us-states

Table actions
Big Local News snapshots this data daily from https://github.com/nytimes/covid-19-data. This is time series data for U.S. confirmed cases and deaths down to the county level. There are three CSV files released once a day: national-level data, state-level data and county-level data. Each file contains date, county/state name, FIPS code, number of confirmed cases, number of deaths going back to January 21. All data is gathered by New York Times reporters from state and local health departments or official government announcements. The data is updated once a day in the morning, usually around 8 a.m. EDT, with a full day’s worth of data from the day before. Please cite the New York Times as described in the README and check terms of use.

Data source: Big Local News · About: big-local-datasette

55 rows where "date" is on date 2020-04-17

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: date (date)

Link rowid ▼ date state fips cases deaths
2490 2490 2020-04-17 Alabama 1 4572 151
2491 2491 2020-04-17 Alaska 2 307 7
2492 2492 2020-04-17 Arizona 4 4507 174
2493 2493 2020-04-17 Arkansas 5 1695 37
2494 2494 2020-04-17 California 6 29398 1050
2495 2495 2020-04-17 Colorado 8 9047 389
2496 2496 2020-04-17 Connecticut 9 16809 1036
2497 2497 2020-04-17 Delaware 10 2323 61
2498 2498 2020-04-17 District of Columbia 11 2476 86
2499 2499 2020-04-17 Florida 12 24745 725
2500 2500 2020-04-17 Georgia 13 16658 661
2501 2501 2020-04-17 Guam 66 796 6
2502 2502 2020-04-17 Hawaii 15 547 9
2503 2503 2020-04-17 Idaho 16 1655 43
2504 2504 2020-04-17 Illinois 17 27575 1142
2505 2505 2020-04-17 Indiana 18 10235 599
2506 2506 2020-04-17 Iowa 19 2332 64
2507 2507 2020-04-17 Kansas 20 1732 84
2508 2508 2020-04-17 Kentucky 21 2522 140
2509 2509 2020-04-17 Louisiana 22 23118 1213
2510 2510 2020-04-17 Maine 23 827 29
2511 2511 2020-04-17 Maryland 24 11641 494
2512 2512 2020-04-17 Massachusetts 25 34402 1404
2513 2513 2020-04-17 Michigan 26 29954 2227
2514 2514 2020-04-17 Minnesota 27 2071 111
2515 2515 2020-04-17 Mississippi 28 3793 140
2516 2516 2020-04-17 Missouri 29 5283 184
2517 2517 2020-04-17 Montana 30 422 8
2518 2518 2020-04-17 Nebraska 31 1216 24
2519 2519 2020-04-17 Nevada 32 3524 151
2520 2520 2020-04-17 New Hampshire 33 1287 37
2521 2521 2020-04-17 New Jersey 34 78467 3840
2522 2522 2020-04-17 New Mexico 35 1711 51
2523 2523 2020-04-17 New York 36 233293 16473
2524 2524 2020-04-17 North Carolina 37 5859 159
2525 2525 2020-04-17 North Dakota 38 439 9
2526 2526 2020-04-17 Northern Mariana Islands 69 14 2
2527 2527 2020-04-17 Ohio 39 9107 418
2528 2528 2020-04-17 Oklahoma 40 2465 136
2529 2529 2020-04-17 Oregon 41 1785 70
2530 2530 2020-04-17 Pennsylvania 42 30121 1027
2531 2531 2020-04-17 Puerto Rico 72 1068 58
2532 2532 2020-04-17 Rhode Island 44 4177 118
2533 2533 2020-04-17 South Carolina 45 4086 116
2534 2534 2020-04-17 South Dakota 46 1411 7
2535 2535 2020-04-17 Tennessee 47 6423 146
2536 2536 2020-04-17 Texas 48 18131 461
2537 2537 2020-04-17 Utah 49 2813 23
2538 2538 2020-04-17 Vermont 50 779 34
2539 2539 2020-04-17 Virgin Islands 78 53 3
2540 2540 2020-04-17 Virginia 51 7492 238
2541 2541 2020-04-17 Washington 53 11479 610
2542 2542 2020-04-17 West Virginia 54 776 16
2543 2543 2020-04-17 Wisconsin 55 4045 205
2544 2544 2020-04-17 Wyoming 56 401 2

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [us-states] (
   [date] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);