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

785 rows where county = "Columbia", fips = 36021 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 · 785 ✖

fips 1

  • 36021 · 785 ✖

county 1

  • Columbia · 785 ✖
Link rowid date ▲ county state fips cases deaths
2501437 2501437 2022-05-13 Columbia New York 36021 10772 141
2498179 2498179 2022-05-12 Columbia New York 36021 10772 140
2494921 2494921 2022-05-11 Columbia New York 36021 10734 140
2491663 2491663 2022-05-10 Columbia New York 36021 10698 140
2488405 2488405 2022-05-09 Columbia New York 36021 10674 140
2485148 2485148 2022-05-08 Columbia New York 36021 10656 140
2481890 2481890 2022-05-07 Columbia New York 36021 10630 140
2478632 2478632 2022-05-06 Columbia New York 36021 10607 140
2475374 2475374 2022-05-05 Columbia New York 36021 10573 140
2472117 2472117 2022-05-04 Columbia New York 36021 10543 140
2468861 2468861 2022-05-03 Columbia New York 36021 10510 140
2465605 2465605 2022-05-02 Columbia New York 36021 10493 140
2462350 2462350 2022-05-01 Columbia New York 36021 10479 140
2459094 2459094 2022-04-30 Columbia New York 36021 10459 140
2455838 2455838 2022-04-29 Columbia New York 36021 10446 140
2452582 2452582 2022-04-28 Columbia New York 36021 10381 140
2449326 2449326 2022-04-27 Columbia New York 36021 10356 140
2446069 2446069 2022-04-26 Columbia New York 36021 10343 140
2442814 2442814 2022-04-25 Columbia New York 36021 10330 140
2439558 2439558 2022-04-24 Columbia New York 36021 10317 140
2436302 2436302 2022-04-23 Columbia New York 36021 10299 140
2433046 2433046 2022-04-22 Columbia New York 36021 10271 140
2429790 2429790 2022-04-21 Columbia New York 36021 10252 140
2426534 2426534 2022-04-20 Columbia New York 36021 10236 140
2423278 2423278 2022-04-19 Columbia New York 36021 10219 140
2420021 2420021 2022-04-18 Columbia New York 36021 10203 140
2416766 2416766 2022-04-17 Columbia New York 36021 10199 140
2413510 2413510 2022-04-16 Columbia New York 36021 10189 140
2410254 2410254 2022-04-15 Columbia New York 36021 10169 140
2406998 2406998 2022-04-14 Columbia New York 36021 10157 140
2403742 2403742 2022-04-13 Columbia New York 36021 10137 140
2400487 2400487 2022-04-12 Columbia New York 36021 10126 140
2397232 2397232 2022-04-11 Columbia New York 36021 10121 140
2393977 2393977 2022-04-10 Columbia New York 36021 10112 140
2390721 2390721 2022-04-09 Columbia New York 36021 10103 140
2387465 2387465 2022-04-08 Columbia New York 36021 10094 140
2384210 2384210 2022-04-07 Columbia New York 36021 10088 140
2380955 2380955 2022-04-06 Columbia New York 36021 10076 140
2377700 2377700 2022-04-05 Columbia New York 36021 10073 140
2374447 2374447 2022-04-04 Columbia New York 36021 10070 140
2371195 2371195 2022-04-03 Columbia New York 36021 10065 140
2367942 2367942 2022-04-02 Columbia New York 36021 10059 140
2364689 2364689 2022-04-01 Columbia New York 36021 10049 140
2361435 2361435 2022-03-31 Columbia New York 36021 10029 140
2358181 2358181 2022-03-30 Columbia New York 36021 10023 140
2354927 2354927 2022-03-29 Columbia New York 36021 10014 140
2351674 2351674 2022-03-28 Columbia New York 36021 10011 140
2348422 2348422 2022-03-27 Columbia New York 36021 10006 140
2345169 2345169 2022-03-26 Columbia New York 36021 10005 140
2341916 2341916 2022-03-25 Columbia New York 36021 9996 140
2338663 2338663 2022-03-24 Columbia New York 36021 9992 140
2335409 2335409 2022-03-23 Columbia New York 36021 9992 140
2332155 2332155 2022-03-22 Columbia New York 36021 9975 140
2328902 2328902 2022-03-21 Columbia New York 36021 9974 140
2325650 2325650 2022-03-20 Columbia New York 36021 9972 140
2322397 2322397 2022-03-19 Columbia New York 36021 9969 140
2319143 2319143 2022-03-18 Columbia New York 36021 9964 140
2315889 2315889 2022-03-17 Columbia New York 36021 9959 140
2312636 2312636 2022-03-16 Columbia New York 36021 9952 140
2309383 2309383 2022-03-15 Columbia New York 36021 9949 140
2306130 2306130 2022-03-14 Columbia New York 36021 9940 140
2302879 2302879 2022-03-13 Columbia New York 36021 9938 140
2299627 2299627 2022-03-12 Columbia New York 36021 9935 140
2296375 2296375 2022-03-11 Columbia New York 36021 9927 140
2293123 2293123 2022-03-10 Columbia New York 36021 9920 140
2289871 2289871 2022-03-09 Columbia New York 36021 9914 140
2286619 2286619 2022-03-08 Columbia New York 36021 9910 140
2283367 2283367 2022-03-07 Columbia New York 36021 9909 140
2280115 2280115 2022-03-06 Columbia New York 36021 9904 140
2276862 2276862 2022-03-05 Columbia New York 36021 9902 140
2273609 2273609 2022-03-04 Columbia New York 36021 9892 140
2270356 2270356 2022-03-03 Columbia New York 36021 9892 140
2267104 2267104 2022-03-02 Columbia New York 36021 9888 140
2263852 2263852 2022-03-01 Columbia New York 36021 9875 140
2260601 2260601 2022-02-28 Columbia New York 36021 9871 140
2257350 2257350 2022-02-27 Columbia New York 36021 9870 140
2254099 2254099 2022-02-26 Columbia New York 36021 9866 140
2250848 2250848 2022-02-25 Columbia New York 36021 9854 140
2247597 2247597 2022-02-24 Columbia New York 36021 9850 140
2244346 2244346 2022-02-23 Columbia New York 36021 9844 140
2241095 2241095 2022-02-22 Columbia New York 36021 9835 140
2237844 2237844 2022-02-21 Columbia New York 36021 9813 140
2234593 2234593 2022-02-20 Columbia New York 36021 9809 140
2231342 2231342 2022-02-19 Columbia New York 36021 9797 140
2228091 2228091 2022-02-18 Columbia New York 36021 9785 140
2224840 2224840 2022-02-17 Columbia New York 36021 9774 140
2221589 2221589 2022-02-16 Columbia New York 36021 9767 140
2218338 2218338 2022-02-15 Columbia New York 36021 9746 139
2215087 2215087 2022-02-14 Columbia New York 36021 9717 138
2211836 2211836 2022-02-13 Columbia New York 36021 9712 137
2208583 2208583 2022-02-12 Columbia New York 36021 9700 137
2205330 2205330 2022-02-11 Columbia New York 36021 9685 137
2202077 2202077 2022-02-10 Columbia New York 36021 9677 137
2198823 2198823 2022-02-09 Columbia New York 36021 9658 136
2195569 2195569 2022-02-08 Columbia New York 36021 9605 136
2192315 2192315 2022-02-07 Columbia New York 36021 9594 136
2189061 2189061 2022-02-06 Columbia New York 36021 9582 136
2185808 2185808 2022-02-05 Columbia New York 36021 9574 136
2182556 2182556 2022-02-04 Columbia New York 36021 9560 135
2179304 2179304 2022-02-03 Columbia New York 36021 9522 135

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