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-07-06 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 |
---|---|---|---|---|---|---|
6890 | 6890 | 2020-07-06 | Alabama | 1 | 44878 | 1007 |
6891 | 6891 | 2020-07-06 | Alaska | 2 | 1401 | 14 |
6892 | 6892 | 2020-07-06 | Arizona | 4 | 101542 | 1832 |
6893 | 6893 | 2020-07-06 | Arkansas | 5 | 24253 | 292 |
6894 | 6894 | 2020-07-06 | California | 6 | 277869 | 6452 |
6895 | 6895 | 2020-07-06 | Colorado | 8 | 34316 | 1704 |
6896 | 6896 | 2020-07-06 | Connecticut | 9 | 46976 | 4338 |
6897 | 6897 | 2020-07-06 | Delaware | 10 | 12293 | 512 |
6898 | 6898 | 2020-07-06 | District of Columbia | 11 | 10515 | 561 |
6899 | 6899 | 2020-07-06 | Florida | 12 | 206439 | 3777 |
6900 | 6900 | 2020-07-06 | Georgia | 13 | 91015 | 2829 |
6901 | 6901 | 2020-07-06 | Guam | 66 | 1270 | 6 |
6902 | 6902 | 2020-07-06 | Hawaii | 15 | 1012 | 19 |
6903 | 6903 | 2020-07-06 | Idaho | 16 | 8222 | 94 |
6904 | 6904 | 2020-07-06 | Illinois | 17 | 149428 | 7250 |
6905 | 6905 | 2020-07-06 | Indiana | 18 | 49560 | 2698 |
6906 | 6906 | 2020-07-06 | Iowa | 19 | 31764 | 725 |
6907 | 6907 | 2020-07-06 | Kansas | 20 | 17082 | 288 |
6908 | 6908 | 2020-07-06 | Kentucky | 21 | 17464 | 621 |
6909 | 6909 | 2020-07-06 | Louisiana | 22 | 66435 | 3296 |
6910 | 6910 | 2020-07-06 | Maine | 23 | 3423 | 109 |
6911 | 6911 | 2020-07-06 | Maryland | 24 | 70497 | 3246 |
6912 | 6912 | 2020-07-06 | Massachusetts | 25 | 110137 | 8198 |
6913 | 6913 | 2020-07-06 | Michigan | 26 | 73403 | 6225 |
6914 | 6914 | 2020-07-06 | Minnesota | 27 | 38606 | 1511 |
6915 | 6915 | 2020-07-06 | Mississippi | 28 | 31257 | 1114 |
6916 | 6916 | 2020-07-06 | Missouri | 29 | 24850 | 1068 |
6917 | 6917 | 2020-07-06 | Montana | 30 | 1249 | 23 |
6918 | 6918 | 2020-07-06 | Nebraska | 31 | 20052 | 286 |
6919 | 6919 | 2020-07-06 | Nevada | 32 | 22930 | 537 |
6920 | 6920 | 2020-07-06 | New Hampshire | 33 | 5914 | 382 |
6921 | 6921 | 2020-07-06 | New Jersey | 34 | 175467 | 15229 |
6922 | 6922 | 2020-07-06 | New Mexico | 35 | 13507 | 515 |
6923 | 6923 | 2020-07-06 | New York | 36 | 402338 | 31911 |
6924 | 6924 | 2020-07-06 | North Carolina | 37 | 74933 | 1424 |
6925 | 6925 | 2020-07-06 | North Dakota | 38 | 3858 | 89 |
6926 | 6926 | 2020-07-06 | Northern Mariana Islands | 69 | 31 | 2 |
6927 | 6927 | 2020-07-06 | Ohio | 39 | 57956 | 2927 |
6928 | 6928 | 2020-07-06 | Oklahoma | 40 | 16362 | 399 |
6929 | 6929 | 2020-07-06 | Oregon | 41 | 10413 | 218 |
6930 | 6930 | 2020-07-06 | Pennsylvania | 42 | 95187 | 6798 |
6931 | 6931 | 2020-07-06 | Puerto Rico | 72 | 8585 | 155 |
6932 | 6932 | 2020-07-06 | Rhode Island | 44 | 16991 | 960 |
6933 | 6933 | 2020-07-06 | South Carolina | 45 | 46380 | 827 |
6934 | 6934 | 2020-07-06 | South Dakota | 46 | 7105 | 97 |
6935 | 6935 | 2020-07-06 | Tennessee | 47 | 51509 | 646 |
6936 | 6936 | 2020-07-06 | Texas | 48 | 209350 | 2726 |
6937 | 6937 | 2020-07-06 | Utah | 49 | 25653 | 190 |
6938 | 6938 | 2020-07-06 | Vermont | 50 | 1251 | 56 |
6939 | 6939 | 2020-07-06 | Virgin Islands | 78 | 116 | 6 |
6940 | 6940 | 2020-07-06 | Virginia | 51 | 66102 | 1853 |
6941 | 6941 | 2020-07-06 | Washington | 53 | 38517 | 1370 |
6942 | 6942 | 2020-07-06 | West Virginia | 54 | 3442 | 95 |
6943 | 6943 | 2020-07-06 | Wisconsin | 55 | 35318 | 805 |
6944 | 6944 | 2020-07-06 | Wyoming | 56 | 1675 | 20 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );