ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Grady" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955064 | 955064 | 2021-01-22 | Grady | Oklahoma | 40051 | 4964 | 52 |
951819 | 951819 | 2021-01-21 | Grady | Oklahoma | 40051 | 4920 | 49 |
948574 | 948574 | 2021-01-20 | Grady | Oklahoma | 40051 | 4875 | 47 |
945328 | 945328 | 2021-01-19 | Grady | Oklahoma | 40051 | 4858 | 46 |
942081 | 942081 | 2021-01-18 | Grady | Oklahoma | 40051 | 4842 | 45 |
938836 | 938836 | 2021-01-17 | Grady | Oklahoma | 40051 | 4817 | 44 |
935591 | 935591 | 2021-01-16 | Grady | Oklahoma | 40051 | 4773 | 42 |
932346 | 932346 | 2021-01-15 | Grady | Oklahoma | 40051 | 4737 | 42 |
929101 | 929101 | 2021-01-14 | Grady | Oklahoma | 40051 | 4674 | 41 |
925856 | 925856 | 2021-01-13 | Grady | Oklahoma | 40051 | 4641 | 40 |
922610 | 922610 | 2021-01-12 | Grady | Oklahoma | 40051 | 4554 | 39 |
919365 | 919365 | 2021-01-11 | Grady | Oklahoma | 40051 | 4536 | 39 |
916120 | 916120 | 2021-01-10 | Grady | Oklahoma | 40051 | 4470 | 39 |
912875 | 912875 | 2021-01-09 | Grady | Oklahoma | 40051 | 4349 | 39 |
909630 | 909630 | 2021-01-08 | Grady | Oklahoma | 40051 | 4322 | 39 |
906385 | 906385 | 2021-01-07 | Grady | Oklahoma | 40051 | 4270 | 39 |
903139 | 903139 | 2021-01-06 | Grady | Oklahoma | 40051 | 4173 | 39 |
899894 | 899894 | 2021-01-05 | Grady | Oklahoma | 40051 | 4151 | 37 |
896649 | 896649 | 2021-01-04 | Grady | Oklahoma | 40051 | 4138 | 37 |
893403 | 893403 | 2021-01-03 | Grady | Oklahoma | 40051 | 4114 | 37 |
890157 | 890157 | 2021-01-02 | Grady | Oklahoma | 40051 | 4040 | 37 |
886910 | 886910 | 2021-01-01 | Grady | Oklahoma | 40051 | 3848 | 37 |
883665 | 883665 | 2020-12-31 | Grady | Oklahoma | 40051 | 3848 | 37 |
880420 | 880420 | 2020-12-30 | Grady | Oklahoma | 40051 | 3808 | 37 |
877175 | 877175 | 2020-12-29 | Grady | Oklahoma | 40051 | 3779 | 37 |
873930 | 873930 | 2020-12-28 | Grady | Oklahoma | 40051 | 3750 | 36 |
870685 | 870685 | 2020-12-27 | Grady | Oklahoma | 40051 | 3717 | 36 |
867440 | 867440 | 2020-12-26 | Grady | Oklahoma | 40051 | 3677 | 36 |
864195 | 864195 | 2020-12-25 | Grady | Oklahoma | 40051 | 3635 | 36 |
860950 | 860950 | 2020-12-24 | Grady | Oklahoma | 40051 | 3635 | 36 |
857705 | 857705 | 2020-12-23 | Grady | Oklahoma | 40051 | 3595 | 36 |
854460 | 854460 | 2020-12-22 | Grady | Oklahoma | 40051 | 3553 | 35 |
851215 | 851215 | 2020-12-21 | Grady | Oklahoma | 40051 | 3518 | 35 |
847970 | 847970 | 2020-12-20 | Grady | Oklahoma | 40051 | 3501 | 34 |
844725 | 844725 | 2020-12-19 | Grady | Oklahoma | 40051 | 3446 | 34 |
841479 | 841479 | 2020-12-18 | Grady | Oklahoma | 40051 | 3408 | 33 |
838234 | 838234 | 2020-12-17 | Grady | Oklahoma | 40051 | 3369 | 33 |
834988 | 834988 | 2020-12-16 | Grady | Oklahoma | 40051 | 3340 | 33 |
831742 | 831742 | 2020-12-15 | Grady | Oklahoma | 40051 | 3316 | 32 |
828495 | 828495 | 2020-12-14 | Grady | Oklahoma | 40051 | 3299 | 32 |
825249 | 825249 | 2020-12-13 | Grady | Oklahoma | 40051 | 3287 | 32 |
822002 | 822002 | 2020-12-12 | Grady | Oklahoma | 40051 | 3219 | 30 |
818756 | 818756 | 2020-12-11 | Grady | Oklahoma | 40051 | 3178 | 25 |
815510 | 815510 | 2020-12-10 | Grady | Oklahoma | 40051 | 3148 | 25 |
812264 | 812264 | 2020-12-09 | Grady | Oklahoma | 40051 | 3124 | 24 |
809020 | 809020 | 2020-12-08 | Grady | Oklahoma | 40051 | 3090 | 23 |
805775 | 805775 | 2020-12-07 | Grady | Oklahoma | 40051 | 3071 | 23 |
802530 | 802530 | 2020-12-06 | Grady | Oklahoma | 40051 | 3032 | 23 |
799285 | 799285 | 2020-12-05 | Grady | Oklahoma | 40051 | 2990 | 23 |
796040 | 796040 | 2020-12-04 | Grady | Oklahoma | 40051 | 2916 | 23 |
792795 | 792795 | 2020-12-03 | Grady | Oklahoma | 40051 | 2832 | 23 |
789550 | 789550 | 2020-12-02 | Grady | Oklahoma | 40051 | 2803 | 23 |
786305 | 786305 | 2020-12-01 | Grady | Oklahoma | 40051 | 2757 | 23 |
783061 | 783061 | 2020-11-30 | Grady | Oklahoma | 40051 | 2746 | 23 |
779815 | 779815 | 2020-11-29 | Grady | Oklahoma | 40051 | 2715 | 23 |
776570 | 776570 | 2020-11-28 | Grady | Oklahoma | 40051 | 2681 | 21 |
773325 | 773325 | 2020-11-27 | Grady | Oklahoma | 40051 | 2600 | 21 |
770080 | 770080 | 2020-11-26 | Grady | Oklahoma | 40051 | 2546 | 21 |
766834 | 766834 | 2020-11-25 | Grady | Oklahoma | 40051 | 2546 | 21 |
763589 | 763589 | 2020-11-24 | Grady | Oklahoma | 40051 | 2488 | 21 |
760344 | 760344 | 2020-11-23 | Grady | Oklahoma | 40051 | 2424 | 20 |
757099 | 757099 | 2020-11-22 | Grady | Oklahoma | 40051 | 2386 | 20 |
753852 | 753852 | 2020-11-21 | Grady | Oklahoma | 40051 | 2344 | 20 |
750606 | 750606 | 2020-11-20 | Grady | Oklahoma | 40051 | 2288 | 19 |
747360 | 747360 | 2020-11-19 | Grady | Oklahoma | 40051 | 2244 | 19 |
744114 | 744114 | 2020-11-18 | Grady | Oklahoma | 40051 | 2195 | 19 |
740867 | 740867 | 2020-11-17 | Grady | Oklahoma | 40051 | 2155 | 19 |
737621 | 737621 | 2020-11-16 | Grady | Oklahoma | 40051 | 2129 | 19 |
734377 | 734377 | 2020-11-15 | Grady | Oklahoma | 40051 | 2094 | 19 |
731131 | 731131 | 2020-11-14 | Grady | Oklahoma | 40051 | 2053 | 19 |
727887 | 727887 | 2020-11-13 | Grady | Oklahoma | 40051 | 1998 | 18 |
724643 | 724643 | 2020-11-12 | Grady | Oklahoma | 40051 | 1939 | 18 |
721400 | 721400 | 2020-11-11 | Grady | Oklahoma | 40051 | 1905 | 18 |
718157 | 718157 | 2020-11-10 | Grady | Oklahoma | 40051 | 1884 | 18 |
714914 | 714914 | 2020-11-09 | Grady | Oklahoma | 40051 | 1868 | 18 |
711670 | 711670 | 2020-11-08 | Grady | Oklahoma | 40051 | 1841 | 18 |
708426 | 708426 | 2020-11-07 | Grady | Oklahoma | 40051 | 1841 | 18 |
705183 | 705183 | 2020-11-06 | Grady | Oklahoma | 40051 | 1773 | 18 |
701940 | 701940 | 2020-11-05 | Grady | Oklahoma | 40051 | 1748 | 18 |
698696 | 698696 | 2020-11-04 | Grady | Oklahoma | 40051 | 1721 | 18 |
695453 | 695453 | 2020-11-03 | Grady | Oklahoma | 40051 | 1706 | 17 |
692211 | 692211 | 2020-11-02 | Grady | Oklahoma | 40051 | 1698 | 17 |
688967 | 688967 | 2020-11-01 | Grady | Oklahoma | 40051 | 1692 | 16 |
685722 | 685722 | 2020-10-31 | Grady | Oklahoma | 40051 | 1675 | 16 |
682479 | 682479 | 2020-10-30 | Grady | Oklahoma | 40051 | 1659 | 16 |
679236 | 679236 | 2020-10-29 | Grady | Oklahoma | 40051 | 1641 | 16 |
675993 | 675993 | 2020-10-28 | Grady | Oklahoma | 40051 | 1631 | 16 |
672750 | 672750 | 2020-10-27 | Grady | Oklahoma | 40051 | 1624 | 16 |
669508 | 669508 | 2020-10-26 | Grady | Oklahoma | 40051 | 1612 | 16 |
666264 | 666264 | 2020-10-25 | Grady | Oklahoma | 40051 | 1605 | 16 |
663019 | 663019 | 2020-10-24 | Grady | Oklahoma | 40051 | 1598 | 16 |
659775 | 659775 | 2020-10-23 | Grady | Oklahoma | 40051 | 1559 | 16 |
656531 | 656531 | 2020-10-22 | Grady | Oklahoma | 40051 | 1547 | 16 |
653286 | 653286 | 2020-10-21 | Grady | Oklahoma | 40051 | 1521 | 16 |
650041 | 650041 | 2020-10-20 | Grady | Oklahoma | 40051 | 1496 | 16 |
646797 | 646797 | 2020-10-19 | Grady | Oklahoma | 40051 | 1467 | 14 |
643551 | 643551 | 2020-10-18 | Grady | Oklahoma | 40051 | 1458 | 14 |
640303 | 640303 | 2020-10-17 | Grady | Oklahoma | 40051 | 1445 | 14 |
637057 | 637057 | 2020-10-16 | Grady | Oklahoma | 40051 | 1426 | 14 |
633811 | 633811 | 2020-10-15 | Grady | Oklahoma | 40051 | 1414 | 13 |
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);