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 = "Nez Perce" and fips = 16069 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

  • 16069 · 780 ✖

county 1

  • Nez Perce · 780 ✖
Link rowid date ▲ county state fips cases deaths
2500167 2500167 2022-05-13 Nez Perce Idaho 16069 8969 148
2496909 2496909 2022-05-12 Nez Perce Idaho 16069 8967 148
2493651 2493651 2022-05-11 Nez Perce Idaho 16069 8959 148
2490393 2490393 2022-05-10 Nez Perce Idaho 16069 8957 148
2487136 2487136 2022-05-09 Nez Perce Idaho 16069 8950 148
2483878 2483878 2022-05-08 Nez Perce Idaho 16069 8949 148
2480620 2480620 2022-05-07 Nez Perce Idaho 16069 8949 148
2477362 2477362 2022-05-06 Nez Perce Idaho 16069 8949 148
2474104 2474104 2022-05-05 Nez Perce Idaho 16069 8947 148
2470847 2470847 2022-05-04 Nez Perce Idaho 16069 8945 148
2467591 2467591 2022-05-03 Nez Perce Idaho 16069 8943 148
2464336 2464336 2022-05-02 Nez Perce Idaho 16069 8940 148
2461080 2461080 2022-05-01 Nez Perce Idaho 16069 8938 148
2457824 2457824 2022-04-30 Nez Perce Idaho 16069 8938 148
2454568 2454568 2022-04-29 Nez Perce Idaho 16069 8938 148
2451312 2451312 2022-04-28 Nez Perce Idaho 16069 8935 148
2448056 2448056 2022-04-27 Nez Perce Idaho 16069 8935 148
2444800 2444800 2022-04-26 Nez Perce Idaho 16069 8935 148
2441544 2441544 2022-04-25 Nez Perce Idaho 16069 8930 148
2438288 2438288 2022-04-24 Nez Perce Idaho 16069 8925 148
2435032 2435032 2022-04-23 Nez Perce Idaho 16069 8925 148
2431776 2431776 2022-04-22 Nez Perce Idaho 16069 8925 148
2428520 2428520 2022-04-21 Nez Perce Idaho 16069 8923 148
2425264 2425264 2022-04-20 Nez Perce Idaho 16069 8922 148
2422008 2422008 2022-04-19 Nez Perce Idaho 16069 8921 148
2418752 2418752 2022-04-18 Nez Perce Idaho 16069 8921 148
2415496 2415496 2022-04-17 Nez Perce Idaho 16069 8914 148
2412240 2412240 2022-04-16 Nez Perce Idaho 16069 8914 148
2408984 2408984 2022-04-15 Nez Perce Idaho 16069 8914 148
2405728 2405728 2022-04-14 Nez Perce Idaho 16069 8914 148
2402473 2402473 2022-04-13 Nez Perce Idaho 16069 8914 148
2399218 2399218 2022-04-12 Nez Perce Idaho 16069 8913 148
2395963 2395963 2022-04-11 Nez Perce Idaho 16069 8913 148
2392707 2392707 2022-04-10 Nez Perce Idaho 16069 8910 148
2389451 2389451 2022-04-09 Nez Perce Idaho 16069 8910 148
2386196 2386196 2022-04-08 Nez Perce Idaho 16069 8910 148
2382941 2382941 2022-04-07 Nez Perce Idaho 16069 8909 148
2379686 2379686 2022-04-06 Nez Perce Idaho 16069 8909 148
2376432 2376432 2022-04-05 Nez Perce Idaho 16069 8909 148
2373180 2373180 2022-04-04 Nez Perce Idaho 16069 8909 148
2369927 2369927 2022-04-03 Nez Perce Idaho 16069 8909 148
2366674 2366674 2022-04-02 Nez Perce Idaho 16069 8909 148
2363421 2363421 2022-04-01 Nez Perce Idaho 16069 8909 148
2360167 2360167 2022-03-31 Nez Perce Idaho 16069 8909 148
2356913 2356913 2022-03-30 Nez Perce Idaho 16069 8909 148
2353660 2353660 2022-03-29 Nez Perce Idaho 16069 8909 148
2350408 2350408 2022-03-28 Nez Perce Idaho 16069 8909 147
2347155 2347155 2022-03-27 Nez Perce Idaho 16069 8909 147
2343902 2343902 2022-03-26 Nez Perce Idaho 16069 8909 147
2340649 2340649 2022-03-25 Nez Perce Idaho 16069 8909 147
2337396 2337396 2022-03-24 Nez Perce Idaho 16069 8906 147
2334142 2334142 2022-03-23 Nez Perce Idaho 16069 8905 147
2330888 2330888 2022-03-22 Nez Perce Idaho 16069 8905 147
2327636 2327636 2022-03-21 Nez Perce Idaho 16069 8904 145
2324383 2324383 2022-03-20 Nez Perce Idaho 16069 8903 145
2321129 2321129 2022-03-19 Nez Perce Idaho 16069 8903 145
2317875 2317875 2022-03-18 Nez Perce Idaho 16069 8903 145
2314622 2314622 2022-03-17 Nez Perce Idaho 16069 8903 145
2311369 2311369 2022-03-16 Nez Perce Idaho 16069 8902 145
2308116 2308116 2022-03-15 Nez Perce Idaho 16069 8902 145
2304865 2304865 2022-03-14 Nez Perce Idaho 16069 8899 145
2301613 2301613 2022-03-13 Nez Perce Idaho 16069 8898 145
2298361 2298361 2022-03-12 Nez Perce Idaho 16069 8898 145
2295109 2295109 2022-03-11 Nez Perce Idaho 16069 8898 145
2291857 2291857 2022-03-10 Nez Perce Idaho 16069 8898 145
2288605 2288605 2022-03-09 Nez Perce Idaho 16069 8894 144
2285354 2285354 2022-03-08 Nez Perce Idaho 16069 8892 142
2282102 2282102 2022-03-07 Nez Perce Idaho 16069 8891 142
2278849 2278849 2022-03-06 Nez Perce Idaho 16069 8886 140
2275596 2275596 2022-03-05 Nez Perce Idaho 16069 8886 140
2272343 2272343 2022-03-04 Nez Perce Idaho 16069 8886 140
2269091 2269091 2022-03-03 Nez Perce Idaho 16069 8880 139
2265838 2265838 2022-03-02 Nez Perce Idaho 16069 8873 139
2262587 2262587 2022-03-01 Nez Perce Idaho 16069 8867 138
2259336 2259336 2022-02-28 Nez Perce Idaho 16069 8866 138
2256085 2256085 2022-02-27 Nez Perce Idaho 16069 8858 138
2252834 2252834 2022-02-26 Nez Perce Idaho 16069 8858 138
2249583 2249583 2022-02-25 Nez Perce Idaho 16069 8858 138
2246332 2246332 2022-02-24 Nez Perce Idaho 16069 8852 138
2243081 2243081 2022-02-23 Nez Perce Idaho 16069 8845 138
2239830 2239830 2022-02-22 Nez Perce Idaho 16069 8831 138
2236579 2236579 2022-02-21 Nez Perce Idaho 16069 8799 137
2233328 2233328 2022-02-20 Nez Perce Idaho 16069 8799 137
2230077 2230077 2022-02-19 Nez Perce Idaho 16069 8799 137
2226826 2226826 2022-02-18 Nez Perce Idaho 16069 8799 137
2223575 2223575 2022-02-17 Nez Perce Idaho 16069 8786 136
2220324 2220324 2022-02-16 Nez Perce Idaho 16069 8771 136
2217073 2217073 2022-02-15 Nez Perce Idaho 16069 8739 136
2213822 2213822 2022-02-14 Nez Perce Idaho 16069 8710 130
2210570 2210570 2022-02-13 Nez Perce Idaho 16069 8673 130
2207317 2207317 2022-02-12 Nez Perce Idaho 16069 8673 130
2204064 2204064 2022-02-11 Nez Perce Idaho 16069 8673 130
2200811 2200811 2022-02-10 Nez Perce Idaho 16069 8644 130
2197557 2197557 2022-02-09 Nez Perce Idaho 16069 8619 130
2194303 2194303 2022-02-08 Nez Perce Idaho 16069 8584 128
2191049 2191049 2022-02-07 Nez Perce Idaho 16069 8558 128
2187796 2187796 2022-02-06 Nez Perce Idaho 16069 8489 128
2184543 2184543 2022-02-05 Nez Perce Idaho 16069 8489 128
2181291 2181291 2022-02-04 Nez Perce Idaho 16069 8482 127
2178040 2178040 2022-02-03 Nez Perce Idaho 16069 8458 125

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