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-635892026-06-18T05:46:54ZCynthia—George1980-06-14····--cynthia.george@proton.me8732 SUNSET BLVDMiamiFL33165—N/A
TPATPA-520532026-10-09T18:25:37ZmatthewJ.reid1952-03-09-•••-••-0918UNKNOWNnull6808 Highland Avenue··SeattleWA··98128——
TPATPA-542322026-03-10T03:31:17ZYUKI—LYNCH06/01/63——null—5354 CENTRAL AVEDENVERCO-nullUNKNOWN
TPATPA-639592026-02-04T11:39:33Z·Grace—Williamson09/17/1997——null—9267 MESA DRIVEMiamiFL33131nullUNKNOWN
TPATPA-618412026-01-29T04:22:42ZRyan—·Henry19970208uhc-30848-72•••-••-9250·NULLnull5813 GRAND AVEDALLASTX75225GRP-5062NAVIGATE-HMO
TPATPA-541962026-03-25T04:00:03ZAndrea—Fuller11-06-1997N/A•••-••-2044+1 393 673 4561—5434 MAPLE AVEMinneapolisMN55427N/A—
TPATPA-623462026-07-21T04:49:09ZArthur····Kelley10/01/08-—····UNKNOWN7852 Union StCharlotteNC28253-7480nullOPTIONS-PPO
TPATPA-508072026-05-26T22:06:45ZMadison··—Greene03/25/1958—•••-••-076712765843345—6827 Ridge RdJacksonvilleFL32217N/A—
TPATPA-548342026-09-27T15:47:45Z Fatima—·Collins1999-12-24-•••-••-43776343053581UNKNOWN9073 LINCOLN WAYDENVERColorado80205GRP-2026UNKNOWN
TPATPA-603522026-01-31T13:08:48ZDeborahAHoffman19551220UNKNOWN•••-••-4117——551 SPRING STREETChandlerAZ85202—-
TPATPA-537242026-01-02T17:39:38ZThomas—Bryant··Apr 5, 2004UHC-39628-85NULLNULL-7941 Desert Sky BlvdTampaFlorida·33659GRP-6321CORE-HMO
TPATPA-530782026-05-16T03:32:07ZJesse—Hudson2108-19-37—null18006928238UNKNOWN7065 Lincoln WayLos AngelesCA90025nullnull
TPATPA-563532026-02-14T08:38:50ZBrooks—Valentina1954-12-15UHC-68658-61—8015204532-45 Hillcrest RoadMinneapolisMinnesota55434NULLOPTIONS-PPO
TPATPA-626772026-07-04T12:10:35ZVincent··Jordan03/11/80··NULLN/AN/A—-—NULL—GRP-9809NULL
TPA TPA-506242026-09-09T06:13:56ZSOFIA—PADILLA2007-03-04—-(248) 762-3563—5934 Elm StGilbertAZ85218GRP-0772—
TPATPA-563002026-05-08T20:34:46Z·BETTY—PENA1953-10-03-•••-••-5550—····8194 Maple AvenueNashvilleTennessee37272—·null
TPATPA-615602026-04-07T11:08:45ZDonald—Kennedy2005-08-27UNKNOWN—+1 526 875 6149null2438 GRAND AVEAUSTINTX·78758-—
TPATPA-642782026-09-15T07:28:32ZCharles—Nunez25-05-1953··N/Anull—charles.nunez@gmail.com1663 Mesa Drive··Seattle··WAUNKNOWNUNKNOWN—
TPATPA-592642026-05-20T10:31:21Zjerry··Rgarrett··1970-04-05—•••-••-11504065040895-4320 VALLEY VIEW DRIVE #252OrlandoFL32861N/AN/A
TPATPA-513432026-03-22T20:05:46ZFatima····Jones1965-05-13—•••-••-2305NULLUNKNOWN8055 Harbor Boulevard #778SeattleWA98167GRP-7206CORE-HMO
TPATPA-595282026-08-15T01:26:33ZPaul—·Bryant1/19/1975UNKNOWNnullNULL—7916 Meadow LaneDENVERCO80236—select-epo
TPATPA-512222026-01-05T04:32:20ZJANET·····HARVEY1964-07-22—·UNKNOWN(870) 668-2954janet.harvey67@outlook.com7746 PALM DRTUCSON··AZ85708GRP-6655—
TPATPA-620572026-04-01T13:08:51ZSantyago—·Gardner2002-05-23UHC-38477-59—597-460-3565—1820 SPRING STREET··Las Vegas·NV89113NULL—
TPATPA-592042026-03-04T02:26:22Z RUSSELLGBELL2006-00-42···UHC-91116-58UNKNOWN(298) 796-8758·UNKNOWN2688 JEFFERSON AVEATLANTA··GA30380—SELECT-EPO
TPATPA-601462026-04-16T20:43:52ZMichelle—Gordon··1948-04-16UHC-80137-39··N/A(688) 429-3271michelle.gordon48@icloud.com470 VALLEY VIEW DRHouston··TX77049-NULL
TPATPA-640982026-01-17T21:34:17ZJohnTSnyder1971-02-14··UNKNOWN———3129 DESERT SKY BLVDAustinTX78787UNKNOWN··CORE-HMO
TPATPA-58540 2026-04-25T15:32:09ZVictoria··—Ellis1988-06-14—•••-••-6767··victoria.ellis@yahoo.com2315 Market StLas VegasNV··89118··NULLN/A
TPATPA-632982026-01-08T22:36:36ZMegn—Hawkins05/16/1951-•••-••-7268—····667 River RdSacramentoCA95812GRP-7582—
TPATPA-514512026-07-26T08:10:04ZAna—Santos1940-10-17—N/A·15909973736UNKNOWN7064 Indian School Rd·TucsonAZ85779—SELECT-EPO
TPATPA-634792026-01-27T12:40:35Zandrea—dean10/02/1939—UNKNOWN(258) 749-8256null1987 Meadow Lane·TempeAZ85201—MEDICARE-ADV-A
TPATPA-557042026-10-16T18:07:11ZARJUN—OWENS08-06-1962UNKNOWNN/A——7641 BroadwayEden PrairieMN55380null-
TPATPA-532432026-02-01T10:19:27ZJeremy··—Nichols1978-04-27UHC3670386NULL··UNKNOWN··NULL—·UNKNOWN—NULL—CORE-HMO
TPATPA-525282026-01-16T10:00:10ZLauren—Henry1/25/1957UHC-78612-29•••-••-2310UNKNOWN———null—null-
TPATPA-621202026-09-29T07:20:38ZGregory··—Santos11/21/1984—NULL·+1 436 662 4051-null—UNKNOWNnullGRP-1593MEDICARE-ADV-A
TPATPA-584272026-09-23T04:28:06ZJOAN—TAYLOR1970-01-11·N/A•••-••-0790825-974-9480—320 Apache BoulevardScottsdaleAZ85294··NULLN/A
TPATPA-543662026-10-10T21:33:03ZSTEPHEN—MCCOY1976-03-10NULL•••-••-8472NULLNULL8878 Market StreetScottsdaleAZ85260——
TPATPA-623412026-01-16T00:10:48ZDianeA.Stephens··1965-11-18-•••-••-8332(240) 578-8523diane.stephens@proton.me6459 Grand Ave··PhoenixAZN/A—UNKNOWN
TPATPA-607442026-10-12T03:28:36ZJacqueline—Lewis19780516·NULL—·N/A-9882 Sage CourtSan DiegoCA92163·GRP-2675UNKNOWN
TPATPA-584422026-08-10T01:23:20ZANDREA—SCHULTZ1976-02-22null•••-••-1449-NULL7705 Valley View DrMiamiFL33111GRP-0786CHOICE-PLUS-PPO
TPATPA-594912026-03-04T04:12:18ZDiana—Webb·1967-05-27N/A——diana.webb@icloud.com5776 Oak StreetScottsdaleAZ85244UNKNOWNUNKNOWN
TPATPA-616022026-10-15T12:44:46ZJudith—Valdez1996-03-09··-N/A(383) 615-9533—6196 Baseline RdSAN DIEGOCA92157nullNAVIGATE-HMO
TPATPA-551662026-07-06T01:37:58ZETHAN—TAYLOR1961-01-06-——null··6658 Highland AveAustinTX78739GRP-9071—
TPATPA-568332026-07-09T05:58:18ZSteven—Mendoza1954-08-20N/A•••-••-7519—N/A9881 Market StMesaAZ·85294--
TPATPA-567112026-10-01T17:37:06Zcynthia—chavez1957-05-17N/A—-—2401 Palm DrColumbusOH43228GRP-1343··N/A
TPATPA-564242026-05-14T06:22:53ZAMYMROMERO1953-04-25—UNKNOWNnullNULL··5444 Union StreetPhoenixAZ·85061UNKNOWN···-
TPATPA-57399 2026-08-29T01:30:15ZBryant, FatimaI.—2001-06-19UHC-81628-53•••-••-1506NULL—5830 Willow Ct Apt 23FresnoCA93700NULL—
TPATPA-598452026-05-05T22:32:56Z ·Michelle··Pierce1994-12-08UNKNOWN•••-••-1553385.357.4846-1752 Washington StGilbertAZ85229GRP-3757—
TPATPA-632492026-02-12T15:38:04ZRalph—Porter05/08/1943—null8318631985—2418 Valley View DriveNashvilleTN37262-1750NULLNAVIGATE-HMO
TPATPA-591552026-05-17T19:24:07Z Hansen, Dennis——1940-05-06—-6584496728·null·4410 River RoadTampaFL33667null····
TPATPA-642792026-04-12T05:35:10ZJlie—Hall1956-08-14-N/A-null1783 Union StreetJacksonvilleFlorida32202UNKNOWNN/A
14,474 rows, page 64 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:42:40.325Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty