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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
county 1
- Vernon · 2,296 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
10010 | 10010 | 2020-03-24 | Vernon | Louisiana | 22115 | 2 | 0 |
11418 | 11418 | 2020-03-25 | Vernon | Louisiana | 22115 | 2 | 0 |
12998 | 12998 | 2020-03-26 | Vernon | Louisiana | 22115 | 2 | 0 |
14705 | 14705 | 2020-03-27 | Vernon | Louisiana | 22115 | 2 | 0 |
16525 | 16525 | 2020-03-28 | Vernon | Louisiana | 22115 | 2 | 0 |
18439 | 18439 | 2020-03-29 | Vernon | Louisiana | 22115 | 2 | 0 |
20455 | 20455 | 2020-03-30 | Vernon | Louisiana | 22115 | 3 | 0 |
22564 | 22564 | 2020-03-31 | Vernon | Louisiana | 22115 | 3 | 0 |
24740 | 24740 | 2020-04-01 | Vernon | Louisiana | 22115 | 6 | 0 |
26991 | 26991 | 2020-04-02 | Vernon | Louisiana | 22115 | 7 | 0 |
29308 | 29308 | 2020-04-03 | Vernon | Louisiana | 22115 | 8 | 0 |
31686 | 31686 | 2020-04-04 | Vernon | Louisiana | 22115 | 11 | 0 |
34111 | 34111 | 2020-04-05 | Vernon | Louisiana | 22115 | 10 | 0 |
36569 | 36569 | 2020-04-06 | Vernon | Louisiana | 22115 | 10 | 0 |
39077 | 39077 | 2020-04-07 | Vernon | Louisiana | 22115 | 11 | 0 |
41629 | 41629 | 2020-04-08 | Vernon | Louisiana | 22115 | 11 | 0 |
44205 | 44205 | 2020-04-09 | Vernon | Louisiana | 22115 | 11 | 0 |
44570 | 44570 | 2020-04-09 | Vernon | Missouri | 29217 | 1 | 0 |
46813 | 46813 | 2020-04-10 | Vernon | Louisiana | 22115 | 13 | 0 |
47179 | 47179 | 2020-04-10 | Vernon | Missouri | 29217 | 3 | 0 |
49455 | 49455 | 2020-04-11 | Vernon | Louisiana | 22115 | 14 | 0 |
49827 | 49827 | 2020-04-11 | Vernon | Missouri | 29217 | 3 | 0 |
52125 | 52125 | 2020-04-12 | Vernon | Louisiana | 22115 | 14 | 0 |
52500 | 52500 | 2020-04-12 | Vernon | Missouri | 29217 | 3 | 0 |
54806 | 54806 | 2020-04-13 | Vernon | Louisiana | 22115 | 14 | 0 |
55181 | 55181 | 2020-04-13 | Vernon | Missouri | 29217 | 3 | 0 |
57880 | 57880 | 2020-04-14 | Vernon | Missouri | 29217 | 3 | 0 |
60593 | 60593 | 2020-04-15 | Vernon | Missouri | 29217 | 3 | 0 |
63316 | 63316 | 2020-04-16 | Vernon | Missouri | 29217 | 4 | 0 |
66056 | 66056 | 2020-04-17 | Vernon | Missouri | 29217 | 4 | 0 |
68810 | 68810 | 2020-04-18 | Vernon | Missouri | 29217 | 4 | 0 |
71577 | 71577 | 2020-04-19 | Vernon | Missouri | 29217 | 4 | 0 |
74350 | 74350 | 2020-04-20 | Vernon | Missouri | 29217 | 4 | 0 |
77130 | 77130 | 2020-04-21 | Vernon | Missouri | 29217 | 3 | 0 |
79918 | 79918 | 2020-04-22 | Vernon | Missouri | 29217 | 4 | 0 |
82714 | 82714 | 2020-04-23 | Vernon | Missouri | 29217 | 4 | 0 |
85518 | 85518 | 2020-04-24 | Vernon | Missouri | 29217 | 4 | 0 |
86826 | 86826 | 2020-04-24 | Vernon | Wisconsin | 55123 | 1 | 0 |
88328 | 88328 | 2020-04-25 | Vernon | Missouri | 29217 | 4 | 0 |
89642 | 89642 | 2020-04-25 | Vernon | Wisconsin | 55123 | 1 | 0 |
91143 | 91143 | 2020-04-26 | Vernon | Missouri | 29217 | 4 | 0 |
92460 | 92460 | 2020-04-26 | Vernon | Wisconsin | 55123 | 1 | 0 |
93964 | 93964 | 2020-04-27 | Vernon | Missouri | 29217 | 4 | 0 |
95290 | 95290 | 2020-04-27 | Vernon | Wisconsin | 55123 | 1 | 0 |
96800 | 96800 | 2020-04-28 | Vernon | Missouri | 29217 | 4 | 0 |
98135 | 98135 | 2020-04-28 | Vernon | Wisconsin | 55123 | 1 | 0 |
99646 | 99646 | 2020-04-29 | Vernon | Missouri | 29217 | 4 | 0 |
100985 | 100985 | 2020-04-29 | Vernon | Wisconsin | 55123 | 1 | 0 |
102498 | 102498 | 2020-04-30 | Vernon | Missouri | 29217 | 4 | 0 |
103840 | 103840 | 2020-04-30 | Vernon | Wisconsin | 55123 | 1 | 0 |
105359 | 105359 | 2020-05-01 | Vernon | Missouri | 29217 | 4 | 0 |
106705 | 106705 | 2020-05-01 | Vernon | Wisconsin | 55123 | 1 | 0 |
108225 | 108225 | 2020-05-02 | Vernon | Missouri | 29217 | 4 | 0 |
109574 | 109574 | 2020-05-02 | Vernon | Wisconsin | 55123 | 1 | 0 |
111097 | 111097 | 2020-05-03 | Vernon | Missouri | 29217 | 4 | 0 |
112449 | 112449 | 2020-05-03 | Vernon | Wisconsin | 55123 | 1 | 0 |
113976 | 113976 | 2020-05-04 | Vernon | Missouri | 29217 | 4 | 0 |
115332 | 115332 | 2020-05-04 | Vernon | Wisconsin | 55123 | 2 | 0 |
116858 | 116858 | 2020-05-05 | Vernon | Missouri | 29217 | 4 | 0 |
118291 | 118291 | 2020-05-05 | Vernon | Wisconsin | 55123 | 2 | 0 |
119818 | 119818 | 2020-05-06 | Vernon | Missouri | 29217 | 5 | 0 |
121257 | 121257 | 2020-05-06 | Vernon | Wisconsin | 55123 | 2 | 0 |
122792 | 122792 | 2020-05-07 | Vernon | Missouri | 29217 | 4 | 0 |
124237 | 124237 | 2020-05-07 | Vernon | Wisconsin | 55123 | 2 | 0 |
125774 | 125774 | 2020-05-08 | Vernon | Missouri | 29217 | 4 | 0 |
127222 | 127222 | 2020-05-08 | Vernon | Wisconsin | 55123 | 3 | 0 |
128762 | 128762 | 2020-05-09 | Vernon | Missouri | 29217 | 4 | 0 |
130212 | 130212 | 2020-05-09 | Vernon | Wisconsin | 55123 | 3 | 0 |
131752 | 131752 | 2020-05-10 | Vernon | Missouri | 29217 | 4 | 0 |
133202 | 133202 | 2020-05-10 | Vernon | Wisconsin | 55123 | 3 | 0 |
134743 | 134743 | 2020-05-11 | Vernon | Missouri | 29217 | 4 | 0 |
136192 | 136192 | 2020-05-11 | Vernon | Wisconsin | 55123 | 3 | 0 |
137733 | 137733 | 2020-05-12 | Vernon | Missouri | 29217 | 4 | 0 |
139183 | 139183 | 2020-05-12 | Vernon | Wisconsin | 55123 | 4 | 0 |
140727 | 140727 | 2020-05-13 | Vernon | Missouri | 29217 | 4 | 0 |
142179 | 142179 | 2020-05-13 | Vernon | Wisconsin | 55123 | 6 | 0 |
143722 | 143722 | 2020-05-14 | Vernon | Missouri | 29217 | 4 | 0 |
145178 | 145178 | 2020-05-14 | Vernon | Wisconsin | 55123 | 7 | 0 |
146723 | 146723 | 2020-05-15 | Vernon | Missouri | 29217 | 4 | 0 |
148181 | 148181 | 2020-05-15 | Vernon | Wisconsin | 55123 | 8 | 0 |
149729 | 149729 | 2020-05-16 | Vernon | Missouri | 29217 | 5 | 0 |
151190 | 151190 | 2020-05-16 | Vernon | Wisconsin | 55123 | 10 | 0 |
152740 | 152740 | 2020-05-17 | Vernon | Missouri | 29217 | 5 | 0 |
154202 | 154202 | 2020-05-17 | Vernon | Wisconsin | 55123 | 11 | 0 |
155754 | 155754 | 2020-05-18 | Vernon | Missouri | 29217 | 5 | 0 |
157218 | 157218 | 2020-05-18 | Vernon | Wisconsin | 55123 | 11 | 0 |
158772 | 158772 | 2020-05-19 | Vernon | Missouri | 29217 | 5 | 0 |
160242 | 160242 | 2020-05-19 | Vernon | Wisconsin | 55123 | 12 | 0 |
161798 | 161798 | 2020-05-20 | Vernon | Missouri | 29217 | 6 | 0 |
163270 | 163270 | 2020-05-20 | Vernon | Wisconsin | 55123 | 12 | 0 |
164827 | 164827 | 2020-05-21 | Vernon | Missouri | 29217 | 7 | 0 |
166301 | 166301 | 2020-05-21 | Vernon | Wisconsin | 55123 | 13 | 0 |
167863 | 167863 | 2020-05-22 | Vernon | Missouri | 29217 | 7 | 0 |
169337 | 169337 | 2020-05-22 | Vernon | Wisconsin | 55123 | 14 | 0 |
170902 | 170902 | 2020-05-23 | Vernon | Missouri | 29217 | 7 | 0 |
172378 | 172378 | 2020-05-23 | Vernon | Wisconsin | 55123 | 14 | 0 |
173944 | 173944 | 2020-05-24 | Vernon | Missouri | 29217 | 7 | 0 |
175421 | 175421 | 2020-05-24 | Vernon | Wisconsin | 55123 | 16 | 0 |
176987 | 176987 | 2020-05-25 | Vernon | Missouri | 29217 | 7 | 0 |
178466 | 178466 | 2020-05-25 | Vernon | Wisconsin | 55123 | 16 | 0 |
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);