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-506372026-04-17T04:53:48ZKAYLA—SIMS05/14/1987-N/A—-7655 Washington StAtlanta·GA30371GRP-2115CORE-HMO
TPATPA-583302026-05-19T03:35:22ZWei—Bradley1967-03-01-———1936 JEFFERSON AVEAustinTX78780NULL··null
TPATPA-632352026-05-28T11:41:11ZHANNAH··—MILLER10/12/1957NULLnullNULL——UNKNOWN-NULLN/A—
TPATPA-523422026-02-26T20:20:33Zmegan—chavez2006-02-24null——N/A1613 LINCOLN WAYLas VegasNV··89112—UNKNOWN··
TPATPA-589462026-06-26T08:56:40ZRalph··Harrison1982-05-22—•••-••-10927274481723UNKNOWN7695 Union StreetAustinTX78783·GRP-0999SELECT-EPO
TPATPA-59802 2026-04-01T20:48:36ZOMAAR—MYRES1982-12-10NULL•••-••-3109—-7679 Maple AvenueOrlandoFLnullN/A—
TPATPA-506652026-05-26T22:42:21Zjean—bell05/09/2006—N/AN/A———nullN/A-N/A
TPATPA-588872026-10-18T11:00:08ZMason, George——1981-12-17—•••-••-759319257007570N/A6505 Sunset BlvdSeattleWA98186——
TPATPA-517902026-04-09T09:14:38ZAhmed—Perez1941-05-09UHC-47618-85-966.224.2443NULL··3435 BROADWAYSacramentoCA95811NULLNULL
TPA TPA-593762026-08-28T17:17:21ZANTHONY—PARKER1987-01-26····—N/AANTHONY.PARKER42@PROTON.ME6120 RIVER ROADDenverCO80262N/AN/A
TPATPA-561702026-03-21T19:53:29ZREBACCA—COOPEROct 28, 1954—UNKNOWN··797-922-2692NULL4303 FOREST AVE·GlendaleAZUNKNOWN·GRP-4577—
TPATPA-516742026-06-21T12:27:51ZEmmaB.Cooleman1992-05-06———N/A-N/A·null—N/A·MEDICARE-ADV-B
TPATPA-619032026-04-12T19:39:03ZCarlos······George··1958-01-21UNKNOWN•••-••-7703··—·99 Mesa DrPlanoTX75063GRP-9721NAVIGATE-HMO
TPATPA-535212026-08-16T07:08:31ZRICHARD—HERRERA08/28/1984··null——9847 Maple AveTUCSONAZ85755—CHOICE-PLUS-PPO
TPATPA-599492026-05-02T12:35:42Zpaul····thomas20-03-1976UNKNOWN•••-••-5589·N/A·-5585 Grand AvenueLAS VEGASNV89192N/ANULL
TPATPA-597872026-09-16T20:26:26ZPalmer, Judith——1997-02-02—NULL——4983 PINE DRORLANDOFL32891——
TPATPA-593412026-09-23T15:06:57ZJessica····Guerrero1953-09-21N/A•••-••-1393N/ANULL747 Canyon RdGilbertAZ85223UNKNOWNnull
TPATPA-632272026-09-07T01:08:49Zjesse—jones1967-07-15N/A•••-••-0227—N/A9066 Union StreetTampaFlorida33627——
TPATPA-613092026-07-17T19:09:39ZLi, Ahmed—····1015-19-52-NULL807-936-9613UNKNOWN—··—N/A··null··—
TPA TPA-513612026-03-13T09:04:16ZFatima—Marquez1995-08-18NULL—+1 851 642 0106nullN/A—NULL-UNKNOWNUNKNOWN
TPATPA-584022026-01-19T03:27:06Z·SHIRLEY—·ADAMS1958-03-11—•••-••-97409054980219N/A2419 Sunset BoulevardTampaFL33625N/ACORE-HMO
TPATPA-513702026-09-24T05:42:27ZMARY····DANIELS9/15/1969null•••-••-6388(326) 242-6146mary.daniels@proton.me3406 MARKET STREETDENVERCO·80259-N/A
TPATPA-578202026-04-14T07:17:48Zmariana····ryan1956-05-09··•••-••-73837873258829N/A···2596 VALLEY VIEW DRPlanoTX75082GRP-1132—
TPATPA-59723 2026-09-22T04:08:19Zrussell—nunez06/15/1987·UHC-92246-28NULL-RUSSELL.NUNEZ3@ICLOUD.COM··9308 River RoadJacksonvilleFL32287-—
TPATPA-587152026-06-16T11:24:11ZFuller, Olivia—··11/15/2000UHC-49543-71N/A5937264366N/A3435 RIDGE RD·PlanoTX75079—CHOICE-PLUS-PPO
TPATPA-581562026-10-15T07:53:09ZGERALD····ORTEGA1979-90-05NULL-N/Agerald.ortega28@proton.me8711 Cedar Ln Apt 29ColumbusOH43291NULLN/A
TPATPA-621302026-01-14T15:53:59ZSAMUEL—ROMERO1939-09-27—•••-••-37047485128467SAMUEL.ROMERO@PROTON.ME5854 BAYSHORE DRIVEMesaazNULL-—
TPATPA-536762026-05-09T00:50:43ZArthur··Cooper1979-03-09—NULLUNKNOWN·N/A1558 Valley View DriveSan DiegoCA92129——
TPATPA-627312026-03-04T07:17:52ZCARLOS—BRYANT1954-09-18—null·12919949150—6753 HILLCREST RDTAMPAFL··33609GRP-6589null
TPATPA-586292026-05-19T15:03:08ZBRADLEY—PATTERSON1990-01-05——N/Abradley.patterson@hotmail.com859 Valley View DriveScottsdaleAZ85241null····
TPATPA-623552026-07-31T13:52:09ZOBRIENV·CHRISTOPHER1982-05-11NULL•••-••-7954—N/A5265 CENTRAL AVEAtlantaGA30332null—
TPATPA-580672026-07-14T04:03:56ZNicole—Kim1945-01-20——UNKNOWN··N/A9473 Jefferson AveGlendaleAZ85350GRP-4300N/A
TPATPA-511842026-07-21T13:27:42ZCharlotte—Henderson1977-12-06—•••-••-1868UNKNOWNNULL2897 Elm StDenverco80208—N/A
TPATPA-558932026-03-09T08:24:37ZSamuel—OBrien10/08/2000UHC-78534-34—600-370-5917NULL8778 OAK STTampaFLN/AGRP-1802UNKNOWN
TPATPA-582902026-05-25T13:54:40ZALICE—HERRERA1980-06-25-N/A(751) 755-4693·alice.herrera@proton.me4802 Camelback RdTucsonAZ85783-7736GRP-9953MEDICARE-ADV-B
TPATPA-623992026-08-31T23:46:04Z·MarcusYWebb·1953-10-21——(831) 547-8128N/A5736 CHURCH STREETSacramento·CA95809·N/ACHOICE-PLUS-PPO
TPATPA-533582026-10-07T17:28:23ZRojas, Edward——2/15/2001UNKNOWNnullNULL—1525 Apache BlvdChandlerAZ85235GRP-3730··null
TPATPA-580022026-06-21T05:36:49Zaisha—padilla1998-08-02null•••-••-7295N/A—1443 Camelback RoadATLANTAGA30318——
TPATPA-504812026-04-07T23:29:08ZbethG.west··07/01/1964N/A•••-••-5292NULLNULL9763 APACHE BOULEVARD #735SAN ANTONIOTX78294-7022GRP-4578OPTIONS-PPO
TPATPA-638092026-06-14T19:30:01ZGREGORY—DEAN1986-04-16N/AN/A(315) 901-4510gregory.dean@outlook.com·7680 Lake View RdColumbusOH43200—·NULL
TPATPA-622242026-01-06T06:18:32ZZACHARY—FULLER1969-07-13—N/A(391) 989-1906—3951 MARKET STREETEden PrairieMN55323nullOPTIONS-PPO
TPATPA-599332026-08-26T07:00:55ZArthur··—Ryan1964-06-17—NULL(600) 702-5020arthur.ryan55@icloud.com2777 Oak StTampaFL33672N/A—
TPATPA-545322026-06-27T03:39:15ZRalph—Jimenez···04/11/98UNKNOWNUNKNOWN5707458691NULL9714 Church StreetSacramentoCA··95875N/A-··
TPATPA-53783 2026-09-28T06:48:32ZSingh, Kathryn——·19390605--—NULL8283 CEDAR LNAustinTX78767-—
TPATPA-560352026-03-19T05:16:48ZBurton, ChristianY—1976-03-16—NULLnull-nullN/AnullN/A····UNKNOWN
TPATPA-590082026-03-08T18:19:20ZBETTYF.WALLACE1955-10-16UHC-43761-16-455-839-2726NULL··7130 Union StLos Angelesca··90013-2352···GRP-0449—
TPATPA-601132026-08-12T00:38:06ZHannahSBailey1947-05-14NULL—(700) 840-9188—1908 Forest AvenueHoustonTX77076null—
TPATPA-523972026-06-02T00:15:00Z———1938-03-26-UNKNOWNN/AN/A2266 WASHINGTON STREETNashvilleTN37213·GRP-0606MEDICARE-ADV-B
TPATPA-626442026-03-19T18:35:20ZAisha—Rojas··18-12-1956—NULLN/A-UNKNOWN··—N/A—N/AN/A
TPATPA-536402026-08-23T06:08:35ZDeborah—Alvarado04-02-2006N/AUNKNOWN499-665-6349-4970 Sunset BoulevardDenverCO80201GRP-0234NULL
14,474 rows, page 154 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:49.111Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty