ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
124,889 rows where state = "Georgia" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 13121 803
- 13233 799
- 13067 798
- 13135 798
- 13057 797
- 13089 796
- 13113 796
- 13115 796
- 13049 795
- 13015 794
- 13177 794
- 13185 794
- 13129 792
- 13151 792
- 13077 791
- 13059 790
- 13063 790
- 13095 790
- 13217 790
- 13117 789
- 13139 789
- 13223 789
- 13285 789
- 13245 788
- 13313 788
- 13073 787
- 13153 787
- 13021 786
- 13099 786
- 13103 786
- …
county >30
- Fulton 803
- Polk 799
- Cobb 798
- Gwinnett 798
- Cherokee 797
- DeKalb 796
- Fayette 796
- Floyd 796
- Charlton 795
- Bartow 794
- Lee 794
- Lowndes 794
- Gordon 792
- Henry 792
- Coweta 791
- Clarke 790
- Clayton 790
- Dougherty 790
- Newton 790
- Forsyth 789
- Hall 789
- Paulding 789
- Troup 789
- Richmond 788
- Whitfield 788
- Columbia 787
- Houston 787
- Bibb 786
- Early 786
- Effingham 786
- …
state 1
- Georgia · 124,789 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
312750 | 312750 | 2020-07-08 | Appling | Georgia | 13001 | 310 | 14 |
315925 | 315925 | 2020-07-09 | Appling | Georgia | 13001 | 313 | 14 |
319098 | 319098 | 2020-07-10 | Appling | Georgia | 13001 | 317 | 14 |
322277 | 322277 | 2020-07-11 | Appling | Georgia | 13001 | 340 | 14 |
325458 | 325458 | 2020-07-12 | Appling | Georgia | 13001 | 343 | 14 |
328644 | 328644 | 2020-07-13 | Appling | Georgia | 13001 | 349 | 14 |
331831 | 331831 | 2020-07-14 | Appling | Georgia | 13001 | 370 | 15 |
335024 | 335024 | 2020-07-15 | Appling | Georgia | 13001 | 376 | 15 |
338219 | 338219 | 2020-07-16 | Appling | Georgia | 13001 | 389 | 15 |
341416 | 341416 | 2020-07-17 | Appling | Georgia | 13001 | 402 | 15 |
344615 | 344615 | 2020-07-18 | Appling | Georgia | 13001 | 411 | 15 |
347815 | 347815 | 2020-07-19 | Appling | Georgia | 13001 | 417 | 15 |
351016 | 351016 | 2020-07-20 | Appling | Georgia | 13001 | 437 | 15 |
354218 | 354218 | 2020-07-21 | Appling | Georgia | 13001 | 449 | 15 |
357421 | 357421 | 2020-07-22 | Appling | Georgia | 13001 | 455 | 16 |
360626 | 360626 | 2020-07-23 | Appling | Georgia | 13001 | 465 | 16 |
363833 | 363833 | 2020-07-24 | Appling | Georgia | 13001 | 475 | 16 |
367040 | 367040 | 2020-07-25 | Appling | Georgia | 13001 | 486 | 16 |
370250 | 370250 | 2020-07-26 | Appling | Georgia | 13001 | 491 | 16 |
373462 | 373462 | 2020-07-27 | Appling | Georgia | 13001 | 518 | 16 |
376676 | 376676 | 2020-07-28 | Appling | Georgia | 13001 | 530 | 16 |
379893 | 379893 | 2020-07-29 | Appling | Georgia | 13001 | 536 | 16 |
383110 | 383110 | 2020-07-30 | Appling | Georgia | 13001 | 544 | 16 |
386328 | 386328 | 2020-07-31 | Appling | Georgia | 13001 | 555 | 16 |
389545 | 389545 | 2020-08-01 | Appling | Georgia | 13001 | 586 | 16 |
392762 | 392762 | 2020-08-02 | Appling | Georgia | 13001 | 594 | 16 |
395978 | 395978 | 2020-08-03 | Appling | Georgia | 13001 | 602 | 16 |
399194 | 399194 | 2020-08-04 | Appling | Georgia | 13001 | 601 | 17 |
402410 | 402410 | 2020-08-05 | Appling | Georgia | 13001 | 615 | 19 |
405628 | 405628 | 2020-08-06 | Appling | Georgia | 13001 | 619 | 19 |
408848 | 408848 | 2020-08-07 | Appling | Georgia | 13001 | 631 | 19 |
412067 | 412067 | 2020-08-08 | Appling | Georgia | 13001 | 645 | 19 |
415287 | 415287 | 2020-08-09 | Appling | Georgia | 13001 | 671 | 19 |
418508 | 418508 | 2020-08-10 | Appling | Georgia | 13001 | 678 | 19 |
421729 | 421729 | 2020-08-11 | Appling | Georgia | 13001 | 689 | 19 |
424950 | 424950 | 2020-08-12 | Appling | Georgia | 13001 | 721 | 19 |
428174 | 428174 | 2020-08-13 | Appling | Georgia | 13001 | 733 | 19 |
431402 | 431402 | 2020-08-14 | Appling | Georgia | 13001 | 765 | 19 |
434627 | 434627 | 2020-08-15 | Appling | Georgia | 13001 | 778 | 19 |
437853 | 437853 | 2020-08-16 | Appling | Georgia | 13001 | 789 | 19 |
441079 | 441079 | 2020-08-17 | Appling | Georgia | 13001 | 804 | 19 |
444305 | 444305 | 2020-08-18 | Appling | Georgia | 13001 | 814 | 19 |
447532 | 447532 | 2020-08-19 | Appling | Georgia | 13001 | 822 | 19 |
450760 | 450760 | 2020-08-20 | Appling | Georgia | 13001 | 833 | 20 |
453988 | 453988 | 2020-08-21 | Appling | Georgia | 13001 | 840 | 21 |
457216 | 457216 | 2020-08-22 | Appling | Georgia | 13001 | 852 | 21 |
460443 | 460443 | 2020-08-23 | Appling | Georgia | 13001 | 857 | 21 |
463672 | 463672 | 2020-08-24 | Appling | Georgia | 13001 | 853 | 22 |
466901 | 466901 | 2020-08-25 | Appling | Georgia | 13001 | 856 | 23 |
470130 | 470130 | 2020-08-26 | Appling | Georgia | 13001 | 862 | 23 |
473362 | 473362 | 2020-08-27 | Appling | Georgia | 13001 | 869 | 23 |
476595 | 476595 | 2020-08-28 | Appling | Georgia | 13001 | 881 | 23 |
479828 | 479828 | 2020-08-29 | Appling | Georgia | 13001 | 883 | 23 |
483062 | 483062 | 2020-08-30 | Appling | Georgia | 13001 | 885 | 23 |
486297 | 486297 | 2020-08-31 | Appling | Georgia | 13001 | 886 | 23 |
489530 | 489530 | 2020-09-01 | Appling | Georgia | 13001 | 892 | 23 |
492763 | 492763 | 2020-09-02 | Appling | Georgia | 13001 | 899 | 23 |
495997 | 495997 | 2020-09-03 | Appling | Georgia | 13001 | 906 | 23 |
499230 | 499230 | 2020-09-04 | Appling | Georgia | 13001 | 920 | 23 |
502464 | 502464 | 2020-09-05 | Appling | Georgia | 13001 | 930 | 23 |
505698 | 505698 | 2020-09-06 | Appling | Georgia | 13001 | 931 | 24 |
508930 | 508930 | 2020-09-07 | Appling | Georgia | 13001 | 931 | 24 |
512163 | 512163 | 2020-09-08 | Appling | Georgia | 13001 | 937 | 25 |
515396 | 515396 | 2020-09-09 | Appling | Georgia | 13001 | 941 | 25 |
518631 | 518631 | 2020-09-10 | Appling | Georgia | 13001 | 948 | 25 |
521868 | 521868 | 2020-09-11 | Appling | Georgia | 13001 | 950 | 25 |
525104 | 525104 | 2020-09-12 | Appling | Georgia | 13001 | 956 | 26 |
528340 | 528340 | 2020-09-13 | Appling | Georgia | 13001 | 960 | 26 |
531577 | 531577 | 2020-09-14 | Appling | Georgia | 13001 | 964 | 26 |
534812 | 534812 | 2020-09-15 | Appling | Georgia | 13001 | 965 | 26 |
538048 | 538048 | 2020-09-16 | Appling | Georgia | 13001 | 967 | 26 |
541285 | 541285 | 2020-09-17 | Appling | Georgia | 13001 | 975 | 26 |
544521 | 544521 | 2020-09-18 | Appling | Georgia | 13001 | 991 | 26 |
547759 | 547759 | 2020-09-19 | Appling | Georgia | 13001 | 1001 | 26 |
550998 | 550998 | 2020-09-20 | Appling | Georgia | 13001 | 1007 | 26 |
554237 | 554237 | 2020-09-21 | Appling | Georgia | 13001 | 1010 | 26 |
557474 | 557474 | 2020-09-22 | Appling | Georgia | 13001 | 1011 | 26 |
560710 | 560710 | 2020-09-23 | Appling | Georgia | 13001 | 1015 | 26 |
563950 | 563950 | 2020-09-24 | Appling | Georgia | 13001 | 1016 | 26 |
567190 | 567190 | 2020-09-25 | Appling | Georgia | 13001 | 1021 | 26 |
570432 | 570432 | 2020-09-26 | Appling | Georgia | 13001 | 1022 | 28 |
573674 | 573674 | 2020-09-27 | Appling | Georgia | 13001 | 1028 | 28 |
576917 | 576917 | 2020-09-28 | Appling | Georgia | 13001 | 1030 | 28 |
580158 | 580158 | 2020-09-29 | Appling | Georgia | 13001 | 1035 | 29 |
583397 | 583397 | 2020-09-30 | Appling | Georgia | 13001 | 1040 | 29 |
586637 | 586637 | 2020-10-01 | Appling | Georgia | 13001 | 1043 | 29 |
589878 | 589878 | 2020-10-02 | Appling | Georgia | 13001 | 1054 | 29 |
593118 | 593118 | 2020-10-03 | Appling | Georgia | 13001 | 1057 | 30 |
596360 | 596360 | 2020-10-04 | Appling | Georgia | 13001 | 1061 | 30 |
599603 | 599603 | 2020-10-05 | Appling | Georgia | 13001 | 1141 | 30 |
602846 | 602846 | 2020-10-06 | Appling | Georgia | 13001 | 1146 | 33 |
606088 | 606088 | 2020-10-07 | Appling | Georgia | 13001 | 1154 | 33 |
609331 | 609331 | 2020-10-08 | Appling | Georgia | 13001 | 1161 | 33 |
612573 | 612573 | 2020-10-09 | Appling | Georgia | 13001 | 1167 | 34 |
615814 | 615814 | 2020-10-10 | Appling | Georgia | 13001 | 1173 | 34 |
619056 | 619056 | 2020-10-11 | Appling | Georgia | 13001 | 1180 | 34 |
622299 | 622299 | 2020-10-12 | Appling | Georgia | 13001 | 1182 | 34 |
625542 | 625542 | 2020-10-13 | Appling | Georgia | 13001 | 1182 | 34 |
628785 | 628785 | 2020-10-14 | Appling | Georgia | 13001 | 1183 | 34 |
632029 | 632029 | 2020-10-15 | Appling | Georgia | 13001 | 1191 | 34 |
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);