ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 39131 and state = "Ohio" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
17084 | 17084 | 2020-03-28 | Pike | Ohio | 39131 | 1 | 0 |
19018 | 19018 | 2020-03-29 | Pike | Ohio | 39131 | 1 | 0 |
21063 | 21063 | 2020-03-30 | Pike | Ohio | 39131 | 1 | 0 |
23196 | 23196 | 2020-03-31 | Pike | Ohio | 39131 | 1 | 0 |
25392 | 25392 | 2020-04-01 | Pike | Ohio | 39131 | 1 | 0 |
27660 | 27660 | 2020-04-02 | Pike | Ohio | 39131 | 1 | 0 |
29989 | 29989 | 2020-04-03 | Pike | Ohio | 39131 | 1 | 0 |
32378 | 32378 | 2020-04-04 | Pike | Ohio | 39131 | 1 | 0 |
34812 | 34812 | 2020-04-05 | Pike | Ohio | 39131 | 1 | 0 |
37283 | 37283 | 2020-04-06 | Pike | Ohio | 39131 | 1 | 0 |
39801 | 39801 | 2020-04-07 | Pike | Ohio | 39131 | 1 | 0 |
42361 | 42361 | 2020-04-08 | Pike | Ohio | 39131 | 1 | 0 |
44947 | 44947 | 2020-04-09 | Pike | Ohio | 39131 | 1 | 0 |
47562 | 47562 | 2020-04-10 | Pike | Ohio | 39131 | 1 | 0 |
50218 | 50218 | 2020-04-11 | Pike | Ohio | 39131 | 1 | 0 |
52891 | 52891 | 2020-04-12 | Pike | Ohio | 39131 | 1 | 0 |
55575 | 55575 | 2020-04-13 | Pike | Ohio | 39131 | 1 | 0 |
58276 | 58276 | 2020-04-14 | Pike | Ohio | 39131 | 1 | 0 |
60991 | 60991 | 2020-04-15 | Pike | Ohio | 39131 | 1 | 0 |
63717 | 63717 | 2020-04-16 | Pike | Ohio | 39131 | 1 | 0 |
66460 | 66460 | 2020-04-17 | Pike | Ohio | 39131 | 1 | 0 |
69217 | 69217 | 2020-04-18 | Pike | Ohio | 39131 | 1 | 0 |
71984 | 71984 | 2020-04-19 | Pike | Ohio | 39131 | 1 | 0 |
74759 | 74759 | 2020-04-20 | Pike | Ohio | 39131 | 2 | 0 |
77540 | 77540 | 2020-04-21 | Pike | Ohio | 39131 | 2 | 0 |
80330 | 80330 | 2020-04-22 | Pike | Ohio | 39131 | 2 | 0 |
83129 | 83129 | 2020-04-23 | Pike | Ohio | 39131 | 2 | 0 |
85933 | 85933 | 2020-04-24 | Pike | Ohio | 39131 | 2 | 0 |
88747 | 88747 | 2020-04-25 | Pike | Ohio | 39131 | 3 | 0 |
91563 | 91563 | 2020-04-26 | Pike | Ohio | 39131 | 3 | 0 |
94389 | 94389 | 2020-04-27 | Pike | Ohio | 39131 | 3 | 0 |
97226 | 97226 | 2020-04-28 | Pike | Ohio | 39131 | 3 | 0 |
100075 | 100075 | 2020-04-29 | Pike | Ohio | 39131 | 3 | 0 |
102928 | 102928 | 2020-04-30 | Pike | Ohio | 39131 | 3 | 0 |
105791 | 105791 | 2020-05-01 | Pike | Ohio | 39131 | 3 | 0 |
108658 | 108658 | 2020-05-02 | Pike | Ohio | 39131 | 3 | 0 |
111532 | 111532 | 2020-05-03 | Pike | Ohio | 39131 | 3 | 0 |
114413 | 114413 | 2020-05-04 | Pike | Ohio | 39131 | 3 | 0 |
117294 | 117294 | 2020-05-05 | Pike | Ohio | 39131 | 4 | 0 |
120255 | 120255 | 2020-05-06 | Pike | Ohio | 39131 | 4 | 0 |
123232 | 123232 | 2020-05-07 | Pike | Ohio | 39131 | 4 | 0 |
126215 | 126215 | 2020-05-08 | Pike | Ohio | 39131 | 4 | 0 |
129204 | 129204 | 2020-05-09 | Pike | Ohio | 39131 | 5 | 0 |
132193 | 132193 | 2020-05-10 | Pike | Ohio | 39131 | 5 | 0 |
135184 | 135184 | 2020-05-11 | Pike | Ohio | 39131 | 5 | 0 |
138174 | 138174 | 2020-05-12 | Pike | Ohio | 39131 | 5 | 0 |
141170 | 141170 | 2020-05-13 | Pike | Ohio | 39131 | 5 | 0 |
144165 | 144165 | 2020-05-14 | Pike | Ohio | 39131 | 5 | 0 |
147166 | 147166 | 2020-05-15 | Pike | Ohio | 39131 | 5 | 0 |
150173 | 150173 | 2020-05-16 | Pike | Ohio | 39131 | 5 | 0 |
153184 | 153184 | 2020-05-17 | Pike | Ohio | 39131 | 5 | 0 |
156201 | 156201 | 2020-05-18 | Pike | Ohio | 39131 | 5 | 0 |
159221 | 159221 | 2020-05-19 | Pike | Ohio | 39131 | 6 | 0 |
162248 | 162248 | 2020-05-20 | Pike | Ohio | 39131 | 6 | 0 |
165277 | 165277 | 2020-05-21 | Pike | Ohio | 39131 | 6 | 0 |
168313 | 168313 | 2020-05-22 | Pike | Ohio | 39131 | 6 | 0 |
171352 | 171352 | 2020-05-23 | Pike | Ohio | 39131 | 6 | 0 |
174394 | 174394 | 2020-05-24 | Pike | Ohio | 39131 | 6 | 0 |
177438 | 177438 | 2020-05-25 | Pike | Ohio | 39131 | 6 | 0 |
180481 | 180481 | 2020-05-26 | Pike | Ohio | 39131 | 6 | 0 |
183530 | 183530 | 2020-05-27 | Pike | Ohio | 39131 | 6 | 0 |
186587 | 186587 | 2020-05-28 | Pike | Ohio | 39131 | 6 | 0 |
189647 | 189647 | 2020-05-29 | Pike | Ohio | 39131 | 6 | 0 |
192711 | 192711 | 2020-05-30 | Pike | Ohio | 39131 | 6 | 0 |
195781 | 195781 | 2020-05-31 | Pike | Ohio | 39131 | 6 | 0 |
198854 | 198854 | 2020-06-01 | Pike | Ohio | 39131 | 8 | 0 |
201929 | 201929 | 2020-06-02 | Pike | Ohio | 39131 | 8 | 0 |
205006 | 205006 | 2020-06-03 | Pike | Ohio | 39131 | 9 | 0 |
208087 | 208087 | 2020-06-04 | Pike | Ohio | 39131 | 9 | 0 |
211169 | 211169 | 2020-06-05 | Pike | Ohio | 39131 | 9 | 0 |
214255 | 214255 | 2020-06-06 | Pike | Ohio | 39131 | 9 | 0 |
217345 | 217345 | 2020-06-07 | Pike | Ohio | 39131 | 9 | 0 |
220437 | 220437 | 2020-06-08 | Pike | Ohio | 39131 | 9 | 0 |
223532 | 223532 | 2020-06-09 | Pike | Ohio | 39131 | 9 | 0 |
226632 | 226632 | 2020-06-10 | Pike | Ohio | 39131 | 9 | 0 |
229736 | 229736 | 2020-06-11 | Pike | Ohio | 39131 | 10 | 0 |
232841 | 232841 | 2020-06-12 | Pike | Ohio | 39131 | 9 | 0 |
235946 | 235946 | 2020-06-13 | Pike | Ohio | 39131 | 9 | 0 |
239054 | 239054 | 2020-06-14 | Pike | Ohio | 39131 | 9 | 0 |
242163 | 242163 | 2020-06-15 | Pike | Ohio | 39131 | 9 | 0 |
245275 | 245275 | 2020-06-16 | Pike | Ohio | 39131 | 9 | 0 |
248388 | 248388 | 2020-06-17 | Pike | Ohio | 39131 | 11 | 0 |
251503 | 251503 | 2020-06-18 | Pike | Ohio | 39131 | 12 | 0 |
254618 | 254618 | 2020-06-19 | Pike | Ohio | 39131 | 12 | 0 |
257743 | 257743 | 2020-06-20 | Pike | Ohio | 39131 | 13 | 0 |
260870 | 260870 | 2020-06-21 | Pike | Ohio | 39131 | 14 | 0 |
263998 | 263998 | 2020-06-22 | Pike | Ohio | 39131 | 17 | 0 |
267126 | 267126 | 2020-06-23 | Pike | Ohio | 39131 | 17 | 0 |
270260 | 270260 | 2020-06-24 | Pike | Ohio | 39131 | 17 | 0 |
273399 | 273399 | 2020-06-25 | Pike | Ohio | 39131 | 19 | 0 |
276546 | 276546 | 2020-06-26 | Pike | Ohio | 39131 | 20 | 0 |
279694 | 279694 | 2020-06-27 | Pike | Ohio | 39131 | 20 | 0 |
282840 | 282840 | 2020-06-28 | Pike | Ohio | 39131 | 20 | 0 |
285985 | 285985 | 2020-06-29 | Pike | Ohio | 39131 | 20 | 0 |
289135 | 289135 | 2020-06-30 | Pike | Ohio | 39131 | 20 | 0 |
292287 | 292287 | 2020-07-01 | Pike | Ohio | 39131 | 20 | 0 |
295442 | 295442 | 2020-07-02 | Pike | Ohio | 39131 | 20 | 0 |
298602 | 298602 | 2020-07-03 | Pike | Ohio | 39131 | 22 | 0 |
301765 | 301765 | 2020-07-04 | Pike | Ohio | 39131 | 23 | 0 |
304928 | 304928 | 2020-07-05 | Pike | Ohio | 39131 | 23 | 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);