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 fips = 36027 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

  • 36027 · 793 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501440 2501440 2022-05-13 Dutchess New York 36027 66962 659
2498182 2498182 2022-05-12 Dutchess New York 36027 66962 659
2494924 2494924 2022-05-11 Dutchess New York 36027 66790 659
2491666 2491666 2022-05-10 Dutchess New York 36027 66665 659
2488408 2488408 2022-05-09 Dutchess New York 36027 66576 659
2485151 2485151 2022-05-08 Dutchess New York 36027 66472 659
2481893 2481893 2022-05-07 Dutchess New York 36027 66359 658
2478635 2478635 2022-05-06 Dutchess New York 36027 66243 658
2475377 2475377 2022-05-05 Dutchess New York 36027 66111 658
2472120 2472120 2022-05-04 Dutchess New York 36027 65963 658
2468864 2468864 2022-05-03 Dutchess New York 36027 65842 658
2465608 2465608 2022-05-02 Dutchess New York 36027 65770 657
2462353 2462353 2022-05-01 Dutchess New York 36027 65707 657
2459097 2459097 2022-04-30 Dutchess New York 36027 65626 657
2455841 2455841 2022-04-29 Dutchess New York 36027 65518 657
2452585 2452585 2022-04-28 Dutchess New York 36027 65438 657
2449329 2449329 2022-04-27 Dutchess New York 36027 65335 657
2446072 2446072 2022-04-26 Dutchess New York 36027 65263 657
2442817 2442817 2022-04-25 Dutchess New York 36027 65217 657
2439561 2439561 2022-04-24 Dutchess New York 36027 65172 657
2436305 2436305 2022-04-23 Dutchess New York 36027 65096 656
2433049 2433049 2022-04-22 Dutchess New York 36027 65008 656
2429793 2429793 2022-04-21 Dutchess New York 36027 64865 656
2426537 2426537 2022-04-20 Dutchess New York 36027 64773 656
2423281 2423281 2022-04-19 Dutchess New York 36027 64709 656
2420024 2420024 2022-04-18 Dutchess New York 36027 64672 655
2416769 2416769 2022-04-17 Dutchess New York 36027 64620 655
2413513 2413513 2022-04-16 Dutchess New York 36027 64574 655
2410257 2410257 2022-04-15 Dutchess New York 36027 64519 655
2407001 2407001 2022-04-14 Dutchess New York 36027 64454 655
2403745 2403745 2022-04-13 Dutchess New York 36027 64381 655
2400490 2400490 2022-04-12 Dutchess New York 36027 64320 655
2397235 2397235 2022-04-11 Dutchess New York 36027 64288 655
2393980 2393980 2022-04-10 Dutchess New York 36027 64250 655
2390724 2390724 2022-04-09 Dutchess New York 36027 64215 655
2387468 2387468 2022-04-08 Dutchess New York 36027 64152 655
2384213 2384213 2022-04-07 Dutchess New York 36027 64095 655
2380958 2380958 2022-04-06 Dutchess New York 36027 64040 655
2377703 2377703 2022-04-05 Dutchess New York 36027 63983 655
2374450 2374450 2022-04-04 Dutchess New York 36027 63960 655
2371198 2371198 2022-04-03 Dutchess New York 36027 63946 655
2367945 2367945 2022-04-02 Dutchess New York 36027 63897 655
2364692 2364692 2022-04-01 Dutchess New York 36027 63856 655
2361438 2361438 2022-03-31 Dutchess New York 36027 63811 655
2358184 2358184 2022-03-30 Dutchess New York 36027 63785 655
2354930 2354930 2022-03-29 Dutchess New York 36027 63766 655
2351677 2351677 2022-03-28 Dutchess New York 36027 63747 655
2348425 2348425 2022-03-27 Dutchess New York 36027 63726 655
2345172 2345172 2022-03-26 Dutchess New York 36027 63707 655
2341919 2341919 2022-03-25 Dutchess New York 36027 63669 655
2338666 2338666 2022-03-24 Dutchess New York 36027 63651 655
2335412 2335412 2022-03-23 Dutchess New York 36027 63628 655
2332158 2332158 2022-03-22 Dutchess New York 36027 63593 655
2328905 2328905 2022-03-21 Dutchess New York 36027 63584 655
2325653 2325653 2022-03-20 Dutchess New York 36027 63577 655
2322400 2322400 2022-03-19 Dutchess New York 36027 63558 654
2319146 2319146 2022-03-18 Dutchess New York 36027 63530 653
2315892 2315892 2022-03-17 Dutchess New York 36027 63499 653
2312639 2312639 2022-03-16 Dutchess New York 36027 63478 653
2309386 2309386 2022-03-15 Dutchess New York 36027 63465 651
2306133 2306133 2022-03-14 Dutchess New York 36027 63439 651
2302882 2302882 2022-03-13 Dutchess New York 36027 63428 651
2299630 2299630 2022-03-12 Dutchess New York 36027 63417 651
2296378 2296378 2022-03-11 Dutchess New York 36027 63391 651
2293126 2293126 2022-03-10 Dutchess New York 36027 63377 650
2289874 2289874 2022-03-09 Dutchess New York 36027 63357 650
2286622 2286622 2022-03-08 Dutchess New York 36027 63340 650
2283370 2283370 2022-03-07 Dutchess New York 36027 63329 650
2280118 2280118 2022-03-06 Dutchess New York 36027 63317 650
2276865 2276865 2022-03-05 Dutchess New York 36027 63297 650
2273612 2273612 2022-03-04 Dutchess New York 36027 63256 649
2270359 2270359 2022-03-03 Dutchess New York 36027 63256 649
2267107 2267107 2022-03-02 Dutchess New York 36027 63209 649
2263855 2263855 2022-03-01 Dutchess New York 36027 63189 648
2260604 2260604 2022-02-28 Dutchess New York 36027 63182 648
2257353 2257353 2022-02-27 Dutchess New York 36027 63162 648
2254102 2254102 2022-02-26 Dutchess New York 36027 63148 648
2250851 2250851 2022-02-25 Dutchess New York 36027 63110 648
2247600 2247600 2022-02-24 Dutchess New York 36027 63072 647
2244349 2244349 2022-02-23 Dutchess New York 36027 63041 646
2241098 2241098 2022-02-22 Dutchess New York 36027 63010 645
2237847 2237847 2022-02-21 Dutchess New York 36027 62981 645
2234596 2234596 2022-02-20 Dutchess New York 36027 62966 645
2231345 2231345 2022-02-19 Dutchess New York 36027 62941 645
2228094 2228094 2022-02-18 Dutchess New York 36027 62902 645
2224843 2224843 2022-02-17 Dutchess New York 36027 62853 644
2221592 2221592 2022-02-16 Dutchess New York 36027 62804 644
2218341 2218341 2022-02-15 Dutchess New York 36027 62776 643
2215090 2215090 2022-02-14 Dutchess New York 36027 62749 641
2211839 2211839 2022-02-13 Dutchess New York 36027 62716 640
2208586 2208586 2022-02-12 Dutchess New York 36027 62659 636
2205333 2205333 2022-02-11 Dutchess New York 36027 62614 636
2202080 2202080 2022-02-10 Dutchess New York 36027 62548 631
2198826 2198826 2022-02-09 Dutchess New York 36027 62462 629
2195572 2195572 2022-02-08 Dutchess New York 36027 62353 627
2192318 2192318 2022-02-07 Dutchess New York 36027 62287 625
2189064 2189064 2022-02-06 Dutchess New York 36027 62229 620
2185811 2185811 2022-02-05 Dutchess New York 36027 62194 620
2182559 2182559 2022-02-04 Dutchess New York 36027 62088 620
2179307 2179307 2022-02-03 Dutchess New York 36027 61983 617

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