ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Hamilton" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536506 | 536506 | 2020-09-15 | Hamilton | Ohio | 39061 | 12368 | 302 |
533270 | 533270 | 2020-09-14 | Hamilton | Ohio | 39061 | 12306 | 292 |
530035 | 530035 | 2020-09-13 | Hamilton | Ohio | 39061 | 12208 | 292 |
526798 | 526798 | 2020-09-12 | Hamilton | Ohio | 39061 | 12171 | 292 |
523562 | 523562 | 2020-09-11 | Hamilton | Ohio | 39061 | 12067 | 291 |
520326 | 520326 | 2020-09-10 | Hamilton | Ohio | 39061 | 11970 | 288 |
517090 | 517090 | 2020-09-09 | Hamilton | Ohio | 39061 | 11896 | 288 |
513855 | 513855 | 2020-09-08 | Hamilton | Ohio | 39061 | 11826 | 288 |
510622 | 510622 | 2020-09-07 | Hamilton | Ohio | 39061 | 11753 | 288 |
507389 | 507389 | 2020-09-06 | Hamilton | Ohio | 39061 | 11713 | 289 |
504157 | 504157 | 2020-09-05 | Hamilton | Ohio | 39061 | 11663 | 289 |
500923 | 500923 | 2020-09-04 | Hamilton | Ohio | 39061 | 11580 | 289 |
497689 | 497689 | 2020-09-03 | Hamilton | Ohio | 39061 | 11494 | 289 |
494456 | 494456 | 2020-09-02 | Hamilton | Ohio | 39061 | 11356 | 287 |
491222 | 491222 | 2020-09-01 | Hamilton | Ohio | 39061 | 11285 | 287 |
487989 | 487989 | 2020-08-31 | Hamilton | Ohio | 39061 | 11174 | 286 |
484756 | 484756 | 2020-08-30 | Hamilton | Ohio | 39061 | 11102 | 286 |
481521 | 481521 | 2020-08-29 | Hamilton | Ohio | 39061 | 11041 | 286 |
478287 | 478287 | 2020-08-28 | Hamilton | Ohio | 39061 | 10903 | 285 |
475054 | 475054 | 2020-08-27 | Hamilton | Ohio | 39061 | 10836 | 284 |
471820 | 471820 | 2020-08-26 | Hamilton | Ohio | 39061 | 10727 | 281 |
468588 | 468588 | 2020-08-25 | Hamilton | Ohio | 39061 | 10663 | 281 |
465360 | 465360 | 2020-08-24 | Hamilton | Ohio | 39061 | 10606 | 281 |
462131 | 462131 | 2020-08-23 | Hamilton | Ohio | 39061 | 10533 | 281 |
458903 | 458903 | 2020-08-22 | Hamilton | Ohio | 39061 | 10503 | 279 |
455675 | 455675 | 2020-08-21 | Hamilton | Ohio | 39061 | 10437 | 276 |
452447 | 452447 | 2020-08-20 | Hamilton | Ohio | 39061 | 10362 | 274 |
449219 | 449219 | 2020-08-19 | Hamilton | Ohio | 39061 | 10314 | 272 |
445991 | 445991 | 2020-08-18 | Hamilton | Ohio | 39061 | 10259 | 269 |
442765 | 442765 | 2020-08-17 | Hamilton | Ohio | 39061 | 10184 | 270 |
439538 | 439538 | 2020-08-16 | Hamilton | Ohio | 39061 | 10142 | 269 |
436313 | 436313 | 2020-08-15 | Hamilton | Ohio | 39061 | 10101 | 269 |
433087 | 433087 | 2020-08-14 | Hamilton | Ohio | 39061 | 10001 | 262 |
429861 | 429861 | 2020-08-13 | Hamilton | Ohio | 39061 | 9917 | 260 |
426636 | 426636 | 2020-08-12 | Hamilton | Ohio | 39061 | 9844 | 259 |
423413 | 423413 | 2020-08-11 | Hamilton | Ohio | 39061 | 9766 | 257 |
420190 | 420190 | 2020-08-10 | Hamilton | Ohio | 39061 | 9689 | 255 |
416970 | 416970 | 2020-08-09 | Hamilton | Ohio | 39061 | 9643 | 255 |
413749 | 413749 | 2020-08-08 | Hamilton | Ohio | 39061 | 9583 | 255 |
410529 | 410529 | 2020-08-07 | Hamilton | Ohio | 39061 | 9493 | 253 |
407309 | 407309 | 2020-08-06 | Hamilton | Ohio | 39061 | 9374 | 252 |
404090 | 404090 | 2020-08-05 | Hamilton | Ohio | 39061 | 9297 | 249 |
400872 | 400872 | 2020-08-04 | Hamilton | Ohio | 39061 | 9248 | 248 |
397657 | 397657 | 2020-08-03 | Hamilton | Ohio | 39061 | 9160 | 248 |
394440 | 394440 | 2020-08-02 | Hamilton | Ohio | 39061 | 9110 | 247 |
391224 | 391224 | 2020-08-01 | Hamilton | Ohio | 39061 | 9048 | 246 |
388007 | 388007 | 2020-07-31 | Hamilton | Ohio | 39061 | 8977 | 245 |
384790 | 384790 | 2020-07-30 | Hamilton | Ohio | 39061 | 8872 | 241 |
381572 | 381572 | 2020-07-29 | Hamilton | Ohio | 39061 | 8702 | 240 |
378355 | 378355 | 2020-07-28 | Hamilton | Ohio | 39061 | 8633 | 233 |
375138 | 375138 | 2020-07-27 | Hamilton | Ohio | 39061 | 8591 | 233 |
371926 | 371926 | 2020-07-26 | Hamilton | Ohio | 39061 | 8497 | 225 |
368714 | 368714 | 2020-07-25 | Hamilton | Ohio | 39061 | 8436 | 224 |
365505 | 365505 | 2020-07-24 | Hamilton | Ohio | 39061 | 8325 | 224 |
362299 | 362299 | 2020-07-23 | Hamilton | Ohio | 39061 | 8203 | 224 |
359093 | 359093 | 2020-07-22 | Hamilton | Ohio | 39061 | 8071 | 220 |
355889 | 355889 | 2020-07-21 | Hamilton | Ohio | 39061 | 8020 | 219 |
352686 | 352686 | 2020-07-20 | Hamilton | Ohio | 39061 | 7923 | 219 |
349483 | 349483 | 2020-07-19 | Hamilton | Ohio | 39061 | 7828 | 218 |
346282 | 346282 | 2020-07-18 | Hamilton | Ohio | 39061 | 7703 | 213 |
343083 | 343083 | 2020-07-17 | Hamilton | Ohio | 39061 | 7586 | 212 |
339885 | 339885 | 2020-07-16 | Hamilton | Ohio | 39061 | 7415 | 211 |
336689 | 336689 | 2020-07-15 | Hamilton | Ohio | 39061 | 7279 | 209 |
333495 | 333495 | 2020-07-14 | Hamilton | Ohio | 39061 | 7179 | 208 |
330303 | 330303 | 2020-07-13 | Hamilton | Ohio | 39061 | 7046 | 208 |
327116 | 327116 | 2020-07-12 | Hamilton | Ohio | 39061 | 6950 | 208 |
323931 | 323931 | 2020-07-11 | Hamilton | Ohio | 39061 | 6781 | 207 |
320751 | 320751 | 2020-07-10 | Hamilton | Ohio | 39061 | 6563 | 207 |
317574 | 317574 | 2020-07-09 | Hamilton | Ohio | 39061 | 6396 | 206 |
314401 | 314401 | 2020-07-08 | Hamilton | Ohio | 39061 | 6287 | 206 |
311229 | 311229 | 2020-07-07 | Hamilton | Ohio | 39061 | 6158 | 204 |
308060 | 308060 | 2020-07-06 | Hamilton | Ohio | 39061 | 6019 | 198 |
304893 | 304893 | 2020-07-05 | Hamilton | Ohio | 39061 | 5924 | 197 |
301730 | 301730 | 2020-07-04 | Hamilton | Ohio | 39061 | 5770 | 197 |
298567 | 298567 | 2020-07-03 | Hamilton | Ohio | 39061 | 5605 | 197 |
295407 | 295407 | 2020-07-02 | Hamilton | Ohio | 39061 | 5224 | 198 |
292252 | 292252 | 2020-07-01 | Hamilton | Ohio | 39061 | 5224 | 198 |
289100 | 289100 | 2020-06-30 | Hamilton | Ohio | 39061 | 5010 | 198 |
285950 | 285950 | 2020-06-29 | Hamilton | Ohio | 39061 | 4922 | 191 |
282805 | 282805 | 2020-06-28 | Hamilton | Ohio | 39061 | 4794 | 191 |
279659 | 279659 | 2020-06-27 | Hamilton | Ohio | 39061 | 4661 | 191 |
276511 | 276511 | 2020-06-26 | Hamilton | Ohio | 39061 | 4491 | 191 |
273364 | 273364 | 2020-06-25 | Hamilton | Ohio | 39061 | 4337 | 191 |
270225 | 270225 | 2020-06-24 | Hamilton | Ohio | 39061 | 4189 | 189 |
267091 | 267091 | 2020-06-23 | Hamilton | Ohio | 39061 | 4098 | 188 |
263963 | 263963 | 2020-06-22 | Hamilton | Ohio | 39061 | 4020 | 187 |
260835 | 260835 | 2020-06-21 | Hamilton | Ohio | 39061 | 3829 | 186 |
257708 | 257708 | 2020-06-20 | Hamilton | Ohio | 39061 | 3744 | 186 |
254583 | 254583 | 2020-06-19 | Hamilton | Ohio | 39061 | 3634 | 184 |
251468 | 251468 | 2020-06-18 | Hamilton | Ohio | 39061 | 3508 | 181 |
248353 | 248353 | 2020-06-17 | Hamilton | Ohio | 39061 | 3374 | 181 |
245240 | 245240 | 2020-06-16 | Hamilton | Ohio | 39061 | 3316 | 181 |
242128 | 242128 | 2020-06-15 | Hamilton | Ohio | 39061 | 3250 | 179 |
239019 | 239019 | 2020-06-14 | Hamilton | Ohio | 39061 | 3185 | 179 |
235911 | 235911 | 2020-06-13 | Hamilton | Ohio | 39061 | 3130 | 179 |
232806 | 232806 | 2020-06-12 | Hamilton | Ohio | 39061 | 3078 | 178 |
229701 | 229701 | 2020-06-11 | Hamilton | Ohio | 39061 | 3011 | 177 |
226597 | 226597 | 2020-06-10 | Hamilton | Ohio | 39061 | 2975 | 174 |
223497 | 223497 | 2020-06-09 | Hamilton | Ohio | 39061 | 2918 | 173 |
220402 | 220402 | 2020-06-08 | Hamilton | Ohio | 39061 | 2891 | 172 |
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);