ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 33015 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
712 | 712 | 2020-03-07 | Rockingham | New Hampshire | 33015 | 1 | 0 |
816 | 816 | 2020-03-08 | Rockingham | New Hampshire | 33015 | 1 | 0 |
940 | 940 | 2020-03-09 | Rockingham | New Hampshire | 33015 | 1 | 0 |
1090 | 1090 | 2020-03-10 | Rockingham | New Hampshire | 33015 | 2 | 0 |
1272 | 1272 | 2020-03-11 | Rockingham | New Hampshire | 33015 | 2 | 0 |
1501 | 1501 | 2020-03-12 | Rockingham | New Hampshire | 33015 | 3 | 0 |
1793 | 1793 | 2020-03-13 | Rockingham | New Hampshire | 33015 | 4 | 0 |
2139 | 2139 | 2020-03-14 | Rockingham | New Hampshire | 33015 | 4 | 0 |
2547 | 2547 | 2020-03-15 | Rockingham | New Hampshire | 33015 | 9 | 0 |
3003 | 3003 | 2020-03-16 | Rockingham | New Hampshire | 33015 | 10 | 0 |
3515 | 3515 | 2020-03-17 | Rockingham | New Hampshire | 33015 | 14 | 0 |
4110 | 4110 | 2020-03-18 | Rockingham | New Hampshire | 33015 | 17 | 0 |
4836 | 4836 | 2020-03-19 | Rockingham | New Hampshire | 33015 | 18 | 0 |
5679 | 5679 | 2020-03-20 | Rockingham | New Hampshire | 33015 | 20 | 0 |
6671 | 6671 | 2020-03-21 | Rockingham | New Hampshire | 33015 | 25 | 0 |
7761 | 7761 | 2020-03-22 | Rockingham | New Hampshire | 33015 | 28 | 0 |
8957 | 8957 | 2020-03-23 | Rockingham | New Hampshire | 33015 | 38 | 0 |
10261 | 10261 | 2020-03-24 | Rockingham | New Hampshire | 33015 | 42 | 0 |
11693 | 11693 | 2020-03-25 | Rockingham | New Hampshire | 33015 | 56 | 0 |
13296 | 13296 | 2020-03-26 | Rockingham | New Hampshire | 33015 | 67 | 0 |
15028 | 15028 | 2020-03-27 | Rockingham | New Hampshire | 33015 | 75 | 0 |
16857 | 16857 | 2020-03-28 | Rockingham | New Hampshire | 33015 | 86 | 0 |
18781 | 18781 | 2020-03-29 | Rockingham | New Hampshire | 33015 | 100 | 1 |
20819 | 20819 | 2020-03-30 | Rockingham | New Hampshire | 33015 | 116 | 1 |
22942 | 22942 | 2020-03-31 | Rockingham | New Hampshire | 33015 | 137 | 1 |
25133 | 25133 | 2020-04-01 | Rockingham | New Hampshire | 33015 | 154 | 1 |
27393 | 27393 | 2020-04-02 | Rockingham | New Hampshire | 33015 | 170 | 1 |
29716 | 29716 | 2020-04-03 | Rockingham | New Hampshire | 33015 | 190 | 1 |
32100 | 32100 | 2020-04-04 | Rockingham | New Hampshire | 33015 | 213 | 1 |
34531 | 34531 | 2020-04-05 | Rockingham | New Hampshire | 33015 | 230 | 1 |
37001 | 37001 | 2020-04-06 | Rockingham | New Hampshire | 33015 | 246 | 1 |
39516 | 39516 | 2020-04-07 | Rockingham | New Hampshire | 33015 | 255 | 2 |
42073 | 42073 | 2020-04-08 | Rockingham | New Hampshire | 33015 | 268 | 2 |
44656 | 44656 | 2020-04-09 | Rockingham | New Hampshire | 33015 | 277 | 2 |
47268 | 47268 | 2020-04-10 | Rockingham | New Hampshire | 33015 | 305 | 2 |
49921 | 49921 | 2020-04-11 | Rockingham | New Hampshire | 33015 | 314 | 3 |
52594 | 52594 | 2020-04-12 | Rockingham | New Hampshire | 33015 | 345 | 3 |
55277 | 55277 | 2020-04-13 | Rockingham | New Hampshire | 33015 | 360 | 3 |
57977 | 57977 | 2020-04-14 | Rockingham | New Hampshire | 33015 | 378 | 3 |
60692 | 60692 | 2020-04-15 | Rockingham | New Hampshire | 33015 | 399 | 5 |
63417 | 63417 | 2020-04-16 | Rockingham | New Hampshire | 33015 | 433 | 6 |
66159 | 66159 | 2020-04-17 | Rockingham | New Hampshire | 33015 | 449 | 8 |
68915 | 68915 | 2020-04-18 | Rockingham | New Hampshire | 33015 | 466 | 8 |
71682 | 71682 | 2020-04-19 | Rockingham | New Hampshire | 33015 | 479 | 10 |
74457 | 74457 | 2020-04-20 | Rockingham | New Hampshire | 33015 | 489 | 11 |
77238 | 77238 | 2020-04-21 | Rockingham | New Hampshire | 33015 | 493 | 11 |
80027 | 80027 | 2020-04-22 | Rockingham | New Hampshire | 33015 | 519 | 13 |
82825 | 82825 | 2020-04-23 | Rockingham | New Hampshire | 33015 | 551 | 14 |
85629 | 85629 | 2020-04-24 | Rockingham | New Hampshire | 33015 | 568 | 15 |
88440 | 88440 | 2020-04-25 | Rockingham | New Hampshire | 33015 | 593 | 15 |
91255 | 91255 | 2020-04-26 | Rockingham | New Hampshire | 33015 | 619 | 15 |
94079 | 94079 | 2020-04-27 | Rockingham | New Hampshire | 33015 | 643 | 15 |
96915 | 96915 | 2020-04-28 | Rockingham | New Hampshire | 33015 | 664 | 15 |
99762 | 99762 | 2020-04-29 | Rockingham | New Hampshire | 33015 | 670 | 19 |
102615 | 102615 | 2020-04-30 | Rockingham | New Hampshire | 33015 | 692 | 22 |
105477 | 105477 | 2020-05-01 | Rockingham | New Hampshire | 33015 | 779 | 25 |
108343 | 108343 | 2020-05-02 | Rockingham | New Hampshire | 33015 | 828 | 27 |
111216 | 111216 | 2020-05-03 | Rockingham | New Hampshire | 33015 | 862 | 28 |
114097 | 114097 | 2020-05-04 | Rockingham | New Hampshire | 33015 | 878 | 28 |
116978 | 116978 | 2020-05-05 | Rockingham | New Hampshire | 33015 | 888 | 31 |
119939 | 119939 | 2020-05-06 | Rockingham | New Hampshire | 33015 | 903 | 43 |
122914 | 122914 | 2020-05-07 | Rockingham | New Hampshire | 33015 | 933 | 44 |
125897 | 125897 | 2020-05-08 | Rockingham | New Hampshire | 33015 | 949 | 47 |
128886 | 128886 | 2020-05-09 | Rockingham | New Hampshire | 33015 | 964 | 53 |
131875 | 131875 | 2020-05-10 | Rockingham | New Hampshire | 33015 | 978 | 53 |
134866 | 134866 | 2020-05-11 | Rockingham | New Hampshire | 33015 | 994 | 53 |
137856 | 137856 | 2020-05-12 | Rockingham | New Hampshire | 33015 | 1010 | 55 |
140852 | 140852 | 2020-05-13 | Rockingham | New Hampshire | 33015 | 1021 | 57 |
143847 | 143847 | 2020-05-14 | Rockingham | New Hampshire | 33015 | 1040 | 57 |
146848 | 146848 | 2020-05-15 | Rockingham | New Hampshire | 33015 | 1069 | 59 |
149855 | 149855 | 2020-05-16 | Rockingham | New Hampshire | 33015 | 1095 | 60 |
152865 | 152865 | 2020-05-17 | Rockingham | New Hampshire | 33015 | 1104 | 60 |
155881 | 155881 | 2020-05-18 | Rockingham | New Hampshire | 33015 | 1113 | 60 |
158899 | 158899 | 2020-05-19 | Rockingham | New Hampshire | 33015 | 1138 | 63 |
161925 | 161925 | 2020-05-20 | Rockingham | New Hampshire | 33015 | 1159 | 65 |
164954 | 164954 | 2020-05-21 | Rockingham | New Hampshire | 33015 | 1179 | 66 |
167990 | 167990 | 2020-05-22 | Rockingham | New Hampshire | 33015 | 1199 | 67 |
171029 | 171029 | 2020-05-23 | Rockingham | New Hampshire | 33015 | 1218 | 67 |
174071 | 174071 | 2020-05-24 | Rockingham | New Hampshire | 33015 | 1223 | 67 |
177114 | 177114 | 2020-05-25 | Rockingham | New Hampshire | 33015 | 1230 | 67 |
180158 | 180158 | 2020-05-26 | Rockingham | New Hampshire | 33015 | 1240 | 67 |
183206 | 183206 | 2020-05-27 | Rockingham | New Hampshire | 33015 | 1254 | 69 |
186263 | 186263 | 2020-05-28 | Rockingham | New Hampshire | 33015 | 1277 | 70 |
189323 | 189323 | 2020-05-29 | Rockingham | New Hampshire | 33015 | 1284 | 70 |
192387 | 192387 | 2020-05-30 | Rockingham | New Hampshire | 33015 | 1293 | 73 |
195457 | 195457 | 2020-05-31 | Rockingham | New Hampshire | 33015 | 1306 | 75 |
198530 | 198530 | 2020-06-01 | Rockingham | New Hampshire | 33015 | 1313 | 75 |
201604 | 201604 | 2020-06-02 | Rockingham | New Hampshire | 33015 | 1320 | 76 |
204681 | 204681 | 2020-06-03 | Rockingham | New Hampshire | 33015 | 1336 | 76 |
207762 | 207762 | 2020-06-04 | Rockingham | New Hampshire | 33015 | 1347 | 76 |
210844 | 210844 | 2020-06-05 | Rockingham | New Hampshire | 33015 | 1359 | 76 |
213928 | 213928 | 2020-06-06 | Rockingham | New Hampshire | 33015 | 1378 | 76 |
217017 | 217017 | 2020-06-07 | Rockingham | New Hampshire | 33015 | 1380 | 76 |
220109 | 220109 | 2020-06-08 | Rockingham | New Hampshire | 33015 | 1386 | 76 |
223204 | 223204 | 2020-06-09 | Rockingham | New Hampshire | 33015 | 1393 | 78 |
226304 | 226304 | 2020-06-10 | Rockingham | New Hampshire | 33015 | 1392 | 79 |
229408 | 229408 | 2020-06-11 | Rockingham | New Hampshire | 33015 | 1400 | 79 |
232513 | 232513 | 2020-06-12 | Rockingham | New Hampshire | 33015 | 1406 | 79 |
235618 | 235618 | 2020-06-13 | Rockingham | New Hampshire | 33015 | 1410 | 79 |
238725 | 238725 | 2020-06-14 | Rockingham | New Hampshire | 33015 | 1412 | 79 |
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);