ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 39099 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055615 | 1055615 | 2021-02-22 | Mahoning | Ohio | 39099 | 19183 | 532 |
1052369 | 1052369 | 2021-02-21 | Mahoning | Ohio | 39099 | 19140 | 531 |
1049122 | 1049122 | 2021-02-20 | Mahoning | Ohio | 39099 | 19117 | 530 |
1045875 | 1045875 | 2021-02-19 | Mahoning | Ohio | 39099 | 19072 | 528 |
1042630 | 1042630 | 2021-02-18 | Mahoning | Ohio | 39099 | 19034 | 530 |
1039385 | 1039385 | 2021-02-17 | Mahoning | Ohio | 39099 | 18987 | 527 |
1036140 | 1036140 | 2021-02-16 | Mahoning | Ohio | 39099 | 18947 | 525 |
1032895 | 1032895 | 2021-02-15 | Mahoning | Ohio | 39099 | 18896 | 521 |
1029649 | 1029649 | 2021-02-14 | Mahoning | Ohio | 39099 | 18852 | 519 |
1026402 | 1026402 | 2021-02-13 | Mahoning | Ohio | 39099 | 18817 | 519 |
1023157 | 1023157 | 2021-02-12 | Mahoning | Ohio | 39099 | 18774 | 472 |
1019912 | 1019912 | 2021-02-11 | Mahoning | Ohio | 39099 | 18713 | 379 |
1016667 | 1016667 | 2021-02-10 | Mahoning | Ohio | 39099 | 18658 | 345 |
1013422 | 1013422 | 2021-02-09 | Mahoning | Ohio | 39099 | 18579 | 345 |
1010177 | 1010177 | 2021-02-08 | Mahoning | Ohio | 39099 | 18530 | 342 |
1006931 | 1006931 | 2021-02-07 | Mahoning | Ohio | 39099 | 18470 | 342 |
1003685 | 1003685 | 2021-02-06 | Mahoning | Ohio | 39099 | 18441 | 342 |
1000439 | 1000439 | 2021-02-05 | Mahoning | Ohio | 39099 | 18390 | 340 |
997193 | 997193 | 2021-02-04 | Mahoning | Ohio | 39099 | 18315 | 340 |
993947 | 993947 | 2021-02-03 | Mahoning | Ohio | 39099 | 18229 | 339 |
990701 | 990701 | 2021-02-02 | Mahoning | Ohio | 39099 | 18135 | 339 |
987455 | 987455 | 2021-02-01 | Mahoning | Ohio | 39099 | 18058 | 339 |
984208 | 984208 | 2021-01-31 | Mahoning | Ohio | 39099 | 17999 | 339 |
980961 | 980961 | 2021-01-30 | Mahoning | Ohio | 39099 | 17953 | 339 |
977715 | 977715 | 2021-01-29 | Mahoning | Ohio | 39099 | 17861 | 339 |
974470 | 974470 | 2021-01-28 | Mahoning | Ohio | 39099 | 17761 | 339 |
971225 | 971225 | 2021-01-27 | Mahoning | Ohio | 39099 | 17654 | 339 |
967980 | 967980 | 2021-01-26 | Mahoning | Ohio | 39099 | 17561 | 339 |
964736 | 964736 | 2021-01-25 | Mahoning | Ohio | 39099 | 17471 | 339 |
961491 | 961491 | 2021-01-24 | Mahoning | Ohio | 39099 | 17383 | 338 |
958246 | 958246 | 2021-01-23 | Mahoning | Ohio | 39099 | 17321 | 338 |
955000 | 955000 | 2021-01-22 | Mahoning | Ohio | 39099 | 17215 | 337 |
951755 | 951755 | 2021-01-21 | Mahoning | Ohio | 39099 | 17163 | 337 |
948510 | 948510 | 2021-01-20 | Mahoning | Ohio | 39099 | 17035 | 337 |
945264 | 945264 | 2021-01-19 | Mahoning | Ohio | 39099 | 16931 | 337 |
942017 | 942017 | 2021-01-18 | Mahoning | Ohio | 39099 | 16815 | 336 |
938772 | 938772 | 2021-01-17 | Mahoning | Ohio | 39099 | 16758 | 335 |
935527 | 935527 | 2021-01-16 | Mahoning | Ohio | 39099 | 16710 | 335 |
932282 | 932282 | 2021-01-15 | Mahoning | Ohio | 39099 | 16567 | 335 |
929037 | 929037 | 2021-01-14 | Mahoning | Ohio | 39099 | 16430 | 334 |
925792 | 925792 | 2021-01-13 | Mahoning | Ohio | 39099 | 16299 | 326 |
922546 | 922546 | 2021-01-12 | Mahoning | Ohio | 39099 | 16219 | 325 |
919301 | 919301 | 2021-01-11 | Mahoning | Ohio | 39099 | 16104 | 325 |
916056 | 916056 | 2021-01-10 | Mahoning | Ohio | 39099 | 15983 | 325 |
912811 | 912811 | 2021-01-09 | Mahoning | Ohio | 39099 | 15904 | 325 |
909566 | 909566 | 2021-01-08 | Mahoning | Ohio | 39099 | 15818 | 315 |
906321 | 906321 | 2021-01-07 | Mahoning | Ohio | 39099 | 15684 | 315 |
903075 | 903075 | 2021-01-06 | Mahoning | Ohio | 39099 | 15529 | 315 |
899830 | 899830 | 2021-01-05 | Mahoning | Ohio | 39099 | 15399 | 315 |
896585 | 896585 | 2021-01-04 | Mahoning | Ohio | 39099 | 15269 | 315 |
893339 | 893339 | 2021-01-03 | Mahoning | Ohio | 39099 | 15131 | 315 |
890093 | 890093 | 2021-01-02 | Mahoning | Ohio | 39099 | 15047 | 315 |
886846 | 886846 | 2021-01-01 | Mahoning | Ohio | 39099 | 14800 | 315 |
883601 | 883601 | 2020-12-31 | Mahoning | Ohio | 39099 | 14800 | 315 |
880356 | 880356 | 2020-12-30 | Mahoning | Ohio | 39099 | 14631 | 313 |
877111 | 877111 | 2020-12-29 | Mahoning | Ohio | 39099 | 14418 | 312 |
873866 | 873866 | 2020-12-28 | Mahoning | Ohio | 39099 | 14309 | 312 |
870621 | 870621 | 2020-12-27 | Mahoning | Ohio | 39099 | 14237 | 312 |
867376 | 867376 | 2020-12-26 | Mahoning | Ohio | 39099 | 14162 | 312 |
864131 | 864131 | 2020-12-25 | Mahoning | Ohio | 39099 | 13929 | 312 |
860886 | 860886 | 2020-12-24 | Mahoning | Ohio | 39099 | 13929 | 312 |
857641 | 857641 | 2020-12-23 | Mahoning | Ohio | 39099 | 13780 | 311 |
854396 | 854396 | 2020-12-22 | Mahoning | Ohio | 39099 | 13345 | 311 |
851151 | 851151 | 2020-12-21 | Mahoning | Ohio | 39099 | 13122 | 311 |
847906 | 847906 | 2020-12-20 | Mahoning | Ohio | 39099 | 12999 | 311 |
844661 | 844661 | 2020-12-19 | Mahoning | Ohio | 39099 | 12795 | 311 |
841415 | 841415 | 2020-12-18 | Mahoning | Ohio | 39099 | 12658 | 311 |
838170 | 838170 | 2020-12-17 | Mahoning | Ohio | 39099 | 12458 | 311 |
834924 | 834924 | 2020-12-16 | Mahoning | Ohio | 39099 | 12229 | 311 |
831678 | 831678 | 2020-12-15 | Mahoning | Ohio | 39099 | 12083 | 311 |
828431 | 828431 | 2020-12-14 | Mahoning | Ohio | 39099 | 11852 | 310 |
825185 | 825185 | 2020-12-13 | Mahoning | Ohio | 39099 | 11716 | 310 |
821938 | 821938 | 2020-12-12 | Mahoning | Ohio | 39099 | 11508 | 310 |
818692 | 818692 | 2020-12-11 | Mahoning | Ohio | 39099 | 11297 | 311 |
815446 | 815446 | 2020-12-10 | Mahoning | Ohio | 39099 | 11096 | 310 |
812200 | 812200 | 2020-12-09 | Mahoning | Ohio | 39099 | 10822 | 308 |
808956 | 808956 | 2020-12-08 | Mahoning | Ohio | 39099 | 10636 | 307 |
805711 | 805711 | 2020-12-07 | Mahoning | Ohio | 39099 | 9854 | 307 |
802466 | 802466 | 2020-12-06 | Mahoning | Ohio | 39099 | 9630 | 305 |
799221 | 799221 | 2020-12-05 | Mahoning | Ohio | 39099 | 9489 | 305 |
795976 | 795976 | 2020-12-04 | Mahoning | Ohio | 39099 | 9296 | 305 |
792731 | 792731 | 2020-12-03 | Mahoning | Ohio | 39099 | 9092 | 303 |
789486 | 789486 | 2020-12-02 | Mahoning | Ohio | 39099 | 8821 | 303 |
786241 | 786241 | 2020-12-01 | Mahoning | Ohio | 39099 | 8647 | 302 |
782997 | 782997 | 2020-11-30 | Mahoning | Ohio | 39099 | 8405 | 301 |
779751 | 779751 | 2020-11-29 | Mahoning | Ohio | 39099 | 8282 | 301 |
776506 | 776506 | 2020-11-28 | Mahoning | Ohio | 39099 | 8123 | 301 |
773261 | 773261 | 2020-11-27 | Mahoning | Ohio | 39099 | 7985 | 301 |
770016 | 770016 | 2020-11-26 | Mahoning | Ohio | 39099 | 7530 | 300 |
766770 | 766770 | 2020-11-25 | Mahoning | Ohio | 39099 | 7530 | 300 |
763525 | 763525 | 2020-11-24 | Mahoning | Ohio | 39099 | 7276 | 299 |
760280 | 760280 | 2020-11-23 | Mahoning | Ohio | 39099 | 7068 | 299 |
757035 | 757035 | 2020-11-22 | Mahoning | Ohio | 39099 | 6772 | 299 |
753788 | 753788 | 2020-11-21 | Mahoning | Ohio | 39099 | 6643 | 299 |
750542 | 750542 | 2020-11-20 | Mahoning | Ohio | 39099 | 6459 | 299 |
747296 | 747296 | 2020-11-19 | Mahoning | Ohio | 39099 | 6141 | 298 |
744050 | 744050 | 2020-11-18 | Mahoning | Ohio | 39099 | 5941 | 297 |
740803 | 740803 | 2020-11-17 | Mahoning | Ohio | 39099 | 5815 | 297 |
737557 | 737557 | 2020-11-16 | Mahoning | Ohio | 39099 | 5644 | 295 |
734313 | 734313 | 2020-11-15 | Mahoning | Ohio | 39099 | 5492 | 295 |
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);