ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
129 rows where deaths = 62 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 30
county 30
- Saluda 29
- Lancaster 15
- Newberry 10
- Marlboro 9
- Barnwell 7
- Laurens 7
- Cherokee 6
- Clarendon 5
- Bamberg 4
- Edgefield 4
- Chester 3
- Fairfield 3
- Kershaw 3
- Oconee 3
- Richland 3
- Abbeville 2
- Jasper 2
- Lee 2
- Aiken 1
- Anderson 1
- Beaufort 1
- Chesterfield 1
- Darlington 1
- Dillon 1
- Dorchester 1
- Greenville 1
- Horry 1
- Lexington 1
- Spartanburg 1
- York 1
state 1
- South Carolina · 129 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2196131 | 2196131 | 2022-02-08 | Abbeville | South Carolina | 45001 | 6434 | 62 |
2192877 | 2192877 | 2022-02-07 | Abbeville | South Carolina | 45001 | 6421 | 62 |
2189641 | 2189641 | 2022-02-06 | Edgefield | South Carolina | 45037 | 6336 | 62 |
2186388 | 2186388 | 2022-02-05 | Edgefield | South Carolina | 45037 | 6336 | 62 |
2183136 | 2183136 | 2022-02-04 | Edgefield | South Carolina | 45037 | 6336 | 62 |
2179884 | 2179884 | 2022-02-03 | Edgefield | South Carolina | 45037 | 6289 | 62 |
2134353 | 2134353 | 2022-01-20 | Saluda | South Carolina | 45081 | 3468 | 62 |
2131101 | 2131101 | 2022-01-19 | Saluda | South Carolina | 45081 | 3443 | 62 |
2127847 | 2127847 | 2022-01-18 | Saluda | South Carolina | 45081 | 3414 | 62 |
2124595 | 2124595 | 2022-01-17 | Saluda | South Carolina | 45081 | 3152 | 62 |
2121343 | 2121343 | 2022-01-16 | Saluda | South Carolina | 45081 | 3152 | 62 |
2118091 | 2118091 | 2022-01-15 | Saluda | South Carolina | 45081 | 3152 | 62 |
2114840 | 2114840 | 2022-01-14 | Saluda | South Carolina | 45081 | 3152 | 62 |
2111588 | 2111588 | 2022-01-13 | Saluda | South Carolina | 45081 | 3076 | 62 |
2108336 | 2108336 | 2022-01-12 | Saluda | South Carolina | 45081 | 3021 | 62 |
2105085 | 2105085 | 2022-01-11 | Saluda | South Carolina | 45081 | 2997 | 62 |
2101834 | 2101834 | 2022-01-10 | Saluda | South Carolina | 45081 | 2969 | 62 |
2098583 | 2098583 | 2022-01-09 | Saluda | South Carolina | 45081 | 2847 | 62 |
2095331 | 2095331 | 2022-01-08 | Saluda | South Carolina | 45081 | 2847 | 62 |
2092079 | 2092079 | 2022-01-07 | Saluda | South Carolina | 45081 | 2847 | 62 |
2088827 | 2088827 | 2022-01-06 | Saluda | South Carolina | 45081 | 2823 | 62 |
2085576 | 2085576 | 2022-01-05 | Saluda | South Carolina | 45081 | 2768 | 62 |
2082324 | 2082324 | 2022-01-04 | Saluda | South Carolina | 45081 | 2755 | 62 |
2079072 | 2079072 | 2022-01-03 | Saluda | South Carolina | 45081 | 2688 | 62 |
2075821 | 2075821 | 2022-01-02 | Saluda | South Carolina | 45081 | 2688 | 62 |
2072570 | 2072570 | 2022-01-01 | Saluda | South Carolina | 45081 | 2688 | 62 |
2069319 | 2069319 | 2021-12-31 | Saluda | South Carolina | 45081 | 2688 | 62 |
2066068 | 2066068 | 2021-12-30 | Saluda | South Carolina | 45081 | 2672 | 62 |
2062818 | 2062818 | 2021-12-29 | Saluda | South Carolina | 45081 | 2663 | 62 |
2059568 | 2059568 | 2021-12-28 | Saluda | South Carolina | 45081 | 2645 | 62 |
2056319 | 2056319 | 2021-12-27 | Saluda | South Carolina | 45081 | 2645 | 62 |
2053070 | 2053070 | 2021-12-26 | Saluda | South Carolina | 45081 | 2645 | 62 |
2049820 | 2049820 | 2021-12-25 | Saluda | South Carolina | 45081 | 2645 | 62 |
2046570 | 2046570 | 2021-12-24 | Saluda | South Carolina | 45081 | 2645 | 62 |
2043320 | 2043320 | 2021-12-23 | Saluda | South Carolina | 45081 | 2645 | 62 |
1780047 | 1780047 | 2021-10-03 | Bamberg | South Carolina | 45009 | 2081 | 62 |
1776797 | 1776797 | 2021-10-02 | Bamberg | South Carolina | 45009 | 2081 | 62 |
1773547 | 1773547 | 2021-10-01 | Bamberg | South Carolina | 45009 | 2081 | 62 |
1770297 | 1770297 | 2021-09-30 | Bamberg | South Carolina | 45009 | 2077 | 62 |
1721583 | 1721583 | 2021-09-15 | Jasper | South Carolina | 45053 | 3659 | 62 |
1718335 | 1718335 | 2021-09-14 | Jasper | South Carolina | 45053 | 3648 | 62 |
1672836 | 1672836 | 2021-08-31 | Barnwell | South Carolina | 45011 | 3216 | 62 |
1672864 | 1672864 | 2021-08-31 | Marlboro | South Carolina | 45069 | 4070 | 62 |
1669588 | 1669588 | 2021-08-30 | Barnwell | South Carolina | 45011 | 3169 | 62 |
1669616 | 1669616 | 2021-08-30 | Marlboro | South Carolina | 45069 | 4056 | 62 |
1666341 | 1666341 | 2021-08-29 | Barnwell | South Carolina | 45011 | 3085 | 62 |
1663093 | 1663093 | 2021-08-28 | Barnwell | South Carolina | 45011 | 3085 | 62 |
1659845 | 1659845 | 2021-08-27 | Barnwell | South Carolina | 45011 | 3085 | 62 |
1656596 | 1656596 | 2021-08-26 | Barnwell | South Carolina | 45011 | 3059 | 62 |
1653349 | 1653349 | 2021-08-25 | Barnwell | South Carolina | 45011 | 3025 | 62 |
1529946 | 1529946 | 2021-07-18 | Marlboro | South Carolina | 45069 | 3531 | 62 |
1526699 | 1526699 | 2021-07-17 | Marlboro | South Carolina | 45069 | 3531 | 62 |
1523452 | 1523452 | 2021-07-16 | Marlboro | South Carolina | 45069 | 3531 | 62 |
1520204 | 1520204 | 2021-07-15 | Marlboro | South Carolina | 45069 | 3527 | 62 |
1516956 | 1516956 | 2021-07-14 | Marlboro | South Carolina | 45069 | 3525 | 62 |
1513709 | 1513709 | 2021-07-13 | Marlboro | South Carolina | 45069 | 3525 | 62 |
1510463 | 1510463 | 2021-07-12 | Marlboro | South Carolina | 45069 | 3524 | 62 |
1335179 | 1335179 | 2021-05-19 | Lee | South Carolina | 45061 | 1922 | 62 |
1331932 | 1331932 | 2021-05-18 | Lee | South Carolina | 45061 | 1922 | 62 |
1042946 | 1042946 | 2021-02-18 | Chester | South Carolina | 45023 | 3506 | 62 |
1039701 | 1039701 | 2021-02-17 | Chester | South Carolina | 45023 | 3491 | 62 |
1036456 | 1036456 | 2021-02-16 | Chester | South Carolina | 45023 | 3474 | 62 |
997517 | 997517 | 2021-02-04 | Fairfield | South Carolina | 45039 | 1911 | 62 |
994271 | 994271 | 2021-02-03 | Fairfield | South Carolina | 45039 | 1901 | 62 |
991025 | 991025 | 2021-02-02 | Fairfield | South Carolina | 45039 | 1893 | 62 |
900151 | 900151 | 2021-01-05 | Dillon | South Carolina | 45033 | 2576 | 62 |
896902 | 896902 | 2021-01-04 | Chesterfield | South Carolina | 45025 | 2445 | 62 |
890434 | 890434 | 2021-01-02 | Oconee | South Carolina | 45073 | 5340 | 62 |
887187 | 887187 | 2021-01-01 | Oconee | South Carolina | 45073 | 5241 | 62 |
883942 | 883942 | 2020-12-31 | Oconee | South Carolina | 45073 | 5241 | 62 |
770331 | 770331 | 2020-11-26 | Cherokee | South Carolina | 45021 | 2030 | 62 |
770356 | 770356 | 2020-11-26 | Newberry | South Carolina | 45071 | 2067 | 62 |
767085 | 767085 | 2020-11-25 | Cherokee | South Carolina | 45021 | 2030 | 62 |
767110 | 767110 | 2020-11-25 | Newberry | South Carolina | 45071 | 2067 | 62 |
763840 | 763840 | 2020-11-24 | Cherokee | South Carolina | 45021 | 2019 | 62 |
763865 | 763865 | 2020-11-24 | Newberry | South Carolina | 45071 | 2057 | 62 |
760595 | 760595 | 2020-11-23 | Cherokee | South Carolina | 45021 | 2011 | 62 |
760612 | 760612 | 2020-11-23 | Kershaw | South Carolina | 45055 | 2868 | 62 |
760620 | 760620 | 2020-11-23 | Newberry | South Carolina | 45071 | 2046 | 62 |
757350 | 757350 | 2020-11-22 | Cherokee | South Carolina | 45021 | 1987 | 62 |
757367 | 757367 | 2020-11-22 | Kershaw | South Carolina | 45055 | 2861 | 62 |
757375 | 757375 | 2020-11-22 | Newberry | South Carolina | 45071 | 2040 | 62 |
754103 | 754103 | 2020-11-21 | Cherokee | South Carolina | 45021 | 1963 | 62 |
754120 | 754120 | 2020-11-21 | Kershaw | South Carolina | 45055 | 2853 | 62 |
754128 | 754128 | 2020-11-21 | Newberry | South Carolina | 45071 | 2032 | 62 |
750882 | 750882 | 2020-11-20 | Newberry | South Carolina | 45071 | 2025 | 62 |
747636 | 747636 | 2020-11-19 | Newberry | South Carolina | 45071 | 2004 | 62 |
744390 | 744390 | 2020-11-18 | Newberry | South Carolina | 45071 | 1988 | 62 |
741143 | 741143 | 2020-11-17 | Newberry | South Carolina | 45071 | 1951 | 62 |
724912 | 724912 | 2020-11-12 | Lancaster | South Carolina | 45057 | 2911 | 62 |
721669 | 721669 | 2020-11-11 | Lancaster | South Carolina | 45057 | 2890 | 62 |
718426 | 718426 | 2020-11-10 | Lancaster | South Carolina | 45057 | 2864 | 62 |
708695 | 708695 | 2020-11-07 | Lancaster | South Carolina | 45057 | 2782 | 62 |
705452 | 705452 | 2020-11-06 | Lancaster | South Carolina | 45057 | 2744 | 62 |
702209 | 702209 | 2020-11-05 | Lancaster | South Carolina | 45057 | 2726 | 62 |
702210 | 702210 | 2020-11-05 | Laurens | South Carolina | 45059 | 2013 | 62 |
698965 | 698965 | 2020-11-04 | Lancaster | South Carolina | 45057 | 2717 | 62 |
698966 | 698966 | 2020-11-04 | Laurens | South Carolina | 45059 | 1994 | 62 |
695722 | 695722 | 2020-11-03 | Lancaster | South Carolina | 45057 | 2693 | 62 |
695723 | 695723 | 2020-11-03 | Laurens | South Carolina | 45059 | 1982 | 62 |
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);