ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where county = "St. Helena", deaths = 18 and state = "Louisiana" 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 |
---|---|---|---|---|---|---|---|
1928260 | 1928260 | 2021-11-18 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1925010 | 1925010 | 2021-11-17 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1921761 | 1921761 | 2021-11-16 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1918511 | 1918511 | 2021-11-15 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1915261 | 1915261 | 2021-11-14 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1912011 | 1912011 | 2021-11-13 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1908762 | 1908762 | 2021-11-12 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1905513 | 1905513 | 2021-11-11 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1902263 | 1902263 | 2021-11-10 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1899013 | 1899013 | 2021-11-09 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1895763 | 1895763 | 2021-11-08 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1892513 | 1892513 | 2021-11-07 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1889263 | 1889263 | 2021-11-06 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1886013 | 1886013 | 2021-11-05 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1882764 | 1882764 | 2021-11-04 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1879515 | 1879515 | 2021-11-03 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1876266 | 1876266 | 2021-11-02 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1873017 | 1873017 | 2021-11-01 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1869768 | 1869768 | 2021-10-31 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1866519 | 1866519 | 2021-10-30 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1863270 | 1863270 | 2021-10-29 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1860021 | 1860021 | 2021-10-28 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1856772 | 1856772 | 2021-10-27 | St. Helena | Louisiana | 22091 | 1263 | 18 |
1853523 | 1853523 | 2021-10-26 | St. Helena | Louisiana | 22091 | 1262 | 18 |
1850274 | 1850274 | 2021-10-25 | St. Helena | Louisiana | 22091 | 1262 | 18 |
1847024 | 1847024 | 2021-10-24 | St. Helena | Louisiana | 22091 | 1262 | 18 |
1843774 | 1843774 | 2021-10-23 | St. Helena | Louisiana | 22091 | 1262 | 18 |
1840524 | 1840524 | 2021-10-22 | St. Helena | Louisiana | 22091 | 1262 | 18 |
1837275 | 1837275 | 2021-10-21 | St. Helena | Louisiana | 22091 | 1262 | 18 |
1834026 | 1834026 | 2021-10-20 | St. Helena | Louisiana | 22091 | 1260 | 18 |
1830777 | 1830777 | 2021-10-19 | St. Helena | Louisiana | 22091 | 1260 | 18 |
1827528 | 1827528 | 2021-10-18 | St. Helena | Louisiana | 22091 | 1259 | 18 |
1824279 | 1824279 | 2021-10-17 | St. Helena | Louisiana | 22091 | 1259 | 18 |
1821030 | 1821030 | 2021-10-16 | St. Helena | Louisiana | 22091 | 1259 | 18 |
1817781 | 1817781 | 2021-10-15 | St. Helena | Louisiana | 22091 | 1259 | 18 |
1814533 | 1814533 | 2021-10-14 | St. Helena | Louisiana | 22091 | 1259 | 18 |
1811284 | 1811284 | 2021-10-13 | St. Helena | Louisiana | 22091 | 1259 | 18 |
1808035 | 1808035 | 2021-10-12 | St. Helena | Louisiana | 22091 | 1258 | 18 |
1804784 | 1804784 | 2021-10-11 | St. Helena | Louisiana | 22091 | 1258 | 18 |
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);