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 2021-03-22 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|
21135 | 21135 | 2021-03-22 | Alabama | 1 | 511779 | 10436 |
21136 | 21136 | 2021-03-22 | Alaska | 2 | 61034 | 296 |
21137 | 21137 | 2021-03-22 | Arizona | 4 | 836737 | 16745 |
21138 | 21138 | 2021-03-22 | Arkansas | 5 | 328707 | 5544 |
21139 | 21139 | 2021-03-22 | California | 6 | 3645684 | 57770 |
21140 | 21140 | 2021-03-22 | Colorado | 8 | 453045 | 6149 |
21141 | 21141 | 2021-03-22 | Connecticut | 9 | 299667 | 7841 |
21142 | 21142 | 2021-03-22 | Delaware | 10 | 92429 | 1531 |
21143 | 21143 | 2021-03-22 | District of Columbia | 11 | 43383 | 1050 |
21144 | 21144 | 2021-03-22 | Florida | 12 | 2011203 | 32778 |
21145 | 21145 | 2021-03-22 | Georgia | 13 | 1021299 | 17990 |
21146 | 21146 | 2021-03-22 | Guam | 66 | 8753 | 135 |
21147 | 21147 | 2021-03-22 | Hawaii | 15 | 28912 | 451 |
21148 | 21148 | 2021-03-22 | Idaho | 16 | 177929 | 1949 |
21149 | 21149 | 2021-03-22 | Illinois | 17 | 1226595 | 23379 |
21150 | 21150 | 2021-03-22 | Indiana | 18 | 681699 | 12947 |
21151 | 21151 | 2021-03-22 | Iowa | 19 | 346218 | 5676 |
21152 | 21152 | 2021-03-22 | Kansas | 20 | 302602 | 4850 |
21153 | 21153 | 2021-03-22 | Kentucky | 21 | 424716 | 5847 |
21154 | 21154 | 2021-03-22 | Louisiana | 22 | 441066 | 10030 |
21155 | 21155 | 2021-03-22 | Maine | 23 | 48642 | 729 |
21156 | 21156 | 2021-03-22 | Maryland | 24 | 400890 | 8184 |
21157 | 21157 | 2021-03-22 | Massachusetts | 25 | 615874 | 16894 |
21158 | 21158 | 2021-03-22 | Michigan | 26 | 695763 | 16904 |
21159 | 21159 | 2021-03-22 | Minnesota | 27 | 506444 | 6850 |
21160 | 21160 | 2021-03-22 | Mississippi | 28 | 302932 | 6956 |
21161 | 21161 | 2021-03-22 | Missouri | 29 | 582710 | 8824 |
21162 | 21162 | 2021-03-22 | Montana | 30 | 103227 | 1415 |
21163 | 21163 | 2021-03-22 | Nebraska | 31 | 207124 | 2244 |
21164 | 21164 | 2021-03-22 | Nevada | 32 | 301360 | 5174 |
21165 | 21165 | 2021-03-22 | New Hampshire | 33 | 80750 | 1217 |
21166 | 21166 | 2021-03-22 | New Jersey | 34 | 869037 | 24181 |
21167 | 21167 | 2021-03-22 | New Mexico | 35 | 189893 | 3894 |
21168 | 21168 | 2021-03-22 | New York | 36 | 1787934 | 48959 |
21169 | 21169 | 2021-03-22 | North Carolina | 37 | 899303 | 11865 |
21170 | 21170 | 2021-03-22 | North Dakota | 38 | 101732 | 1492 |
21171 | 21171 | 2021-03-22 | Northern Mariana Islands | 69 | 157 | 2 |
21172 | 21172 | 2021-03-22 | Ohio | 39 | 1001195 | 18340 |
21173 | 21173 | 2021-03-22 | Oklahoma | 40 | 435450 | 4788 |
21174 | 21174 | 2021-03-22 | Oregon | 41 | 161800 | 2377 |
21175 | 21175 | 2021-03-22 | Pennsylvania | 42 | 993622 | 24839 |
21176 | 21176 | 2021-03-22 | Puerto Rico | 72 | 138131 | 2096 |
21177 | 21177 | 2021-03-22 | Rhode Island | 44 | 134039 | 2604 |
21178 | 21178 | 2021-03-22 | South Carolina | 45 | 542203 | 9027 |
21179 | 21179 | 2021-03-22 | South Dakota | 46 | 115972 | 1923 |
21180 | 21180 | 2021-03-22 | Tennessee | 47 | 787263 | 11610 |
21181 | 21181 | 2021-03-22 | Texas | 48 | 2754620 | 47616 |
21182 | 21182 | 2021-03-22 | Utah | 49 | 381846 | 2062 |
21183 | 21183 | 2021-03-22 | Vermont | 50 | 17839 | 219 |
21184 | 21184 | 2021-03-22 | Virgin Islands | 78 | 2767 | 25 |
21185 | 21185 | 2021-03-22 | Virginia | 51 | 605969 | 10129 |
21186 | 21186 | 2021-03-22 | Washington | 53 | 358727 | 5232 |
21187 | 21187 | 2021-03-22 | West Virginia | 54 | 138102 | 2612 |
21188 | 21188 | 2021-03-22 | Wisconsin | 55 | 629994 | 7241 |
21189 | 21189 | 2021-03-22 | Wyoming | 56 | 55730 | 693 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );