daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

66 rows where day = "2022-01-20" and province_or_state = "Louisiana" sorted by day descending

✎ View and edit SQL

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

province_or_state 1

  • Louisiana · 66 ✖

country_or_region 1

day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2022-01-20 US Louisiana Acadia 22001 13455 260 0   30.295064899999996 -92.41419698 2022-01-21 04:21:09 Acadia, Louisiana, US
2022-01-20 US Louisiana Allen 22003 6012 120 0   30.65385745 -92.82442028 2022-01-21 04:21:09 Allen, Louisiana, US
2022-01-20 US Louisiana Ascension 22005 30434 256 0   30.20406249 -90.91328409999998 2022-01-21 04:21:09 Ascension, Louisiana, US
2022-01-20 US Louisiana Assumption 22007 4787 58 0   29.89946234 -91.06461642 2022-01-21 04:21:09 Assumption, Louisiana, US
2022-01-20 US Louisiana Avoyelles 22009 9506 184 0   31.07796211 -92.00079449 2022-01-21 04:21:09 Avoyelles, Louisiana, US
2022-01-20 US Louisiana Beauregard 22011 7565 131 0   30.64836518 -93.34173616 2022-01-21 04:21:09 Beauregard, Louisiana, US
2022-01-20 US Louisiana Bienville 22013 3266 102 0   32.34569994 -93.05398492 2022-01-21 04:21:09 Bienville, Louisiana, US
2022-01-20 US Louisiana Bossier 22015 31401 425 0   32.67932307 -93.60460152 2022-01-21 04:21:09 Bossier, Louisiana, US
2022-01-20 US Louisiana Caddo 22017 57493 1004 0   32.57991587 -93.88375652 2022-01-21 04:21:09 Caddo, Louisiana, US
2022-01-20 US Louisiana Calcasieu 22019 45635 644 0   30.22931235 -93.35400434 2022-01-21 04:21:09 Calcasieu, Louisiana, US
2022-01-20 US Louisiana Caldwell 22021 2606 43 0   32.0902519 -92.11752148 2022-01-21 04:21:09 Caldwell, Louisiana, US
2022-01-20 US Louisiana Cameron 22023 1042 8 0   29.87592238 -93.19310676 2022-01-21 04:21:09 Cameron, Louisiana, US
2022-01-20 US Louisiana Catahoula 22025 2254 49 0   31.66778967 -91.84526385 2022-01-21 04:21:09 Catahoula, Louisiana, US
2022-01-20 US Louisiana Claiborne 22027 2750 67 0   32.82308512 -92.99526883 2022-01-21 04:21:09 Claiborne, Louisiana, US
2022-01-20 US Louisiana Concordia 22029 4236 81 0   31.44817835 -91.63814433 2022-01-21 04:21:09 Concordia, Louisiana, US
2022-01-20 US Louisiana De Soto 22031 6319 121 0   32.05457447 -93.74130302 2022-01-21 04:21:09 De Soto, Louisiana, US
2022-01-20 US Louisiana East Baton Rouge 22033 95933 1209 0   30.53842039 -91.09777565 2022-01-21 04:21:09 East Baton Rouge, Louisiana, US
2022-01-20 US Louisiana East Carroll 22035 2067 35 0   32.73926954 -91.23425694 2022-01-21 04:21:09 East Carroll, Louisiana, US
2022-01-20 US Louisiana East Feliciana 22037 6105 154 0   30.84425359 -91.04976723 2022-01-21 04:21:09 East Feliciana, Louisiana, US
2022-01-20 US Louisiana Evangeline 22039 7170 145 0   30.72985248 -92.39915924 2022-01-21 04:21:09 Evangeline, Louisiana, US
2022-01-20 US Louisiana Franklin 22041 5726 145 0   32.13675181 -91.67589857 2022-01-21 04:21:09 Franklin, Louisiana, US
2022-01-20 US Louisiana Grant 22043 4718 81 0   31.59882456 -92.56124347 2022-01-21 04:21:09 Grant, Louisiana, US
2022-01-20 US Louisiana Iberia 22045 16232 235 0   29.86803617 -91.75871777 2022-01-21 04:21:09 Iberia, Louisiana, US
2022-01-20 US Louisiana Iberville 22047 7788 130 0   30.25734305 -91.3499598 2022-01-21 04:21:09 Iberville, Louisiana, US
2022-01-20 US Louisiana Jackson 22049 3486 66 0   32.30251776 -92.55692092 2022-01-21 04:21:09 Jackson, Louisiana, US
2022-01-20 US Louisiana Jefferson 22051 100180 1214 0   29.74075478 -90.11115756 2022-01-21 04:21:09 Jefferson, Louisiana, US
2022-01-20 US Louisiana Jefferson Davis 22053 5908 134 0   30.26896765 -92.81210004 2022-01-21 04:21:09 Jefferson Davis, Louisiana, US
2022-01-20 US Louisiana LaSalle 22059 3385 46 0   31.67884782 -92.15907765 2022-01-21 04:21:09 LaSalle, Louisiana, US
2022-01-20 US Louisiana Lafayette 22055 52314 428 0   30.2049055 -92.06959876 2022-01-21 04:21:09 Lafayette, Louisiana, US
2022-01-20 US Louisiana Lafourche 22057 23574 325 0   29.52470226 -90.40976986 2022-01-21 04:21:09 Lafourche, Louisiana, US
2022-01-20 US Louisiana Lincoln 22061 9843 122 0   32.6003154 -92.66597409999999 2022-01-21 04:21:09 Lincoln, Louisiana, US
2022-01-20 US Louisiana Livingston 22063 31820 404 0   30.44143993 -90.73061664 2022-01-21 04:21:09 Livingston, Louisiana, US
2022-01-20 US Louisiana Madison 22065 2841 56 0   32.36918118 -91.23973355 2022-01-21 04:21:09 Madison, Louisiana, US
2022-01-20 US Louisiana Morehouse 22067 5758 120 0   32.81686191 -91.80421614 2022-01-21 04:21:09 Morehouse, Louisiana, US
2022-01-20 US Louisiana Natchitoches 22069 8537 145 0   31.72321584 -93.09816516 2022-01-21 04:21:09 Natchitoches, Louisiana, US
2022-01-20 US Louisiana Orleans 22071 76214 1029 0   30.06971951 -89.92660315 2022-01-21 04:21:09 Orleans, Louisiana, US
2022-01-20 US Louisiana Ouachita 22073 41843 626 0   32.47645559 -92.15704172 2022-01-21 04:21:09 Ouachita, Louisiana, US
2022-01-20 US Louisiana Out of LA 80022 0 0 0   32.83121059 0.0 2022-01-21 04:21:09 Out of LA, Louisiana, US
2022-01-20 US Louisiana Plaquemines 22075 5644 41 0   29.42245447 -89.60322085 2022-01-21 04:21:09 Plaquemines, Louisiana, US
2022-01-20 US Louisiana Pointe Coupee 22077 5062 85 0   30.71409502 -91.60209535 2022-01-21 04:21:09 Pointe Coupee, Louisiana, US
2022-01-20 US Louisiana Rapides 22079 27942 493 0   31.19778499 -92.52997303 2022-01-21 04:21:09 Rapides, Louisiana, US
2022-01-20 US Louisiana Red River 22081 1850 49 0   32.09530039 -93.34213308 2022-01-21 04:21:09 Red River, Louisiana, US
2022-01-20 US Louisiana Richland 22083 5339 81 0   32.41391005 -91.76634876 2022-01-21 04:21:09 Richland, Louisiana, US
2022-01-20 US Louisiana Sabine 22085 5512 100 0   31.56388699 -93.55433981 2022-01-21 04:21:09 Sabine, Louisiana, US
2022-01-20 US Louisiana St. Bernard 22087 9927 102 0   29.87761636 -89.51887093 2022-01-21 04:21:09 St. Bernard, Louisiana, US
2022-01-20 US Louisiana St. Charles 22089 12275 131 0   29.90709658 -90.35555967 2022-01-21 04:21:09 St. Charles, Louisiana, US
2022-01-20 US Louisiana St. Helena 22091 1636 20 0   30.82210324 -90.71013176 2022-01-21 04:21:09 St. Helena, Louisiana, US
2022-01-20 US Louisiana St. James 22093 4803 73 0   30.02531716 -90.80212061 2022-01-21 04:21:09 St. James, Louisiana, US
2022-01-20 US Louisiana St. John the Baptist 22095 9181 174 0   30.12597499 -90.4753503 2022-01-21 04:21:09 St. John the Baptist, Louisiana, US
2022-01-20 US Louisiana St. Landry 22097 18274 357 0   30.59724262 -92.00135806 2022-01-21 04:21:09 St. Landry, Louisiana, US
2022-01-20 US Louisiana St. Martin 22099 10930 166 0   30.13112107 -91.61403569 2022-01-21 04:21:09 St. Martin, Louisiana, US
2022-01-20 US Louisiana St. Mary 22101 10908 238 0   29.69262097 -91.44702164 2022-01-21 04:21:09 St. Mary, Louisiana, US
2022-01-20 US Louisiana St. Tammany 22103 61598 755 0   30.40942847 -89.95642711 2022-01-21 04:21:09 St. Tammany, Louisiana, US
2022-01-20 US Louisiana Tangipahoa 22105 29578 543 0   30.62888673 -90.40664996 2022-01-21 04:21:09 Tangipahoa, Louisiana, US
2022-01-20 US Louisiana Tensas 22107 799 10 0   32.00760749 -91.32915234 2022-01-21 04:21:09 Tensas, Louisiana, US
2022-01-20 US Louisiana Terrebonne 22109 26205 371 0   29.37343766 -90.82626855 2022-01-21 04:21:09 Terrebonne, Louisiana, US
2022-01-20 US Louisiana Unassigned 90022 861 0 0   32.83121059 0.0 2022-01-21 04:21:09 Unassigned, Louisiana, US
2022-01-20 US Louisiana Union 22111 5586 114 0   32.83121059 -92.3749373 2022-01-21 04:21:09 Union, Louisiana, US
2022-01-20 US Louisiana Vermilion 22113 12956 198 0   29.83517605 -92.30292538 2022-01-21 04:21:09 Vermilion, Louisiana, US
2022-01-20 US Louisiana Vernon 22115 8039 168 0   31.10884837 -93.18153838 2022-01-21 04:21:09 Vernon, Louisiana, US
2022-01-20 US Louisiana Washington 22117 10712 224 0   30.85288548 -90.03866652 2022-01-21 04:21:09 Washington, Louisiana, US
2022-01-20 US Louisiana Webster 22119 9221 156 0   32.70847669 -93.33121835 2022-01-21 04:21:09 Webster, Louisiana, US
2022-01-20 US Louisiana West Baton Rouge 22121 6324 80 0   30.46058217 -91.30989571 2022-01-21 04:21:09 West Baton Rouge, Louisiana, US
2022-01-20 US Louisiana West Carroll 22123 2753 53 0   32.78550125 -91.461201 2022-01-21 04:21:09 West Carroll, Louisiana, US
2022-01-20 US Louisiana West Feliciana 22125 2465 41 0   30.87882871 -91.41485379999999 2022-01-21 04:21:09 West Feliciana, Louisiana, US
2022-01-20 US Louisiana Winn 22127 3497 58 0   31.94449367 -92.63789413 2022-01-21 04:21:09 Winn, Louisiana, US

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;