ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 45047 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388352 | 388352 | 2020-07-31 | Greenwood | South Carolina | 45047 | 1197 | 15 |
385135 | 385135 | 2020-07-30 | Greenwood | South Carolina | 45047 | 1174 | 15 |
381917 | 381917 | 2020-07-29 | Greenwood | South Carolina | 45047 | 1170 | 14 |
378700 | 378700 | 2020-07-28 | Greenwood | South Carolina | 45047 | 1155 | 14 |
375484 | 375484 | 2020-07-27 | Greenwood | South Carolina | 45047 | 1132 | 14 |
372271 | 372271 | 2020-07-26 | Greenwood | South Carolina | 45047 | 1130 | 14 |
369059 | 369059 | 2020-07-25 | Greenwood | South Carolina | 45047 | 1115 | 14 |
365850 | 365850 | 2020-07-24 | Greenwood | South Carolina | 45047 | 1096 | 14 |
362644 | 362644 | 2020-07-23 | Greenwood | South Carolina | 45047 | 1075 | 14 |
359438 | 359438 | 2020-07-22 | Greenwood | South Carolina | 45047 | 1056 | 13 |
356234 | 356234 | 2020-07-21 | Greenwood | South Carolina | 45047 | 1046 | 11 |
353031 | 353031 | 2020-07-20 | Greenwood | South Carolina | 45047 | 1013 | 10 |
349828 | 349828 | 2020-07-19 | Greenwood | South Carolina | 45047 | 989 | 10 |
346628 | 346628 | 2020-07-18 | Greenwood | South Carolina | 45047 | 968 | 10 |
343428 | 343428 | 2020-07-17 | Greenwood | South Carolina | 45047 | 943 | 10 |
340230 | 340230 | 2020-07-16 | Greenwood | South Carolina | 45047 | 885 | 9 |
337033 | 337033 | 2020-07-15 | Greenwood | South Carolina | 45047 | 867 | 7 |
333839 | 333839 | 2020-07-14 | Greenwood | South Carolina | 45047 | 845 | 7 |
330647 | 330647 | 2020-07-13 | Greenwood | South Carolina | 45047 | 824 | 7 |
327461 | 327461 | 2020-07-12 | Greenwood | South Carolina | 45047 | 799 | 7 |
324276 | 324276 | 2020-07-11 | Greenwood | South Carolina | 45047 | 767 | 7 |
321096 | 321096 | 2020-07-10 | Greenwood | South Carolina | 45047 | 697 | 7 |
317918 | 317918 | 2020-07-09 | Greenwood | South Carolina | 45047 | 669 | 7 |
314745 | 314745 | 2020-07-08 | Greenwood | South Carolina | 45047 | 649 | 7 |
311573 | 311573 | 2020-07-07 | Greenwood | South Carolina | 45047 | 599 | 7 |
308404 | 308404 | 2020-07-06 | Greenwood | South Carolina | 45047 | 595 | 7 |
305237 | 305237 | 2020-07-05 | Greenwood | South Carolina | 45047 | 561 | 7 |
302074 | 302074 | 2020-07-04 | Greenwood | South Carolina | 45047 | 534 | 7 |
298910 | 298910 | 2020-07-03 | Greenwood | South Carolina | 45047 | 528 | 7 |
295751 | 295751 | 2020-07-02 | Greenwood | South Carolina | 45047 | 527 | 7 |
292595 | 292595 | 2020-07-01 | Greenwood | South Carolina | 45047 | 506 | 7 |
289443 | 289443 | 2020-06-30 | Greenwood | South Carolina | 45047 | 493 | 7 |
286292 | 286292 | 2020-06-29 | Greenwood | South Carolina | 45047 | 467 | 7 |
283147 | 283147 | 2020-06-28 | Greenwood | South Carolina | 45047 | 458 | 7 |
280001 | 280001 | 2020-06-27 | Greenwood | South Carolina | 45047 | 448 | 7 |
276853 | 276853 | 2020-06-26 | Greenwood | South Carolina | 45047 | 405 | 6 |
273706 | 273706 | 2020-06-25 | Greenwood | South Carolina | 45047 | 402 | 6 |
270567 | 270567 | 2020-06-24 | Greenwood | South Carolina | 45047 | 392 | 6 |
267433 | 267433 | 2020-06-23 | Greenwood | South Carolina | 45047 | 382 | 6 |
264305 | 264305 | 2020-06-22 | Greenwood | South Carolina | 45047 | 374 | 5 |
261177 | 261177 | 2020-06-21 | Greenwood | South Carolina | 45047 | 371 | 5 |
258050 | 258050 | 2020-06-20 | Greenwood | South Carolina | 45047 | 353 | 5 |
254924 | 254924 | 2020-06-19 | Greenwood | South Carolina | 45047 | 345 | 5 |
251809 | 251809 | 2020-06-18 | Greenwood | South Carolina | 45047 | 322 | 5 |
248694 | 248694 | 2020-06-17 | Greenwood | South Carolina | 45047 | 320 | 5 |
245581 | 245581 | 2020-06-16 | Greenwood | South Carolina | 45047 | 315 | 5 |
242469 | 242469 | 2020-06-15 | Greenwood | South Carolina | 45047 | 312 | 5 |
239360 | 239360 | 2020-06-14 | Greenwood | South Carolina | 45047 | 304 | 5 |
236252 | 236252 | 2020-06-13 | Greenwood | South Carolina | 45047 | 273 | 5 |
233147 | 233147 | 2020-06-12 | Greenwood | South Carolina | 45047 | 259 | 5 |
230042 | 230042 | 2020-06-11 | Greenwood | South Carolina | 45047 | 235 | 5 |
226938 | 226938 | 2020-06-10 | Greenwood | South Carolina | 45047 | 199 | 4 |
223838 | 223838 | 2020-06-09 | Greenwood | South Carolina | 45047 | 198 | 4 |
220743 | 220743 | 2020-06-08 | Greenwood | South Carolina | 45047 | 183 | 3 |
217651 | 217651 | 2020-06-07 | Greenwood | South Carolina | 45047 | 172 | 3 |
214561 | 214561 | 2020-06-06 | Greenwood | South Carolina | 45047 | 172 | 3 |
211475 | 211475 | 2020-06-05 | Greenwood | South Carolina | 45047 | 160 | 2 |
208393 | 208393 | 2020-06-04 | Greenwood | South Carolina | 45047 | 159 | 2 |
205312 | 205312 | 2020-06-03 | Greenwood | South Carolina | 45047 | 150 | 2 |
202235 | 202235 | 2020-06-02 | Greenwood | South Carolina | 45047 | 148 | 1 |
199160 | 199160 | 2020-06-01 | Greenwood | South Carolina | 45047 | 147 | 1 |
196087 | 196087 | 2020-05-31 | Greenwood | South Carolina | 45047 | 142 | 1 |
193018 | 193018 | 2020-05-30 | Greenwood | South Carolina | 45047 | 129 | 1 |
189953 | 189953 | 2020-05-29 | Greenwood | South Carolina | 45047 | 128 | 1 |
186891 | 186891 | 2020-05-28 | Greenwood | South Carolina | 45047 | 121 | 1 |
183834 | 183834 | 2020-05-27 | Greenwood | South Carolina | 45047 | 103 | 1 |
180784 | 180784 | 2020-05-26 | Greenwood | South Carolina | 45047 | 92 | 1 |
177741 | 177741 | 2020-05-25 | Greenwood | South Carolina | 45047 | 82 | 1 |
174697 | 174697 | 2020-05-24 | Greenwood | South Carolina | 45047 | 82 | 1 |
171655 | 171655 | 2020-05-23 | Greenwood | South Carolina | 45047 | 82 | 1 |
168616 | 168616 | 2020-05-22 | Greenwood | South Carolina | 45047 | 79 | 1 |
165580 | 165580 | 2020-05-21 | Greenwood | South Carolina | 45047 | 76 | 1 |
162551 | 162551 | 2020-05-20 | Greenwood | South Carolina | 45047 | 72 | 1 |
159524 | 159524 | 2020-05-19 | Greenwood | South Carolina | 45047 | 72 | 1 |
156503 | 156503 | 2020-05-18 | Greenwood | South Carolina | 45047 | 71 | 1 |
153486 | 153486 | 2020-05-17 | Greenwood | South Carolina | 45047 | 69 | 1 |
150475 | 150475 | 2020-05-16 | Greenwood | South Carolina | 45047 | 69 | 1 |
147467 | 147467 | 2020-05-15 | Greenwood | South Carolina | 45047 | 69 | 1 |
144466 | 144466 | 2020-05-14 | Greenwood | South Carolina | 45047 | 68 | 1 |
141470 | 141470 | 2020-05-13 | Greenwood | South Carolina | 45047 | 67 | 0 |
138474 | 138474 | 2020-05-12 | Greenwood | South Carolina | 45047 | 63 | 0 |
135484 | 135484 | 2020-05-11 | Greenwood | South Carolina | 45047 | 63 | 0 |
132493 | 132493 | 2020-05-10 | Greenwood | South Carolina | 45047 | 62 | 0 |
129504 | 129504 | 2020-05-09 | Greenwood | South Carolina | 45047 | 62 | 0 |
126515 | 126515 | 2020-05-08 | Greenwood | South Carolina | 45047 | 62 | 0 |
123532 | 123532 | 2020-05-07 | Greenwood | South Carolina | 45047 | 61 | 0 |
120554 | 120554 | 2020-05-06 | Greenwood | South Carolina | 45047 | 61 | 0 |
117592 | 117592 | 2020-05-05 | Greenwood | South Carolina | 45047 | 57 | 0 |
114636 | 114636 | 2020-05-04 | Greenwood | South Carolina | 45047 | 55 | 0 |
111754 | 111754 | 2020-05-03 | Greenwood | South Carolina | 45047 | 55 | 0 |
108880 | 108880 | 2020-05-02 | Greenwood | South Carolina | 45047 | 53 | 0 |
106013 | 106013 | 2020-05-01 | Greenwood | South Carolina | 45047 | 49 | 0 |
103150 | 103150 | 2020-04-30 | Greenwood | South Carolina | 45047 | 49 | 0 |
100297 | 100297 | 2020-04-29 | Greenwood | South Carolina | 45047 | 46 | 0 |
97448 | 97448 | 2020-04-28 | Greenwood | South Carolina | 45047 | 46 | 0 |
94609 | 94609 | 2020-04-27 | Greenwood | South Carolina | 45047 | 45 | 0 |
91782 | 91782 | 2020-04-26 | Greenwood | South Carolina | 45047 | 44 | 0 |
88966 | 88966 | 2020-04-25 | Greenwood | South Carolina | 45047 | 43 | 0 |
86152 | 86152 | 2020-04-24 | Greenwood | South Carolina | 45047 | 42 | 0 |
83348 | 83348 | 2020-04-23 | Greenwood | South Carolina | 45047 | 41 | 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);