Skip to content

Instantly share code, notes, and snippets.

@wilkens

wilkens/cities_data.csv

Created January 14, 2015 17:02
Show Gist options
  • Save wilkens/9d6ea82c3f07fb7aed68 to your computer and use it in GitHub Desktop.
Save wilkens/9d6ea82c3f07fb7aed68 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
cities_data.csv
city year population literature
0 New York 1790 33100.0 10603
1 Washington 1790 2800.0 5079
2 Boston 1790 18300.0 4568
3 Philadelphia 1790 44100.0 2086
4 New Orleans 1790 5300.0 1590
5 Richmond 1790 3800.0 1172
6 Albany 1790 3500.0 1105
7 Buffalo 1790 0.0 927
8 Charleston 1790 16400.0 901
9 Baltimore 1790 13500.0 711
10 San Francisco 1790 0.0 691
11 Newport 1790 6700.0 637
12 Cincinnati 1790 0.0 417
13 St. Louis 1790 0.0 409
14 Vicksburg 1790 0.0 260
15 Chicago 1790 0.0 239
16 Portland 1790 2200.0 229
17 Sacramento 1790 0.0 229
18 Nantucket 1790 4600.0 215
19 Cleveland 1790 0.0 212
20 Salem 1790 13600.0 184
21 Pittsburgh 1790 1000.0 176
22 Detroit 1790 0.0 112
23 New York 1800 60500.0 10603
24 Washington 1800 11200.0 5079
25 Boston 1800 24900.0 4568
26 Philadelphia 1800 61600.0 2086
27 New Orleans 1800 8100.0 1590
28 Richmond 1800 5700.0 1172
29 Albany 1800 5300.0 1105
30 Buffalo 1800 0.0 927
31 Charleston 1800 18800.0 901
32 Baltimore 1800 26500.0 711
33 San Francisco 1800 0.0 691
34 Newport 1800 6700.0 637
35 Cincinnati 1800 900.0 417
36 St. Louis 1800 0.0 409
37 Vicksburg 1800 0.0 260
38 Chicago 1800 0.0 239
39 Portland 1800 3700.0 229
40 Sacramento 1800 0.0 229
41 Nantucket 1800 5600.0 215
42 Cleveland 1800 0.0 212
43 Salem 1800 14700.0 184
44 Pittsburgh 1800 1600.0 176
45 Detroit 1800 0.0 112
46 New York 1810 101000.0 10603
47 Washington 1810 20400.0 5079
48 Boston 1810 38700.0 4568
49 Philadelphia 1810 87300.0 2086
50 New Orleans 1810 17200.0 1590
51 Richmond 1810 9700.0 1172
52 Albany 1810 10800.0 1105
53 Buffalo 1810 1500.0 927
54 Charleston 1810 24700.0 901
55 Baltimore 1810 46600.0 711
56 San Francisco 1810 0.0 691
57 Newport 1810 7900.0 637
58 Cincinnati 1810 2500.0 417
59 St. Louis 1810 1600.0 409
60 Vicksburg 1810 1100.0 260
61 Chicago 1810 0.0 239
62 Portland 1810 7200.0 229
63 Sacramento 1810 0.0 229
64 Nantucket 1810 6800.0 215
65 Cleveland 1810 0.0 212
66 Salem 1810 23100.0 184
67 Pittsburgh 1810 4800.0 176
68 Detroit 1810 1600.0 112
69 New York 1820 131000.0 10603
70 Washington 1820 28800.0 5079
71 Boston 1820 54000.0 4568
72 Philadelphia 1820 109000.0 2086
73 New Orleans 1820 27200.0 1590
74 Richmond 1820 12100.0 1172
75 Albany 1820 17900.0 1105
76 Buffalo 1820 2100.0 927
77 Charleston 1820 24800.0 901
78 Baltimore 1820 62700.0 711
79 San Francisco 1820 0.0 691
80 Newport 1820 7300.0 637
81 Cincinnati 1820 9600.0 417
82 St. Louis 1820 3000.0 409
83 Vicksburg 1820 2700.0 260
84 Chicago 1820 0.0 239
85 Portland 1820 8600.0 229
86 Sacramento 1820 0.0 229
87 Nantucket 1820 7300.0 215
88 Cleveland 1820 600.0 212
89 Salem 1820 22600.0 184
90 Pittsburgh 1820 7300.0 176
91 Detroit 1820 1400.0 112
92 New York 1830 215000.0 10603
93 Washington 1830 35500.0 5079
94 Boston 1830 85600.0 4568
95 Philadelphia 1830 161000.0 2086
96 New Orleans 1830 46100.0 1590
97 Richmond 1830 16100.000000000002 1172
98 Albany 1830 35800.0 1105
99 Buffalo 1830 8700.0 927
100 Charleston 1830 30300.0 901
101 Baltimore 1830 80600.0 711
102 San Francisco 1830 0.0 691
103 Newport 1830 8000.0 637
104 Cincinnati 1830 24800.0 417
105 St. Louis 1830 5000.0 409
106 Vicksburg 1830 7900.0 260
107 Chicago 1830 0.0 239
108 Sacramento 1830 0.0 229
109 Portland 1830 12600.0 229
110 Nantucket 1830 7200.0 215
111 Cleveland 1830 1100.0 212
112 Salem 1830 27300.0 184
113 Pittsburgh 1830 15400.0 176
114 Detroit 1830 2200.0 112
115 New York 1840 374000.0 10603
116 Washington 1840 50200.0 5079
117 Boston 1840 183000.0 4568
118 Philadelphia 1840 259000.0 2086
119 New Orleans 1840 105000.0 1590
120 Richmond 1840 20200.0 1172
121 Albany 1840 72000.0 1105
122 Buffalo 1840 29300.0 927
123 Charleston 1840 42600.0 901
124 Baltimore 1840 110000.0 711
125 San Francisco 1840 0.0 691
126 Newport 1840 8300.0 637
127 Cincinnati 1840 54800.0 417
128 St. Louis 1840 28400.0 409
129 Vicksburg 1840 15800.0 260
130 Chicago 1840 4500.0 239
131 Sacramento 1840 0.0 229
132 Portland 1840 28600.0 229
133 Nantucket 1840 9000.0 215
134 Cleveland 1840 6100.0 212
135 Salem 1840 20700.0 184
136 Pittsburgh 1840 43700.0 176
137 Detroit 1840 21200.0 112
138 New York 1850 650000.0 10603
139 Washington 1850 67000.0 5079
140 Boston 1850 308000.0 4568
141 Philadelphia 1850 405000.0 2086
142 New Orleans 1850 123000.0 1590
143 Richmond 1850 27600.0 1172
144 Albany 1850 107000.0 1105
145 Buffalo 1850 80000.0 927
146 Charleston 1850 50000.0 901
147 Baltimore 1850 179000.0 711
148 San Francisco 1850 34800.0 691
149 Newport 1850 9600.0 637
150 Cincinnati 1850 133000.0 417
151 St. Louis 1850 95000.0 409
152 Vicksburg 1850 18100.0 260
153 Chicago 1850 40000.0 239
154 Sacramento 1850 6800.0 229
155 Portland 1850 36000.0 229
156 Nantucket 1850 8500.0 215
157 Cleveland 1850 17000.0 212
158 Salem 1850 26400.0 184
159 Pittsburgh 1850 86000.0 176
160 Detroit 1850 38000.0 112
161 New York 1860 1143000.0 10603
162 Washington 1860 80000.0 5079
163 Boston 1860 374000.0 4568
164 Philadelphia 1860 608000.0 2086
165 New Orleans 1860 172000.0 1590
166 Richmond 1860 37900.0 1172
167 Albany 1860 116000.0 1105
168 Buffalo 1860 90000.0 927
169 Charleston 1860 40500.0 901
170 Baltimore 1860 221000.0 711
171 San Francisco 1860 57000.0 691
172 Newport 1860 10500.0 637
173 Cincinnati 1860 192000.0 417
174 St. Louis 1860 176000.0 409
175 Vicksburg 1860 20700.0 260
176 Chicago 1860 123000.0 239
177 Sacramento 1860 13800.0 229
178 Portland 1860 51000.0 229
179 Nantucket 1860 6100.0 215
180 Cleveland 1860 49000.0 212
181 Salem 1860 29900.0 184
182 Pittsburgh 1860 93000.0 176
183 Detroit 1860 59000.0 112
184 New York 1870 1687000.0 10603
185 Washington 1870 123000.0 5079
186 Boston 1870 501000.0 4568
187 Philadelphia 1870 747000.0 2086
188 New Orleans 1870 196000.0 1590
189 Richmond 1870 51000.0 1172
190 Albany 1870 157000.0 1105
191 Buffalo 1870 133000.0 927
192 Charleston 1870 49000.0 901
193 Baltimore 1870 283000.0 711
194 San Francisco 1870 151000.0 691
195 Newport 1870 15100.0 637
196 Cincinnati 1870 257000.0 417
197 St. Louis 1870 345000.0 409
198 Vicksburg 1870 26800.0 260
199 Chicago 1870 324000.0 239
200 Sacramento 1870 16300.0 229
201 Portland 1870 56700.0 229
202 Nantucket 1870 4100.0 215
203 Cleveland 1870 101000.0 212
204 Salem 1870 31800.0 184
205 Pittsburgh 1870 170000.0 176
206 Detroit 1870 101000.0 112
207 New York 1880 2234000.0 10603
208 Washington 1880 164000.0 5079
209 Boston 1880 658000.0 4568
210 Philadelphia 1880 949000.0 2086
211 New Orleans 1880 219000.0 1590
212 Richmond 1880 63600.0 1172
213 Albany 1880 178000.0 1105
214 Buffalo 1880 171000.0 927
215 Charleston 1880 50000.0 901
216 Baltimore 1880 353000.0 711
217 San Francisco 1880 236000.0 691
218 Newport 1880 20400.0 637
219 Cincinnati 1880 307000.0 417
220 St. Louis 1880 386000.0 409
221 Vicksburg 1880 31200.0 260
222 Chicago 1880 543000.0 239
223 Portland 1880 60100.0 229
224 Sacramento 1880 21400.0 229
225 Nantucket 1880 3700.0 215
226 Cleveland 1880 169000.0 212
227 Salem 1880 35000.0 184
228 Pittsburgh 1880 265000.0 176
229 Detroit 1880 147000.0 112
230 New York 1890 2977000.0 10603
231 Washington 1890 253000.0 5079
232 Boston 1890 818000.0 4568
233 Philadelphia 1890 1180000.0 2086
234 New Orleans 1890 245000.0 1590
235 Richmond 1890 81400.0 1172
236 Albany 1890 189000.0 1105
237 Buffalo 1890 272000.0 927
238 Charleston 1890 55000.0 901
239 Baltimore 1890 453000.0 711
240 San Francisco 1890 302000.0 691
241 Newport 1890 21000.0 637
242 Cincinnati 1890 344000.0 417
243 St. Louis 1890 490000.0 409
244 Vicksburg 1890 33200.0 260
245 Chicago 1890 1141000.0 239
246 Portland 1890 63700.0 229
247 Sacramento 1890 26400.0 229
248 Nantucket 1890 3300.0 215
249 Cleveland 1890 274000.0 212
250 Salem 1890 39000.0 184
251 Pittsburgh 1890 396000.0 176
252 Detroit 1890 237000.0 112
253 New York 1900 4266000.0 10603
254 Washington 1900 302000.0 5079
255 Boston 1900 1009000.0 4568
256 Philadelphia 1900 1454000.0 2086
257 New Orleans 1900 291000.0 1590
258 Richmond 1900 85100.0 1172
259 Albany 1900 188000.0 1105
260 Buffalo 1900 373000.0 927
261 Charleston 1900 55800.0 901
262 Baltimore 1900 532000.0 711
263 San Francisco 1900 375000.0 691
264 Newport 1900 22400.0 637
265 Cincinnati 1900 379000.0 417
266 St. Louis 1900 626000.0 409
267 Vicksburg 1900 40900.0 260
268 Chicago 1900 1759000.0 239
269 Portland 1900 75400.0 229
270 Sacramento 1900 29300.0 229
271 Nantucket 1900 3000.0 215
272 Cleveland 1900 396000.0 212
273 Salem 1900 43500.0 184
274 Pittsburgh 1900 532000.0 176
275 Detroit 1900 321000.0 112
276 New York 1910 6021000.0 10603
277 Washington 1910 357000.0 5079
278 Boston 1910 1213000.0 4568
279 Philadelphia 1910 1746000.0 2086
280 New Orleans 1910 344000.0 1590
281 Richmond 1910 128000.0 1172
282 Albany 1910 283000.0 1105
283 Buffalo 1910 420000.0 927
284 Charleston 1910 58800.0 901
285 Baltimore 1910 589000.0 711
286 San Francisco 1910 604000.0 691
287 Newport 1910 27100.0 637
288 Cincinnati 1910 425000.0 417
289 St. Louis 1910 760000.0 409
290 Vicksburg 1910 37500.0 260
291 Chicago 1910 2283000.0 239
292 Portland 1910 85300.0 229
293 Sacramento 1910 44700.0 229
294 Nantucket 1910 3000.0 215
295 Cleveland 1910 580000.0 212
296 Salem 1910 51000.0 184
297 Pittsburgh 1910 655000.0 176
298 Detroit 1910 503000.0 112
299 New York 1920 7041000.0 10603
300 Washington 1920 467000.0 5079
301 Boston 1920 1366000.0 4568
302 Philadelphia 1920 2072000.0 2086
303 New Orleans 1920 393000.0 1590
304 Richmond 1920 172000.0 1172
305 Albany 1920 317000.0 1105
306 Buffalo 1920 539000.0 927
307 Charleston 1920 68000.0 901
308 Baltimore 1920 753000.0 711
309 San Francisco 1920 771000.0 691
310 Newport 1920 30300.0 637
311 Cincinnati 1920 470000.0 417
312 St. Louis 1920 859000.0 409
313 Vicksburg 1920 33400.0 260
314 Chicago 1920 2859000.0 239
315 Portland 1920 96800.0 229
316 Sacramento 1920 65900.0 229
317 Nantucket 1920 2800.0 215
318 Cleveland 1920 834000.0 212
319 Salem 1920 49900.0 184
320 Pittsburgh 1920 775000.0 176
321 Detroit 1920 1071000.0 112
322 New York 1930 8667000.0 10603
323 Washington 1930 527000.0 5079
324 Boston 1930 1479000.0 4568
325 Philadelphia 1930 2264000.0 2086
326 New Orleans 1930 469000.0 1590
327 Richmond 1930 183000.0 1172
328 Albany 1930 356000.0 1105
329 Buffalo 1930 620000.0 927
330 Charleston 1930 62300.0 901
331 Baltimore 1930 836000.0 711
332 San Francisco 1930 996000.0 691
333 Newport 1930 27600.0 637
334 Cincinnati 1930 580000.0 417
335 St. Louis 1930 950000.0 409
336 Vicksburg 1930 35800.0 260
337 Chicago 1930 3718000.0 239
338 Portland 1930 103000.0 229
339 Sacramento 1930 93800.0 229
340 Nantucket 1930 3700.0 215
341 Cleveland 1930 976000.0 212
342 Salem 1930 52000.0 184
343 Pittsburgh 1930 960000.0 176
344 Detroit 1930 1721000.0 112
345 New York 1940 10135000.0 10603
346 Washington 1940 800000.0 5079
347 Boston 1940 1746000.0 4568
348 Philadelphia 1940 2538000.0 2086
349 New Orleans 1940 557000.0 1590
350 Richmond 1940 193000.0 1172
351 Albany 1940 364000.0 1105
352 Buffalo 1940 708000.0 927
353 Charleston 1940 71300.0 901
354 Baltimore 1940 992000.0 711
355 San Francisco 1940 1156000.0 691
356 Newport 1940 30500.0 637
357 Cincinnati 1940 559000.0 417
358 St. Louis 1940 1102000.0 409
359 Vicksburg 1940 39600.0 260
360 Chicago 1940 4210000.0 239
361 Portland 1940 110000.0 229
362 Sacramento 1940 106000.0 229
363 Nantucket 1940 3400.0 215
364 Cleveland 1940 1079000.0 212
365 Salem 1940 52100.0 184
366 Pittsburgh 1940 1134000.0 176
367 Detroit 1940 2041000.0 112
368 New York 1950 12604000.0 10603
369 Washington 1950 1287000.0 5079
370 Boston 1950 2301000.0 4568
371 Philadelphia 1950 3297000.0 2086
372 New Orleans 1950 660000.0 1590
373 Richmond 1950 230000.0 1172
374 Albany 1950 377000.0 1105
375 Buffalo 1950 895000.0 927
376 Charleston 1950 70200.0 901
377 Baltimore 1950 1162000.0 711
378 San Francisco 1950 2131000.0 691
379 Newport 1950 37600.0 637
380 Cincinnati 1950 813000.0 417
381 St. Louis 1950 1541000.0 409
382 Vicksburg 1950 39600.0 260
383 Chicago 1950 5208000.0 239
384 Portland 1950 123000.0 229
385 Sacramento 1950 138000.0 229
386 Nantucket 1950 3500.0 215
387 Cleveland 1950 1425000.0 212
388 Salem 1950 55600.0 184
389 Pittsburgh 1950 1400000.0 176
390 Detroit 1950 2884000.0 112
391 New York 1960 14437000.0 10603
392 Washington 1960 1905000.0 5079
393 Boston 1960 2501000.0 4568
394 Philadelphia 1960 3989000.0 2086
395 New Orleans 1960 628000.0 1590
396 Richmond 1960 220000.0 1172
397 Albany 1960 362000.0 1105
398 Buffalo 1960 1054000.0 927
399 Charleston 1960 60300.0 901
400 Baltimore 1960 1419000.0 711
401 San Francisco 1960 2607000.0 691
402 Newport 1960 47000.0 637
403 Cincinnati 1960 994000.0 417
404 St. Louis 1960 1864000.0 409
405 Vicksburg 1960 42200.0 260
406 Chicago 1960 6377000.0 239
407 Portland 1960 128000.0 229
408 Sacramento 1960 192000.0 229
409 Nantucket 1960 3600.0 215
410 Cleveland 1960 1785000.0 212
411 Salem 1960 57700.0 184
412 Pittsburgh 1960 2105000.0 176
413 Detroit 1960 3750000.0 112
414 New York 1970 16193000.0 10603
415 Washington 1970 2671000.0 5079
416 Boston 1970 2703000.0 4568
417 Philadelphia 1970 4419000.0 2086
418 New Orleans 1970 593000.0 1590
419 Richmond 1970 250000.0 1172
420 Albany 1970 324000.0 1105
421 Buffalo 1970 1087000.0 927
422 Charleston 1970 66900.0 901
423 Baltimore 1970 1580000.0 711
424 San Francisco 1970 3049000.0 691
425 Newport 1970 34600.0 637
426 Cincinnati 1970 1111000.0 417
427 St. Louis 1970 2123000.0 409
428 Vicksburg 1970 45000.0 260
429 Chicago 1970 7164000.0 239
430 Portland 1970 129000.0 229
431 Sacramento 1970 257000.0 229
432 Nantucket 1970 3800.0 215
433 Cleveland 1970 1960000.0 212
434 Salem 1970 61900.0 184
435 Pittsburgh 1970 2124000.0 176
436 Detroit 1970 4085000.0 112
437 New York 1980 16500000.0 10603
438 Washington 1980 2912000.0 5079
439 Boston 1980 3064000.0 4568
440 Philadelphia 1980 4830000.0 2086
441 New Orleans 1980 558000.0 1590
442 Richmond 1980 219000.0 1172
443 Albany 1980 284000.0 1105
444 Buffalo 1980 1002000.0 927
445 Charleston 1980 69800.0 901
446 Baltimore 1980 1755000.0 711
447 San Francisco 1980 4185000.0 691
448 Newport 1980 29300.0 637
449 Cincinnati 1980 1123000.0 417
450 St. Louis 1980 1849000.0 409
451 Vicksburg 1980 51600.0 260
452 Chicago 1980 7325000.0 239
453 Portland 1980 139000.0 229
454 Sacramento 1980 276000.0 229
455 Nantucket 1980 5100.0 215
456 Cleveland 1980 1752000.0 212
457 Salem 1980 58300.0 184
458 Pittsburgh 1980 1810000.0 176
459 Detroit 1980 4214000.0 112
460 New York 1990 16754000.0 10603
461 Washington 1990 3363000.0 5079
462 Boston 1990 3355000.0 4568
463 Philadelphia 1990 4970000.0 2086
464 New Orleans 1990 497000.0 1590
465 Richmond 1990 203000.0 1172
466 Albany 1990 283000.0 1105
467 Buffalo 1990 954000.0 927
468 Charleston 1990 80400.0 901
469 Baltimore 1990 1890000.0 711
470 San Francisco 1990 5386000.0 691
471 Newport 1990 28200.0 637
472 Cincinnati 1990 1212000.0 417
473 St. Louis 1990 1947000.0 409
474 Vicksburg 1990 47900.0 260
475 Chicago 1990 7373000.0 239
476 Portland 1990 154000.0 229
477 Sacramento 1990 369000.0 229
478 Nantucket 1990 6000.0 215
479 Cleveland 1990 1677000.0 212
480 Salem 1990 58100.0 184
481 Pittsburgh 1990 1744000.0 176
482 Detroit 1990 3698000.0 112
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment