ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where deaths = 12, fips = 30107 and state = "Montana" 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 |
---|---|---|---|---|---|---|---|
1870269 | 1870269 | 2021-10-31 | Wheatland | Montana | 30107 | 260 | 12 |
1867020 | 1867020 | 2021-10-30 | Wheatland | Montana | 30107 | 260 | 12 |
1863771 | 1863771 | 2021-10-29 | Wheatland | Montana | 30107 | 260 | 12 |
1860522 | 1860522 | 2021-10-28 | Wheatland | Montana | 30107 | 260 | 12 |
1857273 | 1857273 | 2021-10-27 | Wheatland | Montana | 30107 | 259 | 12 |
1854024 | 1854024 | 2021-10-26 | Wheatland | Montana | 30107 | 259 | 12 |
1850775 | 1850775 | 2021-10-25 | Wheatland | Montana | 30107 | 258 | 12 |
1847525 | 1847525 | 2021-10-24 | Wheatland | Montana | 30107 | 256 | 12 |
1844275 | 1844275 | 2021-10-23 | Wheatland | Montana | 30107 | 256 | 12 |
1841025 | 1841025 | 2021-10-22 | Wheatland | Montana | 30107 | 256 | 12 |
1837776 | 1837776 | 2021-10-21 | Wheatland | Montana | 30107 | 253 | 12 |
1834527 | 1834527 | 2021-10-20 | Wheatland | Montana | 30107 | 251 | 12 |
1831278 | 1831278 | 2021-10-19 | Wheatland | Montana | 30107 | 251 | 12 |
1828029 | 1828029 | 2021-10-18 | Wheatland | Montana | 30107 | 250 | 12 |
1824780 | 1824780 | 2021-10-17 | Wheatland | Montana | 30107 | 249 | 12 |
1821531 | 1821531 | 2021-10-16 | Wheatland | Montana | 30107 | 249 | 12 |
1818282 | 1818282 | 2021-10-15 | Wheatland | Montana | 30107 | 249 | 12 |
1815033 | 1815033 | 2021-10-14 | Wheatland | Montana | 30107 | 248 | 12 |
1811785 | 1811785 | 2021-10-13 | Wheatland | Montana | 30107 | 248 | 12 |
1808536 | 1808536 | 2021-10-12 | Wheatland | Montana | 30107 | 248 | 12 |
1805285 | 1805285 | 2021-10-11 | Wheatland | Montana | 30107 | 246 | 12 |
1802036 | 1802036 | 2021-10-10 | Wheatland | Montana | 30107 | 246 | 12 |
1798787 | 1798787 | 2021-10-09 | Wheatland | Montana | 30107 | 246 | 12 |
1795538 | 1795538 | 2021-10-08 | Wheatland | Montana | 30107 | 246 | 12 |
1792289 | 1792289 | 2021-10-07 | Wheatland | Montana | 30107 | 246 | 12 |
1789040 | 1789040 | 2021-10-06 | Wheatland | Montana | 30107 | 246 | 12 |
1785792 | 1785792 | 2021-10-05 | Wheatland | Montana | 30107 | 245 | 12 |
1782543 | 1782543 | 2021-10-04 | Wheatland | Montana | 30107 | 243 | 12 |
1779293 | 1779293 | 2021-10-03 | Wheatland | Montana | 30107 | 243 | 12 |
1776043 | 1776043 | 2021-10-02 | Wheatland | Montana | 30107 | 243 | 12 |
1772793 | 1772793 | 2021-10-01 | Wheatland | Montana | 30107 | 243 | 12 |
1769544 | 1769544 | 2021-09-30 | Wheatland | Montana | 30107 | 243 | 12 |
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);