ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Screven" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386451 | 386451 | 2020-07-31 | Screven | Georgia | 13251 | 167 | 9 |
383233 | 383233 | 2020-07-30 | Screven | Georgia | 13251 | 165 | 9 |
380016 | 380016 | 2020-07-29 | Screven | Georgia | 13251 | 161 | 9 |
376799 | 376799 | 2020-07-28 | Screven | Georgia | 13251 | 157 | 9 |
373585 | 373585 | 2020-07-27 | Screven | Georgia | 13251 | 160 | 9 |
370373 | 370373 | 2020-07-26 | Screven | Georgia | 13251 | 151 | 9 |
367163 | 367163 | 2020-07-25 | Screven | Georgia | 13251 | 147 | 9 |
363956 | 363956 | 2020-07-24 | Screven | Georgia | 13251 | 144 | 9 |
360749 | 360749 | 2020-07-23 | Screven | Georgia | 13251 | 141 | 8 |
357544 | 357544 | 2020-07-22 | Screven | Georgia | 13251 | 138 | 8 |
354341 | 354341 | 2020-07-21 | Screven | Georgia | 13251 | 136 | 8 |
351139 | 351139 | 2020-07-20 | Screven | Georgia | 13251 | 136 | 8 |
347938 | 347938 | 2020-07-19 | Screven | Georgia | 13251 | 135 | 8 |
344738 | 344738 | 2020-07-18 | Screven | Georgia | 13251 | 133 | 8 |
341539 | 341539 | 2020-07-17 | Screven | Georgia | 13251 | 132 | 8 |
338342 | 338342 | 2020-07-16 | Screven | Georgia | 13251 | 130 | 8 |
335147 | 335147 | 2020-07-15 | Screven | Georgia | 13251 | 123 | 8 |
331954 | 331954 | 2020-07-14 | Screven | Georgia | 13251 | 121 | 8 |
328767 | 328767 | 2020-07-13 | Screven | Georgia | 13251 | 115 | 7 |
325581 | 325581 | 2020-07-12 | Screven | Georgia | 13251 | 110 | 7 |
322400 | 322400 | 2020-07-11 | Screven | Georgia | 13251 | 108 | 7 |
319221 | 319221 | 2020-07-10 | Screven | Georgia | 13251 | 107 | 7 |
316048 | 316048 | 2020-07-09 | Screven | Georgia | 13251 | 105 | 7 |
312873 | 312873 | 2020-07-08 | Screven | Georgia | 13251 | 102 | 7 |
309703 | 309703 | 2020-07-07 | Screven | Georgia | 13251 | 101 | 7 |
306535 | 306535 | 2020-07-06 | Screven | Georgia | 13251 | 99 | 7 |
303371 | 303371 | 2020-07-05 | Screven | Georgia | 13251 | 98 | 7 |
300207 | 300207 | 2020-07-04 | Screven | Georgia | 13251 | 97 | 7 |
297045 | 297045 | 2020-07-03 | Screven | Georgia | 13251 | 97 | 7 |
293889 | 293889 | 2020-07-02 | Screven | Georgia | 13251 | 95 | 7 |
290735 | 290735 | 2020-07-01 | Screven | Georgia | 13251 | 93 | 6 |
287584 | 287584 | 2020-06-30 | Screven | Georgia | 13251 | 92 | 6 |
284438 | 284438 | 2020-06-29 | Screven | Georgia | 13251 | 91 | 6 |
281292 | 281292 | 2020-06-28 | Screven | Georgia | 13251 | 89 | 6 |
278145 | 278145 | 2020-06-27 | Screven | Georgia | 13251 | 89 | 6 |
274997 | 274997 | 2020-06-26 | Screven | Georgia | 13251 | 88 | 6 |
271857 | 271857 | 2020-06-25 | Screven | Georgia | 13251 | 87 | 5 |
268721 | 268721 | 2020-06-24 | Screven | Georgia | 13251 | 86 | 5 |
265591 | 265591 | 2020-06-23 | Screven | Georgia | 13251 | 85 | 5 |
262463 | 262463 | 2020-06-22 | Screven | Georgia | 13251 | 79 | 4 |
259336 | 259336 | 2020-06-21 | Screven | Georgia | 13251 | 75 | 4 |
256209 | 256209 | 2020-06-20 | Screven | Georgia | 13251 | 75 | 4 |
253090 | 253090 | 2020-06-19 | Screven | Georgia | 13251 | 74 | 4 |
249975 | 249975 | 2020-06-18 | Screven | Georgia | 13251 | 71 | 4 |
246863 | 246863 | 2020-06-17 | Screven | Georgia | 13251 | 66 | 4 |
243750 | 243750 | 2020-06-16 | Screven | Georgia | 13251 | 65 | 4 |
240639 | 240639 | 2020-06-15 | Screven | Georgia | 13251 | 63 | 4 |
237531 | 237531 | 2020-06-14 | Screven | Georgia | 13251 | 62 | 4 |
234424 | 234424 | 2020-06-13 | Screven | Georgia | 13251 | 62 | 4 |
231318 | 231318 | 2020-06-12 | Screven | Georgia | 13251 | 61 | 4 |
228215 | 228215 | 2020-06-11 | Screven | Georgia | 13251 | 60 | 4 |
225113 | 225113 | 2020-06-10 | Screven | Georgia | 13251 | 60 | 3 |
222018 | 222018 | 2020-06-09 | Screven | Georgia | 13251 | 59 | 3 |
218923 | 218923 | 2020-06-08 | Screven | Georgia | 13251 | 58 | 3 |
215832 | 215832 | 2020-06-07 | Screven | Georgia | 13251 | 57 | 3 |
212745 | 212745 | 2020-06-06 | Screven | Georgia | 13251 | 57 | 3 |
209660 | 209660 | 2020-06-05 | Screven | Georgia | 13251 | 57 | 3 |
206579 | 206579 | 2020-06-04 | Screven | Georgia | 13251 | 56 | 3 |
203499 | 203499 | 2020-06-03 | Screven | Georgia | 13251 | 55 | 3 |
200423 | 200423 | 2020-06-02 | Screven | Georgia | 13251 | 55 | 3 |
197350 | 197350 | 2020-06-01 | Screven | Georgia | 13251 | 55 | 3 |
194280 | 194280 | 2020-05-31 | Screven | Georgia | 13251 | 51 | 3 |
191213 | 191213 | 2020-05-30 | Screven | Georgia | 13251 | 51 | 2 |
188148 | 188148 | 2020-05-29 | Screven | Georgia | 13251 | 50 | 2 |
185092 | 185092 | 2020-05-28 | Screven | Georgia | 13251 | 50 | 2 |
182038 | 182038 | 2020-05-27 | Screven | Georgia | 13251 | 47 | 2 |
178994 | 178994 | 2020-05-26 | Screven | Georgia | 13251 | 32 | 2 |
175950 | 175950 | 2020-05-25 | Screven | Georgia | 13251 | 28 | 2 |
172907 | 172907 | 2020-05-24 | Screven | Georgia | 13251 | 27 | 2 |
169866 | 169866 | 2020-05-23 | Screven | Georgia | 13251 | 26 | 2 |
166829 | 166829 | 2020-05-22 | Screven | Georgia | 13251 | 25 | 2 |
163796 | 163796 | 2020-05-21 | Screven | Georgia | 13251 | 22 | 1 |
160768 | 160768 | 2020-05-20 | Screven | Georgia | 13251 | 20 | 1 |
157742 | 157742 | 2020-05-19 | Screven | Georgia | 13251 | 20 | 1 |
154726 | 154726 | 2020-05-18 | Screven | Georgia | 13251 | 20 | 1 |
151714 | 151714 | 2020-05-17 | Screven | Georgia | 13251 | 19 | 1 |
148705 | 148705 | 2020-05-16 | Screven | Georgia | 13251 | 19 | 1 |
145702 | 145702 | 2020-05-15 | Screven | Georgia | 13251 | 18 | 1 |
142702 | 142702 | 2020-05-14 | Screven | Georgia | 13251 | 18 | 1 |
139706 | 139706 | 2020-05-13 | Screven | Georgia | 13251 | 18 | 1 |
136715 | 136715 | 2020-05-12 | Screven | Georgia | 13251 | 17 | 1 |
133726 | 133726 | 2020-05-11 | Screven | Georgia | 13251 | 17 | 1 |
130735 | 130735 | 2020-05-10 | Screven | Georgia | 13251 | 17 | 1 |
127744 | 127744 | 2020-05-09 | Screven | Georgia | 13251 | 17 | 1 |
124757 | 124757 | 2020-05-08 | Screven | Georgia | 13251 | 17 | 1 |
121778 | 121778 | 2020-05-07 | Screven | Georgia | 13251 | 17 | 1 |
118808 | 118808 | 2020-05-06 | Screven | Georgia | 13251 | 16 | 1 |
115848 | 115848 | 2020-05-05 | Screven | Georgia | 13251 | 16 | 1 |
112965 | 112965 | 2020-05-04 | Screven | Georgia | 13251 | 15 | 1 |
110090 | 110090 | 2020-05-03 | Screven | Georgia | 13251 | 15 | 1 |
107221 | 107221 | 2020-05-02 | Screven | Georgia | 13251 | 15 | 1 |
104356 | 104356 | 2020-05-01 | Screven | Georgia | 13251 | 15 | 1 |
101501 | 101501 | 2020-04-30 | Screven | Georgia | 13251 | 15 | 1 |
98651 | 98651 | 2020-04-29 | Screven | Georgia | 13251 | 15 | 1 |
95806 | 95806 | 2020-04-28 | Screven | Georgia | 13251 | 15 | 1 |
92974 | 92974 | 2020-04-27 | Screven | Georgia | 13251 | 14 | 1 |
90155 | 90155 | 2020-04-26 | Screven | Georgia | 13251 | 14 | 1 |
87339 | 87339 | 2020-04-25 | Screven | Georgia | 13251 | 14 | 1 |
84530 | 84530 | 2020-04-24 | Screven | Georgia | 13251 | 14 | 1 |
81730 | 81730 | 2020-04-23 | Screven | Georgia | 13251 | 14 | 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);