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-515242026-06-25T10:17:24ZPamelaGFuller11/06/1946—•••-••-4093772-895-9546—··N/ANULL———
TPATPA-531812026-06-26T00:06:52ZWei—Day1964-04-22N/A-N/A··-3556 Baseline Road··SEATTLEWA98132GRP-1028—
TPATPA-632412026-06-23T07:32:56Zdnny—russell08/06/1955····•••-••-4976NULLNULL6057 APACHE BLVDSacramentoCA95842N/AUNKNOWN
TPATPA-575832026-03-11T08:49:49ZSmith—Andrew1962-10-28UHC9535462·null9562974725··-5777 Harbor BlvdGILBERTArizona85213··—NULL
TPATPA-599202026-08-08T07:26:48ZGEORGE—FLORES19590116-——UNKNOWN·8251 PINE DRIVEJacksonvilleFlorida32280—MEDICARE-ADV-B
TPATPA-500992026-05-06T14:35:46ZKnight, Evelyn··——·1989-08-28—N/A—N/A-—-—nullCORE-HMO
TPATPA-597152026-10-02T08:10:47ZKAYLA··—·LEWIS1978-06-27—UNKNOWN716-685-7720-8719 Ocean Ave·GilbertAZ85269GRP-4562OPTIONS-PPO
TPATPA-504182026-03-26T17:31:44ZAlan—Johnston19880813UHC-44462-04•••-••-71472524738587—nullnull——UNKNOWNOPTIONS-PPO
TPATPA-540352026-01-20T22:04:18ZEmmaQEstrada03/01/78-UNKNOWN14696908266NULL7700 Sage CourtCharlotteNC28269NULLUNKNOWN
TPATPA-576452026-05-01T23:38:35ZraymondE.howell23-05-1980··N/A—UNKNOWNNULL9124 HIGHLAND AVENUEDenverColorado80242GRP-7312—
TPATPA-589562026-09-17T05:17:18ZMaryMGarrett2007-12-22NULL•••-••-4657396-211-2281MARY.GARRETT@ICLOUD.COM2645 Lake View RoadPhoenixAZ85018·N/AN/A
TPATPA-52385 2026-02-14T10:22:14ZMaria····RamirezApr 23, 1999UNKNOWNUNKNOWN(451) 924-6038NULL1102 Market StLos AngelesCalifornia90037——
TPA TPA-592102026-02-13T02:29:30Z MARIANA·WHERRERA19900311UHC-32984-29•••-••-7781—UNKNOWN5692 Maple AvenuePlano·TX75014GRP-5859—
TPATPA-574652026-10-16T17:26:02ZDoris—Richards9180-11-26—·-—-9764 Cedar LaneHoustonTexas—nullNAVIGATE-HMO
TPATPA-601442026-03-06T02:05:47ZOLIVIA—COOPER1981-09-05—-UNKNOWNNULL683 BAYSHORE DRMINNEAPOLISMN55492—····
TPATPA-640672026-03-26T20:53:29ZCynthia—Le1946-09-14UHC-82199-46N/ANULLUNKNOWN—--—GRP-7934—
TPATPA-590242026-03-28T09:58:41ZGEORGE—LOPEZ1951-11-13——--9472 SUNSET BLVDSAN DIEGOCA92182nullMEDICARE-ADV-B
TPATPA-529292026-03-23T08:43:28ZBlack, PamelaQ.—·1969-01-06NULLNULL2552354-8059 Park PlDenverColorado80257GRP-5362OPTIONS-PPO
TPATPA-640792026-03-08T05:20:28ZJUAN—WALSH19520410N/A•••-••-6308—UNKNOWN——UNKNOWNUNKNOWN-MEDICARE-ADV-B
TPATPA-536492026-08-08T02:02:51ZDEBRA—GUERRERO1975-06-22——UNKNOWNN/A6541 Willow CtPlanoTX75018GRP-5085NAVIGATE-HMO
TPATPA-541802026-02-03T16:40:11ZRALPH··CHAVEZ1988-12-07UNKNOWN•••-••-2411-—8378 Ridge RdDenverCO80258·nullMEDICARE-ADV-A
TPATPA-570702026-08-31T12:59:04ZTaylor, Michelle··P.—11/2/2003··——michelle.taylor65@proton.me9367 Park PlTucsonAZ85790——
TPATPA-575902026-02-15T05:10:21Zcarlos—torres1970-09-14—UNKNOWN—NULL1314 Hillcrest RdMesaAZ85220-··—
TPATPA-616052026-02-05T17:37:49ZOlivia—Johnson09-01-1971—N/Anull—8638 WASHINGTON STREETSeattleWA98181null—
TPATPA-57812 2026-08-09T13:22:29ZERIC·····NUNEZ1595-12-04UHC-54081-90——eric.nunez@proton.me4557 INDIAN SCHOOL RDCharlotteNC28254GRP-8132-
TPATPA-577302026-05-13T11:07:00ZBeverlyU.Hernandez1957-12-27—•••-••-2281—UNKNOWNN/A—UNKNOWN··—GRP-2731·select-epo
TPATPA-61101 2026-04-15T20:52:19ZLARRY—DUNCAN··1989-04-28—•••-••-4110——9313 Baseline RoadEden PrairieMN55346-2425UNKNOWNNULL
TPA TPA-513542026-03-06T05:18:47ZMARCUS··—FIELDSMar 3, 1996—•••-••-1222(613) 307-9537—·8621 OAK STNashvilleTN37241-··NAVIGATE-HMO
TPATPA-517522026-04-26T14:43:33ZBRUCE—MEYER22-03-1964N/A··NULL+1 638 744 4499null1979 JEFFERSON AVENUE··HOUSTONTexas77031null—
TPATPA-509562026-02-03T12:20:31ZJEREMY—CHEN1984-02-25—•••-••-7031nullN/A8578 Union StCOLUMBUS·OH·43238GRP-2877null
TPATPA-509252026-05-26T15:17:21ZCATHERINE—PHILLIPS1981-08-26-·NULLnullcatherine.phillips@icloud.com8247 Desert Sky BlvdSeattleWA98164GRP-2846—
TPATPA-592972026-02-26T04:21:11ZMaria—Fields2001-09-12—null8792688239MARIA.FIELDS@AOL.COM8076 Highland AvenueSeattlewa98195·NULLUNKNOWN
TPATPA-588342026-03-08T08:31:35ZDoris—Foster1950-02-27—•••-••-3672····NULL5527 Pine DriveLas VegasNV·89154——
TPATPA-62408 2026-04-12T05:17:30ZKellly—MorrisApr 11, 1961UNKNOWNUNKNOWN435.711.8910N/A5956 WILLOW COURTPLANOTX75058-—
TPATPA-565712026-07-30T21:27:48Zgloria—nguyen1948-12-13·N/A———242 DESERT SKY BOULEVARD #869DenverCO·80223-UNKNOWN
TPATPA-580042026-06-21T03:06:36ZGloria—·Wells09/12/1956-N/A·(583) 370-0976—NULLnull·-—-—
TPA TPA-631462026-01-18T14:49:42ZJONATHAN—STONE1972-10-13-•••-••-8102332-900-1655null—nullNULL—GRP-5332SELECT-EPO
TPATPA-556392026-10-04T20:49:15ZJordan, Danielle——1998-12-05-—7000994null··5513 Market St Apt 18PhoenixAZ85087NULL··
TPA TPA-590922026-02-12T17:05:31ZKELLY—JOHNSTON1938-07-09··nullnull·(739) 657-6377kelly.johnston@hotmail.com2944 Union StreetNashvilleTN37264—CORE-HMO··
TPATPA-580492026-02-15T00:14:43ZEDWARD—PETERSON1965-05-18———-2594 Ridge RdDallasTX75232NULL··NULL
TPATPA-607332026-04-19T13:59:04ZJOSEPH—JOHNSTON1950-10-17UNKNOWN·N/A—·joseph.johnston@hotmail.com1263 CENTRAL AVENUEScottsdaleAZ85273—null
TPATPA-634722026-07-25T22:44:41ZChristinaHHughes1969-09-24—-UNKNOWNUNKNOWNN/ANULLUNKNOWN-NULLMEDICARE-ADV-A
TPATPA-640012026-09-11T15:34:50ZNICHOLAS—ADAMS1953-12-23—NULLUNKNOWN··-8975 Grand AvenueAtlantaGA30394GRP-4324-
TPATPA-534652026-03-16T10:38:45Zyuki—luna1987-06-20—•••-••-2202nullUNKNOWN2639 Central AveLAS VEGASNevada—UNKNOWNNAVIGATE-HMO
TPATPA-605272026-08-17T07:27:09ZEvelyn—Contreras··1977-01-11—•••-••-10888072724415NULL8517 Sunset Blvd··JacksonvilleFL·32240-OPTIONS-PPO
TPATPA-566422026-09-15T22:23:13ZDenise—Richardson07-10-2002·N/A•••-••-51845933811522NULL6090 Spring StreetChandlerAZ85253GRP-2041MEDICARE-ADV-B
TPATPA-555772026-05-20T13:57:39ZJanet—CarpenterMay 9, 1987UHC-93080-30—2083223594UNKNOWN9345 Sunset BoulevardAtlantaGA——NULL
TPATPA-621402026-06-14T10:58:49ZBryan—Jenkins10/13/1970—NULLnullbryan.jenkins14@proton.me8592 Grand AveMiamiFL··33197—N/A
TPATPA-503602026-08-12T02:59:31ZBilly—Medina·1989-09-14UHC1659776—7814006NULL810 Washington StreetSacramentoCA95868—UNKNOWN
TPATPA-514982026-06-10T11:02:13ZOIVIA—HART1943-06-07·NULL-UNKNOWN-2743 MEADOW LANE #668··SAN DIEGOCA92145·UNKNOWNUNKNOWN
14,474 rows, page 236 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.194Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty