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-22 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 |
---|---|---|---|---|---|---|
6120 | 6120 | 2020-06-22 | Alabama | 1 | 30454 | 841 |
6121 | 6121 | 2020-06-22 | Alaska | 2 | 869 | 10 |
6122 | 6122 | 2020-06-22 | Arizona | 4 | 54767 | 1354 |
6123 | 6123 | 2020-06-22 | Arkansas | 5 | 16083 | 227 |
6124 | 6124 | 2020-06-22 | California | 6 | 184620 | 5561 |
6125 | 6125 | 2020-06-22 | Colorado | 8 | 30689 | 1651 |
6126 | 6126 | 2020-06-22 | Connecticut | 9 | 45782 | 4263 |
6127 | 6127 | 2020-06-22 | Delaware | 10 | 10820 | 435 |
6128 | 6128 | 2020-06-22 | District of Columbia | 11 | 10058 | 535 |
6129 | 6129 | 2020-06-22 | Florida | 12 | 100209 | 3172 |
6130 | 6130 | 2020-06-22 | Georgia | 13 | 62705 | 2607 |
6131 | 6131 | 2020-06-22 | Guam | 66 | 1191 | 6 |
6132 | 6132 | 2020-06-22 | Hawaii | 15 | 804 | 17 |
6133 | 6133 | 2020-06-22 | Idaho | 16 | 4267 | 90 |
6134 | 6134 | 2020-06-22 | Illinois | 17 | 138615 | 6889 |
6135 | 6135 | 2020-06-22 | Indiana | 18 | 43709 | 2553 |
6136 | 6136 | 2020-06-22 | Iowa | 19 | 26217 | 687 |
6137 | 6137 | 2020-06-22 | Kansas | 20 | 12576 | 260 |
6138 | 6138 | 2020-06-22 | Kentucky | 21 | 14073 | 549 |
6139 | 6139 | 2020-06-22 | Louisiana | 22 | 50352 | 3117 |
6140 | 6140 | 2020-06-22 | Maine | 23 | 2971 | 102 |
6141 | 6141 | 2020-06-22 | Maryland | 24 | 65202 | 3074 |
6142 | 6142 | 2020-06-22 | Massachusetts | 25 | 107210 | 7873 |
6143 | 6143 | 2020-06-22 | Michigan | 26 | 68144 | 6101 |
6144 | 6144 | 2020-06-22 | Minnesota | 27 | 33259 | 1416 |
6145 | 6145 | 2020-06-22 | Mississippi | 28 | 22287 | 978 |
6146 | 6146 | 2020-06-22 | Missouri | 29 | 18733 | 980 |
6147 | 6147 | 2020-06-22 | Montana | 30 | 734 | 21 |
6148 | 6148 | 2020-06-22 | Nebraska | 31 | 17957 | 255 |
6149 | 6149 | 2020-06-22 | Nevada | 32 | 13575 | 490 |
6150 | 6150 | 2020-06-22 | New Hampshire | 33 | 5558 | 339 |
6151 | 6151 | 2020-06-22 | New Jersey | 34 | 169415 | 12895 |
6152 | 6152 | 2020-06-22 | New Mexico | 35 | 10694 | 469 |
6153 | 6153 | 2020-06-22 | New York | 36 | 393257 | 30934 |
6154 | 6154 | 2020-06-22 | North Carolina | 37 | 53840 | 1250 |
6155 | 6155 | 2020-06-22 | North Dakota | 38 | 3319 | 83 |
6156 | 6156 | 2020-06-22 | Northern Mariana Islands | 69 | 30 | 2 |
6157 | 6157 | 2020-06-22 | Ohio | 39 | 45537 | 2704 |
6158 | 6158 | 2020-06-22 | Oklahoma | 40 | 10733 | 369 |
6159 | 6159 | 2020-06-22 | Oregon | 41 | 7115 | 192 |
6160 | 6160 | 2020-06-22 | Pennsylvania | 42 | 86666 | 6475 |
6161 | 6161 | 2020-06-22 | Puerto Rico | 72 | 6564 | 149 |
6162 | 6162 | 2020-06-22 | Rhode Island | 44 | 16459 | 903 |
6163 | 6163 | 2020-06-22 | South Carolina | 45 | 25701 | 659 |
6164 | 6164 | 2020-06-22 | South Dakota | 46 | 6326 | 81 |
6165 | 6165 | 2020-06-22 | Tennessee | 47 | 35255 | 525 |
6166 | 6166 | 2020-06-22 | Texas | 48 | 119646 | 2213 |
6167 | 6167 | 2020-06-22 | Utah | 49 | 18035 | 158 |
6168 | 6168 | 2020-06-22 | Vermont | 50 | 1163 | 56 |
6169 | 6169 | 2020-06-22 | Virgin Islands | 78 | 76 | 6 |
6170 | 6170 | 2020-06-22 | Virginia | 51 | 58465 | 1620 |
6171 | 6171 | 2020-06-22 | Washington | 53 | 30443 | 1277 |
6172 | 6172 | 2020-06-22 | West Virginia | 54 | 2571 | 90 |
6173 | 6173 | 2020-06-22 | Wisconsin | 55 | 27849 | 751 |
6174 | 6174 | 2020-06-22 | Wyoming | 56 | 1230 | 20 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );