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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
302596 | 302596 | 2020-07-04 | Greene | Virginia | 51079 | 72 | 1 |
305760 | 305760 | 2020-07-05 | Greene | Virginia | 51079 | 73 | 1 |
308928 | 308928 | 2020-07-06 | Greene | Virginia | 51079 | 75 | 1 |
312097 | 312097 | 2020-07-07 | Greene | Virginia | 51079 | 76 | 2 |
315272 | 315272 | 2020-07-08 | Greene | Virginia | 51079 | 76 | 2 |
318445 | 318445 | 2020-07-09 | Greene | Virginia | 51079 | 78 | 2 |
321624 | 321624 | 2020-07-10 | Greene | Virginia | 51079 | 80 | 2 |
324805 | 324805 | 2020-07-11 | Greene | Virginia | 51079 | 80 | 2 |
327990 | 327990 | 2020-07-12 | Greene | Virginia | 51079 | 84 | 2 |
331176 | 331176 | 2020-07-13 | Greene | Virginia | 51079 | 87 | 2 |
334369 | 334369 | 2020-07-14 | Greene | Virginia | 51079 | 87 | 2 |
337564 | 337564 | 2020-07-15 | Greene | Virginia | 51079 | 88 | 2 |
340760 | 340760 | 2020-07-16 | Greene | Virginia | 51079 | 88 | 2 |
343959 | 343959 | 2020-07-17 | Greene | Virginia | 51079 | 92 | 2 |
347159 | 347159 | 2020-07-18 | Greene | Virginia | 51079 | 92 | 2 |
350360 | 350360 | 2020-07-19 | Greene | Virginia | 51079 | 93 | 2 |
353562 | 353562 | 2020-07-20 | Greene | Virginia | 51079 | 96 | 2 |
356765 | 356765 | 2020-07-21 | Greene | Virginia | 51079 | 100 | 2 |
359970 | 359970 | 2020-07-22 | Greene | Virginia | 51079 | 105 | 2 |
363176 | 363176 | 2020-07-23 | Greene | Virginia | 51079 | 108 | 2 |
366382 | 366382 | 2020-07-24 | Greene | Virginia | 51079 | 114 | 2 |
369591 | 369591 | 2020-07-25 | Greene | Virginia | 51079 | 119 | 2 |
372803 | 372803 | 2020-07-26 | Greene | Virginia | 51079 | 123 | 2 |
376017 | 376017 | 2020-07-27 | Greene | Virginia | 51079 | 134 | 2 |
379233 | 379233 | 2020-07-28 | Greene | Virginia | 51079 | 134 | 2 |
382450 | 382450 | 2020-07-29 | Greene | Virginia | 51079 | 134 | 2 |
385668 | 385668 | 2020-07-30 | Greene | Virginia | 51079 | 134 | 2 |
388885 | 388885 | 2020-07-31 | Greene | Virginia | 51079 | 134 | 2 |
392102 | 392102 | 2020-08-01 | Greene | Virginia | 51079 | 137 | 2 |
395318 | 395318 | 2020-08-02 | Greene | Virginia | 51079 | 138 | 2 |
398534 | 398534 | 2020-08-03 | Greene | Virginia | 51079 | 147 | 2 |
401750 | 401750 | 2020-08-04 | Greene | Virginia | 51079 | 151 | 2 |
404968 | 404968 | 2020-08-05 | Greene | Virginia | 51079 | 152 | 2 |
408188 | 408188 | 2020-08-06 | Greene | Virginia | 51079 | 153 | 2 |
411407 | 411407 | 2020-08-07 | Greene | Virginia | 51079 | 153 | 2 |
414627 | 414627 | 2020-08-08 | Greene | Virginia | 51079 | 154 | 2 |
417848 | 417848 | 2020-08-09 | Greene | Virginia | 51079 | 163 | 2 |
421069 | 421069 | 2020-08-10 | Greene | Virginia | 51079 | 166 | 2 |
424290 | 424290 | 2020-08-11 | Greene | Virginia | 51079 | 167 | 2 |
427514 | 427514 | 2020-08-12 | Greene | Virginia | 51079 | 169 | 2 |
430742 | 430742 | 2020-08-13 | Greene | Virginia | 51079 | 172 | 2 |
433967 | 433967 | 2020-08-14 | Greene | Virginia | 51079 | 173 | 2 |
437193 | 437193 | 2020-08-15 | Greene | Virginia | 51079 | 176 | 2 |
440419 | 440419 | 2020-08-16 | Greene | Virginia | 51079 | 177 | 2 |
443645 | 443645 | 2020-08-17 | Greene | Virginia | 51079 | 179 | 2 |
446872 | 446872 | 2020-08-18 | Greene | Virginia | 51079 | 182 | 2 |
450100 | 450100 | 2020-08-19 | Greene | Virginia | 51079 | 182 | 2 |
453328 | 453328 | 2020-08-20 | Greene | Virginia | 51079 | 185 | 2 |
456556 | 456556 | 2020-08-21 | Greene | Virginia | 51079 | 188 | 2 |
459783 | 459783 | 2020-08-22 | Greene | Virginia | 51079 | 189 | 2 |
463012 | 463012 | 2020-08-23 | Greene | Virginia | 51079 | 191 | 2 |
466241 | 466241 | 2020-08-24 | Greene | Virginia | 51079 | 192 | 2 |
469470 | 469470 | 2020-08-25 | Greene | Virginia | 51079 | 195 | 2 |
472702 | 472702 | 2020-08-26 | Greene | Virginia | 51079 | 196 | 2 |
475935 | 475935 | 2020-08-27 | Greene | Virginia | 51079 | 197 | 3 |
479168 | 479168 | 2020-08-28 | Greene | Virginia | 51079 | 199 | 3 |
482402 | 482402 | 2020-08-29 | Greene | Virginia | 51079 | 199 | 3 |
485637 | 485637 | 2020-08-30 | Greene | Virginia | 51079 | 199 | 3 |
488870 | 488870 | 2020-08-31 | Greene | Virginia | 51079 | 199 | 3 |
492103 | 492103 | 2020-09-01 | Greene | Virginia | 51079 | 199 | 3 |
495337 | 495337 | 2020-09-02 | Greene | Virginia | 51079 | 199 | 3 |
498570 | 498570 | 2020-09-03 | Greene | Virginia | 51079 | 199 | 3 |
501804 | 501804 | 2020-09-04 | Greene | Virginia | 51079 | 199 | 3 |
505038 | 505038 | 2020-09-05 | Greene | Virginia | 51079 | 200 | 3 |
508270 | 508270 | 2020-09-06 | Greene | Virginia | 51079 | 203 | 3 |
511503 | 511503 | 2020-09-07 | Greene | Virginia | 51079 | 203 | 3 |
514736 | 514736 | 2020-09-08 | Greene | Virginia | 51079 | 204 | 3 |
517971 | 517971 | 2020-09-09 | Greene | Virginia | 51079 | 203 | 3 |
521208 | 521208 | 2020-09-10 | Greene | Virginia | 51079 | 204 | 3 |
524444 | 524444 | 2020-09-11 | Greene | Virginia | 51079 | 207 | 3 |
527680 | 527680 | 2020-09-12 | Greene | Virginia | 51079 | 207 | 3 |
530917 | 530917 | 2020-09-13 | Greene | Virginia | 51079 | 206 | 3 |
534152 | 534152 | 2020-09-14 | Greene | Virginia | 51079 | 207 | 3 |
537388 | 537388 | 2020-09-15 | Greene | Virginia | 51079 | 207 | 3 |
540625 | 540625 | 2020-09-16 | Greene | Virginia | 51079 | 207 | 3 |
543861 | 543861 | 2020-09-17 | Greene | Virginia | 51079 | 208 | 3 |
547098 | 547098 | 2020-09-18 | Greene | Virginia | 51079 | 208 | 3 |
550337 | 550337 | 2020-09-19 | Greene | Virginia | 51079 | 209 | 3 |
553576 | 553576 | 2020-09-20 | Greene | Virginia | 51079 | 212 | 3 |
556813 | 556813 | 2020-09-21 | Greene | Virginia | 51079 | 212 | 3 |
560049 | 560049 | 2020-09-22 | Greene | Virginia | 51079 | 212 | 3 |
563288 | 563288 | 2020-09-23 | Greene | Virginia | 51079 | 212 | 3 |
566529 | 566529 | 2020-09-24 | Greene | Virginia | 51079 | 213 | 3 |
569770 | 569770 | 2020-09-25 | Greene | Virginia | 51079 | 216 | 3 |
573012 | 573012 | 2020-09-26 | Greene | Virginia | 51079 | 216 | 3 |
576256 | 576256 | 2020-09-27 | Greene | Virginia | 51079 | 216 | 3 |
579497 | 579497 | 2020-09-28 | Greene | Virginia | 51079 | 219 | 3 |
582736 | 582736 | 2020-09-29 | Greene | Virginia | 51079 | 221 | 3 |
585976 | 585976 | 2020-09-30 | Greene | Virginia | 51079 | 223 | 3 |
589217 | 589217 | 2020-10-01 | Greene | Virginia | 51079 | 223 | 3 |
592457 | 592457 | 2020-10-02 | Greene | Virginia | 51079 | 227 | 3 |
595699 | 595699 | 2020-10-03 | Greene | Virginia | 51079 | 228 | 3 |
598942 | 598942 | 2020-10-04 | Greene | Virginia | 51079 | 232 | 3 |
602185 | 602185 | 2020-10-05 | Greene | Virginia | 51079 | 239 | 3 |
605427 | 605427 | 2020-10-06 | Greene | Virginia | 51079 | 241 | 3 |
608670 | 608670 | 2020-10-07 | Greene | Virginia | 51079 | 241 | 3 |
611912 | 611912 | 2020-10-08 | Greene | Virginia | 51079 | 244 | 3 |
615153 | 615153 | 2020-10-09 | Greene | Virginia | 51079 | 248 | 3 |
618395 | 618395 | 2020-10-10 | Greene | Virginia | 51079 | 250 | 3 |
621638 | 621638 | 2020-10-11 | Greene | Virginia | 51079 | 251 | 3 |
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);