ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,566 rows where county = "Fannin" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
293820 | 293820 | 2020-07-02 | Fannin | Georgia | 13111 | 101 | 1 |
296976 | 296976 | 2020-07-03 | Fannin | Georgia | 13111 | 104 | 1 |
300138 | 300138 | 2020-07-04 | Fannin | Georgia | 13111 | 107 | 1 |
303302 | 303302 | 2020-07-05 | Fannin | Georgia | 13111 | 107 | 1 |
306466 | 306466 | 2020-07-06 | Fannin | Georgia | 13111 | 107 | 1 |
309634 | 309634 | 2020-07-07 | Fannin | Georgia | 13111 | 109 | 1 |
312804 | 312804 | 2020-07-08 | Fannin | Georgia | 13111 | 112 | 1 |
315979 | 315979 | 2020-07-09 | Fannin | Georgia | 13111 | 115 | 1 |
319152 | 319152 | 2020-07-10 | Fannin | Georgia | 13111 | 121 | 1 |
322331 | 322331 | 2020-07-11 | Fannin | Georgia | 13111 | 123 | 1 |
325512 | 325512 | 2020-07-12 | Fannin | Georgia | 13111 | 128 | 1 |
328698 | 328698 | 2020-07-13 | Fannin | Georgia | 13111 | 133 | 1 |
331885 | 331885 | 2020-07-14 | Fannin | Georgia | 13111 | 133 | 1 |
335078 | 335078 | 2020-07-15 | Fannin | Georgia | 13111 | 137 | 1 |
338273 | 338273 | 2020-07-16 | Fannin | Georgia | 13111 | 157 | 2 |
341470 | 341470 | 2020-07-17 | Fannin | Georgia | 13111 | 168 | 2 |
344669 | 344669 | 2020-07-18 | Fannin | Georgia | 13111 | 173 | 2 |
347869 | 347869 | 2020-07-19 | Fannin | Georgia | 13111 | 190 | 2 |
351070 | 351070 | 2020-07-20 | Fannin | Georgia | 13111 | 193 | 2 |
354272 | 354272 | 2020-07-21 | Fannin | Georgia | 13111 | 199 | 2 |
357475 | 357475 | 2020-07-22 | Fannin | Georgia | 13111 | 206 | 2 |
360680 | 360680 | 2020-07-23 | Fannin | Georgia | 13111 | 214 | 2 |
363887 | 363887 | 2020-07-24 | Fannin | Georgia | 13111 | 223 | 2 |
367094 | 367094 | 2020-07-25 | Fannin | Georgia | 13111 | 229 | 2 |
370304 | 370304 | 2020-07-26 | Fannin | Georgia | 13111 | 235 | 2 |
373516 | 373516 | 2020-07-27 | Fannin | Georgia | 13111 | 238 | 2 |
376730 | 376730 | 2020-07-28 | Fannin | Georgia | 13111 | 243 | 2 |
379947 | 379947 | 2020-07-29 | Fannin | Georgia | 13111 | 252 | 2 |
383164 | 383164 | 2020-07-30 | Fannin | Georgia | 13111 | 259 | 2 |
386382 | 386382 | 2020-07-31 | Fannin | Georgia | 13111 | 266 | 2 |
389599 | 389599 | 2020-08-01 | Fannin | Georgia | 13111 | 270 | 2 |
392816 | 392816 | 2020-08-02 | Fannin | Georgia | 13111 | 281 | 2 |
396032 | 396032 | 2020-08-03 | Fannin | Georgia | 13111 | 284 | 2 |
399248 | 399248 | 2020-08-04 | Fannin | Georgia | 13111 | 290 | 3 |
402464 | 402464 | 2020-08-05 | Fannin | Georgia | 13111 | 300 | 3 |
405682 | 405682 | 2020-08-06 | Fannin | Georgia | 13111 | 303 | 3 |
408902 | 408902 | 2020-08-07 | Fannin | Georgia | 13111 | 313 | 3 |
412121 | 412121 | 2020-08-08 | Fannin | Georgia | 13111 | 329 | 3 |
415341 | 415341 | 2020-08-09 | Fannin | Georgia | 13111 | 334 | 3 |
418562 | 418562 | 2020-08-10 | Fannin | Georgia | 13111 | 335 | 3 |
421783 | 421783 | 2020-08-11 | Fannin | Georgia | 13111 | 349 | 3 |
425004 | 425004 | 2020-08-12 | Fannin | Georgia | 13111 | 354 | 4 |
428228 | 428228 | 2020-08-13 | Fannin | Georgia | 13111 | 360 | 5 |
431456 | 431456 | 2020-08-14 | Fannin | Georgia | 13111 | 362 | 5 |
434681 | 434681 | 2020-08-15 | Fannin | Georgia | 13111 | 365 | 5 |
437907 | 437907 | 2020-08-16 | Fannin | Georgia | 13111 | 368 | 5 |
441133 | 441133 | 2020-08-17 | Fannin | Georgia | 13111 | 374 | 5 |
444359 | 444359 | 2020-08-18 | Fannin | Georgia | 13111 | 388 | 5 |
447586 | 447586 | 2020-08-19 | Fannin | Georgia | 13111 | 396 | 5 |
450814 | 450814 | 2020-08-20 | Fannin | Georgia | 13111 | 398 | 5 |
454042 | 454042 | 2020-08-21 | Fannin | Georgia | 13111 | 405 | 5 |
457270 | 457270 | 2020-08-22 | Fannin | Georgia | 13111 | 410 | 5 |
460497 | 460497 | 2020-08-23 | Fannin | Georgia | 13111 | 414 | 6 |
463726 | 463726 | 2020-08-24 | Fannin | Georgia | 13111 | 416 | 6 |
466955 | 466955 | 2020-08-25 | Fannin | Georgia | 13111 | 416 | 6 |
470184 | 470184 | 2020-08-26 | Fannin | Georgia | 13111 | 422 | 6 |
473416 | 473416 | 2020-08-27 | Fannin | Georgia | 13111 | 424 | 6 |
476649 | 476649 | 2020-08-28 | Fannin | Georgia | 13111 | 428 | 7 |
479882 | 479882 | 2020-08-29 | Fannin | Georgia | 13111 | 431 | 8 |
483116 | 483116 | 2020-08-30 | Fannin | Georgia | 13111 | 439 | 8 |
486351 | 486351 | 2020-08-31 | Fannin | Georgia | 13111 | 446 | 8 |
489584 | 489584 | 2020-09-01 | Fannin | Georgia | 13111 | 465 | 8 |
492817 | 492817 | 2020-09-02 | Fannin | Georgia | 13111 | 473 | 8 |
496051 | 496051 | 2020-09-03 | Fannin | Georgia | 13111 | 480 | 8 |
499284 | 499284 | 2020-09-04 | Fannin | Georgia | 13111 | 484 | 8 |
502518 | 502518 | 2020-09-05 | Fannin | Georgia | 13111 | 483 | 8 |
505752 | 505752 | 2020-09-06 | Fannin | Georgia | 13111 | 499 | 8 |
508984 | 508984 | 2020-09-07 | Fannin | Georgia | 13111 | 503 | 8 |
512217 | 512217 | 2020-09-08 | Fannin | Georgia | 13111 | 505 | 8 |
515450 | 515450 | 2020-09-09 | Fannin | Georgia | 13111 | 509 | 8 |
518685 | 518685 | 2020-09-10 | Fannin | Georgia | 13111 | 516 | 9 |
521922 | 521922 | 2020-09-11 | Fannin | Georgia | 13111 | 525 | 9 |
525158 | 525158 | 2020-09-12 | Fannin | Georgia | 13111 | 529 | 9 |
528394 | 528394 | 2020-09-13 | Fannin | Georgia | 13111 | 535 | 9 |
531631 | 531631 | 2020-09-14 | Fannin | Georgia | 13111 | 548 | 9 |
534866 | 534866 | 2020-09-15 | Fannin | Georgia | 13111 | 555 | 9 |
538102 | 538102 | 2020-09-16 | Fannin | Georgia | 13111 | 560 | 9 |
541339 | 541339 | 2020-09-17 | Fannin | Georgia | 13111 | 570 | 9 |
544575 | 544575 | 2020-09-18 | Fannin | Georgia | 13111 | 579 | 10 |
547813 | 547813 | 2020-09-19 | Fannin | Georgia | 13111 | 594 | 12 |
551052 | 551052 | 2020-09-20 | Fannin | Georgia | 13111 | 597 | 12 |
554291 | 554291 | 2020-09-21 | Fannin | Georgia | 13111 | 598 | 12 |
557528 | 557528 | 2020-09-22 | Fannin | Georgia | 13111 | 602 | 13 |
560764 | 560764 | 2020-09-23 | Fannin | Georgia | 13111 | 618 | 20 |
564004 | 564004 | 2020-09-24 | Fannin | Georgia | 13111 | 631 | 21 |
567244 | 567244 | 2020-09-25 | Fannin | Georgia | 13111 | 641 | 21 |
570486 | 570486 | 2020-09-26 | Fannin | Georgia | 13111 | 648 | 22 |
573728 | 573728 | 2020-09-27 | Fannin | Georgia | 13111 | 651 | 22 |
576971 | 576971 | 2020-09-28 | Fannin | Georgia | 13111 | 652 | 22 |
580212 | 580212 | 2020-09-29 | Fannin | Georgia | 13111 | 658 | 24 |
583451 | 583451 | 2020-09-30 | Fannin | Georgia | 13111 | 681 | 24 |
586691 | 586691 | 2020-10-01 | Fannin | Georgia | 13111 | 686 | 24 |
589932 | 589932 | 2020-10-02 | Fannin | Georgia | 13111 | 698 | 25 |
593172 | 593172 | 2020-10-03 | Fannin | Georgia | 13111 | 706 | 25 |
596414 | 596414 | 2020-10-04 | Fannin | Georgia | 13111 | 709 | 25 |
599657 | 599657 | 2020-10-05 | Fannin | Georgia | 13111 | 732 | 25 |
602900 | 602900 | 2020-10-06 | Fannin | Georgia | 13111 | 740 | 26 |
606142 | 606142 | 2020-10-07 | Fannin | Georgia | 13111 | 749 | 26 |
609385 | 609385 | 2020-10-08 | Fannin | Georgia | 13111 | 750 | 27 |
612627 | 612627 | 2020-10-09 | Fannin | Georgia | 13111 | 758 | 27 |
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);