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-528562026-02-07T07:25:06ZLuis—Reed19440424null—2423077489N/A3980 Meadow LnOrlandoFlorida32821—MEDICARE-ADV-A
TPATPA-638892026-09-16T17:21:25ZNathan—·Shaw2003-08-10NULL•••-••-0816——9411 Willow CtMiamiFL33164nullN/A··
TPATPA-536612026-02-20T13:52:32ZBRANDON—JOHNSTON03/05/93——null-5819 JEFFERSON AVENUEMINNEAPOLISMN·55479nullUNKNOWN
TPATPA-565952026-07-10T23:53:17ZCHERYL—CASTRO1905-02-04-•••-••-3039NULL-570 Broadway··PhoenixAZ85002··nullnull
TPATPA-567552026-04-29T11:14:11ZSAMANTHA—CLARK19440624N/A-—samantha.clark67@gmail.com9047 Sunset BlvdScottsdale··AZ85234—OPTIONS-PPO
TPATPA-568292026-02-07T19:19:34ZEric—Martinez2002-01-92··—NULLUNKNOWNERIC.MARTINEZ34@HOTMAIL.COM5589 Forest Avenue #237FresnoCA·UNKNOWN—UNKNOWN
TPATPA-558042026-06-11T11:36:09ZCharlotte—Gomez··09/12/39nullUNKNOWN(455) 972-8822—7981 River RdSacramentoCA-GRP-5181N/A
TPATPA-553452026-01-30T23:46:18ZCarl····Cole1962-09-09UNKNOWN•••-••-7179—N/A7658 Oak StreetAUSTINTX····nullMEDICARE-ADV-A
TPA TPA-607922026-02-23T23:54:27ZDIANA··TURNER06-11-1970—NULL(793) 969-0217UNKNOWN—NULL·NULL—GRP-3742—
TPATPA-528802026-02-26T14:58:48ZMason—Carpenter1950-03-09-UNKNOWN+1 756 385 9455mason.carpenter@outlook.comN/AN/Anull····NULL··MEDICARE-ADV-B
TPATPA-577352026-01-15T20:35:38ZJuan—Herrera1995-05-05—UNKNOWN301-920-2414··—8271 Apache BoulevardMESAArizona85219GRP-8675····
TPATPA-505852026-03-10T17:48:52ZCATHERINEXELLIS1939-12-19—•••-••-9488UNKNOWN··N/A-UNKNOWN—-N/A·-
TPATPA-584412026-05-01T15:29:29ZKaren—Rivera·1984-05-22N/A—9595537karen.rivera@hotmail.com9144 Ridge Road Apt 12FresnoCA93779—null
TPATPA-604892026-04-25T13:59:42ZRalphMFisher18-03-1989UHC-77097-62-·nullralph.fisher@hotmail.com5993 BAYSHORE DRLas VegasNV—N/AOPTIONS-PPO
TPATPA-531822026-06-22T09:25:22Z MARILYN—HUNT1971-06-21UHC-38710-68—--8583 BAYSHORE DRATLANTAGA30370··GRP-1414MEDICARE-ADV-B
TPATPA-527442026-04-17T13:40:49ZNancy—Mendoza18-03-1988UHC-66651-92—N/A—7989 River Road··GilbertAZ85298-UNKNOWN
TPATPA-569852026-03-14T16:42:35ZPriya—Morales1938-05-26—nullnullPRIYA.MORALES6@PROTON.ME7223 Sunset BoulevardChandlerAZ85233-—
TPATPA-62813 2026-01-15T15:22:23ZALBERT—WALLACE19720712UHC-61755-91•••-••-6931——553 Park PlChandlerAZ85209-6117GRP-5494CORE-HMO
TPATPA-557852026-05-02T07:22:03ZJesse—Webb1946-04-25NULLN/AnullUNKNOWN4994 Lincoln WayEden PrairieMN55396NULL—
TPATPA-50032 2026-01-27T18:58:11ZMei—Arnold19770703—·UNKNOWN—NULL4985 Church StMiamiFLN/AGRP-7104·SELECT-EPO
TPATPA-551302026-07-26T07:50:41ZbrandonApark13-07-1957—•••-••-5298624-906-8280—1620 WILLOW CTSCOTTSDALEAZ·85294——
TPA TPA-506612026-01-10T00:47:30ZRonald—Gonzales1951-05-19N/A-5512640····2738 CENTRAL AVEJacksonvilleFL—GRP-5774UNKNOWN
TPATPA-576482026-10-03T16:33:17Z·JUDITH—CASTRO1946-06-18UNKNOWN—338-924-9418——NULLnullNULL-N/A
TPATPA-595112026-06-03T22:02:20ZVictoria—Barnes2003-11-26N/A•••-••-46769801147UNKNOWN1900 Ocean AvenueCharlotteNorth Carolina28251N/A·N/A
TPATPA-584232026-02-17T09:12:44Znicole—peterson1940-03-25NULL-404-540-5548N/Anull-··NULLnull—
TPATPA-550642026-03-18T04:46:53ZKayla—Carr05/19/1964nullnullnullkayla.carr55@proton.me—····null····GRP-9253null
TPATPA-621632026-09-12T18:28:31ZDougls—Ortega01/22/1991—•••-••-2201——····N/A—·null—UNKNOWN
TPATPA-592522026-07-01T05:53:56ZBruce—Lawson01/03/51UNKNOWNUNKNOWNNULLnull4529 Church St #236Los AngelesCA90063N/A—
TPATPA-62153 2026-07-01T21:50:32ZEMMAXDIAZ1978-08-04——2024759767UNKNOWN3374 Spring StreetFresnoCA93773—UNKNOWN
TPATPA-569462026-04-07T22:26:49ZEricQ.Andrews1996-10-25··—-——9487 Apache BoulevardGlendaleAZ85348—null
TPATPA-530742026-07-20T00:28:16Z·Charles—Bryant1995-10-01NULL•••-••-4370null··N/A8292 HILLCREST ROAD #683Las VegasNV89106··GRP-8711UNKNOWN
TPATPA-554782026-09-23T22:53:16ZAngela··DJacobsAug 28, 1969N/AUNKNOWN(856) 713-1841····9636 Pine DrLas VegasNV89134GRP-1013NAVIGATE-HMO
TPATPA-638722026-09-20T22:54:03ZJacqueline—Simmons1940-12-23··N/A—··N/A··8184 Spring StGlendaleAZ85339—NAVIGATE-HMO
TPATPA-535912026-07-13T06:55:19Z STEPHEN—MARSHALLJul 15, 1942null———8400 Union StAUSTINtx78700GRP-2810—
TPATPA-624592026-09-24T10:34:49ZSAM—WARREN06/02/03—•••-••-73932472459264—-——-null—
TPATPA-585202026-03-17T18:15:29ZKelly—Espinoza1989-05-10——8586021424··—9183 CENTRAL AVENUEJacksonvilleFL32286-MEDICARE-ADV-B
TPATPA-517302026-09-14T03:54:50Zjeremy—wagner10-05-1995N/A—(394) 828-8733JEREMY.WAGNER21@PROTON.ME—····NULL··UNKNOWNNULLCORE-HMO
TPATPA-530832026-02-06T12:09:33ZJanet—McDonaldJun 5, 1982UHC-29446-60··NULL(397) 533-7165janet.mcdonald60@yahoo.com5152 SUNSET BLVDTempeAZ85297GRP-7466—
TPATPA-598772026-05-19T22:13:45ZShirley—Fowler··04-06-1979——nullshirley.fowler29@yahoo.com—NULLnull—null—
TPATPA-580452026-07-01T19:24:09Z Virginia—Gilbert1993-01-02UHC5369880——NULL1426 BroadwayFresnoCA93706——
TPATPA-602712026-05-15T23:29:39Z SarahZ.Guzman··Sep 6, 1994UNKNOWN•••-••-8406null—2359 Canyon RdMinneapolisMN55417UNKNOWN—
TPATPA-603422026-09-22T00:01:47ZJOAN—WOODS1963-12-01NULL··N/A——9615 Central AvenueDallas··TX75284UNKNOWN··MEDICARE-ADV-A
TPATPA-517062026-01-13T18:08:44Z·SANDRA—SALAZAR3/5/2007NULL·N/A—UNKNOWN8418 Church StPLANOTX75095GRP-8625SELECT-EPO
TPATPA-595272026-02-10T08:59:46ZERIC—·MORGAN07-05-1995UNKNOWN•••-••-6734(714) 482-6159eric.morgan94@hotmail.com4634 Indian School RdDenverCO·80231—UNKNOWN
TPATPA-634102026-01-29T12:29:48Zmaria—greene1918-03-10NULL•••-••-1461——2309 MARKET STLas VegasNV89167—null
TPATPA-575042026-01-02T07:17:11ZAustin—Chavez1997-11-14N/A-N/AAUSTIN.CHAVEZ@AOL.COM2492 SPRING STSeattlewa98110—SELECT-EPO
TPATPA-510002026-09-12T22:16:19Z Gerald—Walsh2000-04-07-UNKNOWN-—8766 FOREST AVENUEPlanoTX75052GRP-7820··UNKNOWN
TPATPA-614382026-05-30T13:57:18ZRandy—Edwards1976-04-07—null·null—1054 Washington Street #580·MiamiFL33128··—·CHOICE-PLUS-PPO
TPATPA-607072026-07-19T02:08:42ZOmar—OBrien1953-12-16UHC-62805-80•••-••-5301—null8422 WASHINGTON STSan DiegoCA92135—CHOICE-PLUS-PPO
TPA TPA-570822026-08-22T10:49:28ZMASON—MORALES08/10/1941—NULL—mason.morales70@aol.com3768 Maple AvenueSAN DIEGOCA92169GRP-4656-
14,474 rows, page 67 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:40.335Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty