ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 39055 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055593 | 1055593 | 2021-02-22 | Geauga | Ohio | 39055 | 5941 | 129 |
1052347 | 1052347 | 2021-02-21 | Geauga | Ohio | 39055 | 5928 | 129 |
1049100 | 1049100 | 2021-02-20 | Geauga | Ohio | 39055 | 5914 | 128 |
1045853 | 1045853 | 2021-02-19 | Geauga | Ohio | 39055 | 5897 | 128 |
1042608 | 1042608 | 2021-02-18 | Geauga | Ohio | 39055 | 5870 | 128 |
1039363 | 1039363 | 2021-02-17 | Geauga | Ohio | 39055 | 5852 | 128 |
1036118 | 1036118 | 2021-02-16 | Geauga | Ohio | 39055 | 5822 | 126 |
1032873 | 1032873 | 2021-02-15 | Geauga | Ohio | 39055 | 5816 | 125 |
1029627 | 1029627 | 2021-02-14 | Geauga | Ohio | 39055 | 5802 | 125 |
1026380 | 1026380 | 2021-02-13 | Geauga | Ohio | 39055 | 5783 | 124 |
1023135 | 1023135 | 2021-02-12 | Geauga | Ohio | 39055 | 5765 | 110 |
1019890 | 1019890 | 2021-02-11 | Geauga | Ohio | 39055 | 5740 | 70 |
1016645 | 1016645 | 2021-02-10 | Geauga | Ohio | 39055 | 5706 | 57 |
1013400 | 1013400 | 2021-02-09 | Geauga | Ohio | 39055 | 5668 | 57 |
1010155 | 1010155 | 2021-02-08 | Geauga | Ohio | 39055 | 5656 | 56 |
1006909 | 1006909 | 2021-02-07 | Geauga | Ohio | 39055 | 5637 | 56 |
1003663 | 1003663 | 2021-02-06 | Geauga | Ohio | 39055 | 5616 | 56 |
1000417 | 1000417 | 2021-02-05 | Geauga | Ohio | 39055 | 5595 | 56 |
997171 | 997171 | 2021-02-04 | Geauga | Ohio | 39055 | 5565 | 56 |
993925 | 993925 | 2021-02-03 | Geauga | Ohio | 39055 | 5541 | 56 |
990679 | 990679 | 2021-02-02 | Geauga | Ohio | 39055 | 5491 | 56 |
987433 | 987433 | 2021-02-01 | Geauga | Ohio | 39055 | 5456 | 56 |
984186 | 984186 | 2021-01-31 | Geauga | Ohio | 39055 | 5428 | 56 |
980939 | 980939 | 2021-01-30 | Geauga | Ohio | 39055 | 5399 | 56 |
977693 | 977693 | 2021-01-29 | Geauga | Ohio | 39055 | 5355 | 56 |
974448 | 974448 | 2021-01-28 | Geauga | Ohio | 39055 | 5308 | 56 |
971203 | 971203 | 2021-01-27 | Geauga | Ohio | 39055 | 5242 | 56 |
967958 | 967958 | 2021-01-26 | Geauga | Ohio | 39055 | 5189 | 55 |
964714 | 964714 | 2021-01-25 | Geauga | Ohio | 39055 | 5159 | 55 |
961469 | 961469 | 2021-01-24 | Geauga | Ohio | 39055 | 5135 | 55 |
958224 | 958224 | 2021-01-23 | Geauga | Ohio | 39055 | 5084 | 55 |
954978 | 954978 | 2021-01-22 | Geauga | Ohio | 39055 | 5038 | 55 |
951733 | 951733 | 2021-01-21 | Geauga | Ohio | 39055 | 5011 | 55 |
948488 | 948488 | 2021-01-20 | Geauga | Ohio | 39055 | 4971 | 55 |
945242 | 945242 | 2021-01-19 | Geauga | Ohio | 39055 | 4917 | 55 |
941995 | 941995 | 2021-01-18 | Geauga | Ohio | 39055 | 4877 | 55 |
938750 | 938750 | 2021-01-17 | Geauga | Ohio | 39055 | 4835 | 55 |
935505 | 935505 | 2021-01-16 | Geauga | Ohio | 39055 | 4782 | 55 |
932260 | 932260 | 2021-01-15 | Geauga | Ohio | 39055 | 4748 | 55 |
929015 | 929015 | 2021-01-14 | Geauga | Ohio | 39055 | 4699 | 55 |
925770 | 925770 | 2021-01-13 | Geauga | Ohio | 39055 | 4668 | 55 |
922524 | 922524 | 2021-01-12 | Geauga | Ohio | 39055 | 4609 | 55 |
919279 | 919279 | 2021-01-11 | Geauga | Ohio | 39055 | 4559 | 55 |
916034 | 916034 | 2021-01-10 | Geauga | Ohio | 39055 | 4522 | 54 |
912789 | 912789 | 2021-01-09 | Geauga | Ohio | 39055 | 4465 | 54 |
909544 | 909544 | 2021-01-08 | Geauga | Ohio | 39055 | 4423 | 54 |
906299 | 906299 | 2021-01-07 | Geauga | Ohio | 39055 | 4356 | 54 |
903053 | 903053 | 2021-01-06 | Geauga | Ohio | 39055 | 4291 | 54 |
899808 | 899808 | 2021-01-05 | Geauga | Ohio | 39055 | 4242 | 53 |
896563 | 896563 | 2021-01-04 | Geauga | Ohio | 39055 | 4202 | 53 |
893317 | 893317 | 2021-01-03 | Geauga | Ohio | 39055 | 4156 | 53 |
890071 | 890071 | 2021-01-02 | Geauga | Ohio | 39055 | 4113 | 53 |
886824 | 886824 | 2021-01-01 | Geauga | Ohio | 39055 | 4022 | 53 |
883579 | 883579 | 2020-12-31 | Geauga | Ohio | 39055 | 4022 | 53 |
880334 | 880334 | 2020-12-30 | Geauga | Ohio | 39055 | 3964 | 53 |
877089 | 877089 | 2020-12-29 | Geauga | Ohio | 39055 | 3928 | 51 |
873844 | 873844 | 2020-12-28 | Geauga | Ohio | 39055 | 3882 | 51 |
870599 | 870599 | 2020-12-27 | Geauga | Ohio | 39055 | 3856 | 51 |
867354 | 867354 | 2020-12-26 | Geauga | Ohio | 39055 | 3819 | 51 |
864109 | 864109 | 2020-12-25 | Geauga | Ohio | 39055 | 3760 | 51 |
860864 | 860864 | 2020-12-24 | Geauga | Ohio | 39055 | 3760 | 51 |
857619 | 857619 | 2020-12-23 | Geauga | Ohio | 39055 | 3704 | 51 |
854374 | 854374 | 2020-12-22 | Geauga | Ohio | 39055 | 3666 | 51 |
851129 | 851129 | 2020-12-21 | Geauga | Ohio | 39055 | 3625 | 51 |
847884 | 847884 | 2020-12-20 | Geauga | Ohio | 39055 | 3599 | 51 |
844639 | 844639 | 2020-12-19 | Geauga | Ohio | 39055 | 3539 | 51 |
841393 | 841393 | 2020-12-18 | Geauga | Ohio | 39055 | 3494 | 51 |
838148 | 838148 | 2020-12-17 | Geauga | Ohio | 39055 | 3446 | 51 |
834902 | 834902 | 2020-12-16 | Geauga | Ohio | 39055 | 3389 | 51 |
831656 | 831656 | 2020-12-15 | Geauga | Ohio | 39055 | 3372 | 51 |
828409 | 828409 | 2020-12-14 | Geauga | Ohio | 39055 | 3325 | 51 |
825163 | 825163 | 2020-12-13 | Geauga | Ohio | 39055 | 3275 | 51 |
821916 | 821916 | 2020-12-12 | Geauga | Ohio | 39055 | 3223 | 51 |
818670 | 818670 | 2020-12-11 | Geauga | Ohio | 39055 | 3152 | 51 |
815424 | 815424 | 2020-12-10 | Geauga | Ohio | 39055 | 3090 | 51 |
812178 | 812178 | 2020-12-09 | Geauga | Ohio | 39055 | 3049 | 51 |
808934 | 808934 | 2020-12-08 | Geauga | Ohio | 39055 | 2966 | 51 |
805689 | 805689 | 2020-12-07 | Geauga | Ohio | 39055 | 2803 | 51 |
802444 | 802444 | 2020-12-06 | Geauga | Ohio | 39055 | 2727 | 51 |
799199 | 799199 | 2020-12-05 | Geauga | Ohio | 39055 | 2678 | 51 |
795954 | 795954 | 2020-12-04 | Geauga | Ohio | 39055 | 2631 | 51 |
792709 | 792709 | 2020-12-03 | Geauga | Ohio | 39055 | 2572 | 51 |
789464 | 789464 | 2020-12-02 | Geauga | Ohio | 39055 | 2556 | 51 |
786219 | 786219 | 2020-12-01 | Geauga | Ohio | 39055 | 2511 | 51 |
782975 | 782975 | 2020-11-30 | Geauga | Ohio | 39055 | 2430 | 51 |
779729 | 779729 | 2020-11-29 | Geauga | Ohio | 39055 | 2385 | 51 |
776484 | 776484 | 2020-11-28 | Geauga | Ohio | 39055 | 2318 | 51 |
773239 | 773239 | 2020-11-27 | Geauga | Ohio | 39055 | 2270 | 51 |
769994 | 769994 | 2020-11-26 | Geauga | Ohio | 39055 | 2118 | 51 |
766748 | 766748 | 2020-11-25 | Geauga | Ohio | 39055 | 2118 | 51 |
763503 | 763503 | 2020-11-24 | Geauga | Ohio | 39055 | 2033 | 51 |
760258 | 760258 | 2020-11-23 | Geauga | Ohio | 39055 | 1973 | 51 |
757013 | 757013 | 2020-11-22 | Geauga | Ohio | 39055 | 1894 | 51 |
753766 | 753766 | 2020-11-21 | Geauga | Ohio | 39055 | 1814 | 51 |
750520 | 750520 | 2020-11-20 | Geauga | Ohio | 39055 | 1776 | 51 |
747274 | 747274 | 2020-11-19 | Geauga | Ohio | 39055 | 1707 | 51 |
744028 | 744028 | 2020-11-18 | Geauga | Ohio | 39055 | 1646 | 51 |
740781 | 740781 | 2020-11-17 | Geauga | Ohio | 39055 | 1613 | 51 |
737535 | 737535 | 2020-11-16 | Geauga | Ohio | 39055 | 1564 | 51 |
734291 | 734291 | 2020-11-15 | Geauga | Ohio | 39055 | 1497 | 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);