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-602192026-07-24T14:47:52Zdaniel—crawford10/07/71·N/AN/AUNKNOWN··UNKNOWN9650 APACHE BLVDNashville··TN37262null—
TPATPA-575732026-06-23T12:04:15ZCarlos I—Berry1980-07-72————2017 Palm DrMesaArizona85295UNKNOWNN/A
TPATPA-633782026-02-14T19:54:26ZWalterN.WillisOct 16, 1997·null•••-••-7049NULL—7871 Meadow LnDallasTX··75236GRP-9278OPTIONS-PPO
TPATPA-508162026-01-15T16:22:12ZValentina—OBrien1965-06-13—•••-••-9746+1 857 841 2143—5035 Oak StLos AngelesCA90086——
TPATPA-534302026-04-21T13:16:52ZScott··LCooper02/08/08··N/A——-·9015 Church StGlendaleArizona85352UNKNOWNCHOICE-PLUS-PPO
TPATPA-532552026-02-01T10:30:32ZVazquez, Sarah——1982-04-20NULL—2192558280····7529 Grand AvenueTucsonAZ85732—·NULL
TPATPA-594982026-09-08T07:15:54Z Silva, Mark——1987-12-04UNKNOWNUNKNOWN-UNKNOWN7641 Ocean AveChandleraz85251GRP-3362—
TPATPA-553492026-01-28T11:48:18ZCAMILAM.MORGAN07/21/1992N/AN/Anullcamila.morgan29@icloud.com2671 Lake View RoadOrlandoFL—N/AMEDICARE-ADV-A
TPATPA-591342026-04-05T09:18:25ZCynthia—West1970-05-14·UHC-57502-44·null—UNKNOWN8007 WASHINGTON STTampaFL33681··GRP-6711UNKNOWN··
TPATPA-62374 2026-02-10T23:29:01ZBruce—Price19661123UNKNOWNUNKNOWNN/A·bruce.price7@proton.me1066 Sunset BoulevardSACRAMENTOCA95844NULLUNKNOWN
TPATPA-598042026-07-12T14:43:03ZBetty—Black15-06-2008UNKNOWN—8345840573-5994 Highland AveCharlotteNC—NULL·MEDICARE-ADV-A
TPATPA-545382026-07-08T03:20:49ZJEFFREY—MENDEZ05/03/1967—•••-••-03204768792—5599 SAGE COURTDENVERCO80246N/AOPTIONS-PPO
TPATPA-632552026-05-26T18:03:52ZMartha—Marquez·2002-07-06NULL—-—-——NULL——
TPATPA-621752026-09-29T18:17:13ZRANDY··—·THOMAS1978-09-10—•••-••-69523413584918—nullnull—UNKNOWNGRP-7982—
TPATPA-521712026-04-05T10:33:34ZGaryBHughes06/17/1947—•••-••-0392N/A—6761 Cedar LnMesaAZ85235N/A-
TPATPA-552602026-03-13T18:54:11ZGREGORY—PETERS··May 27, 1993—NULL513.235.1550UNKNOWN263 Grand AveCharlotteNC28213GRP-0348—
TPA TPA-524782026-06-05T14:58:45ZSCOTT—CHAVEZ·1982-09-19null•••-••-6952NULL·SCOTT.CHAVEZ68@OUTLOOK.COMNULL——nullGRP-3491—
TPATPA-502752026-06-12T12:11:23ZRlph—Ortega1952-12-18——nullralph.ortega6@proton.me2079 MEADOW LN·MESAAZ85253·nullnull
TPATPA-602302026-03-29T21:11:49Z·michelle—mendez12/20/67··NULLUNKNOWN—1553 Hillcrest RoadSacramentoCA95820GRP-8762—
TPATPA-636682026-05-02T01:56:07ZRAYMOND—ALVARADO5/14/1940—-null-1325 Market St··Dallastx75230GRP-8563-
TPATPA-614242026-03-26T12:01:16ZMARY··MEJIA1950-07-02UHC-24625-01NULLnullmary.mejia@gmail.comNULL··N/A—nullGRP-5487NULL
TPATPA-512852026-06-29T16:23:05ZYUKI—WHITE1115-19-54nullN/ANULL··—UNKNOWN····UNKNOWN——
TPATPA-552932026-10-14T14:17:47ZAnn—Morgan1979-01-26nullNULL8246990803··—4333 Apache BoulevardChandlerAZ·N/ANULL-
TPATPA-504162026-02-12T14:36:09ZOlivia··—Wels··1950-06-10—NULLnullolivia.wells72@icloud.com9276 HILLCREST RDSacramentoCA95868GRP-9165MEDICARE-ADV-B
TPATPA-507692026-04-14T12:49:41Z PATRICK—ESPINOZA1995-01-18—·UNKNOWN227.813.9119—8273 ELM STREET·Eden Prairiemn55398—UNKNOWN
TPATPA-570372026-07-02T02:04:46ZloriSgeorge1947-08-05UHC-37487-27—543-712-3950—6812 Broadway·TempeAZ85239-UNKNOWN
TPATPA-617822026-03-12T07:06:12ZrachelDfowler19610604··—•••-••-9297(983) 819-2153—8131 SUNSET BOULEVARDPhoenixArizona··85069NULLMEDICARE-ADV-B
TPATPA-608702026-08-17T11:24:16ZBradley—Russell·1976-02-07—NULL-—3277 Bayshore DrSacramentoCA95833UNKNOWN-
TPATPA-539332026-09-06T14:56:50ZBOBBY—GRAY1998-12-27—•••-••-24725917836723bobby.gray@gmail.com5084 Market StTampaFlorida33607GRP-5988OPTIONS-PPO
TPATPA-64133 2026-01-30T04:27:41ZBilly—Andrews1960-09-05N/A—(229) 986-3398-4549 Bayshore DriveTempe··AZ85298--
TPATPA-638652026-01-24T05:03:09Zkimberly—mills1955-12-07NULL-·NULLN/A9137 Main StGILBERTAZ85208UNKNOWNnull
TPATPA-605502026-06-03T02:34:42ZAISHA—GILBERT··1971-08-08··UNKNOWN··-5039566880N/A7169 Mountain View DriveSacramentoCA95849——
TPATPA-608292026-07-13T12:23:58ZDOUGLAS—GRANT2005-04-15N/AN/A745.270.3908—4836 SPRING STGilbertAZ85268GRP-2145MEDICARE-ADV-B
TPATPA-537222026-02-28T18:42:33ZMAGGIE—GIBSON2004-05-16N/A—(897) 307-9542NULL7161 Lake View RdColumbusoh43215GRP-3272UNKNOWN
TPATPA-574462026-07-31T03:40:40ZJulia···XPowell··2005-04-04NULL··UNKNOWN—NULL6540 Sunset Boulevard·GlendaleAZ85355GRP-5749—
TPATPA-596542026-08-10T19:38:33ZGRACE—STEPHNES1956-03-05N/A•••-••-2261--1151 Palm DrSan AntonioTX78266nullUNKNOWN
TPATPA-536832026-01-29T02:36:46ZAlyceZButler2006-10-22··N/A•••-••-8544N/A··5189 Baseline RdPhoenixAZ85004—CHOICE-PLUS-PPO
TPA TPA-543992026-06-03T16:00:55ZGERALD—·MEYER1943-09-27N/A—(500) 472-0980null301 Hillcrest RdJACKSONVILLEFL32203—null
TPATPA-570712026-03-25T11:28:58ZRyan—Weaver2007-03-24··N/A(893) 386-5925—4467 Mesa DrPhoenixAZ85039—NULL
TPA TPA-534942026-03-22T22:34:07Z·Lucas, Kevin——1946-07-04-UNKNOWNUNKNOWNNULL7668 Indian School RdMESAAZ85288—NULL
TPATPA-596482026-07-24T13:27:26ZSeanY.Chen03/10/1972UNKNOWNNULL····UNKNOWN4854 Pine DriveLas VegasNV89165-1738·GRP-9379·N/A
TPATPA-590012026-06-01T23:41:12ZPATRICK—VALDEZ04/27/1950UNKNOWN•••-••-3757638.374.3885····5078 Canyon RdMinneapolisMN55432··—UNKNOWN
TPATPA-61915 2026-04-11T12:27:49ZHerrera, Jordan——01/02/94———null8958 Indian School RoadPhoenixAZ85053—NULL
TPATPA-504592026-09-22T07:36:04ZJACOBCHART··19901102N/A····14183970671·null7461 Market StreetTAMPAFL··33625—NULL
TPATPA-583182026-04-26T08:43:25ZRICHARD—HICKS02/15/1987NULLUNKNOWN351.496.9043N/A6440 River RdEDEN PRAIRIEMN55321N/A—
TPATPA-566782026-04-16T03:59:17ZLisaDShaw1989-08-06UHC-91238-33—(745) 258-8793lisa.shaw@aol.com3486 Elm StSAN DIEGOCA—GRP-6791null
TPATPA-50669 2026-04-28T21:38:43ZDonna—MyersOct 7, 1972—-··—6906 Desert Sky BoulevardHoustonTX—null·null
TPATPA-587332026-03-14T13:56:34ZFrances—HenryFeb 7, 2001··—-19734465938———null·N/A—UNKNOWN
TPATPA-598412026-08-17T22:19:58ZLORI—BRADLEY1960-07-22NULLUNKNOWN——75 Market StreetLas VegasNV89112—null
TPATPA-597822026-10-01T04:01:24ZWilliam—Moore1990-04-22—•••-••-9079280-771-8650N/A2025 Bayshore Dr #961AustinTX78727NULLN/A
14,474 rows, page 180 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:53.107Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty