ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Montgomery" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1081586 | 1081586 | 2021-03-02 | Montgomery | Ohio | 39113 | 47301 | 903 |
1078340 | 1078340 | 2021-03-01 | Montgomery | Ohio | 39113 | 47254 | 892 |
1075095 | 1075095 | 2021-02-28 | Montgomery | Ohio | 39113 | 47226 | 889 |
1071849 | 1071849 | 2021-02-27 | Montgomery | Ohio | 39113 | 47187 | 886 |
1068603 | 1068603 | 2021-02-26 | Montgomery | Ohio | 39113 | 47128 | 883 |
1065358 | 1065358 | 2021-02-25 | Montgomery | Ohio | 39113 | 47066 | 879 |
1062114 | 1062114 | 2021-02-24 | Montgomery | Ohio | 39113 | 46983 | 875 |
1058868 | 1058868 | 2021-02-23 | Montgomery | Ohio | 39113 | 46927 | 869 |
1055622 | 1055622 | 2021-02-22 | Montgomery | Ohio | 39113 | 46824 | 865 |
1052376 | 1052376 | 2021-02-21 | Montgomery | Ohio | 39113 | 46761 | 859 |
1049129 | 1049129 | 2021-02-20 | Montgomery | Ohio | 39113 | 46704 | 856 |
1045882 | 1045882 | 2021-02-19 | Montgomery | Ohio | 39113 | 46623 | 854 |
1042637 | 1042637 | 2021-02-18 | Montgomery | Ohio | 39113 | 46563 | 855 |
1039392 | 1039392 | 2021-02-17 | Montgomery | Ohio | 39113 | 46480 | 850 |
1036147 | 1036147 | 2021-02-16 | Montgomery | Ohio | 39113 | 46442 | 848 |
1032902 | 1032902 | 2021-02-15 | Montgomery | Ohio | 39113 | 46369 | 845 |
1029656 | 1029656 | 2021-02-14 | Montgomery | Ohio | 39113 | 46295 | 841 |
1026409 | 1026409 | 2021-02-13 | Montgomery | Ohio | 39113 | 46222 | 841 |
1023164 | 1023164 | 2021-02-12 | Montgomery | Ohio | 39113 | 46097 | 747 |
1019919 | 1019919 | 2021-02-11 | Montgomery | Ohio | 39113 | 45972 | 539 |
1016674 | 1016674 | 2021-02-10 | Montgomery | Ohio | 39113 | 45866 | 476 |
1013429 | 1013429 | 2021-02-09 | Montgomery | Ohio | 39113 | 45730 | 475 |
1010184 | 1010184 | 2021-02-08 | Montgomery | Ohio | 39113 | 45627 | 471 |
1006938 | 1006938 | 2021-02-07 | Montgomery | Ohio | 39113 | 45551 | 470 |
1003692 | 1003692 | 2021-02-06 | Montgomery | Ohio | 39113 | 45441 | 470 |
1000446 | 1000446 | 2021-02-05 | Montgomery | Ohio | 39113 | 45256 | 467 |
997200 | 997200 | 2021-02-04 | Montgomery | Ohio | 39113 | 45132 | 461 |
993954 | 993954 | 2021-02-03 | Montgomery | Ohio | 39113 | 44954 | 456 |
990708 | 990708 | 2021-02-02 | Montgomery | Ohio | 39113 | 44835 | 438 |
987462 | 987462 | 2021-02-01 | Montgomery | Ohio | 39113 | 44687 | 433 |
984215 | 984215 | 2021-01-31 | Montgomery | Ohio | 39113 | 44586 | 430 |
980968 | 980968 | 2021-01-30 | Montgomery | Ohio | 39113 | 44437 | 428 |
977722 | 977722 | 2021-01-29 | Montgomery | Ohio | 39113 | 44264 | 427 |
974477 | 974477 | 2021-01-28 | Montgomery | Ohio | 39113 | 44070 | 426 |
971232 | 971232 | 2021-01-27 | Montgomery | Ohio | 39113 | 43872 | 420 |
967987 | 967987 | 2021-01-26 | Montgomery | Ohio | 39113 | 43662 | 420 |
964743 | 964743 | 2021-01-25 | Montgomery | Ohio | 39113 | 43516 | 419 |
961498 | 961498 | 2021-01-24 | Montgomery | Ohio | 39113 | 43309 | 418 |
958253 | 958253 | 2021-01-23 | Montgomery | Ohio | 39113 | 43107 | 418 |
955007 | 955007 | 2021-01-22 | Montgomery | Ohio | 39113 | 42863 | 417 |
951762 | 951762 | 2021-01-21 | Montgomery | Ohio | 39113 | 42660 | 405 |
948517 | 948517 | 2021-01-20 | Montgomery | Ohio | 39113 | 42334 | 403 |
945271 | 945271 | 2021-01-19 | Montgomery | Ohio | 39113 | 42028 | 399 |
942024 | 942024 | 2021-01-18 | Montgomery | Ohio | 39113 | 41873 | 399 |
938779 | 938779 | 2021-01-17 | Montgomery | Ohio | 39113 | 41700 | 399 |
935534 | 935534 | 2021-01-16 | Montgomery | Ohio | 39113 | 41445 | 399 |
932289 | 932289 | 2021-01-15 | Montgomery | Ohio | 39113 | 41172 | 398 |
929044 | 929044 | 2021-01-14 | Montgomery | Ohio | 39113 | 40858 | 396 |
925799 | 925799 | 2021-01-13 | Montgomery | Ohio | 39113 | 40514 | 396 |
922553 | 922553 | 2021-01-12 | Montgomery | Ohio | 39113 | 40238 | 384 |
919308 | 919308 | 2021-01-11 | Montgomery | Ohio | 39113 | 39691 | 382 |
916063 | 916063 | 2021-01-10 | Montgomery | Ohio | 39113 | 39479 | 382 |
912818 | 912818 | 2021-01-09 | Montgomery | Ohio | 39113 | 39206 | 382 |
909573 | 909573 | 2021-01-08 | Montgomery | Ohio | 39113 | 38845 | 380 |
906328 | 906328 | 2021-01-07 | Montgomery | Ohio | 39113 | 38341 | 380 |
903082 | 903082 | 2021-01-06 | Montgomery | Ohio | 39113 | 37737 | 365 |
899837 | 899837 | 2021-01-05 | Montgomery | Ohio | 39113 | 37411 | 362 |
896592 | 896592 | 2021-01-04 | Montgomery | Ohio | 39113 | 37025 | 359 |
893346 | 893346 | 2021-01-03 | Montgomery | Ohio | 39113 | 36720 | 359 |
890100 | 890100 | 2021-01-02 | Montgomery | Ohio | 39113 | 36362 | 359 |
886853 | 886853 | 2021-01-01 | Montgomery | Ohio | 39113 | 35615 | 359 |
883608 | 883608 | 2020-12-31 | Montgomery | Ohio | 39113 | 35615 | 359 |
880363 | 880363 | 2020-12-30 | Montgomery | Ohio | 39113 | 35213 | 353 |
877118 | 877118 | 2020-12-29 | Montgomery | Ohio | 39113 | 34774 | 352 |
873873 | 873873 | 2020-12-28 | Montgomery | Ohio | 39113 | 34413 | 349 |
870628 | 870628 | 2020-12-27 | Montgomery | Ohio | 39113 | 34161 | 342 |
867383 | 867383 | 2020-12-26 | Montgomery | Ohio | 39113 | 33832 | 342 |
864138 | 864138 | 2020-12-25 | Montgomery | Ohio | 39113 | 33350 | 341 |
860893 | 860893 | 2020-12-24 | Montgomery | Ohio | 39113 | 33350 | 341 |
857648 | 857648 | 2020-12-23 | Montgomery | Ohio | 39113 | 32974 | 337 |
854403 | 854403 | 2020-12-22 | Montgomery | Ohio | 39113 | 32656 | 334 |
851158 | 851158 | 2020-12-21 | Montgomery | Ohio | 39113 | 32212 | 328 |
847913 | 847913 | 2020-12-20 | Montgomery | Ohio | 39113 | 31993 | 326 |
844668 | 844668 | 2020-12-19 | Montgomery | Ohio | 39113 | 31661 | 325 |
841422 | 841422 | 2020-12-18 | Montgomery | Ohio | 39113 | 31218 | 321 |
838177 | 838177 | 2020-12-17 | Montgomery | Ohio | 39113 | 30676 | 319 |
834931 | 834931 | 2020-12-16 | Montgomery | Ohio | 39113 | 30147 | 306 |
831685 | 831685 | 2020-12-15 | Montgomery | Ohio | 39113 | 29982 | 304 |
828438 | 828438 | 2020-12-14 | Montgomery | Ohio | 39113 | 29401 | 302 |
825192 | 825192 | 2020-12-13 | Montgomery | Ohio | 39113 | 29007 | 301 |
821945 | 821945 | 2020-12-12 | Montgomery | Ohio | 39113 | 28623 | 300 |
818699 | 818699 | 2020-12-11 | Montgomery | Ohio | 39113 | 28134 | 300 |
815453 | 815453 | 2020-12-10 | Montgomery | Ohio | 39113 | 27505 | 297 |
812207 | 812207 | 2020-12-09 | Montgomery | Ohio | 39113 | 26925 | 289 |
808963 | 808963 | 2020-12-08 | Montgomery | Ohio | 39113 | 26571 | 286 |
805718 | 805718 | 2020-12-07 | Montgomery | Ohio | 39113 | 25699 | 282 |
802473 | 802473 | 2020-12-06 | Montgomery | Ohio | 39113 | 25312 | 280 |
799228 | 799228 | 2020-12-05 | Montgomery | Ohio | 39113 | 24901 | 280 |
795983 | 795983 | 2020-12-04 | Montgomery | Ohio | 39113 | 24352 | 275 |
792738 | 792738 | 2020-12-03 | Montgomery | Ohio | 39113 | 23838 | 265 |
789493 | 789493 | 2020-12-02 | Montgomery | Ohio | 39113 | 23277 | 250 |
786248 | 786248 | 2020-12-01 | Montgomery | Ohio | 39113 | 22914 | 248 |
783004 | 783004 | 2020-11-30 | Montgomery | Ohio | 39113 | 22521 | 243 |
779758 | 779758 | 2020-11-29 | Montgomery | Ohio | 39113 | 22196 | 243 |
776513 | 776513 | 2020-11-28 | Montgomery | Ohio | 39113 | 21694 | 243 |
773268 | 773268 | 2020-11-27 | Montgomery | Ohio | 39113 | 21355 | 242 |
770023 | 770023 | 2020-11-26 | Montgomery | Ohio | 39113 | 20518 | 236 |
766777 | 766777 | 2020-11-25 | Montgomery | Ohio | 39113 | 20518 | 236 |
763532 | 763532 | 2020-11-24 | Montgomery | Ohio | 39113 | 20065 | 228 |
760287 | 760287 | 2020-11-23 | Montgomery | Ohio | 39113 | 19636 | 225 |
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);