ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Union" and fips = 13291 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635418 | 635418 | 2020-10-16 | Union | Georgia | 13291 | 856 | 23 |
632172 | 632172 | 2020-10-15 | Union | Georgia | 13291 | 854 | 23 |
628928 | 628928 | 2020-10-14 | Union | Georgia | 13291 | 852 | 23 |
625685 | 625685 | 2020-10-13 | Union | Georgia | 13291 | 848 | 23 |
622442 | 622442 | 2020-10-12 | Union | Georgia | 13291 | 843 | 22 |
619199 | 619199 | 2020-10-11 | Union | Georgia | 13291 | 844 | 22 |
615957 | 615957 | 2020-10-10 | Union | Georgia | 13291 | 845 | 22 |
612716 | 612716 | 2020-10-09 | Union | Georgia | 13291 | 843 | 22 |
609474 | 609474 | 2020-10-08 | Union | Georgia | 13291 | 837 | 21 |
606231 | 606231 | 2020-10-07 | Union | Georgia | 13291 | 836 | 21 |
602989 | 602989 | 2020-10-06 | Union | Georgia | 13291 | 825 | 21 |
599746 | 599746 | 2020-10-05 | Union | Georgia | 13291 | 808 | 21 |
596503 | 596503 | 2020-10-04 | Union | Georgia | 13291 | 803 | 21 |
593261 | 593261 | 2020-10-03 | Union | Georgia | 13291 | 797 | 21 |
590021 | 590021 | 2020-10-02 | Union | Georgia | 13291 | 786 | 20 |
586780 | 586780 | 2020-10-01 | Union | Georgia | 13291 | 779 | 20 |
583540 | 583540 | 2020-09-30 | Union | Georgia | 13291 | 777 | 20 |
580301 | 580301 | 2020-09-29 | Union | Georgia | 13291 | 771 | 20 |
577060 | 577060 | 2020-09-28 | Union | Georgia | 13291 | 756 | 20 |
573817 | 573817 | 2020-09-27 | Union | Georgia | 13291 | 757 | 20 |
570575 | 570575 | 2020-09-26 | Union | Georgia | 13291 | 757 | 20 |
567333 | 567333 | 2020-09-25 | Union | Georgia | 13291 | 737 | 20 |
564093 | 564093 | 2020-09-24 | Union | Georgia | 13291 | 707 | 19 |
560853 | 560853 | 2020-09-23 | Union | Georgia | 13291 | 701 | 18 |
557617 | 557617 | 2020-09-22 | Union | Georgia | 13291 | 675 | 18 |
554380 | 554380 | 2020-09-21 | Union | Georgia | 13291 | 675 | 17 |
551141 | 551141 | 2020-09-20 | Union | Georgia | 13291 | 666 | 17 |
547902 | 547902 | 2020-09-19 | Union | Georgia | 13291 | 660 | 17 |
544664 | 544664 | 2020-09-18 | Union | Georgia | 13291 | 649 | 17 |
541428 | 541428 | 2020-09-17 | Union | Georgia | 13291 | 641 | 17 |
538191 | 538191 | 2020-09-16 | Union | Georgia | 13291 | 619 | 17 |
534955 | 534955 | 2020-09-15 | Union | Georgia | 13291 | 608 | 17 |
531720 | 531720 | 2020-09-14 | Union | Georgia | 13291 | 603 | 17 |
528483 | 528483 | 2020-09-13 | Union | Georgia | 13291 | 599 | 17 |
525247 | 525247 | 2020-09-12 | Union | Georgia | 13291 | 599 | 17 |
522011 | 522011 | 2020-09-11 | Union | Georgia | 13291 | 582 | 16 |
518774 | 518774 | 2020-09-10 | Union | Georgia | 13291 | 542 | 16 |
515539 | 515539 | 2020-09-09 | Union | Georgia | 13291 | 538 | 14 |
512306 | 512306 | 2020-09-08 | Union | Georgia | 13291 | 534 | 14 |
509073 | 509073 | 2020-09-07 | Union | Georgia | 13291 | 529 | 14 |
505841 | 505841 | 2020-09-06 | Union | Georgia | 13291 | 519 | 14 |
502607 | 502607 | 2020-09-05 | Union | Georgia | 13291 | 516 | 14 |
499373 | 499373 | 2020-09-04 | Union | Georgia | 13291 | 511 | 14 |
496140 | 496140 | 2020-09-03 | Union | Georgia | 13291 | 509 | 12 |
492906 | 492906 | 2020-09-02 | Union | Georgia | 13291 | 497 | 11 |
489673 | 489673 | 2020-09-01 | Union | Georgia | 13291 | 488 | 11 |
486440 | 486440 | 2020-08-31 | Union | Georgia | 13291 | 480 | 10 |
483205 | 483205 | 2020-08-30 | Union | Georgia | 13291 | 474 | 10 |
479971 | 479971 | 2020-08-29 | Union | Georgia | 13291 | 463 | 9 |
476738 | 476738 | 2020-08-28 | Union | Georgia | 13291 | 463 | 9 |
473505 | 473505 | 2020-08-27 | Union | Georgia | 13291 | 449 | 8 |
470273 | 470273 | 2020-08-26 | Union | Georgia | 13291 | 427 | 7 |
467044 | 467044 | 2020-08-25 | Union | Georgia | 13291 | 423 | 7 |
463815 | 463815 | 2020-08-24 | Union | Georgia | 13291 | 413 | 7 |
460586 | 460586 | 2020-08-23 | Union | Georgia | 13291 | 403 | 7 |
457359 | 457359 | 2020-08-22 | Union | Georgia | 13291 | 397 | 7 |
454131 | 454131 | 2020-08-21 | Union | Georgia | 13291 | 386 | 7 |
450903 | 450903 | 2020-08-20 | Union | Georgia | 13291 | 384 | 7 |
447675 | 447675 | 2020-08-19 | Union | Georgia | 13291 | 371 | 7 |
444448 | 444448 | 2020-08-18 | Union | Georgia | 13291 | 363 | 7 |
441222 | 441222 | 2020-08-17 | Union | Georgia | 13291 | 335 | 7 |
437996 | 437996 | 2020-08-16 | Union | Georgia | 13291 | 331 | 7 |
434770 | 434770 | 2020-08-15 | Union | Georgia | 13291 | 331 | 7 |
431545 | 431545 | 2020-08-14 | Union | Georgia | 13291 | 324 | 7 |
428317 | 428317 | 2020-08-13 | Union | Georgia | 13291 | 313 | 7 |
425093 | 425093 | 2020-08-12 | Union | Georgia | 13291 | 298 | 7 |
421872 | 421872 | 2020-08-11 | Union | Georgia | 13291 | 285 | 7 |
418651 | 418651 | 2020-08-10 | Union | Georgia | 13291 | 264 | 7 |
415430 | 415430 | 2020-08-09 | Union | Georgia | 13291 | 263 | 7 |
412210 | 412210 | 2020-08-08 | Union | Georgia | 13291 | 260 | 7 |
408991 | 408991 | 2020-08-07 | Union | Georgia | 13291 | 256 | 7 |
405771 | 405771 | 2020-08-06 | Union | Georgia | 13291 | 242 | 7 |
402553 | 402553 | 2020-08-05 | Union | Georgia | 13291 | 238 | 6 |
399337 | 399337 | 2020-08-04 | Union | Georgia | 13291 | 235 | 6 |
396121 | 396121 | 2020-08-03 | Union | Georgia | 13291 | 227 | 6 |
392905 | 392905 | 2020-08-02 | Union | Georgia | 13291 | 218 | 6 |
389688 | 389688 | 2020-08-01 | Union | Georgia | 13291 | 205 | 6 |
386471 | 386471 | 2020-07-31 | Union | Georgia | 13291 | 197 | 6 |
383253 | 383253 | 2020-07-30 | Union | Georgia | 13291 | 197 | 6 |
380036 | 380036 | 2020-07-29 | Union | Georgia | 13291 | 184 | 6 |
376819 | 376819 | 2020-07-28 | Union | Georgia | 13291 | 180 | 6 |
373605 | 373605 | 2020-07-27 | Union | Georgia | 13291 | 176 | 6 |
370393 | 370393 | 2020-07-26 | Union | Georgia | 13291 | 174 | 6 |
367183 | 367183 | 2020-07-25 | Union | Georgia | 13291 | 167 | 6 |
363976 | 363976 | 2020-07-24 | Union | Georgia | 13291 | 162 | 5 |
360769 | 360769 | 2020-07-23 | Union | Georgia | 13291 | 151 | 4 |
357564 | 357564 | 2020-07-22 | Union | Georgia | 13291 | 147 | 4 |
354361 | 354361 | 2020-07-21 | Union | Georgia | 13291 | 144 | 5 |
351159 | 351159 | 2020-07-20 | Union | Georgia | 13291 | 137 | 4 |
347958 | 347958 | 2020-07-19 | Union | Georgia | 13291 | 136 | 4 |
344758 | 344758 | 2020-07-18 | Union | Georgia | 13291 | 135 | 4 |
341559 | 341559 | 2020-07-17 | Union | Georgia | 13291 | 134 | 4 |
338362 | 338362 | 2020-07-16 | Union | Georgia | 13291 | 127 | 4 |
335167 | 335167 | 2020-07-15 | Union | Georgia | 13291 | 123 | 4 |
331974 | 331974 | 2020-07-14 | Union | Georgia | 13291 | 120 | 4 |
328787 | 328787 | 2020-07-13 | Union | Georgia | 13291 | 115 | 4 |
325601 | 325601 | 2020-07-12 | Union | Georgia | 13291 | 109 | 4 |
322420 | 322420 | 2020-07-11 | Union | Georgia | 13291 | 99 | 4 |
319241 | 319241 | 2020-07-10 | Union | Georgia | 13291 | 98 | 3 |
316068 | 316068 | 2020-07-09 | Union | Georgia | 13291 | 92 | 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);