ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Jefferson" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
729895 | 729895 | 2020-11-14 | Jefferson | Kansas | 20087 | 476 | 6 |
726652 | 726652 | 2020-11-13 | Jefferson | Kansas | 20087 | 476 | 6 |
723409 | 723409 | 2020-11-12 | Jefferson | Kansas | 20087 | 429 | 6 |
720166 | 720166 | 2020-11-11 | Jefferson | Kansas | 20087 | 429 | 6 |
716923 | 716923 | 2020-11-10 | Jefferson | Kansas | 20087 | 403 | 6 |
713679 | 713679 | 2020-11-09 | Jefferson | Kansas | 20087 | 398 | 6 |
710435 | 710435 | 2020-11-08 | Jefferson | Kansas | 20087 | 366 | 6 |
707191 | 707191 | 2020-11-07 | Jefferson | Kansas | 20087 | 366 | 6 |
703948 | 703948 | 2020-11-06 | Jefferson | Kansas | 20087 | 366 | 6 |
700706 | 700706 | 2020-11-05 | Jefferson | Kansas | 20087 | 341 | 6 |
697462 | 697462 | 2020-11-04 | Jefferson | Kansas | 20087 | 341 | 6 |
694220 | 694220 | 2020-11-03 | Jefferson | Kansas | 20087 | 325 | 6 |
690977 | 690977 | 2020-11-02 | Jefferson | Kansas | 20087 | 316 | 6 |
687732 | 687732 | 2020-11-01 | Jefferson | Kansas | 20087 | 299 | 6 |
684488 | 684488 | 2020-10-31 | Jefferson | Kansas | 20087 | 299 | 6 |
681245 | 681245 | 2020-10-30 | Jefferson | Kansas | 20087 | 299 | 6 |
678002 | 678002 | 2020-10-29 | Jefferson | Kansas | 20087 | 286 | 6 |
674759 | 674759 | 2020-10-28 | Jefferson | Kansas | 20087 | 281 | 6 |
671517 | 671517 | 2020-10-27 | Jefferson | Kansas | 20087 | 281 | 6 |
668274 | 668274 | 2020-10-26 | Jefferson | Kansas | 20087 | 271 | 4 |
665030 | 665030 | 2020-10-25 | Jefferson | Kansas | 20087 | 268 | 4 |
661785 | 661785 | 2020-10-24 | Jefferson | Kansas | 20087 | 268 | 4 |
658541 | 658541 | 2020-10-23 | Jefferson | Kansas | 20087 | 268 | 4 |
655296 | 655296 | 2020-10-22 | Jefferson | Kansas | 20087 | 265 | 4 |
652051 | 652051 | 2020-10-21 | Jefferson | Kansas | 20087 | 265 | 4 |
648807 | 648807 | 2020-10-20 | Jefferson | Kansas | 20087 | 255 | 4 |
645562 | 645562 | 2020-10-19 | Jefferson | Kansas | 20087 | 255 | 4 |
642315 | 642315 | 2020-10-18 | Jefferson | Kansas | 20087 | 253 | 4 |
639068 | 639068 | 2020-10-17 | Jefferson | Kansas | 20087 | 253 | 4 |
635822 | 635822 | 2020-10-16 | Jefferson | Kansas | 20087 | 248 | 4 |
632576 | 632576 | 2020-10-15 | Jefferson | Kansas | 20087 | 247 | 4 |
629332 | 629332 | 2020-10-14 | Jefferson | Kansas | 20087 | 238 | 4 |
626089 | 626089 | 2020-10-13 | Jefferson | Kansas | 20087 | 236 | 4 |
622847 | 622847 | 2020-10-12 | Jefferson | Kansas | 20087 | 233 | 4 |
619603 | 619603 | 2020-10-11 | Jefferson | Kansas | 20087 | 222 | 4 |
616361 | 616361 | 2020-10-10 | Jefferson | Kansas | 20087 | 222 | 4 |
613120 | 613120 | 2020-10-09 | Jefferson | Kansas | 20087 | 222 | 4 |
609878 | 609878 | 2020-10-08 | Jefferson | Kansas | 20087 | 221 | 4 |
606635 | 606635 | 2020-10-07 | Jefferson | Kansas | 20087 | 220 | 4 |
603393 | 603393 | 2020-10-06 | Jefferson | Kansas | 20087 | 219 | 4 |
600150 | 600150 | 2020-10-05 | Jefferson | Kansas | 20087 | 216 | 4 |
596908 | 596908 | 2020-10-04 | Jefferson | Kansas | 20087 | 202 | 4 |
593666 | 593666 | 2020-10-03 | Jefferson | Kansas | 20087 | 202 | 4 |
590425 | 590425 | 2020-10-02 | Jefferson | Kansas | 20087 | 202 | 4 |
587184 | 587184 | 2020-10-01 | Jefferson | Kansas | 20087 | 201 | 4 |
583944 | 583944 | 2020-09-30 | Jefferson | Kansas | 20087 | 198 | 4 |
580705 | 580705 | 2020-09-29 | Jefferson | Kansas | 20087 | 196 | 4 |
577464 | 577464 | 2020-09-28 | Jefferson | Kansas | 20087 | 195 | 4 |
574222 | 574222 | 2020-09-27 | Jefferson | Kansas | 20087 | 186 | 4 |
570979 | 570979 | 2020-09-26 | Jefferson | Kansas | 20087 | 186 | 4 |
567737 | 567737 | 2020-09-25 | Jefferson | Kansas | 20087 | 186 | 4 |
564497 | 564497 | 2020-09-24 | Jefferson | Kansas | 20087 | 186 | 4 |
561257 | 561257 | 2020-09-23 | Jefferson | Kansas | 20087 | 184 | 4 |
558021 | 558021 | 2020-09-22 | Jefferson | Kansas | 20087 | 180 | 2 |
554784 | 554784 | 2020-09-21 | Jefferson | Kansas | 20087 | 179 | 2 |
551545 | 551545 | 2020-09-20 | Jefferson | Kansas | 20087 | 176 | 2 |
548306 | 548306 | 2020-09-19 | Jefferson | Kansas | 20087 | 176 | 2 |
545068 | 545068 | 2020-09-18 | Jefferson | Kansas | 20087 | 176 | 2 |
541832 | 541832 | 2020-09-17 | Jefferson | Kansas | 20087 | 169 | 1 |
538595 | 538595 | 2020-09-16 | Jefferson | Kansas | 20087 | 167 | 1 |
535359 | 535359 | 2020-09-15 | Jefferson | Kansas | 20087 | 167 | 1 |
532124 | 532124 | 2020-09-14 | Jefferson | Kansas | 20087 | 161 | 0 |
528887 | 528887 | 2020-09-13 | Jefferson | Kansas | 20087 | 145 | 0 |
525651 | 525651 | 2020-09-12 | Jefferson | Kansas | 20087 | 145 | 0 |
522415 | 522415 | 2020-09-11 | Jefferson | Kansas | 20087 | 144 | 0 |
519178 | 519178 | 2020-09-10 | Jefferson | Kansas | 20087 | 144 | 0 |
515943 | 515943 | 2020-09-09 | Jefferson | Kansas | 20087 | 139 | 0 |
512710 | 512710 | 2020-09-08 | Jefferson | Kansas | 20087 | 135 | 0 |
509477 | 509477 | 2020-09-07 | Jefferson | Kansas | 20087 | 135 | 0 |
506245 | 506245 | 2020-09-06 | Jefferson | Kansas | 20087 | 129 | 0 |
503011 | 503011 | 2020-09-05 | Jefferson | Kansas | 20087 | 129 | 0 |
499777 | 499777 | 2020-09-04 | Jefferson | Kansas | 20087 | 129 | 0 |
496544 | 496544 | 2020-09-03 | Jefferson | Kansas | 20087 | 125 | 0 |
493310 | 493310 | 2020-09-02 | Jefferson | Kansas | 20087 | 125 | 0 |
490077 | 490077 | 2020-09-01 | Jefferson | Kansas | 20087 | 122 | 0 |
486844 | 486844 | 2020-08-31 | Jefferson | Kansas | 20087 | 120 | 0 |
483609 | 483609 | 2020-08-30 | Jefferson | Kansas | 20087 | 117 | 0 |
480375 | 480375 | 2020-08-29 | Jefferson | Kansas | 20087 | 117 | 0 |
477142 | 477142 | 2020-08-28 | Jefferson | Kansas | 20087 | 117 | 0 |
473909 | 473909 | 2020-08-27 | Jefferson | Kansas | 20087 | 112 | 0 |
470677 | 470677 | 2020-08-26 | Jefferson | Kansas | 20087 | 112 | 0 |
467448 | 467448 | 2020-08-25 | Jefferson | Kansas | 20087 | 106 | 0 |
464219 | 464219 | 2020-08-24 | Jefferson | Kansas | 20087 | 106 | 0 |
460990 | 460990 | 2020-08-23 | Jefferson | Kansas | 20087 | 103 | 0 |
457763 | 457763 | 2020-08-22 | Jefferson | Kansas | 20087 | 103 | 0 |
454535 | 454535 | 2020-08-21 | Jefferson | Kansas | 20087 | 103 | 0 |
451307 | 451307 | 2020-08-20 | Jefferson | Kansas | 20087 | 100 | 0 |
448079 | 448079 | 2020-08-19 | Jefferson | Kansas | 20087 | 100 | 0 |
444852 | 444852 | 2020-08-18 | Jefferson | Kansas | 20087 | 96 | 0 |
441626 | 441626 | 2020-08-17 | Jefferson | Kansas | 20087 | 96 | 0 |
438399 | 438399 | 2020-08-16 | Jefferson | Kansas | 20087 | 91 | 0 |
435174 | 435174 | 2020-08-15 | Jefferson | Kansas | 20087 | 91 | 0 |
431949 | 431949 | 2020-08-14 | Jefferson | Kansas | 20087 | 91 | 0 |
428721 | 428721 | 2020-08-13 | Jefferson | Kansas | 20087 | 88 | 0 |
425497 | 425497 | 2020-08-12 | Jefferson | Kansas | 20087 | 88 | 0 |
422276 | 422276 | 2020-08-11 | Jefferson | Kansas | 20087 | 87 | 0 |
419053 | 419053 | 2020-08-10 | Jefferson | Kansas | 20087 | 86 | 0 |
415832 | 415832 | 2020-08-09 | Jefferson | Kansas | 20087 | 80 | 0 |
412612 | 412612 | 2020-08-08 | Jefferson | Kansas | 20087 | 80 | 0 |
409392 | 409392 | 2020-08-07 | Jefferson | Kansas | 20087 | 80 | 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);