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

791 rows where fips = 22095 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 · 791 ✖

fips 1

  • 22095 · 791 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2500746 2500746 2022-05-13 St. John the Baptist Louisiana 22095 10628 184
2497488 2497488 2022-05-12 St. John the Baptist Louisiana 22095 10622 184
2494230 2494230 2022-05-11 St. John the Baptist Louisiana 22095 10605 184
2490972 2490972 2022-05-10 St. John the Baptist Louisiana 22095 10598 184
2487715 2487715 2022-05-09 St. John the Baptist Louisiana 22095 10591 184
2484457 2484457 2022-05-08 St. John the Baptist Louisiana 22095 10577 184
2481199 2481199 2022-05-07 St. John the Baptist Louisiana 22095 10577 184
2477941 2477941 2022-05-06 St. John the Baptist Louisiana 22095 10577 184
2474683 2474683 2022-05-05 St. John the Baptist Louisiana 22095 10573 184
2471426 2471426 2022-05-04 St. John the Baptist Louisiana 22095 10569 184
2468170 2468170 2022-05-03 St. John the Baptist Louisiana 22095 10564 184
2464915 2464915 2022-05-02 St. John the Baptist Louisiana 22095 10558 184
2461659 2461659 2022-05-01 St. John the Baptist Louisiana 22095 10549 184
2458403 2458403 2022-04-30 St. John the Baptist Louisiana 22095 10549 184
2455147 2455147 2022-04-29 St. John the Baptist Louisiana 22095 10549 184
2451891 2451891 2022-04-28 St. John the Baptist Louisiana 22095 10544 184
2448635 2448635 2022-04-27 St. John the Baptist Louisiana 22095 10542 184
2445379 2445379 2022-04-26 St. John the Baptist Louisiana 22095 10536 184
2442123 2442123 2022-04-25 St. John the Baptist Louisiana 22095 10532 184
2438867 2438867 2022-04-24 St. John the Baptist Louisiana 22095 10527 184
2435611 2435611 2022-04-23 St. John the Baptist Louisiana 22095 10527 184
2432355 2432355 2022-04-22 St. John the Baptist Louisiana 22095 10527 184
2429099 2429099 2022-04-21 St. John the Baptist Louisiana 22095 10526 184
2425843 2425843 2022-04-20 St. John the Baptist Louisiana 22095 10525 184
2422587 2422587 2022-04-19 St. John the Baptist Louisiana 22095 10524 184
2419331 2419331 2022-04-18 St. John the Baptist Louisiana 22095 10523 184
2416075 2416075 2022-04-17 St. John the Baptist Louisiana 22095 10519 184
2412819 2412819 2022-04-16 St. John the Baptist Louisiana 22095 10519 184
2409563 2409563 2022-04-15 St. John the Baptist Louisiana 22095 10519 184
2406307 2406307 2022-04-14 St. John the Baptist Louisiana 22095 10519 184
2403051 2403051 2022-04-13 St. John the Baptist Louisiana 22095 10518 184
2399797 2399797 2022-04-12 St. John the Baptist Louisiana 22095 10517 184
2396541 2396541 2022-04-11 St. John the Baptist Louisiana 22095 10512 184
2393286 2393286 2022-04-10 St. John the Baptist Louisiana 22095 10510 184
2390030 2390030 2022-04-09 St. John the Baptist Louisiana 22095 10510 184
2386774 2386774 2022-04-08 St. John the Baptist Louisiana 22095 10510 184
2383519 2383519 2022-04-07 St. John the Baptist Louisiana 22095 10509 184
2380264 2380264 2022-04-06 St. John the Baptist Louisiana 22095 10509 184
2377009 2377009 2022-04-05 St. John the Baptist Louisiana 22095 10508 184
2373757 2373757 2022-04-04 St. John the Baptist Louisiana 22095 10505 184
2370504 2370504 2022-04-03 St. John the Baptist Louisiana 22095 10503 184
2367251 2367251 2022-04-02 St. John the Baptist Louisiana 22095 10503 184
2363998 2363998 2022-04-01 St. John the Baptist Louisiana 22095 10503 184
2360744 2360744 2022-03-31 St. John the Baptist Louisiana 22095 10502 184
2357490 2357490 2022-03-30 St. John the Baptist Louisiana 22095 10500 184
2354237 2354237 2022-03-29 St. John the Baptist Louisiana 22095 10500 184
2350985 2350985 2022-03-28 St. John the Baptist Louisiana 22095 10498 184
2347732 2347732 2022-03-27 St. John the Baptist Louisiana 22095 10491 184
2344479 2344479 2022-03-26 St. John the Baptist Louisiana 22095 10491 184
2341226 2341226 2022-03-25 St. John the Baptist Louisiana 22095 10491 184
2337973 2337973 2022-03-24 St. John the Baptist Louisiana 22095 10490 184
2334719 2334719 2022-03-23 St. John the Baptist Louisiana 22095 10486 184
2331465 2331465 2022-03-22 St. John the Baptist Louisiana 22095 10486 184
2328213 2328213 2022-03-21 St. John the Baptist Louisiana 22095 10485 184
2324960 2324960 2022-03-20 St. John the Baptist Louisiana 22095 10483 184
2321706 2321706 2022-03-19 St. John the Baptist Louisiana 22095 10483 184
2318452 2318452 2022-03-18 St. John the Baptist Louisiana 22095 10483 184
2315199 2315199 2022-03-17 St. John the Baptist Louisiana 22095 10482 184
2311946 2311946 2022-03-16 St. John the Baptist Louisiana 22095 10482 184
2308693 2308693 2022-03-15 St. John the Baptist Louisiana 22095 10482 184
2305442 2305442 2022-03-14 St. John the Baptist Louisiana 22095 10481 184
2302190 2302190 2022-03-13 St. John the Baptist Louisiana 22095 10473 184
2298938 2298938 2022-03-12 St. John the Baptist Louisiana 22095 10473 184
2295686 2295686 2022-03-11 St. John the Baptist Louisiana 22095 10473 184
2292434 2292434 2022-03-10 St. John the Baptist Louisiana 22095 10473 184
2289182 2289182 2022-03-09 St. John the Baptist Louisiana 22095 10472 184
2285931 2285931 2022-03-08 St. John the Baptist Louisiana 22095 10468 183
2282679 2282679 2022-03-07 St. John the Baptist Louisiana 22095 10467 183
2279426 2279426 2022-03-06 St. John the Baptist Louisiana 22095 10465 183
2276173 2276173 2022-03-05 St. John the Baptist Louisiana 22095 10465 183
2272920 2272920 2022-03-04 St. John the Baptist Louisiana 22095 10465 183
2269668 2269668 2022-03-03 St. John the Baptist Louisiana 22095 10461 182
2266415 2266415 2022-03-02 St. John the Baptist Louisiana 22095 10457 182
2263164 2263164 2022-03-01 St. John the Baptist Louisiana 22095 10453 179
2259913 2259913 2022-02-28 St. John the Baptist Louisiana 22095 10453 179
2256662 2256662 2022-02-27 St. John the Baptist Louisiana 22095 10453 179
2253411 2253411 2022-02-26 St. John the Baptist Louisiana 22095 10453 179
2250160 2250160 2022-02-25 St. John the Baptist Louisiana 22095 10453 179
2246909 2246909 2022-02-24 St. John the Baptist Louisiana 22095 10448 179
2243658 2243658 2022-02-23 St. John the Baptist Louisiana 22095 10445 179
2240407 2240407 2022-02-22 St. John the Baptist Louisiana 22095 10440 180
2237156 2237156 2022-02-21 St. John the Baptist Louisiana 22095 10432 180
2233905 2233905 2022-02-20 St. John the Baptist Louisiana 22095 10420 180
2230654 2230654 2022-02-19 St. John the Baptist Louisiana 22095 10420 180
2227403 2227403 2022-02-18 St. John the Baptist Louisiana 22095 10420 180
2224152 2224152 2022-02-17 St. John the Baptist Louisiana 22095 10414 180
2220901 2220901 2022-02-16 St. John the Baptist Louisiana 22095 10404 180
2217650 2217650 2022-02-15 St. John the Baptist Louisiana 22095 10394 180
2214399 2214399 2022-02-14 St. John the Baptist Louisiana 22095 10383 180
2211147 2211147 2022-02-13 St. John the Baptist Louisiana 22095 10359 180
2207894 2207894 2022-02-12 St. John the Baptist Louisiana 22095 10359 180
2204641 2204641 2022-02-11 St. John the Baptist Louisiana 22095 10359 180
2201388 2201388 2022-02-10 St. John the Baptist Louisiana 22095 10350 180
2198134 2198134 2022-02-09 St. John the Baptist Louisiana 22095 10331 180
2194880 2194880 2022-02-08 St. John the Baptist Louisiana 22095 10306 180
2191626 2191626 2022-02-07 St. John the Baptist Louisiana 22095 10286 179
2188373 2188373 2022-02-06 St. John the Baptist Louisiana 22095 10243 179
2185120 2185120 2022-02-05 St. John the Baptist Louisiana 22095 10243 179
2181868 2181868 2022-02-04 St. John the Baptist Louisiana 22095 10243 179
2178617 2178617 2022-02-03 St. John the Baptist Louisiana 22095 10218 179

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