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

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

View and edit SQL

date (date)

  • 2020-04-22 · 55
Link rowid ▼ date state fips cases deaths
2765 2020-04-22 Alabama 1 5610 201
2766 2020-04-22 Alaska 2 333 7
2767 2020-04-22 Arizona 4 5459 236
2768 2020-04-22 Arkansas 5 2392 44
2769 2020-04-22 California 6 37573 1425
2770 2020-04-22 Colorado 8 10878 526
2771 2020-04-22 Connecticut 9 22469 1544
2772 2020-04-22 Delaware 10 3200 89
2773 2020-04-22 District of Columbia 11 3206 127
2774 2020-04-22 Florida 12 28301 926
2775 2020-04-22 Georgia 13 20099 837
2776 2020-04-22 Guam 66 911 6
2777 2020-04-22 Hawaii 15 586 12
2778 2020-04-22 Idaho 16 1802 54
2779 2020-04-22 Illinois 17 35108 1577
2780 2020-04-22 Indiana 18 12575 764
2781 2020-04-22 Iowa 19 3764 90
2782 2020-04-22 Kansas 20 2291 111
2783 2020-04-22 Kentucky 21 3373 185
2784 2020-04-22 Louisiana 22 25317 1532
2785 2020-04-22 Maine 23 907 39
2786 2020-04-22 Maryland 24 14842 698
2787 2020-04-22 Massachusetts 25 42944 2182
2788 2020-04-22 Michigan 26 33973 2813
2789 2020-04-22 Minnesota 27 2721 179
2790 2020-04-22 Mississippi 28 4894 193
2791 2020-04-22 Missouri 29 6137 236
2792 2020-04-22 Montana 30 439 14
2793 2020-04-22 Nebraska 31 1826 42
2794 2020-04-22 Nevada 32 4081 187
2795 2020-04-22 New Hampshire 33 1588 48
2796 2020-04-22 New Jersey 34 95865 5063
2797 2020-04-22 New Mexico 35 2210 71
2798 2020-04-22 New York 36 261591 19647
2799 2020-04-22 North Carolina 37 7220 242
2800 2020-04-22 North Dakota 38 679 14
2801 2020-04-22 Northern Mariana Islands 69 14 2
2802 2020-04-22 Ohio 39 14117 610
2803 2020-04-22 Oklahoma 40 2894 169
2804 2020-04-22 Oregon 41 2059 78
2805 2020-04-22 Pennsylvania 42 36763 1720
2806 2020-04-22 Puerto Rico 72 915 46
2807 2020-04-22 Rhode Island 44 5841 181
2808 2020-04-22 South Carolina 45 4761 140
2809 2020-04-22 South Dakota 46 1858 9
2810 2020-04-22 Tennessee 47 7681 169
2811 2020-04-22 Texas 48 21769 571
2812 2020-04-22 Utah 49 3451 34
2813 2020-04-22 Vermont 50 823 39
2814 2020-04-22 Virgin Islands 78 54 3
2815 2020-04-22 Virginia 51 10265 349
2816 2020-04-22 Washington 53 12606 696
2817 2020-04-22 West Virginia 54 939 29
2818 2020-04-22 Wisconsin 55 4915 247
2819 2020-04-22 Wyoming 56 447 6

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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