ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Sullivan" and state = "New Hampshire" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
7763 | 7763 | 2020-03-22 | Sullivan | New Hampshire | 33019 | 1 | 0 |
8959 | 8959 | 2020-03-23 | Sullivan | New Hampshire | 33019 | 1 | 0 |
10263 | 10263 | 2020-03-24 | Sullivan | New Hampshire | 33019 | 1 | 0 |
11695 | 11695 | 2020-03-25 | Sullivan | New Hampshire | 33019 | 1 | 0 |
13298 | 13298 | 2020-03-26 | Sullivan | New Hampshire | 33019 | 2 | 0 |
15030 | 15030 | 2020-03-27 | Sullivan | New Hampshire | 33019 | 2 | 0 |
16859 | 16859 | 2020-03-28 | Sullivan | New Hampshire | 33019 | 2 | 0 |
18783 | 18783 | 2020-03-29 | Sullivan | New Hampshire | 33019 | 3 | 0 |
20821 | 20821 | 2020-03-30 | Sullivan | New Hampshire | 33019 | 3 | 0 |
22944 | 22944 | 2020-03-31 | Sullivan | New Hampshire | 33019 | 4 | 0 |
25135 | 25135 | 2020-04-01 | Sullivan | New Hampshire | 33019 | 4 | 1 |
27395 | 27395 | 2020-04-02 | Sullivan | New Hampshire | 33019 | 5 | 1 |
29718 | 29718 | 2020-04-03 | Sullivan | New Hampshire | 33019 | 5 | 1 |
32102 | 32102 | 2020-04-04 | Sullivan | New Hampshire | 33019 | 5 | 1 |
34533 | 34533 | 2020-04-05 | Sullivan | New Hampshire | 33019 | 6 | 1 |
37003 | 37003 | 2020-04-06 | Sullivan | New Hampshire | 33019 | 6 | 1 |
39518 | 39518 | 2020-04-07 | Sullivan | New Hampshire | 33019 | 6 | 1 |
42075 | 42075 | 2020-04-08 | Sullivan | New Hampshire | 33019 | 6 | 1 |
44658 | 44658 | 2020-04-09 | Sullivan | New Hampshire | 33019 | 6 | 1 |
47270 | 47270 | 2020-04-10 | Sullivan | New Hampshire | 33019 | 6 | 1 |
49923 | 49923 | 2020-04-11 | Sullivan | New Hampshire | 33019 | 6 | 1 |
52596 | 52596 | 2020-04-12 | Sullivan | New Hampshire | 33019 | 6 | 1 |
55279 | 55279 | 2020-04-13 | Sullivan | New Hampshire | 33019 | 6 | 1 |
57979 | 57979 | 2020-04-14 | Sullivan | New Hampshire | 33019 | 7 | 1 |
60694 | 60694 | 2020-04-15 | Sullivan | New Hampshire | 33019 | 7 | 1 |
63419 | 63419 | 2020-04-16 | Sullivan | New Hampshire | 33019 | 8 | 1 |
66161 | 66161 | 2020-04-17 | Sullivan | New Hampshire | 33019 | 9 | 1 |
68917 | 68917 | 2020-04-18 | Sullivan | New Hampshire | 33019 | 10 | 1 |
71684 | 71684 | 2020-04-19 | Sullivan | New Hampshire | 33019 | 10 | 1 |
74459 | 74459 | 2020-04-20 | Sullivan | New Hampshire | 33019 | 10 | 1 |
77240 | 77240 | 2020-04-21 | Sullivan | New Hampshire | 33019 | 10 | 1 |
80029 | 80029 | 2020-04-22 | Sullivan | New Hampshire | 33019 | 10 | 1 |
82827 | 82827 | 2020-04-23 | Sullivan | New Hampshire | 33019 | 10 | 1 |
85631 | 85631 | 2020-04-24 | Sullivan | New Hampshire | 33019 | 11 | 1 |
88442 | 88442 | 2020-04-25 | Sullivan | New Hampshire | 33019 | 10 | 1 |
91257 | 91257 | 2020-04-26 | Sullivan | New Hampshire | 33019 | 11 | 1 |
94081 | 94081 | 2020-04-27 | Sullivan | New Hampshire | 33019 | 11 | 1 |
96917 | 96917 | 2020-04-28 | Sullivan | New Hampshire | 33019 | 11 | 1 |
99764 | 99764 | 2020-04-29 | Sullivan | New Hampshire | 33019 | 11 | 1 |
102617 | 102617 | 2020-04-30 | Sullivan | New Hampshire | 33019 | 12 | 1 |
105479 | 105479 | 2020-05-01 | Sullivan | New Hampshire | 33019 | 12 | 1 |
108345 | 108345 | 2020-05-02 | Sullivan | New Hampshire | 33019 | 12 | 1 |
111218 | 111218 | 2020-05-03 | Sullivan | New Hampshire | 33019 | 12 | 1 |
114099 | 114099 | 2020-05-04 | Sullivan | New Hampshire | 33019 | 12 | 1 |
116980 | 116980 | 2020-05-05 | Sullivan | New Hampshire | 33019 | 12 | 1 |
119941 | 119941 | 2020-05-06 | Sullivan | New Hampshire | 33019 | 13 | 1 |
122916 | 122916 | 2020-05-07 | Sullivan | New Hampshire | 33019 | 14 | 1 |
125899 | 125899 | 2020-05-08 | Sullivan | New Hampshire | 33019 | 14 | 1 |
128888 | 128888 | 2020-05-09 | Sullivan | New Hampshire | 33019 | 14 | 1 |
131877 | 131877 | 2020-05-10 | Sullivan | New Hampshire | 33019 | 14 | 1 |
134868 | 134868 | 2020-05-11 | Sullivan | New Hampshire | 33019 | 14 | 1 |
137858 | 137858 | 2020-05-12 | Sullivan | New Hampshire | 33019 | 14 | 1 |
140854 | 140854 | 2020-05-13 | Sullivan | New Hampshire | 33019 | 14 | 1 |
143849 | 143849 | 2020-05-14 | Sullivan | New Hampshire | 33019 | 14 | 1 |
146850 | 146850 | 2020-05-15 | Sullivan | New Hampshire | 33019 | 16 | 1 |
149857 | 149857 | 2020-05-16 | Sullivan | New Hampshire | 33019 | 16 | 1 |
152867 | 152867 | 2020-05-17 | Sullivan | New Hampshire | 33019 | 16 | 1 |
155883 | 155883 | 2020-05-18 | Sullivan | New Hampshire | 33019 | 16 | 1 |
158901 | 158901 | 2020-05-19 | Sullivan | New Hampshire | 33019 | 16 | 1 |
161927 | 161927 | 2020-05-20 | Sullivan | New Hampshire | 33019 | 16 | 1 |
164956 | 164956 | 2020-05-21 | Sullivan | New Hampshire | 33019 | 16 | 1 |
167992 | 167992 | 2020-05-22 | Sullivan | New Hampshire | 33019 | 16 | 1 |
171031 | 171031 | 2020-05-23 | Sullivan | New Hampshire | 33019 | 17 | 1 |
174073 | 174073 | 2020-05-24 | Sullivan | New Hampshire | 33019 | 17 | 1 |
177116 | 177116 | 2020-05-25 | Sullivan | New Hampshire | 33019 | 17 | 1 |
180160 | 180160 | 2020-05-26 | Sullivan | New Hampshire | 33019 | 17 | 1 |
183208 | 183208 | 2020-05-27 | Sullivan | New Hampshire | 33019 | 17 | 1 |
186265 | 186265 | 2020-05-28 | Sullivan | New Hampshire | 33019 | 17 | 1 |
189325 | 189325 | 2020-05-29 | Sullivan | New Hampshire | 33019 | 19 | 1 |
192389 | 192389 | 2020-05-30 | Sullivan | New Hampshire | 33019 | 19 | 1 |
195459 | 195459 | 2020-05-31 | Sullivan | New Hampshire | 33019 | 19 | 1 |
198532 | 198532 | 2020-06-01 | Sullivan | New Hampshire | 33019 | 19 | 1 |
201606 | 201606 | 2020-06-02 | Sullivan | New Hampshire | 33019 | 19 | 1 |
204683 | 204683 | 2020-06-03 | Sullivan | New Hampshire | 33019 | 20 | 1 |
207764 | 207764 | 2020-06-04 | Sullivan | New Hampshire | 33019 | 20 | 1 |
210846 | 210846 | 2020-06-05 | Sullivan | New Hampshire | 33019 | 20 | 1 |
213930 | 213930 | 2020-06-06 | Sullivan | New Hampshire | 33019 | 20 | 1 |
217019 | 217019 | 2020-06-07 | Sullivan | New Hampshire | 33019 | 20 | 1 |
220111 | 220111 | 2020-06-08 | Sullivan | New Hampshire | 33019 | 20 | 1 |
223206 | 223206 | 2020-06-09 | Sullivan | New Hampshire | 33019 | 21 | 1 |
226306 | 226306 | 2020-06-10 | Sullivan | New Hampshire | 33019 | 24 | 1 |
229410 | 229410 | 2020-06-11 | Sullivan | New Hampshire | 33019 | 25 | 1 |
232515 | 232515 | 2020-06-12 | Sullivan | New Hampshire | 33019 | 25 | 1 |
235620 | 235620 | 2020-06-13 | Sullivan | New Hampshire | 33019 | 25 | 1 |
238727 | 238727 | 2020-06-14 | Sullivan | New Hampshire | 33019 | 25 | 1 |
241837 | 241837 | 2020-06-15 | Sullivan | New Hampshire | 33019 | 25 | 1 |
244949 | 244949 | 2020-06-16 | Sullivan | New Hampshire | 33019 | 24 | 1 |
248062 | 248062 | 2020-06-17 | Sullivan | New Hampshire | 33019 | 24 | 1 |
251177 | 251177 | 2020-06-18 | Sullivan | New Hampshire | 33019 | 24 | 1 |
254292 | 254292 | 2020-06-19 | Sullivan | New Hampshire | 33019 | 24 | 1 |
257415 | 257415 | 2020-06-20 | Sullivan | New Hampshire | 33019 | 24 | 1 |
260541 | 260541 | 2020-06-21 | Sullivan | New Hampshire | 33019 | 24 | 1 |
263670 | 263670 | 2020-06-22 | Sullivan | New Hampshire | 33019 | 24 | 1 |
266797 | 266797 | 2020-06-23 | Sullivan | New Hampshire | 33019 | 24 | 1 |
269932 | 269932 | 2020-06-24 | Sullivan | New Hampshire | 33019 | 25 | 1 |
273071 | 273071 | 2020-06-25 | Sullivan | New Hampshire | 33019 | 27 | 1 |
276216 | 276216 | 2020-06-26 | Sullivan | New Hampshire | 33019 | 30 | 1 |
279364 | 279364 | 2020-06-27 | Sullivan | New Hampshire | 33019 | 31 | 1 |
282511 | 282511 | 2020-06-28 | Sullivan | New Hampshire | 33019 | 31 | 1 |
285656 | 285656 | 2020-06-29 | Sullivan | New Hampshire | 33019 | 31 | 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);