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-619662026-02-15T20:37:51ZJoshua—Herrera1954-10-01—N/A(723) 607-7992··-8343 Washington StColumbusOhio·43249—MEDICARE-ADV-B
TPATPA-634412026-03-03T14:58:37Z·MATTHEW—ELLIS1967-12-06UHC-13836-14N/A··——4838 Jefferson AvenueHOUSTONTX77053·GRP-2532MEDICARE-ADV-B
TPATPA-556672026-09-02T02:13:08ZKimberly—Mitchell1945-05-18NULLNULL5469420396KIMBERLY.MITCHELL@YAHOO.COM2928 Ridge RdPhoenixAZ85096-4966·GRP-4829NULL
TPATPA-544522026-02-23T21:44:41ZAustin—Schmidt1/4/1973UNKNOWNnull—·-6057 Palm DrGilbertAZ85286·GRP-5156····
TPATPA-571922026-03-27T10:13:55ZGaryKMills1986-01-19UHC-36526-63•••-••-1970(778) 545-0619—1766 Church StDenverColorado80293N/A—
TPATPA-616562026-01-21T22:36:12ZJUDITH·T.ROBINSON2005-10-03-•••-••-3806null—9430 BASELINE ROADFresnoCA93742-medicare-adv-b
TPATPA-568342026-01-07T19:51:09ZRuth—Hall1968-09-24—•••-••-58452722957547ruth.hall3@aol.com470 Apache BlvdColumbusOH43290GRP-3148··null
TPATPA-612592026-02-02T15:17:49ZBryan—Lawrence1938-04-12·-N/A(878) 393-3657··6144 Apache BlvdAtlanta··GA30365GRP-9347null
TPATPA-522902026-03-20T11:42:59ZCharlotte—Snyder··11/17/1952—-4349272705····4879 MAPLE AVENUESacramentoCA-nullMEDICARE-ADV-B
TPATPA-633462026-02-02T05:14:26ZMatthew—Kelley·04/10/56null——····7256 RIVER RDTEMPEAZ85280—N/A
TPATPA-630632026-08-11T14:36:33ZAhmed··Sanders10/2/1969null•••-••-58077449930595———nullUNKNOWN—·NULL
TPATPA-554652026-06-20T18:14:46ZMaria··BNunez9/6/1952N/A——null2337 PALM DRAustinTX78780··-
TPATPA-542662026-02-18T14:55:58ZGabriel—Chen06/05/97UHC4232653null-N/A3512 Washington StFRESNOCA93736nullCHOICE-PLUS-PPO
TPATPA-624282026-07-10T17:28:33ZYuki·MRichardson22-01-1994UNKNOWNnull703-850-4062—N/A-··N/A—N/ACORE-HMO
TPATPA-582322026-07-22T15:03:08Z·Shirley—Miller19710422N/A•••-••-1674null—·7511 Pine DriveFRESNOCA93791GRP-6288··—
TPATPA-596712026-07-23T15:00:57ZMary—Guzman27-03-2000UHC-44249-22null—N/A1636 Pine DriveLas VegasNV89111UNKNOWN-
TPATPA-531762026-01-26T08:27:14Z Frank—Snchez1941-11-17UHC-19954-35——N/A2748 Sage CtSeattle·WAN/Anull····
TPATPA-548502026-07-12T01:49:12ZEmma—Aguilar1953-07-16N/A•••-••-7621NULLnull4352 Baseline RdChandlerAZ85270—CORE-HMO
TPATPA-503442026-05-13T12:30:41ZAdamRSimpson07-10-2005UHC-19865-62-nullUNKNOWN5333 Harbor BlvdPhoenixArizona85000GRP-5978··NULL
TPATPA-606482026-05-13T15:59:31Z TERESA—·MURPHYOct 9, 1967——N/AN/A4268 Broadway Apt 19MESAAZ85269GRP-8031NAVIGATE-HMO
TPATPA-61147 2026-04-01T20:10:51ZSophia—Hunt1997-11-18nullN/AUNKNOWNnull5141 Valley View DrivePhoenixAZ85027GRP-6401—
TPATPA-515472026-07-14T01:25:41ZMarilyn—Hayes1971-05-03——··NULL9800 Grand AvenueCharlotteNCN/A··GRP-3666CORE-HMO
TPATPA-634282026-09-21T10:04:30ZMatthew—Guerrero19570220-—·N/AMATTHEW.GUERRERO@YAHOO.COM1771 Apache BlvdDALLASTX75246N/AUNKNOWN
TPATPA-596662026-05-26T09:52:33Zsara—garcia1995-02-24N/AN/A749-769-4651sara.garcia28@proton.me····——UNKNOWNGRP-3231-
TPATPA-510572026-02-11T07:58:17ZMARY—ALLEN19741002—•••-••-860019436077668—4111 Grand AvenueEDEN PRAIRIEMN···55368-9918-—
TPATPA-603462026-09-21T04:12:15ZSARAH—GIBSON1953-11-10-··•••-••-07976807372070-——·N/A—GRP-5821NAVIGATE-HMO
TPATPA-568712026-05-29T03:26:26ZJUAN··WILLIAMS1950-11-24nullNULL··N/Anull8198 Lincoln WayScottsdaleAZUNKNOWN—MEDICARE-ADV-B
TPATPA-501802026-07-10T01:40:52ZKim, Fatima——1966-06-26-——··8544 Camelback RoadSacramento·CA95882GRP-5287CHOICE-PLUS-PPO
TPATPA-616992026-09-22T03:23:54ZGreene, Jordan——27-01-1982——-—2298 CAMELBACK ROADScottsdaleAZ85255——
TPATPA-602242026-01-18T15:36:15ZMark—Howell10/15/2000UHC5933175-522.625.2989mark.howell37@icloud.com8095 BAYSHORE DRIVE··San DiegoCA-GRP-2116—
TPATPA-500372026-06-25T10:12:19ZJOSHHUA—BURKE··1994-09-03N/A··(329) 762-7345UNKNOWN6405 Hillcrest RoadDenverCO80285—MEDICARE-ADV-B
TPATPA-539272026-07-31T09:58:46ZANDERA····CARROLL1988-07-02NULL——·null6828 Oak StSACRAMENTOCA95878NULLnull
TPATPA-605692026-01-10T20:56:07ZDiane—Hoffman1958-05-26·N/A—+1 837 549 8609null2939 Lincoln Way··MesaAZ85220—CHOICE-PLUS-PPO
TPATPA-642122026-08-16T16:42:43Z ALXIS—HICKS12/06/1950—-——7538 MARKET ST Apt 10SEATTLEWA—N/A—
TPATPA-522332026-08-02T11:07:11ZMARGARET—WARRENNov 3, 1988—•••-••-5594nullmargaret.warren@outlook.com··1560 WASHINGTON STAtlantaga30344··UNKNOWNnull
TPATPA-607802026-03-27T02:43:14ZDeborah—Grant·1942-10-14UHC-98028-76•••-••-82926849207501NULL4908 RIDGE ROADChandler··AZ85203GRP-4305null
TPATPA-526592026-08-20T13:09:40ZMejia, Barbara——·1972-11-14UHC-89568-77N/A6926701904null132 Canyon RdGLENDALEAZ85385NULLCHOICE-PLUS-PPO
TPATPA-574062026-01-19T21:32:50Z Logan—Taylor28-08-1982··N/A——·NULL1147 Valley View DriveAustinTexas78749·GRP-5000-
TPATPA-566002026-07-02T16:24:51Zlaura—watkins1961-02-15UHC-86062-54•••-••-7143—-2762 Willow CtMESAaz85231N/A··—
TPATPA-594432026-05-04T09:40:28ZROGER—SULLIVAN1941-01-21UNKNOWN—null··9235 Hillcrest RoadGlendaleAZ85385—CHOICE-PLUS-PPO
TPATPA-57183 2026-02-28T13:03:39ZLRARY—PEREZ1982-05-22UHC-26253-85•••-••-27823759861762—6800 Main StGilbertAZ85233GRP-1740OPTIONS-PPO
TPATPA-564512026-04-14T04:57:20ZAlan—Ellis19460113N/A•••-••-3448—·alan.ellis16@icloud.com—NULL—-··GRP-9691CORE-HMO
TPATPA-619332026-05-27T07:28:34ZEugene—HendersonFeb 22, 1959··-null2215016506—3030 Ocean Avenue Apt 21SCOTTSDALEAZ85296——
TPATPA-592282026-02-15T03:27:53ZKathy—Clark19810817nullnull-··kathleen.clark33@icloud.com-———N/A-
TPATPA-556272026-05-28T11:46:18ZPETER—SALAZAR··06-08-1985-•••-••-0881UNKNOWNpeter.salazar54@icloud.com624 Grand AvenueDallasTX75246——
TPATPA-644632026-10-04T13:27:40ZValentina—·Garrett1946-08-06·UHC9041992•••-••-5147—UNKNOWNnull--—N/Anull
TPATPA-593442026-05-30T11:49:37ZJuan—Dean07/12/1979—····+1 919 209 3811NULL·7400 Church StreetGLENDALEAZ85376—NULL
TPATPA-512962026-06-08T13:00:21ZJuan····ReyesApr 23, 1941NULL——··7663 Forest AvenueDallasTX··NULLnullNULL
TPATPA-642832026-06-07T14:01:54ZJESSE—DANIELS24-11-1960null•••-••-7573-null5751 Elm St #500CHARLOTTENC28238GRP-6093—
TPATPA-511812026-10-09T11:56:14Z ·Grant, PatrcikT—01/08/63null•••-••-2149UNKNOWN—592 Apache BoulevardAtlantaGeorgia30372GRP-6017—
14,474 rows, page 246 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:00.243Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty