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 2020-10-09 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|
12115 | 12115 | 2020-10-09 | Alabama | 1 | 163465 | 2653 |
12116 | 12116 | 2020-10-09 | Alaska | 2 | 10099 | 56 |
12117 | 12117 | 2020-10-09 | Arizona | 4 | 224101 | 5746 |
12118 | 12118 | 2020-10-09 | Arkansas | 5 | 91312 | 1530 |
12119 | 12119 | 2020-10-09 | California | 6 | 851229 | 16502 |
12120 | 12120 | 2020-10-09 | Colorado | 8 | 77068 | 2115 |
12121 | 12121 | 2020-10-09 | Connecticut | 9 | 60038 | 4530 |
12122 | 12122 | 2020-10-09 | Delaware | 10 | 21827 | 651 |
12123 | 12123 | 2020-10-09 | District of Columbia | 11 | 15843 | 634 |
12124 | 12124 | 2020-10-09 | Florida | 12 | 728913 | 15185 |
12125 | 12125 | 2020-10-09 | Georgia | 13 | 333934 | 7178 |
12126 | 12126 | 2020-10-09 | Guam | 66 | 3958 | 59 |
12127 | 12127 | 2020-10-09 | Hawaii | 15 | 13461 | 165 |
12128 | 12128 | 2020-10-09 | Idaho | 16 | 47674 | 506 |
12129 | 12129 | 2020-10-09 | Illinois | 17 | 317501 | 9207 |
12130 | 12130 | 2020-10-09 | Indiana | 18 | 133864 | 3761 |
12131 | 12131 | 2020-10-09 | Iowa | 19 | 98023 | 1454 |
12132 | 12132 | 2020-10-09 | Kansas | 20 | 67086 | 765 |
12133 | 12133 | 2020-10-09 | Kentucky | 21 | 80633 | 1283 |
12134 | 12134 | 2020-10-09 | Louisiana | 22 | 173406 | 5635 |
12135 | 12135 | 2020-10-09 | Maine | 23 | 5666 | 143 |
12136 | 12136 | 2020-10-09 | Maryland | 24 | 130652 | 3990 |
12137 | 12137 | 2020-10-09 | Massachusetts | 25 | 137701 | 9577 |
12138 | 12138 | 2020-10-09 | Michigan | 26 | 147880 | 7202 |
12139 | 12139 | 2020-10-09 | Minnesota | 27 | 109365 | 2174 |
12140 | 12140 | 2020-10-09 | Mississippi | 28 | 103681 | 3080 |
12141 | 12141 | 2020-10-09 | Missouri | 29 | 145034 | 2463 |
12142 | 12142 | 2020-10-09 | Montana | 30 | 17478 | 206 |
12143 | 12143 | 2020-10-09 | Nebraska | 31 | 50168 | 522 |
12144 | 12144 | 2020-10-09 | Nevada | 32 | 84785 | 1658 |
12145 | 12145 | 2020-10-09 | New Hampshire | 33 | 8970 | 450 |
12146 | 12146 | 2020-10-09 | New Jersey | 34 | 213801 | 16164 |
12147 | 12147 | 2020-10-09 | New Mexico | 35 | 32241 | 902 |
12148 | 12148 | 2020-10-09 | New York | 36 | 476422 | 32867 |
12149 | 12149 | 2020-10-09 | North Carolina | 37 | 227756 | 3768 |
12150 | 12150 | 2020-10-09 | North Dakota | 38 | 26044 | 325 |
12151 | 12151 | 2020-10-09 | Northern Mariana Islands | 69 | 75 | 2 |
12152 | 12152 | 2020-10-09 | Ohio | 39 | 166102 | 4994 |
12153 | 12153 | 2020-10-09 | Oklahoma | 40 | 97088 | 1091 |
12154 | 12154 | 2020-10-09 | Oregon | 41 | 36538 | 600 |
12155 | 12155 | 2020-10-09 | Pennsylvania | 42 | 174352 | 8387 |
12156 | 12156 | 2020-10-09 | Puerto Rico | 72 | 52892 | 720 |
12157 | 12157 | 2020-10-09 | Rhode Island | 44 | 26294 | 1130 |
12158 | 12158 | 2020-10-09 | South Carolina | 45 | 155676 | 3530 |
12159 | 12159 | 2020-10-09 | South Dakota | 46 | 27215 | 277 |
12160 | 12160 | 2020-10-09 | Tennessee | 47 | 207823 | 2702 |
12161 | 12161 | 2020-10-09 | Texas | 48 | 826241 | 16955 |
12162 | 12162 | 2020-10-09 | Utah | 49 | 83307 | 508 |
12163 | 12163 | 2020-10-09 | Vermont | 50 | 1846 | 58 |
12164 | 12164 | 2020-10-09 | Virgin Islands | 78 | 1324 | 20 |
12165 | 12165 | 2020-10-09 | Virginia | 51 | 156649 | 3344 |
12166 | 12166 | 2020-10-09 | Washington | 53 | 96837 | 2288 |
12167 | 12167 | 2020-10-09 | West Virginia | 54 | 17707 | 376 |
12168 | 12168 | 2020-10-09 | Wisconsin | 55 | 152831 | 1453 |
12169 | 12169 | 2020-10-09 | Wyoming | 56 | 7335 | 54 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );