ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 26099 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 537 ✖
- 229921 7
- 230888 7
- 232167 7
- 233892 7
- 235909 7
- 137642 5
- 157970 5
- 166010 5
- 193931 5
- 229451 5
- 100674 4
- 100779 4
- 100905 4
- 101189 4
- 101662 4
- 106664 4
- 222947 4
- 16996 3
- 48331 3
- 49744 3
- 100037 3
- 100533 3
- 100600 3
- 100713 3
- 100840 3
- 101015 3
- 101412 3
- 101944 3
- 102349 3
- 103196 3
- 104143 3
- 105260 3
- 108054 3
- 109568 3
- 111344 3
- 113570 3
- 115818 3
- 118281 3
- 120375 3
- 122692 3
- 125652 3
- 128751 3
- 133940 3
- 144365 3
- 149528 3
- 154269 3
- 181983 3
- 205793 3
- 214423 3
- 220073 3
- 222040 3
- 223371 3
- 224824 3
- 225871 3
- 226734 3
- 227671 3
- 228541 3
- 238947 3
- 11916 2
- 13433 2
- 13917 2
- 14215 2
- 14722 2
- 15351 2
- 16156 2
- 18270 2
- 19975 2
- 22913 2
- 27445 2
- 32074 2
- 34215 2
- 36826 2
- 41547 2
- 44931 2
- 47426 2
- 48947 2
- 50395 2
- 52238 2
- 53777 2
- 55141 2
- 56229 2
- 57141 2
- 57832 2
- 58439 2
- 59372 2
- 60588 2
- 62222 2
- 64963 2
- 69538 2
- 76232 2
- 82302 2
- 88219 2
- 92643 2
- 95414 2
- 97507 2
- 98634 2
- 99533 2
- 100255 2
- 100429 2
- 102608 2
- 102869 2
- 103518 2
- 103785 2
- 104460 2
- 104905 2
- 105803 2
- 106248 2
- 107495 2
- 108579 2
- 109077 2
- 110213 2
- 110831 2
- 112115 2
- 112792 2
- 114372 2
- 115080 2
- 116751 2
- 117513 2
- 119044 2
- 119679 2
- 121210 2
- 121963 2
- 123813 2
- 124656 2
- 126411 2
- 127089 2
- 130748 2
- 132334 2
- 135834 2
- 140609 2
- 142419 2
- 146350 2
- 148217 2
- 151341 2
- 152802 2
- 156275 2
- 162666 2
- 174175 2
- 176857 2
- 187562 2
- 190201 2
- 202557 2
- 209471 2
- 212077 2
- 216996 2
- 219141 2
- 221041 2
- 221674 2
- 222512 2
- 224132 2
- 225108 2
- 225494 2
- 226074 2
- 226445 2
- 226935 2
- 227245 2
- 227917 2
- 228247 2
- 228793 2
- 229120 2
- 1 1
- 2 1
- 5 1
- 6 1
- 8 1
- 10 1
- 55 1
- 86 1
- 101 1
- 140 1
- 175 1
- 225 1
- 281 1
- 347 1
- 404 1
- 534 1
- 620 1
- 728 1
- 853 1
- 1088 1
- 1332 1
- 1560 1
- 1838 1
- 2003 1
- 2159 1
- 2414 1
- 2626 1
- 2783 1
- 2973 1
- 3164 1
- 3254 1
- 3418 1
- 3620 1
- 3866 1
- 4069 1
- 4222 1
- 4328 1
- 4439 1
- 4505 1
- 4625 1
- 4712 1
- 4946 1
- 5106 1
- 5223 1
- 5288 1
- 5336 1
- 5430 1
- 5521 1
- 5606 1
- 5718 1
- 5761 1
- 5835 1
- 5854 1
- 5888 1
- 5932 1
- 5976 1
- 6063 1
- 6124 1
- 6150 1
- 6172 1
- 6205 1
- 6245 1
- 6341 1
- 6383 1
- 6413 1
- 6455 1
- 6467 1
- 6477 1
- 6502 1
- 6530 1
- 6555 1
- 6592 1
- 6611 1
- 6628 1
- 6640 1
- 6670 1
- 6698 1
- 6728 1
- 6736 1
- 6848 1
- 6860 1
- 6873 1
- 7005 1
- 7026 1
- 7140 1
- 7177 1
- 7235 1
- 7236 1
- 7239 1
- 7245 1
- 7246 1
- 7255 1
- 7274 1
- 7289 1
- 7299 1
- 7330 1
- 7341 1
- 7351 1
- 7362 1
- 7385 1
- 7391 1
- 7404 1
- 7414 1
- 7430 1
- 7464 1
- 7492 1
- 7511 1
- 7537 1
- 7557 1
- 7599 1
- 7668 1
- 7709 1
- 7742 1
- 7761 1
- 7781 1
- 7820 1
- 7865 1
- 7891 1
- 7930 1
- 7979 1
- 8024 1
- 8070 1
- 8117 1
- 8162 1
- 8277 1
- 8378 1
- 8451 1
- 8511 1
- 8593 1
- 8658 1
- 8744 1
- 8826 1
- 8889 1
- 8992 1
- 9020 1
- 9132 1
- 9224 1
- 9296 1
- 9407 1
- 9555 1
- 9689 1
- 9806 1
- 9843 1
- 9963 1
- 10075 1
- 10173 1
- 10283 1
- 10446 1
- 10580 1
- 10674 1
- 10786 1
- 10918 1
- 11036 1
- 11195 1
- 11326 1
- 11463 1
- 11558 1
- 11647 1
- 11727 1
- 11863 1
- 12121 1
- 12258 1
- 12396 1
- 12498 1
- 12603 1
- 12697 1
- 12805 1
- 12924 1
- 12998 1
- 13023 1
- 13126 1
- 13179 1
- 13274 1
- 13347 1
- 13545 1
- 13592 1
- 13677 1
- 13755 1
- 13843 1
- 14004 1
- 14041 1
- 14071 1
- 14119 1
- 14171 1
- 14365 1
- 14407 1
- 14473 1
- 14571 1
- 14644 1
- 14872 1
- 14962 1
- 15063 1
- 15153 1
- 15239 1
- 15511 1
- 15579 1
- 15690 1
- 15822 1
- 16000 1
- 16310 1
- 16407 1
- 16564 1
- 16793 1
- 17321 1
- 17460 1
- 17613 1
- 17802 1
- 17954 1
- 18582 1
- 18793 1
- 19074 1
- 19372 1
- 19647 1
- 20625 1
- 20883 1
- 21278 1
- 21959 1
- 22331 1
- 23744 1
- 24532 1
- 25199 1
- 25854 1
- 26567 1
- 28504 1
- 29309 1
- 29863 1
- 30457 1
- 31410 1
- 33116 1
- 33790 1
- 36060 1
- 37952 1
- 38600 1
- 39490 1
- 40060 1
- 40931 1
- 42376 1
- 43035 1
- 43582 1
- 44119 1
- 44527 1
- 45516 1
- 46118 1
- 46496 1
- 46832 1
- 47154 1
- 47803 1
- 48035 1
- 49156 1
- 49460 1
- 50859 1
- 51026 1
- 51470 1
- 51731 1
- 52050 1
- 52638 1
- 52793 1
- 53063 1
- 53401 1
- 53629 1
- 54076 1
- 54255 1
- 54488 1
- 54692 1
- 54942 1
- 55367 1
- 55605 1
- 55767 1
- 55946 1
- 56112 1
- 56432 1
- 56553 1
- 56670 1
- 56914 1
- 57048 1
- 57326 1
- 57397 1
- 57522 1
- 57655 1
- 57754 1
- 57933 1
- 58014 1
- 58117 1
- 58222 1
- 58344 1
- 58609 1
- 58784 1
- 58926 1
- 59094 1
- 59195 1
- 59556 1
- 59726 1
- 59926 1
- 60169 1
- 60378 1
- 60810 1
- 61005 1
- 61331 1
- 61625 1
- 61987 1
- 62710 1
- 63045 1
- 63529 1
- 63886 1
- 64517 1
- 65756 1
- 66359 1
- 67055 1
- 67879 1
- 68753 1
- 71046 1
- 72016 1
- 73016 1
- 74042 1
- 74844 1
- 77720 1
- 78430 1
- 79547 1
- 80489 1
- 81524 1
- 83520 1
- 84767 1
- 85662 1
- 86434 1
- 87467 1
- 89397 1
- 90326 1
- 90935 1
- 91589 1
- 92088 1
- 93397 1
- 93859 1
- 94283 1
- 94657 1
- 95020 1
- 95985 1
- 96313 1
- 96606 1
- 96979 1
- 97261 1
- 97756 1
- 97938 1
- 98161 1
- 98366 1
- 98520 1
- 98893 1
- 98988 1
- 99169 1
- 99326 1
- 99427 1
- 99653 1
- 99733 1
- 99820 1
- 99920 1
- 99994 1
- 100116 1
- 100156 1
- 100190 1
- 100224 1
- 100303 1
- 100341 1
- 100367 1
- 100388 1
- 100409 1
- 100468 1
- 100490 1
- 100506 1
- 100517 1
- 100561 1
- 100569 1
- 100584 1
- 100594 1
- 100628 1
- 100642 1
- 100655 1
- 100663 1
- 107267 1
state 1
- Michigan 792
fips 1
- 26099 · 792 ✖
county 1
- Macomb 792
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500870 | 2500870 | 2022-05-13 | Macomb | Michigan | 26099 | 238947 | 3970 |
2497612 | 2497612 | 2022-05-12 | Macomb | Michigan | 26099 | 238947 | 3970 |
2494354 | 2494354 | 2022-05-11 | Macomb | Michigan | 26099 | 238947 | 3970 |
2491096 | 2491096 | 2022-05-10 | Macomb | Michigan | 26099 | 235909 | 3963 |
2487839 | 2487839 | 2022-05-09 | Macomb | Michigan | 26099 | 235909 | 3963 |
2484581 | 2484581 | 2022-05-08 | Macomb | Michigan | 26099 | 235909 | 3963 |
2481323 | 2481323 | 2022-05-07 | Macomb | Michigan | 26099 | 235909 | 3963 |
2478065 | 2478065 | 2022-05-06 | Macomb | Michigan | 26099 | 235909 | 3963 |
2474807 | 2474807 | 2022-05-05 | Macomb | Michigan | 26099 | 235909 | 3963 |
2471550 | 2471550 | 2022-05-04 | Macomb | Michigan | 26099 | 235909 | 3963 |
2468294 | 2468294 | 2022-05-03 | Macomb | Michigan | 26099 | 233892 | 3961 |
2465039 | 2465039 | 2022-05-02 | Macomb | Michigan | 26099 | 233892 | 3961 |
2461783 | 2461783 | 2022-05-01 | Macomb | Michigan | 26099 | 233892 | 3961 |
2458527 | 2458527 | 2022-04-30 | Macomb | Michigan | 26099 | 233892 | 3961 |
2455271 | 2455271 | 2022-04-29 | Macomb | Michigan | 26099 | 233892 | 3961 |
2452015 | 2452015 | 2022-04-28 | Macomb | Michigan | 26099 | 233892 | 3961 |
2448759 | 2448759 | 2022-04-27 | Macomb | Michigan | 26099 | 233892 | 3961 |
2445503 | 2445503 | 2022-04-26 | Macomb | Michigan | 26099 | 232167 | 3958 |
2442247 | 2442247 | 2022-04-25 | Macomb | Michigan | 26099 | 232167 | 3958 |
2438991 | 2438991 | 2022-04-24 | Macomb | Michigan | 26099 | 232167 | 3958 |
2435735 | 2435735 | 2022-04-23 | Macomb | Michigan | 26099 | 232167 | 3958 |
2432479 | 2432479 | 2022-04-22 | Macomb | Michigan | 26099 | 232167 | 3958 |
2429223 | 2429223 | 2022-04-21 | Macomb | Michigan | 26099 | 232167 | 3958 |
2425967 | 2425967 | 2022-04-20 | Macomb | Michigan | 26099 | 232167 | 3958 |
2422711 | 2422711 | 2022-04-19 | Macomb | Michigan | 26099 | 230888 | 3950 |
2419455 | 2419455 | 2022-04-18 | Macomb | Michigan | 26099 | 230888 | 3950 |
2416199 | 2416199 | 2022-04-17 | Macomb | Michigan | 26099 | 230888 | 3950 |
2412943 | 2412943 | 2022-04-16 | Macomb | Michigan | 26099 | 230888 | 3950 |
2409687 | 2409687 | 2022-04-15 | Macomb | Michigan | 26099 | 230888 | 3950 |
2406431 | 2406431 | 2022-04-14 | Macomb | Michigan | 26099 | 230888 | 3950 |
2403175 | 2403175 | 2022-04-13 | Macomb | Michigan | 26099 | 230888 | 3950 |
2399921 | 2399921 | 2022-04-12 | Macomb | Michigan | 26099 | 229921 | 3941 |
2396665 | 2396665 | 2022-04-11 | Macomb | Michigan | 26099 | 229921 | 3941 |
2393410 | 2393410 | 2022-04-10 | Macomb | Michigan | 26099 | 229921 | 3941 |
2390154 | 2390154 | 2022-04-09 | Macomb | Michigan | 26099 | 229921 | 3941 |
2386898 | 2386898 | 2022-04-08 | Macomb | Michigan | 26099 | 229921 | 3941 |
2383643 | 2383643 | 2022-04-07 | Macomb | Michigan | 26099 | 229921 | 3941 |
2380388 | 2380388 | 2022-04-06 | Macomb | Michigan | 26099 | 229921 | 3941 |
2377133 | 2377133 | 2022-04-05 | Macomb | Michigan | 26099 | 229451 | 3935 |
2373881 | 2373881 | 2022-04-04 | Macomb | Michigan | 26099 | 229451 | 3935 |
2370628 | 2370628 | 2022-04-03 | Macomb | Michigan | 26099 | 229451 | 3935 |
2367375 | 2367375 | 2022-04-02 | Macomb | Michigan | 26099 | 229451 | 3935 |
2364122 | 2364122 | 2022-04-01 | Macomb | Michigan | 26099 | 229451 | 3935 |
2360868 | 2360868 | 2022-03-31 | Macomb | Michigan | 26099 | 229120 | 3930 |
2357614 | 2357614 | 2022-03-30 | Macomb | Michigan | 26099 | 229120 | 3930 |
2354361 | 2354361 | 2022-03-29 | Macomb | Michigan | 26099 | 228793 | 3916 |
2351109 | 2351109 | 2022-03-28 | Macomb | Michigan | 26099 | 228793 | 3916 |
2347856 | 2347856 | 2022-03-27 | Macomb | Michigan | 26099 | 228541 | 3914 |
2344603 | 2344603 | 2022-03-26 | Macomb | Michigan | 26099 | 228541 | 3914 |
2341350 | 2341350 | 2022-03-25 | Macomb | Michigan | 26099 | 228541 | 3914 |
2338097 | 2338097 | 2022-03-24 | Macomb | Michigan | 26099 | 228247 | 3911 |
2334843 | 2334843 | 2022-03-23 | Macomb | Michigan | 26099 | 228247 | 3911 |
2331589 | 2331589 | 2022-03-22 | Macomb | Michigan | 26099 | 227917 | 3906 |
2328337 | 2328337 | 2022-03-21 | Macomb | Michigan | 26099 | 227917 | 3906 |
2325084 | 2325084 | 2022-03-20 | Macomb | Michigan | 26099 | 227671 | 3906 |
2321830 | 2321830 | 2022-03-19 | Macomb | Michigan | 26099 | 227671 | 3906 |
2318576 | 2318576 | 2022-03-18 | Macomb | Michigan | 26099 | 227671 | 3906 |
2315323 | 2315323 | 2022-03-17 | Macomb | Michigan | 26099 | 227245 | 3900 |
2312070 | 2312070 | 2022-03-16 | Macomb | Michigan | 26099 | 227245 | 3900 |
2308817 | 2308817 | 2022-03-15 | Macomb | Michigan | 26099 | 226935 | 3891 |
2305566 | 2305566 | 2022-03-14 | Macomb | Michigan | 26099 | 226935 | 3891 |
2302314 | 2302314 | 2022-03-13 | Macomb | Michigan | 26099 | 226734 | 3889 |
2299062 | 2299062 | 2022-03-12 | Macomb | Michigan | 26099 | 226734 | 3889 |
2295810 | 2295810 | 2022-03-11 | Macomb | Michigan | 26099 | 226734 | 3889 |
2292558 | 2292558 | 2022-03-10 | Macomb | Michigan | 26099 | 226445 | 3881 |
2289306 | 2289306 | 2022-03-09 | Macomb | Michigan | 26099 | 226445 | 3881 |
2286055 | 2286055 | 2022-03-08 | Macomb | Michigan | 26099 | 226074 | 3847 |
2282803 | 2282803 | 2022-03-07 | Macomb | Michigan | 26099 | 226074 | 3847 |
2279550 | 2279550 | 2022-03-06 | Macomb | Michigan | 26099 | 225871 | 3846 |
2276297 | 2276297 | 2022-03-05 | Macomb | Michigan | 26099 | 225871 | 3846 |
2273044 | 2273044 | 2022-03-04 | Macomb | Michigan | 26099 | 225871 | 3846 |
2269792 | 2269792 | 2022-03-03 | Macomb | Michigan | 26099 | 225494 | 3837 |
2266539 | 2266539 | 2022-03-02 | Macomb | Michigan | 26099 | 225494 | 3837 |
2263288 | 2263288 | 2022-03-01 | Macomb | Michigan | 26099 | 225108 | 3810 |
2260037 | 2260037 | 2022-02-28 | Macomb | Michigan | 26099 | 225108 | 3810 |
2256786 | 2256786 | 2022-02-27 | Macomb | Michigan | 26099 | 224824 | 3808 |
2253535 | 2253535 | 2022-02-26 | Macomb | Michigan | 26099 | 224824 | 3808 |
2250284 | 2250284 | 2022-02-25 | Macomb | Michigan | 26099 | 224824 | 3808 |
2247033 | 2247033 | 2022-02-24 | Macomb | Michigan | 26099 | 224132 | 3796 |
2243782 | 2243782 | 2022-02-23 | Macomb | Michigan | 26099 | 224132 | 3796 |
2240531 | 2240531 | 2022-02-22 | Macomb | Michigan | 26099 | 223371 | 3750 |
2237280 | 2237280 | 2022-02-21 | Macomb | Michigan | 26099 | 223371 | 3750 |
2234029 | 2234029 | 2022-02-20 | Macomb | Michigan | 26099 | 223371 | 3750 |
2230778 | 2230778 | 2022-02-19 | Macomb | Michigan | 26099 | 222947 | 3738 |
2227527 | 2227527 | 2022-02-18 | Macomb | Michigan | 26099 | 222947 | 3738 |
2224276 | 2224276 | 2022-02-17 | Macomb | Michigan | 26099 | 222947 | 3738 |
2221025 | 2221025 | 2022-02-16 | Macomb | Michigan | 26099 | 222947 | 3738 |
2217774 | 2217774 | 2022-02-15 | Macomb | Michigan | 26099 | 222512 | 3699 |
2214523 | 2214523 | 2022-02-14 | Macomb | Michigan | 26099 | 222512 | 3699 |
2211271 | 2211271 | 2022-02-13 | Macomb | Michigan | 26099 | 222040 | 3698 |
2208018 | 2208018 | 2022-02-12 | Macomb | Michigan | 26099 | 222040 | 3698 |
2204765 | 2204765 | 2022-02-11 | Macomb | Michigan | 26099 | 222040 | 3698 |
2201512 | 2201512 | 2022-02-10 | Macomb | Michigan | 26099 | 221674 | 3681 |
2198258 | 2198258 | 2022-02-09 | Macomb | Michigan | 26099 | 221674 | 3681 |
2195004 | 2195004 | 2022-02-08 | Macomb | Michigan | 26099 | 221041 | 3636 |
2191750 | 2191750 | 2022-02-07 | Macomb | Michigan | 26099 | 221041 | 3636 |
2188497 | 2188497 | 2022-02-06 | Macomb | Michigan | 26099 | 220073 | 3635 |
2185244 | 2185244 | 2022-02-05 | Macomb | Michigan | 26099 | 220073 | 3635 |
2181992 | 2181992 | 2022-02-04 | Macomb | Michigan | 26099 | 220073 | 3635 |
2178740 | 2178740 | 2022-02-03 | Macomb | Michigan | 26099 | 219141 | 3611 |
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);