ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Clarendon" and state = "South Carolina" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
5881 | 5881 | 2020-03-20 | Clarendon | South Carolina | 45027 | 1 | 0 |
6885 | 6885 | 2020-03-21 | Clarendon | South Carolina | 45027 | 1 | 0 |
8005 | 8005 | 2020-03-22 | Clarendon | South Carolina | 45027 | 1 | 0 |
9217 | 9217 | 2020-03-23 | Clarendon | South Carolina | 45027 | 4 | 1 |
10543 | 10543 | 2020-03-24 | Clarendon | South Carolina | 45027 | 5 | 1 |
12014 | 12014 | 2020-03-25 | Clarendon | South Carolina | 45027 | 5 | 1 |
13636 | 13636 | 2020-03-26 | Clarendon | South Carolina | 45027 | 5 | 1 |
15383 | 15383 | 2020-03-27 | Clarendon | South Carolina | 45027 | 6 | 1 |
17237 | 17237 | 2020-03-28 | Clarendon | South Carolina | 45027 | 7 | 1 |
19177 | 19177 | 2020-03-29 | Clarendon | South Carolina | 45027 | 16 | 1 |
21229 | 21229 | 2020-03-30 | Clarendon | South Carolina | 45027 | 18 | 1 |
23367 | 23367 | 2020-03-31 | Clarendon | South Carolina | 45027 | 25 | 1 |
25565 | 25565 | 2020-04-01 | Clarendon | South Carolina | 45027 | 28 | 1 |
27839 | 27839 | 2020-04-02 | Clarendon | South Carolina | 45027 | 31 | 1 |
30174 | 30174 | 2020-04-03 | Clarendon | South Carolina | 45027 | 34 | 1 |
32565 | 32565 | 2020-04-04 | Clarendon | South Carolina | 45027 | 45 | 1 |
35001 | 35001 | 2020-04-05 | Clarendon | South Carolina | 45027 | 54 | 2 |
37476 | 37476 | 2020-04-06 | Clarendon | South Carolina | 45027 | 58 | 2 |
39999 | 39999 | 2020-04-07 | Clarendon | South Carolina | 45027 | 68 | 2 |
42559 | 42559 | 2020-04-08 | Clarendon | South Carolina | 45027 | 72 | 3 |
45145 | 45145 | 2020-04-09 | Clarendon | South Carolina | 45027 | 75 | 3 |
47762 | 47762 | 2020-04-10 | Clarendon | South Carolina | 45027 | 80 | 3 |
50419 | 50419 | 2020-04-11 | Clarendon | South Carolina | 45027 | 85 | 4 |
53092 | 53092 | 2020-04-12 | Clarendon | South Carolina | 45027 | 85 | 4 |
55777 | 55777 | 2020-04-13 | Clarendon | South Carolina | 45027 | 86 | 4 |
58480 | 58480 | 2020-04-14 | Clarendon | South Carolina | 45027 | 89 | 6 |
61195 | 61195 | 2020-04-15 | Clarendon | South Carolina | 45027 | 90 | 6 |
63921 | 63921 | 2020-04-16 | Clarendon | South Carolina | 45027 | 98 | 6 |
66667 | 66667 | 2020-04-17 | Clarendon | South Carolina | 45027 | 106 | 6 |
69425 | 69425 | 2020-04-18 | Clarendon | South Carolina | 45027 | 109 | 6 |
72192 | 72192 | 2020-04-19 | Clarendon | South Carolina | 45027 | 112 | 6 |
74967 | 74967 | 2020-04-20 | Clarendon | South Carolina | 45027 | 120 | 7 |
77749 | 77749 | 2020-04-21 | Clarendon | South Carolina | 45027 | 126 | 8 |
80539 | 80539 | 2020-04-22 | Clarendon | South Carolina | 45027 | 138 | 9 |
83338 | 83338 | 2020-04-23 | Clarendon | South Carolina | 45027 | 151 | 9 |
86142 | 86142 | 2020-04-24 | Clarendon | South Carolina | 45027 | 163 | 9 |
88956 | 88956 | 2020-04-25 | Clarendon | South Carolina | 45027 | 172 | 9 |
91772 | 91772 | 2020-04-26 | Clarendon | South Carolina | 45027 | 181 | 11 |
94599 | 94599 | 2020-04-27 | Clarendon | South Carolina | 45027 | 185 | 12 |
97438 | 97438 | 2020-04-28 | Clarendon | South Carolina | 45027 | 194 | 14 |
100287 | 100287 | 2020-04-29 | Clarendon | South Carolina | 45027 | 201 | 17 |
103140 | 103140 | 2020-04-30 | Clarendon | South Carolina | 45027 | 210 | 18 |
106003 | 106003 | 2020-05-01 | Clarendon | South Carolina | 45027 | 214 | 21 |
108870 | 108870 | 2020-05-02 | Clarendon | South Carolina | 45027 | 218 | 21 |
111744 | 111744 | 2020-05-03 | Clarendon | South Carolina | 45027 | 229 | 22 |
114626 | 114626 | 2020-05-04 | Clarendon | South Carolina | 45027 | 232 | 24 |
117582 | 117582 | 2020-05-05 | Clarendon | South Carolina | 45027 | 237 | 24 |
120544 | 120544 | 2020-05-06 | Clarendon | South Carolina | 45027 | 248 | 24 |
123522 | 123522 | 2020-05-07 | Clarendon | South Carolina | 45027 | 253 | 24 |
126505 | 126505 | 2020-05-08 | Clarendon | South Carolina | 45027 | 258 | 25 |
129494 | 129494 | 2020-05-09 | Clarendon | South Carolina | 45027 | 262 | 26 |
132483 | 132483 | 2020-05-10 | Clarendon | South Carolina | 45027 | 263 | 26 |
135474 | 135474 | 2020-05-11 | Clarendon | South Carolina | 45027 | 265 | 27 |
138464 | 138464 | 2020-05-12 | Clarendon | South Carolina | 45027 | 267 | 27 |
141460 | 141460 | 2020-05-13 | Clarendon | South Carolina | 45027 | 266 | 29 |
144456 | 144456 | 2020-05-14 | Clarendon | South Carolina | 45027 | 266 | 31 |
147457 | 147457 | 2020-05-15 | Clarendon | South Carolina | 45027 | 274 | 33 |
150465 | 150465 | 2020-05-16 | Clarendon | South Carolina | 45027 | 274 | 32 |
153476 | 153476 | 2020-05-17 | Clarendon | South Carolina | 45027 | 286 | 32 |
156493 | 156493 | 2020-05-18 | Clarendon | South Carolina | 45027 | 290 | 34 |
159514 | 159514 | 2020-05-19 | Clarendon | South Carolina | 45027 | 293 | 34 |
162541 | 162541 | 2020-05-20 | Clarendon | South Carolina | 45027 | 290 | 35 |
165570 | 165570 | 2020-05-21 | Clarendon | South Carolina | 45027 | 288 | 36 |
168606 | 168606 | 2020-05-22 | Clarendon | South Carolina | 45027 | 289 | 36 |
171645 | 171645 | 2020-05-23 | Clarendon | South Carolina | 45027 | 289 | 37 |
174687 | 174687 | 2020-05-24 | Clarendon | South Carolina | 45027 | 293 | 38 |
177731 | 177731 | 2020-05-25 | Clarendon | South Carolina | 45027 | 293 | 38 |
180774 | 180774 | 2020-05-26 | Clarendon | South Carolina | 45027 | 294 | 38 |
183824 | 183824 | 2020-05-27 | Clarendon | South Carolina | 45027 | 295 | 38 |
186881 | 186881 | 2020-05-28 | Clarendon | South Carolina | 45027 | 296 | 38 |
189943 | 189943 | 2020-05-29 | Clarendon | South Carolina | 45027 | 296 | 38 |
193008 | 193008 | 2020-05-30 | Clarendon | South Carolina | 45027 | 301 | 39 |
196077 | 196077 | 2020-05-31 | Clarendon | South Carolina | 45027 | 301 | 39 |
199150 | 199150 | 2020-06-01 | Clarendon | South Carolina | 45027 | 301 | 39 |
202225 | 202225 | 2020-06-02 | Clarendon | South Carolina | 45027 | 302 | 39 |
205302 | 205302 | 2020-06-03 | Clarendon | South Carolina | 45027 | 302 | 39 |
208383 | 208383 | 2020-06-04 | Clarendon | South Carolina | 45027 | 301 | 39 |
211465 | 211465 | 2020-06-05 | Clarendon | South Carolina | 45027 | 304 | 40 |
214551 | 214551 | 2020-06-06 | Clarendon | South Carolina | 45027 | 305 | 40 |
217641 | 217641 | 2020-06-07 | Clarendon | South Carolina | 45027 | 306 | 40 |
220733 | 220733 | 2020-06-08 | Clarendon | South Carolina | 45027 | 306 | 41 |
223828 | 223828 | 2020-06-09 | Clarendon | South Carolina | 45027 | 309 | 41 |
226928 | 226928 | 2020-06-10 | Clarendon | South Carolina | 45027 | 311 | 41 |
230032 | 230032 | 2020-06-11 | Clarendon | South Carolina | 45027 | 320 | 41 |
233137 | 233137 | 2020-06-12 | Clarendon | South Carolina | 45027 | 325 | 41 |
236242 | 236242 | 2020-06-13 | Clarendon | South Carolina | 45027 | 327 | 41 |
239350 | 239350 | 2020-06-14 | Clarendon | South Carolina | 45027 | 335 | 41 |
242459 | 242459 | 2020-06-15 | Clarendon | South Carolina | 45027 | 343 | 41 |
245571 | 245571 | 2020-06-16 | Clarendon | South Carolina | 45027 | 342 | 41 |
248684 | 248684 | 2020-06-17 | Clarendon | South Carolina | 45027 | 347 | 41 |
251799 | 251799 | 2020-06-18 | Clarendon | South Carolina | 45027 | 346 | 41 |
254914 | 254914 | 2020-06-19 | Clarendon | South Carolina | 45027 | 349 | 41 |
258040 | 258040 | 2020-06-20 | Clarendon | South Carolina | 45027 | 357 | 41 |
261167 | 261167 | 2020-06-21 | Clarendon | South Carolina | 45027 | 359 | 41 |
264295 | 264295 | 2020-06-22 | Clarendon | South Carolina | 45027 | 365 | 42 |
267423 | 267423 | 2020-06-23 | Clarendon | South Carolina | 45027 | 373 | 42 |
270557 | 270557 | 2020-06-24 | Clarendon | South Carolina | 45027 | 378 | 42 |
273696 | 273696 | 2020-06-25 | Clarendon | South Carolina | 45027 | 387 | 42 |
276843 | 276843 | 2020-06-26 | Clarendon | South Carolina | 45027 | 403 | 42 |
279991 | 279991 | 2020-06-27 | Clarendon | South Carolina | 45027 | 406 | 42 |
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);