ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where county = "Scioto" and state = "Ohio" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
37290 | 37290 | 2020-04-06 | Scioto | Ohio | 39145 | 1 | 0 |
39808 | 39808 | 2020-04-07 | Scioto | Ohio | 39145 | 1 | 0 |
42368 | 42368 | 2020-04-08 | Scioto | Ohio | 39145 | 1 | 0 |
44954 | 44954 | 2020-04-09 | Scioto | Ohio | 39145 | 2 | 0 |
47569 | 47569 | 2020-04-10 | Scioto | Ohio | 39145 | 3 | 0 |
50225 | 50225 | 2020-04-11 | Scioto | Ohio | 39145 | 4 | 0 |
52898 | 52898 | 2020-04-12 | Scioto | Ohio | 39145 | 4 | 0 |
55582 | 55582 | 2020-04-13 | Scioto | Ohio | 39145 | 4 | 0 |
58283 | 58283 | 2020-04-14 | Scioto | Ohio | 39145 | 4 | 0 |
60998 | 60998 | 2020-04-15 | Scioto | Ohio | 39145 | 4 | 0 |
63724 | 63724 | 2020-04-16 | Scioto | Ohio | 39145 | 5 | 0 |
66467 | 66467 | 2020-04-17 | Scioto | Ohio | 39145 | 5 | 0 |
69224 | 69224 | 2020-04-18 | Scioto | Ohio | 39145 | 7 | 0 |
71991 | 71991 | 2020-04-19 | Scioto | Ohio | 39145 | 9 | 0 |
74766 | 74766 | 2020-04-20 | Scioto | Ohio | 39145 | 6 | 0 |
77547 | 77547 | 2020-04-21 | Scioto | Ohio | 39145 | 6 | 0 |
80337 | 80337 | 2020-04-22 | Scioto | Ohio | 39145 | 6 | 0 |
83136 | 83136 | 2020-04-23 | Scioto | Ohio | 39145 | 6 | 0 |
85940 | 85940 | 2020-04-24 | Scioto | Ohio | 39145 | 6 | 0 |
88754 | 88754 | 2020-04-25 | Scioto | Ohio | 39145 | 6 | 0 |
91570 | 91570 | 2020-04-26 | Scioto | Ohio | 39145 | 6 | 0 |
94396 | 94396 | 2020-04-27 | Scioto | Ohio | 39145 | 6 | 0 |
97233 | 97233 | 2020-04-28 | Scioto | Ohio | 39145 | 6 | 0 |
100082 | 100082 | 2020-04-29 | Scioto | Ohio | 39145 | 8 | 0 |
102935 | 102935 | 2020-04-30 | Scioto | Ohio | 39145 | 10 | 0 |
105798 | 105798 | 2020-05-01 | Scioto | Ohio | 39145 | 11 | 0 |
108665 | 108665 | 2020-05-02 | Scioto | Ohio | 39145 | 11 | 0 |
111539 | 111539 | 2020-05-03 | Scioto | Ohio | 39145 | 12 | 0 |
114420 | 114420 | 2020-05-04 | Scioto | Ohio | 39145 | 12 | 0 |
117301 | 117301 | 2020-05-05 | Scioto | Ohio | 39145 | 13 | 0 |
120262 | 120262 | 2020-05-06 | Scioto | Ohio | 39145 | 13 | 0 |
123239 | 123239 | 2020-05-07 | Scioto | Ohio | 39145 | 15 | 0 |
126222 | 126222 | 2020-05-08 | Scioto | Ohio | 39145 | 15 | 0 |
129211 | 129211 | 2020-05-09 | Scioto | Ohio | 39145 | 13 | 0 |
132200 | 132200 | 2020-05-10 | Scioto | Ohio | 39145 | 13 | 0 |
135191 | 135191 | 2020-05-11 | Scioto | Ohio | 39145 | 13 | 0 |
138181 | 138181 | 2020-05-12 | Scioto | Ohio | 39145 | 13 | 0 |
141177 | 141177 | 2020-05-13 | Scioto | Ohio | 39145 | 13 | 0 |
144172 | 144172 | 2020-05-14 | Scioto | Ohio | 39145 | 13 | 0 |
147173 | 147173 | 2020-05-15 | Scioto | Ohio | 39145 | 13 | 0 |
150180 | 150180 | 2020-05-16 | Scioto | Ohio | 39145 | 14 | 0 |
153191 | 153191 | 2020-05-17 | Scioto | Ohio | 39145 | 14 | 0 |
156208 | 156208 | 2020-05-18 | Scioto | Ohio | 39145 | 14 | 0 |
159228 | 159228 | 2020-05-19 | Scioto | Ohio | 39145 | 14 | 0 |
162255 | 162255 | 2020-05-20 | Scioto | Ohio | 39145 | 14 | 0 |
165284 | 165284 | 2020-05-21 | Scioto | Ohio | 39145 | 14 | 0 |
168320 | 168320 | 2020-05-22 | Scioto | Ohio | 39145 | 14 | 0 |
171359 | 171359 | 2020-05-23 | Scioto | Ohio | 39145 | 14 | 0 |
174401 | 174401 | 2020-05-24 | Scioto | Ohio | 39145 | 15 | 0 |
177445 | 177445 | 2020-05-25 | Scioto | Ohio | 39145 | 15 | 0 |
180488 | 180488 | 2020-05-26 | Scioto | Ohio | 39145 | 15 | 0 |
183537 | 183537 | 2020-05-27 | Scioto | Ohio | 39145 | 15 | 0 |
186594 | 186594 | 2020-05-28 | Scioto | Ohio | 39145 | 15 | 0 |
189654 | 189654 | 2020-05-29 | Scioto | Ohio | 39145 | 15 | 0 |
192718 | 192718 | 2020-05-30 | Scioto | Ohio | 39145 | 15 | 0 |
195788 | 195788 | 2020-05-31 | Scioto | Ohio | 39145 | 16 | 0 |
198861 | 198861 | 2020-06-01 | Scioto | Ohio | 39145 | 18 | 0 |
201936 | 201936 | 2020-06-02 | Scioto | Ohio | 39145 | 17 | 0 |
205013 | 205013 | 2020-06-03 | Scioto | Ohio | 39145 | 17 | 0 |
208094 | 208094 | 2020-06-04 | Scioto | Ohio | 39145 | 17 | 0 |
211176 | 211176 | 2020-06-05 | Scioto | Ohio | 39145 | 18 | 0 |
214262 | 214262 | 2020-06-06 | Scioto | Ohio | 39145 | 18 | 0 |
217352 | 217352 | 2020-06-07 | Scioto | Ohio | 39145 | 18 | 0 |
220444 | 220444 | 2020-06-08 | Scioto | Ohio | 39145 | 19 | 0 |
223539 | 223539 | 2020-06-09 | Scioto | Ohio | 39145 | 19 | 0 |
226639 | 226639 | 2020-06-10 | Scioto | Ohio | 39145 | 19 | 0 |
229743 | 229743 | 2020-06-11 | Scioto | Ohio | 39145 | 19 | 0 |
232848 | 232848 | 2020-06-12 | Scioto | Ohio | 39145 | 19 | 0 |
235953 | 235953 | 2020-06-13 | Scioto | Ohio | 39145 | 21 | 0 |
239061 | 239061 | 2020-06-14 | Scioto | Ohio | 39145 | 21 | 0 |
242170 | 242170 | 2020-06-15 | Scioto | Ohio | 39145 | 21 | 0 |
245282 | 245282 | 2020-06-16 | Scioto | Ohio | 39145 | 21 | 0 |
248395 | 248395 | 2020-06-17 | Scioto | Ohio | 39145 | 21 | 0 |
251510 | 251510 | 2020-06-18 | Scioto | Ohio | 39145 | 21 | 0 |
254625 | 254625 | 2020-06-19 | Scioto | Ohio | 39145 | 21 | 0 |
257750 | 257750 | 2020-06-20 | Scioto | Ohio | 39145 | 21 | 0 |
260877 | 260877 | 2020-06-21 | Scioto | Ohio | 39145 | 21 | 0 |
264005 | 264005 | 2020-06-22 | Scioto | Ohio | 39145 | 22 | 0 |
267133 | 267133 | 2020-06-23 | Scioto | Ohio | 39145 | 27 | 0 |
270267 | 270267 | 2020-06-24 | Scioto | Ohio | 39145 | 28 | 0 |
273406 | 273406 | 2020-06-25 | Scioto | Ohio | 39145 | 28 | 0 |
276553 | 276553 | 2020-06-26 | Scioto | Ohio | 39145 | 31 | 0 |
279701 | 279701 | 2020-06-27 | Scioto | Ohio | 39145 | 33 | 0 |
282847 | 282847 | 2020-06-28 | Scioto | Ohio | 39145 | 34 | 0 |
285992 | 285992 | 2020-06-29 | Scioto | Ohio | 39145 | 34 | 0 |
289142 | 289142 | 2020-06-30 | Scioto | Ohio | 39145 | 35 | 0 |
292294 | 292294 | 2020-07-01 | Scioto | Ohio | 39145 | 36 | 0 |
295449 | 295449 | 2020-07-02 | Scioto | Ohio | 39145 | 36 | 0 |
298609 | 298609 | 2020-07-03 | Scioto | Ohio | 39145 | 38 | 0 |
301772 | 301772 | 2020-07-04 | Scioto | Ohio | 39145 | 38 | 0 |
304935 | 304935 | 2020-07-05 | Scioto | Ohio | 39145 | 38 | 0 |
308102 | 308102 | 2020-07-06 | Scioto | Ohio | 39145 | 41 | 0 |
311271 | 311271 | 2020-07-07 | Scioto | Ohio | 39145 | 45 | 0 |
314443 | 314443 | 2020-07-08 | Scioto | Ohio | 39145 | 54 | 0 |
317616 | 317616 | 2020-07-09 | Scioto | Ohio | 39145 | 56 | 0 |
320793 | 320793 | 2020-07-10 | Scioto | Ohio | 39145 | 65 | 0 |
323973 | 323973 | 2020-07-11 | Scioto | Ohio | 39145 | 67 | 0 |
327158 | 327158 | 2020-07-12 | Scioto | Ohio | 39145 | 71 | 0 |
330345 | 330345 | 2020-07-13 | Scioto | Ohio | 39145 | 77 | 0 |
333537 | 333537 | 2020-07-14 | Scioto | Ohio | 39145 | 80 | 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);