us-states

Table actions

Data source: Big Local News · About: big-local-datasette

55 rows where "date" is on date 2020-04-20

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

date (date) ✖

  • 2020-04-20 · 55 ✖
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

CSV options: 

CREATE TABLE [us-states] (
   [date] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);