ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57,238 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- Washington 270
- Illinois 266
- California 265
- Arizona 264
- Massachusetts 258
- Wisconsin 255
- Texas 248
- Nebraska 242
- Utah 235
- Oregon 232
- Rhode Island 230
- Florida 229
- New York 229
- Georgia 228
- New Hampshire 228
- North Carolina 227
- New Jersey 226
- Tennessee 226
- Colorado 225
- Maryland 225
- Nevada 225
- Oklahoma 225
- Pennsylvania 225
- South Carolina 225
- Hawaii 224
- Indiana 224
- Kentucky 224
- Minnesota 224
- Vermont 224
- Virginia 224
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
12535 | 12535 | 2020-10-16 | North Dakota | 38 | 30522 | 393 |
12536 | 12536 | 2020-10-16 | Northern Mariana Islands | 69 | 80 | 2 |
12537 | 12537 | 2020-10-16 | Ohio | 39 | 177991 | 5054 |
12538 | 12538 | 2020-10-16 | Oklahoma | 40 | 105308 | 1154 |
12539 | 12539 | 2020-10-16 | Oregon | 41 | 38947 | 620 |
12540 | 12540 | 2020-10-16 | Pennsylvania | 42 | 184185 | 8524 |
12541 | 12541 | 2020-10-16 | Puerto Rico | 72 | 56412 | 758 |
12542 | 12542 | 2020-10-16 | Rhode Island | 44 | 27691 | 1152 |
12543 | 12543 | 2020-10-16 | South Carolina | 45 | 162253 | 3615 |
12544 | 12544 | 2020-10-16 | South Dakota | 46 | 31805 | 307 |
12545 | 12545 | 2020-10-16 | Tennessee | 47 | 220099 | 2847 |
12546 | 12546 | 2020-10-16 | Texas | 48 | 859567 | 17454 |
12547 | 12547 | 2020-10-16 | Utah | 49 | 91966 | 539 |
12548 | 12548 | 2020-10-16 | Vermont | 50 | 1915 | 58 |
12549 | 12549 | 2020-10-16 | Virgin Islands | 78 | 1329 | 21 |
12550 | 12550 | 2020-10-16 | Virginia | 51 | 164124 | 3408 |
12551 | 12551 | 2020-10-16 | Washington | 53 | 101533 | 2338 |
12552 | 12552 | 2020-10-16 | West Virginia | 54 | 19580 | 396 |
12553 | 12553 | 2020-10-16 | Wisconsin | 55 | 175652 | 1588 |
12554 | 12554 | 2020-10-16 | Wyoming | 56 | 8665 | 57 |
12445 | 12445 | 2020-10-15 | Alabama | 1 | 169162 | 2756 |
12446 | 12446 | 2020-10-15 | Alaska | 2 | 11268 | 61 |
12447 | 12447 | 2020-10-15 | Arizona | 4 | 228748 | 5789 |
12448 | 12448 | 2020-10-15 | Arkansas | 5 | 96524 | 1645 |
12449 | 12449 | 2020-10-15 | California | 6 | 870380 | 16839 |
12450 | 12450 | 2020-10-15 | Colorado | 8 | 82443 | 2187 |
12451 | 12451 | 2020-10-15 | Connecticut | 9 | 62028 | 4540 |
12452 | 12452 | 2020-10-15 | Delaware | 10 | 22560 | 661 |
12453 | 12453 | 2020-10-15 | District of Columbia | 11 | 16166 | 638 |
12454 | 12454 | 2020-10-15 | Florida | 12 | 744980 | 15735 |
12455 | 12455 | 2020-10-15 | Georgia | 13 | 344093 | 7320 |
12456 | 12456 | 2020-10-15 | Guam | 66 | 4396 | 62 |
12457 | 12457 | 2020-10-15 | Hawaii | 15 | 13922 | 183 |
12458 | 12458 | 2020-10-15 | Idaho | 16 | 51471 | 521 |
12459 | 12459 | 2020-10-15 | Illinois | 17 | 336211 | 9392 |
12460 | 12460 | 2020-10-15 | Indiana | 18 | 143617 | 3864 |
12461 | 12461 | 2020-10-15 | Iowa | 19 | 104232 | 1516 |
12462 | 12462 | 2020-10-15 | Kansas | 20 | 70815 | 838 |
12463 | 12463 | 2020-10-15 | Kentucky | 21 | 86410 | 1341 |
12464 | 12464 | 2020-10-15 | Louisiana | 22 | 176952 | 5707 |
12465 | 12465 | 2020-10-15 | Maine | 23 | 5836 | 144 |
12466 | 12466 | 2020-10-15 | Maryland | 24 | 134042 | 4028 |
12467 | 12467 | 2020-10-15 | Massachusetts | 25 | 141579 | 9672 |
12468 | 12468 | 2020-10-15 | Michigan | 26 | 156926 | 7304 |
12469 | 12469 | 2020-10-15 | Minnesota | 27 | 117159 | 2252 |
12470 | 12470 | 2020-10-15 | Mississippi | 28 | 108139 | 3152 |
12471 | 12471 | 2020-10-15 | Missouri | 29 | 156142 | 2531 |
12472 | 12472 | 2020-10-15 | Montana | 30 | 21043 | 230 |
12473 | 12473 | 2020-10-15 | Nebraska | 31 | 55428 | 546 |
12474 | 12474 | 2020-10-15 | Nevada | 32 | 88081 | 1700 |
12475 | 12475 | 2020-10-15 | New Hampshire | 33 | 9426 | 463 |
12476 | 12476 | 2020-10-15 | New Jersey | 34 | 218783 | 16197 |
12477 | 12477 | 2020-10-15 | New Mexico | 35 | 34958 | 922 |
12478 | 12478 | 2020-10-15 | New York | 36 | 484135 | 32935 |
12479 | 12479 | 2020-10-15 | North Carolina | 37 | 239338 | 3899 |
12480 | 12480 | 2020-10-15 | North Dakota | 38 | 29658 | 375 |
12481 | 12481 | 2020-10-15 | Northern Mariana Islands | 69 | 80 | 2 |
12482 | 12482 | 2020-10-15 | Ohio | 39 | 175843 | 5038 |
12483 | 12483 | 2020-10-15 | Oklahoma | 40 | 103836 | 1143 |
12484 | 12484 | 2020-10-15 | Oregon | 41 | 38536 | 613 |
12485 | 12485 | 2020-10-15 | Pennsylvania | 42 | 182502 | 8496 |
12486 | 12486 | 2020-10-15 | Puerto Rico | 72 | 56085 | 743 |
12487 | 12487 | 2020-10-15 | Rhode Island | 44 | 27438 | 1149 |
12488 | 12488 | 2020-10-15 | South Carolina | 45 | 161106 | 3607 |
12489 | 12489 | 2020-10-15 | South Dakota | 46 | 31012 | 304 |
12490 | 12490 | 2020-10-15 | Tennessee | 47 | 219355 | 2836 |
12491 | 12491 | 2020-10-15 | Texas | 48 | 853977 | 17362 |
12492 | 12492 | 2020-10-15 | Utah | 49 | 90488 | 531 |
12493 | 12493 | 2020-10-15 | Vermont | 50 | 1903 | 58 |
12494 | 12494 | 2020-10-15 | Virgin Islands | 78 | 1329 | 21 |
12495 | 12495 | 2020-10-15 | Virginia | 51 | 162941 | 3388 |
12496 | 12496 | 2020-10-15 | Washington | 53 | 100838 | 2331 |
12497 | 12497 | 2020-10-15 | West Virginia | 54 | 19082 | 393 |
12498 | 12498 | 2020-10-15 | Wisconsin | 55 | 171480 | 1568 |
12499 | 12499 | 2020-10-15 | Wyoming | 56 | 8375 | 57 |
12390 | 12390 | 2020-10-14 | Alabama | 1 | 167977 | 2706 |
12391 | 12391 | 2020-10-14 | Alaska | 2 | 11103 | 60 |
12392 | 12392 | 2020-10-14 | Arizona | 4 | 227660 | 5772 |
12393 | 12393 | 2020-10-14 | Arkansas | 5 | 95246 | 1634 |
12394 | 12394 | 2020-10-14 | California | 6 | 867094 | 16752 |
12395 | 12395 | 2020-10-14 | Colorado | 8 | 81205 | 2186 |
12396 | 12396 | 2020-10-14 | Connecticut | 9 | 61861 | 4537 |
12397 | 12397 | 2020-10-14 | Delaware | 10 | 22465 | 660 |
12398 | 12398 | 2020-10-14 | District of Columbia | 11 | 16132 | 638 |
12399 | 12399 | 2020-10-14 | Florida | 12 | 741624 | 15594 |
12400 | 12400 | 2020-10-14 | Georgia | 13 | 342302 | 7298 |
12401 | 12401 | 2020-10-14 | Guam | 66 | 4310 | 62 |
12402 | 12402 | 2020-10-14 | Hawaii | 15 | 13834 | 182 |
12403 | 12403 | 2020-10-14 | Idaho | 16 | 50534 | 520 |
12404 | 12404 | 2020-10-14 | Illinois | 17 | 332124 | 9335 |
12405 | 12405 | 2020-10-14 | Indiana | 18 | 141670 | 3836 |
12406 | 12406 | 2020-10-14 | Iowa | 19 | 102905 | 1505 |
12407 | 12407 | 2020-10-14 | Kansas | 20 | 70665 | 838 |
12408 | 12408 | 2020-10-14 | Kentucky | 21 | 85278 | 1325 |
12409 | 12409 | 2020-10-14 | Louisiana | 22 | 176209 | 5695 |
12410 | 12410 | 2020-10-14 | Maine | 23 | 5816 | 143 |
12411 | 12411 | 2020-10-14 | Maryland | 24 | 133413 | 4022 |
12412 | 12412 | 2020-10-14 | Massachusetts | 25 | 140992 | 9647 |
12413 | 12413 | 2020-10-14 | Michigan | 26 | 154409 | 7270 |
12414 | 12414 | 2020-10-14 | Minnesota | 27 | 115996 | 2233 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );