ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 20155 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635856 | 635856 | 2020-10-16 | Reno | Kansas | 20155 | 1636 | 9 |
632610 | 632610 | 2020-10-15 | Reno | Kansas | 20155 | 1564 | 9 |
629366 | 629366 | 2020-10-14 | Reno | Kansas | 20155 | 1564 | 8 |
626123 | 626123 | 2020-10-13 | Reno | Kansas | 20155 | 1521 | 8 |
622881 | 622881 | 2020-10-12 | Reno | Kansas | 20155 | 1521 | 7 |
619637 | 619637 | 2020-10-11 | Reno | Kansas | 20155 | 1426 | 7 |
616395 | 616395 | 2020-10-10 | Reno | Kansas | 20155 | 1412 | 7 |
613154 | 613154 | 2020-10-09 | Reno | Kansas | 20155 | 1387 | 7 |
609912 | 609912 | 2020-10-08 | Reno | Kansas | 20155 | 1301 | 6 |
606669 | 606669 | 2020-10-07 | Reno | Kansas | 20155 | 1301 | 4 |
603427 | 603427 | 2020-10-06 | Reno | Kansas | 20155 | 1245 | 4 |
600184 | 600184 | 2020-10-05 | Reno | Kansas | 20155 | 1245 | 4 |
596942 | 596942 | 2020-10-04 | Reno | Kansas | 20155 | 1200 | 4 |
593700 | 593700 | 2020-10-03 | Reno | Kansas | 20155 | 1200 | 4 |
590459 | 590459 | 2020-10-02 | Reno | Kansas | 20155 | 1200 | 4 |
587218 | 587218 | 2020-10-01 | Reno | Kansas | 20155 | 1155 | 4 |
583978 | 583978 | 2020-09-30 | Reno | Kansas | 20155 | 1155 | 4 |
580739 | 580739 | 2020-09-29 | Reno | Kansas | 20155 | 1148 | 4 |
577498 | 577498 | 2020-09-28 | Reno | Kansas | 20155 | 1148 | 4 |
574256 | 574256 | 2020-09-27 | Reno | Kansas | 20155 | 1094 | 3 |
571013 | 571013 | 2020-09-26 | Reno | Kansas | 20155 | 1094 | 3 |
567771 | 567771 | 2020-09-25 | Reno | Kansas | 20155 | 1094 | 3 |
564531 | 564531 | 2020-09-24 | Reno | Kansas | 20155 | 1065 | 3 |
561291 | 561291 | 2020-09-23 | Reno | Kansas | 20155 | 1065 | 3 |
558055 | 558055 | 2020-09-22 | Reno | Kansas | 20155 | 1024 | 3 |
554818 | 554818 | 2020-09-21 | Reno | Kansas | 20155 | 1024 | 3 |
551579 | 551579 | 2020-09-20 | Reno | Kansas | 20155 | 981 | 3 |
548340 | 548340 | 2020-09-19 | Reno | Kansas | 20155 | 981 | 3 |
545102 | 545102 | 2020-09-18 | Reno | Kansas | 20155 | 981 | 3 |
541866 | 541866 | 2020-09-17 | Reno | Kansas | 20155 | 925 | 3 |
538629 | 538629 | 2020-09-16 | Reno | Kansas | 20155 | 925 | 3 |
535393 | 535393 | 2020-09-15 | Reno | Kansas | 20155 | 911 | 3 |
532158 | 532158 | 2020-09-14 | Reno | Kansas | 20155 | 911 | 3 |
528921 | 528921 | 2020-09-13 | Reno | Kansas | 20155 | 893 | 3 |
525685 | 525685 | 2020-09-12 | Reno | Kansas | 20155 | 893 | 3 |
522449 | 522449 | 2020-09-11 | Reno | Kansas | 20155 | 893 | 3 |
519212 | 519212 | 2020-09-10 | Reno | Kansas | 20155 | 872 | 2 |
515977 | 515977 | 2020-09-09 | Reno | Kansas | 20155 | 872 | 2 |
512744 | 512744 | 2020-09-08 | Reno | Kansas | 20155 | 864 | 1 |
509511 | 509511 | 2020-09-07 | Reno | Kansas | 20155 | 864 | 1 |
506279 | 506279 | 2020-09-06 | Reno | Kansas | 20155 | 850 | 1 |
503045 | 503045 | 2020-09-05 | Reno | Kansas | 20155 | 850 | 1 |
499811 | 499811 | 2020-09-04 | Reno | Kansas | 20155 | 850 | 1 |
496578 | 496578 | 2020-09-03 | Reno | Kansas | 20155 | 804 | 1 |
493344 | 493344 | 2020-09-02 | Reno | Kansas | 20155 | 804 | 1 |
490111 | 490111 | 2020-09-01 | Reno | Kansas | 20155 | 775 | 1 |
486878 | 486878 | 2020-08-31 | Reno | Kansas | 20155 | 775 | 1 |
483643 | 483643 | 2020-08-30 | Reno | Kansas | 20155 | 740 | 1 |
480409 | 480409 | 2020-08-29 | Reno | Kansas | 20155 | 730 | 1 |
477176 | 477176 | 2020-08-28 | Reno | Kansas | 20155 | 713 | 1 |
473943 | 473943 | 2020-08-27 | Reno | Kansas | 20155 | 699 | 1 |
470711 | 470711 | 2020-08-26 | Reno | Kansas | 20155 | 699 | 1 |
467482 | 467482 | 2020-08-25 | Reno | Kansas | 20155 | 666 | 1 |
464253 | 464253 | 2020-08-24 | Reno | Kansas | 20155 | 650 | 1 |
461023 | 461023 | 2020-08-23 | Reno | Kansas | 20155 | 610 | 1 |
457796 | 457796 | 2020-08-22 | Reno | Kansas | 20155 | 570 | 1 |
454568 | 454568 | 2020-08-21 | Reno | Kansas | 20155 | 555 | 1 |
451340 | 451340 | 2020-08-20 | Reno | Kansas | 20155 | 538 | 1 |
448112 | 448112 | 2020-08-19 | Reno | Kansas | 20155 | 527 | 1 |
444885 | 444885 | 2020-08-18 | Reno | Kansas | 20155 | 489 | 1 |
441659 | 441659 | 2020-08-17 | Reno | Kansas | 20155 | 480 | 1 |
438432 | 438432 | 2020-08-16 | Reno | Kansas | 20155 | 449 | 1 |
435207 | 435207 | 2020-08-15 | Reno | Kansas | 20155 | 418 | 1 |
431982 | 431982 | 2020-08-14 | Reno | Kansas | 20155 | 418 | 1 |
428754 | 428754 | 2020-08-13 | Reno | Kansas | 20155 | 397 | 1 |
425530 | 425530 | 2020-08-12 | Reno | Kansas | 20155 | 390 | 1 |
422309 | 422309 | 2020-08-11 | Reno | Kansas | 20155 | 291 | 1 |
419086 | 419086 | 2020-08-10 | Reno | Kansas | 20155 | 291 | 1 |
415865 | 415865 | 2020-08-09 | Reno | Kansas | 20155 | 273 | 1 |
412645 | 412645 | 2020-08-08 | Reno | Kansas | 20155 | 272 | 1 |
409425 | 409425 | 2020-08-07 | Reno | Kansas | 20155 | 269 | 1 |
406206 | 406206 | 2020-08-06 | Reno | Kansas | 20155 | 251 | 1 |
402988 | 402988 | 2020-08-05 | Reno | Kansas | 20155 | 251 | 1 |
399771 | 399771 | 2020-08-04 | Reno | Kansas | 20155 | 239 | 1 |
396556 | 396556 | 2020-08-03 | Reno | Kansas | 20155 | 239 | 1 |
393340 | 393340 | 2020-08-02 | Reno | Kansas | 20155 | 229 | 1 |
390123 | 390123 | 2020-08-01 | Reno | Kansas | 20155 | 229 | 1 |
386906 | 386906 | 2020-07-31 | Reno | Kansas | 20155 | 229 | 1 |
383688 | 383688 | 2020-07-30 | Reno | Kansas | 20155 | 217 | 1 |
380471 | 380471 | 2020-07-29 | Reno | Kansas | 20155 | 217 | 1 |
377254 | 377254 | 2020-07-28 | Reno | Kansas | 20155 | 214 | 1 |
374039 | 374039 | 2020-07-27 | Reno | Kansas | 20155 | 214 | 1 |
370827 | 370827 | 2020-07-26 | Reno | Kansas | 20155 | 201 | 1 |
367617 | 367617 | 2020-07-25 | Reno | Kansas | 20155 | 197 | 1 |
364410 | 364410 | 2020-07-24 | Reno | Kansas | 20155 | 197 | 1 |
361203 | 361203 | 2020-07-23 | Reno | Kansas | 20155 | 184 | 1 |
357998 | 357998 | 2020-07-22 | Reno | Kansas | 20155 | 179 | 1 |
354796 | 354796 | 2020-07-21 | Reno | Kansas | 20155 | 175 | 0 |
351594 | 351594 | 2020-07-20 | Reno | Kansas | 20155 | 175 | 0 |
348394 | 348394 | 2020-07-19 | Reno | Kansas | 20155 | 161 | 0 |
345193 | 345193 | 2020-07-18 | Reno | Kansas | 20155 | 157 | 0 |
341993 | 341993 | 2020-07-17 | Reno | Kansas | 20155 | 155 | 0 |
338797 | 338797 | 2020-07-16 | Reno | Kansas | 20155 | 142 | 0 |
335601 | 335601 | 2020-07-15 | Reno | Kansas | 20155 | 143 | 0 |
332408 | 332408 | 2020-07-14 | Reno | Kansas | 20155 | 141 | 0 |
329221 | 329221 | 2020-07-13 | Reno | Kansas | 20155 | 141 | 0 |
326035 | 326035 | 2020-07-12 | Reno | Kansas | 20155 | 127 | 0 |
322852 | 322852 | 2020-07-11 | Reno | Kansas | 20155 | 123 | 0 |
319673 | 319673 | 2020-07-10 | Reno | Kansas | 20155 | 121 | 0 |
316499 | 316499 | 2020-07-09 | Reno | Kansas | 20155 | 103 | 0 |
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);