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-603632026-09-15T16:50:08ZLAUREN··—REYNOLDS1957-04-11N/A•••-••-7182418-478-5129··7932 Willow CtColumbusOH43297—UNKNOWN
TPATPA-637632026-01-25T17:08:50ZEllis, Jose——·01/01/1963null··--nullnullnull—-N/ACHOICE-PLUS-PPO··
TPA TPA-602812026-06-22T17:37:09ZAna—Foster09/08/89——327-616-8309ana.foster51@proton.me-N/ANULL—null—
TPATPA-502632026-03-20T00:03:33ZAllan—Contreras1939-06-09————7196 BAYSHORE DRIVETampaFL·33627N/A—
TPATPA-518502026-05-04T08:14:00ZMARIA—ESTRADA8/7/1977null——NULL4025 GRAND AVENUEJacksonvilleFL——-
TPA TPA-643922026-07-11T01:45:48ZMark····Walsh1980-06-15··—UNKNOWNNULL—9283 Bayshore DriveATLANTAga30320GRP-2937CORE-HMO
TPATPA-568112026-04-10T11:35:01ZJean—Robertson11/9/1961—•••-••-8229696-720-3498—7484 Camelback Rd #960ColumbusOhio43234··——
TPATPA-622362026-01-19T06:54:59ZPeterR.Brooks05/13/89—•••-••-96522624929134null····-——UNKNOWN—
TPATPA-591052026-02-14T11:41:37ZVirginia—Anderson06-06-2004·null-7256440054VIRGINIA.ANDERSON93@YAHOO.COM9727 Baseline Rd #447TampaFL··33684NULLOPTIONS-PPO
TPATPA-560302026-06-18T02:03:54ZArthur—Richards1984-05-11NULL··•••-••-9267N/Anull4040 Baseline RoadLOS ANGELESCA-NULLMEDICARE-ADV-A
TPA TPA-593822026-09-27T19:21:41Zgloria—martiez1959-09-01·UHC-12879-76—18025233117··gloria.martinez@icloud.com840 Central AvenueLas VegasNV89162NULLmedicare-adv-b
TPA TPA-525312026-01-25T23:36:08Z BRENDA—ALEXANDER2002-05-17—nullnull—3685 Harbor BoulevardDenverCO··-—
TPA TPA-554002026-01-20T00:47:41ZTerry—Torres2008-07-25UHC-76846-30•••-••-6613874.468.8321—1791 Main StCHANDLERAZ85268NULLNULL
TPATPA-615942026-06-07T02:12:50ZVirginia··—Mejia·2006-02-17·NULL•••-••-03172412314554-5994 Canyon Road #872FresnoCA93767GRP-1344-
TPATPA-618892026-08-10T00:37:40ZSanchez, Jean——1991-03-04-•••-••-841814144641991null6271 Camelback RoadLas VegasNV89168GRP-0649UNKNOWN
TPATPA-51030 2026-01-16T14:01:16ZJames—Chen02/13/1961—•••-••-4235859-400-9501-—NULL·N/ANULLN/ACHOICE-PLUS-PPO
TPATPA-611312026-08-01T08:00:56Zsophia····white1979-04-25-•••-••-7328—····2873 Highland AvenueSAN ANTONIOTX78268null·CORE-HMO
TPATPA-502642026-10-01T22:59:02ZDaniel—Burton1962-04-20nullnullN/A··-—UNKNOWN——GRP-0202MEDICARE-ADV-B
TPATPA-613132026-05-09T20:59:38ZPriya—Dean26-05-1945-N/A682-368-9397UNKNOWN9490 Central Avenue·TempeAZ85220GRP-5308··—
TPATPA-502912026-06-09T00:10:38ZBILLY—JACOBS·1959-06-28-·NULL(491) 322-9878··8915 Willow CtTampaFL33614nullCHOICE-PLUS-PPO
TPATPA-603842026-02-10T11:46:13ZAMY··—MYERS09/21/50-NULLNULLnull5533 Valley View DriveCHARLOTTENC28223GRP-4920NULL
TPATPA-535842026-06-30T12:44:28ZKyle—Jackson1990-08-01-—2286516130—-·····null-GRP-1410NULL
TPA TPA-618442026-07-05T12:05:39ZPIYA—GARCIA19670719·-•••-••-7437——2276 Broadway·DALLASTX75216GRP-0784MEDICARE-ADV-B
TPATPA-526882026-02-09T00:47:49Z Vasquez, Billy——19680308N/A—(447) 728-1836—9138 GRAND AVEMinneapolisMN55470nullNULL
TPATPA-581802026-09-13T19:18:40ZSAM—ANDERSON·1971-12-10NULL··null433.335.5037—·N/AUNKNOWN-—UNKNOWNMEDICARE-ADV-A
TPATPA-564702026-07-02T02:54:00ZMARIANAZLUNADec 20, 1951-—5622104-NULL—-—-—
TPATPA-629912026-05-07T00:50:35Z·Kevin—·Jimenez03-11-1992—-——1553 DESERT SKY BLVDORLANDOFL32857null··NAVIGATE-HMO
TPATPA-535792026-04-15T14:34:12ZChristian—TaylorMay 7, 1940-··—(600) 999-2787christian.taylor90@outlook.com5386 VALLEY VIEW DRIVEDallasTX75264—null
TPATPA-506442026-07-26T13:38:29ZRobert—Alexander1959-03-08-—null-814 CAMELBACK RDOrlandoFL32866-1485N/A····
TPATPA-60167 2026-06-28T14:53:42ZBRUCE—JACKSON1956-01-19··UHC-34324-18——bruce.jackson@aol.comNULLNULL-NULLNULL····
TPATPA-585822026-09-30T02:54:18Zpamela—cunningham1960-12-24UHC-98605-98UNKNOWN+1 812 598 7531-8681 Washington StreetScottsdaleAZ85294null·UNKNOWN
TPA TPA-547972026-05-08T14:06:51ZJosephAEstrada1977-05-26N/AUNKNOWNUNKNOWNUNKNOWN712 Washington St·Los Angeles·CA90025N/ACORE-HMO
TPATPA-578702026-06-17T08:41:59Zlauren—nguyen7/16/1990UNKNOWN•••-••-9262nulllauren.nguyen@icloud.com1130 BroadwayFresnoCA93704GRP-0776··
TPATPA-620632026-07-12T18:23:07Z Isabella—George1898-11-27UHC-68744-67null····NULL9793 Lake View Road Apt 23AustinTX—nullCHOICE-PLUS-PPO
TPATPA-573262026-03-10T22:17:30ZDavid—Romero1943-01-11N/A—N/AN/A5115 Willow CourtMesaAZ85286N/A·N/A
TPATPA-576952026-08-01T01:00:32ZGerald—Ward1970-06-09—UNKNOWN—·NULL9556 MESA DRSan DiegoCA92100GRP-5202—
TPATPA-531632026-06-02T20:44:07Zmason—harper08-05-1996UHC-52064-23•••-••-9430NULL—6142 Hillcrest RdFresnoCA··—··
TPATPA-609922026-04-04T18:01:11ZSTEPHANIE—COLLINS1974-08-04UNKNOWNN/A2789321986—7857 RIDGE RDSan AntonioTX··78280N/A··-
TPATPA-634372026-06-20T05:51:17Z Sophia—Welch1938-07-16UHC-08969-87—18303198136null9297 Church StSan Diego·CA92171N/AUNKNOWN
TPA TPA-523012026-05-31T01:51:46ZKATHRYN—LAWSON1984-08-08—UNKNOWNUNKNOWNUNKNOWN6848 Harbor BlvdPhoenixAZ85001—MEDICARE-ADV-B
TPATPA-523452026-03-16T16:58:43ZluisWhill1942-10-27UHC-27600-40•••-••-7985—null7828 Meadow LnGilbert·AZ85271-MEDICARE-ADV-B
TPATPA-585162026-05-07T12:58:50ZkatherineMlucas7/23/1966UHC-29115-96•••-••-0626NULLkatherine.lucas58@proton.me6724 Market StreetAustinTX··78706UNKNOWNMEDICARE-ADV-A
TPATPA-57889 2026-04-16T12:28:27Znathna—cole19580727null-UNKNOWNN/A-NULLN/Anull—NULL
TPATPA-586402026-05-27T07:52:18ZKAREN···R·STEWART02-02-2000N/A——-6295 Lincoln WayTempeAZ85228nullOPTIONS-PPO
TPATPA-622782026-05-31T02:00:07Z SEAN—KELLY08-08-2003-··nullUNKNOWNnull4766 Grand AvenueEden PrairieMN55307-3485N/AMEDICARE-ADV-A
TPATPA-575022026-09-03T15:38:05ZMason—Mills2000-04-22—······mason.mills75@gmail.com2476 Main St Apt 39GlendaleAZ85373UNKNOWNUNKNOWN
TPATPA-628252026-09-26T18:08:51ZVicky—Flores1982-11-16UNKNOWNnullUNKNOWNnull3576 Harbor BlvdLas Vegasnv89182-UNKNOWN
TPATPA-607502026-06-29T00:17:01ZCharlotte····Peters·1997-05-10—•••-••-86023615884195··8173 Park PlTampaFL33605-6066N/ACHOICE-PLUS-PPO
TPATPA-609022026-03-30T09:42:04ZGABRIEL—PHILLIPS1980-01-03—•••-••-9849nullgabriel.phillips62@hotmail.com·5932 Sage Court #795SAN ANTONIOtx·-N/A—
TPATPA-602942026-08-07T18:05:52ZEmma—Garrtt1972-05-20nullUNKNOWNUNKNOWNN/A··nullnullN/AUNKNOWNnullnull
14,474 rows, page 166 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:52.217Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty