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

793 rows where county = "Herkimer" and state = "New York" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • New York · 793 ✖

fips 1

county 1

  • Herkimer · 793 ✖
Link rowid date ▲ county state fips cases deaths
2501448 2501448 2022-05-13 Herkimer New York 36043 14827 193
2498190 2498190 2022-05-12 Herkimer New York 36043 14827 193
2494932 2494932 2022-05-11 Herkimer New York 36043 14798 193
2491674 2491674 2022-05-10 Herkimer New York 36043 14774 192
2488416 2488416 2022-05-09 Herkimer New York 36043 14741 191
2485159 2485159 2022-05-08 Herkimer New York 36043 14723 191
2481901 2481901 2022-05-07 Herkimer New York 36043 14697 191
2478643 2478643 2022-05-06 Herkimer New York 36043 14665 191
2475385 2475385 2022-05-05 Herkimer New York 36043 14634 190
2472128 2472128 2022-05-04 Herkimer New York 36043 14602 190
2468872 2468872 2022-05-03 Herkimer New York 36043 14562 190
2465616 2465616 2022-05-02 Herkimer New York 36043 14537 190
2462361 2462361 2022-05-01 Herkimer New York 36043 14533 190
2459105 2459105 2022-04-30 Herkimer New York 36043 14517 190
2455849 2455849 2022-04-29 Herkimer New York 36043 14482 190
2452593 2452593 2022-04-28 Herkimer New York 36043 14447 190
2449337 2449337 2022-04-27 Herkimer New York 36043 14413 190
2446080 2446080 2022-04-26 Herkimer New York 36043 14376 190
2442825 2442825 2022-04-25 Herkimer New York 36043 14361 190
2439569 2439569 2022-04-24 Herkimer New York 36043 14347 190
2436313 2436313 2022-04-23 Herkimer New York 36043 14325 190
2433057 2433057 2022-04-22 Herkimer New York 36043 14282 190
2429801 2429801 2022-04-21 Herkimer New York 36043 14247 190
2426545 2426545 2022-04-20 Herkimer New York 36043 14223 190
2423289 2423289 2022-04-19 Herkimer New York 36043 14191 190
2420032 2420032 2022-04-18 Herkimer New York 36043 14165 190
2416777 2416777 2022-04-17 Herkimer New York 36043 14152 190
2413521 2413521 2022-04-16 Herkimer New York 36043 14125 190
2410265 2410265 2022-04-15 Herkimer New York 36043 14098 190
2407009 2407009 2022-04-14 Herkimer New York 36043 14076 190
2403753 2403753 2022-04-13 Herkimer New York 36043 14005 190
2400498 2400498 2022-04-12 Herkimer New York 36043 13968 190
2397243 2397243 2022-04-11 Herkimer New York 36043 13952 190
2393988 2393988 2022-04-10 Herkimer New York 36043 13932 190
2390732 2390732 2022-04-09 Herkimer New York 36043 13903 190
2387476 2387476 2022-04-08 Herkimer New York 36043 13884 190
2384221 2384221 2022-04-07 Herkimer New York 36043 13861 190
2380966 2380966 2022-04-06 Herkimer New York 36043 13844 190
2377711 2377711 2022-04-05 Herkimer New York 36043 13830 190
2374458 2374458 2022-04-04 Herkimer New York 36043 13811 190
2371206 2371206 2022-04-03 Herkimer New York 36043 13803 190
2367953 2367953 2022-04-02 Herkimer New York 36043 13792 189
2364700 2364700 2022-04-01 Herkimer New York 36043 13780 189
2361446 2361446 2022-03-31 Herkimer New York 36043 13761 189
2358192 2358192 2022-03-30 Herkimer New York 36043 13744 189
2354938 2354938 2022-03-29 Herkimer New York 36043 13732 189
2351685 2351685 2022-03-28 Herkimer New York 36043 13723 189
2348433 2348433 2022-03-27 Herkimer New York 36043 13719 189
2345180 2345180 2022-03-26 Herkimer New York 36043 13708 189
2341927 2341927 2022-03-25 Herkimer New York 36043 13702 189
2338674 2338674 2022-03-24 Herkimer New York 36043 13689 189
2335420 2335420 2022-03-23 Herkimer New York 36043 13675 189
2332166 2332166 2022-03-22 Herkimer New York 36043 13661 189
2328913 2328913 2022-03-21 Herkimer New York 36043 13652 189
2325661 2325661 2022-03-20 Herkimer New York 36043 13651 189
2322408 2322408 2022-03-19 Herkimer New York 36043 13643 189
2319154 2319154 2022-03-18 Herkimer New York 36043 13635 189
2315900 2315900 2022-03-17 Herkimer New York 36043 13621 189
2312647 2312647 2022-03-16 Herkimer New York 36043 13617 189
2309394 2309394 2022-03-15 Herkimer New York 36043 13610 189
2306141 2306141 2022-03-14 Herkimer New York 36043 13602 189
2302890 2302890 2022-03-13 Herkimer New York 36043 13600 189
2299638 2299638 2022-03-12 Herkimer New York 36043 13596 189
2296386 2296386 2022-03-11 Herkimer New York 36043 13591 189
2293134 2293134 2022-03-10 Herkimer New York 36043 13584 189
2289882 2289882 2022-03-09 Herkimer New York 36043 13582 189
2286630 2286630 2022-03-08 Herkimer New York 36043 13576 189
2283378 2283378 2022-03-07 Herkimer New York 36043 13570 189
2280126 2280126 2022-03-06 Herkimer New York 36043 13564 188
2276873 2276873 2022-03-05 Herkimer New York 36043 13561 188
2273620 2273620 2022-03-04 Herkimer New York 36043 13549 188
2270367 2270367 2022-03-03 Herkimer New York 36043 13549 188
2267115 2267115 2022-03-02 Herkimer New York 36043 13540 188
2263863 2263863 2022-03-01 Herkimer New York 36043 13532 188
2260612 2260612 2022-02-28 Herkimer New York 36043 13523 188
2257361 2257361 2022-02-27 Herkimer New York 36043 13518 188
2254110 2254110 2022-02-26 Herkimer New York 36043 13511 188
2250859 2250859 2022-02-25 Herkimer New York 36043 13497 187
2247608 2247608 2022-02-24 Herkimer New York 36043 13487 187
2244357 2244357 2022-02-23 Herkimer New York 36043 13476 187
2241106 2241106 2022-02-22 Herkimer New York 36043 13467 187
2237855 2237855 2022-02-21 Herkimer New York 36043 13460 186
2234604 2234604 2022-02-20 Herkimer New York 36043 13457 186
2231353 2231353 2022-02-19 Herkimer New York 36043 13443 186
2228102 2228102 2022-02-18 Herkimer New York 36043 13420 186
2224851 2224851 2022-02-17 Herkimer New York 36043 13397 186
2221600 2221600 2022-02-16 Herkimer New York 36043 13378 186
2218349 2218349 2022-02-15 Herkimer New York 36043 13361 186
2215098 2215098 2022-02-14 Herkimer New York 36043 13353 185
2211847 2211847 2022-02-13 Herkimer New York 36043 13336 185
2208594 2208594 2022-02-12 Herkimer New York 36043 13332 184
2205341 2205341 2022-02-11 Herkimer New York 36043 13321 184
2202088 2202088 2022-02-10 Herkimer New York 36043 13306 184
2198834 2198834 2022-02-09 Herkimer New York 36043 13279 184
2195580 2195580 2022-02-08 Herkimer New York 36043 13247 184
2192326 2192326 2022-02-07 Herkimer New York 36043 13219 183
2189072 2189072 2022-02-06 Herkimer New York 36043 13199 182
2185819 2185819 2022-02-05 Herkimer New York 36043 13173 182
2182567 2182567 2022-02-04 Herkimer New York 36043 13146 182
2179315 2179315 2022-02-03 Herkimer New York 36043 13109 181

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