ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where county = "Green" and deaths = 13 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1148688 | 1148688 | 2021-03-23 | Green | Kentucky | 21087 | 1166 | 13 |
1145441 | 1145441 | 2021-03-22 | Green | Kentucky | 21087 | 1164 | 13 |
1142194 | 1142194 | 2021-03-21 | Green | Kentucky | 21087 | 1163 | 13 |
1138948 | 1138948 | 2021-03-20 | Green | Kentucky | 21087 | 1163 | 13 |
1135702 | 1135702 | 2021-03-19 | Green | Kentucky | 21087 | 1163 | 13 |
1132455 | 1132455 | 2021-03-18 | Green | Kentucky | 21087 | 1162 | 13 |
1129207 | 1129207 | 2021-03-17 | Green | Kentucky | 21087 | 1160 | 13 |
1125961 | 1125961 | 2021-03-16 | Green | Kentucky | 21087 | 1160 | 13 |
1122715 | 1122715 | 2021-03-15 | Green | Kentucky | 21087 | 1160 | 13 |
1119468 | 1119468 | 2021-03-14 | Green | Kentucky | 21087 | 1157 | 13 |
1116221 | 1116221 | 2021-03-13 | Green | Kentucky | 21087 | 1157 | 13 |
1112975 | 1112975 | 2021-03-12 | Green | Kentucky | 21087 | 1157 | 13 |
1109729 | 1109729 | 2021-03-11 | Green | Kentucky | 21087 | 1155 | 13 |
1106483 | 1106483 | 2021-03-10 | Green | Kentucky | 21087 | 1150 | 13 |
1103237 | 1103237 | 2021-03-09 | Green | Kentucky | 21087 | 1142 | 13 |
1099991 | 1099991 | 2021-03-08 | Green | Kentucky | 21087 | 1140 | 13 |
1096743 | 1096743 | 2021-03-07 | Green | Kentucky | 21087 | 1134 | 13 |
1093497 | 1093497 | 2021-03-06 | Green | Kentucky | 21087 | 1134 | 13 |
1090251 | 1090251 | 2021-03-05 | Green | Kentucky | 21087 | 1134 | 13 |
1087006 | 1087006 | 2021-03-04 | Green | Kentucky | 21087 | 1133 | 13 |
1083760 | 1083760 | 2021-03-03 | Green | Kentucky | 21087 | 1131 | 13 |
1080514 | 1080514 | 2021-03-02 | Green | Kentucky | 21087 | 1130 | 13 |
1077269 | 1077269 | 2021-03-01 | Green | Kentucky | 21087 | 1125 | 13 |
1074023 | 1074023 | 2021-02-28 | Green | Kentucky | 21087 | 1119 | 13 |
1070777 | 1070777 | 2021-02-27 | Green | Kentucky | 21087 | 1119 | 13 |
1067532 | 1067532 | 2021-02-26 | Green | Kentucky | 21087 | 1118 | 13 |
1064287 | 1064287 | 2021-02-25 | Green | Kentucky | 21087 | 1115 | 13 |
1061042 | 1061042 | 2021-02-24 | Green | Kentucky | 21087 | 1110 | 13 |
1057796 | 1057796 | 2021-02-23 | Green | Kentucky | 21087 | 1104 | 13 |
1054550 | 1054550 | 2021-02-22 | Green | Kentucky | 21087 | 1099 | 13 |
1051303 | 1051303 | 2021-02-21 | Green | Kentucky | 21087 | 1092 | 13 |
1048056 | 1048056 | 2021-02-20 | Green | Kentucky | 21087 | 1092 | 13 |
1044811 | 1044811 | 2021-02-19 | Green | Kentucky | 21087 | 1089 | 13 |
1041566 | 1041566 | 2021-02-18 | Green | Kentucky | 21087 | 1087 | 13 |
1038321 | 1038321 | 2021-02-17 | Green | Kentucky | 21087 | 1083 | 13 |
1035076 | 1035076 | 2021-02-16 | Green | Kentucky | 21087 | 1080 | 13 |
1031830 | 1031830 | 2021-02-15 | Green | Kentucky | 21087 | 1074 | 13 |
1028583 | 1028583 | 2021-02-14 | Green | Kentucky | 21087 | 1070 | 13 |
1025338 | 1025338 | 2021-02-13 | Green | Kentucky | 21087 | 1070 | 13 |
1022093 | 1022093 | 2021-02-12 | Green | Kentucky | 21087 | 1063 | 13 |
1018848 | 1018848 | 2021-02-11 | Green | Kentucky | 21087 | 1055 | 13 |
1015603 | 1015603 | 2021-02-10 | Green | Kentucky | 21087 | 1053 | 13 |
1012358 | 1012358 | 2021-02-09 | Green | Kentucky | 21087 | 1049 | 13 |
1009112 | 1009112 | 2021-02-08 | Green | Kentucky | 21087 | 1046 | 13 |
1005866 | 1005866 | 2021-02-07 | Green | Kentucky | 21087 | 1037 | 13 |
1002620 | 1002620 | 2021-02-06 | Green | Kentucky | 21087 | 1037 | 13 |
999374 | 999374 | 2021-02-05 | Green | Kentucky | 21087 | 1024 | 13 |
996128 | 996128 | 2021-02-04 | Green | Kentucky | 21087 | 1018 | 13 |
992882 | 992882 | 2021-02-03 | Green | Kentucky | 21087 | 1012 | 13 |
989636 | 989636 | 2021-02-02 | Green | Kentucky | 21087 | 1001 | 13 |
986389 | 986389 | 2021-02-01 | Green | Kentucky | 21087 | 995 | 13 |
983142 | 983142 | 2021-01-31 | Green | Kentucky | 21087 | 990 | 13 |
979896 | 979896 | 2021-01-30 | Green | Kentucky | 21087 | 985 | 13 |
976650 | 976650 | 2021-01-29 | Green | Kentucky | 21087 | 982 | 13 |
973405 | 973405 | 2021-01-28 | Green | Kentucky | 21087 | 980 | 13 |
970160 | 970160 | 2021-01-27 | Green | Kentucky | 21087 | 976 | 13 |
966916 | 966916 | 2021-01-26 | Green | Kentucky | 21087 | 971 | 13 |
963671 | 963671 | 2021-01-25 | Green | Kentucky | 21087 | 967 | 13 |
960426 | 960426 | 2021-01-24 | Green | Kentucky | 21087 | 963 | 13 |
957180 | 957180 | 2021-01-23 | Green | Kentucky | 21087 | 958 | 13 |
953935 | 953935 | 2021-01-22 | Green | Kentucky | 21087 | 948 | 13 |
950690 | 950690 | 2021-01-21 | Green | Kentucky | 21087 | 940 | 13 |
947444 | 947444 | 2021-01-20 | Green | Kentucky | 21087 | 932 | 13 |
907385 | 907385 | 2021-01-07 | Green | Wisconsin | 55045 | 2471 | 13 |
904139 | 904139 | 2021-01-06 | Green | Wisconsin | 55045 | 2459 | 13 |
900894 | 900894 | 2021-01-05 | Green | Wisconsin | 55045 | 2438 | 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);