ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

26,227 rows where state = "Oklahoma" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

state

  • Oklahoma · 26,227 ✖
Link rowid date ▲ county state fips cases deaths
1097849 1097849 2021-03-07 Adair Oklahoma 40001 3130 25
1097850 1097850 2021-03-07 Alfalfa Oklahoma 40003 1149 5
1097851 1097851 2021-03-07 Atoka Oklahoma 40005 1784 13
1097852 1097852 2021-03-07 Beaver Oklahoma 40007 448 6
1097853 1097853 2021-03-07 Beckham Oklahoma 40009 2799 37
1097854 1097854 2021-03-07 Blaine Oklahoma 40011 1005 8
1097855 1097855 2021-03-07 Bryan Oklahoma 40013 5983 56
1097856 1097856 2021-03-07 Caddo Oklahoma 40015 3857 58
1097857 1097857 2021-03-07 Canadian Oklahoma 40017 16089 97
1097858 1097858 2021-03-07 Carter Oklahoma 40019 5762 60
1097859 1097859 2021-03-07 Cherokee Oklahoma 40021 5462 44
1097860 1097860 2021-03-07 Choctaw Oklahoma 40023 1579 14
1097861 1097861 2021-03-07 Cimarron Oklahoma 40025 203 1
1097862 1097862 2021-03-07 Cleveland Oklahoma 40027 28977 274
1097863 1097863 2021-03-07 Coal Oklahoma 40029 684 14
1097864 1097864 2021-03-07 Comanche Oklahoma 40031 12244 140
1097865 1097865 2021-03-07 Cotton Oklahoma 40033 658 13
1097866 1097866 2021-03-07 Craig Oklahoma 40035 1898 11
1097867 1097867 2021-03-07 Creek Oklahoma 40037 6647 117
1097868 1097868 2021-03-07 Custer Oklahoma 40039 4031 72
1097869 1097869 2021-03-07 Delaware Oklahoma 40041 4429 62
1097870 1097870 2021-03-07 Dewey Oklahoma 40043 537 6
1097871 1097871 2021-03-07 Ellis Oklahoma 40045 352 3
1097872 1097872 2021-03-07 Garfield Oklahoma 40047 7619 78
1097873 1097873 2021-03-07 Garvin Oklahoma 40049 3477 52
1097874 1097874 2021-03-07 Grady Oklahoma 40051 5689 76
1097875 1097875 2021-03-07 Grant Oklahoma 40053 540 7
1097876 1097876 2021-03-07 Greer Oklahoma 40055 539 17
1097877 1097877 2021-03-07 Harmon Oklahoma 40057 290 3
1097878 1097878 2021-03-07 Harper Oklahoma 40059 408 4
1097879 1097879 2021-03-07 Haskell Oklahoma 40061 1229 11
1097880 1097880 2021-03-07 Hughes Oklahoma 40063 1171 17
1097881 1097881 2021-03-07 Jackson Oklahoma 40065 2957 44
1097882 1097882 2021-03-07 Jefferson Oklahoma 40067 673 12
1097883 1097883 2021-03-07 Johnston Oklahoma 40069 1335 20
1097884 1097884 2021-03-07 Kay Oklahoma 40071 5102 81
1097885 1097885 2021-03-07 Kingfisher Oklahoma 40073 1997 24
1097886 1097886 2021-03-07 Kiowa Oklahoma 40075 801 16
1097887 1097887 2021-03-07 Latimer Oklahoma 40077 818 9
1097888 1097888 2021-03-07 Le Flore Oklahoma 40079 5425 44
1097889 1097889 2021-03-07 Lincoln Oklahoma 40081 3099 54
1097890 1097890 2021-03-07 Logan Oklahoma 40083 4019 28
1097891 1097891 2021-03-07 Love Oklahoma 40085 1433 12
1097892 1097892 2021-03-07 Major Oklahoma 40093 941 12
1097893 1097893 2021-03-07 Marshall Oklahoma 40095 1875 12
1097894 1097894 2021-03-07 Mayes Oklahoma 40097 4042 38
1097895 1097895 2021-03-07 McClain Oklahoma 40087 5064 50
1097896 1097896 2021-03-07 McCurtain Oklahoma 40089 3836 64
1097897 1097897 2021-03-07 McIntosh Oklahoma 40091 1942 35
1097898 1097898 2021-03-07 Murray Oklahoma 40099 1926 22
1097899 1097899 2021-03-07 Muskogee Oklahoma 40101 9138 106
1097900 1097900 2021-03-07 Noble Oklahoma 40103 1357 13
1097901 1097901 2021-03-07 Nowata Oklahoma 40105 1113 16
1097902 1097902 2021-03-07 Okfuskee Oklahoma 40107 1766 20
1097903 1097903 2021-03-07 Oklahoma Oklahoma 40109 81713 758
1097904 1097904 2021-03-07 Okmulgee Oklahoma 40111 3640 50
1097905 1097905 2021-03-07 Osage Oklahoma 40113 4512 52
1097906 1097906 2021-03-07 Ottawa Oklahoma 40115 3646 46
1097907 1097907 2021-03-07 Pawnee Oklahoma 40117 1731 33
1097908 1097908 2021-03-07 Payne Oklahoma 40119 8442 47
1097909 1097909 2021-03-07 Pittsburg Oklahoma 40121 4476 39
1097910 1097910 2021-03-07 Pontotoc Oklahoma 40123 4973 48
1097911 1097911 2021-03-07 Pottawatomie Oklahoma 40125 7983 79
1097912 1097912 2021-03-07 Pushmataha Oklahoma 40127 995 14
1097913 1097913 2021-03-07 Roger Mills Oklahoma 40129 384 7
1097914 1097914 2021-03-07 Rogers Oklahoma 40131 9974 119
1097915 1097915 2021-03-07 Seminole Oklahoma 40133 2774 39
1097916 1097916 2021-03-07 Sequoyah Oklahoma 40135 3984 31
1097917 1097917 2021-03-07 Stephens Oklahoma 40137 4704 68
1097918 1097918 2021-03-07 Texas Oklahoma 40139 3459 24
1097919 1097919 2021-03-07 Tillman Oklahoma 40141 756 14
1097920 1097920 2021-03-07 Tulsa Oklahoma 40143 71541 723
1097921 1097921 2021-03-07 Unknown Oklahoma   5 0
1097922 1097922 2021-03-07 Wagoner Oklahoma 40145 7752 83
1097923 1097923 2021-03-07 Washington Oklahoma 40147 4881 89
1097924 1097924 2021-03-07 Washita Oklahoma 40149 1057 9
1097925 1097925 2021-03-07 Woods Oklahoma 40151 1189 11
1097926 1097926 2021-03-07 Woodward Oklahoma 40153 3098 18
1094601 1094601 2021-03-06 Adair Oklahoma 40001 3135 25
1094602 1094602 2021-03-06 Alfalfa Oklahoma 40003 1149 5
1094603 1094603 2021-03-06 Atoka Oklahoma 40005 1779 13
1094604 1094604 2021-03-06 Beaver Oklahoma 40007 443 6
1094605 1094605 2021-03-06 Beckham Oklahoma 40009 2797 37
1094606 1094606 2021-03-06 Blaine Oklahoma 40011 1003 8
1094607 1094607 2021-03-06 Bryan Oklahoma 40013 5957 56
1094608 1094608 2021-03-06 Caddo Oklahoma 40015 3852 58
1094609 1094609 2021-03-06 Canadian Oklahoma 40017 16062 97
1094610 1094610 2021-03-06 Carter Oklahoma 40019 5757 60
1094611 1094611 2021-03-06 Cherokee Oklahoma 40021 5460 44
1094612 1094612 2021-03-06 Choctaw Oklahoma 40023 1578 14
1094613 1094613 2021-03-06 Cimarron Oklahoma 40025 203 1
1094614 1094614 2021-03-06 Cleveland Oklahoma 40027 28948 274
1094615 1094615 2021-03-06 Coal Oklahoma 40029 684 14
1094616 1094616 2021-03-06 Comanche Oklahoma 40031 12218 140
1094617 1094617 2021-03-06 Cotton Oklahoma 40033 658 13
1094618 1094618 2021-03-06 Craig Oklahoma 40035 1899 11
1094619 1094619 2021-03-06 Creek Oklahoma 40037 6641 117
1094620 1094620 2021-03-06 Custer Oklahoma 40039 4030 72
1094621 1094621 2021-03-06 Delaware Oklahoma 40041 4419 62
1094622 1094622 2021-03-06 Dewey Oklahoma 40043 537 6

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);