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-4045822026-02-22T20:21:42ZJACOB—SIMPSON1/24/2000UHC-02926-18null+1 662 798 7381··null·4452 Maple AveCHARLOTTENC28267GRP-8987null
CLMCLM-4143132026-02-22T15:23:16Z carolyn—harrison19980918N/AUNKNOWN—UNKNOWN··null——-GRP-4080SELECT-EPO
CLMCLM-4152962026-09-04T18:09:18Z·Brandon—Watson08/03/99UHC-65481-98-··—3953 River RoadFresno··CA93756····—
CLMCLM-4182972026-06-07T08:54:11ZLindaAOBrien1962-06-07——392.249.9740N/A···7746 Palm DrDallasTexas75211GRP-6122CHOICE-PLUS-PPO
CLM CLM-4311482026-05-09T15:00:52ZTorres, MaryV—1943-05-26UHC-04025-13•••-••-8273271-510-9300NULLUNKNOWN———·GRP-5063NAVIGATE-HMO
CLMCLM-4127862026-01-13T23:48:02ZLawrence—Griffin1992-03-19UHC-16071-31UNKNOWN··—lawrence.griffin59@outlook.com·7319 Pine DrCOLUMBUSOH43291··GRP-2014OPTIONS-PPO
CLMCLM-4096382026-08-08T19:17:10Z Herrera, Peter··—··1941-07-16UHC-90166-98·null632-722-6920-nullnull——NULL—
CLMCLM-4033712026-02-05T21:11:17ZDean, Julia——11/20/1959—··498-414-6658null6505 HIGHLAND AVENUEJACKSONVILLEFL32273GRP-9543—
CLM CLM-4167312026-02-04T06:10:47ZTHOMAS—BLACK10/13/62UHC-99272-93NULLN/ATHOMAS.BLACK19@AOL.COM9730 Oak StreetGlendale··AZ85321UNKNOWNCORE-HMO
CLMCLM-415147 2026-08-24T11:53:09ZAARON—EVANS1944-06-16—•••-••-8884nullNULL2320 Central Avenue·AustinTX78753GRP-7508—
CLM CLM-4059032026-07-11T14:49:30ZAlexander—Reed1960-08-02————·7671 Church StreetAustinTX78717GRP-3471OPTIONS-PPO
CLMCLM-4239172026-07-14T17:03:09ZLISA—WONGSep 13, 1966N/A•••-••-1871····NULL6788 Oak StTucsonAZ85722GRP-9146NAVIGATE-HMO
CLMCLM-4190952026-09-18T21:39:03ZJUDY····MAQUEZ0205-07-06UHC-68246-94•••-••-2920(664) 674-4729-UNKNOWN——N/A··GRP-6678—
CLMCLM-4026582026-05-03T01:42:24ZHANSON—KATHY1946-09-17UHC-09595-21N/A··259.561.4710·kathleen.hanson7@aol.com1114 GRAND AVEGilbertAZ·85255UNKNOWNCHOICE-PLUS-PPO
CLMCLM-4214822026-09-01T20:37:48ZjeffHsims04/14/1957UNKNOWNNULL775.410.2803—5971 Mesa DrAtlantaGeorgia30352nullSELECT-EPO··
CLMCLM-4260622026-05-19T05:54:39ZAmanda—Little6/12/1989UNKNOWNnull——·8345 Lincoln WayMesaAZ85240GRP-6083—
CLMCLM-4272942026-08-25T07:23:40Z Pena, CherylM.—1992-06-08UHC-77349-09nullNULL—5459 Valley View DriveMINNEAPOLISMinnesota55480GRP-3613OPTIONS-PPO
CLMCLM-4051122026-06-12T20:52:06ZSophia—Wilson1958-01-14UHC-22018-02UNKNOWN944-693-3110—3631 Market StreetNASHVILLETennessee37219—CORE-HMO
CLMCLM-4102082026-05-01T20:19:57Zmaria—myers9149-11-10UHC-25623-45•••-••-8135NULL-—-UNKNOWNnullGRP-3994MEDICARE-ADV-A
CLMCLM-4248462026-04-23T19:46:41ZMichelleRGutierrez19980128··—N/ANULL6253 Grand AveOrlandoFL32870N/AMEDICARE-ADV-B
CLMCLM-4127822026-02-03T13:42:40Z·emily—murray1992-02-20UHC-96474-99null16767586829··-768 Desert Sky Boulevard·DenverCO80221-·CORE-HMO
CLMCLM-4295172026-01-23T08:20:20ZJuliaDLuna1971-02-15····•••-••-0988UNKNOWN—8584 MAIN ST #607TampaFL33678-9397GRP-9371-
CLMCLM-4101692026-09-11T07:59:39ZNancy····Lynch1970-02-10UHC-62977-75—null-1365 SPRING STREETDenverCO80289GRP-4518··OPTIONS-PPO
CLMCLM-4080982026-09-10T22:42:30ZRyan—Richards05/09/1980UHC-91216-27null·-NULL8087 Mesa DriveSeattleWA··GRP-5107—
CLM CLM-4202482026-08-31T05:06:25ZSAMANTHA—KING1995-06-21UHC-02059-92•••-••-9068——·-UNKNOWN—·-null-
CLMCLM-4008002026-01-01T17:54:44ZLAURA—SULLIVAN11/11/1974—•••-••-63336567179083UNKNOWN1021 Highland Ave·AtlantaGA30378GRP-0680SELECT-EPO··
CLMCLM-409635 2026-03-29T23:09:40Zsamuel—·hernandez1966-10-18UHC-55752-85•••-••-6236+1 348 798 0865—7940 BroadwaySacramentoCA··95831GRP-3032·null
CLM CLM-4194012026-05-07T22:57:19ZEDWARD—GREENNov 19, 1963—•••-••-9186null-277 Mesa DriveJacksonvilleFL32259-0902GRP-3775—
CLMCLM-414227 2026-09-02T18:30:10ZJesse—Reyes··2006-02-10--12722119943UNKNOWN5187 Grand AveCHANDLERAZ85293GRP-9739NULL··
CLMCLM-4160932026-02-27T23:34:12ZSOPHIA—MORRISON1973-09-01UHC-01730-23—500-287-0664N/A8156 HIGHLAND AVENUEEden PrairieMN55306-UNKNOWN
CLMCLM-4154442026-02-19T16:54:39ZTYLERJ.··ROJAS1994-06-72N/A—N/A—4070 Main StreetScottsdaleAZ85263—CORE-HMO
CLMCLM-4000082026-04-28T10:46:30Z·SOPHIA—RAMIREZ1974-07-12UHC-63528-88UNKNOWN··(719) 668-1436nullNULLN/A—N/AGRP-7771-
CLMCLM-4286072026-09-27T10:35:57ZLawson, Madison——1995-11-02UHC-63078-75N/A7599881298—8044 Elm StTempeAZ85283GRP-4595UNKNOWN
CLMCLM-4151192026-06-22T14:53:08ZCHARLES—BURKE1955-11-08UHC-58990-73•••-••-2375null··N/A5211 Sunset BoulevardAtlantaGA30354GRP-8328select-epo
CLMCLM-4164842026-02-22T05:06:21Z·ARTHUR··GUZMAN··1951-01-13·UHC-72382-09•••-••-90382469255618NULL3798 Willow CourtFresnoCA93717NULLCHOICE-PLUS-PPO
CLMCLM-4015822026-07-31T11:27:59ZWAYNE—SANTIAGO1999-03-04UHC-95759-83—-null··1288 Highland AveCharlotteNC28253GRP-7293SELECT-EPO
CLMCLM-4024912026-09-17T10:20:27ZBarb··CMcDonald14-01-1983UHC-32514-51-——2086 Washington StreetCHARLOTTENC28227-4082—null
CLMCLM-4028932026-10-16T12:08:36ZChristian—Wison·1994-03-04UNKNOWNUNKNOWN(361) 950-2869NULL928 BROADWAYDALLASTX75248GRP-4161—
CLMCLM-4297262026-08-12T02:46:52ZCHARLOTTE—ROJJAS1962-09-24UNKNOWN•••-••-8063—null1589 River RoadSeattleWashington98163GRP-4690MEDICARE-ADV-B
CLMCLM-4101562026-09-24T01:12:27ZMeiGMurphy1/12/1956UHC-37068-91•••-••-2547—UNKNOWN-NULLUNKNOWNnull··N/ANAVIGATE-HMO
CLMCLM-4218152026-05-05T19:04:24ZAllen, Willie——1989-10-21——894-776-9654null4882 Highland Ave··DenverCO80291——
CLMCLM-4017132026-03-26T01:37:25ZClark, Michael··—20061217UHC5420707nullnull-4197 WASHINGTON STNashvilleTN37262GRP-5463··
CLMCLM-4168832026-03-22T23:54:18ZJuliaXPowell2005-04-04·UHC-59905-63—17674276461·NULL6540 Sunset BlvdGLENDALEAZ85355GRP-5749—
CLM CLM-4308232026-09-14T04:34:39ZColeman, Roy—··1950-10-13null•••-••-96142213393572—8107 CAMELBACK RDPhoenixAZ85040GRP-3732MEDICARE-ADV-A
CLMCLM-4217952026-02-03T19:46:16ZAndrew—Hunt2008-11-21UHC-90052-31—9525173null7960 Meadow LaneMesa··AZ——NAVIGATE-HMO
CLMCLM-4181282026-04-21T15:54:24ZSHIRLEY—·LE2002-03-28UHC-24005-09•••-••-2050914.807.7555NULL7260 MARKET STREETMESAAZ85220GRP-9159NAVIGATE-HMO
CLMCLM-4135782026-04-05T22:03:03ZChristine—Elliott2/25/1998UHC-73005-64NULL5423429113—1462 Sunset BoulevardDallasTX75248GRP-3795UNKNOWN
CLMCLM-4164722026-10-18T11:52:35Z—F—·Apr 9, 1941UHC7617526—NULLNULL5061 Highland AvenueLas VegasNV89155GRP-8997NULL
CLMCLM-4286752026-08-09T20:59:16ZJOE—·PERRY1940-12-09UHC-87923-85•••-••-92245905279824N/A4480 WILLOW CT Apt 16DENVERCO·80275—·SELECT-EPO
CLMCLM-4010022026-05-17T10:52:08ZMARIA··—HARRISON1998-01-02UHC-00391-32•••-••-5727N/ANULL2840 OAK STCOLUMBUSOH43297-1101GRP-7534NAVIGATE-HMO
32,829 rows, page 201 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:43.420Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty