ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,347 rows where county = "Sussex" sorted by fips descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
state 3
- Delaware 788
- New Jersey 786
- Virginia 773
county 1
- Sussex · 2,347 ✖
Link | rowid | date | county | state | fips ▲ | cases | deaths |
---|---|---|---|---|---|---|---|
25961 | 25961 | 2020-04-01 | Sussex | Virginia | 51183 | 1 | 0 |
28252 | 28252 | 2020-04-02 | Sussex | Virginia | 51183 | 1 | 0 |
30601 | 30601 | 2020-04-03 | Sussex | Virginia | 51183 | 2 | 0 |
33001 | 33001 | 2020-04-04 | Sussex | Virginia | 51183 | 3 | 0 |
35439 | 35439 | 2020-04-05 | Sussex | Virginia | 51183 | 4 | 0 |
37923 | 37923 | 2020-04-06 | Sussex | Virginia | 51183 | 4 | 0 |
40458 | 40458 | 2020-04-07 | Sussex | Virginia | 51183 | 5 | 0 |
43027 | 43027 | 2020-04-08 | Sussex | Virginia | 51183 | 6 | 0 |
45623 | 45623 | 2020-04-09 | Sussex | Virginia | 51183 | 6 | 0 |
48250 | 48250 | 2020-04-10 | Sussex | Virginia | 51183 | 8 | 0 |
50908 | 50908 | 2020-04-11 | Sussex | Virginia | 51183 | 8 | 0 |
53583 | 53583 | 2020-04-12 | Sussex | Virginia | 51183 | 8 | 0 |
56273 | 56273 | 2020-04-13 | Sussex | Virginia | 51183 | 8 | 0 |
58979 | 58979 | 2020-04-14 | Sussex | Virginia | 51183 | 8 | 0 |
61698 | 61698 | 2020-04-15 | Sussex | Virginia | 51183 | 10 | 0 |
64431 | 64431 | 2020-04-16 | Sussex | Virginia | 51183 | 9 | 0 |
67179 | 67179 | 2020-04-17 | Sussex | Virginia | 51183 | 11 | 0 |
69941 | 69941 | 2020-04-18 | Sussex | Virginia | 51183 | 11 | 0 |
72711 | 72711 | 2020-04-19 | Sussex | Virginia | 51183 | 11 | 0 |
75487 | 75487 | 2020-04-20 | Sussex | Virginia | 51183 | 12 | 0 |
78271 | 78271 | 2020-04-21 | Sussex | Virginia | 51183 | 23 | 1 |
81064 | 81064 | 2020-04-22 | Sussex | Virginia | 51183 | 23 | 1 |
83865 | 83865 | 2020-04-23 | Sussex | Virginia | 51183 | 25 | 1 |
86672 | 86672 | 2020-04-24 | Sussex | Virginia | 51183 | 28 | 1 |
89487 | 89487 | 2020-04-25 | Sussex | Virginia | 51183 | 28 | 1 |
92304 | 92304 | 2020-04-26 | Sussex | Virginia | 51183 | 28 | 1 |
95133 | 95133 | 2020-04-27 | Sussex | Virginia | 51183 | 30 | 1 |
97977 | 97977 | 2020-04-28 | Sussex | Virginia | 51183 | 30 | 1 |
100827 | 100827 | 2020-04-29 | Sussex | Virginia | 51183 | 30 | 1 |
103682 | 103682 | 2020-04-30 | Sussex | Virginia | 51183 | 31 | 1 |
106546 | 106546 | 2020-05-01 | Sussex | Virginia | 51183 | 31 | 1 |
109415 | 109415 | 2020-05-02 | Sussex | Virginia | 51183 | 31 | 1 |
112289 | 112289 | 2020-05-03 | Sussex | Virginia | 51183 | 31 | 1 |
115172 | 115172 | 2020-05-04 | Sussex | Virginia | 51183 | 32 | 1 |
118131 | 118131 | 2020-05-05 | Sussex | Virginia | 51183 | 32 | 1 |
121095 | 121095 | 2020-05-06 | Sussex | Virginia | 51183 | 32 | 1 |
124076 | 124076 | 2020-05-07 | Sussex | Virginia | 51183 | 32 | 1 |
127061 | 127061 | 2020-05-08 | Sussex | Virginia | 51183 | 32 | 1 |
130051 | 130051 | 2020-05-09 | Sussex | Virginia | 51183 | 32 | 1 |
133041 | 133041 | 2020-05-10 | Sussex | Virginia | 51183 | 33 | 1 |
136031 | 136031 | 2020-05-11 | Sussex | Virginia | 51183 | 34 | 1 |
139022 | 139022 | 2020-05-12 | Sussex | Virginia | 51183 | 38 | 1 |
142018 | 142018 | 2020-05-13 | Sussex | Virginia | 51183 | 38 | 1 |
145015 | 145015 | 2020-05-14 | Sussex | Virginia | 51183 | 53 | 1 |
148018 | 148018 | 2020-05-15 | Sussex | Virginia | 51183 | 67 | 1 |
151027 | 151027 | 2020-05-16 | Sussex | Virginia | 51183 | 80 | 1 |
154038 | 154038 | 2020-05-17 | Sussex | Virginia | 51183 | 80 | 1 |
157055 | 157055 | 2020-05-18 | Sussex | Virginia | 51183 | 91 | 1 |
160079 | 160079 | 2020-05-19 | Sussex | Virginia | 51183 | 98 | 1 |
163107 | 163107 | 2020-05-20 | Sussex | Virginia | 51183 | 99 | 1 |
166136 | 166136 | 2020-05-21 | Sussex | Virginia | 51183 | 100 | 1 |
169172 | 169172 | 2020-05-22 | Sussex | Virginia | 51183 | 100 | 1 |
172213 | 172213 | 2020-05-23 | Sussex | Virginia | 51183 | 114 | 1 |
175256 | 175256 | 2020-05-24 | Sussex | Virginia | 51183 | 114 | 1 |
178301 | 178301 | 2020-05-25 | Sussex | Virginia | 51183 | 114 | 1 |
181345 | 181345 | 2020-05-26 | Sussex | Virginia | 51183 | 135 | 1 |
184396 | 184396 | 2020-05-27 | Sussex | Virginia | 51183 | 138 | 1 |
187453 | 187453 | 2020-05-28 | Sussex | Virginia | 51183 | 142 | 2 |
190517 | 190517 | 2020-05-29 | Sussex | Virginia | 51183 | 151 | 2 |
193583 | 193583 | 2020-05-30 | Sussex | Virginia | 51183 | 154 | 2 |
196653 | 196653 | 2020-05-31 | Sussex | Virginia | 51183 | 154 | 2 |
199726 | 199726 | 2020-06-01 | Sussex | Virginia | 51183 | 161 | 2 |
202802 | 202802 | 2020-06-02 | Sussex | Virginia | 51183 | 161 | 2 |
205881 | 205881 | 2020-06-03 | Sussex | Virginia | 51183 | 165 | 2 |
208963 | 208963 | 2020-06-04 | Sussex | Virginia | 51183 | 173 | 2 |
212048 | 212048 | 2020-06-05 | Sussex | Virginia | 51183 | 174 | 2 |
215135 | 215135 | 2020-06-06 | Sussex | Virginia | 51183 | 175 | 2 |
218225 | 218225 | 2020-06-07 | Sussex | Virginia | 51183 | 175 | 2 |
221317 | 221317 | 2020-06-08 | Sussex | Virginia | 51183 | 175 | 2 |
224413 | 224413 | 2020-06-09 | Sussex | Virginia | 51183 | 175 | 2 |
227513 | 227513 | 2020-06-10 | Sussex | Virginia | 51183 | 175 | 2 |
230617 | 230617 | 2020-06-11 | Sussex | Virginia | 51183 | 176 | 2 |
233722 | 233722 | 2020-06-12 | Sussex | Virginia | 51183 | 177 | 2 |
236829 | 236829 | 2020-06-13 | Sussex | Virginia | 51183 | 178 | 2 |
239937 | 239937 | 2020-06-14 | Sussex | Virginia | 51183 | 181 | 2 |
243048 | 243048 | 2020-06-15 | Sussex | Virginia | 51183 | 183 | 2 |
246161 | 246161 | 2020-06-16 | Sussex | Virginia | 51183 | 183 | 2 |
249273 | 249273 | 2020-06-17 | Sussex | Virginia | 51183 | 184 | 2 |
252388 | 252388 | 2020-06-18 | Sussex | Virginia | 51183 | 185 | 2 |
255507 | 255507 | 2020-06-19 | Sussex | Virginia | 51183 | 185 | 2 |
258634 | 258634 | 2020-06-20 | Sussex | Virginia | 51183 | 185 | 2 |
261761 | 261761 | 2020-06-21 | Sussex | Virginia | 51183 | 185 | 2 |
264890 | 264890 | 2020-06-22 | Sussex | Virginia | 51183 | 186 | 2 |
268019 | 268019 | 2020-06-23 | Sussex | Virginia | 51183 | 187 | 2 |
271153 | 271153 | 2020-06-24 | Sussex | Virginia | 51183 | 191 | 2 |
274293 | 274293 | 2020-06-25 | Sussex | Virginia | 51183 | 193 | 2 |
277441 | 277441 | 2020-06-26 | Sussex | Virginia | 51183 | 194 | 2 |
280589 | 280589 | 2020-06-27 | Sussex | Virginia | 51183 | 195 | 2 |
283735 | 283735 | 2020-06-28 | Sussex | Virginia | 51183 | 195 | 2 |
286881 | 286881 | 2020-06-29 | Sussex | Virginia | 51183 | 195 | 2 |
290031 | 290031 | 2020-06-30 | Sussex | Virginia | 51183 | 194 | 2 |
293184 | 293184 | 2020-07-01 | Sussex | Virginia | 51183 | 200 | 3 |
296339 | 296339 | 2020-07-02 | Sussex | Virginia | 51183 | 205 | 4 |
299501 | 299501 | 2020-07-03 | Sussex | Virginia | 51183 | 208 | 5 |
302665 | 302665 | 2020-07-04 | Sussex | Virginia | 51183 | 209 | 5 |
305829 | 305829 | 2020-07-05 | Sussex | Virginia | 51183 | 209 | 5 |
308997 | 308997 | 2020-07-06 | Sussex | Virginia | 51183 | 210 | 5 |
312166 | 312166 | 2020-07-07 | Sussex | Virginia | 51183 | 211 | 5 |
315341 | 315341 | 2020-07-08 | Sussex | Virginia | 51183 | 212 | 5 |
318514 | 318514 | 2020-07-09 | Sussex | Virginia | 51183 | 210 | 7 |
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);