ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57,238 rows sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 56
- Washington 1,074
- Illinois 1,071
- California 1,070
- Arizona 1,069
- Massachusetts 1,063
- Wisconsin 1,059
- Texas 1,052
- Nebraska 1,047
- Utah 1,039
- Oregon 1,036
- Florida 1,034
- New York 1,034
- Rhode Island 1,034
- Georgia 1,033
- New Hampshire 1,033
- North Carolina 1,032
- New Jersey 1,031
- Colorado 1,030
- Maryland 1,030
- Nevada 1,030
- Tennessee 1,030
- Hawaii 1,029
- Indiana 1,029
- Kentucky 1,029
- Minnesota 1,029
- Oklahoma 1,029
- Pennsylvania 1,029
- South Carolina 1,029
- District of Columbia 1,028
- Kansas 1,028
- Missouri 1,028
- Vermont 1,028
- Virginia 1,028
- Connecticut 1,027
- Iowa 1,027
- Louisiana 1,026
- Ohio 1,026
- Michigan 1,025
- South Dakota 1,025
- Arkansas 1,024
- Delaware 1,024
- Mississippi 1,024
- New Mexico 1,024
- North Dakota 1,024
- Wyoming 1,024
- Alaska 1,023
- Maine 1,023
- Alabama 1,022
- Idaho 1,022
- Montana 1,022
- Puerto Rico 1,022
- Virgin Islands 1,021
- Guam 1,020
- West Virginia 1,018
- Northern Mariana Islands 1,007
- American Samoa 464
Link | rowid | date | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|
1 | 1 | 2020-01-21 | Washington | 53 | 1 | 0 |
2 | 2 | 2020-01-22 | Washington | 53 | 1 | 0 |
3 | 3 | 2020-01-23 | Washington | 53 | 1 | 0 |
4 | 4 | 2020-01-24 | Illinois | 17 | 1 | 0 |
5 | 5 | 2020-01-24 | Washington | 53 | 1 | 0 |
6 | 6 | 2020-01-25 | California | 6 | 1 | 0 |
7 | 7 | 2020-01-25 | Illinois | 17 | 1 | 0 |
8 | 8 | 2020-01-25 | Washington | 53 | 1 | 0 |
9 | 9 | 2020-01-26 | Arizona | 4 | 1 | 0 |
11 | 11 | 2020-01-26 | Illinois | 17 | 1 | 0 |
12 | 12 | 2020-01-26 | Washington | 53 | 1 | 0 |
13 | 13 | 2020-01-27 | Arizona | 4 | 1 | 0 |
15 | 15 | 2020-01-27 | Illinois | 17 | 1 | 0 |
16 | 16 | 2020-01-27 | Washington | 53 | 1 | 0 |
17 | 17 | 2020-01-28 | Arizona | 4 | 1 | 0 |
19 | 19 | 2020-01-28 | Illinois | 17 | 1 | 0 |
20 | 20 | 2020-01-28 | Washington | 53 | 1 | 0 |
21 | 21 | 2020-01-29 | Arizona | 4 | 1 | 0 |
23 | 23 | 2020-01-29 | Illinois | 17 | 1 | 0 |
24 | 24 | 2020-01-29 | Washington | 53 | 1 | 0 |
25 | 25 | 2020-01-30 | Arizona | 4 | 1 | 0 |
28 | 28 | 2020-01-30 | Washington | 53 | 1 | 0 |
29 | 29 | 2020-01-31 | Arizona | 4 | 1 | 0 |
32 | 32 | 2020-01-31 | Washington | 53 | 1 | 0 |
33 | 33 | 2020-02-01 | Arizona | 4 | 1 | 0 |
36 | 36 | 2020-02-01 | Massachusetts | 25 | 1 | 0 |
37 | 37 | 2020-02-01 | Washington | 53 | 1 | 0 |
38 | 38 | 2020-02-02 | Arizona | 4 | 1 | 0 |
41 | 41 | 2020-02-02 | Massachusetts | 25 | 1 | 0 |
42 | 42 | 2020-02-02 | Washington | 53 | 1 | 0 |
43 | 43 | 2020-02-03 | Arizona | 4 | 1 | 0 |
46 | 46 | 2020-02-03 | Massachusetts | 25 | 1 | 0 |
47 | 47 | 2020-02-03 | Washington | 53 | 1 | 0 |
48 | 48 | 2020-02-04 | Arizona | 4 | 1 | 0 |
51 | 51 | 2020-02-04 | Massachusetts | 25 | 1 | 0 |
52 | 52 | 2020-02-04 | Washington | 53 | 1 | 0 |
53 | 53 | 2020-02-05 | Arizona | 4 | 1 | 0 |
56 | 56 | 2020-02-05 | Massachusetts | 25 | 1 | 0 |
57 | 57 | 2020-02-05 | Washington | 53 | 1 | 0 |
58 | 58 | 2020-02-05 | Wisconsin | 55 | 1 | 0 |
59 | 59 | 2020-02-06 | Arizona | 4 | 1 | 0 |
62 | 62 | 2020-02-06 | Massachusetts | 25 | 1 | 0 |
63 | 63 | 2020-02-06 | Washington | 53 | 1 | 0 |
64 | 64 | 2020-02-06 | Wisconsin | 55 | 1 | 0 |
65 | 65 | 2020-02-07 | Arizona | 4 | 1 | 0 |
68 | 68 | 2020-02-07 | Massachusetts | 25 | 1 | 0 |
69 | 69 | 2020-02-07 | Washington | 53 | 1 | 0 |
70 | 70 | 2020-02-07 | Wisconsin | 55 | 1 | 0 |
71 | 71 | 2020-02-08 | Arizona | 4 | 1 | 0 |
74 | 74 | 2020-02-08 | Massachusetts | 25 | 1 | 0 |
75 | 75 | 2020-02-08 | Washington | 53 | 1 | 0 |
76 | 76 | 2020-02-08 | Wisconsin | 55 | 1 | 0 |
77 | 77 | 2020-02-09 | Arizona | 4 | 1 | 0 |
80 | 80 | 2020-02-09 | Massachusetts | 25 | 1 | 0 |
81 | 81 | 2020-02-09 | Washington | 53 | 1 | 0 |
82 | 82 | 2020-02-09 | Wisconsin | 55 | 1 | 0 |
83 | 83 | 2020-02-10 | Arizona | 4 | 1 | 0 |
86 | 86 | 2020-02-10 | Massachusetts | 25 | 1 | 0 |
87 | 87 | 2020-02-10 | Washington | 53 | 1 | 0 |
88 | 88 | 2020-02-10 | Wisconsin | 55 | 1 | 0 |
89 | 89 | 2020-02-11 | Arizona | 4 | 1 | 0 |
92 | 92 | 2020-02-11 | Massachusetts | 25 | 1 | 0 |
93 | 93 | 2020-02-11 | Washington | 53 | 1 | 0 |
94 | 94 | 2020-02-11 | Wisconsin | 55 | 1 | 0 |
95 | 95 | 2020-02-12 | Arizona | 4 | 1 | 0 |
98 | 98 | 2020-02-12 | Massachusetts | 25 | 1 | 0 |
99 | 99 | 2020-02-12 | Texas | 48 | 1 | 0 |
100 | 100 | 2020-02-12 | Washington | 53 | 1 | 0 |
101 | 101 | 2020-02-12 | Wisconsin | 55 | 1 | 0 |
102 | 102 | 2020-02-13 | Arizona | 4 | 1 | 0 |
105 | 105 | 2020-02-13 | Massachusetts | 25 | 1 | 0 |
107 | 107 | 2020-02-13 | Washington | 53 | 1 | 0 |
108 | 108 | 2020-02-13 | Wisconsin | 55 | 1 | 0 |
109 | 109 | 2020-02-14 | Arizona | 4 | 1 | 0 |
112 | 112 | 2020-02-14 | Massachusetts | 25 | 1 | 0 |
114 | 114 | 2020-02-14 | Washington | 53 | 1 | 0 |
115 | 115 | 2020-02-14 | Wisconsin | 55 | 1 | 0 |
116 | 116 | 2020-02-15 | Arizona | 4 | 1 | 0 |
119 | 119 | 2020-02-15 | Massachusetts | 25 | 1 | 0 |
121 | 121 | 2020-02-15 | Washington | 53 | 1 | 0 |
122 | 122 | 2020-02-15 | Wisconsin | 55 | 1 | 0 |
123 | 123 | 2020-02-16 | Arizona | 4 | 1 | 0 |
126 | 126 | 2020-02-16 | Massachusetts | 25 | 1 | 0 |
128 | 128 | 2020-02-16 | Washington | 53 | 1 | 0 |
129 | 129 | 2020-02-16 | Wisconsin | 55 | 1 | 0 |
130 | 130 | 2020-02-17 | Arizona | 4 | 1 | 0 |
133 | 133 | 2020-02-17 | Massachusetts | 25 | 1 | 0 |
136 | 136 | 2020-02-17 | Washington | 53 | 1 | 0 |
137 | 137 | 2020-02-17 | Wisconsin | 55 | 1 | 0 |
138 | 138 | 2020-02-18 | Arizona | 4 | 1 | 0 |
141 | 141 | 2020-02-18 | Massachusetts | 25 | 1 | 0 |
144 | 144 | 2020-02-18 | Washington | 53 | 1 | 0 |
145 | 145 | 2020-02-18 | Wisconsin | 55 | 1 | 0 |
146 | 146 | 2020-02-19 | Arizona | 4 | 1 | 0 |
149 | 149 | 2020-02-19 | Massachusetts | 25 | 1 | 0 |
152 | 152 | 2020-02-19 | Washington | 53 | 1 | 0 |
153 | 153 | 2020-02-19 | Wisconsin | 55 | 1 | 0 |
154 | 154 | 2020-02-20 | Arizona | 4 | 1 | 0 |
157 | 157 | 2020-02-20 | Massachusetts | 25 | 1 | 0 |
160 | 160 | 2020-02-20 | Washington | 53 | 1 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );