ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17 rows where county = "Orange", deaths = 10 and fips = 50017 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 |
---|---|---|---|---|---|---|---|
2170610 | 2170610 | 2022-01-31 | Orange | Vermont | 50017 | 3034 | 10 |
2167356 | 2167356 | 2022-01-30 | Orange | Vermont | 50017 | 3034 | 10 |
2164101 | 2164101 | 2022-01-29 | Orange | Vermont | 50017 | 3023 | 10 |
2160846 | 2160846 | 2022-01-28 | Orange | Vermont | 50017 | 3009 | 10 |
2157590 | 2157590 | 2022-01-27 | Orange | Vermont | 50017 | 2989 | 10 |
2154337 | 2154337 | 2022-01-26 | Orange | Vermont | 50017 | 2965 | 10 |
2151085 | 2151085 | 2022-01-25 | Orange | Vermont | 50017 | 2920 | 10 |
2147833 | 2147833 | 2022-01-24 | Orange | Vermont | 50017 | 2873 | 10 |
2144579 | 2144579 | 2022-01-23 | Orange | Vermont | 50017 | 2833 | 10 |
2141324 | 2141324 | 2022-01-22 | Orange | Vermont | 50017 | 2772 | 10 |
2138068 | 2138068 | 2022-01-21 | Orange | Vermont | 50017 | 2727 | 10 |
2134814 | 2134814 | 2022-01-20 | Orange | Vermont | 50017 | 2678 | 10 |
2131562 | 2131562 | 2022-01-19 | Orange | Vermont | 50017 | 2678 | 10 |
2128308 | 2128308 | 2022-01-18 | Orange | Vermont | 50017 | 2640 | 10 |
2125056 | 2125056 | 2022-01-17 | Orange | Vermont | 50017 | 2591 | 10 |
2121804 | 2121804 | 2022-01-16 | Orange | Vermont | 50017 | 2591 | 10 |
2118552 | 2118552 | 2022-01-15 | Orange | Vermont | 50017 | 2557 | 10 |
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);