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-06-18 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 |
---|---|---|---|---|---|---|
5900 | 5900 | 2020-06-18 | Alabama | 1 | 28206 | 810 |
5901 | 5901 | 2020-06-18 | Alaska | 2 | 795 | 10 |
5902 | 5902 | 2020-06-18 | Arizona | 4 | 43731 | 1287 |
5903 | 5903 | 2020-06-18 | Arkansas | 5 | 13928 | 208 |
5904 | 5904 | 2020-06-18 | California | 6 | 167135 | 5359 |
5905 | 5905 | 2020-06-18 | Colorado | 8 | 29886 | 1638 |
5906 | 5906 | 2020-06-18 | Connecticut | 9 | 45440 | 4226 |
5907 | 5907 | 2020-06-18 | Delaware | 10 | 10499 | 431 |
5908 | 5908 | 2020-06-18 | District of Columbia | 11 | 9903 | 527 |
5909 | 5909 | 2020-06-18 | Florida | 12 | 85918 | 3060 |
5910 | 5910 | 2020-06-18 | Georgia | 13 | 58040 | 2565 |
5911 | 5911 | 2020-06-18 | Guam | 66 | 1162 | 6 |
5912 | 5912 | 2020-06-18 | Hawaii | 15 | 750 | 17 |
5913 | 5913 | 2020-06-18 | Idaho | 16 | 3744 | 90 |
5914 | 5914 | 2020-06-18 | Illinois | 17 | 136081 | 6737 |
5915 | 5915 | 2020-06-18 | Indiana | 18 | 42480 | 2491 |
5916 | 5916 | 2020-06-18 | Iowa | 19 | 24959 | 680 |
5917 | 5917 | 2020-06-18 | Kansas | 20 | 11886 | 252 |
5918 | 5918 | 2020-06-18 | Kentucky | 21 | 13391 | 540 |
5919 | 5919 | 2020-06-18 | Louisiana | 22 | 49506 | 3069 |
5920 | 5920 | 2020-06-18 | Maine | 23 | 2878 | 102 |
5921 | 5921 | 2020-06-18 | Maryland | 24 | 63839 | 3016 |
5922 | 5922 | 2020-06-18 | Massachusetts | 25 | 106422 | 7769 |
5923 | 5923 | 2020-06-18 | Michigan | 26 | 66980 | 6064 |
5924 | 5924 | 2020-06-18 | Minnesota | 27 | 31707 | 1376 |
5925 | 5925 | 2020-06-18 | Mississippi | 28 | 21022 | 943 |
5926 | 5926 | 2020-06-18 | Missouri | 29 | 17488 | 963 |
5927 | 5927 | 2020-06-18 | Montana | 30 | 655 | 20 |
5928 | 5928 | 2020-06-18 | Nebraska | 31 | 17415 | 244 |
5929 | 5929 | 2020-06-18 | Nevada | 32 | 12164 | 475 |
5930 | 5930 | 2020-06-18 | New Hampshire | 33 | 5450 | 331 |
5931 | 5931 | 2020-06-18 | New Jersey | 34 | 168107 | 12800 |
5932 | 5932 | 2020-06-18 | New Mexico | 35 | 10153 | 456 |
5933 | 5933 | 2020-06-18 | New York | 36 | 390536 | 30767 |
5934 | 5934 | 2020-06-18 | North Carolina | 37 | 48426 | 1209 |
5935 | 5935 | 2020-06-18 | North Dakota | 38 | 3199 | 81 |
5936 | 5936 | 2020-06-18 | Northern Mariana Islands | 69 | 30 | 2 |
5937 | 5937 | 2020-06-18 | Ohio | 39 | 43122 | 2633 |
5938 | 5938 | 2020-06-18 | Oklahoma | 40 | 9354 | 366 |
5939 | 5939 | 2020-06-18 | Oregon | 41 | 6390 | 187 |
5940 | 5940 | 2020-06-18 | Pennsylvania | 42 | 84780 | 6417 |
5941 | 5941 | 2020-06-18 | Puerto Rico | 72 | 6111 | 147 |
5942 | 5942 | 2020-06-18 | Rhode Island | 44 | 16269 | 885 |
5943 | 5943 | 2020-06-18 | South Carolina | 45 | 21548 | 621 |
5944 | 5944 | 2020-06-18 | South Dakota | 46 | 6109 | 78 |
5945 | 5945 | 2020-06-18 | Tennessee | 47 | 32604 | 504 |
5946 | 5946 | 2020-06-18 | Texas | 48 | 102677 | 2137 |
5947 | 5947 | 2020-06-18 | Utah | 49 | 16015 | 152 |
5948 | 5948 | 2020-06-18 | Vermont | 50 | 1135 | 56 |
5949 | 5949 | 2020-06-18 | Virgin Islands | 78 | 74 | 6 |
5950 | 5950 | 2020-06-18 | Virginia | 51 | 56238 | 1586 |
5951 | 5951 | 2020-06-18 | Washington | 53 | 28663 | 1246 |
5952 | 5952 | 2020-06-18 | West Virginia | 54 | 2418 | 88 |
5953 | 5953 | 2020-06-18 | Wisconsin | 55 | 26611 | 725 |
5954 | 5954 | 2020-06-18 | Wyoming | 56 | 1144 | 18 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );