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

790 rows where fips = 22087 and state = "Louisiana" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Louisiana · 790 ✖

fips 1

  • 22087 · 790 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2500742 2500742 2022-05-13 St. Bernard Louisiana 22087 11439 111
2497484 2497484 2022-05-12 St. Bernard Louisiana 22087 11431 111
2494226 2494226 2022-05-11 St. Bernard Louisiana 22087 11417 111
2490968 2490968 2022-05-10 St. Bernard Louisiana 22087 11396 111
2487711 2487711 2022-05-09 St. Bernard Louisiana 22087 11378 111
2484453 2484453 2022-05-08 St. Bernard Louisiana 22087 11364 111
2481195 2481195 2022-05-07 St. Bernard Louisiana 22087 11364 111
2477937 2477937 2022-05-06 St. Bernard Louisiana 22087 11364 111
2474679 2474679 2022-05-05 St. Bernard Louisiana 22087 11352 111
2471422 2471422 2022-05-04 St. Bernard Louisiana 22087 11339 111
2468166 2468166 2022-05-03 St. Bernard Louisiana 22087 11331 111
2464911 2464911 2022-05-02 St. Bernard Louisiana 22087 11322 111
2461655 2461655 2022-05-01 St. Bernard Louisiana 22087 11313 111
2458399 2458399 2022-04-30 St. Bernard Louisiana 22087 11313 111
2455143 2455143 2022-04-29 St. Bernard Louisiana 22087 11313 111
2451887 2451887 2022-04-28 St. Bernard Louisiana 22087 11304 111
2448631 2448631 2022-04-27 St. Bernard Louisiana 22087 11299 111
2445375 2445375 2022-04-26 St. Bernard Louisiana 22087 11294 111
2442119 2442119 2022-04-25 St. Bernard Louisiana 22087 11287 111
2438863 2438863 2022-04-24 St. Bernard Louisiana 22087 11272 111
2435607 2435607 2022-04-23 St. Bernard Louisiana 22087 11272 111
2432351 2432351 2022-04-22 St. Bernard Louisiana 22087 11272 111
2429095 2429095 2022-04-21 St. Bernard Louisiana 22087 11267 111
2425839 2425839 2022-04-20 St. Bernard Louisiana 22087 11263 111
2422583 2422583 2022-04-19 St. Bernard Louisiana 22087 11258 111
2419327 2419327 2022-04-18 St. Bernard Louisiana 22087 11250 111
2416071 2416071 2022-04-17 St. Bernard Louisiana 22087 11241 111
2412815 2412815 2022-04-16 St. Bernard Louisiana 22087 11241 111
2409559 2409559 2022-04-15 St. Bernard Louisiana 22087 11241 111
2406303 2406303 2022-04-14 St. Bernard Louisiana 22087 11241 111
2403047 2403047 2022-04-13 St. Bernard Louisiana 22087 11238 111
2399793 2399793 2022-04-12 St. Bernard Louisiana 22087 11232 111
2396537 2396537 2022-04-11 St. Bernard Louisiana 22087 11228 111
2393282 2393282 2022-04-10 St. Bernard Louisiana 22087 11221 111
2390026 2390026 2022-04-09 St. Bernard Louisiana 22087 11221 111
2386770 2386770 2022-04-08 St. Bernard Louisiana 22087 11221 111
2383515 2383515 2022-04-07 St. Bernard Louisiana 22087 11216 111
2380260 2380260 2022-04-06 St. Bernard Louisiana 22087 11213 110
2377005 2377005 2022-04-05 St. Bernard Louisiana 22087 11210 110
2373753 2373753 2022-04-04 St. Bernard Louisiana 22087 11208 110
2370500 2370500 2022-04-03 St. Bernard Louisiana 22087 11207 110
2367247 2367247 2022-04-02 St. Bernard Louisiana 22087 11207 110
2363994 2363994 2022-04-01 St. Bernard Louisiana 22087 11207 110
2360740 2360740 2022-03-31 St. Bernard Louisiana 22087 11204 109
2357486 2357486 2022-03-30 St. Bernard Louisiana 22087 11202 109
2354233 2354233 2022-03-29 St. Bernard Louisiana 22087 11201 109
2350981 2350981 2022-03-28 St. Bernard Louisiana 22087 11200 109
2347728 2347728 2022-03-27 St. Bernard Louisiana 22087 11195 109
2344475 2344475 2022-03-26 St. Bernard Louisiana 22087 11195 109
2341222 2341222 2022-03-25 St. Bernard Louisiana 22087 11195 109
2337969 2337969 2022-03-24 St. Bernard Louisiana 22087 11195 109
2334715 2334715 2022-03-23 St. Bernard Louisiana 22087 11193 109
2331461 2331461 2022-03-22 St. Bernard Louisiana 22087 11193 109
2328209 2328209 2022-03-21 St. Bernard Louisiana 22087 11192 109
2324956 2324956 2022-03-20 St. Bernard Louisiana 22087 11187 109
2321702 2321702 2022-03-19 St. Bernard Louisiana 22087 11187 109
2318448 2318448 2022-03-18 St. Bernard Louisiana 22087 11187 109
2315195 2315195 2022-03-17 St. Bernard Louisiana 22087 11186 109
2311942 2311942 2022-03-16 St. Bernard Louisiana 22087 11184 109
2308689 2308689 2022-03-15 St. Bernard Louisiana 22087 11182 109
2305438 2305438 2022-03-14 St. Bernard Louisiana 22087 11178 108
2302186 2302186 2022-03-13 St. Bernard Louisiana 22087 11173 108
2298934 2298934 2022-03-12 St. Bernard Louisiana 22087 11173 108
2295682 2295682 2022-03-11 St. Bernard Louisiana 22087 11173 108
2292430 2292430 2022-03-10 St. Bernard Louisiana 22087 11172 108
2289178 2289178 2022-03-09 St. Bernard Louisiana 22087 11170 108
2285927 2285927 2022-03-08 St. Bernard Louisiana 22087 11169 108
2282675 2282675 2022-03-07 St. Bernard Louisiana 22087 11167 107
2279422 2279422 2022-03-06 St. Bernard Louisiana 22087 11163 107
2276169 2276169 2022-03-05 St. Bernard Louisiana 22087 11163 107
2272916 2272916 2022-03-04 St. Bernard Louisiana 22087 11163 107
2269664 2269664 2022-03-03 St. Bernard Louisiana 22087 11160 107
2266411 2266411 2022-03-02 St. Bernard Louisiana 22087 11158 107
2263160 2263160 2022-03-01 St. Bernard Louisiana 22087 11151 107
2259909 2259909 2022-02-28 St. Bernard Louisiana 22087 11151 107
2256658 2256658 2022-02-27 St. Bernard Louisiana 22087 11151 107
2253407 2253407 2022-02-26 St. Bernard Louisiana 22087 11151 107
2250156 2250156 2022-02-25 St. Bernard Louisiana 22087 11151 107
2246905 2246905 2022-02-24 St. Bernard Louisiana 22087 11145 107
2243654 2243654 2022-02-23 St. Bernard Louisiana 22087 11137 107
2240403 2240403 2022-02-22 St. Bernard Louisiana 22087 11133 107
2237152 2237152 2022-02-21 St. Bernard Louisiana 22087 11126 107
2233901 2233901 2022-02-20 St. Bernard Louisiana 22087 11116 107
2230650 2230650 2022-02-19 St. Bernard Louisiana 22087 11116 107
2227399 2227399 2022-02-18 St. Bernard Louisiana 22087 11116 107
2224148 2224148 2022-02-17 St. Bernard Louisiana 22087 11110 107
2220897 2220897 2022-02-16 St. Bernard Louisiana 22087 11100 107
2217646 2217646 2022-02-15 St. Bernard Louisiana 22087 11094 107
2214395 2214395 2022-02-14 St. Bernard Louisiana 22087 11081 107
2211143 2211143 2022-02-13 St. Bernard Louisiana 22087 11055 107
2207890 2207890 2022-02-12 St. Bernard Louisiana 22087 11055 107
2204637 2204637 2022-02-11 St. Bernard Louisiana 22087 11055 107
2201384 2201384 2022-02-10 St. Bernard Louisiana 22087 11030 107
2198130 2198130 2022-02-09 St. Bernard Louisiana 22087 11007 106
2194876 2194876 2022-02-08 St. Bernard Louisiana 22087 10993 106
2191622 2191622 2022-02-07 St. Bernard Louisiana 22087 10958 106
2188369 2188369 2022-02-06 St. Bernard Louisiana 22087 10914 106
2185116 2185116 2022-02-05 St. Bernard Louisiana 22087 10914 106
2181864 2181864 2022-02-04 St. Bernard Louisiana 22087 10914 106
2178613 2178613 2022-02-03 St. Bernard Louisiana 22087 10888 105

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]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date] desc);