ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57,238 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- Washington 938
- Illinois 934
- California 933
- Arizona 932
- Massachusetts 926
- Wisconsin 923
- Texas 916
- Nebraska 910
- Utah 903
- Oregon 900
- New York 898
- Rhode Island 898
- Florida 897
- Georgia 896
- New Hampshire 896
- North Carolina 896
- New Jersey 895
- Tennessee 894
- Colorado 893
- Maryland 893
- Nevada 893
- Oklahoma 893
- Pennsylvania 893
- South Carolina 893
- Hawaii 892
- Indiana 892
- Kentucky 892
- Minnesota 892
- Vermont 892
- Virginia 892
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
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 |
49511 | 49511 | 2022-08-14 | Alabama | 1 | 1449812 | 20026 |
49512 | 49512 | 2022-08-14 | Alaska | 2 | 287355 | 1290 |
49513 | 49513 | 2022-08-14 | American Samoa | 60 | 7471 | 33 |
49514 | 49514 | 2022-08-14 | Arizona | 4 | 2224964 | 30901 |
49515 | 49515 | 2022-08-14 | Arkansas | 5 | 917061 | 11822 |
49516 | 49516 | 2022-08-14 | California | 6 | 10898548 | 94234 |
49517 | 49517 | 2022-08-14 | Colorado | 8 | 1621006 | 13283 |
49518 | 49518 | 2022-08-14 | Connecticut | 9 | 863913 | 11165 |
49519 | 49519 | 2022-08-14 | Delaware | 10 | 298262 | 3036 |
49520 | 49520 | 2022-08-14 | District of Columbia | 11 | 164373 | 1374 |
49521 | 49521 | 2022-08-14 | Florida | 12 | 6909416 | 78559 |
49522 | 49522 | 2022-08-14 | Georgia | 13 | 2723200 | 37780 |
49523 | 49523 | 2022-08-14 | Guam | 66 | 57594 | 386 |
49524 | 49524 | 2022-08-14 | Hawaii | 15 | 324519 | 1603 |
49525 | 49525 | 2022-08-14 | Idaho | 16 | 484122 | 5063 |
49526 | 49526 | 2022-08-14 | Illinois | 17 | 3627267 | 39108 |
49527 | 49527 | 2022-08-14 | Indiana | 18 | 1859196 | 24222 |
49528 | 49528 | 2022-08-14 | Iowa | 19 | 828444 | 9850 |
49529 | 49529 | 2022-08-14 | Kansas | 20 | 848733 | 8993 |
49530 | 49530 | 2022-08-14 | Kentucky | 21 | 1505397 | 16464 |
49531 | 49531 | 2022-08-14 | Louisiana | 22 | 1400265 | 17699 |
49532 | 49532 | 2022-08-14 | Maine | 23 | 278921 | 2493 |
49533 | 49533 | 2022-08-14 | Maryland | 24 | 1201609 | 15059 |
49534 | 49534 | 2022-08-14 | Massachusetts | 25 | 1987385 | 21285 |
49535 | 49535 | 2022-08-14 | Michigan | 26 | 2708622 | 37671 |
49536 | 49536 | 2022-08-14 | Minnesota | 27 | 1611246 | 13362 |
49537 | 49537 | 2022-08-14 | Mississippi | 28 | 892291 | 12720 |
49538 | 49538 | 2022-08-14 | Missouri | 29 | 1604194 | 21251 |
49539 | 49539 | 2022-08-14 | Montana | 30 | 300859 | 3481 |
49540 | 49540 | 2022-08-14 | Nebraska | 31 | 522491 | 4394 |
49541 | 49541 | 2022-08-14 | Nevada | 32 | 834897 | 11316 |
49542 | 49542 | 2022-08-14 | New Hampshire | 33 | 341134 | 2640 |
49543 | 49543 | 2022-08-14 | New Jersey | 34 | 2639310 | 34405 |
49544 | 49544 | 2022-08-14 | New Mexico | 35 | 601422 | 8314 |
49545 | 49545 | 2022-08-14 | New York | 36 | 5893546 | 69976 |
49546 | 49546 | 2022-08-14 | North Carolina | 37 | 3047625 | 25734 |
49547 | 49547 | 2022-08-14 | North Dakota | 38 | 261045 | 2373 |
49548 | 49548 | 2022-08-14 | Northern Mariana Islands | 69 | 12871 | 39 |
49549 | 49549 | 2022-08-14 | Ohio | 39 | 3002043 | 39220 |
49550 | 49550 | 2022-08-14 | Oklahoma | 40 | 1144252 | 14623 |
49551 | 49551 | 2022-08-14 | Oregon | 41 | 864935 | 8267 |
49552 | 49552 | 2022-08-14 | Pennsylvania | 42 | 3131000 | 46398 |
49553 | 49553 | 2022-08-14 | Puerto Rico | 72 | 924786 | 4852 |
49554 | 49554 | 2022-08-14 | Rhode Island | 44 | 413259 | 3632 |
49555 | 49555 | 2022-08-14 | South Carolina | 45 | 1637108 | 18215 |
49556 | 49556 | 2022-08-14 | South Dakota | 46 | 253232 | 2973 |
49557 | 49557 | 2022-08-14 | Tennessee | 47 | 2179883 | 26938 |
49558 | 49558 | 2022-08-14 | Texas | 48 | 7589330 | 89859 |
49559 | 49559 | 2022-08-14 | Utah | 49 | 1020399 | 4940 |
49560 | 49560 | 2022-08-14 | Vermont | 50 | 138779 | 699 |
49561 | 49561 | 2022-08-14 | Virgin Islands | 78 | 22135 | 122 |
49562 | 49562 | 2022-08-14 | Virginia | 51 | 1993874 | 21145 |
49563 | 49563 | 2022-08-14 | Washington | 53 | 1761081 | 13872 |
49564 | 49564 | 2022-08-14 | West Virginia | 54 | 567426 | 7203 |
49565 | 49565 | 2022-08-14 | Wisconsin | 55 | 1803143 | 14980 |
49566 | 49566 | 2022-08-14 | Wyoming | 56 | 172473 | 1865 |
49455 | 49455 | 2022-08-13 | Alabama | 1 | 1449812 | 20026 |
49456 | 49456 | 2022-08-13 | Alaska | 2 | 287355 | 1290 |
49457 | 49457 | 2022-08-13 | American Samoa | 60 | 7471 | 33 |
49458 | 49458 | 2022-08-13 | Arizona | 4 | 2224964 | 30901 |
49459 | 49459 | 2022-08-13 | Arkansas | 5 | 916624 | 11822 |
49460 | 49460 | 2022-08-13 | California | 6 | 10898548 | 94234 |
49461 | 49461 | 2022-08-13 | Colorado | 8 | 1620671 | 13282 |
49462 | 49462 | 2022-08-13 | Connecticut | 9 | 863913 | 11165 |
49463 | 49463 | 2022-08-13 | Delaware | 10 | 298262 | 3036 |
49464 | 49464 | 2022-08-13 | District of Columbia | 11 | 164373 | 1374 |
49465 | 49465 | 2022-08-13 | Florida | 12 | 6909416 | 78559 |
49466 | 49466 | 2022-08-13 | Georgia | 13 | 2723200 | 37780 |
49467 | 49467 | 2022-08-13 | Guam | 66 | 57594 | 386 |
49468 | 49468 | 2022-08-13 | Hawaii | 15 | 324519 | 1603 |
49469 | 49469 | 2022-08-13 | Idaho | 16 | 484122 | 5063 |
49470 | 49470 | 2022-08-13 | Illinois | 17 | 3627267 | 39108 |
49471 | 49471 | 2022-08-13 | Indiana | 18 | 1859196 | 24222 |
49472 | 49472 | 2022-08-13 | Iowa | 19 | 828444 | 9850 |
49473 | 49473 | 2022-08-13 | Kansas | 20 | 848733 | 8993 |
49474 | 49474 | 2022-08-13 | Kentucky | 21 | 1505236 | 16464 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );