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-08-29 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 |
---|---|---|---|---|---|---|
9860 | 9860 | 2020-08-29 | Alabama | 1 | 123889 | 2152 |
9861 | 9861 | 2020-08-29 | Alaska | 2 | 5985 | 34 |
9862 | 9862 | 2020-08-29 | Arizona | 4 | 201317 | 5010 |
9863 | 9863 | 2020-08-29 | Arkansas | 5 | 60378 | 772 |
9864 | 9864 | 2020-08-29 | California | 6 | 702500 | 12906 |
9865 | 9865 | 2020-08-29 | Colorado | 8 | 57326 | 1946 |
9866 | 9866 | 2020-08-29 | Connecticut | 9 | 52495 | 4465 |
9867 | 9867 | 2020-08-29 | Delaware | 10 | 17349 | 604 |
9868 | 9868 | 2020-08-29 | District of Columbia | 11 | 13925 | 605 |
9869 | 9869 | 2020-08-29 | Florida | 12 | 618995 | 11104 |
9870 | 9870 | 2020-08-29 | Georgia | 13 | 251676 | 5451 |
9871 | 9871 | 2020-08-29 | Guam | 66 | 2256 | 11 |
9872 | 9872 | 2020-08-29 | Hawaii | 15 | 8115 | 61 |
9873 | 9873 | 2020-08-29 | Idaho | 16 | 31874 | 359 |
9874 | 9874 | 2020-08-29 | Illinois | 17 | 233806 | 8236 |
9875 | 9875 | 2020-08-29 | Indiana | 18 | 94512 | 3285 |
9876 | 9876 | 2020-08-29 | Iowa | 19 | 63836 | 1110 |
9877 | 9877 | 2020-08-29 | Kansas | 20 | 41909 | 449 |
9878 | 9878 | 2020-08-29 | Kentucky | 21 | 49914 | 951 |
9879 | 9879 | 2020-08-29 | Louisiana | 22 | 146944 | 4904 |
9880 | 9880 | 2020-08-29 | Maine | 23 | 4489 | 132 |
9881 | 9881 | 2020-08-29 | Maryland | 24 | 107790 | 3746 |
9882 | 9882 | 2020-08-29 | Massachusetts | 25 | 128030 | 9036 |
9883 | 9883 | 2020-08-29 | Michigan | 26 | 112104 | 6747 |
9884 | 9884 | 2020-08-29 | Minnesota | 27 | 74306 | 1863 |
9885 | 9885 | 2020-08-29 | Mississippi | 28 | 82029 | 2427 |
9886 | 9886 | 2020-08-29 | Missouri | 29 | 83973 | 1613 |
9887 | 9887 | 2020-08-29 | Montana | 30 | 7256 | 104 |
9888 | 9888 | 2020-08-29 | Nebraska | 31 | 33753 | 400 |
9889 | 9889 | 2020-08-29 | Nevada | 32 | 68576 | 1303 |
9890 | 9890 | 2020-08-29 | New Hampshire | 33 | 7246 | 432 |
9891 | 9891 | 2020-08-29 | New Jersey | 34 | 193100 | 15933 |
9892 | 9892 | 2020-08-29 | New Mexico | 35 | 25178 | 769 |
9893 | 9893 | 2020-08-29 | New York | 36 | 438122 | 32522 |
9894 | 9894 | 2020-08-29 | North Carolina | 37 | 165533 | 2708 |
9895 | 9895 | 2020-08-29 | North Dakota | 38 | 11488 | 145 |
9896 | 9896 | 2020-08-29 | Northern Mariana Islands | 69 | 56 | 2 |
9897 | 9897 | 2020-08-29 | Ohio | 39 | 121340 | 4126 |
9898 | 9898 | 2020-08-29 | Oklahoma | 40 | 57353 | 797 |
9899 | 9899 | 2020-08-29 | Oregon | 41 | 26293 | 460 |
9900 | 9900 | 2020-08-29 | Pennsylvania | 42 | 137576 | 7740 |
9901 | 9901 | 2020-08-29 | Puerto Rico | 72 | 32550 | 428 |
9902 | 9902 | 2020-08-29 | Rhode Island | 44 | 21683 | 1046 |
9903 | 9903 | 2020-08-29 | South Carolina | 45 | 117249 | 2698 |
9904 | 9904 | 2020-08-29 | South Dakota | 46 | 12942 | 167 |
9905 | 9905 | 2020-08-29 | Tennessee | 47 | 149310 | 1700 |
9906 | 9906 | 2020-08-29 | Texas | 48 | 633834 | 12733 |
9907 | 9907 | 2020-08-29 | Utah | 49 | 51486 | 408 |
9908 | 9908 | 2020-08-29 | Vermont | 50 | 1605 | 58 |
9909 | 9909 | 2020-08-29 | Virgin Islands | 78 | 1129 | 14 |
9910 | 9910 | 2020-08-29 | Virginia | 51 | 118809 | 2568 |
9911 | 9911 | 2020-08-29 | Washington | 53 | 76834 | 1992 |
9912 | 9912 | 2020-08-29 | West Virginia | 54 | 9967 | 212 |
9913 | 9913 | 2020-08-29 | Wisconsin | 55 | 79767 | 1129 |
9914 | 9914 | 2020-08-29 | Wyoming | 56 | 3784 | 37 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );