ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where "date" is on date 2021-08-08 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- Alabama 1
- Alaska 1
- Arizona 1
- Arkansas 1
- California 1
- Colorado 1
- Connecticut 1
- Delaware 1
- District of Columbia 1
- Florida 1
- Georgia 1
- Guam 1
- Hawaii 1
- Idaho 1
- Illinois 1
- Indiana 1
- Iowa 1
- Kansas 1
- Kentucky 1
- Louisiana 1
- Maine 1
- Maryland 1
- Massachusetts 1
- Michigan 1
- Minnesota 1
- Mississippi 1
- Missouri 1
- Montana 1
- Nebraska 1
- Nevada 1
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
28780 | 28780 | 2021-08-08 | Alabama | 1 | 607209 | 11624 |
28781 | 28781 | 2021-08-08 | Alaska | 2 | 76939 | 381 |
28782 | 28782 | 2021-08-08 | Arizona | 4 | 946054 | 18388 |
28783 | 28783 | 2021-08-08 | Arkansas | 5 | 404277 | 6301 |
28784 | 28784 | 2021-08-08 | California | 6 | 4134375 | 64777 |
28785 | 28785 | 2021-08-08 | Colorado | 8 | 585462 | 7140 |
28786 | 28786 | 2021-08-08 | Connecticut | 9 | 358076 | 8296 |
28787 | 28787 | 2021-08-08 | Delaware | 10 | 112772 | 1835 |
28788 | 28788 | 2021-08-08 | District of Columbia | 11 | 51103 | 1149 |
28789 | 28789 | 2021-08-08 | Florida | 12 | 2725450 | 39695 |
28790 | 28790 | 2021-08-08 | Georgia | 13 | 1184614 | 21095 |
28791 | 28791 | 2021-08-08 | Guam | 66 | 9642 | 144 |
28792 | 28792 | 2021-08-08 | Hawaii | 15 | 44609 | 539 |
28793 | 28793 | 2021-08-08 | Idaho | 16 | 204170 | 2218 |
28794 | 28794 | 2021-08-08 | Illinois | 17 | 1440658 | 25992 |
28795 | 28795 | 2021-08-08 | Indiana | 18 | 784685 | 14054 |
28796 | 28796 | 2021-08-08 | Iowa | 19 | 383997 | 6193 |
28797 | 28797 | 2021-08-08 | Kansas | 20 | 340741 | 5335 |
28798 | 28798 | 2021-08-08 | Kentucky | 21 | 496451 | 7432 |
28799 | 28799 | 2021-08-08 | Louisiana | 22 | 573903 | 11210 |
28800 | 28800 | 2021-08-08 | Maine | 23 | 71306 | 901 |
28801 | 28801 | 2021-08-08 | Maryland | 24 | 474189 | 9857 |
28802 | 28802 | 2021-08-08 | Massachusetts | 25 | 726395 | 18095 |
28803 | 28803 | 2021-08-08 | Michigan | 26 | 1017048 | 21210 |
28804 | 28804 | 2021-08-08 | Minnesota | 27 | 617881 | 7787 |
28805 | 28805 | 2021-08-08 | Mississippi | 28 | 358149 | 7621 |
28806 | 28806 | 2021-08-08 | Missouri | 29 | 717419 | 10491 |
28807 | 28807 | 2021-08-08 | Montana | 30 | 117995 | 1722 |
28808 | 28808 | 2021-08-08 | Nebraska | 31 | 230630 | 2553 |
28809 | 28809 | 2021-08-08 | Nevada | 32 | 363574 | 6005 |
28810 | 28810 | 2021-08-08 | New Hampshire | 33 | 101662 | 1389 |
28811 | 28811 | 2021-08-08 | New Jersey | 34 | 1049222 | 26650 |
28812 | 28812 | 2021-08-08 | New Mexico | 35 | 213793 | 4427 |
28813 | 28813 | 2021-08-08 | New York | 36 | 2174515 | 53346 |
28814 | 28814 | 2021-08-08 | North Carolina | 37 | 1072440 | 13752 |
28815 | 28815 | 2021-08-08 | North Dakota | 38 | 112367 | 1573 |
28816 | 28816 | 2021-08-08 | Northern Mariana Islands | 69 | 206 | 2 |
28817 | 28817 | 2021-08-08 | Ohio | 39 | 1142330 | 20556 |
28818 | 28818 | 2021-08-08 | Oklahoma | 40 | 493983 | 7531 |
28819 | 28819 | 2021-08-08 | Oregon | 41 | 226899 | 2915 |
28820 | 28820 | 2021-08-08 | Pennsylvania | 42 | 1240072 | 27902 |
28821 | 28821 | 2021-08-08 | Puerto Rico | 72 | 185347 | 2609 |
28822 | 28822 | 2021-08-08 | Rhode Island | 44 | 155825 | 2743 |
28823 | 28823 | 2021-08-08 | South Carolina | 45 | 634310 | 9950 |
28824 | 28824 | 2021-08-08 | South Dakota | 46 | 125592 | 2050 |
28825 | 28825 | 2021-08-08 | Tennessee | 47 | 899546 | 12731 |
28826 | 28826 | 2021-08-08 | Texas | 48 | 3231454 | 53816 |
28827 | 28827 | 2021-08-08 | Utah | 49 | 438551 | 2494 |
28828 | 28828 | 2021-08-08 | Vermont | 50 | 25320 | 260 |
28829 | 28829 | 2021-08-08 | Virgin Islands | 78 | 4907 | 40 |
28830 | 28830 | 2021-08-08 | Virginia | 51 | 704664 | 11558 |
28831 | 28831 | 2021-08-08 | Washington | 53 | 489960 | 6209 |
28832 | 28832 | 2021-08-08 | West Virginia | 54 | 169162 | 2965 |
28833 | 28833 | 2021-08-08 | Wisconsin | 55 | 695436 | 8300 |
28834 | 28834 | 2021-08-08 | Wyoming | 56 | 66453 | 786 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );