ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 39043 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
285941 | 285941 | 2020-06-29 | Erie | Ohio | 39043 | 226 | 22 |
289091 | 289091 | 2020-06-30 | Erie | Ohio | 39043 | 228 | 22 |
292243 | 292243 | 2020-07-01 | Erie | Ohio | 39043 | 229 | 22 |
295398 | 295398 | 2020-07-02 | Erie | Ohio | 39043 | 229 | 22 |
298558 | 298558 | 2020-07-03 | Erie | Ohio | 39043 | 234 | 22 |
301721 | 301721 | 2020-07-04 | Erie | Ohio | 39043 | 236 | 22 |
304884 | 304884 | 2020-07-05 | Erie | Ohio | 39043 | 242 | 22 |
308051 | 308051 | 2020-07-06 | Erie | Ohio | 39043 | 244 | 22 |
311220 | 311220 | 2020-07-07 | Erie | Ohio | 39043 | 246 | 22 |
314392 | 314392 | 2020-07-08 | Erie | Ohio | 39043 | 250 | 22 |
317565 | 317565 | 2020-07-09 | Erie | Ohio | 39043 | 260 | 22 |
320742 | 320742 | 2020-07-10 | Erie | Ohio | 39043 | 267 | 22 |
323922 | 323922 | 2020-07-11 | Erie | Ohio | 39043 | 271 | 22 |
327107 | 327107 | 2020-07-12 | Erie | Ohio | 39043 | 286 | 22 |
330294 | 330294 | 2020-07-13 | Erie | Ohio | 39043 | 301 | 22 |
333486 | 333486 | 2020-07-14 | Erie | Ohio | 39043 | 308 | 22 |
336680 | 336680 | 2020-07-15 | Erie | Ohio | 39043 | 317 | 22 |
339876 | 339876 | 2020-07-16 | Erie | Ohio | 39043 | 327 | 22 |
343074 | 343074 | 2020-07-17 | Erie | Ohio | 39043 | 340 | 22 |
346273 | 346273 | 2020-07-18 | Erie | Ohio | 39043 | 353 | 22 |
349474 | 349474 | 2020-07-19 | Erie | Ohio | 39043 | 363 | 22 |
352677 | 352677 | 2020-07-20 | Erie | Ohio | 39043 | 377 | 22 |
355880 | 355880 | 2020-07-21 | Erie | Ohio | 39043 | 380 | 22 |
359084 | 359084 | 2020-07-22 | Erie | Ohio | 39043 | 390 | 22 |
362290 | 362290 | 2020-07-23 | Erie | Ohio | 39043 | 400 | 22 |
365496 | 365496 | 2020-07-24 | Erie | Ohio | 39043 | 406 | 23 |
368705 | 368705 | 2020-07-25 | Erie | Ohio | 39043 | 428 | 23 |
371917 | 371917 | 2020-07-26 | Erie | Ohio | 39043 | 433 | 24 |
375129 | 375129 | 2020-07-27 | Erie | Ohio | 39043 | 449 | 24 |
378346 | 378346 | 2020-07-28 | Erie | Ohio | 39043 | 458 | 24 |
381563 | 381563 | 2020-07-29 | Erie | Ohio | 39043 | 468 | 25 |
384781 | 384781 | 2020-07-30 | Erie | Ohio | 39043 | 488 | 25 |
387998 | 387998 | 2020-07-31 | Erie | Ohio | 39043 | 499 | 26 |
391215 | 391215 | 2020-08-01 | Erie | Ohio | 39043 | 507 | 27 |
394431 | 394431 | 2020-08-02 | Erie | Ohio | 39043 | 516 | 27 |
397648 | 397648 | 2020-08-03 | Erie | Ohio | 39043 | 524 | 27 |
400863 | 400863 | 2020-08-04 | Erie | Ohio | 39043 | 535 | 27 |
404081 | 404081 | 2020-08-05 | Erie | Ohio | 39043 | 546 | 27 |
407300 | 407300 | 2020-08-06 | Erie | Ohio | 39043 | 556 | 27 |
410520 | 410520 | 2020-08-07 | Erie | Ohio | 39043 | 564 | 27 |
413740 | 413740 | 2020-08-08 | Erie | Ohio | 39043 | 570 | 27 |
416961 | 416961 | 2020-08-09 | Erie | Ohio | 39043 | 575 | 27 |
420181 | 420181 | 2020-08-10 | Erie | Ohio | 39043 | 592 | 27 |
423404 | 423404 | 2020-08-11 | Erie | Ohio | 39043 | 597 | 28 |
426627 | 426627 | 2020-08-12 | Erie | Ohio | 39043 | 610 | 28 |
429852 | 429852 | 2020-08-13 | Erie | Ohio | 39043 | 619 | 28 |
433078 | 433078 | 2020-08-14 | Erie | Ohio | 39043 | 626 | 30 |
436304 | 436304 | 2020-08-15 | Erie | Ohio | 39043 | 630 | 30 |
439529 | 439529 | 2020-08-16 | Erie | Ohio | 39043 | 632 | 30 |
442756 | 442756 | 2020-08-17 | Erie | Ohio | 39043 | 637 | 31 |
445982 | 445982 | 2020-08-18 | Erie | Ohio | 39043 | 662 | 31 |
449210 | 449210 | 2020-08-19 | Erie | Ohio | 39043 | 672 | 32 |
452438 | 452438 | 2020-08-20 | Erie | Ohio | 39043 | 677 | 33 |
455666 | 455666 | 2020-08-21 | Erie | Ohio | 39043 | 693 | 33 |
458894 | 458894 | 2020-08-22 | Erie | Ohio | 39043 | 699 | 33 |
462122 | 462122 | 2020-08-23 | Erie | Ohio | 39043 | 704 | 33 |
465351 | 465351 | 2020-08-24 | Erie | Ohio | 39043 | 710 | 33 |
468579 | 468579 | 2020-08-25 | Erie | Ohio | 39043 | 720 | 35 |
471811 | 471811 | 2020-08-26 | Erie | Ohio | 39043 | 747 | 35 |
475045 | 475045 | 2020-08-27 | Erie | Ohio | 39043 | 756 | 36 |
478278 | 478278 | 2020-08-28 | Erie | Ohio | 39043 | 760 | 36 |
481512 | 481512 | 2020-08-29 | Erie | Ohio | 39043 | 769 | 36 |
484747 | 484747 | 2020-08-30 | Erie | Ohio | 39043 | 772 | 36 |
487980 | 487980 | 2020-08-31 | Erie | Ohio | 39043 | 776 | 36 |
491213 | 491213 | 2020-09-01 | Erie | Ohio | 39043 | 774 | 36 |
494447 | 494447 | 2020-09-02 | Erie | Ohio | 39043 | 774 | 37 |
497680 | 497680 | 2020-09-03 | Erie | Ohio | 39043 | 783 | 37 |
500914 | 500914 | 2020-09-04 | Erie | Ohio | 39043 | 799 | 37 |
504148 | 504148 | 2020-09-05 | Erie | Ohio | 39043 | 811 | 37 |
507380 | 507380 | 2020-09-06 | Erie | Ohio | 39043 | 810 | 37 |
510613 | 510613 | 2020-09-07 | Erie | Ohio | 39043 | 822 | 37 |
513846 | 513846 | 2020-09-08 | Erie | Ohio | 39043 | 823 | 38 |
517081 | 517081 | 2020-09-09 | Erie | Ohio | 39043 | 826 | 40 |
520317 | 520317 | 2020-09-10 | Erie | Ohio | 39043 | 827 | 40 |
523553 | 523553 | 2020-09-11 | Erie | Ohio | 39043 | 835 | 42 |
526789 | 526789 | 2020-09-12 | Erie | Ohio | 39043 | 836 | 42 |
530026 | 530026 | 2020-09-13 | Erie | Ohio | 39043 | 844 | 43 |
533261 | 533261 | 2020-09-14 | Erie | Ohio | 39043 | 848 | 43 |
536497 | 536497 | 2020-09-15 | Erie | Ohio | 39043 | 862 | 44 |
539734 | 539734 | 2020-09-16 | Erie | Ohio | 39043 | 868 | 44 |
542970 | 542970 | 2020-09-17 | Erie | Ohio | 39043 | 871 | 44 |
546207 | 546207 | 2020-09-18 | Erie | Ohio | 39043 | 880 | 44 |
549446 | 549446 | 2020-09-19 | Erie | Ohio | 39043 | 896 | 44 |
552685 | 552685 | 2020-09-20 | Erie | Ohio | 39043 | 899 | 44 |
555922 | 555922 | 2020-09-21 | Erie | Ohio | 39043 | 901 | 44 |
559159 | 559159 | 2020-09-22 | Erie | Ohio | 39043 | 912 | 44 |
562396 | 562396 | 2020-09-23 | Erie | Ohio | 39043 | 926 | 45 |
565637 | 565637 | 2020-09-24 | Erie | Ohio | 39043 | 932 | 46 |
568878 | 568878 | 2020-09-25 | Erie | Ohio | 39043 | 935 | 46 |
572120 | 572120 | 2020-09-26 | Erie | Ohio | 39043 | 943 | 47 |
575364 | 575364 | 2020-09-27 | Erie | Ohio | 39043 | 946 | 47 |
578605 | 578605 | 2020-09-28 | Erie | Ohio | 39043 | 959 | 47 |
581845 | 581845 | 2020-09-29 | Erie | Ohio | 39043 | 960 | 47 |
585085 | 585085 | 2020-09-30 | Erie | Ohio | 39043 | 966 | 48 |
588325 | 588325 | 2020-10-01 | Erie | Ohio | 39043 | 983 | 50 |
591566 | 591566 | 2020-10-02 | Erie | Ohio | 39043 | 987 | 50 |
594807 | 594807 | 2020-10-03 | Erie | Ohio | 39043 | 989 | 50 |
598050 | 598050 | 2020-10-04 | Erie | Ohio | 39043 | 989 | 50 |
601293 | 601293 | 2020-10-05 | Erie | Ohio | 39043 | 997 | 50 |
604535 | 604535 | 2020-10-06 | Erie | Ohio | 39043 | 1010 | 51 |
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);