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-08-19 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 55
- 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
- New Hampshire 1
- New Jersey 1
- New Mexico 1
- New York 1
- North Carolina 1
- North Dakota 1
- Northern Mariana Islands 1
- Ohio 1
- Oklahoma 1
- Oregon 1
- Pennsylvania 1
- Puerto Rico 1
- Rhode Island 1
- South Carolina 1
- South Dakota 1
- Tennessee 1
- Texas 1
- Utah 1
- Vermont 1
- Virgin Islands 1
- Virginia 1
- Washington 1
- West Virginia 1
- Wisconsin 1
- Wyoming 1
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
9310 | 9310 | 2020-08-19 | Alabama | 1 | 111478 | 1944 |
9311 | 9311 | 2020-08-19 | Alaska | 2 | 5245 | 27 |
9312 | 9312 | 2020-08-19 | Arizona | 4 | 195568 | 4643 |
9313 | 9313 | 2020-08-19 | Arkansas | 5 | 54216 | 631 |
9314 | 9314 | 2020-08-19 | California | 6 | 646742 | 11686 |
9315 | 9315 | 2020-08-19 | Colorado | 8 | 53943 | 1906 |
9316 | 9316 | 2020-08-19 | Connecticut | 9 | 51314 | 4457 |
9317 | 9317 | 2020-08-19 | Delaware | 10 | 16643 | 595 |
9318 | 9318 | 2020-08-19 | District of Columbia | 11 | 13354 | 600 |
9319 | 9319 | 2020-08-19 | Florida | 12 | 584039 | 9931 |
9320 | 9320 | 2020-08-19 | Georgia | 13 | 227255 | 4744 |
9321 | 9321 | 2020-08-19 | Guam | 66 | 1568 | 6 |
9322 | 9322 | 2020-08-19 | Hawaii | 15 | 5586 | 41 |
9323 | 9323 | 2020-08-19 | Idaho | 16 | 28829 | 292 |
9324 | 9324 | 2020-08-19 | Illinois | 17 | 213888 | 8037 |
9325 | 9325 | 2020-08-19 | Indiana | 18 | 84308 | 3180 |
9326 | 9326 | 2020-08-19 | Iowa | 19 | 53541 | 1011 |
9327 | 9327 | 2020-08-19 | Kansas | 20 | 36333 | 420 |
9328 | 9328 | 2020-08-19 | Kentucky | 21 | 42958 | 866 |
9329 | 9329 | 2020-08-19 | Louisiana | 22 | 140044 | 4609 |
9330 | 9330 | 2020-08-19 | Maine | 23 | 4234 | 127 |
9331 | 9331 | 2020-08-19 | Maryland | 24 | 102215 | 3661 |
9332 | 9332 | 2020-08-19 | Massachusetts | 25 | 124415 | 8876 |
9333 | 9333 | 2020-08-19 | Michigan | 26 | 104235 | 6619 |
9334 | 9334 | 2020-08-19 | Minnesota | 27 | 66664 | 1784 |
9335 | 9335 | 2020-08-19 | Mississippi | 28 | 74555 | 2163 |
9336 | 9336 | 2020-08-19 | Missouri | 29 | 71802 | 1490 |
9337 | 9337 | 2020-08-19 | Montana | 30 | 5976 | 84 |
9338 | 9338 | 2020-08-19 | Nebraska | 31 | 31040 | 373 |
9339 | 9339 | 2020-08-19 | Nevada | 32 | 63127 | 1135 |
9340 | 9340 | 2020-08-19 | New Hampshire | 33 | 7036 | 427 |
9341 | 9341 | 2020-08-19 | New Jersey | 34 | 190256 | 15926 |
9342 | 9342 | 2020-08-19 | New Mexico | 35 | 23749 | 729 |
9343 | 9343 | 2020-08-19 | New York | 36 | 431924 | 32451 |
9344 | 9344 | 2020-08-19 | North Carolina | 37 | 148491 | 2464 |
9345 | 9345 | 2020-08-19 | North Dakota | 38 | 8972 | 134 |
9346 | 9346 | 2020-08-19 | Northern Mariana Islands | 69 | 54 | 2 |
9347 | 9347 | 2020-08-19 | Ohio | 39 | 110881 | 3907 |
9348 | 9348 | 2020-08-19 | Oklahoma | 40 | 49923 | 699 |
9349 | 9349 | 2020-08-19 | Oregon | 41 | 23887 | 408 |
9350 | 9350 | 2020-08-19 | Pennsylvania | 42 | 130950 | 7593 |
9351 | 9351 | 2020-08-19 | Puerto Rico | 72 | 27934 | 356 |
9352 | 9352 | 2020-08-19 | Rhode Island | 44 | 20795 | 1027 |
9353 | 9353 | 2020-08-19 | South Carolina | 45 | 108411 | 2360 |
9354 | 9354 | 2020-08-19 | South Dakota | 46 | 10566 | 155 |
9355 | 9355 | 2020-08-19 | Tennessee | 47 | 134810 | 1437 |
9356 | 9356 | 2020-08-19 | Texas | 48 | 582623 | 11043 |
9357 | 9357 | 2020-08-19 | Utah | 49 | 47647 | 379 |
9358 | 9358 | 2020-08-19 | Vermont | 50 | 1533 | 58 |
9359 | 9359 | 2020-08-19 | Virgin Islands | 78 | 828 | 9 |
9360 | 9360 | 2020-08-19 | Virginia | 51 | 109019 | 2410 |
9361 | 9361 | 2020-08-19 | Washington | 53 | 71594 | 1910 |
9362 | 9362 | 2020-08-19 | West Virginia | 54 | 8801 | 166 |
9363 | 9363 | 2020-08-19 | Wisconsin | 55 | 72204 | 1071 |
9364 | 9364 | 2020-08-19 | Wyoming | 56 | 3430 | 34 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );