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-04-19 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 |
---|---|---|---|---|---|---|
42959 | 42959 | 2022-04-19 | Alabama | 1 | 1298473 | 19513 |
42960 | 42960 | 2022-04-19 | Alaska | 2 | 248375 | 1196 |
42961 | 42961 | 2022-04-19 | American Samoa | 60 | 5517 | 12 |
42962 | 42962 | 2022-04-19 | Arizona | 4 | 2016797 | 29823 |
42963 | 42963 | 2022-04-19 | Arkansas | 5 | 834361 | 11354 |
42964 | 42964 | 2022-04-19 | California | 6 | 9171994 | 89877 |
42965 | 42965 | 2022-04-19 | Colorado | 8 | 1375284 | 12249 |
42966 | 42966 | 2022-04-19 | Connecticut | 9 | 748773 | 10813 |
42967 | 42967 | 2022-04-19 | Delaware | 10 | 260566 | 2896 |
42968 | 42968 | 2022-04-19 | District of Columbia | 11 | 139772 | 1333 |
42969 | 42969 | 2022-04-19 | Florida | 12 | 5888264 | 73738 |
42970 | 42970 | 2022-04-19 | Georgia | 13 | 2437291 | 36087 |
42971 | 42971 | 2022-04-19 | Guam | 66 | 48795 | 355 |
42972 | 42972 | 2022-04-19 | Hawaii | 15 | 237097 | 1387 |
42973 | 42973 | 2022-04-19 | Idaho | 16 | 445275 | 4917 |
42974 | 42974 | 2022-04-19 | Illinois | 17 | 3108399 | 37830 |
42975 | 42975 | 2022-04-19 | Indiana | 18 | 1694955 | 23523 |
42976 | 42976 | 2022-04-19 | Iowa | 19 | 761116 | 9475 |
42977 | 42977 | 2022-04-19 | Kansas | 20 | 773332 | 8524 |
42978 | 42978 | 2022-04-19 | Kentucky | 21 | 1332829 | 15318 |
42979 | 42979 | 2022-04-19 | Louisiana | 22 | 1235421 | 17207 |
42980 | 42980 | 2022-04-19 | Maine | 23 | 240086 | 2276 |
42981 | 42981 | 2022-04-19 | Maryland | 24 | 1022489 | 14407 |
42982 | 42982 | 2022-04-19 | Massachusetts | 25 | 1731170 | 20181 |
42983 | 42983 | 2022-04-19 | Michigan | 26 | 2400990 | 35857 |
42984 | 42984 | 2022-04-19 | Minnesota | 27 | 1440553 | 12722 |
42985 | 42985 | 2022-04-19 | Mississippi | 28 | 796546 | 12429 |
42986 | 42986 | 2022-04-19 | Missouri | 29 | 1431039 | 20187 |
42987 | 42987 | 2022-04-19 | Montana | 30 | 273530 | 3261 |
42988 | 42988 | 2022-04-19 | Nebraska | 31 | 478716 | 4194 |
42989 | 42989 | 2022-04-19 | Nevada | 32 | 716157 | 10682 |
42990 | 42990 | 2022-04-19 | New Hampshire | 33 | 306369 | 2471 |
42991 | 42991 | 2022-04-19 | New Jersey | 34 | 2232789 | 33349 |
42992 | 42992 | 2022-04-19 | New Mexico | 35 | 520402 | 7429 |
42993 | 42993 | 2022-04-19 | New York | 36 | 5073609 | 67507 |
42994 | 42994 | 2022-04-19 | North Carolina | 37 | 2641201 | 23344 |
42995 | 42995 | 2022-04-19 | North Dakota | 38 | 240434 | 2304 |
42996 | 42996 | 2022-04-19 | Northern Mariana Islands | 69 | 11221 | 34 |
42997 | 42997 | 2022-04-19 | Ohio | 39 | 2681437 | 38266 |
42998 | 42998 | 2022-04-19 | Oklahoma | 40 | 1038301 | 14173 |
42999 | 42999 | 2022-04-19 | Oregon | 41 | 711827 | 7461 |
43000 | 43000 | 2022-04-19 | Pennsylvania | 42 | 2800317 | 44539 |
43001 | 43001 | 2022-04-19 | Puerto Rico | 72 | 530825 | 4186 |
43002 | 43002 | 2022-04-19 | Rhode Island | 44 | 367095 | 3532 |
43003 | 43003 | 2022-04-19 | South Carolina | 45 | 1472093 | 17734 |
43004 | 43004 | 2022-04-19 | South Dakota | 46 | 237370 | 2898 |
43005 | 43005 | 2022-04-19 | Tennessee | 47 | 1976936 | 25844 |
43006 | 43006 | 2022-04-19 | Texas | 48 | 6725205 | 88079 |
43007 | 43007 | 2022-04-19 | Utah | 49 | 929587 | 4736 |
43008 | 43008 | 2022-04-19 | Vermont | 50 | 120503 | 626 |
43009 | 43009 | 2022-04-19 | Virgin Islands | 78 | 15928 | 111 |
43010 | 43010 | 2022-04-19 | Virginia | 51 | 1686861 | 20071 |
43011 | 43011 | 2022-04-19 | Washington | 53 | 1478705 | 12676 |
43012 | 43012 | 2022-04-19 | West Virginia | 54 | 499288 | 6804 |
43013 | 43013 | 2022-04-19 | Wisconsin | 55 | 1597347 | 14395 |
43014 | 43014 | 2022-04-19 | Wyoming | 56 | 156392 | 1807 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );