ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,552 rows where county = "Green" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337849 | 2337849 | 2022-03-24 | Green | Kentucky | 21087 | 3668 | 40 |
2339984 | 2339984 | 2022-03-24 | Green | Wisconsin | 55045 | 9071 | 53 |
2334595 | 2334595 | 2022-03-23 | Green | Kentucky | 21087 | 3668 | 40 |
2336731 | 2336731 | 2022-03-23 | Green | Wisconsin | 55045 | 9065 | 53 |
2331341 | 2331341 | 2022-03-22 | Green | Kentucky | 21087 | 3668 | 40 |
2333477 | 2333477 | 2022-03-22 | Green | Wisconsin | 55045 | 9056 | 53 |
2328089 | 2328089 | 2022-03-21 | Green | Kentucky | 21087 | 3668 | 40 |
2330223 | 2330223 | 2022-03-21 | Green | Wisconsin | 55045 | 9053 | 53 |
2324836 | 2324836 | 2022-03-20 | Green | Kentucky | 21087 | 3602 | 40 |
2326971 | 2326971 | 2022-03-20 | Green | Wisconsin | 55045 | 9039 | 53 |
2321582 | 2321582 | 2022-03-19 | Green | Kentucky | 21087 | 3602 | 40 |
2323718 | 2323718 | 2022-03-19 | Green | Wisconsin | 55045 | 9039 | 53 |
2318328 | 2318328 | 2022-03-18 | Green | Kentucky | 21087 | 3602 | 40 |
2320464 | 2320464 | 2022-03-18 | Green | Wisconsin | 55045 | 9039 | 53 |
2315075 | 2315075 | 2022-03-17 | Green | Kentucky | 21087 | 3602 | 40 |
2317210 | 2317210 | 2022-03-17 | Green | Wisconsin | 55045 | 9029 | 52 |
2311822 | 2311822 | 2022-03-16 | Green | Kentucky | 21087 | 3602 | 40 |
2313957 | 2313957 | 2022-03-16 | Green | Wisconsin | 55045 | 9013 | 52 |
2308569 | 2308569 | 2022-03-15 | Green | Kentucky | 21087 | 3602 | 40 |
2310704 | 2310704 | 2022-03-15 | Green | Wisconsin | 55045 | 8998 | 52 |
2305318 | 2305318 | 2022-03-14 | Green | Kentucky | 21087 | 3602 | 40 |
2307451 | 2307451 | 2022-03-14 | Green | Wisconsin | 55045 | 8983 | 52 |
2302066 | 2302066 | 2022-03-13 | Green | Kentucky | 21087 | 3540 | 40 |
2304200 | 2304200 | 2022-03-13 | Green | Wisconsin | 55045 | 8961 | 52 |
2298814 | 2298814 | 2022-03-12 | Green | Kentucky | 21087 | 3540 | 40 |
2300948 | 2300948 | 2022-03-12 | Green | Wisconsin | 55045 | 8961 | 52 |
2295562 | 2295562 | 2022-03-11 | Green | Kentucky | 21087 | 3540 | 40 |
2297696 | 2297696 | 2022-03-11 | Green | Wisconsin | 55045 | 8961 | 52 |
2292310 | 2292310 | 2022-03-10 | Green | Kentucky | 21087 | 3540 | 40 |
2294444 | 2294444 | 2022-03-10 | Green | Wisconsin | 55045 | 8952 | 52 |
2289058 | 2289058 | 2022-03-09 | Green | Kentucky | 21087 | 3540 | 40 |
2291192 | 2291192 | 2022-03-09 | Green | Wisconsin | 55045 | 8944 | 52 |
2285807 | 2285807 | 2022-03-08 | Green | Kentucky | 21087 | 3540 | 40 |
2287940 | 2287940 | 2022-03-08 | Green | Wisconsin | 55045 | 8937 | 52 |
2282555 | 2282555 | 2022-03-07 | Green | Kentucky | 21087 | 3540 | 40 |
2284688 | 2284688 | 2022-03-07 | Green | Wisconsin | 55045 | 8936 | 52 |
2279302 | 2279302 | 2022-03-06 | Green | Kentucky | 21087 | 3526 | 40 |
2281436 | 2281436 | 2022-03-06 | Green | Wisconsin | 55045 | 8921 | 52 |
2276049 | 2276049 | 2022-03-05 | Green | Kentucky | 21087 | 3526 | 40 |
2278183 | 2278183 | 2022-03-05 | Green | Wisconsin | 55045 | 8921 | 52 |
2272796 | 2272796 | 2022-03-04 | Green | Kentucky | 21087 | 3526 | 40 |
2274930 | 2274930 | 2022-03-04 | Green | Wisconsin | 55045 | 8921 | 52 |
2269544 | 2269544 | 2022-03-03 | Green | Kentucky | 21087 | 3509 | 40 |
2271677 | 2271677 | 2022-03-03 | Green | Wisconsin | 55045 | 8914 | 52 |
2266291 | 2266291 | 2022-03-02 | Green | Kentucky | 21087 | 3499 | 40 |
2268425 | 2268425 | 2022-03-02 | Green | Wisconsin | 55045 | 8910 | 52 |
2263040 | 2263040 | 2022-03-01 | Green | Kentucky | 21087 | 3484 | 40 |
2265172 | 2265172 | 2022-03-01 | Green | Wisconsin | 55045 | 8902 | 52 |
2259789 | 2259789 | 2022-02-28 | Green | Kentucky | 21087 | 3470 | 40 |
2261922 | 2261922 | 2022-02-28 | Green | Wisconsin | 55045 | 8898 | 51 |
2256538 | 2256538 | 2022-02-27 | Green | Kentucky | 21087 | 3456 | 40 |
2258671 | 2258671 | 2022-02-27 | Green | Wisconsin | 55045 | 8890 | 51 |
2253287 | 2253287 | 2022-02-26 | Green | Kentucky | 21087 | 3456 | 40 |
2255420 | 2255420 | 2022-02-26 | Green | Wisconsin | 55045 | 8890 | 51 |
2250036 | 2250036 | 2022-02-25 | Green | Kentucky | 21087 | 3456 | 40 |
2252169 | 2252169 | 2022-02-25 | Green | Wisconsin | 55045 | 8890 | 51 |
2246785 | 2246785 | 2022-02-24 | Green | Kentucky | 21087 | 3452 | 40 |
2248918 | 2248918 | 2022-02-24 | Green | Wisconsin | 55045 | 8886 | 51 |
2243534 | 2243534 | 2022-02-23 | Green | Kentucky | 21087 | 3452 | 40 |
2245667 | 2245667 | 2022-02-23 | Green | Wisconsin | 55045 | 8883 | 52 |
2240283 | 2240283 | 2022-02-22 | Green | Kentucky | 21087 | 3444 | 40 |
2242416 | 2242416 | 2022-02-22 | Green | Wisconsin | 55045 | 8871 | 52 |
2237032 | 2237032 | 2022-02-21 | Green | Kentucky | 21087 | 3437 | 40 |
2239165 | 2239165 | 2022-02-21 | Green | Wisconsin | 55045 | 8866 | 51 |
2233781 | 2233781 | 2022-02-20 | Green | Kentucky | 21087 | 3419 | 40 |
2235914 | 2235914 | 2022-02-20 | Green | Wisconsin | 55045 | 8844 | 50 |
2230530 | 2230530 | 2022-02-19 | Green | Kentucky | 21087 | 3419 | 40 |
2232663 | 2232663 | 2022-02-19 | Green | Wisconsin | 55045 | 8844 | 50 |
2227279 | 2227279 | 2022-02-18 | Green | Kentucky | 21087 | 3419 | 40 |
2229412 | 2229412 | 2022-02-18 | Green | Wisconsin | 55045 | 8844 | 50 |
2224028 | 2224028 | 2022-02-17 | Green | Kentucky | 21087 | 3404 | 40 |
2226161 | 2226161 | 2022-02-17 | Green | Wisconsin | 55045 | 8819 | 50 |
2220777 | 2220777 | 2022-02-16 | Green | Kentucky | 21087 | 3387 | 40 |
2222910 | 2222910 | 2022-02-16 | Green | Wisconsin | 55045 | 8801 | 50 |
2217526 | 2217526 | 2022-02-15 | Green | Kentucky | 21087 | 3369 | 40 |
2219659 | 2219659 | 2022-02-15 | Green | Wisconsin | 55045 | 8784 | 50 |
2214275 | 2214275 | 2022-02-14 | Green | Kentucky | 21087 | 3369 | 40 |
2216409 | 2216409 | 2022-02-14 | Green | Wisconsin | 55045 | 8782 | 50 |
2211023 | 2211023 | 2022-02-13 | Green | Kentucky | 21087 | 3309 | 40 |
2213158 | 2213158 | 2022-02-13 | Green | Wisconsin | 55045 | 8742 | 50 |
2207770 | 2207770 | 2022-02-12 | Green | Kentucky | 21087 | 3309 | 40 |
2209905 | 2209905 | 2022-02-12 | Green | Wisconsin | 55045 | 8742 | 50 |
2204517 | 2204517 | 2022-02-11 | Green | Kentucky | 21087 | 3309 | 40 |
2206652 | 2206652 | 2022-02-11 | Green | Wisconsin | 55045 | 8742 | 50 |
2201264 | 2201264 | 2022-02-10 | Green | Kentucky | 21087 | 3293 | 40 |
2203399 | 2203399 | 2022-02-10 | Green | Wisconsin | 55045 | 8717 | 50 |
2198010 | 2198010 | 2022-02-09 | Green | Kentucky | 21087 | 3284 | 40 |
2200145 | 2200145 | 2022-02-09 | Green | Wisconsin | 55045 | 8695 | 50 |
2194756 | 2194756 | 2022-02-08 | Green | Kentucky | 21087 | 3263 | 40 |
2196891 | 2196891 | 2022-02-08 | Green | Wisconsin | 55045 | 8667 | 50 |
2191502 | 2191502 | 2022-02-07 | Green | Kentucky | 21087 | 3252 | 40 |
2193636 | 2193636 | 2022-02-07 | Green | Wisconsin | 55045 | 8649 | 49 |
2188249 | 2188249 | 2022-02-06 | Green | Kentucky | 21087 | 3241 | 40 |
2190383 | 2190383 | 2022-02-06 | Green | Wisconsin | 55045 | 8585 | 49 |
2184996 | 2184996 | 2022-02-05 | Green | Kentucky | 21087 | 3241 | 40 |
2187130 | 2187130 | 2022-02-05 | Green | Wisconsin | 55045 | 8585 | 49 |
2181744 | 2181744 | 2022-02-04 | Green | Kentucky | 21087 | 3241 | 40 |
2183877 | 2183877 | 2022-02-04 | Green | Wisconsin | 55045 | 8585 | 49 |
2178493 | 2178493 | 2022-02-03 | Green | Kentucky | 21087 | 3219 | 40 |
2180625 | 2180625 | 2022-02-03 | Green | Wisconsin | 55045 | 8554 | 48 |
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);