ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
174 rows where deaths = 89 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2305777 | 2305777 | 2022-03-14 | Bates | Missouri | 29013 | 3738 | 89 |
2305861 | 2305861 | 2022-03-14 | Ray | Missouri | 29177 | 5134 | 89 |
2302526 | 2302526 | 2022-03-13 | Bates | Missouri | 29013 | 3735 | 89 |
2302610 | 2302610 | 2022-03-13 | Ray | Missouri | 29177 | 5132 | 89 |
2299274 | 2299274 | 2022-03-12 | Bates | Missouri | 29013 | 3735 | 89 |
2299358 | 2299358 | 2022-03-12 | Ray | Missouri | 29177 | 5132 | 89 |
2296022 | 2296022 | 2022-03-11 | Bates | Missouri | 29013 | 3735 | 89 |
2296106 | 2296106 | 2022-03-11 | Ray | Missouri | 29177 | 5132 | 89 |
2292770 | 2292770 | 2022-03-10 | Bates | Missouri | 29013 | 3734 | 89 |
2292854 | 2292854 | 2022-03-10 | Ray | Missouri | 29177 | 5132 | 89 |
2289518 | 2289518 | 2022-03-09 | Bates | Missouri | 29013 | 3733 | 89 |
2289602 | 2289602 | 2022-03-09 | Ray | Missouri | 29177 | 5129 | 89 |
2286266 | 2286266 | 2022-03-08 | Bates | Missouri | 29013 | 3731 | 89 |
2286350 | 2286350 | 2022-03-08 | Ray | Missouri | 29177 | 5128 | 89 |
2279845 | 2279845 | 2022-03-06 | Ray | Missouri | 29177 | 5125 | 89 |
2276592 | 2276592 | 2022-03-05 | Ray | Missouri | 29177 | 5125 | 89 |
2273339 | 2273339 | 2022-03-04 | Ray | Missouri | 29177 | 5125 | 89 |
2260332 | 2260332 | 2022-02-28 | Ray | Missouri | 29177 | 5104 | 89 |
2260351 | 2260351 | 2022-02-28 | Texas | Missouri | 29215 | 4618 | 89 |
2257081 | 2257081 | 2022-02-27 | Ray | Missouri | 29177 | 5082 | 89 |
2257100 | 2257100 | 2022-02-27 | Texas | Missouri | 29215 | 4617 | 89 |
2253830 | 2253830 | 2022-02-26 | Ray | Missouri | 29177 | 5082 | 89 |
2253849 | 2253849 | 2022-02-26 | Texas | Missouri | 29215 | 4617 | 89 |
2250579 | 2250579 | 2022-02-25 | Ray | Missouri | 29177 | 5082 | 89 |
2250598 | 2250598 | 2022-02-25 | Texas | Missouri | 29215 | 4617 | 89 |
2247328 | 2247328 | 2022-02-24 | Ray | Missouri | 29177 | 5077 | 89 |
2247347 | 2247347 | 2022-02-24 | Texas | Missouri | 29215 | 4614 | 89 |
2244096 | 2244096 | 2022-02-23 | Texas | Missouri | 29215 | 4612 | 89 |
2237570 | 2237570 | 2022-02-21 | Polk | Missouri | 29167 | 7946 | 89 |
2234319 | 2234319 | 2022-02-20 | Polk | Missouri | 29167 | 7946 | 89 |
2231068 | 2231068 | 2022-02-19 | Polk | Missouri | 29167 | 7946 | 89 |
2227817 | 2227817 | 2022-02-18 | Polk | Missouri | 29167 | 7946 | 89 |
2224566 | 2224566 | 2022-02-17 | Polk | Missouri | 29167 | 7946 | 89 |
2221315 | 2221315 | 2022-02-16 | Polk | Missouri | 29167 | 7927 | 89 |
2218064 | 2218064 | 2022-02-15 | Polk | Missouri | 29167 | 7911 | 89 |
2156279 | 2156279 | 2022-01-27 | Warren | Missouri | 29219 | 7719 | 89 |
2153026 | 2153026 | 2022-01-26 | Warren | Missouri | 29219 | 7660 | 89 |
2149774 | 2149774 | 2022-01-25 | Warren | Missouri | 29219 | 7612 | 89 |
2146522 | 2146522 | 2022-01-24 | Warren | Missouri | 29219 | 7569 | 89 |
2143267 | 2143267 | 2022-01-23 | Warren | Missouri | 29219 | 7552 | 89 |
2140012 | 2140012 | 2022-01-22 | Warren | Missouri | 29219 | 7479 | 89 |
2136734 | 2136734 | 2022-01-21 | Randolph | Missouri | 29175 | 5201 | 89 |
2136756 | 2136756 | 2022-01-21 | Warren | Missouri | 29219 | 7443 | 89 |
2133429 | 2133429 | 2022-01-20 | Gasconade | Missouri | 29073 | 2931 | 89 |
2133482 | 2133482 | 2022-01-20 | Randolph | Missouri | 29175 | 5122 | 89 |
2130176 | 2130176 | 2022-01-19 | Gasconade | Missouri | 29073 | 2871 | 89 |
2130229 | 2130229 | 2022-01-19 | Randolph | Missouri | 29175 | 5066 | 89 |
2126889 | 2126889 | 2022-01-18 | Audrain | Missouri | 29007 | 4868 | 89 |
2126975 | 2126975 | 2022-01-18 | Randolph | Missouri | 29175 | 4980 | 89 |
2123637 | 2123637 | 2022-01-17 | Audrain | Missouri | 29007 | 4809 | 89 |
2123723 | 2123723 | 2022-01-17 | Randolph | Missouri | 29175 | 4855 | 89 |
2120385 | 2120385 | 2022-01-16 | Audrain | Missouri | 29007 | 4809 | 89 |
2120471 | 2120471 | 2022-01-16 | Randolph | Missouri | 29175 | 4855 | 89 |
2117133 | 2117133 | 2022-01-15 | Audrain | Missouri | 29007 | 4808 | 89 |
2117219 | 2117219 | 2022-01-15 | Randolph | Missouri | 29175 | 4854 | 89 |
2113882 | 2113882 | 2022-01-14 | Audrain | Missouri | 29007 | 4755 | 89 |
2113968 | 2113968 | 2022-01-14 | Randolph | Missouri | 29175 | 4735 | 89 |
2113989 | 2113989 | 2022-01-14 | Vernon | Missouri | 29217 | 3970 | 89 |
2110630 | 2110630 | 2022-01-13 | Audrain | Missouri | 29007 | 4729 | 89 |
2110716 | 2110716 | 2022-01-13 | Randolph | Missouri | 29175 | 4697 | 89 |
2110737 | 2110737 | 2022-01-13 | Vernon | Missouri | 29217 | 3909 | 89 |
2107379 | 2107379 | 2022-01-12 | Audrain | Missouri | 29007 | 4687 | 89 |
2107465 | 2107465 | 2022-01-12 | Randolph | Missouri | 29175 | 4630 | 89 |
2107486 | 2107486 | 2022-01-12 | Vernon | Missouri | 29217 | 3845 | 89 |
2104128 | 2104128 | 2022-01-11 | Audrain | Missouri | 29007 | 4652 | 89 |
2104214 | 2104214 | 2022-01-11 | Randolph | Missouri | 29175 | 4580 | 89 |
2104235 | 2104235 | 2022-01-11 | Vernon | Missouri | 29217 | 3797 | 89 |
2100877 | 2100877 | 2022-01-10 | Audrain | Missouri | 29007 | 4615 | 89 |
2100967 | 2100967 | 2022-01-10 | Saline | Missouri | 29195 | 4943 | 89 |
2097626 | 2097626 | 2022-01-09 | Audrain | Missouri | 29007 | 4605 | 89 |
2097716 | 2097716 | 2022-01-09 | Saline | Missouri | 29195 | 4925 | 89 |
2094374 | 2094374 | 2022-01-08 | Audrain | Missouri | 29007 | 4598 | 89 |
2094464 | 2094464 | 2022-01-08 | Saline | Missouri | 29195 | 4923 | 89 |
2091122 | 2091122 | 2022-01-07 | Audrain | Missouri | 29007 | 4573 | 89 |
2091212 | 2091212 | 2022-01-07 | Saline | Missouri | 29195 | 4876 | 89 |
2087871 | 2087871 | 2022-01-06 | Audrain | Missouri | 29007 | 4548 | 89 |
2087961 | 2087961 | 2022-01-06 | Saline | Missouri | 29195 | 4847 | 89 |
2084619 | 2084619 | 2022-01-05 | Audrain | Missouri | 29007 | 4529 | 89 |
2084709 | 2084709 | 2022-01-05 | Saline | Missouri | 29195 | 4809 | 89 |
2081367 | 2081367 | 2022-01-04 | Audrain | Missouri | 29007 | 4507 | 89 |
2081457 | 2081457 | 2022-01-04 | Saline | Missouri | 29195 | 4771 | 89 |
2009910 | 2009910 | 2021-12-13 | Lafayette | Missouri | 29107 | 5264 | 89 |
2006659 | 2006659 | 2021-12-12 | Lafayette | Missouri | 29107 | 5254 | 89 |
2003408 | 2003408 | 2021-12-11 | Lafayette | Missouri | 29107 | 5236 | 89 |
2000158 | 2000158 | 2021-12-10 | Lafayette | Missouri | 29107 | 5211 | 89 |
1840969 | 1840969 | 2021-10-22 | Webster | Missouri | 29225 | 5710 | 89 |
1607044 | 1607044 | 2021-08-11 | Scott | Missouri | 29201 | 5157 | 89 |
1603795 | 1603795 | 2021-08-10 | Scott | Missouri | 29201 | 5113 | 89 |
1600546 | 1600546 | 2021-08-09 | Scott | Missouri | 29201 | 5099 | 89 |
1597298 | 1597298 | 2021-08-08 | Scott | Missouri | 29201 | 5090 | 89 |
1594049 | 1594049 | 2021-08-07 | Scott | Missouri | 29201 | 5052 | 89 |
1590800 | 1590800 | 2021-08-06 | Scott | Missouri | 29201 | 5034 | 89 |
1587551 | 1587551 | 2021-08-05 | Scott | Missouri | 29201 | 5015 | 89 |
1584300 | 1584300 | 2021-08-04 | Scott | Missouri | 29201 | 4998 | 89 |
1568016 | 1568016 | 2021-07-30 | Laclede | Missouri | 29105 | 4344 | 89 |
1564768 | 1564768 | 2021-07-29 | Laclede | Missouri | 29105 | 4307 | 89 |
1561520 | 1561520 | 2021-07-28 | Laclede | Missouri | 29105 | 4272 | 89 |
1558272 | 1558272 | 2021-07-27 | Laclede | Missouri | 29105 | 4248 | 89 |
1532296 | 1532296 | 2021-07-19 | Lawrence | Missouri | 29109 | 4076 | 89 |
1529049 | 1529049 | 2021-07-18 | Lawrence | Missouri | 29109 | 4058 | 89 |
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);