ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where fips = 20035 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635796 | 635796 | 2020-10-16 | Cowley | Kansas | 20035 | 482 | 9 |
632550 | 632550 | 2020-10-15 | Cowley | Kansas | 20035 | 464 | 9 |
629306 | 629306 | 2020-10-14 | Cowley | Kansas | 20035 | 464 | 9 |
626063 | 626063 | 2020-10-13 | Cowley | Kansas | 20035 | 454 | 9 |
622821 | 622821 | 2020-10-12 | Cowley | Kansas | 20035 | 454 | 9 |
619577 | 619577 | 2020-10-11 | Cowley | Kansas | 20035 | 436 | 9 |
616335 | 616335 | 2020-10-10 | Cowley | Kansas | 20035 | 436 | 9 |
613094 | 613094 | 2020-10-09 | Cowley | Kansas | 20035 | 436 | 9 |
609852 | 609852 | 2020-10-08 | Cowley | Kansas | 20035 | 426 | 8 |
606609 | 606609 | 2020-10-07 | Cowley | Kansas | 20035 | 426 | 8 |
603367 | 603367 | 2020-10-06 | Cowley | Kansas | 20035 | 420 | 8 |
600124 | 600124 | 2020-10-05 | Cowley | Kansas | 20035 | 420 | 8 |
596882 | 596882 | 2020-10-04 | Cowley | Kansas | 20035 | 407 | 8 |
593640 | 593640 | 2020-10-03 | Cowley | Kansas | 20035 | 407 | 8 |
590399 | 590399 | 2020-10-02 | Cowley | Kansas | 20035 | 407 | 8 |
587158 | 587158 | 2020-10-01 | Cowley | Kansas | 20035 | 401 | 5 |
583918 | 583918 | 2020-09-30 | Cowley | Kansas | 20035 | 401 | 5 |
580679 | 580679 | 2020-09-29 | Cowley | Kansas | 20035 | 389 | 5 |
577438 | 577438 | 2020-09-28 | Cowley | Kansas | 20035 | 389 | 5 |
574196 | 574196 | 2020-09-27 | Cowley | Kansas | 20035 | 373 | 5 |
570953 | 570953 | 2020-09-26 | Cowley | Kansas | 20035 | 373 | 5 |
567711 | 567711 | 2020-09-25 | Cowley | Kansas | 20035 | 373 | 5 |
564471 | 564471 | 2020-09-24 | Cowley | Kansas | 20035 | 359 | 5 |
561231 | 561231 | 2020-09-23 | Cowley | Kansas | 20035 | 359 | 4 |
557995 | 557995 | 2020-09-22 | Cowley | Kansas | 20035 | 348 | 3 |
554758 | 554758 | 2020-09-21 | Cowley | Kansas | 20035 | 348 | 3 |
551519 | 551519 | 2020-09-20 | Cowley | Kansas | 20035 | 327 | 3 |
548280 | 548280 | 2020-09-19 | Cowley | Kansas | 20035 | 327 | 3 |
545042 | 545042 | 2020-09-18 | Cowley | Kansas | 20035 | 327 | 3 |
541806 | 541806 | 2020-09-17 | Cowley | Kansas | 20035 | 313 | 3 |
538569 | 538569 | 2020-09-16 | Cowley | Kansas | 20035 | 313 | 3 |
535333 | 535333 | 2020-09-15 | Cowley | Kansas | 20035 | 302 | 3 |
532098 | 532098 | 2020-09-14 | Cowley | Kansas | 20035 | 302 | 3 |
528861 | 528861 | 2020-09-13 | Cowley | Kansas | 20035 | 286 | 3 |
525625 | 525625 | 2020-09-12 | Cowley | Kansas | 20035 | 286 | 3 |
522389 | 522389 | 2020-09-11 | Cowley | Kansas | 20035 | 286 | 3 |
519152 | 519152 | 2020-09-10 | Cowley | Kansas | 20035 | 283 | 3 |
515917 | 515917 | 2020-09-09 | Cowley | Kansas | 20035 | 283 | 3 |
512684 | 512684 | 2020-09-08 | Cowley | Kansas | 20035 | 280 | 3 |
509451 | 509451 | 2020-09-07 | Cowley | Kansas | 20035 | 280 | 3 |
506219 | 506219 | 2020-09-06 | Cowley | Kansas | 20035 | 270 | 3 |
502985 | 502985 | 2020-09-05 | Cowley | Kansas | 20035 | 270 | 3 |
499751 | 499751 | 2020-09-04 | Cowley | Kansas | 20035 | 270 | 3 |
496518 | 496518 | 2020-09-03 | Cowley | Kansas | 20035 | 266 | 3 |
493284 | 493284 | 2020-09-02 | Cowley | Kansas | 20035 | 266 | 3 |
490051 | 490051 | 2020-09-01 | Cowley | Kansas | 20035 | 255 | 3 |
486818 | 486818 | 2020-08-31 | Cowley | Kansas | 20035 | 255 | 3 |
483583 | 483583 | 2020-08-30 | Cowley | Kansas | 20035 | 249 | 3 |
480349 | 480349 | 2020-08-29 | Cowley | Kansas | 20035 | 249 | 3 |
477116 | 477116 | 2020-08-28 | Cowley | Kansas | 20035 | 249 | 3 |
473883 | 473883 | 2020-08-27 | Cowley | Kansas | 20035 | 247 | 3 |
470651 | 470651 | 2020-08-26 | Cowley | Kansas | 20035 | 247 | 3 |
467422 | 467422 | 2020-08-25 | Cowley | Kansas | 20035 | 240 | 3 |
464193 | 464193 | 2020-08-24 | Cowley | Kansas | 20035 | 240 | 3 |
460964 | 460964 | 2020-08-23 | Cowley | Kansas | 20035 | 222 | 3 |
457737 | 457737 | 2020-08-22 | Cowley | Kansas | 20035 | 222 | 3 |
454509 | 454509 | 2020-08-21 | Cowley | Kansas | 20035 | 222 | 3 |
451281 | 451281 | 2020-08-20 | Cowley | Kansas | 20035 | 203 | 2 |
448053 | 448053 | 2020-08-19 | Cowley | Kansas | 20035 | 203 | 2 |
444826 | 444826 | 2020-08-18 | Cowley | Kansas | 20035 | 198 | 2 |
441600 | 441600 | 2020-08-17 | Cowley | Kansas | 20035 | 198 | 2 |
438373 | 438373 | 2020-08-16 | Cowley | Kansas | 20035 | 182 | 2 |
435148 | 435148 | 2020-08-15 | Cowley | Kansas | 20035 | 182 | 2 |
431923 | 431923 | 2020-08-14 | Cowley | Kansas | 20035 | 182 | 2 |
428695 | 428695 | 2020-08-13 | Cowley | Kansas | 20035 | 178 | 2 |
425471 | 425471 | 2020-08-12 | Cowley | Kansas | 20035 | 178 | 2 |
422250 | 422250 | 2020-08-11 | Cowley | Kansas | 20035 | 174 | 2 |
419027 | 419027 | 2020-08-10 | Cowley | Kansas | 20035 | 173 | 2 |
415806 | 415806 | 2020-08-09 | Cowley | Kansas | 20035 | 165 | 2 |
412586 | 412586 | 2020-08-08 | Cowley | Kansas | 20035 | 165 | 2 |
409366 | 409366 | 2020-08-07 | Cowley | Kansas | 20035 | 165 | 2 |
406147 | 406147 | 2020-08-06 | Cowley | Kansas | 20035 | 160 | 2 |
402929 | 402929 | 2020-08-05 | Cowley | Kansas | 20035 | 160 | 2 |
399712 | 399712 | 2020-08-04 | Cowley | Kansas | 20035 | 160 | 2 |
396497 | 396497 | 2020-08-03 | Cowley | Kansas | 20035 | 158 | 2 |
393281 | 393281 | 2020-08-02 | Cowley | Kansas | 20035 | 151 | 2 |
390064 | 390064 | 2020-08-01 | Cowley | Kansas | 20035 | 151 | 2 |
386847 | 386847 | 2020-07-31 | Cowley | Kansas | 20035 | 151 | 2 |
383629 | 383629 | 2020-07-30 | Cowley | Kansas | 20035 | 146 | 2 |
380412 | 380412 | 2020-07-29 | Cowley | Kansas | 20035 | 146 | 2 |
377195 | 377195 | 2020-07-28 | Cowley | Kansas | 20035 | 140 | 2 |
373980 | 373980 | 2020-07-27 | Cowley | Kansas | 20035 | 140 | 2 |
370768 | 370768 | 2020-07-26 | Cowley | Kansas | 20035 | 128 | 2 |
367558 | 367558 | 2020-07-25 | Cowley | Kansas | 20035 | 128 | 2 |
364351 | 364351 | 2020-07-24 | Cowley | Kansas | 20035 | 128 | 2 |
361144 | 361144 | 2020-07-23 | Cowley | Kansas | 20035 | 124 | 2 |
357939 | 357939 | 2020-07-22 | Cowley | Kansas | 20035 | 118 | 2 |
354737 | 354737 | 2020-07-21 | Cowley | Kansas | 20035 | 118 | 2 |
351535 | 351535 | 2020-07-20 | Cowley | Kansas | 20035 | 118 | 1 |
348335 | 348335 | 2020-07-19 | Cowley | Kansas | 20035 | 97 | 1 |
345134 | 345134 | 2020-07-18 | Cowley | Kansas | 20035 | 97 | 1 |
341934 | 341934 | 2020-07-17 | Cowley | Kansas | 20035 | 97 | 1 |
338738 | 338738 | 2020-07-16 | Cowley | Kansas | 20035 | 90 | 1 |
335542 | 335542 | 2020-07-15 | Cowley | Kansas | 20035 | 90 | 1 |
332349 | 332349 | 2020-07-14 | Cowley | Kansas | 20035 | 88 | 1 |
329162 | 329162 | 2020-07-13 | Cowley | Kansas | 20035 | 88 | 1 |
325976 | 325976 | 2020-07-12 | Cowley | Kansas | 20035 | 83 | 1 |
322795 | 322795 | 2020-07-11 | Cowley | Kansas | 20035 | 79 | 1 |
319616 | 319616 | 2020-07-10 | Cowley | Kansas | 20035 | 79 | 1 |
316443 | 316443 | 2020-07-09 | Cowley | Kansas | 20035 | 77 | 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);