ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,326 rows where county = "Buchanan" sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
county 1
- Buchanan · 2,326 ✖
Link | rowid | date | county | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
40366 | 40366 | 2020-04-07 | Buchanan | Virginia | 51027 | 1 | 0 |
42935 | 42935 | 2020-04-08 | Buchanan | Virginia | 51027 | 1 | 0 |
45529 | 45529 | 2020-04-09 | Buchanan | Virginia | 51027 | 1 | 0 |
48153 | 48153 | 2020-04-10 | Buchanan | Virginia | 51027 | 1 | 0 |
50811 | 50811 | 2020-04-11 | Buchanan | Virginia | 51027 | 2 | 0 |
53486 | 53486 | 2020-04-12 | Buchanan | Virginia | 51027 | 2 | 0 |
56175 | 56175 | 2020-04-13 | Buchanan | Virginia | 51027 | 2 | 0 |
58881 | 58881 | 2020-04-14 | Buchanan | Virginia | 51027 | 12 | 0 |
61600 | 61600 | 2020-04-15 | Buchanan | Virginia | 51027 | 12 | 0 |
64332 | 64332 | 2020-04-16 | Buchanan | Virginia | 51027 | 12 | 0 |
67080 | 67080 | 2020-04-17 | Buchanan | Virginia | 51027 | 12 | 0 |
69842 | 69842 | 2020-04-18 | Buchanan | Virginia | 51027 | 12 | 0 |
72612 | 72612 | 2020-04-19 | Buchanan | Virginia | 51027 | 12 | 0 |
75388 | 75388 | 2020-04-20 | Buchanan | Virginia | 51027 | 12 | 0 |
78170 | 78170 | 2020-04-21 | Buchanan | Virginia | 51027 | 12 | 0 |
80962 | 80962 | 2020-04-22 | Buchanan | Virginia | 51027 | 12 | 0 |
83763 | 83763 | 2020-04-23 | Buchanan | Virginia | 51027 | 12 | 0 |
86570 | 86570 | 2020-04-24 | Buchanan | Virginia | 51027 | 12 | 0 |
89385 | 89385 | 2020-04-25 | Buchanan | Virginia | 51027 | 13 | 0 |
92202 | 92202 | 2020-04-26 | Buchanan | Virginia | 51027 | 13 | 0 |
95031 | 95031 | 2020-04-27 | Buchanan | Virginia | 51027 | 14 | 0 |
97873 | 97873 | 2020-04-28 | Buchanan | Virginia | 51027 | 16 | 0 |
100723 | 100723 | 2020-04-29 | Buchanan | Virginia | 51027 | 16 | 0 |
103578 | 103578 | 2020-04-30 | Buchanan | Virginia | 51027 | 16 | 0 |
106442 | 106442 | 2020-05-01 | Buchanan | Virginia | 51027 | 16 | 0 |
109311 | 109311 | 2020-05-02 | Buchanan | Virginia | 51027 | 16 | 0 |
112185 | 112185 | 2020-05-03 | Buchanan | Virginia | 51027 | 16 | 0 |
115068 | 115068 | 2020-05-04 | Buchanan | Virginia | 51027 | 16 | 0 |
118027 | 118027 | 2020-05-05 | Buchanan | Virginia | 51027 | 16 | 0 |
120991 | 120991 | 2020-05-06 | Buchanan | Virginia | 51027 | 16 | 0 |
123972 | 123972 | 2020-05-07 | Buchanan | Virginia | 51027 | 16 | 0 |
126957 | 126957 | 2020-05-08 | Buchanan | Virginia | 51027 | 16 | 0 |
129946 | 129946 | 2020-05-09 | Buchanan | Virginia | 51027 | 16 | 0 |
132936 | 132936 | 2020-05-10 | Buchanan | Virginia | 51027 | 16 | 0 |
135926 | 135926 | 2020-05-11 | Buchanan | Virginia | 51027 | 16 | 0 |
138917 | 138917 | 2020-05-12 | Buchanan | Virginia | 51027 | 16 | 0 |
141913 | 141913 | 2020-05-13 | Buchanan | Virginia | 51027 | 16 | 0 |
144910 | 144910 | 2020-05-14 | Buchanan | Virginia | 51027 | 16 | 0 |
147913 | 147913 | 2020-05-15 | Buchanan | Virginia | 51027 | 16 | 0 |
150922 | 150922 | 2020-05-16 | Buchanan | Virginia | 51027 | 16 | 0 |
153933 | 153933 | 2020-05-17 | Buchanan | Virginia | 51027 | 16 | 0 |
156950 | 156950 | 2020-05-18 | Buchanan | Virginia | 51027 | 16 | 0 |
159974 | 159974 | 2020-05-19 | Buchanan | Virginia | 51027 | 18 | 0 |
163002 | 163002 | 2020-05-20 | Buchanan | Virginia | 51027 | 18 | 0 |
166031 | 166031 | 2020-05-21 | Buchanan | Virginia | 51027 | 18 | 0 |
169067 | 169067 | 2020-05-22 | Buchanan | Virginia | 51027 | 18 | 0 |
172108 | 172108 | 2020-05-23 | Buchanan | Virginia | 51027 | 18 | 0 |
175151 | 175151 | 2020-05-24 | Buchanan | Virginia | 51027 | 18 | 0 |
178196 | 178196 | 2020-05-25 | Buchanan | Virginia | 51027 | 18 | 0 |
181240 | 181240 | 2020-05-26 | Buchanan | Virginia | 51027 | 19 | 0 |
184291 | 184291 | 2020-05-27 | Buchanan | Virginia | 51027 | 18 | 0 |
187348 | 187348 | 2020-05-28 | Buchanan | Virginia | 51027 | 18 | 0 |
190412 | 190412 | 2020-05-29 | Buchanan | Virginia | 51027 | 18 | 0 |
193478 | 193478 | 2020-05-30 | Buchanan | Virginia | 51027 | 18 | 0 |
196548 | 196548 | 2020-05-31 | Buchanan | Virginia | 51027 | 18 | 0 |
199621 | 199621 | 2020-06-01 | Buchanan | Virginia | 51027 | 18 | 0 |
202697 | 202697 | 2020-06-02 | Buchanan | Virginia | 51027 | 18 | 0 |
205776 | 205776 | 2020-06-03 | Buchanan | Virginia | 51027 | 18 | 0 |
208858 | 208858 | 2020-06-04 | Buchanan | Virginia | 51027 | 18 | 0 |
211943 | 211943 | 2020-06-05 | Buchanan | Virginia | 51027 | 18 | 0 |
215030 | 215030 | 2020-06-06 | Buchanan | Virginia | 51027 | 18 | 0 |
218120 | 218120 | 2020-06-07 | Buchanan | Virginia | 51027 | 18 | 0 |
221212 | 221212 | 2020-06-08 | Buchanan | Virginia | 51027 | 18 | 0 |
224308 | 224308 | 2020-06-09 | Buchanan | Virginia | 51027 | 18 | 0 |
227408 | 227408 | 2020-06-10 | Buchanan | Virginia | 51027 | 18 | 0 |
230512 | 230512 | 2020-06-11 | Buchanan | Virginia | 51027 | 18 | 0 |
233617 | 233617 | 2020-06-12 | Buchanan | Virginia | 51027 | 18 | 0 |
236724 | 236724 | 2020-06-13 | Buchanan | Virginia | 51027 | 18 | 0 |
239832 | 239832 | 2020-06-14 | Buchanan | Virginia | 51027 | 18 | 0 |
242943 | 242943 | 2020-06-15 | Buchanan | Virginia | 51027 | 18 | 0 |
246055 | 246055 | 2020-06-16 | Buchanan | Virginia | 51027 | 18 | 0 |
249167 | 249167 | 2020-06-17 | Buchanan | Virginia | 51027 | 18 | 0 |
252282 | 252282 | 2020-06-18 | Buchanan | Virginia | 51027 | 18 | 0 |
255401 | 255401 | 2020-06-19 | Buchanan | Virginia | 51027 | 18 | 0 |
258528 | 258528 | 2020-06-20 | Buchanan | Virginia | 51027 | 18 | 0 |
261655 | 261655 | 2020-06-21 | Buchanan | Virginia | 51027 | 18 | 0 |
264784 | 264784 | 2020-06-22 | Buchanan | Virginia | 51027 | 18 | 0 |
267913 | 267913 | 2020-06-23 | Buchanan | Virginia | 51027 | 18 | 0 |
271047 | 271047 | 2020-06-24 | Buchanan | Virginia | 51027 | 18 | 0 |
274187 | 274187 | 2020-06-25 | Buchanan | Virginia | 51027 | 18 | 0 |
277335 | 277335 | 2020-06-26 | Buchanan | Virginia | 51027 | 18 | 0 |
280483 | 280483 | 2020-06-27 | Buchanan | Virginia | 51027 | 31 | 0 |
283629 | 283629 | 2020-06-28 | Buchanan | Virginia | 51027 | 31 | 0 |
286775 | 286775 | 2020-06-29 | Buchanan | Virginia | 51027 | 31 | 0 |
289925 | 289925 | 2020-06-30 | Buchanan | Virginia | 51027 | 31 | 0 |
293078 | 293078 | 2020-07-01 | Buchanan | Virginia | 51027 | 31 | 0 |
296233 | 296233 | 2020-07-02 | Buchanan | Virginia | 51027 | 31 | 0 |
299395 | 299395 | 2020-07-03 | Buchanan | Virginia | 51027 | 31 | 0 |
302559 | 302559 | 2020-07-04 | Buchanan | Virginia | 51027 | 31 | 0 |
305723 | 305723 | 2020-07-05 | Buchanan | Virginia | 51027 | 33 | 0 |
308891 | 308891 | 2020-07-06 | Buchanan | Virginia | 51027 | 33 | 0 |
312060 | 312060 | 2020-07-07 | Buchanan | Virginia | 51027 | 34 | 0 |
315235 | 315235 | 2020-07-08 | Buchanan | Virginia | 51027 | 36 | 0 |
318408 | 318408 | 2020-07-09 | Buchanan | Virginia | 51027 | 38 | 0 |
321587 | 321587 | 2020-07-10 | Buchanan | Virginia | 51027 | 39 | 0 |
324768 | 324768 | 2020-07-11 | Buchanan | Virginia | 51027 | 39 | 0 |
327953 | 327953 | 2020-07-12 | Buchanan | Virginia | 51027 | 39 | 0 |
331139 | 331139 | 2020-07-13 | Buchanan | Virginia | 51027 | 42 | 0 |
334332 | 334332 | 2020-07-14 | Buchanan | Virginia | 51027 | 46 | 0 |
337527 | 337527 | 2020-07-15 | Buchanan | Virginia | 51027 | 48 | 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);