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-581012026-08-05T00:09:07ZJanice—Weaver1973-10-17null•••-••-5522nulljanice.weaver61@outlook.comnullN/A—-··GRP-5770SELECT-EPO
TPATPA-507742026-10-17T17:46:15ZHiroshi····Hamilton1951-10-10N/A•••-••-23746399479484NULL4949 Lincoln WayOrlando··FL32858-3735—CORE-HMO
TPATPA-514012026-06-09T12:16:15ZLinda—Spencer1966-09-16··—UNKNOWN332.848.0395NULLUNKNOWN—-—GRP-0743-
TPATPA-625742026-09-08T20:23:44ZJessica—WelchJan 27, 1952····——-1213 Apache BlvdDallasTX75284—CORE-HMO
TPATPA-574412026-04-19T08:57:28ZJacob····Little1974-07-12NULL—·6986938137UNKNOWN6323 Canyon RoadAtlantaGA·30382GRP-9106—
TPATPA-562572026-02-25T20:52:56ZBENJAMIN—PADILLA1974-09-23··-··•••-••-9764NULL—6589 Forest AvenueAUSTINTX78768—UNKNOWN
TPATPA-515312026-02-16T10:04:44ZGary—Richardson08/03/1954—N/A—·-5154 MOUNTAIN VIEW DREDEN PRAIRIEMN55336·GRP-8743MEDICARE-ADV-A
TPATPA-629062026-10-08T06:03:19Z·REED····MATEOJul 21, 1987··UHC5686730•••-••-8097356-688-5085MATEO.REED88@OUTLOOK.COM543 FOREST AVENUE·Orlando·FL32804——
TPATPA-643332026-05-23T15:12:36ZBobby—Butler19740927N/A•••-••-9440NULLUNKNOWN9720 Central AvenueColumbusOhio43261N/A—
TPATPA-596332026-10-14T02:22:30ZRachelYFlorres2001-04-19··—null—NULL3695 Maple AveHoustonTX·77045UNKNOWN—
TPATPA-640452026-05-31T23:13:51ZBrandon—Davis1960-11-09—-N/A·N/Anull-··—UNKNOWN-
TPATPA-615132026-09-04T01:56:38ZHelen—Harris2004-03-21·N/ANULLUNKNOWNN/A8792 Highland AveDenverCO80245··-null
TPATPA-577052026-01-03T20:52:21ZCHRISTOPHER—ELLIS1986-04-05UHC-61611-07---3925 BroadwaySan DiegoCA92178nullN/A
TPATPA-569392026-05-15T14:40:57Z ANGELA—COOK11/05/08UHC3051336•••-••-38642398593746NULL8553 Valley View DriveLos Angeles··CA90032—MEDICARE-ADV-B··
TPATPA-515142026-06-17T02:20:30ZTorres, WillieR—1979-07-09——UNKNOWNN/A3439 Valley View DrTampaFL33603N/A····
TPATPA-570162026-05-12T02:59:45ZMelissa—Rodriguez1943-03-11—•••-••-55666044501001null2585 Ocean Ave #320CharlotteNC28287nullnull
TPATPA-633522026-06-25T15:10:34Zhannah—arnld1989-06-16-•••-••-13283699562370NULL·4860 Desert Sky BoulevardCharlotteNC—null—
TPATPA-525922026-07-16T03:15:33ZRoy··HarrisonAug 21, 1975··null-7999802811—4717 Camelback RdMINNEAPOLISMN55468null—
TPATPA-560582026-01-20T16:24:51ZHenryZ.JohnsonMay 24, 1982NULLNULLN/Anull·8640 WILLOW CTTucsonArizona85757-8772NULLnull··
TPATPA-619912026-02-20T00:27:16ZJudith—Jenkins1971-08-10-—UNKNOWN—253 Highland AvenuePhoenixAZ85035GRP-9520—
TPATPA-605592026-02-02T07:50:10ZAdams, Danielle——1970-01-15UHC-49180-49•••-••-0861—UNKNOWN355 Hillcrest Road·PhoenixAZ85043—UNKNOWN
TPATPA-638262026-03-06T14:59:01Zkevin······gonzales10/25/1949UNKNOWN•••-••-2746—KEVIN.GONZALES@PROTON.ME5627 UNION STSan DiegoCA92150——
TPATPA-590512026-01-24T00:09:52ZBillyIWong··02/21/1989null——··5293 Ridge RoadPLANOTX75096GRP-6751N/A
TPATPA-642452026-09-17T12:32:02ZVIRGINIA—ARMSTRONG07/18/61UHC-99958-97NULL(845) 838-8168VIRGINIA.ARMSTRONG@AOL.COM2450 VALLEY VIEW DRMESA··AZ85204UNKNOWNMEDICARE-ADV-B
TPATPA-639142026-05-15T06:37:48Zkathryn—campbell1983-12-01····null6057720741null3280 Valley View DrLos AngelesCA90059——
TPATPA-500842026-02-21T22:59:28ZSHARON—PATEL1955-09-08—UNKNOWNUNKNOWN—400 WASHINGTON ST Apt 16··ChandlerAZ·85207GRP-2632null
TPATPA-520432026-04-09T19:11:57ZOlivia—·Mendoza19500820-•••-••-0440UNKNOWNNULL—null———null
TPATPA-623982026-01-21T18:16:38ZDEBORAH—JOHNSTON5/4/1963··——13265342461—1122 CENTRAL AVELOS ANGELESCalifornia90011UNKNOWN—
TPATPA-544532026-08-13T18:31:39ZAlex—Carpenter1948-07-15··UHC-30993-74NULL-—1607 OAK STOrlandoFL32811NULLSELECT-EPO
TPATPA-605562026-07-20T10:31:17ZCHUCK—COOK1940-12-71null•••-••-50978907572188-7669 Hillcrest RdOrlandoFL32812UNKNOWN····
TPATPA-635412026-05-21T17:14:12ZBETTY—HANSEN1955-09-13·····-(379) 860-3313betty.hansen19@outlook.com————nullN/A
TPATPA-542352026-04-16T06:37:48ZJustin··Crawford·3/26/1980N/A-UNKNOWNnull——NULL-GRP-8289—
TPATPA-513552026-01-16T01:34:52ZCarolynA··Hawkins19550814————2163 Camelback RdORLANDOFL32861—SELECT-EPO
TPATPA-636012026-07-19T10:58:27ZOwens, Jose——9/22/1982UHC-76682-96•••-••-2725UNKNOWNJOSE.OWENS@AOL.COM2057 Indian School RoadSeattleWA98191nullOPTIONS-PPO
TPATPA-545252026-08-07T23:49:44ZLUISQCAMPBELL19871016·-•••-••-5157+1 839 427 8035luis.campbell@icloud.com4276 WASHINGTON STDenverCO80224··—
TPATPA-552252026-09-16T19:17:39ZANNA—LONG1976-05-06——(635) 994-0133UNKNOWN8406 Elm StLas VegasNV89115—MEDICARE-ADV-B
TPATPA-607832026-02-19T13:02:50ZMason····Kelley09/23/1980—•••-••-3826(400) 967-4880—7635 HILLCREST ROAD #491DALLASTX75260GRP-3716MEDICARE-ADV-B
TPATPA-595962026-07-07T01:51:37ZWilson, Katherine——1991-03-22nullnull——9140 Union StreetNashvilleTN37272—·UNKNOWN
TPATPA-501972026-05-16T20:17:58ZDebra—·DavisFeb 13, 1986UHC9130553null-··—·1252 Church StOrlandoFL32862UNKNOWN·UNKNOWN
TPATPA-573882026-04-18T17:36:12ZZachary—Kennedy2001-01-05-NULL561-681-1350N/A505 Oak StMesaAZ85297——
TPATPA-564912026-01-07T01:02:37ZBARBARAPCHAVEZ··12-07-1980··-4139387604NULL··4256 Camelback RdSan Diego··California92158—UNKNOWN
TPATPA-583282026-08-29T00:37:27ZJonathan—GeorgeMar 11, 1950··•••-••-20372903031049null3565 Jefferson AveJacksonvilleFlorida32270··NULL—
TPATPA-529872026-05-11T00:26:52Z·Freeman, ThomasF—04/07/2006UNKNOWN—NULLthomas.freeman@hotmail.com1119 PINE DRIVECharlotteNCNULLN/ACHOICE-PLUS-PPO
TPATPA-578282026-06-27T21:07:28ZGRACE—ROMERO1978-08-24UHC-31170-76—+1 632 820 9186—6656 Lincoln WayNASHVILLETN37237GRP-9731—
TPATPA-592782026-08-27T08:05:21ZCarol—Li11-07-1982——UNKNOWNUNKNOWN8392 Elm St·JacksonvilleFL32262NULL-
TPATPA-58888 2026-04-05T06:23:05ZGeorge—Mason1981-12-17-•••-••-7593····-UNKNOWNUNKNOWN—N/AGRP-8188—
TPATPA-635502026-09-07T11:07:25Z·AlanIAguilar1965-11-24UNKNOWNUNKNOWN16858170704UNKNOWN2959 Lake View RoadAtlantaGA30392——
TPATPA-61077 2026-01-03T02:02:19ZARTHUR—RIOS03-01-1971UNKNOWNnull——1393 Meadow LnORLANDOFL32867-CORE-HMO
TPATPA-561802026-09-19T18:36:13Zsamuel—berry1941-01-06--259.616.4047—9512 INDIAN SCHOOL RD Apt 34TampaFL33657GRP-9354NULL
TPATPA-555582026-05-14T22:08:57Z JANET—YOUNG1976-05-24UNKNOWNnull242-570-5194NULL3328 Oak StreetNashvilleTN37280····SELECT-EPO
14,474 rows, page 62 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.317Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty