ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Jasper" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418673 | 1418673 | 2021-06-14 | Jasper | Missouri | 29097 | 9710 | 130 |
1415428 | 1415428 | 2021-06-13 | Jasper | Missouri | 29097 | 9700 | 130 |
1412182 | 1412182 | 2021-06-12 | Jasper | Missouri | 29097 | 9691 | 130 |
1408937 | 1408937 | 2021-06-11 | Jasper | Missouri | 29097 | 9681 | 130 |
1405692 | 1405692 | 2021-06-10 | Jasper | Missouri | 29097 | 9656 | 130 |
1402446 | 1402446 | 2021-06-09 | Jasper | Missouri | 29097 | 9643 | 130 |
1399201 | 1399201 | 2021-06-08 | Jasper | Missouri | 29097 | 9629 | 130 |
1395955 | 1395955 | 2021-06-07 | Jasper | Missouri | 29097 | 9611 | 130 |
1392709 | 1392709 | 2021-06-06 | Jasper | Missouri | 29097 | 9603 | 130 |
1389464 | 1389464 | 2021-06-05 | Jasper | Missouri | 29097 | 9603 | 130 |
1386219 | 1386219 | 2021-06-04 | Jasper | Missouri | 29097 | 9590 | 130 |
1382974 | 1382974 | 2021-06-03 | Jasper | Missouri | 29097 | 9575 | 130 |
1379728 | 1379728 | 2021-06-02 | Jasper | Missouri | 29097 | 9559 | 130 |
1376483 | 1376483 | 2021-06-01 | Jasper | Missouri | 29097 | 9543 | 129 |
1373237 | 1373237 | 2021-05-31 | Jasper | Missouri | 29097 | 9540 | 129 |
1369992 | 1369992 | 2021-05-30 | Jasper | Missouri | 29097 | 9539 | 129 |
1366746 | 1366746 | 2021-05-29 | Jasper | Missouri | 29097 | 9536 | 129 |
1363500 | 1363500 | 2021-05-28 | Jasper | Missouri | 29097 | 9531 | 129 |
1360253 | 1360253 | 2021-05-27 | Jasper | Missouri | 29097 | 9524 | 129 |
1357007 | 1357007 | 2021-05-26 | Jasper | Missouri | 29097 | 9515 | 129 |
1353761 | 1353761 | 2021-05-25 | Jasper | Missouri | 29097 | 9508 | 129 |
1350515 | 1350515 | 2021-05-24 | Jasper | Missouri | 29097 | 9497 | 129 |
1347269 | 1347269 | 2021-05-23 | Jasper | Missouri | 29097 | 9497 | 129 |
1344021 | 1344021 | 2021-05-22 | Jasper | Missouri | 29097 | 9497 | 129 |
1340772 | 1340772 | 2021-05-21 | Jasper | Missouri | 29097 | 9493 | 129 |
1337525 | 1337525 | 2021-05-20 | Jasper | Missouri | 29097 | 9486 | 128 |
1334278 | 1334278 | 2021-05-19 | Jasper | Missouri | 29097 | 9482 | 128 |
1331031 | 1331031 | 2021-05-18 | Jasper | Missouri | 29097 | 9480 | 128 |
1327784 | 1327784 | 2021-05-17 | Jasper | Missouri | 29097 | 9472 | 127 |
1324538 | 1324538 | 2021-05-16 | Jasper | Missouri | 29097 | 9472 | 127 |
1321292 | 1321292 | 2021-05-15 | Jasper | Missouri | 29097 | 9469 | 127 |
1318046 | 1318046 | 2021-05-14 | Jasper | Missouri | 29097 | 9467 | 127 |
1314798 | 1314798 | 2021-05-13 | Jasper | Missouri | 29097 | 9459 | 127 |
1311552 | 1311552 | 2021-05-12 | Jasper | Missouri | 29097 | 9446 | 127 |
1308305 | 1308305 | 2021-05-11 | Jasper | Missouri | 29097 | 9439 | 127 |
1305059 | 1305059 | 2021-05-10 | Jasper | Missouri | 29097 | 9432 | 127 |
1301813 | 1301813 | 2021-05-09 | Jasper | Missouri | 29097 | 9428 | 127 |
1298565 | 1298565 | 2021-05-08 | Jasper | Missouri | 29097 | 9428 | 127 |
1295319 | 1295319 | 2021-05-07 | Jasper | Missouri | 29097 | 9420 | 127 |
1292073 | 1292073 | 2021-05-06 | Jasper | Missouri | 29097 | 9414 | 127 |
1288827 | 1288827 | 2021-05-05 | Jasper | Missouri | 29097 | 9409 | 127 |
1285581 | 1285581 | 2021-05-04 | Jasper | Missouri | 29097 | 9402 | 127 |
1282335 | 1282335 | 2021-05-03 | Jasper | Missouri | 29097 | 9394 | 127 |
1279088 | 1279088 | 2021-05-02 | Jasper | Missouri | 29097 | 9394 | 127 |
1275841 | 1275841 | 2021-05-01 | Jasper | Missouri | 29097 | 9383 | 127 |
1272594 | 1272594 | 2021-04-30 | Jasper | Missouri | 29097 | 9372 | 127 |
1269347 | 1269347 | 2021-04-29 | Jasper | Missouri | 29097 | 9363 | 127 |
1266100 | 1266100 | 2021-04-28 | Jasper | Missouri | 29097 | 9355 | 127 |
1262853 | 1262853 | 2021-04-27 | Jasper | Missouri | 29097 | 9350 | 127 |
1259606 | 1259606 | 2021-04-26 | Jasper | Missouri | 29097 | 9345 | 127 |
1256359 | 1256359 | 2021-04-25 | Jasper | Missouri | 29097 | 9343 | 127 |
1253112 | 1253112 | 2021-04-24 | Jasper | Missouri | 29097 | 9343 | 127 |
1249865 | 1249865 | 2021-04-23 | Jasper | Missouri | 29097 | 9337 | 127 |
1246618 | 1246618 | 2021-04-22 | Jasper | Missouri | 29097 | 9334 | 127 |
1243371 | 1243371 | 2021-04-21 | Jasper | Missouri | 29097 | 9330 | 127 |
1240124 | 1240124 | 2021-04-20 | Jasper | Missouri | 29097 | 9327 | 127 |
1236877 | 1236877 | 2021-04-19 | Jasper | Missouri | 29097 | 9325 | 127 |
1233630 | 1233630 | 2021-04-18 | Jasper | Missouri | 29097 | 9325 | 127 |
1230382 | 1230382 | 2021-04-17 | Jasper | Missouri | 29097 | 9323 | 127 |
1227134 | 1227134 | 2021-04-16 | Jasper | Missouri | 29097 | 9433 | 126 |
1223886 | 1223886 | 2021-04-15 | Jasper | Missouri | 29097 | 9431 | 126 |
1220639 | 1220639 | 2021-04-14 | Jasper | Missouri | 29097 | 9427 | 126 |
1217391 | 1217391 | 2021-04-13 | Jasper | Missouri | 29097 | 9423 | 126 |
1214144 | 1214144 | 2021-04-12 | Jasper | Missouri | 29097 | 9418 | 126 |
1210896 | 1210896 | 2021-04-11 | Jasper | Missouri | 29097 | 9416 | 126 |
1207647 | 1207647 | 2021-04-10 | Jasper | Missouri | 29097 | 9415 | 126 |
1204399 | 1204399 | 2021-04-09 | Jasper | Missouri | 29097 | 9402 | 126 |
1201151 | 1201151 | 2021-04-08 | Jasper | Missouri | 29097 | 9399 | 126 |
1197902 | 1197902 | 2021-04-07 | Jasper | Missouri | 29097 | 9394 | 126 |
1194653 | 1194653 | 2021-04-06 | Jasper | Missouri | 29097 | 9384 | 126 |
1191404 | 1191404 | 2021-04-05 | Jasper | Missouri | 29097 | 9383 | 126 |
1188156 | 1188156 | 2021-04-04 | Jasper | Missouri | 29097 | 9382 | 126 |
1184909 | 1184909 | 2021-04-03 | Jasper | Missouri | 29097 | 9381 | 126 |
1181663 | 1181663 | 2021-04-02 | Jasper | Missouri | 29097 | 9376 | 126 |
1178416 | 1178416 | 2021-04-01 | Jasper | Missouri | 29097 | 9372 | 126 |
1175169 | 1175169 | 2021-03-31 | Jasper | Missouri | 29097 | 9367 | 126 |
1171922 | 1171922 | 2021-03-30 | Jasper | Missouri | 29097 | 9362 | 126 |
1168674 | 1168674 | 2021-03-29 | Jasper | Missouri | 29097 | 9360 | 126 |
1165426 | 1165426 | 2021-03-28 | Jasper | Missouri | 29097 | 9358 | 126 |
1162178 | 1162178 | 2021-03-27 | Jasper | Missouri | 29097 | 9357 | 126 |
1158930 | 1158930 | 2021-03-26 | Jasper | Missouri | 29097 | 9352 | 126 |
1155683 | 1155683 | 2021-03-25 | Jasper | Missouri | 29097 | 9345 | 126 |
1152436 | 1152436 | 2021-03-24 | Jasper | Missouri | 29097 | 9346 | 126 |
1149189 | 1149189 | 2021-03-23 | Jasper | Missouri | 29097 | 9338 | 126 |
1145942 | 1145942 | 2021-03-22 | Jasper | Missouri | 29097 | 9326 | 126 |
1142695 | 1142695 | 2021-03-21 | Jasper | Missouri | 29097 | 9325 | 126 |
1139448 | 1139448 | 2021-03-20 | Jasper | Missouri | 29097 | 9324 | 126 |
1136202 | 1136202 | 2021-03-19 | Jasper | Missouri | 29097 | 9317 | 126 |
1132956 | 1132956 | 2021-03-18 | Jasper | Missouri | 29097 | 9309 | 126 |
1129708 | 1129708 | 2021-03-17 | Jasper | Missouri | 29097 | 9303 | 126 |
1126461 | 1126461 | 2021-03-16 | Jasper | Missouri | 29097 | 9288 | 126 |
1123215 | 1123215 | 2021-03-15 | Jasper | Missouri | 29097 | 9281 | 124 |
1119968 | 1119968 | 2021-03-14 | Jasper | Missouri | 29097 | 9276 | 124 |
1116721 | 1116721 | 2021-03-13 | Jasper | Missouri | 29097 | 9273 | 124 |
1113475 | 1113475 | 2021-03-12 | Jasper | Missouri | 29097 | 9259 | 124 |
1110229 | 1110229 | 2021-03-11 | Jasper | Missouri | 29097 | 9251 | 124 |
1106983 | 1106983 | 2021-03-10 | Jasper | Missouri | 29097 | 9245 | 124 |
1103737 | 1103737 | 2021-03-09 | Jasper | Missouri | 29097 | 9232 | 124 |
1100491 | 1100491 | 2021-03-08 | Jasper | Missouri | 29097 | 9226 | 123 |
1097244 | 1097244 | 2021-03-07 | Jasper | Missouri | 29097 | 7461 | 123 |
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);