ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Summit" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922573 | 922573 | 2021-01-12 | Summit | Ohio | 39153 | 31877 | 678 |
919328 | 919328 | 2021-01-11 | Summit | Ohio | 39153 | 31539 | 655 |
916083 | 916083 | 2021-01-10 | Summit | Ohio | 39153 | 31089 | 650 |
912838 | 912838 | 2021-01-09 | Summit | Ohio | 39153 | 30858 | 649 |
909593 | 909593 | 2021-01-08 | Summit | Ohio | 39153 | 30571 | 649 |
906348 | 906348 | 2021-01-07 | Summit | Ohio | 39153 | 30134 | 627 |
903102 | 903102 | 2021-01-06 | Summit | Ohio | 39153 | 29645 | 627 |
899857 | 899857 | 2021-01-05 | Summit | Ohio | 39153 | 29361 | 627 |
896612 | 896612 | 2021-01-04 | Summit | Ohio | 39153 | 29030 | 620 |
893366 | 893366 | 2021-01-03 | Summit | Ohio | 39153 | 28782 | 614 |
890120 | 890120 | 2021-01-02 | Summit | Ohio | 39153 | 28539 | 600 |
886873 | 886873 | 2021-01-01 | Summit | Ohio | 39153 | 28040 | 589 |
883628 | 883628 | 2020-12-31 | Summit | Ohio | 39153 | 28040 | 589 |
880383 | 880383 | 2020-12-30 | Summit | Ohio | 39153 | 27614 | 577 |
877138 | 877138 | 2020-12-29 | Summit | Ohio | 39153 | 27302 | 553 |
873893 | 873893 | 2020-12-28 | Summit | Ohio | 39153 | 26914 | 514 |
870648 | 870648 | 2020-12-27 | Summit | Ohio | 39153 | 26708 | 505 |
867403 | 867403 | 2020-12-26 | Summit | Ohio | 39153 | 26414 | 496 |
864158 | 864158 | 2020-12-25 | Summit | Ohio | 39153 | 25954 | 496 |
860913 | 860913 | 2020-12-24 | Summit | Ohio | 39153 | 25954 | 496 |
857668 | 857668 | 2020-12-23 | Summit | Ohio | 39153 | 25647 | 495 |
854423 | 854423 | 2020-12-22 | Summit | Ohio | 39153 | 25305 | 492 |
851178 | 851178 | 2020-12-21 | Summit | Ohio | 39153 | 24859 | 491 |
847933 | 847933 | 2020-12-20 | Summit | Ohio | 39153 | 24560 | 490 |
844688 | 844688 | 2020-12-19 | Summit | Ohio | 39153 | 24258 | 486 |
841442 | 841442 | 2020-12-18 | Summit | Ohio | 39153 | 23872 | 482 |
838197 | 838197 | 2020-12-17 | Summit | Ohio | 39153 | 23394 | 480 |
834951 | 834951 | 2020-12-16 | Summit | Ohio | 39153 | 22903 | 469 |
831705 | 831705 | 2020-12-15 | Summit | Ohio | 39153 | 22716 | 463 |
828458 | 828458 | 2020-12-14 | Summit | Ohio | 39153 | 22244 | 460 |
825212 | 825212 | 2020-12-13 | Summit | Ohio | 39153 | 21898 | 447 |
821965 | 821965 | 2020-12-12 | Summit | Ohio | 39153 | 21501 | 447 |
818719 | 818719 | 2020-12-11 | Summit | Ohio | 39153 | 20931 | 444 |
815473 | 815473 | 2020-12-10 | Summit | Ohio | 39153 | 20545 | 423 |
812227 | 812227 | 2020-12-09 | Summit | Ohio | 39153 | 19957 | 421 |
808983 | 808983 | 2020-12-08 | Summit | Ohio | 39153 | 19312 | 420 |
805738 | 805738 | 2020-12-07 | Summit | Ohio | 39153 | 18131 | 408 |
802493 | 802493 | 2020-12-06 | Summit | Ohio | 39153 | 17736 | 401 |
799248 | 799248 | 2020-12-05 | Summit | Ohio | 39153 | 17470 | 399 |
796003 | 796003 | 2020-12-04 | Summit | Ohio | 39153 | 17017 | 393 |
792758 | 792758 | 2020-12-03 | Summit | Ohio | 39153 | 16486 | 374 |
789513 | 789513 | 2020-12-02 | Summit | Ohio | 39153 | 16220 | 360 |
786268 | 786268 | 2020-12-01 | Summit | Ohio | 39153 | 15936 | 360 |
783024 | 783024 | 2020-11-30 | Summit | Ohio | 39153 | 15417 | 349 |
779778 | 779778 | 2020-11-29 | Summit | Ohio | 39153 | 15205 | 337 |
776533 | 776533 | 2020-11-28 | Summit | Ohio | 39153 | 14905 | 333 |
773288 | 773288 | 2020-11-27 | Summit | Ohio | 39153 | 14667 | 330 |
770043 | 770043 | 2020-11-26 | Summit | Ohio | 39153 | 13933 | 327 |
766797 | 766797 | 2020-11-25 | Summit | Ohio | 39153 | 13933 | 327 |
763552 | 763552 | 2020-11-24 | Summit | Ohio | 39153 | 13388 | 316 |
760307 | 760307 | 2020-11-23 | Summit | Ohio | 39153 | 12962 | 310 |
757062 | 757062 | 2020-11-22 | Summit | Ohio | 39153 | 12431 | 309 |
753815 | 753815 | 2020-11-21 | Summit | Ohio | 39153 | 12143 | 308 |
750569 | 750569 | 2020-11-20 | Summit | Ohio | 39153 | 11890 | 307 |
747323 | 747323 | 2020-11-19 | Summit | Ohio | 39153 | 11659 | 300 |
744077 | 744077 | 2020-11-18 | Summit | Ohio | 39153 | 11346 | 299 |
740830 | 740830 | 2020-11-17 | Summit | Ohio | 39153 | 11152 | 292 |
737584 | 737584 | 2020-11-16 | Summit | Ohio | 39153 | 10802 | 291 |
734340 | 734340 | 2020-11-15 | Summit | Ohio | 39153 | 10529 | 290 |
731094 | 731094 | 2020-11-14 | Summit | Ohio | 39153 | 10245 | 289 |
727850 | 727850 | 2020-11-13 | Summit | Ohio | 39153 | 10024 | 287 |
724606 | 724606 | 2020-11-12 | Summit | Ohio | 39153 | 9676 | 286 |
721363 | 721363 | 2020-11-11 | Summit | Ohio | 39153 | 9291 | 280 |
718120 | 718120 | 2020-11-10 | Summit | Ohio | 39153 | 9088 | 280 |
714877 | 714877 | 2020-11-09 | Summit | Ohio | 39153 | 8800 | 280 |
711633 | 711633 | 2020-11-08 | Summit | Ohio | 39153 | 8680 | 280 |
708389 | 708389 | 2020-11-07 | Summit | Ohio | 39153 | 8488 | 280 |
705146 | 705146 | 2020-11-06 | Summit | Ohio | 39153 | 8329 | 280 |
701903 | 701903 | 2020-11-05 | Summit | Ohio | 39153 | 8145 | 280 |
698659 | 698659 | 2020-11-04 | Summit | Ohio | 39153 | 7985 | 279 |
695416 | 695416 | 2020-11-03 | Summit | Ohio | 39153 | 7843 | 276 |
692174 | 692174 | 2020-11-02 | Summit | Ohio | 39153 | 7678 | 274 |
688930 | 688930 | 2020-11-01 | Summit | Ohio | 39153 | 7580 | 272 |
685685 | 685685 | 2020-10-31 | Summit | Ohio | 39153 | 7508 | 272 |
682442 | 682442 | 2020-10-30 | Summit | Ohio | 39153 | 7409 | 272 |
679199 | 679199 | 2020-10-29 | Summit | Ohio | 39153 | 7316 | 272 |
675956 | 675956 | 2020-10-28 | Summit | Ohio | 39153 | 7195 | 270 |
672713 | 672713 | 2020-10-27 | Summit | Ohio | 39153 | 7109 | 269 |
669471 | 669471 | 2020-10-26 | Summit | Ohio | 39153 | 6978 | 269 |
666227 | 666227 | 2020-10-25 | Summit | Ohio | 39153 | 6925 | 266 |
662982 | 662982 | 2020-10-24 | Summit | Ohio | 39153 | 6846 | 266 |
659738 | 659738 | 2020-10-23 | Summit | Ohio | 39153 | 6780 | 265 |
656494 | 656494 | 2020-10-22 | Summit | Ohio | 39153 | 6689 | 265 |
653249 | 653249 | 2020-10-21 | Summit | Ohio | 39153 | 6620 | 265 |
650004 | 650004 | 2020-10-20 | Summit | Ohio | 39153 | 6555 | 261 |
646760 | 646760 | 2020-10-19 | Summit | Ohio | 39153 | 6476 | 260 |
643514 | 643514 | 2020-10-18 | Summit | Ohio | 39153 | 6406 | 260 |
640266 | 640266 | 2020-10-17 | Summit | Ohio | 39153 | 6341 | 260 |
637020 | 637020 | 2020-10-16 | Summit | Ohio | 39153 | 6242 | 259 |
633774 | 633774 | 2020-10-15 | Summit | Ohio | 39153 | 6167 | 259 |
630529 | 630529 | 2020-10-14 | Summit | Ohio | 39153 | 6084 | 259 |
627285 | 627285 | 2020-10-13 | Summit | Ohio | 39153 | 6032 | 258 |
624043 | 624043 | 2020-10-12 | Summit | Ohio | 39153 | 5943 | 258 |
620800 | 620800 | 2020-10-11 | Summit | Ohio | 39153 | 5894 | 258 |
617558 | 617558 | 2020-10-10 | Summit | Ohio | 39153 | 5845 | 258 |
614316 | 614316 | 2020-10-09 | Summit | Ohio | 39153 | 5813 | 258 |
611075 | 611075 | 2020-10-08 | Summit | Ohio | 39153 | 5753 | 259 |
607833 | 607833 | 2020-10-07 | Summit | Ohio | 39153 | 5710 | 259 |
604590 | 604590 | 2020-10-06 | Summit | Ohio | 39153 | 5661 | 254 |
601348 | 601348 | 2020-10-05 | Summit | Ohio | 39153 | 5613 | 253 |
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);