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-517882026-10-09T16:23:49ZalbertIkim09/03/89N/AN/A-··null—UNKNOWN——UNKNOWNN/A
TPATPA-520342026-01-25T21:10:55Zmarc—wells1954-04-20—N/A·978-222-9188null9829 RIVER RDDENVERco80225--
TPATPA-587112026-06-18T15:39:25ZBillyB.Garcia1/11/1954——224-293-0388—4474 HIGHLAND AVESAN ANTONIOTX78234null—
TPATPA-624092026-03-15T07:41:50ZHrrison, Roger····—1992-07-11UHC0316133null·3935596005NULL9840 Central Ave Apt 18GlendaleArizona85389nullCHOICE-PLUS-PPO
TPATPA-543712026-10-05T00:32:18ZMasonPBrooks0490-19-67·null—·(772) 422-3662·NULL563 Lake View Road···San DiegoCA92174—CORE-HMO
TPATPA-581672026-05-18T05:05:44ZBobby··—Franklin2008-09-04—NULLNULL-3777 Cedar LnMesaAZ85268——
TPATPA-631122026-03-02T04:53:59ZCarlG.Marquez1958-09-18N/A•••-••-5544(819) 918-9280—2916 Sage Ct···MiamiFL33117—OPTIONS-PPO
TPATPA-613062026-03-11T00:12:32Zedward—alvarado1960-06-18UHC-97144-40··——edward.alvarado28@proton.me6451 Sage CtSan AntonioTX78244-6833—N/A
TPATPA-602392026-07-13T23:39:20ZAMY—BERRY··19421121-•••-••-0182UNKNOWNamy.berry@proton.me2566 Lake View RoadGlendaleaz85304GRP-1894—
TPATPA-622622026-10-18T04:47:30ZMichelle—Reed1990-08-13-UNKNOWNN/A-8363 Mesa DrPhoenixArizona85052GRP-6925··MEDICARE-ADV-B
TPATPA-625392026-08-23T05:54:43ZAnnXBowman6/15/1970—NULL—ann.bowman@aol.com6414 Ridge RoadPhoenixAZ··85023null··—
TPATPA-530702026-03-21T20:35:55Zchristian—walker1970-03-18-null219-610-2158N/A2675 Pine DriveTampaFL33688-8296GRP-7443N/A
TPATPA-595722026-07-03T23:38:27ZBetty···Jimenez19791125null··UNKNOWNN/A5854 LAKE VIEW ROADAtlantaGA30378-1166GRP-1998MEDICARE-ADV-A
TPATPA-586592026-03-08T02:43:33Z·Donna—Young1959-04-09null•••-••-8056null—9562 Grand AveTAMPAFL33640—OPTIONS-PPO
TPATPA-532882026-03-17T13:42:33ZTERESA—HANSEN1960-05-19—•••-••-1459518-848-3308TERESA.HANSEN@GMAIL.COM5250 Jefferson AveMINNEAPOLISMN55462—UNKNOWN
TPATPA-568392026-05-04T07:56:15ZNunez, CherylK—1974-03-17N/A•••-••-4198·800.487.2922NULLUNKNOWN—nullN/AGRP-5990NULL
TPATPA-628692026-08-07T20:50:43ZOmar—Gonzales1974-03-09NULL•••-••-5711——8492 Jefferson AveMiamiFlorida33148-N/A
TPA TPA-584172026-04-15T22:03:23ZGary—Jordan03/09/77——··N/A——null-—CHOICE-PLUS-PPO
TPATPA-558112026-06-14T17:21:23ZMatthewSMedina1961-09-14UNKNOWN·NULL644-275-2167·matthew.medina38@aol.com·9132 Spring StreetHouston·TX77061-—
TPATPA-515642026-03-20T04:27:15ZOlivia—Daniels1944-04-16UNKNOWN—299.652.9031UNKNOWN6761 Jefferson AveLas VegasNV·89183UNKNOWN—
TPATPA-604772026-01-18T02:35:41ZBENJAMIN—COX1983-03-07nullN/A··9548847null2173 Main StSAN ANTONIOTexas78230null—
TPATPA-577692026-06-04T22:02:46ZFatima—Daniels··2007-06-08··—•••-••-4428——500 Desert Sky BlvdPlanoTX75014-2069——
TPATPA-502442026-08-12T08:35:55Z ·Tyler—MorenoNov 12, 1994-—-N/A1312 Ridge RoadSeattle··WA98120-··MEDICARE-ADV-A
TPATPA-525762026-03-05T04:37:55Z David—Lewis04/09/81—-N/A—5645 Apache BoulevardEden PrairieMN55366GRP-8541navigate-hmo
TPATPA-591802026-06-29T17:39:12ZELIZABETH—SCHULTZ··12/24/67—•••-••-3184906.667.3297·elizabeth.schultz@outlook.com9384 Pine DriveFRESNOCA93758-NULL
TPATPA-558782026-05-23T01:40:27ZLe, Jackie——28-04-1977-NULL—UNKNOWN4245 MEADOW LNLas VegasNV89196UNKNOWNOPTIONS-PPO
TPATPA-642002026-01-14T06:16:58Zbenjamin··—copoer1968-06-14····—14894411550·-5419 Market StreetHoustontx77041UNKNOWNnull
TPATPA-529092026-05-19T03:31:57ZBaker, Betty——2007-02-15UNKNOWN•••-••-0844NULLNULL4417 Mountain View DrFresnoCA93743GRP-9835-
TPATPA-623622026-09-01T12:56:02ZJoseGWilliams19490605nullnullnull····4096 Oak St Apt 23Las Vegas·NV89125N/A—
TPATPA-630842026-03-25T12:17:08ZKIMBERLY—HAYES1991-10-13N/ANULL—·KIMBERLY.HAYES@YAHOO.COM1773 Ocean Avenue Apt 40ColumbusOH43281--
TPATPA-558772026-08-23T03:59:11ZALBERT—HAYES1993-09-23nullNULLN/AUNKNOWN·1017 WILLOW COURTTempeAZ85201-4966NULLUNKNOWN
TPATPA-508092026-05-08T03:20:48ZJACK—SMITH19610909—N/ANULLjack.smith9@gmail.com6832 Meadow LnDallasTX75251—NULL
TPATPA-530932026-01-29T21:32:44ZBobby····Jordan1/10/1948————8985 Valley View DriveDallasTX75295——
TPATPA-577392026-03-05T20:11:58ZLawrence—Crawford1941-10-23····•••-••-9857(675) 506-3111lawrence.crawford@proton.me736 Grand AveCHANDLERAZ85209GRP-8786MEDICARE-ADV-B
TPA TPA-53064 2026-02-26T22:10:18ZGrant, Russll——·1961-10-09—UNKNOWNUNKNOWN-2049 CHURCH ST··GLENDALEAZ85306GRP-4809··N/A
TPATPA-513192026-06-08T17:17:25ZKIMBERLY—PARKER2002-12-14UNKNOWN——·NULL7164 Elm Street Apt 11ChandlerAZ··85227-OPTIONS-PPO
TPATPA-58676 2026-04-07T08:48:35ZMaarcus··Phillips1947-07-07UHC-71760-25N/ANULLUNKNOWN1165 Indian School RdDenverCO80293GRP-6397null
TPATPA-582142026-10-10T21:39:32ZHenry····Daniels03/11/45UNKNOWN-··henry.daniels25@gmail.com2317 Church StLos AngelesCA90076GRP-8996-
TPATPA-514822026-03-10T17:55:34ZBrian—Flores18-06-1958-———9152 LINCOLN WAYLas VegasNV89162NULL—
TPATPA-560602026-10-12T02:31:28ZWillie—Robinson·1967-08-05——-null5548 Valley View DriveJacksonville··FL32295-—
TPATPA-581142026-06-06T11:23:29ZJones, Aaron——10/01/1992—•••-••-21775204402227··UNKNOWN—N/A—N/AGRP-4726—
TPATPA-516482026-10-16T13:23:32ZCYNTHIAMMORALES1963-04-10——494-207-1346CYNTHIA.MORALES98@PROTON.ME··1807 Canyon RoadEden PrairieMN55398GRP-4779—
TPATPA-531682026-09-30T19:11:22ZLopez, KyleE—5/5/1956UHC-73389-11null9442025083KYLE.LOPEZ@AOL.COM5858 Sage CourtCHANDLERAZ85219——
TPATPA-546232026-05-23T13:49:33ZMei—Little—null•••-••-69993266580463N/A8602 Central AveEden PrairieMinnesota55310··—null
TPATPA-504752026-07-31T05:37:17ZHudson, Jack——1946-12-16-•••-••-6548-UNKNOWN5259 River Rd··GilbertAZ85265··NULL··
TPATPA-521842026-05-11T06:15:55ZSARA—PADILAL07/06/1981——-—690 Main StTAMPAFL33683nullUNKNOWN
TPATPA-520692026-08-14T03:06:21Z ANN·RCOOK01/18/2002null—405-288-1246null6761 PARK PLFresnoCA93746NULL-
TPATPA-536862026-09-22T22:08:39ZAHMEDHWAGNER19810101——3142204944UNKNOWN212 Bayshore Dr #636Seattle··WA98121—SELECT-EPO
TPATPA-589242026-05-02T16:51:20ZAMY—BISHOP1981-06-26UHC-03676-75•••-••-0539nullUNKNOWN599 Highland AveTucsonAZ85718··GRP-9978N/A
TPATPA-515812026-07-19T00:47:01Z·REBECCA—WILLIAMS11/15/1972UNKNOWN•••-••-3999——5115 Elm StreetDallasTX75257·GRP-0594NAVIGATE-HMO
14,474 rows, page 69 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.342Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty