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-05-04 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 |
---|---|---|---|---|---|---|
43799 | 43799 | 2022-05-04 | Alabama | 1 | 1301805 | 19590 |
43800 | 43800 | 2022-05-04 | Alaska | 2 | 252847 | 1213 |
43801 | 43801 | 2022-05-04 | American Samoa | 60 | 5793 | 26 |
43802 | 43802 | 2022-05-04 | Arizona | 4 | 2025435 | 30189 |
43803 | 43803 | 2022-05-04 | Arkansas | 5 | 836343 | 11403 |
43804 | 43804 | 2022-05-04 | California | 6 | 9263998 | 90571 |
43805 | 43805 | 2022-05-04 | Colorado | 8 | 1394135 | 12671 |
43806 | 43806 | 2022-05-04 | Connecticut | 9 | 763149 | 10858 |
43807 | 43807 | 2022-05-04 | Delaware | 10 | 263479 | 2919 |
43808 | 43808 | 2022-05-04 | District of Columbia | 11 | 141943 | 1340 |
43809 | 43809 | 2022-05-04 | Florida | 12 | 5946185 | 74008 |
43810 | 43810 | 2022-05-04 | Georgia | 13 | 2452012 | 36498 |
43811 | 43811 | 2022-05-04 | Guam | 66 | 49251 | 354 |
43812 | 43812 | 2022-05-04 | Hawaii | 15 | 246110 | 1425 |
43813 | 43813 | 2022-05-04 | Idaho | 16 | 446648 | 4931 |
43814 | 43814 | 2022-05-04 | Illinois | 17 | 3163121 | 37934 |
43815 | 43815 | 2022-05-04 | Indiana | 18 | 1705394 | 23591 |
43816 | 43816 | 2022-05-04 | Iowa | 19 | 765192 | 9533 |
43817 | 43817 | 2022-05-04 | Kansas | 20 | 776919 | 8635 |
43818 | 43818 | 2022-05-04 | Kentucky | 21 | 1339678 | 15571 |
43819 | 43819 | 2022-05-04 | Louisiana | 22 | 1239469 | 17270 |
43820 | 43820 | 2022-05-04 | Maine | 23 | 248099 | 2296 |
43821 | 43821 | 2022-05-04 | Maryland | 24 | 1036603 | 14480 |
43822 | 43822 | 2022-05-04 | Massachusetts | 25 | 1770301 | 20303 |
43823 | 43823 | 2022-05-04 | Michigan | 26 | 2438988 | 36023 |
43824 | 43824 | 2022-05-04 | Minnesota | 27 | 1459625 | 12795 |
43825 | 43825 | 2022-05-04 | Mississippi | 28 | 798283 | 12450 |
43826 | 43826 | 2022-05-04 | Missouri | 29 | 1436092 | 20226 |
43827 | 43827 | 2022-05-04 | Montana | 30 | 274627 | 3375 |
43828 | 43828 | 2022-05-04 | Nebraska | 31 | 480586 | 4215 |
43829 | 43829 | 2022-05-04 | Nevada | 32 | 720739 | 10780 |
43830 | 43830 | 2022-05-04 | New Hampshire | 33 | 312161 | 2487 |
43831 | 43831 | 2022-05-04 | New Jersey | 34 | 2273050 | 33467 |
43832 | 43832 | 2022-05-04 | New Mexico | 35 | 523268 | 7538 |
43833 | 43833 | 2022-05-04 | New York | 36 | 5180822 | 67745 |
43834 | 43834 | 2022-05-04 | North Carolina | 37 | 2675130 | 24587 |
43835 | 43835 | 2022-05-04 | North Dakota | 38 | 241385 | 2315 |
43836 | 43836 | 2022-05-04 | Northern Mariana Islands | 69 | 11263 | 34 |
43837 | 43837 | 2022-05-04 | Ohio | 39 | 2697058 | 38428 |
43838 | 43838 | 2022-05-04 | Oklahoma | 40 | 1041397 | 14271 |
43839 | 43839 | 2022-05-04 | Oregon | 41 | 726612 | 7519 |
43840 | 43840 | 2022-05-04 | Pennsylvania | 42 | 2827882 | 44733 |
43841 | 43841 | 2022-05-04 | Puerto Rico | 72 | 583847 | 4217 |
43842 | 43842 | 2022-05-04 | Rhode Island | 44 | 374181 | 3541 |
43843 | 43843 | 2022-05-04 | South Carolina | 45 | 1477345 | 17847 |
43844 | 43844 | 2022-05-04 | South Dakota | 46 | 238185 | 2915 |
43845 | 43845 | 2022-05-04 | Tennessee | 47 | 1983580 | 25922 |
43846 | 43846 | 2022-05-04 | Texas | 48 | 6761264 | 88334 |
43847 | 43847 | 2022-05-04 | Utah | 49 | 932480 | 4747 |
43848 | 43848 | 2022-05-04 | Vermont | 50 | 125347 | 639 |
43849 | 43849 | 2022-05-04 | Virgin Islands | 78 | 16481 | 111 |
43850 | 43850 | 2022-05-04 | Virginia | 51 | 1710272 | 20256 |
43851 | 43851 | 2022-05-04 | Washington | 53 | 1508710 | 12767 |
43852 | 43852 | 2022-05-04 | West Virginia | 54 | 502192 | 6872 |
43853 | 43853 | 2022-05-04 | Wisconsin | 55 | 1618029 | 14442 |
43854 | 43854 | 2022-05-04 | Wyoming | 56 | 156745 | 1814 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );