ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
671 rows where county = "Decatur" and state = "Kansas" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
325978 | 325978 | 2020-07-12 | Decatur | Kansas | 20039 | 2 | 0 |
329164 | 329164 | 2020-07-13 | Decatur | Kansas | 20039 | 2 | 0 |
332351 | 332351 | 2020-07-14 | Decatur | Kansas | 20039 | 2 | 0 |
335544 | 335544 | 2020-07-15 | Decatur | Kansas | 20039 | 3 | 0 |
338740 | 338740 | 2020-07-16 | Decatur | Kansas | 20039 | 3 | 0 |
341936 | 341936 | 2020-07-17 | Decatur | Kansas | 20039 | 4 | 0 |
345136 | 345136 | 2020-07-18 | Decatur | Kansas | 20039 | 4 | 0 |
348337 | 348337 | 2020-07-19 | Decatur | Kansas | 20039 | 4 | 0 |
351537 | 351537 | 2020-07-20 | Decatur | Kansas | 20039 | 4 | 0 |
354739 | 354739 | 2020-07-21 | Decatur | Kansas | 20039 | 4 | 0 |
357941 | 357941 | 2020-07-22 | Decatur | Kansas | 20039 | 5 | 0 |
361146 | 361146 | 2020-07-23 | Decatur | Kansas | 20039 | 5 | 0 |
364353 | 364353 | 2020-07-24 | Decatur | Kansas | 20039 | 6 | 0 |
367560 | 367560 | 2020-07-25 | Decatur | Kansas | 20039 | 6 | 0 |
370770 | 370770 | 2020-07-26 | Decatur | Kansas | 20039 | 6 | 0 |
373982 | 373982 | 2020-07-27 | Decatur | Kansas | 20039 | 6 | 0 |
377197 | 377197 | 2020-07-28 | Decatur | Kansas | 20039 | 6 | 0 |
380414 | 380414 | 2020-07-29 | Decatur | Kansas | 20039 | 6 | 0 |
383631 | 383631 | 2020-07-30 | Decatur | Kansas | 20039 | 6 | 0 |
386849 | 386849 | 2020-07-31 | Decatur | Kansas | 20039 | 6 | 0 |
390066 | 390066 | 2020-08-01 | Decatur | Kansas | 20039 | 6 | 0 |
393283 | 393283 | 2020-08-02 | Decatur | Kansas | 20039 | 6 | 0 |
396499 | 396499 | 2020-08-03 | Decatur | Kansas | 20039 | 6 | 0 |
399714 | 399714 | 2020-08-04 | Decatur | Kansas | 20039 | 6 | 0 |
402931 | 402931 | 2020-08-05 | Decatur | Kansas | 20039 | 6 | 0 |
406149 | 406149 | 2020-08-06 | Decatur | Kansas | 20039 | 6 | 0 |
409368 | 409368 | 2020-08-07 | Decatur | Kansas | 20039 | 6 | 0 |
412588 | 412588 | 2020-08-08 | Decatur | Kansas | 20039 | 6 | 0 |
415808 | 415808 | 2020-08-09 | Decatur | Kansas | 20039 | 6 | 0 |
419029 | 419029 | 2020-08-10 | Decatur | Kansas | 20039 | 6 | 0 |
422252 | 422252 | 2020-08-11 | Decatur | Kansas | 20039 | 6 | 0 |
425473 | 425473 | 2020-08-12 | Decatur | Kansas | 20039 | 6 | 0 |
428697 | 428697 | 2020-08-13 | Decatur | Kansas | 20039 | 6 | 0 |
431925 | 431925 | 2020-08-14 | Decatur | Kansas | 20039 | 6 | 0 |
435150 | 435150 | 2020-08-15 | Decatur | Kansas | 20039 | 6 | 0 |
438375 | 438375 | 2020-08-16 | Decatur | Kansas | 20039 | 6 | 0 |
441602 | 441602 | 2020-08-17 | Decatur | Kansas | 20039 | 6 | 0 |
444828 | 444828 | 2020-08-18 | Decatur | Kansas | 20039 | 6 | 0 |
448055 | 448055 | 2020-08-19 | Decatur | Kansas | 20039 | 6 | 0 |
451283 | 451283 | 2020-08-20 | Decatur | Kansas | 20039 | 6 | 0 |
454511 | 454511 | 2020-08-21 | Decatur | Kansas | 20039 | 6 | 0 |
457739 | 457739 | 2020-08-22 | Decatur | Kansas | 20039 | 6 | 0 |
460966 | 460966 | 2020-08-23 | Decatur | Kansas | 20039 | 6 | 0 |
464195 | 464195 | 2020-08-24 | Decatur | Kansas | 20039 | 6 | 0 |
467424 | 467424 | 2020-08-25 | Decatur | Kansas | 20039 | 6 | 0 |
470653 | 470653 | 2020-08-26 | Decatur | Kansas | 20039 | 6 | 0 |
473885 | 473885 | 2020-08-27 | Decatur | Kansas | 20039 | 6 | 0 |
477118 | 477118 | 2020-08-28 | Decatur | Kansas | 20039 | 6 | 0 |
480351 | 480351 | 2020-08-29 | Decatur | Kansas | 20039 | 6 | 0 |
483585 | 483585 | 2020-08-30 | Decatur | Kansas | 20039 | 6 | 0 |
486820 | 486820 | 2020-08-31 | Decatur | Kansas | 20039 | 7 | 0 |
490053 | 490053 | 2020-09-01 | Decatur | Kansas | 20039 | 7 | 0 |
493286 | 493286 | 2020-09-02 | Decatur | Kansas | 20039 | 7 | 0 |
496520 | 496520 | 2020-09-03 | Decatur | Kansas | 20039 | 7 | 0 |
499753 | 499753 | 2020-09-04 | Decatur | Kansas | 20039 | 6 | 0 |
502987 | 502987 | 2020-09-05 | Decatur | Kansas | 20039 | 6 | 0 |
506221 | 506221 | 2020-09-06 | Decatur | Kansas | 20039 | 6 | 0 |
509453 | 509453 | 2020-09-07 | Decatur | Kansas | 20039 | 6 | 0 |
512686 | 512686 | 2020-09-08 | Decatur | Kansas | 20039 | 8 | 0 |
515919 | 515919 | 2020-09-09 | Decatur | Kansas | 20039 | 8 | 0 |
519154 | 519154 | 2020-09-10 | Decatur | Kansas | 20039 | 8 | 0 |
522391 | 522391 | 2020-09-11 | Decatur | Kansas | 20039 | 8 | 0 |
525627 | 525627 | 2020-09-12 | Decatur | Kansas | 20039 | 8 | 0 |
528863 | 528863 | 2020-09-13 | Decatur | Kansas | 20039 | 8 | 0 |
532100 | 532100 | 2020-09-14 | Decatur | Kansas | 20039 | 8 | 0 |
535335 | 535335 | 2020-09-15 | Decatur | Kansas | 20039 | 10 | 0 |
538571 | 538571 | 2020-09-16 | Decatur | Kansas | 20039 | 10 | 0 |
541808 | 541808 | 2020-09-17 | Decatur | Kansas | 20039 | 10 | 0 |
545044 | 545044 | 2020-09-18 | Decatur | Kansas | 20039 | 19 | 0 |
548282 | 548282 | 2020-09-19 | Decatur | Kansas | 20039 | 19 | 0 |
551521 | 551521 | 2020-09-20 | Decatur | Kansas | 20039 | 19 | 0 |
554760 | 554760 | 2020-09-21 | Decatur | Kansas | 20039 | 19 | 0 |
557997 | 557997 | 2020-09-22 | Decatur | Kansas | 20039 | 22 | 0 |
561233 | 561233 | 2020-09-23 | Decatur | Kansas | 20039 | 22 | 0 |
564473 | 564473 | 2020-09-24 | Decatur | Kansas | 20039 | 22 | 0 |
567713 | 567713 | 2020-09-25 | Decatur | Kansas | 20039 | 22 | 0 |
570955 | 570955 | 2020-09-26 | Decatur | Kansas | 20039 | 22 | 0 |
574198 | 574198 | 2020-09-27 | Decatur | Kansas | 20039 | 24 | 0 |
577440 | 577440 | 2020-09-28 | Decatur | Kansas | 20039 | 26 | 1 |
580681 | 580681 | 2020-09-29 | Decatur | Kansas | 20039 | 26 | 1 |
583920 | 583920 | 2020-09-30 | Decatur | Kansas | 20039 | 26 | 1 |
587160 | 587160 | 2020-10-01 | Decatur | Kansas | 20039 | 26 | 1 |
590401 | 590401 | 2020-10-02 | Decatur | Kansas | 20039 | 29 | 1 |
593642 | 593642 | 2020-10-03 | Decatur | Kansas | 20039 | 29 | 1 |
596884 | 596884 | 2020-10-04 | Decatur | Kansas | 20039 | 29 | 1 |
600126 | 600126 | 2020-10-05 | Decatur | Kansas | 20039 | 31 | 1 |
603369 | 603369 | 2020-10-06 | Decatur | Kansas | 20039 | 31 | 1 |
606611 | 606611 | 2020-10-07 | Decatur | Kansas | 20039 | 31 | 1 |
609854 | 609854 | 2020-10-08 | Decatur | Kansas | 20039 | 31 | 1 |
613096 | 613096 | 2020-10-09 | Decatur | Kansas | 20039 | 39 | 1 |
616337 | 616337 | 2020-10-10 | Decatur | Kansas | 20039 | 39 | 1 |
619579 | 619579 | 2020-10-11 | Decatur | Kansas | 20039 | 39 | 1 |
622823 | 622823 | 2020-10-12 | Decatur | Kansas | 20039 | 42 | 1 |
626065 | 626065 | 2020-10-13 | Decatur | Kansas | 20039 | 43 | 1 |
629308 | 629308 | 2020-10-14 | Decatur | Kansas | 20039 | 44 | 1 |
632552 | 632552 | 2020-10-15 | Decatur | Kansas | 20039 | 44 | 1 |
635798 | 635798 | 2020-10-16 | Decatur | Kansas | 20039 | 51 | 1 |
639044 | 639044 | 2020-10-17 | Decatur | Kansas | 20039 | 51 | 1 |
642291 | 642291 | 2020-10-18 | Decatur | Kansas | 20039 | 51 | 1 |
645538 | 645538 | 2020-10-19 | Decatur | Kansas | 20039 | 67 | 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);