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-21 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
state 55
- 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
- New Hampshire 1
- New Jersey 1
- New Mexico 1
- New York 1
- North Carolina 1
- North Dakota 1
- Northern Mariana Islands 1
- Ohio 1
- Oklahoma 1
- Oregon 1
- Pennsylvania 1
- Puerto Rico 1
- Rhode Island 1
- South Carolina 1
- South Dakota 1
- Tennessee 1
- Texas 1
- Utah 1
- Vermont 1
- Virgin Islands 1
- Virginia 1
- Washington 1
- West Virginia 1
- Wisconsin 1
- Wyoming 1
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
6065 | 6065 | 2020-06-21 | Alabama | 1 | 30021 | 839 |
6066 | 6066 | 2020-06-21 | Alaska | 2 | 859 | 10 |
6067 | 6067 | 2020-06-21 | Arizona | 4 | 52666 | 1350 |
6068 | 6068 | 2020-06-21 | Arkansas | 5 | 15561 | 225 |
6069 | 6069 | 2020-06-21 | California | 6 | 178807 | 5517 |
6070 | 6070 | 2020-06-21 | Colorado | 8 | 30524 | 1647 |
6071 | 6071 | 2020-06-21 | Connecticut | 9 | 45755 | 4260 |
6072 | 6072 | 2020-06-21 | Delaware | 10 | 10775 | 435 |
6073 | 6073 | 2020-06-21 | District of Columbia | 11 | 10020 | 533 |
6074 | 6074 | 2020-06-21 | Florida | 12 | 97283 | 3160 |
6075 | 6075 | 2020-06-21 | Georgia | 13 | 61493 | 2603 |
6076 | 6076 | 2020-06-21 | Guam | 66 | 1191 | 6 |
6077 | 6077 | 2020-06-21 | Hawaii | 15 | 802 | 17 |
6078 | 6078 | 2020-06-21 | Idaho | 16 | 4025 | 90 |
6079 | 6079 | 2020-06-21 | Illinois | 17 | 138154 | 6865 |
6080 | 6080 | 2020-06-21 | Indiana | 18 | 43496 | 2540 |
6081 | 6081 | 2020-06-21 | Iowa | 19 | 26020 | 686 |
6082 | 6082 | 2020-06-21 | Kansas | 20 | 12258 | 258 |
6083 | 6083 | 2020-06-21 | Kentucky | 21 | 13919 | 544 |
6084 | 6084 | 2020-06-21 | Louisiana | 22 | 49890 | 3105 |
6085 | 6085 | 2020-06-21 | Maine | 23 | 2957 | 102 |
6086 | 6086 | 2020-06-21 | Maryland | 24 | 64903 | 3066 |
6087 | 6087 | 2020-06-21 | Massachusetts | 25 | 107061 | 7857 |
6088 | 6088 | 2020-06-21 | Michigan | 26 | 67873 | 6094 |
6089 | 6089 | 2020-06-21 | Minnesota | 27 | 32952 | 1412 |
6090 | 6090 | 2020-06-21 | Mississippi | 28 | 21022 | 943 |
6091 | 6091 | 2020-06-21 | Missouri | 29 | 18552 | 975 |
6092 | 6092 | 2020-06-21 | Montana | 30 | 717 | 20 |
6093 | 6093 | 2020-06-21 | Nebraska | 31 | 17810 | 252 |
6094 | 6094 | 2020-06-21 | Nevada | 32 | 13236 | 487 |
6095 | 6095 | 2020-06-21 | New Hampshire | 33 | 5544 | 339 |
6096 | 6096 | 2020-06-21 | New Jersey | 34 | 169142 | 12870 |
6097 | 6097 | 2020-06-21 | New Mexico | 35 | 10565 | 469 |
6098 | 6098 | 2020-06-21 | New York | 36 | 392702 | 30884 |
6099 | 6099 | 2020-06-21 | North Carolina | 37 | 52854 | 1245 |
6100 | 6100 | 2020-06-21 | North Dakota | 38 | 3294 | 83 |
6101 | 6101 | 2020-06-21 | Northern Mariana Islands | 69 | 30 | 2 |
6102 | 6102 | 2020-06-21 | Ohio | 39 | 44808 | 2700 |
6103 | 6103 | 2020-06-21 | Oklahoma | 40 | 10515 | 369 |
6104 | 6104 | 2020-06-21 | Oregon | 41 | 6945 | 190 |
6105 | 6105 | 2020-06-21 | Pennsylvania | 42 | 86024 | 6472 |
6106 | 6106 | 2020-06-21 | Puerto Rico | 72 | 6525 | 149 |
6107 | 6107 | 2020-06-21 | Rhode Island | 44 | 16337 | 894 |
6108 | 6108 | 2020-06-21 | South Carolina | 45 | 24693 | 653 |
6109 | 6109 | 2020-06-21 | South Dakota | 46 | 6297 | 81 |
6110 | 6110 | 2020-06-21 | Tennessee | 47 | 34719 | 519 |
6111 | 6111 | 2020-06-21 | Texas | 48 | 114886 | 2195 |
6112 | 6112 | 2020-06-21 | Utah | 49 | 17567 | 158 |
6113 | 6113 | 2020-06-21 | Vermont | 50 | 1159 | 56 |
6114 | 6114 | 2020-06-21 | Virgin Islands | 78 | 76 | 6 |
6115 | 6115 | 2020-06-21 | Virginia | 51 | 57994 | 1611 |
6116 | 6116 | 2020-06-21 | Washington | 53 | 29797 | 1271 |
6117 | 6117 | 2020-06-21 | West Virginia | 54 | 2543 | 89 |
6118 | 6118 | 2020-06-21 | Wisconsin | 55 | 27598 | 751 |
6119 | 6119 | 2020-06-21 | Wyoming | 56 | 1197 | 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 );