ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "St. Louis" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- 2020-04-19 1
- …
state 1
- Minnesota · 390 ✖
fips 1
- 27137 390
county 1
- St. Louis · 390 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1220492 | 1220492 | 2021-04-14 | St. Louis | Minnesota | 27137 | 16572 | 296 |
1217244 | 1217244 | 2021-04-13 | St. Louis | Minnesota | 27137 | 16561 | 296 |
1213997 | 1213997 | 2021-04-12 | St. Louis | Minnesota | 27137 | 16500 | 296 |
1210749 | 1210749 | 2021-04-11 | St. Louis | Minnesota | 27137 | 16440 | 296 |
1207500 | 1207500 | 2021-04-10 | St. Louis | Minnesota | 27137 | 16380 | 295 |
1204252 | 1204252 | 2021-04-09 | St. Louis | Minnesota | 27137 | 16304 | 294 |
1201004 | 1201004 | 2021-04-08 | St. Louis | Minnesota | 27137 | 16190 | 293 |
1197755 | 1197755 | 2021-04-07 | St. Louis | Minnesota | 27137 | 16136 | 292 |
1194506 | 1194506 | 2021-04-06 | St. Louis | Minnesota | 27137 | 16099 | 291 |
1191257 | 1191257 | 2021-04-05 | St. Louis | Minnesota | 27137 | 16011 | 291 |
1188009 | 1188009 | 2021-04-04 | St. Louis | Minnesota | 27137 | 15977 | 289 |
1184762 | 1184762 | 2021-04-03 | St. Louis | Minnesota | 27137 | 15977 | 289 |
1181516 | 1181516 | 2021-04-02 | St. Louis | Minnesota | 27137 | 15920 | 289 |
1178269 | 1178269 | 2021-04-01 | St. Louis | Minnesota | 27137 | 15835 | 289 |
1175022 | 1175022 | 2021-03-31 | St. Louis | Minnesota | 27137 | 15802 | 289 |
1171775 | 1171775 | 2021-03-30 | St. Louis | Minnesota | 27137 | 15769 | 289 |
1168527 | 1168527 | 2021-03-29 | St. Louis | Minnesota | 27137 | 15734 | 289 |
1165279 | 1165279 | 2021-03-28 | St. Louis | Minnesota | 27137 | 15659 | 289 |
1162031 | 1162031 | 2021-03-27 | St. Louis | Minnesota | 27137 | 15633 | 289 |
1158783 | 1158783 | 2021-03-26 | St. Louis | Minnesota | 27137 | 15563 | 289 |
1155536 | 1155536 | 2021-03-25 | St. Louis | Minnesota | 27137 | 15500 | 289 |
1152289 | 1152289 | 2021-03-24 | St. Louis | Minnesota | 27137 | 15451 | 289 |
1149042 | 1149042 | 2021-03-23 | St. Louis | Minnesota | 27137 | 15434 | 289 |
1145795 | 1145795 | 2021-03-22 | St. Louis | Minnesota | 27137 | 15414 | 289 |
1142548 | 1142548 | 2021-03-21 | St. Louis | Minnesota | 27137 | 15378 | 289 |
1139301 | 1139301 | 2021-03-20 | St. Louis | Minnesota | 27137 | 15358 | 289 |
1136055 | 1136055 | 2021-03-19 | St. Louis | Minnesota | 27137 | 15318 | 289 |
1132809 | 1132809 | 2021-03-18 | St. Louis | Minnesota | 27137 | 15276 | 289 |
1129561 | 1129561 | 2021-03-17 | St. Louis | Minnesota | 27137 | 15245 | 289 |
1126314 | 1126314 | 2021-03-16 | St. Louis | Minnesota | 27137 | 15235 | 289 |
1123068 | 1123068 | 2021-03-15 | St. Louis | Minnesota | 27137 | 15215 | 289 |
1119821 | 1119821 | 2021-03-14 | St. Louis | Minnesota | 27137 | 15182 | 289 |
1116574 | 1116574 | 2021-03-13 | St. Louis | Minnesota | 27137 | 15149 | 289 |
1113328 | 1113328 | 2021-03-12 | St. Louis | Minnesota | 27137 | 15124 | 288 |
1110082 | 1110082 | 2021-03-11 | St. Louis | Minnesota | 27137 | 15082 | 286 |
1106836 | 1106836 | 2021-03-10 | St. Louis | Minnesota | 27137 | 15059 | 285 |
1103590 | 1103590 | 2021-03-09 | St. Louis | Minnesota | 27137 | 15041 | 285 |
1100344 | 1100344 | 2021-03-08 | St. Louis | Minnesota | 27137 | 14923 | 266 |
1097097 | 1097097 | 2021-03-07 | St. Louis | Minnesota | 27137 | 14915 | 265 |
1093850 | 1093850 | 2021-03-06 | St. Louis | Minnesota | 27137 | 14887 | 265 |
1090604 | 1090604 | 2021-03-05 | St. Louis | Minnesota | 27137 | 14866 | 265 |
1087359 | 1087359 | 2021-03-04 | St. Louis | Minnesota | 27137 | 14838 | 264 |
1084114 | 1084114 | 2021-03-03 | St. Louis | Minnesota | 27137 | 14822 | 263 |
1080868 | 1080868 | 2021-03-02 | St. Louis | Minnesota | 27137 | 14805 | 262 |
1077622 | 1077622 | 2021-03-01 | St. Louis | Minnesota | 27137 | 14794 | 262 |
1074376 | 1074376 | 2021-02-28 | St. Louis | Minnesota | 27137 | 14769 | 262 |
1071130 | 1071130 | 2021-02-27 | St. Louis | Minnesota | 27137 | 14746 | 262 |
1067885 | 1067885 | 2021-02-26 | St. Louis | Minnesota | 27137 | 14719 | 262 |
1064640 | 1064640 | 2021-02-25 | St. Louis | Minnesota | 27137 | 14668 | 262 |
1061396 | 1061396 | 2021-02-24 | St. Louis | Minnesota | 27137 | 14655 | 262 |
1058150 | 1058150 | 2021-02-23 | St. Louis | Minnesota | 27137 | 14644 | 262 |
1054904 | 1054904 | 2021-02-22 | St. Louis | Minnesota | 27137 | 14628 | 262 |
1051657 | 1051657 | 2021-02-21 | St. Louis | Minnesota | 27137 | 14608 | 262 |
1048410 | 1048410 | 2021-02-20 | St. Louis | Minnesota | 27137 | 14600 | 262 |
1045164 | 1045164 | 2021-02-19 | St. Louis | Minnesota | 27137 | 14579 | 262 |
1041919 | 1041919 | 2021-02-18 | St. Louis | Minnesota | 27137 | 14563 | 262 |
1038674 | 1038674 | 2021-02-17 | St. Louis | Minnesota | 27137 | 14555 | 261 |
1035429 | 1035429 | 2021-02-16 | St. Louis | Minnesota | 27137 | 14541 | 261 |
1032184 | 1032184 | 2021-02-15 | St. Louis | Minnesota | 27137 | 14526 | 261 |
1028937 | 1028937 | 2021-02-14 | St. Louis | Minnesota | 27137 | 14508 | 261 |
1025691 | 1025691 | 2021-02-13 | St. Louis | Minnesota | 27137 | 14488 | 261 |
1022446 | 1022446 | 2021-02-12 | St. Louis | Minnesota | 27137 | 14463 | 260 |
1019201 | 1019201 | 2021-02-11 | St. Louis | Minnesota | 27137 | 14429 | 260 |
1015956 | 1015956 | 2021-02-10 | St. Louis | Minnesota | 27137 | 14415 | 259 |
1012711 | 1012711 | 2021-02-09 | St. Louis | Minnesota | 27137 | 14403 | 259 |
1009466 | 1009466 | 2021-02-08 | St. Louis | Minnesota | 27137 | 14387 | 259 |
1006219 | 1006219 | 2021-02-07 | St. Louis | Minnesota | 27137 | 14364 | 259 |
1002973 | 1002973 | 2021-02-06 | St. Louis | Minnesota | 27137 | 14339 | 258 |
999728 | 999728 | 2021-02-05 | St. Louis | Minnesota | 27137 | 14308 | 257 |
996482 | 996482 | 2021-02-04 | St. Louis | Minnesota | 27137 | 14282 | 256 |
993236 | 993236 | 2021-02-03 | St. Louis | Minnesota | 27137 | 14251 | 255 |
989990 | 989990 | 2021-02-02 | St. Louis | Minnesota | 27137 | 14246 | 254 |
986743 | 986743 | 2021-02-01 | St. Louis | Minnesota | 27137 | 14233 | 254 |
983496 | 983496 | 2021-01-31 | St. Louis | Minnesota | 27137 | 14210 | 254 |
980250 | 980250 | 2021-01-30 | St. Louis | Minnesota | 27137 | 14172 | 254 |
977004 | 977004 | 2021-01-29 | St. Louis | Minnesota | 27137 | 14144 | 253 |
973759 | 973759 | 2021-01-28 | St. Louis | Minnesota | 27137 | 14086 | 252 |
970514 | 970514 | 2021-01-27 | St. Louis | Minnesota | 27137 | 14050 | 252 |
967269 | 967269 | 2021-01-26 | St. Louis | Minnesota | 27137 | 14032 | 251 |
964025 | 964025 | 2021-01-25 | St. Louis | Minnesota | 27137 | 14006 | 251 |
960780 | 960780 | 2021-01-24 | St. Louis | Minnesota | 27137 | 13970 | 250 |
957534 | 957534 | 2021-01-23 | St. Louis | Minnesota | 27137 | 13916 | 247 |
954289 | 954289 | 2021-01-22 | St. Louis | Minnesota | 27137 | 13857 | 245 |
951044 | 951044 | 2021-01-21 | St. Louis | Minnesota | 27137 | 13777 | 244 |
947798 | 947798 | 2021-01-20 | St. Louis | Minnesota | 27137 | 13730 | 242 |
944551 | 944551 | 2021-01-19 | St. Louis | Minnesota | 27137 | 13690 | 241 |
941306 | 941306 | 2021-01-18 | St. Louis | Minnesota | 27137 | 13658 | 241 |
938061 | 938061 | 2021-01-17 | St. Louis | Minnesota | 27137 | 13609 | 241 |
934816 | 934816 | 2021-01-16 | St. Louis | Minnesota | 27137 | 13546 | 240 |
931571 | 931571 | 2021-01-15 | St. Louis | Minnesota | 27137 | 13503 | 239 |
928326 | 928326 | 2021-01-14 | St. Louis | Minnesota | 27137 | 13453 | 237 |
925080 | 925080 | 2021-01-13 | St. Louis | Minnesota | 27137 | 13397 | 236 |
921835 | 921835 | 2021-01-12 | St. Louis | Minnesota | 27137 | 13358 | 231 |
918590 | 918590 | 2021-01-11 | St. Louis | Minnesota | 27137 | 13315 | 229 |
915345 | 915345 | 2021-01-10 | St. Louis | Minnesota | 27137 | 13281 | 229 |
912100 | 912100 | 2021-01-09 | St. Louis | Minnesota | 27137 | 13202 | 226 |
908855 | 908855 | 2021-01-08 | St. Louis | Minnesota | 27137 | 13143 | 226 |
905609 | 905609 | 2021-01-07 | St. Louis | Minnesota | 27137 | 13065 | 225 |
902364 | 902364 | 2021-01-06 | St. Louis | Minnesota | 27137 | 13018 | 220 |
899119 | 899119 | 2021-01-05 | St. Louis | Minnesota | 27137 | 12924 | 213 |
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);