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)
state 1
- Iowa · 321 ✖
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
17906 | 17906 | 2021-01-22 | Iowa | 19 | 311695 | 4478 |
17851 | 17851 | 2021-01-21 | Iowa | 19 | 310440 | 4445 |
17796 | 17796 | 2021-01-20 | Iowa | 19 | 308787 | 4394 |
17741 | 17741 | 2021-01-19 | Iowa | 19 | 307302 | 4332 |
17686 | 17686 | 2021-01-18 | Iowa | 19 | 306082 | 4324 |
17631 | 17631 | 2021-01-17 | Iowa | 19 | 305151 | 4323 |
17576 | 17576 | 2021-01-16 | Iowa | 19 | 304748 | 4321 |
17521 | 17521 | 2021-01-15 | Iowa | 19 | 303927 | 4257 |
17466 | 17466 | 2021-01-14 | Iowa | 19 | 302559 | 4251 |
17411 | 17411 | 2021-01-13 | Iowa | 19 | 301161 | 4232 |
17356 | 17356 | 2021-01-12 | Iowa | 19 | 299254 | 4222 |
17301 | 17301 | 2021-01-11 | Iowa | 19 | 297774 | 4139 |
17246 | 17246 | 2021-01-10 | Iowa | 19 | 296682 | 4138 |
17191 | 17191 | 2021-01-09 | Iowa | 19 | 296171 | 4127 |
17136 | 17136 | 2021-01-08 | Iowa | 19 | 294762 | 4124 |
17081 | 17081 | 2021-01-07 | Iowa | 19 | 293189 | 4065 |
17026 | 17026 | 2021-01-06 | Iowa | 19 | 290776 | 4060 |
16971 | 16971 | 2021-01-05 | Iowa | 19 | 288298 | 3999 |
16916 | 16916 | 2021-01-04 | Iowa | 19 | 286356 | 3992 |
16861 | 16861 | 2021-01-03 | Iowa | 19 | 284715 | 3946 |
16806 | 16806 | 2021-01-02 | Iowa | 19 | 283895 | 3946 |
16751 | 16751 | 2021-01-01 | Iowa | 19 | 282980 | 3898 |
16696 | 16696 | 2020-12-31 | Iowa | 19 | 281712 | 3891 |
16641 | 16641 | 2020-12-30 | Iowa | 19 | 280067 | 3822 |
16586 | 16586 | 2020-12-29 | Iowa | 19 | 278310 | 3812 |
16531 | 16531 | 2020-12-28 | Iowa | 19 | 276649 | 3745 |
16476 | 16476 | 2020-12-27 | Iowa | 19 | 275299 | 3745 |
16421 | 16421 | 2020-12-26 | Iowa | 19 | 274793 | 3744 |
16366 | 16366 | 2020-12-25 | Iowa | 19 | 274266 | 3744 |
16311 | 16311 | 2020-12-24 | Iowa | 19 | 273661 | 3739 |
16256 | 16256 | 2020-12-23 | Iowa | 19 | 272112 | 3668 |
16201 | 16201 | 2020-12-22 | Iowa | 19 | 270294 | 3653 |
16146 | 16146 | 2020-12-21 | Iowa | 19 | 268736 | 3589 |
16091 | 16091 | 2020-12-20 | Iowa | 19 | 267329 | 3589 |
16036 | 16036 | 2020-12-19 | Iowa | 19 | 266959 | 3533 |
15981 | 15981 | 2020-12-18 | Iowa | 19 | 264729 | 3451 |
15926 | 15926 | 2020-12-17 | Iowa | 19 | 262210 | 3451 |
15871 | 15871 | 2020-12-16 | Iowa | 19 | 260784 | 3354 |
15816 | 15816 | 2020-12-15 | Iowa | 19 | 258253 | 3337 |
15761 | 15761 | 2020-12-14 | Iowa | 19 | 256902 | 3269 |
15706 | 15706 | 2020-12-13 | Iowa | 19 | 256249 | 3209 |
15651 | 15651 | 2020-12-12 | Iowa | 19 | 255009 | 3208 |
15596 | 15596 | 2020-12-11 | Iowa | 19 | 253612 | 3193 |
15541 | 15541 | 2020-12-10 | Iowa | 19 | 251027 | 3116 |
15486 | 15486 | 2020-12-09 | Iowa | 19 | 248782 | 3017 |
15431 | 15431 | 2020-12-08 | Iowa | 19 | 246237 | 2915 |
15376 | 15376 | 2020-12-07 | Iowa | 19 | 245985 | 2723 |
15321 | 15321 | 2020-12-06 | Iowa | 19 | 244689 | 2717 |
15266 | 15266 | 2020-12-05 | Iowa | 19 | 243385 | 2682 |
15211 | 15211 | 2020-12-04 | Iowa | 19 | 241531 | 2665 |
15156 | 15156 | 2020-12-03 | Iowa | 19 | 238722 | 2603 |
15101 | 15101 | 2020-12-02 | Iowa | 19 | 236159 | 2518 |
15046 | 15046 | 2020-12-01 | Iowa | 19 | 233062 | 2449 |
14991 | 14991 | 2020-11-30 | Iowa | 19 | 230634 | 2426 |
14936 | 14936 | 2020-11-29 | Iowa | 19 | 228690 | 2399 |
14881 | 14881 | 2020-11-28 | Iowa | 19 | 227181 | 2375 |
14826 | 14826 | 2020-11-27 | Iowa | 19 | 225065 | 2360 |
14771 | 14771 | 2020-11-26 | Iowa | 19 | 223323 | 2349 |
14716 | 14716 | 2020-11-25 | Iowa | 19 | 221288 | 2312 |
14661 | 14661 | 2020-11-24 | Iowa | 19 | 217786 | 2271 |
14606 | 14606 | 2020-11-23 | Iowa | 19 | 214792 | 2222 |
14551 | 14551 | 2020-11-22 | Iowa | 19 | 211664 | 2202 |
14496 | 14496 | 2020-11-21 | Iowa | 19 | 209203 | 2191 |
14441 | 14441 | 2020-11-20 | Iowa | 19 | 205918 | 2159 |
14386 | 14386 | 2020-11-19 | Iowa | 19 | 201572 | 2127 |
14331 | 14331 | 2020-11-18 | Iowa | 19 | 197532 | 2102 |
14276 | 14276 | 2020-11-17 | Iowa | 19 | 193196 | 2064 |
14221 | 14221 | 2020-11-16 | Iowa | 19 | 189597 | 2023 |
14166 | 14166 | 2020-11-15 | Iowa | 19 | 186314 | 1989 |
14111 | 14111 | 2020-11-14 | Iowa | 19 | 183557 | 1985 |
14056 | 14056 | 2020-11-13 | Iowa | 19 | 178890 | 1972 |
14001 | 14001 | 2020-11-12 | Iowa | 19 | 173401 | 1947 |
13946 | 13946 | 2020-11-11 | Iowa | 19 | 168457 | 1927 |
13891 | 13891 | 2020-11-10 | Iowa | 19 | 163827 | 1898 |
13836 | 13836 | 2020-11-09 | Iowa | 19 | 159910 | 1872 |
13781 | 13781 | 2020-11-08 | Iowa | 19 | 155583 | 1845 |
13726 | 13726 | 2020-11-07 | Iowa | 19 | 150639 | 1842 |
13671 | 13671 | 2020-11-06 | Iowa | 19 | 146267 | 1828 |
13616 | 13616 | 2020-11-05 | Iowa | 19 | 142795 | 1814 |
13561 | 13561 | 2020-11-04 | Iowa | 19 | 137315 | 1801 |
13506 | 13506 | 2020-11-03 | Iowa | 19 | 134576 | 1780 |
13451 | 13451 | 2020-11-02 | Iowa | 19 | 132697 | 1755 |
13396 | 13396 | 2020-11-01 | Iowa | 19 | 131097 | 1733 |
13341 | 13341 | 2020-10-31 | Iowa | 19 | 128798 | 1716 |
13286 | 13286 | 2020-10-30 | Iowa | 19 | 125973 | 1714 |
13231 | 13231 | 2020-10-29 | Iowa | 19 | 123232 | 1705 |
13176 | 13176 | 2020-10-28 | Iowa | 19 | 120911 | 1691 |
13121 | 13121 | 2020-10-27 | Iowa | 19 | 118852 | 1680 |
13066 | 13066 | 2020-10-26 | Iowa | 19 | 117198 | 1657 |
13011 | 13011 | 2020-10-25 | Iowa | 19 | 116238 | 1635 |
12956 | 12956 | 2020-10-24 | Iowa | 19 | 114952 | 1634 |
12901 | 12901 | 2020-10-23 | Iowa | 19 | 113596 | 1629 |
12846 | 12846 | 2020-10-22 | Iowa | 19 | 112242 | 1617 |
12791 | 12791 | 2020-10-21 | Iowa | 19 | 110444 | 1594 |
12736 | 12736 | 2020-10-20 | Iowa | 19 | 109210 | 1576 |
12681 | 12681 | 2020-10-19 | Iowa | 19 | 108114 | 1548 |
12626 | 12626 | 2020-10-18 | Iowa | 19 | 107334 | 1532 |
12571 | 12571 | 2020-10-17 | Iowa | 19 | 106698 | 1528 |
12516 | 12516 | 2020-10-16 | Iowa | 19 | 105746 | 1524 |
12461 | 12461 | 2020-10-15 | Iowa | 19 | 104232 | 1516 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );