ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "St. Bernard" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947564 | 947564 | 2021-01-20 | St. Bernard | Louisiana | 22087 | 2993 | 42 |
944317 | 944317 | 2021-01-19 | St. Bernard | Louisiana | 22087 | 2941 | 41 |
941072 | 941072 | 2021-01-18 | St. Bernard | Louisiana | 22087 | 2923 | 41 |
937827 | 937827 | 2021-01-17 | St. Bernard | Louisiana | 22087 | 2912 | 41 |
934582 | 934582 | 2021-01-16 | St. Bernard | Louisiana | 22087 | 2873 | 41 |
931337 | 931337 | 2021-01-15 | St. Bernard | Louisiana | 22087 | 2873 | 41 |
928092 | 928092 | 2021-01-14 | St. Bernard | Louisiana | 22087 | 2847 | 41 |
924846 | 924846 | 2021-01-13 | St. Bernard | Louisiana | 22087 | 2821 | 41 |
921601 | 921601 | 2021-01-12 | St. Bernard | Louisiana | 22087 | 2777 | 41 |
918356 | 918356 | 2021-01-11 | St. Bernard | Louisiana | 22087 | 2735 | 41 |
915111 | 915111 | 2021-01-10 | St. Bernard | Louisiana | 22087 | 2714 | 40 |
911866 | 911866 | 2021-01-09 | St. Bernard | Louisiana | 22087 | 2662 | 40 |
908621 | 908621 | 2021-01-08 | St. Bernard | Louisiana | 22087 | 2662 | 40 |
905375 | 905375 | 2021-01-07 | St. Bernard | Louisiana | 22087 | 2626 | 39 |
902130 | 902130 | 2021-01-06 | St. Bernard | Louisiana | 22087 | 2590 | 39 |
898885 | 898885 | 2021-01-05 | St. Bernard | Louisiana | 22087 | 2447 | 39 |
895640 | 895640 | 2021-01-04 | St. Bernard | Louisiana | 22087 | 2431 | 39 |
892393 | 892393 | 2021-01-03 | St. Bernard | Louisiana | 22087 | 2420 | 39 |
889147 | 889147 | 2021-01-02 | St. Bernard | Louisiana | 22087 | 2367 | 39 |
885901 | 885901 | 2021-01-01 | St. Bernard | Louisiana | 22087 | 2367 | 39 |
882656 | 882656 | 2020-12-31 | St. Bernard | Louisiana | 22087 | 2367 | 39 |
879411 | 879411 | 2020-12-30 | St. Bernard | Louisiana | 22087 | 2332 | 39 |
876166 | 876166 | 2020-12-29 | St. Bernard | Louisiana | 22087 | 2263 | 39 |
872921 | 872921 | 2020-12-28 | St. Bernard | Louisiana | 22087 | 2234 | 39 |
869676 | 869676 | 2020-12-27 | St. Bernard | Louisiana | 22087 | 2223 | 39 |
866431 | 866431 | 2020-12-26 | St. Bernard | Louisiana | 22087 | 2204 | 39 |
863186 | 863186 | 2020-12-25 | St. Bernard | Louisiana | 22087 | 2204 | 39 |
859941 | 859941 | 2020-12-24 | St. Bernard | Louisiana | 22087 | 2204 | 39 |
856696 | 856696 | 2020-12-23 | St. Bernard | Louisiana | 22087 | 2184 | 38 |
853451 | 853451 | 2020-12-22 | St. Bernard | Louisiana | 22087 | 2174 | 38 |
850206 | 850206 | 2020-12-21 | St. Bernard | Louisiana | 22087 | 2136 | 38 |
846961 | 846961 | 2020-12-20 | St. Bernard | Louisiana | 22087 | 2121 | 38 |
843715 | 843715 | 2020-12-19 | St. Bernard | Louisiana | 22087 | 2101 | 38 |
840470 | 840470 | 2020-12-18 | St. Bernard | Louisiana | 22087 | 2101 | 38 |
837225 | 837225 | 2020-12-17 | St. Bernard | Louisiana | 22087 | 2085 | 38 |
833979 | 833979 | 2020-12-16 | St. Bernard | Louisiana | 22087 | 2074 | 38 |
830732 | 830732 | 2020-12-15 | St. Bernard | Louisiana | 22087 | 2065 | 37 |
827486 | 827486 | 2020-12-14 | St. Bernard | Louisiana | 22087 | 2045 | 37 |
824239 | 824239 | 2020-12-13 | St. Bernard | Louisiana | 22087 | 2036 | 37 |
820993 | 820993 | 2020-12-12 | St. Bernard | Louisiana | 22087 | 2014 | 36 |
817747 | 817747 | 2020-12-11 | St. Bernard | Louisiana | 22087 | 2014 | 36 |
814501 | 814501 | 2020-12-10 | St. Bernard | Louisiana | 22087 | 1997 | 36 |
811256 | 811256 | 2020-12-09 | St. Bernard | Louisiana | 22087 | 1989 | 35 |
808011 | 808011 | 2020-12-08 | St. Bernard | Louisiana | 22087 | 1976 | 34 |
804766 | 804766 | 2020-12-07 | St. Bernard | Louisiana | 22087 | 1954 | 34 |
801521 | 801521 | 2020-12-06 | St. Bernard | Louisiana | 22087 | 1946 | 34 |
798276 | 798276 | 2020-12-05 | St. Bernard | Louisiana | 22087 | 1921 | 34 |
795031 | 795031 | 2020-12-04 | St. Bernard | Louisiana | 22087 | 1921 | 34 |
791786 | 791786 | 2020-12-03 | St. Bernard | Louisiana | 22087 | 1910 | 34 |
788541 | 788541 | 2020-12-02 | St. Bernard | Louisiana | 22087 | 1885 | 34 |
785297 | 785297 | 2020-12-01 | St. Bernard | Louisiana | 22087 | 1853 | 34 |
782052 | 782052 | 2020-11-30 | St. Bernard | Louisiana | 22087 | 1807 | 34 |
778806 | 778806 | 2020-11-29 | St. Bernard | Louisiana | 22087 | 1809 | 34 |
775561 | 775561 | 2020-11-28 | St. Bernard | Louisiana | 22087 | 1800 | 34 |
772316 | 772316 | 2020-11-27 | St. Bernard | Louisiana | 22087 | 1800 | 34 |
769071 | 769071 | 2020-11-26 | St. Bernard | Louisiana | 22087 | 1778 | 34 |
765825 | 765825 | 2020-11-25 | St. Bernard | Louisiana | 22087 | 1778 | 34 |
762580 | 762580 | 2020-11-24 | St. Bernard | Louisiana | 22087 | 1766 | 34 |
759335 | 759335 | 2020-11-23 | St. Bernard | Louisiana | 22087 | 1745 | 34 |
756088 | 756088 | 2020-11-22 | St. Bernard | Louisiana | 22087 | 1731 | 34 |
752842 | 752842 | 2020-11-21 | St. Bernard | Louisiana | 22087 | 1715 | 34 |
749596 | 749596 | 2020-11-20 | St. Bernard | Louisiana | 22087 | 1715 | 34 |
746350 | 746350 | 2020-11-19 | St. Bernard | Louisiana | 22087 | 1704 | 34 |
743103 | 743103 | 2020-11-18 | St. Bernard | Louisiana | 22087 | 1697 | 34 |
739856 | 739856 | 2020-11-17 | St. Bernard | Louisiana | 22087 | 1688 | 34 |
736612 | 736612 | 2020-11-16 | St. Bernard | Louisiana | 22087 | 1676 | 34 |
733366 | 733366 | 2020-11-15 | St. Bernard | Louisiana | 22087 | 1676 | 34 |
730121 | 730121 | 2020-11-14 | St. Bernard | Louisiana | 22087 | 1657 | 34 |
726878 | 726878 | 2020-11-13 | St. Bernard | Louisiana | 22087 | 1657 | 34 |
723635 | 723635 | 2020-11-12 | St. Bernard | Louisiana | 22087 | 1623 | 32 |
720392 | 720392 | 2020-11-11 | St. Bernard | Louisiana | 22087 | 1609 | 32 |
717149 | 717149 | 2020-11-10 | St. Bernard | Louisiana | 22087 | 1609 | 32 |
713905 | 713905 | 2020-11-09 | St. Bernard | Louisiana | 22087 | 1579 | 32 |
710661 | 710661 | 2020-11-08 | St. Bernard | Louisiana | 22087 | 1578 | 32 |
707417 | 707417 | 2020-11-07 | St. Bernard | Louisiana | 22087 | 1572 | 32 |
704174 | 704174 | 2020-11-06 | St. Bernard | Louisiana | 22087 | 1572 | 32 |
700932 | 700932 | 2020-11-05 | St. Bernard | Louisiana | 22087 | 1570 | 32 |
697688 | 697688 | 2020-11-04 | St. Bernard | Louisiana | 22087 | 1567 | 32 |
694445 | 694445 | 2020-11-03 | St. Bernard | Louisiana | 22087 | 1565 | 32 |
691203 | 691203 | 2020-11-02 | St. Bernard | Louisiana | 22087 | 1565 | 32 |
687958 | 687958 | 2020-11-01 | St. Bernard | Louisiana | 22087 | 1559 | 32 |
684714 | 684714 | 2020-10-31 | St. Bernard | Louisiana | 22087 | 1557 | 32 |
681471 | 681471 | 2020-10-30 | St. Bernard | Louisiana | 22087 | 1557 | 32 |
678227 | 678227 | 2020-10-29 | St. Bernard | Louisiana | 22087 | 1554 | 32 |
674985 | 674985 | 2020-10-28 | St. Bernard | Louisiana | 22087 | 1551 | 32 |
671742 | 671742 | 2020-10-27 | St. Bernard | Louisiana | 22087 | 1548 | 32 |
668500 | 668500 | 2020-10-26 | St. Bernard | Louisiana | 22087 | 1542 | 32 |
665256 | 665256 | 2020-10-25 | St. Bernard | Louisiana | 22087 | 1538 | 32 |
662011 | 662011 | 2020-10-24 | St. Bernard | Louisiana | 22087 | 1532 | 32 |
658767 | 658767 | 2020-10-23 | St. Bernard | Louisiana | 22087 | 1532 | 32 |
655522 | 655522 | 2020-10-22 | St. Bernard | Louisiana | 22087 | 1525 | 32 |
652277 | 652277 | 2020-10-21 | St. Bernard | Louisiana | 22087 | 1524 | 32 |
649032 | 649032 | 2020-10-20 | St. Bernard | Louisiana | 22087 | 1517 | 32 |
645788 | 645788 | 2020-10-19 | St. Bernard | Louisiana | 22087 | 1512 | 32 |
642541 | 642541 | 2020-10-18 | St. Bernard | Louisiana | 22087 | 1516 | 32 |
639294 | 639294 | 2020-10-17 | St. Bernard | Louisiana | 22087 | 1508 | 32 |
636048 | 636048 | 2020-10-16 | St. Bernard | Louisiana | 22087 | 1508 | 32 |
632802 | 632802 | 2020-10-15 | St. Bernard | Louisiana | 22087 | 1501 | 32 |
629558 | 629558 | 2020-10-14 | St. Bernard | Louisiana | 22087 | 1488 | 31 |
626314 | 626314 | 2020-10-13 | St. Bernard | Louisiana | 22087 | 1487 | 31 |
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);