ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
69,101 rows where state = "Ohio" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
- 39035 796
- 39151 794
- 39155 793
- 39013 791
- 39017 791
- 39049 791
- 39093 791
- 39153 791
- 39157 791
- 39095 790
- 39103 790
- 39055 789
- 39031 788
- 39037 788
- 39085 788
- 39099 788
- 39005 787
- 39023 787
- 39041 787
- 39077 787
- 39109 787
- 39061 786
- 39113 786
- 39139 786
- 39007 785
- 39029 785
- 39101 785
- 39159 785
- 39165 785
- 39025 784
- …
county >30
- Cuyahoga 796
- Stark 794
- Trumbull 793
- Belmont 791
- Butler 791
- Franklin 791
- Lorain 791
- Summit 791
- Tuscarawas 791
- Lucas 790
- Medina 790
- Geauga 789
- Coshocton 788
- Darke 788
- Lake 788
- Mahoning 788
- Ashland 787
- Clark 787
- Delaware 787
- Huron 787
- Miami 787
- Hamilton 786
- Montgomery 786
- Richland 786
- Ashtabula 785
- Columbiana 785
- Marion 785
- Union 785
- Warren 785
- Clermont 784
- …
state 1
- Ohio · 69,101 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
32322 | 32322 | 2020-04-04 | Adams | Ohio | 39001 | 1 | 0 |
34755 | 34755 | 2020-04-05 | Adams | Ohio | 39001 | 2 | 0 |
37224 | 37224 | 2020-04-06 | Adams | Ohio | 39001 | 2 | 0 |
39741 | 39741 | 2020-04-07 | Adams | Ohio | 39001 | 2 | 0 |
42299 | 42299 | 2020-04-08 | Adams | Ohio | 39001 | 2 | 0 |
44884 | 44884 | 2020-04-09 | Adams | Ohio | 39001 | 3 | 0 |
47499 | 47499 | 2020-04-10 | Adams | Ohio | 39001 | 3 | 0 |
50154 | 50154 | 2020-04-11 | Adams | Ohio | 39001 | 3 | 0 |
52827 | 52827 | 2020-04-12 | Adams | Ohio | 39001 | 3 | 0 |
55511 | 55511 | 2020-04-13 | Adams | Ohio | 39001 | 3 | 0 |
58212 | 58212 | 2020-04-14 | Adams | Ohio | 39001 | 3 | 0 |
60926 | 60926 | 2020-04-15 | Adams | Ohio | 39001 | 3 | 0 |
63652 | 63652 | 2020-04-16 | Adams | Ohio | 39001 | 3 | 0 |
66395 | 66395 | 2020-04-17 | Adams | Ohio | 39001 | 3 | 0 |
69152 | 69152 | 2020-04-18 | Adams | Ohio | 39001 | 3 | 0 |
71919 | 71919 | 2020-04-19 | Adams | Ohio | 39001 | 3 | 0 |
74694 | 74694 | 2020-04-20 | Adams | Ohio | 39001 | 3 | 0 |
77475 | 77475 | 2020-04-21 | Adams | Ohio | 39001 | 3 | 0 |
80265 | 80265 | 2020-04-22 | Adams | Ohio | 39001 | 4 | 0 |
83064 | 83064 | 2020-04-23 | Adams | Ohio | 39001 | 4 | 0 |
85868 | 85868 | 2020-04-24 | Adams | Ohio | 39001 | 4 | 0 |
88682 | 88682 | 2020-04-25 | Adams | Ohio | 39001 | 4 | 0 |
91498 | 91498 | 2020-04-26 | Adams | Ohio | 39001 | 4 | 0 |
94324 | 94324 | 2020-04-27 | Adams | Ohio | 39001 | 4 | 0 |
97161 | 97161 | 2020-04-28 | Adams | Ohio | 39001 | 4 | 0 |
100010 | 100010 | 2020-04-29 | Adams | Ohio | 39001 | 5 | 0 |
102863 | 102863 | 2020-04-30 | Adams | Ohio | 39001 | 4 | 0 |
105726 | 105726 | 2020-05-01 | Adams | Ohio | 39001 | 5 | 0 |
108593 | 108593 | 2020-05-02 | Adams | Ohio | 39001 | 5 | 0 |
111467 | 111467 | 2020-05-03 | Adams | Ohio | 39001 | 5 | 0 |
114348 | 114348 | 2020-05-04 | Adams | Ohio | 39001 | 5 | 0 |
117229 | 117229 | 2020-05-05 | Adams | Ohio | 39001 | 5 | 0 |
120190 | 120190 | 2020-05-06 | Adams | Ohio | 39001 | 5 | 0 |
123167 | 123167 | 2020-05-07 | Adams | Ohio | 39001 | 5 | 0 |
126150 | 126150 | 2020-05-08 | Adams | Ohio | 39001 | 5 | 0 |
129139 | 129139 | 2020-05-09 | Adams | Ohio | 39001 | 6 | 0 |
132128 | 132128 | 2020-05-10 | Adams | Ohio | 39001 | 6 | 0 |
135119 | 135119 | 2020-05-11 | Adams | Ohio | 39001 | 6 | 0 |
138109 | 138109 | 2020-05-12 | Adams | Ohio | 39001 | 6 | 0 |
141105 | 141105 | 2020-05-13 | Adams | Ohio | 39001 | 6 | 0 |
144100 | 144100 | 2020-05-14 | Adams | Ohio | 39001 | 7 | 0 |
147101 | 147101 | 2020-05-15 | Adams | Ohio | 39001 | 8 | 0 |
150108 | 150108 | 2020-05-16 | Adams | Ohio | 39001 | 8 | 0 |
153119 | 153119 | 2020-05-17 | Adams | Ohio | 39001 | 8 | 0 |
156136 | 156136 | 2020-05-18 | Adams | Ohio | 39001 | 8 | 1 |
159156 | 159156 | 2020-05-19 | Adams | Ohio | 39001 | 8 | 1 |
162183 | 162183 | 2020-05-20 | Adams | Ohio | 39001 | 8 | 1 |
165212 | 165212 | 2020-05-21 | Adams | Ohio | 39001 | 8 | 1 |
168248 | 168248 | 2020-05-22 | Adams | Ohio | 39001 | 8 | 1 |
171287 | 171287 | 2020-05-23 | Adams | Ohio | 39001 | 8 | 1 |
174329 | 174329 | 2020-05-24 | Adams | Ohio | 39001 | 8 | 1 |
177373 | 177373 | 2020-05-25 | Adams | Ohio | 39001 | 8 | 1 |
180416 | 180416 | 2020-05-26 | Adams | Ohio | 39001 | 8 | 1 |
183465 | 183465 | 2020-05-27 | Adams | Ohio | 39001 | 8 | 1 |
186522 | 186522 | 2020-05-28 | Adams | Ohio | 39001 | 8 | 1 |
189582 | 189582 | 2020-05-29 | Adams | Ohio | 39001 | 9 | 1 |
192646 | 192646 | 2020-05-30 | Adams | Ohio | 39001 | 9 | 1 |
195716 | 195716 | 2020-05-31 | Adams | Ohio | 39001 | 10 | 1 |
198789 | 198789 | 2020-06-01 | Adams | Ohio | 39001 | 10 | 1 |
201864 | 201864 | 2020-06-02 | Adams | Ohio | 39001 | 10 | 1 |
204941 | 204941 | 2020-06-03 | Adams | Ohio | 39001 | 10 | 1 |
208022 | 208022 | 2020-06-04 | Adams | Ohio | 39001 | 11 | 1 |
211104 | 211104 | 2020-06-05 | Adams | Ohio | 39001 | 11 | 1 |
214190 | 214190 | 2020-06-06 | Adams | Ohio | 39001 | 11 | 1 |
217280 | 217280 | 2020-06-07 | Adams | Ohio | 39001 | 11 | 1 |
220372 | 220372 | 2020-06-08 | Adams | Ohio | 39001 | 11 | 1 |
223467 | 223467 | 2020-06-09 | Adams | Ohio | 39001 | 11 | 1 |
226567 | 226567 | 2020-06-10 | Adams | Ohio | 39001 | 12 | 1 |
229671 | 229671 | 2020-06-11 | Adams | Ohio | 39001 | 12 | 1 |
232776 | 232776 | 2020-06-12 | Adams | Ohio | 39001 | 12 | 1 |
235881 | 235881 | 2020-06-13 | Adams | Ohio | 39001 | 14 | 1 |
238989 | 238989 | 2020-06-14 | Adams | Ohio | 39001 | 15 | 1 |
242098 | 242098 | 2020-06-15 | Adams | Ohio | 39001 | 15 | 1 |
245210 | 245210 | 2020-06-16 | Adams | Ohio | 39001 | 17 | 1 |
248323 | 248323 | 2020-06-17 | Adams | Ohio | 39001 | 17 | 1 |
251438 | 251438 | 2020-06-18 | Adams | Ohio | 39001 | 18 | 1 |
254553 | 254553 | 2020-06-19 | Adams | Ohio | 39001 | 18 | 1 |
257678 | 257678 | 2020-06-20 | Adams | Ohio | 39001 | 18 | 1 |
260805 | 260805 | 2020-06-21 | Adams | Ohio | 39001 | 18 | 1 |
263933 | 263933 | 2020-06-22 | Adams | Ohio | 39001 | 19 | 1 |
267061 | 267061 | 2020-06-23 | Adams | Ohio | 39001 | 19 | 1 |
270195 | 270195 | 2020-06-24 | Adams | Ohio | 39001 | 19 | 1 |
273334 | 273334 | 2020-06-25 | Adams | Ohio | 39001 | 20 | 1 |
276481 | 276481 | 2020-06-26 | Adams | Ohio | 39001 | 20 | 1 |
279629 | 279629 | 2020-06-27 | Adams | Ohio | 39001 | 20 | 1 |
282775 | 282775 | 2020-06-28 | Adams | Ohio | 39001 | 20 | 1 |
285920 | 285920 | 2020-06-29 | Adams | Ohio | 39001 | 21 | 1 |
289070 | 289070 | 2020-06-30 | Adams | Ohio | 39001 | 21 | 1 |
292222 | 292222 | 2020-07-01 | Adams | Ohio | 39001 | 21 | 1 |
295377 | 295377 | 2020-07-02 | Adams | Ohio | 39001 | 21 | 1 |
298537 | 298537 | 2020-07-03 | Adams | Ohio | 39001 | 22 | 1 |
301700 | 301700 | 2020-07-04 | Adams | Ohio | 39001 | 23 | 1 |
304863 | 304863 | 2020-07-05 | Adams | Ohio | 39001 | 22 | 1 |
308030 | 308030 | 2020-07-06 | Adams | Ohio | 39001 | 24 | 1 |
311199 | 311199 | 2020-07-07 | Adams | Ohio | 39001 | 24 | 1 |
314371 | 314371 | 2020-07-08 | Adams | Ohio | 39001 | 24 | 1 |
317544 | 317544 | 2020-07-09 | Adams | Ohio | 39001 | 24 | 1 |
320721 | 320721 | 2020-07-10 | Adams | Ohio | 39001 | 25 | 1 |
323901 | 323901 | 2020-07-11 | Adams | Ohio | 39001 | 26 | 1 |
327086 | 327086 | 2020-07-12 | Adams | Ohio | 39001 | 26 | 1 |
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);