ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
27 rows where deaths = 64, fips = 28131 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1873331 | 1873331 | 2021-11-01 | Stone | Mississippi | 28131 | 3620 | 64 |
1870082 | 1870082 | 2021-10-31 | Stone | Mississippi | 28131 | 3618 | 64 |
1866833 | 1866833 | 2021-10-30 | Stone | Mississippi | 28131 | 3618 | 64 |
1863584 | 1863584 | 2021-10-29 | Stone | Mississippi | 28131 | 3618 | 64 |
1860335 | 1860335 | 2021-10-28 | Stone | Mississippi | 28131 | 3609 | 64 |
1857086 | 1857086 | 2021-10-27 | Stone | Mississippi | 28131 | 3607 | 64 |
1853837 | 1853837 | 2021-10-26 | Stone | Mississippi | 28131 | 3606 | 64 |
1850588 | 1850588 | 2021-10-25 | Stone | Mississippi | 28131 | 3606 | 64 |
1847338 | 1847338 | 2021-10-24 | Stone | Mississippi | 28131 | 3603 | 64 |
1844088 | 1844088 | 2021-10-23 | Stone | Mississippi | 28131 | 3603 | 64 |
1840838 | 1840838 | 2021-10-22 | Stone | Mississippi | 28131 | 3603 | 64 |
1837589 | 1837589 | 2021-10-21 | Stone | Mississippi | 28131 | 3597 | 64 |
1834340 | 1834340 | 2021-10-20 | Stone | Mississippi | 28131 | 3597 | 64 |
1831091 | 1831091 | 2021-10-19 | Stone | Mississippi | 28131 | 3593 | 64 |
1827842 | 1827842 | 2021-10-18 | Stone | Mississippi | 28131 | 3587 | 64 |
1824593 | 1824593 | 2021-10-17 | Stone | Mississippi | 28131 | 3584 | 64 |
1821344 | 1821344 | 2021-10-16 | Stone | Mississippi | 28131 | 3584 | 64 |
1818095 | 1818095 | 2021-10-15 | Stone | Mississippi | 28131 | 3584 | 64 |
1814846 | 1814846 | 2021-10-14 | Stone | Mississippi | 28131 | 3582 | 64 |
1811598 | 1811598 | 2021-10-13 | Stone | Mississippi | 28131 | 3578 | 64 |
1808349 | 1808349 | 2021-10-12 | Stone | Mississippi | 28131 | 3571 | 64 |
1805098 | 1805098 | 2021-10-11 | Stone | Mississippi | 28131 | 3571 | 64 |
1801849 | 1801849 | 2021-10-10 | Stone | Mississippi | 28131 | 3564 | 64 |
1798600 | 1798600 | 2021-10-09 | Stone | Mississippi | 28131 | 3564 | 64 |
1795351 | 1795351 | 2021-10-08 | Stone | Mississippi | 28131 | 3564 | 64 |
1792102 | 1792102 | 2021-10-07 | Stone | Mississippi | 28131 | 3560 | 64 |
1788853 | 1788853 | 2021-10-06 | Stone | Mississippi | 28131 | 3553 | 64 |
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);