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-04-09 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 |
---|---|---|---|---|---|---|
22125 | 22125 | 2021-04-09 | Alabama | 1 | 518234 | 10686 |
22126 | 22126 | 2021-04-09 | Alaska | 2 | 64259 | 299 |
22127 | 22127 | 2021-04-09 | Arizona | 4 | 848217 | 17062 |
22128 | 22128 | 2021-04-09 | Arkansas | 5 | 331882 | 5661 |
22129 | 22129 | 2021-04-09 | California | 6 | 3693923 | 60272 |
22130 | 22130 | 2021-04-09 | Colorado | 8 | 478535 | 6203 |
22131 | 22131 | 2021-04-09 | Connecticut | 9 | 321586 | 7944 |
22132 | 22132 | 2021-04-09 | Delaware | 10 | 97784 | 1573 |
22133 | 22133 | 2021-04-09 | District of Columbia | 11 | 45634 | 1079 |
22134 | 22134 | 2021-04-09 | Florida | 12 | 2111799 | 33967 |
22135 | 22135 | 2021-04-09 | Georgia | 13 | 1047385 | 18825 |
22136 | 22136 | 2021-04-09 | Guam | 66 | 8802 | 137 |
22137 | 22137 | 2021-04-09 | Hawaii | 15 | 30844 | 467 |
22138 | 22138 | 2021-04-09 | Idaho | 16 | 183255 | 1995 |
22139 | 22139 | 2021-04-09 | Illinois | 17 | 1276891 | 23762 |
22140 | 22140 | 2021-04-09 | Indiana | 18 | 699472 | 13131 |
22141 | 22141 | 2021-04-09 | Iowa | 19 | 356073 | 5849 |
22142 | 22142 | 2021-04-09 | Kansas | 20 | 306518 | 4938 |
22143 | 22143 | 2021-04-09 | Kentucky | 21 | 435601 | 6328 |
22144 | 22144 | 2021-04-09 | Louisiana | 22 | 448838 | 10216 |
22145 | 22145 | 2021-04-09 | Maine | 23 | 53434 | 750 |
22146 | 22146 | 2021-04-09 | Maryland | 24 | 423849 | 8424 |
22147 | 22147 | 2021-04-09 | Massachusetts | 25 | 655278 | 17376 |
22148 | 22148 | 2021-04-09 | Michigan | 26 | 811304 | 17471 |
22149 | 22149 | 2021-04-09 | Minnesota | 27 | 537906 | 7010 |
22150 | 22150 | 2021-04-09 | Mississippi | 28 | 307094 | 7086 |
22151 | 22151 | 2021-04-09 | Missouri | 29 | 594557 | 9000 |
22152 | 22152 | 2021-04-09 | Montana | 30 | 106104 | 1521 |
22153 | 22153 | 2021-04-09 | Nebraska | 31 | 213574 | 2326 |
22154 | 22154 | 2021-04-09 | Nevada | 32 | 306952 | 5323 |
22155 | 22155 | 2021-04-09 | New Hampshire | 33 | 87978 | 1253 |
22156 | 22156 | 2021-04-09 | New Jersey | 34 | 946504 | 24826 |
22157 | 22157 | 2021-04-09 | New Mexico | 35 | 193368 | 3978 |
22158 | 22158 | 2021-04-09 | New York | 36 | 1940703 | 50465 |
22159 | 22159 | 2021-04-09 | North Carolina | 37 | 930371 | 12273 |
22160 | 22160 | 2021-04-09 | North Dakota | 38 | 104519 | 1501 |
22161 | 22161 | 2021-04-09 | Northern Mariana Islands | 69 | 160 | 2 |
22162 | 22162 | 2021-04-09 | Ohio | 39 | 1035552 | 18827 |
22163 | 22163 | 2021-04-09 | Oklahoma | 40 | 442805 | 6669 |
22164 | 22164 | 2021-04-09 | Oregon | 41 | 169338 | 2451 |
22165 | 22165 | 2021-04-09 | Pennsylvania | 42 | 1069713 | 25421 |
22166 | 22166 | 2021-04-09 | Puerto Rico | 72 | 145375 | 2146 |
22167 | 22167 | 2021-04-09 | Rhode Island | 44 | 141097 | 2638 |
22168 | 22168 | 2021-04-09 | South Carolina | 45 | 560762 | 9248 |
22169 | 22169 | 2021-04-09 | South Dakota | 46 | 119467 | 1946 |
22170 | 22170 | 2021-04-09 | Tennessee | 47 | 807921 | 11900 |
22171 | 22171 | 2021-04-09 | Texas | 48 | 2819137 | 49280 |
22172 | 22172 | 2021-04-09 | Utah | 49 | 389414 | 2157 |
22173 | 22173 | 2021-04-09 | Vermont | 50 | 20815 | 231 |
22174 | 22174 | 2021-04-09 | Virgin Islands | 78 | 2971 | 26 |
22175 | 22175 | 2021-04-09 | Virginia | 51 | 632625 | 10451 |
22176 | 22176 | 2021-04-09 | Washington | 53 | 376812 | 5373 |
22177 | 22177 | 2021-04-09 | West Virginia | 54 | 145299 | 2737 |
22178 | 22178 | 2021-04-09 | Wisconsin | 55 | 644160 | 7376 |
22179 | 22179 | 2021-04-09 | Wyoming | 56 | 56873 | 701 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );