ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Oliver" 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 |
---|---|---|---|---|---|---|---|
1279580 | 1279580 | 2021-05-02 | Oliver | North Dakota | 38065 | 157 | 3 |
1276333 | 1276333 | 2021-05-01 | Oliver | North Dakota | 38065 | 156 | 3 |
1273086 | 1273086 | 2021-04-30 | Oliver | North Dakota | 38065 | 156 | 3 |
1269839 | 1269839 | 2021-04-29 | Oliver | North Dakota | 38065 | 156 | 3 |
1266592 | 1266592 | 2021-04-28 | Oliver | North Dakota | 38065 | 156 | 3 |
1263345 | 1263345 | 2021-04-27 | Oliver | North Dakota | 38065 | 155 | 3 |
1260098 | 1260098 | 2021-04-26 | Oliver | North Dakota | 38065 | 155 | 3 |
1256851 | 1256851 | 2021-04-25 | Oliver | North Dakota | 38065 | 155 | 3 |
1253604 | 1253604 | 2021-04-24 | Oliver | North Dakota | 38065 | 155 | 3 |
1250357 | 1250357 | 2021-04-23 | Oliver | North Dakota | 38065 | 155 | 3 |
1247110 | 1247110 | 2021-04-22 | Oliver | North Dakota | 38065 | 155 | 3 |
1243863 | 1243863 | 2021-04-21 | Oliver | North Dakota | 38065 | 155 | 3 |
1240616 | 1240616 | 2021-04-20 | Oliver | North Dakota | 38065 | 155 | 3 |
1237369 | 1237369 | 2021-04-19 | Oliver | North Dakota | 38065 | 155 | 3 |
1234122 | 1234122 | 2021-04-18 | Oliver | North Dakota | 38065 | 155 | 3 |
1230874 | 1230874 | 2021-04-17 | Oliver | North Dakota | 38065 | 155 | 3 |
1227626 | 1227626 | 2021-04-16 | Oliver | North Dakota | 38065 | 154 | 3 |
1224378 | 1224378 | 2021-04-15 | Oliver | North Dakota | 38065 | 154 | 3 |
1221131 | 1221131 | 2021-04-14 | Oliver | North Dakota | 38065 | 154 | 3 |
1217883 | 1217883 | 2021-04-13 | Oliver | North Dakota | 38065 | 154 | 3 |
1214635 | 1214635 | 2021-04-12 | Oliver | North Dakota | 38065 | 154 | 3 |
1211388 | 1211388 | 2021-04-11 | Oliver | North Dakota | 38065 | 154 | 3 |
1208139 | 1208139 | 2021-04-10 | Oliver | North Dakota | 38065 | 154 | 3 |
1204891 | 1204891 | 2021-04-09 | Oliver | North Dakota | 38065 | 154 | 3 |
1201643 | 1201643 | 2021-04-08 | Oliver | North Dakota | 38065 | 154 | 3 |
1198394 | 1198394 | 2021-04-07 | Oliver | North Dakota | 38065 | 154 | 3 |
1195145 | 1195145 | 2021-04-06 | Oliver | North Dakota | 38065 | 154 | 3 |
1191897 | 1191897 | 2021-04-05 | Oliver | North Dakota | 38065 | 154 | 3 |
1188648 | 1188648 | 2021-04-04 | Oliver | North Dakota | 38065 | 154 | 3 |
1185401 | 1185401 | 2021-04-03 | Oliver | North Dakota | 38065 | 154 | 3 |
1182154 | 1182154 | 2021-04-02 | Oliver | North Dakota | 38065 | 154 | 3 |
1178907 | 1178907 | 2021-04-01 | Oliver | North Dakota | 38065 | 154 | 3 |
1175660 | 1175660 | 2021-03-31 | Oliver | North Dakota | 38065 | 154 | 3 |
1172413 | 1172413 | 2021-03-30 | Oliver | North Dakota | 38065 | 154 | 3 |
1169166 | 1169166 | 2021-03-29 | Oliver | North Dakota | 38065 | 154 | 3 |
1165918 | 1165918 | 2021-03-28 | Oliver | North Dakota | 38065 | 154 | 3 |
1162670 | 1162670 | 2021-03-27 | Oliver | North Dakota | 38065 | 154 | 3 |
1159421 | 1159421 | 2021-03-26 | Oliver | North Dakota | 38065 | 154 | 3 |
1156174 | 1156174 | 2021-03-25 | Oliver | North Dakota | 38065 | 154 | 3 |
1152927 | 1152927 | 2021-03-24 | Oliver | North Dakota | 38065 | 154 | 3 |
1149680 | 1149680 | 2021-03-23 | Oliver | North Dakota | 38065 | 154 | 3 |
1146433 | 1146433 | 2021-03-22 | Oliver | North Dakota | 38065 | 154 | 3 |
1143186 | 1143186 | 2021-03-21 | Oliver | North Dakota | 38065 | 154 | 3 |
1139939 | 1139939 | 2021-03-20 | Oliver | North Dakota | 38065 | 154 | 3 |
1136693 | 1136693 | 2021-03-19 | Oliver | North Dakota | 38065 | 154 | 2 |
1133447 | 1133447 | 2021-03-18 | Oliver | North Dakota | 38065 | 154 | 2 |
1130199 | 1130199 | 2021-03-17 | Oliver | North Dakota | 38065 | 154 | 2 |
1126952 | 1126952 | 2021-03-16 | Oliver | North Dakota | 38065 | 154 | 2 |
1123706 | 1123706 | 2021-03-15 | Oliver | North Dakota | 38065 | 154 | 2 |
1120460 | 1120460 | 2021-03-14 | Oliver | North Dakota | 38065 | 154 | 2 |
1117213 | 1117213 | 2021-03-13 | Oliver | North Dakota | 38065 | 154 | 2 |
1113966 | 1113966 | 2021-03-12 | Oliver | North Dakota | 38065 | 154 | 2 |
1110720 | 1110720 | 2021-03-11 | Oliver | North Dakota | 38065 | 154 | 2 |
1107474 | 1107474 | 2021-03-10 | Oliver | North Dakota | 38065 | 153 | 2 |
1104228 | 1104228 | 2021-03-09 | Oliver | North Dakota | 38065 | 153 | 2 |
1100982 | 1100982 | 2021-03-08 | Oliver | North Dakota | 38065 | 153 | 2 |
1097736 | 1097736 | 2021-03-07 | Oliver | North Dakota | 38065 | 153 | 2 |
1094488 | 1094488 | 2021-03-06 | Oliver | North Dakota | 38065 | 153 | 2 |
1091242 | 1091242 | 2021-03-05 | Oliver | North Dakota | 38065 | 153 | 2 |
1087997 | 1087997 | 2021-03-04 | Oliver | North Dakota | 38065 | 153 | 2 |
1084752 | 1084752 | 2021-03-03 | Oliver | North Dakota | 38065 | 152 | 2 |
1081506 | 1081506 | 2021-03-02 | Oliver | North Dakota | 38065 | 152 | 2 |
1078260 | 1078260 | 2021-03-01 | Oliver | North Dakota | 38065 | 151 | 2 |
1075015 | 1075015 | 2021-02-28 | Oliver | North Dakota | 38065 | 151 | 2 |
1071769 | 1071769 | 2021-02-27 | Oliver | North Dakota | 38065 | 151 | 2 |
1068523 | 1068523 | 2021-02-26 | Oliver | North Dakota | 38065 | 151 | 2 |
1065278 | 1065278 | 2021-02-25 | Oliver | North Dakota | 38065 | 151 | 2 |
1062034 | 1062034 | 2021-02-24 | Oliver | North Dakota | 38065 | 151 | 2 |
1058788 | 1058788 | 2021-02-23 | Oliver | North Dakota | 38065 | 151 | 2 |
1055542 | 1055542 | 2021-02-22 | Oliver | North Dakota | 38065 | 150 | 2 |
1052296 | 1052296 | 2021-02-21 | Oliver | North Dakota | 38065 | 150 | 2 |
1049049 | 1049049 | 2021-02-20 | Oliver | North Dakota | 38065 | 150 | 2 |
1045802 | 1045802 | 2021-02-19 | Oliver | North Dakota | 38065 | 150 | 2 |
1042557 | 1042557 | 2021-02-18 | Oliver | North Dakota | 38065 | 150 | 2 |
1039312 | 1039312 | 2021-02-17 | Oliver | North Dakota | 38065 | 150 | 2 |
1036067 | 1036067 | 2021-02-16 | Oliver | North Dakota | 38065 | 150 | 2 |
1032822 | 1032822 | 2021-02-15 | Oliver | North Dakota | 38065 | 150 | 2 |
1029576 | 1029576 | 2021-02-14 | Oliver | North Dakota | 38065 | 150 | 2 |
1026329 | 1026329 | 2021-02-13 | Oliver | North Dakota | 38065 | 150 | 2 |
1023084 | 1023084 | 2021-02-12 | Oliver | North Dakota | 38065 | 150 | 2 |
1019839 | 1019839 | 2021-02-11 | Oliver | North Dakota | 38065 | 150 | 2 |
1016594 | 1016594 | 2021-02-10 | Oliver | North Dakota | 38065 | 150 | 2 |
1013349 | 1013349 | 2021-02-09 | Oliver | North Dakota | 38065 | 150 | 2 |
1010104 | 1010104 | 2021-02-08 | Oliver | North Dakota | 38065 | 150 | 2 |
1006858 | 1006858 | 2021-02-07 | Oliver | North Dakota | 38065 | 150 | 2 |
1003612 | 1003612 | 2021-02-06 | Oliver | North Dakota | 38065 | 149 | 2 |
1000366 | 1000366 | 2021-02-05 | Oliver | North Dakota | 38065 | 148 | 2 |
997120 | 997120 | 2021-02-04 | Oliver | North Dakota | 38065 | 149 | 2 |
993874 | 993874 | 2021-02-03 | Oliver | North Dakota | 38065 | 150 | 2 |
990628 | 990628 | 2021-02-02 | Oliver | North Dakota | 38065 | 150 | 2 |
987382 | 987382 | 2021-02-01 | Oliver | North Dakota | 38065 | 150 | 2 |
984135 | 984135 | 2021-01-31 | Oliver | North Dakota | 38065 | 150 | 2 |
980888 | 980888 | 2021-01-30 | Oliver | North Dakota | 38065 | 150 | 2 |
977642 | 977642 | 2021-01-29 | Oliver | North Dakota | 38065 | 150 | 2 |
974397 | 974397 | 2021-01-28 | Oliver | North Dakota | 38065 | 150 | 2 |
971152 | 971152 | 2021-01-27 | Oliver | North Dakota | 38065 | 150 | 2 |
967907 | 967907 | 2021-01-26 | Oliver | North Dakota | 38065 | 150 | 2 |
964663 | 964663 | 2021-01-25 | Oliver | North Dakota | 38065 | 151 | 2 |
961418 | 961418 | 2021-01-24 | Oliver | North Dakota | 38065 | 151 | 2 |
958173 | 958173 | 2021-01-23 | Oliver | North Dakota | 38065 | 151 | 2 |
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);