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-04-03 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 |
---|---|---|---|---|---|---|
21795 | 21795 | 2021-04-03 | Alabama | 1 | 516615 | 10637 |
21796 | 21796 | 2021-04-03 | Alaska | 2 | 62987 | 299 |
21797 | 21797 | 2021-04-03 | Arizona | 4 | 843838 | 16991 |
21798 | 21798 | 2021-04-03 | Arkansas | 5 | 330970 | 5641 |
21799 | 21799 | 2021-04-03 | California | 6 | 3678343 | 59675 |
21800 | 21800 | 2021-04-03 | Colorado | 8 | 469052 | 6187 |
21801 | 21801 | 2021-04-03 | Connecticut | 9 | 313956 | 7904 |
21802 | 21802 | 2021-04-03 | Delaware | 10 | 96077 | 1565 |
21803 | 21803 | 2021-04-03 | District of Columbia | 11 | 44932 | 1070 |
21804 | 21804 | 2021-04-03 | Florida | 12 | 2077024 | 33651 |
21805 | 21805 | 2021-04-03 | Georgia | 13 | 1039632 | 18623 |
21806 | 21806 | 2021-04-03 | Guam | 66 | 8785 | 137 |
21807 | 21807 | 2021-04-03 | Hawaii | 15 | 30246 | 464 |
21808 | 21808 | 2021-04-03 | Idaho | 16 | 181309 | 1969 |
21809 | 21809 | 2021-04-03 | Illinois | 17 | 1257605 | 23635 |
21810 | 21810 | 2021-04-03 | Indiana | 18 | 693258 | 13074 |
21811 | 21811 | 2021-04-03 | Iowa | 19 | 353207 | 5822 |
21812 | 21812 | 2021-04-03 | Kansas | 20 | 305137 | 4932 |
21813 | 21813 | 2021-04-03 | Kentucky | 21 | 432287 | 6210 |
21814 | 21814 | 2021-04-03 | Louisiana | 22 | 445469 | 10161 |
21815 | 21815 | 2021-04-03 | Maine | 23 | 51468 | 745 |
21816 | 21816 | 2021-04-03 | Maryland | 24 | 415845 | 8342 |
21817 | 21817 | 2021-04-03 | Massachusetts | 25 | 643232 | 17281 |
21818 | 21818 | 2021-04-03 | Michigan | 26 | 767273 | 17249 |
21819 | 21819 | 2021-04-03 | Minnesota | 27 | 526345 | 6953 |
21820 | 21820 | 2021-04-03 | Mississippi | 28 | 305991 | 7055 |
21821 | 21821 | 2021-04-03 | Missouri | 29 | 590697 | 8988 |
21822 | 21822 | 2021-04-03 | Montana | 30 | 105092 | 1465 |
21823 | 21823 | 2021-04-03 | Nebraska | 31 | 211570 | 2285 |
21824 | 21824 | 2021-04-03 | Nevada | 32 | 304924 | 5274 |
21825 | 21825 | 2021-04-03 | New Hampshire | 33 | 85448 | 1247 |
21826 | 21826 | 2021-04-03 | New Jersey | 34 | 923394 | 24632 |
21827 | 21827 | 2021-04-03 | New Mexico | 35 | 192152 | 3951 |
21828 | 21828 | 2021-04-03 | New York | 36 | 1896534 | 50042 |
21829 | 21829 | 2021-04-03 | North Carolina | 37 | 917474 | 12161 |
21830 | 21830 | 2021-04-03 | North Dakota | 38 | 103609 | 1498 |
21831 | 21831 | 2021-04-03 | Northern Mariana Islands | 69 | 159 | 2 |
21832 | 21832 | 2021-04-03 | Ohio | 39 | 1024011 | 18643 |
21833 | 21833 | 2021-04-03 | Oklahoma | 40 | 439149 | 4953 |
21834 | 21834 | 2021-04-03 | Oregon | 41 | 166480 | 2406 |
21835 | 21835 | 2021-04-03 | Pennsylvania | 42 | 1043693 | 25243 |
21836 | 21836 | 2021-04-03 | Puerto Rico | 72 | 142387 | 2126 |
21837 | 21837 | 2021-04-03 | Rhode Island | 44 | 138255 | 2630 |
21838 | 21838 | 2021-04-03 | South Carolina | 45 | 555274 | 9196 |
21839 | 21839 | 2021-04-03 | South Dakota | 46 | 118361 | 1938 |
21840 | 21840 | 2021-04-03 | Tennessee | 47 | 799450 | 11809 |
21841 | 21841 | 2021-04-03 | Texas | 48 | 2797366 | 48831 |
21842 | 21842 | 2021-04-03 | Utah | 49 | 387057 | 2132 |
21843 | 21843 | 2021-04-03 | Vermont | 50 | 19905 | 229 |
21844 | 21844 | 2021-04-03 | Virgin Islands | 78 | 2907 | 26 |
21845 | 21845 | 2021-04-03 | Virginia | 51 | 623881 | 10287 |
21846 | 21846 | 2021-04-03 | Washington | 53 | 370362 | 5326 |
21847 | 21847 | 2021-04-03 | West Virginia | 54 | 143106 | 2693 |
21848 | 21848 | 2021-04-03 | Wisconsin | 55 | 638777 | 7342 |
21849 | 21849 | 2021-04-03 | Wyoming | 56 | 56447 | 700 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );