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

792 rows where county = "Grant" and state = "Washington" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Washington · 792 ✖

fips 1

county 1

  • Grant · 792 ✖
Link rowid date ▲ county state fips cases deaths
2502655 2502655 2022-05-13 Grant Washington 53025 27251 259
2499397 2499397 2022-05-12 Grant Washington 53025 27251 259
2496139 2496139 2022-05-11 Grant Washington 53025 27146 259
2492881 2492881 2022-05-10 Grant Washington 53025 27146 259
2489623 2489623 2022-05-09 Grant Washington 53025 27146 259
2486366 2486366 2022-05-08 Grant Washington 53025 27146 259
2483108 2483108 2022-05-07 Grant Washington 53025 27146 259
2479850 2479850 2022-05-06 Grant Washington 53025 27146 259
2476592 2476592 2022-05-05 Grant Washington 53025 27146 259
2473334 2473334 2022-05-04 Grant Washington 53025 27146 259
2470078 2470078 2022-05-03 Grant Washington 53025 27123 259
2466822 2466822 2022-05-02 Grant Washington 53025 27123 259
2463567 2463567 2022-05-01 Grant Washington 53025 27123 259
2460311 2460311 2022-04-30 Grant Washington 53025 27123 259
2457055 2457055 2022-04-29 Grant Washington 53025 27123 259
2453799 2453799 2022-04-28 Grant Washington 53025 27094 259
2450543 2450543 2022-04-27 Grant Washington 53025 27094 259
2447287 2447287 2022-04-26 Grant Washington 53025 27094 259
2444031 2444031 2022-04-25 Grant Washington 53025 27094 259
2440775 2440775 2022-04-24 Grant Washington 53025 27094 259
2437519 2437519 2022-04-23 Grant Washington 53025 27094 259
2434263 2434263 2022-04-22 Grant Washington 53025 27094 259
2431007 2431007 2022-04-21 Grant Washington 53025 27064 259
2427751 2427751 2022-04-20 Grant Washington 53025 27064 259
2424495 2424495 2022-04-19 Grant Washington 53025 27064 259
2421239 2421239 2022-04-18 Grant Washington 53025 27064 259
2417983 2417983 2022-04-17 Grant Washington 53025 27064 259
2414727 2414727 2022-04-16 Grant Washington 53025 27064 259
2411471 2411471 2022-04-15 Grant Washington 53025 27064 259
2408215 2408215 2022-04-14 Grant Washington 53025 27064 259
2404959 2404959 2022-04-13 Grant Washington 53025 27064 259
2401704 2401704 2022-04-12 Grant Washington 53025 27064 259
2398449 2398449 2022-04-11 Grant Washington 53025 27064 259
2395194 2395194 2022-04-10 Grant Washington 53025 27064 259
2391938 2391938 2022-04-09 Grant Washington 53025 27064 259
2388682 2388682 2022-04-08 Grant Washington 53025 27064 259
2385427 2385427 2022-04-07 Grant Washington 53025 27064 259
2382172 2382172 2022-04-06 Grant Washington 53025 27050 256
2378917 2378917 2022-04-05 Grant Washington 53025 27050 256
2375663 2375663 2022-04-04 Grant Washington 53025 27050 256
2372411 2372411 2022-04-03 Grant Washington 53025 27050 256
2369158 2369158 2022-04-02 Grant Washington 53025 27050 256
2365905 2365905 2022-04-01 Grant Washington 53025 27050 256
2362652 2362652 2022-03-31 Grant Washington 53025 27050 256
2359398 2359398 2022-03-30 Grant Washington 53025 27039 256
2356144 2356144 2022-03-29 Grant Washington 53025 27039 256
2352891 2352891 2022-03-28 Grant Washington 53025 27039 256
2349639 2349639 2022-03-27 Grant Washington 53025 27039 256
2346386 2346386 2022-03-26 Grant Washington 53025 27039 256
2343133 2343133 2022-03-25 Grant Washington 53025 27039 256
2339880 2339880 2022-03-24 Grant Washington 53025 27039 256
2336627 2336627 2022-03-23 Grant Washington 53025 27013 255
2333373 2333373 2022-03-22 Grant Washington 53025 27013 255
2330119 2330119 2022-03-21 Grant Washington 53025 27013 255
2326867 2326867 2022-03-20 Grant Washington 53025 27013 255
2323614 2323614 2022-03-19 Grant Washington 53025 27013 255
2320360 2320360 2022-03-18 Grant Washington 53025 27013 255
2317106 2317106 2022-03-17 Grant Washington 53025 26960 253
2313853 2313853 2022-03-16 Grant Washington 53025 26960 253
2310600 2310600 2022-03-15 Grant Washington 53025 26960 253
2307347 2307347 2022-03-14 Grant Washington 53025 26960 253
2304096 2304096 2022-03-13 Grant Washington 53025 26960 253
2300844 2300844 2022-03-12 Grant Washington 53025 26960 253
2297592 2297592 2022-03-11 Grant Washington 53025 26960 253
2294340 2294340 2022-03-10 Grant Washington 53025 26891 249
2291088 2291088 2022-03-09 Grant Washington 53025 26891 249
2287836 2287836 2022-03-08 Grant Washington 53025 26891 249
2284584 2284584 2022-03-07 Grant Washington 53025 26891 249
2281332 2281332 2022-03-06 Grant Washington 53025 26891 249
2278079 2278079 2022-03-05 Grant Washington 53025 26891 249
2274826 2274826 2022-03-04 Grant Washington 53025 26891 249
2271573 2271573 2022-03-03 Grant Washington 53025 26766 248
2268321 2268321 2022-03-02 Grant Washington 53025 26766 248
2265068 2265068 2022-03-01 Grant Washington 53025 26766 248
2261818 2261818 2022-02-28 Grant Washington 53025 26766 248
2258567 2258567 2022-02-27 Grant Washington 53025 26766 248
2255316 2255316 2022-02-26 Grant Washington 53025 26766 248
2252065 2252065 2022-02-25 Grant Washington 53025 26766 248
2248814 2248814 2022-02-24 Grant Washington 53025 26533 246
2245563 2245563 2022-02-23 Grant Washington 53025 26533 246
2242312 2242312 2022-02-22 Grant Washington 53025 26533 246
2239061 2239061 2022-02-21 Grant Washington 53025 26533 246
2235810 2235810 2022-02-20 Grant Washington 53025 26533 246
2232559 2232559 2022-02-19 Grant Washington 53025 26533 246
2229308 2229308 2022-02-18 Grant Washington 53025 26533 246
2226057 2226057 2022-02-17 Grant Washington 53025 26533 246
2222806 2222806 2022-02-16 Grant Washington 53025 26141 236
2219555 2219555 2022-02-15 Grant Washington 53025 26141 236
2216305 2216305 2022-02-14 Grant Washington 53025 26141 236
2213054 2213054 2022-02-13 Grant Washington 53025 26141 236
2209801 2209801 2022-02-12 Grant Washington 53025 26141 236
2206548 2206548 2022-02-11 Grant Washington 53025 26141 236
2203295 2203295 2022-02-10 Grant Washington 53025 26141 236
2200041 2200041 2022-02-09 Grant Washington 53025 25362 236
2196787 2196787 2022-02-08 Grant Washington 53025 25362 236
2193532 2193532 2022-02-07 Grant Washington 53025 25362 236
2190279 2190279 2022-02-06 Grant Washington 53025 25362 236
2187026 2187026 2022-02-05 Grant Washington 53025 25362 236
2183773 2183773 2022-02-04 Grant Washington 53025 25362 236
2180521 2180521 2022-02-03 Grant Washington 53025 25362 236

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