ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 13245 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 375 ✖
- 0 16
- 532 16
- 535 12
- 17 10
- 514 9
- 48 8
- 14 7
- 212 7
- 544 7
- 886 7
- 891 7
- 893 7
- 15 6
- 16 6
- 173 6
- 185 6
- 521 6
- 739 6
- 765 6
- 1 5
- 162 5
- 245 5
- 502 5
- 513 5
- 545 5
- 549 5
- 721 5
- 731 5
- 747 5
- 887 5
- 22 4
- 25 4
- 36 4
- 42 4
- 62 4
- 74 4
- 425 4
- 452 4
- 458 4
- 509 4
- 519 4
- 531 4
- 533 4
- 536 4
- 555 4
- 637 4
- 709 4
- 753 4
- 764 4
- 773 4
- 781 4
- 809 4
- 840 4
- 3 3
- 4 3
- 10 3
- 18 3
- 54 3
- 60 3
- 63 3
- 83 3
- 90 3
- 114 3
- 138 3
- 148 3
- 172 3
- 174 3
- 175 3
- 203 3
- 211 3
- 218 3
- 250 3
- 253 3
- 278 3
- 321 3
- 366 3
- 384 3
- 468 3
- 476 3
- 490 3
- 495 3
- 510 3
- 516 3
- 525 3
- 537 3
- 542 3
- 567 3
- 592 3
- 608 3
- 619 3
- 658 3
- 682 3
- 695 3
- 726 3
- 743 3
- 775 3
- 776 3
- 795 3
- 819 3
- 832 3
- 849 3
- 858 3
- 868 3
- 874 3
- 882 3
- 884 3
- 895 3
- 19 2
- 30 2
- 38 2
- 57 2
- 73 2
- 77 2
- 87 2
- 95 2
- 97 2
- 125 2
- 143 2
- 149 2
- 153 2
- 166 2
- 167 2
- 168 2
- 181 2
- 182 2
- 215 2
- 219 2
- 220 2
- 222 2
- 227 2
- 231 2
- 234 2
- 242 2
- 252 2
- 255 2
- 292 2
- 345 2
- 374 2
- 412 2
- 443 2
- 451 2
- 469 2
- 474 2
- 480 2
- 481 2
- 482 2
- 491 2
- 492 2
- 494 2
- 522 2
- 526 2
- 529 2
- 556 2
- 607 2
- 692 2
- 715 2
- 729 2
- 733 2
- 750 2
- 774 2
- 805 2
- 837 2
- 872 2
- 6 1
- 7 1
- 8 1
- 9 1
- 11 1
- 12 1
- 13 1
- 20 1
- 27 1
- 32 1
- 34 1
- 35 1
- 40 1
- 41 1
- 49 1
- 53 1
- 58 1
- 59 1
- 61 1
- 69 1
- 75 1
- 79 1
- 84 1
- 88 1
- 94 1
- 96 1
- 98 1
- 102 1
- 103 1
- 105 1
- 110 1
- 115 1
- 116 1
- 117 1
- 120 1
- 126 1
- 131 1
- 133 1
- 135 1
- 137 1
- 139 1
- 145 1
- 147 1
- 150 1
- 152 1
- 158 1
- 159 1
- 160 1
- 161 1
- 164 1
- 171 1
- 183 1
- 199 1
- 200 1
- 202 1
- 205 1
- 208 1
- 213 1
- 221 1
- 229 1
- 230 1
- 233 1
- 235 1
- 239 1
- 241 1
- 246 1
- 249 1
- 259 1
- 263 1
- 264 1
- 268 1
- 279 1
- 280 1
- 284 1
- 286 1
- 297 1
- 303 1
- 308 1
- 311 1
- 313 1
- 327 1
- 328 1
- 332 1
- 334 1
- 348 1
- 355 1
- 359 1
- 364 1
- 365 1
- 369 1
- 377 1
- 395 1
- 399 1
- 403 1
- 408 1
- 414 1
- 416 1
- 418 1
- 429 1
- 431 1
- 435 1
- 438 1
- 440 1
- 444 1
- 446 1
- 447 1
- 453 1
- 455 1
- 456 1
- 461 1
- 462 1
- 472 1
- 475 1
- 477 1
- 485 1
- 489 1
- 499 1
- 504 1
- 505 1
- 506 1
- 508 1
- 511 1
- 512 1
- 515 1
- 523 1
- 524 1
- 528 1
- 534 1
- 538 1
- 547 1
- 548 1
- 552 1
- 553 1
- 557 1
- 568 1
- 577 1
- 586 1
- 590 1
- 595 1
- 600 1
- 606 1
- 613 1
- 614 1
- 617 1
- 625 1
- 630 1
- 632 1
- 635 1
- 642 1
- 644 1
- 649 1
- 665 1
- 671 1
- 672 1
- 676 1
- 687 1
- 689 1
- 697 1
- 700 1
- 704 1
- 705 1
- 711 1
- 722 1
- 725 1
- 735 1
- 737 1
- 742 1
- 744 1
- 746 1
- 749 1
- 754 1
- 755 1
- 759 1
- 763 1
- 767 1
- 768 1
- 769 1
- 771 1
- 777 1
- 783 1
- 784 1
- 788 1
- 791 1
- 798 1
- 803 1
- 811 1
- 815 1
- 816 1
- 823 1
- 824 1
- 826 1
- 830 1
- 835 1
- 839 1
- 843 1
- 845 1
- 848 1
- 852 1
- 854 1
- 855 1
- 857 1
- 863 1
- 864 1
- 865 1
- 866 1
- 871 1
- 873 1
- 876 1
- 877 1
- 878 1
- 879 1
- 883 1
state 1
- Georgia 788
fips 1
- 13245 · 788 ✖
county 1
- Richmond 788
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3348 | 3348 | 2020-03-17 | Richmond | Georgia | 13245 | 1 | 0 |
3910 | 3910 | 2020-03-18 | Richmond | Georgia | 13245 | 2 | 0 |
4585 | 4585 | 2020-03-19 | Richmond | Georgia | 13245 | 3 | 0 |
5378 | 5378 | 2020-03-20 | Richmond | Georgia | 13245 | 9 | 0 |
6312 | 6312 | 2020-03-21 | Richmond | Georgia | 13245 | 10 | 0 |
7358 | 7358 | 2020-03-22 | Richmond | Georgia | 13245 | 10 | 0 |
8511 | 8511 | 2020-03-23 | Richmond | Georgia | 13245 | 11 | 0 |
9770 | 9770 | 2020-03-24 | Richmond | Georgia | 13245 | 11 | 0 |
11150 | 11150 | 2020-03-25 | Richmond | Georgia | 13245 | 11 | 0 |
12702 | 12702 | 2020-03-26 | Richmond | Georgia | 13245 | 11 | 0 |
14376 | 14376 | 2020-03-27 | Richmond | Georgia | 13245 | 11 | 0 |
16165 | 16165 | 2020-03-28 | Richmond | Georgia | 13245 | 12 | 0 |
18062 | 18062 | 2020-03-29 | Richmond | Georgia | 13245 | 12 | 0 |
20055 | 20055 | 2020-03-30 | Richmond | Georgia | 13245 | 17 | 0 |
22138 | 22138 | 2020-03-31 | Richmond | Georgia | 13245 | 40 | 0 |
24303 | 24303 | 2020-04-01 | Richmond | Georgia | 13245 | 41 | 0 |
26534 | 26534 | 2020-04-02 | Richmond | Georgia | 13245 | 42 | 1 |
28840 | 28840 | 2020-04-03 | Richmond | Georgia | 13245 | 49 | 1 |
31200 | 31200 | 2020-04-04 | Richmond | Georgia | 13245 | 51 | 1 |
33607 | 33607 | 2020-04-05 | Richmond | Georgia | 13245 | 51 | 1 |
36057 | 36057 | 2020-04-06 | Richmond | Georgia | 13245 | 56 | 1 |
38550 | 38550 | 2020-04-07 | Richmond | Georgia | 13245 | 75 | 3 |
41094 | 41094 | 2020-04-08 | Richmond | Georgia | 13245 | 79 | 3 |
43668 | 43668 | 2020-04-09 | Richmond | Georgia | 13245 | 89 | 4 |
46270 | 46270 | 2020-04-10 | Richmond | Georgia | 13245 | 134 | 4 |
48901 | 48901 | 2020-04-11 | Richmond | Georgia | 13245 | 138 | 3 |
51563 | 51563 | 2020-04-12 | Richmond | Georgia | 13245 | 144 | 4 |
54243 | 54243 | 2020-04-13 | Richmond | Georgia | 13245 | 156 | 6 |
56935 | 56935 | 2020-04-14 | Richmond | Georgia | 13245 | 162 | 7 |
59642 | 59642 | 2020-04-15 | Richmond | Georgia | 13245 | 169 | 8 |
62362 | 62362 | 2020-04-16 | Richmond | Georgia | 13245 | 231 | 9 |
65095 | 65095 | 2020-04-17 | Richmond | Georgia | 13245 | 246 | 10 |
67843 | 67843 | 2020-04-18 | Richmond | Georgia | 13245 | 262 | 10 |
70605 | 70605 | 2020-04-19 | Richmond | Georgia | 13245 | 264 | 10 |
73374 | 73374 | 2020-04-20 | Richmond | Georgia | 13245 | 283 | 11 |
76150 | 76150 | 2020-04-21 | Richmond | Georgia | 13245 | 294 | 12 |
78934 | 78934 | 2020-04-22 | Richmond | Georgia | 13245 | 313 | 13 |
81727 | 81727 | 2020-04-23 | Richmond | Georgia | 13245 | 335 | 14 |
84527 | 84527 | 2020-04-24 | Richmond | Georgia | 13245 | 353 | 14 |
87336 | 87336 | 2020-04-25 | Richmond | Georgia | 13245 | 355 | 14 |
90152 | 90152 | 2020-04-26 | Richmond | Georgia | 13245 | 360 | 14 |
92971 | 92971 | 2020-04-27 | Richmond | Georgia | 13245 | 377 | 14 |
95803 | 95803 | 2020-04-28 | Richmond | Georgia | 13245 | 382 | 14 |
98648 | 98648 | 2020-04-29 | Richmond | Georgia | 13245 | 390 | 14 |
101498 | 101498 | 2020-04-30 | Richmond | Georgia | 13245 | 406 | 15 |
104353 | 104353 | 2020-05-01 | Richmond | Georgia | 13245 | 412 | 15 |
107218 | 107218 | 2020-05-02 | Richmond | Georgia | 13245 | 415 | 16 |
110087 | 110087 | 2020-05-03 | Richmond | Georgia | 13245 | 417 | 16 |
112962 | 112962 | 2020-05-04 | Richmond | Georgia | 13245 | 422 | 15 |
115845 | 115845 | 2020-05-05 | Richmond | Georgia | 13245 | 424 | 15 |
118805 | 118805 | 2020-05-06 | Richmond | Georgia | 13245 | 429 | 15 |
121775 | 121775 | 2020-05-07 | Richmond | Georgia | 13245 | 436 | 15 |
124754 | 124754 | 2020-05-08 | Richmond | Georgia | 13245 | 444 | 16 |
127741 | 127741 | 2020-05-09 | Richmond | Georgia | 13245 | 444 | 16 |
130732 | 130732 | 2020-05-10 | Richmond | Georgia | 13245 | 447 | 16 |
133723 | 133723 | 2020-05-11 | Richmond | Georgia | 13245 | 449 | 16 |
136712 | 136712 | 2020-05-12 | Richmond | Georgia | 13245 | 469 | 17 |
139703 | 139703 | 2020-05-13 | Richmond | Georgia | 13245 | 471 | 17 |
142699 | 142699 | 2020-05-14 | Richmond | Georgia | 13245 | 480 | 17 |
145699 | 145699 | 2020-05-15 | Richmond | Georgia | 13245 | 490 | 17 |
148702 | 148702 | 2020-05-16 | Richmond | Georgia | 13245 | 490 | 17 |
151711 | 151711 | 2020-05-17 | Richmond | Georgia | 13245 | 490 | 17 |
154723 | 154723 | 2020-05-18 | Richmond | Georgia | 13245 | 491 | 17 |
157739 | 157739 | 2020-05-19 | Richmond | Georgia | 13245 | 495 | 17 |
160765 | 160765 | 2020-05-20 | Richmond | Georgia | 13245 | 501 | 17 |
163793 | 163793 | 2020-05-21 | Richmond | Georgia | 13245 | 522 | 17 |
166826 | 166826 | 2020-05-22 | Richmond | Georgia | 13245 | 523 | 18 |
169863 | 169863 | 2020-05-23 | Richmond | Georgia | 13245 | 525 | 18 |
172904 | 172904 | 2020-05-24 | Richmond | Georgia | 13245 | 527 | 18 |
175947 | 175947 | 2020-05-25 | Richmond | Georgia | 13245 | 534 | 19 |
178991 | 178991 | 2020-05-26 | Richmond | Georgia | 13245 | 553 | 19 |
182035 | 182035 | 2020-05-27 | Richmond | Georgia | 13245 | 563 | 20 |
185089 | 185089 | 2020-05-28 | Richmond | Georgia | 13245 | 576 | 22 |
188145 | 188145 | 2020-05-29 | Richmond | Georgia | 13245 | 595 | 22 |
191210 | 191210 | 2020-05-30 | Richmond | Georgia | 13245 | 595 | 22 |
194277 | 194277 | 2020-05-31 | Richmond | Georgia | 13245 | 595 | 22 |
197347 | 197347 | 2020-06-01 | Richmond | Georgia | 13245 | 599 | 25 |
200420 | 200420 | 2020-06-02 | Richmond | Georgia | 13245 | 598 | 25 |
203496 | 203496 | 2020-06-03 | Richmond | Georgia | 13245 | 606 | 25 |
206576 | 206576 | 2020-06-04 | Richmond | Georgia | 13245 | 609 | 25 |
209657 | 209657 | 2020-06-05 | Richmond | Georgia | 13245 | 619 | 27 |
212742 | 212742 | 2020-06-06 | Richmond | Georgia | 13245 | 627 | 30 |
215829 | 215829 | 2020-06-07 | Richmond | Georgia | 13245 | 627 | 30 |
218920 | 218920 | 2020-06-08 | Richmond | Georgia | 13245 | 645 | 32 |
222015 | 222015 | 2020-06-09 | Richmond | Georgia | 13245 | 652 | 34 |
225110 | 225110 | 2020-06-10 | Richmond | Georgia | 13245 | 659 | 36 |
228212 | 228212 | 2020-06-11 | Richmond | Georgia | 13245 | 658 | 35 |
231315 | 231315 | 2020-06-12 | Richmond | Georgia | 13245 | 664 | 36 |
234421 | 234421 | 2020-06-13 | Richmond | Georgia | 13245 | 666 | 36 |
237528 | 237528 | 2020-06-14 | Richmond | Georgia | 13245 | 669 | 36 |
240636 | 240636 | 2020-06-15 | Richmond | Georgia | 13245 | 682 | 38 |
243747 | 243747 | 2020-06-16 | Richmond | Georgia | 13245 | 687 | 38 |
246860 | 246860 | 2020-06-17 | Richmond | Georgia | 13245 | 703 | 40 |
249972 | 249972 | 2020-06-18 | Richmond | Georgia | 13245 | 711 | 41 |
253087 | 253087 | 2020-06-19 | Richmond | Georgia | 13245 | 736 | 42 |
256206 | 256206 | 2020-06-20 | Richmond | Georgia | 13245 | 740 | 42 |
259333 | 259333 | 2020-06-21 | Richmond | Georgia | 13245 | 746 | 42 |
262460 | 262460 | 2020-06-22 | Richmond | Georgia | 13245 | 755 | 42 |
265588 | 265588 | 2020-06-23 | Richmond | Georgia | 13245 | 776 | 48 |
268718 | 268718 | 2020-06-24 | Richmond | Georgia | 13245 | 785 | 48 |
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);