ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Mahoning" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
731067 | 731067 | 2020-11-14 | Mahoning | Ohio | 39099 | 5333 | 295 |
727823 | 727823 | 2020-11-13 | Mahoning | Ohio | 39099 | 5234 | 295 |
724579 | 724579 | 2020-11-12 | Mahoning | Ohio | 39099 | 5065 | 293 |
721336 | 721336 | 2020-11-11 | Mahoning | Ohio | 39099 | 4945 | 293 |
718093 | 718093 | 2020-11-10 | Mahoning | Ohio | 39099 | 4834 | 287 |
714850 | 714850 | 2020-11-09 | Mahoning | Ohio | 39099 | 4722 | 287 |
711606 | 711606 | 2020-11-08 | Mahoning | Ohio | 39099 | 4638 | 287 |
708362 | 708362 | 2020-11-07 | Mahoning | Ohio | 39099 | 4568 | 287 |
705119 | 705119 | 2020-11-06 | Mahoning | Ohio | 39099 | 4472 | 287 |
701876 | 701876 | 2020-11-05 | Mahoning | Ohio | 39099 | 4401 | 287 |
698632 | 698632 | 2020-11-04 | Mahoning | Ohio | 39099 | 4319 | 287 |
695389 | 695389 | 2020-11-03 | Mahoning | Ohio | 39099 | 4243 | 287 |
692147 | 692147 | 2020-11-02 | Mahoning | Ohio | 39099 | 4146 | 287 |
688903 | 688903 | 2020-11-01 | Mahoning | Ohio | 39099 | 4090 | 287 |
685658 | 685658 | 2020-10-31 | Mahoning | Ohio | 39099 | 4042 | 287 |
682415 | 682415 | 2020-10-30 | Mahoning | Ohio | 39099 | 4006 | 287 |
679172 | 679172 | 2020-10-29 | Mahoning | Ohio | 39099 | 3960 | 287 |
675929 | 675929 | 2020-10-28 | Mahoning | Ohio | 39099 | 3910 | 287 |
672686 | 672686 | 2020-10-27 | Mahoning | Ohio | 39099 | 3889 | 287 |
669444 | 669444 | 2020-10-26 | Mahoning | Ohio | 39099 | 3863 | 287 |
666200 | 666200 | 2020-10-25 | Mahoning | Ohio | 39099 | 3810 | 287 |
662955 | 662955 | 2020-10-24 | Mahoning | Ohio | 39099 | 3779 | 287 |
659711 | 659711 | 2020-10-23 | Mahoning | Ohio | 39099 | 3739 | 287 |
656467 | 656467 | 2020-10-22 | Mahoning | Ohio | 39099 | 3709 | 286 |
653222 | 653222 | 2020-10-21 | Mahoning | Ohio | 39099 | 3660 | 286 |
649977 | 649977 | 2020-10-20 | Mahoning | Ohio | 39099 | 3635 | 283 |
646733 | 646733 | 2020-10-19 | Mahoning | Ohio | 39099 | 3605 | 283 |
643487 | 643487 | 2020-10-18 | Mahoning | Ohio | 39099 | 3567 | 283 |
640239 | 640239 | 2020-10-17 | Mahoning | Ohio | 39099 | 3544 | 283 |
636993 | 636993 | 2020-10-16 | Mahoning | Ohio | 39099 | 3515 | 283 |
633747 | 633747 | 2020-10-15 | Mahoning | Ohio | 39099 | 3476 | 283 |
630502 | 630502 | 2020-10-14 | Mahoning | Ohio | 39099 | 3425 | 283 |
627258 | 627258 | 2020-10-13 | Mahoning | Ohio | 39099 | 3400 | 282 |
624016 | 624016 | 2020-10-12 | Mahoning | Ohio | 39099 | 3388 | 282 |
620773 | 620773 | 2020-10-11 | Mahoning | Ohio | 39099 | 3371 | 282 |
617531 | 617531 | 2020-10-10 | Mahoning | Ohio | 39099 | 3352 | 282 |
614289 | 614289 | 2020-10-09 | Mahoning | Ohio | 39099 | 3341 | 282 |
611048 | 611048 | 2020-10-08 | Mahoning | Ohio | 39099 | 3316 | 282 |
607806 | 607806 | 2020-10-07 | Mahoning | Ohio | 39099 | 3289 | 282 |
604563 | 604563 | 2020-10-06 | Mahoning | Ohio | 39099 | 3271 | 282 |
601321 | 601321 | 2020-10-05 | Mahoning | Ohio | 39099 | 3249 | 282 |
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);