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

22,635 rows where province_or_state = "Louisiana" sorted by day descending

✎ View and edit SQL

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

province_or_state

  • Louisiana · 22,635 ✖

country_or_region

  • US 22,635
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
802763 802763 2021-03-01 US Louisiana Acadia 22001 6092 185 0 5907 30.2950649 -92.41419698 2021-03-02 05:23:30 Acadia, Louisiana, US
802764 802764 2021-03-01 US Louisiana Allen 22003 2993 86 0 2907 30.65385745 -92.82442028 2021-03-02 05:23:30 Allen, Louisiana, US
802765 802765 2021-03-01 US Louisiana Ascension 22005 10963 147 0 10816 30.20406249 -90.91328409999998 2021-03-02 05:23:30 Ascension, Louisiana, US
802766 802766 2021-03-01 US Louisiana Assumption 22007 2091 34 0 2057 29.89946234 -91.06461642 2021-03-02 05:23:30 Assumption, Louisiana, US
802767 802767 2021-03-01 US Louisiana Avoyelles 22009 3932 118 0 3814 31.07796211 -92.00079449 2021-03-02 05:23:30 Avoyelles, Louisiana, US
802768 802768 2021-03-01 US Louisiana Beauregard 22011 2823 65 0 2758 30.64836518 -93.34173616 2021-03-02 05:23:30 Beauregard, Louisiana, US
802769 802769 2021-03-01 US Louisiana Bienville 22013 1608 74 0 1534 32.34569994 -93.05398492 2021-03-02 05:23:30 Bienville, Louisiana, US
802770 802770 2021-03-01 US Louisiana Bossier 22015 13034 262 0 12772 32.67932307 -93.60460152 2021-03-02 05:23:30 Bossier, Louisiana, US
802771 802771 2021-03-01 US Louisiana Caddo 22017 24751 675 0 24076 32.57991587 -93.88375652 2021-03-02 05:23:30 Caddo, Louisiana, US
802772 802772 2021-03-01 US Louisiana Calcasieu 22019 19491 354 0 19137 30.22931235 -93.35400434 2021-03-02 05:23:30 Calcasieu, Louisiana, US
802773 802773 2021-03-01 US Louisiana Caldwell 22021 1075 25 0 1050 32.0902519 -92.11752148 2021-03-02 05:23:30 Caldwell, Louisiana, US
802774 802774 2021-03-01 US Louisiana Cameron 22023 542 6 0 536 29.87592238 -93.19310676 2021-03-02 05:23:30 Cameron, Louisiana, US
802775 802775 2021-03-01 US Louisiana Catahoula 22025 1057 34 0 1023 31.66778967 -91.84526385 2021-03-02 05:23:30 Catahoula, Louisiana, US
802776 802776 2021-03-01 US Louisiana Claiborne 22027 1399 49 0 1350 32.82308512 -92.99526883 2021-03-02 05:23:30 Claiborne, Louisiana, US
802777 802777 2021-03-01 US Louisiana Concordia 22029 1780 56 0 1724 31.44817835 -91.63814433 2021-03-02 05:23:30 Concordia, Louisiana, US
802778 802778 2021-03-01 US Louisiana De Soto 22031 2643 71 0 2572 32.05457447 -93.74130302 2021-03-02 05:23:30 De Soto, Louisiana, US
802779 802779 2021-03-01 US Louisiana East Baton Rouge 22033 35673 737 0 34936 30.53842039 -91.09777565 2021-03-02 05:23:30 East Baton Rouge, Louisiana, US
802780 802780 2021-03-01 US Louisiana East Carroll 22035 1109 23 0 1086 32.73926954 -91.23425694 2021-03-02 05:23:30 East Carroll, Louisiana, US
802781 802781 2021-03-01 US Louisiana East Feliciana 22037 2996 106 0 2890 30.84425359 -91.04976723 2021-03-02 05:23:30 East Feliciana, Louisiana, US
802782 802782 2021-03-01 US Louisiana Evangeline 22039 3303 79 0 3224 30.72985248 -92.39915924 2021-03-02 05:23:30 Evangeline, Louisiana, US
802783 802783 2021-03-01 US Louisiana Franklin 22041 2437 104 0 2333 32.13675181 -91.67589857 2021-03-02 05:23:30 Franklin, Louisiana, US
802784 802784 2021-03-01 US Louisiana Grant 22043 2016 52 0 1964 31.59882456 -92.56124347 2021-03-02 05:23:30 Grant, Louisiana, US
802785 802785 2021-03-01 US Louisiana Iberia 22045 6477 146 0 6331 29.86803617 -91.75871777 2021-03-02 05:23:30 Iberia, Louisiana, US
802786 802786 2021-03-01 US Louisiana Iberville 22047 3442 91 0 3351 30.25734305 -91.3499598 2021-03-02 05:23:30 Iberville, Louisiana, US
802787 802787 2021-03-01 US Louisiana Jackson 22049 1786 47 0 1739 32.30251776 -92.55692092 2021-03-02 05:23:30 Jackson, Louisiana, US
802788 802788 2021-03-01 US Louisiana Jefferson 22051 43936 844 0 43092 29.74075478 -90.11115756 2021-03-02 05:23:30 Jefferson, Louisiana, US
802789 802789 2021-03-01 US Louisiana Jefferson Davis 22053 2879 84 0 2795 30.26896765 -92.81210004 2021-03-02 05:23:30 Jefferson Davis, Louisiana, US
802790 802790 2021-03-01 US Louisiana LaSalle 22059 1423 34 0 1389 31.67884782 -92.15907765 2021-03-02 05:23:30 LaSalle, Louisiana, US
802791 802791 2021-03-01 US Louisiana Lafayette 22055 21602 262 0 21340 30.2049055 -92.06959876 2021-03-02 05:23:30 Lafayette, Louisiana, US
802792 802792 2021-03-01 US Louisiana Lafourche 22057 9128 198 0 8930 29.52470226 -90.40976986 2021-03-02 05:23:30 Lafourche, Louisiana, US
802793 802793 2021-03-01 US Louisiana Lincoln 22061 4230 89 0 4141 32.6003154 -92.6659741 2021-03-02 05:23:30 Lincoln, Louisiana, US
802794 802794 2021-03-01 US Louisiana Livingston 22063 12346 182 0 12164 30.44143993 -90.73061664 2021-03-02 05:23:30 Livingston, Louisiana, US
802795 802795 2021-03-01 US Louisiana Madison 22065 1552 33 0 1519 32.36918118 -91.23973355 2021-03-02 05:23:30 Madison, Louisiana, US
802796 802796 2021-03-01 US Louisiana Morehouse 22067 2714 67 0 2647 32.81686191 -91.80421614 2021-03-02 05:23:30 Morehouse, Louisiana, US
802797 802797 2021-03-01 US Louisiana Natchitoches 22069 3864 79 0 3785 31.72321584 -93.09816516 2021-03-02 05:23:30 Natchitoches, Louisiana, US
802798 802798 2021-03-01 US Louisiana Orleans 22071 28501 763 0 27738 30.06971951 -89.92660315 2021-03-02 05:23:30 Orleans, Louisiana, US
802799 802799 2021-03-01 US Louisiana Ouachita 22073 17695 420 0 17275 32.47645559 -92.15704172 2021-03-02 05:23:30 Ouachita, Louisiana, US
802800 802800 2021-03-01 US Louisiana Out of LA 80022 0 0 0 0 32.83121059 0.0 2021-03-02 05:23:30 Out of LA, Louisiana, US
802801 802801 2021-03-01 US Louisiana Plaquemines 22075 2336 24 0 2312 29.42245447 -89.60322085 2021-03-02 05:23:30 Plaquemines, Louisiana, US
802802 802802 2021-03-01 US Louisiana Pointe Coupee 22077 2364 70 0 2294 30.71409502 -91.60209535 2021-03-02 05:23:30 Pointe Coupee, Louisiana, US
802803 802803 2021-03-01 US Louisiana Rapides 22079 11276 293 0 10983 31.19778499 -92.52997303 2021-03-02 05:23:30 Rapides, Louisiana, US
802804 802804 2021-03-01 US Louisiana Red River 22081 862 36 0 826 32.09530039 -93.34213308 2021-03-02 05:23:30 Red River, Louisiana, US
802805 802805 2021-03-01 US Louisiana Richland 22083 2344 49 0 2295 32.41391005 -91.76634876 2021-03-02 05:23:30 Richland, Louisiana, US
802806 802806 2021-03-01 US Louisiana Sabine 22085 2782 52 0 2730 31.56388699 -93.55433981 2021-03-02 05:23:30 Sabine, Louisiana, US
802807 802807 2021-03-01 US Louisiana St. Bernard 22087 3742 46 0 3696 29.87761636 -89.51887093 2021-03-02 05:23:30 St. Bernard, Louisiana, US
802808 802808 2021-03-01 US Louisiana St. Charles 22089 5122 88 0 5034 29.90709658 -90.35555967 2021-03-02 05:23:30 St. Charles, Louisiana, US
802809 802809 2021-03-01 US Louisiana St. Helena 22091 878 8 0 870 30.82210324 -90.71013176 2021-03-02 05:23:30 St. Helena, Louisiana, US
802810 802810 2021-03-01 US Louisiana St. James 22093 1854 49 0 1805 30.02531716 -90.80212061 2021-03-02 05:23:30 St. James, Louisiana, US
802811 802811 2021-03-01 US Louisiana St. John the Baptist 22095 3531 133 0 3398 30.12597499 -90.4753503 2021-03-02 05:23:30 St. John the Baptist, Louisiana, US
802812 802812 2021-03-01 US Louisiana St. Landry 22097 8302 243 0 8059 30.59724262 -92.00135806 2021-03-02 05:23:30 St. Landry, Louisiana, US
802813 802813 2021-03-01 US Louisiana St. Martin 22099 4842 112 0 4730 30.13112107 -91.61403569 2021-03-02 05:23:30 St. Martin, Louisiana, US
802814 802814 2021-03-01 US Louisiana St. Mary 22101 4140 120 0 4020 29.69262097 -91.44702164 2021-03-02 05:23:30 St. Mary, Louisiana, US
802815 802815 2021-03-01 US Louisiana St. Tammany 22103 24087 491 0 23596 30.40942847 -89.95642711 2021-03-02 05:23:30 St. Tammany, Louisiana, US
802816 802816 2021-03-01 US Louisiana Tangipahoa 22105 12016 269 0 11747 30.62888673 -90.40664996 2021-03-02 05:23:30 Tangipahoa, Louisiana, US
802817 802817 2021-03-01 US Louisiana Tensas 22107 355 6 0 349 32.00760749 -91.32915234 2021-03-02 05:23:30 Tensas, Louisiana, US
802818 802818 2021-03-01 US Louisiana Terrebonne 22109 9549 202 0 9347 29.37343766 -90.82626855 2021-03-02 05:23:30 Terrebonne, Louisiana, US
802819 802819 2021-03-01 US Louisiana Unassigned 90022 427 0 0 427 32.83121059 0.0 2021-03-02 05:23:30 Unassigned, Louisiana, US
802820 802820 2021-03-01 US Louisiana Union 22111 2298 76 0 2222 32.83121059 -92.3749373 2021-03-02 05:23:30 Union, Louisiana, US
802821 802821 2021-03-01 US Louisiana Vermilion 22113 4873 107 0 4766 29.83517605 -92.30292538 2021-03-02 05:23:30 Vermilion, Louisiana, US
802822 802822 2021-03-01 US Louisiana Vernon 22115 2885 96 0 2789 31.10884837 -93.18153838 2021-03-02 05:23:30 Vernon, Louisiana, US
802823 802823 2021-03-01 US Louisiana Washington 22117 4093 121 0 3972 30.85288548 -90.03866652 2021-03-02 05:23:30 Washington, Louisiana, US
802824 802824 2021-03-01 US Louisiana Webster 22119 3928 94 0 3834 32.70847669 -93.33121835 2021-03-02 05:23:30 Webster, Louisiana, US
802825 802825 2021-03-01 US Louisiana West Baton Rouge 22121 2506 53 0 2453 30.46058217 -91.30989571 2021-03-02 05:23:30 West Baton Rouge, Louisiana, US
802826 802826 2021-03-01 US Louisiana West Carroll 22123 1162 39 0 1123 32.78550125 -91.461201 2021-03-02 05:23:30 West Carroll, Louisiana, US
802827 802827 2021-03-01 US Louisiana West Feliciana 22125 1101 31 0 1070 30.87882871 -91.4148538 2021-03-02 05:23:30 West Feliciana, Louisiana, US
802828 802828 2021-03-01 US Louisiana Winn 22127 1466 39 0 1427 31.94449367 -92.63789413 2021-03-02 05:23:30 Winn, Louisiana, US
1067905 1067905 2021-02-28 US Louisiana Acadia 22001 6077 185 0 5892 30.2950649 -92.41419698 2021-03-01 05:23:01 Acadia, Louisiana, US
1067906 1067906 2021-02-28 US Louisiana Allen 22003 2986 86 0 2900 30.65385745 -92.82442028 2021-03-01 05:23:01 Allen, Louisiana, US
1067907 1067907 2021-02-28 US Louisiana Ascension 22005 10956 147 0 10809 30.20406249 -90.91328409999998 2021-03-01 05:23:01 Ascension, Louisiana, US
1067908 1067908 2021-02-28 US Louisiana Assumption 22007 2090 34 0 2056 29.89946234 -91.06461642 2021-03-01 05:23:01 Assumption, Louisiana, US
1067909 1067909 2021-02-28 US Louisiana Avoyelles 22009 3924 117 0 3807 31.07796211 -92.00079449 2021-03-01 05:23:01 Avoyelles, Louisiana, US
1067910 1067910 2021-02-28 US Louisiana Beauregard 22011 2824 65 0 2759 30.64836518 -93.34173616 2021-03-01 05:23:01 Beauregard, Louisiana, US
1067911 1067911 2021-02-28 US Louisiana Bienville 22013 1602 73 0 1529 32.34569994 -93.05398492 2021-03-01 05:23:01 Bienville, Louisiana, US
1067912 1067912 2021-02-28 US Louisiana Bossier 22015 13010 261 0 12749 32.67932307 -93.60460152 2021-03-01 05:23:01 Bossier, Louisiana, US
1067913 1067913 2021-02-28 US Louisiana Caddo 22017 24726 675 0 24051 32.57991587 -93.88375652 2021-03-01 05:23:01 Caddo, Louisiana, US
1067914 1067914 2021-02-28 US Louisiana Calcasieu 22019 19459 354 0 19105 30.22931235 -93.35400434 2021-03-01 05:23:01 Calcasieu, Louisiana, US
1067915 1067915 2021-02-28 US Louisiana Caldwell 22021 1075 25 0 1050 32.0902519 -92.11752148 2021-03-01 05:23:01 Caldwell, Louisiana, US
1067916 1067916 2021-02-28 US Louisiana Cameron 22023 539 5 0 534 29.87592238 -93.19310676 2021-03-01 05:23:01 Cameron, Louisiana, US
1067917 1067917 2021-02-28 US Louisiana Catahoula 22025 1055 34 0 1021 31.66778967 -91.84526385 2021-03-01 05:23:01 Catahoula, Louisiana, US
1067918 1067918 2021-02-28 US Louisiana Claiborne 22027 1402 49 0 1353 32.82308512 -92.99526883 2021-03-01 05:23:01 Claiborne, Louisiana, US
1067919 1067919 2021-02-28 US Louisiana Concordia 22029 1782 56 0 1726 31.44817835 -91.63814433 2021-03-01 05:23:01 Concordia, Louisiana, US
1067920 1067920 2021-02-28 US Louisiana De Soto 22031 2639 71 0 2568 32.05457447 -93.74130302 2021-03-01 05:23:01 De Soto, Louisiana, US
1067921 1067921 2021-02-28 US Louisiana East Baton Rouge 22033 35628 734 0 34894 30.53842039 -91.09777565 2021-03-01 05:23:01 East Baton Rouge, Louisiana, US
1067922 1067922 2021-02-28 US Louisiana East Carroll 22035 1107 23 0 1084 32.73926954 -91.23425694 2021-03-01 05:23:01 East Carroll, Louisiana, US
1067923 1067923 2021-02-28 US Louisiana East Feliciana 22037 2994 106 0 2888 30.84425359 -91.04976723 2021-03-01 05:23:01 East Feliciana, Louisiana, US
1067924 1067924 2021-02-28 US Louisiana Evangeline 22039 3298 78 0 3220 30.72985248 -92.39915924 2021-03-01 05:23:01 Evangeline, Louisiana, US
1067925 1067925 2021-02-28 US Louisiana Franklin 22041 2435 101 0 2334 32.13675181 -91.67589857 2021-03-01 05:23:01 Franklin, Louisiana, US
1067926 1067926 2021-02-28 US Louisiana Grant 22043 2013 52 0 1961 31.59882456 -92.56124347 2021-03-01 05:23:01 Grant, Louisiana, US
1067927 1067927 2021-02-28 US Louisiana Iberia 22045 6470 145 0 6325 29.86803617 -91.75871777 2021-03-01 05:23:01 Iberia, Louisiana, US
1067928 1067928 2021-02-28 US Louisiana Iberville 22047 3435 91 0 3344 30.25734305 -91.3499598 2021-03-01 05:23:01 Iberville, Louisiana, US
1067929 1067929 2021-02-28 US Louisiana Jackson 22049 1776 47 0 1729 32.30251776 -92.55692092 2021-03-01 05:23:01 Jackson, Louisiana, US
1067930 1067930 2021-02-28 US Louisiana Jefferson 22051 43898 844 0 43054 29.74075478 -90.11115756 2021-03-01 05:23:01 Jefferson, Louisiana, US
1067931 1067931 2021-02-28 US Louisiana Jefferson Davis 22053 2874 84 0 2790 30.26896765 -92.81210004 2021-03-01 05:23:01 Jefferson Davis, Louisiana, US
1067932 1067932 2021-02-28 US Louisiana LaSalle 22059 1420 34 0 1386 31.67884782 -92.15907765 2021-03-01 05:23:01 LaSalle, Louisiana, US
1067933 1067933 2021-02-28 US Louisiana Lafayette 22055 21588 262 0 21326 30.2049055 -92.06959876 2021-03-01 05:23:01 Lafayette, Louisiana, US
1067934 1067934 2021-02-28 US Louisiana Lafourche 22057 9124 198 0 8926 29.52470226 -90.40976986 2021-03-01 05:23:01 Lafourche, Louisiana, US
1067935 1067935 2021-02-28 US Louisiana Lincoln 22061 4230 89 0 4141 32.6003154 -92.6659741 2021-03-01 05:23:01 Lincoln, Louisiana, US
1067936 1067936 2021-02-28 US Louisiana Livingston 22063 12343 180 0 12163 30.44143993 -90.73061664 2021-03-01 05:23:01 Livingston, Louisiana, US
1067937 1067937 2021-02-28 US Louisiana Madison 22065 1552 33 0 1519 32.36918118 -91.23973355 2021-03-01 05:23:01 Madison, Louisiana, US
1067938 1067938 2021-02-28 US Louisiana Morehouse 22067 2710 67 0 2643 32.81686191 -91.80421614 2021-03-01 05:23:01 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] TEXT,
   [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]);