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
PRVPRV-218052026-10-16T19:24:43ZJeanA··Kelly2007-01-26N/A-N/AN/A1655 Cedar LaneCHANDLERAZ85271NULL-
CLMCLM-427959 2026-02-03T13:43:17ZWislon, Kyle—··1956-10-22UHC-49295-41N/A—N/A834 Oak StNashvilleTNnullGRP-0960—
ENRENR-1363252026-07-15T11:19:21ZIsabella—West1941-02-13··UHC-40107-10•••-••-5467+1 209 653 7952isabella.west@yahoo.com6180 Highland AvePlanoTX75021GRP-0619CHOICE-PLUS-PPO
CLMCLM-4063542026-09-10T20:15:03ZJOYCE—RAY1942-05-09UHC-45796-43··NULL3475552834nullNULL——NULLNULL·MEDICARE-ADV-A
CLMCLM-4083192026-07-23T01:25:53ZMcDonald, Raymond··——Jun 24, 1965N/A•••-••-65583229130UNKNOWN8053 Broadway··San AntonioTX78293-—
CLMCLM-4253252026-10-18T15:53:35ZJOAN—MURHPY05/01/00UHC-51326-26··294-859-5260UNKNOWN4518 Sage CourtJacksonvilleFL32249····CHOICE-PLUS-PPO
CLM CLM-4148352026-09-02T10:59:29ZGregory—Palmer1986-02-26UHC3345051NULL(314) 619-8561GREGORY.PALMER@OUTLOOK.COM8004 Church St··SCOTTSDALEAZ85256-6865GRP-7823UNKNOWN
CLMCLM-4103792026-10-02T12:05:16ZSarah—Cole6/18/1953UHC-95165-36•••-••-1664N/A-NULLnull—UNKNOWNGRP-0730CORE-HMO
PRVPRV-206152026-07-04T00:48:01ZCharlotte—Moore2002-02-05UNKNOWNnull835-765-6917UNKNOWN3631 Market St··MinneapolisMN55475—CORE-HMO
CLMCLM-4318712026-02-05T03:18:17ZCharles—Stevens2004-01-25UHC-12624-66——N/AnullNULLN/A·N/A—CORE-HMO
TPATPA-515002026-08-14T23:13:44ZJoan—Mitchell·1977-11-24—•••-••-2905UNKNOWN····315 HILLCREST ROADLos AngelesCA90088NULL··NULL
ENRENR-1172902026-04-24T12:03:34ZDIANARJACOBS1955-07-17··NULLUNKNOWN+1 287 425 4739··——UNKNOWN—N/AGRP-9226CHOICE-PLUS-PPO
ENRENR-1404872026-01-16T15:09:20ZDaavidN.Phillips1938-01-10UHC-54059-78•••-••-7841221-325-8949david.phillips77@icloud.com7151 Spring StreetChandlerAZ··85299GRP-7050OPTIONS-PPO
ENRENR-1145142026-07-12T01:09:19ZMateoM.BennettFeb 20, 2001UHC-24608-69··N/A(428) 343-9032—6588 Sunset Blvd·DALLASTX75271GRP-9170CHOICE-PLUS-PPO
PRVPRV-294662026-05-22T20:49:18ZJEREMY—MURPHY10-01-1938UHC-74188-97——-2694 Ocean AvenueMiamiFL33148—null
CLMCLM-4130342026-05-28T07:34:46ZCHRISTIAN—HERNADEZMar 27, 1951NULLN/A831-960-9817null—UNKNOWNnull—-N/A
CLMCLM-4050112026-09-03T16:52:11ZAlice—Lynch1958-09-16UHC-12665-44—7566717771—-NULLnullUNKNOWN—SELECT-EPO
ENRENR-1374242026-01-08T15:11:48ZANDREWDMALDONADO1967-12-04UHC-72932-59•••-••-5409—-7983 Union StTempeAZ85272GRP-6951NAVIGATE-HMO
ENRENR-1057422026-05-23T04:27:45ZCARLAHOFFMAN12/11/41·UHC-12474-99•••-••-4002+1 901 217 2683carl.hoffman@proton.me7522 Indian School RoadMiamiFlorida33185GRP-1310·CORE-HMO
CLMCLM-4217752026-04-25T02:08:37ZLuis··—McDonald1940-06-07UHC-12314-12——NULL4096 Main StreetGLENDALEAZ85353GRP-2719—
ENRENR-1102402026-05-28T00:22:40ZLOGAN—PENA1939-08-08UHC5577656•••-••-2660402-927-5385··logan.pena62@hotmail.comNULL—·NULL-GRP-1096NAVIGATE-HMO
ENRENR-1081592026-04-26T19:25:21ZDanielle—McCoy1989-01-25UHC-02509-48•••-••-2053(551) 396-0722-3451 Cedar LaneGLENDALEArizona85304GRP-0651OPTIONS-PPO
TPATPA-632482026-02-18T14:26:19Z·Payne, Madison——1995-11-13N/A•••-••-9680NULLUNKNOWN1413 CENTRAL AVENashvilleTN··37260null—
CLMCLM-4273612026-05-21T01:30:23ZNathan··Gilbert01/10/08UHC-54667-70UNKNOWN····nathan.gilbert89@aol.com9116 SUNSET BLVDCharlotteNC28217GRP-3357NAVIGATE-HMO
ENRENR-1370242026-09-09T15:48:40ZJERRY—DUN·1993-02-22UHC-45079-43··UNKNOWN(678) 992-1657JERRY.DUNN54@YAHOO.COM5397 RIVER ROADCharlotteNorth Carolina··28296GRP-6795CHOICE-PLUS-PPO··
ENRENR-1280142026-09-26T03:00:26ZDYLAN·LBOWMAN1984-06-22UHC-70202-76•••-••-6879UNKNOWNDYLAN.BOWMAN@GMAIL.COM·2383 CEDAR LANEJacksonvilleFL32237GRP-9635CHOICE-PLUS-PPO
CLMCLM-4055032026-03-03T04:24:53ZTONY—MASON08/27/59UHC-71486-08•••-••-2584522-985-4900·nullNULLnull····N/A·GRP-5270MEDICARE-ADV-A
ENRENR-1397712026-10-08T02:59:44ZOwens, Juan——1990-04-23UHC8030115•••-••-0844(966) 531-4257JUAN.OWENS@HOTMAIL.COM9414 Hillcrest Road #736OrlandoFL32819GRP-2053MEDICARE-ADV-A
ENRENR-1188062026-05-24T16:55:35ZMarilyn—Hicks1943-02-26UHC-38790-56•••-••-4656·202-989-0959marilyn.hicks16@outlook.com4833 MOUNTAIN VIEW DRIVEAustinTX78799GRP-3907CHOICE-PLUS-PPO
CLMCLM-4183802026-05-18T06:25:54ZGloria—Johnston—UHC-03301-51•••-••-7811-GLORIA.JOHNSTON56@OUTLOOK.COM··2654 Maple AvenueOrlandofl··32863NULLOPTIONS-PPO
CLMCLM-4280052026-02-19T13:30:06Zwiillie—hughes2007-11-19UHC3686798•••-••-6707280-582-1410··7719 BroadwayChandlerAZ·85201GRP-7777—
TPATPA-547522026-05-25T07:22:51Z ERIC—LANE1948-11-21-•••-••-2669+1 598 637 3246—1483 MEADOW LANEFRESNOCA93756——
TPATPA-638502026-04-12T04:53:53ZCYNTHIA—MARTINEZ1996-09-25—····null—7315 BROADWAYGilbertAZ85227—MEDICARE-ADV-A
ENRENR-1100312026-09-11T16:24:59ZAbigail—Herrera·08/01/2007UHC-30685-36—5625269774ABIGAIL.HERRERA@YAHOO.COM6743 Central AveLas VegasNV89114GRP-5323OPTIONS-PPO
CLMCLM-4028012026-03-14T07:47:47ZEmily—Walker1997-10-13———-350 MAIN ST #285·San DiegoCA92135······MEDICARE-ADV-B
ENRENR-1158422026-07-08T20:18:35Z Daniel··GrayDec 1, 1980UHC-40750-73··•••-••-303619077702615DANIEL.GRAY@YAHOO.COM8185 SPRING STTampaFL·33657GRP-7373CHOICE-PLUS-PPO
CLMCLM-4248762026-06-08T06:39:22ZALICE—CRUZ19740913UHC-21043-26N/A-N/A——-—GRP-4698MEDICARE-ADV-B
CLMCLM-4276382026-10-18T03:46:22ZROY—BURNS·1996-01-06uhc-22217-24•••-••-6683····-·UNKNOWN—-·-GRP-2544NAVIGATE-HMO
ENRENR-141360 2026-04-29T08:21:33ZLUCIAVMENDOZA1965-02-03UHC-92600-02•••-••-06663794803350lucia.mendoza@outlook.com3079 SUNSET BOULEVARDTucson·AZ85764-8061GRP-1732CHOICE-PLUS-PPO
ENRENR-1198252026-05-20T12:05:44ZKatherine—Jacobs0085-19-96UHC-26509-84•••-••-1782+1 399 886 5637katherine.jacobs15@gmail.com··9842 Indian School RoadPhoenixAZ85091GRP-2991CHOICE-PLUS-PPO
PRVPRV-232932026-01-03T13:56:59ZVirginiaTWright1950-01-25UNKNOWN•••-••-1285--4695 Market StLos AngelesCA90035—N/A
ENRENR-142940 2026-07-28T18:11:07Z·Katherine—Silva1967-06-26UHC-61789-52•••-••-8438·(240) 267-2357katherine.silva@gmail.com1917 Palm DriveHoustonTX77040GRP-1684·MEDICARE-ADV-B
CLMCLM-4210062026-05-27T08:22:40ZADAM—MCDOONALD22-08-1986N/A•••-••-6189681.523.0456ADAM.MCDONALD@AOL.COM5555 Sunset BoulevardCOLUMBUSOH43214GRP-5527—
ENRENR-1174902026-04-12T13:13:40ZMaria—Edwards2000-02-04·UHC-28038-32NULLnull-5499 Ridge RoadJacksonville··FL32285GRP-5370CHOICE-PLUS-PPO
CLMCLM-4101082026-07-10T18:31:35Zcheryl—garza1964-08-05UHC-54815-28N/ANULL—561 Jefferson AvenueSan DiegoCA92167-3918GRP-8598···MEDICARE-ADV-A
ENRENR-1222562026-06-12T18:44:07ZSandraZFlores11-12-2003UHC-55057-99•••-••-3103(723) 765-5518-··6442 CHURCH STGlendaleAZ85344··GRP-6015OPTIONS-PPO
ENRENR-1009712026-10-14T08:53:21Z·Perez, Ronald——01/07/80UHC1219435•••-••-8287(469) 822-7013ronald.perez21@icloud.com3180 Elm StreetCharlotteNC28284GRP-6446CHOICE-PLUS-PPO
CLMCLM-4142042026-08-27T18:44:39ZGluria··Hamilton1938-03-03UHC-85050-17N/A—nullUNKNOWN———nullNULL
ENRENR-1289832026-08-16T12:17:41ZSteveUEvansOct 12, 1969UHC-53770-89•••-••-0734933-282-0762NULL9061 Meadow LaneSacramentoCalifornia95854GRP-7511NAVIGATE-HMO
ENRENR-1367522026-05-18T10:20:35ZLAUREN—CASTILLO1995-02-27UHC-82470-95•••-••-4613583-830-2953N/A1958 Highland Ave Apt 14··Austin··TX78734GRP-0189MEDICARE-ADV-B
100,000 rows, page 172 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.709Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty