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-03-31 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 55
- 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
- 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 |
---|---|---|---|---|---|---|
21630 | 21630 | 2021-03-31 | Alabama | 1 | 515388 | 10554 |
21631 | 21631 | 2021-03-31 | Alaska | 2 | 62559 | 299 |
21632 | 21632 | 2021-03-31 | Arizona | 4 | 841811 | 16967 |
21633 | 21633 | 2021-03-31 | Arkansas | 5 | 330398 | 5626 |
21634 | 21634 | 2021-03-31 | California | 6 | 3669048 | 59260 |
21635 | 21635 | 2021-03-31 | Colorado | 8 | 464782 | 6175 |
21636 | 21636 | 2021-03-31 | Connecticut | 9 | 310888 | 7886 |
21637 | 21637 | 2021-03-31 | Delaware | 10 | 94802 | 1559 |
21638 | 21638 | 2021-03-31 | District of Columbia | 11 | 44513 | 1064 |
21639 | 21639 | 2021-03-31 | Florida | 12 | 2057727 | 33424 |
21640 | 21640 | 2021-03-31 | Georgia | 13 | 1035186 | 18473 |
21641 | 21641 | 2021-03-31 | Guam | 66 | 8776 | 135 |
21642 | 21642 | 2021-03-31 | Hawaii | 15 | 29779 | 460 |
21643 | 21643 | 2021-03-31 | Idaho | 16 | 180643 | 1965 |
21644 | 21644 | 2021-03-31 | Illinois | 17 | 1248133 | 23579 |
21645 | 21645 | 2021-03-31 | Indiana | 18 | 689785 | 13039 |
21646 | 21646 | 2021-03-31 | Iowa | 19 | 351402 | 5743 |
21647 | 21647 | 2021-03-31 | Kansas | 20 | 304657 | 4913 |
21648 | 21648 | 2021-03-31 | Kentucky | 21 | 430116 | 6151 |
21649 | 21649 | 2021-03-31 | Louisiana | 22 | 444933 | 10141 |
21650 | 21650 | 2021-03-31 | Maine | 23 | 50504 | 743 |
21651 | 21651 | 2021-03-31 | Maryland | 24 | 411529 | 8286 |
21652 | 21652 | 2021-03-31 | Massachusetts | 25 | 635580 | 17185 |
21653 | 21653 | 2021-03-31 | Michigan | 26 | 744823 | 17112 |
21654 | 21654 | 2021-03-31 | Minnesota | 27 | 519607 | 6926 |
21655 | 21655 | 2021-03-31 | Mississippi | 28 | 305146 | 7032 |
21656 | 21656 | 2021-03-31 | Missouri | 29 | 588900 | 8977 |
21657 | 21657 | 2021-03-31 | Montana | 30 | 104677 | 1437 |
21658 | 21658 | 2021-03-31 | Nebraska | 31 | 209602 | 2282 |
21659 | 21659 | 2021-03-31 | Nevada | 32 | 303799 | 5249 |
21660 | 21660 | 2021-03-31 | New Hampshire | 33 | 84176 | 1238 |
21661 | 21661 | 2021-03-31 | New Jersey | 34 | 908812 | 24528 |
21662 | 21662 | 2021-03-31 | New Mexico | 35 | 191652 | 3939 |
21663 | 21663 | 2021-03-31 | New York | 36 | 1871595 | 49790 |
21664 | 21664 | 2021-03-31 | North Carolina | 37 | 915456 | 12137 |
21665 | 21665 | 2021-03-31 | North Dakota | 38 | 103123 | 1498 |
21666 | 21666 | 2021-03-31 | Northern Mariana Islands | 69 | 159 | 2 |
21667 | 21667 | 2021-03-31 | Ohio | 39 | 1017566 | 18609 |
21668 | 21668 | 2021-03-31 | Oklahoma | 40 | 438364 | 4953 |
21669 | 21669 | 2021-03-31 | Oregon | 41 | 165013 | 2396 |
21670 | 21670 | 2021-03-31 | Pennsylvania | 42 | 1030415 | 25150 |
21671 | 21671 | 2021-03-31 | Puerto Rico | 72 | 140720 | 2113 |
21672 | 21672 | 2021-03-31 | Rhode Island | 44 | 137329 | 2619 |
21673 | 21673 | 2021-03-31 | South Carolina | 45 | 551630 | 9146 |
21674 | 21674 | 2021-03-31 | South Dakota | 46 | 117759 | 1935 |
21675 | 21675 | 2021-03-31 | Tennessee | 47 | 797531 | 11798 |
21676 | 21676 | 2021-03-31 | Texas | 48 | 2790030 | 48540 |
21677 | 21677 | 2021-03-31 | Utah | 49 | 385700 | 2122 |
21678 | 21678 | 2021-03-31 | Vermont | 50 | 19275 | 227 |
21679 | 21679 | 2021-03-31 | Virgin Islands | 78 | 2907 | 26 |
21680 | 21680 | 2021-03-31 | Virginia | 51 | 618976 | 10252 |
21681 | 21681 | 2021-03-31 | Washington | 53 | 366907 | 5309 |
21682 | 21682 | 2021-03-31 | West Virginia | 54 | 141738 | 2676 |
21683 | 21683 | 2021-03-31 | Wisconsin | 55 | 636250 | 7316 |
21684 | 21684 | 2021-03-31 | Wyoming | 56 | 56310 | 700 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );