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-19 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 |
---|---|---|---|---|---|---|
12665 | 12665 | 2020-10-19 | Alabama | 1 | 173485 | 2789 |
12666 | 12666 | 2020-10-19 | Alaska | 2 | 12138 | 63 |
12667 | 12667 | 2020-10-19 | Arizona | 4 | 231933 | 5830 |
12668 | 12668 | 2020-10-19 | Arkansas | 5 | 99597 | 1714 |
12669 | 12669 | 2020-10-19 | California | 6 | 882666 | 16987 |
12670 | 12670 | 2020-10-19 | Colorado | 8 | 86727 | 2207 |
12671 | 12671 | 2020-10-19 | Connecticut | 9 | 64021 | 4554 |
12672 | 12672 | 2020-10-19 | Delaware | 10 | 23196 | 666 |
12673 | 12673 | 2020-10-19 | District of Columbia | 11 | 16395 | 641 |
12674 | 12674 | 2020-10-19 | Florida | 12 | 756719 | 16020 |
12675 | 12675 | 2020-10-19 | Georgia | 13 | 350654 | 7479 |
12676 | 12676 | 2020-10-19 | Guam | 66 | 4725 | 67 |
12677 | 12677 | 2020-10-19 | Hawaii | 15 | 14218 | 186 |
12678 | 12678 | 2020-10-19 | Idaho | 16 | 54123 | 535 |
12679 | 12679 | 2020-10-19 | Illinois | 17 | 352449 | 9520 |
12680 | 12680 | 2020-10-19 | Indiana | 18 | 151588 | 3960 |
12681 | 12681 | 2020-10-19 | Iowa | 19 | 108114 | 1548 |
12682 | 12682 | 2020-10-19 | Kansas | 20 | 74616 | 872 |
12683 | 12683 | 2020-10-19 | Kentucky | 21 | 90443 | 1381 |
12684 | 12684 | 2020-10-19 | Louisiana | 22 | 179070 | 5766 |
12685 | 12685 | 2020-10-19 | Maine | 23 | 5962 | 146 |
12686 | 12686 | 2020-10-19 | Maryland | 24 | 136643 | 4041 |
12687 | 12687 | 2020-10-19 | Massachusetts | 25 | 144488 | 9753 |
12688 | 12688 | 2020-10-19 | Michigan | 26 | 164055 | 7364 |
12689 | 12689 | 2020-10-19 | Minnesota | 27 | 124492 | 2292 |
12690 | 12690 | 2020-10-19 | Mississippi | 28 | 110592 | 3171 |
12691 | 12691 | 2020-10-19 | Missouri | 29 | 164249 | 2660 |
12692 | 12692 | 2020-10-19 | Montana | 30 | 23503 | 242 |
12693 | 12693 | 2020-10-19 | Nebraska | 31 | 58817 | 568 |
12694 | 12694 | 2020-10-19 | Nevada | 32 | 90978 | 1714 |
12695 | 12695 | 2020-10-19 | New Hampshire | 33 | 9746 | 468 |
12696 | 12696 | 2020-10-19 | New Jersey | 34 | 222994 | 16214 |
12697 | 12697 | 2020-10-19 | New Mexico | 35 | 37302 | 935 |
12698 | 12698 | 2020-10-19 | New York | 36 | 490015 | 32990 |
12699 | 12699 | 2020-10-19 | North Carolina | 37 | 247551 | 3969 |
12700 | 12700 | 2020-10-19 | North Dakota | 38 | 32642 | 413 |
12701 | 12701 | 2020-10-19 | Northern Mariana Islands | 69 | 86 | 2 |
12702 | 12702 | 2020-10-19 | Ohio | 39 | 183624 | 5075 |
12703 | 12703 | 2020-10-19 | Oklahoma | 40 | 108073 | 1173 |
12704 | 12704 | 2020-10-19 | Oregon | 41 | 39799 | 630 |
12705 | 12705 | 2020-10-19 | Pennsylvania | 42 | 188442 | 8562 |
12706 | 12706 | 2020-10-19 | Puerto Rico | 72 | 57950 | 768 |
12707 | 12707 | 2020-10-19 | Rhode Island | 44 | 28347 | 1159 |
12708 | 12708 | 2020-10-19 | South Carolina | 45 | 164609 | 3661 |
12709 | 12709 | 2020-10-19 | South Dakota | 46 | 33836 | 323 |
12710 | 12710 | 2020-10-19 | Tennessee | 47 | 228267 | 2896 |
12711 | 12711 | 2020-10-19 | Texas | 48 | 874080 | 17564 |
12712 | 12712 | 2020-10-19 | Utah | 49 | 95572 | 547 |
12713 | 12713 | 2020-10-19 | Vermont | 50 | 1946 | 58 |
12714 | 12714 | 2020-10-19 | Virgin Islands | 78 | 1335 | 21 |
12715 | 12715 | 2020-10-19 | Virginia | 51 | 166828 | 3457 |
12716 | 12716 | 2020-10-19 | Washington | 53 | 103323 | 2357 |
12717 | 12717 | 2020-10-19 | West Virginia | 54 | 20293 | 399 |
12718 | 12718 | 2020-10-19 | Wisconsin | 55 | 183177 | 1624 |
12719 | 12719 | 2020-10-19 | Wyoming | 56 | 9311 | 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 );