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 2021-03-29 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 |
---|---|---|---|---|---|---|
21520 | 21520 | 2021-03-29 | Alabama | 1 | 514619 | 10526 |
21521 | 21521 | 2021-03-29 | Alaska | 2 | 61744 | 299 |
21522 | 21522 | 2021-03-29 | Arizona | 4 | 840501 | 16918 |
21523 | 21523 | 2021-03-29 | Arkansas | 5 | 330008 | 5601 |
21524 | 21524 | 2021-03-29 | California | 6 | 3664161 | 59015 |
21525 | 21525 | 2021-03-29 | Colorado | 8 | 461969 | 6166 |
21526 | 21526 | 2021-03-29 | Connecticut | 9 | 308439 | 7883 |
21527 | 21527 | 2021-03-29 | Delaware | 10 | 94402 | 1552 |
21528 | 21528 | 2021-03-29 | District of Columbia | 11 | 44248 | 1059 |
21529 | 21529 | 2021-03-29 | Florida | 12 | 2047371 | 33246 |
21530 | 21530 | 2021-03-29 | Georgia | 13 | 1032045 | 18381 |
21531 | 21531 | 2021-03-29 | Guam | 66 | 8773 | 135 |
21532 | 21532 | 2021-03-29 | Hawaii | 15 | 29626 | 459 |
21533 | 21533 | 2021-03-29 | Idaho | 16 | 179897 | 1960 |
21534 | 21534 | 2021-03-29 | Illinois | 17 | 1243171 | 23527 |
21535 | 21535 | 2021-03-29 | Indiana | 18 | 688017 | 13028 |
21536 | 21536 | 2021-03-29 | Iowa | 19 | 350219 | 5729 |
21537 | 21537 | 2021-03-29 | Kansas | 20 | 304143 | 4902 |
21538 | 21538 | 2021-03-29 | Kentucky | 21 | 428835 | 6104 |
21539 | 21539 | 2021-03-29 | Louisiana | 22 | 443905 | 10122 |
21540 | 21540 | 2021-03-29 | Maine | 23 | 50030 | 736 |
21541 | 21541 | 2021-03-29 | Maryland | 24 | 409260 | 8260 |
21542 | 21542 | 2021-03-29 | Massachusetts | 25 | 631031 | 17130 |
21543 | 21543 | 2021-03-29 | Michigan | 26 | 731519 | 17048 |
21544 | 21544 | 2021-03-29 | Minnesota | 27 | 516686 | 6913 |
21545 | 21545 | 2021-03-29 | Mississippi | 28 | 304695 | 7001 |
21546 | 21546 | 2021-03-29 | Missouri | 29 | 587619 | 8920 |
21547 | 21547 | 2021-03-29 | Montana | 30 | 104293 | 1436 |
21548 | 21548 | 2021-03-29 | Nebraska | 31 | 208853 | 2280 |
21549 | 21549 | 2021-03-29 | Nevada | 32 | 303292 | 5237 |
21550 | 21550 | 2021-03-29 | New Hampshire | 33 | 83340 | 1237 |
21551 | 21551 | 2021-03-29 | New Jersey | 34 | 900271 | 24404 |
21552 | 21552 | 2021-03-29 | New Mexico | 35 | 191230 | 3927 |
21553 | 21553 | 2021-03-29 | New York | 36 | 1858162 | 49648 |
21554 | 21554 | 2021-03-29 | North Carolina | 37 | 912026 | 12110 |
21555 | 21555 | 2021-03-29 | North Dakota | 38 | 102671 | 1498 |
21556 | 21556 | 2021-03-29 | Northern Mariana Islands | 69 | 159 | 2 |
21557 | 21557 | 2021-03-29 | Ohio | 39 | 1013119 | 18526 |
21558 | 21558 | 2021-03-29 | Oklahoma | 40 | 437853 | 4850 |
21559 | 21559 | 2021-03-29 | Oregon | 41 | 164256 | 2390 |
21560 | 21560 | 2021-03-29 | Pennsylvania | 42 | 1020584 | 25073 |
21561 | 21561 | 2021-03-29 | Puerto Rico | 72 | 140103 | 2112 |
21562 | 21562 | 2021-03-29 | Rhode Island | 44 | 136419 | 2613 |
21563 | 21563 | 2021-03-29 | South Carolina | 45 | 550068 | 9122 |
21564 | 21564 | 2021-03-29 | South Dakota | 46 | 117336 | 1933 |
21565 | 21565 | 2021-03-29 | Tennessee | 47 | 795088 | 11761 |
21566 | 21566 | 2021-03-29 | Texas | 48 | 2782555 | 48309 |
21567 | 21567 | 2021-03-29 | Utah | 49 | 384815 | 2114 |
21568 | 21568 | 2021-03-29 | Vermont | 50 | 19002 | 225 |
21569 | 21569 | 2021-03-29 | Virgin Islands | 78 | 2907 | 26 |
21570 | 21570 | 2021-03-29 | Virginia | 51 | 616509 | 10219 |
21571 | 21571 | 2021-03-29 | Washington | 53 | 365029 | 5296 |
21572 | 21572 | 2021-03-29 | West Virginia | 54 | 140991 | 2638 |
21573 | 21573 | 2021-03-29 | Wisconsin | 55 | 634662 | 7278 |
21574 | 21574 | 2021-03-29 | Wyoming | 56 | 56190 | 695 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );