ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Gladwin" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947668 | 947668 | 2021-01-20 | Gladwin | Michigan | 26051 | 1362 | 37 |
944421 | 944421 | 2021-01-19 | Gladwin | Michigan | 26051 | 1350 | 37 |
941176 | 941176 | 2021-01-18 | Gladwin | Michigan | 26051 | 1346 | 37 |
937931 | 937931 | 2021-01-17 | Gladwin | Michigan | 26051 | 1334 | 36 |
934686 | 934686 | 2021-01-16 | Gladwin | Michigan | 26051 | 1334 | 36 |
931441 | 931441 | 2021-01-15 | Gladwin | Michigan | 26051 | 1332 | 35 |
928196 | 928196 | 2021-01-14 | Gladwin | Michigan | 26051 | 1324 | 35 |
924950 | 924950 | 2021-01-13 | Gladwin | Michigan | 26051 | 1317 | 35 |
921705 | 921705 | 2021-01-12 | Gladwin | Michigan | 26051 | 1306 | 35 |
918460 | 918460 | 2021-01-11 | Gladwin | Michigan | 26051 | 1296 | 35 |
915215 | 915215 | 2021-01-10 | Gladwin | Michigan | 26051 | 1283 | 35 |
911970 | 911970 | 2021-01-09 | Gladwin | Michigan | 26051 | 1283 | 35 |
908725 | 908725 | 2021-01-08 | Gladwin | Michigan | 26051 | 1276 | 35 |
905479 | 905479 | 2021-01-07 | Gladwin | Michigan | 26051 | 1270 | 35 |
902234 | 902234 | 2021-01-06 | Gladwin | Michigan | 26051 | 1262 | 34 |
898989 | 898989 | 2021-01-05 | Gladwin | Michigan | 26051 | 1249 | 34 |
895744 | 895744 | 2021-01-04 | Gladwin | Michigan | 26051 | 1235 | 33 |
892497 | 892497 | 2021-01-03 | Gladwin | Michigan | 26051 | 1210 | 33 |
889251 | 889251 | 2021-01-02 | Gladwin | Michigan | 26051 | 1210 | 33 |
886005 | 886005 | 2021-01-01 | Gladwin | Michigan | 26051 | 1184 | 32 |
882760 | 882760 | 2020-12-31 | Gladwin | Michigan | 26051 | 1184 | 32 |
879515 | 879515 | 2020-12-30 | Gladwin | Michigan | 26051 | 1184 | 32 |
876270 | 876270 | 2020-12-29 | Gladwin | Michigan | 26051 | 1179 | 33 |
873025 | 873025 | 2020-12-28 | Gladwin | Michigan | 26051 | 1169 | 31 |
869780 | 869780 | 2020-12-27 | Gladwin | Michigan | 26051 | 1154 | 29 |
866535 | 866535 | 2020-12-26 | Gladwin | Michigan | 26051 | 1154 | 29 |
863290 | 863290 | 2020-12-25 | Gladwin | Michigan | 26051 | 1129 | 28 |
860045 | 860045 | 2020-12-24 | Gladwin | Michigan | 26051 | 1129 | 28 |
856800 | 856800 | 2020-12-23 | Gladwin | Michigan | 26051 | 1129 | 28 |
853555 | 853555 | 2020-12-22 | Gladwin | Michigan | 26051 | 1116 | 26 |
850310 | 850310 | 2020-12-21 | Gladwin | Michigan | 26051 | 1106 | 25 |
847065 | 847065 | 2020-12-20 | Gladwin | Michigan | 26051 | 1094 | 23 |
843819 | 843819 | 2020-12-19 | Gladwin | Michigan | 26051 | 1094 | 23 |
840574 | 840574 | 2020-12-18 | Gladwin | Michigan | 26051 | 1088 | 23 |
837329 | 837329 | 2020-12-17 | Gladwin | Michigan | 26051 | 1076 | 22 |
834083 | 834083 | 2020-12-16 | Gladwin | Michigan | 26051 | 1070 | 20 |
830836 | 830836 | 2020-12-15 | Gladwin | Michigan | 26051 | 1060 | 18 |
827590 | 827590 | 2020-12-14 | Gladwin | Michigan | 26051 | 1055 | 16 |
824343 | 824343 | 2020-12-13 | Gladwin | Michigan | 26051 | 1037 | 16 |
821097 | 821097 | 2020-12-12 | Gladwin | Michigan | 26051 | 1037 | 16 |
817851 | 817851 | 2020-12-11 | Gladwin | Michigan | 26051 | 1021 | 14 |
814605 | 814605 | 2020-12-10 | Gladwin | Michigan | 26051 | 1009 | 14 |
811360 | 811360 | 2020-12-09 | Gladwin | Michigan | 26051 | 992 | 14 |
808115 | 808115 | 2020-12-08 | Gladwin | Michigan | 26051 | 964 | 14 |
804870 | 804870 | 2020-12-07 | Gladwin | Michigan | 26051 | 946 | 14 |
801625 | 801625 | 2020-12-06 | Gladwin | Michigan | 26051 | 924 | 14 |
798380 | 798380 | 2020-12-05 | Gladwin | Michigan | 26051 | 924 | 14 |
795135 | 795135 | 2020-12-04 | Gladwin | Michigan | 26051 | 914 | 14 |
791890 | 791890 | 2020-12-03 | Gladwin | Michigan | 26051 | 891 | 14 |
788645 | 788645 | 2020-12-02 | Gladwin | Michigan | 26051 | 869 | 12 |
785400 | 785400 | 2020-12-01 | Gladwin | Michigan | 26051 | 855 | 12 |
782156 | 782156 | 2020-11-30 | Gladwin | Michigan | 26051 | 835 | 12 |
778910 | 778910 | 2020-11-29 | Gladwin | Michigan | 26051 | 800 | 10 |
775665 | 775665 | 2020-11-28 | Gladwin | Michigan | 26051 | 800 | 10 |
772420 | 772420 | 2020-11-27 | Gladwin | Michigan | 26051 | 792 | 10 |
769175 | 769175 | 2020-11-26 | Gladwin | Michigan | 26051 | 732 | 9 |
765929 | 765929 | 2020-11-25 | Gladwin | Michigan | 26051 | 732 | 9 |
762684 | 762684 | 2020-11-24 | Gladwin | Michigan | 26051 | 709 | 9 |
759439 | 759439 | 2020-11-23 | Gladwin | Michigan | 26051 | 689 | 9 |
756192 | 756192 | 2020-11-22 | Gladwin | Michigan | 26051 | 643 | 8 |
752946 | 752946 | 2020-11-21 | Gladwin | Michigan | 26051 | 643 | 8 |
749700 | 749700 | 2020-11-20 | Gladwin | Michigan | 26051 | 626 | 8 |
746454 | 746454 | 2020-11-19 | Gladwin | Michigan | 26051 | 585 | 8 |
743207 | 743207 | 2020-11-18 | Gladwin | Michigan | 26051 | 559 | 8 |
739960 | 739960 | 2020-11-17 | Gladwin | Michigan | 26051 | 538 | 7 |
736716 | 736716 | 2020-11-16 | Gladwin | Michigan | 26051 | 503 | 7 |
733470 | 733470 | 2020-11-15 | Gladwin | Michigan | 26051 | 458 | 6 |
730225 | 730225 | 2020-11-14 | Gladwin | Michigan | 26051 | 458 | 6 |
726982 | 726982 | 2020-11-13 | Gladwin | Michigan | 26051 | 428 | 6 |
723739 | 723739 | 2020-11-12 | Gladwin | Michigan | 26051 | 378 | 4 |
720496 | 720496 | 2020-11-11 | Gladwin | Michigan | 26051 | 359 | 4 |
717253 | 717253 | 2020-11-10 | Gladwin | Michigan | 26051 | 340 | 4 |
714009 | 714009 | 2020-11-09 | Gladwin | Michigan | 26051 | 327 | 3 |
710765 | 710765 | 2020-11-08 | Gladwin | Michigan | 26051 | 306 | 3 |
707521 | 707521 | 2020-11-07 | Gladwin | Michigan | 26051 | 306 | 3 |
704278 | 704278 | 2020-11-06 | Gladwin | Michigan | 26051 | 292 | 3 |
701036 | 701036 | 2020-11-05 | Gladwin | Michigan | 26051 | 281 | 3 |
697792 | 697792 | 2020-11-04 | Gladwin | Michigan | 26051 | 268 | 3 |
694549 | 694549 | 2020-11-03 | Gladwin | Michigan | 26051 | 260 | 3 |
691307 | 691307 | 2020-11-02 | Gladwin | Michigan | 26051 | 259 | 2 |
688062 | 688062 | 2020-11-01 | Gladwin | Michigan | 26051 | 240 | 2 |
684818 | 684818 | 2020-10-31 | Gladwin | Michigan | 26051 | 240 | 2 |
681575 | 681575 | 2020-10-30 | Gladwin | Michigan | 26051 | 234 | 2 |
678331 | 678331 | 2020-10-29 | Gladwin | Michigan | 26051 | 228 | 2 |
675089 | 675089 | 2020-10-28 | Gladwin | Michigan | 26051 | 216 | 2 |
671846 | 671846 | 2020-10-27 | Gladwin | Michigan | 26051 | 209 | 2 |
668604 | 668604 | 2020-10-26 | Gladwin | Michigan | 26051 | 204 | 2 |
665360 | 665360 | 2020-10-25 | Gladwin | Michigan | 26051 | 185 | 2 |
662115 | 662115 | 2020-10-24 | Gladwin | Michigan | 26051 | 185 | 2 |
658871 | 658871 | 2020-10-23 | Gladwin | Michigan | 26051 | 178 | 2 |
655626 | 655626 | 2020-10-22 | Gladwin | Michigan | 26051 | 176 | 2 |
652381 | 652381 | 2020-10-21 | Gladwin | Michigan | 26051 | 172 | 2 |
649136 | 649136 | 2020-10-20 | Gladwin | Michigan | 26051 | 166 | 2 |
645892 | 645892 | 2020-10-19 | Gladwin | Michigan | 26051 | 167 | 2 |
642645 | 642645 | 2020-10-18 | Gladwin | Michigan | 26051 | 156 | 2 |
639398 | 639398 | 2020-10-17 | Gladwin | Michigan | 26051 | 156 | 2 |
636152 | 636152 | 2020-10-16 | Gladwin | Michigan | 26051 | 156 | 2 |
632906 | 632906 | 2020-10-15 | Gladwin | Michigan | 26051 | 147 | 2 |
629661 | 629661 | 2020-10-14 | Gladwin | Michigan | 26051 | 139 | 2 |
626417 | 626417 | 2020-10-13 | Gladwin | Michigan | 26051 | 135 | 2 |
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);