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-4166342026-03-19T17:05:37ZBOBBYL.RICE··1938-01-19UHC-16174-42N/A(510) 347-0594NULL8491 Desert Sky BoulevardSacramentoCA95810null—
CLMCLM-4182712026-04-04T04:05:45ZSHYRLEY—MORGAN05/16/97UHC-26269-59•••-••-0160—shirley.morgan75@outlook.com—NULLUNKNOWN—null—
CLMCLM-4072852026-08-14T03:30:38Z CARLGTORRES1978-02-05—UNKNOWNN/A-··897 Lake View RoadAUSTINTX·78768—NAVIGATE-HMO
CLMCLM-4291692026-04-03T19:47:27Zkeith—murphy2002-11-25UHC-50394-87—723-499-0871—7738 Central AvenueLas VegasNV89169-8160UNKNOWN—
CLMCLM-4000472026-04-06T07:05:54Zsandra—rice2005-09-20UNKNOWNN/A388.883.3669UNKNOWN4628 LAKE VIEW RDAUSTINTX78796GRP-3539SELECT-EPO··
CLMCLM-4147102026-02-15T14:02:59ZMARCUSZWEAVER2001-04-01UHC-34510-39UNKNOWN—UNKNOWN7557 Sage CtTampaFL33685GRP-2919UNKNOWN
CLMCLM-4171642026-01-24T00:48:56ZJOYCEQMEDINA12/10/48UHC-72617-64•••-••-95589742914813····9324 Jefferson Avenue··AtlantaGA30321——
CLMCLM-4244312026-03-13T19:16:38Z·Brittany—Arnold1976-06-20UHC-79114-26———2061 Apache BoulevardNashvilleTennessee37254GRP-3088—
CLMCLM-4169162026-05-30T18:03:15ZEmma—Tucker··1964-05-09UHC-70803-55•••-••-0858(812) 677-0647····8985 Hillcrest Road·FRESNOCA93774GRP-7560CHOICE-PLUS-PPO
CLMCLM-4107962026-04-09T14:28:38ZNancy—Carroll·05/04/79UHC-31589-42-nullN/A·6414 MEADOW LANEPhoenixAZ85091GRP-3573SELECT-EPO
CLMCLM-4059572026-04-17T21:39:33ZRACHELMWEST09/13/51UHC5825349-2376717144—-·NULL——·-—
CLMCLM-4260482026-05-23T17:23:30ZSarah··Li1946-03-24UHC-49550-89··+1 736 512 1624sarah.li@hotmail.com4849 Mesa DriveChandlerAZ··85232UNKNOWNN/A
CLMCLM-4165712026-08-19T17:45:06ZJacob—Hall2001-06-06··UHC-90583-09N/A-N/A2618 Ridge RdPHOENIXaz85094GRP-1696null
CLMCLM-4218322026-08-23T16:49:49ZLarry—Hanson7/28/1959UHC-36825-92•••-••-8870(213) 282-2422null5391 Mountain View DriveSEATTLEWA98133NULL·OPTIONS-PPO
CLMCLM-4120402026-02-08T11:05:11ZBRENDA—BANKS08-12-1954uhc-05819-20——null2233 BROADWAYOrlandoFLNULLGRP-8424CORE-HMO
CLMCLM-4164302026-02-10T04:16:41ZANNULUNA2007-08-13null··915.862.7196NULL6600 Hillcrest Road·TucsonAZ85711—medicare-adv-a
CLMCLM-4025852026-04-17T11:47:14ZRUSSELL—LE1941-05-10UHC1941653•••-••-7408700-739-2456··null-··—UNKNOWNN/A·UNKNOWNmedicare-adv-b
CLMCLM-4132612026-07-31T22:15:16ZKaren··Morrison·2000-06-28UHC-23765-47•••-••-9613476-411-6775··NULL—nullNULL—UNKNOWNOPTIONS-PPO
CLMCLM-4100772026-03-28T19:55:28ZMary—Padilla11/16/75UHC0579298N/A651.591.3831null7828 Cedar Ln··Gilbertaz85233·GRP-1135N/A
CLMCLM-4071302026-05-18T02:17:41ZChristain—Yang·1945-08-10UHC-31026-34—900.247.7102·null8005 Willow CourtAustinTX78785··GRP-9756N/A
CLMCLM-4183842026-05-17T19:06:52ZBrendaU.Hernandez1996-04-12UHC-85229-30nullNULLNULL1513 BAYSHORE DR Apt 5SeattleWA98146GRP-1485NULL··
CLMCLM-4240362026-05-13T19:45:22ZJERRY—MARTIN1994-11-16UHC-95865-44——UNKNOWN9420 Baseline Road Apt 19HOUSTON·TX77025N/AUNKNOWN
CLMCLM-4285762026-10-06T00:04:02ZGary—Vargas1949-09-07UHC-01629-87•••-••-1584367.236.2843—UNKNOWN—nullN/A-CORE-HMO
CLMCLM-4090102026-05-15T14:01:07ZJENNIFER—SCOTTApr 26, 1999—-8037048jennifer.scott90@icloud.com4552 Apache BlvdPlano·TX·75006-5208GRP-2849OPTIONS-PPO
CLMCLM-4093752026-06-30T06:49:45ZRalph—Pierce1962-10-19NULLN/A2063445570UNKNOWN·7815 DESERT SKY BLVDNashvilleTN37251-8430N/AUNKNOWN
CLMCLM-4295292026-08-11T06:01:26ZMei····Robertson02/22/87·uhc-47647-46-—UNKNOWN8987 DESERT SKY BOULEVARDJacksonvilleFL32275GRP-5276—
CLMCLM-4045922026-07-03T17:01:32ZJason—King1976-08-06——806-587-3303····9255 Palm DriveFresnoCA93751-N/A
CLMCLM-4147712026-08-01T15:34:31Znicole—rogers1957-02-15NULL-NULLN/A3399 Sunset BoulevardJacksonvilleFL32220GRP-7927MEDICARE-ADV-A
CLMCLM-407770 2026-03-31T06:10:58ZNoah—Miller··2003-01-20UNKNOWN•••-••-6224868.704.1115—468 Bayshore DriveScottsdaleAZ85250N/AN/A
CLMCLM-4074272026-03-19T12:35:00Zwiill—burns2002-02-08UHC-17222-97UNKNOWN306-474-4265—4216 APACHE BOULEVARD··FresnoCA93781GRP-6536··NULL··
CLMCLM-4317072026-10-12T11:46:25ZChristine—Wallace1962-08-25N/A··-252-729-5340—8665 Camelback RdEden Prairie··MN55309-NULL
CLMCLM-4086722026-03-14T08:07:04ZWillie····Webb20060924UHC-15119-47··•••-••-9500N/AN/A7251 WILLOW COURTMiamiFL--··MEDICARE-ADV-B
CLMCLM-4249852026-04-20T23:58:23ZGrace—Lane07/05/1966null•••-••-64444458626076null7022 Lincoln WayDALLAS··TX75290GRP-6437CHOICE-PLUS-PPO
CLMCLM-4017752026-03-27T06:13:12ZTyler—Taylor2000-06-06UHC-19451-27N/A831-578-1085-9668 HILLCREST RDCharlotteNC·28271-8855UNKNOWN—
CLMCLM-4254262026-10-14T01:14:36ZPark, Barbara——05/01/1982UHC-16638-84··•••-••-7222NULLN/A4177 PINE DRIVEScottsdaleAZ85224GRP-3609core-hmo
CLMCLM-4007062026-03-18T16:18:22Z·Kyle—Nelson9/4/1949UHC-49038-08——N/A9867 Ridge RoadCOLUMBUSOH43227GRP-1258NAVIGATE-HMO
CLMCLM-4039522026-03-09T14:06:16ZCooper, Bobby——1998-12-01NULLnullUNKNOWN————-GRP-2736N/A
CLM CLM-4099612026-09-17T11:25:42Zvirginia··F.hayes1980-02-12UHC-99818-07N/A(648) 805-6139N/A2603 Jefferson Ave #211Los AngelesCA90082—SELECT-EPO··
CLMCLM-4110072026-06-23T23:04:10ZStewart, Jeffrey··—····03/24/95UHC-18721-55··N/A+1 206 953 8887—6049 Grand AvenueColumbusOH43289GRP-7650—
CLMCLM-4112462026-03-27T18:01:52Z Steve—Phillips1955-03-05UNKNOWN··•••-••-4741··UNKNOWN486 Bayshore DrNASHVILLETN37224nullN/A··
CLM CLM-4295902026-01-31T14:11:49ZDonna··Adams1983-01-09UHC-77847-88—--3296 Forest Avenue·MesaAZ85224GRP-7183SELECT-EPO
CLMCLM-4139762026-02-08T01:37:14ZCHRISTINA—OWESN1984-12-01——·511-321-2085null—·UNKNOWNN/AN/AGRP-4706-
CLMCLM-4055482026-06-30T04:37:14ZAhmed—Welch09/19/86UHC-38427-46UNKNOWN3773730239—·UNKNOWNN/AnullNULLGRP-6781MEDICARE-ADV-B
CLMCLM-4013812026-01-06T06:00:20ZJose—Olson2003-05-28uhc-32021-76•••-••-9177null—5299 Elm StJacksonvilleFL32210UNKNOWNNAVIGATE-HMO
CLMCLM-4015972026-05-18T22:34:45ZPorter, BrandonE—9147-04-22—N/A757.597.6324··7764 Pine DrMiamiFL——N/A
CLMCLM-403347 2026-09-07T15:13:36ZSofiaC.Vargas1954-02-16—N/A534-214-2508UNKNOWN2814 CENTRAL AVENUETucsonAZ85706-5103—SELECT-EPO
CLMCLM-4308092026-02-25T17:42:47ZjordanP.evans1991-12-13UHC-87973-57null(488) 679-8562—6438 Sage CourtColumbusOH43256GRP-3493MEDICARE-ADV-A
CLMCLM-4180192026-06-21T22:20:37ZJulia—VasquezNov 28, 1955UHC-21529-95UNKNOWNnulljulia.vasquez43@icloud.com————GRP-8727medicare-adv-a
CLMCLM-4206542026-10-08T05:37:54Z JLIE—KELLY1984-06-24UHC-04129-50N/A(922) 361-2848UNKNOWN6254 BROADWAYScottsdaleAZ85298-3783—CORE-HMO
CLMCLM-4058342026-09-22T02:43:25ZHiroshiY.Price01/23/75UHC-21169-37—14393906066-null—N/A····GRP-6591-
32,829 rows, page 181 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:40.619Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty