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-02-19 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 |
---|---|---|---|---|---|---|
39655 | 39655 | 2022-02-19 | Alabama | 1 | 1272608 | 17933 |
39656 | 39656 | 2022-02-19 | Alaska | 2 | 234541 | 1108 |
39657 | 39657 | 2022-02-19 | American Samoa | 60 | 57 | 0 |
39658 | 39658 | 2022-02-19 | Arizona | 4 | 1965659 | 27618 |
39659 | 39659 | 2022-02-19 | Arkansas | 5 | 813925 | 10291 |
39660 | 39660 | 2022-02-19 | California | 6 | 8888971 | 84020 |
39661 | 39661 | 2022-02-19 | Colorado | 8 | 1307537 | 11915 |
39662 | 39662 | 2022-02-19 | Connecticut | 9 | 719327 | 10357 |
39663 | 39663 | 2022-02-19 | Delaware | 10 | 254946 | 2695 |
39664 | 39664 | 2022-02-19 | District of Columbia | 11 | 133697 | 1314 |
39665 | 39665 | 2022-02-19 | Florida | 12 | 5780682 | 68902 |
39666 | 39666 | 2022-02-19 | Georgia | 13 | 2381751 | 33411 |
39667 | 39667 | 2022-02-19 | Guam | 66 | 43193 | 317 |
39668 | 39668 | 2022-02-19 | Hawaii | 15 | 228425 | 1297 |
39669 | 39669 | 2022-02-19 | Idaho | 16 | 414604 | 4678 |
39670 | 39670 | 2022-02-19 | Illinois | 17 | 3019048 | 36360 |
39671 | 39671 | 2022-02-19 | Indiana | 18 | 1678232 | 22529 |
39672 | 39672 | 2022-02-19 | Iowa | 19 | 745530 | 8948 |
39673 | 39673 | 2022-02-19 | Kansas | 20 | 762769 | 7928 |
39674 | 39674 | 2022-02-19 | Kentucky | 21 | 1270477 | 13609 |
39675 | 39675 | 2022-02-19 | Louisiana | 22 | 1219464 | 16400 |
39676 | 39676 | 2022-02-19 | Maine | 23 | 213770 | 1960 |
39677 | 39677 | 2022-02-19 | Maryland | 24 | 997309 | 14003 |
39678 | 39678 | 2022-02-19 | Massachusetts | 25 | 1661206 | 23109 |
39679 | 39679 | 2022-02-19 | Michigan | 26 | 2331762 | 33832 |
39680 | 39680 | 2022-02-19 | Minnesota | 27 | 1404832 | 12131 |
39681 | 39681 | 2022-02-19 | Mississippi | 28 | 785528 | 11836 |
39682 | 39682 | 2022-02-19 | Missouri | 29 | 1404551 | 18598 |
39683 | 39683 | 2022-02-19 | Montana | 30 | 262221 | 3107 |
39684 | 39684 | 2022-02-19 | Nebraska | 31 | 452601 | 3883 |
39685 | 39685 | 2022-02-19 | Nevada | 32 | 677345 | 9508 |
39686 | 39686 | 2022-02-19 | New Hampshire | 33 | 293697 | 2333 |
39687 | 39687 | 2022-02-19 | New Jersey | 34 | 2156697 | 32697 |
39688 | 39688 | 2022-02-19 | New Mexico | 35 | 507323 | 6777 |
39689 | 39689 | 2022-02-19 | New York | 36 | 4888802 | 66322 |
39690 | 39690 | 2022-02-19 | North Carolina | 37 | 2560860 | 22158 |
39691 | 39691 | 2022-02-19 | North Dakota | 38 | 236784 | 2221 |
39692 | 39692 | 2022-02-19 | Northern Mariana Islands | 69 | 8422 | 25 |
39693 | 39693 | 2022-02-19 | Ohio | 39 | 2643929 | 35493 |
39694 | 39694 | 2022-02-19 | Oklahoma | 40 | 1013287 | 12767 |
39695 | 39695 | 2022-02-19 | Oregon | 41 | 685953 | 6456 |
39696 | 39696 | 2022-02-19 | Pennsylvania | 42 | 2742752 | 42686 |
39697 | 39697 | 2022-02-19 | Puerto Rico | 72 | 504847 | 4078 |
39698 | 39698 | 2022-02-19 | Rhode Island | 44 | 354045 | 3397 |
39699 | 39699 | 2022-02-19 | South Carolina | 45 | 1449637 | 16533 |
39700 | 39700 | 2022-02-19 | South Dakota | 46 | 234961 | 2772 |
39701 | 39701 | 2022-02-19 | Tennessee | 47 | 1942537 | 23695 |
39702 | 39702 | 2022-02-19 | Texas | 48 | 6522401 | 83782 |
39703 | 39703 | 2022-02-19 | Utah | 49 | 918402 | 4359 |
39704 | 39704 | 2022-02-19 | Vermont | 50 | 110679 | 583 |
39705 | 39705 | 2022-02-19 | Virgin Islands | 78 | 15255 | 108 |
39706 | 39706 | 2022-02-19 | Virginia | 51 | 1622685 | 18016 |
39707 | 39707 | 2022-02-19 | Washington | 53 | 1410803 | 11706 |
39708 | 39708 | 2022-02-19 | West Virginia | 54 | 481818 | 6162 |
39709 | 39709 | 2022-02-19 | Wisconsin | 55 | 1564600 | 13068 |
39710 | 39710 | 2022-02-19 | Wyoming | 56 | 154082 | 1689 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );