ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Washington" and state = "Vermont" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2266 | 2266 | 2020-03-14 | Washington | Vermont | 50023 | 1 | 0 |
2693 | 2693 | 2020-03-15 | Washington | Vermont | 50023 | 1 | 0 |
3165 | 3165 | 2020-03-16 | Washington | Vermont | 50023 | 1 | 0 |
3701 | 3701 | 2020-03-17 | Washington | Vermont | 50023 | 1 | 0 |
4333 | 4333 | 2020-03-18 | Washington | Vermont | 50023 | 1 | 0 |
5089 | 5089 | 2020-03-19 | Washington | Vermont | 50023 | 1 | 0 |
5985 | 5985 | 2020-03-20 | Washington | Vermont | 50023 | 2 | 0 |
7009 | 7009 | 2020-03-21 | Washington | Vermont | 50023 | 2 | 0 |
8139 | 8139 | 2020-03-22 | Washington | Vermont | 50023 | 2 | 0 |
9360 | 9360 | 2020-03-23 | Washington | Vermont | 50023 | 2 | 0 |
10706 | 10706 | 2020-03-24 | Washington | Vermont | 50023 | 3 | 0 |
12218 | 12218 | 2020-03-25 | Washington | Vermont | 50023 | 5 | 0 |
13854 | 13854 | 2020-03-26 | Washington | Vermont | 50023 | 7 | 0 |
15620 | 15620 | 2020-03-27 | Washington | Vermont | 50023 | 9 | 0 |
17494 | 17494 | 2020-03-28 | Washington | Vermont | 50023 | 10 | 0 |
19453 | 19453 | 2020-03-29 | Washington | Vermont | 50023 | 12 | 0 |
21516 | 21516 | 2020-03-30 | Washington | Vermont | 50023 | 13 | 0 |
23655 | 23655 | 2020-03-31 | Washington | Vermont | 50023 | 15 | 0 |
25870 | 25870 | 2020-04-01 | Washington | Vermont | 50023 | 15 | 0 |
28159 | 28159 | 2020-04-02 | Washington | Vermont | 50023 | 15 | 0 |
30502 | 30502 | 2020-04-03 | Washington | Vermont | 50023 | 21 | 0 |
32900 | 32900 | 2020-04-04 | Washington | Vermont | 50023 | 21 | 0 |
35338 | 35338 | 2020-04-05 | Washington | Vermont | 50023 | 22 | 0 |
37816 | 37816 | 2020-04-06 | Washington | Vermont | 50023 | 22 | 0 |
40346 | 40346 | 2020-04-07 | Washington | Vermont | 50023 | 24 | 0 |
42915 | 42915 | 2020-04-08 | Washington | Vermont | 50023 | 24 | 0 |
45509 | 45509 | 2020-04-09 | Washington | Vermont | 50023 | 24 | 0 |
48133 | 48133 | 2020-04-10 | Washington | Vermont | 50023 | 24 | 0 |
50791 | 50791 | 2020-04-11 | Washington | Vermont | 50023 | 28 | 0 |
53466 | 53466 | 2020-04-12 | Washington | Vermont | 50023 | 28 | 0 |
56155 | 56155 | 2020-04-13 | Washington | Vermont | 50023 | 28 | 0 |
58861 | 58861 | 2020-04-14 | Washington | Vermont | 50023 | 29 | 0 |
61580 | 61580 | 2020-04-15 | Washington | Vermont | 50023 | 29 | 0 |
64312 | 64312 | 2020-04-16 | Washington | Vermont | 50023 | 29 | 1 |
67060 | 67060 | 2020-04-17 | Washington | Vermont | 50023 | 30 | 1 |
69822 | 69822 | 2020-04-18 | Washington | Vermont | 50023 | 31 | 1 |
72592 | 72592 | 2020-04-19 | Washington | Vermont | 50023 | 32 | 1 |
75368 | 75368 | 2020-04-20 | Washington | Vermont | 50023 | 32 | 1 |
78150 | 78150 | 2020-04-21 | Washington | Vermont | 50023 | 32 | 1 |
80942 | 80942 | 2020-04-22 | Washington | Vermont | 50023 | 33 | 1 |
83743 | 83743 | 2020-04-23 | Washington | Vermont | 50023 | 33 | 1 |
86550 | 86550 | 2020-04-24 | Washington | Vermont | 50023 | 33 | 1 |
89365 | 89365 | 2020-04-25 | Washington | Vermont | 50023 | 33 | 1 |
92182 | 92182 | 2020-04-26 | Washington | Vermont | 50023 | 33 | 1 |
95011 | 95011 | 2020-04-27 | Washington | Vermont | 50023 | 32 | 1 |
97853 | 97853 | 2020-04-28 | Washington | Vermont | 50023 | 32 | 1 |
100703 | 100703 | 2020-04-29 | Washington | Vermont | 50023 | 32 | 1 |
103558 | 103558 | 2020-04-30 | Washington | Vermont | 50023 | 33 | 1 |
106422 | 106422 | 2020-05-01 | Washington | Vermont | 50023 | 33 | 1 |
109291 | 109291 | 2020-05-02 | Washington | Vermont | 50023 | 33 | 1 |
112165 | 112165 | 2020-05-03 | Washington | Vermont | 50023 | 35 | 1 |
115048 | 115048 | 2020-05-04 | Washington | Vermont | 50023 | 35 | 1 |
118007 | 118007 | 2020-05-05 | Washington | Vermont | 50023 | 35 | 1 |
120971 | 120971 | 2020-05-06 | Washington | Vermont | 50023 | 36 | 1 |
123952 | 123952 | 2020-05-07 | Washington | Vermont | 50023 | 37 | 1 |
126937 | 126937 | 2020-05-08 | Washington | Vermont | 50023 | 37 | 1 |
129926 | 129926 | 2020-05-09 | Washington | Vermont | 50023 | 37 | 1 |
132916 | 132916 | 2020-05-10 | Washington | Vermont | 50023 | 38 | 1 |
135906 | 135906 | 2020-05-11 | Washington | Vermont | 50023 | 38 | 1 |
138897 | 138897 | 2020-05-12 | Washington | Vermont | 50023 | 38 | 1 |
141893 | 141893 | 2020-05-13 | Washington | Vermont | 50023 | 38 | 1 |
144890 | 144890 | 2020-05-14 | Washington | Vermont | 50023 | 38 | 1 |
147893 | 147893 | 2020-05-15 | Washington | Vermont | 50023 | 38 | 1 |
150902 | 150902 | 2020-05-16 | Washington | Vermont | 50023 | 38 | 1 |
153913 | 153913 | 2020-05-17 | Washington | Vermont | 50023 | 38 | 1 |
156930 | 156930 | 2020-05-18 | Washington | Vermont | 50023 | 38 | 1 |
159954 | 159954 | 2020-05-19 | Washington | Vermont | 50023 | 38 | 1 |
162982 | 162982 | 2020-05-20 | Washington | Vermont | 50023 | 38 | 1 |
166011 | 166011 | 2020-05-21 | Washington | Vermont | 50023 | 38 | 1 |
169047 | 169047 | 2020-05-22 | Washington | Vermont | 50023 | 38 | 1 |
172088 | 172088 | 2020-05-23 | Washington | Vermont | 50023 | 39 | 1 |
175131 | 175131 | 2020-05-24 | Washington | Vermont | 50023 | 39 | 1 |
178176 | 178176 | 2020-05-25 | Washington | Vermont | 50023 | 39 | 1 |
181220 | 181220 | 2020-05-26 | Washington | Vermont | 50023 | 39 | 1 |
184271 | 184271 | 2020-05-27 | Washington | Vermont | 50023 | 39 | 1 |
187328 | 187328 | 2020-05-28 | Washington | Vermont | 50023 | 39 | 1 |
190392 | 190392 | 2020-05-29 | Washington | Vermont | 50023 | 39 | 1 |
193458 | 193458 | 2020-05-30 | Washington | Vermont | 50023 | 39 | 1 |
196528 | 196528 | 2020-05-31 | Washington | Vermont | 50023 | 39 | 1 |
199601 | 199601 | 2020-06-01 | Washington | Vermont | 50023 | 39 | 1 |
202677 | 202677 | 2020-06-02 | Washington | Vermont | 50023 | 39 | 1 |
205756 | 205756 | 2020-06-03 | Washington | Vermont | 50023 | 39 | 1 |
208838 | 208838 | 2020-06-04 | Washington | Vermont | 50023 | 39 | 1 |
211923 | 211923 | 2020-06-05 | Washington | Vermont | 50023 | 39 | 1 |
215010 | 215010 | 2020-06-06 | Washington | Vermont | 50023 | 39 | 1 |
218100 | 218100 | 2020-06-07 | Washington | Vermont | 50023 | 39 | 1 |
221192 | 221192 | 2020-06-08 | Washington | Vermont | 50023 | 39 | 1 |
224288 | 224288 | 2020-06-09 | Washington | Vermont | 50023 | 39 | 1 |
227388 | 227388 | 2020-06-10 | Washington | Vermont | 50023 | 39 | 1 |
230492 | 230492 | 2020-06-11 | Washington | Vermont | 50023 | 39 | 1 |
233597 | 233597 | 2020-06-12 | Washington | Vermont | 50023 | 40 | 1 |
236704 | 236704 | 2020-06-13 | Washington | Vermont | 50023 | 41 | 1 |
239812 | 239812 | 2020-06-14 | Washington | Vermont | 50023 | 41 | 1 |
242923 | 242923 | 2020-06-15 | Washington | Vermont | 50023 | 41 | 1 |
246035 | 246035 | 2020-06-16 | Washington | Vermont | 50023 | 41 | 1 |
249147 | 249147 | 2020-06-17 | Washington | Vermont | 50023 | 41 | 1 |
252262 | 252262 | 2020-06-18 | Washington | Vermont | 50023 | 41 | 1 |
255380 | 255380 | 2020-06-19 | Washington | Vermont | 50023 | 41 | 1 |
258507 | 258507 | 2020-06-20 | Washington | Vermont | 50023 | 41 | 1 |
261634 | 261634 | 2020-06-21 | Washington | Vermont | 50023 | 41 | 1 |
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);