ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Lapeer" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054792 | 1054792 | 2021-02-22 | Lapeer | Michigan | 26087 | 5458 | 128 |
1051545 | 1051545 | 2021-02-21 | Lapeer | Michigan | 26087 | 5433 | 128 |
1048298 | 1048298 | 2021-02-20 | Lapeer | Michigan | 26087 | 5433 | 128 |
1045052 | 1045052 | 2021-02-19 | Lapeer | Michigan | 26087 | 5414 | 128 |
1041807 | 1041807 | 2021-02-18 | Lapeer | Michigan | 26087 | 5400 | 128 |
1038562 | 1038562 | 2021-02-17 | Lapeer | Michigan | 26087 | 5379 | 128 |
1035317 | 1035317 | 2021-02-16 | Lapeer | Michigan | 26087 | 5361 | 128 |
1032072 | 1032072 | 2021-02-15 | Lapeer | Michigan | 26087 | 5348 | 128 |
1028825 | 1028825 | 2021-02-14 | Lapeer | Michigan | 26087 | 5335 | 127 |
1025579 | 1025579 | 2021-02-13 | Lapeer | Michigan | 26087 | 5335 | 127 |
1022334 | 1022334 | 2021-02-12 | Lapeer | Michigan | 26087 | 5315 | 126 |
1019089 | 1019089 | 2021-02-11 | Lapeer | Michigan | 26087 | 5300 | 126 |
1015844 | 1015844 | 2021-02-10 | Lapeer | Michigan | 26087 | 5288 | 126 |
1012599 | 1012599 | 2021-02-09 | Lapeer | Michigan | 26087 | 5261 | 125 |
1009354 | 1009354 | 2021-02-08 | Lapeer | Michigan | 26087 | 5232 | 125 |
1006107 | 1006107 | 2021-02-07 | Lapeer | Michigan | 26087 | 5214 | 125 |
1002861 | 1002861 | 2021-02-06 | Lapeer | Michigan | 26087 | 5214 | 125 |
999616 | 999616 | 2021-02-05 | Lapeer | Michigan | 26087 | 5197 | 124 |
996370 | 996370 | 2021-02-04 | Lapeer | Michigan | 26087 | 5169 | 124 |
993124 | 993124 | 2021-02-03 | Lapeer | Michigan | 26087 | 5114 | 123 |
989878 | 989878 | 2021-02-02 | Lapeer | Michigan | 26087 | 5089 | 123 |
986631 | 986631 | 2021-02-01 | Lapeer | Michigan | 26087 | 5078 | 122 |
983384 | 983384 | 2021-01-31 | Lapeer | Michigan | 26087 | 5062 | 122 |
980138 | 980138 | 2021-01-30 | Lapeer | Michigan | 26087 | 5062 | 122 |
976892 | 976892 | 2021-01-29 | Lapeer | Michigan | 26087 | 5056 | 122 |
973647 | 973647 | 2021-01-28 | Lapeer | Michigan | 26087 | 5043 | 122 |
970402 | 970402 | 2021-01-27 | Lapeer | Michigan | 26087 | 5033 | 121 |
967157 | 967157 | 2021-01-26 | Lapeer | Michigan | 26087 | 5021 | 121 |
963913 | 963913 | 2021-01-25 | Lapeer | Michigan | 26087 | 5004 | 121 |
960668 | 960668 | 2021-01-24 | Lapeer | Michigan | 26087 | 4984 | 121 |
957422 | 957422 | 2021-01-23 | Lapeer | Michigan | 26087 | 4984 | 121 |
954177 | 954177 | 2021-01-22 | Lapeer | Michigan | 26087 | 4983 | 119 |
950932 | 950932 | 2021-01-21 | Lapeer | Michigan | 26087 | 4966 | 118 |
947686 | 947686 | 2021-01-20 | Lapeer | Michigan | 26087 | 4955 | 116 |
944439 | 944439 | 2021-01-19 | Lapeer | Michigan | 26087 | 4942 | 116 |
941194 | 941194 | 2021-01-18 | Lapeer | Michigan | 26087 | 4926 | 115 |
937949 | 937949 | 2021-01-17 | Lapeer | Michigan | 26087 | 4908 | 114 |
934704 | 934704 | 2021-01-16 | Lapeer | Michigan | 26087 | 4908 | 114 |
931459 | 931459 | 2021-01-15 | Lapeer | Michigan | 26087 | 4902 | 113 |
928214 | 928214 | 2021-01-14 | Lapeer | Michigan | 26087 | 4879 | 114 |
924968 | 924968 | 2021-01-13 | Lapeer | Michigan | 26087 | 4675 | 110 |
921723 | 921723 | 2021-01-12 | Lapeer | Michigan | 26087 | 4646 | 110 |
918478 | 918478 | 2021-01-11 | Lapeer | Michigan | 26087 | 4614 | 110 |
915233 | 915233 | 2021-01-10 | Lapeer | Michigan | 26087 | 4563 | 110 |
911988 | 911988 | 2021-01-09 | Lapeer | Michigan | 26087 | 4563 | 110 |
908743 | 908743 | 2021-01-08 | Lapeer | Michigan | 26087 | 4535 | 110 |
905497 | 905497 | 2021-01-07 | Lapeer | Michigan | 26087 | 4518 | 110 |
902252 | 902252 | 2021-01-06 | Lapeer | Michigan | 26087 | 4483 | 109 |
899007 | 899007 | 2021-01-05 | Lapeer | Michigan | 26087 | 4453 | 109 |
895762 | 895762 | 2021-01-04 | Lapeer | Michigan | 26087 | 4408 | 108 |
892515 | 892515 | 2021-01-03 | Lapeer | Michigan | 26087 | 4377 | 107 |
889269 | 889269 | 2021-01-02 | Lapeer | Michigan | 26087 | 4377 | 107 |
886023 | 886023 | 2021-01-01 | Lapeer | Michigan | 26087 | 4334 | 108 |
882778 | 882778 | 2020-12-31 | Lapeer | Michigan | 26087 | 4334 | 108 |
879533 | 879533 | 2020-12-30 | Lapeer | Michigan | 26087 | 4334 | 108 |
876288 | 876288 | 2020-12-29 | Lapeer | Michigan | 26087 | 4304 | 108 |
873043 | 873043 | 2020-12-28 | Lapeer | Michigan | 26087 | 4257 | 105 |
869798 | 869798 | 2020-12-27 | Lapeer | Michigan | 26087 | 4236 | 104 |
866553 | 866553 | 2020-12-26 | Lapeer | Michigan | 26087 | 4236 | 104 |
863308 | 863308 | 2020-12-25 | Lapeer | Michigan | 26087 | 4192 | 96 |
860063 | 860063 | 2020-12-24 | Lapeer | Michigan | 26087 | 4192 | 96 |
856818 | 856818 | 2020-12-23 | Lapeer | Michigan | 26087 | 4192 | 96 |
853573 | 853573 | 2020-12-22 | Lapeer | Michigan | 26087 | 4145 | 96 |
850328 | 850328 | 2020-12-21 | Lapeer | Michigan | 26087 | 4093 | 95 |
847083 | 847083 | 2020-12-20 | Lapeer | Michigan | 26087 | 4036 | 93 |
843837 | 843837 | 2020-12-19 | Lapeer | Michigan | 26087 | 4036 | 93 |
840592 | 840592 | 2020-12-18 | Lapeer | Michigan | 26087 | 4012 | 92 |
837347 | 837347 | 2020-12-17 | Lapeer | Michigan | 26087 | 3915 | 91 |
834101 | 834101 | 2020-12-16 | Lapeer | Michigan | 26087 | 3864 | 85 |
830854 | 830854 | 2020-12-15 | Lapeer | Michigan | 26087 | 3812 | 84 |
827608 | 827608 | 2020-12-14 | Lapeer | Michigan | 26087 | 3725 | 82 |
824361 | 824361 | 2020-12-13 | Lapeer | Michigan | 26087 | 3706 | 80 |
821115 | 821115 | 2020-12-12 | Lapeer | Michigan | 26087 | 3706 | 80 |
817869 | 817869 | 2020-12-11 | Lapeer | Michigan | 26087 | 3597 | 78 |
814623 | 814623 | 2020-12-10 | Lapeer | Michigan | 26087 | 3531 | 75 |
811378 | 811378 | 2020-12-09 | Lapeer | Michigan | 26087 | 3489 | 73 |
808133 | 808133 | 2020-12-08 | Lapeer | Michigan | 26087 | 3418 | 71 |
804888 | 804888 | 2020-12-07 | Lapeer | Michigan | 26087 | 3355 | 71 |
801643 | 801643 | 2020-12-06 | Lapeer | Michigan | 26087 | 3272 | 71 |
798398 | 798398 | 2020-12-05 | Lapeer | Michigan | 26087 | 3272 | 71 |
795153 | 795153 | 2020-12-04 | Lapeer | Michigan | 26087 | 3200 | 70 |
791908 | 791908 | 2020-12-03 | Lapeer | Michigan | 26087 | 3124 | 68 |
788663 | 788663 | 2020-12-02 | Lapeer | Michigan | 26087 | 3044 | 66 |
785418 | 785418 | 2020-12-01 | Lapeer | Michigan | 26087 | 2957 | 61 |
782174 | 782174 | 2020-11-30 | Lapeer | Michigan | 26087 | 2884 | 60 |
778928 | 778928 | 2020-11-29 | Lapeer | Michigan | 26087 | 2765 | 60 |
775683 | 775683 | 2020-11-28 | Lapeer | Michigan | 26087 | 2765 | 60 |
772438 | 772438 | 2020-11-27 | Lapeer | Michigan | 26087 | 2672 | 58 |
769193 | 769193 | 2020-11-26 | Lapeer | Michigan | 26087 | 2484 | 58 |
765947 | 765947 | 2020-11-25 | Lapeer | Michigan | 26087 | 2484 | 58 |
762702 | 762702 | 2020-11-24 | Lapeer | Michigan | 26087 | 2412 | 56 |
759457 | 759457 | 2020-11-23 | Lapeer | Michigan | 26087 | 2374 | 55 |
756210 | 756210 | 2020-11-22 | Lapeer | Michigan | 26087 | 2263 | 55 |
752964 | 752964 | 2020-11-21 | Lapeer | Michigan | 26087 | 2263 | 55 |
749718 | 749718 | 2020-11-20 | Lapeer | Michigan | 26087 | 2180 | 54 |
746472 | 746472 | 2020-11-19 | Lapeer | Michigan | 26087 | 2141 | 54 |
743225 | 743225 | 2020-11-18 | Lapeer | Michigan | 26087 | 2073 | 54 |
739978 | 739978 | 2020-11-17 | Lapeer | Michigan | 26087 | 2008 | 52 |
736734 | 736734 | 2020-11-16 | Lapeer | Michigan | 26087 | 1925 | 52 |
733488 | 733488 | 2020-11-15 | Lapeer | Michigan | 26087 | 1850 | 51 |
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);