ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Goochland" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923411 | 923411 | 2021-01-12 | Goochland | Virginia | 51075 | 766 | 7 |
920166 | 920166 | 2021-01-11 | Goochland | Virginia | 51075 | 755 | 7 |
916921 | 916921 | 2021-01-10 | Goochland | Virginia | 51075 | 728 | 7 |
913676 | 913676 | 2021-01-09 | Goochland | Virginia | 51075 | 699 | 7 |
910431 | 910431 | 2021-01-08 | Goochland | Virginia | 51075 | 688 | 7 |
907186 | 907186 | 2021-01-07 | Goochland | Virginia | 51075 | 678 | 7 |
903940 | 903940 | 2021-01-06 | Goochland | Virginia | 51075 | 671 | 7 |
900695 | 900695 | 2021-01-05 | Goochland | Virginia | 51075 | 670 | 8 |
897450 | 897450 | 2021-01-04 | Goochland | Virginia | 51075 | 653 | 7 |
894204 | 894204 | 2021-01-03 | Goochland | Virginia | 51075 | 650 | 7 |
890958 | 890958 | 2021-01-02 | Goochland | Virginia | 51075 | 644 | 7 |
887711 | 887711 | 2021-01-01 | Goochland | Virginia | 51075 | 621 | 7 |
884466 | 884466 | 2020-12-31 | Goochland | Virginia | 51075 | 612 | 7 |
881221 | 881221 | 2020-12-30 | Goochland | Virginia | 51075 | 607 | 7 |
877976 | 877976 | 2020-12-29 | Goochland | Virginia | 51075 | 604 | 7 |
874731 | 874731 | 2020-12-28 | Goochland | Virginia | 51075 | 603 | 7 |
871486 | 871486 | 2020-12-27 | Goochland | Virginia | 51075 | 598 | 7 |
868241 | 868241 | 2020-12-26 | Goochland | Virginia | 51075 | 594 | 7 |
864996 | 864996 | 2020-12-25 | Goochland | Virginia | 51075 | 583 | 7 |
861751 | 861751 | 2020-12-24 | Goochland | Virginia | 51075 | 579 | 7 |
858506 | 858506 | 2020-12-23 | Goochland | Virginia | 51075 | 569 | 7 |
855261 | 855261 | 2020-12-22 | Goochland | Virginia | 51075 | 553 | 7 |
852016 | 852016 | 2020-12-21 | Goochland | Virginia | 51075 | 543 | 7 |
848771 | 848771 | 2020-12-20 | Goochland | Virginia | 51075 | 528 | 7 |
845526 | 845526 | 2020-12-19 | Goochland | Virginia | 51075 | 525 | 7 |
842280 | 842280 | 2020-12-18 | Goochland | Virginia | 51075 | 524 | 7 |
839035 | 839035 | 2020-12-17 | Goochland | Virginia | 51075 | 522 | 7 |
835789 | 835789 | 2020-12-16 | Goochland | Virginia | 51075 | 519 | 7 |
832543 | 832543 | 2020-12-15 | Goochland | Virginia | 51075 | 515 | 7 |
829296 | 829296 | 2020-12-14 | Goochland | Virginia | 51075 | 514 | 7 |
826050 | 826050 | 2020-12-13 | Goochland | Virginia | 51075 | 514 | 7 |
822803 | 822803 | 2020-12-12 | Goochland | Virginia | 51075 | 508 | 7 |
819557 | 819557 | 2020-12-11 | Goochland | Virginia | 51075 | 501 | 7 |
816311 | 816311 | 2020-12-10 | Goochland | Virginia | 51075 | 497 | 7 |
813065 | 813065 | 2020-12-09 | Goochland | Virginia | 51075 | 495 | 7 |
809821 | 809821 | 2020-12-08 | Goochland | Virginia | 51075 | 492 | 7 |
806576 | 806576 | 2020-12-07 | Goochland | Virginia | 51075 | 486 | 7 |
803331 | 803331 | 2020-12-06 | Goochland | Virginia | 51075 | 479 | 7 |
800086 | 800086 | 2020-12-05 | Goochland | Virginia | 51075 | 476 | 7 |
796841 | 796841 | 2020-12-04 | Goochland | Virginia | 51075 | 470 | 7 |
793596 | 793596 | 2020-12-03 | Goochland | Virginia | 51075 | 463 | 7 |
790351 | 790351 | 2020-12-02 | Goochland | Virginia | 51075 | 457 | 7 |
787106 | 787106 | 2020-12-01 | Goochland | Virginia | 51075 | 453 | 7 |
783862 | 783862 | 2020-11-30 | Goochland | Virginia | 51075 | 450 | 7 |
780617 | 780617 | 2020-11-29 | Goochland | Virginia | 51075 | 443 | 7 |
777371 | 777371 | 2020-11-28 | Goochland | Virginia | 51075 | 441 | 7 |
774126 | 774126 | 2020-11-27 | Goochland | Virginia | 51075 | 436 | 7 |
770881 | 770881 | 2020-11-26 | Goochland | Virginia | 51075 | 427 | 7 |
767635 | 767635 | 2020-11-25 | Goochland | Virginia | 51075 | 420 | 7 |
764390 | 764390 | 2020-11-24 | Goochland | Virginia | 51075 | 416 | 7 |
761145 | 761145 | 2020-11-23 | Goochland | Virginia | 51075 | 403 | 7 |
757900 | 757900 | 2020-11-22 | Goochland | Virginia | 51075 | 397 | 7 |
754653 | 754653 | 2020-11-21 | Goochland | Virginia | 51075 | 392 | 7 |
751407 | 751407 | 2020-11-20 | Goochland | Virginia | 51075 | 389 | 7 |
748161 | 748161 | 2020-11-19 | Goochland | Virginia | 51075 | 382 | 7 |
744915 | 744915 | 2020-11-18 | Goochland | Virginia | 51075 | 376 | 7 |
741668 | 741668 | 2020-11-17 | Goochland | Virginia | 51075 | 374 | 7 |
738421 | 738421 | 2020-11-16 | Goochland | Virginia | 51075 | 375 | 7 |
735177 | 735177 | 2020-11-15 | Goochland | Virginia | 51075 | 368 | 7 |
731931 | 731931 | 2020-11-14 | Goochland | Virginia | 51075 | 368 | 7 |
728686 | 728686 | 2020-11-13 | Goochland | Virginia | 51075 | 366 | 7 |
725443 | 725443 | 2020-11-12 | Goochland | Virginia | 51075 | 366 | 7 |
722200 | 722200 | 2020-11-11 | Goochland | Virginia | 51075 | 364 | 7 |
718957 | 718957 | 2020-11-10 | Goochland | Virginia | 51075 | 364 | 7 |
715714 | 715714 | 2020-11-09 | Goochland | Virginia | 51075 | 357 | 7 |
712470 | 712470 | 2020-11-08 | Goochland | Virginia | 51075 | 357 | 7 |
709226 | 709226 | 2020-11-07 | Goochland | Virginia | 51075 | 355 | 7 |
705982 | 705982 | 2020-11-06 | Goochland | Virginia | 51075 | 350 | 7 |
702739 | 702739 | 2020-11-05 | Goochland | Virginia | 51075 | 346 | 7 |
699496 | 699496 | 2020-11-04 | Goochland | Virginia | 51075 | 341 | 7 |
696252 | 696252 | 2020-11-03 | Goochland | Virginia | 51075 | 341 | 7 |
693010 | 693010 | 2020-11-02 | Goochland | Virginia | 51075 | 340 | 7 |
689766 | 689766 | 2020-11-01 | Goochland | Virginia | 51075 | 340 | 7 |
686521 | 686521 | 2020-10-31 | Goochland | Virginia | 51075 | 335 | 7 |
683278 | 683278 | 2020-10-30 | Goochland | Virginia | 51075 | 331 | 7 |
680035 | 680035 | 2020-10-29 | Goochland | Virginia | 51075 | 331 | 7 |
676792 | 676792 | 2020-10-28 | Goochland | Virginia | 51075 | 330 | 7 |
673549 | 673549 | 2020-10-27 | Goochland | Virginia | 51075 | 328 | 7 |
670307 | 670307 | 2020-10-26 | Goochland | Virginia | 51075 | 327 | 7 |
667064 | 667064 | 2020-10-25 | Goochland | Virginia | 51075 | 326 | 7 |
663819 | 663819 | 2020-10-24 | Goochland | Virginia | 51075 | 324 | 7 |
660575 | 660575 | 2020-10-23 | Goochland | Virginia | 51075 | 321 | 7 |
657331 | 657331 | 2020-10-22 | Goochland | Virginia | 51075 | 319 | 7 |
654086 | 654086 | 2020-10-21 | Goochland | Virginia | 51075 | 315 | 7 |
650841 | 650841 | 2020-10-20 | Goochland | Virginia | 51075 | 312 | 7 |
647597 | 647597 | 2020-10-19 | Goochland | Virginia | 51075 | 309 | 7 |
644351 | 644351 | 2020-10-18 | Goochland | Virginia | 51075 | 309 | 7 |
641103 | 641103 | 2020-10-17 | Goochland | Virginia | 51075 | 306 | 7 |
637856 | 637856 | 2020-10-16 | Goochland | Virginia | 51075 | 305 | 7 |
634611 | 634611 | 2020-10-15 | Goochland | Virginia | 51075 | 306 | 7 |
631366 | 631366 | 2020-10-14 | Goochland | Virginia | 51075 | 305 | 7 |
628122 | 628122 | 2020-10-13 | Goochland | Virginia | 51075 | 305 | 7 |
624879 | 624879 | 2020-10-12 | Goochland | Virginia | 51075 | 301 | 7 |
621636 | 621636 | 2020-10-11 | Goochland | Virginia | 51075 | 300 | 7 |
618393 | 618393 | 2020-10-10 | Goochland | Virginia | 51075 | 296 | 7 |
615151 | 615151 | 2020-10-09 | Goochland | Virginia | 51075 | 294 | 7 |
611910 | 611910 | 2020-10-08 | Goochland | Virginia | 51075 | 290 | 7 |
608668 | 608668 | 2020-10-07 | Goochland | Virginia | 51075 | 287 | 7 |
605425 | 605425 | 2020-10-06 | Goochland | Virginia | 51075 | 287 | 7 |
602183 | 602183 | 2020-10-05 | Goochland | Virginia | 51075 | 285 | 7 |
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);