Raw sources

Raw sources (bronze)

Rows from every feed, stored exactly as received. Normalisation happens in the silver layer, where each change is flagged.

ENREnrollment
43,101
raw rows
Usable
42,871
Flagged
84%
No member ID
2%
Linked
29,405
First seen
2026-01-01
Last seen
2026-10-18
CLMClaims
32,829
raw rows
Usable
32,674
Flagged
74%
No member ID
35%
Linked
30,209
First seen
2026-01-01
Last seen
2026-10-18
TPAThird-party administrator
14,474
raw rows
Usable
14,404
Flagged
77%
No member ID
85%
Linked
11,671
First seen
2026-01-01
Last seen
2026-10-18
PRVProvider network
9,596
raw rows
Usable
9,546
Flagged
80%
No member ID
50%
Linked
8,676
First seen
2026-01-01
Last seen
2026-10-18

Raw events

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1382892026-06-22T05:38:32ZNoahDGeorge··1956-09-22UHC-49449-53•••-••-9873720-912-1097N/A2933 Pine Drive Apt 31Las VegasNV89197GRP-1857MEDICARE-ADV-A··
ENRENR-1415942026-03-29T19:01:25ZDOROTHY—RUSSELL1990-09-17UHC9962504•••-••-9024-dorothy.russell9@outlook.com9373 Spring StMesa··AZ85208GRP-9816choice-plus-ppo··
ENRENR-1129622026-06-17T13:45:59ZAnn—Ferguson2050-06-16UHC-90827-12•••-••-8830(459) 743-7797ann.ferguson41@aol.com2004 PINE DRScottsdaleAZ85208GRP-4466NAVIGATE-HMO
ENRENR-1430342026-09-24T02:45:37ZDavidK·PerryUNKNOWNUHC-81654-23•••-••-46435179320743david.perry@proton.me1212 Oak St Apt 26Los AngelesCA90009GRP-6304OPTIONS-PPO
ENRENR-1221312026-06-08T05:49:26ZSUSAN—HERRERA1977-09-13UHC-51841-46··•••-••-4828942-219-6219susan.herrera@gmail.com6558 PARK PL·AustinTX78751GRP-0309··CHOICE-PLUS-PPO
CLMCLM-4066672026-04-25T14:45:55ZRandy··Lawrence1981-01-02UHC-90741-18•••-••-2866NULLrandy.lawrence@proton.me8287 Highland AveGlendale·AZ—GRP-2674MEDICARE-ADV-A
ENRENR-109303 2026-08-03T21:36:35ZGerald—Kennedy10-03-1977UHC-54614-81•••-••-1526(385) 806-0050GERALD.KENNEDY72@ICLOUD.COM6525 Camelback RoadORLANDOFL32885GRP-8665CHOICE-PLUS-PPO
ENRENR-1262652026-06-19T11:18:42ZMateoSDiaz··1952-06-25UHC-92907-25•••-••-221715253721839—2968 Apache Boulevard #166HOUSTONtx77085GRP-1621MEDICARE-ADV-A
TPATPA-602602026-02-04T03:52:59ZEVELYN—PALMER01/03/56UNKNOWN•••-••-7223null—2570 Lake View RoadFRESNOCA93770GRP-2603—
CLMCLM-4004522026-09-20T11:58:30ZMargaret—·Chavez·3/19/1951UHC-92419-11•••-••-6659875.661.0430—nullnull—NULLGRP-0692MEDICARE-ADV-B
ENRENR-1372432026-04-19T23:00:54ZJosh—Munoz··2003-01-12UHC-13562-40··•••-••-9996(840) 964-7411joshua.munoz@hotmail.com5125 Park Place··SeattleWA98119GRP-3490CORE-HMO
CLMCLM-4116322026-05-22T14:26:49ZChris··Baker1978-06-18UHC-00876-55null(975) 880-6941··8288 Sunset BlvdFRESNOCA·93747—MEDICARE-ADV-A
ENRENR-1405582026-05-12T10:29:43Zpat····ruizSep 23, 1953UHC-33799-24•••-••-2331nullN/A5562 Desert Sky BoulevardAustinTX78768GRP-2609SELECT-EPO
ENRENR-1371052026-01-30T16:24:51Zjessica··—carroll6/12/1942UHC-09268-29•••-••-143615033331504jessica.carroll62@gmail.com9859 Sage Ct Apt 29JacksonvilleFL32206GRP-2629CHOICE-PLUS-PPO
PRVPRV-227652026-08-19T02:41:47ZBOBBY—PERZ02/16/2005····•••-••-6135(667) 727-6081bobby.perez68@aol.com669 RIDGE RDPlanoTX—UNKNOWN—
ENR ENR-1281722026-05-05T13:43:14ZMariaQGarcia10-09-1981UHC-26872-43•••-••-6206628-771-4238MARIA.GARCIA@GMAIL.COM3787 Mountain View DrHoustonTX77048··GRP-7001select-epo
ENRENR-1057102026-02-17T11:54:22ZMarianaSDelgado1989-10-06UHC-41386-07N/A882-658-8091mariana.delgado@icloud.com516 Maple AvenueORLANDOfl32818GRP-1743··SELECT-EPO
TPATPA-577952026-07-15T16:43:03ZCARLUS—MCCOY1981-10-23nullnull—N/A4191 Grand Avenue·PlanoTX··75061—N/A
CLMCLM-4260362026-01-04T15:21:47ZMELISSA—HICKS1954-01-18UHC-05893-60•••-••-229317853754493-8011 Central AveTempeAZ85266N/ANAVIGATE-HMO
CLMCLM-4289262026-10-16T04:52:04ZBell, Kimberly··—2003-09-01NULLnull597-903-3704—3424 Central AvenueTempeAZnullGRP-6745N/A
CLMCLM-4167842026-08-04T05:14:13ZCheryl—Butler··1997-02-05··UHC-37634-84N/ANULL·UNKNOWN5797 CEDAR LANEOrlandoFL32848GRP-4327··MEDICARE-ADV-B
ENRENR-1190962026-05-17T15:19:35ZBRANDON·ATORRES1955-11-27UHC-26652-20-286-887-4840······4878 Canyon RoadChandlerAZ85267GRP-4644MEDICARE-ADV-B··
TPATPA-540112026-09-15T08:56:55ZEMMA—ROBERTSON1974-03-04NULL——UNKNOWN·434 PINE DRTempeAZ85242null·NULL
CLMCLM-4159762026-01-03T04:57:39ZMegan··—Burton19-12-1962UHC-70543-77•••-••-4525··NULL———UNKNOWNGRP-1139OPTIONS-PPO
CLMCLM-4298562026-05-27T17:10:57ZAustin, Kyle··—1987-03-04·UHC-55692-22•••-••-7343UNKNOWNkyle.austin61@outlook.com·8976 Spring St Apt 11AtlantaGA··30387GRP-1921NULL
TPATPA-585272026-04-07T07:00:57Z ·madison—knight02/05/1984UNKNOWN··•••-••-1242N/ANULL8677 Baseline Road Apt 37AtlantaGA30319N/A·CHOICE-PLUS-PPO
CLMCLM-4169772026-05-13T00:23:55ZMARK—·CONTRERAS6/5/1994uhc-18319-57—(365) 335-9957UNKNOWN7677 Indian School RdSACRAMENTOCA95831GRP-4070CORE-HMO
CLMCLM-4153942026-04-27T23:10:23ZStephens, Kathryn——1977-02-28UHC-35933-47•••-••-828517965411367NULL9830 SAGE COURT #552·SeattleWashington98147—MEDICARE-ADV-B
CLMCLM-4208522026-03-08T10:25:44ZJean—Espinoza1942-05-24——(489) 314-1789—3118 JEFFERSON AVEJacksonvilleFlorida32261··GRP-4864—
CLMCLM-4311082026-03-21T09:05:50ZJEAN—MCCOY1936-12-09-•••-••-449615507371454null343 Maple AvenueTampafl33600GRP-2063—
ENRENR-1189962026-06-15T01:48:37Z Nicole—Banks1996-12-26UHC-03903-87•••-••-319415514045899nicole.banks@gmail.com2517 Mountain View DrMesaAZ85200GRP-5995CORE-HMO
CLMCLM-4136762026-09-07T03:05:08ZWEI—COOPER10/26/1980UHC-59412-04-—UNKNOWN--————
CLMCLM-4006342026-04-25T20:26:00ZBrian—Cole··1960-09-26null•••-••-6165(824) 714-8547—8635 MARKET STMiamiFL33182GRP-6276options-ppo
ENRENR-1284732026-01-27T13:05:33Zhelen—henry1950-07-05UHC-47591-64•••-••-330516467528838NULL588 Central AvenueLOS ANGELESCA90092GRP-2044OPTIONS-PPO
TPATPA-596492026-09-13T01:35:02Z sean··—chenMar 10, 1972——748-889-0655UNKNOWN376 Apache BlvdTampaFL33632-2403nullN/A
ENRENR-1296802026-05-16T07:23:55ZGary··Myers··1981-04-13UHC-24954-02—(529) 223-9926—5636 Ridge RdFRESNOCalifornia··93701GRP-6479SELECT-EPO
CLMCLM-4111882026-07-25T07:57:29ZJOHNNY—GOMEZ1958-03-19UHC-49320-75UNKNOWN+1 535 463 0642john.gomez@gmail.com5201 Park PlOrlandoFL32873nullNULL
ENRENR-1335422026-04-13T09:37:58ZLoganRGibson1961-12-08UHC-11992-08•••-••-6618554-902-5162N/A5444 Union StreetSacramentoCA95815GRP-6159SELECT-EPO
CLMCLM-4151342026-06-19T15:48:58ZMargaretMCox19950201UHC-24171-72null7206292101UNKNOWNUNKNOWN····N/AN/AGRP-2141UNKNOWN
PRVPRV-206702026-02-18T12:06:47Z·McCoy, Gregory——1942-05-15——·(518) 279-0967null8994 Lake View RdNashville·TN37293—NULL
ENRENR-1209722026-10-14T20:28:06ZRussell·UJimenez26-08-1972UHC-20971-83•••-••-3723331-714-0263russell.jimenez64@aol.com8370 Harbor BlvdATLANTA··GA—GRP-7029CORE-HMO
ENRENR-1163462026-04-26T09:53:48Z Jason S.—Wang1998-11-22UHC-62361-29•••-••-53478538654878··jason.wang@gmail.com6287 Washington Street··HOUSTON·TX77024··GRP-5261CHOICE-PLUS-PPO
CLMCLM-4205592026-07-28T04:32:20ZFerguson, Nancy··—19710410——19894813491null664 Grand AvenueAtlantaga30319UNKNOWNCHOICE-PLUS-PPO
ENRENR-1017952026-03-17T20:24:01Z kaylaV.mendez20-11-2006·UHC-70644-98•••-••-08268705351750—9792 MEADOW LNSan AntonioTX78217·GRP-4879NAVIGATE-HMO
CLMCLM-4038082026-01-13T08:09:02ZVINCENT—ESPINOZA···1980-01-11uhc-29654-36•••-••-2767NULLNULL3999 Church St··Las VegasNV89101GRP-9531NAVIGATE-HMO··
CLMCLM-4303352026-02-28T01:02:34Z·DiegoH··Contreras23-02-1948UHC-46032-06UNKNOWN5944815555DIEGO.CONTRERAS@PROTON.ME2310 Forest AveEDEN PRAIRIEMN—-MEDICARE-ADV-A··
CLMCLM-4099602026-07-17T17:38:11ZTaylor, Kyle——2006-05-28UHC-63974-95—703.951.3758kyle.taylor73@aol.com·8390 MARKET STTampaFLUNKNOWN—null
CLMCLM-4323072026-01-15T11:11:18ZKayla—Valdez23-05-1938·····nullnull·NULL8475 LINCOLN WAYChandlerAZ85247N/Anull
ENRENR-1186382026-03-04T21:48:07ZDANIELLEVADREWS2006-04-02UHC-00916-15•••-••-8618(588) 832-8982DANIELLE.ANDREWS@AOL.COM621 LINCOLN WAY···ScottsdaleAZ85265GRP-0583OPTIONS-PPO
CLMCLM-4261682026-06-04T03:02:23ZKayla—Yeng1952-06-07UHC-08889-57N/A——null——UNKNOWNGRP-6014—
100,000 rows, page 104 of 2,000PreviousNext

Bronze layer rules

What is guaranteed for downstream layers

  • As received
    Values are stored exactly as the feed delivered them, including whitespace, inconsistent casing and placeholder tokens such as NULL or N/A.
  • No transformation
    Bronze is never edited in place. Every fix lives in silver and is traceable back here by record ID.
  • Line number preserved
    The line number records each row's position in the source file, so a value can be located in the original extract.
  • Load timestamp
    The load timestamp marks when the row landed in the lakehouse; this batch landed 2026-10-22T12:42:36.678Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty