ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 39139 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536545 | 536545 | 2020-09-15 | Richland | Ohio | 39139 | 755 | 18 |
533309 | 533309 | 2020-09-14 | Richland | Ohio | 39139 | 752 | 18 |
530074 | 530074 | 2020-09-13 | Richland | Ohio | 39139 | 745 | 18 |
526837 | 526837 | 2020-09-12 | Richland | Ohio | 39139 | 741 | 18 |
523601 | 523601 | 2020-09-11 | Richland | Ohio | 39139 | 736 | 18 |
520365 | 520365 | 2020-09-10 | Richland | Ohio | 39139 | 731 | 18 |
517129 | 517129 | 2020-09-09 | Richland | Ohio | 39139 | 730 | 18 |
513894 | 513894 | 2020-09-08 | Richland | Ohio | 39139 | 725 | 18 |
510661 | 510661 | 2020-09-07 | Richland | Ohio | 39139 | 724 | 18 |
507428 | 507428 | 2020-09-06 | Richland | Ohio | 39139 | 722 | 18 |
504196 | 504196 | 2020-09-05 | Richland | Ohio | 39139 | 720 | 18 |
500962 | 500962 | 2020-09-04 | Richland | Ohio | 39139 | 714 | 18 |
497728 | 497728 | 2020-09-03 | Richland | Ohio | 39139 | 711 | 17 |
494495 | 494495 | 2020-09-02 | Richland | Ohio | 39139 | 707 | 17 |
491261 | 491261 | 2020-09-01 | Richland | Ohio | 39139 | 703 | 17 |
488028 | 488028 | 2020-08-31 | Richland | Ohio | 39139 | 698 | 17 |
484795 | 484795 | 2020-08-30 | Richland | Ohio | 39139 | 696 | 17 |
481560 | 481560 | 2020-08-29 | Richland | Ohio | 39139 | 695 | 17 |
478326 | 478326 | 2020-08-28 | Richland | Ohio | 39139 | 693 | 17 |
475093 | 475093 | 2020-08-27 | Richland | Ohio | 39139 | 689 | 17 |
471859 | 471859 | 2020-08-26 | Richland | Ohio | 39139 | 687 | 17 |
468627 | 468627 | 2020-08-25 | Richland | Ohio | 39139 | 679 | 16 |
465399 | 465399 | 2020-08-24 | Richland | Ohio | 39139 | 674 | 16 |
462170 | 462170 | 2020-08-23 | Richland | Ohio | 39139 | 670 | 16 |
458942 | 458942 | 2020-08-22 | Richland | Ohio | 39139 | 667 | 16 |
455714 | 455714 | 2020-08-21 | Richland | Ohio | 39139 | 665 | 15 |
452486 | 452486 | 2020-08-20 | Richland | Ohio | 39139 | 661 | 15 |
449258 | 449258 | 2020-08-19 | Richland | Ohio | 39139 | 659 | 15 |
446030 | 446030 | 2020-08-18 | Richland | Ohio | 39139 | 657 | 14 |
442804 | 442804 | 2020-08-17 | Richland | Ohio | 39139 | 652 | 12 |
439577 | 439577 | 2020-08-16 | Richland | Ohio | 39139 | 644 | 12 |
436352 | 436352 | 2020-08-15 | Richland | Ohio | 39139 | 640 | 12 |
433126 | 433126 | 2020-08-14 | Richland | Ohio | 39139 | 635 | 12 |
429900 | 429900 | 2020-08-13 | Richland | Ohio | 39139 | 626 | 12 |
426675 | 426675 | 2020-08-12 | Richland | Ohio | 39139 | 619 | 12 |
423452 | 423452 | 2020-08-11 | Richland | Ohio | 39139 | 614 | 12 |
420229 | 420229 | 2020-08-10 | Richland | Ohio | 39139 | 608 | 12 |
417009 | 417009 | 2020-08-09 | Richland | Ohio | 39139 | 604 | 12 |
413788 | 413788 | 2020-08-08 | Richland | Ohio | 39139 | 600 | 12 |
410568 | 410568 | 2020-08-07 | Richland | Ohio | 39139 | 596 | 11 |
407348 | 407348 | 2020-08-06 | Richland | Ohio | 39139 | 589 | 11 |
404129 | 404129 | 2020-08-05 | Richland | Ohio | 39139 | 559 | 11 |
400911 | 400911 | 2020-08-04 | Richland | Ohio | 39139 | 547 | 12 |
397696 | 397696 | 2020-08-03 | Richland | Ohio | 39139 | 540 | 12 |
394479 | 394479 | 2020-08-02 | Richland | Ohio | 39139 | 536 | 10 |
391263 | 391263 | 2020-08-01 | Richland | Ohio | 39139 | 531 | 10 |
388046 | 388046 | 2020-07-31 | Richland | Ohio | 39139 | 525 | 10 |
384829 | 384829 | 2020-07-30 | Richland | Ohio | 39139 | 509 | 10 |
381611 | 381611 | 2020-07-29 | Richland | Ohio | 39139 | 496 | 10 |
378394 | 378394 | 2020-07-28 | Richland | Ohio | 39139 | 491 | 9 |
375177 | 375177 | 2020-07-27 | Richland | Ohio | 39139 | 487 | 8 |
371965 | 371965 | 2020-07-26 | Richland | Ohio | 39139 | 480 | 8 |
368753 | 368753 | 2020-07-25 | Richland | Ohio | 39139 | 477 | 8 |
365544 | 365544 | 2020-07-24 | Richland | Ohio | 39139 | 473 | 8 |
362338 | 362338 | 2020-07-23 | Richland | Ohio | 39139 | 465 | 8 |
359132 | 359132 | 2020-07-22 | Richland | Ohio | 39139 | 461 | 8 |
355928 | 355928 | 2020-07-21 | Richland | Ohio | 39139 | 450 | 8 |
352725 | 352725 | 2020-07-20 | Richland | Ohio | 39139 | 441 | 8 |
349522 | 349522 | 2020-07-19 | Richland | Ohio | 39139 | 428 | 8 |
346321 | 346321 | 2020-07-18 | Richland | Ohio | 39139 | 425 | 8 |
343122 | 343122 | 2020-07-17 | Richland | Ohio | 39139 | 422 | 7 |
339924 | 339924 | 2020-07-16 | Richland | Ohio | 39139 | 412 | 7 |
336728 | 336728 | 2020-07-15 | Richland | Ohio | 39139 | 403 | 7 |
333534 | 333534 | 2020-07-14 | Richland | Ohio | 39139 | 392 | 6 |
330342 | 330342 | 2020-07-13 | Richland | Ohio | 39139 | 390 | 6 |
327155 | 327155 | 2020-07-12 | Richland | Ohio | 39139 | 378 | 6 |
323970 | 323970 | 2020-07-11 | Richland | Ohio | 39139 | 371 | 5 |
320790 | 320790 | 2020-07-10 | Richland | Ohio | 39139 | 363 | 5 |
317613 | 317613 | 2020-07-09 | Richland | Ohio | 39139 | 359 | 5 |
314440 | 314440 | 2020-07-08 | Richland | Ohio | 39139 | 351 | 5 |
311268 | 311268 | 2020-07-07 | Richland | Ohio | 39139 | 347 | 5 |
308099 | 308099 | 2020-07-06 | Richland | Ohio | 39139 | 345 | 5 |
304932 | 304932 | 2020-07-05 | Richland | Ohio | 39139 | 337 | 5 |
301769 | 301769 | 2020-07-04 | Richland | Ohio | 39139 | 332 | 5 |
298606 | 298606 | 2020-07-03 | Richland | Ohio | 39139 | 325 | 5 |
295446 | 295446 | 2020-07-02 | Richland | Ohio | 39139 | 318 | 5 |
292291 | 292291 | 2020-07-01 | Richland | Ohio | 39139 | 318 | 5 |
289139 | 289139 | 2020-06-30 | Richland | Ohio | 39139 | 314 | 5 |
285989 | 285989 | 2020-06-29 | Richland | Ohio | 39139 | 312 | 4 |
282844 | 282844 | 2020-06-28 | Richland | Ohio | 39139 | 310 | 4 |
279698 | 279698 | 2020-06-27 | Richland | Ohio | 39139 | 306 | 4 |
276550 | 276550 | 2020-06-26 | Richland | Ohio | 39139 | 300 | 4 |
273403 | 273403 | 2020-06-25 | Richland | Ohio | 39139 | 296 | 4 |
270264 | 270264 | 2020-06-24 | Richland | Ohio | 39139 | 285 | 4 |
267130 | 267130 | 2020-06-23 | Richland | Ohio | 39139 | 280 | 4 |
264002 | 264002 | 2020-06-22 | Richland | Ohio | 39139 | 277 | 4 |
260874 | 260874 | 2020-06-21 | Richland | Ohio | 39139 | 271 | 4 |
257747 | 257747 | 2020-06-20 | Richland | Ohio | 39139 | 269 | 4 |
254622 | 254622 | 2020-06-19 | Richland | Ohio | 39139 | 266 | 4 |
251507 | 251507 | 2020-06-18 | Richland | Ohio | 39139 | 260 | 4 |
248392 | 248392 | 2020-06-17 | Richland | Ohio | 39139 | 257 | 4 |
245279 | 245279 | 2020-06-16 | Richland | Ohio | 39139 | 253 | 4 |
242167 | 242167 | 2020-06-15 | Richland | Ohio | 39139 | 252 | 4 |
239058 | 239058 | 2020-06-14 | Richland | Ohio | 39139 | 249 | 4 |
235950 | 235950 | 2020-06-13 | Richland | Ohio | 39139 | 246 | 4 |
232845 | 232845 | 2020-06-12 | Richland | Ohio | 39139 | 242 | 4 |
229740 | 229740 | 2020-06-11 | Richland | Ohio | 39139 | 238 | 4 |
226636 | 226636 | 2020-06-10 | Richland | Ohio | 39139 | 234 | 4 |
223536 | 223536 | 2020-06-09 | Richland | Ohio | 39139 | 232 | 4 |
220441 | 220441 | 2020-06-08 | Richland | Ohio | 39139 | 232 | 4 |
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);