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-06-08 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 |
---|---|---|---|---|---|---|
5350 | 5350 | 2020-06-08 | Alabama | 1 | 20925 | 718 |
5351 | 5351 | 2020-06-08 | Alaska | 2 | 607 | 8 |
5352 | 5352 | 2020-06-08 | Arizona | 4 | 27761 | 1052 |
5353 | 5353 | 2020-06-08 | Arkansas | 5 | 9740 | 155 |
5354 | 5354 | 2020-06-08 | California | 6 | 134287 | 4679 |
5355 | 5355 | 2020-06-08 | Colorado | 8 | 28169 | 1543 |
5356 | 5356 | 2020-06-08 | Connecticut | 9 | 44092 | 4084 |
5357 | 5357 | 2020-06-08 | Delaware | 10 | 9972 | 398 |
5358 | 5358 | 2020-06-08 | District of Columbia | 11 | 9389 | 491 |
5359 | 5359 | 2020-06-08 | Florida | 12 | 64896 | 2711 |
5360 | 5360 | 2020-06-08 | Georgia | 13 | 49995 | 2176 |
5361 | 5361 | 2020-06-08 | Guam | 66 | 1149 | 6 |
5362 | 5362 | 2020-06-08 | Hawaii | 15 | 664 | 17 |
5363 | 5363 | 2020-06-08 | Idaho | 16 | 3197 | 83 |
5364 | 5364 | 2020-06-08 | Illinois | 17 | 129543 | 6142 |
5365 | 5365 | 2020-06-08 | Indiana | 18 | 38553 | 2316 |
5366 | 5366 | 2020-06-08 | Iowa | 19 | 22111 | 623 |
5367 | 5367 | 2020-06-08 | Kansas | 20 | 10724 | 237 |
5368 | 5368 | 2020-06-08 | Kentucky | 21 | 11701 | 487 |
5369 | 5369 | 2020-06-08 | Louisiana | 22 | 43163 | 2944 |
5370 | 5370 | 2020-06-08 | Maine | 23 | 2588 | 99 |
5371 | 5371 | 2020-06-08 | Maryland | 24 | 59024 | 2776 |
5372 | 5372 | 2020-06-08 | Massachusetts | 25 | 103626 | 7353 |
5373 | 5373 | 2020-06-08 | Michigan | 26 | 64911 | 5916 |
5374 | 5374 | 2020-06-08 | Minnesota | 27 | 28235 | 1208 |
5375 | 5375 | 2020-06-08 | Mississippi | 28 | 17768 | 837 |
5376 | 5376 | 2020-06-08 | Missouri | 29 | 15159 | 832 |
5377 | 5377 | 2020-06-08 | Montana | 30 | 548 | 18 |
5378 | 5378 | 2020-06-08 | Nebraska | 31 | 15752 | 196 |
5379 | 5379 | 2020-06-08 | Nevada | 32 | 9815 | 442 |
5380 | 5380 | 2020-06-08 | New Hampshire | 33 | 5079 | 286 |
5381 | 5381 | 2020-06-08 | New Jersey | 34 | 164497 | 12214 |
5382 | 5382 | 2020-06-08 | New Mexico | 35 | 9062 | 400 |
5383 | 5383 | 2020-06-08 | New York | 36 | 383591 | 30239 |
5384 | 5384 | 2020-06-08 | North Carolina | 37 | 36581 | 1041 |
5385 | 5385 | 2020-06-08 | North Dakota | 38 | 2883 | 75 |
5386 | 5386 | 2020-06-08 | Northern Mariana Islands | 69 | 28 | 2 |
5387 | 5387 | 2020-06-08 | Ohio | 39 | 38837 | 2404 |
5388 | 5388 | 2020-06-08 | Oklahoma | 40 | 7206 | 348 |
5389 | 5389 | 2020-06-08 | Oregon | 41 | 4927 | 164 |
5390 | 5390 | 2020-06-08 | Pennsylvania | 42 | 80432 | 6007 |
5391 | 5391 | 2020-06-08 | Puerto Rico | 72 | 5046 | 142 |
5392 | 5392 | 2020-06-08 | Rhode Island | 44 | 15642 | 799 |
5393 | 5393 | 2020-06-08 | South Carolina | 45 | 14800 | 557 |
5394 | 5394 | 2020-06-08 | South Dakota | 46 | 5471 | 65 |
5395 | 5395 | 2020-06-08 | Tennessee | 47 | 27217 | 417 |
5396 | 5396 | 2020-06-08 | Texas | 48 | 77326 | 1856 |
5397 | 5397 | 2020-06-08 | Utah | 49 | 12378 | 124 |
5398 | 5398 | 2020-06-08 | Vermont | 50 | 1075 | 55 |
5399 | 5399 | 2020-06-08 | Virgin Islands | 78 | 71 | 6 |
5400 | 5400 | 2020-06-08 | Virginia | 51 | 51251 | 1477 |
5401 | 5401 | 2020-06-08 | Washington | 53 | 25593 | 1168 |
5402 | 5402 | 2020-06-08 | West Virginia | 54 | 2161 | 84 |
5403 | 5403 | 2020-06-08 | Wisconsin | 55 | 21463 | 650 |
5404 | 5404 | 2020-06-08 | Wyoming | 56 | 960 | 17 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );