ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,296 rows where county = "Vernon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Vernon · 2,196 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2393726 | 2393726 | 2022-04-10 | Vernon | Missouri | 29217 | 5051 | 109 |
2395338 | 2395338 | 2022-04-10 | Vernon | Wisconsin | 55123 | 6022 | 96 |
2390041 | 2390041 | 2022-04-09 | Vernon | Louisiana | 22115 | 9924 | 191 |
2390470 | 2390470 | 2022-04-09 | Vernon | Missouri | 29217 | 5051 | 109 |
2392082 | 2392082 | 2022-04-09 | Vernon | Wisconsin | 55123 | 6022 | 96 |
2386785 | 2386785 | 2022-04-08 | Vernon | Louisiana | 22115 | 9924 | 191 |
2387214 | 2387214 | 2022-04-08 | Vernon | Missouri | 29217 | 5051 | 109 |
2388826 | 2388826 | 2022-04-08 | Vernon | Wisconsin | 55123 | 6022 | 96 |
2383530 | 2383530 | 2022-04-07 | Vernon | Louisiana | 22115 | 9924 | 191 |
2383959 | 2383959 | 2022-04-07 | Vernon | Missouri | 29217 | 5051 | 109 |
2385571 | 2385571 | 2022-04-07 | Vernon | Wisconsin | 55123 | 6019 | 96 |
2380275 | 2380275 | 2022-04-06 | Vernon | Louisiana | 22115 | 9923 | 191 |
2380704 | 2380704 | 2022-04-06 | Vernon | Missouri | 29217 | 5051 | 109 |
2382316 | 2382316 | 2022-04-06 | Vernon | Wisconsin | 55123 | 6016 | 96 |
2377020 | 2377020 | 2022-04-05 | Vernon | Louisiana | 22115 | 9920 | 191 |
2377449 | 2377449 | 2022-04-05 | Vernon | Missouri | 29217 | 5051 | 109 |
2379061 | 2379061 | 2022-04-05 | Vernon | Wisconsin | 55123 | 6015 | 96 |
2373768 | 2373768 | 2022-04-04 | Vernon | Louisiana | 22115 | 9919 | 191 |
2374196 | 2374196 | 2022-04-04 | Vernon | Missouri | 29217 | 5051 | 109 |
2375807 | 2375807 | 2022-04-04 | Vernon | Wisconsin | 55123 | 6015 | 96 |
2370515 | 2370515 | 2022-04-03 | Vernon | Louisiana | 22115 | 9919 | 191 |
2370944 | 2370944 | 2022-04-03 | Vernon | Missouri | 29217 | 5051 | 109 |
2372555 | 2372555 | 2022-04-03 | Vernon | Wisconsin | 55123 | 6009 | 96 |
2367262 | 2367262 | 2022-04-02 | Vernon | Louisiana | 22115 | 9919 | 191 |
2367691 | 2367691 | 2022-04-02 | Vernon | Missouri | 29217 | 5051 | 109 |
2369302 | 2369302 | 2022-04-02 | Vernon | Wisconsin | 55123 | 6009 | 96 |
2364009 | 2364009 | 2022-04-01 | Vernon | Louisiana | 22115 | 9919 | 191 |
2364438 | 2364438 | 2022-04-01 | Vernon | Missouri | 29217 | 5051 | 109 |
2366049 | 2366049 | 2022-04-01 | Vernon | Wisconsin | 55123 | 6009 | 96 |
2360755 | 2360755 | 2022-03-31 | Vernon | Louisiana | 22115 | 9919 | 189 |
2361184 | 2361184 | 2022-03-31 | Vernon | Missouri | 29217 | 5051 | 109 |
2362796 | 2362796 | 2022-03-31 | Vernon | Wisconsin | 55123 | 6003 | 96 |
2357501 | 2357501 | 2022-03-30 | Vernon | Louisiana | 22115 | 9919 | 188 |
2357930 | 2357930 | 2022-03-30 | Vernon | Missouri | 29217 | 5049 | 109 |
2359542 | 2359542 | 2022-03-30 | Vernon | Wisconsin | 55123 | 6001 | 96 |
2354248 | 2354248 | 2022-03-29 | Vernon | Louisiana | 22115 | 9919 | 188 |
2354677 | 2354677 | 2022-03-29 | Vernon | Missouri | 29217 | 5045 | 108 |
2356288 | 2356288 | 2022-03-29 | Vernon | Wisconsin | 55123 | 5999 | 96 |
2350996 | 2350996 | 2022-03-28 | Vernon | Louisiana | 22115 | 9918 | 188 |
2351424 | 2351424 | 2022-03-28 | Vernon | Missouri | 29217 | 5046 | 106 |
2353035 | 2353035 | 2022-03-28 | Vernon | Wisconsin | 55123 | 5997 | 94 |
2347743 | 2347743 | 2022-03-27 | Vernon | Louisiana | 22115 | 9917 | 188 |
2348172 | 2348172 | 2022-03-27 | Vernon | Missouri | 29217 | 5046 | 106 |
2349783 | 2349783 | 2022-03-27 | Vernon | Wisconsin | 55123 | 5992 | 93 |
2344490 | 2344490 | 2022-03-26 | Vernon | Louisiana | 22115 | 9917 | 188 |
2344919 | 2344919 | 2022-03-26 | Vernon | Missouri | 29217 | 5046 | 106 |
2346530 | 2346530 | 2022-03-26 | Vernon | Wisconsin | 55123 | 5992 | 93 |
2341237 | 2341237 | 2022-03-25 | Vernon | Louisiana | 22115 | 9917 | 188 |
2341666 | 2341666 | 2022-03-25 | Vernon | Missouri | 29217 | 5046 | 106 |
2343277 | 2343277 | 2022-03-25 | Vernon | Wisconsin | 55123 | 5992 | 93 |
2337984 | 2337984 | 2022-03-24 | Vernon | Louisiana | 22115 | 9917 | 188 |
2338413 | 2338413 | 2022-03-24 | Vernon | Missouri | 29217 | 5046 | 106 |
2340024 | 2340024 | 2022-03-24 | Vernon | Wisconsin | 55123 | 5987 | 93 |
2334730 | 2334730 | 2022-03-23 | Vernon | Louisiana | 22115 | 9917 | 188 |
2335159 | 2335159 | 2022-03-23 | Vernon | Missouri | 29217 | 5045 | 106 |
2336771 | 2336771 | 2022-03-23 | Vernon | Wisconsin | 55123 | 5984 | 93 |
2331476 | 2331476 | 2022-03-22 | Vernon | Louisiana | 22115 | 9916 | 188 |
2331905 | 2331905 | 2022-03-22 | Vernon | Missouri | 29217 | 5044 | 106 |
2333517 | 2333517 | 2022-03-22 | Vernon | Wisconsin | 55123 | 5981 | 93 |
2328224 | 2328224 | 2022-03-21 | Vernon | Louisiana | 22115 | 9916 | 188 |
2328652 | 2328652 | 2022-03-21 | Vernon | Missouri | 29217 | 5041 | 105 |
2330263 | 2330263 | 2022-03-21 | Vernon | Wisconsin | 55123 | 5976 | 93 |
2324971 | 2324971 | 2022-03-20 | Vernon | Louisiana | 22115 | 9916 | 188 |
2325400 | 2325400 | 2022-03-20 | Vernon | Missouri | 29217 | 5039 | 105 |
2327011 | 2327011 | 2022-03-20 | Vernon | Wisconsin | 55123 | 5969 | 92 |
2321717 | 2321717 | 2022-03-19 | Vernon | Louisiana | 22115 | 9916 | 188 |
2322146 | 2322146 | 2022-03-19 | Vernon | Missouri | 29217 | 5039 | 105 |
2323758 | 2323758 | 2022-03-19 | Vernon | Wisconsin | 55123 | 5969 | 92 |
2318463 | 2318463 | 2022-03-18 | Vernon | Louisiana | 22115 | 9916 | 188 |
2318892 | 2318892 | 2022-03-18 | Vernon | Missouri | 29217 | 5039 | 105 |
2320504 | 2320504 | 2022-03-18 | Vernon | Wisconsin | 55123 | 5969 | 92 |
2315210 | 2315210 | 2022-03-17 | Vernon | Louisiana | 22115 | 9915 | 187 |
2315639 | 2315639 | 2022-03-17 | Vernon | Missouri | 29217 | 5039 | 105 |
2317250 | 2317250 | 2022-03-17 | Vernon | Wisconsin | 55123 | 5961 | 91 |
2311957 | 2311957 | 2022-03-16 | Vernon | Louisiana | 22115 | 9915 | 187 |
2312386 | 2312386 | 2022-03-16 | Vernon | Missouri | 29217 | 5039 | 105 |
2313997 | 2313997 | 2022-03-16 | Vernon | Wisconsin | 55123 | 5954 | 91 |
2308704 | 2308704 | 2022-03-15 | Vernon | Louisiana | 22115 | 9915 | 187 |
2309133 | 2309133 | 2022-03-15 | Vernon | Missouri | 29217 | 5039 | 105 |
2310744 | 2310744 | 2022-03-15 | Vernon | Wisconsin | 55123 | 5952 | 91 |
2305453 | 2305453 | 2022-03-14 | Vernon | Louisiana | 22115 | 9915 | 187 |
2305881 | 2305881 | 2022-03-14 | Vernon | Missouri | 29217 | 5039 | 103 |
2307491 | 2307491 | 2022-03-14 | Vernon | Wisconsin | 55123 | 5952 | 91 |
2302201 | 2302201 | 2022-03-13 | Vernon | Louisiana | 22115 | 9914 | 187 |
2302630 | 2302630 | 2022-03-13 | Vernon | Missouri | 29217 | 5037 | 103 |
2304240 | 2304240 | 2022-03-13 | Vernon | Wisconsin | 55123 | 5948 | 91 |
2298949 | 2298949 | 2022-03-12 | Vernon | Louisiana | 22115 | 9914 | 187 |
2299378 | 2299378 | 2022-03-12 | Vernon | Missouri | 29217 | 5037 | 103 |
2300988 | 2300988 | 2022-03-12 | Vernon | Wisconsin | 55123 | 5948 | 91 |
2295697 | 2295697 | 2022-03-11 | Vernon | Louisiana | 22115 | 9914 | 187 |
2296126 | 2296126 | 2022-03-11 | Vernon | Missouri | 29217 | 5037 | 103 |
2297736 | 2297736 | 2022-03-11 | Vernon | Wisconsin | 55123 | 5948 | 91 |
2292445 | 2292445 | 2022-03-10 | Vernon | Louisiana | 22115 | 9914 | 187 |
2292874 | 2292874 | 2022-03-10 | Vernon | Missouri | 29217 | 5037 | 102 |
2294484 | 2294484 | 2022-03-10 | Vernon | Wisconsin | 55123 | 5945 | 91 |
2289193 | 2289193 | 2022-03-09 | Vernon | Louisiana | 22115 | 9914 | 187 |
2289622 | 2289622 | 2022-03-09 | Vernon | Missouri | 29217 | 5037 | 102 |
2291232 | 2291232 | 2022-03-09 | Vernon | Wisconsin | 55123 | 5941 | 91 |
2285942 | 2285942 | 2022-03-08 | Vernon | Louisiana | 22115 | 9911 | 186 |
2286370 | 2286370 | 2022-03-08 | Vernon | Missouri | 29217 | 5035 | 102 |
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);