population_2010blocks_2020nabes

2010 Minneapolis population by blocks, linked to their neighborhood. For details and ideas for queries, see this blog post, and for the column descriptions see this one for Washington, DC (they're the same).

Data license: CC BY-SA 4.0 · Data source: US Census & Minnesota Open Data Portal

12 rows where P005014 = 1 and P005016 = 2

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: GEOID10, FID, BDNAME, BDNUM, GEO_ID, NAME_x, P003001, P003002, P003003, P003004, P003005, P003007, P003008, P005001, P005002, P005003, P005004, P005005, P005006, P005008, P005009, P005010, P005011, P005012, P005013, P005017

Link rowid ▼ GEOID10 FID BDNAME BDNUM TEXT_NBR GEO_ID NAME_x P003001 P003002 P003003 P003004 P003005 P003006 P003007 P003008 P005001 P005002 P005003 P005004 P005005 P005006 P005007 P005008 P005009 P005010 P005011 P005012 P005013 P005014 P005015 P005016 P005017
543 543 270530017002003 9 Bottineau 14 14 1000000US270530017002003 Block 2003, Block Group 2, Census Tract 17, Hennepin County, Minnesota 41 19 7 2 6 0 2 5 41 32 19 4 2 5 0 0 2 9 0 3 0 1 0 2 3
1206 1206 270531048001011 19 Cedar Riverside 38 38 1000000US270531048001011 Block 1011, Block Group 1, Census Tract 1048, Hennepin County, Minnesota 496 336 18 1 124 0 2 15 496 484 329 18 1 123 0 0 13 12 7 0 0 1 0 2 2
1994 1994 270531056002007 28 Steven's Square - Loring Heights 32 32 1000000US270531056002007 Block 2007, Block Group 2, Census Tract 1056, Hennepin County, Minnesota 159 140 3 2 11 0 2 1 159 155 139 3 2 10 0 0 1 4 1 0 0 1 0 2 0
5135 5135 270531055002013 75 Lowry Hill 43 43 1000000US270531055002013 Block 2013, Block Group 2, Census Tract 1055, Hennepin County, Minnesota 208 173 19 1 3 0 3 9 208 196 168 18 1 2 0 1 6 12 5 1 0 1 0 2 3
5354 5354 270530038003002 79 Marcy Holmes 35 35 1000000US270530038003002 Block 3002, Block Group 3, Census Tract 38, Hennepin County, Minnesota 186 134 9 0 37 0 2 4 186 170 122 8 0 36 0 0 4 16 12 1 0 1 0 2 0
5789 5789 270530068001002 86 Whittier 51 51 1000000US270530068001002 Block 1002, Block Group 1, Census Tract 68, Hennepin County, Minnesota 207 168 21 3 3 0 2 10 207 197 163 21 2 2 0 0 9 10 5 0 1 1 0 2 1
6457 6457 270530017002003 9 Bottineau 14 14 1000000US270530017002003 Block 2003, Block Group 2, Census Tract 17, Hennepin County, Minnesota 41 19 7 2 6 0 2 5 41 32 19 4 2 5 0 0 2 9 0 3 0 1 0 2 3
7120 7120 270531048001011 19 Cedar Riverside 38 38 1000000US270531048001011 Block 1011, Block Group 1, Census Tract 1048, Hennepin County, Minnesota 496 336 18 1 124 0 2 15 496 484 329 18 1 123 0 0 13 12 7 0 0 1 0 2 2
7908 7908 270531056002007 28 Steven's Square - Loring Heights 32 32 1000000US270531056002007 Block 2007, Block Group 2, Census Tract 1056, Hennepin County, Minnesota 159 140 3 2 11 0 2 1 159 155 139 3 2 10 0 0 1 4 1 0 0 1 0 2 0
11049 11049 270531055002013 75 Lowry Hill 43 43 1000000US270531055002013 Block 2013, Block Group 2, Census Tract 1055, Hennepin County, Minnesota 208 173 19 1 3 0 3 9 208 196 168 18 1 2 0 1 6 12 5 1 0 1 0 2 3
11268 11268 270530038003002 79 Marcy Holmes 35 35 1000000US270530038003002 Block 3002, Block Group 3, Census Tract 38, Hennepin County, Minnesota 186 134 9 0 37 0 2 4 186 170 122 8 0 36 0 0 4 16 12 1 0 1 0 2 0
11703 11703 270530068001002 86 Whittier 51 51 1000000US270530068001002 Block 1002, Block Group 1, Census Tract 68, Hennepin County, Minnesota 207 168 21 3 3 0 2 10 207 197 163 21 2 2 0 0 9 10 5 0 1 1 0 2 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "population_2010blocks_2020nabes" (
"GEOID10" INTEGER,
  "FID" INTEGER,
  "BDNAME" TEXT,
  "BDNUM" INTEGER,
  "TEXT_NBR" INTEGER,
  "GEO_ID" TEXT,
  "NAME_x" TEXT,
  "P003001" INTEGER,
  "P003002" INTEGER,
  "P003003" INTEGER,
  "P003004" INTEGER,
  "P003005" INTEGER,
  "P003006" INTEGER,
  "P003007" INTEGER,
  "P003008" INTEGER,
  "P005001" INTEGER,
  "P005002" INTEGER,
  "P005003" INTEGER,
  "P005004" INTEGER,
  "P005005" INTEGER,
  "P005006" INTEGER,
  "P005007" INTEGER,
  "P005008" INTEGER,
  "P005009" INTEGER,
  "P005010" INTEGER,
  "P005011" INTEGER,
  "P005012" INTEGER,
  "P005013" INTEGER,
  "P005014" INTEGER,
  "P005015" INTEGER,
  "P005016" INTEGER,
  "P005017" INTEGER
);