ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where county = "Grant", deaths = 30 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
707395 | 707395 | 2020-11-07 | Grant | Louisiana | 22043 | 553 | 30 |
704152 | 704152 | 2020-11-06 | Grant | Louisiana | 22043 | 553 | 30 |
700910 | 700910 | 2020-11-05 | Grant | Louisiana | 22043 | 548 | 30 |
697666 | 697666 | 2020-11-04 | Grant | Louisiana | 22043 | 548 | 30 |
694423 | 694423 | 2020-11-03 | Grant | Louisiana | 22043 | 550 | 30 |
691181 | 691181 | 2020-11-02 | Grant | Louisiana | 22043 | 543 | 30 |
687936 | 687936 | 2020-11-01 | Grant | Louisiana | 22043 | 545 | 30 |
684692 | 684692 | 2020-10-31 | Grant | Louisiana | 22043 | 543 | 30 |
681449 | 681449 | 2020-10-30 | Grant | Louisiana | 22043 | 543 | 30 |
678205 | 678205 | 2020-10-29 | Grant | Louisiana | 22043 | 538 | 30 |
674963 | 674963 | 2020-10-28 | Grant | Louisiana | 22043 | 541 | 30 |
671720 | 671720 | 2020-10-27 | Grant | Louisiana | 22043 | 540 | 30 |
668478 | 668478 | 2020-10-26 | Grant | Louisiana | 22043 | 541 | 30 |
665234 | 665234 | 2020-10-25 | Grant | Louisiana | 22043 | 536 | 30 |
661989 | 661989 | 2020-10-24 | Grant | Louisiana | 22043 | 532 | 30 |
658745 | 658745 | 2020-10-23 | Grant | Louisiana | 22043 | 532 | 30 |
655500 | 655500 | 2020-10-22 | Grant | Louisiana | 22043 | 528 | 30 |
652255 | 652255 | 2020-10-21 | Grant | Louisiana | 22043 | 522 | 30 |
649010 | 649010 | 2020-10-20 | Grant | Louisiana | 22043 | 523 | 30 |
645766 | 645766 | 2020-10-19 | Grant | Louisiana | 22043 | 516 | 30 |
642519 | 642519 | 2020-10-18 | Grant | Louisiana | 22043 | 517 | 30 |
639272 | 639272 | 2020-10-17 | Grant | Louisiana | 22043 | 512 | 30 |
636026 | 636026 | 2020-10-16 | Grant | Louisiana | 22043 | 512 | 30 |
632780 | 632780 | 2020-10-15 | Grant | Louisiana | 22043 | 514 | 30 |
629536 | 629536 | 2020-10-14 | Grant | Louisiana | 22043 | 512 | 30 |
626292 | 626292 | 2020-10-13 | Grant | Louisiana | 22043 | 512 | 30 |
623050 | 623050 | 2020-10-12 | Grant | Louisiana | 22043 | 510 | 30 |
619806 | 619806 | 2020-10-11 | Grant | Louisiana | 22043 | 509 | 30 |
616564 | 616564 | 2020-10-10 | Grant | Louisiana | 22043 | 504 | 30 |
613323 | 613323 | 2020-10-09 | Grant | Louisiana | 22043 | 504 | 30 |
610081 | 610081 | 2020-10-08 | Grant | Louisiana | 22043 | 503 | 30 |
606839 | 606839 | 2020-10-07 | Grant | Louisiana | 22043 | 502 | 30 |
603597 | 603597 | 2020-10-06 | Grant | Louisiana | 22043 | 502 | 30 |
600354 | 600354 | 2020-10-05 | Grant | Louisiana | 22043 | 502 | 30 |
597112 | 597112 | 2020-10-04 | Grant | Louisiana | 22043 | 500 | 30 |
593870 | 593870 | 2020-10-03 | Grant | Louisiana | 22043 | 495 | 30 |
590629 | 590629 | 2020-10-02 | Grant | Louisiana | 22043 | 495 | 30 |
587388 | 587388 | 2020-10-01 | Grant | Louisiana | 22043 | 497 | 30 |
584148 | 584148 | 2020-09-30 | Grant | Louisiana | 22043 | 498 | 30 |
580908 | 580908 | 2020-09-29 | Grant | Louisiana | 22043 | 498 | 30 |
577667 | 577667 | 2020-09-28 | Grant | Louisiana | 22043 | 499 | 30 |
574425 | 574425 | 2020-09-27 | Grant | Louisiana | 22043 | 495 | 30 |
571182 | 571182 | 2020-09-26 | Grant | Louisiana | 22043 | 490 | 30 |
567940 | 567940 | 2020-09-25 | Grant | Louisiana | 22043 | 490 | 30 |
564700 | 564700 | 2020-09-24 | Grant | Louisiana | 22043 | 487 | 30 |
561460 | 561460 | 2020-09-23 | Grant | Louisiana | 22043 | 486 | 30 |
558224 | 558224 | 2020-09-22 | Grant | Louisiana | 22043 | 487 | 30 |
554987 | 554987 | 2020-09-21 | Grant | Louisiana | 22043 | 483 | 30 |
551748 | 551748 | 2020-09-20 | Grant | Louisiana | 22043 | 483 | 30 |
548509 | 548509 | 2020-09-19 | Grant | Louisiana | 22043 | 479 | 30 |
545271 | 545271 | 2020-09-18 | Grant | Louisiana | 22043 | 479 | 30 |
542035 | 542035 | 2020-09-17 | Grant | Louisiana | 22043 | 475 | 30 |
538799 | 538799 | 2020-09-16 | Grant | Louisiana | 22043 | 470 | 30 |
535562 | 535562 | 2020-09-15 | Grant | Louisiana | 22043 | 474 | 30 |
532327 | 532327 | 2020-09-14 | Grant | Louisiana | 22043 | 470 | 30 |
529090 | 529090 | 2020-09-13 | Grant | Louisiana | 22043 | 471 | 30 |
525854 | 525854 | 2020-09-12 | Grant | Louisiana | 22043 | 466 | 30 |
522618 | 522618 | 2020-09-11 | Grant | Louisiana | 22043 | 466 | 30 |
519381 | 519381 | 2020-09-10 | Grant | Louisiana | 22043 | 459 | 30 |
516146 | 516146 | 2020-09-09 | Grant | Louisiana | 22043 | 456 | 30 |
512913 | 512913 | 2020-09-08 | Grant | Louisiana | 22043 | 449 | 30 |
509681 | 509681 | 2020-09-07 | Grant | Louisiana | 22043 | 448 | 30 |
506448 | 506448 | 2020-09-06 | Grant | Louisiana | 22043 | 442 | 30 |
503214 | 503214 | 2020-09-05 | Grant | Louisiana | 22043 | 436 | 30 |
499981 | 499981 | 2020-09-04 | Grant | Louisiana | 22043 | 436 | 30 |
496747 | 496747 | 2020-09-03 | Grant | Louisiana | 22043 | 435 | 30 |
493514 | 493514 | 2020-09-02 | Grant | Louisiana | 22043 | 438 | 30 |
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);