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

50,902 rows where state = "Louisiana" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips >30

state 1

  • Louisiana · 50,902 ✖
Link rowid date ▲ county state fips cases deaths
2500699 2500699 2022-05-13 Acadia Louisiana 22001 15906 294
2500700 2500700 2022-05-13 Allen Louisiana 22003 7880 141
2500701 2500701 2022-05-13 Ascension Louisiana 22005 35030 293
2500702 2500702 2022-05-13 Assumption Louisiana 22007 5575 70
2500703 2500703 2022-05-13 Avoyelles Louisiana 22009 11600 208
2500704 2500704 2022-05-13 Beauregard Louisiana 22011 9271 143
2500705 2500705 2022-05-13 Bienville Louisiana 22013 3992 110
2500706 2500706 2022-05-13 Bossier Louisiana 22015 37689 494
2500707 2500707 2022-05-13 Caddo Louisiana 22017 67560 1156
2500708 2500708 2022-05-13 Calcasieu Louisiana 22019 54862 706
2500709 2500709 2022-05-13 Caldwell Louisiana 22021 3625 55
2500710 2500710 2022-05-13 Cameron Louisiana 22023 1199 8
2500711 2500711 2022-05-13 Catahoula Louisiana 22025 2700 55
2500712 2500712 2022-05-13 Claiborne Louisiana 22027 3280 78
2500713 2500713 2022-05-13 Concordia Louisiana 22029 5103 89
2500714 2500714 2022-05-13 De Soto Louisiana 22031 7362 135
2500715 2500715 2022-05-13 East Baton Rouge Louisiana 22033 111670 1349
2500716 2500716 2022-05-13 East Carroll Louisiana 22035 2538 38
2500717 2500717 2022-05-13 East Feliciana Louisiana 22037 7324 170
2500718 2500718 2022-05-13 Evangeline Louisiana 22039 8398 159
2500719 2500719 2022-05-13 Franklin Louisiana 22041 7352 178
2500720 2500720 2022-05-13 Grant Louisiana 22043 5861 94
2500721 2500721 2022-05-13 Iberia Louisiana 22045 19149 263
2500722 2500722 2022-05-13 Iberville Louisiana 22047 9023 153
2500723 2500723 2022-05-13 Jackson Louisiana 22049 4409 76
2500724 2500724 2022-05-13 Jefferson Louisiana 22051 115373 1341
2500725 2500725 2022-05-13 Jefferson Davis Louisiana 22053 6942 157
2500726 2500726 2022-05-13 LaSalle Louisiana 22059 4275 61
2500727 2500727 2022-05-13 Lafayette Louisiana 22055 62873 500
2500728 2500728 2022-05-13 Lafourche Louisiana 22057 27889 372
2500729 2500729 2022-05-13 Lincoln Louisiana 22061 12269 144
2500730 2500730 2022-05-13 Livingston Louisiana 22063 37238 466
2500731 2500731 2022-05-13 Madison Louisiana 22065 3264 59
2500732 2500732 2022-05-13 Morehouse Louisiana 22067 6871 134
2500733 2500733 2022-05-13 Natchitoches Louisiana 22069 10162 167
2500734 2500734 2022-05-13 Orleans Louisiana 22071 90328 1109
2500735 2500735 2022-05-13 Ouachita Louisiana 22073 50769 754
2500736 2500736 2022-05-13 Plaquemines Louisiana 22075 6509 45
2500737 2500737 2022-05-13 Pointe Coupee Louisiana 22077 6297 94
2500738 2500738 2022-05-13 Rapides Louisiana 22079 32791 577
2500739 2500739 2022-05-13 Red River Louisiana 22081 2112 53
2500740 2500740 2022-05-13 Richland Louisiana 22083 6732 97
2500741 2500741 2022-05-13 Sabine Louisiana 22085 6343 113
2500742 2500742 2022-05-13 St. Bernard Louisiana 22087 11439 111
2500743 2500743 2022-05-13 St. Charles Louisiana 22089 13920 145
2500744 2500744 2022-05-13 St. Helena Louisiana 22091 1920 23
2500745 2500745 2022-05-13 St. James Louisiana 22093 5805 77
2500746 2500746 2022-05-13 St. John the Baptist Louisiana 22095 10628 184
2500747 2500747 2022-05-13 St. Landry Louisiana 22097 22279 416
2500748 2500748 2022-05-13 St. Martin Louisiana 22099 12985 188
2500749 2500749 2022-05-13 St. Mary Louisiana 22101 12526 262
2500750 2500750 2022-05-13 St. Tammany Louisiana 22103 73066 851
2500751 2500751 2022-05-13 Tangipahoa Louisiana 22105 34885 599
2500752 2500752 2022-05-13 Tensas Louisiana 22107 988 11
2500753 2500753 2022-05-13 Terrebonne Louisiana 22109 31012 419
2500754 2500754 2022-05-13 Union Louisiana 22111 6928 135
2500755 2500755 2022-05-13 Unknown Louisiana   984 0
2500756 2500756 2022-05-13 Vermilion Louisiana 22113 15334 224
2500757 2500757 2022-05-13 Vernon Louisiana 22115 9939 191
2500758 2500758 2022-05-13 Washington Louisiana 22117 12994 249
2500759 2500759 2022-05-13 Webster Louisiana 22119 11145 186
2500760 2500760 2022-05-13 West Baton Rouge Louisiana 22121 7335 90
2500761 2500761 2022-05-13 West Carroll Louisiana 22123 3629 66
2500762 2500762 2022-05-13 West Feliciana Louisiana 22125 2835 46
2500763 2500763 2022-05-13 Winn Louisiana 22127 4452 64
2497441 2497441 2022-05-12 Acadia Louisiana 22001 15905 294
2497442 2497442 2022-05-12 Allen Louisiana 22003 7878 140
2497443 2497443 2022-05-12 Ascension Louisiana 22005 35010 293
2497444 2497444 2022-05-12 Assumption Louisiana 22007 5574 70
2497445 2497445 2022-05-12 Avoyelles Louisiana 22009 11600 208
2497446 2497446 2022-05-12 Beauregard Louisiana 22011 9269 143
2497447 2497447 2022-05-12 Bienville Louisiana 22013 3992 110
2497448 2497448 2022-05-12 Bossier Louisiana 22015 37678 493
2497449 2497449 2022-05-12 Caddo Louisiana 22017 67541 1155
2497450 2497450 2022-05-12 Calcasieu Louisiana 22019 54851 706
2497451 2497451 2022-05-12 Caldwell Louisiana 22021 3624 55
2497452 2497452 2022-05-12 Cameron Louisiana 22023 1199 8
2497453 2497453 2022-05-12 Catahoula Louisiana 22025 2698 55
2497454 2497454 2022-05-12 Claiborne Louisiana 22027 3280 78
2497455 2497455 2022-05-12 Concordia Louisiana 22029 5099 89
2497456 2497456 2022-05-12 De Soto Louisiana 22031 7361 135
2497457 2497457 2022-05-12 East Baton Rouge Louisiana 22033 111601 1349
2497458 2497458 2022-05-12 East Carroll Louisiana 22035 2538 38
2497459 2497459 2022-05-12 East Feliciana Louisiana 22037 7324 170
2497460 2497460 2022-05-12 Evangeline Louisiana 22039 8398 159
2497461 2497461 2022-05-12 Franklin Louisiana 22041 7349 178
2497462 2497462 2022-05-12 Grant Louisiana 22043 5860 94
2497463 2497463 2022-05-12 Iberia Louisiana 22045 19142 263
2497464 2497464 2022-05-12 Iberville Louisiana 22047 9021 153
2497465 2497465 2022-05-12 Jackson Louisiana 22049 4409 76
2497466 2497466 2022-05-12 Jefferson Louisiana 22051 115247 1341
2497467 2497467 2022-05-12 Jefferson Davis Louisiana 22053 6942 157
2497468 2497468 2022-05-12 LaSalle Louisiana 22059 4273 61
2497469 2497469 2022-05-12 Lafayette Louisiana 22055 62829 500
2497470 2497470 2022-05-12 Lafourche Louisiana 22057 27873 372
2497471 2497471 2022-05-12 Lincoln Louisiana 22061 12266 144
2497472 2497472 2022-05-12 Livingston Louisiana 22063 37226 466
2497473 2497473 2022-05-12 Madison Louisiana 22065 3264 59
2497474 2497474 2022-05-12 Morehouse Louisiana 22067 6871 134
2497475 2497475 2022-05-12 Natchitoches Louisiana 22069 10161 167

Next page

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