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

768 rows where county = "Pulaski" and state = "Indiana" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Indiana · 768 ✖

fips 1

county 1

  • Pulaski · 768 ✖
Link rowid date ▲ county state fips cases deaths
2500345 2500345 2022-05-13 Pulaski Indiana 18131 3086 86
2497087 2497087 2022-05-12 Pulaski Indiana 18131 3084 86
2493829 2493829 2022-05-11 Pulaski Indiana 18131 3084 86
2490571 2490571 2022-05-10 Pulaski Indiana 18131 3083 86
2487314 2487314 2022-05-09 Pulaski Indiana 18131 3083 86
2484056 2484056 2022-05-08 Pulaski Indiana 18131 3081 86
2480798 2480798 2022-05-07 Pulaski Indiana 18131 3081 86
2477540 2477540 2022-05-06 Pulaski Indiana 18131 3081 86
2474282 2474282 2022-05-05 Pulaski Indiana 18131 3081 86
2471025 2471025 2022-05-04 Pulaski Indiana 18131 3081 86
2467769 2467769 2022-05-03 Pulaski Indiana 18131 3081 86
2464514 2464514 2022-05-02 Pulaski Indiana 18131 3081 86
2461258 2461258 2022-05-01 Pulaski Indiana 18131 3080 86
2458002 2458002 2022-04-30 Pulaski Indiana 18131 3080 86
2454746 2454746 2022-04-29 Pulaski Indiana 18131 3080 86
2451490 2451490 2022-04-28 Pulaski Indiana 18131 3079 86
2448234 2448234 2022-04-27 Pulaski Indiana 18131 3079 86
2444978 2444978 2022-04-26 Pulaski Indiana 18131 3076 86
2441722 2441722 2022-04-25 Pulaski Indiana 18131 3076 86
2438466 2438466 2022-04-24 Pulaski Indiana 18131 3074 86
2435210 2435210 2022-04-23 Pulaski Indiana 18131 3074 86
2431954 2431954 2022-04-22 Pulaski Indiana 18131 3074 86
2428698 2428698 2022-04-21 Pulaski Indiana 18131 3074 86
2425442 2425442 2022-04-20 Pulaski Indiana 18131 3074 86
2422186 2422186 2022-04-19 Pulaski Indiana 18131 3074 86
2418930 2418930 2022-04-18 Pulaski Indiana 18131 3074 86
2415674 2415674 2022-04-17 Pulaski Indiana 18131 3070 86
2412418 2412418 2022-04-16 Pulaski Indiana 18131 3070 86
2409162 2409162 2022-04-15 Pulaski Indiana 18131 3070 86
2405906 2405906 2022-04-14 Pulaski Indiana 18131 3070 86
2402651 2402651 2022-04-13 Pulaski Indiana 18131 3070 86
2399396 2399396 2022-04-12 Pulaski Indiana 18131 3069 86
2396141 2396141 2022-04-11 Pulaski Indiana 18131 3069 86
2392885 2392885 2022-04-10 Pulaski Indiana 18131 3068 86
2389629 2389629 2022-04-09 Pulaski Indiana 18131 3068 86
2386374 2386374 2022-04-08 Pulaski Indiana 18131 3068 86
2383119 2383119 2022-04-07 Pulaski Indiana 18131 3068 86
2379864 2379864 2022-04-06 Pulaski Indiana 18131 3068 86
2376610 2376610 2022-04-05 Pulaski Indiana 18131 3067 86
2373358 2373358 2022-04-04 Pulaski Indiana 18131 3067 86
2370105 2370105 2022-04-03 Pulaski Indiana 18131 3066 86
2366852 2366852 2022-04-02 Pulaski Indiana 18131 3066 86
2363599 2363599 2022-04-01 Pulaski Indiana 18131 3066 86
2360345 2360345 2022-03-31 Pulaski Indiana 18131 3066 86
2357091 2357091 2022-03-30 Pulaski Indiana 18131 3066 86
2353838 2353838 2022-03-29 Pulaski Indiana 18131 3070 86
2350586 2350586 2022-03-28 Pulaski Indiana 18131 3070 86
2347333 2347333 2022-03-27 Pulaski Indiana 18131 3070 86
2344080 2344080 2022-03-26 Pulaski Indiana 18131 3070 86
2340827 2340827 2022-03-25 Pulaski Indiana 18131 3070 86
2337574 2337574 2022-03-24 Pulaski Indiana 18131 3070 86
2334320 2334320 2022-03-23 Pulaski Indiana 18131 3069 86
2331066 2331066 2022-03-22 Pulaski Indiana 18131 3069 86
2327814 2327814 2022-03-21 Pulaski Indiana 18131 3069 85
2324561 2324561 2022-03-20 Pulaski Indiana 18131 3068 85
2321307 2321307 2022-03-19 Pulaski Indiana 18131 3068 85
2318053 2318053 2022-03-18 Pulaski Indiana 18131 3068 85
2314800 2314800 2022-03-17 Pulaski Indiana 18131 3068 85
2311547 2311547 2022-03-16 Pulaski Indiana 18131 3067 85
2308294 2308294 2022-03-15 Pulaski Indiana 18131 3067 85
2305043 2305043 2022-03-14 Pulaski Indiana 18131 3067 85
2301791 2301791 2022-03-13 Pulaski Indiana 18131 3065 85
2298539 2298539 2022-03-12 Pulaski Indiana 18131 3065 85
2295287 2295287 2022-03-11 Pulaski Indiana 18131 3065 85
2292035 2292035 2022-03-10 Pulaski Indiana 18131 3064 85
2288783 2288783 2022-03-09 Pulaski Indiana 18131 3064 85
2285532 2285532 2022-03-08 Pulaski Indiana 18131 3063 85
2282280 2282280 2022-03-07 Pulaski Indiana 18131 3061 85
2279027 2279027 2022-03-06 Pulaski Indiana 18131 3054 85
2275774 2275774 2022-03-05 Pulaski Indiana 18131 3054 85
2272521 2272521 2022-03-04 Pulaski Indiana 18131 3054 85
2269269 2269269 2022-03-03 Pulaski Indiana 18131 3050 85
2266016 2266016 2022-03-02 Pulaski Indiana 18131 3048 85
2262765 2262765 2022-03-01 Pulaski Indiana 18131 3048 85
2259514 2259514 2022-02-28 Pulaski Indiana 18131 3046 85
2256263 2256263 2022-02-27 Pulaski Indiana 18131 3045 85
2253012 2253012 2022-02-26 Pulaski Indiana 18131 3045 85
2249761 2249761 2022-02-25 Pulaski Indiana 18131 3045 85
2246510 2246510 2022-02-24 Pulaski Indiana 18131 3044 85
2243259 2243259 2022-02-23 Pulaski Indiana 18131 3043 85
2240008 2240008 2022-02-22 Pulaski Indiana 18131 3041 85
2236757 2236757 2022-02-21 Pulaski Indiana 18131 3039 85
2233506 2233506 2022-02-20 Pulaski Indiana 18131 3035 85
2230255 2230255 2022-02-19 Pulaski Indiana 18131 3035 85
2227004 2227004 2022-02-18 Pulaski Indiana 18131 3035 85
2223753 2223753 2022-02-17 Pulaski Indiana 18131 3032 85
2220502 2220502 2022-02-16 Pulaski Indiana 18131 3027 85
2217251 2217251 2022-02-15 Pulaski Indiana 18131 3022 83
2214000 2214000 2022-02-14 Pulaski Indiana 18131 3023 83
2210748 2210748 2022-02-13 Pulaski Indiana 18131 3014 82
2207495 2207495 2022-02-12 Pulaski Indiana 18131 3014 82
2204242 2204242 2022-02-11 Pulaski Indiana 18131 3014 82
2200989 2200989 2022-02-10 Pulaski Indiana 18131 3000 81
2197735 2197735 2022-02-09 Pulaski Indiana 18131 2992 81
2194481 2194481 2022-02-08 Pulaski Indiana 18131 2992 81
2191227 2191227 2022-02-07 Pulaski Indiana 18131 2986 81
2187974 2187974 2022-02-06 Pulaski Indiana 18131 2978 81
2184721 2184721 2022-02-05 Pulaski Indiana 18131 2978 81
2181469 2181469 2022-02-04 Pulaski Indiana 18131 2978 81
2178218 2178218 2022-02-03 Pulaski Indiana 18131 2964 81

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