ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
715 rows where fips = 40063 and state = "Oklahoma" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
189699 | 189699 | 2020-05-29 | Hughes | Oklahoma | 40063 | 1 | 0 |
192764 | 192764 | 2020-05-30 | Hughes | Oklahoma | 40063 | 1 | 0 |
195833 | 195833 | 2020-05-31 | Hughes | Oklahoma | 40063 | 1 | 0 |
198906 | 198906 | 2020-06-01 | Hughes | Oklahoma | 40063 | 1 | 0 |
201981 | 201981 | 2020-06-02 | Hughes | Oklahoma | 40063 | 3 | 0 |
205058 | 205058 | 2020-06-03 | Hughes | Oklahoma | 40063 | 3 | 0 |
208139 | 208139 | 2020-06-04 | Hughes | Oklahoma | 40063 | 3 | 0 |
211221 | 211221 | 2020-06-05 | Hughes | Oklahoma | 40063 | 3 | 0 |
214307 | 214307 | 2020-06-06 | Hughes | Oklahoma | 40063 | 3 | 0 |
217397 | 217397 | 2020-06-07 | Hughes | Oklahoma | 40063 | 3 | 0 |
220489 | 220489 | 2020-06-08 | Hughes | Oklahoma | 40063 | 3 | 0 |
223584 | 223584 | 2020-06-09 | Hughes | Oklahoma | 40063 | 3 | 0 |
226684 | 226684 | 2020-06-10 | Hughes | Oklahoma | 40063 | 3 | 0 |
229788 | 229788 | 2020-06-11 | Hughes | Oklahoma | 40063 | 3 | 0 |
232893 | 232893 | 2020-06-12 | Hughes | Oklahoma | 40063 | 3 | 0 |
235998 | 235998 | 2020-06-13 | Hughes | Oklahoma | 40063 | 3 | 0 |
239106 | 239106 | 2020-06-14 | Hughes | Oklahoma | 40063 | 3 | 0 |
242215 | 242215 | 2020-06-15 | Hughes | Oklahoma | 40063 | 3 | 0 |
245327 | 245327 | 2020-06-16 | Hughes | Oklahoma | 40063 | 3 | 0 |
248440 | 248440 | 2020-06-17 | Hughes | Oklahoma | 40063 | 3 | 0 |
251555 | 251555 | 2020-06-18 | Hughes | Oklahoma | 40063 | 3 | 0 |
254670 | 254670 | 2020-06-19 | Hughes | Oklahoma | 40063 | 3 | 0 |
257796 | 257796 | 2020-06-20 | Hughes | Oklahoma | 40063 | 3 | 0 |
260923 | 260923 | 2020-06-21 | Hughes | Oklahoma | 40063 | 5 | 0 |
264051 | 264051 | 2020-06-22 | Hughes | Oklahoma | 40063 | 5 | 0 |
267179 | 267179 | 2020-06-23 | Hughes | Oklahoma | 40063 | 5 | 0 |
270313 | 270313 | 2020-06-24 | Hughes | Oklahoma | 40063 | 6 | 0 |
273452 | 273452 | 2020-06-25 | Hughes | Oklahoma | 40063 | 6 | 0 |
276599 | 276599 | 2020-06-26 | Hughes | Oklahoma | 40063 | 7 | 0 |
279747 | 279747 | 2020-06-27 | Hughes | Oklahoma | 40063 | 7 | 0 |
282893 | 282893 | 2020-06-28 | Hughes | Oklahoma | 40063 | 10 | 0 |
286038 | 286038 | 2020-06-29 | Hughes | Oklahoma | 40063 | 10 | 0 |
289188 | 289188 | 2020-06-30 | Hughes | Oklahoma | 40063 | 10 | 0 |
292341 | 292341 | 2020-07-01 | Hughes | Oklahoma | 40063 | 11 | 0 |
295497 | 295497 | 2020-07-02 | Hughes | Oklahoma | 40063 | 11 | 0 |
298656 | 298656 | 2020-07-03 | Hughes | Oklahoma | 40063 | 13 | 0 |
301819 | 301819 | 2020-07-04 | Hughes | Oklahoma | 40063 | 13 | 0 |
304982 | 304982 | 2020-07-05 | Hughes | Oklahoma | 40063 | 13 | 0 |
308149 | 308149 | 2020-07-06 | Hughes | Oklahoma | 40063 | 13 | 0 |
311318 | 311318 | 2020-07-07 | Hughes | Oklahoma | 40063 | 13 | 0 |
314490 | 314490 | 2020-07-08 | Hughes | Oklahoma | 40063 | 13 | 0 |
317663 | 317663 | 2020-07-09 | Hughes | Oklahoma | 40063 | 13 | 0 |
320840 | 320840 | 2020-07-10 | Hughes | Oklahoma | 40063 | 14 | 0 |
324020 | 324020 | 2020-07-11 | Hughes | Oklahoma | 40063 | 14 | 0 |
327205 | 327205 | 2020-07-12 | Hughes | Oklahoma | 40063 | 14 | 0 |
330392 | 330392 | 2020-07-13 | Hughes | Oklahoma | 40063 | 14 | 0 |
333584 | 333584 | 2020-07-14 | Hughes | Oklahoma | 40063 | 15 | 0 |
336778 | 336778 | 2020-07-15 | Hughes | Oklahoma | 40063 | 16 | 0 |
339974 | 339974 | 2020-07-16 | Hughes | Oklahoma | 40063 | 17 | 0 |
343172 | 343172 | 2020-07-17 | Hughes | Oklahoma | 40063 | 20 | 1 |
346372 | 346372 | 2020-07-18 | Hughes | Oklahoma | 40063 | 22 | 1 |
349572 | 349572 | 2020-07-19 | Hughes | Oklahoma | 40063 | 22 | 1 |
352775 | 352775 | 2020-07-20 | Hughes | Oklahoma | 40063 | 22 | 1 |
355978 | 355978 | 2020-07-21 | Hughes | Oklahoma | 40063 | 22 | 1 |
359182 | 359182 | 2020-07-22 | Hughes | Oklahoma | 40063 | 25 | 1 |
362388 | 362388 | 2020-07-23 | Hughes | Oklahoma | 40063 | 28 | 1 |
365594 | 365594 | 2020-07-24 | Hughes | Oklahoma | 40063 | 44 | 1 |
368803 | 368803 | 2020-07-25 | Hughes | Oklahoma | 40063 | 53 | 1 |
372015 | 372015 | 2020-07-26 | Hughes | Oklahoma | 40063 | 73 | 1 |
375227 | 375227 | 2020-07-27 | Hughes | Oklahoma | 40063 | 78 | 1 |
378444 | 378444 | 2020-07-28 | Hughes | Oklahoma | 40063 | 86 | 1 |
381661 | 381661 | 2020-07-29 | Hughes | Oklahoma | 40063 | 92 | 1 |
384879 | 384879 | 2020-07-30 | Hughes | Oklahoma | 40063 | 96 | 1 |
388096 | 388096 | 2020-07-31 | Hughes | Oklahoma | 40063 | 100 | 1 |
391313 | 391313 | 2020-08-01 | Hughes | Oklahoma | 40063 | 107 | 1 |
394529 | 394529 | 2020-08-02 | Hughes | Oklahoma | 40063 | 111 | 1 |
397746 | 397746 | 2020-08-03 | Hughes | Oklahoma | 40063 | 111 | 1 |
400961 | 400961 | 2020-08-04 | Hughes | Oklahoma | 40063 | 115 | 1 |
404179 | 404179 | 2020-08-05 | Hughes | Oklahoma | 40063 | 118 | 1 |
407398 | 407398 | 2020-08-06 | Hughes | Oklahoma | 40063 | 124 | 1 |
410618 | 410618 | 2020-08-07 | Hughes | Oklahoma | 40063 | 126 | 1 |
413838 | 413838 | 2020-08-08 | Hughes | Oklahoma | 40063 | 134 | 2 |
417059 | 417059 | 2020-08-09 | Hughes | Oklahoma | 40063 | 137 | 2 |
420279 | 420279 | 2020-08-10 | Hughes | Oklahoma | 40063 | 138 | 2 |
423502 | 423502 | 2020-08-11 | Hughes | Oklahoma | 40063 | 141 | 2 |
426725 | 426725 | 2020-08-12 | Hughes | Oklahoma | 40063 | 146 | 2 |
429950 | 429950 | 2020-08-13 | Hughes | Oklahoma | 40063 | 152 | 2 |
433176 | 433176 | 2020-08-14 | Hughes | Oklahoma | 40063 | 172 | 2 |
436402 | 436402 | 2020-08-15 | Hughes | Oklahoma | 40063 | 177 | 2 |
439627 | 439627 | 2020-08-16 | Hughes | Oklahoma | 40063 | 178 | 2 |
442854 | 442854 | 2020-08-17 | Hughes | Oklahoma | 40063 | 179 | 2 |
446080 | 446080 | 2020-08-18 | Hughes | Oklahoma | 40063 | 181 | 3 |
449308 | 449308 | 2020-08-19 | Hughes | Oklahoma | 40063 | 184 | 3 |
452536 | 452536 | 2020-08-20 | Hughes | Oklahoma | 40063 | 185 | 3 |
455764 | 455764 | 2020-08-21 | Hughes | Oklahoma | 40063 | 191 | 3 |
458992 | 458992 | 2020-08-22 | Hughes | Oklahoma | 40063 | 192 | 3 |
462220 | 462220 | 2020-08-23 | Hughes | Oklahoma | 40063 | 194 | 3 |
465449 | 465449 | 2020-08-24 | Hughes | Oklahoma | 40063 | 194 | 3 |
468677 | 468677 | 2020-08-25 | Hughes | Oklahoma | 40063 | 199 | 3 |
471909 | 471909 | 2020-08-26 | Hughes | Oklahoma | 40063 | 205 | 3 |
475143 | 475143 | 2020-08-27 | Hughes | Oklahoma | 40063 | 207 | 3 |
478376 | 478376 | 2020-08-28 | Hughes | Oklahoma | 40063 | 208 | 3 |
481610 | 481610 | 2020-08-29 | Hughes | Oklahoma | 40063 | 212 | 3 |
484845 | 484845 | 2020-08-30 | Hughes | Oklahoma | 40063 | 214 | 3 |
488078 | 488078 | 2020-08-31 | Hughes | Oklahoma | 40063 | 215 | 3 |
491311 | 491311 | 2020-09-01 | Hughes | Oklahoma | 40063 | 217 | 3 |
494545 | 494545 | 2020-09-02 | Hughes | Oklahoma | 40063 | 221 | 4 |
497778 | 497778 | 2020-09-03 | Hughes | Oklahoma | 40063 | 223 | 4 |
501012 | 501012 | 2020-09-04 | Hughes | Oklahoma | 40063 | 226 | 4 |
504246 | 504246 | 2020-09-05 | Hughes | Oklahoma | 40063 | 236 | 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);