ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Riley" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635859 | 635859 | 2020-10-16 | Riley | Kansas | 20161 | 2035 | 11 |
632613 | 632613 | 2020-10-15 | Riley | Kansas | 20161 | 2004 | 10 |
629369 | 629369 | 2020-10-14 | Riley | Kansas | 20161 | 2003 | 9 |
626126 | 626126 | 2020-10-13 | Riley | Kansas | 20161 | 1968 | 9 |
622884 | 622884 | 2020-10-12 | Riley | Kansas | 20161 | 1968 | 9 |
619640 | 619640 | 2020-10-11 | Riley | Kansas | 20161 | 1945 | 9 |
616398 | 616398 | 2020-10-10 | Riley | Kansas | 20161 | 1945 | 9 |
613157 | 613157 | 2020-10-09 | Riley | Kansas | 20161 | 1945 | 9 |
609915 | 609915 | 2020-10-08 | Riley | Kansas | 20161 | 1937 | 9 |
606672 | 606672 | 2020-10-07 | Riley | Kansas | 20161 | 1937 | 9 |
603430 | 603430 | 2020-10-06 | Riley | Kansas | 20161 | 1933 | 8 |
600187 | 600187 | 2020-10-05 | Riley | Kansas | 20161 | 1857 | 8 |
596945 | 596945 | 2020-10-04 | Riley | Kansas | 20161 | 1857 | 8 |
593703 | 593703 | 2020-10-03 | Riley | Kansas | 20161 | 1857 | 8 |
590462 | 590462 | 2020-10-02 | Riley | Kansas | 20161 | 1857 | 8 |
587221 | 587221 | 2020-10-01 | Riley | Kansas | 20161 | 1857 | 8 |
583981 | 583981 | 2020-09-30 | Riley | Kansas | 20161 | 1857 | 8 |
580742 | 580742 | 2020-09-29 | Riley | Kansas | 20161 | 1815 | 8 |
577501 | 577501 | 2020-09-28 | Riley | Kansas | 20161 | 1815 | 8 |
574259 | 574259 | 2020-09-27 | Riley | Kansas | 20161 | 1795 | 8 |
571016 | 571016 | 2020-09-26 | Riley | Kansas | 20161 | 1795 | 8 |
567774 | 567774 | 2020-09-25 | Riley | Kansas | 20161 | 1795 | 8 |
564534 | 564534 | 2020-09-24 | Riley | Kansas | 20161 | 1722 | 8 |
561294 | 561294 | 2020-09-23 | Riley | Kansas | 20161 | 1722 | 8 |
558058 | 558058 | 2020-09-22 | Riley | Kansas | 20161 | 1643 | 8 |
554821 | 554821 | 2020-09-21 | Riley | Kansas | 20161 | 1643 | 8 |
551582 | 551582 | 2020-09-20 | Riley | Kansas | 20161 | 1576 | 8 |
548343 | 548343 | 2020-09-19 | Riley | Kansas | 20161 | 1576 | 8 |
545105 | 545105 | 2020-09-18 | Riley | Kansas | 20161 | 1576 | 8 |
541869 | 541869 | 2020-09-17 | Riley | Kansas | 20161 | 1519 | 8 |
538632 | 538632 | 2020-09-16 | Riley | Kansas | 20161 | 1411 | 8 |
535396 | 535396 | 2020-09-15 | Riley | Kansas | 20161 | 1411 | 8 |
532161 | 532161 | 2020-09-14 | Riley | Kansas | 20161 | 1411 | 8 |
528924 | 528924 | 2020-09-13 | Riley | Kansas | 20161 | 1322 | 6 |
525688 | 525688 | 2020-09-12 | Riley | Kansas | 20161 | 1322 | 6 |
522452 | 522452 | 2020-09-11 | Riley | Kansas | 20161 | 1322 | 6 |
519215 | 519215 | 2020-09-10 | Riley | Kansas | 20161 | 1322 | 6 |
515980 | 515980 | 2020-09-09 | Riley | Kansas | 20161 | 1322 | 6 |
512747 | 512747 | 2020-09-08 | Riley | Kansas | 20161 | 1307 | 6 |
509514 | 509514 | 2020-09-07 | Riley | Kansas | 20161 | 1186 | 6 |
506282 | 506282 | 2020-09-06 | Riley | Kansas | 20161 | 1186 | 6 |
503048 | 503048 | 2020-09-05 | Riley | Kansas | 20161 | 1186 | 6 |
499814 | 499814 | 2020-09-04 | Riley | Kansas | 20161 | 1186 | 6 |
496581 | 496581 | 2020-09-03 | Riley | Kansas | 20161 | 1045 | 6 |
493347 | 493347 | 2020-09-02 | Riley | Kansas | 20161 | 934 | 5 |
490114 | 490114 | 2020-09-01 | Riley | Kansas | 20161 | 934 | 5 |
486881 | 486881 | 2020-08-31 | Riley | Kansas | 20161 | 934 | 5 |
483646 | 483646 | 2020-08-30 | Riley | Kansas | 20161 | 822 | 5 |
480412 | 480412 | 2020-08-29 | Riley | Kansas | 20161 | 822 | 5 |
477179 | 477179 | 2020-08-28 | Riley | Kansas | 20161 | 822 | 5 |
473946 | 473946 | 2020-08-27 | Riley | Kansas | 20161 | 686 | 5 |
470714 | 470714 | 2020-08-26 | Riley | Kansas | 20161 | 686 | 5 |
467485 | 467485 | 2020-08-25 | Riley | Kansas | 20161 | 618 | 5 |
464256 | 464256 | 2020-08-24 | Riley | Kansas | 20161 | 618 | 5 |
461026 | 461026 | 2020-08-23 | Riley | Kansas | 20161 | 577 | 5 |
457799 | 457799 | 2020-08-22 | Riley | Kansas | 20161 | 577 | 5 |
454571 | 454571 | 2020-08-21 | Riley | Kansas | 20161 | 577 | 5 |
451343 | 451343 | 2020-08-20 | Riley | Kansas | 20161 | 544 | 5 |
448115 | 448115 | 2020-08-19 | Riley | Kansas | 20161 | 544 | 5 |
444888 | 444888 | 2020-08-18 | Riley | Kansas | 20161 | 512 | 5 |
441662 | 441662 | 2020-08-17 | Riley | Kansas | 20161 | 512 | 5 |
438435 | 438435 | 2020-08-16 | Riley | Kansas | 20161 | 507 | 5 |
435210 | 435210 | 2020-08-15 | Riley | Kansas | 20161 | 507 | 5 |
431985 | 431985 | 2020-08-14 | Riley | Kansas | 20161 | 507 | 5 |
428757 | 428757 | 2020-08-13 | Riley | Kansas | 20161 | 501 | 5 |
425533 | 425533 | 2020-08-12 | Riley | Kansas | 20161 | 501 | 5 |
422312 | 422312 | 2020-08-11 | Riley | Kansas | 20161 | 494 | 5 |
419089 | 419089 | 2020-08-10 | Riley | Kansas | 20161 | 494 | 5 |
415868 | 415868 | 2020-08-09 | Riley | Kansas | 20161 | 477 | 5 |
412648 | 412648 | 2020-08-08 | Riley | Kansas | 20161 | 477 | 5 |
409428 | 409428 | 2020-08-07 | Riley | Kansas | 20161 | 477 | 5 |
406209 | 406209 | 2020-08-06 | Riley | Kansas | 20161 | 465 | 5 |
402991 | 402991 | 2020-08-05 | Riley | Kansas | 20161 | 465 | 5 |
399774 | 399774 | 2020-08-04 | Riley | Kansas | 20161 | 449 | 5 |
396559 | 396559 | 2020-08-03 | Riley | Kansas | 20161 | 449 | 5 |
393343 | 393343 | 2020-08-02 | Riley | Kansas | 20161 | 449 | 5 |
390126 | 390126 | 2020-08-01 | Riley | Kansas | 20161 | 449 | 5 |
386909 | 386909 | 2020-07-31 | Riley | Kansas | 20161 | 449 | 5 |
383691 | 383691 | 2020-07-30 | Riley | Kansas | 20161 | 445 | 5 |
380474 | 380474 | 2020-07-29 | Riley | Kansas | 20161 | 441 | 4 |
377257 | 377257 | 2020-07-28 | Riley | Kansas | 20161 | 428 | 4 |
374042 | 374042 | 2020-07-27 | Riley | Kansas | 20161 | 426 | 4 |
370830 | 370830 | 2020-07-26 | Riley | Kansas | 20161 | 419 | 4 |
367620 | 367620 | 2020-07-25 | Riley | Kansas | 20161 | 419 | 4 |
364413 | 364413 | 2020-07-24 | Riley | Kansas | 20161 | 419 | 4 |
361206 | 361206 | 2020-07-23 | Riley | Kansas | 20161 | 418 | 3 |
358001 | 358001 | 2020-07-22 | Riley | Kansas | 20161 | 411 | 3 |
354799 | 354799 | 2020-07-21 | Riley | Kansas | 20161 | 405 | 3 |
351597 | 351597 | 2020-07-20 | Riley | Kansas | 20161 | 398 | 3 |
348397 | 348397 | 2020-07-19 | Riley | Kansas | 20161 | 382 | 3 |
345196 | 345196 | 2020-07-18 | Riley | Kansas | 20161 | 382 | 3 |
341996 | 341996 | 2020-07-17 | Riley | Kansas | 20161 | 382 | 3 |
338800 | 338800 | 2020-07-16 | Riley | Kansas | 20161 | 374 | 3 |
335604 | 335604 | 2020-07-15 | Riley | Kansas | 20161 | 371 | 3 |
332411 | 332411 | 2020-07-14 | Riley | Kansas | 20161 | 364 | 3 |
329224 | 329224 | 2020-07-13 | Riley | Kansas | 20161 | 355 | 3 |
326038 | 326038 | 2020-07-12 | Riley | Kansas | 20161 | 337 | 3 |
322855 | 322855 | 2020-07-11 | Riley | Kansas | 20161 | 337 | 3 |
319676 | 319676 | 2020-07-10 | Riley | Kansas | 20161 | 337 | 3 |
316502 | 316502 | 2020-07-09 | Riley | Kansas | 20161 | 332 | 3 |
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);