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-09-13 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 |
---|---|---|---|---|---|---|
30760 | 30760 | 2021-09-13 | Alabama | 1 | 750298 | 12678 |
30761 | 30761 | 2021-09-13 | Alaska | 2 | 95878 | 442 |
30762 | 30762 | 2021-09-13 | Arizona | 4 | 1050878 | 19187 |
30763 | 30763 | 2021-09-13 | Arkansas | 5 | 475647 | 7298 |
30764 | 30764 | 2021-09-13 | California | 6 | 4599348 | 67312 |
30765 | 30765 | 2021-09-13 | Colorado | 8 | 643202 | 7479 |
30766 | 30766 | 2021-09-13 | Connecticut | 9 | 380281 | 8424 |
30767 | 30767 | 2021-09-13 | Delaware | 10 | 125549 | 1900 |
30768 | 30768 | 2021-09-13 | District of Columbia | 11 | 57771 | 1165 |
30769 | 30769 | 2021-09-13 | Florida | 12 | 3442090 | 48772 |
30770 | 30770 | 2021-09-13 | Georgia | 13 | 1467477 | 23121 |
30771 | 30771 | 2021-09-13 | Guam | 66 | 13522 | 169 |
30772 | 30772 | 2021-09-13 | Hawaii | 15 | 70083 | 657 |
30773 | 30773 | 2021-09-13 | Idaho | 16 | 235422 | 2487 |
30774 | 30774 | 2021-09-13 | Illinois | 17 | 1578344 | 26969 |
30775 | 30775 | 2021-09-13 | Indiana | 18 | 913389 | 14848 |
30776 | 30776 | 2021-09-13 | Iowa | 19 | 421168 | 6337 |
30777 | 30777 | 2021-09-13 | Kansas | 20 | 390982 | 5791 |
30778 | 30778 | 2021-09-13 | Kentucky | 21 | 633518 | 8132 |
30779 | 30779 | 2021-09-13 | Louisiana | 22 | 716706 | 13121 |
30780 | 30780 | 2021-09-13 | Maine | 23 | 80510 | 961 |
30781 | 30781 | 2021-09-13 | Maryland | 24 | 511871 | 10189 |
30782 | 30782 | 2021-09-13 | Massachusetts | 25 | 782107 | 18369 |
30783 | 30783 | 2021-09-13 | Michigan | 26 | 1093203 | 21840 |
30784 | 30784 | 2021-09-13 | Minnesota | 27 | 669269 | 7996 |
30785 | 30785 | 2021-09-13 | Mississippi | 28 | 464075 | 8976 |
30786 | 30786 | 2021-09-13 | Missouri | 29 | 804615 | 11574 |
30787 | 30787 | 2021-09-13 | Montana | 30 | 135059 | 1842 |
30788 | 30788 | 2021-09-13 | Nebraska | 31 | 253788 | 2608 |
30789 | 30789 | 2021-09-13 | Nevada | 32 | 404851 | 6728 |
30790 | 30790 | 2021-09-13 | New Hampshire | 33 | 112326 | 1443 |
30791 | 30791 | 2021-09-13 | New Jersey | 34 | 1119051 | 27079 |
30792 | 30792 | 2021-09-13 | New Mexico | 35 | 241663 | 4621 |
30793 | 30793 | 2021-09-13 | New York | 36 | 2338377 | 54271 |
30794 | 30794 | 2021-09-13 | North Carolina | 37 | 1305188 | 15263 |
30795 | 30795 | 2021-09-13 | North Dakota | 38 | 122768 | 1605 |
30796 | 30796 | 2021-09-13 | Northern Mariana Islands | 69 | 252 | 2 |
30797 | 30797 | 2021-09-13 | Ohio | 39 | 1304193 | 21154 |
30798 | 30798 | 2021-09-13 | Oklahoma | 40 | 584692 | 8208 |
30799 | 30799 | 2021-09-13 | Oregon | 41 | 301504 | 3451 |
30800 | 30800 | 2021-09-13 | Pennsylvania | 42 | 1350719 | 28568 |
30801 | 30801 | 2021-09-13 | Puerto Rico | 72 | 210703 | 3003 |
30802 | 30802 | 2021-09-13 | Rhode Island | 44 | 166811 | 2802 |
30803 | 30803 | 2021-09-13 | South Carolina | 45 | 802328 | 11306 |
30804 | 30804 | 2021-09-13 | South Dakota | 46 | 137300 | 2088 |
30805 | 30805 | 2021-09-13 | Tennessee | 47 | 1128123 | 13894 |
30806 | 30806 | 2021-09-13 | Texas | 48 | 3833311 | 60475 |
30807 | 30807 | 2021-09-13 | Utah | 49 | 484278 | 2740 |
30808 | 30808 | 2021-09-13 | Vermont | 50 | 30264 | 288 |
30809 | 30809 | 2021-09-13 | Virgin Islands | 78 | 6289 | 66 |
30810 | 30810 | 2021-09-13 | Virginia | 51 | 811079 | 12089 |
30811 | 30811 | 2021-09-13 | Washington | 53 | 609292 | 7042 |
30812 | 30812 | 2021-09-13 | West Virginia | 54 | 211706 | 3238 |
30813 | 30813 | 2021-09-13 | Wisconsin | 55 | 758055 | 8632 |
30814 | 30814 | 2021-09-13 | Wyoming | 56 | 81825 | 879 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );