ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Clay" and fips = 13061 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
933838 | 933838 | 2021-01-16 | Clay | Georgia | 13061 | 204 | 3 |
930593 | 930593 | 2021-01-15 | Clay | Georgia | 13061 | 204 | 3 |
927348 | 927348 | 2021-01-14 | Clay | Georgia | 13061 | 203 | 3 |
924102 | 924102 | 2021-01-13 | Clay | Georgia | 13061 | 200 | 3 |
920857 | 920857 | 2021-01-12 | Clay | Georgia | 13061 | 200 | 3 |
917612 | 917612 | 2021-01-11 | Clay | Georgia | 13061 | 199 | 3 |
914367 | 914367 | 2021-01-10 | Clay | Georgia | 13061 | 198 | 3 |
911122 | 911122 | 2021-01-09 | Clay | Georgia | 13061 | 198 | 3 |
907877 | 907877 | 2021-01-08 | Clay | Georgia | 13061 | 195 | 3 |
904631 | 904631 | 2021-01-07 | Clay | Georgia | 13061 | 191 | 3 |
901386 | 901386 | 2021-01-06 | Clay | Georgia | 13061 | 189 | 3 |
898141 | 898141 | 2021-01-05 | Clay | Georgia | 13061 | 190 | 3 |
894896 | 894896 | 2021-01-04 | Clay | Georgia | 13061 | 188 | 3 |
891649 | 891649 | 2021-01-03 | Clay | Georgia | 13061 | 186 | 3 |
888402 | 888402 | 2021-01-02 | Clay | Georgia | 13061 | 183 | 3 |
885157 | 885157 | 2021-01-01 | Clay | Georgia | 13061 | 179 | 3 |
881912 | 881912 | 2020-12-31 | Clay | Georgia | 13061 | 177 | 3 |
878667 | 878667 | 2020-12-30 | Clay | Georgia | 13061 | 176 | 3 |
875422 | 875422 | 2020-12-29 | Clay | Georgia | 13061 | 175 | 3 |
872177 | 872177 | 2020-12-28 | Clay | Georgia | 13061 | 172 | 3 |
868932 | 868932 | 2020-12-27 | Clay | Georgia | 13061 | 172 | 3 |
865687 | 865687 | 2020-12-26 | Clay | Georgia | 13061 | 173 | 3 |
862442 | 862442 | 2020-12-25 | Clay | Georgia | 13061 | 173 | 3 |
859197 | 859197 | 2020-12-24 | Clay | Georgia | 13061 | 173 | 3 |
855952 | 855952 | 2020-12-23 | Clay | Georgia | 13061 | 169 | 3 |
852707 | 852707 | 2020-12-22 | Clay | Georgia | 13061 | 167 | 3 |
849462 | 849462 | 2020-12-21 | Clay | Georgia | 13061 | 166 | 3 |
846217 | 846217 | 2020-12-20 | Clay | Georgia | 13061 | 166 | 3 |
842971 | 842971 | 2020-12-19 | Clay | Georgia | 13061 | 166 | 3 |
839726 | 839726 | 2020-12-18 | Clay | Georgia | 13061 | 166 | 3 |
836481 | 836481 | 2020-12-17 | Clay | Georgia | 13061 | 163 | 3 |
833235 | 833235 | 2020-12-16 | Clay | Georgia | 13061 | 162 | 3 |
829988 | 829988 | 2020-12-15 | Clay | Georgia | 13061 | 162 | 3 |
826742 | 826742 | 2020-12-14 | Clay | Georgia | 13061 | 157 | 3 |
823495 | 823495 | 2020-12-13 | Clay | Georgia | 13061 | 157 | 3 |
820249 | 820249 | 2020-12-12 | Clay | Georgia | 13061 | 157 | 3 |
817003 | 817003 | 2020-12-11 | Clay | Georgia | 13061 | 157 | 3 |
813757 | 813757 | 2020-12-10 | Clay | Georgia | 13061 | 157 | 3 |
810513 | 810513 | 2020-12-09 | Clay | Georgia | 13061 | 151 | 3 |
807268 | 807268 | 2020-12-08 | Clay | Georgia | 13061 | 151 | 3 |
804023 | 804023 | 2020-12-07 | Clay | Georgia | 13061 | 151 | 3 |
800778 | 800778 | 2020-12-06 | Clay | Georgia | 13061 | 151 | 3 |
797533 | 797533 | 2020-12-05 | Clay | Georgia | 13061 | 151 | 3 |
794288 | 794288 | 2020-12-04 | Clay | Georgia | 13061 | 150 | 3 |
791043 | 791043 | 2020-12-03 | Clay | Georgia | 13061 | 150 | 3 |
787798 | 787798 | 2020-12-02 | Clay | Georgia | 13061 | 150 | 3 |
784554 | 784554 | 2020-12-01 | Clay | Georgia | 13061 | 150 | 3 |
781309 | 781309 | 2020-11-30 | Clay | Georgia | 13061 | 150 | 3 |
778063 | 778063 | 2020-11-29 | Clay | Georgia | 13061 | 150 | 3 |
774818 | 774818 | 2020-11-28 | Clay | Georgia | 13061 | 149 | 3 |
771573 | 771573 | 2020-11-27 | Clay | Georgia | 13061 | 149 | 3 |
768328 | 768328 | 2020-11-26 | Clay | Georgia | 13061 | 149 | 3 |
765082 | 765082 | 2020-11-25 | Clay | Georgia | 13061 | 149 | 3 |
761837 | 761837 | 2020-11-24 | Clay | Georgia | 13061 | 149 | 3 |
758592 | 758592 | 2020-11-23 | Clay | Georgia | 13061 | 149 | 3 |
755345 | 755345 | 2020-11-22 | Clay | Georgia | 13061 | 150 | 3 |
752099 | 752099 | 2020-11-21 | Clay | Georgia | 13061 | 148 | 3 |
748853 | 748853 | 2020-11-20 | Clay | Georgia | 13061 | 148 | 3 |
745607 | 745607 | 2020-11-19 | Clay | Georgia | 13061 | 147 | 3 |
742360 | 742360 | 2020-11-18 | Clay | Georgia | 13061 | 145 | 3 |
739113 | 739113 | 2020-11-17 | Clay | Georgia | 13061 | 144 | 3 |
735869 | 735869 | 2020-11-16 | Clay | Georgia | 13061 | 144 | 3 |
732623 | 732623 | 2020-11-15 | Clay | Georgia | 13061 | 144 | 3 |
729378 | 729378 | 2020-11-14 | Clay | Georgia | 13061 | 143 | 3 |
726135 | 726135 | 2020-11-13 | Clay | Georgia | 13061 | 143 | 3 |
722892 | 722892 | 2020-11-12 | Clay | Georgia | 13061 | 143 | 3 |
719649 | 719649 | 2020-11-11 | Clay | Georgia | 13061 | 143 | 3 |
716406 | 716406 | 2020-11-10 | Clay | Georgia | 13061 | 143 | 3 |
713162 | 713162 | 2020-11-09 | Clay | Georgia | 13061 | 132 | 3 |
709918 | 709918 | 2020-11-08 | Clay | Georgia | 13061 | 132 | 3 |
706674 | 706674 | 2020-11-07 | Clay | Georgia | 13061 | 132 | 3 |
703431 | 703431 | 2020-11-06 | Clay | Georgia | 13061 | 132 | 3 |
700188 | 700188 | 2020-11-05 | Clay | Georgia | 13061 | 132 | 3 |
696944 | 696944 | 2020-11-04 | Clay | Georgia | 13061 | 132 | 3 |
693702 | 693702 | 2020-11-03 | Clay | Georgia | 13061 | 132 | 3 |
690459 | 690459 | 2020-11-02 | Clay | Georgia | 13061 | 132 | 3 |
687214 | 687214 | 2020-11-01 | Clay | Georgia | 13061 | 131 | 3 |
683970 | 683970 | 2020-10-31 | Clay | Georgia | 13061 | 131 | 3 |
680727 | 680727 | 2020-10-30 | Clay | Georgia | 13061 | 131 | 3 |
677484 | 677484 | 2020-10-29 | Clay | Georgia | 13061 | 131 | 3 |
674241 | 674241 | 2020-10-28 | Clay | Georgia | 13061 | 131 | 3 |
670999 | 670999 | 2020-10-27 | Clay | Georgia | 13061 | 131 | 3 |
667756 | 667756 | 2020-10-26 | Clay | Georgia | 13061 | 131 | 3 |
664511 | 664511 | 2020-10-25 | Clay | Georgia | 13061 | 129 | 3 |
661267 | 661267 | 2020-10-24 | Clay | Georgia | 13061 | 129 | 3 |
658023 | 658023 | 2020-10-23 | Clay | Georgia | 13061 | 129 | 3 |
654778 | 654778 | 2020-10-22 | Clay | Georgia | 13061 | 129 | 3 |
651533 | 651533 | 2020-10-21 | Clay | Georgia | 13061 | 129 | 3 |
648289 | 648289 | 2020-10-20 | Clay | Georgia | 13061 | 127 | 3 |
645044 | 645044 | 2020-10-19 | Clay | Georgia | 13061 | 127 | 3 |
641796 | 641796 | 2020-10-18 | Clay | Georgia | 13061 | 124 | 3 |
638549 | 638549 | 2020-10-17 | Clay | Georgia | 13061 | 124 | 3 |
635304 | 635304 | 2020-10-16 | Clay | Georgia | 13061 | 124 | 3 |
632058 | 632058 | 2020-10-15 | Clay | Georgia | 13061 | 124 | 3 |
628814 | 628814 | 2020-10-14 | Clay | Georgia | 13061 | 124 | 3 |
625571 | 625571 | 2020-10-13 | Clay | Georgia | 13061 | 124 | 3 |
622328 | 622328 | 2020-10-12 | Clay | Georgia | 13061 | 124 | 3 |
619085 | 619085 | 2020-10-11 | Clay | Georgia | 13061 | 124 | 3 |
615843 | 615843 | 2020-10-10 | Clay | Georgia | 13061 | 123 | 3 |
612602 | 612602 | 2020-10-09 | Clay | Georgia | 13061 | 123 | 3 |
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);