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 |
---|---|---|---|---|---|---|---|
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 |
757042 | 757042 | 2020-11-22 | Montgomery | Ohio | 39113 | 19082 | 225 |
753795 | 753795 | 2020-11-21 | Montgomery | Ohio | 39113 | 18559 | 225 |
750549 | 750549 | 2020-11-20 | Montgomery | Ohio | 39113 | 18176 | 223 |
747303 | 747303 | 2020-11-19 | Montgomery | Ohio | 39113 | 17811 | 220 |
744057 | 744057 | 2020-11-18 | Montgomery | Ohio | 39113 | 17496 | 215 |
740810 | 740810 | 2020-11-17 | Montgomery | Ohio | 39113 | 17243 | 214 |
737564 | 737564 | 2020-11-16 | Montgomery | Ohio | 39113 | 16904 | 213 |
734320 | 734320 | 2020-11-15 | Montgomery | Ohio | 39113 | 16412 | 211 |
731074 | 731074 | 2020-11-14 | Montgomery | Ohio | 39113 | 16108 | 211 |
727830 | 727830 | 2020-11-13 | Montgomery | Ohio | 39113 | 15684 | 209 |
724586 | 724586 | 2020-11-12 | Montgomery | Ohio | 39113 | 15228 | 205 |
721343 | 721343 | 2020-11-11 | Montgomery | Ohio | 39113 | 14820 | 205 |
718100 | 718100 | 2020-11-10 | Montgomery | Ohio | 39113 | 14491 | 195 |
714857 | 714857 | 2020-11-09 | Montgomery | Ohio | 39113 | 14169 | 193 |
711613 | 711613 | 2020-11-08 | Montgomery | Ohio | 39113 | 13901 | 193 |
708369 | 708369 | 2020-11-07 | Montgomery | Ohio | 39113 | 13624 | 193 |
705126 | 705126 | 2020-11-06 | Montgomery | Ohio | 39113 | 13278 | 193 |
701883 | 701883 | 2020-11-05 | Montgomery | Ohio | 39113 | 13036 | 191 |
698639 | 698639 | 2020-11-04 | Montgomery | Ohio | 39113 | 12763 | 190 |
695396 | 695396 | 2020-11-03 | Montgomery | Ohio | 39113 | 12561 | 190 |
692154 | 692154 | 2020-11-02 | Montgomery | Ohio | 39113 | 12328 | 190 |
688910 | 688910 | 2020-11-01 | Montgomery | Ohio | 39113 | 12156 | 190 |
685665 | 685665 | 2020-10-31 | Montgomery | Ohio | 39113 | 11889 | 190 |
682422 | 682422 | 2020-10-30 | Montgomery | Ohio | 39113 | 11748 | 190 |
679179 | 679179 | 2020-10-29 | Montgomery | Ohio | 39113 | 11494 | 190 |
675936 | 675936 | 2020-10-28 | Montgomery | Ohio | 39113 | 11281 | 190 |
672693 | 672693 | 2020-10-27 | Montgomery | Ohio | 39113 | 11103 | 190 |
669451 | 669451 | 2020-10-26 | Montgomery | Ohio | 39113 | 10959 | 190 |
666207 | 666207 | 2020-10-25 | Montgomery | Ohio | 39113 | 10864 | 189 |
662962 | 662962 | 2020-10-24 | Montgomery | Ohio | 39113 | 10686 | 189 |
659718 | 659718 | 2020-10-23 | Montgomery | Ohio | 39113 | 10546 | 189 |
656474 | 656474 | 2020-10-22 | Montgomery | Ohio | 39113 | 10377 | 189 |
653229 | 653229 | 2020-10-21 | Montgomery | Ohio | 39113 | 10216 | 189 |
649984 | 649984 | 2020-10-20 | Montgomery | Ohio | 39113 | 10083 | 186 |
646740 | 646740 | 2020-10-19 | Montgomery | Ohio | 39113 | 10000 | 185 |
643494 | 643494 | 2020-10-18 | Montgomery | Ohio | 39113 | 9883 | 184 |
640246 | 640246 | 2020-10-17 | Montgomery | Ohio | 39113 | 9772 | 184 |
637000 | 637000 | 2020-10-16 | Montgomery | Ohio | 39113 | 9675 | 183 |
633754 | 633754 | 2020-10-15 | Montgomery | Ohio | 39113 | 9487 | 183 |
630509 | 630509 | 2020-10-14 | Montgomery | Ohio | 39113 | 9302 | 183 |
627265 | 627265 | 2020-10-13 | Montgomery | Ohio | 39113 | 9154 | 183 |
624023 | 624023 | 2020-10-12 | Montgomery | Ohio | 39113 | 9075 | 183 |
620780 | 620780 | 2020-10-11 | Montgomery | Ohio | 39113 | 9025 | 183 |
617538 | 617538 | 2020-10-10 | Montgomery | Ohio | 39113 | 8943 | 183 |
614296 | 614296 | 2020-10-09 | Montgomery | Ohio | 39113 | 8864 | 183 |
611055 | 611055 | 2020-10-08 | Montgomery | Ohio | 39113 | 8732 | 182 |
607813 | 607813 | 2020-10-07 | Montgomery | Ohio | 39113 | 8572 | 182 |
604570 | 604570 | 2020-10-06 | Montgomery | Ohio | 39113 | 8508 | 181 |
601328 | 601328 | 2020-10-05 | Montgomery | Ohio | 39113 | 8417 | 181 |
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);