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)
Suggested facets: date (date)
county 1
- Vernon · 2,296 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500757 | 2500757 | 2022-05-13 | Vernon | Louisiana | 22115 | 9939 | 191 |
2501186 | 2501186 | 2022-05-13 | Vernon | Missouri | 29217 | 5104 | 109 |
2502800 | 2502800 | 2022-05-13 | Vernon | Wisconsin | 55123 | 6239 | 98 |
2497499 | 2497499 | 2022-05-12 | Vernon | Louisiana | 22115 | 9938 | 191 |
2497928 | 2497928 | 2022-05-12 | Vernon | Missouri | 29217 | 5100 | 109 |
2499542 | 2499542 | 2022-05-12 | Vernon | Wisconsin | 55123 | 6238 | 98 |
2494241 | 2494241 | 2022-05-11 | Vernon | Louisiana | 22115 | 9936 | 191 |
2494670 | 2494670 | 2022-05-11 | Vernon | Missouri | 29217 | 5100 | 109 |
2496284 | 2496284 | 2022-05-11 | Vernon | Wisconsin | 55123 | 6231 | 98 |
2490983 | 2490983 | 2022-05-10 | Vernon | Louisiana | 22115 | 9935 | 191 |
2491412 | 2491412 | 2022-05-10 | Vernon | Missouri | 29217 | 5100 | 109 |
2493026 | 2493026 | 2022-05-10 | Vernon | Wisconsin | 55123 | 6212 | 98 |
2487726 | 2487726 | 2022-05-09 | Vernon | Louisiana | 22115 | 9933 | 191 |
2488154 | 2488154 | 2022-05-09 | Vernon | Missouri | 29217 | 5100 | 109 |
2489768 | 2489768 | 2022-05-09 | Vernon | Wisconsin | 55123 | 6206 | 98 |
2484468 | 2484468 | 2022-05-08 | Vernon | Louisiana | 22115 | 9933 | 191 |
2484897 | 2484897 | 2022-05-08 | Vernon | Missouri | 29217 | 5100 | 109 |
2486511 | 2486511 | 2022-05-08 | Vernon | Wisconsin | 55123 | 6183 | 97 |
2481210 | 2481210 | 2022-05-07 | Vernon | Louisiana | 22115 | 9933 | 191 |
2481639 | 2481639 | 2022-05-07 | Vernon | Missouri | 29217 | 5100 | 109 |
2483253 | 2483253 | 2022-05-07 | Vernon | Wisconsin | 55123 | 6183 | 97 |
2477952 | 2477952 | 2022-05-06 | Vernon | Louisiana | 22115 | 9933 | 191 |
2478381 | 2478381 | 2022-05-06 | Vernon | Missouri | 29217 | 5100 | 109 |
2479995 | 2479995 | 2022-05-06 | Vernon | Wisconsin | 55123 | 6183 | 97 |
2474694 | 2474694 | 2022-05-05 | Vernon | Louisiana | 22115 | 9933 | 191 |
2475123 | 2475123 | 2022-05-05 | Vernon | Missouri | 29217 | 5094 | 109 |
2476737 | 2476737 | 2022-05-05 | Vernon | Wisconsin | 55123 | 6173 | 97 |
2471437 | 2471437 | 2022-05-04 | Vernon | Louisiana | 22115 | 9933 | 190 |
2471866 | 2471866 | 2022-05-04 | Vernon | Missouri | 29217 | 5051 | 109 |
2473479 | 2473479 | 2022-05-04 | Vernon | Wisconsin | 55123 | 6152 | 97 |
2468181 | 2468181 | 2022-05-03 | Vernon | Louisiana | 22115 | 9933 | 190 |
2468610 | 2468610 | 2022-05-03 | Vernon | Missouri | 29217 | 5051 | 109 |
2470222 | 2470222 | 2022-05-03 | Vernon | Wisconsin | 55123 | 6136 | 97 |
2464926 | 2464926 | 2022-05-02 | Vernon | Louisiana | 22115 | 9933 | 190 |
2465354 | 2465354 | 2022-05-02 | Vernon | Missouri | 29217 | 5051 | 109 |
2466966 | 2466966 | 2022-05-02 | Vernon | Wisconsin | 55123 | 6135 | 97 |
2461670 | 2461670 | 2022-05-01 | Vernon | Louisiana | 22115 | 9933 | 190 |
2462099 | 2462099 | 2022-05-01 | Vernon | Missouri | 29217 | 5051 | 109 |
2463711 | 2463711 | 2022-05-01 | Vernon | Wisconsin | 55123 | 6113 | 97 |
2458414 | 2458414 | 2022-04-30 | Vernon | Louisiana | 22115 | 9933 | 190 |
2458843 | 2458843 | 2022-04-30 | Vernon | Missouri | 29217 | 5051 | 109 |
2460455 | 2460455 | 2022-04-30 | Vernon | Wisconsin | 55123 | 6113 | 97 |
2455158 | 2455158 | 2022-04-29 | Vernon | Louisiana | 22115 | 9933 | 190 |
2455587 | 2455587 | 2022-04-29 | Vernon | Missouri | 29217 | 5051 | 109 |
2457199 | 2457199 | 2022-04-29 | Vernon | Wisconsin | 55123 | 6113 | 97 |
2451902 | 2451902 | 2022-04-28 | Vernon | Louisiana | 22115 | 9933 | 190 |
2452331 | 2452331 | 2022-04-28 | Vernon | Missouri | 29217 | 5051 | 109 |
2453943 | 2453943 | 2022-04-28 | Vernon | Wisconsin | 55123 | 6109 | 97 |
2448646 | 2448646 | 2022-04-27 | Vernon | Louisiana | 22115 | 9933 | 191 |
2449075 | 2449075 | 2022-04-27 | Vernon | Missouri | 29217 | 5051 | 109 |
2450687 | 2450687 | 2022-04-27 | Vernon | Wisconsin | 55123 | 6096 | 97 |
2445390 | 2445390 | 2022-04-26 | Vernon | Louisiana | 22115 | 9933 | 191 |
2445818 | 2445818 | 2022-04-26 | Vernon | Missouri | 29217 | 5051 | 109 |
2447431 | 2447431 | 2022-04-26 | Vernon | Wisconsin | 55123 | 6085 | 97 |
2442134 | 2442134 | 2022-04-25 | Vernon | Louisiana | 22115 | 9932 | 191 |
2442563 | 2442563 | 2022-04-25 | Vernon | Missouri | 29217 | 5051 | 109 |
2444175 | 2444175 | 2022-04-25 | Vernon | Wisconsin | 55123 | 6080 | 96 |
2438878 | 2438878 | 2022-04-24 | Vernon | Louisiana | 22115 | 9932 | 191 |
2439307 | 2439307 | 2022-04-24 | Vernon | Missouri | 29217 | 5051 | 109 |
2440919 | 2440919 | 2022-04-24 | Vernon | Wisconsin | 55123 | 6068 | 96 |
2435622 | 2435622 | 2022-04-23 | Vernon | Louisiana | 22115 | 9932 | 191 |
2436051 | 2436051 | 2022-04-23 | Vernon | Missouri | 29217 | 5051 | 109 |
2437663 | 2437663 | 2022-04-23 | Vernon | Wisconsin | 55123 | 6068 | 96 |
2432366 | 2432366 | 2022-04-22 | Vernon | Louisiana | 22115 | 9932 | 191 |
2432795 | 2432795 | 2022-04-22 | Vernon | Missouri | 29217 | 5051 | 109 |
2434407 | 2434407 | 2022-04-22 | Vernon | Wisconsin | 55123 | 6068 | 96 |
2429110 | 2429110 | 2022-04-21 | Vernon | Louisiana | 22115 | 9932 | 191 |
2429539 | 2429539 | 2022-04-21 | Vernon | Missouri | 29217 | 5051 | 109 |
2431151 | 2431151 | 2022-04-21 | Vernon | Wisconsin | 55123 | 6061 | 96 |
2425854 | 2425854 | 2022-04-20 | Vernon | Louisiana | 22115 | 9931 | 191 |
2426283 | 2426283 | 2022-04-20 | Vernon | Missouri | 29217 | 5051 | 109 |
2427895 | 2427895 | 2022-04-20 | Vernon | Wisconsin | 55123 | 6054 | 96 |
2422598 | 2422598 | 2022-04-19 | Vernon | Louisiana | 22115 | 9931 | 191 |
2423027 | 2423027 | 2022-04-19 | Vernon | Missouri | 29217 | 5051 | 109 |
2424639 | 2424639 | 2022-04-19 | Vernon | Wisconsin | 55123 | 6051 | 96 |
2419342 | 2419342 | 2022-04-18 | Vernon | Louisiana | 22115 | 9931 | 191 |
2419770 | 2419770 | 2022-04-18 | Vernon | Missouri | 29217 | 5051 | 109 |
2421383 | 2421383 | 2022-04-18 | Vernon | Wisconsin | 55123 | 6048 | 96 |
2416086 | 2416086 | 2022-04-17 | Vernon | Louisiana | 22115 | 9928 | 191 |
2416515 | 2416515 | 2022-04-17 | Vernon | Missouri | 29217 | 5051 | 109 |
2418127 | 2418127 | 2022-04-17 | Vernon | Wisconsin | 55123 | 6043 | 96 |
2412830 | 2412830 | 2022-04-16 | Vernon | Louisiana | 22115 | 9928 | 191 |
2413259 | 2413259 | 2022-04-16 | Vernon | Missouri | 29217 | 5051 | 109 |
2414871 | 2414871 | 2022-04-16 | Vernon | Wisconsin | 55123 | 6043 | 96 |
2409574 | 2409574 | 2022-04-15 | Vernon | Louisiana | 22115 | 9928 | 191 |
2410003 | 2410003 | 2022-04-15 | Vernon | Missouri | 29217 | 5051 | 109 |
2411615 | 2411615 | 2022-04-15 | Vernon | Wisconsin | 55123 | 6043 | 96 |
2406318 | 2406318 | 2022-04-14 | Vernon | Louisiana | 22115 | 9928 | 191 |
2406747 | 2406747 | 2022-04-14 | Vernon | Missouri | 29217 | 5051 | 109 |
2408359 | 2408359 | 2022-04-14 | Vernon | Wisconsin | 55123 | 6037 | 96 |
2403062 | 2403062 | 2022-04-13 | Vernon | Louisiana | 22115 | 9928 | 191 |
2403491 | 2403491 | 2022-04-13 | Vernon | Missouri | 29217 | 5051 | 109 |
2405103 | 2405103 | 2022-04-13 | Vernon | Wisconsin | 55123 | 6032 | 96 |
2399808 | 2399808 | 2022-04-12 | Vernon | Louisiana | 22115 | 9927 | 191 |
2400236 | 2400236 | 2022-04-12 | Vernon | Missouri | 29217 | 5051 | 109 |
2401848 | 2401848 | 2022-04-12 | Vernon | Wisconsin | 55123 | 6030 | 96 |
2396552 | 2396552 | 2022-04-11 | Vernon | Louisiana | 22115 | 9926 | 191 |
2396981 | 2396981 | 2022-04-11 | Vernon | Missouri | 29217 | 5051 | 109 |
2398593 | 2398593 | 2022-04-11 | Vernon | Wisconsin | 55123 | 6030 | 96 |
2393297 | 2393297 | 2022-04-10 | Vernon | Louisiana | 22115 | 9924 | 191 |
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);