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-1222912026-01-06T15:24:31ZMei—Kelly04/03/2007UHC-06073-29•••-••-9081(365) 373-3135mei.kelly24@proton.me5712 Pine Dr Apt 16Los Angeles·CA90069GRP-4620CHOICE-PLUS-PPO
ENRENR-1070292026-05-09T21:33:42ZRonaldY.James2006-09-11UHC-93023-09•••-••-89092271480ronald.james72@aol.com7332 Spring StreetPlano··TX75019GRP-9708SELECT-EPO
CLMCLM-4170442026-05-22T21:21:04ZThomas—Foster05/26/1999UHC-99921-94——null··369 OCEAN AVE···DenverCO80260GRP-6029NULL
ENRENR-1122272026-06-25T22:35:12Zkyle—weebb1991-06-22UHC-73310-75•••-••-5439·809-696-7715kyle.webb7@icloud.com3288 LAKE VIEW ROADMesaAZ85270GRP-8844MEDICARE-ADV-A
ENRENR-1107332026-03-12T05:37:59ZPaulRKelley01/07/70UHC-52485-37•••-••-2032860.671.6045·paul.kelley@outlook.com3925 Hillcrest Rd #518JacksonvilleFLNULLGRP-0946SELECT-EPO
TPATPA-634882026-07-08T13:41:54Zrachel—griffin1997-03-14—•••-••-9792595-987-5403NULL8748 Hillcrest RoadAtlantaGeorgia30390null—
ENRENR-1096622026-02-14T03:29:56ZAlvarez, Bruce——20090625··UHC-37901-97•••-••-99235866137515bruce.alvarez87@hotmail.com1038 Union StMesaAZ85205GRP-5555CORE-HMO
ENRENR-1248382026-06-05T23:57:37Z·JOEYPWEBB2008-01-15UHC-44238-24•••-••-8242902-250-5861joseph.webb@outlook.com838 Washington Street #194MinneapolisMN55477GRP-0298NAVIGATE-HMO
ENRENR-1107692026-03-26T08:17:18ZBillyIWelch2/8/2008uhc-84428-82•••-••-3023588-807-9051null1255 Spring StTucsonAZ·85721GRP-3552SELECT-EPO
ENRENR-1405472026-10-04T17:14:30Zstephen—padilla1952-08-02UHC-99631-53•••-••-9108+1 553 567 3589stephen.padilla@proton.me2032 Lincoln WayLas VegasNV89164GRP-1359CORE-HMO
CLMCLM-4005702026-01-21T13:10:11ZMaosn—Gonzalez12/23/1962UHC-48888-88·N/AN/A-7688 Valley View DriveMinneapolisMN55413GRP-6270—
CLMCLM-4104152026-08-02T07:13:53ZTheresa··Foster1965-09-06NULLNULLN/A—8878 Lincoln WaySan AntonioTX78209GRP-3916··
ENRENR-1076442026-09-08T17:25:43ZCarolyn—Lunna1947-05-20UHC-73667-01•••-••-53604088207898carolyn.luna@yahoo.com—-null—GRP-1217CORE-HMO
CLMCLM-4210162026-09-30T23:49:53ZRussell—Espinoza1980-02-28nullnull9436534566nullNULL-——-null
CLMCLM-4203472026-03-28T22:06:48Z ·Vega, Mateo——1939-06-18null—833.471.7898——NULL··——CORE-HMO··
PRVPRV-235582026-01-10T09:38:21ZSOPHIA—MURPHY··1975-06-15——4433302133····7694 Pine DriveGlendaleaz85314—UNKNOWN
ENRENR-1241722026-07-31T12:18:58Z Robisnon, Bobby——NULLUHC3641787•••-••-4556+1 275 821 6491BOBBY.ROBINSON65@PROTON.ME7600 Bayshore DriveEDEN PRAIRIE··MN55399GRP-7564MEDICARE-ADV-B
CLMCLM-428177 2026-01-05T12:10:46ZJerry—Mendez6/22/1963·NULLnull—UNKNOWN5505 Canyon RoadLas VegasNV89199—·MEDICARE-ADV-B
ENRENR-1209582026-09-20T15:29:38ZJORDANY.YOUNG12/19/06UHC1124309•••-••-013212956700581jordan.young@icloud.com4637 Highland AveFresnoCA93791GRP-8513NAVIGATE-HMO
CLMCLM-4035552026-02-10T17:07:14ZMARILYN—ELLIOTT2008-05-15UNKNOWNNULL(212) 878-3719MARILYN.ELLIOTT@ICLOUD.COM1704 UNION STREETAtlantaGA30342GRP-6960NULL
ENRENR-1226552026-06-04T07:37:00ZHannah—Lucas1986-12-09UHC-54951-70•••-••-779717145655361HANNAH.LUCAS@GMAIL.COM9358 Mountain View DrPlanoTX75067··GRP-3393MEDICARE-ADV-B
ENRENR-1352152026-03-17T22:35:48ZWood, Ethan··——07-02-1996UHC-49596-34•••-••-7606(504) 577-5803—7948 Main Street·CHARLOTTENC28249GRP-9695NAVIGATE-HMO
TPATPA-523472026-05-07T09:41:56ZSantiago··Gardner1988-07-05UHC-96725-82null622-251-6731—628 OAK STREETSan AntonioTX78217nullOPTIONS-PPO
ENRENR-1085582026-05-31T02:57:27ZMyers, Greg——·1963-03-11UHC-56955-74•••-••-0574(416) 516-8613gregory.myers48@outlook.com·5794 Lincoln WayFresnoCA93777GRP-5121SELECT-EPO
ENRENR-1294112026-09-02T14:32:23Z·Kayyla—Carroll2000-10-24UHC-38077-37-—-·8138 Canyon RoadTempeAZ85298GRP-5031NAVIGATE-HMO
CLMCLM-412768 2026-01-08T13:23:51ZSUSAN—CUNNINGHAM1972-05-03UHC-54309-49•••-••-2841N/A··—1351 Baseline RdGilbertArizona85266GRP-6205MEDICARE-ADV-B
CLMCLM-4010722026-06-13T01:50:07Zchristian—marshall1949-12-23UHC-23971-08-——····UNKNOWN—-—OPTIONS-PPO
ENRENR-1312562026-04-14T02:32:31Z·CAROLIRIELY1995-12-18UHC-60140-26•••-••-3580270.686.5980carol.riley72@outlook.com6128 Main StreetTampaFL33627GRP-7443CORE-HMO
TPATPA-512822026-10-18T06:34:46ZPATRICIA—DELGADO1969-11-05····-nullUNKNOWN4110 Hillcrest Rd··TampaFL33667GRP-4400UNKNOWN
CLMCLM-4225182026-07-16T16:37:25ZAlice—Bishop12/09/1969—•••-••-5414675-350-9647—3124 MAIN STNASHVILLETN37225UNKNOWN···NULL
CLMCLM-4225362026-04-14T07:38:45ZMATEOTGOMEZOct 2, 1973UHC-94373-83•••-••-0423——607 Grand AveLAS VEGASNV89143GRP-3141MEDICARE-ADV-A
ENRENR-1380082026-07-09T00:19:06ZdonaldQ.santiago11/04/1962UHC-92432-89UNKNOWN··(939) 627-9118donald.santiago11@hotmail.com7104 LAKE VIEW RDGilbertAZ··85225GRP-8650SELECT-EPO
ENRENR-1250952026-03-21T01:02:18ZAbigailV.Marshall1982-04-17UHC-99816-10•••-••-815217277331794UNKNOWN1792 BROADWAYMinneapolisMN55477GRP-2552CORE-HMO
CLMCLM-4170772026-03-28T14:47:50ZBILLY—GRIFFIN1986-06-20UHC-51997-76•••-••-11979124540129—1134 Valley View DrHOUSTONTX··77016—null
CLMCLM-4292702026-07-04T02:08:03ZAmandaQDay2003-05-12····•••-••-9212—null··NULL—··GRP-5576UNKNOWN
CLMCLM-4107822026-09-09T12:29:07ZJUAN—·HART·1970-04-08UHC-11791-07··•••-••-9124(921) 351-3526·JUAN.HART@HOTMAIL.COM3203 MEADOW LNJACKSONVILLEFL32257——
PRVPRV-222142026-01-16T01:51:27ZLEE—JULIE6/28/1985UHC-59108-59·N/A—JULIE.LEE54@YAHOO.COM7238 Main StreetTucsonAZ85743null-
ENRENR-1073542026-08-26T21:51:04ZCatherine—Hudson2001-05-05UHC-76200-83NULL(597) 810-3544catherine.hudson65@hotmail.com370 Harbor Boulevard Apt 12MIAMIFL··33129-4079GRP-3391CHOICE-PLUS-PPO
CLMCLM-4074112026-04-19T03:04:24Z CAROLYN—JIMENEZ1947-10-28UHC-43087-38——N/A3589 Pine DrColumbusOH43242UNKNOWN—
ENRENR-1110462026-03-07T14:26:52Z·donna·W.ferguson19521117UHC-64369-08•••-••-8063252-627-9130donna.ferguson14@yahoo.com6244 Hillcrest RdNASHVILLE·TN—GRP-9838··MEDICARE-ADV-A
CLMCLM-4085792026-01-02T16:04:22ZJoshua—HolmesApr 20, 1977UHC-28099-06•••-••-4569—NULL·-UNKNOWNNULLN/AGRP-9480NAVIGATE-HMO
CLMCLM-4077682026-01-29T16:25:07ZBlack, Glora—··1994-12-14null··UNKNOWN794-804-5970GLORIA.BLACK16@HOTMAIL.COMnull·nullN/AnullGRP-1834NAVIGATE-HMO
CLMCLM-4059542026-03-10T07:25:00ZEUGENE—CARLSONAug 18, 1993UHC-73643-65NULL4763169237···7646 Ridge RoadPhoenixAZ·85051UNKNOWNCHOICE-PLUS-PPO
TPATPA-574662026-03-09T15:49:43ZAlexanderH·Gray1940-05-01N/A—-null9441 Willow CourtMINNEAPOLISMN··55455GRP-3053SELECT-EPO
ENRENR-1427192026-05-16T07:35:24ZCARLOSG.RUIZ1986-04-23UHC-41194-02•••-••-30758483815644carlos.ruiz60@hotmail.com4033 Maple AveGlendaleArizona85316GRP-1656OPTIONS-PPO
ENRENR-1423772026-04-18T17:55:24Z·TERESA—REED1974-06-13UHC-91743-86•••-••-591917837657538teresa.reed@icloud.com2181 Main Street·Las VegasNV89144GRP-6849MEDICARE-ADV-B
PRVPRV-224302026-02-02T15:20:48ZJack—Martinez2006-09-24UHC-79485-18—15069828781—5313 Forest Ave·MinneapolisMN55403——
TPATPA-533532026-02-15T01:58:01ZGraham, Emma··—1978-09-13N/A—null—6542 Central AvenueGlendaleAZ85306null—
PRVPRV-202612026-02-07T14:18:29ZMORRISON—DONALD11/26/1970UHC-52599-41-8265790735—6285 Park PlDenverCOUNKNOWN····UNKNOWN
ENRENR-1346122026-03-29T12:53:19ZCheryl—Alvarez·1/25/1938UHC0515116•••-••-4643——9105 Baseline RdOrlandoFL32875GRP-9676MEDICARE-ADV-B
100,000 rows, page 205 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.723Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty