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-16 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 |
---|---|---|---|---|---|---|
19265 | 19265 | 2021-02-16 | Alabama | 1 | 482488 | 9257 |
19266 | 19266 | 2021-02-16 | Alaska | 2 | 56504 | 276 |
19267 | 19267 | 2021-02-16 | Arizona | 4 | 799944 | 14981 |
19268 | 19268 | 2021-02-16 | Arkansas | 5 | 313525 | 5287 |
19269 | 19269 | 2021-02-16 | California | 6 | 3499336 | 47446 |
19270 | 19270 | 2021-02-16 | Colorado | 8 | 417688 | 5932 |
19271 | 19271 | 2021-02-16 | Connecticut | 9 | 270822 | 7449 |
19272 | 19272 | 2021-02-16 | Delaware | 10 | 83369 | 1291 |
19273 | 19273 | 2021-02-16 | District of Columbia | 11 | 39131 | 982 |
19274 | 19274 | 2021-02-16 | Florida | 12 | 1837277 | 29153 |
19275 | 19275 | 2021-02-16 | Georgia | 13 | 945339 | 15691 |
19276 | 19276 | 2021-02-16 | Guam | 66 | 8670 | 131 |
19277 | 19277 | 2021-02-16 | Hawaii | 15 | 26819 | 423 |
19278 | 19278 | 2021-02-16 | Idaho | 16 | 168097 | 1808 |
19279 | 19279 | 2021-02-16 | Illinois | 17 | 1167889 | 22199 |
19280 | 19280 | 2021-02-16 | Indiana | 18 | 653713 | 12231 |
19281 | 19281 | 2021-02-16 | Iowa | 19 | 330318 | 5263 |
19282 | 19282 | 2021-02-16 | Kansas | 20 | 290556 | 4406 |
19283 | 19283 | 2021-02-16 | Kentucky | 21 | 394829 | 4491 |
19284 | 19284 | 2021-02-16 | Louisiana | 22 | 420394 | 9325 |
19285 | 19285 | 2021-02-16 | Maine | 23 | 42768 | 651 |
19286 | 19286 | 2021-02-16 | Maryland | 24 | 372403 | 7612 |
19287 | 19287 | 2021-02-16 | Massachusetts | 25 | 560576 | 15567 |
19288 | 19288 | 2021-02-16 | Michigan | 26 | 630605 | 16138 |
19289 | 19289 | 2021-02-16 | Minnesota | 27 | 474689 | 6448 |
19290 | 19290 | 2021-02-16 | Mississippi | 28 | 288714 | 6501 |
19291 | 19291 | 2021-02-16 | Missouri | 29 | 516710 | 7888 |
19292 | 19292 | 2021-02-16 | Montana | 30 | 97759 | 1332 |
19293 | 19293 | 2021-02-16 | Nebraska | 31 | 197904 | 2128 |
19294 | 19294 | 2021-02-16 | Nevada | 32 | 289094 | 4736 |
19295 | 19295 | 2021-02-16 | New Hampshire | 33 | 71215 | 1136 |
19296 | 19296 | 2021-02-16 | New Jersey | 34 | 751065 | 22497 |
19297 | 19297 | 2021-02-16 | New Mexico | 35 | 181061 | 3552 |
19298 | 19298 | 2021-02-16 | New York | 36 | 1553374 | 45683 |
19299 | 19299 | 2021-02-16 | North Carolina | 37 | 827985 | 10611 |
19300 | 19300 | 2021-02-16 | North Dakota | 38 | 98811 | 1461 |
19301 | 19301 | 2021-02-16 | Northern Mariana Islands | 69 | 134 | 2 |
19302 | 19302 | 2021-02-16 | Ohio | 39 | 943291 | 16453 |
19303 | 19303 | 2021-02-16 | Oklahoma | 40 | 414780 | 4061 |
19304 | 19304 | 2021-02-16 | Oregon | 41 | 150875 | 2138 |
19305 | 19305 | 2021-02-16 | Pennsylvania | 42 | 904203 | 23166 |
19306 | 19306 | 2021-02-16 | Puerto Rico | 72 | 131932 | 1924 |
19307 | 19307 | 2021-02-16 | Rhode Island | 44 | 122072 | 2344 |
19308 | 19308 | 2021-02-16 | South Carolina | 45 | 490453 | 8055 |
19309 | 19309 | 2021-02-16 | South Dakota | 46 | 110593 | 1844 |
19310 | 19310 | 2021-02-16 | Tennessee | 47 | 746183 | 10862 |
19311 | 19311 | 2021-02-16 | Texas | 48 | 2572743 | 41546 |
19312 | 19312 | 2021-02-16 | Utah | 49 | 362406 | 1797 |
19313 | 19313 | 2021-02-16 | Vermont | 50 | 13917 | 191 |
19314 | 19314 | 2021-02-16 | Virgin Islands | 78 | 2542 | 25 |
19315 | 19315 | 2021-02-16 | Virginia | 51 | 553308 | 7037 |
19316 | 19316 | 2021-02-16 | Washington | 53 | 333185 | 4777 |
19317 | 19317 | 2021-02-16 | West Virginia | 54 | 128117 | 2216 |
19318 | 19318 | 2021-02-16 | Wisconsin | 55 | 608420 | 6792 |
19319 | 19319 | 2021-02-16 | Wyoming | 56 | 53351 | 662 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );