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

782 rows where county = "Grant" 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 · 782 ✖

fips 1

county 1

  • Grant · 782 ✖
Link rowid date ▲ county state fips cases deaths
2500720 2500720 2022-05-13 Grant Louisiana 22043 5861 94
2497462 2497462 2022-05-12 Grant Louisiana 22043 5860 94
2494204 2494204 2022-05-11 Grant Louisiana 22043 5859 94
2490946 2490946 2022-05-10 Grant Louisiana 22043 5859 94
2487689 2487689 2022-05-09 Grant Louisiana 22043 5859 94
2484431 2484431 2022-05-08 Grant Louisiana 22043 5858 94
2481173 2481173 2022-05-07 Grant Louisiana 22043 5858 94
2477915 2477915 2022-05-06 Grant Louisiana 22043 5858 94
2474657 2474657 2022-05-05 Grant Louisiana 22043 5858 94
2471400 2471400 2022-05-04 Grant Louisiana 22043 5858 94
2468144 2468144 2022-05-03 Grant Louisiana 22043 5857 94
2464889 2464889 2022-05-02 Grant Louisiana 22043 5857 94
2461633 2461633 2022-05-01 Grant Louisiana 22043 5857 94
2458377 2458377 2022-04-30 Grant Louisiana 22043 5857 94
2455121 2455121 2022-04-29 Grant Louisiana 22043 5857 94
2451865 2451865 2022-04-28 Grant Louisiana 22043 5857 94
2448609 2448609 2022-04-27 Grant Louisiana 22043 5856 94
2445353 2445353 2022-04-26 Grant Louisiana 22043 5856 94
2442097 2442097 2022-04-25 Grant Louisiana 22043 5856 94
2438841 2438841 2022-04-24 Grant Louisiana 22043 5855 94
2435585 2435585 2022-04-23 Grant Louisiana 22043 5855 94
2432329 2432329 2022-04-22 Grant Louisiana 22043 5855 94
2429073 2429073 2022-04-21 Grant Louisiana 22043 5855 94
2425817 2425817 2022-04-20 Grant Louisiana 22043 5855 94
2422561 2422561 2022-04-19 Grant Louisiana 22043 5855 94
2419305 2419305 2022-04-18 Grant Louisiana 22043 5854 94
2416049 2416049 2022-04-17 Grant Louisiana 22043 5854 94
2412793 2412793 2022-04-16 Grant Louisiana 22043 5854 94
2409537 2409537 2022-04-15 Grant Louisiana 22043 5854 94
2406281 2406281 2022-04-14 Grant Louisiana 22043 5854 94
2403025 2403025 2022-04-13 Grant Louisiana 22043 5854 94
2399771 2399771 2022-04-12 Grant Louisiana 22043 5854 94
2396515 2396515 2022-04-11 Grant Louisiana 22043 5853 94
2393260 2393260 2022-04-10 Grant Louisiana 22043 5853 94
2390004 2390004 2022-04-09 Grant Louisiana 22043 5853 94
2386748 2386748 2022-04-08 Grant Louisiana 22043 5853 94
2383493 2383493 2022-04-07 Grant Louisiana 22043 5853 94
2380238 2380238 2022-04-06 Grant Louisiana 22043 5852 93
2376983 2376983 2022-04-05 Grant Louisiana 22043 5852 93
2373731 2373731 2022-04-04 Grant Louisiana 22043 5852 93
2370478 2370478 2022-04-03 Grant Louisiana 22043 5852 93
2367225 2367225 2022-04-02 Grant Louisiana 22043 5852 93
2363972 2363972 2022-04-01 Grant Louisiana 22043 5852 93
2360718 2360718 2022-03-31 Grant Louisiana 22043 5852 93
2357464 2357464 2022-03-30 Grant Louisiana 22043 5852 93
2354211 2354211 2022-03-29 Grant Louisiana 22043 5851 93
2350959 2350959 2022-03-28 Grant Louisiana 22043 5851 93
2347706 2347706 2022-03-27 Grant Louisiana 22043 5851 93
2344453 2344453 2022-03-26 Grant Louisiana 22043 5851 93
2341200 2341200 2022-03-25 Grant Louisiana 22043 5851 93
2337947 2337947 2022-03-24 Grant Louisiana 22043 5850 93
2334693 2334693 2022-03-23 Grant Louisiana 22043 5850 91
2331439 2331439 2022-03-22 Grant Louisiana 22043 5850 91
2328187 2328187 2022-03-21 Grant Louisiana 22043 5850 91
2324934 2324934 2022-03-20 Grant Louisiana 22043 5850 90
2321680 2321680 2022-03-19 Grant Louisiana 22043 5850 90
2318426 2318426 2022-03-18 Grant Louisiana 22043 5850 90
2315173 2315173 2022-03-17 Grant Louisiana 22043 5849 90
2311920 2311920 2022-03-16 Grant Louisiana 22043 5848 90
2308667 2308667 2022-03-15 Grant Louisiana 22043 5847 90
2305416 2305416 2022-03-14 Grant Louisiana 22043 5846 90
2302164 2302164 2022-03-13 Grant Louisiana 22043 5843 90
2298912 2298912 2022-03-12 Grant Louisiana 22043 5843 90
2295660 2295660 2022-03-11 Grant Louisiana 22043 5843 90
2292408 2292408 2022-03-10 Grant Louisiana 22043 5843 90
2289156 2289156 2022-03-09 Grant Louisiana 22043 5842 90
2285905 2285905 2022-03-08 Grant Louisiana 22043 5839 90
2282653 2282653 2022-03-07 Grant Louisiana 22043 5838 87
2279400 2279400 2022-03-06 Grant Louisiana 22043 5836 87
2276147 2276147 2022-03-05 Grant Louisiana 22043 5836 87
2272894 2272894 2022-03-04 Grant Louisiana 22043 5836 87
2269642 2269642 2022-03-03 Grant Louisiana 22043 5835 87
2266389 2266389 2022-03-02 Grant Louisiana 22043 5825 86
2263138 2263138 2022-03-01 Grant Louisiana 22043 5816 86
2259887 2259887 2022-02-28 Grant Louisiana 22043 5816 86
2256636 2256636 2022-02-27 Grant Louisiana 22043 5816 86
2253385 2253385 2022-02-26 Grant Louisiana 22043 5816 86
2250134 2250134 2022-02-25 Grant Louisiana 22043 5816 86
2246883 2246883 2022-02-24 Grant Louisiana 22043 5813 86
2243632 2243632 2022-02-23 Grant Louisiana 22043 5807 86
2240381 2240381 2022-02-22 Grant Louisiana 22043 5800 85
2237130 2237130 2022-02-21 Grant Louisiana 22043 5794 85
2233879 2233879 2022-02-20 Grant Louisiana 22043 5773 85
2230628 2230628 2022-02-19 Grant Louisiana 22043 5773 85
2227377 2227377 2022-02-18 Grant Louisiana 22043 5773 85
2224126 2224126 2022-02-17 Grant Louisiana 22043 5763 84
2220875 2220875 2022-02-16 Grant Louisiana 22043 5746 84
2217624 2217624 2022-02-15 Grant Louisiana 22043 5738 84
2214373 2214373 2022-02-14 Grant Louisiana 22043 5727 84
2211121 2211121 2022-02-13 Grant Louisiana 22043 5712 84
2207868 2207868 2022-02-12 Grant Louisiana 22043 5712 84
2204615 2204615 2022-02-11 Grant Louisiana 22043 5712 84
2201362 2201362 2022-02-10 Grant Louisiana 22043 5691 84
2198108 2198108 2022-02-09 Grant Louisiana 22043 5673 84
2194854 2194854 2022-02-08 Grant Louisiana 22043 5647 84
2191600 2191600 2022-02-07 Grant Louisiana 22043 5633 84
2188347 2188347 2022-02-06 Grant Louisiana 22043 5600 84
2185094 2185094 2022-02-05 Grant Louisiana 22043 5600 84
2181842 2181842 2022-02-04 Grant Louisiana 22043 5600 84
2178591 2178591 2022-02-03 Grant Louisiana 22043 5528 84

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