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-20 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- 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
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
43015 | 43015 | 2022-04-20 | Alabama | 1 | 1298626 | 19524 |
43016 | 43016 | 2022-04-20 | Alaska | 2 | 249901 | 1209 |
43017 | 43017 | 2022-04-20 | American Samoa | 60 | 5517 | 12 |
43018 | 43018 | 2022-04-20 | Arizona | 4 | 2019174 | 29852 |
43019 | 43019 | 2022-04-20 | Arkansas | 5 | 834553 | 11360 |
43020 | 43020 | 2022-04-20 | California | 6 | 9173336 | 89915 |
43021 | 43021 | 2022-04-20 | Colorado | 8 | 1376583 | 12242 |
43022 | 43022 | 2022-04-20 | Connecticut | 9 | 749783 | 10825 |
43023 | 43023 | 2022-04-20 | Delaware | 10 | 260735 | 2896 |
43024 | 43024 | 2022-04-20 | District of Columbia | 11 | 140674 | 1333 |
43025 | 43025 | 2022-04-20 | Florida | 12 | 5891834 | 73759 |
43026 | 43026 | 2022-04-20 | Georgia | 13 | 2439765 | 36217 |
43027 | 43027 | 2022-04-20 | Guam | 66 | 48840 | 355 |
43028 | 43028 | 2022-04-20 | Hawaii | 15 | 238763 | 1404 |
43029 | 43029 | 2022-04-20 | Idaho | 16 | 445454 | 4921 |
43030 | 43030 | 2022-04-20 | Illinois | 17 | 3112315 | 37840 |
43031 | 43031 | 2022-04-20 | Indiana | 18 | 1695736 | 23523 |
43032 | 43032 | 2022-04-20 | Iowa | 19 | 761356 | 9510 |
43033 | 43033 | 2022-04-20 | Kansas | 20 | 773333 | 8524 |
43034 | 43034 | 2022-04-20 | Kentucky | 21 | 1332898 | 15318 |
43035 | 43035 | 2022-04-20 | Louisiana | 22 | 1235683 | 17213 |
43036 | 43036 | 2022-04-20 | Maine | 23 | 240810 | 2277 |
43037 | 43037 | 2022-04-20 | Maryland | 24 | 1023125 | 14412 |
43038 | 43038 | 2022-04-20 | Massachusetts | 25 | 1733156 | 20208 |
43039 | 43039 | 2022-04-20 | Michigan | 26 | 2405644 | 35895 |
43040 | 43040 | 2022-04-20 | Minnesota | 27 | 1441539 | 12739 |
43041 | 43041 | 2022-04-20 | Mississippi | 28 | 796645 | 12432 |
43042 | 43042 | 2022-04-20 | Missouri | 29 | 1431255 | 20192 |
43043 | 43043 | 2022-04-20 | Montana | 30 | 273616 | 3262 |
43044 | 43044 | 2022-04-20 | Nebraska | 31 | 478811 | 4195 |
43045 | 43045 | 2022-04-20 | Nevada | 32 | 716548 | 10684 |
43046 | 43046 | 2022-04-20 | New Hampshire | 33 | 306724 | 2472 |
43047 | 43047 | 2022-04-20 | New Jersey | 34 | 2235034 | 33356 |
43048 | 43048 | 2022-04-20 | New Mexico | 35 | 520591 | 7436 |
43049 | 43049 | 2022-04-20 | New York | 36 | 5080508 | 67525 |
43050 | 43050 | 2022-04-20 | North Carolina | 37 | 2649255 | 23373 |
43051 | 43051 | 2022-04-20 | North Dakota | 38 | 240529 | 2304 |
43052 | 43052 | 2022-04-20 | Northern Mariana Islands | 69 | 11221 | 34 |
43053 | 43053 | 2022-04-20 | Ohio | 39 | 2681437 | 38266 |
43054 | 43054 | 2022-04-20 | Oklahoma | 40 | 1038301 | 14173 |
43055 | 43055 | 2022-04-20 | Oregon | 41 | 712686 | 7468 |
43056 | 43056 | 2022-04-20 | Pennsylvania | 42 | 2801534 | 44550 |
43057 | 43057 | 2022-04-20 | Puerto Rico | 72 | 533154 | 4188 |
43058 | 43058 | 2022-04-20 | Rhode Island | 44 | 367413 | 3532 |
43059 | 43059 | 2022-04-20 | South Carolina | 45 | 1472093 | 17734 |
43060 | 43060 | 2022-04-20 | South Dakota | 46 | 237535 | 2901 |
43061 | 43061 | 2022-04-20 | Tennessee | 47 | 1977268 | 25841 |
43062 | 43062 | 2022-04-20 | Texas | 48 | 6727842 | 88121 |
43063 | 43063 | 2022-04-20 | Utah | 49 | 929587 | 4736 |
43064 | 43064 | 2022-04-20 | Vermont | 50 | 120847 | 626 |
43065 | 43065 | 2022-04-20 | Virgin Islands | 78 | 15928 | 111 |
43066 | 43066 | 2022-04-20 | Virginia | 51 | 1688068 | 20099 |
43067 | 43067 | 2022-04-20 | Washington | 53 | 1480490 | 12703 |
43068 | 43068 | 2022-04-20 | West Virginia | 54 | 499445 | 6807 |
43069 | 43069 | 2022-04-20 | Wisconsin | 55 | 1599011 | 14399 |
43070 | 43070 | 2022-04-20 | 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 );