ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Newton" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386434 | 386434 | 2020-07-31 | Newton | Georgia | 13217 | 1533 | 32 |
383216 | 383216 | 2020-07-30 | Newton | Georgia | 13217 | 1503 | 29 |
379999 | 379999 | 2020-07-29 | Newton | Georgia | 13217 | 1455 | 29 |
376782 | 376782 | 2020-07-28 | Newton | Georgia | 13217 | 1423 | 25 |
373568 | 373568 | 2020-07-27 | Newton | Georgia | 13217 | 1386 | 24 |
370356 | 370356 | 2020-07-26 | Newton | Georgia | 13217 | 1368 | 24 |
367146 | 367146 | 2020-07-25 | Newton | Georgia | 13217 | 1355 | 24 |
363939 | 363939 | 2020-07-24 | Newton | Georgia | 13217 | 1328 | 24 |
360732 | 360732 | 2020-07-23 | Newton | Georgia | 13217 | 1294 | 22 |
357527 | 357527 | 2020-07-22 | Newton | Georgia | 13217 | 1263 | 22 |
354324 | 354324 | 2020-07-21 | Newton | Georgia | 13217 | 1239 | 21 |
351122 | 351122 | 2020-07-20 | Newton | Georgia | 13217 | 1202 | 19 |
347921 | 347921 | 2020-07-19 | Newton | Georgia | 13217 | 1177 | 19 |
344721 | 344721 | 2020-07-18 | Newton | Georgia | 13217 | 1144 | 19 |
341522 | 341522 | 2020-07-17 | Newton | Georgia | 13217 | 1098 | 19 |
338325 | 338325 | 2020-07-16 | Newton | Georgia | 13217 | 1043 | 18 |
335130 | 335130 | 2020-07-15 | Newton | Georgia | 13217 | 1010 | 16 |
331937 | 331937 | 2020-07-14 | Newton | Georgia | 13217 | 975 | 15 |
328750 | 328750 | 2020-07-13 | Newton | Georgia | 13217 | 951 | 15 |
325564 | 325564 | 2020-07-12 | Newton | Georgia | 13217 | 906 | 15 |
322383 | 322383 | 2020-07-11 | Newton | Georgia | 13217 | 876 | 15 |
319204 | 319204 | 2020-07-10 | Newton | Georgia | 13217 | 863 | 14 |
316031 | 316031 | 2020-07-09 | Newton | Georgia | 13217 | 812 | 12 |
312856 | 312856 | 2020-07-08 | Newton | Georgia | 13217 | 779 | 12 |
309686 | 309686 | 2020-07-07 | Newton | Georgia | 13217 | 750 | 12 |
306518 | 306518 | 2020-07-06 | Newton | Georgia | 13217 | 734 | 12 |
303354 | 303354 | 2020-07-05 | Newton | Georgia | 13217 | 713 | 12 |
300190 | 300190 | 2020-07-04 | Newton | Georgia | 13217 | 700 | 12 |
297028 | 297028 | 2020-07-03 | Newton | Georgia | 13217 | 673 | 12 |
293872 | 293872 | 2020-07-02 | Newton | Georgia | 13217 | 644 | 11 |
290718 | 290718 | 2020-07-01 | Newton | Georgia | 13217 | 616 | 11 |
287567 | 287567 | 2020-06-30 | Newton | Georgia | 13217 | 599 | 11 |
284421 | 284421 | 2020-06-29 | Newton | Georgia | 13217 | 571 | 11 |
281275 | 281275 | 2020-06-28 | Newton | Georgia | 13217 | 571 | 11 |
278128 | 278128 | 2020-06-27 | Newton | Georgia | 13217 | 561 | 11 |
274980 | 274980 | 2020-06-26 | Newton | Georgia | 13217 | 541 | 11 |
271840 | 271840 | 2020-06-25 | Newton | Georgia | 13217 | 538 | 11 |
268704 | 268704 | 2020-06-24 | Newton | Georgia | 13217 | 525 | 11 |
265574 | 265574 | 2020-06-23 | Newton | Georgia | 13217 | 516 | 11 |
262446 | 262446 | 2020-06-22 | Newton | Georgia | 13217 | 493 | 11 |
259319 | 259319 | 2020-06-21 | Newton | Georgia | 13217 | 474 | 11 |
256192 | 256192 | 2020-06-20 | Newton | Georgia | 13217 | 466 | 11 |
253073 | 253073 | 2020-06-19 | Newton | Georgia | 13217 | 466 | 11 |
249958 | 249958 | 2020-06-18 | Newton | Georgia | 13217 | 452 | 11 |
246846 | 246846 | 2020-06-17 | Newton | Georgia | 13217 | 440 | 11 |
243733 | 243733 | 2020-06-16 | Newton | Georgia | 13217 | 425 | 11 |
240622 | 240622 | 2020-06-15 | Newton | Georgia | 13217 | 420 | 11 |
237514 | 237514 | 2020-06-14 | Newton | Georgia | 13217 | 415 | 11 |
234407 | 234407 | 2020-06-13 | Newton | Georgia | 13217 | 415 | 11 |
231301 | 231301 | 2020-06-12 | Newton | Georgia | 13217 | 412 | 11 |
228198 | 228198 | 2020-06-11 | Newton | Georgia | 13217 | 407 | 11 |
225096 | 225096 | 2020-06-10 | Newton | Georgia | 13217 | 402 | 11 |
222001 | 222001 | 2020-06-09 | Newton | Georgia | 13217 | 396 | 11 |
218906 | 218906 | 2020-06-08 | Newton | Georgia | 13217 | 395 | 10 |
215815 | 215815 | 2020-06-07 | Newton | Georgia | 13217 | 389 | 10 |
212728 | 212728 | 2020-06-06 | Newton | Georgia | 13217 | 389 | 10 |
209643 | 209643 | 2020-06-05 | Newton | Georgia | 13217 | 388 | 10 |
206562 | 206562 | 2020-06-04 | Newton | Georgia | 13217 | 382 | 11 |
203482 | 203482 | 2020-06-03 | Newton | Georgia | 13217 | 376 | 11 |
200406 | 200406 | 2020-06-02 | Newton | Georgia | 13217 | 370 | 11 |
197333 | 197333 | 2020-06-01 | Newton | Georgia | 13217 | 361 | 11 |
194263 | 194263 | 2020-05-31 | Newton | Georgia | 13217 | 352 | 11 |
191196 | 191196 | 2020-05-30 | Newton | Georgia | 13217 | 352 | 11 |
188131 | 188131 | 2020-05-29 | Newton | Georgia | 13217 | 351 | 11 |
185075 | 185075 | 2020-05-28 | Newton | Georgia | 13217 | 344 | 11 |
182021 | 182021 | 2020-05-27 | Newton | Georgia | 13217 | 341 | 11 |
178977 | 178977 | 2020-05-26 | Newton | Georgia | 13217 | 335 | 11 |
175933 | 175933 | 2020-05-25 | Newton | Georgia | 13217 | 311 | 10 |
172890 | 172890 | 2020-05-24 | Newton | Georgia | 13217 | 304 | 10 |
169849 | 169849 | 2020-05-23 | Newton | Georgia | 13217 | 289 | 10 |
166812 | 166812 | 2020-05-22 | Newton | Georgia | 13217 | 286 | 11 |
163779 | 163779 | 2020-05-21 | Newton | Georgia | 13217 | 280 | 11 |
160751 | 160751 | 2020-05-20 | Newton | Georgia | 13217 | 275 | 10 |
157725 | 157725 | 2020-05-19 | Newton | Georgia | 13217 | 266 | 10 |
154709 | 154709 | 2020-05-18 | Newton | Georgia | 13217 | 264 | 10 |
151697 | 151697 | 2020-05-17 | Newton | Georgia | 13217 | 257 | 10 |
148688 | 148688 | 2020-05-16 | Newton | Georgia | 13217 | 261 | 10 |
145685 | 145685 | 2020-05-15 | Newton | Georgia | 13217 | 262 | 9 |
142685 | 142685 | 2020-05-14 | Newton | Georgia | 13217 | 263 | 8 |
139689 | 139689 | 2020-05-13 | Newton | Georgia | 13217 | 262 | 8 |
136698 | 136698 | 2020-05-12 | Newton | Georgia | 13217 | 261 | 8 |
133709 | 133709 | 2020-05-11 | Newton | Georgia | 13217 | 260 | 8 |
130718 | 130718 | 2020-05-10 | Newton | Georgia | 13217 | 258 | 8 |
127727 | 127727 | 2020-05-09 | Newton | Georgia | 13217 | 252 | 8 |
124740 | 124740 | 2020-05-08 | Newton | Georgia | 13217 | 240 | 8 |
121761 | 121761 | 2020-05-07 | Newton | Georgia | 13217 | 236 | 8 |
118791 | 118791 | 2020-05-06 | Newton | Georgia | 13217 | 232 | 8 |
115831 | 115831 | 2020-05-05 | Newton | Georgia | 13217 | 222 | 8 |
112948 | 112948 | 2020-05-04 | Newton | Georgia | 13217 | 215 | 8 |
110073 | 110073 | 2020-05-03 | Newton | Georgia | 13217 | 208 | 7 |
107204 | 107204 | 2020-05-02 | Newton | Georgia | 13217 | 205 | 7 |
104339 | 104339 | 2020-05-01 | Newton | Georgia | 13217 | 200 | 7 |
101484 | 101484 | 2020-04-30 | Newton | Georgia | 13217 | 196 | 7 |
98634 | 98634 | 2020-04-29 | Newton | Georgia | 13217 | 193 | 7 |
95789 | 95789 | 2020-04-28 | Newton | Georgia | 13217 | 184 | 7 |
92957 | 92957 | 2020-04-27 | Newton | Georgia | 13217 | 173 | 7 |
90138 | 90138 | 2020-04-26 | Newton | Georgia | 13217 | 166 | 6 |
87322 | 87322 | 2020-04-25 | Newton | Georgia | 13217 | 166 | 6 |
84513 | 84513 | 2020-04-24 | Newton | Georgia | 13217 | 158 | 6 |
81713 | 81713 | 2020-04-23 | Newton | Georgia | 13217 | 153 | 5 |
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);