ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Lorain", fips = 39093 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
948507 | 948507 | 2021-01-20 | Lorain | Ohio | 39093 | 18599 | 212 |
945261 | 945261 | 2021-01-19 | Lorain | Ohio | 39093 | 18418 | 212 |
942014 | 942014 | 2021-01-18 | Lorain | Ohio | 39093 | 18217 | 212 |
938769 | 938769 | 2021-01-17 | Lorain | Ohio | 39093 | 18086 | 212 |
935524 | 935524 | 2021-01-16 | Lorain | Ohio | 39093 | 17916 | 207 |
932279 | 932279 | 2021-01-15 | Lorain | Ohio | 39093 | 17708 | 207 |
929034 | 929034 | 2021-01-14 | Lorain | Ohio | 39093 | 17563 | 207 |
925789 | 925789 | 2021-01-13 | Lorain | Ohio | 39093 | 17335 | 202 |
922543 | 922543 | 2021-01-12 | Lorain | Ohio | 39093 | 17196 | 201 |
919298 | 919298 | 2021-01-11 | Lorain | Ohio | 39093 | 17071 | 200 |
916053 | 916053 | 2021-01-10 | Lorain | Ohio | 39093 | 16771 | 200 |
912808 | 912808 | 2021-01-09 | Lorain | Ohio | 39093 | 16612 | 200 |
909563 | 909563 | 2021-01-08 | Lorain | Ohio | 39093 | 16425 | 193 |
906318 | 906318 | 2021-01-07 | Lorain | Ohio | 39093 | 16187 | 188 |
903072 | 903072 | 2021-01-06 | Lorain | Ohio | 39093 | 15924 | 188 |
899827 | 899827 | 2021-01-05 | Lorain | Ohio | 39093 | 15790 | 185 |
896582 | 896582 | 2021-01-04 | Lorain | Ohio | 39093 | 15622 | 184 |
893336 | 893336 | 2021-01-03 | Lorain | Ohio | 39093 | 15421 | 184 |
890090 | 890090 | 2021-01-02 | Lorain | Ohio | 39093 | 15231 | 162 |
886843 | 886843 | 2021-01-01 | Lorain | Ohio | 39093 | 14786 | 162 |
883598 | 883598 | 2020-12-31 | Lorain | Ohio | 39093 | 14786 | 162 |
880353 | 880353 | 2020-12-30 | Lorain | Ohio | 39093 | 14549 | 161 |
877108 | 877108 | 2020-12-29 | Lorain | Ohio | 39093 | 14338 | 161 |
873863 | 873863 | 2020-12-28 | Lorain | Ohio | 39093 | 14189 | 148 |
870618 | 870618 | 2020-12-27 | Lorain | Ohio | 39093 | 14042 | 145 |
867373 | 867373 | 2020-12-26 | Lorain | Ohio | 39093 | 13910 | 144 |
864128 | 864128 | 2020-12-25 | Lorain | Ohio | 39093 | 13619 | 144 |
860883 | 860883 | 2020-12-24 | Lorain | Ohio | 39093 | 13619 | 144 |
857638 | 857638 | 2020-12-23 | Lorain | Ohio | 39093 | 13342 | 144 |
854393 | 854393 | 2020-12-22 | Lorain | Ohio | 39093 | 13215 | 144 |
851148 | 851148 | 2020-12-21 | Lorain | Ohio | 39093 | 13045 | 143 |
847903 | 847903 | 2020-12-20 | Lorain | Ohio | 39093 | 12905 | 143 |
844658 | 844658 | 2020-12-19 | Lorain | Ohio | 39093 | 12672 | 143 |
841412 | 841412 | 2020-12-18 | Lorain | Ohio | 39093 | 12438 | 143 |
838167 | 838167 | 2020-12-17 | Lorain | Ohio | 39093 | 12162 | 139 |
834921 | 834921 | 2020-12-16 | Lorain | Ohio | 39093 | 11879 | 132 |
831675 | 831675 | 2020-12-15 | Lorain | Ohio | 39093 | 11782 | 128 |
828428 | 828428 | 2020-12-14 | Lorain | Ohio | 39093 | 11648 | 128 |
825182 | 825182 | 2020-12-13 | Lorain | Ohio | 39093 | 11410 | 122 |
821935 | 821935 | 2020-12-12 | Lorain | Ohio | 39093 | 11143 | 122 |
818689 | 818689 | 2020-12-11 | Lorain | Ohio | 39093 | 10874 | 122 |
815443 | 815443 | 2020-12-10 | Lorain | Ohio | 39093 | 10684 | 122 |
812197 | 812197 | 2020-12-09 | Lorain | Ohio | 39093 | 10432 | 122 |
808953 | 808953 | 2020-12-08 | Lorain | Ohio | 39093 | 10195 | 117 |
805708 | 805708 | 2020-12-07 | Lorain | Ohio | 39093 | 9145 | 116 |
802463 | 802463 | 2020-12-06 | Lorain | Ohio | 39093 | 8778 | 116 |
799218 | 799218 | 2020-12-05 | Lorain | Ohio | 39093 | 8592 | 116 |
795973 | 795973 | 2020-12-04 | Lorain | Ohio | 39093 | 8368 | 114 |
792728 | 792728 | 2020-12-03 | Lorain | Ohio | 39093 | 8213 | 106 |
789483 | 789483 | 2020-12-02 | Lorain | Ohio | 39093 | 8020 | 106 |
786238 | 786238 | 2020-12-01 | Lorain | Ohio | 39093 | 7854 | 106 |
782994 | 782994 | 2020-11-30 | Lorain | Ohio | 39093 | 7654 | 106 |
779748 | 779748 | 2020-11-29 | Lorain | Ohio | 39093 | 7475 | 106 |
776503 | 776503 | 2020-11-28 | Lorain | Ohio | 39093 | 7265 | 106 |
773258 | 773258 | 2020-11-27 | Lorain | Ohio | 39093 | 7149 | 106 |
770013 | 770013 | 2020-11-26 | Lorain | Ohio | 39093 | 6690 | 106 |
766767 | 766767 | 2020-11-25 | Lorain | Ohio | 39093 | 6690 | 106 |
763522 | 763522 | 2020-11-24 | Lorain | Ohio | 39093 | 6434 | 99 |
760277 | 760277 | 2020-11-23 | Lorain | Ohio | 39093 | 6236 | 97 |
757032 | 757032 | 2020-11-22 | Lorain | Ohio | 39093 | 5902 | 97 |
753785 | 753785 | 2020-11-21 | Lorain | Ohio | 39093 | 5644 | 97 |
750539 | 750539 | 2020-11-20 | Lorain | Ohio | 39093 | 5565 | 97 |
747293 | 747293 | 2020-11-19 | Lorain | Ohio | 39093 | 5320 | 97 |
744047 | 744047 | 2020-11-18 | Lorain | Ohio | 39093 | 5148 | 96 |
740800 | 740800 | 2020-11-17 | Lorain | Ohio | 39093 | 5040 | 95 |
737554 | 737554 | 2020-11-16 | Lorain | Ohio | 39093 | 4899 | 95 |
734310 | 734310 | 2020-11-15 | Lorain | Ohio | 39093 | 4711 | 94 |
731064 | 731064 | 2020-11-14 | Lorain | Ohio | 39093 | 4505 | 94 |
727820 | 727820 | 2020-11-13 | Lorain | Ohio | 39093 | 4363 | 94 |
724576 | 724576 | 2020-11-12 | Lorain | Ohio | 39093 | 4167 | 93 |
721333 | 721333 | 2020-11-11 | Lorain | Ohio | 39093 | 3997 | 93 |
718090 | 718090 | 2020-11-10 | Lorain | Ohio | 39093 | 3866 | 93 |
714847 | 714847 | 2020-11-09 | Lorain | Ohio | 39093 | 3760 | 93 |
711603 | 711603 | 2020-11-08 | Lorain | Ohio | 39093 | 3629 | 93 |
708359 | 708359 | 2020-11-07 | Lorain | Ohio | 39093 | 3552 | 93 |
705116 | 705116 | 2020-11-06 | Lorain | Ohio | 39093 | 3435 | 93 |
701873 | 701873 | 2020-11-05 | Lorain | Ohio | 39093 | 3384 | 92 |
698629 | 698629 | 2020-11-04 | Lorain | Ohio | 39093 | 3296 | 91 |
695386 | 695386 | 2020-11-03 | Lorain | Ohio | 39093 | 3239 | 91 |
692144 | 692144 | 2020-11-02 | Lorain | Ohio | 39093 | 3191 | 91 |
688900 | 688900 | 2020-11-01 | Lorain | Ohio | 39093 | 3146 | 91 |
685655 | 685655 | 2020-10-31 | Lorain | Ohio | 39093 | 3094 | 91 |
682412 | 682412 | 2020-10-30 | Lorain | Ohio | 39093 | 3049 | 91 |
679169 | 679169 | 2020-10-29 | Lorain | Ohio | 39093 | 2998 | 90 |
675926 | 675926 | 2020-10-28 | Lorain | Ohio | 39093 | 2927 | 90 |
672683 | 672683 | 2020-10-27 | Lorain | Ohio | 39093 | 2897 | 90 |
669441 | 669441 | 2020-10-26 | Lorain | Ohio | 39093 | 2862 | 89 |
666197 | 666197 | 2020-10-25 | Lorain | Ohio | 39093 | 2815 | 89 |
662952 | 662952 | 2020-10-24 | Lorain | Ohio | 39093 | 2789 | 89 |
659708 | 659708 | 2020-10-23 | Lorain | Ohio | 39093 | 2754 | 89 |
656464 | 656464 | 2020-10-22 | Lorain | Ohio | 39093 | 2728 | 89 |
653219 | 653219 | 2020-10-21 | Lorain | Ohio | 39093 | 2692 | 89 |
649974 | 649974 | 2020-10-20 | Lorain | Ohio | 39093 | 2666 | 89 |
646730 | 646730 | 2020-10-19 | Lorain | Ohio | 39093 | 2654 | 89 |
643484 | 643484 | 2020-10-18 | Lorain | Ohio | 39093 | 2623 | 89 |
640236 | 640236 | 2020-10-17 | Lorain | Ohio | 39093 | 2596 | 89 |
636990 | 636990 | 2020-10-16 | Lorain | Ohio | 39093 | 2569 | 89 |
633744 | 633744 | 2020-10-15 | Lorain | Ohio | 39093 | 2550 | 89 |
630499 | 630499 | 2020-10-14 | Lorain | Ohio | 39093 | 2528 | 89 |
627255 | 627255 | 2020-10-13 | Lorain | Ohio | 39093 | 2513 | 89 |
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);