ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where county = "James City" and deaths = 15 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
312108 | 312108 | 2020-07-07 | James City | Virginia | 51095 | 306 | 15 |
308939 | 308939 | 2020-07-06 | James City | Virginia | 51095 | 297 | 15 |
305771 | 305771 | 2020-07-05 | James City | Virginia | 51095 | 293 | 15 |
302607 | 302607 | 2020-07-04 | James City | Virginia | 51095 | 279 | 15 |
299443 | 299443 | 2020-07-03 | James City | Virginia | 51095 | 270 | 15 |
296281 | 296281 | 2020-07-02 | James City | Virginia | 51095 | 268 | 15 |
293126 | 293126 | 2020-07-01 | James City | Virginia | 51095 | 265 | 15 |
289973 | 289973 | 2020-06-30 | James City | Virginia | 51095 | 263 | 15 |
286823 | 286823 | 2020-06-29 | James City | Virginia | 51095 | 258 | 15 |
283677 | 283677 | 2020-06-28 | James City | Virginia | 51095 | 254 | 15 |
280531 | 280531 | 2020-06-27 | James City | Virginia | 51095 | 252 | 15 |
277383 | 277383 | 2020-06-26 | James City | Virginia | 51095 | 251 | 15 |
274235 | 274235 | 2020-06-25 | James City | Virginia | 51095 | 248 | 15 |
271095 | 271095 | 2020-06-24 | James City | Virginia | 51095 | 247 | 15 |
267961 | 267961 | 2020-06-23 | James City | Virginia | 51095 | 245 | 15 |
264832 | 264832 | 2020-06-22 | James City | Virginia | 51095 | 245 | 15 |
261703 | 261703 | 2020-06-21 | James City | Virginia | 51095 | 242 | 15 |
258576 | 258576 | 2020-06-20 | James City | Virginia | 51095 | 239 | 15 |
255449 | 255449 | 2020-06-19 | James City | Virginia | 51095 | 238 | 15 |
252330 | 252330 | 2020-06-18 | James City | Virginia | 51095 | 237 | 15 |
249215 | 249215 | 2020-06-17 | James City | Virginia | 51095 | 236 | 15 |
246103 | 246103 | 2020-06-16 | James City | Virginia | 51095 | 236 | 15 |
242990 | 242990 | 2020-06-15 | James City | Virginia | 51095 | 233 | 15 |
239879 | 239879 | 2020-06-14 | James City | Virginia | 51095 | 233 | 15 |
236771 | 236771 | 2020-06-13 | James City | Virginia | 51095 | 231 | 15 |
233664 | 233664 | 2020-06-12 | James City | Virginia | 51095 | 230 | 15 |
230559 | 230559 | 2020-06-11 | James City | Virginia | 51095 | 225 | 15 |
227455 | 227455 | 2020-06-10 | James City | Virginia | 51095 | 224 | 15 |
224355 | 224355 | 2020-06-09 | James City | Virginia | 51095 | 224 | 15 |
221259 | 221259 | 2020-06-08 | James City | Virginia | 51095 | 217 | 15 |
218167 | 218167 | 2020-06-07 | James City | Virginia | 51095 | 216 | 15 |
215077 | 215077 | 2020-06-06 | James City | Virginia | 51095 | 211 | 15 |
211990 | 211990 | 2020-06-05 | James City | Virginia | 51095 | 211 | 15 |
208905 | 208905 | 2020-06-04 | James City | Virginia | 51095 | 211 | 15 |
205823 | 205823 | 2020-06-03 | James City | Virginia | 51095 | 211 | 15 |
202744 | 202744 | 2020-06-02 | James City | Virginia | 51095 | 210 | 15 |
199668 | 199668 | 2020-06-01 | James City | Virginia | 51095 | 206 | 15 |
196595 | 196595 | 2020-05-31 | James City | Virginia | 51095 | 205 | 15 |
193525 | 193525 | 2020-05-30 | James City | Virginia | 51095 | 202 | 15 |
190459 | 190459 | 2020-05-29 | James City | Virginia | 51095 | 202 | 15 |
187395 | 187395 | 2020-05-28 | James City | Virginia | 51095 | 202 | 15 |
166078 | 166078 | 2020-05-21 | James City | Virginia | 51095 | 189 | 15 |
163049 | 163049 | 2020-05-20 | James City | Virginia | 51095 | 189 | 15 |
160021 | 160021 | 2020-05-19 | James City | Virginia | 51095 | 189 | 15 |
156997 | 156997 | 2020-05-18 | James City | Virginia | 51095 | 187 | 15 |
153980 | 153980 | 2020-05-17 | James City | Virginia | 51095 | 186 | 15 |
150969 | 150969 | 2020-05-16 | James City | Virginia | 51095 | 179 | 15 |
147960 | 147960 | 2020-05-15 | James City | Virginia | 51095 | 179 | 15 |
144957 | 144957 | 2020-05-14 | James City | Virginia | 51095 | 174 | 15 |
141960 | 141960 | 2020-05-13 | James City | Virginia | 51095 | 174 | 15 |
138964 | 138964 | 2020-05-12 | James City | Virginia | 51095 | 174 | 15 |
135973 | 135973 | 2020-05-11 | James City | Virginia | 51095 | 173 | 15 |
132983 | 132983 | 2020-05-10 | James City | Virginia | 51095 | 173 | 15 |
129993 | 129993 | 2020-05-09 | James City | Virginia | 51095 | 169 | 15 |
127003 | 127003 | 2020-05-08 | James City | Virginia | 51095 | 170 | 15 |
124018 | 124018 | 2020-05-07 | James City | Virginia | 51095 | 167 | 15 |
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);