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-4119502026-08-12T02:53:40ZAndreaFCunningham2002-03-21UHC-76946-30•••-••-0377NULL———null··—UNKNOWN—
CLMCLM-4071532026-05-13T14:35:46ZRUSSELL—DUNN5/24/2006UHC-33552-97UNKNOWN—··2113 Spring StreetMinneapolisMinnesota55494NULLCHOICE-PLUS-PPO
CLMCLM-4124142026-03-29T13:09:51ZSmith, Harold——1965-12-25NULL•••-••-5746null-6838 Camelback RoadDenverCO·80214GRP-0362SELECT-EPO
CLMCLM-4004772026-03-15T18:24:01ZHIROSHI—ORTEGA·11/11/1979UHC-36461-06UNKNOWNnullNULL188 ELM STREETAustinTX78799GRP-1116··—
CLMCLM-4107682026-08-08T05:51:20ZSoto, Ahmed——1938-03-10UHC-22956-92•••-••-9371-—8663 LAKE VIEW RD··TUCSON·AZ85743UNKNOWNOPTIONS-PPO
CLMCLM-4217012026-08-24T06:33:18ZAlbertKGonzalez09/15/68UHC-36932-95nullUNKNOWN—9216 Indian School RoadMesaAZ··85200··NULL—
CLMCLM-410211 2026-01-17T19:09:37ZPhilipQGeorge10/03/1973UHC-42855-64—6342069013null·3287 Main StPhoenix·AZ85055GRP-0866—
CLMCLM-4321902026-04-05T15:30:54ZDoris—OBrien1973-11-11··—-NULL-8287 Grand AvenueFresnoCAUNKNOWNGRP-2666MEDICARE-ADV-A
CLM CLM-4009492026-10-12T02:41:54ZHeatherILopez1941-12-08UHC-55811-29•••-••-8565(540) 631-6183—2352 Ridge Road·SeattleWAUNKNOWNN/AN/A
CLMCLM-4150842026-02-03T06:06:14ZJoseph—Vasquez2003-04-28—N/AN/Anull4444 Palm DrSacramentoCA—GRP-0583N/A
CLMCLM-4000382026-03-29T22:47:53Zsara—snyder1960-07-03UHC-12811-54····+1 282 360 4106null··1546 Sage CourtTUCSONAZ85712nullMEDICARE-ADV-A
CLMCLM-4232482026-10-15T13:05:14ZSophia····Lawrencce05/04/89UHC-54923-39-2544280562sophia.lawrence90@yahoo.com2752 Valley View DrCHARLOTTE·NC28215GRP-5553NAVIGATE-HMO
CLMCLM-4048252026-01-30T05:40:20ZHEATHER—MYERS04-01-1958UHC-23811-98—4379955558null5967 RIDGE ROADPhoenixAZ·85039GRP-7658NAVIGATE-HMO
CLMCLM-4048902026-04-20T04:39:45ZSAMANTHA—GONZALEZ··04/09/39UHC-43456-07—403-511-4429samantha.gonzalez6@outlook.com9765 Meadow LnSAN ANTONIOTX78275N/AMEDICARE-ADV-A
CLMCLM-4211902026-02-05T17:37:48Z·Brian—·Fuller1992-11-16UNKNOWNUNKNOWN-—8939 Spring StreetPhoenixAZ85024nullMEDICARE-ADV-A
CLMCLM-4267192026-09-27T03:37:21ZBarb····HicksJun 28, 1960nullNULL(612) 456-2667BARBARA.HICKS83@AOL.COMUNKNOWN--N/AGRP-2308NAVIGATE-HMO
CLMCLM-4160232026-03-29T09:08:35ZBRNDA—NELSON1946-06-04UHC-04067-06——brenda.nelson@outlook.com1315 Market StreetGilbertaz—····SELECT-EPO
CLMCLM-4269652026-04-04T11:54:09Z·Keith··Collins21-06-1972UHC-22597-64-+1 676 563 1419··2439 Mesa DriveLOS ANGELESCalifornia··90053GRP-2678—
CLMCLM-4287112026-01-30T13:14:01ZPETER····BLACK1991-07-06··UHC-10895-50•••-••-9487(529) 792-6699peter.black6@gmail.com··9849 PALM DRIVE #580MiamiFL-GRP-8493null
CLMCLM-4173212026-01-25T15:37:57ZAlexis—West1996-10-23UHC-01606-34•••-••-0174—NULL—--—GRP-8193null
CLMCLM-4180812026-04-10T17:38:10ZCHARLES—ROSS1992-12-15UHC-90074-48NULL362-268-7021—8583 Elm StFresnoca93771··—select-epo
CLMCLM-4110972026-09-07T14:19:35Z ROGERT··ROBERTSON02/25/1977N/AUNKNOWN(798) 515-7830—7470 BASELINE ROADChandlerAZ85260GRP-0452—
CLMCLM-4264222026-10-02T17:08:57Z·Alan—Ryan06/15/1940UHC-68642-08-N/A—5901 GRAND AVE··San DiegoCA··NULL—NAVIGATE-HMO
CLMCLM-4041632026-02-16T15:54:32ZEmily—Rojas08/11/73UNKNOWN•••-••-3926nullNULL3655 Market StreetLas VegasNV89101GRP-9446—
CLMCLM-4136102026-07-13T17:23:31ZGLORIA—BURKE07-11-1981·UHC-56404-96null+1 393 343 9367N/A8287 Valley View DrTucsonAZ85728GRP-5910—
CLMCLM-4301462026-08-29T17:44:58ZFatima··—Anderson07/03/1996·null———————GRP-4101NULL
CLMCLM-4186412026-04-29T11:09:49Zjames—ford1987-08-05UHC-80014-49··19278219832N/A—nullN/A-—MEDICARE-ADV-A
CLMCLM-4002222026-04-01T15:50:36ZAlice—Le20050917UHC-71611-32UNKNOWN—UNKNOWN4656 Hillcrest RdGlendaleAZ85382GRP-3309·CHOICE-PLUS-PPO
CLMCLM-4206312026-05-22T19:59:07ZCHRISTIAN—LE1970-07-15uhc-11475-19null··——N/A····UNKNOWNUNKNOWNUNKNOWN—
CLMCLM-4244602026-04-28T00:48:06ZSARAH—OLIVER1992-12-26UHC-68141-22——NULL8057 Cedar LaneColumbusOH43217··GRP-6959N/A··
CLMCLM-4204282026-07-01T01:36:27ZThomas—Carter1984-12-06UHC-18931-33NULL6564273432-UNKNOWNUNKNOWNUNKNOWN-GRP-5519MEDICARE-ADV-A
CLMCLM-4061662026-05-05T01:37:23ZChristina—·Harrison1983-12-03·UHC-49614-16-7244681626··UNKNOWN1526 Union StFresnoCA93724GRP-4570MEDICARE-ADV-A
CLMCLM-4291912026-06-08T05:19:33Z KAREN—RUSSELL11/11/1999··UHC-70383-59N/Anull————UNKNOWNGRP-2926NAVIGATE-HMO
CLMCLM-4053132026-09-17T15:43:56ZGEORGE—SIMS1997-01-02UHC-90175-74-983-261-9092NULL461 Jefferson AvePlanoTexasNULLGRP-2667CHOICE-PLUS-PPO
CLM CLM-4156202026-09-03T17:00:32ZJesse··Singh·1988-02-14UHC-17713-76-924-263-5331NULLUNKNOWN—UNKNOWN—GRP-4631····
CLMCLM-4202622026-01-30T23:13:11ZMARHA—NICHOLS04/27/89UHC-63051-72NULL·4647608888UNKNOWN1787 Jefferson Avenue··Mesa··AZ—GRP-0185CORE-HMO
CLM CLM-4170952026-08-13T14:35:46Z·Ashley—Olson1984-01-07—•••-••-9155(268) 968-2837······1015 BAYSHORE DRSACRAMENTOCA95827GRP-2214NULL
CLMCLM-4265432026-04-16T14:41:36ZHarold—Myers1971-09-22UHC-42540-15—N/A—9113 Indian School RoadJacksonvilleFL32299GRP-7908MEDICARE-ADV-A
CLMCLM-4172252026-03-30T21:28:25ZSean—Nguyen2004-05-04UHC-10988-10—NULLN/A3327 Mesa DriveMiamiFL33166NULLCHOICE-PLUS-PPO
CLMCLM-4025472026-05-17T15:59:39Z Katherine—Martin1977-03-27UNKNOWN•••-••-1957N/AN/A-·UNKNOWNnullNULL—NULL
CLMCLM-4153902026-03-22T01:57:58ZRnald—Flores04/24/1996·UHC-43464-13•••-••-0724null—7090 CANYON RDSacramentoCA95850·GRP-9186CORE-HMO
CLMCLM-4031952026-09-22T15:20:28ZDennis··Hunt1993-03-07--2047001UNKNOWN9777 Mountain View DrCOLUMBUSOH43245UNKNOWN—
CLMCLM-4275332026-04-08T19:58:57ZChristian—MeyerApr 25, 2007UHC-81174-40—(483) 455-3818·NULL2940 Indian School RdDallasTX75216UNKNOWN·UNKNOWN
CLMCLM-4057472026-09-24T08:06:11ZVIRGINIA—GRANT8/3/1968UNKNOWN··——3062 Forest AvenueCOLUMBUSOH43296--
CLMCLM-4294052026-07-30T01:55:15ZEDWARD····EDWARDS··24-11-1964N/A•••-••-7884N/Anull1315 Apache BoulevardCharlotteNC28241--
CLMCLM-4123412026-09-22T14:00:29Zrussell··—carter16-10-1940UHC-58996-04null+1 700 599 1659··—1066 Main StFresnoCA93705N/AMEDICARE-ADV-B
CLMCLM-430880 2026-01-12T06:48:56ZSophia—Williamson0208-07-05UHC-77075-88•••-••-7772692-731-6891——nullNULLUNKNOWNN/ASELECT-EPO
CLMCLM-4301972026-05-04T14:18:04ZRoss, Jennifer——19561005UHC-16794-05•••-••-3267705.325.7982jennifer.ross69@yahoo.comnullN/A—UNKNOWNnull—
CLMCLM-4151762026-02-19T03:48:52Z ANDREW—SNYDER1994-12-28-UNKNOWN——-null———SELECT-EPO
CLMCLM-4232752026-10-08T22:34:28ZDenise—Young1969-11-18UHC-62842-53—5053136925—2167 Desert Sky BlvdTempeAZ·NULLGRP-4791N/A
32,829 rows, page 113 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.475Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty