ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Madison" and state = "Ohio" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
292270 | 292270 | 2020-07-01 | Madison | Ohio | 39097 | 188 | 8 |
295425 | 295425 | 2020-07-02 | Madison | Ohio | 39097 | 188 | 8 |
298585 | 298585 | 2020-07-03 | Madison | Ohio | 39097 | 192 | 8 |
301748 | 301748 | 2020-07-04 | Madison | Ohio | 39097 | 193 | 8 |
304911 | 304911 | 2020-07-05 | Madison | Ohio | 39097 | 195 | 8 |
308078 | 308078 | 2020-07-06 | Madison | Ohio | 39097 | 197 | 8 |
311247 | 311247 | 2020-07-07 | Madison | Ohio | 39097 | 199 | 9 |
314419 | 314419 | 2020-07-08 | Madison | Ohio | 39097 | 202 | 9 |
317592 | 317592 | 2020-07-09 | Madison | Ohio | 39097 | 206 | 9 |
320769 | 320769 | 2020-07-10 | Madison | Ohio | 39097 | 213 | 9 |
323949 | 323949 | 2020-07-11 | Madison | Ohio | 39097 | 216 | 9 |
327134 | 327134 | 2020-07-12 | Madison | Ohio | 39097 | 222 | 9 |
330321 | 330321 | 2020-07-13 | Madison | Ohio | 39097 | 225 | 9 |
333513 | 333513 | 2020-07-14 | Madison | Ohio | 39097 | 230 | 9 |
336707 | 336707 | 2020-07-15 | Madison | Ohio | 39097 | 233 | 9 |
339903 | 339903 | 2020-07-16 | Madison | Ohio | 39097 | 237 | 9 |
343101 | 343101 | 2020-07-17 | Madison | Ohio | 39097 | 244 | 9 |
346300 | 346300 | 2020-07-18 | Madison | Ohio | 39097 | 244 | 9 |
349501 | 349501 | 2020-07-19 | Madison | Ohio | 39097 | 245 | 9 |
352704 | 352704 | 2020-07-20 | Madison | Ohio | 39097 | 253 | 9 |
355907 | 355907 | 2020-07-21 | Madison | Ohio | 39097 | 257 | 9 |
359111 | 359111 | 2020-07-22 | Madison | Ohio | 39097 | 259 | 9 |
362317 | 362317 | 2020-07-23 | Madison | Ohio | 39097 | 262 | 9 |
365523 | 365523 | 2020-07-24 | Madison | Ohio | 39097 | 266 | 9 |
368732 | 368732 | 2020-07-25 | Madison | Ohio | 39097 | 271 | 9 |
371944 | 371944 | 2020-07-26 | Madison | Ohio | 39097 | 271 | 9 |
375156 | 375156 | 2020-07-27 | Madison | Ohio | 39097 | 276 | 9 |
378373 | 378373 | 2020-07-28 | Madison | Ohio | 39097 | 285 | 9 |
381590 | 381590 | 2020-07-29 | Madison | Ohio | 39097 | 299 | 9 |
384808 | 384808 | 2020-07-30 | Madison | Ohio | 39097 | 308 | 9 |
388025 | 388025 | 2020-07-31 | Madison | Ohio | 39097 | 313 | 10 |
391242 | 391242 | 2020-08-01 | Madison | Ohio | 39097 | 322 | 10 |
394458 | 394458 | 2020-08-02 | Madison | Ohio | 39097 | 329 | 10 |
397675 | 397675 | 2020-08-03 | Madison | Ohio | 39097 | 333 | 10 |
400890 | 400890 | 2020-08-04 | Madison | Ohio | 39097 | 336 | 10 |
404108 | 404108 | 2020-08-05 | Madison | Ohio | 39097 | 343 | 10 |
407327 | 407327 | 2020-08-06 | Madison | Ohio | 39097 | 349 | 10 |
410547 | 410547 | 2020-08-07 | Madison | Ohio | 39097 | 353 | 10 |
413767 | 413767 | 2020-08-08 | Madison | Ohio | 39097 | 355 | 10 |
416988 | 416988 | 2020-08-09 | Madison | Ohio | 39097 | 374 | 10 |
420208 | 420208 | 2020-08-10 | Madison | Ohio | 39097 | 388 | 10 |
423431 | 423431 | 2020-08-11 | Madison | Ohio | 39097 | 401 | 10 |
426654 | 426654 | 2020-08-12 | Madison | Ohio | 39097 | 503 | 10 |
429879 | 429879 | 2020-08-13 | Madison | Ohio | 39097 | 580 | 10 |
433105 | 433105 | 2020-08-14 | Madison | Ohio | 39097 | 587 | 10 |
436331 | 436331 | 2020-08-15 | Madison | Ohio | 39097 | 592 | 10 |
439556 | 439556 | 2020-08-16 | Madison | Ohio | 39097 | 592 | 10 |
442783 | 442783 | 2020-08-17 | Madison | Ohio | 39097 | 595 | 10 |
446009 | 446009 | 2020-08-18 | Madison | Ohio | 39097 | 601 | 11 |
449237 | 449237 | 2020-08-19 | Madison | Ohio | 39097 | 605 | 11 |
452465 | 452465 | 2020-08-20 | Madison | Ohio | 39097 | 628 | 11 |
455693 | 455693 | 2020-08-21 | Madison | Ohio | 39097 | 632 | 11 |
458921 | 458921 | 2020-08-22 | Madison | Ohio | 39097 | 647 | 11 |
462149 | 462149 | 2020-08-23 | Madison | Ohio | 39097 | 649 | 11 |
465378 | 465378 | 2020-08-24 | Madison | Ohio | 39097 | 654 | 11 |
468606 | 468606 | 2020-08-25 | Madison | Ohio | 39097 | 655 | 11 |
471838 | 471838 | 2020-08-26 | Madison | Ohio | 39097 | 662 | 11 |
475072 | 475072 | 2020-08-27 | Madison | Ohio | 39097 | 669 | 11 |
478305 | 478305 | 2020-08-28 | Madison | Ohio | 39097 | 679 | 11 |
481539 | 481539 | 2020-08-29 | Madison | Ohio | 39097 | 688 | 11 |
484774 | 484774 | 2020-08-30 | Madison | Ohio | 39097 | 689 | 11 |
488007 | 488007 | 2020-08-31 | Madison | Ohio | 39097 | 696 | 11 |
491240 | 491240 | 2020-09-01 | Madison | Ohio | 39097 | 704 | 11 |
494474 | 494474 | 2020-09-02 | Madison | Ohio | 39097 | 705 | 11 |
497707 | 497707 | 2020-09-03 | Madison | Ohio | 39097 | 712 | 11 |
500941 | 500941 | 2020-09-04 | Madison | Ohio | 39097 | 718 | 11 |
504175 | 504175 | 2020-09-05 | Madison | Ohio | 39097 | 721 | 11 |
507407 | 507407 | 2020-09-06 | Madison | Ohio | 39097 | 726 | 11 |
510640 | 510640 | 2020-09-07 | Madison | Ohio | 39097 | 727 | 11 |
513873 | 513873 | 2020-09-08 | Madison | Ohio | 39097 | 732 | 11 |
517108 | 517108 | 2020-09-09 | Madison | Ohio | 39097 | 732 | 11 |
520344 | 520344 | 2020-09-10 | Madison | Ohio | 39097 | 737 | 11 |
523580 | 523580 | 2020-09-11 | Madison | Ohio | 39097 | 744 | 11 |
526816 | 526816 | 2020-09-12 | Madison | Ohio | 39097 | 747 | 11 |
530053 | 530053 | 2020-09-13 | Madison | Ohio | 39097 | 747 | 11 |
533288 | 533288 | 2020-09-14 | Madison | Ohio | 39097 | 748 | 11 |
536524 | 536524 | 2020-09-15 | Madison | Ohio | 39097 | 750 | 12 |
539761 | 539761 | 2020-09-16 | Madison | Ohio | 39097 | 758 | 12 |
542997 | 542997 | 2020-09-17 | Madison | Ohio | 39097 | 764 | 12 |
546234 | 546234 | 2020-09-18 | Madison | Ohio | 39097 | 770 | 12 |
549473 | 549473 | 2020-09-19 | Madison | Ohio | 39097 | 776 | 12 |
552712 | 552712 | 2020-09-20 | Madison | Ohio | 39097 | 780 | 12 |
555949 | 555949 | 2020-09-21 | Madison | Ohio | 39097 | 780 | 12 |
559186 | 559186 | 2020-09-22 | Madison | Ohio | 39097 | 787 | 12 |
562423 | 562423 | 2020-09-23 | Madison | Ohio | 39097 | 792 | 12 |
565664 | 565664 | 2020-09-24 | Madison | Ohio | 39097 | 802 | 12 |
568905 | 568905 | 2020-09-25 | Madison | Ohio | 39097 | 815 | 12 |
572147 | 572147 | 2020-09-26 | Madison | Ohio | 39097 | 823 | 12 |
575391 | 575391 | 2020-09-27 | Madison | Ohio | 39097 | 830 | 12 |
578632 | 578632 | 2020-09-28 | Madison | Ohio | 39097 | 843 | 12 |
581872 | 581872 | 2020-09-29 | Madison | Ohio | 39097 | 855 | 12 |
585112 | 585112 | 2020-09-30 | Madison | Ohio | 39097 | 876 | 12 |
588352 | 588352 | 2020-10-01 | Madison | Ohio | 39097 | 887 | 12 |
591593 | 591593 | 2020-10-02 | Madison | Ohio | 39097 | 893 | 14 |
594834 | 594834 | 2020-10-03 | Madison | Ohio | 39097 | 907 | 14 |
598077 | 598077 | 2020-10-04 | Madison | Ohio | 39097 | 910 | 14 |
601320 | 601320 | 2020-10-05 | Madison | Ohio | 39097 | 911 | 14 |
604562 | 604562 | 2020-10-06 | Madison | Ohio | 39097 | 922 | 14 |
607805 | 607805 | 2020-10-07 | Madison | Ohio | 39097 | 930 | 14 |
611047 | 611047 | 2020-10-08 | Madison | Ohio | 39097 | 940 | 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);