ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 39077 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536514 | 536514 | 2020-09-15 | Huron | Ohio | 39077 | 512 | 7 |
533278 | 533278 | 2020-09-14 | Huron | Ohio | 39077 | 509 | 7 |
530043 | 530043 | 2020-09-13 | Huron | Ohio | 39077 | 505 | 7 |
526806 | 526806 | 2020-09-12 | Huron | Ohio | 39077 | 504 | 7 |
523570 | 523570 | 2020-09-11 | Huron | Ohio | 39077 | 502 | 7 |
520334 | 520334 | 2020-09-10 | Huron | Ohio | 39077 | 499 | 6 |
517098 | 517098 | 2020-09-09 | Huron | Ohio | 39077 | 498 | 6 |
513863 | 513863 | 2020-09-08 | Huron | Ohio | 39077 | 496 | 6 |
510630 | 510630 | 2020-09-07 | Huron | Ohio | 39077 | 495 | 6 |
507397 | 507397 | 2020-09-06 | Huron | Ohio | 39077 | 493 | 6 |
504165 | 504165 | 2020-09-05 | Huron | Ohio | 39077 | 493 | 6 |
500931 | 500931 | 2020-09-04 | Huron | Ohio | 39077 | 487 | 6 |
497697 | 497697 | 2020-09-03 | Huron | Ohio | 39077 | 483 | 6 |
494464 | 494464 | 2020-09-02 | Huron | Ohio | 39077 | 481 | 6 |
491230 | 491230 | 2020-09-01 | Huron | Ohio | 39077 | 479 | 6 |
487997 | 487997 | 2020-08-31 | Huron | Ohio | 39077 | 475 | 6 |
484764 | 484764 | 2020-08-30 | Huron | Ohio | 39077 | 470 | 6 |
481529 | 481529 | 2020-08-29 | Huron | Ohio | 39077 | 469 | 6 |
478295 | 478295 | 2020-08-28 | Huron | Ohio | 39077 | 468 | 6 |
475062 | 475062 | 2020-08-27 | Huron | Ohio | 39077 | 465 | 6 |
471828 | 471828 | 2020-08-26 | Huron | Ohio | 39077 | 462 | 6 |
468596 | 468596 | 2020-08-25 | Huron | Ohio | 39077 | 462 | 6 |
465368 | 465368 | 2020-08-24 | Huron | Ohio | 39077 | 462 | 6 |
462139 | 462139 | 2020-08-23 | Huron | Ohio | 39077 | 462 | 6 |
458911 | 458911 | 2020-08-22 | Huron | Ohio | 39077 | 462 | 6 |
455683 | 455683 | 2020-08-21 | Huron | Ohio | 39077 | 459 | 6 |
452455 | 452455 | 2020-08-20 | Huron | Ohio | 39077 | 425 | 6 |
449227 | 449227 | 2020-08-19 | Huron | Ohio | 39077 | 425 | 6 |
445999 | 445999 | 2020-08-18 | Huron | Ohio | 39077 | 423 | 5 |
442773 | 442773 | 2020-08-17 | Huron | Ohio | 39077 | 420 | 5 |
439546 | 439546 | 2020-08-16 | Huron | Ohio | 39077 | 418 | 5 |
436321 | 436321 | 2020-08-15 | Huron | Ohio | 39077 | 418 | 5 |
433095 | 433095 | 2020-08-14 | Huron | Ohio | 39077 | 414 | 5 |
429869 | 429869 | 2020-08-13 | Huron | Ohio | 39077 | 413 | 5 |
426644 | 426644 | 2020-08-12 | Huron | Ohio | 39077 | 411 | 5 |
423421 | 423421 | 2020-08-11 | Huron | Ohio | 39077 | 404 | 5 |
420198 | 420198 | 2020-08-10 | Huron | Ohio | 39077 | 401 | 5 |
416978 | 416978 | 2020-08-09 | Huron | Ohio | 39077 | 396 | 5 |
413757 | 413757 | 2020-08-08 | Huron | Ohio | 39077 | 395 | 5 |
410537 | 410537 | 2020-08-07 | Huron | Ohio | 39077 | 393 | 5 |
407317 | 407317 | 2020-08-06 | Huron | Ohio | 39077 | 388 | 5 |
404098 | 404098 | 2020-08-05 | Huron | Ohio | 39077 | 383 | 5 |
400880 | 400880 | 2020-08-04 | Huron | Ohio | 39077 | 378 | 4 |
397665 | 397665 | 2020-08-03 | Huron | Ohio | 39077 | 376 | 4 |
394448 | 394448 | 2020-08-02 | Huron | Ohio | 39077 | 371 | 4 |
391232 | 391232 | 2020-08-01 | Huron | Ohio | 39077 | 368 | 4 |
388015 | 388015 | 2020-07-31 | Huron | Ohio | 39077 | 369 | 4 |
384798 | 384798 | 2020-07-30 | Huron | Ohio | 39077 | 359 | 4 |
381580 | 381580 | 2020-07-29 | Huron | Ohio | 39077 | 349 | 3 |
378363 | 378363 | 2020-07-28 | Huron | Ohio | 39077 | 343 | 3 |
375146 | 375146 | 2020-07-27 | Huron | Ohio | 39077 | 334 | 3 |
371934 | 371934 | 2020-07-26 | Huron | Ohio | 39077 | 329 | 3 |
368722 | 368722 | 2020-07-25 | Huron | Ohio | 39077 | 328 | 3 |
365513 | 365513 | 2020-07-24 | Huron | Ohio | 39077 | 320 | 3 |
362307 | 362307 | 2020-07-23 | Huron | Ohio | 39077 | 317 | 3 |
359101 | 359101 | 2020-07-22 | Huron | Ohio | 39077 | 311 | 3 |
355897 | 355897 | 2020-07-21 | Huron | Ohio | 39077 | 309 | 3 |
352694 | 352694 | 2020-07-20 | Huron | Ohio | 39077 | 303 | 3 |
349491 | 349491 | 2020-07-19 | Huron | Ohio | 39077 | 290 | 3 |
346290 | 346290 | 2020-07-18 | Huron | Ohio | 39077 | 284 | 3 |
343091 | 343091 | 2020-07-17 | Huron | Ohio | 39077 | 278 | 3 |
339893 | 339893 | 2020-07-16 | Huron | Ohio | 39077 | 275 | 3 |
336697 | 336697 | 2020-07-15 | Huron | Ohio | 39077 | 271 | 3 |
333503 | 333503 | 2020-07-14 | Huron | Ohio | 39077 | 264 | 3 |
330311 | 330311 | 2020-07-13 | Huron | Ohio | 39077 | 260 | 2 |
327124 | 327124 | 2020-07-12 | Huron | Ohio | 39077 | 247 | 2 |
323939 | 323939 | 2020-07-11 | Huron | Ohio | 39077 | 240 | 2 |
320759 | 320759 | 2020-07-10 | Huron | Ohio | 39077 | 238 | 2 |
317582 | 317582 | 2020-07-09 | Huron | Ohio | 39077 | 234 | 2 |
314409 | 314409 | 2020-07-08 | Huron | Ohio | 39077 | 228 | 2 |
311237 | 311237 | 2020-07-07 | Huron | Ohio | 39077 | 223 | 2 |
308068 | 308068 | 2020-07-06 | Huron | Ohio | 39077 | 220 | 2 |
304901 | 304901 | 2020-07-05 | Huron | Ohio | 39077 | 215 | 2 |
301738 | 301738 | 2020-07-04 | Huron | Ohio | 39077 | 211 | 2 |
298575 | 298575 | 2020-07-03 | Huron | Ohio | 39077 | 199 | 2 |
295415 | 295415 | 2020-07-02 | Huron | Ohio | 39077 | 177 | 2 |
292260 | 292260 | 2020-07-01 | Huron | Ohio | 39077 | 177 | 2 |
289108 | 289108 | 2020-06-30 | Huron | Ohio | 39077 | 170 | 1 |
285958 | 285958 | 2020-06-29 | Huron | Ohio | 39077 | 165 | 1 |
282813 | 282813 | 2020-06-28 | Huron | Ohio | 39077 | 159 | 1 |
279667 | 279667 | 2020-06-27 | Huron | Ohio | 39077 | 153 | 1 |
276519 | 276519 | 2020-06-26 | Huron | Ohio | 39077 | 147 | 1 |
273372 | 273372 | 2020-06-25 | Huron | Ohio | 39077 | 144 | 1 |
270233 | 270233 | 2020-06-24 | Huron | Ohio | 39077 | 129 | 1 |
267099 | 267099 | 2020-06-23 | Huron | Ohio | 39077 | 127 | 1 |
263971 | 263971 | 2020-06-22 | Huron | Ohio | 39077 | 122 | 1 |
260843 | 260843 | 2020-06-21 | Huron | Ohio | 39077 | 110 | 1 |
257716 | 257716 | 2020-06-20 | Huron | Ohio | 39077 | 97 | 1 |
254591 | 254591 | 2020-06-19 | Huron | Ohio | 39077 | 96 | 1 |
251476 | 251476 | 2020-06-18 | Huron | Ohio | 39077 | 95 | 1 |
248361 | 248361 | 2020-06-17 | Huron | Ohio | 39077 | 81 | 1 |
245248 | 245248 | 2020-06-16 | Huron | Ohio | 39077 | 79 | 1 |
242136 | 242136 | 2020-06-15 | Huron | Ohio | 39077 | 77 | 1 |
239027 | 239027 | 2020-06-14 | Huron | Ohio | 39077 | 77 | 1 |
235919 | 235919 | 2020-06-13 | Huron | Ohio | 39077 | 74 | 1 |
232814 | 232814 | 2020-06-12 | Huron | Ohio | 39077 | 72 | 1 |
229709 | 229709 | 2020-06-11 | Huron | Ohio | 39077 | 71 | 1 |
226605 | 226605 | 2020-06-10 | Huron | Ohio | 39077 | 64 | 1 |
223505 | 223505 | 2020-06-09 | Huron | Ohio | 39077 | 64 | 1 |
220410 | 220410 | 2020-06-08 | Huron | Ohio | 39077 | 63 | 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);