ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
125 rows where deaths = 9, fips = 38057 and state = "North Dakota" 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 |
---|---|---|---|---|---|---|---|
1224374 | 1224374 | 2021-04-15 | Mercer | North Dakota | 38057 | 1104 | 9 |
1221127 | 1221127 | 2021-04-14 | Mercer | North Dakota | 38057 | 1102 | 9 |
1217879 | 1217879 | 2021-04-13 | Mercer | North Dakota | 38057 | 1100 | 9 |
1214631 | 1214631 | 2021-04-12 | Mercer | North Dakota | 38057 | 1099 | 9 |
1211384 | 1211384 | 2021-04-11 | Mercer | North Dakota | 38057 | 1099 | 9 |
1208135 | 1208135 | 2021-04-10 | Mercer | North Dakota | 38057 | 1097 | 9 |
1204887 | 1204887 | 2021-04-09 | Mercer | North Dakota | 38057 | 1097 | 9 |
1201639 | 1201639 | 2021-04-08 | Mercer | North Dakota | 38057 | 1096 | 9 |
1198390 | 1198390 | 2021-04-07 | Mercer | North Dakota | 38057 | 1095 | 9 |
1195141 | 1195141 | 2021-04-06 | Mercer | North Dakota | 38057 | 1095 | 9 |
1191893 | 1191893 | 2021-04-05 | Mercer | North Dakota | 38057 | 1095 | 9 |
1188644 | 1188644 | 2021-04-04 | Mercer | North Dakota | 38057 | 1095 | 9 |
1185397 | 1185397 | 2021-04-03 | Mercer | North Dakota | 38057 | 1095 | 9 |
1182150 | 1182150 | 2021-04-02 | Mercer | North Dakota | 38057 | 1095 | 9 |
1178903 | 1178903 | 2021-04-01 | Mercer | North Dakota | 38057 | 1095 | 9 |
1175656 | 1175656 | 2021-03-31 | Mercer | North Dakota | 38057 | 1095 | 9 |
1172409 | 1172409 | 2021-03-30 | Mercer | North Dakota | 38057 | 1095 | 9 |
1169162 | 1169162 | 2021-03-29 | Mercer | North Dakota | 38057 | 1095 | 9 |
1165914 | 1165914 | 2021-03-28 | Mercer | North Dakota | 38057 | 1095 | 9 |
1162666 | 1162666 | 2021-03-27 | Mercer | North Dakota | 38057 | 1095 | 9 |
1159417 | 1159417 | 2021-03-26 | Mercer | North Dakota | 38057 | 1093 | 9 |
1156170 | 1156170 | 2021-03-25 | Mercer | North Dakota | 38057 | 1091 | 9 |
1152923 | 1152923 | 2021-03-24 | Mercer | North Dakota | 38057 | 1086 | 9 |
1149676 | 1149676 | 2021-03-23 | Mercer | North Dakota | 38057 | 1086 | 9 |
1146429 | 1146429 | 2021-03-22 | Mercer | North Dakota | 38057 | 1083 | 9 |
1143182 | 1143182 | 2021-03-21 | Mercer | North Dakota | 38057 | 1082 | 9 |
1139935 | 1139935 | 2021-03-20 | Mercer | North Dakota | 38057 | 1082 | 9 |
1136689 | 1136689 | 2021-03-19 | Mercer | North Dakota | 38057 | 1082 | 9 |
1133443 | 1133443 | 2021-03-18 | Mercer | North Dakota | 38057 | 1082 | 9 |
1130195 | 1130195 | 2021-03-17 | Mercer | North Dakota | 38057 | 1080 | 9 |
1126948 | 1126948 | 2021-03-16 | Mercer | North Dakota | 38057 | 1078 | 9 |
1123702 | 1123702 | 2021-03-15 | Mercer | North Dakota | 38057 | 1078 | 9 |
1120456 | 1120456 | 2021-03-14 | Mercer | North Dakota | 38057 | 1078 | 9 |
1117209 | 1117209 | 2021-03-13 | Mercer | North Dakota | 38057 | 1078 | 9 |
1113962 | 1113962 | 2021-03-12 | Mercer | North Dakota | 38057 | 1077 | 9 |
1110716 | 1110716 | 2021-03-11 | Mercer | North Dakota | 38057 | 1076 | 9 |
1107470 | 1107470 | 2021-03-10 | Mercer | North Dakota | 38057 | 1073 | 9 |
1104224 | 1104224 | 2021-03-09 | Mercer | North Dakota | 38057 | 1073 | 9 |
1100978 | 1100978 | 2021-03-08 | Mercer | North Dakota | 38057 | 1073 | 9 |
1097732 | 1097732 | 2021-03-07 | Mercer | North Dakota | 38057 | 1073 | 9 |
1094484 | 1094484 | 2021-03-06 | Mercer | North Dakota | 38057 | 1073 | 9 |
1091238 | 1091238 | 2021-03-05 | Mercer | North Dakota | 38057 | 1073 | 9 |
1087993 | 1087993 | 2021-03-04 | Mercer | North Dakota | 38057 | 1073 | 9 |
1084748 | 1084748 | 2021-03-03 | Mercer | North Dakota | 38057 | 1072 | 9 |
1081502 | 1081502 | 2021-03-02 | Mercer | North Dakota | 38057 | 1070 | 9 |
1078256 | 1078256 | 2021-03-01 | Mercer | North Dakota | 38057 | 1069 | 9 |
1075011 | 1075011 | 2021-02-28 | Mercer | North Dakota | 38057 | 1069 | 9 |
1071765 | 1071765 | 2021-02-27 | Mercer | North Dakota | 38057 | 1069 | 9 |
1068519 | 1068519 | 2021-02-26 | Mercer | North Dakota | 38057 | 1069 | 9 |
1065274 | 1065274 | 2021-02-25 | Mercer | North Dakota | 38057 | 1070 | 9 |
1062030 | 1062030 | 2021-02-24 | Mercer | North Dakota | 38057 | 1070 | 9 |
1058784 | 1058784 | 2021-02-23 | Mercer | North Dakota | 38057 | 1069 | 9 |
1055538 | 1055538 | 2021-02-22 | Mercer | North Dakota | 38057 | 1069 | 9 |
1052292 | 1052292 | 2021-02-21 | Mercer | North Dakota | 38057 | 1069 | 9 |
1049045 | 1049045 | 2021-02-20 | Mercer | North Dakota | 38057 | 1069 | 9 |
1045798 | 1045798 | 2021-02-19 | Mercer | North Dakota | 38057 | 1068 | 9 |
1042553 | 1042553 | 2021-02-18 | Mercer | North Dakota | 38057 | 1066 | 9 |
1039308 | 1039308 | 2021-02-17 | Mercer | North Dakota | 38057 | 1063 | 9 |
1036063 | 1036063 | 2021-02-16 | Mercer | North Dakota | 38057 | 1063 | 9 |
1032818 | 1032818 | 2021-02-15 | Mercer | North Dakota | 38057 | 1063 | 9 |
1029572 | 1029572 | 2021-02-14 | Mercer | North Dakota | 38057 | 1063 | 9 |
1026325 | 1026325 | 2021-02-13 | Mercer | North Dakota | 38057 | 1061 | 9 |
1023080 | 1023080 | 2021-02-12 | Mercer | North Dakota | 38057 | 1061 | 9 |
1019835 | 1019835 | 2021-02-11 | Mercer | North Dakota | 38057 | 1059 | 9 |
1016590 | 1016590 | 2021-02-10 | Mercer | North Dakota | 38057 | 1058 | 9 |
1013345 | 1013345 | 2021-02-09 | Mercer | North Dakota | 38057 | 1057 | 9 |
1010100 | 1010100 | 2021-02-08 | Mercer | North Dakota | 38057 | 1058 | 9 |
1006854 | 1006854 | 2021-02-07 | Mercer | North Dakota | 38057 | 1058 | 9 |
1003608 | 1003608 | 2021-02-06 | Mercer | North Dakota | 38057 | 1058 | 9 |
1000362 | 1000362 | 2021-02-05 | Mercer | North Dakota | 38057 | 1058 | 9 |
997116 | 997116 | 2021-02-04 | Mercer | North Dakota | 38057 | 1058 | 9 |
993870 | 993870 | 2021-02-03 | Mercer | North Dakota | 38057 | 1055 | 9 |
990624 | 990624 | 2021-02-02 | Mercer | North Dakota | 38057 | 1053 | 9 |
987378 | 987378 | 2021-02-01 | Mercer | North Dakota | 38057 | 1053 | 9 |
984131 | 984131 | 2021-01-31 | Mercer | North Dakota | 38057 | 1053 | 9 |
980884 | 980884 | 2021-01-30 | Mercer | North Dakota | 38057 | 1053 | 9 |
977638 | 977638 | 2021-01-29 | Mercer | North Dakota | 38057 | 1053 | 9 |
974393 | 974393 | 2021-01-28 | Mercer | North Dakota | 38057 | 1051 | 9 |
971148 | 971148 | 2021-01-27 | Mercer | North Dakota | 38057 | 1051 | 9 |
967903 | 967903 | 2021-01-26 | Mercer | North Dakota | 38057 | 1049 | 9 |
964659 | 964659 | 2021-01-25 | Mercer | North Dakota | 38057 | 1046 | 9 |
961414 | 961414 | 2021-01-24 | Mercer | North Dakota | 38057 | 1046 | 9 |
958169 | 958169 | 2021-01-23 | Mercer | North Dakota | 38057 | 1045 | 9 |
954923 | 954923 | 2021-01-22 | Mercer | North Dakota | 38057 | 1046 | 9 |
951678 | 951678 | 2021-01-21 | Mercer | North Dakota | 38057 | 1045 | 9 |
948433 | 948433 | 2021-01-20 | Mercer | North Dakota | 38057 | 1043 | 9 |
945187 | 945187 | 2021-01-19 | Mercer | North Dakota | 38057 | 1037 | 9 |
941940 | 941940 | 2021-01-18 | Mercer | North Dakota | 38057 | 1036 | 9 |
938695 | 938695 | 2021-01-17 | Mercer | North Dakota | 38057 | 1035 | 9 |
935450 | 935450 | 2021-01-16 | Mercer | North Dakota | 38057 | 1035 | 9 |
932205 | 932205 | 2021-01-15 | Mercer | North Dakota | 38057 | 1035 | 9 |
928960 | 928960 | 2021-01-14 | Mercer | North Dakota | 38057 | 1035 | 9 |
925715 | 925715 | 2021-01-13 | Mercer | North Dakota | 38057 | 1035 | 9 |
922469 | 922469 | 2021-01-12 | Mercer | North Dakota | 38057 | 1033 | 9 |
919224 | 919224 | 2021-01-11 | Mercer | North Dakota | 38057 | 1031 | 9 |
915979 | 915979 | 2021-01-10 | Mercer | North Dakota | 38057 | 1031 | 9 |
912734 | 912734 | 2021-01-09 | Mercer | North Dakota | 38057 | 1030 | 9 |
909489 | 909489 | 2021-01-08 | Mercer | North Dakota | 38057 | 1026 | 9 |
906244 | 906244 | 2021-01-07 | Mercer | North Dakota | 38057 | 1022 | 9 |
902998 | 902998 | 2021-01-06 | Mercer | North Dakota | 38057 | 1022 | 9 |
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);