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-18 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 |
---|---|---|---|---|---|---|
9255 | 9255 | 2020-08-18 | Alabama | 1 | 110361 | 1936 |
9256 | 9256 | 2020-08-18 | Alaska | 2 | 5175 | 27 |
9257 | 9257 | 2020-08-18 | Arizona | 4 | 194931 | 4535 |
9258 | 9258 | 2020-08-18 | Arkansas | 5 | 53487 | 619 |
9259 | 9259 | 2020-08-18 | California | 6 | 640499 | 11523 |
9260 | 9260 | 2020-08-18 | Colorado | 8 | 53674 | 1906 |
9261 | 9261 | 2020-08-18 | Connecticut | 9 | 51255 | 4456 |
9262 | 9262 | 2020-08-18 | Delaware | 10 | 16593 | 593 |
9263 | 9263 | 2020-08-18 | District of Columbia | 11 | 13325 | 599 |
9264 | 9264 | 2020-08-18 | Florida | 12 | 579924 | 9757 |
9265 | 9265 | 2020-08-18 | Georgia | 13 | 224681 | 4691 |
9266 | 9266 | 2020-08-18 | Guam | 66 | 1546 | 6 |
9267 | 9267 | 2020-08-18 | Hawaii | 15 | 5326 | 40 |
9268 | 9268 | 2020-08-18 | Idaho | 16 | 28486 | 283 |
9269 | 9269 | 2020-08-18 | Illinois | 17 | 211806 | 8017 |
9270 | 9270 | 2020-08-18 | Indiana | 18 | 83799 | 3165 |
9271 | 9271 | 2020-08-18 | Iowa | 19 | 53201 | 1002 |
9272 | 9272 | 2020-08-18 | Kansas | 20 | 35632 | 415 |
9273 | 9273 | 2020-08-18 | Kentucky | 21 | 42270 | 858 |
9274 | 9274 | 2020-08-18 | Louisiana | 22 | 139248 | 4554 |
9275 | 9275 | 2020-08-18 | Maine | 23 | 4213 | 127 |
9276 | 9276 | 2020-08-18 | Maryland | 24 | 101780 | 3650 |
9277 | 9277 | 2020-08-18 | Massachusetts | 25 | 124063 | 8848 |
9278 | 9278 | 2020-08-18 | Michigan | 26 | 103527 | 6607 |
9279 | 9279 | 2020-08-18 | Minnesota | 27 | 66107 | 1767 |
9280 | 9280 | 2020-08-18 | Mississippi | 28 | 73207 | 2128 |
9281 | 9281 | 2020-08-18 | Missouri | 29 | 70759 | 1477 |
9282 | 9282 | 2020-08-18 | Montana | 30 | 5867 | 84 |
9283 | 9283 | 2020-08-18 | Nebraska | 31 | 30825 | 370 |
9284 | 9284 | 2020-08-18 | Nevada | 32 | 62752 | 1102 |
9285 | 9285 | 2020-08-18 | New Hampshire | 33 | 7017 | 424 |
9286 | 9286 | 2020-08-18 | New Jersey | 34 | 189937 | 15925 |
9287 | 9287 | 2020-08-18 | New Mexico | 35 | 23579 | 723 |
9288 | 9288 | 2020-08-18 | New York | 36 | 431298 | 32446 |
9289 | 9289 | 2020-08-18 | North Carolina | 37 | 147141 | 2425 |
9290 | 9290 | 2020-08-18 | North Dakota | 38 | 8786 | 132 |
9291 | 9291 | 2020-08-18 | Northern Mariana Islands | 69 | 54 | 2 |
9292 | 9292 | 2020-08-18 | Ohio | 39 | 109923 | 3871 |
9293 | 9293 | 2020-08-18 | Oklahoma | 40 | 49326 | 682 |
9294 | 9294 | 2020-08-18 | Oregon | 41 | 23685 | 399 |
9295 | 9295 | 2020-08-18 | Pennsylvania | 42 | 130286 | 7561 |
9296 | 9296 | 2020-08-18 | Puerto Rico | 72 | 27713 | 346 |
9297 | 9297 | 2020-08-18 | Rhode Island | 44 | 20692 | 1024 |
9298 | 9298 | 2020-08-18 | South Carolina | 45 | 107672 | 2343 |
9299 | 9299 | 2020-08-18 | South Dakota | 46 | 10443 | 154 |
9300 | 9300 | 2020-08-18 | Tennessee | 47 | 132796 | 1410 |
9301 | 9301 | 2020-08-18 | Texas | 48 | 577220 | 10798 |
9302 | 9302 | 2020-08-18 | Utah | 49 | 47285 | 372 |
9303 | 9303 | 2020-08-18 | Vermont | 50 | 1530 | 58 |
9304 | 9304 | 2020-08-18 | Virgin Islands | 78 | 796 | 9 |
9305 | 9305 | 2020-08-18 | Virginia | 51 | 108282 | 2396 |
9306 | 9306 | 2020-08-18 | Washington | 53 | 71032 | 1895 |
9307 | 9307 | 2020-08-18 | West Virginia | 54 | 8731 | 164 |
9308 | 9308 | 2020-08-18 | Wisconsin | 55 | 71517 | 1063 |
9309 | 9309 | 2020-08-18 | Wyoming | 56 | 3360 | 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 );