create table of population for US counties

[paulhtremblay]

Create a table with the population and fips

[Joylizzie]

I can only find the actual population as of 2010 from: https://data.ers.usda.gov/reports.aspx?ID=17827.

I downloaded this table which has fips code, rual,urban classification,state, county, actual population. The total US population in 2010 - 312,471,327 is less than estimate population - 328,239,523 in 2019 - you can find the data here: https://www.census.gov/data/datasets/time-series/demo/popest/2010s-counties-total.html

I will use the actual population in 2010 - although is not the latest actual population.

The table 'rualurbancodes2013' is created under 'covid19' in Bigquery.

I will use the rucc code with number 1, 2, 3 as urban area, 4-9 as rural area in the comparison in future analysis.

[paulhtremblay]

Can you please change the table name to rural_urban_codes_2013 Create a branch (git checkout -b make_pop) Include these notes in the README commit the branch and then present it to me for code review Thanks!

[Joylizzie]

I renamed the file as you asked - rural_urban_codes_2013. Not sure how to do the rest of your asking yet. Going to work them out. I did some query with BIG help getting rural and urban daily cases/deaths/actual population in 2010.

[paulhtremblay]

From your shell: git checkout -b population open up Readme and document your changes git commit -am "what you did" git push

[Joylizzie]

I don't know how to do what you said. After doing something You probably can see there is a pull request and a pushed Population branch. I currently get a git book to read to know more information.

some commands I did under my "(covid19) lizhi@Panda:~/projects/covid19$ " Terminal are:

(covid19) lizhi@Panda:~/projects/covid19$ git checkout -b population Readme(Command readme not found) ls git commit -am git commit -am "add rural_urban_codes_2013.csv us_states.csv" [population 00dfd87] add rural_urban_codes_2013.csv us_states.csv 4 files changed, 3273 insertions(+) create mode 100644 rural_urban_codes_2013.csv create mode 100644 us_states.csv

git push fatal: The current branch population has no upstream branch. To push the current branch and set the remote as upstream, use

git push --set-upstream origin population

(covid19) lizhi@Panda:~/projects/covid19$ git branch -a master

• population remotes/origin/HEAD -> origin/master remotes/origin/basic-style remotes/origin/development remotes/origin/fix-html remotes/origin/master (covid19) lizhi@Panda:~/projects/covid19$ git branch -r origin/HEAD -> origin/master origin/basic-style origin/development origin/fix-html origin/master (covid19) lizhi@Panda:~/projects/covid19$ git push population fatal: 'population' does not appear to be a git repository fatal: Could not read from remote repository.

Please make sure you have the correct access rights and the repository exists. (covid19) lizhi@Panda:~/projects/covid19$ git push origin population Username for 'https://github.com': Joylizzie Password for 'https://Joylizzie@github.com': Counting objects: 63, done. Delta compression using up to 4 threads. Compressing objects: 100% (49/49), done. Writing objects: 100% (63/63), 153.83 KiB | 2.40 MiB/s, done. Total 63 (delta 30), reused 23 (delta 14) remote: Resolving deltas: 100% (30/30), completed with 7 local objects. remote: remote: Create a pull request for 'population' on GitHub by visiting: remote: https://github.com/paulhtremblay/covid19/pull/new/population remote: To https://github.com/paulhtremblay/covid19.git

• [new branch] population -> population

Not sure how to continue...