ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Peach" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 104 ✖
- 133 45
- 70 44
- 115 44
- 2 43
- 59 35
- 9 23
- 24 22
- 26 20
- 10 19
- 52 19
- 33 17
- 119 15
- 16 14
- 27 13
- 28 13
- 30 13
- 12 11
- 116 11
- 120 11
- 0 10
- 72 10
- 108 10
- 4 9
- 47 9
- 75 9
- 1 8
- 3 8
- 49 8
- 55 8
- 66 8
- 118 8
- 125 8
- 25 7
- 29 7
- 36 7
- 41 7
- 60 7
- 69 7
- 92 7
- 110 7
- 113 7
- 18 6
- 74 6
- 77 6
- 8 5
- 17 5
- 19 5
- 56 5
- 61 5
- 90 5
- 97 5
- 102 5
- 15 4
- 20 4
- 73 4
- 78 4
- 85 4
- 94 4
- 104 4
- 127 4
- 130 4
- 5 3
- 14 3
- 21 3
- 23 3
- 34 3
- 37 3
- 43 3
- 48 3
- 64 3
- 98 3
- 106 3
- 7 2
- 35 2
- 38 2
- 39 2
- 40 2
- 45 2
- 51 2
- 57 2
- 62 2
- 65 2
- 76 2
- 82 2
- 88 2
- 91 2
- 96 2
- 103 2
- 122 2
- 129 2
- 131 2
- 6 1
- 11 1
- 42 1
- 50 1
- 53 1
- 68 1
- 71 1
- 81 1
- 83 1
- 95 1
- 114 1
- 117 1
- 124 1
state 1
- Georgia 786
fips 1
- 13225 786
county 1
- Peach · 786 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4583 | 4583 | 2020-03-19 | Peach | Georgia | 13225 | 1 | 0 |
5374 | 5374 | 2020-03-20 | Peach | Georgia | 13225 | 2 | 0 |
6308 | 6308 | 2020-03-21 | Peach | Georgia | 13225 | 2 | 0 |
7354 | 7354 | 2020-03-22 | Peach | Georgia | 13225 | 3 | 0 |
8506 | 8506 | 2020-03-23 | Peach | Georgia | 13225 | 3 | 0 |
9764 | 9764 | 2020-03-24 | Peach | Georgia | 13225 | 3 | 0 |
11144 | 11144 | 2020-03-25 | Peach | Georgia | 13225 | 5 | 0 |
12696 | 12696 | 2020-03-26 | Peach | Georgia | 13225 | 5 | 0 |
14370 | 14370 | 2020-03-27 | Peach | Georgia | 13225 | 6 | 0 |
16158 | 16158 | 2020-03-28 | Peach | Georgia | 13225 | 6 | 0 |
18055 | 18055 | 2020-03-29 | Peach | Georgia | 13225 | 6 | 1 |
20048 | 20048 | 2020-03-30 | Peach | Georgia | 13225 | 7 | 1 |
22130 | 22130 | 2020-03-31 | Peach | Georgia | 13225 | 7 | 1 |
24294 | 24294 | 2020-04-01 | Peach | Georgia | 13225 | 7 | 1 |
26525 | 26525 | 2020-04-02 | Peach | Georgia | 13225 | 7 | 1 |
28830 | 28830 | 2020-04-03 | Peach | Georgia | 13225 | 10 | 1 |
31190 | 31190 | 2020-04-04 | Peach | Georgia | 13225 | 10 | 1 |
33597 | 33597 | 2020-04-05 | Peach | Georgia | 13225 | 13 | 1 |
36047 | 36047 | 2020-04-06 | Peach | Georgia | 13225 | 16 | 2 |
38540 | 38540 | 2020-04-07 | Peach | Georgia | 13225 | 20 | 2 |
41084 | 41084 | 2020-04-08 | Peach | Georgia | 13225 | 19 | 2 |
43658 | 43658 | 2020-04-09 | Peach | Georgia | 13225 | 20 | 2 |
46260 | 46260 | 2020-04-10 | Peach | Georgia | 13225 | 21 | 2 |
48891 | 48891 | 2020-04-11 | Peach | Georgia | 13225 | 22 | 2 |
51553 | 51553 | 2020-04-12 | Peach | Georgia | 13225 | 23 | 2 |
54233 | 54233 | 2020-04-13 | Peach | Georgia | 13225 | 24 | 2 |
56925 | 56925 | 2020-04-14 | Peach | Georgia | 13225 | 24 | 2 |
59632 | 59632 | 2020-04-15 | Peach | Georgia | 13225 | 25 | 2 |
62352 | 62352 | 2020-04-16 | Peach | Georgia | 13225 | 30 | 2 |
65085 | 65085 | 2020-04-17 | Peach | Georgia | 13225 | 32 | 2 |
67833 | 67833 | 2020-04-18 | Peach | Georgia | 13225 | 32 | 2 |
70595 | 70595 | 2020-04-19 | Peach | Georgia | 13225 | 32 | 2 |
73364 | 73364 | 2020-04-20 | Peach | Georgia | 13225 | 35 | 2 |
76140 | 76140 | 2020-04-21 | Peach | Georgia | 13225 | 35 | 2 |
78924 | 78924 | 2020-04-22 | Peach | Georgia | 13225 | 35 | 2 |
81717 | 81717 | 2020-04-23 | Peach | Georgia | 13225 | 36 | 2 |
84517 | 84517 | 2020-04-24 | Peach | Georgia | 13225 | 37 | 2 |
87326 | 87326 | 2020-04-25 | Peach | Georgia | 13225 | 37 | 2 |
90142 | 90142 | 2020-04-26 | Peach | Georgia | 13225 | 37 | 2 |
92961 | 92961 | 2020-04-27 | Peach | Georgia | 13225 | 39 | 2 |
95793 | 95793 | 2020-04-28 | Peach | Georgia | 13225 | 45 | 2 |
98638 | 98638 | 2020-04-29 | Peach | Georgia | 13225 | 45 | 2 |
101488 | 101488 | 2020-04-30 | Peach | Georgia | 13225 | 46 | 2 |
104343 | 104343 | 2020-05-01 | Peach | Georgia | 13225 | 52 | 2 |
107208 | 107208 | 2020-05-02 | Peach | Georgia | 13225 | 56 | 2 |
110077 | 110077 | 2020-05-03 | Peach | Georgia | 13225 | 55 | 2 |
112952 | 112952 | 2020-05-04 | Peach | Georgia | 13225 | 59 | 2 |
115835 | 115835 | 2020-05-05 | Peach | Georgia | 13225 | 60 | 2 |
118795 | 118795 | 2020-05-06 | Peach | Georgia | 13225 | 61 | 2 |
121765 | 121765 | 2020-05-07 | Peach | Georgia | 13225 | 61 | 2 |
124744 | 124744 | 2020-05-08 | Peach | Georgia | 13225 | 62 | 2 |
127731 | 127731 | 2020-05-09 | Peach | Georgia | 13225 | 62 | 2 |
130722 | 130722 | 2020-05-10 | Peach | Georgia | 13225 | 63 | 2 |
133713 | 133713 | 2020-05-11 | Peach | Georgia | 13225 | 63 | 2 |
136702 | 136702 | 2020-05-12 | Peach | Georgia | 13225 | 68 | 2 |
139693 | 139693 | 2020-05-13 | Peach | Georgia | 13225 | 69 | 2 |
142689 | 142689 | 2020-05-14 | Peach | Georgia | 13225 | 69 | 2 |
145689 | 145689 | 2020-05-15 | Peach | Georgia | 13225 | 71 | 2 |
148692 | 148692 | 2020-05-16 | Peach | Georgia | 13225 | 70 | 2 |
151701 | 151701 | 2020-05-17 | Peach | Georgia | 13225 | 69 | 2 |
154713 | 154713 | 2020-05-18 | Peach | Georgia | 13225 | 69 | 2 |
157729 | 157729 | 2020-05-19 | Peach | Georgia | 13225 | 69 | 3 |
160755 | 160755 | 2020-05-20 | Peach | Georgia | 13225 | 69 | 3 |
163783 | 163783 | 2020-05-21 | Peach | Georgia | 13225 | 69 | 3 |
166816 | 166816 | 2020-05-22 | Peach | Georgia | 13225 | 70 | 3 |
169853 | 169853 | 2020-05-23 | Peach | Georgia | 13225 | 70 | 3 |
172894 | 172894 | 2020-05-24 | Peach | Georgia | 13225 | 70 | 3 |
175937 | 175937 | 2020-05-25 | Peach | Georgia | 13225 | 70 | 3 |
178981 | 178981 | 2020-05-26 | Peach | Georgia | 13225 | 70 | 3 |
182025 | 182025 | 2020-05-27 | Peach | Georgia | 13225 | 70 | 4 |
185079 | 185079 | 2020-05-28 | Peach | Georgia | 13225 | 70 | 4 |
188135 | 188135 | 2020-05-29 | Peach | Georgia | 13225 | 72 | 4 |
191200 | 191200 | 2020-05-30 | Peach | Georgia | 13225 | 72 | 4 |
194267 | 194267 | 2020-05-31 | Peach | Georgia | 13225 | 72 | 4 |
197337 | 197337 | 2020-06-01 | Peach | Georgia | 13225 | 73 | 4 |
200410 | 200410 | 2020-06-02 | Peach | Georgia | 13225 | 74 | 4 |
203486 | 203486 | 2020-06-03 | Peach | Georgia | 13225 | 76 | 4 |
206566 | 206566 | 2020-06-04 | Peach | Georgia | 13225 | 76 | 4 |
209647 | 209647 | 2020-06-05 | Peach | Georgia | 13225 | 76 | 5 |
212732 | 212732 | 2020-06-06 | Peach | Georgia | 13225 | 76 | 5 |
215819 | 215819 | 2020-06-07 | Peach | Georgia | 13225 | 78 | 5 |
218910 | 218910 | 2020-06-08 | Peach | Georgia | 13225 | 78 | 6 |
222005 | 222005 | 2020-06-09 | Peach | Georgia | 13225 | 80 | 7 |
225100 | 225100 | 2020-06-10 | Peach | Georgia | 13225 | 80 | 7 |
228202 | 228202 | 2020-06-11 | Peach | Georgia | 13225 | 80 | 8 |
231305 | 231305 | 2020-06-12 | Peach | Georgia | 13225 | 86 | 8 |
234411 | 234411 | 2020-06-13 | Peach | Georgia | 13225 | 86 | 9 |
237518 | 237518 | 2020-06-14 | Peach | Georgia | 13225 | 90 | 8 |
240626 | 240626 | 2020-06-15 | Peach | Georgia | 13225 | 91 | 8 |
243737 | 243737 | 2020-06-16 | Peach | Georgia | 13225 | 91 | 8 |
246850 | 246850 | 2020-06-17 | Peach | Georgia | 13225 | 92 | 9 |
249962 | 249962 | 2020-06-18 | Peach | Georgia | 13225 | 92 | 9 |
253077 | 253077 | 2020-06-19 | Peach | Georgia | 13225 | 92 | 9 |
256196 | 256196 | 2020-06-20 | Peach | Georgia | 13225 | 93 | 9 |
259323 | 259323 | 2020-06-21 | Peach | Georgia | 13225 | 93 | 9 |
262450 | 262450 | 2020-06-22 | Peach | Georgia | 13225 | 93 | 9 |
265578 | 265578 | 2020-06-23 | Peach | Georgia | 13225 | 95 | 9 |
268708 | 268708 | 2020-06-24 | Peach | Georgia | 13225 | 95 | 9 |
271844 | 271844 | 2020-06-25 | Peach | Georgia | 13225 | 95 | 9 |
274984 | 274984 | 2020-06-26 | Peach | Georgia | 13225 | 97 | 9 |
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);