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 2021-11-19 sorted by date descending
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 |
---|---|---|---|---|---|---|
34503 | 34503 | 2021-11-19 | Alabama | 1 | 841956 | 16063 |
34504 | 34504 | 2021-11-19 | Alaska | 2 | 147120 | 838 |
34505 | 34505 | 2021-11-19 | American Samoa | 60 | 5 | 0 |
34506 | 34506 | 2021-11-19 | Arizona | 4 | 1233146 | 21886 |
34507 | 34507 | 2021-11-19 | Arkansas | 5 | 523192 | 8608 |
34508 | 34508 | 2021-11-19 | California | 6 | 5037132 | 73901 |
34509 | 34509 | 2021-11-19 | Colorado | 8 | 808315 | 9059 |
34510 | 34510 | 2021-11-19 | Connecticut | 9 | 412918 | 8850 |
34511 | 34511 | 2021-11-19 | Delaware | 10 | 149566 | 2154 |
34512 | 34512 | 2021-11-19 | District of Columbia | 11 | 66028 | 1196 |
34513 | 34513 | 2021-11-19 | Florida | 12 | 3677968 | 61081 |
34514 | 34514 | 2021-11-19 | Georgia | 13 | 1620185 | 29057 |
34515 | 34515 | 2021-11-19 | Guam | 66 | 20030 | 263 |
34516 | 34516 | 2021-11-19 | Hawaii | 15 | 83684 | 995 |
34517 | 34517 | 2021-11-19 | Idaho | 16 | 303050 | 3845 |
34518 | 34518 | 2021-11-19 | Illinois | 17 | 1769267 | 29157 |
34519 | 34519 | 2021-11-19 | Indiana | 18 | 1073046 | 17247 |
34520 | 34520 | 2021-11-19 | Iowa | 19 | 509761 | 7268 |
34521 | 34521 | 2021-11-19 | Kansas | 20 | 456720 | 6668 |
34522 | 34522 | 2021-11-19 | Kentucky | 21 | 774770 | 10671 |
34523 | 34523 | 2021-11-19 | Louisiana | 22 | 767330 | 14749 |
34524 | 34524 | 2021-11-19 | Maine | 23 | 115009 | 1268 |
34525 | 34525 | 2021-11-19 | Maryland | 24 | 576229 | 11102 |
34526 | 34526 | 2021-11-19 | Massachusetts | 25 | 890733 | 19268 |
34527 | 34527 | 2021-11-19 | Michigan | 26 | 1405810 | 24814 |
34528 | 34528 | 2021-11-19 | Minnesota | 27 | 871327 | 9279 |
34529 | 34529 | 2021-11-19 | Mississippi | 28 | 510748 | 10229 |
34530 | 34530 | 2021-11-19 | Missouri | 29 | 905060 | 15405 |
34531 | 34531 | 2021-11-19 | Montana | 30 | 188217 | 2554 |
34532 | 34532 | 2021-11-19 | Nebraska | 31 | 301436 | 3098 |
34533 | 34533 | 2021-11-19 | Nevada | 32 | 464633 | 7918 |
34534 | 34534 | 2021-11-19 | New Hampshire | 33 | 150813 | 1662 |
34535 | 34535 | 2021-11-19 | New Jersey | 34 | 1228167 | 28243 |
34536 | 34536 | 2021-11-19 | New Mexico | 35 | 301937 | 5265 |
34537 | 34537 | 2021-11-19 | New York | 36 | 2658788 | 56663 |
34538 | 34538 | 2021-11-19 | North Carolina | 37 | 1517098 | 18617 |
34539 | 34539 | 2021-11-19 | North Dakota | 38 | 157888 | 1887 |
34540 | 34540 | 2021-11-19 | Northern Mariana Islands | 69 | 438 | 3 |
34541 | 34541 | 2021-11-19 | Ohio | 39 | 1633480 | 26063 |
34542 | 34542 | 2021-11-19 | Oklahoma | 40 | 658600 | 10879 |
34543 | 34543 | 2021-11-19 | Oregon | 41 | 384062 | 4914 |
34544 | 34544 | 2021-11-19 | Pennsylvania | 42 | 1674328 | 32825 |
34545 | 34545 | 2021-11-19 | Puerto Rico | 72 | 220711 | 3260 |
34546 | 34546 | 2021-11-19 | Rhode Island | 44 | 186387 | 2906 |
34547 | 34547 | 2021-11-19 | South Carolina | 45 | 911624 | 14096 |
34548 | 34548 | 2021-11-19 | South Dakota | 46 | 162375 | 2305 |
34549 | 34549 | 2021-11-19 | Tennessee | 47 | 1274480 | 16689 |
34550 | 34550 | 2021-11-19 | Texas | 48 | 4296648 | 73591 |
34551 | 34551 | 2021-11-19 | Utah | 49 | 583054 | 3428 |
34552 | 34552 | 2021-11-19 | Vermont | 50 | 46449 | 401 |
34553 | 34553 | 2021-11-19 | Virgin Islands | 78 | 7439 | 85 |
34554 | 34554 | 2021-11-19 | Virginia | 51 | 953460 | 14492 |
34555 | 34555 | 2021-11-19 | Washington | 53 | 764781 | 9157 |
34556 | 34556 | 2021-11-19 | West Virginia | 54 | 287612 | 4726 |
34557 | 34557 | 2021-11-19 | Wisconsin | 55 | 945854 | 9816 |
34558 | 34558 | 2021-11-19 | Wyoming | 56 | 109318 | 1347 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );