ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where "date" is on date 2022-02-03 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- Alabama 1
- Alaska 1
- American Samoa 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
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
38759 | 38759 | 2022-02-03 | Alabama | 1 | 1229300 | 17215 |
38760 | 38760 | 2022-02-03 | Alaska | 2 | 219767 | 1064 |
38761 | 38761 | 2022-02-03 | American Samoa | 60 | 18 | 0 |
38762 | 38762 | 2022-02-03 | Arizona | 4 | 1894335 | 26430 |
38763 | 38763 | 2022-02-03 | Arkansas | 5 | 790223 | 9733 |
38764 | 38764 | 2022-02-03 | California | 6 | 8562030 | 80922 |
38765 | 38765 | 2022-02-03 | Colorado | 8 | 1271310 | 11409 |
38766 | 38766 | 2022-02-03 | Connecticut | 9 | 704871 | 10083 |
38767 | 38767 | 2022-02-03 | Delaware | 10 | 249716 | 2555 |
38768 | 38768 | 2022-02-03 | District of Columbia | 11 | 131284 | 1291 |
38769 | 38769 | 2022-02-03 | Florida | 12 | 5590369 | 65993 |
38770 | 38770 | 2022-02-03 | Georgia | 13 | 2325658 | 32002 |
38771 | 38771 | 2022-02-03 | Guam | 66 | 34757 | 297 |
38772 | 38772 | 2022-02-03 | Hawaii | 15 | 217895 | 1191 |
38773 | 38773 | 2022-02-03 | Idaho | 16 | 387384 | 4468 |
38774 | 38774 | 2022-02-03 | Illinois | 17 | 2943829 | 34966 |
38775 | 38775 | 2022-02-03 | Indiana | 18 | 1646533 | 21666 |
38776 | 38776 | 2022-02-03 | Iowa | 19 | 724912 | 8657 |
38777 | 38777 | 2022-02-03 | Kansas | 20 | 740153 | 7608 |
38778 | 38778 | 2022-02-03 | Kentucky | 21 | 1197175 | 13058 |
38779 | 38779 | 2022-02-03 | Louisiana | 22 | 1185174 | 15841 |
38780 | 38780 | 2022-02-03 | Maine | 23 | 178501 | 1777 |
38781 | 38781 | 2022-02-03 | Maryland | 24 | 960459 | 13611 |
38782 | 38782 | 2022-02-03 | Massachusetts | 25 | 1625704 | 22316 |
38783 | 38783 | 2022-02-03 | Michigan | 26 | 2277192 | 32599 |
38784 | 38784 | 2022-02-03 | Minnesota | 27 | 1352598 | 11711 |
38785 | 38785 | 2022-02-03 | Mississippi | 28 | 744023 | 11202 |
38786 | 38786 | 2022-02-03 | Missouri | 29 | 1364896 | 17837 |
38787 | 38787 | 2022-02-03 | Montana | 30 | 246377 | 3033 |
38788 | 38788 | 2022-02-03 | Nebraska | 31 | 444695 | 3731 |
38789 | 38789 | 2022-02-03 | Nevada | 32 | 663107 | 9084 |
38790 | 38790 | 2022-02-03 | New Hampshire | 33 | 279842 | 2239 |
38791 | 38791 | 2022-02-03 | New Jersey | 34 | 2123207 | 31769 |
38792 | 38792 | 2022-02-03 | New Mexico | 35 | 487604 | 6518 |
38793 | 38793 | 2022-02-03 | New York | 36 | 4814634 | 64812 |
38794 | 38794 | 2022-02-03 | North Carolina | 37 | 2458111 | 21037 |
38795 | 38795 | 2022-02-03 | North Dakota | 38 | 228087 | 2168 |
38796 | 38796 | 2022-02-03 | Northern Mariana Islands | 69 | 5575 | 23 |
38797 | 38797 | 2022-02-03 | Ohio | 39 | 2601241 | 33537 |
38798 | 38798 | 2022-02-03 | Oklahoma | 40 | 988190 | 12193 |
38799 | 38799 | 2022-02-03 | Oregon | 41 | 649389 | 6181 |
38800 | 38800 | 2022-02-03 | Pennsylvania | 42 | 2681717 | 41199 |
38801 | 38801 | 2022-02-03 | Puerto Rico | 72 | 494625 | 3908 |
38802 | 38802 | 2022-02-03 | Rhode Island | 44 | 347041 | 3341 |
38803 | 38803 | 2022-02-03 | South Carolina | 45 | 1400276 | 15744 |
38804 | 38804 | 2022-02-03 | South Dakota | 46 | 229671 | 2677 |
38805 | 38805 | 2022-02-03 | Tennessee | 47 | 1847542 | 22618 |
38806 | 38806 | 2022-02-03 | Texas | 48 | 6308863 | 80518 |
38807 | 38807 | 2022-02-03 | Utah | 49 | 895624 | 4160 |
38808 | 38808 | 2022-02-03 | Vermont | 50 | 106174 | 548 |
38809 | 38809 | 2022-02-03 | Virgin Islands | 78 | 14963 | 102 |
38810 | 38810 | 2022-02-03 | Virginia | 51 | 1565522 | 16548 |
38811 | 38811 | 2022-02-03 | Washington | 53 | 1355172 | 10961 |
38812 | 38812 | 2022-02-03 | West Virginia | 54 | 455201 | 5829 |
38813 | 38813 | 2022-02-03 | Wisconsin | 55 | 1531529 | 12548 |
38814 | 38814 | 2022-02-03 | Wyoming | 56 | 149126 | 1650 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );