johns_hopkins_csse_daily_reports

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 source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

38,211 rows where province_or_state = "Louisiana" sorted by day descending

✎ View and edit SQL

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

Suggested facets: day (date), last_update (date)

province_or_state

  • Louisiana · 38,211 ✖

country_or_region

  • US 38,211
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
33768 33768 2021-10-23 US Louisiana Acadia 22001 10426 249 0   30.295064899999996 -92.41419698 2021-10-24 04:21:22 Acadia, Louisiana, US
33769 33769 2021-10-23 US Louisiana Allen 22003 4705 113 0   30.65385745 -92.82442028 2021-10-24 04:21:22 Allen, Louisiana, US
33770 33770 2021-10-23 US Louisiana Ascension 22005 21717 239 0   30.20406249 -90.91328409999998 2021-10-24 04:21:22 Ascension, Louisiana, US
33771 33771 2021-10-23 US Louisiana Assumption 22007 3643 56 0   29.89946234 -91.06461642 2021-10-24 04:21:22 Assumption, Louisiana, US
33772 33772 2021-10-23 US Louisiana Avoyelles 22009 7072 177 0   31.07796211 -92.00079449 2021-10-24 04:21:22 Avoyelles, Louisiana, US
33773 33773 2021-10-23 US Louisiana Beauregard 22011 6063 122 0   30.64836518 -93.34173616 2021-10-24 04:21:22 Beauregard, Louisiana, US
33774 33774 2021-10-23 US Louisiana Bienville 22013 2484 96 0   32.34569994 -93.05398492 2021-10-24 04:21:22 Bienville, Louisiana, US
33775 33775 2021-10-23 US Louisiana Bossier 22015 21633 400 0   32.67932307 -93.60460152 2021-10-24 04:21:22 Bossier, Louisiana, US
33776 33776 2021-10-23 US Louisiana Caddo 22017 39260 956 0   32.57991587 -93.88375652 2021-10-24 04:21:22 Caddo, Louisiana, US
33777 33777 2021-10-23 US Louisiana Calcasieu 22019 34331 610 0   30.22931235 -93.35400434 2021-10-24 04:21:22 Calcasieu, Louisiana, US
33778 33778 2021-10-23 US Louisiana Caldwell 22021 2221 38 0   32.0902519 -92.11752148 2021-10-24 04:21:22 Caldwell, Louisiana, US
33779 33779 2021-10-23 US Louisiana Cameron 22023 862 9 0   29.87592238 -93.19310676 2021-10-24 04:21:22 Cameron, Louisiana, US
33780 33780 2021-10-23 US Louisiana Catahoula 22025 1777 48 0   31.66778967 -91.84526385 2021-10-24 04:21:22 Catahoula, Louisiana, US
33781 33781 2021-10-23 US Louisiana Claiborne 22027 2004 63 0   32.82308512 -92.99526883 2021-10-24 04:21:22 Claiborne, Louisiana, US
33782 33782 2021-10-23 US Louisiana Concordia 22029 3201 78 0   31.44817835 -91.63814433 2021-10-24 04:21:22 Concordia, Louisiana, US
33783 33783 2021-10-23 US Louisiana De Soto 22031 4718 107 0   32.05457447 -93.74130302 2021-10-24 04:21:22 De Soto, Louisiana, US
33784 33784 2021-10-23 US Louisiana East Baton Rouge 22033 63656 1158 0   30.53842039 -91.09777565 2021-10-24 04:21:22 East Baton Rouge, Louisiana, US
33785 33785 2021-10-23 US Louisiana East Carroll 22035 1589 30 0   32.73926954 -91.23425694 2021-10-24 04:21:22 East Carroll, Louisiana, US
33786 33786 2021-10-23 US Louisiana East Feliciana 22037 4476 144 0   30.84425359 -91.04976723 2021-10-24 04:21:22 East Feliciana, Louisiana, US
33787 33787 2021-10-23 US Louisiana Evangeline 22039 5802 140 0   30.72985248 -92.39915924 2021-10-24 04:21:22 Evangeline, Louisiana, US
33788 33788 2021-10-23 US Louisiana Franklin 22041 4672 137 0   32.13675181 -91.67589857 2021-10-24 04:21:22 Franklin, Louisiana, US
33789 33789 2021-10-23 US Louisiana Grant 22043 3814 77 0   31.59882456 -92.56124347 2021-10-24 04:21:22 Grant, Louisiana, US
33790 33790 2021-10-23 US Louisiana Iberia 22045 12406 224 0   29.86803617 -91.75871777 2021-10-24 04:21:22 Iberia, Louisiana, US
33791 33791 2021-10-23 US Louisiana Iberville 22047 5801 125 0   30.25734305 -91.3499598 2021-10-24 04:21:22 Iberville, Louisiana, US
33792 33792 2021-10-23 US Louisiana Jackson 22049 2754 63 0   32.30251776 -92.55692092 2021-10-24 04:21:22 Jackson, Louisiana, US
33793 33793 2021-10-23 US Louisiana Jefferson 22051 69330 1158 0   29.74075478 -90.11115756 2021-10-24 04:21:22 Jefferson, Louisiana, US
33794 33794 2021-10-23 US Louisiana Jefferson Davis 22053 4695 126 0   30.26896765 -92.81210004 2021-10-24 04:21:22 Jefferson Davis, Louisiana, US
33795 33795 2021-10-23 US Louisiana LaSalle 22059 2717 46 0   31.67884782 -92.15907765 2021-10-24 04:21:22 LaSalle, Louisiana, US
33796 33796 2021-10-23 US Louisiana Lafayette 22055 38681 401 0   30.2049055 -92.06959876 2021-10-24 04:21:22 Lafayette, Louisiana, US
33797 33797 2021-10-23 US Louisiana Lafourche 22057 17821 309 0   29.52470226 -90.40976986 2021-10-24 04:21:22 Lafourche, Louisiana, US
33798 33798 2021-10-23 US Louisiana Lincoln 22061 7041 115 0   32.6003154 -92.66597409999999 2021-10-24 04:21:22 Lincoln, Louisiana, US
33799 33799 2021-10-23 US Louisiana Livingston 22063 24437 373 0   30.44143993 -90.73061664 2021-10-24 04:21:22 Livingston, Louisiana, US
33800 33800 2021-10-23 US Louisiana Madison 22065 2233 52 0   32.36918118 -91.23973355 2021-10-24 04:21:22 Madison, Louisiana, US
33801 33801 2021-10-23 US Louisiana Morehouse 22067 4451 115 0   32.81686191 -91.80421614 2021-10-24 04:21:22 Morehouse, Louisiana, US
33802 33802 2021-10-23 US Louisiana Natchitoches 22069 6552 133 0   31.72321584 -93.09816516 2021-10-24 04:21:22 Natchitoches, Louisiana, US
33803 33803 2021-10-23 US Louisiana Orleans 22071 46614 993 0   30.06971951 -89.92660315 2021-10-24 04:21:22 Orleans, Louisiana, US
33804 33804 2021-10-23 US Louisiana Ouachita 22073 31401 583 0   32.47645559 -92.15704172 2021-10-24 04:21:22 Ouachita, Louisiana, US
33805 33805 2021-10-23 US Louisiana Out of LA 80022 0 0 0   32.83121059 0.0 2021-10-24 04:21:22 Out of LA, Louisiana, US
33806 33806 2021-10-23 US Louisiana Plaquemines 22075 3813 40 0   29.42245447 -89.60322085 2021-10-24 04:21:22 Plaquemines, Louisiana, US
33807 33807 2021-10-23 US Louisiana Pointe Coupee 22077 3849 83 0   30.71409502 -91.60209535 2021-10-24 04:21:22 Pointe Coupee, Louisiana, US
33808 33808 2021-10-23 US Louisiana Rapides 22079 21140 460 0   31.19778499 -92.52997303 2021-10-24 04:21:22 Rapides, Louisiana, US
33809 33809 2021-10-23 US Louisiana Red River 22081 1400 48 0   32.09530039 -93.34213308 2021-10-24 04:21:22 Red River, Louisiana, US
33810 33810 2021-10-23 US Louisiana Richland 22083 4295 78 0   32.41391005 -91.76634876 2021-10-24 04:21:22 Richland, Louisiana, US
33811 33811 2021-10-23 US Louisiana Sabine 22085 4497 88 0   31.56388699 -93.55433981 2021-10-24 04:21:22 Sabine, Louisiana, US
33812 33812 2021-10-23 US Louisiana St. Bernard 22087 6873 98 0   29.87761636 -89.51887093 2021-10-24 04:21:22 St. Bernard, Louisiana, US
33813 33813 2021-10-23 US Louisiana St. Charles 22089 8848 127 0   29.90709658 -90.35555967 2021-10-24 04:21:22 St. Charles, Louisiana, US
33814 33814 2021-10-23 US Louisiana St. Helena 22091 1262 18 0   30.82210324 -90.71013176 2021-10-24 04:21:22 St. Helena, Louisiana, US
33815 33815 2021-10-23 US Louisiana St. James 22093 3487 70 0   30.02531716 -90.80212061 2021-10-24 04:21:22 St. James, Louisiana, US
33816 33816 2021-10-23 US Louisiana St. John the Baptist 22095 6288 170 0   30.12597499 -90.4753503 2021-10-24 04:21:22 St. John the Baptist, Louisiana, US
33817 33817 2021-10-23 US Louisiana St. Landry 22097 14006 344 0   30.59724262 -92.00135806 2021-10-24 04:21:22 St. Landry, Louisiana, US
33818 33818 2021-10-23 US Louisiana St. Martin 22099 8372 160 0   30.13112107 -91.61403569 2021-10-24 04:21:22 St. Martin, Louisiana, US
33819 33819 2021-10-23 US Louisiana St. Mary 22101 8519 221 0   29.69262097 -91.44702164 2021-10-24 04:21:22 St. Mary, Louisiana, US
33820 33820 2021-10-23 US Louisiana St. Tammany 22103 43411 716 0   30.40942847 -89.95642711 2021-10-24 04:21:22 St. Tammany, Louisiana, US
33821 33821 2021-10-23 US Louisiana Tangipahoa 22105 22690 502 0   30.62888673 -90.40664996 2021-10-24 04:21:22 Tangipahoa, Louisiana, US
33822 33822 2021-10-23 US Louisiana Tensas 22107 520 8 0   32.00760749 -91.32915234 2021-10-24 04:21:22 Tensas, Louisiana, US
33823 33823 2021-10-23 US Louisiana Terrebonne 22109 19315 338 0   29.37343766 -90.82626855 2021-10-24 04:21:22 Terrebonne, Louisiana, US
33824 33824 2021-10-23 US Louisiana Unassigned 90022 576 0 0   32.83121059 0.0 2021-10-24 04:21:22 Unassigned, Louisiana, US
33825 33825 2021-10-23 US Louisiana Union 22111 3984 105 0   32.83121059 -92.3749373 2021-10-24 04:21:22 Union, Louisiana, US
33826 33826 2021-10-23 US Louisiana Vermilion 22113 10162 187 0   29.83517605 -92.30292538 2021-10-24 04:21:22 Vermilion, Louisiana, US
33827 33827 2021-10-23 US Louisiana Vernon 22115 6272 160 0   31.10884837 -93.18153838 2021-10-24 04:21:22 Vernon, Louisiana, US
33828 33828 2021-10-23 US Louisiana Washington 22117 7933 212 0   30.85288548 -90.03866652 2021-10-24 04:21:22 Washington, Louisiana, US
33829 33829 2021-10-23 US Louisiana Webster 22119 6591 147 0   32.70847669 -93.33121835 2021-10-24 04:21:22 Webster, Louisiana, US
33830 33830 2021-10-23 US Louisiana West Baton Rouge 22121 4374 74 0   30.46058217 -91.30989571 2021-10-24 04:21:22 West Baton Rouge, Louisiana, US
33831 33831 2021-10-23 US Louisiana West Carroll 22123 1971 47 0   32.78550125 -91.461201 2021-10-24 04:21:22 West Carroll, Louisiana, US
33832 33832 2021-10-23 US Louisiana West Feliciana 22125 1509 40 0   30.87882871 -91.41485379999999 2021-10-24 04:21:22 West Feliciana, Louisiana, US
33833 33833 2021-10-23 US Louisiana Winn 22127 2614 58 0   31.94449367 -92.63789413 2021-10-24 04:21:22 Winn, Louisiana, US
314252 314252 2021-10-22 US Louisiana Acadia 22001 10426 249 0   30.295064899999996 -92.41419698 2021-10-23 04:21:32 Acadia, Louisiana, US
314253 314253 2021-10-22 US Louisiana Allen 22003 4705 113 0   30.65385745 -92.82442028 2021-10-23 04:21:32 Allen, Louisiana, US
314254 314254 2021-10-22 US Louisiana Ascension 22005 21717 239 0   30.20406249 -90.91328409999998 2021-10-23 04:21:32 Ascension, Louisiana, US
314255 314255 2021-10-22 US Louisiana Assumption 22007 3643 56 0   29.89946234 -91.06461642 2021-10-23 04:21:32 Assumption, Louisiana, US
314256 314256 2021-10-22 US Louisiana Avoyelles 22009 7072 177 0   31.07796211 -92.00079449 2021-10-23 04:21:32 Avoyelles, Louisiana, US
314257 314257 2021-10-22 US Louisiana Beauregard 22011 6063 122 0   30.64836518 -93.34173616 2021-10-23 04:21:32 Beauregard, Louisiana, US
314258 314258 2021-10-22 US Louisiana Bienville 22013 2484 96 0   32.34569994 -93.05398492 2021-10-23 04:21:32 Bienville, Louisiana, US
314259 314259 2021-10-22 US Louisiana Bossier 22015 21633 400 0   32.67932307 -93.60460152 2021-10-23 04:21:32 Bossier, Louisiana, US
314260 314260 2021-10-22 US Louisiana Caddo 22017 39260 956 0   32.57991587 -93.88375652 2021-10-23 04:21:32 Caddo, Louisiana, US
314261 314261 2021-10-22 US Louisiana Calcasieu 22019 34331 610 0   30.22931235 -93.35400434 2021-10-23 04:21:32 Calcasieu, Louisiana, US
314262 314262 2021-10-22 US Louisiana Caldwell 22021 2221 38 0   32.0902519 -92.11752148 2021-10-23 04:21:32 Caldwell, Louisiana, US
314263 314263 2021-10-22 US Louisiana Cameron 22023 862 9 0   29.87592238 -93.19310676 2021-10-23 04:21:32 Cameron, Louisiana, US
314264 314264 2021-10-22 US Louisiana Catahoula 22025 1777 48 0   31.66778967 -91.84526385 2021-10-23 04:21:32 Catahoula, Louisiana, US
314265 314265 2021-10-22 US Louisiana Claiborne 22027 2004 63 0   32.82308512 -92.99526883 2021-10-23 04:21:32 Claiborne, Louisiana, US
314266 314266 2021-10-22 US Louisiana Concordia 22029 3201 78 0   31.44817835 -91.63814433 2021-10-23 04:21:32 Concordia, Louisiana, US
314267 314267 2021-10-22 US Louisiana De Soto 22031 4718 107 0   32.05457447 -93.74130302 2021-10-23 04:21:32 De Soto, Louisiana, US
314268 314268 2021-10-22 US Louisiana East Baton Rouge 22033 63656 1158 0   30.53842039 -91.09777565 2021-10-23 04:21:32 East Baton Rouge, Louisiana, US
314269 314269 2021-10-22 US Louisiana East Carroll 22035 1589 30 0   32.73926954 -91.23425694 2021-10-23 04:21:32 East Carroll, Louisiana, US
314270 314270 2021-10-22 US Louisiana East Feliciana 22037 4476 144 0   30.84425359 -91.04976723 2021-10-23 04:21:32 East Feliciana, Louisiana, US
314271 314271 2021-10-22 US Louisiana Evangeline 22039 5802 140 0   30.72985248 -92.39915924 2021-10-23 04:21:32 Evangeline, Louisiana, US
314272 314272 2021-10-22 US Louisiana Franklin 22041 4672 137 0   32.13675181 -91.67589857 2021-10-23 04:21:32 Franklin, Louisiana, US
314273 314273 2021-10-22 US Louisiana Grant 22043 3814 77 0   31.59882456 -92.56124347 2021-10-23 04:21:32 Grant, Louisiana, US
314274 314274 2021-10-22 US Louisiana Iberia 22045 12406 224 0   29.86803617 -91.75871777 2021-10-23 04:21:32 Iberia, Louisiana, US
314275 314275 2021-10-22 US Louisiana Iberville 22047 5801 125 0   30.25734305 -91.3499598 2021-10-23 04:21:32 Iberville, Louisiana, US
314276 314276 2021-10-22 US Louisiana Jackson 22049 2754 63 0   32.30251776 -92.55692092 2021-10-23 04:21:32 Jackson, Louisiana, US
314277 314277 2021-10-22 US Louisiana Jefferson 22051 69330 1158 0   29.74075478 -90.11115756 2021-10-23 04:21:32 Jefferson, Louisiana, US
314278 314278 2021-10-22 US Louisiana Jefferson Davis 22053 4695 126 0   30.26896765 -92.81210004 2021-10-23 04:21:32 Jefferson Davis, Louisiana, US
314279 314279 2021-10-22 US Louisiana LaSalle 22059 2717 46 0   31.67884782 -92.15907765 2021-10-23 04:21:32 LaSalle, Louisiana, US
314280 314280 2021-10-22 US Louisiana Lafayette 22055 38681 401 0   30.2049055 -92.06959876 2021-10-23 04:21:32 Lafayette, Louisiana, US
314281 314281 2021-10-22 US Louisiana Lafourche 22057 17821 309 0   29.52470226 -90.40976986 2021-10-23 04:21:32 Lafourche, Louisiana, US
314282 314282 2021-10-22 US Louisiana Lincoln 22061 7041 115 0   32.6003154 -92.66597409999999 2021-10-23 04:21:32 Lincoln, Louisiana, US
314283 314283 2021-10-22 US Louisiana Livingston 22063 24437 373 0   30.44143993 -90.73061664 2021-10-23 04:21:32 Livingston, Louisiana, US
314284 314284 2021-10-22 US Louisiana Madison 22065 2233 52 0   32.36918118 -91.23973355 2021-10-23 04:21:32 Madison, Louisiana, US
314285 314285 2021-10-22 US Louisiana Morehouse 22067 4451 115 0   32.81686191 -91.80421614 2021-10-23 04:21:32 Morehouse, Louisiana, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [johns_hopkins_csse_daily_reports] (
   [day] TEXT,
   [country_or_region] TEXT,
   [province_or_state] TEXT,
   [admin2] TEXT,
   [fips] TEXT,
   [confirmed] INTEGER,
   [deaths] INTEGER,
   [recovered] INTEGER,
   [active] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day]
    ON [johns_hopkins_csse_daily_reports] ([day]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state]
    ON [johns_hopkins_csse_daily_reports] ([province_or_state]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region]
    ON [johns_hopkins_csse_daily_reports] ([country_or_region]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key]
    ON [johns_hopkins_csse_daily_reports] ([combined_key]);