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-08-26 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 |
---|---|---|---|---|---|---|
50183 | 50183 | 2022-08-26 | Alabama | 1 | 1479605 | 20048 |
50184 | 50184 | 2022-08-26 | Alaska | 2 | 291395 | 1297 |
50185 | 50185 | 2022-08-26 | American Samoa | 60 | 7471 | 33 |
50186 | 50186 | 2022-08-26 | Arizona | 4 | 2245713 | 31047 |
50187 | 50187 | 2022-08-26 | Arkansas | 5 | 928253 | 11895 |
50188 | 50188 | 2022-08-26 | California | 6 | 11054444 | 94913 |
50189 | 50189 | 2022-08-26 | Colorado | 8 | 1634099 | 13344 |
50190 | 50190 | 2022-08-26 | Connecticut | 9 | 872624 | 11197 |
50191 | 50191 | 2022-08-26 | Delaware | 10 | 301797 | 3042 |
50192 | 50192 | 2022-08-26 | District of Columbia | 11 | 165774 | 1381 |
50193 | 50193 | 2022-08-26 | Florida | 12 | 6998561 | 79573 |
50194 | 50194 | 2022-08-26 | Georgia | 13 | 2770967 | 38080 |
50195 | 50195 | 2022-08-26 | Guam | 66 | 58645 | 390 |
50196 | 50196 | 2022-08-26 | Hawaii | 15 | 329351 | 1629 |
50197 | 50197 | 2022-08-26 | Idaho | 16 | 488173 | 5110 |
50198 | 50198 | 2022-08-26 | Illinois | 17 | 3676762 | 39284 |
50199 | 50199 | 2022-08-26 | Indiana | 18 | 1887358 | 24378 |
50200 | 50200 | 2022-08-26 | Iowa | 19 | 838125 | 9907 |
50201 | 50201 | 2022-08-26 | Kansas | 20 | 859190 | 8976 |
50202 | 50202 | 2022-08-26 | Kentucky | 21 | 1538002 | 16603 |
50203 | 50203 | 2022-08-26 | Louisiana | 22 | 1422451 | 17843 |
50204 | 50204 | 2022-08-26 | Maine | 23 | 281807 | 2507 |
50205 | 50205 | 2022-08-26 | Maryland | 24 | 1218315 | 15151 |
50206 | 50206 | 2022-08-26 | Massachusetts | 25 | 2005250 | 21390 |
50207 | 50207 | 2022-08-26 | Michigan | 26 | 2751201 | 37909 |
50208 | 50208 | 2022-08-26 | Minnesota | 27 | 1630819 | 13429 |
50209 | 50209 | 2022-08-26 | Mississippi | 28 | 904905 | 12766 |
50210 | 50210 | 2022-08-26 | Missouri | 29 | 1625994 | 21427 |
50211 | 50211 | 2022-08-26 | Montana | 30 | 304417 | 3504 |
50212 | 50212 | 2022-08-26 | Nebraska | 31 | 527989 | 4455 |
50213 | 50213 | 2022-08-26 | Nevada | 32 | 839977 | 11379 |
50214 | 50214 | 2022-08-26 | New Hampshire | 33 | 343486 | 2657 |
50215 | 50215 | 2022-08-26 | New Jersey | 34 | 2666991 | 34520 |
50216 | 50216 | 2022-08-26 | New Mexico | 35 | 609204 | 8401 |
50217 | 50217 | 2022-08-26 | New York | 36 | 5956144 | 70290 |
50218 | 50218 | 2022-08-26 | North Carolina | 37 | 3098923 | 25853 |
50219 | 50219 | 2022-08-26 | North Dakota | 38 | 263918 | 2393 |
50220 | 50220 | 2022-08-26 | Northern Mariana Islands | 69 | 13050 | 40 |
50221 | 50221 | 2022-08-26 | Ohio | 39 | 3049546 | 39406 |
50222 | 50222 | 2022-08-26 | Oklahoma | 40 | 1163366 | 14670 |
50223 | 50223 | 2022-08-26 | Oregon | 41 | 875409 | 8383 |
50224 | 50224 | 2022-08-26 | Pennsylvania | 42 | 3167638 | 46596 |
50225 | 50225 | 2022-08-26 | Puerto Rico | 72 | 948866 | 4940 |
50226 | 50226 | 2022-08-26 | Rhode Island | 44 | 416638 | 3643 |
50227 | 50227 | 2022-08-26 | South Carolina | 45 | 1661020 | 18245 |
50228 | 50228 | 2022-08-26 | South Dakota | 46 | 256255 | 2984 |
50229 | 50229 | 2022-08-26 | Tennessee | 47 | 2227924 | 27113 |
50230 | 50230 | 2022-08-26 | Texas | 48 | 7700317 | 90268 |
50231 | 50231 | 2022-08-26 | Utah | 49 | 1027083 | 4968 |
50232 | 50232 | 2022-08-26 | Vermont | 50 | 139769 | 707 |
50233 | 50233 | 2022-08-26 | Virgin Islands | 78 | 22481 | 122 |
50234 | 50234 | 2022-08-26 | Virginia | 51 | 2028479 | 21356 |
50235 | 50235 | 2022-08-26 | Washington | 53 | 1779422 | 14044 |
50236 | 50236 | 2022-08-26 | West Virginia | 54 | 578535 | 7268 |
50237 | 50237 | 2022-08-26 | Wisconsin | 55 | 1826088 | 15042 |
50238 | 50238 | 2022-08-26 | Wyoming | 56 | 174213 | 1877 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );