ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where deaths = 140 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 9
state 1
- Missouri · 100 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471806 | 2471806 | 2022-05-04 | Johnson | Missouri | 29101 | 12165 | 140 |
2468550 | 2468550 | 2022-05-03 | Johnson | Missouri | 29101 | 12165 | 140 |
2465294 | 2465294 | 2022-05-02 | Johnson | Missouri | 29101 | 12165 | 140 |
2462039 | 2462039 | 2022-05-01 | Johnson | Missouri | 29101 | 12165 | 140 |
2458783 | 2458783 | 2022-04-30 | Johnson | Missouri | 29101 | 12165 | 140 |
2455527 | 2455527 | 2022-04-29 | Johnson | Missouri | 29101 | 12165 | 140 |
2452271 | 2452271 | 2022-04-28 | Johnson | Missouri | 29101 | 12165 | 140 |
2449015 | 2449015 | 2022-04-27 | Johnson | Missouri | 29101 | 12165 | 140 |
2445758 | 2445758 | 2022-04-26 | Johnson | Missouri | 29101 | 12165 | 140 |
2442503 | 2442503 | 2022-04-25 | Johnson | Missouri | 29101 | 12165 | 140 |
2439247 | 2439247 | 2022-04-24 | Johnson | Missouri | 29101 | 12165 | 140 |
2435991 | 2435991 | 2022-04-23 | Johnson | Missouri | 29101 | 12165 | 140 |
2432735 | 2432735 | 2022-04-22 | Johnson | Missouri | 29101 | 12165 | 140 |
2429479 | 2429479 | 2022-04-21 | Johnson | Missouri | 29101 | 12165 | 140 |
2426223 | 2426223 | 2022-04-20 | Johnson | Missouri | 29101 | 12165 | 140 |
2422967 | 2422967 | 2022-04-19 | Johnson | Missouri | 29101 | 12165 | 140 |
2419710 | 2419710 | 2022-04-18 | Johnson | Missouri | 29101 | 12165 | 140 |
2416455 | 2416455 | 2022-04-17 | Johnson | Missouri | 29101 | 12165 | 140 |
2413199 | 2413199 | 2022-04-16 | Johnson | Missouri | 29101 | 12165 | 140 |
2409943 | 2409943 | 2022-04-15 | Johnson | Missouri | 29101 | 12165 | 140 |
2406687 | 2406687 | 2022-04-14 | Johnson | Missouri | 29101 | 12165 | 140 |
2403431 | 2403431 | 2022-04-13 | Johnson | Missouri | 29101 | 12165 | 140 |
2400176 | 2400176 | 2022-04-12 | Johnson | Missouri | 29101 | 12165 | 140 |
2396921 | 2396921 | 2022-04-11 | Johnson | Missouri | 29101 | 12165 | 140 |
2393666 | 2393666 | 2022-04-10 | Johnson | Missouri | 29101 | 12165 | 140 |
2390410 | 2390410 | 2022-04-09 | Johnson | Missouri | 29101 | 12165 | 140 |
2387154 | 2387154 | 2022-04-08 | Johnson | Missouri | 29101 | 12165 | 140 |
2383899 | 2383899 | 2022-04-07 | Johnson | Missouri | 29101 | 12165 | 140 |
2380644 | 2380644 | 2022-04-06 | Johnson | Missouri | 29101 | 12165 | 140 |
2377389 | 2377389 | 2022-04-05 | Johnson | Missouri | 29101 | 12165 | 140 |
2374136 | 2374136 | 2022-04-04 | Johnson | Missouri | 29101 | 12165 | 140 |
2370884 | 2370884 | 2022-04-03 | Johnson | Missouri | 29101 | 12165 | 140 |
2367631 | 2367631 | 2022-04-02 | Johnson | Missouri | 29101 | 12165 | 140 |
2364378 | 2364378 | 2022-04-01 | Johnson | Missouri | 29101 | 12165 | 140 |
2361124 | 2361124 | 2022-03-31 | Johnson | Missouri | 29101 | 12165 | 140 |
2357870 | 2357870 | 2022-03-30 | Johnson | Missouri | 29101 | 12156 | 140 |
2354617 | 2354617 | 2022-03-29 | Johnson | Missouri | 29101 | 12154 | 140 |
2351364 | 2351364 | 2022-03-28 | Johnson | Missouri | 29101 | 12150 | 140 |
2348112 | 2348112 | 2022-03-27 | Johnson | Missouri | 29101 | 12141 | 140 |
2344859 | 2344859 | 2022-03-26 | Johnson | Missouri | 29101 | 12141 | 140 |
2341606 | 2341606 | 2022-03-25 | Johnson | Missouri | 29101 | 12141 | 140 |
2338353 | 2338353 | 2022-03-24 | Johnson | Missouri | 29101 | 12141 | 140 |
2335099 | 2335099 | 2022-03-23 | Johnson | Missouri | 29101 | 12139 | 140 |
2331845 | 2331845 | 2022-03-22 | Johnson | Missouri | 29101 | 12138 | 140 |
2169198 | 2169198 | 2022-01-31 | Butler | Missouri | 29023 | 9333 | 140 |
2169283 | 2169283 | 2022-01-31 | Scott | Missouri | 29201 | 10300 | 140 |
2165943 | 2165943 | 2022-01-30 | Butler | Missouri | 29023 | 9334 | 140 |
2166028 | 2166028 | 2022-01-30 | Scott | Missouri | 29201 | 10288 | 140 |
2162688 | 2162688 | 2022-01-29 | Butler | Missouri | 29023 | 9290 | 140 |
2162773 | 2162773 | 2022-01-29 | Scott | Missouri | 29201 | 10275 | 140 |
2159433 | 2159433 | 2022-01-28 | Butler | Missouri | 29023 | 9217 | 140 |
2159518 | 2159518 | 2022-01-28 | Scott | Missouri | 29201 | 10217 | 140 |
2156179 | 2156179 | 2022-01-27 | Butler | Missouri | 29023 | 9122 | 140 |
2156264 | 2156264 | 2022-01-27 | Scott | Missouri | 29201 | 10114 | 140 |
2152926 | 2152926 | 2022-01-26 | Butler | Missouri | 29023 | 9052 | 140 |
2153011 | 2153011 | 2022-01-26 | Scott | Missouri | 29201 | 9994 | 140 |
2149674 | 2149674 | 2022-01-25 | Butler | Missouri | 29023 | 9003 | 140 |
2149759 | 2149759 | 2022-01-25 | Scott | Missouri | 29201 | 9937 | 140 |
2146507 | 2146507 | 2022-01-24 | Scott | Missouri | 29201 | 9831 | 140 |
2143252 | 2143252 | 2022-01-23 | Scott | Missouri | 29201 | 9798 | 140 |
2139997 | 2139997 | 2022-01-22 | Scott | Missouri | 29201 | 9759 | 140 |
2136741 | 2136741 | 2022-01-21 | Scott | Missouri | 29201 | 9700 | 140 |
2133489 | 2133489 | 2022-01-20 | Scott | Missouri | 29201 | 9548 | 140 |
2130236 | 2130236 | 2022-01-19 | Scott | Missouri | 29201 | 9417 | 140 |
2100930 | 2100930 | 2022-01-10 | Lawrence | Missouri | 29109 | 6069 | 140 |
2097679 | 2097679 | 2022-01-09 | Lawrence | Missouri | 29109 | 6041 | 140 |
2094427 | 2094427 | 2022-01-08 | Lawrence | Missouri | 29109 | 6010 | 140 |
2091175 | 2091175 | 2022-01-07 | Lawrence | Missouri | 29109 | 5977 | 140 |
2087924 | 2087924 | 2022-01-06 | Lawrence | Missouri | 29109 | 5950 | 140 |
2084672 | 2084672 | 2022-01-05 | Lawrence | Missouri | 29109 | 5936 | 140 |
2081420 | 2081420 | 2022-01-04 | Lawrence | Missouri | 29109 | 5904 | 140 |
1678416 | 1678416 | 2021-09-02 | Boone | Missouri | 29019 | 22991 | 140 |
1675168 | 1675168 | 2021-09-01 | Boone | Missouri | 29019 | 22991 | 140 |
1671920 | 1671920 | 2021-08-31 | Boone | Missouri | 29019 | 22991 | 140 |
1668673 | 1668673 | 2021-08-30 | Boone | Missouri | 29019 | 22931 | 140 |
1568044 | 1568044 | 2021-07-30 | Phelps | Missouri | 29161 | 4774 | 140 |
1564796 | 1564796 | 2021-07-29 | Phelps | Missouri | 29161 | 4735 | 140 |
1561548 | 1561548 | 2021-07-28 | Phelps | Missouri | 29161 | 4702 | 140 |
1558266 | 1558266 | 2021-07-27 | Jasper | Missouri | 29097 | 11450 | 140 |
1558300 | 1558300 | 2021-07-27 | Phelps | Missouri | 29161 | 4664 | 140 |
1555019 | 1555019 | 2021-07-26 | Jasper | Missouri | 29097 | 11376 | 140 |
1551772 | 1551772 | 2021-07-25 | Jasper | Missouri | 29097 | 11368 | 140 |
1548525 | 1548525 | 2021-07-24 | Jasper | Missouri | 29097 | 11357 | 140 |
1545278 | 1545278 | 2021-07-23 | Jasper | Missouri | 29097 | 11299 | 140 |
1541997 | 1541997 | 2021-07-22 | Cape Girardeau | Missouri | 29031 | 9685 | 140 |
1542030 | 1542030 | 2021-07-22 | Jasper | Missouri | 29097 | 11229 | 140 |
1538750 | 1538750 | 2021-07-21 | Cape Girardeau | Missouri | 29031 | 9685 | 140 |
1538783 | 1538783 | 2021-07-21 | Jasper | Missouri | 29097 | 11157 | 140 |
1535503 | 1535503 | 2021-07-20 | Cape Girardeau | Missouri | 29031 | 9652 | 140 |
1535536 | 1535536 | 2021-07-20 | Jasper | Missouri | 29097 | 11056 | 140 |
1532255 | 1532255 | 2021-07-19 | Cape Girardeau | Missouri | 29031 | 9652 | 140 |
1529008 | 1529008 | 2021-07-18 | Cape Girardeau | Missouri | 29031 | 9652 | 140 |
1525761 | 1525761 | 2021-07-17 | Cape Girardeau | Missouri | 29031 | 9652 | 140 |
1522514 | 1522514 | 2021-07-16 | Cape Girardeau | Missouri | 29031 | 9652 | 140 |
1519265 | 1519265 | 2021-07-15 | Cape Girardeau | Missouri | 29031 | 9652 | 140 |
1516018 | 1516018 | 2021-07-14 | Cape Girardeau | Missouri | 29031 | 9652 | 140 |
1512772 | 1512772 | 2021-07-13 | Cape Girardeau | Missouri | 29031 | 9616 | 140 |
691583 | 691583 | 2020-11-02 | Jackson | Missouri | 29095 | 10777 | 140 |
688338 | 688338 | 2020-11-01 | Jackson | Missouri | 29095 | 10582 | 140 |
685094 | 685094 | 2020-10-31 | Jackson | Missouri | 29095 | 10480 | 140 |
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);