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-1197382026-08-19T04:44:23ZReid, RoyB—1975-11-05uhc-74723-28•••-••-285612044353822ROY.REID14@GMAIL.COM7434 Cedar LaneGlendaleArizona·85398·GRP-9407CHOICE-PLUS-PPO
ENRENR-1133492026-08-02T11:00:48ZSTEPHANIE····REED1993-01-10UHC-97234-36··—2635950946··stephanie.reed@outlook.com7427 Church StNashvilleTN37269GRP-3167CHOICE-PLUS-PPO
ENRENR-1332232026-10-14T16:30:14ZMASON·Y.CHAVEZ11/05/77UHC-05258-48—381-384-1263mason.chavez85@aol.com4773 Highland AveEden PrairieMN·55366·GRP-3349OPTIONS-PPO
ENRENR-1111742026-02-27T21:20:21ZBEVERLY··GUERRERO1942-05-27UHC-26887-19•••-••-8119827.751.5431beverly.guerrero@aol.com8315 Jefferson AveTEMPEAZ85230GRP-9686NAVIGATE-HMO
ENRENR-1103592026-10-18T07:38:23ZRONALD··—SAANCHEZ1991-08-06UHC-88684-05N/A+1 247 583 7174ronald.sanchez@proton.me4103 Meadow LaneGLENDALEAZ··85348GRP-9976NAVIGATE-HMO
ENRENR-1351462026-08-08T23:39:28ZAISHA··—PENA1993-10-07UHC-36637-98—·(686) 895-9963aisha.pena41@yahoo.com5845 Union StreetPhoenixAZ85097GRP-1807OPTIONS-PPO
ENRENR-1377112026-01-25T17:02:04Zelizabeth—chapman1951-70-14UHC-53911-66•••-••-4302—elizabeth.chapman23@hotmail.com·3446 Elm StGilbertAZUNKNOWN·GRP-7978NAVIGATE-HMO··
ENRENR-1283902026-09-29T15:21:38ZSentiagoY.PerkinsJan 21, 1972UHC-86977-19•••-••-4357241-730-0455SANTIAGO.PERKINS@HOTMAIL.COM172 Jefferson AvenueGLENDALE··AZ85363-9491GRP-2112OPTIONS-PPO
ENRENR-1047212026-02-20T20:06:20Z·DianaXOrtega·Aug 19, 1978UHC-22553-31-4692665241diana.ortega76@gmail.com9025 Palm DriveChandleraz85246GRP-5674SELECT-EPO
ENRENR-1359532026-09-08T18:17:34ZBRITTANYM··MARQUEZ1964-12-27UHC-71596-90•••-••-8742+1 263 379 9907brittany.marquez@outlook.com4717 Spring St··ColumbusOH43249GRP-4992··NAVIGATE-HMO
ENRENR-1033932026-05-19T17:14:28ZJerry—Hamilton·1980-10-25UHC-48191-99•••-••-5801(262) 594-2278NULL7614 Palm DriveSeattle·WA98130GRP-6176··CORE-HMO
ENRENR-1152432026-05-31T06:54:28ZNgueyn, KevinR—19600917UHC-91720-45NULL····KEVIN.NGUYEN@GMAIL.COM7436 Cedar Ln·Nashville·TN—GRP-4719NAVIGATE-HMO
ENRENR-1390862026-02-12T08:07:31ZJessL.Hunt04/27/1981UHC-73352-65•••-••-999917764191539jessica.hunt@aol.com3711 Valley View DrMiamiFL33171GRP-8163MEDICARE-ADV-B
ENRENR-1266052026-03-11T02:18:01Z Austin, ValentinaU····24-05-1987··UHC-27686-48•••-••-78742844465589VALENTINA.AUSTIN77@YAHOO.COM2807 Indian School RdDallasTXUNKNOWNGRP-3156MEDICARE-ADV-B
ENRENR-1333122026-08-07T20:09:16ZDIANAI.HOWELL1946-09-28···UHC-87462-48•••-••-6442(782) 551-7719DIANA.HOWELL@GMAIL.COM6018 Apache BoulevardDallasTX75236GRP-9859SELECT-EPO
ENRENR-1073532026-01-20T18:38:53ZMark, VargasA.—06/13/82UHC-25967-45•••-••-32016382418379·NULL7658 Oak StPhoenixAZ85019GRP-6632OPTIONS-PPO
ENRENR-1036202026-02-10T18:02:15ZKATHERINEKTURNAR12/5/1953UHC-72280-81—nullKATHERINE.TURNER@ICLOUD.COM7485 LAKE VIEW ROADSeattleWA98138GRP-0466CHOICE-PLUS-PPO
ENRENR-1238932026-03-25T09:38:28ZAHMEDIADAMSDec 6, 2001UHC-61442-82•••-••-6684642-226-2115ahmed.adams54@yahoo.com·3121 Union Street Apt 1Las VegasNV89139GRP-1756OPTIONS-PPO
ENRENR-1074842026-04-04T00:19:55ZLINDAKGARRETT1940-12-15··UHC-81913-81NULL2543791017LINDA.GARRETT@YAHOO.COM·2449 BROADWAYGilbert··AZ85229··GRP-6130MEDICARE-ADV-B
ENRENR-1214182026-07-14T05:53:09ZMike—Walker··01-05-1974UHC-97961-65•••-••-7431(354) 770-4933michael.walker2@outlook.com5591 Harbor BoulevardAustinTexas—GRP-2760CHOICE-PLUS-PPO
ENRENR-1143052026-04-09T12:13:47ZArjunOSims19740325UHC-58340-06•••-••-0096+1 499 500 4480ARJUN.SIMS34@OUTLOOK.COM··6914 Grand AvenueEden PrairieMN55383GRP-3281NAVIGATE-HMO
ENRENR-1406232026-07-03T00:24:48ZJAOCB—SANDOVAL1999-07-07UHC-89969-12•••-••-9079·3937201192jacob.sandoval83@icloud.com1111 Mesa DriveATLANTAGeorgia30330GRP-0438CORE-HMO··
ENRENR-1138052026-06-09T20:59:13Zwalter··—moreno1948-02-08UHC5796248null2207894625WALTER.MORENO33@PROTON.ME968 Park Pl··CHARLOTTE·NC28220GRP-6808NAVIGATE-HMO
ENRENR-1030172026-06-12T05:11:19ZKENNETH—WALLACE11/28/1958UHC-00563-50•••-••-1400(258) 824-3229KENNETH.WALLACE38@ICLOUD.COM4932 Indian School RoadMiamiFL33157GRP-5772NAVIGATE-HMO
ENRENR-1316302026-06-02T21:02:23ZNOAH—VASQUEZ2006-02-22UHC5148614•••-••-73478449950826N/A8848 Willow CourtLas VegasNV89140GRP-7804CORE-HMO
ENRENR-1389752026-07-28T16:09:01ZAUSTIN—HARRIS1949-10-05UHC8607997•••-••-84096992618190—·4002 Desert Sky BoulevardColumbusOH43222GRP-0348CHOICE-PLUS-PPO
ENRENR-132581 2026-07-20T13:08:39ZEma—Montgomary1976-06-14UHC-51502-75•••-••-4625630-781-1769emma.montgomery93@hotmail.com356 PINE DRMiamiFlorida33128GRP-4357NAVIGATE-HMO
ENRENR-1260102026-08-13T11:02:13Z GEORGE—VALDEZ1998-11-25UHC-34806-17•••-••-2020(890) 912-8333george.valdez34@icloud.com3498 CHURCH ST #539·CharlotteNorth Carolina28245··GRP-6925CORE-HMO
ENRENR-1128902026-02-10T08:33:26ZHannahXLewis06/28/2002UHC4122601•••-••-26128918067254hannah.lewis@yahoo.com236 Church StreetDENVERCO80227··GRP-4426SELECT-EPO
ENRENR-1153972026-02-08T12:28:59Z DEBRA—RIVERA1996-02-15UHC-46042-67•••-••-0937(730) 323-5911debra.rivera80@outlook.com7286 Hillcrest RoadSACRAMENTOCA95811GRP-8560OPTIONS-PPO
ENRENR-1232232026-08-07T14:17:11Z keith—bell1989-12-22UHC-33386-33•••-••-0804NULL—9563 Willow CtTempe···AZ85268·GRP-7875CHOICE-PLUS-PPO
ENRENR-1067852026-01-02T19:22:26ZEVELYNDHERNANDEZ1976-08-19UHC-34040-49•••-••-2268297-625-2079evelyn.hernandez45@outlook.com780 Forest AveSeattleWA98108GRP-0842OPTIONS-PPO
ENRENR-1223332026-04-13T03:00:28Z·Mark A—Contreras6/5/1994UHC-18319-57•••-••-3761365-335-9957mark.contreras@hotmail.com4270 OCEAN AVE #399PlanoTexas75036GRP-4070·CORE-HMO
ENRENR-1136002026-08-16T13:45:01ZBrianW.Roberts09/26/86UHC-10708-73•••-••-6951·6028362302brian.roberts@proton.me750 Highland AveTempeAZ85297GRP-5961OPTIONS-PPO
ENRENR-1373792026-06-29T02:22:37ZblilyVlanne6/14/1980UHC-29517-66•••-••-2262276-708-3544··BILLY.LANE@HOTMAIL.COM··5605 Ocean AveSan Diego·CA92192GRP-1108CORE-HMO
ENRENR-1229232026-05-15T19:58:26ZCARL—TRAN06/10/59UHC-23306-38··•••-••-7694564.355.0612carl.tran@yahoo.com9834 Desert Sky Boulevard··Eden PrairieMN—GRP-9668SELECT-EPO
ENRENR-1098612026-08-17T18:57:27ZPATRICIA—GRANTSep 7, 1978UHC-06605-29•••-••-8962748.593.1064··6500 RIDGE RDMiami··FL33172GRP-6546OPTIONS-PPO
ENRENR-1185382026-08-15T06:47:28Z·DianaV.Matthews2004-08-21UHC-03953-30•••-••-6563·6508580109diana.matthews@gmail.com6688 Harbor Boulevard Apt 17MiamiFL33130GRP-4777SELECT-EPO
ENRENR-1066612026-06-29T18:09:11ZElliott, MaggieQ—5/10/1953UHC-55958-59•••-••-5493622.578.0751margaret.elliott13@proton.me8763 SAGE COURTEden PrairieMN55308GRP-2907CORE-HMO
ENRENR-1184962026-07-12T23:32:26ZGary—Rojas1959-10-16UHC-89288-74··•••-••-9807+1 637 712 5647null5763 Canyon RoadSeattleWA98153GRP-8999CORE-HMO
ENRENR-1232632026-06-12T10:40:40ZAdamI·Little1943-08-22UHC-80356-86•••-••-5436551-542-4028ADAM.LITTLE@HOTMAIL.COM1689 MOUNTAIN VIEW DRNashvilleTN37201··GRP-6014MEDICARE-ADV-A
ENRENR-1299622026-09-12T23:13:18ZKayla—Mills2007-04-02UHC-01587-52•••-••-7850(886) 785-6919·kayla.mills76@aol.com3905 APACHE BLVDMiamiFL33131GRP-0480MEDICARE-ADV-B
ENRENR-1410442026-05-10T17:26:32ZDEBRA—FERGUSON1943-06-01UHC-56840-08•••-••-1381(436) 799-0900DEBRA.FERGUSON@ICLOUD.COM4725 River Road·PhoenixAZ85049GRP-1383MEDICARE-ADV-A
ENRENR-1340362026-05-22T06:28:12ZGordon·KSara1942-10-07UHC-37263-85•••-••-3057357-316-9412sara.gordon70@hotmail.com5437 Sage CourtCharlotteNorth Carolina28244GRP-3741CHOICE-PLUS-PPO··
ENRENR-1030722026-06-13T03:00:04ZJACKIE··FREEMAN1945-01-21UHC8659981•••-••-75942419134654-8928 Union StAUSTIN·TX78733-7332GRP-3988OPTIONS-PPO
ENRENR-1400632026-03-05T03:07:16Z Andrews, BillyR.····4/7/1955UHC7995412—12518606280—7626 River Road Apt 19ColumbusOhioUNKNOWNGRP-5120CORE-HMO
ENRENR-1015982026-06-12T14:28:39ZCharlotteB.Ruiz1938-02-14UHC-14538-84•••-••-81095886938927N/A7208 Camelback RdLas VegasNV89125GRP-2174CORE-HMO
ENRENR-1292642026-08-27T16:14:11ZWilliam—Hernandez2001-09-12UHC-46931-84•••-••-18695142381081william.hernandez@hotmail.comN/Anull—N/AGRP-8800SELECT-EPO
ENRENR-1269512026-07-13T18:54:42ZMarthaDGardner1944-05-13UHC-33697-52•••-••-0747257.983.7123martha.gardner@yahoo.com3192 Sunset BoulevardGilbertAZ85215GRP-6757MEDICARE-ADV-B
ENRENR-1216772026-01-27T11:25:11ZTeresa··—Cox1938-06-18UHC-62397-17•••-••-88639187257717null1758 Bayshore Dr·PLANOTX75032GRP-8327SELECT-EPO
43,101 rows, page 127 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:37.768Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty