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

Claims only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
CLMCLM-4248172026-08-31T14:26:50Z JUSTIN—GORDON1988-03-01UHC-82612-26•••-••-76873913676—2293 Union StDENVERCO80284GRP-2110MEDICARE-ADV-A
CLMCLM-4043252026-03-09T05:36:41ZKelley, Brenda——19390906UHC-29633-02··•••-••-8946237-601-5830—1801 PARK PLDallasTX75207GRP-8707SELECT-EPO
CLMCLM-4047822026-08-20T12:05:13Zmateo—jensen19510524nullnull+1 576 867 3999-null·UNKNOWNnullNULLUNKNOWNnull
CLMCLM-4254052026-07-28T14:58:39ZJEREMY—·CRUZJul 6, 1952·UHC-05311-82•••-••-3042(364) 486-5549—6553 River RdORLANDOFL32829-MEDICARE-ADV-A
CLMCLM-4203302026-08-13T16:01:17ZKYLE··SMITH21-10-1984UHC-47052-61·-600.958.2377NULL2161 Jefferson AvenueOrlandoFL32827GRP-4203·OPTIONS-PPO
CLMCLM-4201032026-05-09T02:55:54ZASHLEY—PARKMar 25, 1984UHC-77999-99nullNULLN/A5422 MEADOW LANEMIAMIFL33129GRP-6725CHOICE-PLUS-PPO
CLMCLM-4237992026-08-30T17:09:21Z ISABELLAEALLEN1928-11-27·UHC-40176-31—9269187387—5683 Palm DriveTucsonAZ85787GRP-9885CORE-HMO··
CLMCLM-4242872026-01-24T19:21:15ZWilliam··—Salazar1969-07-12UHC-91974-52—225-924-8488NULL4437 Valley View DriveNASHVILLETN37225GRP-8327CORE-HMO
CLMCLM-4280072026-09-12T20:06:57ZDebra—FranklinSep 6, 1981UHC-11815-41•••-••-1497—-1835 BASELINE ROAD·JacksonvilleFL32238GRP-3656-··
CLMCLM-4014772026-02-27T03:30:39ZAustin—Stevens19920612UHC-53338-41—737-668-8370···N/A-NULL··—NULL—
CLMCLM-4250922026-04-15T20:05:35ZGrace—Dominguez11-10-1971UHC-38982-72—-UNKNOWN··1991 BroadwaySAN DIEGOCA92156-7019····SELECT-EPO
CLMCLM-4096222026-01-17T16:27:19ZLarry—Moore1979-07-17-•••-••-2779-—399 Sage CourtSacramentoCalifornia95808GRP-5705CHOICE-PLUS-PPO··
CLMCLM-4247882026-10-10T16:09:21ZCamila—Coleman1960-01-21··N/A-NULL—2961 CEDAR LANETampaFL33609·null·CHOICE-PLUS-PPO
CLMCLM-4022862026-08-17T20:35:01ZOlivia··Grant·7/23/1994UHC5090376··——UNKNOWN··631 Camelback RoadCHARLOTTENC28253-2194UNKNOWNN/A
CLMCLM-4200532026-01-26T00:55:59ZAUSTINR·MARTINEZ05/20/2003—•••-••-4216—NULL2801 PARK PLLOS ANGELESCA·90064GRP-2792MEDICARE-ADV-A
CLMCLM-411342 2026-04-15T10:34:46ZOlivia—Stewart1/24/1941UHC-02547-28•••-••-4751(393) 634-9878—2403 VALLEY VIEW DRGilbertAZ85278N/ACHOICE-PLUS-PPO
CLMCLM-4214322026-06-09T12:33:23Zlucia····vazquez1970-06-11··N/ANULL(633) 759-9464····4165 Meadow LaneFresnoCalifornia93711—MEDICARE-ADV-B
CLMCLM-4282422026-04-14T07:10:13ZAlice—Cruz01/08/39UHC-28830-68·UNKNOWN····—4350 Meadow Lane Apt 20HoustonTX77029N/A—
CLMCLM-4129292026-01-05T11:52:06ZMEGAN—·BOYD04-11-1991UHC-11001-98NULL·417-613-1011—4484 BAYSHORE DRIVE·COLUMBUSOH43238GRP-5237—
CLMCLM-4256312026-01-17T01:20:40ZEmilyA.Dunn1957-02-18—UNKNOWN--3708 LAKE VIEW ROADHoustonTX77032GRP-2096CHOICE-PLUS-PPO
CLMCLM-4122632026-05-02T17:19:35ZCheryl····Bishop1951-11-16UHC-61142-38N/AUNKNOWN—9801 CEDAR LNSeattleWA98115··——
CLMCLM-4226052026-08-26T21:01:07Z ·DYLAN·RRAMOS1961-07-22NULL—·8185998585—N/A-——GRP-3610NULL
CLMCLM-4170272026-02-15T17:20:10Zgerald—hamilton19861002UHC-33520-63•••-••-8241+1 442 846 9240··-6006 Spring St··San AntonioTX·78237N/ASELECT-EPO··
CLMCLM-4082332026-04-12T04:37:29ZJACQUELINE····MOOREMar 14, 1995UHC-13379-89•••-••-9482NULL—9435 BroadwayHoustonTX77087·GRP-6649OPTIONS-PPO
CLMCLM-4238882026-05-24T18:18:40ZJudy—Montgomery1962-02-14UNKNOWN-7003875748UNKNOWN··6221 CENTRAL AVEEden PrairieMN55388GRP-7268SELECT-EPO
CLMCLM-4220232026-09-06T08:24:37ZRYAN—EDWARDS2000-05-08UNKNOWNUNKNOWN497-304-2142-638 Church Street··GilbertAZ85260GRP-3764MEDICARE-ADV-B
CLMCLM-4248802026-09-09T02:04:21Z·Mason—Price1971-09-26UHC-45042-06•••-••-5884·(712) 470-1790—2697 Hillcrest Road Apt 39CharlotteNC28231GRP-5357N/A
CLMCLM-4112112026-02-12T05:08:24ZMadison—Rivera1984-04-07UHC-25876-36——MADISON.RIVERA67@HOTMAIL.COM6960 BroadwayTucsonAZ85702—SELECT-EPO
CLMCLM-405136 2026-03-11T02:05:50ZBobby—Rios1940-05-27UHC-55415-79•••-••-5312N/Abobby.rios73@yahoo.com4383 Apache BlvdHoustonTX··77083N/A··—
CLMCLM-4138762026-03-27T14:56:24ZHenry—Reynolds1964-10-26UHC-48672-91-N/A—3404 Central AveFresnoCalifornia93797nullCHOICE-PLUS-PPO
CLMCLM-4228122026-03-23T09:52:02ZChristina—Burke·05/26/04—•••-••-9548445-293-4401—····NULL-··GRP-8681CORE-HMO
CLMCLM-4203552026-03-03T20:28:00ZJessica—McCoy10-01-1952UHC-14823-28N/AUNKNOWNnull2580 Hillcrest RoadJacksonvilleFL32287GRP-4521—
CLMCLM-4288362026-10-11T23:32:58ZWalsh, Ashley—····1961-10-13····—452-228-1878null7897 Palm DrNashvilleTN-GRP-2138UNKNOWN
CLM CLM-4027762026-01-07T07:15:25ZSteven—Bell22-01-1987··UHC-72953-34null(318) 591-4211—-nullN/ANULL··NULLNAVIGATE-HMO
CLMCLM-4097862026-07-16T23:39:38ZWelh, Cheryl——1938-01-06UHC-07157-28UNKNOWNN/AN/Anullnull··—-·GRP-0372MEDICARE-ADV-B··
CLMCLM-4080232026-05-11T11:50:47ZAngela—Salazar1979-06-05UHC-63436-64··•••-••-3141·-—5809 MOUNTAIN VIEW DRMinneapolisMN··55406GRP-7348-
CLMCLM-4065662026-10-02T07:03:16ZAnthony—Rios1984-09-02UHC-38512-88—null—5354 Camelback Rd #268Gilbertaz85246-3873GRP-2495SELECT-EPO
CLMCLM-4143082026-10-10T21:08:55ZTimothy—Hunt··12/17/1987UHC-84563-77null239-313-8431··-null——N/AGRP-1819MEDICARE-ADV-B
CLMCLM-405117 2026-06-15T22:13:24ZMARIAT.ORTEGA19530524UHC-21435-18·NULL2319362824—5472 Oak StreetAUSTINTX78714NULL-
CLMCLM-4218052026-02-15T06:04:22ZHelen—Watson09-09-1971—•••-••-9112644-596-4399—4667 RIVER RDMinneapolisMN55423—·UNKNOWN
CLMCLM-4279762026-04-19T04:27:47ZAisha—Peterson··07-04-1978UHC5037882•••-••-7031—null-UNKNOWN····—GRP-6805MEDICARE-ADV-A
CLMCLM-4228252026-08-04T01:53:16ZDIANE—HUNT7/11/1974-UNKNOWNUNKNOWN····772 BAYSHORE DRAustinTX78781GRP-2583UNKNOWN
CLMCLM-4059892026-01-17T09:50:31ZJOSHUA··BMARSHALL1942-20-26··—•••-••-0695··NULL8078 Canyon RoadMesaAZ85266nullCORE-HMO
CLMCLM-4089802026-10-01T09:19:59ZKathryn—Tran1970-07-24UHC-64928-64··•••-••-1846(687) 384-8250—UNKNOWN—·UNKNOWNN/A—SELECT-EPO
CLMCLM-4096592026-05-13T16:24:39ZalexanderLwells1963-06-07——288.357.5441null6815 HARBOR BOULEVARDSACRAMENTOCA95852GRP-3935—
CLMCLM-4001872026-03-08T11:50:07ZYuki P—Fuller01-01-2003UHC-56196-75•••-••-7960——UNKNOWN——-GRP-2554options-ppo
CLMCLM-4303932026-04-23T18:22:22ZROGER—BAILEY1991-01-21UHC-31418-13•••-••-7014nullN/A—UNKNOWNnullN/A··GRP-4154MEDICARE-ADV-A
CLMCLM-4272482026-04-21T17:38:37ZBruke—Vega04/17/1971··—•••-••-64044652547967—N/A··UNKNOWN——GRP-9185·null
CLMCLM-410039 2026-05-11T10:18:24ZJASONMMILLS1986-04-22——3524226638jason.mills@aol.com··2460 Grand AvenueTampaFL··33639—CHOICE-PLUS-PPO
CLMCLM-4092292026-03-25T19:12:55ZJOE—CASTILLO1971-02-06——6245948061NULL4630 CHURCH ST·TampaFL33600GRP-6871CHOICE-PLUS-PPO
32,829 rows, page 166 of 657PreviousNext

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