ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,552 rows where county = "Hampshire" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4735 | 4735 | 2020-03-19 | Hampshire | Massachusetts | 25015 | 1 | 0 |
5554 | 5554 | 2020-03-20 | Hampshire | Massachusetts | 25015 | 2 | 0 |
6513 | 6513 | 2020-03-21 | Hampshire | Massachusetts | 25015 | 2 | 0 |
7590 | 7590 | 2020-03-22 | Hampshire | Massachusetts | 25015 | 4 | 0 |
8762 | 8762 | 2020-03-23 | Hampshire | Massachusetts | 25015 | 6 | 0 |
10051 | 10051 | 2020-03-24 | Hampshire | Massachusetts | 25015 | 8 | 0 |
11463 | 11463 | 2020-03-25 | Hampshire | Massachusetts | 25015 | 11 | 0 |
13044 | 13044 | 2020-03-26 | Hampshire | Massachusetts | 25015 | 17 | 0 |
14752 | 14752 | 2020-03-27 | Hampshire | Massachusetts | 25015 | 20 | 0 |
16572 | 16572 | 2020-03-28 | Hampshire | Massachusetts | 25015 | 30 | 0 |
18487 | 18487 | 2020-03-29 | Hampshire | Massachusetts | 25015 | 37 | 0 |
20503 | 20503 | 2020-03-30 | Hampshire | Massachusetts | 25015 | 46 | 0 |
22612 | 22612 | 2020-03-31 | Hampshire | Massachusetts | 25015 | 69 | 1 |
24791 | 24791 | 2020-04-01 | Hampshire | Massachusetts | 25015 | 81 | 1 |
27043 | 27043 | 2020-04-02 | Hampshire | Massachusetts | 25015 | 102 | 2 |
29361 | 29361 | 2020-04-03 | Hampshire | Massachusetts | 25015 | 114 | 3 |
31739 | 31739 | 2020-04-04 | Hampshire | Massachusetts | 25015 | 125 | 3 |
34164 | 34164 | 2020-04-05 | Hampshire | Massachusetts | 25015 | 128 | 3 |
36623 | 36623 | 2020-04-06 | Hampshire | Massachusetts | 25015 | 147 | 3 |
39131 | 39131 | 2020-04-07 | Hampshire | Massachusetts | 25015 | 158 | 3 |
41683 | 41683 | 2020-04-08 | Hampshire | Massachusetts | 25015 | 164 | 3 |
43086 | 43086 | 2020-04-08 | Hampshire | West Virginia | 54027 | 2 | 0 |
44259 | 44259 | 2020-04-09 | Hampshire | Massachusetts | 25015 | 177 | 3 |
45682 | 45682 | 2020-04-09 | Hampshire | West Virginia | 54027 | 2 | 0 |
46867 | 46867 | 2020-04-10 | Hampshire | Massachusetts | 25015 | 194 | 4 |
48310 | 48310 | 2020-04-10 | Hampshire | West Virginia | 54027 | 2 | 0 |
49509 | 49509 | 2020-04-11 | Hampshire | Massachusetts | 25015 | 204 | 5 |
50968 | 50968 | 2020-04-11 | Hampshire | West Virginia | 54027 | 4 | 0 |
52179 | 52179 | 2020-04-12 | Hampshire | Massachusetts | 25015 | 219 | 6 |
53644 | 53644 | 2020-04-12 | Hampshire | West Virginia | 54027 | 4 | 0 |
54860 | 54860 | 2020-04-13 | Hampshire | Massachusetts | 25015 | 224 | 6 |
56334 | 56334 | 2020-04-13 | Hampshire | West Virginia | 54027 | 5 | 0 |
57558 | 57558 | 2020-04-14 | Hampshire | Massachusetts | 25015 | 233 | 6 |
59040 | 59040 | 2020-04-14 | Hampshire | West Virginia | 54027 | 7 | 0 |
60267 | 60267 | 2020-04-15 | Hampshire | Massachusetts | 25015 | 239 | 6 |
61759 | 61759 | 2020-04-15 | Hampshire | West Virginia | 54027 | 7 | 0 |
62988 | 62988 | 2020-04-16 | Hampshire | Massachusetts | 25015 | 248 | 6 |
64492 | 64492 | 2020-04-16 | Hampshire | West Virginia | 54027 | 6 | 0 |
65726 | 65726 | 2020-04-17 | Hampshire | Massachusetts | 25015 | 258 | 7 |
67240 | 67240 | 2020-04-17 | Hampshire | West Virginia | 54027 | 6 | 0 |
68476 | 68476 | 2020-04-18 | Hampshire | Massachusetts | 25015 | 306 | 7 |
70002 | 70002 | 2020-04-18 | Hampshire | West Virginia | 54027 | 6 | 0 |
71240 | 71240 | 2020-04-19 | Hampshire | Massachusetts | 25015 | 317 | 7 |
72771 | 72771 | 2020-04-19 | Hampshire | West Virginia | 54027 | 6 | 1 |
74012 | 74012 | 2020-04-20 | Hampshire | Massachusetts | 25015 | 332 | 9 |
75547 | 75547 | 2020-04-20 | Hampshire | West Virginia | 54027 | 6 | 1 |
76792 | 76792 | 2020-04-21 | Hampshire | Massachusetts | 25015 | 337 | 10 |
78330 | 78330 | 2020-04-21 | Hampshire | West Virginia | 54027 | 7 | 1 |
79578 | 79578 | 2020-04-22 | Hampshire | Massachusetts | 25015 | 345 | 14 |
81123 | 81123 | 2020-04-22 | Hampshire | West Virginia | 54027 | 7 | 1 |
82373 | 82373 | 2020-04-23 | Hampshire | Massachusetts | 25015 | 367 | 15 |
83924 | 83924 | 2020-04-23 | Hampshire | West Virginia | 54027 | 7 | 1 |
85177 | 85177 | 2020-04-24 | Hampshire | Massachusetts | 25015 | 396 | 17 |
86731 | 86731 | 2020-04-24 | Hampshire | West Virginia | 54027 | 7 | 1 |
87987 | 87987 | 2020-04-25 | Hampshire | Massachusetts | 25015 | 412 | 20 |
89547 | 89547 | 2020-04-25 | Hampshire | West Virginia | 54027 | 7 | 1 |
90803 | 90803 | 2020-04-26 | Hampshire | Massachusetts | 25015 | 427 | 24 |
92365 | 92365 | 2020-04-26 | Hampshire | West Virginia | 54027 | 7 | 1 |
93624 | 93624 | 2020-04-27 | Hampshire | Massachusetts | 25015 | 443 | 26 |
95194 | 95194 | 2020-04-27 | Hampshire | West Virginia | 54027 | 7 | 1 |
96459 | 96459 | 2020-04-28 | Hampshire | Massachusetts | 25015 | 509 | 27 |
98039 | 98039 | 2020-04-28 | Hampshire | West Virginia | 54027 | 7 | 1 |
99305 | 99305 | 2020-04-29 | Hampshire | Massachusetts | 25015 | 531 | 26 |
100889 | 100889 | 2020-04-29 | Hampshire | West Virginia | 54027 | 7 | 1 |
102157 | 102157 | 2020-04-30 | Hampshire | Massachusetts | 25015 | 546 | 30 |
103744 | 103744 | 2020-04-30 | Hampshire | West Virginia | 54027 | 7 | 1 |
105017 | 105017 | 2020-05-01 | Hampshire | Massachusetts | 25015 | 518 | 32 |
106608 | 106608 | 2020-05-01 | Hampshire | West Virginia | 54027 | 7 | 1 |
107881 | 107881 | 2020-05-02 | Hampshire | Massachusetts | 25015 | 549 | 33 |
109477 | 109477 | 2020-05-02 | Hampshire | West Virginia | 54027 | 7 | 1 |
110753 | 110753 | 2020-05-03 | Hampshire | Massachusetts | 25015 | 559 | 36 |
112351 | 112351 | 2020-05-03 | Hampshire | West Virginia | 54027 | 7 | 1 |
113631 | 113631 | 2020-05-04 | Hampshire | Massachusetts | 25015 | 563 | 36 |
115234 | 115234 | 2020-05-04 | Hampshire | West Virginia | 54027 | 8 | 1 |
116512 | 116512 | 2020-05-05 | Hampshire | Massachusetts | 25015 | 575 | 47 |
118193 | 118193 | 2020-05-05 | Hampshire | West Virginia | 54027 | 8 | 1 |
119473 | 119473 | 2020-05-06 | Hampshire | Massachusetts | 25015 | 580 | 47 |
121158 | 121158 | 2020-05-06 | Hampshire | West Virginia | 54027 | 8 | 1 |
122445 | 122445 | 2020-05-07 | Hampshire | Massachusetts | 25015 | 595 | 48 |
124138 | 124138 | 2020-05-07 | Hampshire | West Virginia | 54027 | 8 | 1 |
125427 | 125427 | 2020-05-08 | Hampshire | Massachusetts | 25015 | 654 | 48 |
127123 | 127123 | 2020-05-08 | Hampshire | West Virginia | 54027 | 8 | 1 |
128414 | 128414 | 2020-05-09 | Hampshire | Massachusetts | 25015 | 659 | 50 |
130113 | 130113 | 2020-05-09 | Hampshire | West Virginia | 54027 | 8 | 1 |
131404 | 131404 | 2020-05-10 | Hampshire | Massachusetts | 25015 | 676 | 55 |
133103 | 133103 | 2020-05-10 | Hampshire | West Virginia | 54027 | 9 | 1 |
134395 | 134395 | 2020-05-11 | Hampshire | Massachusetts | 25015 | 688 | 57 |
136093 | 136093 | 2020-05-11 | Hampshire | West Virginia | 54027 | 9 | 1 |
137385 | 137385 | 2020-05-12 | Hampshire | Massachusetts | 25015 | 702 | 57 |
139084 | 139084 | 2020-05-12 | Hampshire | West Virginia | 54027 | 10 | 1 |
140379 | 140379 | 2020-05-13 | Hampshire | Massachusetts | 25015 | 708 | 64 |
142080 | 142080 | 2020-05-13 | Hampshire | West Virginia | 54027 | 10 | 1 |
143374 | 143374 | 2020-05-14 | Hampshire | Massachusetts | 25015 | 724 | 66 |
145077 | 145077 | 2020-05-14 | Hampshire | West Virginia | 54027 | 11 | 1 |
146374 | 146374 | 2020-05-15 | Hampshire | Massachusetts | 25015 | 738 | 67 |
148080 | 148080 | 2020-05-15 | Hampshire | West Virginia | 54027 | 12 | 1 |
149379 | 149379 | 2020-05-16 | Hampshire | Massachusetts | 25015 | 751 | 69 |
151089 | 151089 | 2020-05-16 | Hampshire | West Virginia | 54027 | 12 | 1 |
152390 | 152390 | 2020-05-17 | Hampshire | Massachusetts | 25015 | 767 | 72 |
154100 | 154100 | 2020-05-17 | Hampshire | West Virginia | 54027 | 12 | 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);