ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where county = "Rockbridge" and deaths = 3 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 |
---|---|---|---|---|---|---|---|
855319 | 855319 | 2020-12-22 | Rockbridge | Virginia | 51163 | 479 | 3 |
852074 | 852074 | 2020-12-21 | Rockbridge | Virginia | 51163 | 476 | 3 |
848829 | 848829 | 2020-12-20 | Rockbridge | Virginia | 51163 | 462 | 3 |
845584 | 845584 | 2020-12-19 | Rockbridge | Virginia | 51163 | 452 | 3 |
842338 | 842338 | 2020-12-18 | Rockbridge | Virginia | 51163 | 434 | 3 |
839093 | 839093 | 2020-12-17 | Rockbridge | Virginia | 51163 | 430 | 3 |
835847 | 835847 | 2020-12-16 | Rockbridge | Virginia | 51163 | 423 | 3 |
832601 | 832601 | 2020-12-15 | Rockbridge | Virginia | 51163 | 405 | 3 |
829354 | 829354 | 2020-12-14 | Rockbridge | Virginia | 51163 | 383 | 3 |
826108 | 826108 | 2020-12-13 | Rockbridge | Virginia | 51163 | 374 | 3 |
822861 | 822861 | 2020-12-12 | Rockbridge | Virginia | 51163 | 369 | 3 |
819615 | 819615 | 2020-12-11 | Rockbridge | Virginia | 51163 | 357 | 3 |
816369 | 816369 | 2020-12-10 | Rockbridge | Virginia | 51163 | 350 | 3 |
813123 | 813123 | 2020-12-09 | Rockbridge | Virginia | 51163 | 341 | 3 |
809879 | 809879 | 2020-12-08 | Rockbridge | Virginia | 51163 | 333 | 3 |
741726 | 741726 | 2020-11-17 | Rockbridge | Virginia | 51163 | 207 | 3 |
738479 | 738479 | 2020-11-16 | Rockbridge | Virginia | 51163 | 202 | 3 |
735235 | 735235 | 2020-11-15 | Rockbridge | Virginia | 51163 | 197 | 3 |
731989 | 731989 | 2020-11-14 | Rockbridge | Virginia | 51163 | 194 | 3 |
728744 | 728744 | 2020-11-13 | Rockbridge | Virginia | 51163 | 192 | 3 |
725501 | 725501 | 2020-11-12 | Rockbridge | Virginia | 51163 | 182 | 3 |
722258 | 722258 | 2020-11-11 | Rockbridge | Virginia | 51163 | 180 | 3 |
719015 | 719015 | 2020-11-10 | Rockbridge | Virginia | 51163 | 172 | 3 |
715772 | 715772 | 2020-11-09 | Rockbridge | Virginia | 51163 | 174 | 3 |
712528 | 712528 | 2020-11-08 | Rockbridge | Virginia | 51163 | 174 | 3 |
709284 | 709284 | 2020-11-07 | Rockbridge | Virginia | 51163 | 174 | 3 |
706040 | 706040 | 2020-11-06 | Rockbridge | Virginia | 51163 | 167 | 3 |
702797 | 702797 | 2020-11-05 | Rockbridge | Virginia | 51163 | 164 | 3 |
699554 | 699554 | 2020-11-04 | Rockbridge | Virginia | 51163 | 160 | 3 |
696310 | 696310 | 2020-11-03 | Rockbridge | Virginia | 51163 | 159 | 3 |
693068 | 693068 | 2020-11-02 | Rockbridge | Virginia | 51163 | 155 | 3 |
689824 | 689824 | 2020-11-01 | Rockbridge | Virginia | 51163 | 155 | 3 |
686579 | 686579 | 2020-10-31 | Rockbridge | Virginia | 51163 | 154 | 3 |
683336 | 683336 | 2020-10-30 | Rockbridge | Virginia | 51163 | 153 | 3 |
680093 | 680093 | 2020-10-29 | Rockbridge | Virginia | 51163 | 153 | 3 |
676850 | 676850 | 2020-10-28 | Rockbridge | Virginia | 51163 | 153 | 3 |
673607 | 673607 | 2020-10-27 | Rockbridge | Virginia | 51163 | 152 | 3 |
670365 | 670365 | 2020-10-26 | Rockbridge | Virginia | 51163 | 151 | 3 |
667122 | 667122 | 2020-10-25 | Rockbridge | Virginia | 51163 | 150 | 3 |
663877 | 663877 | 2020-10-24 | Rockbridge | Virginia | 51163 | 150 | 3 |
660633 | 660633 | 2020-10-23 | Rockbridge | Virginia | 51163 | 150 | 3 |
657389 | 657389 | 2020-10-22 | Rockbridge | Virginia | 51163 | 148 | 3 |
654144 | 654144 | 2020-10-21 | Rockbridge | Virginia | 51163 | 148 | 3 |
650899 | 650899 | 2020-10-20 | Rockbridge | Virginia | 51163 | 147 | 3 |
647655 | 647655 | 2020-10-19 | Rockbridge | Virginia | 51163 | 147 | 3 |
644409 | 644409 | 2020-10-18 | Rockbridge | Virginia | 51163 | 147 | 3 |
641161 | 641161 | 2020-10-17 | Rockbridge | Virginia | 51163 | 144 | 3 |
637914 | 637914 | 2020-10-16 | Rockbridge | Virginia | 51163 | 143 | 3 |
634669 | 634669 | 2020-10-15 | Rockbridge | Virginia | 51163 | 140 | 3 |
631424 | 631424 | 2020-10-14 | Rockbridge | Virginia | 51163 | 140 | 3 |
628180 | 628180 | 2020-10-13 | Rockbridge | Virginia | 51163 | 143 | 3 |
624937 | 624937 | 2020-10-12 | Rockbridge | Virginia | 51163 | 141 | 3 |
621694 | 621694 | 2020-10-11 | Rockbridge | Virginia | 51163 | 140 | 3 |
618451 | 618451 | 2020-10-10 | Rockbridge | Virginia | 51163 | 138 | 3 |
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);