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-04-20 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 |
---|---|---|---|---|---|---|
2655 | 2655 | 2020-04-20 | Alabama | 1 | 5078 | 164 |
2656 | 2656 | 2020-04-20 | Alaska | 2 | 319 | 7 |
2657 | 2657 | 2020-04-20 | Arizona | 4 | 5064 | 191 |
2658 | 2658 | 2020-04-20 | Arkansas | 5 | 1971 | 42 |
2659 | 2659 | 2020-04-20 | California | 6 | 33862 | 1223 |
2660 | 2660 | 2020-04-20 | Colorado | 8 | 10106 | 448 |
2661 | 2661 | 2020-04-20 | Connecticut | 9 | 19815 | 1331 |
2662 | 2662 | 2020-04-20 | Delaware | 10 | 2745 | 72 |
2663 | 2663 | 2020-04-20 | District of Columbia | 11 | 2927 | 105 |
2664 | 2664 | 2020-04-20 | Florida | 12 | 27050 | 822 |
2665 | 2665 | 2020-04-20 | Georgia | 13 | 18447 | 767 |
2666 | 2666 | 2020-04-20 | Guam | 66 | 811 | 6 |
2667 | 2667 | 2020-04-20 | Hawaii | 15 | 578 | 10 |
2668 | 2668 | 2020-04-20 | Idaho | 16 | 1736 | 48 |
2669 | 2669 | 2020-04-20 | Illinois | 17 | 31508 | 1359 |
2670 | 2670 | 2020-04-20 | Indiana | 18 | 11784 | 666 |
2671 | 2671 | 2020-04-20 | Iowa | 19 | 3175 | 79 |
2672 | 2672 | 2020-04-20 | Kansas | 20 | 2030 | 101 |
2673 | 2673 | 2020-04-20 | Kentucky | 21 | 3050 | 155 |
2674 | 2674 | 2020-04-20 | Louisiana | 22 | 24523 | 1328 |
2675 | 2675 | 2020-04-20 | Maine | 23 | 875 | 35 |
2676 | 2676 | 2020-04-20 | Maryland | 24 | 13750 | 582 |
2677 | 2677 | 2020-04-20 | Massachusetts | 25 | 39643 | 1809 |
2678 | 2678 | 2020-04-20 | Michigan | 26 | 31929 | 2466 |
2679 | 2679 | 2020-04-20 | Minnesota | 27 | 2470 | 143 |
2680 | 2680 | 2020-04-20 | Mississippi | 28 | 4512 | 169 |
2681 | 2681 | 2020-04-20 | Missouri | 29 | 5807 | 201 |
2682 | 2682 | 2020-04-20 | Montana | 30 | 433 | 12 |
2683 | 2683 | 2020-04-20 | Nebraska | 31 | 1646 | 33 |
2684 | 2684 | 2020-04-20 | Nevada | 32 | 3830 | 163 |
2685 | 2685 | 2020-04-20 | New Hampshire | 33 | 1447 | 42 |
2686 | 2686 | 2020-04-20 | New Jersey | 34 | 88806 | 4377 |
2687 | 2687 | 2020-04-20 | New Mexico | 35 | 1971 | 58 |
2688 | 2688 | 2020-04-20 | New York | 36 | 251608 | 18412 |
2689 | 2689 | 2020-04-20 | North Carolina | 37 | 6764 | 187 |
2690 | 2690 | 2020-04-20 | North Dakota | 38 | 627 | 13 |
2691 | 2691 | 2020-04-20 | Northern Mariana Islands | 69 | 14 | 2 |
2692 | 2692 | 2020-04-20 | Ohio | 39 | 12919 | 509 |
2693 | 2693 | 2020-04-20 | Oklahoma | 40 | 2680 | 143 |
2694 | 2694 | 2020-04-20 | Oregon | 41 | 1956 | 75 |
2695 | 2695 | 2020-04-20 | Pennsylvania | 42 | 34005 | 1366 |
2696 | 2696 | 2020-04-20 | Puerto Rico | 72 | 1252 | 42 |
2697 | 2697 | 2020-04-20 | Rhode Island | 44 | 5090 | 155 |
2698 | 2698 | 2020-04-20 | South Carolina | 45 | 4439 | 124 |
2699 | 2699 | 2020-04-20 | South Dakota | 46 | 1685 | 7 |
2700 | 2700 | 2020-04-20 | Tennessee | 47 | 6994 | 156 |
2701 | 2701 | 2020-04-20 | Texas | 48 | 20035 | 523 |
2702 | 2702 | 2020-04-20 | Utah | 49 | 3213 | 28 |
2703 | 2703 | 2020-04-20 | Vermont | 50 | 816 | 37 |
2704 | 2704 | 2020-04-20 | Virgin Islands | 78 | 54 | 3 |
2705 | 2705 | 2020-04-20 | Virginia | 51 | 8989 | 300 |
2706 | 2706 | 2020-04-20 | Washington | 53 | 12255 | 661 |
2707 | 2707 | 2020-04-20 | West Virginia | 54 | 908 | 26 |
2708 | 2708 | 2020-04-20 | Wisconsin | 55 | 4564 | 231 |
2709 | 2709 | 2020-04-20 | Wyoming | 56 | 426 | 2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );