ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Wayne" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388061 | 388061 | 2020-07-31 | Wayne | Ohio | 39169 | 485 | 58 |
384844 | 384844 | 2020-07-30 | Wayne | Ohio | 39169 | 472 | 58 |
381626 | 381626 | 2020-07-29 | Wayne | Ohio | 39169 | 463 | 58 |
378409 | 378409 | 2020-07-28 | Wayne | Ohio | 39169 | 452 | 58 |
375192 | 375192 | 2020-07-27 | Wayne | Ohio | 39169 | 447 | 58 |
371980 | 371980 | 2020-07-26 | Wayne | Ohio | 39169 | 446 | 58 |
368768 | 368768 | 2020-07-25 | Wayne | Ohio | 39169 | 443 | 58 |
365559 | 365559 | 2020-07-24 | Wayne | Ohio | 39169 | 432 | 57 |
362353 | 362353 | 2020-07-23 | Wayne | Ohio | 39169 | 421 | 57 |
359147 | 359147 | 2020-07-22 | Wayne | Ohio | 39169 | 418 | 57 |
355943 | 355943 | 2020-07-21 | Wayne | Ohio | 39169 | 412 | 57 |
352740 | 352740 | 2020-07-20 | Wayne | Ohio | 39169 | 405 | 57 |
349537 | 349537 | 2020-07-19 | Wayne | Ohio | 39169 | 400 | 56 |
346337 | 346337 | 2020-07-18 | Wayne | Ohio | 39169 | 399 | 56 |
343137 | 343137 | 2020-07-17 | Wayne | Ohio | 39169 | 393 | 56 |
339939 | 339939 | 2020-07-16 | Wayne | Ohio | 39169 | 387 | 56 |
336743 | 336743 | 2020-07-15 | Wayne | Ohio | 39169 | 384 | 56 |
333549 | 333549 | 2020-07-14 | Wayne | Ohio | 39169 | 378 | 56 |
330357 | 330357 | 2020-07-13 | Wayne | Ohio | 39169 | 376 | 55 |
327170 | 327170 | 2020-07-12 | Wayne | Ohio | 39169 | 373 | 55 |
323985 | 323985 | 2020-07-11 | Wayne | Ohio | 39169 | 372 | 53 |
320805 | 320805 | 2020-07-10 | Wayne | Ohio | 39169 | 372 | 53 |
317628 | 317628 | 2020-07-09 | Wayne | Ohio | 39169 | 367 | 52 |
314455 | 314455 | 2020-07-08 | Wayne | Ohio | 39169 | 365 | 52 |
311283 | 311283 | 2020-07-07 | Wayne | Ohio | 39169 | 363 | 52 |
308114 | 308114 | 2020-07-06 | Wayne | Ohio | 39169 | 363 | 51 |
304947 | 304947 | 2020-07-05 | Wayne | Ohio | 39169 | 362 | 51 |
301784 | 301784 | 2020-07-04 | Wayne | Ohio | 39169 | 360 | 51 |
298621 | 298621 | 2020-07-03 | Wayne | Ohio | 39169 | 359 | 51 |
295462 | 295462 | 2020-07-02 | Wayne | Ohio | 39169 | 354 | 52 |
292306 | 292306 | 2020-07-01 | Wayne | Ohio | 39169 | 354 | 52 |
289154 | 289154 | 2020-06-30 | Wayne | Ohio | 39169 | 353 | 52 |
286004 | 286004 | 2020-06-29 | Wayne | Ohio | 39169 | 352 | 52 |
282859 | 282859 | 2020-06-28 | Wayne | Ohio | 39169 | 350 | 52 |
279713 | 279713 | 2020-06-27 | Wayne | Ohio | 39169 | 348 | 52 |
276565 | 276565 | 2020-06-26 | Wayne | Ohio | 39169 | 346 | 52 |
273418 | 273418 | 2020-06-25 | Wayne | Ohio | 39169 | 343 | 52 |
270279 | 270279 | 2020-06-24 | Wayne | Ohio | 39169 | 338 | 52 |
267145 | 267145 | 2020-06-23 | Wayne | Ohio | 39169 | 332 | 52 |
264017 | 264017 | 2020-06-22 | Wayne | Ohio | 39169 | 330 | 52 |
260889 | 260889 | 2020-06-21 | Wayne | Ohio | 39169 | 327 | 52 |
257763 | 257763 | 2020-06-20 | Wayne | Ohio | 39169 | 323 | 52 |
254637 | 254637 | 2020-06-19 | Wayne | Ohio | 39169 | 321 | 52 |
251522 | 251522 | 2020-06-18 | Wayne | Ohio | 39169 | 316 | 52 |
248407 | 248407 | 2020-06-17 | Wayne | Ohio | 39169 | 313 | 52 |
245294 | 245294 | 2020-06-16 | Wayne | Ohio | 39169 | 311 | 52 |
242182 | 242182 | 2020-06-15 | Wayne | Ohio | 39169 | 308 | 52 |
239073 | 239073 | 2020-06-14 | Wayne | Ohio | 39169 | 306 | 52 |
235965 | 235965 | 2020-06-13 | Wayne | Ohio | 39169 | 304 | 52 |
232860 | 232860 | 2020-06-12 | Wayne | Ohio | 39169 | 304 | 52 |
229755 | 229755 | 2020-06-11 | Wayne | Ohio | 39169 | 304 | 52 |
226651 | 226651 | 2020-06-10 | Wayne | Ohio | 39169 | 302 | 52 |
223551 | 223551 | 2020-06-09 | Wayne | Ohio | 39169 | 301 | 51 |
220456 | 220456 | 2020-06-08 | Wayne | Ohio | 39169 | 300 | 51 |
217364 | 217364 | 2020-06-07 | Wayne | Ohio | 39169 | 298 | 51 |
214274 | 214274 | 2020-06-06 | Wayne | Ohio | 39169 | 296 | 51 |
211188 | 211188 | 2020-06-05 | Wayne | Ohio | 39169 | 296 | 51 |
208106 | 208106 | 2020-06-04 | Wayne | Ohio | 39169 | 293 | 51 |
205025 | 205025 | 2020-06-03 | Wayne | Ohio | 39169 | 288 | 51 |
201948 | 201948 | 2020-06-02 | Wayne | Ohio | 39169 | 281 | 51 |
198873 | 198873 | 2020-06-01 | Wayne | Ohio | 39169 | 277 | 50 |
195800 | 195800 | 2020-05-31 | Wayne | Ohio | 39169 | 274 | 50 |
192731 | 192731 | 2020-05-30 | Wayne | Ohio | 39169 | 272 | 50 |
189666 | 189666 | 2020-05-29 | Wayne | Ohio | 39169 | 266 | 50 |
186606 | 186606 | 2020-05-28 | Wayne | Ohio | 39169 | 260 | 49 |
183549 | 183549 | 2020-05-27 | Wayne | Ohio | 39169 | 256 | 50 |
180500 | 180500 | 2020-05-26 | Wayne | Ohio | 39169 | 252 | 50 |
177457 | 177457 | 2020-05-25 | Wayne | Ohio | 39169 | 250 | 50 |
174413 | 174413 | 2020-05-24 | Wayne | Ohio | 39169 | 248 | 50 |
171371 | 171371 | 2020-05-23 | Wayne | Ohio | 39169 | 248 | 50 |
168332 | 168332 | 2020-05-22 | Wayne | Ohio | 39169 | 242 | 50 |
165296 | 165296 | 2020-05-21 | Wayne | Ohio | 39169 | 211 | 49 |
162267 | 162267 | 2020-05-20 | Wayne | Ohio | 39169 | 209 | 49 |
159240 | 159240 | 2020-05-19 | Wayne | Ohio | 39169 | 206 | 49 |
156220 | 156220 | 2020-05-18 | Wayne | Ohio | 39169 | 202 | 48 |
153203 | 153203 | 2020-05-17 | Wayne | Ohio | 39169 | 201 | 48 |
150192 | 150192 | 2020-05-16 | Wayne | Ohio | 39169 | 200 | 48 |
147185 | 147185 | 2020-05-15 | Wayne | Ohio | 39169 | 198 | 48 |
144184 | 144184 | 2020-05-14 | Wayne | Ohio | 39169 | 194 | 48 |
141189 | 141189 | 2020-05-13 | Wayne | Ohio | 39169 | 192 | 47 |
138193 | 138193 | 2020-05-12 | Wayne | Ohio | 39169 | 190 | 47 |
135203 | 135203 | 2020-05-11 | Wayne | Ohio | 39169 | 188 | 42 |
132212 | 132212 | 2020-05-10 | Wayne | Ohio | 39169 | 188 | 42 |
129223 | 129223 | 2020-05-09 | Wayne | Ohio | 39169 | 188 | 42 |
126234 | 126234 | 2020-05-08 | Wayne | Ohio | 39169 | 183 | 42 |
123251 | 123251 | 2020-05-07 | Wayne | Ohio | 39169 | 177 | 41 |
120274 | 120274 | 2020-05-06 | Wayne | Ohio | 39169 | 173 | 36 |
117313 | 117313 | 2020-05-05 | Wayne | Ohio | 39169 | 166 | 33 |
114432 | 114432 | 2020-05-04 | Wayne | Ohio | 39169 | 161 | 33 |
111551 | 111551 | 2020-05-03 | Wayne | Ohio | 39169 | 153 | 32 |
108677 | 108677 | 2020-05-02 | Wayne | Ohio | 39169 | 149 | 32 |
105810 | 105810 | 2020-05-01 | Wayne | Ohio | 39169 | 143 | 30 |
102947 | 102947 | 2020-04-30 | Wayne | Ohio | 39169 | 128 | 28 |
100094 | 100094 | 2020-04-29 | Wayne | Ohio | 39169 | 125 | 24 |
97245 | 97245 | 2020-04-28 | Wayne | Ohio | 39169 | 119 | 23 |
94407 | 94407 | 2020-04-27 | Wayne | Ohio | 39169 | 114 | 22 |
91581 | 91581 | 2020-04-26 | Wayne | Ohio | 39169 | 104 | 21 |
88765 | 88765 | 2020-04-25 | Wayne | Ohio | 39169 | 100 | 20 |
85951 | 85951 | 2020-04-24 | Wayne | Ohio | 39169 | 91 | 18 |
83147 | 83147 | 2020-04-23 | Wayne | Ohio | 39169 | 88 | 18 |
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);