ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
59,923 rows where state = "Oklahoma" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 40143 799
- 40109 792
- 40065 791
- 40027 790
- 40071 790
- 40119 790
- 40017 789
- 40117 788
- 40039 786
- 40051 786
- 40083 786
- 40087 786
- 40147 786
- 40049 785
- 40101 783
- 40103 783
- 40123 782
- 40097 781
- 40145 781
- 40001 780
- 40013 780
- 40019 780
- 40037 780
- 40041 780
- 40113 780
- 40125 780
- 40137 780
- 40031 779
- 40035 779
- 40081 779
- …
date (date) >30 ✖
- 2020-07-27 78
- 2020-08-15 78
- 2020-08-16 78
- 2020-08-17 78
- 2020-08-18 78
- 2020-08-19 78
- 2020-08-20 78
- 2020-08-21 78
- 2020-08-22 78
- 2020-08-23 78
- 2020-08-24 78
- 2020-08-25 78
- 2020-08-26 78
- 2020-08-27 78
- 2020-08-28 78
- 2020-08-29 78
- 2020-08-30 78
- 2020-08-31 78
- 2020-09-01 78
- 2020-09-02 78
- 2020-09-03 78
- 2020-09-04 78
- 2020-09-05 78
- 2020-09-06 78
- 2020-09-07 78
- 2020-09-08 78
- 2020-09-09 78
- 2020-09-10 78
- 2020-09-11 78
- 2020-09-12 78
- …
county >30
- Tulsa 799
- Oklahoma 792
- Jackson 791
- Cleveland 790
- Kay 790
- Payne 790
- Canadian 789
- Pawnee 788
- Custer 786
- Grady 786
- Logan 786
- McClain 786
- Washington 786
- Garvin 785
- Muskogee 783
- Noble 783
- Pontotoc 782
- Mayes 781
- Wagoner 781
- Adair 780
- Bryan 780
- Carter 780
- Creek 780
- Delaware 780
- Osage 780
- Pottawatomie 780
- Stephens 780
- Comanche 779
- Craig 779
- Lincoln 779
- …
state 1
- Oklahoma · 59,923 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
11907 | 11907 | 2020-03-25 | Adair | Oklahoma | 40001 | 2 | 0 |
13517 | 13517 | 2020-03-26 | Adair | Oklahoma | 40001 | 2 | 0 |
15256 | 15256 | 2020-03-27 | Adair | Oklahoma | 40001 | 3 | 0 |
17101 | 17101 | 2020-03-28 | Adair | Oklahoma | 40001 | 3 | 0 |
19035 | 19035 | 2020-03-29 | Adair | Oklahoma | 40001 | 4 | 0 |
21082 | 21082 | 2020-03-30 | Adair | Oklahoma | 40001 | 4 | 0 |
23215 | 23215 | 2020-03-31 | Adair | Oklahoma | 40001 | 4 | 0 |
25411 | 25411 | 2020-04-01 | Adair | Oklahoma | 40001 | 8 | 0 |
27680 | 27680 | 2020-04-02 | Adair | Oklahoma | 40001 | 9 | 0 |
30009 | 30009 | 2020-04-03 | Adair | Oklahoma | 40001 | 14 | 0 |
32398 | 32398 | 2020-04-04 | Adair | Oklahoma | 40001 | 14 | 0 |
34832 | 34832 | 2020-04-05 | Adair | Oklahoma | 40001 | 18 | 0 |
37305 | 37305 | 2020-04-06 | Adair | Oklahoma | 40001 | 20 | 0 |
39823 | 39823 | 2020-04-07 | Adair | Oklahoma | 40001 | 25 | 1 |
42383 | 42383 | 2020-04-08 | Adair | Oklahoma | 40001 | 25 | 2 |
44969 | 44969 | 2020-04-09 | Adair | Oklahoma | 40001 | 25 | 2 |
47584 | 47584 | 2020-04-10 | Adair | Oklahoma | 40001 | 26 | 2 |
50240 | 50240 | 2020-04-11 | Adair | Oklahoma | 40001 | 27 | 2 |
52913 | 52913 | 2020-04-12 | Adair | Oklahoma | 40001 | 27 | 2 |
55597 | 55597 | 2020-04-13 | Adair | Oklahoma | 40001 | 27 | 2 |
58298 | 58298 | 2020-04-14 | Adair | Oklahoma | 40001 | 28 | 2 |
61013 | 61013 | 2020-04-15 | Adair | Oklahoma | 40001 | 29 | 3 |
63739 | 63739 | 2020-04-16 | Adair | Oklahoma | 40001 | 29 | 3 |
66482 | 66482 | 2020-04-17 | Adair | Oklahoma | 40001 | 38 | 3 |
69239 | 69239 | 2020-04-18 | Adair | Oklahoma | 40001 | 41 | 3 |
72006 | 72006 | 2020-04-19 | Adair | Oklahoma | 40001 | 43 | 3 |
74781 | 74781 | 2020-04-20 | Adair | Oklahoma | 40001 | 46 | 3 |
77562 | 77562 | 2020-04-21 | Adair | Oklahoma | 40001 | 47 | 3 |
80352 | 80352 | 2020-04-22 | Adair | Oklahoma | 40001 | 49 | 3 |
83151 | 83151 | 2020-04-23 | Adair | Oklahoma | 40001 | 50 | 3 |
85955 | 85955 | 2020-04-24 | Adair | Oklahoma | 40001 | 53 | 3 |
88769 | 88769 | 2020-04-25 | Adair | Oklahoma | 40001 | 54 | 3 |
91585 | 91585 | 2020-04-26 | Adair | Oklahoma | 40001 | 55 | 3 |
94411 | 94411 | 2020-04-27 | Adair | Oklahoma | 40001 | 55 | 3 |
97249 | 97249 | 2020-04-28 | Adair | Oklahoma | 40001 | 64 | 3 |
100098 | 100098 | 2020-04-29 | Adair | Oklahoma | 40001 | 64 | 3 |
102951 | 102951 | 2020-04-30 | Adair | Oklahoma | 40001 | 64 | 3 |
105814 | 105814 | 2020-05-01 | Adair | Oklahoma | 40001 | 65 | 3 |
108681 | 108681 | 2020-05-02 | Adair | Oklahoma | 40001 | 65 | 3 |
111555 | 111555 | 2020-05-03 | Adair | Oklahoma | 40001 | 65 | 3 |
114436 | 114436 | 2020-05-04 | Adair | Oklahoma | 40001 | 65 | 3 |
117317 | 117317 | 2020-05-05 | Adair | Oklahoma | 40001 | 66 | 3 |
120278 | 120278 | 2020-05-06 | Adair | Oklahoma | 40001 | 68 | 3 |
123255 | 123255 | 2020-05-07 | Adair | Oklahoma | 40001 | 69 | 3 |
126238 | 126238 | 2020-05-08 | Adair | Oklahoma | 40001 | 72 | 3 |
129227 | 129227 | 2020-05-09 | Adair | Oklahoma | 40001 | 74 | 3 |
132216 | 132216 | 2020-05-10 | Adair | Oklahoma | 40001 | 74 | 3 |
135207 | 135207 | 2020-05-11 | Adair | Oklahoma | 40001 | 72 | 3 |
138197 | 138197 | 2020-05-12 | Adair | Oklahoma | 40001 | 74 | 3 |
141193 | 141193 | 2020-05-13 | Adair | Oklahoma | 40001 | 74 | 3 |
144188 | 144188 | 2020-05-14 | Adair | Oklahoma | 40001 | 74 | 3 |
147189 | 147189 | 2020-05-15 | Adair | Oklahoma | 40001 | 74 | 3 |
150196 | 150196 | 2020-05-16 | Adair | Oklahoma | 40001 | 74 | 3 |
153207 | 153207 | 2020-05-17 | Adair | Oklahoma | 40001 | 75 | 3 |
156224 | 156224 | 2020-05-18 | Adair | Oklahoma | 40001 | 75 | 3 |
159244 | 159244 | 2020-05-19 | Adair | Oklahoma | 40001 | 77 | 3 |
162271 | 162271 | 2020-05-20 | Adair | Oklahoma | 40001 | 78 | 3 |
165300 | 165300 | 2020-05-21 | Adair | Oklahoma | 40001 | 78 | 3 |
168336 | 168336 | 2020-05-22 | Adair | Oklahoma | 40001 | 79 | 3 |
171375 | 171375 | 2020-05-23 | Adair | Oklahoma | 40001 | 82 | 3 |
174417 | 174417 | 2020-05-24 | Adair | Oklahoma | 40001 | 82 | 3 |
177461 | 177461 | 2020-05-25 | Adair | Oklahoma | 40001 | 82 | 3 |
180504 | 180504 | 2020-05-26 | Adair | Oklahoma | 40001 | 82 | 3 |
183553 | 183553 | 2020-05-27 | Adair | Oklahoma | 40001 | 82 | 3 |
186610 | 186610 | 2020-05-28 | Adair | Oklahoma | 40001 | 84 | 3 |
189670 | 189670 | 2020-05-29 | Adair | Oklahoma | 40001 | 85 | 3 |
192735 | 192735 | 2020-05-30 | Adair | Oklahoma | 40001 | 87 | 3 |
195804 | 195804 | 2020-05-31 | Adair | Oklahoma | 40001 | 87 | 3 |
198877 | 198877 | 2020-06-01 | Adair | Oklahoma | 40001 | 88 | 3 |
201952 | 201952 | 2020-06-02 | Adair | Oklahoma | 40001 | 91 | 3 |
205029 | 205029 | 2020-06-03 | Adair | Oklahoma | 40001 | 91 | 4 |
208110 | 208110 | 2020-06-04 | Adair | Oklahoma | 40001 | 93 | 4 |
211192 | 211192 | 2020-06-05 | Adair | Oklahoma | 40001 | 93 | 4 |
214278 | 214278 | 2020-06-06 | Adair | Oklahoma | 40001 | 93 | 4 |
217368 | 217368 | 2020-06-07 | Adair | Oklahoma | 40001 | 94 | 4 |
220460 | 220460 | 2020-06-08 | Adair | Oklahoma | 40001 | 94 | 4 |
223555 | 223555 | 2020-06-09 | Adair | Oklahoma | 40001 | 95 | 4 |
226655 | 226655 | 2020-06-10 | Adair | Oklahoma | 40001 | 95 | 4 |
229759 | 229759 | 2020-06-11 | Adair | Oklahoma | 40001 | 95 | 4 |
232864 | 232864 | 2020-06-12 | Adair | Oklahoma | 40001 | 95 | 4 |
235969 | 235969 | 2020-06-13 | Adair | Oklahoma | 40001 | 96 | 4 |
239077 | 239077 | 2020-06-14 | Adair | Oklahoma | 40001 | 96 | 4 |
242186 | 242186 | 2020-06-15 | Adair | Oklahoma | 40001 | 96 | 4 |
245298 | 245298 | 2020-06-16 | Adair | Oklahoma | 40001 | 96 | 4 |
248411 | 248411 | 2020-06-17 | Adair | Oklahoma | 40001 | 96 | 4 |
251526 | 251526 | 2020-06-18 | Adair | Oklahoma | 40001 | 101 | 4 |
254641 | 254641 | 2020-06-19 | Adair | Oklahoma | 40001 | 103 | 4 |
257767 | 257767 | 2020-06-20 | Adair | Oklahoma | 40001 | 104 | 4 |
260893 | 260893 | 2020-06-21 | Adair | Oklahoma | 40001 | 107 | 4 |
264021 | 264021 | 2020-06-22 | Adair | Oklahoma | 40001 | 108 | 4 |
267149 | 267149 | 2020-06-23 | Adair | Oklahoma | 40001 | 110 | 4 |
270283 | 270283 | 2020-06-24 | Adair | Oklahoma | 40001 | 110 | 4 |
273422 | 273422 | 2020-06-25 | Adair | Oklahoma | 40001 | 111 | 4 |
276569 | 276569 | 2020-06-26 | Adair | Oklahoma | 40001 | 111 | 4 |
279717 | 279717 | 2020-06-27 | Adair | Oklahoma | 40001 | 111 | 4 |
282863 | 282863 | 2020-06-28 | Adair | Oklahoma | 40001 | 112 | 4 |
286008 | 286008 | 2020-06-29 | Adair | Oklahoma | 40001 | 114 | 4 |
289158 | 289158 | 2020-06-30 | Adair | Oklahoma | 40001 | 115 | 4 |
292310 | 292310 | 2020-07-01 | Adair | Oklahoma | 40001 | 115 | 4 |
295466 | 295466 | 2020-07-02 | Adair | Oklahoma | 40001 | 119 | 4 |
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);