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

780 rows where county = "Payette" 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 · 780 ✖

fips 1

county 1

  • Payette · 780 ✖
Link rowid date ▲ county state fips cases deaths
2500170 2500170 2022-05-13 Payette Idaho 16075 5586 87
2496912 2496912 2022-05-12 Payette Idaho 16075 5584 87
2493654 2493654 2022-05-11 Payette Idaho 16075 5584 87
2490396 2490396 2022-05-10 Payette Idaho 16075 5579 87
2487139 2487139 2022-05-09 Payette Idaho 16075 5579 87
2483881 2483881 2022-05-08 Payette Idaho 16075 5575 87
2480623 2480623 2022-05-07 Payette Idaho 16075 5575 87
2477365 2477365 2022-05-06 Payette Idaho 16075 5575 87
2474107 2474107 2022-05-05 Payette Idaho 16075 5569 87
2470850 2470850 2022-05-04 Payette Idaho 16075 5569 87
2467594 2467594 2022-05-03 Payette Idaho 16075 5562 87
2464339 2464339 2022-05-02 Payette Idaho 16075 5562 87
2461083 2461083 2022-05-01 Payette Idaho 16075 5560 87
2457827 2457827 2022-04-30 Payette Idaho 16075 5560 87
2454571 2454571 2022-04-29 Payette Idaho 16075 5560 87
2451315 2451315 2022-04-28 Payette Idaho 16075 5558 86
2448059 2448059 2022-04-27 Payette Idaho 16075 5558 86
2444803 2444803 2022-04-26 Payette Idaho 16075 5556 86
2441547 2441547 2022-04-25 Payette Idaho 16075 5556 86
2438291 2438291 2022-04-24 Payette Idaho 16075 5552 86
2435035 2435035 2022-04-23 Payette Idaho 16075 5552 86
2431779 2431779 2022-04-22 Payette Idaho 16075 5552 86
2428523 2428523 2022-04-21 Payette Idaho 16075 5537 86
2425267 2425267 2022-04-20 Payette Idaho 16075 5537 86
2422011 2422011 2022-04-19 Payette Idaho 16075 5534 86
2418755 2418755 2022-04-18 Payette Idaho 16075 5534 86
2415499 2415499 2022-04-17 Payette Idaho 16075 5534 86
2412243 2412243 2022-04-16 Payette Idaho 16075 5534 86
2408987 2408987 2022-04-15 Payette Idaho 16075 5534 86
2405731 2405731 2022-04-14 Payette Idaho 16075 5534 86
2402476 2402476 2022-04-13 Payette Idaho 16075 5533 86
2399221 2399221 2022-04-12 Payette Idaho 16075 5532 86
2395966 2395966 2022-04-11 Payette Idaho 16075 5530 86
2392710 2392710 2022-04-10 Payette Idaho 16075 5526 86
2389454 2389454 2022-04-09 Payette Idaho 16075 5526 86
2386199 2386199 2022-04-08 Payette Idaho 16075 5526 86
2382944 2382944 2022-04-07 Payette Idaho 16075 5526 86
2379689 2379689 2022-04-06 Payette Idaho 16075 5526 86
2376435 2376435 2022-04-05 Payette Idaho 16075 5528 86
2373183 2373183 2022-04-04 Payette Idaho 16075 5528 86
2369930 2369930 2022-04-03 Payette Idaho 16075 5529 86
2366677 2366677 2022-04-02 Payette Idaho 16075 5529 86
2363424 2363424 2022-04-01 Payette Idaho 16075 5529 86
2360170 2360170 2022-03-31 Payette Idaho 16075 5530 86
2356916 2356916 2022-03-30 Payette Idaho 16075 5530 86
2353663 2353663 2022-03-29 Payette Idaho 16075 5528 85
2350411 2350411 2022-03-28 Payette Idaho 16075 5528 85
2347158 2347158 2022-03-27 Payette Idaho 16075 5526 85
2343905 2343905 2022-03-26 Payette Idaho 16075 5526 85
2340652 2340652 2022-03-25 Payette Idaho 16075 5526 85
2337399 2337399 2022-03-24 Payette Idaho 16075 5526 85
2334145 2334145 2022-03-23 Payette Idaho 16075 5526 85
2330891 2330891 2022-03-22 Payette Idaho 16075 5525 85
2327639 2327639 2022-03-21 Payette Idaho 16075 5524 85
2324386 2324386 2022-03-20 Payette Idaho 16075 5524 85
2321132 2321132 2022-03-19 Payette Idaho 16075 5524 85
2317878 2317878 2022-03-18 Payette Idaho 16075 5524 85
2314625 2314625 2022-03-17 Payette Idaho 16075 5518 85
2311372 2311372 2022-03-16 Payette Idaho 16075 5518 85
2308119 2308119 2022-03-15 Payette Idaho 16075 5517 85
2304868 2304868 2022-03-14 Payette Idaho 16075 5517 85
2301616 2301616 2022-03-13 Payette Idaho 16075 5517 85
2298364 2298364 2022-03-12 Payette Idaho 16075 5517 85
2295112 2295112 2022-03-11 Payette Idaho 16075 5517 85
2291860 2291860 2022-03-10 Payette Idaho 16075 5516 85
2288608 2288608 2022-03-09 Payette Idaho 16075 5516 84
2285357 2285357 2022-03-08 Payette Idaho 16075 5516 84
2282105 2282105 2022-03-07 Payette Idaho 16075 5513 84
2278852 2278852 2022-03-06 Payette Idaho 16075 5522 84
2275599 2275599 2022-03-05 Payette Idaho 16075 5522 84
2272346 2272346 2022-03-04 Payette Idaho 16075 5522 84
2269094 2269094 2022-03-03 Payette Idaho 16075 5509 84
2265841 2265841 2022-03-02 Payette Idaho 16075 5495 84
2262590 2262590 2022-03-01 Payette Idaho 16075 5480 84
2259339 2259339 2022-02-28 Payette Idaho 16075 5465 84
2256088 2256088 2022-02-27 Payette Idaho 16075 5443 83
2252837 2252837 2022-02-26 Payette Idaho 16075 5443 83
2249586 2249586 2022-02-25 Payette Idaho 16075 5443 83
2246335 2246335 2022-02-24 Payette Idaho 16075 5430 82
2243084 2243084 2022-02-23 Payette Idaho 16075 5403 82
2239833 2239833 2022-02-22 Payette Idaho 16075 5379 82
2236582 2236582 2022-02-21 Payette Idaho 16075 5373 82
2233331 2233331 2022-02-20 Payette Idaho 16075 5373 82
2230080 2230080 2022-02-19 Payette Idaho 16075 5373 82
2226829 2226829 2022-02-18 Payette Idaho 16075 5362 82
2223578 2223578 2022-02-17 Payette Idaho 16075 5338 82
2220327 2220327 2022-02-16 Payette Idaho 16075 5301 82
2217076 2217076 2022-02-15 Payette Idaho 16075 5259 81
2213825 2213825 2022-02-14 Payette Idaho 16075 5215 80
2210573 2210573 2022-02-13 Payette Idaho 16075 5193 80
2207320 2207320 2022-02-12 Payette Idaho 16075 5193 80
2204067 2204067 2022-02-11 Payette Idaho 16075 5182 80
2200814 2200814 2022-02-10 Payette Idaho 16075 5155 80
2197560 2197560 2022-02-09 Payette Idaho 16075 5101 80
2194306 2194306 2022-02-08 Payette Idaho 16075 5068 78
2191052 2191052 2022-02-07 Payette Idaho 16075 5024 78
2187799 2187799 2022-02-06 Payette Idaho 16075 5002 78
2184546 2184546 2022-02-05 Payette Idaho 16075 5002 78
2181294 2181294 2022-02-04 Payette Idaho 16075 4996 78
2178043 2178043 2022-02-03 Payette Idaho 16075 4942 78

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