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-10-19 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 |
---|---|---|---|---|---|---|
53207 | 53207 | 2022-10-19 | Alabama | 1 | 1530803 | 20526 |
53208 | 53208 | 2022-10-19 | Alaska | 2 | 298095 | 1350 |
53209 | 53209 | 2022-10-19 | American Samoa | 60 | 8251 | 34 |
53210 | 53210 | 2022-10-19 | Arizona | 4 | 2283073 | 31514 |
53211 | 53211 | 2022-10-19 | Arkansas | 5 | 956857 | 12396 |
53212 | 53212 | 2022-10-19 | California | 6 | 11321488 | 96519 |
53213 | 53213 | 2022-10-19 | Colorado | 8 | 1673522 | 13583 |
53214 | 53214 | 2022-10-19 | Connecticut | 9 | 907476 | 11423 |
53215 | 53215 | 2022-10-19 | Delaware | 10 | 311698 | 3136 |
53216 | 53216 | 2022-10-19 | District of Columbia | 11 | 169149 | 1392 |
53217 | 53217 | 2022-10-19 | Florida | 12 | 7145833 | 82065 |
53218 | 53218 | 2022-10-19 | Georgia | 13 | 2832383 | 38986 |
53219 | 53219 | 2022-10-19 | Guam | 66 | 59672 | 402 |
53220 | 53220 | 2022-10-19 | Hawaii | 15 | 351768 | 1699 |
53221 | 53221 | 2022-10-19 | Idaho | 16 | 498876 | 5206 |
53222 | 53222 | 2022-10-19 | Illinois | 17 | 3796917 | 39875 |
53223 | 53223 | 2022-10-19 | Indiana | 18 | 1933102 | 24816 |
53224 | 53224 | 2022-10-19 | Iowa | 19 | 861010 | 10153 |
53225 | 53225 | 2022-10-19 | Kansas | 20 | 886124 | 9615 |
53226 | 53226 | 2022-10-19 | Kentucky | 21 | 1606537 | 17191 |
53227 | 53227 | 2022-10-19 | Louisiana | 22 | 1459866 | 18138 |
53228 | 53228 | 2022-10-19 | Maine | 23 | 294893 | 2629 |
53229 | 53229 | 2022-10-19 | Maryland | 24 | 1262107 | 15497 |
53230 | 53230 | 2022-10-19 | Massachusetts | 25 | 2069848 | 21841 |
53231 | 53231 | 2022-10-19 | Michigan | 26 | 2874009 | 39092 |
53232 | 53232 | 2022-10-19 | Minnesota | 27 | 1676151 | 13738 |
53233 | 53233 | 2022-10-19 | Mississippi | 28 | 930438 | 12945 |
53234 | 53234 | 2022-10-19 | Missouri | 29 | 1678111 | 21791 |
53235 | 53235 | 2022-10-19 | Montana | 30 | 313126 | 3566 |
53236 | 53236 | 2022-10-19 | Nebraska | 31 | 540345 | 4559 |
53237 | 53237 | 2022-10-19 | Nevada | 32 | 850204 | 11544 |
53238 | 53238 | 2022-10-19 | New Hampshire | 33 | 354923 | 2725 |
53239 | 53239 | 2022-10-19 | New Jersey | 34 | 2775804 | 34851 |
53240 | 53240 | 2022-10-19 | New Mexico | 35 | 623531 | 8609 |
53241 | 53241 | 2022-10-19 | New York | 36 | 6188598 | 71589 |
53242 | 53242 | 2022-10-19 | North Carolina | 37 | 3220858 | 26895 |
53243 | 53243 | 2022-10-19 | North Dakota | 38 | 271085 | 2434 |
53244 | 53244 | 2022-10-19 | Northern Mariana Islands | 69 | 13171 | 40 |
53245 | 53245 | 2022-10-19 | Ohio | 39 | 3162278 | 40037 |
53246 | 53246 | 2022-10-19 | Oklahoma | 40 | 1205519 | 14924 |
53247 | 53247 | 2022-10-19 | Oregon | 41 | 905882 | 8645 |
53248 | 53248 | 2022-10-19 | Pennsylvania | 42 | 3291589 | 47582 |
53249 | 53249 | 2022-10-19 | Puerto Rico | 72 | 1003619 | 5220 |
53250 | 53250 | 2022-10-19 | Rhode Island | 44 | 428874 | 3681 |
53251 | 53251 | 2022-10-19 | South Carolina | 45 | 1718600 | 18527 |
53252 | 53252 | 2022-10-19 | South Dakota | 46 | 263468 | 3049 |
53253 | 53253 | 2022-10-19 | Tennessee | 47 | 2293313 | 27735 |
53254 | 53254 | 2022-10-19 | Texas | 48 | 7906550 | 91182 |
53255 | 53255 | 2022-10-19 | Utah | 49 | 1041933 | 5034 |
53256 | 53256 | 2022-10-19 | Vermont | 50 | 144346 | 734 |
53257 | 53257 | 2022-10-19 | Virgin Islands | 78 | 23276 | 123 |
53258 | 53258 | 2022-10-19 | Virginia | 51 | 2107801 | 22077 |
53259 | 53259 | 2022-10-19 | Washington | 53 | 1830765 | 14525 |
53260 | 53260 | 2022-10-19 | West Virginia | 54 | 605322 | 7479 |
53261 | 53261 | 2022-10-19 | Wisconsin | 55 | 1885525 | 15379 |
53262 | 53262 | 2022-10-19 | Wyoming | 56 | 178032 | 1906 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );