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-533722026-08-20T04:29:14ZNATALIE—BURTON1967-05-28N/A—-UNKNOWN523 MAIN STREET Apt 11TucsonAZ—UNKNOWNSELECT-EPO
TPATPA-524812026-06-30T03:54:36ZFosster, BruceJ—12/16/1942—•••-••-3364848-278-7537BRUCE.FOSTER@OUTLOOK.COM1361 Highland Ave··CHANDLERAZ85286-6768GRP-9841NULL··
TPATPA-565562026-10-12T04:34:13ZDorothy—Hudson1988-11-08NULL--N/A3077 MEADOW LANEMinneapolisMN55437NULL·CHOICE-PLUS-PPO
TPATPA-589362026-02-20T17:46:35Zsean—youngJul 27, 2007NULL—368-863-7921··—3421 INDIAN SCHOOL ROADPhoenixAZ85060——
TPATPA-600012026-03-22T08:18:43ZReid, Daniel——1980-05-26—•••-••-2334N/A—7481 Park PlaceHoustonTX77046——
TPATPA-538412026-07-27T11:24:00ZWillie—Rivera1960-07-07—N/A···N/A9797 Lake View RdLos AngelesCA90018—N/A
TPATPA-588752026-07-13T23:35:40ZTheresa····Tucker3/3/1972··null····812-780-5521—884 Maple Ave #571San DiegoCA92197—MEDICARE-ADV-B
TPATPA-628832026-09-23T03:40:19Zluis—gray2000-03-07——UNKNOWN-1486 Willow CourtDENVERCO80216GRP-2461··—
TPATPA-617632026-06-09T05:40:46Zwayne—williams1985-03-11NULLNULL926-325-3755wayne.williams14@proton.me5571 Sunset BoulevardMesaAZ85272UNKNOWN··NAVIGATE-HMO
TPATPA-561212026-03-25T20:40:42ZCunningham, Julia——1954-05-28UHC-98772-34———3668 Spring StAUSTINTX-GRP-7842—
TPATPA-519092026-09-05T17:16:38ZGregory—RoibnsonMar 14, 2000UHC-86586-59UNKNOWN+1 891 908 3975N/A1979 Cedar LaneGilbert·AZ85211N/AN/A
TPATPA-544402026-10-06T01:52:48ZAndrew—Little1972-07-06··null•••-••-7529——3646 Sunset BoulevardTempeAZ·85217·N/ACORE-HMO
TPATPA-571702026-03-15T21:40:30ZTHERESA—HERRERA19450408NULL··-—UNKNOWN4862 Indian School RdTempeAZnull··—UNKNOWN
TPATPA-639292026-03-18T10:27:29ZMason—·Sttone1983-10-10nullUNKNOWNUNKNOWNNULL··5591 Park PlaceGlendaleAZ85392··UNKNOWNMEDICARE-ADV-B
TPA TPA-639732026-09-05T15:43:31ZChristian—McDonald1954-04-03N/AUNKNOWN—christian.mcdonald@yahoo.com2592 Forest AvenueGlendaleAZ85322GRP-5031UNKNOWN
TPATPA-616872026-09-26T01:30:35ZEvelyn··PalmerApr 3, 1997-UNKNOWN—EVELYN.PALMER@AOL.COM8011 Church StreetTucsonAZ85758NULL—
TPATPA-55610 2026-08-10T07:50:00ZDebra—Fields1973-06-12—•••-••-5843nullN/A1358 Pine DrPHOENIXAZ85093-—
TPATPA-634162026-10-01T12:21:17ZBobby—Jones1990-10-25NULL•••-••-0397·N/Abobby.jones43@proton.me8156 Lake View Road·AUSTINTexas78778—select-epo
TPATPA-582192026-05-27T03:25:36ZDouglas—Day19460813N/A•••-••-5293UNKNOWNdouglas.day@proton.me3209 Washington StOrlandoFL32814-3736GRP-0333—
TPATPA-639212026-04-29T22:13:33ZBEVERLY—SULLIVAN1990-01-27UNKNOWN•••-••-9649750-888-1312·-6770 Ocean AvenueSACRAMENTOCA95803NULLN/A
TPATPA-55158 2026-02-23T09:17:04Zcatherine······collins1952-01-23—-225-490-2786nullnull——UNKNOWN——
TPATPA-589532026-06-21T15:17:40ZAhmed—Reid1947-12-15null•••-••-6622N/AUNKNOWN3342 Grand AveGlendaleAZ85326N/ASELECT-EPO
TPATPA-602272026-03-30T06:32:02ZSTEPHEN—GONZALES1986-05-06··——NULL-789 Highland AvenueTUCSONAZ85780-0843nullMEDICARE-ADV-A
TPATPA-596992026-07-01T08:26:04ZNatalie—Murphy2002-12-24··NULL•••-••-3865····—2401 Union StAUSTINTX78739GRP-7824NULL
TPATPA-567092026-09-23T13:46:07Z·Barbara—Carter1941-08-17NULL——barbara.carter87@proton.me5676 Ridge RdChandlerAZ85290-3226——
TPATPA-596062026-03-28T12:12:30ZJoan······LarsonSep 16, 1949N/ANULL9718793852JOAN.LARSON@YAHOO.COM2943 Pine DrTEMPEAZ85259N/ANULL
TPATPA-622462026-07-13T04:11:16ZNOAH··—BROOKS1976-03-25nullnull-——null———UNKNOWN
TPATPA-642312026-03-22T15:44:22ZBobby—Simpson1961-07-27—N/A5796655691-133 RIVER ROADDallastx75257GRP-4880choice-plus-ppo
TPATPA-547782026-09-17T14:49:58Z CHARLES····DUNN1993-10-24UHC-26801-85··NULL(960) 815-3372NULL4956 Meadow LaneColumbusOH·43288-N/A
TPATPA-589942026-09-23T15:48:27ZJennifer—Watkins21-04-1993N/Anull———NULLN/A-GRP-3525—
TPATPA-542522026-04-02T02:54:27ZMEI—JOHNSON1978-02-23——nullmei.johnson4@yahoo.com—NULL—N/A······
TPATPA-636852026-10-01T23:59:48ZARTHUR—MORRISON1995-07-18N/A•••-••-0149—ARTHUR.MORRISON64@PROTON.MEnullnullUNKNOWN—GRP-9517····
TPATPA-599602026-03-10T22:50:12ZJose—Torres26-07-1962null•••-••-80157986801290N/A5904 DESERT SKY BOULEVARDEden PrairieMN55389nullSELECT-EPO
TPATPA-611162026-09-29T11:48:06Zfrances—hanson1954-10-11NULL•••-••-3314421-588-6375UNKNOWN3170 Valley View DrGlendaleAZ85368—··
TPATPA-520442026-01-24T08:04:17ZKATHLEEN—·OBRIEN02/05/88UHC-27159-72NULL436-634-4511NULL9351 Elm Street·Los AngelesCA90075-3934—UNKNOWN
TPATPA-534752026-01-12T02:13:03ZJennifer—Moore1994-12-06NULL•••-••-3213nullNULL3483 Church StreetSan DiegoCA92152··N/A
TPATPA-617942026-07-20T23:05:28ZJessica—Burns1957-03-03UHC4630771NULL-·jessica.burns14@icloud.com·7840 Desert Sky BlvdScottsdaleAZ85211UNKNOWNOPTIONS-PPO
TPA TPA-544212026-07-24T18:00:50ZRUTH—·HERRERA02/24/60N/A•••-••-7198UNKNOWN—N/A——UNKNOWNUNKNOWN·options-ppo
TPATPA-604072026-04-19T08:46:44ZVIRGINIA—BURTON10-09-1994NULL-N/AN/A210 River RdDallasTX—-NULL
TPATPA-51351 2026-03-06T06:12:25ZdianaFrid20000201-•••-••-5365—diana.reid57@yahoo.com9358 Desert Sky Boulevard·SacramentocanullUNKNOWNOPTIONS-PPO
TPATPA-570392026-09-25T04:30:52ZALAN—MARQUEZN/AUHC8862029-—ALAN.MARQUEZ@OUTLOOK.COM2304 CENTRAL AVENUE·FresnoCalifornia93742-1263nullNAVIGATE-HMO
TPATPA-582342026-02-21T10:33:29ZHansun, Elizabeth——1981-10-23··—nullUNKNOWN·1726 Elm StSAN ANTONIOTX78247-null
TPATPA-585012026-06-30T18:37:10ZGABRIEL—ESPINOZA1939-11-25——-gabriel.espinoza@aol.com———-N/ANULL
TPATPA-503132026-01-13T10:56:11ZPamela—Bradley··Dec 7, 1994UNKNOWN—-N/A4004 Baseline RoadJacksonville··FL32266GRP-3035OPTIONS-PPO
TPATPA-612452026-05-11T07:10:02ZAmber··—Baker1975-02-20-NULL958-295-8441—8203 BAYSHORE DRAustinTX78727··null—
TPATPA-627172026-07-04T03:33:13ZLarry—Ryan1963-05-24——UNKNOWN·N/A7997 Pine Drive··FresnoCA93742—null
TPATPA-52975 2026-05-13T23:14:51ZOlson, MichaelI.—1956-12-01—•••-••-4359+1 835 985 8016UNKNOWN··—NULLUNKNOWN——
TPATPA-559802026-05-12T12:41:51ZTerry—Schmidt06/16/93UNKNOWN—UNKNOWNterry.schmidt@aol.com4118 Pine DriveMiamiFL33196-CORE-HMO
TPATPA-605412026-07-06T08:47:46ZRaymond—Woods·1996-04-12NULLN/Anullnull2178 Washington StreetMinneapolisMN55497null·UNKNOWN
TPATPA-540882026-04-04T00:12:33Zjesse—hernandez2008-10-08UHC4067860•••-••-1794NULLN/A2780 FOREST AVEChandlerAZ85247····MEDICARE-ADV-A
14,474 rows, page 212 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:56.143Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty