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-14 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 |
---|---|---|---|---|---|---|
5680 | 5680 | 2020-06-14 | Alabama | 1 | 25615 | 773 |
5681 | 5681 | 2020-06-14 | Alaska | 2 | 734 | 10 |
5682 | 5682 | 2020-06-14 | Arizona | 4 | 35953 | 1194 |
5683 | 5683 | 2020-06-14 | Arkansas | 5 | 12501 | 179 |
5684 | 5684 | 2020-06-14 | California | 6 | 152953 | 5089 |
5685 | 5685 | 2020-06-14 | Colorado | 8 | 29115 | 1599 |
5686 | 5686 | 2020-06-14 | Connecticut | 9 | 45088 | 4201 |
5687 | 5687 | 2020-06-14 | Delaware | 10 | 10264 | 422 |
5688 | 5688 | 2020-06-14 | District of Columbia | 11 | 9767 | 515 |
5689 | 5689 | 2020-06-14 | Florida | 12 | 75560 | 2930 |
5690 | 5690 | 2020-06-14 | Georgia | 13 | 54874 | 2416 |
5691 | 5691 | 2020-06-14 | Guam | 66 | 1154 | 6 |
5692 | 5692 | 2020-06-14 | Hawaii | 15 | 716 | 17 |
5693 | 5693 | 2020-06-14 | Idaho | 16 | 3413 | 88 |
5694 | 5694 | 2020-06-14 | Illinois | 17 | 133719 | 6512 |
5695 | 5695 | 2020-06-14 | Indiana | 18 | 40901 | 2422 |
5696 | 5696 | 2020-06-14 | Iowa | 19 | 23959 | 652 |
5697 | 5697 | 2020-06-14 | Kansas | 20 | 11247 | 244 |
5698 | 5698 | 2020-06-14 | Kentucky | 21 | 12652 | 527 |
5699 | 5699 | 2020-06-14 | Louisiana | 22 | 46732 | 3014 |
5700 | 5700 | 2020-06-14 | Maine | 23 | 2793 | 100 |
5701 | 5701 | 2020-06-14 | Maryland | 24 | 62328 | 2939 |
5702 | 5702 | 2020-06-14 | Massachusetts | 25 | 105603 | 7624 |
5703 | 5703 | 2020-06-14 | Michigan | 26 | 66246 | 6020 |
5704 | 5704 | 2020-06-14 | Minnesota | 27 | 30502 | 1329 |
5705 | 5705 | 2020-06-14 | Mississippi | 28 | 19516 | 891 |
5706 | 5706 | 2020-06-14 | Missouri | 29 | 16384 | 890 |
5707 | 5707 | 2020-06-14 | Montana | 30 | 601 | 19 |
5708 | 5708 | 2020-06-14 | Nebraska | 31 | 16735 | 221 |
5709 | 5709 | 2020-06-14 | Nevada | 32 | 11199 | 464 |
5710 | 5710 | 2020-06-14 | New Hampshire | 33 | 5318 | 320 |
5711 | 5711 | 2020-06-14 | New Jersey | 34 | 166881 | 12625 |
5712 | 5712 | 2020-06-14 | New Mexico | 35 | 9723 | 435 |
5713 | 5713 | 2020-06-14 | New York | 36 | 388096 | 30605 |
5714 | 5714 | 2020-06-14 | North Carolina | 37 | 44199 | 1139 |
5715 | 5715 | 2020-06-14 | North Dakota | 38 | 3083 | 77 |
5716 | 5716 | 2020-06-14 | Northern Mariana Islands | 69 | 30 | 2 |
5717 | 5717 | 2020-06-14 | Ohio | 39 | 41148 | 2557 |
5718 | 5718 | 2020-06-14 | Oklahoma | 40 | 8231 | 359 |
5719 | 5719 | 2020-06-14 | Oregon | 41 | 5644 | 176 |
5720 | 5720 | 2020-06-14 | Pennsylvania | 42 | 83301 | 6275 |
5721 | 5721 | 2020-06-14 | Puerto Rico | 72 | 5811 | 147 |
5722 | 5722 | 2020-06-14 | Rhode Island | 44 | 15947 | 833 |
5723 | 5723 | 2020-06-14 | South Carolina | 45 | 18796 | 600 |
5724 | 5724 | 2020-06-14 | South Dakota | 46 | 5898 | 75 |
5725 | 5725 | 2020-06-14 | Tennessee | 47 | 30174 | 467 |
5726 | 5726 | 2020-06-14 | Texas | 48 | 89542 | 1995 |
5727 | 5727 | 2020-06-14 | Utah | 49 | 14313 | 139 |
5728 | 5728 | 2020-06-14 | Vermont | 50 | 1127 | 55 |
5729 | 5729 | 2020-06-14 | Virgin Islands | 78 | 73 | 6 |
5730 | 5730 | 2020-06-14 | Virginia | 51 | 54506 | 1546 |
5731 | 5731 | 2020-06-14 | Washington | 53 | 27135 | 1220 |
5732 | 5732 | 2020-06-14 | West Virginia | 54 | 2290 | 88 |
5733 | 5733 | 2020-06-14 | Wisconsin | 55 | 25307 | 702 |
5734 | 5734 | 2020-06-14 | Wyoming | 56 | 1060 | 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 );