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

776 rows where county = "Nevada" and fips = 5099 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

  • 5099 · 776 ✖

county 1

  • Nevada · 776 ✖
Link rowid date ▲ county state fips cases deaths
2499735 2499735 2022-05-13 Nevada Arkansas 5099 2188 46
2496477 2496477 2022-05-12 Nevada Arkansas 5099 2187 46
2493219 2493219 2022-05-11 Nevada Arkansas 5099 2186 46
2489961 2489961 2022-05-10 Nevada Arkansas 5099 2186 46
2486704 2486704 2022-05-09 Nevada Arkansas 5099 2186 46
2483446 2483446 2022-05-08 Nevada Arkansas 5099 2186 46
2480188 2480188 2022-05-07 Nevada Arkansas 5099 2186 46
2476930 2476930 2022-05-06 Nevada Arkansas 5099 2185 46
2473672 2473672 2022-05-05 Nevada Arkansas 5099 2185 46
2470415 2470415 2022-05-04 Nevada Arkansas 5099 2185 46
2467159 2467159 2022-05-03 Nevada Arkansas 5099 2185 46
2463904 2463904 2022-05-02 Nevada Arkansas 5099 2185 46
2460648 2460648 2022-05-01 Nevada Arkansas 5099 2185 46
2457392 2457392 2022-04-30 Nevada Arkansas 5099 2185 46
2454136 2454136 2022-04-29 Nevada Arkansas 5099 2185 46
2450880 2450880 2022-04-28 Nevada Arkansas 5099 2185 46
2447624 2447624 2022-04-27 Nevada Arkansas 5099 2185 46
2444368 2444368 2022-04-26 Nevada Arkansas 5099 2185 45
2441112 2441112 2022-04-25 Nevada Arkansas 5099 2185 45
2437856 2437856 2022-04-24 Nevada Arkansas 5099 2185 45
2434600 2434600 2022-04-23 Nevada Arkansas 5099 2184 45
2431344 2431344 2022-04-22 Nevada Arkansas 5099 2184 45
2428088 2428088 2022-04-21 Nevada Arkansas 5099 2184 45
2424832 2424832 2022-04-20 Nevada Arkansas 5099 2184 45
2421576 2421576 2022-04-19 Nevada Arkansas 5099 2184 45
2418320 2418320 2022-04-18 Nevada Arkansas 5099 2184 45
2415064 2415064 2022-04-17 Nevada Arkansas 5099 2184 45
2411808 2411808 2022-04-16 Nevada Arkansas 5099 2184 45
2408552 2408552 2022-04-15 Nevada Arkansas 5099 2184 45
2405296 2405296 2022-04-14 Nevada Arkansas 5099 2184 45
2402041 2402041 2022-04-13 Nevada Arkansas 5099 2184 45
2398786 2398786 2022-04-12 Nevada Arkansas 5099 2183 45
2395531 2395531 2022-04-11 Nevada Arkansas 5099 2183 45
2392275 2392275 2022-04-10 Nevada Arkansas 5099 2183 45
2389019 2389019 2022-04-09 Nevada Arkansas 5099 2183 45
2385764 2385764 2022-04-08 Nevada Arkansas 5099 2183 45
2382509 2382509 2022-04-07 Nevada Arkansas 5099 2183 45
2379254 2379254 2022-04-06 Nevada Arkansas 5099 2183 45
2376000 2376000 2022-04-05 Nevada Arkansas 5099 2183 45
2372748 2372748 2022-04-04 Nevada Arkansas 5099 2183 45
2369495 2369495 2022-04-03 Nevada Arkansas 5099 2183 45
2366242 2366242 2022-04-02 Nevada Arkansas 5099 2183 45
2362989 2362989 2022-04-01 Nevada Arkansas 5099 2183 45
2359735 2359735 2022-03-31 Nevada Arkansas 5099 2183 45
2356481 2356481 2022-03-30 Nevada Arkansas 5099 2182 45
2353228 2353228 2022-03-29 Nevada Arkansas 5099 2182 45
2349976 2349976 2022-03-28 Nevada Arkansas 5099 2182 45
2346723 2346723 2022-03-27 Nevada Arkansas 5099 2182 45
2343470 2343470 2022-03-26 Nevada Arkansas 5099 2182 45
2340217 2340217 2022-03-25 Nevada Arkansas 5099 2182 45
2336964 2336964 2022-03-24 Nevada Arkansas 5099 2182 45
2333710 2333710 2022-03-23 Nevada Arkansas 5099 2180 44
2330456 2330456 2022-03-22 Nevada Arkansas 5099 2180 44
2327204 2327204 2022-03-21 Nevada Arkansas 5099 2177 44
2323951 2323951 2022-03-20 Nevada Arkansas 5099 2177 44
2320697 2320697 2022-03-19 Nevada Arkansas 5099 2177 44
2317443 2317443 2022-03-18 Nevada Arkansas 5099 2172 44
2314190 2314190 2022-03-17 Nevada Arkansas 5099 2170 44
2310937 2310937 2022-03-16 Nevada Arkansas 5099 2169 44
2307684 2307684 2022-03-15 Nevada Arkansas 5099 2168 44
2304433 2304433 2022-03-14 Nevada Arkansas 5099 2163 44
2301181 2301181 2022-03-13 Nevada Arkansas 5099 2162 44
2297929 2297929 2022-03-12 Nevada Arkansas 5099 2162 44
2294677 2294677 2022-03-11 Nevada Arkansas 5099 2162 44
2291425 2291425 2022-03-10 Nevada Arkansas 5099 2158 44
2288173 2288173 2022-03-09 Nevada Arkansas 5099 2156 44
2284922 2284922 2022-03-08 Nevada Arkansas 5099 2155 44
2281670 2281670 2022-03-07 Nevada Arkansas 5099 2154 44
2278417 2278417 2022-03-06 Nevada Arkansas 5099 2153 44
2275164 2275164 2022-03-05 Nevada Arkansas 5099 2152 44
2271911 2271911 2022-03-04 Nevada Arkansas 5099 2152 44
2268659 2268659 2022-03-03 Nevada Arkansas 5099 2150 44
2265406 2265406 2022-03-02 Nevada Arkansas 5099 2151 44
2262155 2262155 2022-03-01 Nevada Arkansas 5099 2151 44
2258904 2258904 2022-02-28 Nevada Arkansas 5099 2150 44
2255653 2255653 2022-02-27 Nevada Arkansas 5099 2147 44
2252402 2252402 2022-02-26 Nevada Arkansas 5099 2147 44
2249151 2249151 2022-02-25 Nevada Arkansas 5099 2147 44
2245900 2245900 2022-02-24 Nevada Arkansas 5099 2144 44
2242649 2242649 2022-02-23 Nevada Arkansas 5099 2144 44
2239398 2239398 2022-02-22 Nevada Arkansas 5099 2139 44
2236147 2236147 2022-02-21 Nevada Arkansas 5099 2139 44
2232896 2232896 2022-02-20 Nevada Arkansas 5099 2139 44
2229645 2229645 2022-02-19 Nevada Arkansas 5099 2137 44
2226394 2226394 2022-02-18 Nevada Arkansas 5099 2137 44
2223143 2223143 2022-02-17 Nevada Arkansas 5099 2137 43
2219892 2219892 2022-02-16 Nevada Arkansas 5099 2134 43
2216641 2216641 2022-02-15 Nevada Arkansas 5099 2125 43
2213390 2213390 2022-02-14 Nevada Arkansas 5099 2118 43
2210138 2210138 2022-02-13 Nevada Arkansas 5099 2116 43
2206885 2206885 2022-02-12 Nevada Arkansas 5099 2110 43
2203632 2203632 2022-02-11 Nevada Arkansas 5099 2104 43
2200379 2200379 2022-02-10 Nevada Arkansas 5099 2097 43
2197125 2197125 2022-02-09 Nevada Arkansas 5099 2092 43
2193870 2193870 2022-02-08 Nevada Arkansas 5099 2086 43
2190617 2190617 2022-02-07 Nevada Arkansas 5099 2082 43
2187364 2187364 2022-02-06 Nevada Arkansas 5099 2080 43
2184111 2184111 2022-02-05 Nevada Arkansas 5099 2079 43
2180859 2180859 2022-02-04 Nevada Arkansas 5099 2072 42
2177608 2177608 2022-02-03 Nevada Arkansas 5099 2068 42

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