ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
735 rows where county = "Unknown" and state = "New Hampshire" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194899 | 1194899 | 2021-04-06 | Unknown | New Hampshire | 1149 | 6 | |
1191650 | 1191650 | 2021-04-05 | Unknown | New Hampshire | 1160 | 6 | |
1188402 | 1188402 | 2021-04-04 | Unknown | New Hampshire | 1154 | 6 | |
1185155 | 1185155 | 2021-04-03 | Unknown | New Hampshire | 1133 | 6 | |
1181908 | 1181908 | 2021-04-02 | Unknown | New Hampshire | 1181 | 6 | |
1178661 | 1178661 | 2021-04-01 | Unknown | New Hampshire | 1106 | 6 | |
1175414 | 1175414 | 2021-03-31 | Unknown | New Hampshire | 1165 | 5 | |
1172167 | 1172167 | 2021-03-30 | Unknown | New Hampshire | 1140 | 5 | |
1168919 | 1168919 | 2021-03-29 | Unknown | New Hampshire | 1122 | 5 | |
1165671 | 1165671 | 2021-03-28 | Unknown | New Hampshire | 1095 | 5 | |
1162423 | 1162423 | 2021-03-27 | Unknown | New Hampshire | 1103 | 5 | |
1159175 | 1159175 | 2021-03-26 | Unknown | New Hampshire | 1117 | 5 | |
1155928 | 1155928 | 2021-03-25 | Unknown | New Hampshire | 1124 | 5 | |
1152681 | 1152681 | 2021-03-24 | Unknown | New Hampshire | 1129 | 5 | |
1149434 | 1149434 | 2021-03-23 | Unknown | New Hampshire | 1114 | 5 | |
1146187 | 1146187 | 2021-03-22 | Unknown | New Hampshire | 1095 | 5 | |
1142940 | 1142940 | 2021-03-21 | Unknown | New Hampshire | 1076 | 5 | |
1139693 | 1139693 | 2021-03-20 | Unknown | New Hampshire | 1074 | 5 | |
1136447 | 1136447 | 2021-03-19 | Unknown | New Hampshire | 1066 | 5 | |
1133201 | 1133201 | 2021-03-18 | Unknown | New Hampshire | 1103 | 5 | |
1129953 | 1129953 | 2021-03-17 | Unknown | New Hampshire | 1093 | 5 | |
1126706 | 1126706 | 2021-03-16 | Unknown | New Hampshire | 1077 | 5 | |
1123460 | 1123460 | 2021-03-15 | Unknown | New Hampshire | 1064 | 5 | |
1120213 | 1120213 | 2021-03-14 | Unknown | New Hampshire | 1041 | 5 | |
1116966 | 1116966 | 2021-03-13 | Unknown | New Hampshire | 1026 | 5 | |
1113720 | 1113720 | 2021-03-12 | Unknown | New Hampshire | 1035 | 5 | |
1110474 | 1110474 | 2021-03-11 | Unknown | New Hampshire | 1039 | 5 | |
1107228 | 1107228 | 2021-03-10 | Unknown | New Hampshire | 1041 | 5 | |
1103982 | 1103982 | 2021-03-09 | Unknown | New Hampshire | 1067 | 5 | |
1100736 | 1100736 | 2021-03-08 | Unknown | New Hampshire | 1049 | 5 | |
1097489 | 1097489 | 2021-03-07 | Unknown | New Hampshire | 1042 | 5 | |
1094242 | 1094242 | 2021-03-06 | Unknown | New Hampshire | 1055 | 5 | |
1090996 | 1090996 | 2021-03-05 | Unknown | New Hampshire | 1037 | 5 | |
1087751 | 1087751 | 2021-03-04 | Unknown | New Hampshire | 1037 | 5 | |
1084506 | 1084506 | 2021-03-03 | Unknown | New Hampshire | 1041 | 5 | |
1081260 | 1081260 | 2021-03-02 | Unknown | New Hampshire | 1075 | 5 | |
1078014 | 1078014 | 2021-03-01 | Unknown | New Hampshire | 1057 | 5 | |
1074768 | 1074768 | 2021-02-28 | Unknown | New Hampshire | 1050 | 5 | |
1071522 | 1071522 | 2021-02-27 | Unknown | New Hampshire | 1047 | 5 | |
1068277 | 1068277 | 2021-02-26 | Unknown | New Hampshire | 1055 | 5 | |
1065032 | 1065032 | 2021-02-25 | Unknown | New Hampshire | 1063 | 5 | |
1061788 | 1061788 | 2021-02-24 | Unknown | New Hampshire | 1089 | 5 | |
1058542 | 1058542 | 2021-02-23 | Unknown | New Hampshire | 1084 | 5 | |
1055296 | 1055296 | 2021-02-22 | Unknown | New Hampshire | 1065 | 5 | |
1052049 | 1052049 | 2021-02-21 | Unknown | New Hampshire | 1051 | 5 | |
1048802 | 1048802 | 2021-02-20 | Unknown | New Hampshire | 1060 | 5 | |
1045556 | 1045556 | 2021-02-19 | Unknown | New Hampshire | 1045 | 5 | |
1042311 | 1042311 | 2021-02-18 | Unknown | New Hampshire | 1037 | 5 | |
1039066 | 1039066 | 2021-02-17 | Unknown | New Hampshire | 1070 | 5 | |
1035821 | 1035821 | 2021-02-16 | Unknown | New Hampshire | 1019 | 5 | |
1032576 | 1032576 | 2021-02-15 | Unknown | New Hampshire | 1007 | 5 | |
1029329 | 1029329 | 2021-02-14 | Unknown | New Hampshire | 996 | 5 | |
1026083 | 1026083 | 2021-02-13 | Unknown | New Hampshire | 1008 | 5 | |
1022838 | 1022838 | 2021-02-12 | Unknown | New Hampshire | 991 | 5 | |
1019593 | 1019593 | 2021-02-11 | Unknown | New Hampshire | 977 | 5 | |
1016348 | 1016348 | 2021-02-10 | Unknown | New Hampshire | 995 | 5 | |
1013103 | 1013103 | 2021-02-09 | Unknown | New Hampshire | 1041 | 5 | |
1009858 | 1009858 | 2021-02-08 | Unknown | New Hampshire | 1017 | 5 | |
1006611 | 1006611 | 2021-02-07 | Unknown | New Hampshire | 1004 | 5 | |
1003365 | 1003365 | 2021-02-06 | Unknown | New Hampshire | 1033 | 4 | |
1000120 | 1000120 | 2021-02-05 | Unknown | New Hampshire | 1026 | 4 | |
996874 | 996874 | 2021-02-04 | Unknown | New Hampshire | 1022 | 4 | |
993628 | 993628 | 2021-02-03 | Unknown | New Hampshire | 1042 | 4 | |
990382 | 990382 | 2021-02-02 | Unknown | New Hampshire | 1053 | 5 | |
987135 | 987135 | 2021-02-01 | Unknown | New Hampshire | 1038 | 4 | |
983888 | 983888 | 2021-01-31 | Unknown | New Hampshire | 1022 | 4 | |
980642 | 980642 | 2021-01-30 | Unknown | New Hampshire | 1042 | 2 | |
977396 | 977396 | 2021-01-29 | Unknown | New Hampshire | 1030 | 1 | |
974151 | 974151 | 2021-01-28 | Unknown | New Hampshire | 1040 | 1 | |
970906 | 970906 | 2021-01-27 | Unknown | New Hampshire | 1043 | 1 | |
967661 | 967661 | 2021-01-26 | Unknown | New Hampshire | 1094 | 1 | |
964417 | 964417 | 2021-01-25 | Unknown | New Hampshire | 1061 | 1 | |
961172 | 961172 | 2021-01-24 | Unknown | New Hampshire | 1041 | 1 | |
957926 | 957926 | 2021-01-23 | Unknown | New Hampshire | 1053 | 1 | |
954681 | 954681 | 2021-01-22 | Unknown | New Hampshire | 1047 | 1 | |
951436 | 951436 | 2021-01-21 | Unknown | New Hampshire | 1096 | 1 | |
948190 | 948190 | 2021-01-20 | Unknown | New Hampshire | 1132 | 1 | |
944943 | 944943 | 2021-01-19 | Unknown | New Hampshire | 1097 | 1 | |
941698 | 941698 | 2021-01-18 | Unknown | New Hampshire | 1011 | 1 | |
938453 | 938453 | 2021-01-17 | Unknown | New Hampshire | 992 | 1 | |
935208 | 935208 | 2021-01-16 | Unknown | New Hampshire | 975 | 1 | |
931963 | 931963 | 2021-01-15 | Unknown | New Hampshire | 1001 | 0 | |
928718 | 928718 | 2021-01-14 | Unknown | New Hampshire | 1051 | 0 | |
925472 | 925472 | 2021-01-13 | Unknown | New Hampshire | 1066 | 0 | |
922227 | 922227 | 2021-01-12 | Unknown | New Hampshire | 1053 | 0 | |
918982 | 918982 | 2021-01-11 | Unknown | New Hampshire | 1020 | 0 | |
915737 | 915737 | 2021-01-10 | Unknown | New Hampshire | 988 | 0 | |
912492 | 912492 | 2021-01-09 | Unknown | New Hampshire | 973 | 0 | |
909247 | 909247 | 2021-01-08 | Unknown | New Hampshire | 1001 | 1 | |
906001 | 906001 | 2021-01-07 | Unknown | New Hampshire | 997 | 1 | |
902756 | 902756 | 2021-01-06 | Unknown | New Hampshire | 1000 | 1 | |
899511 | 899511 | 2021-01-05 | Unknown | New Hampshire | 979 | 1 | |
896266 | 896266 | 2021-01-04 | Unknown | New Hampshire | 962 | 1 | |
893019 | 893019 | 2021-01-03 | Unknown | New Hampshire | 902 | 0 | |
889773 | 889773 | 2021-01-02 | Unknown | New Hampshire | 903 | 0 | |
886527 | 886527 | 2021-01-01 | Unknown | New Hampshire | 883 | 0 | |
883282 | 883282 | 2020-12-31 | Unknown | New Hampshire | 883 | 0 | |
880037 | 880037 | 2020-12-30 | Unknown | New Hampshire | 863 | 0 | |
876792 | 876792 | 2020-12-29 | Unknown | New Hampshire | 860 | 0 | |
873547 | 873547 | 2020-12-28 | Unknown | New Hampshire | 805 | 0 |
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);