ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
51 rows where county = "Greene", deaths = 2 and fips = 51079 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 |
---|---|---|---|---|---|---|---|
472702 | 472702 | 2020-08-26 | Greene | Virginia | 51079 | 196 | 2 |
469470 | 469470 | 2020-08-25 | Greene | Virginia | 51079 | 195 | 2 |
466241 | 466241 | 2020-08-24 | Greene | Virginia | 51079 | 192 | 2 |
463012 | 463012 | 2020-08-23 | Greene | Virginia | 51079 | 191 | 2 |
459783 | 459783 | 2020-08-22 | Greene | Virginia | 51079 | 189 | 2 |
456556 | 456556 | 2020-08-21 | Greene | Virginia | 51079 | 188 | 2 |
453328 | 453328 | 2020-08-20 | Greene | Virginia | 51079 | 185 | 2 |
450100 | 450100 | 2020-08-19 | Greene | Virginia | 51079 | 182 | 2 |
446872 | 446872 | 2020-08-18 | Greene | Virginia | 51079 | 182 | 2 |
443645 | 443645 | 2020-08-17 | Greene | Virginia | 51079 | 179 | 2 |
440419 | 440419 | 2020-08-16 | Greene | Virginia | 51079 | 177 | 2 |
437193 | 437193 | 2020-08-15 | Greene | Virginia | 51079 | 176 | 2 |
433967 | 433967 | 2020-08-14 | Greene | Virginia | 51079 | 173 | 2 |
430742 | 430742 | 2020-08-13 | Greene | Virginia | 51079 | 172 | 2 |
427514 | 427514 | 2020-08-12 | Greene | Virginia | 51079 | 169 | 2 |
424290 | 424290 | 2020-08-11 | Greene | Virginia | 51079 | 167 | 2 |
421069 | 421069 | 2020-08-10 | Greene | Virginia | 51079 | 166 | 2 |
417848 | 417848 | 2020-08-09 | Greene | Virginia | 51079 | 163 | 2 |
414627 | 414627 | 2020-08-08 | Greene | Virginia | 51079 | 154 | 2 |
411407 | 411407 | 2020-08-07 | Greene | Virginia | 51079 | 153 | 2 |
408188 | 408188 | 2020-08-06 | Greene | Virginia | 51079 | 153 | 2 |
404968 | 404968 | 2020-08-05 | Greene | Virginia | 51079 | 152 | 2 |
401750 | 401750 | 2020-08-04 | Greene | Virginia | 51079 | 151 | 2 |
398534 | 398534 | 2020-08-03 | Greene | Virginia | 51079 | 147 | 2 |
395318 | 395318 | 2020-08-02 | Greene | Virginia | 51079 | 138 | 2 |
392102 | 392102 | 2020-08-01 | Greene | Virginia | 51079 | 137 | 2 |
388885 | 388885 | 2020-07-31 | Greene | Virginia | 51079 | 134 | 2 |
385668 | 385668 | 2020-07-30 | Greene | Virginia | 51079 | 134 | 2 |
382450 | 382450 | 2020-07-29 | Greene | Virginia | 51079 | 134 | 2 |
379233 | 379233 | 2020-07-28 | Greene | Virginia | 51079 | 134 | 2 |
376017 | 376017 | 2020-07-27 | Greene | Virginia | 51079 | 134 | 2 |
372803 | 372803 | 2020-07-26 | Greene | Virginia | 51079 | 123 | 2 |
369591 | 369591 | 2020-07-25 | Greene | Virginia | 51079 | 119 | 2 |
366382 | 366382 | 2020-07-24 | Greene | Virginia | 51079 | 114 | 2 |
363176 | 363176 | 2020-07-23 | Greene | Virginia | 51079 | 108 | 2 |
359970 | 359970 | 2020-07-22 | Greene | Virginia | 51079 | 105 | 2 |
356765 | 356765 | 2020-07-21 | Greene | Virginia | 51079 | 100 | 2 |
353562 | 353562 | 2020-07-20 | Greene | Virginia | 51079 | 96 | 2 |
350360 | 350360 | 2020-07-19 | Greene | Virginia | 51079 | 93 | 2 |
347159 | 347159 | 2020-07-18 | Greene | Virginia | 51079 | 92 | 2 |
343959 | 343959 | 2020-07-17 | Greene | Virginia | 51079 | 92 | 2 |
340760 | 340760 | 2020-07-16 | Greene | Virginia | 51079 | 88 | 2 |
337564 | 337564 | 2020-07-15 | Greene | Virginia | 51079 | 88 | 2 |
334369 | 334369 | 2020-07-14 | Greene | Virginia | 51079 | 87 | 2 |
331176 | 331176 | 2020-07-13 | Greene | Virginia | 51079 | 87 | 2 |
327990 | 327990 | 2020-07-12 | Greene | Virginia | 51079 | 84 | 2 |
324805 | 324805 | 2020-07-11 | Greene | Virginia | 51079 | 80 | 2 |
321624 | 321624 | 2020-07-10 | Greene | Virginia | 51079 | 80 | 2 |
318445 | 318445 | 2020-07-09 | Greene | Virginia | 51079 | 78 | 2 |
315272 | 315272 | 2020-07-08 | Greene | Virginia | 51079 | 76 | 2 |
312097 | 312097 | 2020-07-07 | Greene | Virginia | 51079 | 76 | 2 |
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);