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 |
---|---|---|---|---|---|---|---|
536493 | 536493 | 2020-09-15 | Cuyahoga | Ohio | 39035 | 16789 | 631 |
533257 | 533257 | 2020-09-14 | Cuyahoga | Ohio | 39035 | 16747 | 622 |
530022 | 530022 | 2020-09-13 | Cuyahoga | Ohio | 39035 | 16698 | 622 |
526785 | 526785 | 2020-09-12 | Cuyahoga | Ohio | 39035 | 16630 | 621 |
523549 | 523549 | 2020-09-11 | Cuyahoga | Ohio | 39035 | 16544 | 621 |
520313 | 520313 | 2020-09-10 | Cuyahoga | Ohio | 39035 | 16479 | 613 |
517077 | 517077 | 2020-09-09 | Cuyahoga | Ohio | 39035 | 16407 | 608 |
513842 | 513842 | 2020-09-08 | Cuyahoga | Ohio | 39035 | 16360 | 605 |
510609 | 510609 | 2020-09-07 | Cuyahoga | Ohio | 39035 | 16317 | 603 |
507376 | 507376 | 2020-09-06 | Cuyahoga | Ohio | 39035 | 16249 | 599 |
504144 | 504144 | 2020-09-05 | Cuyahoga | Ohio | 39035 | 16190 | 599 |
500910 | 500910 | 2020-09-04 | Cuyahoga | Ohio | 39035 | 16066 | 599 |
497676 | 497676 | 2020-09-03 | Cuyahoga | Ohio | 39035 | 15965 | 591 |
494443 | 494443 | 2020-09-02 | Cuyahoga | Ohio | 39035 | 15925 | 582 |
491209 | 491209 | 2020-09-01 | Cuyahoga | Ohio | 39035 | 15804 | 581 |
487976 | 487976 | 2020-08-31 | Cuyahoga | Ohio | 39035 | 15714 | 575 |
484743 | 484743 | 2020-08-30 | Cuyahoga | Ohio | 39035 | 15624 | 574 |
481508 | 481508 | 2020-08-29 | Cuyahoga | Ohio | 39035 | 15544 | 574 |
478274 | 478274 | 2020-08-28 | Cuyahoga | Ohio | 39035 | 15452 | 571 |
475041 | 475041 | 2020-08-27 | Cuyahoga | Ohio | 39035 | 15316 | 570 |
471807 | 471807 | 2020-08-26 | Cuyahoga | Ohio | 39035 | 15192 | 565 |
468575 | 468575 | 2020-08-25 | Cuyahoga | Ohio | 39035 | 15088 | 552 |
465347 | 465347 | 2020-08-24 | Cuyahoga | Ohio | 39035 | 15032 | 552 |
462118 | 462118 | 2020-08-23 | Cuyahoga | Ohio | 39035 | 14955 | 552 |
458890 | 458890 | 2020-08-22 | Cuyahoga | Ohio | 39035 | 14881 | 552 |
455662 | 455662 | 2020-08-21 | Cuyahoga | Ohio | 39035 | 14774 | 552 |
452434 | 452434 | 2020-08-20 | Cuyahoga | Ohio | 39035 | 14673 | 544 |
449206 | 449206 | 2020-08-19 | Cuyahoga | Ohio | 39035 | 14585 | 542 |
445978 | 445978 | 2020-08-18 | Cuyahoga | Ohio | 39035 | 14487 | 541 |
442752 | 442752 | 2020-08-17 | Cuyahoga | Ohio | 39035 | 14418 | 528 |
439525 | 439525 | 2020-08-16 | Cuyahoga | Ohio | 39035 | 14335 | 528 |
436300 | 436300 | 2020-08-15 | Cuyahoga | Ohio | 39035 | 14278 | 529 |
433074 | 433074 | 2020-08-14 | Cuyahoga | Ohio | 39035 | 14120 | 523 |
429848 | 429848 | 2020-08-13 | Cuyahoga | Ohio | 39035 | 13999 | 519 |
426623 | 426623 | 2020-08-12 | Cuyahoga | Ohio | 39035 | 13869 | 512 |
423400 | 423400 | 2020-08-11 | Cuyahoga | Ohio | 39035 | 13734 | 505 |
420177 | 420177 | 2020-08-10 | Cuyahoga | Ohio | 39035 | 13640 | 500 |
416957 | 416957 | 2020-08-09 | Cuyahoga | Ohio | 39035 | 13514 | 499 |
413736 | 413736 | 2020-08-08 | Cuyahoga | Ohio | 39035 | 13414 | 499 |
410516 | 410516 | 2020-08-07 | Cuyahoga | Ohio | 39035 | 13269 | 498 |
407296 | 407296 | 2020-08-06 | Cuyahoga | Ohio | 39035 | 13141 | 491 |
404077 | 404077 | 2020-08-05 | Cuyahoga | Ohio | 39035 | 13011 | 487 |
400859 | 400859 | 2020-08-04 | Cuyahoga | Ohio | 39035 | 12881 | 482 |
397644 | 397644 | 2020-08-03 | Cuyahoga | Ohio | 39035 | 12753 | 477 |
394427 | 394427 | 2020-08-02 | Cuyahoga | Ohio | 39035 | 12646 | 477 |
391211 | 391211 | 2020-08-01 | Cuyahoga | Ohio | 39035 | 12518 | 475 |
387994 | 387994 | 2020-07-31 | Cuyahoga | Ohio | 39035 | 12399 | 470 |
384777 | 384777 | 2020-07-30 | Cuyahoga | Ohio | 39035 | 12212 | 465 |
381559 | 381559 | 2020-07-29 | Cuyahoga | Ohio | 39035 | 12088 | 465 |
378342 | 378342 | 2020-07-28 | Cuyahoga | Ohio | 39035 | 11938 | 460 |
375125 | 375125 | 2020-07-27 | Cuyahoga | Ohio | 39035 | 11788 | 454 |
371913 | 371913 | 2020-07-26 | Cuyahoga | Ohio | 39035 | 11697 | 449 |
368701 | 368701 | 2020-07-25 | Cuyahoga | Ohio | 39035 | 11584 | 449 |
365492 | 365492 | 2020-07-24 | Cuyahoga | Ohio | 39035 | 11404 | 450 |
362286 | 362286 | 2020-07-23 | Cuyahoga | Ohio | 39035 | 11206 | 435 |
359080 | 359080 | 2020-07-22 | Cuyahoga | Ohio | 39035 | 11015 | 432 |
355876 | 355876 | 2020-07-21 | Cuyahoga | Ohio | 39035 | 10828 | 431 |
352673 | 352673 | 2020-07-20 | Cuyahoga | Ohio | 39035 | 10713 | 424 |
349470 | 349470 | 2020-07-19 | Cuyahoga | Ohio | 39035 | 10553 | 421 |
346269 | 346269 | 2020-07-18 | Cuyahoga | Ohio | 39035 | 10438 | 414 |
343070 | 343070 | 2020-07-17 | Cuyahoga | Ohio | 39035 | 10215 | 407 |
339872 | 339872 | 2020-07-16 | Cuyahoga | Ohio | 39035 | 9985 | 406 |
336676 | 336676 | 2020-07-15 | Cuyahoga | Ohio | 39035 | 9784 | 402 |
333482 | 333482 | 2020-07-14 | Cuyahoga | Ohio | 39035 | 9509 | 400 |
330290 | 330290 | 2020-07-13 | Cuyahoga | Ohio | 39035 | 9359 | 399 |
327103 | 327103 | 2020-07-12 | Cuyahoga | Ohio | 39035 | 9208 | 399 |
323918 | 323918 | 2020-07-11 | Cuyahoga | Ohio | 39035 | 8979 | 393 |
320738 | 320738 | 2020-07-10 | Cuyahoga | Ohio | 39035 | 8786 | 393 |
317561 | 317561 | 2020-07-09 | Cuyahoga | Ohio | 39035 | 8518 | 383 |
314388 | 314388 | 2020-07-08 | Cuyahoga | Ohio | 39035 | 8277 | 383 |
311216 | 311216 | 2020-07-07 | Cuyahoga | Ohio | 39035 | 8048 | 379 |
308047 | 308047 | 2020-07-06 | Cuyahoga | Ohio | 39035 | 7883 | 373 |
304880 | 304880 | 2020-07-05 | Cuyahoga | Ohio | 39035 | 7724 | 373 |
301717 | 301717 | 2020-07-04 | Cuyahoga | Ohio | 39035 | 7571 | 372 |
298554 | 298554 | 2020-07-03 | Cuyahoga | Ohio | 39035 | 7392 | 372 |
295394 | 295394 | 2020-07-02 | Cuyahoga | Ohio | 39035 | 7013 | 366 |
292239 | 292239 | 2020-07-01 | Cuyahoga | Ohio | 39035 | 7013 | 366 |
289087 | 289087 | 2020-06-30 | Cuyahoga | Ohio | 39035 | 6831 | 364 |
285937 | 285937 | 2020-06-29 | Cuyahoga | Ohio | 39035 | 6694 | 352 |
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 |
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);