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-11-12 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
723592 723592 2020-11-12 Acadia Louisiana 22001 3432 108
723593 723593 2020-11-12 Allen Louisiana 22003 1907 64
723594 723594 2020-11-12 Ascension Louisiana 22005 4600 100
723595 723595 2020-11-12 Assumption Louisiana 22007 852 25
723596 723596 2020-11-12 Avoyelles Louisiana 22009 1823 65
723597 723597 2020-11-12 Beauregard Louisiana 22011 1150 43
723598 723598 2020-11-12 Bienville Louisiana 22013 662 35
723599 723599 2020-11-12 Bossier Louisiana 22015 4817 127
723600 723600 2020-11-12 Caddo Louisiana 22017 11136 417
723601 723601 2020-11-12 Calcasieu Louisiana 22019 8806 233
723602 723602 2020-11-12 Caldwell Louisiana 22021 423 4
723603 723603 2020-11-12 Cameron Louisiana 22023 255 3
723604 723604 2020-11-12 Catahoula Louisiana 22025 481 15
723605 723605 2020-11-12 Claiborne Louisiana 22027 637 27
723606 723606 2020-11-12 Concordia Louisiana 22029 682 17
723607 723607 2020-11-12 De Soto Louisiana 22031 1094 35
723608 723608 2020-11-12 East Baton Rouge Louisiana 22033 16870 463
723609 723609 2020-11-12 East Carroll Louisiana 22035 614 6
723610 723610 2020-11-12 East Feliciana Louisiana 22037 1816 83
723611 723611 2020-11-12 Evangeline Louisiana 22039 1510 40
723612 723612 2020-11-12 Franklin Louisiana 22041 1442 53
723613 723613 2020-11-12 Grant Louisiana 22043 566 31
723614 723614 2020-11-12 Iberia Louisiana 22045 3166 99
723615 723615 2020-11-12 Iberville Louisiana 22047 1580 62
723616 723616 2020-11-12 Jackson Louisiana 22049 936 24
723617 723617 2020-11-12 Jefferson Louisiana 22051 19465 593
723618 723618 2020-11-12 Jefferson Davis Louisiana 22053 1436 45
723619 723619 2020-11-12 LaSalle Louisiana 22059 565 12
723620 723620 2020-11-12 Lafayette Louisiana 22055 9878 141
723621 723621 2020-11-12 Lafourche Louisiana 22057 4015 131
723622 723622 2020-11-12 Lincoln Louisiana 22061 1817 53
723623 723623 2020-11-12 Livingston Louisiana 22063 4463 83
723624 723624 2020-11-12 Madison Louisiana 22065 922 11
723625 723625 2020-11-12 Morehouse Louisiana 22067 964 29
723626 723626 2020-11-12 Natchitoches Louisiana 22069 1660 35
723627 723627 2020-11-12 Orleans Louisiana 22071 14124 605
723628 723628 2020-11-12 Ouachita Louisiana 22073 7834 174
723629 723629 2020-11-12 Plaquemines Louisiana 22075 932 19
723630 723630 2020-11-12 Pointe Coupee Louisiana 22077 1181 44
723631 723631 2020-11-12 Rapides Louisiana 22079 5001 169
723632 723632 2020-11-12 Red River Louisiana 22081 516 25
723633 723633 2020-11-12 Richland Louisiana 22083 981 21
723634 723634 2020-11-12 Sabine Louisiana 22085 1105 16
723635 723635 2020-11-12 St. Bernard Louisiana 22087 1623 32
723636 723636 2020-11-12 St. Charles Louisiana 22089 2011 65
723637 723637 2020-11-12 St. Helena Louisiana 22091 448 4
723638 723638 2020-11-12 St. James Louisiana 22093 864 40
723639 723639 2020-11-12 St. John the Baptist Louisiana 22095 1738 108
723640 723640 2020-11-12 St. Landry Louisiana 22097 3925 140
723641 723641 2020-11-12 St. Martin Louisiana 22099 2343 65
723642 723642 2020-11-12 St. Mary Louisiana 22101 2092 87
723643 723643 2020-11-12 St. Tammany Louisiana 22103 8116 277
723644 723644 2020-11-12 Tangipahoa Louisiana 22105 5197 130
723645 723645 2020-11-12 Tensas Louisiana 22107 192 3
723646 723646 2020-11-12 Terrebonne Louisiana 22109 4001 126
723647 723647 2020-11-12 Union Louisiana 22111 1190 54
723648 723648 2020-11-12 Unknown Louisiana   6957 234
723649 723649 2020-11-12 Vermilion Louisiana 22113 2201 70
723650 723650 2020-11-12 Vernon Louisiana 22115 1173 57
723651 723651 2020-11-12 Washington Louisiana 22117 1800 73
723652 723652 2020-11-12 Webster Louisiana 22119 1588 45
723653 723653 2020-11-12 West Baton Rouge Louisiana 22121 1037 42
723654 723654 2020-11-12 West Carroll Louisiana 22123 406 14
723655 723655 2020-11-12 West Feliciana Louisiana 22125 767 25
723656 723656 2020-11-12 Winn Louisiana 22127 746 21

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