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-4262832026-10-03T20:51:12ZNathan—Crawford06/03/02uhc-83107-81··nullNULL—·null———GRP-1457MEDICARE-ADV-A··
CLMCLM-411596 2026-03-23T03:28:02Zaustin—morales08-04-1992UHC-73946-07NULL3978119293N/A898 BroadwayCharlotteNC28266-3176GRP-9564N/A
CLMCLM-4221392026-02-06T07:39:35Z danielle—price1967-09-04UNKNOWN—+1 868 523 7340UNKNOWN—null-nullGRP-1869CORE-HMO
CLMCLM-4183572026-01-01T07:16:11ZKelly··Richardson1959-01-18-NULL—··1166 Sunset BlvdATLANTAGA30394——
CLMCLM-4122992026-01-27T13:34:04ZLAWRENCEJ.WATSON19951004——19029864081··9551 CAMELBACK ROADMinneapolisMN··55483NULLMEDICARE-ADV-B
CLMCLM-4001682026-01-28T01:39:19ZWebbb, Bryan——10/09/1961UHC6189496UNKNOWN12515226792N/A5836 Central AveCharlotteNorth Carolina28269GRP-2431CORE-HMO
CLMCLM-4163482026-08-02T06:36:02Zarjun—anderson2006-04-21-—NULLN/A7072 Desert Sky BoulevardAustinTXnullGRP-2226null
CLMCLM-4031872026-05-19T21:51:04ZYukiAHerrera2004-09-05——(220) 917-8255N/A1268 Palm Drive··MinneapolisMN-GRP-0586-
CLMCLM-4045102026-09-27T17:38:11ZDaniel—Allen1944-11-27UHC-80230-70—233-223-8726daniel.allen36@yahoo.com9804 Camelback RoadHoustonTX77018NULLNULL
CLMCLM-4310502026-09-16T14:55:15ZLAWRENCEE·HANSEN1988-02-04NULLUNKNOWNN/Alawrence.hansen21@gmail.com2358 Meadow Lane Apt 21MIAMIFlorida33103N/A-
CLMCLM-4109152026-04-13T10:26:37ZBETTY—WILSOON2001-09-19UHC-90824-27null—null4772 Desert Sky BoulevardTampaFL33684—MEDICARE-ADV-B
CLMCLM-4066142026-03-28T06:33:55ZJose—Roberts1942-07-12UHC-90725-16———1301 ELM STREETJACKSONVILLEFL—GRP-4710OPTIONS-PPO
CLMCLM-4142162026-01-20T20:00:41Zanna—kennedy1955-01-20UNKNOWN··•••-••-7453—UNKNOWN—UNKNOWN··N/AN/A-—
CLM CLM-4276072026-03-07T22:45:50ZRICHARDALAWRENCE1953-06-20··UHC-05636-56UNKNOWN—UNKNOWN7375 SAGE CT #614Eden PrairieMN55371NULL—
CLMCLM-4262562026-01-05T08:02:39ZMarcKMatthews1990-03-08UHC-28870-27•••-••-1340-—4840 MARKET STAustinTexas78755GRP-0629OPTIONS-PPO
CLMCLM-4169302026-02-20T07:42:54ZGonzales, Nathan——2006-02-18UHC-41893-36N/A6422183948—null-nullNULLN/AN/A
CLMCLM-4178632026-06-02T20:25:08ZrogerEblackJul 21, 1992UHC-70794-50N/A—UNKNOWN929 HARBOR BOULEVARDDallas·Texas75217GRP-7634N/A
CLM CLM-4310772026-07-01T08:55:42ZJanet··Lewis19701007UHC-35740-35··(616) 462-4999JANET.LEWIS@OUTLOOK.COM3583 RIVER ROAD·PhoenixAZ85055GRP-3266N/A
CLMCLM-4226882026-01-18T17:01:16ZArthurVLawson··1980-01-04UHC-45410-99NULLN/A··—nullnullUNKNOWNGRP-3970CHOICE-PLUS-PPO
CLMCLM-4094412026-09-26T21:11:19ZCINTHIA—·CASTRO1981-10-06UNKNOWN··——··1248 Sunset BlvdSeattleWashington98189GRP-7224-
CLM CLM-4218862026-03-31T08:44:33ZbrittanyP.·fuller1939-10-04-NULL17165006523—1183 Elm St·MesaAZ85254-9075··GRP-3852UNKNOWN
CLMCLM-4064672026-10-14T01:31:15ZElizabeth—Fox2005-12-07—nullnull—9575 Ocean AveLos AngelesCalifornia90057-1415GRP-8523··choice-plus-ppo
CLMCLM-4191022026-06-10T14:41:55ZJulia····Alexander08/02/93UHC-68877-99nullUNKNOWNN/ANULLN/AN/A—-NULL
CLMCLM-4249592026-09-26T02:37:17ZJesseJWeaver1958-11-12UHC7684880—749.492.7515··UNKNOWN4153 VALLEY VIEW DRIVEFresnoCA93784GRP-7637MEDICARE-ADV-B
CLMCLM-4244462026-09-02T03:47:05ZWheeler, Angela——1952-02-15UNKNOWN—3758530687-1829 GRAND AVENUE #630Jacksonville··FLNULLGRP-6763—
CLMCLM-4038372026-03-23T18:41:33ZchristopherHwalsh··Jan 11, 1987UHC-69478-96-(693) 505-5116—5458 Indian School RdScottsdaleAZ85286-3002nullMEDICARE-ADV-A
CLM CLM-4271952026-06-23T18:13:02ZWilliam····Rose1964-03-08····•••-••-3578(855) 312-3142—5030 Cedar LanePhoenixAZ85035··GRP-0887—
CLMCLM-4146622026-03-10T15:52:49ZSue—Carr2004-06-19nullUNKNOWNNULLnull8577 Spring Street #711CharlotteNC28263GRP-5326OPTIONS-PPO
CLMCLM-4189362026-03-18T11:46:57ZEUGENE··—FULLER08/22/1947-NULL4076674723UNKNOWN738 Market St #787MinneapolisMN··55473N/Anull
CLMCLM-4001222026-08-27T06:25:44ZSofia—Lawson09/07/63UHC-68415-31NULLNULL·null——NULLUNKNOWNGRP-7674MEDICARE-ADV-B
CLMCLM-4163172026-03-15T00:30:29ZCharlotte—Le1980-08-17UHC8822335NULL7436252642UNKNOWN3814 MESA DRIVECharlotteNC28217-2625—-
CLMCLM-4037482026-05-05T22:59:22ZHENRYF···LITTLE26-12-1944·null·N/A-··UNKNOWN266 CAMELBACK ROAD Apt 29AtlantaGA30361-—
CLMCLM-407645 2026-09-24T03:51:58ZDiana—Ryan09/14/1945-NULL(674) 254-3948—5268 Canyon RoadSCOTTSDALEAZ85200··NULL
CLMCLM-4047772026-06-11T02:12:25ZMaria—Ray1984-02-16UHC0246483N/A-—6515 Market StreetGlendaleAZ·85309GRP-7860CORE-HMO
CLMCLM-4094312026-10-04T21:03:40ZAHMEDT.LE2003-06-10UHC-34122-14•••-••-2609—UNKNOWN1420 WASHINGTON ST #228Las VegasNVUNKNOWN··GRP-5547—
CLMCLM-4120852026-05-10T23:37:43ZKyle—HarveyOct 27, 1976UHC-55261-28UNKNOWN890.427.1769—4135 Sage CourtSan DiegoCA·92196GRP-2967—
CLMCLM-4212612026-10-06T06:39:28ZDOROTHY—BRADLEY1952-09-12UHC-61130-89•••-••-38756219104998dorothy.bradley7@proton.me634 Canyon RoadSeattleWashington98100GRP-3375CHOICE-PLUS-PPO
CLMCLM-4298182026-01-14T01:11:32ZGomez, JacobK—19760710uhc-45306-71·null253-237-5044NULL6461 Valley View DrATLANTAGA30380GRP-6772CHOICE-PLUS-PPO
CLMCLM-4038632026-04-04T13:25:15Z Arjun—Vargas··20060309UHC-30971-89•••-••-3011nullarjun.vargas@yahoo.comnullnullnull-GRP-2648UNKNOWN··
CLMCLM-4004982026-10-17T18:28:21ZShaw, Mariana——19520214UHC-69035-21•••-••-6074576-555-0410MARIANA.SHAW@AOL.COM1064 Oak StreetDenverCO80287——
CLMCLM-402355 2026-01-19T07:56:37Z———May 10, 2006UHC-93207-47•••-••-6663NULL——UNKNOWN··-—GRP-7474—
CLMCLM-4253972026-10-09T15:19:21Zomar—castro12/7/1951UNKNOWNnullN/A—7219 Oak StMiamiFL33180-0126GRP-0442select-epo
CLMCLM-4258132026-10-16T06:18:17Z·Jean—Day1943-03-26UHC-32810-59-(218) 634-8777NULL7726 Church StDenverColorado80220GRP-5709choice-plus-ppo··
CLMCLM-4224882026-05-09T10:02:37ZPAUL—VAZQUEZ1995-01-08UHC-55634-10UNKNOWN(978) 262-0349—4886 Lake View RoadPlanoTexas75085GRP-4431MEDICARE-ADV-B
CLMCLM-4206742026-05-16T04:28:32ZMARY—WEBER1964-12-04UHC-98691-21-(694) 940-1767mary.weber@gmail.com8305 Ocean AveGlendaleAZ85301GRP-0323CORE-HMO
CLMCLM-4238802026-04-16T12:27:32ZDiane··Austin11/21/1955UHC-03189-68null864.444.6894N/A2127 Maple AveEden PrairieMN55302GRP-2775NAVIGATE-HMO
CLMCLM-4213862026-01-16T01:16:37Z Diane—Nguyen03/10/1961null—(709) 335-2459N/AUNKNOWN—·nullN/AGRP-4909OPTIONS-PPO
CLMCLM-4202572026-07-14T05:10:39Z·joe—olson1986-02-15UHC-47916-67N/A—N/A8847 Market StScottsdaleAZ85245GRP-6373OPTIONS-PPO
CLMCLM-4159812026-05-17T19:23:47ZCHRIS—HARVEY·03/09/97UHC-40603-08•••-••-0673379.326.1896N/A····—N/A—GRP-2866N/A
CLMCLM-4154062026-08-09T00:07:08ZMichelle—Wong10/18/1959UHC-75999-90•••-••-3742+1 475 201 9065NULL1501 Indian School Rd #627JacksonvilleFL·32250GRP-0894·SELECT-EPO
32,829 rows, page 51 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:36.702Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty