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-1402672026-02-27T08:26:08Z LisaXWatkins11/3/2004UHC-54169-63•••-••-4975251.660.0742LISA.WATKINS@OUTLOOK.COM··7669 Central AvenueSan AntonioTX·78246GRP-3448CORE-HMO
ENRENR-1151552026-08-04T08:22:40Zmichelle—hudon·Aug 23, 1939UHC-39161-56——MICHELLE.HUDSON@AOL.COM3593 Main StreetLOS ANGELES··ca90017GRP-1978NAVIGATE-HMO
ENRENR-1125282026-01-22T04:47:30ZamandaTnunez1973-09-04UHC-71122-93•••-••-2916569-666-9380amanda.nunez@hotmail.com9286 GRAND AVEFresnoCA93764GRP-0104CORE-HMO
ENRENR-1056712026-08-25T21:16:25ZChristinaA.Soto04/18/1990UHC-05302-85•••-••-5862nullN/A··6040 Harbor BoulevardCharlotteNC28292GRP-9842NAVIGATE-HMO
ENRENR-1055582026-07-05T15:04:03ZLori—McCoy06/18/80UHC-65472-29•••-••-8492459-579-5584—1974 Cedar LnMiamiFL33123GRP-7911NAVIGATE-HMO
ENRENR-1008402026-06-23T06:33:17ZSCOTTNELLIS12/4/1975UHC-48686-39•••-••-3525299-200-8798·-1689 Main St Apt 12San DiegoCA92199GRP-7486CHOICE-PLUS-PPO
ENRENR-1063552026-03-07T14:46:21Z ·Steve·P.Estrada19401015uhc-77984-19—8139704382steven.estrada@yahoo.com6415 Baseline Road··HoustonTX-GRP-1401SELECT-EPO
ENRENR-1283052026-01-04T23:47:23ZHayes, Laura——1982-02-12UHC-18951-39•••-••-10258847645031laura.hayes@gmail.com8992 Canyon RdMINNEAPOLIS··MN··55454GRP-4298··SELECT-EPO
ENRENR-1166582026-02-23T20:18:16ZJONATHANS··KELLY3/21/1966UHC-66694-50•••-••-87403063168699jonathan.kelly16@gmail.com8337 Central AvenueTampaFL33611GRP-0383CORE-HMO
ENRENR-1261362026-07-12T04:38:19ZELIZABETHVSPECNER01/14/89UHC1046732•••-••-7627317-523-9732ELIZABETH.SPENCER54@ICLOUD.COM6879 Willow CtLos AngelesCA90062-5806GRP-9300···CORE-HMO
ENRENR-1043842026-05-21T08:29:57ZBrandon—Burke18-12-1978UHC-96135-51•••-••-2860218-982-4790brandon.burke@outlook.com7916 Meadow Lane··GilbertAZ85271GRP-0548OPTIONS-PPO
ENRENR-1186552026-06-17T14:11:42ZKAYLA···ALVAREZ1965-02-05UHC-80479-03•••-••-7175(201) 397-0498N/A2707 Church StreetSeattle··WA····GRP-8479MEDICARE-ADV-B
ENRENR-1031082026-01-24T11:12:51ZSims, GloriaB.—19941026UHC-87592-87•••-••-1133+1 673 918 3266gloria.sims@hotmail.com1671 Grand AveGlendaleAZ85310GRP-2270SELECT-EPO
ENRENR-1159152026-03-23T13:08:52ZEVELYNJGARDNER1992-09-28UHC-73149-18UNKNOWN932.635.0746EVELYN.GARDNER@OUTLOOK.COM3445 Mountain View DrMesaAZ85250GRP-3365MEDICARE-ADV-B
ENR ENR-1187992026-06-01T00:48:35ZSARAHT·TUCKERMar 6, 1998UHC-97286-29•••-••-9043·null—3680 Central AvePhoenixAZ85036GRP-8316··MEDICARE-ADV-A
ENRENR-1306982026-01-14T20:55:57ZMaryP.Patel··8/12/1985UHC-02629-56•••-••-45995106015184MARY.PATEL88@PROTON.ME9591 Sunset BoulevardMesa·AZ85244GRP-3482CORE-HMO
ENRENR-1112092026-08-05T08:49:38Zalexander—·carter1996-01-15UHC-35056-20•••-••-0810361-545-7298NULL8565 LAKE VIEW ROADAustinTX··78764GRP-4293·MEDICARE-ADV-A
ENRENR-1334222026-06-30T03:47:38ZSophia—Foster·1939-02-09UHC-38274-57•••-••-91839839074273sophia.foster24@gmail.com7330 Canyon RoadNashvilleTN37241GRP-2219CORE-HMO··
ENRENR-1377252026-06-26T06:25:39ZGabriel·WSandersMay 23, 2006UHC-13138-62•••-••-1019(964) 593-9670—1842 Broadway #779JacksonvilleFL32249GRP-6557NAVIGATE-HMO
ENRENR-1229772026-01-09T14:30:59ZVicky·QHamilton1974-09-06UHC-20657-68•••-••-332715389913492VICTORIA.HAMILTON@PROTON.ME1611 SPRING STREETLas VegasNevada89162···GRP-3748CHOICE-PLUS-PPO
ENRENR-1123202026-07-29T18:01:09ZSchmidt, BeverlyG—03/21/93UHC-13118-62•••-••-7621899-659-3510·beverly.schmidt34@proton.me·2192 Lake View RdOrlando··FL—GRP-4127MEDICARE-ADV-B
ENRENR-1400072026-08-09T18:00:20ZVINCENT—DELGADO1960-02-12UHC-58815-25··•••-••-641617402126774vincent.delgado39@aol.com5442 Sunset BlvdMiami·FL—GRP-4598SELECT-EPO
ENRENR-140743 2026-09-10T13:29:03ZDiegoJ.BerryApr 6, 1949UHC-56283-01—466-253-3984null4290 Jefferson AveAustinTX78741··GRP-3822MEDICARE-ADV-A
ENRENR-1189212026-05-25T22:25:46ZDOUGLAS—MENDEZ11-12-1947UHC-96845-13•••-••-5864-douglas.mendez66@aol.com5921 Washington Street··Miami··FL33188GRP-9992NAVIGATE-HMO
ENRENR-1073872026-10-16T04:41:19ZGibson, Jeremy—··19850420UHC-48164-51•••-••-6465+1 472 355 1739jeremy.gibson5@proton.me6980 VALLEY VIEW DRIVENashvilletn37205··GRP-5307OPTIONS-PPO
ENRENR-1097952026-05-12T14:11:30ZbettyFlawson1956-10-10UHC-82127-13•••-••-38782256032982betty.lawson@yahoo.com3519 BroadwayCharlotteNC··28227GRP-8145NAVIGATE-HMO
ENRENR-1244382026-09-16T02:38:48ZVincentY.Lawson1948-08-14UHC-80113-26•••-••-8905477-263-3322UNKNOWN9354 GRAND AVENUEAustinTX78737GRP-3935MEDICARE-ADV-B
ENRENR-1006682026-06-22T20:50:21ZCHRISTINE—SIMPSON1941-04-10··UHC-03299-46•••-••-7350(454) 624-8511-·5334 Jefferson AvenueTEMPEAZ85280GRP-9525MEDICARE-ADV-B
ENRENR-1326172026-01-03T12:25:04ZChristian··Long··1988-11-01UHC-14914-29•••-••-437213084903750N/A4884 Union StSACRAMENTO··CA95825·GRP-0908OPTIONS-PPO
ENRENR-1149452026-02-25T20:44:48ZJULIEIVAZQUEZ1977-08-16UHC-26940-05•••-••-7399(217) 816-8733JULIE.VAZQUEZ50@ICLOUD.COM965 Ocean AvenueScottsdaleAZ85242GRP-4459CORE-HMO
ENRENR-1265822026-03-23T20:10:20ZKILEMMOORE03/11/84UHC1885678•••-••-101217619379297null870 Indian School RdORLANDOFL32805GRP-3750MEDICARE-ADV-B
ENRENR-1182262026-05-14T06:13:33ZSCOTTZ.RICHARDSJan 23, 1991UHC-45156-18•••-••-0655(874) 794-6288NULL4546 Oak StreetNashvilleTN·37202GRP-2112CORE-HMO
ENRENR-1357402026-03-21T18:37:00ZDebra—Campbel1985-06-08UHC-83937-54•••-••-7940(709) 682-3811debra.campbell@yahoo.com3827 Spring StreetLos AngelesCA90081GRP-3150CHOICE-PLUS-PPO
ENRENR-1335612026-09-14T16:32:22ZJack—Kennedy1955-01-34UHC-82804-57•••-••-5682(811) 980-3553JACK.KENNEDY@PROTON.ME1930 Valley View DrOrlandoFL32880GRP-5840OPTIONS-PPO
ENRENR-1256492026-03-27T10:19:12ZHaroldCPetersonJul 3, 1987UHC-35736-34··•••-••-7048+1 675 648 0028UNKNOWN6134 Baseline RoadJacksonvilleFL32259GRP-3718OPTIONS-PPO
ENRENR-1121482026-10-18T09:25:55ZNick—Patterson1974-12-05··UHC-35022-20•••-••-17119733221182··NICHOLAS.PATTERSON7@YAHOO.COM9852 Washington St #446··TempeAZ85259GRP-9384select-epo
ENRENR-1099942026-08-01T22:46:41ZLINDA·QKELLEY04/15/77UHC-65744-09•••-••-1827934-259-3909LINDA.KELLEY@YAHOO.COM6434 WASHINGTON STREETLas VegasNV89155GRP-6177MEDICARE-ADV-B
ENR ENR-1007682026-05-30T11:50:47ZJANICCE····KELLEY1960-05-25UHC-15572-90—4836541592janice.kelley@yahoo.com5743 PINE DRLos AngelesCalifornia—GRP-9977··MEDICARE-ADV-B
ENRENR-1099902026-01-21T13:16:59ZDay, Gary——05/27/1974··UHC-86503-99•••-••-4899+1 204 819 7147GARY.DAY9@GMAIL.COM5743 Hillcrest Rd #228DENVERCO80266GRP-6667OPTIONS-PPO
ENRENR-1103312026-09-11T11:04:19ZRaymndSDelgado12/28/1975UHC-13862-33•••-••-0904443-830-5646RAYMOND.DELGADO@GMAIL.COM873 MOUNTAIN VIEW DRJacksonvilleFL·32230GRP-1973MEDICARE-ADV-A··
ENRENR-1342692026-10-10T13:47:13Zashley—daniels02/25/60UHC-77365-77•••-••-4078(227) 414-0055··ashley.daniels@gmail.com9072 Bayshore DriveAtlantaGA30364GRP-1477CORE-HMO
ENRENR-1255362026-01-16T01:54:43ZNoah—Ellis02-05-1958UHC-84589-07•••-••-81056472567487-7018 Maple AveDenverColorado80271-8345GRP-9379CHOICE-PLUS-PPO
ENRENR-1058492026-04-11T07:02:54ZEricSAustin1959-06-07UHC-94411-49•••-••-5185UNKNOWNeric.austin@aol.com7540 Ridge RoadEden PrairieMN55368GRP-7818OPTIONS-PPO
ENRENR-1050822026-07-02T01:37:06ZLinda··McCoy1948-12-02UHC-27992-22•••-••-8269362-467-1261linda.mccoy68@proton.me69 SUNSET BLVDTempeAZ85291GRP-2634NAVIGATE-HMO
ENRENR-1333422026-01-19T03:33:15ZAmber··—Baker··1975-02-20UHC-69086-47•••-••-419419582958441amber.baker@yahoo.com8203 Bayshore DrAustinTX78727GRP-0257MEDICARE-ADV-B
ENRENR-1156512026-02-08T06:42:29ZMariaSDominguez1985-05-22UHC-32345-88N/A(870) 894-5614maria.dominguez46@gmail.com6206 Lincoln WayDallasTexas75254··GRP-0365SELECT-EPO
ENRENR-1171822026-05-03T00:29:30ZElliott, NatalieL—Nov 20, 1978UHC-09220-55•••-••-0515610-876-0923natalie.elliott@proton.me6038 Desert Sky Boulevard #245MiamiFL33177GRP-1524NAVIGATE-HMO
ENRENR-1415672026-02-09T19:30:39ZSophia—Hall—UHC6098796•••-••-796715572425063SOPHIA.HALL88@HOTMAIL.COM6314 RIDGE ROADLos AngelesCA90067GRP-9745MEDICARE-ADV-A
ENRENR-1380732026-01-20T16:10:23ZGREGORYYESPINOZA1982-11-20UHC-77447-91•••-••-32168208254799UNKNOWN5603 Indian School RoadColumbusOH·43279GRP-3158OPTIONS-PPO
ENRENR-1007612026-05-27T09:39:44ZMATEOB.ESPINOZA19790321UHC2230473•••-••-6501717-734-6822·null2755 CENTRAL AVENUEAustinTX78798GRP-9574OPTIONS-PPO
43,101 rows, page 268 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.423Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty