ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where "date" is on date 2020-03-18 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 |
---|---|---|---|---|---|---|
850 | 850 | 2020-03-18 | Alabama | 1 | 51 | 0 |
851 | 851 | 2020-03-18 | Alaska | 2 | 9 | 0 |
852 | 852 | 2020-03-18 | Arizona | 4 | 28 | 0 |
853 | 853 | 2020-03-18 | Arkansas | 5 | 33 | 0 |
854 | 854 | 2020-03-18 | California | 6 | 893 | 17 |
855 | 855 | 2020-03-18 | Colorado | 8 | 216 | 3 |
856 | 856 | 2020-03-18 | Connecticut | 9 | 96 | 1 |
857 | 857 | 2020-03-18 | Delaware | 10 | 26 | 0 |
858 | 858 | 2020-03-18 | District of Columbia | 11 | 36 | 0 |
859 | 859 | 2020-03-18 | Florida | 12 | 326 | 7 |
860 | 860 | 2020-03-18 | Georgia | 13 | 193 | 3 |
861 | 861 | 2020-03-18 | Guam | 66 | 8 | 0 |
862 | 862 | 2020-03-18 | Hawaii | 15 | 16 | 0 |
863 | 863 | 2020-03-18 | Idaho | 16 | 11 | 0 |
864 | 864 | 2020-03-18 | Illinois | 17 | 286 | 1 |
865 | 865 | 2020-03-18 | Indiana | 18 | 39 | 2 |
866 | 866 | 2020-03-18 | Iowa | 19 | 38 | 0 |
867 | 867 | 2020-03-18 | Kansas | 20 | 22 | 1 |
868 | 868 | 2020-03-18 | Kentucky | 21 | 35 | 1 |
869 | 869 | 2020-03-18 | Louisiana | 22 | 280 | 7 |
870 | 870 | 2020-03-18 | Maine | 23 | 43 | 0 |
871 | 871 | 2020-03-18 | Maryland | 24 | 85 | 1 |
872 | 872 | 2020-03-18 | Massachusetts | 25 | 256 | 0 |
873 | 873 | 2020-03-18 | Michigan | 26 | 80 | 1 |
874 | 874 | 2020-03-18 | Minnesota | 27 | 77 | 0 |
875 | 875 | 2020-03-18 | Mississippi | 28 | 34 | 0 |
876 | 876 | 2020-03-18 | Missouri | 29 | 21 | 1 |
877 | 877 | 2020-03-18 | Montana | 30 | 12 | 0 |
878 | 878 | 2020-03-18 | Nebraska | 31 | 43 | 0 |
879 | 879 | 2020-03-18 | Nevada | 32 | 82 | 1 |
880 | 880 | 2020-03-18 | New Hampshire | 33 | 39 | 0 |
881 | 881 | 2020-03-18 | New Jersey | 34 | 427 | 5 |
882 | 882 | 2020-03-18 | New Mexico | 35 | 28 | 0 |
883 | 883 | 2020-03-18 | New York | 36 | 2387 | 32 |
884 | 884 | 2020-03-18 | North Carolina | 37 | 66 | 0 |
885 | 885 | 2020-03-18 | North Dakota | 38 | 7 | 0 |
886 | 886 | 2020-03-18 | Ohio | 39 | 90 | 0 |
887 | 887 | 2020-03-18 | Oklahoma | 40 | 29 | 0 |
888 | 888 | 2020-03-18 | Oregon | 41 | 74 | 3 |
889 | 889 | 2020-03-18 | Pennsylvania | 42 | 139 | 1 |
890 | 890 | 2020-03-18 | Puerto Rico | 72 | 5 | 0 |
891 | 891 | 2020-03-18 | Rhode Island | 44 | 33 | 0 |
892 | 892 | 2020-03-18 | South Carolina | 45 | 60 | 1 |
893 | 893 | 2020-03-18 | South Dakota | 46 | 11 | 1 |
894 | 894 | 2020-03-18 | Tennessee | 47 | 98 | 0 |
895 | 895 | 2020-03-18 | Texas | 48 | 166 | 2 |
896 | 896 | 2020-03-18 | Utah | 49 | 65 | 0 |
897 | 897 | 2020-03-18 | Vermont | 50 | 19 | 0 |
898 | 898 | 2020-03-18 | Virgin Islands | 78 | 3 | 0 |
899 | 899 | 2020-03-18 | Virginia | 51 | 78 | 2 |
900 | 900 | 2020-03-18 | Washington | 53 | 1026 | 68 |
901 | 901 | 2020-03-18 | West Virginia | 54 | 2 | 0 |
902 | 902 | 2020-03-18 | Wisconsin | 55 | 106 | 0 |
903 | 903 | 2020-03-18 | Wyoming | 56 | 17 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );