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-11-28 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 |
---|---|---|---|---|---|---|
14865 | 14865 | 2020-11-28 | Alabama | 1 | 244993 | 3572 |
14866 | 14866 | 2020-11-28 | Alaska | 2 | 31279 | 115 |
14867 | 14867 | 2020-11-28 | Arizona | 4 | 322774 | 6624 |
14868 | 14868 | 2020-11-28 | Arkansas | 5 | 155026 | 2449 |
14869 | 14869 | 2020-11-28 | California | 6 | 1206296 | 19132 |
14870 | 14870 | 2020-11-28 | Colorado | 8 | 226567 | 3012 |
14871 | 14871 | 2020-11-28 | Connecticut | 9 | 112581 | 4961 |
14872 | 14872 | 2020-11-28 | Delaware | 10 | 34670 | 763 |
14873 | 14873 | 2020-11-28 | District of Columbia | 11 | 21308 | 678 |
14874 | 14874 | 2020-11-28 | Florida | 12 | 985289 | 18441 |
14875 | 14875 | 2020-11-28 | Georgia | 13 | 450627 | 9173 |
14876 | 14876 | 2020-11-28 | Guam | 66 | 7751 | 113 |
14877 | 14877 | 2020-11-28 | Hawaii | 15 | 17871 | 238 |
14878 | 14878 | 2020-11-28 | Idaho | 16 | 99984 | 919 |
14879 | 14879 | 2020-11-28 | Illinois | 17 | 714070 | 12852 |
14880 | 14880 | 2020-11-28 | Indiana | 18 | 331725 | 5663 |
14881 | 14881 | 2020-11-28 | Iowa | 19 | 227181 | 2375 |
14882 | 14882 | 2020-11-28 | Kansas | 20 | 155265 | 1529 |
14883 | 14883 | 2020-11-28 | Kentucky | 21 | 177453 | 2028 |
14884 | 14884 | 2020-11-28 | Louisiana | 22 | 230602 | 6391 |
14885 | 14885 | 2020-11-28 | Maine | 23 | 11288 | 191 |
14886 | 14886 | 2020-11-28 | Maryland | 24 | 194603 | 4602 |
14887 | 14887 | 2020-11-28 | Massachusetts | 25 | 222469 | 10676 |
14888 | 14888 | 2020-11-28 | Michigan | 26 | 377209 | 9461 |
14889 | 14889 | 2020-11-28 | Minnesota | 27 | 304082 | 3580 |
14890 | 14890 | 2020-11-28 | Mississippi | 28 | 149940 | 3779 |
14891 | 14891 | 2020-11-28 | Missouri | 29 | 306526 | 3950 |
14892 | 14892 | 2020-11-28 | Montana | 30 | 60845 | 670 |
14893 | 14893 | 2020-11-28 | Nebraska | 31 | 125820 | 1021 |
14894 | 14894 | 2020-11-28 | Nevada | 32 | 149613 | 2123 |
14895 | 14895 | 2020-11-28 | New Hampshire | 33 | 20002 | 523 |
14896 | 14896 | 2020-11-28 | New Jersey | 34 | 332104 | 16965 |
14897 | 14897 | 2020-11-28 | New Mexico | 35 | 93982 | 1527 |
14898 | 14898 | 2020-11-28 | New York | 36 | 639200 | 34049 |
14899 | 14899 | 2020-11-28 | North Carolina | 37 | 358654 | 5249 |
14900 | 14900 | 2020-11-28 | North Dakota | 38 | 77941 | 921 |
14901 | 14901 | 2020-11-28 | Northern Mariana Islands | 69 | 104 | 2 |
14902 | 14902 | 2020-11-28 | Ohio | 39 | 406703 | 6378 |
14903 | 14903 | 2020-11-28 | Oklahoma | 40 | 193824 | 1717 |
14904 | 14904 | 2020-11-28 | Oregon | 41 | 72506 | 899 |
14905 | 14905 | 2020-11-28 | Pennsylvania | 42 | 356243 | 10337 |
14906 | 14906 | 2020-11-28 | Puerto Rico | 72 | 85196 | 1083 |
14907 | 14907 | 2020-11-28 | Rhode Island | 44 | 53954 | 1346 |
14908 | 14908 | 2020-11-28 | South Carolina | 45 | 214911 | 4346 |
14909 | 14909 | 2020-11-28 | South Dakota | 46 | 79099 | 942 |
14910 | 14910 | 2020-11-28 | Tennessee | 47 | 355885 | 4489 |
14911 | 14911 | 2020-11-28 | Texas | 48 | 1234740 | 21847 |
14912 | 14912 | 2020-11-28 | Utah | 49 | 192087 | 863 |
14913 | 14913 | 2020-11-28 | Vermont | 50 | 4033 | 67 |
14914 | 14914 | 2020-11-28 | Virgin Islands | 78 | 1540 | 23 |
14915 | 14915 | 2020-11-28 | Virginia | 51 | 233617 | 4054 |
14916 | 14916 | 2020-11-28 | Washington | 53 | 166736 | 2828 |
14917 | 14917 | 2020-11-28 | West Virginia | 54 | 45845 | 718 |
14918 | 14918 | 2020-11-28 | Wisconsin | 55 | 404999 | 3474 |
14919 | 14919 | 2020-11-28 | Wyoming | 56 | 31929 | 215 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );