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 |
---|---|---|---|---|---|---|---|
534918 | 534918 | 2020-09-15 | Newton | Georgia | 13217 | 2466 | 78 |
531683 | 531683 | 2020-09-14 | Newton | Georgia | 13217 | 2451 | 76 |
528446 | 528446 | 2020-09-13 | Newton | Georgia | 13217 | 2439 | 76 |
525210 | 525210 | 2020-09-12 | Newton | Georgia | 13217 | 2435 | 74 |
521974 | 521974 | 2020-09-11 | Newton | Georgia | 13217 | 2418 | 74 |
518737 | 518737 | 2020-09-10 | Newton | Georgia | 13217 | 2417 | 72 |
515502 | 515502 | 2020-09-09 | Newton | Georgia | 13217 | 2406 | 67 |
512269 | 512269 | 2020-09-08 | Newton | Georgia | 13217 | 2390 | 65 |
509036 | 509036 | 2020-09-07 | Newton | Georgia | 13217 | 2381 | 65 |
505804 | 505804 | 2020-09-06 | Newton | Georgia | 13217 | 2380 | 65 |
502570 | 502570 | 2020-09-05 | Newton | Georgia | 13217 | 2375 | 64 |
499336 | 499336 | 2020-09-04 | Newton | Georgia | 13217 | 2371 | 63 |
496103 | 496103 | 2020-09-03 | Newton | Georgia | 13217 | 2360 | 62 |
492869 | 492869 | 2020-09-02 | Newton | Georgia | 13217 | 2342 | 62 |
489636 | 489636 | 2020-09-01 | Newton | Georgia | 13217 | 2325 | 62 |
486403 | 486403 | 2020-08-31 | Newton | Georgia | 13217 | 2306 | 61 |
483168 | 483168 | 2020-08-30 | Newton | Georgia | 13217 | 2295 | 60 |
479934 | 479934 | 2020-08-29 | Newton | Georgia | 13217 | 2277 | 60 |
476701 | 476701 | 2020-08-28 | Newton | Georgia | 13217 | 2252 | 59 |
473468 | 473468 | 2020-08-27 | Newton | Georgia | 13217 | 2234 | 58 |
470236 | 470236 | 2020-08-26 | Newton | Georgia | 13217 | 2208 | 58 |
467007 | 467007 | 2020-08-25 | Newton | Georgia | 13217 | 2189 | 58 |
463778 | 463778 | 2020-08-24 | Newton | Georgia | 13217 | 2168 | 58 |
460549 | 460549 | 2020-08-23 | Newton | Georgia | 13217 | 2159 | 58 |
457322 | 457322 | 2020-08-22 | Newton | Georgia | 13217 | 2148 | 58 |
454094 | 454094 | 2020-08-21 | Newton | Georgia | 13217 | 2127 | 52 |
450866 | 450866 | 2020-08-20 | Newton | Georgia | 13217 | 2095 | 52 |
447638 | 447638 | 2020-08-19 | Newton | Georgia | 13217 | 2078 | 52 |
444411 | 444411 | 2020-08-18 | Newton | Georgia | 13217 | 2060 | 50 |
441185 | 441185 | 2020-08-17 | Newton | Georgia | 13217 | 2038 | 50 |
437959 | 437959 | 2020-08-16 | Newton | Georgia | 13217 | 2012 | 49 |
434733 | 434733 | 2020-08-15 | Newton | Georgia | 13217 | 1987 | 48 |
431508 | 431508 | 2020-08-14 | Newton | Georgia | 13217 | 1944 | 46 |
428280 | 428280 | 2020-08-13 | Newton | Georgia | 13217 | 1914 | 46 |
425056 | 425056 | 2020-08-12 | Newton | Georgia | 13217 | 1895 | 45 |
421835 | 421835 | 2020-08-11 | Newton | Georgia | 13217 | 1865 | 40 |
418614 | 418614 | 2020-08-10 | Newton | Georgia | 13217 | 1823 | 40 |
415393 | 415393 | 2020-08-09 | Newton | Georgia | 13217 | 1787 | 40 |
412173 | 412173 | 2020-08-08 | Newton | Georgia | 13217 | 1764 | 40 |
408954 | 408954 | 2020-08-07 | Newton | Georgia | 13217 | 1736 | 39 |
405734 | 405734 | 2020-08-06 | Newton | Georgia | 13217 | 1693 | 35 |
402516 | 402516 | 2020-08-05 | Newton | Georgia | 13217 | 1688 | 37 |
399300 | 399300 | 2020-08-04 | Newton | Georgia | 13217 | 1645 | 36 |
396084 | 396084 | 2020-08-03 | Newton | Georgia | 13217 | 1618 | 35 |
392868 | 392868 | 2020-08-02 | Newton | Georgia | 13217 | 1596 | 35 |
389651 | 389651 | 2020-08-01 | Newton | Georgia | 13217 | 1566 | 35 |
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 |
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);