ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Kanawha" and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637998 | 637998 | 2020-10-16 | Kanawha | West Virginia | 54039 | 3249 | 101 |
634753 | 634753 | 2020-10-15 | Kanawha | West Virginia | 54039 | 3196 | 101 |
631508 | 631508 | 2020-10-14 | Kanawha | West Virginia | 54039 | 3170 | 100 |
628264 | 628264 | 2020-10-13 | Kanawha | West Virginia | 54039 | 3162 | 98 |
625021 | 625021 | 2020-10-12 | Kanawha | West Virginia | 54039 | 3113 | 97 |
621778 | 621778 | 2020-10-11 | Kanawha | West Virginia | 54039 | 3099 | 95 |
618535 | 618535 | 2020-10-10 | Kanawha | West Virginia | 54039 | 3080 | 94 |
615293 | 615293 | 2020-10-09 | Kanawha | West Virginia | 54039 | 3054 | 91 |
612052 | 612052 | 2020-10-08 | Kanawha | West Virginia | 54039 | 2994 | 89 |
608810 | 608810 | 2020-10-07 | Kanawha | West Virginia | 54039 | 2965 | 88 |
605567 | 605567 | 2020-10-06 | Kanawha | West Virginia | 54039 | 2930 | 86 |
602325 | 602325 | 2020-10-05 | Kanawha | West Virginia | 54039 | 2910 | 85 |
599082 | 599082 | 2020-10-04 | Kanawha | West Virginia | 54039 | 2874 | 83 |
595839 | 595839 | 2020-10-03 | Kanawha | West Virginia | 54039 | 2842 | 82 |
592597 | 592597 | 2020-10-02 | Kanawha | West Virginia | 54039 | 2813 | 82 |
589357 | 589357 | 2020-10-01 | Kanawha | West Virginia | 54039 | 2772 | 81 |
586116 | 586116 | 2020-09-30 | Kanawha | West Virginia | 54039 | 2747 | 81 |
582876 | 582876 | 2020-09-29 | Kanawha | West Virginia | 54039 | 2704 | 79 |
579637 | 579637 | 2020-09-28 | Kanawha | West Virginia | 54039 | 2688 | 79 |
576396 | 576396 | 2020-09-27 | Kanawha | West Virginia | 54039 | 2651 | 78 |
573152 | 573152 | 2020-09-26 | Kanawha | West Virginia | 54039 | 2603 | 76 |
569910 | 569910 | 2020-09-25 | Kanawha | West Virginia | 54039 | 2554 | 76 |
566669 | 566669 | 2020-09-24 | Kanawha | West Virginia | 54039 | 2468 | 74 |
563428 | 563428 | 2020-09-23 | Kanawha | West Virginia | 54039 | 2415 | 72 |
560189 | 560189 | 2020-09-22 | Kanawha | West Virginia | 54039 | 2377 | 70 |
556953 | 556953 | 2020-09-21 | Kanawha | West Virginia | 54039 | 2317 | 68 |
553716 | 553716 | 2020-09-20 | Kanawha | West Virginia | 54039 | 2297 | 67 |
550477 | 550477 | 2020-09-19 | Kanawha | West Virginia | 54039 | 2258 | 65 |
547238 | 547238 | 2020-09-18 | Kanawha | West Virginia | 54039 | 2194 | 62 |
544001 | 544001 | 2020-09-17 | Kanawha | West Virginia | 54039 | 2154 | 62 |
540765 | 540765 | 2020-09-16 | Kanawha | West Virginia | 54039 | 2083 | 62 |
537528 | 537528 | 2020-09-15 | Kanawha | West Virginia | 54039 | 2035 | 58 |
534292 | 534292 | 2020-09-14 | Kanawha | West Virginia | 54039 | 2019 | 56 |
531057 | 531057 | 2020-09-13 | Kanawha | West Virginia | 54039 | 1985 | 51 |
527820 | 527820 | 2020-09-12 | Kanawha | West Virginia | 54039 | 1934 | 51 |
524584 | 524584 | 2020-09-11 | Kanawha | West Virginia | 54039 | 1839 | 51 |
521348 | 521348 | 2020-09-10 | Kanawha | West Virginia | 54039 | 1809 | 48 |
518111 | 518111 | 2020-09-09 | Kanawha | West Virginia | 54039 | 1753 | 47 |
514876 | 514876 | 2020-09-08 | Kanawha | West Virginia | 54039 | 1737 | 47 |
511643 | 511643 | 2020-09-07 | Kanawha | West Virginia | 54039 | 1731 | 45 |
508410 | 508410 | 2020-09-06 | Kanawha | West Virginia | 54039 | 1686 | 44 |
505178 | 505178 | 2020-09-05 | Kanawha | West Virginia | 54039 | 1650 | 43 |
501944 | 501944 | 2020-09-04 | Kanawha | West Virginia | 54039 | 1582 | 43 |
498710 | 498710 | 2020-09-03 | Kanawha | West Virginia | 54039 | 1553 | 40 |
495477 | 495477 | 2020-09-02 | Kanawha | West Virginia | 54039 | 1515 | 36 |
492243 | 492243 | 2020-09-01 | Kanawha | West Virginia | 54039 | 1491 | 34 |
489010 | 489010 | 2020-08-31 | Kanawha | West Virginia | 54039 | 1417 | 31 |
485777 | 485777 | 2020-08-30 | Kanawha | West Virginia | 54039 | 1393 | 31 |
482542 | 482542 | 2020-08-29 | Kanawha | West Virginia | 54039 | 1363 | 30 |
479308 | 479308 | 2020-08-28 | Kanawha | West Virginia | 54039 | 1338 | 28 |
476075 | 476075 | 2020-08-27 | Kanawha | West Virginia | 54039 | 1294 | 27 |
472842 | 472842 | 2020-08-26 | Kanawha | West Virginia | 54039 | 1281 | 27 |
469610 | 469610 | 2020-08-25 | Kanawha | West Virginia | 54039 | 1246 | 27 |
466381 | 466381 | 2020-08-24 | Kanawha | West Virginia | 54039 | 1225 | 27 |
463152 | 463152 | 2020-08-23 | Kanawha | West Virginia | 54039 | 1214 | 27 |
459923 | 459923 | 2020-08-22 | Kanawha | West Virginia | 54039 | 1194 | 27 |
456696 | 456696 | 2020-08-21 | Kanawha | West Virginia | 54039 | 1178 | 27 |
453468 | 453468 | 2020-08-20 | Kanawha | West Virginia | 54039 | 1161 | 26 |
450240 | 450240 | 2020-08-19 | Kanawha | West Virginia | 54039 | 1122 | 26 |
447012 | 447012 | 2020-08-18 | Kanawha | West Virginia | 54039 | 1113 | 25 |
443785 | 443785 | 2020-08-17 | Kanawha | West Virginia | 54039 | 1095 | 24 |
440559 | 440559 | 2020-08-16 | Kanawha | West Virginia | 54039 | 1080 | 24 |
437333 | 437333 | 2020-08-15 | Kanawha | West Virginia | 54039 | 1066 | 24 |
434107 | 434107 | 2020-08-14 | Kanawha | West Virginia | 54039 | 1046 | 24 |
430882 | 430882 | 2020-08-13 | Kanawha | West Virginia | 54039 | 1020 | 24 |
427654 | 427654 | 2020-08-12 | Kanawha | West Virginia | 54039 | 976 | 24 |
424430 | 424430 | 2020-08-11 | Kanawha | West Virginia | 54039 | 960 | 24 |
421209 | 421209 | 2020-08-10 | Kanawha | West Virginia | 54039 | 938 | 24 |
417988 | 417988 | 2020-08-09 | Kanawha | West Virginia | 54039 | 935 | 23 |
414767 | 414767 | 2020-08-08 | Kanawha | West Virginia | 54039 | 911 | 23 |
411547 | 411547 | 2020-08-07 | Kanawha | West Virginia | 54039 | 898 | 22 |
408328 | 408328 | 2020-08-06 | Kanawha | West Virginia | 54039 | 876 | 22 |
405108 | 405108 | 2020-08-05 | Kanawha | West Virginia | 54039 | 856 | 22 |
401890 | 401890 | 2020-08-04 | Kanawha | West Virginia | 54039 | 848 | 22 |
398674 | 398674 | 2020-08-03 | Kanawha | West Virginia | 54039 | 851 | 21 |
395458 | 395458 | 2020-08-02 | Kanawha | West Virginia | 54039 | 822 | 21 |
392242 | 392242 | 2020-08-01 | Kanawha | West Virginia | 54039 | 808 | 20 |
389025 | 389025 | 2020-07-31 | Kanawha | West Virginia | 54039 | 798 | 20 |
385808 | 385808 | 2020-07-30 | Kanawha | West Virginia | 54039 | 756 | 20 |
382590 | 382590 | 2020-07-29 | Kanawha | West Virginia | 54039 | 729 | 20 |
379373 | 379373 | 2020-07-28 | Kanawha | West Virginia | 54039 | 712 | 20 |
376157 | 376157 | 2020-07-27 | Kanawha | West Virginia | 54039 | 707 | 20 |
372943 | 372943 | 2020-07-26 | Kanawha | West Virginia | 54039 | 692 | 20 |
369731 | 369731 | 2020-07-25 | Kanawha | West Virginia | 54039 | 667 | 20 |
366521 | 366521 | 2020-07-24 | Kanawha | West Virginia | 54039 | 653 | 20 |
363314 | 363314 | 2020-07-23 | Kanawha | West Virginia | 54039 | 606 | 20 |
360108 | 360108 | 2020-07-22 | Kanawha | West Virginia | 54039 | 596 | 20 |
356903 | 356903 | 2020-07-21 | Kanawha | West Virginia | 54039 | 551 | 20 |
353700 | 353700 | 2020-07-20 | Kanawha | West Virginia | 54039 | 546 | 20 |
350498 | 350498 | 2020-07-19 | Kanawha | West Virginia | 54039 | 532 | 20 |
347297 | 347297 | 2020-07-18 | Kanawha | West Virginia | 54039 | 501 | 20 |
344097 | 344097 | 2020-07-17 | Kanawha | West Virginia | 54039 | 484 | 20 |
340898 | 340898 | 2020-07-16 | Kanawha | West Virginia | 54039 | 475 | 20 |
337702 | 337702 | 2020-07-15 | Kanawha | West Virginia | 54039 | 454 | 20 |
334507 | 334507 | 2020-07-14 | Kanawha | West Virginia | 54039 | 434 | 20 |
331314 | 331314 | 2020-07-13 | Kanawha | West Virginia | 54039 | 433 | 20 |
328128 | 328128 | 2020-07-12 | Kanawha | West Virginia | 54039 | 421 | 20 |
324942 | 324942 | 2020-07-11 | Kanawha | West Virginia | 54039 | 410 | 20 |
321761 | 321761 | 2020-07-10 | Kanawha | West Virginia | 54039 | 393 | 20 |
318582 | 318582 | 2020-07-09 | Kanawha | West Virginia | 54039 | 384 | 20 |
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);