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-01-21 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|
17835 | 17835 | 2021-01-21 | Alabama | 1 | 432536 | 6379 |
17836 | 17836 | 2021-01-21 | Alaska | 2 | 52282 | 245 |
17837 | 17837 | 2021-01-21 | Arizona | 4 | 703249 | 11813 |
17838 | 17838 | 2021-01-21 | Arkansas | 5 | 279220 | 4496 |
17839 | 17839 | 2021-01-21 | California | 6 | 3116369 | 35704 |
17840 | 17840 | 2021-01-21 | Colorado | 8 | 382918 | 5523 |
17841 | 17841 | 2021-01-21 | Connecticut | 9 | 235796 | 6774 |
17842 | 17842 | 2021-01-21 | Delaware | 10 | 72523 | 1027 |
17843 | 17843 | 2021-01-21 | District of Columbia | 11 | 34612 | 864 |
17844 | 17844 | 2021-01-21 | Florida | 12 | 1613876 | 24738 |
17845 | 17845 | 2021-01-21 | Georgia | 13 | 820513 | 12484 |
17846 | 17846 | 2021-01-21 | Guam | 66 | 8497 | 129 |
17847 | 17847 | 2021-01-21 | Hawaii | 15 | 24663 | 325 |
17848 | 17848 | 2021-01-21 | Idaho | 16 | 158400 | 1658 |
17849 | 17849 | 2021-01-21 | Illinois | 17 | 1089010 | 20423 |
17850 | 17850 | 2021-01-21 | Indiana | 18 | 605004 | 9593 |
17851 | 17851 | 2021-01-21 | Iowa | 19 | 310440 | 4445 |
17852 | 17852 | 2021-01-21 | Kansas | 20 | 266562 | 3575 |
17853 | 17853 | 2021-01-21 | Kentucky | 21 | 341343 | 3584 |
17854 | 17854 | 2021-01-21 | Louisiana | 22 | 378318 | 8442 |
17855 | 17855 | 2021-01-21 | Maine | 23 | 35638 | 536 |
17856 | 17856 | 2021-01-21 | Maryland | 24 | 334725 | 6735 |
17857 | 17857 | 2021-01-21 | Massachusetts | 25 | 486180 | 13906 |
17858 | 17858 | 2021-01-21 | Michigan | 26 | 590546 | 14922 |
17859 | 17859 | 2021-01-21 | Minnesota | 27 | 450830 | 6079 |
17860 | 17860 | 2021-01-21 | Mississippi | 28 | 259117 | 5668 |
17861 | 17861 | 2021-01-21 | Missouri | 29 | 481962 | 6909 |
17862 | 17862 | 2021-01-21 | Montana | 30 | 90742 | 1102 |
17863 | 17863 | 2021-01-21 | Nebraska | 31 | 186472 | 1949 |
17864 | 17864 | 2021-01-21 | Nevada | 32 | 266643 | 3915 |
17865 | 17865 | 2021-01-21 | New Hampshire | 33 | 60294 | 962 |
17866 | 17866 | 2021-01-21 | New Jersey | 34 | 646188 | 20760 |
17867 | 17867 | 2021-01-21 | New Mexico | 35 | 166823 | 3046 |
17868 | 17868 | 2021-01-21 | New York | 36 | 1293976 | 41348 |
17869 | 17869 | 2021-01-21 | North Carolina | 37 | 697660 | 8397 |
17870 | 17870 | 2021-01-21 | North Dakota | 38 | 96392 | 1422 |
17871 | 17871 | 2021-01-21 | Northern Mariana Islands | 69 | 129 | 2 |
17872 | 17872 | 2021-01-21 | Ohio | 39 | 849704 | 10518 |
17873 | 17873 | 2021-01-21 | Oklahoma | 40 | 363046 | 3140 |
17874 | 17874 | 2021-01-21 | Oregon | 41 | 135973 | 1850 |
17875 | 17875 | 2021-01-21 | Pennsylvania | 42 | 794632 | 20128 |
17876 | 17876 | 2021-01-21 | Puerto Rico | 72 | 122343 | 1732 |
17877 | 17877 | 2021-01-21 | Rhode Island | 44 | 108786 | 2076 |
17878 | 17878 | 2021-01-21 | South Carolina | 45 | 404492 | 6373 |
17879 | 17879 | 2021-01-21 | South Dakota | 46 | 106400 | 1673 |
17880 | 17880 | 2021-01-21 | Tennessee | 47 | 685037 | 8606 |
17881 | 17881 | 2021-01-21 | Texas | 48 | 2207935 | 34075 |
17882 | 17882 | 2021-01-21 | Utah | 49 | 330469 | 1548 |
17883 | 17883 | 2021-01-21 | Vermont | 50 | 10580 | 168 |
17884 | 17884 | 2021-01-21 | Virgin Islands | 78 | 2305 | 24 |
17885 | 17885 | 2021-01-21 | Virginia | 51 | 459604 | 5940 |
17886 | 17886 | 2021-01-21 | Washington | 53 | 300420 | 4131 |
17887 | 17887 | 2021-01-21 | West Virginia | 54 | 112617 | 1849 |
17888 | 17888 | 2021-01-21 | Wisconsin | 55 | 575688 | 6091 |
17889 | 17889 | 2021-01-21 | Wyoming | 56 | 50424 | 550 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );