ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Troup" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
933949 | 933949 | 2021-01-16 | Troup | Georgia | 13285 | 5922 | 144 |
930704 | 930704 | 2021-01-15 | Troup | Georgia | 13285 | 5861 | 142 |
927459 | 927459 | 2021-01-14 | Troup | Georgia | 13285 | 5793 | 140 |
924213 | 924213 | 2021-01-13 | Troup | Georgia | 13285 | 5739 | 139 |
920968 | 920968 | 2021-01-12 | Troup | Georgia | 13285 | 5680 | 133 |
917723 | 917723 | 2021-01-11 | Troup | Georgia | 13285 | 5621 | 132 |
914478 | 914478 | 2021-01-10 | Troup | Georgia | 13285 | 5568 | 132 |
911233 | 911233 | 2021-01-09 | Troup | Georgia | 13285 | 5516 | 132 |
907988 | 907988 | 2021-01-08 | Troup | Georgia | 13285 | 5464 | 131 |
904742 | 904742 | 2021-01-07 | Troup | Georgia | 13285 | 5332 | 130 |
901497 | 901497 | 2021-01-06 | Troup | Georgia | 13285 | 5288 | 130 |
898252 | 898252 | 2021-01-05 | Troup | Georgia | 13285 | 5266 | 129 |
895007 | 895007 | 2021-01-04 | Troup | Georgia | 13285 | 5190 | 128 |
891760 | 891760 | 2021-01-03 | Troup | Georgia | 13285 | 5164 | 128 |
888513 | 888513 | 2021-01-02 | Troup | Georgia | 13285 | 5108 | 128 |
885268 | 885268 | 2021-01-01 | Troup | Georgia | 13285 | 5058 | 128 |
882023 | 882023 | 2020-12-31 | Troup | Georgia | 13285 | 5013 | 128 |
878778 | 878778 | 2020-12-30 | Troup | Georgia | 13285 | 4958 | 127 |
875533 | 875533 | 2020-12-29 | Troup | Georgia | 13285 | 4915 | 127 |
872288 | 872288 | 2020-12-28 | Troup | Georgia | 13285 | 4861 | 127 |
869043 | 869043 | 2020-12-27 | Troup | Georgia | 13285 | 4853 | 127 |
865798 | 865798 | 2020-12-26 | Troup | Georgia | 13285 | 4835 | 127 |
862553 | 862553 | 2020-12-25 | Troup | Georgia | 13285 | 4797 | 127 |
859308 | 859308 | 2020-12-24 | Troup | Georgia | 13285 | 4765 | 127 |
856063 | 856063 | 2020-12-23 | Troup | Georgia | 13285 | 4710 | 127 |
852818 | 852818 | 2020-12-22 | Troup | Georgia | 13285 | 4675 | 127 |
849573 | 849573 | 2020-12-21 | Troup | Georgia | 13285 | 4629 | 127 |
846328 | 846328 | 2020-12-20 | Troup | Georgia | 13285 | 4596 | 127 |
843082 | 843082 | 2020-12-19 | Troup | Georgia | 13285 | 4565 | 127 |
839837 | 839837 | 2020-12-18 | Troup | Georgia | 13285 | 4543 | 127 |
836592 | 836592 | 2020-12-17 | Troup | Georgia | 13285 | 4497 | 127 |
833346 | 833346 | 2020-12-16 | Troup | Georgia | 13285 | 4443 | 127 |
830099 | 830099 | 2020-12-15 | Troup | Georgia | 13285 | 4393 | 126 |
826853 | 826853 | 2020-12-14 | Troup | Georgia | 13285 | 4348 | 126 |
823606 | 823606 | 2020-12-13 | Troup | Georgia | 13285 | 4335 | 126 |
820360 | 820360 | 2020-12-12 | Troup | Georgia | 13285 | 4310 | 126 |
817114 | 817114 | 2020-12-11 | Troup | Georgia | 13285 | 4267 | 126 |
813868 | 813868 | 2020-12-10 | Troup | Georgia | 13285 | 4243 | 126 |
810624 | 810624 | 2020-12-09 | Troup | Georgia | 13285 | 4204 | 126 |
807379 | 807379 | 2020-12-08 | Troup | Georgia | 13285 | 4164 | 126 |
804134 | 804134 | 2020-12-07 | Troup | Georgia | 13285 | 4132 | 126 |
800889 | 800889 | 2020-12-06 | Troup | Georgia | 13285 | 4100 | 126 |
797644 | 797644 | 2020-12-05 | Troup | Georgia | 13285 | 4082 | 126 |
794399 | 794399 | 2020-12-04 | Troup | Georgia | 13285 | 4052 | 125 |
791154 | 791154 | 2020-12-03 | Troup | Georgia | 13285 | 4034 | 125 |
787909 | 787909 | 2020-12-02 | Troup | Georgia | 13285 | 4012 | 121 |
784665 | 784665 | 2020-12-01 | Troup | Georgia | 13285 | 3973 | 120 |
781420 | 781420 | 2020-11-30 | Troup | Georgia | 13285 | 3945 | 120 |
778174 | 778174 | 2020-11-29 | Troup | Georgia | 13285 | 3926 | 120 |
774929 | 774929 | 2020-11-28 | Troup | Georgia | 13285 | 3922 | 120 |
771684 | 771684 | 2020-11-27 | Troup | Georgia | 13285 | 3913 | 120 |
768439 | 768439 | 2020-11-26 | Troup | Georgia | 13285 | 3901 | 120 |
765193 | 765193 | 2020-11-25 | Troup | Georgia | 13285 | 3876 | 119 |
761948 | 761948 | 2020-11-24 | Troup | Georgia | 13285 | 3858 | 119 |
758703 | 758703 | 2020-11-23 | Troup | Georgia | 13285 | 3845 | 119 |
755456 | 755456 | 2020-11-22 | Troup | Georgia | 13285 | 3843 | 119 |
752210 | 752210 | 2020-11-21 | Troup | Georgia | 13285 | 3837 | 118 |
748964 | 748964 | 2020-11-20 | Troup | Georgia | 13285 | 3798 | 117 |
745718 | 745718 | 2020-11-19 | Troup | Georgia | 13285 | 3776 | 117 |
742471 | 742471 | 2020-11-18 | Troup | Georgia | 13285 | 3757 | 117 |
739224 | 739224 | 2020-11-17 | Troup | Georgia | 13285 | 3742 | 116 |
735980 | 735980 | 2020-11-16 | Troup | Georgia | 13285 | 3734 | 116 |
732734 | 732734 | 2020-11-15 | Troup | Georgia | 13285 | 3727 | 116 |
729489 | 729489 | 2020-11-14 | Troup | Georgia | 13285 | 3705 | 115 |
726246 | 726246 | 2020-11-13 | Troup | Georgia | 13285 | 3688 | 115 |
723003 | 723003 | 2020-11-12 | Troup | Georgia | 13285 | 3673 | 115 |
719760 | 719760 | 2020-11-11 | Troup | Georgia | 13285 | 3653 | 114 |
716517 | 716517 | 2020-11-10 | Troup | Georgia | 13285 | 3634 | 113 |
713273 | 713273 | 2020-11-09 | Troup | Georgia | 13285 | 3580 | 113 |
710029 | 710029 | 2020-11-08 | Troup | Georgia | 13285 | 3578 | 113 |
706785 | 706785 | 2020-11-07 | Troup | Georgia | 13285 | 3565 | 113 |
703542 | 703542 | 2020-11-06 | Troup | Georgia | 13285 | 3556 | 113 |
700299 | 700299 | 2020-11-05 | Troup | Georgia | 13285 | 3543 | 114 |
697055 | 697055 | 2020-11-04 | Troup | Georgia | 13285 | 3535 | 113 |
693813 | 693813 | 2020-11-03 | Troup | Georgia | 13285 | 3512 | 110 |
690570 | 690570 | 2020-11-02 | Troup | Georgia | 13285 | 3501 | 109 |
687325 | 687325 | 2020-11-01 | Troup | Georgia | 13285 | 3466 | 109 |
684081 | 684081 | 2020-10-31 | Troup | Georgia | 13285 | 3465 | 109 |
680838 | 680838 | 2020-10-30 | Troup | Georgia | 13285 | 3461 | 109 |
677595 | 677595 | 2020-10-29 | Troup | Georgia | 13285 | 3451 | 109 |
674352 | 674352 | 2020-10-28 | Troup | Georgia | 13285 | 3465 | 108 |
671110 | 671110 | 2020-10-27 | Troup | Georgia | 13285 | 3453 | 107 |
667867 | 667867 | 2020-10-26 | Troup | Georgia | 13285 | 3441 | 106 |
664622 | 664622 | 2020-10-25 | Troup | Georgia | 13285 | 3394 | 106 |
661378 | 661378 | 2020-10-24 | Troup | Georgia | 13285 | 3372 | 106 |
658134 | 658134 | 2020-10-23 | Troup | Georgia | 13285 | 3361 | 106 |
654889 | 654889 | 2020-10-22 | Troup | Georgia | 13285 | 3348 | 106 |
651644 | 651644 | 2020-10-21 | Troup | Georgia | 13285 | 3340 | 106 |
648400 | 648400 | 2020-10-20 | Troup | Georgia | 13285 | 3333 | 106 |
645155 | 645155 | 2020-10-19 | Troup | Georgia | 13285 | 3324 | 106 |
641907 | 641907 | 2020-10-18 | Troup | Georgia | 13285 | 3301 | 104 |
638660 | 638660 | 2020-10-17 | Troup | Georgia | 13285 | 3292 | 104 |
635415 | 635415 | 2020-10-16 | Troup | Georgia | 13285 | 3289 | 104 |
632169 | 632169 | 2020-10-15 | Troup | Georgia | 13285 | 3282 | 104 |
628925 | 628925 | 2020-10-14 | Troup | Georgia | 13285 | 3266 | 103 |
625682 | 625682 | 2020-10-13 | Troup | Georgia | 13285 | 3248 | 103 |
622439 | 622439 | 2020-10-12 | Troup | Georgia | 13285 | 3242 | 103 |
619196 | 619196 | 2020-10-11 | Troup | Georgia | 13285 | 3207 | 103 |
615954 | 615954 | 2020-10-10 | Troup | Georgia | 13285 | 3195 | 103 |
612713 | 612713 | 2020-10-09 | Troup | Georgia | 13285 | 3193 | 103 |
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);