ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

65 rows where "date" is on date 2021-02-18 and state = "Louisiana" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

state 1

  • Louisiana · 65 ✖
Link rowid date ▲ county state fips cases deaths
1041643 1041643 2021-02-18 Acadia Louisiana 22001 5993 181
1041644 1041644 2021-02-18 Allen Louisiana 22003 2928 84
1041645 1041645 2021-02-18 Ascension Louisiana 22005 10783 144
1041646 1041646 2021-02-18 Assumption Louisiana 22007 2067 33
1041647 1041647 2021-02-18 Avoyelles Louisiana 22009 3844 117
1041648 1041648 2021-02-18 Beauregard Louisiana 22011 2738 65
1041649 1041649 2021-02-18 Bienville Louisiana 22013 1571 69
1041650 1041650 2021-02-18 Bossier Louisiana 22015 12842 256
1041651 1041651 2021-02-18 Caddo Louisiana 22017 24407 663
1041652 1041652 2021-02-18 Calcasieu Louisiana 22019 18748 346
1041653 1041653 2021-02-18 Caldwell Louisiana 22021 1068 25
1041654 1041654 2021-02-18 Cameron Louisiana 22023 528 5
1041655 1041655 2021-02-18 Catahoula Louisiana 22025 1037 33
1041656 1041656 2021-02-18 Claiborne Louisiana 22027 1392 49
1041657 1041657 2021-02-18 Concordia Louisiana 22029 1745 55
1041658 1041658 2021-02-18 De Soto Louisiana 22031 2609 70
1041659 1041659 2021-02-18 East Baton Rouge Louisiana 22033 34795 717
1041660 1041660 2021-02-18 East Carroll Louisiana 22035 1096 22
1041661 1041661 2021-02-18 East Feliciana Louisiana 22037 2931 104
1041662 1041662 2021-02-18 Evangeline Louisiana 22039 3227 77
1041663 1041663 2021-02-18 Franklin Louisiana 22041 2410 100
1041664 1041664 2021-02-18 Grant Louisiana 22043 1980 51
1041665 1041665 2021-02-18 Iberia Louisiana 22045 6353 142
1041666 1041666 2021-02-18 Iberville Louisiana 22047 3382 91
1041667 1041667 2021-02-18 Jackson Louisiana 22049 1746 45
1041668 1041668 2021-02-18 Jefferson Louisiana 22051 43172 830
1041669 1041669 2021-02-18 Jefferson Davis Louisiana 22053 2824 83
1041670 1041670 2021-02-18 LaSalle Louisiana 22059 1401 33
1041671 1041671 2021-02-18 Lafayette Louisiana 22055 21344 253
1041672 1041672 2021-02-18 Lafourche Louisiana 22057 8915 193
1041673 1041673 2021-02-18 Lincoln Louisiana 22061 4201 88
1041674 1041674 2021-02-18 Livingston Louisiana 22063 12010 172
1041675 1041675 2021-02-18 Madison Louisiana 22065 1544 31
1041676 1041676 2021-02-18 Morehouse Louisiana 22067 2678 67
1041677 1041677 2021-02-18 Natchitoches Louisiana 22069 3831 77
1041678 1041678 2021-02-18 Orleans Louisiana 22071 27875 750
1041679 1041679 2021-02-18 Ouachita Louisiana 22073 17590 404
1041680 1041680 2021-02-18 Plaquemines Louisiana 22075 2241 23
1041681 1041681 2021-02-18 Pointe Coupee Louisiana 22077 2324 69
1041682 1041682 2021-02-18 Rapides Louisiana 22079 11131 287
1041683 1041683 2021-02-18 Red River Louisiana 22081 854 35
1041684 1041684 2021-02-18 Richland Louisiana 22083 2315 49
1041685 1041685 2021-02-18 Sabine Louisiana 22085 2739 52
1041686 1041686 2021-02-18 St. Bernard Louisiana 22087 3564 46
1041687 1041687 2021-02-18 St. Charles Louisiana 22089 5011 88
1041688 1041688 2021-02-18 St. Helena Louisiana 22091 867 8
1041689 1041689 2021-02-18 St. James Louisiana 22093 1821 48
1041690 1041690 2021-02-18 St. John the Baptist Louisiana 22095 3466 131
1041691 1041691 2021-02-18 St. Landry Louisiana 22097 8172 241
1041692 1041692 2021-02-18 St. Martin Louisiana 22099 4786 110
1041693 1041693 2021-02-18 St. Mary Louisiana 22101 4017 118
1041694 1041694 2021-02-18 St. Tammany Louisiana 22103 23182 475
1041695 1041695 2021-02-18 Tangipahoa Louisiana 22105 11811 257
1041696 1041696 2021-02-18 Tensas Louisiana 22107 355 6
1041697 1041697 2021-02-18 Terrebonne Louisiana 22109 9268 192
1041698 1041698 2021-02-18 Union Louisiana 22111 2280 75
1041699 1041699 2021-02-18 Unknown Louisiana   416 0
1041700 1041700 2021-02-18 Vermilion Louisiana 22113 4768 105
1041701 1041701 2021-02-18 Vernon Louisiana 22115 2826 95
1041702 1041702 2021-02-18 Washington Louisiana 22117 4007 117
1041703 1041703 2021-02-18 Webster Louisiana 22119 3879 92
1041704 1041704 2021-02-18 West Baton Rouge Louisiana 22121 2449 53
1041705 1041705 2021-02-18 West Carroll Louisiana 22123 1154 39
1041706 1041706 2021-02-18 West Feliciana Louisiana 22125 1099 31
1041707 1041707 2021-02-18 Winn Louisiana 22127 1439 39

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);