ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where "date" is on date 2020-07-23 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 55
- 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
- New Hampshire 1
- New Jersey 1
- New Mexico 1
- New York 1
- North Carolina 1
- North Dakota 1
- Northern Mariana Islands 1
- Ohio 1
- Oklahoma 1
- Oregon 1
- Pennsylvania 1
- Puerto Rico 1
- Rhode Island 1
- South Carolina 1
- South Dakota 1
- Tennessee 1
- Texas 1
- Utah 1
- Vermont 1
- Virgin Islands 1
- Virginia 1
- Washington 1
- West Virginia 1
- Wisconsin 1
- Wyoming 1
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
7825 | 7825 | 2020-07-23 | Alabama | 1 | 74212 | 1397 |
7826 | 7826 | 2020-07-23 | Alaska | 2 | 2682 | 17 |
7827 | 7827 | 2020-07-23 | Arizona | 4 | 153029 | 3067 |
7828 | 7828 | 2020-07-23 | Arkansas | 5 | 36259 | 386 |
7829 | 7829 | 2020-07-23 | California | 6 | 433175 | 8190 |
7830 | 7830 | 2020-07-23 | Colorado | 8 | 42409 | 1788 |
7831 | 7831 | 2020-07-23 | Connecticut | 9 | 48232 | 4410 |
7832 | 7832 | 2020-07-23 | Delaware | 10 | 13924 | 529 |
7833 | 7833 | 2020-07-23 | District of Columbia | 11 | 11571 | 581 |
7834 | 7834 | 2020-07-23 | Florida | 12 | 389860 | 5517 |
7835 | 7835 | 2020-07-23 | Georgia | 13 | 143857 | 3288 |
7836 | 7836 | 2020-07-23 | Guam | 66 | 1301 | 6 |
7837 | 7837 | 2020-07-23 | Hawaii | 15 | 1468 | 25 |
7838 | 7838 | 2020-07-23 | Idaho | 16 | 16862 | 142 |
7839 | 7839 | 2020-07-23 | Illinois | 17 | 168766 | 7563 |
7840 | 7840 | 2020-07-23 | Indiana | 18 | 61079 | 2880 |
7841 | 7841 | 2020-07-23 | Iowa | 19 | 40796 | 820 |
7842 | 7842 | 2020-07-23 | Kansas | 20 | 24518 | 326 |
7843 | 7843 | 2020-07-23 | Kentucky | 21 | 25828 | 706 |
7844 | 7844 | 2020-07-23 | Louisiana | 22 | 101762 | 3686 |
7845 | 7845 | 2020-07-23 | Maine | 23 | 3737 | 118 |
7846 | 7846 | 2020-07-23 | Maryland | 24 | 81396 | 3409 |
7847 | 7847 | 2020-07-23 | Massachusetts | 25 | 114647 | 8484 |
7848 | 7848 | 2020-07-23 | Michigan | 26 | 84585 | 6397 |
7849 | 7849 | 2020-07-23 | Minnesota | 27 | 48761 | 1601 |
7850 | 7850 | 2020-07-23 | Mississippi | 28 | 48053 | 1436 |
7851 | 7851 | 2020-07-23 | Missouri | 29 | 39923 | 1212 |
7852 | 7852 | 2020-07-23 | Montana | 30 | 2924 | 43 |
7853 | 7853 | 2020-07-23 | Nebraska | 31 | 23818 | 318 |
7854 | 7854 | 2020-07-23 | Nevada | 32 | 40088 | 709 |
7855 | 7855 | 2020-07-23 | New Hampshire | 33 | 6318 | 405 |
7856 | 7856 | 2020-07-23 | New Jersey | 34 | 179807 | 15730 |
7857 | 7857 | 2020-07-23 | New Mexico | 35 | 18163 | 596 |
7858 | 7858 | 2020-07-23 | New York | 36 | 414405 | 32270 |
7859 | 7859 | 2020-07-23 | North Carolina | 37 | 107050 | 1754 |
7860 | 7860 | 2020-07-23 | North Dakota | 38 | 5497 | 101 |
7861 | 7861 | 2020-07-23 | Northern Mariana Islands | 69 | 38 | 2 |
7862 | 7862 | 2020-07-23 | Ohio | 39 | 80186 | 3256 |
7863 | 7863 | 2020-07-23 | Oklahoma | 40 | 27969 | 477 |
7864 | 7864 | 2020-07-23 | Oregon | 41 | 15765 | 277 |
7865 | 7865 | 2020-07-23 | Pennsylvania | 42 | 109153 | 7142 |
7866 | 7866 | 2020-07-23 | Puerto Rico | 72 | 13473 | 188 |
7867 | 7867 | 2020-07-23 | Rhode Island | 44 | 18148 | 1001 |
7868 | 7868 | 2020-07-23 | South Carolina | 45 | 76606 | 1334 |
7869 | 7869 | 2020-07-23 | South Dakota | 46 | 8143 | 121 |
7870 | 7870 | 2020-07-23 | Tennessee | 47 | 84652 | 913 |
7871 | 7871 | 2020-07-23 | Texas | 48 | 376104 | 4714 |
7872 | 7872 | 2020-07-23 | Utah | 49 | 36178 | 271 |
7873 | 7873 | 2020-07-23 | Vermont | 50 | 1377 | 56 |
7874 | 7874 | 2020-07-23 | Virgin Islands | 78 | 342 | 7 |
7875 | 7875 | 2020-07-23 | Virginia | 51 | 81237 | 2054 |
7876 | 7876 | 2020-07-23 | Washington | 53 | 52255 | 1548 |
7877 | 7877 | 2020-07-23 | West Virginia | 54 | 5550 | 103 |
7878 | 7878 | 2020-07-23 | Wisconsin | 55 | 49751 | 887 |
7879 | 7879 | 2020-07-23 | Wyoming | 56 | 2347 | 25 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );