us-states
Data source: Big Local News · About: big-local-datasette
11,399 rows sorted by date descending
This data as json, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
11345 | 11345 | 2020-09-25 | Alabama | 1 | 150658 | 2491 |
11346 | 11346 | 2020-09-25 | Alaska | 2 | 8133 | 48 |
11347 | 11347 | 2020-09-25 | Arizona | 4 | 216367 | 5588 |
11348 | 11348 | 2020-09-25 | Arkansas | 5 | 79946 | 1266 |
11349 | 11349 | 2020-09-25 | California | 6 | 805733 | 15533 |
11350 | 11350 | 2020-09-25 | Colorado | 8 | 68506 | 2045 |
11351 | 11351 | 2020-09-25 | Connecticut | 9 | 56587 | 4501 |
11352 | 11352 | 2020-09-25 | Delaware | 10 | 20085 | 631 |
11353 | 11353 | 2020-09-25 | District of Columbia | 11 | 15163 | 623 |
11354 | 11354 | 2020-09-25 | Florida | 12 | 695879 | 13914 |
11355 | 11355 | 2020-09-25 | Georgia | 13 | 296089 | 6717 |
11356 | 11356 | 2020-09-25 | Guam | 66 | 3255 | 40 |
11357 | 11357 | 2020-09-25 | Hawaii | 15 | 12039 | 126 |
11358 | 11358 | 2020-09-25 | Idaho | 16 | 40228 | 458 |
11359 | 11359 | 2020-09-25 | Illinois | 17 | 287375 | 8826 |
11360 | 11360 | 2020-09-25 | Indiana | 18 | 117656 | 3566 |
11361 | 11361 | 2020-09-25 | Iowa | 19 | 85031 | 1312 |
11362 | 11362 | 2020-09-25 | Kansas | 20 | 57813 | 634 |
11363 | 11363 | 2020-09-25 | Kentucky | 21 | 69150 | 1179 |
11364 | 11364 | 2020-09-25 | Louisiana | 22 | 165152 | 5444 |
11365 | 11365 | 2020-09-25 | Maine | 23 | 5235 | 140 |
11366 | 11366 | 2020-09-25 | Maryland | 24 | 122850 | 3917 |
11367 | 11367 | 2020-09-25 | Massachusetts | 25 | 129481 | 9373 |
11368 | 11368 | 2020-09-25 | Michigan | 26 | 133443 | 7028 |
11369 | 11369 | 2020-09-25 | Minnesota | 27 | 94241 | 2046 |
11370 | 11370 | 2020-09-25 | Mississippi | 28 | 96032 | 2894 |
11371 | 11371 | 2020-09-25 | Missouri | 29 | 123168 | 2070 |
11372 | 11372 | 2020-09-25 | Montana | 30 | 11656 | 170 |
11373 | 11373 | 2020-09-25 | Nebraska | 31 | 43162 | 483 |
11374 | 11374 | 2020-09-25 | Nevada | 32 | 77930 | 1573 |
11375 | 11375 | 2020-09-25 | New Hampshire | 33 | 8085 | 438 |
11376 | 11376 | 2020-09-25 | New Jersey | 34 | 203891 | 16097 |
11377 | 11377 | 2020-09-25 | New Mexico | 35 | 28487 | 865 |
11378 | 11378 | 2020-09-25 | New York | 36 | 458466 | 32708 |
11379 | 11379 | 2020-09-25 | North Carolina | 37 | 204658 | 3437 |
11380 | 11380 | 2020-09-25 | North Dakota | 38 | 19888 | 222 |
11381 | 11381 | 2020-09-25 | Northern Mariana Islands | 69 | 69 | 2 |
11382 | 11382 | 2020-09-25 | Ohio | 39 | 148894 | 4734 |
11383 | 11383 | 2020-09-25 | Oklahoma | 40 | 82520 | 993 |
11384 | 11384 | 2020-09-25 | Oregon | 41 | 32328 | 545 |
11385 | 11385 | 2020-09-25 | Pennsylvania | 42 | 159051 | 8157 |
11386 | 11386 | 2020-09-25 | Puerto Rico | 72 | 44905 | 635 |
11387 | 11387 | 2020-09-25 | Rhode Island | 44 | 24181 | 1107 |
11388 | 11388 | 2020-09-25 | South Carolina | 45 | 143902 | 3297 |
11389 | 11389 | 2020-09-25 | South Dakota | 46 | 20554 | 216 |
11390 | 11390 | 2020-09-25 | Tennessee | 47 | 186769 | 2326 |
11391 | 11391 | 2020-09-25 | Texas | 48 | 761644 | 15637 |
11392 | 11392 | 2020-09-25 | Utah | 49 | 68536 | 448 |
11393 | 11393 | 2020-09-25 | Vermont | 50 | 1731 | 58 |
11394 | 11394 | 2020-09-25 | Virgin Islands | 78 | 1296 | 19 |
11395 | 11395 | 2020-09-25 | Virginia | 51 | 144433 | 3136 |
11396 | 11396 | 2020-09-25 | Washington | 53 | 89149 | 2193 |
11397 | 11397 | 2020-09-25 | West Virginia | 54 | 14953 | 330 |
11398 | 11398 | 2020-09-25 | Wisconsin | 55 | 117355 | 1285 |
11399 | 11399 | 2020-09-25 | Wyoming | 56 | 5420 | 50 |
11290 | 11290 | 2020-09-24 | Alabama | 1 | 148206 | 2506 |
11291 | 11291 | 2020-09-24 | Alaska | 2 | 8015 | 43 |
11292 | 11292 | 2020-09-24 | Arizona | 4 | 215852 | 5560 |
11293 | 11293 | 2020-09-24 | Arkansas | 5 | 79049 | 1246 |
11294 | 11294 | 2020-09-24 | California | 6 | 801671 | 15389 |
11295 | 11295 | 2020-09-24 | Colorado | 8 | 67745 | 2042 |
11296 | 11296 | 2020-09-24 | Connecticut | 9 | 56472 | 4499 |
11297 | 11297 | 2020-09-24 | Delaware | 10 | 19947 | 630 |
11298 | 11298 | 2020-09-24 | District of Columbia | 11 | 15106 | 621 |
11299 | 11299 | 2020-09-24 | Florida | 12 | 693032 | 13794 |
11300 | 11300 | 2020-09-24 | Georgia | 13 | 294334 | 6667 |
11301 | 11301 | 2020-09-24 | Guam | 66 | 3232 | 39 |
11302 | 11302 | 2020-09-24 | Hawaii | 15 | 11908 | 123 |
11303 | 11303 | 2020-09-24 | Idaho | 16 | 39547 | 458 |
11304 | 11304 | 2020-09-24 | Illinois | 17 | 284620 | 8793 |
11305 | 11305 | 2020-09-24 | Indiana | 18 | 116481 | 3548 |
11306 | 11306 | 2020-09-24 | Iowa | 19 | 83993 | 1303 |
11307 | 11307 | 2020-09-24 | Kansas | 20 | 56432 | 633 |
11308 | 11308 | 2020-09-24 | Kentucky | 21 | 68230 | 1166 |
11309 | 11309 | 2020-09-24 | Louisiana | 22 | 164446 | 5423 |
11310 | 11310 | 2020-09-24 | Maine | 23 | 5215 | 140 |
11311 | 11311 | 2020-09-24 | Maryland | 24 | 122293 | 3909 |
11312 | 11312 | 2020-09-24 | Massachusetts | 25 | 128993 | 9362 |
11313 | 11313 | 2020-09-24 | Michigan | 26 | 132400 | 7020 |
11314 | 11314 | 2020-09-24 | Minnesota | 27 | 93064 | 2040 |
11315 | 11315 | 2020-09-24 | Mississippi | 28 | 95310 | 2874 |
11316 | 11316 | 2020-09-24 | Missouri | 29 | 121143 | 2049 |
11317 | 11317 | 2020-09-24 | Montana | 30 | 11381 | 165 |
11318 | 11318 | 2020-09-24 | Nebraska | 31 | 42731 | 478 |
11319 | 11319 | 2020-09-24 | Nevada | 32 | 77338 | 1565 |
11320 | 11320 | 2020-09-24 | New Hampshire | 33 | 8044 | 438 |
11321 | 11321 | 2020-09-24 | New Jersey | 34 | 203343 | 16091 |
11322 | 11322 | 2020-09-24 | New Mexico | 35 | 28224 | 859 |
11323 | 11323 | 2020-09-24 | New York | 36 | 457557 | 32696 |
11324 | 11324 | 2020-09-24 | North Carolina | 37 | 199236 | 3380 |
11325 | 11325 | 2020-09-24 | North Dakota | 38 | 19454 | 215 |
11326 | 11326 | 2020-09-24 | Northern Mariana Islands | 69 | 69 | 2 |
11327 | 11327 | 2020-09-24 | Ohio | 39 | 147744 | 4715 |
11328 | 11328 | 2020-09-24 | Oklahoma | 40 | 81244 | 981 |
11329 | 11329 | 2020-09-24 | Oregon | 41 | 31869 | 540 |
11330 | 11330 | 2020-09-24 | Pennsylvania | 42 | 158221 | 8150 |
11331 | 11331 | 2020-09-24 | Puerto Rico | 72 | 43842 | 627 |
11332 | 11332 | 2020-09-24 | Rhode Island | 44 | 24311 | 1106 |
11333 | 11333 | 2020-09-24 | South Carolina | 45 | 142707 | 3279 |
11334 | 11334 | 2020-09-24 | South Dakota | 46 | 20097 | 210 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [us-states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );