ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 39023 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055577 | 1055577 | 2021-02-22 | Clark | Ohio | 39023 | 12101 | 331 |
1052331 | 1052331 | 2021-02-21 | Clark | Ohio | 39023 | 12082 | 330 |
1049084 | 1049084 | 2021-02-20 | Clark | Ohio | 39023 | 12064 | 329 |
1045837 | 1045837 | 2021-02-19 | Clark | Ohio | 39023 | 12046 | 328 |
1042592 | 1042592 | 2021-02-18 | Clark | Ohio | 39023 | 12018 | 320 |
1039347 | 1039347 | 2021-02-17 | Clark | Ohio | 39023 | 11995 | 317 |
1036102 | 1036102 | 2021-02-16 | Clark | Ohio | 39023 | 11978 | 317 |
1032857 | 1032857 | 2021-02-15 | Clark | Ohio | 39023 | 11957 | 321 |
1029611 | 1029611 | 2021-02-14 | Clark | Ohio | 39023 | 11930 | 320 |
1026364 | 1026364 | 2021-02-13 | Clark | Ohio | 39023 | 11913 | 320 |
1023119 | 1023119 | 2021-02-12 | Clark | Ohio | 39023 | 11881 | 318 |
1019874 | 1019874 | 2021-02-11 | Clark | Ohio | 39023 | 11838 | 303 |
1016629 | 1016629 | 2021-02-10 | Clark | Ohio | 39023 | 11815 | 301 |
1013384 | 1013384 | 2021-02-09 | Clark | Ohio | 39023 | 11778 | 300 |
1010139 | 1010139 | 2021-02-08 | Clark | Ohio | 39023 | 11741 | 299 |
1006893 | 1006893 | 2021-02-07 | Clark | Ohio | 39023 | 11716 | 299 |
1003647 | 1003647 | 2021-02-06 | Clark | Ohio | 39023 | 11685 | 299 |
1000401 | 1000401 | 2021-02-05 | Clark | Ohio | 39023 | 11633 | 295 |
997155 | 997155 | 2021-02-04 | Clark | Ohio | 39023 | 11599 | 295 |
993909 | 993909 | 2021-02-03 | Clark | Ohio | 39023 | 11552 | 295 |
990663 | 990663 | 2021-02-02 | Clark | Ohio | 39023 | 11518 | 293 |
987417 | 987417 | 2021-02-01 | Clark | Ohio | 39023 | 11462 | 289 |
984170 | 984170 | 2021-01-31 | Clark | Ohio | 39023 | 11420 | 288 |
980923 | 980923 | 2021-01-30 | Clark | Ohio | 39023 | 11372 | 288 |
977677 | 977677 | 2021-01-29 | Clark | Ohio | 39023 | 11297 | 288 |
974432 | 974432 | 2021-01-28 | Clark | Ohio | 39023 | 11205 | 281 |
971187 | 971187 | 2021-01-27 | Clark | Ohio | 39023 | 11147 | 266 |
967942 | 967942 | 2021-01-26 | Clark | Ohio | 39023 | 11094 | 266 |
964698 | 964698 | 2021-01-25 | Clark | Ohio | 39023 | 11058 | 265 |
961453 | 961453 | 2021-01-24 | Clark | Ohio | 39023 | 10995 | 265 |
958208 | 958208 | 2021-01-23 | Clark | Ohio | 39023 | 10942 | 265 |
954962 | 954962 | 2021-01-22 | Clark | Ohio | 39023 | 10867 | 265 |
951717 | 951717 | 2021-01-21 | Clark | Ohio | 39023 | 10802 | 265 |
948472 | 948472 | 2021-01-20 | Clark | Ohio | 39023 | 10723 | 264 |
945226 | 945226 | 2021-01-19 | Clark | Ohio | 39023 | 10672 | 264 |
941979 | 941979 | 2021-01-18 | Clark | Ohio | 39023 | 10648 | 264 |
938734 | 938734 | 2021-01-17 | Clark | Ohio | 39023 | 10608 | 264 |
935489 | 935489 | 2021-01-16 | Clark | Ohio | 39023 | 10557 | 264 |
932244 | 932244 | 2021-01-15 | Clark | Ohio | 39023 | 10451 | 263 |
928999 | 928999 | 2021-01-14 | Clark | Ohio | 39023 | 10334 | 261 |
925754 | 925754 | 2021-01-13 | Clark | Ohio | 39023 | 10235 | 260 |
922508 | 922508 | 2021-01-12 | Clark | Ohio | 39023 | 10177 | 260 |
919263 | 919263 | 2021-01-11 | Clark | Ohio | 39023 | 10057 | 251 |
916018 | 916018 | 2021-01-10 | Clark | Ohio | 39023 | 9945 | 248 |
912773 | 912773 | 2021-01-09 | Clark | Ohio | 39023 | 9876 | 247 |
909528 | 909528 | 2021-01-08 | Clark | Ohio | 39023 | 9758 | 247 |
906283 | 906283 | 2021-01-07 | Clark | Ohio | 39023 | 9624 | 244 |
903037 | 903037 | 2021-01-06 | Clark | Ohio | 39023 | 9494 | 240 |
899792 | 899792 | 2021-01-05 | Clark | Ohio | 39023 | 9380 | 207 |
896547 | 896547 | 2021-01-04 | Clark | Ohio | 39023 | 9303 | 189 |
893301 | 893301 | 2021-01-03 | Clark | Ohio | 39023 | 9240 | 186 |
890055 | 890055 | 2021-01-02 | Clark | Ohio | 39023 | 9151 | 186 |
886808 | 886808 | 2021-01-01 | Clark | Ohio | 39023 | 8988 | 186 |
883563 | 883563 | 2020-12-31 | Clark | Ohio | 39023 | 8988 | 186 |
880318 | 880318 | 2020-12-30 | Clark | Ohio | 39023 | 8868 | 186 |
877073 | 877073 | 2020-12-29 | Clark | Ohio | 39023 | 8763 | 184 |
873828 | 873828 | 2020-12-28 | Clark | Ohio | 39023 | 8686 | 179 |
870583 | 870583 | 2020-12-27 | Clark | Ohio | 39023 | 8651 | 179 |
867338 | 867338 | 2020-12-26 | Clark | Ohio | 39023 | 8586 | 179 |
864093 | 864093 | 2020-12-25 | Clark | Ohio | 39023 | 8449 | 179 |
860848 | 860848 | 2020-12-24 | Clark | Ohio | 39023 | 8449 | 179 |
857603 | 857603 | 2020-12-23 | Clark | Ohio | 39023 | 8353 | 179 |
854358 | 854358 | 2020-12-22 | Clark | Ohio | 39023 | 8280 | 173 |
851113 | 851113 | 2020-12-21 | Clark | Ohio | 39023 | 8196 | 173 |
847868 | 847868 | 2020-12-20 | Clark | Ohio | 39023 | 8144 | 172 |
844623 | 844623 | 2020-12-19 | Clark | Ohio | 39023 | 8058 | 172 |
841377 | 841377 | 2020-12-18 | Clark | Ohio | 39023 | 7973 | 152 |
838132 | 838132 | 2020-12-17 | Clark | Ohio | 39023 | 7859 | 150 |
834886 | 834886 | 2020-12-16 | Clark | Ohio | 39023 | 7697 | 150 |
831640 | 831640 | 2020-12-15 | Clark | Ohio | 39023 | 7669 | 150 |
828393 | 828393 | 2020-12-14 | Clark | Ohio | 39023 | 7547 | 150 |
825147 | 825147 | 2020-12-13 | Clark | Ohio | 39023 | 7384 | 150 |
821900 | 821900 | 2020-12-12 | Clark | Ohio | 39023 | 7261 | 150 |
818654 | 818654 | 2020-12-11 | Clark | Ohio | 39023 | 7081 | 148 |
815408 | 815408 | 2020-12-10 | Clark | Ohio | 39023 | 6951 | 147 |
812162 | 812162 | 2020-12-09 | Clark | Ohio | 39023 | 6803 | 147 |
808918 | 808918 | 2020-12-08 | Clark | Ohio | 39023 | 6669 | 147 |
805673 | 805673 | 2020-12-07 | Clark | Ohio | 39023 | 6473 | 146 |
802428 | 802428 | 2020-12-06 | Clark | Ohio | 39023 | 6386 | 144 |
799183 | 799183 | 2020-12-05 | Clark | Ohio | 39023 | 6295 | 144 |
795938 | 795938 | 2020-12-04 | Clark | Ohio | 39023 | 6171 | 143 |
792693 | 792693 | 2020-12-03 | Clark | Ohio | 39023 | 6038 | 142 |
789448 | 789448 | 2020-12-02 | Clark | Ohio | 39023 | 5907 | 140 |
786203 | 786203 | 2020-12-01 | Clark | Ohio | 39023 | 5799 | 137 |
782959 | 782959 | 2020-11-30 | Clark | Ohio | 39023 | 5711 | 131 |
779713 | 779713 | 2020-11-29 | Clark | Ohio | 39023 | 5637 | 131 |
776468 | 776468 | 2020-11-28 | Clark | Ohio | 39023 | 5546 | 129 |
773223 | 773223 | 2020-11-27 | Clark | Ohio | 39023 | 5438 | 129 |
769978 | 769978 | 2020-11-26 | Clark | Ohio | 39023 | 5218 | 101 |
766732 | 766732 | 2020-11-25 | Clark | Ohio | 39023 | 5218 | 101 |
763487 | 763487 | 2020-11-24 | Clark | Ohio | 39023 | 5114 | 64 |
760242 | 760242 | 2020-11-23 | Clark | Ohio | 39023 | 5010 | 64 |
756997 | 756997 | 2020-11-22 | Clark | Ohio | 39023 | 4866 | 64 |
753750 | 753750 | 2020-11-21 | Clark | Ohio | 39023 | 4799 | 64 |
750504 | 750504 | 2020-11-20 | Clark | Ohio | 39023 | 4633 | 64 |
747258 | 747258 | 2020-11-19 | Clark | Ohio | 39023 | 4499 | 64 |
744012 | 744012 | 2020-11-18 | Clark | Ohio | 39023 | 4389 | 62 |
740765 | 740765 | 2020-11-17 | Clark | Ohio | 39023 | 4327 | 62 |
737519 | 737519 | 2020-11-16 | Clark | Ohio | 39023 | 4230 | 62 |
734275 | 734275 | 2020-11-15 | Clark | Ohio | 39023 | 4145 | 62 |
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);