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 2021-08-03 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 46
- 45001 1
- 45003 1
- 45005 1
- 45007 1
- 45009 1
- 45011 1
- 45013 1
- 45015 1
- 45017 1
- 45019 1
- 45021 1
- 45023 1
- 45025 1
- 45027 1
- 45029 1
- 45031 1
- 45033 1
- 45035 1
- 45037 1
- 45039 1
- 45041 1
- 45043 1
- 45045 1
- 45047 1
- 45049 1
- 45051 1
- 45053 1
- 45055 1
- 45057 1
- 45059 1
- 45061 1
- 45063 1
- 45065 1
- 45067 1
- 45069 1
- 45071 1
- 45073 1
- 45075 1
- 45077 1
- 45079 1
- 45081 1
- 45083 1
- 45085 1
- 45087 1
- 45089 1
- 45091 1
county 46
- 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
- Lee 1
- Lexington 1
- Marion 1
- Marlboro 1
- McCormick 1
- Newberry 1
- Oconee 1
- Orangeburg 1
- Pickens 1
- Richland 1
- Saluda 1
- Spartanburg 1
- Sumter 1
- Union 1
- Williamsburg 1
- York 1
state 1
- South Carolina · 46 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1581875 | 1581875 | 2021-08-03 | Abbeville | South Carolina | 45001 | 2666 | 41 |
1581876 | 1581876 | 2021-08-03 | Aiken | South Carolina | 45003 | 18500 | 226 |
1581877 | 1581877 | 2021-08-03 | Allendale | South Carolina | 45005 | 985 | 15 |
1581878 | 1581878 | 2021-08-03 | Anderson | South Carolina | 45007 | 24053 | 537 |
1581879 | 1581879 | 2021-08-03 | Bamberg | South Carolina | 45009 | 1629 | 53 |
1581880 | 1581880 | 2021-08-03 | Barnwell | South Carolina | 45011 | 2710 | 58 |
1581881 | 1581881 | 2021-08-03 | Beaufort | South Carolina | 45013 | 18312 | 211 |
1581882 | 1581882 | 2021-08-03 | Berkeley | South Carolina | 45015 | 19438 | 209 |
1581883 | 1581883 | 2021-08-03 | Calhoun | South Carolina | 45017 | 1372 | 37 |
1581884 | 1581884 | 2021-08-03 | Charleston | South Carolina | 45019 | 46453 | 519 |
1581885 | 1581885 | 2021-08-03 | Cherokee | South Carolina | 45021 | 6455 | 159 |
1581886 | 1581886 | 2021-08-03 | Chester | South Carolina | 45023 | 4468 | 80 |
1581887 | 1581887 | 2021-08-03 | Chesterfield | South Carolina | 45025 | 5104 | 108 |
1581888 | 1581888 | 2021-08-03 | Clarendon | South Carolina | 45027 | 3684 | 114 |
1581889 | 1581889 | 2021-08-03 | Colleton | South Carolina | 45029 | 3889 | 135 |
1581890 | 1581890 | 2021-08-03 | Darlington | South Carolina | 45031 | 8871 | 183 |
1581891 | 1581891 | 2021-08-03 | Dillon | South Carolina | 45033 | 4586 | 85 |
1581892 | 1581892 | 2021-08-03 | Dorchester | South Carolina | 45035 | 19932 | 228 |
1581893 | 1581893 | 2021-08-03 | Edgefield | South Carolina | 45037 | 3258 | 43 |
1581894 | 1581894 | 2021-08-03 | Fairfield | South Carolina | 45039 | 2539 | 83 |
1581895 | 1581895 | 2021-08-03 | Florence | South Carolina | 45041 | 18633 | 427 |
1581896 | 1581896 | 2021-08-03 | Georgetown | South Carolina | 45043 | 7110 | 144 |
1581897 | 1581897 | 2021-08-03 | Greenville | South Carolina | 45045 | 77825 | 1043 |
1581898 | 1581898 | 2021-08-03 | Greenwood | South Carolina | 45047 | 8488 | 174 |
1581899 | 1581899 | 2021-08-03 | Hampton | South Carolina | 45049 | 2045 | 52 |
1581900 | 1581900 | 2021-08-03 | Horry | South Carolina | 45051 | 42804 | 597 |
1581901 | 1581901 | 2021-08-03 | Jasper | South Carolina | 45053 | 2598 | 49 |
1581902 | 1581902 | 2021-08-03 | Kershaw | South Carolina | 45055 | 8110 | 144 |
1581903 | 1581903 | 2021-08-03 | Lancaster | South Carolina | 45057 | 11388 | 175 |
1581904 | 1581904 | 2021-08-03 | Laurens | South Carolina | 45059 | 7698 | 172 |
1581905 | 1581905 | 2021-08-03 | Lee | South Carolina | 45061 | 2002 | 65 |
1581906 | 1581906 | 2021-08-03 | Lexington | South Carolina | 45063 | 36166 | 482 |
1581907 | 1581907 | 2021-08-03 | Marion | South Carolina | 45067 | 3719 | 108 |
1581908 | 1581908 | 2021-08-03 | Marlboro | South Carolina | 45069 | 3609 | 61 |
1581909 | 1581909 | 2021-08-03 | McCormick | South Carolina | 45065 | 1069 | 28 |
1581910 | 1581910 | 2021-08-03 | Newberry | South Carolina | 45071 | 5300 | 108 |
1581911 | 1581911 | 2021-08-03 | Oconee | South Carolina | 45073 | 10297 | 143 |
1581912 | 1581912 | 2021-08-03 | Orangeburg | South Carolina | 45075 | 10266 | 256 |
1581913 | 1581913 | 2021-08-03 | Pickens | South Carolina | 45077 | 19565 | 306 |
1581914 | 1581914 | 2021-08-03 | Richland | South Carolina | 45079 | 50486 | 582 |
1581915 | 1581915 | 2021-08-03 | Saluda | South Carolina | 45081 | 1846 | 48 |
1581916 | 1581916 | 2021-08-03 | Spartanburg | South Carolina | 45083 | 43397 | 831 |
1581917 | 1581917 | 2021-08-03 | Sumter | South Carolina | 45085 | 11455 | 211 |
1581918 | 1581918 | 2021-08-03 | Union | South Carolina | 45087 | 3279 | 82 |
1581919 | 1581919 | 2021-08-03 | Williamsburg | South Carolina | 45089 | 4255 | 106 |
1581920 | 1581920 | 2021-08-03 | York | South Carolina | 45091 | 33724 | 399 |
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);