ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

6,232 rows where county = "Butler" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 8

fips 8

county 1

  • Butler · 6,232 ✖
Link rowid date ▲ county state fips cases deaths
2499581 2499581 2022-05-13 Butler Alabama 1013 5068 129
2500384 2500384 2022-05-13 Butler Iowa 19023 3252 53
2500480 2500480 2022-05-13 Butler Kansas 20015 19104 192
2500594 2500594 2022-05-13 Butler Kentucky 21031 3874 54
2501087 2501087 2022-05-13 Butler Missouri 29023 10206 169
2501260 2501260 2022-05-13 Butler Nebraska 31023 1923 18
2501652 2501652 2022-05-13 Butler Ohio 39017 93927 1157
2501856 2501856 2022-05-13 Butler Pennsylvania 42019 45173 743
2496323 2496323 2022-05-12 Butler Alabama 1013 5068 129
2497126 2497126 2022-05-12 Butler Iowa 19023 3252 53
2497222 2497222 2022-05-12 Butler Kansas 20015 19057 192
2497336 2497336 2022-05-12 Butler Kentucky 21031 3874 54
2497829 2497829 2022-05-12 Butler Missouri 29023 10177 169
2498002 2498002 2022-05-12 Butler Nebraska 31023 1921 18
2498394 2498394 2022-05-12 Butler Ohio 39017 93927 1157
2498598 2498598 2022-05-12 Butler Pennsylvania 42019 45173 743
2493065 2493065 2022-05-11 Butler Alabama 1013 5068 129
2493868 2493868 2022-05-11 Butler Iowa 19023 3252 53
2493964 2493964 2022-05-11 Butler Kansas 20015 19057 192
2494078 2494078 2022-05-11 Butler Kentucky 21031 3874 54
2494571 2494571 2022-05-11 Butler Missouri 29023 10177 169
2494744 2494744 2022-05-11 Butler Nebraska 31023 1921 18
2495136 2495136 2022-05-11 Butler Ohio 39017 93585 1153
2495340 2495340 2022-05-11 Butler Pennsylvania 42019 45173 743
2489807 2489807 2022-05-10 Butler Alabama 1013 5068 129
2490610 2490610 2022-05-10 Butler Iowa 19023 3243 53
2490706 2490706 2022-05-10 Butler Kansas 20015 19057 192
2490820 2490820 2022-05-10 Butler Kentucky 21031 3874 54
2491313 2491313 2022-05-10 Butler Missouri 29023 10177 169
2491486 2491486 2022-05-10 Butler Nebraska 31023 1933 18
2491878 2491878 2022-05-10 Butler Ohio 39017 93585 1153
2492082 2492082 2022-05-10 Butler Pennsylvania 42019 44918 742
2486550 2486550 2022-05-09 Butler Alabama 1013 5068 129
2487353 2487353 2022-05-09 Butler Iowa 19023 3243 53
2487449 2487449 2022-05-09 Butler Kansas 20015 19057 189
2487563 2487563 2022-05-09 Butler Kentucky 21031 3874 54
2488055 2488055 2022-05-09 Butler Missouri 29023 10177 169
2488228 2488228 2022-05-09 Butler Nebraska 31023 1933 18
2488620 2488620 2022-05-09 Butler Ohio 39017 93585 1153
2488824 2488824 2022-05-09 Butler Pennsylvania 42019 44918 742
2483292 2483292 2022-05-08 Butler Alabama 1013 5067 129
2484095 2484095 2022-05-08 Butler Iowa 19023 3243 53
2484191 2484191 2022-05-08 Butler Kansas 20015 19057 189
2484305 2484305 2022-05-08 Butler Kentucky 21031 3870 54
2484798 2484798 2022-05-08 Butler Missouri 29023 10177 169
2484971 2484971 2022-05-08 Butler Nebraska 31023 1931 18
2485363 2485363 2022-05-08 Butler Ohio 39017 93585 1153
2485567 2485567 2022-05-08 Butler Pennsylvania 42019 44918 742
2480034 2480034 2022-05-07 Butler Alabama 1013 5067 129
2480837 2480837 2022-05-07 Butler Iowa 19023 3243 53
2480933 2480933 2022-05-07 Butler Kansas 20015 19057 189
2481047 2481047 2022-05-07 Butler Kentucky 21031 3870 54
2481540 2481540 2022-05-07 Butler Missouri 29023 10177 169
2481713 2481713 2022-05-07 Butler Nebraska 31023 1931 18
2482105 2482105 2022-05-07 Butler Ohio 39017 93585 1153
2482309 2482309 2022-05-07 Butler Pennsylvania 42019 44918 742
2476776 2476776 2022-05-06 Butler Alabama 1013 5067 129
2477579 2477579 2022-05-06 Butler Iowa 19023 3243 53
2477675 2477675 2022-05-06 Butler Kansas 20015 19057 189
2477789 2477789 2022-05-06 Butler Kentucky 21031 3870 54
2478282 2478282 2022-05-06 Butler Missouri 29023 10177 169
2478455 2478455 2022-05-06 Butler Nebraska 31023 1931 18
2478847 2478847 2022-05-06 Butler Ohio 39017 93585 1153
2479051 2479051 2022-05-06 Butler Pennsylvania 42019 44918 742
2473518 2473518 2022-05-05 Butler Alabama 1013 5067 129
2474321 2474321 2022-05-05 Butler Iowa 19023 3243 53
2474417 2474417 2022-05-05 Butler Kansas 20015 19033 189
2474531 2474531 2022-05-05 Butler Kentucky 21031 3870 54
2475024 2475024 2022-05-05 Butler Missouri 29023 10153 169
2475197 2475197 2022-05-05 Butler Nebraska 31023 1931 18
2475589 2475589 2022-05-05 Butler Ohio 39017 93585 1153
2475793 2475793 2022-05-05 Butler Pennsylvania 42019 44918 742
2470261 2470261 2022-05-04 Butler Alabama 1013 5067 129
2471064 2471064 2022-05-04 Butler Iowa 19023 3243 53
2471160 2471160 2022-05-04 Butler Kansas 20015 19033 189
2471274 2471274 2022-05-04 Butler Kentucky 21031 3870 54
2471767 2471767 2022-05-04 Butler Missouri 29023 10111 166
2471940 2471940 2022-05-04 Butler Nebraska 31023 1932 18
2472332 2472332 2022-05-04 Butler Ohio 39017 93267 1152
2472536 2472536 2022-05-04 Butler Pennsylvania 42019 44918 742
2467005 2467005 2022-05-03 Butler Alabama 1013 5066 129
2467808 2467808 2022-05-03 Butler Iowa 19023 3231 53
2467904 2467904 2022-05-03 Butler Kansas 20015 19033 189
2468018 2468018 2022-05-03 Butler Kentucky 21031 3870 54
2468511 2468511 2022-05-03 Butler Missouri 29023 10111 166
2468684 2468684 2022-05-03 Butler Nebraska 31023 1932 18
2469076 2469076 2022-05-03 Butler Ohio 39017 93267 1152
2469280 2469280 2022-05-03 Butler Pennsylvania 42019 44896 742
2463750 2463750 2022-05-02 Butler Alabama 1013 5066 129
2464553 2464553 2022-05-02 Butler Iowa 19023 3231 53
2464649 2464649 2022-05-02 Butler Kansas 20015 19033 189
2464763 2464763 2022-05-02 Butler Kentucky 21031 3870 54
2465255 2465255 2022-05-02 Butler Missouri 29023 10111 166
2465428 2465428 2022-05-02 Butler Nebraska 31023 1934 18
2465820 2465820 2022-05-02 Butler Ohio 39017 93267 1152
2466024 2466024 2022-05-02 Butler Pennsylvania 42019 44871 741
2460494 2460494 2022-05-01 Butler Alabama 1013 5064 129
2461297 2461297 2022-05-01 Butler Iowa 19023 3231 53
2461393 2461393 2022-05-01 Butler Kansas 20015 19033 189
2461507 2461507 2022-05-01 Butler Kentucky 21031 3870 54

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
CREATE INDEX [idx_ny_times_us_counties_state]
    ON [ny_times_us_counties] ([state]);
CREATE INDEX [idx_ny_times_us_counties_county]
    ON [ny_times_us_counties] ([county]);
CREATE INDEX [idx_ny_times_us_counties_fips]
    ON [ny_times_us_counties] ([fips]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date] desc);