ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
130 rows where county = "Buena Vista city", deaths = 1 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
819524 | 819524 | 2020-12-11 | Buena Vista city | Virginia | 51530 | 396 | 1 |
816278 | 816278 | 2020-12-10 | Buena Vista city | Virginia | 51530 | 372 | 1 |
813032 | 813032 | 2020-12-09 | Buena Vista city | Virginia | 51530 | 358 | 1 |
809788 | 809788 | 2020-12-08 | Buena Vista city | Virginia | 51530 | 357 | 1 |
806543 | 806543 | 2020-12-07 | Buena Vista city | Virginia | 51530 | 350 | 1 |
803298 | 803298 | 2020-12-06 | Buena Vista city | Virginia | 51530 | 336 | 1 |
800053 | 800053 | 2020-12-05 | Buena Vista city | Virginia | 51530 | 310 | 1 |
796808 | 796808 | 2020-12-04 | Buena Vista city | Virginia | 51530 | 299 | 1 |
793563 | 793563 | 2020-12-03 | Buena Vista city | Virginia | 51530 | 281 | 1 |
790318 | 790318 | 2020-12-02 | Buena Vista city | Virginia | 51530 | 275 | 1 |
787073 | 787073 | 2020-12-01 | Buena Vista city | Virginia | 51530 | 275 | 1 |
783829 | 783829 | 2020-11-30 | Buena Vista city | Virginia | 51530 | 267 | 1 |
780584 | 780584 | 2020-11-29 | Buena Vista city | Virginia | 51530 | 264 | 1 |
777338 | 777338 | 2020-11-28 | Buena Vista city | Virginia | 51530 | 263 | 1 |
774093 | 774093 | 2020-11-27 | Buena Vista city | Virginia | 51530 | 255 | 1 |
770848 | 770848 | 2020-11-26 | Buena Vista city | Virginia | 51530 | 256 | 1 |
767602 | 767602 | 2020-11-25 | Buena Vista city | Virginia | 51530 | 251 | 1 |
764357 | 764357 | 2020-11-24 | Buena Vista city | Virginia | 51530 | 242 | 1 |
761112 | 761112 | 2020-11-23 | Buena Vista city | Virginia | 51530 | 238 | 1 |
757867 | 757867 | 2020-11-22 | Buena Vista city | Virginia | 51530 | 229 | 1 |
754620 | 754620 | 2020-11-21 | Buena Vista city | Virginia | 51530 | 219 | 1 |
751374 | 751374 | 2020-11-20 | Buena Vista city | Virginia | 51530 | 209 | 1 |
748128 | 748128 | 2020-11-19 | Buena Vista city | Virginia | 51530 | 204 | 1 |
744882 | 744882 | 2020-11-18 | Buena Vista city | Virginia | 51530 | 194 | 1 |
741635 | 741635 | 2020-11-17 | Buena Vista city | Virginia | 51530 | 189 | 1 |
738388 | 738388 | 2020-11-16 | Buena Vista city | Virginia | 51530 | 173 | 1 |
735144 | 735144 | 2020-11-15 | Buena Vista city | Virginia | 51530 | 161 | 1 |
731898 | 731898 | 2020-11-14 | Buena Vista city | Virginia | 51530 | 158 | 1 |
728653 | 728653 | 2020-11-13 | Buena Vista city | Virginia | 51530 | 152 | 1 |
725410 | 725410 | 2020-11-12 | Buena Vista city | Virginia | 51530 | 147 | 1 |
722167 | 722167 | 2020-11-11 | Buena Vista city | Virginia | 51530 | 147 | 1 |
718924 | 718924 | 2020-11-10 | Buena Vista city | Virginia | 51530 | 143 | 1 |
715681 | 715681 | 2020-11-09 | Buena Vista city | Virginia | 51530 | 141 | 1 |
712437 | 712437 | 2020-11-08 | Buena Vista city | Virginia | 51530 | 140 | 1 |
709193 | 709193 | 2020-11-07 | Buena Vista city | Virginia | 51530 | 139 | 1 |
705949 | 705949 | 2020-11-06 | Buena Vista city | Virginia | 51530 | 137 | 1 |
702706 | 702706 | 2020-11-05 | Buena Vista city | Virginia | 51530 | 136 | 1 |
699463 | 699463 | 2020-11-04 | Buena Vista city | Virginia | 51530 | 134 | 1 |
696219 | 696219 | 2020-11-03 | Buena Vista city | Virginia | 51530 | 132 | 1 |
692977 | 692977 | 2020-11-02 | Buena Vista city | Virginia | 51530 | 129 | 1 |
689733 | 689733 | 2020-11-01 | Buena Vista city | Virginia | 51530 | 129 | 1 |
686488 | 686488 | 2020-10-31 | Buena Vista city | Virginia | 51530 | 125 | 1 |
683245 | 683245 | 2020-10-30 | Buena Vista city | Virginia | 51530 | 124 | 1 |
680002 | 680002 | 2020-10-29 | Buena Vista city | Virginia | 51530 | 121 | 1 |
676759 | 676759 | 2020-10-28 | Buena Vista city | Virginia | 51530 | 121 | 1 |
673516 | 673516 | 2020-10-27 | Buena Vista city | Virginia | 51530 | 121 | 1 |
670274 | 670274 | 2020-10-26 | Buena Vista city | Virginia | 51530 | 121 | 1 |
667031 | 667031 | 2020-10-25 | Buena Vista city | Virginia | 51530 | 121 | 1 |
663786 | 663786 | 2020-10-24 | Buena Vista city | Virginia | 51530 | 121 | 1 |
660542 | 660542 | 2020-10-23 | Buena Vista city | Virginia | 51530 | 121 | 1 |
657298 | 657298 | 2020-10-22 | Buena Vista city | Virginia | 51530 | 121 | 1 |
654053 | 654053 | 2020-10-21 | Buena Vista city | Virginia | 51530 | 121 | 1 |
650808 | 650808 | 2020-10-20 | Buena Vista city | Virginia | 51530 | 121 | 1 |
647564 | 647564 | 2020-10-19 | Buena Vista city | Virginia | 51530 | 121 | 1 |
644318 | 644318 | 2020-10-18 | Buena Vista city | Virginia | 51530 | 121 | 1 |
641070 | 641070 | 2020-10-17 | Buena Vista city | Virginia | 51530 | 119 | 1 |
637823 | 637823 | 2020-10-16 | Buena Vista city | Virginia | 51530 | 119 | 1 |
634578 | 634578 | 2020-10-15 | Buena Vista city | Virginia | 51530 | 115 | 1 |
631333 | 631333 | 2020-10-14 | Buena Vista city | Virginia | 51530 | 115 | 1 |
628089 | 628089 | 2020-10-13 | Buena Vista city | Virginia | 51530 | 108 | 1 |
624846 | 624846 | 2020-10-12 | Buena Vista city | Virginia | 51530 | 107 | 1 |
621603 | 621603 | 2020-10-11 | Buena Vista city | Virginia | 51530 | 106 | 1 |
618360 | 618360 | 2020-10-10 | Buena Vista city | Virginia | 51530 | 107 | 1 |
615118 | 615118 | 2020-10-09 | Buena Vista city | Virginia | 51530 | 101 | 1 |
611877 | 611877 | 2020-10-08 | Buena Vista city | Virginia | 51530 | 99 | 1 |
608635 | 608635 | 2020-10-07 | Buena Vista city | Virginia | 51530 | 94 | 1 |
605392 | 605392 | 2020-10-06 | Buena Vista city | Virginia | 51530 | 92 | 1 |
602150 | 602150 | 2020-10-05 | Buena Vista city | Virginia | 51530 | 90 | 1 |
598907 | 598907 | 2020-10-04 | Buena Vista city | Virginia | 51530 | 90 | 1 |
595664 | 595664 | 2020-10-03 | Buena Vista city | Virginia | 51530 | 89 | 1 |
592422 | 592422 | 2020-10-02 | Buena Vista city | Virginia | 51530 | 89 | 1 |
589182 | 589182 | 2020-10-01 | Buena Vista city | Virginia | 51530 | 89 | 1 |
585941 | 585941 | 2020-09-30 | Buena Vista city | Virginia | 51530 | 88 | 1 |
582701 | 582701 | 2020-09-29 | Buena Vista city | Virginia | 51530 | 85 | 1 |
579462 | 579462 | 2020-09-28 | Buena Vista city | Virginia | 51530 | 83 | 1 |
576221 | 576221 | 2020-09-27 | Buena Vista city | Virginia | 51530 | 83 | 1 |
572977 | 572977 | 2020-09-26 | Buena Vista city | Virginia | 51530 | 80 | 1 |
569735 | 569735 | 2020-09-25 | Buena Vista city | Virginia | 51530 | 80 | 1 |
566494 | 566494 | 2020-09-24 | Buena Vista city | Virginia | 51530 | 80 | 1 |
563253 | 563253 | 2020-09-23 | Buena Vista city | Virginia | 51530 | 80 | 1 |
560014 | 560014 | 2020-09-22 | Buena Vista city | Virginia | 51530 | 80 | 1 |
556778 | 556778 | 2020-09-21 | Buena Vista city | Virginia | 51530 | 79 | 1 |
553541 | 553541 | 2020-09-20 | Buena Vista city | Virginia | 51530 | 79 | 1 |
550302 | 550302 | 2020-09-19 | Buena Vista city | Virginia | 51530 | 79 | 1 |
547063 | 547063 | 2020-09-18 | Buena Vista city | Virginia | 51530 | 79 | 1 |
543826 | 543826 | 2020-09-17 | Buena Vista city | Virginia | 51530 | 78 | 1 |
540590 | 540590 | 2020-09-16 | Buena Vista city | Virginia | 51530 | 78 | 1 |
537353 | 537353 | 2020-09-15 | Buena Vista city | Virginia | 51530 | 78 | 1 |
534117 | 534117 | 2020-09-14 | Buena Vista city | Virginia | 51530 | 77 | 1 |
530882 | 530882 | 2020-09-13 | Buena Vista city | Virginia | 51530 | 77 | 1 |
527645 | 527645 | 2020-09-12 | Buena Vista city | Virginia | 51530 | 77 | 1 |
524409 | 524409 | 2020-09-11 | Buena Vista city | Virginia | 51530 | 77 | 1 |
521173 | 521173 | 2020-09-10 | Buena Vista city | Virginia | 51530 | 77 | 1 |
517936 | 517936 | 2020-09-09 | Buena Vista city | Virginia | 51530 | 77 | 1 |
514701 | 514701 | 2020-09-08 | Buena Vista city | Virginia | 51530 | 76 | 1 |
511468 | 511468 | 2020-09-07 | Buena Vista city | Virginia | 51530 | 76 | 1 |
508235 | 508235 | 2020-09-06 | Buena Vista city | Virginia | 51530 | 76 | 1 |
505003 | 505003 | 2020-09-05 | Buena Vista city | Virginia | 51530 | 76 | 1 |
501769 | 501769 | 2020-09-04 | Buena Vista city | Virginia | 51530 | 76 | 1 |
498535 | 498535 | 2020-09-03 | Buena Vista city | Virginia | 51530 | 75 | 1 |
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);