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-4254832026-07-24T02:44:03ZCARL—COLEMAN1970-03-15UHC-95130-07NULL·+1 984 766 9139—3129 CHURCH STSan AntonioTX78288—NAVIGATE-HMO
CLMCLM-415652 2026-01-13T00:56:21ZThheresa—YoungJan 10, 1940UHC-74149-85•••-••-2556UNKNOWN—97 BROADWAY Apt 2SacramentoCA95843-3817NULLSELECT-EPO
CLMCLM-4264462026-01-21T09:36:18ZMASON—JACOBS1988-12-28UHC-48090-22——UNKNOWNUNKNOWNNULL-—GRP-2411SELECT-EPO
CLMCLM-4102902026-08-27T18:45:56ZKaren—Morrison6/12/1985··N/A•••-••-8231(941) 703-5798N/A—N/ANULL—GRP-3099-
CLMCLM-4018752026-01-26T17:22:35ZMICHAEL—HARRISON25-02-1939UHC-19556-29—N/ANULLN/AN/AnullUNKNOWN—NAVIGATE-HMO
CLM CLM-4117292026-09-18T11:00:39ZRyan, Lucia——1987-05-06UHC-61623-91•••-••-9220—LUCIA.RYAN@PROTON.ME5920 ELM STREETColumbusOH43294nullUNKNOWN
CLMCLM-4107122026-05-25T12:04:39ZMason—Carter2006-05-10UNKNOWNUNKNOWN4806123680NULL··NULLNULLNULL-GRP-7196OPTIONS-PPO
CLMCLM-4197652026-01-06T17:07:58ZChris—Schmidt1969-05-04—-N/Anull—····null··nullNAVIGATE-HMO
CLMCLM-4247932026-05-14T12:56:50ZTyler—Waber1967-01-20UHC3298545•••-••-9263+1 210 569 0851N/A5659 Main StreetLas VegasNV89166N/Anull
CLMCLM-4067932026-08-26T17:47:44ZTaylor, Bradley——1977-02-24UHC9692898null(631) 795-8677—4774 MEADOW LNPlanoTX75045GRP-1858OPTIONS-PPO
CLMCLM-4196192026-07-05T18:42:02ZVIRGINIA—·WEAVER——NULLN/AVIRGINIA.WEAVER81@ICLOUD.COM5687 Sage CtGLENDALEAZ··UNKNOWNGRP-1049UNKNOWN
CLMCLM-406860 2026-07-10T05:27:23Zgreen—luis09/23/80—UNKNOWN874-411-7899UNKNOWN1792 Mountain View Dr·San AntonioTX78270-8199-CORE-HMO
CLMCLM-4266142026-04-17T09:31:19ZELIZABETH—RODRIGEUZ19631206NULL—2787150921null7374 Sage CourtTampaFlorida33602-3922N/ANAVIGATE-HMO
CLMCLM-4024902026-09-30T00:38:44ZSandra····MorrisAug 19, 1976NULL-(622) 834-8788NULL8039 VALLEY VIEW DRMinneapolisMN55428GRP-1916—
CLMCLM-4095082026-08-01T06:12:21ZAam····Garrett·01-12-1986UHC-27878-40•••-••-7008(807) 931-1482adam.garrett@aol.com1351 Ocean AveSeattleWA98139GRP-3997-
CLMCLM-4002632026-01-04T11:10:51ZMadison—Boyd1997-10-09·null•••-••-3525495-763-1430-5761 CENTRAL AVENashvilleTN37230UNKNOWN·CHOICE-PLUS-PPO
CLMCLM-4294772026-01-30T19:02:17ZNatalie—Weber1966-08-06null—null—3991 Hillcrest RdFresnoCA93768·GRP-5086MEDICARE-ADV-A··
CLMCLM-4093952026-10-03T06:18:22ZTheresa—Ferguson8/2/1971UHC-72869-72—+1 816 981 8524null4160 HARBOR BLVDDallasTX75223—NAVIGATE-HMO
CLMCLM-4265142026-08-16T18:16:53ZBrendaW.HughesOct 21, 1948UHC-10738-48N/A—UNKNOWN8393 Market StreetScottsdaleAZ85260——
CLMCLM-4208802026-06-17T18:04:16ZVictriaH.Flores1944-02-20UHC-25370-92•••-••-3858UNKNOWNnull7285 Apache BoulevardTempeAZ85261··CHOICE-PLUS-PPO
CLMCLM-4197422026-04-01T14:32:52ZAmanda—·Thompson02-01-1959··•••-••-2239(694) 253-5631—929 Maple AvenueAustinTX·78775GRP-0602··
CLMCLM-4260552026-02-08T00:30:44ZFrank—Robertson1982-05-16UHC-20010-86-8027583177······2074 Hillcrest RoadTAMPAFL33658UNKNOWNnull
CLMCLM-4235722026-06-01T18:33:35ZMegan—LarsonApr 12, 1966N/AN/AN/Amegan.larson@proton.me6605 PARK PLACEMINNEAPOLISMN55481——
CLMCLM-4027952026-08-21T01:52:32ZJACK—REEED1963-04-03UHC-42013-97—7437110930——N/AN/AnullGRP-3456CHOICE-PLUS-PPO··
CLMCLM-4215692026-02-26T10:10:06ZValentina—Pattel04/05/1943UHC-58567-46•••-••-8224+1 519 503 9657—9493 Canyon RdSeattleWashington98115GRP-9590UNKNOWN
CLMCLM-4225612026-07-13T18:40:25Zkeith—foster01/10/73··uhc-88227-23—846-697-1232—3575 OAK STREETPhoenixAZ85043GRP-3388CHOICE-PLUS-PPO
CLMCLM-4126022026-02-16T03:40:01ZEmily—Bleck19490219·UNKNOWN—+1 228 931 8389—8359 Desert Sky Boulevard·JacksonvilleFL32287··GRP-3535CORE-HMO
CLMCLM-4060252026-04-05T23:14:31ZJESSE—FIELDS1948-04-01—•••-••-09092475310915—829 Central AvenueDallasTexas75288GRP-1797··—
CLMCLM-405256 2026-08-03T23:48:32Z·Frank—Padilla1964-02-14UHC-18739-54•••-••-60346403168158—3588 River RdMinneapolisMN55480—CORE-HMO··
CLMCLM-4061722026-09-19T09:21:22ZDYLAN—WILLIAMSON6/23/1965—NULL-N/A297 Meadow Lane·JacksonvilleFL32281GRP-9613null
CLMCLM-4035422026-06-03T21:49:23ZCarolQCarlson1994-06-12—UNKNOWNUNKNOWNUNKNOWN841 CENTRAL AVENUEDallasTX75220GRP-9934··OPTIONS-PPO
CLMCLM-428067 2026-10-18T09:33:34ZJason—Hunt12/08/63—•••-••-8600—JASON.HUNT@ICLOUD.COM3113 Park PlTempeAZ85216—null
CLMCLM-4267872026-07-14T22:39:08ZLsiaGEvans·1981-09-07UHC8918142•••-••-6775(593) 954-4189—214 ELM STDenverCO80286nullCHOICE-PLUS-PPO
CLMCLM-4226972026-02-26T16:36:22ZRUSSELL—SPENCER·1983-09-17UHC-70361-34··—242-972-5257RUSSELL.SPENCER86@AOL.COM5512 Harbor BlvdTempeAZ85220GRP-5229CORE-HMO
CLMCLM-4099852026-02-18T18:44:54ZParker, Danielle—··1944-05-13··UNKNOWN—UNKNOWN—8373 CHURCH STREET··TAMPAFL33691null—
CLMCLM-4006892026-08-31T04:59:00ZPamela··—Bradley1994-12-07··-•••-••-7820NULLUNKNOWNN/AUNKNOWN-—GRP-3035OPTIONS-PPO
CLMCLM-4086062026-01-16T13:00:38ZJONATHAN—WARD2003-10-01—•••-••-2452·+1 786 684 0720-5264 Mesa DriveSan AntonioTX78280-8686—NULL
CLMCLM-4327522026-01-26T12:32:56ZMarcusHFernandez1997-10-04UHC-69524-07—(497) 982-9474N/A1095 Hillcrest RoadTempeAZ85298GRP-9519—
CLMCLM-4325632026-04-02T19:07:41ZJeremy—Stevens1952-01-07··UHC-47173-61—nulljeremy.stevens89@outlook.com··473 Market StreetPlanoTX75072—NAVIGATE-HMO
CLMCLM-4323602026-02-28T22:26:34ZAmy—Sanchez1972-07-02UHC-63205-92nullUNKNOWN—7045 DESERT SKY BLVDSacramentoCA95892GRP-2838—
CLMCLM-4048982026-04-14T01:19:58ZWayne—Weaver1954-08-08··UHC-84816-21•••-••-2284NULL—8045 Main StAUSTINTX78710-3183——
CLMCLM-4228652026-02-27T03:40:35ZsharonQreyes—UHC-18188-08•••-••-2798NULL—8929 FOREST AVENUE #477San AntonioTX78231GRP-6819—
CLMCLM-4284862026-06-06T22:00:36Z Terry—Hughes2002-02-18—•••-••-0645N/A-3241 VALLEY VIEW DRIVEPhoenixAZ85018-0399GRP-6709—
CLMCLM-4192392026-09-22T20:02:00ZHANNAH—ROBERTS2003-04-13UHC-35362-03null(673) 932-6336·-780 MEADOW LNTEMPEAZ85251null··SELECT-EPO
CLMCLM-4030292026-02-02T08:08:55ZRAYMONDELEWIS21-01-1949uhc-00572-26—5365907879·raymond.lewis51@yahoo.com561 Pine DriveJacksonvilleFL32266GRP-5396—
CLMCLM-4070292026-04-26T09:59:28ZJerry—Fields2007-01-11·UHC-44330-22•••-••-0636UNKNOWN··UNKNOWN8454 Bayshore Dr·NashvilleTN37225UNKNOWNMEDICARE-ADV-B
CLMCLM-4221742026-09-29T10:03:39ZSARAH—PHILLIPS1981-01-22UNKNOWN··•••-••-34843443740128·sarah.phillips72@hotmail.com1159 Spring StJacksonvilleFL··32222N/Anull
CLMCLM-4170862026-03-25T22:37:21ZAlice—GrahamOct 8, 2002UHC3505531•••-••-4780490-203-8393N/A1877 Forest AveSeattleWA98129·N/ASELECT-EPO
CLMCLM-400504 2026-07-31T13:34:10ZDorothy—Reyes1994-07-24UHC-45582-86•••-••-8419(688) 676-7972—8886 Lake View RoadOrlandofl—N/ANULL
CLMCLM-4268972026-02-19T11:30:49ZSteveP.Lawrence08-12-1974—•••-••-10092144806—5363 Park Place Apt 38PLANOTX75087GRP-5355··MEDICARE-ADV-A
32,829 rows, page 152 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.340Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty