ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Marion" and state = "Kansas" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
326015 | 326015 | 2020-07-12 | Marion | Kansas | 20115 | 22 | 1 |
329201 | 329201 | 2020-07-13 | Marion | Kansas | 20115 | 24 | 1 |
332388 | 332388 | 2020-07-14 | Marion | Kansas | 20115 | 24 | 1 |
335581 | 335581 | 2020-07-15 | Marion | Kansas | 20115 | 26 | 1 |
338777 | 338777 | 2020-07-16 | Marion | Kansas | 20115 | 26 | 1 |
341973 | 341973 | 2020-07-17 | Marion | Kansas | 20115 | 27 | 1 |
345173 | 345173 | 2020-07-18 | Marion | Kansas | 20115 | 27 | 1 |
348374 | 348374 | 2020-07-19 | Marion | Kansas | 20115 | 27 | 1 |
351574 | 351574 | 2020-07-20 | Marion | Kansas | 20115 | 34 | 1 |
354776 | 354776 | 2020-07-21 | Marion | Kansas | 20115 | 34 | 1 |
357978 | 357978 | 2020-07-22 | Marion | Kansas | 20115 | 36 | 1 |
361183 | 361183 | 2020-07-23 | Marion | Kansas | 20115 | 36 | 1 |
364390 | 364390 | 2020-07-24 | Marion | Kansas | 20115 | 42 | 1 |
367597 | 367597 | 2020-07-25 | Marion | Kansas | 20115 | 42 | 1 |
370807 | 370807 | 2020-07-26 | Marion | Kansas | 20115 | 42 | 1 |
374019 | 374019 | 2020-07-27 | Marion | Kansas | 20115 | 46 | 1 |
377234 | 377234 | 2020-07-28 | Marion | Kansas | 20115 | 46 | 1 |
380451 | 380451 | 2020-07-29 | Marion | Kansas | 20115 | 50 | 1 |
383668 | 383668 | 2020-07-30 | Marion | Kansas | 20115 | 50 | 1 |
386886 | 386886 | 2020-07-31 | Marion | Kansas | 20115 | 51 | 1 |
390103 | 390103 | 2020-08-01 | Marion | Kansas | 20115 | 51 | 1 |
393320 | 393320 | 2020-08-02 | Marion | Kansas | 20115 | 51 | 1 |
396536 | 396536 | 2020-08-03 | Marion | Kansas | 20115 | 52 | 1 |
399751 | 399751 | 2020-08-04 | Marion | Kansas | 20115 | 52 | 1 |
402968 | 402968 | 2020-08-05 | Marion | Kansas | 20115 | 56 | 1 |
406186 | 406186 | 2020-08-06 | Marion | Kansas | 20115 | 56 | 1 |
409405 | 409405 | 2020-08-07 | Marion | Kansas | 20115 | 58 | 1 |
412625 | 412625 | 2020-08-08 | Marion | Kansas | 20115 | 58 | 1 |
415845 | 415845 | 2020-08-09 | Marion | Kansas | 20115 | 58 | 1 |
419066 | 419066 | 2020-08-10 | Marion | Kansas | 20115 | 58 | 1 |
422289 | 422289 | 2020-08-11 | Marion | Kansas | 20115 | 58 | 1 |
425510 | 425510 | 2020-08-12 | Marion | Kansas | 20115 | 58 | 1 |
428734 | 428734 | 2020-08-13 | Marion | Kansas | 20115 | 58 | 1 |
431962 | 431962 | 2020-08-14 | Marion | Kansas | 20115 | 59 | 1 |
435187 | 435187 | 2020-08-15 | Marion | Kansas | 20115 | 59 | 1 |
438412 | 438412 | 2020-08-16 | Marion | Kansas | 20115 | 59 | 1 |
441639 | 441639 | 2020-08-17 | Marion | Kansas | 20115 | 60 | 1 |
444865 | 444865 | 2020-08-18 | Marion | Kansas | 20115 | 60 | 1 |
448092 | 448092 | 2020-08-19 | Marion | Kansas | 20115 | 60 | 1 |
451320 | 451320 | 2020-08-20 | Marion | Kansas | 20115 | 60 | 1 |
454548 | 454548 | 2020-08-21 | Marion | Kansas | 20115 | 61 | 1 |
457776 | 457776 | 2020-08-22 | Marion | Kansas | 20115 | 61 | 1 |
461003 | 461003 | 2020-08-23 | Marion | Kansas | 20115 | 61 | 1 |
464232 | 464232 | 2020-08-24 | Marion | Kansas | 20115 | 61 | 1 |
467461 | 467461 | 2020-08-25 | Marion | Kansas | 20115 | 61 | 1 |
470690 | 470690 | 2020-08-26 | Marion | Kansas | 20115 | 63 | 1 |
473922 | 473922 | 2020-08-27 | Marion | Kansas | 20115 | 63 | 1 |
477155 | 477155 | 2020-08-28 | Marion | Kansas | 20115 | 64 | 1 |
480388 | 480388 | 2020-08-29 | Marion | Kansas | 20115 | 64 | 1 |
483622 | 483622 | 2020-08-30 | Marion | Kansas | 20115 | 64 | 1 |
486857 | 486857 | 2020-08-31 | Marion | Kansas | 20115 | 68 | 1 |
490090 | 490090 | 2020-09-01 | Marion | Kansas | 20115 | 68 | 1 |
493323 | 493323 | 2020-09-02 | Marion | Kansas | 20115 | 72 | 1 |
496557 | 496557 | 2020-09-03 | Marion | Kansas | 20115 | 72 | 1 |
499790 | 499790 | 2020-09-04 | Marion | Kansas | 20115 | 82 | 1 |
503024 | 503024 | 2020-09-05 | Marion | Kansas | 20115 | 82 | 1 |
506258 | 506258 | 2020-09-06 | Marion | Kansas | 20115 | 82 | 1 |
509490 | 509490 | 2020-09-07 | Marion | Kansas | 20115 | 83 | 1 |
512723 | 512723 | 2020-09-08 | Marion | Kansas | 20115 | 83 | 1 |
515956 | 515956 | 2020-09-09 | Marion | Kansas | 20115 | 84 | 1 |
519191 | 519191 | 2020-09-10 | Marion | Kansas | 20115 | 84 | 1 |
522428 | 522428 | 2020-09-11 | Marion | Kansas | 20115 | 84 | 1 |
525664 | 525664 | 2020-09-12 | Marion | Kansas | 20115 | 84 | 1 |
528900 | 528900 | 2020-09-13 | Marion | Kansas | 20115 | 84 | 1 |
532137 | 532137 | 2020-09-14 | Marion | Kansas | 20115 | 85 | 1 |
535372 | 535372 | 2020-09-15 | Marion | Kansas | 20115 | 85 | 1 |
538608 | 538608 | 2020-09-16 | Marion | Kansas | 20115 | 85 | 1 |
541845 | 541845 | 2020-09-17 | Marion | Kansas | 20115 | 85 | 1 |
545081 | 545081 | 2020-09-18 | Marion | Kansas | 20115 | 86 | 1 |
548319 | 548319 | 2020-09-19 | Marion | Kansas | 20115 | 86 | 1 |
551558 | 551558 | 2020-09-20 | Marion | Kansas | 20115 | 86 | 1 |
554797 | 554797 | 2020-09-21 | Marion | Kansas | 20115 | 86 | 1 |
558034 | 558034 | 2020-09-22 | Marion | Kansas | 20115 | 86 | 1 |
561270 | 561270 | 2020-09-23 | Marion | Kansas | 20115 | 86 | 1 |
564510 | 564510 | 2020-09-24 | Marion | Kansas | 20115 | 86 | 1 |
567750 | 567750 | 2020-09-25 | Marion | Kansas | 20115 | 90 | 1 |
570992 | 570992 | 2020-09-26 | Marion | Kansas | 20115 | 90 | 1 |
574235 | 574235 | 2020-09-27 | Marion | Kansas | 20115 | 90 | 1 |
577477 | 577477 | 2020-09-28 | Marion | Kansas | 20115 | 92 | 1 |
580718 | 580718 | 2020-09-29 | Marion | Kansas | 20115 | 92 | 1 |
583957 | 583957 | 2020-09-30 | Marion | Kansas | 20115 | 102 | 1 |
587197 | 587197 | 2020-10-01 | Marion | Kansas | 20115 | 102 | 1 |
590438 | 590438 | 2020-10-02 | Marion | Kansas | 20115 | 103 | 1 |
593679 | 593679 | 2020-10-03 | Marion | Kansas | 20115 | 103 | 1 |
596921 | 596921 | 2020-10-04 | Marion | Kansas | 20115 | 103 | 1 |
600163 | 600163 | 2020-10-05 | Marion | Kansas | 20115 | 110 | 1 |
603406 | 603406 | 2020-10-06 | Marion | Kansas | 20115 | 110 | 1 |
606648 | 606648 | 2020-10-07 | Marion | Kansas | 20115 | 113 | 1 |
609891 | 609891 | 2020-10-08 | Marion | Kansas | 20115 | 113 | 1 |
613133 | 613133 | 2020-10-09 | Marion | Kansas | 20115 | 121 | 1 |
616374 | 616374 | 2020-10-10 | Marion | Kansas | 20115 | 126 | 1 |
619616 | 619616 | 2020-10-11 | Marion | Kansas | 20115 | 126 | 1 |
622860 | 622860 | 2020-10-12 | Marion | Kansas | 20115 | 126 | 1 |
626102 | 626102 | 2020-10-13 | Marion | Kansas | 20115 | 134 | 1 |
629345 | 629345 | 2020-10-14 | Marion | Kansas | 20115 | 134 | 1 |
632589 | 632589 | 2020-10-15 | Marion | Kansas | 20115 | 134 | 1 |
635835 | 635835 | 2020-10-16 | Marion | Kansas | 20115 | 147 | 1 |
639081 | 639081 | 2020-10-17 | Marion | Kansas | 20115 | 147 | 1 |
642328 | 642328 | 2020-10-18 | Marion | Kansas | 20115 | 147 | 1 |
645575 | 645575 | 2020-10-19 | Marion | Kansas | 20115 | 151 | 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);