ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Dillon" and state = "South Carolina" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
286285 | 286285 | 2020-06-29 | Dillon | South Carolina | 45033 | 298 | 8 |
289436 | 289436 | 2020-06-30 | Dillon | South Carolina | 45033 | 304 | 9 |
292588 | 292588 | 2020-07-01 | Dillon | South Carolina | 45033 | 307 | 10 |
295744 | 295744 | 2020-07-02 | Dillon | South Carolina | 45033 | 316 | 10 |
298903 | 298903 | 2020-07-03 | Dillon | South Carolina | 45033 | 321 | 10 |
302067 | 302067 | 2020-07-04 | Dillon | South Carolina | 45033 | 330 | 10 |
305230 | 305230 | 2020-07-05 | Dillon | South Carolina | 45033 | 336 | 10 |
308397 | 308397 | 2020-07-06 | Dillon | South Carolina | 45033 | 344 | 12 |
311566 | 311566 | 2020-07-07 | Dillon | South Carolina | 45033 | 350 | 12 |
314738 | 314738 | 2020-07-08 | Dillon | South Carolina | 45033 | 356 | 13 |
317911 | 317911 | 2020-07-09 | Dillon | South Carolina | 45033 | 363 | 13 |
321089 | 321089 | 2020-07-10 | Dillon | South Carolina | 45033 | 370 | 13 |
324269 | 324269 | 2020-07-11 | Dillon | South Carolina | 45033 | 376 | 14 |
327454 | 327454 | 2020-07-12 | Dillon | South Carolina | 45033 | 384 | 14 |
330640 | 330640 | 2020-07-13 | Dillon | South Carolina | 45033 | 397 | 14 |
333832 | 333832 | 2020-07-14 | Dillon | South Carolina | 45033 | 402 | 14 |
337026 | 337026 | 2020-07-15 | Dillon | South Carolina | 45033 | 407 | 14 |
340223 | 340223 | 2020-07-16 | Dillon | South Carolina | 45033 | 416 | 16 |
343421 | 343421 | 2020-07-17 | Dillon | South Carolina | 45033 | 426 | 17 |
346621 | 346621 | 2020-07-18 | Dillon | South Carolina | 45033 | 426 | 18 |
349821 | 349821 | 2020-07-19 | Dillon | South Carolina | 45033 | 436 | 18 |
353024 | 353024 | 2020-07-20 | Dillon | South Carolina | 45033 | 441 | 18 |
356227 | 356227 | 2020-07-21 | Dillon | South Carolina | 45033 | 455 | 19 |
359431 | 359431 | 2020-07-22 | Dillon | South Carolina | 45033 | 462 | 19 |
362637 | 362637 | 2020-07-23 | Dillon | South Carolina | 45033 | 471 | 20 |
365843 | 365843 | 2020-07-24 | Dillon | South Carolina | 45033 | 480 | 21 |
369052 | 369052 | 2020-07-25 | Dillon | South Carolina | 45033 | 486 | 21 |
372264 | 372264 | 2020-07-26 | Dillon | South Carolina | 45033 | 499 | 21 |
375477 | 375477 | 2020-07-27 | Dillon | South Carolina | 45033 | 506 | 21 |
378693 | 378693 | 2020-07-28 | Dillon | South Carolina | 45033 | 516 | 21 |
381910 | 381910 | 2020-07-29 | Dillon | South Carolina | 45033 | 521 | 21 |
385128 | 385128 | 2020-07-30 | Dillon | South Carolina | 45033 | 536 | 23 |
388345 | 388345 | 2020-07-31 | Dillon | South Carolina | 45033 | 541 | 23 |
391562 | 391562 | 2020-08-01 | Dillon | South Carolina | 45033 | 552 | 23 |
394778 | 394778 | 2020-08-02 | Dillon | South Carolina | 45033 | 564 | 23 |
397995 | 397995 | 2020-08-03 | Dillon | South Carolina | 45033 | 579 | 23 |
401210 | 401210 | 2020-08-04 | Dillon | South Carolina | 45033 | 583 | 23 |
404428 | 404428 | 2020-08-05 | Dillon | South Carolina | 45033 | 593 | 23 |
407647 | 407647 | 2020-08-06 | Dillon | South Carolina | 45033 | 607 | 24 |
410867 | 410867 | 2020-08-07 | Dillon | South Carolina | 45033 | 619 | 24 |
414087 | 414087 | 2020-08-08 | Dillon | South Carolina | 45033 | 634 | 24 |
417308 | 417308 | 2020-08-09 | Dillon | South Carolina | 45033 | 642 | 24 |
420528 | 420528 | 2020-08-10 | Dillon | South Carolina | 45033 | 644 | 25 |
423751 | 423751 | 2020-08-11 | Dillon | South Carolina | 45033 | 654 | 25 |
426974 | 426974 | 2020-08-12 | Dillon | South Carolina | 45033 | 657 | 25 |
430199 | 430199 | 2020-08-13 | Dillon | South Carolina | 45033 | 661 | 25 |
433425 | 433425 | 2020-08-14 | Dillon | South Carolina | 45033 | 663 | 25 |
436652 | 436652 | 2020-08-15 | Dillon | South Carolina | 45033 | 671 | 25 |
439877 | 439877 | 2020-08-16 | Dillon | South Carolina | 45033 | 679 | 26 |
443104 | 443104 | 2020-08-17 | Dillon | South Carolina | 45033 | 679 | 26 |
446330 | 446330 | 2020-08-18 | Dillon | South Carolina | 45033 | 684 | 26 |
449558 | 449558 | 2020-08-19 | Dillon | South Carolina | 45033 | 690 | 26 |
452786 | 452786 | 2020-08-20 | Dillon | South Carolina | 45033 | 696 | 27 |
456014 | 456014 | 2020-08-21 | Dillon | South Carolina | 45033 | 704 | 28 |
459242 | 459242 | 2020-08-22 | Dillon | South Carolina | 45033 | 708 | 28 |
462470 | 462470 | 2020-08-23 | Dillon | South Carolina | 45033 | 711 | 28 |
465699 | 465699 | 2020-08-24 | Dillon | South Carolina | 45033 | 714 | 28 |
468927 | 468927 | 2020-08-25 | Dillon | South Carolina | 45033 | 720 | 28 |
472159 | 472159 | 2020-08-26 | Dillon | South Carolina | 45033 | 721 | 28 |
475393 | 475393 | 2020-08-27 | Dillon | South Carolina | 45033 | 735 | 28 |
478626 | 478626 | 2020-08-28 | Dillon | South Carolina | 45033 | 740 | 28 |
481860 | 481860 | 2020-08-29 | Dillon | South Carolina | 45033 | 746 | 28 |
485095 | 485095 | 2020-08-30 | Dillon | South Carolina | 45033 | 757 | 28 |
488328 | 488328 | 2020-08-31 | Dillon | South Carolina | 45033 | 761 | 28 |
491561 | 491561 | 2020-09-01 | Dillon | South Carolina | 45033 | 768 | 28 |
494795 | 494795 | 2020-09-02 | Dillon | South Carolina | 45033 | 769 | 28 |
498028 | 498028 | 2020-09-03 | Dillon | South Carolina | 45033 | 784 | 28 |
501262 | 501262 | 2020-09-04 | Dillon | South Carolina | 45033 | 792 | 28 |
504496 | 504496 | 2020-09-05 | Dillon | South Carolina | 45033 | 808 | 28 |
507728 | 507728 | 2020-09-06 | Dillon | South Carolina | 45033 | 816 | 28 |
510961 | 510961 | 2020-09-07 | Dillon | South Carolina | 45033 | 830 | 28 |
514194 | 514194 | 2020-09-08 | Dillon | South Carolina | 45033 | 832 | 28 |
517429 | 517429 | 2020-09-09 | Dillon | South Carolina | 45033 | 841 | 28 |
520665 | 520665 | 2020-09-10 | Dillon | South Carolina | 45033 | 841 | 28 |
523901 | 523901 | 2020-09-11 | Dillon | South Carolina | 45033 | 857 | 28 |
527137 | 527137 | 2020-09-12 | Dillon | South Carolina | 45033 | 874 | 28 |
530374 | 530374 | 2020-09-13 | Dillon | South Carolina | 45033 | 888 | 28 |
533609 | 533609 | 2020-09-14 | Dillon | South Carolina | 45033 | 898 | 28 |
536845 | 536845 | 2020-09-15 | Dillon | South Carolina | 45033 | 906 | 29 |
540082 | 540082 | 2020-09-16 | Dillon | South Carolina | 45033 | 913 | 30 |
543318 | 543318 | 2020-09-17 | Dillon | South Carolina | 45033 | 920 | 30 |
546555 | 546555 | 2020-09-18 | Dillon | South Carolina | 45033 | 938 | 31 |
549794 | 549794 | 2020-09-19 | Dillon | South Carolina | 45033 | 950 | 31 |
553033 | 553033 | 2020-09-20 | Dillon | South Carolina | 45033 | 959 | 33 |
556270 | 556270 | 2020-09-21 | Dillon | South Carolina | 45033 | 978 | 34 |
559507 | 559507 | 2020-09-22 | Dillon | South Carolina | 45033 | 986 | 34 |
562744 | 562744 | 2020-09-23 | Dillon | South Carolina | 45033 | 993 | 36 |
565985 | 565985 | 2020-09-24 | Dillon | South Carolina | 45033 | 1004 | 36 |
569226 | 569226 | 2020-09-25 | Dillon | South Carolina | 45033 | 1016 | 37 |
572468 | 572468 | 2020-09-26 | Dillon | South Carolina | 45033 | 1027 | 37 |
575712 | 575712 | 2020-09-27 | Dillon | South Carolina | 45033 | 1039 | 37 |
578953 | 578953 | 2020-09-28 | Dillon | South Carolina | 45033 | 1047 | 37 |
582193 | 582193 | 2020-09-29 | Dillon | South Carolina | 45033 | 1058 | 39 |
585433 | 585433 | 2020-09-30 | Dillon | South Carolina | 45033 | 1061 | 39 |
588673 | 588673 | 2020-10-01 | Dillon | South Carolina | 45033 | 1063 | 39 |
591914 | 591914 | 2020-10-02 | Dillon | South Carolina | 45033 | 1072 | 39 |
595155 | 595155 | 2020-10-03 | Dillon | South Carolina | 45033 | 1108 | 40 |
598398 | 598398 | 2020-10-04 | Dillon | South Carolina | 45033 | 1119 | 40 |
601641 | 601641 | 2020-10-05 | Dillon | South Carolina | 45033 | 1122 | 40 |
604883 | 604883 | 2020-10-06 | Dillon | South Carolina | 45033 | 1133 | 41 |
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);