ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,132 rows where county = "Sumter" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
state 4
- Florida 787
- Georgia 785
- South Carolina 785
- Alabama 775
county 1
- Sumter · 3,132 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
3883 | 3883 | 2020-03-18 | Sumter | Florida | 12119 | 1 | 0 |
4552 | 4552 | 2020-03-19 | Sumter | Florida | 12119 | 2 | 0 |
5332 | 5332 | 2020-03-20 | Sumter | Florida | 12119 | 2 | 0 |
5381 | 5381 | 2020-03-20 | Sumter | Georgia | 13261 | 2 | 0 |
5897 | 5897 | 2020-03-20 | Sumter | South Carolina | 45085 | 1 | 0 |
6264 | 6264 | 2020-03-21 | Sumter | Florida | 12119 | 4 | 0 |
6315 | 6315 | 2020-03-21 | Sumter | Georgia | 13261 | 2 | 0 |
6907 | 6907 | 2020-03-21 | Sumter | South Carolina | 45085 | 3 | 0 |
7304 | 7304 | 2020-03-22 | Sumter | Florida | 12119 | 5 | 0 |
7361 | 7361 | 2020-03-22 | Sumter | Georgia | 13261 | 2 | 0 |
8028 | 8028 | 2020-03-22 | Sumter | South Carolina | 45085 | 3 | 0 |
8450 | 8450 | 2020-03-23 | Sumter | Florida | 12119 | 8 | 0 |
8514 | 8514 | 2020-03-23 | Sumter | Georgia | 13261 | 2 | 0 |
9242 | 9242 | 2020-03-23 | Sumter | South Carolina | 45085 | 4 | 0 |
9695 | 9695 | 2020-03-24 | Sumter | Florida | 12119 | 10 | 0 |
9775 | 9775 | 2020-03-24 | Sumter | Georgia | 13261 | 4 | 0 |
11070 | 11070 | 2020-03-25 | Sumter | Florida | 12119 | 18 | 0 |
11155 | 11155 | 2020-03-25 | Sumter | Georgia | 13261 | 5 | 0 |
12618 | 12618 | 2020-03-26 | Sumter | Florida | 12119 | 24 | 0 |
12707 | 12707 | 2020-03-26 | Sumter | Georgia | 13261 | 7 | 0 |
14288 | 14288 | 2020-03-27 | Sumter | Florida | 12119 | 29 | 0 |
14381 | 14381 | 2020-03-27 | Sumter | Georgia | 13261 | 10 | 0 |
16073 | 16073 | 2020-03-28 | Sumter | Florida | 12119 | 40 | 0 |
17966 | 17966 | 2020-03-29 | Sumter | Florida | 12119 | 45 | 0 |
19707 | 19707 | 2020-03-30 | Sumter | Alabama | 1119 | 1 | 0 |
19947 | 19947 | 2020-03-30 | Sumter | Florida | 12119 | 47 | 0 |
21779 | 21779 | 2020-03-31 | Sumter | Alabama | 1119 | 1 | 0 |
22025 | 22025 | 2020-03-31 | Sumter | Florida | 12119 | 51 | 0 |
23935 | 23935 | 2020-04-01 | Sumter | Alabama | 1119 | 3 | 0 |
24188 | 24188 | 2020-04-01 | Sumter | Florida | 12119 | 57 | 0 |
26157 | 26157 | 2020-04-02 | Sumter | Alabama | 1119 | 4 | 0 |
28454 | 28454 | 2020-04-03 | Sumter | Alabama | 1119 | 7 | 0 |
30811 | 30811 | 2020-04-04 | Sumter | Alabama | 1119 | 6 | 0 |
33215 | 33215 | 2020-04-05 | Sumter | Alabama | 1119 | 7 | 0 |
35654 | 35654 | 2020-04-06 | Sumter | Alabama | 1119 | 10 | 0 |
38142 | 38142 | 2020-04-07 | Sumter | Alabama | 1119 | 15 | 0 |
40684 | 40684 | 2020-04-08 | Sumter | Alabama | 1119 | 17 | 0 |
43258 | 43258 | 2020-04-09 | Sumter | Alabama | 1119 | 17 | 0 |
45856 | 45856 | 2020-04-10 | Sumter | Alabama | 1119 | 18 | 0 |
48485 | 48485 | 2020-04-11 | Sumter | Alabama | 1119 | 19 | 0 |
51147 | 51147 | 2020-04-12 | Sumter | Alabama | 1119 | 20 | 0 |
53825 | 53825 | 2020-04-13 | Sumter | Alabama | 1119 | 23 | 0 |
56517 | 56517 | 2020-04-14 | Sumter | Alabama | 1119 | 26 | 0 |
59225 | 59225 | 2020-04-15 | Sumter | Alabama | 1119 | 30 | 0 |
61943 | 61943 | 2020-04-16 | Sumter | Alabama | 1119 | 31 | 0 |
64676 | 64676 | 2020-04-17 | Sumter | Alabama | 1119 | 33 | 0 |
67424 | 67424 | 2020-04-18 | Sumter | Alabama | 1119 | 35 | 0 |
70186 | 70186 | 2020-04-19 | Sumter | Alabama | 1119 | 36 | 0 |
72955 | 72955 | 2020-04-20 | Sumter | Alabama | 1119 | 40 | 0 |
75731 | 75731 | 2020-04-21 | Sumter | Alabama | 1119 | 44 | 0 |
10568 | 10568 | 2020-03-24 | Sumter | South Carolina | 45085 | 8 | 1 |
12040 | 12040 | 2020-03-25 | Sumter | South Carolina | 45085 | 10 | 1 |
16170 | 16170 | 2020-03-28 | Sumter | Georgia | 13261 | 13 | 1 |
18067 | 18067 | 2020-03-29 | Sumter | Georgia | 13261 | 15 | 1 |
78514 | 78514 | 2020-04-22 | Sumter | Alabama | 1119 | 46 | 1 |
81307 | 81307 | 2020-04-23 | Sumter | Alabama | 1119 | 47 | 1 |
84108 | 84108 | 2020-04-24 | Sumter | Alabama | 1119 | 51 | 1 |
86916 | 86916 | 2020-04-25 | Sumter | Alabama | 1119 | 51 | 1 |
13662 | 13662 | 2020-03-26 | Sumter | South Carolina | 45085 | 10 | 2 |
15409 | 15409 | 2020-03-27 | Sumter | South Carolina | 45085 | 10 | 2 |
17264 | 17264 | 2020-03-28 | Sumter | South Carolina | 45085 | 24 | 2 |
19204 | 19204 | 2020-03-29 | Sumter | South Carolina | 45085 | 30 | 2 |
20061 | 20061 | 2020-03-30 | Sumter | Georgia | 13261 | 17 | 2 |
21256 | 21256 | 2020-03-30 | Sumter | South Carolina | 45085 | 34 | 2 |
22146 | 22146 | 2020-03-31 | Sumter | Georgia | 13261 | 35 | 2 |
23394 | 23394 | 2020-03-31 | Sumter | South Carolina | 45085 | 39 | 2 |
25592 | 25592 | 2020-04-01 | Sumter | South Carolina | 45085 | 48 | 2 |
26418 | 26418 | 2020-04-02 | Sumter | Florida | 12119 | 66 | 2 |
89732 | 89732 | 2020-04-26 | Sumter | Alabama | 1119 | 53 | 2 |
92550 | 92550 | 2020-04-27 | Sumter | Alabama | 1119 | 55 | 2 |
95380 | 95380 | 2020-04-28 | Sumter | Alabama | 1119 | 55 | 2 |
98225 | 98225 | 2020-04-29 | Sumter | Alabama | 1119 | 56 | 2 |
101075 | 101075 | 2020-04-30 | Sumter | Alabama | 1119 | 64 | 2 |
24311 | 24311 | 2020-04-01 | Sumter | Georgia | 13261 | 38 | 3 |
26542 | 26542 | 2020-04-02 | Sumter | Georgia | 13261 | 48 | 3 |
27868 | 27868 | 2020-04-02 | Sumter | South Carolina | 45085 | 66 | 3 |
28721 | 28721 | 2020-04-03 | Sumter | Florida | 12119 | 68 | 3 |
30203 | 30203 | 2020-04-03 | Sumter | South Carolina | 45085 | 75 | 3 |
31081 | 31081 | 2020-04-04 | Sumter | Florida | 12119 | 73 | 3 |
32594 | 32594 | 2020-04-04 | Sumter | South Carolina | 45085 | 79 | 3 |
33487 | 33487 | 2020-04-05 | Sumter | Florida | 12119 | 75 | 3 |
35030 | 35030 | 2020-04-05 | Sumter | South Carolina | 45085 | 80 | 3 |
37505 | 37505 | 2020-04-06 | Sumter | South Carolina | 45085 | 90 | 3 |
40028 | 40028 | 2020-04-07 | Sumter | South Carolina | 45085 | 105 | 3 |
42588 | 42588 | 2020-04-08 | Sumter | South Carolina | 45085 | 117 | 3 |
45174 | 45174 | 2020-04-09 | Sumter | South Carolina | 45085 | 126 | 3 |
47791 | 47791 | 2020-04-10 | Sumter | South Carolina | 45085 | 142 | 3 |
103930 | 103930 | 2020-05-01 | Sumter | Alabama | 1119 | 68 | 3 |
106795 | 106795 | 2020-05-02 | Sumter | Alabama | 1119 | 72 | 3 |
109664 | 109664 | 2020-05-03 | Sumter | Alabama | 1119 | 77 | 3 |
112539 | 112539 | 2020-05-04 | Sumter | Alabama | 1119 | 81 | 3 |
115422 | 115422 | 2020-05-05 | Sumter | Alabama | 1119 | 85 | 3 |
28848 | 28848 | 2020-04-03 | Sumter | Georgia | 13261 | 67 | 4 |
31208 | 31208 | 2020-04-04 | Sumter | Georgia | 13261 | 83 | 4 |
33615 | 33615 | 2020-04-05 | Sumter | Georgia | 13261 | 83 | 4 |
36065 | 36065 | 2020-04-06 | Sumter | Georgia | 13261 | 90 | 4 |
50448 | 50448 | 2020-04-11 | Sumter | South Carolina | 45085 | 146 | 4 |
53121 | 53121 | 2020-04-12 | Sumter | South Carolina | 45085 | 148 | 4 |
55806 | 55806 | 2020-04-13 | Sumter | South Carolina | 45085 | 152 | 4 |
58509 | 58509 | 2020-04-14 | Sumter | South Carolina | 45085 | 156 | 4 |
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);