ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Vernon" and state = "Louisiana" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
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 |
46813 | 46813 | 2020-04-10 | Vernon | Louisiana | 22115 | 13 | 0 |
49455 | 49455 | 2020-04-11 | Vernon | Louisiana | 22115 | 14 | 0 |
52125 | 52125 | 2020-04-12 | Vernon | Louisiana | 22115 | 14 | 0 |
54806 | 54806 | 2020-04-13 | Vernon | Louisiana | 22115 | 14 | 0 |
57504 | 57504 | 2020-04-14 | Vernon | Louisiana | 22115 | 14 | 1 |
60212 | 60212 | 2020-04-15 | Vernon | Louisiana | 22115 | 14 | 1 |
62933 | 62933 | 2020-04-16 | Vernon | Louisiana | 22115 | 14 | 1 |
65672 | 65672 | 2020-04-17 | Vernon | Louisiana | 22115 | 14 | 1 |
68421 | 68421 | 2020-04-18 | Vernon | Louisiana | 22115 | 14 | 1 |
71184 | 71184 | 2020-04-19 | Vernon | Louisiana | 22115 | 14 | 1 |
73956 | 73956 | 2020-04-20 | Vernon | Louisiana | 22115 | 14 | 1 |
76736 | 76736 | 2020-04-21 | Vernon | Louisiana | 22115 | 14 | 1 |
79522 | 79522 | 2020-04-22 | Vernon | Louisiana | 22115 | 14 | 1 |
82318 | 82318 | 2020-04-23 | Vernon | Louisiana | 22115 | 14 | 1 |
85122 | 85122 | 2020-04-24 | Vernon | Louisiana | 22115 | 15 | 1 |
87931 | 87931 | 2020-04-25 | Vernon | Louisiana | 22115 | 16 | 2 |
90747 | 90747 | 2020-04-26 | Vernon | Louisiana | 22115 | 16 | 2 |
93568 | 93568 | 2020-04-27 | Vernon | Louisiana | 22115 | 16 | 2 |
96403 | 96403 | 2020-04-28 | Vernon | Louisiana | 22115 | 16 | 2 |
99249 | 99249 | 2020-04-29 | Vernon | Louisiana | 22115 | 16 | 2 |
102101 | 102101 | 2020-04-30 | Vernon | Louisiana | 22115 | 16 | 2 |
104962 | 104962 | 2020-05-01 | Vernon | Louisiana | 22115 | 16 | 2 |
107826 | 107826 | 2020-05-02 | Vernon | Louisiana | 22115 | 16 | 2 |
110698 | 110698 | 2020-05-03 | Vernon | Louisiana | 22115 | 16 | 2 |
113575 | 113575 | 2020-05-04 | Vernon | Louisiana | 22115 | 16 | 2 |
116457 | 116457 | 2020-05-05 | Vernon | Louisiana | 22115 | 17 | 2 |
119418 | 119418 | 2020-05-06 | Vernon | Louisiana | 22115 | 17 | 2 |
122389 | 122389 | 2020-05-07 | Vernon | Louisiana | 22115 | 17 | 2 |
125371 | 125371 | 2020-05-08 | Vernon | Louisiana | 22115 | 17 | 2 |
128358 | 128358 | 2020-05-09 | Vernon | Louisiana | 22115 | 18 | 2 |
131348 | 131348 | 2020-05-10 | Vernon | Louisiana | 22115 | 18 | 2 |
134339 | 134339 | 2020-05-11 | Vernon | Louisiana | 22115 | 18 | 2 |
137329 | 137329 | 2020-05-12 | Vernon | Louisiana | 22115 | 18 | 2 |
140323 | 140323 | 2020-05-13 | Vernon | Louisiana | 22115 | 19 | 2 |
143318 | 143318 | 2020-05-14 | Vernon | Louisiana | 22115 | 19 | 2 |
146318 | 146318 | 2020-05-15 | Vernon | Louisiana | 22115 | 19 | 2 |
149323 | 149323 | 2020-05-16 | Vernon | Louisiana | 22115 | 20 | 2 |
152334 | 152334 | 2020-05-17 | Vernon | Louisiana | 22115 | 20 | 2 |
155348 | 155348 | 2020-05-18 | Vernon | Louisiana | 22115 | 21 | 2 |
158366 | 158366 | 2020-05-19 | Vernon | Louisiana | 22115 | 21 | 2 |
161392 | 161392 | 2020-05-20 | Vernon | Louisiana | 22115 | 21 | 2 |
164421 | 164421 | 2020-05-21 | Vernon | Louisiana | 22115 | 22 | 2 |
167457 | 167457 | 2020-05-22 | Vernon | Louisiana | 22115 | 23 | 3 |
170495 | 170495 | 2020-05-23 | Vernon | Louisiana | 22115 | 23 | 3 |
173536 | 173536 | 2020-05-24 | Vernon | Louisiana | 22115 | 23 | 3 |
176580 | 176580 | 2020-05-25 | Vernon | Louisiana | 22115 | 24 | 3 |
179624 | 179624 | 2020-05-26 | Vernon | Louisiana | 22115 | 24 | 3 |
182669 | 182669 | 2020-05-27 | Vernon | Louisiana | 22115 | 24 | 3 |
185724 | 185724 | 2020-05-28 | Vernon | Louisiana | 22115 | 25 | 3 |
188782 | 188782 | 2020-05-29 | Vernon | Louisiana | 22115 | 25 | 3 |
191846 | 191846 | 2020-05-30 | Vernon | Louisiana | 22115 | 25 | 3 |
194914 | 194914 | 2020-05-31 | Vernon | Louisiana | 22115 | 26 | 3 |
197985 | 197985 | 2020-06-01 | Vernon | Louisiana | 22115 | 26 | 3 |
201057 | 201057 | 2020-06-02 | Vernon | Louisiana | 22115 | 28 | 3 |
204134 | 204134 | 2020-06-03 | Vernon | Louisiana | 22115 | 28 | 3 |
207215 | 207215 | 2020-06-04 | Vernon | Louisiana | 22115 | 29 | 3 |
210296 | 210296 | 2020-06-05 | Vernon | Louisiana | 22115 | 31 | 3 |
213381 | 213381 | 2020-06-06 | Vernon | Louisiana | 22115 | 33 | 3 |
216468 | 216468 | 2020-06-07 | Vernon | Louisiana | 22115 | 34 | 3 |
219560 | 219560 | 2020-06-08 | Vernon | Louisiana | 22115 | 34 | 3 |
222655 | 222655 | 2020-06-09 | Vernon | Louisiana | 22115 | 39 | 3 |
225751 | 225751 | 2020-06-10 | Vernon | Louisiana | 22115 | 39 | 3 |
228853 | 228853 | 2020-06-11 | Vernon | Louisiana | 22115 | 39 | 3 |
231957 | 231957 | 2020-06-12 | Vernon | Louisiana | 22115 | 43 | 3 |
235062 | 235062 | 2020-06-13 | Vernon | Louisiana | 22115 | 51 | 3 |
238169 | 238169 | 2020-06-14 | Vernon | Louisiana | 22115 | 53 | 3 |
241278 | 241278 | 2020-06-15 | Vernon | Louisiana | 22115 | 54 | 3 |
244389 | 244389 | 2020-06-16 | Vernon | Louisiana | 22115 | 58 | 3 |
247502 | 247502 | 2020-06-17 | Vernon | Louisiana | 22115 | 67 | 3 |
250614 | 250614 | 2020-06-18 | Vernon | Louisiana | 22115 | 67 | 3 |
253729 | 253729 | 2020-06-19 | Vernon | Louisiana | 22115 | 73 | 4 |
256849 | 256849 | 2020-06-20 | Vernon | Louisiana | 22115 | 74 | 4 |
259975 | 259975 | 2020-06-21 | Vernon | Louisiana | 22115 | 76 | 4 |
263104 | 263104 | 2020-06-22 | Vernon | Louisiana | 22115 | 77 | 5 |
266231 | 266231 | 2020-06-23 | Vernon | Louisiana | 22115 | 89 | 6 |
269364 | 269364 | 2020-06-24 | Vernon | Louisiana | 22115 | 91 | 6 |
272500 | 272500 | 2020-06-25 | Vernon | Louisiana | 22115 | 96 | 6 |
275643 | 275643 | 2020-06-26 | Vernon | Louisiana | 22115 | 107 | 7 |
278791 | 278791 | 2020-06-27 | Vernon | Louisiana | 22115 | 107 | 7 |
281939 | 281939 | 2020-06-28 | Vernon | Louisiana | 22115 | 111 | 7 |
285085 | 285085 | 2020-06-29 | Vernon | Louisiana | 22115 | 116 | 7 |
288234 | 288234 | 2020-06-30 | Vernon | Louisiana | 22115 | 138 | 8 |
291385 | 291385 | 2020-07-01 | Vernon | Louisiana | 22115 | 153 | 8 |
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);