ny_times_us_counties

Table actions
⚠️ 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

36,091 rows where state = "South Carolina" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips >30

county >30

state 1

  • South Carolina · 36,091 ✖
Link rowid date ▲ county state fips cases deaths
2501999 2501999 2022-05-13 Abbeville South Carolina 45001 6655 69
2502000 2502000 2022-05-13 Aiken South Carolina 45003 41767 437
2502001 2502001 2022-05-13 Allendale South Carolina 45005 2093 24
2502002 2502002 2022-05-13 Anderson South Carolina 45007 58025 998
2502003 2502003 2022-05-13 Bamberg South Carolina 45009 3446 75
2502004 2502004 2022-05-13 Barnwell South Carolina 45011 5834 103
2502005 2502005 2022-05-13 Beaufort South Carolina 45013 43530 380
2502006 2502006 2022-05-13 Berkeley South Carolina 45015 52240 450
2502007 2502007 2022-05-13 Calhoun South Carolina 45017 2799 61
2502008 2502008 2022-05-13 Charleston South Carolina 45019 112905 945
2502009 2502009 2022-05-13 Cherokee South Carolina 45021 14761 322
2502010 2502010 2022-05-13 Chester South Carolina 45023 10134 153
2502011 2502011 2022-05-13 Chesterfield South Carolina 45025 11836 191
2502012 2502012 2022-05-13 Clarendon South Carolina 45027 8776 159
2502013 2502013 2022-05-13 Colleton South Carolina 45029 8913 221
2502014 2502014 2022-05-13 Darlington South Carolina 45031 18939 311
2502015 2502015 2022-05-13 Dillon South Carolina 45033 9729 144
2502016 2502016 2022-05-13 Dorchester South Carolina 45035 56325 496
2502017 2502017 2022-05-13 Edgefield South Carolina 45037 6779 71
2502018 2502018 2022-05-13 Fairfield South Carolina 45039 6007 107
2502019 2502019 2022-05-13 Florence South Carolina 45041 41861 631
2502020 2502020 2022-05-13 Georgetown South Carolina 45043 15958 227
2502021 2502021 2022-05-13 Greenville South Carolina 45045 173338 2008
2502022 2502022 2022-05-13 Greenwood South Carolina 45047 22607 305
2502023 2502023 2022-05-13 Hampton South Carolina 45049 5024 86
2502024 2502024 2022-05-13 Horry South Carolina 45051 97534 1159
2502025 2502025 2022-05-13 Jasper South Carolina 45053 5924 93
2502026 2502026 2022-05-13 Kershaw South Carolina 45055 21623 261
2502027 2502027 2022-05-13 Lancaster South Carolina 45057 25276 281
2502028 2502028 2022-05-13 Laurens South Carolina 45059 18667 295
2502029 2502029 2022-05-13 Lee South Carolina 45061 4272 95
2502030 2502030 2022-05-13 Lexington South Carolina 45063 96569 872
2502031 2502031 2022-05-13 Marion South Carolina 45067 8564 163
2502032 2502032 2022-05-13 Marlboro South Carolina 45069 7880 105
2502033 2502033 2022-05-13 McCormick South Carolina 45065 2244 40
2502034 2502034 2022-05-13 Newberry South Carolina 45071 13355 195
2502035 2502035 2022-05-13 Oconee South Carolina 45073 24348 343
2502036 2502036 2022-05-13 Orangeburg South Carolina 45075 23425 420
2502037 2502037 2022-05-13 Pickens South Carolina 45077 46111 632
2502038 2502038 2022-05-13 Richland South Carolina 45079 123578 947
2502039 2502039 2022-05-13 Saluda South Carolina 45081 3968 78
2502040 2502040 2022-05-13 Spartanburg South Carolina 45083 95357 1548
2502041 2502041 2022-05-13 Sumter South Carolina 45085 28100 394
2502042 2502042 2022-05-13 Union South Carolina 45087 7750 150
2502043 2502043 2022-05-13 Williamsburg South Carolina 45089 8557 146
2502044 2502044 2022-05-13 York South Carolina 45091 78263 678
2498741 2498741 2022-05-12 Abbeville South Carolina 45001 6655 69
2498742 2498742 2022-05-12 Aiken South Carolina 45003 41767 437
2498743 2498743 2022-05-12 Allendale South Carolina 45005 2093 24
2498744 2498744 2022-05-12 Anderson South Carolina 45007 58025 998
2498745 2498745 2022-05-12 Bamberg South Carolina 45009 3446 75
2498746 2498746 2022-05-12 Barnwell South Carolina 45011 5834 103
2498747 2498747 2022-05-12 Beaufort South Carolina 45013 43530 380
2498748 2498748 2022-05-12 Berkeley South Carolina 45015 52240 450
2498749 2498749 2022-05-12 Calhoun South Carolina 45017 2799 61
2498750 2498750 2022-05-12 Charleston South Carolina 45019 112905 945
2498751 2498751 2022-05-12 Cherokee South Carolina 45021 14761 322
2498752 2498752 2022-05-12 Chester South Carolina 45023 10134 153
2498753 2498753 2022-05-12 Chesterfield South Carolina 45025 11836 191
2498754 2498754 2022-05-12 Clarendon South Carolina 45027 8776 159
2498755 2498755 2022-05-12 Colleton South Carolina 45029 8913 221
2498756 2498756 2022-05-12 Darlington South Carolina 45031 18939 311
2498757 2498757 2022-05-12 Dillon South Carolina 45033 9729 144
2498758 2498758 2022-05-12 Dorchester South Carolina 45035 56325 496
2498759 2498759 2022-05-12 Edgefield South Carolina 45037 6779 71
2498760 2498760 2022-05-12 Fairfield South Carolina 45039 6007 107
2498761 2498761 2022-05-12 Florence South Carolina 45041 41861 631
2498762 2498762 2022-05-12 Georgetown South Carolina 45043 15958 227
2498763 2498763 2022-05-12 Greenville South Carolina 45045 173338 2008
2498764 2498764 2022-05-12 Greenwood South Carolina 45047 22607 305
2498765 2498765 2022-05-12 Hampton South Carolina 45049 5024 86
2498766 2498766 2022-05-12 Horry South Carolina 45051 97534 1159
2498767 2498767 2022-05-12 Jasper South Carolina 45053 5924 93
2498768 2498768 2022-05-12 Kershaw South Carolina 45055 21623 261
2498769 2498769 2022-05-12 Lancaster South Carolina 45057 25276 281
2498770 2498770 2022-05-12 Laurens South Carolina 45059 18667 295
2498771 2498771 2022-05-12 Lee South Carolina 45061 4272 95
2498772 2498772 2022-05-12 Lexington South Carolina 45063 96569 872
2498773 2498773 2022-05-12 Marion South Carolina 45067 8564 163
2498774 2498774 2022-05-12 Marlboro South Carolina 45069 7880 105
2498775 2498775 2022-05-12 McCormick South Carolina 45065 2244 40
2498776 2498776 2022-05-12 Newberry South Carolina 45071 13355 195
2498777 2498777 2022-05-12 Oconee South Carolina 45073 24348 343
2498778 2498778 2022-05-12 Orangeburg South Carolina 45075 23425 420
2498779 2498779 2022-05-12 Pickens South Carolina 45077 46111 632
2498780 2498780 2022-05-12 Richland South Carolina 45079 123578 947
2498781 2498781 2022-05-12 Saluda South Carolina 45081 3968 78
2498782 2498782 2022-05-12 Spartanburg South Carolina 45083 95357 1548
2498783 2498783 2022-05-12 Sumter South Carolina 45085 28100 394
2498784 2498784 2022-05-12 Union South Carolina 45087 7750 150
2498785 2498785 2022-05-12 Williamsburg South Carolina 45089 8557 146
2498786 2498786 2022-05-12 York South Carolina 45091 78263 678
2495483 2495483 2022-05-11 Abbeville South Carolina 45001 6655 69
2495484 2495484 2022-05-11 Aiken South Carolina 45003 41767 437
2495485 2495485 2022-05-11 Allendale South Carolina 45005 2093 24
2495486 2495486 2022-05-11 Anderson South Carolina 45007 58025 998
2495487 2495487 2022-05-11 Bamberg South Carolina 45009 3446 75
2495488 2495488 2022-05-11 Barnwell South Carolina 45011 5834 103
2495489 2495489 2022-05-11 Beaufort South Carolina 45013 43530 380
2495490 2495490 2022-05-11 Berkeley South Carolina 45015 52240 450

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
);
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);