Skip to content

Which total positive column should be used? #13

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

Open
gadenbuie opened this issue Apr 15, 2020 · 1 comment
Open

Which total positive column should be used? #13

gadenbuie opened this issue Apr 15, 2020 · 1 comment

Comments

@gadenbuie
Copy link
Owner

gadenbuie commented Apr 15, 2020

I'm using t_positive from Florida_COVID19_Cases (FeatureServer), which is the only documented positive tests column, but as of 2020-04-14 19:00 the total in this column equals 21,629 whereas the dashboard reports 21,628 positive tests, which matches the undocumented t_positive_2 column.

T_positive — Testing: Total positive persons tested for all Florida and non-Florida resident types, including Florida residents tested outside of the state, and those tested at private facilities.

The discrepancy is due to Duval county, and I'm not sure why or what the difference means.

read_csv("https://github.com/gadenbuie/covid19-florida/raw/master/data/covid-19-florida_arcgis_summary.csv") %>% 
    filter(timestamp == "2020-04-15 07:00:37", t_positive != t_positive_2) %>% 
    select(county_1, t_positive, t_positive_2,  c_fl_res, c_not_fl_res, c_fl_res_out)
# # A tibble: 1 x 6
#   county_1 t_positive t_positive_2 c_fl_res c_not_fl_res c_fl_res_out
#   <chr>         <dbl>        <dbl>    <dbl>        <dbl>        <dbl>
# 1 Duval           719          718      704           14            0
@gadenbuie
Copy link
Owner Author

I should use

  • t_positive_2 which corresponds to T_positive and is

    Testing: Total positive persons tested for all Florida and non-Florida resident types, including Florida residents tested outside of the state, and those tested at private facilities

  • t_negative_2 which corresponds to T_negative and is

    Testing: Total negative persons tested for all Florida and non-Florida residents, including Florida residents tested outside of the state, andthose tested at private facilities.

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

1 participant