ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
117 rows where deaths = 2, fips = 33005 and state = "New Hampshire" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
397350 | 397350 | 2020-08-03 | Cheshire | New Hampshire | 33005 | 92 | 2 |
394134 | 394134 | 2020-08-02 | Cheshire | New Hampshire | 33005 | 90 | 2 |
390917 | 390917 | 2020-08-01 | Cheshire | New Hampshire | 33005 | 90 | 2 |
387700 | 387700 | 2020-07-31 | Cheshire | New Hampshire | 33005 | 85 | 2 |
384483 | 384483 | 2020-07-30 | Cheshire | New Hampshire | 33005 | 85 | 2 |
381266 | 381266 | 2020-07-29 | Cheshire | New Hampshire | 33005 | 85 | 2 |
378048 | 378048 | 2020-07-28 | Cheshire | New Hampshire | 33005 | 85 | 2 |
374833 | 374833 | 2020-07-27 | Cheshire | New Hampshire | 33005 | 82 | 2 |
371621 | 371621 | 2020-07-26 | Cheshire | New Hampshire | 33005 | 81 | 2 |
368409 | 368409 | 2020-07-25 | Cheshire | New Hampshire | 33005 | 80 | 2 |
365200 | 365200 | 2020-07-24 | Cheshire | New Hampshire | 33005 | 80 | 2 |
361994 | 361994 | 2020-07-23 | Cheshire | New Hampshire | 33005 | 80 | 2 |
358788 | 358788 | 2020-07-22 | Cheshire | New Hampshire | 33005 | 80 | 2 |
355584 | 355584 | 2020-07-21 | Cheshire | New Hampshire | 33005 | 80 | 2 |
352381 | 352381 | 2020-07-20 | Cheshire | New Hampshire | 33005 | 80 | 2 |
349178 | 349178 | 2020-07-19 | Cheshire | New Hampshire | 33005 | 80 | 2 |
345977 | 345977 | 2020-07-18 | Cheshire | New Hampshire | 33005 | 80 | 2 |
342778 | 342778 | 2020-07-17 | Cheshire | New Hampshire | 33005 | 79 | 2 |
339580 | 339580 | 2020-07-16 | Cheshire | New Hampshire | 33005 | 79 | 2 |
336384 | 336384 | 2020-07-15 | Cheshire | New Hampshire | 33005 | 78 | 2 |
333190 | 333190 | 2020-07-14 | Cheshire | New Hampshire | 33005 | 77 | 2 |
329999 | 329999 | 2020-07-13 | Cheshire | New Hampshire | 33005 | 76 | 2 |
326812 | 326812 | 2020-07-12 | Cheshire | New Hampshire | 33005 | 76 | 2 |
323628 | 323628 | 2020-07-11 | Cheshire | New Hampshire | 33005 | 75 | 2 |
320448 | 320448 | 2020-07-10 | Cheshire | New Hampshire | 33005 | 75 | 2 |
317272 | 317272 | 2020-07-09 | Cheshire | New Hampshire | 33005 | 75 | 2 |
314098 | 314098 | 2020-07-08 | Cheshire | New Hampshire | 33005 | 74 | 2 |
310927 | 310927 | 2020-07-07 | Cheshire | New Hampshire | 33005 | 74 | 2 |
307759 | 307759 | 2020-07-06 | Cheshire | New Hampshire | 33005 | 73 | 2 |
304592 | 304592 | 2020-07-05 | Cheshire | New Hampshire | 33005 | 73 | 2 |
301429 | 301429 | 2020-07-04 | Cheshire | New Hampshire | 33005 | 72 | 2 |
298266 | 298266 | 2020-07-03 | Cheshire | New Hampshire | 33005 | 72 | 2 |
295106 | 295106 | 2020-07-02 | Cheshire | New Hampshire | 33005 | 72 | 2 |
291951 | 291951 | 2020-07-01 | Cheshire | New Hampshire | 33005 | 72 | 2 |
288799 | 288799 | 2020-06-30 | Cheshire | New Hampshire | 33005 | 71 | 2 |
285649 | 285649 | 2020-06-29 | Cheshire | New Hampshire | 33005 | 69 | 2 |
282504 | 282504 | 2020-06-28 | Cheshire | New Hampshire | 33005 | 67 | 2 |
279357 | 279357 | 2020-06-27 | Cheshire | New Hampshire | 33005 | 67 | 2 |
276209 | 276209 | 2020-06-26 | Cheshire | New Hampshire | 33005 | 67 | 2 |
273064 | 273064 | 2020-06-25 | Cheshire | New Hampshire | 33005 | 66 | 2 |
269925 | 269925 | 2020-06-24 | Cheshire | New Hampshire | 33005 | 66 | 2 |
266790 | 266790 | 2020-06-23 | Cheshire | New Hampshire | 33005 | 64 | 2 |
263663 | 263663 | 2020-06-22 | Cheshire | New Hampshire | 33005 | 64 | 2 |
260534 | 260534 | 2020-06-21 | Cheshire | New Hampshire | 33005 | 64 | 2 |
257408 | 257408 | 2020-06-20 | Cheshire | New Hampshire | 33005 | 64 | 2 |
254285 | 254285 | 2020-06-19 | Cheshire | New Hampshire | 33005 | 63 | 2 |
251170 | 251170 | 2020-06-18 | Cheshire | New Hampshire | 33005 | 62 | 2 |
248055 | 248055 | 2020-06-17 | Cheshire | New Hampshire | 33005 | 63 | 2 |
244942 | 244942 | 2020-06-16 | Cheshire | New Hampshire | 33005 | 62 | 2 |
241830 | 241830 | 2020-06-15 | Cheshire | New Hampshire | 33005 | 60 | 2 |
238720 | 238720 | 2020-06-14 | Cheshire | New Hampshire | 33005 | 60 | 2 |
235613 | 235613 | 2020-06-13 | Cheshire | New Hampshire | 33005 | 60 | 2 |
232508 | 232508 | 2020-06-12 | Cheshire | New Hampshire | 33005 | 60 | 2 |
229403 | 229403 | 2020-06-11 | Cheshire | New Hampshire | 33005 | 60 | 2 |
226299 | 226299 | 2020-06-10 | Cheshire | New Hampshire | 33005 | 59 | 2 |
223199 | 223199 | 2020-06-09 | Cheshire | New Hampshire | 33005 | 59 | 2 |
220104 | 220104 | 2020-06-08 | Cheshire | New Hampshire | 33005 | 59 | 2 |
217012 | 217012 | 2020-06-07 | Cheshire | New Hampshire | 33005 | 57 | 2 |
213923 | 213923 | 2020-06-06 | Cheshire | New Hampshire | 33005 | 57 | 2 |
210839 | 210839 | 2020-06-05 | Cheshire | New Hampshire | 33005 | 57 | 2 |
207757 | 207757 | 2020-06-04 | Cheshire | New Hampshire | 33005 | 57 | 2 |
204676 | 204676 | 2020-06-03 | Cheshire | New Hampshire | 33005 | 57 | 2 |
201599 | 201599 | 2020-06-02 | Cheshire | New Hampshire | 33005 | 57 | 2 |
198525 | 198525 | 2020-06-01 | Cheshire | New Hampshire | 33005 | 57 | 2 |
195452 | 195452 | 2020-05-31 | Cheshire | New Hampshire | 33005 | 57 | 2 |
192382 | 192382 | 2020-05-30 | Cheshire | New Hampshire | 33005 | 57 | 2 |
189318 | 189318 | 2020-05-29 | Cheshire | New Hampshire | 33005 | 57 | 2 |
186258 | 186258 | 2020-05-28 | Cheshire | New Hampshire | 33005 | 55 | 2 |
183201 | 183201 | 2020-05-27 | Cheshire | New Hampshire | 33005 | 54 | 2 |
180153 | 180153 | 2020-05-26 | Cheshire | New Hampshire | 33005 | 54 | 2 |
177109 | 177109 | 2020-05-25 | Cheshire | New Hampshire | 33005 | 54 | 2 |
174066 | 174066 | 2020-05-24 | Cheshire | New Hampshire | 33005 | 52 | 2 |
171024 | 171024 | 2020-05-23 | Cheshire | New Hampshire | 33005 | 51 | 2 |
167985 | 167985 | 2020-05-22 | Cheshire | New Hampshire | 33005 | 51 | 2 |
164949 | 164949 | 2020-05-21 | Cheshire | New Hampshire | 33005 | 50 | 2 |
161920 | 161920 | 2020-05-20 | Cheshire | New Hampshire | 33005 | 49 | 2 |
158894 | 158894 | 2020-05-19 | Cheshire | New Hampshire | 33005 | 49 | 2 |
155876 | 155876 | 2020-05-18 | Cheshire | New Hampshire | 33005 | 48 | 2 |
152860 | 152860 | 2020-05-17 | Cheshire | New Hampshire | 33005 | 47 | 2 |
149850 | 149850 | 2020-05-16 | Cheshire | New Hampshire | 33005 | 47 | 2 |
146843 | 146843 | 2020-05-15 | Cheshire | New Hampshire | 33005 | 47 | 2 |
143842 | 143842 | 2020-05-14 | Cheshire | New Hampshire | 33005 | 45 | 2 |
140847 | 140847 | 2020-05-13 | Cheshire | New Hampshire | 33005 | 45 | 2 |
137851 | 137851 | 2020-05-12 | Cheshire | New Hampshire | 33005 | 44 | 2 |
134861 | 134861 | 2020-05-11 | Cheshire | New Hampshire | 33005 | 43 | 2 |
131870 | 131870 | 2020-05-10 | Cheshire | New Hampshire | 33005 | 43 | 2 |
128881 | 128881 | 2020-05-09 | Cheshire | New Hampshire | 33005 | 43 | 2 |
125892 | 125892 | 2020-05-08 | Cheshire | New Hampshire | 33005 | 43 | 2 |
122909 | 122909 | 2020-05-07 | Cheshire | New Hampshire | 33005 | 41 | 2 |
119934 | 119934 | 2020-05-06 | Cheshire | New Hampshire | 33005 | 41 | 2 |
116973 | 116973 | 2020-05-05 | Cheshire | New Hampshire | 33005 | 41 | 2 |
114092 | 114092 | 2020-05-04 | Cheshire | New Hampshire | 33005 | 40 | 2 |
111211 | 111211 | 2020-05-03 | Cheshire | New Hampshire | 33005 | 40 | 2 |
108338 | 108338 | 2020-05-02 | Cheshire | New Hampshire | 33005 | 40 | 2 |
105472 | 105472 | 2020-05-01 | Cheshire | New Hampshire | 33005 | 40 | 2 |
102610 | 102610 | 2020-04-30 | Cheshire | New Hampshire | 33005 | 40 | 2 |
99757 | 99757 | 2020-04-29 | Cheshire | New Hampshire | 33005 | 40 | 2 |
96910 | 96910 | 2020-04-28 | Cheshire | New Hampshire | 33005 | 40 | 2 |
94074 | 94074 | 2020-04-27 | Cheshire | New Hampshire | 33005 | 38 | 2 |
91250 | 91250 | 2020-04-26 | Cheshire | New Hampshire | 33005 | 36 | 2 |
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);