ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where county = "Charleston", deaths = 1 and fips = 45019 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 |
---|---|---|---|---|---|---|---|
50415 | 50415 | 2020-04-11 | Charleston | South Carolina | 45019 | 331 | 1 |
47758 | 47758 | 2020-04-10 | Charleston | South Carolina | 45019 | 328 | 1 |
45141 | 45141 | 2020-04-09 | Charleston | South Carolina | 45019 | 313 | 1 |
42555 | 42555 | 2020-04-08 | Charleston | South Carolina | 45019 | 308 | 1 |
39995 | 39995 | 2020-04-07 | Charleston | South Carolina | 45019 | 305 | 1 |
37472 | 37472 | 2020-04-06 | Charleston | South Carolina | 45019 | 300 | 1 |
34997 | 34997 | 2020-04-05 | Charleston | South Carolina | 45019 | 274 | 1 |
32561 | 32561 | 2020-04-04 | Charleston | South Carolina | 45019 | 274 | 1 |
30170 | 30170 | 2020-04-03 | Charleston | South Carolina | 45019 | 247 | 1 |
27835 | 27835 | 2020-04-02 | Charleston | South Carolina | 45019 | 231 | 1 |
25562 | 25562 | 2020-04-01 | Charleston | South Carolina | 45019 | 190 | 1 |
23364 | 23364 | 2020-03-31 | Charleston | South Carolina | 45019 | 142 | 1 |
21226 | 21226 | 2020-03-30 | Charleston | South Carolina | 45019 | 123 | 1 |
19174 | 19174 | 2020-03-29 | Charleston | South Carolina | 45019 | 116 | 1 |
17234 | 17234 | 2020-03-28 | Charleston | South Carolina | 45019 | 108 | 1 |
15380 | 15380 | 2020-03-27 | Charleston | South Carolina | 45019 | 92 | 1 |
13633 | 13633 | 2020-03-26 | Charleston | South Carolina | 45019 | 60 | 1 |
12011 | 12011 | 2020-03-25 | Charleston | South Carolina | 45019 | 52 | 1 |
10540 | 10540 | 2020-03-24 | Charleston | South Carolina | 45019 | 36 | 1 |
9215 | 9215 | 2020-03-23 | Charleston | South Carolina | 45019 | 31 | 1 |
8004 | 8004 | 2020-03-22 | Charleston | South Carolina | 45019 | 13 | 1 |
6884 | 6884 | 2020-03-21 | Charleston | South Carolina | 45019 | 9 | 1 |
5880 | 5880 | 2020-03-20 | Charleston | South Carolina | 45019 | 6 | 1 |
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);