ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Grant" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
903140 | 903140 | 2021-01-06 | Grant | Oklahoma | 40053 | 409 | 5 |
899895 | 899895 | 2021-01-05 | Grant | Oklahoma | 40053 | 408 | 5 |
896650 | 896650 | 2021-01-04 | Grant | Oklahoma | 40053 | 405 | 5 |
893404 | 893404 | 2021-01-03 | Grant | Oklahoma | 40053 | 402 | 5 |
890158 | 890158 | 2021-01-02 | Grant | Oklahoma | 40053 | 386 | 5 |
886911 | 886911 | 2021-01-01 | Grant | Oklahoma | 40053 | 380 | 5 |
883666 | 883666 | 2020-12-31 | Grant | Oklahoma | 40053 | 380 | 5 |
880421 | 880421 | 2020-12-30 | Grant | Oklahoma | 40053 | 380 | 5 |
877176 | 877176 | 2020-12-29 | Grant | Oklahoma | 40053 | 375 | 5 |
873931 | 873931 | 2020-12-28 | Grant | Oklahoma | 40053 | 375 | 5 |
870686 | 870686 | 2020-12-27 | Grant | Oklahoma | 40053 | 369 | 5 |
867441 | 867441 | 2020-12-26 | Grant | Oklahoma | 40053 | 363 | 5 |
864196 | 864196 | 2020-12-25 | Grant | Oklahoma | 40053 | 355 | 5 |
860951 | 860951 | 2020-12-24 | Grant | Oklahoma | 40053 | 355 | 5 |
857706 | 857706 | 2020-12-23 | Grant | Oklahoma | 40053 | 350 | 5 |
854461 | 854461 | 2020-12-22 | Grant | Oklahoma | 40053 | 340 | 5 |
851216 | 851216 | 2020-12-21 | Grant | Oklahoma | 40053 | 333 | 5 |
847971 | 847971 | 2020-12-20 | Grant | Oklahoma | 40053 | 326 | 5 |
844726 | 844726 | 2020-12-19 | Grant | Oklahoma | 40053 | 307 | 5 |
841480 | 841480 | 2020-12-18 | Grant | Oklahoma | 40053 | 304 | 5 |
838235 | 838235 | 2020-12-17 | Grant | Oklahoma | 40053 | 302 | 5 |
834989 | 834989 | 2020-12-16 | Grant | Oklahoma | 40053 | 299 | 5 |
831743 | 831743 | 2020-12-15 | Grant | Oklahoma | 40053 | 296 | 5 |
828496 | 828496 | 2020-12-14 | Grant | Oklahoma | 40053 | 286 | 5 |
825250 | 825250 | 2020-12-13 | Grant | Oklahoma | 40053 | 280 | 5 |
822003 | 822003 | 2020-12-12 | Grant | Oklahoma | 40053 | 265 | 5 |
818757 | 818757 | 2020-12-11 | Grant | Oklahoma | 40053 | 253 | 5 |
815511 | 815511 | 2020-12-10 | Grant | Oklahoma | 40053 | 249 | 5 |
812265 | 812265 | 2020-12-09 | Grant | Oklahoma | 40053 | 248 | 5 |
809021 | 809021 | 2020-12-08 | Grant | Oklahoma | 40053 | 239 | 5 |
805776 | 805776 | 2020-12-07 | Grant | Oklahoma | 40053 | 238 | 5 |
802531 | 802531 | 2020-12-06 | Grant | Oklahoma | 40053 | 235 | 5 |
799286 | 799286 | 2020-12-05 | Grant | Oklahoma | 40053 | 231 | 5 |
796041 | 796041 | 2020-12-04 | Grant | Oklahoma | 40053 | 227 | 5 |
792796 | 792796 | 2020-12-03 | Grant | Oklahoma | 40053 | 214 | 5 |
789551 | 789551 | 2020-12-02 | Grant | Oklahoma | 40053 | 214 | 5 |
786306 | 786306 | 2020-12-01 | Grant | Oklahoma | 40053 | 214 | 5 |
783062 | 783062 | 2020-11-30 | Grant | Oklahoma | 40053 | 212 | 5 |
779816 | 779816 | 2020-11-29 | Grant | Oklahoma | 40053 | 209 | 5 |
776571 | 776571 | 2020-11-28 | Grant | Oklahoma | 40053 | 209 | 5 |
773326 | 773326 | 2020-11-27 | Grant | Oklahoma | 40053 | 202 | 5 |
770081 | 770081 | 2020-11-26 | Grant | Oklahoma | 40053 | 200 | 4 |
766835 | 766835 | 2020-11-25 | Grant | Oklahoma | 40053 | 200 | 4 |
763590 | 763590 | 2020-11-24 | Grant | Oklahoma | 40053 | 195 | 4 |
760345 | 760345 | 2020-11-23 | Grant | Oklahoma | 40053 | 193 | 3 |
757100 | 757100 | 2020-11-22 | Grant | Oklahoma | 40053 | 188 | 3 |
753853 | 753853 | 2020-11-21 | Grant | Oklahoma | 40053 | 187 | 3 |
750607 | 750607 | 2020-11-20 | Grant | Oklahoma | 40053 | 187 | 3 |
747361 | 747361 | 2020-11-19 | Grant | Oklahoma | 40053 | 180 | 3 |
744115 | 744115 | 2020-11-18 | Grant | Oklahoma | 40053 | 177 | 3 |
740868 | 740868 | 2020-11-17 | Grant | Oklahoma | 40053 | 174 | 3 |
737622 | 737622 | 2020-11-16 | Grant | Oklahoma | 40053 | 170 | 3 |
734378 | 734378 | 2020-11-15 | Grant | Oklahoma | 40053 | 165 | 3 |
731132 | 731132 | 2020-11-14 | Grant | Oklahoma | 40053 | 157 | 3 |
727888 | 727888 | 2020-11-13 | Grant | Oklahoma | 40053 | 155 | 3 |
724644 | 724644 | 2020-11-12 | Grant | Oklahoma | 40053 | 151 | 2 |
721401 | 721401 | 2020-11-11 | Grant | Oklahoma | 40053 | 148 | 2 |
718158 | 718158 | 2020-11-10 | Grant | Oklahoma | 40053 | 145 | 2 |
714915 | 714915 | 2020-11-09 | Grant | Oklahoma | 40053 | 143 | 2 |
711671 | 711671 | 2020-11-08 | Grant | Oklahoma | 40053 | 140 | 2 |
708427 | 708427 | 2020-11-07 | Grant | Oklahoma | 40053 | 140 | 2 |
705184 | 705184 | 2020-11-06 | Grant | Oklahoma | 40053 | 130 | 2 |
701941 | 701941 | 2020-11-05 | Grant | Oklahoma | 40053 | 126 | 2 |
698697 | 698697 | 2020-11-04 | Grant | Oklahoma | 40053 | 121 | 2 |
695454 | 695454 | 2020-11-03 | Grant | Oklahoma | 40053 | 120 | 2 |
692212 | 692212 | 2020-11-02 | Grant | Oklahoma | 40053 | 119 | 2 |
688968 | 688968 | 2020-11-01 | Grant | Oklahoma | 40053 | 114 | 2 |
685723 | 685723 | 2020-10-31 | Grant | Oklahoma | 40053 | 114 | 2 |
682480 | 682480 | 2020-10-30 | Grant | Oklahoma | 40053 | 109 | 2 |
679237 | 679237 | 2020-10-29 | Grant | Oklahoma | 40053 | 109 | 1 |
675994 | 675994 | 2020-10-28 | Grant | Oklahoma | 40053 | 105 | 1 |
672751 | 672751 | 2020-10-27 | Grant | Oklahoma | 40053 | 101 | 1 |
669509 | 669509 | 2020-10-26 | Grant | Oklahoma | 40053 | 99 | 1 |
666265 | 666265 | 2020-10-25 | Grant | Oklahoma | 40053 | 99 | 1 |
663020 | 663020 | 2020-10-24 | Grant | Oklahoma | 40053 | 99 | 1 |
659776 | 659776 | 2020-10-23 | Grant | Oklahoma | 40053 | 88 | 1 |
656532 | 656532 | 2020-10-22 | Grant | Oklahoma | 40053 | 84 | 1 |
653287 | 653287 | 2020-10-21 | Grant | Oklahoma | 40053 | 80 | 1 |
650042 | 650042 | 2020-10-20 | Grant | Oklahoma | 40053 | 79 | 1 |
646798 | 646798 | 2020-10-19 | Grant | Oklahoma | 40053 | 78 | 1 |
643552 | 643552 | 2020-10-18 | Grant | Oklahoma | 40053 | 74 | 1 |
640304 | 640304 | 2020-10-17 | Grant | Oklahoma | 40053 | 74 | 1 |
637058 | 637058 | 2020-10-16 | Grant | Oklahoma | 40053 | 74 | 1 |
633812 | 633812 | 2020-10-15 | Grant | Oklahoma | 40053 | 72 | 1 |
630567 | 630567 | 2020-10-14 | Grant | Oklahoma | 40053 | 70 | 1 |
627323 | 627323 | 2020-10-13 | Grant | Oklahoma | 40053 | 68 | 1 |
624081 | 624081 | 2020-10-12 | Grant | Oklahoma | 40053 | 67 | 1 |
620838 | 620838 | 2020-10-11 | Grant | Oklahoma | 40053 | 65 | 1 |
617596 | 617596 | 2020-10-10 | Grant | Oklahoma | 40053 | 63 | 1 |
614354 | 614354 | 2020-10-09 | Grant | Oklahoma | 40053 | 60 | 1 |
611113 | 611113 | 2020-10-08 | Grant | Oklahoma | 40053 | 58 | 1 |
607871 | 607871 | 2020-10-07 | Grant | Oklahoma | 40053 | 55 | 1 |
604628 | 604628 | 2020-10-06 | Grant | Oklahoma | 40053 | 55 | 1 |
601386 | 601386 | 2020-10-05 | Grant | Oklahoma | 40053 | 55 | 1 |
598143 | 598143 | 2020-10-04 | Grant | Oklahoma | 40053 | 55 | 1 |
594900 | 594900 | 2020-10-03 | Grant | Oklahoma | 40053 | 55 | 1 |
591659 | 591659 | 2020-10-02 | Grant | Oklahoma | 40053 | 53 | 1 |
588418 | 588418 | 2020-10-01 | Grant | Oklahoma | 40053 | 53 | 1 |
585178 | 585178 | 2020-09-30 | Grant | Oklahoma | 40053 | 50 | 1 |
581938 | 581938 | 2020-09-29 | Grant | Oklahoma | 40053 | 50 | 1 |
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);