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 date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, 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 |
53579 | 53579 | 2020-04-12 | Stafford | Virginia | 51179 | 72 | 1 |
54637 | 54637 | 2020-04-13 | Stafford | Kansas | 20185 | 1 | 0 |
56269 | 56269 | 2020-04-13 | Stafford | Virginia | 51179 | 87 | 1 |
57331 | 57331 | 2020-04-14 | Stafford | Kansas | 20185 | 1 | 0 |
58975 | 58975 | 2020-04-14 | Stafford | Virginia | 51179 | 95 | 1 |
60040 | 60040 | 2020-04-15 | Stafford | Kansas | 20185 | 1 | 0 |
61694 | 61694 | 2020-04-15 | Stafford | Virginia | 51179 | 108 | 1 |
62761 | 62761 | 2020-04-16 | Stafford | Kansas | 20185 | 1 | 0 |
64427 | 64427 | 2020-04-16 | Stafford | Virginia | 51179 | 120 | 1 |
65498 | 65498 | 2020-04-17 | Stafford | Kansas | 20185 | 1 | 0 |
67175 | 67175 | 2020-04-17 | Stafford | Virginia | 51179 | 128 | 1 |
68247 | 68247 | 2020-04-18 | Stafford | Kansas | 20185 | 1 | 0 |
69937 | 69937 | 2020-04-18 | Stafford | Virginia | 51179 | 143 | 1 |
71009 | 71009 | 2020-04-19 | Stafford | Kansas | 20185 | 1 | 0 |
72707 | 72707 | 2020-04-19 | Stafford | Virginia | 51179 | 152 | 1 |
73781 | 73781 | 2020-04-20 | Stafford | Kansas | 20185 | 1 | 0 |
75483 | 75483 | 2020-04-20 | Stafford | Virginia | 51179 | 161 | 1 |
76561 | 76561 | 2020-04-21 | Stafford | Kansas | 20185 | 1 | 0 |
78267 | 78267 | 2020-04-21 | Stafford | Virginia | 51179 | 164 | 2 |
79346 | 79346 | 2020-04-22 | Stafford | Kansas | 20185 | 1 | 0 |
81060 | 81060 | 2020-04-22 | Stafford | Virginia | 51179 | 170 | 2 |
82142 | 82142 | 2020-04-23 | Stafford | Kansas | 20185 | 1 | 0 |
83861 | 83861 | 2020-04-23 | Stafford | Virginia | 51179 | 180 | 2 |
84945 | 84945 | 2020-04-24 | Stafford | Kansas | 20185 | 1 | 0 |
86668 | 86668 | 2020-04-24 | Stafford | Virginia | 51179 | 193 | 2 |
87754 | 87754 | 2020-04-25 | Stafford | Kansas | 20185 | 1 | 0 |
89483 | 89483 | 2020-04-25 | Stafford | Virginia | 51179 | 198 | 2 |
90570 | 90570 | 2020-04-26 | Stafford | Kansas | 20185 | 1 | 0 |
92300 | 92300 | 2020-04-26 | Stafford | Virginia | 51179 | 213 | 2 |
93391 | 93391 | 2020-04-27 | Stafford | Kansas | 20185 | 1 | 0 |
95129 | 95129 | 2020-04-27 | Stafford | Virginia | 51179 | 218 | 2 |
96224 | 96224 | 2020-04-28 | Stafford | Kansas | 20185 | 1 | 0 |
97973 | 97973 | 2020-04-28 | Stafford | Virginia | 51179 | 221 | 2 |
99070 | 99070 | 2020-04-29 | Stafford | Kansas | 20185 | 1 | 0 |
100823 | 100823 | 2020-04-29 | Stafford | Virginia | 51179 | 225 | 2 |
101922 | 101922 | 2020-04-30 | Stafford | Kansas | 20185 | 1 | 0 |
103678 | 103678 | 2020-04-30 | Stafford | Virginia | 51179 | 240 | 2 |
104783 | 104783 | 2020-05-01 | Stafford | Kansas | 20185 | 1 | 0 |
106542 | 106542 | 2020-05-01 | Stafford | Virginia | 51179 | 251 | 2 |
107648 | 107648 | 2020-05-02 | Stafford | Kansas | 20185 | 1 | 0 |
109411 | 109411 | 2020-05-02 | Stafford | Virginia | 51179 | 262 | 2 |
110519 | 110519 | 2020-05-03 | Stafford | Kansas | 20185 | 1 | 0 |
112285 | 112285 | 2020-05-03 | Stafford | Virginia | 51179 | 271 | 2 |
113396 | 113396 | 2020-05-04 | Stafford | Kansas | 20185 | 1 | 0 |
115168 | 115168 | 2020-05-04 | Stafford | Virginia | 51179 | 288 | 2 |
116278 | 116278 | 2020-05-05 | Stafford | Kansas | 20185 | 1 | 0 |
118127 | 118127 | 2020-05-05 | Stafford | Virginia | 51179 | 308 | 2 |
119239 | 119239 | 2020-05-06 | Stafford | Kansas | 20185 | 1 | 0 |
121091 | 121091 | 2020-05-06 | Stafford | Virginia | 51179 | 308 | 2 |
122209 | 122209 | 2020-05-07 | Stafford | Kansas | 20185 | 1 | 0 |
124072 | 124072 | 2020-05-07 | Stafford | Virginia | 51179 | 334 | 2 |
125191 | 125191 | 2020-05-08 | Stafford | Kansas | 20185 | 1 | 0 |
127057 | 127057 | 2020-05-08 | Stafford | Virginia | 51179 | 344 | 2 |
128179 | 128179 | 2020-05-09 | Stafford | Kansas | 20185 | 1 | 0 |
130047 | 130047 | 2020-05-09 | Stafford | Virginia | 51179 | 354 | 2 |
131169 | 131169 | 2020-05-10 | Stafford | Kansas | 20185 | 1 | 0 |
133037 | 133037 | 2020-05-10 | Stafford | Virginia | 51179 | 374 | 2 |
134160 | 134160 | 2020-05-11 | 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);