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-01-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
921558 921558 2021-01-12 Acadia Louisiana 22001 5464 167
921559 921559 2021-01-12 Allen Louisiana 22003 2588 75
921560 921560 2021-01-12 Ascension Louisiana 22005 8918 124
921561 921561 2021-01-12 Assumption Louisiana 22007 1547 29
921562 921562 2021-01-12 Avoyelles Louisiana 22009 3070 96
921563 921563 2021-01-12 Beauregard Louisiana 22011 2286 59
921564 921564 2021-01-12 Bienville Louisiana 22013 1357 59
921565 921565 2021-01-12 Bossier Louisiana 22015 10260 210
921566 921566 2021-01-12 Caddo Louisiana 22017 20077 558
921567 921567 2021-01-12 Calcasieu Louisiana 22019 15528 295
921568 921568 2021-01-12 Caldwell Louisiana 22021 998 22
921569 921569 2021-01-12 Cameron Louisiana 22023 433 4
921570 921570 2021-01-12 Catahoula Louisiana 22025 957 29
921571 921571 2021-01-12 Claiborne Louisiana 22027 1228 41
921572 921572 2021-01-12 Concordia Louisiana 22029 1577 41
921573 921573 2021-01-12 De Soto Louisiana 22031 1975 54
921574 921574 2021-01-12 East Baton Rouge Louisiana 22033 28306 618
921575 921575 2021-01-12 East Carroll Louisiana 22035 1021 19
921576 921576 2021-01-12 East Feliciana Louisiana 22037 2603 96
921577 921577 2021-01-12 Evangeline Louisiana 22039 2839 60
921578 921578 2021-01-12 Franklin Louisiana 22041 2194 87
921579 921579 2021-01-12 Grant Louisiana 22043 1689 41
921580 921580 2021-01-12 Iberia Louisiana 22045 5426 125
921581 921581 2021-01-12 Iberville Louisiana 22047 2912 75
921582 921582 2021-01-12 Jackson Louisiana 22049 1497 39
921583 921583 2021-01-12 Jefferson Louisiana 22051 35823 709
921584 921584 2021-01-12 Jefferson Davis Louisiana 22053 2487 69
921585 921585 2021-01-12 LaSalle Louisiana 22059 1246 26
921586 921586 2021-01-12 Lafayette Louisiana 22055 18678 206
921587 921587 2021-01-12 Lafourche Louisiana 22057 7087 166
921588 921588 2021-01-12 Lincoln Louisiana 22061 3612 78
921589 921589 2021-01-12 Livingston Louisiana 22063 9872 136
921590 921590 2021-01-12 Madison Louisiana 22065 1436 25
921591 921591 2021-01-12 Morehouse Louisiana 22067 2351 53
921592 921592 2021-01-12 Natchitoches Louisiana 22069 3289 63
921593 921593 2021-01-12 Orleans Louisiana 22071 23531 691
921594 921594 2021-01-12 Ouachita Louisiana 22073 15554 325
921595 921595 2021-01-12 Plaquemines Louisiana 22075 1905 22
921596 921596 2021-01-12 Pointe Coupee Louisiana 22077 2082 59
921597 921597 2021-01-12 Rapides Louisiana 22079 9521 225
921598 921598 2021-01-12 Red River Louisiana 22081 720 29
921599 921599 2021-01-12 Richland Louisiana 22083 1920 40
921600 921600 2021-01-12 Sabine Louisiana 22085 2306 47
921601 921601 2021-01-12 St. Bernard Louisiana 22087 2777 41
921602 921602 2021-01-12 St. Charles Louisiana 22089 4130 78
921603 921603 2021-01-12 St. Helena Louisiana 22091 773 5
921604 921604 2021-01-12 St. James Louisiana 22093 1524 44
921605 921605 2021-01-12 St. John the Baptist Louisiana 22095 2947 121
921606 921606 2021-01-12 St. Landry Louisiana 22097 7213 209
921607 921607 2021-01-12 St. Martin Louisiana 22099 4187 93
921608 921608 2021-01-12 St. Mary Louisiana 22101 3419 104
921609 921609 2021-01-12 St. Tammany Louisiana 22103 17601 376
921610 921610 2021-01-12 Tangipahoa Louisiana 22105 9800 198
921611 921611 2021-01-12 Tensas Louisiana 22107 292 3
921612 921612 2021-01-12 Terrebonne Louisiana 22109 7214 157
921613 921613 2021-01-12 Union Louisiana 22111 2050 69
921614 921614 2021-01-12 Unknown Louisiana   410 0
921615 921615 2021-01-12 Vermilion Louisiana 22113 3968 90
921616 921616 2021-01-12 Vernon Louisiana 22115 2440 79
921617 921617 2021-01-12 Washington Louisiana 22117 3413 97
921618 921618 2021-01-12 Webster Louisiana 22119 3274 71
921619 921619 2021-01-12 West Baton Rouge Louisiana 22121 2026 50
921620 921620 2021-01-12 West Carroll Louisiana 22123 1031 35
921621 921621 2021-01-12 West Feliciana Louisiana 22125 1000 26
921622 921622 2021-01-12 Winn Louisiana 22127 1280 33

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