ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 39101 and state = "Ohio" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5805 | 5805 | 2020-03-20 | Marion | Ohio | 39101 | 1 | 0 |
6806 | 6806 | 2020-03-21 | Marion | Ohio | 39101 | 1 | 0 |
7917 | 7917 | 2020-03-22 | Marion | Ohio | 39101 | 1 | 0 |
9123 | 9123 | 2020-03-23 | Marion | Ohio | 39101 | 3 | 0 |
10439 | 10439 | 2020-03-24 | Marion | Ohio | 39101 | 4 | 0 |
11888 | 11888 | 2020-03-25 | Marion | Ohio | 39101 | 4 | 0 |
13496 | 13496 | 2020-03-26 | Marion | Ohio | 39101 | 4 | 0 |
15234 | 15234 | 2020-03-27 | Marion | Ohio | 39101 | 5 | 0 |
17076 | 17076 | 2020-03-28 | Marion | Ohio | 39101 | 5 | 0 |
19010 | 19010 | 2020-03-29 | Marion | Ohio | 39101 | 6 | 0 |
21055 | 21055 | 2020-03-30 | Marion | Ohio | 39101 | 7 | 0 |
23187 | 23187 | 2020-03-31 | Marion | Ohio | 39101 | 8 | 0 |
25382 | 25382 | 2020-04-01 | Marion | Ohio | 39101 | 9 | 0 |
27650 | 27650 | 2020-04-02 | Marion | Ohio | 39101 | 10 | 0 |
29979 | 29979 | 2020-04-03 | Marion | Ohio | 39101 | 11 | 0 |
32368 | 32368 | 2020-04-04 | Marion | Ohio | 39101 | 12 | 0 |
34801 | 34801 | 2020-04-05 | Marion | Ohio | 39101 | 19 | 0 |
37270 | 37270 | 2020-04-06 | Marion | Ohio | 39101 | 25 | 0 |
39787 | 39787 | 2020-04-07 | Marion | Ohio | 39101 | 28 | 0 |
42347 | 42347 | 2020-04-08 | Marion | Ohio | 39101 | 32 | 0 |
44932 | 44932 | 2020-04-09 | Marion | Ohio | 39101 | 40 | 0 |
47547 | 47547 | 2020-04-10 | Marion | Ohio | 39101 | 42 | 0 |
50203 | 50203 | 2020-04-11 | Marion | Ohio | 39101 | 49 | 0 |
52876 | 52876 | 2020-04-12 | Marion | Ohio | 39101 | 53 | 0 |
55560 | 55560 | 2020-04-13 | Marion | Ohio | 39101 | 91 | 0 |
58261 | 58261 | 2020-04-14 | Marion | Ohio | 39101 | 110 | 0 |
60976 | 60976 | 2020-04-15 | Marion | Ohio | 39101 | 164 | 0 |
63702 | 63702 | 2020-04-16 | Marion | Ohio | 39101 | 276 | 1 |
66445 | 66445 | 2020-04-17 | Marion | Ohio | 39101 | 428 | 1 |
69202 | 69202 | 2020-04-18 | Marion | Ohio | 39101 | 983 | 1 |
71969 | 71969 | 2020-04-19 | Marion | Ohio | 39101 | 1834 | 1 |
74744 | 74744 | 2020-04-20 | Marion | Ohio | 39101 | 2073 | 1 |
77525 | 77525 | 2020-04-21 | Marion | Ohio | 39101 | 2132 | 1 |
80315 | 80315 | 2020-04-22 | Marion | Ohio | 39101 | 2137 | 3 |
83114 | 83114 | 2020-04-23 | Marion | Ohio | 39101 | 2161 | 3 |
85918 | 85918 | 2020-04-24 | Marion | Ohio | 39101 | 2169 | 4 |
88732 | 88732 | 2020-04-25 | Marion | Ohio | 39101 | 2172 | 4 |
91548 | 91548 | 2020-04-26 | Marion | Ohio | 39101 | 2178 | 4 |
94374 | 94374 | 2020-04-27 | Marion | Ohio | 39101 | 2188 | 4 |
97211 | 97211 | 2020-04-28 | Marion | Ohio | 39101 | 2191 | 4 |
100060 | 100060 | 2020-04-29 | Marion | Ohio | 39101 | 2196 | 4 |
102913 | 102913 | 2020-04-30 | Marion | Ohio | 39101 | 2196 | 4 |
105776 | 105776 | 2020-05-01 | Marion | Ohio | 39101 | 2276 | 4 |
108643 | 108643 | 2020-05-02 | Marion | Ohio | 39101 | 2294 | 4 |
111517 | 111517 | 2020-05-03 | Marion | Ohio | 39101 | 2329 | 4 |
114398 | 114398 | 2020-05-04 | Marion | Ohio | 39101 | 2332 | 4 |
117279 | 117279 | 2020-05-05 | Marion | Ohio | 39101 | 2335 | 9 |
120240 | 120240 | 2020-05-06 | Marion | Ohio | 39101 | 2347 | 13 |
123217 | 123217 | 2020-05-07 | Marion | Ohio | 39101 | 2350 | 13 |
126200 | 126200 | 2020-05-08 | Marion | Ohio | 39101 | 2366 | 13 |
129189 | 129189 | 2020-05-09 | Marion | Ohio | 39101 | 2381 | 13 |
132178 | 132178 | 2020-05-10 | Marion | Ohio | 39101 | 2387 | 13 |
135169 | 135169 | 2020-05-11 | Marion | Ohio | 39101 | 2404 | 14 |
138159 | 138159 | 2020-05-12 | Marion | Ohio | 39101 | 2412 | 14 |
141155 | 141155 | 2020-05-13 | Marion | Ohio | 39101 | 2419 | 15 |
144150 | 144150 | 2020-05-14 | Marion | Ohio | 39101 | 2431 | 15 |
147151 | 147151 | 2020-05-15 | Marion | Ohio | 39101 | 2436 | 15 |
150158 | 150158 | 2020-05-16 | Marion | Ohio | 39101 | 2449 | 15 |
153169 | 153169 | 2020-05-17 | Marion | Ohio | 39101 | 2500 | 15 |
156186 | 156186 | 2020-05-18 | Marion | Ohio | 39101 | 2513 | 15 |
159206 | 159206 | 2020-05-19 | Marion | Ohio | 39101 | 2524 | 15 |
162233 | 162233 | 2020-05-20 | Marion | Ohio | 39101 | 2540 | 18 |
165262 | 165262 | 2020-05-21 | Marion | Ohio | 39101 | 2557 | 18 |
168298 | 168298 | 2020-05-22 | Marion | Ohio | 39101 | 2581 | 18 |
171337 | 171337 | 2020-05-23 | Marion | Ohio | 39101 | 2608 | 21 |
174379 | 174379 | 2020-05-24 | Marion | Ohio | 39101 | 2617 | 21 |
177423 | 177423 | 2020-05-25 | Marion | Ohio | 39101 | 2619 | 21 |
180466 | 180466 | 2020-05-26 | Marion | Ohio | 39101 | 2623 | 23 |
183515 | 183515 | 2020-05-27 | Marion | Ohio | 39101 | 2628 | 23 |
186572 | 186572 | 2020-05-28 | Marion | Ohio | 39101 | 2642 | 25 |
189632 | 189632 | 2020-05-29 | Marion | Ohio | 39101 | 2657 | 28 |
192696 | 192696 | 2020-05-30 | Marion | Ohio | 39101 | 2660 | 28 |
195766 | 195766 | 2020-05-31 | Marion | Ohio | 39101 | 2666 | 28 |
198839 | 198839 | 2020-06-01 | Marion | Ohio | 39101 | 2668 | 28 |
201914 | 201914 | 2020-06-02 | Marion | Ohio | 39101 | 2674 | 30 |
204991 | 204991 | 2020-06-03 | Marion | Ohio | 39101 | 2679 | 31 |
208072 | 208072 | 2020-06-04 | Marion | Ohio | 39101 | 2686 | 31 |
211154 | 211154 | 2020-06-05 | Marion | Ohio | 39101 | 2688 | 32 |
214240 | 214240 | 2020-06-06 | Marion | Ohio | 39101 | 2689 | 32 |
217330 | 217330 | 2020-06-07 | Marion | Ohio | 39101 | 2691 | 32 |
220422 | 220422 | 2020-06-08 | Marion | Ohio | 39101 | 2694 | 32 |
223517 | 223517 | 2020-06-09 | Marion | Ohio | 39101 | 2695 | 32 |
226617 | 226617 | 2020-06-10 | Marion | Ohio | 39101 | 2697 | 33 |
229721 | 229721 | 2020-06-11 | Marion | Ohio | 39101 | 2699 | 33 |
232826 | 232826 | 2020-06-12 | Marion | Ohio | 39101 | 2701 | 33 |
235931 | 235931 | 2020-06-13 | Marion | Ohio | 39101 | 2704 | 33 |
239039 | 239039 | 2020-06-14 | Marion | Ohio | 39101 | 2706 | 33 |
242148 | 242148 | 2020-06-15 | Marion | Ohio | 39101 | 2706 | 33 |
245260 | 245260 | 2020-06-16 | Marion | Ohio | 39101 | 2712 | 33 |
248373 | 248373 | 2020-06-17 | Marion | Ohio | 39101 | 2712 | 33 |
251488 | 251488 | 2020-06-18 | Marion | Ohio | 39101 | 2713 | 34 |
254603 | 254603 | 2020-06-19 | Marion | Ohio | 39101 | 2715 | 34 |
257728 | 257728 | 2020-06-20 | Marion | Ohio | 39101 | 2715 | 34 |
260855 | 260855 | 2020-06-21 | Marion | Ohio | 39101 | 2715 | 34 |
263983 | 263983 | 2020-06-22 | Marion | Ohio | 39101 | 2713 | 35 |
267111 | 267111 | 2020-06-23 | Marion | Ohio | 39101 | 2713 | 35 |
270245 | 270245 | 2020-06-24 | Marion | Ohio | 39101 | 2714 | 35 |
273384 | 273384 | 2020-06-25 | Marion | Ohio | 39101 | 2717 | 36 |
276531 | 276531 | 2020-06-26 | Marion | Ohio | 39101 | 2717 | 36 |
279679 | 279679 | 2020-06-27 | Marion | Ohio | 39101 | 2719 | 37 |
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);