ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Gwinnett" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
933875 | 933875 | 2021-01-16 | Gwinnett | Georgia | 13135 | 71564 | 656 |
930630 | 930630 | 2021-01-15 | Gwinnett | Georgia | 13135 | 70719 | 648 |
927385 | 927385 | 2021-01-14 | Gwinnett | Georgia | 13135 | 69784 | 642 |
924139 | 924139 | 2021-01-13 | Gwinnett | Georgia | 13135 | 68904 | 639 |
920894 | 920894 | 2021-01-12 | Gwinnett | Georgia | 13135 | 68067 | 632 |
917649 | 917649 | 2021-01-11 | Gwinnett | Georgia | 13135 | 66910 | 627 |
914404 | 914404 | 2021-01-10 | Gwinnett | Georgia | 13135 | 65924 | 625 |
911159 | 911159 | 2021-01-09 | Gwinnett | Georgia | 13135 | 65110 | 624 |
907914 | 907914 | 2021-01-08 | Gwinnett | Georgia | 13135 | 64042 | 614 |
904668 | 904668 | 2021-01-07 | Gwinnett | Georgia | 13135 | 62661 | 610 |
901423 | 901423 | 2021-01-06 | Gwinnett | Georgia | 13135 | 61621 | 609 |
898178 | 898178 | 2021-01-05 | Gwinnett | Georgia | 13135 | 61181 | 605 |
894933 | 894933 | 2021-01-04 | Gwinnett | Georgia | 13135 | 60117 | 604 |
891686 | 891686 | 2021-01-03 | Gwinnett | Georgia | 13135 | 59719 | 604 |
888439 | 888439 | 2021-01-02 | Gwinnett | Georgia | 13135 | 59199 | 604 |
885194 | 885194 | 2021-01-01 | Gwinnett | Georgia | 13135 | 58601 | 604 |
881949 | 881949 | 2020-12-31 | Gwinnett | Georgia | 13135 | 57528 | 601 |
878704 | 878704 | 2020-12-30 | Gwinnett | Georgia | 13135 | 56521 | 597 |
875459 | 875459 | 2020-12-29 | Gwinnett | Georgia | 13135 | 55763 | 594 |
872214 | 872214 | 2020-12-28 | Gwinnett | Georgia | 13135 | 54930 | 591 |
868969 | 868969 | 2020-12-27 | Gwinnett | Georgia | 13135 | 54408 | 591 |
865724 | 865724 | 2020-12-26 | Gwinnett | Georgia | 13135 | 54114 | 591 |
862479 | 862479 | 2020-12-25 | Gwinnett | Georgia | 13135 | 53732 | 589 |
859234 | 859234 | 2020-12-24 | Gwinnett | Georgia | 13135 | 53301 | 586 |
855989 | 855989 | 2020-12-23 | Gwinnett | Georgia | 13135 | 52427 | 583 |
852744 | 852744 | 2020-12-22 | Gwinnett | Georgia | 13135 | 51723 | 580 |
849499 | 849499 | 2020-12-21 | Gwinnett | Georgia | 13135 | 50864 | 576 |
846254 | 846254 | 2020-12-20 | Gwinnett | Georgia | 13135 | 50600 | 575 |
843008 | 843008 | 2020-12-19 | Gwinnett | Georgia | 13135 | 50062 | 574 |
839763 | 839763 | 2020-12-18 | Gwinnett | Georgia | 13135 | 49580 | 572 |
836518 | 836518 | 2020-12-17 | Gwinnett | Georgia | 13135 | 48980 | 570 |
833272 | 833272 | 2020-12-16 | Gwinnett | Georgia | 13135 | 48296 | 568 |
830025 | 830025 | 2020-12-15 | Gwinnett | Georgia | 13135 | 47764 | 565 |
826779 | 826779 | 2020-12-14 | Gwinnett | Georgia | 13135 | 47001 | 565 |
823532 | 823532 | 2020-12-13 | Gwinnett | Georgia | 13135 | 46614 | 564 |
820286 | 820286 | 2020-12-12 | Gwinnett | Georgia | 13135 | 46065 | 564 |
817040 | 817040 | 2020-12-11 | Gwinnett | Georgia | 13135 | 45524 | 560 |
813794 | 813794 | 2020-12-10 | Gwinnett | Georgia | 13135 | 45037 | 557 |
810550 | 810550 | 2020-12-09 | Gwinnett | Georgia | 13135 | 44322 | 554 |
807305 | 807305 | 2020-12-08 | Gwinnett | Georgia | 13135 | 43782 | 550 |
804060 | 804060 | 2020-12-07 | Gwinnett | Georgia | 13135 | 43060 | 550 |
800815 | 800815 | 2020-12-06 | Gwinnett | Georgia | 13135 | 42664 | 550 |
797570 | 797570 | 2020-12-05 | Gwinnett | Georgia | 13135 | 42459 | 550 |
794325 | 794325 | 2020-12-04 | Gwinnett | Georgia | 13135 | 42048 | 547 |
791080 | 791080 | 2020-12-03 | Gwinnett | Georgia | 13135 | 41381 | 541 |
787835 | 787835 | 2020-12-02 | Gwinnett | Georgia | 13135 | 40916 | 534 |
784591 | 784591 | 2020-12-01 | Gwinnett | Georgia | 13135 | 40364 | 528 |
781346 | 781346 | 2020-11-30 | Gwinnett | Georgia | 13135 | 39938 | 526 |
778100 | 778100 | 2020-11-29 | Gwinnett | Georgia | 13135 | 39721 | 526 |
774855 | 774855 | 2020-11-28 | Gwinnett | Georgia | 13135 | 39537 | 525 |
771610 | 771610 | 2020-11-27 | Gwinnett | Georgia | 13135 | 39276 | 522 |
768365 | 768365 | 2020-11-26 | Gwinnett | Georgia | 13135 | 39013 | 518 |
765119 | 765119 | 2020-11-25 | Gwinnett | Georgia | 13135 | 38699 | 516 |
761874 | 761874 | 2020-11-24 | Gwinnett | Georgia | 13135 | 38459 | 511 |
758629 | 758629 | 2020-11-23 | Gwinnett | Georgia | 13135 | 38150 | 510 |
755382 | 755382 | 2020-11-22 | Gwinnett | Georgia | 13135 | 37977 | 510 |
752136 | 752136 | 2020-11-21 | Gwinnett | Georgia | 13135 | 37797 | 510 |
748890 | 748890 | 2020-11-20 | Gwinnett | Georgia | 13135 | 37267 | 505 |
745644 | 745644 | 2020-11-19 | Gwinnett | Georgia | 13135 | 37004 | 502 |
742397 | 742397 | 2020-11-18 | Gwinnett | Georgia | 13135 | 36744 | 500 |
739150 | 739150 | 2020-11-17 | Gwinnett | Georgia | 13135 | 36516 | 497 |
735906 | 735906 | 2020-11-16 | Gwinnett | Georgia | 13135 | 36118 | 495 |
732660 | 732660 | 2020-11-15 | Gwinnett | Georgia | 13135 | 36018 | 494 |
729415 | 729415 | 2020-11-14 | Gwinnett | Georgia | 13135 | 35835 | 494 |
726172 | 726172 | 2020-11-13 | Gwinnett | Georgia | 13135 | 35572 | 492 |
722929 | 722929 | 2020-11-12 | Gwinnett | Georgia | 13135 | 35339 | 492 |
719686 | 719686 | 2020-11-11 | Gwinnett | Georgia | 13135 | 35105 | 485 |
716443 | 716443 | 2020-11-10 | Gwinnett | Georgia | 13135 | 34903 | 481 |
713199 | 713199 | 2020-11-09 | Gwinnett | Georgia | 13135 | 34514 | 479 |
709955 | 709955 | 2020-11-08 | Gwinnett | Georgia | 13135 | 34402 | 479 |
706711 | 706711 | 2020-11-07 | Gwinnett | Georgia | 13135 | 34266 | 479 |
703468 | 703468 | 2020-11-06 | Gwinnett | Georgia | 13135 | 34131 | 478 |
700225 | 700225 | 2020-11-05 | Gwinnett | Georgia | 13135 | 33883 | 476 |
696981 | 696981 | 2020-11-04 | Gwinnett | Georgia | 13135 | 33740 | 473 |
693739 | 693739 | 2020-11-03 | Gwinnett | Georgia | 13135 | 33471 | 452 |
690496 | 690496 | 2020-11-02 | Gwinnett | Georgia | 13135 | 33346 | 452 |
687251 | 687251 | 2020-11-01 | Gwinnett | Georgia | 13135 | 33063 | 450 |
684007 | 684007 | 2020-10-31 | Gwinnett | Georgia | 13135 | 32947 | 450 |
680764 | 680764 | 2020-10-30 | Gwinnett | Georgia | 13135 | 32739 | 449 |
677521 | 677521 | 2020-10-29 | Gwinnett | Georgia | 13135 | 32591 | 447 |
674278 | 674278 | 2020-10-28 | Gwinnett | Georgia | 13135 | 32441 | 445 |
671036 | 671036 | 2020-10-27 | Gwinnett | Georgia | 13135 | 32334 | 443 |
667793 | 667793 | 2020-10-26 | Gwinnett | Georgia | 13135 | 32228 | 442 |
664548 | 664548 | 2020-10-25 | Gwinnett | Georgia | 13135 | 31979 | 440 |
661304 | 661304 | 2020-10-24 | Gwinnett | Georgia | 13135 | 31877 | 440 |
658060 | 658060 | 2020-10-23 | Gwinnett | Georgia | 13135 | 31782 | 438 |
654815 | 654815 | 2020-10-22 | Gwinnett | Georgia | 13135 | 31632 | 438 |
651570 | 651570 | 2020-10-21 | Gwinnett | Georgia | 13135 | 31589 | 436 |
648326 | 648326 | 2020-10-20 | Gwinnett | Georgia | 13135 | 31539 | 436 |
645081 | 645081 | 2020-10-19 | Gwinnett | Georgia | 13135 | 31421 | 434 |
641833 | 641833 | 2020-10-18 | Gwinnett | Georgia | 13135 | 31298 | 433 |
638586 | 638586 | 2020-10-17 | Gwinnett | Georgia | 13135 | 31167 | 431 |
635341 | 635341 | 2020-10-16 | Gwinnett | Georgia | 13135 | 31027 | 429 |
632095 | 632095 | 2020-10-15 | Gwinnett | Georgia | 13135 | 30904 | 428 |
628851 | 628851 | 2020-10-14 | Gwinnett | Georgia | 13135 | 30766 | 427 |
625608 | 625608 | 2020-10-13 | Gwinnett | Georgia | 13135 | 30624 | 425 |
622365 | 622365 | 2020-10-12 | Gwinnett | Georgia | 13135 | 30470 | 424 |
619122 | 619122 | 2020-10-11 | Gwinnett | Georgia | 13135 | 30242 | 424 |
615880 | 615880 | 2020-10-10 | Gwinnett | Georgia | 13135 | 30158 | 423 |
612639 | 612639 | 2020-10-09 | Gwinnett | Georgia | 13135 | 30039 | 422 |
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);