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

755 rows where county = "Piscataquis" and state = "Maine" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

  • Maine · 755 ✖

fips 1

county 1

  • Piscataquis · 755 ✖
Link rowid date ▲ county state fips cases deaths
2500774 2500774 2022-05-13 Piscataquis Maine 23021 3112 31
2497516 2497516 2022-05-12 Piscataquis Maine 23021 3105 31
2494258 2494258 2022-05-11 Piscataquis Maine 23021 3093 31
2491000 2491000 2022-05-10 Piscataquis Maine 23021 3091 31
2487743 2487743 2022-05-09 Piscataquis Maine 23021 3083 31
2484485 2484485 2022-05-08 Piscataquis Maine 23021 3080 31
2481227 2481227 2022-05-07 Piscataquis Maine 23021 3080 31
2477969 2477969 2022-05-06 Piscataquis Maine 23021 3068 31
2474711 2474711 2022-05-05 Piscataquis Maine 23021 3059 31
2471454 2471454 2022-05-04 Piscataquis Maine 23021 3057 31
2468198 2468198 2022-05-03 Piscataquis Maine 23021 3045 31
2464943 2464943 2022-05-02 Piscataquis Maine 23021 3040 31
2461687 2461687 2022-05-01 Piscataquis Maine 23021 3038 31
2458431 2458431 2022-04-30 Piscataquis Maine 23021 3038 31
2455175 2455175 2022-04-29 Piscataquis Maine 23021 3025 31
2451919 2451919 2022-04-28 Piscataquis Maine 23021 3022 31
2448663 2448663 2022-04-27 Piscataquis Maine 23021 3015 31
2445407 2445407 2022-04-26 Piscataquis Maine 23021 3012 31
2442151 2442151 2022-04-25 Piscataquis Maine 23021 3006 31
2438895 2438895 2022-04-24 Piscataquis Maine 23021 3006 31
2435639 2435639 2022-04-23 Piscataquis Maine 23021 3006 31
2432383 2432383 2022-04-22 Piscataquis Maine 23021 3005 31
2429127 2429127 2022-04-21 Piscataquis Maine 23021 3004 31
2425871 2425871 2022-04-20 Piscataquis Maine 23021 3003 31
2422615 2422615 2022-04-19 Piscataquis Maine 23021 2997 31
2419359 2419359 2022-04-18 Piscataquis Maine 23021 2997 31
2416103 2416103 2022-04-17 Piscataquis Maine 23021 2997 31
2412847 2412847 2022-04-16 Piscataquis Maine 23021 2997 31
2409591 2409591 2022-04-15 Piscataquis Maine 23021 2994 31
2406335 2406335 2022-04-14 Piscataquis Maine 23021 2990 31
2403079 2403079 2022-04-13 Piscataquis Maine 23021 2984 31
2399825 2399825 2022-04-12 Piscataquis Maine 23021 2978 31
2396569 2396569 2022-04-11 Piscataquis Maine 23021 2976 31
2393314 2393314 2022-04-10 Piscataquis Maine 23021 2976 31
2390058 2390058 2022-04-09 Piscataquis Maine 23021 2976 31
2386802 2386802 2022-04-08 Piscataquis Maine 23021 2977 31
2383547 2383547 2022-04-07 Piscataquis Maine 23021 2975 31
2380292 2380292 2022-04-06 Piscataquis Maine 23021 2971 31
2377037 2377037 2022-04-05 Piscataquis Maine 23021 2970 31
2373785 2373785 2022-04-04 Piscataquis Maine 23021 2967 31
2370532 2370532 2022-04-03 Piscataquis Maine 23021 2967 31
2367279 2367279 2022-04-02 Piscataquis Maine 23021 2967 31
2364026 2364026 2022-04-01 Piscataquis Maine 23021 2967 31
2360772 2360772 2022-03-31 Piscataquis Maine 23021 2965 31
2357518 2357518 2022-03-30 Piscataquis Maine 23021 2964 31
2354265 2354265 2022-03-29 Piscataquis Maine 23021 2960 31
2351013 2351013 2022-03-28 Piscataquis Maine 23021 2959 31
2347760 2347760 2022-03-27 Piscataquis Maine 23021 2959 31
2344507 2344507 2022-03-26 Piscataquis Maine 23021 2959 31
2341254 2341254 2022-03-25 Piscataquis Maine 23021 2958 31
2338001 2338001 2022-03-24 Piscataquis Maine 23021 2956 31
2334747 2334747 2022-03-23 Piscataquis Maine 23021 2952 31
2331493 2331493 2022-03-22 Piscataquis Maine 23021 2950 31
2328241 2328241 2022-03-21 Piscataquis Maine 23021 2946 31
2324988 2324988 2022-03-20 Piscataquis Maine 23021 2946 31
2321734 2321734 2022-03-19 Piscataquis Maine 23021 2946 31
2318480 2318480 2022-03-18 Piscataquis Maine 23021 2945 31
2315227 2315227 2022-03-17 Piscataquis Maine 23021 2938 31
2311974 2311974 2022-03-16 Piscataquis Maine 23021 2937 31
2308721 2308721 2022-03-15 Piscataquis Maine 23021 2931 31
2305470 2305470 2022-03-14 Piscataquis Maine 23021 2928 30
2302218 2302218 2022-03-13 Piscataquis Maine 23021 2928 30
2298966 2298966 2022-03-12 Piscataquis Maine 23021 2928 30
2295714 2295714 2022-03-11 Piscataquis Maine 23021 2926 30
2292462 2292462 2022-03-10 Piscataquis Maine 23021 2920 30
2289210 2289210 2022-03-09 Piscataquis Maine 23021 2918 30
2285959 2285959 2022-03-08 Piscataquis Maine 23021 2912 30
2282707 2282707 2022-03-07 Piscataquis Maine 23021 2910 30
2279454 2279454 2022-03-06 Piscataquis Maine 23021 2910 30
2276201 2276201 2022-03-05 Piscataquis Maine 23021 2910 30
2272948 2272948 2022-03-04 Piscataquis Maine 23021 2902 29
2269696 2269696 2022-03-03 Piscataquis Maine 23021 2899 27
2266443 2266443 2022-03-02 Piscataquis Maine 23021 2854 27
2263192 2263192 2022-03-01 Piscataquis Maine 23021 2844 27
2259941 2259941 2022-02-28 Piscataquis Maine 23021 2839 27
2256690 2256690 2022-02-27 Piscataquis Maine 23021 2839 27
2253439 2253439 2022-02-26 Piscataquis Maine 23021 2839 27
2250188 2250188 2022-02-25 Piscataquis Maine 23021 2819 27
2246937 2246937 2022-02-24 Piscataquis Maine 23021 2812 27
2243686 2243686 2022-02-23 Piscataquis Maine 23021 2795 27
2240435 2240435 2022-02-22 Piscataquis Maine 23021 2781 27
2237184 2237184 2022-02-21 Piscataquis Maine 23021 2683 27
2233933 2233933 2022-02-20 Piscataquis Maine 23021 2682 27
2230682 2230682 2022-02-19 Piscataquis Maine 23021 2664 27
2227431 2227431 2022-02-18 Piscataquis Maine 23021 2609 27
2224180 2224180 2022-02-17 Piscataquis Maine 23021 2542 27
2220929 2220929 2022-02-16 Piscataquis Maine 23021 2509 26
2217678 2217678 2022-02-15 Piscataquis Maine 23021 2466 26
2214427 2214427 2022-02-14 Piscataquis Maine 23021 2330 26
2211175 2211175 2022-02-13 Piscataquis Maine 23021 2330 26
2207922 2207922 2022-02-12 Piscataquis Maine 23021 2330 26
2204669 2204669 2022-02-11 Piscataquis Maine 23021 2314 26
2201416 2201416 2022-02-10 Piscataquis Maine 23021 2308 26
2198162 2198162 2022-02-09 Piscataquis Maine 23021 2298 26
2194908 2194908 2022-02-08 Piscataquis Maine 23021 2295 26
2191654 2191654 2022-02-07 Piscataquis Maine 23021 2274 26
2188401 2188401 2022-02-06 Piscataquis Maine 23021 2274 26
2185148 2185148 2022-02-05 Piscataquis Maine 23021 2274 26
2181896 2181896 2022-02-04 Piscataquis Maine 23021 2265 26
2178645 2178645 2022-02-03 Piscataquis Maine 23021 2254 25

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