ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36,091 rows where state = "South Carolina" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
- 45019 799
- 45055 799
- 45083 797
- 45057 794
- 45013 791
- 45063 791
- 45007 790
- 45045 790
- 45051 790
- 45039 789
- 45017 788
- 45079 788
- 45091 788
- 45061 787
- 45001 786
- 45035 786
- 45081 786
- 45003 785
- 45015 785
- 45027 785
- 45031 785
- 45041 785
- 45075 785
- 45077 785
- 45085 785
- 45033 784
- 45037 784
- 45047 784
- 45053 784
- 45069 784
- …
county >30
- Charleston 799
- Kershaw 799
- Spartanburg 797
- Lancaster 794
- Beaufort 791
- Lexington 791
- Anderson 790
- Greenville 790
- Horry 790
- Fairfield 789
- Calhoun 788
- Richland 788
- York 788
- Lee 787
- Abbeville 786
- Dorchester 786
- Saluda 786
- Aiken 785
- Berkeley 785
- Clarendon 785
- Darlington 785
- Florence 785
- Orangeburg 785
- Pickens 785
- Sumter 785
- Dillon 784
- Edgefield 784
- Greenwood 784
- Jasper 784
- Marlboro 784
- …
state 1
- South Carolina · 36,091 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5001 | 5001 | 2020-03-19 | Abbeville | South Carolina | 45001 | 1 | 0 |
5874 | 5874 | 2020-03-20 | Abbeville | South Carolina | 45001 | 1 | 0 |
6878 | 6878 | 2020-03-21 | Abbeville | South Carolina | 45001 | 1 | 0 |
7998 | 7998 | 2020-03-22 | Abbeville | South Carolina | 45001 | 1 | 0 |
9209 | 9209 | 2020-03-23 | Abbeville | South Carolina | 45001 | 1 | 0 |
10534 | 10534 | 2020-03-24 | Abbeville | South Carolina | 45001 | 1 | 0 |
12005 | 12005 | 2020-03-25 | Abbeville | South Carolina | 45001 | 3 | 0 |
13627 | 13627 | 2020-03-26 | Abbeville | South Carolina | 45001 | 4 | 0 |
15374 | 15374 | 2020-03-27 | Abbeville | South Carolina | 45001 | 4 | 0 |
17228 | 17228 | 2020-03-28 | Abbeville | South Carolina | 45001 | 4 | 0 |
19168 | 19168 | 2020-03-29 | Abbeville | South Carolina | 45001 | 4 | 0 |
21219 | 21219 | 2020-03-30 | Abbeville | South Carolina | 45001 | 3 | 0 |
23356 | 23356 | 2020-03-31 | Abbeville | South Carolina | 45001 | 4 | 0 |
25553 | 25553 | 2020-04-01 | Abbeville | South Carolina | 45001 | 4 | 0 |
27826 | 27826 | 2020-04-02 | Abbeville | South Carolina | 45001 | 6 | 0 |
30161 | 30161 | 2020-04-03 | Abbeville | South Carolina | 45001 | 6 | 0 |
32552 | 32552 | 2020-04-04 | Abbeville | South Carolina | 45001 | 6 | 0 |
34988 | 34988 | 2020-04-05 | Abbeville | South Carolina | 45001 | 6 | 0 |
37463 | 37463 | 2020-04-06 | Abbeville | South Carolina | 45001 | 6 | 0 |
39986 | 39986 | 2020-04-07 | Abbeville | South Carolina | 45001 | 5 | 0 |
42546 | 42546 | 2020-04-08 | Abbeville | South Carolina | 45001 | 6 | 0 |
45132 | 45132 | 2020-04-09 | Abbeville | South Carolina | 45001 | 7 | 0 |
47749 | 47749 | 2020-04-10 | Abbeville | South Carolina | 45001 | 7 | 0 |
50406 | 50406 | 2020-04-11 | Abbeville | South Carolina | 45001 | 9 | 0 |
53079 | 53079 | 2020-04-12 | Abbeville | South Carolina | 45001 | 9 | 0 |
55764 | 55764 | 2020-04-13 | Abbeville | South Carolina | 45001 | 9 | 0 |
58467 | 58467 | 2020-04-14 | Abbeville | South Carolina | 45001 | 9 | 0 |
61182 | 61182 | 2020-04-15 | Abbeville | South Carolina | 45001 | 10 | 0 |
63908 | 63908 | 2020-04-16 | Abbeville | South Carolina | 45001 | 10 | 0 |
66654 | 66654 | 2020-04-17 | Abbeville | South Carolina | 45001 | 10 | 0 |
69412 | 69412 | 2020-04-18 | Abbeville | South Carolina | 45001 | 15 | 0 |
72179 | 72179 | 2020-04-19 | Abbeville | South Carolina | 45001 | 17 | 0 |
74954 | 74954 | 2020-04-20 | Abbeville | South Carolina | 45001 | 17 | 0 |
77736 | 77736 | 2020-04-21 | Abbeville | South Carolina | 45001 | 18 | 0 |
80526 | 80526 | 2020-04-22 | Abbeville | South Carolina | 45001 | 22 | 0 |
83325 | 83325 | 2020-04-23 | Abbeville | South Carolina | 45001 | 23 | 0 |
86129 | 86129 | 2020-04-24 | Abbeville | South Carolina | 45001 | 24 | 0 |
88943 | 88943 | 2020-04-25 | Abbeville | South Carolina | 45001 | 24 | 0 |
91759 | 91759 | 2020-04-26 | Abbeville | South Carolina | 45001 | 27 | 0 |
94586 | 94586 | 2020-04-27 | Abbeville | South Carolina | 45001 | 29 | 0 |
97425 | 97425 | 2020-04-28 | Abbeville | South Carolina | 45001 | 29 | 0 |
100274 | 100274 | 2020-04-29 | Abbeville | South Carolina | 45001 | 29 | 0 |
103127 | 103127 | 2020-04-30 | Abbeville | South Carolina | 45001 | 31 | 0 |
105990 | 105990 | 2020-05-01 | Abbeville | South Carolina | 45001 | 31 | 0 |
108857 | 108857 | 2020-05-02 | Abbeville | South Carolina | 45001 | 31 | 0 |
111731 | 111731 | 2020-05-03 | Abbeville | South Carolina | 45001 | 33 | 0 |
114613 | 114613 | 2020-05-04 | Abbeville | South Carolina | 45001 | 33 | 0 |
117569 | 117569 | 2020-05-05 | Abbeville | South Carolina | 45001 | 33 | 0 |
120531 | 120531 | 2020-05-06 | Abbeville | South Carolina | 45001 | 33 | 0 |
123509 | 123509 | 2020-05-07 | Abbeville | South Carolina | 45001 | 34 | 0 |
126492 | 126492 | 2020-05-08 | Abbeville | South Carolina | 45001 | 34 | 0 |
129481 | 129481 | 2020-05-09 | Abbeville | South Carolina | 45001 | 34 | 0 |
132470 | 132470 | 2020-05-10 | Abbeville | South Carolina | 45001 | 34 | 0 |
135461 | 135461 | 2020-05-11 | Abbeville | South Carolina | 45001 | 34 | 0 |
138451 | 138451 | 2020-05-12 | Abbeville | South Carolina | 45001 | 34 | 0 |
141447 | 141447 | 2020-05-13 | Abbeville | South Carolina | 45001 | 34 | 0 |
144443 | 144443 | 2020-05-14 | Abbeville | South Carolina | 45001 | 34 | 0 |
147444 | 147444 | 2020-05-15 | Abbeville | South Carolina | 45001 | 34 | 0 |
150452 | 150452 | 2020-05-16 | Abbeville | South Carolina | 45001 | 34 | 0 |
153463 | 153463 | 2020-05-17 | Abbeville | South Carolina | 45001 | 35 | 0 |
156480 | 156480 | 2020-05-18 | Abbeville | South Carolina | 45001 | 35 | 0 |
159501 | 159501 | 2020-05-19 | Abbeville | South Carolina | 45001 | 36 | 0 |
162528 | 162528 | 2020-05-20 | Abbeville | South Carolina | 45001 | 36 | 0 |
165557 | 165557 | 2020-05-21 | Abbeville | South Carolina | 45001 | 36 | 0 |
168593 | 168593 | 2020-05-22 | Abbeville | South Carolina | 45001 | 36 | 0 |
171632 | 171632 | 2020-05-23 | Abbeville | South Carolina | 45001 | 35 | 0 |
174674 | 174674 | 2020-05-24 | Abbeville | South Carolina | 45001 | 35 | 0 |
177718 | 177718 | 2020-05-25 | Abbeville | South Carolina | 45001 | 35 | 0 |
180761 | 180761 | 2020-05-26 | Abbeville | South Carolina | 45001 | 35 | 0 |
183811 | 183811 | 2020-05-27 | Abbeville | South Carolina | 45001 | 35 | 0 |
186868 | 186868 | 2020-05-28 | Abbeville | South Carolina | 45001 | 37 | 0 |
189930 | 189930 | 2020-05-29 | Abbeville | South Carolina | 45001 | 39 | 0 |
192995 | 192995 | 2020-05-30 | Abbeville | South Carolina | 45001 | 39 | 0 |
196064 | 196064 | 2020-05-31 | Abbeville | South Carolina | 45001 | 42 | 0 |
199137 | 199137 | 2020-06-01 | Abbeville | South Carolina | 45001 | 44 | 0 |
202212 | 202212 | 2020-06-02 | Abbeville | South Carolina | 45001 | 46 | 0 |
205289 | 205289 | 2020-06-03 | Abbeville | South Carolina | 45001 | 46 | 0 |
208370 | 208370 | 2020-06-04 | Abbeville | South Carolina | 45001 | 47 | 0 |
211452 | 211452 | 2020-06-05 | Abbeville | South Carolina | 45001 | 47 | 0 |
214538 | 214538 | 2020-06-06 | Abbeville | South Carolina | 45001 | 49 | 0 |
217628 | 217628 | 2020-06-07 | Abbeville | South Carolina | 45001 | 51 | 0 |
220720 | 220720 | 2020-06-08 | Abbeville | South Carolina | 45001 | 58 | 0 |
223815 | 223815 | 2020-06-09 | Abbeville | South Carolina | 45001 | 60 | 0 |
226915 | 226915 | 2020-06-10 | Abbeville | South Carolina | 45001 | 60 | 0 |
230019 | 230019 | 2020-06-11 | Abbeville | South Carolina | 45001 | 63 | 0 |
233124 | 233124 | 2020-06-12 | Abbeville | South Carolina | 45001 | 62 | 0 |
236229 | 236229 | 2020-06-13 | Abbeville | South Carolina | 45001 | 63 | 0 |
239337 | 239337 | 2020-06-14 | Abbeville | South Carolina | 45001 | 67 | 0 |
242446 | 242446 | 2020-06-15 | Abbeville | South Carolina | 45001 | 70 | 0 |
245558 | 245558 | 2020-06-16 | Abbeville | South Carolina | 45001 | 73 | 0 |
248671 | 248671 | 2020-06-17 | Abbeville | South Carolina | 45001 | 73 | 0 |
251786 | 251786 | 2020-06-18 | Abbeville | South Carolina | 45001 | 73 | 0 |
254901 | 254901 | 2020-06-19 | Abbeville | South Carolina | 45001 | 73 | 0 |
258027 | 258027 | 2020-06-20 | Abbeville | South Carolina | 45001 | 86 | 0 |
261154 | 261154 | 2020-06-21 | Abbeville | South Carolina | 45001 | 88 | 0 |
264282 | 264282 | 2020-06-22 | Abbeville | South Carolina | 45001 | 87 | 0 |
267410 | 267410 | 2020-06-23 | Abbeville | South Carolina | 45001 | 86 | 0 |
270544 | 270544 | 2020-06-24 | Abbeville | South Carolina | 45001 | 91 | 0 |
273683 | 273683 | 2020-06-25 | Abbeville | South Carolina | 45001 | 99 | 0 |
276830 | 276830 | 2020-06-26 | Abbeville | South Carolina | 45001 | 100 | 0 |
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);