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-08-25 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 |
---|---|---|---|---|---|---|
9640 | 9640 | 2020-08-25 | Alabama | 1 | 117242 | 2037 |
9641 | 9641 | 2020-08-25 | Alaska | 2 | 5621 | 33 |
9642 | 9642 | 2020-08-25 | Arizona | 4 | 199293 | 4796 |
9643 | 9643 | 2020-08-25 | Arkansas | 5 | 57374 | 711 |
9644 | 9644 | 2020-08-25 | California | 6 | 682320 | 12409 |
9645 | 9645 | 2020-08-25 | Colorado | 8 | 56176 | 1932 |
9646 | 9646 | 2020-08-25 | Connecticut | 9 | 52040 | 4463 |
9647 | 9647 | 2020-08-25 | Delaware | 10 | 16962 | 603 |
9648 | 9648 | 2020-08-25 | District of Columbia | 11 | 13684 | 604 |
9649 | 9649 | 2020-08-25 | Florida | 12 | 605494 | 10579 |
9650 | 9650 | 2020-08-25 | Georgia | 13 | 241865 | 5147 |
9651 | 9651 | 2020-08-25 | Guam | 66 | 1953 | 8 |
9652 | 9652 | 2020-08-25 | Hawaii | 15 | 6961 | 48 |
9653 | 9653 | 2020-08-25 | Idaho | 16 | 30648 | 328 |
9654 | 9654 | 2020-08-25 | Illinois | 17 | 225812 | 8155 |
9655 | 9655 | 2020-08-25 | Indiana | 18 | 90460 | 3241 |
9656 | 9656 | 2020-08-25 | Iowa | 19 | 57606 | 1059 |
9657 | 9657 | 2020-08-25 | Kansas | 20 | 39089 | 433 |
9658 | 9658 | 2020-08-25 | Kentucky | 21 | 46798 | 918 |
9659 | 9659 | 2020-08-25 | Louisiana | 22 | 144257 | 4797 |
9660 | 9660 | 2020-08-25 | Maine | 23 | 4368 | 131 |
9661 | 9661 | 2020-08-25 | Maryland | 24 | 105554 | 3707 |
9662 | 9662 | 2020-08-25 | Massachusetts | 25 | 126420 | 8961 |
9663 | 9663 | 2020-08-25 | Michigan | 26 | 108742 | 6687 |
9664 | 9664 | 2020-08-25 | Minnesota | 27 | 70753 | 1825 |
9665 | 9665 | 2020-08-25 | Mississippi | 28 | 79206 | 2315 |
9666 | 9666 | 2020-08-25 | Missouri | 29 | 78246 | 1553 |
9667 | 9667 | 2020-08-25 | Montana | 30 | 6649 | 97 |
9668 | 9668 | 2020-08-25 | Nebraska | 31 | 32379 | 386 |
9669 | 9669 | 2020-08-25 | Nevada | 32 | 66515 | 1230 |
9670 | 9670 | 2020-08-25 | New Hampshire | 33 | 7150 | 429 |
9671 | 9671 | 2020-08-25 | New Jersey | 34 | 191850 | 15953 |
9672 | 9672 | 2020-08-25 | New Mexico | 35 | 24535 | 750 |
9673 | 9673 | 2020-08-25 | New York | 36 | 435495 | 32495 |
9674 | 9674 | 2020-08-25 | North Carolina | 37 | 158185 | 2607 |
9675 | 9675 | 2020-08-25 | North Dakota | 38 | 10233 | 142 |
9676 | 9676 | 2020-08-25 | Northern Mariana Islands | 69 | 54 | 2 |
9677 | 9677 | 2020-08-25 | Ohio | 39 | 116495 | 3996 |
9678 | 9678 | 2020-08-25 | Oklahoma | 40 | 54172 | 744 |
9679 | 9679 | 2020-08-25 | Oregon | 41 | 25408 | 436 |
9680 | 9680 | 2020-08-25 | Pennsylvania | 42 | 134803 | 7666 |
9681 | 9681 | 2020-08-25 | Puerto Rico | 72 | 30720 | 395 |
9682 | 9682 | 2020-08-25 | Rhode Island | 44 | 21372 | 1039 |
9683 | 9683 | 2020-08-25 | South Carolina | 45 | 113488 | 2529 |
9684 | 9684 | 2020-08-25 | South Dakota | 46 | 11507 | 161 |
9685 | 9685 | 2020-08-25 | Tennessee | 47 | 142501 | 1605 |
9686 | 9686 | 2020-08-25 | Texas | 48 | 613707 | 12012 |
9687 | 9687 | 2020-08-25 | Utah | 49 | 49870 | 398 |
9688 | 9688 | 2020-08-25 | Vermont | 50 | 1572 | 58 |
9689 | 9689 | 2020-08-25 | Virgin Islands | 78 | 1030 | 14 |
9690 | 9690 | 2020-08-25 | Virginia | 51 | 114635 | 2494 |
9691 | 9691 | 2020-08-25 | Washington | 53 | 74634 | 1962 |
9692 | 9692 | 2020-08-25 | West Virginia | 54 | 9395 | 187 |
9693 | 9693 | 2020-08-25 | Wisconsin | 55 | 76453 | 1106 |
9694 | 9694 | 2020-08-25 | Wyoming | 56 | 3634 | 37 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );