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-08-27 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|
29825 | 29825 | 2021-08-27 | Alabama | 1 | 681828 | 12153 |
29826 | 29826 | 2021-08-27 | Alaska | 2 | 86055 | 421 |
29827 | 29827 | 2021-08-27 | Arizona | 4 | 1001871 | 18724 |
29828 | 29828 | 2021-08-27 | Arkansas | 5 | 446430 | 6836 |
29829 | 29829 | 2021-08-27 | California | 6 | 4396238 | 65605 |
29830 | 29830 | 2021-08-27 | Colorado | 8 | 612786 | 7280 |
29831 | 29831 | 2021-08-27 | Connecticut | 9 | 370708 | 8358 |
29832 | 29832 | 2021-08-27 | Delaware | 10 | 118544 | 1875 |
29833 | 29833 | 2021-08-27 | District of Columbia | 11 | 54556 | 1159 |
29834 | 29834 | 2021-08-27 | Florida | 12 | 3179714 | 43979 |
29835 | 29835 | 2021-08-27 | Georgia | 13 | 1339537 | 21826 |
29836 | 29836 | 2021-08-27 | Guam | 66 | 11015 | 146 |
29837 | 29837 | 2021-08-27 | Hawaii | 15 | 57509 | 579 |
29838 | 29838 | 2021-08-27 | Idaho | 16 | 217961 | 2328 |
29839 | 29839 | 2021-08-27 | Illinois | 17 | 1512387 | 26420 |
29840 | 29840 | 2021-08-27 | Indiana | 18 | 847057 | 14373 |
29841 | 29841 | 2021-08-27 | Iowa | 19 | 400082 | 6268 |
29842 | 29842 | 2021-08-27 | Kansas | 20 | 366848 | 5575 |
29843 | 29843 | 2021-08-27 | Kentucky | 21 | 564438 | 7739 |
29844 | 29844 | 2021-08-27 | Louisiana | 22 | 679796 | 12359 |
29845 | 29845 | 2021-08-27 | Maine | 23 | 74966 | 928 |
29846 | 29846 | 2021-08-27 | Maryland | 24 | 492770 | 9971 |
29847 | 29847 | 2021-08-27 | Massachusetts | 25 | 753795 | 18219 |
29848 | 29848 | 2021-08-27 | Michigan | 26 | 1053009 | 21509 |
29849 | 29849 | 2021-08-27 | Minnesota | 27 | 644283 | 7892 |
29850 | 29850 | 2021-08-27 | Mississippi | 28 | 427640 | 8279 |
29851 | 29851 | 2021-08-27 | Missouri | 29 | 767331 | 11110 |
29852 | 29852 | 2021-08-27 | Montana | 30 | 125730 | 1783 |
29853 | 29853 | 2021-08-27 | Nebraska | 31 | 241671 | 2584 |
29854 | 29854 | 2021-08-27 | Nevada | 32 | 386559 | 6433 |
29855 | 29855 | 2021-08-27 | New Hampshire | 33 | 106525 | 1415 |
29856 | 29856 | 2021-08-27 | New Jersey | 34 | 1084546 | 26826 |
29857 | 29857 | 2021-08-27 | New Mexico | 35 | 229509 | 4507 |
29858 | 29858 | 2021-08-27 | New York | 36 | 2258143 | 53745 |
29859 | 29859 | 2021-08-27 | North Carolina | 37 | 1191456 | 14334 |
29860 | 29860 | 2021-08-27 | North Dakota | 38 | 116337 | 1592 |
29861 | 29861 | 2021-08-27 | Northern Mariana Islands | 69 | 234 | 2 |
29862 | 29862 | 2021-08-27 | Ohio | 39 | 1202728 | 20799 |
29863 | 29863 | 2021-08-27 | Oklahoma | 40 | 542412 | 7812 |
29864 | 29864 | 2021-08-27 | Oregon | 41 | 268401 | 3130 |
29865 | 29865 | 2021-08-27 | Pennsylvania | 42 | 1288041 | 28180 |
29866 | 29866 | 2021-08-27 | Puerto Rico | 72 | 201679 | 2804 |
29867 | 29867 | 2021-08-27 | Rhode Island | 44 | 161701 | 2764 |
29868 | 29868 | 2021-08-27 | South Carolina | 45 | 714265 | 10452 |
29869 | 29869 | 2021-08-27 | South Dakota | 46 | 130776 | 2062 |
29870 | 29870 | 2021-08-27 | Tennessee | 47 | 1003567 | 13241 |
29871 | 29871 | 2021-08-27 | Texas | 48 | 3548371 | 56519 |
29872 | 29872 | 2021-08-27 | Utah | 49 | 459953 | 2623 |
29873 | 29873 | 2021-08-27 | Vermont | 50 | 27648 | 275 |
29874 | 29874 | 2021-08-27 | Virgin Islands | 78 | 5760 | 53 |
29875 | 29875 | 2021-08-27 | Virginia | 51 | 754652 | 11769 |
29876 | 29876 | 2021-08-27 | Washington | 53 | 553077 | 6567 |
29877 | 29877 | 2021-08-27 | West Virginia | 54 | 184682 | 3054 |
29878 | 29878 | 2021-08-27 | Wisconsin | 55 | 727515 | 8438 |
29879 | 29879 | 2021-08-27 | Wyoming | 56 | 73467 | 835 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );