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

547 rows where county = "Esmeralda" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

fips 1

county 1

  • Esmeralda · 547 ✖
Link rowid date ▲ county state fips cases deaths
2501348 2501348 2022-05-13 Esmeralda Nevada 32009 109 3
2498090 2498090 2022-05-12 Esmeralda Nevada 32009 109 3
2494832 2494832 2022-05-11 Esmeralda Nevada 32009 109 3
2491574 2491574 2022-05-10 Esmeralda Nevada 32009 107 3
2488316 2488316 2022-05-09 Esmeralda Nevada 32009 107 3
2485059 2485059 2022-05-08 Esmeralda Nevada 32009 107 3
2481801 2481801 2022-05-07 Esmeralda Nevada 32009 107 3
2478543 2478543 2022-05-06 Esmeralda Nevada 32009 107 3
2475285 2475285 2022-05-05 Esmeralda Nevada 32009 107 3
2472028 2472028 2022-05-04 Esmeralda Nevada 32009 107 3
2468772 2468772 2022-05-03 Esmeralda Nevada 32009 108 3
2465516 2465516 2022-05-02 Esmeralda Nevada 32009 108 3
2462261 2462261 2022-05-01 Esmeralda Nevada 32009 108 3
2459005 2459005 2022-04-30 Esmeralda Nevada 32009 108 3
2455749 2455749 2022-04-29 Esmeralda Nevada 32009 108 3
2452493 2452493 2022-04-28 Esmeralda Nevada 32009 108 3
2449237 2449237 2022-04-27 Esmeralda Nevada 32009 108 3
2445980 2445980 2022-04-26 Esmeralda Nevada 32009 109 3
2442725 2442725 2022-04-25 Esmeralda Nevada 32009 109 3
2439469 2439469 2022-04-24 Esmeralda Nevada 32009 109 3
2436213 2436213 2022-04-23 Esmeralda Nevada 32009 109 3
2432957 2432957 2022-04-22 Esmeralda Nevada 32009 109 3
2429701 2429701 2022-04-21 Esmeralda Nevada 32009 109 3
2426445 2426445 2022-04-20 Esmeralda Nevada 32009 109 3
2423189 2423189 2022-04-19 Esmeralda Nevada 32009 109 3
2419932 2419932 2022-04-18 Esmeralda Nevada 32009 109 3
2416677 2416677 2022-04-17 Esmeralda Nevada 32009 109 3
2413421 2413421 2022-04-16 Esmeralda Nevada 32009 109 3
2410165 2410165 2022-04-15 Esmeralda Nevada 32009 109 3
2406909 2406909 2022-04-14 Esmeralda Nevada 32009 109 3
2403653 2403653 2022-04-13 Esmeralda Nevada 32009 109 3
2400398 2400398 2022-04-12 Esmeralda Nevada 32009 109 3
2397143 2397143 2022-04-11 Esmeralda Nevada 32009 109 3
2393888 2393888 2022-04-10 Esmeralda Nevada 32009 109 3
2390632 2390632 2022-04-09 Esmeralda Nevada 32009 109 3
2387376 2387376 2022-04-08 Esmeralda Nevada 32009 109 3
2384121 2384121 2022-04-07 Esmeralda Nevada 32009 109 3
2380866 2380866 2022-04-06 Esmeralda Nevada 32009 109 3
2377611 2377611 2022-04-05 Esmeralda Nevada 32009 109 3
2374358 2374358 2022-04-04 Esmeralda Nevada 32009 109 3
2371106 2371106 2022-04-03 Esmeralda Nevada 32009 109 3
2367853 2367853 2022-04-02 Esmeralda Nevada 32009 109 3
2364600 2364600 2022-04-01 Esmeralda Nevada 32009 109 3
2361346 2361346 2022-03-31 Esmeralda Nevada 32009 109 3
2358092 2358092 2022-03-30 Esmeralda Nevada 32009 109 3
2354839 2354839 2022-03-29 Esmeralda Nevada 32009 109 3
2351586 2351586 2022-03-28 Esmeralda Nevada 32009 109 3
2348334 2348334 2022-03-27 Esmeralda Nevada 32009 109 3
2345081 2345081 2022-03-26 Esmeralda Nevada 32009 109 3
2341828 2341828 2022-03-25 Esmeralda Nevada 32009 109 3
2338575 2338575 2022-03-24 Esmeralda Nevada 32009 109 3
2335321 2335321 2022-03-23 Esmeralda Nevada 32009 109 3
2332067 2332067 2022-03-22 Esmeralda Nevada 32009 109 3
2328814 2328814 2022-03-21 Esmeralda Nevada 32009 109 3
2325562 2325562 2022-03-20 Esmeralda Nevada 32009 109 3
2322308 2322308 2022-03-19 Esmeralda Nevada 32009 109 3
2319054 2319054 2022-03-18 Esmeralda Nevada 32009 109 3
2315801 2315801 2022-03-17 Esmeralda Nevada 32009 109 3
2312548 2312548 2022-03-16 Esmeralda Nevada 32009 109 3
2309295 2309295 2022-03-15 Esmeralda Nevada 32009 90 3
2306043 2306043 2022-03-14 Esmeralda Nevada 32009 90 3
2302792 2302792 2022-03-13 Esmeralda Nevada 32009 90 3
2299540 2299540 2022-03-12 Esmeralda Nevada 32009 90 3
2296288 2296288 2022-03-11 Esmeralda Nevada 32009 90 3
2293036 2293036 2022-03-10 Esmeralda Nevada 32009 90 3
2289784 2289784 2022-03-09 Esmeralda Nevada 32009 90 3
2286532 2286532 2022-03-08 Esmeralda Nevada 32009 90 3
2283280 2283280 2022-03-07 Esmeralda Nevada 32009 90 3
2280027 2280027 2022-03-06 Esmeralda Nevada 32009 90 3
2276774 2276774 2022-03-05 Esmeralda Nevada 32009 90 3
2273521 2273521 2022-03-04 Esmeralda Nevada 32009 90 3
2270269 2270269 2022-03-03 Esmeralda Nevada 32009 90 3
2267016 2267016 2022-03-02 Esmeralda Nevada 32009 90 3
2263765 2263765 2022-03-01 Esmeralda Nevada 32009 90 3
2260514 2260514 2022-02-28 Esmeralda Nevada 32009 90 3
2257263 2257263 2022-02-27 Esmeralda Nevada 32009 90 3
2254012 2254012 2022-02-26 Esmeralda Nevada 32009 90 3
2250761 2250761 2022-02-25 Esmeralda Nevada 32009 90 3
2247510 2247510 2022-02-24 Esmeralda Nevada 32009 90 4
2244259 2244259 2022-02-23 Esmeralda Nevada 32009 90 3
2241008 2241008 2022-02-22 Esmeralda Nevada 32009 89 3
2237757 2237757 2022-02-21 Esmeralda Nevada 32009 88 3
2234506 2234506 2022-02-20 Esmeralda Nevada 32009 88 3
2231255 2231255 2022-02-19 Esmeralda Nevada 32009 88 3
2228004 2228004 2022-02-18 Esmeralda Nevada 32009 88 3
2224753 2224753 2022-02-17 Esmeralda Nevada 32009 88 3
2221502 2221502 2022-02-16 Esmeralda Nevada 32009 88 3
2218251 2218251 2022-02-15 Esmeralda Nevada 32009 88 3
2215000 2215000 2022-02-14 Esmeralda Nevada 32009 88 3
2211748 2211748 2022-02-13 Esmeralda Nevada 32009 88 3
2208495 2208495 2022-02-12 Esmeralda Nevada 32009 88 3
2205242 2205242 2022-02-11 Esmeralda Nevada 32009 88 3
2201989 2201989 2022-02-10 Esmeralda Nevada 32009 87 3
2198735 2198735 2022-02-09 Esmeralda Nevada 32009 87 3
2195481 2195481 2022-02-08 Esmeralda Nevada 32009 87 3
2192227 2192227 2022-02-07 Esmeralda Nevada 32009 87 3
2188974 2188974 2022-02-06 Esmeralda Nevada 32009 87 3
2185721 2185721 2022-02-05 Esmeralda Nevada 32009 87 3
2182469 2182469 2022-02-04 Esmeralda Nevada 32009 87 3
2179217 2179217 2022-02-03 Esmeralda Nevada 32009 87 3

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