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 2020-12-31 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 |
---|---|---|---|---|---|---|
16680 | 16680 | 2020-12-31 | Alabama | 1 | 361226 | 4827 |
16681 | 16681 | 2020-12-31 | Alaska | 2 | 46740 | 198 |
16682 | 16682 | 2020-12-31 | Arizona | 4 | 523829 | 8879 |
16683 | 16683 | 2020-12-31 | Arkansas | 5 | 225138 | 3676 |
16684 | 16684 | 2020-12-31 | California | 6 | 2307860 | 25965 |
16685 | 16685 | 2020-12-31 | Colorado | 8 | 335579 | 4879 |
16686 | 16686 | 2020-12-31 | Connecticut | 9 | 185708 | 5995 |
16687 | 16687 | 2020-12-31 | Delaware | 10 | 57456 | 926 |
16688 | 16688 | 2020-12-31 | District of Columbia | 11 | 28983 | 786 |
16689 | 16689 | 2020-12-31 | Florida | 12 | 1323307 | 21672 |
16690 | 16690 | 2020-12-31 | Georgia | 13 | 644065 | 10588 |
16691 | 16691 | 2020-12-31 | Guam | 66 | 8286 | 123 |
16692 | 16692 | 2020-12-31 | Hawaii | 15 | 21459 | 286 |
16693 | 16693 | 2020-12-31 | Idaho | 16 | 141388 | 1438 |
16694 | 16694 | 2020-12-31 | Illinois | 17 | 965840 | 17979 |
16695 | 16695 | 2020-12-31 | Indiana | 18 | 514455 | 8263 |
16696 | 16696 | 2020-12-31 | Iowa | 19 | 281712 | 3891 |
16697 | 16697 | 2020-12-31 | Kansas | 20 | 225455 | 2741 |
16698 | 16698 | 2020-12-31 | Kentucky | 21 | 268828 | 2956 |
16699 | 16699 | 2020-12-31 | Louisiana | 22 | 315275 | 7488 |
16700 | 16700 | 2020-12-31 | Maine | 23 | 24201 | 347 |
16701 | 16701 | 2020-12-31 | Maryland | 24 | 276834 | 5895 |
16702 | 16702 | 2020-12-31 | Massachusetts | 25 | 375178 | 12423 |
16703 | 16703 | 2020-12-31 | Michigan | 26 | 526668 | 13010 |
16704 | 16704 | 2020-12-31 | Minnesota | 27 | 415361 | 5382 |
16705 | 16705 | 2020-12-31 | Mississippi | 28 | 215811 | 4787 |
16706 | 16706 | 2020-12-31 | Missouri | 29 | 418637 | 5887 |
16707 | 16707 | 2020-12-31 | Montana | 30 | 81701 | 962 |
16708 | 16708 | 2020-12-31 | Nebraska | 31 | 167795 | 1690 |
16709 | 16709 | 2020-12-31 | Nevada | 32 | 225165 | 3136 |
16710 | 16710 | 2020-12-31 | New Hampshire | 33 | 44028 | 759 |
16711 | 16711 | 2020-12-31 | New Jersey | 34 | 479381 | 19042 |
16712 | 16712 | 2020-12-31 | New Mexico | 35 | 142897 | 2479 |
16713 | 16713 | 2020-12-31 | New York | 36 | 979040 | 37557 |
16714 | 16714 | 2020-12-31 | North Carolina | 37 | 541070 | 6811 |
16715 | 16715 | 2020-12-31 | North Dakota | 38 | 92502 | 1299 |
16716 | 16716 | 2020-12-31 | Northern Mariana Islands | 69 | 122 | 2 |
16717 | 16717 | 2020-12-31 | Ohio | 39 | 700380 | 8962 |
16718 | 16718 | 2020-12-31 | Oklahoma | 40 | 290936 | 2489 |
16719 | 16719 | 2020-12-31 | Oregon | 41 | 113929 | 1485 |
16720 | 16720 | 2020-12-31 | Pennsylvania | 42 | 646060 | 16020 |
16721 | 16721 | 2020-12-31 | Puerto Rico | 72 | 109906 | 1503 |
16722 | 16722 | 2020-12-31 | Rhode Island | 44 | 87949 | 1777 |
16723 | 16723 | 2020-12-31 | South Carolina | 45 | 307507 | 5296 |
16724 | 16724 | 2020-12-31 | South Dakota | 46 | 99164 | 1488 |
16725 | 16725 | 2020-12-31 | Tennessee | 47 | 572579 | 6846 |
16726 | 16726 | 2020-12-31 | Texas | 48 | 1770527 | 28155 |
16727 | 16727 | 2020-12-31 | Utah | 49 | 276612 | 1270 |
16728 | 16728 | 2020-12-31 | Vermont | 50 | 7412 | 136 |
16729 | 16729 | 2020-12-31 | Virgin Islands | 78 | 2031 | 23 |
16730 | 16730 | 2020-12-31 | Virginia | 51 | 349584 | 5032 |
16731 | 16731 | 2020-12-31 | Washington | 53 | 251064 | 3523 |
16732 | 16732 | 2020-12-31 | West Virginia | 54 | 85334 | 1338 |
16733 | 16733 | 2020-12-31 | Wisconsin | 55 | 520438 | 5245 |
16734 | 16734 | 2020-12-31 | Wyoming | 56 | 44409 | 438 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );