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-09-21 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 |
---|---|---|---|---|---|---|
31200 | 31200 | 2021-09-21 | Alabama | 1 | 775531 | 13460 |
31201 | 31201 | 2021-09-21 | Alaska | 2 | 102551 | 463 |
31202 | 31202 | 2021-09-21 | Arizona | 4 | 1070757 | 19584 |
31203 | 31203 | 2021-09-21 | Arkansas | 5 | 486853 | 7499 |
31204 | 31204 | 2021-09-21 | California | 6 | 4669895 | 68244 |
31205 | 31205 | 2021-09-21 | Colorado | 8 | 658712 | 7605 |
31206 | 31206 | 2021-09-21 | Connecticut | 9 | 386182 | 8477 |
31207 | 31207 | 2021-09-21 | Delaware | 10 | 128964 | 1927 |
31208 | 31208 | 2021-09-21 | District of Columbia | 11 | 59712 | 1171 |
31209 | 31209 | 2021-09-21 | Florida | 12 | 3517177 | 51889 |
31210 | 31210 | 2021-09-21 | Georgia | 13 | 1510443 | 24114 |
31211 | 31211 | 2021-09-21 | Guam | 66 | 14828 | 182 |
31212 | 31212 | 2021-09-21 | Hawaii | 15 | 73841 | 711 |
31213 | 31213 | 2021-09-21 | Idaho | 16 | 245458 | 2663 |
31214 | 31214 | 2021-09-21 | Illinois | 17 | 1606469 | 27299 |
31215 | 31215 | 2021-09-21 | Indiana | 18 | 940608 | 15239 |
31216 | 31216 | 2021-09-21 | Iowa | 19 | 437872 | 6401 |
31217 | 31217 | 2021-09-21 | Kansas | 20 | 400540 | 5939 |
31218 | 31218 | 2021-09-21 | Kentucky | 21 | 666269 | 8450 |
31219 | 31219 | 2021-09-21 | Louisiana | 22 | 730099 | 13558 |
31220 | 31220 | 2021-09-21 | Maine | 23 | 84542 | 1002 |
31221 | 31221 | 2021-09-21 | Maryland | 24 | 521438 | 10309 |
31222 | 31222 | 2021-09-21 | Massachusetts | 25 | 796925 | 18480 |
31223 | 31223 | 2021-09-21 | Michigan | 26 | 1115997 | 22020 |
31224 | 31224 | 2021-09-21 | Minnesota | 27 | 690484 | 8104 |
31225 | 31225 | 2021-09-21 | Mississippi | 28 | 477769 | 9331 |
31226 | 31226 | 2021-09-21 | Missouri | 29 | 820910 | 11955 |
31227 | 31227 | 2021-09-21 | Montana | 30 | 142655 | 1901 |
31228 | 31228 | 2021-09-21 | Nebraska | 31 | 260199 | 2634 |
31229 | 31229 | 2021-09-21 | Nevada | 32 | 413547 | 6918 |
31230 | 31230 | 2021-09-21 | New Hampshire | 33 | 115612 | 1462 |
31231 | 31231 | 2021-09-21 | New Jersey | 34 | 1137016 | 27240 |
31232 | 31232 | 2021-09-21 | New Mexico | 35 | 246639 | 4702 |
31233 | 31233 | 2021-09-21 | New York | 36 | 2380164 | 54559 |
31234 | 31234 | 2021-09-21 | North Carolina | 37 | 1353006 | 15829 |
31235 | 31235 | 2021-09-21 | North Dakota | 38 | 126675 | 1626 |
31236 | 31236 | 2021-09-21 | Northern Mariana Islands | 69 | 265 | 2 |
31237 | 31237 | 2021-09-21 | Ohio | 39 | 1358918 | 21596 |
31238 | 31238 | 2021-09-21 | Oklahoma | 40 | 598556 | 8439 |
31239 | 31239 | 2021-09-21 | Oregon | 41 | 314841 | 3624 |
31240 | 31240 | 2021-09-21 | Pennsylvania | 42 | 1387872 | 28932 |
31241 | 31241 | 2021-09-21 | Puerto Rico | 72 | 212847 | 3092 |
31242 | 31242 | 2021-09-21 | Rhode Island | 44 | 169686 | 2816 |
31243 | 31243 | 2021-09-21 | South Carolina | 45 | 832466 | 11828 |
31244 | 31244 | 2021-09-21 | South Dakota | 46 | 141141 | 2108 |
31245 | 31245 | 2021-09-21 | Tennessee | 47 | 1163270 | 14334 |
31246 | 31246 | 2021-09-21 | Texas | 48 | 3954709 | 62778 |
31247 | 31247 | 2021-09-21 | Utah | 49 | 495796 | 2829 |
31248 | 31248 | 2021-09-21 | Vermont | 50 | 31911 | 301 |
31249 | 31249 | 2021-09-21 | Virgin Islands | 78 | 6489 | 67 |
31250 | 31250 | 2021-09-21 | Virginia | 51 | 839475 | 12364 |
31251 | 31251 | 2021-09-21 | Washington | 53 | 633534 | 7372 |
31252 | 31252 | 2021-09-21 | West Virginia | 54 | 225772 | 3441 |
31253 | 31253 | 2021-09-21 | Wisconsin | 55 | 784048 | 8731 |
31254 | 31254 | 2021-09-21 | Wyoming | 56 | 86052 | 955 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );