ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
117 rows where deaths = 144 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 21
county 21
- Chesterfield 29
- Williamsburg 22
- Dillon 11
- Kershaw 9
- Georgetown 7
- Newberry 7
- Union 7
- Cherokee 5
- Colleton 4
- Greenwood 3
- Dorchester 2
- Lancaster 2
- Aiken 1
- Anderson 1
- Beaufort 1
- Berkeley 1
- Charleston 1
- Darlington 1
- Lexington 1
- Marion 1
- Orangeburg 1
state 1
- South Carolina · 117 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502015 | 2502015 | 2022-05-13 | Dillon | South Carolina | 45033 | 9729 | 144 |
2498757 | 2498757 | 2022-05-12 | Dillon | South Carolina | 45033 | 9729 | 144 |
2495499 | 2495499 | 2022-05-11 | Dillon | South Carolina | 45033 | 9729 | 144 |
2492241 | 2492241 | 2022-05-10 | Dillon | South Carolina | 45033 | 9720 | 144 |
2488983 | 2488983 | 2022-05-09 | Dillon | South Carolina | 45033 | 9720 | 144 |
2485726 | 2485726 | 2022-05-08 | Dillon | South Carolina | 45033 | 9720 | 144 |
2482468 | 2482468 | 2022-05-07 | Dillon | South Carolina | 45033 | 9720 | 144 |
2479210 | 2479210 | 2022-05-06 | Dillon | South Carolina | 45033 | 9720 | 144 |
2475952 | 2475952 | 2022-05-05 | Dillon | South Carolina | 45033 | 9720 | 144 |
2472695 | 2472695 | 2022-05-04 | Dillon | South Carolina | 45033 | 9720 | 144 |
2469439 | 2469439 | 2022-05-03 | Dillon | South Carolina | 45033 | 9720 | 144 |
2352280 | 2352280 | 2022-03-28 | Williamsburg | South Carolina | 45089 | 8524 | 144 |
2349028 | 2349028 | 2022-03-27 | Williamsburg | South Carolina | 45089 | 8524 | 144 |
2345775 | 2345775 | 2022-03-26 | Williamsburg | South Carolina | 45089 | 8524 | 144 |
2342522 | 2342522 | 2022-03-25 | Williamsburg | South Carolina | 45089 | 8524 | 144 |
2339269 | 2339269 | 2022-03-24 | Williamsburg | South Carolina | 45089 | 8524 | 144 |
2336015 | 2336015 | 2022-03-23 | Williamsburg | South Carolina | 45089 | 8524 | 144 |
2332761 | 2332761 | 2022-03-22 | Williamsburg | South Carolina | 45089 | 8524 | 144 |
2329508 | 2329508 | 2022-03-21 | Williamsburg | South Carolina | 45089 | 8523 | 144 |
2326256 | 2326256 | 2022-03-20 | Williamsburg | South Carolina | 45089 | 8523 | 144 |
2323003 | 2323003 | 2022-03-19 | Williamsburg | South Carolina | 45089 | 8523 | 144 |
2319749 | 2319749 | 2022-03-18 | Williamsburg | South Carolina | 45089 | 8523 | 144 |
2316495 | 2316495 | 2022-03-17 | Williamsburg | South Carolina | 45089 | 8523 | 144 |
2313242 | 2313242 | 2022-03-16 | Williamsburg | South Carolina | 45089 | 8523 | 144 |
2309989 | 2309989 | 2022-03-15 | Williamsburg | South Carolina | 45089 | 8523 | 144 |
2306736 | 2306736 | 2022-03-14 | Williamsburg | South Carolina | 45089 | 8520 | 144 |
2303485 | 2303485 | 2022-03-13 | Williamsburg | South Carolina | 45089 | 8520 | 144 |
2300233 | 2300233 | 2022-03-12 | Williamsburg | South Carolina | 45089 | 8520 | 144 |
2296981 | 2296981 | 2022-03-11 | Williamsburg | South Carolina | 45089 | 8520 | 144 |
2293729 | 2293729 | 2022-03-10 | Williamsburg | South Carolina | 45089 | 8519 | 144 |
2290477 | 2290477 | 2022-03-09 | Williamsburg | South Carolina | 45089 | 8517 | 144 |
2287225 | 2287225 | 2022-03-08 | Williamsburg | South Carolina | 45089 | 8514 | 144 |
2283973 | 2283973 | 2022-03-07 | Williamsburg | South Carolina | 45089 | 8514 | 144 |
2280720 | 2280720 | 2022-03-06 | Union | South Carolina | 45087 | 7619 | 144 |
2277467 | 2277467 | 2022-03-05 | Union | South Carolina | 45087 | 7619 | 144 |
2274214 | 2274214 | 2022-03-04 | Union | South Carolina | 45087 | 7619 | 144 |
2270961 | 2270961 | 2022-03-03 | Union | South Carolina | 45087 | 7619 | 144 |
2267709 | 2267709 | 2022-03-02 | Union | South Carolina | 45087 | 7613 | 144 |
2264456 | 2264456 | 2022-03-01 | Union | South Carolina | 45087 | 7612 | 144 |
2261206 | 2261206 | 2022-02-28 | Union | South Carolina | 45087 | 7612 | 144 |
2101826 | 2101826 | 2022-01-10 | Marion | South Carolina | 45067 | 6430 | 144 |
1919774 | 1919774 | 2021-11-15 | Chesterfield | South Carolina | 45025 | 7423 | 144 |
1916524 | 1916524 | 2021-11-14 | Chesterfield | South Carolina | 45025 | 7406 | 144 |
1913274 | 1913274 | 2021-11-13 | Chesterfield | South Carolina | 45025 | 7406 | 144 |
1910024 | 1910024 | 2021-11-12 | Chesterfield | South Carolina | 45025 | 7406 | 144 |
1906775 | 1906775 | 2021-11-11 | Chesterfield | South Carolina | 45025 | 7388 | 144 |
1903526 | 1903526 | 2021-11-10 | Chesterfield | South Carolina | 45025 | 7388 | 144 |
1900276 | 1900276 | 2021-11-09 | Chesterfield | South Carolina | 45025 | 7380 | 144 |
1897026 | 1897026 | 2021-11-08 | Chesterfield | South Carolina | 45025 | 7375 | 144 |
1893776 | 1893776 | 2021-11-07 | Chesterfield | South Carolina | 45025 | 7353 | 144 |
1890526 | 1890526 | 2021-11-06 | Chesterfield | South Carolina | 45025 | 7353 | 144 |
1887276 | 1887276 | 2021-11-05 | Chesterfield | South Carolina | 45025 | 7353 | 144 |
1884026 | 1884026 | 2021-11-04 | Chesterfield | South Carolina | 45025 | 7328 | 144 |
1880777 | 1880777 | 2021-11-03 | Chesterfield | South Carolina | 45025 | 7299 | 144 |
1877528 | 1877528 | 2021-11-02 | Chesterfield | South Carolina | 45025 | 7297 | 144 |
1874279 | 1874279 | 2021-11-01 | Chesterfield | South Carolina | 45025 | 7288 | 144 |
1871030 | 1871030 | 2021-10-31 | Chesterfield | South Carolina | 45025 | 7256 | 144 |
1867781 | 1867781 | 2021-10-30 | Chesterfield | South Carolina | 45025 | 7256 | 144 |
1864532 | 1864532 | 2021-10-29 | Chesterfield | South Carolina | 45025 | 7256 | 144 |
1861283 | 1861283 | 2021-10-28 | Chesterfield | South Carolina | 45025 | 7242 | 144 |
1858034 | 1858034 | 2021-10-27 | Chesterfield | South Carolina | 45025 | 7228 | 144 |
1854785 | 1854785 | 2021-10-26 | Chesterfield | South Carolina | 45025 | 7217 | 144 |
1851536 | 1851536 | 2021-10-25 | Chesterfield | South Carolina | 45025 | 7210 | 144 |
1848286 | 1848286 | 2021-10-24 | Chesterfield | South Carolina | 45025 | 7186 | 144 |
1848309 | 1848309 | 2021-10-24 | Newberry | South Carolina | 45071 | 7454 | 144 |
1845036 | 1845036 | 2021-10-23 | Chesterfield | South Carolina | 45025 | 7186 | 144 |
1845059 | 1845059 | 2021-10-23 | Newberry | South Carolina | 45071 | 7454 | 144 |
1841786 | 1841786 | 2021-10-22 | Chesterfield | South Carolina | 45025 | 7186 | 144 |
1841809 | 1841809 | 2021-10-22 | Newberry | South Carolina | 45071 | 7454 | 144 |
1838537 | 1838537 | 2021-10-21 | Chesterfield | South Carolina | 45025 | 7174 | 144 |
1838560 | 1838560 | 2021-10-21 | Newberry | South Carolina | 45071 | 7445 | 144 |
1835288 | 1835288 | 2021-10-20 | Chesterfield | South Carolina | 45025 | 7163 | 144 |
1835311 | 1835311 | 2021-10-20 | Newberry | South Carolina | 45071 | 7430 | 144 |
1832039 | 1832039 | 2021-10-19 | Chesterfield | South Carolina | 45025 | 7155 | 144 |
1832062 | 1832062 | 2021-10-19 | Newberry | South Carolina | 45071 | 7426 | 144 |
1828790 | 1828790 | 2021-10-18 | Chesterfield | South Carolina | 45025 | 7150 | 144 |
1828813 | 1828813 | 2021-10-18 | Newberry | South Carolina | 45071 | 7419 | 144 |
1666350 | 1666350 | 2021-08-29 | Colleton | South Carolina | 45029 | 4642 | 144 |
1663102 | 1663102 | 2021-08-28 | Colleton | South Carolina | 45029 | 4642 | 144 |
1659854 | 1659854 | 2021-08-27 | Colleton | South Carolina | 45029 | 4642 | 144 |
1656605 | 1656605 | 2021-08-26 | Colleton | South Carolina | 45029 | 4576 | 144 |
1604646 | 1604646 | 2021-08-10 | Kershaw | South Carolina | 45055 | 8480 | 144 |
1601397 | 1601397 | 2021-08-09 | Kershaw | South Carolina | 45055 | 8441 | 144 |
1598143 | 1598143 | 2021-08-08 | Georgetown | South Carolina | 45043 | 7197 | 144 |
1598149 | 1598149 | 2021-08-08 | Kershaw | South Carolina | 45055 | 8235 | 144 |
1594894 | 1594894 | 2021-08-07 | Georgetown | South Carolina | 45043 | 7197 | 144 |
1594900 | 1594900 | 2021-08-07 | Kershaw | South Carolina | 45055 | 8235 | 144 |
1591645 | 1591645 | 2021-08-06 | Georgetown | South Carolina | 45043 | 7197 | 144 |
1591651 | 1591651 | 2021-08-06 | Kershaw | South Carolina | 45055 | 8235 | 144 |
1588396 | 1588396 | 2021-08-05 | Georgetown | South Carolina | 45043 | 7166 | 144 |
1588402 | 1588402 | 2021-08-05 | Kershaw | South Carolina | 45055 | 8189 | 144 |
1585146 | 1585146 | 2021-08-04 | Georgetown | South Carolina | 45043 | 7136 | 144 |
1585152 | 1585152 | 2021-08-04 | Kershaw | South Carolina | 45055 | 8152 | 144 |
1581896 | 1581896 | 2021-08-03 | Georgetown | South Carolina | 45043 | 7110 | 144 |
1581902 | 1581902 | 2021-08-03 | Kershaw | South Carolina | 45055 | 8110 | 144 |
1578647 | 1578647 | 2021-08-02 | Georgetown | South Carolina | 45043 | 7079 | 144 |
1578653 | 1578653 | 2021-08-02 | Kershaw | South Carolina | 45055 | 8072 | 144 |
1143575 | 1143575 | 2021-03-21 | Cherokee | South Carolina | 45021 | 5644 | 144 |
1140328 | 1140328 | 2021-03-20 | Cherokee | South Carolina | 45021 | 5634 | 144 |
1137082 | 1137082 | 2021-03-19 | Cherokee | South Carolina | 45021 | 5615 | 144 |
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);