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-596492026-09-13T01:35:02Z sean··—chenMar 10, 1972——748-889-0655UNKNOWN376 Apache BlvdTampaFL33632-2403nullN/A
TPATPA-563862026-01-12T23:13:58Zjordan—porter2001-04-17—•••-••-4268NULL—2631 HIGHLAND AVENUEAustinTX78707GRP-4825null
TPATPA-590442026-01-30T05:12:34ZHudson, Gregory——8/14/1968—NULLUNKNOWNN/AUNKNOWN—null-GRP-4947··N/A
TPATPA-531052026-03-09T06:05:30ZGeraldYWagner1982-02-05—•••-••-379316279468172-9744 RIVER ROAD #478CharlotteNC28269nullCORE-HMO
TPATPA-610802026-10-09T11:37:09ZPAUL—PRICE2001-03-20-—803-219-0290-6131 Jefferson AvenueGlendaleAZ85325-3957—CORE-HMO
TPATPA-574612026-01-27T04:52:41ZChapman, Tommy——1967-01-23——18624451824··-4340 CANYON RDChandlerArizona85252—NULL
TPATPA-504432026-02-20T15:15:29ZGary—Sullivan1965-11-03N/AnullN/Agary.sullivan62@aol.com8505 Market StTempeAZ85242GRP-5094—
TPATPA-631582026-09-24T03:19:39ZHENNRY—·DOMINGUEZ2000-08-01····N/A15516789287NULL9538 MESA DRIVETAMPA·Florida33662-7119nullnull
TPATPA-62935 2026-01-28T07:48:14ZGEORGE—HOEWLL1984-03-09UNKNOWN-(261) 897-4828—9286 Baseline RoadMesa·Arizona85207NULL—
TPATPA-529972026-03-13T14:48:54ZGRACECKELLY06/04/92—null(766) 506-0494GRACE.KELLY@YAHOO.COM5725 Maple AvenueSAN DIEGOCA92122UNKNOWN—
TPATPA-503042026-07-25T05:32:41ZALICE—CRAWFORD1953-10-20····—··-8047 FOREST AVENUEPlanoTX75059——
TPATPA-625482026-04-06T23:25:15Zwaltar—bowman04/16/1971—•••-••-2778——·9491 Apache BoulevardHoustonTX77035GRP-4410—
TPATPA-515012026-03-30T07:39:57ZJustin—Fisher3/26/1939—UNKNOWN··NULL5138 Central AveMinneapolisMN55450GRP-0171NULL
TPATPA-574372026-07-10T15:36:40Zandrea—casitllo1989-08-21—•••-••-8983—null6085 Camelback RoadPhoenixAZ85044NULL—
TPATPA-571372026-02-13T03:46:22ZMARIA—CHEN09-10-2006UNKNOWNnull-··—5649 Elm StreetEden PrairieMN55345——
TPATPA-581392026-09-04T10:54:14ZjackYdunn2007-02-20-······JACK.DUNN1@OUTLOOK.COM414 Broadway Apt 40NashvilleTN37216GRP-7721—
TPATPA-61926 2026-08-19T23:25:14ZSarah··—Carroll1969-05-06UNKNOWN—UNKNOWN—UNKNOWN—nullNULL—NAVIGATE-HMO
TPATPA-60548 2026-09-06T14:49:03ZAndrea—Rivear01/09/46N/A·N/AUNKNOWNNULL·-UNKNOWN——N/A-
TPATPA-628152026-03-06T20:17:03ZAndrea··Morrison1968-07-20··—•••-••-6127—-7960 JEFFERSON AVE #395HoustonTX77095GRP-8071··OPTIONS-PPO
TPATPA-502552026-04-26T13:14:27ZRoger—Bell1986-11-02N/A•••-••-1403·null—7058 Meadow LnMiamiFlorida33133GRP-8391MEDICARE-ADV-B
TPATPA-637002026-06-12T21:53:16ZFatima—Price1945-11-18-·null··—3822 Lincoln WaySan DiegoCalifornia92174-5025UNKNOWN—
TPATPA-619952026-09-22T23:02:50ZAustin, Heather——1994-10-27UHC-79946-28—nullN/A4774 Harbor Boulevard·GilbertAZ85244GRP-1430-
TPATPA-537292026-06-19T16:56:59ZMargaret··OBrien1966-02-24·N/AUNKNOWN-··N/A——nullN/AUNKNOWN··
TPA TPA-513722026-07-20T02:36:16ZSarahUCrawford1996-06-24UNKNOWN•••-••-7441--8210 Cedar LnColumbusOH43297GRP-8412UNKNOWN
TPATPA-509292026-02-12T13:05:42ZCharlesVWongFeb 1, 1963NULL•••-••-1611+1 545 468 4159null2646 BroadwayMiamiFL33116——
TPATPA-596852026-02-28T20:25:54ZPatterson, Michael——6009-19-61—null·7988501642null1907 Lincoln WayLOS ANGELESCA·90083--
TPATPA-529942026-03-14T01:09:31Z·BRYAN—BAILEY1950-02-26N/A—790-619-6459BRYAN.BAILEY@ICLOUD.COM3511 UNION STREETLas VegasNV89157GRP-0417MEDICARE-ADV-B
TPATPA-603952026-02-08T06:54:31ZKATHRYN—BUTLER1961-10-11··—nullUNKNOWNUNKNOWN1625 FOREST AVENUEMesaAZ85243UNKNOWNUNKNOWN
TPATPA-600812026-06-21T23:44:26ZDoris—Mejia1971-01-16——302-338-9122DORIS.MEJIA@ICLOUD.COM5866 MAPLE AVEAtlantaGA30315——
TPATPA-513662026-05-04T00:44:41ZHannah—Sims06/23/1983··NULL•••-••-7872UNKNOWNUNKNOWN3516 LAKE VIEW ROADTampaFL33663··GRP-6476—
TPATPA-506672026-04-29T14:34:02ZDeborah··—Wright1997-11-24NULL--—7683 Market StreetOrlandoFL32813——
TPATPA-552972026-09-11T05:39:51ZJarryY.·Price1957-10-17—UNKNOWN(432) 403-7551·-·563 DESERT SKY BOULEVARDGLENDALEAZ85340··GRP-2899N/A
TPATPA-638612026-09-23T17:07:07ZRachel—Gordon1973-01-27UHC4714330UNKNOWNnullN/Anullnull——GRP-8871UNKNOWN
TPATPA-612202026-09-03T08:04:23ZPATRICK—GILBERT1986-05-26UHC-38235-14—····—9878 INDIAN SCHOOL RD Apt 12Atlanta·GAUNKNOWN-null
TPATPA-524902026-06-26T05:10:57ZAaron—Colle8/21/1994N/AN/A740-431-0654NULL3158 Elm StreetTucson·az85742—N/A
TPATPA-611662026-07-11T16:44:19Z Deborha—Owens·1969-09-28NULL•••-••-3208——7234 HIGHLAND AVENUEFresnoCA93721——
TPATPA-526382026-10-04T04:39:25Zmaria····danies1982-10-09UNKNOWNNULL—maria.daniels@gmail.com5183 Sunset BoulevardFresnoCANULLGRP-0817UNKNOWN
TPATPA-572432026-06-08T21:54:29Zkeith—henderson2001-10-07NULLN/A858.926.3470-N/AUNKNOWNN/A——NAVIGATE-HMO··
TPATPA-578672026-05-04T08:12:21ZLARRY—LYNCH1993-07-16UNKNOWN•••-••-8177——4992 Valley View DriveSAN ANTONIOTX78275-0420—null
TPATPA-57078 2026-08-19T00:01:49ZKayla—Riley2004-02-12N/A—(501) 221-1052—2261 River Rd #713DallasTX·75285—CORE-HMO
TPATPA-604432026-07-05T23:34:37ZJULIE—GOMEZ1941-06-07—•••-••-7999(750) 806-2634null5130 Bayshore DrGilbertAZ85241NULLMEDICARE-ADV-B
TPATPA-571492026-04-03T03:48:49ZJOYCE—BLACK2005-08-22··UNKNOWNnull-UNKNOWN··9734 Park Place··Eden PrairieMN55360-3470——
TPATPA-570962026-07-26T17:18:24ZGloria··Miller19880911UHC-04119-68•••-••-5462(315) 367-5577UNKNOWN7263 Cedar LnColumbus··OH43288·NULL—
TPATPA-572352026-07-14T22:27:12ZKenneth—Montgomery1985-06-02—UNKNOWN-—476 HARBOR BLVD·TucsonAZ·85704-4524GRP-2284··NULL
TPATPA-600682026-03-04T16:32:11ZAlexis—Parrker1988-11-26—-404-860-2689N/A---—N/A—
TPATPA-557202026-08-27T13:27:00ZANGELAZWATKINSAug 2, 1997-UNKNOWN8257488-2215 Canyon RdTAMPA·Florida33613-2616null·CORE-HMO
TPA TPA-516382026-09-18T16:43:16ZStephanieOGilbert12/07/58———stephanie.gilbert10@gmail.comNULLnullN/A-GRP-5920-
TPATPA-520132026-05-20T08:23:03ZJenniferP.Carr1949-11-05UHC-46410-65•••-••-4235—N/A2820 HILLCREST RDSan AntonioTXUNKNOWNUNKNOWN—
TPATPA-628722026-03-30T18:29:43ZLAUREN—WAGNER09-01-1959UHC-76656-69—(810) 616-1786··lauren.wagner49@outlook.com6697 Highland AvenueSEATTLEWA98172N/A—
TPATPA-632202026-04-12T23:32:01ZAlice—Mendez4/2/1992—N/AN/A—·3762 Jefferson AvenueOrlandoFL32851—null
14,474 rows, page 16 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:36.678Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty