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-4165022026-06-03T08:02:13ZJesse—·Barnes19690323UHC-14334-26•••-••-0128nulljesse.barnes89@icloud.com2923 Church StMiamiFLnullGRP-4283CORE-HMO
CLMCLM-4034022026-04-03T08:48:55ZSofia—Carpenter07/07/95UHC-20485-01·-NULL—UNKNOWN-null—GRP-4014—
CLMCLM-4015342026-06-26T13:26:40ZDonna—Myers1972-10-07UHC-84044-07——NULL·null——N/AGRP-6574—
CLMCLM-4034042026-01-25T08:54:08ZKeith··Lawrence1/22/1973UHC-56811-34——keith.lawrence@proton.me7530 MAPLE AVENUEDenver··CO80247NULLOPTIONS-PPO
CLMCLM-4259582026-04-02T19:03:34ZRobert—·Hill2000-11-17—•••-••-7341(239) 651-1620robert.hill57@outlook.com—NULLUNKNOWNnullGRP-5716MEDICARE-ADV-B
CLMCLM-4183072026-09-03T12:40:46ZETHAN··KENNEDY1960-09-08UHC-60111-50—674-752-0478null3654 Washington StTampaFL33609··UNKNOWN
CLMCLM-4211632026-06-04T17:14:19ZElijah—Carlson7/25/1990·UHC-45667-50•••-••-6231616-401-1340—7199 BroadwayMiamiFL—null··N/A
CLMCLM-4162582026-08-09T00:12:21ZBeverly—Sanchez1980-11-10UHC-76900-91null··—N/A——-UNKNOWNGRP-8900OPTIONS-PPO
CLMCLM-4312782026-04-17T00:44:42ZMarshall, Nicholas——12/11/1955UHC-05205-98•••-••-2262+1 649 853 2301N/A779 Elm StAtlantaGeorgia30336-4786—NAVIGATE-HMO
CLM CLM-4056232026-07-24T19:41:21ZTimothy—Howell1953-09-28··UHC-30686-19—552-691-5775-·5103 Oak StPLANOTX75062GRP-7963MEDICARE-ADV-B
CLM CLM-4191062026-06-01T08:24:27Zgreg—reid1943-07-18—··UNKNOWN—2914 Maple AveAtlantaga30399nullSELECT-EPO
CLMCLM-4183462026-04-12T09:48:52ZJoanDBishop11/01/60UHC-81997-94—+1 376 614 9480NULL2326 CANYON ROADTAMPAfl33670GRP-8013NAVIGATE-HMO
CLMCLM-4283802026-03-04T00:22:31ZStephanieNEvans·2005-06-17UHC-34729-41····NULLNULL8831 Baseline RoadHoustonTX77092-2423GRP-8521navigate-hmo
CLMCLM-4194712026-08-15T08:57:09ZKIMBERLY····SIMMONS02/12/1997—•••-••-5697-UNKNOWN5330 Park PlMIAMIFlorida33186GRP-2967null
CLMCLM-4238082026-08-15T23:47:46ZCHRISTINEECUNNINGHAM02/17/2002UHC-89978-63-UNKNOWN··—5620 CANYON ROADChandlerAZ85224-1034GRP-5434NULL
CLMCLM-4104842026-04-28T04:23:49ZCarolyn—Price12/07/2005—-··630.299.1698—8651 RIDGE ROADAtlantaGA·30391GRP-0374CORE-HMO
CLMCLM-4013622026-06-05T20:11:26ZCHERYL—CHEN10/27/1997·UHC-19223-34—321.331.0797—3073 Park PlacePlanoTexas75093NULL··NULL
CLM CLM-4221252026-10-12T21:24:50ZPatel, Donald—····1989-03-28—··7724414294N/A958 Cedar LnDenverCONULLGRP-9596null
CLMCLM-4130012026-05-10T14:59:24ZJEAN—GRAHAM8/15/1961UHC-91965-70··NULLnull—1653 RIDGE RD Apt 1TampaFL33658—MEDICARE-ADV-A
CLMCLM-4279612026-02-27T11:10:58ZBeverly·MMartin1939-09-14·UHC-82779-58•••-••-9487790-781-0395——N/ANULL-GRP-7290NULL
CLMCLM-4193382026-08-17T13:58:54ZFatyma—Espinoza1987-11-15UHC-85345-13null—N/A—N/A——GRP-0425MEDICARE-ADV-A
CLMCLM-4198052026-08-13T02:44:00ZNoah—Hunt2004-06-14··UHC-24276-37——-———-—OPTIONS-PPO
CLMCLM-4318652026-03-02T18:04:52Zlawrence—weaver1979-05-28—•••-••-59338639601548null9358 Canyon RdDallasTX·75225NULL·CORE-HMO
CLMCLM-4273302026-09-06T14:44:57ZALEXANDER··OBRIEN20-05-1970—•••-••-0255NULLALEXANDER.OBRIEN@OUTLOOK.COM618 SAGE COURT··ColumbusOH43236UNKNOWNnull··
CLMCLM-416540 2026-05-07T11:48:29ZVIRGINIAL.WATKINS··1948-06-01UHC-85208-07UNKNOWNUNKNOWNUNKNOWN1208 Forest AvenueScottsdaleAZ85294GRP-2499MEDICARE-ADV-B
CLMCLM-4072422026-02-19T20:27:51ZKYLE····LOPEZ5/5/1956UHC-73389-11•••-••-02049442025083-5858 Sage Court Apt 23Chandleraz·85219-6295NULLN/A
CLMCLM-4006712026-01-28T10:21:49ZMelissaH.··Espinoza1953-11-24UHC-88231-39•••-••-4592·658-306-5744·NULL7482 Mesa DriveGlendale··AZ85307GRP-5643MEDICARE-ADV-A
CLMCLM-4169752026-08-03T06:56:59ZBENJAMIN····FRANKLINMay 28, 1976UHC8830624•••-••-3216—null6093 Central AvenueEden Prairiemn—GRP-1945CHOICE-PLUS-PPO
CLMCLM-4299592026-08-18T07:03:22ZJERRY—DEAN··1977-11-14·-•••-••-81476989627—5719 Lincoln WayCHARLOTTENC··—GRP-3450MEDICARE-ADV-A
CLMCLM-4089832026-04-16T19:40:25ZSteve··Carlson·09-05-1953UHC-58376-55-——655 Central Avenue···AUSTINTX78703GRP-4941core-hmo
CLMCLM-4178162026-09-25T15:34:25ZKarenHBisop1939-10-24UHC6525019UNKNOWN——1677 Lincoln WayAtlantaGA30360GRP-6079····
CLMCLM-4100072026-02-26T13:55:29Z Ronald—Perez1992-01-17UHC-32632-12·N/ANULL··UNKNOWN8671 Pine DrAUSTINTX78765UNKNOWNnull
CLMCLM-418299 2026-01-29T10:06:41ZGloria—DeanFeb 17, 2002UHC-59777-51N/AN/A—3807 Meadow Ln··Plano·TX——null
CLMCLM-4020922026-03-27T01:43:18ZRaymond—Hart··19730308UHC-46604-84•••-••-592714414062269—2095 MARKET STREET··EDEN PRAIRIEMN55309GRP-5600MEDICARE-ADV-A
CLMCLM-4275062026-10-16T23:07:38ZLawrenceWHayes1966-03-25UHC-29287-75•••-••-08569976447N/A-—-—NULLMEDICARE-ADV-B
CLMCLM-4200882026-07-14T16:36:56ZLindaMStone··1938-10-05UHC-41475-82——UNKNOWNNULLN/A·-—GRP-8306NAVIGATE-HMO
CLMCLM-425903 2026-05-23T00:42:40ZAguilar, Megan——1961-12-14nullnullNULL····—NULLN/A-GRP-4775NULL
CLMCLM-4058502026-09-06T19:43:37Z·Maria—Yang··1949-06-05N/A—UNKNOWNmaria.yang28@proton.me7584 HILLCREST RD··AtlantaGA30354GRP-2084null
CLMCLM-4145062026-07-03T21:26:20ZweiT.willis11/23/1998UHC-55764-27—884-661-3508null·107 Meadow LaneDallasTX75249GRP-5626MEDICARE-ADV-B
CLMCLM-4125122026-01-13T00:27:56Zana—jenkins01/22/46UHC-83983-70—777-859-7230ANA.JENKINS84@YAHOO.COM882 Broadway Apt 28COLUMBUS··OH43233-OPTIONS-PPO
CLMCLM-4114092026-04-20T18:21:34Zbeverly—schultz19800715UHC-92488-45NULLnullUNKNOWN9639 UNION STREETNashville·TN37287NULLCHOICE-PLUS-PPO
CLMCLM-4215872026-06-15T18:56:29Zdoris—guzman··1956-10-23N/Anullnull—3126 INDIAN SCHOOL RDMinneapolisMN55466GRP-7067CHOICE-PLUS-PPO
CLMCLM-422606 2026-07-04T06:42:35ZmeganVcarter1953-09-14UHC1612953•••-••-4780—N/A2354 Canyon RdTucson·AZ85771N/ACORE-HMO
CLMCLM-4053842026-02-11T01:12:48ZCHISTOPHEROWALLACE08/07/2000——529.751.7988christopher.wallace@outlook.com2898 Indian School RdSan DiegoCA92101-9019GRP-7556·null
CLMCLM-4042842026-06-23T01:36:49ZBENJAMIN—RICHARDSON1958-04-17UHC-80303-69··560-644-6879null6480 INDIAN SCHOOL RD·DallasTXN/AGRP-1567MEDICARE-ADV-B
CLMCLM-4289622026-04-12T14:04:29Z·Ykui—Vazquez1960-04-08UNKNOWNnull—yuki.vazquez@proton.me6603 Camelback RdMiamiFL33192GRP-6919NAVIGATE-HMO
CLMCLM-4061142026-06-22T03:43:29ZJUAN—BANKS1979-05-19———NULL7773 Forest AvenueLas VegasNV89164NULL··null
CLMCLM-4274972026-09-24T05:31:14ZLogan—Ortyz1975-01-01UNKNOWN-UNKNOWNUNKNOWN·2251 Grand AvenueLas VegasNV89141—OPTIONS-PPO
CLMCLM-4174682026-06-27T11:14:13ZBobby—Mendez1987-11-04uhc-62846-21N/Anull—-—null—GRP-0515SELECT-EPO
CLMCLM-4163832026-09-21T03:48:34ZHudson, Hiroshi——1986-10-26UNKNOWN•••-••-7582-UNKNOWN—NULL-—GRP-4910MEDICARE-ADV-B
32,829 rows, page 87 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.758Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty