ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,552 rows where county = "Hampshire" sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
Link | rowid | date | county | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
43086 | 43086 | 2020-04-08 | Hampshire | West Virginia | 54027 | 2 | 0 |
45682 | 45682 | 2020-04-09 | Hampshire | West Virginia | 54027 | 2 | 0 |
48310 | 48310 | 2020-04-10 | Hampshire | West Virginia | 54027 | 2 | 0 |
50968 | 50968 | 2020-04-11 | Hampshire | West Virginia | 54027 | 4 | 0 |
53644 | 53644 | 2020-04-12 | Hampshire | West Virginia | 54027 | 4 | 0 |
56334 | 56334 | 2020-04-13 | Hampshire | West Virginia | 54027 | 5 | 0 |
59040 | 59040 | 2020-04-14 | Hampshire | West Virginia | 54027 | 7 | 0 |
61759 | 61759 | 2020-04-15 | Hampshire | West Virginia | 54027 | 7 | 0 |
64492 | 64492 | 2020-04-16 | Hampshire | West Virginia | 54027 | 6 | 0 |
67240 | 67240 | 2020-04-17 | Hampshire | West Virginia | 54027 | 6 | 0 |
70002 | 70002 | 2020-04-18 | Hampshire | West Virginia | 54027 | 6 | 0 |
72771 | 72771 | 2020-04-19 | Hampshire | West Virginia | 54027 | 6 | 1 |
75547 | 75547 | 2020-04-20 | Hampshire | West Virginia | 54027 | 6 | 1 |
78330 | 78330 | 2020-04-21 | Hampshire | West Virginia | 54027 | 7 | 1 |
81123 | 81123 | 2020-04-22 | Hampshire | West Virginia | 54027 | 7 | 1 |
83924 | 83924 | 2020-04-23 | Hampshire | West Virginia | 54027 | 7 | 1 |
86731 | 86731 | 2020-04-24 | Hampshire | West Virginia | 54027 | 7 | 1 |
89547 | 89547 | 2020-04-25 | Hampshire | West Virginia | 54027 | 7 | 1 |
92365 | 92365 | 2020-04-26 | Hampshire | West Virginia | 54027 | 7 | 1 |
95194 | 95194 | 2020-04-27 | Hampshire | West Virginia | 54027 | 7 | 1 |
98039 | 98039 | 2020-04-28 | Hampshire | West Virginia | 54027 | 7 | 1 |
100889 | 100889 | 2020-04-29 | Hampshire | West Virginia | 54027 | 7 | 1 |
103744 | 103744 | 2020-04-30 | Hampshire | West Virginia | 54027 | 7 | 1 |
106608 | 106608 | 2020-05-01 | Hampshire | West Virginia | 54027 | 7 | 1 |
109477 | 109477 | 2020-05-02 | Hampshire | West Virginia | 54027 | 7 | 1 |
112351 | 112351 | 2020-05-03 | Hampshire | West Virginia | 54027 | 7 | 1 |
115234 | 115234 | 2020-05-04 | Hampshire | West Virginia | 54027 | 8 | 1 |
118193 | 118193 | 2020-05-05 | Hampshire | West Virginia | 54027 | 8 | 1 |
121158 | 121158 | 2020-05-06 | Hampshire | West Virginia | 54027 | 8 | 1 |
124138 | 124138 | 2020-05-07 | Hampshire | West Virginia | 54027 | 8 | 1 |
127123 | 127123 | 2020-05-08 | Hampshire | West Virginia | 54027 | 8 | 1 |
130113 | 130113 | 2020-05-09 | Hampshire | West Virginia | 54027 | 8 | 1 |
133103 | 133103 | 2020-05-10 | Hampshire | West Virginia | 54027 | 9 | 1 |
136093 | 136093 | 2020-05-11 | Hampshire | West Virginia | 54027 | 9 | 1 |
139084 | 139084 | 2020-05-12 | Hampshire | West Virginia | 54027 | 10 | 1 |
142080 | 142080 | 2020-05-13 | Hampshire | West Virginia | 54027 | 10 | 1 |
145077 | 145077 | 2020-05-14 | Hampshire | West Virginia | 54027 | 11 | 1 |
148080 | 148080 | 2020-05-15 | Hampshire | West Virginia | 54027 | 12 | 1 |
151089 | 151089 | 2020-05-16 | Hampshire | West Virginia | 54027 | 12 | 1 |
154100 | 154100 | 2020-05-17 | Hampshire | West Virginia | 54027 | 12 | 1 |
157117 | 157117 | 2020-05-18 | Hampshire | West Virginia | 54027 | 12 | 1 |
160141 | 160141 | 2020-05-19 | Hampshire | West Virginia | 54027 | 12 | 1 |
163169 | 163169 | 2020-05-20 | Hampshire | West Virginia | 54027 | 12 | 1 |
166198 | 166198 | 2020-05-21 | Hampshire | West Virginia | 54027 | 13 | 1 |
169234 | 169234 | 2020-05-22 | Hampshire | West Virginia | 54027 | 13 | 1 |
172275 | 172275 | 2020-05-23 | Hampshire | West Virginia | 54027 | 15 | 1 |
175318 | 175318 | 2020-05-24 | Hampshire | West Virginia | 54027 | 17 | 1 |
178363 | 178363 | 2020-05-25 | Hampshire | West Virginia | 54027 | 21 | 1 |
181407 | 181407 | 2020-05-26 | Hampshire | West Virginia | 54027 | 21 | 1 |
184458 | 184458 | 2020-05-27 | Hampshire | West Virginia | 54027 | 23 | 1 |
187515 | 187515 | 2020-05-28 | Hampshire | West Virginia | 54027 | 29 | 1 |
190579 | 190579 | 2020-05-29 | Hampshire | West Virginia | 54027 | 28 | 1 |
193645 | 193645 | 2020-05-30 | Hampshire | West Virginia | 54027 | 28 | 1 |
196715 | 196715 | 2020-05-31 | Hampshire | West Virginia | 54027 | 29 | 1 |
199788 | 199788 | 2020-06-01 | Hampshire | West Virginia | 54027 | 31 | 1 |
202864 | 202864 | 2020-06-02 | Hampshire | West Virginia | 54027 | 31 | 1 |
205943 | 205943 | 2020-06-03 | Hampshire | West Virginia | 54027 | 31 | 1 |
209025 | 209025 | 2020-06-04 | Hampshire | West Virginia | 54027 | 31 | 1 |
212110 | 212110 | 2020-06-05 | Hampshire | West Virginia | 54027 | 33 | 1 |
215197 | 215197 | 2020-06-06 | Hampshire | West Virginia | 54027 | 34 | 1 |
218287 | 218287 | 2020-06-07 | Hampshire | West Virginia | 54027 | 33 | 1 |
221379 | 221379 | 2020-06-08 | Hampshire | West Virginia | 54027 | 33 | 1 |
224475 | 224475 | 2020-06-09 | Hampshire | West Virginia | 54027 | 33 | 1 |
227575 | 227575 | 2020-06-10 | Hampshire | West Virginia | 54027 | 35 | 1 |
230679 | 230679 | 2020-06-11 | Hampshire | West Virginia | 54027 | 35 | 1 |
233784 | 233784 | 2020-06-12 | Hampshire | West Virginia | 54027 | 35 | 1 |
236891 | 236891 | 2020-06-13 | Hampshire | West Virginia | 54027 | 39 | 1 |
239999 | 239999 | 2020-06-14 | Hampshire | West Virginia | 54027 | 39 | 1 |
243110 | 243110 | 2020-06-15 | Hampshire | West Virginia | 54027 | 39 | 1 |
246223 | 246223 | 2020-06-16 | Hampshire | West Virginia | 54027 | 40 | 1 |
249335 | 249335 | 2020-06-17 | Hampshire | West Virginia | 54027 | 40 | 1 |
252450 | 252450 | 2020-06-18 | Hampshire | West Virginia | 54027 | 40 | 1 |
255569 | 255569 | 2020-06-19 | Hampshire | West Virginia | 54027 | 40 | 1 |
258696 | 258696 | 2020-06-20 | Hampshire | West Virginia | 54027 | 40 | 1 |
261823 | 261823 | 2020-06-21 | Hampshire | West Virginia | 54027 | 40 | 1 |
264952 | 264952 | 2020-06-22 | Hampshire | West Virginia | 54027 | 40 | 1 |
268081 | 268081 | 2020-06-23 | Hampshire | West Virginia | 54027 | 40 | 1 |
271215 | 271215 | 2020-06-24 | Hampshire | West Virginia | 54027 | 40 | 1 |
274355 | 274355 | 2020-06-25 | Hampshire | West Virginia | 54027 | 40 | 1 |
277503 | 277503 | 2020-06-26 | Hampshire | West Virginia | 54027 | 40 | 1 |
280651 | 280651 | 2020-06-27 | Hampshire | West Virginia | 54027 | 40 | 1 |
283797 | 283797 | 2020-06-28 | Hampshire | West Virginia | 54027 | 41 | 1 |
286943 | 286943 | 2020-06-29 | Hampshire | West Virginia | 54027 | 41 | 1 |
290093 | 290093 | 2020-06-30 | Hampshire | West Virginia | 54027 | 41 | 1 |
293246 | 293246 | 2020-07-01 | Hampshire | West Virginia | 54027 | 42 | 1 |
296401 | 296401 | 2020-07-02 | Hampshire | West Virginia | 54027 | 42 | 1 |
299563 | 299563 | 2020-07-03 | Hampshire | West Virginia | 54027 | 42 | 1 |
302727 | 302727 | 2020-07-04 | Hampshire | West Virginia | 54027 | 42 | 1 |
305891 | 305891 | 2020-07-05 | Hampshire | West Virginia | 54027 | 42 | 1 |
309059 | 309059 | 2020-07-06 | Hampshire | West Virginia | 54027 | 42 | 1 |
312228 | 312228 | 2020-07-07 | Hampshire | West Virginia | 54027 | 42 | 1 |
315403 | 315403 | 2020-07-08 | Hampshire | West Virginia | 54027 | 42 | 1 |
318576 | 318576 | 2020-07-09 | Hampshire | West Virginia | 54027 | 42 | 1 |
321755 | 321755 | 2020-07-10 | Hampshire | West Virginia | 54027 | 42 | 1 |
324936 | 324936 | 2020-07-11 | Hampshire | West Virginia | 54027 | 42 | 1 |
328122 | 328122 | 2020-07-12 | Hampshire | West Virginia | 54027 | 42 | 1 |
331308 | 331308 | 2020-07-13 | Hampshire | West Virginia | 54027 | 42 | 1 |
334501 | 334501 | 2020-07-14 | Hampshire | West Virginia | 54027 | 44 | 1 |
337696 | 337696 | 2020-07-15 | Hampshire | West Virginia | 54027 | 45 | 1 |
340892 | 340892 | 2020-07-16 | Hampshire | West Virginia | 54027 | 44 | 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);