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-4018712026-05-25T04:13:18ZAlbert—Rogers11/21/1965UHC-07011-45——UNKNOWN4423 Lincoln WayScottsdaleAZ··85275··GRP-7378SELECT-EPO
CLMCLM-4045622026-05-04T03:25:53ZKathryn—Burns2002-02-02—-UNKNOWN—N/ANULL——GRP-6312MEDICARE-ADV-A··
CLMCLM-4142022026-07-07T14:32:01ZSATNIAGO—BLACK1982-03-02UHC-79415-28——N/A—NULL··NULL··——CHOICE-PLUS-PPO
CLMCLM-4209752026-06-12T21:24:53ZValentina—Alvarez1962-11-16UHC-86730-68nullnull—2460 JEFFERSON AVEAtlantaGA30378NULLCORE-HMO
CLMCLM-4209012026-10-16T19:33:49ZSARAH—MORRIS1994-05-08UHC-40918-63UNKNOWN4496500273null4576 Harbor BlvdMESA··Arizona85264NULLMEDICARE-ADV-A
CLMCLM-4002192026-09-12T00:35:57ZCAROL—MUNOOZ03/20/1990null•••-••-0570—carol.munoz43@yahoo.com-N/A··—NULLNULL-
CLMCLM-4226812026-07-16T15:42:56ZDYLAN—GRANT1982-08-16UNKNOWN—UNKNOWN—3002 PINE DRIVE··GlendaleAZ85346-OPTIONS-PPO
CLMCLM-4096872026-08-08T18:34:05ZAaronRTaylor1978-06-11UHC-35048-99•••-••-4124226-488-2521null4151 SAGE CTLas VegasNV89197NULLMEDICARE-ADV-B
CLMCLM-4278992026-02-26T13:09:47ZKEITHX.LARSON1994-01-19UHC-83530-31UNKNOWN—-4843 Oak StreetDALLASTX75229GRP-4386MEDICARE-ADV-A
CLMCLM-4252852026-05-30T01:48:42Z Ana—Banks1964-10-09UHC-54583-90—N/Anull2552 Union StHoustonTX77045·GRP-8147N/A
CLMCLM-4241512026-10-16T08:16:23Zfatima—fisher07/19/71UHC-13643-76•••-••-1881848-324-2784null740 Cedar LnTucsonAZ85783—NULL
CLMCLM-4079162026-09-02T00:20:04ZGabrielY·Castro1938-06-04——nullgabriel.castro34@outlook.com7898 Union StATLANTAGA30397UNKNOWNUNKNOWN
CLMCLM-4108752026-06-02T18:47:57ZTomXLuna10-04-1986UHC-64102-71UNKNOWN8902543970—————GRP-4137MEDICARE-ADV-B
CLMCLM-4027772026-01-26T00:27:45ZmasonZmoore19840516UHC-30212-79——··7231 Indian School RdCHANDLERAZ85220GRP-0100N/A
CLMCLM-4157242026-02-10T20:46:10ZRONALD—HERRERA19800914UHC-53971-30UNKNOWN6398054413N/ANULLnullnull—GRP-2985UNKNOWN
CLMCLM-4318642026-03-25T08:06:35ZDORIS···ESPINOZA1965-01-18UHC-94052-91•••-••-7484UNKNOWN-5805 Meadow LaneScottsdaleAZ·85244NULL··NULL
CLMCLM-4086422026-09-11T18:27:21ZAmanda—Cole07/03/1965UHC-99435-72•••-••-9038UNKNOWN··N/A4164 BroadwaySACRAMENTOCA95819NULL—
CLMCLM-4042552026-07-28T18:11:01ZJordan—Ross1975-01-26N/A-····jordan.ross58@proton.me8556 MARKET STREETEden Prairiemn—GRP-7843MEDICARE-ADV-A
CLMCLM-4225852026-07-16T01:08:13ZHeather—Brown10/2/1970UHC-40975-16N/A--2111 Baseline RdMINNEAPOLIS··mn··55466GRP-4840-
CLMCLM-4048132026-07-11T20:23:48ZDENISE—DAVISAug 20, 1990UHC-10523-05N/A18646063712N/A5468 Bayshore DrATLANTAGA30340-9484GRP-6994MEDICARE-ADV-B
CLMCLM-4302712026-02-28T13:42:40ZAARN—MURPHYMay 14, 1990UHC-37198-49•••-••-3764892-619-6294—8259 PINE DRPhoenixAZ85042-0891N/A-
CLMCLM-4269942026-01-15T00:24:45ZHAROLD—MATTHEWS1967-11-23UHC-47451-76—(881) 460-1146··-1371 ELM ST #725NashvilleTN37212nullCORE-HMO
CLMCLM-4020812026-01-06T07:59:31ZLARRY—BUTLER1953-04-19UHC3519272•••-••-5882UNKNOWNN/A··3941 Palm DrSan Antoniotx78201UNKNOWNnavigate-hmo
CLMCLM-4236862026-10-07T12:42:01Zrandy—morris14-04-1994—•••-••-8869UNKNOWN—N/A——nullGRP-4801SELECT-EPO··
CLMCLM-4109282026-10-01T21:52:28ZJooyceAHerrera1942-06-21UHC-61035-88-575-740-3081NULL2531 Ridge RdDallastxnullGRP-3654NAVIGATE-HMO
CLMCLM-4037172026-04-27T14:35:58Zwillie—le2006-12-02UHC-57029-92•••-••-5792(490) 730-2785—3352 Forest Ave Apt 16LAS VEGAS··Nevada89105GRP-9331NULL
CLMCLM-4219902026-04-06T18:34:54Z·Elijah—Greene1988-08-10UHC-82662-56-nullELIJAH.GREENE7@HOTMAIL.COM8413 Church StPhoenixAZ··85050—·MEDICARE-ADV-B
CLMCLM-4227782026-05-27T02:13:43ZMichelle—Burns1938-06-03UHC-94933-30•••-••-0000—··UNKNOWN———GRP-2057NAVIGATE-HMO
CLMCLM-4223982026-07-30T11:42:13ZBETTY—RILLEY·Aug 15, 2003UHC-60575-35•••-••-3576—-9568 Grand AvenueSACRAMENTOCA95862N/A-
CLMCLM-4059302026-05-25T23:48:24ZMICHAEL—WELLSOct 18, 1953·-nullUNKNOWNmichael.wells@icloud.com4425 Mesa DrCharlotteNC28254-0093UNKNOWN-
CLMCLM-4079522026-01-22T22:13:34ZPriyaUNelson1961-02-03UHC-65947-09•••-••-81217128746994-9565 Ridge RdSeattle·WA98154GRP-8882select-epo
CLMCLM-4325982026-05-31T21:34:46ZJoyce—Collins··1941-03-23—-284-813-0637null4149 CHURCH STREETEden PrairieMN55328N/ANAVIGATE-HMO
CLMCLM-4076192026-09-29T13:15:49ZTIMOTHY—·KIM1949-12-24-nullnullNULL·5736 Grand AvenueSAN ANTONIOTX78214—-
CLMCLM-4141032026-01-03T20:16:43ZAmandaUShaw1966-03-05—null——7331 WASHINGTON STCOLUMBUSOH43256·GRP-9009null
CLMCLM-4163632026-05-15T21:32:13ZOMAR—MEIDNA1955-05-19UHC-37490-97NULL—UNKNOWN··3433 MEADOW LANEOrlando··FL32854-4758GRP-9341medicare-adv-a
CLMCLM-4321542026-03-09T09:11:41ZKELLY—GUTIERREZ1990-10-16—NULL-null6693 Maple AvenueLas VegasNV89123—CORE-HMO
CLMCLM-421902 2026-10-11T16:05:40ZAlexis—PriceSep 9, 1958UHC-80433-48—19034940566UNKNOWN1324 Main StScottsdale·AZ85248-6509GRP-3123—
CLMCLM-4299112026-05-17T00:41:51Z·angela—cooper1981-05-11UNKNOWNUNKNOWN2214994935null4250 BroadwayCharlotteNC28288GRP-1456—
CLMCLM-4186452026-07-22T08:40:31Z·STEVEN—CLARK2006-02-12UHC4956783•••-••-9286null—5715 Jefferson AveGlendaleAZ85358GRP-4565—
CLMCLM-4125742026-08-30T16:50:17ZNunezNDouglas01/02/59·UHC-04096-41•••-••-7071806.719.8149—4598 Spring St Apt 13DallasTX75262GRP-3068null
CLMCLM-4114322026-05-31T00:45:24ZNguyen, Harold········1994-06-13nullUNKNOWNN/A··8987 Central AveLos AngelesCA90050GRP-6605—
CLMCLM-4305722026-09-30T07:42:11ZLORI····BRYANT1998-08-20UHC-70153-08UNKNOWN355-574-7096——nullnull-UNKNOWNMEDICARE-ADV-A
CLMCLM-4129882026-09-17T13:43:00ZSean··—Holmes8/13/2003UHC-34874-09··—13073845941··-—-UNKNOWNnullnull-
CLMCLM-4224582026-05-12T03:16:28ZShirley—Baker1984-05-13UHC-45715-13nullNULLUNKNOWN1033 Bayshore Dr··DenverCO80254-UNKNOWN
CLMCLM-410376 2026-09-11T00:31:52ZLarson, Arujn——1991-01-24UHC-89929-24—(985) 440-5454NULL1443 Mesa Drive··PlanoTX75059GRP-1954CHOICE-PLUS-PPO
CLMCLM-4109002026-07-21T21:43:08ZWAYNE··—BENNETT1949-04-19UHC-21799-63··nullnull···null4620 Baseline RoadColumbusoh··—GRP-4776····
CLMCLM-4065562026-09-20T22:07:54ZNICHOLAS—LARSON1993-08-09UHC-90661-50null—UNKNOWN·9895 Sunset BoulevardMinneapolisMN—NULL-
CLMCLM-4169782026-09-13T19:42:53ZEthanH.Green·1966-09-18UHC-13997-72•••-••-1872——9413 Highland AvenueLas VegasNV·89186UNKNOWNMEDICARE-ADV-B
CLMCLM-4163042026-07-22T18:01:24ZANNA—REIID12/1/1965UHC-32350-43•••-••-9998—UNKNOWN6762 SPRING STREETFresnoCalifornia93744GRP-5025CHOICE-PLUS-PPO
CLMCLM-4263282026-04-09T01:33:30Z·FRANK—FERNANDEZ1987-09-07··——421.629.3411FRANK.FERNANDEZ@PROTON.ME2613 Oak Street··ChandlerAZ85215GRP-7848CHOICE-PLUS-PPO
32,829 rows, page 105 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:38.463Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty