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 2021-02-15 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 |
---|---|---|---|---|---|---|
19210 | 19210 | 2021-02-15 | Alabama | 1 | 481605 | 9244 |
19211 | 19211 | 2021-02-15 | Alaska | 2 | 56008 | 271 |
19212 | 19212 | 2021-02-15 | Arizona | 4 | 798845 | 14978 |
19213 | 19213 | 2021-02-15 | Arkansas | 5 | 313348 | 5275 |
19214 | 19214 | 2021-02-15 | California | 6 | 3490542 | 47115 |
19215 | 19215 | 2021-02-15 | Colorado | 8 | 416905 | 5924 |
19216 | 19216 | 2021-02-15 | Connecticut | 9 | 270242 | 7447 |
19217 | 19217 | 2021-02-15 | Delaware | 10 | 83239 | 1283 |
19218 | 19218 | 2021-02-15 | District of Columbia | 11 | 39001 | 980 |
19219 | 19219 | 2021-02-15 | Florida | 12 | 1830980 | 28933 |
19220 | 19220 | 2021-02-15 | Georgia | 13 | 942484 | 15451 |
19221 | 19221 | 2021-02-15 | Guam | 66 | 8668 | 131 |
19222 | 19222 | 2021-02-15 | Hawaii | 15 | 26803 | 423 |
19223 | 19223 | 2021-02-15 | Idaho | 16 | 167566 | 1805 |
19224 | 19224 | 2021-02-15 | Illinois | 17 | 1166098 | 22166 |
19225 | 19225 | 2021-02-15 | Indiana | 18 | 652836 | 12191 |
19226 | 19226 | 2021-02-15 | Iowa | 19 | 329726 | 5237 |
19227 | 19227 | 2021-02-15 | Kansas | 20 | 290510 | 4406 |
19228 | 19228 | 2021-02-15 | Kentucky | 21 | 393775 | 4464 |
19229 | 19229 | 2021-02-15 | Louisiana | 22 | 420394 | 9325 |
19230 | 19230 | 2021-02-15 | Maine | 23 | 42677 | 649 |
19231 | 19231 | 2021-02-15 | Maryland | 24 | 371885 | 7580 |
19232 | 19232 | 2021-02-15 | Massachusetts | 25 | 559350 | 15517 |
19233 | 19233 | 2021-02-15 | Michigan | 26 | 629490 | 16119 |
19234 | 19234 | 2021-02-15 | Minnesota | 27 | 474237 | 6446 |
19235 | 19235 | 2021-02-15 | Mississippi | 28 | 287980 | 6464 |
19236 | 19236 | 2021-02-15 | Missouri | 29 | 515870 | 7879 |
19237 | 19237 | 2021-02-15 | Montana | 30 | 97575 | 1329 |
19238 | 19238 | 2021-02-15 | Nebraska | 31 | 197761 | 2124 |
19239 | 19239 | 2021-02-15 | Nevada | 32 | 288764 | 4722 |
19240 | 19240 | 2021-02-15 | New Hampshire | 33 | 71017 | 1135 |
19241 | 19241 | 2021-02-15 | New Jersey | 34 | 747432 | 22466 |
19242 | 19242 | 2021-02-15 | New Mexico | 35 | 180761 | 3540 |
19243 | 19243 | 2021-02-15 | New York | 36 | 1546665 | 45552 |
19244 | 19244 | 2021-02-15 | North Carolina | 37 | 825692 | 10545 |
19245 | 19245 | 2021-02-15 | North Dakota | 38 | 98673 | 1461 |
19246 | 19246 | 2021-02-15 | Northern Mariana Islands | 69 | 134 | 2 |
19247 | 19247 | 2021-02-15 | Ohio | 39 | 941265 | 16394 |
19248 | 19248 | 2021-02-15 | Oklahoma | 40 | 414272 | 4041 |
19249 | 19249 | 2021-02-15 | Oregon | 41 | 150464 | 2137 |
19250 | 19250 | 2021-02-15 | Pennsylvania | 42 | 901245 | 23157 |
19251 | 19251 | 2021-02-15 | Puerto Rico | 72 | 131452 | 1920 |
19252 | 19252 | 2021-02-15 | Rhode Island | 44 | 121787 | 2334 |
19253 | 19253 | 2021-02-15 | South Carolina | 45 | 489018 | 8034 |
19254 | 19254 | 2021-02-15 | South Dakota | 46 | 110376 | 1844 |
19255 | 19255 | 2021-02-15 | Tennessee | 47 | 745150 | 10846 |
19256 | 19256 | 2021-02-15 | Texas | 48 | 2569113 | 41484 |
19257 | 19257 | 2021-02-15 | Utah | 49 | 361815 | 1796 |
19258 | 19258 | 2021-02-15 | Vermont | 50 | 13862 | 190 |
19259 | 19259 | 2021-02-15 | Virgin Islands | 78 | 2542 | 25 |
19260 | 19260 | 2021-02-15 | Virginia | 51 | 551538 | 7016 |
19261 | 19261 | 2021-02-15 | Washington | 53 | 331305 | 4739 |
19262 | 19262 | 2021-02-15 | West Virginia | 54 | 127889 | 2212 |
19263 | 19263 | 2021-02-15 | Wisconsin | 55 | 607639 | 6753 |
19264 | 19264 | 2021-02-15 | Wyoming | 56 | 53136 | 647 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );