ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 39085 and state = "Ohio" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
3592 | 3592 | 2020-03-17 | Lake | Ohio | 39085 | 1 | 0 |
4206 | 4206 | 2020-03-18 | Lake | Ohio | 39085 | 2 | 0 |
4938 | 4938 | 2020-03-19 | Lake | Ohio | 39085 | 2 | 0 |
5801 | 5801 | 2020-03-20 | Lake | Ohio | 39085 | 3 | 0 |
6801 | 6801 | 2020-03-21 | Lake | Ohio | 39085 | 4 | 0 |
7912 | 7912 | 2020-03-22 | Lake | Ohio | 39085 | 6 | 0 |
9116 | 9116 | 2020-03-23 | Lake | Ohio | 39085 | 8 | 0 |
10432 | 10432 | 2020-03-24 | Lake | Ohio | 39085 | 11 | 0 |
11880 | 11880 | 2020-03-25 | Lake | Ohio | 39085 | 14 | 0 |
13488 | 13488 | 2020-03-26 | Lake | Ohio | 39085 | 19 | 0 |
15226 | 15226 | 2020-03-27 | Lake | Ohio | 39085 | 27 | 1 |
17068 | 17068 | 2020-03-28 | Lake | Ohio | 39085 | 30 | 1 |
19002 | 19002 | 2020-03-29 | Lake | Ohio | 39085 | 35 | 1 |
21047 | 21047 | 2020-03-30 | Lake | Ohio | 39085 | 43 | 1 |
23179 | 23179 | 2020-03-31 | Lake | Ohio | 39085 | 44 | 2 |
25374 | 25374 | 2020-04-01 | Lake | Ohio | 39085 | 48 | 2 |
27642 | 27642 | 2020-04-02 | Lake | Ohio | 39085 | 62 | 3 |
29971 | 29971 | 2020-04-03 | Lake | Ohio | 39085 | 66 | 3 |
32360 | 32360 | 2020-04-04 | Lake | Ohio | 39085 | 76 | 3 |
34793 | 34793 | 2020-04-05 | Lake | Ohio | 39085 | 79 | 3 |
37262 | 37262 | 2020-04-06 | Lake | Ohio | 39085 | 87 | 3 |
39779 | 39779 | 2020-04-07 | Lake | Ohio | 39085 | 92 | 4 |
42339 | 42339 | 2020-04-08 | Lake | Ohio | 39085 | 99 | 4 |
44924 | 44924 | 2020-04-09 | Lake | Ohio | 39085 | 106 | 5 |
47539 | 47539 | 2020-04-10 | Lake | Ohio | 39085 | 108 | 6 |
50195 | 50195 | 2020-04-11 | Lake | Ohio | 39085 | 112 | 6 |
52868 | 52868 | 2020-04-12 | Lake | Ohio | 39085 | 114 | 6 |
55552 | 55552 | 2020-04-13 | Lake | Ohio | 39085 | 117 | 6 |
58253 | 58253 | 2020-04-14 | Lake | Ohio | 39085 | 121 | 6 |
60968 | 60968 | 2020-04-15 | Lake | Ohio | 39085 | 124 | 6 |
63694 | 63694 | 2020-04-16 | Lake | Ohio | 39085 | 127 | 6 |
66437 | 66437 | 2020-04-17 | Lake | Ohio | 39085 | 130 | 6 |
69194 | 69194 | 2020-04-18 | Lake | Ohio | 39085 | 131 | 6 |
71961 | 71961 | 2020-04-19 | Lake | Ohio | 39085 | 133 | 6 |
74736 | 74736 | 2020-04-20 | Lake | Ohio | 39085 | 135 | 6 |
77517 | 77517 | 2020-04-21 | Lake | Ohio | 39085 | 139 | 6 |
80307 | 80307 | 2020-04-22 | Lake | Ohio | 39085 | 145 | 6 |
83106 | 83106 | 2020-04-23 | Lake | Ohio | 39085 | 148 | 6 |
85910 | 85910 | 2020-04-24 | Lake | Ohio | 39085 | 154 | 7 |
88724 | 88724 | 2020-04-25 | Lake | Ohio | 39085 | 157 | 7 |
91540 | 91540 | 2020-04-26 | Lake | Ohio | 39085 | 157 | 7 |
94366 | 94366 | 2020-04-27 | Lake | Ohio | 39085 | 158 | 7 |
97203 | 97203 | 2020-04-28 | Lake | Ohio | 39085 | 160 | 7 |
100052 | 100052 | 2020-04-29 | Lake | Ohio | 39085 | 165 | 7 |
102905 | 102905 | 2020-04-30 | Lake | Ohio | 39085 | 168 | 7 |
105768 | 105768 | 2020-05-01 | Lake | Ohio | 39085 | 170 | 8 |
108635 | 108635 | 2020-05-02 | Lake | Ohio | 39085 | 170 | 8 |
111509 | 111509 | 2020-05-03 | Lake | Ohio | 39085 | 172 | 8 |
114390 | 114390 | 2020-05-04 | Lake | Ohio | 39085 | 173 | 8 |
117271 | 117271 | 2020-05-05 | Lake | Ohio | 39085 | 176 | 8 |
120232 | 120232 | 2020-05-06 | Lake | Ohio | 39085 | 180 | 8 |
123209 | 123209 | 2020-05-07 | Lake | Ohio | 39085 | 187 | 8 |
126192 | 126192 | 2020-05-08 | Lake | Ohio | 39085 | 192 | 8 |
129181 | 129181 | 2020-05-09 | Lake | Ohio | 39085 | 194 | 8 |
132170 | 132170 | 2020-05-10 | Lake | Ohio | 39085 | 197 | 8 |
135161 | 135161 | 2020-05-11 | Lake | Ohio | 39085 | 199 | 8 |
138151 | 138151 | 2020-05-12 | Lake | Ohio | 39085 | 203 | 8 |
141147 | 141147 | 2020-05-13 | Lake | Ohio | 39085 | 206 | 8 |
144142 | 144142 | 2020-05-14 | Lake | Ohio | 39085 | 210 | 8 |
147143 | 147143 | 2020-05-15 | Lake | Ohio | 39085 | 214 | 8 |
150150 | 150150 | 2020-05-16 | Lake | Ohio | 39085 | 219 | 8 |
153161 | 153161 | 2020-05-17 | Lake | Ohio | 39085 | 224 | 8 |
156178 | 156178 | 2020-05-18 | Lake | Ohio | 39085 | 226 | 9 |
159198 | 159198 | 2020-05-19 | Lake | Ohio | 39085 | 231 | 9 |
162225 | 162225 | 2020-05-20 | Lake | Ohio | 39085 | 235 | 9 |
165254 | 165254 | 2020-05-21 | Lake | Ohio | 39085 | 246 | 11 |
168290 | 168290 | 2020-05-22 | Lake | Ohio | 39085 | 252 | 11 |
174371 | 174371 | 2020-05-24 | Lake | Ohio | 39085 | 267 | 11 |
177415 | 177415 | 2020-05-25 | Lake | Ohio | 39085 | 268 | 11 |
171329 | 171329 | 2020-05-23 | Lake | Ohio | 39085 | 263 | 12 |
180458 | 180458 | 2020-05-26 | Lake | Ohio | 39085 | 282 | 12 |
183507 | 183507 | 2020-05-27 | Lake | Ohio | 39085 | 287 | 12 |
186564 | 186564 | 2020-05-28 | Lake | Ohio | 39085 | 290 | 12 |
189624 | 189624 | 2020-05-29 | Lake | Ohio | 39085 | 302 | 12 |
192688 | 192688 | 2020-05-30 | Lake | Ohio | 39085 | 306 | 12 |
195758 | 195758 | 2020-05-31 | Lake | Ohio | 39085 | 308 | 12 |
201906 | 201906 | 2020-06-02 | Lake | Ohio | 39085 | 309 | 12 |
204983 | 204983 | 2020-06-03 | Lake | Ohio | 39085 | 318 | 12 |
208064 | 208064 | 2020-06-04 | Lake | Ohio | 39085 | 320 | 12 |
211146 | 211146 | 2020-06-05 | Lake | Ohio | 39085 | 325 | 12 |
214232 | 214232 | 2020-06-06 | Lake | Ohio | 39085 | 327 | 12 |
217322 | 217322 | 2020-06-07 | Lake | Ohio | 39085 | 331 | 12 |
220414 | 220414 | 2020-06-08 | Lake | Ohio | 39085 | 334 | 12 |
223509 | 223509 | 2020-06-09 | Lake | Ohio | 39085 | 337 | 12 |
226609 | 226609 | 2020-06-10 | Lake | Ohio | 39085 | 337 | 12 |
229713 | 229713 | 2020-06-11 | Lake | Ohio | 39085 | 338 | 12 |
232818 | 232818 | 2020-06-12 | Lake | Ohio | 39085 | 344 | 12 |
235923 | 235923 | 2020-06-13 | Lake | Ohio | 39085 | 346 | 12 |
239031 | 239031 | 2020-06-14 | Lake | Ohio | 39085 | 347 | 12 |
242140 | 242140 | 2020-06-15 | Lake | Ohio | 39085 | 348 | 12 |
245252 | 245252 | 2020-06-16 | Lake | Ohio | 39085 | 350 | 12 |
248365 | 248365 | 2020-06-17 | Lake | Ohio | 39085 | 354 | 12 |
198831 | 198831 | 2020-06-01 | Lake | Ohio | 39085 | 309 | 13 |
251480 | 251480 | 2020-06-18 | Lake | Ohio | 39085 | 356 | 13 |
254595 | 254595 | 2020-06-19 | Lake | Ohio | 39085 | 358 | 13 |
257720 | 257720 | 2020-06-20 | Lake | Ohio | 39085 | 364 | 14 |
260847 | 260847 | 2020-06-21 | Lake | Ohio | 39085 | 367 | 14 |
263975 | 263975 | 2020-06-22 | Lake | Ohio | 39085 | 369 | 14 |
270237 | 270237 | 2020-06-24 | Lake | Ohio | 39085 | 381 | 14 |
267103 | 267103 | 2020-06-23 | Lake | Ohio | 39085 | 373 | 15 |
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);