ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Colleton" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
8006 | 8006 | 2020-03-22 | Colleton | South Carolina | 45029 | 1 | 0 |
9218 | 9218 | 2020-03-23 | Colleton | South Carolina | 45029 | 1 | 0 |
10544 | 10544 | 2020-03-24 | Colleton | South Carolina | 45029 | 1 | 0 |
12015 | 12015 | 2020-03-25 | Colleton | South Carolina | 45029 | 1 | 0 |
13637 | 13637 | 2020-03-26 | Colleton | South Carolina | 45029 | 1 | 0 |
15384 | 15384 | 2020-03-27 | Colleton | South Carolina | 45029 | 2 | 0 |
17238 | 17238 | 2020-03-28 | Colleton | South Carolina | 45029 | 4 | 0 |
19178 | 19178 | 2020-03-29 | Colleton | South Carolina | 45029 | 4 | 0 |
21230 | 21230 | 2020-03-30 | Colleton | South Carolina | 45029 | 5 | 0 |
23368 | 23368 | 2020-03-31 | Colleton | South Carolina | 45029 | 5 | 0 |
25566 | 25566 | 2020-04-01 | Colleton | South Carolina | 45029 | 5 | 0 |
27840 | 27840 | 2020-04-02 | Colleton | South Carolina | 45029 | 6 | 0 |
30175 | 30175 | 2020-04-03 | Colleton | South Carolina | 45029 | 6 | 0 |
32566 | 32566 | 2020-04-04 | Colleton | South Carolina | 45029 | 9 | 0 |
35002 | 35002 | 2020-04-05 | Colleton | South Carolina | 45029 | 8 | 0 |
37477 | 37477 | 2020-04-06 | Colleton | South Carolina | 45029 | 10 | 0 |
40000 | 40000 | 2020-04-07 | Colleton | South Carolina | 45029 | 10 | 0 |
42560 | 42560 | 2020-04-08 | Colleton | South Carolina | 45029 | 12 | 0 |
45146 | 45146 | 2020-04-09 | Colleton | South Carolina | 45029 | 15 | 0 |
47763 | 47763 | 2020-04-10 | Colleton | South Carolina | 45029 | 15 | 0 |
50420 | 50420 | 2020-04-11 | Colleton | South Carolina | 45029 | 15 | 0 |
53093 | 53093 | 2020-04-12 | Colleton | South Carolina | 45029 | 16 | 0 |
55778 | 55778 | 2020-04-13 | Colleton | South Carolina | 45029 | 17 | 0 |
58481 | 58481 | 2020-04-14 | Colleton | South Carolina | 45029 | 18 | 0 |
61196 | 61196 | 2020-04-15 | Colleton | South Carolina | 45029 | 21 | 1 |
63922 | 63922 | 2020-04-16 | Colleton | South Carolina | 45029 | 21 | 1 |
66668 | 66668 | 2020-04-17 | Colleton | South Carolina | 45029 | 21 | 1 |
69426 | 69426 | 2020-04-18 | Colleton | South Carolina | 45029 | 23 | 1 |
72193 | 72193 | 2020-04-19 | Colleton | South Carolina | 45029 | 23 | 1 |
74968 | 74968 | 2020-04-20 | Colleton | South Carolina | 45029 | 23 | 1 |
77750 | 77750 | 2020-04-21 | Colleton | South Carolina | 45029 | 23 | 2 |
80540 | 80540 | 2020-04-22 | Colleton | South Carolina | 45029 | 23 | 2 |
83339 | 83339 | 2020-04-23 | Colleton | South Carolina | 45029 | 23 | 2 |
86143 | 86143 | 2020-04-24 | Colleton | South Carolina | 45029 | 24 | 2 |
88957 | 88957 | 2020-04-25 | Colleton | South Carolina | 45029 | 26 | 3 |
91773 | 91773 | 2020-04-26 | Colleton | South Carolina | 45029 | 26 | 4 |
94600 | 94600 | 2020-04-27 | Colleton | South Carolina | 45029 | 26 | 4 |
97439 | 97439 | 2020-04-28 | Colleton | South Carolina | 45029 | 26 | 4 |
100288 | 100288 | 2020-04-29 | Colleton | South Carolina | 45029 | 26 | 4 |
103141 | 103141 | 2020-04-30 | Colleton | South Carolina | 45029 | 27 | 4 |
106004 | 106004 | 2020-05-01 | Colleton | South Carolina | 45029 | 33 | 4 |
108871 | 108871 | 2020-05-02 | Colleton | South Carolina | 45029 | 32 | 4 |
111745 | 111745 | 2020-05-03 | Colleton | South Carolina | 45029 | 32 | 4 |
114627 | 114627 | 2020-05-04 | Colleton | South Carolina | 45029 | 32 | 4 |
117583 | 117583 | 2020-05-05 | Colleton | South Carolina | 45029 | 32 | 4 |
120545 | 120545 | 2020-05-06 | Colleton | South Carolina | 45029 | 32 | 4 |
123523 | 123523 | 2020-05-07 | Colleton | South Carolina | 45029 | 32 | 4 |
126506 | 126506 | 2020-05-08 | Colleton | South Carolina | 45029 | 32 | 4 |
129495 | 129495 | 2020-05-09 | Colleton | South Carolina | 45029 | 32 | 4 |
132484 | 132484 | 2020-05-10 | Colleton | South Carolina | 45029 | 32 | 4 |
135475 | 135475 | 2020-05-11 | Colleton | South Carolina | 45029 | 32 | 4 |
138465 | 138465 | 2020-05-12 | Colleton | South Carolina | 45029 | 32 | 4 |
141461 | 141461 | 2020-05-13 | Colleton | South Carolina | 45029 | 33 | 4 |
144457 | 144457 | 2020-05-14 | Colleton | South Carolina | 45029 | 41 | 4 |
147458 | 147458 | 2020-05-15 | Colleton | South Carolina | 45029 | 48 | 4 |
150466 | 150466 | 2020-05-16 | Colleton | South Carolina | 45029 | 51 | 4 |
153477 | 153477 | 2020-05-17 | Colleton | South Carolina | 45029 | 52 | 4 |
156494 | 156494 | 2020-05-18 | Colleton | South Carolina | 45029 | 58 | 4 |
159515 | 159515 | 2020-05-19 | Colleton | South Carolina | 45029 | 58 | 4 |
162542 | 162542 | 2020-05-20 | Colleton | South Carolina | 45029 | 60 | 8 |
165571 | 165571 | 2020-05-21 | Colleton | South Carolina | 45029 | 63 | 8 |
168607 | 168607 | 2020-05-22 | Colleton | South Carolina | 45029 | 66 | 8 |
171646 | 171646 | 2020-05-23 | Colleton | South Carolina | 45029 | 69 | 8 |
174688 | 174688 | 2020-05-24 | Colleton | South Carolina | 45029 | 75 | 8 |
177732 | 177732 | 2020-05-25 | Colleton | South Carolina | 45029 | 74 | 8 |
180775 | 180775 | 2020-05-26 | Colleton | South Carolina | 45029 | 76 | 8 |
183825 | 183825 | 2020-05-27 | Colleton | South Carolina | 45029 | 76 | 11 |
186882 | 186882 | 2020-05-28 | Colleton | South Carolina | 45029 | 86 | 11 |
189944 | 189944 | 2020-05-29 | Colleton | South Carolina | 45029 | 92 | 11 |
193009 | 193009 | 2020-05-30 | Colleton | South Carolina | 45029 | 101 | 11 |
196078 | 196078 | 2020-05-31 | Colleton | South Carolina | 45029 | 105 | 12 |
199151 | 199151 | 2020-06-01 | Colleton | South Carolina | 45029 | 110 | 14 |
202226 | 202226 | 2020-06-02 | Colleton | South Carolina | 45029 | 114 | 14 |
205303 | 205303 | 2020-06-03 | Colleton | South Carolina | 45029 | 117 | 14 |
208384 | 208384 | 2020-06-04 | Colleton | South Carolina | 45029 | 122 | 14 |
211466 | 211466 | 2020-06-05 | Colleton | South Carolina | 45029 | 128 | 14 |
214552 | 214552 | 2020-06-06 | Colleton | South Carolina | 45029 | 132 | 14 |
217642 | 217642 | 2020-06-07 | Colleton | South Carolina | 45029 | 142 | 14 |
220734 | 220734 | 2020-06-08 | Colleton | South Carolina | 45029 | 144 | 14 |
223829 | 223829 | 2020-06-09 | Colleton | South Carolina | 45029 | 148 | 14 |
226929 | 226929 | 2020-06-10 | Colleton | South Carolina | 45029 | 159 | 14 |
230033 | 230033 | 2020-06-11 | Colleton | South Carolina | 45029 | 165 | 16 |
233138 | 233138 | 2020-06-12 | Colleton | South Carolina | 45029 | 177 | 16 |
236243 | 236243 | 2020-06-13 | Colleton | South Carolina | 45029 | 190 | 16 |
239351 | 239351 | 2020-06-14 | Colleton | South Carolina | 45029 | 198 | 16 |
242460 | 242460 | 2020-06-15 | Colleton | South Carolina | 45029 | 201 | 16 |
245572 | 245572 | 2020-06-16 | Colleton | South Carolina | 45029 | 209 | 17 |
248685 | 248685 | 2020-06-17 | Colleton | South Carolina | 45029 | 211 | 18 |
251800 | 251800 | 2020-06-18 | Colleton | South Carolina | 45029 | 214 | 18 |
254915 | 254915 | 2020-06-19 | Colleton | South Carolina | 45029 | 217 | 19 |
258041 | 258041 | 2020-06-20 | Colleton | South Carolina | 45029 | 234 | 19 |
261168 | 261168 | 2020-06-21 | Colleton | South Carolina | 45029 | 245 | 20 |
264296 | 264296 | 2020-06-22 | Colleton | South Carolina | 45029 | 246 | 20 |
267424 | 267424 | 2020-06-23 | Colleton | South Carolina | 45029 | 253 | 20 |
270558 | 270558 | 2020-06-24 | Colleton | South Carolina | 45029 | 258 | 20 |
273697 | 273697 | 2020-06-25 | Colleton | South Carolina | 45029 | 273 | 21 |
276844 | 276844 | 2020-06-26 | Colleton | South Carolina | 45029 | 284 | 21 |
279992 | 279992 | 2020-06-27 | Colleton | South Carolina | 45029 | 295 | 21 |
283138 | 283138 | 2020-06-28 | Colleton | South Carolina | 45029 | 307 | 21 |
286283 | 286283 | 2020-06-29 | Colleton | South Carolina | 45029 | 324 | 21 |
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);