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 = 36041 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: deaths, date (date)

state 1

fips 1

  • 36041 · 787 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501447 2501447 2022-05-13 Hamilton New York 36041 919 5
2498189 2498189 2022-05-12 Hamilton New York 36041 919 5
2494931 2494931 2022-05-11 Hamilton New York 36041 919 5
2491673 2491673 2022-05-10 Hamilton New York 36041 916 5
2488415 2488415 2022-05-09 Hamilton New York 36041 915 5
2485158 2485158 2022-05-08 Hamilton New York 36041 914 5
2481900 2481900 2022-05-07 Hamilton New York 36041 910 5
2478642 2478642 2022-05-06 Hamilton New York 36041 910 5
2475384 2475384 2022-05-05 Hamilton New York 36041 909 5
2472127 2472127 2022-05-04 Hamilton New York 36041 909 5
2468871 2468871 2022-05-03 Hamilton New York 36041 908 5
2465615 2465615 2022-05-02 Hamilton New York 36041 905 5
2462360 2462360 2022-05-01 Hamilton New York 36041 904 5
2459104 2459104 2022-04-30 Hamilton New York 36041 904 5
2455848 2455848 2022-04-29 Hamilton New York 36041 904 5
2452592 2452592 2022-04-28 Hamilton New York 36041 904 5
2449336 2449336 2022-04-27 Hamilton New York 36041 901 5
2446079 2446079 2022-04-26 Hamilton New York 36041 895 5
2442824 2442824 2022-04-25 Hamilton New York 36041 891 5
2439568 2439568 2022-04-24 Hamilton New York 36041 890 5
2436312 2436312 2022-04-23 Hamilton New York 36041 890 5
2433056 2433056 2022-04-22 Hamilton New York 36041 890 5
2429800 2429800 2022-04-21 Hamilton New York 36041 889 5
2426544 2426544 2022-04-20 Hamilton New York 36041 888 5
2423288 2423288 2022-04-19 Hamilton New York 36041 886 5
2420031 2420031 2022-04-18 Hamilton New York 36041 885 5
2416776 2416776 2022-04-17 Hamilton New York 36041 885 5
2413520 2413520 2022-04-16 Hamilton New York 36041 885 5
2410264 2410264 2022-04-15 Hamilton New York 36041 885 5
2407008 2407008 2022-04-14 Hamilton New York 36041 881 5
2403752 2403752 2022-04-13 Hamilton New York 36041 879 5
2400497 2400497 2022-04-12 Hamilton New York 36041 875 5
2397242 2397242 2022-04-11 Hamilton New York 36041 874 5
2393987 2393987 2022-04-10 Hamilton New York 36041 874 5
2390731 2390731 2022-04-09 Hamilton New York 36041 874 5
2387475 2387475 2022-04-08 Hamilton New York 36041 874 5
2384220 2384220 2022-04-07 Hamilton New York 36041 874 5
2380965 2380965 2022-04-06 Hamilton New York 36041 873 5
2377710 2377710 2022-04-05 Hamilton New York 36041 873 5
2374457 2374457 2022-04-04 Hamilton New York 36041 872 5
2371205 2371205 2022-04-03 Hamilton New York 36041 871 5
2367952 2367952 2022-04-02 Hamilton New York 36041 871 5
2364699 2364699 2022-04-01 Hamilton New York 36041 871 5
2361445 2361445 2022-03-31 Hamilton New York 36041 871 5
2358191 2358191 2022-03-30 Hamilton New York 36041 871 5
2354937 2354937 2022-03-29 Hamilton New York 36041 870 5
2351684 2351684 2022-03-28 Hamilton New York 36041 870 5
2348432 2348432 2022-03-27 Hamilton New York 36041 870 5
2345179 2345179 2022-03-26 Hamilton New York 36041 870 5
2341926 2341926 2022-03-25 Hamilton New York 36041 870 5
2338673 2338673 2022-03-24 Hamilton New York 36041 868 5
2335419 2335419 2022-03-23 Hamilton New York 36041 865 5
2332165 2332165 2022-03-22 Hamilton New York 36041 862 5
2328912 2328912 2022-03-21 Hamilton New York 36041 856 5
2325660 2325660 2022-03-20 Hamilton New York 36041 856 5
2322407 2322407 2022-03-19 Hamilton New York 36041 854 5
2319153 2319153 2022-03-18 Hamilton New York 36041 852 5
2315899 2315899 2022-03-17 Hamilton New York 36041 852 5
2312646 2312646 2022-03-16 Hamilton New York 36041 850 5
2309393 2309393 2022-03-15 Hamilton New York 36041 849 5
2306140 2306140 2022-03-14 Hamilton New York 36041 846 5
2302889 2302889 2022-03-13 Hamilton New York 36041 846 5
2299637 2299637 2022-03-12 Hamilton New York 36041 846 5
2296385 2296385 2022-03-11 Hamilton New York 36041 844 5
2293133 2293133 2022-03-10 Hamilton New York 36041 842 5
2289881 2289881 2022-03-09 Hamilton New York 36041 842 5
2286629 2286629 2022-03-08 Hamilton New York 36041 842 5
2283377 2283377 2022-03-07 Hamilton New York 36041 838 5
2280125 2280125 2022-03-06 Hamilton New York 36041 837 5
2276872 2276872 2022-03-05 Hamilton New York 36041 836 5
2273619 2273619 2022-03-04 Hamilton New York 36041 834 5
2270366 2270366 2022-03-03 Hamilton New York 36041 834 5
2267114 2267114 2022-03-02 Hamilton New York 36041 834 5
2263862 2263862 2022-03-01 Hamilton New York 36041 834 5
2260611 2260611 2022-02-28 Hamilton New York 36041 833 5
2257360 2257360 2022-02-27 Hamilton New York 36041 833 5
2254109 2254109 2022-02-26 Hamilton New York 36041 830 5
2250858 2250858 2022-02-25 Hamilton New York 36041 829 5
2247607 2247607 2022-02-24 Hamilton New York 36041 829 5
2244356 2244356 2022-02-23 Hamilton New York 36041 828 5
2241105 2241105 2022-02-22 Hamilton New York 36041 827 5
2237854 2237854 2022-02-21 Hamilton New York 36041 827 5
2234603 2234603 2022-02-20 Hamilton New York 36041 826 5
2231352 2231352 2022-02-19 Hamilton New York 36041 825 5
2228101 2228101 2022-02-18 Hamilton New York 36041 823 5
2224850 2224850 2022-02-17 Hamilton New York 36041 823 5
2221599 2221599 2022-02-16 Hamilton New York 36041 822 5
2218348 2218348 2022-02-15 Hamilton New York 36041 820 5
2215097 2215097 2022-02-14 Hamilton New York 36041 819 5
2211846 2211846 2022-02-13 Hamilton New York 36041 819 5
2208593 2208593 2022-02-12 Hamilton New York 36041 818 5
2205340 2205340 2022-02-11 Hamilton New York 36041 812 5
2202087 2202087 2022-02-10 Hamilton New York 36041 810 5
2198833 2198833 2022-02-09 Hamilton New York 36041 807 5
2195579 2195579 2022-02-08 Hamilton New York 36041 806 5
2192325 2192325 2022-02-07 Hamilton New York 36041 804 5
2189071 2189071 2022-02-06 Hamilton New York 36041 803 5
2185818 2185818 2022-02-05 Hamilton New York 36041 803 5
2182566 2182566 2022-02-04 Hamilton New York 36041 800 5
2179314 2179314 2022-02-03 Hamilton New York 36041 797 5

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