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-4192992026-09-20T04:19:43ZIsabella—Welsh1979-06-04NULL•••-••-5267—isabella.walsh@icloud.com8165 Camelback RdORLANDOFL32827UNKNOWN—
ENRENR-1387592026-09-03T05:55:42ZKIM—PAMELA1980-03-14UHC-79074-20•••-••-2227(769) 975-3197null2856 Washington StMinneapolisMN55408GRP-1959MEDICARE-ADV-B
ENRENR-1377472026-10-11T07:17:30ZJACQUELINEPSCHULTZ1979-10-11UHC-76279-02•••-••-8726946-206-5805··-1456 Lincoln WayGlendaleAZ85346GRP-8387MEDICARE-ADV-A
CLMCLM-4190002026-10-08T14:30:11ZMaria—Perry1950-03-18UHC-77478-68UNKNOWN--3812 SAGE COURTSeattleWA·98135GRP-3836null
CLMCLM-4128382026-07-30T20:09:16Zharold—fernandez1981-07-02UHC-45011-98NULL822.225.0190N/A—null—N/AGRP-8285NAVIGATE-HMO
ENRENR-115867 2026-07-30T10:04:00ZTerryIStephens06-01-1975UHC-40276-33•••-••-2886736.550.0542null6170 Baseline RdMiamiFlorida33147GRP-2153MEDICARE-ADV-A
ENRENR-1207142026-03-31T10:08:36ZDENNY—·HANSEN12/15/58UHC-20254-19•••-••-9204+1 982 202 0073dennis.hansen61@icloud.com6525 SAGE COURTPhoenixAZ85024GRP-5469SELECT-EPO
ENRENR-1297232026-01-01T10:27:10ZRichardOSantiago1986-05-09UHC-26774-18•••-••-9830—richard.santiago@gmail.com9782 Bayshore DrAustinTX78722GRP-3077MEDICARE-ADV-A··
ENRENR-1416452026-04-27T13:37:29ZMARIANA—MOORE1970-04-24·UHC-57676-62•••-••-37308817138923mariana.moore84@gmail.com5410 Palm DrChandlerAZ85228GRP-1442SELECT-EPO
CLMCLM-4198142026-06-09T12:45:44ZAdamTDixon07/03/74UHC-43173-48•••-••-8847·6179309N/AN/A--nullGRP-9698—
PRVPRV-232732026-07-02T00:00:11ZMARIA—GRAY1994-12-02UHC-06693-16null329-500-2298—·7226 Lincoln WayCharlotteNC28208—null
ENRENR-1311912026-05-25T12:08:21ZArjunXAustin··1960-03-04UHC8491923•••-••-3964435-830-2251··ARJUN.AUSTIN95@ICLOUD.COM2454 Highland AvenueTempeAZ85211GRP-8662MEDICARE-ADV-A
ENRENR-1316212026-09-19T16:40:19ZANTHONY F—GUTIERREZ1986-06-16UHC-85172-66—229-640-9013··anthony.gutierrez@proton.me7152 Sage CtChandlerAZ··85267GRP-1850MEDICARE-ADV-B
TPATPA-616042026-07-16T02:59:22ZChris··—Robinson1990-04-22null——CHRISTOPHER.ROBINSON@YAHOO.COM2661 Valley View DriveLOS ANGELESCA90006-N/A
CLMCLM-4058932026-09-28T20:49:14ZMARCUS—·LAWSON9/6/1986UHC-23031-42•••-••-9029null—1599 Meadow Ln Apt 10OrlandoFL32899GRP-6550CHOICE-PLUS-PPO
PRVPRV-274532026-02-07T15:08:47Z KAYLA—MARTIN1981-02-09—NULL(730) 388-2240KAYLA.MARTIN@PROTON.ME2860 SPRING STNASHVILLETN37218NULL—
PRVPRV-216262026-08-17T18:24:12ZVargas, Mark——1982-06-13—NULL(638) 241-8379—7658 OAK STPhoenixAZ85019——
CLMCLM-4304292026-09-23T12:36:12ZKellyB.Watson1986-04-16UHC-78347-04•••-••-5098N/AnullNULL—N/AN/AGRP-5770··NAVIGATE-HMO
TPATPA-634392026-09-28T09:14:04ZJean—Smith1938-10-14·nullN/A——4181 Lake View RdGilbertAZ85200GRP-6826null
TPATPA-620492026-09-28T23:49:16ZChristine—Wright24-09-1944··———NULL5725 Ocean AveORLANDOFL32857—·-
CLM CLM-4275082026-05-29T20:51:13ZBrian··—Matthews09/19/64N/AN/A·264-316-4895·BRIAN.MATTHEWS16@AOL.COM6673 Meadow LaneMiamiFL33132GRP-9763CHOICE-PLUS-PPO
ENRENR-1305672026-02-17T08:56:48ZLane, VirginiaL—09-09-1957UHC5368649··•••-••-452914409852591VIRGINIA.LANE88@HOTMAIL.COM8548 Indian School RoadDenverCO80250GRP-5160OPTIONS-PPO
ENR ENR-1411952026-07-10T20:27:39ZRANDY··RWATKINS1992-06-03UHC-12417-87•••-••-76132873288828-1964 JEFFERSON AVELas VegasNV89170GRP-3815NAVIGATE-HMO
CLMCLM-4282852026-09-13T16:37:38ZJESSICAYCARROLL1942-01-62—•••-••-14365033331504N/A9859 Sage CourtJACKSONVILLEFL32206GRP-2629null
ENRENR-1211832026-07-21T19:02:10ZDANIELLE—KINGMay 23, 1982UHC-42664-83•••-••-3716698-443-7672danielle.king55@yahoo.com6050 PARK PLACEFRESNOCA93707GRP-2092OPTIONS-PPO
ENRENR-1143842026-01-31T06:22:37ZETHANEBUTLER1996-12-25UHC-96007-92•••-••-1239(582) 370-1347ethan.butler23@aol.com708 BroadwayGilbertArizona85232GRP-2694·CORE-HMO
ENRENR-1342722026-09-01T07:19:22ZAlbert··VDominguez1961-08-27UHC1612524•••-••-8987(389) 322-7612albert.dominguez59@gmail.com3883 Canyon Rd #141SACRAMENTOCA95819-7517··GRP-8361CHOICE-PLUS-PPO
ENRENR-1145112026-08-14T21:18:03ZDoris—Yang12/03/68UHC-09369-79•••-••-7784+1 228 244 8221UNKNOWN3736 Pine DrivePhoenixAZ85014GRP-0195··MEDICARE-ADV-A
CLMCLM-4320162026-06-13T01:37:24ZBrdaley—Ferguson1957-12-13UNKNOWN•••-••-6048204-631-8258N/AUNKNOWN-··nullNULLUNKNOWNNAVIGATE-HMO
CLMCLM-4215962026-01-29T17:18:27ZTERRYL.LI1965-05-07——4623377466····8628 Oak StreetSan AntonioTX78245GRP-5732N/A
CLMCLM-415906 2026-04-14T13:46:01ZNATHAN—CAMPBELLJan 12, 1958··—NULL812-345-8389-·6555 Palm DriveCHARLOTTENC28231GRP-9588—
ENRENR-1005312026-04-12T06:10:20ZCHERLES—WILLIS·1954-04-17UHC-75469-91··•••-••-3829+1 778 327 0021charles.willis@yahoo.com··2631 Lincoln WayAustinTexas78745GRP-4408·MEDICARE-ADV-A
PRVPRV-287102026-02-09T23:39:27Z·Kathryn—Mendez06/22/1968UHC-53197-07—+1 743 348 4944—7362 Maple AveTUCSONAZ85782nullN/A
ENRENR-1387582026-06-24T10:24:01ZDorothyYBanks1968-02-22UHC-45975-38•••-••-5187(779) 675-8829null2711 Baseline RoadOrlandoFL32854GRP-3050SELECT-EPO
TPATPA-601892026-03-07T18:29:54ZFrances—Wnog11/20/1997—N/A(717) 892-1720—6245 BroadwayDenver·CO80235NULL—
ENRENR-1008162026-08-15T01:11:16ZAbigail··HHayes2004-06-12UHC-91200-52•••-••-9417829-664-6716abigail.hayes@proton.me4247 Hillcrest RoadAustinTX78792GRP-4570CHOICE-PLUS-PPO
CLMCLM-4017192026-10-08T07:10:51ZCamila·L.James1990-08-22——912.616.8583—5779 Lincoln WayCharlotte···North Carolina28261-·NULL
ENRENR-1351562026-02-28T17:44:59Z·elijahLmontgomeryNULLUHC-34909-33NULL249-907-7765-7134 Jefferson Avenue Apt 24NashvilleTennessee37234GRP-7097OPTIONS-PPO
ENRENR-1237462026-01-21T20:37:19ZAustin—Dorothy1949-11-11UHC-48631-14•••-••-1976462-533-7469DOROTHY.AUSTIN99@OUTLOOK.COM8657 Oak StreetLos AngelesCA90068GRP-2488CHOICE-PLUS-PPO
ENRENR-1027992026-10-15T21:33:12Z·PAUL—GARRETT··1973-02-03UHC-53636-94•••-••-14772408614041paul.garrett@outlook.com971 Indian School RdChandlerArizona85268GRP-8103·MEDICARE-ADV-A
ENRENR-1309622026-05-04T16:06:23ZAllenQ.BreendaMar 7, 1952UHC-73574-97•••-••-1590(917) 588-5664brenda.allen@gmail.com2354 APACHE BOULEVARD Apt 22ATLANTAGeorgia30345GRP-9743CHOICE-PLUS-PPO
CLMCLM-4320142026-10-15T15:07:19ZArjun—Santos14-05-1960N/AN/A—null866 Hillcrest RdEden PrairieMN—GRP-2305··NAVIGATE-HMO
CLMCLM-4006232026-09-20T04:08:57ZBRUCEP.MARTINEZ··1967-02-06UHC-23802-99N/A—bruce.martinez84@proton.me6126 CANYON RDDALLASTX75286GRP-1365null
PRVPRV-259022026-10-05T08:29:00ZCheryl····Ramos20000103NULLnull—CHERYL.RAMOS3@AOL.COM6590 Willow CtColumbusOH·43221N/A—
ENRENR-1029782026-08-05T04:20:12Zjoshua—johnson1995-50-03UHC7242230UNKNOWN(665) 795-0588joshua.johnson@aol.com7815 Maple AvenueTucsonAZ85726GRP-0356CORE-HMO
CLMCLM-4299332026-03-03T14:21:36ZWALTER—FLORES1947-07-06UHC-24155-05·N/A—null9510 GRAND AVELos AngelesCA90056GRP-6344medicare-adv-a
ENRENR-1401342026-02-09T12:19:36ZWagner, TylerD—1974-04-01UHC-13695-74··•••-••-5888(356) 775-3034tyler.wagner@gmail.com2317 Camelback RoadChandlerAZ85226GRP-8360MEDICARE-ADV-A
PRVPRV-201742026-04-30T06:18:58Zbrandon—bryant1980-12-13UHC7804795•••-••-9574(953) 340-0231————NULLUNKNOWNMEDICARE-ADV-B
TPATPA-617142026-04-12T02:28:12Z·Tyler—Reyes1970-89-23—-(478) 903-8854null··4440 Maple AveORLANDOFL32849··GRP-9510—
ENRENR-119424 2026-07-25T04:56:27ZDOUGLASYHARPER1942-03-21UHC-45918-09•••-••-0894(936) 717-1067douglas.harper8@gmail.com4966 Grand AveSacramentoCA95822GRP-4365OPTIONS-PPO
100,000 rows, page 36 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:34.770Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty