ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where "date" is on date 2022-03-29 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 56
- Alabama 1
- Alaska 1
- American Samoa 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 |
---|---|---|---|---|---|---|
41783 | 41783 | 2022-03-29 | Alabama | 1 | 1294816 | 19280 |
41784 | 41784 | 2022-03-29 | Alaska | 2 | 244800 | 1186 |
41785 | 41785 | 2022-03-29 | American Samoa | 60 | 2953 | 0 |
41786 | 41786 | 2022-03-29 | Arizona | 4 | 1997037 | 28883 |
41787 | 41787 | 2022-03-29 | Arkansas | 5 | 832718 | 11211 |
41788 | 41788 | 2022-03-29 | California | 6 | 9095335 | 88838 |
41789 | 41789 | 2022-03-29 | Colorado | 8 | 1348873 | 12171 |
41790 | 41790 | 2022-03-29 | Connecticut | 9 | 735575 | 10779 |
41791 | 41791 | 2022-03-29 | Delaware | 10 | 259453 | 2846 |
41792 | 41792 | 2022-03-29 | District of Columbia | 11 | 136506 | 1331 |
41793 | 41793 | 2022-03-29 | Florida | 12 | 5846240 | 73136 |
41794 | 41794 | 2022-03-29 | Georgia | 13 | 2417820 | 35459 |
41795 | 41795 | 2022-03-29 | Guam | 66 | 48150 | 344 |
41796 | 41796 | 2022-03-29 | Hawaii | 15 | 233569 | 1370 |
41797 | 41797 | 2022-03-29 | Idaho | 16 | 443881 | 4873 |
41798 | 41798 | 2022-03-29 | Illinois | 17 | 3070932 | 37631 |
41799 | 41799 | 2022-03-29 | Indiana | 18 | 1694848 | 23373 |
41800 | 41800 | 2022-03-29 | Iowa | 19 | 758463 | 9402 |
41801 | 41801 | 2022-03-29 | Kansas | 20 | 770780 | 8248 |
41802 | 41802 | 2022-03-29 | Kentucky | 21 | 1322323 | 14898 |
41803 | 41803 | 2022-03-29 | Louisiana | 22 | 1232128 | 17104 |
41804 | 41804 | 2022-03-29 | Maine | 23 | 235293 | 2200 |
41805 | 41805 | 2022-03-29 | Maryland | 24 | 1011475 | 14331 |
41806 | 41806 | 2022-03-29 | Massachusetts | 25 | 1695750 | 20097 |
41807 | 41807 | 2022-03-29 | Michigan | 26 | 2379828 | 35538 |
41808 | 41808 | 2022-03-29 | Minnesota | 27 | 1428924 | 12610 |
41809 | 41809 | 2022-03-29 | Mississippi | 28 | 794292 | 12396 |
41810 | 41810 | 2022-03-29 | Missouri | 29 | 1426966 | 20140 |
41811 | 41811 | 2022-03-29 | Montana | 30 | 272753 | 3246 |
41812 | 41812 | 2022-03-29 | Nebraska | 31 | 477831 | 4123 |
41813 | 41813 | 2022-03-29 | Nevada | 32 | 712638 | 10056 |
41814 | 41814 | 2022-03-29 | New Hampshire | 33 | 302253 | 2451 |
41815 | 41815 | 2022-03-29 | New Jersey | 34 | 2196970 | 33225 |
41816 | 41816 | 2022-03-29 | New Mexico | 35 | 517608 | 7236 |
41817 | 41817 | 2022-03-29 | New York | 36 | 4970905 | 67299 |
41818 | 41818 | 2022-03-29 | North Carolina | 37 | 2629108 | 23204 |
41819 | 41819 | 2022-03-29 | North Dakota | 38 | 239705 | 2279 |
41820 | 41820 | 2022-03-29 | Northern Mariana Islands | 69 | 11065 | 33 |
41821 | 41821 | 2022-03-29 | Ohio | 39 | 2669698 | 37793 |
41822 | 41822 | 2022-03-29 | Oklahoma | 40 | 1033256 | 13889 |
41823 | 41823 | 2022-03-29 | Oregon | 41 | 703465 | 7115 |
41824 | 41824 | 2022-03-29 | Pennsylvania | 42 | 2779921 | 44238 |
41825 | 41825 | 2022-03-29 | Puerto Rico | 72 | 513291 | 4163 |
41826 | 41826 | 2022-03-29 | Rhode Island | 44 | 360759 | 3522 |
41827 | 41827 | 2022-03-29 | South Carolina | 45 | 1468140 | 17591 |
41828 | 41828 | 2022-03-29 | South Dakota | 46 | 236955 | 2880 |
41829 | 41829 | 2022-03-29 | Tennessee | 47 | 1971458 | 25259 |
41830 | 41830 | 2022-03-29 | Texas | 48 | 6674412 | 87393 |
41831 | 41831 | 2022-03-29 | Utah | 49 | 927877 | 4711 |
41832 | 41832 | 2022-03-29 | Vermont | 50 | 116246 | 617 |
41833 | 41833 | 2022-03-29 | Virgin Islands | 78 | 15632 | 111 |
41834 | 41834 | 2022-03-29 | Virginia | 51 | 1667289 | 19653 |
41835 | 41835 | 2022-03-29 | Washington | 53 | 1453946 | 12515 |
41836 | 41836 | 2022-03-29 | West Virginia | 54 | 497553 | 6794 |
41837 | 41837 | 2022-03-29 | Wisconsin | 55 | 1584392 | 14291 |
41838 | 41838 | 2022-03-29 | Wyoming | 56 | 156112 | 1791 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );