ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 33005 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5675 | 5675 | 2020-03-20 | Cheshire | New Hampshire | 33005 | 1 | 0 |
6667 | 6667 | 2020-03-21 | Cheshire | New Hampshire | 33005 | 1 | 0 |
7757 | 7757 | 2020-03-22 | Cheshire | New Hampshire | 33005 | 1 | 0 |
8953 | 8953 | 2020-03-23 | Cheshire | New Hampshire | 33005 | 1 | 0 |
10257 | 10257 | 2020-03-24 | Cheshire | New Hampshire | 33005 | 1 | 0 |
11689 | 11689 | 2020-03-25 | Cheshire | New Hampshire | 33005 | 1 | 0 |
13292 | 13292 | 2020-03-26 | Cheshire | New Hampshire | 33005 | 2 | 0 |
15024 | 15024 | 2020-03-27 | Cheshire | New Hampshire | 33005 | 2 | 0 |
16853 | 16853 | 2020-03-28 | Cheshire | New Hampshire | 33005 | 2 | 0 |
18777 | 18777 | 2020-03-29 | Cheshire | New Hampshire | 33005 | 3 | 0 |
20815 | 20815 | 2020-03-30 | Cheshire | New Hampshire | 33005 | 3 | 0 |
22938 | 22938 | 2020-03-31 | Cheshire | New Hampshire | 33005 | 4 | 0 |
25129 | 25129 | 2020-04-01 | Cheshire | New Hampshire | 33005 | 7 | 0 |
27389 | 27389 | 2020-04-02 | Cheshire | New Hampshire | 33005 | 8 | 0 |
29711 | 29711 | 2020-04-03 | Cheshire | New Hampshire | 33005 | 9 | 0 |
32095 | 32095 | 2020-04-04 | Cheshire | New Hampshire | 33005 | 10 | 0 |
34526 | 34526 | 2020-04-05 | Cheshire | New Hampshire | 33005 | 11 | 0 |
36996 | 36996 | 2020-04-06 | Cheshire | New Hampshire | 33005 | 13 | 0 |
39511 | 39511 | 2020-04-07 | Cheshire | New Hampshire | 33005 | 13 | 1 |
42068 | 42068 | 2020-04-08 | Cheshire | New Hampshire | 33005 | 14 | 1 |
44651 | 44651 | 2020-04-09 | Cheshire | New Hampshire | 33005 | 14 | 2 |
47263 | 47263 | 2020-04-10 | Cheshire | New Hampshire | 33005 | 17 | 2 |
49916 | 49916 | 2020-04-11 | Cheshire | New Hampshire | 33005 | 18 | 2 |
52589 | 52589 | 2020-04-12 | Cheshire | New Hampshire | 33005 | 19 | 2 |
55272 | 55272 | 2020-04-13 | Cheshire | New Hampshire | 33005 | 20 | 2 |
57972 | 57972 | 2020-04-14 | Cheshire | New Hampshire | 33005 | 21 | 2 |
60687 | 60687 | 2020-04-15 | Cheshire | New Hampshire | 33005 | 26 | 2 |
63412 | 63412 | 2020-04-16 | Cheshire | New Hampshire | 33005 | 26 | 2 |
66154 | 66154 | 2020-04-17 | Cheshire | New Hampshire | 33005 | 27 | 2 |
68910 | 68910 | 2020-04-18 | Cheshire | New Hampshire | 33005 | 28 | 2 |
71677 | 71677 | 2020-04-19 | Cheshire | New Hampshire | 33005 | 29 | 2 |
74452 | 74452 | 2020-04-20 | Cheshire | New Hampshire | 33005 | 30 | 2 |
77233 | 77233 | 2020-04-21 | Cheshire | New Hampshire | 33005 | 30 | 2 |
80022 | 80022 | 2020-04-22 | Cheshire | New Hampshire | 33005 | 33 | 2 |
82820 | 82820 | 2020-04-23 | Cheshire | New Hampshire | 33005 | 35 | 2 |
85624 | 85624 | 2020-04-24 | Cheshire | New Hampshire | 33005 | 35 | 2 |
88435 | 88435 | 2020-04-25 | Cheshire | New Hampshire | 33005 | 36 | 2 |
91250 | 91250 | 2020-04-26 | Cheshire | New Hampshire | 33005 | 36 | 2 |
94074 | 94074 | 2020-04-27 | Cheshire | New Hampshire | 33005 | 38 | 2 |
96910 | 96910 | 2020-04-28 | Cheshire | New Hampshire | 33005 | 40 | 2 |
99757 | 99757 | 2020-04-29 | Cheshire | New Hampshire | 33005 | 40 | 2 |
102610 | 102610 | 2020-04-30 | Cheshire | New Hampshire | 33005 | 40 | 2 |
105472 | 105472 | 2020-05-01 | Cheshire | New Hampshire | 33005 | 40 | 2 |
108338 | 108338 | 2020-05-02 | Cheshire | New Hampshire | 33005 | 40 | 2 |
111211 | 111211 | 2020-05-03 | Cheshire | New Hampshire | 33005 | 40 | 2 |
114092 | 114092 | 2020-05-04 | Cheshire | New Hampshire | 33005 | 40 | 2 |
116973 | 116973 | 2020-05-05 | Cheshire | New Hampshire | 33005 | 41 | 2 |
119934 | 119934 | 2020-05-06 | Cheshire | New Hampshire | 33005 | 41 | 2 |
122909 | 122909 | 2020-05-07 | Cheshire | New Hampshire | 33005 | 41 | 2 |
125892 | 125892 | 2020-05-08 | Cheshire | New Hampshire | 33005 | 43 | 2 |
128881 | 128881 | 2020-05-09 | Cheshire | New Hampshire | 33005 | 43 | 2 |
131870 | 131870 | 2020-05-10 | Cheshire | New Hampshire | 33005 | 43 | 2 |
134861 | 134861 | 2020-05-11 | Cheshire | New Hampshire | 33005 | 43 | 2 |
137851 | 137851 | 2020-05-12 | Cheshire | New Hampshire | 33005 | 44 | 2 |
140847 | 140847 | 2020-05-13 | Cheshire | New Hampshire | 33005 | 45 | 2 |
143842 | 143842 | 2020-05-14 | Cheshire | New Hampshire | 33005 | 45 | 2 |
146843 | 146843 | 2020-05-15 | Cheshire | New Hampshire | 33005 | 47 | 2 |
149850 | 149850 | 2020-05-16 | Cheshire | New Hampshire | 33005 | 47 | 2 |
152860 | 152860 | 2020-05-17 | Cheshire | New Hampshire | 33005 | 47 | 2 |
155876 | 155876 | 2020-05-18 | Cheshire | New Hampshire | 33005 | 48 | 2 |
158894 | 158894 | 2020-05-19 | Cheshire | New Hampshire | 33005 | 49 | 2 |
161920 | 161920 | 2020-05-20 | Cheshire | New Hampshire | 33005 | 49 | 2 |
164949 | 164949 | 2020-05-21 | Cheshire | New Hampshire | 33005 | 50 | 2 |
167985 | 167985 | 2020-05-22 | Cheshire | New Hampshire | 33005 | 51 | 2 |
171024 | 171024 | 2020-05-23 | Cheshire | New Hampshire | 33005 | 51 | 2 |
174066 | 174066 | 2020-05-24 | Cheshire | New Hampshire | 33005 | 52 | 2 |
177109 | 177109 | 2020-05-25 | Cheshire | New Hampshire | 33005 | 54 | 2 |
180153 | 180153 | 2020-05-26 | Cheshire | New Hampshire | 33005 | 54 | 2 |
183201 | 183201 | 2020-05-27 | Cheshire | New Hampshire | 33005 | 54 | 2 |
186258 | 186258 | 2020-05-28 | Cheshire | New Hampshire | 33005 | 55 | 2 |
189318 | 189318 | 2020-05-29 | Cheshire | New Hampshire | 33005 | 57 | 2 |
192382 | 192382 | 2020-05-30 | Cheshire | New Hampshire | 33005 | 57 | 2 |
195452 | 195452 | 2020-05-31 | Cheshire | New Hampshire | 33005 | 57 | 2 |
198525 | 198525 | 2020-06-01 | Cheshire | New Hampshire | 33005 | 57 | 2 |
201599 | 201599 | 2020-06-02 | Cheshire | New Hampshire | 33005 | 57 | 2 |
204676 | 204676 | 2020-06-03 | Cheshire | New Hampshire | 33005 | 57 | 2 |
207757 | 207757 | 2020-06-04 | Cheshire | New Hampshire | 33005 | 57 | 2 |
210839 | 210839 | 2020-06-05 | Cheshire | New Hampshire | 33005 | 57 | 2 |
213923 | 213923 | 2020-06-06 | Cheshire | New Hampshire | 33005 | 57 | 2 |
217012 | 217012 | 2020-06-07 | Cheshire | New Hampshire | 33005 | 57 | 2 |
220104 | 220104 | 2020-06-08 | Cheshire | New Hampshire | 33005 | 59 | 2 |
223199 | 223199 | 2020-06-09 | Cheshire | New Hampshire | 33005 | 59 | 2 |
226299 | 226299 | 2020-06-10 | Cheshire | New Hampshire | 33005 | 59 | 2 |
229403 | 229403 | 2020-06-11 | Cheshire | New Hampshire | 33005 | 60 | 2 |
232508 | 232508 | 2020-06-12 | Cheshire | New Hampshire | 33005 | 60 | 2 |
235613 | 235613 | 2020-06-13 | Cheshire | New Hampshire | 33005 | 60 | 2 |
238720 | 238720 | 2020-06-14 | Cheshire | New Hampshire | 33005 | 60 | 2 |
241830 | 241830 | 2020-06-15 | Cheshire | New Hampshire | 33005 | 60 | 2 |
244942 | 244942 | 2020-06-16 | Cheshire | New Hampshire | 33005 | 62 | 2 |
248055 | 248055 | 2020-06-17 | Cheshire | New Hampshire | 33005 | 63 | 2 |
251170 | 251170 | 2020-06-18 | Cheshire | New Hampshire | 33005 | 62 | 2 |
254285 | 254285 | 2020-06-19 | Cheshire | New Hampshire | 33005 | 63 | 2 |
257408 | 257408 | 2020-06-20 | Cheshire | New Hampshire | 33005 | 64 | 2 |
260534 | 260534 | 2020-06-21 | Cheshire | New Hampshire | 33005 | 64 | 2 |
263663 | 263663 | 2020-06-22 | Cheshire | New Hampshire | 33005 | 64 | 2 |
266790 | 266790 | 2020-06-23 | Cheshire | New Hampshire | 33005 | 64 | 2 |
269925 | 269925 | 2020-06-24 | Cheshire | New Hampshire | 33005 | 66 | 2 |
273064 | 273064 | 2020-06-25 | Cheshire | New Hampshire | 33005 | 66 | 2 |
276209 | 276209 | 2020-06-26 | Cheshire | New Hampshire | 33005 | 67 | 2 |
279357 | 279357 | 2020-06-27 | Cheshire | New Hampshire | 33005 | 67 | 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);