ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 20087 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
406173 | 406173 | 2020-08-06 | Jefferson | Kansas | 20087 | 79 | 0 |
402955 | 402955 | 2020-08-05 | Jefferson | Kansas | 20087 | 78 | 0 |
399738 | 399738 | 2020-08-04 | Jefferson | Kansas | 20087 | 77 | 0 |
396523 | 396523 | 2020-08-03 | Jefferson | Kansas | 20087 | 73 | 0 |
393307 | 393307 | 2020-08-02 | Jefferson | Kansas | 20087 | 61 | 0 |
390090 | 390090 | 2020-08-01 | Jefferson | Kansas | 20087 | 61 | 0 |
386873 | 386873 | 2020-07-31 | Jefferson | Kansas | 20087 | 61 | 0 |
383655 | 383655 | 2020-07-30 | Jefferson | Kansas | 20087 | 56 | 0 |
380438 | 380438 | 2020-07-29 | Jefferson | Kansas | 20087 | 56 | 0 |
377221 | 377221 | 2020-07-28 | Jefferson | Kansas | 20087 | 53 | 0 |
374006 | 374006 | 2020-07-27 | Jefferson | Kansas | 20087 | 51 | 0 |
370794 | 370794 | 2020-07-26 | Jefferson | Kansas | 20087 | 48 | 0 |
367584 | 367584 | 2020-07-25 | Jefferson | Kansas | 20087 | 48 | 0 |
364377 | 364377 | 2020-07-24 | Jefferson | Kansas | 20087 | 48 | 0 |
361170 | 361170 | 2020-07-23 | Jefferson | Kansas | 20087 | 46 | 0 |
357965 | 357965 | 2020-07-22 | Jefferson | Kansas | 20087 | 44 | 0 |
354763 | 354763 | 2020-07-21 | Jefferson | Kansas | 20087 | 44 | 0 |
351561 | 351561 | 2020-07-20 | Jefferson | Kansas | 20087 | 44 | 0 |
348361 | 348361 | 2020-07-19 | Jefferson | Kansas | 20087 | 41 | 0 |
345160 | 345160 | 2020-07-18 | Jefferson | Kansas | 20087 | 41 | 0 |
341960 | 341960 | 2020-07-17 | Jefferson | Kansas | 20087 | 41 | 0 |
338764 | 338764 | 2020-07-16 | Jefferson | Kansas | 20087 | 39 | 0 |
335568 | 335568 | 2020-07-15 | Jefferson | Kansas | 20087 | 39 | 0 |
332375 | 332375 | 2020-07-14 | Jefferson | Kansas | 20087 | 38 | 0 |
329188 | 329188 | 2020-07-13 | Jefferson | Kansas | 20087 | 37 | 0 |
326002 | 326002 | 2020-07-12 | Jefferson | Kansas | 20087 | 38 | 0 |
322819 | 322819 | 2020-07-11 | Jefferson | Kansas | 20087 | 37 | 0 |
319640 | 319640 | 2020-07-10 | Jefferson | Kansas | 20087 | 37 | 0 |
316467 | 316467 | 2020-07-09 | Jefferson | Kansas | 20087 | 33 | 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);