ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 39041 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
295397 | 295397 | 2020-07-02 | Delaware | Ohio | 39041 | 518 | 15 |
292242 | 292242 | 2020-07-01 | Delaware | Ohio | 39041 | 518 | 15 |
289090 | 289090 | 2020-06-30 | Delaware | Ohio | 39041 | 494 | 15 |
285940 | 285940 | 2020-06-29 | Delaware | Ohio | 39041 | 482 | 15 |
282795 | 282795 | 2020-06-28 | Delaware | Ohio | 39041 | 471 | 15 |
279649 | 279649 | 2020-06-27 | Delaware | Ohio | 39041 | 461 | 15 |
276501 | 276501 | 2020-06-26 | Delaware | Ohio | 39041 | 458 | 15 |
273354 | 273354 | 2020-06-25 | Delaware | Ohio | 39041 | 449 | 15 |
270215 | 270215 | 2020-06-24 | Delaware | Ohio | 39041 | 441 | 15 |
267081 | 267081 | 2020-06-23 | Delaware | Ohio | 39041 | 439 | 15 |
263953 | 263953 | 2020-06-22 | Delaware | Ohio | 39041 | 433 | 15 |
260825 | 260825 | 2020-06-21 | Delaware | Ohio | 39041 | 427 | 15 |
257698 | 257698 | 2020-06-20 | Delaware | Ohio | 39041 | 419 | 15 |
254573 | 254573 | 2020-06-19 | Delaware | Ohio | 39041 | 412 | 15 |
251458 | 251458 | 2020-06-18 | Delaware | Ohio | 39041 | 410 | 15 |
248343 | 248343 | 2020-06-17 | Delaware | Ohio | 39041 | 403 | 15 |
245230 | 245230 | 2020-06-16 | Delaware | Ohio | 39041 | 403 | 15 |
242118 | 242118 | 2020-06-15 | Delaware | Ohio | 39041 | 402 | 15 |
239009 | 239009 | 2020-06-14 | Delaware | Ohio | 39041 | 398 | 15 |
235901 | 235901 | 2020-06-13 | Delaware | Ohio | 39041 | 394 | 15 |
232796 | 232796 | 2020-06-12 | Delaware | Ohio | 39041 | 389 | 15 |
229691 | 229691 | 2020-06-11 | Delaware | Ohio | 39041 | 387 | 14 |
226587 | 226587 | 2020-06-10 | Delaware | Ohio | 39041 | 384 | 14 |
223487 | 223487 | 2020-06-09 | Delaware | Ohio | 39041 | 378 | 14 |
220392 | 220392 | 2020-06-08 | Delaware | Ohio | 39041 | 369 | 14 |
217300 | 217300 | 2020-06-07 | Delaware | Ohio | 39041 | 368 | 14 |
214210 | 214210 | 2020-06-06 | Delaware | Ohio | 39041 | 366 | 14 |
211124 | 211124 | 2020-06-05 | Delaware | Ohio | 39041 | 360 | 14 |
208042 | 208042 | 2020-06-04 | Delaware | Ohio | 39041 | 355 | 14 |
204961 | 204961 | 2020-06-03 | Delaware | Ohio | 39041 | 344 | 14 |
201884 | 201884 | 2020-06-02 | Delaware | Ohio | 39041 | 340 | 13 |
198809 | 198809 | 2020-06-01 | Delaware | Ohio | 39041 | 337 | 13 |
195736 | 195736 | 2020-05-31 | Delaware | Ohio | 39041 | 337 | 13 |
192666 | 192666 | 2020-05-30 | Delaware | Ohio | 39041 | 331 | 13 |
189602 | 189602 | 2020-05-29 | Delaware | Ohio | 39041 | 320 | 13 |
186542 | 186542 | 2020-05-28 | Delaware | Ohio | 39041 | 310 | 13 |
183485 | 183485 | 2020-05-27 | Delaware | Ohio | 39041 | 302 | 13 |
180436 | 180436 | 2020-05-26 | Delaware | Ohio | 39041 | 302 | 13 |
177393 | 177393 | 2020-05-25 | Delaware | Ohio | 39041 | 300 | 13 |
174349 | 174349 | 2020-05-24 | Delaware | Ohio | 39041 | 296 | 13 |
171307 | 171307 | 2020-05-23 | Delaware | Ohio | 39041 | 292 | 11 |
168268 | 168268 | 2020-05-22 | Delaware | Ohio | 39041 | 282 | 11 |
165232 | 165232 | 2020-05-21 | Delaware | Ohio | 39041 | 280 | 11 |
162203 | 162203 | 2020-05-20 | Delaware | Ohio | 39041 | 277 | 10 |
159176 | 159176 | 2020-05-19 | Delaware | Ohio | 39041 | 266 | 9 |
156156 | 156156 | 2020-05-18 | Delaware | Ohio | 39041 | 263 | 9 |
153139 | 153139 | 2020-05-17 | Delaware | Ohio | 39041 | 258 | 5 |
150128 | 150128 | 2020-05-16 | Delaware | Ohio | 39041 | 257 | 5 |
147121 | 147121 | 2020-05-15 | Delaware | Ohio | 39041 | 241 | 5 |
144120 | 144120 | 2020-05-14 | Delaware | Ohio | 39041 | 240 | 4 |
141125 | 141125 | 2020-05-13 | Delaware | Ohio | 39041 | 234 | 4 |
138129 | 138129 | 2020-05-12 | Delaware | Ohio | 39041 | 232 | 4 |
135139 | 135139 | 2020-05-11 | Delaware | Ohio | 39041 | 222 | 4 |
132148 | 132148 | 2020-05-10 | Delaware | Ohio | 39041 | 220 | 4 |
129159 | 129159 | 2020-05-09 | Delaware | Ohio | 39041 | 211 | 4 |
126170 | 126170 | 2020-05-08 | Delaware | Ohio | 39041 | 199 | 4 |
123187 | 123187 | 2020-05-07 | Delaware | Ohio | 39041 | 196 | 4 |
120210 | 120210 | 2020-05-06 | Delaware | Ohio | 39041 | 190 | 4 |
117249 | 117249 | 2020-05-05 | Delaware | Ohio | 39041 | 184 | 4 |
114368 | 114368 | 2020-05-04 | Delaware | Ohio | 39041 | 179 | 4 |
111487 | 111487 | 2020-05-03 | Delaware | Ohio | 39041 | 175 | 4 |
108613 | 108613 | 2020-05-02 | Delaware | Ohio | 39041 | 168 | 4 |
105746 | 105746 | 2020-05-01 | Delaware | Ohio | 39041 | 163 | 4 |
102883 | 102883 | 2020-04-30 | Delaware | Ohio | 39041 | 160 | 4 |
100030 | 100030 | 2020-04-29 | Delaware | Ohio | 39041 | 153 | 4 |
97181 | 97181 | 2020-04-28 | Delaware | Ohio | 39041 | 151 | 3 |
94344 | 94344 | 2020-04-27 | Delaware | Ohio | 39041 | 148 | 3 |
91518 | 91518 | 2020-04-26 | Delaware | Ohio | 39041 | 143 | 3 |
88702 | 88702 | 2020-04-25 | Delaware | Ohio | 39041 | 138 | 3 |
85888 | 85888 | 2020-04-24 | Delaware | Ohio | 39041 | 137 | 3 |
83084 | 83084 | 2020-04-23 | Delaware | Ohio | 39041 | 132 | 3 |
80285 | 80285 | 2020-04-22 | Delaware | Ohio | 39041 | 128 | 3 |
77495 | 77495 | 2020-04-21 | Delaware | Ohio | 39041 | 127 | 3 |
74714 | 74714 | 2020-04-20 | Delaware | Ohio | 39041 | 122 | 3 |
71939 | 71939 | 2020-04-19 | Delaware | Ohio | 39041 | 123 | 3 |
69172 | 69172 | 2020-04-18 | Delaware | Ohio | 39041 | 119 | 3 |
66415 | 66415 | 2020-04-17 | Delaware | Ohio | 39041 | 119 | 3 |
63672 | 63672 | 2020-04-16 | Delaware | Ohio | 39041 | 114 | 3 |
60946 | 60946 | 2020-04-15 | Delaware | Ohio | 39041 | 108 | 3 |
58232 | 58232 | 2020-04-14 | Delaware | Ohio | 39041 | 99 | 2 |
55531 | 55531 | 2020-04-13 | Delaware | Ohio | 39041 | 96 | 2 |
52847 | 52847 | 2020-04-12 | Delaware | Ohio | 39041 | 94 | 2 |
50174 | 50174 | 2020-04-11 | Delaware | Ohio | 39041 | 89 | 2 |
47519 | 47519 | 2020-04-10 | Delaware | Ohio | 39041 | 88 | 2 |
44904 | 44904 | 2020-04-09 | Delaware | Ohio | 39041 | 84 | 2 |
42319 | 42319 | 2020-04-08 | Delaware | Ohio | 39041 | 79 | 1 |
39761 | 39761 | 2020-04-07 | Delaware | Ohio | 39041 | 77 | 1 |
37244 | 37244 | 2020-04-06 | Delaware | Ohio | 39041 | 77 | 1 |
34775 | 34775 | 2020-04-05 | Delaware | Ohio | 39041 | 70 | 1 |
32342 | 32342 | 2020-04-04 | Delaware | Ohio | 39041 | 69 | 1 |
29953 | 29953 | 2020-04-03 | Delaware | Ohio | 39041 | 61 | 1 |
27624 | 27624 | 2020-04-02 | Delaware | Ohio | 39041 | 50 | 1 |
25358 | 25358 | 2020-04-01 | Delaware | Ohio | 39041 | 47 | 1 |
23163 | 23163 | 2020-03-31 | Delaware | Ohio | 39041 | 40 | 1 |
21031 | 21031 | 2020-03-30 | Delaware | Ohio | 39041 | 38 | 1 |
18987 | 18987 | 2020-03-29 | Delaware | Ohio | 39041 | 31 | 0 |
17053 | 17053 | 2020-03-28 | Delaware | Ohio | 39041 | 26 | 0 |
15211 | 15211 | 2020-03-27 | Delaware | Ohio | 39041 | 22 | 0 |
13474 | 13474 | 2020-03-26 | Delaware | Ohio | 39041 | 15 | 0 |
11867 | 11867 | 2020-03-25 | Delaware | Ohio | 39041 | 12 | 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);