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-1070372026-10-02T00:17:23ZSANDRA—DIXONNov 8, 1966UHC0220833•••-••-2347646-202-9251-·648 Union StMESAAZ85267-4610GRP-6857CORE-HMO
ENRENR-1009972026-06-28T00:05:52Z HANNAH—GONZALEZ3/24/1978UHC-49007-82•••-••-4666·N/Ahannah.gonzalez51@yahoo.com3987 Maple AvePhoenixAZ85048GRP-7722MEDICARE-ADV-B
ENRENR-1298102026-06-04T05:55:30ZAmy—Jensen··May 13, 1984UHC-30982-25•••-••-8541·610.338.5366amy.jensen94@icloud.com9565 Spring Street·HoustonTX77050GRP-1824MEDICARE-ADV-A
ENRENR-1184422026-02-27T21:41:00ZROY—CHAVEZ11/04/39UHC-19953-03•••-••-95512785855716roy.chavez50@hotmail.com1429 APACHE BOULEVARDChandlerAZ85295GRP-6134MEDICARE-ADV-B
ENRENR-1410572026-08-09T20:42:46Z DorothyILopez1994-01-02UHC-91732-95•••-••-97534139804903dorothy.lopez@icloud.com4787 Valley View DriveChandlerAZ85242GRP-7380CHOICE-PLUS-PPO
ENRENR-117714 2026-03-09T11:50:46ZJoyceZ.Hanson1949-10-10UHC-20821-83•••-••-7168+1 709 985 2727··JOYCE.HANSON@PROTON.ME7845 Jefferson AveMESAaz85227GRP-4052OPTIONS-PPO
ENRENR-1269362026-01-24T18:52:35ZKarenLFuller··1984-12-23UHC-16884-91•••-••-2053(203) 938-3532KAREN.FULLER@PROTON.ME3419 Jefferson AvenueTempeAZ85294GRP-4498SELECT-EPO··
ENRENR-1015662026-10-09T20:30:57ZLAUREN—PETERS2000-10-06··UHC-27427-96•••-••-18755318945729LAUREN.PETERS40@ICLOUD.COM4948 Hillcrest Rd·CharlotteNCN/A·GRP-8184SELECT-EPO
ENRENR-1162632026-04-25T00:54:49ZKevinA.Perkins1946-09-13UHC-14586-75•••-••-6556+1 898 367 5834kevin.perkins@hotmail.com3108 LAKE VIEW RDSan Diego·CA·92117GRP-8439CORE-HMO
ENRENR-1026992026-03-15T16:13:14ZPriyaXBradley1940-08-10UHC-02485-02•••-••-1220219-552-4475NULL553 Highland AvenueFresnoCA93795GRP-1932SELECT-EPO
ENRENR-1388822026-07-07T04:37:39ZBenjamin—HicksJan 14, 2002UHC5782875•••-••-3601886.429.7842benjamin.hicks88@hotmail.com4096 River RdColumbusOH43218GRP-6068·OPTIONS-PPO
ENRENR-1186592026-02-11T13:16:22ZHelen—Graham11/14/1985UHC-83009-59•••-••-8158+1 930 813 4417-7493 Park PlaceMiamiFL··33137GRP-4543·MEDICARE-ADV-A
ENRENR-1299492026-01-28T23:05:01ZTaylor, VincentA—01/18/38UHC-06216-10•••-••-8216791-251-2014VINCENT.TAYLOR77@GMAIL.COM9608 Baseline RoadJACKSONVILLEFlorida32263GRP-5666OPTIONS-PPO
ENRENR-1237132026-03-09T07:57:06ZCyynthiaGCarroll2004-07-27UHC-69883-08N/A953-299-7992N/A7925 MOUNTAIN VIEW DRLas VegasNV89189GRP-6868CORE-HMO
ENRENR-1051832026-06-07T08:04:01ZDanielCWhite1994-09-26UHC-97483-98—+1 589 256 6072daniel.white@yahoo.comNULL—N/A—GRP-7334CHOICE-PLUS-PPO
ENRENR-1173592026-02-04T10:26:45ZALBERT—FISHER06/06/71UHC-40609-82•••-••-9841(561) 976-1914ALBERT.FISHER@GMAIL.COM8806 PARK PLACESan Antonio··TX78212GRP-8031·CORE-HMO
ENRENR-1202972026-05-29T04:45:09ZMARIANA—PETERSON1979-12-19UHC-50156-37•••-••-4629(889) 792-2950NULL6743 Park PlScottsdaleaz85256GRP-0246NAVIGATE-HMO
ENRENR-1043252026-06-24T23:16:32Z EVELYNYDELGADO1939-08-07UHC-30789-39•••-••-2074599-622-3288evelyn.delgado80@proton.me·222 Main StreetTempeaz85221GRP-7517MEDICARE-ADV-A
ENRENR-1098392026-03-28T15:55:55ZDonaldD.Watkins1974-01-14·UHC-53110-97null·(236) 574-4188donald.watkins@aol.com7620 MAIN ST #488Houstontx77082-9773GRP-7996NAVIGATE-HMO
ENRENR-124785 2026-08-15T19:44:31ZJose····Richards1995-02-10UHC-95582-35•••-••-9162755.905.8342-2591 Ocean AveLos AngelesCA··90066GRP-1576NAVIGATE-HMO
ENRENR-1115552026-02-22T17:06:46ZNathan—Rose05-05-1964UHC-57831-42•••-••-3599988.254.5271N/A439 Baseline RoadDenverCO··80269-7525··GRP-5654MEDICARE-ADV-A
ENRENR-1036622026-06-12T23:40:35ZJuanOMartinJul 17, 1963UHC-38051-15•••-••-2366+1 639 613 7275juan.martin2@gmail.com5914 Apache BoulevardScottsdaleAZ85222GRP-5298CORE-HMO
ENRENR-1226122026-02-07T00:35:31ZWILLIEF.FRANKLIN09-09-1939UHC-97091-61•••-••-6829906.624.8834—460 Baseline RdHoustonTX77049-3023GRP-4901SELECT-EPO
ENRENR-1400222026-01-19T09:24:07Zray—peters03-08-1972UHC7219033•••-••-3563—raymond.peters35@outlook.com2221 LAKE VIEW RDAustinTX78732GRP-6072MEDICARE-ADV-B
ENRENR-1079952026-08-21T18:00:00ZKatherineZOliver1946-05-24UHC-76825-62•••-••-4163+1 678 761 6686katherine.oliver@proton.me348 JEFFERSON AVEDENVERCO80297··GRP-4624·OPTIONS-PPO
ENRENR-1110762026-04-02T02:43:51ZJACQUELINE—GRANT12/02/1978UHC-43018-83•••-••-59897108128830jacqueline.grant@icloud.com9887 SPRING ST #854CharlotteNorth Carolina28269GRP-2597MEDICARE-ADV-B
ENRENR-1334652026-05-22T11:53:44ZMARK··—HERNANDEZ·11/13/00UHC-59408-49•••-••-61779227518837—6600 Elm StreetGILBERTAZ85256·GRP-9305CORE-HMO
ENRENR-1060232026-09-10T09:35:19Z Hiroshi—Li1965-02-27··UHC-68933-39•••-••-73593893686392hiroshi.li@proton.me4513 Lincoln WayNashvilleTN37208GRP-2080MEDICARE-ADV-B
ENRENR-1159682026-08-17T09:14:08ZStephen—Hayes03/20/54UHC-21260-70•••-••-0699+1 643 347 1467STEPHEN.HAYES@OUTLOOK.COM3539 Union StreetScottsdaleAZ85203GRP-0955··CHOICE-PLUS-PPO
ENRENR-1048292026-06-14T15:35:57ZmeiY.mendoza1963-80-04uhc-90746-47•••-••-85846364097441MEI.MENDOZA43@HOTMAIL.COM8355 Pine DriveGilbertAZ85299GRP-2180CHOICE-PLUS-PPO
ENRENR-1375612026-07-24T15:52:48ZHIROSHI—TUCKER1991-09-26UHC-97146-79•••-••-08327358520018hiroshi.tucker90@gmail.com1742 Washington Street·AtlantaGA30300GRP-3383··MEDICARE-ADV-A
ENRENR-1397022026-09-16T08:00:14ZSharonSBrooks1973-01-21UHC-47249-88•••-••-7668447-218-4819sharon.brooks50@hotmail.com7716 Church StSCOTTSDALEaz85212GRP-4588options-ppo
ENRENR-1345702026-04-29T13:14:01ZANDREA—ELLIOTT07/09/1976UHC-77603-42•••-••-3442+1 793 728 6264—5558 BASELINE ROADLAS VEGASNV89192-8299GRP-8460MEDICARE-ADV-A
ENRENR-1003012026-06-22T20:25:42ZLaura—Wood20020906UHC-73210-09•••-••-217417196073533laura.wood77@outlook.com2088 Union StSeattleWA98145GRP-9111··MEDICARE-ADV-A
ENRENR-1212142026-05-12T07:54:38ZGeorge·EFisher23-03-1961UHC-84057-85•••-••-8938(833) 698-6277-1435 GRAND AVENUEDallasTX75251-0912GRP-4420MEDICARE-ADV-A
ENRENR-130009 2026-03-06T07:37:11ZDianeCSmith2/1/1965UHC-11502-72•••-••-65414476701230—7482 Meadow LnMiamifl33176GRP-1436OPTIONS-PPO
ENRENR-1396672026-09-20T13:12:58ZAmber·KRussell19471021UHC-13855-37•••-••-8934(711) 809-3265—9449 MAIN STTempeAZ·85283GRP-1012NAVIGATE-HMO
ENRENR-1305562026-03-07T17:24:50Zyuki—wright·1986-02-22UHC-59968-86•••-••-5612(946) 683-5588yuki.wright@icloud.com9017 Pine DrJacksonvilleFL32241GRP-6785SELECT-EPO
ENRENR-1183552026-05-06T20:48:37ZElijahITaylorApr 15, 1986UHC6176009•••-••-67843363689075-5130 Highland AveDallas·TX75270GRP-2206NAVIGATE-HMO
ENRENR-1010352026-09-13T06:13:34Z Adam—Anderson··1956-04-18UHC-78727-50•••-••-11807045711048—2882 Grand AveAustinTX78727-3822··GRP-8071OPTIONS-PPO
ENRENR-1130702026-04-12T19:30:53Zsandra··Ahoffman··1968-03-22UHC-72456-92•••-••-2769·(924) 479-1907sandra.hoffman51@icloud.com8251 Willow Court··OrlandoFL32825GRP-1399SELECT-EPO··
ENRENR-1128392026-07-28T11:15:29ZALEXANDERKBRYANT17-10-1972UHC-16087-50•••-••-4045(307) 663-6225ALEXANDER.BRYANT@AOL.COM8443 Indian School Rd #518Seattle··WA98124GRP-9790OPTIONS-PPO
ENR ENR-1428032026-07-23T03:08:52Z CHRISTINAFWILLIAMS19961221UHC-25299-76•••-••-69184427525175CHRISTINA.WILLIAMS@GMAIL.COM9383 Ocean Ave Apt 17TucsonAZ85705GRP-1370OPTIONS-PPO
ENRENR-1217212026-04-08T13:05:07ZWilliam—Dixon19651014UHC-96330-91•••-••-2139·+1 439 323 9148william.dixon@yahoo.com9245 PINE DRIVE·MiamiFL-GRP-3013MEDICARE-ADV-B
ENRENR-1098972026-03-25T14:47:27ZRACHELL··REYES12/3/1990UHC-94617-20•••-••-1681(724) 611-8176rachel.reyes@gmail.com3174 RIDGE RDMinneapolisMinnesota·55459GRP-4267CORE-HMO
ENRENR-121962 2026-06-21T17:43:04ZLawson, EdwardH.—1982-04-04UHC-29283-46•••-••-7187(977) 583-8497EDWARD.LAWSON@ICLOUD.COM8410 Apache BlvdNASHVILLETNN/AGRP-8622CORE-HMO
ENRENR-1100182026-10-03T14:19:49ZAlan····ShawJul 21, 1997UHC-21401-15•••-••-4128+1 935 913 2370alan.shaw53@aol.com5641 River RoadCOLUMBUSOH43287GRP-2467··MEDICARE-ADV-A
ENRENR-1013732026-09-19T21:18:16ZSOPHIARHENRYNov 4, 1981UHC-79809-95•••-••-4450nullsophia.henry64@proton.me8262 VALLEY VIEW DRIVESAN ANTONIOTX78238GRP-8755SELECT-EPO
ENRENR-1126902026-09-20T05:44:06ZSEANJ.JORDAN1959-01-07UHC-23609-15•••-••-4035(915) 422-9841-5294 GRAND AVETempeAZ85201GRP-1644CHOICE-PLUS-PPO
ENRENR-1184002026-07-03T05:47:09ZElijahKHudson1967-07-17UHC-28101-71•••-••-28483532080370—4748 Apache Boulevard #434Nashvilletn—GRP-4547MEDICARE-ADV-A
43,101 rows, page 217 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:40.594Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty