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-520142026-07-19T20:23:32ZKenneth—Jordan19630922···NULL—(355) 855-2864··—3273 Canyon RoadMinneapolisMN55437UNKNOWN·NAVIGATE-HMO
TPATPA-520922026-01-14T09:23:55ZSchmidt, Bradley——·04/16/54·-····N/AN/A—-N/A··NULLnull··N/A
TPATPA-607782026-05-12T16:13:34ZOlivia—Wheeler1965-10-28—nullNULL-8573 Ridge RoadMesaAZ85217NULLNULL
TPATPA-616102026-02-23T11:45:13Z—G—04-02-1978—•••-••-4414—·NULL3675 Sage CtTucsonAZ85780NULL····
TPATPA-536992026-07-11T06:49:09ZAdams, Jacqueline——1996-06-09NULL—(451) 722-3182jacqueline.adams@hotmail.com5404 Spring StreetHoustonTX77067··NULL—
TPATPA-584102026-03-05T17:53:46ZNicole—Carr1961-06-14UNKNOWN•••-••-7392·-NULL7331 Pine DrPhoenixAZ85053nullMEDICARE-ADV-B
TPATPA-566282026-10-04T07:15:04ZCarter, Amanda——2008-02-14———N/A—--NULLGRP-1951—
TPATPA-550132026-04-10T02:39:53ZBilly—AlexanderApr 5, 1946UHC-77283-87NULL(481) 481-7040—1182 Central AveTampaFL33694-N/A
TPATPA-544202026-08-30T15:34:29ZRuth—Herrera02/24/1960··NULLUNKNOWNUNKNOWNnull6473 CEDAR LNMinneapolisMN55477—·OPTIONS-PPO
TPATPA-609582026-09-10T03:18:05ZJUDITH—MARTINEZ1993-09-16-NULL660-829-4651N/A—UNKNOWNUNKNOWN—GRP-4866—
TPATPA-575662026-03-01T10:18:26ZphilipC.··ross1944-12-11—-3545478928UNKNOWN3455 Park PlaceTucsonAZ85773····
TPATPA-559242026-05-29T19:57:48ZCamlia—Marshall08-01-1940N/A··N/A-UNKNOWN3494 Ridge RdMiamiFL33128GRP-9581-
TPATPA-582282026-10-01T01:39:19ZBurce—Gray1997-05-17—··—NULL3961 BASELINE RDMinneapolis··MN55410GRP-5426NULL
TPATPA-583882026-02-26T14:03:34ZHiroshi—Espinoza09-12-1997NULL—(925) 849-5433null2482 Mesa Dr #998··TEMPEAZ85226GRP-4095SELECT-EPO
TPATPA-545982026-03-22T06:33:03ZNathan—Hall··1939-08-26nullNULL—NULL7748 BAYSHORE DRIVEAustinTX78735nullnull
TPATPA-640282026-09-21T08:59:18ZCHRISTINE—COOPER1963-04-27UNKNOWN-836-676-7236UNKNOWN4649 CAMELBACK ROADTAMPAFL33646GRP-5756SELECT-EPO
TPATPA-510622026-03-03T15:18:22ZEvelynPFisher2005-10-08UHC-52353-84-NULL—489 Highland AveSacramentoCA··95826——
TPATPA-63964 2026-03-29T08:11:26ZLAUREN—MEDINA1962-06-02NULLNULL7458414713—2179 BAYSHORE DRPhoenixAZ85086GRP-8740MEDICARE-ADV-B
TPATPA-628352026-08-01T21:13:34ZJOE—·RICCE12-06-1994N/ANULLNULLNULL1843 Bayshore DriveTucsonAZUNKNOWN—OPTIONS-PPO··
TPATPA-582232026-02-01T10:46:35ZScott—Hicks21-05-1975N/Anull—null3977 WASHINGTON STSeattlewa98149GRP-3508—
TPATPA-605382026-09-25T08:43:39ZSandra—Reed04/05/85—UNKNOWN(421) 761-0275UNKNOWN····N/A—NULL·-CHOICE-PLUS-PPO
TPATPA-574342026-04-18T18:51:02ZBeverly—Bennett1948-08-14·N/Anull13645788323beverly.bennett@gmail.com4158 INDIAN SCHOOL RDDENVERCO80291····MEDICARE-ADV-A
TPATPA-586922026-04-16T16:50:16ZJONATHAN—PETTERS1994-07-26—•••-••-2548NULL—4899 Indian School RdLos AngelesCA90066null—
TPATPA-580222026-07-27T07:08:21Z·Ronald—Hoffman3/11/1979—•••-••-0770(865) 215-9800—4022 Park PlaceAustinTX78792-0443GRP-6141··MEDICARE-ADV-A
TPATPA-535462026-07-01T23:27:11ZSTEPHANIE—RYAN1999-09-22——+1 303 752 5432—4072 MARKET STREETMiamiFL33185—OPTIONS-PPO
TPATPA-573582026-10-07T18:13:39Zrilay—donna1995-08-28nullUNKNOWN—N/A4358 Forest AveTucsonAZ—UNKNOWN—
TPATPA-522862026-01-15T22:49:19Z ·DOROTHY—GRY·1945-08-20—N/A——UNKNOWNN/Anull—UNKNOWNMEDICARE-ADV-B
TPATPA-598132026-04-01T11:40:49ZHeather—Cox19570925N/A—NULL—613 Ridge RoadLos AngelesCA90008GRP-2435MEDICARE-ADV-A··
TPATPA-574492026-08-18T06:22:31ZkathrynE.willis1976-11-17N/AUNKNOWN9825227898—·1590 Sunset BoulevardColumbusOH43228GRP-7218CORE-HMO
TPATPA-644312026-02-28T09:16:16ZJoseph—Payne07/21/1971--(860) 336-9247NULL8176 HILLCREST ROADORLANDOfl32897UNKNOWNN/A
TPATPA-500772026-07-14T21:31:42ZTeresa—FranklinSep 27, 2006UHC-79947-46•••-••-98274965056080teresa.franklin45@aol.com4892 BROADWAYOrlandoFL··32896UNKNOWN·MEDICARE-ADV-A
TPATPA-545032026-06-03T04:06:07ZJoan—Brown2002-09-03UHC-09520-95—+1 453 697 7100··--—null·-null-
TPATPA-541882026-05-13T04:01:09ZJoan—Garrett3/20/1950—N/A····—9201 Cedar LaneAustinTX78750—null
TPATPA-517482026-04-20T10:39:10ZJEREMY—SNYDER1997-11-27UHC-72167-18NULLnullnull4178 Park PlJacksonvilleFL·32209-4768—medicare-adv-b
TPATPA-506582026-08-17T11:32:23ZCheryl—Cunningham1949-09-03UHC-44238-01—-····1762 Cedar LaneChandlerAZ85280UNKNOWN—
TPATPA-500592026-08-16T19:30:43ZAMBERO.SCHULTZFeb 21, 2006—NULL(846) 964-8188··1979 Washington St Apt 2Miamifl·33176—OPTIONS-PPO
TPATPA-509522026-07-29T03:57:13ZBenjamin—OBrienAug 21, 1938UNKNOWNnull501-934-8070—3925 CENTRAL AVEGLENDALE·AZ85387GRP-4912OPTIONS-PPO
TPATPA-625622026-03-16T08:02:43Zolivia—gilbert1972-07-07null•••-••-88652306390465—UNKNOWN—-··UNKNOWN—
TPATPA-511602026-08-05T14:13:59ZANTHONY—MERTINOct 23, 1982null•••-••-0160——2343 OAK STREETPhoenixAZ85045-2771—·MEDICARE-ADV-A
TPATPA-619172026-02-23T19:49:55ZCATHERINE····WHEELER1952-10-07NULL•••-••-5827(803) 319-4021UNKNOWNUNKNOWN——UNKNOWNGRP-0257MEDICARE-ADV-A
TPATPA-574472026-02-17T14:59:05ZJERRY—HUGHES1983-05-26N/A——-1707 Hillcrest RdSeattleWA98147·GRP-5996-
TPATPA-585712026-09-27T00:05:22ZDoris—Fernandez04-02-2003·UHC-98369-55null····null5596 Bayshore Drive Apt 40JacksonvilleFL··32268—NULL
TPATPA-52654 2026-04-30T22:19:32ZLARRY—BOWMAN22-10-1973NULL•••-••-3001—larry.bowman45@icloud.comUNKNOWN—null—NULL—
TPATPA-545112026-03-06T23:25:02ZMorrison, DebbieZ—18-03-1975····•••-••-6501—N/A8651 Central AveTempeAZ85298nullMEDICARE-ADV-A
TPATPA-613842026-04-22T14:27:06ZRichard—Burke1947-04-17NULL—6136855808N/A7848 Central AvenueCHARLOTTENC28283-3638N/A··-
TPATPA-640762026-01-15T03:22:15ZMELISSA—MEDINADec 23, 1972null—NULLUNKNOWN670 Sage CtGlendale··AZ85359GRP-9478—
TPATPA-528642026-09-09T08:06:13ZGreene, George——Jan 17, 1953—null·UNKNOWN—2020 UNION STREETSeattleWA98198GRP-2094null
TPATPA-600712026-04-27T01:19:58ZSean—Ray1970-02-01—NULL574.545.2514·sean.ray78@outlook.com8684 Desert Sky BoulevardCOLUMBUSOH43224UNKNOWNMEDICARE-ADV-B
TPA TPA-64006 2026-08-18T15:08:35Zwilliam—vargas1981-12-28—UNKNOWN527-442-1061WILLIAM.VARGAS55@OUTLOOK.COM24 Forest AveGilbertAZ85207—MEDICARE-ADV-B
TPATPA-588852026-06-03T01:53:51ZWei—Griffin7/13/1983null····nullWEI.GRIFFIN@HOTMAIL.COM6937 UNION ST·Houston·TX77001GRP-9904UNKNOWN
14,474 rows, page 23 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:36.702Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty