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-4282682026-07-22T02:33:44ZWillie—Sanchez1971-01-27UHC-64820-04——-2285 CENTRAL AVETucsonAZ85727GRP-0266—
CLMCLM-4314982026-07-08T06:13:02ZDylan—Carlson1946-10-01·UHC3677169•••-••-4155+1 988 592 2765—1363 BASELINE ROADATLANTAGA30378GRP-2027-
CLMCLM-4135602026-09-19T07:05:11ZCheryl··—Ward1986-10-26NULL•••-••-8923-null1170 SPRING STREETNASHVILLETNN/AN/ACHOICE-PLUS-PPO
CLMCLM-4090452026-06-24T18:43:56ZFord, Doris——1985-08-03··—•••-••-7147NULLdoris.ford57@icloud.com4869 Meadow LnMesaAZ85259null—
CLMCLM-4185912026-10-05T06:54:42ZArjun—Ward1958-02-24UHC-59588-89—nullN/A5039 WASHINGTON STREET·MINNEAPOLISMinnesota55449nullNULL
CLM CLM-4223072026-09-04T19:04:05Znoah—·woods02-10-1969UHC6670523NULLN/Anoah.woods@aol.com3225 Church StGlendale··AZ85337-6401UNKNOWN—
CLMCLM-4322462026-10-02T09:25:23Zfrank—allen11/7/1974UHC-03524-51•••-••-0178N/AN/A3277 Baseline Rd·SeattleWashington98142GRP-6554·CORE-HMO
CLMCLM-4170332026-04-01T07:46:18ZJOHNNY—WONG1971-01-25UHC-53102-06•••-••-6267null—1306 Elm StreetScottsdaleAZ85211NULLnull··
CLMCLM-4296112026-06-26T00:11:40ZGARY··—GRAHAM19910519UHC9847975UNKNOWNnullnull6136 WILLOW COURTLos AngelesCalifornia90038-7049GRP-4099—
CLMCLM-4170222026-05-08T01:28:31Zpeter—arnold1994-08-02—•••-••-813318313924397peter.arnold@proton.me1574 OAK STMESAAZUNKNOWN—·-
CLMCLM-4234222026-07-29T11:39:09Z———08/25/1969UHC-95875-47——-5564 CENTRAL AVENUEMINNEAPOLISMN··-NULLnull··
CLMCLM-4233002026-09-25T15:38:50ZSOFIA—SILVA1960-09-16—•••-••-5075—-7071 MAPLE AVENUE··MesaAZ85288GRP-4077choice-plus-ppo
CLMCLM-4277322026-08-12T16:15:25ZAlbert—Chavze1998-08-22UHC-44798-07—573.380.4728NULL1017 CENTRAL AVE··San AntonioTX78233GRP-3630··NULL
CLMCLM-4038182026-02-24T16:31:49ZkellyYcarroll19911206null•••-••-0362NULL··—null—··null-MEDICARE-ADV-B
CLMCLM-4273932026-09-06T04:34:22Z·Madison—Reyes··19460418-•••-••-8736——null——··—MEDICARE-ADV-A
CLMCLM-4189502026-08-21T00:23:12ZEugeneZ.··Fields1946-04-17UHC-09366-25•••-••-1354——8134 Valley View DriveColumbusOH43232N/AUNKNOWN
CLMCLM-4121962026-06-09T03:29:05ZEDWARD—NICHOLS··04/26/97UHC-26667-44NULL9239142340UNKNOWN4601 Ridge RoadDallasTX·75216GRP-5696UNKNOWN
CLMCLM-4043772026-08-19T21:00:05Z Noah—Weber1956-12-23··UHC-61800-97N/A(298) 465-4134N/A9454 Church StDENVER·CO80243GRP-0835·OPTIONS-PPO
CLMCLM-4050782026-10-10T16:58:33Z ·Brian—Little19460209·UHC-65114-56UNKNOWN986.588.1087N/A9016 Maple AveMesaAZ·85278UNKNOWNMEDICARE-ADV-B
CLMCLM-4113752026-04-18T23:14:33ZHEATHER··GARZA1983-04-15null•••-••-8505(627) 948-0819—7382 Baseline RdPhoenixArizona85013GRP-9935OPTIONS-PPO
CLMCLM-402099 2026-08-21T19:38:26ZRUSSELL—GARDNERDec 20, 1955UHC-65262-67N/AUNKNOWNN/A4353 Jefferson AvenueTempeAZ··85277··GRP-9848CHOICE-PLUS-PPO
CLMCLM-4254842026-07-24T02:44:03ZCARL—COLEMAN1970-03-15UHC-95130-07NULL·+1 984 766 9139—3129 CHURCH STSan AntonioTX78288—NAVIGATE-HMO
CLMCLM-4274262026-07-05T09:52:08ZHenry, David——1938-09-08·UHC-00305-08•••-••-9891458-477-8767UNKNOWN7188 BROADWAYSAN DIEGOCA92109—N/A
CLMCLM-4218642026-08-24T00:54:32Z HaroldLRivera1954-10-21——NULL—2011 Park Pl·JacksonvilleFL32254GRP-9654-
CLMCLM-4049722026-02-15T07:37:34ZDonald—ElliottAug 3, 1964N/A—661-866-2285N/A5052 Indian School RdAustinTX78727GRP-1692OPTIONS-PPO
CLMCLM-4151662026-07-27T06:20:58ZDaniel—Hunter1990-12-19-•••-••-6612701-967-2836N/A3802 Mesa Drive··NashvilleTennessee37296GRP-3261NULL
CLMCLM-4211092026-04-17T14:35:01ZDENNISNPARK1948-06-15UHC-17765-89•••-••-0816N/AN/A—-——·GRP-8763MEDICARE-ADV-A
CLM CLM-4165962026-10-04T18:00:10ZJames—Rojas·1946-10-27UHC-49912-59null·314-826-0850N/AUNKNOWN—NULLN/AGRP-4226NULL
CLMCLM-4295302026-01-11T08:30:14ZValentina—Duncan12/15/2007——15717007966··UNKNOWN··5071 Maple AvenueMinneapolisMN55411GRP-7611··MEDICARE-ADV-A··
CLM CLM-4058542026-01-24T12:30:36ZKallyPAguilar19381104UHC-52255-77—N/A—5312 RIDGE RDSAN ANTONIOTX78246····MEDICARE-ADV-A
CLMCLM-4188112026-02-24T22:34:44ZAlice—Vazquez1939-02-06null··—601.892.4404NULL9804 INDIAN SCHOOL ROADSeattleWA98183-—
CLMCLM-4019382026-05-24T10:43:03Z Katherine—Montgomery8/7/1996····—932-554-5090-6855 Sunset BlvdTempeAZN/Anull-
CLMCLM-4195082026-01-27T01:56:14Z EDPMONTGOMERY1953-05-27UHC-32912-54•••-••-3672393.455.6474UNKNOWN1759 Camelback Rd··FresnoCA93732GRP-2162NULL
CLMCLM-4148852026-09-30T00:20:06ZRusseell····Meyer20070124UHC-23548-21-—··null—UNKNOWN—-NAVIGATE-HMO
CLMCLM-4166092026-07-15T00:05:54ZBRANDON—HOLMES1948-05-27—•••-••-3886·842.883.7060nullN/AUNKNOWNnull—GRP-2349N/A
CLMCLM-4123092026-03-06T09:37:50ZLogan—Salazar09-03-2007UHC-81920-75•••-••-4200N/A-4954 Union StCharlotteNC28266NULL-
CLMCLM-4013072026-03-04T21:45:34Zlisa··—soto19541201UNKNOWNUNKNOWN19312285367N/A——·N/AnullGRP-9371MEDICARE-ADV-A
CLMCLM-4180982026-02-06T01:56:48ZVictoria—Peterson2004-03-17UHC-99908-60•••-••-21203673902205-5416 Sunset Blvd·GilbertAZ85228GRP-0530—
CLMCLM-4212742026-02-25T07:54:16ZJanet—Brown23-08-1939——619-729-9720—1614 Washington StDallasTX75288··GRP-5902CORE-HMO··
CLM CLM-4082132026-05-14T07:22:43ZBilly··Olson1974-06-21uhc-87272-66•••-••-2053706-446-3924null2435 Main StreetSAN DIEGOca92126····SELECT-EPO
CLMCLM-4214002026-09-24T20:44:39ZJeffrey—Park06/15/1938N/A··-(790) 363-8100N/A5894 Pine DriveChandlerArizona85282GRP-7681OPTIONS-PPO
CLMCLM-4223432026-05-11T12:58:26ZMartha—Dixon12/27/1980UHC-22273-83•••-••-519117392825747MARTHA.DIXON@ICLOUD.COM6794 Park PlAtlantaGA30377——
CLMCLM-4315992026-07-26T23:53:45Z·Beverly—SchultzJul 9, 1981UHC-83728-87•••-••-8403null—627 Highland AveDallas·TX·75261·GRP-4646MEDICARE-ADV-A
CLMCLM-414465 2026-03-02T16:23:30Zwilliam—allen06/12/53UHC-46233-87•••-••-8473——430 Highland AvenueDallasTX75267GRP-4503SELECT-EPO
CLMCLM-4313322026-05-21T19:44:22ZStewart—Rebecca09/21/1941UHC-12215-27•••-••-8782—null··378 Willow CtPlanoTX75059GRP-1751N/A
CLMCLM-423755 2026-06-01T00:36:13ZPhilip··U.Spencer1953-12-04-—(641) 510-5709—238 Highland AveTempeAZ··85269GRP-5495OPTIONS-PPO
CLMCLM-4114962026-06-25T12:57:54Z·Edward—·Ward1939-08-01UHC1507161•••-••-2021(440) 360-0369null4128 Washington StreetAtlantaGA30301GRP-0328null
CLMCLM-4236172026-06-27T18:04:48ZAUSTIN—HARVEY·02/02/1988UHC-73934-26—null—————-null··
CLMCLM-4211312026-02-24T03:44:36ZHANNAH····HOFFMAN10/12/51UHC-41519-61null(641) 821-4518null2300 Elm StreetORLANDOFL··32879nullnull
CLMCLM-4259112026-02-16T18:00:08ZAISHA—·LUPEZ03/03/1971·NULL•••-••-7682——24 Desert Sky BoulevardChandlerAZ85260GRP-4702CORE-HMO··
32,829 rows, page 72 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:37.731Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty