ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Greene" and fips = 51079 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
537388 | 537388 | 2020-09-15 | Greene | Virginia | 51079 | 207 | 3 |
534152 | 534152 | 2020-09-14 | Greene | Virginia | 51079 | 207 | 3 |
530917 | 530917 | 2020-09-13 | Greene | Virginia | 51079 | 206 | 3 |
527680 | 527680 | 2020-09-12 | Greene | Virginia | 51079 | 207 | 3 |
524444 | 524444 | 2020-09-11 | Greene | Virginia | 51079 | 207 | 3 |
521208 | 521208 | 2020-09-10 | Greene | Virginia | 51079 | 204 | 3 |
517971 | 517971 | 2020-09-09 | Greene | Virginia | 51079 | 203 | 3 |
514736 | 514736 | 2020-09-08 | Greene | Virginia | 51079 | 204 | 3 |
511503 | 511503 | 2020-09-07 | Greene | Virginia | 51079 | 203 | 3 |
508270 | 508270 | 2020-09-06 | Greene | Virginia | 51079 | 203 | 3 |
505038 | 505038 | 2020-09-05 | Greene | Virginia | 51079 | 200 | 3 |
501804 | 501804 | 2020-09-04 | Greene | Virginia | 51079 | 199 | 3 |
498570 | 498570 | 2020-09-03 | Greene | Virginia | 51079 | 199 | 3 |
495337 | 495337 | 2020-09-02 | Greene | Virginia | 51079 | 199 | 3 |
492103 | 492103 | 2020-09-01 | Greene | Virginia | 51079 | 199 | 3 |
488870 | 488870 | 2020-08-31 | Greene | Virginia | 51079 | 199 | 3 |
485637 | 485637 | 2020-08-30 | Greene | Virginia | 51079 | 199 | 3 |
482402 | 482402 | 2020-08-29 | Greene | Virginia | 51079 | 199 | 3 |
479168 | 479168 | 2020-08-28 | Greene | Virginia | 51079 | 199 | 3 |
475935 | 475935 | 2020-08-27 | Greene | Virginia | 51079 | 197 | 3 |
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 |
308928 | 308928 | 2020-07-06 | Greene | Virginia | 51079 | 75 | 1 |
305760 | 305760 | 2020-07-05 | Greene | Virginia | 51079 | 73 | 1 |
302596 | 302596 | 2020-07-04 | Greene | Virginia | 51079 | 72 | 1 |
299432 | 299432 | 2020-07-03 | Greene | Virginia | 51079 | 67 | 1 |
296270 | 296270 | 2020-07-02 | Greene | Virginia | 51079 | 67 | 1 |
293115 | 293115 | 2020-07-01 | Greene | Virginia | 51079 | 66 | 1 |
289962 | 289962 | 2020-06-30 | Greene | Virginia | 51079 | 67 | 1 |
286812 | 286812 | 2020-06-29 | Greene | Virginia | 51079 | 65 | 1 |
283666 | 283666 | 2020-06-28 | Greene | Virginia | 51079 | 65 | 1 |
280520 | 280520 | 2020-06-27 | Greene | Virginia | 51079 | 60 | 1 |
277372 | 277372 | 2020-06-26 | Greene | Virginia | 51079 | 57 | 1 |
274224 | 274224 | 2020-06-25 | Greene | Virginia | 51079 | 57 | 1 |
271084 | 271084 | 2020-06-24 | Greene | Virginia | 51079 | 55 | 1 |
267950 | 267950 | 2020-06-23 | Greene | Virginia | 51079 | 55 | 1 |
264821 | 264821 | 2020-06-22 | Greene | Virginia | 51079 | 55 | 1 |
261692 | 261692 | 2020-06-21 | Greene | Virginia | 51079 | 49 | 1 |
258565 | 258565 | 2020-06-20 | Greene | Virginia | 51079 | 48 | 1 |
255438 | 255438 | 2020-06-19 | Greene | Virginia | 51079 | 48 | 1 |
252319 | 252319 | 2020-06-18 | Greene | Virginia | 51079 | 48 | 1 |
249204 | 249204 | 2020-06-17 | Greene | Virginia | 51079 | 46 | 1 |
246092 | 246092 | 2020-06-16 | Greene | Virginia | 51079 | 45 | 1 |
242979 | 242979 | 2020-06-15 | Greene | Virginia | 51079 | 45 | 1 |
239868 | 239868 | 2020-06-14 | Greene | Virginia | 51079 | 45 | 1 |
236760 | 236760 | 2020-06-13 | Greene | Virginia | 51079 | 45 | 1 |
233653 | 233653 | 2020-06-12 | Greene | Virginia | 51079 | 45 | 1 |
230548 | 230548 | 2020-06-11 | Greene | Virginia | 51079 | 45 | 1 |
227444 | 227444 | 2020-06-10 | Greene | Virginia | 51079 | 44 | 1 |
224344 | 224344 | 2020-06-09 | Greene | Virginia | 51079 | 44 | 1 |
221248 | 221248 | 2020-06-08 | Greene | Virginia | 51079 | 44 | 1 |
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);