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-05 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 |
---|---|---|---|---|---|---|
5185 | 5185 | 2020-06-05 | Alabama | 1 | 19387 | 676 |
5186 | 5186 | 2020-06-05 | Alaska | 2 | 565 | 8 |
5187 | 5187 | 2020-06-05 | Arizona | 4 | 24369 | 1016 |
5188 | 5188 | 2020-06-05 | Arkansas | 5 | 8651 | 152 |
5189 | 5189 | 2020-06-05 | California | 6 | 126510 | 4550 |
5190 | 5190 | 2020-06-05 | Colorado | 8 | 27601 | 1524 |
5191 | 5191 | 2020-06-05 | Connecticut | 9 | 43460 | 4038 |
5192 | 5192 | 2020-06-05 | Delaware | 10 | 9773 | 388 |
5193 | 5193 | 2020-06-05 | District of Columbia | 11 | 9199 | 479 |
5194 | 5194 | 2020-06-05 | Florida | 12 | 61480 | 2659 |
5195 | 5195 | 2020-06-05 | Georgia | 13 | 48280 | 2143 |
5196 | 5196 | 2020-06-05 | Guam | 66 | 1148 | 6 |
5197 | 5197 | 2020-06-05 | Hawaii | 15 | 653 | 17 |
5198 | 5198 | 2020-06-05 | Idaho | 16 | 3111 | 83 |
5199 | 5199 | 2020-06-05 | Illinois | 17 | 126317 | 5834 |
5200 | 5200 | 2020-06-05 | Indiana | 18 | 37499 | 2258 |
5201 | 5201 | 2020-06-05 | Iowa | 19 | 21332 | 597 |
5202 | 5202 | 2020-06-05 | Kansas | 20 | 10493 | 233 |
5203 | 5203 | 2020-06-05 | Kentucky | 21 | 11051 | 476 |
5204 | 5204 | 2020-06-05 | Louisiana | 22 | 42100 | 2912 |
5205 | 5205 | 2020-06-05 | Maine | 23 | 2482 | 98 |
5206 | 5206 | 2020-06-05 | Maryland | 24 | 57407 | 2702 |
5207 | 5207 | 2020-06-05 | Massachusetts | 25 | 102557 | 7235 |
5208 | 5208 | 2020-06-05 | Michigan | 26 | 63744 | 5854 |
5209 | 5209 | 2020-06-05 | Minnesota | 27 | 26991 | 1159 |
5210 | 5210 | 2020-06-05 | Mississippi | 28 | 16769 | 803 |
5211 | 5211 | 2020-06-05 | Missouri | 29 | 14515 | 816 |
5212 | 5212 | 2020-06-05 | Montana | 30 | 539 | 18 |
5213 | 5213 | 2020-06-05 | Nebraska | 31 | 15379 | 193 |
5214 | 5214 | 2020-06-05 | Nevada | 32 | 9306 | 436 |
5215 | 5215 | 2020-06-05 | New Hampshire | 33 | 4953 | 278 |
5216 | 5216 | 2020-06-05 | New Jersey | 34 | 163336 | 12049 |
5217 | 5217 | 2020-06-05 | New Mexico | 35 | 8672 | 387 |
5218 | 5218 | 2020-06-05 | New York | 36 | 381019 | 30066 |
5219 | 5219 | 2020-06-05 | North Carolina | 37 | 33417 | 1001 |
5220 | 5220 | 2020-06-05 | North Dakota | 38 | 2748 | 74 |
5221 | 5221 | 2020-06-05 | Northern Mariana Islands | 69 | 26 | 2 |
5222 | 5222 | 2020-06-05 | Ohio | 39 | 37758 | 2355 |
5223 | 5223 | 2020-06-05 | Oklahoma | 40 | 7004 | 345 |
5224 | 5224 | 2020-06-05 | Oregon | 41 | 4585 | 161 |
5225 | 5225 | 2020-06-05 | Pennsylvania | 42 | 78908 | 5952 |
5226 | 5226 | 2020-06-05 | Puerto Rico | 72 | 4620 | 141 |
5227 | 5227 | 2020-06-05 | Rhode Island | 44 | 15441 | 772 |
5228 | 5228 | 2020-06-05 | South Carolina | 45 | 13453 | 538 |
5229 | 5229 | 2020-06-05 | South Dakota | 46 | 5277 | 65 |
5230 | 5230 | 2020-06-05 | Tennessee | 47 | 25799 | 405 |
5231 | 5231 | 2020-06-05 | Texas | 48 | 73323 | 1821 |
5232 | 5232 | 2020-06-05 | Utah | 49 | 11344 | 120 |
5233 | 5233 | 2020-06-05 | Vermont | 50 | 1027 | 55 |
5234 | 5234 | 2020-06-05 | Virgin Islands | 78 | 71 | 6 |
5235 | 5235 | 2020-06-05 | Virginia | 51 | 48532 | 1453 |
5236 | 5236 | 2020-06-05 | Washington | 53 | 24546 | 1160 |
5237 | 5237 | 2020-06-05 | West Virginia | 54 | 2119 | 84 |
5238 | 5238 | 2020-06-05 | Wisconsin | 55 | 20723 | 634 |
5239 | 5239 | 2020-06-05 | Wyoming | 56 | 933 | 17 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );