ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,511 rows where fips = "" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501127 | 2501127 | 2022-05-13 | Joplin | Missouri | 13761 | 219 | |
2501128 | 2501128 | 2022-05-13 | Kansas City | Missouri | 114636 | 1310 | |
2497869 | 2497869 | 2022-05-12 | Joplin | Missouri | 13738 | 219 | |
2497870 | 2497870 | 2022-05-12 | Kansas City | Missouri | 114124 | 1306 | |
2494611 | 2494611 | 2022-05-11 | Joplin | Missouri | 13738 | 219 | |
2494612 | 2494612 | 2022-05-11 | Kansas City | Missouri | 114124 | 1306 | |
2491353 | 2491353 | 2022-05-10 | Joplin | Missouri | 13738 | 219 | |
2491354 | 2491354 | 2022-05-10 | Kansas City | Missouri | 114124 | 1306 | |
2488095 | 2488095 | 2022-05-09 | Joplin | Missouri | 13738 | 219 | |
2488096 | 2488096 | 2022-05-09 | Kansas City | Missouri | 114124 | 1306 | |
2484838 | 2484838 | 2022-05-08 | Joplin | Missouri | 13738 | 219 | |
2484839 | 2484839 | 2022-05-08 | Kansas City | Missouri | 114124 | 1306 | |
2481580 | 2481580 | 2022-05-07 | Joplin | Missouri | 13738 | 219 | |
2481581 | 2481581 | 2022-05-07 | Kansas City | Missouri | 114124 | 1306 | |
2478322 | 2478322 | 2022-05-06 | Joplin | Missouri | 13738 | 219 | |
2478323 | 2478323 | 2022-05-06 | Kansas City | Missouri | 114124 | 1306 | |
2475064 | 2475064 | 2022-05-05 | Joplin | Missouri | 13735 | 219 | |
2475065 | 2475065 | 2022-05-05 | Kansas City | Missouri | 113605 | 1304 | |
2471807 | 2471807 | 2022-05-04 | Joplin | Missouri | 13735 | 217 | |
2471808 | 2471808 | 2022-05-04 | Kansas City | Missouri | 112687 | 1290 | |
2468551 | 2468551 | 2022-05-03 | Joplin | Missouri | 13735 | 217 | |
2468552 | 2468552 | 2022-05-03 | Kansas City | Missouri | 112687 | 1290 | |
2465295 | 2465295 | 2022-05-02 | Joplin | Missouri | 13735 | 217 | |
2465296 | 2465296 | 2022-05-02 | Kansas City | Missouri | 112687 | 1290 | |
2462040 | 2462040 | 2022-05-01 | Joplin | Missouri | 13735 | 217 | |
2462041 | 2462041 | 2022-05-01 | Kansas City | Missouri | 112687 | 1290 | |
2458784 | 2458784 | 2022-04-30 | Joplin | Missouri | 13735 | 217 | |
2458785 | 2458785 | 2022-04-30 | Kansas City | Missouri | 112687 | 1290 | |
2455528 | 2455528 | 2022-04-29 | Joplin | Missouri | 13735 | 217 | |
2455529 | 2455529 | 2022-04-29 | Kansas City | Missouri | 112687 | 1290 | |
2452272 | 2452272 | 2022-04-28 | Joplin | Missouri | 13735 | 217 | |
2452273 | 2452273 | 2022-04-28 | Kansas City | Missouri | 112687 | 1290 | |
2449016 | 2449016 | 2022-04-27 | Joplin | Missouri | 13735 | 217 | |
2449017 | 2449017 | 2022-04-27 | Kansas City | Missouri | 112687 | 1290 | |
2445759 | 2445759 | 2022-04-26 | Joplin | Missouri | 13735 | 217 | |
2445760 | 2445760 | 2022-04-26 | Kansas City | Missouri | 112687 | 1290 | |
2442504 | 2442504 | 2022-04-25 | Joplin | Missouri | 13735 | 217 | |
2442505 | 2442505 | 2022-04-25 | Kansas City | Missouri | 112687 | 1290 | |
2439248 | 2439248 | 2022-04-24 | Joplin | Missouri | 13735 | 217 | |
2439249 | 2439249 | 2022-04-24 | Kansas City | Missouri | 112687 | 1290 | |
2435992 | 2435992 | 2022-04-23 | Joplin | Missouri | 13735 | 217 | |
2435993 | 2435993 | 2022-04-23 | Kansas City | Missouri | 112687 | 1290 | |
2432736 | 2432736 | 2022-04-22 | Joplin | Missouri | 13735 | 217 | |
2432737 | 2432737 | 2022-04-22 | Kansas City | Missouri | 112687 | 1290 | |
2429480 | 2429480 | 2022-04-21 | Joplin | Missouri | 13735 | 217 | |
2429481 | 2429481 | 2022-04-21 | Kansas City | Missouri | 112687 | 1290 | |
2426224 | 2426224 | 2022-04-20 | Joplin | Missouri | 13735 | 217 | |
2426225 | 2426225 | 2022-04-20 | Kansas City | Missouri | 112687 | 1290 | |
2422968 | 2422968 | 2022-04-19 | Joplin | Missouri | 13735 | 217 | |
2422969 | 2422969 | 2022-04-19 | Kansas City | Missouri | 112687 | 1290 | |
2419711 | 2419711 | 2022-04-18 | Joplin | Missouri | 13735 | 217 | |
2419712 | 2419712 | 2022-04-18 | Kansas City | Missouri | 112687 | 1290 | |
2416456 | 2416456 | 2022-04-17 | Joplin | Missouri | 13735 | 217 | |
2416457 | 2416457 | 2022-04-17 | Kansas City | Missouri | 112687 | 1290 | |
2413200 | 2413200 | 2022-04-16 | Joplin | Missouri | 13735 | 217 | |
2413201 | 2413201 | 2022-04-16 | Kansas City | Missouri | 112687 | 1290 | |
2409944 | 2409944 | 2022-04-15 | Joplin | Missouri | 13735 | 217 | |
2409945 | 2409945 | 2022-04-15 | Kansas City | Missouri | 112687 | 1290 | |
2406688 | 2406688 | 2022-04-14 | Joplin | Missouri | 13735 | 217 | |
2406689 | 2406689 | 2022-04-14 | Kansas City | Missouri | 112687 | 1290 | |
2403432 | 2403432 | 2022-04-13 | Joplin | Missouri | 13735 | 217 | |
2403433 | 2403433 | 2022-04-13 | Kansas City | Missouri | 112687 | 1290 | |
2400177 | 2400177 | 2022-04-12 | Joplin | Missouri | 13735 | 217 | |
2400178 | 2400178 | 2022-04-12 | Kansas City | Missouri | 112687 | 1290 | |
2396922 | 2396922 | 2022-04-11 | Joplin | Missouri | 13735 | 217 | |
2396923 | 2396923 | 2022-04-11 | Kansas City | Missouri | 112687 | 1290 | |
2393667 | 2393667 | 2022-04-10 | Joplin | Missouri | 13735 | 217 | |
2393668 | 2393668 | 2022-04-10 | Kansas City | Missouri | 112687 | 1290 | |
2390411 | 2390411 | 2022-04-09 | Joplin | Missouri | 13735 | 217 | |
2390412 | 2390412 | 2022-04-09 | Kansas City | Missouri | 112687 | 1290 | |
2387155 | 2387155 | 2022-04-08 | Joplin | Missouri | 13735 | 217 | |
2387156 | 2387156 | 2022-04-08 | Kansas City | Missouri | 112687 | 1290 | |
2383900 | 2383900 | 2022-04-07 | Joplin | Missouri | 13735 | 217 | |
2383901 | 2383901 | 2022-04-07 | Kansas City | Missouri | 112687 | 1290 | |
2380645 | 2380645 | 2022-04-06 | Joplin | Missouri | 13735 | 217 | |
2380646 | 2380646 | 2022-04-06 | Kansas City | Missouri | 112687 | 1290 | |
2377390 | 2377390 | 2022-04-05 | Joplin | Missouri | 13735 | 217 | |
2377391 | 2377391 | 2022-04-05 | Kansas City | Missouri | 112687 | 1290 | |
2374137 | 2374137 | 2022-04-04 | Joplin | Missouri | 13735 | 217 | |
2374138 | 2374138 | 2022-04-04 | Kansas City | Missouri | 112687 | 1290 | |
2370885 | 2370885 | 2022-04-03 | Joplin | Missouri | 13735 | 217 | |
2370886 | 2370886 | 2022-04-03 | Kansas City | Missouri | 112687 | 1290 | |
2367632 | 2367632 | 2022-04-02 | Joplin | Missouri | 13735 | 217 | |
2367633 | 2367633 | 2022-04-02 | Kansas City | Missouri | 112687 | 1290 | |
2364379 | 2364379 | 2022-04-01 | Joplin | Missouri | 13735 | 217 | |
2364380 | 2364380 | 2022-04-01 | Kansas City | Missouri | 112687 | 1290 | |
2361125 | 2361125 | 2022-03-31 | Joplin | Missouri | 13735 | 217 | |
2361126 | 2361126 | 2022-03-31 | Kansas City | Missouri | 112687 | 1290 | |
2357871 | 2357871 | 2022-03-30 | Joplin | Missouri | 13735 | 217 | |
2357872 | 2357872 | 2022-03-30 | Kansas City | Missouri | 112638 | 1289 | |
2354618 | 2354618 | 2022-03-29 | Joplin | Missouri | 13731 | 217 | |
2354619 | 2354619 | 2022-03-29 | Kansas City | Missouri | 112592 | 1288 | |
2351365 | 2351365 | 2022-03-28 | Joplin | Missouri | 13729 | 216 | |
2351366 | 2351366 | 2022-03-28 | Kansas City | Missouri | 112560 | 1280 | |
2348113 | 2348113 | 2022-03-27 | Joplin | Missouri | 13729 | 216 | |
2348114 | 2348114 | 2022-03-27 | Kansas City | Missouri | 112464 | 1279 | |
2344860 | 2344860 | 2022-03-26 | Joplin | Missouri | 13729 | 216 | |
2344861 | 2344861 | 2022-03-26 | Kansas City | Missouri | 112464 | 1279 | |
2341607 | 2341607 | 2022-03-25 | Joplin | Missouri | 13729 | 216 | |
2341608 | 2341608 | 2022-03-25 | Kansas City | Missouri | 112464 | 1279 |
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);