Saint Paul rental stock and apartment sales, 2009 to 2026 Published by the Twin Cities Renter Guide, twincitiesrenterguide.com. Last updated: Oct. 27, 2026 DESCRIPTION Year-by-year counts of Saint Paul's apartment tax classes (4A and 4d low-income rental) and units, the assessor's market value per apartment unit, apartment building sales by year, and apartment purchases by businesses since 2022. Behind the chart "Did Saint Paul lose apartments after rent stabilization?" on the Can a city protect renters and still build? card, the "Who's been buying" table on Slumlord Millionaires, and the "Last sold" line in the landlord lookup. FILES - saint-paul-rental-stock-2009-2026.csv: one row per assessment year. - saint-paul-apartment-sales-by-year.csv: one row per sale year. - saint-paul-apartment-purchases-2022-2026.csv: one row per deal bought by a business, 2022 to March 2026. - source-ramsey-assessor-saint-paul-apartment-classes-2009-2026.csv: copy of the source rows for 4A and 4d parcels, every year (39,015 rows). The sale date and sale price columns are left out, because some of these parcels are owned by private people. The full Saint Paul pull (about 1.5 million rows, all classes) is too big to post; it comes from the link below. Each file has a -dictionary.csv, including the county source copy (source-ramsey-assessor-saint-paul-apartment-classes-2009-2026-dictionary.csv). SOURCE Ramsey County, Assessor Parcel Data (Open Data Portal, dataset 4fwy-py9e), https://opendata.ramseycountymn.gov/Housing-Property-and-Development/Assessor-Parcel-Data/4fwy-py9e/about_data Retrieved Oct. 27, 2026, for every assessment year from 2009 to 2026. Saint Paul rows are the ones labeled with Saint Paul's 17 district councils (municipality 01 to 17). Owner names come from the Twin Cities landlord dataset (MetroGIS regional parcels), matched by parcel ID. METHOD Classes come from primary_classification. The 4d low-income rental class was code 229 through 2023 and 224 from 2024. Units are living_units; a blank counts as 0. Sales: each year's file carries the parcel's latest sale as of when the county last refreshed it, so we combined every distinct parcel, sale date and price, took the class and units from the assessment year of the sale (or 2026 if missing), kept 4A and 4d parcels with units, and treated parcels sold on the same date for the same price as one deal. LIMITS - The county keeps only each parcel's most recent sale (plus one earlier sale for parcels that sold again between early 2025 and March 2026). A building sold in 2015 and again in 2023 shows only the 2023 sale, so older years are undercounted. Year-to-year comparisons are reliable only from about 2020 on. - Recorded prices can include transfers between related companies and tax-credit partnership restructurings. Deals that fail the market check (see the dictionary) are left out of totals. - A parcel with several classes is counted under its primary class only. - Market values are the assessor's estimates and aren't adjusted for inflation. - The class says nothing about why a building moved into or out of 4d, or about rents. OPENING THE FILES The CSV files are UTF-8 text. In Excel, use Data > From Text/CSV, choose UTF-8, and set ID columns (parcel, license, block and precinct codes) to Text; opened by double-click, long numbers lose digits and leading zeros and some punctuation can look wrong. LICENSE CC BY-NC 4.0 (Creative Commons Attribution-NonCommercial 4.0 International, https://creativecommons.org/licenses/by-nc/4.0/). Credit: "Source: Twin Cities Renter Guide (twincitiesrenterguide.com), CC BY-NC 4.0." Commercial use needs written permission; news reporting, research, teaching, government use and nonprofit organizing are already allowed with credit. USE RULE (part of the guide's terms): don't use this data to harass, dox, threaten or target anyone, to discriminate against renters, or for anything illegal. Pass this rule along if you share it. The public records behind this file belong to their publishers (listed above) and follow their terms. Full terms: https://twincitiesrenterguide.com/#terms-of-use