ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where deaths = 203 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176629 | 2176629 | 2022-02-02 | Colleton | South Carolina | 45029 | 8311 | 203 |
1906790 | 1906790 | 2021-11-11 | Kershaw | South Carolina | 45055 | 12086 | 203 |
1903541 | 1903541 | 2021-11-10 | Kershaw | South Carolina | 45055 | 12086 | 203 |
1900291 | 1900291 | 2021-11-09 | Kershaw | South Carolina | 45055 | 12078 | 203 |
1897041 | 1897041 | 2021-11-08 | Kershaw | South Carolina | 45055 | 12076 | 203 |
1893791 | 1893791 | 2021-11-07 | Kershaw | South Carolina | 45055 | 12047 | 203 |
1890541 | 1890541 | 2021-11-06 | Kershaw | South Carolina | 45055 | 12047 | 203 |
1887291 | 1887291 | 2021-11-05 | Kershaw | South Carolina | 45055 | 12047 | 203 |
1884041 | 1884041 | 2021-11-04 | Kershaw | South Carolina | 45055 | 12033 | 203 |
1763823 | 1763823 | 2021-09-28 | Lancaster | South Carolina | 45057 | 15047 | 203 |
1757308 | 1757308 | 2021-09-26 | Cherokee | South Carolina | 45021 | 9072 | 203 |
1754060 | 1754060 | 2021-09-25 | Cherokee | South Carolina | 45021 | 9072 | 203 |
1750812 | 1750812 | 2021-09-24 | Cherokee | South Carolina | 45021 | 9072 | 203 |
1721572 | 1721572 | 2021-09-15 | Darlington | South Carolina | 45031 | 10815 | 203 |
1416305 | 1416305 | 2021-06-13 | Berkeley | South Carolina | 45015 | 17936 | 203 |
1413059 | 1413059 | 2021-06-12 | Berkeley | South Carolina | 45015 | 17938 | 203 |
1409814 | 1409814 | 2021-06-11 | Berkeley | South Carolina | 45015 | 17938 | 203 |
1292986 | 1292986 | 2021-05-06 | Sumter | South Carolina | 45085 | 10402 | 203 |
1289740 | 1289740 | 2021-05-05 | Sumter | South Carolina | 45085 | 10397 | 203 |
1273471 | 1273471 | 2021-04-30 | Beaufort | South Carolina | 45013 | 16668 | 203 |
1270224 | 1270224 | 2021-04-29 | Beaufort | South Carolina | 45013 | 16653 | 203 |
1266977 | 1266977 | 2021-04-28 | Beaufort | South Carolina | 45013 | 16641 | 203 |
1263730 | 1263730 | 2021-04-27 | Beaufort | South Carolina | 45013 | 16631 | 203 |
1260483 | 1260483 | 2021-04-26 | Beaufort | South Carolina | 45013 | 16623 | 203 |
1257236 | 1257236 | 2021-04-25 | Beaufort | South Carolina | 45013 | 16611 | 203 |
935877 | 935877 | 2021-01-16 | York | South Carolina | 45091 | 19211 | 203 |
692472 | 692472 | 2020-11-02 | Florence | South Carolina | 45041 | 5747 | 203 |
689228 | 689228 | 2020-11-01 | Florence | South Carolina | 45041 | 5720 | 203 |
685983 | 685983 | 2020-10-31 | Florence | South Carolina | 45041 | 5683 | 203 |
673011 | 673011 | 2020-10-27 | Florence | South Carolina | 45041 | 5582 | 203 |
669752 | 669752 | 2020-10-26 | Anderson | South Carolina | 45007 | 5622 | 203 |
666536 | 666536 | 2020-10-25 | Lexington | South Carolina | 45063 | 8796 | 203 |
663291 | 663291 | 2020-10-24 | Lexington | South Carolina | 45063 | 8722 | 203 |
608135 | 608135 | 2020-10-07 | Horry | South Carolina | 45051 | 10863 | 203 |
595164 | 595164 | 2020-10-03 | Horry | South Carolina | 45051 | 10574 | 203 |
507751 | 507751 | 2020-09-06 | Richland | South Carolina | 45079 | 12243 | 203 |
504519 | 504519 | 2020-09-05 | Richland | South Carolina | 45079 | 12152 | 203 |
423744 | 423744 | 2020-08-11 | Charleston | South Carolina | 45019 | 12454 | 203 |
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);