ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Gwinnett" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386394 | 386394 | 2020-07-31 | Gwinnett | Georgia | 13135 | 17130 | 238 |
383176 | 383176 | 2020-07-30 | Gwinnett | Georgia | 13135 | 16711 | 228 |
379959 | 379959 | 2020-07-29 | Gwinnett | Georgia | 13135 | 16255 | 223 |
376742 | 376742 | 2020-07-28 | Gwinnett | Georgia | 13135 | 15915 | 217 |
373528 | 373528 | 2020-07-27 | Gwinnett | Georgia | 13135 | 15534 | 216 |
370316 | 370316 | 2020-07-26 | Gwinnett | Georgia | 13135 | 15315 | 216 |
367106 | 367106 | 2020-07-25 | Gwinnett | Georgia | 13135 | 15134 | 216 |
363899 | 363899 | 2020-07-24 | Gwinnett | Georgia | 13135 | 14801 | 213 |
360692 | 360692 | 2020-07-23 | Gwinnett | Georgia | 13135 | 14442 | 209 |
357487 | 357487 | 2020-07-22 | Gwinnett | Georgia | 13135 | 14099 | 209 |
354284 | 354284 | 2020-07-21 | Gwinnett | Georgia | 13135 | 13878 | 204 |
351082 | 351082 | 2020-07-20 | Gwinnett | Georgia | 13135 | 13614 | 199 |
347881 | 347881 | 2020-07-19 | Gwinnett | Georgia | 13135 | 13444 | 198 |
344681 | 344681 | 2020-07-18 | Gwinnett | Georgia | 13135 | 13234 | 197 |
341482 | 341482 | 2020-07-17 | Gwinnett | Georgia | 13135 | 12897 | 195 |
338285 | 338285 | 2020-07-16 | Gwinnett | Georgia | 13135 | 12489 | 191 |
335090 | 335090 | 2020-07-15 | Gwinnett | Georgia | 13135 | 12217 | 189 |
331897 | 331897 | 2020-07-14 | Gwinnett | Georgia | 13135 | 11882 | 187 |
328710 | 328710 | 2020-07-13 | Gwinnett | Georgia | 13135 | 11691 | 185 |
325524 | 325524 | 2020-07-12 | Gwinnett | Georgia | 13135 | 11304 | 183 |
322343 | 322343 | 2020-07-11 | Gwinnett | Georgia | 13135 | 11074 | 182 |
319164 | 319164 | 2020-07-10 | Gwinnett | Georgia | 13135 | 10741 | 178 |
315991 | 315991 | 2020-07-09 | Gwinnett | Georgia | 13135 | 10415 | 175 |
312816 | 312816 | 2020-07-08 | Gwinnett | Georgia | 13135 | 10237 | 175 |
309646 | 309646 | 2020-07-07 | Gwinnett | Georgia | 13135 | 9972 | 174 |
306478 | 306478 | 2020-07-06 | Gwinnett | Georgia | 13135 | 9787 | 174 |
303314 | 303314 | 2020-07-05 | Gwinnett | Georgia | 13135 | 9645 | 173 |
300150 | 300150 | 2020-07-04 | Gwinnett | Georgia | 13135 | 9482 | 173 |
296988 | 296988 | 2020-07-03 | Gwinnett | Georgia | 13135 | 9085 | 173 |
293832 | 293832 | 2020-07-02 | Gwinnett | Georgia | 13135 | 8619 | 173 |
290678 | 290678 | 2020-07-01 | Gwinnett | Georgia | 13135 | 8362 | 173 |
287527 | 287527 | 2020-06-30 | Gwinnett | Georgia | 13135 | 8082 | 170 |
284381 | 284381 | 2020-06-29 | Gwinnett | Georgia | 13135 | 7755 | 170 |
281235 | 281235 | 2020-06-28 | Gwinnett | Georgia | 13135 | 7685 | 169 |
278088 | 278088 | 2020-06-27 | Gwinnett | Georgia | 13135 | 7604 | 169 |
274940 | 274940 | 2020-06-26 | Gwinnett | Georgia | 13135 | 7463 | 168 |
271800 | 271800 | 2020-06-25 | Gwinnett | Georgia | 13135 | 7223 | 167 |
268664 | 268664 | 2020-06-24 | Gwinnett | Georgia | 13135 | 7036 | 164 |
265534 | 265534 | 2020-06-23 | Gwinnett | Georgia | 13135 | 6636 | 163 |
262406 | 262406 | 2020-06-22 | Gwinnett | Georgia | 13135 | 6407 | 162 |
259279 | 259279 | 2020-06-21 | Gwinnett | Georgia | 13135 | 6151 | 162 |
256152 | 256152 | 2020-06-20 | Gwinnett | Georgia | 13135 | 6043 | 162 |
253033 | 253033 | 2020-06-19 | Gwinnett | Georgia | 13135 | 5958 | 161 |
249918 | 249918 | 2020-06-18 | Gwinnett | Georgia | 13135 | 5753 | 159 |
246806 | 246806 | 2020-06-17 | Gwinnett | Georgia | 13135 | 5658 | 158 |
243693 | 243693 | 2020-06-16 | Gwinnett | Georgia | 13135 | 5451 | 156 |
240582 | 240582 | 2020-06-15 | Gwinnett | Georgia | 13135 | 5308 | 155 |
237474 | 237474 | 2020-06-14 | Gwinnett | Georgia | 13135 | 5172 | 152 |
234367 | 234367 | 2020-06-13 | Gwinnett | Georgia | 13135 | 5141 | 152 |
231261 | 231261 | 2020-06-12 | Gwinnett | Georgia | 13135 | 5089 | 152 |
228158 | 228158 | 2020-06-11 | Gwinnett | Georgia | 13135 | 4980 | 150 |
225056 | 225056 | 2020-06-10 | Gwinnett | Georgia | 13135 | 4808 | 142 |
221961 | 221961 | 2020-06-09 | Gwinnett | Georgia | 13135 | 4692 | 143 |
218866 | 218866 | 2020-06-08 | Gwinnett | Georgia | 13135 | 4598 | 139 |
215775 | 215775 | 2020-06-07 | Gwinnett | Georgia | 13135 | 4440 | 137 |
212688 | 212688 | 2020-06-06 | Gwinnett | Georgia | 13135 | 4433 | 137 |
209603 | 209603 | 2020-06-05 | Gwinnett | Georgia | 13135 | 4372 | 136 |
206522 | 206522 | 2020-06-04 | Gwinnett | Georgia | 13135 | 4267 | 135 |
203442 | 203442 | 2020-06-03 | Gwinnett | Georgia | 13135 | 4063 | 135 |
200366 | 200366 | 2020-06-02 | Gwinnett | Georgia | 13135 | 3891 | 133 |
197293 | 197293 | 2020-06-01 | Gwinnett | Georgia | 13135 | 3870 | 132 |
194223 | 194223 | 2020-05-31 | Gwinnett | Georgia | 13135 | 3780 | 128 |
191156 | 191156 | 2020-05-30 | Gwinnett | Georgia | 13135 | 3769 | 127 |
188091 | 188091 | 2020-05-29 | Gwinnett | Georgia | 13135 | 3733 | 126 |
185035 | 185035 | 2020-05-28 | Gwinnett | Georgia | 13135 | 3619 | 127 |
181981 | 181981 | 2020-05-27 | Gwinnett | Georgia | 13135 | 3480 | 126 |
178937 | 178937 | 2020-05-26 | Gwinnett | Georgia | 13135 | 3307 | 125 |
175893 | 175893 | 2020-05-25 | Gwinnett | Georgia | 13135 | 3198 | 121 |
172850 | 172850 | 2020-05-24 | Gwinnett | Georgia | 13135 | 3056 | 122 |
169809 | 169809 | 2020-05-23 | Gwinnett | Georgia | 13135 | 2997 | 121 |
166772 | 166772 | 2020-05-22 | Gwinnett | Georgia | 13135 | 2961 | 121 |
163739 | 163739 | 2020-05-21 | Gwinnett | Georgia | 13135 | 2882 | 121 |
160711 | 160711 | 2020-05-20 | Gwinnett | Georgia | 13135 | 2820 | 117 |
157685 | 157685 | 2020-05-19 | Gwinnett | Georgia | 13135 | 2771 | 114 |
154669 | 154669 | 2020-05-18 | Gwinnett | Georgia | 13135 | 2680 | 105 |
151657 | 151657 | 2020-05-17 | Gwinnett | Georgia | 13135 | 2594 | 102 |
148648 | 148648 | 2020-05-16 | Gwinnett | Georgia | 13135 | 2597 | 102 |
145645 | 145645 | 2020-05-15 | Gwinnett | Georgia | 13135 | 2597 | 101 |
142645 | 142645 | 2020-05-14 | Gwinnett | Georgia | 13135 | 2552 | 101 |
139649 | 139649 | 2020-05-13 | Gwinnett | Georgia | 13135 | 2510 | 101 |
136658 | 136658 | 2020-05-12 | Gwinnett | Georgia | 13135 | 2495 | 101 |
133669 | 133669 | 2020-05-11 | Gwinnett | Georgia | 13135 | 2475 | 92 |
130678 | 130678 | 2020-05-10 | Gwinnett | Georgia | 13135 | 2447 | 87 |
127687 | 127687 | 2020-05-09 | Gwinnett | Georgia | 13135 | 2403 | 87 |
124700 | 124700 | 2020-05-08 | Gwinnett | Georgia | 13135 | 2322 | 87 |
121721 | 121721 | 2020-05-07 | Gwinnett | Georgia | 13135 | 2254 | 84 |
118751 | 118751 | 2020-05-06 | Gwinnett | Georgia | 13135 | 2222 | 81 |
115791 | 115791 | 2020-05-05 | Gwinnett | Georgia | 13135 | 2102 | 77 |
112908 | 112908 | 2020-05-04 | Gwinnett | Georgia | 13135 | 2057 | 65 |
110033 | 110033 | 2020-05-03 | Gwinnett | Georgia | 13135 | 1980 | 58 |
107164 | 107164 | 2020-05-02 | Gwinnett | Georgia | 13135 | 1934 | 58 |
104299 | 104299 | 2020-05-01 | Gwinnett | Georgia | 13135 | 1848 | 58 |
101444 | 101444 | 2020-04-30 | Gwinnett | Georgia | 13135 | 1793 | 57 |
98594 | 98594 | 2020-04-29 | Gwinnett | Georgia | 13135 | 1744 | 55 |
95749 | 95749 | 2020-04-28 | Gwinnett | Georgia | 13135 | 1620 | 54 |
92917 | 92917 | 2020-04-27 | Gwinnett | Georgia | 13135 | 1545 | 52 |
90098 | 90098 | 2020-04-26 | Gwinnett | Georgia | 13135 | 1504 | 47 |
87282 | 87282 | 2020-04-25 | Gwinnett | Georgia | 13135 | 1460 | 46 |
84473 | 84473 | 2020-04-24 | Gwinnett | Georgia | 13135 | 1382 | 46 |
81673 | 81673 | 2020-04-23 | Gwinnett | Georgia | 13135 | 1351 | 46 |
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);