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
CLMCLM-4019182026-05-28T22:27:05Zmary—masonAug 6, 1994UHC8523294nullN/ANULL9474 LAKE VIEW ROADAustin··tx78733GRP-9804OPTIONS-PPO
TPATPA-598142026-06-16T06:27:02ZLawrence—Fox1941-09-28N/A———4708 PARK PLACEMesaAZ85233GRP-1062NULL··
ENRENR-1026202026-08-12T05:05:30ZEricFJacobs1954-07-06UHC-34838-64•••-••-9077256-715-3744null··9882 WILLOW COURT·OrlandoFL32869GRP-6636·NAVIGATE-HMO
TPATPA-633632026-08-23T19:16:44Z·Austtin—Li07/11/43UNKNOWNNULL8143275055—4095 Bayshore DrScottsdaleAZ85262-4617·NULLN/A··
TPATPA-599292026-08-13T17:57:10ZCHARLOTTE—WELCH01/19/05—UNKNOWN—··3149 Cedar LanePlanoTX75039-OPTIONS-PPO
CLMCLM-4087512026-06-09T14:36:01ZPatricai··Gomez1940-10-24UHC-71807-52•••-••-665212928418674-nullUNKNOWN——UNKNOWN—
CLMCLM-4233932026-01-31T22:11:49ZEricGBowman19720914UHC-39720-70•••-••-6459(238) 612-5890······6475 PINE DR·Orlandofl32845GRP-8290MEDICARE-ADV-B
ENRENR-1007542026-09-03T10:54:00ZDIEGOESANCHEZ2/7/1964UHC-13365-28•••-••-42665905475100diego.sanchez14@hotmail.com9567 Park Place Apt 25CHARLOTTENC28231GRP-6142OPTIONS-PPO
CLMCLM-4051002026-09-23T09:02:07ZDiane—Knight19421118UHC-54183-65nullN/AN/A2976 Market StTucsonAZ85760GRP-0103MEDICARE-ADV-A
PRVPRV-28458 2026-03-11T01:31:01ZLong, JoseB—08/05/1972··UHC-18259-67··—468-457-3172N/A8334 Canyon RdNashvilleTN37269—MEDICARE-ADV-B
CLMCLM-4200102026-06-01T04:31:10ZEdwardW.Elliott1979-05-08UHC-33180-88UNKNOWN-NULL·2976 PARK PLACETempeAZ85230UNKNOWNCHOICE-PLUS-PPO
ENRENR-1336872026-10-02T19:30:10Z·ABIGAIL—MORRISON04/01/50UHC-09145-97•••-••-2259(397) 420-4494NULL928 Bayshore Dr #958MinneapolisMN55448GRP-8104NAVIGATE-HMO
TPATPA-619822026-02-27T16:16:36ZAndrewBHenderson1965-07-01UHC-57798-24——null5559 Maple AvenueGilbertAZ85226—SELECT-EPO
CLMCLM-4173032026-08-25T00:45:12ZBurns, Theresa——1961-08-13UHC-49456-91NULL8677651239N/A6374 River RoadMiami·Florida33146nullN/A
CLMCLM-4206792026-07-22T07:45:18ZDebbie—Davis·07/11/53N/A•••-••-5053(596) 386-2981-9882 Valley View DriveAustinTX78745GRP-3861MEDICARE-ADV-B
ENRENR-1141242026-09-25T09:18:28ZAliceAMcDonald1963-06-01UHC-51908-02•••-••-5424(958) 919-0958null4905 Jefferson AveTucsonAZ85722·GRP-6936OPTIONS-PPO
TPATPA-589092026-03-10T07:17:32ZSimpson, Mateo——14-01-1977UHC-30934-66—5124901471—5376 BroadwayLos AngelesCalifornia90018NULLN/A
CLMCLM-4306532026-07-27T11:01:47ZSANDRA—MCCOY1999-11-15UHC-43501-97•••-••-4873268-818-3877null··—UNKNOWNN/A-··GRP-1237OPTIONS-PPO
ENRENR-1319842026-03-26T01:00:13ZJUDDITH··SULLIVAN1948-01-23UHC-14136-74•••-••-18905306664110judith.sullivan95@aol.com5778 SPRING STREET··HoustonTX77098-0700GRP-8277MEDICARE-ADV-A
ENRENR-1298402026-10-06T11:37:22ZTERRYUPADILLA1945-08-18UHC-55722-08··•••-••-55335225569658—639 Maple Ave·San AntonioTXUNKNOWNGRP-7136CORE-HMO
ENRENR-1222452026-09-10T21:15:34ZKATHERINE—SANDERS4/3/1951UHC-48581-74•••-••-4759(986) 815-4913katherine.sanders@hotmail.com2011 River RoadAustinTexas78728GRP-0854SELECT-EPO
CLMCLM-4120332026-07-22T13:30:01Z·Wong, SamuelL—10/12/05N/A•••-••-8384—NULL9102 FOREST AVENUEHoustonTX77062N/A-
ENRENR-1338752026-10-05T19:11:55Z·EDWARDU.VAZQUEZ1944-05-19·UHC-43788-02•••-••-267816694110424edward.vazquez@hotmail.com2074 BROADWAYFresnoCA93707·GRP-3809CHOICE-PLUS-PPO
ENRENR-1368642026-10-06T03:45:44ZCHRISTOPHERFWELLS19530409UHC-08027-82•••-••-1421(886) 330-4838christopher.wells39@outlook.com8935 Baseline RoadJacksonvilleFL32233GRP-5402SELECT-EPO
ENRENR-1005772026-03-14T09:30:43ZcamilaY.bryantJul 1, 1941UHC-78163-31•••-••-8079+1 409 375 5405camila.bryant69@icloud.com517 Harbor BoulevardColumbusOH43259GRP-3328medicare-adv-b
CLMCLM-4323252026-09-08T06:24:26ZRuth—Allen19881207-•••-••-85387785510561NULL4663 Oak StHoustonTX77017GRP-7968—
ENRENR-1025972026-03-26T11:49:05Zkelly—ray1956-10-25UHC2997994•••-••-1660896-209-1304KELLY.RAY@YAHOO.COM7409 HILLCREST ROADFresnoCA··93743-6609GRP-2421MEDICARE-ADV-A
ENRENR-1358012026-03-04T14:14:13ZWalterORios1952-07-13·UHC2172587•••-••-72106014480537walter.rios@aol.com9491 Palm DrMinneapolismn55481GRP-9436CHOICE-PLUS-PPO
CLMCLM-4192972026-04-10T22:48:24ZIsabella—Walsh1979-06-04····—NULL—NULL—-nullGRP-8847MEDICARE-ADV-B
ENRENR-1035692026-01-29T20:47:12ZPHILIP··HAYES1964-11-19UHC-89762-42•••-••-010618606034896philip.hayes49@hotmail.comN/AUNKNOWN-UNKNOWNGRP-8799MEDICARE-ADV-A
PRVPRV-292172026-09-09T04:09:54Z·Jusitn····Coleman1977-12-02NULL•••-••-0782·(878) 417-3750justin.coleman@outlook.com6753 BASELINE RDSan DiegoCA92138··-CHOICE-PLUS-PPO
CLMCLM-4207512026-06-19T12:34:34ZCehryl—Owens1976-10-12—NULL··14679141075cheryl.owens24@gmail.com——nullNULL·GRP-6373UNKNOWN··
PRVPRV-268312026-10-18T20:20:46ZCharles—Nelson1939-03-01uhc-63194-22-+1 918 505 7537null1880 PINE DREden PrairieMN55394UNKNOWN—
CLMCLM-4078112026-04-08T01:23:11ZKeithZAlvarez2001-08-18UHC-14541-33-6609361558—6453 Indian School Rd··CHARLOTTENC28299GRP-8883—
CLMCLM-4013422026-08-02T04:38:06ZZachary—Rodriguez1941-10-09UHC-03456-11•••-••-34656490451UNKNOWN7339 Jefferson AveLos AngelesCA90091—CHOICE-PLUS-PPO
ENRENR-1404502026-02-16T01:53:38ZLuciaF·Tucker1984-08-18UHC-39477-43-UNKNOWNLUCIA.TUCKER27@AOL.COM174 Mountain View DrAustinTX78781GRP-2220MEDICARE-ADV-A
TPATPA-521502026-03-10T03:54:33Zcatherine—gracia03/14/1965UHC-49707-14-—catherine.garcia@proton.meN/A—nullUNKNOWN——
ENRENR-1050582026-01-08T19:15:53ZRoberts, MarianaX.—01/01/02UHC-17847-12•••-••-6530328-553-8730··N/A3588 Meadow Ln Apt 12San AntonioTX78264GRP-1363OPTIONS-PPO
ENRENR-1306752026-05-11T18:08:17ZHenry, Ashley··M—·12/15/1965UHC-55793-41•••-••-8474+1 301 923 2575—8367 Church StreetAtlantaGAUNKNOWNGRP-9284·select-epo
CLMCLM-4307782026-04-14T18:18:36ZKATHERINE··WHEELER1982-06-17NULL—nullkatherine.wheeler73@outlook.com5094 Maple AvenueLas VegasNV89196GRP-0210·SELECT-EPO
ENRENR-1237202026-01-18T16:32:01ZDavidELewis2006-06-05UHC-84403-72•••-••-54522882264879david.lewis@hotmail.com8861 MESA DRLos Angeles·California90094GRP-7192CORE-HMO
PRVPRV-226512026-07-07T16:44:08ZKathryn—Tran·1970-07-24N/ANULL6873848250-4838 Mountain View DriveTucsonArizona85754——
CLMCLM-4315772026-03-26T01:23:23ZNatalie—Ryan··06/05/04UHC-86274-64•••-••-3485309.552.2514·NULL9790 Washington StreetMinneapolisMinnesota55421NULL-
ENRENR-108745 2026-05-23T10:00:06ZMarianaTOrtega7/3/1999UHC-09499-92•••-••-7961(737) 661-5042mariana.ortega61@yahoo.com119 Park PlaceEden PrairieMN55307GRP-8993CORE-HMO
TPA TPA-511412026-04-23T15:30:25ZBilly—King2001-11-28—N/A721-460-3681N/A2775 BROADWAYColumbusOH43288-6029N/ANAVIGATE-HMO
PRVPRV-295852026-08-18T21:53:07ZTyler—Ramirez08/04/1985-—817-463-7516NULL··135 Church StSan DiegoCA92111N/AUNKNOWN
ENRENR-1286732026-02-21T01:52:40ZJULIE—CARROLL1953-12-25UHC4920348•••-••-4380UNKNOWNnull213 Spring StScottsdaleAZ85225GRP-5118CHOICE-PLUS-PPO
ENRENR-1382502026-01-07T12:37:39ZSOFIAK.HOWARD1956-10-02UHC-60029-39•••-••-7376·+1 513 548 6442SOFIA.HOWARD58@GMAIL.COM7473 Palm DrPhoenix·AZ—GRP-7867MEDICARE-ADV-B
CLMCLM-4235232026-03-20T13:54:09Z AHMED—CASTRO12/17/1993null—7727389026null9824 OAK STREETMinneapolis··MN55444GRP-8639—
ENRENR-1331772026-02-21T06:05:04Z steven—park·11/17/2007UHC-63840-34•••-••-48065382630073null9470 Pine DrAustinTX78751GRP-5022CORE-HMO
100,000 rows, page 15 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:34.759Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty