ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Leavenworth" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635830 | 635830 | 2020-10-16 | Leavenworth | Kansas | 20103 | 2487 | 17 |
632584 | 632584 | 2020-10-15 | Leavenworth | Kansas | 20103 | 2449 | 17 |
629340 | 629340 | 2020-10-14 | Leavenworth | Kansas | 20103 | 2449 | 17 |
626097 | 626097 | 2020-10-13 | Leavenworth | Kansas | 20103 | 2429 | 15 |
622855 | 622855 | 2020-10-12 | Leavenworth | Kansas | 20103 | 2429 | 15 |
619611 | 619611 | 2020-10-11 | Leavenworth | Kansas | 20103 | 2386 | 15 |
616369 | 616369 | 2020-10-10 | Leavenworth | Kansas | 20103 | 2386 | 15 |
613128 | 613128 | 2020-10-09 | Leavenworth | Kansas | 20103 | 2386 | 15 |
609886 | 609886 | 2020-10-08 | Leavenworth | Kansas | 20103 | 2349 | 15 |
606643 | 606643 | 2020-10-07 | Leavenworth | Kansas | 20103 | 2349 | 15 |
603401 | 603401 | 2020-10-06 | Leavenworth | Kansas | 20103 | 2324 | 14 |
600158 | 600158 | 2020-10-05 | Leavenworth | Kansas | 20103 | 2324 | 14 |
596916 | 596916 | 2020-10-04 | Leavenworth | Kansas | 20103 | 2293 | 13 |
593674 | 593674 | 2020-10-03 | Leavenworth | Kansas | 20103 | 2293 | 13 |
590433 | 590433 | 2020-10-02 | Leavenworth | Kansas | 20103 | 2293 | 13 |
587192 | 587192 | 2020-10-01 | Leavenworth | Kansas | 20103 | 2258 | 11 |
583952 | 583952 | 2020-09-30 | Leavenworth | Kansas | 20103 | 2258 | 11 |
580713 | 580713 | 2020-09-29 | Leavenworth | Kansas | 20103 | 2232 | 11 |
577472 | 577472 | 2020-09-28 | Leavenworth | Kansas | 20103 | 2232 | 11 |
574230 | 574230 | 2020-09-27 | Leavenworth | Kansas | 20103 | 2080 | 11 |
570987 | 570987 | 2020-09-26 | Leavenworth | Kansas | 20103 | 2080 | 11 |
567745 | 567745 | 2020-09-25 | Leavenworth | Kansas | 20103 | 2080 | 11 |
564505 | 564505 | 2020-09-24 | Leavenworth | Kansas | 20103 | 2023 | 11 |
561265 | 561265 | 2020-09-23 | Leavenworth | Kansas | 20103 | 2023 | 11 |
558029 | 558029 | 2020-09-22 | Leavenworth | Kansas | 20103 | 1979 | 11 |
554792 | 554792 | 2020-09-21 | Leavenworth | Kansas | 20103 | 1979 | 11 |
551553 | 551553 | 2020-09-20 | Leavenworth | Kansas | 20103 | 1924 | 10 |
548314 | 548314 | 2020-09-19 | Leavenworth | Kansas | 20103 | 1924 | 10 |
545076 | 545076 | 2020-09-18 | Leavenworth | Kansas | 20103 | 1924 | 10 |
541840 | 541840 | 2020-09-17 | Leavenworth | Kansas | 20103 | 1891 | 10 |
538603 | 538603 | 2020-09-16 | Leavenworth | Kansas | 20103 | 1891 | 10 |
535367 | 535367 | 2020-09-15 | Leavenworth | Kansas | 20103 | 1870 | 9 |
532132 | 532132 | 2020-09-14 | Leavenworth | Kansas | 20103 | 1870 | 9 |
528895 | 528895 | 2020-09-13 | Leavenworth | Kansas | 20103 | 1819 | 9 |
525659 | 525659 | 2020-09-12 | Leavenworth | Kansas | 20103 | 1819 | 9 |
522423 | 522423 | 2020-09-11 | Leavenworth | Kansas | 20103 | 1819 | 9 |
519186 | 519186 | 2020-09-10 | Leavenworth | Kansas | 20103 | 1794 | 9 |
515951 | 515951 | 2020-09-09 | Leavenworth | Kansas | 20103 | 1794 | 9 |
512718 | 512718 | 2020-09-08 | Leavenworth | Kansas | 20103 | 1781 | 9 |
509485 | 509485 | 2020-09-07 | Leavenworth | Kansas | 20103 | 1781 | 9 |
506253 | 506253 | 2020-09-06 | Leavenworth | Kansas | 20103 | 1750 | 9 |
503019 | 503019 | 2020-09-05 | Leavenworth | Kansas | 20103 | 1750 | 9 |
499785 | 499785 | 2020-09-04 | Leavenworth | Kansas | 20103 | 1750 | 9 |
496552 | 496552 | 2020-09-03 | Leavenworth | Kansas | 20103 | 1721 | 9 |
493318 | 493318 | 2020-09-02 | Leavenworth | Kansas | 20103 | 1721 | 9 |
490085 | 490085 | 2020-09-01 | Leavenworth | Kansas | 20103 | 1777 | 9 |
486852 | 486852 | 2020-08-31 | Leavenworth | Kansas | 20103 | 1777 | 9 |
483617 | 483617 | 2020-08-30 | Leavenworth | Kansas | 20103 | 1674 | 9 |
480383 | 480383 | 2020-08-29 | Leavenworth | Kansas | 20103 | 1674 | 9 |
477150 | 477150 | 2020-08-28 | Leavenworth | Kansas | 20103 | 1674 | 9 |
473917 | 473917 | 2020-08-27 | Leavenworth | Kansas | 20103 | 1658 | 9 |
470685 | 470685 | 2020-08-26 | Leavenworth | Kansas | 20103 | 1658 | 9 |
467456 | 467456 | 2020-08-25 | Leavenworth | Kansas | 20103 | 1634 | 9 |
464227 | 464227 | 2020-08-24 | Leavenworth | Kansas | 20103 | 1634 | 9 |
460998 | 460998 | 2020-08-23 | Leavenworth | Kansas | 20103 | 1603 | 9 |
457771 | 457771 | 2020-08-22 | Leavenworth | Kansas | 20103 | 1603 | 9 |
454543 | 454543 | 2020-08-21 | Leavenworth | Kansas | 20103 | 1603 | 9 |
451315 | 451315 | 2020-08-20 | Leavenworth | Kansas | 20103 | 1587 | 9 |
448087 | 448087 | 2020-08-19 | Leavenworth | Kansas | 20103 | 1587 | 9 |
444860 | 444860 | 2020-08-18 | Leavenworth | Kansas | 20103 | 1576 | 9 |
441634 | 441634 | 2020-08-17 | Leavenworth | Kansas | 20103 | 1576 | 9 |
438407 | 438407 | 2020-08-16 | Leavenworth | Kansas | 20103 | 1549 | 9 |
435182 | 435182 | 2020-08-15 | Leavenworth | Kansas | 20103 | 1549 | 9 |
431957 | 431957 | 2020-08-14 | Leavenworth | Kansas | 20103 | 1549 | 9 |
428729 | 428729 | 2020-08-13 | Leavenworth | Kansas | 20103 | 1532 | 9 |
425505 | 425505 | 2020-08-12 | Leavenworth | Kansas | 20103 | 1532 | 9 |
422284 | 422284 | 2020-08-11 | Leavenworth | Kansas | 20103 | 1513 | 9 |
419061 | 419061 | 2020-08-10 | Leavenworth | Kansas | 20103 | 1513 | 9 |
415840 | 415840 | 2020-08-09 | Leavenworth | Kansas | 20103 | 1487 | 8 |
412620 | 412620 | 2020-08-08 | Leavenworth | Kansas | 20103 | 1487 | 8 |
409400 | 409400 | 2020-08-07 | Leavenworth | Kansas | 20103 | 1487 | 8 |
406181 | 406181 | 2020-08-06 | Leavenworth | Kansas | 20103 | 1472 | 8 |
402963 | 402963 | 2020-08-05 | Leavenworth | Kansas | 20103 | 1472 | 8 |
399746 | 399746 | 2020-08-04 | Leavenworth | Kansas | 20103 | 1457 | 8 |
396531 | 396531 | 2020-08-03 | Leavenworth | Kansas | 20103 | 1457 | 8 |
393315 | 393315 | 2020-08-02 | Leavenworth | Kansas | 20103 | 1422 | 8 |
390098 | 390098 | 2020-08-01 | Leavenworth | Kansas | 20103 | 1422 | 8 |
386881 | 386881 | 2020-07-31 | Leavenworth | Kansas | 20103 | 1422 | 8 |
383663 | 383663 | 2020-07-30 | Leavenworth | Kansas | 20103 | 1406 | 8 |
380446 | 380446 | 2020-07-29 | Leavenworth | Kansas | 20103 | 1406 | 8 |
377229 | 377229 | 2020-07-28 | Leavenworth | Kansas | 20103 | 1392 | 7 |
374014 | 374014 | 2020-07-27 | Leavenworth | Kansas | 20103 | 1392 | 7 |
370802 | 370802 | 2020-07-26 | Leavenworth | Kansas | 20103 | 1372 | 7 |
367592 | 367592 | 2020-07-25 | Leavenworth | Kansas | 20103 | 1372 | 7 |
364385 | 364385 | 2020-07-24 | Leavenworth | Kansas | 20103 | 1372 | 7 |
361178 | 361178 | 2020-07-23 | Leavenworth | Kansas | 20103 | 1333 | 7 |
357973 | 357973 | 2020-07-22 | Leavenworth | Kansas | 20103 | 1333 | 7 |
354771 | 354771 | 2020-07-21 | Leavenworth | Kansas | 20103 | 1306 | 7 |
351569 | 351569 | 2020-07-20 | Leavenworth | Kansas | 20103 | 1306 | 7 |
348369 | 348369 | 2020-07-19 | Leavenworth | Kansas | 20103 | 1274 | 7 |
345168 | 345168 | 2020-07-18 | Leavenworth | Kansas | 20103 | 1274 | 7 |
341968 | 341968 | 2020-07-17 | Leavenworth | Kansas | 20103 | 1274 | 7 |
338772 | 338772 | 2020-07-16 | Leavenworth | Kansas | 20103 | 1264 | 7 |
335576 | 335576 | 2020-07-15 | Leavenworth | Kansas | 20103 | 1264 | 7 |
332383 | 332383 | 2020-07-14 | Leavenworth | Kansas | 20103 | 1248 | 7 |
329196 | 329196 | 2020-07-13 | Leavenworth | Kansas | 20103 | 1248 | 7 |
326010 | 326010 | 2020-07-12 | Leavenworth | Kansas | 20103 | 1232 | 7 |
322827 | 322827 | 2020-07-11 | Leavenworth | Kansas | 20103 | 1232 | 7 |
319648 | 319648 | 2020-07-10 | Leavenworth | Kansas | 20103 | 1232 | 7 |
316475 | 316475 | 2020-07-09 | Leavenworth | Kansas | 20103 | 1200 | 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);