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-600832026-02-27T08:09:26ZRuth—Jackson8/16/2003—•••-••-0932(724) 812-1502NULL4532 Jefferson AveMesaAZ85236··N/A
TPATPA-582132026-03-20T07:13:34ZJessica—Adams1961-07-22UNKNOWNUNKNOWNN/AN/A1007 Oak StreetColumbusOH43251N/A—
TPATPA-547792026-03-21T19:58:00ZDina—Chapman08-02-2000—•••-••-7129+1 632 227 2810··NULL—····—GRP-0542NULL
TPA TPA-507882026-02-14T07:24:07ZSaraE.Ortega09/16/54N/AUNKNOWN(625) 932-6223UNKNOWN8418 Lake View RdScottsdaleAZ85269GRP-9604-
TPATPA-558192026-01-02T04:15:11ZFrances—Fields19521104null—N/Afrances.fields@aol.com565 MAIN STTEMPEAZ··85239GRP-6416MEDICARE-ADV-A
TPATPA-633872026-03-30T09:10:17ZKAYLAOWILLIAMSON1993-02-05N/A--kayla.williamson3@yahoo.com5310 Indian School RdSan DiegoCA92184NULL-
TPATPA-642432026-02-09T15:41:09ZJOHN—LUNA1982-01-25—•••-••-1762UNKNOWNUNKNOWN2837 Jefferson AveMesaAZ85294UNKNOWNOPTIONS-PPO··
TPATPA-591862026-09-13T01:09:07ZANDREA—PETERS1962-05-26N/A—N/A-5022 Lake View RoadTAMPAFL33675··nullNULL
TPA TPA-594622026-05-02T06:03:09ZMariana—Nguyen08/06/1945-NULL——9516 Ocean AvenueChandlerAZ··85250GRP-9502MEDICARE-ADV-A
TPATPA-634582026-04-06T23:49:15Z Diane—Le26-09-1952—•••-••-1083N/A—4863 River RoadGILBERT··Arizona85227—-
TPATPA-575752026-08-08T05:03:10ZFrancesNMoreno1978-09-23—··—FRANCES.MORENO94@GMAIL.COM3535 GRAND AVENUETempeAZ85289··—NAVIGATE-HMO
TPATPA-518272026-01-02T08:51:59ZPhilip—Nichols1988-04-04N/A··•••-••-3348N/ANULL5140 PARK PLSan DiegoCA92155GRP-2166MEDICARE-ADV-A
TPATPA-55165 2026-03-04T19:20:30ZAndrew—Phillips1942-07-11——null-·7022 Grand AveMiamiFL33145GRP-8618-
TPATPA-535972026-09-06T00:29:05ZAlanEHarrison··1954-01-20N/A-——3847 Grand AveNashvilleTN37253—····
TPATPA-622002026-02-27T13:24:42ZMargaret—Ryan1961-09-12NULL•••-••-4145+1 241 885 7734··—3627 Mountain View DrNASHVILLETennessee37229—OPTIONS-PPO
TPATPA-566502026-06-03T14:48:50ZReid, DaniielK.—1939-01-23UHC-18514-12—(477) 524-0045··NULL8395 CAMELBACK ROADCOLUMBUSOH43209UNKNOWN—
TPATPA-58663 2026-01-26T15:48:30ZArthur—Schultz19640624nullnull526-793-5344—1911 Bayshore Drive Apt 23MinneapolisMN55483——
TPATPA-545962026-04-15T15:54:31ZPrice, Carolyn··—Dec 7, 2005N/ANULLNULL—8651 RIDGE ROADAtlantaGA30391-N/A
TPATPA-596672026-06-16T10:01:16ZScott····Bell1976-09-05UHC-21307-72null967-740-2548N/A5175 Union StreetColumbusOH··43267——
TPATPA-541412026-09-24T02:53:49ZCAMILA—NELSON1997-01-14NULL•••-••-123216132771924NULL1110 SUNSET BLVDFresnoCA93747nullMEDICARE-ADV-B
TPATPA-629842026-03-02T01:35:01ZCheryl··Robertson1960-03-26NULL•••-••-6946—NULL2346 Lincoln WayScottsdaleAZ85203GRP-0592—
TPATPA-526962026-06-22T00:23:44ZDeborah—Nguyen1982-07-12—•••-••-45932496456874deborah.nguyen38@yahoo.com8504 Oak St Apt 34DenverColorado80256GRP-4410SELECT-EPO
TPATPA-602832026-10-11T15:29:56ZHANNAH—YANG1960-11-12—NULL8628563844NULL9744 Church StreetTUCSONAZ85713UNKNOWN—
TPATPA-554912026-02-22T21:48:58ZLarry··—Johnson1959-06-10UHC-47867-04—N/AUNKNOWN440 Desert Sky BlvdCharlotteNC-NULLUNKNOWN
TPATPA-517102026-01-12T05:28:44Zlaura—hunt1976-05-20UHC-71086-48•••-••-7647N/ANULL8673 River RdAtlanta·GA30339-5421··null—
TPATPA-575652026-07-05T09:53:45ZMARIA—LAWRENCE1981-06-26··—•••-••-6234246-677-0094null2940 RIVER ROADMesaAZ85264GRP-2893N/A
TPATPA-556542026-05-02T16:44:21Z·Susan K.—Singh1992-06-09N/A—UNKNOWN-··2587 Ridge RoadSacramentoCA95823··—
TPATPA-559132026-05-17T18:33:53ZSanchez, Alan——19661125nullN/ANULL—5421 Hillcrest RoadPhoenixAZ··85064····-
TPATPA-56982 2026-03-16T10:47:37ZNicholas—Grant11/6/1998UHC-26220-94•••-••-1090-nicholas.grant@outlook.com7769 Lake View RdFresnoCA93715-4765GRP-1063OPTIONS-PPO
TPATPA-612932026-06-15T03:02:32ZCHARLES—MORALES07/06/96nullN/A(884) 369-6264N/A1061 MESA DRCharlotteNC28244N/AN/A
TPATPA-585512026-04-08T07:44:34ZSANTIAGO··—HAMILTON···02/12/07————6075 Canyon RoadPhoenixaz85080N/AMEDICARE-ADV-B
TPATPA-543942026-02-11T22:06:15Z ·BillyF.Mendez1978-12-26UHC-22489-73UNKNOWN··N/A—3385 Desert Sky BlvdChandlerAZ85223NULL-
TPATPA-62044 2026-10-08T18:43:36ZMaria—Stewart12/26/2006····•••-••-9798-NULL9251 Pine DrEden PrairieMN55398nullnull
TPATPA-512412026-08-27T06:02:26ZPeter··—Brooks1965-09-18—N/AN/A—2138 Union Street··SeattleWA··null—NAVIGATE-HMO
TPATPA-599042026-02-07T07:17:58ZLopez, Maria—····04/08/45———-3303 FOREST AVENUEJacksonville··FL32243—NAVIGATE-HMO
TPATPA-590752026-03-01T07:47:31ZAnna—Santos1975-12-04UHC1515291——null6959 Desert Sky BlvdGilbertAZ85234-7894—N/A
TPATPA-642872026-02-19T10:40:18ZAnaNMendoza3/7/1983—•••-••-8978(551) 872-7496-2702 Lake View RoadATLANTA··GA30307·GRP-1044—
TPATPA-604872026-06-15T01:06:58ZMarcusOColeman1964-04-27NULL··6195191216N/A9477 HIGHLAND AVE #144SacramentoCA95820GRP-7736CORE-HMO
TPATPA-559602026-06-27T03:47:03ZIsaella—Payne1990-06-09—UNKNOWN—null2458 Forest AvenueHOUSTONTX·77019N/AMEDICARE-ADV-B
TPATPA-588212026-09-22T01:32:11ZDenise—SpencerFeb 2, 1953—NULL647.644.1833··null··———UNKNOWN—CORE-HMO
TPATPA-574842026-10-08T02:23:06Z·WEI—BAIELY··1975-02-24——-NULL609 HILLCREST RDMINNEAPOLIS··mn··55431····—
TPATPA-522182026-10-09T11:53:10ZDorothyXHicks1941-08-16-•••-••-4135UNKNOWNDOROTHY.HICKS9@AOL.COM———UNKNOWN··GRP-3095—
TPATPA-604422026-07-14T07:19:34ZDaniels, Jacqueline——2000-10-28UNKNOWNUNKNOWN--5622 Valley View DriveMiamiFLN/A-··MEDICARE-ADV-B
TPATPA-547832026-06-27T21:34:31Zchristian—le1971-11-18—-7589227788CHRISTIAN.LE6@ICLOUD.COM·7506 Mountain View DriveSan DiegoCA—-—
TPATPA-641302026-08-28T07:49:14Zcamila—jensen1989-03-15NULLN/A9844032725camila.jensen91@proton.me1928 CANYON ROAD··Eden PrairieMN55338-MEDICARE-ADV-B
TPATPA-515252026-08-18T18:16:14ZDANIELLE—BRADLEY1946-04-12··—null2354782240··NULL3413 BroadwayTampaFL33627GRP-5147core-hmo
TPATPA-512612026-05-06T11:45:33Z Albert—Hunt1939-04-27——NULLALBERT.HUNT22@OUTLOOK.COM843 Church StreetPlanoTX75062—UNKNOWN
TPATPA-555122026-07-01T17:36:55Zhenry—pierce2007-07-20UHC-46617-49•••-••-3284·(917) 913-8692··—--UNKNOWNGRP-6770UNKNOWN
TPATPA-538192026-09-20T08:54:02ZVincent—GordonJan 3, 1973N/A-NULL—1710 Central AvenueMIAMIFL33190GRP-3489N/A
TPATPA-613282026-07-10T11:39:30ZLARRY····SCOTT19590502··N/AUNKNOWNlarry.scott@gmail.com-—NULL··-N/AUNKNOWN
14,474 rows, page 110 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:43.618Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty