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-4282632026-05-21T06:24:02Zjason—morgan2006-04-10UHC3145791N/A·504-271-8566—2752 Hillcrest RdTampaFL··GRP-2075OPTIONS-PPO
CLMCLM-4089572026-03-30T18:42:22Z—··—02-07-1988—NULL—andrea.carroll35@proton.me6828 OAK STREETSacramentoca95878··GRP-8898NULL
CLMCLM-4121902026-05-12T05:39:54ZArjun—Wong1993-08-22UHC-77127-41•••-••-5604——null—N/ANULLGRP-9980—
CLMCLM-4253162026-04-30T22:31:48ZJulia—RyanApr 8, 1988UHC-57990-23·UNKNOWN712-387-4597NULL2161 Hillcrest RdSacramentoCA95881··--
CLMCLM-4324202026-03-09T11:31:14ZBarbara—Nichols05-03-1953UHC-25443-03•••-••-0446907-730-0078null8658 Mountain View Drive··MiamiFL33174GRP-0914NULL
CLMCLM-4082272026-01-03T18:13:10ZJULIA—CARROLL07/10/1972NULLUNKNOWN8312837561null——UNKNOWNN/A··UNKNOWN
CLMCLM-4125732026-02-05T07:18:12ZDOUGLAS··NUNEZ1959-01-02UHC-04096-41··NULL8067198149null4598 SPRING STREETDALLASTX75262GRP-3068NULL
CLMCLM-4301992026-05-31T19:39:26ZPhilip—Olson2007-09-07null•••-••-28258858086728-4297 Indian School RoadNashvilleTN37257GRP-7255SELECT-EPO
CLMCLM-4169262026-03-03T11:46:30ZDORIS—RICHARDS1980-11-26UHC-30582-10•••-••-9110NULLUNKNOWN9764 Cedar LaneHoustonTX77004NULL·NAVIGATE-HMO
CLMCLM-4115102026-07-11T17:38:48ZLinda—Smith09/17/89UHC6819920•••-••-6889NULLnull—N/A—-GRP-6601-
CLMCLM-4044652026-03-03T01:05:03ZBruceKStephens1938-03-04UHC-46738-13•••-••-65784106070075·UNKNOWN6482 UNION STOrlandoFL32844GRP-5481NAVIGATE-HMO
CLMCLM-4012012026-08-23T16:23:22ZSANDRAZGEORGEJul 26, 1939—UNKNOWN639-666-7723—7414 Cedar LaneCHANDLERAZ85287GRP-8840MEDICARE-ADV-A
CLMCLM-4138842026-01-17T10:15:00ZPATRICIA—PETEL1958-07-09NULLUNKNOWN703-372-4602-3400 Central AvenueNASHVILLETN37256-0808·GRP-2401UNKNOWN
CLMCLM-4090022026-05-11T21:43:59Z·ALICE—REID1950-07-06null—+1 250 701 2884—3716 Harbor BlvdOrlandoFL32861GRP-0161—
CLM CLM-4036812026-02-02T13:31:08ZSARAHMALVARADO4/16/1963UHC-19247-27NULL(209) 558-1648··—6407 Grand Ave·OrlandoFL32893GRP-9632—
CLMCLM-4015182026-10-15T18:03:43Z·RONALD—GONZALES1951-05-19··—UNKNOWN—2738 CENTRAL AVEJACKSONVILLEFL·32239GRP-5774medicare-adv-b
CLMCLM-4171822026-06-08T08:38:04ZAlbert—Schultz19391206UHC7924771UNKNOWN918.693.0633null8850 Hillcrest RoadColumbusOH43219GRP-1889MEDICARE-ADV-B
CLMCLM-4312362026-09-03T00:39:18ZJoshuaMGonzales06-03-2001UHC-38587-47•••-••-7577NULL—4712 Sunset BoulevardPhoenixArizonaNULL—MEDICARE-ADV-A
CLMCLM-4147282026-08-09T16:48:42ZJanetY.Munoz1941-09-07—N/A4469016354JANET.MUNOZ96@YAHOO.COMnullnull-—GRP-8597—
CLMCLM-4184742026-07-08T06:40:38Zjacqueline—mason19930708UHC-70522-46•••-••-6389——5140 Cedar LaneMINNEAPOLISMNUNKNOWNGRP-7795CHOICE-PLUS-PPO··
CLMCLM-4029742026-01-09T08:19:58ZFATIMA—WEBB20-11-1964UNKNOWN•••-••-1542——2690 Desert Sky BlvdLOS ANGELESCAUNKNOWNGRP-1858OPTIONS-PPO
CLMCLM-4148152026-01-21T23:59:35ZBruce··—Hansen··06-04-1995UNKNOWN·N/A-—3759 WILLOW CTAustinTX78735UNKNOWN—
CLMCLM-4221732026-01-12T00:11:12ZLORI··ROBINSON1955-05-14N/A—-null1793 Mountain View DriveTampaFL33627·nullMEDICARE-ADV-B
CLMCLM-4185402026-04-18T12:53:42ZAshleyEThompson22-11-1999UHC-62776-77nullN/A—8765 Central AveEden Prairie·MN55320UNKNOWNNULL
CLMCLM-4190172026-04-25T04:39:55ZRICHARD—SNYDER06/12/42····NULL··N/A··2861 Main StChandlerAZ85246UNKNOWNCHOICE-PLUS-PPO
CLMCLM-4249742026-07-25T05:00:22ZTEERESA—BISHOP1961-04-10UHC-34907-30NULL6129120926NULL314 Church St #391TampaFL33601GRP-6012OPTIONS-PPO
CLMCLM-4093542026-03-05T09:45:44ZMegan··Lee01/08/2001UHC-95660-41•••-••-9708(951) 644-2188—153 Bayshore DriveSacramentoCA95845GRP-9569MEDICARE-ADV-B
CLMCLM-4134552026-02-28T02:13:43Zhannha—ferguson11-12-1991UHC-39726-66•••-••-27145204389894hannah.ferguson@outlook.com3085 JEFFERSON AVENUEEden PrairieMN55306GRP-2310NAVIGATE-HMO
CLMCLM-4311562026-03-13T16:44:30ZHelen—Munoz··23-08-1999—•••-••-4443·(650) 570-0591null7417 Forest AveSan DiegoCA92146GRP-1505-
CLMCLM-4215612026-08-10T14:30:54Z·Billy—Williams·4/7/1950UHC-03915-92—·2515010182NULL6354 Baseline RdHoustonTexas77045GRP-9531null
CLM CLM-406762 2026-09-18T03:17:49ZJordan··KBarnes25-05-1982UHC-12682-64N/A12848833622jordan.barnes91@aol.com5047 WASHINGTON STPlanoTX75082GRP-4049MEDICARE-ADV-A
CLMCLM-4023532026-05-14T10:29:33ZRalph—Woods07/26/1967—UNKNOWN—N/A6887 Spring StreetTampaFlorida33671—MEDICARE-ADV-B··
CLMCLM-4125472026-02-03T18:54:53ZRachelD.·Coleman1949-10-19UHC-34040-77N/A13024390138RACHEL.COLEMAN@YAHOO.COM935 Meadow LnAtlantaGA30376GRP-3693OPTIONS-PPO
CLMCLM-4208092026-01-19T09:06:37Z mariana—jackson1992-11-20UHC3693996•••-••-3344—N/A8346 PALM DRIVEAustinTX78738UNKNOWN-
CLMCLM-4200412026-02-17T05:44:14ZVirginia—Wilson··1999-05-18UHC8826797•••-••-8044——7763 Oak Street #570··San AntonioTX78268-2900GRP-8161—
CLMCLM-4036222026-07-19T20:28:27Zashley—vargas1998-11-05UHC-01359-34•••-••-0533——null——-GRP-7068—
CLMCLM-4190222026-02-11T15:43:20ZKatherine—Aguilar19510107··—N/ANULLUNKNOWN3243 Grand AveLas VegasNevada89104GRP-5384NAVIGATE-HMO
CLMCLM-4111332026-03-11T12:10:25ZGarcia, Lori——06/24/93UHC-39221-56NULL——988 SAGE COURTTampaFL··33691N/ACORE-HMO
CLMCLM-4230962026-01-13T17:24:01ZKaren—Green06/27/53-—+1 672 613 2324-1578 Camelback RoadDALLASTX··75298-9853UNKNOWN—
CLMCLM-4207222026-07-18T19:34:25ZBarbara—Adams10/03/65UHC-39914-52····+1 553 368 3724—····UNKNOWNnullUNKNOWN·GRP-5614—
CLMCLM-4138942026-01-07T17:59:08Zanna—ellis1967-11-23UHC-86115-09•••-••-0769null—4372 Lake View RdSacramentoCA95841—····
CLMCLM-4307842026-02-10T19:23:42ZCATHERINE—MARSHALL12/18/99-—5655780944NULL··5936 River RdTucson·AZ85759—CORE-HMO
CLMCLM-4143052026-05-21T14:21:47ZCherylTJacobs1974-07-10UHC-69318-52—(835) 253-8081—8057 Harbor BoulevardMINNEAPOLISMN55439GRP-5660—
CLMCLM-4043462026-01-12T02:21:37ZAmber—Pierce2006-01-14UHC-31742-53N/AUNKNOWN··UNKNOWN8563 Indian School RdMinneapolisMN55448·GRP-0206CORE-HMO
CLMCLM-4239342026-02-23T07:38:55ZKenneth—Johnston02/15/1978UHC-37895-83•••-••-4733N/A—5511 Apache BoulevardMesa·AZ85213GRP-9563—
CLMCLM-4263082026-02-20T15:03:15Zruth—collins1938-02-06UHC-81446-80•••-••-5265NULLN/A4725 Harbor BlvdCharlotteNC28279GRP-5432-
CLMCLM-4222432026-06-21T01:02:24ZAdamBYoung19920770UHC8891495•••-••-8216UNKNOWN—9456 MESA DRIVETempeAZ85277GRP-2972····
CLMCLM-4171932026-07-19T09:26:04Zfrances—hillJul 26, 1966null•••-••-99795736357429—7104 Jefferson AveScottsdaleAZ85237NULLMEDICARE-ADV-B
CLMCLM-4292902026-10-15T19:05:09ZVirginia—Wong1971-03-07-NULL671-435-7218-6349 River RdChandlerAZ—-UNKNOWN
CLMCLM-4196262026-04-09T01:50:10ZDONNAP·YOUNG1959-04-09UHC-09777-54—UNKNOWN·donna.young@icloud.com9562 GRAND AVETAMPAFL33640UNKNOWN··OPTIONS-PPO
32,829 rows, page 79 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.744Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty