ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Clay" and fips = 1027 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1047025 | 1047025 | 2021-02-20 | Clay | Alabama | 1027 | 1416 | 54 |
1043780 | 1043780 | 2021-02-19 | Clay | Alabama | 1027 | 1409 | 54 |
1040535 | 1040535 | 2021-02-18 | Clay | Alabama | 1027 | 1407 | 53 |
1037290 | 1037290 | 2021-02-17 | Clay | Alabama | 1027 | 1403 | 53 |
1034045 | 1034045 | 2021-02-16 | Clay | Alabama | 1027 | 1399 | 53 |
1030799 | 1030799 | 2021-02-15 | Clay | Alabama | 1027 | 1394 | 53 |
1027552 | 1027552 | 2021-02-14 | Clay | Alabama | 1027 | 1393 | 53 |
1024307 | 1024307 | 2021-02-13 | Clay | Alabama | 1027 | 1390 | 53 |
1021062 | 1021062 | 2021-02-12 | Clay | Alabama | 1027 | 1389 | 53 |
1017817 | 1017817 | 2021-02-11 | Clay | Alabama | 1027 | 1386 | 53 |
1014572 | 1014572 | 2021-02-10 | Clay | Alabama | 1027 | 1372 | 52 |
1011327 | 1011327 | 2021-02-09 | Clay | Alabama | 1027 | 1371 | 52 |
1008081 | 1008081 | 2021-02-08 | Clay | Alabama | 1027 | 1362 | 52 |
1004835 | 1004835 | 2021-02-07 | Clay | Alabama | 1027 | 1360 | 52 |
1001589 | 1001589 | 2021-02-06 | Clay | Alabama | 1027 | 1354 | 52 |
998343 | 998343 | 2021-02-05 | Clay | Alabama | 1027 | 1345 | 51 |
995097 | 995097 | 2021-02-04 | Clay | Alabama | 1027 | 1343 | 51 |
991851 | 991851 | 2021-02-03 | Clay | Alabama | 1027 | 1334 | 50 |
988605 | 988605 | 2021-02-02 | Clay | Alabama | 1027 | 1333 | 50 |
985358 | 985358 | 2021-02-01 | Clay | Alabama | 1027 | 1330 | 50 |
982111 | 982111 | 2021-01-31 | Clay | Alabama | 1027 | 1328 | 50 |
978865 | 978865 | 2021-01-30 | Clay | Alabama | 1027 | 1323 | 50 |
975620 | 975620 | 2021-01-29 | Clay | Alabama | 1027 | 1323 | 50 |
972375 | 972375 | 2021-01-28 | Clay | Alabama | 1027 | 1319 | 50 |
969130 | 969130 | 2021-01-27 | Clay | Alabama | 1027 | 1316 | 50 |
965886 | 965886 | 2021-01-26 | Clay | Alabama | 1027 | 1310 | 50 |
962641 | 962641 | 2021-01-25 | Clay | Alabama | 1027 | 1307 | 46 |
959396 | 959396 | 2021-01-24 | Clay | Alabama | 1027 | 1305 | 46 |
956150 | 956150 | 2021-01-23 | Clay | Alabama | 1027 | 1297 | 46 |
952905 | 952905 | 2021-01-22 | Clay | Alabama | 1027 | 1291 | 46 |
949660 | 949660 | 2021-01-21 | Clay | Alabama | 1027 | 1285 | 46 |
946414 | 946414 | 2021-01-20 | Clay | Alabama | 1027 | 1276 | 45 |
943167 | 943167 | 2021-01-19 | Clay | Alabama | 1027 | 1270 | 45 |
939922 | 939922 | 2021-01-18 | Clay | Alabama | 1027 | 1267 | 45 |
936677 | 936677 | 2021-01-17 | Clay | Alabama | 1027 | 1261 | 45 |
933432 | 933432 | 2021-01-16 | Clay | Alabama | 1027 | 1261 | 45 |
930187 | 930187 | 2021-01-15 | Clay | Alabama | 1027 | 1252 | 46 |
926942 | 926942 | 2021-01-14 | Clay | Alabama | 1027 | 1244 | 46 |
923696 | 923696 | 2021-01-13 | Clay | Alabama | 1027 | 1237 | 43 |
920451 | 920451 | 2021-01-12 | Clay | Alabama | 1027 | 1231 | 36 |
917206 | 917206 | 2021-01-11 | Clay | Alabama | 1027 | 1233 | 35 |
913961 | 913961 | 2021-01-10 | Clay | Alabama | 1027 | 1230 | 35 |
910716 | 910716 | 2021-01-09 | Clay | Alabama | 1027 | 1223 | 35 |
907471 | 907471 | 2021-01-08 | Clay | Alabama | 1027 | 1211 | 35 |
904225 | 904225 | 2021-01-07 | Clay | Alabama | 1027 | 1196 | 34 |
900980 | 900980 | 2021-01-06 | Clay | Alabama | 1027 | 1184 | 34 |
897735 | 897735 | 2021-01-05 | Clay | Alabama | 1027 | 1179 | 34 |
894489 | 894489 | 2021-01-04 | Clay | Alabama | 1027 | 1163 | 34 |
891243 | 891243 | 2021-01-03 | Clay | Alabama | 1027 | 1158 | 34 |
887996 | 887996 | 2021-01-02 | Clay | Alabama | 1027 | 1158 | 34 |
884751 | 884751 | 2021-01-01 | Clay | Alabama | 1027 | 1150 | 34 |
881506 | 881506 | 2020-12-31 | Clay | Alabama | 1027 | 1141 | 34 |
878261 | 878261 | 2020-12-30 | Clay | Alabama | 1027 | 1131 | 34 |
875016 | 875016 | 2020-12-29 | Clay | Alabama | 1027 | 1116 | 34 |
871771 | 871771 | 2020-12-28 | Clay | Alabama | 1027 | 1111 | 34 |
868526 | 868526 | 2020-12-27 | Clay | Alabama | 1027 | 1108 | 34 |
865281 | 865281 | 2020-12-26 | Clay | Alabama | 1027 | 1103 | 34 |
862036 | 862036 | 2020-12-25 | Clay | Alabama | 1027 | 1098 | 34 |
858791 | 858791 | 2020-12-24 | Clay | Alabama | 1027 | 1088 | 34 |
855546 | 855546 | 2020-12-23 | Clay | Alabama | 1027 | 1083 | 34 |
852301 | 852301 | 2020-12-22 | Clay | Alabama | 1027 | 1077 | 32 |
849056 | 849056 | 2020-12-21 | Clay | Alabama | 1027 | 1062 | 29 |
845811 | 845811 | 2020-12-20 | Clay | Alabama | 1027 | 1055 | 29 |
842565 | 842565 | 2020-12-19 | Clay | Alabama | 1027 | 1052 | 29 |
839320 | 839320 | 2020-12-18 | Clay | Alabama | 1027 | 1041 | 29 |
836075 | 836075 | 2020-12-17 | Clay | Alabama | 1027 | 1034 | 29 |
832829 | 832829 | 2020-12-16 | Clay | Alabama | 1027 | 1017 | 29 |
829582 | 829582 | 2020-12-15 | Clay | Alabama | 1027 | 1014 | 28 |
826336 | 826336 | 2020-12-14 | Clay | Alabama | 1027 | 1008 | 28 |
823089 | 823089 | 2020-12-13 | Clay | Alabama | 1027 | 1003 | 28 |
819843 | 819843 | 2020-12-12 | Clay | Alabama | 1027 | 998 | 28 |
816597 | 816597 | 2020-12-11 | Clay | Alabama | 1027 | 995 | 28 |
813351 | 813351 | 2020-12-10 | Clay | Alabama | 1027 | 991 | 27 |
810107 | 810107 | 2020-12-09 | Clay | Alabama | 1027 | 980 | 27 |
806862 | 806862 | 2020-12-08 | Clay | Alabama | 1027 | 979 | 27 |
803617 | 803617 | 2020-12-07 | Clay | Alabama | 1027 | 971 | 27 |
800372 | 800372 | 2020-12-06 | Clay | Alabama | 1027 | 963 | 27 |
797127 | 797127 | 2020-12-05 | Clay | Alabama | 1027 | 956 | 27 |
793882 | 793882 | 2020-12-04 | Clay | Alabama | 1027 | 955 | 27 |
790637 | 790637 | 2020-12-03 | Clay | Alabama | 1027 | 948 | 25 |
787392 | 787392 | 2020-12-02 | Clay | Alabama | 1027 | 935 | 25 |
784148 | 784148 | 2020-12-01 | Clay | Alabama | 1027 | 928 | 24 |
780903 | 780903 | 2020-11-30 | Clay | Alabama | 1027 | 920 | 24 |
777657 | 777657 | 2020-11-29 | Clay | Alabama | 1027 | 920 | 24 |
774412 | 774412 | 2020-11-28 | Clay | Alabama | 1027 | 919 | 24 |
771167 | 771167 | 2020-11-27 | Clay | Alabama | 1027 | 911 | 24 |
767921 | 767921 | 2020-11-26 | Clay | Alabama | 1027 | 910 | 24 |
764676 | 764676 | 2020-11-25 | Clay | Alabama | 1027 | 902 | 23 |
761431 | 761431 | 2020-11-24 | Clay | Alabama | 1027 | 896 | 23 |
758186 | 758186 | 2020-11-23 | Clay | Alabama | 1027 | 894 | 23 |
754939 | 754939 | 2020-11-22 | Clay | Alabama | 1027 | 888 | 23 |
751693 | 751693 | 2020-11-21 | Clay | Alabama | 1027 | 883 | 23 |
748447 | 748447 | 2020-11-20 | Clay | Alabama | 1027 | 876 | 23 |
745201 | 745201 | 2020-11-19 | Clay | Alabama | 1027 | 868 | 23 |
741954 | 741954 | 2020-11-18 | Clay | Alabama | 1027 | 859 | 15 |
738707 | 738707 | 2020-11-17 | Clay | Alabama | 1027 | 852 | 15 |
735463 | 735463 | 2020-11-16 | Clay | Alabama | 1027 | 850 | 13 |
732217 | 732217 | 2020-11-15 | Clay | Alabama | 1027 | 850 | 13 |
728972 | 728972 | 2020-11-14 | Clay | Alabama | 1027 | 845 | 13 |
725729 | 725729 | 2020-11-13 | Clay | Alabama | 1027 | 833 | 13 |
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);