Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Excluded Counties #7

Closed
demonstrous opened this issue Mar 27, 2020 · 12 comments
Closed

Excluded Counties #7

demonstrous opened this issue Mar 27, 2020 · 12 comments

Comments

@demonstrous
Copy link

You may not be aware but the boroughs of New York City are also counties. Brooklyn=Kings Queens=Queens, Staten Island= Richmond, Bronx=Bronx, Manhattan=New York (obviously problematic naming). The population of Kings county is larger than at least 4 western states. Please consider adding them to your account. The daily data can be found here: https://www1.nyc.gov/assets/doh/downloads/pdf/imm/covid-19-daily-data-summary.pdf.

I live in Brooklyn and I have personally been tracking NY state county numbers here: https://docs.google.com/spreadsheets/d/159YnHmWplkEkhUZbC5oFT9cKiibLVMzaRm4LbhHN4Co/edit?usp=sharing

Thanks for your efforts,
Cooper Miller

@jicruz96
Copy link

Territories such as Puerto Rico don't subdivide into counties, but their municipal districts serve just as as well. Why not use these as proxies? This will allow better geographical specificity in the data for our fellow Americans in the territories.

@jessieb2001
Copy link

Vernon County, Missouri is missing from the data.

@jqnatividad
Copy link

+100 on breaking down NYC count into the 5 boroughs/counties, especially since NYC accounts for the bulk of covid-19 cases in the US, never mind NYT is the hometown paper.

@cgsantucci
Copy link

You may not be aware but the boroughs of New York City are also counties. Brooklyn=Kings Queens=Queens, Staten Island= Richmond, Bronx=Bronx, Manhattan=New York (obviously problematic naming). The population of Kings county is larger than at least 4 western states. Please consider adding them to your account. The daily data can be found here: https://www1.nyc.gov/assets/doh/downloads/pdf/imm/covid-19-daily-data-summary.pdf.

I live in Brooklyn and I have personally been tracking NY state county numbers here: ://docs.google.com/spreadsheets/d/159YnHmWplkEkhUZbC5oFT9cKiibLVMzaRm4LbhHN4Co/edit?usp=sharing

Thanks for your efforts,
Cooper Miller

Hello Cooper,
I have collected data by borough back to March 19 on cases and am looking for any previous boro disaggregated data to create density progression maps using GIS. By any chance do you have these numbers? Happy to share info I've collected if that is helpful.
Best, Christina

@dannguyen
Copy link

I agree that splitting NYC into its separate counties would make data analysis/viz slightly easier, but I assume they grouped the 5 counties together because that matches the actual reality of the NYC bureaucracy. AFAIK, the 5 counties do not have their own governments, and so there isn't as much real-world importance to treat Kings and Manhattan County as separate entities, in the way it does for, say, Nassau and Suffolk counties, which each have their own government and bureaucracy accountable for multiple cities

@demonstrous
Copy link
Author

You may not be aware but the boroughs of New York City are also counties. Brooklyn=Kings Queens=Queens, Staten Island= Richmond, Bronx=Bronx, Manhattan=New York (obviously problematic naming). The population of Kings county is larger than at least 4 western states. Please consider adding them to your account. The daily data can be found here: https://www1.nyc.gov/assets/doh/downloads/pdf/imm/covid-19-daily-data-summary.pdf.
I live in Brooklyn and I have personally been tracking NY state county numbers here: ://docs.google.com/spreadsheets/d/159YnHmWplkEkhUZbC5oFT9cKiibLVMzaRm4LbhHN4Co/edit?usp=sharing
Thanks for your efforts,
Cooper Miller

Hello Cooper,
I have collected data by borough back to March 19 on cases and am looking for any previous boro disaggregated data to create density progression maps using GIS. By any chance do you have these numbers? Happy to share info I've collected if that is helpful.
Best, Christina

I started to look at NYS counties on March 10th. I started looking into city data on the 19th, at some point the city gov site got a facelift and the data was missing for a day. I went to the wayback machine on archive.org to look at previous versions of the information, 18th was as far back as they were sharing data online.
March 18th:
Unknown | 1
Staten Island | 42
Bronx | 106
Brooklyn | 236
Queens | 248
Manhattan | 290
Total | 923

More city info is here:
https://www1.nyc.gov/site/doh/covid/covid-19-providers.page

I just found this neighborhood heat map(!) on that page:
https://www1.nyc.gov/assets/doh/downloads/pdf/imm/covid-19-data-map.pdf

It might be worth checking the wayback machine to see if the pdf was updated.
Let me know if this helps, Christina!
-Cooper

@demonstrous
Copy link
Author

(didn't mean to close this thread)

@demonstrous demonstrous reopened this Mar 28, 2020
@beighleyashley
Copy link

I believe, through the process of elimination, the “Unknown” county in California is Tuolumne. We had our first confirmed case on the 25th (patient was actually from Mono county, but had traveled to Tuolumne county the day prior to being admitted into the hospital, and supposedly had little/no contact with other residents, except one companion who is not showing signs, but being quarantined.) I may be wrong, but either way, Tuolumne is missing from the list.

@cgsantucci
Copy link

You may not be aware but the boroughs of New York City are also counties. Brooklyn=Kings Queens=Queens, Staten Island= Richmond, Bronx=Bronx, Manhattan=New York (obviously problematic naming). The population of Kings county is larger than at least 4 western states. Please consider adding them to your account. The daily data can be found here: https://www1.nyc.gov/assets/doh/downloads/pdf/imm/covid-19-daily-data-summary.pdf.
I live in Brooklyn and I have personally been tracking NY state county numbers here: ://docs.google.com/spreadsheets/d/159YnHmWplkEkhUZbC5oFT9cKiibLVMzaRm4LbhHN4Co/edit?usp=sharing
Thanks for your efforts,
Cooper Miller

Hello Cooper,
I have collected data by borough back to March 19 on cases and am looking for any previous boro disaggregated data to create density progression maps using GIS. By any chance do you have these numbers? Happy to share info I've collected if that is helpful.
Best, Christina

I started to look at NYS counties on March 10th. I started looking into city data on the 19th, at some point the city gov site got a facelift and the data was missing for a day. I went to the wayback machine on archive.org to look at previous versions of the information, 18th was as far back as they were sharing data online.
March 18th:
Unknown | 1
Staten Island | 42
Bronx | 106
Brooklyn | 236
Queens | 248
Manhattan | 290
Total | 923

More city info is here:
https://www1.nyc.gov/site/doh/covid/covid-19-providers.page

I just found this neighborhood heat map(!) on that page:
https://www1.nyc.gov/assets/doh/downloads/pdf/imm/covid-19-data-map.pdf

It might be worth checking the wayback machine to see if the pdf was updated.
Let me know if this helps, Christina!
-Cooper

Belated thank you for the 18th data!

@albertsun
Copy link
Collaborator

@demonstrous We are aware that the boroughs are counties. New York State reports data for New York City as a single entity. The city has been reporting data by borough separately, but we are still checking to see that the way it reports cases is consistent with how cases are reported across the rest of the dataset before integrating borough-level numbers into our dataset.

@jessieb2001 Vernon County, Missouri is not in the data because it has 0 cases and 0 deaths. All counties without any cases or deaths are excluded.

@jicruz96 Thanks for that suggestion. We haven't seen Puerto Rico report any data at the municipal district level yet though.

@m0L3hMu8Y
Copy link

Hi there. This is incredibly helpful, and a great service for all of us. If you find it valid, I believe there are 3 cases in Jasper County, Texas, which hasn’t yet made the list. Here’s the link to a local news source. https://www.kjas.com/news/local_news/article_e3e2af3a-7458-11ea-945c-8bdc1a134ef5.html

Thanks again!

@albertsun
Copy link
Collaborator

Hi @m0L3hMu8Y, thanks for passing that source along. For the time being we are going to be counting Jasper County, Texas with two cases as that is the number the state health department is still reporting. That will be in the next release of data for 4/2.

@tiffehr tiffehr closed this as completed Apr 4, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

10 participants