ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Warren" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
602995 | 602995 | 2020-10-06 | Warren | Georgia | 13301 | 175 | 5 |
599752 | 599752 | 2020-10-05 | Warren | Georgia | 13301 | 174 | 5 |
596509 | 596509 | 2020-10-04 | Warren | Georgia | 13301 | 158 | 5 |
593267 | 593267 | 2020-10-03 | Warren | Georgia | 13301 | 156 | 5 |
590027 | 590027 | 2020-10-02 | Warren | Georgia | 13301 | 156 | 5 |
586786 | 586786 | 2020-10-01 | Warren | Georgia | 13301 | 153 | 5 |
583546 | 583546 | 2020-09-30 | Warren | Georgia | 13301 | 152 | 5 |
580307 | 580307 | 2020-09-29 | Warren | Georgia | 13301 | 152 | 5 |
577066 | 577066 | 2020-09-28 | Warren | Georgia | 13301 | 151 | 5 |
573823 | 573823 | 2020-09-27 | Warren | Georgia | 13301 | 150 | 5 |
570581 | 570581 | 2020-09-26 | Warren | Georgia | 13301 | 145 | 5 |
567339 | 567339 | 2020-09-25 | Warren | Georgia | 13301 | 142 | 5 |
564099 | 564099 | 2020-09-24 | Warren | Georgia | 13301 | 141 | 5 |
560859 | 560859 | 2020-09-23 | Warren | Georgia | 13301 | 140 | 5 |
557623 | 557623 | 2020-09-22 | Warren | Georgia | 13301 | 138 | 5 |
554386 | 554386 | 2020-09-21 | Warren | Georgia | 13301 | 136 | 5 |
551147 | 551147 | 2020-09-20 | Warren | Georgia | 13301 | 135 | 5 |
547908 | 547908 | 2020-09-19 | Warren | Georgia | 13301 | 131 | 5 |
544670 | 544670 | 2020-09-18 | Warren | Georgia | 13301 | 131 | 5 |
541434 | 541434 | 2020-09-17 | Warren | Georgia | 13301 | 128 | 5 |
538197 | 538197 | 2020-09-16 | Warren | Georgia | 13301 | 128 | 5 |
534961 | 534961 | 2020-09-15 | Warren | Georgia | 13301 | 127 | 5 |
531726 | 531726 | 2020-09-14 | Warren | Georgia | 13301 | 126 | 5 |
528489 | 528489 | 2020-09-13 | Warren | Georgia | 13301 | 125 | 5 |
525253 | 525253 | 2020-09-12 | Warren | Georgia | 13301 | 124 | 5 |
522017 | 522017 | 2020-09-11 | Warren | Georgia | 13301 | 124 | 5 |
518780 | 518780 | 2020-09-10 | Warren | Georgia | 13301 | 124 | 5 |
515545 | 515545 | 2020-09-09 | Warren | Georgia | 13301 | 124 | 5 |
512312 | 512312 | 2020-09-08 | Warren | Georgia | 13301 | 124 | 5 |
509079 | 509079 | 2020-09-07 | Warren | Georgia | 13301 | 124 | 5 |
505847 | 505847 | 2020-09-06 | Warren | Georgia | 13301 | 123 | 5 |
502613 | 502613 | 2020-09-05 | Warren | Georgia | 13301 | 123 | 5 |
499379 | 499379 | 2020-09-04 | Warren | Georgia | 13301 | 123 | 5 |
496146 | 496146 | 2020-09-03 | Warren | Georgia | 13301 | 121 | 5 |
492912 | 492912 | 2020-09-02 | Warren | Georgia | 13301 | 121 | 5 |
489679 | 489679 | 2020-09-01 | Warren | Georgia | 13301 | 120 | 5 |
486446 | 486446 | 2020-08-31 | Warren | Georgia | 13301 | 117 | 5 |
483211 | 483211 | 2020-08-30 | Warren | Georgia | 13301 | 117 | 5 |
479977 | 479977 | 2020-08-29 | Warren | Georgia | 13301 | 117 | 5 |
476744 | 476744 | 2020-08-28 | Warren | Georgia | 13301 | 118 | 5 |
473511 | 473511 | 2020-08-27 | Warren | Georgia | 13301 | 116 | 5 |
470279 | 470279 | 2020-08-26 | Warren | Georgia | 13301 | 116 | 5 |
467050 | 467050 | 2020-08-25 | Warren | Georgia | 13301 | 114 | 5 |
463821 | 463821 | 2020-08-24 | Warren | Georgia | 13301 | 110 | 3 |
460592 | 460592 | 2020-08-23 | Warren | Georgia | 13301 | 110 | 3 |
457365 | 457365 | 2020-08-22 | Warren | Georgia | 13301 | 110 | 3 |
454137 | 454137 | 2020-08-21 | Warren | Georgia | 13301 | 110 | 3 |
450909 | 450909 | 2020-08-20 | Warren | Georgia | 13301 | 100 | 3 |
447681 | 447681 | 2020-08-19 | Warren | Georgia | 13301 | 98 | 2 |
444454 | 444454 | 2020-08-18 | Warren | Georgia | 13301 | 97 | 2 |
441228 | 441228 | 2020-08-17 | Warren | Georgia | 13301 | 92 | 2 |
438002 | 438002 | 2020-08-16 | Warren | Georgia | 13301 | 92 | 1 |
434776 | 434776 | 2020-08-15 | Warren | Georgia | 13301 | 90 | 1 |
431551 | 431551 | 2020-08-14 | Warren | Georgia | 13301 | 89 | 1 |
428323 | 428323 | 2020-08-13 | Warren | Georgia | 13301 | 89 | 1 |
425099 | 425099 | 2020-08-12 | Warren | Georgia | 13301 | 87 | 1 |
421878 | 421878 | 2020-08-11 | Warren | Georgia | 13301 | 80 | 1 |
418657 | 418657 | 2020-08-10 | Warren | Georgia | 13301 | 79 | 1 |
415436 | 415436 | 2020-08-09 | Warren | Georgia | 13301 | 77 | 1 |
412216 | 412216 | 2020-08-08 | Warren | Georgia | 13301 | 75 | 1 |
408997 | 408997 | 2020-08-07 | Warren | Georgia | 13301 | 68 | 1 |
405777 | 405777 | 2020-08-06 | Warren | Georgia | 13301 | 62 | 1 |
402559 | 402559 | 2020-08-05 | Warren | Georgia | 13301 | 60 | 1 |
399343 | 399343 | 2020-08-04 | Warren | Georgia | 13301 | 56 | 1 |
396127 | 396127 | 2020-08-03 | Warren | Georgia | 13301 | 55 | 1 |
392911 | 392911 | 2020-08-02 | Warren | Georgia | 13301 | 55 | 0 |
389694 | 389694 | 2020-08-01 | Warren | Georgia | 13301 | 55 | 0 |
386477 | 386477 | 2020-07-31 | Warren | Georgia | 13301 | 53 | 0 |
383259 | 383259 | 2020-07-30 | Warren | Georgia | 13301 | 50 | 0 |
380042 | 380042 | 2020-07-29 | Warren | Georgia | 13301 | 46 | 0 |
376825 | 376825 | 2020-07-28 | Warren | Georgia | 13301 | 46 | 0 |
373611 | 373611 | 2020-07-27 | Warren | Georgia | 13301 | 46 | 0 |
370399 | 370399 | 2020-07-26 | Warren | Georgia | 13301 | 45 | 0 |
367189 | 367189 | 2020-07-25 | Warren | Georgia | 13301 | 45 | 0 |
363982 | 363982 | 2020-07-24 | Warren | Georgia | 13301 | 44 | 0 |
360775 | 360775 | 2020-07-23 | Warren | Georgia | 13301 | 44 | 0 |
357570 | 357570 | 2020-07-22 | Warren | Georgia | 13301 | 44 | 0 |
354367 | 354367 | 2020-07-21 | Warren | Georgia | 13301 | 44 | 0 |
351165 | 351165 | 2020-07-20 | Warren | Georgia | 13301 | 44 | 0 |
347964 | 347964 | 2020-07-19 | Warren | Georgia | 13301 | 44 | 0 |
344764 | 344764 | 2020-07-18 | Warren | Georgia | 13301 | 45 | 0 |
341565 | 341565 | 2020-07-17 | Warren | Georgia | 13301 | 40 | 0 |
338368 | 338368 | 2020-07-16 | Warren | Georgia | 13301 | 37 | 0 |
335173 | 335173 | 2020-07-15 | Warren | Georgia | 13301 | 36 | 0 |
331980 | 331980 | 2020-07-14 | Warren | Georgia | 13301 | 34 | 0 |
328793 | 328793 | 2020-07-13 | Warren | Georgia | 13301 | 34 | 0 |
325607 | 325607 | 2020-07-12 | Warren | Georgia | 13301 | 31 | 0 |
322426 | 322426 | 2020-07-11 | Warren | Georgia | 13301 | 30 | 0 |
319247 | 319247 | 2020-07-10 | Warren | Georgia | 13301 | 30 | 0 |
316074 | 316074 | 2020-07-09 | Warren | Georgia | 13301 | 30 | 0 |
312899 | 312899 | 2020-07-08 | Warren | Georgia | 13301 | 30 | 0 |
309729 | 309729 | 2020-07-07 | Warren | Georgia | 13301 | 29 | 0 |
306561 | 306561 | 2020-07-06 | Warren | Georgia | 13301 | 27 | 0 |
303397 | 303397 | 2020-07-05 | Warren | Georgia | 13301 | 27 | 0 |
300233 | 300233 | 2020-07-04 | Warren | Georgia | 13301 | 26 | 0 |
297071 | 297071 | 2020-07-03 | Warren | Georgia | 13301 | 25 | 0 |
293915 | 293915 | 2020-07-02 | Warren | Georgia | 13301 | 23 | 0 |
290761 | 290761 | 2020-07-01 | Warren | Georgia | 13301 | 23 | 0 |
287610 | 287610 | 2020-06-30 | Warren | Georgia | 13301 | 22 | 0 |
284464 | 284464 | 2020-06-29 | Warren | Georgia | 13301 | 20 | 0 |
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);