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-27 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 |
---|---|---|---|---|---|---|
50239 | 50239 | 2022-08-27 | Alabama | 1 | 1479605 | 20048 |
50240 | 50240 | 2022-08-27 | Alaska | 2 | 291395 | 1297 |
50241 | 50241 | 2022-08-27 | American Samoa | 60 | 7471 | 33 |
50242 | 50242 | 2022-08-27 | Arizona | 4 | 2245713 | 31047 |
50243 | 50243 | 2022-08-27 | Arkansas | 5 | 929156 | 11905 |
50244 | 50244 | 2022-08-27 | California | 6 | 11054444 | 94913 |
50245 | 50245 | 2022-08-27 | Colorado | 8 | 1634099 | 13344 |
50246 | 50246 | 2022-08-27 | Connecticut | 9 | 872624 | 11197 |
50247 | 50247 | 2022-08-27 | Delaware | 10 | 301797 | 3042 |
50248 | 50248 | 2022-08-27 | District of Columbia | 11 | 165774 | 1381 |
50249 | 50249 | 2022-08-27 | Florida | 12 | 6998561 | 79573 |
50250 | 50250 | 2022-08-27 | Georgia | 13 | 2770967 | 38080 |
50251 | 50251 | 2022-08-27 | Guam | 66 | 58645 | 390 |
50252 | 50252 | 2022-08-27 | Hawaii | 15 | 329351 | 1629 |
50253 | 50253 | 2022-08-27 | Idaho | 16 | 488173 | 5110 |
50254 | 50254 | 2022-08-27 | Illinois | 17 | 3676762 | 39284 |
50255 | 50255 | 2022-08-27 | Indiana | 18 | 1887358 | 24378 |
50256 | 50256 | 2022-08-27 | Iowa | 19 | 838125 | 9907 |
50257 | 50257 | 2022-08-27 | Kansas | 20 | 859190 | 8976 |
50258 | 50258 | 2022-08-27 | Kentucky | 21 | 1538002 | 16603 |
50259 | 50259 | 2022-08-27 | Louisiana | 22 | 1422451 | 17843 |
50260 | 50260 | 2022-08-27 | Maine | 23 | 282106 | 2508 |
50261 | 50261 | 2022-08-27 | Maryland | 24 | 1218584 | 15151 |
50262 | 50262 | 2022-08-27 | Massachusetts | 25 | 2005250 | 21390 |
50263 | 50263 | 2022-08-27 | Michigan | 26 | 2751201 | 37909 |
50264 | 50264 | 2022-08-27 | Minnesota | 27 | 1630819 | 13429 |
50265 | 50265 | 2022-08-27 | Mississippi | 28 | 904905 | 12766 |
50266 | 50266 | 2022-08-27 | Missouri | 29 | 1625994 | 21427 |
50267 | 50267 | 2022-08-27 | Montana | 30 | 304417 | 3504 |
50268 | 50268 | 2022-08-27 | Nebraska | 31 | 527989 | 4455 |
50269 | 50269 | 2022-08-27 | Nevada | 32 | 839977 | 11379 |
50270 | 50270 | 2022-08-27 | New Hampshire | 33 | 343486 | 2657 |
50271 | 50271 | 2022-08-27 | New Jersey | 34 | 2669786 | 34529 |
50272 | 50272 | 2022-08-27 | New Mexico | 35 | 609204 | 8401 |
50273 | 50273 | 2022-08-27 | New York | 36 | 5958345 | 70290 |
50274 | 50274 | 2022-08-27 | North Carolina | 37 | 3098923 | 25853 |
50275 | 50275 | 2022-08-27 | North Dakota | 38 | 263918 | 2393 |
50276 | 50276 | 2022-08-27 | Northern Mariana Islands | 69 | 13050 | 40 |
50277 | 50277 | 2022-08-27 | Ohio | 39 | 3049546 | 39406 |
50278 | 50278 | 2022-08-27 | Oklahoma | 40 | 1163366 | 14670 |
50279 | 50279 | 2022-08-27 | Oregon | 41 | 875409 | 8383 |
50280 | 50280 | 2022-08-27 | Pennsylvania | 42 | 3167638 | 46596 |
50281 | 50281 | 2022-08-27 | Puerto Rico | 72 | 951222 | 4950 |
50282 | 50282 | 2022-08-27 | Rhode Island | 44 | 416638 | 3643 |
50283 | 50283 | 2022-08-27 | South Carolina | 45 | 1661020 | 18245 |
50284 | 50284 | 2022-08-27 | South Dakota | 46 | 256255 | 2984 |
50285 | 50285 | 2022-08-27 | Tennessee | 47 | 2227924 | 27113 |
50286 | 50286 | 2022-08-27 | Texas | 48 | 7700317 | 90268 |
50287 | 50287 | 2022-08-27 | Utah | 49 | 1027083 | 4968 |
50288 | 50288 | 2022-08-27 | Vermont | 50 | 139769 | 707 |
50289 | 50289 | 2022-08-27 | Virgin Islands | 78 | 22481 | 122 |
50290 | 50290 | 2022-08-27 | Virginia | 51 | 2028479 | 21356 |
50291 | 50291 | 2022-08-27 | Washington | 53 | 1779422 | 14044 |
50292 | 50292 | 2022-08-27 | West Virginia | 54 | 578535 | 7268 |
50293 | 50293 | 2022-08-27 | Wisconsin | 55 | 1826088 | 15042 |
50294 | 50294 | 2022-08-27 | 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 );