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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
CLMCLM-4017582026-09-13T22:30:59ZTIMTHILL11/08/2009UHC-07622-22•••-••-8758—UNKNOWN7501 Grand AveMinneapolisMN··55491-OPTIONS-PPO
CLMCLM-4071232026-01-29T16:38:29ZGERAD··KENNEDY·1977-03-10N/A-385-806-0050null—NULLnull—GRP-8665—
CLM CLM-4179952026-09-24T08:48:34ZAdam—Lewis5/17/1977UHC-06334-32•••-••-7772null—5302 Indian School Road·AustinTX78729GRP-1581MEDICARE-ADV-B
ENRENR-1052362026-02-09T07:33:04ZSANDAPJACKSSON18-01-1970UHC-04416-25•••-••-9971+1 506 556 1529null9555 Meadow LaneEden PrairieMN55397GRP-0755MEDICARE-ADV-B
ENRENR-1275442026-03-19T19:49:02Z Danielle—Ellis1941-03-12UHC-67285-47•••-••-4057457-518-2376DANIELLE.ELLIS@HOTMAIL.COM7010 Grand AvenueDenverCO80233GRP-9760MEDICARE-ADV-A
CLMCLM-4048682026-09-04T09:33:22Z·Jesse—Berry5/21/1963UHC-34766-81•••-••-2243796-420-0802NULL··823 Harbor BoulevardEden PrairieMN55337GRP-3869CHOICE-PLUS-PPO
ENRENR-1071122026-01-19T08:40:48ZLAWRENCESMARTIN··1943-05-06UHC-43693-23-—lawrence.martin28@yahoo.com204 UNION STREETMiamiFL33191GRP-0509SELECT-EPO
CLMCLM-4102172026-07-05T09:26:48Z·DAVID—YANG2008-01-27NULL····UNKNOWNNULL7936 Park PlaceAtlantaGA30313—MEDICARE-ADV-B
CLMCLM-4223192026-08-23T10:32:10ZRYANDREED1595-01-18UHC-08268-31•••-••-7823··-··7022 Elm StCharlotteNC·28289N/AMEDICARE-ADV-B
PRVPRV-260292026-03-20T17:04:49ZTheresa—Green06/17/1989NULL•••-••-1093N/A—3471 Hillcrest RoadCHANDLERAZ85238UNKNOWNMEDICARE-ADV-B
ENRENR-1135562026-09-21T08:57:41ZNICOLEHSPENCER2008-04-24UHC-17549-23•••-••-0166+1 637 608 7780null·8006 Washington StPhoenixAZ··85062GRP-0689CORE-HMO
TPATPA-542862026-08-16T07:22:25ZJoeQHernandez1984-04-12—•••-••-2354+1 744 837 0918—795 MAPLE AVENUETempeAZ··—MEDICARE-ADV-B
ENRENR-1142252026-01-27T01:15:26Zphilip—banks1955-04-03UHC-92600-21•••-••-88095097634744PHILIP.BANKS@GMAIL.COM9677 Jefferson Avenue #745AustinTX78705GRP-2625MEDICARE-ADV-B
CLMCLM-4301782026-05-20T16:39:33ZETHANE—01-03-1961UHC-07381-68—·758-381-1982null8361 INDIAN SCHOOL ROADNashvilleTN37248····—
CLMCLM-4083232026-09-30T17:26:37ZLARRY····JONES6/4/1950UHC-94064-39UNKNOWN-—6613 Jefferson AvenuePlanoTX75089GRP-9933MEDICARE-ADV-B
ENRENR-1026662026-06-14T08:07:45ZWayne—JimenezDec 3, 1962UHC-31574-79•••-••-4770··wayne.jimenez70@aol.com6937 Grand Ave #107Las VegasNV89161-0280GRP-7427MEDICARE-ADV-A
CLMCLM-4163072026-07-24T05:42:31ZVirginiaQ··Hunter1968-02-24UNKNOWN•••-••-63377402839156-3867 BroadwayTAMPAFL33638-UNKNOWN
ENR ENR-1233902026-03-12T08:20:48Zhenry—hudson1962-05-17UHC-35103-42•••-••-5636(399) 531-9723henry.hudson94@yahoo.com3276 Camelback RoadGlendaleAZ85374·GRP-2840CHOICE-PLUS-PPO
ENRENR-1182032026-10-09T21:55:23ZWILLIAMW.THOMAS1963-02-12UHC-69152-82•••-••-30663124310william.thomas@proton.me··6444 Ridge Rd·ScottsdaleArizona85280GRP-3113MEDICARE-ADV-A
CLMCLM-4200692026-03-31T02:18:21ZEMMAA·RAMOS1960-08-12UNKNOWNUNKNOWN+1 928 876 2075emma.ramos@icloud.com6476 SUNSET BOULEVARDCharlotteNC··28260GRP-1997-
CLMCLM-4209692026-01-09T14:15:34Z·MELISSA—MARSHALL1998-06-13UHC7396039———4529 GRAND AVE··MinneapolisMN55492-7983GRP-0971····
ENRENR-1058072026-04-04T05:05:10ZDENNISTGRAYJun 20, 1969UHC-23100-81··NULL627-315-2189dennis.gray@icloud.com4859 Maple AvenueFresnoCA93720GRP-6773OPTIONS-PPO
ENRENR-1241862026-07-13T21:41:19ZWeaver, Janice——1973-10-17··UHC-62096-42•••-••-5522·UNKNOWNjanice.weaver61@outlook.com1279 Oak StreetDENVERCO80225·GRP-5770SELECT-EPO
PRVPRV-246602026-06-21T11:01:07ZTeresa—Vazquez2003-03-18null—(292) 466-1981TERESA.VAZQUEZ3@HOTMAIL.COM6244 Union StreetPlanoTX75087null··—
ENRENR-1227762026-03-08T17:52:35Zrobert—jacobs14-03-1957UHC-25481-39—15642961872··ROBERT.JACOBS32@ICLOUD.COM··6001 CANYON RD··Jacksonvillefl32224GRP-6704CORE-HMO
ENRENR-1010742026-01-13T05:57:39ZGRACEOLITTLE19720206UHC-70114-35•••-••-8216794-358-0354GRACE.LITTLE88@HOTMAIL.COM4309 Spring StSCOTTSDALEaz85229GRP-1566OPTIONS-PPO
CLMCLM-4287142026-06-18T06:42:48ZOmar—Cruz1940-02-18UNKNOWN•••-••-76405687368832N/A4576 JEFFERSON AVENUEPhoenixAZ··85002·N/AUNKNOWN
CLMCLM-4171672026-04-09T06:52:56ZMatthew—Williamson1955-12-05UNKNOWN—UNKNOWN····4340 HARBOR BOULEVARDHOUSTONTX77052-7311—UNKNOWN
CLMCLM-4043182026-05-10T04:56:47ZAngelaTWagner1951-05-16··————·N/Anull—N/AGRP-9777OPTIONS-PPO
ENRENR-1377742026-02-07T18:34:29ZKAYLAVREYES1995-02-08UHC-27866-07—418-331-8017··kayla.reyes@proton.me··2735 Highland AveTampaFL33678GRP-9289MEDICARE-ADV-A
PRVPRV-279182026-03-21T10:47:40ZBILLY—MILLS1946-11-11—N/A——8661 INDIAN SCHOOL RD·PLANOTX75097N/A··
PRVPRV-271922026-02-26T12:35:34ZMARK—SCHULTZ1984-04-08··UNKNOWNN/A(692) 588-9993mark.schultz6@proton.me3302 Palm Drive Apt 25DenverCO80239··—UNKNOWN
ENRENR-1030672026-06-27T06:53:43ZCharlotte—YoungMay 2, 1998UHC-74145-50··—(805) 626-0184charlotte.young@yahoo.com1108 UNION STREET Apt 33PlanoTX75044GRP-6019MEDICARE-ADV-A
PRVPRV-240362026-05-19T23:07:20ZDORIS—SINGH09/25/50UHC-06680-50•••-••-3865+1 421 608 1762—7706 Sage CourtLas VegasNV89120—-
ENRENR-1194382026-03-20T13:37:52ZCrawford, Eugene··I—9/21/1980UHC2340639•••-••-0563(889) 495-1061eugene.crawford59@proton.me2129 Indian School RdScottsdaleaz85202GRP-2163CORE-HMO
CLMCLM-4097202026-02-02T19:03:45ZDanielle—TorresSep 16, 2003UHC-36695-30null(855) 832-4572—4732 WILLOW CTCHANDLERAZ85293GRP-1270null
ENR ENR-1399262026-01-14T08:07:17ZVazquez, DavidN··1991-07-20UHC-60007-82•••-••-94756243644386david.vazquez91@outlook.com5456 Washington Street #974Seattlewa98174-5839GRP-7146MEDICARE-ADV-B
PRV PRV-241042026-09-16T21:28:58ZWalter—Flores1966-11-05N/Anull4604772449UNKNOWN4809 Bayshore DriveAustinTexas78778NULLN/A
ENRENR-1208622026-05-07T23:23:49ZDIANATFIELDS19900926UHC-61484-50•••-••-1981+1 404 321 1488diana.fields@aol.com1618 Jefferson AveChandlerAZ85205GRP-2096CHOICE-PLUS-PPO
ENRENR-1371432026-06-04T02:43:34ZScott—Welch1981-07-13UHC8019778•••-••-50663428648102null5665 Elm St Apt 21DENVERCO80220GRP-9033NAVIGATE-HMO
ENRENR-1071262026-08-18T01:24:38ZRebecca····Miller1995-08-19UHC-58098-43·null4473126499-4169 Desert Sky BlvdEDEN PRAIRIE·MN55344GRP-3838SELECT-EPO
CLMCLM-4126822026-04-09T08:13:05ZLee, Luis—····1965-04-28-UNKNOWN·(264) 582-7180UNKNOWN—UNKNOWN··NULLNULLGRP-7019OPTIONS-PPO
CLMCLM-4168572026-03-23T06:12:10ZTERRYI.RICHARDSON1984-07-04UHC-96410-44N/ANULLNULL921 Main StCHANDLERAZ85220GRP-7595—
ENRENR-1168792026-08-03T21:24:11ZJerry—Romero··03/24/64UHC9831299•••-••-6540(267) 908-1891JERRY.ROMERO57@GMAIL.COM855 Lake View RoadTucsonAZ—GRP-5539CORE-HMO
CLMCLM-4230182026-01-11T22:00:34ZBradley—Carlson6/21/1951UHC-48617-01NULLN/AnullN/A····—UNKNOWN——
CLMCLM-4225822026-04-04T10:12:00ZJohn—Hughes1947-09-08UHC-46207-33null328.335.2963null1769 Mesa DriveTempeAZ85216··GRP-6416··CORE-HMO
ENRENR-1232352026-09-26T05:18:28ZADAMA.KNIGHT1952-11-20UHC-86556-41•••-••-9147(321) 410-2752ADAM.KNIGHT36@GMAIL.COM7661 Market StAtlantaGA30343GRP-8189CHOICE-PLUS-PPO
ENRENR-1238682026-01-08T14:34:28Z·SarahYKnight1983-04-06UHC-23456-64•••-••-153118228673916—7683 SUNSET BLVDMINNEAPOLISMN55499GRP-0316··OPTIONS-PPO
ENRENR-1421362026-09-28T06:38:29Z·RachelOVazuez1983-01-11UHC2139733•••-••-1284385-972-9498RACHEL.VAZQUEZ@AOL.COM7668 CENTRAL AVEAtlantaGA30327GRP-5510OPTIONS-PPO
ENRENR-1269592026-02-25T08:16:27ZWalterD—1986-05-25··UHC-98616-19•••-••-1361(566) 617-0182walter.patterson65@aol.com3166 Mountain View DrLas VegasNV89122GRP-6424MEDICARE-ADV-A
100,000 rows, page 120 of 2,000PreviousNext

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.685Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty