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 2020-06-17 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 |
---|---|---|---|---|---|---|
5845 | 5845 | 2020-06-17 | Alabama | 1 | 27312 | 790 |
5846 | 5846 | 2020-06-17 | Alaska | 2 | 776 | 10 |
5847 | 5847 | 2020-06-17 | Arizona | 4 | 41159 | 1252 |
5848 | 5848 | 2020-06-17 | Arkansas | 5 | 13606 | 197 |
5849 | 5849 | 2020-06-17 | California | 6 | 163381 | 5283 |
5850 | 5850 | 2020-06-17 | Colorado | 8 | 29658 | 1631 |
5851 | 5851 | 2020-06-17 | Connecticut | 9 | 45429 | 4219 |
5852 | 5852 | 2020-06-17 | Delaware | 10 | 10444 | 426 |
5853 | 5853 | 2020-06-17 | District of Columbia | 11 | 9847 | 523 |
5854 | 5854 | 2020-06-17 | Florida | 12 | 82711 | 3017 |
5855 | 5855 | 2020-06-17 | Georgia | 13 | 57217 | 2536 |
5856 | 5856 | 2020-06-17 | Guam | 66 | 1157 | 6 |
5857 | 5857 | 2020-06-17 | Hawaii | 15 | 732 | 17 |
5858 | 5858 | 2020-06-17 | Idaho | 16 | 3634 | 89 |
5859 | 5859 | 2020-06-17 | Illinois | 17 | 135416 | 6687 |
5860 | 5860 | 2020-06-17 | Indiana | 18 | 42036 | 2475 |
5861 | 5861 | 2020-06-17 | Iowa | 19 | 24616 | 677 |
5862 | 5862 | 2020-06-17 | Kansas | 20 | 11801 | 248 |
5863 | 5863 | 2020-06-17 | Kentucky | 21 | 13190 | 536 |
5864 | 5864 | 2020-06-17 | Louisiana | 22 | 48746 | 3062 |
5865 | 5865 | 2020-06-17 | Maine | 23 | 2836 | 102 |
5866 | 5866 | 2020-06-17 | Maryland | 24 | 63565 | 2996 |
5867 | 5867 | 2020-06-17 | Massachusetts | 25 | 106151 | 7733 |
5868 | 5868 | 2020-06-17 | Michigan | 26 | 66694 | 6041 |
5869 | 5869 | 2020-06-17 | Minnesota | 27 | 31328 | 1357 |
5870 | 5870 | 2020-06-17 | Mississippi | 28 | 20641 | 938 |
5871 | 5871 | 2020-06-17 | Missouri | 29 | 17151 | 924 |
5872 | 5872 | 2020-06-17 | Montana | 30 | 630 | 20 |
5873 | 5873 | 2020-06-17 | Nebraska | 31 | 17226 | 239 |
5874 | 5874 | 2020-06-17 | Nevada | 32 | 11852 | 473 |
5875 | 5875 | 2020-06-17 | New Hampshire | 33 | 5436 | 330 |
5876 | 5876 | 2020-06-17 | New Jersey | 34 | 167703 | 12769 |
5877 | 5877 | 2020-06-17 | New Mexico | 35 | 10065 | 452 |
5878 | 5878 | 2020-06-17 | New York | 36 | 389910 | 30722 |
5879 | 5879 | 2020-06-17 | North Carolina | 37 | 47142 | 1198 |
5880 | 5880 | 2020-06-17 | North Dakota | 38 | 3170 | 78 |
5881 | 5881 | 2020-06-17 | Northern Mariana Islands | 69 | 30 | 2 |
5882 | 5882 | 2020-06-17 | Ohio | 39 | 42422 | 2611 |
5883 | 5883 | 2020-06-17 | Oklahoma | 40 | 8903 | 364 |
5884 | 5884 | 2020-06-17 | Oregon | 41 | 6235 | 183 |
5885 | 5885 | 2020-06-17 | Pennsylvania | 42 | 84387 | 6376 |
5886 | 5886 | 2020-06-17 | Puerto Rico | 72 | 6003 | 147 |
5887 | 5887 | 2020-06-17 | Rhode Island | 44 | 16213 | 876 |
5888 | 5888 | 2020-06-17 | South Carolina | 45 | 20556 | 617 |
5889 | 5889 | 2020-06-17 | South Dakota | 46 | 6050 | 78 |
5890 | 5890 | 2020-06-17 | Tennessee | 47 | 32112 | 493 |
5891 | 5891 | 2020-06-17 | Texas | 48 | 99466 | 2099 |
5892 | 5892 | 2020-06-17 | Utah | 49 | 15464 | 149 |
5893 | 5893 | 2020-06-17 | Vermont | 50 | 1130 | 55 |
5894 | 5894 | 2020-06-17 | Virgin Islands | 78 | 73 | 6 |
5895 | 5895 | 2020-06-17 | Virginia | 51 | 55775 | 1583 |
5896 | 5896 | 2020-06-17 | Washington | 53 | 28270 | 1229 |
5897 | 5897 | 2020-06-17 | West Virginia | 54 | 2376 | 88 |
5898 | 5898 | 2020-06-17 | Wisconsin | 55 | 26167 | 719 |
5899 | 5899 | 2020-06-17 | Wyoming | 56 | 1114 | 18 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );