ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Ashland" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055568 | 1055568 | 2021-02-22 | Ashland | Ohio | 39005 | 3743 | 93 |
1052322 | 1052322 | 2021-02-21 | Ashland | Ohio | 39005 | 3733 | 92 |
1049075 | 1049075 | 2021-02-20 | Ashland | Ohio | 39005 | 3729 | 92 |
1045828 | 1045828 | 2021-02-19 | Ashland | Ohio | 39005 | 3723 | 92 |
1042583 | 1042583 | 2021-02-18 | Ashland | Ohio | 39005 | 3709 | 91 |
1039338 | 1039338 | 2021-02-17 | Ashland | Ohio | 39005 | 3704 | 91 |
1036093 | 1036093 | 2021-02-16 | Ashland | Ohio | 39005 | 3702 | 91 |
1032848 | 1032848 | 2021-02-15 | Ashland | Ohio | 39005 | 3695 | 91 |
1029602 | 1029602 | 2021-02-14 | Ashland | Ohio | 39005 | 3686 | 86 |
1026355 | 1026355 | 2021-02-13 | Ashland | Ohio | 39005 | 3680 | 86 |
1023110 | 1023110 | 2021-02-12 | Ashland | Ohio | 39005 | 3674 | 73 |
1019865 | 1019865 | 2021-02-11 | Ashland | Ohio | 39005 | 3666 | 49 |
1016620 | 1016620 | 2021-02-10 | Ashland | Ohio | 39005 | 3656 | 40 |
1013375 | 1013375 | 2021-02-09 | Ashland | Ohio | 39005 | 3646 | 39 |
1010130 | 1010130 | 2021-02-08 | Ashland | Ohio | 39005 | 3634 | 39 |
1006884 | 1006884 | 2021-02-07 | Ashland | Ohio | 39005 | 3631 | 39 |
1003638 | 1003638 | 2021-02-06 | Ashland | Ohio | 39005 | 3621 | 39 |
1000392 | 1000392 | 2021-02-05 | Ashland | Ohio | 39005 | 3614 | 38 |
997146 | 997146 | 2021-02-04 | Ashland | Ohio | 39005 | 3607 | 38 |
993900 | 993900 | 2021-02-03 | Ashland | Ohio | 39005 | 3600 | 38 |
990654 | 990654 | 2021-02-02 | Ashland | Ohio | 39005 | 3592 | 38 |
987408 | 987408 | 2021-02-01 | Ashland | Ohio | 39005 | 3579 | 38 |
984161 | 984161 | 2021-01-31 | Ashland | Ohio | 39005 | 3565 | 38 |
980914 | 980914 | 2021-01-30 | Ashland | Ohio | 39005 | 3556 | 38 |
977668 | 977668 | 2021-01-29 | Ashland | Ohio | 39005 | 3545 | 38 |
974423 | 974423 | 2021-01-28 | Ashland | Ohio | 39005 | 3531 | 38 |
971178 | 971178 | 2021-01-27 | Ashland | Ohio | 39005 | 3515 | 38 |
967933 | 967933 | 2021-01-26 | Ashland | Ohio | 39005 | 3496 | 38 |
964689 | 964689 | 2021-01-25 | Ashland | Ohio | 39005 | 3490 | 38 |
961444 | 961444 | 2021-01-24 | Ashland | Ohio | 39005 | 3474 | 38 |
958199 | 958199 | 2021-01-23 | Ashland | Ohio | 39005 | 3449 | 38 |
954953 | 954953 | 2021-01-22 | Ashland | Ohio | 39005 | 3428 | 38 |
951708 | 951708 | 2021-01-21 | Ashland | Ohio | 39005 | 3425 | 38 |
948463 | 948463 | 2021-01-20 | Ashland | Ohio | 39005 | 3397 | 38 |
945217 | 945217 | 2021-01-19 | Ashland | Ohio | 39005 | 3368 | 38 |
941970 | 941970 | 2021-01-18 | Ashland | Ohio | 39005 | 3338 | 38 |
938725 | 938725 | 2021-01-17 | Ashland | Ohio | 39005 | 3317 | 38 |
935480 | 935480 | 2021-01-16 | Ashland | Ohio | 39005 | 3291 | 38 |
932235 | 932235 | 2021-01-15 | Ashland | Ohio | 39005 | 3253 | 38 |
928990 | 928990 | 2021-01-14 | Ashland | Ohio | 39005 | 3225 | 38 |
925745 | 925745 | 2021-01-13 | Ashland | Ohio | 39005 | 3192 | 38 |
922499 | 922499 | 2021-01-12 | Ashland | Ohio | 39005 | 3150 | 38 |
919254 | 919254 | 2021-01-11 | Ashland | Ohio | 39005 | 3141 | 38 |
916009 | 916009 | 2021-01-10 | Ashland | Ohio | 39005 | 3089 | 38 |
912764 | 912764 | 2021-01-09 | Ashland | Ohio | 39005 | 3055 | 38 |
909519 | 909519 | 2021-01-08 | Ashland | Ohio | 39005 | 3024 | 38 |
906274 | 906274 | 2021-01-07 | Ashland | Ohio | 39005 | 2976 | 38 |
903028 | 903028 | 2021-01-06 | Ashland | Ohio | 39005 | 2927 | 38 |
899783 | 899783 | 2021-01-05 | Ashland | Ohio | 39005 | 2909 | 38 |
896538 | 896538 | 2021-01-04 | Ashland | Ohio | 39005 | 2877 | 38 |
893292 | 893292 | 2021-01-03 | Ashland | Ohio | 39005 | 2844 | 38 |
890046 | 890046 | 2021-01-02 | Ashland | Ohio | 39005 | 2825 | 37 |
886799 | 886799 | 2021-01-01 | Ashland | Ohio | 39005 | 2729 | 37 |
883554 | 883554 | 2020-12-31 | Ashland | Ohio | 39005 | 2729 | 37 |
880309 | 880309 | 2020-12-30 | Ashland | Ohio | 39005 | 2679 | 37 |
877064 | 877064 | 2020-12-29 | Ashland | Ohio | 39005 | 2623 | 37 |
873819 | 873819 | 2020-12-28 | Ashland | Ohio | 39005 | 2592 | 37 |
870574 | 870574 | 2020-12-27 | Ashland | Ohio | 39005 | 2560 | 37 |
867329 | 867329 | 2020-12-26 | Ashland | Ohio | 39005 | 2535 | 37 |
864084 | 864084 | 2020-12-25 | Ashland | Ohio | 39005 | 2476 | 37 |
860839 | 860839 | 2020-12-24 | Ashland | Ohio | 39005 | 2476 | 37 |
857594 | 857594 | 2020-12-23 | Ashland | Ohio | 39005 | 2403 | 37 |
854349 | 854349 | 2020-12-22 | Ashland | Ohio | 39005 | 2374 | 36 |
851104 | 851104 | 2020-12-21 | Ashland | Ohio | 39005 | 2348 | 36 |
847859 | 847859 | 2020-12-20 | Ashland | Ohio | 39005 | 2327 | 36 |
844614 | 844614 | 2020-12-19 | Ashland | Ohio | 39005 | 2265 | 36 |
841368 | 841368 | 2020-12-18 | Ashland | Ohio | 39005 | 2196 | 36 |
838123 | 838123 | 2020-12-17 | Ashland | Ohio | 39005 | 2129 | 36 |
834877 | 834877 | 2020-12-16 | Ashland | Ohio | 39005 | 2078 | 36 |
831631 | 831631 | 2020-12-15 | Ashland | Ohio | 39005 | 2056 | 36 |
828384 | 828384 | 2020-12-14 | Ashland | Ohio | 39005 | 2026 | 36 |
825138 | 825138 | 2020-12-13 | Ashland | Ohio | 39005 | 1985 | 36 |
821891 | 821891 | 2020-12-12 | Ashland | Ohio | 39005 | 1944 | 36 |
818645 | 818645 | 2020-12-11 | Ashland | Ohio | 39005 | 1868 | 36 |
815399 | 815399 | 2020-12-10 | Ashland | Ohio | 39005 | 1838 | 36 |
812153 | 812153 | 2020-12-09 | Ashland | Ohio | 39005 | 1799 | 36 |
808909 | 808909 | 2020-12-08 | Ashland | Ohio | 39005 | 1749 | 35 |
805664 | 805664 | 2020-12-07 | Ashland | Ohio | 39005 | 1546 | 34 |
802419 | 802419 | 2020-12-06 | Ashland | Ohio | 39005 | 1455 | 34 |
799174 | 799174 | 2020-12-05 | Ashland | Ohio | 39005 | 1423 | 33 |
795929 | 795929 | 2020-12-04 | Ashland | Ohio | 39005 | 1390 | 33 |
792684 | 792684 | 2020-12-03 | Ashland | Ohio | 39005 | 1351 | 33 |
789439 | 789439 | 2020-12-02 | Ashland | Ohio | 39005 | 1328 | 33 |
786194 | 786194 | 2020-12-01 | Ashland | Ohio | 39005 | 1288 | 31 |
782950 | 782950 | 2020-11-30 | Ashland | Ohio | 39005 | 1251 | 29 |
779704 | 779704 | 2020-11-29 | Ashland | Ohio | 39005 | 1232 | 29 |
776459 | 776459 | 2020-11-28 | Ashland | Ohio | 39005 | 1207 | 29 |
773214 | 773214 | 2020-11-27 | Ashland | Ohio | 39005 | 1173 | 28 |
769969 | 769969 | 2020-11-26 | Ashland | Ohio | 39005 | 1078 | 25 |
766723 | 766723 | 2020-11-25 | Ashland | Ohio | 39005 | 1078 | 25 |
763478 | 763478 | 2020-11-24 | Ashland | Ohio | 39005 | 1052 | 22 |
760233 | 760233 | 2020-11-23 | Ashland | Ohio | 39005 | 1027 | 22 |
756988 | 756988 | 2020-11-22 | Ashland | Ohio | 39005 | 983 | 22 |
753741 | 753741 | 2020-11-21 | Ashland | Ohio | 39005 | 945 | 21 |
750495 | 750495 | 2020-11-20 | Ashland | Ohio | 39005 | 920 | 21 |
747249 | 747249 | 2020-11-19 | Ashland | Ohio | 39005 | 881 | 21 |
744003 | 744003 | 2020-11-18 | Ashland | Ohio | 39005 | 857 | 20 |
740756 | 740756 | 2020-11-17 | Ashland | Ohio | 39005 | 832 | 20 |
737510 | 737510 | 2020-11-16 | Ashland | Ohio | 39005 | 809 | 20 |
734266 | 734266 | 2020-11-15 | Ashland | Ohio | 39005 | 772 | 20 |
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);