ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where "date" is on date 2022-02-17 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- Alabama 1
- Alaska 1
- American Samoa 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
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
39543 | 39543 | 2022-02-17 | Alabama | 1 | 1270015 | 17787 |
39544 | 39544 | 2022-02-17 | Alaska | 2 | 233405 | 1108 |
39545 | 39545 | 2022-02-17 | American Samoa | 60 | 57 | 0 |
39546 | 39546 | 2022-02-17 | Arizona | 4 | 1959866 | 27398 |
39547 | 39547 | 2022-02-17 | Arkansas | 5 | 811669 | 10235 |
39548 | 39548 | 2022-02-17 | California | 6 | 8870565 | 83686 |
39549 | 39549 | 2022-02-17 | Colorado | 8 | 1305818 | 11908 |
39550 | 39550 | 2022-02-17 | Connecticut | 9 | 718064 | 10324 |
39551 | 39551 | 2022-02-17 | Delaware | 10 | 254441 | 2655 |
39552 | 39552 | 2022-02-17 | District of Columbia | 11 | 133587 | 1313 |
39553 | 39553 | 2022-02-17 | Florida | 12 | 5769916 | 68572 |
39554 | 39554 | 2022-02-17 | Georgia | 13 | 2378883 | 33269 |
39555 | 39555 | 2022-02-17 | Guam | 66 | 41860 | 309 |
39556 | 39556 | 2022-02-17 | Hawaii | 15 | 227602 | 1287 |
39557 | 39557 | 2022-02-17 | Idaho | 16 | 411257 | 4656 |
39558 | 39558 | 2022-02-17 | Illinois | 17 | 3015848 | 36285 |
39559 | 39559 | 2022-02-17 | Indiana | 18 | 1676718 | 22426 |
39560 | 39560 | 2022-02-17 | Iowa | 19 | 743773 | 8948 |
39561 | 39561 | 2022-02-17 | Kansas | 20 | 761359 | 7909 |
39562 | 39562 | 2022-02-17 | Kentucky | 21 | 1264778 | 13566 |
39563 | 39563 | 2022-02-17 | Louisiana | 22 | 1218262 | 16353 |
39564 | 39564 | 2022-02-17 | Maine | 23 | 206005 | 1883 |
39565 | 39565 | 2022-02-17 | Maryland | 24 | 995589 | 13981 |
39566 | 39566 | 2022-02-17 | Massachusetts | 25 | 1659075 | 23060 |
39567 | 39567 | 2022-02-17 | Michigan | 26 | 2331762 | 33832 |
39568 | 39568 | 2022-02-17 | Minnesota | 27 | 1402609 | 12100 |
39569 | 39569 | 2022-02-17 | Mississippi | 28 | 784338 | 11790 |
39570 | 39570 | 2022-02-17 | Missouri | 29 | 1403357 | 18586 |
39571 | 39571 | 2022-02-17 | Montana | 30 | 261140 | 3101 |
39572 | 39572 | 2022-02-17 | Nebraska | 31 | 452189 | 3871 |
39573 | 39573 | 2022-02-17 | Nevada | 32 | 676687 | 9489 |
39574 | 39574 | 2022-02-17 | New Hampshire | 33 | 292187 | 2326 |
39575 | 39575 | 2022-02-17 | New Jersey | 34 | 2153093 | 32609 |
39576 | 39576 | 2022-02-17 | New Mexico | 35 | 506348 | 6748 |
39577 | 39577 | 2022-02-17 | New York | 36 | 4881848 | 66224 |
39578 | 39578 | 2022-02-17 | North Carolina | 37 | 2555905 | 22071 |
39579 | 39579 | 2022-02-17 | North Dakota | 38 | 236267 | 2216 |
39580 | 39580 | 2022-02-17 | Northern Mariana Islands | 69 | 8153 | 25 |
39581 | 39581 | 2022-02-17 | Ohio | 39 | 2640201 | 35372 |
39582 | 39582 | 2022-02-17 | Oklahoma | 40 | 1012168 | 12767 |
39583 | 39583 | 2022-02-17 | Oregon | 41 | 684411 | 6444 |
39584 | 39584 | 2022-02-17 | Pennsylvania | 42 | 2735573 | 42617 |
39585 | 39585 | 2022-02-17 | Puerto Rico | 72 | 503907 | 4060 |
39586 | 39586 | 2022-02-17 | Rhode Island | 44 | 353776 | 3397 |
39587 | 39587 | 2022-02-17 | South Carolina | 45 | 1447557 | 16520 |
39588 | 39588 | 2022-02-17 | South Dakota | 46 | 234084 | 2766 |
39589 | 39589 | 2022-02-17 | Tennessee | 47 | 1935143 | 23619 |
39590 | 39590 | 2022-02-17 | Texas | 48 | 6502958 | 83350 |
39591 | 39591 | 2022-02-17 | Utah | 49 | 917403 | 4344 |
39592 | 39592 | 2022-02-17 | Vermont | 50 | 110417 | 579 |
39593 | 39593 | 2022-02-17 | Virgin Islands | 78 | 15255 | 108 |
39594 | 39594 | 2022-02-17 | Virginia | 51 | 1619839 | 17947 |
39595 | 39595 | 2022-02-17 | Washington | 53 | 1411406 | 11621 |
39596 | 39596 | 2022-02-17 | West Virginia | 54 | 480692 | 6146 |
39597 | 39597 | 2022-02-17 | Wisconsin | 55 | 1563071 | 13045 |
39598 | 39598 | 2022-02-17 | Wyoming | 56 | 153850 | 1689 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );