ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
717 rows where county = "Unknown" and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195162 | 1195162 | 2021-04-06 | Unknown | North Dakota | 31 | 31 | |
1191914 | 1191914 | 2021-04-05 | Unknown | North Dakota | 31 | 31 | |
1188665 | 1188665 | 2021-04-04 | Unknown | North Dakota | 32 | 32 | |
1185418 | 1185418 | 2021-04-03 | Unknown | North Dakota | 32 | 32 | |
1182171 | 1182171 | 2021-04-02 | Unknown | North Dakota | 32 | 32 | |
1178924 | 1178924 | 2021-04-01 | Unknown | North Dakota | 32 | 32 | |
1175677 | 1175677 | 2021-03-31 | Unknown | North Dakota | 32 | 32 | |
1172430 | 1172430 | 2021-03-30 | Unknown | North Dakota | 32 | 32 | |
1169183 | 1169183 | 2021-03-29 | Unknown | North Dakota | 32 | 32 | |
1165935 | 1165935 | 2021-03-28 | Unknown | North Dakota | 32 | 32 | |
1162687 | 1162687 | 2021-03-27 | Unknown | North Dakota | 32 | 32 | |
1159438 | 1159438 | 2021-03-26 | Unknown | North Dakota | 32 | 32 | |
1156191 | 1156191 | 2021-03-25 | Unknown | North Dakota | 32 | 32 | |
1152944 | 1152944 | 2021-03-24 | Unknown | North Dakota | 31 | 31 | |
1149697 | 1149697 | 2021-03-23 | Unknown | North Dakota | 31 | 31 | |
1146450 | 1146450 | 2021-03-22 | Unknown | North Dakota | 31 | 31 | |
1143203 | 1143203 | 2021-03-21 | Unknown | North Dakota | 31 | 31 | |
1139956 | 1139956 | 2021-03-20 | Unknown | North Dakota | 31 | 31 | |
1136710 | 1136710 | 2021-03-19 | Unknown | North Dakota | 31 | 31 | |
1133464 | 1133464 | 2021-03-18 | Unknown | North Dakota | 31 | 31 | |
1130216 | 1130216 | 2021-03-17 | Unknown | North Dakota | 31 | 31 | |
1126969 | 1126969 | 2021-03-16 | Unknown | North Dakota | 31 | 31 | |
1123723 | 1123723 | 2021-03-15 | Unknown | North Dakota | 31 | 31 | |
1120477 | 1120477 | 2021-03-14 | Unknown | North Dakota | 31 | 31 | |
1117230 | 1117230 | 2021-03-13 | Unknown | North Dakota | 31 | 31 | |
1113983 | 1113983 | 2021-03-12 | Unknown | North Dakota | 31 | 31 | |
1110737 | 1110737 | 2021-03-11 | Unknown | North Dakota | 31 | 31 | |
1107491 | 1107491 | 2021-03-10 | Unknown | North Dakota | 30 | 30 | |
1104245 | 1104245 | 2021-03-09 | Unknown | North Dakota | 30 | 30 | |
1100999 | 1100999 | 2021-03-08 | Unknown | North Dakota | 30 | 30 | |
1097753 | 1097753 | 2021-03-07 | Unknown | North Dakota | 30 | 30 | |
1094505 | 1094505 | 2021-03-06 | Unknown | North Dakota | 30 | 30 | |
1091259 | 1091259 | 2021-03-05 | Unknown | North Dakota | 30 | 30 | |
1088014 | 1088014 | 2021-03-04 | Unknown | North Dakota | 30 | 30 | |
1084769 | 1084769 | 2021-03-03 | Unknown | North Dakota | 30 | 30 | |
1081523 | 1081523 | 2021-03-02 | Unknown | North Dakota | 30 | 30 | |
1078277 | 1078277 | 2021-03-01 | Unknown | North Dakota | 30 | 30 | |
1075032 | 1075032 | 2021-02-28 | Unknown | North Dakota | 30 | 30 | |
1071786 | 1071786 | 2021-02-27 | Unknown | North Dakota | 30 | 30 | |
1068540 | 1068540 | 2021-02-26 | Unknown | North Dakota | 30 | 30 | |
1065295 | 1065295 | 2021-02-25 | Unknown | North Dakota | 30 | 30 | |
1062051 | 1062051 | 2021-02-24 | Unknown | North Dakota | 30 | 30 | |
1058805 | 1058805 | 2021-02-23 | Unknown | North Dakota | 30 | 30 | |
1055559 | 1055559 | 2021-02-22 | Unknown | North Dakota | 30 | 30 | |
1052313 | 1052313 | 2021-02-21 | Unknown | North Dakota | 30 | 30 | |
1049066 | 1049066 | 2021-02-20 | Unknown | North Dakota | 30 | 30 | |
1045819 | 1045819 | 2021-02-19 | Unknown | North Dakota | 30 | 30 | |
1042574 | 1042574 | 2021-02-18 | Unknown | North Dakota | 30 | 30 | |
1039329 | 1039329 | 2021-02-17 | Unknown | North Dakota | 30 | 30 | |
1036084 | 1036084 | 2021-02-16 | Unknown | North Dakota | 30 | 30 | |
1032839 | 1032839 | 2021-02-15 | Unknown | North Dakota | 30 | 30 | |
1029593 | 1029593 | 2021-02-14 | Unknown | North Dakota | 30 | 30 | |
1026346 | 1026346 | 2021-02-13 | Unknown | North Dakota | 30 | 30 | |
1023101 | 1023101 | 2021-02-12 | Unknown | North Dakota | 30 | 30 | |
1019856 | 1019856 | 2021-02-11 | Unknown | North Dakota | 30 | 30 | |
1016611 | 1016611 | 2021-02-10 | Unknown | North Dakota | 30 | 30 | |
1013366 | 1013366 | 2021-02-09 | Unknown | North Dakota | 30 | 30 | |
1010121 | 1010121 | 2021-02-08 | Unknown | North Dakota | 26 | 26 | |
1006875 | 1006875 | 2021-02-07 | Unknown | North Dakota | 25 | 25 | |
1003629 | 1003629 | 2021-02-06 | Unknown | North Dakota | 25 | 25 | |
1000383 | 1000383 | 2021-02-05 | Unknown | North Dakota | 25 | 25 | |
997137 | 997137 | 2021-02-04 | Unknown | North Dakota | 25 | 25 | |
993891 | 993891 | 2021-02-03 | Unknown | North Dakota | 25 | 25 | |
990645 | 990645 | 2021-02-02 | Unknown | North Dakota | 26 | 25 | |
987399 | 987399 | 2021-02-01 | Unknown | North Dakota | 28 | 25 | |
984152 | 984152 | 2021-01-31 | Unknown | North Dakota | 26 | 25 | |
980905 | 980905 | 2021-01-30 | Unknown | North Dakota | 26 | 25 | |
977659 | 977659 | 2021-01-29 | Unknown | North Dakota | 26 | 25 | |
974414 | 974414 | 2021-01-28 | Unknown | North Dakota | 26 | 25 | |
971169 | 971169 | 2021-01-27 | Unknown | North Dakota | 25 | 25 | |
967924 | 967924 | 2021-01-26 | Unknown | North Dakota | 25 | 25 | |
964680 | 964680 | 2021-01-25 | Unknown | North Dakota | 25 | 25 | |
961435 | 961435 | 2021-01-24 | Unknown | North Dakota | 25 | 25 | |
958190 | 958190 | 2021-01-23 | Unknown | North Dakota | 25 | 25 | |
954944 | 954944 | 2021-01-22 | Unknown | North Dakota | 27 | 25 | |
951699 | 951699 | 2021-01-21 | Unknown | North Dakota | 23 | 22 | |
948454 | 948454 | 2021-01-20 | Unknown | North Dakota | 22 | 22 | |
945208 | 945208 | 2021-01-19 | Unknown | North Dakota | 22 | 22 | |
941961 | 941961 | 2021-01-18 | Unknown | North Dakota | 22 | 22 | |
938716 | 938716 | 2021-01-17 | Unknown | North Dakota | 22 | 22 | |
935471 | 935471 | 2021-01-16 | Unknown | North Dakota | 22 | 22 | |
932226 | 932226 | 2021-01-15 | Unknown | North Dakota | 22 | 22 | |
928981 | 928981 | 2021-01-14 | Unknown | North Dakota | 7 | 7 | |
925736 | 925736 | 2021-01-13 | Unknown | North Dakota | 7 | 7 | |
922490 | 922490 | 2021-01-12 | Unknown | North Dakota | 8 | 8 | |
919245 | 919245 | 2021-01-11 | Unknown | North Dakota | 9 | 8 | |
916000 | 916000 | 2021-01-10 | Unknown | North Dakota | 8 | 8 | |
912755 | 912755 | 2021-01-09 | Unknown | North Dakota | 8 | 8 | |
909510 | 909510 | 2021-01-08 | Unknown | North Dakota | 8 | 8 | |
906265 | 906265 | 2021-01-07 | Unknown | North Dakota | 7 | 7 | |
903019 | 903019 | 2021-01-06 | Unknown | North Dakota | 7 | 7 | |
899774 | 899774 | 2021-01-05 | Unknown | North Dakota | 7 | 7 | |
896529 | 896529 | 2021-01-04 | Unknown | North Dakota | 7 | 7 | |
893283 | 893283 | 2021-01-03 | Unknown | North Dakota | 7 | 7 | |
890037 | 890037 | 2021-01-02 | Unknown | North Dakota | 7 | 7 | |
886790 | 886790 | 2021-01-01 | Unknown | North Dakota | 7 | 7 | |
883545 | 883545 | 2020-12-31 | Unknown | North Dakota | 7 | 7 | |
880300 | 880300 | 2020-12-30 | Unknown | North Dakota | 7 | 7 | |
877055 | 877055 | 2020-12-29 | Unknown | North Dakota | 7 | 7 | |
873810 | 873810 | 2020-12-28 | Unknown | North Dakota | 7 | 7 |
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);