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

788 rows where fips = 36019 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 · 788 ✖

fips 1

  • 36019 · 788 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501436 2501436 2022-05-13 Clinton New York 36019 18034 90
2498178 2498178 2022-05-12 Clinton New York 36019 18034 90
2494920 2494920 2022-05-11 Clinton New York 36019 17976 90
2491662 2491662 2022-05-10 Clinton New York 36019 17948 90
2488404 2488404 2022-05-09 Clinton New York 36019 17912 90
2485147 2485147 2022-05-08 Clinton New York 36019 17888 90
2481889 2481889 2022-05-07 Clinton New York 36019 17832 90
2478631 2478631 2022-05-06 Clinton New York 36019 17777 90
2475373 2475373 2022-05-05 Clinton New York 36019 17736 90
2472116 2472116 2022-05-04 Clinton New York 36019 17671 89
2468860 2468860 2022-05-03 Clinton New York 36019 17649 88
2465604 2465604 2022-05-02 Clinton New York 36019 17630 88
2462349 2462349 2022-05-01 Clinton New York 36019 17602 88
2459093 2459093 2022-04-30 Clinton New York 36019 17567 88
2455837 2455837 2022-04-29 Clinton New York 36019 17528 88
2452581 2452581 2022-04-28 Clinton New York 36019 17457 88
2449325 2449325 2022-04-27 Clinton New York 36019 17407 88
2446068 2446068 2022-04-26 Clinton New York 36019 17373 87
2442813 2442813 2022-04-25 Clinton New York 36019 17348 87
2439557 2439557 2022-04-24 Clinton New York 36019 17322 87
2436301 2436301 2022-04-23 Clinton New York 36019 17289 87
2433045 2433045 2022-04-22 Clinton New York 36019 17259 87
2429789 2429789 2022-04-21 Clinton New York 36019 17222 87
2426533 2426533 2022-04-20 Clinton New York 36019 17173 87
2423277 2423277 2022-04-19 Clinton New York 36019 17156 87
2420020 2420020 2022-04-18 Clinton New York 36019 17142 87
2416765 2416765 2022-04-17 Clinton New York 36019 17109 87
2413509 2413509 2022-04-16 Clinton New York 36019 17073 87
2410253 2410253 2022-04-15 Clinton New York 36019 17032 87
2406997 2406997 2022-04-14 Clinton New York 36019 16992 87
2403741 2403741 2022-04-13 Clinton New York 36019 16976 87
2400486 2400486 2022-04-12 Clinton New York 36019 16952 86
2397231 2397231 2022-04-11 Clinton New York 36019 16941 86
2393976 2393976 2022-04-10 Clinton New York 36019 16920 86
2390720 2390720 2022-04-09 Clinton New York 36019 16893 86
2387464 2387464 2022-04-08 Clinton New York 36019 16860 86
2384209 2384209 2022-04-07 Clinton New York 36019 16825 86
2380954 2380954 2022-04-06 Clinton New York 36019 16791 86
2377699 2377699 2022-04-05 Clinton New York 36019 16775 86
2374446 2374446 2022-04-04 Clinton New York 36019 16757 86
2371194 2371194 2022-04-03 Clinton New York 36019 16745 86
2367941 2367941 2022-04-02 Clinton New York 36019 16732 86
2364688 2364688 2022-04-01 Clinton New York 36019 16717 86
2361434 2361434 2022-03-31 Clinton New York 36019 16700 86
2358180 2358180 2022-03-30 Clinton New York 36019 16682 86
2354926 2354926 2022-03-29 Clinton New York 36019 16668 86
2351673 2351673 2022-03-28 Clinton New York 36019 16665 86
2348421 2348421 2022-03-27 Clinton New York 36019 16655 86
2345168 2345168 2022-03-26 Clinton New York 36019 16641 86
2341915 2341915 2022-03-25 Clinton New York 36019 16628 86
2338662 2338662 2022-03-24 Clinton New York 36019 16602 86
2335408 2335408 2022-03-23 Clinton New York 36019 16574 86
2332154 2332154 2022-03-22 Clinton New York 36019 16562 85
2328901 2328901 2022-03-21 Clinton New York 36019 16558 85
2325649 2325649 2022-03-20 Clinton New York 36019 16552 85
2322396 2322396 2022-03-19 Clinton New York 36019 16546 84
2319142 2319142 2022-03-18 Clinton New York 36019 16531 84
2315888 2315888 2022-03-17 Clinton New York 36019 16511 84
2312635 2312635 2022-03-16 Clinton New York 36019 16501 84
2309382 2309382 2022-03-15 Clinton New York 36019 16489 84
2306129 2306129 2022-03-14 Clinton New York 36019 16485 84
2302878 2302878 2022-03-13 Clinton New York 36019 16479 84
2299626 2299626 2022-03-12 Clinton New York 36019 16467 84
2296374 2296374 2022-03-11 Clinton New York 36019 16460 84
2293122 2293122 2022-03-10 Clinton New York 36019 16434 84
2289870 2289870 2022-03-09 Clinton New York 36019 16422 83
2286618 2286618 2022-03-08 Clinton New York 36019 16417 83
2283366 2283366 2022-03-07 Clinton New York 36019 16405 83
2280114 2280114 2022-03-06 Clinton New York 36019 16389 82
2276861 2276861 2022-03-05 Clinton New York 36019 16368 82
2273608 2273608 2022-03-04 Clinton New York 36019 16337 82
2270355 2270355 2022-03-03 Clinton New York 36019 16337 81
2267103 2267103 2022-03-02 Clinton New York 36019 16305 81
2263851 2263851 2022-03-01 Clinton New York 36019 16289 81
2260600 2260600 2022-02-28 Clinton New York 36019 16276 81
2257349 2257349 2022-02-27 Clinton New York 36019 16260 81
2254098 2254098 2022-02-26 Clinton New York 36019 16242 80
2250847 2250847 2022-02-25 Clinton New York 36019 16223 80
2247596 2247596 2022-02-24 Clinton New York 36019 16195 79
2244345 2244345 2022-02-23 Clinton New York 36019 16161 79
2241094 2241094 2022-02-22 Clinton New York 36019 16141 79
2237843 2237843 2022-02-21 Clinton New York 36019 16122 79
2234592 2234592 2022-02-20 Clinton New York 36019 16100 78
2231341 2231341 2022-02-19 Clinton New York 36019 16066 78
2228090 2228090 2022-02-18 Clinton New York 36019 16034 78
2224839 2224839 2022-02-17 Clinton New York 36019 15981 78
2221588 2221588 2022-02-16 Clinton New York 36019 15914 78
2218337 2218337 2022-02-15 Clinton New York 36019 15882 78
2215086 2215086 2022-02-14 Clinton New York 36019 15859 76
2211835 2211835 2022-02-13 Clinton New York 36019 15813 76
2208582 2208582 2022-02-12 Clinton New York 36019 15758 76
2205329 2205329 2022-02-11 Clinton New York 36019 15677 76
2202076 2202076 2022-02-10 Clinton New York 36019 15581 75
2198822 2198822 2022-02-09 Clinton New York 36019 15500 75
2195568 2195568 2022-02-08 Clinton New York 36019 15451 75
2192314 2192314 2022-02-07 Clinton New York 36019 15424 73
2189060 2189060 2022-02-06 Clinton New York 36019 15371 72
2185807 2185807 2022-02-05 Clinton New York 36019 15327 71
2182555 2182555 2022-02-04 Clinton New York 36019 15242 69
2179303 2179303 2022-02-03 Clinton New York 36019 15134 69

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