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

789 rows where county = "Allegany" 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 · 789 ✖

fips 1

county 1

  • Allegany · 789 ✖
Link rowid date ▲ county state fips cases deaths
2501429 2501429 2022-05-13 Allegany New York 36003 9275 155
2498171 2498171 2022-05-12 Allegany New York 36003 9275 154
2494913 2494913 2022-05-11 Allegany New York 36003 9258 154
2491655 2491655 2022-05-10 Allegany New York 36003 9243 154
2488397 2488397 2022-05-09 Allegany New York 36003 9234 154
2485140 2485140 2022-05-08 Allegany New York 36003 9226 154
2481882 2481882 2022-05-07 Allegany New York 36003 9212 154
2478624 2478624 2022-05-06 Allegany New York 36003 9185 154
2475366 2475366 2022-05-05 Allegany New York 36003 9168 154
2472109 2472109 2022-05-04 Allegany New York 36003 9147 154
2468853 2468853 2022-05-03 Allegany New York 36003 9123 154
2465597 2465597 2022-05-02 Allegany New York 36003 9109 154
2462342 2462342 2022-05-01 Allegany New York 36003 9108 154
2459086 2459086 2022-04-30 Allegany New York 36003 9100 154
2455830 2455830 2022-04-29 Allegany New York 36003 9091 154
2452574 2452574 2022-04-28 Allegany New York 36003 9077 154
2449318 2449318 2022-04-27 Allegany New York 36003 9063 154
2446061 2446061 2022-04-26 Allegany New York 36003 9054 154
2442806 2442806 2022-04-25 Allegany New York 36003 9053 154
2439550 2439550 2022-04-24 Allegany New York 36003 9047 154
2436294 2436294 2022-04-23 Allegany New York 36003 9037 154
2433038 2433038 2022-04-22 Allegany New York 36003 9027 154
2429782 2429782 2022-04-21 Allegany New York 36003 9015 154
2426526 2426526 2022-04-20 Allegany New York 36003 9004 154
2423270 2423270 2022-04-19 Allegany New York 36003 8999 154
2420013 2420013 2022-04-18 Allegany New York 36003 8988 154
2416758 2416758 2022-04-17 Allegany New York 36003 8986 154
2413502 2413502 2022-04-16 Allegany New York 36003 8984 154
2410246 2410246 2022-04-15 Allegany New York 36003 8972 154
2406990 2406990 2022-04-14 Allegany New York 36003 8966 154
2403734 2403734 2022-04-13 Allegany New York 36003 8959 154
2400479 2400479 2022-04-12 Allegany New York 36003 8955 154
2397224 2397224 2022-04-11 Allegany New York 36003 8955 154
2393969 2393969 2022-04-10 Allegany New York 36003 8954 154
2390713 2390713 2022-04-09 Allegany New York 36003 8952 154
2387457 2387457 2022-04-08 Allegany New York 36003 8948 154
2384202 2384202 2022-04-07 Allegany New York 36003 8938 154
2380947 2380947 2022-04-06 Allegany New York 36003 8931 154
2377692 2377692 2022-04-05 Allegany New York 36003 8929 154
2374439 2374439 2022-04-04 Allegany New York 36003 8929 154
2371187 2371187 2022-04-03 Allegany New York 36003 8927 154
2367934 2367934 2022-04-02 Allegany New York 36003 8926 154
2364681 2364681 2022-04-01 Allegany New York 36003 8923 154
2361427 2361427 2022-03-31 Allegany New York 36003 8914 154
2358173 2358173 2022-03-30 Allegany New York 36003 8910 154
2354919 2354919 2022-03-29 Allegany New York 36003 8907 154
2351666 2351666 2022-03-28 Allegany New York 36003 8907 154
2348414 2348414 2022-03-27 Allegany New York 36003 8903 154
2345161 2345161 2022-03-26 Allegany New York 36003 8899 154
2341908 2341908 2022-03-25 Allegany New York 36003 8896 154
2338655 2338655 2022-03-24 Allegany New York 36003 8891 154
2335401 2335401 2022-03-23 Allegany New York 36003 8886 154
2332147 2332147 2022-03-22 Allegany New York 36003 8878 154
2328894 2328894 2022-03-21 Allegany New York 36003 8877 153
2325642 2325642 2022-03-20 Allegany New York 36003 8877 153
2322389 2322389 2022-03-19 Allegany New York 36003 8876 153
2319135 2319135 2022-03-18 Allegany New York 36003 8869 153
2315881 2315881 2022-03-17 Allegany New York 36003 8866 153
2312628 2312628 2022-03-16 Allegany New York 36003 8864 152
2309375 2309375 2022-03-15 Allegany New York 36003 8860 152
2306122 2306122 2022-03-14 Allegany New York 36003 8855 151
2302871 2302871 2022-03-13 Allegany New York 36003 8852 151
2299619 2299619 2022-03-12 Allegany New York 36003 8851 151
2296367 2296367 2022-03-11 Allegany New York 36003 8847 151
2293115 2293115 2022-03-10 Allegany New York 36003 8836 151
2289863 2289863 2022-03-09 Allegany New York 36003 8834 151
2286611 2286611 2022-03-08 Allegany New York 36003 8830 151
2283359 2283359 2022-03-07 Allegany New York 36003 8826 150
2280107 2280107 2022-03-06 Allegany New York 36003 8826 150
2276854 2276854 2022-03-05 Allegany New York 36003 8824 149
2273601 2273601 2022-03-04 Allegany New York 36003 8806 149
2270348 2270348 2022-03-03 Allegany New York 36003 8806 149
2267096 2267096 2022-03-02 Allegany New York 36003 8804 149
2263844 2263844 2022-03-01 Allegany New York 36003 8800 149
2260593 2260593 2022-02-28 Allegany New York 36003 8795 149
2257342 2257342 2022-02-27 Allegany New York 36003 8791 148
2254091 2254091 2022-02-26 Allegany New York 36003 8786 148
2250840 2250840 2022-02-25 Allegany New York 36003 8777 148
2247589 2247589 2022-02-24 Allegany New York 36003 8760 148
2244338 2244338 2022-02-23 Allegany New York 36003 8748 148
2241087 2241087 2022-02-22 Allegany New York 36003 8740 147
2237836 2237836 2022-02-21 Allegany New York 36003 8734 147
2234585 2234585 2022-02-20 Allegany New York 36003 8730 147
2231334 2231334 2022-02-19 Allegany New York 36003 8721 147
2228083 2228083 2022-02-18 Allegany New York 36003 8707 146
2224832 2224832 2022-02-17 Allegany New York 36003 8693 146
2221581 2221581 2022-02-16 Allegany New York 36003 8670 146
2218330 2218330 2022-02-15 Allegany New York 36003 8654 146
2215079 2215079 2022-02-14 Allegany New York 36003 8636 146
2211828 2211828 2022-02-13 Allegany New York 36003 8623 146
2208575 2208575 2022-02-12 Allegany New York 36003 8611 146
2205322 2205322 2022-02-11 Allegany New York 36003 8593 146
2202069 2202069 2022-02-10 Allegany New York 36003 8573 146
2198815 2198815 2022-02-09 Allegany New York 36003 8545 146
2195561 2195561 2022-02-08 Allegany New York 36003 8517 146
2192307 2192307 2022-02-07 Allegany New York 36003 8504 145
2189053 2189053 2022-02-06 Allegany New York 36003 8486 144
2185800 2185800 2022-02-05 Allegany New York 36003 8459 144
2182548 2182548 2022-02-04 Allegany New York 36003 8432 144
2179296 2179296 2022-02-03 Allegany New York 36003 8406 144

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