ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Huron" and state = "Ohio" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
4205 | 4205 | 2020-03-18 | Huron | Ohio | 39077 | 1 | 0 |
4937 | 4937 | 2020-03-19 | Huron | Ohio | 39077 | 1 | 0 |
5800 | 5800 | 2020-03-20 | Huron | Ohio | 39077 | 1 | 0 |
6800 | 6800 | 2020-03-21 | Huron | Ohio | 39077 | 1 | 0 |
7911 | 7911 | 2020-03-22 | Huron | Ohio | 39077 | 1 | 0 |
9114 | 9114 | 2020-03-23 | Huron | Ohio | 39077 | 1 | 0 |
10430 | 10430 | 2020-03-24 | Huron | Ohio | 39077 | 2 | 0 |
11878 | 11878 | 2020-03-25 | Huron | Ohio | 39077 | 2 | 0 |
13485 | 13485 | 2020-03-26 | Huron | Ohio | 39077 | 3 | 0 |
15223 | 15223 | 2020-03-27 | Huron | Ohio | 39077 | 3 | 0 |
17065 | 17065 | 2020-03-28 | Huron | Ohio | 39077 | 3 | 0 |
18999 | 18999 | 2020-03-29 | Huron | Ohio | 39077 | 3 | 0 |
21044 | 21044 | 2020-03-30 | Huron | Ohio | 39077 | 3 | 1 |
23176 | 23176 | 2020-03-31 | Huron | Ohio | 39077 | 4 | 1 |
25371 | 25371 | 2020-04-01 | Huron | Ohio | 39077 | 4 | 1 |
27639 | 27639 | 2020-04-02 | Huron | Ohio | 39077 | 4 | 1 |
29968 | 29968 | 2020-04-03 | Huron | Ohio | 39077 | 5 | 1 |
32357 | 32357 | 2020-04-04 | Huron | Ohio | 39077 | 6 | 1 |
34790 | 34790 | 2020-04-05 | Huron | Ohio | 39077 | 6 | 1 |
37259 | 37259 | 2020-04-06 | Huron | Ohio | 39077 | 9 | 1 |
39776 | 39776 | 2020-04-07 | Huron | Ohio | 39077 | 10 | 1 |
42335 | 42335 | 2020-04-08 | Huron | Ohio | 39077 | 9 | 1 |
44920 | 44920 | 2020-04-09 | Huron | Ohio | 39077 | 10 | 1 |
47535 | 47535 | 2020-04-10 | Huron | Ohio | 39077 | 10 | 1 |
50191 | 50191 | 2020-04-11 | Huron | Ohio | 39077 | 15 | 1 |
52864 | 52864 | 2020-04-12 | Huron | Ohio | 39077 | 14 | 1 |
55548 | 55548 | 2020-04-13 | Huron | Ohio | 39077 | 14 | 1 |
58249 | 58249 | 2020-04-14 | Huron | Ohio | 39077 | 14 | 1 |
60964 | 60964 | 2020-04-15 | Huron | Ohio | 39077 | 14 | 1 |
63690 | 63690 | 2020-04-16 | Huron | Ohio | 39077 | 16 | 1 |
66433 | 66433 | 2020-04-17 | Huron | Ohio | 39077 | 16 | 1 |
69190 | 69190 | 2020-04-18 | Huron | Ohio | 39077 | 15 | 1 |
71957 | 71957 | 2020-04-19 | Huron | Ohio | 39077 | 16 | 1 |
74732 | 74732 | 2020-04-20 | Huron | Ohio | 39077 | 20 | 1 |
77513 | 77513 | 2020-04-21 | Huron | Ohio | 39077 | 23 | 1 |
83102 | 83102 | 2020-04-23 | Huron | Ohio | 39077 | 24 | 1 |
85906 | 85906 | 2020-04-24 | Huron | Ohio | 39077 | 25 | 1 |
88720 | 88720 | 2020-04-25 | Huron | Ohio | 39077 | 27 | 1 |
91536 | 91536 | 2020-04-26 | Huron | Ohio | 39077 | 28 | 1 |
94362 | 94362 | 2020-04-27 | Huron | Ohio | 39077 | 29 | 1 |
97199 | 97199 | 2020-04-28 | Huron | Ohio | 39077 | 30 | 1 |
100048 | 100048 | 2020-04-29 | Huron | Ohio | 39077 | 30 | 1 |
102901 | 102901 | 2020-04-30 | Huron | Ohio | 39077 | 29 | 1 |
105764 | 105764 | 2020-05-01 | Huron | Ohio | 39077 | 29 | 1 |
108631 | 108631 | 2020-05-02 | Huron | Ohio | 39077 | 31 | 1 |
111505 | 111505 | 2020-05-03 | Huron | Ohio | 39077 | 31 | 1 |
114386 | 114386 | 2020-05-04 | Huron | Ohio | 39077 | 32 | 1 |
117267 | 117267 | 2020-05-05 | Huron | Ohio | 39077 | 33 | 1 |
120228 | 120228 | 2020-05-06 | Huron | Ohio | 39077 | 34 | 1 |
123205 | 123205 | 2020-05-07 | Huron | Ohio | 39077 | 34 | 1 |
126188 | 126188 | 2020-05-08 | Huron | Ohio | 39077 | 37 | 1 |
129177 | 129177 | 2020-05-09 | Huron | Ohio | 39077 | 38 | 1 |
132166 | 132166 | 2020-05-10 | Huron | Ohio | 39077 | 38 | 1 |
135157 | 135157 | 2020-05-11 | Huron | Ohio | 39077 | 38 | 1 |
138147 | 138147 | 2020-05-12 | Huron | Ohio | 39077 | 39 | 1 |
141143 | 141143 | 2020-05-13 | Huron | Ohio | 39077 | 39 | 1 |
144138 | 144138 | 2020-05-14 | Huron | Ohio | 39077 | 40 | 1 |
147139 | 147139 | 2020-05-15 | Huron | Ohio | 39077 | 39 | 1 |
150146 | 150146 | 2020-05-16 | Huron | Ohio | 39077 | 40 | 1 |
153157 | 153157 | 2020-05-17 | Huron | Ohio | 39077 | 41 | 1 |
156174 | 156174 | 2020-05-18 | Huron | Ohio | 39077 | 42 | 1 |
159194 | 159194 | 2020-05-19 | Huron | Ohio | 39077 | 43 | 1 |
162221 | 162221 | 2020-05-20 | Huron | Ohio | 39077 | 44 | 1 |
165250 | 165250 | 2020-05-21 | Huron | Ohio | 39077 | 46 | 1 |
168286 | 168286 | 2020-05-22 | Huron | Ohio | 39077 | 48 | 1 |
171325 | 171325 | 2020-05-23 | Huron | Ohio | 39077 | 49 | 1 |
174367 | 174367 | 2020-05-24 | Huron | Ohio | 39077 | 52 | 1 |
177411 | 177411 | 2020-05-25 | Huron | Ohio | 39077 | 55 | 1 |
180454 | 180454 | 2020-05-26 | Huron | Ohio | 39077 | 55 | 1 |
183503 | 183503 | 2020-05-27 | Huron | Ohio | 39077 | 55 | 1 |
186560 | 186560 | 2020-05-28 | Huron | Ohio | 39077 | 56 | 1 |
189620 | 189620 | 2020-05-29 | Huron | Ohio | 39077 | 56 | 1 |
192684 | 192684 | 2020-05-30 | Huron | Ohio | 39077 | 57 | 1 |
195754 | 195754 | 2020-05-31 | Huron | Ohio | 39077 | 58 | 1 |
198827 | 198827 | 2020-06-01 | Huron | Ohio | 39077 | 60 | 1 |
201902 | 201902 | 2020-06-02 | Huron | Ohio | 39077 | 60 | 1 |
204979 | 204979 | 2020-06-03 | Huron | Ohio | 39077 | 60 | 1 |
208060 | 208060 | 2020-06-04 | Huron | Ohio | 39077 | 61 | 1 |
211142 | 211142 | 2020-06-05 | Huron | Ohio | 39077 | 61 | 1 |
214228 | 214228 | 2020-06-06 | Huron | Ohio | 39077 | 62 | 1 |
217318 | 217318 | 2020-06-07 | Huron | Ohio | 39077 | 63 | 1 |
220410 | 220410 | 2020-06-08 | Huron | Ohio | 39077 | 63 | 1 |
223505 | 223505 | 2020-06-09 | Huron | Ohio | 39077 | 64 | 1 |
226605 | 226605 | 2020-06-10 | Huron | Ohio | 39077 | 64 | 1 |
229709 | 229709 | 2020-06-11 | Huron | Ohio | 39077 | 71 | 1 |
232814 | 232814 | 2020-06-12 | Huron | Ohio | 39077 | 72 | 1 |
235919 | 235919 | 2020-06-13 | Huron | Ohio | 39077 | 74 | 1 |
239027 | 239027 | 2020-06-14 | Huron | Ohio | 39077 | 77 | 1 |
242136 | 242136 | 2020-06-15 | Huron | Ohio | 39077 | 77 | 1 |
245248 | 245248 | 2020-06-16 | Huron | Ohio | 39077 | 79 | 1 |
248361 | 248361 | 2020-06-17 | Huron | Ohio | 39077 | 81 | 1 |
251476 | 251476 | 2020-06-18 | Huron | Ohio | 39077 | 95 | 1 |
254591 | 254591 | 2020-06-19 | Huron | Ohio | 39077 | 96 | 1 |
257716 | 257716 | 2020-06-20 | Huron | Ohio | 39077 | 97 | 1 |
260843 | 260843 | 2020-06-21 | Huron | Ohio | 39077 | 110 | 1 |
263971 | 263971 | 2020-06-22 | Huron | Ohio | 39077 | 122 | 1 |
267099 | 267099 | 2020-06-23 | Huron | Ohio | 39077 | 127 | 1 |
270233 | 270233 | 2020-06-24 | Huron | Ohio | 39077 | 129 | 1 |
273372 | 273372 | 2020-06-25 | Huron | Ohio | 39077 | 144 | 1 |
276519 | 276519 | 2020-06-26 | Huron | Ohio | 39077 | 147 | 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);