ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where deaths = 33, fips = 29157 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 |
---|---|---|---|---|---|---|---|
1925421 | 1925421 | 2021-11-17 | Perry | Missouri | 29157 | 3314 | 33 |
1922172 | 1922172 | 2021-11-16 | Perry | Missouri | 29157 | 3304 | 33 |
1918922 | 1918922 | 2021-11-15 | Perry | Missouri | 29157 | 3303 | 33 |
1915672 | 1915672 | 2021-11-14 | Perry | Missouri | 29157 | 3301 | 33 |
1912422 | 1912422 | 2021-11-13 | Perry | Missouri | 29157 | 3296 | 33 |
1909172 | 1909172 | 2021-11-12 | Perry | Missouri | 29157 | 3282 | 33 |
1905923 | 1905923 | 2021-11-11 | Perry | Missouri | 29157 | 3256 | 33 |
1902674 | 1902674 | 2021-11-10 | Perry | Missouri | 29157 | 3256 | 33 |
1899424 | 1899424 | 2021-11-09 | Perry | Missouri | 29157 | 3248 | 33 |
1896174 | 1896174 | 2021-11-08 | Perry | Missouri | 29157 | 3237 | 33 |
1892924 | 1892924 | 2021-11-07 | Perry | Missouri | 29157 | 3235 | 33 |
1889674 | 1889674 | 2021-11-06 | Perry | Missouri | 29157 | 3233 | 33 |
1886424 | 1886424 | 2021-11-05 | Perry | Missouri | 29157 | 3223 | 33 |
1883175 | 1883175 | 2021-11-04 | Perry | Missouri | 29157 | 3212 | 33 |
1879926 | 1879926 | 2021-11-03 | Perry | Missouri | 29157 | 3204 | 33 |
1876677 | 1876677 | 2021-11-02 | Perry | Missouri | 29157 | 3188 | 33 |
1873428 | 1873428 | 2021-11-01 | Perry | Missouri | 29157 | 3176 | 33 |
1870179 | 1870179 | 2021-10-31 | Perry | Missouri | 29157 | 3174 | 33 |
1866930 | 1866930 | 2021-10-30 | Perry | Missouri | 29157 | 3173 | 33 |
1863681 | 1863681 | 2021-10-29 | Perry | Missouri | 29157 | 3165 | 33 |
1860432 | 1860432 | 2021-10-28 | Perry | Missouri | 29157 | 3149 | 33 |
1857183 | 1857183 | 2021-10-27 | Perry | Missouri | 29157 | 3140 | 33 |
1853934 | 1853934 | 2021-10-26 | Perry | Missouri | 29157 | 3128 | 33 |
1850685 | 1850685 | 2021-10-25 | Perry | Missouri | 29157 | 3110 | 33 |
1847435 | 1847435 | 2021-10-24 | Perry | Missouri | 29157 | 3105 | 33 |
1844185 | 1844185 | 2021-10-23 | Perry | Missouri | 29157 | 3105 | 33 |
1840935 | 1840935 | 2021-10-22 | Perry | Missouri | 29157 | 3099 | 33 |
1837686 | 1837686 | 2021-10-21 | Perry | Missouri | 29157 | 3092 | 33 |
1834437 | 1834437 | 2021-10-20 | Perry | Missouri | 29157 | 3082 | 33 |
1831188 | 1831188 | 2021-10-19 | Perry | Missouri | 29157 | 3071 | 33 |
1827939 | 1827939 | 2021-10-18 | Perry | Missouri | 29157 | 3063 | 33 |
1824690 | 1824690 | 2021-10-17 | Perry | Missouri | 29157 | 3062 | 33 |
1821441 | 1821441 | 2021-10-16 | Perry | Missouri | 29157 | 3059 | 33 |
1818192 | 1818192 | 2021-10-15 | Perry | Missouri | 29157 | 3052 | 33 |
1814943 | 1814943 | 2021-10-14 | Perry | Missouri | 29157 | 3044 | 33 |
1811695 | 1811695 | 2021-10-13 | Perry | Missouri | 29157 | 3036 | 33 |
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);