ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Jasper" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1073447 | 1073447 | 2021-02-28 | Jasper | Georgia | 13159 | 1299 | 33 |
1070201 | 1070201 | 2021-02-27 | Jasper | Georgia | 13159 | 1297 | 33 |
1066956 | 1066956 | 2021-02-26 | Jasper | Georgia | 13159 | 1295 | 32 |
1063711 | 1063711 | 2021-02-25 | Jasper | Georgia | 13159 | 1289 | 32 |
1060466 | 1060466 | 2021-02-24 | Jasper | Georgia | 13159 | 1282 | 32 |
1057220 | 1057220 | 2021-02-23 | Jasper | Georgia | 13159 | 1278 | 30 |
1053974 | 1053974 | 2021-02-22 | Jasper | Georgia | 13159 | 1269 | 30 |
1050727 | 1050727 | 2021-02-21 | Jasper | Georgia | 13159 | 1266 | 30 |
1047480 | 1047480 | 2021-02-20 | Jasper | Georgia | 13159 | 1265 | 30 |
1044235 | 1044235 | 2021-02-19 | Jasper | Georgia | 13159 | 1261 | 30 |
1040990 | 1040990 | 2021-02-18 | Jasper | Georgia | 13159 | 1258 | 30 |
1037745 | 1037745 | 2021-02-17 | Jasper | Georgia | 13159 | 1255 | 30 |
1034500 | 1034500 | 2021-02-16 | Jasper | Georgia | 13159 | 1247 | 29 |
1031254 | 1031254 | 2021-02-15 | Jasper | Georgia | 13159 | 1244 | 29 |
1028007 | 1028007 | 2021-02-14 | Jasper | Georgia | 13159 | 1240 | 28 |
1024762 | 1024762 | 2021-02-13 | Jasper | Georgia | 13159 | 1236 | 28 |
1021517 | 1021517 | 2021-02-12 | Jasper | Georgia | 13159 | 1231 | 28 |
1018272 | 1018272 | 2021-02-11 | Jasper | Georgia | 13159 | 1223 | 28 |
1015027 | 1015027 | 2021-02-10 | Jasper | Georgia | 13159 | 1215 | 27 |
1011782 | 1011782 | 2021-02-09 | Jasper | Georgia | 13159 | 1211 | 27 |
1008536 | 1008536 | 2021-02-08 | Jasper | Georgia | 13159 | 1206 | 27 |
1005290 | 1005290 | 2021-02-07 | Jasper | Georgia | 13159 | 1202 | 27 |
1002044 | 1002044 | 2021-02-06 | Jasper | Georgia | 13159 | 1198 | 27 |
998798 | 998798 | 2021-02-05 | Jasper | Georgia | 13159 | 1195 | 27 |
995552 | 995552 | 2021-02-04 | Jasper | Georgia | 13159 | 1192 | 27 |
992306 | 992306 | 2021-02-03 | Jasper | Georgia | 13159 | 1188 | 27 |
989060 | 989060 | 2021-02-02 | Jasper | Georgia | 13159 | 1179 | 27 |
985813 | 985813 | 2021-02-01 | Jasper | Georgia | 13159 | 1170 | 27 |
982566 | 982566 | 2021-01-31 | Jasper | Georgia | 13159 | 1168 | 27 |
979320 | 979320 | 2021-01-30 | Jasper | Georgia | 13159 | 1164 | 27 |
976075 | 976075 | 2021-01-29 | Jasper | Georgia | 13159 | 1156 | 25 |
972830 | 972830 | 2021-01-28 | Jasper | Georgia | 13159 | 1149 | 24 |
969585 | 969585 | 2021-01-27 | Jasper | Georgia | 13159 | 1141 | 23 |
966341 | 966341 | 2021-01-26 | Jasper | Georgia | 13159 | 1136 | 23 |
963096 | 963096 | 2021-01-25 | Jasper | Georgia | 13159 | 1117 | 23 |
959851 | 959851 | 2021-01-24 | Jasper | Georgia | 13159 | 1112 | 23 |
956605 | 956605 | 2021-01-23 | Jasper | Georgia | 13159 | 1110 | 23 |
953360 | 953360 | 2021-01-22 | Jasper | Georgia | 13159 | 1100 | 20 |
950115 | 950115 | 2021-01-21 | Jasper | Georgia | 13159 | 1093 | 20 |
946869 | 946869 | 2021-01-20 | Jasper | Georgia | 13159 | 1083 | 20 |
943622 | 943622 | 2021-01-19 | Jasper | Georgia | 13159 | 1072 | 18 |
940377 | 940377 | 2021-01-18 | Jasper | Georgia | 13159 | 1063 | 17 |
937132 | 937132 | 2021-01-17 | Jasper | Georgia | 13159 | 1058 | 16 |
933887 | 933887 | 2021-01-16 | Jasper | Georgia | 13159 | 1050 | 16 |
930642 | 930642 | 2021-01-15 | Jasper | Georgia | 13159 | 1041 | 16 |
927397 | 927397 | 2021-01-14 | Jasper | Georgia | 13159 | 1031 | 15 |
924151 | 924151 | 2021-01-13 | Jasper | Georgia | 13159 | 1021 | 15 |
920906 | 920906 | 2021-01-12 | Jasper | Georgia | 13159 | 1006 | 14 |
917661 | 917661 | 2021-01-11 | Jasper | Georgia | 13159 | 997 | 14 |
914416 | 914416 | 2021-01-10 | Jasper | Georgia | 13159 | 988 | 14 |
911171 | 911171 | 2021-01-09 | Jasper | Georgia | 13159 | 976 | 14 |
907926 | 907926 | 2021-01-08 | Jasper | Georgia | 13159 | 949 | 11 |
904680 | 904680 | 2021-01-07 | Jasper | Georgia | 13159 | 930 | 11 |
901435 | 901435 | 2021-01-06 | Jasper | Georgia | 13159 | 917 | 11 |
898190 | 898190 | 2021-01-05 | Jasper | Georgia | 13159 | 901 | 11 |
894945 | 894945 | 2021-01-04 | Jasper | Georgia | 13159 | 874 | 9 |
891698 | 891698 | 2021-01-03 | Jasper | Georgia | 13159 | 866 | 9 |
888451 | 888451 | 2021-01-02 | Jasper | Georgia | 13159 | 858 | 9 |
885206 | 885206 | 2021-01-01 | Jasper | Georgia | 13159 | 843 | 9 |
881961 | 881961 | 2020-12-31 | Jasper | Georgia | 13159 | 828 | 9 |
878716 | 878716 | 2020-12-30 | Jasper | Georgia | 13159 | 812 | 7 |
875471 | 875471 | 2020-12-29 | Jasper | Georgia | 13159 | 798 | 7 |
872226 | 872226 | 2020-12-28 | Jasper | Georgia | 13159 | 778 | 7 |
868981 | 868981 | 2020-12-27 | Jasper | Georgia | 13159 | 778 | 7 |
865736 | 865736 | 2020-12-26 | Jasper | Georgia | 13159 | 773 | 7 |
862491 | 862491 | 2020-12-25 | Jasper | Georgia | 13159 | 765 | 7 |
859246 | 859246 | 2020-12-24 | Jasper | Georgia | 13159 | 756 | 7 |
856001 | 856001 | 2020-12-23 | Jasper | Georgia | 13159 | 739 | 7 |
852756 | 852756 | 2020-12-22 | Jasper | Georgia | 13159 | 718 | 7 |
849511 | 849511 | 2020-12-21 | Jasper | Georgia | 13159 | 708 | 7 |
846266 | 846266 | 2020-12-20 | Jasper | Georgia | 13159 | 705 | 7 |
843020 | 843020 | 2020-12-19 | Jasper | Georgia | 13159 | 693 | 7 |
839775 | 839775 | 2020-12-18 | Jasper | Georgia | 13159 | 686 | 7 |
836530 | 836530 | 2020-12-17 | Jasper | Georgia | 13159 | 669 | 7 |
833284 | 833284 | 2020-12-16 | Jasper | Georgia | 13159 | 659 | 7 |
830037 | 830037 | 2020-12-15 | Jasper | Georgia | 13159 | 646 | 7 |
826791 | 826791 | 2020-12-14 | Jasper | Georgia | 13159 | 623 | 7 |
823544 | 823544 | 2020-12-13 | Jasper | Georgia | 13159 | 616 | 7 |
820298 | 820298 | 2020-12-12 | Jasper | Georgia | 13159 | 611 | 7 |
817052 | 817052 | 2020-12-11 | Jasper | Georgia | 13159 | 601 | 7 |
813806 | 813806 | 2020-12-10 | Jasper | Georgia | 13159 | 592 | 7 |
810562 | 810562 | 2020-12-09 | Jasper | Georgia | 13159 | 582 | 7 |
807317 | 807317 | 2020-12-08 | Jasper | Georgia | 13159 | 565 | 7 |
804072 | 804072 | 2020-12-07 | Jasper | Georgia | 13159 | 550 | 7 |
800827 | 800827 | 2020-12-06 | Jasper | Georgia | 13159 | 545 | 7 |
797582 | 797582 | 2020-12-05 | Jasper | Georgia | 13159 | 542 | 7 |
794337 | 794337 | 2020-12-04 | Jasper | Georgia | 13159 | 533 | 7 |
791092 | 791092 | 2020-12-03 | Jasper | Georgia | 13159 | 520 | 7 |
787847 | 787847 | 2020-12-02 | Jasper | Georgia | 13159 | 511 | 7 |
784603 | 784603 | 2020-12-01 | Jasper | Georgia | 13159 | 496 | 7 |
781358 | 781358 | 2020-11-30 | Jasper | Georgia | 13159 | 481 | 7 |
778112 | 778112 | 2020-11-29 | Jasper | Georgia | 13159 | 478 | 6 |
774867 | 774867 | 2020-11-28 | Jasper | Georgia | 13159 | 474 | 6 |
771622 | 771622 | 2020-11-27 | Jasper | Georgia | 13159 | 470 | 6 |
768377 | 768377 | 2020-11-26 | Jasper | Georgia | 13159 | 464 | 6 |
765131 | 765131 | 2020-11-25 | Jasper | Georgia | 13159 | 460 | 6 |
761886 | 761886 | 2020-11-24 | Jasper | Georgia | 13159 | 447 | 6 |
758641 | 758641 | 2020-11-23 | Jasper | Georgia | 13159 | 441 | 6 |
755394 | 755394 | 2020-11-22 | Jasper | Georgia | 13159 | 440 | 6 |
752148 | 752148 | 2020-11-21 | Jasper | Georgia | 13159 | 440 | 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);