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-08-15 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 |
---|---|---|---|---|---|---|
49567 | 49567 | 2022-08-15 | Alabama | 1 | 1449812 | 20026 |
49568 | 49568 | 2022-08-15 | Alaska | 2 | 287355 | 1290 |
49569 | 49569 | 2022-08-15 | American Samoa | 60 | 7471 | 33 |
49570 | 49570 | 2022-08-15 | Arizona | 4 | 2224964 | 30901 |
49571 | 49571 | 2022-08-15 | Arkansas | 5 | 917523 | 11822 |
49572 | 49572 | 2022-08-15 | California | 6 | 10908539 | 94262 |
49573 | 49573 | 2022-08-15 | Colorado | 8 | 1622738 | 13293 |
49574 | 49574 | 2022-08-15 | Connecticut | 9 | 865196 | 11165 |
49575 | 49575 | 2022-08-15 | Delaware | 10 | 299087 | 3036 |
49576 | 49576 | 2022-08-15 | District of Columbia | 11 | 164373 | 1374 |
49577 | 49577 | 2022-08-15 | Florida | 12 | 6926031 | 78731 |
49578 | 49578 | 2022-08-15 | Georgia | 13 | 2723252 | 37780 |
49579 | 49579 | 2022-08-15 | Guam | 66 | 57773 | 387 |
49580 | 49580 | 2022-08-15 | Hawaii | 15 | 324519 | 1603 |
49581 | 49581 | 2022-08-15 | Idaho | 16 | 484709 | 5069 |
49582 | 49582 | 2022-08-15 | Illinois | 17 | 3635675 | 39119 |
49583 | 49583 | 2022-08-15 | Indiana | 18 | 1862813 | 24262 |
49584 | 49584 | 2022-08-15 | Iowa | 19 | 830079 | 9850 |
49585 | 49585 | 2022-08-15 | Kansas | 20 | 848977 | 8993 |
49586 | 49586 | 2022-08-15 | Kentucky | 21 | 1520706 | 16540 |
49587 | 49587 | 2022-08-15 | Louisiana | 22 | 1403404 | 17708 |
49588 | 49588 | 2022-08-15 | Maine | 23 | 278921 | 2493 |
49589 | 49589 | 2022-08-15 | Maryland | 24 | 1203149 | 15063 |
49590 | 49590 | 2022-08-15 | Massachusetts | 25 | 1987385 | 21285 |
49591 | 49591 | 2022-08-15 | Michigan | 26 | 2708622 | 37671 |
49592 | 49592 | 2022-08-15 | Minnesota | 27 | 1611246 | 13362 |
49593 | 49593 | 2022-08-15 | Mississippi | 28 | 894772 | 12729 |
49594 | 49594 | 2022-08-15 | Missouri | 29 | 1604707 | 21251 |
49595 | 49595 | 2022-08-15 | Montana | 30 | 300906 | 3481 |
49596 | 49596 | 2022-08-15 | Nebraska | 31 | 522491 | 4394 |
49597 | 49597 | 2022-08-15 | Nevada | 32 | 835365 | 11331 |
49598 | 49598 | 2022-08-15 | New Hampshire | 33 | 341568 | 2641 |
49599 | 49599 | 2022-08-15 | New Jersey | 34 | 2640445 | 34404 |
49600 | 49600 | 2022-08-15 | New Mexico | 35 | 602930 | 8320 |
49601 | 49601 | 2022-08-15 | New York | 36 | 5900333 | 70001 |
49602 | 49602 | 2022-08-15 | North Carolina | 37 | 3047828 | 25734 |
49603 | 49603 | 2022-08-15 | North Dakota | 38 | 261045 | 2373 |
49604 | 49604 | 2022-08-15 | Northern Mariana Islands | 69 | 12948 | 39 |
49605 | 49605 | 2022-08-15 | Ohio | 39 | 3002043 | 39220 |
49606 | 49606 | 2022-08-15 | Oklahoma | 40 | 1147408 | 14623 |
49607 | 49607 | 2022-08-15 | Oregon | 41 | 866763 | 8292 |
49608 | 49608 | 2022-08-15 | Pennsylvania | 42 | 3134837 | 46422 |
49609 | 49609 | 2022-08-15 | Puerto Rico | 72 | 926199 | 4853 |
49610 | 49610 | 2022-08-15 | Rhode Island | 44 | 413259 | 3632 |
49611 | 49611 | 2022-08-15 | South Carolina | 45 | 1637108 | 18215 |
49612 | 49612 | 2022-08-15 | South Dakota | 46 | 253232 | 2973 |
49613 | 49613 | 2022-08-15 | Tennessee | 47 | 2182385 | 26945 |
49614 | 49614 | 2022-08-15 | Texas | 48 | 7611171 | 89908 |
49615 | 49615 | 2022-08-15 | Utah | 49 | 1020399 | 4940 |
49616 | 49616 | 2022-08-15 | Vermont | 50 | 138779 | 699 |
49617 | 49617 | 2022-08-15 | Virgin Islands | 78 | 22135 | 122 |
49618 | 49618 | 2022-08-15 | Virginia | 51 | 1999881 | 21163 |
49619 | 49619 | 2022-08-15 | Washington | 53 | 1764789 | 13888 |
49620 | 49620 | 2022-08-15 | West Virginia | 54 | 569322 | 7206 |
49621 | 49621 | 2022-08-15 | Wisconsin | 55 | 1807046 | 14980 |
49622 | 49622 | 2022-08-15 | Wyoming | 56 | 172473 | 1865 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );