ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Jackson" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635821 | 635821 | 2020-10-16 | Jackson | Kansas | 20085 | 286 | 4 |
632575 | 632575 | 2020-10-15 | Jackson | Kansas | 20085 | 279 | 3 |
629331 | 629331 | 2020-10-14 | Jackson | Kansas | 20085 | 279 | 3 |
626088 | 626088 | 2020-10-13 | Jackson | Kansas | 20085 | 275 | 3 |
622846 | 622846 | 2020-10-12 | Jackson | Kansas | 20085 | 275 | 3 |
619602 | 619602 | 2020-10-11 | Jackson | Kansas | 20085 | 273 | 3 |
616360 | 616360 | 2020-10-10 | Jackson | Kansas | 20085 | 273 | 3 |
613119 | 613119 | 2020-10-09 | Jackson | Kansas | 20085 | 273 | 3 |
609877 | 609877 | 2020-10-08 | Jackson | Kansas | 20085 | 266 | 3 |
606634 | 606634 | 2020-10-07 | Jackson | Kansas | 20085 | 266 | 3 |
603392 | 603392 | 2020-10-06 | Jackson | Kansas | 20085 | 258 | 3 |
600149 | 600149 | 2020-10-05 | Jackson | Kansas | 20085 | 256 | 2 |
596907 | 596907 | 2020-10-04 | Jackson | Kansas | 20085 | 253 | 2 |
593665 | 593665 | 2020-10-03 | Jackson | Kansas | 20085 | 253 | 2 |
590424 | 590424 | 2020-10-02 | Jackson | Kansas | 20085 | 253 | 2 |
587183 | 587183 | 2020-10-01 | Jackson | Kansas | 20085 | 247 | 2 |
583943 | 583943 | 2020-09-30 | Jackson | Kansas | 20085 | 247 | 2 |
580704 | 580704 | 2020-09-29 | Jackson | Kansas | 20085 | 245 | 2 |
577463 | 577463 | 2020-09-28 | Jackson | Kansas | 20085 | 245 | 2 |
574221 | 574221 | 2020-09-27 | Jackson | Kansas | 20085 | 239 | 2 |
570978 | 570978 | 2020-09-26 | Jackson | Kansas | 20085 | 239 | 2 |
567736 | 567736 | 2020-09-25 | Jackson | Kansas | 20085 | 239 | 2 |
564496 | 564496 | 2020-09-24 | Jackson | Kansas | 20085 | 234 | 2 |
561256 | 561256 | 2020-09-23 | Jackson | Kansas | 20085 | 234 | 2 |
558020 | 558020 | 2020-09-22 | Jackson | Kansas | 20085 | 231 | 2 |
554783 | 554783 | 2020-09-21 | Jackson | Kansas | 20085 | 231 | 2 |
551544 | 551544 | 2020-09-20 | Jackson | Kansas | 20085 | 231 | 2 |
548305 | 548305 | 2020-09-19 | Jackson | Kansas | 20085 | 231 | 2 |
545067 | 545067 | 2020-09-18 | Jackson | Kansas | 20085 | 231 | 2 |
541831 | 541831 | 2020-09-17 | Jackson | Kansas | 20085 | 228 | 2 |
538594 | 538594 | 2020-09-16 | Jackson | Kansas | 20085 | 225 | 2 |
535358 | 535358 | 2020-09-15 | Jackson | Kansas | 20085 | 226 | 2 |
532123 | 532123 | 2020-09-14 | Jackson | Kansas | 20085 | 226 | 2 |
528886 | 528886 | 2020-09-13 | Jackson | Kansas | 20085 | 223 | 1 |
525650 | 525650 | 2020-09-12 | Jackson | Kansas | 20085 | 223 | 1 |
522414 | 522414 | 2020-09-11 | Jackson | Kansas | 20085 | 223 | 1 |
519177 | 519177 | 2020-09-10 | Jackson | Kansas | 20085 | 221 | 1 |
515942 | 515942 | 2020-09-09 | Jackson | Kansas | 20085 | 221 | 1 |
512709 | 512709 | 2020-09-08 | Jackson | Kansas | 20085 | 218 | 1 |
509476 | 509476 | 2020-09-07 | Jackson | Kansas | 20085 | 218 | 1 |
506244 | 506244 | 2020-09-06 | Jackson | Kansas | 20085 | 213 | 1 |
503010 | 503010 | 2020-09-05 | Jackson | Kansas | 20085 | 213 | 1 |
499776 | 499776 | 2020-09-04 | Jackson | Kansas | 20085 | 213 | 1 |
496543 | 496543 | 2020-09-03 | Jackson | Kansas | 20085 | 213 | 1 |
493309 | 493309 | 2020-09-02 | Jackson | Kansas | 20085 | 210 | 1 |
490076 | 490076 | 2020-09-01 | Jackson | Kansas | 20085 | 208 | 1 |
486843 | 486843 | 2020-08-31 | Jackson | Kansas | 20085 | 208 | 1 |
483608 | 483608 | 2020-08-30 | Jackson | Kansas | 20085 | 201 | 1 |
480374 | 480374 | 2020-08-29 | Jackson | Kansas | 20085 | 201 | 1 |
477141 | 477141 | 2020-08-28 | Jackson | Kansas | 20085 | 196 | 1 |
473908 | 473908 | 2020-08-27 | Jackson | Kansas | 20085 | 195 | 1 |
470676 | 470676 | 2020-08-26 | Jackson | Kansas | 20085 | 189 | 1 |
467447 | 467447 | 2020-08-25 | Jackson | Kansas | 20085 | 185 | 1 |
464218 | 464218 | 2020-08-24 | Jackson | Kansas | 20085 | 185 | 1 |
460989 | 460989 | 2020-08-23 | Jackson | Kansas | 20085 | 178 | 1 |
457762 | 457762 | 2020-08-22 | Jackson | Kansas | 20085 | 178 | 1 |
454534 | 454534 | 2020-08-21 | Jackson | Kansas | 20085 | 178 | 1 |
451306 | 451306 | 2020-08-20 | Jackson | Kansas | 20085 | 178 | 1 |
448078 | 448078 | 2020-08-19 | Jackson | Kansas | 20085 | 173 | 1 |
444851 | 444851 | 2020-08-18 | Jackson | Kansas | 20085 | 171 | 1 |
441625 | 441625 | 2020-08-17 | Jackson | Kansas | 20085 | 171 | 1 |
438398 | 438398 | 2020-08-16 | Jackson | Kansas | 20085 | 164 | 1 |
435173 | 435173 | 2020-08-15 | Jackson | Kansas | 20085 | 164 | 1 |
431948 | 431948 | 2020-08-14 | Jackson | Kansas | 20085 | 164 | 1 |
428720 | 428720 | 2020-08-13 | Jackson | Kansas | 20085 | 163 | 1 |
425496 | 425496 | 2020-08-12 | Jackson | Kansas | 20085 | 163 | 1 |
422275 | 422275 | 2020-08-11 | Jackson | Kansas | 20085 | 155 | 1 |
419052 | 419052 | 2020-08-10 | Jackson | Kansas | 20085 | 155 | 1 |
415831 | 415831 | 2020-08-09 | Jackson | Kansas | 20085 | 146 | 1 |
412611 | 412611 | 2020-08-08 | Jackson | Kansas | 20085 | 146 | 1 |
409391 | 409391 | 2020-08-07 | Jackson | Kansas | 20085 | 146 | 1 |
406172 | 406172 | 2020-08-06 | Jackson | Kansas | 20085 | 148 | 1 |
402954 | 402954 | 2020-08-05 | Jackson | Kansas | 20085 | 148 | 1 |
399737 | 399737 | 2020-08-04 | Jackson | Kansas | 20085 | 145 | 1 |
396522 | 396522 | 2020-08-03 | Jackson | Kansas | 20085 | 145 | 1 |
393306 | 393306 | 2020-08-02 | Jackson | Kansas | 20085 | 144 | 1 |
390089 | 390089 | 2020-08-01 | Jackson | Kansas | 20085 | 144 | 1 |
386872 | 386872 | 2020-07-31 | Jackson | Kansas | 20085 | 144 | 1 |
383654 | 383654 | 2020-07-30 | Jackson | Kansas | 20085 | 142 | 1 |
380437 | 380437 | 2020-07-29 | Jackson | Kansas | 20085 | 138 | 1 |
377220 | 377220 | 2020-07-28 | Jackson | Kansas | 20085 | 136 | 1 |
374005 | 374005 | 2020-07-27 | Jackson | Kansas | 20085 | 136 | 1 |
370793 | 370793 | 2020-07-26 | Jackson | Kansas | 20085 | 131 | 1 |
367583 | 367583 | 2020-07-25 | Jackson | Kansas | 20085 | 131 | 1 |
364376 | 364376 | 2020-07-24 | Jackson | Kansas | 20085 | 131 | 1 |
361169 | 361169 | 2020-07-23 | Jackson | Kansas | 20085 | 131 | 1 |
357964 | 357964 | 2020-07-22 | Jackson | Kansas | 20085 | 131 | 1 |
354762 | 354762 | 2020-07-21 | Jackson | Kansas | 20085 | 130 | 1 |
351560 | 351560 | 2020-07-20 | Jackson | Kansas | 20085 | 130 | 1 |
348360 | 348360 | 2020-07-19 | Jackson | Kansas | 20085 | 126 | 1 |
345159 | 345159 | 2020-07-18 | Jackson | Kansas | 20085 | 126 | 1 |
341959 | 341959 | 2020-07-17 | Jackson | Kansas | 20085 | 126 | 1 |
338763 | 338763 | 2020-07-16 | Jackson | Kansas | 20085 | 126 | 1 |
335567 | 335567 | 2020-07-15 | Jackson | Kansas | 20085 | 124 | 1 |
332374 | 332374 | 2020-07-14 | Jackson | Kansas | 20085 | 124 | 1 |
329187 | 329187 | 2020-07-13 | Jackson | Kansas | 20085 | 123 | 1 |
326001 | 326001 | 2020-07-12 | Jackson | Kansas | 20085 | 117 | 1 |
322818 | 322818 | 2020-07-11 | Jackson | Kansas | 20085 | 117 | 1 |
319639 | 319639 | 2020-07-10 | Jackson | Kansas | 20085 | 117 | 1 |
316466 | 316466 | 2020-07-09 | Jackson | Kansas | 20085 | 117 | 1 |
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);