ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where deaths = 6, fips = 51630 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
829292 | 829292 | 2020-12-14 | Fredericksburg city | Virginia | 51630 | 838 | 6 |
826046 | 826046 | 2020-12-13 | Fredericksburg city | Virginia | 51630 | 823 | 6 |
822799 | 822799 | 2020-12-12 | Fredericksburg city | Virginia | 51630 | 823 | 6 |
819553 | 819553 | 2020-12-11 | Fredericksburg city | Virginia | 51630 | 815 | 6 |
816307 | 816307 | 2020-12-10 | Fredericksburg city | Virginia | 51630 | 800 | 6 |
813061 | 813061 | 2020-12-09 | Fredericksburg city | Virginia | 51630 | 795 | 6 |
809817 | 809817 | 2020-12-08 | Fredericksburg city | Virginia | 51630 | 784 | 6 |
806572 | 806572 | 2020-12-07 | Fredericksburg city | Virginia | 51630 | 777 | 6 |
803327 | 803327 | 2020-12-06 | Fredericksburg city | Virginia | 51630 | 755 | 6 |
800082 | 800082 | 2020-12-05 | Fredericksburg city | Virginia | 51630 | 741 | 6 |
796837 | 796837 | 2020-12-04 | Fredericksburg city | Virginia | 51630 | 723 | 6 |
793592 | 793592 | 2020-12-03 | Fredericksburg city | Virginia | 51630 | 717 | 6 |
790347 | 790347 | 2020-12-02 | Fredericksburg city | Virginia | 51630 | 711 | 6 |
787102 | 787102 | 2020-12-01 | Fredericksburg city | Virginia | 51630 | 708 | 6 |
783858 | 783858 | 2020-11-30 | Fredericksburg city | Virginia | 51630 | 703 | 6 |
780613 | 780613 | 2020-11-29 | Fredericksburg city | Virginia | 51630 | 702 | 6 |
777367 | 777367 | 2020-11-28 | Fredericksburg city | Virginia | 51630 | 699 | 6 |
774122 | 774122 | 2020-11-27 | Fredericksburg city | Virginia | 51630 | 692 | 6 |
770877 | 770877 | 2020-11-26 | Fredericksburg city | Virginia | 51630 | 678 | 6 |
767631 | 767631 | 2020-11-25 | Fredericksburg city | Virginia | 51630 | 674 | 6 |
764386 | 764386 | 2020-11-24 | Fredericksburg city | Virginia | 51630 | 669 | 6 |
761141 | 761141 | 2020-11-23 | Fredericksburg city | Virginia | 51630 | 661 | 6 |
757896 | 757896 | 2020-11-22 | Fredericksburg city | Virginia | 51630 | 652 | 6 |
754649 | 754649 | 2020-11-21 | Fredericksburg city | Virginia | 51630 | 649 | 6 |
751403 | 751403 | 2020-11-20 | Fredericksburg city | Virginia | 51630 | 643 | 6 |
748157 | 748157 | 2020-11-19 | Fredericksburg city | Virginia | 51630 | 641 | 6 |
744911 | 744911 | 2020-11-18 | Fredericksburg city | Virginia | 51630 | 640 | 6 |
741664 | 741664 | 2020-11-17 | Fredericksburg city | Virginia | 51630 | 639 | 6 |
738417 | 738417 | 2020-11-16 | Fredericksburg city | Virginia | 51630 | 638 | 6 |
728682 | 728682 | 2020-11-13 | Fredericksburg city | Virginia | 51630 | 629 | 6 |
725439 | 725439 | 2020-11-12 | Fredericksburg city | Virginia | 51630 | 628 | 6 |
722196 | 722196 | 2020-11-11 | Fredericksburg city | Virginia | 51630 | 624 | 6 |
718953 | 718953 | 2020-11-10 | Fredericksburg city | Virginia | 51630 | 622 | 6 |
715710 | 715710 | 2020-11-09 | Fredericksburg city | Virginia | 51630 | 619 | 6 |
712466 | 712466 | 2020-11-08 | Fredericksburg city | Virginia | 51630 | 618 | 6 |
709222 | 709222 | 2020-11-07 | Fredericksburg city | Virginia | 51630 | 617 | 6 |
705978 | 705978 | 2020-11-06 | Fredericksburg city | Virginia | 51630 | 612 | 6 |
702735 | 702735 | 2020-11-05 | Fredericksburg city | Virginia | 51630 | 609 | 6 |
699492 | 699492 | 2020-11-04 | Fredericksburg city | Virginia | 51630 | 607 | 6 |
696248 | 696248 | 2020-11-03 | Fredericksburg city | Virginia | 51630 | 603 | 6 |
693006 | 693006 | 2020-11-02 | Fredericksburg city | Virginia | 51630 | 600 | 6 |
689762 | 689762 | 2020-11-01 | Fredericksburg city | Virginia | 51630 | 599 | 6 |
686517 | 686517 | 2020-10-31 | Fredericksburg city | Virginia | 51630 | 597 | 6 |
683274 | 683274 | 2020-10-30 | Fredericksburg city | Virginia | 51630 | 594 | 6 |
680031 | 680031 | 2020-10-29 | Fredericksburg city | Virginia | 51630 | 591 | 6 |
676788 | 676788 | 2020-10-28 | Fredericksburg city | Virginia | 51630 | 588 | 6 |
673545 | 673545 | 2020-10-27 | Fredericksburg city | Virginia | 51630 | 589 | 6 |
670303 | 670303 | 2020-10-26 | Fredericksburg city | Virginia | 51630 | 585 | 6 |
667060 | 667060 | 2020-10-25 | Fredericksburg city | Virginia | 51630 | 585 | 6 |
663815 | 663815 | 2020-10-24 | Fredericksburg city | Virginia | 51630 | 585 | 6 |
660571 | 660571 | 2020-10-23 | Fredericksburg city | Virginia | 51630 | 582 | 6 |
657327 | 657327 | 2020-10-22 | Fredericksburg city | Virginia | 51630 | 583 | 6 |
654082 | 654082 | 2020-10-21 | Fredericksburg city | Virginia | 51630 | 576 | 6 |
560043 | 560043 | 2020-09-22 | Fredericksburg city | Virginia | 51630 | 533 | 6 |
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);