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

787 rows where fips = 36017 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 · 787 ✖

fips 1

  • 36017 · 787 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501435 2501435 2022-05-13 Chenango New York 36017 9858 121
2498177 2498177 2022-05-12 Chenango New York 36017 9858 120
2494919 2494919 2022-05-11 Chenango New York 36017 9836 120
2491661 2491661 2022-05-10 Chenango New York 36017 9805 120
2488403 2488403 2022-05-09 Chenango New York 36017 9784 120
2485146 2485146 2022-05-08 Chenango New York 36017 9779 120
2481888 2481888 2022-05-07 Chenango New York 36017 9768 120
2478630 2478630 2022-05-06 Chenango New York 36017 9751 120
2475372 2475372 2022-05-05 Chenango New York 36017 9730 120
2472115 2472115 2022-05-04 Chenango New York 36017 9715 120
2468859 2468859 2022-05-03 Chenango New York 36017 9686 120
2465603 2465603 2022-05-02 Chenango New York 36017 9676 120
2462348 2462348 2022-05-01 Chenango New York 36017 9661 120
2459092 2459092 2022-04-30 Chenango New York 36017 9643 120
2455836 2455836 2022-04-29 Chenango New York 36017 9621 120
2452580 2452580 2022-04-28 Chenango New York 36017 9607 120
2449324 2449324 2022-04-27 Chenango New York 36017 9589 120
2446067 2446067 2022-04-26 Chenango New York 36017 9567 120
2442812 2442812 2022-04-25 Chenango New York 36017 9562 120
2439556 2439556 2022-04-24 Chenango New York 36017 9548 120
2436300 2436300 2022-04-23 Chenango New York 36017 9541 120
2433044 2433044 2022-04-22 Chenango New York 36017 9520 120
2429788 2429788 2022-04-21 Chenango New York 36017 9497 120
2426532 2426532 2022-04-20 Chenango New York 36017 9483 120
2423276 2423276 2022-04-19 Chenango New York 36017 9463 120
2420019 2420019 2022-04-18 Chenango New York 36017 9452 120
2416764 2416764 2022-04-17 Chenango New York 36017 9445 120
2413508 2413508 2022-04-16 Chenango New York 36017 9436 120
2410252 2410252 2022-04-15 Chenango New York 36017 9423 120
2406996 2406996 2022-04-14 Chenango New York 36017 9410 120
2403740 2403740 2022-04-13 Chenango New York 36017 9397 120
2400485 2400485 2022-04-12 Chenango New York 36017 9381 120
2397230 2397230 2022-04-11 Chenango New York 36017 9377 120
2393975 2393975 2022-04-10 Chenango New York 36017 9367 120
2390719 2390719 2022-04-09 Chenango New York 36017 9353 120
2387463 2387463 2022-04-08 Chenango New York 36017 9336 120
2384208 2384208 2022-04-07 Chenango New York 36017 9323 120
2380953 2380953 2022-04-06 Chenango New York 36017 9314 119
2377698 2377698 2022-04-05 Chenango New York 36017 9303 119
2374445 2374445 2022-04-04 Chenango New York 36017 9299 119
2371193 2371193 2022-04-03 Chenango New York 36017 9294 119
2367940 2367940 2022-04-02 Chenango New York 36017 9288 119
2364687 2364687 2022-04-01 Chenango New York 36017 9277 119
2361433 2361433 2022-03-31 Chenango New York 36017 9271 118
2358179 2358179 2022-03-30 Chenango New York 36017 9262 118
2354925 2354925 2022-03-29 Chenango New York 36017 9257 118
2351672 2351672 2022-03-28 Chenango New York 36017 9251 118
2348420 2348420 2022-03-27 Chenango New York 36017 9249 118
2345167 2345167 2022-03-26 Chenango New York 36017 9249 118
2341914 2341914 2022-03-25 Chenango New York 36017 9245 118
2338661 2338661 2022-03-24 Chenango New York 36017 9237 118
2335407 2335407 2022-03-23 Chenango New York 36017 9235 118
2332153 2332153 2022-03-22 Chenango New York 36017 9224 118
2328900 2328900 2022-03-21 Chenango New York 36017 9223 118
2325648 2325648 2022-03-20 Chenango New York 36017 9222 118
2322395 2322395 2022-03-19 Chenango New York 36017 9219 118
2319141 2319141 2022-03-18 Chenango New York 36017 9210 118
2315887 2315887 2022-03-17 Chenango New York 36017 9207 118
2312634 2312634 2022-03-16 Chenango New York 36017 9200 118
2309381 2309381 2022-03-15 Chenango New York 36017 9199 118
2306128 2306128 2022-03-14 Chenango New York 36017 9198 118
2302877 2302877 2022-03-13 Chenango New York 36017 9197 118
2299625 2299625 2022-03-12 Chenango New York 36017 9191 118
2296373 2296373 2022-03-11 Chenango New York 36017 9187 118
2293121 2293121 2022-03-10 Chenango New York 36017 9180 118
2289869 2289869 2022-03-09 Chenango New York 36017 9178 118
2286617 2286617 2022-03-08 Chenango New York 36017 9173 118
2283365 2283365 2022-03-07 Chenango New York 36017 9169 117
2280113 2280113 2022-03-06 Chenango New York 36017 9166 117
2276860 2276860 2022-03-05 Chenango New York 36017 9162 117
2273607 2273607 2022-03-04 Chenango New York 36017 9152 117
2270354 2270354 2022-03-03 Chenango New York 36017 9152 117
2267102 2267102 2022-03-02 Chenango New York 36017 9143 117
2263850 2263850 2022-03-01 Chenango New York 36017 9138 117
2260599 2260599 2022-02-28 Chenango New York 36017 9134 117
2257348 2257348 2022-02-27 Chenango New York 36017 9131 117
2254097 2254097 2022-02-26 Chenango New York 36017 9127 117
2250846 2250846 2022-02-25 Chenango New York 36017 9115 117
2247595 2247595 2022-02-24 Chenango New York 36017 9105 117
2244344 2244344 2022-02-23 Chenango New York 36017 9090 117
2241093 2241093 2022-02-22 Chenango New York 36017 9081 117
2237842 2237842 2022-02-21 Chenango New York 36017 9076 117
2234591 2234591 2022-02-20 Chenango New York 36017 9065 117
2231340 2231340 2022-02-19 Chenango New York 36017 9057 117
2228089 2228089 2022-02-18 Chenango New York 36017 9045 117
2224838 2224838 2022-02-17 Chenango New York 36017 9027 117
2221587 2221587 2022-02-16 Chenango New York 36017 9011 117
2218336 2218336 2022-02-15 Chenango New York 36017 8992 116
2215085 2215085 2022-02-14 Chenango New York 36017 8981 116
2211834 2211834 2022-02-13 Chenango New York 36017 8967 115
2208581 2208581 2022-02-12 Chenango New York 36017 8949 115
2205328 2205328 2022-02-11 Chenango New York 36017 8921 115
2202075 2202075 2022-02-10 Chenango New York 36017 8889 115
2198821 2198821 2022-02-09 Chenango New York 36017 8863 115
2195567 2195567 2022-02-08 Chenango New York 36017 8837 115
2192313 2192313 2022-02-07 Chenango New York 36017 8820 115
2189059 2189059 2022-02-06 Chenango New York 36017 8801 115
2185806 2185806 2022-02-05 Chenango New York 36017 8785 115
2182554 2182554 2022-02-04 Chenango New York 36017 8757 114
2179302 2179302 2022-02-03 Chenango New York 36017 8734 114

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