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

22,758 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

state

  • Louisiana · 22,758 ✖
Link rowid date ▲ county state fips cases deaths
1093574 1093574 2021-03-06 Acadia Louisiana 22001 6126 185
1093575 1093575 2021-03-06 Allen Louisiana 22003 3007 87
1093576 1093576 2021-03-06 Ascension Louisiana 22005 11048 152
1093577 1093577 2021-03-06 Assumption Louisiana 22007 2097 34
1093578 1093578 2021-03-06 Avoyelles Louisiana 22009 3942 118
1093579 1093579 2021-03-06 Beauregard Louisiana 22011 2863 65
1093580 1093580 2021-03-06 Bienville Louisiana 22013 1618 75
1093581 1093581 2021-03-06 Bossier Louisiana 22015 13061 264
1093582 1093582 2021-03-06 Caddo Louisiana 22017 24819 682
1093583 1093583 2021-03-06 Calcasieu Louisiana 22019 19723 362
1093584 1093584 2021-03-06 Caldwell Louisiana 22021 1083 25
1093585 1093585 2021-03-06 Cameron Louisiana 22023 555 6
1093586 1093586 2021-03-06 Catahoula Louisiana 22025 1057 35
1093587 1093587 2021-03-06 Claiborne Louisiana 22027 1402 49
1093588 1093588 2021-03-06 Concordia Louisiana 22029 1788 56
1093589 1093589 2021-03-06 De Soto Louisiana 22031 2655 74
1093590 1093590 2021-03-06 East Baton Rouge Louisiana 22033 35949 744
1093591 1093591 2021-03-06 East Carroll Louisiana 22035 1114 23
1093592 1093592 2021-03-06 East Feliciana Louisiana 22037 3023 106
1093593 1093593 2021-03-06 Evangeline Louisiana 22039 3328 79
1093594 1093594 2021-03-06 Franklin Louisiana 22041 2448 104
1093595 1093595 2021-03-06 Grant Louisiana 22043 2017 52
1093596 1093596 2021-03-06 Iberia Louisiana 22045 6502 147
1093597 1093597 2021-03-06 Iberville Louisiana 22047 3476 91
1093598 1093598 2021-03-06 Jackson Louisiana 22049 1792 47
1093599 1093599 2021-03-06 Jefferson Louisiana 22051 44184 857
1093600 1093600 2021-03-06 Jefferson Davis Louisiana 22053 2897 86
1093601 1093601 2021-03-06 LaSalle Louisiana 22059 1427 34
1093602 1093602 2021-03-06 Lafayette Louisiana 22055 21700 262
1093603 1093603 2021-03-06 Lafourche Louisiana 22057 9203 198
1093604 1093604 2021-03-06 Lincoln Louisiana 22061 4238 89
1093605 1093605 2021-03-06 Livingston Louisiana 22063 12455 184
1093606 1093606 2021-03-06 Madison Louisiana 22065 1555 34
1093607 1093607 2021-03-06 Morehouse Louisiana 22067 2721 68
1093608 1093608 2021-03-06 Natchitoches Louisiana 22069 3876 81
1093609 1093609 2021-03-06 Orleans Louisiana 22071 28655 766
1093610 1093610 2021-03-06 Ouachita Louisiana 22073 17719 422
1093611 1093611 2021-03-06 Plaquemines Louisiana 22075 2371 25
1093612 1093612 2021-03-06 Pointe Coupee Louisiana 22077 2373 70
1093613 1093613 2021-03-06 Rapides Louisiana 22079 11313 295
1093614 1093614 2021-03-06 Red River Louisiana 22081 859 36
1093615 1093615 2021-03-06 Richland Louisiana 22083 2360 49
1093616 1093616 2021-03-06 Sabine Louisiana 22085 2789 55
1093617 1093617 2021-03-06 St. Bernard Louisiana 22087 3783 46
1093618 1093618 2021-03-06 St. Charles Louisiana 22089 5150 88
1093619 1093619 2021-03-06 St. Helena Louisiana 22091 885 8
1093620 1093620 2021-03-06 St. James Louisiana 22093 1858 49
1093621 1093621 2021-03-06 St. John the Baptist Louisiana 22095 3551 133
1093622 1093622 2021-03-06 St. Landry Louisiana 22097 8346 245
1093623 1093623 2021-03-06 St. Martin Louisiana 22099 4873 112
1093624 1093624 2021-03-06 St. Mary Louisiana 22101 4185 122
1093625 1093625 2021-03-06 St. Tammany Louisiana 22103 24324 496
1093626 1093626 2021-03-06 Tangipahoa Louisiana 22105 12072 273
1093627 1093627 2021-03-06 Tensas Louisiana 22107 356 6
1093628 1093628 2021-03-06 Terrebonne Louisiana 22109 9616 204
1093629 1093629 2021-03-06 Union Louisiana 22111 2304 76
1093630 1093630 2021-03-06 Unknown Louisiana   422 0
1093631 1093631 2021-03-06 Vermilion Louisiana 22113 4903 107
1093632 1093632 2021-03-06 Vernon Louisiana 22115 2895 96
1093633 1093633 2021-03-06 Washington Louisiana 22117 4124 122
1093634 1093634 2021-03-06 Webster Louisiana 22119 3940 97
1093635 1093635 2021-03-06 West Baton Rouge Louisiana 22121 2518 54
1093636 1093636 2021-03-06 West Carroll Louisiana 22123 1161 39
1093637 1093637 2021-03-06 West Feliciana Louisiana 22125 1119 31
1093638 1093638 2021-03-06 Winn Louisiana 22127 1472 39
1090328 1090328 2021-03-05 Acadia Louisiana 22001 6126 185
1090329 1090329 2021-03-05 Allen Louisiana 22003 3007 87
1090330 1090330 2021-03-05 Ascension Louisiana 22005 11048 152
1090331 1090331 2021-03-05 Assumption Louisiana 22007 2097 34
1090332 1090332 2021-03-05 Avoyelles Louisiana 22009 3942 118
1090333 1090333 2021-03-05 Beauregard Louisiana 22011 2863 65
1090334 1090334 2021-03-05 Bienville Louisiana 22013 1618 75
1090335 1090335 2021-03-05 Bossier Louisiana 22015 13061 264
1090336 1090336 2021-03-05 Caddo Louisiana 22017 24819 682
1090337 1090337 2021-03-05 Calcasieu Louisiana 22019 19723 362
1090338 1090338 2021-03-05 Caldwell Louisiana 22021 1083 25
1090339 1090339 2021-03-05 Cameron Louisiana 22023 555 6
1090340 1090340 2021-03-05 Catahoula Louisiana 22025 1057 35
1090341 1090341 2021-03-05 Claiborne Louisiana 22027 1402 49
1090342 1090342 2021-03-05 Concordia Louisiana 22029 1788 56
1090343 1090343 2021-03-05 De Soto Louisiana 22031 2655 74
1090344 1090344 2021-03-05 East Baton Rouge Louisiana 22033 35949 744
1090345 1090345 2021-03-05 East Carroll Louisiana 22035 1114 23
1090346 1090346 2021-03-05 East Feliciana Louisiana 22037 3023 106
1090347 1090347 2021-03-05 Evangeline Louisiana 22039 3328 79
1090348 1090348 2021-03-05 Franklin Louisiana 22041 2448 104
1090349 1090349 2021-03-05 Grant Louisiana 22043 2017 52
1090350 1090350 2021-03-05 Iberia Louisiana 22045 6502 147
1090351 1090351 2021-03-05 Iberville Louisiana 22047 3476 91
1090352 1090352 2021-03-05 Jackson Louisiana 22049 1792 47
1090353 1090353 2021-03-05 Jefferson Louisiana 22051 44184 857
1090354 1090354 2021-03-05 Jefferson Davis Louisiana 22053 2897 86
1090355 1090355 2021-03-05 LaSalle Louisiana 22059 1427 34
1090356 1090356 2021-03-05 Lafayette Louisiana 22055 21700 262
1090357 1090357 2021-03-05 Lafourche Louisiana 22057 9203 198
1090358 1090358 2021-03-05 Lincoln Louisiana 22061 4238 89
1090359 1090359 2021-03-05 Livingston Louisiana 22063 12455 184
1090360 1090360 2021-03-05 Madison Louisiana 22065 1555 34
1090361 1090361 2021-03-05 Morehouse Louisiana 22067 2721 68
1090362 1090362 2021-03-05 Natchitoches Louisiana 22069 3876 81

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