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-07-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 |
---|---|---|---|---|---|---|
48559 | 48559 | 2022-07-28 | Alabama | 1 | 1421760 | 19890 |
48560 | 48560 | 2022-07-28 | Alaska | 2 | 281969 | 1270 |
48561 | 48561 | 2022-07-28 | American Samoa | 60 | 7471 | 33 |
48562 | 48562 | 2022-07-28 | Arizona | 4 | 2196429 | 30768 |
48563 | 48563 | 2022-07-28 | Arkansas | 5 | 901129 | 11699 |
48564 | 48564 | 2022-07-28 | California | 6 | 10656412 | 93508 |
48565 | 48565 | 2022-07-28 | Colorado | 8 | 1601498 | 13174 |
48566 | 48566 | 2022-07-28 | Connecticut | 9 | 852438 | 11102 |
48567 | 48567 | 2022-07-28 | Delaware | 10 | 293541 | 3024 |
48568 | 48568 | 2022-07-28 | District of Columbia | 11 | 162327 | 1364 |
48569 | 48569 | 2022-07-28 | Florida | 12 | 6778523 | 77377 |
48570 | 48570 | 2022-07-28 | Georgia | 13 | 2672553 | 37520 |
48571 | 48571 | 2022-07-28 | Guam | 66 | 56026 | 381 |
48572 | 48572 | 2022-07-28 | Hawaii | 15 | 317785 | 1568 |
48573 | 48573 | 2022-07-28 | Idaho | 16 | 477854 | 5033 |
48574 | 48574 | 2022-07-28 | Illinois | 17 | 3564043 | 38873 |
48575 | 48575 | 2022-07-28 | Indiana | 18 | 1823296 | 24086 |
48576 | 48576 | 2022-07-28 | Iowa | 19 | 817159 | 9782 |
48577 | 48577 | 2022-07-28 | Kansas | 20 | 835564 | 8986 |
48578 | 48578 | 2022-07-28 | Kentucky | 21 | 1468197 | 16352 |
48579 | 48579 | 2022-07-28 | Louisiana | 22 | 1375417 | 17562 |
48580 | 48580 | 2022-07-28 | Maine | 23 | 275482 | 2465 |
48581 | 48581 | 2022-07-28 | Maryland | 24 | 1177761 | 14973 |
48582 | 48582 | 2022-07-28 | Massachusetts | 25 | 1966919 | 21176 |
48583 | 48583 | 2022-07-28 | Michigan | 26 | 2672312 | 37428 |
48584 | 48584 | 2022-07-28 | Minnesota | 27 | 1590564 | 13293 |
48585 | 48585 | 2022-07-28 | Mississippi | 28 | 873857 | 12630 |
48586 | 48586 | 2022-07-28 | Missouri | 29 | 1572548 | 21074 |
48587 | 48587 | 2022-07-28 | Montana | 30 | 294850 | 3467 |
48588 | 48588 | 2022-07-28 | Nebraska | 31 | 515287 | 4366 |
48589 | 48589 | 2022-07-28 | Nevada | 32 | 826500 | 11221 |
48590 | 48590 | 2022-07-28 | New Hampshire | 33 | 338062 | 2625 |
48591 | 48591 | 2022-07-28 | New Jersey | 34 | 2587104 | 34256 |
48592 | 48592 | 2022-07-28 | New Mexico | 35 | 589993 | 8235 |
48593 | 48593 | 2022-07-28 | New York | 36 | 5793691 | 69564 |
48594 | 48594 | 2022-07-28 | North Carolina | 37 | 2983366 | 25493 |
48595 | 48595 | 2022-07-28 | North Dakota | 38 | 256545 | 2354 |
48596 | 48596 | 2022-07-28 | Northern Mariana Islands | 69 | 12720 | 37 |
48597 | 48597 | 2022-07-28 | Ohio | 39 | 2948242 | 39035 |
48598 | 48598 | 2022-07-28 | Oklahoma | 40 | 1120934 | 14576 |
48599 | 48599 | 2022-07-28 | Oregon | 41 | 848903 | 8072 |
48600 | 48600 | 2022-07-28 | Pennsylvania | 42 | 3080593 | 46164 |
48601 | 48601 | 2022-07-28 | Puerto Rico | 72 | 877142 | 4748 |
48602 | 48602 | 2022-07-28 | Rhode Island | 44 | 410066 | 3630 |
48603 | 48603 | 2022-07-28 | South Carolina | 45 | 1605165 | 18192 |
48604 | 48604 | 2022-07-28 | South Dakota | 46 | 250286 | 2956 |
48605 | 48605 | 2022-07-28 | Tennessee | 47 | 2142053 | 26714 |
48606 | 48606 | 2022-07-28 | Texas | 48 | 7429581 | 89399 |
48607 | 48607 | 2022-07-28 | Utah | 49 | 1010550 | 4900 |
48608 | 48608 | 2022-07-28 | Vermont | 50 | 137649 | 693 |
48609 | 48609 | 2022-07-28 | Virgin Islands | 78 | 21677 | 120 |
48610 | 48610 | 2022-07-28 | Virginia | 51 | 1950818 | 20905 |
48611 | 48611 | 2022-07-28 | Washington | 53 | 1729964 | 13643 |
48612 | 48612 | 2022-07-28 | West Virginia | 54 | 554215 | 7149 |
48613 | 48613 | 2022-07-28 | Wisconsin | 55 | 1775581 | 14921 |
48614 | 48614 | 2022-07-28 | Wyoming | 56 | 170031 | 1856 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );