ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
6,232 rows where county = "Butler" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 8
county 1
- Butler · 6,232 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1730 | 1730 | 2020-03-13 | Butler | Kansas | 20015 | 1 | 0 |
2064 | 2064 | 2020-03-14 | Butler | Kansas | 20015 | 1 | 0 |
2187 | 2187 | 2020-03-14 | Butler | Ohio | 39017 | 4 | 0 |
2460 | 2460 | 2020-03-15 | Butler | Kansas | 20015 | 1 | 0 |
2601 | 2601 | 2020-03-15 | Butler | Ohio | 39017 | 6 | 0 |
2905 | 2905 | 2020-03-16 | Butler | Kansas | 20015 | 1 | 0 |
3063 | 3063 | 2020-03-16 | Butler | Ohio | 39017 | 6 | 0 |
3398 | 3398 | 2020-03-17 | Butler | Kansas | 20015 | 1 | 0 |
3586 | 3586 | 2020-03-17 | Butler | Ohio | 39017 | 6 | 0 |
3974 | 3974 | 2020-03-18 | Butler | Kansas | 20015 | 1 | 0 |
4197 | 4197 | 2020-03-18 | Butler | Ohio | 39017 | 8 | 0 |
4655 | 4655 | 2020-03-19 | Butler | Kansas | 20015 | 1 | 0 |
4928 | 4928 | 2020-03-19 | Butler | Ohio | 39017 | 8 | 0 |
5466 | 5466 | 2020-03-20 | Butler | Kansas | 20015 | 2 | 0 |
5790 | 5790 | 2020-03-20 | Butler | Ohio | 39017 | 12 | 0 |
6411 | 6411 | 2020-03-21 | Butler | Kansas | 20015 | 2 | 0 |
6787 | 6787 | 2020-03-21 | Butler | Ohio | 39017 | 16 | 0 |
6853 | 6853 | 2020-03-21 | Butler | Pennsylvania | 42019 | 1 | 0 |
7478 | 7478 | 2020-03-22 | Butler | Kansas | 20015 | 3 | 0 |
7893 | 7893 | 2020-03-22 | Butler | Ohio | 39017 | 17 | 0 |
7968 | 7968 | 2020-03-22 | Butler | Pennsylvania | 42019 | 1 | 0 |
8639 | 8639 | 2020-03-23 | Butler | Kansas | 20015 | 3 | 0 |
9096 | 9096 | 2020-03-23 | Butler | Ohio | 39017 | 17 | 0 |
9178 | 9178 | 2020-03-23 | Butler | Pennsylvania | 42019 | 5 | 0 |
9919 | 9919 | 2020-03-24 | Butler | Kansas | 20015 | 3 | 0 |
10408 | 10408 | 2020-03-24 | Butler | Ohio | 39017 | 18 | 0 |
10499 | 10499 | 2020-03-24 | Butler | Pennsylvania | 42019 | 6 | 0 |
10839 | 10839 | 2020-03-25 | Butler | Alabama | 1013 | 1 | 0 |
11316 | 11316 | 2020-03-25 | Butler | Kansas | 20015 | 3 | 0 |
11855 | 11855 | 2020-03-25 | Butler | Ohio | 39017 | 18 | 0 |
11961 | 11961 | 2020-03-25 | Butler | Pennsylvania | 42019 | 12 | 0 |
12372 | 12372 | 2020-03-26 | Butler | Alabama | 1013 | 1 | 0 |
12883 | 12883 | 2020-03-26 | Butler | Kansas | 20015 | 3 | 0 |
13462 | 13462 | 2020-03-26 | Butler | Ohio | 39017 | 21 | 0 |
13580 | 13580 | 2020-03-26 | Butler | Pennsylvania | 42019 | 19 | 1 |
14030 | 14030 | 2020-03-27 | Butler | Alabama | 1013 | 1 | 0 |
14538 | 14538 | 2020-03-27 | Butler | Iowa | 19023 | 1 | 0 |
14579 | 14579 | 2020-03-27 | Butler | Kansas | 20015 | 3 | 0 |
15199 | 15199 | 2020-03-27 | Butler | Ohio | 39017 | 23 | 0 |
15326 | 15326 | 2020-03-27 | Butler | Pennsylvania | 42019 | 26 | 1 |
15808 | 15808 | 2020-03-28 | Butler | Alabama | 1013 | 1 | 0 |
16342 | 16342 | 2020-03-28 | Butler | Iowa | 19023 | 1 | 0 |
16386 | 16386 | 2020-03-28 | Butler | Kansas | 20015 | 3 | 0 |
16427 | 16427 | 2020-03-28 | Butler | Kentucky | 21031 | 1 | 0 |
17041 | 17041 | 2020-03-28 | Butler | Ohio | 39017 | 25 | 0 |
17173 | 17173 | 2020-03-28 | Butler | Pennsylvania | 42019 | 41 | 2 |
17691 | 17691 | 2020-03-29 | Butler | Alabama | 1013 | 1 | 0 |
18247 | 18247 | 2020-03-29 | Butler | Iowa | 19023 | 1 | 0 |
18291 | 18291 | 2020-03-29 | Butler | Kansas | 20015 | 3 | 0 |
18337 | 18337 | 2020-03-29 | Butler | Kentucky | 21031 | 1 | 0 |
18975 | 18975 | 2020-03-29 | Butler | Ohio | 39017 | 27 | 0 |
19111 | 19111 | 2020-03-29 | Butler | Pennsylvania | 42019 | 47 | 2 |
19661 | 19661 | 2020-03-30 | Butler | Alabama | 1013 | 1 | 0 |
20254 | 20254 | 2020-03-30 | Butler | Iowa | 19023 | 1 | 0 |
20304 | 20304 | 2020-03-30 | Butler | Kansas | 20015 | 3 | 0 |
20351 | 20351 | 2020-03-30 | Butler | Kentucky | 21031 | 1 | 0 |
21019 | 21019 | 2020-03-30 | Butler | Ohio | 39017 | 30 | 0 |
21161 | 21161 | 2020-03-30 | Butler | Pennsylvania | 42019 | 49 | 2 |
21733 | 21733 | 2020-03-31 | Butler | Alabama | 1013 | 1 | 0 |
22349 | 22349 | 2020-03-31 | Butler | Iowa | 19023 | 1 | 0 |
22401 | 22401 | 2020-03-31 | Butler | Kansas | 20015 | 3 | 0 |
22451 | 22451 | 2020-03-31 | Butler | Kentucky | 21031 | 1 | 0 |
23151 | 23151 | 2020-03-31 | Butler | Ohio | 39017 | 36 | 0 |
23297 | 23297 | 2020-03-31 | Butler | Pennsylvania | 42019 | 60 | 2 |
23886 | 23886 | 2020-04-01 | Butler | Alabama | 1013 | 1 | 0 |
24521 | 24521 | 2020-04-01 | Butler | Iowa | 19023 | 1 | 0 |
24576 | 24576 | 2020-04-01 | Butler | Kansas | 20015 | 5 | 0 |
24627 | 24627 | 2020-04-01 | Butler | Kentucky | 21031 | 1 | 0 |
25008 | 25008 | 2020-04-01 | Butler | Missouri | 29023 | 1 | 0 |
25346 | 25346 | 2020-04-01 | Butler | Ohio | 39017 | 41 | 0 |
25495 | 25495 | 2020-04-01 | Butler | Pennsylvania | 42019 | 64 | 2 |
26107 | 26107 | 2020-04-02 | Butler | Alabama | 1013 | 1 | 0 |
26762 | 26762 | 2020-04-02 | Butler | Iowa | 19023 | 1 | 0 |
26818 | 26818 | 2020-04-02 | Butler | Kansas | 20015 | 7 | 0 |
26872 | 26872 | 2020-04-02 | Butler | Kentucky | 21031 | 1 | 0 |
27263 | 27263 | 2020-04-02 | Butler | Missouri | 29023 | 1 | 0 |
27612 | 27612 | 2020-04-02 | Butler | Ohio | 39017 | 45 | 0 |
27767 | 27767 | 2020-04-02 | Butler | Pennsylvania | 42019 | 69 | 2 |
28403 | 28403 | 2020-04-03 | Butler | Alabama | 1013 | 1 | 0 |
29073 | 29073 | 2020-04-03 | Butler | Iowa | 19023 | 1 | 0 |
29132 | 29132 | 2020-04-03 | Butler | Kansas | 20015 | 7 | 0 |
29188 | 29188 | 2020-04-03 | Butler | Kentucky | 21031 | 1 | 0 |
29582 | 29582 | 2020-04-03 | Butler | Missouri | 29023 | 1 | 0 |
29941 | 29941 | 2020-04-03 | Butler | Ohio | 39017 | 49 | 1 |
30100 | 30100 | 2020-04-03 | Butler | Pennsylvania | 42019 | 75 | 2 |
30760 | 30760 | 2020-04-04 | Butler | Alabama | 1013 | 1 | 0 |
31441 | 31441 | 2020-04-04 | Butler | Iowa | 19023 | 1 | 0 |
31504 | 31504 | 2020-04-04 | Butler | Kansas | 20015 | 8 | 0 |
31562 | 31562 | 2020-04-04 | Butler | Kentucky | 21031 | 1 | 0 |
31962 | 31962 | 2020-04-04 | Butler | Missouri | 29023 | 2 | 0 |
32330 | 32330 | 2020-04-04 | Butler | Ohio | 39017 | 59 | 1 |
32490 | 32490 | 2020-04-04 | Butler | Pennsylvania | 42019 | 84 | 2 |
33164 | 33164 | 2020-04-05 | Butler | Alabama | 1013 | 1 | 0 |
33852 | 33852 | 2020-04-05 | Butler | Iowa | 19023 | 1 | 0 |
33917 | 33917 | 2020-04-05 | Butler | Kansas | 20015 | 8 | 0 |
33979 | 33979 | 2020-04-05 | Butler | Kentucky | 21031 | 1 | 0 |
34390 | 34390 | 2020-04-05 | Butler | Missouri | 29023 | 2 | 0 |
34763 | 34763 | 2020-04-05 | Butler | Ohio | 39017 | 68 | 2 |
34925 | 34925 | 2020-04-05 | Butler | Pennsylvania | 42019 | 87 | 2 |
35603 | 35603 | 2020-04-06 | Butler | Alabama | 1013 | 1 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
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);