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

43,543 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 · 43,543 ✖
Link rowid date ▲ county state fips cases deaths
1818765 1818765 2021-10-15 Adair Oklahoma 40001 4818 57
1818766 1818766 2021-10-15 Alfalfa Oklahoma 40003 1290 7
1818767 1818767 2021-10-15 Atoka Oklahoma 40005 2698 30
1818768 1818768 2021-10-15 Beaver Oklahoma 40007 550 6
1818769 1818769 2021-10-15 Beckham Oklahoma 40009 3382 63
1818770 1818770 2021-10-15 Blaine Oklahoma 40011 1477 26
1818771 1818771 2021-10-15 Bryan Oklahoma 40013 8479 103
1818772 1818772 2021-10-15 Caddo Oklahoma 40015 5094 114
1818773 1818773 2021-10-15 Canadian Oklahoma 40017 22572 238
1818774 1818774 2021-10-15 Carter Oklahoma 40019 8805 158
1818775 1818775 2021-10-15 Cherokee Oklahoma 40021 8912 103
1818776 1818776 2021-10-15 Choctaw Oklahoma 40023 2701 43
1818777 1818777 2021-10-15 Cimarron Oklahoma 40025 306 2
1818778 1818778 2021-10-15 Cleveland Oklahoma 40027 42536 540
1818779 1818779 2021-10-15 Coal Oklahoma 40029 1027 19
1818780 1818780 2021-10-15 Comanche Oklahoma 40031 20807 269
1818781 1818781 2021-10-15 Cotton Oklahoma 40033 951 20
1818782 1818782 2021-10-15 Craig Oklahoma 40035 2950 29
1818783 1818783 2021-10-15 Creek Oklahoma 40037 10901 231
1818784 1818784 2021-10-15 Custer Oklahoma 40039 4902 115
1818785 1818785 2021-10-15 Delaware Oklahoma 40041 7180 139
1818786 1818786 2021-10-15 Dewey Oklahoma 40043 659 16
1818787 1818787 2021-10-15 Ellis Oklahoma 40045 437 6
1818788 1818788 2021-10-15 Garfield Oklahoma 40047 9849 157
1818789 1818789 2021-10-15 Garvin Oklahoma 40049 4659 95
1818790 1818790 2021-10-15 Grady Oklahoma 40051 7911 156
1818791 1818791 2021-10-15 Grant Oklahoma 40053 690 7
1818792 1818792 2021-10-15 Greer Oklahoma 40055 739 23
1818793 1818793 2021-10-15 Harmon Oklahoma 40057 360 6
1818794 1818794 2021-10-15 Harper Oklahoma 40059 484 8
1818795 1818795 2021-10-15 Haskell Oklahoma 40061 1829 26
1818796 1818796 2021-10-15 Hughes Oklahoma 40063 1658 37
1818797 1818797 2021-10-15 Jackson Oklahoma 40065 3808 67
1818798 1818798 2021-10-15 Jefferson Oklahoma 40067 920 18
1818799 1818799 2021-10-15 Johnston Oklahoma 40069 1915 44
1818800 1818800 2021-10-15 Kay Oklahoma 40071 7044 148
1818801 1818801 2021-10-15 Kingfisher Oklahoma 40073 2544 44
1818802 1818802 2021-10-15 Kiowa Oklahoma 40075 1117 30
1818803 1818803 2021-10-15 Latimer Oklahoma 40077 1451 14
1818804 1818804 2021-10-15 Le Flore Oklahoma 40079 7885 77
1818805 1818805 2021-10-15 Lincoln Oklahoma 40081 4769 101
1818806 1818806 2021-10-15 Logan Oklahoma 40083 5975 97
1818807 1818807 2021-10-15 Love Oklahoma 40085 1970 26
1818808 1818808 2021-10-15 Major Oklahoma 40093 1219 28
1818809 1818809 2021-10-15 Marshall Oklahoma 40095 2681 26
1818810 1818810 2021-10-15 Mayes Oklahoma 40097 6642 105
1818811 1818811 2021-10-15 McClain Oklahoma 40087 7325 92
1818812 1818812 2021-10-15 McCurtain Oklahoma 40089 5603 113
1818813 1818813 2021-10-15 McIntosh Oklahoma 40091 2831 80
1818814 1818814 2021-10-15 Murray Oklahoma 40099 2574 51
1818815 1818815 2021-10-15 Muskogee Oklahoma 40101 13176 243
1818816 1818816 2021-10-15 Noble Oklahoma 40103 1865 28
1818817 1818817 2021-10-15 Nowata Oklahoma 40105 1760 24
1818818 1818818 2021-10-15 Okfuskee Oklahoma 40107 2273 34
1818819 1818819 2021-10-15 Oklahoma Oklahoma 40109 117180 1577
1818820 1818820 2021-10-15 Okmulgee Oklahoma 40111 5767 119
1818821 1818821 2021-10-15 Osage Oklahoma 40113 6765 117
1818822 1818822 2021-10-15 Ottawa Oklahoma 40115 5970 90
1818823 1818823 2021-10-15 Pawnee Oklahoma 40117 2590 60
1818824 1818824 2021-10-15 Payne Oklahoma 40119 11775 100
1818825 1818825 2021-10-15 Pittsburg Oklahoma 40121 6569 108
1818826 1818826 2021-10-15 Pontotoc Oklahoma 40123 6701 93
1818827 1818827 2021-10-15 Pottawatomie Oklahoma 40125 11809 173
1818828 1818828 2021-10-15 Pushmataha Oklahoma 40127 1747 34
1818829 1818829 2021-10-15 Roger Mills Oklahoma 40129 487 12
1818830 1818830 2021-10-15 Rogers Oklahoma 40131 15443 260
1818831 1818831 2021-10-15 Seminole Oklahoma 40133 3755 92
1818832 1818832 2021-10-15 Sequoyah Oklahoma 40135 6606 79
1818833 1818833 2021-10-15 Stephens Oklahoma 40137 7364 122
1818834 1818834 2021-10-15 Texas Oklahoma 40139 3998 37
1818835 1818835 2021-10-15 Tillman Oklahoma 40141 972 21
1818836 1818836 2021-10-15 Tulsa Oklahoma 40143 105510 1505
1818837 1818837 2021-10-15 Unknown Oklahoma   4431 0
1818838 1818838 2021-10-15 Wagoner Oklahoma 40145 12429 191
1818839 1818839 2021-10-15 Washington Oklahoma 40147 8310 183
1818840 1818840 2021-10-15 Washita Oklahoma 40149 1454 25
1818841 1818841 2021-10-15 Woods Oklahoma 40151 1599 22
1818842 1818842 2021-10-15 Woodward Oklahoma 40153 3681 43
1815516 1815516 2021-10-14 Adair Oklahoma 40001 4818 57
1815517 1815517 2021-10-14 Alfalfa Oklahoma 40003 1290 7
1815518 1815518 2021-10-14 Atoka Oklahoma 40005 2698 30
1815519 1815519 2021-10-14 Beaver Oklahoma 40007 550 6
1815520 1815520 2021-10-14 Beckham Oklahoma 40009 3382 63
1815521 1815521 2021-10-14 Blaine Oklahoma 40011 1477 26
1815522 1815522 2021-10-14 Bryan Oklahoma 40013 8479 103
1815523 1815523 2021-10-14 Caddo Oklahoma 40015 5094 114
1815524 1815524 2021-10-14 Canadian Oklahoma 40017 22572 238
1815525 1815525 2021-10-14 Carter Oklahoma 40019 8805 158
1815526 1815526 2021-10-14 Cherokee Oklahoma 40021 8912 103
1815527 1815527 2021-10-14 Choctaw Oklahoma 40023 2701 43
1815528 1815528 2021-10-14 Cimarron Oklahoma 40025 306 2
1815529 1815529 2021-10-14 Cleveland Oklahoma 40027 42536 540
1815530 1815530 2021-10-14 Coal Oklahoma 40029 1027 19
1815531 1815531 2021-10-14 Comanche Oklahoma 40031 20807 269
1815532 1815532 2021-10-14 Cotton Oklahoma 40033 951 20
1815533 1815533 2021-10-14 Craig Oklahoma 40035 2950 29
1815534 1815534 2021-10-14 Creek Oklahoma 40037 10901 231
1815535 1815535 2021-10-14 Custer Oklahoma 40039 4902 115
1815536 1815536 2021-10-14 Delaware Oklahoma 40041 7180 139
1815537 1815537 2021-10-14 Dewey Oklahoma 40043 659 16

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