ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Troup" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635415 | 635415 | 2020-10-16 | Troup | Georgia | 13285 | 3289 | 104 |
632169 | 632169 | 2020-10-15 | Troup | Georgia | 13285 | 3282 | 104 |
628925 | 628925 | 2020-10-14 | Troup | Georgia | 13285 | 3266 | 103 |
625682 | 625682 | 2020-10-13 | Troup | Georgia | 13285 | 3248 | 103 |
622439 | 622439 | 2020-10-12 | Troup | Georgia | 13285 | 3242 | 103 |
619196 | 619196 | 2020-10-11 | Troup | Georgia | 13285 | 3207 | 103 |
615954 | 615954 | 2020-10-10 | Troup | Georgia | 13285 | 3195 | 103 |
612713 | 612713 | 2020-10-09 | Troup | Georgia | 13285 | 3193 | 103 |
609471 | 609471 | 2020-10-08 | Troup | Georgia | 13285 | 3184 | 102 |
606228 | 606228 | 2020-10-07 | Troup | Georgia | 13285 | 3170 | 102 |
602986 | 602986 | 2020-10-06 | Troup | Georgia | 13285 | 3163 | 102 |
599743 | 599743 | 2020-10-05 | Troup | Georgia | 13285 | 3157 | 101 |
596500 | 596500 | 2020-10-04 | Troup | Georgia | 13285 | 2850 | 101 |
593258 | 593258 | 2020-10-03 | Troup | Georgia | 13285 | 2845 | 101 |
590018 | 590018 | 2020-10-02 | Troup | Georgia | 13285 | 2837 | 100 |
586777 | 586777 | 2020-10-01 | Troup | Georgia | 13285 | 2833 | 100 |
583537 | 583537 | 2020-09-30 | Troup | Georgia | 13285 | 2822 | 100 |
580298 | 580298 | 2020-09-29 | Troup | Georgia | 13285 | 2808 | 100 |
577057 | 577057 | 2020-09-28 | Troup | Georgia | 13285 | 2805 | 99 |
573814 | 573814 | 2020-09-27 | Troup | Georgia | 13285 | 2802 | 96 |
570572 | 570572 | 2020-09-26 | Troup | Georgia | 13285 | 2800 | 96 |
567330 | 567330 | 2020-09-25 | Troup | Georgia | 13285 | 2796 | 96 |
564090 | 564090 | 2020-09-24 | Troup | Georgia | 13285 | 2785 | 96 |
560850 | 560850 | 2020-09-23 | Troup | Georgia | 13285 | 2776 | 95 |
557614 | 557614 | 2020-09-22 | Troup | Georgia | 13285 | 2763 | 94 |
554377 | 554377 | 2020-09-21 | Troup | Georgia | 13285 | 2758 | 93 |
551138 | 551138 | 2020-09-20 | Troup | Georgia | 13285 | 2754 | 93 |
547899 | 547899 | 2020-09-19 | Troup | Georgia | 13285 | 2752 | 93 |
544661 | 544661 | 2020-09-18 | Troup | Georgia | 13285 | 2739 | 93 |
541425 | 541425 | 2020-09-17 | Troup | Georgia | 13285 | 2732 | 93 |
538188 | 538188 | 2020-09-16 | Troup | Georgia | 13285 | 2720 | 93 |
534952 | 534952 | 2020-09-15 | Troup | Georgia | 13285 | 2711 | 93 |
531717 | 531717 | 2020-09-14 | Troup | Georgia | 13285 | 2701 | 93 |
528480 | 528480 | 2020-09-13 | Troup | Georgia | 13285 | 2697 | 93 |
525244 | 525244 | 2020-09-12 | Troup | Georgia | 13285 | 2692 | 92 |
522008 | 522008 | 2020-09-11 | Troup | Georgia | 13285 | 2679 | 91 |
518771 | 518771 | 2020-09-10 | Troup | Georgia | 13285 | 2674 | 92 |
515536 | 515536 | 2020-09-09 | Troup | Georgia | 13285 | 2669 | 91 |
512303 | 512303 | 2020-09-08 | Troup | Georgia | 13285 | 2663 | 90 |
509070 | 509070 | 2020-09-07 | Troup | Georgia | 13285 | 2655 | 90 |
505838 | 505838 | 2020-09-06 | Troup | Georgia | 13285 | 2652 | 90 |
502604 | 502604 | 2020-09-05 | Troup | Georgia | 13285 | 2642 | 90 |
499370 | 499370 | 2020-09-04 | Troup | Georgia | 13285 | 2634 | 89 |
496137 | 496137 | 2020-09-03 | Troup | Georgia | 13285 | 2627 | 87 |
492903 | 492903 | 2020-09-02 | Troup | Georgia | 13285 | 2614 | 86 |
489670 | 489670 | 2020-09-01 | Troup | Georgia | 13285 | 2602 | 85 |
486437 | 486437 | 2020-08-31 | Troup | Georgia | 13285 | 2589 | 84 |
483202 | 483202 | 2020-08-30 | Troup | Georgia | 13285 | 2588 | 84 |
479968 | 479968 | 2020-08-29 | Troup | Georgia | 13285 | 2584 | 84 |
476735 | 476735 | 2020-08-28 | Troup | Georgia | 13285 | 2570 | 84 |
473502 | 473502 | 2020-08-27 | Troup | Georgia | 13285 | 2557 | 82 |
470270 | 470270 | 2020-08-26 | Troup | Georgia | 13285 | 2540 | 81 |
467041 | 467041 | 2020-08-25 | Troup | Georgia | 13285 | 2516 | 79 |
463812 | 463812 | 2020-08-24 | Troup | Georgia | 13285 | 2512 | 79 |
460583 | 460583 | 2020-08-23 | Troup | Georgia | 13285 | 2503 | 79 |
457356 | 457356 | 2020-08-22 | Troup | Georgia | 13285 | 2496 | 79 |
454128 | 454128 | 2020-08-21 | Troup | Georgia | 13285 | 2483 | 78 |
450900 | 450900 | 2020-08-20 | Troup | Georgia | 13285 | 2454 | 77 |
447672 | 447672 | 2020-08-19 | Troup | Georgia | 13285 | 2438 | 77 |
444445 | 444445 | 2020-08-18 | Troup | Georgia | 13285 | 2431 | 77 |
441219 | 441219 | 2020-08-17 | Troup | Georgia | 13285 | 2419 | 77 |
437993 | 437993 | 2020-08-16 | Troup | Georgia | 13285 | 2413 | 77 |
434767 | 434767 | 2020-08-15 | Troup | Georgia | 13285 | 2400 | 76 |
431542 | 431542 | 2020-08-14 | Troup | Georgia | 13285 | 2380 | 74 |
428314 | 428314 | 2020-08-13 | Troup | Georgia | 13285 | 2354 | 73 |
425090 | 425090 | 2020-08-12 | Troup | Georgia | 13285 | 2335 | 71 |
421869 | 421869 | 2020-08-11 | Troup | Georgia | 13285 | 2312 | 72 |
418648 | 418648 | 2020-08-10 | Troup | Georgia | 13285 | 2298 | 69 |
415427 | 415427 | 2020-08-09 | Troup | Georgia | 13285 | 2290 | 69 |
412207 | 412207 | 2020-08-08 | Troup | Georgia | 13285 | 2280 | 69 |
408988 | 408988 | 2020-08-07 | Troup | Georgia | 13285 | 2257 | 69 |
405768 | 405768 | 2020-08-06 | Troup | Georgia | 13285 | 2238 | 67 |
402550 | 402550 | 2020-08-05 | Troup | Georgia | 13285 | 2213 | 66 |
399334 | 399334 | 2020-08-04 | Troup | Georgia | 13285 | 2193 | 64 |
396118 | 396118 | 2020-08-03 | Troup | Georgia | 13285 | 2175 | 63 |
392902 | 392902 | 2020-08-02 | Troup | Georgia | 13285 | 2169 | 63 |
389685 | 389685 | 2020-08-01 | Troup | Georgia | 13285 | 2159 | 63 |
386468 | 386468 | 2020-07-31 | Troup | Georgia | 13285 | 2158 | 58 |
383250 | 383250 | 2020-07-30 | Troup | Georgia | 13285 | 2140 | 54 |
380033 | 380033 | 2020-07-29 | Troup | Georgia | 13285 | 2130 | 53 |
376816 | 376816 | 2020-07-28 | Troup | Georgia | 13285 | 2109 | 53 |
373602 | 373602 | 2020-07-27 | Troup | Georgia | 13285 | 2090 | 52 |
370390 | 370390 | 2020-07-26 | Troup | Georgia | 13285 | 2085 | 52 |
367180 | 367180 | 2020-07-25 | Troup | Georgia | 13285 | 2069 | 52 |
363973 | 363973 | 2020-07-24 | Troup | Georgia | 13285 | 2027 | 52 |
360766 | 360766 | 2020-07-23 | Troup | Georgia | 13285 | 1999 | 50 |
357561 | 357561 | 2020-07-22 | Troup | Georgia | 13285 | 1957 | 49 |
354358 | 354358 | 2020-07-21 | Troup | Georgia | 13285 | 1939 | 45 |
351156 | 351156 | 2020-07-20 | Troup | Georgia | 13285 | 1874 | 43 |
347955 | 347955 | 2020-07-19 | Troup | Georgia | 13285 | 1866 | 43 |
344755 | 344755 | 2020-07-18 | Troup | Georgia | 13285 | 1857 | 43 |
341556 | 341556 | 2020-07-17 | Troup | Georgia | 13285 | 1841 | 44 |
338359 | 338359 | 2020-07-16 | Troup | Georgia | 13285 | 1815 | 39 |
335164 | 335164 | 2020-07-15 | Troup | Georgia | 13285 | 1802 | 39 |
331971 | 331971 | 2020-07-14 | Troup | Georgia | 13285 | 1767 | 38 |
328784 | 328784 | 2020-07-13 | Troup | Georgia | 13285 | 1756 | 38 |
325598 | 325598 | 2020-07-12 | Troup | Georgia | 13285 | 1750 | 38 |
322417 | 322417 | 2020-07-11 | Troup | Georgia | 13285 | 1744 | 38 |
319238 | 319238 | 2020-07-10 | Troup | Georgia | 13285 | 1716 | 38 |
316065 | 316065 | 2020-07-09 | Troup | Georgia | 13285 | 1698 | 38 |
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);