ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
46 rows where "date" is on date 2020-10-14 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Abbeville 1
- Aiken 1
- Allendale 1
- Anderson 1
- Bamberg 1
- Barnwell 1
- Beaufort 1
- Berkeley 1
- Calhoun 1
- Charleston 1
- Cherokee 1
- Chester 1
- Chesterfield 1
- Clarendon 1
- Colleton 1
- Darlington 1
- Dillon 1
- Dorchester 1
- Edgefield 1
- Fairfield 1
- Florence 1
- Georgetown 1
- Greenville 1
- Greenwood 1
- Hampton 1
- Horry 1
- Jasper 1
- Kershaw 1
- Lancaster 1
- Laurens 1
- …
state 1
- South Carolina · 46 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
630807 | 630807 | 2020-10-14 | Abbeville | South Carolina | 45001 | 694 | 15 |
630808 | 630808 | 2020-10-14 | Aiken | South Carolina | 45003 | 4644 | 85 |
630809 | 630809 | 2020-10-14 | Allendale | South Carolina | 45005 | 425 | 6 |
630810 | 630810 | 2020-10-14 | Anderson | South Carolina | 45007 | 5076 | 189 |
630811 | 630811 | 2020-10-14 | Bamberg | South Carolina | 45009 | 665 | 35 |
630812 | 630812 | 2020-10-14 | Barnwell | South Carolina | 45011 | 810 | 18 |
630813 | 630813 | 2020-10-14 | Beaufort | South Carolina | 45013 | 5909 | 89 |
630814 | 630814 | 2020-10-14 | Berkeley | South Carolina | 45015 | 5723 | 92 |
630815 | 630815 | 2020-10-14 | Calhoun | South Carolina | 45017 | 494 | 17 |
630816 | 630816 | 2020-10-14 | Charleston | South Carolina | 45019 | 16392 | 269 |
630817 | 630817 | 2020-10-14 | Cherokee | South Carolina | 45021 | 1313 | 46 |
630818 | 630818 | 2020-10-14 | Chester | South Carolina | 45023 | 1131 | 22 |
630819 | 630819 | 2020-10-14 | Chesterfield | South Carolina | 45025 | 1383 | 39 |
630820 | 630820 | 2020-10-14 | Clarendon | South Carolina | 45027 | 1133 | 68 |
630821 | 630821 | 2020-10-14 | Colleton | South Carolina | 45029 | 1167 | 43 |
630822 | 630822 | 2020-10-14 | Darlington | South Carolina | 45031 | 2286 | 63 |
630823 | 630823 | 2020-10-14 | Dillon | South Carolina | 45033 | 1226 | 44 |
630824 | 630824 | 2020-10-14 | Dorchester | South Carolina | 45035 | 4485 | 91 |
630825 | 630825 | 2020-10-14 | Edgefield | South Carolina | 45037 | 862 | 20 |
630826 | 630826 | 2020-10-14 | Fairfield | South Carolina | 45039 | 824 | 37 |
630827 | 630827 | 2020-10-14 | Florence | South Carolina | 45041 | 5259 | 199 |
630828 | 630828 | 2020-10-14 | Georgetown | South Carolina | 45043 | 2067 | 47 |
630829 | 630829 | 2020-10-14 | Greenville | South Carolina | 45045 | 15846 | 330 |
630830 | 630830 | 2020-10-14 | Greenwood | South Carolina | 45047 | 2418 | 73 |
630831 | 630831 | 2020-10-14 | Hampton | South Carolina | 45049 | 730 | 29 |
630832 | 630832 | 2020-10-14 | Horry | South Carolina | 45051 | 11527 | 207 |
630833 | 630833 | 2020-10-14 | Jasper | South Carolina | 45053 | 865 | 23 |
630834 | 630834 | 2020-10-14 | Kershaw | South Carolina | 45055 | 2244 | 41 |
630835 | 630835 | 2020-10-14 | Lancaster | South Carolina | 45057 | 2367 | 56 |
630836 | 630836 | 2020-10-14 | Laurens | South Carolina | 45059 | 1797 | 58 |
630837 | 630837 | 2020-10-14 | Lee | South Carolina | 45061 | 744 | 35 |
630838 | 630838 | 2020-10-14 | Lexington | South Carolina | 45063 | 8206 | 186 |
630839 | 630839 | 2020-10-14 | Marion | South Carolina | 45067 | 1024 | 32 |
630840 | 630840 | 2020-10-14 | Marlboro | South Carolina | 45069 | 1026 | 12 |
630841 | 630841 | 2020-10-14 | McCormick | South Carolina | 45065 | 253 | 7 |
630842 | 630842 | 2020-10-14 | Newberry | South Carolina | 45071 | 1506 | 35 |
630843 | 630843 | 2020-10-14 | Oconee | South Carolina | 45073 | 2191 | 29 |
630844 | 630844 | 2020-10-14 | Orangeburg | South Carolina | 45075 | 3219 | 129 |
630845 | 630845 | 2020-10-14 | Pickens | South Carolina | 45077 | 3695 | 52 |
630846 | 630846 | 2020-10-14 | Richland | South Carolina | 45079 | 16263 | 258 |
630847 | 630847 | 2020-10-14 | Saluda | South Carolina | 45081 | 710 | 22 |
630848 | 630848 | 2020-10-14 | Spartanburg | South Carolina | 45083 | 7802 | 210 |
630849 | 630849 | 2020-10-14 | Sumter | South Carolina | 45085 | 3350 | 84 |
630850 | 630850 | 2020-10-14 | Union | South Carolina | 45087 | 670 | 15 |
630851 | 630851 | 2020-10-14 | Williamsburg | South Carolina | 45089 | 1372 | 46 |
630852 | 630852 | 2020-10-14 | York | South Carolina | 45091 | 6016 | 90 |
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);