ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Kay" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
630576 | 630576 | 2020-10-14 | Kay | Oklahoma | 40071 | 771 | 15 |
627332 | 627332 | 2020-10-13 | Kay | Oklahoma | 40071 | 759 | 15 |
624090 | 624090 | 2020-10-12 | Kay | Oklahoma | 40071 | 745 | 15 |
620847 | 620847 | 2020-10-11 | Kay | Oklahoma | 40071 | 743 | 15 |
617605 | 617605 | 2020-10-10 | Kay | Oklahoma | 40071 | 741 | 15 |
614363 | 614363 | 2020-10-09 | Kay | Oklahoma | 40071 | 734 | 15 |
611122 | 611122 | 2020-10-08 | Kay | Oklahoma | 40071 | 725 | 15 |
607880 | 607880 | 2020-10-07 | Kay | Oklahoma | 40071 | 716 | 15 |
604637 | 604637 | 2020-10-06 | Kay | Oklahoma | 40071 | 708 | 15 |
601395 | 601395 | 2020-10-05 | Kay | Oklahoma | 40071 | 686 | 14 |
598152 | 598152 | 2020-10-04 | Kay | Oklahoma | 40071 | 678 | 14 |
594909 | 594909 | 2020-10-03 | Kay | Oklahoma | 40071 | 675 | 14 |
591668 | 591668 | 2020-10-02 | Kay | Oklahoma | 40071 | 670 | 13 |
588427 | 588427 | 2020-10-01 | Kay | Oklahoma | 40071 | 656 | 13 |
585187 | 585187 | 2020-09-30 | Kay | Oklahoma | 40071 | 637 | 13 |
581947 | 581947 | 2020-09-29 | Kay | Oklahoma | 40071 | 616 | 13 |
578707 | 578707 | 2020-09-28 | Kay | Oklahoma | 40071 | 596 | 13 |
575466 | 575466 | 2020-09-27 | Kay | Oklahoma | 40071 | 594 | 13 |
572222 | 572222 | 2020-09-26 | Kay | Oklahoma | 40071 | 585 | 13 |
568980 | 568980 | 2020-09-25 | Kay | Oklahoma | 40071 | 570 | 13 |
565739 | 565739 | 2020-09-24 | Kay | Oklahoma | 40071 | 557 | 13 |
562498 | 562498 | 2020-09-23 | Kay | Oklahoma | 40071 | 544 | 13 |
559261 | 559261 | 2020-09-22 | Kay | Oklahoma | 40071 | 531 | 13 |
556024 | 556024 | 2020-09-21 | Kay | Oklahoma | 40071 | 511 | 13 |
552787 | 552787 | 2020-09-20 | Kay | Oklahoma | 40071 | 500 | 13 |
549548 | 549548 | 2020-09-19 | Kay | Oklahoma | 40071 | 491 | 13 |
546309 | 546309 | 2020-09-18 | Kay | Oklahoma | 40071 | 482 | 13 |
543072 | 543072 | 2020-09-17 | Kay | Oklahoma | 40071 | 472 | 13 |
539836 | 539836 | 2020-09-16 | Kay | Oklahoma | 40071 | 459 | 13 |
536599 | 536599 | 2020-09-15 | Kay | Oklahoma | 40071 | 451 | 13 |
533363 | 533363 | 2020-09-14 | Kay | Oklahoma | 40071 | 442 | 13 |
530128 | 530128 | 2020-09-13 | Kay | Oklahoma | 40071 | 423 | 13 |
526891 | 526891 | 2020-09-12 | Kay | Oklahoma | 40071 | 408 | 13 |
523655 | 523655 | 2020-09-11 | Kay | Oklahoma | 40071 | 401 | 13 |
520419 | 520419 | 2020-09-10 | Kay | Oklahoma | 40071 | 386 | 12 |
517183 | 517183 | 2020-09-09 | Kay | Oklahoma | 40071 | 383 | 12 |
513948 | 513948 | 2020-09-08 | Kay | Oklahoma | 40071 | 374 | 12 |
510715 | 510715 | 2020-09-07 | Kay | Oklahoma | 40071 | 365 | 12 |
507482 | 507482 | 2020-09-06 | Kay | Oklahoma | 40071 | 360 | 12 |
504250 | 504250 | 2020-09-05 | Kay | Oklahoma | 40071 | 359 | 12 |
501016 | 501016 | 2020-09-04 | Kay | Oklahoma | 40071 | 348 | 12 |
497782 | 497782 | 2020-09-03 | Kay | Oklahoma | 40071 | 340 | 12 |
494549 | 494549 | 2020-09-02 | Kay | Oklahoma | 40071 | 327 | 12 |
491315 | 491315 | 2020-09-01 | Kay | Oklahoma | 40071 | 326 | 12 |
488082 | 488082 | 2020-08-31 | Kay | Oklahoma | 40071 | 309 | 12 |
484849 | 484849 | 2020-08-30 | Kay | Oklahoma | 40071 | 309 | 12 |
481614 | 481614 | 2020-08-29 | Kay | Oklahoma | 40071 | 308 | 12 |
478380 | 478380 | 2020-08-28 | Kay | Oklahoma | 40071 | 300 | 12 |
475147 | 475147 | 2020-08-27 | Kay | Oklahoma | 40071 | 295 | 12 |
471913 | 471913 | 2020-08-26 | Kay | Oklahoma | 40071 | 294 | 11 |
468681 | 468681 | 2020-08-25 | Kay | Oklahoma | 40071 | 291 | 11 |
465453 | 465453 | 2020-08-24 | Kay | Oklahoma | 40071 | 288 | 11 |
462224 | 462224 | 2020-08-23 | Kay | Oklahoma | 40071 | 287 | 11 |
458996 | 458996 | 2020-08-22 | Kay | Oklahoma | 40071 | 286 | 11 |
455768 | 455768 | 2020-08-21 | Kay | Oklahoma | 40071 | 281 | 11 |
452540 | 452540 | 2020-08-20 | Kay | Oklahoma | 40071 | 275 | 11 |
449312 | 449312 | 2020-08-19 | Kay | Oklahoma | 40071 | 271 | 11 |
446084 | 446084 | 2020-08-18 | Kay | Oklahoma | 40071 | 270 | 11 |
442858 | 442858 | 2020-08-17 | Kay | Oklahoma | 40071 | 267 | 11 |
439631 | 439631 | 2020-08-16 | Kay | Oklahoma | 40071 | 266 | 11 |
436406 | 436406 | 2020-08-15 | Kay | Oklahoma | 40071 | 265 | 11 |
433180 | 433180 | 2020-08-14 | Kay | Oklahoma | 40071 | 256 | 11 |
429954 | 429954 | 2020-08-13 | Kay | Oklahoma | 40071 | 254 | 11 |
426729 | 426729 | 2020-08-12 | Kay | Oklahoma | 40071 | 252 | 11 |
423506 | 423506 | 2020-08-11 | Kay | Oklahoma | 40071 | 251 | 11 |
420283 | 420283 | 2020-08-10 | Kay | Oklahoma | 40071 | 244 | 11 |
417063 | 417063 | 2020-08-09 | Kay | Oklahoma | 40071 | 244 | 11 |
413842 | 413842 | 2020-08-08 | Kay | Oklahoma | 40071 | 242 | 11 |
410622 | 410622 | 2020-08-07 | Kay | Oklahoma | 40071 | 238 | 11 |
407402 | 407402 | 2020-08-06 | Kay | Oklahoma | 40071 | 233 | 11 |
404183 | 404183 | 2020-08-05 | Kay | Oklahoma | 40071 | 231 | 11 |
400965 | 400965 | 2020-08-04 | Kay | Oklahoma | 40071 | 223 | 10 |
397750 | 397750 | 2020-08-03 | Kay | Oklahoma | 40071 | 217 | 10 |
394533 | 394533 | 2020-08-02 | Kay | Oklahoma | 40071 | 214 | 10 |
391317 | 391317 | 2020-08-01 | Kay | Oklahoma | 40071 | 214 | 10 |
388100 | 388100 | 2020-07-31 | Kay | Oklahoma | 40071 | 207 | 10 |
384883 | 384883 | 2020-07-30 | Kay | Oklahoma | 40071 | 205 | 10 |
381665 | 381665 | 2020-07-29 | Kay | Oklahoma | 40071 | 199 | 10 |
378448 | 378448 | 2020-07-28 | Kay | Oklahoma | 40071 | 198 | 10 |
375231 | 375231 | 2020-07-27 | Kay | Oklahoma | 40071 | 188 | 9 |
372019 | 372019 | 2020-07-26 | Kay | Oklahoma | 40071 | 181 | 9 |
368807 | 368807 | 2020-07-25 | Kay | Oklahoma | 40071 | 172 | 9 |
365598 | 365598 | 2020-07-24 | Kay | Oklahoma | 40071 | 169 | 9 |
362392 | 362392 | 2020-07-23 | Kay | Oklahoma | 40071 | 164 | 9 |
359186 | 359186 | 2020-07-22 | Kay | Oklahoma | 40071 | 156 | 9 |
355982 | 355982 | 2020-07-21 | Kay | Oklahoma | 40071 | 153 | 9 |
352779 | 352779 | 2020-07-20 | Kay | Oklahoma | 40071 | 147 | 9 |
349576 | 349576 | 2020-07-19 | Kay | Oklahoma | 40071 | 146 | 9 |
346376 | 346376 | 2020-07-18 | Kay | Oklahoma | 40071 | 146 | 9 |
343176 | 343176 | 2020-07-17 | Kay | Oklahoma | 40071 | 141 | 9 |
339978 | 339978 | 2020-07-16 | Kay | Oklahoma | 40071 | 139 | 9 |
336782 | 336782 | 2020-07-15 | Kay | Oklahoma | 40071 | 133 | 9 |
333588 | 333588 | 2020-07-14 | Kay | Oklahoma | 40071 | 129 | 8 |
330396 | 330396 | 2020-07-13 | Kay | Oklahoma | 40071 | 126 | 8 |
327209 | 327209 | 2020-07-12 | Kay | Oklahoma | 40071 | 124 | 8 |
324024 | 324024 | 2020-07-11 | Kay | Oklahoma | 40071 | 124 | 8 |
320844 | 320844 | 2020-07-10 | Kay | Oklahoma | 40071 | 123 | 8 |
317667 | 317667 | 2020-07-09 | Kay | Oklahoma | 40071 | 120 | 8 |
314494 | 314494 | 2020-07-08 | Kay | Oklahoma | 40071 | 115 | 8 |
311322 | 311322 | 2020-07-07 | Kay | Oklahoma | 40071 | 113 | 7 |
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);