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-01-13 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 |
---|---|---|---|---|---|---|
17395 | 17395 | 2021-01-13 | Alabama | 1 | 410995 | 5760 |
17396 | 17396 | 2021-01-13 | Alaska | 2 | 50526 | 217 |
17397 | 17397 | 2021-01-13 | Arizona | 4 | 643683 | 10689 |
17398 | 17398 | 2021-01-13 | Arkansas | 5 | 262020 | 4186 |
17399 | 17399 | 2021-01-13 | California | 6 | 2858041 | 31653 |
17400 | 17400 | 2021-01-13 | Colorado | 8 | 368775 | 5354 |
17401 | 17401 | 2021-01-13 | Connecticut | 9 | 220576 | 6536 |
17402 | 17402 | 2021-01-13 | Delaware | 10 | 67173 | 994 |
17403 | 17403 | 2021-01-13 | District of Columbia | 11 | 32600 | 831 |
17404 | 17404 | 2021-01-13 | Florida | 12 | 1517464 | 23395 |
17405 | 17405 | 2021-01-13 | Georgia | 13 | 757993 | 11435 |
17406 | 17406 | 2021-01-13 | Guam | 66 | 8413 | 125 |
17407 | 17407 | 2021-01-13 | Hawaii | 15 | 23663 | 309 |
17408 | 17408 | 2021-01-13 | Idaho | 16 | 152560 | 1576 |
17409 | 17409 | 2021-01-13 | Illinois | 17 | 1048784 | 19619 |
17410 | 17410 | 2021-01-13 | Indiana | 18 | 577153 | 9163 |
17411 | 17411 | 2021-01-13 | Iowa | 19 | 301161 | 4232 |
17412 | 17412 | 2021-01-13 | Kansas | 20 | 255200 | 3355 |
17413 | 17413 | 2021-01-13 | Kentucky | 21 | 316673 | 3324 |
17414 | 17414 | 2021-01-13 | Louisiana | 22 | 355835 | 8022 |
17415 | 17415 | 2021-01-13 | Maine | 23 | 31150 | 453 |
17416 | 17416 | 2021-01-13 | Maryland | 24 | 315055 | 6404 |
17417 | 17417 | 2021-01-13 | Massachusetts | 25 | 448447 | 13359 |
17418 | 17418 | 2021-01-13 | Michigan | 26 | 571014 | 14325 |
17419 | 17419 | 2021-01-13 | Minnesota | 27 | 440422 | 5842 |
17420 | 17420 | 2021-01-13 | Mississippi | 28 | 243899 | 5315 |
17421 | 17421 | 2021-01-13 | Missouri | 29 | 464620 | 6538 |
17422 | 17422 | 2021-01-13 | Montana | 30 | 87759 | 1069 |
17423 | 17423 | 2021-01-13 | Nebraska | 31 | 180160 | 1870 |
17424 | 17424 | 2021-01-13 | Nevada | 32 | 254043 | 3596 |
17425 | 17425 | 2021-01-13 | New Hampshire | 33 | 54125 | 885 |
17426 | 17426 | 2021-01-13 | New Jersey | 34 | 602629 | 20166 |
17427 | 17427 | 2021-01-13 | New Mexico | 35 | 159119 | 2809 |
17428 | 17428 | 2021-01-13 | New York | 36 | 1179523 | 39760 |
17429 | 17429 | 2021-01-13 | North Carolina | 37 | 642003 | 7796 |
17430 | 17430 | 2021-01-13 | North Dakota | 38 | 95142 | 1364 |
17431 | 17431 | 2021-01-13 | Northern Mariana Islands | 69 | 128 | 2 |
17432 | 17432 | 2021-01-13 | Ohio | 39 | 799639 | 9881 |
17433 | 17433 | 2021-01-13 | Oklahoma | 40 | 341364 | 2848 |
17434 | 17434 | 2021-01-13 | Oregon | 41 | 129109 | 1716 |
17435 | 17435 | 2021-01-13 | Pennsylvania | 42 | 747245 | 18458 |
17436 | 17436 | 2021-01-13 | Puerto Rico | 72 | 118254 | 1659 |
17437 | 17437 | 2021-01-13 | Rhode Island | 44 | 102485 | 1987 |
17438 | 17438 | 2021-01-13 | South Carolina | 45 | 365378 | 5911 |
17439 | 17439 | 2021-01-13 | South Dakota | 46 | 104195 | 1604 |
17440 | 17440 | 2021-01-13 | Tennessee | 47 | 653568 | 8072 |
17441 | 17441 | 2021-01-13 | Texas | 48 | 2040144 | 31396 |
17442 | 17442 | 2021-01-13 | Utah | 49 | 314817 | 1449 |
17443 | 17443 | 2021-01-13 | Vermont | 50 | 9368 | 158 |
17444 | 17444 | 2021-01-13 | Virgin Islands | 78 | 2166 | 24 |
17445 | 17445 | 2021-01-13 | Virginia | 51 | 412545 | 5552 |
17446 | 17446 | 2021-01-13 | Washington | 53 | 285690 | 3909 |
17447 | 17447 | 2021-01-13 | West Virginia | 54 | 104392 | 1671 |
17448 | 17448 | 2021-01-13 | Wisconsin | 55 | 558020 | 5679 |
17449 | 17449 | 2021-01-13 | Wyoming | 56 | 48289 | 522 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );