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 2022-04-19 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
2422540 2422540 2022-04-19 Acadia Louisiana 22001 15876 292
2422541 2422541 2022-04-19 Allen Louisiana 22003 7872 137
2422542 2422542 2022-04-19 Ascension Louisiana 22005 34832 292
2422543 2422543 2022-04-19 Assumption Louisiana 22007 5559 70
2422544 2422544 2022-04-19 Avoyelles Louisiana 22009 11577 207
2422545 2422545 2022-04-19 Beauregard Louisiana 22011 9251 142
2422546 2422546 2022-04-19 Bienville Louisiana 22013 3979 110
2422547 2422547 2022-04-19 Bossier Louisiana 22015 37512 492
2422548 2422548 2022-04-19 Caddo Louisiana 22017 67268 1144
2422549 2422549 2022-04-19 Calcasieu Louisiana 22019 54675 704
2422550 2422550 2022-04-19 Caldwell Louisiana 22021 3596 55
2422551 2422551 2022-04-19 Cameron Louisiana 22023 1198 8
2422552 2422552 2022-04-19 Catahoula Louisiana 22025 2694 55
2422553 2422553 2022-04-19 Claiborne Louisiana 22027 3278 76
2422554 2422554 2022-04-19 Concordia Louisiana 22029 5091 89
2422555 2422555 2022-04-19 De Soto Louisiana 22031 7329 135
2422556 2422556 2022-04-19 East Baton Rouge Louisiana 22033 110882 1343
2422557 2422557 2022-04-19 East Carroll Louisiana 22035 2537 38
2422558 2422558 2022-04-19 East Feliciana Louisiana 22037 7303 170
2422559 2422559 2022-04-19 Evangeline Louisiana 22039 8383 158
2422560 2422560 2022-04-19 Franklin Louisiana 22041 7343 178
2422561 2422561 2022-04-19 Grant Louisiana 22043 5855 94
2422562 2422562 2022-04-19 Iberia Louisiana 22045 19060 264
2422563 2422563 2022-04-19 Iberville Louisiana 22047 8987 153
2422564 2422564 2022-04-19 Jackson Louisiana 22049 4395 75
2422565 2422565 2022-04-19 Jefferson Louisiana 22051 113825 1335
2422566 2422566 2022-04-19 Jefferson Davis Louisiana 22053 6935 157
2422567 2422567 2022-04-19 LaSalle Louisiana 22059 4248 59
2422568 2422568 2022-04-19 Lafayette Louisiana 22055 62574 499
2422569 2422569 2022-04-19 Lafourche Louisiana 22057 27761 367
2422570 2422570 2022-04-19 Lincoln Louisiana 22061 12219 145
2422571 2422571 2022-04-19 Livingston Louisiana 22063 37109 463
2422572 2422572 2022-04-19 Madison Louisiana 22065 3256 59
2422573 2422573 2022-04-19 Morehouse Louisiana 22067 6851 134
2422574 2422574 2022-04-19 Natchitoches Louisiana 22069 10114 166
2422575 2422575 2022-04-19 Orleans Louisiana 22071 87992 1108
2422576 2422576 2022-04-19 Ouachita Louisiana 22073 50589 746
2422577 2422577 2022-04-19 Plaquemines Louisiana 22075 6433 45
2422578 2422578 2022-04-19 Pointe Coupee Louisiana 22077 6273 93
2422579 2422579 2022-04-19 Rapides Louisiana 22079 32727 575
2422580 2422580 2022-04-19 Red River Louisiana 22081 2109 53
2422581 2422581 2022-04-19 Richland Louisiana 22083 6718 96
2422582 2422582 2022-04-19 Sabine Louisiana 22085 6332 110
2422583 2422583 2022-04-19 St. Bernard Louisiana 22087 11258 111
2422584 2422584 2022-04-19 St. Charles Louisiana 22089 13819 144
2422585 2422585 2022-04-19 St. Helena Louisiana 22091 1912 23
2422586 2422586 2022-04-19 St. James Louisiana 22093 5776 77
2422587 2422587 2022-04-19 St. John the Baptist Louisiana 22095 10524 184
2422588 2422588 2022-04-19 St. Landry Louisiana 22097 22200 416
2422589 2422589 2022-04-19 St. Martin Louisiana 22099 12949 186
2422590 2422590 2022-04-19 St. Mary Louisiana 22101 12485 262
2422591 2422591 2022-04-19 St. Tammany Louisiana 22103 72207 849
2422592 2422592 2022-04-19 Tangipahoa Louisiana 22105 34703 597
2422593 2422593 2022-04-19 Tensas Louisiana 22107 986 11
2422594 2422594 2022-04-19 Terrebonne Louisiana 22109 30852 415
2422595 2422595 2022-04-19 Union Louisiana 22111 6913 132
2422596 2422596 2022-04-19 Unknown Louisiana   979 0
2422597 2422597 2022-04-19 Vermilion Louisiana 22113 15296 223
2422598 2422598 2022-04-19 Vernon Louisiana 22115 9931 191
2422599 2422599 2022-04-19 Washington Louisiana 22117 12946 248
2422600 2422600 2022-04-19 Webster Louisiana 22119 11098 183
2422601 2422601 2022-04-19 West Baton Rouge Louisiana 22121 7301 90
2422602 2422602 2022-04-19 West Carroll Louisiana 22123 3625 65
2422603 2422603 2022-04-19 West Feliciana Louisiana 22125 2831 46
2422604 2422604 2022-04-19 Winn Louisiana 22127 4433 63

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