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 2021-12-09 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|
35623 | 35623 | 2021-12-09 | Alabama | 1 | 850645 | 16203 |
35624 | 35624 | 2021-12-09 | Alaska | 2 | 151979 | 862 |
35625 | 35625 | 2021-12-09 | American Samoa | 60 | 10 | 0 |
35626 | 35626 | 2021-12-09 | Arizona | 4 | 1305260 | 22854 |
35627 | 35627 | 2021-12-09 | Arkansas | 5 | 536368 | 8810 |
35628 | 35628 | 2021-12-09 | California | 6 | 5148904 | 75374 |
35629 | 35629 | 2021-12-09 | Colorado | 8 | 856884 | 9744 |
35630 | 35630 | 2021-12-09 | Connecticut | 9 | 436143 | 8946 |
35631 | 35631 | 2021-12-09 | Delaware | 10 | 158600 | 2210 |
35632 | 35632 | 2021-12-09 | District of Columbia | 11 | 68460 | 1197 |
35633 | 35633 | 2021-12-09 | Florida | 12 | 3708204 | 62007 |
35634 | 35634 | 2021-12-09 | Georgia | 13 | 1642875 | 29675 |
35635 | 35635 | 2021-12-09 | Guam | 66 | 20252 | 268 |
35636 | 35636 | 2021-12-09 | Hawaii | 15 | 85676 | 1037 |
35637 | 35637 | 2021-12-09 | Idaho | 16 | 311178 | 4014 |
35638 | 35638 | 2021-12-09 | Illinois | 17 | 1882641 | 29793 |
35639 | 35639 | 2021-12-09 | Indiana | 18 | 1149275 | 17954 |
35640 | 35640 | 2021-12-09 | Iowa | 19 | 542433 | 7550 |
35641 | 35641 | 2021-12-09 | Kansas | 20 | 483238 | 6799 |
35642 | 35642 | 2021-12-09 | Kentucky | 21 | 812786 | 11540 |
35643 | 35643 | 2021-12-09 | Louisiana | 22 | 775368 | 14867 |
35644 | 35644 | 2021-12-09 | Maine | 23 | 126833 | 1357 |
35645 | 35645 | 2021-12-09 | Maryland | 24 | 592912 | 11255 |
35646 | 35646 | 2021-12-09 | Massachusetts | 25 | 963923 | 19606 |
35647 | 35647 | 2021-12-09 | Michigan | 26 | 1550852 | 26614 |
35648 | 35648 | 2021-12-09 | Minnesota | 27 | 952356 | 9938 |
35649 | 35649 | 2021-12-09 | Mississippi | 28 | 518670 | 10317 |
35650 | 35650 | 2021-12-09 | Missouri | 29 | 948588 | 15688 |
35651 | 35651 | 2021-12-09 | Montana | 30 | 193755 | 2789 |
35652 | 35652 | 2021-12-09 | Nebraska | 31 | 319847 | 3241 |
35653 | 35653 | 2021-12-09 | Nevada | 32 | 477407 | 8153 |
35654 | 35654 | 2021-12-09 | New Hampshire | 33 | 173089 | 1773 |
35655 | 35655 | 2021-12-09 | New Jersey | 34 | 1289542 | 28526 |
35656 | 35656 | 2021-12-09 | New Mexico | 35 | 328332 | 5461 |
35657 | 35657 | 2021-12-09 | New York | 36 | 2816974 | 57507 |
35658 | 35658 | 2021-12-09 | North Carolina | 37 | 1562961 | 18965 |
35659 | 35659 | 2021-12-09 | North Dakota | 38 | 166272 | 1983 |
35660 | 35660 | 2021-12-09 | Northern Mariana Islands | 69 | 1514 | 5 |
35661 | 35661 | 2021-12-09 | Ohio | 39 | 1761008 | 27011 |
35662 | 35662 | 2021-12-09 | Oklahoma | 40 | 678343 | 11384 |
35663 | 35663 | 2021-12-09 | Oregon | 41 | 399361 | 5356 |
35664 | 35664 | 2021-12-09 | Pennsylvania | 42 | 1806671 | 34271 |
35665 | 35665 | 2021-12-09 | Puerto Rico | 72 | 222841 | 3274 |
35666 | 35666 | 2021-12-09 | Rhode Island | 44 | 200197 | 2951 |
35667 | 35667 | 2021-12-09 | South Carolina | 45 | 927649 | 14347 |
35668 | 35668 | 2021-12-09 | South Dakota | 46 | 170800 | 2392 |
35669 | 35669 | 2021-12-09 | Tennessee | 47 | 1301673 | 17519 |
35670 | 35670 | 2021-12-09 | Texas | 48 | 4360146 | 74767 |
35671 | 35671 | 2021-12-09 | Utah | 49 | 609486 | 3632 |
35672 | 35672 | 2021-12-09 | Vermont | 50 | 54321 | 426 |
35673 | 35673 | 2021-12-09 | Virgin Islands | 78 | 7588 | 87 |
35674 | 35674 | 2021-12-09 | Virginia | 51 | 991221 | 14868 |
35675 | 35675 | 2021-12-09 | Washington | 53 | 791852 | 9584 |
35676 | 35676 | 2021-12-09 | West Virginia | 54 | 304355 | 5055 |
35677 | 35677 | 2021-12-09 | Wisconsin | 55 | 1017528 | 10330 |
35678 | 35678 | 2021-12-09 | Wyoming | 56 | 112731 | 1472 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );