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-05-17 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|
24215 | 24215 | 2021-05-17 | Alabama | 1 | 540267 | 11038 |
24216 | 24216 | 2021-05-17 | Alaska | 2 | 69032 | 347 |
24217 | 24217 | 2021-05-17 | Arizona | 4 | 873446 | 17466 |
24218 | 24218 | 2021-05-17 | Arkansas | 5 | 338849 | 5796 |
24219 | 24219 | 2021-05-17 | California | 6 | 3770344 | 62701 |
24220 | 24220 | 2021-05-17 | Colorado | 8 | 535375 | 6592 |
24221 | 24221 | 2021-05-17 | Connecticut | 9 | 345639 | 8194 |
24222 | 24222 | 2021-05-17 | Delaware | 10 | 107089 | 1651 |
24223 | 24223 | 2021-05-17 | District of Columbia | 11 | 48590 | 1122 |
24224 | 24224 | 2021-05-17 | Florida | 12 | 2293972 | 36132 |
24225 | 24225 | 2021-05-17 | Georgia | 13 | 1091492 | 19860 |
24226 | 24226 | 2021-05-17 | Guam | 66 | 9072 | 140 |
24227 | 24227 | 2021-05-17 | Hawaii | 15 | 34247 | 489 |
24228 | 24228 | 2021-05-17 | Idaho | 16 | 190354 | 2071 |
24229 | 24229 | 2021-05-17 | Illinois | 17 | 1371126 | 24801 |
24230 | 24230 | 2021-05-17 | Indiana | 18 | 739327 | 13486 |
24231 | 24231 | 2021-05-17 | Iowa | 19 | 369489 | 6006 |
24232 | 24232 | 2021-05-17 | Kansas | 20 | 314136 | 5080 |
24233 | 24233 | 2021-05-17 | Kentucky | 21 | 455442 | 6832 |
24234 | 24234 | 2021-05-17 | Louisiana | 22 | 465946 | 10489 |
24235 | 24235 | 2021-05-17 | Maine | 23 | 65914 | 803 |
24236 | 24236 | 2021-05-17 | Maryland | 24 | 456408 | 8932 |
24237 | 24237 | 2021-05-17 | Massachusetts | 25 | 702338 | 17772 |
24238 | 24238 | 2021-05-17 | Michigan | 26 | 977002 | 19799 |
24239 | 24239 | 2021-05-17 | Minnesota | 27 | 595109 | 7389 |
24240 | 24240 | 2021-05-17 | Mississippi | 28 | 315026 | 7257 |
24241 | 24241 | 2021-05-17 | Missouri | 29 | 609296 | 9393 |
24242 | 24242 | 2021-05-17 | Montana | 30 | 110825 | 1598 |
24243 | 24243 | 2021-05-17 | Nebraska | 31 | 222512 | 2364 |
24244 | 24244 | 2021-05-17 | Nevada | 32 | 321081 | 5533 |
24245 | 24245 | 2021-05-17 | New Hampshire | 33 | 97774 | 1333 |
24246 | 24246 | 2021-05-17 | New Jersey | 34 | 1011107 | 25974 |
24247 | 24247 | 2021-05-17 | New Mexico | 35 | 201186 | 4118 |
24248 | 24248 | 2021-05-17 | New York | 36 | 2085028 | 52449 |
24249 | 24249 | 2021-05-17 | North Carolina | 37 | 992520 | 12915 |
24250 | 24250 | 2021-05-17 | North Dakota | 38 | 109165 | 1534 |
24251 | 24251 | 2021-05-17 | Northern Mariana Islands | 69 | 172 | 2 |
24252 | 24252 | 2021-05-17 | Ohio | 39 | 1091623 | 19528 |
24253 | 24253 | 2021-05-17 | Oklahoma | 40 | 451278 | 6878 |
24254 | 24254 | 2021-05-17 | Oregon | 41 | 196004 | 2616 |
24255 | 24255 | 2021-05-17 | Pennsylvania | 42 | 1191979 | 26890 |
24256 | 24256 | 2021-05-17 | Puerto Rico | 72 | 170578 | 2438 |
24257 | 24257 | 2021-05-17 | Rhode Island | 44 | 150648 | 2701 |
24258 | 24258 | 2021-05-17 | South Carolina | 45 | 588939 | 9654 |
24259 | 24259 | 2021-05-17 | South Dakota | 46 | 123686 | 1993 |
24260 | 24260 | 2021-05-17 | Tennessee | 47 | 843588 | 12228 |
24261 | 24261 | 2021-05-17 | Texas | 48 | 2926306 | 51139 |
24262 | 24262 | 2021-05-17 | Utah | 49 | 402798 | 2259 |
24263 | 24263 | 2021-05-17 | Vermont | 50 | 23912 | 252 |
24264 | 24264 | 2021-05-17 | Virgin Islands | 78 | 3267 | 27 |
24265 | 24265 | 2021-05-17 | Virginia | 51 | 670465 | 11029 |
24266 | 24266 | 2021-05-17 | Washington | 53 | 425382 | 5682 |
24267 | 24267 | 2021-05-17 | West Virginia | 54 | 158643 | 2762 |
24268 | 24268 | 2021-05-17 | Wisconsin | 55 | 670017 | 7712 |
24269 | 24269 | 2021-05-17 | Wyoming | 56 | 59222 | 712 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );