ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
229 rows where deaths = 73 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501141 | 2501141 | 2022-05-13 | McDonald | Missouri | 29119 | 5813 | 73 |
2497883 | 2497883 | 2022-05-12 | McDonald | Missouri | 29119 | 5809 | 73 |
2494625 | 2494625 | 2022-05-11 | McDonald | Missouri | 29119 | 5809 | 73 |
2491367 | 2491367 | 2022-05-10 | McDonald | Missouri | 29119 | 5809 | 73 |
2488109 | 2488109 | 2022-05-09 | McDonald | Missouri | 29119 | 5809 | 73 |
2484852 | 2484852 | 2022-05-08 | McDonald | Missouri | 29119 | 5809 | 73 |
2481594 | 2481594 | 2022-05-07 | McDonald | Missouri | 29119 | 5809 | 73 |
2478336 | 2478336 | 2022-05-06 | McDonald | Missouri | 29119 | 5809 | 73 |
2475078 | 2475078 | 2022-05-05 | McDonald | Missouri | 29119 | 5806 | 73 |
2328621 | 2328621 | 2022-03-21 | Pemiscot | Missouri | 29155 | 2986 | 73 |
2325369 | 2325369 | 2022-03-20 | Pemiscot | Missouri | 29155 | 2986 | 73 |
2322115 | 2322115 | 2022-03-19 | Pemiscot | Missouri | 29155 | 2986 | 73 |
2318861 | 2318861 | 2022-03-18 | Pemiscot | Missouri | 29155 | 2986 | 73 |
2315608 | 2315608 | 2022-03-17 | Pemiscot | Missouri | 29155 | 2981 | 73 |
2312355 | 2312355 | 2022-03-16 | Pemiscot | Missouri | 29155 | 2977 | 73 |
2309102 | 2309102 | 2022-03-15 | Pemiscot | Missouri | 29155 | 2975 | 73 |
2305850 | 2305850 | 2022-03-14 | Pemiscot | Missouri | 29155 | 2975 | 73 |
2302599 | 2302599 | 2022-03-13 | Pemiscot | Missouri | 29155 | 2974 | 73 |
2299347 | 2299347 | 2022-03-12 | Pemiscot | Missouri | 29155 | 2974 | 73 |
2296095 | 2296095 | 2022-03-11 | Pemiscot | Missouri | 29155 | 2974 | 73 |
2292843 | 2292843 | 2022-03-10 | Pemiscot | Missouri | 29155 | 2973 | 73 |
2289591 | 2289591 | 2022-03-09 | Pemiscot | Missouri | 29155 | 2972 | 73 |
2286339 | 2286339 | 2022-03-08 | Pemiscot | Missouri | 29155 | 2964 | 73 |
2283087 | 2283087 | 2022-03-07 | Pemiscot | Missouri | 29155 | 2960 | 73 |
2279834 | 2279834 | 2022-03-06 | Pemiscot | Missouri | 29155 | 2960 | 73 |
2276581 | 2276581 | 2022-03-05 | Pemiscot | Missouri | 29155 | 2960 | 73 |
2273328 | 2273328 | 2022-03-04 | Pemiscot | Missouri | 29155 | 2960 | 73 |
2270076 | 2270076 | 2022-03-03 | Pemiscot | Missouri | 29155 | 2957 | 73 |
2266823 | 2266823 | 2022-03-02 | Pemiscot | Missouri | 29155 | 2957 | 73 |
2263572 | 2263572 | 2022-03-01 | Pemiscot | Missouri | 29155 | 2949 | 73 |
2260274 | 2260274 | 2022-02-28 | Dent | Missouri | 29065 | 3227 | 73 |
2257023 | 2257023 | 2022-02-27 | Dent | Missouri | 29065 | 3225 | 73 |
2253772 | 2253772 | 2022-02-26 | Dent | Missouri | 29065 | 3225 | 73 |
2250521 | 2250521 | 2022-02-25 | Dent | Missouri | 29065 | 3225 | 73 |
2247270 | 2247270 | 2022-02-24 | Dent | Missouri | 29065 | 3224 | 73 |
2244013 | 2244013 | 2022-02-23 | Cooper | Missouri | 29053 | 4123 | 73 |
2244103 | 2244103 | 2022-02-23 | Wright | Missouri | 29229 | 3792 | 73 |
2240762 | 2240762 | 2022-02-22 | Cooper | Missouri | 29053 | 4121 | 73 |
2240852 | 2240852 | 2022-02-22 | Wright | Missouri | 29229 | 3789 | 73 |
2237511 | 2237511 | 2022-02-21 | Cooper | Missouri | 29053 | 4113 | 73 |
2237601 | 2237601 | 2022-02-21 | Wright | Missouri | 29229 | 3778 | 73 |
2234260 | 2234260 | 2022-02-20 | Cooper | Missouri | 29053 | 4113 | 73 |
2234350 | 2234350 | 2022-02-20 | Wright | Missouri | 29229 | 3778 | 73 |
2231009 | 2231009 | 2022-02-19 | Cooper | Missouri | 29053 | 4113 | 73 |
2231099 | 2231099 | 2022-02-19 | Wright | Missouri | 29229 | 3778 | 73 |
2227758 | 2227758 | 2022-02-18 | Cooper | Missouri | 29053 | 4113 | 73 |
2227848 | 2227848 | 2022-02-18 | Wright | Missouri | 29229 | 3778 | 73 |
2224507 | 2224507 | 2022-02-17 | Cooper | Missouri | 29053 | 4113 | 73 |
2224597 | 2224597 | 2022-02-17 | Wright | Missouri | 29229 | 3775 | 73 |
2221256 | 2221256 | 2022-02-16 | Cooper | Missouri | 29053 | 4109 | 73 |
2221346 | 2221346 | 2022-02-16 | Wright | Missouri | 29229 | 3769 | 73 |
2218005 | 2218005 | 2022-02-15 | Cooper | Missouri | 29053 | 4107 | 73 |
2218095 | 2218095 | 2022-02-15 | Wright | Missouri | 29229 | 3759 | 73 |
2214754 | 2214754 | 2022-02-14 | Cooper | Missouri | 29053 | 4105 | 73 |
2214844 | 2214844 | 2022-02-14 | Wright | Missouri | 29229 | 3756 | 73 |
2211502 | 2211502 | 2022-02-13 | Cooper | Missouri | 29053 | 4090 | 73 |
2211592 | 2211592 | 2022-02-13 | Wright | Missouri | 29229 | 3729 | 73 |
2208249 | 2208249 | 2022-02-12 | Cooper | Missouri | 29053 | 4090 | 73 |
2208339 | 2208339 | 2022-02-12 | Wright | Missouri | 29229 | 3729 | 73 |
2204996 | 2204996 | 2022-02-11 | Cooper | Missouri | 29053 | 4090 | 73 |
2205086 | 2205086 | 2022-02-11 | Wright | Missouri | 29229 | 3729 | 73 |
2201743 | 2201743 | 2022-02-10 | Cooper | Missouri | 29053 | 4090 | 73 |
2201833 | 2201833 | 2022-02-10 | Wright | Missouri | 29229 | 3729 | 73 |
2198489 | 2198489 | 2022-02-09 | Cooper | Missouri | 29053 | 4066 | 73 |
2198579 | 2198579 | 2022-02-09 | Wright | Missouri | 29229 | 3713 | 73 |
2195235 | 2195235 | 2022-02-08 | Cooper | Missouri | 29053 | 4039 | 73 |
2195282 | 2195282 | 2022-02-08 | New Madrid | Missouri | 29143 | 4815 | 73 |
2195325 | 2195325 | 2022-02-08 | Wright | Missouri | 29229 | 3700 | 73 |
2191961 | 2191961 | 2022-02-07 | Bates | Missouri | 29013 | 3647 | 73 |
2191981 | 2191981 | 2022-02-07 | Cooper | Missouri | 29053 | 4029 | 73 |
2192028 | 2192028 | 2022-02-07 | New Madrid | Missouri | 29143 | 4805 | 73 |
2188708 | 2188708 | 2022-02-06 | Bates | Missouri | 29013 | 3641 | 73 |
2188728 | 2188728 | 2022-02-06 | Cooper | Missouri | 29053 | 4027 | 73 |
2188775 | 2188775 | 2022-02-06 | New Madrid | Missouri | 29143 | 4775 | 73 |
2185455 | 2185455 | 2022-02-05 | Bates | Missouri | 29013 | 3634 | 73 |
2185475 | 2185475 | 2022-02-05 | Cooper | Missouri | 29053 | 4022 | 73 |
2185522 | 2185522 | 2022-02-05 | New Madrid | Missouri | 29143 | 4747 | 73 |
2182203 | 2182203 | 2022-02-04 | Bates | Missouri | 29013 | 3628 | 73 |
2182270 | 2182270 | 2022-02-04 | New Madrid | Missouri | 29143 | 4730 | 73 |
2178951 | 2178951 | 2022-02-03 | Bates | Missouri | 29013 | 3611 | 73 |
2179018 | 2179018 | 2022-02-03 | New Madrid | Missouri | 29143 | 4704 | 73 |
2175699 | 2175699 | 2022-02-02 | Bates | Missouri | 29013 | 3606 | 73 |
2175766 | 2175766 | 2022-02-02 | New Madrid | Missouri | 29143 | 4649 | 73 |
2172446 | 2172446 | 2022-02-01 | Bates | Missouri | 29013 | 3578 | 73 |
2172513 | 2172513 | 2022-02-01 | New Madrid | Missouri | 29143 | 4572 | 73 |
2123724 | 2123724 | 2022-01-17 | Ray | Missouri | 29177 | 4249 | 73 |
2120472 | 2120472 | 2022-01-16 | Ray | Missouri | 29177 | 4249 | 73 |
2117220 | 2117220 | 2022-01-15 | Ray | Missouri | 29177 | 4249 | 73 |
2113969 | 2113969 | 2022-01-14 | Ray | Missouri | 29177 | 4183 | 73 |
2110717 | 2110717 | 2022-01-13 | Ray | Missouri | 29177 | 4131 | 73 |
2107466 | 2107466 | 2022-01-12 | Ray | Missouri | 29177 | 4088 | 73 |
2104215 | 2104215 | 2022-01-11 | Ray | Missouri | 29177 | 4059 | 73 |
2078221 | 2078221 | 2022-01-03 | Texas | Missouri | 29215 | 3578 | 73 |
2074970 | 2074970 | 2022-01-02 | Texas | Missouri | 29215 | 3533 | 73 |
2071719 | 2071719 | 2022-01-01 | Texas | Missouri | 29215 | 3533 | 73 |
2068468 | 2068468 | 2021-12-31 | Texas | Missouri | 29215 | 3533 | 73 |
2065217 | 2065217 | 2021-12-30 | Texas | Missouri | 29215 | 3533 | 73 |
2009927 | 2009927 | 2021-12-13 | Morgan | Missouri | 29141 | 2893 | 73 |
2006676 | 2006676 | 2021-12-12 | Morgan | Missouri | 29141 | 2882 | 73 |
2003425 | 2003425 | 2021-12-11 | Morgan | Missouri | 29141 | 2876 | 73 |
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);