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-1154792026-01-29T13:57:06ZChrisD.Hoffman19460504UHC-47909-72•••-••-6619+1 924 309 0019christopher.hoffman@proton.me6080 Baseline Road·HoustonTX77022-9829GRP-0219MEDICARE-ADV-A
ENRENR-1305622026-03-08T14:42:36Z Carol—Nunez11/08/1974UHC-30090-98•••-••-4814697.591.6085null3632 Hillcrest RoadPlanoTX75076GRP-0584MEDICARE-ADV-A
ENRENR-1206632026-09-28T05:51:19ZJULIAB.MITCHELL1965-11-04UHC-68852-95•••-••-9950·684-906-0488—2886 Valley View DriveDallasTX75209GRP-3945··SELECT-EPO
ENRENR-1316542026-04-12T14:35:17ZPAMELARARNOLDFeb 13, 1958UHC-73899-09•••-••-5317(806) 446-3919pamela.arnold53@icloud.com1866 OAK STFresnoCA93763GRP-2838OPTIONS-PPO
ENRENR-1225012026-08-09T22:43:20ZOmar—Gardner1953-09-05UHC-50030-98•••-••-8558695-217-2052null2622 Sunset BlvdNashvilleTN37271GRP-9648CHOICE-PLUS-PPO
ENRENR-1097732026-01-11T19:39:02ZGARY—·BOYD1971-06-20·UHC-06620-65•••-••-692718183047588·GARY.BOYD53@AOL.COM5162 Jefferson Ave··MiamiFL33179GRP-8553OPTIONS-PPO
ENRENR-1430242026-05-19T20:07:25ZJUAN—·MORALES1995-06-09uhc-08643-27•••-••-5198868-833-4727juan.morales@icloud.com8572 Valley View DrGilbertArizona85253GRP-4425·SELECT-EPO
ENRENR-1359742026-08-20T15:24:35ZKathrynMHart10-01-1947uhc-34576-96•••-••-2997(463) 616-7714kathryn.hart90@outlook.com1306 Pine Dr Apt 24ATLANTAGA—GRP-3191SELECT-EPO
ENRENR-1052362026-02-09T07:33:04ZSANDAPJACKSSON18-01-1970UHC-04416-25•••-••-9971+1 506 556 1529null9555 Meadow LaneEden PrairieMN55397GRP-0755MEDICARE-ADV-B
ENRENR-1275442026-03-19T19:49:02Z Danielle—Ellis1941-03-12UHC-67285-47•••-••-4057457-518-2376DANIELLE.ELLIS@HOTMAIL.COM7010 Grand AvenueDenverCO80233GRP-9760MEDICARE-ADV-A
ENRENR-1071122026-01-19T08:40:48ZLAWRENCESMARTIN··1943-05-06UHC-43693-23-—lawrence.martin28@yahoo.com204 UNION STREETMiamiFL33191GRP-0509SELECT-EPO
ENRENR-1135562026-09-21T08:57:41ZNICOLEHSPENCER2008-04-24UHC-17549-23•••-••-0166+1 637 608 7780null·8006 Washington StPhoenixAZ··85062GRP-0689CORE-HMO
ENRENR-1142252026-01-27T01:15:26Zphilip—banks1955-04-03UHC-92600-21•••-••-88095097634744PHILIP.BANKS@GMAIL.COM9677 Jefferson Avenue #745AustinTX78705GRP-2625MEDICARE-ADV-B
ENRENR-1026662026-06-14T08:07:45ZWayne—JimenezDec 3, 1962UHC-31574-79•••-••-4770··wayne.jimenez70@aol.com6937 Grand Ave #107Las VegasNV89161-0280GRP-7427MEDICARE-ADV-A
ENR ENR-1233902026-03-12T08:20:48Zhenry—hudson1962-05-17UHC-35103-42•••-••-5636(399) 531-9723henry.hudson94@yahoo.com3276 Camelback RoadGlendaleAZ85374·GRP-2840CHOICE-PLUS-PPO
ENRENR-1182032026-10-09T21:55:23ZWILLIAMW.THOMAS1963-02-12UHC-69152-82•••-••-30663124310william.thomas@proton.me··6444 Ridge Rd·ScottsdaleArizona85280GRP-3113MEDICARE-ADV-A
ENRENR-1058072026-04-04T05:05:10ZDENNISTGRAYJun 20, 1969UHC-23100-81··NULL627-315-2189dennis.gray@icloud.com4859 Maple AvenueFresnoCA93720GRP-6773OPTIONS-PPO
ENRENR-1241862026-07-13T21:41:19ZWeaver, Janice——1973-10-17··UHC-62096-42•••-••-5522·UNKNOWNjanice.weaver61@outlook.com1279 Oak StreetDENVERCO80225·GRP-5770SELECT-EPO
ENRENR-1227762026-03-08T17:52:35Zrobert—jacobs14-03-1957UHC-25481-39—15642961872··ROBERT.JACOBS32@ICLOUD.COM··6001 CANYON RD··Jacksonvillefl32224GRP-6704CORE-HMO
ENRENR-1010742026-01-13T05:57:39ZGRACEOLITTLE19720206UHC-70114-35•••-••-8216794-358-0354GRACE.LITTLE88@HOTMAIL.COM4309 Spring StSCOTTSDALEaz85229GRP-1566OPTIONS-PPO
ENRENR-1377742026-02-07T18:34:29ZKAYLAVREYES1995-02-08UHC-27866-07—418-331-8017··kayla.reyes@proton.me··2735 Highland AveTampaFL33678GRP-9289MEDICARE-ADV-A
ENRENR-1030672026-06-27T06:53:43ZCharlotte—YoungMay 2, 1998UHC-74145-50··—(805) 626-0184charlotte.young@yahoo.com1108 UNION STREET Apt 33PlanoTX75044GRP-6019MEDICARE-ADV-A
ENRENR-1194382026-03-20T13:37:52ZCrawford, Eugene··I—9/21/1980UHC2340639•••-••-0563(889) 495-1061eugene.crawford59@proton.me2129 Indian School RdScottsdaleaz85202GRP-2163CORE-HMO
ENR ENR-1399262026-01-14T08:07:17ZVazquez, DavidN··1991-07-20UHC-60007-82•••-••-94756243644386david.vazquez91@outlook.com5456 Washington Street #974Seattlewa98174-5839GRP-7146MEDICARE-ADV-B
ENRENR-1208622026-05-07T23:23:49ZDIANATFIELDS19900926UHC-61484-50•••-••-1981+1 404 321 1488diana.fields@aol.com1618 Jefferson AveChandlerAZ85205GRP-2096CHOICE-PLUS-PPO
ENRENR-1371432026-06-04T02:43:34ZScott—Welch1981-07-13UHC8019778•••-••-50663428648102null5665 Elm St Apt 21DENVERCO80220GRP-9033NAVIGATE-HMO
ENRENR-1071262026-08-18T01:24:38ZRebecca····Miller1995-08-19UHC-58098-43·null4473126499-4169 Desert Sky BlvdEDEN PRAIRIE·MN55344GRP-3838SELECT-EPO
ENRENR-1168792026-08-03T21:24:11ZJerry—Romero··03/24/64UHC9831299•••-••-6540(267) 908-1891JERRY.ROMERO57@GMAIL.COM855 Lake View RoadTucsonAZ—GRP-5539CORE-HMO
ENRENR-1232352026-09-26T05:18:28ZADAMA.KNIGHT1952-11-20UHC-86556-41•••-••-9147(321) 410-2752ADAM.KNIGHT36@GMAIL.COM7661 Market StAtlantaGA30343GRP-8189CHOICE-PLUS-PPO
ENRENR-1238682026-01-08T14:34:28Z·SarahYKnight1983-04-06UHC-23456-64•••-••-153118228673916—7683 SUNSET BLVDMINNEAPOLISMN55499GRP-0316··OPTIONS-PPO
ENRENR-1421362026-09-28T06:38:29Z·RachelOVazuez1983-01-11UHC2139733•••-••-1284385-972-9498RACHEL.VAZQUEZ@AOL.COM7668 CENTRAL AVEAtlantaGA30327GRP-5510OPTIONS-PPO
ENRENR-1269592026-02-25T08:16:27ZWalterD—1986-05-25··UHC-98616-19•••-••-1361(566) 617-0182walter.patterson65@aol.com3166 Mountain View DrLas VegasNV89122GRP-6424MEDICARE-ADV-A
ENRENR-1018882026-09-19T16:20:00ZAMANDA—MARSHALL1952-06-22UHC-03865-31•••-••-73489524022435UNKNOWN1064 Ocean AveGILBERTArizona··85283GRP-7146CORE-HMO
ENRENR-1290862026-01-27T04:53:17ZSean—Yang··1978-12-20UHC-75066-21•••-••-2096698-901-9021··sean.yang@hotmail.com7871 Desert Sky BoulevardMIAMIFL·33194GRP-0605OPTIONS-PPO
ENRENR-1252932026-02-16T01:02:16ZGLORIAQROSS08/24/1983··UHC-95778-74•••-••-1502NULLUNKNOWN·4616 Forest Ave #308MinneapolisMN·55498GRP-3774MEDICARE-ADV-B
ENRENR-1172922026-06-12T09:19:28ZLoganAPhillips1966-04-21UHC-58593-18····460.919.6479logan.phillips87@icloud.com3710 Mountain View Dr Apt 32OrlandoFL32851GRP-9869NAVIGATE-HMO
ENRENR-1094782026-03-09T14:14:20ZLewis, Roger——02/03/56UHC-29701-15•••-••-6736(861) 490-5018—5339 Ridge RdDallasTX75210GRP-3957CORE-HMO
ENRENR-1201142026-07-11T13:54:59ZseanSmeyer1949-11-03UHC-75769-78—4655735390null158 Mesa DriveTucsonAZ85781GRP-9708MEDICARE-ADV-A
ENRENR-1046552026-03-03T07:40:24Z Andrew—Padilla1984-08-21UHC-80718-14•••-••-0102745-251-9577ANDREW.PADILLA@GMAIL.COM902 MARKET STDallasTX75267GRP-5650core-hmo
ENRENR-1142212026-06-17T02:47:48ZANDREACMARSHALL1975-04-27UHC1110001•••-••-7328597-745-3596ANDREA.MARSHALL12@HOTMAIL.COM3932 Mesa DrMiamiFL33180·GRP-4878CHOICE-PLUS-PPO
ENRENR-1186392026-02-10T11:59:51ZWEIKFLORES1946-10-15UHC-45273-71•••-••-23798686401554N/A2163 Union StreetEDEN PRAIRIEMinnesota55343GRP-2280SELECT-EPO
ENRENR-135578 2026-06-01T14:39:45ZMATTHEWPSANCHEZ05/13/75UHC-20584-91•••-••-1694838.733.2068MATTHEW.SANCHEZ74@ICLOUD.COM1626 Park Pl Apt 23TempeAZ85298GRP-8919MEDICARE-ADV-B
ENRENR-1161132026-01-17T07:15:49Z LarryM·Lna1971-06-18UHC-37316-70··•••-••-4016946.962.3959larry.luna79@icloud.com9021 WILLOW CTColumbusOH43275GRP-3342MEDICARE-ADV-A
ENRENR-1425602026-03-07T04:30:16ZHANNAHX.DOMINGUEZ1942-05-23··UHC-10928-36•••-••-969719067238081HANNAH.DOMINGUEZ1@YAHOO.COM2610 MAPLE AVEGilbert··AZ85234GRP-9386OPTIONS-PPO
ENRENR-1359232026-10-05T12:25:50Z·RUSSELLEMURRAY06/02/1946UHC6088205•••-••-61683746386—2644 Ridge RoadPHOENIXAZ85034GRP-2456NAVIGATE-HMO
ENRENR-1365392026-07-16T17:01:17ZLganQTranMay 11, 1997UHC2636290•••-••-6517729-650-0155logan.tran22@yahoo.com4762 CANYON ROADPlanoTX75057-0040GRP-9638CORE-HMO
ENRENR-1269162026-03-19T18:01:04ZKnight, RobertG—2008-07-21UHC-16048-80··•••-••-070314059524641robert.knight22@proton.me2299 Lincoln WayMiamiFL33146-1658GRP-4887MEDICARE-ADV-B
ENRENR-1125592026-01-18T13:26:13ZKennedy, Randy——11/01/54UHC-29773-41····(973) 227-4314RANDY.KENNEDY@YAHOO.COM5003 Union StreetLas VegasNV·89159GRP-9958MEDICARE-ADV-A
ENRENR-1246772026-05-20T10:02:32ZETHANV.REID19580210UHC9352279•••-••-1047742-332-8602ethan.reid@yahoo.com123 Park PlaceLos AngelesCA90017GRP-9512choice-plus-ppo
ENRENR-1120532026-05-30T17:28:07ZSean·Z.Sims10/5/1966UHC-28541-23•••-••-6294+1 887 541 5263sean.sims34@icloud.com··5018 Elm StreetMESAAZ85281GRP-1689OPTIONS-PPO
43,101 rows, page 53 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:36.685Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty