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-641042026-10-11T04:31:42ZJeffrey····Grant1983-09-13———JEFFREY.GRANT91@PROTON.ME·NULLN/A—---
TPATPA-596912026-08-28T09:05:55ZNancy—Dean1947-05-23NULL—18347463387nancy.dean@outlook.com3690 Union StGlendale··AZ85359—N/A
TPATPA-641152026-10-03T10:11:40ZKEVIN—MITCHELL-UNKNOWN—(374) 979-4017—661 Valley View DriveDallasTX75223GRP-6567-
TPATPA-539372026-08-09T11:31:44ZBrittany—Wheeler1971-09-05·N/AN/A19617043830N/A1233 Forest AvenueMiamiFL33162-··—
TPATPA-596572026-07-25T09:13:53ZAliceU·Mills1965-02-25NULL····—--UNKNOWN··—N/AGRP-9023—
TPATPA-512762026-07-13T23:55:56ZKathryn—Harrison··1/11/1974—•••-••-6236279-770-3167—2953 ELM STOrlando··fl32855—-
TPATPA-519912026-07-05T13:52:50ZSofia—Baker7/7/1944··N/Anull685-544-7021NULL2623 BASELINE ROADDallastx75261GRP-9558—
TPATPA-626662026-02-22T09:02:05ZRichard—Riley1961-07-11nullNULL—-3721 Mesa DriveTucsonAZ·85728GRP-8393-
TPATPA-50270 2026-03-11T14:21:51ZHayes, Abigail——2004-06-12-—·829.664.6716NULL4247 Hillcrest RoadAustinTX78792·NULLCHOICE-PLUS-PPO
TPATPA-589162026-04-11T21:26:14ZAdams, Sarah——-NULL-—N/A2699 Canyon Road Apt 9FresnoCA93784-null
TPATPA-546512026-02-11T13:57:55ZJUDY—·JIMENEZ8/13/1997N/AUNKNOWN—N/A8620 River RoadPhoenixAZ85070GRP-9946—
TPATPA-560972026-02-16T21:20:35ZVincent—Berry1966-04-10UNKNOWN-NULLnull8119 Market StMiamiFL33187——
TPATPA-546002026-06-28T05:01:51ZAUSTIN—HERRERA··2002-09-12NULL-—austin.herrera30@gmail.comUNKNOWN—UNKNOWNnullnull—
TPATPA-632812026-03-08T14:09:44ZLinda—Gray19910506UHC-75175-37-N/A—null—-———
TPATPA-525332026-06-18T19:18:18Zvirginia—grant1968-08-03··NULL··null··——3062 Forest AvenueColumbusoh43296-9414-null
TPATPA-537632026-09-17T21:30:32ZCarlos····Tayor11/5/1960·UHC-54687-87····N/Acarlos.taylor@gmail.com—N/A—N/AGRP-7150MEDICARE-ADV-A
TPATPA-511502026-07-13T08:38:47ZALAN··—JACOBS1988-10-28-null+1 364 578 7610alan.jacobs99@hotmail.com7390 Desert Sky BlvdEden PrairieMinnesota55388—-
TPATPA-543492026-03-29T05:06:33ZOmar—Wong··1952-11-11—null+1 237 237 5706omar.wong51@gmail.com8933 Mesa DriveMinneapolisMN55458NULL-
TPATPA-523712026-08-11T22:28:22ZDoris—Alvarez1971-01-07—UNKNOWN(669) 927-0351N/A8860 Meadow Ln··Tampa··FL33639—MEDICARE-ADV-B
TPATPA-642172026-07-17T04:45:59ZRAYMOND—MALDONADO1969-10-23null•••-••-1909—-4552 MARKET STREETColumbusoh··43285-6778··—-
TPATPA-583812026-06-02T09:59:56Z·Abigail—Mitchell·1968-08-24—•••-••-16522578456056null103 BroadwayColumbusOHUNKNOWN-—
TPATPA-556562026-02-22T00:32:43ZCarol—·Russell8/10/2000—•••-••-7026+1 680 313 1019NULL1060 APACHE BLVDNashvilleTN37221-9667GRP-0704—
TPATPA-603992026-02-26T04:43:50ZSimposn, Eric——1998-10-18—•••-••-9695—null8776 CANYON ROADColumbusOH43289—OPTIONS-PPO
TPATPA-644032026-05-21T05:13:53ZCATHERINE—BENNETT1980-01-12—•••-••-2465258.712.4462—939 Ocean AveAustinTX78790N/A····
TPATPA-586982026-01-14T08:44:09ZVirginia—Delgado02/23/65NULL—6779327801·virginia.delgado1@proton.me7260 Union StSacramentoCA95836UNKNOWNSELECT-EPO
TPATPA-576512026-04-04T22:39:55ZMICHAEL—FLORES2000-05-13UNKNOWN—7163171886michael.flores26@yahoo.com7802 OAK STREET Apt 14CharlotteNCN/A—NULL
TPATPA-527272026-02-14T02:19:57ZCrawford, Samantha——1985-10-16N/A—NULLnull4309 Main StTampaFL·33607GRP-5416·null
TPATPA-617702026-05-29T04:18:27ZRichards, Nancy——12-06-1948UHC-93715-49N/A(812) 956-6702····—————MEDICARE-ADV-A
TPA TPA-548002026-05-16T23:42:53ZscottYhenderson1958-01-24UHC-32283-14-—NULL3879 Ridge RdCharlottenc28203GRP-1757··NAVIGATE-HMO
TPATPA-538402026-09-02T10:44:04ZWillie—Rivera07-07-1960UNKNOWNnull3716764022—·9797 Lake View RdLOS ANGELESCalifornia90018--
TPATPA-506062026-08-28T20:35:24ZJose—Olson2003-05-28UHC3202176N/A9768270409-5299 Elm StreetJacksonvilleFL32210GRP-9613—
TPATPA-609682026-06-07T17:11:25ZKenneth····West1989-04-08——UNKNOWNnull8925 PINE DR·AustinTexas··NULL——
TPATPA-599622026-07-13T01:32:48ZRICHARD—BENNETT··1991-07-15—nullUNKNOWNrichard.bennett68@gmail.com7321 River Road··TempeArizona85265—·N/A
TPATPA-607952026-02-13T11:55:45ZStephens—Fatima··Jul 4, 1995N/A—····N/A1103 MAIN STSacramentoCA95862··——
TPATPA-57900 2026-07-10T20:38:32ZRay, Mariana——1981-12-14NULL··—443-506-3290null5557 Hillcrest RdMinneapolisMN55417N/A—
TPATPA-644622026-05-20T01:34:08ZEugene—Graham··1950-06-16—-—UNKNOWN7226 Oak StreetAtlantaGA30343GRP-6525NAVIGATE-HMO
TPATPA-535962026-02-24T02:23:53ZClark, Walter——Apr 23, 1938—NULL462-283-1591—·6835 OAK STREETSAN DIEGOCA··92132UNKNOWNMEDICARE-ADV-A
TPATPA-621762026-09-19T08:44:34ZISABELLA····REED·1987-08-24-•••-••-0210—NULL8519 Main St #450GilbertAZ85250nullNULL
TPATPA-593172026-07-15T21:52:10ZNguyen, Jeremy——1990-03-26—·-—UNKNOWN5719 JEFFERSON AVENUEAtlantaGA30308—OPTIONS-PPO
TPA TPA-629642026-08-21T11:57:41ZEric—Hernadez17-04-1979—UNKNOWN16863443440··—5841 Forest AvenueLos AngelesCA90034-UNKNOWN
TPATPA-532202026-08-17T01:52:02ZHarris, Jordan——1951-12-25UNKNOWNNULL——1233 Forest AvenueLAS VEGASNV89120—UNKNOWN
TPATPA-518442026-09-10T12:16:48ZPriya—Rodriguez1950-11-12——688.982.1901null3100 Apache BoulevardSeattleWA98174—UNKNOWN
TPATPA-532152026-07-27T14:41:27ZEmilyV.Spencer2002-01-14UHC-55914-20•••-••-9818NULL—7951 BAYSHORE DRLOS ANGELESCA90029—N/A
TPATPA-571532026-06-26T03:58:13ZJERRY—WATKINS7/7/1957N/AUNKNOWN—····2207 Washington St Apt 39Los AngelesCA90098-8664GRP-3716—
TPATPA-569792026-06-27T07:43:12ZMary—Peters1970-05-23UNKNOWN·nullNULL—4536 Sage CtSan AntonioTX78232GRP-4582UNKNOWN
TPATPA-622892026-01-24T22:36:27Z Mari····Wells1971-03-17—-—····-UNKNOWNUNKNOWNN/AN/A··-
TPATPA-543892026-10-14T03:49:59Zfatima—·simmons—NULL-·UNKNOWN—388 CHURCH ST #621ColumbusOH43239NULLoptions-ppo
TPATPA-576742026-02-14T23:31:01ZEMILY—·HARRIS10/25/1967UHC-11654-18•••-••-0697——5568 APACHE BLVDOrlandoFL32860GRP-1238····
TPATPA-520892026-07-26T08:44:41ZElijahN.Bishop1965-08-08—NULL446.810.9924elijah.bishop@gmail.com————NULLSELECT-EPO
TPATPA-513962026-01-08T21:44:09ZYuki—Richardson1982-02-08—•••-••-29366144330688—2434 Forest Ave #229Eden PrairieMN55340N/ANAVIGATE-HMO
14,474 rows, page 155 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:49.115Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty