ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Colquitt" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1073403 | 1073403 | 2021-02-28 | Colquitt | Georgia | 13071 | 4428 | 101 |
1070157 | 1070157 | 2021-02-27 | Colquitt | Georgia | 13071 | 4424 | 101 |
1066912 | 1066912 | 2021-02-26 | Colquitt | Georgia | 13071 | 4409 | 100 |
1063667 | 1063667 | 2021-02-25 | Colquitt | Georgia | 13071 | 4397 | 100 |
1060422 | 1060422 | 2021-02-24 | Colquitt | Georgia | 13071 | 4381 | 100 |
1057176 | 1057176 | 2021-02-23 | Colquitt | Georgia | 13071 | 4360 | 99 |
1053930 | 1053930 | 2021-02-22 | Colquitt | Georgia | 13071 | 4332 | 97 |
1050683 | 1050683 | 2021-02-21 | Colquitt | Georgia | 13071 | 4332 | 96 |
1047436 | 1047436 | 2021-02-20 | Colquitt | Georgia | 13071 | 4324 | 96 |
1044191 | 1044191 | 2021-02-19 | Colquitt | Georgia | 13071 | 4315 | 93 |
1040946 | 1040946 | 2021-02-18 | Colquitt | Georgia | 13071 | 4296 | 91 |
1037701 | 1037701 | 2021-02-17 | Colquitt | Georgia | 13071 | 4282 | 90 |
1034456 | 1034456 | 2021-02-16 | Colquitt | Georgia | 13071 | 4265 | 88 |
1031210 | 1031210 | 2021-02-15 | Colquitt | Georgia | 13071 | 4229 | 86 |
1027963 | 1027963 | 2021-02-14 | Colquitt | Georgia | 13071 | 4227 | 85 |
1024718 | 1024718 | 2021-02-13 | Colquitt | Georgia | 13071 | 4225 | 84 |
1021473 | 1021473 | 2021-02-12 | Colquitt | Georgia | 13071 | 4208 | 83 |
1018228 | 1018228 | 2021-02-11 | Colquitt | Georgia | 13071 | 4201 | 81 |
1014983 | 1014983 | 2021-02-10 | Colquitt | Georgia | 13071 | 4193 | 81 |
1011738 | 1011738 | 2021-02-09 | Colquitt | Georgia | 13071 | 4180 | 80 |
1008492 | 1008492 | 2021-02-08 | Colquitt | Georgia | 13071 | 4165 | 79 |
1005246 | 1005246 | 2021-02-07 | Colquitt | Georgia | 13071 | 4162 | 79 |
1002000 | 1002000 | 2021-02-06 | Colquitt | Georgia | 13071 | 4159 | 79 |
998754 | 998754 | 2021-02-05 | Colquitt | Georgia | 13071 | 4147 | 78 |
995508 | 995508 | 2021-02-04 | Colquitt | Georgia | 13071 | 4135 | 78 |
992262 | 992262 | 2021-02-03 | Colquitt | Georgia | 13071 | 4118 | 76 |
989016 | 989016 | 2021-02-02 | Colquitt | Georgia | 13071 | 4100 | 76 |
985769 | 985769 | 2021-02-01 | Colquitt | Georgia | 13071 | 4080 | 75 |
982522 | 982522 | 2021-01-31 | Colquitt | Georgia | 13071 | 4077 | 75 |
979276 | 979276 | 2021-01-30 | Colquitt | Georgia | 13071 | 4069 | 75 |
976031 | 976031 | 2021-01-29 | Colquitt | Georgia | 13071 | 4047 | 74 |
972786 | 972786 | 2021-01-28 | Colquitt | Georgia | 13071 | 3945 | 73 |
969541 | 969541 | 2021-01-27 | Colquitt | Georgia | 13071 | 3932 | 71 |
966297 | 966297 | 2021-01-26 | Colquitt | Georgia | 13071 | 3894 | 70 |
963052 | 963052 | 2021-01-25 | Colquitt | Georgia | 13071 | 3868 | 66 |
959807 | 959807 | 2021-01-24 | Colquitt | Georgia | 13071 | 3867 | 65 |
956561 | 956561 | 2021-01-23 | Colquitt | Georgia | 13071 | 3861 | 65 |
953316 | 953316 | 2021-01-22 | Colquitt | Georgia | 13071 | 3820 | 64 |
950071 | 950071 | 2021-01-21 | Colquitt | Georgia | 13071 | 3766 | 64 |
946825 | 946825 | 2021-01-20 | Colquitt | Georgia | 13071 | 3743 | 64 |
943578 | 943578 | 2021-01-19 | Colquitt | Georgia | 13071 | 3717 | 58 |
940333 | 940333 | 2021-01-18 | Colquitt | Georgia | 13071 | 3703 | 56 |
937088 | 937088 | 2021-01-17 | Colquitt | Georgia | 13071 | 3698 | 56 |
933843 | 933843 | 2021-01-16 | Colquitt | Georgia | 13071 | 3669 | 56 |
930598 | 930598 | 2021-01-15 | Colquitt | Georgia | 13071 | 3648 | 56 |
927353 | 927353 | 2021-01-14 | Colquitt | Georgia | 13071 | 3605 | 56 |
924107 | 924107 | 2021-01-13 | Colquitt | Georgia | 13071 | 3555 | 56 |
920862 | 920862 | 2021-01-12 | Colquitt | Georgia | 13071 | 3534 | 56 |
917617 | 917617 | 2021-01-11 | Colquitt | Georgia | 13071 | 3492 | 55 |
914372 | 914372 | 2021-01-10 | Colquitt | Georgia | 13071 | 3479 | 55 |
911127 | 911127 | 2021-01-09 | Colquitt | Georgia | 13071 | 3423 | 55 |
907882 | 907882 | 2021-01-08 | Colquitt | Georgia | 13071 | 3408 | 54 |
904636 | 904636 | 2021-01-07 | Colquitt | Georgia | 13071 | 3364 | 53 |
901391 | 901391 | 2021-01-06 | Colquitt | Georgia | 13071 | 3351 | 53 |
898146 | 898146 | 2021-01-05 | Colquitt | Georgia | 13071 | 3301 | 53 |
894901 | 894901 | 2021-01-04 | Colquitt | Georgia | 13071 | 3239 | 53 |
891654 | 891654 | 2021-01-03 | Colquitt | Georgia | 13071 | 3230 | 53 |
888407 | 888407 | 2021-01-02 | Colquitt | Georgia | 13071 | 3211 | 53 |
885162 | 885162 | 2021-01-01 | Colquitt | Georgia | 13071 | 3194 | 53 |
881917 | 881917 | 2020-12-31 | Colquitt | Georgia | 13071 | 3151 | 53 |
878672 | 878672 | 2020-12-30 | Colquitt | Georgia | 13071 | 3138 | 53 |
875427 | 875427 | 2020-12-29 | Colquitt | Georgia | 13071 | 3096 | 53 |
872182 | 872182 | 2020-12-28 | Colquitt | Georgia | 13071 | 3039 | 52 |
868937 | 868937 | 2020-12-27 | Colquitt | Georgia | 13071 | 3032 | 52 |
865692 | 865692 | 2020-12-26 | Colquitt | Georgia | 13071 | 3030 | 52 |
862447 | 862447 | 2020-12-25 | Colquitt | Georgia | 13071 | 3024 | 52 |
859202 | 859202 | 2020-12-24 | Colquitt | Georgia | 13071 | 3005 | 52 |
855957 | 855957 | 2020-12-23 | Colquitt | Georgia | 13071 | 2981 | 52 |
852712 | 852712 | 2020-12-22 | Colquitt | Georgia | 13071 | 2964 | 52 |
849467 | 849467 | 2020-12-21 | Colquitt | Georgia | 13071 | 2935 | 52 |
846222 | 846222 | 2020-12-20 | Colquitt | Georgia | 13071 | 2932 | 52 |
842976 | 842976 | 2020-12-19 | Colquitt | Georgia | 13071 | 2925 | 52 |
839731 | 839731 | 2020-12-18 | Colquitt | Georgia | 13071 | 2906 | 51 |
836486 | 836486 | 2020-12-17 | Colquitt | Georgia | 13071 | 2885 | 51 |
833240 | 833240 | 2020-12-16 | Colquitt | Georgia | 13071 | 2859 | 51 |
829993 | 829993 | 2020-12-15 | Colquitt | Georgia | 13071 | 2848 | 51 |
826747 | 826747 | 2020-12-14 | Colquitt | Georgia | 13071 | 2825 | 52 |
823500 | 823500 | 2020-12-13 | Colquitt | Georgia | 13071 | 2822 | 52 |
820254 | 820254 | 2020-12-12 | Colquitt | Georgia | 13071 | 2806 | 52 |
817008 | 817008 | 2020-12-11 | Colquitt | Georgia | 13071 | 2801 | 51 |
813762 | 813762 | 2020-12-10 | Colquitt | Georgia | 13071 | 2791 | 51 |
810518 | 810518 | 2020-12-09 | Colquitt | Georgia | 13071 | 2766 | 51 |
807273 | 807273 | 2020-12-08 | Colquitt | Georgia | 13071 | 2752 | 51 |
804028 | 804028 | 2020-12-07 | Colquitt | Georgia | 13071 | 2730 | 51 |
800783 | 800783 | 2020-12-06 | Colquitt | Georgia | 13071 | 2711 | 51 |
797538 | 797538 | 2020-12-05 | Colquitt | Georgia | 13071 | 2693 | 49 |
794293 | 794293 | 2020-12-04 | Colquitt | Georgia | 13071 | 2678 | 48 |
791048 | 791048 | 2020-12-03 | Colquitt | Georgia | 13071 | 2662 | 48 |
787803 | 787803 | 2020-12-02 | Colquitt | Georgia | 13071 | 2632 | 47 |
784559 | 784559 | 2020-12-01 | Colquitt | Georgia | 13071 | 2603 | 47 |
781314 | 781314 | 2020-11-30 | Colquitt | Georgia | 13071 | 2587 | 47 |
778068 | 778068 | 2020-11-29 | Colquitt | Georgia | 13071 | 2586 | 47 |
774823 | 774823 | 2020-11-28 | Colquitt | Georgia | 13071 | 2586 | 47 |
771578 | 771578 | 2020-11-27 | Colquitt | Georgia | 13071 | 2583 | 47 |
768333 | 768333 | 2020-11-26 | Colquitt | Georgia | 13071 | 2579 | 47 |
765087 | 765087 | 2020-11-25 | Colquitt | Georgia | 13071 | 2577 | 47 |
761842 | 761842 | 2020-11-24 | Colquitt | Georgia | 13071 | 2572 | 47 |
758597 | 758597 | 2020-11-23 | Colquitt | Georgia | 13071 | 2573 | 47 |
755350 | 755350 | 2020-11-22 | Colquitt | Georgia | 13071 | 2578 | 47 |
752104 | 752104 | 2020-11-21 | Colquitt | Georgia | 13071 | 2598 | 47 |
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);