ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where deaths = 216 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 16
county 16
- Aiken 5
- Lexington 5
- Cherokee 4
- Laurens 4
- Georgetown 3
- Oconee 3
- Orangeburg 3
- Dorchester 2
- Beaufort 1
- Berkeley 1
- Colleton 1
- Darlington 1
- Florence 1
- Greenwood 1
- Kershaw 1
- York 1
state 1
- South Carolina · 37 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2290447 | 2290447 | 2022-03-09 | Colleton | South Carolina | 45029 | 8820 | 216 |
2257933 | 2257933 | 2022-02-27 | Georgetown | South Carolina | 45043 | 15723 | 216 |
2254682 | 2254682 | 2022-02-26 | Georgetown | South Carolina | 45043 | 15723 | 216 |
2251431 | 2251431 | 2022-02-25 | Georgetown | South Carolina | 45043 | 15723 | 216 |
2010803 | 2010803 | 2021-12-13 | Kershaw | South Carolina | 45055 | 12622 | 216 |
1871054 | 1871054 | 2021-10-31 | Oconee | South Carolina | 45073 | 15505 | 216 |
1867805 | 1867805 | 2021-10-30 | Oconee | South Carolina | 45073 | 15505 | 216 |
1864556 | 1864556 | 2021-10-29 | Oconee | South Carolina | 45073 | 15505 | 216 |
1838554 | 1838554 | 2021-10-21 | Laurens | South Carolina | 45059 | 11501 | 216 |
1835299 | 1835299 | 2021-10-20 | Greenwood | South Carolina | 45047 | 12245 | 216 |
1835305 | 1835305 | 2021-10-20 | Laurens | South Carolina | 45059 | 11487 | 216 |
1832056 | 1832056 | 2021-10-19 | Laurens | South Carolina | 45059 | 11471 | 216 |
1828807 | 1828807 | 2021-10-18 | Laurens | South Carolina | 45059 | 11462 | 216 |
1780053 | 1780053 | 2021-10-03 | Cherokee | South Carolina | 45021 | 9513 | 216 |
1776803 | 1776803 | 2021-10-02 | Cherokee | South Carolina | 45021 | 9513 | 216 |
1773553 | 1773553 | 2021-10-01 | Cherokee | South Carolina | 45021 | 9513 | 216 |
1770303 | 1770303 | 2021-09-30 | Cherokee | South Carolina | 45021 | 9490 | 216 |
1767059 | 1767059 | 2021-09-29 | Darlington | South Carolina | 45031 | 11446 | 216 |
1633856 | 1633856 | 2021-08-19 | Berkeley | South Carolina | 45015 | 21810 | 216 |
1611122 | 1611122 | 2021-08-12 | Beaufort | South Carolina | 45013 | 19650 | 216 |
1289715 | 1289715 | 2021-05-05 | Dorchester | South Carolina | 45035 | 17694 | 216 |
1266988 | 1266988 | 2021-04-28 | Dorchester | South Carolina | 45035 | 17450 | 216 |
1198774 | 1198774 | 2021-04-07 | Aiken | South Carolina | 45003 | 16616 | 216 |
1195525 | 1195525 | 2021-04-06 | Aiken | South Carolina | 45003 | 16602 | 216 |
1192277 | 1192277 | 2021-04-05 | Aiken | South Carolina | 45003 | 16576 | 216 |
1189028 | 1189028 | 2021-04-04 | Aiken | South Carolina | 45003 | 16554 | 216 |
1185781 | 1185781 | 2021-04-03 | Aiken | South Carolina | 45003 | 16554 | 216 |
1075430 | 1075430 | 2021-02-28 | Orangeburg | South Carolina | 45075 | 8769 | 216 |
1072184 | 1072184 | 2021-02-27 | Orangeburg | South Carolina | 45075 | 8737 | 216 |
1068938 | 1068938 | 2021-02-26 | Orangeburg | South Carolina | 45075 | 8697 | 216 |
974820 | 974820 | 2021-01-28 | York | South Carolina | 45091 | 21640 | 216 |
783322 | 783322 | 2020-11-30 | Florence | South Carolina | 45041 | 6750 | 216 |
728159 | 728159 | 2020-11-13 | Lexington | South Carolina | 45063 | 10185 | 216 |
724915 | 724915 | 2020-11-12 | Lexington | South Carolina | 45063 | 10110 | 216 |
721672 | 721672 | 2020-11-11 | Lexington | South Carolina | 45063 | 9997 | 216 |
718429 | 718429 | 2020-11-10 | Lexington | South Carolina | 45063 | 9892 | 216 |
715186 | 715186 | 2020-11-09 | Lexington | South Carolina | 45063 | 9807 | 216 |
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);