ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Delaware" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536496 | 536496 | 2020-09-15 | Delaware | Ohio | 39041 | 2022 | 20 |
533260 | 533260 | 2020-09-14 | Delaware | Ohio | 39041 | 1985 | 20 |
530025 | 530025 | 2020-09-13 | Delaware | Ohio | 39041 | 1967 | 20 |
526788 | 526788 | 2020-09-12 | Delaware | Ohio | 39041 | 1946 | 20 |
523552 | 523552 | 2020-09-11 | Delaware | Ohio | 39041 | 1905 | 21 |
520316 | 520316 | 2020-09-10 | Delaware | Ohio | 39041 | 1857 | 20 |
517080 | 517080 | 2020-09-09 | Delaware | Ohio | 39041 | 1824 | 20 |
513845 | 513845 | 2020-09-08 | Delaware | Ohio | 39041 | 1802 | 20 |
510612 | 510612 | 2020-09-07 | Delaware | Ohio | 39041 | 1798 | 20 |
507379 | 507379 | 2020-09-06 | Delaware | Ohio | 39041 | 1778 | 20 |
504147 | 504147 | 2020-09-05 | Delaware | Ohio | 39041 | 1771 | 20 |
500913 | 500913 | 2020-09-04 | Delaware | Ohio | 39041 | 1748 | 20 |
497679 | 497679 | 2020-09-03 | Delaware | Ohio | 39041 | 1725 | 20 |
494446 | 494446 | 2020-09-02 | Delaware | Ohio | 39041 | 1688 | 20 |
491212 | 491212 | 2020-09-01 | Delaware | Ohio | 39041 | 1674 | 20 |
487979 | 487979 | 2020-08-31 | Delaware | Ohio | 39041 | 1651 | 20 |
484746 | 484746 | 2020-08-30 | Delaware | Ohio | 39041 | 1645 | 20 |
481511 | 481511 | 2020-08-29 | Delaware | Ohio | 39041 | 1629 | 20 |
478277 | 478277 | 2020-08-28 | Delaware | Ohio | 39041 | 1606 | 20 |
475044 | 475044 | 2020-08-27 | Delaware | Ohio | 39041 | 1580 | 20 |
471810 | 471810 | 2020-08-26 | Delaware | Ohio | 39041 | 1565 | 20 |
468578 | 468578 | 2020-08-25 | Delaware | Ohio | 39041 | 1546 | 20 |
465350 | 465350 | 2020-08-24 | Delaware | Ohio | 39041 | 1527 | 20 |
462121 | 462121 | 2020-08-23 | Delaware | Ohio | 39041 | 1516 | 20 |
458893 | 458893 | 2020-08-22 | Delaware | Ohio | 39041 | 1504 | 20 |
455665 | 455665 | 2020-08-21 | Delaware | Ohio | 39041 | 1483 | 20 |
452437 | 452437 | 2020-08-20 | Delaware | Ohio | 39041 | 1469 | 19 |
449209 | 449209 | 2020-08-19 | Delaware | Ohio | 39041 | 1457 | 19 |
445981 | 445981 | 2020-08-18 | Delaware | Ohio | 39041 | 1441 | 19 |
442755 | 442755 | 2020-08-17 | Delaware | Ohio | 39041 | 1434 | 19 |
439528 | 439528 | 2020-08-16 | Delaware | Ohio | 39041 | 1412 | 19 |
436303 | 436303 | 2020-08-15 | Delaware | Ohio | 39041 | 1404 | 19 |
433077 | 433077 | 2020-08-14 | Delaware | Ohio | 39041 | 1392 | 19 |
429851 | 429851 | 2020-08-13 | Delaware | Ohio | 39041 | 1378 | 19 |
426626 | 426626 | 2020-08-12 | Delaware | Ohio | 39041 | 1365 | 19 |
423403 | 423403 | 2020-08-11 | Delaware | Ohio | 39041 | 1344 | 19 |
420180 | 420180 | 2020-08-10 | Delaware | Ohio | 39041 | 1316 | 19 |
416960 | 416960 | 2020-08-09 | Delaware | Ohio | 39041 | 1301 | 19 |
413739 | 413739 | 2020-08-08 | Delaware | Ohio | 39041 | 1292 | 19 |
410519 | 410519 | 2020-08-07 | Delaware | Ohio | 39041 | 1273 | 19 |
407299 | 407299 | 2020-08-06 | Delaware | Ohio | 39041 | 1263 | 19 |
404080 | 404080 | 2020-08-05 | Delaware | Ohio | 39041 | 1241 | 18 |
400862 | 400862 | 2020-08-04 | Delaware | Ohio | 39041 | 1219 | 18 |
397647 | 397647 | 2020-08-03 | Delaware | Ohio | 39041 | 1206 | 18 |
394430 | 394430 | 2020-08-02 | Delaware | Ohio | 39041 | 1194 | 18 |
391214 | 391214 | 2020-08-01 | Delaware | Ohio | 39041 | 1180 | 18 |
387997 | 387997 | 2020-07-31 | Delaware | Ohio | 39041 | 1168 | 18 |
384780 | 384780 | 2020-07-30 | Delaware | Ohio | 39041 | 1141 | 17 |
381562 | 381562 | 2020-07-29 | Delaware | Ohio | 39041 | 1112 | 17 |
378345 | 378345 | 2020-07-28 | Delaware | Ohio | 39041 | 1095 | 17 |
375128 | 375128 | 2020-07-27 | Delaware | Ohio | 39041 | 1073 | 17 |
371916 | 371916 | 2020-07-26 | Delaware | Ohio | 39041 | 1060 | 17 |
368704 | 368704 | 2020-07-25 | Delaware | Ohio | 39041 | 1048 | 17 |
365495 | 365495 | 2020-07-24 | Delaware | Ohio | 39041 | 1024 | 17 |
362289 | 362289 | 2020-07-23 | Delaware | Ohio | 39041 | 991 | 16 |
359083 | 359083 | 2020-07-22 | Delaware | Ohio | 39041 | 977 | 15 |
355879 | 355879 | 2020-07-21 | Delaware | Ohio | 39041 | 959 | 15 |
352676 | 352676 | 2020-07-20 | Delaware | Ohio | 39041 | 940 | 15 |
349473 | 349473 | 2020-07-19 | Delaware | Ohio | 39041 | 916 | 15 |
346272 | 346272 | 2020-07-18 | Delaware | Ohio | 39041 | 902 | 15 |
343073 | 343073 | 2020-07-17 | Delaware | Ohio | 39041 | 871 | 15 |
339875 | 339875 | 2020-07-16 | Delaware | Ohio | 39041 | 829 | 15 |
336679 | 336679 | 2020-07-15 | Delaware | Ohio | 39041 | 806 | 15 |
333485 | 333485 | 2020-07-14 | Delaware | Ohio | 39041 | 784 | 15 |
330293 | 330293 | 2020-07-13 | Delaware | Ohio | 39041 | 763 | 15 |
327106 | 327106 | 2020-07-12 | Delaware | Ohio | 39041 | 724 | 15 |
323921 | 323921 | 2020-07-11 | Delaware | Ohio | 39041 | 698 | 15 |
320741 | 320741 | 2020-07-10 | Delaware | Ohio | 39041 | 675 | 15 |
317564 | 317564 | 2020-07-09 | Delaware | Ohio | 39041 | 645 | 15 |
314391 | 314391 | 2020-07-08 | Delaware | Ohio | 39041 | 617 | 15 |
311219 | 311219 | 2020-07-07 | Delaware | Ohio | 39041 | 588 | 15 |
308050 | 308050 | 2020-07-06 | Delaware | Ohio | 39041 | 582 | 15 |
304883 | 304883 | 2020-07-05 | Delaware | Ohio | 39041 | 568 | 15 |
301720 | 301720 | 2020-07-04 | Delaware | Ohio | 39041 | 553 | 15 |
298557 | 298557 | 2020-07-03 | Delaware | Ohio | 39041 | 541 | 15 |
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 |
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);