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-621982026-07-20T23:21:24ZRICHARDIPETERS14-07-1949UNKNOWNUNKNOWN241-231-1818NULL8617 CENTRAL AVE Apt 11MinneapolisMN55418UNKNOWN-
TPATPA-615992026-10-17T19:46:13ZAdam—Carlson1990-04-20——N/ANULL2767 Lake View RoadDenverCO80281-3888——
TPATPA-636372026-01-27T19:26:54Zbutler—hannah1987-06-26UHC-70941-53UNKNOWN··UNKNOWN5044 Union StSAN ANTONIOTX78212-MEDICARE-ADV-A
TPATPA-643132026-01-08T11:20:20ZPAUL—NGUYEN24-02-1989—N/A—null5530 Indian School Rd··PhoenixAZ85028NULLOPTIONS-PPO··
TPA TPA-582002026-07-02T01:17:47ZArmstrong, Charles——·09/13/1998-····N/A-1851 MAPLE AVENUESeattleWA··98184—CHOICE-PLUS-PPO
TPATPA-516562026-02-18T14:52:51ZSTEPHEN—COOK2001-11-05UHC-38054-36··—881-665-0692—433 MAIN STREETSan AntonioTX78202-····
TPATPA-535632026-06-03T15:35:51ZJonathan····Ferguson14-10-1989N/A•••-••-7380—UNKNOWN7819 Cedar LaneSeattle·WA98120GRP-6804-
TPATPA-572752026-04-01T20:28:44ZMARGARET—TUCKER1993-08-05—•••-••-5477-—3606 MESA DRIVESan DiegoCalifornia92146GRP-2193—
TPATPA-515962026-09-13T13:57:28ZRACHEL—FERNANDEZ1965-06-19····—(438) 742-0693—2170 HILLCREST ROADSacramentoCA95830—UNKNOWN
TPA TPA-627002026-01-07T13:51:46Z·maria—hayes17-08-1977—•••-••-8925—NULLnullUNKNOWN··-NULLNULL
TPATPA-558962026-09-05T18:48:41ZSingh, Lori—··1973-06-04—-NULL··2288 Canyon RoadDenverColorado80250—null
TPATPA-526002026-06-01T12:42:43ZEmily—Perez4/28/1997UNKNOWNNULL407-559-8766—74 JEFFERSON AVEColumbusOH43244nullNAVIGATE-HMO
TPATPA-507732026-02-02T05:41:16ZMariana····Shaw10/19/1991·UNKNOWN•••-••-6837+1 557 710 6620mariana.shaw45@yahoo.com--——nullMEDICARE-ADV-B
TPATPA-517802026-03-29T14:14:48ZKelly, Jean··M—1954-06-06UNKNOWNnull-—5987 Central AvenueSeattleWashington98124··—NULL
TPATPA-610952026-01-06T11:10:59ZELIZABETH—RICHARDSON19940112-NULL——7983 Park PlSacramentoCA95858GRP-5473CORE-HMO
TPATPA-542912026-09-06T08:48:08ZBOBBY··VAZQUEZ1940-03-17null—+1 454 771 4809—8042 BASELINE ROADNashvilleTN37224——
TPATPA-564462026-01-30T10:36:58ZKevinZMorris05/10/38NULLN/A+1 392 387 8287—2422 Willow CtAustinTexas··78755NULLOPTIONS-PPO
TPATPA-580202026-03-14T14:52:13ZSarah—Knight1982-04-06UNKNOWN·UNKNOWN822-867-3916N/A7683 SUNSET BLVD··Minneapolis·MN55499—OPTIONS-PPO
TPATPA-562122026-04-03T10:08:29ZMaria—Jordan8/2/1956UNKNOWN—+1 524 519 3419UNKNOWN9605 CEDAR LNAustinTX78745—·null
TPATPA-619762026-05-23T14:52:56ZDoris··—Jimenez2001-08-20·nullUNKNOWN341-256-4479··DORIS.JIMENEZ@AOL.COM3960 Lincoln WayTUCSONAZ85727—null
TPA TPA-509912026-04-13T23:06:35ZLaurenOStephens1994-01-02UHC-21092-63—N/AN/A8542 VALLEY VIEW DRIVETempeAZ—UNKNOWNCORE-HMO
TPATPA-537282026-01-10T06:20:53ZBRIAN—JENSEN21-09-2001N/A—+1 297 416 6832··3976 Canyon RoadCharlotteNC28276-9070UNKNOWNNULL
TPATPA-535522026-01-08T18:58:34Z virginia—lynch07-12-1950null•••-••-0662——-—nullNULL—SELECT-EPO
TPATPA-576022026-07-12T16:20:33ZGeorge—WebbOct 25, 1956NULL•••-••-843714089673281george.webb@aol.com8325 Park PlaceDallasTX75200-2132GRP-8546—
TPATPA-565112026-02-22T20:40:56Zolivia—ruiz1/18/1961——UNKNOWN-9419 Apache Boulevard #974AustinTX·NULLN/ANAVIGATE-HMO
TPATPA-616582026-01-19T17:52:18ZTONY—THOMPSON1957-06-26N/Anull——7223 Church StreetPLANOTX75002-SELECT-EPO
TPATPA-643582026-02-02T19:27:16Z·Duris—McDonald1977-06-19UHC0091081N/A··(531) 825-0759UNKNOWN566 CHURCH STREETChandlerArizona85203N/A—
TPATPA-531442026-04-03T10:06:10ZHelen—Kelley1996-05-12NULL•••-••-9739770-462-3558N/A9444 VALLEY VIEW DRCOLUMBUSOH43248NULLCHOICE-PLUS-PPO
TPATPA-574152026-10-13T17:27:07ZKevin—Marshall1962-04-05UNKNOWNN/A18177369229··—6674 Sage CourtTampaFL33694·GRP-8519—
TPATPA-523842026-09-11T06:25:13ZMari··—Ramireez1999-04-23UHC-45453-34nullN/A—1102 Market StLos Angeles··CA90037GRP-7360··SELECT-EPO
TPATPA-594002026-09-11T02:31:46ZNoah—·CookAug 22, 1966——UNKNOWN—7531 Oak StreetAustin··TX78733GRP-0612—
TPATPA-545062026-05-10T22:44:41Zlawrence—hicks1954-03-16—•••-••-84446608903294LAWRENCE.HICKS95@ICLOUD.COM1518 CANYON RDEden Prairiemn·NULLN/A—
TPATPA-505272026-02-28T17:03:46Zbrittany—·hawkins1993-08-16UNKNOWN•••-••-8605-UNKNOWN4053 Pine DriveCharlotteNC··28241-3012UNKNOWNN/A
TPATPA-578232026-07-11T03:45:10ZCeryl—Cunningham1963-02-20---cheryl.cunningham@hotmail.com9223 Elm StreetSeattleWA98192GRP-5376-
TPATPA-558342026-04-19T14:32:49ZWILLIE—HICKS··04/17/62UHC-95705-04UNKNOWNNULL-5869 Lincoln Way·Los AngelesCalifornia90031-0438nullMEDICARE-ADV-B
TPATPA-562092026-07-29T12:08:28ZLopez, Madison—··1945-02-18UHC5442431•••-••-837812767735983N/A673 Grand AvenueLas VegasNV··89177-6658UNKNOWN-
TPATPA-517822026-06-19T00:30:16ZZacharyRCarpenter1946-09-12-—N/A-4234 Central AvenuePhoenixAZ85025—OPTIONS-PPO
TPATPA-572992026-06-27T18:16:38ZLogan—Bailey2001-10-07··UHC-62349-08null-··—2684 Grand AvenueJacksonvilleFL32209GRP-8027····
TPA TPA-541082026-01-09T14:18:47ZDouglas—Robisnon1974-11-27null—null—9031 Apache BlvdNashvilleTN··37242···GRP-2881MEDICARE-ADV-B
TPATPA-541452026-10-14T05:52:52ZBeverly—Bailey··19860420null—-NULL5723 Spring StGilbertAZ85222UNKNOWN—
TPATPA-624902026-07-15T00:04:02ZLUIS—WEBER1955-07-22UHC-82340-28•••-••-5695——452 Willow CourtLOS ANGELESCA90040-N/A
TPATPA-575082026-01-28T06:24:59ZcherylD.thomas04/20/97null-null—8372 Cedar LnEden PrairieMN··N/AGRP-0896—
TPATPA-524662026-02-18T02:55:03ZDominguez, Roger——5/18/1946—•••-••-25784357984198UNKNOWN668 Forest AveLas VegasNV89193—CHOICE-PLUS-PPO
TPATPA-511612026-08-05T14:13:59ZANTHONY—MERTINOct 23, 1982null•••-••-0160——2343 OAK STREETPhoenixAZ85045-2771—·MEDICARE-ADV-A
TPATPA-539732026-04-01T20:43:09ZANA—COOK1938-07-28N/A—446-955-4109-UNKNOWN————CHOICE-PLUS-PPO
TPATPA-538722026-02-25T17:40:19ZVINCENT—RIZ··1997-09-22NULL—NULL··2484 CENTRAL AVEEden Prairiemn-GRP-2411NULL
TPATPA-571312026-05-13T11:10:09ZElizabeth—Li02/01/54-UNKNOWN-elizabeth.li@icloud.com3590 Willow CtEden PrairieMN55392-8796UNKNOWNOPTIONS-PPO
TPA TPA-500192026-01-21T02:38:40ZFranklin, Jeeremy····—09/25/1974UHC-69691-36null(761) 888-5265———NULLUNKNOWNUNKNOWN—
TPATPA-551592026-10-02T19:14:58ZGERALD—KING1991-07-16NULL•••-••-7499UNKNOWN··NULL9108 Palm DrTempeArizona85212-1154nullOPTIONS-PPO
TPATPA-508462026-10-10T17:57:59ZCharlotte—Alexander2001-07-07NULL——-903 Meadow LnHoustonTX77049N/A—
14,474 rows, page 258 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.530Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty