ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 45077 and state = "South Carolina" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
283162 | 283162 | 2020-06-28 | Pickens | South Carolina | 45077 | 778 | 4 |
286307 | 286307 | 2020-06-29 | Pickens | South Carolina | 45077 | 809 | 4 |
289458 | 289458 | 2020-06-30 | Pickens | South Carolina | 45077 | 835 | 5 |
292610 | 292610 | 2020-07-01 | Pickens | South Carolina | 45077 | 855 | 5 |
295766 | 295766 | 2020-07-02 | Pickens | South Carolina | 45077 | 896 | 5 |
298925 | 298925 | 2020-07-03 | Pickens | South Carolina | 45077 | 921 | 5 |
302089 | 302089 | 2020-07-04 | Pickens | South Carolina | 45077 | 942 | 5 |
305252 | 305252 | 2020-07-05 | Pickens | South Carolina | 45077 | 979 | 5 |
308419 | 308419 | 2020-07-06 | Pickens | South Carolina | 45077 | 1000 | 5 |
311588 | 311588 | 2020-07-07 | Pickens | South Carolina | 45077 | 1007 | 5 |
314760 | 314760 | 2020-07-08 | Pickens | South Carolina | 45077 | 1042 | 6 |
317933 | 317933 | 2020-07-09 | Pickens | South Carolina | 45077 | 1072 | 6 |
321111 | 321111 | 2020-07-10 | Pickens | South Carolina | 45077 | 1115 | 7 |
324291 | 324291 | 2020-07-11 | Pickens | South Carolina | 45077 | 1150 | 7 |
327476 | 327476 | 2020-07-12 | Pickens | South Carolina | 45077 | 1181 | 7 |
330662 | 330662 | 2020-07-13 | Pickens | South Carolina | 45077 | 1197 | 8 |
333854 | 333854 | 2020-07-14 | Pickens | South Carolina | 45077 | 1227 | 8 |
337048 | 337048 | 2020-07-15 | Pickens | South Carolina | 45077 | 1254 | 8 |
340245 | 340245 | 2020-07-16 | Pickens | South Carolina | 45077 | 1282 | 10 |
343443 | 343443 | 2020-07-17 | Pickens | South Carolina | 45077 | 1329 | 11 |
346643 | 346643 | 2020-07-18 | Pickens | South Carolina | 45077 | 1372 | 11 |
349843 | 349843 | 2020-07-19 | Pickens | South Carolina | 45077 | 1403 | 14 |
353046 | 353046 | 2020-07-20 | Pickens | South Carolina | 45077 | 1431 | 14 |
356249 | 356249 | 2020-07-21 | Pickens | South Carolina | 45077 | 1470 | 15 |
359453 | 359453 | 2020-07-22 | Pickens | South Carolina | 45077 | 1484 | 16 |
362659 | 362659 | 2020-07-23 | Pickens | South Carolina | 45077 | 1494 | 16 |
365865 | 365865 | 2020-07-24 | Pickens | South Carolina | 45077 | 1516 | 16 |
369074 | 369074 | 2020-07-25 | Pickens | South Carolina | 45077 | 1540 | 16 |
372286 | 372286 | 2020-07-26 | Pickens | South Carolina | 45077 | 1563 | 16 |
375499 | 375499 | 2020-07-27 | Pickens | South Carolina | 45077 | 1589 | 17 |
378715 | 378715 | 2020-07-28 | Pickens | South Carolina | 45077 | 1599 | 18 |
381932 | 381932 | 2020-07-29 | Pickens | South Carolina | 45077 | 1616 | 19 |
385150 | 385150 | 2020-07-30 | Pickens | South Carolina | 45077 | 1653 | 20 |
388367 | 388367 | 2020-07-31 | Pickens | South Carolina | 45077 | 1683 | 22 |
391584 | 391584 | 2020-08-01 | Pickens | South Carolina | 45077 | 1708 | 23 |
394800 | 394800 | 2020-08-02 | Pickens | South Carolina | 45077 | 1725 | 23 |
398017 | 398017 | 2020-08-03 | Pickens | South Carolina | 45077 | 1747 | 23 |
401232 | 401232 | 2020-08-04 | Pickens | South Carolina | 45077 | 1767 | 23 |
404450 | 404450 | 2020-08-05 | Pickens | South Carolina | 45077 | 1777 | 24 |
407669 | 407669 | 2020-08-06 | Pickens | South Carolina | 45077 | 1793 | 26 |
410889 | 410889 | 2020-08-07 | Pickens | South Carolina | 45077 | 1818 | 27 |
414109 | 414109 | 2020-08-08 | Pickens | South Carolina | 45077 | 1841 | 27 |
417330 | 417330 | 2020-08-09 | Pickens | South Carolina | 45077 | 1850 | 27 |
420550 | 420550 | 2020-08-10 | Pickens | South Carolina | 45077 | 1863 | 27 |
423773 | 423773 | 2020-08-11 | Pickens | South Carolina | 45077 | 1876 | 27 |
426996 | 426996 | 2020-08-12 | Pickens | South Carolina | 45077 | 1882 | 27 |
430221 | 430221 | 2020-08-13 | Pickens | South Carolina | 45077 | 1897 | 27 |
433447 | 433447 | 2020-08-14 | Pickens | South Carolina | 45077 | 1908 | 27 |
436674 | 436674 | 2020-08-15 | Pickens | South Carolina | 45077 | 1923 | 29 |
439899 | 439899 | 2020-08-16 | Pickens | South Carolina | 45077 | 1929 | 29 |
443126 | 443126 | 2020-08-17 | Pickens | South Carolina | 45077 | 1934 | 30 |
446352 | 446352 | 2020-08-18 | Pickens | South Carolina | 45077 | 1942 | 30 |
449580 | 449580 | 2020-08-19 | Pickens | South Carolina | 45077 | 1949 | 30 |
452808 | 452808 | 2020-08-20 | Pickens | South Carolina | 45077 | 1964 | 30 |
456036 | 456036 | 2020-08-21 | Pickens | South Carolina | 45077 | 1993 | 30 |
459264 | 459264 | 2020-08-22 | Pickens | South Carolina | 45077 | 2009 | 30 |
462492 | 462492 | 2020-08-23 | Pickens | South Carolina | 45077 | 2033 | 31 |
465721 | 465721 | 2020-08-24 | Pickens | South Carolina | 45077 | 2047 | 31 |
468949 | 468949 | 2020-08-25 | Pickens | South Carolina | 45077 | 2100 | 31 |
472181 | 472181 | 2020-08-26 | Pickens | South Carolina | 45077 | 2113 | 31 |
475415 | 475415 | 2020-08-27 | Pickens | South Carolina | 45077 | 2118 | 33 |
478648 | 478648 | 2020-08-28 | Pickens | South Carolina | 45077 | 2147 | 34 |
481882 | 481882 | 2020-08-29 | Pickens | South Carolina | 45077 | 2162 | 35 |
485117 | 485117 | 2020-08-30 | Pickens | South Carolina | 45077 | 2180 | 35 |
488350 | 488350 | 2020-08-31 | Pickens | South Carolina | 45077 | 2194 | 35 |
491583 | 491583 | 2020-09-01 | Pickens | South Carolina | 45077 | 2212 | 35 |
494817 | 494817 | 2020-09-02 | Pickens | South Carolina | 45077 | 2241 | 35 |
498050 | 498050 | 2020-09-03 | Pickens | South Carolina | 45077 | 2320 | 35 |
501284 | 501284 | 2020-09-04 | Pickens | South Carolina | 45077 | 2338 | 36 |
504518 | 504518 | 2020-09-05 | Pickens | South Carolina | 45077 | 2359 | 36 |
507750 | 507750 | 2020-09-06 | Pickens | South Carolina | 45077 | 2407 | 36 |
510983 | 510983 | 2020-09-07 | Pickens | South Carolina | 45077 | 2429 | 36 |
514216 | 514216 | 2020-09-08 | Pickens | South Carolina | 45077 | 2443 | 36 |
517451 | 517451 | 2020-09-09 | Pickens | South Carolina | 45077 | 2445 | 36 |
520687 | 520687 | 2020-09-10 | Pickens | South Carolina | 45077 | 2462 | 37 |
523923 | 523923 | 2020-09-11 | Pickens | South Carolina | 45077 | 2525 | 38 |
527159 | 527159 | 2020-09-12 | Pickens | South Carolina | 45077 | 2550 | 38 |
530396 | 530396 | 2020-09-13 | Pickens | South Carolina | 45077 | 2596 | 39 |
533631 | 533631 | 2020-09-14 | Pickens | South Carolina | 45077 | 2617 | 39 |
536867 | 536867 | 2020-09-15 | Pickens | South Carolina | 45077 | 2640 | 40 |
540104 | 540104 | 2020-09-16 | Pickens | South Carolina | 45077 | 2660 | 40 |
543340 | 543340 | 2020-09-17 | Pickens | South Carolina | 45077 | 2691 | 40 |
546577 | 546577 | 2020-09-18 | Pickens | South Carolina | 45077 | 2706 | 41 |
549816 | 549816 | 2020-09-19 | Pickens | South Carolina | 45077 | 2720 | 41 |
553055 | 553055 | 2020-09-20 | Pickens | South Carolina | 45077 | 2743 | 42 |
556292 | 556292 | 2020-09-21 | Pickens | South Carolina | 45077 | 2750 | 42 |
559529 | 559529 | 2020-09-22 | Pickens | South Carolina | 45077 | 2774 | 44 |
562766 | 562766 | 2020-09-23 | Pickens | South Carolina | 45077 | 2800 | 45 |
566007 | 566007 | 2020-09-24 | Pickens | South Carolina | 45077 | 2821 | 45 |
569248 | 569248 | 2020-09-25 | Pickens | South Carolina | 45077 | 2848 | 45 |
572490 | 572490 | 2020-09-26 | Pickens | South Carolina | 45077 | 2924 | 45 |
575734 | 575734 | 2020-09-27 | Pickens | South Carolina | 45077 | 2937 | 45 |
578975 | 578975 | 2020-09-28 | Pickens | South Carolina | 45077 | 2951 | 45 |
582215 | 582215 | 2020-09-29 | Pickens | South Carolina | 45077 | 3152 | 45 |
585455 | 585455 | 2020-09-30 | Pickens | South Carolina | 45077 | 3155 | 45 |
588695 | 588695 | 2020-10-01 | Pickens | South Carolina | 45077 | 3169 | 45 |
591936 | 591936 | 2020-10-02 | Pickens | South Carolina | 45077 | 3210 | 45 |
595177 | 595177 | 2020-10-03 | Pickens | South Carolina | 45077 | 3295 | 47 |
598420 | 598420 | 2020-10-04 | Pickens | South Carolina | 45077 | 3334 | 47 |
601663 | 601663 | 2020-10-05 | Pickens | South Carolina | 45077 | 3361 | 47 |
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);