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-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 |
---|---|---|---|---|---|---|
8540 | 8540 | 2020-08-05 | Alabama | 1 | 94654 | 1695 |
8541 | 8541 | 2020-08-05 | Alaska | 2 | 4181 | 23 |
8542 | 8542 | 2020-08-05 | Arizona | 4 | 182230 | 3933 |
8543 | 8543 | 2020-08-05 | Arkansas | 5 | 46293 | 508 |
8544 | 8544 | 2020-08-05 | California | 6 | 532776 | 9866 |
8545 | 8545 | 2020-08-05 | Colorado | 8 | 49143 | 1857 |
8546 | 8546 | 2020-08-05 | Connecticut | 9 | 50225 | 4437 |
8547 | 8547 | 2020-08-05 | Delaware | 10 | 15296 | 587 |
8548 | 8548 | 2020-08-05 | District of Columbia | 11 | 12443 | 587 |
8549 | 8549 | 2020-08-05 | Florida | 12 | 502731 | 7626 |
8550 | 8550 | 2020-08-05 | Georgia | 13 | 186395 | 3899 |
8551 | 8551 | 2020-08-05 | Guam | 66 | 1358 | 6 |
8552 | 8552 | 2020-08-05 | Hawaii | 15 | 2740 | 26 |
8553 | 8553 | 2020-08-05 | Idaho | 16 | 22854 | 218 |
8554 | 8554 | 2020-08-05 | Illinois | 17 | 188474 | 7776 |
8555 | 8555 | 2020-08-05 | Indiana | 18 | 71685 | 3007 |
8556 | 8556 | 2020-08-05 | Iowa | 19 | 46836 | 900 |
8557 | 8557 | 2020-08-05 | Kansas | 20 | 30047 | 371 |
8558 | 8558 | 2020-08-05 | Kentucky | 21 | 33823 | 771 |
8559 | 8559 | 2020-08-05 | Louisiana | 22 | 126061 | 4096 |
8560 | 8560 | 2020-08-05 | Maine | 23 | 3992 | 124 |
8561 | 8561 | 2020-08-05 | Maryland | 24 | 93000 | 3536 |
8562 | 8562 | 2020-08-05 | Massachusetts | 25 | 119643 | 8659 |
8563 | 8563 | 2020-08-05 | Michigan | 26 | 94045 | 6480 |
8564 | 8564 | 2020-08-05 | Minnesota | 27 | 57820 | 1670 |
8565 | 8565 | 2020-08-05 | Mississippi | 28 | 63444 | 1804 |
8566 | 8566 | 2020-08-05 | Missouri | 29 | 55951 | 1337 |
8567 | 8567 | 2020-08-05 | Montana | 30 | 4481 | 65 |
8568 | 8568 | 2020-08-05 | Nebraska | 31 | 27489 | 342 |
8569 | 8569 | 2020-08-05 | Nevada | 32 | 52919 | 891 |
8570 | 8570 | 2020-08-05 | New Hampshire | 33 | 6719 | 418 |
8571 | 8571 | 2020-08-05 | New Jersey | 34 | 185180 | 15842 |
8572 | 8572 | 2020-08-05 | New Mexico | 35 | 21566 | 667 |
8573 | 8573 | 2020-08-05 | New York | 36 | 422935 | 32431 |
8574 | 8574 | 2020-08-05 | North Carolina | 37 | 129454 | 2079 |
8575 | 8575 | 2020-08-05 | North Dakota | 38 | 7061 | 112 |
8576 | 8576 | 2020-08-05 | Northern Mariana Islands | 69 | 46 | 2 |
8577 | 8577 | 2020-08-05 | Ohio | 39 | 96305 | 3596 |
8578 | 8578 | 2020-08-05 | Oklahoma | 40 | 40555 | 583 |
8579 | 8579 | 2020-08-05 | Oregon | 41 | 19979 | 342 |
8580 | 8580 | 2020-08-05 | Pennsylvania | 42 | 120492 | 7310 |
8581 | 8581 | 2020-08-05 | Puerto Rico | 72 | 19651 | 246 |
8582 | 8582 | 2020-08-05 | Rhode Island | 44 | 19481 | 1012 |
8583 | 8583 | 2020-08-05 | South Carolina | 45 | 95472 | 1894 |
8584 | 8584 | 2020-08-05 | South Dakota | 46 | 9168 | 137 |
8585 | 8585 | 2020-08-05 | Tennessee | 47 | 111305 | 1130 |
8586 | 8586 | 2020-08-05 | Texas | 48 | 482467 | 8152 |
8587 | 8587 | 2020-08-05 | Utah | 49 | 42478 | 330 |
8588 | 8588 | 2020-08-05 | Vermont | 50 | 1436 | 57 |
8589 | 8589 | 2020-08-05 | Virgin Islands | 78 | 501 | 9 |
8590 | 8590 | 2020-08-05 | Virginia | 51 | 95049 | 2274 |
8591 | 8591 | 2020-08-05 | Washington | 53 | 62389 | 1704 |
8592 | 8592 | 2020-08-05 | West Virginia | 54 | 7159 | 124 |
8593 | 8593 | 2020-08-05 | Wisconsin | 55 | 61247 | 979 |
8594 | 8594 | 2020-08-05 | Wyoming | 56 | 2923 | 27 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );