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-17 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
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 |
---|---|---|---|---|---|---|
796 | 796 | 2020-03-17 | Alabama | 1 | 39 | 0 |
797 | 797 | 2020-03-17 | Alaska | 2 | 6 | 0 |
798 | 798 | 2020-03-17 | Arizona | 4 | 20 | 0 |
799 | 799 | 2020-03-17 | Arkansas | 5 | 22 | 0 |
800 | 800 | 2020-03-17 | California | 6 | 732 | 14 |
801 | 801 | 2020-03-17 | Colorado | 8 | 183 | 3 |
802 | 802 | 2020-03-17 | Connecticut | 9 | 68 | 0 |
803 | 803 | 2020-03-17 | Delaware | 10 | 16 | 0 |
804 | 804 | 2020-03-17 | District of Columbia | 11 | 31 | 0 |
805 | 805 | 2020-03-17 | Florida | 12 | 210 | 6 |
806 | 806 | 2020-03-17 | Georgia | 13 | 142 | 1 |
807 | 807 | 2020-03-17 | Guam | 66 | 3 | 0 |
808 | 808 | 2020-03-17 | Hawaii | 15 | 14 | 0 |
809 | 809 | 2020-03-17 | Idaho | 16 | 9 | 0 |
810 | 810 | 2020-03-17 | Illinois | 17 | 159 | 1 |
811 | 811 | 2020-03-17 | Indiana | 18 | 30 | 2 |
812 | 812 | 2020-03-17 | Iowa | 19 | 29 | 0 |
813 | 813 | 2020-03-17 | Kansas | 20 | 17 | 1 |
814 | 814 | 2020-03-17 | Kentucky | 21 | 26 | 1 |
815 | 815 | 2020-03-17 | Louisiana | 22 | 196 | 5 |
816 | 816 | 2020-03-17 | Maine | 23 | 32 | 0 |
817 | 817 | 2020-03-17 | Maryland | 24 | 57 | 0 |
818 | 818 | 2020-03-17 | Massachusetts | 25 | 218 | 0 |
819 | 819 | 2020-03-17 | Michigan | 26 | 65 | 0 |
820 | 820 | 2020-03-17 | Minnesota | 27 | 60 | 0 |
821 | 821 | 2020-03-17 | Mississippi | 28 | 21 | 0 |
822 | 822 | 2020-03-17 | Missouri | 29 | 16 | 0 |
823 | 823 | 2020-03-17 | Montana | 30 | 8 | 0 |
824 | 824 | 2020-03-17 | Nebraska | 31 | 36 | 0 |
825 | 825 | 2020-03-17 | Nevada | 32 | 55 | 1 |
826 | 826 | 2020-03-17 | New Hampshire | 33 | 26 | 0 |
827 | 827 | 2020-03-17 | New Jersey | 34 | 268 | 3 |
828 | 828 | 2020-03-17 | New Mexico | 35 | 23 | 0 |
829 | 829 | 2020-03-17 | New York | 36 | 1375 | 18 |
830 | 830 | 2020-03-17 | North Carolina | 37 | 42 | 0 |
831 | 831 | 2020-03-17 | North Dakota | 38 | 5 | 0 |
832 | 832 | 2020-03-17 | Ohio | 39 | 67 | 0 |
833 | 833 | 2020-03-17 | Oklahoma | 40 | 18 | 0 |
834 | 834 | 2020-03-17 | Oregon | 41 | 66 | 2 |
835 | 835 | 2020-03-17 | Pennsylvania | 42 | 101 | 0 |
836 | 836 | 2020-03-17 | Puerto Rico | 72 | 5 | 0 |
837 | 837 | 2020-03-17 | Rhode Island | 44 | 23 | 0 |
838 | 838 | 2020-03-17 | South Carolina | 45 | 47 | 1 |
839 | 839 | 2020-03-17 | South Dakota | 46 | 11 | 1 |
840 | 840 | 2020-03-17 | Tennessee | 47 | 73 | 0 |
841 | 841 | 2020-03-17 | Texas | 48 | 106 | 1 |
842 | 842 | 2020-03-17 | Utah | 49 | 51 | 0 |
843 | 843 | 2020-03-17 | Vermont | 50 | 14 | 0 |
844 | 844 | 2020-03-17 | Virgin Islands | 78 | 2 | 0 |
845 | 845 | 2020-03-17 | Virginia | 51 | 67 | 2 |
846 | 846 | 2020-03-17 | Washington | 53 | 908 | 54 |
847 | 847 | 2020-03-17 | West Virginia | 54 | 1 | 0 |
848 | 848 | 2020-03-17 | Wisconsin | 55 | 72 | 0 |
849 | 849 | 2020-03-17 | Wyoming | 56 | 15 | 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 );