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-12-26 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|
57015 | 57015 | 2022-12-26 | Alabama | 1 | 1568934 | 21208 |
57016 | 57016 | 2022-12-26 | Alaska | 2 | 301449 | 1408 |
57017 | 57017 | 2022-12-26 | American Samoa | 60 | 8266 | 34 |
57018 | 57018 | 2022-12-26 | Arizona | 4 | 2373361 | 32038 |
57019 | 57019 | 2022-12-26 | Arkansas | 5 | 981964 | 12690 |
57020 | 57020 | 2022-12-26 | California | 6 | 11772585 | 100628 |
57021 | 57021 | 2022-12-26 | Colorado | 8 | 1731721 | 13859 |
57022 | 57022 | 2022-12-26 | Connecticut | 9 | 944755 | 11733 |
57023 | 57023 | 2022-12-26 | Delaware | 10 | 320581 | 3205 |
57024 | 57024 | 2022-12-26 | District of Columbia | 11 | 173626 | 1411 |
57025 | 57025 | 2022-12-26 | Florida | 12 | 7269428 | 83606 |
57026 | 57026 | 2022-12-26 | Georgia | 13 | 2888123 | 39913 |
57027 | 57027 | 2022-12-26 | Guam | 66 | 60727 | 412 |
57028 | 57028 | 2022-12-26 | Hawaii | 15 | 362117 | 1755 |
57029 | 57029 | 2022-12-26 | Idaho | 16 | 510661 | 5316 |
57030 | 57030 | 2022-12-26 | Illinois | 17 | 3960888 | 40610 |
57031 | 57031 | 2022-12-26 | Indiana | 18 | 1996253 | 25303 |
57032 | 57032 | 2022-12-26 | Iowa | 19 | 884263 | 10389 |
57033 | 57033 | 2022-12-26 | Kansas | 20 | 914344 | 9850 |
57034 | 57034 | 2022-12-26 | Kentucky | 21 | 1657664 | 17708 |
57035 | 57035 | 2022-12-26 | Louisiana | 22 | 1507707 | 18345 |
57036 | 57036 | 2022-12-26 | Maine | 23 | 305600 | 2803 |
57037 | 57037 | 2022-12-26 | Maryland | 24 | 1311672 | 15985 |
57038 | 57038 | 2022-12-26 | Massachusetts | 25 | 2144967 | 22793 |
57039 | 57039 | 2022-12-26 | Michigan | 26 | 2977727 | 40659 |
57040 | 57040 | 2022-12-26 | Minnesota | 27 | 1731172 | 14273 |
57041 | 57041 | 2022-12-26 | Mississippi | 28 | 951070 | 13113 |
57042 | 57042 | 2022-12-26 | Missouri | 29 | 1736293 | 23252 |
57043 | 57043 | 2022-12-26 | Montana | 30 | 322437 | 3635 |
57044 | 57044 | 2022-12-26 | Nebraska | 31 | 554953 | 4841 |
57045 | 57045 | 2022-12-26 | Nevada | 32 | 874117 | 11838 |
57046 | 57046 | 2022-12-26 | New Hampshire | 33 | 366116 | 2851 |
57047 | 57047 | 2022-12-26 | New Jersey | 34 | 2908733 | 35446 |
57048 | 57048 | 2022-12-26 | New Mexico | 35 | 657140 | 8802 |
57049 | 57049 | 2022-12-26 | New York | 36 | 6529668 | 77546 |
57050 | 57050 | 2022-12-26 | North Carolina | 37 | 3316814 | 28789 |
57051 | 57051 | 2022-12-26 | North Dakota | 38 | 280043 | 2469 |
57052 | 57052 | 2022-12-26 | Northern Mariana Islands | 69 | 13236 | 41 |
57053 | 57053 | 2022-12-26 | Ohio | 39 | 3294521 | 40949 |
57054 | 57054 | 2022-12-26 | Oklahoma | 40 | 1244121 | 16041 |
57055 | 57055 | 2022-12-26 | Oregon | 41 | 936721 | 8953 |
57056 | 57056 | 2022-12-26 | Pennsylvania | 42 | 3403953 | 48881 |
57057 | 57057 | 2022-12-26 | Puerto Rico | 72 | 1079676 | 5506 |
57058 | 57058 | 2022-12-26 | Rhode Island | 44 | 443645 | 3800 |
57059 | 57059 | 2022-12-26 | South Carolina | 45 | 1760204 | 19368 |
57060 | 57060 | 2022-12-26 | South Dakota | 46 | 271433 | 3136 |
57061 | 57061 | 2022-12-26 | Tennessee | 47 | 2358463 | 28262 |
57062 | 57062 | 2022-12-26 | Texas | 48 | 8080404 | 92628 |
57063 | 57063 | 2022-12-26 | Utah | 49 | 1072888 | 5177 |
57064 | 57064 | 2022-12-26 | Vermont | 50 | 148031 | 791 |
57065 | 57065 | 2022-12-26 | Virgin Islands | 78 | 23734 | 127 |
57066 | 57066 | 2022-12-26 | Virginia | 51 | 2195634 | 22782 |
57067 | 57067 | 2022-12-26 | Washington | 53 | 1879139 | 15021 |
57068 | 57068 | 2022-12-26 | West Virginia | 54 | 621614 | 7786 |
57069 | 57069 | 2022-12-26 | Wisconsin | 55 | 1954481 | 15826 |
57070 | 57070 | 2022-12-26 | Wyoming | 56 | 182581 | 1959 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );