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

788 rows where county = "Madison" 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 · 788 ✖

fips 1

county 1

  • Madison · 788 ✖
Link rowid date ▲ county state fips cases deaths
2500165 2500165 2022-05-13 Madison Idaho 16065 12674 50
2496907 2496907 2022-05-12 Madison Idaho 16065 12669 50
2493649 2493649 2022-05-11 Madison Idaho 16065 12669 50
2490391 2490391 2022-05-10 Madison Idaho 16065 12669 50
2487134 2487134 2022-05-09 Madison Idaho 16065 12669 50
2483876 2483876 2022-05-08 Madison Idaho 16065 12668 50
2480618 2480618 2022-05-07 Madison Idaho 16065 12668 50
2477360 2477360 2022-05-06 Madison Idaho 16065 12668 50
2474102 2474102 2022-05-05 Madison Idaho 16065 12667 50
2470845 2470845 2022-05-04 Madison Idaho 16065 12667 50
2467589 2467589 2022-05-03 Madison Idaho 16065 12665 50
2464334 2464334 2022-05-02 Madison Idaho 16065 12665 50
2461078 2461078 2022-05-01 Madison Idaho 16065 12663 50
2457822 2457822 2022-04-30 Madison Idaho 16065 12663 50
2454566 2454566 2022-04-29 Madison Idaho 16065 12663 50
2451310 2451310 2022-04-28 Madison Idaho 16065 12664 50
2448054 2448054 2022-04-27 Madison Idaho 16065 12664 50
2444798 2444798 2022-04-26 Madison Idaho 16065 12663 50
2441542 2441542 2022-04-25 Madison Idaho 16065 12663 50
2438286 2438286 2022-04-24 Madison Idaho 16065 12659 50
2435030 2435030 2022-04-23 Madison Idaho 16065 12659 50
2431774 2431774 2022-04-22 Madison Idaho 16065 12659 50
2428518 2428518 2022-04-21 Madison Idaho 16065 12656 50
2425262 2425262 2022-04-20 Madison Idaho 16065 12656 50
2422006 2422006 2022-04-19 Madison Idaho 16065 12655 50
2418750 2418750 2022-04-18 Madison Idaho 16065 12655 50
2415494 2415494 2022-04-17 Madison Idaho 16065 12655 50
2412238 2412238 2022-04-16 Madison Idaho 16065 12655 50
2408982 2408982 2022-04-15 Madison Idaho 16065 12655 50
2405726 2405726 2022-04-14 Madison Idaho 16065 12655 50
2402471 2402471 2022-04-13 Madison Idaho 16065 12653 50
2399216 2399216 2022-04-12 Madison Idaho 16065 12653 50
2395961 2395961 2022-04-11 Madison Idaho 16065 12653 50
2392705 2392705 2022-04-10 Madison Idaho 16065 12652 50
2389449 2389449 2022-04-09 Madison Idaho 16065 12652 50
2386194 2386194 2022-04-08 Madison Idaho 16065 12652 50
2382939 2382939 2022-04-07 Madison Idaho 16065 12651 50
2379684 2379684 2022-04-06 Madison Idaho 16065 12651 50
2376430 2376430 2022-04-05 Madison Idaho 16065 12651 50
2373178 2373178 2022-04-04 Madison Idaho 16065 12652 50
2369925 2369925 2022-04-03 Madison Idaho 16065 12649 50
2366672 2366672 2022-04-02 Madison Idaho 16065 12649 50
2363419 2363419 2022-04-01 Madison Idaho 16065 12649 50
2360165 2360165 2022-03-31 Madison Idaho 16065 12649 50
2356911 2356911 2022-03-30 Madison Idaho 16065 12649 50
2353658 2353658 2022-03-29 Madison Idaho 16065 12648 50
2350406 2350406 2022-03-28 Madison Idaho 16065 12647 50
2347153 2347153 2022-03-27 Madison Idaho 16065 12646 50
2343900 2343900 2022-03-26 Madison Idaho 16065 12646 50
2340647 2340647 2022-03-25 Madison Idaho 16065 12646 50
2337394 2337394 2022-03-24 Madison Idaho 16065 12648 50
2334140 2334140 2022-03-23 Madison Idaho 16065 12648 50
2330886 2330886 2022-03-22 Madison Idaho 16065 12648 50
2327634 2327634 2022-03-21 Madison Idaho 16065 12649 50
2324381 2324381 2022-03-20 Madison Idaho 16065 12648 50
2321127 2321127 2022-03-19 Madison Idaho 16065 12648 50
2317873 2317873 2022-03-18 Madison Idaho 16065 12648 50
2314620 2314620 2022-03-17 Madison Idaho 16065 12653 50
2311367 2311367 2022-03-16 Madison Idaho 16065 12653 50
2308114 2308114 2022-03-15 Madison Idaho 16065 12652 50
2304863 2304863 2022-03-14 Madison Idaho 16065 12651 50
2301611 2301611 2022-03-13 Madison Idaho 16065 12650 50
2298359 2298359 2022-03-12 Madison Idaho 16065 12650 50
2295107 2295107 2022-03-11 Madison Idaho 16065 12650 50
2291855 2291855 2022-03-10 Madison Idaho 16065 12649 50
2288603 2288603 2022-03-09 Madison Idaho 16065 12649 49
2285352 2285352 2022-03-08 Madison Idaho 16065 12648 49
2282100 2282100 2022-03-07 Madison Idaho 16065 12647 49
2278847 2278847 2022-03-06 Madison Idaho 16065 12644 49
2275594 2275594 2022-03-05 Madison Idaho 16065 12644 49
2272341 2272341 2022-03-04 Madison Idaho 16065 12644 49
2269089 2269089 2022-03-03 Madison Idaho 16065 12643 49
2265836 2265836 2022-03-02 Madison Idaho 16065 12643 49
2262585 2262585 2022-03-01 Madison Idaho 16065 12630 49
2259334 2259334 2022-02-28 Madison Idaho 16065 12627 48
2256083 2256083 2022-02-27 Madison Idaho 16065 12622 47
2252832 2252832 2022-02-26 Madison Idaho 16065 12622 47
2249581 2249581 2022-02-25 Madison Idaho 16065 12622 47
2246330 2246330 2022-02-24 Madison Idaho 16065 12620 47
2243079 2243079 2022-02-23 Madison Idaho 16065 12612 47
2239828 2239828 2022-02-22 Madison Idaho 16065 12607 47
2236577 2236577 2022-02-21 Madison Idaho 16065 12594 47
2233326 2233326 2022-02-20 Madison Idaho 16065 12594 47
2230075 2230075 2022-02-19 Madison Idaho 16065 12594 47
2226824 2226824 2022-02-18 Madison Idaho 16065 12592 47
2223573 2223573 2022-02-17 Madison Idaho 16065 12588 47
2220322 2220322 2022-02-16 Madison Idaho 16065 12584 46
2217071 2217071 2022-02-15 Madison Idaho 16065 12580 46
2213820 2213820 2022-02-14 Madison Idaho 16065 12453 45
2210568 2210568 2022-02-13 Madison Idaho 16065 12451 45
2207315 2207315 2022-02-12 Madison Idaho 16065 12451 45
2204062 2204062 2022-02-11 Madison Idaho 16065 12444 45
2200809 2200809 2022-02-10 Madison Idaho 16065 12426 45
2197555 2197555 2022-02-09 Madison Idaho 16065 12402 45
2194301 2194301 2022-02-08 Madison Idaho 16065 12386 44
2191047 2191047 2022-02-07 Madison Idaho 16065 12375 44
2187794 2187794 2022-02-06 Madison Idaho 16065 12355 44
2184541 2184541 2022-02-05 Madison Idaho 16065 12355 44
2181289 2181289 2022-02-04 Madison Idaho 16065 12347 44
2178038 2178038 2022-02-03 Madison Idaho 16065 12322 44

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