ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 39023 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 |
---|---|---|---|---|---|---|---|
4198 | 4198 | 2020-03-18 | Clark | Ohio | 39023 | 1 | 0 |
4929 | 4929 | 2020-03-19 | Clark | Ohio | 39023 | 1 | 0 |
5791 | 5791 | 2020-03-20 | Clark | Ohio | 39023 | 1 | 0 |
6788 | 6788 | 2020-03-21 | Clark | Ohio | 39023 | 1 | 0 |
7895 | 7895 | 2020-03-22 | Clark | Ohio | 39023 | 1 | 0 |
9098 | 9098 | 2020-03-23 | Clark | Ohio | 39023 | 1 | 0 |
10411 | 10411 | 2020-03-24 | Clark | Ohio | 39023 | 2 | 0 |
11858 | 11858 | 2020-03-25 | Clark | Ohio | 39023 | 2 | 0 |
13465 | 13465 | 2020-03-26 | Clark | Ohio | 39023 | 2 | 0 |
15202 | 15202 | 2020-03-27 | Clark | Ohio | 39023 | 2 | 0 |
17044 | 17044 | 2020-03-28 | Clark | Ohio | 39023 | 2 | 0 |
18978 | 18978 | 2020-03-29 | Clark | Ohio | 39023 | 7 | 0 |
21022 | 21022 | 2020-03-30 | Clark | Ohio | 39023 | 6 | 0 |
23154 | 23154 | 2020-03-31 | Clark | Ohio | 39023 | 6 | 0 |
25349 | 25349 | 2020-04-01 | Clark | Ohio | 39023 | 6 | 0 |
27615 | 27615 | 2020-04-02 | Clark | Ohio | 39023 | 7 | 0 |
29944 | 29944 | 2020-04-03 | Clark | Ohio | 39023 | 7 | 0 |
32333 | 32333 | 2020-04-04 | Clark | Ohio | 39023 | 7 | 0 |
34766 | 34766 | 2020-04-05 | Clark | Ohio | 39023 | 8 | 0 |
37235 | 37235 | 2020-04-06 | Clark | Ohio | 39023 | 10 | 0 |
39752 | 39752 | 2020-04-07 | Clark | Ohio | 39023 | 11 | 0 |
42310 | 42310 | 2020-04-08 | Clark | Ohio | 39023 | 13 | 0 |
44895 | 44895 | 2020-04-09 | Clark | Ohio | 39023 | 14 | 0 |
47510 | 47510 | 2020-04-10 | Clark | Ohio | 39023 | 14 | 0 |
50165 | 50165 | 2020-04-11 | Clark | Ohio | 39023 | 18 | 0 |
52838 | 52838 | 2020-04-12 | Clark | Ohio | 39023 | 20 | 0 |
55522 | 55522 | 2020-04-13 | Clark | Ohio | 39023 | 20 | 0 |
58223 | 58223 | 2020-04-14 | Clark | Ohio | 39023 | 20 | 0 |
60937 | 60937 | 2020-04-15 | Clark | Ohio | 39023 | 21 | 0 |
63663 | 63663 | 2020-04-16 | Clark | Ohio | 39023 | 23 | 0 |
66406 | 66406 | 2020-04-17 | Clark | Ohio | 39023 | 25 | 0 |
69163 | 69163 | 2020-04-18 | Clark | Ohio | 39023 | 26 | 0 |
71930 | 71930 | 2020-04-19 | Clark | Ohio | 39023 | 25 | 0 |
74705 | 74705 | 2020-04-20 | Clark | Ohio | 39023 | 26 | 0 |
77486 | 77486 | 2020-04-21 | Clark | Ohio | 39023 | 28 | 0 |
80276 | 80276 | 2020-04-22 | Clark | Ohio | 39023 | 28 | 0 |
83075 | 83075 | 2020-04-23 | Clark | Ohio | 39023 | 29 | 1 |
85879 | 85879 | 2020-04-24 | Clark | Ohio | 39023 | 30 | 1 |
88693 | 88693 | 2020-04-25 | Clark | Ohio | 39023 | 32 | 1 |
91509 | 91509 | 2020-04-26 | Clark | Ohio | 39023 | 33 | 2 |
94335 | 94335 | 2020-04-27 | Clark | Ohio | 39023 | 43 | 2 |
97172 | 97172 | 2020-04-28 | Clark | Ohio | 39023 | 48 | 2 |
100021 | 100021 | 2020-04-29 | Clark | Ohio | 39023 | 51 | 2 |
102874 | 102874 | 2020-04-30 | Clark | Ohio | 39023 | 57 | 2 |
105737 | 105737 | 2020-05-01 | Clark | Ohio | 39023 | 57 | 2 |
108604 | 108604 | 2020-05-02 | Clark | Ohio | 39023 | 63 | 2 |
111478 | 111478 | 2020-05-03 | Clark | Ohio | 39023 | 67 | 2 |
114359 | 114359 | 2020-05-04 | Clark | Ohio | 39023 | 70 | 2 |
117240 | 117240 | 2020-05-05 | Clark | Ohio | 39023 | 69 | 2 |
120201 | 120201 | 2020-05-06 | Clark | Ohio | 39023 | 71 | 2 |
123178 | 123178 | 2020-05-07 | Clark | Ohio | 39023 | 74 | 2 |
126161 | 126161 | 2020-05-08 | Clark | Ohio | 39023 | 80 | 2 |
129150 | 129150 | 2020-05-09 | Clark | Ohio | 39023 | 90 | 3 |
132139 | 132139 | 2020-05-10 | Clark | Ohio | 39023 | 93 | 3 |
135130 | 135130 | 2020-05-11 | Clark | Ohio | 39023 | 98 | 3 |
138120 | 138120 | 2020-05-12 | Clark | Ohio | 39023 | 104 | 3 |
141116 | 141116 | 2020-05-13 | Clark | Ohio | 39023 | 114 | 3 |
144111 | 144111 | 2020-05-14 | Clark | Ohio | 39023 | 122 | 3 |
147112 | 147112 | 2020-05-15 | Clark | Ohio | 39023 | 131 | 3 |
150119 | 150119 | 2020-05-16 | Clark | Ohio | 39023 | 138 | 3 |
153130 | 153130 | 2020-05-17 | Clark | Ohio | 39023 | 139 | 3 |
156147 | 156147 | 2020-05-18 | Clark | Ohio | 39023 | 148 | 3 |
159167 | 159167 | 2020-05-19 | Clark | Ohio | 39023 | 155 | 4 |
162194 | 162194 | 2020-05-20 | Clark | Ohio | 39023 | 166 | 4 |
165223 | 165223 | 2020-05-21 | Clark | Ohio | 39023 | 178 | 4 |
168259 | 168259 | 2020-05-22 | Clark | Ohio | 39023 | 184 | 5 |
171298 | 171298 | 2020-05-23 | Clark | Ohio | 39023 | 195 | 6 |
174340 | 174340 | 2020-05-24 | Clark | Ohio | 39023 | 206 | 6 |
177384 | 177384 | 2020-05-25 | Clark | Ohio | 39023 | 223 | 6 |
180427 | 180427 | 2020-05-26 | Clark | Ohio | 39023 | 225 | 6 |
183476 | 183476 | 2020-05-27 | Clark | Ohio | 39023 | 231 | 6 |
186533 | 186533 | 2020-05-28 | Clark | Ohio | 39023 | 234 | 5 |
189593 | 189593 | 2020-05-29 | Clark | Ohio | 39023 | 252 | 6 |
192657 | 192657 | 2020-05-30 | Clark | Ohio | 39023 | 277 | 6 |
195727 | 195727 | 2020-05-31 | Clark | Ohio | 39023 | 285 | 6 |
198800 | 198800 | 2020-06-01 | Clark | Ohio | 39023 | 295 | 6 |
201875 | 201875 | 2020-06-02 | Clark | Ohio | 39023 | 298 | 7 |
204952 | 204952 | 2020-06-03 | Clark | Ohio | 39023 | 306 | 7 |
208033 | 208033 | 2020-06-04 | Clark | Ohio | 39023 | 313 | 7 |
211115 | 211115 | 2020-06-05 | Clark | Ohio | 39023 | 323 | 7 |
214201 | 214201 | 2020-06-06 | Clark | Ohio | 39023 | 336 | 8 |
217291 | 217291 | 2020-06-07 | Clark | Ohio | 39023 | 355 | 8 |
220383 | 220383 | 2020-06-08 | Clark | Ohio | 39023 | 371 | 8 |
223478 | 223478 | 2020-06-09 | Clark | Ohio | 39023 | 377 | 8 |
226578 | 226578 | 2020-06-10 | Clark | Ohio | 39023 | 384 | 8 |
229682 | 229682 | 2020-06-11 | Clark | Ohio | 39023 | 394 | 8 |
232787 | 232787 | 2020-06-12 | Clark | Ohio | 39023 | 400 | 8 |
235892 | 235892 | 2020-06-13 | Clark | Ohio | 39023 | 403 | 8 |
239000 | 239000 | 2020-06-14 | Clark | Ohio | 39023 | 409 | 8 |
242109 | 242109 | 2020-06-15 | Clark | Ohio | 39023 | 425 | 8 |
245221 | 245221 | 2020-06-16 | Clark | Ohio | 39023 | 460 | 8 |
248334 | 248334 | 2020-06-17 | Clark | Ohio | 39023 | 502 | 8 |
251449 | 251449 | 2020-06-18 | Clark | Ohio | 39023 | 568 | 8 |
254564 | 254564 | 2020-06-19 | Clark | Ohio | 39023 | 606 | 8 |
257689 | 257689 | 2020-06-20 | Clark | Ohio | 39023 | 639 | 8 |
260816 | 260816 | 2020-06-21 | Clark | Ohio | 39023 | 653 | 8 |
263944 | 263944 | 2020-06-22 | Clark | Ohio | 39023 | 670 | 8 |
267072 | 267072 | 2020-06-23 | Clark | Ohio | 39023 | 688 | 8 |
270206 | 270206 | 2020-06-24 | Clark | Ohio | 39023 | 697 | 8 |
273345 | 273345 | 2020-06-25 | Clark | Ohio | 39023 | 703 | 8 |
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);