ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Union" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917726 | 917726 | 2021-01-11 | Union | Georgia | 13291 | 1636 | 46 |
914481 | 914481 | 2021-01-10 | Union | Georgia | 13291 | 1618 | 46 |
911236 | 911236 | 2021-01-09 | Union | Georgia | 13291 | 1610 | 46 |
907991 | 907991 | 2021-01-08 | Union | Georgia | 13291 | 1590 | 44 |
904745 | 904745 | 2021-01-07 | Union | Georgia | 13291 | 1567 | 44 |
901500 | 901500 | 2021-01-06 | Union | Georgia | 13291 | 1538 | 43 |
898255 | 898255 | 2021-01-05 | Union | Georgia | 13291 | 1531 | 43 |
895010 | 895010 | 2021-01-04 | Union | Georgia | 13291 | 1521 | 42 |
891763 | 891763 | 2021-01-03 | Union | Georgia | 13291 | 1506 | 42 |
888516 | 888516 | 2021-01-02 | Union | Georgia | 13291 | 1479 | 42 |
885271 | 885271 | 2021-01-01 | Union | Georgia | 13291 | 1467 | 42 |
882026 | 882026 | 2020-12-31 | Union | Georgia | 13291 | 1432 | 42 |
878781 | 878781 | 2020-12-30 | Union | Georgia | 13291 | 1411 | 42 |
875536 | 875536 | 2020-12-29 | Union | Georgia | 13291 | 1392 | 42 |
872291 | 872291 | 2020-12-28 | Union | Georgia | 13291 | 1384 | 42 |
869046 | 869046 | 2020-12-27 | Union | Georgia | 13291 | 1375 | 42 |
865801 | 865801 | 2020-12-26 | Union | Georgia | 13291 | 1359 | 42 |
862556 | 862556 | 2020-12-25 | Union | Georgia | 13291 | 1356 | 42 |
859311 | 859311 | 2020-12-24 | Union | Georgia | 13291 | 1354 | 42 |
856066 | 856066 | 2020-12-23 | Union | Georgia | 13291 | 1330 | 42 |
852821 | 852821 | 2020-12-22 | Union | Georgia | 13291 | 1310 | 41 |
849576 | 849576 | 2020-12-21 | Union | Georgia | 13291 | 1303 | 41 |
846331 | 846331 | 2020-12-20 | Union | Georgia | 13291 | 1297 | 41 |
843085 | 843085 | 2020-12-19 | Union | Georgia | 13291 | 1281 | 41 |
839840 | 839840 | 2020-12-18 | Union | Georgia | 13291 | 1265 | 41 |
836595 | 836595 | 2020-12-17 | Union | Georgia | 13291 | 1246 | 40 |
833349 | 833349 | 2020-12-16 | Union | Georgia | 13291 | 1236 | 40 |
830102 | 830102 | 2020-12-15 | Union | Georgia | 13291 | 1231 | 39 |
826856 | 826856 | 2020-12-14 | Union | Georgia | 13291 | 1221 | 40 |
823609 | 823609 | 2020-12-13 | Union | Georgia | 13291 | 1219 | 40 |
820363 | 820363 | 2020-12-12 | Union | Georgia | 13291 | 1215 | 40 |
817117 | 817117 | 2020-12-11 | Union | Georgia | 13291 | 1209 | 40 |
813871 | 813871 | 2020-12-10 | Union | Georgia | 13291 | 1194 | 40 |
810627 | 810627 | 2020-12-09 | Union | Georgia | 13291 | 1180 | 39 |
807382 | 807382 | 2020-12-08 | Union | Georgia | 13291 | 1169 | 38 |
804137 | 804137 | 2020-12-07 | Union | Georgia | 13291 | 1149 | 38 |
800892 | 800892 | 2020-12-06 | Union | Georgia | 13291 | 1140 | 38 |
797647 | 797647 | 2020-12-05 | Union | Georgia | 13291 | 1139 | 38 |
794402 | 794402 | 2020-12-04 | Union | Georgia | 13291 | 1135 | 38 |
791157 | 791157 | 2020-12-03 | Union | Georgia | 13291 | 1124 | 36 |
787912 | 787912 | 2020-12-02 | Union | Georgia | 13291 | 1116 | 36 |
784668 | 784668 | 2020-12-01 | Union | Georgia | 13291 | 1105 | 36 |
781423 | 781423 | 2020-11-30 | Union | Georgia | 13291 | 1091 | 36 |
778177 | 778177 | 2020-11-29 | Union | Georgia | 13291 | 1081 | 36 |
774932 | 774932 | 2020-11-28 | Union | Georgia | 13291 | 1080 | 36 |
771687 | 771687 | 2020-11-27 | Union | Georgia | 13291 | 1071 | 36 |
768442 | 768442 | 2020-11-26 | Union | Georgia | 13291 | 1068 | 35 |
765196 | 765196 | 2020-11-25 | Union | Georgia | 13291 | 1065 | 35 |
761951 | 761951 | 2020-11-24 | Union | Georgia | 13291 | 1054 | 34 |
758706 | 758706 | 2020-11-23 | Union | Georgia | 13291 | 1049 | 34 |
755459 | 755459 | 2020-11-22 | Union | Georgia | 13291 | 1044 | 34 |
752213 | 752213 | 2020-11-21 | Union | Georgia | 13291 | 1040 | 34 |
748967 | 748967 | 2020-11-20 | Union | Georgia | 13291 | 1036 | 33 |
745721 | 745721 | 2020-11-19 | Union | Georgia | 13291 | 1028 | 33 |
742474 | 742474 | 2020-11-18 | Union | Georgia | 13291 | 1024 | 32 |
739227 | 739227 | 2020-11-17 | Union | Georgia | 13291 | 1015 | 32 |
735983 | 735983 | 2020-11-16 | Union | Georgia | 13291 | 997 | 32 |
732737 | 732737 | 2020-11-15 | Union | Georgia | 13291 | 994 | 32 |
729492 | 729492 | 2020-11-14 | Union | Georgia | 13291 | 992 | 32 |
726249 | 726249 | 2020-11-13 | Union | Georgia | 13291 | 990 | 32 |
723006 | 723006 | 2020-11-12 | Union | Georgia | 13291 | 979 | 32 |
719763 | 719763 | 2020-11-11 | Union | Georgia | 13291 | 975 | 32 |
716520 | 716520 | 2020-11-10 | Union | Georgia | 13291 | 968 | 31 |
713276 | 713276 | 2020-11-09 | Union | Georgia | 13291 | 958 | 31 |
710032 | 710032 | 2020-11-08 | Union | Georgia | 13291 | 958 | 30 |
706788 | 706788 | 2020-11-07 | Union | Georgia | 13291 | 957 | 30 |
703545 | 703545 | 2020-11-06 | Union | Georgia | 13291 | 952 | 30 |
700302 | 700302 | 2020-11-05 | Union | Georgia | 13291 | 945 | 30 |
697058 | 697058 | 2020-11-04 | Union | Georgia | 13291 | 938 | 30 |
693816 | 693816 | 2020-11-03 | Union | Georgia | 13291 | 932 | 28 |
690573 | 690573 | 2020-11-02 | Union | Georgia | 13291 | 921 | 27 |
687328 | 687328 | 2020-11-01 | Union | Georgia | 13291 | 918 | 26 |
684084 | 684084 | 2020-10-31 | Union | Georgia | 13291 | 917 | 26 |
680841 | 680841 | 2020-10-30 | Union | Georgia | 13291 | 913 | 26 |
677598 | 677598 | 2020-10-29 | Union | Georgia | 13291 | 901 | 26 |
674355 | 674355 | 2020-10-28 | Union | Georgia | 13291 | 896 | 26 |
671113 | 671113 | 2020-10-27 | Union | Georgia | 13291 | 892 | 25 |
667870 | 667870 | 2020-10-26 | Union | Georgia | 13291 | 889 | 25 |
664625 | 664625 | 2020-10-25 | Union | Georgia | 13291 | 887 | 25 |
661381 | 661381 | 2020-10-24 | Union | Georgia | 13291 | 885 | 25 |
658137 | 658137 | 2020-10-23 | Union | Georgia | 13291 | 880 | 25 |
654892 | 654892 | 2020-10-22 | Union | Georgia | 13291 | 876 | 25 |
651647 | 651647 | 2020-10-21 | Union | Georgia | 13291 | 868 | 25 |
648403 | 648403 | 2020-10-20 | Union | Georgia | 13291 | 867 | 25 |
645158 | 645158 | 2020-10-19 | Union | Georgia | 13291 | 864 | 25 |
641910 | 641910 | 2020-10-18 | Union | Georgia | 13291 | 861 | 25 |
638663 | 638663 | 2020-10-17 | Union | Georgia | 13291 | 858 | 24 |
635418 | 635418 | 2020-10-16 | Union | Georgia | 13291 | 856 | 23 |
632172 | 632172 | 2020-10-15 | Union | Georgia | 13291 | 854 | 23 |
628928 | 628928 | 2020-10-14 | Union | Georgia | 13291 | 852 | 23 |
625685 | 625685 | 2020-10-13 | Union | Georgia | 13291 | 848 | 23 |
622442 | 622442 | 2020-10-12 | Union | Georgia | 13291 | 843 | 22 |
619199 | 619199 | 2020-10-11 | Union | Georgia | 13291 | 844 | 22 |
615957 | 615957 | 2020-10-10 | Union | Georgia | 13291 | 845 | 22 |
612716 | 612716 | 2020-10-09 | Union | Georgia | 13291 | 843 | 22 |
609474 | 609474 | 2020-10-08 | Union | Georgia | 13291 | 837 | 21 |
606231 | 606231 | 2020-10-07 | Union | Georgia | 13291 | 836 | 21 |
602989 | 602989 | 2020-10-06 | Union | Georgia | 13291 | 825 | 21 |
599746 | 599746 | 2020-10-05 | Union | Georgia | 13291 | 808 | 21 |
596503 | 596503 | 2020-10-04 | Union | Georgia | 13291 | 803 | 21 |
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);