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-585352026-09-06T23:30:49ZPAT—VALDEZ2004-08-20—N/A5963246416patrick.valdez@gmail.com4711 PINE DRColumbusOhio43210··N/A
TPATPA-614522026-07-12T07:22:02ZKylePFields1951-05-23UHC-45606-15NULL12297733888··—7188 BroadwayPlanoTX75098GRP-9139MEDICARE-ADV-A
TPATPA-637672026-03-18T17:04:04ZPatrick—Moales·19660501—NULL18953673611—1729 Central AveSacramentoCA95803N/Anull
TPATPA-543802026-05-07T05:38:24ZDEBRA—ROJAS1942-07-15UHC-41714-20null-UNKNOWN2800 SAGE CT #427Las VegasNV89182··—N/A··
TPATPA-553662026-01-09T17:40:55Z Evelyn—Gonzales19620220——null—942 Valley View DriveSan AntonioTX78274null—
TPATPA-551752026-06-12T12:16:11ZAlcieQOrtega1/20/1948-N/A756-766-5648alice.ortega@icloud.comN/AN/A·NULLnullNULLMEDICARE-ADV-B
TPATPA-611672026-08-11T03:14:42ZKeith—Collins12/13/1980—NULL(802) 872-9234null7882 Lincoln Way Apt 14PlanoTX—null-
TPATPA-63307 2026-04-10T02:15:01ZFatima······Anderson1996-07-03UNKNOWNN/AN/AUNKNOWNnull··N/A—null——
TPATPA-517622026-02-07T14:01:32Z·sandra—fuller09/17/83··UHC-21692-45nullN/AUNKNOWN2866 Bayshore DrLos AngelesCA90064-2827—CHOICE-PLUS-PPO
TPATPA-560272026-01-04T20:30:06Z laura—mendez1995-12-09NULL•••-••-92582995950017·N/A5085 Bayshore DrPhoenixAZ85046--
TPATPA-524872026-06-28T04:54:42ZANDY—DAVIS1980-03-19NULLNULL940.465.9477—1983 Oak StreetTucsonAZ85725-null
TPATPA-527732026-06-08T20:35:07ZLOGAN—LUCAS9/26/1985—N/A929-522-3998—3084 DESERT SKY BOULEVARDMesaArizona85281nullNAVIGATE-HMO··
TPATPA-52045 2026-06-22T11:11:19ZKATHLEEN—OBRIEN2/5/1988NULLN/AN/A··9351 ELM STLos AngelesCA····GRP-7528··
TPATPA-604652026-06-24T01:56:20ZDennis—Alvarez1979-08-21UHC-79179-52•••-••-1031--·3110 Desert Sky Blvd·Planotx75063null-
TPATPA-597412026-02-23T07:17:01ZMARTHA····REID1981-01-12N/A—UNKNOWN··UNKNOWN·1230 Camelback RoadAtlantaGAnullUNKNOWNSELECT-EPO
TPATPA-573742026-06-19T20:50:09ZGREGORY—LAWSON07-06-1967—•••-••-7641—GREGORY.LAWSON@ICLOUD.COM3612 Palm DriveTUCSON·AZ85710—NULL
TPATPA-521202026-04-23T18:57:03ZGABRIEL—ROBINSON1952-09-09NULLnull9824779733——NULLUNKNOWN-UNKNOWNSELECT-EPO
TPA TPA-644412026-01-19T04:51:25ZRichard—Lucas1947-06-12NULL•••-••-2590·null-·6760 HILLCREST ROADLas VegasNV89143N/A—
TPATPA-609832026-06-24T22:41:36ZNICOLE—·GILBERT1951-01-25NULL-NULL———NULL—N/A—
TPATPA-563282026-06-30T01:47:52Z·LINDA—WEAVER2008-05-21—•••-••-45315002717806N/A3756 Meadow Ln Apt 40PLANOTX75057——
TPATPA-529312026-08-07T23:06:46Znicole—burke04/14/1985··—NULL(904) 985-4277UNKNOWN7663 River RdOrlandoFlorida32872—N/A
TPA TPA-571332026-04-02T19:34:06ZCarl··—Wang04/05/1944—N/A—carl.wang@gmail.com8827 RIVER RDOrlandoFL32800-3587N/A-
TPATPA-634882026-07-08T13:41:54Zrachel—griffin1997-03-14—•••-••-9792595-987-5403NULL8748 Hillcrest RoadAtlantaGeorgia30390null—
TPATPA-523472026-05-07T09:41:56ZSantiago··Gardner1988-07-05UHC-96725-82null622-251-6731—628 OAK STREETSan AntonioTX78217nullOPTIONS-PPO
TPATPA-512822026-10-18T06:34:46ZPATRICIA—DELGADO1969-11-05····-nullUNKNOWN4110 Hillcrest Rd··TampaFL33667GRP-4400UNKNOWN
TPATPA-574662026-03-09T15:49:43ZAlexanderH·Gray1940-05-01N/A—-null9441 Willow CourtMINNEAPOLISMN··55455GRP-3053SELECT-EPO
TPATPA-533532026-02-15T01:58:01ZGraham, Emma··—1978-09-13N/A—null—6542 Central AvenueGlendaleAZ85306null—
TPATPA-633152026-06-09T15:29:18ZJOHN—MATTHEWS·1957-08-27UNKNOWN•••-••-8653null-5065 Indian School Rd··PlanoTexas75029·GRP-9140-
TPATPA-507852026-01-08T12:30:45ZSarah—Lawson9166-05-06—N/AUNKNOWNnull3210 Market StNashvilleTN—-NAVIGATE-HMO
TPATPA-528232026-03-21T13:43:52Z Billy—Hunt1995-07-25N/A··•••-••-5328UNKNOWN————UNKNOWNnull—
TPATPA-557982026-05-08T06:42:20ZGibson, Roger——Dec 6, 1942null—nullNULL2278 Canyon Rd··San DiegoCA··92154-6728NULLN/A
TPATPA-576192026-01-22T13:19:25ZArjun—Holmes··11/22/1978-—UNKNOWN··—5851 MAIN STREET #229GlendaleAZ85333N/ACORE-HMO
TPATPA-521922026-03-20T13:55:47ZArthur—ContrerasOct 20, 1943—-333.994.8394null3294 Baseline RoadJacksonville··FL32277nullN/A
TPATPA-581682026-09-22T12:15:16ZRalph··—Knight1995-10-12N/A—nullUNKNOWN7040 Palm Dr··DENVERCO80237·GRP-6349—
TPATPA-588942026-07-15T19:21:13ZHEATHER—FREEMAN1961-09-08-•••-••-35352063831906HEATHER.FREEMAN46@PROTON.ME2537 GRAND AVEOrlandoFL32846—UNKNOWN
TPATPA-561522026-07-12T00:56:29ZJOYCE—REYES2008-12-04—•••-••-0209—joyce.reyes86@proton.me1156 BroadwayDallasTexas-NULLCORE-HMO
TPATPA-579882026-05-25T01:59:07ZLUCIANMONTGMOERY12/09/47NULL—+1 651 739 0159N/A2513 HARBOR BLVDHoustonTX77084-5814—··
TPATPA-58565 2026-06-03T23:03:18ZJerry—Lane1949-10-23———-2060 OCEAN AVEOrlandoFL32820UNKNOWNN/A
TPATPA-566112026-09-03T04:05:42ZDENISE—WELLS1998-09-06—•••-••-7438UNKNOWN··8604 Lincoln Way Apt 27COLUMBUSOHUNKNOWN-CORE-HMO
TPATPA-580632026-05-16T10:12:42ZBRENDA—THOMPSON01/18/1986—•••-••-1590null—7461 Lincoln WaySeattleWA98165—CORE-HMO
TPATPA-592532026-10-16T18:25:36ZJoshua—Williamson1987-07-19—•••-••-1163—joshua.williamson77@aol.com··2202 Apache BoulevardJacksonvilleFL—UNKNOWN··CHOICE-PLUS-PPO
TPATPA-60813 2026-09-28T16:40:29Zkenneth—reynolds1947-05-04NULL•••-••-7562——1528 Jefferson AvenueGILBERT··AZ85211NULL—
TPATPA-597242026-01-30T02:25:47Zjoan—edwards07/06/1956UNKNOWNNULL····null4205 UNION STREETDallasTX75293UNKNOWN-
TPATPA-581702026-01-26T06:58:22Z———19940207null•••-••-0901nullN/A5068 Ocean AvenueDallasTX75218—null
TPATPA-508912026-01-01T10:32:22ZRAYMOND···HART1973-03-08UNKNOWNNULL441-406-2269raymond.hart78@icloud.com2095 MARKET STREETEden Prairie·MN55309——
TPATPA-517712026-09-04T14:52:13ZGABRIELCPAYNE1954-05-06-——gabriel.payne92@icloud.com379 Spring StSan DiegoCA92184···NULL—
TPATPA-516052026-02-28T18:34:08ZVICTORIA—MOORE2003-01-28—··4370809null-·-NULLN/AUNKNOWN—
TPATPA-600222026-04-10T07:56:04ZTerry··Wlsh19610719—•••-••-60328695095746-NULLUNKNOWN—-—N/A
TPATPA-583512026-03-05T18:19:53ZAndrews, Logan——1991-09-19—·-N/AUNKNOWN1378 Park PlTempeAZ85202——
TPATPA-563602026-09-08T23:24:34ZGEORGE—TORRES1964-05-20N/A•••-••-6914929.416.2649—4804 Market StMesaAZ85267GRP-8333UNKNOWN
14,474 rows, page 30 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:37.721Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty