ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where "date" is on date 2022-01-23 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 56
- Alabama 1
- Alaska 1
- American Samoa 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 ▼ |
---|---|---|---|---|---|---|
38145 | 38145 | 2022-01-23 | American Samoa | 60 | 18 | 0 |
38180 | 38180 | 2022-01-23 | Northern Mariana Islands | 69 | 4246 | 22 |
38193 | 38193 | 2022-01-23 | Virgin Islands | 78 | 14028 | 94 |
38155 | 38155 | 2022-01-23 | Guam | 66 | 26726 | 277 |
38192 | 38192 | 2022-01-23 | Vermont | 50 | 99109 | 514 |
38144 | 38144 | 2022-01-23 | Alaska | 2 | 194133 | 1027 |
38156 | 38156 | 2022-01-23 | Hawaii | 15 | 197582 | 1143 |
38152 | 38152 | 2022-01-23 | District of Columbia | 11 | 127200 | 1267 |
38198 | 38198 | 2022-01-23 | Wyoming | 56 | 135369 | 1601 |
38164 | 38164 | 2022-01-23 | Maine | 23 | 166899 | 1698 |
38179 | 38179 | 2022-01-23 | North Dakota | 38 | 211087 | 2116 |
38174 | 38174 | 2022-01-23 | New Hampshire | 33 | 257793 | 2135 |
38151 | 38151 | 2022-01-23 | Delaware | 10 | 240179 | 2480 |
38188 | 38188 | 2022-01-23 | South Dakota | 46 | 216656 | 2601 |
38171 | 38171 | 2022-01-23 | Montana | 30 | 222716 | 2980 |
38186 | 38186 | 2022-01-23 | Rhode Island | 44 | 327109 | 3240 |
38172 | 38172 | 2022-01-23 | Nebraska | 31 | 413056 | 3569 |
38185 | 38185 | 2022-01-23 | Puerto Rico | 72 | 475695 | 3696 |
38191 | 38191 | 2022-01-23 | Utah | 49 | 826149 | 4030 |
38157 | 38157 | 2022-01-23 | Idaho | 16 | 358143 | 4324 |
38196 | 38196 | 2022-01-23 | West Virginia | 54 | 418887 | 5609 |
38183 | 38183 | 2022-01-23 | Oregon | 41 | 570892 | 5936 |
38176 | 38176 | 2022-01-23 | New Mexico | 35 | 437934 | 6261 |
38161 | 38161 | 2022-01-23 | Kansas | 20 | 681740 | 7352 |
38160 | 38160 | 2022-01-23 | Iowa | 19 | 682363 | 8317 |
38173 | 38173 | 2022-01-23 | Nevada | 32 | 614505 | 8736 |
38147 | 38147 | 2022-01-23 | Arkansas | 5 | 738638 | 9510 |
38150 | 38150 | 2022-01-23 | Connecticut | 9 | 671674 | 9769 |
38195 | 38195 | 2022-01-23 | Washington | 53 | 1157551 | 10474 |
38169 | 38169 | 2022-01-23 | Mississippi | 28 | 681382 | 10721 |
38149 | 38149 | 2022-01-23 | Colorado | 8 | 1186421 | 10974 |
38168 | 38168 | 2022-01-23 | Minnesota | 27 | 1216874 | 11291 |
38182 | 38182 | 2022-01-23 | Oklahoma | 40 | 893913 | 11873 |
38197 | 38197 | 2022-01-23 | Wisconsin | 55 | 1446213 | 11946 |
38162 | 38162 | 2022-01-23 | Kentucky | 21 | 1071699 | 12719 |
38165 | 38165 | 2022-01-23 | Maryland | 24 | 935874 | 13123 |
38187 | 38187 | 2022-01-23 | South Carolina | 45 | 1265710 | 15108 |
38163 | 38163 | 2022-01-23 | Louisiana | 22 | 1060022 | 15324 |
38194 | 38194 | 2022-01-23 | Virginia | 51 | 1451713 | 15853 |
38143 | 38143 | 2022-01-23 | Alabama | 1 | 1147194 | 16826 |
38170 | 38170 | 2022-01-23 | Missouri | 29 | 1281125 | 17254 |
38178 | 38178 | 2022-01-23 | North Carolina | 37 | 2204205 | 20204 |
38159 | 38159 | 2022-01-23 | Indiana | 18 | 1528366 | 20751 |
38166 | 38166 | 2022-01-23 | Massachusetts | 25 | 1535986 | 21402 |
38189 | 38189 | 2022-01-23 | Tennessee | 47 | 1694357 | 21812 |
38146 | 38146 | 2022-01-23 | Arizona | 4 | 1752552 | 25623 |
38175 | 38175 | 2022-01-23 | New Jersey | 34 | 2067692 | 30759 |
38154 | 38154 | 2022-01-23 | Georgia | 13 | 2171163 | 31066 |
38167 | 38167 | 2022-01-23 | Michigan | 26 | 2118580 | 31466 |
38181 | 38181 | 2022-01-23 | Ohio | 39 | 2506175 | 31987 |
38158 | 38158 | 2022-01-23 | Illinois | 17 | 2777353 | 33446 |
38184 | 38184 | 2022-01-23 | Pennsylvania | 42 | 2572500 | 39538 |
38177 | 38177 | 2022-01-23 | New York | 36 | 4686169 | 62853 |
38153 | 38153 | 2022-01-23 | Florida | 12 | 5303818 | 63763 |
38190 | 38190 | 2022-01-23 | Texas | 48 | 5934240 | 78388 |
38148 | 38148 | 2022-01-23 | California | 6 | 7688422 | 78839 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );