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-4189822026-01-26T11:47:24Zgary—jordan1977-03-09—····(216) 331-1280·NULLN/A—··N/ANULLCHOICE-PLUS-PPO
CLMCLM-4293372026-03-18T05:48:33Zlaura—berry18-02-1961UHC-60478-77•••-••-93937924332083··-5033 MAIN STMiamiFL33184N/A··CORE-HMO
CLMCLM-4072272026-07-27T10:51:09ZVincent··—Lee01/01/79UHC-40504-25—689-774-5966—4326 Sunset BoulevardHoustonTexas77068··N/ACORE-HMO
CLMCLM-4092682026-10-15T02:05:53ZHiroshi—Miller1978-09-12uhc-76081-36nullNULLUNKNOWN8858 SAGE CTGilbertAZ85263NULLnull
CLMCLM-4315032026-01-14T09:00:19ZMarthaJHarvey··01/08/1988NULL•••-••-3415N/A—6664 Union StDenverCO—nullnull
CLMCLM-4090782026-01-11T01:50:14ZTren, RobertN—1978-03-12UHC-15067-68—N/A—6155 Spring StreetPLANOTX·-GRP-1353CORE-HMO
CLMCLM-4153642026-08-14T14:47:55Z Ethan—Little03-02-1983UHC3463267•••-••-8311+1 983 411 2655N/A2244 PINE DRIVETampaFL33633GRP-9479UNKNOWN
CLMCLM-4076382026-01-20T16:37:37ZMason, Ana——2002-01-10UNKNOWN··-3122246069UNKNOWN—UNKNOWN—UNKNOWNN/ANAVIGATE-HMO
CLMCLM-4193222026-05-17T16:30:06ZThomas, Megan——14-10-1998UHC-49695-95•••-••-6822—UNKNOWN2120 HIGHLAND AVEDALLASTX75221··NULLCORE-HMO
CLMCLM-4016132026-05-27T05:44:50ZANA—ROBERTS1973-01-18UHC-57213-03N/A757.267.8141—9756 Lincoln WayMesaArizona85221GRP-9417CHOICE-PLUS-PPO
CLMCLM-432237 2026-04-13T12:37:44ZCARL—WEST·1992-01-06-UNKNOWNnull—3663 GRAND AVE Apt 38GlendaleAZ85353GRP-1270NULL
CLMCLM-4318012026-09-11T00:12:37ZAnn—Alvarado1984-07-11—nullN/ANULL4414 HARBOR BOULEVARDSan DiegoCA92123GRP-8856··N/A
CLMCLM-4261462026-07-25T17:07:27ZDianaRMills1989-02-06UHC-78735-87UNKNOWNnullnull5029 Union StreetLos AngelesCA90053NULLMEDICARE-ADV-B
CLMCLM-4103882026-04-21T01:46:23Z JEREMY··—COOK1948-08-19N/A•••-••-6215NULL-null····-NULLGRP-7088null
CLMCLM-4240612026-03-28T14:55:04ZJones, Luis——1984-04-14UNKNOWN··•••-••-8577331.547.3919N/A2214 Washington StATLANTAGA··30344—UNKNOWN
CLMCLM-4189532026-09-06T01:50:06ZOAR—HUNT1938-05-20UHC-97434-51··•••-••-3893454.362.9865—9314 BAYSHORE DRIVELos AngelesCAN/A—NAVIGATE-HMO··
CLMCLM-4142052026-07-26T12:21:36Z·Heather—Simpson—UHC-44129-07•••-••-817217052744371null4087 APACHE BOULEVARDPlanoTX75005GRP-3464CORE-HMO··
CLMCLM-4229372026-05-09T05:25:28ZCooper, Kathryn··U—21-09-1979UHC-84332-55——KATHRYN.COOPER18@OUTLOOK.COM2370 RIDGE ROADMesaAZ85215GRP-2309MEDICARE-ADV-B··
CLMCLM-413004 2026-02-11T09:33:20ZMateoEBarnes··1954-02-13—null759-849-8133··null—·UNKNOWN-NULLGRP-5709UNKNOWN
CLMCLM-4316612026-06-09T04:38:19Z·JAMES—PORTER1948-06-18UHC-83196-09-(793) 383-5208JAMES.PORTER@OUTLOOK.COM8111 Ocean AveAtlantaGA30316GRP-4066MEDICARE-ADV-A
CLMCLM-4279492026-09-27T12:38:47ZLauren—Howard2005-04-18-null(782) 435-3526····9045 HARBOR BLVDMinneapolisMN55437GRP-1520··UNKNOWN
CLMCLM-4296252026-01-07T12:27:04ZSusan—Williams2000-06-23-•••-••-92123679071705—4391 Lincoln WayDALLASTX75284GRP-2127SELECT-EPO
CLMCLM-4218762026-07-31T21:40:07ZmariaHsimpson·12/22/2008·UHC-29411-66•••-••-8653nullNULL2468 Union StreetHoustonTexas77056—MEDICARE-ADV-B
CLMCLM-4097482026-05-17T18:24:12Z Jeremy—Kim1942-09-06UHC-94680-42UNKNOWN··NULL—6877 Apache BoulevardFresnoCA93792GRP-0575OPTIONS-PPO··
CLMCLM-4275342026-06-17T07:29:03ZChristian—Meyer2007-04-25··-N/A—christian.meyer63@yahoo.com2940 INDIAN SCHOOL RDDALLASTX··75216UNKNOWNNULL
CLMCLM-4102672026-08-04T04:14:02ZMichael B—Evans2006-09-04N/A··•••-••-8105+1 914 583 7414N/A8354 Maple AvenueORLANDO·FL32856GRP-6224-
CLMCLM-4046372026-10-18T16:12:32ZSophia—Howell28-04-1997UHC-51733-01NULL-··N/A2377 APACHE BOULEVARDSAN DIEGOCA92144GRP-3482—
CLMCLM-4059112026-03-14T12:54:40ZTeresa—Hughes08/25/1996UHC-82381-89•••-••-4665+1 724 829 7926NULL7401 Oak StreetSacramentoCA95897GRP-0132MEDICARE-ADV-B
CLMCLM-4065462026-03-21T01:50:18ZBrianYNunez19660109NULLnull626-415-9831UNKNOWN—UNKNOWN··UNKNOWN—GRP-3735MEDICARE-ADV-A
CLMCLM-4245322026-04-14T18:54:15ZHanson, Bryan——2007-11-19nullNULLNULL····6628 Church StreetEden PrairieMN55389GRP-0470OPTIONS-PPO
CLMCLM-4062872026-02-18T01:10:44ZIsabella—Carrr06/13/60UHC3227906•••-••-3907N/ANULL1829 MOUNTAIN VIEW DR Apt 17PhoenixAZ85008N/A—
CLMCLM-4096852026-02-08T04:59:43Z·Holmes, Terry····—Sep 4, 1973UHC-16727-88NULL(624) 592-1610N/A-—N/AN/AnullCHOICE-PLUS-PPO
CLMCLM-4235992026-09-02T07:36:02Z·AmyI.Myers09/21/50··UHC-78281-86•••-••-9327+1 363 696 7559amy.myers@hotmail.com5533 Valley View DrCharlotteNC28223GRP-4920N/A
CLMCLM-4151602026-08-22T08:33:48ZEDDIE—GARCIA1942-12-09UHC8225521UNKNOWN—null5691 Lincoln WayAustin·Texas78786GRP-2285—
CLMCLM-4098052026-05-16T16:24:04ZDENNISJGREENE1940-09-07NULL-··UNKNOWN8074 GRAND AVETempeAZ·85253GRP-6592—
CLMCLM-4150862026-04-10T21:33:04ZKellyAGeorge1978-02-12·UHC-37526-19•••-••-7126855-289-9701null··null··N/ANULL··—GRP-6465—
CLMCLM-4130702026-05-27T17:08:38ZPatrick—Perez5/24/1975UHC-74189-68•••-••-0456UNKNOWNNULL6266 CEDAR LNGilbertAZ85213--
CLMCLM-4174232026-03-08T17:26:03ZJimmy—Crawford1974-01-28UHC-30066-13•••-••-3233(922) 556-8912JAMES.CRAWFORD@OUTLOOK.COM3463 Washington StreetTAMPA·Florida33670····MEDICARE-ADV-A
CLMCLM-4298402026-08-04T01:54:17ZRamos, Lauren——Jul 1, 1955————5403 Maple AveMiamiFL33133GRP-2223N/A
CLMCLM-4062282026-03-20T22:26:59Znicholas—armstrong11-12-1947UHC-83109-91•••-••-9516(258) 335-5901NULL9735 Canyon RoadColumbusOH43289GRP-6160CORE-HMO··
CLMCLM-4030882026-07-25T09:10:00ZFrank—·Ramireez1974-09-09—UNKNOWN·-—N/A··N/A—-GRP-0296MEDICARE-ADV-A··
CLMCLM-4241032026-01-16T04:17:51ZEdward—George19830617-•••-••-0123+1 925 654 9706——UNKNOWN·-null—··
CLMCLM-4320002026-07-08T13:35:32Zralph—mejia1955-01-02UHC-24782-47N/A·3845363782—9551 Willow CourtDallasTexas75228GRP-5217MEDICARE-ADV-A··
CLMCLM-4271772026-02-08T06:08:54ZSAMANTHA—SPENCER1998-11-24UHC-00058-48•••-••-59699724442N/A6140 GRAND AVENUEEden PrairieMN55307GRP-1099null
CLMCLM-4216872026-01-05T21:04:36ZJONATHAN—MURPHY1988-04-25UHC-59517-51•••-••-7804NULL····N/A-—UNKNOWNGRP-6692-··
CLMCLM-4158472026-08-23T22:14:41ZFATIMAC.RUIZ1998-12-07UHC-33575-16N/A906.357.6772—6908 Forest AvenueTampaFL33636-7120N/AMEDICARE-ADV-B
CLMCLM-4068702026-02-12T17:19:26ZVIRGINIAN.CARR1959-09-19UHC-61614-40•••-••-4061325-445-1452VIRGINIA.CARR39@GMAIL.COM9085 Church StreetDALLASTX··75283GRP-3616—
CLMCLM-4043562026-07-25T09:18:00ZRoy—OlsonAug 6, 1967UHC-36243-10•••-••-1033(518) 548-3978N/A6622 BAYSHORE DRIVEChandler··AZ·85200GRP-8773-
CLMCLM-4138832026-07-06T04:23:47ZNICHOLASWDIXON1948-06-27UHC-09024-50null(933) 930-3634·nicholas.dixon@proton.me8495 Canyon RoadFresnoCalifornia93705-NAVIGATE-HMO
CLMCLM-4158352026-04-01T17:46:44ZKENNETH—THOMPSON2/21/1952UNKNOWN———2624 Central AveSan AntonioTX78270-3322GRP-2392—
32,829 rows, page 28 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.799Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty