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-1410302026-08-02T08:57:11ZRaymondCFreeman·1953-01-23UHC-96816-88•••-••-9299482-364-8363raymond.freeman@icloud.com3667 Valley View DrTempeArizona85211GRP-6197NAVIGATE-HMO
ENRENR-1338012026-08-10T20:38:26ZJOSHUAV.RIOS1968-05-18UHC-07268-37•••-••-9041519-957-7640joshua.rios31@hotmail.com6349 Indian School Road Apt 35CHARLOTTENC28263GRP-6889OPTIONS-PPO
PRVPRV-216682026-04-19T17:41:28ZMATTHEWAFULLER··1986-01-08UHC-61724-23—nullmatthew.fuller67@hotmail.com3540 Apache BlvdAUSTINTX78704··N/A—
PRV PRV-221522026-05-25T14:05:47ZSara—Richardson2002-11-24—UNKNOWN5574408247SARA.RICHARDSON10@HOTMAIL.COM-——N/A—·N/A
ENRENR-1128512026-03-24T20:25:57ZCharlotte F.—Stevens1953-09-18UHC-53541-53•••-••-50717462708052charlotte.stevens13@gmail.com1313 Ridge RoadGilbert·AZ85247GRP-6305SELECT-EPO
ENRENR-124434 2026-05-17T21:59:19ZPRIYA····SANDOVAL1980-02-04UHC-19727-45··•••-••-63913099280704PRIYA.SANDOVAL@PROTON.ME5492 Jefferson AvenueChandlerAZ85237GRP-6267SELECT-EPO
ENRENR-1162152026-03-15T11:01:54ZCHARLOTTE··—LAWSON2/25/1952UHC-42796-35•••-••-5951836-201-0634CHARLOTTE.LAWSON@GMAIL.COM4101 RIVER RDFresnoCA93700GRP-7214CHOICE-PLUS-PPO
TPATPA-613842026-04-22T14:27:06ZRichard—Burke1947-04-17NULL—6136855808N/A7848 Central AvenueCHARLOTTENC28283-3638N/A··-
TPATPA-640762026-01-15T03:22:15ZMELISSA—MEDINADec 23, 1972null—NULLUNKNOWN670 Sage CtGlendale··AZ85359GRP-9478—
TPATPA-528642026-09-09T08:06:13ZGreene, George——Jan 17, 1953—null·UNKNOWN—2020 UNION STREETSeattleWA98198GRP-2094null
ENRENR-1230732026-07-19T08:52:52ZAUSTIN—GREEN1938-03-12UHC-95563-02•••-••-6991-austin.green@outlook.com676 River RoadScottsdaleAZ85281GRP-7176·MEDICARE-ADV-A
TPATPA-600712026-04-27T01:19:58ZSean—Ray1970-02-01—NULL574.545.2514·sean.ray78@outlook.com8684 Desert Sky BoulevardCOLUMBUSOH43224UNKNOWNMEDICARE-ADV-B
TPA TPA-64006 2026-08-18T15:08:35Zwilliam—vargas1981-12-28—UNKNOWN527-442-1061WILLIAM.VARGAS55@OUTLOOK.COM24 Forest AveGilbertAZ85207—MEDICARE-ADV-B
ENR ENR-1096722026-08-15T00:00:33ZJuanM.··Pena1994-04-26UHC-44287-88•••-••-96153054839241JUAN.PENA@OUTLOOK.COM1149 Oak StMesaAZ85242GRP-1318··CHOICE-PLUS-PPO
TPATPA-588852026-06-03T01:53:51ZWei—Griffin7/13/1983null····nullWEI.GRIFFIN@HOTMAIL.COM6937 UNION ST·Houston·TX77001GRP-9904UNKNOWN
ENRENR-1256182026-04-23T10:37:36Z·Willie—Garcia1939-05-09··UHC-41138-39•••-••-05335952969080—2073 Church StSacramentoCA95855GRP-3309··SELECT-EPO
CLM CLM-4304332026-04-20T14:34:05ZJoan—Mdeina1968-02-10—•••-••-8635NULL··JOAN.MEDINA@HOTMAIL.COM4462 OAK STOrlandoFL32890-5711GRP-1695MEDICARE-ADV-B
ENRENR-1285122026-07-09T19:56:01ZHANNAH—BROOKS1990-02-06UHC-39010-28•••-••-6969633-823-4325HANNAH.BROOKS@HOTMAIL.COM137 Harbor BoulevardSan DiegoCA92168GRP-5107CORE-HMO
CLMCLM-4279412026-05-12T03:25:21ZChristine—Carroll1964-07-11UHC-73179-44-UNKNOWN-327 Sage CourtMesaAZ85231GRP-9136CORE-HMO
PRVPRV-242022026-08-13T16:29:32ZTylerM.Woods20-04-1982UHC-14817-37·UNKNOWNN/AUNKNOWN7877 Ridge RoadHoustonTXnull—NULL
ENRENR-1373262026-08-02T18:19:16ZMATEOC.PARK04/13/2001UHC-21681-06•••-••-2832874-354-7087mateo.park@icloud.com5295 RIVER ROADDenverCO80259·GRP-4340CHOICE-PLUS-PPO
ENRENR-1161062026-01-04T03:25:37ZMatthews··Ahmed1947-05-11UHC-67757-69•••-••-5769—·ahmed.matthews@proton.me2473 OAK STTAMPAFLNULLGRP-8118CORE-HMO
ENRENR-1392132026-08-26T12:05:26ZChen, Joe——1947-11-23UHC-65483-46•••-••-7206271-484-2503—3130 Camelback RoadEden PrairieMinnesota55358GRP-0476SELECT-EPO
ENRENR-1193992026-02-01T03:09:41Z ·nathanT.watkins19820926UHC-78419-09•••-••-8779(856) 379-0874nathan.watkins60@hotmail.com7109 CENTRAL AVEPhoenixAZ85034GRP-8228SELECT-EPO
CLMCLM-4019962026-06-08T00:09:02ZMarcus—Bennett1950-06-07UHC-69159-18—574-374-6773marcus.bennett76@outlook.com—UNKNOWN—null-OPTIONS-PPO
ENRENR-1042722026-03-03T21:27:26ZARTHURMHALL11/24/1938UHC8761137·-2655323170ARTHUR.HALL@YAHOO.COM6568 Cedar LnChandlerArizona··85245GRP-8109OPTIONS-PPO
ENRENR-1098702026-05-14T03:35:21ZALICEL.YANG1997-02-18UHC-22171-25··•••-••-845012207826753alice.yang@outlook.com··3250 Forest Ave #936SacramentoCA95866GRP-4470·CORE-HMO
PRVPRV-223042026-06-11T21:51:53ZDavid··—Marshall2008-01-19NULL-430.314.1225—·N/A———NULLSELECT-EPO
PRVPRV-207752026-09-22T00:55:57Zterry—elliott1980-07-19UHC-19456-25NULL16812696009··N/A610 OAK STREETDallas··TX75226-3526——
TPATPA-605422026-04-09T21:44:18ZTYLER—EDWARDS1988-03-04NULL•••-••-24798425081422TYLER.EDWARDS20@HOTMAIL.COM8005 Church StreetLos AngelesCAUNKNOWNGRP-6863—
TPATPA-549072026-10-15T18:31:16ZmarkP.kennedy2004-06-24—N/Anull—8236 Main StreetJacksonville··FL32202NULLMEDICARE-ADV-A
TPATPA-610692026-02-16T23:53:47Zscott—knightApr 1, 1964—NULLUNKNOWN—5464 Oak StMiamiFL33131NULLNULL
CLMCLM-4163862026-03-17T00:54:47ZJanice—Carlson1973-10-08—•••-••-2128NULL—5916 Hillcrest RdSan AntonioTX··78288GRP-6806—
CLMCLM-4077952026-03-20T19:41:54ZZachary—Aguilar1944-03-27·null··396-415-1017··6999 Palm DrJacksonvilleFLUNKNOWNGRP-2660UNKNOWN
CLMCLM-4128452026-03-30T23:06:17Zjerry····romero03/24/1964UHC-98312-99•••-••-6540·-null855 Lake View Road Apt 2TUCSONaz85786GRP-5539N/A
CLMCLM-4041522026-06-21T09:58:45ZOLIVIA—FOX1976-01-11UHC-47212-39N/A··(777) 831-4682—1864 Market StreetAustinTX78750—·-
ENRENR-1278342026-08-12T15:53:17ZMichelle··R··Price08/09/83UHC-08987-60null+1 962 400 8270null5625 PINE DRGlendaleArizona85359GRP-6200CORE-HMO
CLMCLM-4057122026-10-14T06:20:39ZLIS—RICHARDSON10-06-1990UHC-29830-20•••-••-9983UNKNOWNN/A7253 ELM STREET #117··Los AngelesCalifornia90080GRP-3579MEDICARE-ADV-B
CLMCLM-4235522026-01-10T12:42:53ZDoris—Castillo1982-09-17—NULL910.274.5382··—9025 Highland Avenue··Columbus··OH43264·GRP-1494CORE-HMO
TPATPA-531742026-06-09T13:54:50ZMarilynDColeman1958-03-25UNKNOWN—13624793359··—1474 Mountain View DrGlendaleAZ85341—N/A
ENRENR-1233152026-01-22T12:51:53Z CamilaNAndrews1983-02-08·UHC-90086-43•••-••-37506097465CAMILA.ANDREWS91@GMAIL.COM6518 Mesa DrHoustonTX77024GRP-0695NAVIGATE-HMO
CLMCLM-4113932026-06-06T02:59:17ZJordan, Lori——1985-05-24UHC-12979-70NULL7214927607··3367 Ocean AveMESAArizona85209GRP-3687—
CLMCLM-4161972026-04-09T19:50:10ZJUSTIN—JENKINS1957-12-15··—N/AN/AUNKNOWN9632 Palm Dr··ScottsdaleAZnullGRP-0830—
PRVPRV-202472026-08-28T22:01:13ZLaurraASullivan1974-11-11—•••-••-633316567179083··—1021 Highland AvenueAtlantaGeorgia30378-N/A··
ENR ENR-1332662026-04-06T17:34:25ZSharonB.Watson1967-08-23UHC-84466-70•••-••-98833796979011SHARON.WATSON@YAHOO.COM6446 MAIN STDallasTX75297GRP-9223MEDICARE-ADV-B
ENRENR-1201012026-02-03T03:31:32ZDORIS—LEE··Mar 7, 1970·UHC2922543-4115754918doris.lee@proton.me5764 Lake View RoadCharlotteNC28211GRP-9815OPTIONS-PPO
TPATPA-554052026-09-22T00:01:52ZJeremy—Alvarado1991-12-01—•••-••-01735136052825·-8217 Spring StAustinTX——MEDICARE-ADV-B
TPATPA-502302026-01-17T12:25:24ZGeorge—Nichols08/10/1992-•••-••-1319—george.nichols91@aol.com6925 Harbor BoulevardColumbusOH43234GRP-8811SELECT-EPO
CLMCLM-4199502026-02-07T06:04:03Z evelynL.le1993-12-09··uhc-70727-05N/A-—1620 Central AveGlendaleAZ85349NULL—
CLMCLM-4096862026-05-27T06:04:40ZIsabellaFSandoval19600925UHC-55384-75•••-••-2087UNKNOWN—3929 Mountain View DriveLos AngelesCalifornia90073··—MEDICARE-ADV-B
100,000 rows, page 162 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.705Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty