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
ENR ENR-1313352026-09-29T08:44:37ZMarilynS.Perkins1981-04-09UHC-97616-01UNKNOWN786.675.7543N/A··5018 Ridge Road #381MINNEAPOLISMN··55446GRP-1521MEDICARE-ADV-B
ENRENR-1262842026-03-13T15:06:05ZEVELYNLLE12/09/1993—•••-••-86765342195395evelyn.le39@hotmail.com1620 Central AveGlendaleAZ85349GRP-1213NAVIGATE-HMO
ENRENR-1317052026-06-18T16:11:44ZMorgan, Gloria——1956-03-18UHC-10264-85•••-••-8476(790) 455-2356gloria.morgan@proton.me8810 Jefferson AvenueCharlotteNC28251GRP-2107NAVIGATE-HMO
ENRENR-1268612026-06-05T03:24:14ZDAVIDBROGERS··12/15/1950UHC-03997-69•••-••-37486937497399—5317 Washington St Apt 22MESA··AZ85218-8030GRP-4420CORE-HMO
ENRENR-1314202026-05-15T10:44:34ZWeber, Nicole··—19730422UHC-69937-12•••-••-27728965281228—9692 Indian School Rd·JacksonvilleFL32270GRP-1406OPTIONS-PPO··
ENRENR-1341812026-06-01T08:11:41Zemily—willis1971-10-05UHC-67918-94null··450-619-6523emily.willis58@icloud.com3559 Mesa DriveGilbertAZ··85288GRP-7476CHOICE-PLUS-PPO
ENRENR-1134422026-10-03T23:00:39ZSARAHVHANSEN1991-12-08UHC4153607•••-••-2851599-223-3279SARAH.HANSEN83@HOTMAIL.COM8339 Bayshore DrMinneapolisMN55496-0022GRP-7753CORE-HMO
ENRENR-135864 2026-07-06T22:48:11ZEmilyC.Dominguez01-10-1985UHC-30743-93•••-••-7257(523) 310-3106emily.dominguez@outlook.com4578 Pine DriveJACKSONVILLEFlorida··32253-7455GRP-9321core-hmo
ENRENR-1194272026-08-02T16:14:06ZFrankIDayJun 21, 2000UHC-58405-01•••-••-6498646-321-4064frank.day@icloud.com7146 MOUNTAIN VIEW DRCharlotteNC28256GRP-5999MEDICARE-ADV-A
ENRENR-1033972026-10-06T09:03:12ZROY—PAYNE01/20/87UHC-52043-76•••-••-81862617780795ROY.PAYNE@AOL.COM5791 Baseline RoadColumbus·OH43228GRP-6749NAVIGATE-HMO
ENRENR-1202442026-08-15T03:44:14ZSoophia—Williamson06/09/44UHC-37598-10·nullUNKNOWN-··7952 GRAND AVE·PlanoTX75077GRP-0818CHOICE-PLUS-PPO
ENRENR-1366212026-06-07T05:12:22ZJuanWStephens1959-06-20UHC-60981-40•••-••-2781——9229 Washington StreetColumbusOH43248··GRP-5142CORE-HMO
ENRENR-1072862026-06-27T09:33:32ZGARY—VEGA02/20/06UHC-86681-75•••-••-7468(500) 215-6966gary.vega32@hotmail.com2281 Grand Avenue·San DiegoCA92156GRP-9623·MEDICARE-ADV-A
ENRENR-1001012026-07-09T10:22:36Zaaron—webb10/07/2008··uhc-75621-63•••-••-8348458.846.6333AARON.WEBB@AOL.COM6397 GRAND AVENUETempeAZ85260GRP-8847CORE-HMO
ENRENR-1346242026-05-02T00:34:08ZDorothyLWong··Apr 25, 1959·UHC-61229-84··742.631.1683—6100 Sunset BoulevardNashvilleTN37239GRP-1842CORE-HMO
ENRENR-1259352026-08-18T15:08:03ZCharles—Padilla24-10-1948UHC-99928-66•••-••-0953(448) 388-9157NULL8669 HIGHLAND AVE··TempeAZ85200GRP-1498·NAVIGATE-HMO
ENRENR-1028822026-07-13T05:07:28ZEvans, SueS—1960-06-17uhc-39153-49•••-••-943318418939686susan.evans@aol.com7457 BASELINE RDScottsdale·AZ85219GRP-0316SELECT-EPO··
ENRENR-1047522026-09-03T17:26:27ZAnnaCMendza12/01/1946UHC-01935-15•••-••-61217439156605UNKNOWN··3118 Lake View RoadGilbert··AZ·85283GRP-8664MEDICARE-ADV-B
ENRENR-1373652026-08-24T14:01:10ZRonaldEWard2001-05-25UHC-91083-58··•••-••-30824782839587RONALD.WARD58@HOTMAIL.COM4020 BroadwayGilbertAZ85294GRP-2993MEDICARE-ADV-B
ENRENR-1369332026-02-22T16:07:15ZGEARLDMGARZA1945-04-09UHC-07051-35•••-••-366817754715299gerald.garza68@icloud.com··3829 Main StreetDenverCO80234GRP-6047·OPTIONS-PPO
ENRENR-1001322026-02-16T16:47:03ZJacquelineL··Larson1939-10-06UHC-61655-04··•••-••-8949647-443-0681JACQUELINE.LARSON@PROTON.ME··7816 PALM DRIVEChandleraz85231GRP-5385MEDICARE-ADV-A
ENRENR-1308892026-05-14T14:29:26ZTeresa—Reed1964-02-17UHC-86365-59•••-••-1533(412) 255-1261·teresa.reed@aol.com5062 MAPLE AVENUEPlanoTexas75088GRP-7956·MEDICARE-ADV-B
ENRENR-1133842026-08-29T21:57:34ZNANCY··—LYNCH1970-02-10UHC-62977-75•••-••-3864832-505-6289—1365 Spring StreetDenverCO80289GRP-4518OPTIONS-PPO
ENRENR-1119582026-09-19T18:25:49ZLARRYVSMITH1953-11-11UHC-68077-82•••-••-1158(664) 700-7187larry.smith90@outlook.com1043 PARK PL Apt 30Las Vegasnv89107-5614GRP-7416OPTIONS-PPO
ENRENR-1169012026-01-17T07:11:50ZANNC.PATEL05/14/2006UHC-35602-52•••-••-7871N/AANN.PATEL87@GMAIL.COM1868 Lake View Rd·Eden PrairieMN55325GRP-6806··NAVIGATE-HMO
ENRENR-1216672026-05-31T21:41:30ZVictoria·HTayllor·1984-12-03UHC-98294-38•••-••-6666(594) 403-5375victoria.taylor9@yahoo.com5710 Harbor BlvdSan DiegoCA92190GRP-8301NAVIGATE-HMO
ENRENR-1265852026-04-12T09:44:09ZLOGAN—PARK··12/09/43UHC-39537-44•••-••-4195·532-279-1353LOGAN.PARK46@HOTMAIL.COM8579 HIGHLAND AVESACRAMENTOCalifornia95884GRP-7328··MEDICARE-ADV-B
ENRENR-1106842026-07-14T11:45:34ZPAMELA—JACKSON03/14/59UHC-56346-66•••-••-5394nullPAMELA.JACKSON90@YAHOO.COM7679 MESA DRIVECharlotteNCN/AGRP-8293CORE-HMO
ENRENR-1203022026-02-07T00:38:17ZPRIYA—SIMPSONNov 22, 1997UHC-26606-78•••-••-622417079954573PRIYA.SIMPSON@YAHOO.COM5204 MEADOW LN Apt 29ColumbusOH··43257GRP-4339CORE-HMO
ENRENR-1095622026-01-20T19:43:10ZZACHARY··—HUGHES1988-02-18··UHC-96105-20•••-••-6286909-294-9321zachary.hughes58@aol.com4613 Canyon RdSeattle·WA98121GRP-7001OPTIONS-PPO
ENRENR-1036752026-05-03T22:14:24ZMARTHAGSANCHEZ··1992-02-84UHC-34396-45•••-••-463117289875490martha.sanchez@aol.com·3891 Camelback RoadSEATTLEWA98186GRP-3597CHOICE-PLUS-PPO
ENRENR-1300542026-07-10T09:47:59ZEdward··GSchultz1981-08-11UHC-56577-84•••-••-470419672707272··1818 Bayshore DriveLos AngelesCA90071··GRP-7901CHOICE-PLUS-PPO
ENRENR-1411312026-09-11T04:40:07ZValentina·Z—1963-07-07UHC-41018-29•••-••-2220780.814.1056—·9825 Park Pl·Miamifl33109GRP-5552MEDICARE-ADV-B··
ENRENR-1210452026-05-02T21:45:19ZKelley, Jesse——·1954-06-03UHC-71064-07•••-••-0800(976) 209-7230jesse.kelley78@aol.com6169 Camelback Rd··San AntonioTX78217GRP-4825MEDICARE-ADV-B
ENRENR-1318762026-04-26T12:45:42ZEmma—Adams04/06/1940UHC-68871-40•••-••-238812187796440··106 INDIAN SCHOOL RD··Las VegasNV89148GRP-4604CHOICE-PLUS-PPO
ENRENR-1405332026-05-27T04:12:51Zstephanie····aguilar1954-03-19UHC-60325-07•••-••-34239534028384stephanie.aguilar@proton.me4279 Sunset BoulevardSacramentoCA95855GRP-4662SELECT-EPO
ENRENR-1113672026-06-05T08:04:20ZDiegoX·Campbell01/09/75UHC-87112-20•••-••-5989660-808-7742·N/A7400 Main StFresnoCA93796GRP-7798SELECT-EPO
ENRENR-1057762026-10-17T17:01:00ZGREGORY—ROBINSON3/14/1999UHC-86586-59•••-••-7069891.908.3975gregory.robinson@aol.com1979 Cedar LaneGILBERTAZ··85211GRP-9426OPTIONS-PPO
ENRENR-1357462026-04-20T22:26:30ZKYLE—MYERS1982-10-21UHC-86503-69•••-••-4398(811) 735-4532N/A2974 RIDGE ROADMESAAZ85211GRP-3512OPTIONS-PPO
ENRENR-1227472026-08-30T07:52:22ZLUYSWHARRISON2008-01-23·uhc-28050-67—555-891-7472luis.harrison@hotmail.com··8077 HARBOR BLVDSan Antonio··tx78211GRP-4435CORE-HMO
ENRENR-1150432026-07-06T20:24:12ZnoahXwatson1942-03-17UHC-55361-63•••-••-1930-—3672 Highland AvenueTempeAZ85226GRP-0774NAVIGATE-HMO
ENRENR-1149332026-01-16T02:38:28ZBOBV.··WANG11/24/1964UHC-67542-41•••-••-5440+1 986 786 6859UNKNOWN8908 Elm StreetGlendaleAZ85315··GRP-2093CHOICE-PLUS-PPO
ENRENR-1332462026-07-24T03:25:09ZPhilip··—Yang2004-11-11UHC-17010-53··•••-••-04413935180229PHILIP.YANG22@HOTMAIL.COM7571 ELM STTampa··FL33609GRP-5130OPTIONS-PPO
ENRENR-1249022026-01-25T17:45:27Z·KathleenC.Salazar19610205UHC-01997-43•••-••-2408(452) 995-4335kathleen.salazar@hotmail.com9016 Ocean AveFresnoca93733GRP-8673CORE-HMO··
ENRENR-1141662026-05-01T21:20:00ZLuciaF·Edwards1970-06-17UHC-42348-35•••-••-5585437.475.1530—6382 Jefferson AveDALLASTXN/AGRP-0152MEDICARE-ADV-B
ENRENR-1038822026-09-07T04:07:25ZSarahX.··Weaver09-08-1944UHC-47275-12•••-••-84839032075539··—979 Central AveLas VegasNV89114GRP-7887MEDICARE-ADV-B
ENRENR-1311222026-05-26T19:31:24ZKeith—Bradley·1990-11-17UHC-88618-79··•••-••-79906972707140keith.bradley47@icloud.com8921 CEDAR LNJacksonvilleFL32227GRP-8201MEDICARE-ADV-B
ENRENR-1410892026-05-14T06:58:22Z RyanHBurns15-12-1994UHC-07094-27•••-••-9012407.649.6902ryan.burns9@hotmail.com2824 CANYON RDSeattleWA98104GRP-1406MEDICARE-ADV-A
ENRENR-1016902026-07-02T15:41:59Zmelissa··—jimenez10/06/39UHC-42639-44•••-••-7637+1 889 815 6374MELISSA.JIMENEZ@AOL.COM6734 Pine DriveATLANTAGA30373GRP-5202OPTIONS-PPO
ENRENR-1073592026-07-11T02:40:23ZASHLEY—NUNEZ1942-02-11UHC7805072UNKNOWN·519.730.9594ASHLEY.NUNEZ90@GMAIL.COM6577 Highland AveMinneapolisMN55411GRP-8791MEDICARE-ADV-B
43,101 rows, page 141 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:38.465Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty