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-4029112026-01-04T16:05:11ZCYNTHIA—GIBSON·1952-11-09UHC-98065-16NULL—NULL8464 Jefferson AveTempeAZ85239NULLOPTIONS-PPO··
CLMCLM-4196832026-02-22T19:56:56ZDorothy—Lawrence4/11/1966UNKNOWN···-NULLdorothy.lawrence@proton.me·1167 Canyon RoadLos AngelesCalifornia90087··—NULL
CLMCLM-4282292026-02-08T08:52:05Z·Bryan····Foster2001-12-01—•••-••-2391UNKNOWNNULL636 Ocean AveFRESNO·CA93709UNKNOWNMEDICARE-ADV-B
CLMCLM-4130052026-09-13T14:13:58ZLAURENSVALDEZ21-06-1944—•••-••-7421—····—UNKNOWN··UNKNOWNUNKNOWNN/ASELECT-EPO
CLMCLM-4040072026-07-01T12:16:40ZEUGENE—YOUNG·07/25/1983UHC-39535-18null253-870-0296null4495 River RoadDallas··TX75204nullN/A
CLMCLM-4077052026-01-12T20:29:44ZBradley, John——1973-03-13UHC-80398-48—5965673213—349 River RoadChandlerArizona85266—-
CLMCLM-4008112026-07-24T02:31:52ZBrandon—Russell1944-07-24UNKNOWN··•••-••-6204888-680-6197brandon.russell2@aol.com7081 Main StJacksonvilleFL··32262-4419NULL-
CLMCLM-4105402026-01-04T12:31:09ZHeather—Diaz·03/08/1945UHC-41818-71UNKNOWN771.973.1873null·2988 Baseline RoadAustinTX78701GRP-2772NULL
CLMCLM-4326902026-08-01T20:09:11ZSUSANUHART10/02/1938uhc-24309-19—·355.600.6318—3896 Baseline Road·CHARLOTTENC28296GRP-4554MEDICARE-ADV-B
CLMCLM-420099 2026-02-12T00:02:55ZDOROTHY—GREENE·11/01/65UHC-20965-16•••-••-1822UNKNOWNDOROTHY.GREENE@GMAIL.COM1956 Indian School RdGLENDALEAZ85338GRP-2307··
CLMCLM-4245842026-01-01T11:30:16ZAlexander—Moore·1977-02-04——null··N/A6873 Pine Drive Apt 39ScottsdaleAZ85215GRP-2489NULL
CLMCLM-4213152026-06-21T15:38:29ZEma—Hayes11/22/1947UHC-08659-93-(438) 618-4440NULL7363 Cedar Lane··CharlotteNC28215GRP-8584—
CLMCLM-427392 2026-07-08T23:03:26ZCynthia—Gardner2006-05-19UHC-87765-08—N/ANULL2372 Bayshore DrScottsdale··AZNULLGRP-6591—
CLMCLM-4086072026-05-09T04:44:06ZEUGENE······EVANS1996-11-21UHC-63484-44null8443900229-6250 Mountain View Dr #486Scottsdaleaz85272GRP-3639—
CLMCLM-4171122026-02-21T12:27:06ZALAN—·LANE06/10/82UHC-36065-99-UNKNOWN—3933 Pine DrPlanoTX75096GRP-5703UNKNOWN
CLMCLM-4170612026-06-23T10:06:41ZKEVIN—CARR·1999-05-26UHC-60832-66NULL··3872349753-———N/AUNKNOWN··MEDICARE-ADV-A··
CLMCLM-4127852026-04-18T11:48:15ZLAWRENCE····GRIFFIN1992-03-19UHC1607131-6382468560·lawrence.griffin59@outlook.com7319 PINE DR··ColumbusOH43291GRP-2014OPTIONS-PPO
CLMCLM-4232572026-08-01T08:08:26ZMark··QHowell2000-10-15—•••-••-0351UNKNOWNUNKNOWNnullnull—NULL——
CLMCLM-4240062026-05-06T12:17:23ZStewart, Jordan——08/17/58UHC-47141-73··N/A4626014149NULL8097 Main St·Glendaleaz85316NULLNULL
CLMCLM-4161172026-08-19T16:00:13ZJack—Sims··09/21/83UHC-08090-72—(824) 989-4889N/A8391 Harbor BlvdPlanotx75073··GRP-9745MEDICARE-ADV-A
CLM CLM-4118292026-04-05T13:43:09ZBeverlyL.Rios2008-08-05·UHC-19162-50—-····6429 CANYON RDChandlerAZ·85269GRP-5085NAVIGATE-HMO
CLMCLM-4299182026-07-21T06:54:21Z·ANAY··MCCUYSep 24, 1965NULL•••-••-8355+1 834 577 4490ana.mccoy61@yahoo.com2208 Highland AveSan DiegoCA92192UNKNOWNnull
CLMCLM-4034532026-06-11T06:25:46Zabigail—mcdonald1969-07-26UHC-91015-76•••-••-9460—N/A··——N/AGRP-6616null
CLMCLM-4326282026-05-13T07:36:09ZMargaretB··Vasquez1962-10-26UHC-19632-97•••-••-3115558-561-0720-7899 Church StreetSCOTTSDALE·AZ—GRP-8809CORE-HMO
CLMCLM-4267802026-01-02T23:04:23ZSUE····WARD1976-10-13UHC-82540-45—N/Anull1262 Canyon Rd·COLUMBUSOH43220GRP-0434CORE-HMO
CLM CLM-4011052026-02-15T01:27:20Z·JAMES—SARA1964-06-24—•••-••-6574(515) 208-7217—·2639 Sage CourtTEMPEAZ—GRP-1937—
CLMCLM-4317632026-08-14T22:11:52ZDylan—Alexander2003-08-15uhc-29580-17····5559234313—-N/A——GRP-6288MEDICARE-ADV-B
CLMCLM-4311242026-06-10T02:24:04Z·Jacob—Allen1999-06-02UHC-06582-86-——-—·N/AN/AGRP-7641null
CLMCLM-4062752026-07-20T20:01:38Z·FrancesC.MasonMar 7, 1979UHC-03601-50•••-••-3026N/A—N/ANULL—N/AGRP-3971NAVIGATE-HMO··
CLMCLM-4288242026-07-04T05:30:36ZHoffman, DennisJ—UNKNOWNUHC-46207-75null4645087927—1521 Market StLos AngelesCA90089GRP-6303NAVIGATE-HMO
CLMCLM-4064602026-09-12T05:55:16Zkenneth—roberts01/07/1976UHC-87369-79NULL-N/A———N/AGRP-9246—
CLMCLM-4141402026-01-26T06:47:02ZRaymond—Banks1966-04-28··UHC-72994-01•••-••-4260-—3219 GRAND AVENUEEden PrairieMinnesota-—MEDICARE-ADV-B··
CLMCLM-4294952026-08-07T10:15:34ZCheyrl—Little28-09-1992UHC-89021-43—(521) 609-3799—4835 HILLCREST ROADEden Prairiemn55390—NAVIGATE-HMO
CLMCLM-4162322026-07-26T23:04:51ZAmanda—Washington20000701UHC9824234—·+1 773 788 3172—2909 SPRING STREETCharlotte··NC28257GRP-9681·UNKNOWN
CLMCLM-4169672026-06-12T00:19:46ZAlice—Bailey1960-05-04UHC-91287-15UNKNOWN···7244840697—1607 Union St Apt 28PhoenixAZ85029GRP-5716N/A
CLMCLM-4257602026-06-20T02:52:27Zabbigail—morrison·04/01/50UHC-09145-97—-UNKNOWN928 Bayshore DriveMinneapolisMN55448-6780GRP-8104NULL
CLMCLM-4017352026-03-25T04:34:40Z·Carol—Carter1941-03-06UHC-13659-35•••-••-6893null—1517 Apache BlvdEDEN PRAIRIEMN55369GRP-8264NULL··
CLMCLM-4174322026-06-05T01:41:28ZBarb—Ruiz1958-07-24UHC-08229-93—+1 279 710 4004——————OPTIONS-PPO
CLMCLM-4003342026-02-28T04:59:47Zterry··—edwards1951-05-81UHC-82887-97··•••-••-1529(914) 635-5492N/A1429 Desert Sky BoulevardMiamiFL33169GRP-4954NULL
CLMCLM-4116312026-06-22T05:09:27ZTERRY—COLEMAN1939-09-10UHC-28889-03•••-••-3837N/Aterry.coleman88@proton.me9252 Lake View RdGilbertAZ·85229GRP-8526—
CLMCLM-4058872026-04-04T16:14:31ZEthan—Robertson··1965-12-09UHC-07705-11UNKNOWN536-330-2824NULL4600 Canyon RdSeattleWA··-GRP-9363-
CLMCLM-4245902026-04-21T16:11:17ZAlvarez, Jacob——1972-04-09UHC-66933-02•••-••-9211555-293-7460—NULLNULL-UNKNOWN-NULL
CLM CLM-4062182026-05-12T13:19:33ZFRANK—ARMSTRONGNov 7, 1977UHC-73728-14NULL479-722-8556N/A8373 Mesa Drive··SeattleWA98100GRP-4697SELECT-EPO
CLMCLM-422049 2026-03-30T00:26:59ZERIC—HLAL1956-12-06—-+1 203 290 3503null—null—UNKNOWNGRP-9147MEDICARE-ADV-B··
CLMCLM-4096112026-04-15T11:06:01ZVirginia—Mertin1953-05-18UHC-82287-41N/AN/AN/Anull··——-GRP-3311MEDICARE-ADV-A
CLMCLM-4250262026-07-08T07:12:14ZGeogre—Austin09/20/38UHC-22482-04NULL(490) 397-8675—3710 Bayshore DrPHOENIXAZ85073-7334N/AUNKNOWN··
CLMCLM-4053852026-09-04T01:11:57ZIsabellaK.Andrews1959-10-19UHC-83174-58•••-••-7802——7949 Mesa DriveCharlotteNC28280—select-epo
CLMCLM-4137052026-06-11T10:24:59ZBEVERLY—RUIZ1972-02-15UHC-85465-78—15218812450UNKNOWN159 Church Street·TEMPEAZ85289-N/A
CLMCLM-4137282026-05-12T08:33:29ZMenedz, Laura——1995-12-09UHC-60316-23•••-••-9258———NULL-—N/ACHOICE-PLUS-PPO
CLMCLM-4160992026-03-25T02:41:05Z·DANIELLE—KING1982-05-23UHC-42664-83N/A—null6050 Park PlFresnoCalifornia93707-5653GRP-2092—
32,829 rows, page 18 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:34.781Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty