ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "Fayette" and state = "Georgia" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-09 1
- 2020-03-10 1
- 2020-03-11 1
- 2020-03-12 1
- 2020-03-13 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- …
state 1
- Georgia · 796 ✖
fips 1
- 13113 796
county 1
- Fayette · 796 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
908 | 908 | 2020-03-09 | Fayette | Georgia | 13113 | 1 | 0 |
1049 | 1049 | 2020-03-10 | Fayette | Georgia | 13113 | 1 | 0 |
1221 | 1221 | 2020-03-11 | Fayette | Georgia | 13113 | 1 | 0 |
1435 | 1435 | 2020-03-12 | Fayette | Georgia | 13113 | 1 | 0 |
1703 | 1703 | 2020-03-13 | Fayette | Georgia | 13113 | 1 | 0 |
2026 | 2026 | 2020-03-14 | Fayette | Georgia | 13113 | 4 | 0 |
2413 | 2413 | 2020-03-15 | Fayette | Georgia | 13113 | 5 | 0 |
2850 | 2850 | 2020-03-16 | Fayette | Georgia | 13113 | 5 | 0 |
3335 | 3335 | 2020-03-17 | Fayette | Georgia | 13113 | 5 | 0 |
3896 | 3896 | 2020-03-18 | Fayette | Georgia | 13113 | 7 | 0 |
4568 | 4568 | 2020-03-19 | Fayette | Georgia | 13113 | 8 | 1 |
5352 | 5352 | 2020-03-20 | Fayette | Georgia | 13113 | 8 | 1 |
6285 | 6285 | 2020-03-21 | Fayette | Georgia | 13113 | 9 | 2 |
7331 | 7331 | 2020-03-22 | Fayette | Georgia | 13113 | 9 | 2 |
8479 | 8479 | 2020-03-23 | Fayette | Georgia | 13113 | 11 | 2 |
9731 | 9731 | 2020-03-24 | Fayette | Georgia | 13113 | 12 | 2 |
11108 | 11108 | 2020-03-25 | Fayette | Georgia | 13113 | 12 | 2 |
12657 | 12657 | 2020-03-26 | Fayette | Georgia | 13113 | 14 | 2 |
14329 | 14329 | 2020-03-27 | Fayette | Georgia | 13113 | 22 | 2 |
16115 | 16115 | 2020-03-28 | Fayette | Georgia | 13113 | 26 | 3 |
18012 | 18012 | 2020-03-29 | Fayette | Georgia | 13113 | 27 | 3 |
20001 | 20001 | 2020-03-30 | Fayette | Georgia | 13113 | 42 | 3 |
22081 | 22081 | 2020-03-31 | Fayette | Georgia | 13113 | 48 | 4 |
24244 | 24244 | 2020-04-01 | Fayette | Georgia | 13113 | 48 | 4 |
26475 | 26475 | 2020-04-02 | Fayette | Georgia | 13113 | 55 | 4 |
28779 | 28779 | 2020-04-03 | Fayette | Georgia | 13113 | 61 | 4 |
31139 | 31139 | 2020-04-04 | Fayette | Georgia | 13113 | 66 | 4 |
33546 | 33546 | 2020-04-05 | Fayette | Georgia | 13113 | 67 | 4 |
35995 | 35995 | 2020-04-06 | Fayette | Georgia | 13113 | 74 | 4 |
38487 | 38487 | 2020-04-07 | Fayette | Georgia | 13113 | 81 | 4 |
41031 | 41031 | 2020-04-08 | Fayette | Georgia | 13113 | 90 | 4 |
43605 | 43605 | 2020-04-09 | Fayette | Georgia | 13113 | 93 | 4 |
46207 | 46207 | 2020-04-10 | Fayette | Georgia | 13113 | 93 | 4 |
48837 | 48837 | 2020-04-11 | Fayette | Georgia | 13113 | 99 | 4 |
51499 | 51499 | 2020-04-12 | Fayette | Georgia | 13113 | 100 | 4 |
54179 | 54179 | 2020-04-13 | Fayette | Georgia | 13113 | 106 | 5 |
56871 | 56871 | 2020-04-14 | Fayette | Georgia | 13113 | 115 | 5 |
59578 | 59578 | 2020-04-15 | Fayette | Georgia | 13113 | 122 | 5 |
62298 | 62298 | 2020-04-16 | Fayette | Georgia | 13113 | 126 | 5 |
65031 | 65031 | 2020-04-17 | Fayette | Georgia | 13113 | 134 | 5 |
67779 | 67779 | 2020-04-18 | Fayette | Georgia | 13113 | 136 | 5 |
70541 | 70541 | 2020-04-19 | Fayette | Georgia | 13113 | 139 | 5 |
73310 | 73310 | 2020-04-20 | Fayette | Georgia | 13113 | 143 | 8 |
76086 | 76086 | 2020-04-21 | Fayette | Georgia | 13113 | 144 | 8 |
78870 | 78870 | 2020-04-22 | Fayette | Georgia | 13113 | 146 | 8 |
81663 | 81663 | 2020-04-23 | Fayette | Georgia | 13113 | 156 | 8 |
84463 | 84463 | 2020-04-24 | Fayette | Georgia | 13113 | 158 | 8 |
87272 | 87272 | 2020-04-25 | Fayette | Georgia | 13113 | 161 | 8 |
90088 | 90088 | 2020-04-26 | Fayette | Georgia | 13113 | 161 | 8 |
92907 | 92907 | 2020-04-27 | Fayette | Georgia | 13113 | 169 | 8 |
95739 | 95739 | 2020-04-28 | Fayette | Georgia | 13113 | 171 | 9 |
98584 | 98584 | 2020-04-29 | Fayette | Georgia | 13113 | 176 | 10 |
101434 | 101434 | 2020-04-30 | Fayette | Georgia | 13113 | 176 | 10 |
104289 | 104289 | 2020-05-01 | Fayette | Georgia | 13113 | 178 | 10 |
107154 | 107154 | 2020-05-02 | Fayette | Georgia | 13113 | 181 | 10 |
110023 | 110023 | 2020-05-03 | Fayette | Georgia | 13113 | 183 | 10 |
112898 | 112898 | 2020-05-04 | Fayette | Georgia | 13113 | 187 | 10 |
115781 | 115781 | 2020-05-05 | Fayette | Georgia | 13113 | 189 | 10 |
118741 | 118741 | 2020-05-06 | Fayette | Georgia | 13113 | 188 | 11 |
121710 | 121710 | 2020-05-07 | Fayette | Georgia | 13113 | 191 | 12 |
124689 | 124689 | 2020-05-08 | Fayette | Georgia | 13113 | 190 | 12 |
127676 | 127676 | 2020-05-09 | Fayette | Georgia | 13113 | 195 | 12 |
130667 | 130667 | 2020-05-10 | Fayette | Georgia | 13113 | 199 | 12 |
133658 | 133658 | 2020-05-11 | Fayette | Georgia | 13113 | 201 | 12 |
136647 | 136647 | 2020-05-12 | Fayette | Georgia | 13113 | 202 | 12 |
139638 | 139638 | 2020-05-13 | Fayette | Georgia | 13113 | 202 | 12 |
142634 | 142634 | 2020-05-14 | Fayette | Georgia | 13113 | 204 | 11 |
145634 | 145634 | 2020-05-15 | Fayette | Georgia | 13113 | 205 | 11 |
148637 | 148637 | 2020-05-16 | Fayette | Georgia | 13113 | 206 | 11 |
151646 | 151646 | 2020-05-17 | Fayette | Georgia | 13113 | 207 | 11 |
154658 | 154658 | 2020-05-18 | Fayette | Georgia | 13113 | 210 | 11 |
157674 | 157674 | 2020-05-19 | Fayette | Georgia | 13113 | 212 | 11 |
160700 | 160700 | 2020-05-20 | Fayette | Georgia | 13113 | 215 | 11 |
163728 | 163728 | 2020-05-21 | Fayette | Georgia | 13113 | 212 | 11 |
166761 | 166761 | 2020-05-22 | Fayette | Georgia | 13113 | 215 | 11 |
169798 | 169798 | 2020-05-23 | Fayette | Georgia | 13113 | 219 | 11 |
172839 | 172839 | 2020-05-24 | Fayette | Georgia | 13113 | 220 | 11 |
175882 | 175882 | 2020-05-25 | Fayette | Georgia | 13113 | 221 | 13 |
178926 | 178926 | 2020-05-26 | Fayette | Georgia | 13113 | 232 | 13 |
181970 | 181970 | 2020-05-27 | Fayette | Georgia | 13113 | 235 | 13 |
185024 | 185024 | 2020-05-28 | Fayette | Georgia | 13113 | 231 | 13 |
188080 | 188080 | 2020-05-29 | Fayette | Georgia | 13113 | 234 | 13 |
191145 | 191145 | 2020-05-30 | Fayette | Georgia | 13113 | 235 | 13 |
194212 | 194212 | 2020-05-31 | Fayette | Georgia | 13113 | 235 | 13 |
197282 | 197282 | 2020-06-01 | Fayette | Georgia | 13113 | 235 | 13 |
200355 | 200355 | 2020-06-02 | Fayette | Georgia | 13113 | 237 | 13 |
203431 | 203431 | 2020-06-03 | Fayette | Georgia | 13113 | 239 | 13 |
206511 | 206511 | 2020-06-04 | Fayette | Georgia | 13113 | 241 | 13 |
209592 | 209592 | 2020-06-05 | Fayette | Georgia | 13113 | 244 | 15 |
212677 | 212677 | 2020-06-06 | Fayette | Georgia | 13113 | 245 | 15 |
215764 | 215764 | 2020-06-07 | Fayette | Georgia | 13113 | 245 | 15 |
218855 | 218855 | 2020-06-08 | Fayette | Georgia | 13113 | 247 | 15 |
221950 | 221950 | 2020-06-09 | Fayette | Georgia | 13113 | 254 | 15 |
225045 | 225045 | 2020-06-10 | Fayette | Georgia | 13113 | 254 | 14 |
228147 | 228147 | 2020-06-11 | Fayette | Georgia | 13113 | 258 | 14 |
231250 | 231250 | 2020-06-12 | Fayette | Georgia | 13113 | 259 | 14 |
234356 | 234356 | 2020-06-13 | Fayette | Georgia | 13113 | 260 | 14 |
237463 | 237463 | 2020-06-14 | Fayette | Georgia | 13113 | 261 | 14 |
240571 | 240571 | 2020-06-15 | Fayette | Georgia | 13113 | 261 | 15 |
243682 | 243682 | 2020-06-16 | Fayette | Georgia | 13113 | 270 | 16 |
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);