ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Lee" and state = "South Carolina" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
4268 | 4268 | 2020-03-18 | Lee | South Carolina | 45061 | 1 | 0 |
5012 | 5012 | 2020-03-19 | Lee | South Carolina | 45061 | 1 | 0 |
5890 | 5890 | 2020-03-20 | Lee | South Carolina | 45061 | 1 | 0 |
6898 | 6898 | 2020-03-21 | Lee | South Carolina | 45061 | 1 | 0 |
8019 | 8019 | 2020-03-22 | Lee | South Carolina | 45061 | 1 | 0 |
9232 | 9232 | 2020-03-23 | Lee | South Carolina | 45061 | 2 | 0 |
10558 | 10558 | 2020-03-24 | Lee | South Carolina | 45061 | 2 | 0 |
12029 | 12029 | 2020-03-25 | Lee | South Carolina | 45061 | 2 | 0 |
13651 | 13651 | 2020-03-26 | Lee | South Carolina | 45061 | 2 | 0 |
15398 | 15398 | 2020-03-27 | Lee | South Carolina | 45061 | 2 | 0 |
17253 | 17253 | 2020-03-28 | Lee | South Carolina | 45061 | 5 | 0 |
19193 | 19193 | 2020-03-29 | Lee | South Carolina | 45061 | 5 | 0 |
21245 | 21245 | 2020-03-30 | Lee | South Carolina | 45061 | 5 | 0 |
23383 | 23383 | 2020-03-31 | Lee | South Carolina | 45061 | 5 | 0 |
25581 | 25581 | 2020-04-01 | Lee | South Carolina | 45061 | 5 | 1 |
27856 | 27856 | 2020-04-02 | Lee | South Carolina | 45061 | 8 | 1 |
30191 | 30191 | 2020-04-03 | Lee | South Carolina | 45061 | 13 | 1 |
32582 | 32582 | 2020-04-04 | Lee | South Carolina | 45061 | 16 | 1 |
35018 | 35018 | 2020-04-05 | Lee | South Carolina | 45061 | 17 | 2 |
37493 | 37493 | 2020-04-06 | Lee | South Carolina | 45061 | 18 | 2 |
40016 | 40016 | 2020-04-07 | Lee | South Carolina | 45061 | 19 | 2 |
42576 | 42576 | 2020-04-08 | Lee | South Carolina | 45061 | 22 | 2 |
45162 | 45162 | 2020-04-09 | Lee | South Carolina | 45061 | 24 | 3 |
47779 | 47779 | 2020-04-10 | Lee | South Carolina | 45061 | 27 | 3 |
50436 | 50436 | 2020-04-11 | Lee | South Carolina | 45061 | 27 | 3 |
53109 | 53109 | 2020-04-12 | Lee | South Carolina | 45061 | 29 | 3 |
55794 | 55794 | 2020-04-13 | Lee | South Carolina | 45061 | 31 | 3 |
58497 | 58497 | 2020-04-14 | Lee | South Carolina | 45061 | 33 | 3 |
61212 | 61212 | 2020-04-15 | Lee | South Carolina | 45061 | 34 | 3 |
63938 | 63938 | 2020-04-16 | Lee | South Carolina | 45061 | 35 | 4 |
66684 | 66684 | 2020-04-17 | Lee | South Carolina | 45061 | 40 | 5 |
69442 | 69442 | 2020-04-18 | Lee | South Carolina | 45061 | 40 | 5 |
77766 | 77766 | 2020-04-21 | Lee | South Carolina | 45061 | 41 | 5 |
72209 | 72209 | 2020-04-19 | Lee | South Carolina | 45061 | 42 | 5 |
74984 | 74984 | 2020-04-20 | Lee | South Carolina | 45061 | 42 | 5 |
80556 | 80556 | 2020-04-22 | Lee | South Carolina | 45061 | 42 | 5 |
83355 | 83355 | 2020-04-23 | Lee | South Carolina | 45061 | 45 | 5 |
86159 | 86159 | 2020-04-24 | Lee | South Carolina | 45061 | 48 | 5 |
88973 | 88973 | 2020-04-25 | Lee | South Carolina | 45061 | 51 | 6 |
91789 | 91789 | 2020-04-26 | Lee | South Carolina | 45061 | 51 | 6 |
94616 | 94616 | 2020-04-27 | Lee | South Carolina | 45061 | 55 | 6 |
97455 | 97455 | 2020-04-28 | Lee | South Carolina | 45061 | 58 | 7 |
100304 | 100304 | 2020-04-29 | Lee | South Carolina | 45061 | 58 | 7 |
103157 | 103157 | 2020-04-30 | Lee | South Carolina | 45061 | 63 | 7 |
106020 | 106020 | 2020-05-01 | Lee | South Carolina | 45061 | 65 | 7 |
108887 | 108887 | 2020-05-02 | Lee | South Carolina | 45061 | 68 | 8 |
111761 | 111761 | 2020-05-03 | Lee | South Carolina | 45061 | 68 | 8 |
114643 | 114643 | 2020-05-04 | Lee | South Carolina | 45061 | 68 | 8 |
117599 | 117599 | 2020-05-05 | Lee | South Carolina | 45061 | 69 | 8 |
120561 | 120561 | 2020-05-06 | Lee | South Carolina | 45061 | 70 | 8 |
123539 | 123539 | 2020-05-07 | Lee | South Carolina | 45061 | 80 | 8 |
126522 | 126522 | 2020-05-08 | Lee | South Carolina | 45061 | 92 | 8 |
129511 | 129511 | 2020-05-09 | Lee | South Carolina | 45061 | 99 | 8 |
132500 | 132500 | 2020-05-10 | Lee | South Carolina | 45061 | 106 | 8 |
135491 | 135491 | 2020-05-11 | Lee | South Carolina | 45061 | 115 | 8 |
138481 | 138481 | 2020-05-12 | Lee | South Carolina | 45061 | 117 | 8 |
141477 | 141477 | 2020-05-13 | Lee | South Carolina | 45061 | 122 | 10 |
144473 | 144473 | 2020-05-14 | Lee | South Carolina | 45061 | 123 | 10 |
147474 | 147474 | 2020-05-15 | Lee | South Carolina | 45061 | 127 | 10 |
150482 | 150482 | 2020-05-16 | Lee | South Carolina | 45061 | 158 | 11 |
153493 | 153493 | 2020-05-17 | Lee | South Carolina | 45061 | 164 | 11 |
156510 | 156510 | 2020-05-18 | Lee | South Carolina | 45061 | 170 | 11 |
159531 | 159531 | 2020-05-19 | Lee | South Carolina | 45061 | 174 | 11 |
162558 | 162558 | 2020-05-20 | Lee | South Carolina | 45061 | 175 | 11 |
165587 | 165587 | 2020-05-21 | Lee | South Carolina | 45061 | 178 | 13 |
168623 | 168623 | 2020-05-22 | Lee | South Carolina | 45061 | 181 | 13 |
171662 | 171662 | 2020-05-23 | Lee | South Carolina | 45061 | 187 | 13 |
174704 | 174704 | 2020-05-24 | Lee | South Carolina | 45061 | 191 | 13 |
177748 | 177748 | 2020-05-25 | Lee | South Carolina | 45061 | 198 | 13 |
180791 | 180791 | 2020-05-26 | Lee | South Carolina | 45061 | 207 | 13 |
183841 | 183841 | 2020-05-27 | Lee | South Carolina | 45061 | 208 | 15 |
186898 | 186898 | 2020-05-28 | Lee | South Carolina | 45061 | 209 | 15 |
189960 | 189960 | 2020-05-29 | Lee | South Carolina | 45061 | 212 | 16 |
193025 | 193025 | 2020-05-30 | Lee | South Carolina | 45061 | 217 | 16 |
196094 | 196094 | 2020-05-31 | Lee | South Carolina | 45061 | 218 | 16 |
199167 | 199167 | 2020-06-01 | Lee | South Carolina | 45061 | 218 | 16 |
202242 | 202242 | 2020-06-02 | Lee | South Carolina | 45061 | 221 | 16 |
205319 | 205319 | 2020-06-03 | Lee | South Carolina | 45061 | 222 | 17 |
208400 | 208400 | 2020-06-04 | Lee | South Carolina | 45061 | 225 | 17 |
211482 | 211482 | 2020-06-05 | Lee | South Carolina | 45061 | 227 | 17 |
214568 | 214568 | 2020-06-06 | Lee | South Carolina | 45061 | 227 | 17 |
217658 | 217658 | 2020-06-07 | Lee | South Carolina | 45061 | 229 | 17 |
220750 | 220750 | 2020-06-08 | Lee | South Carolina | 45061 | 229 | 17 |
223845 | 223845 | 2020-06-09 | Lee | South Carolina | 45061 | 231 | 19 |
230049 | 230049 | 2020-06-11 | Lee | South Carolina | 45061 | 232 | 19 |
226945 | 226945 | 2020-06-10 | Lee | South Carolina | 45061 | 233 | 19 |
233154 | 233154 | 2020-06-12 | Lee | South Carolina | 45061 | 233 | 19 |
236259 | 236259 | 2020-06-13 | Lee | South Carolina | 45061 | 233 | 19 |
239367 | 239367 | 2020-06-14 | Lee | South Carolina | 45061 | 236 | 19 |
242476 | 242476 | 2020-06-15 | Lee | South Carolina | 45061 | 236 | 19 |
245588 | 245588 | 2020-06-16 | Lee | South Carolina | 45061 | 238 | 19 |
248701 | 248701 | 2020-06-17 | Lee | South Carolina | 45061 | 238 | 19 |
251816 | 251816 | 2020-06-18 | Lee | South Carolina | 45061 | 245 | 19 |
254931 | 254931 | 2020-06-19 | Lee | South Carolina | 45061 | 246 | 19 |
258057 | 258057 | 2020-06-20 | Lee | South Carolina | 45061 | 251 | 20 |
261184 | 261184 | 2020-06-21 | Lee | South Carolina | 45061 | 254 | 20 |
264312 | 264312 | 2020-06-22 | Lee | South Carolina | 45061 | 256 | 20 |
270574 | 270574 | 2020-06-24 | Lee | South Carolina | 45061 | 264 | 21 |
273713 | 273713 | 2020-06-25 | Lee | South Carolina | 45061 | 264 | 22 |
267440 | 267440 | 2020-06-23 | Lee | South Carolina | 45061 | 265 | 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);