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-10-29 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 |
---|---|---|---|---|---|---|
13215 | 13215 | 2020-10-29 | Alabama | 1 | 189149 | 2914 |
13216 | 13216 | 2020-10-29 | Alaska | 2 | 15417 | 72 |
13217 | 13217 | 2020-10-29 | Arizona | 4 | 242510 | 5920 |
13218 | 13218 | 2020-10-29 | Arkansas | 5 | 109712 | 1894 |
13219 | 13219 | 2020-10-29 | California | 6 | 926910 | 17567 |
13220 | 13220 | 2020-10-29 | Colorado | 8 | 102665 | 2295 |
13221 | 13221 | 2020-10-29 | Connecticut | 9 | 70446 | 4609 |
13222 | 13222 | 2020-10-29 | Delaware | 10 | 24553 | 689 |
13223 | 13223 | 2020-10-29 | District of Columbia | 11 | 17074 | 645 |
13224 | 13224 | 2020-10-29 | Florida | 12 | 794616 | 16647 |
13225 | 13225 | 2020-10-29 | Georgia | 13 | 368840 | 7737 |
13226 | 13226 | 2020-10-29 | Guam | 66 | 5518 | 79 |
13227 | 13227 | 2020-10-29 | Hawaii | 15 | 15046 | 214 |
13228 | 13228 | 2020-10-29 | Idaho | 16 | 63195 | 618 |
13229 | 13229 | 2020-10-29 | Illinois | 17 | 401622 | 9963 |
13230 | 13230 | 2020-10-29 | Indiana | 18 | 175190 | 4260 |
13231 | 13231 | 2020-10-29 | Iowa | 19 | 123232 | 1705 |
13232 | 13232 | 2020-10-29 | Kansas | 20 | 83838 | 1008 |
13233 | 13233 | 2020-10-29 | Kentucky | 21 | 105517 | 1524 |
13234 | 13234 | 2020-10-29 | Louisiana | 22 | 186216 | 5908 |
13235 | 13235 | 2020-10-29 | Maine | 23 | 6467 | 146 |
13236 | 13236 | 2020-10-29 | Maryland | 24 | 143875 | 4127 |
13237 | 13237 | 2020-10-29 | Massachusetts | 25 | 155564 | 9951 |
13238 | 13238 | 2020-10-29 | Michigan | 26 | 189926 | 7651 |
13239 | 13239 | 2020-10-29 | Minnesota | 27 | 142364 | 2472 |
13240 | 13240 | 2020-10-29 | Mississippi | 28 | 118587 | 3310 |
13241 | 13241 | 2020-10-29 | Missouri | 29 | 184847 | 2978 |
13242 | 13242 | 2020-10-29 | Montana | 30 | 30932 | 339 |
13243 | 13243 | 2020-10-29 | Nebraska | 31 | 68150 | 646 |
13244 | 13244 | 2020-10-29 | Nevada | 32 | 98814 | 1770 |
13245 | 13245 | 2020-10-29 | New Hampshire | 33 | 10768 | 482 |
13246 | 13246 | 2020-10-29 | New Jersey | 34 | 236340 | 16332 |
13247 | 13247 | 2020-10-29 | New Mexico | 35 | 44904 | 994 |
13248 | 13248 | 2020-10-29 | New York | 36 | 507913 | 33128 |
13249 | 13249 | 2020-10-29 | North Carolina | 37 | 269419 | 4307 |
13250 | 13250 | 2020-10-29 | North Dakota | 38 | 41135 | 504 |
13251 | 13251 | 2020-10-29 | Northern Mariana Islands | 69 | 92 | 2 |
13252 | 13252 | 2020-10-29 | Ohio | 39 | 208937 | 5275 |
13253 | 13253 | 2020-10-29 | Oklahoma | 40 | 120193 | 1306 |
13254 | 13254 | 2020-10-29 | Oregon | 41 | 43793 | 674 |
13255 | 13255 | 2020-10-29 | Pennsylvania | 42 | 208087 | 8828 |
13256 | 13256 | 2020-10-29 | Puerto Rico | 72 | 64798 | 814 |
13257 | 13257 | 2020-10-29 | Rhode Island | 44 | 32312 | 1195 |
13258 | 13258 | 2020-10-29 | South Carolina | 45 | 174591 | 3889 |
13259 | 13259 | 2020-10-29 | South Dakota | 46 | 43000 | 403 |
13260 | 13260 | 2020-10-29 | Tennessee | 47 | 252727 | 3229 |
13261 | 13261 | 2020-10-29 | Texas | 48 | 939355 | 18372 |
13262 | 13262 | 2020-10-29 | Utah | 49 | 110666 | 598 |
13263 | 13263 | 2020-10-29 | Vermont | 50 | 2141 | 58 |
13264 | 13264 | 2020-10-29 | Virgin Islands | 78 | 1353 | 21 |
13265 | 13265 | 2020-10-29 | Virginia | 51 | 178183 | 3636 |
13266 | 13266 | 2020-10-29 | Washington | 53 | 110748 | 2463 |
13267 | 13267 | 2020-10-29 | West Virginia | 54 | 23466 | 443 |
13268 | 13268 | 2020-10-29 | Wisconsin | 55 | 226712 | 2008 |
13269 | 13269 | 2020-10-29 | Wyoming | 56 | 12507 | 87 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );