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-1376752026-09-07T09:38:45ZTimothy—Slva1948-10-12UHC-09253-40··•••-••-8691755.771.0982timothy.silva39@gmail.com5738 Forest AvenueTampaFL·33607GRP-9578MEDICARE-ADV-B
ENRENR-1083672026-07-01T16:32:58ZBettyORamos1944-01-17UHC-55325-32•••-••-6016N/A—727 Pine DrTampaFL··33634GRP-6542SELECT-EPO
ENRENR-1097762026-07-13T21:36:11ZAshley—Mitchell1989-08-02UHC-16625-75•••-••-4862946-459-7814ashley.mitchell@outlook.com7255 Cedar LnPlanoTX··75086··GRP-9781CHOICE-PLUS-PPO
ENRENR-1130542026-01-04T17:46:58ZscottShart19620402UHC-39979-07•••-••-90454126057459SCOTT.HART@PROTON.ME7942 Oak StMiamiFL33100GRP-5498MEDICARE-ADV-B
ENRENR-1404372026-03-04T11:00:21ZSandersUDouglas1958-07-23UHC-15375-20•••-••-09244699400251DOUGLAS.SANDERS93@AOL.COM·7638 BAYSHORE DRIVEATLANTAGeorgia30371GRP-7030CHOICE-PLUS-PPO
ENRENR-1305092026-08-13T13:48:40ZAHMED—HAYES05/03/1998UHC6134246•••-••-55994545116766N/A896 Bayshore Drive #901PlanoTX75056GRP-3326NAVIGATE-HMO
ENRENR-1004492026-09-21T22:39:28ZColeman, Keyla——19750103UHC-81024-35•••-••-19776152551314kayla.coleman@hotmail.com1530 APACHE BOULEVARDTampaFL33606GRP-0184OPTIONS-PPO
ENRENR-1003172026-07-23T09:43:54ZPatriciaE.Little1945-08-08UHC-13258-35NULL(317) 967-1474UNKNOWN5906 Sunset BoulevardColumbusOH43293GRP-1951MEDICARE-ADV-A
ENRENR-1008922026-09-26T21:05:16Zlawrence—garrett07/27/82UHC8375559null(860) 677-4695lawrence.garrett11@yahoo.com6007 BroadwayTampaFL33687GRP-9782medicare-adv-b
ENR ENR-1320782026-09-16T14:01:19ZDIXONO.··NOAH1968-05-24uhc-37800-54NULL··15267817748NOAH.DIXON90@AOL.COM5291 Camelback RoadATLANTAGA30396GRP-3145SELECT-EPO
ENRENR-1260002026-03-31T05:23:37ZTERESA—LAWRENCE1988-05-24UHC-66781-07•••-••-49745231004teresa.lawrence19@proton.me6964 Maple Ave·SeattleWAN/AGRP-6977SELECT-EPO
ENRENR-1300992026-05-08T17:18:44ZJoe—Williamson·1977-10-01UHC-73466-21•••-••-6081+1 222 611 1932JOE.WILLIAMSON69@ICLOUD.COM··7460 Palm DriveSACRAMENTOCA95825GRP-0765SELECT-EPO
ENRENR-1364292026-02-04T15:46:27ZRoger··MRobinson1990-04-28UHC2298173•••-••-921916299699491roger.robinson@yahoo.com2138 Ocean AvenueTampaFL33617GRP-0215NAVIGATE-HMO
ENRENR-1218402026-07-04T23:19:47ZAnn—Furd1944-05-12UHC-85813-12•••-••-6219491.697.4629ann.ford@proton.me3740 SPRING STREETGilbertAZ85264·GRP-1862OPTIONS-PPO
ENRENR-1226682026-08-05T07:25:38ZMariaLRyan1965-03-01·UHC-53814-07•••-••-4361(289) 811-8492-8437 Lake View RoadAtlantaGeorgia·30370GRP-4742CHOICE-PLUS-PPO
ENR ENR-1102332026-10-08T01:22:09ZKennethJ··Palmer10/25/1949UHC-11426-40•••-••-66905924742578UNKNOWN5068 LAKE VIEW RDORLANDOFL32810GRP-6975SELECT-EPO
ENRENR-1343462026-02-27T20:38:46ZJulieGJensen1970-04-14UHC-39503-67•••-••-5814+1 495 590 7765—5625 Baseline RoadLos Angelesca90060-7521GRP-1474SELECT-EPO
ENRENR-1013052026-10-09T23:55:18ZTERESA—CARR1996-07-04UHC7410933•••-••-7369(725) 213-3613teresa.carr@outlook.com1962 Palm DriveDallasTexas75236GRP-7617NAVIGATE-HMO
ENRENR-1279832026-09-07T17:14:55ZGabrielN··Owns1959-06-19UHC-52858-37•••-••-35272729850887gabriel.owens@hotmail.com6403 Valley View DrJacksonvilleFL32212GRP-5418CHOICE-PLUS-PPO
ENRENR-1191912026-07-14T08:46:52ZRichard—HansonJul 8, 1980UHC-34961-18null944-598-2355NULL·673 Bayshore Dr·MinneapolisMN55492GRP-9819MEDICARE-ADV-B
ENRENR-1259952026-06-03T07:17:05ZJUDY—COX1986-12-06UHC-67971-10•••-••-96789648217194—6375 Baseline RdSan DiegoCA92186GRP-5030MEDICARE-ADV-A
ENRENR-1135432026-07-19T12:15:09ZCarolynJMills1983-06-17UHC-54330-82•••-••-5800762-531-5624null9218 Canyon RoadGlendaleAZ85357GRP-1026CHOICE-PLUS-PPO
ENRENR-1145572026-03-22T19:18:12Z SamuelR.Gomez1993-12-17UHC-03152-04•••-••-7957+1 442 745 1814samuel.gomez97@outlook.com··105 Grand AvenueGilbertAZ85206GRP-1678MEDICARE-ADV-B
ENRENR-1394262026-01-31T03:47:52ZKYLEGMEYER1976-10-28UHC-64032-36•••-••-5696787.971.5728·KYLE.MEYER38@OUTLOOK.COM5213 LAKE VIEW RDTampaFL33615GRP-5548CORE-HMO
ENRENR-1258412026-03-23T13:26:55ZDonnaPYoung04/09/59UHC-09777-54•••-••-80562052221233DONNA.YOUNG@ICLOUD.COM9562 GRAND AVENUETAMPAFL33640GRP-9548OPTIONS-PPO
ENRENR-1427922026-08-07T16:18:06ZEthanKHarveyOct 24, 1960UHC-44646-94UNKNOWN+1 717 821 8219—·3014 Forest AveDenverCO80284GRP-2366OPTIONS-PPO
ENRENR-1181382026-07-13T20:15:08ZRonaldFVasquez07-09-1947UHC-90558-80•••-••-0676885.585.6933ronald.vasquez@proton.me4937 Lake View RdDENVERco··80250GRP-0557SELECT-EPO
ENRENR-1331472026-01-12T18:00:41ZsamanthaDvaldez·19730402·UHC-63204-93•••-••-14518598316933samantha.valdez68@hotmail.com7008 Washington StDenverCO80273GRP-1926···SELECT-EPO
ENRENR-1389772026-07-03T06:32:19Z Mark—Li1996-11-20UHC-93308-91•••-••-50803043246343mark.li7@gmail.com4867 Baseline RoadMIAMIFL33136GRP-8098MEDICARE-ADV-A
ENRENR-1024652026-01-23T05:50:48ZTyler—Wilson1987-12-11UHC-59252-11··•••-••-4228(779) 219-3053··tyler.wilson39@hotmail.com7542 Union StSacramentoca95843GRP-9766MEDICARE-ADV-B
ENRENR-1371582026-01-18T23:14:06ZMarcus—Davis1951-01-24UHC-27003-57•••-••-6145·(559) 864-8628MARCUS.DAVIS73@HOTMAIL.COM889 Elm StreetColumbusOhioNULLGRP-2797OPTIONS-PPO
ENRENR-1338332026-03-15T17:13:18ZGuzmanEDavid08/27/1957UHC-47294-74•••-••-4725(390) 423-5765DAVID.GUZMAN72@HOTMAIL.COM8849 OAK STREETSACRAMENTOCA95848-8323GRP-8744NAVIGATE-HMO
ENRENR-1138962026-01-22T13:49:04ZJudyUFranklin9/24/1978UHC-39136-20•••-••-9983(275) 790-3834judy.franklin@gmail.com8374 Mountain View DriveCHARLOTTE··NC28288GRP-8736NAVIGATE-HMO
ENRENR-1189362026-09-23T01:28:19ZBARBARAJBROOKS04/02/2004UNKNOWN•••-••-2034715.997.3458UNKNOWN2534 PALM DRIVEScottsdaleAZ85271GRP-5683OPTIONS-PPO
ENRENR-1156212026-02-12T01:07:17ZCarroll, ChristinaD—1990-07-10UHC-18251-33•••-••-9544·6411917CHRISTINA.CARROLL34@HOTMAIL.COM1480 MAIN STREETEden PrairieMN55331GRP-8525SELECT-EPO
ENRENR-1177592026-04-30T03:48:32ZJESSE—PIERCEJul 27, 1947UHC-13009-43•••-••-8605914-422-8848···jesse.pierce@proton.me4125 CANYON ROADTucsonAZ85703GRP-0244CORE-HMO
ENRENR-1356942026-05-02T07:29:41ZJOEHROSE1951-06-22UHC-91305-46NULL(947) 508-4966joe.rose83@icloud.com9445 HILLCREST RD···PlanoTX75063-6559GRP-5929··SELECT-EPO
ENRENR-1128372026-06-11T11:56:48ZCYNTHIAY.FORD23-09-1951UHC-92645-67N/A575-913-4166—2718 RIDGE RDLos AngelesCA90098GRP-1234MEDICARE-ADV-A
ENRENR-1307952026-02-09T19:41:55ZPHILIPBSIPMSON1940-08-26UHC-19865-64•••-••-0990394-552-5330philip.simpson84@gmail.com9221 Market StreetMinneapolisMinnesota55493-7817GRP-5282··MEDICARE-ADV-B
ENRENR-1000402026-01-20T05:48:03ZLAURENXWILLIAMS2002-07-08uhc-33359-92•••-••-32572732873430LAUREN.WILLIAMS87@AOL.COM3118 Sunset Blvd·MesaAZ85293-4135GRP-3234SELECT-EPO
ENRENR-1347262026-08-03T09:07:35ZJordan—Greane1982-01-27UHC-14726-64•••-••-0418——2298 Camelback RoadSCOTTSDALEAZ85255GRP-1311select-epo
ENRENR-1246672026-02-06T22:14:24ZETHAN—WEAVER6/5/1967UHC-26033-52•••-••-18944762445631ETHAN.WEAVER73@AOL.COM8731 Washington StreetMesaAZ85268··GRP-6773SELECT-EPO
ENRENR-1117802026-02-14T12:40:07Z·MelissaZHall9/23/1949UHC-70732-54•••-••-840417364924487MELISSA.HALL@AOL.COM3608 Maple AveMiamiFL33104GRP-0924··OPTIONS-PPO
ENRENR-1247862026-01-29T20:51:56ZDOTJHUGHES1980-03-27UHC-92550-82··•••-••-76797649083664dorothy.hughes52@proton.me7079 Main Street·AtlantaGA30332GRP-4264OPTIONS-PPO
ENRENR-1415622026-01-31T02:50:16ZJereemy—Weaver15-04-1946UHC-70862-18•••-••-512415609815679—7375 Ridge RoadScottsdaleAZ·85284GRP-6144CHOICE-PLUS-PPO
ENRENR-1389912026-08-08T03:10:41ZTIM—SIMMONS09/16/57UHC-07596-21•••-••-0457686-444-1659····4725 OCEAN AVEOrlandoFL32872-4561GRP-8799OPTIONS-PPO
ENRENR-1331532026-04-22T12:14:21ZEvelyn—Adams20040119UHC-78739-98•••-••-4252370.998.7297NULL9199 BroadwayORLANDOFL·32869-4317GRP-1788MEDICARE-ADV-B
ENRENR-1429842026-02-26T21:42:23ZRONALDZELLIOTT2006-06-24UHC-68126-25•••-••-8008809-656-0979ronald.elliott36@aol.com5202 PINE DRAustinTX78700·GRP-8326OPTIONS-PPO
ENRENR-1177302026-03-10T04:53:32ZAUSTINK.HART·1/22/1999UHC-70253-84•••-••-2842(304) 454-9959austin.hart@outlook.com4422 Apache BlvdPHOENIXAZ85073·GRP-7865OPTIONS-PPO
ENRENR-1379322026-07-22T10:59:01ZRUTHS.··MUNOZ1954-08-01UHC-01549-46•••-••-1952·+1 428 792 8428RUTH.MUNOZ@HOTMAIL.COM633 CANYON ROADHoustonTX77016GRP-1628OPTIONS-PPO
43,101 rows, page 152 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.477Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty