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-20 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 |
---|---|---|---|---|---|---|
12720 | 12720 | 2020-10-20 | Alabama | 1 | 174528 | 2805 |
12721 | 12721 | 2020-10-20 | Alaska | 2 | 12349 | 63 |
12722 | 12722 | 2020-10-20 | Arizona | 4 | 232939 | 5837 |
12723 | 12723 | 2020-10-20 | Arkansas | 5 | 100441 | 1728 |
12724 | 12724 | 2020-10-20 | California | 6 | 887094 | 17067 |
12725 | 12725 | 2020-10-20 | Colorado | 8 | 87966 | 2212 |
12726 | 12726 | 2020-10-20 | Connecticut | 9 | 64455 | 4559 |
12727 | 12727 | 2020-10-20 | Delaware | 10 | 23325 | 668 |
12728 | 12728 | 2020-10-20 | District of Columbia | 11 | 16445 | 642 |
12729 | 12729 | 2020-10-20 | Florida | 12 | 760381 | 16104 |
12730 | 12730 | 2020-10-20 | Georgia | 13 | 351990 | 7494 |
12731 | 12731 | 2020-10-20 | Guam | 66 | 4855 | 67 |
12732 | 12732 | 2020-10-20 | Hawaii | 15 | 14302 | 188 |
12733 | 12733 | 2020-10-20 | Idaho | 16 | 55153 | 541 |
12734 | 12734 | 2020-10-20 | Illinois | 17 | 356151 | 9562 |
12735 | 12735 | 2020-10-20 | Indiana | 18 | 153088 | 4008 |
12736 | 12736 | 2020-10-20 | Iowa | 19 | 109210 | 1576 |
12737 | 12737 | 2020-10-20 | Kansas | 20 | 74883 | 902 |
12738 | 12738 | 2020-10-20 | Kentucky | 21 | 91731 | 1403 |
12739 | 12739 | 2020-10-20 | Louisiana | 22 | 179769 | 5772 |
12740 | 12740 | 2020-10-20 | Maine | 23 | 5989 | 146 |
12741 | 12741 | 2020-10-20 | Maryland | 24 | 137229 | 4050 |
12742 | 12742 | 2020-10-20 | Massachusetts | 25 | 145464 | 9758 |
12743 | 12743 | 2020-10-20 | Michigan | 26 | 165949 | 7386 |
12744 | 12744 | 2020-10-20 | Minnesota | 27 | 125584 | 2299 |
12745 | 12745 | 2020-10-20 | Mississippi | 28 | 111322 | 3202 |
12746 | 12746 | 2020-10-20 | Missouri | 29 | 164891 | 2668 |
12747 | 12747 | 2020-10-20 | Montana | 30 | 24201 | 252 |
12748 | 12748 | 2020-10-20 | Nebraska | 31 | 59409 | 575 |
12749 | 12749 | 2020-10-20 | Nevada | 32 | 91679 | 1728 |
12750 | 12750 | 2020-10-20 | New Hampshire | 33 | 9828 | 468 |
12751 | 12751 | 2020-10-20 | New Jersey | 34 | 223982 | 16227 |
12752 | 12752 | 2020-10-20 | New Mexico | 35 | 37896 | 942 |
12753 | 12753 | 2020-10-20 | New York | 36 | 491216 | 32998 |
12754 | 12754 | 2020-10-20 | North Carolina | 37 | 249158 | 4018 |
12755 | 12755 | 2020-10-20 | North Dakota | 38 | 33671 | 417 |
12756 | 12756 | 2020-10-20 | Northern Mariana Islands | 69 | 88 | 2 |
12757 | 12757 | 2020-10-20 | Ohio | 39 | 185639 | 5083 |
12758 | 12758 | 2020-10-20 | Oklahoma | 40 | 109548 | 1191 |
12759 | 12759 | 2020-10-20 | Oregon | 41 | 40149 | 636 |
12760 | 12760 | 2020-10-20 | Pennsylvania | 42 | 189988 | 8591 |
12761 | 12761 | 2020-10-20 | Puerto Rico | 72 | 58643 | 769 |
12762 | 12762 | 2020-10-20 | Rhode Island | 44 | 28649 | 1164 |
12763 | 12763 | 2020-10-20 | South Carolina | 45 | 165493 | 3696 |
12764 | 12764 | 2020-10-20 | South Dakota | 46 | 34457 | 330 |
12765 | 12765 | 2020-10-20 | Tennessee | 47 | 229794 | 2924 |
12766 | 12766 | 2020-10-20 | Texas | 48 | 879949 | 17644 |
12767 | 12767 | 2020-10-20 | Utah | 49 | 96643 | 552 |
12768 | 12768 | 2020-10-20 | Vermont | 50 | 1956 | 58 |
12769 | 12769 | 2020-10-20 | Virgin Islands | 78 | 1337 | 21 |
12770 | 12770 | 2020-10-20 | Virginia | 51 | 167754 | 3485 |
12771 | 12771 | 2020-10-20 | Washington | 53 | 103845 | 2380 |
12772 | 12772 | 2020-10-20 | West Virginia | 54 | 20519 | 408 |
12773 | 12773 | 2020-10-20 | Wisconsin | 55 | 187898 | 1660 |
12774 | 12774 | 2020-10-20 | Wyoming | 56 | 9526 | 61 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );