ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Gordon" sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1706 | 1706 | 2020-03-13 | Gordon | Georgia | 13129 | 2 | 0 |
2029 | 2029 | 2020-03-14 | Gordon | Georgia | 13129 | 2 | 0 |
2416 | 2416 | 2020-03-15 | Gordon | Georgia | 13129 | 2 | 0 |
2854 | 2854 | 2020-03-16 | Gordon | Georgia | 13129 | 2 | 0 |
3339 | 3339 | 2020-03-17 | Gordon | Georgia | 13129 | 2 | 0 |
3900 | 3900 | 2020-03-18 | Gordon | Georgia | 13129 | 3 | 0 |
4573 | 4573 | 2020-03-19 | Gordon | Georgia | 13129 | 3 | 0 |
5357 | 5357 | 2020-03-20 | Gordon | Georgia | 13129 | 3 | 0 |
6290 | 6290 | 2020-03-21 | Gordon | Georgia | 13129 | 4 | 0 |
7336 | 7336 | 2020-03-22 | Gordon | Georgia | 13129 | 4 | 0 |
8484 | 8484 | 2020-03-23 | Gordon | Georgia | 13129 | 6 | 0 |
9736 | 9736 | 2020-03-24 | Gordon | Georgia | 13129 | 8 | 1 |
11113 | 11113 | 2020-03-25 | Gordon | Georgia | 13129 | 9 | 1 |
12663 | 12663 | 2020-03-26 | Gordon | Georgia | 13129 | 9 | 1 |
14335 | 14335 | 2020-03-27 | Gordon | Georgia | 13129 | 12 | 1 |
16121 | 16121 | 2020-03-28 | Gordon | Georgia | 13129 | 14 | 1 |
18018 | 18018 | 2020-03-29 | Gordon | Georgia | 13129 | 14 | 1 |
20008 | 20008 | 2020-03-30 | Gordon | Georgia | 13129 | 15 | 1 |
22088 | 22088 | 2020-03-31 | Gordon | Georgia | 13129 | 16 | 1 |
24251 | 24251 | 2020-04-01 | Gordon | Georgia | 13129 | 18 | 1 |
26482 | 26482 | 2020-04-02 | Gordon | Georgia | 13129 | 20 | 1 |
28786 | 28786 | 2020-04-03 | Gordon | Georgia | 13129 | 21 | 2 |
31146 | 31146 | 2020-04-04 | Gordon | Georgia | 13129 | 23 | 2 |
33553 | 33553 | 2020-04-05 | Gordon | Georgia | 13129 | 23 | 2 |
36002 | 36002 | 2020-04-06 | Gordon | Georgia | 13129 | 25 | 3 |
38494 | 38494 | 2020-04-07 | Gordon | Georgia | 13129 | 25 | 3 |
41038 | 41038 | 2020-04-08 | Gordon | Georgia | 13129 | 26 | 3 |
43612 | 43612 | 2020-04-09 | Gordon | Georgia | 13129 | 27 | 3 |
46214 | 46214 | 2020-04-10 | Gordon | Georgia | 13129 | 29 | 3 |
48844 | 48844 | 2020-04-11 | Gordon | Georgia | 13129 | 33 | 3 |
51506 | 51506 | 2020-04-12 | Gordon | Georgia | 13129 | 38 | 3 |
54186 | 54186 | 2020-04-13 | Gordon | Georgia | 13129 | 41 | 3 |
56878 | 56878 | 2020-04-14 | Gordon | Georgia | 13129 | 45 | 3 |
59585 | 59585 | 2020-04-15 | Gordon | Georgia | 13129 | 48 | 5 |
62305 | 62305 | 2020-04-16 | Gordon | Georgia | 13129 | 50 | 5 |
65038 | 65038 | 2020-04-17 | Gordon | Georgia | 13129 | 55 | 5 |
67786 | 67786 | 2020-04-18 | Gordon | Georgia | 13129 | 58 | 5 |
70548 | 70548 | 2020-04-19 | Gordon | Georgia | 13129 | 64 | 5 |
73317 | 73317 | 2020-04-20 | Gordon | Georgia | 13129 | 64 | 6 |
76093 | 76093 | 2020-04-21 | Gordon | Georgia | 13129 | 67 | 7 |
78877 | 78877 | 2020-04-22 | Gordon | Georgia | 13129 | 70 | 8 |
81670 | 81670 | 2020-04-23 | Gordon | Georgia | 13129 | 73 | 10 |
84470 | 84470 | 2020-04-24 | Gordon | Georgia | 13129 | 75 | 10 |
87279 | 87279 | 2020-04-25 | Gordon | Georgia | 13129 | 81 | 10 |
90095 | 90095 | 2020-04-26 | Gordon | Georgia | 13129 | 81 | 10 |
92914 | 92914 | 2020-04-27 | Gordon | Georgia | 13129 | 81 | 12 |
95746 | 95746 | 2020-04-28 | Gordon | Georgia | 13129 | 86 | 12 |
98591 | 98591 | 2020-04-29 | Gordon | Georgia | 13129 | 91 | 12 |
101441 | 101441 | 2020-04-30 | Gordon | Georgia | 13129 | 92 | 12 |
104296 | 104296 | 2020-05-01 | Gordon | Georgia | 13129 | 113 | 12 |
107161 | 107161 | 2020-05-02 | Gordon | Georgia | 13129 | 113 | 12 |
110030 | 110030 | 2020-05-03 | Gordon | Georgia | 13129 | 113 | 12 |
112905 | 112905 | 2020-05-04 | Gordon | Georgia | 13129 | 116 | 13 |
115788 | 115788 | 2020-05-05 | Gordon | Georgia | 13129 | 117 | 13 |
118748 | 118748 | 2020-05-06 | Gordon | Georgia | 13129 | 118 | 14 |
121718 | 121718 | 2020-05-07 | Gordon | Georgia | 13129 | 120 | 15 |
124697 | 124697 | 2020-05-08 | Gordon | Georgia | 13129 | 120 | 15 |
127684 | 127684 | 2020-05-09 | Gordon | Georgia | 13129 | 121 | 15 |
130675 | 130675 | 2020-05-10 | Gordon | Georgia | 13129 | 122 | 15 |
133666 | 133666 | 2020-05-11 | Gordon | Georgia | 13129 | 124 | 16 |
136655 | 136655 | 2020-05-12 | Gordon | Georgia | 13129 | 125 | 16 |
139646 | 139646 | 2020-05-13 | Gordon | Georgia | 13129 | 124 | 16 |
142642 | 142642 | 2020-05-14 | Gordon | Georgia | 13129 | 124 | 15 |
145642 | 145642 | 2020-05-15 | Gordon | Georgia | 13129 | 125 | 15 |
148645 | 148645 | 2020-05-16 | Gordon | Georgia | 13129 | 127 | 15 |
151654 | 151654 | 2020-05-17 | Gordon | Georgia | 13129 | 128 | 15 |
154666 | 154666 | 2020-05-18 | Gordon | Georgia | 13129 | 128 | 15 |
157682 | 157682 | 2020-05-19 | Gordon | Georgia | 13129 | 132 | 15 |
160708 | 160708 | 2020-05-20 | Gordon | Georgia | 13129 | 134 | 15 |
163736 | 163736 | 2020-05-21 | Gordon | Georgia | 13129 | 135 | 15 |
166769 | 166769 | 2020-05-22 | Gordon | Georgia | 13129 | 136 | 15 |
169806 | 169806 | 2020-05-23 | Gordon | Georgia | 13129 | 138 | 15 |
172847 | 172847 | 2020-05-24 | Gordon | Georgia | 13129 | 138 | 15 |
175890 | 175890 | 2020-05-25 | Gordon | Georgia | 13129 | 138 | 15 |
178934 | 178934 | 2020-05-26 | Gordon | Georgia | 13129 | 137 | 15 |
181978 | 181978 | 2020-05-27 | Gordon | Georgia | 13129 | 142 | 15 |
185032 | 185032 | 2020-05-28 | Gordon | Georgia | 13129 | 148 | 15 |
188088 | 188088 | 2020-05-29 | Gordon | Georgia | 13129 | 152 | 15 |
191153 | 191153 | 2020-05-30 | Gordon | Georgia | 13129 | 160 | 16 |
194220 | 194220 | 2020-05-31 | Gordon | Georgia | 13129 | 163 | 16 |
197290 | 197290 | 2020-06-01 | Gordon | Georgia | 13129 | 164 | 16 |
200363 | 200363 | 2020-06-02 | Gordon | Georgia | 13129 | 166 | 16 |
203439 | 203439 | 2020-06-03 | Gordon | Georgia | 13129 | 170 | 16 |
206519 | 206519 | 2020-06-04 | Gordon | Georgia | 13129 | 181 | 16 |
209600 | 209600 | 2020-06-05 | Gordon | Georgia | 13129 | 194 | 16 |
212685 | 212685 | 2020-06-06 | Gordon | Georgia | 13129 | 195 | 16 |
215772 | 215772 | 2020-06-07 | Gordon | Georgia | 13129 | 202 | 16 |
218863 | 218863 | 2020-06-08 | Gordon | Georgia | 13129 | 203 | 16 |
221958 | 221958 | 2020-06-09 | Gordon | Georgia | 13129 | 209 | 16 |
225053 | 225053 | 2020-06-10 | Gordon | Georgia | 13129 | 219 | 17 |
228155 | 228155 | 2020-06-11 | Gordon | Georgia | 13129 | 234 | 17 |
231258 | 231258 | 2020-06-12 | Gordon | Georgia | 13129 | 240 | 18 |
234364 | 234364 | 2020-06-13 | Gordon | Georgia | 13129 | 247 | 18 |
237471 | 237471 | 2020-06-14 | Gordon | Georgia | 13129 | 253 | 18 |
240579 | 240579 | 2020-06-15 | Gordon | Georgia | 13129 | 256 | 18 |
243690 | 243690 | 2020-06-16 | Gordon | Georgia | 13129 | 260 | 18 |
246803 | 246803 | 2020-06-17 | Gordon | Georgia | 13129 | 267 | 18 |
249915 | 249915 | 2020-06-18 | Gordon | Georgia | 13129 | 273 | 18 |
253030 | 253030 | 2020-06-19 | Gordon | Georgia | 13129 | 283 | 18 |
256149 | 256149 | 2020-06-20 | Gordon | Georgia | 13129 | 287 | 18 |
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);