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-14 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 |
---|---|---|---|---|---|---|
42679 | 42679 | 2022-04-14 | Alabama | 1 | 1297649 | 19475 |
42680 | 42680 | 2022-04-14 | Alaska | 2 | 248375 | 1196 |
42681 | 42681 | 2022-04-14 | American Samoa | 60 | 5517 | 12 |
42682 | 42682 | 2022-04-14 | Arizona | 4 | 2016797 | 29823 |
42683 | 42683 | 2022-04-14 | Arkansas | 5 | 834037 | 11332 |
42684 | 42684 | 2022-04-14 | California | 6 | 9151205 | 89629 |
42685 | 42685 | 2022-04-14 | Colorado | 8 | 1369106 | 12222 |
42686 | 42686 | 2022-04-14 | Connecticut | 9 | 744459 | 10809 |
42687 | 42687 | 2022-04-14 | Delaware | 10 | 259796 | 2884 |
42688 | 42688 | 2022-04-14 | District of Columbia | 11 | 139160 | 1333 |
42689 | 42689 | 2022-04-14 | Florida | 12 | 5875505 | 73656 |
42690 | 42690 | 2022-04-14 | Georgia | 13 | 2436297 | 36042 |
42691 | 42691 | 2022-04-14 | Guam | 66 | 48651 | 355 |
42692 | 42692 | 2022-04-14 | Hawaii | 15 | 237097 | 1387 |
42693 | 42693 | 2022-04-14 | Idaho | 16 | 445107 | 4914 |
42694 | 42694 | 2022-04-14 | Illinois | 17 | 3097741 | 37806 |
42695 | 42695 | 2022-04-14 | Indiana | 18 | 1693565 | 23509 |
42696 | 42696 | 2022-04-14 | Iowa | 19 | 760377 | 9475 |
42697 | 42697 | 2022-04-14 | Kansas | 20 | 772058 | 8501 |
42698 | 42698 | 2022-04-14 | Kentucky | 21 | 1329565 | 15212 |
42699 | 42699 | 2022-04-14 | Louisiana | 22 | 1234650 | 17194 |
42700 | 42700 | 2022-04-14 | Maine | 23 | 239130 | 2276 |
42701 | 42701 | 2022-04-14 | Maryland | 24 | 1018965 | 14395 |
42702 | 42702 | 2022-04-14 | Massachusetts | 25 | 1721642 | 20169 |
42703 | 42703 | 2022-04-14 | Michigan | 26 | 2395209 | 35817 |
42704 | 42704 | 2022-04-14 | Minnesota | 27 | 1437016 | 12708 |
42705 | 42705 | 2022-04-14 | Mississippi | 28 | 796262 | 12421 |
42706 | 42706 | 2022-04-14 | Missouri | 29 | 1430223 | 20186 |
42707 | 42707 | 2022-04-14 | Montana | 30 | 273299 | 3260 |
42708 | 42708 | 2022-04-14 | Nebraska | 31 | 478417 | 4191 |
42709 | 42709 | 2022-04-14 | Nevada | 32 | 715498 | 10501 |
42710 | 42710 | 2022-04-14 | New Hampshire | 33 | 305119 | 2464 |
42711 | 42711 | 2022-04-14 | New Jersey | 34 | 2223788 | 33324 |
42712 | 42712 | 2022-04-14 | New Mexico | 35 | 519681 | 7402 |
42713 | 42713 | 2022-04-14 | New York | 36 | 5044079 | 67447 |
42714 | 42714 | 2022-04-14 | North Carolina | 37 | 2640677 | 23344 |
42715 | 42715 | 2022-04-14 | North Dakota | 38 | 240312 | 2304 |
42716 | 42716 | 2022-04-14 | Northern Mariana Islands | 69 | 11203 | 34 |
42717 | 42717 | 2022-04-14 | Ohio | 39 | 2681437 | 38266 |
42718 | 42718 | 2022-04-14 | Oklahoma | 40 | 1036495 | 14166 |
42719 | 42719 | 2022-04-14 | Oregon | 41 | 709125 | 7427 |
42720 | 42720 | 2022-04-14 | Pennsylvania | 42 | 2793978 | 44464 |
42721 | 42721 | 2022-04-14 | Puerto Rico | 72 | 524566 | 4184 |
42722 | 42722 | 2022-04-14 | Rhode Island | 44 | 365548 | 3527 |
42723 | 42723 | 2022-04-14 | South Carolina | 45 | 1470597 | 17698 |
42724 | 42724 | 2022-04-14 | South Dakota | 46 | 237370 | 2898 |
42725 | 42725 | 2022-04-14 | Tennessee | 47 | 1975364 | 25837 |
42726 | 42726 | 2022-04-14 | Texas | 48 | 6715756 | 87896 |
42727 | 42727 | 2022-04-14 | Utah | 49 | 929587 | 4736 |
42728 | 42728 | 2022-04-14 | Vermont | 50 | 119339 | 623 |
42729 | 42729 | 2022-04-14 | Virgin Islands | 78 | 15872 | 111 |
42730 | 42730 | 2022-04-14 | Virginia | 51 | 1681729 | 19988 |
42731 | 42731 | 2022-04-14 | Washington | 53 | 1472774 | 12643 |
42732 | 42732 | 2022-04-14 | West Virginia | 54 | 498773 | 6791 |
42733 | 42733 | 2022-04-14 | Wisconsin | 55 | 1594304 | 14383 |
42734 | 42734 | 2022-04-14 | 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 );