ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Lucas" and state = "Ohio" sorted by fips descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▲ | cases | deaths |
---|---|---|---|---|---|---|---|
2605 | 2605 | 2020-03-15 | Lucas | Ohio | 39095 | 1 | 0 |
3068 | 3068 | 2020-03-16 | Lucas | Ohio | 39095 | 1 | 0 |
3594 | 3594 | 2020-03-17 | Lucas | Ohio | 39095 | 1 | 0 |
4208 | 4208 | 2020-03-18 | Lucas | Ohio | 39095 | 1 | 0 |
4940 | 4940 | 2020-03-19 | Lucas | Ohio | 39095 | 1 | 0 |
5803 | 5803 | 2020-03-20 | Lucas | Ohio | 39095 | 2 | 1 |
6804 | 6804 | 2020-03-21 | Lucas | Ohio | 39095 | 4 | 1 |
7915 | 7915 | 2020-03-22 | Lucas | Ohio | 39095 | 5 | 1 |
9120 | 9120 | 2020-03-23 | Lucas | Ohio | 39095 | 9 | 1 |
10436 | 10436 | 2020-03-24 | Lucas | Ohio | 39095 | 11 | 1 |
11885 | 11885 | 2020-03-25 | Lucas | Ohio | 39095 | 23 | 2 |
13493 | 13493 | 2020-03-26 | Lucas | Ohio | 39095 | 35 | 2 |
15231 | 15231 | 2020-03-27 | Lucas | Ohio | 39095 | 50 | 2 |
17073 | 17073 | 2020-03-28 | Lucas | Ohio | 39095 | 67 | 2 |
19007 | 19007 | 2020-03-29 | Lucas | Ohio | 39095 | 94 | 2 |
21052 | 21052 | 2020-03-30 | Lucas | Ohio | 39095 | 114 | 3 |
23184 | 23184 | 2020-03-31 | Lucas | Ohio | 39095 | 133 | 3 |
25379 | 25379 | 2020-04-01 | Lucas | Ohio | 39095 | 171 | 3 |
27647 | 27647 | 2020-04-02 | Lucas | Ohio | 39095 | 206 | 3 |
29976 | 29976 | 2020-04-03 | Lucas | Ohio | 39095 | 233 | 4 |
32365 | 32365 | 2020-04-04 | Lucas | Ohio | 39095 | 272 | 7 |
34798 | 34798 | 2020-04-05 | Lucas | Ohio | 39095 | 302 | 8 |
37267 | 37267 | 2020-04-06 | Lucas | Ohio | 39095 | 321 | 12 |
39784 | 39784 | 2020-04-07 | Lucas | Ohio | 39095 | 347 | 16 |
42344 | 42344 | 2020-04-08 | Lucas | Ohio | 39095 | 371 | 16 |
44929 | 44929 | 2020-04-09 | Lucas | Ohio | 39095 | 403 | 16 |
47544 | 47544 | 2020-04-10 | Lucas | Ohio | 39095 | 443 | 20 |
50200 | 50200 | 2020-04-11 | Lucas | Ohio | 39095 | 490 | 21 |
52873 | 52873 | 2020-04-12 | Lucas | Ohio | 39095 | 503 | 21 |
55557 | 55557 | 2020-04-13 | Lucas | Ohio | 39095 | 514 | 21 |
58258 | 58258 | 2020-04-14 | Lucas | Ohio | 39095 | 540 | 25 |
60973 | 60973 | 2020-04-15 | Lucas | Ohio | 39095 | 596 | 28 |
63699 | 63699 | 2020-04-16 | Lucas | Ohio | 39095 | 644 | 28 |
66442 | 66442 | 2020-04-17 | Lucas | Ohio | 39095 | 682 | 28 |
69199 | 69199 | 2020-04-18 | Lucas | Ohio | 39095 | 724 | 31 |
71966 | 71966 | 2020-04-19 | Lucas | Ohio | 39095 | 789 | 33 |
74741 | 74741 | 2020-04-20 | Lucas | Ohio | 39095 | 823 | 33 |
77522 | 77522 | 2020-04-21 | Lucas | Ohio | 39095 | 853 | 36 |
80312 | 80312 | 2020-04-22 | Lucas | Ohio | 39095 | 878 | 44 |
83111 | 83111 | 2020-04-23 | Lucas | Ohio | 39095 | 936 | 55 |
85915 | 85915 | 2020-04-24 | Lucas | Ohio | 39095 | 985 | 58 |
88729 | 88729 | 2020-04-25 | Lucas | Ohio | 39095 | 1033 | 59 |
91545 | 91545 | 2020-04-26 | Lucas | Ohio | 39095 | 1104 | 59 |
94371 | 94371 | 2020-04-27 | Lucas | Ohio | 39095 | 1130 | 61 |
97208 | 97208 | 2020-04-28 | Lucas | Ohio | 39095 | 1166 | 66 |
100057 | 100057 | 2020-04-29 | Lucas | Ohio | 39095 | 1208 | 114 |
102910 | 102910 | 2020-04-30 | Lucas | Ohio | 39095 | 1251 | 117 |
105773 | 105773 | 2020-05-01 | Lucas | Ohio | 39095 | 1297 | 119 |
108640 | 108640 | 2020-05-02 | Lucas | Ohio | 39095 | 1331 | 119 |
111514 | 111514 | 2020-05-03 | Lucas | Ohio | 39095 | 1376 | 119 |
114395 | 114395 | 2020-05-04 | Lucas | Ohio | 39095 | 1429 | 120 |
117276 | 117276 | 2020-05-05 | Lucas | Ohio | 39095 | 1478 | 133 |
120237 | 120237 | 2020-05-06 | Lucas | Ohio | 39095 | 1527 | 151 |
123214 | 123214 | 2020-05-07 | Lucas | Ohio | 39095 | 1583 | 155 |
126197 | 126197 | 2020-05-08 | Lucas | Ohio | 39095 | 1665 | 161 |
129186 | 129186 | 2020-05-09 | Lucas | Ohio | 39095 | 1710 | 164 |
132175 | 132175 | 2020-05-10 | Lucas | Ohio | 39095 | 1757 | 164 |
135166 | 135166 | 2020-05-11 | Lucas | Ohio | 39095 | 1806 | 165 |
138156 | 138156 | 2020-05-12 | Lucas | Ohio | 39095 | 1836 | 179 |
141152 | 141152 | 2020-05-13 | Lucas | Ohio | 39095 | 1858 | 187 |
144147 | 144147 | 2020-05-14 | Lucas | Ohio | 39095 | 1883 | 195 |
147148 | 147148 | 2020-05-15 | Lucas | Ohio | 39095 | 1921 | 204 |
150155 | 150155 | 2020-05-16 | Lucas | Ohio | 39095 | 1945 | 203 |
153166 | 153166 | 2020-05-17 | Lucas | Ohio | 39095 | 1960 | 204 |
156183 | 156183 | 2020-05-18 | Lucas | Ohio | 39095 | 1986 | 207 |
159203 | 159203 | 2020-05-19 | Lucas | Ohio | 39095 | 1999 | 209 |
162230 | 162230 | 2020-05-20 | Lucas | Ohio | 39095 | 2021 | 214 |
165259 | 165259 | 2020-05-21 | Lucas | Ohio | 39095 | 2056 | 219 |
168295 | 168295 | 2020-05-22 | Lucas | Ohio | 39095 | 2071 | 218 |
171334 | 171334 | 2020-05-23 | Lucas | Ohio | 39095 | 2087 | 228 |
174376 | 174376 | 2020-05-24 | Lucas | Ohio | 39095 | 2107 | 229 |
177420 | 177420 | 2020-05-25 | Lucas | Ohio | 39095 | 2126 | 229 |
180463 | 180463 | 2020-05-26 | Lucas | Ohio | 39095 | 2152 | 229 |
183512 | 183512 | 2020-05-27 | Lucas | Ohio | 39095 | 2162 | 233 |
186569 | 186569 | 2020-05-28 | Lucas | Ohio | 39095 | 2178 | 240 |
189629 | 189629 | 2020-05-29 | Lucas | Ohio | 39095 | 2202 | 240 |
192693 | 192693 | 2020-05-30 | Lucas | Ohio | 39095 | 2241 | 242 |
195763 | 195763 | 2020-05-31 | Lucas | Ohio | 39095 | 2267 | 242 |
198836 | 198836 | 2020-06-01 | Lucas | Ohio | 39095 | 2277 | 248 |
201911 | 201911 | 2020-06-02 | Lucas | Ohio | 39095 | 2282 | 252 |
204988 | 204988 | 2020-06-03 | Lucas | Ohio | 39095 | 2296 | 256 |
208069 | 208069 | 2020-06-04 | Lucas | Ohio | 39095 | 2313 | 263 |
211151 | 211151 | 2020-06-05 | Lucas | Ohio | 39095 | 2329 | 263 |
214237 | 214237 | 2020-06-06 | Lucas | Ohio | 39095 | 2340 | 265 |
217327 | 217327 | 2020-06-07 | Lucas | Ohio | 39095 | 2348 | 265 |
220419 | 220419 | 2020-06-08 | Lucas | Ohio | 39095 | 2354 | 266 |
223514 | 223514 | 2020-06-09 | Lucas | Ohio | 39095 | 2372 | 267 |
226614 | 226614 | 2020-06-10 | Lucas | Ohio | 39095 | 2390 | 270 |
229718 | 229718 | 2020-06-11 | Lucas | Ohio | 39095 | 2394 | 272 |
232823 | 232823 | 2020-06-12 | Lucas | Ohio | 39095 | 2411 | 272 |
235928 | 235928 | 2020-06-13 | Lucas | Ohio | 39095 | 2419 | 280 |
239036 | 239036 | 2020-06-14 | Lucas | Ohio | 39095 | 2428 | 280 |
242145 | 242145 | 2020-06-15 | Lucas | Ohio | 39095 | 2457 | 282 |
245257 | 245257 | 2020-06-16 | Lucas | Ohio | 39095 | 2460 | 286 |
248370 | 248370 | 2020-06-17 | Lucas | Ohio | 39095 | 2462 | 289 |
251485 | 251485 | 2020-06-18 | Lucas | Ohio | 39095 | 2468 | 291 |
254600 | 254600 | 2020-06-19 | Lucas | Ohio | 39095 | 2478 | 293 |
257725 | 257725 | 2020-06-20 | Lucas | Ohio | 39095 | 2483 | 294 |
260852 | 260852 | 2020-06-21 | Lucas | Ohio | 39095 | 2490 | 294 |
263980 | 263980 | 2020-06-22 | Lucas | Ohio | 39095 | 2511 | 294 |
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);