johns_hopkins_csse_daily_reports

⚠️ 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

9,303 rows where province_or_state = "Louisiana" sorted by day descending

View and edit SQL

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

province_or_state

  • Louisiana · 9,303

country_or_region

  • US 9,303
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
496189 2020-08-11 US Louisiana Caldwell 22021 224 3 0 221 32.0902519 -92.11752148 2020-08-12 04:27:29 Caldwell, Louisiana, US
496190 2020-08-11 US Louisiana De Soto 22031 743 26 0 717 32.05457447 -93.74130302 2020-08-12 04:27:29 De Soto, Louisiana, US
496191 2020-08-11 US Louisiana East Feliciana 22037 603 38 0 565 30.84425359 -91.04976723 2020-08-12 04:27:29 East Feliciana, Louisiana, US
496192 2020-08-11 US Louisiana Morehouse 22067 536 12 0 524 32.81686191 -91.80421614 2020-08-12 04:27:29 Morehouse, Louisiana, US
496193 2020-08-11 US Louisiana Ouachita 22073 4923 114 0 4809 32.47645559 -92.15704172 2020-08-12 04:27:29 Ouachita, Louisiana, US
496194 2020-08-11 US Louisiana St. Charles 22089 1492 52 0 1440 29.90709658 -90.35555967 2020-08-12 04:27:29 St. Charles, Louisiana, US
496195 2020-08-11 US Louisiana St. John the Baptist 22095 1434 92 0 1342 30.12597499 -90.4753503 2020-08-12 04:27:29 St. John the Baptist, Louisiana, US
496196 2020-08-11 US Louisiana Vermilion 22113 1611 27 0 1584 29.83517605 -92.30292538 2020-08-12 04:27:29 Vermilion, Louisiana, US
496926 2020-08-11 US Louisiana Assumption 22007 591 20 0 571 29.89946234 -91.06461642 2020-08-12 04:27:29 Assumption, Louisiana, US
496927 2020-08-11 US Louisiana Bossier 22015 2374 82 0 2292 32.67932307 -93.60460152 2020-08-12 04:27:29 Bossier, Louisiana, US
496928 2020-08-11 US Louisiana Iberville 22047 1259 49 0 1210 30.25734305 -91.3499598 2020-08-12 04:27:29 Iberville, Louisiana, US
496929 2020-08-11 US Louisiana Jefferson 22051 15452 529 0 14923 29.74075478 -90.11115756 2020-08-12 04:27:29 Jefferson, Louisiana, US
496930 2020-08-11 US Louisiana Lafourche 22057 2863 99 0 2764 29.52470226 -90.40976986 2020-08-12 04:27:29 Lafourche, Louisiana, US
496931 2020-08-11 US Louisiana Out of LA 80022 0 0 0 0 32.83121059 0.0 2020-08-12 04:27:29 Out of LA, Louisiana, US
496932 2020-08-11 US Louisiana Plaquemines 22075 461 19 0 442 29.42245447 -89.60322085 2020-08-12 04:27:29 Plaquemines, Louisiana, US
496933 2020-08-11 US Louisiana Sabine 22085 658 11 0 647 31.56388699 -93.55433981 2020-08-12 04:27:29 Sabine, Louisiana, US
496934 2020-08-11 US Louisiana Tangipahoa 22105 3540 78 0 3462 30.62888673 -90.40664996 2020-08-12 04:27:29 Tangipahoa, Louisiana, US
496935 2020-08-11 US Louisiana Vernon 22115 772 29 0 743 31.10884837 -93.18153838 2020-08-12 04:27:29 Vernon, Louisiana, US
497432 2020-08-11 US Louisiana Acadia 22001 2634 85 0 2549 30.2950649 -92.41419698 2020-08-12 04:27:29 Acadia, Louisiana, US
497433 2020-08-11 US Louisiana Allen 22003 1284 30 0 1254 30.65385745 -92.82442028 2020-08-12 04:27:29 Allen, Louisiana, US
497434 2020-08-11 US Louisiana Bienville 22013 386 30 0 356 32.34569994 -93.05398492 2020-08-12 04:27:29 Bienville, Louisiana, US
497435 2020-08-11 US Louisiana Claiborne 22027 282 11 0 271 32.82308512 -92.99526883 2020-08-12 04:27:29 Claiborne, Louisiana, US
497436 2020-08-11 US Louisiana Concordia 22029 337 9 0 328 31.44817835 -91.63814433 2020-08-12 04:27:29 Concordia, Louisiana, US
497437 2020-08-11 US Louisiana Jefferson Davis 22053 1033 28 0 1005 30.26896765 -92.81210004 2020-08-12 04:27:29 Jefferson Davis, Louisiana, US
497438 2020-08-11 US Louisiana Lafayette 22055 7723 96 0 7627 30.2049055 -92.06959876 2020-08-12 04:27:29 Lafayette, Louisiana, US
497439 2020-08-11 US Louisiana St. Martin 22099 1734 46 0 1688 30.13112107 -91.61403569 2020-08-12 04:27:29 St. Martin, Louisiana, US
497440 2020-08-11 US Louisiana Webster 22119 898 14 0 884 32.70847669 -93.33121835 2020-08-12 04:27:29 Webster, Louisiana, US
497865 2020-08-11 US Louisiana Beauregard 22011 837 19 0 818 30.64836518 -93.34173616 2020-08-12 04:27:29 Beauregard, Louisiana, US
497866 2020-08-11 US Louisiana Calcasieu 22019 6862 146 0 6716 30.22931235 -93.35400434 2020-08-12 04:27:29 Calcasieu, Louisiana, US
497867 2020-08-11 US Louisiana East Baton Rouge 22033 12377 354 0 12023 30.53842039 -91.09777565 2020-08-12 04:27:29 East Baton Rouge, Louisiana, US
497868 2020-08-11 US Louisiana East Carroll 22035 521 2 0 519 32.73926954 -91.23425694 2020-08-12 04:27:29 East Carroll, Louisiana, US
497869 2020-08-11 US Louisiana Evangeline 22039 908 7 0 901 30.72985248 -92.39915924 2020-08-12 04:27:29 Evangeline, Louisiana, US
497870 2020-08-11 US Louisiana Livingston 22063 2975 52 0 2923 30.44143993 -90.73061664 2020-08-12 04:27:29 Livingston, Louisiana, US
497871 2020-08-11 US Louisiana Natchitoches 22069 791 17 0 774 31.72321584 -93.09816516 2020-08-12 04:27:29 Natchitoches, Louisiana, US
497872 2020-08-11 US Louisiana Red River 22081 244 12 0 232 32.09530039 -93.34213308 2020-08-12 04:27:29 Red River, Louisiana, US
497873 2020-08-11 US Louisiana St. Bernard 22087 1113 24 0 1089 29.87761636 -89.51887093 2020-08-12 04:27:29 St. Bernard, Louisiana, US
497874 2020-08-11 US Louisiana St. Tammany 22103 5323 215 0 5108 30.40942847 -89.95642711 2020-08-12 04:27:29 St. Tammany, Louisiana, US
498348 2020-08-11 US Louisiana Unassigned 90022 255 118 0 137 32.83121059 0.0 2020-08-12 04:27:29 Unassigned, Louisiana, US
498375 2020-08-11 US Louisiana Ascension 22005 2930 77 0 2853 30.20406249 -90.91328409999998 2020-08-12 04:27:29 Ascension, Louisiana, US
498376 2020-08-11 US Louisiana Avoyelles 22009 1096 32 0 1064 31.07796211 -92.00079449 2020-08-12 04:27:29 Avoyelles, Louisiana, US
498377 2020-08-11 US Louisiana LaSalle 22059 308 2 0 306 31.67884782 -92.15907765 2020-08-12 04:27:29 LaSalle, Louisiana, US
498378 2020-08-11 US Louisiana St. Mary 22101 1631 55 0 1576 29.69262097 -91.44702164 2020-08-12 04:27:29 St. Mary, Louisiana, US
498379 2020-08-11 US Louisiana Terrebonne 22109 3072 85 0 2987 29.37343766 -90.82626855 2020-08-12 04:27:29 Terrebonne, Louisiana, US
498380 2020-08-11 US Louisiana West Carroll 22123 296 6 0 290 32.78550125 -91.461201 2020-08-12 04:27:29 West Carroll, Louisiana, US
498894 2020-08-11 US Louisiana Jackson 22049 378 18 0 360 32.30251776 -92.55692092 2020-08-12 04:27:29 Jackson, Louisiana, US
498895 2020-08-11 US Louisiana St. Landry 22097 2778 91 0 2687 30.59724262 -92.00135806 2020-08-12 04:27:29 St. Landry, Louisiana, US
498896 2020-08-11 US Louisiana West Feliciana 22125 355 17 0 338 30.87882871 -91.4148538 2020-08-12 04:27:29 West Feliciana, Louisiana, US
498897 2020-08-11 US Louisiana Winn 22127 426 7 0 419 31.94449367 -92.63789413 2020-08-12 04:27:29 Winn, Louisiana, US
499364 2020-08-11 US Louisiana Caddo 22017 6739 296 0 6443 32.57991587 -93.88375652 2020-08-12 04:27:29 Caddo, Louisiana, US
499365 2020-08-11 US Louisiana Cameron 22023 170 0 0 170 29.87592238 -93.19310676 2020-08-12 04:27:29 Cameron, Louisiana, US
499366 2020-08-11 US Louisiana Catahoula 22025 296 5 0 291 31.66778967 -91.84526385 2020-08-12 04:27:29 Catahoula, Louisiana, US
499367 2020-08-11 US Louisiana Grant 22043 307 18 0 289 31.59882456 -92.56124347 2020-08-12 04:27:29 Grant, Louisiana, US
499368 2020-08-11 US Louisiana Orleans 22071 10805 562 0 10243 30.06971951 -89.92660315 2020-08-12 04:27:29 Orleans, Louisiana, US
499369 2020-08-11 US Louisiana Rapides 22079 3327 114 0 3213 31.19778499 -92.52997303 2020-08-12 04:27:29 Rapides, Louisiana, US
499370 2020-08-11 US Louisiana St. James 22093 722 32 0 690 30.02531716 -90.80212061 2020-08-12 04:27:29 St. James, Louisiana, US
499371 2020-08-11 US Louisiana Union 22111 711 35 0 676 32.83121059 -92.3749373 2020-08-12 04:27:29 Union, Louisiana, US
499372 2020-08-11 US Louisiana West Baton Rouge 22121 727 37 0 690 30.46058217 -91.30989571 2020-08-12 04:27:29 West Baton Rouge, Louisiana, US
500036 2020-08-11 US Louisiana Franklin 22041 940 19 0 921 32.13675181 -91.67589857 2020-08-12 04:27:29 Franklin, Louisiana, US
500037 2020-08-11 US Louisiana Iberia 22045 2561 73 0 2488 29.86803617 -91.75871777 2020-08-12 04:27:29 Iberia, Louisiana, US
500038 2020-08-11 US Louisiana Lincoln 22061 806 31 0 775 32.6003154 -92.6659741 2020-08-12 04:27:29 Lincoln, Louisiana, US
500039 2020-08-11 US Louisiana Madison 22065 618 6 0 612 32.36918118 -91.23973355 2020-08-12 04:27:29 Madison, Louisiana, US
500040 2020-08-11 US Louisiana Pointe Coupee 22077 810 32 0 778 30.71409502 -91.60209535 2020-08-12 04:27:29 Pointe Coupee, Louisiana, US
500041 2020-08-11 US Louisiana Richland 22083 604 8 0 596 32.41391005 -91.76634876 2020-08-12 04:27:29 Richland, Louisiana, US
500042 2020-08-11 US Louisiana St. Helena 22091 275 2 0 273 30.82210324 -90.71013176 2020-08-12 04:27:29 St. Helena, Louisiana, US
500043 2020-08-11 US Louisiana Tensas 22107 91 0 0 91 32.00760749 -91.32915234 2020-08-12 04:27:29 Tensas, Louisiana, US
500044 2020-08-11 US Louisiana Washington 22117 1293 58 0 1235 30.85288548 -90.03866652 2020-08-12 04:27:29 Washington, Louisiana, US
274079 2020-08-10 US Louisiana Acadia 22001 2601 85 0 2516 30.295064899999996 -92.41419698 2020-08-11 04:35:08 Acadia, Louisiana, US
274132 2020-08-10 US Louisiana Allen 22003 1278 30 0 1248 30.65385745 -92.82442028 2020-08-11 04:35:08 Allen, Louisiana, US
274174 2020-08-10 US Louisiana Ascension 22005 2890 74 0 2816 30.20406249 -90.91328409999998 2020-08-11 04:35:08 Ascension, Louisiana, US
274181 2020-08-10 US Louisiana Assumption 22007 588 20 0 568 29.89946234 -91.06461642 2020-08-11 04:35:08 Assumption, Louisiana, US
274198 2020-08-10 US Louisiana Avoyelles 22009 1070 32 0 1038 31.07796211 -92.00079449 2020-08-11 04:35:08 Avoyelles, Louisiana, US
274248 2020-08-10 US Louisiana Beauregard 22011 835 18 0 817 30.64836518 -93.34173616 2020-08-11 04:35:08 Beauregard, Louisiana, US
274292 2020-08-10 US Louisiana Bienville 22013 382 30 0 352 32.34569994 -93.05398492 2020-08-11 04:35:08 Bienville, Louisiana, US
274330 2020-08-10 US Louisiana Bossier 22015 2339 81 0 2258 32.67932307 -93.60460152 2020-08-11 04:35:08 Bossier, Louisiana, US
274423 2020-08-10 US Louisiana Caddo 22017 6688 295 0 6393 32.57991587 -93.88375652 2020-08-11 04:35:08 Caddo, Louisiana, US
274427 2020-08-10 US Louisiana Calcasieu 22019 6815 146 0 6669 30.22931235 -93.35400434 2020-08-11 04:35:08 Calcasieu, Louisiana, US
274429 2020-08-10 US Louisiana Caldwell 22021 221 3 0 218 32.0902519 -92.11752148 2020-08-11 04:35:08 Caldwell, Louisiana, US
274456 2020-08-10 US Louisiana Cameron 22023 169 0 0 169 29.87592238 -93.19310676 2020-08-11 04:35:08 Cameron, Louisiana, US
274517 2020-08-10 US Louisiana Catahoula 22025 295 5 0 290 31.66778967 -91.84526385 2020-08-11 04:35:08 Catahoula, Louisiana, US
274607 2020-08-10 US Louisiana Claiborne 22027 277 11 0 266 32.82308512 -92.99526883 2020-08-11 04:35:08 Claiborne, Louisiana, US
274717 2020-08-10 US Louisiana Concordia 22029 334 9 0 325 31.44817835 -91.63814433 2020-08-11 04:35:08 Concordia, Louisiana, US
274833 2020-08-10 US Louisiana De Soto 22031 727 26 0 701 32.05457447 -93.74130302 2020-08-11 04:35:08 De Soto, Louisiana, US
274933 2020-08-10 US Louisiana East Baton Rouge 22033 12244 350 0 11894 30.53842039 -91.09777565 2020-08-11 04:35:08 East Baton Rouge, Louisiana, US
274934 2020-08-10 US Louisiana East Carroll 22035 520 2 0 518 32.73926954 -91.23425694 2020-08-11 04:35:08 East Carroll, Louisiana, US
274935 2020-08-10 US Louisiana East Feliciana 22037 591 36 0 555 30.84425359 -91.04976723 2020-08-11 04:35:08 East Feliciana, Louisiana, US
274989 2020-08-10 US Louisiana Evangeline 22039 895 7 0 888 30.72985248 -92.39915924 2020-08-11 04:35:08 Evangeline, Louisiana, US
275062 2020-08-10 US Louisiana Franklin 22041 938 18 0 920 32.13675181 -91.67589857 2020-08-11 04:35:08 Franklin, Louisiana, US
275179 2020-08-10 US Louisiana Grant 22043 306 18 0 288 31.59882456 -92.56124347 2020-08-11 04:35:08 Grant, Louisiana, US
275433 2020-08-10 US Louisiana Iberia 22045 2539 72 0 2467 29.86803617 -91.75871777 2020-08-11 04:35:08 Iberia, Louisiana, US
275434 2020-08-10 US Louisiana Iberville 22047 1250 48 0 1202 30.25734305 -91.3499598 2020-08-11 04:35:08 Iberville, Louisiana, US
275474 2020-08-10 US Louisiana Jackson 22049 376 18 0 358 32.30251776 -92.55692092 2020-08-11 04:35:08 Jackson, Louisiana, US
275512 2020-08-10 US Louisiana Jefferson 22051 15350 529 0 14821 29.74075478 -90.11115756 2020-08-11 04:35:08 Jefferson, Louisiana, US
275527 2020-08-10 US Louisiana Jefferson Davis 22053 1028 28 0 1000 30.26896765 -92.81210004 2020-08-11 04:35:08 Jefferson Davis, Louisiana, US
275648 2020-08-10 US Louisiana LaSalle 22059 305 2 0 303 31.67884782 -92.15907765 2020-08-11 04:35:08 LaSalle, Louisiana, US
275655 2020-08-10 US Louisiana Lafayette 22055 7643 96 0 7547 30.2049055 -92.06959876 2020-08-11 04:35:08 Lafayette, Louisiana, US
275659 2020-08-10 US Louisiana Lafourche 22057 2839 99 0 2740 29.52470226 -90.40976986 2020-08-11 04:35:08 Lafourche, Louisiana, US
275770 2020-08-10 US Louisiana Lincoln 22061 805 31 0 774 32.6003154 -92.66597409999999 2020-08-11 04:35:08 Lincoln, Louisiana, US
275798 2020-08-10 US Louisiana Livingston 22063 2938 51 0 2887 30.44143993 -90.73061664 2020-08-11 04:35:08 Livingston, Louisiana, US
275866 2020-08-10 US Louisiana Madison 22065 613 6 0 607 32.36918118 -91.23973355 2020-08-11 04:35:08 Madison, Louisiana, US
276110 2020-08-10 US Louisiana Morehouse 22067 531 12 0 519 32.81686191 -91.80421614 2020-08-11 04:35:08 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]);
Powered by Datasette · Query took 1788.902ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette