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-1022802026-09-08T07:48:15ZBradleyURice··02/21/1975UHC-56784-20•••-••-1646347-898-6423BRADLEY.RICE69@PROTON.ME5761 Meadow Lane··TempeAZ85277GRP-6853·NAVIGATE-HMO
ENRENR-1083292026-08-01T16:35:13ZVirginiaGCarter9158-06-24UHC-07463-33•••-••-969218418984941virginia.carter83@hotmail.com9246 Lake View RdMinneapolisMinnesota··55485-4420GRP-2355CORE-HMO
ENRENR-1326002026-06-19T17:28:07ZMARIA—·RAMOS1993-08-27··UHC1570144•••-••-3328+1 930 772 1896maria.ramos@icloud.com1825 Pine DrCOLUMBUSOH43231··GRP-0219select-epo
ENRENR-1360922026-03-23T16:52:10ZJudy—Price04-04-1995UHC-95781-13•••-••-5508716-540-2635JUDY.PRICE@YAHOO.COM3123 PALM DRIVE #976LAS VEGASNV89147GRP-2417MEDICARE-ADV-B
ENRENR-1279242026-08-15T20:54:24ZAmyYHamilton1957-11-14UHC-90488-46•••-••-57467488178584AMY.HAMILTON50@PROTON.ME6489 RIVER RDGilbertAZ85229GRP-5897CORE-HMO
ENRENR-1361852026-07-19T12:49:48ZRichardIPeters14-07-1949UHC8574009•••-••-8506+1 241 231 1818richard.peters@yahoo.com··8617 Central AveMINNEAPOLISMN·55418GRP-8744SELECT-EPO
ENRENR-1396602026-04-25T19:44:48ZTorres, DonnaP.—1957-03-17UHC-62265-92•••-••-5304687.810.2635·donna.torres14@gmail.com2673 Park PlTempeAZ85267GRP-1305NAVIGATE-HMO
ENRENR-1339522026-05-08T12:58:41ZdebC.day19730811UHC-27341-20N/A(711) 676-3156—6113 Camelback RdHouston·TX77000GRP-6407··OPTIONS-PPO
ENRENR-1055332026-06-26T21:31:11ZAnna—Willis1963-11-06UHC-02375-50•••-••-5933(769) 547-2625N/A7346 Grand AvenueSEATTLEWashington98119GRP-4661MEDICARE-ADV-B
ENRENR-1182102026-07-20T03:33:20Zjesssica··Gperez15-02-1997UHC-75199-96•••-••-0872·(891) 713-3214jessica.perez83@hotmail.com9284 Willow CourtDallasTexas75277GRP-6946SELECT-EPO
ENRENR-1385782026-09-19T00:10:54ZAmberC.Bishop1950-04-19N/A-(205) 229-3003AMBER.BISHOP1@PROTON.ME5736 Sage CtDallasTX··75236··GRP-2385navigate-hmo
ENRENR-1197762026-05-06T03:48:01Z THOMAS—PEREZMay 23, 1975UHC-80680-30•••-••-25148127877thomas.perez26@aol.com2001 Park Pl #105GlendaleAZ85314GRP-4221·CHOICE-PLUS-PPO
ENRENR-1052622026-08-13T05:54:16ZJudy—Gomez1977-08-18UHC-18172-29•••-••-3182(940) 250-4971judy.gomez2@hotmail.com8411 Canyon Rd··Orlandofl32840-0168GRP-2678CHOICE-PLUS-PPO
ENRENR-1410252026-07-17T09:50:02ZkathrynPwatkins19570314·UHC-05724-67··343-452-5990kathryn.watkins20@aol.com2121 Union StreetNashvilleTN37261GRP-4103··MEDICARE-ADV-B
ENRENR-1099702026-08-23T18:24:21ZNOAH—MARTINEZ1/7/1971UHC-54843-07•••-••-32595695071780NOAH.MARTINEZ@YAHOO.COM9722 Union StreetLos AngelesCA90097-9137·GRP-3623OPTIONS-PPO
ENRENR-1026482026-01-13T10:27:55ZJackN.Sanchez···1979-09-16UHC6280189•••-••-861316739817625jack.sanchez95@hotmail.com5240 UNION STChandlerAZ—·GRP-8445CORE-HMO
ENRENR-1009922026-08-02T06:49:07ZMegan B—Delgado4/12/1972UHC-66630-74•••-••-3856UNKNOWNmegan.delgado@yahoo.com9891 Baseline Rd Apt 28ChandlerArizona·85258GRP-6438MEDICARE-ADV-A
ENRENR-1028462026-08-04T18:23:07ZJulia—Morales01-12-1960UHC-40277-59•••-••-4521UNKNOWNjulia.morales@proton.me5891 Harbor BlvdMinneapolis·MN55482GRP-3987CHOICE-PLUS-PPO
ENRENR-1207262026-10-11T17:46:15ZDONG··MURRAY2001-12-17·UHC-38778-25•••-••-29847513713750donald.murray@gmail.com7821 Lincoln WaySacramentoCA·95825GRP-5258CHOICE-PLUS-PPO
ENRENR-1372772026-03-25T13:38:19ZCamilaXHillJun 27, 1967UHC-12011-96•••-••-5524404-341-5428UNKNOWN8268 Broadway·Los AngelesCA··—GRP-2825MEDICARE-ADV-A
ENRENR-1287252026-02-13T08:17:51ZKIMBERLYMJAMES07/23/02UHC-59619-33•••-••-7626(268) 978-9008null1599 HILLCREST ROADSeattleWA98161-2845·GRP-2518·OPTIONS-PPO
ENRENR-1371742026-09-24T04:43:03ZValentinaR.Greene1961-04-03UHC9226247•••-••-3099508-895-7041valentina.greene@icloud.com212 SUNSET BOULEVARDGilbertAZ85271GRP-3166SELECT-EPO
ENRENR-1213592026-06-07T10:47:24ZAngelaEDay1959-04-07UHC-82108-67—242.629.0831—41 Indian School RdHoustonTX77018GRP-1678MEDICARE-ADV-B
ENRENR-1120222026-08-05T09:34:39ZJanice··Marshall19520907··UHC-92674-04•••-••-5180650.920.3588janice.marshall90@outlook.com··2157 HIGHLAND AVENUE Apt 24SCOTTSDALEAZ85251GRP-9445SELECT-EPO
ENR ENR-1395272026-03-08T12:07:40ZMurphy, KellyA—10/07/1948UHC-06629-57•••-••-0281(244) 819-4486kelly.murphy29@aol.com7420 Maple AveLas VegasNV··89142GRP-0266MEDICARE-ADV-A
ENRENR-1275302026-09-22T23:15:27ZHANNAHFKELLEY··Apr 2, 1965··UHC-51043-32•••-••-875619588503503HANNAH.KELLEY@YAHOO.COM1591 BROADWAY #934ColumbusOH43275GRP-1163·SELECT-EPO
ENRENR-1122622026-09-02T15:27:33ZJordan—·Baker1990-11-22UHC-78101-68•••-••-4167(821) 493-4284UNKNOWN4551 BroadwayTucsonAZ85779-7858··GRP-5299OPTIONS-PPO
ENRENR-1075342026-07-15T22:17:10ZLaurenEHenry1957-02-15UHC-78612-29•••-••-2310-····6133 Lake View RoadTempeAZ85261GRP-5072NAVIGATE-HMO
ENRENR-1224152026-08-10T08:10:49ZSteven—Anderson21-10-1980UHC-73679-17•••-••-3337+1 526 592 2271null5988 LINCOLN WAYTampa·FL33683··GRP-2066OPTIONS-PPO
ENRENR-1164912026-05-20T08:58:18ZJonathanB.ParkerSep 7, 1952UHC-53297-26•••-••-5012+1 646 649 8212JONATHAN.PARKER58@GMAIL.COM8769 Lincoln WaySEATTLEWAUNKNOWNGRP-5255MEDICARE-ADV-B
ENRENR-1426472026-09-26T08:50:09ZLUCIAJCASTILOL1989-12-02UHC-03398-73•••-••-5515(922) 964-7888lucia.castillo@icloud.com413 OCEAN AVENUEMiamiFLUNKNOWNGRP-7232MEDICARE-ADV-A
ENRENR-1281712026-02-05T01:21:05ZSofia—Hudson2007-06-12UHC-81130-33•••-••-81468067668250N/A··1523 Forest AvePlanoTX75026GRP-4071SELECT-EPO
ENRENR-1277302026-01-18T21:43:51ZKathrynL.Gutierrez1171-20-00UHC-77738-19N/A285-333-3842NULL1505 PALM DRIVEAustinTXnullGRP-9052OPTIONS-PPO
ENRENR-1257052026-07-07T14:14:00ZFerguson, Philip——1991-08-28UHC-35676-88•••-••-5834·(348) 267-0324philip.ferguson74@proton.me8340 DESERT SKY BLVDTucsonAZ··85709-1735GRP-7612OPTIONS-PPO
ENRENR-1033702026-08-21T20:02:33Z GloriaFWashington6/22/1944UHC-94993-03—+1 538 817 3999gloria.washington@yahoo.com3544 Washington StreetMIAMIFL33114GRP-9890SELECT-EPO
ENRENR-1006132026-06-20T13:16:00ZSusan—RobertsonN/A·UHC8728175•••-••-9728971-754-3482—2352 Willow CtHOUSTONTX77049GRP-9237CHOICE-PLUS-PPO
ENRENR-1055842026-04-06T01:00:30ZnancyYsilva1938-11-11UHC9178324•••-••-1837(380) 373-9297··null3546 RIDGE RDCHARLOTTENC28268GRP-5322MEDICARE-ADV-A
ENRENR-1273022026-01-07T23:49:49Zcheryl—woods05/03/1941UHC-59069-87•••-••-53757933716474cheryl.woods49@hotmail.com3117 Union StPlanoTX75005GRP-1429MEDICARE-ADV-A
ENRENR-1357142026-01-09T00:09:55ZSCOTT—ROGERS19670424UHC-44575-22•••-••-5162·447-538-5483SCOTT.ROGERS4@GMAIL.COM1447 OAK STLos AngelesCA90097GRP-2046OPTIONS-PPO
ENRENR-1415842026-10-10T18:05:24ZcamilaJprice1972-05-11UHC-50192-84•••-••-7580—-6672 Canyon RdNASHVILLETN37270GRP-8836CORE-HMO
ENRENR-1017112026-01-02T06:41:44ZSanders, Adam··—·1998-12-16UHC-10599-86•••-••-6699901-396-8821-8671 Valley View DrFresnoCA·93713GRP-4914SELECT-EPO··
ENRENR-1287482026-09-07T22:37:27ZEmmaR·Castillo1946-04-21UHC-53809-28•••-••-3950(890) 703-2515emma.castillo45@aol.com·2824 Park PlaceGlendaleAZ85351GRP-7162OPTIONS-PPO
ENRENR-108014 2026-03-27T16:30:33ZBobbyU.Rojas1945-05-20UHC-53291-78•••-••-58105359582762bobby.rojas@gmail.com2796 Hillcrest RdOrlandoFL32805-9520···GRP-7859CORE-HMO
ENR ENR-1176442026-07-29T03:42:56ZNick—BrownFeb 20, 1953UHC-28244-03·null7545954577null358 Lincoln WayMiamiFL33139GRP-5437SELECT-EPO
ENRENR-1210952026-10-01T04:13:22ZLISA·P.PRICE1959-02-08UHC-84631-05•••-••-0111(539) 213-2792lisa.price24@proton.me4157 SAGE COURT···FresnoCA93731GRP-1457CORE-HMO
ENRENR-1138502026-02-28T21:36:47ZJoe—Green1980-10-16UHC-41373-96•••-••-7897-joe.green52@proton.me·3650 Union StreetFRESNOCA93785-0877GRP-6472NAVIGATE-HMO
ENRENR-121030 2026-05-13T00:46:06ZLOGAN—RIVERA1976-05-01UHC-27810-95•••-••-3439·17747795587logan.rivera58@proton.me8658 ELM STPHOENIXAZ85060GRP-8412CHOICE-PLUS-PPO
ENRENR-1221302026-09-06T07:51:13ZSusanA··Herrera1977-09-13uhc-51841-46··•••-••-482819422196219SUSAN.HERRERA@GMAIL.COM6558 PARK PLACEAustinTX78751GRP-0309CHOICE-PLUS-PPO
ENRENR-1136152026-01-28T16:36:15ZJackNJohnston1941-03-21··UHC3905441··•••-••-6101(427) 343-9445jack.johnston39@hotmail.com·217 Ridge RdAustinTX78720-3088GRP-7320OPTIONS-PPO
ENRENR-1072942026-05-03T09:07:46ZAhmed—Welch09/19/1986UHC-38427-46•••-••-9170377-373-0239ahmed.welch@proton.me·8895 Main StreetDENVERCO80243GRP-6781MEDICARE-ADV-B
43,101 rows, page 262 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:43.416Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty