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-04-13 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 56
- 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
- Nevada 1
- New Hampshire 1
- New Jersey 1
- New Mexico 1
- New York 1
- North Carolina 1
- North Dakota 1
- Northern Mariana Islands 1
- Ohio 1
- Oklahoma 1
- Oregon 1
- Pennsylvania 1
- Puerto Rico 1
- Rhode Island 1
- South Carolina 1
- South Dakota 1
- Tennessee 1
- Texas 1
- Utah 1
- Vermont 1
- Virgin Islands 1
- Virginia 1
- Washington 1
- West Virginia 1
- Wisconsin 1
- Wyoming 1
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
42623 | 42623 | 2022-04-13 | Alabama | 1 | 1297461 | 19441 |
42624 | 42624 | 2022-04-13 | Alaska | 2 | 248375 | 1196 |
42625 | 42625 | 2022-04-13 | American Samoa | 60 | 5341 | 12 |
42626 | 42626 | 2022-04-13 | Arizona | 4 | 2016797 | 29823 |
42627 | 42627 | 2022-04-13 | Arkansas | 5 | 833948 | 11325 |
42628 | 42628 | 2022-04-13 | California | 6 | 9136777 | 89554 |
42629 | 42629 | 2022-04-13 | Colorado | 8 | 1367421 | 12243 |
42630 | 42630 | 2022-04-13 | Connecticut | 9 | 744052 | 10809 |
42631 | 42631 | 2022-04-13 | Delaware | 10 | 259570 | 2884 |
42632 | 42632 | 2022-04-13 | District of Columbia | 11 | 139160 | 1333 |
42633 | 42633 | 2022-04-13 | Florida | 12 | 5872586 | 73622 |
42634 | 42634 | 2022-04-13 | Georgia | 13 | 2435807 | 35999 |
42635 | 42635 | 2022-04-13 | Guam | 66 | 48624 | 353 |
42636 | 42636 | 2022-04-13 | Hawaii | 15 | 237097 | 1387 |
42637 | 42637 | 2022-04-13 | Idaho | 16 | 445002 | 4908 |
42638 | 42638 | 2022-04-13 | Illinois | 17 | 3094402 | 37800 |
42639 | 42639 | 2022-04-13 | Indiana | 18 | 1693567 | 23502 |
42640 | 42640 | 2022-04-13 | Iowa | 19 | 760293 | 9475 |
42641 | 42641 | 2022-04-13 | Kansas | 20 | 772058 | 8501 |
42642 | 42642 | 2022-04-13 | Kentucky | 21 | 1329496 | 15212 |
42643 | 42643 | 2022-04-13 | Louisiana | 22 | 1234146 | 17191 |
42644 | 42644 | 2022-04-13 | Maine | 23 | 238774 | 2276 |
42645 | 42645 | 2022-04-13 | Maryland | 24 | 1018190 | 14391 |
42646 | 42646 | 2022-04-13 | Massachusetts | 25 | 1718387 | 20167 |
42647 | 42647 | 2022-04-13 | Michigan | 26 | 2395209 | 35817 |
42648 | 42648 | 2022-04-13 | Minnesota | 27 | 1436154 | 12694 |
42649 | 42649 | 2022-04-13 | Mississippi | 28 | 796139 | 12420 |
42650 | 42650 | 2022-04-13 | Missouri | 29 | 1430048 | 20184 |
42651 | 42651 | 2022-04-13 | Montana | 30 | 273264 | 3259 |
42652 | 42652 | 2022-04-13 | Nebraska | 31 | 478332 | 4190 |
42653 | 42653 | 2022-04-13 | Nevada | 32 | 715377 | 10501 |
42654 | 42654 | 2022-04-13 | New Hampshire | 33 | 304793 | 2463 |
42655 | 42655 | 2022-04-13 | New Jersey | 34 | 2221058 | 33315 |
42656 | 42656 | 2022-04-13 | New Mexico | 35 | 519510 | 7392 |
42657 | 42657 | 2022-04-13 | New York | 36 | 5036645 | 67442 |
42658 | 42658 | 2022-04-13 | North Carolina | 37 | 2640677 | 23344 |
42659 | 42659 | 2022-04-13 | North Dakota | 38 | 240236 | 2301 |
42660 | 42660 | 2022-04-13 | Northern Mariana Islands | 69 | 11203 | 34 |
42661 | 42661 | 2022-04-13 | Ohio | 39 | 2676629 | 38166 |
42662 | 42662 | 2022-04-13 | Oklahoma | 40 | 1036495 | 14087 |
42663 | 42663 | 2022-04-13 | Oregon | 41 | 708522 | 7404 |
42664 | 42664 | 2022-04-13 | Pennsylvania | 42 | 2792250 | 44441 |
42665 | 42665 | 2022-04-13 | Puerto Rico | 72 | 522834 | 4182 |
42666 | 42666 | 2022-04-13 | Rhode Island | 44 | 365009 | 3527 |
42667 | 42667 | 2022-04-13 | South Carolina | 45 | 1470597 | 17698 |
42668 | 42668 | 2022-04-13 | South Dakota | 46 | 237370 | 2898 |
42669 | 42669 | 2022-04-13 | Tennessee | 47 | 1975044 | 25776 |
42670 | 42670 | 2022-04-13 | Texas | 48 | 6712724 | 87875 |
42671 | 42671 | 2022-04-13 | Utah | 49 | 928847 | 4730 |
42672 | 42672 | 2022-04-13 | Vermont | 50 | 118993 | 623 |
42673 | 42673 | 2022-04-13 | Virgin Islands | 78 | 15836 | 111 |
42674 | 42674 | 2022-04-13 | Virginia | 51 | 1680533 | 19953 |
42675 | 42675 | 2022-04-13 | Washington | 53 | 1472736 | 12643 |
42676 | 42676 | 2022-04-13 | West Virginia | 54 | 498643 | 6777 |
42677 | 42677 | 2022-04-13 | Wisconsin | 55 | 1593347 | 14380 |
42678 | 42678 | 2022-04-13 | Wyoming | 56 | 156258 | 1801 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );