ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Butler" and state = "Ohio" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2187 | 2187 | 2020-03-14 | Butler | Ohio | 39017 | 4 | 0 |
2601 | 2601 | 2020-03-15 | Butler | Ohio | 39017 | 6 | 0 |
3063 | 3063 | 2020-03-16 | Butler | Ohio | 39017 | 6 | 0 |
3586 | 3586 | 2020-03-17 | Butler | Ohio | 39017 | 6 | 0 |
4197 | 4197 | 2020-03-18 | Butler | Ohio | 39017 | 8 | 0 |
4928 | 4928 | 2020-03-19 | Butler | Ohio | 39017 | 8 | 0 |
5790 | 5790 | 2020-03-20 | Butler | Ohio | 39017 | 12 | 0 |
6787 | 6787 | 2020-03-21 | Butler | Ohio | 39017 | 16 | 0 |
7893 | 7893 | 2020-03-22 | Butler | Ohio | 39017 | 17 | 0 |
9096 | 9096 | 2020-03-23 | Butler | Ohio | 39017 | 17 | 0 |
10408 | 10408 | 2020-03-24 | Butler | Ohio | 39017 | 18 | 0 |
11855 | 11855 | 2020-03-25 | Butler | Ohio | 39017 | 18 | 0 |
13462 | 13462 | 2020-03-26 | Butler | Ohio | 39017 | 21 | 0 |
15199 | 15199 | 2020-03-27 | Butler | Ohio | 39017 | 23 | 0 |
17041 | 17041 | 2020-03-28 | Butler | Ohio | 39017 | 25 | 0 |
18975 | 18975 | 2020-03-29 | Butler | Ohio | 39017 | 27 | 0 |
21019 | 21019 | 2020-03-30 | Butler | Ohio | 39017 | 30 | 0 |
23151 | 23151 | 2020-03-31 | Butler | Ohio | 39017 | 36 | 0 |
25346 | 25346 | 2020-04-01 | Butler | Ohio | 39017 | 41 | 0 |
27612 | 27612 | 2020-04-02 | Butler | Ohio | 39017 | 45 | 0 |
29941 | 29941 | 2020-04-03 | Butler | Ohio | 39017 | 49 | 1 |
32330 | 32330 | 2020-04-04 | Butler | Ohio | 39017 | 59 | 1 |
34763 | 34763 | 2020-04-05 | Butler | Ohio | 39017 | 68 | 2 |
37232 | 37232 | 2020-04-06 | Butler | Ohio | 39017 | 75 | 2 |
39749 | 39749 | 2020-04-07 | Butler | Ohio | 39017 | 92 | 2 |
42307 | 42307 | 2020-04-08 | Butler | Ohio | 39017 | 102 | 2 |
44892 | 44892 | 2020-04-09 | Butler | Ohio | 39017 | 108 | 2 |
47507 | 47507 | 2020-04-10 | Butler | Ohio | 39017 | 112 | 2 |
50162 | 50162 | 2020-04-11 | Butler | Ohio | 39017 | 115 | 2 |
52835 | 52835 | 2020-04-12 | Butler | Ohio | 39017 | 117 | 2 |
55519 | 55519 | 2020-04-13 | Butler | Ohio | 39017 | 121 | 2 |
58220 | 58220 | 2020-04-14 | Butler | Ohio | 39017 | 127 | 2 |
60934 | 60934 | 2020-04-15 | Butler | Ohio | 39017 | 133 | 2 |
63660 | 63660 | 2020-04-16 | Butler | Ohio | 39017 | 148 | 2 |
66403 | 66403 | 2020-04-17 | Butler | Ohio | 39017 | 155 | 2 |
69160 | 69160 | 2020-04-18 | Butler | Ohio | 39017 | 164 | 2 |
71927 | 71927 | 2020-04-19 | Butler | Ohio | 39017 | 166 | 2 |
74702 | 74702 | 2020-04-20 | Butler | Ohio | 39017 | 180 | 2 |
77483 | 77483 | 2020-04-21 | Butler | Ohio | 39017 | 184 | 2 |
80273 | 80273 | 2020-04-22 | Butler | Ohio | 39017 | 192 | 4 |
83072 | 83072 | 2020-04-23 | Butler | Ohio | 39017 | 201 | 4 |
85876 | 85876 | 2020-04-24 | Butler | Ohio | 39017 | 208 | 4 |
88690 | 88690 | 2020-04-25 | Butler | Ohio | 39017 | 216 | 4 |
91506 | 91506 | 2020-04-26 | Butler | Ohio | 39017 | 225 | 4 |
94332 | 94332 | 2020-04-27 | Butler | Ohio | 39017 | 234 | 4 |
97169 | 97169 | 2020-04-28 | Butler | Ohio | 39017 | 254 | 5 |
100018 | 100018 | 2020-04-29 | Butler | Ohio | 39017 | 261 | 7 |
102871 | 102871 | 2020-04-30 | Butler | Ohio | 39017 | 281 | 7 |
105734 | 105734 | 2020-05-01 | Butler | Ohio | 39017 | 296 | 7 |
108601 | 108601 | 2020-05-02 | Butler | Ohio | 39017 | 318 | 7 |
111475 | 111475 | 2020-05-03 | Butler | Ohio | 39017 | 328 | 7 |
114356 | 114356 | 2020-05-04 | Butler | Ohio | 39017 | 334 | 7 |
117237 | 117237 | 2020-05-05 | Butler | Ohio | 39017 | 346 | 8 |
120198 | 120198 | 2020-05-06 | Butler | Ohio | 39017 | 361 | 10 |
123175 | 123175 | 2020-05-07 | Butler | Ohio | 39017 | 372 | 12 |
126158 | 126158 | 2020-05-08 | Butler | Ohio | 39017 | 404 | 12 |
129147 | 129147 | 2020-05-09 | Butler | Ohio | 39017 | 436 | 13 |
132136 | 132136 | 2020-05-10 | Butler | Ohio | 39017 | 452 | 13 |
135127 | 135127 | 2020-05-11 | Butler | Ohio | 39017 | 479 | 13 |
138117 | 138117 | 2020-05-12 | Butler | Ohio | 39017 | 496 | 14 |
141113 | 141113 | 2020-05-13 | Butler | Ohio | 39017 | 509 | 15 |
144108 | 144108 | 2020-05-14 | Butler | Ohio | 39017 | 542 | 16 |
147109 | 147109 | 2020-05-15 | Butler | Ohio | 39017 | 558 | 16 |
150116 | 150116 | 2020-05-16 | Butler | Ohio | 39017 | 578 | 16 |
153127 | 153127 | 2020-05-17 | Butler | Ohio | 39017 | 591 | 16 |
156144 | 156144 | 2020-05-18 | Butler | Ohio | 39017 | 610 | 16 |
159164 | 159164 | 2020-05-19 | Butler | Ohio | 39017 | 639 | 17 |
162191 | 162191 | 2020-05-20 | Butler | Ohio | 39017 | 671 | 19 |
165220 | 165220 | 2020-05-21 | Butler | Ohio | 39017 | 699 | 23 |
168256 | 168256 | 2020-05-22 | Butler | Ohio | 39017 | 734 | 23 |
171295 | 171295 | 2020-05-23 | Butler | Ohio | 39017 | 750 | 25 |
174337 | 174337 | 2020-05-24 | Butler | Ohio | 39017 | 776 | 25 |
177381 | 177381 | 2020-05-25 | Butler | Ohio | 39017 | 802 | 25 |
180424 | 180424 | 2020-05-26 | Butler | Ohio | 39017 | 817 | 25 |
183473 | 183473 | 2020-05-27 | Butler | Ohio | 39017 | 826 | 26 |
186530 | 186530 | 2020-05-28 | Butler | Ohio | 39017 | 847 | 28 |
189590 | 189590 | 2020-05-29 | Butler | Ohio | 39017 | 862 | 29 |
192654 | 192654 | 2020-05-30 | Butler | Ohio | 39017 | 874 | 29 |
195724 | 195724 | 2020-05-31 | Butler | Ohio | 39017 | 893 | 29 |
198797 | 198797 | 2020-06-01 | Butler | Ohio | 39017 | 909 | 31 |
201872 | 201872 | 2020-06-02 | Butler | Ohio | 39017 | 919 | 32 |
204949 | 204949 | 2020-06-03 | Butler | Ohio | 39017 | 933 | 33 |
208030 | 208030 | 2020-06-04 | Butler | Ohio | 39017 | 948 | 32 |
211112 | 211112 | 2020-06-05 | Butler | Ohio | 39017 | 975 | 32 |
214198 | 214198 | 2020-06-06 | Butler | Ohio | 39017 | 985 | 32 |
217288 | 217288 | 2020-06-07 | Butler | Ohio | 39017 | 999 | 32 |
220380 | 220380 | 2020-06-08 | Butler | Ohio | 39017 | 1013 | 32 |
223475 | 223475 | 2020-06-09 | Butler | Ohio | 39017 | 1034 | 32 |
226575 | 226575 | 2020-06-10 | Butler | Ohio | 39017 | 1045 | 32 |
229679 | 229679 | 2020-06-11 | Butler | Ohio | 39017 | 1048 | 33 |
232784 | 232784 | 2020-06-12 | Butler | Ohio | 39017 | 1065 | 33 |
235889 | 235889 | 2020-06-13 | Butler | Ohio | 39017 | 1080 | 33 |
238997 | 238997 | 2020-06-14 | Butler | Ohio | 39017 | 1090 | 34 |
242106 | 242106 | 2020-06-15 | Butler | Ohio | 39017 | 1103 | 34 |
245218 | 245218 | 2020-06-16 | Butler | Ohio | 39017 | 1120 | 35 |
248331 | 248331 | 2020-06-17 | Butler | Ohio | 39017 | 1129 | 35 |
251446 | 251446 | 2020-06-18 | Butler | Ohio | 39017 | 1153 | 36 |
254561 | 254561 | 2020-06-19 | Butler | Ohio | 39017 | 1166 | 37 |
257686 | 257686 | 2020-06-20 | Butler | Ohio | 39017 | 1194 | 39 |
260813 | 260813 | 2020-06-21 | Butler | Ohio | 39017 | 1201 | 39 |
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);