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-08-31 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
1671535 1671535 2021-08-31 Acadia Louisiana 22001 9346 227
1671536 1671536 2021-08-31 Allen Louisiana 22003 4145 95
1671537 1671537 2021-08-31 Ascension Louisiana 22005 19952 203
1671538 1671538 2021-08-31 Assumption Louisiana 22007 3336 43
1671539 1671539 2021-08-31 Avoyelles Louisiana 22009 6247 140
1671540 1671540 2021-08-31 Beauregard Louisiana 22011 4860 88
1671541 1671541 2021-08-31 Bienville Louisiana 22013 2154 85
1671542 1671542 2021-08-31 Bossier Louisiana 22015 19020 340
1671543 1671543 2021-08-31 Caddo Louisiana 22017 35084 822
1671544 1671544 2021-08-31 Calcasieu Louisiana 22019 30036 510
1671545 1671545 2021-08-31 Caldwell Louisiana 22021 1523 32
1671546 1671546 2021-08-31 Cameron Louisiana 22023 782 8
1671547 1671547 2021-08-31 Catahoula Louisiana 22025 1567 41
1671548 1671548 2021-08-31 Claiborne Louisiana 22027 1790 57
1671549 1671549 2021-08-31 Concordia Louisiana 22029 2792 66
1671550 1671550 2021-08-31 De Soto Louisiana 22031 4147 96
1671551 1671551 2021-08-31 East Baton Rouge Louisiana 22033 58416 1021
1671552 1671552 2021-08-31 East Carroll Louisiana 22035 1399 28
1671553 1671553 2021-08-31 East Feliciana Louisiana 22037 4250 129
1671554 1671554 2021-08-31 Evangeline Louisiana 22039 5044 109
1671555 1671555 2021-08-31 Franklin Louisiana 22041 3714 119
1671556 1671556 2021-08-31 Grant Louisiana 22043 3316 65
1671557 1671557 2021-08-31 Iberia Louisiana 22045 11197 193
1671558 1671558 2021-08-31 Iberville Louisiana 22047 5446 115
1671559 1671559 2021-08-31 Jackson Louisiana 22049 2459 58
1671560 1671560 2021-08-31 Jefferson Louisiana 22051 65340 1018
1671561 1671561 2021-08-31 Jefferson Davis Louisiana 22053 4134 108
1671562 1671562 2021-08-31 LaSalle Louisiana 22059 2329 41
1671563 1671563 2021-08-31 Lafayette Louisiana 22055 34858 352
1671564 1671564 2021-08-31 Lafourche Louisiana 22057 16391 251
1671565 1671565 2021-08-31 Lincoln Louisiana 22061 5984 100
1671566 1671566 2021-08-31 Livingston Louisiana 22063 22291 291
1671567 1671567 2021-08-31 Madison Louisiana 22065 1903 48
1671568 1671568 2021-08-31 Morehouse Louisiana 22067 3960 92
1671569 1671569 2021-08-31 Natchitoches Louisiana 22069 5368 108
1671570 1671570 2021-08-31 Orleans Louisiana 22071 43361 890
1671571 1671571 2021-08-31 Ouachita Louisiana 22073 26682 502
1671572 1671572 2021-08-31 Plaquemines Louisiana 22075 3558 33
1671573 1671573 2021-08-31 Pointe Coupee Louisiana 22077 3522 79
1671574 1671574 2021-08-31 Rapides Louisiana 22079 18539 384
1671575 1671575 2021-08-31 Red River Louisiana 22081 1158 42
1671576 1671576 2021-08-31 Richland Louisiana 22083 3559 67
1671577 1671577 2021-08-31 Sabine Louisiana 22085 3770 67
1671578 1671578 2021-08-31 St. Bernard Louisiana 22087 6351 77
1671579 1671579 2021-08-31 St. Charles Louisiana 22089 8289 115
1671580 1671580 2021-08-31 St. Helena Louisiana 22091 1226 12
1671581 1671581 2021-08-31 St. James Louisiana 22093 3041 60
1671582 1671582 2021-08-31 St. John the Baptist Louisiana 22095 5816 153
1671583 1671583 2021-08-31 St. Landry Louisiana 22097 12418 296
1671584 1671584 2021-08-31 St. Martin Louisiana 22099 7617 135
1671585 1671585 2021-08-31 St. Mary Louisiana 22101 7782 187
1671586 1671586 2021-08-31 St. Tammany Louisiana 22103 39777 604
1671587 1671587 2021-08-31 Tangipahoa Louisiana 22105 20978 418
1671588 1671588 2021-08-31 Tensas Louisiana 22107 434 8
1671589 1671589 2021-08-31 Terrebonne Louisiana 22109 17784 267
1671590 1671590 2021-08-31 Union Louisiana 22111 3367 90
1671591 1671591 2021-08-31 Unknown Louisiana   470 0
1671592 1671592 2021-08-31 Vermilion Louisiana 22113 8883 148
1671593 1671593 2021-08-31 Vernon Louisiana 22115 4775 129
1671594 1671594 2021-08-31 Washington Louisiana 22117 7069 173
1671595 1671595 2021-08-31 Webster Louisiana 22119 5648 123
1671596 1671596 2021-08-31 West Baton Rouge Louisiana 22121 4130 68
1671597 1671597 2021-08-31 West Carroll Louisiana 22123 1581 44
1671598 1671598 2021-08-31 West Feliciana Louisiana 22125 1409 37
1671599 1671599 2021-08-31 Winn Louisiana 22127 2222 52

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