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 = 36025 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

  • 36025 · 793 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501439 2501439 2022-05-13 Delaware New York 36025 8261 72
2498181 2498181 2022-05-12 Delaware New York 36025 8261 72
2494923 2494923 2022-05-11 Delaware New York 36025 8239 72
2491665 2491665 2022-05-10 Delaware New York 36025 8221 72
2488407 2488407 2022-05-09 Delaware New York 36025 8199 72
2485150 2485150 2022-05-08 Delaware New York 36025 8195 72
2481892 2481892 2022-05-07 Delaware New York 36025 8182 72
2478634 2478634 2022-05-06 Delaware New York 36025 8171 72
2475376 2475376 2022-05-05 Delaware New York 36025 8150 72
2472119 2472119 2022-05-04 Delaware New York 36025 8136 72
2468863 2468863 2022-05-03 Delaware New York 36025 8113 72
2465607 2465607 2022-05-02 Delaware New York 36025 8108 72
2462352 2462352 2022-05-01 Delaware New York 36025 8103 72
2459096 2459096 2022-04-30 Delaware New York 36025 8095 72
2455840 2455840 2022-04-29 Delaware New York 36025 8078 72
2452584 2452584 2022-04-28 Delaware New York 36025 8058 72
2449328 2449328 2022-04-27 Delaware New York 36025 8043 72
2446071 2446071 2022-04-26 Delaware New York 36025 8016 72
2442816 2442816 2022-04-25 Delaware New York 36025 8001 72
2439560 2439560 2022-04-24 Delaware New York 36025 7995 71
2436304 2436304 2022-04-23 Delaware New York 36025 7987 71
2433048 2433048 2022-04-22 Delaware New York 36025 7977 71
2429792 2429792 2022-04-21 Delaware New York 36025 7960 71
2426536 2426536 2022-04-20 Delaware New York 36025 7950 70
2423280 2423280 2022-04-19 Delaware New York 36025 7929 70
2420023 2420023 2022-04-18 Delaware New York 36025 7924 70
2416768 2416768 2022-04-17 Delaware New York 36025 7923 70
2413512 2413512 2022-04-16 Delaware New York 36025 7906 70
2410256 2410256 2022-04-15 Delaware New York 36025 7895 70
2407000 2407000 2022-04-14 Delaware New York 36025 7883 70
2403744 2403744 2022-04-13 Delaware New York 36025 7868 69
2400489 2400489 2022-04-12 Delaware New York 36025 7854 69
2397234 2397234 2022-04-11 Delaware New York 36025 7847 69
2393979 2393979 2022-04-10 Delaware New York 36025 7839 69
2390723 2390723 2022-04-09 Delaware New York 36025 7832 69
2387467 2387467 2022-04-08 Delaware New York 36025 7817 69
2384212 2384212 2022-04-07 Delaware New York 36025 7806 69
2380957 2380957 2022-04-06 Delaware New York 36025 7791 69
2377702 2377702 2022-04-05 Delaware New York 36025 7779 69
2374449 2374449 2022-04-04 Delaware New York 36025 7769 69
2371197 2371197 2022-04-03 Delaware New York 36025 7763 68
2367944 2367944 2022-04-02 Delaware New York 36025 7744 68
2364691 2364691 2022-04-01 Delaware New York 36025 7726 68
2361437 2361437 2022-03-31 Delaware New York 36025 7713 68
2358183 2358183 2022-03-30 Delaware New York 36025 7694 68
2354929 2354929 2022-03-29 Delaware New York 36025 7682 68
2351676 2351676 2022-03-28 Delaware New York 36025 7672 68
2348424 2348424 2022-03-27 Delaware New York 36025 7667 68
2345171 2345171 2022-03-26 Delaware New York 36025 7659 68
2341918 2341918 2022-03-25 Delaware New York 36025 7648 68
2338665 2338665 2022-03-24 Delaware New York 36025 7643 68
2335411 2335411 2022-03-23 Delaware New York 36025 7634 68
2332157 2332157 2022-03-22 Delaware New York 36025 7627 68
2328904 2328904 2022-03-21 Delaware New York 36025 7622 68
2325652 2325652 2022-03-20 Delaware New York 36025 7622 68
2322399 2322399 2022-03-19 Delaware New York 36025 7620 68
2319145 2319145 2022-03-18 Delaware New York 36025 7616 68
2315891 2315891 2022-03-17 Delaware New York 36025 7614 68
2312638 2312638 2022-03-16 Delaware New York 36025 7608 68
2309385 2309385 2022-03-15 Delaware New York 36025 7605 68
2306132 2306132 2022-03-14 Delaware New York 36025 7597 68
2302881 2302881 2022-03-13 Delaware New York 36025 7596 68
2299629 2299629 2022-03-12 Delaware New York 36025 7595 68
2296377 2296377 2022-03-11 Delaware New York 36025 7592 68
2293125 2293125 2022-03-10 Delaware New York 36025 7585 68
2289873 2289873 2022-03-09 Delaware New York 36025 7584 68
2286621 2286621 2022-03-08 Delaware New York 36025 7580 68
2283369 2283369 2022-03-07 Delaware New York 36025 7578 68
2280117 2280117 2022-03-06 Delaware New York 36025 7576 68
2276864 2276864 2022-03-05 Delaware New York 36025 7573 68
2273611 2273611 2022-03-04 Delaware New York 36025 7566 68
2270358 2270358 2022-03-03 Delaware New York 36025 7566 68
2267106 2267106 2022-03-02 Delaware New York 36025 7556 68
2263854 2263854 2022-03-01 Delaware New York 36025 7552 68
2260603 2260603 2022-02-28 Delaware New York 36025 7549 68
2257352 2257352 2022-02-27 Delaware New York 36025 7546 68
2254101 2254101 2022-02-26 Delaware New York 36025 7541 68
2250850 2250850 2022-02-25 Delaware New York 36025 7535 68
2247599 2247599 2022-02-24 Delaware New York 36025 7534 68
2244348 2244348 2022-02-23 Delaware New York 36025 7530 68
2241097 2241097 2022-02-22 Delaware New York 36025 7520 68
2237846 2237846 2022-02-21 Delaware New York 36025 7516 68
2234595 2234595 2022-02-20 Delaware New York 36025 7516 68
2231344 2231344 2022-02-19 Delaware New York 36025 7508 68
2228093 2228093 2022-02-18 Delaware New York 36025 7501 68
2224842 2224842 2022-02-17 Delaware New York 36025 7491 68
2221591 2221591 2022-02-16 Delaware New York 36025 7480 68
2218340 2218340 2022-02-15 Delaware New York 36025 7467 68
2215089 2215089 2022-02-14 Delaware New York 36025 7459 68
2211838 2211838 2022-02-13 Delaware New York 36025 7446 68
2208585 2208585 2022-02-12 Delaware New York 36025 7439 68
2205332 2205332 2022-02-11 Delaware New York 36025 7426 68
2202079 2202079 2022-02-10 Delaware New York 36025 7408 68
2198825 2198825 2022-02-09 Delaware New York 36025 7397 68
2195571 2195571 2022-02-08 Delaware New York 36025 7381 68
2192317 2192317 2022-02-07 Delaware New York 36025 7367 68
2189063 2189063 2022-02-06 Delaware New York 36025 7361 68
2185810 2185810 2022-02-05 Delaware New York 36025 7346 68
2182558 2182558 2022-02-04 Delaware New York 36025 7317 67
2179306 2179306 2022-02-03 Delaware New York 36025 7279 67

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