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-4212362026-07-16T14:44:23ZVirginia—RayJul 22, 1956UHC-17642-30··—9372571397null350 UNION STPhoenixAZ·85045NULL—
CLMCLM-4219722026-05-31T11:02:30ZPriya—Lynch··1982-09-24UHC-09790-72N/A·-··NULLNULL·nullUNKNOWNGRP-0673MEDICARE-ADV-A
CLMCLM-4186672026-04-29T03:51:06ZCHRISTIAN—JAMES19771008UHC-82723-91-442-916-7211—9378 Oak StreetTempeAZ85242N/Anull
CLMCLM-4233432026-09-30T12:06:50Z·Amy—Castro1989-03-26nullnull208-462-1583-3536 Lake View RdNashvilleTN37254GRP-3831SELECT-EPO
CLMCLM-4041162026-02-22T02:54:00ZRaymond—Wood17-12-1977UHC-43430-18•••-••-4947-—409 Cedar LnLas VegasNV89148GRP-5840MEDICARE-ADV-B
CLMCLM-4116892026-02-27T04:42:25ZRandyZ.Malddonado91990804UHC-32441-24N/A—RANDY.MALDONADO19@AOL.COM5269 Church StTucsonAZ85782GRP-3490null
CLMCLM-4100032026-09-28T19:48:43ZDENISEYDAVIS1976-01-20——313-588-7336—8266 Oak StSEATTLEWA98149·GRP-7759UNKNOWN
CLMCLM-4170542026-04-10T06:16:31ZWagner, Roger——1959-01-11——+1 653 599 5616——nullNULL—GRP-1723CHOICE-PLUS-PPO
CLMCLM-4160782026-09-24T00:40:05ZDEBORAH—BUTLER1972-01-07UHC-03429-27N/A····N/A6650 Indian School RdDallasTX75239GRP-9478—
CLMCLM-4173232026-04-10T01:31:47ZAlexisJWest1996-10-23UHC-01606-34·-+1 386 612 9530··N/A5812 Church StreetDallasTX75264GRP-8193-
CLMCLM-4257082026-07-30T03:51:42ZNATALIE····OLIVER2/22/1968-NULL··natalie.oliver@icloud.comNULL—NULLNULLGRP-1596-
CLMCLM-4147592026-05-01T17:37:16ZAlice—Marquez1978-07-18---NULLUNKNOWN··N/ANULL—N/ACORE-HMO
CLMCLM-4319322026-05-18T15:46:08ZEdward—Gilbert1965-06-19UHC-07317-90UNKNOWN··(397) 319-0600UNKNOWN··5360 Valley View DrMinneapolisMN55401GRP-1793—
CLM CLM-4135722026-07-14T07:35:59ZJonathan—Freeman11/23/1950UHC-97811-68•••-••-9130(558) 218-9906··jonathan.freeman@gmail.com230 Sage CtMIAMIFL33196GRP-6757NULL
CLMCLM-4001792026-05-31T12:23:24ZMaria··Mejia·1958-01-11—•••-••-6548-UNKNOWN1538 Desert Sky BlvdHouston··TX77068GRP-1729-··
CLMCLM-4072142026-09-09T09:42:03ZKIMBERLY—MUNOZ2007-12-22N/A-——5212 Spring StreetJACKSONVILLEFL32237-3312—CORE-HMO
CLMCLM-4111412026-08-29T09:24:45ZLinda··—Pane1989-08-18UHC-24198-89•••-••-0646nulllinda.payne@proton.me9531 SAGE CTTAMPAFL33676—SELECT-EPO
CLMCLM-4130602026-09-24T20:15:38ZHannahBSimmons1981-12-04UHC-61478-12··•••-••-6460595-791-1275UNKNOWN··2317 CHURCH STREETFresnoCA93778GRP-9157navigate-hmo
CLMCLM-4260472026-05-19T00:43:19Z KATHRYN—GRAY1969-12-14UHC-34431-13UNKNOWN—N/A6391 CAMELBACK ROADSCOTTSDALEArizona85213GRP-9951N/A
CLMCLM-4269962026-06-22T21:21:28ZHarold—Matthews1961-71-23UHC-47451-76NULLnull··NULL1371 Elm StNashvilleTN37212GRP-1782CORE-HMO
CLMCLM-4279532026-09-30T07:20:32ZPriya—Ward1993-03-24-—null-2129 Forest AvenueEDEN PRAIRIEMN55347GRP-2238··CHOICE-PLUS-PPO
CLMCLM-4191202026-06-04T15:58:35ZJonathan, LeU—1978-08-09UHC-34946-14null(808) 978-3259N/A·4386 Market StreetDenverCO··80254GRP-3406UNKNOWN
CLMCLM-4249322026-09-28T22:37:18ZMei····Alvarado1943-12-01-•••-••-4519867-400-2494N/A——·NULL—UNKNOWNNAVIGATE-HMO
CLM CLM-4208042026-10-13T05:33:54ZElizabeth··Bishop12/27/1956UHC-78286-67NULL967.994.4942NULL·5904 Harbor Blvd Apt 12PLANOTX75067GRP-2294··NAVIGATE-HMO
CLMCLM-4077312026-04-18T22:40:55ZBEVERLYG.PADILLA26-10-1954··nullUNKNOWN—N/A6136 Park PlMesaAZ85225—CORE-HMO
CLMCLM-4316442026-09-14T13:12:42Zbrian··Eburke1969-10-08UHC-98758-75··•••-••-16417227541840—1203 CHURCH STSan DiegoCA92196-0814GRP-0890—
CLMCLM-4126572026-10-01T11:19:30ZJustin—Rodriguez01/25/81··UHC-14976-96•••-••-0679203.476.8363null5750 Desert Sky BlvdDallasTX75286GRP-0806—
CLMCLM-4172542026-08-28T01:41:39ZJerry··—Contreras1983-12-09null•••-••-971719344280533-7457 CANYON RDNashvilleTennessee·37208N/ANAVIGATE-HMO
CLMCLM-4004282026-04-09T15:22:08ZJEREMY—MITCHELL1946-04-04····•••-••-4757UNKNOWN—null-—-UNKNOWN··—
CLMCLM-4053562026-03-14T15:18:50ZSHIRLEY··BMORRIS1942-12-21UHC-34000-41•••-••-7130(258) 886-5895··4454 Camelback RdSacramentoCA95880GRP-4516null
CLMCLM-4226922026-04-14T05:08:30ZRichard—Santiago·05/09/86UHC-26774-18•••-••-9830660-745-1570—9782 Bayshore Dr··Austin··TX78722GRP-3077··UNKNOWN
CLMCLM-4141442026-05-13T16:06:46ZDENNIS—·CONTRERASAug 27, 1998UHC-23357-72··N/A-·NULL1344 Mountain View DriveORLANDOFL32830——
CLMCLM-4311432026-01-21T19:59:07ZVICTORIA····WATSON04/28/65UHC-16748-13•••-••-7716(615) 294-5436—·5576 Sunset BoulevardGlendale·Arizona85367UNKNOWNCORE-HMO
CLMCLM-4060152026-08-18T07:59:32Zdonald—luna1955-01-09UHC-18639-83N/A—NULL8713 Main StreetScottsdaleAZ85205GRP-3194MEDICARE-ADV-B
CLMCLM-429478 2026-01-27T11:44:47ZTheresa—Rogers·1966-02-03UHC-93439-83·····7816874581—5959 FOREST AVEMesaAZNULLGRP-1814-
CLMCLM-4053462026-09-28T12:18:08ZBruce—Porter15-04-2005·null·UNKNOWN(975) 299-4052BRUCE.PORTER70@ICLOUD.COM1886 Maple AvenueTempeAZ85247GRP-7182SELECT-EPO
CLMCLM-4244222026-01-12T22:47:36ZDorothy—Harvey2002-08-24—null(313) 604-0690dorothy.harvey@proton.me4150 Apache BoulevardGlendaleAZ85322GRP-7078NAVIGATE-HMO
CLMCLM-4098902026-01-24T13:22:28ZJosephCLawson19-02-1981UHC-26174-27•••-••-9324+1 245 419 2338UNKNOWN—N/A-·nullGRP-7780MEDICARE-ADV-B
CLM CLM-4105232026-09-27T05:11:40ZPatel, CharlotteY—2008-08-11UHC-45528-19—UNKNOWN—2247 Mountain View Drive·Los AngelesCA90024GRP-5158NAVIGATE-HMO
CLMCLM-4150902026-01-24T12:56:04ZDANIELK.··REID23-01-1939UHC-18514-12NULL—N/A8395 Camelback RoadColumbusOH43209-7426-choice-plus-ppo
CLM CLM-4298642026-04-16T12:43:29ZAisha—Salazar19531110·NULL-NULLN/A2129 Jefferson Ave··NashvilleTN37292-—
CLMCLM-4289422026-06-08T14:00:18ZLARRY—BURTON1965-02-07UHC-16584-63•••-••-38668966346266null782 Pine DrChandlerAZ85271GRP-5532CHOICE-PLUS-PPO
CLMCLM-4236572026-08-15T12:25:50ZNATALIEH.DUNCAN19720322UHC-88287-19··——N/A930 Meadow LaneLAS VEGASNV89125GRP-1379OPTIONS-PPO
CLMCLM-4147272026-05-23T06:39:59ZJudy····Castro1984-02-12UHC-14119-09—(253) 861-8240··8470 Church St Apt 13PLANOTexas75003UNKNOWNNULL
CLM CLM-4180302026-06-10T15:32:23Zkyle—hill12/22/2005—-14137661012N/A4264 Market StCharlotteNC28268UNKNOWNnull
CLMCLM-4025082026-05-29T02:30:54ZWILLIAM—SIMMONSJun 17, 1972UHC-76744-15null4213430868N/A3955 Oak StreetMiamiFL33134-7184NULL-
CLMCLM-409875 2026-05-14T16:15:10ZJason—Guerrero1949-07-19UHC-14738-35—-—1164 Indian School RdSEATTLEWA98130GRP-3440OPTIONS-PPO
CLMCLM-4179042026-01-11T00:05:18ZGEORGE··—SLVA09/06/1972UHC4378468•••-••-8286UNKNOWN-9064 Camelback RdGlendaleAZ85322NULLUNKNOWN
CLMCLM-4242462026-08-10T22:13:29ZkatherineI.hart1992-03-19····NULL-NULL5857 Ridge RdDallasTX75204GRP-5706UNKNOWN
CLMCLM-4107792026-10-05T15:46:56ZJUDY····MARTIN··1977-07-26UHC-75557-23•••-••-45809288111335—9886 HIGHLAND AVEGilbertAZ85203-N/A
32,829 rows, page 14 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:34.774Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty