{"ok":true,"what":"Brick & Mortar — free public-records exports for the Twin Cities.","usage":"/api/export?dataset=<id>&scope=<key>&columns=<a,b,c>&format=csv|xlsx|json|geojson","datasets":[{"id":"trades","title":"Business counts by trade, five vintages","subject":"the seven-county Twin Cities metro · business counts 2017 · 2019 · 2021 · 2022 · 2023 · employment and pay 2025 Q4","rows":318,"scopes":[{"key":"all","label":"every trade","rows":318},{"key":"growing","label":"trades that grew","rows":134},{"key":"shrinking","label":"trades that shrank","rows":171}],"columns":["trade","naics","y2017","y2019","y2021","y2022","y2023","change_pct","workers_per_business","avg_pay_per_worker_usd","employees_now","avg_weekly_wage_usd","wage_basis_pct"]},{"id":"building-stock","title":"Building stock by era","subject":"Hennepin + Ramsey · 1880–2026","rows":12,"scopes":[{"key":"all","label":"all property","rows":6},{"key":"commercial","label":"commercial only","rows":6}],"columns":["era","buildings","share_pct","stock","first_year","last_year","incomplete"]},{"id":"county-profile","title":"Who lives here, and what they pay","subject":"Hennepin and Ramsey counties · 2020-2024 ACS 5-year","rows":24,"scopes":[{"key":"hennepin","label":"The Minneapolis side","rows":12},{"key":"ramsey","label":"The St. Paul side","rows":12}],"columns":["measure","shown","county","unit","value","period"]},{"id":"adjacency","title":"What shares a lot line with a property","subject":"Hennepin + Ramsey + Dakota + Anoka + Washington + Scott + Carver · 52,686 commercial parcels · the longest shared line on each side","rows":115652,"scopes":[{"key":"all","label":"every side of every parcel","rows":115652},{"key":"residential","label":"sides that back onto housing","rows":23500},{"key":"vacant","label":"sides with vacant land next door","rows":9581},{"key":"zoning_edge","label":"sides where the zoning changes","rows":5522}],"columns":["address","side","neighbour_address","neighbour_use","neighbour_zoning","neighbour_zoning_name","shared_line_ft","neighbour_assessed","neighbour_building_sqft","building_sqft","zoning","zoning_name","zoning_city","zoning_edge","split_zoned","in_floodplain","parcel_id","use","assessed","owner","taxpayer","neighbour_id","neighbour_built","neighbour_lot_sqft","neighbours_on_this_side","residential_edge","vacant_land","county"]},{"id":"corridors","title":"Walk a corridor, address by address","subject":"Hennepin + Ramsey + Dakota + Anoka + Washington + Scott + Carver · 1,267 named runs carrying at least 15 mapped parcels","rows":44151,"scopes":[{"key":"all","label":"every mapped run","rows":44151},{"key":"through","label":"arterials and collectors","rows":23829},{"key":"arterial","label":"arterials only","rows":1643},{"key":"counted","label":"runs with a measured traffic count","rows":11114},{"key":"busiest","label":"as busy as an arterial, whatever it is classed","rows":1118},{"key":"permitted","label":"permitted since 2024-08-17","rows":5464}],"columns":["corridor","station_ft","address","use","zoning","zoning_name","flood_zone","flood_zone_name","in_floodplain","base_flood_elev","sba_loans","sba_approved","sba_last_fy","sba_charged_off","year_built","assessed","frontage_ft","side","parcel_id","owner","taxpayer","lot_sqft","footprint_sqft","building_sqft","building_sqft_method","stories","structures","all_footprint_sqft","road_class","daily_traffic","traffic_year","traffic_basis","heavy_traffic","heavy_traffic_basis","traffic_dist_ft","vacant_land","businesses","business_mix","zoning_city","split_zoned","last_permit","last_permit_trade","last_permit_work","permits_since_2020","permitted_recently","open_permits","open_permit_last","open_permit_work","open_permit_trade","calls_311","calls_311_recent","last_311_call","top_311_request","recent_311_request","calls_311_on_one_point","parcels_on_this_corridor","county"]},{"id":"sales","title":"What sold, and for how much per square foot","subject":"Hennepin + Ramsey + Dakota + Anoka + Washington + Scott + Carver · sale of record on 34,302 indexed parcels","rows":34302,"scopes":[{"key":"all","label":"every sale of record","rows":34302},{"key":"clean","label":"arms length only","rows":29949},{"key":"recent","label":"sold since 2019","rows":13670},{"key":"comps","label":"usable comps only","rows":21741},{"key":"sized","label":"sales with a building area","rows":11558}],"columns":["address","sale_month","price","lot_sqft","price_per_lot_sqft","price_per_building_sqft","building_sqft","building_sqft_method","footprint_sqft","stories","structures","all_footprint_sqft","use","year_built","assessed","parcel_id","owner","taxpayer","owner_type","arms_length","multi_parcel_deed","shares_price_and_month","usable_comp","county"]},{"id":"owners","title":"Who owns it, and what else do they hold","subject":"Hennepin + Ramsey + Dakota + Anoka + Washington · 9,251 owners holding 2 or more parcels in the commercial index","rows":9251,"scopes":[{"key":"all","label":"every owner with 2+ parcels","rows":9251},{"key":"big","label":"ten or more parcels","rows":415},{"key":"entity","label":"companies and institutions","rows":7174},{"key":"land","label":"owners of vacant land","rows":1586}],"columns":["owner","parcels_held","assessed_total","taxpayer","owner_type","cities","first_purchase","latest_purchase","largest_holding","lot_sqft_total","commercial_parcels","vacant_land_parcels","county"]},{"id":"licences","title":"Who holds a licence to trade here","subject":"5,951 licensed businesses on 3,753 of the 17,007 commercial sites in Minneapolis and Saint Paul — 22.07%","rows":6553,"scopes":[{"key":"all","label":"every licensed business","rows":6553},{"key":"food","label":"food, drink and groceries","rows":3718},{"key":"care","label":"childcare, care homes and clinics","rows":426},{"key":"mpca","label":"on a parcel the state holds a file on","rows":1943}],"columns":["business","type","address","status","expires","category","licensed_since","site_parcel_id","joined_on","source","county","mpca_files","mpca_open","mpca_tanks","mpca_restricted","mpca_note"]},{"id":"census-tracts","title":"How a neighbourhood differs from the typical one","subject":"472 census tracts · Hennepin + Ramsey · 2020-2024 ACS 5-year residents · 2023 jobs","rows":10797,"scopes":[{"key":"all","label":"every tract","rows":10797},{"key":"residents","label":"who lives here","rows":7023},{"key":"jobs","label":"who works here","rows":3774},{"key":"hennepin","label":"Hennepin County tracts","rows":7527},{"key":"ramsey","label":"Ramsey County tracts","rows":3270}],"columns":["measure","shown","median_tract_shown","gap_pct","tract","census_product","county","geoid","value","median_tract","unit","census_variable"]},{"id":"emergency-calls","title":"What the 911 calls around here are about","subject":"Minneapolis only — 87 neighbourhoods inside one city of a seven-county market. 1,646,661 calls from 2020-08-20 to 2026-08-20, aggregated to the neighbourhood because the source publishes no address.","rows":22123,"scopes":[{"key":"all","label":"every call","rows":22123},{"key":"alarms","label":"business alarms only","rows":413},{"key":"police","label":"police responded","rows":13348},{"key":"fire","label":"fire and EMS responded","rows":7024},{"key":"crisis","label":"behavioral crisis team","rows":1751}],"columns":["neighbourhood","subject","calls","vs_city","pct_of_this_neighbourhood","pct_citywide","pct_of_city_for_this_subject","agency","dispositioned_false","no_disposition","priority_1","neighbourhood_calls","first_year","last_year","calls_2021","calls_2022","calls_2023","calls_2024","calls_2025","business_alarm"]},{"id":"landlords","title":"Who the landlord is, on a licensed rental property","subject":"23,303 active rental licences · 124,431 licensed units · Minneapolis only","rows":23303,"scopes":[{"key":"all","label":"every licensed rental","rows":23303},{"key":"absentee","label":"owner lives somewhere else","rows":10995},{"key":"tiered","label":"above the city's Tier 1","rows":859},{"key":"short","label":"short-term rentals","rows":829}],"columns":["owner","address","units","tier","absentee","owner_city","neighborhood","calls_311","top_311_request","calls_311_recent","recent_311_request","last_311_call","calls_311_on_one_point","licensed_since","expires","short_term","owner_state","ward","community","police_precinct","category","status","licence_no","parcel_id","above_tier_1","owner_phone","owner_email","owner_address","owner_zip","applicant_is_owner","applicant","applicant_phone","applicant_email","applicant_address","applicant_city"]},{"id":"contamination","title":"Cleanup and storage-tank files, by address","subject":"Hennepin and Ramsey · 5,587 parcels carrying 7,149 MPCA cleanup or tank files","rows":7149,"scopes":[{"key":"all","label":"every cleanup and tank file","rows":7149},{"key":"open","label":"still open","rows":6001},{"key":"tanks","label":"storage tanks","rows":3666},{"key":"restricted","label":"a legal restriction on the property's use","rows":554}],"columns":["address","site","site_address","status","activity","kind","tanks","cleanup","institutional_controls","assessed","all_activities","programs","industry","lot_sqft","city","county","parcel_id","mpca_record"]},{"id":"contractors","title":"Who does the work here, and how to write to them","subject":"Minneapolis and Saint Paul · 6,588 firms on 47,764 permits · 2020-01-02 to 2026-08-17","rows":6588,"scopes":[{"key":"all","label":"every firm","rows":6588},{"key":"active","label":"still pulling permits","rows":2610},{"key":"structural","label":"structural work","rows":4504},{"key":"busy","label":"ten or more permits","rows":842}],"columns":["firm","main_trade","permits","sites","last_permit","mailing_address","city","first_permit","open_permits","permits_recently","trades","register","value_usd_stp","county"]},{"id":"subsidised-housing","title":"Subsidised homes, and when the subsidy runs out","subject":"1,500 subsidised properties · Hennepin + Ramsey + Dakota + Anoka + Washington + Scott + Carver · 293 carry a contract expiry","rows":1500,"scopes":[{"key":"all","label":"every subsidised property","rows":1500},{"key":"expiring","label":"subsidy ends before 2031","rows":103},{"key":"large","label":"50 or more subsidised units","rows":418}],"columns":["property","address","city","program_family","units_total","units_subsidised","subsidy_expires","county","location_grain","programme","year_in_service","also_in","expiring_soon","occupied_pct","households_reported_pct","median_household_income_usd","pct_aged_62_plus","pct_with_a_disability","also_tax_credit","tract","zip","hud_layer","hud_key"]},{"id":"sba-loans","title":"What a bank actually lent, loan by loan","subject":"8,822 SBA loans · Hennepin + Ramsey + Dakota + Anoka + Washington + Scott + Carver · FY2010–FY2026 · $4.69bn approved, $4.03bn of it disbursed","rows":8822,"scopes":[{"key":"all","label":"every approved loan","rows":8822},{"key":"disbursed","label":"money was disbursed","rows":7477},{"key":"big","label":"$1m or more","rows":1343},{"key":"written-off","label":"was charged off","rows":125}],"columns":["business","address","city","county","program","approved","approval_date","trade","lender","status_label","jobs_supported","status","disbursed","approval_fy","sba_guaranteed","term_months","interest_rate","rate_type","third_party_lender","third_party_dollars","lender_kind","naics","franchise","business_type","business_age","paid_in_full","charged_off","charged_off_amount","written_off","big","zip","parcel_id"]},{"id":"businesses","title":"Who is listed at every commercial address","subject":"88,433 businesses · Hennepin + Ramsey + Dakota + Anoka + Washington + Scott + Carver · on 24,706 of 53,690 commercial sites (46.02%)","rows":88433,"scopes":[{"key":"all","label":"every listed business","rows":88433},{"key":"independent","label":"independents only","rows":76754},{"key":"chain","label":"part of a chain","rows":11679}],"columns":["name","address","city","sector","category","phone","website","county","brand","chain","independent","postcode","confidence","build_yr","district","street","site_parcel_id","overture_id","lat","lon"]},{"id":"flood","title":"Which properties FEMA puts in the floodplain","subject":"28,354 parcels · Hennepin + Ramsey + Dakota + Anoka + Washington + Scott + Carver · 21,214 in a Special Flood Hazard Area · 11 FEMA did not place","rows":28354,"scopes":[{"key":"all","label":"every parcel FEMA flagged","rows":28354},{"key":"sfha","label":"Special Flood Hazard Area","rows":21214},{"key":"shaded","label":"the 0.2% band only","rows":7129}],"columns":["address","city","county","flood_zone","flood_zone_name","in_sfha","assessed","base_flood_elev","build_yr","shaded_band","not_placed_by_fema","pin","lat","lon"]},{"id":"providers","title":"Healthcare providers with a federal NPI, statewide","subject":"Minnesota · statewide · 32,257 federal provider numbers held by 25,624 named organisations at 23,988 addresses, in 714 cities","rows":32257,"scopes":[{"key":"all","label":"every provider number","rows":32257},{"key":"home-and-community","label":"home care and community agencies","rows":6812},{"key":"clinical","label":"hospitals and clinics","rows":5378},{"key":"residential","label":"nursing, custodial and residential care","rows":2856}],"columns":["organisation","official","official_title","provider_type","taxonomy_code","address","city","trades_as","npi","zip","provider_group","official_middle","former_name","other_name","mailing_address","mailing_city","mailing_state","mail_outside_mn"]},{"id":"parcel-coverage","title":"What the statewide parcel layer can answer, county by county","subject":"87 Minnesota counties · 16 fields · 2,710,201 parcels compiled by MnGeo","rows":87,"scopes":[{"key":"all","label":"all 87 counties","rows":87},{"key":"published","label":"counties that publish parcels","rows":59},{"key":"value","label":"can answer what it is worth","rows":33},{"key":"sales","label":"knows what things sold for","rows":10},{"key":"empty","label":"consented, published almost nothing","rows":18}],"columns":["county","status","parcels","questions_answered","emv_total_pct","useclass1_pct","acres_poly_pct","sale_value_pct","empty_despite_opt_in","empty_fields","county_data_date","fips","emv_total_n","emv_land_pct","emv_land_n","emv_bldg_pct","emv_bldg_n","total_tax_pct","total_tax_n","useclass1_n","acres_poly_n","acres_deed_pct","acres_deed_n","year_built_pct","year_built_n","fin_sq_ft_pct","fin_sq_ft_n","num_units_pct","num_units_n","dwell_type_pct","dwell_type_n","owner_name_pct","owner_name_n","tax_name_pct","tax_name_n","homestead_pct","homestead_n","sale_date_pct","sale_date_n","sale_value_n"]}]}