ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
757 rows where fips = 40091 and state = "Oklahoma" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
66523 | 66523 | 2020-04-17 | McIntosh | Oklahoma | 40091 | 1 | 0 |
69281 | 69281 | 2020-04-18 | McIntosh | Oklahoma | 40091 | 2 | 0 |
72048 | 72048 | 2020-04-19 | McIntosh | Oklahoma | 40091 | 2 | 0 |
74823 | 74823 | 2020-04-20 | McIntosh | Oklahoma | 40091 | 2 | 0 |
77605 | 77605 | 2020-04-21 | McIntosh | Oklahoma | 40091 | 2 | 0 |
80395 | 80395 | 2020-04-22 | McIntosh | Oklahoma | 40091 | 2 | 0 |
83194 | 83194 | 2020-04-23 | McIntosh | Oklahoma | 40091 | 2 | 0 |
85998 | 85998 | 2020-04-24 | McIntosh | Oklahoma | 40091 | 2 | 0 |
88812 | 88812 | 2020-04-25 | McIntosh | Oklahoma | 40091 | 2 | 0 |
91628 | 91628 | 2020-04-26 | McIntosh | Oklahoma | 40091 | 2 | 0 |
94454 | 94454 | 2020-04-27 | McIntosh | Oklahoma | 40091 | 2 | 0 |
97292 | 97292 | 2020-04-28 | McIntosh | Oklahoma | 40091 | 2 | 0 |
100141 | 100141 | 2020-04-29 | McIntosh | Oklahoma | 40091 | 2 | 0 |
102994 | 102994 | 2020-04-30 | McIntosh | Oklahoma | 40091 | 2 | 0 |
105857 | 105857 | 2020-05-01 | McIntosh | Oklahoma | 40091 | 2 | 0 |
108724 | 108724 | 2020-05-02 | McIntosh | Oklahoma | 40091 | 2 | 0 |
111598 | 111598 | 2020-05-03 | McIntosh | Oklahoma | 40091 | 2 | 0 |
114480 | 114480 | 2020-05-04 | McIntosh | Oklahoma | 40091 | 3 | 0 |
117361 | 117361 | 2020-05-05 | McIntosh | Oklahoma | 40091 | 3 | 0 |
120322 | 120322 | 2020-05-06 | McIntosh | Oklahoma | 40091 | 4 | 0 |
123299 | 123299 | 2020-05-07 | McIntosh | Oklahoma | 40091 | 4 | 0 |
126282 | 126282 | 2020-05-08 | McIntosh | Oklahoma | 40091 | 5 | 0 |
129271 | 129271 | 2020-05-09 | McIntosh | Oklahoma | 40091 | 5 | 0 |
132260 | 132260 | 2020-05-10 | McIntosh | Oklahoma | 40091 | 5 | 0 |
135251 | 135251 | 2020-05-11 | McIntosh | Oklahoma | 40091 | 5 | 0 |
138241 | 138241 | 2020-05-12 | McIntosh | Oklahoma | 40091 | 5 | 0 |
141237 | 141237 | 2020-05-13 | McIntosh | Oklahoma | 40091 | 5 | 0 |
144232 | 144232 | 2020-05-14 | McIntosh | Oklahoma | 40091 | 5 | 0 |
147233 | 147233 | 2020-05-15 | McIntosh | Oklahoma | 40091 | 8 | 0 |
150240 | 150240 | 2020-05-16 | McIntosh | Oklahoma | 40091 | 10 | 0 |
153251 | 153251 | 2020-05-17 | McIntosh | Oklahoma | 40091 | 10 | 0 |
156268 | 156268 | 2020-05-18 | McIntosh | Oklahoma | 40091 | 10 | 0 |
159289 | 159289 | 2020-05-19 | McIntosh | Oklahoma | 40091 | 10 | 1 |
162316 | 162316 | 2020-05-20 | McIntosh | Oklahoma | 40091 | 10 | 1 |
165345 | 165345 | 2020-05-21 | McIntosh | Oklahoma | 40091 | 11 | 1 |
168381 | 168381 | 2020-05-22 | McIntosh | Oklahoma | 40091 | 11 | 1 |
171420 | 171420 | 2020-05-23 | McIntosh | Oklahoma | 40091 | 11 | 1 |
174462 | 174462 | 2020-05-24 | McIntosh | Oklahoma | 40091 | 11 | 1 |
177506 | 177506 | 2020-05-25 | McIntosh | Oklahoma | 40091 | 11 | 1 |
180549 | 180549 | 2020-05-26 | McIntosh | Oklahoma | 40091 | 11 | 1 |
183598 | 183598 | 2020-05-27 | McIntosh | Oklahoma | 40091 | 11 | 1 |
186655 | 186655 | 2020-05-28 | McIntosh | Oklahoma | 40091 | 11 | 1 |
189716 | 189716 | 2020-05-29 | McIntosh | Oklahoma | 40091 | 11 | 1 |
192781 | 192781 | 2020-05-30 | McIntosh | Oklahoma | 40091 | 11 | 1 |
195850 | 195850 | 2020-05-31 | McIntosh | Oklahoma | 40091 | 11 | 1 |
198923 | 198923 | 2020-06-01 | McIntosh | Oklahoma | 40091 | 11 | 1 |
201998 | 201998 | 2020-06-02 | McIntosh | Oklahoma | 40091 | 12 | 1 |
205075 | 205075 | 2020-06-03 | McIntosh | Oklahoma | 40091 | 12 | 1 |
208156 | 208156 | 2020-06-04 | McIntosh | Oklahoma | 40091 | 14 | 1 |
211238 | 211238 | 2020-06-05 | McIntosh | Oklahoma | 40091 | 14 | 1 |
214324 | 214324 | 2020-06-06 | McIntosh | Oklahoma | 40091 | 14 | 1 |
217414 | 217414 | 2020-06-07 | McIntosh | Oklahoma | 40091 | 14 | 1 |
220506 | 220506 | 2020-06-08 | McIntosh | Oklahoma | 40091 | 14 | 1 |
223601 | 223601 | 2020-06-09 | McIntosh | Oklahoma | 40091 | 14 | 1 |
226701 | 226701 | 2020-06-10 | McIntosh | Oklahoma | 40091 | 14 | 1 |
229805 | 229805 | 2020-06-11 | McIntosh | Oklahoma | 40091 | 14 | 1 |
232910 | 232910 | 2020-06-12 | McIntosh | Oklahoma | 40091 | 15 | 1 |
236015 | 236015 | 2020-06-13 | McIntosh | Oklahoma | 40091 | 16 | 1 |
239123 | 239123 | 2020-06-14 | McIntosh | Oklahoma | 40091 | 16 | 1 |
242232 | 242232 | 2020-06-15 | McIntosh | Oklahoma | 40091 | 16 | 1 |
245344 | 245344 | 2020-06-16 | McIntosh | Oklahoma | 40091 | 21 | 1 |
248457 | 248457 | 2020-06-17 | McIntosh | Oklahoma | 40091 | 23 | 1 |
251572 | 251572 | 2020-06-18 | McIntosh | Oklahoma | 40091 | 25 | 1 |
254687 | 254687 | 2020-06-19 | McIntosh | Oklahoma | 40091 | 27 | 1 |
257813 | 257813 | 2020-06-20 | McIntosh | Oklahoma | 40091 | 29 | 1 |
260940 | 260940 | 2020-06-21 | McIntosh | Oklahoma | 40091 | 38 | 1 |
264068 | 264068 | 2020-06-22 | McIntosh | Oklahoma | 40091 | 40 | 1 |
267196 | 267196 | 2020-06-23 | McIntosh | Oklahoma | 40091 | 40 | 1 |
270330 | 270330 | 2020-06-24 | McIntosh | Oklahoma | 40091 | 43 | 1 |
273469 | 273469 | 2020-06-25 | McIntosh | Oklahoma | 40091 | 48 | 1 |
276616 | 276616 | 2020-06-26 | McIntosh | Oklahoma | 40091 | 49 | 1 |
279764 | 279764 | 2020-06-27 | McIntosh | Oklahoma | 40091 | 49 | 1 |
282910 | 282910 | 2020-06-28 | McIntosh | Oklahoma | 40091 | 50 | 1 |
286055 | 286055 | 2020-06-29 | McIntosh | Oklahoma | 40091 | 52 | 1 |
289205 | 289205 | 2020-06-30 | McIntosh | Oklahoma | 40091 | 57 | 1 |
292358 | 292358 | 2020-07-01 | McIntosh | Oklahoma | 40091 | 59 | 1 |
295514 | 295514 | 2020-07-02 | McIntosh | Oklahoma | 40091 | 63 | 1 |
298673 | 298673 | 2020-07-03 | McIntosh | Oklahoma | 40091 | 64 | 1 |
301836 | 301836 | 2020-07-04 | McIntosh | Oklahoma | 40091 | 66 | 1 |
304999 | 304999 | 2020-07-05 | McIntosh | Oklahoma | 40091 | 67 | 1 |
308166 | 308166 | 2020-07-06 | McIntosh | Oklahoma | 40091 | 70 | 1 |
311335 | 311335 | 2020-07-07 | McIntosh | Oklahoma | 40091 | 69 | 1 |
314507 | 314507 | 2020-07-08 | McIntosh | Oklahoma | 40091 | 71 | 1 |
317680 | 317680 | 2020-07-09 | McIntosh | Oklahoma | 40091 | 79 | 1 |
320857 | 320857 | 2020-07-10 | McIntosh | Oklahoma | 40091 | 84 | 1 |
324037 | 324037 | 2020-07-11 | McIntosh | Oklahoma | 40091 | 85 | 1 |
327222 | 327222 | 2020-07-12 | McIntosh | Oklahoma | 40091 | 86 | 1 |
330409 | 330409 | 2020-07-13 | McIntosh | Oklahoma | 40091 | 87 | 1 |
333601 | 333601 | 2020-07-14 | McIntosh | Oklahoma | 40091 | 88 | 1 |
336795 | 336795 | 2020-07-15 | McIntosh | Oklahoma | 40091 | 88 | 1 |
339991 | 339991 | 2020-07-16 | McIntosh | Oklahoma | 40091 | 92 | 1 |
343189 | 343189 | 2020-07-17 | McIntosh | Oklahoma | 40091 | 96 | 1 |
346389 | 346389 | 2020-07-18 | McIntosh | Oklahoma | 40091 | 99 | 1 |
349589 | 349589 | 2020-07-19 | McIntosh | Oklahoma | 40091 | 99 | 1 |
352792 | 352792 | 2020-07-20 | McIntosh | Oklahoma | 40091 | 100 | 1 |
355995 | 355995 | 2020-07-21 | McIntosh | Oklahoma | 40091 | 102 | 1 |
359199 | 359199 | 2020-07-22 | McIntosh | Oklahoma | 40091 | 109 | 1 |
362405 | 362405 | 2020-07-23 | McIntosh | Oklahoma | 40091 | 110 | 1 |
365611 | 365611 | 2020-07-24 | McIntosh | Oklahoma | 40091 | 119 | 1 |
368820 | 368820 | 2020-07-25 | McIntosh | Oklahoma | 40091 | 124 | 1 |
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);