ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
186 rows where cases = 1 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
fips >30
county >30
- Dillon 19
- Saluda 14
- Spartanburg 13
- Calhoun 12
- Charleston 11
- Edgefield 8
- Marlboro 8
- Fairfield 7
- Newberry 7
- Abbeville 6
- Chester 5
- Colleton 5
- Lee 5
- Marion 5
- Pickens 5
- Union 5
- Aiken 4
- Dorchester 4
- McCormick 4
- York 4
- Allendale 3
- Clarendon 3
- Florence 3
- Hampton 3
- Jasper 3
- Williamsburg 3
- Barnwell 2
- Berkeley 2
- Cherokee 2
- Greenville 2
- …
state 1
- South Carolina · 186 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
42562 | 42562 | 2020-04-08 | Dillon | South Carolina | 45033 | 1 | 0 |
40002 | 40002 | 2020-04-07 | Dillon | South Carolina | 45033 | 1 | 0 |
37479 | 37479 | 2020-04-06 | Dillon | South Carolina | 45033 | 1 | 0 |
35004 | 35004 | 2020-04-05 | Dillon | South Carolina | 45033 | 1 | 0 |
35022 | 35022 | 2020-04-05 | McCormick | South Carolina | 45065 | 1 | 0 |
32568 | 32568 | 2020-04-04 | Dillon | South Carolina | 45033 | 1 | 0 |
32576 | 32576 | 2020-04-04 | Hampton | South Carolina | 45049 | 1 | 0 |
32586 | 32586 | 2020-04-04 | McCormick | South Carolina | 45065 | 1 | 0 |
30163 | 30163 | 2020-04-03 | Allendale | South Carolina | 45005 | 1 | 0 |
30171 | 30171 | 2020-04-03 | Cherokee | South Carolina | 45021 | 1 | 0 |
30177 | 30177 | 2020-04-03 | Dillon | South Carolina | 45033 | 1 | 0 |
30185 | 30185 | 2020-04-03 | Hampton | South Carolina | 45049 | 1 | 0 |
30195 | 30195 | 2020-04-03 | McCormick | South Carolina | 45065 | 1 | 0 |
27828 | 27828 | 2020-04-02 | Allendale | South Carolina | 45005 | 1 | 0 |
27836 | 27836 | 2020-04-02 | Cherokee | South Carolina | 45021 | 1 | 0 |
27842 | 27842 | 2020-04-02 | Dillon | South Carolina | 45033 | 1 | 0 |
27850 | 27850 | 2020-04-02 | Hampton | South Carolina | 45049 | 1 | 0 |
27860 | 27860 | 2020-04-02 | McCormick | South Carolina | 45065 | 1 | 0 |
25555 | 25555 | 2020-04-01 | Allendale | South Carolina | 45005 | 1 | 0 |
25568 | 25568 | 2020-04-01 | Dillon | South Carolina | 45033 | 1 | 0 |
25590 | 25590 | 2020-04-01 | Saluda | South Carolina | 45081 | 1 | 0 |
23360 | 23360 | 2020-03-31 | Barnwell | South Carolina | 45011 | 1 | 0 |
23370 | 23370 | 2020-03-31 | Dillon | South Carolina | 45033 | 1 | 0 |
23392 | 23392 | 2020-03-31 | Saluda | South Carolina | 45081 | 1 | 0 |
21222 | 21222 | 2020-03-30 | Barnwell | South Carolina | 45011 | 1 | 0 |
21232 | 21232 | 2020-03-30 | Dillon | South Carolina | 45033 | 1 | 0 |
21254 | 21254 | 2020-03-30 | Saluda | South Carolina | 45081 | 1 | 0 |
19180 | 19180 | 2020-03-29 | Dillon | South Carolina | 45033 | 1 | 0 |
19195 | 19195 | 2020-03-29 | Marion | South Carolina | 45067 | 1 | 0 |
19202 | 19202 | 2020-03-29 | Saluda | South Carolina | 45081 | 1 | 0 |
19205 | 19205 | 2020-03-29 | Union | South Carolina | 45087 | 1 | 0 |
17233 | 17233 | 2020-03-28 | Calhoun | South Carolina | 45017 | 1 | 0 |
17240 | 17240 | 2020-03-28 | Dillon | South Carolina | 45033 | 1 | 0 |
17242 | 17242 | 2020-03-28 | Edgefield | South Carolina | 45037 | 1 | 0 |
17255 | 17255 | 2020-03-28 | Marion | South Carolina | 45067 | 1 | 0 |
17256 | 17256 | 2020-03-28 | Marlboro | South Carolina | 45069 | 1 | 0 |
17262 | 17262 | 2020-03-28 | Saluda | South Carolina | 45081 | 1 | 0 |
17265 | 17265 | 2020-03-28 | Union | South Carolina | 45087 | 1 | 0 |
15379 | 15379 | 2020-03-27 | Calhoun | South Carolina | 45017 | 1 | 0 |
15381 | 15381 | 2020-03-27 | Chester | South Carolina | 45023 | 1 | 0 |
15386 | 15386 | 2020-03-27 | Dillon | South Carolina | 45033 | 1 | 0 |
15388 | 15388 | 2020-03-27 | Edgefield | South Carolina | 45037 | 1 | 0 |
15400 | 15400 | 2020-03-27 | Marion | South Carolina | 45067 | 1 | 0 |
15401 | 15401 | 2020-03-27 | Marlboro | South Carolina | 45069 | 1 | 0 |
15402 | 15402 | 2020-03-27 | Newberry | South Carolina | 45071 | 1 | 0 |
15407 | 15407 | 2020-03-27 | Saluda | South Carolina | 45081 | 1 | 0 |
15410 | 15410 | 2020-03-27 | Union | South Carolina | 45087 | 1 | 0 |
15411 | 15411 | 2020-03-27 | Williamsburg | South Carolina | 45089 | 1 | 0 |
13632 | 13632 | 2020-03-26 | Calhoun | South Carolina | 45017 | 1 | 0 |
13634 | 13634 | 2020-03-26 | Chester | South Carolina | 45023 | 1 | 0 |
13637 | 13637 | 2020-03-26 | Colleton | South Carolina | 45029 | 1 | 0 |
13639 | 13639 | 2020-03-26 | Dillon | South Carolina | 45033 | 1 | 0 |
13641 | 13641 | 2020-03-26 | Edgefield | South Carolina | 45037 | 1 | 0 |
13653 | 13653 | 2020-03-26 | Marion | South Carolina | 45067 | 1 | 0 |
13654 | 13654 | 2020-03-26 | Marlboro | South Carolina | 45069 | 1 | 0 |
13655 | 13655 | 2020-03-26 | Newberry | South Carolina | 45071 | 1 | 0 |
13660 | 13660 | 2020-03-26 | Saluda | South Carolina | 45081 | 1 | 0 |
13663 | 13663 | 2020-03-26 | Union | South Carolina | 45087 | 1 | 0 |
13664 | 13664 | 2020-03-26 | Williamsburg | South Carolina | 45089 | 1 | 0 |
12010 | 12010 | 2020-03-25 | Calhoun | South Carolina | 45017 | 1 | 0 |
12012 | 12012 | 2020-03-25 | Chester | South Carolina | 45023 | 1 | 0 |
12015 | 12015 | 2020-03-25 | Colleton | South Carolina | 45029 | 1 | 0 |
12017 | 12017 | 2020-03-25 | Dillon | South Carolina | 45033 | 1 | 0 |
12019 | 12019 | 2020-03-25 | Edgefield | South Carolina | 45037 | 1 | 0 |
12031 | 12031 | 2020-03-25 | Marion | South Carolina | 45067 | 1 | 0 |
12032 | 12032 | 2020-03-25 | Marlboro | South Carolina | 45069 | 1 | 0 |
12033 | 12033 | 2020-03-25 | Newberry | South Carolina | 45071 | 1 | 0 |
12038 | 12038 | 2020-03-25 | Saluda | South Carolina | 45081 | 1 | 0 |
12041 | 12041 | 2020-03-25 | Union | South Carolina | 45087 | 1 | 0 |
12042 | 12042 | 2020-03-25 | Williamsburg | South Carolina | 45089 | 1 | 0 |
10534 | 10534 | 2020-03-24 | Abbeville | South Carolina | 45001 | 1 | 0 |
10539 | 10539 | 2020-03-24 | Calhoun | South Carolina | 45017 | 1 | 0 |
10541 | 10541 | 2020-03-24 | Chester | South Carolina | 45023 | 1 | 0 |
10542 | 10542 | 2020-03-24 | Chesterfield | South Carolina | 45025 | 1 | 0 |
10544 | 10544 | 2020-03-24 | Colleton | South Carolina | 45029 | 1 | 0 |
10546 | 10546 | 2020-03-24 | Dillon | South Carolina | 45033 | 1 | 0 |
10548 | 10548 | 2020-03-24 | Edgefield | South Carolina | 45037 | 1 | 0 |
10560 | 10560 | 2020-03-24 | Marlboro | South Carolina | 45069 | 1 | 0 |
10561 | 10561 | 2020-03-24 | Newberry | South Carolina | 45071 | 1 | 0 |
10564 | 10564 | 2020-03-24 | Pickens | South Carolina | 45077 | 1 | 0 |
10566 | 10566 | 2020-03-24 | Saluda | South Carolina | 45081 | 1 | 0 |
9209 | 9209 | 2020-03-23 | Abbeville | South Carolina | 45001 | 1 | 0 |
9210 | 9210 | 2020-03-23 | Aiken | South Carolina | 45003 | 1 | 0 |
9214 | 9214 | 2020-03-23 | Calhoun | South Carolina | 45017 | 1 | 0 |
9216 | 9216 | 2020-03-23 | Chester | South Carolina | 45023 | 1 | 0 |
9218 | 9218 | 2020-03-23 | Colleton | South Carolina | 45029 | 1 | 0 |
9220 | 9220 | 2020-03-23 | Dillon | South Carolina | 45033 | 1 | 0 |
9222 | 9222 | 2020-03-23 | Edgefield | South Carolina | 45037 | 1 | 0 |
9229 | 9229 | 2020-03-23 | Jasper | South Carolina | 45053 | 1 | 0 |
9234 | 9234 | 2020-03-23 | Marlboro | South Carolina | 45069 | 1 | 0 |
9235 | 9235 | 2020-03-23 | Newberry | South Carolina | 45071 | 1 | 0 |
9238 | 9238 | 2020-03-23 | Pickens | South Carolina | 45077 | 1 | 0 |
9240 | 9240 | 2020-03-23 | Saluda | South Carolina | 45081 | 1 | 0 |
7998 | 7998 | 2020-03-22 | Abbeville | South Carolina | 45001 | 1 | 0 |
7999 | 7999 | 2020-03-22 | Aiken | South Carolina | 45003 | 1 | 0 |
8003 | 8003 | 2020-03-22 | Calhoun | South Carolina | 45017 | 1 | 0 |
8005 | 8005 | 2020-03-22 | Clarendon | South Carolina | 45027 | 1 | 0 |
8006 | 8006 | 2020-03-22 | Colleton | South Carolina | 45029 | 1 | 0 |
8008 | 8008 | 2020-03-22 | Dillon | South Carolina | 45033 | 1 | 0 |
8009 | 8009 | 2020-03-22 | Dorchester | South Carolina | 45035 | 1 | 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);