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

762 rows where fips = 56003 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

  • 56003 · 762 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502811 2502811 2022-05-13 Big Horn Wyoming 56003 2586 61
2499553 2499553 2022-05-12 Big Horn Wyoming 56003 2586 61
2496295 2496295 2022-05-11 Big Horn Wyoming 56003 2586 61
2493037 2493037 2022-05-10 Big Horn Wyoming 56003 2586 61
2489779 2489779 2022-05-09 Big Horn Wyoming 56003 2583 61
2486522 2486522 2022-05-08 Big Horn Wyoming 56003 2583 61
2483264 2483264 2022-05-07 Big Horn Wyoming 56003 2583 61
2480006 2480006 2022-05-06 Big Horn Wyoming 56003 2583 61
2476748 2476748 2022-05-05 Big Horn Wyoming 56003 2583 61
2473490 2473490 2022-05-04 Big Horn Wyoming 56003 2583 61
2470233 2470233 2022-05-03 Big Horn Wyoming 56003 2583 61
2466977 2466977 2022-05-02 Big Horn Wyoming 56003 2583 61
2463722 2463722 2022-05-01 Big Horn Wyoming 56003 2583 61
2460466 2460466 2022-04-30 Big Horn Wyoming 56003 2583 61
2457210 2457210 2022-04-29 Big Horn Wyoming 56003 2583 61
2453954 2453954 2022-04-28 Big Horn Wyoming 56003 2583 61
2450698 2450698 2022-04-27 Big Horn Wyoming 56003 2583 61
2447442 2447442 2022-04-26 Big Horn Wyoming 56003 2583 61
2444186 2444186 2022-04-25 Big Horn Wyoming 56003 2580 60
2440930 2440930 2022-04-24 Big Horn Wyoming 56003 2580 60
2437674 2437674 2022-04-23 Big Horn Wyoming 56003 2580 60
2434418 2434418 2022-04-22 Big Horn Wyoming 56003 2580 60
2431162 2431162 2022-04-21 Big Horn Wyoming 56003 2580 60
2427906 2427906 2022-04-20 Big Horn Wyoming 56003 2580 60
2424650 2424650 2022-04-19 Big Horn Wyoming 56003 2580 60
2421394 2421394 2022-04-18 Big Horn Wyoming 56003 2579 60
2418138 2418138 2022-04-17 Big Horn Wyoming 56003 2579 60
2414882 2414882 2022-04-16 Big Horn Wyoming 56003 2579 60
2411626 2411626 2022-04-15 Big Horn Wyoming 56003 2579 60
2408370 2408370 2022-04-14 Big Horn Wyoming 56003 2579 60
2405114 2405114 2022-04-13 Big Horn Wyoming 56003 2579 60
2401859 2401859 2022-04-12 Big Horn Wyoming 56003 2579 60
2398604 2398604 2022-04-11 Big Horn Wyoming 56003 2579 60
2395349 2395349 2022-04-10 Big Horn Wyoming 56003 2579 60
2392093 2392093 2022-04-09 Big Horn Wyoming 56003 2579 60
2388837 2388837 2022-04-08 Big Horn Wyoming 56003 2579 60
2385582 2385582 2022-04-07 Big Horn Wyoming 56003 2579 60
2382327 2382327 2022-04-06 Big Horn Wyoming 56003 2579 60
2379072 2379072 2022-04-05 Big Horn Wyoming 56003 2579 60
2375818 2375818 2022-04-04 Big Horn Wyoming 56003 2578 60
2372566 2372566 2022-04-03 Big Horn Wyoming 56003 2578 60
2369313 2369313 2022-04-02 Big Horn Wyoming 56003 2578 60
2366060 2366060 2022-04-01 Big Horn Wyoming 56003 2578 60
2362807 2362807 2022-03-31 Big Horn Wyoming 56003 2577 60
2359553 2359553 2022-03-30 Big Horn Wyoming 56003 2577 60
2356299 2356299 2022-03-29 Big Horn Wyoming 56003 2577 60
2353046 2353046 2022-03-28 Big Horn Wyoming 56003 2575 60
2349794 2349794 2022-03-27 Big Horn Wyoming 56003 2575 60
2346541 2346541 2022-03-26 Big Horn Wyoming 56003 2575 60
2343288 2343288 2022-03-25 Big Horn Wyoming 56003 2575 60
2340035 2340035 2022-03-24 Big Horn Wyoming 56003 2575 60
2336782 2336782 2022-03-23 Big Horn Wyoming 56003 2575 60
2333528 2333528 2022-03-22 Big Horn Wyoming 56003 2575 60
2330274 2330274 2022-03-21 Big Horn Wyoming 56003 2575 60
2327022 2327022 2022-03-20 Big Horn Wyoming 56003 2575 60
2323769 2323769 2022-03-19 Big Horn Wyoming 56003 2575 60
2320515 2320515 2022-03-18 Big Horn Wyoming 56003 2575 60
2317261 2317261 2022-03-17 Big Horn Wyoming 56003 2575 60
2314008 2314008 2022-03-16 Big Horn Wyoming 56003 2575 60
2310755 2310755 2022-03-15 Big Horn Wyoming 56003 2575 60
2307502 2307502 2022-03-14 Big Horn Wyoming 56003 2572 60
2304251 2304251 2022-03-13 Big Horn Wyoming 56003 2572 60
2300999 2300999 2022-03-12 Big Horn Wyoming 56003 2572 60
2297747 2297747 2022-03-11 Big Horn Wyoming 56003 2572 60
2294495 2294495 2022-03-10 Big Horn Wyoming 56003 2573 60
2291243 2291243 2022-03-09 Big Horn Wyoming 56003 2573 60
2287991 2287991 2022-03-08 Big Horn Wyoming 56003 2568 60
2284739 2284739 2022-03-07 Big Horn Wyoming 56003 2566 60
2281487 2281487 2022-03-06 Big Horn Wyoming 56003 2567 60
2278234 2278234 2022-03-05 Big Horn Wyoming 56003 2567 60
2274981 2274981 2022-03-04 Big Horn Wyoming 56003 2567 60
2271728 2271728 2022-03-03 Big Horn Wyoming 56003 2565 60
2268476 2268476 2022-03-02 Big Horn Wyoming 56003 2562 60
2265223 2265223 2022-03-01 Big Horn Wyoming 56003 2562 60
2261973 2261973 2022-02-28 Big Horn Wyoming 56003 2561 60
2258722 2258722 2022-02-27 Big Horn Wyoming 56003 2560 60
2255471 2255471 2022-02-26 Big Horn Wyoming 56003 2560 60
2252220 2252220 2022-02-25 Big Horn Wyoming 56003 2560 60
2248969 2248969 2022-02-24 Big Horn Wyoming 56003 2560 60
2245718 2245718 2022-02-23 Big Horn Wyoming 56003 2558 60
2242467 2242467 2022-02-22 Big Horn Wyoming 56003 2559 60
2239216 2239216 2022-02-21 Big Horn Wyoming 56003 2543 60
2235965 2235965 2022-02-20 Big Horn Wyoming 56003 2543 60
2232714 2232714 2022-02-19 Big Horn Wyoming 56003 2543 60
2229463 2229463 2022-02-18 Big Horn Wyoming 56003 2543 60
2226212 2226212 2022-02-17 Big Horn Wyoming 56003 2545 60
2222961 2222961 2022-02-16 Big Horn Wyoming 56003 2542 60
2219710 2219710 2022-02-15 Big Horn Wyoming 56003 2537 60
2216460 2216460 2022-02-14 Big Horn Wyoming 56003 2536 60
2213209 2213209 2022-02-13 Big Horn Wyoming 56003 2524 60
2209956 2209956 2022-02-12 Big Horn Wyoming 56003 2524 60
2206703 2206703 2022-02-11 Big Horn Wyoming 56003 2524 60
2203450 2203450 2022-02-10 Big Horn Wyoming 56003 2516 60
2200196 2200196 2022-02-09 Big Horn Wyoming 56003 2510 60
2196942 2196942 2022-02-08 Big Horn Wyoming 56003 2503 60
2193687 2193687 2022-02-07 Big Horn Wyoming 56003 2497 60
2190434 2190434 2022-02-06 Big Horn Wyoming 56003 2481 60
2187181 2187181 2022-02-05 Big Horn Wyoming 56003 2481 60
2183928 2183928 2022-02-04 Big Horn Wyoming 56003 2481 60
2180676 2180676 2022-02-03 Big Horn Wyoming 56003 2466 60

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