ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
53 rows where "date" is on date 2020-03-16 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 |
---|---|---|---|---|---|---|
743 | 743 | 2020-03-16 | Alabama | 1 | 29 | 0 |
744 | 744 | 2020-03-16 | Alaska | 2 | 3 | 0 |
745 | 745 | 2020-03-16 | Arizona | 4 | 18 | 0 |
746 | 746 | 2020-03-16 | Arkansas | 5 | 22 | 0 |
747 | 747 | 2020-03-16 | California | 6 | 588 | 11 |
748 | 748 | 2020-03-16 | Colorado | 8 | 161 | 2 |
749 | 749 | 2020-03-16 | Connecticut | 9 | 41 | 0 |
750 | 750 | 2020-03-16 | Delaware | 10 | 8 | 0 |
751 | 751 | 2020-03-16 | District of Columbia | 11 | 22 | 0 |
752 | 752 | 2020-03-16 | Florida | 12 | 141 | 4 |
753 | 753 | 2020-03-16 | Georgia | 13 | 118 | 1 |
754 | 754 | 2020-03-16 | Guam | 66 | 3 | 0 |
755 | 755 | 2020-03-16 | Hawaii | 15 | 10 | 0 |
756 | 756 | 2020-03-16 | Idaho | 16 | 5 | 0 |
757 | 757 | 2020-03-16 | Illinois | 17 | 104 | 0 |
758 | 758 | 2020-03-16 | Indiana | 18 | 24 | 1 |
759 | 759 | 2020-03-16 | Iowa | 19 | 22 | 0 |
760 | 760 | 2020-03-16 | Kansas | 20 | 11 | 1 |
761 | 761 | 2020-03-16 | Kentucky | 21 | 22 | 1 |
762 | 762 | 2020-03-16 | Louisiana | 22 | 137 | 3 |
763 | 763 | 2020-03-16 | Maine | 23 | 17 | 0 |
764 | 764 | 2020-03-16 | Maryland | 24 | 39 | 0 |
765 | 765 | 2020-03-16 | Massachusetts | 25 | 197 | 0 |
766 | 766 | 2020-03-16 | Michigan | 26 | 54 | 0 |
767 | 767 | 2020-03-16 | Minnesota | 27 | 54 | 0 |
768 | 768 | 2020-03-16 | Mississippi | 28 | 12 | 0 |
769 | 769 | 2020-03-16 | Missouri | 29 | 9 | 0 |
770 | 770 | 2020-03-16 | Montana | 30 | 8 | 0 |
771 | 771 | 2020-03-16 | Nebraska | 31 | 33 | 0 |
772 | 772 | 2020-03-16 | Nevada | 32 | 45 | 1 |
773 | 773 | 2020-03-16 | New Hampshire | 33 | 17 | 0 |
774 | 774 | 2020-03-16 | New Jersey | 34 | 176 | 3 |
775 | 775 | 2020-03-16 | New Mexico | 35 | 21 | 0 |
776 | 776 | 2020-03-16 | New York | 36 | 950 | 10 |
777 | 777 | 2020-03-16 | North Carolina | 37 | 34 | 0 |
778 | 778 | 2020-03-16 | North Dakota | 38 | 1 | 0 |
779 | 779 | 2020-03-16 | Ohio | 39 | 50 | 0 |
780 | 780 | 2020-03-16 | Oklahoma | 40 | 10 | 0 |
781 | 781 | 2020-03-16 | Oregon | 41 | 46 | 1 |
782 | 782 | 2020-03-16 | Pennsylvania | 42 | 81 | 0 |
783 | 783 | 2020-03-16 | Puerto Rico | 72 | 5 | 0 |
784 | 784 | 2020-03-16 | Rhode Island | 44 | 21 | 0 |
785 | 785 | 2020-03-16 | South Carolina | 45 | 33 | 1 |
786 | 786 | 2020-03-16 | South Dakota | 46 | 10 | 1 |
787 | 787 | 2020-03-16 | Tennessee | 47 | 52 | 0 |
788 | 788 | 2020-03-16 | Texas | 48 | 87 | 1 |
789 | 789 | 2020-03-16 | Utah | 49 | 40 | 0 |
790 | 790 | 2020-03-16 | Vermont | 50 | 12 | 0 |
791 | 791 | 2020-03-16 | Virgin Islands | 78 | 2 | 0 |
792 | 792 | 2020-03-16 | Virginia | 51 | 51 | 1 |
793 | 793 | 2020-03-16 | Washington | 53 | 794 | 48 |
794 | 794 | 2020-03-16 | Wisconsin | 55 | 47 | 0 |
795 | 795 | 2020-03-16 | Wyoming | 56 | 10 | 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 );