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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1087212026-04-24T02:28:14ZSinghS.Brenda1999-05-10UHC-58435-51•••-••-2751676-242-0877NULL7872 Indian School RoadGlendale·Arizona85389GRP-5839CHOICE-PLUS-PPO
CLMCLM-4054932026-03-13T02:44:15Z Rachel—Wheeler1968-04-06uhc-03328-76•••-••-5356····NULL3159 River RoadChandlerAZUNKNOWN·GRP-6068·NULL
PRVPRV-231722026-01-29T14:10:26ZNatalie—Banks1989-04-09UHC-97535-49•••-••-7272·6464522147—7508 Jefferson AvenueSeattleWA98177null—
ENRENR-104579 2026-10-05T00:17:56ZBowman, Patricia——2/14/1989UHC8244860··•••-••-80134585137889PATRICIA.BOWMAN@PROTON.ME201 Hillcrest RdColumbusOHUNKNOWNGRP-8046SELECT-EPO
CLMCLM-4149812026-04-12T01:47:22Z·Priya B.—Rice1956-12-11UHC-92535-76N/A12084330337··9320 Bayshore DrChandlerAZ85250GRP-3056NAVIGATE-HMO··
CLMCLM-4114672026-07-09T19:35:57Z·Nicole—·Elliott1954-07-08UHC6081781—-——NULL··-N/A······
CLMCLM-4185482026-02-25T09:44:24ZRUSSELL—POWELL22-10-1939UHC-73379-98•••-••-5979N/ARUSSELL.POWELL93@OUTLOOK.COMnullnull—-—N/A
ENRENR-1384562026-02-01T05:40:07ZdonaaldCespinoza1943-12-26UHC-52321-03•••-••-9364+1 861 380 8046··donald.espinoza5@proton.me9490 Union StreetOrlandoFL32806GRP-3305SELECT-EPO
ENR ENR-124710 2026-04-24T18:26:50ZStone, Linda··——19851114UHC-66695-10•••-••-4079·12404287313LINDA.STONE64@HOTMAIL.COM3121 Main StreetScottsdaleAZ85213··GRP-5955CHOICE-PLUS-PPO
ENRENR-1378932026-06-09T08:39:28Z carlPchapman1972-03-02UHC-14869-57•••-••-8272230-335-7304carl.chapman15@proton.me7757 Hillcrest Road··COLUMBUS·OHNULLGRP-2890CORE-HMO
ENRENR-1070112026-05-26T14:15:36ZBarbara—Simmons1966-11-20·UHC-72880-67•••-••-7927(915) 956-1852-3632 Sunset BlvdHoustontx77080GRP-9522·SELECT-EPO
ENRENR-1080652026-06-04T04:41:09ZAlexanderP.McCoy02/21/1942UHC-33082-26N/A606-892-4506—5925 HILLCREST ROADOrlandoFL32833GRP-2774MEDICARE-ADV-A
CLMCLM-405379 2026-07-10T19:44:24ZRonald··—Sims1983-08-21UHC-85514-63null——2231 Church StreetFresno·CA93729GRP-8355CORE-HMO
PRVPRV-214512026-10-06T13:20:38ZWallace, Peter——2/10/1974··UHC-28274-41•••-••-4028—null—NULL·null····—null
ENRENR-1171662026-01-24T09:25:24ZRivera, Barbara——4/26/1996UHC6424952•••-••-0956UNKNOWNbarbara.rivera81@gmail.com3211 Main StreetPlanoTX75077GRP-3314MEDICARE-ADV-A
ENRENR-106218 2026-05-15T18:14:46ZamandaErogerrsNov 21, 1965UHC-64231-47··•••-••-27769688486813AMANDA.ROGERS@OUTLOOK.COM-N/A-·NULLGRP-7374OPTIONS-PPO
PRVPRV-247602026-06-24T11:24:18ZChirstian—Edwards1977-03-19UHC-82513-35null—·christian.edwards@gmail.com—nullN/AN/A-null
ENRENR-1216442026-02-14T06:45:19ZLynch, JeanP.—1996-12-23UHC-03327-17•••-••-9325735-864-4371—5840 Spring StSACRAMENTOCA95860-2051GRP-9849OPTIONS-PPO
ENRENR-1223322026-04-13T03:00:28Z·Mark A—Contreras6/5/1994UHC-18319-57•••-••-3761365-335-9957mark.contreras@hotmail.com4270 OCEAN AVE #399PlanoTexas75036GRP-4070·CORE-HMO
ENRENR-1155072026-02-16T02:58:06ZTERESA·SKNIGHT1969-10-26UHC-05402-97•••-••-4155(698) 540-5208teresa.knight4@outlook.com9898 Apache BoulevardMesaAZ85208-0089GRP-0124MEDICARE-ADV-B
TPATPA-548292026-01-24T08:25:57ZLUIS—CLARK1983-08-07NULL—·-—8275 Church StColumbusOH43264N/AMEDICARE-ADV-B··
ENRENR-1284822026-10-08T18:02:14ZJEAN—RAMIREZ03/05/05UHC-02634-12··•••-••-2437(537) 672-5919jean.ramirez@aol.com6452 Pine DriveHoustonTX77072··GRP-1948··CORE-HMO
CLMCLM-4196742026-03-15T13:35:47ZnoahFmoore·1963-07-27UHC-12184-09•••-••-4948-—NULL-NULL—GRP-4932—
ENRENR-1327242026-03-23T08:40:26ZMARKO··WEBER2004-03-02UHC-65837-43•••-••-32173589842492MARK.WEBER9@AOL.COM7694 Central AvenueScottsdaleAZ85219GRP-1874select-epo
CLMCLM-4293232026-07-25T15:47:23ZJORDAN—ROBERTSON13-09-1979-··•••-••-0692—····1875 Ocean AveTempeAZ85216-4989GRP-3661OPTIONS-PPO
CLMCLM-4068552026-09-27T11:29:53ZNancy—Spencer09/06/08UHC-62462-17•••-••-98316803761098UNKNOWN6931 Ocean AveCharlotte··NC28255··UNKNOWN-
CLMCLM-4275122026-06-19T14:22:52ZKimberly—Gordon2006-12-28UHC-89560-95N/A+1 784 584 5260—1992 MOUNTAIN VIEW DRCharlotteNC28288-6913GRP-9801··-
PRVPRV-265662026-01-03T04:23:19ZRUTH—OLSON1960-10-19UHC-37143-79•••-••-1713nullRUTH.OLSON29@HOTMAIL.COM8833 Sage CtSeattle··WA98120—OPTIONS-PPO
CLMCLM-4281302026-05-29T03:15:40ZRuthM.Meyer2004-06-19UHC-88349-27··•••-••-0378—N/A8704 Central AveGlendaleAZ85341·GRP-3069MEDICARE-ADV-B
ENRENR-1006552026-02-20T07:25:35ZRaymond··YThomas1948-12-06UHC0932920··•••-••-7371—null9463 Bayshore DriveTampaFL33691GRP-3532SELECT-EPO
ENRENR-1129482026-06-11T18:10:40ZJOEX.THOMAS1980-08-27UHC-66607-08•••-••-072214176737554joe.thomas@proton.me8428 Camelback RoadLos AngelesCA90052GRP-9209SELECT-EPO
ENRENR-1400322026-03-26T19:53:28ZPAMELA··—GUZMAN·1982-06-11UHC-98619-77•••-••-8256+1 409 588 1018—9168 Mountain View Drive·TempeAZ·85257GRP-5175MEDICARE-ADV-A
CLMCLM-4291092026-10-14T07:00:06ZTerry—YoungDec 26, 2003UHC-16318-17—UNKNOWN-116 Baseline RdHoustonTX77015-1921GRP-5918SELECT-EPO
CLMCLM-4254532026-09-17T10:51:42ZScott—Gibson06/02/04····—-UNKNOWN5853 Lake View Road··MiamiFL33153GRP-4659-
TPATPA-554212026-05-23T15:54:25ZLawrence—·Watson1995-10-04UNKNOWN•••-••-7664N/A—9551 CAMELBACK RD #710MINNEAPOLISMN55483GRP-7217UNKNOWN
TPATPA-576722026-10-05T16:59:16Zemily—harris1968-10-25—•••-••-0697UNKNOWN··—N/A—nullnullUNKNOWN
ENRENR-1314532026-07-07T09:21:05ZDebraFHanson05/14/52UHC-88261-03•••-••-66028846283798UNKNOWN2273 MAIN STSAN DIEGOCA92196GRP-0395OPTIONS-PPO
PRVPRV-258982026-05-10T11:47:12ZLucia—Jenkins1962-08-09nullUNKNOWN251.763.6966—2112 Sunset BoulevardColumbusOH43253—OPTIONS-PPO··
CLMCLM-4176582026-07-10T23:29:55ZCARLOS—MCCOY1981-10-23——N/A—5251 Main StreetTampaFL33640NULLnavigate-hmo
ENRENR-1311012026-03-30T11:17:39ZLisaM.·Knenedy1957-11-10UHC1314963•••-••-3420+1 651 934 5047LISA.KENNEDY@YAHOO.COM5138 Harbor BoulevardMesaAZ85204-9631GRP-3296MEDICARE-ADV-B
CLMCLM-4124192026-08-01T04:39:51ZGeorge—·Little1999-10-12·UHC-09315-33UNKNOWN(521) 984-5136NULLnullnullnullnullGRP-8965-
ENR ENR-1027282026-04-26T01:03:11ZKYLEYHOFFMAN11/15/1939UHC-39224-93—(542) 367-7413-1424 Park PlaceTampaFL33697GRP-0227core-hmo
ENRENR-1145342026-10-13T12:15:32ZELIZABETHSTUCKER1981-04-25UHC-35219-28null657-679-5291elizabeth.tucker60@proton.me9246 Main StreetMiamiFL33164GRP-5585MEDICARE-ADV-A
TPATPA-517172026-09-06T23:01:41ZPrice, Philip··F—1999-11-07—NULL15548342963philip.price@yahoo.com1953 HILLCREST ROADGILBERTAZ85296-2957—NULL
PRVPRV-283982026-01-24T22:07:34ZMarianaKHenry1946-04-24nullNULL2368291588—4336 DESERT SKY BLVDMesaAZ85237-9502UNKNOWN·UNKNOWN
ENRENR-1244672026-05-28T18:38:56ZCATHERINE—COLEMAN08/12/2004UHC-75249-39•••-••-926915508284224catherine.coleman@gmail.com4690 Camelback RdSan AntonioTX78292GRP-9124CORE-HMO
CLMCLM-4117522026-09-08T05:32:07ZEMILY—THOMPSON2/27/1964UHC-60492-22—858-356-0260N/A7291 Mesa Drive Apt 35CharlotteNC28216GRP-0562—
CLMCLM-4140562026-01-28T00:41:22ZChapman, Amanda—··1950-09-03·UHC-94916-77•••-••-1346766-787-5967amanda.chapman52@icloud.com6464 Maple Ave #624MiamiFL33137GRP-3738NULL
CLMCLM-4226532026-10-03T02:11:28ZLORI····LI16-05-2000UHC-86987-56•••-••-7122(213) 752-9288UNKNOWN··7785 Ocean AvenueSan Diegoca92124-8605NULL—
CLMCLM-4113682026-06-15T17:37:57ZJonathanEWheeler—····NULL9602096387—null——-GRP-4743OPTIONS-PPO
100,000 rows, page 186 of 2,000PreviousNext

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.716Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty