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-05-27 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- 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
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
24765 | 24765 | 2021-05-27 | Alabama | 1 | 543177 | 11140 |
24766 | 24766 | 2021-05-27 | Alaska | 2 | 69583 | 352 |
24767 | 24767 | 2021-05-27 | Arizona | 4 | 879102 | 17594 |
24768 | 24768 | 2021-05-27 | Arkansas | 5 | 340916 | 5829 |
24769 | 24769 | 2021-05-27 | California | 6 | 3786674 | 63163 |
24770 | 24770 | 2021-05-27 | Colorado | 8 | 543886 | 6688 |
24771 | 24771 | 2021-05-27 | Connecticut | 9 | 347137 | 8230 |
24772 | 24772 | 2021-05-27 | Delaware | 10 | 108607 | 1660 |
24773 | 24773 | 2021-05-27 | District of Columbia | 11 | 48844 | 1132 |
24774 | 24774 | 2021-05-27 | Florida | 12 | 2318472 | 36732 |
24775 | 24775 | 2021-05-27 | Georgia | 13 | 1097547 | 20122 |
24776 | 24776 | 2021-05-27 | Guam | 66 | 9123 | 140 |
24777 | 24777 | 2021-05-27 | Hawaii | 15 | 34807 | 495 |
24778 | 24778 | 2021-05-27 | Idaho | 16 | 191949 | 2092 |
24779 | 24779 | 2021-05-27 | Illinois | 17 | 1383335 | 25101 |
24780 | 24780 | 2021-05-27 | Indiana | 18 | 745688 | 13583 |
24781 | 24781 | 2021-05-27 | Iowa | 19 | 371138 | 6048 |
24782 | 24782 | 2021-05-27 | Kansas | 20 | 315649 | 5099 |
24783 | 24783 | 2021-05-27 | Kentucky | 21 | 459425 | 6908 |
24784 | 24784 | 2021-05-27 | Louisiana | 22 | 470331 | 10570 |
24785 | 24785 | 2021-05-27 | Maine | 23 | 67416 | 825 |
24786 | 24786 | 2021-05-27 | Maryland | 24 | 459308 | 9581 |
24787 | 24787 | 2021-05-27 | Massachusetts | 25 | 706272 | 17850 |
24788 | 24788 | 2021-05-27 | Michigan | 26 | 988892 | 20287 |
24789 | 24789 | 2021-05-27 | Minnesota | 27 | 600501 | 7496 |
24790 | 24790 | 2021-05-27 | Mississippi | 28 | 317276 | 7304 |
24791 | 24791 | 2021-05-27 | Missouri | 29 | 614040 | 9664 |
24792 | 24792 | 2021-05-27 | Montana | 30 | 111713 | 1610 |
24793 | 24793 | 2021-05-27 | Nebraska | 31 | 223264 | 2378 |
24794 | 24794 | 2021-05-27 | Nevada | 32 | 323481 | 5578 |
24795 | 24795 | 2021-05-27 | New Hampshire | 33 | 98613 | 1349 |
24796 | 24796 | 2021-05-27 | New Jersey | 34 | 1015368 | 26173 |
24797 | 24797 | 2021-05-27 | New Mexico | 35 | 202701 | 4261 |
24798 | 24798 | 2021-05-27 | New York | 36 | 2097465 | 52685 |
24799 | 24799 | 2021-05-27 | North Carolina | 37 | 1001048 | 13075 |
24800 | 24800 | 2021-05-27 | North Dakota | 38 | 109851 | 1541 |
24801 | 24801 | 2021-05-27 | Northern Mariana Islands | 69 | 181 | 2 |
24802 | 24802 | 2021-05-27 | Ohio | 39 | 1100312 | 19753 |
24803 | 24803 | 2021-05-27 | Oklahoma | 40 | 452633 | 7291 |
24804 | 24804 | 2021-05-27 | Oregon | 41 | 200219 | 2679 |
24805 | 24805 | 2021-05-27 | Pennsylvania | 42 | 1204359 | 27219 |
24806 | 24806 | 2021-05-27 | Puerto Rico | 72 | 171832 | 2489 |
24807 | 24807 | 2021-05-27 | Rhode Island | 44 | 151691 | 2708 |
24808 | 24808 | 2021-05-27 | South Carolina | 45 | 592243 | 9711 |
24809 | 24809 | 2021-05-27 | South Dakota | 46 | 124105 | 2004 |
24810 | 24810 | 2021-05-27 | Tennessee | 47 | 847710 | 12328 |
24811 | 24811 | 2021-05-27 | Texas | 48 | 2945297 | 51572 |
24812 | 24812 | 2021-05-27 | Utah | 49 | 405457 | 2294 |
24813 | 24813 | 2021-05-27 | Vermont | 50 | 24182 | 255 |
24814 | 24814 | 2021-05-27 | Virgin Islands | 78 | 3399 | 27 |
24815 | 24815 | 2021-05-27 | Virginia | 51 | 674439 | 11152 |
24816 | 24816 | 2021-05-27 | Washington | 53 | 435680 | 5798 |
24817 | 24817 | 2021-05-27 | West Virginia | 54 | 161046 | 2792 |
24818 | 24818 | 2021-05-27 | Wisconsin | 55 | 673951 | 7814 |
24819 | 24819 | 2021-05-27 | Wyoming | 56 | 60048 | 719 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );