ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Ashland", fips = 39005 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
731020 | 731020 | 2020-11-14 | Ashland | Ohio | 39005 | 754 | 20 |
727776 | 727776 | 2020-11-13 | Ashland | Ohio | 39005 | 736 | 20 |
724532 | 724532 | 2020-11-12 | Ashland | Ohio | 39005 | 711 | 20 |
721289 | 721289 | 2020-11-11 | Ashland | Ohio | 39005 | 689 | 20 |
718046 | 718046 | 2020-11-10 | Ashland | Ohio | 39005 | 641 | 20 |
714803 | 714803 | 2020-11-09 | Ashland | Ohio | 39005 | 631 | 20 |
711559 | 711559 | 2020-11-08 | Ashland | Ohio | 39005 | 606 | 20 |
708315 | 708315 | 2020-11-07 | Ashland | Ohio | 39005 | 585 | 20 |
705072 | 705072 | 2020-11-06 | Ashland | Ohio | 39005 | 576 | 20 |
701829 | 701829 | 2020-11-05 | Ashland | Ohio | 39005 | 557 | 20 |
698585 | 698585 | 2020-11-04 | Ashland | Ohio | 39005 | 542 | 20 |
695342 | 695342 | 2020-11-03 | Ashland | Ohio | 39005 | 529 | 19 |
692100 | 692100 | 2020-11-02 | Ashland | Ohio | 39005 | 518 | 9 |
688856 | 688856 | 2020-11-01 | Ashland | Ohio | 39005 | 511 | 9 |
685611 | 685611 | 2020-10-31 | Ashland | Ohio | 39005 | 495 | 9 |
682368 | 682368 | 2020-10-30 | Ashland | Ohio | 39005 | 485 | 9 |
679125 | 679125 | 2020-10-29 | Ashland | Ohio | 39005 | 473 | 9 |
675882 | 675882 | 2020-10-28 | Ashland | Ohio | 39005 | 452 | 9 |
672639 | 672639 | 2020-10-27 | Ashland | Ohio | 39005 | 441 | 9 |
669397 | 669397 | 2020-10-26 | Ashland | Ohio | 39005 | 435 | 9 |
666153 | 666153 | 2020-10-25 | Ashland | Ohio | 39005 | 428 | 9 |
662908 | 662908 | 2020-10-24 | Ashland | Ohio | 39005 | 420 | 9 |
659664 | 659664 | 2020-10-23 | Ashland | Ohio | 39005 | 410 | 9 |
656420 | 656420 | 2020-10-22 | Ashland | Ohio | 39005 | 398 | 6 |
653175 | 653175 | 2020-10-21 | Ashland | Ohio | 39005 | 389 | 5 |
649930 | 649930 | 2020-10-20 | Ashland | Ohio | 39005 | 373 | 5 |
646686 | 646686 | 2020-10-19 | Ashland | Ohio | 39005 | 371 | 5 |
643440 | 643440 | 2020-10-18 | Ashland | Ohio | 39005 | 370 | 5 |
640192 | 640192 | 2020-10-17 | Ashland | Ohio | 39005 | 365 | 5 |
636946 | 636946 | 2020-10-16 | Ashland | Ohio | 39005 | 361 | 5 |
633700 | 633700 | 2020-10-15 | Ashland | Ohio | 39005 | 357 | 5 |
630455 | 630455 | 2020-10-14 | Ashland | Ohio | 39005 | 351 | 5 |
627211 | 627211 | 2020-10-13 | Ashland | Ohio | 39005 | 349 | 5 |
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);