ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 45003 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 |
---|---|---|---|---|---|---|---|
637299 | 637299 | 2020-10-16 | Aiken | South Carolina | 45003 | 4713 | 85 |
634053 | 634053 | 2020-10-15 | Aiken | South Carolina | 45003 | 4683 | 85 |
630808 | 630808 | 2020-10-14 | Aiken | South Carolina | 45003 | 4644 | 85 |
627564 | 627564 | 2020-10-13 | Aiken | South Carolina | 45003 | 4542 | 85 |
624322 | 624322 | 2020-10-12 | Aiken | South Carolina | 45003 | 4526 | 85 |
621079 | 621079 | 2020-10-11 | Aiken | South Carolina | 45003 | 4509 | 85 |
617836 | 617836 | 2020-10-10 | Aiken | South Carolina | 45003 | 4496 | 85 |
614594 | 614594 | 2020-10-09 | Aiken | South Carolina | 45003 | 4474 | 85 |
611353 | 611353 | 2020-10-08 | Aiken | South Carolina | 45003 | 4462 | 85 |
608111 | 608111 | 2020-10-07 | Aiken | South Carolina | 45003 | 4432 | 85 |
604868 | 604868 | 2020-10-06 | Aiken | South Carolina | 45003 | 4417 | 84 |
601626 | 601626 | 2020-10-05 | Aiken | South Carolina | 45003 | 4399 | 84 |
598383 | 598383 | 2020-10-04 | Aiken | South Carolina | 45003 | 4384 | 84 |
595140 | 595140 | 2020-10-03 | Aiken | South Carolina | 45003 | 4377 | 84 |
591899 | 591899 | 2020-10-02 | Aiken | South Carolina | 45003 | 4319 | 82 |
588658 | 588658 | 2020-10-01 | Aiken | South Carolina | 45003 | 4290 | 82 |
585418 | 585418 | 2020-09-30 | Aiken | South Carolina | 45003 | 4281 | 82 |
582178 | 582178 | 2020-09-29 | Aiken | South Carolina | 45003 | 4208 | 82 |
578938 | 578938 | 2020-09-28 | Aiken | South Carolina | 45003 | 4160 | 82 |
575697 | 575697 | 2020-09-27 | Aiken | South Carolina | 45003 | 4149 | 82 |
572453 | 572453 | 2020-09-26 | Aiken | South Carolina | 45003 | 4135 | 81 |
569211 | 569211 | 2020-09-25 | Aiken | South Carolina | 45003 | 4092 | 81 |
565970 | 565970 | 2020-09-24 | Aiken | South Carolina | 45003 | 4053 | 80 |
562729 | 562729 | 2020-09-23 | Aiken | South Carolina | 45003 | 4025 | 79 |
559492 | 559492 | 2020-09-22 | Aiken | South Carolina | 45003 | 3999 | 78 |
556255 | 556255 | 2020-09-21 | Aiken | South Carolina | 45003 | 2681 | 77 |
553018 | 553018 | 2020-09-20 | Aiken | South Carolina | 45003 | 2671 | 77 |
549779 | 549779 | 2020-09-19 | Aiken | South Carolina | 45003 | 2619 | 77 |
546540 | 546540 | 2020-09-18 | Aiken | South Carolina | 45003 | 2596 | 77 |
543303 | 543303 | 2020-09-17 | Aiken | South Carolina | 45003 | 2577 | 78 |
540067 | 540067 | 2020-09-16 | Aiken | South Carolina | 45003 | 2556 | 77 |
536830 | 536830 | 2020-09-15 | Aiken | South Carolina | 45003 | 2540 | 77 |
533594 | 533594 | 2020-09-14 | Aiken | South Carolina | 45003 | 2525 | 76 |
530359 | 530359 | 2020-09-13 | Aiken | South Carolina | 45003 | 2511 | 76 |
527122 | 527122 | 2020-09-12 | Aiken | South Carolina | 45003 | 2502 | 76 |
523886 | 523886 | 2020-09-11 | Aiken | South Carolina | 45003 | 2485 | 74 |
520650 | 520650 | 2020-09-10 | Aiken | South Carolina | 45003 | 2473 | 71 |
517414 | 517414 | 2020-09-09 | Aiken | South Carolina | 45003 | 2464 | 69 |
514179 | 514179 | 2020-09-08 | Aiken | South Carolina | 45003 | 2457 | 68 |
510946 | 510946 | 2020-09-07 | Aiken | South Carolina | 45003 | 2451 | 68 |
507713 | 507713 | 2020-09-06 | Aiken | South Carolina | 45003 | 2444 | 68 |
504481 | 504481 | 2020-09-05 | Aiken | South Carolina | 45003 | 2432 | 67 |
501247 | 501247 | 2020-09-04 | Aiken | South Carolina | 45003 | 2420 | 68 |
498013 | 498013 | 2020-09-03 | Aiken | South Carolina | 45003 | 2409 | 67 |
494780 | 494780 | 2020-09-02 | Aiken | South Carolina | 45003 | 2378 | 65 |
491546 | 491546 | 2020-09-01 | Aiken | South Carolina | 45003 | 2369 | 64 |
488313 | 488313 | 2020-08-31 | Aiken | South Carolina | 45003 | 2364 | 63 |
485080 | 485080 | 2020-08-30 | Aiken | South Carolina | 45003 | 2354 | 63 |
481845 | 481845 | 2020-08-29 | Aiken | South Carolina | 45003 | 2325 | 63 |
478611 | 478611 | 2020-08-28 | Aiken | South Carolina | 45003 | 2312 | 62 |
475378 | 475378 | 2020-08-27 | Aiken | South Carolina | 45003 | 2293 | 57 |
472144 | 472144 | 2020-08-26 | Aiken | South Carolina | 45003 | 2277 | 57 |
468912 | 468912 | 2020-08-25 | Aiken | South Carolina | 45003 | 2255 | 57 |
465684 | 465684 | 2020-08-24 | Aiken | South Carolina | 45003 | 2239 | 56 |
462455 | 462455 | 2020-08-23 | Aiken | South Carolina | 45003 | 2237 | 56 |
459227 | 459227 | 2020-08-22 | Aiken | South Carolina | 45003 | 2224 | 56 |
455999 | 455999 | 2020-08-21 | Aiken | South Carolina | 45003 | 2207 | 53 |
452771 | 452771 | 2020-08-20 | Aiken | South Carolina | 45003 | 2184 | 51 |
449543 | 449543 | 2020-08-19 | Aiken | South Carolina | 45003 | 2172 | 50 |
446315 | 446315 | 2020-08-18 | Aiken | South Carolina | 45003 | 2155 | 49 |
443089 | 443089 | 2020-08-17 | Aiken | South Carolina | 45003 | 2137 | 46 |
439862 | 439862 | 2020-08-16 | Aiken | South Carolina | 45003 | 2121 | 46 |
436637 | 436637 | 2020-08-15 | Aiken | South Carolina | 45003 | 2096 | 46 |
433410 | 433410 | 2020-08-14 | Aiken | South Carolina | 45003 | 2047 | 44 |
430184 | 430184 | 2020-08-13 | Aiken | South Carolina | 45003 | 2017 | 42 |
426959 | 426959 | 2020-08-12 | Aiken | South Carolina | 45003 | 1991 | 42 |
423736 | 423736 | 2020-08-11 | Aiken | South Carolina | 45003 | 1934 | 39 |
420513 | 420513 | 2020-08-10 | Aiken | South Carolina | 45003 | 1883 | 38 |
417293 | 417293 | 2020-08-09 | Aiken | South Carolina | 45003 | 1868 | 38 |
414072 | 414072 | 2020-08-08 | Aiken | South Carolina | 45003 | 1843 | 37 |
410852 | 410852 | 2020-08-07 | Aiken | South Carolina | 45003 | 1810 | 34 |
407632 | 407632 | 2020-08-06 | Aiken | South Carolina | 45003 | 1788 | 33 |
404413 | 404413 | 2020-08-05 | Aiken | South Carolina | 45003 | 1706 | 33 |
401195 | 401195 | 2020-08-04 | Aiken | South Carolina | 45003 | 1638 | 31 |
397980 | 397980 | 2020-08-03 | Aiken | South Carolina | 45003 | 1594 | 29 |
394763 | 394763 | 2020-08-02 | Aiken | South Carolina | 45003 | 1575 | 26 |
391547 | 391547 | 2020-08-01 | Aiken | South Carolina | 45003 | 1538 | 26 |
388330 | 388330 | 2020-07-31 | Aiken | South Carolina | 45003 | 1491 | 24 |
385113 | 385113 | 2020-07-30 | Aiken | South Carolina | 45003 | 1444 | 24 |
381895 | 381895 | 2020-07-29 | Aiken | South Carolina | 45003 | 1403 | 24 |
378678 | 378678 | 2020-07-28 | Aiken | South Carolina | 45003 | 1355 | 23 |
375462 | 375462 | 2020-07-27 | Aiken | South Carolina | 45003 | 1301 | 23 |
372249 | 372249 | 2020-07-26 | Aiken | South Carolina | 45003 | 1260 | 23 |
369037 | 369037 | 2020-07-25 | Aiken | South Carolina | 45003 | 1199 | 23 |
365828 | 365828 | 2020-07-24 | Aiken | South Carolina | 45003 | 1162 | 22 |
362622 | 362622 | 2020-07-23 | Aiken | South Carolina | 45003 | 1123 | 20 |
359416 | 359416 | 2020-07-22 | Aiken | South Carolina | 45003 | 1109 | 20 |
356212 | 356212 | 2020-07-21 | Aiken | South Carolina | 45003 | 1061 | 18 |
353009 | 353009 | 2020-07-20 | Aiken | South Carolina | 45003 | 1049 | 15 |
349806 | 349806 | 2020-07-19 | Aiken | South Carolina | 45003 | 1027 | 15 |
346606 | 346606 | 2020-07-18 | Aiken | South Carolina | 45003 | 992 | 15 |
343406 | 343406 | 2020-07-17 | Aiken | South Carolina | 45003 | 924 | 14 |
340208 | 340208 | 2020-07-16 | Aiken | South Carolina | 45003 | 903 | 13 |
337011 | 337011 | 2020-07-15 | Aiken | South Carolina | 45003 | 873 | 13 |
333817 | 333817 | 2020-07-14 | Aiken | South Carolina | 45003 | 800 | 13 |
330625 | 330625 | 2020-07-13 | Aiken | South Carolina | 45003 | 735 | 13 |
327439 | 327439 | 2020-07-12 | Aiken | South Carolina | 45003 | 697 | 13 |
324254 | 324254 | 2020-07-11 | Aiken | South Carolina | 45003 | 636 | 13 |
321074 | 321074 | 2020-07-10 | Aiken | South Carolina | 45003 | 599 | 11 |
317896 | 317896 | 2020-07-09 | Aiken | South Carolina | 45003 | 575 | 11 |
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);