ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Forsyth" and state = "Georgia" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
2852 | 2852 | 2020-03-16 | Forsyth | Georgia | 13117 | 1 | 0 |
3337 | 3337 | 2020-03-17 | Forsyth | Georgia | 13117 | 1 | 0 |
3898 | 3898 | 2020-03-18 | Forsyth | Georgia | 13117 | 2 | 0 |
4570 | 4570 | 2020-03-19 | Forsyth | Georgia | 13117 | 3 | 0 |
5354 | 5354 | 2020-03-20 | Forsyth | Georgia | 13117 | 3 | 0 |
6287 | 6287 | 2020-03-21 | Forsyth | Georgia | 13117 | 4 | 0 |
7333 | 7333 | 2020-03-22 | Forsyth | Georgia | 13117 | 5 | 0 |
8481 | 8481 | 2020-03-23 | Forsyth | Georgia | 13117 | 7 | 0 |
9733 | 9733 | 2020-03-24 | Forsyth | Georgia | 13117 | 8 | 1 |
11110 | 11110 | 2020-03-25 | Forsyth | Georgia | 13117 | 10 | 1 |
12659 | 12659 | 2020-03-26 | Forsyth | Georgia | 13117 | 15 | 1 |
14331 | 14331 | 2020-03-27 | Forsyth | Georgia | 13117 | 21 | 1 |
16117 | 16117 | 2020-03-28 | Forsyth | Georgia | 13117 | 22 | 1 |
18014 | 18014 | 2020-03-29 | Forsyth | Georgia | 13117 | 28 | 1 |
20003 | 20003 | 2020-03-30 | Forsyth | Georgia | 13117 | 36 | 1 |
22083 | 22083 | 2020-03-31 | Forsyth | Georgia | 13117 | 47 | 1 |
24246 | 24246 | 2020-04-01 | Forsyth | Georgia | 13117 | 50 | 1 |
26477 | 26477 | 2020-04-02 | Forsyth | Georgia | 13117 | 53 | 1 |
28781 | 28781 | 2020-04-03 | Forsyth | Georgia | 13117 | 61 | 1 |
31141 | 31141 | 2020-04-04 | Forsyth | Georgia | 13117 | 71 | 1 |
33548 | 33548 | 2020-04-05 | Forsyth | Georgia | 13117 | 73 | 1 |
35997 | 35997 | 2020-04-06 | Forsyth | Georgia | 13117 | 85 | 1 |
38489 | 38489 | 2020-04-07 | Forsyth | Georgia | 13117 | 99 | 1 |
41033 | 41033 | 2020-04-08 | Forsyth | Georgia | 13117 | 98 | 2 |
43607 | 43607 | 2020-04-09 | Forsyth | Georgia | 13117 | 109 | 2 |
46209 | 46209 | 2020-04-10 | Forsyth | Georgia | 13117 | 119 | 4 |
48839 | 48839 | 2020-04-11 | Forsyth | Georgia | 13117 | 128 | 5 |
51501 | 51501 | 2020-04-12 | Forsyth | Georgia | 13117 | 133 | 5 |
54181 | 54181 | 2020-04-13 | Forsyth | Georgia | 13117 | 143 | 5 |
56873 | 56873 | 2020-04-14 | Forsyth | Georgia | 13117 | 153 | 5 |
59580 | 59580 | 2020-04-15 | Forsyth | Georgia | 13117 | 157 | 5 |
62300 | 62300 | 2020-04-16 | Forsyth | Georgia | 13117 | 169 | 5 |
65033 | 65033 | 2020-04-17 | Forsyth | Georgia | 13117 | 185 | 6 |
67781 | 67781 | 2020-04-18 | Forsyth | Georgia | 13117 | 197 | 7 |
70543 | 70543 | 2020-04-19 | Forsyth | Georgia | 13117 | 202 | 7 |
73312 | 73312 | 2020-04-20 | Forsyth | Georgia | 13117 | 211 | 7 |
76088 | 76088 | 2020-04-21 | Forsyth | Georgia | 13117 | 216 | 8 |
78872 | 78872 | 2020-04-22 | Forsyth | Georgia | 13117 | 227 | 8 |
81665 | 81665 | 2020-04-23 | Forsyth | Georgia | 13117 | 235 | 8 |
84465 | 84465 | 2020-04-24 | Forsyth | Georgia | 13117 | 241 | 8 |
87274 | 87274 | 2020-04-25 | Forsyth | Georgia | 13117 | 249 | 8 |
90090 | 90090 | 2020-04-26 | Forsyth | Georgia | 13117 | 252 | 8 |
92909 | 92909 | 2020-04-27 | Forsyth | Georgia | 13117 | 271 | 8 |
95741 | 95741 | 2020-04-28 | Forsyth | Georgia | 13117 | 284 | 9 |
98586 | 98586 | 2020-04-29 | Forsyth | Georgia | 13117 | 292 | 9 |
101436 | 101436 | 2020-04-30 | Forsyth | Georgia | 13117 | 299 | 9 |
104291 | 104291 | 2020-05-01 | Forsyth | Georgia | 13117 | 309 | 10 |
107156 | 107156 | 2020-05-02 | Forsyth | Georgia | 13117 | 331 | 10 |
110025 | 110025 | 2020-05-03 | Forsyth | Georgia | 13117 | 332 | 10 |
112900 | 112900 | 2020-05-04 | Forsyth | Georgia | 13117 | 341 | 10 |
115783 | 115783 | 2020-05-05 | Forsyth | Georgia | 13117 | 347 | 10 |
118743 | 118743 | 2020-05-06 | Forsyth | Georgia | 13117 | 356 | 10 |
121712 | 121712 | 2020-05-07 | Forsyth | Georgia | 13117 | 361 | 10 |
124691 | 124691 | 2020-05-08 | Forsyth | Georgia | 13117 | 364 | 10 |
127678 | 127678 | 2020-05-09 | Forsyth | Georgia | 13117 | 366 | 10 |
130669 | 130669 | 2020-05-10 | Forsyth | Georgia | 13117 | 388 | 10 |
133660 | 133660 | 2020-05-11 | Forsyth | Georgia | 13117 | 391 | 10 |
136649 | 136649 | 2020-05-12 | Forsyth | Georgia | 13117 | 386 | 11 |
139640 | 139640 | 2020-05-13 | Forsyth | Georgia | 13117 | 393 | 11 |
142636 | 142636 | 2020-05-14 | Forsyth | Georgia | 13117 | 395 | 11 |
145636 | 145636 | 2020-05-15 | Forsyth | Georgia | 13117 | 397 | 11 |
148639 | 148639 | 2020-05-16 | Forsyth | Georgia | 13117 | 398 | 11 |
151648 | 151648 | 2020-05-17 | Forsyth | Georgia | 13117 | 399 | 11 |
154660 | 154660 | 2020-05-18 | Forsyth | Georgia | 13117 | 405 | 11 |
157676 | 157676 | 2020-05-19 | Forsyth | Georgia | 13117 | 412 | 11 |
160702 | 160702 | 2020-05-20 | Forsyth | Georgia | 13117 | 434 | 11 |
163730 | 163730 | 2020-05-21 | Forsyth | Georgia | 13117 | 443 | 12 |
166763 | 166763 | 2020-05-22 | Forsyth | Georgia | 13117 | 444 | 12 |
169800 | 169800 | 2020-05-23 | Forsyth | Georgia | 13117 | 446 | 12 |
172841 | 172841 | 2020-05-24 | Forsyth | Georgia | 13117 | 449 | 12 |
175884 | 175884 | 2020-05-25 | Forsyth | Georgia | 13117 | 480 | 12 |
185026 | 185026 | 2020-05-28 | Forsyth | Georgia | 13117 | 507 | 12 |
188082 | 188082 | 2020-05-29 | Forsyth | Georgia | 13117 | 512 | 12 |
191147 | 191147 | 2020-05-30 | Forsyth | Georgia | 13117 | 512 | 12 |
194214 | 194214 | 2020-05-31 | Forsyth | Georgia | 13117 | 512 | 12 |
197284 | 197284 | 2020-06-01 | Forsyth | Georgia | 13117 | 523 | 12 |
200357 | 200357 | 2020-06-02 | Forsyth | Georgia | 13117 | 532 | 12 |
203433 | 203433 | 2020-06-03 | Forsyth | Georgia | 13117 | 534 | 12 |
206513 | 206513 | 2020-06-04 | Forsyth | Georgia | 13117 | 535 | 12 |
209594 | 209594 | 2020-06-05 | Forsyth | Georgia | 13117 | 541 | 12 |
212679 | 212679 | 2020-06-06 | Forsyth | Georgia | 13117 | 546 | 12 |
215766 | 215766 | 2020-06-07 | Forsyth | Georgia | 13117 | 546 | 12 |
218857 | 218857 | 2020-06-08 | Forsyth | Georgia | 13117 | 556 | 12 |
221952 | 221952 | 2020-06-09 | Forsyth | Georgia | 13117 | 575 | 12 |
225047 | 225047 | 2020-06-10 | Forsyth | Georgia | 13117 | 579 | 12 |
178928 | 178928 | 2020-05-26 | Forsyth | Georgia | 13117 | 492 | 13 |
181972 | 181972 | 2020-05-27 | Forsyth | Georgia | 13117 | 502 | 13 |
228149 | 228149 | 2020-06-11 | Forsyth | Georgia | 13117 | 579 | 13 |
231252 | 231252 | 2020-06-12 | Forsyth | Georgia | 13117 | 589 | 13 |
234358 | 234358 | 2020-06-13 | Forsyth | Georgia | 13117 | 594 | 13 |
237465 | 237465 | 2020-06-14 | Forsyth | Georgia | 13117 | 595 | 13 |
240573 | 240573 | 2020-06-15 | Forsyth | Georgia | 13117 | 598 | 13 |
243684 | 243684 | 2020-06-16 | Forsyth | Georgia | 13117 | 603 | 13 |
246797 | 246797 | 2020-06-17 | Forsyth | Georgia | 13117 | 616 | 13 |
249909 | 249909 | 2020-06-18 | Forsyth | Georgia | 13117 | 627 | 14 |
253024 | 253024 | 2020-06-19 | Forsyth | Georgia | 13117 | 638 | 14 |
256143 | 256143 | 2020-06-20 | Forsyth | Georgia | 13117 | 642 | 14 |
259270 | 259270 | 2020-06-21 | Forsyth | Georgia | 13117 | 650 | 14 |
262397 | 262397 | 2020-06-22 | Forsyth | Georgia | 13117 | 660 | 14 |
265525 | 265525 | 2020-06-23 | Forsyth | Georgia | 13117 | 694 | 14 |
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);