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-599642026-09-03T21:58:21ZLori—Hamilton19610904NULL•••-••-5632(849) 351-9558N/A—··N/A——MEDICARE-ADV-B
TPATPA-567002026-02-11T19:57:04ZPhilip····Grant1990-09-27—•••-••-9332null—N/A—null·nullnullMEDICARE-ADV-A
TPATPA-636822026-10-07T19:24:24ZJulie—Fernandez02/14/43UHC-12499-80--UNKNOWNnullnullN/ANULLUNKNOWN—
TPATPA-528332026-06-20T03:54:03Zcatherine—nguyen1998-09-22UHC-20991-26—N/A—·9866 Mesa DrJacksonvilleFL32213GRP-5094null
TPATPA-558902026-03-30T11:49:08ZPRIYA—HAMILTON1971-06-27N/A•••-••-1696——5118 Apache BlvdAtlantaGA30381—SELECT-EPO
TPATPA-56237 2026-07-01T22:47:48ZAaron—Lewis1947-03-24··-··-UNKNOWN-2428 Lake View RoadDenverCO80275UNKNOWNN/A
TPA TPA-546662026-08-24T13:07:59ZAlexisY·Palmer1950-11-01N/A—+1 810 324 8489-·795 Highland Avenue·San AntonioTX78208UNKNOWN······
TPATPA-536672026-03-28T23:21:53Zahmed··—spencer06/20/1994··UHC-74337-10NULL-AHMED.SPENCER88@OUTLOOK.COM317 Park Place Apt 14MesaAZ85244NULLSELECT-EPO··
TPATPA-528032026-07-20T02:59:10Z brian—·torres1986-09-09null—339-829-9287··brian.torres11@yahoo.com··9749 Lincoln Way··ColumbusOH43205N/A—
TPATPA-61647 2026-05-01T02:22:38ZHeather—Pena03/26/04NULLN/A—heather.pena@hotmail.com6554 Baseline RdTUCSONAZ85708N/Anull··
TPATPA-523612026-08-03T15:12:53ZZachary—Berry1974-01-01N/A-N/A—9420 Spring StHoustonTX77094null·N/A
TPATPA-591302026-03-29T20:07:19ZEric··Johnston1978-09-27UNKNOWN·N/AnullUNKNOWN8379 Church St··AtlantaGA30388GRP-8926UNKNOWN
TPATPA-532932026-02-02T01:06:01ZEvelyn····Aguilar19500713·NULL·NULL—NULL2316 Ridge RoadTampa·FL33637—null
TPATPA-567622026-03-10T21:42:18Zarjun—brooks··1897-03-25UHC-10874-58•••-••-8396·746-525-4212———UNKNOWN——-··
TPATPA-596772026-03-30T10:23:43ZRaymond—Ford·12/19/87nullN/A(921) 421-5096N/A··UNKNOWNnullN/AUNKNOWN—
TPATPA-592802026-07-01T08:13:27Zscott—hansen1943-04-11NULL•••-••-2328328-978-3314null212 Meadow LnMinneapolisMN—····-
TPATPA-543312026-03-02T00:47:21ZKathleenOWilliaamson1964-11-04UHC-41645-14UNKNOWN(941) 805-6680kathleen.williamson@aol.com7680 Indian School RdCharlotteNC28244GRP-1653N/A
TPATPA-540822026-10-03T22:23:26ZRobert··—Edwards7/11/2004UNKNOWN•••-••-6337N/Arobert.edwards@outlook.comnull—N/ANULLUNKNOWNN/A
TPATPA-575002026-04-01T03:34:44Z charles··O·porter2004-04-09NULL•••-••-22516176355619NULL··9313 FOREST AVENUESacramentoCA95829GRP-9736UNKNOWN··
TPATPA-572822026-02-23T11:53:54ZTheresa—Fox07/20/38NULL—17204608474—974 Park PlaceDallastx75284—·MEDICARE-ADV-B
TPATPA-638172026-06-17T11:49:39ZJLIE··—PALMER1948-07-04nullnullN/A·-2721 Palm DrChandlerArizona85293N/A—
TPATPA-505962026-02-04T11:31:52ZJose—Lane1969-10-15—•••-••-8255·912-705-6604—3821 BroadwaySan AntonioTX78201N/A-
TPA TPA-592152026-02-16T20:50:48ZCAMILA—REYES6/18/1981UHC-66882-65··—(542) 760-1646camila.reyes@outlook.com488 Grand AvenueLos AngelesCalifornia90081-1460GRP-7765N/A
TPATPA-500872026-04-02T09:24:57Zsharon—patel19550908N/A•••-••-6638null-400 Washington Street #136ChandlerAZ85207··NAVIGATE-HMO
TPATPA-590862026-06-17T07:29:41ZSTEPHANIE—ARMSTRONG1994-01-24UNKNOWN--stephanie.armstrong7@gmail.com-—NULLUNKNOWNGRP-5261MEDICARE-ADV-A
TPATPA-618542026-04-13T23:07:56ZCharlotte—·KennedyN/A—•••-••-3651UNKNOWNNULL—NULLnullUNKNOWNGRP-0284-
TPATPA-612322026-08-12T21:54:53ZAhmed—Li1964-03-09—•••-••-48498592720573·ahmed.li41@outlook.com754 Elm StreetSeattleWA98104-2321—N/A
TPATPA-558512026-01-14T03:34:12ZfrankFalexander1999-12-26—UNKNOWNUNKNOWN—·2263 Washington StreetPhoenixAZ85022·-null
TPATPA-586902026-06-27T12:08:30ZOlivia—Arnold19400523null··•••-••-85468006046003—824 Forest AvenuePlanoTX·75049nullMEDICARE-ADV-A
TPATPA-591492026-10-09T08:32:07ZGaryM.··Stewart··2004-07-21—•••-••-7642nullgary.stewart@proton.me4203 Apache Blvd Apt 18PlanoTX75076NULLN/A
TPA TPA-642812026-06-26T18:08:11ZRoy··—James08/14/1967NULL•••-••-0359—N/A8311 MAIN STTucsonAZ85778··GRP-9873N/A
TPATPA-556922026-03-08T20:10:15ZElijah—Meyer·1957-01-17--nullELIJAH.MEYER88@YAHOO.COM1014 MOUNTAIN VIEW DRIVEAtlantaGA30316·null····
TPA TPA-620212026-06-02T23:57:11ZRachelCFlores2006-02-05UHC-97143-27•••-••-4672(864) 356-6599NULL5831 SUNSET BOULEVARDPlanoTX75080GRP-0644-
TPATPA-57802 2026-02-20T07:57:03ZAndrea—Patel2008-04-01UNKNOWN•••-••-4199—NULL9262 Hillcrest RoadColumbusOH43201-4125-NULL
TPATPA-554952026-09-02T15:35:37ZKathy—Salazar1988-03-07UHC6243229•••-••-94495826762980UNKNOWN9564 Lincoln WayMesaAZ·85203····—
TPATPA-562002026-01-08T12:15:45ZDAVID—HERNANDEZ·1987-06-28-N/AN/A··DAVID.HERNANDEZ@AOL.COM····UNKNOWN-··—GRP-5652UNKNOWN
TPATPA-523582026-04-30T17:25:50ZWAYNE—CUNNINGHAM1947-05-12UNKNOWN•••-••-1397—NULL1551 LINCOLN WAY #746DallasTX75265-5558GRP-0739null
TPATPA-552232026-08-16T23:02:07ZBRYAN—RODRIGUEZ·19460825UHC-05002-09·NULLnullUNKNOWN6943 Camelback RdSeattleWA98103N/AUNKNOWN
TPATPA-514862026-09-21T09:18:53ZDYLAN—DOMINGUEZ1988-03-52—-N/A··—3895 PALM DRIVEGilbertAZ85279··GRP-3042MEDICARE-ADV-B
TPATPA-603742026-09-13T18:00:51ZCHERYL—BUTLER19451114—•••-••-0570—····6585 Bayshore DrivePlanotx75038GRP-8081null
TPATPA-583412026-05-03T01:53:42ZBeverlyIMartinez1985-09-20null•••-••-5779(336) 667-3465BEVERLY.MARTINEZ@ICLOUD.COM127 Valley View DrivePhoenixAZ85045NULLUNKNOWN··
TPATPA-51651 2026-04-26T13:41:20ZBILL—WARD19840517-·N/A7434220103william.ward@icloud.com5716 MOUNTAIN VIEW DRIVEHoustonTX····—choice-plus-ppo
TPATPA-517912026-06-23T16:57:52ZDylan C—Webb1993-04-28nullnull(638) 767-2848NULL2218 Harbor BlvdEden PrairieMinnesota55324-UNKNOWN
TPATPA-552402026-05-02T21:38:43ZNICHOLAS—·MORGAN1977-02-06····-N/ANULL4559 Union StreetSACRAMENTOCalifornia95839-N/A
TPATPA-641762026-05-27T10:43:40Z·diez—bernda7/16/1986UNKNOWNUNKNOWN··2018733562—6985 Broadway Apt 5DenverCO80244UNKNOWN··null
TPATPA-597382026-06-05T01:40:32ZJanet—Ryan1948-04-08NULL•••-••-3430NULLjanet.ryan@proton.me1484 Mesa DriveSan AntonioTexas78203GRP-1368medicare-adv-a
TPATPA-592252026-05-25T17:35:27ZBrittany—Hudson1966-07-21····—UNKNOWN-··1462 CANYON RDMinneapolisMN55447GRP-8131—
TPATPA-610282026-09-09T01:26:10ZJeremy··Henderson1994-12-07N/A•••-••-554114864125425jeremy.henderson42@aol.com887 Desert Sky BoulevardMiamiFL33164-NULL
TPATPA-597182026-01-26T19:50:17Zbruce—little7/9/1939N/AN/A(779) 505-4597NULL5733 Baseline RoadLOS ANGELES·CA90043——
TPATPA-619602026-07-14T04:14:02ZKimberly—Hernandez1945-12-13-•••-••-4454(369) 389-0543—4884 Pine DrivePHOENIXAZ·85023nullnull
14,474 rows, page 107 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:43.609Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty