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-10-18 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 ▼ |
---|---|---|---|---|---|---|
53153 | 53153 | 2022-10-18 | American Samoa | 60 | 8251 | 34 |
53188 | 53188 | 2022-10-18 | Northern Mariana Islands | 69 | 13171 | 40 |
53201 | 53201 | 2022-10-18 | Virgin Islands | 78 | 23256 | 123 |
53163 | 53163 | 2022-10-18 | Guam | 66 | 59672 | 402 |
53200 | 53200 | 2022-10-18 | Vermont | 50 | 143683 | 732 |
53152 | 53152 | 2022-10-18 | Alaska | 2 | 297740 | 1350 |
53160 | 53160 | 2022-10-18 | District of Columbia | 11 | 169149 | 1392 |
53164 | 53164 | 2022-10-18 | Hawaii | 15 | 349598 | 1696 |
53206 | 53206 | 2022-10-18 | Wyoming | 56 | 178032 | 1906 |
53187 | 53187 | 2022-10-18 | North Dakota | 38 | 271085 | 2434 |
53172 | 53172 | 2022-10-18 | Maine | 23 | 294415 | 2627 |
53182 | 53182 | 2022-10-18 | New Hampshire | 33 | 354443 | 2721 |
53196 | 53196 | 2022-10-18 | South Dakota | 46 | 262837 | 3046 |
53159 | 53159 | 2022-10-18 | Delaware | 10 | 311538 | 3136 |
53179 | 53179 | 2022-10-18 | Montana | 30 | 313126 | 3566 |
53194 | 53194 | 2022-10-18 | Rhode Island | 44 | 428874 | 3681 |
53180 | 53180 | 2022-10-18 | Nebraska | 31 | 539389 | 4552 |
53199 | 53199 | 2022-10-18 | Utah | 49 | 1041933 | 5034 |
53165 | 53165 | 2022-10-18 | Idaho | 16 | 498194 | 5202 |
53193 | 53193 | 2022-10-18 | Puerto Rico | 72 | 1002681 | 5217 |
53204 | 53204 | 2022-10-18 | West Virginia | 54 | 605012 | 7479 |
53184 | 53184 | 2022-10-18 | New Mexico | 35 | 623179 | 8603 |
53191 | 53191 | 2022-10-18 | Oregon | 41 | 902319 | 8622 |
53169 | 53169 | 2022-10-18 | Kansas | 20 | 883499 | 9609 |
53168 | 53168 | 2022-10-18 | Iowa | 19 | 860166 | 10125 |
53158 | 53158 | 2022-10-18 | Connecticut | 9 | 907038 | 11420 |
53181 | 53181 | 2022-10-18 | Nevada | 32 | 850204 | 11536 |
53155 | 53155 | 2022-10-18 | Arkansas | 5 | 956424 | 12386 |
53177 | 53177 | 2022-10-18 | Mississippi | 28 | 930438 | 12945 |
53157 | 53157 | 2022-10-18 | Colorado | 8 | 1672464 | 13578 |
53176 | 53176 | 2022-10-18 | Minnesota | 27 | 1676151 | 13738 |
53203 | 53203 | 2022-10-18 | Washington | 53 | 1829223 | 14496 |
53190 | 53190 | 2022-10-18 | Oklahoma | 40 | 1205519 | 14924 |
53205 | 53205 | 2022-10-18 | Wisconsin | 55 | 1884212 | 15374 |
53173 | 53173 | 2022-10-18 | Maryland | 24 | 1261418 | 15494 |
53170 | 53170 | 2022-10-18 | Kentucky | 21 | 1606537 | 17191 |
53171 | 53171 | 2022-10-18 | Louisiana | 22 | 1459308 | 18136 |
53195 | 53195 | 2022-10-18 | South Carolina | 45 | 1718600 | 18527 |
53151 | 53151 | 2022-10-18 | Alabama | 1 | 1530411 | 20522 |
53178 | 53178 | 2022-10-18 | Missouri | 29 | 1678032 | 21791 |
53174 | 53174 | 2022-10-18 | Massachusetts | 25 | 2069848 | 21841 |
53202 | 53202 | 2022-10-18 | Virginia | 51 | 2106527 | 22057 |
53167 | 53167 | 2022-10-18 | Indiana | 18 | 1930022 | 24816 |
53186 | 53186 | 2022-10-18 | North Carolina | 37 | 3220858 | 26895 |
53197 | 53197 | 2022-10-18 | Tennessee | 47 | 2293248 | 27735 |
53154 | 53154 | 2022-10-18 | Arizona | 4 | 2277635 | 31455 |
53183 | 53183 | 2022-10-18 | New Jersey | 34 | 2773961 | 34840 |
53162 | 53162 | 2022-10-18 | Georgia | 13 | 2828618 | 38882 |
53175 | 53175 | 2022-10-18 | Michigan | 26 | 2865394 | 39041 |
53166 | 53166 | 2022-10-18 | Illinois | 17 | 3796284 | 39867 |
53189 | 53189 | 2022-10-18 | Ohio | 39 | 3162278 | 40037 |
53192 | 53192 | 2022-10-18 | Pennsylvania | 42 | 3280746 | 47442 |
53185 | 53185 | 2022-10-18 | New York | 36 | 6184627 | 71541 |
53161 | 53161 | 2022-10-18 | Florida | 12 | 7144141 | 82025 |
53198 | 53198 | 2022-10-18 | Texas | 48 | 7903332 | 91156 |
53156 | 53156 | 2022-10-18 | California | 6 | 11319195 | 96481 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );