ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,027 rows where state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 504 ✖
- 0 16
- 9615 14
- 10255 9
- 6149 7
- 6158 7
- 6170 7
- 6183 7
- 6193 7
- 6210 7
- 6226 7
- 6268 7
- 6307 7
- 6337 7
- 6401 7
- 6563 7
- 6654 7
- 6748 7
- 6848 7
- 6965 7
- 7069 7
- 7166 7
- 7268 7
- 7354 7
- 7445 7
- 7550 7
- 7680 7
- 7799 7
- 7858 7
- 8019 7
- 8201 7
- 8317 7
- 8501 7
- 8657 7
- 8829 7
- 8948 7
- 9085 7
- 9171 7
- 9262 7
- 9349 7
- 9402 7
- 9445 7
- 9454 7
- 9475 7
- 9510 7
- 9529 7
- 9533 7
- 9555 7
- 9572 7
- 9588 7
- 9603 7
- 9680 7
- 9688 7
- 9703 7
- 9759 7
- 9782 7
- 9817 7
- 9850 7
- 9882 7
- 9907 7
- 9940 7
- 9968 7
- 9994 7
- 10051 7
- 10077 7
- 10097 7
- 10153 7
- 10177 7
- 10207 7
- 10296 7
- 10318 7
- 10345 7
- 6482 6
- 9718 5
- 10126 5
- 10231 5
- 6035 4
- 10389 4
- 1 3
- 11 3
- 721 3
- 5336 3
- 5822 3
- 5857 3
- 5927 3
- 6055 3
- 6109 3
- 6146 3
- 10276 3
- 10391 3
- 3 2
- 27 2
- 44 2
- 704 2
- 717 2
- 748 2
- 826 2
- 975 2
- 1265 2
- 3451 2
- 3589 2
- 3744 2
- 3745 2
- 3946 2
- 5108 2
- 5236 2
- 5470 2
- 5673 2
- 5676 2
- 5729 2
- 5858 2
- 5882 2
- 5931 2
- 5959 2
- 5985 2
- 6006 2
- 6102 2
- 6133 2
- 9719 2
- 10125 2
- 10229 2
- 10278 2
- 4 1
- 6 1
- 7 1
- 9 1
- 22 1
- 25 1
- 26 1
- 31 1
- 34 1
- 41 1
- 53 1
- 60 1
- 64 1
- 74 1
- 75 1
- 79 1
- 83 1
- 90 1
- 96 1
- 107 1
- 112 1
- 118 1
- 127 1
- 136 1
- 148 1
- 162 1
- 170 1
- 175 1
- 184 1
- 188 1
- 207 1
- 219 1
- 231 1
- 243 1
- 252 1
- 265 1
- 271 1
- 289 1
- 306 1
- 318 1
- 336 1
- 346 1
- 351 1
- 355 1
- 367 1
- 400 1
- 414 1
- 441 1
- 446 1
- 456 1
- 460 1
- 480 1
- 496 1
- 510 1
- 525 1
- 531 1
- 537 1
- 558 1
- 564 1
- 574 1
- 590 1
- 597 1
- 602 1
- 606 1
- 623 1
- 629 1
- 638 1
- 641 1
- 650 1
- 651 1
- 652 1
- 661 1
- 670 1
- 677 1
- 680 1
- 681 1
- 685 1
- 686 1
- 687 1
- 690 1
- 694 1
- 702 1
- 706 1
- 712 1
- 719 1
- 725 1
- 732 1
- 739 1
- 742 1
- 752 1
- 755 1
- 759 1
- 777 1
- 781 1
- 785 1
- 790 1
- 793 1
- 798 1
- 808 1
- 814 1
- 820 1
- 829 1
- 836 1
- 839 1
- 854 1
- 865 1
- 872 1
- 874 1
- 878 1
- 884 1
- 888 1
- 900 1
- 912 1
- 915 1
- 926 1
- 931 1
- 935 1
- 946 1
- 953 1
- 964 1
- 972 1
- 987 1
- 1002 1
- 1011 1
- 1016 1
- 1030 1
- 1033 1
- 1037 1
- 1047 1
- 1059 1
- 1077 1
- 1091 1
- 1108 1
- 1110 1
- 1113 1
- 1120 1
- 1125 1
- 1134 1
- 1137 1
- 1158 1
- 1165 1
- 1167 1
- 1170 1
- 1185 1
- 1204 1
- 1208 1
- 1216 1
- 1218 1
- 1220 1
- 1233 1
- 1234 1
- 1248 1
- 1257 1
- 1264 1
- 1284 1
- 1293 1
- 1298 1
- 1303 1
- 1312 1
- 1314 1
- 1316 1
- 1324 1
- 1341 1
- 1358 1
- 1366 1
- 1377 1
- 1381 1
- 1387 1
- 1399 1
- 1414 1
- 1419 1
- 1433 1
- 1454 1
- 1460 1
- 1462 1
- 1481 1
- 1491 1
- 1505 1
- 1516 1
- 1524 1
- 1528 1
- 1532 1
- 1548 1
- 1576 1
- 1594 1
- 1617 1
- 1629 1
- 1634 1
- 1635 1
- 1657 1
- 1680 1
- 1691 1
- 1705 1
- 1714 1
- 1716 1
- 1733 1
- 1755 1
- 1780 1
- 1801 1
- 1814 1
- 1828 1
- 1842 1
- 1845 1
- 1872 1
- 1898 1
- 1927 1
- 1947 1
- 1972 1
- 1985 1
- 1989 1
- 2023 1
- 2064 1
- 2102 1
- 2127 1
- 2159 1
- 2191 1
- 2202 1
- 2222 1
- 2271 1
- 2312 1
- 2349 1
- 2360 1
- 2375 1
- 2399 1
- 2426 1
- 2449 1
- 2518 1
- 2603 1
- 2665 1
- 2682 1
- 2717 1
- 2723 1
- 2915 1
- 3017 1
- 3116 1
- 3193 1
- 3208 1
- 3209 1
- 3269 1
- 3337 1
- 3354 1
- 3533 1
- 3653 1
- 3668 1
- 3739 1
- 3812 1
- 3822 1
- 3891 1
- 3898 1
- 3992 1
- 3999 1
- 4060 1
- 4065 1
- 4124 1
- 4127 1
- 4138 1
- 4139 1
- 4222 1
- 4232 1
- 4251 1
- 4257 1
- 4321 1
- 4323 1
- 4324 1
- 4332 1
- 4394 1
- 4445 1
- 4478 1
- 4486 1
- 4487 1
- 4488 1
- 4492 1
- 4500 1
- 4532 1
- 4577 1
- 4651 1
- 4901 1
- 4906 1
- 4919 1
- 4975 1
- 5033 1
- 5067 1
- 5110 1
- 5145 1
- 5174 1
- 5196 1
- 5223 1
- 5237 1
- 5263 1
- 5306 1
- 5321 1
- 5374 1
- 5400 1
- 5415 1
- 5438 1
- 5463 1
- 5472 1
- 5498 1
- 5501 1
- 5536 1
- 5549 1
- 5553 1
- 5559 1
- 5560 1
- 5575 1
- 5602 1
- 5622 1
- 5632 1
- 5634 1
- 5642 1
- 5643 1
- 5658 1
- 5668 1
- 5675 1
- 5683 1
- 5689 1
- 5708 1
- 5716 1
- 5718 1
- 5725 1
- 5743 1
- 5751 1
- 5754 1
- 5835 1
- 5836 1
- 5843 1
- 5849 1
- 5871 1
- 5878 1
- 5887 1
- 5894 1
- 5899 1
- 5904 1
- 5907 1
- 5930 1
- 5950 1
- 5952 1
- 5960 1
- 5962 1
- 5980 1
- 5983 1
- 5984 1
- 5989 1
- 5994 1
- 5998 1
- 5999 1
- 6001 1
- 6013 1
- 6018 1
- 6025 1
- 6039 1
- 6044 1
- 6048 1
- 6053 1
- 6057 1
- 6061 1
- 6065 1
- 6067 1
- 6068 1
- 6072 1
- 6073 1
- 6078 1
- 6084 1
- 6095 1
- 6097 1
- 6099 1
- 6103 1
- 6112 1
- 6114 1
- 6115 1
- 6117 1
- 6120 1
- 6124 1
- 6125 1
- 6131 1
- 6134 1
- 6138 1
- 6140 1
- 6142 1
- 6148 1
- 6483 1
- 10424 1
- 10425 1
state 1
- Iowa · 1,027 ✖
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
57200 | 57200 | 2022-12-29 | Iowa | 19 | 886411 | 10424 |
57144 | 57144 | 2022-12-28 | Iowa | 19 | 886408 | 10425 |
57088 | 57088 | 2022-12-27 | Iowa | 19 | 884263 | 10389 |
57032 | 57032 | 2022-12-26 | Iowa | 19 | 884263 | 10389 |
56976 | 56976 | 2022-12-25 | Iowa | 19 | 884263 | 10389 |
56920 | 56920 | 2022-12-24 | Iowa | 19 | 884263 | 10389 |
56864 | 56864 | 2022-12-23 | Iowa | 19 | 884263 | 10391 |
56808 | 56808 | 2022-12-22 | Iowa | 19 | 884263 | 10391 |
56752 | 56752 | 2022-12-21 | Iowa | 19 | 884262 | 10391 |
56696 | 56696 | 2022-12-20 | Iowa | 19 | 880770 | 10345 |
56640 | 56640 | 2022-12-19 | Iowa | 19 | 880770 | 10345 |
56584 | 56584 | 2022-12-18 | Iowa | 19 | 880770 | 10345 |
56528 | 56528 | 2022-12-17 | Iowa | 19 | 880770 | 10345 |
56472 | 56472 | 2022-12-16 | Iowa | 19 | 880770 | 10345 |
56416 | 56416 | 2022-12-15 | Iowa | 19 | 880770 | 10345 |
56360 | 56360 | 2022-12-14 | Iowa | 19 | 880770 | 10345 |
56304 | 56304 | 2022-12-13 | Iowa | 19 | 877068 | 10318 |
56248 | 56248 | 2022-12-12 | Iowa | 19 | 877068 | 10318 |
56192 | 56192 | 2022-12-11 | Iowa | 19 | 877068 | 10318 |
56136 | 56136 | 2022-12-10 | Iowa | 19 | 877068 | 10318 |
56080 | 56080 | 2022-12-09 | Iowa | 19 | 877068 | 10318 |
56024 | 56024 | 2022-12-08 | Iowa | 19 | 877068 | 10318 |
55968 | 55968 | 2022-12-07 | Iowa | 19 | 877066 | 10318 |
55912 | 55912 | 2022-12-06 | Iowa | 19 | 873597 | 10296 |
55856 | 55856 | 2022-12-05 | Iowa | 19 | 873597 | 10296 |
55800 | 55800 | 2022-12-04 | Iowa | 19 | 873597 | 10296 |
55744 | 55744 | 2022-12-03 | Iowa | 19 | 873597 | 10296 |
55688 | 55688 | 2022-12-02 | Iowa | 19 | 873597 | 10296 |
55632 | 55632 | 2022-12-01 | Iowa | 19 | 873597 | 10296 |
55576 | 55576 | 2022-11-30 | Iowa | 19 | 873595 | 10296 |
55520 | 55520 | 2022-11-29 | Iowa | 19 | 870897 | 10278 |
55464 | 55464 | 2022-11-28 | Iowa | 19 | 870897 | 10278 |
55408 | 55408 | 2022-11-27 | Iowa | 19 | 870897 | 10276 |
55352 | 55352 | 2022-11-26 | Iowa | 19 | 870897 | 10276 |
55296 | 55296 | 2022-11-25 | Iowa | 19 | 870897 | 10276 |
55240 | 55240 | 2022-11-24 | Iowa | 19 | 868595 | 10255 |
55184 | 55184 | 2022-11-23 | Iowa | 19 | 868595 | 10255 |
55128 | 55128 | 2022-11-22 | Iowa | 19 | 868595 | 10255 |
55072 | 55072 | 2022-11-21 | Iowa | 19 | 868595 | 10255 |
55016 | 55016 | 2022-11-20 | Iowa | 19 | 868595 | 10255 |
54960 | 54960 | 2022-11-19 | Iowa | 19 | 868595 | 10255 |
54904 | 54904 | 2022-11-18 | Iowa | 19 | 868595 | 10255 |
54848 | 54848 | 2022-11-17 | Iowa | 19 | 868595 | 10255 |
54792 | 54792 | 2022-11-16 | Iowa | 19 | 868595 | 10255 |
54736 | 54736 | 2022-11-15 | Iowa | 19 | 866615 | 10231 |
54680 | 54680 | 2022-11-14 | Iowa | 19 | 866615 | 10231 |
54624 | 54624 | 2022-11-13 | Iowa | 19 | 866615 | 10231 |
54568 | 54568 | 2022-11-12 | Iowa | 19 | 866615 | 10231 |
54512 | 54512 | 2022-11-11 | Iowa | 19 | 866615 | 10231 |
54456 | 54456 | 2022-11-10 | Iowa | 19 | 866615 | 10229 |
54400 | 54400 | 2022-11-09 | Iowa | 19 | 866615 | 10229 |
54344 | 54344 | 2022-11-08 | Iowa | 19 | 864752 | 10207 |
54288 | 54288 | 2022-11-07 | Iowa | 19 | 864752 | 10207 |
54232 | 54232 | 2022-11-06 | Iowa | 19 | 864752 | 10207 |
54176 | 54176 | 2022-11-05 | Iowa | 19 | 864752 | 10207 |
54120 | 54120 | 2022-11-04 | Iowa | 19 | 864752 | 10207 |
54064 | 54064 | 2022-11-03 | Iowa | 19 | 864752 | 10207 |
54008 | 54008 | 2022-11-02 | Iowa | 19 | 864752 | 10207 |
53952 | 53952 | 2022-11-01 | Iowa | 19 | 862925 | 10177 |
53896 | 53896 | 2022-10-31 | Iowa | 19 | 862925 | 10177 |
53840 | 53840 | 2022-10-30 | Iowa | 19 | 862925 | 10177 |
53784 | 53784 | 2022-10-29 | Iowa | 19 | 862925 | 10177 |
53728 | 53728 | 2022-10-28 | Iowa | 19 | 862925 | 10177 |
53672 | 53672 | 2022-10-27 | Iowa | 19 | 862925 | 10177 |
53616 | 53616 | 2022-10-26 | Iowa | 19 | 862925 | 10177 |
53560 | 53560 | 2022-10-25 | Iowa | 19 | 861010 | 10153 |
53504 | 53504 | 2022-10-24 | Iowa | 19 | 861010 | 10153 |
53448 | 53448 | 2022-10-23 | Iowa | 19 | 861010 | 10153 |
53392 | 53392 | 2022-10-22 | Iowa | 19 | 861010 | 10153 |
53336 | 53336 | 2022-10-21 | Iowa | 19 | 861010 | 10153 |
53280 | 53280 | 2022-10-20 | Iowa | 19 | 861010 | 10153 |
53224 | 53224 | 2022-10-19 | Iowa | 19 | 861010 | 10153 |
53168 | 53168 | 2022-10-18 | Iowa | 19 | 860166 | 10125 |
53112 | 53112 | 2022-10-17 | Iowa | 19 | 860166 | 10125 |
53056 | 53056 | 2022-10-16 | Iowa | 19 | 859632 | 10126 |
53000 | 53000 | 2022-10-15 | Iowa | 19 | 859632 | 10126 |
52944 | 52944 | 2022-10-14 | Iowa | 19 | 859632 | 10126 |
52888 | 52888 | 2022-10-13 | Iowa | 19 | 859632 | 10126 |
52832 | 52832 | 2022-10-12 | Iowa | 19 | 859502 | 10126 |
52776 | 52776 | 2022-10-11 | Iowa | 19 | 858989 | 10097 |
52720 | 52720 | 2022-10-10 | Iowa | 19 | 857944 | 10097 |
52664 | 52664 | 2022-10-09 | Iowa | 19 | 857944 | 10097 |
52608 | 52608 | 2022-10-08 | Iowa | 19 | 857944 | 10097 |
52552 | 52552 | 2022-10-07 | Iowa | 19 | 857944 | 10097 |
52496 | 52496 | 2022-10-06 | Iowa | 19 | 857944 | 10097 |
52440 | 52440 | 2022-10-05 | Iowa | 19 | 857784 | 10097 |
52384 | 52384 | 2022-10-04 | Iowa | 19 | 857128 | 10077 |
52328 | 52328 | 2022-10-03 | Iowa | 19 | 856645 | 10077 |
52272 | 52272 | 2022-10-02 | Iowa | 19 | 856096 | 10077 |
52216 | 52216 | 2022-10-01 | Iowa | 19 | 856096 | 10077 |
52160 | 52160 | 2022-09-30 | Iowa | 19 | 856096 | 10077 |
52104 | 52104 | 2022-09-29 | Iowa | 19 | 856096 | 10077 |
52048 | 52048 | 2022-09-28 | Iowa | 19 | 855931 | 10077 |
51992 | 51992 | 2022-09-27 | Iowa | 19 | 855407 | 10051 |
51936 | 51936 | 2022-09-26 | Iowa | 19 | 854774 | 10051 |
51880 | 51880 | 2022-09-25 | Iowa | 19 | 854054 | 10051 |
51824 | 51824 | 2022-09-24 | Iowa | 19 | 854054 | 10051 |
51768 | 51768 | 2022-09-23 | Iowa | 19 | 854054 | 10051 |
51712 | 51712 | 2022-09-22 | Iowa | 19 | 854054 | 10051 |
51656 | 51656 | 2022-09-21 | Iowa | 19 | 853840 | 10051 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );