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

779 rows where county = "Washington" and fips = 12133 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 12133 · 779 ✖

county 1

  • Washington · 779 ✖
Link rowid date ▲ county state fips cases deaths
2499965 2499965 2022-05-13 Washington Florida 12133 6642 110
2496707 2496707 2022-05-12 Washington Florida 12133 6642 110
2493449 2493449 2022-05-11 Washington Florida 12133 6642 110
2490191 2490191 2022-05-10 Washington Florida 12133 6642 110
2486934 2486934 2022-05-09 Washington Florida 12133 6642 110
2483676 2483676 2022-05-08 Washington Florida 12133 6642 110
2480418 2480418 2022-05-07 Washington Florida 12133 6642 110
2477160 2477160 2022-05-06 Washington Florida 12133 6642 110
2473902 2473902 2022-05-05 Washington Florida 12133 6632 110
2470645 2470645 2022-05-04 Washington Florida 12133 6632 110
2467389 2467389 2022-05-03 Washington Florida 12133 6632 110
2464134 2464134 2022-05-02 Washington Florida 12133 6632 110
2460878 2460878 2022-05-01 Washington Florida 12133 6632 110
2457622 2457622 2022-04-30 Washington Florida 12133 6632 110
2454366 2454366 2022-04-29 Washington Florida 12133 6632 110
2451110 2451110 2022-04-28 Washington Florida 12133 6632 110
2447854 2447854 2022-04-27 Washington Florida 12133 6632 110
2444598 2444598 2022-04-26 Washington Florida 12133 6632 110
2441342 2441342 2022-04-25 Washington Florida 12133 6632 110
2438086 2438086 2022-04-24 Washington Florida 12133 6632 110
2434830 2434830 2022-04-23 Washington Florida 12133 6632 110
2431574 2431574 2022-04-22 Washington Florida 12133 6632 110
2428318 2428318 2022-04-21 Washington Florida 12133 6625 110
2425062 2425062 2022-04-20 Washington Florida 12133 6625 110
2421806 2421806 2022-04-19 Washington Florida 12133 6625 110
2418550 2418550 2022-04-18 Washington Florida 12133 6625 110
2415294 2415294 2022-04-17 Washington Florida 12133 6625 110
2412038 2412038 2022-04-16 Washington Florida 12133 6625 110
2408782 2408782 2022-04-15 Washington Florida 12133 6625 110
2405526 2405526 2022-04-14 Washington Florida 12133 6625 110
2402271 2402271 2022-04-13 Washington Florida 12133 6625 110
2399016 2399016 2022-04-12 Washington Florida 12133 6625 110
2395761 2395761 2022-04-11 Washington Florida 12133 6625 110
2392505 2392505 2022-04-10 Washington Florida 12133 6625 110
2389249 2389249 2022-04-09 Washington Florida 12133 6625 110
2385994 2385994 2022-04-08 Washington Florida 12133 6625 110
2382739 2382739 2022-04-07 Washington Florida 12133 6602 110
2379484 2379484 2022-04-06 Washington Florida 12133 6602 110
2376230 2376230 2022-04-05 Washington Florida 12133 6602 108
2372978 2372978 2022-04-04 Washington Florida 12133 6602 108
2369725 2369725 2022-04-03 Washington Florida 12133 6602 108
2366472 2366472 2022-04-02 Washington Florida 12133 6602 108
2363219 2363219 2022-04-01 Washington Florida 12133 6602 108
2359965 2359965 2022-03-31 Washington Florida 12133 6602 108
2356711 2356711 2022-03-30 Washington Florida 12133 6602 108
2353458 2353458 2022-03-29 Washington Florida 12133 6602 107
2350206 2350206 2022-03-28 Washington Florida 12133 6602 107
2346953 2346953 2022-03-27 Washington Florida 12133 6602 107
2343700 2343700 2022-03-26 Washington Florida 12133 6602 107
2340447 2340447 2022-03-25 Washington Florida 12133 6602 107
2337194 2337194 2022-03-24 Washington Florida 12133 6596 107
2333940 2333940 2022-03-23 Washington Florida 12133 6596 105
2330686 2330686 2022-03-22 Washington Florida 12133 6596 105
2327434 2327434 2022-03-21 Washington Florida 12133 6596 105
2324181 2324181 2022-03-20 Washington Florida 12133 6596 105
2320927 2320927 2022-03-19 Washington Florida 12133 6596 105
2317673 2317673 2022-03-18 Washington Florida 12133 6596 105
2314420 2314420 2022-03-17 Washington Florida 12133 6596 105
2311167 2311167 2022-03-16 Washington Florida 12133 6596 105
2307914 2307914 2022-03-15 Washington Florida 12133 6596 105
2304663 2304663 2022-03-14 Washington Florida 12133 6596 105
2301411 2301411 2022-03-13 Washington Florida 12133 6596 105
2298159 2298159 2022-03-12 Washington Florida 12133 6596 105
2294907 2294907 2022-03-11 Washington Florida 12133 6596 105
2291655 2291655 2022-03-10 Washington Florida 12133 6583 105
2288403 2288403 2022-03-09 Washington Florida 12133 6583 105
2285152 2285152 2022-03-08 Washington Florida 12133 6583 104
2281900 2281900 2022-03-07 Washington Florida 12133 6583 104
2278647 2278647 2022-03-06 Washington Florida 12133 6583 104
2275394 2275394 2022-03-05 Washington Florida 12133 6583 104
2272141 2272141 2022-03-04 Washington Florida 12133 6583 104
2268889 2268889 2022-03-03 Washington Florida 12133 6580 104
2265636 2265636 2022-03-02 Washington Florida 12133 6580 104
2262385 2262385 2022-03-01 Washington Florida 12133 6580 100
2259134 2259134 2022-02-28 Washington Florida 12133 6580 100
2255883 2255883 2022-02-27 Washington Florida 12133 6580 100
2252632 2252632 2022-02-26 Washington Florida 12133 6580 100
2249381 2249381 2022-02-25 Washington Florida 12133 6580 100
2246130 2246130 2022-02-24 Washington Florida 12133 6568 100
2242879 2242879 2022-02-23 Washington Florida 12133 6568 100
2239628 2239628 2022-02-22 Washington Florida 12133 6568 90
2236377 2236377 2022-02-21 Washington Florida 12133 6568 90
2233126 2233126 2022-02-20 Washington Florida 12133 6568 90
2229875 2229875 2022-02-19 Washington Florida 12133 6568 90
2226624 2226624 2022-02-18 Washington Florida 12133 6568 90
2223373 2223373 2022-02-17 Washington Florida 12133 6522 90
2220122 2220122 2022-02-16 Washington Florida 12133 6522 90
2216871 2216871 2022-02-15 Washington Florida 12133 6522 87
2213620 2213620 2022-02-14 Washington Florida 12133 6522 87
2210368 2210368 2022-02-13 Washington Florida 12133 6522 87
2207115 2207115 2022-02-12 Washington Florida 12133 6522 87
2203862 2203862 2022-02-11 Washington Florida 12133 6522 87
2200609 2200609 2022-02-10 Washington Florida 12133 6463 87
2197355 2197355 2022-02-09 Washington Florida 12133 6463 87
2194101 2194101 2022-02-08 Washington Florida 12133 6463 87
2190847 2190847 2022-02-07 Washington Florida 12133 6463 87
2187594 2187594 2022-02-06 Washington Florida 12133 6463 87
2184341 2184341 2022-02-05 Washington Florida 12133 6463 87
2181089 2181089 2022-02-04 Washington Florida 12133 6463 87
2177838 2177838 2022-02-03 Washington Florida 12133 6261 87

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