ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
735 rows where county = "Unknown" and state = "New Hampshire" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- 2020-04-19 1
- 2020-04-20 1
- 2020-04-21 1
- 2020-04-22 1
- 2020-04-23 1
- 2020-04-24 1
- 2020-04-25 1
- 2020-04-26 1
- 2020-04-27 1
- 2020-04-28 1
- 2020-04-29 1
- 2020-04-30 1
- 2020-05-01 1
- 2020-05-02 1
- 2020-05-03 1
- 2020-05-04 1
- 2020-05-05 1
- 2020-05-06 1
- …
state 1
- New Hampshire · 735 ✖
fips 1
- - 735
county 1
- Unknown · 735 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
32103 | 32103 | 2020-04-04 | Unknown | New Hampshire | 4 | 0 | |
34534 | 34534 | 2020-04-05 | Unknown | New Hampshire | 6 | 0 | |
37004 | 37004 | 2020-04-06 | Unknown | New Hampshire | 1 | 0 | |
39519 | 39519 | 2020-04-07 | Unknown | New Hampshire | 1 | 0 | |
42076 | 42076 | 2020-04-08 | Unknown | New Hampshire | 1 | 0 | |
49924 | 49924 | 2020-04-11 | Unknown | New Hampshire | 1 | 0 | |
52597 | 52597 | 2020-04-12 | Unknown | New Hampshire | 1 | 0 | |
55280 | 55280 | 2020-04-13 | Unknown | New Hampshire | 1 | 0 | |
57980 | 57980 | 2020-04-14 | Unknown | New Hampshire | 1 | 0 | |
63420 | 63420 | 2020-04-16 | Unknown | New Hampshire | 1 | 0 | |
66162 | 66162 | 2020-04-17 | Unknown | New Hampshire | 2 | 0 | |
68918 | 68918 | 2020-04-18 | Unknown | New Hampshire | 0 | 1 | |
71685 | 71685 | 2020-04-19 | Unknown | New Hampshire | 2 | 1 | |
74460 | 74460 | 2020-04-20 | Unknown | New Hampshire | 4 | 1 | |
77241 | 77241 | 2020-04-21 | Unknown | New Hampshire | 15 | 1 | |
80030 | 80030 | 2020-04-22 | Unknown | New Hampshire | 17 | 1 | |
82828 | 82828 | 2020-04-23 | Unknown | New Hampshire | 11 | 1 | |
85632 | 85632 | 2020-04-24 | Unknown | New Hampshire | 3 | 1 | |
88443 | 88443 | 2020-04-25 | Unknown | New Hampshire | 6 | 1 | |
91258 | 91258 | 2020-04-26 | Unknown | New Hampshire | 5 | 1 | |
94082 | 94082 | 2020-04-27 | Unknown | New Hampshire | 11 | 1 | |
96918 | 96918 | 2020-04-28 | Unknown | New Hampshire | 7 | 1 | |
99765 | 99765 | 2020-04-29 | Unknown | New Hampshire | 4 | 1 | |
102618 | 102618 | 2020-04-30 | Unknown | New Hampshire | 3 | 0 | |
105480 | 105480 | 2020-05-01 | Unknown | New Hampshire | 15 | 0 | |
108346 | 108346 | 2020-05-02 | Unknown | New Hampshire | 26 | 0 | |
111219 | 111219 | 2020-05-03 | Unknown | New Hampshire | 19 | 0 | |
114100 | 114100 | 2020-05-04 | Unknown | New Hampshire | 15 | 0 | |
116981 | 116981 | 2020-05-05 | Unknown | New Hampshire | 15 | 0 | |
119942 | 119942 | 2020-05-06 | Unknown | New Hampshire | 20 | 0 | |
122917 | 122917 | 2020-05-07 | Unknown | New Hampshire | 21 | 0 | |
125900 | 125900 | 2020-05-08 | Unknown | New Hampshire | 28 | 0 | |
128889 | 128889 | 2020-05-09 | Unknown | New Hampshire | 32 | 0 | |
131878 | 131878 | 2020-05-10 | Unknown | New Hampshire | 28 | 0 | |
134869 | 134869 | 2020-05-11 | Unknown | New Hampshire | 31 | 0 | |
137859 | 137859 | 2020-05-12 | Unknown | New Hampshire | 26 | 0 | |
140855 | 140855 | 2020-05-13 | Unknown | New Hampshire | 26 | 0 | |
143850 | 143850 | 2020-05-14 | Unknown | New Hampshire | 34 | 0 | |
146851 | 146851 | 2020-05-15 | Unknown | New Hampshire | 56 | 0 | |
149858 | 149858 | 2020-05-16 | Unknown | New Hampshire | 10 | 0 | |
152868 | 152868 | 2020-05-17 | Unknown | New Hampshire | 10 | 0 | |
155884 | 155884 | 2020-05-18 | Unknown | New Hampshire | 32 | 0 | |
158902 | 158902 | 2020-05-19 | Unknown | New Hampshire | 11 | 0 | |
161928 | 161928 | 2020-05-20 | Unknown | New Hampshire | 14 | 0 | |
164957 | 164957 | 2020-05-21 | Unknown | New Hampshire | 15 | 0 | |
167993 | 167993 | 2020-05-22 | Unknown | New Hampshire | 17 | 0 | |
171032 | 171032 | 2020-05-23 | Unknown | New Hampshire | 15 | 0 | |
174074 | 174074 | 2020-05-24 | Unknown | New Hampshire | 14 | 0 | |
177117 | 177117 | 2020-05-25 | Unknown | New Hampshire | 12 | 0 | |
180161 | 180161 | 2020-05-26 | Unknown | New Hampshire | 12 | 0 | |
183209 | 183209 | 2020-05-27 | Unknown | New Hampshire | 10 | 0 | |
186266 | 186266 | 2020-05-28 | Unknown | New Hampshire | 10 | 0 | |
189326 | 189326 | 2020-05-29 | Unknown | New Hampshire | 6 | 0 | |
192390 | 192390 | 2020-05-30 | Unknown | New Hampshire | 4 | 0 | |
195460 | 195460 | 2020-05-31 | Unknown | New Hampshire | 6 | 0 | |
198533 | 198533 | 2020-06-01 | Unknown | New Hampshire | 6 | 0 | |
201607 | 201607 | 2020-06-02 | Unknown | New Hampshire | 10 | 0 | |
204684 | 204684 | 2020-06-03 | Unknown | New Hampshire | 10 | 0 | |
207765 | 207765 | 2020-06-04 | Unknown | New Hampshire | 8 | 0 | |
210847 | 210847 | 2020-06-05 | Unknown | New Hampshire | 7 | 0 | |
213931 | 213931 | 2020-06-06 | Unknown | New Hampshire | 10 | 0 | |
217020 | 217020 | 2020-06-07 | Unknown | New Hampshire | 9 | 0 | |
220112 | 220112 | 2020-06-08 | Unknown | New Hampshire | 9 | 0 | |
223207 | 223207 | 2020-06-09 | Unknown | New Hampshire | 8 | 0 | |
226307 | 226307 | 2020-06-10 | Unknown | New Hampshire | 8 | 0 | |
229411 | 229411 | 2020-06-11 | Unknown | New Hampshire | 4 | 0 | |
232516 | 232516 | 2020-06-12 | Unknown | New Hampshire | 5 | 0 | |
235621 | 235621 | 2020-06-13 | Unknown | New Hampshire | 5 | 0 | |
238728 | 238728 | 2020-06-14 | Unknown | New Hampshire | 5 | 0 | |
241838 | 241838 | 2020-06-15 | Unknown | New Hampshire | 5 | 0 | |
244950 | 244950 | 2020-06-16 | Unknown | New Hampshire | 4 | 0 | |
248063 | 248063 | 2020-06-17 | Unknown | New Hampshire | 3 | 0 | |
251178 | 251178 | 2020-06-18 | Unknown | New Hampshire | 1 | 0 | |
254293 | 254293 | 2020-06-19 | Unknown | New Hampshire | 1 | 0 | |
257416 | 257416 | 2020-06-20 | Unknown | New Hampshire | 1 | 0 | |
260542 | 260542 | 2020-06-21 | Unknown | New Hampshire | 2 | 0 | |
263671 | 263671 | 2020-06-22 | Unknown | New Hampshire | 3 | 0 | |
266798 | 266798 | 2020-06-23 | Unknown | New Hampshire | 1 | 0 | |
269933 | 269933 | 2020-06-24 | Unknown | New Hampshire | 2 | 0 | |
273072 | 273072 | 2020-06-25 | Unknown | New Hampshire | 2 | 0 | |
276217 | 276217 | 2020-06-26 | Unknown | New Hampshire | 2 | 0 | |
279365 | 279365 | 2020-06-27 | Unknown | New Hampshire | 2 | 0 | |
282512 | 282512 | 2020-06-28 | Unknown | New Hampshire | 2 | 0 | |
285657 | 285657 | 2020-06-29 | Unknown | New Hampshire | 1 | 0 | |
288807 | 288807 | 2020-06-30 | Unknown | New Hampshire | 1 | 0 | |
291959 | 291959 | 2020-07-01 | Unknown | New Hampshire | 1 | 0 | |
295114 | 295114 | 2020-07-02 | Unknown | New Hampshire | 1 | 0 | |
298274 | 298274 | 2020-07-03 | Unknown | New Hampshire | 2 | 0 | |
301437 | 301437 | 2020-07-04 | Unknown | New Hampshire | 1 | 0 | |
304600 | 304600 | 2020-07-05 | Unknown | New Hampshire | 4 | 0 | |
307767 | 307767 | 2020-07-06 | Unknown | New Hampshire | 3 | 0 | |
310935 | 310935 | 2020-07-07 | Unknown | New Hampshire | 1 | 0 | |
314106 | 314106 | 2020-07-08 | Unknown | New Hampshire | 1 | 0 | |
317280 | 317280 | 2020-07-09 | Unknown | New Hampshire | 1 | 0 | |
320456 | 320456 | 2020-07-10 | Unknown | New Hampshire | 2 | 0 | |
323636 | 323636 | 2020-07-11 | Unknown | New Hampshire | 2 | 0 | |
326820 | 326820 | 2020-07-12 | Unknown | New Hampshire | 6 | 0 | |
330007 | 330007 | 2020-07-13 | Unknown | New Hampshire | 5 | 0 | |
384491 | 384491 | 2020-07-30 | Unknown | New Hampshire | 3 | 0 | |
387708 | 387708 | 2020-07-31 | Unknown | New Hampshire | 1 | 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);