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

778 rows where county = "Gem" and state = "Idaho" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Idaho · 778 ✖

fips 1

county 1

  • Gem · 778 ✖
Link rowid date ▲ county state fips cases deaths
2500155 2500155 2022-05-13 Gem Idaho 16045 3681 79
2496897 2496897 2022-05-12 Gem Idaho 16045 3680 79
2493639 2493639 2022-05-11 Gem Idaho 16045 3680 79
2490381 2490381 2022-05-10 Gem Idaho 16045 3676 79
2487124 2487124 2022-05-09 Gem Idaho 16045 3676 79
2483866 2483866 2022-05-08 Gem Idaho 16045 3675 79
2480608 2480608 2022-05-07 Gem Idaho 16045 3675 79
2477350 2477350 2022-05-06 Gem Idaho 16045 3675 79
2474092 2474092 2022-05-05 Gem Idaho 16045 3670 79
2470835 2470835 2022-05-04 Gem Idaho 16045 3670 79
2467579 2467579 2022-05-03 Gem Idaho 16045 3669 79
2464324 2464324 2022-05-02 Gem Idaho 16045 3669 79
2461068 2461068 2022-05-01 Gem Idaho 16045 3668 79
2457812 2457812 2022-04-30 Gem Idaho 16045 3668 79
2454556 2454556 2022-04-29 Gem Idaho 16045 3668 79
2451300 2451300 2022-04-28 Gem Idaho 16045 3664 79
2448044 2448044 2022-04-27 Gem Idaho 16045 3664 79
2444788 2444788 2022-04-26 Gem Idaho 16045 3663 79
2441532 2441532 2022-04-25 Gem Idaho 16045 3663 79
2438276 2438276 2022-04-24 Gem Idaho 16045 3663 79
2435020 2435020 2022-04-23 Gem Idaho 16045 3663 79
2431764 2431764 2022-04-22 Gem Idaho 16045 3663 79
2428508 2428508 2022-04-21 Gem Idaho 16045 3657 79
2425252 2425252 2022-04-20 Gem Idaho 16045 3657 79
2421996 2421996 2022-04-19 Gem Idaho 16045 3640 79
2418740 2418740 2022-04-18 Gem Idaho 16045 3640 79
2415484 2415484 2022-04-17 Gem Idaho 16045 3640 79
2412228 2412228 2022-04-16 Gem Idaho 16045 3640 79
2408972 2408972 2022-04-15 Gem Idaho 16045 3640 79
2405716 2405716 2022-04-14 Gem Idaho 16045 3639 79
2402461 2402461 2022-04-13 Gem Idaho 16045 3638 79
2399206 2399206 2022-04-12 Gem Idaho 16045 3638 79
2395951 2395951 2022-04-11 Gem Idaho 16045 3638 79
2392695 2392695 2022-04-10 Gem Idaho 16045 3637 79
2389439 2389439 2022-04-09 Gem Idaho 16045 3637 79
2386184 2386184 2022-04-08 Gem Idaho 16045 3637 79
2382929 2382929 2022-04-07 Gem Idaho 16045 3637 79
2379674 2379674 2022-04-06 Gem Idaho 16045 3637 79
2376420 2376420 2022-04-05 Gem Idaho 16045 3639 79
2373168 2373168 2022-04-04 Gem Idaho 16045 3639 79
2369915 2369915 2022-04-03 Gem Idaho 16045 3639 79
2366662 2366662 2022-04-02 Gem Idaho 16045 3639 79
2363409 2363409 2022-04-01 Gem Idaho 16045 3639 79
2360155 2360155 2022-03-31 Gem Idaho 16045 3637 79
2356901 2356901 2022-03-30 Gem Idaho 16045 3637 79
2353648 2353648 2022-03-29 Gem Idaho 16045 3637 79
2350396 2350396 2022-03-28 Gem Idaho 16045 3637 79
2347143 2347143 2022-03-27 Gem Idaho 16045 3635 79
2343890 2343890 2022-03-26 Gem Idaho 16045 3635 79
2340637 2340637 2022-03-25 Gem Idaho 16045 3635 79
2337384 2337384 2022-03-24 Gem Idaho 16045 3635 79
2334130 2334130 2022-03-23 Gem Idaho 16045 3634 79
2330876 2330876 2022-03-22 Gem Idaho 16045 3633 79
2327624 2327624 2022-03-21 Gem Idaho 16045 3633 79
2324371 2324371 2022-03-20 Gem Idaho 16045 3633 79
2321117 2321117 2022-03-19 Gem Idaho 16045 3633 79
2317863 2317863 2022-03-18 Gem Idaho 16045 3633 79
2314610 2314610 2022-03-17 Gem Idaho 16045 3632 79
2311357 2311357 2022-03-16 Gem Idaho 16045 3631 79
2308104 2308104 2022-03-15 Gem Idaho 16045 3630 79
2304853 2304853 2022-03-14 Gem Idaho 16045 3629 79
2301601 2301601 2022-03-13 Gem Idaho 16045 3629 79
2298349 2298349 2022-03-12 Gem Idaho 16045 3629 79
2295097 2295097 2022-03-11 Gem Idaho 16045 3629 79
2291845 2291845 2022-03-10 Gem Idaho 16045 3629 79
2288593 2288593 2022-03-09 Gem Idaho 16045 3628 79
2285342 2285342 2022-03-08 Gem Idaho 16045 3628 78
2282090 2282090 2022-03-07 Gem Idaho 16045 3630 78
2278837 2278837 2022-03-06 Gem Idaho 16045 3636 78
2275584 2275584 2022-03-05 Gem Idaho 16045 3636 78
2272331 2272331 2022-03-04 Gem Idaho 16045 3636 78
2269079 2269079 2022-03-03 Gem Idaho 16045 3628 78
2265826 2265826 2022-03-02 Gem Idaho 16045 3620 78
2262575 2262575 2022-03-01 Gem Idaho 16045 3607 78
2259324 2259324 2022-02-28 Gem Idaho 16045 3605 77
2256073 2256073 2022-02-27 Gem Idaho 16045 3597 77
2252822 2252822 2022-02-26 Gem Idaho 16045 3597 77
2249571 2249571 2022-02-25 Gem Idaho 16045 3597 77
2246320 2246320 2022-02-24 Gem Idaho 16045 3582 77
2243069 2243069 2022-02-23 Gem Idaho 16045 3561 77
2239818 2239818 2022-02-22 Gem Idaho 16045 3554 77
2236567 2236567 2022-02-21 Gem Idaho 16045 3548 77
2233316 2233316 2022-02-20 Gem Idaho 16045 3548 77
2230065 2230065 2022-02-19 Gem Idaho 16045 3548 77
2226814 2226814 2022-02-18 Gem Idaho 16045 3540 77
2223563 2223563 2022-02-17 Gem Idaho 16045 3525 77
2220312 2220312 2022-02-16 Gem Idaho 16045 3505 77
2217061 2217061 2022-02-15 Gem Idaho 16045 3484 77
2213810 2213810 2022-02-14 Gem Idaho 16045 3473 77
2210558 2210558 2022-02-13 Gem Idaho 16045 3452 77
2207305 2207305 2022-02-12 Gem Idaho 16045 3452 77
2204052 2204052 2022-02-11 Gem Idaho 16045 3446 77
2200799 2200799 2022-02-10 Gem Idaho 16045 3434 77
2197545 2197545 2022-02-09 Gem Idaho 16045 3402 77
2194291 2194291 2022-02-08 Gem Idaho 16045 3376 77
2191037 2191037 2022-02-07 Gem Idaho 16045 3357 77
2187784 2187784 2022-02-06 Gem Idaho 16045 3346 77
2184531 2184531 2022-02-05 Gem Idaho 16045 3346 77
2181279 2181279 2022-02-04 Gem Idaho 16045 3334 77
2178028 2178028 2022-02-03 Gem Idaho 16045 3325 77

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