ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where county = "Spartanburg" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
245599 | 245599 | 2020-06-16 | Spartanburg | South Carolina | 45083 | 1026 | 37 |
248712 | 248712 | 2020-06-17 | Spartanburg | South Carolina | 45083 | 1046 | 36 |
251827 | 251827 | 2020-06-18 | Spartanburg | South Carolina | 45083 | 1088 | 36 |
254942 | 254942 | 2020-06-19 | Spartanburg | South Carolina | 45083 | 1146 | 38 |
258068 | 258068 | 2020-06-20 | Spartanburg | South Carolina | 45083 | 1183 | 38 |
261195 | 261195 | 2020-06-21 | Spartanburg | South Carolina | 45083 | 1200 | 39 |
264323 | 264323 | 2020-06-22 | Spartanburg | South Carolina | 45083 | 1247 | 39 |
267451 | 267451 | 2020-06-23 | Spartanburg | South Carolina | 45083 | 1257 | 42 |
270585 | 270585 | 2020-06-24 | Spartanburg | South Carolina | 45083 | 1278 | 44 |
273724 | 273724 | 2020-06-25 | Spartanburg | South Carolina | 45083 | 1312 | 44 |
276871 | 276871 | 2020-06-26 | Spartanburg | South Carolina | 45083 | 1369 | 44 |
280019 | 280019 | 2020-06-27 | Spartanburg | South Carolina | 45083 | 1429 | 45 |
283165 | 283165 | 2020-06-28 | Spartanburg | South Carolina | 45083 | 1472 | 45 |
286310 | 286310 | 2020-06-29 | Spartanburg | South Carolina | 45083 | 1544 | 45 |
289461 | 289461 | 2020-06-30 | Spartanburg | South Carolina | 45083 | 1609 | 48 |
292613 | 292613 | 2020-07-01 | Spartanburg | South Carolina | 45083 | 1663 | 48 |
295769 | 295769 | 2020-07-02 | Spartanburg | South Carolina | 45083 | 1767 | 49 |
298928 | 298928 | 2020-07-03 | Spartanburg | South Carolina | 45083 | 1798 | 49 |
302092 | 302092 | 2020-07-04 | Spartanburg | South Carolina | 45083 | 1835 | 50 |
305255 | 305255 | 2020-07-05 | Spartanburg | South Carolina | 45083 | 1892 | 52 |
308422 | 308422 | 2020-07-06 | Spartanburg | South Carolina | 45083 | 1955 | 52 |
311591 | 311591 | 2020-07-07 | Spartanburg | South Carolina | 45083 | 2009 | 52 |
314763 | 314763 | 2020-07-08 | Spartanburg | South Carolina | 45083 | 2083 | 57 |
317936 | 317936 | 2020-07-09 | Spartanburg | South Carolina | 45083 | 2158 | 58 |
321114 | 321114 | 2020-07-10 | Spartanburg | South Carolina | 45083 | 2238 | 58 |
324294 | 324294 | 2020-07-11 | Spartanburg | South Carolina | 45083 | 2363 | 58 |
327479 | 327479 | 2020-07-12 | Spartanburg | South Carolina | 45083 | 2460 | 58 |
330665 | 330665 | 2020-07-13 | Spartanburg | South Carolina | 45083 | 2562 | 58 |
333857 | 333857 | 2020-07-14 | Spartanburg | South Carolina | 45083 | 2648 | 57 |
337051 | 337051 | 2020-07-15 | Spartanburg | South Carolina | 45083 | 2745 | 57 |
340248 | 340248 | 2020-07-16 | Spartanburg | South Carolina | 45083 | 2826 | 59 |
343446 | 343446 | 2020-07-17 | Spartanburg | South Carolina | 45083 | 2905 | 61 |
346646 | 346646 | 2020-07-18 | Spartanburg | South Carolina | 45083 | 2950 | 62 |
349846 | 349846 | 2020-07-19 | Spartanburg | South Carolina | 45083 | 3041 | 63 |
353049 | 353049 | 2020-07-20 | Spartanburg | South Carolina | 45083 | 3117 | 64 |
356252 | 356252 | 2020-07-21 | Spartanburg | South Carolina | 45083 | 3166 | 67 |
359456 | 359456 | 2020-07-22 | Spartanburg | South Carolina | 45083 | 3252 | 68 |
362662 | 362662 | 2020-07-23 | Spartanburg | South Carolina | 45083 | 3298 | 69 |
365868 | 365868 | 2020-07-24 | Spartanburg | South Carolina | 45083 | 3347 | 71 |
369077 | 369077 | 2020-07-25 | Spartanburg | South Carolina | 45083 | 3405 | 74 |
372289 | 372289 | 2020-07-26 | Spartanburg | South Carolina | 45083 | 3432 | 75 |
375502 | 375502 | 2020-07-27 | Spartanburg | South Carolina | 45083 | 3450 | 75 |
378718 | 378718 | 2020-07-28 | Spartanburg | South Carolina | 45083 | 3486 | 81 |
381935 | 381935 | 2020-07-29 | Spartanburg | South Carolina | 45083 | 3544 | 81 |
385153 | 385153 | 2020-07-30 | Spartanburg | South Carolina | 45083 | 3609 | 81 |
388370 | 388370 | 2020-07-31 | Spartanburg | South Carolina | 45083 | 3656 | 82 |
391587 | 391587 | 2020-08-01 | Spartanburg | South Carolina | 45083 | 3700 | 82 |
394803 | 394803 | 2020-08-02 | Spartanburg | South Carolina | 45083 | 3741 | 85 |
398020 | 398020 | 2020-08-03 | Spartanburg | South Carolina | 45083 | 3793 | 87 |
401235 | 401235 | 2020-08-04 | Spartanburg | South Carolina | 45083 | 3838 | 92 |
404453 | 404453 | 2020-08-05 | Spartanburg | South Carolina | 45083 | 3898 | 94 |
407672 | 407672 | 2020-08-06 | Spartanburg | South Carolina | 45083 | 3961 | 98 |
410892 | 410892 | 2020-08-07 | Spartanburg | South Carolina | 45083 | 4005 | 99 |
414112 | 414112 | 2020-08-08 | Spartanburg | South Carolina | 45083 | 4057 | 101 |
417333 | 417333 | 2020-08-09 | Spartanburg | South Carolina | 45083 | 4080 | 103 |
420553 | 420553 | 2020-08-10 | Spartanburg | South Carolina | 45083 | 4100 | 103 |
423776 | 423776 | 2020-08-11 | Spartanburg | South Carolina | 45083 | 4172 | 102 |
426999 | 426999 | 2020-08-12 | Spartanburg | South Carolina | 45083 | 4222 | 108 |
430224 | 430224 | 2020-08-13 | Spartanburg | South Carolina | 45083 | 4299 | 111 |
433450 | 433450 | 2020-08-14 | Spartanburg | South Carolina | 45083 | 4335 | 111 |
436677 | 436677 | 2020-08-15 | Spartanburg | South Carolina | 45083 | 4360 | 114 |
439902 | 439902 | 2020-08-16 | Spartanburg | South Carolina | 45083 | 4389 | 114 |
443129 | 443129 | 2020-08-17 | Spartanburg | South Carolina | 45083 | 4400 | 115 |
446355 | 446355 | 2020-08-18 | Spartanburg | South Carolina | 45083 | 4469 | 118 |
449583 | 449583 | 2020-08-19 | Spartanburg | South Carolina | 45083 | 4526 | 121 |
452811 | 452811 | 2020-08-20 | Spartanburg | South Carolina | 45083 | 4559 | 123 |
456039 | 456039 | 2020-08-21 | Spartanburg | South Carolina | 45083 | 4651 | 126 |
459267 | 459267 | 2020-08-22 | Spartanburg | South Carolina | 45083 | 4685 | 127 |
462495 | 462495 | 2020-08-23 | Spartanburg | South Carolina | 45083 | 4702 | 127 |
465724 | 465724 | 2020-08-24 | Spartanburg | South Carolina | 45083 | 4715 | 127 |
468952 | 468952 | 2020-08-25 | Spartanburg | South Carolina | 45083 | 4778 | 127 |
472184 | 472184 | 2020-08-26 | Spartanburg | South Carolina | 45083 | 4804 | 132 |
475418 | 475418 | 2020-08-27 | Spartanburg | South Carolina | 45083 | 4823 | 142 |
478651 | 478651 | 2020-08-28 | Spartanburg | South Carolina | 45083 | 4896 | 143 |
481885 | 481885 | 2020-08-29 | Spartanburg | South Carolina | 45083 | 4969 | 148 |
485120 | 485120 | 2020-08-30 | Spartanburg | South Carolina | 45083 | 4994 | 149 |
488353 | 488353 | 2020-08-31 | Spartanburg | South Carolina | 45083 | 5016 | 150 |
491586 | 491586 | 2020-09-01 | Spartanburg | South Carolina | 45083 | 5047 | 157 |
494820 | 494820 | 2020-09-02 | Spartanburg | South Carolina | 45083 | 5128 | 163 |
498053 | 498053 | 2020-09-03 | Spartanburg | South Carolina | 45083 | 5227 | 163 |
501287 | 501287 | 2020-09-04 | Spartanburg | South Carolina | 45083 | 5442 | 166 |
504521 | 504521 | 2020-09-05 | Spartanburg | South Carolina | 45083 | 5540 | 171 |
507753 | 507753 | 2020-09-06 | Spartanburg | South Carolina | 45083 | 5579 | 172 |
510986 | 510986 | 2020-09-07 | Spartanburg | South Carolina | 45083 | 5593 | 172 |
514219 | 514219 | 2020-09-08 | Spartanburg | South Carolina | 45083 | 5603 | 172 |
517454 | 517454 | 2020-09-09 | Spartanburg | South Carolina | 45083 | 5617 | 175 |
520690 | 520690 | 2020-09-10 | Spartanburg | South Carolina | 45083 | 5625 | 174 |
523926 | 523926 | 2020-09-11 | Spartanburg | South Carolina | 45083 | 5786 | 180 |
527162 | 527162 | 2020-09-12 | Spartanburg | South Carolina | 45083 | 5872 | 181 |
530399 | 530399 | 2020-09-13 | Spartanburg | South Carolina | 45083 | 5977 | 181 |
533634 | 533634 | 2020-09-14 | Spartanburg | South Carolina | 45083 | 5996 | 181 |
536870 | 536870 | 2020-09-15 | Spartanburg | South Carolina | 45083 | 6044 | 185 |
540107 | 540107 | 2020-09-16 | Spartanburg | South Carolina | 45083 | 6156 | 185 |
543343 | 543343 | 2020-09-17 | Spartanburg | South Carolina | 45083 | 6261 | 187 |
546580 | 546580 | 2020-09-18 | Spartanburg | South Carolina | 45083 | 6312 | 189 |
549819 | 549819 | 2020-09-19 | Spartanburg | South Carolina | 45083 | 6352 | 189 |
553058 | 553058 | 2020-09-20 | Spartanburg | South Carolina | 45083 | 6354 | 189 |
556295 | 556295 | 2020-09-21 | Spartanburg | South Carolina | 45083 | 6361 | 189 |
559532 | 559532 | 2020-09-22 | Spartanburg | South Carolina | 45083 | 6483 | 192 |
562769 | 562769 | 2020-09-23 | Spartanburg | South Carolina | 45083 | 6565 | 192 |
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);