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-06-20 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 55
- 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
- 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 |
---|---|---|---|---|---|---|
26085 | 26085 | 2021-06-20 | Alabama | 1 | 548657 | 11306 |
26086 | 26086 | 2021-06-20 | Alaska | 2 | 70285 | 356 |
26087 | 26087 | 2021-06-20 | Arizona | 4 | 889727 | 17843 |
26088 | 26088 | 2021-06-20 | Arkansas | 5 | 345605 | 5874 |
26089 | 26089 | 2021-06-20 | California | 6 | 3808733 | 63337 |
26090 | 26090 | 2021-06-20 | Colorado | 8 | 557005 | 6876 |
26091 | 26091 | 2021-06-20 | Connecticut | 9 | 348665 | 8270 |
26092 | 26092 | 2021-06-20 | Delaware | 10 | 109548 | 1683 |
26093 | 26093 | 2021-06-20 | District of Columbia | 11 | 49243 | 1141 |
26094 | 26094 | 2021-06-20 | Florida | 12 | 2310881 | 37555 |
26095 | 26095 | 2021-06-20 | Georgia | 13 | 1106604 | 20628 |
26096 | 26096 | 2021-06-20 | Guam | 66 | 9236 | 140 |
26097 | 26097 | 2021-06-20 | Hawaii | 15 | 36036 | 510 |
26098 | 26098 | 2021-06-20 | Idaho | 16 | 194084 | 2125 |
26099 | 26099 | 2021-06-20 | Illinois | 17 | 1392733 | 25566 |
26100 | 26100 | 2021-06-20 | Indiana | 18 | 754583 | 13795 |
26101 | 26101 | 2021-06-20 | Iowa | 19 | 373101 | 6114 |
26102 | 26102 | 2021-06-20 | Kansas | 20 | 318104 | 5163 |
26103 | 26103 | 2021-06-20 | Kentucky | 21 | 464291 | 7227 |
26104 | 26104 | 2021-06-20 | Louisiana | 22 | 477453 | 10688 |
26105 | 26105 | 2021-06-20 | Maine | 23 | 68826 | 854 |
26106 | 26106 | 2021-06-20 | Maryland | 24 | 461956 | 9707 |
26107 | 26107 | 2021-06-20 | Massachusetts | 25 | 709395 | 17971 |
26108 | 26108 | 2021-06-20 | Michigan | 26 | 996624 | 20848 |
26109 | 26109 | 2021-06-20 | Minnesota | 27 | 604602 | 7638 |
26110 | 26110 | 2021-06-20 | Mississippi | 28 | 319948 | 7371 |
26111 | 26111 | 2021-06-20 | Missouri | 29 | 626206 | 9846 |
26112 | 26112 | 2021-06-20 | Montana | 30 | 113275 | 1651 |
26113 | 26113 | 2021-06-20 | Nebraska | 31 | 224343 | 2519 |
26114 | 26114 | 2021-06-20 | Nevada | 32 | 328875 | 5649 |
26115 | 26115 | 2021-06-20 | New Hampshire | 33 | 99254 | 1367 |
26116 | 26116 | 2021-06-20 | New Jersey | 34 | 1021182 | 26374 |
26117 | 26117 | 2021-06-20 | New Mexico | 35 | 204698 | 4318 |
26118 | 26118 | 2021-06-20 | New York | 36 | 2110069 | 53026 |
26119 | 26119 | 2021-06-20 | North Carolina | 37 | 1010919 | 13359 |
26120 | 26120 | 2021-06-20 | North Dakota | 38 | 110598 | 1554 |
26121 | 26121 | 2021-06-20 | Northern Mariana Islands | 69 | 183 | 2 |
26122 | 26122 | 2021-06-20 | Ohio | 39 | 1108902 | 20166 |
26123 | 26123 | 2021-06-20 | Oklahoma | 40 | 455535 | 7354 |
26124 | 26124 | 2021-06-20 | Oregon | 41 | 206777 | 2784 |
26125 | 26125 | 2021-06-20 | Pennsylvania | 42 | 1214901 | 27621 |
26126 | 26126 | 2021-06-20 | Puerto Rico | 72 | 173328 | 2540 |
26127 | 26127 | 2021-06-20 | Rhode Island | 44 | 152383 | 2724 |
26128 | 26128 | 2021-06-20 | South Carolina | 45 | 595448 | 9792 |
26129 | 26129 | 2021-06-20 | South Dakota | 46 | 124393 | 2027 |
26130 | 26130 | 2021-06-20 | Tennessee | 47 | 853104 | 12415 |
26131 | 26131 | 2021-06-20 | Texas | 48 | 2979672 | 52292 |
26132 | 26132 | 2021-06-20 | Utah | 49 | 411680 | 2330 |
26133 | 26133 | 2021-06-20 | Vermont | 50 | 24360 | 256 |
26134 | 26134 | 2021-06-20 | Virgin Islands | 78 | 3752 | 30 |
26135 | 26135 | 2021-06-20 | Virginia | 51 | 678649 | 11351 |
26136 | 26136 | 2021-06-20 | Washington | 53 | 449170 | 5867 |
26137 | 26137 | 2021-06-20 | West Virginia | 54 | 163382 | 2863 |
26138 | 26138 | 2021-06-20 | Wisconsin | 55 | 676885 | 8047 |
26139 | 26139 | 2021-06-20 | Wyoming | 56 | 61490 | 734 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );