ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 39061 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1081560 | 1081560 | 2021-03-02 | Hamilton | Ohio | 39061 | 73415 | 1034 |
1078314 | 1078314 | 2021-03-01 | Hamilton | Ohio | 39061 | 73287 | 974 |
1075069 | 1075069 | 2021-02-28 | Hamilton | Ohio | 39061 | 73202 | 970 |
1071823 | 1071823 | 2021-02-27 | Hamilton | Ohio | 39061 | 73102 | 963 |
1068577 | 1068577 | 2021-02-26 | Hamilton | Ohio | 39061 | 72988 | 958 |
1065332 | 1065332 | 2021-02-25 | Hamilton | Ohio | 39061 | 72843 | 954 |
1062088 | 1062088 | 2021-02-24 | Hamilton | Ohio | 39061 | 72643 | 947 |
1058842 | 1058842 | 2021-02-23 | Hamilton | Ohio | 39061 | 72486 | 944 |
1055596 | 1055596 | 2021-02-22 | Hamilton | Ohio | 39061 | 72330 | 938 |
1052350 | 1052350 | 2021-02-21 | Hamilton | Ohio | 39061 | 72213 | 935 |
1049103 | 1049103 | 2021-02-20 | Hamilton | Ohio | 39061 | 72108 | 929 |
1045856 | 1045856 | 2021-02-19 | Hamilton | Ohio | 39061 | 71712 | 927 |
1042611 | 1042611 | 2021-02-18 | Hamilton | Ohio | 39061 | 71567 | 925 |
1039366 | 1039366 | 2021-02-17 | Hamilton | Ohio | 39061 | 71388 | 917 |
1036121 | 1036121 | 2021-02-16 | Hamilton | Ohio | 39061 | 71245 | 913 |
1032876 | 1032876 | 2021-02-15 | Hamilton | Ohio | 39061 | 71123 | 909 |
1029630 | 1029630 | 2021-02-14 | Hamilton | Ohio | 39061 | 70979 | 909 |
1026383 | 1026383 | 2021-02-13 | Hamilton | Ohio | 39061 | 70822 | 909 |
1023138 | 1023138 | 2021-02-12 | Hamilton | Ohio | 39061 | 70556 | 768 |
1019893 | 1019893 | 2021-02-11 | Hamilton | Ohio | 39061 | 70320 | 538 |
1016648 | 1016648 | 2021-02-10 | Hamilton | Ohio | 39061 | 70101 | 488 |
1013403 | 1013403 | 2021-02-09 | Hamilton | Ohio | 39061 | 69858 | 487 |
1010158 | 1010158 | 2021-02-08 | Hamilton | Ohio | 39061 | 69562 | 485 |
1006912 | 1006912 | 2021-02-07 | Hamilton | Ohio | 39061 | 69411 | 475 |
1003666 | 1003666 | 2021-02-06 | Hamilton | Ohio | 39061 | 69226 | 474 |
1000420 | 1000420 | 2021-02-05 | Hamilton | Ohio | 39061 | 68885 | 473 |
997174 | 997174 | 2021-02-04 | Hamilton | Ohio | 39061 | 68541 | 468 |
993928 | 993928 | 2021-02-03 | Hamilton | Ohio | 39061 | 68156 | 465 |
990682 | 990682 | 2021-02-02 | Hamilton | Ohio | 39061 | 67772 | 460 |
987436 | 987436 | 2021-02-01 | Hamilton | Ohio | 39061 | 67394 | 460 |
984189 | 984189 | 2021-01-31 | Hamilton | Ohio | 39061 | 67154 | 460 |
980942 | 980942 | 2021-01-30 | Hamilton | Ohio | 39061 | 66862 | 460 |
977696 | 977696 | 2021-01-29 | Hamilton | Ohio | 39061 | 66481 | 459 |
974451 | 974451 | 2021-01-28 | Hamilton | Ohio | 39061 | 66124 | 457 |
971206 | 971206 | 2021-01-27 | Hamilton | Ohio | 39061 | 65638 | 457 |
967961 | 967961 | 2021-01-26 | Hamilton | Ohio | 39061 | 65148 | 455 |
964717 | 964717 | 2021-01-25 | Hamilton | Ohio | 39061 | 64744 | 448 |
961472 | 961472 | 2021-01-24 | Hamilton | Ohio | 39061 | 64392 | 448 |
958227 | 958227 | 2021-01-23 | Hamilton | Ohio | 39061 | 64017 | 448 |
954981 | 954981 | 2021-01-22 | Hamilton | Ohio | 39061 | 63509 | 448 |
951736 | 951736 | 2021-01-21 | Hamilton | Ohio | 39061 | 63092 | 447 |
948491 | 948491 | 2021-01-20 | Hamilton | Ohio | 39061 | 62391 | 443 |
945245 | 945245 | 2021-01-19 | Hamilton | Ohio | 39061 | 61931 | 441 |
941998 | 941998 | 2021-01-18 | Hamilton | Ohio | 39061 | 61629 | 439 |
938753 | 938753 | 2021-01-17 | Hamilton | Ohio | 39061 | 61350 | 439 |
935508 | 935508 | 2021-01-16 | Hamilton | Ohio | 39061 | 60913 | 438 |
932263 | 932263 | 2021-01-15 | Hamilton | Ohio | 39061 | 60343 | 438 |
929018 | 929018 | 2021-01-14 | Hamilton | Ohio | 39061 | 59783 | 436 |
925773 | 925773 | 2021-01-13 | Hamilton | Ohio | 39061 | 59040 | 427 |
922527 | 922527 | 2021-01-12 | Hamilton | Ohio | 39061 | 58503 | 426 |
919282 | 919282 | 2021-01-11 | Hamilton | Ohio | 39061 | 57879 | 426 |
916037 | 916037 | 2021-01-10 | Hamilton | Ohio | 39061 | 57384 | 425 |
912792 | 912792 | 2021-01-09 | Hamilton | Ohio | 39061 | 56947 | 425 |
909547 | 909547 | 2021-01-08 | Hamilton | Ohio | 39061 | 56256 | 425 |
906302 | 906302 | 2021-01-07 | Hamilton | Ohio | 39061 | 55652 | 423 |
903056 | 903056 | 2021-01-06 | Hamilton | Ohio | 39061 | 54992 | 423 |
899811 | 899811 | 2021-01-05 | Hamilton | Ohio | 39061 | 54379 | 421 |
896566 | 896566 | 2021-01-04 | Hamilton | Ohio | 39061 | 53797 | 419 |
893320 | 893320 | 2021-01-03 | Hamilton | Ohio | 39061 | 53404 | 419 |
890074 | 890074 | 2021-01-02 | Hamilton | Ohio | 39061 | 52847 | 419 |
886827 | 886827 | 2021-01-01 | Hamilton | Ohio | 39061 | 51821 | 417 |
883582 | 883582 | 2020-12-31 | Hamilton | Ohio | 39061 | 51821 | 417 |
880337 | 880337 | 2020-12-30 | Hamilton | Ohio | 39061 | 51124 | 413 |
877092 | 877092 | 2020-12-29 | Hamilton | Ohio | 39061 | 50527 | 411 |
873847 | 873847 | 2020-12-28 | Hamilton | Ohio | 39061 | 49961 | 411 |
870602 | 870602 | 2020-12-27 | Hamilton | Ohio | 39061 | 49823 | 411 |
867357 | 867357 | 2020-12-26 | Hamilton | Ohio | 39061 | 49478 | 411 |
864112 | 864112 | 2020-12-25 | Hamilton | Ohio | 39061 | 48711 | 411 |
860867 | 860867 | 2020-12-24 | Hamilton | Ohio | 39061 | 48711 | 411 |
857622 | 857622 | 2020-12-23 | Hamilton | Ohio | 39061 | 48185 | 409 |
854377 | 854377 | 2020-12-22 | Hamilton | Ohio | 39061 | 47713 | 408 |
851132 | 851132 | 2020-12-21 | Hamilton | Ohio | 39061 | 47264 | 405 |
847887 | 847887 | 2020-12-20 | Hamilton | Ohio | 39061 | 46842 | 405 |
844642 | 844642 | 2020-12-19 | Hamilton | Ohio | 39061 | 46283 | 404 |
841396 | 841396 | 2020-12-18 | Hamilton | Ohio | 39061 | 45723 | 402 |
838151 | 838151 | 2020-12-17 | Hamilton | Ohio | 39061 | 45052 | 401 |
834905 | 834905 | 2020-12-16 | Hamilton | Ohio | 39061 | 44346 | 401 |
831659 | 831659 | 2020-12-15 | Hamilton | Ohio | 39061 | 43939 | 394 |
828412 | 828412 | 2020-12-14 | Hamilton | Ohio | 39061 | 43457 | 393 |
825166 | 825166 | 2020-12-13 | Hamilton | Ohio | 39061 | 43008 | 393 |
821919 | 821919 | 2020-12-12 | Hamilton | Ohio | 39061 | 42448 | 393 |
818673 | 818673 | 2020-12-11 | Hamilton | Ohio | 39061 | 41545 | 390 |
815427 | 815427 | 2020-12-10 | Hamilton | Ohio | 39061 | 40751 | 390 |
812181 | 812181 | 2020-12-09 | Hamilton | Ohio | 39061 | 39864 | 385 |
808937 | 808937 | 2020-12-08 | Hamilton | Ohio | 39061 | 39256 | 382 |
805692 | 805692 | 2020-12-07 | Hamilton | Ohio | 39061 | 37528 | 382 |
802447 | 802447 | 2020-12-06 | Hamilton | Ohio | 39061 | 36846 | 382 |
799202 | 799202 | 2020-12-05 | Hamilton | Ohio | 39061 | 36289 | 382 |
795957 | 795957 | 2020-12-04 | Hamilton | Ohio | 39061 | 35572 | 381 |
792712 | 792712 | 2020-12-03 | Hamilton | Ohio | 39061 | 34945 | 379 |
789467 | 789467 | 2020-12-02 | Hamilton | Ohio | 39061 | 34402 | 379 |
786222 | 786222 | 2020-12-01 | Hamilton | Ohio | 39061 | 33874 | 376 |
782978 | 782978 | 2020-11-30 | Hamilton | Ohio | 39061 | 33221 | 372 |
779732 | 779732 | 2020-11-29 | Hamilton | Ohio | 39061 | 32557 | 372 |
776487 | 776487 | 2020-11-28 | Hamilton | Ohio | 39061 | 32049 | 372 |
773242 | 773242 | 2020-11-27 | Hamilton | Ohio | 39061 | 31491 | 372 |
769997 | 769997 | 2020-11-26 | Hamilton | Ohio | 39061 | 30493 | 372 |
766751 | 766751 | 2020-11-25 | Hamilton | Ohio | 39061 | 30493 | 372 |
763506 | 763506 | 2020-11-24 | Hamilton | Ohio | 39061 | 29931 | 372 |
760261 | 760261 | 2020-11-23 | Hamilton | Ohio | 39061 | 29462 | 371 |
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);