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

19,979 rows sorted by cases descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: date (date)

Link rowid date state fips cases ▲ deaths
19929 19929 2021-02-28 California 6 3568991 52213
19874 19874 2021-02-27 California 6 3565496 51979
19819 19819 2021-02-26 California 6 3561086 51794
19764 19764 2021-02-25 California 6 3554195 51385
19709 19709 2021-02-24 California 6 3548559 50953
19654 19654 2021-02-23 California 6 3542706 49869
19599 19599 2021-02-22 California 6 3536446 49531
19544 19544 2021-02-21 California 6 3531474 49340
19489 19489 2021-02-20 California 6 3526828 49111
19434 19434 2021-02-19 California 6 3520761 48794
19379 19379 2021-02-18 California 6 3512881 48334
19324 19324 2021-02-17 California 6 3505032 47902
19269 19269 2021-02-16 California 6 3498760 47446
19214 19214 2021-02-15 California 6 3489996 47115
19159 19159 2021-02-14 California 6 3484984 47055
19104 19104 2021-02-13 California 6 3479029 46865
19049 19049 2021-02-12 California 6 3469853 46435
18994 18994 2021-02-11 California 6 3460320 45976
18939 18939 2021-02-10 California 6 3449774 45436
18884 18884 2021-02-09 California 6 3441177 44973
18829 18829 2021-02-08 California 6 3430685 44440
18774 18774 2021-02-07 California 6 3417099 44152
18719 18719 2021-02-06 California 6 3406890 43987
18664 18664 2021-02-05 California 6 3395295 43631
18609 18609 2021-02-04 California 6 3381278 43062
18554 18554 2021-02-03 California 6 3366597 42434
18499 18499 2021-02-02 California 6 3354039 41858
18444 18444 2021-02-01 California 6 3341197 41284
18389 18389 2021-01-31 California 6 3323613 40928
18334 18334 2021-01-30 California 6 3309630 40694
18279 18279 2021-01-29 California 6 3292084 40192
18224 18224 2021-01-28 California 6 3272349 39527
18169 18169 2021-01-27 California 6 3252716 38927
18114 18114 2021-01-26 California 6 3234088 38221
18059 18059 2021-01-25 California 6 3212488 37499
18004 18004 2021-01-24 California 6 3185612 37118
17949 17949 2021-01-23 California 6 3163932 36818
17894 17894 2021-01-22 California 6 3140928 36326
17839 17839 2021-01-21 California 6 3115911 35704
17784 17784 2021-01-20 California 6 3090339 35001
17729 17729 2021-01-19 California 6 3071119 34390
17674 17674 2021-01-18 California 6 3032007 33742
17619 17619 2021-01-17 California 6 3006583 33593
17564 17564 2021-01-16 California 6 2974966 33393
17509 17509 2021-01-15 California 6 2937376 32947
17454 17454 2021-01-14 California 6 2898271 32246
17399 17399 2021-01-13 California 6 2857587 31653
17344 17344 2021-01-12 California 6 2815933 31105
17289 17289 2021-01-11 California 6 2770065 30381
17234 17234 2021-01-10 California 6 2729525 30000
17179 17179 2021-01-09 California 6 2687085 29699
19971 19971 2021-02-28 Texas 48 2653285 43949
19916 19916 2021-02-27 Texas 48 2649664 43772
19861 19861 2021-02-26 Texas 48 2644221 43633
17124 17124 2021-01-08 California 6 2639814 29226
19806 19806 2021-02-25 Texas 48 2633310 43350
19751 19751 2021-02-24 Texas 48 2625490 43053
19696 19696 2021-02-23 Texas 48 2617850 42728
19641 19641 2021-02-22 Texas 48 2607576 42484
19586 19586 2021-02-21 Texas 48 2600230 42321
19531 19531 2021-02-20 Texas 48 2593823 42202
17069 17069 2021-01-07 California 6 2588891 28552
19476 19476 2021-02-19 Texas 48 2588291 42000
19421 19421 2021-02-18 Texas 48 2582346 41764
19366 19366 2021-02-17 Texas 48 2579959 41650
19311 19311 2021-02-16 Texas 48 2575430 41546
19256 19256 2021-02-15 Texas 48 2571789 41484
19201 19201 2021-02-14 Texas 48 2568858 41440
19146 19146 2021-02-13 Texas 48 2564337 41320
19091 19091 2021-02-12 Texas 48 2556292 41063
17014 17014 2021-01-06 California 6 2548494 28040
19036 19036 2021-02-11 Texas 48 2543997 40661
18981 18981 2021-02-10 Texas 48 2532070 40297
18926 18926 2021-02-09 Texas 48 2518970 39973
16959 16959 2021-01-05 California 6 2511822 27486
18871 18871 2021-02-08 Texas 48 2505725 39655
18816 18816 2021-02-07 Texas 48 2494795 39490
18761 18761 2021-02-06 Texas 48 2487260 39330
18706 18706 2021-02-05 Texas 48 2478744 39039
16904 16904 2021-01-04 California 6 2474561 26995
18651 18651 2021-02-04 Texas 48 2464307 38610
18596 18596 2021-02-03 Texas 48 2450705 38203
16849 16849 2021-01-03 California 6 2433838 26635
18541 18541 2021-02-02 Texas 48 2432691 37760
18486 18486 2021-02-01 Texas 48 2414468 37405
16794 16794 2021-01-02 California 6 2397923 26542
18431 18431 2021-01-31 Texas 48 2375218 37242
18376 18376 2021-01-30 Texas 48 2362817 37096
18321 18321 2021-01-29 Texas 48 2349047 36804
16739 16739 2021-01-01 California 6 2345726 26236
18266 18266 2021-01-28 Texas 48 2330107 36434
18211 18211 2021-01-27 Texas 48 2310785 36024
16684 16684 2020-12-31 California 6 2307769 25965
18156 18156 2021-01-26 Texas 48 2291007 35544
16629 16629 2020-12-30 California 6 2275505 25391
18101 18101 2021-01-25 Texas 48 2270391 35236
18046 18046 2021-01-24 Texas 48 2249959 35050
16574 16574 2020-12-29 California 6 2243119 24954
17991 17991 2021-01-23 Texas 48 2242145 34859
17936 17936 2021-01-22 Texas 48 2228301 34496

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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