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

Enrollment only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-111003 2026-01-13T21:11:43ZHeatherD.Cooper06/07/70UHC-68190-18-7862097832HEATHER.COOPER91@PROTON.ME3206 SPRING STMiamiFL33141GRP-7814CORE-HMO··
ENRENR-1228882026-04-11T12:25:35Z ·patriciaI.··austin08/10/74UHC-85341-11•••-••-3918697-509-4085UNKNOWN829 BROADWAYColumbusOH43210GRP-6680OPTIONS-PPO
ENRENR-1380422026-05-23T20:21:55ZJustin—Sms10/22/1938UHC-97386-84•••-••-5792·613-983-2805justin.sims@aol.com5124 Highland Ave Apt 36··FresnoCA93787GRP-7248CHOICE-PLUS-PPO
ENRENR-1326782026-03-25T13:47:10ZJULIEHLI9/20/1972·UHC-87775-74•••-••-7285674-569-5156JULIE.LI41@HOTMAIL.COM5776 Willow Ct··Los AngelesCA90003GRP-1591CORE-HMO
ENRENR-1305152026-08-08T20:15:33ZRachel—Schmidt1990-01-10UHC-48968-94•••-••-13654023757404RACHEL.SCHMIDT@ICLOUD.COM4772 Sage Court #163SAN ANTONIOtx78254GRP-1340CHOICE-PLUS-PPO
ENRENR-103337 2026-07-15T17:12:08ZSofiaBLiDec 18, 1948UHC-51465-50··•••-••-1440321-358-5049sofia.li@gmail.com1674 RIDGE ROAD··JacksonvilleFL·32294GRP-1949CORE-HMO
ENRENR-1281742026-04-23T01:04:50ZCHRISIJACKSON1958-04-13UHC-69793-47•••-••-8404323-382-5689christopher.jackson@yahoo.com4347 MEADOW LANEAustinTX78768GRP-5651CHOICE-PLUS-PPO
ENRENR-1340982026-04-11T14:33:19ZsarahE.carlson20-02-1943UHC-61080-99•••-••-039116876115975sarah.carlson2@yahoo.com·9655 RIVER ROADGilbertAZ85275-7370GRP-3290SELECT-EPO
ENRENR-1384882026-04-06T23:35:22Zdenise··knight13-01-1979UHC-67464-26—+1 212 836 6084DENISE.KNIGHT96@OUTLOOK.COM2302 Canyon RdPhoenixAZ85008GRP-7505CHOICE-PLUS-PPO
ENRENR-1039662026-08-12T07:43:33ZClark, Dennis——08/01/59UHC-72319-78•••-••-19848089742295UNKNOWN1277 Indian School RoadFresnoCA93731GRP-1038MEDICARE-ADV-A
ENRENR-1314682026-05-08T02:12:23ZKathleenACrawford1964-12-08UHC-91893-76•••-••-5522(425) 682-5536kathleen.crawford@outlook.com6694 Maple AvenueChandlerAZ85283GRP-3853CHOICE-PLUS-PPO··
ENRENR-1286772026-07-30T17:41:04ZCAMILAV··WANG02/18/1964··UHC-11506-03•••-••-6314+1 566 926 0162camila.wang40@gmail.com1186 Elm StSacramentoCalifornia·95806GRP-1133··SELECT-EPO
ENRENR-1019992026-07-10T23:43:51ZBell, JeanE.····2006-05-09UHC-44976-64•••-••-7060939-933-9866N/A5048 PALM DRChandlerAZ85209GRP-1278medicare-adv-a
ENRENR-1135362026-09-30T19:13:48ZAndrewXMcDonald21-08-2000UHC-38489-91•••-••-0776(437) 434-2555andrew.mcdonald44@aol.com···4462 CAMELBACK RDOrlandoFL32836-6267GRP-6366MEDICARE-ADV-A
ENRENR-1383922026-04-21T21:52:34ZIsebellaBJordan27-09-1988UHC-55243-09N/A17465040423—4855 Spring StreetPhoenixAZ85093GRP-6027CHOICE-PLUS-PPO
ENRENR-1351782026-02-25T07:48:02ZLori—Guzman··1/14/1957UHC-40801-21NULL(924) 971-6506lori.guzman26@yahoo.com8493 Washington StSan DiegoCA92122GRP-3934CHOICE-PLUS-PPO
ENRENR-1383502026-03-21T00:33:42ZMartha—Wood1989-02-23uhc-19861-21•••-••-0706(630) 762-6643martha.wood14@aol.com·9595 Bayshore DriveSeattleWA98166GRP-1306medicare-adv-a
ENRENR-1355852026-05-05T11:20:36ZBRANDON—SHAW2007-05-20UHC-41262-36•••-••-8175—-9042 Desert Sky BoulevardCharlotteNC28263GRP-1558CORE-HMO
ENRENR-1212292026-03-03T04:53:10ZRandy—Hunt19900404UHC-06808-42•••-••-7568940-665-3056UNKNOWN5547 Baseline RdHoustonTX77024GRP-6816NAVIGATE-HMO
ENRENR-1076112026-06-13T14:29:01ZSTEPHEN—LEWIS1958-03-04UHC-80754-67•••-••-9001-stephen.lewis26@yahoo.com7899 Church StreetMiamiFlorida33177GRP-5956MEDICARE-ADV-B
ENRENR-130788 2026-05-04T18:27:29ZAlexander—Montgomery0248-19-40UHC7896667··•••-••-26875316762901ALEXANDER.MONTGOMERY94@HOTMAIL.COM6536 Washington StCharlotteNC28230GRP-2802CHOICE-PLUS-PPO
ENRENR-1115902026-02-21T04:50:42ZJean··Q.·Burton2005-12-17UHC-63224-77•••-••-77569776738027jean.burton70@yahoo.com8348 BAYSHORE DRIVEOrlandofl32888GRP-4359CHOICE-PLUS-PPO
ENRENR-1239232026-05-19T14:42:54ZEstrada, DeborahW—·10-03-1991UHC-65814-20•••-••-2501731.852.7594deborah.estrada@icloud.com5054 Park PlaceSan AntonioTX78210GRP-9158MEDICARE-ADV-B
ENRENR-1069042026-05-03T06:03:50Z·WillieIPierce1980-10-02UHC-53272-81N/A(241) 458-7667WILLIE.PIERCE8@HOTMAIL.COM7239 BroadwayNASHVILLETN37230GRP-8817MEDICARE-ADV-B
ENRENR-1011412026-02-06T03:02:47ZJoanI.—1949-03-16NULL-N/Ajoan.lane@outlook.com573 WILLOW COURTPlanoTX75001-8032GRP-1519CHOICE-PLUS-PPO
ENRENR-1144372026-03-05T09:23:37ZRALPHX·STEVENS·1970-01-07UHC-93694-52•••-••-4587+1 248 543 2346RALPH.STEVENS51@PROTON.ME5840 BASELINE ROADSan AntonioTX··78267··GRP-9217MEDICARE-ADV-A
ENRENR-110886 2026-08-19T01:25:40Z·KIMBERLY—SIMMONS2006-06-17UHC-57214-03•••-••-1589(604) 399-2924KIMBERLY.SIMMONS4@YAHOO.COM8328 Baseline RoadFresnoCA93789GRP-3308CHOICE-PLUS-PPO
ENRENR-1077892026-06-12T22:02:15ZLindaBBowman9186-06-20UHC-62137-15•••-••-2860+1 319 841 0592linda.bowman@gmail.com7825 Desert Sky BlvdSan AntonioTX··78204··GRP-1488MEDICARE-ADV-A
ENRENR-1182602026-10-07T22:30:29ZDAVID—NGUYEN1945-01-25UHC-96172-78•••-••-80516198636398david.nguyen11@icloud.com7133 Camelback RdAustinTX78740GRP-9820CHOICE-PLUS-PPO
ENRENR-1161222026-04-16T11:47:36ZJULIEILEWIS1963-30-22·UHC-04157-39•••-••-4641—julie.lewis@icloud.com7632 Church StSeattleWA98167GRP-1591MEDICARE-ADV-A··
ENRENR-1135842026-02-01T13:22:04ZBenjaminLJones1991-05-27UHC-38434-13•••-••-71966846058886benjamin.jones@gmail.com4261 Sunset BoulevardCOLUMBUSOH43263GRP-5075MEDICARE-ADV-B
ENRENR-1244332026-08-25T16:03:02ZSTEPHEN····COX1997-04-01UHC-91227-85•••-••-3021+1 945 330 4929·stephen.cox44@yahoo.com9136 BroadwaySAN ANTONIOTX78208GRP-2912NAVIGATE-HMO
ENRENR-135337 2026-10-02T17:15:16ZCamila—Schmidt1982-02-13··UHC-82888-41•••-••-3168(465) 511-8349·camila.schmidt@aol.com8179 HILLCREST ROADPhoenixAZ85011GRP-4360OPTIONS-PPO
ENRENR-1347952026-09-06T04:38:30ZSantiagoJWright1950-06-07UHC-78314-61•••-••-8198704-640-0571santiago.wright@aol.com·5510 Lincoln WayPHOENIXAZ85073GRP-4730CORE-HMO
ENRENR-1203872026-04-22T05:50:07ZPaul—Little1969-06-22UHC-34102-43•••-••-6456(513) 953-6473·paul.little38@aol.com5292 CENTRAL AVEAtlantaGA30343GRP-2399OPTIONS-PPO
ENRENR-1139012026-08-30T17:38:35ZScott, Jennifer·W—·1990-10-11UHC4308665•••-••-58482703368JENNIFER.SCOTT12@ICLOUD.COM3029 Market StSacramento··CA95839GRP-8764CORE-HMO
ENRENR-1427332026-07-06T10:30:53ZSOFIARGARDNER10/17/2002UHC-36099-78•••-••-9468(961) 851-2797NULL8066 BroadwaySeattleWA98156GRP-7330·CHOICE-PLUS-PPO
ENRENR-1019082026-04-04T02:24:40Zdylan—wang1941-03-06UHC-09762-15•••-••-62362198627734DYLAN.WANG@PROTON.ME7317 SAGE COURTMesaArizona85221GRP-8788CHOICE-PLUS-PPO
ENRENR-1261222026-10-14T07:51:33ZAdamOHughes04/05/1974UHC-67149-60··•••-••-15347572253575adam.hughes@yahoo.com-—UNKNOWN—GRP-6894MEDICARE-ADV-A
ENRENR-1198222026-01-14T20:56:29ZDANIELLEARAMIREZ1966-02-11UHC-72750-13•••-••-7175759-917-8217danielle.ramirez47@icloud.com·8031 SPRING STREETMIAMIFL33107GRP-4294MEDICARE-ADV-B
ENRENR-1327642026-02-17T13:34:35ZTerryDWatson··19441106UHC-66989-30•••-••-40929459152615—706 FOREST AVENUE··San DiegoCA92144GRP-9055CHOICE-PLUS-PPO
ENRENR-1321002026-06-12T18:46:56Z·Rose, BrandonM—05/22/1976UHC-85159-64•••-••-750312436368592brandon.rose70@proton.me1264 Valley View DrTucsonArizona85764GRP-3435CORE-HMO
ENRENR-1000222026-02-25T19:34:40ZRaymond—Walsh19511103UHC-09175-90•••-••-7458+1 646 319 9468·raymond.walsh91@outlook.com764 BASELINE ROADSEATTLEWA98198GRP-7045··CHOICE-PLUS-PPO
ENRENR-1136322026-03-20T06:31:44ZMasonH.ChenSep 21, 1982uhc-68233-59•••-••-937117104003271mason.chen@gmail.com9569 CANYON RDSan AntonioTX78240GRP-2610··options-ppo
ENRENR-1018402026-09-11T10:25:17ZAmandaMDaniels18-08-1938uhc-10897-78•••-••-65645889986572amanda.daniels19@yahoo.com8322 Sage CourtNASHVILLETennessee··37216-9291GRP-0808MEDICARE-ADV-B
ENRENR-1157302026-09-01T02:30:19ZJanet—Sulllivan11/13/64UHC-57981-28•••-••-47793934903035N/A1756 Lake View RdPhoenixAZ85039GRP-5948OPTIONS-PPO
ENRENR-1156662026-05-30T12:02:13ZJoseX.Johnson7/10/1982-•••-••-72266836489848jose.johnson@hotmail.com791 Maple AveLAS VEGASNevada89182GRP-2856choice-plus-ppo
ENRENR-1052412026-05-13T13:44:39ZCHRISTIAN··LFERGUSON1978-09-04UHC-73339-50•••-••-4178(628) 358-7707christian.ferguson3@proton.me6291 RIDGE ROAD Apt 9··AustinTX—GRP-9352CORE-HMO
ENRENR-1299202026-01-13T19:12:00Z·Aguilar, RuthK—07/04/1995UHC-73106-42•••-••-6144·6329985888ruth.aguilar19@yahoo.com7008 CEDAR LANE·MESAAZ85207GRP-1207MEDICARE-ADV-A
ENRENR-1166992026-09-16T15:22:53ZRANDYF.DIXON1991-08-06UHC-17679-69N/A8345020074—6924 Willow CourtAtlantaGA30381··GRP-6791NAVIGATE-HMO
43,101 rows, page 33 of 863PreviousNext

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:34.793Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty