ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
762 rows where county = "Grant" and state = "West Virginia" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
356895 | 356895 | 2020-07-21 | Grant | West Virginia | 54023 | 26 | 0 |
360100 | 360100 | 2020-07-22 | Grant | West Virginia | 54023 | 35 | 0 |
363306 | 363306 | 2020-07-23 | Grant | West Virginia | 54023 | 38 | 0 |
366513 | 366513 | 2020-07-24 | Grant | West Virginia | 54023 | 38 | 0 |
369723 | 369723 | 2020-07-25 | Grant | West Virginia | 54023 | 39 | 0 |
372935 | 372935 | 2020-07-26 | Grant | West Virginia | 54023 | 42 | 0 |
376149 | 376149 | 2020-07-27 | Grant | West Virginia | 54023 | 43 | 0 |
379365 | 379365 | 2020-07-28 | Grant | West Virginia | 54023 | 47 | 0 |
382582 | 382582 | 2020-07-29 | Grant | West Virginia | 54023 | 66 | 0 |
385800 | 385800 | 2020-07-30 | Grant | West Virginia | 54023 | 66 | 0 |
389017 | 389017 | 2020-07-31 | Grant | West Virginia | 54023 | 68 | 0 |
392234 | 392234 | 2020-08-01 | Grant | West Virginia | 54023 | 73 | 0 |
395450 | 395450 | 2020-08-02 | Grant | West Virginia | 54023 | 77 | 0 |
398666 | 398666 | 2020-08-03 | Grant | West Virginia | 54023 | 81 | 0 |
401882 | 401882 | 2020-08-04 | Grant | West Virginia | 54023 | 81 | 1 |
405100 | 405100 | 2020-08-05 | Grant | West Virginia | 54023 | 89 | 1 |
408320 | 408320 | 2020-08-06 | Grant | West Virginia | 54023 | 97 | 1 |
411539 | 411539 | 2020-08-07 | Grant | West Virginia | 54023 | 117 | 1 |
414759 | 414759 | 2020-08-08 | Grant | West Virginia | 54023 | 119 | 1 |
417980 | 417980 | 2020-08-09 | Grant | West Virginia | 54023 | 121 | 1 |
421201 | 421201 | 2020-08-10 | Grant | West Virginia | 54023 | 121 | 1 |
424422 | 424422 | 2020-08-11 | Grant | West Virginia | 54023 | 121 | 3 |
427646 | 427646 | 2020-08-12 | Grant | West Virginia | 54023 | 129 | 4 |
430874 | 430874 | 2020-08-13 | Grant | West Virginia | 54023 | 131 | 4 |
434099 | 434099 | 2020-08-14 | Grant | West Virginia | 54023 | 131 | 4 |
437325 | 437325 | 2020-08-15 | Grant | West Virginia | 54023 | 131 | 4 |
440551 | 440551 | 2020-08-16 | Grant | West Virginia | 54023 | 131 | 4 |
443777 | 443777 | 2020-08-17 | Grant | West Virginia | 54023 | 131 | 4 |
447004 | 447004 | 2020-08-18 | Grant | West Virginia | 54023 | 131 | 4 |
450232 | 450232 | 2020-08-19 | Grant | West Virginia | 54023 | 131 | 5 |
453460 | 453460 | 2020-08-20 | Grant | West Virginia | 54023 | 131 | 5 |
456688 | 456688 | 2020-08-21 | Grant | West Virginia | 54023 | 131 | 4 |
459915 | 459915 | 2020-08-22 | Grant | West Virginia | 54023 | 133 | 4 |
463144 | 463144 | 2020-08-23 | Grant | West Virginia | 54023 | 133 | 4 |
466373 | 466373 | 2020-08-24 | Grant | West Virginia | 54023 | 133 | 4 |
469602 | 469602 | 2020-08-25 | Grant | West Virginia | 54023 | 134 | 5 |
472834 | 472834 | 2020-08-26 | Grant | West Virginia | 54023 | 138 | 5 |
476067 | 476067 | 2020-08-27 | Grant | West Virginia | 54023 | 139 | 5 |
479300 | 479300 | 2020-08-28 | Grant | West Virginia | 54023 | 140 | 5 |
482534 | 482534 | 2020-08-29 | Grant | West Virginia | 54023 | 139 | 6 |
485769 | 485769 | 2020-08-30 | Grant | West Virginia | 54023 | 139 | 6 |
489002 | 489002 | 2020-08-31 | Grant | West Virginia | 54023 | 141 | 6 |
492235 | 492235 | 2020-09-01 | Grant | West Virginia | 54023 | 141 | 6 |
495469 | 495469 | 2020-09-02 | Grant | West Virginia | 54023 | 141 | 6 |
498702 | 498702 | 2020-09-03 | Grant | West Virginia | 54023 | 142 | 6 |
501936 | 501936 | 2020-09-04 | Grant | West Virginia | 54023 | 143 | 6 |
505170 | 505170 | 2020-09-05 | Grant | West Virginia | 54023 | 143 | 6 |
508402 | 508402 | 2020-09-06 | Grant | West Virginia | 54023 | 144 | 6 |
511635 | 511635 | 2020-09-07 | Grant | West Virginia | 54023 | 144 | 6 |
514868 | 514868 | 2020-09-08 | Grant | West Virginia | 54023 | 144 | 6 |
518103 | 518103 | 2020-09-09 | Grant | West Virginia | 54023 | 144 | 6 |
521340 | 521340 | 2020-09-10 | Grant | West Virginia | 54023 | 145 | 6 |
524576 | 524576 | 2020-09-11 | Grant | West Virginia | 54023 | 147 | 6 |
527812 | 527812 | 2020-09-12 | Grant | West Virginia | 54023 | 147 | 6 |
531049 | 531049 | 2020-09-13 | Grant | West Virginia | 54023 | 147 | 6 |
534284 | 534284 | 2020-09-14 | Grant | West Virginia | 54023 | 147 | 7 |
537520 | 537520 | 2020-09-15 | Grant | West Virginia | 54023 | 147 | 7 |
540757 | 540757 | 2020-09-16 | Grant | West Virginia | 54023 | 150 | 7 |
543993 | 543993 | 2020-09-17 | Grant | West Virginia | 54023 | 150 | 7 |
547230 | 547230 | 2020-09-18 | Grant | West Virginia | 54023 | 150 | 7 |
550469 | 550469 | 2020-09-19 | Grant | West Virginia | 54023 | 150 | 7 |
553708 | 553708 | 2020-09-20 | Grant | West Virginia | 54023 | 152 | 7 |
556945 | 556945 | 2020-09-21 | Grant | West Virginia | 54023 | 152 | 7 |
560181 | 560181 | 2020-09-22 | Grant | West Virginia | 54023 | 152 | 7 |
563420 | 563420 | 2020-09-23 | Grant | West Virginia | 54023 | 152 | 7 |
566661 | 566661 | 2020-09-24 | Grant | West Virginia | 54023 | 156 | 7 |
569902 | 569902 | 2020-09-25 | Grant | West Virginia | 54023 | 158 | 7 |
573144 | 573144 | 2020-09-26 | Grant | West Virginia | 54023 | 160 | 7 |
576388 | 576388 | 2020-09-27 | Grant | West Virginia | 54023 | 161 | 7 |
579629 | 579629 | 2020-09-28 | Grant | West Virginia | 54023 | 161 | 7 |
582868 | 582868 | 2020-09-29 | Grant | West Virginia | 54023 | 161 | 7 |
586108 | 586108 | 2020-09-30 | Grant | West Virginia | 54023 | 161 | 7 |
589349 | 589349 | 2020-10-01 | Grant | West Virginia | 54023 | 162 | 7 |
592589 | 592589 | 2020-10-02 | Grant | West Virginia | 54023 | 163 | 7 |
595831 | 595831 | 2020-10-03 | Grant | West Virginia | 54023 | 162 | 7 |
599074 | 599074 | 2020-10-04 | Grant | West Virginia | 54023 | 163 | 7 |
602317 | 602317 | 2020-10-05 | Grant | West Virginia | 54023 | 163 | 7 |
605559 | 605559 | 2020-10-06 | Grant | West Virginia | 54023 | 163 | 7 |
608802 | 608802 | 2020-10-07 | Grant | West Virginia | 54023 | 163 | 7 |
612044 | 612044 | 2020-10-08 | Grant | West Virginia | 54023 | 165 | 7 |
615285 | 615285 | 2020-10-09 | Grant | West Virginia | 54023 | 169 | 7 |
618527 | 618527 | 2020-10-10 | Grant | West Virginia | 54023 | 172 | 7 |
621770 | 621770 | 2020-10-11 | Grant | West Virginia | 54023 | 174 | 7 |
625013 | 625013 | 2020-10-12 | Grant | West Virginia | 54023 | 174 | 7 |
628256 | 628256 | 2020-10-13 | Grant | West Virginia | 54023 | 176 | 7 |
631500 | 631500 | 2020-10-14 | Grant | West Virginia | 54023 | 177 | 7 |
634745 | 634745 | 2020-10-15 | Grant | West Virginia | 54023 | 177 | 7 |
637990 | 637990 | 2020-10-16 | Grant | West Virginia | 54023 | 177 | 7 |
641237 | 641237 | 2020-10-17 | Grant | West Virginia | 54023 | 178 | 8 |
644485 | 644485 | 2020-10-18 | Grant | West Virginia | 54023 | 178 | 8 |
647731 | 647731 | 2020-10-19 | Grant | West Virginia | 54023 | 178 | 8 |
650975 | 650975 | 2020-10-20 | Grant | West Virginia | 54023 | 178 | 8 |
654220 | 654220 | 2020-10-21 | Grant | West Virginia | 54023 | 179 | 8 |
657465 | 657465 | 2020-10-22 | Grant | West Virginia | 54023 | 179 | 8 |
660709 | 660709 | 2020-10-23 | Grant | West Virginia | 54023 | 179 | 8 |
663953 | 663953 | 2020-10-24 | Grant | West Virginia | 54023 | 182 | 8 |
667198 | 667198 | 2020-10-25 | Grant | West Virginia | 54023 | 185 | 8 |
670441 | 670441 | 2020-10-26 | Grant | West Virginia | 54023 | 188 | 8 |
673683 | 673683 | 2020-10-27 | Grant | West Virginia | 54023 | 191 | 8 |
676926 | 676926 | 2020-10-28 | Grant | West Virginia | 54023 | 191 | 8 |
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);