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 2021-03-20 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 |
---|---|---|---|---|---|---|
21025 | 21025 | 2021-03-20 | Alabama | 1 | 511087 | 10436 |
21026 | 21026 | 2021-03-20 | Alaska | 2 | 60683 | 296 |
21027 | 21027 | 2021-03-20 | Arizona | 4 | 835765 | 16733 |
21028 | 21028 | 2021-03-20 | Arkansas | 5 | 328547 | 5533 |
21029 | 21029 | 2021-03-20 | California | 6 | 3640830 | 57495 |
21030 | 21030 | 2021-03-20 | Colorado | 8 | 452174 | 6148 |
21031 | 21031 | 2021-03-20 | Connecticut | 9 | 296691 | 7832 |
21032 | 21032 | 2021-03-20 | Delaware | 10 | 91942 | 1526 |
21033 | 21033 | 2021-03-20 | District of Columbia | 11 | 43175 | 1049 |
21034 | 21034 | 2021-03-20 | Florida | 12 | 2004354 | 32712 |
21035 | 21035 | 2021-03-20 | Georgia | 13 | 1018824 | 17965 |
21036 | 21036 | 2021-03-20 | Guam | 66 | 8749 | 135 |
21037 | 21037 | 2021-03-20 | Hawaii | 15 | 28763 | 450 |
21038 | 21038 | 2021-03-20 | Idaho | 16 | 177501 | 1944 |
21039 | 21039 | 2021-03-20 | Illinois | 17 | 1223884 | 23329 |
21040 | 21040 | 2021-03-20 | Indiana | 18 | 680420 | 12926 |
21041 | 21041 | 2021-03-20 | Iowa | 19 | 345644 | 5675 |
21042 | 21042 | 2021-03-20 | Kansas | 20 | 302223 | 4842 |
21043 | 21043 | 2021-03-20 | Kentucky | 21 | 423989 | 5777 |
21044 | 21044 | 2021-03-20 | Louisiana | 22 | 439737 | 9988 |
21045 | 21045 | 2021-03-20 | Maine | 23 | 48292 | 728 |
21046 | 21046 | 2021-03-20 | Maryland | 24 | 399201 | 8158 |
21047 | 21047 | 2021-03-20 | Massachusetts | 25 | 612857 | 16832 |
21048 | 21048 | 2021-03-20 | Michigan | 26 | 689933 | 16897 |
21049 | 21049 | 2021-03-20 | Minnesota | 27 | 504341 | 6845 |
21050 | 21050 | 2021-03-20 | Mississippi | 28 | 302677 | 6955 |
21051 | 21051 | 2021-03-20 | Missouri | 29 | 581859 | 8816 |
21052 | 21052 | 2021-03-20 | Montana | 30 | 103042 | 1415 |
21053 | 21053 | 2021-03-20 | Nebraska | 31 | 206685 | 2243 |
21054 | 21054 | 2021-03-20 | Nevada | 32 | 300962 | 5171 |
21055 | 21055 | 2021-03-20 | New Hampshire | 33 | 80316 | 1217 |
21056 | 21056 | 2021-03-20 | New Jersey | 34 | 862648 | 24134 |
21057 | 21057 | 2021-03-20 | New Mexico | 35 | 189560 | 3891 |
21058 | 21058 | 2021-03-20 | New York | 36 | 1779291 | 48916 |
21059 | 21059 | 2021-03-20 | North Carolina | 37 | 896395 | 11848 |
21060 | 21060 | 2021-03-20 | North Dakota | 38 | 101633 | 1492 |
21061 | 21061 | 2021-03-20 | Northern Mariana Islands | 69 | 157 | 2 |
21062 | 21062 | 2021-03-20 | Ohio | 39 | 998819 | 18340 |
21063 | 21063 | 2021-03-20 | Oklahoma | 40 | 434491 | 4788 |
21064 | 21064 | 2021-03-20 | Oregon | 41 | 161342 | 2373 |
21065 | 21065 | 2021-03-20 | Pennsylvania | 42 | 989336 | 24841 |
21066 | 21066 | 2021-03-20 | Puerto Rico | 72 | 137510 | 2092 |
21067 | 21067 | 2021-03-20 | Rhode Island | 44 | 133039 | 2595 |
21068 | 21068 | 2021-03-20 | South Carolina | 45 | 540390 | 8977 |
21069 | 21069 | 2021-03-20 | South Dakota | 46 | 115723 | 1922 |
21070 | 21070 | 2021-03-20 | Tennessee | 47 | 784220 | 11606 |
21071 | 21071 | 2021-03-20 | Texas | 48 | 2748905 | 47462 |
21072 | 21072 | 2021-03-20 | Utah | 49 | 381311 | 2060 |
21073 | 21073 | 2021-03-20 | Vermont | 50 | 17555 | 219 |
21074 | 21074 | 2021-03-20 | Virgin Islands | 78 | 2767 | 25 |
21075 | 21075 | 2021-03-20 | Virginia | 51 | 603748 | 10106 |
21076 | 21076 | 2021-03-20 | Washington | 53 | 357376 | 5224 |
21077 | 21077 | 2021-03-20 | West Virginia | 54 | 137478 | 2600 |
21078 | 21078 | 2021-03-20 | Wisconsin | 55 | 629167 | 7241 |
21079 | 21079 | 2021-03-20 | Wyoming | 56 | 55581 | 693 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );