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 2020-12-27 and state = "Louisiana" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Louisiana · 65 ✖
Link rowid date ▲ county state fips cases deaths
869633 869633 2020-12-27 Acadia Louisiana 22001 4874 143
869634 869634 2020-12-27 Allen Louisiana 22003 2396 71
869635 869635 2020-12-27 Ascension Louisiana 22005 7499 115
869636 869636 2020-12-27 Assumption Louisiana 22007 1295 26
869637 869637 2020-12-27 Avoyelles Louisiana 22009 2553 85
869638 869638 2020-12-27 Beauregard Louisiana 22011 1808 54
869639 869639 2020-12-27 Bienville Louisiana 22013 1151 46
869640 869640 2020-12-27 Bossier Louisiana 22015 8478 190
869641 869641 2020-12-27 Caddo Louisiana 22017 17029 511
869642 869642 2020-12-27 Calcasieu Louisiana 22019 13092 280
869643 869643 2020-12-27 Caldwell Louisiana 22021 865 19
869644 869644 2020-12-27 Cameron Louisiana 22023 367 4
869645 869645 2020-12-27 Catahoula Louisiana 22025 788 21
869646 869646 2020-12-27 Claiborne Louisiana 22027 978 34
869647 869647 2020-12-27 Concordia Louisiana 22029 1361 35
869648 869648 2020-12-27 De Soto Louisiana 22031 1686 49
869649 869649 2020-12-27 East Baton Rouge Louisiana 22033 24657 564
869650 869650 2020-12-27 East Carroll Louisiana 22035 931 15
869651 869651 2020-12-27 East Feliciana Louisiana 22037 2403 91
869652 869652 2020-12-27 Evangeline Louisiana 22039 2510 56
869653 869653 2020-12-27 Franklin Louisiana 22041 1969 77
869654 869654 2020-12-27 Grant Louisiana 22043 1340 38
869655 869655 2020-12-27 Iberia Louisiana 22045 4606 120
869656 869656 2020-12-27 Iberville Louisiana 22047 2590 71
869657 869657 2020-12-27 Jackson Louisiana 22049 1331 37
869658 869658 2020-12-27 Jefferson Louisiana 22051 30031 666
869659 869659 2020-12-27 Jefferson Davis Louisiana 22053 2176 62
869660 869660 2020-12-27 LaSalle Louisiana 22059 1119 23
869661 869661 2020-12-27 Lafayette Louisiana 22055 15990 184
869662 869662 2020-12-27 Lafourche Louisiana 22057 5928 161
869663 869663 2020-12-27 Lincoln Louisiana 22061 3233 69
869664 869664 2020-12-27 Livingston Louisiana 22063 8328 117
869665 869665 2020-12-27 Madison Louisiana 22065 1257 17
869666 869666 2020-12-27 Morehouse Louisiana 22067 1992 43
869667 869667 2020-12-27 Natchitoches Louisiana 22069 2670 57
869668 869668 2020-12-27 Orleans Louisiana 22071 19847 673
869669 869669 2020-12-27 Ouachita Louisiana 22073 13231 267
869670 869670 2020-12-27 Plaquemines Louisiana 22075 1610 20
869671 869671 2020-12-27 Pointe Coupee Louisiana 22077 1814 56
869672 869672 2020-12-27 Rapides Louisiana 22079 7737 209
869673 869673 2020-12-27 Red River Louisiana 22081 645 29
869674 869674 2020-12-27 Richland Louisiana 22083 1671 38
869675 869675 2020-12-27 Sabine Louisiana 22085 1973 41
869676 869676 2020-12-27 St. Bernard Louisiana 22087 2223 39
869677 869677 2020-12-27 St. Charles Louisiana 22089 3486 73
869678 869678 2020-12-27 St. Helena Louisiana 22091 666 4
869679 869679 2020-12-27 St. James Louisiana 22093 1263 43
869680 869680 2020-12-27 St. John the Baptist Louisiana 22095 2533 118
869681 869681 2020-12-27 St. Landry Louisiana 22097 6325 197
869682 869682 2020-12-27 St. Martin Louisiana 22099 3605 81
869683 869683 2020-12-27 St. Mary Louisiana 22101 2905 101
869684 869684 2020-12-27 St. Tammany Louisiana 22103 14401 326
869685 869685 2020-12-27 Tangipahoa Louisiana 22105 8660 170
869686 869686 2020-12-27 Tensas Louisiana 22107 264 3
869687 869687 2020-12-27 Terrebonne Louisiana 22109 5819 147
869688 869688 2020-12-27 Union Louisiana 22111 1731 63
869689 869689 2020-12-27 Unknown Louisiana   411 0
869690 869690 2020-12-27 Vermilion Louisiana 22113 3322 85
869691 869691 2020-12-27 Vernon Louisiana 22115 1967 72
869692 869692 2020-12-27 Washington Louisiana 22117 3030 86
869693 869693 2020-12-27 Webster Louisiana 22119 2612 67
869694 869694 2020-12-27 West Baton Rouge Louisiana 22121 1741 47
869695 869695 2020-12-27 West Carroll Louisiana 22123 853 31
869696 869696 2020-12-27 West Feliciana Louisiana 22125 906 25
869697 869697 2020-12-27 Winn Louisiana 22127 1190 29

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