ny_times_us_counties
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
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
Advanced export
JSON shape: default, array, newline-delimited
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);