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-4215332026-09-15T11:49:11ZGregoryMWillis13-09-1952——921-682-0718UNKNOWN6901 Pine DrAtlantaGA30391GRP-2079OPTIONS-PPO
CLMCLM-4092912026-01-13T06:40:20ZBenjamin—Moreno2000-08-10NULL-—null··1642 Maple AveAustinTexas78737··NAVIGATE-HMO
CLMCLM-4138912026-03-10T20:27:35ZJulia—Cunningham1954-05-28—N/A——3668 Spring StAustinTX78725GRP-7842SELECT-EPO
CLMCLM-4177342026-01-20T10:47:14ZWayne—GarzaNov 24, 1990——4467283919N/A7840 Forest AvenueJacksonvilleFL32295··GRP-1066MEDICARE-ADV-A
CLMCLM-4197542026-01-31T14:12:45ZTerry—Rojas··10-04-1983UHC-70197-41··6077968128-8350 WILLOW CTTucsonAZ85706NULLN/A
CLMCLM-4166722026-08-23T00:55:07ZBENJAMIN—·YANG1944-10-04·UHC-43975-07•••-••-1990(705) 909-2295—5389 Desert Sky BlvdMesaAZ85265-5995-NULL··
CLMCLM-4164232026-03-25T13:03:50Zmelissa—andersonJul 2, 1981UHC-00123-95null327-603-5760—NULLUNKNOWN—-GRP-2990MEDICARE-ADV-B
CLM CLM-4173842026-06-26T07:40:28Z Christian—NguyenDec 13, 1978UHC-03910-55—UNKNOWN—5012 Ocean AvenueDALLAS··TXUNKNOWNGRP-3885··CHOICE-PLUS-PPO
CLMCLM-408241 2026-04-20T09:08:03ZDORISO.DUNN1990-04-22UHC-40407-79null··+1 294 471 8445·doris.dunn@outlook.com·6561 Valley View DriveSCOTTSDALEAZ85289UNKNOWNnull
CLMCLM-4245302026-06-05T19:37:17ZWashington, Cynthia——1945-04-24UHC-73781-55•••-••-7893(358) 352-3389—6260 Harbor BlvdTucsonAZ85722··GRP-0497CORE-HMO
CLMCLM-4175522026-09-11T18:23:13ZAlbert—Cruz19-04-1992—•••-••-5581·6270179—8046 Camelback RoadSeattleWA98137GRP-8811··NAVIGATE-HMO
CLMCLM-4285502026-02-16T11:58:37ZSHIRLEYJORTEGA1987-10-14UHC-70852-06—8597371183—1843 Ocean Avenue·Los AngelesCA90091GRP-3357MEDICARE-ADV-A
CLMCLM-4285112026-01-07T14:22:55ZHannah—Nelson03/10/1987UNKNOWN-——7495 Mesa Drive··TampaFL··33646·GRP-5702CHOICE-PLUS-PPO
CLMCLM-4205252026-05-08T18:27:24ZRamos, Denise——1960-12-10UHC-80996-85··•••-••-3774525-793-7763—899 FOREST AVE #582DenverCO80256—NAVIGATE-HMO
CLMCLM-4281802026-01-10T10:42:44Z·JoshhuaSHicks1958-02-27UHC-84187-07•••-••-8849—null4761 Lincoln WayFresnoCA93799GRP-8072OPTIONS-PPO
CLMCLM-4235812026-07-26T11:48:34Zjoyce—george1965-10-12UHC-38796-05null-N/A1879 Hillcrest RdMesaAZ85272-—
CLMCLM-4066952026-04-01T13:23:42ZDeborah—Reyes1972-12-05NULL•••-••-4260——·139 Main StScottsdaleAZ85278GRP-7990NULL
CLMCLM-4002072026-01-24T09:07:19ZRandy—·Luna1946-09-28UHC-74452-32NULL974.804.7006UNKNOWN··——N/AN/AGRP-8699CHOICE-PLUS-PPO
CLMCLM-4031502026-09-16T07:07:01ZDiegoK.Jones··1981-07-13N/A•••-••-7653·NULL—3014 Valley View DrFresnoCA93746GRP-1798MEDICARE-ADV-A
CLMCLM-4292052026-05-21T18:04:47ZMARCUS—HUDSON··02-06-1977UHC-54432-48··N/A-4570 Oak StMinneapolisMN55467—MEDICARE-ADV-A
CLM CLM-4149172026-06-08T14:12:25ZCHRISTINA—WILSON1989-05-09··—UNKNOWN(924) 818-5789—7942 Bayshore DrOrlandoFL32897GRP-9183CORE-HMO
CLMCLM-4211622026-07-27T22:24:43Zteresa—harrison1951-12-01··—•••-••-02116826369415null8615 PALM DRIVEDallasTexas75243—NULL
CLMCLM-4279842026-08-04T10:44:48Zrachel—alexander20080324UHC-56685-50•••-••-1631700-275-3367NULLN/A—UNKNOWNUNKNOWN-·-
CLMCLM-4224752026-09-04T04:35:09ZAlexis—·Ross2001-04-24··UHC-76669-06•••-••-6669—UNKNOWN2335 Baseline RdAtlantaGA30386—OPTIONS-PPO··
CLMCLM-4222142026-05-04T16:15:05ZDIANA—SPENCER8/19/1942—•••-••-4291(690) 379-2927-1835 Oak StreetDenverCO80219GRP-5366—
CLMCLM-4141352026-10-16T15:26:57ZDANIELIMARSHALLNov 10, 1964UHC-78984-90—NULLdaniel.marshall@outlook.com7389 Hillcrest RdScottsdaleArizona·85219GRP-1280SELECT-EPO
CLMCLM-4113642026-02-15T11:46:49ZBradleyR.Meyer1978-02-03UHC-39806-76—18057839731bradley.meyer@yahoo.com2160 Central AvenueJacksonvilleFL32236·GRP-4851OPTIONS-PPO
CLMCLM-4072002026-03-27T22:29:43ZWEI—·GONZALES1950-07-11UHC-13014-37-772.209.7302N/A2897 Grand Avenue·LAS VEGASNV89180GRP-6096NULL
CLMCLM-4160672026-03-01T03:27:31ZRACHEL—COLEMAN·28-12-1982UHC-96750-71—6609535067null93 Ocean AveJacksonvilleFL32262GRP-1653N/A
CLMCLM-4087202026-02-20T00:19:44ZJoshua—Reid09/19/1987UHC-38851-18•••-••-33399065402514UNKNOWN1962 Camelback RdLos AngelesCA90018··GRP-5812-
CLMCLM-4209442026-01-30T20:19:56ZRussell—Bell··2006-04-02N/A-——2688 JEFFERSON AVENUEAtlantaGA30380GRP-5560SELECT-EPO
CLM CLM-4269392026-06-30T14:56:33ZRandy—Munoz09/18/2003UHC-21023-01null+1 343 689 3410UNKNOWN7660 CENTRAL AVESACRAMENTOCA95872GRP-9295CHOICE-PLUS-PPO
CLMCLM-4067222026-07-02T15:55:13ZKathleen—Bailay1983-04-15UHC-81568-33•••-••-1185957.504.9058—6841 PARK PLACEEden Prairiemn55334null—
CLMCLM-4249652026-04-22T09:26:17Z alice—butler·1/25/1948UHC-00725-73—nullnull7764 Main StreetAustinTX78749GRP-6616NAVIGATE-HMO
CLMCLM-4004142026-09-29T05:05:30ZJOHN—GARDNER19471106UHC-45824-49•••-••-1061——6299 Desert Sky BlvdAUSTINTX78722-5816——
CLMCLM-4296472026-02-03T05:07:06ZKennneth—Cox1953-06-17··--321-638-7904kenneth.cox@outlook.com·3484 MAPLE AVEGlendaleArizona85331GRP-2620NULL
CLMCLM-4168532026-01-11T17:59:05ZJEANZCOLLINS3/7/1971—•••-••-7695—jean.collins@hotmail.com4646 Main StTucsonAZ85755GRP-3550—
CLMCLM-4182922026-09-16T09:45:32ZJONATHAN—·HUGHES1980-01-09UHC-60893-02•••-••-1877nulljonathan.hughes@outlook.com1879 Union StreetFresnoCA93779·GRP-0450UNKNOWN
CLMCLM-4166062026-08-30T13:29:39ZAbigail—Palmer09/23/2007—UNKNOWN··UNKNOWN———nullN/AGRP-4000MEDICARE-ADV-A
CLMCLM-4221182026-03-12T21:37:48ZEric—Hudson20081203uhc-87974-59NULLnullUNKNOWN8745 Church StMinneapolisMN55422GRP-6377CORE-HMO
CLMCLM-4066522026-08-06T20:39:41ZGREGORY—DAVIS07-06-1991UHC-72859-52•••-••-9708-NULL1305 Desert Sky Boulevard··MiamiFL33108-OPTIONS-PPO
CLMCLM-4139232026-07-27T08:38:24ZANTHONY—SIVLA1950-03-01—•••-••-8074NULLNULL7986 Bayshore DrJacksonvilleFL32287GRP-2776medicare-adv-a
CLMCLM-4152182026-07-04T02:18:18Zrichard·······johnson2008-05-22NULL·UNKNOWN5806651532UNKNOWN8974 Palm DriveColumbus··OH43244GRP-5474NAVIGATE-HMO
CLMCLM-4058222026-03-21T17:46:46ZKENNETH··QFREEMAN1957-09-19UHC-86967-68-16284005044—8864 Palm DrivePlanoTX75032GRP-0318NULL
CLMCLM-4210902026-01-28T22:46:32ZDAVD—BUTLER··12/28/2004———NULL2061 Lake View RoadMesaAZ85277GRP-3894·CHOICE-PLUS-PPO
CLMCLM-4170882026-07-06T06:14:25ZVincent····Sandoval09/17/1994UHC-44129-46•••-••-88486226781184UNKNOWN1390 Desert Sky BoulevardColumbusOH43229—UNKNOWN
CLMCLM-4182102026-08-07T08:57:49ZDiana····LopezDec 20, 1990uhc-00021-65———7282 SUNSET BLVDTEMPEAZ85203null—
CLMCLM-4251062026-04-15T04:04:48ZDixon, Martha——2007-02-09UHC-86777-89—-··NULL8595 Desert Sky BoulevardHoustonTX77074GRP-5735NAVIGATE-HMO
CLMCLM-4249022026-01-11T05:15:55ZAlan—OBiren1691-03-02UHC-95481-89•••-••-3828541-345-0956NULL2792 Bayshore Drive·Atlantaga30391GRP-5923—
CLMCLM-411404 2026-02-23T09:04:56ZEmma—Harrison1939-12-13null—389-848-6336UNKNOWN1925 Mountain View Drive··MiamiFlorida33123GRP-7383SELECT-EPO
32,829 rows, page 163 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.357Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty