Created
March 28, 2020 23:19
-
-
Save underthecurve/f169602786b605324faf8bde084de783 to your computer and use it in GitHub Desktop.
baltimore vs dc population
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
library('tidyverse') | |
population <- read_csv('baltimorepop.csv') | |
ggplot(population, | |
aes(x = factor(year), | |
y = pop/1000, | |
color = city, | |
group = city)) + | |
geom_line(size = 2) + | |
scale_y_continuous(limits = c(200, 1000), | |
breaks = seq(200, 1000, 100)) + | |
labs(x = '', | |
y = '', | |
title = "DC's population overtook Baltimore's after 2010", | |
subtitle = "population in 000s", | |
caption = "*2019 figure is an estimate\nSource: U.S. Census Bureau") + | |
theme_minimal() + | |
theme(panel.grid.minor.x = element_blank(), | |
panel.grid.minor.y = element_blank(), | |
legend.title = element_blank()) |
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
year city pop source note | |
1900 baltimore 508957 https://www.census.gov/population/cencounts/md190090.txt April 1 decenncial census population | |
1910 baltimore 558485 https://www.census.gov/population/cencounts/md190090.txt April 1 decenncial census population | |
1920 baltimore 733826 https://www.census.gov/population/cencounts/md190090.txt April 1 decenncial census population | |
1930 baltimore 804874 https://www.census.gov/population/cencounts/md190090.txt April 1 decenncial census population | |
1940 baltimore 859100 https://www.census.gov/population/cencounts/md190090.txt April 1 decenncial census population | |
1950 baltimore 949708 https://www.census.gov/population/cencounts/md190090.txt April 1 decenncial census population | |
1960 baltimore 939024 https://www.census.gov/population/cencounts/md190090.txt April 1 decenncial census population | |
1970 baltimore 905787 https://www.census.gov/population/cencounts/md190090.txt April 1 decenncial census population | |
1980 baltimore 786741 https://www.census.gov/population/cencounts/md190090.txt April 1 decenncial census population | |
1990 baltimore 736014 https://planning.maryland.gov/MSDC/Documents/Census/Cen2010/pop_70-10/TotalPopulation.pdf April 1 decenncial census population | |
2000 baltimore 651154 https://planning.maryland.gov/MSDC/Documents/Census/Cen2010/pop_70-10/TotalPopulation.pdf April 1 decenncial census population | |
2010 baltimore 621074 https://www.census.gov/prod/cen2010/notes/cqr-MD-gu.pdf April 1 decenncial census population - REVISED as part of Census Count Question Resolution (CQR) Program | |
2019 baltimore 593490 https://www.census.gov/data/tables/time-series/demo/popest/2010s-counties-total.html July 1 population estimate | |
1900 dc 278718 https://www.census.gov/population/cencounts/dc190090.txt April 1 decenncial census population | |
1910 dc 331069 https://www.census.gov/population/cencounts/dc190090.txt April 1 decenncial census population | |
1920 dc 437571 https://www.census.gov/population/cencounts/dc190090.txt April 1 decenncial census population | |
1930 dc 486869 https://www.census.gov/population/cencounts/dc190090.txt April 1 decenncial census population | |
1940 dc 663091 https://www.census.gov/population/cencounts/dc190090.txt April 1 decenncial census population | |
1950 dc 802178 https://www.census.gov/population/cencounts/dc190090.txt April 1 decenncial census population | |
1960 dc 763956 https://www.census.gov/population/cencounts/dc190090.txt April 1 decenncial census population | |
1970 dc 756510 https://www.census.gov/population/cencounts/dc190090.txt April 1 decenncial census population | |
1980 dc 638333 https://www.census.gov/population/cencounts/dc190090.txt April 1 decenncial census population | |
1990 dc 606900 https://www.census.gov/population/cencounts/dc190090.txt April 1 decenncial census population | |
2000 dc 572059 https://www2.census.gov/census_2000/datasets/demographic_profile/District_of_Columbia/2kh11.pdf April 1 decenncial census population | |
2010 dc 601767 https://www.census.gov/prod/cen2010/notes/cqr-DC-gu.pdf April 1 decenncial census population - REVISED as part of Census Count Question Resolution (CQR) Program | |
2019 dc 705749 https://www.census.gov/data/tables/time-series/demo/popest/2010s-counties-total.html July 1 population estimate |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment