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-4076972026-08-11T02:42:12ZTERRYMWHITE1936-10-19UHC-08193-23NULL··475-233-2073··N/A—nullN/ANULLGRP-9740-
CLMCLM-4034792026-04-13T15:03:51ZSAM··—EVANS2003-06-19—·-—-··4995 Maple AvenuePhoenixAZ··85021N/A-
CLMCLM-4276902026-09-17T11:55:05ZMARCUS—REYNOLDS1992-60-16UHC-16240-68null·(602) 660-6361——NULL—UNKNOWN—····
CLMCLM-4012752026-05-07T15:21:54ZMarkRMcDonald2/6/1989··UNKNOWN·NULL854-830-0320null1238 PARK PLSeattleWashington98192GRP-0848MEDICARE-ADV-A
CLMCLM-4179082026-06-08T09:17:46ZNicholas—Washington08/08/68UHC1839187UNKNOWN+1 479 687 0616UNKNOWN6609 Highland AvePhoenixAZ85085GRP-1485-
CLMCLM-4239372026-09-18T19:20:52ZFoster, Gerald··——1993-02-26NULL—NULL—·8689 Jefferson AvenueTUCSON··az85762GRP-1453··NULL
CLMCLM-4057962026-01-20T16:36:31ZJordan—Duncan1993-06-11nullNULL(786) 319-0096—4713 Indian School RdHoustonTX-GRP-9330OPTIONS-PPO
CLMCLM-4232032026-07-11T15:51:13ZSam—Adams07/20/60UHC-62298-66··N/AUNKNOWN—2770 CANYON ROADCOLUMBUSOH43226GRP-8950SELECT-EPO
CLM CLM-4278512026-03-01T20:42:08ZDyylan·YCole01-07-2004UHC-93588-47—258-293-0050dylan.cole50@outlook.com6513 Cedar Lane··PhoenixAZ85086N/AMEDICARE-ADV-A
CLMCLM-4282572026-02-05T12:27:35ZJoshua··Roberts1979-05-25UHC-70115-04•••-••-5206null—-··—null-····UNKNOWN
CLMCLM-4242772026-09-19T07:01:42ZDeborah··—Vargas19440626——NULLN/A4953 APACHE BLVDMINNEAPOLISMN55473GRP-4934—
CLMCLM-4120972026-05-31T16:38:10Z Abigail—Scott1979-12-18UHC-38723-32NULLNULLnull943 Harbor BlvdOrlando··FL32833GRP-5016null
CLMCLM-4188522026-01-22T13:46:07ZDOUGLAS—MCDONALD1959-11-11·UHC-18708-72—N/ANULL6907 VALLEY VIEW DRIVEAustin·TX78704GRP-9482—
CLMCLM-4213612026-04-30T14:15:49ZWALTER—·COOK1962-06-25UHC-07206-18•••-••-3814835-367-6991··null4996 Meadow Ln·TampaFL33611-5369NULL—
CLMCLM-4084882026-09-10T16:48:05ZDominguez, Austin——1943-02-20UHC-60615-04NULL3860311NULL6619 MAIN STGlendaleArizona85320GRP-2814—
CLMCLM-4081602026-08-08T03:15:54ZVincent—Hayes1945-11-04uhc-40423-93•••-••-1578(409) 989-5608—1652 Washington StPhoenixAZ85099UNKNOWNN/A
CLMCLM-4175852026-08-14T00:13:04ZFerguson, Danielle——Oct 12, 1985UHC-82532-02-(317) 669-2769nullnull——NULLGRP-2304-
CLMCLM-4304232026-07-19T17:49:13ZJACQUELINEIMENDOZA19900214UHC-51173-49—6345392198null6121 Cedar LaneLas VegasNV89110·GRP-1741null
CLMCLM-4279192026-09-18T03:50:01Z·Andrea—·OlsonApr 16, 1990UHC-41097-65—nullnull4035 Forest AveGlendaleAZ—UNKNOWNnull
CLMCLM-4175582026-08-31T09:06:14Zdenise—peterson2006-10-12N/AN/A399-872-2277-—NULL·NULL—GRP-6038—
CLMCLM-4248502026-07-24T21:41:42ZJUDITH—MARTINEZ16-09-1993UHC-48517-88—·(660) 829-4651—9374 HILLCREST RDPhoenixAZ85043NULLNULL
CLMCLM-4317312026-09-24T04:37:24ZElizabeth··Pierce19700224·UNKNOWNUNKNOWN874-591-7377···-1754 UNION STREETAtlantaGA30337GRP-8289N/A
CLMCLM-4040572026-04-14T16:52:15ZWATSON—ROGER1948-04-27nullNULLN/Aroger.watson@yahoo.com··6246 Forest AveMinneapolisMN55429GRP-8180MEDICARE-ADV-A··
CLMCLM-4237572026-05-25T19:52:00ZBRADLEYNHUGHES·1996-05-25UHC-90029-18UNKNOWN—UNKNOWN6130 Lincoln WaySan AntonioTX78234—medicare-adv-a
CLMCLM-4282212026-03-25T22:24:38ZKelly··Jensen1954-03-12UHC-89135-52•••-••-7086·NULL—3420 Baseline RdNashville··TN37213GRP-9906—
CLMCLM-4090492026-05-07T04:48:54ZTHOMAS—WELCH2/15/2007—•••-••-7713nullnull··NULLN/ANULLGRP-3343-
CLM CLM-4047732026-10-10T05:57:38ZMike···Nelson1938-06-07····•••-••-5257——1008 Pine Drive Apt 16SacramentoCA95849—UNKNOWN
CLMCLM-4152472026-05-18T12:09:00ZJeremy—VegaAug 14, 1977—NULL12019487213UNKNOWN-N/AUNKNOWNN/A··UNKNOWNOPTIONS-PPO··
CLMCLM-4212812026-02-20T17:41:41ZHall, Terry——1988-07-22UHC-83199-44•••-••-2830(761) 479-6806--—null—GRP-2974NAVIGATE-HMO
CLMCLM-4226262026-03-03T00:46:25ZIsabella—Hanson19690215UHC-86221-59•••-••-5580—isabella.hanson48@gmail.com6627 Apache BoulevardEDEN PRAIRIEMN55326UNKNOWN—
CLMCLM-4022932026-02-22T06:23:45ZTIMOTHY—BRYANT1965-02-15uhc-19534-28null··-—4738 Park Pl·PhoenixAZ85034—UNKNOWN
CLMCLM-4069272026-06-15T18:29:02Z·Matthew—Castro19990228null•••-••-6767938.811.4111····3320 Willow CourtHoustonTX77062—MEDICARE-ADV-B
CLMCLM-4215492026-09-05T22:08:17Z·JESSE—·CASITLLO1947-02-15UHC-64582-82•••-••-9415950.929.3843JESSE.CASTILLO59@OUTLOOK.COM-nullNULL—GRP-4491-
CLMCLM-4039892026-05-10T09:14:27Z———1940-06-06null•••-••-8370·····N/AnullN/A—-GRP-6323SELECT-EPO
CLMCLM-4095892026-05-12T08:12:20ZAdamZ.Turnr1959-06-10—•••-••-2129819-960-3611adam.turner5@gmail.com6333 VALLEY VIEW DRFresnoCA93726-9349GRP-3334MEDICARE-ADV-A
CLMCLM-4270632026-02-22T03:22:39ZAngela—EllisMar 3, 1999N/A··—N/A———UNKNOWN—GRP-1039CHOICE-PLUS-PPO
CLMCLM-419766 2026-07-05T09:21:37Zchris··washington1996-03-01UHC-95770-57•••-••-3651890-886-8216—6603 Cedar Lane··CharlotteNC28218GRP-5847NULL··
CLMCLM-4295622026-07-07T09:38:26ZStephanie—Yang2002-09-03—•••-••-4847N/AUNKNOWN6020 Ocean Avenue··CharlotteNorth Carolina28250-6137GRP-4879N/A
CLMCLM-4181242026-07-22T06:15:19Zdonald—sullivan··1972-20-12null··UNKNOWN——9412 Main StreetFresnoCA93709···GRP-6802—
CLMCLM-4003562026-03-06T03:44:35Z·HANNAH—DOMINGUEZ1988-11-24UHC-53763-37NULL—HANNAH.DOMINGUEZ66@GMAIL.COM-—---MEDICARE-ADV-B
CLMCLM-4267112026-03-28T08:53:59Z·Morrison, Charles——1953-01-11null———5824 Lincoln WayPhoenixAZ85017GRP-8968·NULL
CLMCLM-4059072026-04-02T01:45:51Z ThomasU.Armstrong··1993-12-04UHC-87670-07--—1436 Elm StAustinTX78709N/AOPTIONS-PPO
CLMCLM-4258562026-10-07T20:52:36ZPriya—Estrada1960-06-09—•••-••-25466956069331UNKNOWN-nullNULLN/AGRP-7467··NAVIGATE-HMO
CLMCLM-414999 2026-02-03T05:08:20ZRoy—Reid1975-11-05UHC-74723-28—nullroy.reid14@gmail.com7434 Cedar LaneGlendaleAZ85398GRP-9407CHOICE-PLUS-PPO··
CLMCLM-4281432026-05-21T11:13:15ZMEI—TRANNov 1, 1998UHC-37090-48—4997853600NULL·9864 Hillcrest RoadColumbusOH43263—MEDICARE-ADV-B
CLMCLM-4133242026-07-12T13:01:46ZBowman, Gloria——1993-07-05··UHC-30916-26N/A—nullN/A—·nullUNKNOWNUNKNOWNCHOICE-PLUS-PPO
CLMCLM-4077102026-02-20T22:23:12ZNoahMGuzman1963-12-02UHC-32384-07··•••-••-6110354-354-8161noah.guzman5@aol.com4878 Oak StLOS ANGELESCA90071GRP-4083·CORE-HMO
CLMCLM-401400 2026-01-06T10:59:09ZGABRIELP··ROBERTSON1946-05-09UHC-65311-64—··—N/A--············
CLMCLM-4283282026-07-25T07:51:39ZJERRYE·SNYDER20040714-—+1 895 212 2926—2995 Ridge Road··FresnoCA93791-7111GRP-8100····
CLMCLM-4242712026-04-12T09:42:35ZJACK—BARNES07/25/40UHC-58851-08•••-••-2377null··5734 Washington StreetAtlantaGA·30356GRP-9378··—
32,829 rows, page 62 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:36.717Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty