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-551112026-08-22T03:59:46ZCHRISTOPHER—WEST9/19/2008—····7029951507UNKNOWN9858 SPRING STREETTucsonAZ··85745NULLNULL
TPATPA-606362026-08-28T22:36:19ZLaura—Patterson2006-10-22—•••-••-5988—··—UNKNOWN——-UNKNOWN
TPATPA-575352026-01-04T10:15:16ZPrice, RuthZ.—1971-01-26—-(343) 895-0785—4460 MESA DRLAS VEGASnv89187NULLMEDICARE-ADV-A
TPATPA-534852026-08-25T18:16:47ZLee, Michelle——02/03/52-null--88 Highland AvenueCharlotteNC28211····N/A
TPATPA-628522026-03-18T08:41:25Z·HANNAH—DUNN2004-02-01N/AUNKNOWNnullNULL310 Church StAustintx78715—core-hmo
TPATPA-546952026-09-13T04:37:03ZAaron—Reid1996-12-22UHC-63780-47•••-••-12737123040949aaron.reid15@hotmail.com9152 Jefferson AveMesaAZ85276-9616UNKNOWNMEDICARE-ADV-A
TPATPA-538522026-09-03T02:28:26ZHiroshi—Mejia1996-05-02—-4573777660··NULLNULL—-UNKNOWN··GRP-1365UNKNOWN
TPATPA-638952026-03-10T19:49:46ZPamela—Young1969-50-14null——·PAMELA.YOUNG@YAHOO.COM3553 RIVER ROADColumbusOHUNKNOWN-····
TPATPA-589662026-02-17T19:00:11Z·saraZharvey2/18/1984UNKNOWNnull·(624) 543-1462sara.harvey@gmail.com8811 Church StDENVERCO80257GRP-9521MEDICARE-ADV-B
TPATPA-636512026-06-25T05:27:45ZRICHARD—ROBERTSON1966-12-04N/A•••-••-4973UNKNOWNNULL7513 Mesa DriveSeattleWA·N/A—null
TPATPA-561962026-06-29T12:35:24Z·Sam—Garcia05-05-1939-·null——8620 MEADOW LANESeattle·WA98137··CHOICE-PLUS-PPO··
TPATPA-516042026-10-08T22:02:48ZBurke, Christina—····1976-06-13··null—14377423752··UNKNOWN5791 Cedar LaneGLENDALEAZ·85314GRP-7752-
TPATPA-635342026-04-18T17:57:30ZPatricia—Mendez1987-03-22—-NULLN/A—null—····——
TPATPA-536352026-09-13T21:25:16ZElizabeth—Ramirez11-01-2001··UHC-37122-33—UNKNOWN·ELIZABETH.RAMIREZ@HOTMAIL.COM2787 Indian School RdAustinTX78741—null
TPATPA-634912026-08-25T22:27:50ZWilson, Julie—··1948-09-17null-N/A—6180 CANYON RD Apt 16·OrlandoFL32839NULLMEDICARE-ADV-B
TPATPA-63243 2026-01-22T06:56:58ZJACK—·PIERCE01/01/96——3499282769NULL8375 Spring StEden PrairieMinnesota55337··-MEDICARE-ADV-A
TPATPA-529792026-02-21T22:56:45ZDIANA—JAMES1952-05-22UNKNOWN•••-••-970113729253890N/A3640 Sage CtGlendaleAZ85358nullUNKNOWN··
TPATPA-528362026-01-29T06:32:27ZELIZABETH—MCDONALD1992-08-18··UHC-98519-77-919.361.6244elizabeth.mcdonald77@yahoo.com8972 BroadwayTucsonAZ85719UNKNOWN·NULL
TPATPA-567712026-06-09T06:41:40ZDANIEL—MYERS--•••-••-4500+1 324 879 2863N/A2242 Camelback RoadGilbertAZ85258·GRP-6750null
TPATPA-628202026-10-10T12:06:08Z·Denise—Tran19940908N/A——NULL7545 Spring StSan AntonioTexas·78264-N/A··
TPATPA-559822026-03-05T08:30:01Zbeverly—elliott1993-12-28—•••-••-4853——4808 Lincoln WayMINNEAPOLISMN55464··GRP-0848—
TPATPA-549292026-04-21T16:59:49ZDaniel—Martinez03/07/90N/A•••-••-4499——8221 Willow CtPhoenixArizona85001··NULL
TPATPA-602762026-04-29T18:27:25ZSTEPHEN—FERNANDEZAug 17, 1944NULL•••-••-3420UNKNOWNNULL5103 LAKE VIEW ROADPhoenixAZ85072—MEDICARE-ADV-B
TPATPA-550682026-01-02T04:22:04ZTERESA—LEWIS26-06-2000—-nullnull7045 Meadow Ln·DallasTX75282GRP-8942CORE-HMO
TPATPA-614652026-03-22T11:21:23ZRalph—Andrews·09/20/1953UNKNOWN—212-227-8055UNKNOWN-N/ANULLUNKNOWN-null
TPATPA-501722026-09-25T04:59:33Zralph—·elliott1993-06-26UHC0674967··UNKNOWN—ralph.elliott55@gmail.comN/A—nullN/AGRP-9415MEDICARE-ADV-A
TPATPA-614082026-01-07T07:54:59ZAlexaner—Palmer03/01/1984UNKNOWN———8899 Apache BoulevardDallasTexas-GRP-3790··MEDICARE-ADV-A
TPATPA-562242026-01-03T15:26:17Z·MARY—OWENS1943-01-19N/A····647-908-2878mary.owens77@yahoo.com726 SUNSET BLVDAtlantaGA30394N/ASELECT-EPO
TPATPA-639762026-09-29T12:16:33ZAndrew—HoffmanJan 28, 2004-•••-••-8412··null8112 Meadow Ln··Tampa··Florida33690GRP-1586—
TPATPA-593982026-04-21T03:03:50ZREBECCA—MURRAY09/21/02··null•••-••-0693—null··6746 Lake View RoadSan AntonioTexas—GRP-5058null
TPATPA-622992026-10-17T10:34:07ZHENRY—NGUYEN18-03-2002—•••-••-4783484-310-9592—5080 Canyon RoadCOLUMBUSOhio43273GRP-6641—
TPATPA-523252026-07-20T11:02:49ZWatson, Kathryn——2004-11-20-UNKNOWN628.751.2246·null3234 Palm DrCharlotteNC·28211—UNKNOWN
TPATPA-637212026-01-06T03:59:03ZMarrk—Gardner1966-02-12——(314) 576-0286-607 Harbor BoulevardCharlotteNC-GRP-9684··
TPATPA-61873 2026-05-26T13:14:36ZEstrada, Katherrine—····1969-09-09—N/A5177047628UNKNOWN3002 ELM STREETDallasTX75262GRP-2958NULL
TPATPA-565322026-08-25T15:06:54Z deniseQharrison19770112UHC-02609-73UNKNOWNNULLDENISE.HARRISON@GMAIL.COM——NULL·-NULL-
TPATPA-536682026-10-13T09:37:48ZCAMILA—LUCAS1959-11-09··UNKNOWN-N/A—1620 JEFFERSON AVEDallas··tx75232—·CHOICE-PLUS-PPO
TPATPA-553802026-05-14T09:30:53Z WAYNET.GREENE1964-05-20··nullnull-5071 Cedar LnNashvilleTN37279nullNULL
TPATPA-553562026-03-12T04:28:17ZSharonJ.Duncan22-04-1994——(858) 675-5796sharon.duncan@hotmail.com1226 Mountain View DriveGILBERTAZ85228—CHOICE-PLUS-PPO
TPATPA-571892026-07-06T19:18:44ZJohn—Ramos·1991-11-26—NULL205.802.6242—626 Grand AvenueTampaFloridaNULLGRP-4342SELECT-EPO
TPATPA-512062026-07-28T16:59:29ZLAWRENCE—NICHOLS1994-01-19—•••-••-6994—null1338 Union Street Apt 37OrlandoFL32862GRP-3945null
TPATPA-624772026-07-18T07:51:34ZRebeccaCHamiltonFeb 23, 1954——(215) 519-3615—2665 Indian School RdPlanoTX75019N/A—
TPATPA-525642026-03-06T20:04:31ZEugene··Foster24-03-1959UHC-01745-69··UNKNOWN685-688-6984UNKNOWN6273 Central AvenueSacramentoCA95833-9298—N/A
TPATPA-631742026-03-10T04:27:30Z·JESSICA··WARREN7/17/1986··NULL··—UNKNOWN—7351 River RdPlanoTX75013null-
TPATPA-627942026-08-23T18:59:11Zlori—miller1942-02-11N/A··•••-••-9796——138 Harbor BoulevardNashvilleTN37242NULLCORE-HMO
TPATPA-562302026-07-05T02:52:52ZHENRY—REYNOLDS08/03/02-—976-488-8719UNKNOWN698 Mountain View DrDALLASTX75273N/AUNKNOWN
TPATPA-610722026-06-29T23:58:34ZMateo—Dean2000-12-27NULL——mateo.dean@proton.me493 Forest AvePLANOTX75046N/A—
TPATPA-559692026-03-03T22:06:39ZMary—Cox19900803··null•••-••-7285N/A—NULLnull—nullN/Anull
TPATPA-523682026-09-29T05:46:50Zdouglas—sims1955-11-20NULLNULL(853) 594-2098-9415 Baseline RdChandlerArizona85238GRP-1359—
TPATPA-522992026-10-09T05:59:33ZHarnandez, Keith——1998-11-21UHC-09533-29N/A··—NULLN/A-·NULLN/AGRP-1319-
TPATPA-577342026-04-04T20:18:07ZJudy—Vega1996-03-15··-N/A—N/A-null·null—GRP-8359N/A
14,474 rows, page 276 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:43:03.451Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty