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-22 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 |
---|---|---|---|---|---|---|
16185 | 16185 | 2020-12-22 | Alabama | 1 | 329811 | 4452 |
16186 | 16186 | 2020-12-22 | Alaska | 2 | 44241 | 186 |
16187 | 16187 | 2020-12-22 | Arizona | 4 | 470351 | 8133 |
16188 | 16188 | 2020-12-22 | Arkansas | 5 | 205048 | 3338 |
16189 | 16189 | 2020-12-22 | California | 6 | 1968541 | 23254 |
16190 | 16190 | 2020-12-22 | Colorado | 8 | 315397 | 4464 |
16191 | 16191 | 2020-12-22 | Connecticut | 9 | 168960 | 5703 |
16192 | 16192 | 2020-12-22 | Delaware | 10 | 51623 | 872 |
16193 | 16193 | 2020-12-22 | District of Columbia | 11 | 26900 | 744 |
16194 | 16194 | 2020-12-22 | Florida | 12 | 1223007 | 20753 |
16195 | 16195 | 2020-12-22 | Georgia | 13 | 579957 | 10135 |
16196 | 16196 | 2020-12-22 | Guam | 66 | 8180 | 121 |
16197 | 16197 | 2020-12-22 | Hawaii | 15 | 20487 | 280 |
16198 | 16198 | 2020-12-22 | Idaho | 16 | 132950 | 1317 |
16199 | 16199 | 2020-12-22 | Illinois | 17 | 913265 | 16677 |
16200 | 16200 | 2020-12-22 | Indiana | 18 | 474797 | 7581 |
16201 | 16201 | 2020-12-22 | Iowa | 19 | 270294 | 3653 |
16202 | 16202 | 2020-12-22 | Kansas | 20 | 208109 | 2448 |
16203 | 16203 | 2020-12-22 | Kentucky | 21 | 250089 | 2739 |
16204 | 16204 | 2020-12-22 | Louisiana | 22 | 290960 | 7158 |
16205 | 16205 | 2020-12-22 | Maine | 23 | 19743 | 303 |
16206 | 16206 | 2020-12-22 | Maryland | 24 | 255666 | 5519 |
16207 | 16207 | 2020-12-22 | Massachusetts | 25 | 331174 | 11804 |
16208 | 16208 | 2020-12-22 | Michigan | 26 | 503497 | 12333 |
16209 | 16209 | 2020-12-22 | Minnesota | 27 | 401070 | 4955 |
16210 | 16210 | 2020-12-22 | Mississippi | 28 | 197691 | 4490 |
16211 | 16211 | 2020-12-22 | Missouri | 29 | 393488 | 5474 |
16212 | 16212 | 2020-12-22 | Montana | 30 | 78017 | 901 |
16213 | 16213 | 2020-12-22 | Nebraska | 31 | 159267 | 1553 |
16214 | 16214 | 2020-12-22 | Nevada | 32 | 207351 | 2832 |
16215 | 16215 | 2020-12-22 | New Hampshire | 33 | 38008 | 656 |
16216 | 16216 | 2020-12-22 | New Jersey | 34 | 442274 | 18326 |
16217 | 16217 | 2020-12-22 | New Mexico | 35 | 132075 | 2203 |
16218 | 16218 | 2020-12-22 | New York | 36 | 871155 | 36300 |
16219 | 16219 | 2020-12-22 | North Carolina | 37 | 491242 | 6342 |
16220 | 16220 | 2020-12-22 | North Dakota | 38 | 90459 | 1244 |
16221 | 16221 | 2020-12-22 | Northern Mariana Islands | 69 | 116 | 2 |
16222 | 16222 | 2020-12-22 | Ohio | 39 | 637032 | 8252 |
16223 | 16223 | 2020-12-22 | Oklahoma | 40 | 265620 | 2240 |
16224 | 16224 | 2020-12-22 | Oregon | 41 | 105091 | 1382 |
16225 | 16225 | 2020-12-22 | Pennsylvania | 42 | 577183 | 14244 |
16226 | 16226 | 2020-12-22 | Puerto Rico | 72 | 103527 | 1391 |
16227 | 16227 | 2020-12-22 | Rhode Island | 44 | 81187 | 1678 |
16228 | 16228 | 2020-12-22 | South Carolina | 45 | 278055 | 4976 |
16229 | 16229 | 2020-12-22 | South Dakota | 46 | 95509 | 1381 |
16230 | 16230 | 2020-12-22 | Tennessee | 47 | 519475 | 6205 |
16231 | 16231 | 2020-12-22 | Texas | 48 | 1630886 | 26363 |
16232 | 16232 | 2020-12-22 | Utah | 49 | 255085 | 1175 |
16233 | 16233 | 2020-12-22 | Vermont | 50 | 6608 | 112 |
16234 | 16234 | 2020-12-22 | Virgin Islands | 78 | 1934 | 23 |
16235 | 16235 | 2020-12-22 | Virginia | 51 | 314481 | 4705 |
16236 | 16236 | 2020-12-22 | Washington | 53 | 232204 | 3214 |
16237 | 16237 | 2020-12-22 | West Virginia | 54 | 74737 | 1171 |
16238 | 16238 | 2020-12-22 | Wisconsin | 55 | 497380 | 4882 |
16239 | 16239 | 2020-12-22 | Wyoming | 56 | 42379 | 373 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );