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-04-30 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 |
---|---|---|---|---|---|---|
43575 | 43575 | 2022-04-30 | Alabama | 1 | 1300733 | 19567 |
43576 | 43576 | 2022-04-30 | Alaska | 2 | 251388 | 1212 |
43577 | 43577 | 2022-04-30 | American Samoa | 60 | 5517 | 12 |
43578 | 43578 | 2022-04-30 | Arizona | 4 | 2021524 | 29951 |
43579 | 43579 | 2022-04-30 | Arkansas | 5 | 835857 | 11389 |
43580 | 43580 | 2022-04-30 | California | 6 | 9235936 | 90419 |
43581 | 43581 | 2022-04-30 | Colorado | 8 | 1389860 | 12366 |
43582 | 43582 | 2022-04-30 | Connecticut | 9 | 758281 | 10850 |
43583 | 43583 | 2022-04-30 | Delaware | 10 | 262461 | 2907 |
43584 | 43584 | 2022-04-30 | District of Columbia | 11 | 141943 | 1340 |
43585 | 43585 | 2022-04-30 | Florida | 12 | 5925668 | 73948 |
43586 | 43586 | 2022-04-30 | Georgia | 13 | 2445476 | 36349 |
43587 | 43587 | 2022-04-30 | Guam | 66 | 49106 | 355 |
43588 | 43588 | 2022-04-30 | Hawaii | 15 | 241955 | 1415 |
43589 | 43589 | 2022-04-30 | Idaho | 16 | 446138 | 4930 |
43590 | 43590 | 2022-04-30 | Illinois | 17 | 3144347 | 37898 |
43591 | 43591 | 2022-04-30 | Indiana | 18 | 1702292 | 23587 |
43592 | 43592 | 2022-04-30 | Iowa | 19 | 763782 | 9529 |
43593 | 43593 | 2022-04-30 | Kansas | 20 | 776663 | 8635 |
43594 | 43594 | 2022-04-30 | Kentucky | 21 | 1337049 | 15418 |
43595 | 43595 | 2022-04-30 | Louisiana | 22 | 1238011 | 17248 |
43596 | 43596 | 2022-04-30 | Maine | 23 | 245080 | 2286 |
43597 | 43597 | 2022-04-30 | Maryland | 24 | 1031797 | 14456 |
43598 | 43598 | 2022-04-30 | Massachusetts | 25 | 1757103 | 20263 |
43599 | 43599 | 2022-04-30 | Michigan | 26 | 2425946 | 36002 |
43600 | 43600 | 2022-04-30 | Minnesota | 27 | 1452817 | 12778 |
43601 | 43601 | 2022-04-30 | Mississippi | 28 | 797575 | 12444 |
43602 | 43602 | 2022-04-30 | Missouri | 29 | 1433608 | 20199 |
43603 | 43603 | 2022-04-30 | Montana | 30 | 274221 | 3363 |
43604 | 43604 | 2022-04-30 | Nebraska | 31 | 479989 | 4197 |
43605 | 43605 | 2022-04-30 | Nevada | 32 | 719451 | 10774 |
43606 | 43606 | 2022-04-30 | New Hampshire | 33 | 309982 | 2480 |
43607 | 43607 | 2022-04-30 | New Jersey | 34 | 2261694 | 33433 |
43608 | 43608 | 2022-04-30 | New Mexico | 35 | 522329 | 7501 |
43609 | 43609 | 2022-04-30 | New York | 36 | 5150193 | 67684 |
43610 | 43610 | 2022-04-30 | North Carolina | 37 | 2661333 | 23415 |
43611 | 43611 | 2022-04-30 | North Dakota | 38 | 241127 | 2315 |
43612 | 43612 | 2022-04-30 | Northern Mariana Islands | 69 | 11263 | 34 |
43613 | 43613 | 2022-04-30 | Ohio | 39 | 2697058 | 38428 |
43614 | 43614 | 2022-04-30 | Oklahoma | 40 | 1040982 | 14271 |
43615 | 43615 | 2022-04-30 | Oregon | 41 | 721311 | 7502 |
43616 | 43616 | 2022-04-30 | Pennsylvania | 42 | 2820219 | 44677 |
43617 | 43617 | 2022-04-30 | Puerto Rico | 72 | 570895 | 4207 |
43618 | 43618 | 2022-04-30 | Rhode Island | 44 | 371629 | 3540 |
43619 | 43619 | 2022-04-30 | South Carolina | 45 | 1474272 | 17767 |
43620 | 43620 | 2022-04-30 | South Dakota | 46 | 237812 | 2912 |
43621 | 43621 | 2022-04-30 | Tennessee | 47 | 1981990 | 25895 |
43622 | 43622 | 2022-04-30 | Texas | 48 | 6752149 | 88303 |
43623 | 43623 | 2022-04-30 | Utah | 49 | 932480 | 4747 |
43624 | 43624 | 2022-04-30 | Vermont | 50 | 123842 | 637 |
43625 | 43625 | 2022-04-30 | Virgin Islands | 78 | 16306 | 111 |
43626 | 43626 | 2022-04-30 | Virginia | 51 | 1701458 | 20236 |
43627 | 43627 | 2022-04-30 | Washington | 53 | 1498708 | 12747 |
43628 | 43628 | 2022-04-30 | West Virginia | 54 | 501204 | 6856 |
43629 | 43629 | 2022-04-30 | Wisconsin | 55 | 1610673 | 14413 |
43630 | 43630 | 2022-04-30 | Wyoming | 56 | 156550 | 1812 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );