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-26 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 |
---|---|---|---|---|---|---|
21355 | 21355 | 2021-03-26 | Alabama | 1 | 513580 | 10523 |
21356 | 21356 | 2021-03-26 | Alaska | 2 | 61744 | 299 |
21357 | 21357 | 2021-03-26 | Arizona | 4 | 838558 | 16898 |
21358 | 21358 | 2021-03-26 | Arkansas | 5 | 329695 | 5583 |
21359 | 21359 | 2021-03-26 | California | 6 | 3656822 | 58630 |
21360 | 21360 | 2021-03-26 | Colorado | 8 | 458106 | 6161 |
21361 | 21361 | 2021-03-26 | Connecticut | 9 | 305210 | 7865 |
21362 | 21362 | 2021-03-26 | Delaware | 10 | 93325 | 1536 |
21363 | 21363 | 2021-03-26 | District of Columbia | 11 | 43825 | 1055 |
21364 | 21364 | 2021-03-26 | Florida | 12 | 2033171 | 33115 |
21365 | 21365 | 2021-03-26 | Georgia | 13 | 1028447 | 18275 |
21366 | 21366 | 2021-03-26 | Guam | 66 | 8765 | 135 |
21367 | 21367 | 2021-03-26 | Hawaii | 15 | 29322 | 456 |
21368 | 21368 | 2021-03-26 | Idaho | 16 | 179313 | 1957 |
21369 | 21369 | 2021-03-26 | Illinois | 17 | 1236528 | 23472 |
21370 | 21370 | 2021-03-26 | Indiana | 18 | 685382 | 13002 |
21371 | 21371 | 2021-03-26 | Iowa | 19 | 349055 | 5716 |
21372 | 21372 | 2021-03-26 | Kansas | 20 | 303710 | 4891 |
21373 | 21373 | 2021-03-26 | Kentucky | 21 | 427650 | 6041 |
21374 | 21374 | 2021-03-26 | Louisiana | 22 | 443069 | 10087 |
21375 | 21375 | 2021-03-26 | Maine | 23 | 49443 | 731 |
21376 | 21376 | 2021-03-26 | Maryland | 24 | 405528 | 8232 |
21377 | 21377 | 2021-03-26 | Massachusetts | 25 | 624986 | 17051 |
21378 | 21378 | 2021-03-26 | Michigan | 26 | 717104 | 17015 |
21379 | 21379 | 2021-03-26 | Minnesota | 27 | 512175 | 6899 |
21380 | 21380 | 2021-03-26 | Mississippi | 28 | 304210 | 6998 |
21381 | 21381 | 2021-03-26 | Missouri | 29 | 586353 | 8910 |
21382 | 21382 | 2021-03-26 | Montana | 30 | 104107 | 1435 |
21383 | 21383 | 2021-03-26 | Nebraska | 31 | 208213 | 2280 |
21384 | 21384 | 2021-03-26 | Nevada | 32 | 302642 | 5226 |
21385 | 21385 | 2021-03-26 | New Hampshire | 33 | 82374 | 1231 |
21386 | 21386 | 2021-03-26 | New Jersey | 34 | 887479 | 24358 |
21387 | 21387 | 2021-03-26 | New Mexico | 35 | 190716 | 3925 |
21388 | 21388 | 2021-03-26 | New York | 36 | 1831605 | 49363 |
21389 | 21389 | 2021-03-26 | North Carolina | 37 | 906770 | 12049 |
21390 | 21390 | 2021-03-26 | North Dakota | 38 | 102414 | 1498 |
21391 | 21391 | 2021-03-26 | Northern Mariana Islands | 69 | 159 | 2 |
21392 | 21392 | 2021-03-26 | Ohio | 39 | 1008913 | 18526 |
21393 | 21393 | 2021-03-26 | Oklahoma | 40 | 436971 | 4850 |
21394 | 21394 | 2021-03-26 | Oregon | 41 | 163368 | 2384 |
21395 | 21395 | 2021-03-26 | Pennsylvania | 42 | 1010521 | 25013 |
21396 | 21396 | 2021-03-26 | Puerto Rico | 72 | 138841 | 2106 |
21397 | 21397 | 2021-03-26 | Rhode Island | 44 | 135775 | 2608 |
21398 | 21398 | 2021-03-26 | South Carolina | 45 | 546670 | 9092 |
21399 | 21399 | 2021-03-26 | South Dakota | 46 | 116833 | 1928 |
21400 | 21400 | 2021-03-26 | Tennessee | 47 | 792724 | 11713 |
21401 | 21401 | 2021-03-26 | Texas | 48 | 2772019 | 48126 |
21402 | 21402 | 2021-03-26 | Utah | 49 | 383771 | 2091 |
21403 | 21403 | 2021-03-26 | Vermont | 50 | 18498 | 224 |
21404 | 21404 | 2021-03-26 | Virgin Islands | 78 | 2888 | 26 |
21405 | 21405 | 2021-03-26 | Virginia | 51 | 612062 | 10154 |
21406 | 21406 | 2021-03-26 | Washington | 53 | 362403 | 5288 |
21407 | 21407 | 2021-03-26 | West Virginia | 54 | 139750 | 2628 |
21408 | 21408 | 2021-03-26 | Wisconsin | 55 | 633154 | 7272 |
21409 | 21409 | 2021-03-26 | Wyoming | 56 | 56046 | 695 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );