Update arizona rule county checks to use name, not fips code

[leebrian]

Currently, the check for whether only a single county is suppressed uses county name+state to determine the number of counties in a state per census, but uses fips+state to determine the number of counties in a state for cases. This can lead to some mismatches.

They should both use county name. Please update and test.

covid_case_privacy_review/R/review_public_geo.R

Line 227 in 8fd7356

case_counties_per_state = aggregate(data=subset(data_with_census,county_fips_code != 'NA'), county_fips_code ~ res_state, function(x) length(unique(x)))

[josephotienoowino]

Hello can i get the dataset for educational purposes

[leebrian]

Both datasets are available on data.cdc.gov, COVID-19 Case Surveillance Public Use Data and
COVID-19 Case Surveillance Public Use Data with Geography

Also, @ErikTCrosby would you please take a look at this issue and see if it's still valid? It's super old so not sure if it still applies.

[josephotienoowino]

unable to download

…

On Thu, Mar 2, 2023, 7:14 PM Brian Lee ***@***.***> wrote: Both datasets are available on data.cdc.gov, COVID-19 Case Surveillance Public Use Data <https://data.cdc.gov/Case-Surveillance/COVID-19-Case-Surveillance-Public-Use-Data/vbim-akqf> and COVID-19 Case Surveillance Public Use Data with Geography <https://data.cdc.gov/Case-Surveillance/COVID-19-Case-Surveillance-Public-Use-Data-with-Ge/n8mc-b4w4> Also, @ErikTCrosby <https://github.com/ErikTCrosby> would you please take a look at this issue and see if it's still valid? It's super old so not sure if it still applies. — Reply to this email directly, view it on GitHub <#4 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AVK52IWW26O7JNRZMBALUW3W2DBQBANCNFSM5JRX2J2A> . You are receiving this because you commented.Message ID: ***@***.***>

[leebrian]

There's a support email address for those datasets. Please reach out to them and they can help you download the datasets. I just tested the export function and it is working, although those datasets are very large so it will take a long time to download. You can also use the API link to query subsets or download portions.

[josephotienoowino]

Thank you

…

On Thu, Mar 2, 2023, 8:15 PM Brian Lee ***@***.***> wrote: There's a support email address for those datasets. Please reach out to them and they can help you download the datasets. I just tested the export function and it is working, although those datasets are very large so it will take a long time to download. You can also use the API link to query subsets or download portions. — Reply to this email directly, view it on GitHub <#4 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AVK52ISE4B7IYO5NIZAWCCLW2DISBANCNFSM5JRX2J2A> . You are receiving this because you commented.Message ID: ***@***.***>