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

19,963 rows where state = "Louisiana" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips

state

  • Louisiana · 19,963 ✖
Link rowid date ▲ county state fips cases deaths
954092 954092 2021-01-22 Acadia Louisiana 22001 5658 174
954093 954093 2021-01-22 Allen Louisiana 22003 2716 77
954094 954094 2021-01-22 Ascension Louisiana 22005 9741 135
954095 954095 2021-01-22 Assumption Louisiana 22007 1733 30
954096 954096 2021-01-22 Avoyelles Louisiana 22009 3324 103
954097 954097 2021-01-22 Beauregard Louisiana 22011 2466 60
954098 954098 2021-01-22 Bienville Louisiana 22013 1450 64
954099 954099 2021-01-22 Bossier Louisiana 22015 11031 225
954100 954100 2021-01-22 Caddo Louisiana 22017 21669 589
954101 954101 2021-01-22 Calcasieu Louisiana 22019 16736 312
954102 954102 2021-01-22 Caldwell Louisiana 22021 1030 23
954103 954103 2021-01-22 Cameron Louisiana 22023 459 4
954104 954104 2021-01-22 Catahoula Louisiana 22025 992 29
954105 954105 2021-01-22 Claiborne Louisiana 22027 1305 47
954106 954106 2021-01-22 Concordia Louisiana 22029 1660 50
954107 954107 2021-01-22 De Soto Louisiana 22031 2193 58
954108 954108 2021-01-22 East Baton Rouge Louisiana 22033 30908 653
954109 954109 2021-01-22 East Carroll Louisiana 22035 1057 20
954110 954110 2021-01-22 East Feliciana Louisiana 22037 2716 98
954111 954111 2021-01-22 Evangeline Louisiana 22039 3014 68
954112 954112 2021-01-22 Franklin Louisiana 22041 2299 93
954113 954113 2021-01-22 Grant Louisiana 22043 1777 43
954114 954114 2021-01-22 Iberia Louisiana 22045 5782 132
954115 954115 2021-01-22 Iberville Louisiana 22047 3107 81
954116 954116 2021-01-22 Jackson Louisiana 22049 1555 43
954117 954117 2021-01-22 Jefferson Louisiana 22051 38873 743
954118 954118 2021-01-22 Jefferson Davis Louisiana 22053 2634 75
954119 954119 2021-01-22 LaSalle Louisiana 22059 1291 32
954120 954120 2021-01-22 Lafayette Louisiana 22055 19824 225
954121 954121 2021-01-22 Lafourche Louisiana 22057 7700 172
954122 954122 2021-01-22 Lincoln Louisiana 22061 3838 83
954123 954123 2021-01-22 Livingston Louisiana 22063 10636 149
954124 954124 2021-01-22 Madison Louisiana 22065 1490 28
954125 954125 2021-01-22 Morehouse Louisiana 22067 2512 59
954126 954126 2021-01-22 Natchitoches Louisiana 22069 3519 72
954127 954127 2021-01-22 Orleans Louisiana 22071 25178 709
954128 954128 2021-01-22 Ouachita Louisiana 22073 16469 363
954129 954129 2021-01-22 Plaquemines Louisiana 22075 2024 22
954130 954130 2021-01-22 Pointe Coupee Louisiana 22077 2191 63
954131 954131 2021-01-22 Rapides Louisiana 22079 10193 242
954132 954132 2021-01-22 Red River Louisiana 22081 758 30
954133 954133 2021-01-22 Richland Louisiana 22083 2086 42
954134 954134 2021-01-22 Sabine Louisiana 22085 2455 48
954135 954135 2021-01-22 St. Bernard Louisiana 22087 3050 43
954136 954136 2021-01-22 St. Charles Louisiana 22089 4577 80
954137 954137 2021-01-22 St. Helena Louisiana 22091 812 7
954138 954138 2021-01-22 St. James Louisiana 22093 1648 46
954139 954139 2021-01-22 St. John the Baptist Louisiana 22095 3130 125
954140 954140 2021-01-22 St. Landry Louisiana 22097 7587 221
954141 954141 2021-01-22 St. Martin Louisiana 22099 4454 99
954142 954142 2021-01-22 St. Mary Louisiana 22101 3650 107
954143 954143 2021-01-22 St. Tammany Louisiana 22103 20085 413
954144 954144 2021-01-22 Tangipahoa Louisiana 22105 10556 220
954145 954145 2021-01-22 Tensas Louisiana 22107 334 5
954146 954146 2021-01-22 Terrebonne Louisiana 22109 7927 166
954147 954147 2021-01-22 Union Louisiana 22111 2152 71
954148 954148 2021-01-22 Unknown Louisiana   412 0
954149 954149 2021-01-22 Vermilion Louisiana 22113 4334 95
954150 954150 2021-01-22 Vernon Louisiana 22115 2586 82
954151 954151 2021-01-22 Washington Louisiana 22117 3679 107
954152 954152 2021-01-22 Webster Louisiana 22119 3532 80
954153 954153 2021-01-22 West Baton Rouge Louisiana 22121 2206 50
954154 954154 2021-01-22 West Carroll Louisiana 22123 1093 36
954155 954155 2021-01-22 West Feliciana Louisiana 22125 1046 28
954156 954156 2021-01-22 Winn Louisiana 22127 1356 34
950847 950847 2021-01-21 Acadia Louisiana 22001 5644 174
950848 950848 2021-01-21 Allen Louisiana 22003 2705 76
950849 950849 2021-01-21 Ascension Louisiana 22005 9711 134
950850 950850 2021-01-21 Assumption Louisiana 22007 1721 30
950851 950851 2021-01-21 Avoyelles Louisiana 22009 3296 102
950852 950852 2021-01-21 Beauregard Louisiana 22011 2455 60
950853 950853 2021-01-21 Bienville Louisiana 22013 1444 63
950854 950854 2021-01-21 Bossier Louisiana 22015 10953 225
950855 950855 2021-01-21 Caddo Louisiana 22017 21545 587
950856 950856 2021-01-21 Calcasieu Louisiana 22019 16676 312
950857 950857 2021-01-21 Caldwell Louisiana 22021 1027 23
950858 950858 2021-01-21 Cameron Louisiana 22023 465 4
950859 950859 2021-01-21 Catahoula Louisiana 22025 989 29
950860 950860 2021-01-21 Claiborne Louisiana 22027 1291 47
950861 950861 2021-01-21 Concordia Louisiana 22029 1652 50
950862 950862 2021-01-21 De Soto Louisiana 22031 2155 56
950863 950863 2021-01-21 East Baton Rouge Louisiana 22033 30727 651
950864 950864 2021-01-21 East Carroll Louisiana 22035 1053 20
950865 950865 2021-01-21 East Feliciana Louisiana 22037 2712 98
950866 950866 2021-01-21 Evangeline Louisiana 22039 2989 68
950867 950867 2021-01-21 Franklin Louisiana 22041 2289 93
950868 950868 2021-01-21 Grant Louisiana 22043 1772 43
950869 950869 2021-01-21 Iberia Louisiana 22045 5732 132
950870 950870 2021-01-21 Iberville Louisiana 22047 3106 78
950871 950871 2021-01-21 Jackson Louisiana 22049 1546 42
950872 950872 2021-01-21 Jefferson Louisiana 22051 38677 742
950873 950873 2021-01-21 Jefferson Davis Louisiana 22053 2632 75
950874 950874 2021-01-21 LaSalle Louisiana 22059 1287 31
950875 950875 2021-01-21 Lafayette Louisiana 22055 19686 224
950876 950876 2021-01-21 Lafourche Louisiana 22057 7671 172
950877 950877 2021-01-21 Lincoln Louisiana 22061 3818 83
950878 950878 2021-01-21 Livingston Louisiana 22063 10611 149
950879 950879 2021-01-21 Madison Louisiana 22065 1480 28
950880 950880 2021-01-21 Morehouse Louisiana 22067 2493 58
950881 950881 2021-01-21 Natchitoches Louisiana 22069 3508 72

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