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

784 rows where fips = 8053 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

  • 8053 · 784 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2499847 2499847 2022-05-13 Hinsdale Colorado 8053 131 0
2496589 2496589 2022-05-12 Hinsdale Colorado 8053 131 0
2493331 2493331 2022-05-11 Hinsdale Colorado 8053 131 0
2490073 2490073 2022-05-10 Hinsdale Colorado 8053 131 0
2486816 2486816 2022-05-09 Hinsdale Colorado 8053 131 0
2483558 2483558 2022-05-08 Hinsdale Colorado 8053 131 0
2480300 2480300 2022-05-07 Hinsdale Colorado 8053 131 0
2477042 2477042 2022-05-06 Hinsdale Colorado 8053 131 0
2473784 2473784 2022-05-05 Hinsdale Colorado 8053 130 0
2470527 2470527 2022-05-04 Hinsdale Colorado 8053 130 0
2467271 2467271 2022-05-03 Hinsdale Colorado 8053 130 0
2464016 2464016 2022-05-02 Hinsdale Colorado 8053 130 0
2460760 2460760 2022-05-01 Hinsdale Colorado 8053 130 0
2457504 2457504 2022-04-30 Hinsdale Colorado 8053 130 0
2454248 2454248 2022-04-29 Hinsdale Colorado 8053 130 0
2450992 2450992 2022-04-28 Hinsdale Colorado 8053 130 0
2447736 2447736 2022-04-27 Hinsdale Colorado 8053 129 0
2444480 2444480 2022-04-26 Hinsdale Colorado 8053 129 0
2441224 2441224 2022-04-25 Hinsdale Colorado 8053 129 0
2437968 2437968 2022-04-24 Hinsdale Colorado 8053 129 0
2434712 2434712 2022-04-23 Hinsdale Colorado 8053 129 0
2431456 2431456 2022-04-22 Hinsdale Colorado 8053 129 0
2428200 2428200 2022-04-21 Hinsdale Colorado 8053 129 0
2424944 2424944 2022-04-20 Hinsdale Colorado 8053 129 0
2421688 2421688 2022-04-19 Hinsdale Colorado 8053 126 0
2418432 2418432 2022-04-18 Hinsdale Colorado 8053 123 0
2415176 2415176 2022-04-17 Hinsdale Colorado 8053 123 0
2411920 2411920 2022-04-16 Hinsdale Colorado 8053 123 0
2408664 2408664 2022-04-15 Hinsdale Colorado 8053 123 0
2405408 2405408 2022-04-14 Hinsdale Colorado 8053 123 0
2402153 2402153 2022-04-13 Hinsdale Colorado 8053 123 0
2398898 2398898 2022-04-12 Hinsdale Colorado 8053 123 0
2395643 2395643 2022-04-11 Hinsdale Colorado 8053 123 0
2392387 2392387 2022-04-10 Hinsdale Colorado 8053 123 0
2389131 2389131 2022-04-09 Hinsdale Colorado 8053 123 0
2385876 2385876 2022-04-08 Hinsdale Colorado 8053 123 0
2382621 2382621 2022-04-07 Hinsdale Colorado 8053 123 0
2379366 2379366 2022-04-06 Hinsdale Colorado 8053 123 0
2376112 2376112 2022-04-05 Hinsdale Colorado 8053 123 0
2372860 2372860 2022-04-04 Hinsdale Colorado 8053 123 0
2369607 2369607 2022-04-03 Hinsdale Colorado 8053 123 0
2366354 2366354 2022-04-02 Hinsdale Colorado 8053 123 0
2363101 2363101 2022-04-01 Hinsdale Colorado 8053 123 0
2359847 2359847 2022-03-31 Hinsdale Colorado 8053 123 0
2356593 2356593 2022-03-30 Hinsdale Colorado 8053 123 0
2353340 2353340 2022-03-29 Hinsdale Colorado 8053 123 0
2350088 2350088 2022-03-28 Hinsdale Colorado 8053 123 0
2346835 2346835 2022-03-27 Hinsdale Colorado 8053 123 0
2343582 2343582 2022-03-26 Hinsdale Colorado 8053 123 0
2340329 2340329 2022-03-25 Hinsdale Colorado 8053 123 0
2337076 2337076 2022-03-24 Hinsdale Colorado 8053 123 0
2333822 2333822 2022-03-23 Hinsdale Colorado 8053 123 0
2330568 2330568 2022-03-22 Hinsdale Colorado 8053 123 0
2327316 2327316 2022-03-21 Hinsdale Colorado 8053 123 0
2324063 2324063 2022-03-20 Hinsdale Colorado 8053 123 0
2320809 2320809 2022-03-19 Hinsdale Colorado 8053 123 0
2317555 2317555 2022-03-18 Hinsdale Colorado 8053 123 0
2314302 2314302 2022-03-17 Hinsdale Colorado 8053 123 0
2311049 2311049 2022-03-16 Hinsdale Colorado 8053 123 0
2307796 2307796 2022-03-15 Hinsdale Colorado 8053 123 0
2304545 2304545 2022-03-14 Hinsdale Colorado 8053 123 0
2301293 2301293 2022-03-13 Hinsdale Colorado 8053 123 0
2298041 2298041 2022-03-12 Hinsdale Colorado 8053 123 0
2294789 2294789 2022-03-11 Hinsdale Colorado 8053 123 0
2291537 2291537 2022-03-10 Hinsdale Colorado 8053 121 0
2288285 2288285 2022-03-09 Hinsdale Colorado 8053 121 0
2285034 2285034 2022-03-08 Hinsdale Colorado 8053 121 0
2281782 2281782 2022-03-07 Hinsdale Colorado 8053 121 0
2278529 2278529 2022-03-06 Hinsdale Colorado 8053 121 0
2275276 2275276 2022-03-05 Hinsdale Colorado 8053 121 0
2272023 2272023 2022-03-04 Hinsdale Colorado 8053 121 0
2268771 2268771 2022-03-03 Hinsdale Colorado 8053 121 0
2265518 2265518 2022-03-02 Hinsdale Colorado 8053 121 0
2262267 2262267 2022-03-01 Hinsdale Colorado 8053 120 0
2259016 2259016 2022-02-28 Hinsdale Colorado 8053 120 0
2255765 2255765 2022-02-27 Hinsdale Colorado 8053 120 0
2252514 2252514 2022-02-26 Hinsdale Colorado 8053 120 0
2249263 2249263 2022-02-25 Hinsdale Colorado 8053 120 0
2246012 2246012 2022-02-24 Hinsdale Colorado 8053 120 0
2242761 2242761 2022-02-23 Hinsdale Colorado 8053 120 0
2239510 2239510 2022-02-22 Hinsdale Colorado 8053 120 0
2236259 2236259 2022-02-21 Hinsdale Colorado 8053 120 0
2233008 2233008 2022-02-20 Hinsdale Colorado 8053 120 0
2229757 2229757 2022-02-19 Hinsdale Colorado 8053 120 0
2226506 2226506 2022-02-18 Hinsdale Colorado 8053 120 0
2223255 2223255 2022-02-17 Hinsdale Colorado 8053 120 0
2220004 2220004 2022-02-16 Hinsdale Colorado 8053 120 0
2216753 2216753 2022-02-15 Hinsdale Colorado 8053 120 0
2213502 2213502 2022-02-14 Hinsdale Colorado 8053 120 0
2210250 2210250 2022-02-13 Hinsdale Colorado 8053 120 0
2206997 2206997 2022-02-12 Hinsdale Colorado 8053 120 0
2203744 2203744 2022-02-11 Hinsdale Colorado 8053 120 0
2200491 2200491 2022-02-10 Hinsdale Colorado 8053 120 0
2197237 2197237 2022-02-09 Hinsdale Colorado 8053 120 0
2193983 2193983 2022-02-08 Hinsdale Colorado 8053 118 0
2190729 2190729 2022-02-07 Hinsdale Colorado 8053 118 0
2187476 2187476 2022-02-06 Hinsdale Colorado 8053 117 0
2184223 2184223 2022-02-05 Hinsdale Colorado 8053 117 0
2180971 2180971 2022-02-04 Hinsdale Colorado 8053 117 0
2177720 2177720 2022-02-03 Hinsdale Colorado 8053 117 0

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