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-07-30 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 |
---|---|---|---|---|---|---|---|
385112 | 385112 | 2020-07-30 | Abbeville | South Carolina | 45001 | 285 | 7 |
385113 | 385113 | 2020-07-30 | Aiken | South Carolina | 45003 | 1444 | 24 |
385114 | 385114 | 2020-07-30 | Allendale | South Carolina | 45005 | 172 | 3 |
385115 | 385115 | 2020-07-30 | Anderson | South Carolina | 45007 | 1882 | 41 |
385116 | 385116 | 2020-07-30 | Bamberg | South Carolina | 45009 | 414 | 15 |
385117 | 385117 | 2020-07-30 | Barnwell | South Carolina | 45011 | 313 | 4 |
385118 | 385118 | 2020-07-30 | Beaufort | South Carolina | 45013 | 3398 | 44 |
385119 | 385119 | 2020-07-30 | Berkeley | South Carolina | 45015 | 3731 | 57 |
385120 | 385120 | 2020-07-30 | Calhoun | South Carolina | 45017 | 284 | 6 |
385121 | 385121 | 2020-07-30 | Charleston | South Carolina | 45019 | 11260 | 158 |
385122 | 385122 | 2020-07-30 | Cherokee | South Carolina | 45021 | 515 | 24 |
385123 | 385123 | 2020-07-30 | Chester | South Carolina | 45023 | 523 | 10 |
385124 | 385124 | 2020-07-30 | Chesterfield | South Carolina | 45025 | 660 | 19 |
385125 | 385125 | 2020-07-30 | Clarendon | South Carolina | 45027 | 740 | 50 |
385126 | 385126 | 2020-07-30 | Colleton | South Carolina | 45029 | 727 | 31 |
385127 | 385127 | 2020-07-30 | Darlington | South Carolina | 45031 | 994 | 33 |
385128 | 385128 | 2020-07-30 | Dillon | South Carolina | 45033 | 536 | 23 |
385129 | 385129 | 2020-07-30 | Dorchester | South Carolina | 45035 | 2653 | 37 |
385130 | 385130 | 2020-07-30 | Edgefield | South Carolina | 45037 | 264 | 6 |
385131 | 385131 | 2020-07-30 | Fairfield | South Carolina | 45039 | 517 | 23 |
385132 | 385132 | 2020-07-30 | Florence | South Carolina | 45041 | 2789 | 91 |
385133 | 385133 | 2020-07-30 | Georgetown | South Carolina | 45043 | 1211 | 17 |
385134 | 385134 | 2020-07-30 | Greenville | South Carolina | 45045 | 9876 | 175 |
385135 | 385135 | 2020-07-30 | Greenwood | South Carolina | 45047 | 1174 | 15 |
385136 | 385136 | 2020-07-30 | Hampton | South Carolina | 45049 | 309 | 8 |
385137 | 385137 | 2020-07-30 | Horry | South Carolina | 45051 | 7873 | 121 |
385138 | 385138 | 2020-07-30 | Jasper | South Carolina | 45053 | 474 | 11 |
385139 | 385139 | 2020-07-30 | Kershaw | South Carolina | 45055 | 1246 | 22 |
385140 | 385140 | 2020-07-30 | Lancaster | South Carolina | 45057 | 1003 | 21 |
385141 | 385141 | 2020-07-30 | Laurens | South Carolina | 45059 | 1176 | 33 |
385142 | 385142 | 2020-07-30 | Lee | South Carolina | 45061 | 485 | 26 |
385143 | 385143 | 2020-07-30 | Lexington | South Carolina | 45063 | 4488 | 97 |
385144 | 385144 | 2020-07-30 | Marion | South Carolina | 45067 | 498 | 12 |
385145 | 385145 | 2020-07-30 | Marlboro | South Carolina | 45069 | 409 | 4 |
385146 | 385146 | 2020-07-30 | McCormick | South Carolina | 45065 | 100 | 2 |
385147 | 385147 | 2020-07-30 | Newberry | South Carolina | 45071 | 737 | 8 |
385148 | 385148 | 2020-07-30 | Oconee | South Carolina | 45073 | 699 | 6 |
385149 | 385149 | 2020-07-30 | Orangeburg | South Carolina | 45075 | 2061 | 52 |
385150 | 385150 | 2020-07-30 | Pickens | South Carolina | 45077 | 1653 | 20 |
385151 | 385151 | 2020-07-30 | Richland | South Carolina | 45079 | 7617 | 129 |
385152 | 385152 | 2020-07-30 | Saluda | South Carolina | 45081 | 395 | 7 |
385153 | 385153 | 2020-07-30 | Spartanburg | South Carolina | 45083 | 3609 | 81 |
385154 | 385154 | 2020-07-30 | Sumter | South Carolina | 45085 | 2201 | 42 |
385155 | 385155 | 2020-07-30 | Union | South Carolina | 45087 | 307 | 2 |
385156 | 385156 | 2020-07-30 | Williamsburg | South Carolina | 45089 | 848 | 23 |
385157 | 385157 | 2020-07-30 | York | South Carolina | 45091 | 3022 | 27 |
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);