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-10-10 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- 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
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
32263 | 32263 | 2021-10-10 | Alabama | 1 | 808132 | 14858 |
32264 | 32264 | 2021-10-10 | Alaska | 2 | 120496 | 574 |
32265 | 32265 | 2021-10-10 | American Samoa | 60 | 3 | 0 |
32266 | 32266 | 2021-10-10 | Arizona | 4 | 1118601 | 20382 |
32267 | 32267 | 2021-10-10 | Arkansas | 5 | 502872 | 8120 |
32268 | 32268 | 2021-10-10 | California | 6 | 4792007 | 70160 |
32269 | 32269 | 2021-10-10 | Colorado | 8 | 692561 | 7915 |
32270 | 32270 | 2021-10-10 | Connecticut | 9 | 394008 | 8667 |
32271 | 32271 | 2021-10-10 | Delaware | 10 | 137599 | 1997 |
32272 | 32272 | 2021-10-10 | District of Columbia | 11 | 62266 | 1182 |
32273 | 32273 | 2021-10-10 | Florida | 12 | 3604846 | 56667 |
32274 | 32274 | 2021-10-10 | Georgia | 13 | 1567598 | 26215 |
32275 | 32275 | 2021-10-10 | Guam | 66 | 17027 | 213 |
32276 | 32276 | 2021-10-10 | Hawaii | 15 | 78986 | 838 |
32277 | 32277 | 2021-10-10 | Idaho | 16 | 268713 | 3123 |
32278 | 32278 | 2021-10-10 | Illinois | 17 | 1655222 | 27965 |
32279 | 32279 | 2021-10-10 | Indiana | 18 | 985949 | 15982 |
32280 | 32280 | 2021-10-10 | Iowa | 19 | 464797 | 6654 |
32281 | 32281 | 2021-10-10 | Kansas | 20 | 418664 | 6146 |
32282 | 32282 | 2021-10-10 | Kentucky | 21 | 716455 | 9162 |
32283 | 32283 | 2021-10-10 | Louisiana | 22 | 747329 | 14173 |
32284 | 32284 | 2021-10-10 | Maine | 23 | 94941 | 1075 |
32285 | 32285 | 2021-10-10 | Maryland | 24 | 544449 | 10593 |
32286 | 32286 | 2021-10-10 | Massachusetts | 25 | 823485 | 18746 |
32287 | 32287 | 2021-10-10 | Michigan | 26 | 1186800 | 22683 |
32288 | 32288 | 2021-10-10 | Minnesota | 27 | 735759 | 8408 |
32289 | 32289 | 2021-10-10 | Mississippi | 28 | 494271 | 9811 |
32290 | 32290 | 2021-10-10 | Missouri | 29 | 850474 | 12401 |
32291 | 32291 | 2021-10-10 | Montana | 30 | 158851 | 2079 |
32292 | 32292 | 2021-10-10 | Nebraska | 31 | 271550 | 2855 |
32293 | 32293 | 2021-10-10 | Nevada | 32 | 436244 | 7285 |
32294 | 32294 | 2021-10-10 | New Hampshire | 33 | 124208 | 1497 |
32295 | 32295 | 2021-10-10 | New Jersey | 34 | 1171573 | 27597 |
32296 | 32296 | 2021-10-10 | New Mexico | 35 | 258943 | 4871 |
32297 | 32297 | 2021-10-10 | New York | 36 | 2470595 | 55253 |
32298 | 32298 | 2021-10-10 | North Carolina | 37 | 1427236 | 17121 |
32299 | 32299 | 2021-10-10 | North Dakota | 38 | 137985 | 1676 |
32300 | 32300 | 2021-10-10 | Northern Mariana Islands | 69 | 273 | 2 |
32301 | 32301 | 2021-10-10 | Ohio | 39 | 1467331 | 22819 |
32302 | 32302 | 2021-10-10 | Oklahoma | 40 | 622780 | 9213 |
32303 | 32303 | 2021-10-10 | Oregon | 41 | 341113 | 3982 |
32304 | 32304 | 2021-10-10 | Pennsylvania | 42 | 1479364 | 29907 |
32305 | 32305 | 2021-10-10 | Puerto Rico | 72 | 216012 | 3191 |
32306 | 32306 | 2021-10-10 | Rhode Island | 44 | 174570 | 2854 |
32307 | 32307 | 2021-10-10 | South Carolina | 45 | 874013 | 12929 |
32308 | 32308 | 2021-10-10 | South Dakota | 46 | 147820 | 2171 |
32309 | 32309 | 2021-10-10 | Tennessee | 47 | 1220612 | 15428 |
32310 | 32310 | 2021-10-10 | Texas | 48 | 4129954 | 67994 |
32311 | 32311 | 2021-10-10 | Utah | 49 | 520291 | 2994 |
32312 | 32312 | 2021-10-10 | Vermont | 50 | 35672 | 335 |
32313 | 32313 | 2021-10-10 | Virgin Islands | 78 | 6925 | 73 |
32314 | 32314 | 2021-10-10 | Virginia | 51 | 888159 | 13075 |
32315 | 32315 | 2021-10-10 | Washington | 53 | 680808 | 8068 |
32316 | 32316 | 2021-10-10 | West Virginia | 54 | 253138 | 3935 |
32317 | 32317 | 2021-10-10 | Wisconsin | 55 | 835193 | 9006 |
32318 | 32318 | 2021-10-10 | Wyoming | 56 | 94303 | 1041 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );