ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57,238 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- Washington 204
- Illinois 200
- California 199
- Arizona 198
- Massachusetts 192
- Wisconsin 189
- Texas 182
- Nebraska 176
- Utah 169
- Oregon 165
- Florida 163
- New York 163
- Rhode Island 163
- Georgia 162
- New Hampshire 162
- North Carolina 161
- New Jersey 160
- Tennessee 160
- Colorado 159
- Maryland 159
- Nevada 159
- Hawaii 158
- Indiana 158
- Kentucky 158
- Minnesota 158
- Oklahoma 158
- Pennsylvania 158
- South Carolina 158
- Vermont 158
- Virginia 158
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
8915 | 8915 | 2020-08-11 | Tennessee | 47 | 122003 | 1259 |
8916 | 8916 | 2020-08-11 | Texas | 48 | 524898 | 9311 |
8917 | 8917 | 2020-08-11 | Utah | 49 | 44836 | 350 |
8918 | 8918 | 2020-08-11 | Vermont | 50 | 1472 | 58 |
8919 | 8919 | 2020-08-11 | Virgin Islands | 78 | 639 | 9 |
8920 | 8920 | 2020-08-11 | Virginia | 51 | 101745 | 2344 |
8921 | 8921 | 2020-08-11 | Washington | 53 | 66619 | 1785 |
8922 | 8922 | 2020-08-11 | West Virginia | 54 | 7875 | 147 |
8923 | 8923 | 2020-08-11 | Wisconsin | 55 | 66146 | 1017 |
8924 | 8924 | 2020-08-11 | Wyoming | 56 | 3073 | 29 |
8815 | 8815 | 2020-08-10 | Alabama | 1 | 103020 | 1797 |
8816 | 8816 | 2020-08-10 | Alaska | 2 | 4537 | 24 |
8817 | 8817 | 2020-08-10 | Arizona | 4 | 187634 | 4157 |
8818 | 8818 | 2020-08-10 | Arkansas | 5 | 50028 | 555 |
8819 | 8819 | 2020-08-10 | California | 6 | 574267 | 10460 |
8820 | 8820 | 2020-08-10 | Colorado | 8 | 51104 | 1868 |
8821 | 8821 | 2020-08-10 | Connecticut | 9 | 50567 | 4444 |
8822 | 8822 | 2020-08-10 | Delaware | 10 | 15634 | 591 |
8823 | 8823 | 2020-08-10 | District of Columbia | 11 | 12807 | 591 |
8824 | 8824 | 2020-08-10 | Florida | 12 | 536953 | 8276 |
8825 | 8825 | 2020-08-10 | Georgia | 13 | 202276 | 4138 |
8826 | 8826 | 2020-08-10 | Guam | 66 | 1387 | 6 |
8827 | 8827 | 2020-08-10 | Hawaii | 15 | 3615 | 33 |
8828 | 8828 | 2020-08-10 | Idaho | 16 | 25267 | 239 |
8829 | 8829 | 2020-08-10 | Illinois | 17 | 197326 | 7854 |
8830 | 8830 | 2020-08-10 | Indiana | 18 | 76734 | 3044 |
8831 | 8831 | 2020-08-10 | Iowa | 19 | 49164 | 935 |
8832 | 8832 | 2020-08-10 | Kansas | 20 | 32094 | 387 |
8833 | 8833 | 2020-08-10 | Kentucky | 21 | 36739 | 794 |
8834 | 8834 | 2020-08-10 | Louisiana | 22 | 132079 | 4287 |
8835 | 8835 | 2020-08-10 | Maine | 23 | 4049 | 125 |
8836 | 8836 | 2020-08-10 | Maryland | 24 | 96821 | 3591 |
8837 | 8837 | 2020-08-10 | Massachusetts | 25 | 121315 | 8741 |
8838 | 8838 | 2020-08-10 | Michigan | 26 | 97472 | 6527 |
8839 | 8839 | 2020-08-10 | Minnesota | 27 | 61557 | 1701 |
8840 | 8840 | 2020-08-10 | Mississippi | 28 | 67649 | 1912 |
8841 | 8841 | 2020-08-10 | Missouri | 29 | 60882 | 1397 |
8842 | 8842 | 2020-08-10 | Montana | 30 | 5032 | 75 |
8843 | 8843 | 2020-08-10 | Nebraska | 31 | 28696 | 354 |
8844 | 8844 | 2020-08-10 | Nevada | 32 | 57022 | 963 |
8845 | 8845 | 2020-08-10 | New Hampshire | 33 | 6840 | 419 |
8846 | 8846 | 2020-08-10 | New Jersey | 34 | 186884 | 15878 |
8847 | 8847 | 2020-08-10 | New Mexico | 35 | 22444 | 690 |
8848 | 8848 | 2020-08-10 | New York | 36 | 426046 | 32361 |
8849 | 8849 | 2020-08-10 | North Carolina | 37 | 137006 | 2198 |
8850 | 8850 | 2020-08-10 | North Dakota | 38 | 7717 | 117 |
8851 | 8851 | 2020-08-10 | Northern Mariana Islands | 69 | 49 | 2 |
8852 | 8852 | 2020-08-10 | Ohio | 39 | 101731 | 3673 |
8853 | 8853 | 2020-08-10 | Oklahoma | 40 | 43962 | 605 |
8854 | 8854 | 2020-08-10 | Oregon | 41 | 21488 | 362 |
8855 | 8855 | 2020-08-10 | Pennsylvania | 42 | 124269 | 7378 |
8856 | 8856 | 2020-08-10 | Puerto Rico | 72 | 22821 | 279 |
8857 | 8857 | 2020-08-10 | Rhode Island | 44 | 19934 | 1015 |
8858 | 8858 | 2020-08-10 | South Carolina | 45 | 101159 | 2049 |
8859 | 8859 | 2020-08-10 | South Dakota | 46 | 9663 | 146 |
8860 | 8860 | 2020-08-10 | Tennessee | 47 | 120967 | 1223 |
8861 | 8861 | 2020-08-10 | Texas | 48 | 517182 | 9064 |
8862 | 8862 | 2020-08-10 | Utah | 49 | 44487 | 346 |
8863 | 8863 | 2020-08-10 | Vermont | 50 | 1462 | 58 |
8864 | 8864 | 2020-08-10 | Virgin Islands | 78 | 576 | 9 |
8865 | 8865 | 2020-08-10 | Virginia | 51 | 100749 | 2327 |
8866 | 8866 | 2020-08-10 | Washington | 53 | 66225 | 1780 |
8867 | 8867 | 2020-08-10 | West Virginia | 54 | 7754 | 141 |
8868 | 8868 | 2020-08-10 | Wisconsin | 55 | 65427 | 1009 |
8869 | 8869 | 2020-08-10 | Wyoming | 56 | 3042 | 28 |
8760 | 8760 | 2020-08-09 | Alabama | 1 | 101334 | 1768 |
8761 | 8761 | 2020-08-09 | Alaska | 2 | 4471 | 24 |
8762 | 8762 | 2020-08-09 | Arizona | 4 | 187086 | 4152 |
8763 | 8763 | 2020-08-09 | Arkansas | 5 | 49383 | 544 |
8764 | 8764 | 2020-08-09 | California | 6 | 563244 | 10365 |
8765 | 8765 | 2020-08-09 | Colorado | 8 | 50799 | 1863 |
8766 | 8766 | 2020-08-09 | Connecticut | 9 | 50320 | 4441 |
8767 | 8767 | 2020-08-09 | Delaware | 10 | 15575 | 591 |
8768 | 8768 | 2020-08-09 | District of Columbia | 11 | 12753 | 591 |
8769 | 8769 | 2020-08-09 | Florida | 12 | 532798 | 8185 |
8770 | 8770 | 2020-08-09 | Georgia | 13 | 200147 | 4108 |
8771 | 8771 | 2020-08-09 | Guam | 66 | 1381 | 6 |
8772 | 8772 | 2020-08-09 | Hawaii | 15 | 3475 | 30 |
8773 | 8773 | 2020-08-09 | Idaho | 16 | 24797 | 237 |
8774 | 8774 | 2020-08-09 | Illinois | 17 | 195897 | 7852 |
8775 | 8775 | 2020-08-09 | Indiana | 18 | 76071 | 3041 |
8776 | 8776 | 2020-08-09 | Iowa | 19 | 48919 | 931 |
8777 | 8777 | 2020-08-09 | Kansas | 20 | 31145 | 380 |
8778 | 8778 | 2020-08-09 | Kentucky | 21 | 36316 | 790 |
8779 | 8779 | 2020-08-09 | Louisiana | 22 | 131517 | 4263 |
8780 | 8780 | 2020-08-09 | Maine | 23 | 4042 | 125 |
8781 | 8781 | 2020-08-09 | Maryland | 24 | 96065 | 3585 |
8782 | 8782 | 2020-08-09 | Massachusetts | 25 | 121040 | 8735 |
8783 | 8783 | 2020-08-09 | Michigan | 26 | 96835 | 6520 |
8784 | 8784 | 2020-08-09 | Minnesota | 27 | 60939 | 1698 |
8785 | 8785 | 2020-08-09 | Mississippi | 28 | 67173 | 1896 |
8786 | 8786 | 2020-08-09 | Missouri | 29 | 59895 | 1386 |
8787 | 8787 | 2020-08-09 | Montana | 30 | 4952 | 75 |
8788 | 8788 | 2020-08-09 | Nebraska | 31 | 28432 | 353 |
8789 | 8789 | 2020-08-09 | Nevada | 32 | 56278 | 959 |
8790 | 8790 | 2020-08-09 | New Hampshire | 33 | 6831 | 419 |
8791 | 8791 | 2020-08-09 | New Jersey | 34 | 186626 | 15874 |
8792 | 8792 | 2020-08-09 | New Mexico | 35 | 22315 | 685 |
8793 | 8793 | 2020-08-09 | New York | 36 | 425568 | 32354 |
8794 | 8794 | 2020-08-09 | North Carolina | 37 | 136250 | 2195 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );