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-10 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 |
---|---|---|---|---|---|---|
22180 | 22180 | 2021-04-10 | Alabama | 1 | 518588 | 10712 |
22181 | 22181 | 2021-04-10 | Alaska | 2 | 64259 | 299 |
22182 | 22182 | 2021-04-10 | Arizona | 4 | 849022 | 17092 |
22183 | 22183 | 2021-04-10 | Arkansas | 5 | 332053 | 5661 |
22184 | 22184 | 2021-04-10 | California | 6 | 3696900 | 60361 |
22185 | 22185 | 2021-04-10 | Colorado | 8 | 479514 | 6209 |
22186 | 22186 | 2021-04-10 | Connecticut | 9 | 321586 | 7944 |
22187 | 22187 | 2021-04-10 | Delaware | 10 | 98203 | 1577 |
22188 | 22188 | 2021-04-10 | District of Columbia | 11 | 45762 | 1081 |
22189 | 22189 | 2021-04-10 | Florida | 12 | 2118705 | 34013 |
22190 | 22190 | 2021-04-10 | Georgia | 13 | 1048888 | 18886 |
22191 | 22191 | 2021-04-10 | Guam | 66 | 8804 | 137 |
22192 | 22192 | 2021-04-10 | Hawaii | 15 | 30956 | 468 |
22193 | 22193 | 2021-04-10 | Idaho | 16 | 183258 | 1995 |
22194 | 22194 | 2021-04-10 | Illinois | 17 | 1280295 | 23777 |
22195 | 22195 | 2021-04-10 | Indiana | 18 | 700830 | 13138 |
22196 | 22196 | 2021-04-10 | Iowa | 19 | 356509 | 5857 |
22197 | 22197 | 2021-04-10 | Kansas | 20 | 306518 | 4938 |
22198 | 22198 | 2021-04-10 | Kentucky | 21 | 435930 | 6344 |
22199 | 22199 | 2021-04-10 | Louisiana | 22 | 448838 | 10216 |
22200 | 22200 | 2021-04-10 | Maine | 23 | 53745 | 750 |
22201 | 22201 | 2021-04-10 | Maryland | 24 | 425433 | 8444 |
22202 | 22202 | 2021-04-10 | Massachusetts | 25 | 657578 | 17379 |
22203 | 22203 | 2021-04-10 | Michigan | 26 | 818667 | 17552 |
22204 | 22204 | 2021-04-10 | Minnesota | 27 | 540355 | 7022 |
22205 | 22205 | 2021-04-10 | Mississippi | 28 | 307332 | 7095 |
22206 | 22206 | 2021-04-10 | Missouri | 29 | 595098 | 9006 |
22207 | 22207 | 2021-04-10 | Montana | 30 | 106205 | 1523 |
22208 | 22208 | 2021-04-10 | Nebraska | 31 | 214010 | 2327 |
22209 | 22209 | 2021-04-10 | Nevada | 32 | 307704 | 5332 |
22210 | 22210 | 2021-04-10 | New Hampshire | 33 | 88446 | 1256 |
22211 | 22211 | 2021-04-10 | New Jersey | 34 | 950103 | 24859 |
22212 | 22212 | 2021-04-10 | New Mexico | 35 | 193368 | 3978 |
22213 | 22213 | 2021-04-10 | New York | 36 | 1948232 | 50527 |
22214 | 22214 | 2021-04-10 | North Carolina | 37 | 930371 | 12274 |
22215 | 22215 | 2021-04-10 | North Dakota | 38 | 104732 | 1502 |
22216 | 22216 | 2021-04-10 | Northern Mariana Islands | 69 | 160 | 2 |
22217 | 22217 | 2021-04-10 | Ohio | 39 | 1037600 | 18827 |
22218 | 22218 | 2021-04-10 | Oklahoma | 40 | 442805 | 6669 |
22219 | 22219 | 2021-04-10 | Oregon | 41 | 170085 | 2451 |
22220 | 22220 | 2021-04-10 | Pennsylvania | 42 | 1073909 | 25457 |
22221 | 22221 | 2021-04-10 | Puerto Rico | 72 | 146815 | 2152 |
22222 | 22222 | 2021-04-10 | Rhode Island | 44 | 141097 | 2638 |
22223 | 22223 | 2021-04-10 | South Carolina | 45 | 561773 | 9273 |
22224 | 22224 | 2021-04-10 | South Dakota | 46 | 119705 | 1946 |
22225 | 22225 | 2021-04-10 | Tennessee | 47 | 807996 | 11900 |
22226 | 22226 | 2021-04-10 | Texas | 48 | 2821570 | 49345 |
22227 | 22227 | 2021-04-10 | Utah | 49 | 389821 | 2159 |
22228 | 22228 | 2021-04-10 | Vermont | 50 | 20965 | 231 |
22229 | 22229 | 2021-04-10 | Virgin Islands | 78 | 2971 | 26 |
22230 | 22230 | 2021-04-10 | Virginia | 51 | 634325 | 10458 |
22231 | 22231 | 2021-04-10 | Washington | 53 | 377979 | 5373 |
22232 | 22232 | 2021-04-10 | West Virginia | 54 | 145754 | 2742 |
22233 | 22233 | 2021-04-10 | Wisconsin | 55 | 645081 | 7380 |
22234 | 22234 | 2021-04-10 | 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 );