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-11-07 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 |
---|---|---|---|---|---|---|
13710 | 13710 | 2020-11-07 | Alabama | 1 | 202482 | 3082 |
13711 | 13711 | 2020-11-07 | Alaska | 2 | 19194 | 79 |
13712 | 13712 | 2020-11-07 | Arizona | 4 | 257384 | 6147 |
13713 | 13713 | 2020-11-07 | Arkansas | 5 | 120828 | 2068 |
13714 | 13714 | 2020-11-07 | California | 6 | 972821 | 17964 |
13715 | 13715 | 2020-11-07 | Colorado | 8 | 128611 | 2417 |
13716 | 13716 | 2020-11-07 | Connecticut | 9 | 78125 | 4671 |
13717 | 13717 | 2020-11-07 | Delaware | 10 | 26258 | 716 |
13718 | 13718 | 2020-11-07 | District of Columbia | 11 | 17891 | 654 |
13719 | 13719 | 2020-11-07 | Florida | 12 | 837069 | 17099 |
13720 | 13720 | 2020-11-07 | Georgia | 13 | 389257 | 8427 |
13721 | 13721 | 2020-11-07 | Guam | 66 | 6046 | 89 |
13722 | 13722 | 2020-11-07 | Hawaii | 15 | 15939 | 219 |
13723 | 13723 | 2020-11-07 | Idaho | 16 | 72528 | 685 |
13724 | 13724 | 2020-11-07 | Illinois | 17 | 479061 | 10498 |
13725 | 13725 | 2020-11-07 | Indiana | 18 | 208243 | 4592 |
13726 | 13726 | 2020-11-07 | Iowa | 19 | 150639 | 1842 |
13727 | 13727 | 2020-11-07 | Kansas | 20 | 99671 | 1166 |
13728 | 13728 | 2020-11-07 | Kentucky | 21 | 122021 | 1640 |
13729 | 13729 | 2020-11-07 | Louisiana | 22 | 191715 | 6016 |
13730 | 13730 | 2020-11-07 | Maine | 23 | 7603 | 152 |
13731 | 13731 | 2020-11-07 | Maryland | 24 | 153198 | 4201 |
13732 | 13732 | 2020-11-07 | Massachusetts | 25 | 169576 | 10146 |
13733 | 13733 | 2020-11-07 | Michigan | 26 | 228706 | 7943 |
13734 | 13734 | 2020-11-07 | Minnesota | 27 | 175008 | 2679 |
13735 | 13735 | 2020-11-07 | Mississippi | 28 | 125885 | 3433 |
13736 | 13736 | 2020-11-07 | Missouri | 29 | 213645 | 3235 |
13737 | 13737 | 2020-11-07 | Montana | 30 | 38948 | 445 |
13738 | 13738 | 2020-11-07 | Nebraska | 31 | 82395 | 715 |
13739 | 13739 | 2020-11-07 | Nevada | 32 | 109326 | 1851 |
13740 | 13740 | 2020-11-07 | New Hampshire | 33 | 12241 | 489 |
13741 | 13741 | 2020-11-07 | New Jersey | 34 | 254382 | 16425 |
13742 | 13742 | 2020-11-07 | New Mexico | 35 | 53671 | 1104 |
13743 | 13743 | 2020-11-07 | New York | 36 | 530354 | 33287 |
13744 | 13744 | 2020-11-07 | North Carolina | 37 | 291563 | 4629 |
13745 | 13745 | 2020-11-07 | North Dakota | 38 | 53209 | 633 |
13746 | 13746 | 2020-11-07 | Northern Mariana Islands | 69 | 98 | 2 |
13747 | 13747 | 2020-11-07 | Ohio | 39 | 245727 | 5506 |
13748 | 13748 | 2020-11-07 | Oklahoma | 40 | 136258 | 1438 |
13749 | 13749 | 2020-11-07 | Oregon | 41 | 49587 | 729 |
13750 | 13750 | 2020-11-07 | Pennsylvania | 42 | 232582 | 9089 |
13751 | 13751 | 2020-11-07 | Puerto Rico | 72 | 71532 | 862 |
13752 | 13752 | 2020-11-07 | Rhode Island | 44 | 36380 | 1224 |
13753 | 13753 | 2020-11-07 | South Carolina | 45 | 184742 | 4015 |
13754 | 13754 | 2020-11-07 | South Dakota | 46 | 53976 | 523 |
13755 | 13755 | 2020-11-07 | Tennessee | 47 | 273603 | 3556 |
13756 | 13756 | 2020-11-07 | Texas | 48 | 1009837 | 19219 |
13757 | 13757 | 2020-11-07 | Utah | 49 | 130238 | 658 |
13758 | 13758 | 2020-11-07 | Vermont | 50 | 2347 | 59 |
13759 | 13759 | 2020-11-07 | Virgin Islands | 78 | 1405 | 23 |
13760 | 13760 | 2020-11-07 | Virginia | 51 | 190873 | 3704 |
13761 | 13761 | 2020-11-07 | Washington | 53 | 121220 | 2552 |
13762 | 13762 | 2020-11-07 | West Virginia | 54 | 27742 | 502 |
13763 | 13763 | 2020-11-07 | Wisconsin | 55 | 277568 | 2385 |
13764 | 13764 | 2020-11-07 | Wyoming | 56 | 16597 | 105 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );