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-01-28 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 |
---|---|---|---|---|---|---|
38423 | 38423 | 2022-01-28 | Alabama | 1 | 1153149 | 16826 |
38424 | 38424 | 2022-01-28 | Alaska | 2 | 211117 | 1057 |
38425 | 38425 | 2022-01-28 | American Samoa | 60 | 18 | 0 |
38426 | 38426 | 2022-01-28 | Arizona | 4 | 1829406 | 26001 |
38427 | 38427 | 2022-01-28 | Arkansas | 5 | 768061 | 9622 |
38428 | 38428 | 2022-01-28 | California | 6 | 8248681 | 79934 |
38429 | 38429 | 2022-01-28 | Colorado | 8 | 1245392 | 11259 |
38430 | 38430 | 2022-01-28 | Connecticut | 9 | 696070 | 9985 |
38431 | 38431 | 2022-01-28 | Delaware | 10 | 246037 | 2498 |
38432 | 38432 | 2022-01-28 | District of Columbia | 11 | 129817 | 1284 |
38433 | 38433 | 2022-01-28 | Florida | 12 | 5478894 | 64955 |
38434 | 38434 | 2022-01-28 | Georgia | 13 | 2281370 | 31595 |
38435 | 38435 | 2022-01-28 | Guam | 66 | 32007 | 286 |
38436 | 38436 | 2022-01-28 | Hawaii | 15 | 208253 | 1161 |
38437 | 38437 | 2022-01-28 | Idaho | 16 | 376095 | 4400 |
38438 | 38438 | 2022-01-28 | Illinois | 17 | 2901790 | 34439 |
38439 | 38439 | 2022-01-28 | Indiana | 18 | 1607951 | 21301 |
38440 | 38440 | 2022-01-28 | Iowa | 19 | 703366 | 8501 |
38441 | 38441 | 2022-01-28 | Kansas | 20 | 723285 | 7550 |
38442 | 38442 | 2022-01-28 | Kentucky | 21 | 1152288 | 12905 |
38443 | 38443 | 2022-01-28 | Louisiana | 22 | 1160130 | 15631 |
38444 | 38444 | 2022-01-28 | Maine | 23 | 172952 | 1733 |
38445 | 38445 | 2022-01-28 | Maryland | 24 | 950136 | 13387 |
38446 | 38446 | 2022-01-28 | Massachusetts | 25 | 1598451 | 21909 |
38447 | 38447 | 2022-01-28 | Michigan | 26 | 2229405 | 32159 |
38448 | 38448 | 2022-01-28 | Minnesota | 27 | 1309815 | 11532 |
38449 | 38449 | 2022-01-28 | Mississippi | 28 | 717666 | 10831 |
38450 | 38450 | 2022-01-28 | Missouri | 29 | 1330080 | 17392 |
38451 | 38451 | 2022-01-28 | Montana | 30 | 239559 | 2997 |
38452 | 38452 | 2022-01-28 | Nebraska | 31 | 435358 | 3666 |
38453 | 38453 | 2022-01-28 | Nevada | 32 | 648088 | 8914 |
38454 | 38454 | 2022-01-28 | New Hampshire | 33 | 272492 | 2205 |
38455 | 38455 | 2022-01-28 | New Jersey | 34 | 2102227 | 31320 |
38456 | 38456 | 2022-01-28 | New Mexico | 35 | 470513 | 6419 |
38457 | 38457 | 2022-01-28 | New York | 36 | 4761590 | 63910 |
38458 | 38458 | 2022-01-28 | North Carolina | 37 | 2373587 | 20605 |
38459 | 38459 | 2022-01-28 | North Dakota | 38 | 221072 | 2140 |
38460 | 38460 | 2022-01-28 | Northern Mariana Islands | 69 | 4692 | 23 |
38461 | 38461 | 2022-01-28 | Ohio | 39 | 2562412 | 33071 |
38462 | 38462 | 2022-01-28 | Oklahoma | 40 | 953116 | 12044 |
38463 | 38463 | 2022-01-28 | Oregon | 41 | 620653 | 6086 |
38464 | 38464 | 2022-01-28 | Pennsylvania | 42 | 2637080 | 40394 |
38465 | 38465 | 2022-01-28 | Puerto Rico | 72 | 487284 | 3809 |
38466 | 38466 | 2022-01-28 | Rhode Island | 44 | 341407 | 3302 |
38467 | 38467 | 2022-01-28 | South Carolina | 45 | 1355116 | 15266 |
38468 | 38468 | 2022-01-28 | South Dakota | 46 | 225383 | 2637 |
38469 | 38469 | 2022-01-28 | Tennessee | 47 | 1785235 | 22158 |
38470 | 38470 | 2022-01-28 | Texas | 48 | 6122432 | 79324 |
38471 | 38471 | 2022-01-28 | Utah | 49 | 875414 | 4107 |
38472 | 38472 | 2022-01-28 | Vermont | 50 | 103066 | 532 |
38473 | 38473 | 2022-01-28 | Virgin Islands | 78 | 14802 | 99 |
38474 | 38474 | 2022-01-28 | Virginia | 51 | 1525603 | 16127 |
38475 | 38475 | 2022-01-28 | Washington | 53 | 1294536 | 10756 |
38476 | 38476 | 2022-01-28 | West Virginia | 54 | 438889 | 5743 |
38477 | 38477 | 2022-01-28 | Wisconsin | 55 | 1503538 | 12291 |
38478 | 38478 | 2022-01-28 | Wyoming | 56 | 144526 | 1625 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );