ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where deaths = 154, fips = 45071 and state = "South Carolina" 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 |
---|---|---|---|---|---|---|---|
2157124 | 2157124 | 2022-01-27 | Newberry | South Carolina | 45071 | 12058 | 154 |
2153871 | 2153871 | 2022-01-26 | Newberry | South Carolina | 45071 | 11945 | 154 |
2150619 | 2150619 | 2022-01-25 | Newberry | South Carolina | 45071 | 11424 | 154 |
2147367 | 2147367 | 2022-01-24 | Newberry | South Carolina | 45071 | 11424 | 154 |
2144113 | 2144113 | 2022-01-23 | Newberry | South Carolina | 45071 | 11424 | 154 |
2140858 | 2140858 | 2022-01-22 | Newberry | South Carolina | 45071 | 11424 | 154 |
2137602 | 2137602 | 2022-01-21 | Newberry | South Carolina | 45071 | 11424 | 154 |
2134348 | 2134348 | 2022-01-20 | Newberry | South Carolina | 45071 | 11250 | 154 |
2131096 | 2131096 | 2022-01-19 | Newberry | South Carolina | 45071 | 11048 | 154 |
2127842 | 2127842 | 2022-01-18 | Newberry | South Carolina | 45071 | 10962 | 154 |
2124590 | 2124590 | 2022-01-17 | Newberry | South Carolina | 45071 | 10099 | 154 |
2121338 | 2121338 | 2022-01-16 | Newberry | South Carolina | 45071 | 10099 | 154 |
2118086 | 2118086 | 2022-01-15 | Newberry | South Carolina | 45071 | 10099 | 154 |
2114835 | 2114835 | 2022-01-14 | Newberry | South Carolina | 45071 | 10099 | 154 |
2111583 | 2111583 | 2022-01-13 | Newberry | South Carolina | 45071 | 9851 | 154 |
2108331 | 2108331 | 2022-01-12 | Newberry | South Carolina | 45071 | 9291 | 154 |
2105080 | 2105080 | 2022-01-11 | Newberry | South Carolina | 45071 | 9216 | 154 |
2101829 | 2101829 | 2022-01-10 | Newberry | South Carolina | 45071 | 9152 | 154 |
2098578 | 2098578 | 2022-01-09 | Newberry | South Carolina | 45071 | 8828 | 154 |
2095326 | 2095326 | 2022-01-08 | Newberry | South Carolina | 45071 | 8828 | 154 |
2092074 | 2092074 | 2022-01-07 | Newberry | South Carolina | 45071 | 8828 | 154 |
2088822 | 2088822 | 2022-01-06 | Newberry | South Carolina | 45071 | 8748 | 154 |
2085571 | 2085571 | 2022-01-05 | Newberry | South Carolina | 45071 | 8553 | 154 |
2082319 | 2082319 | 2022-01-04 | Newberry | South Carolina | 45071 | 8454 | 154 |
2059563 | 2059563 | 2021-12-28 | Newberry | South Carolina | 45071 | 7926 | 154 |
2056314 | 2056314 | 2021-12-27 | Newberry | South Carolina | 45071 | 7926 | 154 |
2053065 | 2053065 | 2021-12-26 | Newberry | South Carolina | 45071 | 7926 | 154 |
2049815 | 2049815 | 2021-12-25 | Newberry | South Carolina | 45071 | 7926 | 154 |
2046565 | 2046565 | 2021-12-24 | Newberry | South Carolina | 45071 | 7926 | 154 |
2043315 | 2043315 | 2021-12-23 | Newberry | South Carolina | 45071 | 7926 | 154 |
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);