ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
999 rows where deaths = 13 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Ralls 91
- Shelby 75
- Mercer 51
- Scott 45
- Knox 44
- Linn 43
- Daviess 35
- Monroe 30
- Lewis 28
- Sullivan 27
- Newton 26
- Dunklin 24
- Caldwell 22
- McDonald 20
- Hickory 19
- Shannon 19
- Andrew 18
- Montgomery 17
- Platte 17
- Ste. Genevieve 17
- Holt 16
- Howard 16
- Barton 14
- Carter 14
- Lincoln 14
- Vernon 14
- Madison 13
- Iron 11
- Stone 11
- Bollinger 10
- …
state 1
- Missouri · 999 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471809 | 2471809 | 2022-05-04 | Knox | Missouri | 29103 | 977 | 13 |
2471822 | 2471822 | 2022-05-04 | Mercer | Missouri | 29129 | 697 | 13 |
2468553 | 2468553 | 2022-05-03 | Knox | Missouri | 29103 | 977 | 13 |
2468566 | 2468566 | 2022-05-03 | Mercer | Missouri | 29129 | 697 | 13 |
2465297 | 2465297 | 2022-05-02 | Knox | Missouri | 29103 | 977 | 13 |
2465310 | 2465310 | 2022-05-02 | Mercer | Missouri | 29129 | 697 | 13 |
2462042 | 2462042 | 2022-05-01 | Knox | Missouri | 29103 | 977 | 13 |
2462055 | 2462055 | 2022-05-01 | Mercer | Missouri | 29129 | 697 | 13 |
2458786 | 2458786 | 2022-04-30 | Knox | Missouri | 29103 | 977 | 13 |
2458799 | 2458799 | 2022-04-30 | Mercer | Missouri | 29129 | 697 | 13 |
2455530 | 2455530 | 2022-04-29 | Knox | Missouri | 29103 | 977 | 13 |
2455543 | 2455543 | 2022-04-29 | Mercer | Missouri | 29129 | 697 | 13 |
2452274 | 2452274 | 2022-04-28 | Knox | Missouri | 29103 | 977 | 13 |
2452287 | 2452287 | 2022-04-28 | Mercer | Missouri | 29129 | 697 | 13 |
2449018 | 2449018 | 2022-04-27 | Knox | Missouri | 29103 | 977 | 13 |
2449031 | 2449031 | 2022-04-27 | Mercer | Missouri | 29129 | 697 | 13 |
2445761 | 2445761 | 2022-04-26 | Knox | Missouri | 29103 | 977 | 13 |
2445774 | 2445774 | 2022-04-26 | Mercer | Missouri | 29129 | 697 | 13 |
2442506 | 2442506 | 2022-04-25 | Knox | Missouri | 29103 | 977 | 13 |
2442519 | 2442519 | 2022-04-25 | Mercer | Missouri | 29129 | 697 | 13 |
2439250 | 2439250 | 2022-04-24 | Knox | Missouri | 29103 | 977 | 13 |
2439263 | 2439263 | 2022-04-24 | Mercer | Missouri | 29129 | 697 | 13 |
2435994 | 2435994 | 2022-04-23 | Knox | Missouri | 29103 | 977 | 13 |
2436007 | 2436007 | 2022-04-23 | Mercer | Missouri | 29129 | 697 | 13 |
2432738 | 2432738 | 2022-04-22 | Knox | Missouri | 29103 | 977 | 13 |
2432751 | 2432751 | 2022-04-22 | Mercer | Missouri | 29129 | 697 | 13 |
2429482 | 2429482 | 2022-04-21 | Knox | Missouri | 29103 | 977 | 13 |
2429495 | 2429495 | 2022-04-21 | Mercer | Missouri | 29129 | 697 | 13 |
2426226 | 2426226 | 2022-04-20 | Knox | Missouri | 29103 | 977 | 13 |
2426239 | 2426239 | 2022-04-20 | Mercer | Missouri | 29129 | 697 | 13 |
2422970 | 2422970 | 2022-04-19 | Knox | Missouri | 29103 | 977 | 13 |
2422983 | 2422983 | 2022-04-19 | Mercer | Missouri | 29129 | 697 | 13 |
2419713 | 2419713 | 2022-04-18 | Knox | Missouri | 29103 | 977 | 13 |
2419726 | 2419726 | 2022-04-18 | Mercer | Missouri | 29129 | 697 | 13 |
2416458 | 2416458 | 2022-04-17 | Knox | Missouri | 29103 | 977 | 13 |
2416471 | 2416471 | 2022-04-17 | Mercer | Missouri | 29129 | 697 | 13 |
2413202 | 2413202 | 2022-04-16 | Knox | Missouri | 29103 | 977 | 13 |
2413215 | 2413215 | 2022-04-16 | Mercer | Missouri | 29129 | 697 | 13 |
2409946 | 2409946 | 2022-04-15 | Knox | Missouri | 29103 | 977 | 13 |
2409959 | 2409959 | 2022-04-15 | Mercer | Missouri | 29129 | 697 | 13 |
2406690 | 2406690 | 2022-04-14 | Knox | Missouri | 29103 | 977 | 13 |
2406703 | 2406703 | 2022-04-14 | Mercer | Missouri | 29129 | 697 | 13 |
2403434 | 2403434 | 2022-04-13 | Knox | Missouri | 29103 | 977 | 13 |
2403447 | 2403447 | 2022-04-13 | Mercer | Missouri | 29129 | 697 | 13 |
2400179 | 2400179 | 2022-04-12 | Knox | Missouri | 29103 | 977 | 13 |
2400192 | 2400192 | 2022-04-12 | Mercer | Missouri | 29129 | 697 | 13 |
2396924 | 2396924 | 2022-04-11 | Knox | Missouri | 29103 | 977 | 13 |
2396937 | 2396937 | 2022-04-11 | Mercer | Missouri | 29129 | 697 | 13 |
2393669 | 2393669 | 2022-04-10 | Knox | Missouri | 29103 | 977 | 13 |
2393682 | 2393682 | 2022-04-10 | Mercer | Missouri | 29129 | 697 | 13 |
2390413 | 2390413 | 2022-04-09 | Knox | Missouri | 29103 | 977 | 13 |
2390426 | 2390426 | 2022-04-09 | Mercer | Missouri | 29129 | 697 | 13 |
2387157 | 2387157 | 2022-04-08 | Knox | Missouri | 29103 | 977 | 13 |
2387170 | 2387170 | 2022-04-08 | Mercer | Missouri | 29129 | 697 | 13 |
2383902 | 2383902 | 2022-04-07 | Knox | Missouri | 29103 | 977 | 13 |
2383915 | 2383915 | 2022-04-07 | Mercer | Missouri | 29129 | 697 | 13 |
2380647 | 2380647 | 2022-04-06 | Knox | Missouri | 29103 | 977 | 13 |
2380660 | 2380660 | 2022-04-06 | Mercer | Missouri | 29129 | 697 | 13 |
2377392 | 2377392 | 2022-04-05 | Knox | Missouri | 29103 | 977 | 13 |
2377405 | 2377405 | 2022-04-05 | Mercer | Missouri | 29129 | 697 | 13 |
2374139 | 2374139 | 2022-04-04 | Knox | Missouri | 29103 | 977 | 13 |
2374152 | 2374152 | 2022-04-04 | Mercer | Missouri | 29129 | 697 | 13 |
2370887 | 2370887 | 2022-04-03 | Knox | Missouri | 29103 | 977 | 13 |
2370900 | 2370900 | 2022-04-03 | Mercer | Missouri | 29129 | 697 | 13 |
2367634 | 2367634 | 2022-04-02 | Knox | Missouri | 29103 | 977 | 13 |
2367647 | 2367647 | 2022-04-02 | Mercer | Missouri | 29129 | 697 | 13 |
2364381 | 2364381 | 2022-04-01 | Knox | Missouri | 29103 | 977 | 13 |
2364394 | 2364394 | 2022-04-01 | Mercer | Missouri | 29129 | 697 | 13 |
2361127 | 2361127 | 2022-03-31 | Knox | Missouri | 29103 | 977 | 13 |
2361140 | 2361140 | 2022-03-31 | Mercer | Missouri | 29129 | 697 | 13 |
2357873 | 2357873 | 2022-03-30 | Knox | Missouri | 29103 | 977 | 13 |
2357886 | 2357886 | 2022-03-30 | Mercer | Missouri | 29129 | 697 | 13 |
2354620 | 2354620 | 2022-03-29 | Knox | Missouri | 29103 | 976 | 13 |
2354633 | 2354633 | 2022-03-29 | Mercer | Missouri | 29129 | 697 | 13 |
2351367 | 2351367 | 2022-03-28 | Knox | Missouri | 29103 | 974 | 13 |
2351380 | 2351380 | 2022-03-28 | Mercer | Missouri | 29129 | 697 | 13 |
2348115 | 2348115 | 2022-03-27 | Knox | Missouri | 29103 | 970 | 13 |
2348128 | 2348128 | 2022-03-27 | Mercer | Missouri | 29129 | 696 | 13 |
2344862 | 2344862 | 2022-03-26 | Knox | Missouri | 29103 | 970 | 13 |
2344875 | 2344875 | 2022-03-26 | Mercer | Missouri | 29129 | 696 | 13 |
2341609 | 2341609 | 2022-03-25 | Knox | Missouri | 29103 | 970 | 13 |
2341622 | 2341622 | 2022-03-25 | Mercer | Missouri | 29129 | 696 | 13 |
2338356 | 2338356 | 2022-03-24 | Knox | Missouri | 29103 | 967 | 13 |
2338369 | 2338369 | 2022-03-24 | Mercer | Missouri | 29129 | 696 | 13 |
2335102 | 2335102 | 2022-03-23 | Knox | Missouri | 29103 | 967 | 13 |
2335115 | 2335115 | 2022-03-23 | Mercer | Missouri | 29129 | 695 | 13 |
2331848 | 2331848 | 2022-03-22 | Knox | Missouri | 29103 | 966 | 13 |
2331861 | 2331861 | 2022-03-22 | Mercer | Missouri | 29129 | 695 | 13 |
2328608 | 2328608 | 2022-03-21 | Mercer | Missouri | 29129 | 694 | 13 |
2325356 | 2325356 | 2022-03-20 | Mercer | Missouri | 29129 | 694 | 13 |
2322102 | 2322102 | 2022-03-19 | Mercer | Missouri | 29129 | 694 | 13 |
2318848 | 2318848 | 2022-03-18 | Mercer | Missouri | 29129 | 694 | 13 |
2315595 | 2315595 | 2022-03-17 | Mercer | Missouri | 29129 | 694 | 13 |
2312342 | 2312342 | 2022-03-16 | Mercer | Missouri | 29129 | 694 | 13 |
2309089 | 2309089 | 2022-03-15 | Mercer | Missouri | 29129 | 694 | 13 |
2169285 | 2169285 | 2022-01-31 | Shelby | Missouri | 29205 | 1424 | 13 |
2166030 | 2166030 | 2022-01-30 | Shelby | Missouri | 29205 | 1422 | 13 |
2162775 | 2162775 | 2022-01-29 | Shelby | Missouri | 29205 | 1418 | 13 |
2159520 | 2159520 | 2022-01-28 | Shelby | Missouri | 29205 | 1410 | 13 |
2156266 | 2156266 | 2022-01-27 | Shelby | Missouri | 29205 | 1404 | 13 |
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);