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

Third-party administrator only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
TPATPA-549912026-07-01T15:45:34ZALEXANDER—RAY06-05-1996··UHC-31410-22•••-••-8359668-369-0258—5159 Ridge RoadTampaFL——CHOICE-PLUS-PPO··
TPATPA-505162026-03-28T03:34:43ZFatima—Davis1997-04-15—•••-••-2824—·NULL35 CEDAR LANEChandlerAZ85259UNKNOWNSELECT-EPO
TPATPA-563412026-07-16T00:09:24ZARJUN—ARNOLD1960-06-05UHC-91721-44null-N/A9660 BroadwayOrlandoFlorida—nullCHOICE-PLUS-PPO
TPATPA-507972026-07-04T23:35:55ZKYLE—LI·10-03-1966UHC-58094-35•••-••-0187nullUNKNOWN··7657 Elm St #388AustinTX78774——
TPATPA-632932026-07-10T12:39:42ZCarlos—Boyd1983-03-26N/A•••-••-5750-··—7880 Apache BoulevardDenver···CO80226··NULLN/A
TPATPA-592702026-08-08T09:16:57ZElizabeth····Dean12-06-1989-—(693) 504-7284null4310 CHURCH STREETAustinTX78747N/AN/A
TPATPA-559412026-05-08T14:21:02ZScott—Fuller1965-02-05NULL—807-672-7536-·7273 MOUNTAIN VIEW DR #675MiamiFL33115nullUNKNOWN
TPATPA-620072026-09-09T17:11:03ZCynthia—Alvarez1974-04-15——5878402408NULLNULL-—UNKNOWNGRP-1294-
TPATPA-58472 2026-10-09T04:14:35ZCYNTHIA—LOPEZ2003-11-17null——CYNTHIA.LOPEZ@AOL.COM4377 WASHINGTON STREETAUSTINTX78715-8648··GRP-3336OPTIONS-PPO
TPATPA-573092026-03-11T12:08:52ZRachel—·Johnston2005-08-26UHC-09885-88—19258171640—9518 Jefferson AveScottsdaleAZ85278nullNAVIGATE-HMO
TPATPA-632862026-02-08T17:25:24ZJASON—SMITH1972-06-13—UNKNOWNN/A···NULL6480 River Rd·GlendaleAZ85315··UNKNOWNNAVIGATE-HMO
TPATPA-627422026-05-07T22:26:33ZGrace··Rios12/04/40UHC-55558-64—7071813-2070 Ridge RoadSeattleWA·-—MEDICARE-ADV-A
TPATPA-644152026-05-13T19:01:14Z Teresa—Howell10/7/1959nullN/Anull····6315 OAK STAustinTX78713UNKNOWN—
TPATPA-573422026-05-03T11:22:09Zdanielle—hill1995-12-09NULL—N/ADANIELLE.HILL@PROTON.ME1649 Desert Sky BoulevardORLANDOFL32812GRP-2801··MEDICARE-ADV-B
TPATPA-531512026-06-21T23:42:39ZRalph—Perry19791208·UHC-71340-83——NULL9310 LAKE VIEW RD·JacksonvilleFL32247GRP-3677null
TPATPA-627102026-05-16T21:52:16Zpriya—phillips6/3/1984—•••-••-4745NULLPRIYA.PHILLIPS26@ICLOUD.COM·1868 Hillcrest RoadMIAMIFLnullGRP-6437—
TPATPA-60867 2026-05-12T21:12:54ZDoorthy—Fox19601015UHC-34920-65—5793449713dorothy.fox@icloud.com—UNKNOWN——NULL—
TPATPA-569022026-01-06T04:58:03ZPamela—Lucas1941-05-22··-N/AUNKNOWN—1250 CHURCH STMesaAZ85275—NAVIGATE-HMO
TPATPA-505072026-03-09T21:39:01ZSARA—GUZMAN06/21/58UNKNOWN-nullsara.guzman@gmail.com3218 Hillcrest RdEden Prairie··MN55354GRP-9282NULL
TPATPA-579562026-07-04T11:26:26ZLinda—LucasNULLUHC-20791-83•••-••-7169400-271-1136···UNKNOWN6009 Bayshore DrEden PrairieMN55326N/A—
TPATPA-570232026-05-30T09:55:02ZEugene—Bailey1968-02-11——(526) 447-2913-—-·UNKNOWNnullUNKNOWNUNKNOWN
TPATPA-562942026-09-28T23:03:31ZArjun—Wells1957-11-04N/A··NULL—arjun.wells45@proton.me8956 Desert Sky BoulevardSan DiegoCAnull··GRP-0526—
TPATPA-629432026-04-22T07:47:42Z·KyleALane1981-11-07UHC-74857-31•••-••-6635null—9320 Willow Court #758··Dallastx75209nullNULL
TPATPA-634332026-02-18T02:59:48ZBRADLEYFLARRSON19601116—•••-••-8104-··-9556 Maple AvenuePhoenixAZ85057GRP-6254-
TPATPA-503872026-07-05T03:54:19ZSTEPHEN—MORALES1961-03-24—•••-••-5064·9183796476—5118 Grand Ave·Los AngelesCA90075GRP-4755null
TPATPA-641172026-03-22T01:30:42ZKAREN··—SPENCER12/21/1969—•••-••-47825698106—1338 CEDAR LNPhoenixAZ85004-—
TPATPA-610132026-06-25T17:54:47ZDENISE—ALEXANDER1954-06-06—•••-••-82854085520921—8510 Central AveMiamiFL33121UNKNOWNN/A
TPATPA-548052026-03-31T22:25:36ZCHARLOTTE—LEE1938-01-07NULLUNKNOWN--1687 Maple AveColumbusOH43216-3709null—
TPATPA-504732026-08-29T14:41:19ZBilly—Le1997-10-17UHC-14949-45——billy.le30@proton.me7834 SAGE COURT··MesaAZ85225-null
TPATPA-568272026-05-12T02:53:47ZsamuelEkelley1969-12-07nullUNKNOWNNULL·null9612 Spring StOrlandoFL32857nullCORE-HMO
TPATPA-630992026-08-08T22:09:41ZJennifer—Shaw··12/17/1998null-17753629460jennifer.shaw@proton.me——-N/A-SELECT-EPO
TPA TPA-568312026-03-19T04:20:33ZRalph—Knight··10/18/1949NULL-nullralph.knight20@gmail.com9517 MAPLE AVENUEDenver·CO80230GRP-8600N/A
TPATPA-518192026-07-05T17:57:06ZGarrett, WilliamN.—Dec 1, 1993UHC-62739-05•••-••-1944631-843-1022NULL5433 OAK STSan AntonioTX78260UNKNOWN-
TPATPA-597352026-07-18T21:38:32ZDoris—Peters26-03-1977—····679.696.2488NULL2727 Lincoln WayDallasTX75283—MEDICARE-ADV-A
TPATPA-61097 2026-06-13T22:15:29ZLawson, Amber——1989-08-18N/A—N/Aamber.lawson@aol.com6226 Indian School RoadOrlandofl32872-3011GRP-7005MEDICARE-ADV-A
TPATPA-577422026-04-19T18:48:37Z·dennis—parker03-05-1972N/A•••-••-0834null·UNKNOWNN/A——UNKNOWNUNKNOWN—
TPATPA-550102026-08-03T13:23:54ZJACOB—KELLY1990-05-14N/A•••-••-8996nulljacob.kelly@gmail.com9005 Hillcrest RoadAustinTX78705·nullOPTIONS-PPO
TPATPA-568722026-09-25T07:24:13ZSamantha—·Coleman06-01-1974N/A•••-••-46378233136294UNKNOWN8594 Pine DrDallasTX—GRP-9583N/A
TPATPA-567332026-07-29T07:33:29ZRaymond—Hansen·1966-09-17-··•••-••-3350null—4381 Palm DrSan DiegoCaliforniaN/ANULLMEDICARE-ADV-B
TPATPA-523722026-04-08T14:22:17ZElijah—Tran2008-03-05null—(600) 569-7813ELIJAH.TRAN@YAHOO.COM5797 Elm StSan AntonioTexas——-··
TPATPA-538942026-01-29T22:13:52ZBenjamin—Rivera1938-09-23—•••-••-8847·+1 463 905 7281—2529 Cedar LaneSan DiegoCalifornia92195-2324NULL—
TPA TPA-531322026-06-06T03:05:00ZIsabellaLDavis1976-08-21UNKNOWNUNKNOWN-—3286 Bayshore Drive #449AtlantaGA30333——
TPATPA-557052026-10-18T07:04:39ZGREGORY—SCHULZFeb 25, 1969UHC-14832-94NULL—gregory.schultz46@icloud.com——NULLnullGRP-5139UNKNOWN
TPATPA-574592026-07-07T18:54:16ZBILLY—RUIZ1994-10-09-N/A—NULL4316 BroadwayLOS ANGELESCA90030GRP-2294CHOICE-PLUS-PPO
TPATPA-563242026-04-21T20:57:16ZLuis—Miller1998-03-25—•••-••-7930—null6417 APACHE BOULEVARDFRESNOCA93795GRP-2163null
TPATPA-635752026-01-09T23:47:44ZPaul—Henderson·1981-12-19NULL——paul.henderson80@outlook.com666 HIGHLAND AVEAustintx78739—-
TPATPA-587402026-04-16T09:53:06ZLawrenceUSmith1964-03-19UHC2268539—888.965.5008LAWRENCE.SMITH@GMAIL.COM259 Central AveOrlandoFlorida32877·GRP-2541NULL
TPATPA-518872026-02-15T04:16:11ZCATHERINE··RICHARDSON·1988-01-10-UNKNOWN14248223146catherine.richardson42@proton.me4471 Elm St #799SEATTLEWA98189——
TPATPA-543922026-09-17T18:35:45ZBETTY—ELLIS10/26/99—•••-••-6204—-8398 Market StMinneapolisMN55437—NULL
TPATPA-577562026-04-06T16:13:32ZMariana····MrenoJan 12, 1964UHC-30139-49UNKNOWN907-854-6397—2366 Apache BlvdJacksonvilleFlorida32269nullMEDICARE-ADV-A
14,474 rows, page 237 of 290PreviousNext

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:43:00.202Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty