ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Chesterfield" and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502011 | 2502011 | 2022-05-13 | Chesterfield | South Carolina | 45025 | 11836 | 191 |
2498753 | 2498753 | 2022-05-12 | Chesterfield | South Carolina | 45025 | 11836 | 191 |
2495495 | 2495495 | 2022-05-11 | Chesterfield | South Carolina | 45025 | 11836 | 191 |
2492237 | 2492237 | 2022-05-10 | Chesterfield | South Carolina | 45025 | 11821 | 191 |
2488979 | 2488979 | 2022-05-09 | Chesterfield | South Carolina | 45025 | 11821 | 191 |
2485722 | 2485722 | 2022-05-08 | Chesterfield | South Carolina | 45025 | 11821 | 191 |
2482464 | 2482464 | 2022-05-07 | Chesterfield | South Carolina | 45025 | 11821 | 191 |
2479206 | 2479206 | 2022-05-06 | Chesterfield | South Carolina | 45025 | 11821 | 191 |
2475948 | 2475948 | 2022-05-05 | Chesterfield | South Carolina | 45025 | 11821 | 191 |
2472691 | 2472691 | 2022-05-04 | Chesterfield | South Carolina | 45025 | 11821 | 191 |
2469435 | 2469435 | 2022-05-03 | Chesterfield | South Carolina | 45025 | 11821 | 191 |
2466179 | 2466179 | 2022-05-02 | Chesterfield | South Carolina | 45025 | 11816 | 190 |
2462924 | 2462924 | 2022-05-01 | Chesterfield | South Carolina | 45025 | 11816 | 190 |
2459668 | 2459668 | 2022-04-30 | Chesterfield | South Carolina | 45025 | 11816 | 190 |
2456412 | 2456412 | 2022-04-29 | Chesterfield | South Carolina | 45025 | 11816 | 190 |
2453156 | 2453156 | 2022-04-28 | Chesterfield | South Carolina | 45025 | 11816 | 190 |
2449900 | 2449900 | 2022-04-27 | Chesterfield | South Carolina | 45025 | 11807 | 189 |
2446643 | 2446643 | 2022-04-26 | Chesterfield | South Carolina | 45025 | 11807 | 189 |
2443388 | 2443388 | 2022-04-25 | Chesterfield | South Carolina | 45025 | 11807 | 189 |
2440132 | 2440132 | 2022-04-24 | Chesterfield | South Carolina | 45025 | 11807 | 189 |
2436876 | 2436876 | 2022-04-23 | Chesterfield | South Carolina | 45025 | 11807 | 189 |
2433620 | 2433620 | 2022-04-22 | Chesterfield | South Carolina | 45025 | 11807 | 189 |
2430364 | 2430364 | 2022-04-21 | Chesterfield | South Carolina | 45025 | 11807 | 189 |
2427108 | 2427108 | 2022-04-20 | Chesterfield | South Carolina | 45025 | 11807 | 189 |
2423852 | 2423852 | 2022-04-19 | Chesterfield | South Carolina | 45025 | 11807 | 189 |
2420596 | 2420596 | 2022-04-18 | Chesterfield | South Carolina | 45025 | 11800 | 188 |
2417340 | 2417340 | 2022-04-17 | Chesterfield | South Carolina | 45025 | 11800 | 188 |
2414084 | 2414084 | 2022-04-16 | Chesterfield | South Carolina | 45025 | 11800 | 188 |
2410828 | 2410828 | 2022-04-15 | Chesterfield | South Carolina | 45025 | 11800 | 188 |
2407572 | 2407572 | 2022-04-14 | Chesterfield | South Carolina | 45025 | 11800 | 188 |
2404316 | 2404316 | 2022-04-13 | Chesterfield | South Carolina | 45025 | 11800 | 188 |
2401061 | 2401061 | 2022-04-12 | Chesterfield | South Carolina | 45025 | 11800 | 188 |
2397806 | 2397806 | 2022-04-11 | Chesterfield | South Carolina | 45025 | 11795 | 188 |
2394551 | 2394551 | 2022-04-10 | Chesterfield | South Carolina | 45025 | 11795 | 188 |
2391295 | 2391295 | 2022-04-09 | Chesterfield | South Carolina | 45025 | 11795 | 188 |
2388039 | 2388039 | 2022-04-08 | Chesterfield | South Carolina | 45025 | 11795 | 188 |
2384784 | 2384784 | 2022-04-07 | Chesterfield | South Carolina | 45025 | 11795 | 188 |
2381529 | 2381529 | 2022-04-06 | Chesterfield | South Carolina | 45025 | 11795 | 188 |
2378274 | 2378274 | 2022-04-05 | Chesterfield | South Carolina | 45025 | 11795 | 188 |
2375020 | 2375020 | 2022-04-04 | Chesterfield | South Carolina | 45025 | 11787 | 188 |
2371768 | 2371768 | 2022-04-03 | Chesterfield | South Carolina | 45025 | 11787 | 188 |
2368515 | 2368515 | 2022-04-02 | Chesterfield | South Carolina | 45025 | 11787 | 188 |
2365262 | 2365262 | 2022-04-01 | Chesterfield | South Carolina | 45025 | 11787 | 188 |
2362009 | 2362009 | 2022-03-31 | Chesterfield | South Carolina | 45025 | 11787 | 188 |
2358755 | 2358755 | 2022-03-30 | Chesterfield | South Carolina | 45025 | 11787 | 188 |
2355501 | 2355501 | 2022-03-29 | Chesterfield | South Carolina | 45025 | 11787 | 188 |
2352248 | 2352248 | 2022-03-28 | Chesterfield | South Carolina | 45025 | 11785 | 187 |
2348996 | 2348996 | 2022-03-27 | Chesterfield | South Carolina | 45025 | 11785 | 187 |
2345743 | 2345743 | 2022-03-26 | Chesterfield | South Carolina | 45025 | 11785 | 187 |
2342490 | 2342490 | 2022-03-25 | Chesterfield | South Carolina | 45025 | 11785 | 187 |
2339237 | 2339237 | 2022-03-24 | Chesterfield | South Carolina | 45025 | 11785 | 187 |
2335983 | 2335983 | 2022-03-23 | Chesterfield | South Carolina | 45025 | 11785 | 187 |
2332729 | 2332729 | 2022-03-22 | Chesterfield | South Carolina | 45025 | 11785 | 187 |
2329476 | 2329476 | 2022-03-21 | Chesterfield | South Carolina | 45025 | 11767 | 186 |
2326224 | 2326224 | 2022-03-20 | Chesterfield | South Carolina | 45025 | 11767 | 186 |
2322971 | 2322971 | 2022-03-19 | Chesterfield | South Carolina | 45025 | 11767 | 186 |
2319717 | 2319717 | 2022-03-18 | Chesterfield | South Carolina | 45025 | 11767 | 186 |
2316463 | 2316463 | 2022-03-17 | Chesterfield | South Carolina | 45025 | 11767 | 186 |
2313210 | 2313210 | 2022-03-16 | Chesterfield | South Carolina | 45025 | 11767 | 186 |
2309957 | 2309957 | 2022-03-15 | Chesterfield | South Carolina | 45025 | 11767 | 186 |
2306704 | 2306704 | 2022-03-14 | Chesterfield | South Carolina | 45025 | 11751 | 186 |
2303453 | 2303453 | 2022-03-13 | Chesterfield | South Carolina | 45025 | 11751 | 186 |
2300201 | 2300201 | 2022-03-12 | Chesterfield | South Carolina | 45025 | 11751 | 186 |
2296949 | 2296949 | 2022-03-11 | Chesterfield | South Carolina | 45025 | 11751 | 186 |
2293697 | 2293697 | 2022-03-10 | Chesterfield | South Carolina | 45025 | 11750 | 185 |
2290445 | 2290445 | 2022-03-09 | Chesterfield | South Carolina | 45025 | 11736 | 184 |
2287193 | 2287193 | 2022-03-08 | Chesterfield | South Carolina | 45025 | 11732 | 184 |
2283941 | 2283941 | 2022-03-07 | Chesterfield | South Carolina | 45025 | 11728 | 184 |
2280689 | 2280689 | 2022-03-06 | Chesterfield | South Carolina | 45025 | 11720 | 183 |
2277436 | 2277436 | 2022-03-05 | Chesterfield | South Carolina | 45025 | 11720 | 183 |
2274183 | 2274183 | 2022-03-04 | Chesterfield | South Carolina | 45025 | 11720 | 183 |
2270930 | 2270930 | 2022-03-03 | Chesterfield | South Carolina | 45025 | 11718 | 183 |
2267678 | 2267678 | 2022-03-02 | Chesterfield | South Carolina | 45025 | 11712 | 182 |
2264425 | 2264425 | 2022-03-01 | Chesterfield | South Carolina | 45025 | 11712 | 182 |
2261175 | 2261175 | 2022-02-28 | Chesterfield | South Carolina | 45025 | 11711 | 181 |
2257924 | 2257924 | 2022-02-27 | Chesterfield | South Carolina | 45025 | 11698 | 181 |
2254673 | 2254673 | 2022-02-26 | Chesterfield | South Carolina | 45025 | 11698 | 181 |
2251422 | 2251422 | 2022-02-25 | Chesterfield | South Carolina | 45025 | 11698 | 181 |
2248171 | 2248171 | 2022-02-24 | Chesterfield | South Carolina | 45025 | 11697 | 181 |
2244920 | 2244920 | 2022-02-23 | Chesterfield | South Carolina | 45025 | 11687 | 179 |
2241669 | 2241669 | 2022-02-22 | Chesterfield | South Carolina | 45025 | 11671 | 178 |
2238418 | 2238418 | 2022-02-21 | Chesterfield | South Carolina | 45025 | 11631 | 177 |
2235167 | 2235167 | 2022-02-20 | Chesterfield | South Carolina | 45025 | 11631 | 177 |
2231916 | 2231916 | 2022-02-19 | Chesterfield | South Carolina | 45025 | 11631 | 177 |
2228665 | 2228665 | 2022-02-18 | Chesterfield | South Carolina | 45025 | 11631 | 177 |
2225414 | 2225414 | 2022-02-17 | Chesterfield | South Carolina | 45025 | 11606 | 177 |
2222163 | 2222163 | 2022-02-16 | Chesterfield | South Carolina | 45025 | 11566 | 176 |
2218912 | 2218912 | 2022-02-15 | Chesterfield | South Carolina | 45025 | 11547 | 176 |
2215661 | 2215661 | 2022-02-14 | Chesterfield | South Carolina | 45025 | 11530 | 176 |
2212410 | 2212410 | 2022-02-13 | Chesterfield | South Carolina | 45025 | 11404 | 173 |
2209157 | 2209157 | 2022-02-12 | Chesterfield | South Carolina | 45025 | 11404 | 173 |
2205904 | 2205904 | 2022-02-11 | Chesterfield | South Carolina | 45025 | 11404 | 173 |
2202651 | 2202651 | 2022-02-10 | Chesterfield | South Carolina | 45025 | 11404 | 173 |
2199397 | 2199397 | 2022-02-09 | Chesterfield | South Carolina | 45025 | 11359 | 173 |
2196143 | 2196143 | 2022-02-08 | Chesterfield | South Carolina | 45025 | 11322 | 172 |
2192889 | 2192889 | 2022-02-07 | Chesterfield | South Carolina | 45025 | 11308 | 172 |
2189635 | 2189635 | 2022-02-06 | Chesterfield | South Carolina | 45025 | 11197 | 171 |
2186382 | 2186382 | 2022-02-05 | Chesterfield | South Carolina | 45025 | 11197 | 171 |
2183130 | 2183130 | 2022-02-04 | Chesterfield | South Carolina | 45025 | 11197 | 171 |
2179878 | 2179878 | 2022-02-03 | Chesterfield | South Carolina | 45025 | 11113 | 170 |
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);