ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "York" 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 |
---|---|---|---|---|---|---|---|
388374 | 388374 | 2020-07-31 | York | South Carolina | 45091 | 3077 | 27 |
385157 | 385157 | 2020-07-30 | York | South Carolina | 45091 | 3022 | 27 |
381939 | 381939 | 2020-07-29 | York | South Carolina | 45091 | 2972 | 26 |
378722 | 378722 | 2020-07-28 | York | South Carolina | 45091 | 2934 | 25 |
375506 | 375506 | 2020-07-27 | York | South Carolina | 45091 | 2858 | 24 |
372293 | 372293 | 2020-07-26 | York | South Carolina | 45091 | 2816 | 24 |
369081 | 369081 | 2020-07-25 | York | South Carolina | 45091 | 2792 | 23 |
365872 | 365872 | 2020-07-24 | York | South Carolina | 45091 | 2726 | 18 |
362666 | 362666 | 2020-07-23 | York | South Carolina | 45091 | 2667 | 18 |
359460 | 359460 | 2020-07-22 | York | South Carolina | 45091 | 2571 | 17 |
356256 | 356256 | 2020-07-21 | York | South Carolina | 45091 | 2514 | 16 |
353053 | 353053 | 2020-07-20 | York | South Carolina | 45091 | 2438 | 14 |
349850 | 349850 | 2020-07-19 | York | South Carolina | 45091 | 2390 | 14 |
346650 | 346650 | 2020-07-18 | York | South Carolina | 45091 | 2232 | 14 |
343450 | 343450 | 2020-07-17 | York | South Carolina | 45091 | 2203 | 14 |
340252 | 340252 | 2020-07-16 | York | South Carolina | 45091 | 2138 | 13 |
337055 | 337055 | 2020-07-15 | York | South Carolina | 45091 | 2062 | 13 |
333861 | 333861 | 2020-07-14 | York | South Carolina | 45091 | 1989 | 13 |
330669 | 330669 | 2020-07-13 | York | South Carolina | 45091 | 1949 | 13 |
327483 | 327483 | 2020-07-12 | York | South Carolina | 45091 | 1885 | 12 |
324298 | 324298 | 2020-07-11 | York | South Carolina | 45091 | 1839 | 12 |
321118 | 321118 | 2020-07-10 | York | South Carolina | 45091 | 1760 | 12 |
317940 | 317940 | 2020-07-09 | York | South Carolina | 45091 | 1685 | 12 |
314767 | 314767 | 2020-07-08 | York | South Carolina | 45091 | 1618 | 12 |
311595 | 311595 | 2020-07-07 | York | South Carolina | 45091 | 1573 | 12 |
308426 | 308426 | 2020-07-06 | York | South Carolina | 45091 | 1544 | 12 |
305259 | 305259 | 2020-07-05 | York | South Carolina | 45091 | 1483 | 12 |
302096 | 302096 | 2020-07-04 | York | South Carolina | 45091 | 1456 | 12 |
298932 | 298932 | 2020-07-03 | York | South Carolina | 45091 | 1406 | 12 |
295773 | 295773 | 2020-07-02 | York | South Carolina | 45091 | 1301 | 12 |
292617 | 292617 | 2020-07-01 | York | South Carolina | 45091 | 1257 | 12 |
289465 | 289465 | 2020-06-30 | York | South Carolina | 45091 | 1204 | 12 |
286314 | 286314 | 2020-06-29 | York | South Carolina | 45091 | 1156 | 12 |
283169 | 283169 | 2020-06-28 | York | South Carolina | 45091 | 1095 | 12 |
280023 | 280023 | 2020-06-27 | York | South Carolina | 45091 | 1047 | 12 |
276875 | 276875 | 2020-06-26 | York | South Carolina | 45091 | 989 | 12 |
273728 | 273728 | 2020-06-25 | York | South Carolina | 45091 | 947 | 12 |
270589 | 270589 | 2020-06-24 | York | South Carolina | 45091 | 914 | 11 |
267455 | 267455 | 2020-06-23 | York | South Carolina | 45091 | 886 | 11 |
264327 | 264327 | 2020-06-22 | York | South Carolina | 45091 | 860 | 11 |
261199 | 261199 | 2020-06-21 | York | South Carolina | 45091 | 814 | 11 |
258072 | 258072 | 2020-06-20 | York | South Carolina | 45091 | 783 | 11 |
254946 | 254946 | 2020-06-19 | York | South Carolina | 45091 | 741 | 11 |
251831 | 251831 | 2020-06-18 | York | South Carolina | 45091 | 729 | 11 |
248716 | 248716 | 2020-06-17 | York | South Carolina | 45091 | 700 | 11 |
245603 | 245603 | 2020-06-16 | York | South Carolina | 45091 | 686 | 10 |
242491 | 242491 | 2020-06-15 | York | South Carolina | 45091 | 652 | 10 |
239382 | 239382 | 2020-06-14 | York | South Carolina | 45091 | 636 | 10 |
236274 | 236274 | 2020-06-13 | York | South Carolina | 45091 | 613 | 10 |
233169 | 233169 | 2020-06-12 | York | South Carolina | 45091 | 580 | 10 |
230064 | 230064 | 2020-06-11 | York | South Carolina | 45091 | 557 | 10 |
226960 | 226960 | 2020-06-10 | York | South Carolina | 45091 | 536 | 10 |
223860 | 223860 | 2020-06-09 | York | South Carolina | 45091 | 510 | 10 |
220765 | 220765 | 2020-06-08 | York | South Carolina | 45091 | 486 | 10 |
217673 | 217673 | 2020-06-07 | York | South Carolina | 45091 | 465 | 10 |
214583 | 214583 | 2020-06-06 | York | South Carolina | 45091 | 458 | 10 |
211497 | 211497 | 2020-06-05 | York | South Carolina | 45091 | 446 | 10 |
208415 | 208415 | 2020-06-04 | York | South Carolina | 45091 | 433 | 10 |
205334 | 205334 | 2020-06-03 | York | South Carolina | 45091 | 426 | 10 |
202257 | 202257 | 2020-06-02 | York | South Carolina | 45091 | 421 | 8 |
199182 | 199182 | 2020-06-01 | York | South Carolina | 45091 | 417 | 8 |
196109 | 196109 | 2020-05-31 | York | South Carolina | 45091 | 407 | 8 |
193040 | 193040 | 2020-05-30 | York | South Carolina | 45091 | 398 | 7 |
189975 | 189975 | 2020-05-29 | York | South Carolina | 45091 | 385 | 7 |
186913 | 186913 | 2020-05-28 | York | South Carolina | 45091 | 371 | 7 |
183856 | 183856 | 2020-05-27 | York | South Carolina | 45091 | 363 | 6 |
180806 | 180806 | 2020-05-26 | York | South Carolina | 45091 | 352 | 6 |
177763 | 177763 | 2020-05-25 | York | South Carolina | 45091 | 346 | 6 |
174719 | 174719 | 2020-05-24 | York | South Carolina | 45091 | 340 | 6 |
171677 | 171677 | 2020-05-23 | York | South Carolina | 45091 | 339 | 6 |
168638 | 168638 | 2020-05-22 | York | South Carolina | 45091 | 329 | 5 |
165602 | 165602 | 2020-05-21 | York | South Carolina | 45091 | 324 | 5 |
162573 | 162573 | 2020-05-20 | York | South Carolina | 45091 | 317 | 5 |
159546 | 159546 | 2020-05-19 | York | South Carolina | 45091 | 308 | 5 |
156525 | 156525 | 2020-05-18 | York | South Carolina | 45091 | 304 | 5 |
153508 | 153508 | 2020-05-17 | York | South Carolina | 45091 | 293 | 5 |
150497 | 150497 | 2020-05-16 | York | South Carolina | 45091 | 290 | 5 |
147489 | 147489 | 2020-05-15 | York | South Carolina | 45091 | 280 | 5 |
144488 | 144488 | 2020-05-14 | York | South Carolina | 45091 | 272 | 5 |
141492 | 141492 | 2020-05-13 | York | South Carolina | 45091 | 265 | 5 |
138496 | 138496 | 2020-05-12 | York | South Carolina | 45091 | 258 | 5 |
135506 | 135506 | 2020-05-11 | York | South Carolina | 45091 | 242 | 5 |
132515 | 132515 | 2020-05-10 | York | South Carolina | 45091 | 238 | 5 |
129526 | 129526 | 2020-05-09 | York | South Carolina | 45091 | 237 | 5 |
126537 | 126537 | 2020-05-08 | York | South Carolina | 45091 | 233 | 5 |
123554 | 123554 | 2020-05-07 | York | South Carolina | 45091 | 225 | 5 |
120576 | 120576 | 2020-05-06 | York | South Carolina | 45091 | 222 | 5 |
117614 | 117614 | 2020-05-05 | York | South Carolina | 45091 | 219 | 4 |
114658 | 114658 | 2020-05-04 | York | South Carolina | 45091 | 222 | 3 |
111776 | 111776 | 2020-05-03 | York | South Carolina | 45091 | 221 | 3 |
108902 | 108902 | 2020-05-02 | York | South Carolina | 45091 | 219 | 3 |
106035 | 106035 | 2020-05-01 | York | South Carolina | 45091 | 215 | 3 |
103172 | 103172 | 2020-04-30 | York | South Carolina | 45091 | 210 | 3 |
100319 | 100319 | 2020-04-29 | York | South Carolina | 45091 | 197 | 3 |
97470 | 97470 | 2020-04-28 | York | South Carolina | 45091 | 188 | 3 |
94631 | 94631 | 2020-04-27 | York | South Carolina | 45091 | 186 | 3 |
91804 | 91804 | 2020-04-26 | York | South Carolina | 45091 | 181 | 3 |
88988 | 88988 | 2020-04-25 | York | South Carolina | 45091 | 177 | 3 |
86174 | 86174 | 2020-04-24 | York | South Carolina | 45091 | 172 | 3 |
83370 | 83370 | 2020-04-23 | York | South Carolina | 45091 | 171 | 3 |
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);