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 2021-11-23 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 |
---|---|---|---|---|---|---|
34727 | 34727 | 2021-11-23 | Alabama | 1 | 843780 | 16086 |
34728 | 34728 | 2021-11-23 | Alaska | 2 | 148004 | 840 |
34729 | 34729 | 2021-11-23 | American Samoa | 60 | 5 | 0 |
34730 | 34730 | 2021-11-23 | Arizona | 4 | 1248184 | 22062 |
34731 | 34731 | 2021-11-23 | Arkansas | 5 | 525130 | 8627 |
34732 | 34732 | 2021-11-23 | California | 6 | 5055959 | 74157 |
34733 | 34733 | 2021-11-23 | Colorado | 8 | 818476 | 9201 |
34734 | 34734 | 2021-11-23 | Connecticut | 9 | 415732 | 8853 |
34735 | 34735 | 2021-11-23 | Delaware | 10 | 150876 | 2162 |
34736 | 34736 | 2021-11-23 | District of Columbia | 11 | 66433 | 1196 |
34737 | 34737 | 2021-11-23 | Florida | 12 | 3682809 | 61147 |
34738 | 34738 | 2021-11-23 | Georgia | 13 | 1623871 | 29181 |
34739 | 34739 | 2021-11-23 | Guam | 66 | 20086 | 264 |
34740 | 34740 | 2021-11-23 | Hawaii | 15 | 84135 | 999 |
34741 | 34741 | 2021-11-23 | Idaho | 16 | 304589 | 3884 |
34742 | 34742 | 2021-11-23 | Illinois | 17 | 1785089 | 29234 |
34743 | 34743 | 2021-11-23 | Indiana | 18 | 1084111 | 17369 |
34744 | 34744 | 2021-11-23 | Iowa | 19 | 516907 | 7268 |
34745 | 34745 | 2021-11-23 | Kansas | 20 | 459181 | 6670 |
34746 | 34746 | 2021-11-23 | Kentucky | 21 | 780477 | 10837 |
34747 | 34747 | 2021-11-23 | Louisiana | 22 | 768714 | 14768 |
34748 | 34748 | 2021-11-23 | Maine | 23 | 116948 | 1300 |
34749 | 34749 | 2021-11-23 | Maryland | 24 | 579824 | 11145 |
34750 | 34750 | 2021-11-23 | Massachusetts | 25 | 900985 | 19309 |
34751 | 34751 | 2021-11-23 | Michigan | 26 | 1424537 | 24900 |
34752 | 34752 | 2021-11-23 | Minnesota | 27 | 887492 | 9353 |
34753 | 34753 | 2021-11-23 | Mississippi | 28 | 512200 | 10253 |
34754 | 34754 | 2021-11-23 | Missouri | 29 | 910885 | 15430 |
34755 | 34755 | 2021-11-23 | Montana | 30 | 189390 | 2606 |
34756 | 34756 | 2021-11-23 | Nebraska | 31 | 304432 | 3112 |
34757 | 34757 | 2021-11-23 | Nevada | 32 | 467061 | 7953 |
34758 | 34758 | 2021-11-23 | New Hampshire | 33 | 154579 | 1678 |
34759 | 34759 | 2021-11-23 | New Jersey | 34 | 1236151 | 28295 |
34760 | 34760 | 2021-11-23 | New Mexico | 35 | 306743 | 5291 |
34761 | 34761 | 2021-11-23 | New York | 36 | 2684084 | 56775 |
34762 | 34762 | 2021-11-23 | North Carolina | 37 | 1523894 | 18662 |
34763 | 34763 | 2021-11-23 | North Dakota | 38 | 159411 | 1899 |
34764 | 34764 | 2021-11-23 | Northern Mariana Islands | 69 | 474 | 3 |
34765 | 34765 | 2021-11-23 | Ohio | 39 | 1653380 | 26190 |
34766 | 34766 | 2021-11-23 | Oklahoma | 40 | 661675 | 10879 |
34767 | 34767 | 2021-11-23 | Oregon | 41 | 386634 | 5066 |
34768 | 34768 | 2021-11-23 | Pennsylvania | 42 | 1696959 | 33003 |
34769 | 34769 | 2021-11-23 | Puerto Rico | 72 | 221100 | 3264 |
34770 | 34770 | 2021-11-23 | Rhode Island | 44 | 188135 | 2913 |
34771 | 34771 | 2021-11-23 | South Carolina | 45 | 914384 | 14135 |
34772 | 34772 | 2021-11-23 | South Dakota | 46 | 163721 | 2318 |
34773 | 34773 | 2021-11-23 | Tennessee | 47 | 1278841 | 16775 |
34774 | 34774 | 2021-11-23 | Texas | 48 | 4306962 | 73832 |
34775 | 34775 | 2021-11-23 | Utah | 49 | 588036 | 3457 |
34776 | 34776 | 2021-11-23 | Vermont | 50 | 47805 | 406 |
34777 | 34777 | 2021-11-23 | Virgin Islands | 78 | 7480 | 85 |
34778 | 34778 | 2021-11-23 | Virginia | 51 | 959156 | 14573 |
34779 | 34779 | 2021-11-23 | Washington | 53 | 769808 | 9225 |
34780 | 34780 | 2021-11-23 | West Virginia | 54 | 290026 | 4770 |
34781 | 34781 | 2021-11-23 | Wisconsin | 55 | 958496 | 9873 |
34782 | 34782 | 2021-11-23 | Wyoming | 56 | 110051 | 1347 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );