ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 39011 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
948466 | 948466 | 2021-01-20 | Auglaize | Ohio | 39011 | 4183 | 59 |
945220 | 945220 | 2021-01-19 | Auglaize | Ohio | 39011 | 4162 | 59 |
941973 | 941973 | 2021-01-18 | Auglaize | Ohio | 39011 | 4151 | 59 |
938728 | 938728 | 2021-01-17 | Auglaize | Ohio | 39011 | 4127 | 59 |
935483 | 935483 | 2021-01-16 | Auglaize | Ohio | 39011 | 4109 | 59 |
932238 | 932238 | 2021-01-15 | Auglaize | Ohio | 39011 | 4092 | 59 |
928993 | 928993 | 2021-01-14 | Auglaize | Ohio | 39011 | 4070 | 59 |
925748 | 925748 | 2021-01-13 | Auglaize | Ohio | 39011 | 4042 | 59 |
922502 | 922502 | 2021-01-12 | Auglaize | Ohio | 39011 | 4012 | 59 |
919257 | 919257 | 2021-01-11 | Auglaize | Ohio | 39011 | 3991 | 59 |
916012 | 916012 | 2021-01-10 | Auglaize | Ohio | 39011 | 3942 | 59 |
912767 | 912767 | 2021-01-09 | Auglaize | Ohio | 39011 | 3921 | 59 |
909522 | 909522 | 2021-01-08 | Auglaize | Ohio | 39011 | 3900 | 57 |
906277 | 906277 | 2021-01-07 | Auglaize | Ohio | 39011 | 3857 | 55 |
903031 | 903031 | 2021-01-06 | Auglaize | Ohio | 39011 | 3807 | 55 |
899786 | 899786 | 2021-01-05 | Auglaize | Ohio | 39011 | 3771 | 55 |
896541 | 896541 | 2021-01-04 | Auglaize | Ohio | 39011 | 3730 | 55 |
893295 | 893295 | 2021-01-03 | Auglaize | Ohio | 39011 | 3712 | 55 |
890049 | 890049 | 2021-01-02 | Auglaize | Ohio | 39011 | 3671 | 55 |
886802 | 886802 | 2021-01-01 | Auglaize | Ohio | 39011 | 3642 | 55 |
883557 | 883557 | 2020-12-31 | Auglaize | Ohio | 39011 | 3642 | 55 |
880312 | 880312 | 2020-12-30 | Auglaize | Ohio | 39011 | 3586 | 55 |
877067 | 877067 | 2020-12-29 | Auglaize | Ohio | 39011 | 3542 | 51 |
873822 | 873822 | 2020-12-28 | Auglaize | Ohio | 39011 | 3507 | 51 |
870577 | 870577 | 2020-12-27 | Auglaize | Ohio | 39011 | 3490 | 51 |
867332 | 867332 | 2020-12-26 | Auglaize | Ohio | 39011 | 3473 | 51 |
864087 | 864087 | 2020-12-25 | Auglaize | Ohio | 39011 | 3442 | 51 |
860842 | 860842 | 2020-12-24 | Auglaize | Ohio | 39011 | 3442 | 51 |
857597 | 857597 | 2020-12-23 | Auglaize | Ohio | 39011 | 3393 | 50 |
854352 | 854352 | 2020-12-22 | Auglaize | Ohio | 39011 | 3366 | 50 |
851107 | 851107 | 2020-12-21 | Auglaize | Ohio | 39011 | 3326 | 49 |
847862 | 847862 | 2020-12-20 | Auglaize | Ohio | 39011 | 3302 | 49 |
844617 | 844617 | 2020-12-19 | Auglaize | Ohio | 39011 | 3288 | 49 |
841371 | 841371 | 2020-12-18 | Auglaize | Ohio | 39011 | 3253 | 49 |
838126 | 838126 | 2020-12-17 | Auglaize | Ohio | 39011 | 3198 | 49 |
834880 | 834880 | 2020-12-16 | Auglaize | Ohio | 39011 | 3159 | 47 |
831634 | 831634 | 2020-12-15 | Auglaize | Ohio | 39011 | 3112 | 47 |
828387 | 828387 | 2020-12-14 | Auglaize | Ohio | 39011 | 3087 | 46 |
825141 | 825141 | 2020-12-13 | Auglaize | Ohio | 39011 | 3063 | 46 |
821894 | 821894 | 2020-12-12 | Auglaize | Ohio | 39011 | 3036 | 46 |
818648 | 818648 | 2020-12-11 | Auglaize | Ohio | 39011 | 3014 | 46 |
815402 | 815402 | 2020-12-10 | Auglaize | Ohio | 39011 | 2981 | 44 |
812156 | 812156 | 2020-12-09 | Auglaize | Ohio | 39011 | 2931 | 44 |
808912 | 808912 | 2020-12-08 | Auglaize | Ohio | 39011 | 2872 | 42 |
805667 | 805667 | 2020-12-07 | Auglaize | Ohio | 39011 | 2770 | 42 |
802422 | 802422 | 2020-12-06 | Auglaize | Ohio | 39011 | 2738 | 42 |
799177 | 799177 | 2020-12-05 | Auglaize | Ohio | 39011 | 2728 | 42 |
795932 | 795932 | 2020-12-04 | Auglaize | Ohio | 39011 | 2696 | 42 |
792687 | 792687 | 2020-12-03 | Auglaize | Ohio | 39011 | 2658 | 41 |
789442 | 789442 | 2020-12-02 | Auglaize | Ohio | 39011 | 2619 | 39 |
786197 | 786197 | 2020-12-01 | Auglaize | Ohio | 39011 | 2554 | 39 |
782953 | 782953 | 2020-11-30 | Auglaize | Ohio | 39011 | 2510 | 35 |
779707 | 779707 | 2020-11-29 | Auglaize | Ohio | 39011 | 2487 | 35 |
776462 | 776462 | 2020-11-28 | Auglaize | Ohio | 39011 | 2467 | 35 |
773217 | 773217 | 2020-11-27 | Auglaize | Ohio | 39011 | 2439 | 35 |
769972 | 769972 | 2020-11-26 | Auglaize | Ohio | 39011 | 2364 | 35 |
766726 | 766726 | 2020-11-25 | Auglaize | Ohio | 39011 | 2364 | 35 |
763481 | 763481 | 2020-11-24 | Auglaize | Ohio | 39011 | 2310 | 31 |
760236 | 760236 | 2020-11-23 | Auglaize | Ohio | 39011 | 2232 | 30 |
756991 | 756991 | 2020-11-22 | Auglaize | Ohio | 39011 | 2189 | 25 |
753744 | 753744 | 2020-11-21 | Auglaize | Ohio | 39011 | 2159 | 23 |
750498 | 750498 | 2020-11-20 | Auglaize | Ohio | 39011 | 2107 | 23 |
747252 | 747252 | 2020-11-19 | Auglaize | Ohio | 39011 | 2047 | 22 |
744006 | 744006 | 2020-11-18 | Auglaize | Ohio | 39011 | 2000 | 22 |
740759 | 740759 | 2020-11-17 | Auglaize | Ohio | 39011 | 1931 | 21 |
737513 | 737513 | 2020-11-16 | Auglaize | Ohio | 39011 | 1892 | 21 |
734269 | 734269 | 2020-11-15 | Auglaize | Ohio | 39011 | 1867 | 21 |
731023 | 731023 | 2020-11-14 | Auglaize | Ohio | 39011 | 1836 | 21 |
727779 | 727779 | 2020-11-13 | Auglaize | Ohio | 39011 | 1744 | 21 |
724535 | 724535 | 2020-11-12 | Auglaize | Ohio | 39011 | 1684 | 21 |
721292 | 721292 | 2020-11-11 | Auglaize | Ohio | 39011 | 1617 | 21 |
718049 | 718049 | 2020-11-10 | Auglaize | Ohio | 39011 | 1591 | 19 |
714806 | 714806 | 2020-11-09 | Auglaize | Ohio | 39011 | 1535 | 19 |
711562 | 711562 | 2020-11-08 | Auglaize | Ohio | 39011 | 1515 | 19 |
708318 | 708318 | 2020-11-07 | Auglaize | Ohio | 39011 | 1494 | 19 |
705075 | 705075 | 2020-11-06 | Auglaize | Ohio | 39011 | 1460 | 19 |
701832 | 701832 | 2020-11-05 | Auglaize | Ohio | 39011 | 1430 | 19 |
698588 | 698588 | 2020-11-04 | Auglaize | Ohio | 39011 | 1393 | 19 |
695345 | 695345 | 2020-11-03 | Auglaize | Ohio | 39011 | 1341 | 19 |
692103 | 692103 | 2020-11-02 | Auglaize | Ohio | 39011 | 1300 | 19 |
688859 | 688859 | 2020-11-01 | Auglaize | Ohio | 39011 | 1279 | 19 |
685614 | 685614 | 2020-10-31 | Auglaize | Ohio | 39011 | 1258 | 19 |
682371 | 682371 | 2020-10-30 | Auglaize | Ohio | 39011 | 1233 | 19 |
679128 | 679128 | 2020-10-29 | Auglaize | Ohio | 39011 | 1198 | 19 |
675885 | 675885 | 2020-10-28 | Auglaize | Ohio | 39011 | 1147 | 19 |
672642 | 672642 | 2020-10-27 | Auglaize | Ohio | 39011 | 1127 | 19 |
669400 | 669400 | 2020-10-26 | Auglaize | Ohio | 39011 | 1106 | 18 |
666156 | 666156 | 2020-10-25 | Auglaize | Ohio | 39011 | 1094 | 18 |
662911 | 662911 | 2020-10-24 | Auglaize | Ohio | 39011 | 1054 | 18 |
659667 | 659667 | 2020-10-23 | Auglaize | Ohio | 39011 | 1023 | 16 |
656423 | 656423 | 2020-10-22 | Auglaize | Ohio | 39011 | 1006 | 16 |
653178 | 653178 | 2020-10-21 | Auglaize | Ohio | 39011 | 978 | 16 |
649933 | 649933 | 2020-10-20 | Auglaize | Ohio | 39011 | 951 | 16 |
646689 | 646689 | 2020-10-19 | Auglaize | Ohio | 39011 | 936 | 16 |
643443 | 643443 | 2020-10-18 | Auglaize | Ohio | 39011 | 927 | 16 |
640195 | 640195 | 2020-10-17 | Auglaize | Ohio | 39011 | 899 | 16 |
636949 | 636949 | 2020-10-16 | Auglaize | Ohio | 39011 | 882 | 16 |
633703 | 633703 | 2020-10-15 | Auglaize | Ohio | 39011 | 856 | 16 |
630458 | 630458 | 2020-10-14 | Auglaize | Ohio | 39011 | 823 | 16 |
627214 | 627214 | 2020-10-13 | Auglaize | Ohio | 39011 | 794 | 16 |
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);