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-02-02 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
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 |
---|---|---|---|---|---|---|---|
991006 | 991006 | 2021-02-02 | Abbeville | South Carolina | 45001 | 1856 | 30 |
991007 | 991007 | 2021-02-02 | Aiken | South Carolina | 45003 | 13191 | 175 |
991008 | 991008 | 2021-02-02 | Allendale | South Carolina | 45005 | 706 | 13 |
991009 | 991009 | 2021-02-02 | Anderson | South Carolina | 45007 | 17674 | 383 |
991010 | 991010 | 2021-02-02 | Bamberg | South Carolina | 45009 | 1262 | 44 |
991011 | 991011 | 2021-02-02 | Barnwell | South Carolina | 45011 | 2086 | 43 |
991012 | 991012 | 2021-02-02 | Beaufort | South Carolina | 45013 | 13644 | 154 |
991013 | 991013 | 2021-02-02 | Berkeley | South Carolina | 45015 | 12843 | 144 |
991014 | 991014 | 2021-02-02 | Calhoun | South Carolina | 45017 | 1134 | 29 |
991015 | 991015 | 2021-02-02 | Charleston | South Carolina | 45019 | 33254 | 397 |
991016 | 991016 | 2021-02-02 | Cherokee | South Carolina | 45021 | 4587 | 118 |
991017 | 991017 | 2021-02-02 | Chester | South Carolina | 45023 | 3206 | 55 |
991018 | 991018 | 2021-02-02 | Chesterfield | South Carolina | 45025 | 3484 | 83 |
991019 | 991019 | 2021-02-02 | Clarendon | South Carolina | 45027 | 2563 | 85 |
991020 | 991020 | 2021-02-02 | Colleton | South Carolina | 45029 | 2842 | 88 |
991021 | 991021 | 2021-02-02 | Darlington | South Carolina | 45031 | 7023 | 137 |
991022 | 991022 | 2021-02-02 | Dillon | South Carolina | 45033 | 3559 | 71 |
991023 | 991023 | 2021-02-02 | Dorchester | South Carolina | 45035 | 12838 | 154 |
991024 | 991024 | 2021-02-02 | Edgefield | South Carolina | 45037 | 2354 | 32 |
991025 | 991025 | 2021-02-02 | Fairfield | South Carolina | 45039 | 1893 | 62 |
991026 | 991026 | 2021-02-02 | Florence | South Carolina | 45041 | 15141 | 357 |
991027 | 991027 | 2021-02-02 | Georgetown | South Carolina | 45043 | 5525 | 126 |
991028 | 991028 | 2021-02-02 | Greenville | South Carolina | 45045 | 56352 | 728 |
991029 | 991029 | 2021-02-02 | Greenwood | South Carolina | 45047 | 6242 | 135 |
991030 | 991030 | 2021-02-02 | Hampton | South Carolina | 45049 | 1526 | 41 |
991031 | 991031 | 2021-02-02 | Horry | South Carolina | 45051 | 29296 | 456 |
991032 | 991032 | 2021-02-02 | Jasper | South Carolina | 45053 | 1897 | 37 |
991033 | 991033 | 2021-02-02 | Kershaw | South Carolina | 45055 | 5645 | 100 |
991034 | 991034 | 2021-02-02 | Lancaster | South Carolina | 45057 | 7966 | 118 |
991035 | 991035 | 2021-02-02 | Laurens | South Carolina | 45059 | 5547 | 134 |
991036 | 991036 | 2021-02-02 | Lee | South Carolina | 45061 | 1632 | 51 |
991037 | 991037 | 2021-02-02 | Lexington | South Carolina | 45063 | 24926 | 384 |
991038 | 991038 | 2021-02-02 | Marion | South Carolina | 45067 | 2918 | 87 |
991039 | 991039 | 2021-02-02 | Marlboro | South Carolina | 45069 | 2652 | 42 |
991040 | 991040 | 2021-02-02 | McCormick | South Carolina | 45065 | 719 | 17 |
991041 | 991041 | 2021-02-02 | Newberry | South Carolina | 45071 | 3803 | 85 |
991042 | 991042 | 2021-02-02 | Oconee | South Carolina | 45073 | 7624 | 102 |
991043 | 991043 | 2021-02-02 | Orangeburg | South Carolina | 45075 | 7622 | 188 |
991044 | 991044 | 2021-02-02 | Pickens | South Carolina | 45077 | 14797 | 224 |
991045 | 991045 | 2021-02-02 | Richland | South Carolina | 45079 | 36169 | 440 |
991046 | 991046 | 2021-02-02 | Saluda | South Carolina | 45081 | 1369 | 36 |
991047 | 991047 | 2021-02-02 | Spartanburg | South Carolina | 45083 | 30215 | 583 |
991048 | 991048 | 2021-02-02 | Sumter | South Carolina | 45085 | 8203 | 148 |
991049 | 991049 | 2021-02-02 | Union | South Carolina | 45087 | 2263 | 61 |
991050 | 991050 | 2021-02-02 | Williamsburg | South Carolina | 45089 | 3355 | 77 |
991051 | 991051 | 2021-02-02 | York | South Carolina | 45091 | 22501 | 264 |
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);