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-535882026-08-10T15:43:00ZPHILIP—BLACK1955-02-06UNKNOWNUNKNOWN—NULL1873 FOREST AVENUEHoustonTX77015-N/A
TPATPA-574292026-01-19T04:31:02ZJanet··Cruz25-09-1942UHC-97798-27nullN/ANULL—nullUNKNOWNUNKNOWNGRP-8448-
TPATPA-576102026-01-14T12:08:41ZKTHERINE—MASON1991-06-25N/ANULL--2654 CANYON ROADNASHVILLETN37273UNKNOWNN/A
TPATPA-554742026-02-14T09:06:38ZSUSAN····CLARKDec 6, 1983UNKNOWN•••-••-1663null—9001 River Rd #391·HoustonTX77035—MEDICARE-ADV-B
TPATPA-58406 2026-03-27T22:49:06ZSimpson, Henry——1985-11-04·--(632) 631-5741henry.simpson@yahoo.com3244 Park PlaceFresnoCA93772——
TPATPA-590562026-01-19T03:36:31ZNATTHAN—TRAN2003-06-21———null-UNKNOWN—NULLGRP-2535NULL
TPATPA-628322026-01-18T06:14:07ZLUIS—·BLACK20-12-1993—•••-••-9364—-6457 BroadwayTEMPEAZ85276GRP-9518CHOICE-PLUS-PPO
TPATPA-580442026-01-13T10:57:49ZEmilyMMurphy·20040802null··nullemily.murphy36@hotmail.comUNKNOWNUNKNOWN——NULL—
TPATPA-562352026-03-15T05:30:00ZKATHLEEN—MORRIS1962-10-27N/A—-··kathleen.morris1@icloud.com4720 Apache BlvdTucsonAZ85750NULLUNKNOWN
TPATPA-562502026-07-04T08:24:55ZEric—Freeman4/7/1961UHC-11481-11•••-••-3336NULLERIC.FREEMAN@YAHOO.COM533 Highland AvenueDallasTX75252-3768NULL··NULL
TPATPA-642252026-03-04T22:41:55Z JOAN—PRCIE1938-10-13null—877-521-7866··UNKNOWN5568 River RoadSEATTLEWA98144·UNKNOWNN/A··
TPATPA-509882026-04-16T02:43:54ZPerez, Ann——1999-12-05——N/Aann.perez21@outlook.com352 Elm StreetDenverColorado80229—UNKNOWN
TPATPA-529172026-09-21T13:47:36ZPamelaCLawrence2001-03-23-•••-••-7775—NULL1587 Lincoln Way··MinneapolisMinnesota55461-MEDICARE-ADV-B
TPATPA-585602026-08-02T16:01:44Zjefrfey—wells1992-30-12-•••-••-572815047408272··NULL6803 APACHE BOULEVARDSAN ANTONIOTX78272-3309··null
TPATPA-585362026-03-16T05:27:06ZPatrick—Valdez2004-08-20···NULL•••-••-5939(596) 324-6416NULL·4711 Pine DrColumbusOH43210-9118nullUNKNOWN
TPATPA-584962026-01-17T01:37:14Zann—kennedy1955-04-17UNKNOWNUNKNOWN-UNKNOWN5760 Cedar Ln··ChandlerAZ··—MEDICARE-ADV-B
TPATPA-623002026-03-31T02:11:17Z·MARTHA—HARVEY1949-05-15·UNKNOWNN/A—MARTHA.HARVEY77@AOL.COMNULLUNKNOWNNULL-N/A··null
TPATPA-58778 2026-10-04T02:01:47Zlisa—dunn·1940-11-09—•••-••-7357(691) 574-3293-999 River RdAUSTINTX78730-—
TPATPA-552372026-05-27T05:09:12ZMariana··Park·2000-05-15NULLUNKNOWN3823530792··—491 Sage CtDALLASTX75221-8390—null
TPATPA-629162026-10-05T20:01:54ZBrian—Little2007-11-25——3942717446—7536 Mesa DriveOrlando··FL32860GRP-5770UNKNOWN
TPATPA-508282026-08-19T01:32:55ZSTEPHANIE—COLESep 22, 1997UNKNOWN•••-••-9584UNKNOWN—4353 OCEAN AVENUEHOUSTONtx77031·-N/A··
TPATPA-572462026-10-16T06:57:11ZLOGANVJORDAN·1963-01-14NULL•••-••-2362(942) 224-3560null3273 Hillcrest RdLos AngelesCA90039NULLN/A
TPATPA-640362026-01-18T16:02:27ZEvelyn—GuzmanJul 11, 1990N/AN/A——5792 Bayshore Drive #818SeattleWA98178-4618null··N/A
TPATPA-600952026-03-24T10:14:03ZKATHLEEN—WRIGHT2005-08-02nullNULL—UNKNOWN1377 Desert Sky BlvdTucsonAZ85732UNKNOWN-
TPA TPA-551872026-07-30T14:49:47ZBARBARA—YANG2003-08-06UHC-42370-87•••-••-2437(835) 352-5565-·2610 Palm Dr #461SacramentoCA95809GRP-9595····
TPATPA-550462026-03-08T00:05:47Zterry—arnold—N/A•••-••-5838UNKNOWNUNKNOWN——-··nullNAVIGATE-HMO
TPATPA-557772026-05-25T06:27:09ZAnnPDunn··09/05/47——(955) 800-7751ann.dunn22@hotmail.com8837 Harbor BoulevardEden Prairie··MN55380UNKNOWNOPTIONS-PPO
TPATPA-546322026-01-14T17:50:20Z·harold—rojas·-N/ANULL——1296 Forest Avenue··SAN ANTONIOTX78283NULL-
TPATPA-627062026-10-05T17:08:12ZSharon—Luna12/02/1957N/AN/AUNKNOWN··9300 Maple AvenueLas Vegas··NV··89138NULLMEDICARE-ADV-A
TPATPA-591952026-02-23T09:34:56ZSAMANTHA—WARD1988-04-23—•••-••-0620NULL—2150 Church StreetGilbertAZ85211-·CORE-HMO
TPATPA-627622026-04-22T23:29:25Z·DANIEL—SILVA1985-06-21———UNKNOWN8847 Valley View DrPhoenixAZ85042N/ANULL
TPATPA-602882026-07-26T20:45:25ZHall, Brandon——1997-08-11··N/Anull921-493-7486-1192 Union StChandlerAZ85280GRP-6416NAVIGATE-HMO
TPATPA-607212026-08-25T15:47:24ZSTEVE—BOYD08/18/07—N/AN/A—283 SPRING STPlanotx75094—N/A
TPATPA-641162026-04-28T11:07:39ZSpencer, Karen——1969-12-21null-····karen.spencer54@gmail.com1338 CEDAR LNPhoenixAZ85004——
TPA TPA-622502026-09-08T17:00:05ZDANIEL—THOMPSON7/13/1954——N/ANULL3387 BASELINE RDLAS VEGASNVNULLGRP-1100SELECT-EPO
TPATPA-620522026-02-05T10:26:13ZAustinRMedina06-03-1954——+1 802 709 8372—4470 Main St #614FresnoCA93780nullN/A
TPATPA-569982026-01-10T10:25:27Zcharlotte—lopez07-05-1954—NULL-—4337 Sage CourtHoustonTexas77053nullNULL
TPATPA-641532026-07-23T13:20:29ZPaul—Gutierrez1949-04-03-UNKNOWNNULLNULL1811 Mountain View DriveChandler·AZ·85263—OPTIONS-PPO
TPA TPA-557102026-05-31T06:10:05ZChristopher—Thomas1964-04-22UNKNOWN———1594 JEFFERSON AVESan DiegoCA92197-8041··N/A—
TPATPA-501132026-09-05T05:12:51ZEMA—GUTIERREZ19680212UHC-12397-86NULLUNKNOWNemma.gutierrez@aol.com··9308 Indian School RoadTAMPAFL33653N/AN/A
TPATPA-599612026-04-05T01:46:58ZNoah—·Sanchez19891024NULL•••-••-6715632.479.8982—8247 RIDGE RDLos AngelesCA90056UNKNOWNUNKNOWN··
TPATPA-600362026-01-01T10:26:27ZBaker, Julia——1975-07-01N/ANULL——659 Central Ave #111GlendaleAZ85321GRP-4028—
TPATPA-544632026-02-05T17:38:10ZSANDRA—TUCKER1962-06-06N/A—N/ANULL4843 Grand AvenueSan DiegoCA92176GRP-3107—
TPATPA-565352026-01-08T14:22:44ZamandaD.martinez8/3/1960N/A-··—null7043 Forest AvenueGLENDALEAZ85321GRP-4170OPTIONS-PPO
TPATPA-54814 2026-06-05T19:32:31Zgloria—gordon1952-09-04··•••-••-7351null—9544 Camelback RoadOrlandoFL32849N/A··N/A
TPATPA-607602026-07-26T13:16:27Z BRUCE—SMITH1994-02-20—-(935) 315-6705N/A959 Baseline RoadEDEN PRAIRIEMN—·-choice-plus-ppo
TPATPA-642152026-03-07T00:07:35ZDiane—Chavez09/18/1971——N/ANULL7566 MOUNTAIN VIEW DR··JacksonvilleFL32255null—
TPATPA-611602026-06-12T04:30:49ZMICHAEL—CHAPMAN1980-02-27UHC-12278-83•••-••-0190215-787-3890UNKNOWN··9642 Washington StreetEDEN PRAIRIEMN55324-1251null—
TPATPA-547912026-03-20T08:48:31ZGarza, Kathy——·1962-07-25-—NULLkathleen.garza84@icloud.com··5978 ELM STREET #673San DiegoCA92113nullNULL
TPATPA-614352026-01-02T01:05:20ZHiroshi—Henderson1981-04-02·NULLNULL710-665-3795HIROSHI.HENDERSON@OUTLOOK.COM7926 Camelback Rd··TUCSONAZ85740GRP-7878MEDICARE-ADV-A
14,474 rows, page 213 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:56.147Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty