ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,554 rows where county = "Greenwood" sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, date (date)
Link | rowid | date | county | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
6893 | 6893 | 2020-03-21 | Greenwood | South Carolina | 45047 | 2 | 0 |
8014 | 8014 | 2020-03-22 | Greenwood | South Carolina | 45047 | 2 | 0 |
9227 | 9227 | 2020-03-23 | Greenwood | South Carolina | 45047 | 2 | 0 |
10553 | 10553 | 2020-03-24 | Greenwood | South Carolina | 45047 | 2 | 0 |
12024 | 12024 | 2020-03-25 | Greenwood | South Carolina | 45047 | 2 | 0 |
13646 | 13646 | 2020-03-26 | Greenwood | South Carolina | 45047 | 2 | 0 |
15393 | 15393 | 2020-03-27 | Greenwood | South Carolina | 45047 | 2 | 0 |
17247 | 17247 | 2020-03-28 | Greenwood | South Carolina | 45047 | 3 | 0 |
19187 | 19187 | 2020-03-29 | Greenwood | South Carolina | 45047 | 3 | 0 |
21239 | 21239 | 2020-03-30 | Greenwood | South Carolina | 45047 | 3 | 0 |
23377 | 23377 | 2020-03-31 | Greenwood | South Carolina | 45047 | 5 | 0 |
25575 | 25575 | 2020-04-01 | Greenwood | South Carolina | 45047 | 6 | 0 |
27849 | 27849 | 2020-04-02 | Greenwood | South Carolina | 45047 | 8 | 0 |
30184 | 30184 | 2020-04-03 | Greenwood | South Carolina | 45047 | 9 | 0 |
32575 | 32575 | 2020-04-04 | Greenwood | South Carolina | 45047 | 10 | 0 |
35011 | 35011 | 2020-04-05 | Greenwood | South Carolina | 45047 | 10 | 0 |
37486 | 37486 | 2020-04-06 | Greenwood | South Carolina | 45047 | 11 | 0 |
40009 | 40009 | 2020-04-07 | Greenwood | South Carolina | 45047 | 12 | 0 |
42569 | 42569 | 2020-04-08 | Greenwood | South Carolina | 45047 | 14 | 0 |
45155 | 45155 | 2020-04-09 | Greenwood | South Carolina | 45047 | 15 | 0 |
47772 | 47772 | 2020-04-10 | Greenwood | South Carolina | 45047 | 16 | 0 |
50429 | 50429 | 2020-04-11 | Greenwood | South Carolina | 45047 | 17 | 0 |
53102 | 53102 | 2020-04-12 | Greenwood | South Carolina | 45047 | 17 | 0 |
55787 | 55787 | 2020-04-13 | Greenwood | South Carolina | 45047 | 18 | 0 |
58490 | 58490 | 2020-04-14 | Greenwood | South Carolina | 45047 | 18 | 0 |
61205 | 61205 | 2020-04-15 | Greenwood | South Carolina | 45047 | 19 | 0 |
63931 | 63931 | 2020-04-16 | Greenwood | South Carolina | 45047 | 31 | 0 |
66677 | 66677 | 2020-04-17 | Greenwood | South Carolina | 45047 | 32 | 0 |
69435 | 69435 | 2020-04-18 | Greenwood | South Carolina | 45047 | 34 | 0 |
72202 | 72202 | 2020-04-19 | Greenwood | South Carolina | 45047 | 36 | 0 |
74977 | 74977 | 2020-04-20 | Greenwood | South Carolina | 45047 | 37 | 0 |
77759 | 77759 | 2020-04-21 | Greenwood | South Carolina | 45047 | 40 | 0 |
80549 | 80549 | 2020-04-22 | Greenwood | South Carolina | 45047 | 41 | 0 |
83348 | 83348 | 2020-04-23 | Greenwood | South Carolina | 45047 | 41 | 0 |
86152 | 86152 | 2020-04-24 | Greenwood | South Carolina | 45047 | 42 | 0 |
88966 | 88966 | 2020-04-25 | Greenwood | South Carolina | 45047 | 43 | 0 |
91782 | 91782 | 2020-04-26 | Greenwood | South Carolina | 45047 | 44 | 0 |
94609 | 94609 | 2020-04-27 | Greenwood | South Carolina | 45047 | 45 | 0 |
97448 | 97448 | 2020-04-28 | Greenwood | South Carolina | 45047 | 46 | 0 |
100297 | 100297 | 2020-04-29 | Greenwood | South Carolina | 45047 | 46 | 0 |
103150 | 103150 | 2020-04-30 | Greenwood | South Carolina | 45047 | 49 | 0 |
106013 | 106013 | 2020-05-01 | Greenwood | South Carolina | 45047 | 49 | 0 |
108880 | 108880 | 2020-05-02 | Greenwood | South Carolina | 45047 | 53 | 0 |
111754 | 111754 | 2020-05-03 | Greenwood | South Carolina | 45047 | 55 | 0 |
114636 | 114636 | 2020-05-04 | Greenwood | South Carolina | 45047 | 55 | 0 |
117592 | 117592 | 2020-05-05 | Greenwood | South Carolina | 45047 | 57 | 0 |
120554 | 120554 | 2020-05-06 | Greenwood | South Carolina | 45047 | 61 | 0 |
123532 | 123532 | 2020-05-07 | Greenwood | South Carolina | 45047 | 61 | 0 |
126515 | 126515 | 2020-05-08 | Greenwood | South Carolina | 45047 | 62 | 0 |
129504 | 129504 | 2020-05-09 | Greenwood | South Carolina | 45047 | 62 | 0 |
132493 | 132493 | 2020-05-10 | Greenwood | South Carolina | 45047 | 62 | 0 |
135484 | 135484 | 2020-05-11 | Greenwood | South Carolina | 45047 | 63 | 0 |
138474 | 138474 | 2020-05-12 | Greenwood | South Carolina | 45047 | 63 | 0 |
141470 | 141470 | 2020-05-13 | Greenwood | South Carolina | 45047 | 67 | 0 |
144466 | 144466 | 2020-05-14 | Greenwood | South Carolina | 45047 | 68 | 1 |
147467 | 147467 | 2020-05-15 | Greenwood | South Carolina | 45047 | 69 | 1 |
150475 | 150475 | 2020-05-16 | Greenwood | South Carolina | 45047 | 69 | 1 |
153486 | 153486 | 2020-05-17 | Greenwood | South Carolina | 45047 | 69 | 1 |
156503 | 156503 | 2020-05-18 | Greenwood | South Carolina | 45047 | 71 | 1 |
159524 | 159524 | 2020-05-19 | Greenwood | South Carolina | 45047 | 72 | 1 |
162551 | 162551 | 2020-05-20 | Greenwood | South Carolina | 45047 | 72 | 1 |
165580 | 165580 | 2020-05-21 | Greenwood | South Carolina | 45047 | 76 | 1 |
168616 | 168616 | 2020-05-22 | Greenwood | South Carolina | 45047 | 79 | 1 |
171655 | 171655 | 2020-05-23 | Greenwood | South Carolina | 45047 | 82 | 1 |
174697 | 174697 | 2020-05-24 | Greenwood | South Carolina | 45047 | 82 | 1 |
177741 | 177741 | 2020-05-25 | Greenwood | South Carolina | 45047 | 82 | 1 |
180784 | 180784 | 2020-05-26 | Greenwood | South Carolina | 45047 | 92 | 1 |
183834 | 183834 | 2020-05-27 | Greenwood | South Carolina | 45047 | 103 | 1 |
186891 | 186891 | 2020-05-28 | Greenwood | South Carolina | 45047 | 121 | 1 |
189953 | 189953 | 2020-05-29 | Greenwood | South Carolina | 45047 | 128 | 1 |
193018 | 193018 | 2020-05-30 | Greenwood | South Carolina | 45047 | 129 | 1 |
196087 | 196087 | 2020-05-31 | Greenwood | South Carolina | 45047 | 142 | 1 |
199160 | 199160 | 2020-06-01 | Greenwood | South Carolina | 45047 | 147 | 1 |
202235 | 202235 | 2020-06-02 | Greenwood | South Carolina | 45047 | 148 | 1 |
205312 | 205312 | 2020-06-03 | Greenwood | South Carolina | 45047 | 150 | 2 |
208393 | 208393 | 2020-06-04 | Greenwood | South Carolina | 45047 | 159 | 2 |
211475 | 211475 | 2020-06-05 | Greenwood | South Carolina | 45047 | 160 | 2 |
214561 | 214561 | 2020-06-06 | Greenwood | South Carolina | 45047 | 172 | 3 |
217651 | 217651 | 2020-06-07 | Greenwood | South Carolina | 45047 | 172 | 3 |
220743 | 220743 | 2020-06-08 | Greenwood | South Carolina | 45047 | 183 | 3 |
223838 | 223838 | 2020-06-09 | Greenwood | South Carolina | 45047 | 198 | 4 |
226938 | 226938 | 2020-06-10 | Greenwood | South Carolina | 45047 | 199 | 4 |
230042 | 230042 | 2020-06-11 | Greenwood | South Carolina | 45047 | 235 | 5 |
233147 | 233147 | 2020-06-12 | Greenwood | South Carolina | 45047 | 259 | 5 |
236252 | 236252 | 2020-06-13 | Greenwood | South Carolina | 45047 | 273 | 5 |
239360 | 239360 | 2020-06-14 | Greenwood | South Carolina | 45047 | 304 | 5 |
242469 | 242469 | 2020-06-15 | Greenwood | South Carolina | 45047 | 312 | 5 |
245581 | 245581 | 2020-06-16 | Greenwood | South Carolina | 45047 | 315 | 5 |
248694 | 248694 | 2020-06-17 | Greenwood | South Carolina | 45047 | 320 | 5 |
251809 | 251809 | 2020-06-18 | Greenwood | South Carolina | 45047 | 322 | 5 |
254924 | 254924 | 2020-06-19 | Greenwood | South Carolina | 45047 | 345 | 5 |
258050 | 258050 | 2020-06-20 | Greenwood | South Carolina | 45047 | 353 | 5 |
261177 | 261177 | 2020-06-21 | Greenwood | South Carolina | 45047 | 371 | 5 |
264305 | 264305 | 2020-06-22 | Greenwood | South Carolina | 45047 | 374 | 5 |
267433 | 267433 | 2020-06-23 | Greenwood | South Carolina | 45047 | 382 | 6 |
270567 | 270567 | 2020-06-24 | Greenwood | South Carolina | 45047 | 392 | 6 |
273706 | 273706 | 2020-06-25 | Greenwood | South Carolina | 45047 | 402 | 6 |
276853 | 276853 | 2020-06-26 | Greenwood | South Carolina | 45047 | 405 | 6 |
280001 | 280001 | 2020-06-27 | Greenwood | South Carolina | 45047 | 448 | 7 |
283147 | 283147 | 2020-06-28 | Greenwood | South Carolina | 45047 | 458 | 7 |
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);