ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

4,854 rows where state = "South Carolina" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

county

state

  • South Carolina · 4,854
Link rowid date ▲ county state fips cases deaths
294032 2020-07-03 Abbeville South Carolina 45001 118 0
294033 2020-07-03 Aiken South Carolina 45003 451 10
294034 2020-07-03 Allendale South Carolina 45005 58 3
294035 2020-07-03 Anderson South Carolina 45007 742 12
294036 2020-07-03 Bamberg South Carolina 45009 140 1
294037 2020-07-03 Barnwell South Carolina 45011 88 1
294038 2020-07-03 Beaufort South Carolina 45013 1376 21
294039 2020-07-03 Berkeley South Carolina 45015 1392 23
294040 2020-07-03 Calhoun South Carolina 45017 103 2
294041 2020-07-03 Charleston South Carolina 45019 5033 34
294042 2020-07-03 Cherokee South Carolina 45021 173 7
294043 2020-07-03 Chester South Carolina 45023 217 1
294044 2020-07-03 Chesterfield South Carolina 45025 385 14
294045 2020-07-03 Clarendon South Carolina 45027 435 43
294046 2020-07-03 Colleton South Carolina 45029 352 22
294047 2020-07-03 Darlington South Carolina 45031 469 15
294048 2020-07-03 Dillon South Carolina 45033 321 10
294049 2020-07-03 Dorchester South Carolina 45035 928 3
294050 2020-07-03 Edgefield South Carolina 45037 90 3
294051 2020-07-03 Fairfield South Carolina 45039 305 22
294052 2020-07-03 Florence South Carolina 45041 1296 55
294053 2020-07-03 Georgetown South Carolina 45043 549 4
294054 2020-07-03 Greenville South Carolina 45045 5497 86
294055 2020-07-03 Greenwood South Carolina 45047 528 7
294056 2020-07-03 Hampton South Carolina 45049 79 2
294057 2020-07-03 Horry South Carolina 45051 3966 50
294058 2020-07-03 Jasper South Carolina 45053 170 3
294059 2020-07-03 Kershaw South Carolina 45055 725 17
294060 2020-07-03 Lancaster South Carolina 45057 519 13
294061 2020-07-03 Laurens South Carolina 45059 546 8
294062 2020-07-03 Lee South Carolina 45061 301 22
294063 2020-07-03 Lexington South Carolina 45063 2281 53
294064 2020-07-03 Marion South Carolina 45067 234 8
294065 2020-07-03 Marlboro South Carolina 45069 311 4
294066 2020-07-03 McCormick South Carolina 45065 18 2
294067 2020-07-03 Newberry South Carolina 45071 287 4
294068 2020-07-03 Oconee South Carolina 45073 304 1
294069 2020-07-03 Orangeburg South Carolina 45075 853 14
294070 2020-07-03 Pickens South Carolina 45077 921 5
294071 2020-07-03 Richland South Carolina 45079 3866 86
294072 2020-07-03 Saluda South Carolina 45081 224 1
294073 2020-07-03 Spartanburg South Carolina 45083 1798 49
294074 2020-07-03 Sumter South Carolina 45085 1158 25
294075 2020-07-03 Union South Carolina 45087 98 0
294076 2020-07-03 Williamsburg South Carolina 45089 421 15
294077 2020-07-03 York South Carolina 45091 1406 12
290952 2020-07-02 Abbeville South Carolina 45001 119 0
290953 2020-07-02 Aiken South Carolina 45003 434 10
290954 2020-07-02 Allendale South Carolina 45005 58 3
290955 2020-07-02 Anderson South Carolina 45007 676 11
290956 2020-07-02 Bamberg South Carolina 45009 130 1
290957 2020-07-02 Barnwell South Carolina 45011 86 1
290958 2020-07-02 Beaufort South Carolina 45013 1325 20
290959 2020-07-02 Berkeley South Carolina 45015 1278 23
290960 2020-07-02 Calhoun South Carolina 45017 99 2
290961 2020-07-02 Charleston South Carolina 45019 4615 34
290962 2020-07-02 Cherokee South Carolina 45021 169 8
290963 2020-07-02 Chester South Carolina 45023 201 1
290964 2020-07-02 Chesterfield South Carolina 45025 376 14
290965 2020-07-02 Clarendon South Carolina 45027 423 43
290966 2020-07-02 Colleton South Carolina 45029 343 22
290967 2020-07-02 Darlington South Carolina 45031 461 15
290968 2020-07-02 Dillon South Carolina 45033 316 10
290969 2020-07-02 Dorchester South Carolina 45035 844 3
290970 2020-07-02 Edgefield South Carolina 45037 86 3
290971 2020-07-02 Fairfield South Carolina 45039 303 22
290972 2020-07-02 Florence South Carolina 45041 1266 55
290973 2020-07-02 Georgetown South Carolina 45043 506 3
290974 2020-07-02 Greenville South Carolina 45045 5371 83
290975 2020-07-02 Greenwood South Carolina 45047 527 7
290976 2020-07-02 Hampton South Carolina 45049 74 2
290977 2020-07-02 Horry South Carolina 45051 3730 50
290978 2020-07-02 Jasper South Carolina 45053 142 3
290979 2020-07-02 Kershaw South Carolina 45055 708 15
290980 2020-07-02 Lancaster South Carolina 45057 506 13
290981 2020-07-02 Laurens South Carolina 45059 521 7
290982 2020-07-02 Lee South Carolina 45061 295 22
290983 2020-07-02 Lexington South Carolina 45063 2236 53
290984 2020-07-02 Marion South Carolina 45067 214 7
290985 2020-07-02 Marlboro South Carolina 45069 310 4
290986 2020-07-02 McCormick South Carolina 45065 17 2
290987 2020-07-02 Newberry South Carolina 45071 270 4
290988 2020-07-02 Oconee South Carolina 45073 290 1
290989 2020-07-02 Orangeburg South Carolina 45075 813 14
290990 2020-07-02 Pickens South Carolina 45077 896 5
290991 2020-07-02 Richland South Carolina 45079 3757 86
290992 2020-07-02 Saluda South Carolina 45081 219 1
290993 2020-07-02 Spartanburg South Carolina 45083 1767 49
290994 2020-07-02 Sumter South Carolina 45085 1115 25
290995 2020-07-02 Union South Carolina 45087 95 0
290996 2020-07-02 Williamsburg South Carolina 45089 413 15
290997 2020-07-02 York South Carolina 45091 1301 12
287875 2020-07-01 Abbeville South Carolina 45001 113 0
287876 2020-07-01 Aiken South Carolina 45003 406 10
287877 2020-07-01 Allendale South Carolina 45005 50 3
287878 2020-07-01 Anderson South Carolina 45007 635 11
287879 2020-07-01 Bamberg South Carolina 45009 117 1
287880 2020-07-01 Barnwell South Carolina 45011 82 1
287881 2020-07-01 Beaufort South Carolina 45013 1282 18
287882 2020-07-01 Berkeley South Carolina 45015 1170 23

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 918.094ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette