ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Clay" and fips = 13061 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635304 | 635304 | 2020-10-16 | Clay | Georgia | 13061 | 124 | 3 |
632058 | 632058 | 2020-10-15 | Clay | Georgia | 13061 | 124 | 3 |
628814 | 628814 | 2020-10-14 | Clay | Georgia | 13061 | 124 | 3 |
625571 | 625571 | 2020-10-13 | Clay | Georgia | 13061 | 124 | 3 |
622328 | 622328 | 2020-10-12 | Clay | Georgia | 13061 | 124 | 3 |
619085 | 619085 | 2020-10-11 | Clay | Georgia | 13061 | 124 | 3 |
615843 | 615843 | 2020-10-10 | Clay | Georgia | 13061 | 123 | 3 |
612602 | 612602 | 2020-10-09 | Clay | Georgia | 13061 | 123 | 3 |
609360 | 609360 | 2020-10-08 | Clay | Georgia | 13061 | 123 | 3 |
606117 | 606117 | 2020-10-07 | Clay | Georgia | 13061 | 123 | 3 |
602875 | 602875 | 2020-10-06 | Clay | Georgia | 13061 | 123 | 3 |
599632 | 599632 | 2020-10-05 | Clay | Georgia | 13061 | 123 | 3 |
596389 | 596389 | 2020-10-04 | Clay | Georgia | 13061 | 121 | 3 |
593147 | 593147 | 2020-10-03 | Clay | Georgia | 13061 | 121 | 3 |
589907 | 589907 | 2020-10-02 | Clay | Georgia | 13061 | 121 | 3 |
586666 | 586666 | 2020-10-01 | Clay | Georgia | 13061 | 121 | 2 |
583426 | 583426 | 2020-09-30 | Clay | Georgia | 13061 | 122 | 2 |
580187 | 580187 | 2020-09-29 | Clay | Georgia | 13061 | 121 | 2 |
576946 | 576946 | 2020-09-28 | Clay | Georgia | 13061 | 121 | 2 |
573703 | 573703 | 2020-09-27 | Clay | Georgia | 13061 | 121 | 2 |
570461 | 570461 | 2020-09-26 | Clay | Georgia | 13061 | 121 | 2 |
567219 | 567219 | 2020-09-25 | Clay | Georgia | 13061 | 120 | 2 |
563979 | 563979 | 2020-09-24 | Clay | Georgia | 13061 | 120 | 2 |
560739 | 560739 | 2020-09-23 | Clay | Georgia | 13061 | 120 | 2 |
557503 | 557503 | 2020-09-22 | Clay | Georgia | 13061 | 120 | 2 |
554266 | 554266 | 2020-09-21 | Clay | Georgia | 13061 | 120 | 2 |
551027 | 551027 | 2020-09-20 | Clay | Georgia | 13061 | 120 | 2 |
547788 | 547788 | 2020-09-19 | Clay | Georgia | 13061 | 120 | 2 |
544550 | 544550 | 2020-09-18 | Clay | Georgia | 13061 | 120 | 2 |
541314 | 541314 | 2020-09-17 | Clay | Georgia | 13061 | 119 | 2 |
538077 | 538077 | 2020-09-16 | Clay | Georgia | 13061 | 119 | 2 |
534841 | 534841 | 2020-09-15 | Clay | Georgia | 13061 | 118 | 2 |
531606 | 531606 | 2020-09-14 | Clay | Georgia | 13061 | 118 | 2 |
528369 | 528369 | 2020-09-13 | Clay | Georgia | 13061 | 118 | 2 |
525133 | 525133 | 2020-09-12 | Clay | Georgia | 13061 | 116 | 2 |
521897 | 521897 | 2020-09-11 | Clay | Georgia | 13061 | 117 | 2 |
518660 | 518660 | 2020-09-10 | Clay | Georgia | 13061 | 115 | 2 |
515425 | 515425 | 2020-09-09 | Clay | Georgia | 13061 | 115 | 2 |
512192 | 512192 | 2020-09-08 | Clay | Georgia | 13061 | 114 | 2 |
508959 | 508959 | 2020-09-07 | Clay | Georgia | 13061 | 114 | 2 |
505727 | 505727 | 2020-09-06 | Clay | Georgia | 13061 | 114 | 2 |
502493 | 502493 | 2020-09-05 | Clay | Georgia | 13061 | 114 | 2 |
499259 | 499259 | 2020-09-04 | Clay | Georgia | 13061 | 114 | 2 |
496026 | 496026 | 2020-09-03 | Clay | Georgia | 13061 | 113 | 2 |
492792 | 492792 | 2020-09-02 | Clay | Georgia | 13061 | 113 | 2 |
489559 | 489559 | 2020-09-01 | Clay | Georgia | 13061 | 113 | 2 |
486326 | 486326 | 2020-08-31 | Clay | Georgia | 13061 | 111 | 2 |
483091 | 483091 | 2020-08-30 | Clay | Georgia | 13061 | 111 | 2 |
479857 | 479857 | 2020-08-29 | Clay | Georgia | 13061 | 112 | 2 |
476624 | 476624 | 2020-08-28 | Clay | Georgia | 13061 | 112 | 2 |
473391 | 473391 | 2020-08-27 | Clay | Georgia | 13061 | 112 | 2 |
470159 | 470159 | 2020-08-26 | Clay | Georgia | 13061 | 111 | 2 |
466930 | 466930 | 2020-08-25 | Clay | Georgia | 13061 | 110 | 2 |
463701 | 463701 | 2020-08-24 | Clay | Georgia | 13061 | 110 | 2 |
460472 | 460472 | 2020-08-23 | Clay | Georgia | 13061 | 109 | 2 |
457245 | 457245 | 2020-08-22 | Clay | Georgia | 13061 | 108 | 2 |
454017 | 454017 | 2020-08-21 | Clay | Georgia | 13061 | 108 | 2 |
450789 | 450789 | 2020-08-20 | Clay | Georgia | 13061 | 107 | 2 |
447561 | 447561 | 2020-08-19 | Clay | Georgia | 13061 | 106 | 2 |
444334 | 444334 | 2020-08-18 | Clay | Georgia | 13061 | 106 | 2 |
441108 | 441108 | 2020-08-17 | Clay | Georgia | 13061 | 103 | 2 |
437882 | 437882 | 2020-08-16 | Clay | Georgia | 13061 | 103 | 2 |
434656 | 434656 | 2020-08-15 | Clay | Georgia | 13061 | 101 | 2 |
431431 | 431431 | 2020-08-14 | Clay | Georgia | 13061 | 100 | 2 |
428203 | 428203 | 2020-08-13 | Clay | Georgia | 13061 | 96 | 2 |
424979 | 424979 | 2020-08-12 | Clay | Georgia | 13061 | 93 | 2 |
421758 | 421758 | 2020-08-11 | Clay | Georgia | 13061 | 91 | 2 |
418537 | 418537 | 2020-08-10 | Clay | Georgia | 13061 | 86 | 2 |
415316 | 415316 | 2020-08-09 | Clay | Georgia | 13061 | 86 | 2 |
412096 | 412096 | 2020-08-08 | Clay | Georgia | 13061 | 86 | 2 |
408877 | 408877 | 2020-08-07 | Clay | Georgia | 13061 | 86 | 2 |
405657 | 405657 | 2020-08-06 | Clay | Georgia | 13061 | 85 | 2 |
402439 | 402439 | 2020-08-05 | Clay | Georgia | 13061 | 85 | 2 |
399223 | 399223 | 2020-08-04 | Clay | Georgia | 13061 | 85 | 2 |
396007 | 396007 | 2020-08-03 | Clay | Georgia | 13061 | 80 | 2 |
392791 | 392791 | 2020-08-02 | Clay | Georgia | 13061 | 80 | 2 |
389574 | 389574 | 2020-08-01 | Clay | Georgia | 13061 | 76 | 2 |
386357 | 386357 | 2020-07-31 | Clay | Georgia | 13061 | 72 | 2 |
383139 | 383139 | 2020-07-30 | Clay | Georgia | 13061 | 70 | 2 |
379922 | 379922 | 2020-07-29 | Clay | Georgia | 13061 | 69 | 2 |
376705 | 376705 | 2020-07-28 | Clay | Georgia | 13061 | 69 | 2 |
373491 | 373491 | 2020-07-27 | Clay | Georgia | 13061 | 69 | 2 |
370279 | 370279 | 2020-07-26 | Clay | Georgia | 13061 | 69 | 2 |
367069 | 367069 | 2020-07-25 | Clay | Georgia | 13061 | 69 | 2 |
363862 | 363862 | 2020-07-24 | Clay | Georgia | 13061 | 69 | 2 |
360655 | 360655 | 2020-07-23 | Clay | Georgia | 13061 | 68 | 2 |
357450 | 357450 | 2020-07-22 | Clay | Georgia | 13061 | 68 | 2 |
354247 | 354247 | 2020-07-21 | Clay | Georgia | 13061 | 67 | 2 |
351045 | 351045 | 2020-07-20 | Clay | Georgia | 13061 | 65 | 2 |
347844 | 347844 | 2020-07-19 | Clay | Georgia | 13061 | 65 | 2 |
344644 | 344644 | 2020-07-18 | Clay | Georgia | 13061 | 65 | 2 |
341445 | 341445 | 2020-07-17 | Clay | Georgia | 13061 | 65 | 2 |
338248 | 338248 | 2020-07-16 | Clay | Georgia | 13061 | 65 | 2 |
335053 | 335053 | 2020-07-15 | Clay | Georgia | 13061 | 64 | 2 |
331860 | 331860 | 2020-07-14 | Clay | Georgia | 13061 | 63 | 2 |
328673 | 328673 | 2020-07-13 | Clay | Georgia | 13061 | 63 | 2 |
325487 | 325487 | 2020-07-12 | Clay | Georgia | 13061 | 61 | 2 |
322306 | 322306 | 2020-07-11 | Clay | Georgia | 13061 | 61 | 2 |
319127 | 319127 | 2020-07-10 | Clay | Georgia | 13061 | 59 | 2 |
315954 | 315954 | 2020-07-09 | Clay | Georgia | 13061 | 56 | 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);