ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,565 rows where county = "Stafford" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
3179 | 3179 | 2020-03-16 | Stafford | Virginia | 51179 | 1 | 0 |
3718 | 3718 | 2020-03-17 | Stafford | Virginia | 51179 | 1 | 0 |
4352 | 4352 | 2020-03-18 | Stafford | Virginia | 51179 | 2 | 0 |
5108 | 5108 | 2020-03-19 | Stafford | Virginia | 51179 | 2 | 0 |
6009 | 6009 | 2020-03-20 | Stafford | Virginia | 51179 | 2 | 0 |
7039 | 7039 | 2020-03-21 | Stafford | Virginia | 51179 | 2 | 0 |
8176 | 8176 | 2020-03-22 | Stafford | Virginia | 51179 | 5 | 0 |
9399 | 9399 | 2020-03-23 | Stafford | Virginia | 51179 | 6 | 0 |
10747 | 10747 | 2020-03-24 | Stafford | Virginia | 51179 | 6 | 0 |
12269 | 12269 | 2020-03-25 | Stafford | Virginia | 51179 | 6 | 0 |
13917 | 13917 | 2020-03-26 | Stafford | Virginia | 51179 | 11 | 0 |
15686 | 15686 | 2020-03-27 | Stafford | Virginia | 51179 | 11 | 0 |
17566 | 17566 | 2020-03-28 | Stafford | Virginia | 51179 | 11 | 0 |
18322 | 18322 | 2020-03-29 | Stafford | Kansas | 20185 | 1 | 0 |
19528 | 19528 | 2020-03-29 | Stafford | Virginia | 51179 | 13 | 0 |
20336 | 20336 | 2020-03-30 | Stafford | Kansas | 20185 | 1 | 0 |
21595 | 21595 | 2020-03-30 | Stafford | Virginia | 51179 | 20 | 0 |
22435 | 22435 | 2020-03-31 | Stafford | Kansas | 20185 | 1 | 0 |
23742 | 23742 | 2020-03-31 | Stafford | Virginia | 51179 | 24 | 0 |
24611 | 24611 | 2020-04-01 | Stafford | Kansas | 20185 | 1 | 0 |
25958 | 25958 | 2020-04-01 | Stafford | Virginia | 51179 | 28 | 0 |
26855 | 26855 | 2020-04-02 | Stafford | Kansas | 20185 | 1 | 0 |
28249 | 28249 | 2020-04-02 | Stafford | Virginia | 51179 | 28 | 0 |
29171 | 29171 | 2020-04-03 | Stafford | Kansas | 20185 | 1 | 0 |
30598 | 30598 | 2020-04-03 | Stafford | Virginia | 51179 | 29 | 0 |
31545 | 31545 | 2020-04-04 | Stafford | Kansas | 20185 | 1 | 0 |
32997 | 32997 | 2020-04-04 | Stafford | Virginia | 51179 | 38 | 0 |
33960 | 33960 | 2020-04-05 | Stafford | Kansas | 20185 | 1 | 0 |
35435 | 35435 | 2020-04-05 | Stafford | Virginia | 51179 | 41 | 0 |
36418 | 36418 | 2020-04-06 | Stafford | Kansas | 20185 | 1 | 0 |
37919 | 37919 | 2020-04-06 | Stafford | Virginia | 51179 | 43 | 0 |
38923 | 38923 | 2020-04-07 | Stafford | Kansas | 20185 | 1 | 0 |
40454 | 40454 | 2020-04-07 | Stafford | Virginia | 51179 | 49 | 0 |
41470 | 41470 | 2020-04-08 | Stafford | Kansas | 20185 | 1 | 0 |
43023 | 43023 | 2020-04-08 | Stafford | Virginia | 51179 | 48 | 0 |
44046 | 44046 | 2020-04-09 | Stafford | Kansas | 20185 | 1 | 0 |
45619 | 45619 | 2020-04-09 | Stafford | Virginia | 51179 | 54 | 0 |
46653 | 46653 | 2020-04-10 | Stafford | Kansas | 20185 | 1 | 0 |
48246 | 48246 | 2020-04-10 | Stafford | Virginia | 51179 | 60 | 0 |
49290 | 49290 | 2020-04-11 | Stafford | Kansas | 20185 | 1 | 0 |
50904 | 50904 | 2020-04-11 | Stafford | Virginia | 51179 | 67 | 0 |
51955 | 51955 | 2020-04-12 | Stafford | Kansas | 20185 | 1 | 0 |
54637 | 54637 | 2020-04-13 | Stafford | Kansas | 20185 | 1 | 0 |
57331 | 57331 | 2020-04-14 | Stafford | Kansas | 20185 | 1 | 0 |
60040 | 60040 | 2020-04-15 | Stafford | Kansas | 20185 | 1 | 0 |
62761 | 62761 | 2020-04-16 | Stafford | Kansas | 20185 | 1 | 0 |
65498 | 65498 | 2020-04-17 | Stafford | Kansas | 20185 | 1 | 0 |
68247 | 68247 | 2020-04-18 | Stafford | Kansas | 20185 | 1 | 0 |
71009 | 71009 | 2020-04-19 | Stafford | Kansas | 20185 | 1 | 0 |
73781 | 73781 | 2020-04-20 | Stafford | Kansas | 20185 | 1 | 0 |
76561 | 76561 | 2020-04-21 | Stafford | Kansas | 20185 | 1 | 0 |
79346 | 79346 | 2020-04-22 | Stafford | Kansas | 20185 | 1 | 0 |
82142 | 82142 | 2020-04-23 | Stafford | Kansas | 20185 | 1 | 0 |
84945 | 84945 | 2020-04-24 | Stafford | Kansas | 20185 | 1 | 0 |
87754 | 87754 | 2020-04-25 | Stafford | Kansas | 20185 | 1 | 0 |
90570 | 90570 | 2020-04-26 | Stafford | Kansas | 20185 | 1 | 0 |
93391 | 93391 | 2020-04-27 | Stafford | Kansas | 20185 | 1 | 0 |
96224 | 96224 | 2020-04-28 | Stafford | Kansas | 20185 | 1 | 0 |
99070 | 99070 | 2020-04-29 | Stafford | Kansas | 20185 | 1 | 0 |
101922 | 101922 | 2020-04-30 | Stafford | Kansas | 20185 | 1 | 0 |
104783 | 104783 | 2020-05-01 | Stafford | Kansas | 20185 | 1 | 0 |
107648 | 107648 | 2020-05-02 | Stafford | Kansas | 20185 | 1 | 0 |
110519 | 110519 | 2020-05-03 | Stafford | Kansas | 20185 | 1 | 0 |
113396 | 113396 | 2020-05-04 | Stafford | Kansas | 20185 | 1 | 0 |
116278 | 116278 | 2020-05-05 | Stafford | Kansas | 20185 | 1 | 0 |
119239 | 119239 | 2020-05-06 | Stafford | Kansas | 20185 | 1 | 0 |
122209 | 122209 | 2020-05-07 | Stafford | Kansas | 20185 | 1 | 0 |
125191 | 125191 | 2020-05-08 | Stafford | Kansas | 20185 | 1 | 0 |
128179 | 128179 | 2020-05-09 | Stafford | Kansas | 20185 | 1 | 0 |
131169 | 131169 | 2020-05-10 | Stafford | Kansas | 20185 | 1 | 0 |
134160 | 134160 | 2020-05-11 | Stafford | Kansas | 20185 | 1 | 0 |
137150 | 137150 | 2020-05-12 | Stafford | Kansas | 20185 | 1 | 0 |
140143 | 140143 | 2020-05-13 | Stafford | Kansas | 20185 | 1 | 0 |
143139 | 143139 | 2020-05-14 | Stafford | Kansas | 20185 | 1 | 0 |
146139 | 146139 | 2020-05-15 | Stafford | Kansas | 20185 | 1 | 0 |
149143 | 149143 | 2020-05-16 | Stafford | Kansas | 20185 | 1 | 0 |
152154 | 152154 | 2020-05-17 | Stafford | Kansas | 20185 | 1 | 0 |
155167 | 155167 | 2020-05-18 | Stafford | Kansas | 20185 | 1 | 0 |
158184 | 158184 | 2020-05-19 | Stafford | Kansas | 20185 | 1 | 0 |
161209 | 161209 | 2020-05-20 | Stafford | Kansas | 20185 | 1 | 0 |
164238 | 164238 | 2020-05-21 | Stafford | Kansas | 20185 | 1 | 0 |
167273 | 167273 | 2020-05-22 | Stafford | Kansas | 20185 | 1 | 0 |
170311 | 170311 | 2020-05-23 | Stafford | Kansas | 20185 | 1 | 0 |
173352 | 173352 | 2020-05-24 | Stafford | Kansas | 20185 | 1 | 0 |
176396 | 176396 | 2020-05-25 | Stafford | Kansas | 20185 | 1 | 0 |
179440 | 179440 | 2020-05-26 | Stafford | Kansas | 20185 | 1 | 0 |
182485 | 182485 | 2020-05-27 | Stafford | Kansas | 20185 | 1 | 0 |
185539 | 185539 | 2020-05-28 | Stafford | Kansas | 20185 | 1 | 0 |
188597 | 188597 | 2020-05-29 | Stafford | Kansas | 20185 | 1 | 0 |
191661 | 191661 | 2020-05-30 | Stafford | Kansas | 20185 | 1 | 0 |
194729 | 194729 | 2020-05-31 | Stafford | Kansas | 20185 | 1 | 0 |
197799 | 197799 | 2020-06-01 | Stafford | Kansas | 20185 | 1 | 0 |
200871 | 200871 | 2020-06-02 | Stafford | Kansas | 20185 | 1 | 0 |
203948 | 203948 | 2020-06-03 | Stafford | Kansas | 20185 | 1 | 0 |
207029 | 207029 | 2020-06-04 | Stafford | Kansas | 20185 | 1 | 0 |
210110 | 210110 | 2020-06-05 | Stafford | Kansas | 20185 | 1 | 0 |
213195 | 213195 | 2020-06-06 | Stafford | Kansas | 20185 | 1 | 0 |
216282 | 216282 | 2020-06-07 | Stafford | Kansas | 20185 | 1 | 0 |
219374 | 219374 | 2020-06-08 | Stafford | Kansas | 20185 | 1 | 0 |
222469 | 222469 | 2020-06-09 | Stafford | Kansas | 20185 | 1 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);