ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
750 rows where county = "Vernon" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502800 | 2502800 | 2022-05-13 | Vernon | Wisconsin | 55123 | 6239 | 98 |
2499542 | 2499542 | 2022-05-12 | Vernon | Wisconsin | 55123 | 6238 | 98 |
2496284 | 2496284 | 2022-05-11 | Vernon | Wisconsin | 55123 | 6231 | 98 |
2493026 | 2493026 | 2022-05-10 | Vernon | Wisconsin | 55123 | 6212 | 98 |
2489768 | 2489768 | 2022-05-09 | Vernon | Wisconsin | 55123 | 6206 | 98 |
2486511 | 2486511 | 2022-05-08 | Vernon | Wisconsin | 55123 | 6183 | 97 |
2483253 | 2483253 | 2022-05-07 | Vernon | Wisconsin | 55123 | 6183 | 97 |
2479995 | 2479995 | 2022-05-06 | Vernon | Wisconsin | 55123 | 6183 | 97 |
2476737 | 2476737 | 2022-05-05 | Vernon | Wisconsin | 55123 | 6173 | 97 |
2473479 | 2473479 | 2022-05-04 | Vernon | Wisconsin | 55123 | 6152 | 97 |
2470222 | 2470222 | 2022-05-03 | Vernon | Wisconsin | 55123 | 6136 | 97 |
2466966 | 2466966 | 2022-05-02 | Vernon | Wisconsin | 55123 | 6135 | 97 |
2463711 | 2463711 | 2022-05-01 | Vernon | Wisconsin | 55123 | 6113 | 97 |
2460455 | 2460455 | 2022-04-30 | Vernon | Wisconsin | 55123 | 6113 | 97 |
2457199 | 2457199 | 2022-04-29 | Vernon | Wisconsin | 55123 | 6113 | 97 |
2453943 | 2453943 | 2022-04-28 | Vernon | Wisconsin | 55123 | 6109 | 97 |
2450687 | 2450687 | 2022-04-27 | Vernon | Wisconsin | 55123 | 6096 | 97 |
2447431 | 2447431 | 2022-04-26 | Vernon | Wisconsin | 55123 | 6085 | 97 |
2444175 | 2444175 | 2022-04-25 | Vernon | Wisconsin | 55123 | 6080 | 96 |
2440919 | 2440919 | 2022-04-24 | Vernon | Wisconsin | 55123 | 6068 | 96 |
2437663 | 2437663 | 2022-04-23 | Vernon | Wisconsin | 55123 | 6068 | 96 |
2434407 | 2434407 | 2022-04-22 | Vernon | Wisconsin | 55123 | 6068 | 96 |
2431151 | 2431151 | 2022-04-21 | Vernon | Wisconsin | 55123 | 6061 | 96 |
2427895 | 2427895 | 2022-04-20 | Vernon | Wisconsin | 55123 | 6054 | 96 |
2424639 | 2424639 | 2022-04-19 | Vernon | Wisconsin | 55123 | 6051 | 96 |
2421383 | 2421383 | 2022-04-18 | Vernon | Wisconsin | 55123 | 6048 | 96 |
2418127 | 2418127 | 2022-04-17 | Vernon | Wisconsin | 55123 | 6043 | 96 |
2414871 | 2414871 | 2022-04-16 | Vernon | Wisconsin | 55123 | 6043 | 96 |
2411615 | 2411615 | 2022-04-15 | Vernon | Wisconsin | 55123 | 6043 | 96 |
2408359 | 2408359 | 2022-04-14 | Vernon | Wisconsin | 55123 | 6037 | 96 |
2405103 | 2405103 | 2022-04-13 | Vernon | Wisconsin | 55123 | 6032 | 96 |
2401848 | 2401848 | 2022-04-12 | Vernon | Wisconsin | 55123 | 6030 | 96 |
2398593 | 2398593 | 2022-04-11 | Vernon | Wisconsin | 55123 | 6030 | 96 |
2395338 | 2395338 | 2022-04-10 | Vernon | Wisconsin | 55123 | 6022 | 96 |
2392082 | 2392082 | 2022-04-09 | Vernon | Wisconsin | 55123 | 6022 | 96 |
2388826 | 2388826 | 2022-04-08 | Vernon | Wisconsin | 55123 | 6022 | 96 |
2385571 | 2385571 | 2022-04-07 | Vernon | Wisconsin | 55123 | 6019 | 96 |
2382316 | 2382316 | 2022-04-06 | Vernon | Wisconsin | 55123 | 6016 | 96 |
2379061 | 2379061 | 2022-04-05 | Vernon | Wisconsin | 55123 | 6015 | 96 |
2375807 | 2375807 | 2022-04-04 | Vernon | Wisconsin | 55123 | 6015 | 96 |
2372555 | 2372555 | 2022-04-03 | Vernon | Wisconsin | 55123 | 6009 | 96 |
2369302 | 2369302 | 2022-04-02 | Vernon | Wisconsin | 55123 | 6009 | 96 |
2366049 | 2366049 | 2022-04-01 | Vernon | Wisconsin | 55123 | 6009 | 96 |
2362796 | 2362796 | 2022-03-31 | Vernon | Wisconsin | 55123 | 6003 | 96 |
2359542 | 2359542 | 2022-03-30 | Vernon | Wisconsin | 55123 | 6001 | 96 |
2356288 | 2356288 | 2022-03-29 | Vernon | Wisconsin | 55123 | 5999 | 96 |
2353035 | 2353035 | 2022-03-28 | Vernon | Wisconsin | 55123 | 5997 | 94 |
2349783 | 2349783 | 2022-03-27 | Vernon | Wisconsin | 55123 | 5992 | 93 |
2346530 | 2346530 | 2022-03-26 | Vernon | Wisconsin | 55123 | 5992 | 93 |
2343277 | 2343277 | 2022-03-25 | Vernon | Wisconsin | 55123 | 5992 | 93 |
2340024 | 2340024 | 2022-03-24 | Vernon | Wisconsin | 55123 | 5987 | 93 |
2336771 | 2336771 | 2022-03-23 | Vernon | Wisconsin | 55123 | 5984 | 93 |
2333517 | 2333517 | 2022-03-22 | Vernon | Wisconsin | 55123 | 5981 | 93 |
2330263 | 2330263 | 2022-03-21 | Vernon | Wisconsin | 55123 | 5976 | 93 |
2327011 | 2327011 | 2022-03-20 | Vernon | Wisconsin | 55123 | 5969 | 92 |
2323758 | 2323758 | 2022-03-19 | Vernon | Wisconsin | 55123 | 5969 | 92 |
2320504 | 2320504 | 2022-03-18 | Vernon | Wisconsin | 55123 | 5969 | 92 |
2317250 | 2317250 | 2022-03-17 | Vernon | Wisconsin | 55123 | 5961 | 91 |
2313997 | 2313997 | 2022-03-16 | Vernon | Wisconsin | 55123 | 5954 | 91 |
2310744 | 2310744 | 2022-03-15 | Vernon | Wisconsin | 55123 | 5952 | 91 |
2307491 | 2307491 | 2022-03-14 | Vernon | Wisconsin | 55123 | 5952 | 91 |
2304240 | 2304240 | 2022-03-13 | Vernon | Wisconsin | 55123 | 5948 | 91 |
2300988 | 2300988 | 2022-03-12 | Vernon | Wisconsin | 55123 | 5948 | 91 |
2297736 | 2297736 | 2022-03-11 | Vernon | Wisconsin | 55123 | 5948 | 91 |
2294484 | 2294484 | 2022-03-10 | Vernon | Wisconsin | 55123 | 5945 | 91 |
2291232 | 2291232 | 2022-03-09 | Vernon | Wisconsin | 55123 | 5941 | 91 |
2287980 | 2287980 | 2022-03-08 | Vernon | Wisconsin | 55123 | 5935 | 90 |
2284728 | 2284728 | 2022-03-07 | Vernon | Wisconsin | 55123 | 5935 | 90 |
2281476 | 2281476 | 2022-03-06 | Vernon | Wisconsin | 55123 | 5926 | 90 |
2278223 | 2278223 | 2022-03-05 | Vernon | Wisconsin | 55123 | 5926 | 90 |
2274970 | 2274970 | 2022-03-04 | Vernon | Wisconsin | 55123 | 5926 | 90 |
2271717 | 2271717 | 2022-03-03 | Vernon | Wisconsin | 55123 | 5920 | 90 |
2268465 | 2268465 | 2022-03-02 | Vernon | Wisconsin | 55123 | 5917 | 90 |
2265212 | 2265212 | 2022-03-01 | Vernon | Wisconsin | 55123 | 5902 | 90 |
2261962 | 2261962 | 2022-02-28 | Vernon | Wisconsin | 55123 | 5897 | 89 |
2258711 | 2258711 | 2022-02-27 | Vernon | Wisconsin | 55123 | 5885 | 89 |
2255460 | 2255460 | 2022-02-26 | Vernon | Wisconsin | 55123 | 5885 | 89 |
2252209 | 2252209 | 2022-02-25 | Vernon | Wisconsin | 55123 | 5885 | 89 |
2248958 | 2248958 | 2022-02-24 | Vernon | Wisconsin | 55123 | 5879 | 89 |
2245707 | 2245707 | 2022-02-23 | Vernon | Wisconsin | 55123 | 5870 | 88 |
2242456 | 2242456 | 2022-02-22 | Vernon | Wisconsin | 55123 | 5859 | 88 |
2239205 | 2239205 | 2022-02-21 | Vernon | Wisconsin | 55123 | 5856 | 88 |
2235954 | 2235954 | 2022-02-20 | Vernon | Wisconsin | 55123 | 5842 | 88 |
2232703 | 2232703 | 2022-02-19 | Vernon | Wisconsin | 55123 | 5842 | 88 |
2229452 | 2229452 | 2022-02-18 | Vernon | Wisconsin | 55123 | 5842 | 88 |
2226201 | 2226201 | 2022-02-17 | Vernon | Wisconsin | 55123 | 5833 | 88 |
2222950 | 2222950 | 2022-02-16 | Vernon | Wisconsin | 55123 | 5824 | 88 |
2219699 | 2219699 | 2022-02-15 | Vernon | Wisconsin | 55123 | 5810 | 88 |
2216449 | 2216449 | 2022-02-14 | Vernon | Wisconsin | 55123 | 5794 | 88 |
2213198 | 2213198 | 2022-02-13 | Vernon | Wisconsin | 55123 | 5751 | 86 |
2209945 | 2209945 | 2022-02-12 | Vernon | Wisconsin | 55123 | 5751 | 86 |
2206692 | 2206692 | 2022-02-11 | Vernon | Wisconsin | 55123 | 5751 | 86 |
2203439 | 2203439 | 2022-02-10 | Vernon | Wisconsin | 55123 | 5726 | 85 |
2200185 | 2200185 | 2022-02-09 | Vernon | Wisconsin | 55123 | 5708 | 84 |
2196931 | 2196931 | 2022-02-08 | Vernon | Wisconsin | 55123 | 5683 | 84 |
2193676 | 2193676 | 2022-02-07 | Vernon | Wisconsin | 55123 | 5663 | 84 |
2190423 | 2190423 | 2022-02-06 | Vernon | Wisconsin | 55123 | 5621 | 83 |
2187170 | 2187170 | 2022-02-05 | Vernon | Wisconsin | 55123 | 5621 | 83 |
2183917 | 2183917 | 2022-02-04 | Vernon | Wisconsin | 55123 | 5621 | 83 |
2180665 | 2180665 | 2022-02-03 | Vernon | Wisconsin | 55123 | 5586 | 83 |
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);