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-615492026-01-16T04:55:03Zrussell—schultz1964-07-04——(539) 281-5153RUSSELL.SCHULTZ@AOL.COM--····—GRP-1080-
TPATPA-507202026-06-03T19:59:26ZHenryK.Powell2008-12-15——null··-9155 MOUNTAIN VIEW DRMinneapolisMN55442--
TPATPA-619282026-09-02T03:36:17ZCHRISTIAN—CLARK1953-09-17—N/A——2938 Maple AvenueCHANDLERAZ85239GRP-5516·MEDICARE-ADV-A
TPATPA-597512026-10-13T07:39:28ZSCOTT—SPENCER1986-04-25—•••-••-3324nullN/A8322 Apache BoulevardJacksonvilleFL32255-CHOICE-PLUS-PPO
TPATPA-605762026-08-16T11:12:50ZCruz, Kyle——May 2, 1947—UNKNOWN——·2342 Church St·JacksonvilleFL32226—-
TPATPA-569212026-04-24T23:06:46ZRANDY—GRIFFINnull—N/AN/AUNKNOWN3473 PINE DRIVESeattleWA98129GRP-1807UNKNOWN
TPATPA-520722026-06-27T05:57:44ZDan—Butler1953-12-10UHC-11269-20———5515 Maple AvenueLas VegasNV89179NULLUNKNOWN
TPATPA-609172026-10-11T14:38:22ZELIZABETH—JONES··02/25/96N/AnullUNKNOWN—9833 Oak StreetLOS ANGELES·CA90087-6424NULLN/A
TPATPA-598692026-09-26T22:57:26ZDonald—Amstrong03/18/1956null•••-••-1235—N/A3391 Lincoln Way·GlendaleAZ85380GRP-1511null
TPATPA-638212026-01-09T22:30:59ZBryan—Matthews1968-09-15N/A-——5098 Lincoln WayScottsdaleAZ85262·UNKNOWNMEDICARE-ADV-B··
TPATPA-59680 2026-01-31T05:42:18Zjulie—flores2005-12-02—•••-••-0921·785.752.9815julie.flores69@yahoo.com354 LAKE VIEW RDOrlandoFL32818—NULL
TPATPA-633642026-03-20T13:32:11ZDiana—Ryan1955-01-07null—753-898-5601diana.ryan68@gmail.com8473 Meadow LnGilbertAZ85209NULL—
TPATPA-509482026-07-12T22:49:05ZstephenE·mason1949-01-20UHC-11372-10UNKNOWN—N/A5037 OCEAN AVEColumbus·OH43224GRP-8993—
TPATPA-642112026-08-24T10:13:19ZJoe—HerreraNov 14, 1993UHC-92339-35NULL—null9242 Willow CtFresnocanull—-
TPATPA-574162026-10-03T10:09:20ZDiana—Chen1971-06-13—·UNKNOWNNULL-3556 MEADOW LANEEden Prairie··MN55313··NULL—
TPATPA-616712026-02-26T02:15:10ZWei—Nichols1996-11-05—•••-••-16823308629625—8744 Sunset BoulevardChandlerAZ85236GRP-3621··—
TPATPA-536792026-04-26T06:34:46ZASHLY—OLSON1946-05-10··——null5864 Willow CourtGilbertAZ85239GRP-1169—
TPATPA-625282026-04-06T09:28:40ZJuan—Marshall10/26/1938N/A•••-••-7692—UNKNOWN4144 Maple Ave··GilbertAZ85284··—UNKNOWN
TPATPA-551312026-04-11T13:15:49Zbrandon—park07/13/57—····NULL—1620 Willow Court··ScottsdaleAZ85294GRP-1559··OPTIONS-PPO
TPATPA-596462026-06-12T09:04:51ZOmar—Grant9/21/1979UNKNOWN··——-3168 Baseline RdColumbusOH43288GRP-5919-
TPATPA-598852026-03-28T03:05:27ZMARILYN—HALL1963-03-04-•••-••-8746N/ANULL1501 Valley View DriveEden PrairieMN55304-—
TPA TPA-521692026-02-23T11:40:37ZKimberly—Wilis1954-04-24NULLNULLN/A—5805 Park PlaceSan Diego·CA92106NULLUNKNOWN
TPATPA-608712026-10-08T15:11:34ZBRADLEY—RUSSELL1977-02-07NULLnull··bradley.russell@icloud.com3277 Bayshore DriveSACRAMENTOCA··95833NULL-
TPATPA-518202026-05-11T16:23:50ZLawson, Debra——08/19/39—•••-••-4616980-429-1247N/A6946 Market StDallasTX75270NULLN/A
TPATPA-549622026-02-07T19:20:13Z Camila—Perins1986-01-14——--3532 Canyon RoadScottsdaleAZ85248·UNKNOWNnull
TPATPA-543592026-02-20T12:54:13ZHenry—Espinoza26-07-1959UHC-08632-94—nullNULL1745 CHURCH STAustinTX78795—null
TPATPA-545492026-08-11T09:10:55ZADAM—GRIFFIN1999-11-11—•••-••-0330274-632-9625—···N/AUNKNOWNUNKNOWN··nullMEDICARE-ADV-A
TPATPA-596042026-05-07T04:03:44ZEric—James·1977-02-03UHC0721769—UNKNOWNUNKNOWN·1977 LINCOLN WAYHoustonTX77000GRP-3302NAVIGATE-HMO··
TPATPA-618052026-06-23T06:41:05Zbobby—ferguson1975-12-21——690.967.9502UNKNOWN·4853 LAKE VIEW RDChandler·AZ85273·NULL—
TPATPA-540642026-05-12T10:02:26ZKATHRYN—NICHOLS—NULL•••-••-6474851.704.2478—3840 UNION STMinneapolisMNnullUNKNOWNNAVIGATE-HMO
TPATPA-616932026-08-02T21:59:48ZLISA—COOK15-04-1967UNKNOWNUNKNOWNUNKNOWN··8671 Pine Dr·AustinTX78798NULLCHOICE-PLUS-PPO
TPATPA-547192026-03-31T00:31:20ZRice, Jacqueline··——1965-03-03·NULL—+1 364 834 7640—8134 Lake View RdATLANTA··GA30349-0164——
TPATPA-534202026-01-13T01:02:44ZFRANK—ANDERSON10/2/1941—nullNULL-3969 Apache BoulevardTucson·AZ85784N/A-··
TPA TPA-531622026-01-09T08:53:55ZGloria—Rogers1985-03-18null—-UNKNOWN5350 Desert Sky BoulevardATLANTAGA30347—null
TPATPA-56348 2026-10-13T11:33:51ZAlice—MorrisJan 24, 1990——UNKNOWNnull1934 Indian School RoadMesaAZ85252—NULL
TPATPA-561192026-04-24T22:33:10ZJulia····Jones14-12-1940—nullnullUNKNOWN5880 Cedar LnSeattleWA98174——
TPATPA-573602026-02-24T08:55:03ZGrace—Hernandez··1950-12-14—•••-••-1760(207) 528-9147—·1280 SUNSET BLVD Apt 5ChandlerAZ85229nullN/A··
TPATPA-626942026-04-18T23:00:11ZHiroshi—Herrera1979-01-23N/A•••-••-5209-UNKNOWN··4577 Union StreetPlanoTX75018UNKNOWN-
TPATPA-523912026-10-13T19:08:49ZJOHN—SNYDER04/10/49UHC-19895-89•••-••-4448(921) 492-8644····1460 Church StSan DiegoCA92181····MEDICARE-ADV-A
TPATPA-558552026-05-04T16:47:05ZAmbber—Brown··04-01-1948N/A—7732869431—5547 Hillcrest RdTUCSONAZ··85743-5958null··CHOICE-PLUS-PPO
TPATPA-537892026-06-10T01:44:58ZKathryn—Black1999-08-22—•••-••-7403UNKNOWN—NULLNULL-NULL--
TPATPA-619392026-09-28T06:13:50ZKyle··Cook20-06-1963—null19472163495UNKNOWN8422 Hillcrest RoadTAMPAFL33671--
TPATPA-573132026-07-12T22:48:32ZBUTLER····DYLAN1971-06-18null-12456384148—5807 Church StreetHoustonTexas·77095NULLnavigate-hmo
TPATPA-525322026-05-10T11:21:19ZPeggy—Bryant19650906··—-2794077712—1180 UNION STHoustonTX77099N/AUNKNOWN
TPATPA-542752026-10-07T11:14:22ZRachel····Vargas1969-09-01—-715-670-5137—2429 Central AveAustinTX78749UNKNOWN—
TPATPA-546882026-08-18T09:21:21ZWei··Carroll1995-02-10UNKNOWNUNKNOWN13265855563null1945 OCEAN AVE #936NashvilleTN37220—MEDICARE-ADV-B
TPATPA-639262026-10-06T12:10:22ZRACEHL—PAYNE1938-01-01—-··+1 467 727 3440NULL6669 Ocean AvenueOrlandoFL32838-CHOICE-PLUS-PPO
TPATPA-619792026-07-30T03:14:37ZHelen··—Gray1997-02-18NULL•••-••-2397-—6062 Canyon Rd #813··TucsonAZ85792GRP-2449N/A
TPATPA-624402026-08-16T00:17:56ZJerry—Willimason1992-00-89·UHC-31382-25•••-••-9860-··—·4925 Jefferson AveChandler··AZ85233nullN/A··
TPATPA-633822026-05-14T16:04:32ZethanP·weber12/18/1981null··—(342) 782-4017UNKNOWN3382 Lincoln Way·MiamiFL33161··N/A
14,474 rows, page 2 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-19T19:54:25.414Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty