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

59,923 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 >30

county >30

state 1

  • Oklahoma · 59,923 ✖
Link rowid date ▲ county state fips cases deaths
2501733 2501733 2022-05-13 Adair Oklahoma 40001 8001 75
2501734 2501734 2022-05-13 Alfalfa Oklahoma 40003 1716 15
2501735 2501735 2022-05-13 Atoka Oklahoma 40005 3911 54
2501736 2501736 2022-05-13 Beaver Oklahoma 40007 969 11
2501737 2501737 2022-05-13 Beckham Oklahoma 40009 5983 106
2501738 2501738 2022-05-13 Blaine Oklahoma 40011 2461 43
2501739 2501739 2022-05-13 Bryan Oklahoma 40013 13672 136
2501740 2501740 2022-05-13 Caddo Oklahoma 40015 8278 171
2501741 2501741 2022-05-13 Canadian Oklahoma 40017 39889 390
2501742 2501742 2022-05-13 Carter Oklahoma 40019 14366 239
2501743 2501743 2022-05-13 Cherokee Oklahoma 40021 14532 151
2501744 2501744 2022-05-13 Choctaw Oklahoma 40023 4056 64
2501745 2501745 2022-05-13 Cimarron Oklahoma 40025 566 7
2501746 2501746 2022-05-13 Cleveland Oklahoma 40027 79713 822
2501747 2501747 2022-05-13 Coal Oklahoma 40029 1672 24
2501748 2501748 2022-05-13 Comanche Oklahoma 40031 33173 397
2501749 2501749 2022-05-13 Cotton Oklahoma 40033 1464 29
2501750 2501750 2022-05-13 Craig Oklahoma 40035 4785 55
2501751 2501751 2022-05-13 Creek Oklahoma 40037 18245 338
2501752 2501752 2022-05-13 Custer Oklahoma 40039 7935 169
2501753 2501753 2022-05-13 Delaware Oklahoma 40041 11098 203
2501754 2501754 2022-05-13 Dewey Oklahoma 40043 1064 32
2501755 2501755 2022-05-13 Ellis Oklahoma 40045 774 8
2501756 2501756 2022-05-13 Garfield Oklahoma 40047 15233 295
2501757 2501757 2022-05-13 Garvin Oklahoma 40049 7068 148
2501758 2501758 2022-05-13 Grady Oklahoma 40051 13773 246
2501759 2501759 2022-05-13 Grant Oklahoma 40053 1036 16
2501760 2501760 2022-05-13 Greer Oklahoma 40055 1296 37
2501761 2501761 2022-05-13 Harmon Oklahoma 40057 522 12
2501762 2501762 2022-05-13 Harper Oklahoma 40059 714 12
2501763 2501763 2022-05-13 Haskell Oklahoma 40061 2796 41
2501764 2501764 2022-05-13 Hughes Oklahoma 40063 2586 62
2501765 2501765 2022-05-13 Jackson Oklahoma 40065 6575 108
2501766 2501766 2022-05-13 Jefferson Oklahoma 40067 1339 27
2501767 2501767 2022-05-13 Johnston Oklahoma 40069 3041 54
2501768 2501768 2022-05-13 Kay Oklahoma 40071 12327 216
2501769 2501769 2022-05-13 Kingfisher Oklahoma 40073 4178 71
2501770 2501770 2022-05-13 Kiowa Oklahoma 40075 1965 52
2501771 2501771 2022-05-13 Latimer Oklahoma 40077 2273 35
2501772 2501772 2022-05-13 Le Flore Oklahoma 40079 12521 107
2501773 2501773 2022-05-13 Lincoln Oklahoma 40081 7897 140
2501774 2501774 2022-05-13 Logan Oklahoma 40083 10911 160
2501775 2501775 2022-05-13 Love Oklahoma 40085 3109 39
2501776 2501776 2022-05-13 Major Oklahoma 40093 2461 41
2501777 2501777 2022-05-13 Marshall Oklahoma 40095 4603 46
2501778 2501778 2022-05-13 Mayes Oklahoma 40097 10399 163
2501779 2501779 2022-05-13 McClain Oklahoma 40087 11773 137
2501780 2501780 2022-05-13 McCurtain Oklahoma 40089 8117 166
2501781 2501781 2022-05-13 McIntosh Oklahoma 40091 4864 124
2501782 2501782 2022-05-13 Murray Oklahoma 40099 4165 77
2501783 2501783 2022-05-13 Muskogee Oklahoma 40101 19987 348
2501784 2501784 2022-05-13 Noble Oklahoma 40103 3050 39
2501785 2501785 2022-05-13 Nowata Oklahoma 40105 2785 40
2501786 2501786 2022-05-13 Okfuskee Oklahoma 40107 3533 62
2501787 2501787 2022-05-13 Oklahoma Oklahoma 40109 199990 2467
2501788 2501788 2022-05-13 Okmulgee Oklahoma 40111 9686 188
2501789 2501789 2022-05-13 Osage Oklahoma 40113 10965 167
2501790 2501790 2022-05-13 Ottawa Oklahoma 40115 9204 127
2501791 2501791 2022-05-13 Pawnee Oklahoma 40117 4121 85
2501792 2501792 2022-05-13 Payne Oklahoma 40119 18463 166
2501793 2501793 2022-05-13 Pittsburg Oklahoma 40121 10780 211
2501794 2501794 2022-05-13 Pontotoc Oklahoma 40123 12132 150
2501795 2501795 2022-05-13 Pottawatomie Oklahoma 40125 20703 284
2501796 2501796 2022-05-13 Pushmataha Oklahoma 40127 2677 45
2501797 2501797 2022-05-13 Roger Mills Oklahoma 40129 892 16
2501798 2501798 2022-05-13 Rogers Oklahoma 40131 25476 389
2501799 2501799 2022-05-13 Seminole Oklahoma 40133 6142 135
2501800 2501800 2022-05-13 Sequoyah Oklahoma 40135 10639 106
2501801 2501801 2022-05-13 Stephens Oklahoma 40137 11374 205
2501802 2501802 2022-05-13 Texas Oklahoma 40139 5996 54
2501803 2501803 2022-05-13 Tillman Oklahoma 40141 1532 35
2501804 2501804 2022-05-13 Tulsa Oklahoma 40143 172585 2183
2501805 2501805 2022-05-13 Unknown Oklahoma   806 0
2501806 2501806 2022-05-13 Wagoner Oklahoma 40145 21915 277
2501807 2501807 2022-05-13 Washington Oklahoma 40147 12718 262
2501808 2501808 2022-05-13 Washita Oklahoma 40149 2639 54
2501809 2501809 2022-05-13 Woods Oklahoma 40151 2352 38
2501810 2501810 2022-05-13 Woodward Oklahoma 40153 5172 76
2498475 2498475 2022-05-12 Adair Oklahoma 40001 8001 75
2498476 2498476 2022-05-12 Alfalfa Oklahoma 40003 1716 15
2498477 2498477 2022-05-12 Atoka Oklahoma 40005 3911 54
2498478 2498478 2022-05-12 Beaver Oklahoma 40007 969 11
2498479 2498479 2022-05-12 Beckham Oklahoma 40009 5983 106
2498480 2498480 2022-05-12 Blaine Oklahoma 40011 2461 43
2498481 2498481 2022-05-12 Bryan Oklahoma 40013 13672 136
2498482 2498482 2022-05-12 Caddo Oklahoma 40015 8278 171
2498483 2498483 2022-05-12 Canadian Oklahoma 40017 39889 390
2498484 2498484 2022-05-12 Carter Oklahoma 40019 14366 239
2498485 2498485 2022-05-12 Cherokee Oklahoma 40021 14532 151
2498486 2498486 2022-05-12 Choctaw Oklahoma 40023 4056 64
2498487 2498487 2022-05-12 Cimarron Oklahoma 40025 566 7
2498488 2498488 2022-05-12 Cleveland Oklahoma 40027 79713 822
2498489 2498489 2022-05-12 Coal Oklahoma 40029 1672 24
2498490 2498490 2022-05-12 Comanche Oklahoma 40031 33173 397
2498491 2498491 2022-05-12 Cotton Oklahoma 40033 1464 29
2498492 2498492 2022-05-12 Craig Oklahoma 40035 4785 55
2498493 2498493 2022-05-12 Creek Oklahoma 40037 18245 338
2498494 2498494 2022-05-12 Custer Oklahoma 40039 7935 169
2498495 2498495 2022-05-12 Delaware Oklahoma 40041 11098 203
2498496 2498496 2022-05-12 Dewey Oklahoma 40043 1064 32

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