ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where "date" is on date 2021-07-16 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- Alabama 1
- Alaska 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
- Nevada 1
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
27515 | 27515 | 2021-07-16 | Alabama | 1 | 558577 | 11442 |
27516 | 27516 | 2021-07-16 | Alaska | 2 | 71826 | 364 |
27517 | 27517 | 2021-07-16 | Arizona | 4 | 906116 | 18100 |
27518 | 27518 | 2021-07-16 | Arkansas | 5 | 362580 | 5992 |
27519 | 27519 | 2021-07-16 | California | 6 | 3930518 | 64083 |
27520 | 27520 | 2021-07-16 | Colorado | 8 | 568469 | 7031 |
27521 | 27521 | 2021-07-16 | Connecticut | 9 | 350675 | 8282 |
27522 | 27522 | 2021-07-16 | Delaware | 10 | 110270 | 1697 |
27523 | 27523 | 2021-07-16 | District of Columbia | 11 | 49652 | 1146 |
27524 | 27524 | 2021-07-16 | Florida | 12 | 2406809 | 38388 |
27525 | 27525 | 2021-07-16 | Georgia | 13 | 1121132 | 20862 |
27526 | 27526 | 2021-07-16 | Guam | 66 | 9446 | 143 |
27527 | 27527 | 2021-07-16 | Hawaii | 15 | 37455 | 520 |
27528 | 27528 | 2021-07-16 | Idaho | 16 | 196935 | 2174 |
27529 | 27529 | 2021-07-16 | Illinois | 17 | 1403989 | 25823 |
27530 | 27530 | 2021-07-16 | Indiana | 18 | 763522 | 13940 |
27531 | 27531 | 2021-07-16 | Iowa | 19 | 375321 | 6158 |
27532 | 27532 | 2021-07-16 | Kansas | 20 | 324738 | 5232 |
27533 | 27533 | 2021-07-16 | Kentucky | 21 | 470538 | 7328 |
27534 | 27534 | 2021-07-16 | Louisiana | 22 | 495945 | 10828 |
27535 | 27535 | 2021-07-16 | Maine | 23 | 69418 | 878 |
27536 | 27536 | 2021-07-16 | Maryland | 24 | 464065 | 9778 |
27537 | 27537 | 2021-07-16 | Massachusetts | 25 | 712272 | 18020 |
27538 | 27538 | 2021-07-16 | Michigan | 26 | 1002006 | 21095 |
27539 | 27539 | 2021-07-16 | Minnesota | 27 | 607617 | 7728 |
27540 | 27540 | 2021-07-16 | Mississippi | 28 | 326804 | 7465 |
27541 | 27541 | 2021-07-16 | Missouri | 29 | 659027 | 10103 |
27542 | 27542 | 2021-07-16 | Montana | 30 | 114772 | 1691 |
27543 | 27543 | 2021-07-16 | Nebraska | 31 | 225861 | 2536 |
27544 | 27544 | 2021-07-16 | Nevada | 32 | 343096 | 5758 |
27545 | 27545 | 2021-07-16 | New Hampshire | 33 | 99907 | 1381 |
27546 | 27546 | 2021-07-16 | New Jersey | 34 | 1027954 | 26531 |
27547 | 27547 | 2021-07-16 | New Mexico | 35 | 207189 | 4381 |
27548 | 27548 | 2021-07-16 | New York | 36 | 2122158 | 53176 |
27549 | 27549 | 2021-07-16 | North Carolina | 37 | 1023968 | 13533 |
27550 | 27550 | 2021-07-16 | North Dakota | 38 | 111006 | 1567 |
27551 | 27551 | 2021-07-16 | Northern Mariana Islands | 69 | 187 | 2 |
27552 | 27552 | 2021-07-16 | Ohio | 39 | 1116322 | 20437 |
27553 | 27553 | 2021-07-16 | Oklahoma | 40 | 464607 | 7417 |
27554 | 27554 | 2021-07-16 | Oregon | 41 | 212030 | 2848 |
27555 | 27555 | 2021-07-16 | Pennsylvania | 42 | 1220060 | 27786 |
27556 | 27556 | 2021-07-16 | Puerto Rico | 72 | 174899 | 2560 |
27557 | 27557 | 2021-07-16 | Rhode Island | 44 | 152971 | 2736 |
27558 | 27558 | 2021-07-16 | South Carolina | 45 | 601803 | 9862 |
27559 | 27559 | 2021-07-16 | South Dakota | 46 | 124750 | 2040 |
27560 | 27560 | 2021-07-16 | Tennessee | 47 | 860701 | 12538 |
27561 | 27561 | 2021-07-16 | Texas | 48 | 3030756 | 52919 |
27562 | 27562 | 2021-07-16 | Utah | 49 | 422714 | 2413 |
27563 | 27563 | 2021-07-16 | Vermont | 50 | 24550 | 258 |
27564 | 27564 | 2021-07-16 | Virgin Islands | 78 | 4119 | 32 |
27565 | 27565 | 2021-07-16 | Virginia | 51 | 684499 | 11477 |
27566 | 27566 | 2021-07-16 | Washington | 53 | 461401 | 6093 |
27567 | 27567 | 2021-07-16 | West Virginia | 54 | 164933 | 2919 |
27568 | 27568 | 2021-07-16 | Wisconsin | 55 | 680034 | 8209 |
27569 | 27569 | 2021-07-16 | Wyoming | 56 | 63523 | 760 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );