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-1334462026-02-17T16:11:49ZEric—Moreno19740903UHC-96118-34•••-••-7237(667) 498-6759-··2639 Harbor BoulevardMesaAZ85299GRP-4304SELECT-EPO
CLMCLM-4047852026-01-18T00:29:25ZChristian—Salasar··1994-10-08—•••-••-2976····—nullnullN/ANULLGRP-4032NAVIGATE-HMO
ENRENR-1191372026-04-06T01:26:50ZJoiceATran1939-04-24uhc-45030-13•••-••-8326(544) 629-0568N/A3124 Grand Avenue #749MiamiFlorida33162-3227··GRP-2908OPTIONS-PPO
ENRENR-1094262026-05-07T13:53:02ZBillyZBaker03/22/2008UHC-91951-40UNKNOWN(464) 983-5518—7750 SUNSET BOULEVARDSeattleWAUNKNOWN··GRP-0482CORE-HMO
TPATPA-540222026-07-09T07:10:17ZSAM—SPENCER02/23/1959—nullUNKNOWNUNKNOWN1630 Lake View RoadDallasTX75202—MEDICARE-ADV-B
CLMCLM-4199332026-01-19T06:12:15ZKATHRYN—HARVEY1939-06-06UHC-96992-41•••-••-1378····KATHRYN.HARVEY35@ICLOUD.COM—-null—GRP-1806null
CLMCLM-4173132026-08-31T08:55:14ZWheeler, JasonA.··1954-08-10UHC-04921-58N/A17058205106NULL--··—-UNKNOWN—
ENRENR-1411962026-05-28T17:40:06ZPriyaNJames1/11/1976UHC-56355-15•••-••-943813105964427priya.james@proton.me1251 Indian School Rd·SeattleWA98170-8323GRP-4590OPTIONS-PPO
CLMCLM-4093862026-05-14T08:56:48ZEvelyn··—Andrews1946-01-27UHC-11362-59UNKNOWN··-NULLNULLN/AN/ANULL··UNKNOWNSELECT-EPO
ENRENR-1084292026-03-12T06:03:43ZJohnstonV.Ryan11/26/83UHC-51949-51•••-••-1447394-749-2415····3311 Mountain View DriveTampaFL33669GRP-3548CORE-HMO··
CLMCLM-4022722026-09-24T17:59:47ZDENNYCSANDERS1982-03-12—N/ANULL-4095 MEADOW LNNashvilleTN37259—N/A
ENRENR-1191142026-05-06T22:45:53Zmateo—perez2003-01-14UHC-46817-61•••-••-6138(900) 939-4352mateo.perez@gmail.com2630 Maple AvenueTampa··Florida33636GRP-7687·NAVIGATE-HMO
TPATPA-556972026-08-21T01:23:54ZSCOTTUJORDAN19650217——-—7935 Desert Sky Blvd Apt 5FresnoCA··93744NULL·-
ENRENR-1220122026-06-10T18:28:35Z BrandonFMorris·1961-09-27UHC-64581-74•••-••-2377+1 582 963 1175brandon.morris50@hotmail.com3009 MAPLE AVETampa··FL33626GRP-3120SELECT-EPO
CLMCLM-429301 2026-03-04T07:05:44ZRonald—Jimenez19421025UHC-03548-71UNKNOWN(612) 779-7056-N/A—N/AN/AGRP-4268null
ENRENR-1101212026-08-21T01:44:10ZMICHELLEO.LUNA2001-07-03UHC-80345-60•••-••-4033N/A·MICHELLE.LUNA1@HOTMAIL.COM2555 Pine Drive··Los Angeles·CA90092GRP-5396CORE-HMO
ENRENR-1339442026-09-12T09:13:02ZstephanieS.collins12/6/1959UHC-83864-87•••-••-56298162159665stephanie.collins@outlook.com195 Main StreetDallasTX75253··GRP-9790CHOICE-PLUS-PPO
CLMCLM-4244432026-10-14T16:31:38ZRiz, RalphA··—14-05-1950UHC-42464-05•••-••-749918179605979—5738 Valley View Drive··MESAaz85298GRP-6814N/A
CLMCLM-4297122026-08-21T18:50:11ZRobert··Walker1988-05-09UHC-76321-65•••-••-8157NULL·N/A-——N/AnullCORE-HMO
ENRENR-1413012026-09-09T06:08:05ZJezse U.—Bennett1940-12-16UHC-57219-23•••-••-09749488340392JESSE.BENNETT@PROTON.ME3288 Forest AveJacksonvilleFL32201GRP-2611SELECT-EPO
TPATPA-521792026-03-23T13:23:34ZCHARLES—LANE1953-12-13UNKNOWNNULL832-724-4393-2643 Washington StreetSeattleWA····—NAVIGATE-HMO
CLMCLM-4300492026-02-08T07:41:04ZWilliam—Russell1965-03-03UHC-23538-66•••-••-1065N/Awilliam.russell@aol.com4366 Cedar LnLos AngelesCA90084GRP-5009NULL
PRVPRV-201132026-06-25T22:15:56ZAARONUHARPER11/02/2008UHC-06862-81—2896341496UNKNOWN—————-
CLMCLM-4076692026-10-15T01:47:10Zkevin—scott1977-09-05UHC-95333-52•••-••-2664NULL·NULL6262 Apache BoulevardCOLUMBUSOH··43216GRP-2002—
ENRENR-1394392026-05-23T14:37:22Zlawrence—hoffman1971-02-10UHC-12016-65··•••-••-0088953-943-2023lawrence.hoffman10@hotmail.com5415 River RoadMinneapolisMinnesota55416-9199GRP-3130SELECT-EPO
ENRENR-1237642026-01-08T17:01:00ZAnaEMorgan11-12-1970UHC-89767-67—9302634432UNKNOWN8899 BroadwaySCOTTSDALEArizona85296GRP-7550CHOICE-PLUS-PPO
PRVPRV-207442026-07-28T21:26:21ZJoshua—Lane08/05/08—•••-••-08417074910819JOSHUA.LANE@ICLOUD.COM3732 Maple Avenue··SacramentoCA95899—NULL
ENRENR-1001642026-10-14T08:12:53ZNancy—PatelMay 17, 1982UHC-76230-29•••-••-004313948821622NANCY.PATEL@OUTLOOK.COM5592 Oak StTucsonAZNULLGRP-4884OPTIONS-PPO
ENRENR-1053882026-02-22T05:14:20ZKathryn—Diaz1991-05-13UHC-61746-34•••-••-18465030036·N/A5960 Palm DrGLENDALEAZ85310GRP-7416OPTIONS-PPO
CLMCLM-4250512026-03-14T20:30:37ZOrtiz, Charles N——04/02/38UNKNOWN•••-••-9223951-924-6952-6243 HILLCREST ROADGLENDALEAZ85395··GRP-8629·NULL
ENRENR-1389422026-09-04T11:02:12Z ARJUN—MARTINEZApr 11, 1977UHC-00639-60•••-••-1967626-365-0166arjun.martinez@icloud.com5901 CENTRAL AVEPhoenixAZ85091GRP-7449··CORE-HMO
ENRENR-1125372026-09-12T18:43:49ZLarson—Jen21-06-1989UHC-10361-83•••-••-2353(265) 533-0194-4725 Elm StPhoenixAZ85048GRP-5773SELECT-EPO
CLMCLM-4323042026-01-20T06:14:42ZKAYLA—VALDEZ1938-05-23nullNULL—null8475 LINCOLN WAYChandlerAZ85247GRP-9072NULL
CLMCLM-4050842026-06-04T21:19:10ZJudith—Lopez2002-05-16—•••-••-0967——9047 BroadwayGlendaleAZ85316GRP-1165N/A
CLMCLM-4235602026-09-25T01:27:26ZGary—Owens1976-10-19UHC-31774-69—407.517.9620gary.owens76@outlook.com·3992 Park PlGilbertaz85205GRP-4578—
ENRENR-1187212026-01-19T10:05:41ZKEITH—OWENS19951016··UHC-04440-15•••-••-0822(246) 794-0638KEITH.OWENS57@OUTLOOK.COM2171 Baseline Rd·MinneapolisMN55445GRP-2139CHOICE-PLUS-PPO
PRVPRV-212722026-06-21T13:06:57ZGregory—Ward·19810122UHC-42600-61···null(422) 714-3570—886 Bayshore DriveMiamiFL33159N/A·CHOICE-PLUS-PPO
PRVPRV-252782026-01-15T01:49:55Z ROGERHNELSON1989-06-14·N/ANULL19684758967roger.nelson28@aol.com1103 DESERT SKY BLVDTucsonAZ85733N/A-
ENRENR-1237092026-10-04T10:15:55ZAlexis··FHowell2005-09-05UHC-00431-38•••-••-47785859599109··—128 CEDAR LANEFresnoCA93746GRP-5532NAVIGATE-HMO
PRVPRV-271532026-08-08T12:24:10ZDEBORAH—VARGAS·19440626··—409-643-3678deborah.vargas@gmail.com4953 APACHE BOULEVARDMinneapolisMN55473·nullN/A
ENRENR-1430062026-01-22T06:54:05ZMadison A—Taylor1976-11-16UHC-93143-71•••-••-1211698-379-4310-·2393 Canyon RoadGILBERTAZ85235GRP-4542SELECT-EPO
ENRENR-1418382026-09-12T22:39:01ZAnaP··Lewis··1951-03-11—•••-••-4803392-466-9478ana.lewis40@proton.me7077 Palm Drive #323AustinTX78718-7605GRP-8304MEDICARE-ADV-A
ENR ENR-1308822026-01-09T03:52:05ZChalrotte—Chen19780120··UHC-29497-60•••-••-4199758.779.6006charlotte.chen@proton.me5075 Canyon RdSEATTLE·WA98148GRP-5903CORE-HMO
PRVPRV-231492026-03-28T16:07:21ZChreyl—Kennedy1982-09-19UHC-14493-37•••-••-8363316-279-2853null2547 WASHINGTON STREETPlano·TX75005null·null
CLMCLM-4173202026-03-20T15:53:09ZALEXIS—WALKER1962-07-15····-N/AUNKNOWN2604 HIGHLAND AVEPhoenixAZNULLGRP-2072CORE-HMO
ENRENR-1416142026-03-17T01:08:22ZharoldYalvarado1974-10-05uhc-97987-12-424-762-2889NULL2637 CHURCH STREETSan AntonioTX78216GRP-8855CHOICE-PLUS-PPO
ENRENR-1088892026-06-11T00:18:35ZMarthaS.Walker1980-04-09UHC-95006-84•••-••-0134(669) 943-8139·null5060 BROADWAYLos AngelesCA90067GRP-3008CHOICE-PLUS-PPO
ENRENR-1120452026-06-11T18:56:37ZLogan—Phillips19860417UHC-77399-76•••-••-4503651-221-4377··9755 Bayshore DriveMINNEAPOLISMN55411GRP-0646SELECT-EPO
CLMCLM-414866 2026-01-21T04:15:55ZJEREMY····WILLIAMSON1975-07-08UHC-70103-18•••-••-7435UNKNOWN—nullnullnull—·GRP-7947-
CLMCLM-418923 2026-07-05T12:27:06ZMary····Miller···11/17/1940UHC-95565-83•••-••-9365—NULL9265 SUNSET BOULEVARDMinneapolisMN···55476GRP-4373NAVIGATE-HMO
100,000 rows, page 128 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.689Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty