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-613942026-09-05T06:44:37ZStephanie—Chapman1961-10-04null•••-••-5735—N/A—UNKNOWNUNKNOWNUNKNOWNGRP-0913—
TPATPA-562782026-02-19T05:16:22ZChristina—Hoffman1955-02-05--362.383.6863CHRISTINA.HOFFMAN@HOTMAIL.COM————GRP-1843MEDICARE-ADV-A
TPATPA-631552026-06-21T10:37:30Z HEATHER—SAALZAR04/04/1968UNKNOWN——N/A8565 Highland AvenueDenverCO80256nullUNKNOWN
TPATPA-589652026-02-17T19:00:11Z·saraZharvey2/18/1984UNKNOWNnull·(624) 543-1462sara.harvey@gmail.com8811 Church StDENVERCO80257GRP-9521MEDICARE-ADV-B
TPATPA-622982026-06-13T22:35:14ZMARIANA—PEREZ1994-09-22UNKNOWNnullUNKNOWN—·4020 MEADOW LNSAN DIEGOCalifornia92121-5771-OPTIONS-PPO
TPATPA-585232026-10-15T17:01:33Zaustin—cunningham·2005-12-11-—-—4366 Forest AvenuePhoenixaz85002GRP-8055null
TPATPA-624602026-01-09T06:07:36ZMatthew—Sandoval1956-02-01null•••-••-2940UNKNOWNmatthew.sandoval@hotmail.com7835 Cedar LnAUSTINTX78786-UNKNOWN
TPATPA-544082026-10-10T18:10:38ZSteen—Nelson1964-01-11UNKNOWN——steven.nelson@outlook.com-N/AN/ANULLN/A—
TPATPA-519012026-07-10T03:49:52ZZACHARY··GIBSON··11-08-1951—•••-••-6989nullzachary.gibson18@proton.me4400 Church StAtlantaGA30373-2104N/AN/A
TPATPA-595162026-07-24T19:43:44ZHeather—Duncan1946-05-05UNKNOWNNULL·-·NULL7012 Central AvenueMesaAZN/A-··NAVIGATE-HMO
TPATPA-57724 2026-08-30T12:56:00ZJoyce—Snyder1961-01-07uhc-38342-05•••-••-6007——7991 MEADOW LANEGlendaleArizona85350——
TPATPA-608282026-10-18T22:29:15ZVargas—Keith1955-03-05—•••-••-6838N/A—720 Meadow LaneSEATTLEWA98111·N/AUNKNOWN
TPATPA-554612026-09-06T16:09:18ZLINDA—PERKINS2004-01-21—UNKNOWNNULL·LINDA.PERKINS20@OUTLOOK.COM2599 INDIAN SCHOOL RDEden PrairieMN55342··GRP-2625—
TPATPA-624672026-09-18T10:46:47ZJESSE—PADILLA01/13/44N/AN/A861.648.6458—····UNKNOWN—-N/A—
TPATPA-529332026-06-29T01:00:34ZVasquez, William——1939-01-24··UNKNOWNnull455-526-9205null3942 Union St #112··MinneapolisMN55411NULLNULL
TPATPA-638012026-07-26T05:44:42ZLuis—·Rogers·1996-06-13UNKNOWNNULL-····1887 Broadway·Las VegasNV89118GRP-4248MEDICARE-ADV-A
TPATPA-565502026-09-11T04:25:32ZNacny—Rojas1999-06-09UHC-90304-33•••-••-6093—UNKNOWN6782 Pine DrHoustonTX77065GRP-5252—
TPATPA-630462026-10-06T13:54:20ZRussell····Torres1984-12-02UHC-27828-45•••-••-4843NULL—4623 Lake View Rd #404NashvilleTN·37205GRP-9327CORE-HMO
TPATPA-520302026-02-01T14:12:11ZAlexander—Allen1972-06-07UHC-21630-34—9174195231NULL6316 Spring StTucsonAZ85713-0019-MEDICARE-ADV-A
TPATPA-585182026-02-18T22:47:45ZKayla—Grent1939-01-16UNKNOWN•••-••-85503166447406—3675 Market StreetGlendaleAZ85327-0556··nullCORE-HMO
TPATPA-601122026-04-20T04:00:33ZHANNAH—BAILEY05/14/1947·null•••-••-490717008409188N/A1908 FOREST AVENUEHoustonTX77076-null
TPATPA-557472026-06-09T06:14:07ZARTHUR—SINNGH0209-17-93UHC7123780-··UNKNOWN··NULL-null——GRP-4033NAVIGATE-HMO
TPATPA-556762026-01-18T14:25:20ZAnna—Torres2005-04-23··UHC-62997-94•••-••-8056-—5265 CANYON ROADCHARLOTTENC28216GRP-2224MEDICARE-ADV-A
TPATPA-527932026-08-23T06:19:03ZSantiago—Oliver2001-09-27null—752-363-3157null2408 Church StreetOrlandoFL32861UNKNOWN—
TPATPA-564412026-10-12T07:56:08ZSAMUEL—ROSS1998-03-03UHC-33174-59·NULL·null—3528 MEADOW LNHoustonTX77002—MEDICARE-ADV-A
TPATPA-594772026-01-08T05:48:23Zbilly—williams1950-04-07NULL—-null6354 Baseline RdHOUSTON·TX77045GRP-9531-
TPATPA-595582026-02-05T09:51:36Zjean··—ramirez2005-03-05—•••-••-2437N/A—N/AUNKNOWN··UNKNOWNUNKNOWN—CORE-HMO
TPATPA-55996 2026-02-22T12:05:36ZDixon, Timothy——1951-11-17····-(445) 631-0971NULL1368 Ridge RdPlanoTexasnullGRP-7871NULL
TPATPA-621842026-08-19T05:51:51ZMarcus—Richardson·1995-01-28NULL·NULL920-657-2938—2714 BROADWAYGlendaleAZ85378··GRP-3186CORE-HMO
TPATPA-503632026-08-15T20:04:13ZANGELA—YANG1970-01-18nullnull·9816019278—7662 Oak StreetAUSTINTX78702N/Anull
TPATPA-570272026-10-14T23:48:08ZMills, Judith——1943-05-28UNKNOWN—3948150586judith.mills@gmail.com7674 PINE DRDenverColorado·80205—UNKNOWN··
TPATPA-616782026-04-12T22:42:46ZRandy—Clark1989-05-14N/Anull·N/A—4099 Camelback RdMIAMIFL33195·nullMEDICARE-ADV-B
TPATPA-587922026-09-04T01:53:04ZValentina····Matthews1997-01-27UHC4868026—NULL—N/A——NULLGRP-7580UNKNOWN
TPATPA-577612026-04-01T12:11:55Z·Charles—WilsonJan 2, 2006—N/A862-594-1570UNKNOWN3100 Lincoln Way Apt 23Los AngelesCA90077GRP-9074NULL
TPA TPA-567072026-06-25T01:59:03ZTylerLChapman2005-02-26nullnullnullnull6201 Mountain View DriveSacramentoCA95811GRP-8571NAVIGATE-HMO
TPATPA-584542026-09-20T03:10:39ZHelen··—Estrada1944-12-08··-—·-5639 Spring StLas VegasNV89134GRP-5425····
TPATPA-569512026-07-14T03:54:46Z·SAMANTHA—CRAWFORD16-05-2006—N/A527-303-6319——N/ANULLnull—-
TPATPA-567042026-09-12T10:02:45ZFerguson, MarthaP.—1990-08-18nullN/A—martha.ferguson40@outlook.com6568 BroadwaySan AntonioTX78288null··—
TPATPA-599872026-07-17T10:48:12Z Gerald—Arnold1960-12-28UHC-27129-15UNKNOWN··(502) 621-0058N/A2154 Bayshore DrHOUSTONTX77001GRP-3632SELECT-EPO
TPATPA-612392026-03-03T01:29:32ZLAUREN—SCHMIDT1958-01-11UNKNOWNNULL4944651390—6676 Central AvenueAustinTX78741GRP-4562—
TPA TPA-625102026-03-18T14:26:59ZJERRY—SNYDER14-07-2003-——NULL2995 Ridge RoadFresnoCA93791····CHOICE-PLUS-PPO
TPATPA-628642026-07-29T06:41:04ZNathan—Greene19990711··—UNKNOWN17433653209NULLUNKNOWN—-N/AGRP-5726-
TPATPA-574882026-02-04T23:19:34ZSarah—Banks1980-10-22N/A•••-••-3416-—3771 Lincoln WayHOUSTONTX77001—UNKNOWN
TPATPA-561862026-09-08T00:41:26ZKaren—Lucas1976-10-28UNKNOWN··—·(816) 919-4594-7119 Palm Dr #319DallasTX75261GRP-8982N/A
TPATPA-611122026-08-06T20:28:17ZBryan—Morgan1998-03-16·UNKNOWNnull—nullUNKNOWNUNKNOWN—N/A·GRP-0655··
TPATPA-631682026-09-13T06:51:45ZNancy—Porter1940-07-15N/A··•••-••-8091—nancy.porter@hotmail.com6331 OCEAN AVENUEDallasTexas75291GRP-8849MEDICARE-ADV-A
TPATPA-604032026-06-21T09:38:20ZWilliis, Bradley——1999-01-08··NULLnull-—·5874 CEDAR LNMIAMIFL33165·NULLSELECT-EPO
TPATPA-615802026-09-25T16:47:34Z·Hannah—Maartinez1944-05-13NULL•••-••-0124N/AHANNAH.MARTINEZ@PROTON.ME··6560 Lincoln WaySan DiegoCA92159N/A-··
TPATPA-567732026-07-24T23:59:08ZTYLER—ROJAS6/27/1994—null-tyler.rojas17@outlook.com4070 Main StreetScottsdaleAZ85263—N/A
TPATPA-610902026-02-09T00:36:08ZPerkins, CamilaY.—4/14/1956—··3359232099-9569 Main Street·SeattleWA98164——
14,474 rows, page 98 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.445Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty