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-4051972026-02-21T23:48:09Zvictoria··mccoy1998-05-22UHC-62971-33—(701) 845-5061—8234 OAK STREETSEATTLEWashington98100·NULLnull
CLMCLM-4100142026-08-07T03:01:17ZLANE—ARTHUR1971-08-10UHC6074808·-(201) 221-9236UNKNOWN·7691 Elm StreetFresnoCA93720UNKNOWN—
PRVPRV-201642026-06-01T05:33:08ZAnthony—Riley1961-09-02·N/ANULL(340) 844-8924NULL4452 Harbor Blvd··SAN DIEGOCalifornia·92151NULLMEDICARE-ADV-A
TPATPA-619892026-04-15T23:34:39ZSTEVENN.··WELCH2002-11-08UHC-34050-08-—null9598 Mountain View DriveAtlantaGA30368—NULL
CLMCLM-4014392026-06-23T22:30:55Z ·BRUCE—CHAVEZ8/25/1940UHC-59211-88•••-••-3355482-328-6893UNKNOWNnullNULL—nullGRP-3955NULL
PRVPRV-291672026-05-06T18:23:48ZCarl—Sims··1964-06-26uhc-22625-51—(896) 738-6776carl.sims@icloud.com3056 INDIAN SCHOOL ROAD··TUCSONAZNULL—N/A
TPATPA-604902026-04-25T13:59:42ZRalphMFisher18-03-1989UHC-77097-62-·nullralph.fisher@hotmail.com5993 BAYSHORE DRLas VegasNV—N/AOPTIONS-PPO
PRVPRV-236062026-05-27T10:12:43ZKyle—Hall1971-12-28UHC-40356-45null··(498) 716-4866N/A3425 River RoadEden PrairieMN55396-5726—MEDICARE-ADV-B
ENRENR-1412202026-02-11T01:45:57ZJOSHUA—CRAWFORD1966-05-13·UHC-85570-06•••-••-6109865-501-4135joshua.crawford54@proton.me7519 Elm StreetDenverCO—GRP-2079NAVIGATE-HMO
ENR ENR-1152602026-08-10T12:07:31ZDoris—McCoy26-08-1984UHC-58446-73•••-••-2966664-476-0105-7393 River RdGilbertAZ85242GRP-2739NAVIGATE-HMO
CLMCLM-4099102026-10-17T06:02:26ZJordanOFowler7/25/1992—NULL432-510-3303——--—GRP-2959null
ENRENR-1257972026-10-09T12:52:48ZMarianaJArnold1973-01-18UHC-82201-41•••-••-9042(620) 860-9139UNKNOWN7880 Ocean AveTEMPEArizona85216-4757GRP-3586MEDICARE-ADV-A
TPATPA-531652026-07-06T19:39:34ZjasonF.ryyan06/10/93—null—-1933 LAKE VIEW ROADGilbert··AZ85207-0159GRP-8340null
ENRENR-1336822026-09-26T22:43:40ZRay, Tommy——1942-08-12·UHC-25610-12•••-••-8562437-846-1048—979 BroadwayTucsonAZ85731GRP-9995MEDICARE-ADV-B
ENRENR-1042192026-03-08T15:55:14ZSusn—Schultz1939-11-17··UHC5164266•••-••-22549623369527SUSAN.SCHULTZ1@GMAIL.COM·4292 Highland Ave·SEATTLEWA····GRP-1458MEDICARE-ADV-B
TPATPA-553992026-03-17T03:03:19Zralph—fox1970-06-04NULLUNKNOWNnullnull2658 Indian School Road··Orlando··FL32800nullN/A
ENR ENR-1218062026-01-24T11:22:06ZJohn—Larson··08/14/79UHC-27245-80•••-••-5781+1 986 974 0126john.larson@icloud.com6872 Palm DrPhoenix··AZ85067GRP-8776CHOICE-PLUS-PPO
ENRENR-1378672026-06-28T12:06:47Z·Donna····Russell9/22/1981UHC-64385-22•••-••-6357(309) 867-3471—8815 Sunset BoulevardSeattleWA·98122GRP-4961·NAVIGATE-HMO
PRVPRV-287772026-08-24T01:31:51ZJuliaALarson01/23/1969UHC2750234•••-••-5997582-973-4161julia.larson80@aol.com6838 Maple Ave··Houston·TX77091·nullMEDICARE-ADV-B
ENRENR-1410292026-10-12T13:52:58ZTheresaASingh1948-04-09UHC-14998-79•••-••-23254599033090theresa.singh76@outlook.com8027 Union StAustinTXUNKNOWNGRP-9550CHOICE-PLUS-PPO
TPATPA-563262026-01-28T03:35:46ZTheresaB.Mills2000-03-14NULL—-··—2359 Market Street·TUCSONAZ85714NULL··medicare-adv-a··
CLMCLM-4317412026-06-10T23:58:23ZLinda—White03/14/1948UHC0045447N/A——·NULL————N/A
PRVPRV-222462026-05-28T19:31:22ZASHLEY··BROOKSMar 10, 1991UNKNOWNN/A17187793598ashley.brooks44@yahoo.com1256 Canyon RdPhoenixAZ85069N/ASELECT-EPO
ENRENR-1365762026-10-03T12:33:49ZyukiSstephens1941-11-27UHC-35271-91-(687) 557-2311yuki.stephens@aol.com1860 Cedar LnGilbertAZ··85237GRP-5012MEDICARE-ADV-A
TPATPA-542932026-02-17T07:31:18ZAMBER—LI1943-02-26-———2607 Apache Blvd #414··Eden PrairieMN55397——
ENRENR-1229572026-02-21T05:19:55ZBaker, MariaH—1972-02-28UHC-25029-78•••-••-7055+1 650 903 8382··5242 HILLCREST ROADNashvilleTNN/AGRP-3196MEDICARE-ADV-B
TPATPA-602172026-08-05T19:36:24ZlisaSanderson1951-12-09null··•••-••-4127N/A····2347 Market StJacksonvilleFL32216UNKNOWNMEDICARE-ADV-A
CLMCLM-4015322026-01-01T07:51:08ZKeithLFord12/04/1979UHC-86520-46NULL-null3256 Meadow LaneAtlantaGA30389GRP-9399null
ENRENR-1088222026-03-10T20:23:59ZWAAYNECTURNER··Sep 1, 1948··UHC-74124-29•••-••-5093NULLwayne.turner13@gmail.com4921 Canyon Rd·LAS VEGASNV89169GRP-6119OPTIONS-PPO
CLMCLM-4278592026-06-17T01:18:26ZBradley····Hernandez1998-05-27nullNULL··(860) 399-2759null—NULLNULL—GRP-9596-
PRVPRV-294262026-09-15T13:16:42ZJason—Wells1979-06-12UHC0271963•••-••-20108826052732jason.wells@yahoo.com7236 Valley View DriveSAN ANTONIO·TX78296null—
CLMCLM-4249392026-02-08T20:02:41ZDIANE—FLORES1957-03-20—UNKNOWN967-928-1052NULL--—UNKNOWN—NAVIGATE-HMO
ENRENR-1072172026-07-16T20:59:55ZSHIRLEYPESTRADA1982-10-07·UHC3022274•••-••-890812714414326N/A1380 MOUNTAIN VIEW DRTempeAZ·85202GRP-2403MEDICARE-ADV-B
ENRENR-127045 2026-05-03T03:02:56Zmary E.—prike18-09-1946·UHC-79267-93•••-••-29585314924067N/A4950 Union Street··SAN ANTONIOTX·78285GRP-1045MEDICARE-ADV-A
PRVPRV-216132026-08-03T21:29:09ZAlbert—Mason19540314·UHC-72233-68··769.593.6039NULL2440 Desert Sky Boulevard··Glendaleaz85355—·null
ENRENR-1124802026-01-02T17:37:25ZChristopher—Coleman10-08-1965UHC-83613-24•••-••-7487458-853-6985christopher.coleman71@icloud.com783 MOUNTAIN VIEW DRAustinTX78738GRP-3637CORE-HMO
ENRENR-1077122026-02-05T14:19:51Z·AlexisQYang19971220UHC-98520-52•••-••-8091—alexis.yang@aol.com6129 Sunset BlvdSan AntonioTX78200GRP-2729MEDICARE-ADV-B
PRVPRV-206052026-07-14T11:27:08ZWalter—Ortega·1960-11-18·UHC-32319-15NULL(758) 986-4166UNKNOWN3191 ELM STSan AntonioTexas78296——
ENRENR-1385162026-02-04T07:43:19Z Beverly··—Ortega16-07-1950UHC-09931-26•••-••-5507575.975.7794N/A830 BAYSHORE DR·DALLASTexas75209GRP-2139CHOICE-PLUS-PPO
TPATPA-590202026-02-04T08:06:27ZJoseN.Wells06/15/1968—-4147465634null409 Baseline RoadChandlerAZ85238——
PRVPRV-241532026-01-26T19:56:48ZBRADLEY··ARNOLD1/14/1957-nullUNKNOWN-525 Lake View RoadGilbertAZ··NULL—N/A
ENR ENR-1418432026-01-07T23:12:08ZDorothy····Fulelr20-03-1970UHC-32368-14··•••-••-0693N/A—5100 GRAND AVENUECharlotteNC28272GRP-1708·OPTIONS-PPO
ENRENR-1394272026-03-19T05:42:37ZKyleG.Meyer1976-10-28UHC-64032-36•••-••-56967879715728—5213 Lake View RdTAMPA··FL33615GRP-5548CORE-HMO··
TPATPA-520072026-06-24T20:02:32ZGary—·Hansen1975-05-10N/A—UNKNOWN—NULL—-—GRP-3801—
PRVPRV-223902026-04-17T13:12:44Z SARAH····MARSHALL1941-06-20UNKNOWNUNKNOWN7891031—4580 RIVER ROADTucson··Arizona85708——
ENRENR-1037382026-04-17T09:20:09ZCheyrlT··Carlson—UHC-21115-04•••-••-5871691-363-0878cheryl.carlson@aol.com3405 WASHINGTON STPhoenixAZ85084GRP-1590··CHOICE-PLUS-PPO
PRVPRV-225772026-08-10T06:15:45ZGary—Stone··03/24/39UHC-26978-96N/AUNKNOWNgary.stone@proton.me7116 CAMELBACK RDNashvilleTN37294nullNULL
ENRENR-1407932026-01-27T09:08:13ZJonathanY.··Hunt1991-05-28UHC-20299-86•••-••-6936233-893-2043····8273 Palm DriveTampaFL33613-2824GRP-6553NAVIGATE-HMO
CLMCLM-4313602026-10-15T14:59:48ZKimberly—Delgado·1961-12-14UHC-27985-96•••-••-5573N/A—5493 River RoadDallas·TX·75247GRP-5722null
CLMCLM-4160762026-07-09T10:27:33ZJordan—Lee1969-03-03·UHC-83908-16•••-••-9129(440) 404-4747UNKNOWN3342 GRAND AVENUELos AngelesCA90009··——
100,000 rows, page 217 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:37.729Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty