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-4007122026-07-23T00:14:01ZSTEPHEN—MURPHY1955-10-14UHC0029143-683-720-2601-9309 Ridge RoadNASHVILLE··TN-——
ENRENR-1384762026-05-11T19:58:40ZJANETB.··MYERS1976-03-26UHC-34234-73•••-••-11733436329039JANET.MYERS99@OUTLOOK.COM1433 Jefferson AveJacksonvilleFL··—GRP-7320SELECT-EPO
ENRENR-1228962026-08-28T07:45:11ZEVELYN·TJENSEN2005-05-28UHC7227872•••-••-4712·(561) 657-7951—9886 Sage CourtPHOENIXaz85052GRP-8113·OPTIONS-PPO
ENRENR-1328832026-09-09T00:08:18ZSimmons, AmandaA—1945-02-14UHC-72306-59•••-••-56292098525970amanda.simmons55@yahoo.com4107 Indian School RdSan DiegoCalifornia92111GRP-3947··MEDICARE-ADV-A
ENRENR-1222032026-04-01T01:35:48ZChavez, Michelle··—1992-04-26UHC-36979-40•••-••-2758—MICHELLE.CHAVEZ@PROTON.ME5832 Sunset BoulevardScottsdaleAZ85288-2461GRP-5925CORE-HMO
ENRENR-1404022026-07-30T09:29:37ZRoberts, Wayne——16-04-1976UHC-40291-13•••-••-6990(774) 876-9308UNKNOWN5652 Canyon RoadAustinTX··78724GRP-6965MEDICARE-ADV-A
CLMCLM-4025922026-09-09T08:03:44ZOlivia—Hughes1985-02-19UHC-11245-96null—····6459 Lake View RoadDenverCO·80228-4661N/AMEDICARE-ADV-A
CLMCLM-4102542026-05-10T16:45:36ZFrank—Carter1947-02-18UNKNOWN•••-••-0190N/ANULL·8754 Meadow LnTEMPEAZ85277GRP-0813CORE-HMO
CLMCLM-4296212026-06-25T17:13:45Z·RUSSELLQJACK1988-05-10—nullnulljack.russell82@aol.comnull—-UNKNOWNGRP-8880SELECT-EPO
ENRENR-1189012026-01-04T14:46:52ZDavid—Sullivan9183-02-03uhc-29415-94•••-••-2612871-515-3745·DAVID.SULLIVAN12@OUTLOOK.COM7143 Palm DrEden PrairieMN55343GRP-5545MEDICARE-ADV-B
ENRENR-1131862026-05-28T23:19:24ZSandraANunezNov 26, 1977UHC-69103-39•••-••-7074(652) 267-6685SANDRA.NUNEZ@OUTLOOK.COM5624 Church StAustinTX··78784GRP-6810MEDICARE-ADV-B
CLMCLM-4096162026-05-09T22:16:52ZMartha—Singh1999-11-07····null(211) 940-3045N/A3687 Pine DrJacksonvilleFL32278NULLMEDICARE-ADV-B
CLMCLM-4180252026-08-13T21:37:06ZYkuiMMurphy1945-05-16UHC-24467-37•••-••-5468795-219-2534null3311 Ocean AveSacramentoca95816··—
CLM CLM-4265332026-07-22T12:13:25Zcatherine··—medina9/7/1970UHC-50377-75··•••-••-2309331-865-7151NULL4377 Park PlHoustontx77001N/ANAVIGATE-HMO
ENRENR-1243612026-01-12T12:06:49ZMason—Fowler1940-01-28UHC-02372-66•••-••-19164247934688UNKNOWN606 PALM DRIVE #377Glendale·AZ85310·GRP-1872MEDICARE-ADV-B··
ENRENR-1375432026-09-29T02:18:20ZHIROSHIJANDERSON19561213UHC-20940-17UNKNOWN667-787-8937—8110 Desert Sky BlvdNASHVILLETN37282GRP-4970MEDICARE-ADV-A
TPATPA-505052026-02-01T00:30:08ZFox, Terry——·2007-08-14nullNULL——5658 Maple AvenueLas VegasNV89181-9304GRP-9014NULL
ENRENR-1212882026-02-07T09:39:29ZThomasCStephensJun 13, 1986UHC9313685•••-••-44528272320636thomas.stephens64@outlook.com4569 Jefferson AvenueCharlotteNC28218GRP-7913CHOICE-PLUS-PPO
CLMCLM-4183362026-08-01T18:15:40ZCAMILA—RAMOS1952-05-01UHC-23396-60··N/A3156815432NULL8909 Market StCharlotteNC·28213GRP-1035··NAVIGATE-HMO
PRVPRV-223122026-10-06T04:59:25ZDenise Q····Lane1943-08-91-—3863616140NULL8532 Sage CtHoustonTX77041null····
CLMCLM-4002392026-03-01T09:24:09ZRice, Emily——1955-12-08UHC-52218-45•••-••-8035(410) 895-6746-N/A-NULL—null·CHOICE-PLUS-PPO
CLM CLM-4262862026-03-05T01:55:53ZPamela—ReidJul 6, 1986UHC-83233-52•••-••-1059N/ANULL8710 Sunset BoulevardHoustonTX77018GRP-0312CORE-HMO
CLMCLM-4115692026-03-30T06:04:45ZSantiago—Miller1951-02-23UHC-98037-76—9432530574null··963 Mountain View DriveSACRAMENTOCA95893NULLCORE-HMO··
ENRENR-104939 2026-05-09T22:29:58ZEsipnoza, Vincent——1980-10-11UHC-29654-36··•••-••-27677965684784VINCENT.ESPINOZA@AOL.COM3999 Church StLas Vegasnv89101GRP-9531NAVIGATE-HMO
CLMCLM-4013532026-07-02T05:53:14ZJulia····Ortega07/12/75UHC-75167-48•••-••-1762——null—UNKNOWNUNKNOWNGRP-0605—
ENRENR-1273962026-04-13T23:07:51ZEmma—Soto1957-10-07UHC-80867-23•••-••-579417385433932emma.soto25@hotmail.com3951 PARK PLCharlotteNC28233GRP-6668MEDICARE-ADV-A
CLMCLM-4088342026-03-24T16:24:54ZRebecca—Roberts1981-03-07UHC-71907-16•••-••-3355842.482.4889··—7830 CAMELBACK ROADGlendaleAZNULL—CHOICE-PLUS-PPO
CLMCLM-4075322026-07-01T09:28:34ZROGER—WHITE1948-08-05UHC-38078-45—(337) 457-0252—1413 Meadow LaneMiamiFL33135—SELECT-EPO
CLMCLM-4308652026-06-09T18:26:32Zdennis—brown1944-05-22··UHC-22981-87UNKNOWN5062915317—····—null—nullMEDICARE-ADV-A
CLMCLM-4325902026-01-11T19:21:12Zchrystina··—martinez2000-02-25UNKNOWNUNKNOWN···CHRISTINA.MARTINEZ63@OUTLOOK.COM704 CENTRAL AVENUEMinneapolis·MN55423nullCORE-HMO
CLM CLM-4277882026-02-01T19:23:47Z·Emilly—Lane8/21/2002UHC-37845-55-UNKNOWN-6688 WASHINGTON ST #687GlendaleArizona85325—UNKNOWN
ENRENR-1360302026-04-23T16:02:42ZLAUREN—HOWELL··Nov 11, 1955UHC-02859-87——NULL5487 Meadow LnSacramentoCA95899GRP-9068MEDICARE-ADV-A
ENR ENR-1241162026-02-01T01:29:19Z·ASHLEYMNELSON1996-12-25UHC-79695-84··•••-••-8766955-478-1769—417 WILLOW COURTSEATTLEWA98129-9927GRP-7899CHOICE-PLUS-PPO··
CLMCLM-4110882026-02-18T12:45:36ZLoriZHawkins1990-02-28UHC-55156-14•••-••-4827UNKNOWNNULL590 Meadow LnTempeArizona85211-··null
ENRENR-1406512026-02-20T11:27:41ZKelly—Chapman01/12/1970uhc-53409-78UNKNOWN·(319) 444-2943·KELLY.CHAPMAN@GMAIL.COM3677 APACHE BLVDTampaFlorida33634GRP-8730OPTIONS-PPO
ENRENR-1260562026-10-14T20:44:08ZPayne, AlexanderU—4/3/2007UHC-40615-86•••-••-00742942080306alexander.payne78@aol.com241 RIDGE ROADTEMPEArizona85223·GRP-6992SELECT-EPO
ENRENR-1320672026-09-28T00:56:22ZJessicaB.Cox1982-09-27uhc-61058-29•••-••-8443825-712-6253-4717 Forest AveHoustonTX77091GRP-2364SELECT-EPO
CLMCLM-4085782026-02-22T10:19:14ZJoshua—Holmse1977-04-20UHC-28099-06•••-••-4569(719) 708-6582—2964 BAYSHORE DRMesaAZ85270GRP-9480null
ENRENR-1374292026-09-07T18:08:49ZVictoria—Hart1976-07-08UHC-02304-58•••-••-2750(810) 273-8134victoria.hart28@hotmail.com·NULLNULL——GRP-3621MEDICARE-ADV-B
PRVPRV-26093 2026-01-29T15:37:55ZZacahry—·Pena1950-06-06null-3799111696NULL6126 Mountain View DrGilbertAZ85251—UNKNOWN
PRVPRV-276352026-02-27T22:55:28ZKATHRYN···WARREN1959-03-12··UHC-71018-94UNKNOWN··(316) 713-6460KATHRYN.WARREN@AOL.COM6289 Jefferson Ave··LOS ANGELESCA90013——
PRVPRV-261642026-04-21T14:57:51ZAna—Gordon1985-02-13···N/AUNKNOWN(713) 469-9142—4498 WASHINGTON STREETColumbusOH43210NULL-
CLMCLM-4043962026-04-18T17:44:50Z·RYAN—ROJAS1967-03-17··UHC-73873-93··•••-••-52439157674523··3825 APACHE BOULEVARDSAN DIEGOCA92125-8161GRP-2161SELECT-EPO
ENRENR-1255032026-08-12T01:09:24ZJEFFREYTHALL1945-02-06UHC-39370-03•••-••-8756UNKNOWNjeffrey.hall@aol.com857 Forest AveMesaAZ85253GRP-2097OPTIONS-PPO
CLMCLM-4170842026-08-05T11:17:03ZRUSSELL—MATTHEWS28-12-1964UHC6879397··UNKNOWN·-—8711 UNION ST Apt 5SAN ANTONIOTexas··78245—-
TPATPA-631302026-02-20T05:09:40Z Noah—HudsonOct 6, 1970N/A——null8252 Washington StSacramentoCA95820N/A—
ENRENR-1065722026-07-07T12:53:34ZMarcus·QWad03-05-1951UHC-01655-80•••-••-930518878421034-8789 Park PlPlanoTexas··75059GRP-4277CORE-HMO
TPATPA-531142026-04-24T01:11:38ZVALENTINA—WHEELER·1944-03-26—null432-796-4908N/AUNKNOWNnullN/A——SELECT-EPO
ENRENR-1355882026-05-06T19:16:43ZJEFFREY—REID··1999-03-15UHC-36073-68•••-••-3899(615) 693-0640jeffrey.reid@icloud.com1420 LAKE VIEW ROADAUSTINTX78700GRP-3994MEDICARE-ADV-B
ENRENR-1423922026-04-16T02:10:51ZMills, Denise——Mar 24, 1982UHC-44700-43•••-••-76535672689715··DENISE.MILLS@YAHOO.COM1110 Grand AvenueAtlantaGA30389GRP-3763NAVIGATE-HMO
100,000 rows, page 180 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.713Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty