ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 13103 and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635325 | 635325 | 2020-10-16 | Effingham | Georgia | 13103 | 1684 | 28 |
632079 | 632079 | 2020-10-15 | Effingham | Georgia | 13103 | 1667 | 28 |
628835 | 628835 | 2020-10-14 | Effingham | Georgia | 13103 | 1655 | 28 |
625592 | 625592 | 2020-10-13 | Effingham | Georgia | 13103 | 1643 | 28 |
622349 | 622349 | 2020-10-12 | Effingham | Georgia | 13103 | 1630 | 28 |
619106 | 619106 | 2020-10-11 | Effingham | Georgia | 13103 | 1621 | 28 |
615864 | 615864 | 2020-10-10 | Effingham | Georgia | 13103 | 1587 | 28 |
612623 | 612623 | 2020-10-09 | Effingham | Georgia | 13103 | 1576 | 28 |
609381 | 609381 | 2020-10-08 | Effingham | Georgia | 13103 | 1566 | 27 |
606138 | 606138 | 2020-10-07 | Effingham | Georgia | 13103 | 1557 | 26 |
602896 | 602896 | 2020-10-06 | Effingham | Georgia | 13103 | 1549 | 26 |
599653 | 599653 | 2020-10-05 | Effingham | Georgia | 13103 | 1536 | 26 |
596410 | 596410 | 2020-10-04 | Effingham | Georgia | 13103 | 1506 | 26 |
593168 | 593168 | 2020-10-03 | Effingham | Georgia | 13103 | 1497 | 26 |
589928 | 589928 | 2020-10-02 | Effingham | Georgia | 13103 | 1484 | 25 |
586687 | 586687 | 2020-10-01 | Effingham | Georgia | 13103 | 1464 | 24 |
583447 | 583447 | 2020-09-30 | Effingham | Georgia | 13103 | 1453 | 23 |
580208 | 580208 | 2020-09-29 | Effingham | Georgia | 13103 | 1445 | 23 |
576967 | 576967 | 2020-09-28 | Effingham | Georgia | 13103 | 1439 | 23 |
573724 | 573724 | 2020-09-27 | Effingham | Georgia | 13103 | 1439 | 23 |
570482 | 570482 | 2020-09-26 | Effingham | Georgia | 13103 | 1431 | 23 |
567240 | 567240 | 2020-09-25 | Effingham | Georgia | 13103 | 1423 | 23 |
564000 | 564000 | 2020-09-24 | Effingham | Georgia | 13103 | 1416 | 23 |
560760 | 560760 | 2020-09-23 | Effingham | Georgia | 13103 | 1403 | 23 |
557524 | 557524 | 2020-09-22 | Effingham | Georgia | 13103 | 1384 | 23 |
554287 | 554287 | 2020-09-21 | Effingham | Georgia | 13103 | 1380 | 23 |
551048 | 551048 | 2020-09-20 | Effingham | Georgia | 13103 | 1376 | 23 |
547809 | 547809 | 2020-09-19 | Effingham | Georgia | 13103 | 1365 | 23 |
544571 | 544571 | 2020-09-18 | Effingham | Georgia | 13103 | 1338 | 22 |
541335 | 541335 | 2020-09-17 | Effingham | Georgia | 13103 | 1333 | 21 |
538098 | 538098 | 2020-09-16 | Effingham | Georgia | 13103 | 1322 | 21 |
534862 | 534862 | 2020-09-15 | Effingham | Georgia | 13103 | 1315 | 21 |
531627 | 531627 | 2020-09-14 | Effingham | Georgia | 13103 | 1309 | 21 |
528390 | 528390 | 2020-09-13 | Effingham | Georgia | 13103 | 1291 | 21 |
525154 | 525154 | 2020-09-12 | Effingham | Georgia | 13103 | 1257 | 21 |
521918 | 521918 | 2020-09-11 | Effingham | Georgia | 13103 | 1242 | 21 |
518681 | 518681 | 2020-09-10 | Effingham | Georgia | 13103 | 1224 | 20 |
515446 | 515446 | 2020-09-09 | Effingham | Georgia | 13103 | 1209 | 20 |
512213 | 512213 | 2020-09-08 | Effingham | Georgia | 13103 | 1195 | 19 |
508980 | 508980 | 2020-09-07 | Effingham | Georgia | 13103 | 1177 | 19 |
505748 | 505748 | 2020-09-06 | Effingham | Georgia | 13103 | 1173 | 19 |
502514 | 502514 | 2020-09-05 | Effingham | Georgia | 13103 | 1152 | 18 |
499280 | 499280 | 2020-09-04 | Effingham | Georgia | 13103 | 1140 | 18 |
496047 | 496047 | 2020-09-03 | Effingham | Georgia | 13103 | 1117 | 17 |
492813 | 492813 | 2020-09-02 | Effingham | Georgia | 13103 | 1083 | 17 |
489580 | 489580 | 2020-09-01 | Effingham | Georgia | 13103 | 1080 | 17 |
486347 | 486347 | 2020-08-31 | Effingham | Georgia | 13103 | 1068 | 16 |
483112 | 483112 | 2020-08-30 | Effingham | Georgia | 13103 | 1054 | 16 |
479878 | 479878 | 2020-08-29 | Effingham | Georgia | 13103 | 1042 | 16 |
476645 | 476645 | 2020-08-28 | Effingham | Georgia | 13103 | 1029 | 15 |
473412 | 473412 | 2020-08-27 | Effingham | Georgia | 13103 | 1010 | 14 |
470180 | 470180 | 2020-08-26 | Effingham | Georgia | 13103 | 996 | 14 |
466951 | 466951 | 2020-08-25 | Effingham | Georgia | 13103 | 975 | 14 |
463722 | 463722 | 2020-08-24 | Effingham | Georgia | 13103 | 962 | 14 |
460493 | 460493 | 2020-08-23 | Effingham | Georgia | 13103 | 946 | 14 |
457266 | 457266 | 2020-08-22 | Effingham | Georgia | 13103 | 936 | 14 |
454038 | 454038 | 2020-08-21 | Effingham | Georgia | 13103 | 910 | 12 |
450810 | 450810 | 2020-08-20 | Effingham | Georgia | 13103 | 884 | 11 |
447582 | 447582 | 2020-08-19 | Effingham | Georgia | 13103 | 864 | 10 |
444355 | 444355 | 2020-08-18 | Effingham | Georgia | 13103 | 857 | 6 |
441129 | 441129 | 2020-08-17 | Effingham | Georgia | 13103 | 833 | 6 |
437903 | 437903 | 2020-08-16 | Effingham | Georgia | 13103 | 823 | 5 |
434677 | 434677 | 2020-08-15 | Effingham | Georgia | 13103 | 810 | 5 |
431452 | 431452 | 2020-08-14 | Effingham | Georgia | 13103 | 793 | 5 |
428224 | 428224 | 2020-08-13 | Effingham | Georgia | 13103 | 775 | 5 |
425000 | 425000 | 2020-08-12 | Effingham | Georgia | 13103 | 770 | 5 |
421779 | 421779 | 2020-08-11 | Effingham | Georgia | 13103 | 758 | 3 |
418558 | 418558 | 2020-08-10 | Effingham | Georgia | 13103 | 745 | 2 |
415337 | 415337 | 2020-08-09 | Effingham | Georgia | 13103 | 727 | 2 |
412117 | 412117 | 2020-08-08 | Effingham | Georgia | 13103 | 719 | 2 |
408898 | 408898 | 2020-08-07 | Effingham | Georgia | 13103 | 703 | 2 |
405678 | 405678 | 2020-08-06 | Effingham | Georgia | 13103 | 684 | 1 |
402460 | 402460 | 2020-08-05 | Effingham | Georgia | 13103 | 672 | 1 |
399244 | 399244 | 2020-08-04 | Effingham | Georgia | 13103 | 657 | 1 |
396028 | 396028 | 2020-08-03 | Effingham | Georgia | 13103 | 651 | 1 |
392812 | 392812 | 2020-08-02 | Effingham | Georgia | 13103 | 631 | 1 |
389595 | 389595 | 2020-08-01 | Effingham | Georgia | 13103 | 626 | 1 |
386378 | 386378 | 2020-07-31 | Effingham | Georgia | 13103 | 614 | 1 |
383160 | 383160 | 2020-07-30 | Effingham | Georgia | 13103 | 587 | 1 |
379943 | 379943 | 2020-07-29 | Effingham | Georgia | 13103 | 571 | 1 |
376726 | 376726 | 2020-07-28 | Effingham | Georgia | 13103 | 556 | 1 |
373512 | 373512 | 2020-07-27 | Effingham | Georgia | 13103 | 542 | 1 |
370300 | 370300 | 2020-07-26 | Effingham | Georgia | 13103 | 533 | 1 |
367090 | 367090 | 2020-07-25 | Effingham | Georgia | 13103 | 524 | 1 |
363883 | 363883 | 2020-07-24 | Effingham | Georgia | 13103 | 491 | 1 |
360676 | 360676 | 2020-07-23 | Effingham | Georgia | 13103 | 468 | 1 |
357471 | 357471 | 2020-07-22 | Effingham | Georgia | 13103 | 444 | 1 |
354268 | 354268 | 2020-07-21 | Effingham | Georgia | 13103 | 435 | 1 |
351066 | 351066 | 2020-07-20 | Effingham | Georgia | 13103 | 419 | 1 |
347865 | 347865 | 2020-07-19 | Effingham | Georgia | 13103 | 400 | 1 |
344665 | 344665 | 2020-07-18 | Effingham | Georgia | 13103 | 393 | 1 |
341466 | 341466 | 2020-07-17 | Effingham | Georgia | 13103 | 380 | 1 |
338269 | 338269 | 2020-07-16 | Effingham | Georgia | 13103 | 373 | 1 |
335074 | 335074 | 2020-07-15 | Effingham | Georgia | 13103 | 360 | 1 |
331881 | 331881 | 2020-07-14 | Effingham | Georgia | 13103 | 354 | 1 |
328694 | 328694 | 2020-07-13 | Effingham | Georgia | 13103 | 333 | 1 |
325508 | 325508 | 2020-07-12 | Effingham | Georgia | 13103 | 284 | 1 |
322327 | 322327 | 2020-07-11 | Effingham | Georgia | 13103 | 273 | 1 |
319148 | 319148 | 2020-07-10 | Effingham | Georgia | 13103 | 260 | 1 |
315975 | 315975 | 2020-07-09 | Effingham | Georgia | 13103 | 224 | 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);