ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Wagoner" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955112 | 955112 | 2021-01-22 | Wagoner | Oklahoma | 40145 | 6426 | 65 |
951867 | 951867 | 2021-01-21 | Wagoner | Oklahoma | 40145 | 6352 | 64 |
948622 | 948622 | 2021-01-20 | Wagoner | Oklahoma | 40145 | 6280 | 63 |
945376 | 945376 | 2021-01-19 | Wagoner | Oklahoma | 40145 | 6218 | 63 |
942129 | 942129 | 2021-01-18 | Wagoner | Oklahoma | 40145 | 6181 | 62 |
938884 | 938884 | 2021-01-17 | Wagoner | Oklahoma | 40145 | 6142 | 62 |
935639 | 935639 | 2021-01-16 | Wagoner | Oklahoma | 40145 | 6077 | 61 |
932394 | 932394 | 2021-01-15 | Wagoner | Oklahoma | 40145 | 5946 | 58 |
929149 | 929149 | 2021-01-14 | Wagoner | Oklahoma | 40145 | 5815 | 57 |
925904 | 925904 | 2021-01-13 | Wagoner | Oklahoma | 40145 | 5751 | 56 |
922658 | 922658 | 2021-01-12 | Wagoner | Oklahoma | 40145 | 5625 | 52 |
919413 | 919413 | 2021-01-11 | Wagoner | Oklahoma | 40145 | 5581 | 52 |
916168 | 916168 | 2021-01-10 | Wagoner | Oklahoma | 40145 | 5506 | 52 |
912923 | 912923 | 2021-01-09 | Wagoner | Oklahoma | 40145 | 5358 | 51 |
909678 | 909678 | 2021-01-08 | Wagoner | Oklahoma | 40145 | 5260 | 49 |
906433 | 906433 | 2021-01-07 | Wagoner | Oklahoma | 40145 | 5189 | 49 |
903187 | 903187 | 2021-01-06 | Wagoner | Oklahoma | 40145 | 5098 | 49 |
899942 | 899942 | 2021-01-05 | Wagoner | Oklahoma | 40145 | 5044 | 47 |
896697 | 896697 | 2021-01-04 | Wagoner | Oklahoma | 40145 | 5009 | 47 |
893451 | 893451 | 2021-01-03 | Wagoner | Oklahoma | 40145 | 4954 | 47 |
890205 | 890205 | 2021-01-02 | Wagoner | Oklahoma | 40145 | 4762 | 46 |
886958 | 886958 | 2021-01-01 | Wagoner | Oklahoma | 40145 | 4650 | 46 |
883713 | 883713 | 2020-12-31 | Wagoner | Oklahoma | 40145 | 4650 | 46 |
880468 | 880468 | 2020-12-30 | Wagoner | Oklahoma | 40145 | 4567 | 45 |
877223 | 877223 | 2020-12-29 | Wagoner | Oklahoma | 40145 | 4474 | 44 |
873978 | 873978 | 2020-12-28 | Wagoner | Oklahoma | 40145 | 4448 | 44 |
870733 | 870733 | 2020-12-27 | Wagoner | Oklahoma | 40145 | 4368 | 44 |
867488 | 867488 | 2020-12-26 | Wagoner | Oklahoma | 40145 | 4272 | 44 |
864243 | 864243 | 2020-12-25 | Wagoner | Oklahoma | 40145 | 4161 | 44 |
860998 | 860998 | 2020-12-24 | Wagoner | Oklahoma | 40145 | 4161 | 44 |
857753 | 857753 | 2020-12-23 | Wagoner | Oklahoma | 40145 | 4114 | 43 |
854508 | 854508 | 2020-12-22 | Wagoner | Oklahoma | 40145 | 4033 | 42 |
851263 | 851263 | 2020-12-21 | Wagoner | Oklahoma | 40145 | 3976 | 42 |
848018 | 848018 | 2020-12-20 | Wagoner | Oklahoma | 40145 | 3924 | 42 |
844773 | 844773 | 2020-12-19 | Wagoner | Oklahoma | 40145 | 3792 | 41 |
841527 | 841527 | 2020-12-18 | Wagoner | Oklahoma | 40145 | 3672 | 41 |
838282 | 838282 | 2020-12-17 | Wagoner | Oklahoma | 40145 | 3597 | 41 |
835036 | 835036 | 2020-12-16 | Wagoner | Oklahoma | 40145 | 3502 | 41 |
831790 | 831790 | 2020-12-15 | Wagoner | Oklahoma | 40145 | 3422 | 41 |
828543 | 828543 | 2020-12-14 | Wagoner | Oklahoma | 40145 | 3393 | 41 |
825297 | 825297 | 2020-12-13 | Wagoner | Oklahoma | 40145 | 3364 | 41 |
822050 | 822050 | 2020-12-12 | Wagoner | Oklahoma | 40145 | 3322 | 41 |
818804 | 818804 | 2020-12-11 | Wagoner | Oklahoma | 40145 | 3247 | 40 |
815558 | 815558 | 2020-12-10 | Wagoner | Oklahoma | 40145 | 3200 | 39 |
812312 | 812312 | 2020-12-09 | Wagoner | Oklahoma | 40145 | 3144 | 38 |
809068 | 809068 | 2020-12-08 | Wagoner | Oklahoma | 40145 | 3114 | 38 |
805823 | 805823 | 2020-12-07 | Wagoner | Oklahoma | 40145 | 3096 | 38 |
802578 | 802578 | 2020-12-06 | Wagoner | Oklahoma | 40145 | 3083 | 38 |
799333 | 799333 | 2020-12-05 | Wagoner | Oklahoma | 40145 | 3042 | 38 |
796088 | 796088 | 2020-12-04 | Wagoner | Oklahoma | 40145 | 2977 | 37 |
792843 | 792843 | 2020-12-03 | Wagoner | Oklahoma | 40145 | 2939 | 37 |
789598 | 789598 | 2020-12-02 | Wagoner | Oklahoma | 40145 | 2904 | 37 |
786353 | 786353 | 2020-12-01 | Wagoner | Oklahoma | 40145 | 2857 | 35 |
783109 | 783109 | 2020-11-30 | Wagoner | Oklahoma | 40145 | 2845 | 35 |
779863 | 779863 | 2020-11-29 | Wagoner | Oklahoma | 40145 | 2822 | 35 |
776618 | 776618 | 2020-11-28 | Wagoner | Oklahoma | 40145 | 2797 | 35 |
773373 | 773373 | 2020-11-27 | Wagoner | Oklahoma | 40145 | 2729 | 35 |
770128 | 770128 | 2020-11-26 | Wagoner | Oklahoma | 40145 | 2697 | 35 |
766882 | 766882 | 2020-11-25 | Wagoner | Oklahoma | 40145 | 2697 | 35 |
763637 | 763637 | 2020-11-24 | Wagoner | Oklahoma | 40145 | 2615 | 35 |
760392 | 760392 | 2020-11-23 | Wagoner | Oklahoma | 40145 | 2593 | 35 |
757147 | 757147 | 2020-11-22 | Wagoner | Oklahoma | 40145 | 2566 | 35 |
753900 | 753900 | 2020-11-21 | Wagoner | Oklahoma | 40145 | 2511 | 35 |
750654 | 750654 | 2020-11-20 | Wagoner | Oklahoma | 40145 | 2437 | 35 |
747408 | 747408 | 2020-11-19 | Wagoner | Oklahoma | 40145 | 2389 | 35 |
744162 | 744162 | 2020-11-18 | Wagoner | Oklahoma | 40145 | 2358 | 35 |
740915 | 740915 | 2020-11-17 | Wagoner | Oklahoma | 40145 | 2317 | 35 |
737669 | 737669 | 2020-11-16 | Wagoner | Oklahoma | 40145 | 2305 | 35 |
734425 | 734425 | 2020-11-15 | Wagoner | Oklahoma | 40145 | 2284 | 35 |
731179 | 731179 | 2020-11-14 | Wagoner | Oklahoma | 40145 | 2248 | 34 |
727935 | 727935 | 2020-11-13 | Wagoner | Oklahoma | 40145 | 2223 | 33 |
724691 | 724691 | 2020-11-12 | Wagoner | Oklahoma | 40145 | 2212 | 32 |
721448 | 721448 | 2020-11-11 | Wagoner | Oklahoma | 40145 | 2161 | 31 |
718205 | 718205 | 2020-11-10 | Wagoner | Oklahoma | 40145 | 2128 | 31 |
714962 | 714962 | 2020-11-09 | Wagoner | Oklahoma | 40145 | 2111 | 31 |
711718 | 711718 | 2020-11-08 | Wagoner | Oklahoma | 40145 | 2098 | 31 |
708474 | 708474 | 2020-11-07 | Wagoner | Oklahoma | 40145 | 2098 | 31 |
705231 | 705231 | 2020-11-06 | Wagoner | Oklahoma | 40145 | 2069 | 31 |
701988 | 701988 | 2020-11-05 | Wagoner | Oklahoma | 40145 | 2053 | 31 |
698744 | 698744 | 2020-11-04 | Wagoner | Oklahoma | 40145 | 2030 | 31 |
695501 | 695501 | 2020-11-03 | Wagoner | Oklahoma | 40145 | 2019 | 31 |
692259 | 692259 | 2020-11-02 | Wagoner | Oklahoma | 40145 | 2009 | 31 |
689015 | 689015 | 2020-11-01 | Wagoner | Oklahoma | 40145 | 1995 | 31 |
685770 | 685770 | 2020-10-31 | Wagoner | Oklahoma | 40145 | 1985 | 31 |
682527 | 682527 | 2020-10-30 | Wagoner | Oklahoma | 40145 | 1972 | 31 |
679284 | 679284 | 2020-10-29 | Wagoner | Oklahoma | 40145 | 1951 | 30 |
676041 | 676041 | 2020-10-28 | Wagoner | Oklahoma | 40145 | 1937 | 30 |
672798 | 672798 | 2020-10-27 | Wagoner | Oklahoma | 40145 | 1919 | 30 |
669556 | 669556 | 2020-10-26 | Wagoner | Oklahoma | 40145 | 1886 | 29 |
666312 | 666312 | 2020-10-25 | Wagoner | Oklahoma | 40145 | 1878 | 29 |
663067 | 663067 | 2020-10-24 | Wagoner | Oklahoma | 40145 | 1871 | 29 |
659823 | 659823 | 2020-10-23 | Wagoner | Oklahoma | 40145 | 1850 | 28 |
656579 | 656579 | 2020-10-22 | Wagoner | Oklahoma | 40145 | 1834 | 28 |
653334 | 653334 | 2020-10-21 | Wagoner | Oklahoma | 40145 | 1804 | 27 |
650089 | 650089 | 2020-10-20 | Wagoner | Oklahoma | 40145 | 1783 | 27 |
646845 | 646845 | 2020-10-19 | Wagoner | Oklahoma | 40145 | 1755 | 27 |
643599 | 643599 | 2020-10-18 | Wagoner | Oklahoma | 40145 | 1750 | 27 |
640351 | 640351 | 2020-10-17 | Wagoner | Oklahoma | 40145 | 1743 | 27 |
637105 | 637105 | 2020-10-16 | Wagoner | Oklahoma | 40145 | 1731 | 27 |
633859 | 633859 | 2020-10-15 | Wagoner | Oklahoma | 40145 | 1722 | 27 |
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);