ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where fips = 39035 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
282792 | 282792 | 2020-06-28 | Cuyahoga | Ohio | 39035 | 6571 | 351 |
279646 | 279646 | 2020-06-27 | Cuyahoga | Ohio | 39035 | 6429 | 351 |
276498 | 276498 | 2020-06-26 | Cuyahoga | Ohio | 39035 | 6287 | 347 |
273351 | 273351 | 2020-06-25 | Cuyahoga | Ohio | 39035 | 6111 | 346 |
270212 | 270212 | 2020-06-24 | Cuyahoga | Ohio | 39035 | 5964 | 343 |
267078 | 267078 | 2020-06-23 | Cuyahoga | Ohio | 39035 | 5820 | 341 |
263950 | 263950 | 2020-06-22 | Cuyahoga | Ohio | 39035 | 5734 | 339 |
260822 | 260822 | 2020-06-21 | Cuyahoga | Ohio | 39035 | 5633 | 338 |
257695 | 257695 | 2020-06-20 | Cuyahoga | Ohio | 39035 | 5555 | 336 |
254570 | 254570 | 2020-06-19 | Cuyahoga | Ohio | 39035 | 5481 | 334 |
251455 | 251455 | 2020-06-18 | Cuyahoga | Ohio | 39035 | 5404 | 327 |
248340 | 248340 | 2020-06-17 | Cuyahoga | Ohio | 39035 | 5336 | 319 |
245227 | 245227 | 2020-06-16 | Cuyahoga | Ohio | 39035 | 5271 | 318 |
242115 | 242115 | 2020-06-15 | Cuyahoga | Ohio | 39035 | 5220 | 315 |
239006 | 239006 | 2020-06-14 | Cuyahoga | Ohio | 39035 | 5175 | 311 |
235898 | 235898 | 2020-06-13 | Cuyahoga | Ohio | 39035 | 5144 | 310 |
232793 | 232793 | 2020-06-12 | Cuyahoga | Ohio | 39035 | 5112 | 304 |
229688 | 229688 | 2020-06-11 | Cuyahoga | Ohio | 39035 | 5057 | 303 |
226584 | 226584 | 2020-06-10 | Cuyahoga | Ohio | 39035 | 5011 | 298 |
223484 | 223484 | 2020-06-09 | Cuyahoga | Ohio | 39035 | 4939 | 287 |
220389 | 220389 | 2020-06-08 | Cuyahoga | Ohio | 39035 | 4910 | 283 |
217297 | 217297 | 2020-06-07 | Cuyahoga | Ohio | 39035 | 4858 | 268 |
214207 | 214207 | 2020-06-06 | Cuyahoga | Ohio | 39035 | 4827 | 265 |
211121 | 211121 | 2020-06-05 | Cuyahoga | Ohio | 39035 | 4789 | 265 |
208039 | 208039 | 2020-06-04 | Cuyahoga | Ohio | 39035 | 4732 | 259 |
204958 | 204958 | 2020-06-03 | Cuyahoga | Ohio | 39035 | 4669 | 247 |
201881 | 201881 | 2020-06-02 | Cuyahoga | Ohio | 39035 | 4581 | 245 |
198806 | 198806 | 2020-06-01 | Cuyahoga | Ohio | 39035 | 4508 | 241 |
195733 | 195733 | 2020-05-31 | Cuyahoga | Ohio | 39035 | 4444 | 226 |
192663 | 192663 | 2020-05-30 | Cuyahoga | Ohio | 39035 | 4369 | 226 |
189599 | 189599 | 2020-05-29 | Cuyahoga | Ohio | 39035 | 4318 | 226 |
186539 | 186539 | 2020-05-28 | Cuyahoga | Ohio | 39035 | 4211 | 226 |
183482 | 183482 | 2020-05-27 | Cuyahoga | Ohio | 39035 | 4137 | 224 |
180433 | 180433 | 2020-05-26 | Cuyahoga | Ohio | 39035 | 4060 | 221 |
177390 | 177390 | 2020-05-25 | Cuyahoga | Ohio | 39035 | 3963 | 217 |
174346 | 174346 | 2020-05-24 | Cuyahoga | Ohio | 39035 | 3927 | 209 |
171304 | 171304 | 2020-05-23 | Cuyahoga | Ohio | 39035 | 3851 | 207 |
168265 | 168265 | 2020-05-22 | Cuyahoga | Ohio | 39035 | 3762 | 204 |
165229 | 165229 | 2020-05-21 | Cuyahoga | Ohio | 39035 | 3667 | 202 |
162200 | 162200 | 2020-05-20 | Cuyahoga | Ohio | 39035 | 3512 | 190 |
159173 | 159173 | 2020-05-19 | Cuyahoga | Ohio | 39035 | 3463 | 183 |
156153 | 156153 | 2020-05-18 | Cuyahoga | Ohio | 39035 | 3410 | 175 |
153136 | 153136 | 2020-05-17 | Cuyahoga | Ohio | 39035 | 3321 | 173 |
150125 | 150125 | 2020-05-16 | Cuyahoga | Ohio | 39035 | 3223 | 163 |
147118 | 147118 | 2020-05-15 | Cuyahoga | Ohio | 39035 | 3156 | 162 |
144117 | 144117 | 2020-05-14 | Cuyahoga | Ohio | 39035 | 3066 | 157 |
141122 | 141122 | 2020-05-13 | Cuyahoga | Ohio | 39035 | 2979 | 153 |
138126 | 138126 | 2020-05-12 | Cuyahoga | Ohio | 39035 | 2908 | 151 |
135136 | 135136 | 2020-05-11 | Cuyahoga | Ohio | 39035 | 2861 | 147 |
132145 | 132145 | 2020-05-10 | Cuyahoga | Ohio | 39035 | 2795 | 146 |
129156 | 129156 | 2020-05-09 | Cuyahoga | Ohio | 39035 | 2755 | 145 |
126167 | 126167 | 2020-05-08 | Cuyahoga | Ohio | 39035 | 2668 | 143 |
123184 | 123184 | 2020-05-07 | Cuyahoga | Ohio | 39035 | 2591 | 136 |
120207 | 120207 | 2020-05-06 | Cuyahoga | Ohio | 39035 | 2542 | 131 |
117246 | 117246 | 2020-05-05 | Cuyahoga | Ohio | 39035 | 2428 | 128 |
114365 | 114365 | 2020-05-04 | Cuyahoga | Ohio | 39035 | 2398 | 121 |
111484 | 111484 | 2020-05-03 | Cuyahoga | Ohio | 39035 | 2338 | 120 |
108610 | 108610 | 2020-05-02 | Cuyahoga | Ohio | 39035 | 2305 | 115 |
105743 | 105743 | 2020-05-01 | Cuyahoga | Ohio | 39035 | 2217 | 115 |
102880 | 102880 | 2020-04-30 | Cuyahoga | Ohio | 39035 | 2126 | 112 |
100027 | 100027 | 2020-04-29 | Cuyahoga | Ohio | 39035 | 2030 | 110 |
97178 | 97178 | 2020-04-28 | Cuyahoga | Ohio | 39035 | 1984 | 109 |
94341 | 94341 | 2020-04-27 | Cuyahoga | Ohio | 39035 | 1938 | 96 |
91515 | 91515 | 2020-04-26 | Cuyahoga | Ohio | 39035 | 1902 | 91 |
88699 | 88699 | 2020-04-25 | Cuyahoga | Ohio | 39035 | 1867 | 91 |
85885 | 85885 | 2020-04-24 | Cuyahoga | Ohio | 39035 | 1817 | 91 |
83081 | 83081 | 2020-04-23 | Cuyahoga | Ohio | 39035 | 1768 | 83 |
80282 | 80282 | 2020-04-22 | Cuyahoga | Ohio | 39035 | 1713 | 79 |
77492 | 77492 | 2020-04-21 | Cuyahoga | Ohio | 39035 | 1653 | 64 |
74711 | 74711 | 2020-04-20 | Cuyahoga | Ohio | 39035 | 1577 | 55 |
71936 | 71936 | 2020-04-19 | Cuyahoga | Ohio | 39035 | 1466 | 53 |
69169 | 69169 | 2020-04-18 | Cuyahoga | Ohio | 39035 | 1453 | 52 |
66412 | 66412 | 2020-04-17 | Cuyahoga | Ohio | 39035 | 1383 | 48 |
63669 | 63669 | 2020-04-16 | Cuyahoga | Ohio | 39035 | 1331 | 42 |
60943 | 60943 | 2020-04-15 | Cuyahoga | Ohio | 39035 | 1281 | 39 |
58229 | 58229 | 2020-04-14 | Cuyahoga | Ohio | 39035 | 1239 | 33 |
55528 | 55528 | 2020-04-13 | Cuyahoga | Ohio | 39035 | 1197 | 24 |
52844 | 52844 | 2020-04-12 | Cuyahoga | Ohio | 39035 | 1152 | 23 |
50171 | 50171 | 2020-04-11 | Cuyahoga | Ohio | 39035 | 1113 | 22 |
47516 | 47516 | 2020-04-10 | Cuyahoga | Ohio | 39035 | 1052 | 22 |
44901 | 44901 | 2020-04-09 | Cuyahoga | Ohio | 39035 | 1014 | 23 |
42316 | 42316 | 2020-04-08 | Cuyahoga | Ohio | 39035 | 960 | 23 |
39758 | 39758 | 2020-04-07 | Cuyahoga | Ohio | 39035 | 911 | 19 |
37241 | 37241 | 2020-04-06 | Cuyahoga | Ohio | 39035 | 871 | 15 |
34772 | 34772 | 2020-04-05 | Cuyahoga | Ohio | 39035 | 826 | 14 |
32339 | 32339 | 2020-04-04 | Cuyahoga | Ohio | 39035 | 781 | 13 |
29950 | 29950 | 2020-04-03 | Cuyahoga | Ohio | 39035 | 780 | 13 |
27621 | 27621 | 2020-04-02 | Cuyahoga | Ohio | 39035 | 663 | 12 |
25355 | 25355 | 2020-04-01 | Cuyahoga | Ohio | 39035 | 589 | 9 |
23160 | 23160 | 2020-03-31 | Cuyahoga | Ohio | 39035 | 527 | 6 |
21028 | 21028 | 2020-03-30 | Cuyahoga | Ohio | 39035 | 493 | 4 |
18984 | 18984 | 2020-03-29 | Cuyahoga | Ohio | 39035 | 449 | 4 |
17050 | 17050 | 2020-03-28 | Cuyahoga | Ohio | 39035 | 370 | 3 |
15208 | 15208 | 2020-03-27 | Cuyahoga | Ohio | 39035 | 330 | 2 |
13471 | 13471 | 2020-03-26 | Cuyahoga | Ohio | 39035 | 259 | 2 |
11864 | 11864 | 2020-03-25 | Cuyahoga | Ohio | 39035 | 206 | 2 |
10417 | 10417 | 2020-03-24 | Cuyahoga | Ohio | 39035 | 167 | 2 |
9103 | 9103 | 2020-03-23 | Cuyahoga | Ohio | 39035 | 149 | 1 |
7900 | 7900 | 2020-03-22 | Cuyahoga | Ohio | 39035 | 125 | 1 |
6792 | 6792 | 2020-03-21 | Cuyahoga | Ohio | 39035 | 92 | 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);