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-03-06 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 |
---|---|---|---|---|---|---|
20255 | 20255 | 2021-03-06 | Alabama | 1 | 499411 | 10149 |
20256 | 20256 | 2021-03-06 | Alaska | 2 | 58870 | 292 |
20257 | 20257 | 2021-03-06 | Arizona | 4 | 825119 | 16323 |
20258 | 20258 | 2021-03-06 | Arkansas | 5 | 324653 | 5297 |
20259 | 20259 | 2021-03-06 | California | 6 | 3597075 | 54124 |
20260 | 20260 | 2021-03-06 | Colorado | 8 | 437650 | 6075 |
20261 | 20261 | 2021-03-06 | Connecticut | 9 | 285330 | 7704 |
20262 | 20262 | 2021-03-06 | Delaware | 10 | 88139 | 1464 |
20263 | 20263 | 2021-03-06 | District of Columbia | 11 | 41273 | 1030 |
20264 | 20264 | 2021-03-06 | Florida | 12 | 1940889 | 31619 |
20265 | 20265 | 2021-03-06 | Georgia | 13 | 996616 | 17347 |
20266 | 20266 | 2021-03-06 | Guam | 66 | 8718 | 134 |
20267 | 20267 | 2021-03-06 | Hawaii | 15 | 27774 | 441 |
20268 | 20268 | 2021-03-06 | Idaho | 16 | 173011 | 1882 |
20269 | 20269 | 2021-03-06 | Illinois | 17 | 1200720 | 23002 |
20270 | 20270 | 2021-03-06 | Indiana | 18 | 669754 | 12726 |
20271 | 20271 | 2021-03-06 | Iowa | 19 | 339511 | 5553 |
20272 | 20272 | 2021-03-06 | Kansas | 20 | 298900 | 4812 |
20273 | 20273 | 2021-03-06 | Kentucky | 21 | 413684 | 4952 |
20274 | 20274 | 2021-03-06 | Louisiana | 22 | 433045 | 9716 |
20275 | 20275 | 2021-03-06 | Maine | 23 | 45635 | 704 |
20276 | 20276 | 2021-03-06 | Maryland | 24 | 386792 | 7941 |
20277 | 20277 | 2021-03-06 | Massachusetts | 25 | 589931 | 16374 |
20278 | 20278 | 2021-03-06 | Michigan | 26 | 655016 | 16647 |
20279 | 20279 | 2021-03-06 | Minnesota | 27 | 489184 | 6614 |
20280 | 20280 | 2021-03-06 | Mississippi | 28 | 297321 | 6805 |
20281 | 20281 | 2021-03-06 | Missouri | 29 | 527836 | 8606 |
20282 | 20282 | 2021-03-06 | Montana | 30 | 100925 | 1382 |
20283 | 20283 | 2021-03-06 | Nebraska | 31 | 203084 | 2223 |
20284 | 20284 | 2021-03-06 | Nevada | 32 | 296030 | 5036 |
20285 | 20285 | 2021-03-06 | New Hampshire | 33 | 76695 | 1181 |
20286 | 20286 | 2021-03-06 | New Jersey | 34 | 810089 | 23557 |
20287 | 20287 | 2021-03-06 | New Mexico | 35 | 186742 | 3798 |
20288 | 20288 | 2021-03-06 | New York | 36 | 1687250 | 47767 |
20289 | 20289 | 2021-03-06 | North Carolina | 37 | 873169 | 11520 |
20290 | 20290 | 2021-03-06 | North Dakota | 38 | 100387 | 1479 |
20291 | 20291 | 2021-03-06 | Northern Mariana Islands | 69 | 144 | 2 |
20292 | 20292 | 2021-03-06 | Ohio | 39 | 977738 | 17502 |
20293 | 20293 | 2021-03-06 | Oklahoma | 40 | 428536 | 4534 |
20294 | 20294 | 2021-03-06 | Oregon | 41 | 157163 | 2303 |
20295 | 20295 | 2021-03-06 | Pennsylvania | 42 | 951703 | 24362 |
20296 | 20296 | 2021-03-06 | Puerto Rico | 72 | 134942 | 2059 |
20297 | 20297 | 2021-03-06 | Rhode Island | 44 | 128121 | 2541 |
20298 | 20298 | 2021-03-06 | South Carolina | 45 | 524457 | 8719 |
20299 | 20299 | 2021-03-06 | South Dakota | 46 | 113378 | 1898 |
20300 | 20300 | 2021-03-06 | Tennessee | 47 | 768139 | 11447 |
20301 | 20301 | 2021-03-06 | Texas | 48 | 2689785 | 45381 |
20302 | 20302 | 2021-03-06 | Utah | 49 | 374494 | 1975 |
20303 | 20303 | 2021-03-06 | Vermont | 50 | 15964 | 208 |
20304 | 20304 | 2021-03-06 | Virgin Islands | 78 | 2714 | 25 |
20305 | 20305 | 2021-03-06 | Virginia | 51 | 584537 | 9519 |
20306 | 20306 | 2021-03-06 | Washington | 53 | 347301 | 5107 |
20307 | 20307 | 2021-03-06 | West Virginia | 54 | 133290 | 2323 |
20308 | 20308 | 2021-03-06 | Wisconsin | 55 | 621277 | 7107 |
20309 | 20309 | 2021-03-06 | Wyoming | 56 | 54764 | 682 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );