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 2020-12-02 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 |
---|---|---|---|---|---|---|
15085 | 15085 | 2020-12-02 | Alabama | 1 | 256828 | 3711 |
15086 | 15086 | 2020-12-02 | Alaska | 2 | 33614 | 116 |
15087 | 15087 | 2020-12-02 | Arizona | 4 | 342925 | 6755 |
15088 | 15088 | 2020-12-02 | Arkansas | 5 | 161521 | 2522 |
15089 | 15089 | 2020-12-02 | California | 6 | 1272079 | 19440 |
15090 | 15090 | 2020-12-02 | Colorado | 8 | 243324 | 3226 |
15091 | 15091 | 2020-12-02 | Connecticut | 9 | 121426 | 5091 |
15092 | 15092 | 2020-12-02 | Delaware | 10 | 36698 | 779 |
15093 | 15093 | 2020-12-02 | District of Columbia | 11 | 21842 | 690 |
15094 | 15094 | 2020-12-02 | Florida | 12 | 1018152 | 18775 |
15095 | 15095 | 2020-12-02 | Georgia | 13 | 464417 | 9301 |
15096 | 15096 | 2020-12-02 | Guam | 66 | 7889 | 113 |
15097 | 15097 | 2020-12-02 | Hawaii | 15 | 18117 | 242 |
15098 | 15098 | 2020-12-02 | Idaho | 16 | 105250 | 1002 |
15099 | 15099 | 2020-12-02 | Illinois | 17 | 750208 | 13433 |
15100 | 15100 | 2020-12-02 | Indiana | 18 | 353722 | 5973 |
15101 | 15101 | 2020-12-02 | Iowa | 19 | 236159 | 2518 |
15102 | 15102 | 2020-12-02 | Kansas | 20 | 164981 | 1679 |
15103 | 15103 | 2020-12-02 | Kentucky | 21 | 191067 | 2124 |
15104 | 15104 | 2020-12-02 | Louisiana | 22 | 241335 | 6501 |
15105 | 15105 | 2020-12-02 | Maine | 23 | 12208 | 218 |
15106 | 15106 | 2020-12-02 | Maryland | 24 | 203672 | 4715 |
15107 | 15107 | 2020-12-02 | Massachusetts | 25 | 234232 | 10824 |
15108 | 15108 | 2020-12-02 | Michigan | 26 | 401953 | 9839 |
15109 | 15109 | 2020-12-02 | Minnesota | 27 | 327536 | 3751 |
15110 | 15110 | 2020-12-02 | Mississippi | 28 | 156868 | 3851 |
15111 | 15111 | 2020-12-02 | Missouri | 29 | 321411 | 4185 |
15112 | 15112 | 2020-12-02 | Montana | 30 | 64399 | 713 |
15113 | 15113 | 2020-12-02 | Nebraska | 31 | 133139 | 1139 |
15114 | 15114 | 2020-12-02 | Nevada | 32 | 157586 | 2225 |
15115 | 15115 | 2020-12-02 | New Hampshire | 33 | 22332 | 537 |
15116 | 15116 | 2020-12-02 | New Jersey | 34 | 348042 | 17145 |
15117 | 15117 | 2020-12-02 | New Mexico | 35 | 100963 | 1629 |
15118 | 15118 | 2020-12-02 | New York | 36 | 669016 | 34286 |
15119 | 15119 | 2020-12-02 | North Carolina | 37 | 372525 | 5406 |
15120 | 15120 | 2020-12-02 | North Dakota | 38 | 80141 | 972 |
15121 | 15121 | 2020-12-02 | Northern Mariana Islands | 69 | 106 | 2 |
15122 | 15122 | 2020-12-02 | Ohio | 39 | 437928 | 6671 |
15123 | 15123 | 2020-12-02 | Oklahoma | 40 | 202341 | 1812 |
15124 | 15124 | 2020-12-02 | Oregon | 41 | 78206 | 962 |
15125 | 15125 | 2020-12-02 | Pennsylvania | 42 | 381342 | 10803 |
15126 | 15126 | 2020-12-02 | Puerto Rico | 72 | 87323 | 1144 |
15127 | 15127 | 2020-12-02 | Rhode Island | 44 | 59005 | 1391 |
15128 | 15128 | 2020-12-02 | South Carolina | 45 | 220835 | 4444 |
15129 | 15129 | 2020-12-02 | South Dakota | 46 | 82203 | 995 |
15130 | 15130 | 2020-12-02 | Tennessee | 47 | 375995 | 4635 |
15131 | 15131 | 2020-12-02 | Texas | 48 | 1293839 | 22422 |
15132 | 15132 | 2020-12-02 | Utah | 49 | 202220 | 906 |
15133 | 15133 | 2020-12-02 | Vermont | 50 | 4461 | 74 |
15134 | 15134 | 2020-12-02 | Virgin Islands | 78 | 1589 | 23 |
15135 | 15135 | 2020-12-02 | Virginia | 51 | 242480 | 4113 |
15136 | 15136 | 2020-12-02 | Washington | 53 | 177929 | 2979 |
15137 | 15137 | 2020-12-02 | West Virginia | 54 | 49905 | 778 |
15138 | 15138 | 2020-12-02 | Wisconsin | 55 | 420930 | 3715 |
15139 | 15139 | 2020-12-02 | Wyoming | 56 | 34507 | 230 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );