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-110886 2026-08-19T01:25:40Z·KIMBERLY—SIMMONS2006-06-17UHC-57214-03•••-••-1589(604) 399-2924KIMBERLY.SIMMONS4@YAHOO.COM8328 Baseline RoadFresnoCA93789GRP-3308CHOICE-PLUS-PPO
TPATPA-641562026-07-08T08:01:31ZKaren—Rose1993-11-16—•••-••-90188776486886null1976 Willow Ct··LAS VEGASNV89101——
TPATPA-548822026-09-27T01:22:41Z AUSTIN—PARK··1987-07-24UNKNOWN———8843 Forest AvenueSEATTLEWashington··98131GRP-0393—
CLM CLM-4025102026-08-15T11:34:19ZOlivia—Hunt1987-09-16—UNKNOWN5355722990-4796 Hillcrest RdAtlantaGA—·GRP-9019CORE-HMO
PRVPRV-294552026-08-05T11:56:02ZCHUCKA.NUNEZ1953-05-25UHC-42084-71-862-710-4283charles.nunez@gmail.com1663 Mesa DrSeattleWA98179——
TPA TPA-633342026-05-05T04:10:17ZLARRY—MORENO1959-04-27—N/A—null——N/A··—··MEDICARE-ADV-B
CLM CLM-4292862026-10-11T22:28:48Z bobby··—wilson1994-01-12—UNKNOWN··NULL-UNKNOWNN/A-nullGRP-7897UNKNOWN
ENRENR-1077892026-06-12T22:02:15ZLindaBBowman9186-06-20UHC-62137-15•••-••-2860+1 319 841 0592linda.bowman@gmail.com7825 Desert Sky BlvdSan AntonioTX··78204··GRP-1488MEDICARE-ADV-A
ENRENR-1182602026-10-07T22:30:29ZDAVID—NGUYEN1945-01-25UHC-96172-78•••-••-80516198636398david.nguyen11@icloud.com7133 Camelback RdAustinTX78740GRP-9820CHOICE-PLUS-PPO
ENRENR-1161222026-04-16T11:47:36ZJULIEILEWIS1963-30-22·UHC-04157-39•••-••-4641—julie.lewis@icloud.com7632 Church StSeattleWA98167GRP-1591MEDICARE-ADV-A··
ENRENR-1135842026-02-01T13:22:04ZBenjaminLJones1991-05-27UHC-38434-13•••-••-71966846058886benjamin.jones@gmail.com4261 Sunset BoulevardCOLUMBUSOH43263GRP-5075MEDICARE-ADV-B
ENRENR-1244332026-08-25T16:03:02ZSTEPHEN····COX1997-04-01UHC-91227-85•••-••-3021+1 945 330 4929·stephen.cox44@yahoo.com9136 BroadwaySAN ANTONIOTX78208GRP-2912NAVIGATE-HMO
ENRENR-135337 2026-10-02T17:15:16ZCamila—Schmidt1982-02-13··UHC-82888-41•••-••-3168(465) 511-8349·camila.schmidt@aol.com8179 HILLCREST ROADPhoenixAZ85011GRP-4360OPTIONS-PPO
ENRENR-1347952026-09-06T04:38:30ZSantiagoJWright1950-06-07UHC-78314-61•••-••-8198704-640-0571santiago.wright@aol.com·5510 Lincoln WayPHOENIXAZ85073GRP-4730CORE-HMO
ENRENR-1203872026-04-22T05:50:07ZPaul—Little1969-06-22UHC-34102-43•••-••-6456(513) 953-6473·paul.little38@aol.com5292 CENTRAL AVEAtlantaGA30343GRP-2399OPTIONS-PPO
ENRENR-1139012026-08-30T17:38:35ZScott, Jennifer·W—·1990-10-11UHC4308665•••-••-58482703368JENNIFER.SCOTT12@ICLOUD.COM3029 Market StSacramento··CA95839GRP-8764CORE-HMO
CLMCLM-4027372026-07-02T14:24:36ZSteven—Ortiz08/10/1954UHC-99424-41——-7834 Camelback RdJacksonvilleFL32224·N/A·MEDICARE-ADV-A
ENRENR-1427332026-07-06T10:30:53ZSOFIARGARDNER10/17/2002UHC-36099-78•••-••-9468(961) 851-2797NULL8066 BroadwaySeattleWA98156GRP-7330·CHOICE-PLUS-PPO
TPATPA-592512026-08-20T23:09:12ZGABRIEL—FORD05/10/03null•••-••-8222null-12 Valley View DriveEDEN PRAIRIEMinnesota55320-6215GRP-1757UNKNOWN
ENRENR-1019082026-04-04T02:24:40Zdylan—wang1941-03-06UHC-09762-15•••-••-62362198627734DYLAN.WANG@PROTON.ME7317 SAGE COURTMesaArizona85221GRP-8788CHOICE-PLUS-PPO
CLMCLM-4235752026-03-09T20:56:03ZDouglas—·Daniels1957-01-06UHC-43682-30·UNKNOWNN/ANULL3223 Washington StreetDenverCO—GRP-2849NULL
CLMCLM-4180532026-10-12T11:15:07Zkaren—anderson1974-08-20UHC4886586•••-••-6666(317) 501-9423null3300 Mountain View DrLos AngelesCA90049GRP-3758CORE-HMO
ENRENR-1261222026-10-14T07:51:33ZAdamOHughes04/05/1974UHC-67149-60··•••-••-15347572253575adam.hughes@yahoo.com-—UNKNOWN—GRP-6894MEDICARE-ADV-A
ENRENR-1198222026-01-14T20:56:29ZDANIELLEARAMIREZ1966-02-11UHC-72750-13•••-••-7175759-917-8217danielle.ramirez47@icloud.com·8031 SPRING STREETMIAMIFL33107GRP-4294MEDICARE-ADV-B
TPATPA-515382026-10-09T13:03:26ZMegan····Davis1994-06-27·-NULL-—5918 Union StNashvilleTennessee·37208—UNKNOWN
TPATPA-523602026-10-17T11:42:02ZSOFIAGBROWN2003-06-02····N/A2624086601-8770 Lake View RdScottsdaleAZ85247UNKNOWNSELECT-EPO
ENRENR-1327642026-02-17T13:34:35ZTerryDWatson··19441106UHC-66989-30•••-••-40929459152615—706 FOREST AVENUE··San DiegoCA92144GRP-9055CHOICE-PLUS-PPO
PRVPRV-209092026-09-19T21:47:02ZChristianNLawsonFeb 12, 1975null•••-••-3766(659) 257-4429christian.lawson64@aol.com5942 Baseline RdGilbertAZ—N/ACORE-HMO··
ENRENR-1321002026-06-12T18:46:56Z·Rose, BrandonM—05/22/1976UHC-85159-64•••-••-750312436368592brandon.rose70@proton.me1264 Valley View DrTucsonArizona85764GRP-3435CORE-HMO
CLM CLM-4107152026-05-25T13:58:12ZHarold··Nelson9/18/1971-—3195965425—918 ELM STREETAUSTINTX78796GRP-0183SELECT-EPO
CLMCLM-4106942026-08-20T05:38:45ZDavid····Woods12/12/07··—UNKNOWN+1 571 675 3261NULL9773 Washington St Apt 24San AntonioTX78283-3457·GRP-5030SELECT-EPO
TPATPA-564492026-07-13T19:33:46ZVASQUEZ—ALEXANDER1951-09-23null-····null4517 Ridge RoadSeattleWA98176-—
ENRENR-1000222026-02-25T19:34:40ZRaymond—Walsh19511103UHC-09175-90•••-••-7458+1 646 319 9468·raymond.walsh91@outlook.com764 BASELINE ROADSEATTLEWA98198GRP-7045··CHOICE-PLUS-PPO
CLMCLM-4093992026-04-10T23:01:21ZFowler, StephenM—2001-09-27·UHC-96013-13•••-••-1021600-797-8481null—NULL——GRP-6067SELECT-EPO
PRVPRV-238872026-03-07T09:56:36ZMills, Ana——06/13/1998—UNKNOWN782-284-9623NULL7015 Union StLas VegasNV··89176—UNKNOWN
ENRENR-1136322026-03-20T06:31:44ZMasonH.ChenSep 21, 1982uhc-68233-59•••-••-937117104003271mason.chen@gmail.com9569 CANYON RDSan AntonioTX78240GRP-2610··options-ppo
PRVPRV-27952 2026-04-02T06:15:45ZPIRYA—LITTLE1949-11-22NULL•••-••-4529(752) 816-8242priya.little46@outlook.com9710 DESERT SKY BLVDColumbusOhio43213NULL—
CLMCLM-4089482026-09-14T21:46:28ZStephens, Seean——12/23/1961UHC-73604-61NULL(970) 800-2977null8270 Desert Sky BlvdMesaaz85282-—
CLMCLM-4258182026-09-08T22:30:15ZWagner, Christine——·2/28/1989N/A-(746) 680-6351N/A8466 JEFFERSON AVETucsonAZ—GRP-7795N/A
PRVPRV-274072026-01-02T13:04:17ZARTHUR—WALLACE1961-07-10-•••-••-0935·(665) 866-7099—N/AnullUNKNOWN—-OPTIONS-PPO
CLMCLM-4059202026-07-03T23:07:31ZJAMES—·HAMILTON09/27/1994--—null2485 Mountain View DriveLos AngelesCA··90040nullN/A
CLMCLM-4199402026-02-18T13:06:47Z GloriaSLee05-09-1988null—15609335158··2438 Sunset BlvdLOS ANGELESCA90068··N/A—
ENRENR-1018402026-09-11T10:25:17ZAmandaMDaniels18-08-1938uhc-10897-78•••-••-65645889986572amanda.daniels19@yahoo.com8322 Sage CourtNASHVILLETennessee··37216-9291GRP-0808MEDICARE-ADV-B
ENRENR-1157302026-09-01T02:30:19ZJanet—Sulllivan11/13/64UHC-57981-28•••-••-47793934903035N/A1756 Lake View RdPhoenixAZ85039GRP-5948OPTIONS-PPO
TPATPA-537882026-03-07T23:02:47ZTheresa··Munoz06/25/41N/AUNKNOWN8789573749N/A5411 Mountain View DrMinneapolisMN55412—N/A
ENRENR-1156662026-05-30T12:02:13ZJoseX.Johnson7/10/1982-•••-••-72266836489848jose.johnson@hotmail.com791 Maple AveLAS VEGASNevada89182GRP-2856choice-plus-ppo
CLMCLM-4300212026-02-18T23:46:09Z·Mason—Santaigo19891206UHC4496259•••-••-6002UNKNOWNnullNULLUNKNOWNN/AnullGRP-4856MEDICARE-ADV-A
ENRENR-1052412026-05-13T13:44:39ZCHRISTIAN··LFERGUSON1978-09-04UHC-73339-50•••-••-4178(628) 358-7707christian.ferguson3@proton.me6291 RIDGE ROAD Apt 9··AustinTX—GRP-9352CORE-HMO
PRVPRV-261952026-07-22T09:01:58ZHenry—MyeersMay 4, 1953NULL-(213) 207-1418N/A2969 Cedar LaneLas VegasNV89100-4663UNKNOWN—
TPATPA-545012026-05-24T08:56:10ZKarenNMorrison1985-06-12—UNKNOWN9417035798null9358 Mountain View DrFRESNOCA93727-—
100,000 rows, page 75 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.793Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty