ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where fips = 39135 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1081597 | 1081597 | 2021-03-02 | Preble | Ohio | 39135 | 3533 | 78 |
1078351 | 1078351 | 2021-03-01 | Preble | Ohio | 39135 | 3526 | 71 |
1075106 | 1075106 | 2021-02-28 | Preble | Ohio | 39135 | 3525 | 71 |
1071860 | 1071860 | 2021-02-27 | Preble | Ohio | 39135 | 3524 | 71 |
1068614 | 1068614 | 2021-02-26 | Preble | Ohio | 39135 | 3517 | 71 |
1065369 | 1065369 | 2021-02-25 | Preble | Ohio | 39135 | 3513 | 70 |
1062125 | 1062125 | 2021-02-24 | Preble | Ohio | 39135 | 3510 | 70 |
1058879 | 1058879 | 2021-02-23 | Preble | Ohio | 39135 | 3505 | 70 |
1055633 | 1055633 | 2021-02-22 | Preble | Ohio | 39135 | 3495 | 69 |
1052387 | 1052387 | 2021-02-21 | Preble | Ohio | 39135 | 3493 | 69 |
1049140 | 1049140 | 2021-02-20 | Preble | Ohio | 39135 | 3491 | 69 |
1045893 | 1045893 | 2021-02-19 | Preble | Ohio | 39135 | 3483 | 69 |
1042648 | 1042648 | 2021-02-18 | Preble | Ohio | 39135 | 3479 | 69 |
1039403 | 1039403 | 2021-02-17 | Preble | Ohio | 39135 | 3474 | 69 |
1036158 | 1036158 | 2021-02-16 | Preble | Ohio | 39135 | 3470 | 69 |
1032913 | 1032913 | 2021-02-15 | Preble | Ohio | 39135 | 3462 | 69 |
1029667 | 1029667 | 2021-02-14 | Preble | Ohio | 39135 | 3456 | 69 |
1026420 | 1026420 | 2021-02-13 | Preble | Ohio | 39135 | 3451 | 69 |
1023175 | 1023175 | 2021-02-12 | Preble | Ohio | 39135 | 3440 | 64 |
1019930 | 1019930 | 2021-02-11 | Preble | Ohio | 39135 | 3435 | 44 |
1016685 | 1016685 | 2021-02-10 | Preble | Ohio | 39135 | 3421 | 38 |
1013440 | 1013440 | 2021-02-09 | Preble | Ohio | 39135 | 3407 | 38 |
1010195 | 1010195 | 2021-02-08 | Preble | Ohio | 39135 | 3387 | 38 |
1006949 | 1006949 | 2021-02-07 | Preble | Ohio | 39135 | 3387 | 38 |
1003703 | 1003703 | 2021-02-06 | Preble | Ohio | 39135 | 3381 | 38 |
1000457 | 1000457 | 2021-02-05 | Preble | Ohio | 39135 | 3363 | 38 |
997211 | 997211 | 2021-02-04 | Preble | Ohio | 39135 | 3353 | 37 |
993965 | 993965 | 2021-02-03 | Preble | Ohio | 39135 | 3336 | 37 |
990719 | 990719 | 2021-02-02 | Preble | Ohio | 39135 | 3320 | 37 |
987473 | 987473 | 2021-02-01 | Preble | Ohio | 39135 | 3313 | 37 |
984226 | 984226 | 2021-01-31 | Preble | Ohio | 39135 | 3306 | 37 |
980979 | 980979 | 2021-01-30 | Preble | Ohio | 39135 | 3300 | 37 |
977733 | 977733 | 2021-01-29 | Preble | Ohio | 39135 | 3289 | 37 |
974488 | 974488 | 2021-01-28 | Preble | Ohio | 39135 | 3276 | 37 |
971243 | 971243 | 2021-01-27 | Preble | Ohio | 39135 | 3250 | 37 |
967998 | 967998 | 2021-01-26 | Preble | Ohio | 39135 | 3236 | 37 |
964754 | 964754 | 2021-01-25 | Preble | Ohio | 39135 | 3227 | 37 |
961509 | 961509 | 2021-01-24 | Preble | Ohio | 39135 | 3214 | 37 |
958264 | 958264 | 2021-01-23 | Preble | Ohio | 39135 | 3206 | 37 |
955018 | 955018 | 2021-01-22 | Preble | Ohio | 39135 | 3191 | 37 |
951773 | 951773 | 2021-01-21 | Preble | Ohio | 39135 | 3184 | 37 |
948528 | 948528 | 2021-01-20 | Preble | Ohio | 39135 | 3153 | 37 |
945282 | 945282 | 2021-01-19 | Preble | Ohio | 39135 | 3138 | 36 |
942035 | 942035 | 2021-01-18 | Preble | Ohio | 39135 | 3124 | 34 |
938790 | 938790 | 2021-01-17 | Preble | Ohio | 39135 | 3115 | 34 |
935545 | 935545 | 2021-01-16 | Preble | Ohio | 39135 | 3100 | 34 |
932300 | 932300 | 2021-01-15 | Preble | Ohio | 39135 | 3081 | 34 |
929055 | 929055 | 2021-01-14 | Preble | Ohio | 39135 | 3064 | 34 |
925810 | 925810 | 2021-01-13 | Preble | Ohio | 39135 | 3035 | 34 |
922564 | 922564 | 2021-01-12 | Preble | Ohio | 39135 | 3019 | 34 |
919319 | 919319 | 2021-01-11 | Preble | Ohio | 39135 | 2973 | 34 |
916074 | 916074 | 2021-01-10 | Preble | Ohio | 39135 | 2966 | 31 |
912829 | 912829 | 2021-01-09 | Preble | Ohio | 39135 | 2945 | 31 |
909584 | 909584 | 2021-01-08 | Preble | Ohio | 39135 | 2914 | 31 |
906339 | 906339 | 2021-01-07 | Preble | Ohio | 39135 | 2881 | 31 |
903093 | 903093 | 2021-01-06 | Preble | Ohio | 39135 | 2855 | 31 |
899848 | 899848 | 2021-01-05 | Preble | Ohio | 39135 | 2818 | 31 |
896603 | 896603 | 2021-01-04 | Preble | Ohio | 39135 | 2788 | 31 |
893357 | 893357 | 2021-01-03 | Preble | Ohio | 39135 | 2775 | 31 |
890111 | 890111 | 2021-01-02 | Preble | Ohio | 39135 | 2759 | 31 |
886864 | 886864 | 2021-01-01 | Preble | Ohio | 39135 | 2719 | 31 |
883619 | 883619 | 2020-12-31 | Preble | Ohio | 39135 | 2719 | 31 |
880374 | 880374 | 2020-12-30 | Preble | Ohio | 39135 | 2678 | 31 |
877129 | 877129 | 2020-12-29 | Preble | Ohio | 39135 | 2653 | 31 |
873884 | 873884 | 2020-12-28 | Preble | Ohio | 39135 | 2630 | 31 |
870639 | 870639 | 2020-12-27 | Preble | Ohio | 39135 | 2628 | 31 |
867394 | 867394 | 2020-12-26 | Preble | Ohio | 39135 | 2595 | 30 |
864149 | 864149 | 2020-12-25 | Preble | Ohio | 39135 | 2538 | 30 |
860904 | 860904 | 2020-12-24 | Preble | Ohio | 39135 | 2538 | 30 |
857659 | 857659 | 2020-12-23 | Preble | Ohio | 39135 | 2507 | 30 |
854414 | 854414 | 2020-12-22 | Preble | Ohio | 39135 | 2499 | 30 |
851169 | 851169 | 2020-12-21 | Preble | Ohio | 39135 | 2476 | 29 |
847924 | 847924 | 2020-12-20 | Preble | Ohio | 39135 | 2464 | 29 |
844679 | 844679 | 2020-12-19 | Preble | Ohio | 39135 | 2440 | 29 |
841433 | 841433 | 2020-12-18 | Preble | Ohio | 39135 | 2404 | 27 |
838188 | 838188 | 2020-12-17 | Preble | Ohio | 39135 | 2372 | 27 |
834942 | 834942 | 2020-12-16 | Preble | Ohio | 39135 | 2331 | 26 |
831696 | 831696 | 2020-12-15 | Preble | Ohio | 39135 | 2311 | 26 |
828449 | 828449 | 2020-12-14 | Preble | Ohio | 39135 | 2283 | 26 |
825203 | 825203 | 2020-12-13 | Preble | Ohio | 39135 | 2250 | 26 |
821956 | 821956 | 2020-12-12 | Preble | Ohio | 39135 | 2228 | 26 |
818710 | 818710 | 2020-12-11 | Preble | Ohio | 39135 | 2187 | 25 |
815464 | 815464 | 2020-12-10 | Preble | Ohio | 39135 | 2149 | 25 |
812218 | 812218 | 2020-12-09 | Preble | Ohio | 39135 | 2118 | 25 |
808974 | 808974 | 2020-12-08 | Preble | Ohio | 39135 | 2055 | 24 |
805729 | 805729 | 2020-12-07 | Preble | Ohio | 39135 | 1945 | 23 |
802484 | 802484 | 2020-12-06 | Preble | Ohio | 39135 | 1908 | 22 |
799239 | 799239 | 2020-12-05 | Preble | Ohio | 39135 | 1876 | 22 |
795994 | 795994 | 2020-12-04 | Preble | Ohio | 39135 | 1830 | 21 |
792749 | 792749 | 2020-12-03 | Preble | Ohio | 39135 | 1800 | 21 |
789504 | 789504 | 2020-12-02 | Preble | Ohio | 39135 | 1773 | 21 |
786259 | 786259 | 2020-12-01 | Preble | Ohio | 39135 | 1740 | 21 |
783015 | 783015 | 2020-11-30 | Preble | Ohio | 39135 | 1710 | 21 |
779769 | 779769 | 2020-11-29 | Preble | Ohio | 39135 | 1691 | 21 |
776524 | 776524 | 2020-11-28 | Preble | Ohio | 39135 | 1657 | 21 |
773279 | 773279 | 2020-11-27 | Preble | Ohio | 39135 | 1625 | 21 |
770034 | 770034 | 2020-11-26 | Preble | Ohio | 39135 | 1565 | 21 |
766788 | 766788 | 2020-11-25 | Preble | Ohio | 39135 | 1565 | 21 |
763543 | 763543 | 2020-11-24 | Preble | Ohio | 39135 | 1526 | 21 |
760298 | 760298 | 2020-11-23 | Preble | Ohio | 39135 | 1484 | 21 |
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);