ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Clay" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194448 | 1194448 | 2021-04-06 | Clay | Minnesota | 27027 | 7507 | 89 |
1191199 | 1191199 | 2021-04-05 | Clay | Minnesota | 27027 | 7467 | 89 |
1187951 | 1187951 | 2021-04-04 | Clay | Minnesota | 27027 | 7461 | 89 |
1184704 | 1184704 | 2021-04-03 | Clay | Minnesota | 27027 | 7461 | 89 |
1181458 | 1181458 | 2021-04-02 | Clay | Minnesota | 27027 | 7409 | 89 |
1178211 | 1178211 | 2021-04-01 | Clay | Minnesota | 27027 | 7382 | 89 |
1174964 | 1174964 | 2021-03-31 | Clay | Minnesota | 27027 | 7356 | 89 |
1171717 | 1171717 | 2021-03-30 | Clay | Minnesota | 27027 | 7324 | 89 |
1168469 | 1168469 | 2021-03-29 | Clay | Minnesota | 27027 | 7294 | 89 |
1165221 | 1165221 | 2021-03-28 | Clay | Minnesota | 27027 | 7265 | 89 |
1161973 | 1161973 | 2021-03-27 | Clay | Minnesota | 27027 | 7250 | 89 |
1158725 | 1158725 | 2021-03-26 | Clay | Minnesota | 27027 | 7239 | 89 |
1155478 | 1155478 | 2021-03-25 | Clay | Minnesota | 27027 | 7206 | 89 |
1152231 | 1152231 | 2021-03-24 | Clay | Minnesota | 27027 | 7194 | 89 |
1148984 | 1148984 | 2021-03-23 | Clay | Minnesota | 27027 | 7169 | 89 |
1145737 | 1145737 | 2021-03-22 | Clay | Minnesota | 27027 | 7152 | 89 |
1142490 | 1142490 | 2021-03-21 | Clay | Minnesota | 27027 | 7129 | 89 |
1139243 | 1139243 | 2021-03-20 | Clay | Minnesota | 27027 | 7120 | 89 |
1135997 | 1135997 | 2021-03-19 | Clay | Minnesota | 27027 | 7106 | 89 |
1132751 | 1132751 | 2021-03-18 | Clay | Minnesota | 27027 | 7098 | 89 |
1129503 | 1129503 | 2021-03-17 | Clay | Minnesota | 27027 | 7077 | 89 |
1126256 | 1126256 | 2021-03-16 | Clay | Minnesota | 27027 | 7064 | 89 |
1123010 | 1123010 | 2021-03-15 | Clay | Minnesota | 27027 | 7047 | 89 |
1119763 | 1119763 | 2021-03-14 | Clay | Minnesota | 27027 | 7039 | 89 |
1116516 | 1116516 | 2021-03-13 | Clay | Minnesota | 27027 | 7018 | 89 |
1113270 | 1113270 | 2021-03-12 | Clay | Minnesota | 27027 | 7009 | 89 |
1110024 | 1110024 | 2021-03-11 | Clay | Minnesota | 27027 | 7003 | 89 |
1106778 | 1106778 | 2021-03-10 | Clay | Minnesota | 27027 | 6995 | 89 |
1103532 | 1103532 | 2021-03-09 | Clay | Minnesota | 27027 | 6975 | 89 |
1100286 | 1100286 | 2021-03-08 | Clay | Minnesota | 27027 | 6965 | 88 |
1097039 | 1097039 | 2021-03-07 | Clay | Minnesota | 27027 | 6962 | 88 |
1093792 | 1093792 | 2021-03-06 | Clay | Minnesota | 27027 | 6955 | 88 |
1090546 | 1090546 | 2021-03-05 | Clay | Minnesota | 27027 | 6945 | 87 |
1087301 | 1087301 | 2021-03-04 | Clay | Minnesota | 27027 | 6936 | 87 |
1084056 | 1084056 | 2021-03-03 | Clay | Minnesota | 27027 | 6923 | 87 |
1080810 | 1080810 | 2021-03-02 | Clay | Minnesota | 27027 | 6915 | 87 |
1077564 | 1077564 | 2021-03-01 | Clay | Minnesota | 27027 | 6903 | 87 |
1074318 | 1074318 | 2021-02-28 | Clay | Minnesota | 27027 | 6899 | 87 |
1071072 | 1071072 | 2021-02-27 | Clay | Minnesota | 27027 | 6888 | 87 |
1067827 | 1067827 | 2021-02-26 | Clay | Minnesota | 27027 | 6867 | 87 |
1064582 | 1064582 | 2021-02-25 | Clay | Minnesota | 27027 | 6853 | 86 |
1061338 | 1061338 | 2021-02-24 | Clay | Minnesota | 27027 | 6836 | 86 |
1058092 | 1058092 | 2021-02-23 | Clay | Minnesota | 27027 | 6822 | 84 |
1054846 | 1054846 | 2021-02-22 | Clay | Minnesota | 27027 | 6807 | 84 |
1051599 | 1051599 | 2021-02-21 | Clay | Minnesota | 27027 | 6803 | 84 |
1048352 | 1048352 | 2021-02-20 | Clay | Minnesota | 27027 | 6790 | 84 |
1045106 | 1045106 | 2021-02-19 | Clay | Minnesota | 27027 | 6780 | 84 |
1041861 | 1041861 | 2021-02-18 | Clay | Minnesota | 27027 | 6768 | 84 |
1038616 | 1038616 | 2021-02-17 | Clay | Minnesota | 27027 | 6752 | 84 |
1035371 | 1035371 | 2021-02-16 | Clay | Minnesota | 27027 | 6746 | 84 |
1032126 | 1032126 | 2021-02-15 | Clay | Minnesota | 27027 | 6740 | 84 |
1028879 | 1028879 | 2021-02-14 | Clay | Minnesota | 27027 | 6735 | 84 |
1025633 | 1025633 | 2021-02-13 | Clay | Minnesota | 27027 | 6729 | 84 |
1022388 | 1022388 | 2021-02-12 | Clay | Minnesota | 27027 | 6729 | 83 |
1019143 | 1019143 | 2021-02-11 | Clay | Minnesota | 27027 | 6725 | 83 |
1015898 | 1015898 | 2021-02-10 | Clay | Minnesota | 27027 | 6716 | 83 |
1012653 | 1012653 | 2021-02-09 | Clay | Minnesota | 27027 | 6712 | 83 |
1009408 | 1009408 | 2021-02-08 | Clay | Minnesota | 27027 | 6710 | 83 |
1006161 | 1006161 | 2021-02-07 | Clay | Minnesota | 27027 | 6710 | 83 |
1002915 | 1002915 | 2021-02-06 | Clay | Minnesota | 27027 | 6707 | 83 |
999670 | 999670 | 2021-02-05 | Clay | Minnesota | 27027 | 6701 | 84 |
996424 | 996424 | 2021-02-04 | Clay | Minnesota | 27027 | 6690 | 84 |
993178 | 993178 | 2021-02-03 | Clay | Minnesota | 27027 | 6675 | 84 |
989932 | 989932 | 2021-02-02 | Clay | Minnesota | 27027 | 6669 | 84 |
986685 | 986685 | 2021-02-01 | Clay | Minnesota | 27027 | 6667 | 84 |
983438 | 983438 | 2021-01-31 | Clay | Minnesota | 27027 | 6665 | 84 |
980192 | 980192 | 2021-01-30 | Clay | Minnesota | 27027 | 6655 | 84 |
976946 | 976946 | 2021-01-29 | Clay | Minnesota | 27027 | 6645 | 84 |
973701 | 973701 | 2021-01-28 | Clay | Minnesota | 27027 | 6636 | 84 |
970456 | 970456 | 2021-01-27 | Clay | Minnesota | 27027 | 6621 | 84 |
967211 | 967211 | 2021-01-26 | Clay | Minnesota | 27027 | 6613 | 84 |
963967 | 963967 | 2021-01-25 | Clay | Minnesota | 27027 | 6606 | 84 |
960722 | 960722 | 2021-01-24 | Clay | Minnesota | 27027 | 6588 | 84 |
957476 | 957476 | 2021-01-23 | Clay | Minnesota | 27027 | 6576 | 84 |
954231 | 954231 | 2021-01-22 | Clay | Minnesota | 27027 | 6555 | 82 |
950986 | 950986 | 2021-01-21 | Clay | Minnesota | 27027 | 6546 | 81 |
947740 | 947740 | 2021-01-20 | Clay | Minnesota | 27027 | 6539 | 81 |
944493 | 944493 | 2021-01-19 | Clay | Minnesota | 27027 | 6532 | 80 |
941248 | 941248 | 2021-01-18 | Clay | Minnesota | 27027 | 6516 | 80 |
938003 | 938003 | 2021-01-17 | Clay | Minnesota | 27027 | 6502 | 80 |
934758 | 934758 | 2021-01-16 | Clay | Minnesota | 27027 | 6484 | 78 |
931513 | 931513 | 2021-01-15 | Clay | Minnesota | 27027 | 6466 | 78 |
928268 | 928268 | 2021-01-14 | Clay | Minnesota | 27027 | 6432 | 78 |
925022 | 925022 | 2021-01-13 | Clay | Minnesota | 27027 | 6410 | 78 |
921777 | 921777 | 2021-01-12 | Clay | Minnesota | 27027 | 6392 | 78 |
918532 | 918532 | 2021-01-11 | Clay | Minnesota | 27027 | 6372 | 78 |
915287 | 915287 | 2021-01-10 | Clay | Minnesota | 27027 | 6369 | 78 |
912042 | 912042 | 2021-01-09 | Clay | Minnesota | 27027 | 6357 | 78 |
908797 | 908797 | 2021-01-08 | Clay | Minnesota | 27027 | 6345 | 78 |
905551 | 905551 | 2021-01-07 | Clay | Minnesota | 27027 | 6320 | 78 |
902306 | 902306 | 2021-01-06 | Clay | Minnesota | 27027 | 6306 | 78 |
899061 | 899061 | 2021-01-05 | Clay | Minnesota | 27027 | 6280 | 78 |
895816 | 895816 | 2021-01-04 | Clay | Minnesota | 27027 | 6261 | 78 |
892569 | 892569 | 2021-01-03 | Clay | Minnesota | 27027 | 6212 | 78 |
889323 | 889323 | 2021-01-02 | Clay | Minnesota | 27027 | 6188 | 78 |
886077 | 886077 | 2021-01-01 | Clay | Minnesota | 27027 | 6163 | 78 |
882832 | 882832 | 2020-12-31 | Clay | Minnesota | 27027 | 6163 | 78 |
879587 | 879587 | 2020-12-30 | Clay | Minnesota | 27027 | 6143 | 78 |
876342 | 876342 | 2020-12-29 | Clay | Minnesota | 27027 | 6129 | 77 |
873097 | 873097 | 2020-12-28 | Clay | Minnesota | 27027 | 6123 | 77 |
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);