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-10-14 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 55
- 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
- New Hampshire 1
- New Jersey 1
- New Mexico 1
- New York 1
- North Carolina 1
- North Dakota 1
- Northern Mariana Islands 1
- Ohio 1
- Oklahoma 1
- Oregon 1
- Pennsylvania 1
- Puerto Rico 1
- Rhode Island 1
- South Carolina 1
- South Dakota 1
- Tennessee 1
- Texas 1
- Utah 1
- Vermont 1
- Virgin Islands 1
- Virginia 1
- Washington 1
- West Virginia 1
- Wisconsin 1
- Wyoming 1
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
12390 | 12390 | 2020-10-14 | Alabama | 1 | 167977 | 2706 |
12391 | 12391 | 2020-10-14 | Alaska | 2 | 11103 | 60 |
12392 | 12392 | 2020-10-14 | Arizona | 4 | 227660 | 5772 |
12393 | 12393 | 2020-10-14 | Arkansas | 5 | 95246 | 1634 |
12394 | 12394 | 2020-10-14 | California | 6 | 867094 | 16752 |
12395 | 12395 | 2020-10-14 | Colorado | 8 | 81205 | 2186 |
12396 | 12396 | 2020-10-14 | Connecticut | 9 | 61861 | 4537 |
12397 | 12397 | 2020-10-14 | Delaware | 10 | 22465 | 660 |
12398 | 12398 | 2020-10-14 | District of Columbia | 11 | 16132 | 638 |
12399 | 12399 | 2020-10-14 | Florida | 12 | 741624 | 15594 |
12400 | 12400 | 2020-10-14 | Georgia | 13 | 342302 | 7298 |
12401 | 12401 | 2020-10-14 | Guam | 66 | 4310 | 62 |
12402 | 12402 | 2020-10-14 | Hawaii | 15 | 13834 | 182 |
12403 | 12403 | 2020-10-14 | Idaho | 16 | 50534 | 520 |
12404 | 12404 | 2020-10-14 | Illinois | 17 | 332124 | 9335 |
12405 | 12405 | 2020-10-14 | Indiana | 18 | 141670 | 3836 |
12406 | 12406 | 2020-10-14 | Iowa | 19 | 102905 | 1505 |
12407 | 12407 | 2020-10-14 | Kansas | 20 | 70665 | 838 |
12408 | 12408 | 2020-10-14 | Kentucky | 21 | 85278 | 1325 |
12409 | 12409 | 2020-10-14 | Louisiana | 22 | 176209 | 5695 |
12410 | 12410 | 2020-10-14 | Maine | 23 | 5816 | 143 |
12411 | 12411 | 2020-10-14 | Maryland | 24 | 133413 | 4022 |
12412 | 12412 | 2020-10-14 | Massachusetts | 25 | 140992 | 9647 |
12413 | 12413 | 2020-10-14 | Michigan | 26 | 154409 | 7270 |
12414 | 12414 | 2020-10-14 | Minnesota | 27 | 115996 | 2233 |
12415 | 12415 | 2020-10-14 | Mississippi | 28 | 106817 | 3140 |
12416 | 12416 | 2020-10-14 | Missouri | 29 | 154213 | 2598 |
12417 | 12417 | 2020-10-14 | Montana | 30 | 20321 | 225 |
12418 | 12418 | 2020-10-14 | Nebraska | 31 | 54467 | 536 |
12419 | 12419 | 2020-10-14 | Nevada | 32 | 87527 | 1694 |
12420 | 12420 | 2020-10-14 | New Hampshire | 33 | 9349 | 458 |
12421 | 12421 | 2020-10-14 | New Jersey | 34 | 217812 | 16191 |
12422 | 12422 | 2020-10-14 | New Mexico | 35 | 34290 | 921 |
12423 | 12423 | 2020-10-14 | New York | 36 | 482671 | 32916 |
12424 | 12424 | 2020-10-14 | North Carolina | 37 | 236812 | 3882 |
12425 | 12425 | 2020-10-14 | North Dakota | 38 | 28952 | 370 |
12426 | 12426 | 2020-10-14 | Northern Mariana Islands | 69 | 77 | 2 |
12427 | 12427 | 2020-10-14 | Ohio | 39 | 173665 | 5033 |
12428 | 12428 | 2020-10-14 | Oklahoma | 40 | 102615 | 1132 |
12429 | 12429 | 2020-10-14 | Oregon | 41 | 38175 | 609 |
12430 | 12430 | 2020-10-14 | Pennsylvania | 42 | 180956 | 8481 |
12431 | 12431 | 2020-10-14 | Puerto Rico | 72 | 55516 | 742 |
12432 | 12432 | 2020-10-14 | Rhode Island | 44 | 27164 | 1147 |
12433 | 12433 | 2020-10-14 | South Carolina | 45 | 159809 | 3593 |
12434 | 12434 | 2020-10-14 | South Dakota | 46 | 30215 | 291 |
12435 | 12435 | 2020-10-14 | Tennessee | 47 | 217140 | 2801 |
12436 | 12436 | 2020-10-14 | Texas | 48 | 848168 | 17276 |
12437 | 12437 | 2020-10-14 | Utah | 49 | 89018 | 529 |
12438 | 12438 | 2020-10-14 | Vermont | 50 | 1889 | 58 |
12439 | 12439 | 2020-10-14 | Virgin Islands | 78 | 1328 | 20 |
12440 | 12440 | 2020-10-14 | Virginia | 51 | 161610 | 3381 |
12441 | 12441 | 2020-10-14 | Washington | 53 | 100068 | 2319 |
12442 | 12442 | 2020-10-14 | West Virginia | 54 | 18818 | 391 |
12443 | 12443 | 2020-10-14 | Wisconsin | 55 | 167441 | 1549 |
12444 | 12444 | 2020-10-14 | Wyoming | 56 | 8177 | 57 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );