ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57,238 rows sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- New York 1,006
- New Jersey 997
- Michigan 994
- Louisiana 989
- Massachusetts 989
- Illinois 987
- California 986
- Pennsylvania 986
- Connecticut 985
- Florida 976
- Georgia 974
- Indiana 974
- Maryland 974
- Ohio 969
- Texas 964
- Colorado 959
- Virginia 953
- Washington 947
- Minnesota 940
- Arizona 933
- North Carolina 932
- Mississippi 910
- Alabama 903
- Missouri 903
- South Carolina 896
- Tennessee 878
- Nevada 864
- Wisconsin 857
- Iowa 854
- Kentucky 839
- …
Link | rowid | date | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|
7538 | 7538 | 2020-07-17 | South Carolina | 45 | 66060 | 1096 |
22628 | 22628 | 2021-04-18 | District of Columbia | 11 | 46662 | 1096 |
22683 | 22683 | 2021-04-19 | District of Columbia | 11 | 46740 | 1096 |
5099 | 5099 | 2020-06-03 | Minnesota | 27 | 25881 | 1097 |
11167 | 11167 | 2020-09-21 | Rhode Island | 44 | 23932 | 1097 |
22738 | 22738 | 2021-04-20 | District of Columbia | 11 | 46869 | 1097 |
22793 | 22793 | 2021-04-21 | District of Columbia | 11 | 46941 | 1097 |
12263 | 12263 | 2020-10-11 | Oklahoma | 40 | 99387 | 1098 |
18745 | 18745 | 2021-02-06 | New Hampshire | 33 | 68061 | 1098 |
22848 | 22848 | 2021-04-22 | District of Columbia | 11 | 47040 | 1098 |
37260 | 37260 | 2022-01-07 | Hawaii | 15 | 130605 | 1098 |
4410 | 4410 | 2020-05-21 | Virginia | 51 | 34137 | 1099 |
10648 | 10648 | 2020-09-12 | Kentucky | 21 | 60187 | 1099 |
11222 | 11222 | 2020-09-22 | Rhode Island | 44 | 24044 | 1099 |
22903 | 22903 | 2021-04-23 | District of Columbia | 11 | 47141 | 1099 |
22958 | 22958 | 2021-04-24 | District of Columbia | 11 | 47219 | 1099 |
23013 | 23013 | 2021-04-25 | District of Columbia | 11 | 47323 | 1099 |
23068 | 23068 | 2021-04-26 | District of Columbia | 11 | 47378 | 1099 |
37316 | 37316 | 2022-01-08 | Hawaii | 15 | 134753 | 1099 |
5462 | 5462 | 2020-06-10 | Arizona | 4 | 29981 | 1100 |
23123 | 23123 | 2021-04-27 | District of Columbia | 11 | 47471 | 1100 |
18447 | 18447 | 2021-02-01 | Delaware | 10 | 78495 | 1101 |
9284 | 9284 | 2020-08-18 | Nevada | 32 | 62752 | 1102 |
10703 | 10703 | 2020-09-13 | Kentucky | 21 | 60607 | 1102 |
11277 | 11277 | 2020-09-23 | Rhode Island | 44 | 24177 | 1102 |
15902 | 15902 | 2020-12-16 | Utah | 49 | 240715 | 1102 |
17862 | 17862 | 2021-01-21 | Montana | 30 | 90742 | 1102 |
32788 | 32788 | 2021-10-19 | Maine | 23 | 98607 | 1102 |
37372 | 37372 | 2022-01-09 | Hawaii | 15 | 139262 | 1102 |
37428 | 37428 | 2022-01-10 | Hawaii | 15 | 143089 | 1102 |
37484 | 37484 | 2022-01-11 | Hawaii | 15 | 146000 | 1102 |
2399 | 2399 | 2020-04-15 | Louisiana | 22 | 21951 | 1103 |
6750 | 6750 | 2020-07-03 | Mississippi | 28 | 29684 | 1103 |
8530 | 8530 | 2020-08-04 | Tennessee | 47 | 109652 | 1103 |
7110 | 7110 | 2020-07-10 | Alabama | 1 | 50508 | 1104 |
12318 | 12318 | 2020-10-12 | Oklahoma | 40 | 100184 | 1104 |
13742 | 13742 | 2020-11-07 | New Mexico | 35 | 53671 | 1104 |
18800 | 18800 | 2021-02-07 | New Hampshire | 33 | 68379 | 1104 |
23178 | 23178 | 2021-04-28 | District of Columbia | 11 | 47533 | 1104 |
10758 | 10758 | 2020-09-14 | Kentucky | 21 | 61182 | 1105 |
23233 | 23233 | 2021-04-29 | District of Columbia | 11 | 47614 | 1105 |
23288 | 23288 | 2021-04-30 | District of Columbia | 11 | 47697 | 1105 |
4741 | 4741 | 2020-05-27 | Washington | 53 | 21825 | 1106 |
9693 | 9693 | 2020-08-25 | Wisconsin | 55 | 76453 | 1106 |
11332 | 11332 | 2020-09-24 | Rhode Island | 44 | 24311 | 1106 |
15016 | 15016 | 2020-11-30 | Puerto Rico | 72 | 86160 | 1106 |
17917 | 17917 | 2021-01-22 | Montana | 30 | 91145 | 1106 |
18855 | 18855 | 2021-02-08 | New Hampshire | 33 | 68499 | 1106 |
23343 | 23343 | 2021-05-01 | District of Columbia | 11 | 47800 | 1106 |
23398 | 23398 | 2021-05-02 | District of Columbia | 11 | 47855 | 1106 |
23453 | 23453 | 2021-05-03 | District of Columbia | 11 | 47903 | 1106 |
23508 | 23508 | 2021-05-04 | District of Columbia | 11 | 47986 | 1106 |
6805 | 6805 | 2020-07-04 | Mississippi | 28 | 30674 | 1107 |
7136 | 7136 | 2020-07-10 | Missouri | 29 | 28060 | 1107 |
11387 | 11387 | 2020-09-25 | Rhode Island | 44 | 24181 | 1107 |
11442 | 11442 | 2020-09-26 | Rhode Island | 44 | 24181 | 1107 |
11497 | 11497 | 2020-09-27 | Rhode Island | 44 | 24181 | 1107 |
37540 | 37540 | 2022-01-12 | Hawaii | 15 | 149460 | 1107 |
2402 | 2402 | 2020-04-15 | Massachusetts | 25 | 29918 | 1108 |
9821 | 9821 | 2020-08-28 | Iowa | 19 | 62828 | 1108 |
18502 | 18502 | 2021-02-02 | Delaware | 10 | 78696 | 1108 |
39488 | 39488 | 2022-02-16 | Alaska | 2 | 233405 | 1108 |
39544 | 39544 | 2022-02-17 | Alaska | 2 | 233405 | 1108 |
39600 | 39600 | 2022-02-18 | Alaska | 2 | 234541 | 1108 |
39656 | 39656 | 2022-02-19 | Alaska | 2 | 234541 | 1108 |
39712 | 39712 | 2022-02-20 | Alaska | 2 | 234541 | 1108 |
39768 | 39768 | 2022-02-21 | Alaska | 2 | 234541 | 1108 |
39824 | 39824 | 2022-02-22 | Alaska | 2 | 234541 | 1108 |
15560 | 15560 | 2020-12-10 | North Dakota | 38 | 87210 | 1109 |
18910 | 18910 | 2021-02-09 | New Hampshire | 33 | 68918 | 1109 |
23563 | 23563 | 2021-05-05 | District of Columbia | 11 | 48041 | 1109 |
32844 | 32844 | 2021-10-20 | Maine | 23 | 99256 | 1109 |
3801 | 3801 | 2020-05-10 | Texas | 48 | 40037 | 1110 |
9876 | 9876 | 2020-08-29 | Iowa | 19 | 63836 | 1110 |
11552 | 11552 | 2020-09-28 | Rhode Island | 44 | 24424 | 1110 |
15349 | 15349 | 2020-12-06 | South Dakota | 46 | 85991 | 1110 |
15404 | 15404 | 2020-12-07 | South Dakota | 46 | 86500 | 1110 |
23618 | 23618 | 2021-05-06 | District of Columbia | 11 | 48080 | 1110 |
23673 | 23673 | 2021-05-07 | District of Columbia | 11 | 48136 | 1110 |
23728 | 23728 | 2021-05-08 | District of Columbia | 11 | 48164 | 1110 |
23783 | 23783 | 2021-05-09 | District of Columbia | 11 | 48180 | 1110 |
23838 | 23838 | 2021-05-10 | District of Columbia | 11 | 48195 | 1110 |
6860 | 6860 | 2020-07-05 | Mississippi | 28 | 30900 | 1111 |
15459 | 15459 | 2020-12-08 | South Dakota | 46 | 87038 | 1111 |
37596 | 37596 | 2022-01-13 | Hawaii | 15 | 152811 | 1111 |
7191 | 7191 | 2020-07-11 | Missouri | 29 | 28649 | 1112 |
9748 | 9748 | 2020-08-26 | Wisconsin | 55 | 77220 | 1112 |
10813 | 10813 | 2020-09-15 | Kentucky | 21 | 61986 | 1112 |
15509 | 15509 | 2020-12-09 | Oregon | 41 | 88308 | 1112 |
7246 | 7246 | 2020-07-12 | Missouri | 29 | 29173 | 1113 |
9931 | 9931 | 2020-08-30 | Iowa | 19 | 64599 | 1113 |
11607 | 11607 | 2020-09-29 | Rhode Island | 44 | 24556 | 1113 |
23893 | 23893 | 2021-05-11 | District of Columbia | 11 | 48282 | 1113 |
32900 | 32900 | 2021-10-21 | Maine | 23 | 99807 | 1113 |
3220 | 3220 | 2020-04-30 | Indiana | 18 | 18099 | 1114 |
5549 | 5549 | 2020-06-11 | North Carolina | 37 | 39735 | 1114 |
6915 | 6915 | 2020-07-06 | Mississippi | 28 | 31257 | 1114 |
7165 | 7165 | 2020-07-11 | Alabama | 1 | 51947 | 1114 |
11662 | 11662 | 2020-09-30 | Rhode Island | 44 | 24748 | 1114 |
37652 | 37652 | 2022-01-14 | Hawaii | 15 | 155839 | 1114 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );