ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Macoupin" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 590 ✖
- 46 13
- 41 10
- 45 8
- 4782 7
- 39 5
- 47 5
- 7481 5
- 30 4
- 51 4
- 4812 4
- 5895 4
- 6820 4
- 8280 4
- 8541 4
- 10387 4
- 12447 4
- 12549 4
- 12747 4
- 16 3
- 38 3
- 4772 3
- 4783 3
- 4786 3
- 4839 3
- 4881 3
- 4933 3
- 5010 3
- 5112 3
- 5268 3
- 5432 3
- 5618 3
- 6136 3
- 6365 3
- 6525 3
- 6676 3
- 6893 3
- 6988 3
- 7096 3
- 7213 3
- 7323 3
- 7421 3
- 7659 3
- 7882 3
- 8093 3
- 9268 3
- 11376 3
- 11975 3
- 12314 3
- 12611 3
- 12653 3
- 12681 3
- 12703 3
- 12728 3
- 12771 3
- 12784 3
- 12816 3
- 12858 3
- 12906 3
- 1 2
- 14 2
- 17 2
- 21 2
- 24 2
- 28 2
- 32 2
- 42 2
- 58 2
- 86 2
- 101 2
- 142 2
- 345 2
- 432 2
- 854 2
- 3273 2
- 4624 2
- 4715 2
- 4746 2
- 4765 2
- 7295 2
- 12262 2
- 12779 2
- 4 1
- 5 1
- 7 1
- 8 1
- 10 1
- 12 1
- 18 1
- 20 1
- 22 1
- 25 1
- 31 1
- 34 1
- 36 1
- 40 1
- 43 1
- 44 1
- 48 1
- 49 1
- 50 1
- 52 1
- 53 1
- 54 1
- 55 1
- 60 1
- 61 1
- 62 1
- 66 1
- 67 1
- 69 1
- 70 1
- 72 1
- 75 1
- 76 1
- 83 1
- 89 1
- 95 1
- 100 1
- 106 1
- 109 1
- 112 1
- 117 1
- 122 1
- 123 1
- 127 1
- 131 1
- 135 1
- 137 1
- 154 1
- 156 1
- 170 1
- 179 1
- 181 1
- 182 1
- 200 1
- 209 1
- 222 1
- 235 1
- 241 1
- 245 1
- 252 1
- 260 1
- 274 1
- 281 1
- 290 1
- 296 1
- 301 1
- 302 1
- 324 1
- 333 1
- 340 1
- 349 1
- 352 1
- 362 1
- 364 1
- 388 1
- 391 1
- 394 1
- 396 1
- 402 1
- 410 1
- 418 1
- 423 1
- 435 1
- 440 1
- 450 1
- 461 1
- 470 1
- 486 1
- 495 1
- 496 1
- 498 1
- 515 1
- 523 1
- 535 1
- 540 1
- 544 1
- 550 1
- 556 1
- 567 1
- 576 1
- 581 1
- 593 1
- 595 1
- 597 1
- 603 1
- 610 1
- 620 1
- 630 1
- 636 1
- 646 1
- 647 1
- 654 1
- 664 1
- 685 1
- 703 1
- 709 1
- 722 1
- 731 1
- 741 1
- 751 1
- 760 1
- 771 1
- 784 1
- 807 1
- 816 1
- 824 1
- 829 1
- 843 1
- 877 1
- 879 1
- 893 1
- 919 1
- 951 1
- 1021 1
- 1054 1
- 1101 1
- 1144 1
- 1205 1
- 1300 1
- 1344 1
- 1406 1
- 1458 1
- 1489 1
- 1518 1
- 1573 1
- 1630 1
- 1762 1
- 1828 1
- 1874 1
- 1895 1
- 1918 1
- 1988 1
- 2056 1
- 2108 1
- 2115 1
- 2184 1
- 2232 1
- 2276 1
- 2321 1
- 2385 1
- 2414 1
- 2467 1
- 2495 1
- 2518 1
- 2547 1
- 2593 1
- 2642 1
- 2679 1
- 2725 1
- 2758 1
- 2779 1
- 2795 1
- 2840 1
- 2877 1
- 2915 1
- 2952 1
- 2984 1
- 3004 1
- 3019 1
- 3053 1
- 3071 1
- 3102 1
- 3114 1
- 3130 1
- 3143 1
- 3155 1
- 3199 1
- 3236 1
- 3314 1
- 3335 1
- 3357 1
- 3379 1
- 3413 1
- 3454 1
- 3490 1
- 3546 1
- 3574 1
- 3606 1
- 3657 1
- 3704 1
- 3739 1
- 3772 1
- 3795 1
- 3810 1
- 3826 1
- 3849 1
- 3879 1
- 3913 1
- 3975 1
- 4002 1
- 4009 1
- 4029 1
- 4056 1
- 4073 1
- 4090 1
- 4112 1
- 4127 1
- 4136 1
- 4146 1
- 4162 1
- 4180 1
- 4193 1
- 4194 1
- 4211 1
- 4213 1
- 4223 1
- 4227 1
- 4241 1
- 4252 1
- 4259 1
- 4267 1
- 4275 1
- 4276 1
- 4286 1
- 4288 1
- 4294 1
- 4306 1
- 4312 1
- 4314 1
- 4318 1
- 4321 1
- 4329 1
- 4340 1
- 4344 1
- 4347 1
- 4350 1
- 4352 1
- 4360 1
- 4364 1
- 4370 1
- 4372 1
- 4379 1
- 4385 1
- 4386 1
- 4398 1
- 4407 1
- 4410 1
- 4413 1
- 4416 1
- 4417 1
- 4424 1
- 4431 1
- 4438 1
- 4446 1
- 4448 1
- 4456 1
- 4459 1
- 4460 1
- 4465 1
- 4469 1
- 4470 1
- 4479 1
- 4481 1
- 4484 1
- 4486 1
- 4491 1
- 4496 1
- 4502 1
- 4504 1
- 4506 1
- 4507 1
- 4508 1
- 4509 1
- 4514 1
- 4527 1
- 4534 1
- 4543 1
- 4548 1
- 4550 1
- 4557 1
- 4566 1
- 4575 1
- 4582 1
- 4588 1
- 4593 1
- 4596 1
- 4602 1
- 4606 1
- 4611 1
- 4616 1
- 4622 1
- 4628 1
- 4633 1
- 4636 1
- 4643 1
- 4645 1
- 4648 1
- 4656 1
- 4660 1
- 4667 1
- 4669 1
- 4671 1
- 4673 1
- 4675 1
- 4676 1
- 4686 1
- 4690 1
- 4697 1
- 4702 1
- 4708 1
- 4729 1
- 4735 1
- 4740 1
- 4744 1
- 4745 1
- 4748 1
- 4752 1
- 4759 1
- 4761 1
- 4762 1
- 4766 1
- 4767 1
- 4771 1
- 4773 1
- 4774 1
- 4775 1
- 4776 1
- 4778 1
- 4780 1
- 4781 1
- 4785 1
- 4791 1
- 4794 1
- 4802 1
- 4809 1
- 4817 1
- 4827 1
- 4834 1
- 4843 1
- 4855 1
- 4866 1
- 4875 1
- 4894 1
- 4899 1
- 4906 1
- 4924 1
- 4959 1
- 4970 1
- 4987 1
- 4995 1
- 5040 1
- 5061 1
- 5085 1
- 5103 1
- 5145 1
- 5182 1
- 5208 1
- 5242 1
- 5313 1
- 5348 1
- 5379 1
- 5403 1
- 5477 1
- 5491 1
- 5540 1
- 5572 1
- 5713 1
- 5757 1
- 5807 1
- 5857 1
- 5970 1
- 6019 1
- 6066 1
- 6205 1
- 6263 1
- 6299 1
- 6339 1
- 6415 1
- 6437 1
- 6463 1
- 6493 1
- 6562 1
- 6581 1
- 6618 1
- 6651 1
- 6727 1
- 6755 1
- 6779 1
- 6800 1
- 6845 1
- 6858 1
- 6877 1
- 6927 1
- 6938 1
- 6951 1
- 6965 1
- 7010 1
- 7035 1
- 7058 1
- 7081 1
- 7127 1
- 7146 1
- 7170 1
- 7190 1
- 7245 1
- 7262 1
- 7356 1
- 7372 1
- 7388 1
- 7405 1
- 7448 1
- 7464 1
- 7542 1
- 7564 1
- 7591 1
- 7640 1
- 7710 1
- 7749 1
- 7795 1
- 7830 1
- 7943 1
- 7976 1
- 8031 1
- 8061 1
- 8188 1
- 8220 1
- 8255 1
- 8372 1
- 8430 1
- 8473 1
- 8732 1
- 8827 1
- 8951 1
- 9128 1
- 9572 1
- 9735 1
- 9958 1
- 10183 1
- 10802 1
- 11079 1
- 11232 1
- 11595 1
- 11686 1
- 11786 1
- 11885 1
- 12136 1
- 12201 1
- 12361 1
- 12392 1
- 12420 1
- 12505 1
- 12518 1
- 12529 1
- 12537 1
- 12576 1
- 12587 1
- 12598 1
- 12630 1
- 12644 1
- 12648 1
- 12651 1
- 12666 1
- 12668 1
- 12673 1
- 12677 1
- 12687 1
- 12692 1
- 12697 1
- 12701 1
- 12708 1
- 12711 1
- 12720 1
- 12724 1
- 12733 1
- 12739 1
- 12746 1
- 12756 1
- 12764 1
- 12766 1
- 12769 1
- 12780 1
- 12782 1
- 12790 1
- 12796 1
- 12801 1
- 12807 1
- 12831 1
- 12838 1
- 12843 1
- 12850 1
- 12870 1
- 12882 1
- 12886 1
- 12894 1
- 12928 1
- 12942 1
- 12949 1
- 12956 1
- 12975 1
state 1
- Illinois · 772 ✖
fips 1
- 17117 772
county 1
- Macoupin · 772 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500232 | 2500232 | 2022-05-13 | Macoupin | Illinois | 17117 | 12975 | 171 |
2496974 | 2496974 | 2022-05-12 | Macoupin | Illinois | 17117 | 12956 | 171 |
2493716 | 2493716 | 2022-05-11 | Macoupin | Illinois | 17117 | 12949 | 171 |
2490458 | 2490458 | 2022-05-10 | Macoupin | Illinois | 17117 | 12942 | 171 |
2487201 | 2487201 | 2022-05-09 | Macoupin | Illinois | 17117 | 12928 | 171 |
2483943 | 2483943 | 2022-05-08 | Macoupin | Illinois | 17117 | 12906 | 171 |
2480685 | 2480685 | 2022-05-07 | Macoupin | Illinois | 17117 | 12906 | 171 |
2477427 | 2477427 | 2022-05-06 | Macoupin | Illinois | 17117 | 12906 | 171 |
2474169 | 2474169 | 2022-05-05 | Macoupin | Illinois | 17117 | 12894 | 171 |
2470912 | 2470912 | 2022-05-04 | Macoupin | Illinois | 17117 | 12886 | 171 |
2467656 | 2467656 | 2022-05-03 | Macoupin | Illinois | 17117 | 12882 | 171 |
2464401 | 2464401 | 2022-05-02 | Macoupin | Illinois | 17117 | 12870 | 171 |
2461145 | 2461145 | 2022-05-01 | Macoupin | Illinois | 17117 | 12858 | 171 |
2457889 | 2457889 | 2022-04-30 | Macoupin | Illinois | 17117 | 12858 | 171 |
2454633 | 2454633 | 2022-04-29 | Macoupin | Illinois | 17117 | 12858 | 171 |
2451377 | 2451377 | 2022-04-28 | Macoupin | Illinois | 17117 | 12850 | 171 |
2448121 | 2448121 | 2022-04-27 | Macoupin | Illinois | 17117 | 12843 | 171 |
2444865 | 2444865 | 2022-04-26 | Macoupin | Illinois | 17117 | 12838 | 171 |
2441609 | 2441609 | 2022-04-25 | Macoupin | Illinois | 17117 | 12831 | 171 |
2438353 | 2438353 | 2022-04-24 | Macoupin | Illinois | 17117 | 12816 | 171 |
2435097 | 2435097 | 2022-04-23 | Macoupin | Illinois | 17117 | 12816 | 171 |
2431841 | 2431841 | 2022-04-22 | Macoupin | Illinois | 17117 | 12816 | 171 |
2428585 | 2428585 | 2022-04-21 | Macoupin | Illinois | 17117 | 12807 | 171 |
2425329 | 2425329 | 2022-04-20 | Macoupin | Illinois | 17117 | 12801 | 171 |
2422073 | 2422073 | 2022-04-19 | Macoupin | Illinois | 17117 | 12796 | 171 |
2418817 | 2418817 | 2022-04-18 | Macoupin | Illinois | 17117 | 12790 | 171 |
2415561 | 2415561 | 2022-04-17 | Macoupin | Illinois | 17117 | 12784 | 171 |
2412305 | 2412305 | 2022-04-16 | Macoupin | Illinois | 17117 | 12784 | 171 |
2409049 | 2409049 | 2022-04-15 | Macoupin | Illinois | 17117 | 12784 | 171 |
2405793 | 2405793 | 2022-04-14 | Macoupin | Illinois | 17117 | 12782 | 171 |
2402538 | 2402538 | 2022-04-13 | Macoupin | Illinois | 17117 | 12780 | 171 |
2399283 | 2399283 | 2022-04-12 | Macoupin | Illinois | 17117 | 12779 | 171 |
2396028 | 2396028 | 2022-04-11 | Macoupin | Illinois | 17117 | 12779 | 171 |
2392772 | 2392772 | 2022-04-10 | Macoupin | Illinois | 17117 | 12771 | 171 |
2389516 | 2389516 | 2022-04-09 | Macoupin | Illinois | 17117 | 12771 | 171 |
2386261 | 2386261 | 2022-04-08 | Macoupin | Illinois | 17117 | 12771 | 171 |
2383006 | 2383006 | 2022-04-07 | Macoupin | Illinois | 17117 | 12769 | 171 |
2379751 | 2379751 | 2022-04-06 | Macoupin | Illinois | 17117 | 12766 | 171 |
2376497 | 2376497 | 2022-04-05 | Macoupin | Illinois | 17117 | 12764 | 171 |
2373245 | 2373245 | 2022-04-04 | Macoupin | Illinois | 17117 | 12756 | 170 |
2369992 | 2369992 | 2022-04-03 | Macoupin | Illinois | 17117 | 12747 | 170 |
2366739 | 2366739 | 2022-04-02 | Macoupin | Illinois | 17117 | 12747 | 170 |
2363486 | 2363486 | 2022-04-01 | Macoupin | Illinois | 17117 | 12747 | 170 |
2360232 | 2360232 | 2022-03-31 | Macoupin | Illinois | 17117 | 12746 | 170 |
2356978 | 2356978 | 2022-03-30 | Macoupin | Illinois | 17117 | 12747 | 170 |
2353725 | 2353725 | 2022-03-29 | Macoupin | Illinois | 17117 | 12739 | 170 |
2350473 | 2350473 | 2022-03-28 | Macoupin | Illinois | 17117 | 12733 | 170 |
2347220 | 2347220 | 2022-03-27 | Macoupin | Illinois | 17117 | 12728 | 170 |
2343967 | 2343967 | 2022-03-26 | Macoupin | Illinois | 17117 | 12728 | 170 |
2340714 | 2340714 | 2022-03-25 | Macoupin | Illinois | 17117 | 12728 | 170 |
2337461 | 2337461 | 2022-03-24 | Macoupin | Illinois | 17117 | 12724 | 170 |
2334207 | 2334207 | 2022-03-23 | Macoupin | Illinois | 17117 | 12720 | 169 |
2330953 | 2330953 | 2022-03-22 | Macoupin | Illinois | 17117 | 12711 | 168 |
2327701 | 2327701 | 2022-03-21 | Macoupin | Illinois | 17117 | 12708 | 168 |
2324448 | 2324448 | 2022-03-20 | Macoupin | Illinois | 17117 | 12703 | 168 |
2321194 | 2321194 | 2022-03-19 | Macoupin | Illinois | 17117 | 12703 | 168 |
2317940 | 2317940 | 2022-03-18 | Macoupin | Illinois | 17117 | 12703 | 168 |
2314687 | 2314687 | 2022-03-17 | Macoupin | Illinois | 17117 | 12701 | 168 |
2311434 | 2311434 | 2022-03-16 | Macoupin | Illinois | 17117 | 12697 | 168 |
2308181 | 2308181 | 2022-03-15 | Macoupin | Illinois | 17117 | 12692 | 168 |
2304930 | 2304930 | 2022-03-14 | Macoupin | Illinois | 17117 | 12687 | 167 |
2301678 | 2301678 | 2022-03-13 | Macoupin | Illinois | 17117 | 12681 | 166 |
2298426 | 2298426 | 2022-03-12 | Macoupin | Illinois | 17117 | 12681 | 166 |
2295174 | 2295174 | 2022-03-11 | Macoupin | Illinois | 17117 | 12681 | 166 |
2291922 | 2291922 | 2022-03-10 | Macoupin | Illinois | 17117 | 12677 | 166 |
2288670 | 2288670 | 2022-03-09 | Macoupin | Illinois | 17117 | 12673 | 166 |
2285419 | 2285419 | 2022-03-08 | Macoupin | Illinois | 17117 | 12668 | 166 |
2282167 | 2282167 | 2022-03-07 | Macoupin | Illinois | 17117 | 12666 | 166 |
2278914 | 2278914 | 2022-03-06 | Macoupin | Illinois | 17117 | 12653 | 166 |
2275661 | 2275661 | 2022-03-05 | Macoupin | Illinois | 17117 | 12653 | 166 |
2272408 | 2272408 | 2022-03-04 | Macoupin | Illinois | 17117 | 12653 | 166 |
2269156 | 2269156 | 2022-03-03 | Macoupin | Illinois | 17117 | 12651 | 166 |
2265903 | 2265903 | 2022-03-02 | Macoupin | Illinois | 17117 | 12648 | 166 |
2262652 | 2262652 | 2022-03-01 | Macoupin | Illinois | 17117 | 12644 | 166 |
2259401 | 2259401 | 2022-02-28 | Macoupin | Illinois | 17117 | 12630 | 166 |
2256150 | 2256150 | 2022-02-27 | Macoupin | Illinois | 17117 | 12611 | 166 |
2252899 | 2252899 | 2022-02-26 | Macoupin | Illinois | 17117 | 12611 | 166 |
2249648 | 2249648 | 2022-02-25 | Macoupin | Illinois | 17117 | 12611 | 166 |
2246397 | 2246397 | 2022-02-24 | Macoupin | Illinois | 17117 | 12598 | 166 |
2243146 | 2243146 | 2022-02-23 | Macoupin | Illinois | 17117 | 12587 | 166 |
2239895 | 2239895 | 2022-02-22 | Macoupin | Illinois | 17117 | 12576 | 166 |
2236644 | 2236644 | 2022-02-21 | Macoupin | Illinois | 17117 | 12549 | 165 |
2233393 | 2233393 | 2022-02-20 | Macoupin | Illinois | 17117 | 12549 | 165 |
2230142 | 2230142 | 2022-02-19 | Macoupin | Illinois | 17117 | 12549 | 165 |
2226891 | 2226891 | 2022-02-18 | Macoupin | Illinois | 17117 | 12549 | 165 |
2223640 | 2223640 | 2022-02-17 | Macoupin | Illinois | 17117 | 12537 | 165 |
2220389 | 2220389 | 2022-02-16 | Macoupin | Illinois | 17117 | 12529 | 165 |
2217138 | 2217138 | 2022-02-15 | Macoupin | Illinois | 17117 | 12518 | 163 |
2213887 | 2213887 | 2022-02-14 | Macoupin | Illinois | 17117 | 12505 | 163 |
2210635 | 2210635 | 2022-02-13 | Macoupin | Illinois | 17117 | 12447 | 162 |
2207382 | 2207382 | 2022-02-12 | Macoupin | Illinois | 17117 | 12447 | 162 |
2204129 | 2204129 | 2022-02-11 | Macoupin | Illinois | 17117 | 12447 | 162 |
2200876 | 2200876 | 2022-02-10 | Macoupin | Illinois | 17117 | 12447 | 162 |
2197622 | 2197622 | 2022-02-09 | Macoupin | Illinois | 17117 | 12420 | 161 |
2194368 | 2194368 | 2022-02-08 | Macoupin | Illinois | 17117 | 12392 | 158 |
2191114 | 2191114 | 2022-02-07 | Macoupin | Illinois | 17117 | 12361 | 158 |
2187861 | 2187861 | 2022-02-06 | Macoupin | Illinois | 17117 | 12314 | 158 |
2184608 | 2184608 | 2022-02-05 | Macoupin | Illinois | 17117 | 12314 | 158 |
2181356 | 2181356 | 2022-02-04 | Macoupin | Illinois | 17117 | 12314 | 158 |
2178105 | 2178105 | 2022-02-03 | Macoupin | Illinois | 17117 | 12262 | 157 |
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);