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
ENRENR-120643 2026-01-04T07:13:11ZSharonO.Stevens1985-05-24UHC-10278-31•••-••-5906762-809-4049··sharon.stevens@outlook.com1993 SAGE COURT #947NashvilleTennessee37250GRP-4005··MEDICARE-ADV-B
ENRENR-1134302026-08-21T06:59:19ZMaria—Myers1949-11-10UHC-25623-45•••-••-8135(684) 857-5252maria.myers@aol.com2789 Sage CourtGlendaleAZ85369··GRP-3994SELECT-EPO
CLMCLM-423461 2026-03-26T08:13:13ZEDWARDU.MALDONADO1/10/2006uhc-96749-77•••-••-5003null—·2333 Forest AvenueAUSTINTexas78734—MEDICARE-ADV-B
CLMCLM-4046502026-02-09T20:59:08ZNicole··—Sims2007-09-28UNKNOWN•••-••-3069(220) 330-9197NULL—null—NULLGRP-8142··CORE-HMO
ENRENR-1154472026-07-12T06:10:44Z·Wagner, Jeffrey N——1981-04-19UHC-02624-89··•••-••-248717676570707jeffrey.wagner@outlook.com8796 River RdNashvilleTN37299GRP-6667CORE-HMO
TPATPA-536822026-07-23T04:51:22Zvinent—moreno1975-02-13·-•••-••-28159744288NULL9606 Pine DrJacksonvilleFL32278GRP-7730null
CLMCLM-4175412026-05-14T18:37:34ZSusan—Perkins07/11/92UHC-70290-70··•••-••-8686639-738-3695UNKNOWN1937 CENTRAL AVETEMPEaz85289GRP-7695null
ENRENR-1122762026-04-29T13:20:18ZBRADLEYWJONES07/11/80UHC-91461-93•••-••-8219818-907-2740·N/A2163 Baseline RoadLAS VEGASNV··89162GRP-1505·MEDICARE-ADV-B
PRVPRV-212082026-04-15T07:54:38ZBenjamin—Richardson1958-04-17nullN/A(560) 644-6879-6480 Indian School RdDallasTX75277NULL—
CLM CLM-4323622026-04-01T16:08:23ZSanchez, Amy——19720702UHC6320592•••-••-2395-null7045 DESERT SKY BOULEVARDSacramentoCalifornia95892GRP-2838-
ENRENR-1274672026-09-25T12:32:47ZGraceNPatterson1983-10-22UHC6518374··NULL+1 957 905 4803—2433 Forest AvenueJacksonvilleFL32214-1689GRP-9956NAVIGATE-HMO
ENRENR-1228262026-05-25T20:28:10Zkelly T—dayJan 19, 1983UHC-30774-01•••-••-1188977-622-9722kelly.day@yahoo.com8106 Forest AvenueGILBERTAZ85277··GRP-2591SELECT-EPO
ENRENR-1098122026-09-17T17:48:58ZAbigail—·Hicks4/5/2001UHC-46842-79•••-••-7361····abigail.hicks@yahoo.com251 HILLCREST RDSEATTLEWA98176GRP-2410NAVIGATE-HMO
ENRENR-1189072026-05-28T17:37:10ZKimberlyH.··George1958-03-08·UHC-06108-11•••-••-76913043669565kimberly.george@aol.com252 Harbor BoulevardNashvilleTN37296GRP-0639MEDICARE-ADV-B
TPATPA-554152026-02-04T12:44:02ZNatalie—Reid1974-05-23-•••-••-8290UNKNOWN-8152 MEADOW LANEORLANDO·FL32822——
ENRENR-1116242026-05-11T21:03:57Z·Alice—Fox1596-01-28UHC-49138-69•••-••-3661(755) 691-8267alice.fox27@outlook.com4968 Mountain View DriveCharlotteNCN/AGRP-5260CHOICE-PLUS-PPO
TPATPA-641622026-07-15T14:01:25ZJeff—Warren2001-02-27··NULL646-429-7828NULL5097 MOUNTAIN VIEW DRIVE Apt 1MinneapolisMN55464-UNKNOWN
ENRENR-1070602026-02-16T14:33:21Z·RoyPJordan2002-06-11UHC-59020-72•••-••-419913167770903UNKNOWN3977 Main StMiamiFL33122-7378GRP-1433navigate-hmo
CLMCLM-4025562026-02-23T17:50:32Zbryan····carpenter1953-01-10UHC-20454-32null·+1 254 943 6670UNKNOWN3793 HARBOR BLVDLos Angeles·California90075—-
CLMCLM-4159602026-08-06T17:45:12ZMarilyn—Walker·1999-12-09N/AN/A(523) 651-7965—·721 RIVER ROADMINNEAPOLISMN55443-8119nullNAVIGATE-HMO
TPATPA-568072026-10-04T21:55:02ZArjunG.·Martinez1938-06-17·-•••-••-5991(595) 534-9977arjun.martinez@hotmail.com·210 Union StMinneapolisMinnesota55436GRP-4562N/A
PRVPRV-295162026-07-23T08:57:18Zbrittany—jackson01/05/1956UHC-56213-21•••-••-2212—NULL2035 Oak StreetMESAArizona85281—N/A
ENRENR-1215022026-09-27T04:32:01ZStevenN.Ramirez1952-06-15UHC-82095-13··•••-••-97135604422STEVEN.RAMIREZ@YAHOO.COM5837 Indian School RoadColumbusoh43282GRP-7759OPTIONS-PPO
ENRENR-1120282026-09-16T05:01:21ZDOUGLAS—BRYANT24-09-1970UHC-85493-63•••-••-9593315-848-0114douglas.bryant@gmail.com6227 Mesa DriveEden PrairieMN55327GRP-3931MEDICARE-ADV-B
CLMCLM-4009762026-08-26T19:42:10ZSean—Hunter1944-01-18-N/A16185124174—5604 Pine DrAustinTXUNKNOWN-··OPTIONS-PPO
CLMCLM-4164662026-06-03T09:34:29ZjoykeBhunt1951-05-13-N/A7968446569··901 Meadow LnGlendaleAZ85347GRP-7814-
CLMCLM-4318582026-01-14T06:19:30Zkathleen··L.lane20050521UHC-17661-79null540-633-4740—nullnull—-—CHOICE-PLUS-PPO
CLM CLM-4035962026-03-22T02:23:48ZISABELLA—GRIFFIN12/20/1958UHC-44529-74—UNKNOWNnull-NULL·null-GRP-1013NAVIGATE-HMO
CLMCLM-4317222026-09-22T19:51:48ZJoan—Dunn10/11/2007UHC-24034-56•••-••-3054NULL—1352 PALM DRIVETucsonAZ85747GRP-8710NAVIGATE-HMO
ENRENR-1204572026-03-14T02:11:57Z·ANNA—LI02/06/2002UHC-38800-76•••-••-86758983243993ANNA.LI@GMAIL.COM6393 BroadwayScottsdaleAZ·85266GRP-6900·OPTIONS-PPO
TPATPA-643322026-10-05T01:17:46Z Diego—Lawrence11/27/1978null-847.646.9423diego.lawrence@outlook.com—nullNULL··—CHOICE-PLUS-PPO
ENRENR-1175862026-09-18T14:55:16ZLoriP.Singh06/04/1973UHC-68004-93—·NULLlori.singh60@proton.me2288 CANYON ROADDenverCO80250-2825GRP-5195CHOICE-PLUS-PPO
CLMCLM-4011732026-04-26T11:55:15ZCARL—COLEAug 19, 1943UHC-70721-52N/A··—UNKNOWN2452 OAK STREETCOLUMBUSOH43216GRP-9633UNKNOWN
ENRENR-1307582026-09-24T02:32:05ZMarianaYMaritnez1973-02-25UHC-91751-31•••-••-571314526045419··N/A29 Sage CourtSAN ANTONIOTX78274GRP-8321CHOICE-PLUS-PPO
TPATPA-517582026-08-04T20:09:06ZNicoleD.Harris08/04/55null-UNKNOWNnicole.harris@outlook.com3260 Cedar Ln·FRESNOCAnull··null·-
CLMCLM-4170552026-07-08T20:56:40ZTimothy—Nichols2001-03-11NULLnull716-395-3811—2209 Union StAustinTX78758N/ACHOICE-PLUS-PPO
CLMCLM-4015992026-02-25T02:55:01ZGregory—Williamson1942-02-03·UHC-62492-19•••-••-4677+1 291 808 6349—9673 OCEAN AVE··HOUSTONTX77003—MEDICARE-ADV-B
TPATPA-638942026-02-21T10:11:01ZIsabella—Sims·11/28/1954N/A•••-••-3356·238-640-6617NULL6026 Baseline RdDallasTX75260-null
CLMCLM-4306582026-07-26T17:53:55ZCHRIISTIAN—GONZALES1965-07-03——null·-—-·null-UNKNOWN—
TPA TPA-529412026-08-22T00:33:54ZCastillo, Donald——1942-07-26N/A•••-••-3920(518) 342-4288nullNULLnullnullnullNULLSELECT-EPO
TPATPA-614732026-01-29T22:12:41ZKEVIN—ORTEGA1950-11-09··N/A-UNKNOWN··—7358 Oak StreetHouston·TX--UNKNOWN
CLMCLM-4319902026-02-10T18:39:27Z CHRISTIAN—·NICHOLS1949-03-23UHC-98422-73—··-1259 CHURCH STSan AntonioTX78218··UNKNOWN—
TPATPA-509072026-03-25T10:05:42ZRuht··Mendez2007-11-17—•••-••-2827——7365 Spring StSan AntonioTX78277-5165—CORE-HMO
ENRENR-1084632026-05-23T08:53:31ZJudith—Olsoon04/11/1966·UHC-31184-68•••-••-4822(351) 686-1068judith.olson@outlook.com4157 HILLCREST ROAD #811·PhoenixAZ85023GRP-1341CHOICE-PLUS-PPO
CLMCLM-4275212026-02-15T12:34:34Zlinda—smith··1960-12-14UHC-42244-14NULL—N/A6026 INDIAN SCHOOL ROADTampaFL33609-NAVIGATE-HMO
CLMCLM-4057462026-10-09T22:03:36ZAnna··—Meyer23-09-1938UHC-27108-48UNKNOWN——1046 PALM DRIVEHoustonTX77007··GRP-8472OPTIONS-PPO
PRVPRV-240432026-02-17T17:05:39ZMaria—Yang2007-10-28N/A•••-••-9743-NULL··5815 Hillcrest RdLos AngelesCA90047UNKNOWNOPTIONS-PPO
ENRENR-1367592026-05-03T17:06:45ZRalph··ALee··1941-05-14·UHC-36004-46··N/A··ralph.lee73@proton.me9298 OAK STSan AntonioTX78272GRP-8940CORE-HMO
ENRENR-1340492026-09-30T19:39:56ZIsabellaVLewis·1986-12-27UHC-29437-16•••-••-1990610-209-1011N/A4245 LINCOLN WAY··AustinTX78764GRP-7459··NAVIGATE-HMO
TPATPA-628002026-06-25T14:18:02ZHarold····Olson04/21/82—null—HAROLD.OLSON40@HOTMAIL.COM2989 BASELINE RD Apt 30TUCSONAZ85764nullN/A
100,000 rows, page 174 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.710Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty