ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 29005 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 284 ✖
- 3 43
- 1390 39
- 2 36
- 290 32
- 457 22
- 1 18
- 463 18
- 456 16
- 6 15
- 1389 11
- 286 8
- 1385 8
- 443 7
- 454 7
- 464 7
- 11 6
- 255 6
- 439 6
- 451 6
- 20 5
- 41 5
- 44 5
- 259 5
- 287 5
- 433 5
- 444 5
- 445 5
- 455 5
- 458 5
- 465 5
- 487 5
- 578 5
- 669 5
- 804 5
- 1373 5
- 14 4
- 19 4
- 37 4
- 61 4
- 68 4
- 70 4
- 261 4
- 288 4
- 430 4
- 467 4
- 612 4
- 631 4
- 674 4
- 949 4
- 975 4
- 1333 4
- 1369 4
- 1382 4
- 5 3
- 12 3
- 13 3
- 18 3
- 21 3
- 22 3
- 28 3
- 53 3
- 71 3
- 77 3
- 289 3
- 431 3
- 477 3
- 564 3
- 622 3
- 646 3
- 660 3
- 687 3
- 771 3
- 888 3
- 928 3
- 1023 3
- 1049 3
- 1281 3
- 1379 3
- 4 2
- 33 2
- 39 2
- 51 2
- 54 2
- 75 2
- 91 2
- 146 2
- 157 2
- 214 2
- 245 2
- 249 2
- 250 2
- 260 2
- 279 2
- 284 2
- 285 2
- 429 2
- 442 2
- 449 2
- 513 2
- 565 2
- 581 2
- 589 2
- 665 2
- 680 2
- 702 2
- 727 2
- 815 2
- 845 2
- 859 2
- 1186 2
- 1377 2
- 1380 2
- 7 1
- 9 1
- 23 1
- 25 1
- 29 1
- 34 1
- 36 1
- 43 1
- 50 1
- 52 1
- 56 1
- 62 1
- 64 1
- 65 1
- 73 1
- 74 1
- 76 1
- 80 1
- 82 1
- 84 1
- 86 1
- 90 1
- 95 1
- 98 1
- 102 1
- 106 1
- 109 1
- 114 1
- 115 1
- 125 1
- 132 1
- 153 1
- 170 1
- 180 1
- 184 1
- 190 1
- 194 1
- 196 1
- 199 1
- 203 1
- 207 1
- 209 1
- 211 1
- 213 1
- 220 1
- 224 1
- 226 1
- 228 1
- 232 1
- 234 1
- 236 1
- 251 1
- 253 1
- 256 1
- 258 1
- 262 1
- 281 1
- 283 1
- 428 1
- 435 1
- 446 1
- 448 1
- 450 1
- 460 1
- 471 1
- 474 1
- 476 1
- 478 1
- 484 1
- 486 1
- 493 1
- 503 1
- 504 1
- 515 1
- 520 1
- 524 1
- 532 1
- 542 1
- 544 1
- 546 1
- 548 1
- 552 1
- 554 1
- 558 1
- 570 1
- 576 1
- 584 1
- 588 1
- 590 1
- 599 1
- 604 1
- 608 1
- 617 1
- 619 1
- 620 1
- 621 1
- 626 1
- 628 1
- 632 1
- 638 1
- 639 1
- 641 1
- 647 1
- 649 1
- 650 1
- 655 1
- 666 1
- 670 1
- 672 1
- 673 1
- 685 1
- 689 1
- 720 1
- 728 1
- 731 1
- 746 1
- 778 1
- 789 1
- 800 1
- 816 1
- 851 1
- 865 1
- 875 1
- 878 1
- 885 1
- 901 1
- 915 1
- 924 1
- 926 1
- 932 1
- 942 1
- 958 1
- 965 1
- 974 1
- 979 1
- 987 1
- 995 1
- 1008 1
- 1017 1
- 1032 1
- 1040 1
- 1042 1
- 1045 1
- 1056 1
- 1059 1
- 1067 1
- 1080 1
- 1086 1
- 1089 1
- 1090 1
- 1096 1
- 1115 1
- 1131 1
- 1183 1
- 1187 1
- 1197 1
- 1217 1
- 1255 1
- 1273 1
- 1288 1
- 1305 1
- 1343 1
- 1345 1
- 1358 1
- 1363 1
- 1371 1
- 1374 1
- 1376 1
- 1381 1
- 1386 1
- 1387 1
- 1388 1
state 1
- Missouri · 778 ✖
fips 1
- 29005 · 778 ✖
county 1
- Atchison 778
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501078 | 2501078 | 2022-05-13 | Atchison | Missouri | 29005 | 1387 | 23 |
2497820 | 2497820 | 2022-05-12 | Atchison | Missouri | 29005 | 1385 | 23 |
2494562 | 2494562 | 2022-05-11 | Atchison | Missouri | 29005 | 1385 | 23 |
2491304 | 2491304 | 2022-05-10 | Atchison | Missouri | 29005 | 1385 | 23 |
2488046 | 2488046 | 2022-05-09 | Atchison | Missouri | 29005 | 1385 | 23 |
2484789 | 2484789 | 2022-05-08 | Atchison | Missouri | 29005 | 1385 | 23 |
2481531 | 2481531 | 2022-05-07 | Atchison | Missouri | 29005 | 1385 | 23 |
2478273 | 2478273 | 2022-05-06 | Atchison | Missouri | 29005 | 1385 | 23 |
2475015 | 2475015 | 2022-05-05 | Atchison | Missouri | 29005 | 1390 | 23 |
2471758 | 2471758 | 2022-05-04 | Atchison | Missouri | 29005 | 1390 | 21 |
2468502 | 2468502 | 2022-05-03 | Atchison | Missouri | 29005 | 1390 | 21 |
2465246 | 2465246 | 2022-05-02 | Atchison | Missouri | 29005 | 1390 | 21 |
2461991 | 2461991 | 2022-05-01 | Atchison | Missouri | 29005 | 1390 | 21 |
2458735 | 2458735 | 2022-04-30 | Atchison | Missouri | 29005 | 1390 | 21 |
2455479 | 2455479 | 2022-04-29 | Atchison | Missouri | 29005 | 1390 | 21 |
2452223 | 2452223 | 2022-04-28 | Atchison | Missouri | 29005 | 1390 | 21 |
2448967 | 2448967 | 2022-04-27 | Atchison | Missouri | 29005 | 1390 | 21 |
2445710 | 2445710 | 2022-04-26 | Atchison | Missouri | 29005 | 1390 | 21 |
2442455 | 2442455 | 2022-04-25 | Atchison | Missouri | 29005 | 1390 | 21 |
2439199 | 2439199 | 2022-04-24 | Atchison | Missouri | 29005 | 1390 | 21 |
2435943 | 2435943 | 2022-04-23 | Atchison | Missouri | 29005 | 1390 | 21 |
2432687 | 2432687 | 2022-04-22 | Atchison | Missouri | 29005 | 1390 | 21 |
2429431 | 2429431 | 2022-04-21 | Atchison | Missouri | 29005 | 1390 | 21 |
2426175 | 2426175 | 2022-04-20 | Atchison | Missouri | 29005 | 1390 | 21 |
2422919 | 2422919 | 2022-04-19 | Atchison | Missouri | 29005 | 1390 | 21 |
2419662 | 2419662 | 2022-04-18 | Atchison | Missouri | 29005 | 1390 | 21 |
2416407 | 2416407 | 2022-04-17 | Atchison | Missouri | 29005 | 1390 | 21 |
2413151 | 2413151 | 2022-04-16 | Atchison | Missouri | 29005 | 1390 | 21 |
2409895 | 2409895 | 2022-04-15 | Atchison | Missouri | 29005 | 1390 | 21 |
2406639 | 2406639 | 2022-04-14 | Atchison | Missouri | 29005 | 1390 | 21 |
2403383 | 2403383 | 2022-04-13 | Atchison | Missouri | 29005 | 1390 | 21 |
2400128 | 2400128 | 2022-04-12 | Atchison | Missouri | 29005 | 1390 | 21 |
2396873 | 2396873 | 2022-04-11 | Atchison | Missouri | 29005 | 1390 | 21 |
2393618 | 2393618 | 2022-04-10 | Atchison | Missouri | 29005 | 1390 | 21 |
2390362 | 2390362 | 2022-04-09 | Atchison | Missouri | 29005 | 1390 | 21 |
2387106 | 2387106 | 2022-04-08 | Atchison | Missouri | 29005 | 1390 | 21 |
2383851 | 2383851 | 2022-04-07 | Atchison | Missouri | 29005 | 1390 | 21 |
2380596 | 2380596 | 2022-04-06 | Atchison | Missouri | 29005 | 1390 | 21 |
2377341 | 2377341 | 2022-04-05 | Atchison | Missouri | 29005 | 1390 | 21 |
2374088 | 2374088 | 2022-04-04 | Atchison | Missouri | 29005 | 1390 | 21 |
2370836 | 2370836 | 2022-04-03 | Atchison | Missouri | 29005 | 1390 | 21 |
2367583 | 2367583 | 2022-04-02 | Atchison | Missouri | 29005 | 1390 | 21 |
2364330 | 2364330 | 2022-04-01 | Atchison | Missouri | 29005 | 1390 | 21 |
2361076 | 2361076 | 2022-03-31 | Atchison | Missouri | 29005 | 1390 | 21 |
2357822 | 2357822 | 2022-03-30 | Atchison | Missouri | 29005 | 1390 | 21 |
2354569 | 2354569 | 2022-03-29 | Atchison | Missouri | 29005 | 1390 | 21 |
2351316 | 2351316 | 2022-03-28 | Atchison | Missouri | 29005 | 1390 | 21 |
2348064 | 2348064 | 2022-03-27 | Atchison | Missouri | 29005 | 1389 | 21 |
2344811 | 2344811 | 2022-03-26 | Atchison | Missouri | 29005 | 1389 | 21 |
2341558 | 2341558 | 2022-03-25 | Atchison | Missouri | 29005 | 1389 | 21 |
2338305 | 2338305 | 2022-03-24 | Atchison | Missouri | 29005 | 1389 | 21 |
2335051 | 2335051 | 2022-03-23 | Atchison | Missouri | 29005 | 1389 | 21 |
2331797 | 2331797 | 2022-03-22 | Atchison | Missouri | 29005 | 1389 | 21 |
2328544 | 2328544 | 2022-03-21 | Atchison | Missouri | 29005 | 1389 | 20 |
2325292 | 2325292 | 2022-03-20 | Atchison | Missouri | 29005 | 1389 | 20 |
2322038 | 2322038 | 2022-03-19 | Atchison | Missouri | 29005 | 1389 | 20 |
2318784 | 2318784 | 2022-03-18 | Atchison | Missouri | 29005 | 1389 | 20 |
2315531 | 2315531 | 2022-03-17 | Atchison | Missouri | 29005 | 1389 | 20 |
2312278 | 2312278 | 2022-03-16 | Atchison | Missouri | 29005 | 1388 | 20 |
2309025 | 2309025 | 2022-03-15 | Atchison | Missouri | 29005 | 1386 | 20 |
2305773 | 2305773 | 2022-03-14 | Atchison | Missouri | 29005 | 1385 | 20 |
2302522 | 2302522 | 2022-03-13 | Atchison | Missouri | 29005 | 1382 | 20 |
2299270 | 2299270 | 2022-03-12 | Atchison | Missouri | 29005 | 1382 | 20 |
2296018 | 2296018 | 2022-03-11 | Atchison | Missouri | 29005 | 1382 | 20 |
2292766 | 2292766 | 2022-03-10 | Atchison | Missouri | 29005 | 1382 | 20 |
2289514 | 2289514 | 2022-03-09 | Atchison | Missouri | 29005 | 1380 | 20 |
2286262 | 2286262 | 2022-03-08 | Atchison | Missouri | 29005 | 1381 | 20 |
2283010 | 2283010 | 2022-03-07 | Atchison | Missouri | 29005 | 1380 | 19 |
2279757 | 2279757 | 2022-03-06 | Atchison | Missouri | 29005 | 1379 | 19 |
2276504 | 2276504 | 2022-03-05 | Atchison | Missouri | 29005 | 1379 | 19 |
2273251 | 2273251 | 2022-03-04 | Atchison | Missouri | 29005 | 1379 | 19 |
2269999 | 2269999 | 2022-03-03 | Atchison | Missouri | 29005 | 1376 | 19 |
2266746 | 2266746 | 2022-03-02 | Atchison | Missouri | 29005 | 1377 | 19 |
2263495 | 2263495 | 2022-03-01 | Atchison | Missouri | 29005 | 1377 | 19 |
2260244 | 2260244 | 2022-02-28 | Atchison | Missouri | 29005 | 1374 | 19 |
2256993 | 2256993 | 2022-02-27 | Atchison | Missouri | 29005 | 1373 | 19 |
2253742 | 2253742 | 2022-02-26 | Atchison | Missouri | 29005 | 1373 | 19 |
2250491 | 2250491 | 2022-02-25 | Atchison | Missouri | 29005 | 1373 | 19 |
2247240 | 2247240 | 2022-02-24 | Atchison | Missouri | 29005 | 1373 | 19 |
2243989 | 2243989 | 2022-02-23 | Atchison | Missouri | 29005 | 1373 | 19 |
2240738 | 2240738 | 2022-02-22 | Atchison | Missouri | 29005 | 1371 | 19 |
2237487 | 2237487 | 2022-02-21 | Atchison | Missouri | 29005 | 1369 | 19 |
2234236 | 2234236 | 2022-02-20 | Atchison | Missouri | 29005 | 1369 | 19 |
2230985 | 2230985 | 2022-02-19 | Atchison | Missouri | 29005 | 1369 | 19 |
2227734 | 2227734 | 2022-02-18 | Atchison | Missouri | 29005 | 1369 | 19 |
2224483 | 2224483 | 2022-02-17 | Atchison | Missouri | 29005 | 1363 | 19 |
2221232 | 2221232 | 2022-02-16 | Atchison | Missouri | 29005 | 1358 | 19 |
2217981 | 2217981 | 2022-02-15 | Atchison | Missouri | 29005 | 1345 | 19 |
2214730 | 2214730 | 2022-02-14 | Atchison | Missouri | 29005 | 1343 | 19 |
2211478 | 2211478 | 2022-02-13 | Atchison | Missouri | 29005 | 1333 | 19 |
2208225 | 2208225 | 2022-02-12 | Atchison | Missouri | 29005 | 1333 | 19 |
2204972 | 2204972 | 2022-02-11 | Atchison | Missouri | 29005 | 1333 | 19 |
2201719 | 2201719 | 2022-02-10 | Atchison | Missouri | 29005 | 1333 | 19 |
2198465 | 2198465 | 2022-02-09 | Atchison | Missouri | 29005 | 1305 | 19 |
2195211 | 2195211 | 2022-02-08 | Atchison | Missouri | 29005 | 1288 | 19 |
2191957 | 2191957 | 2022-02-07 | Atchison | Missouri | 29005 | 1281 | 19 |
2188704 | 2188704 | 2022-02-06 | Atchison | Missouri | 29005 | 1281 | 19 |
2185451 | 2185451 | 2022-02-05 | Atchison | Missouri | 29005 | 1281 | 19 |
2182199 | 2182199 | 2022-02-04 | Atchison | Missouri | 29005 | 1273 | 19 |
2178947 | 2178947 | 2022-02-03 | Atchison | Missouri | 29005 | 1255 | 19 |
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);