ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,582 rows where county = "Forsyth" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1531 | 1531 | 2020-03-12 | Forsyth | North Carolina | 37067 | 2 | 0 |
1825 | 1825 | 2020-03-13 | Forsyth | North Carolina | 37067 | 2 | 0 |
2178 | 2178 | 2020-03-14 | Forsyth | North Carolina | 37067 | 2 | 0 |
2590 | 2590 | 2020-03-15 | Forsyth | North Carolina | 37067 | 2 | 0 |
2852 | 2852 | 2020-03-16 | Forsyth | Georgia | 13117 | 1 | 0 |
3052 | 3052 | 2020-03-16 | Forsyth | North Carolina | 37067 | 2 | 0 |
3337 | 3337 | 2020-03-17 | Forsyth | Georgia | 13117 | 1 | 0 |
3571 | 3571 | 2020-03-17 | Forsyth | North Carolina | 37067 | 2 | 0 |
3898 | 3898 | 2020-03-18 | Forsyth | Georgia | 13117 | 2 | 0 |
4174 | 4174 | 2020-03-18 | Forsyth | North Carolina | 37067 | 2 | 0 |
4570 | 4570 | 2020-03-19 | Forsyth | Georgia | 13117 | 3 | 0 |
4905 | 4905 | 2020-03-19 | Forsyth | North Carolina | 37067 | 2 | 0 |
5354 | 5354 | 2020-03-20 | Forsyth | Georgia | 13117 | 3 | 0 |
5758 | 5758 | 2020-03-20 | Forsyth | North Carolina | 37067 | 7 | 0 |
6287 | 6287 | 2020-03-21 | Forsyth | Georgia | 13117 | 4 | 0 |
6755 | 6755 | 2020-03-21 | Forsyth | North Carolina | 37067 | 8 | 0 |
7333 | 7333 | 2020-03-22 | Forsyth | Georgia | 13117 | 5 | 0 |
7854 | 7854 | 2020-03-22 | Forsyth | North Carolina | 37067 | 12 | 0 |
8481 | 8481 | 2020-03-23 | Forsyth | Georgia | 13117 | 7 | 0 |
9055 | 9055 | 2020-03-23 | Forsyth | North Carolina | 37067 | 12 | 0 |
9733 | 9733 | 2020-03-24 | Forsyth | Georgia | 13117 | 8 | 1 |
10363 | 10363 | 2020-03-24 | Forsyth | North Carolina | 37067 | 12 | 0 |
11110 | 11110 | 2020-03-25 | Forsyth | Georgia | 13117 | 10 | 1 |
11804 | 11804 | 2020-03-25 | Forsyth | North Carolina | 37067 | 17 | 0 |
12659 | 12659 | 2020-03-26 | Forsyth | Georgia | 13117 | 15 | 1 |
13408 | 13408 | 2020-03-26 | Forsyth | North Carolina | 37067 | 17 | 0 |
14331 | 14331 | 2020-03-27 | Forsyth | Georgia | 13117 | 21 | 1 |
15142 | 15142 | 2020-03-27 | Forsyth | North Carolina | 37067 | 17 | 0 |
16117 | 16117 | 2020-03-28 | Forsyth | Georgia | 13117 | 22 | 1 |
16974 | 16974 | 2020-03-28 | Forsyth | North Carolina | 37067 | 24 | 0 |
18014 | 18014 | 2020-03-29 | Forsyth | Georgia | 13117 | 28 | 1 |
18904 | 18904 | 2020-03-29 | Forsyth | North Carolina | 37067 | 35 | 0 |
20003 | 20003 | 2020-03-30 | Forsyth | Georgia | 13117 | 36 | 1 |
20944 | 20944 | 2020-03-30 | Forsyth | North Carolina | 37067 | 39 | 0 |
22083 | 22083 | 2020-03-31 | Forsyth | Georgia | 13117 | 47 | 1 |
23070 | 23070 | 2020-03-31 | Forsyth | North Carolina | 37067 | 42 | 1 |
24246 | 24246 | 2020-04-01 | Forsyth | Georgia | 13117 | 50 | 1 |
25264 | 25264 | 2020-04-01 | Forsyth | North Carolina | 37067 | 42 | 1 |
26477 | 26477 | 2020-04-02 | Forsyth | Georgia | 13117 | 53 | 1 |
27526 | 27526 | 2020-04-02 | Forsyth | North Carolina | 37067 | 56 | 1 |
28781 | 28781 | 2020-04-03 | Forsyth | Georgia | 13117 | 61 | 1 |
29852 | 29852 | 2020-04-03 | Forsyth | North Carolina | 37067 | 63 | 1 |
31141 | 31141 | 2020-04-04 | Forsyth | Georgia | 13117 | 71 | 1 |
32239 | 32239 | 2020-04-04 | Forsyth | North Carolina | 37067 | 82 | 1 |
33548 | 33548 | 2020-04-05 | Forsyth | Georgia | 13117 | 73 | 1 |
34670 | 34670 | 2020-04-05 | Forsyth | North Carolina | 37067 | 86 | 2 |
35997 | 35997 | 2020-04-06 | Forsyth | Georgia | 13117 | 85 | 1 |
37139 | 37139 | 2020-04-06 | Forsyth | North Carolina | 37067 | 94 | 2 |
38489 | 38489 | 2020-04-07 | Forsyth | Georgia | 13117 | 99 | 1 |
39654 | 39654 | 2020-04-07 | Forsyth | North Carolina | 37067 | 105 | 2 |
41033 | 41033 | 2020-04-08 | Forsyth | Georgia | 13117 | 98 | 2 |
42211 | 42211 | 2020-04-08 | Forsyth | North Carolina | 37067 | 104 | 2 |
43607 | 43607 | 2020-04-09 | Forsyth | Georgia | 13117 | 109 | 2 |
44794 | 44794 | 2020-04-09 | Forsyth | North Carolina | 37067 | 105 | 2 |
46209 | 46209 | 2020-04-10 | Forsyth | Georgia | 13117 | 119 | 4 |
47407 | 47407 | 2020-04-10 | Forsyth | North Carolina | 37067 | 111 | 3 |
48839 | 48839 | 2020-04-11 | Forsyth | Georgia | 13117 | 128 | 5 |
50062 | 50062 | 2020-04-11 | Forsyth | North Carolina | 37067 | 112 | 4 |
51501 | 51501 | 2020-04-12 | Forsyth | Georgia | 13117 | 133 | 5 |
52735 | 52735 | 2020-04-12 | Forsyth | North Carolina | 37067 | 114 | 4 |
54181 | 54181 | 2020-04-13 | Forsyth | Georgia | 13117 | 143 | 5 |
55418 | 55418 | 2020-04-13 | Forsyth | North Carolina | 37067 | 117 | 4 |
56873 | 56873 | 2020-04-14 | Forsyth | Georgia | 13117 | 153 | 5 |
58118 | 58118 | 2020-04-14 | Forsyth | North Carolina | 37067 | 121 | 4 |
59580 | 59580 | 2020-04-15 | Forsyth | Georgia | 13117 | 157 | 5 |
60832 | 60832 | 2020-04-15 | Forsyth | North Carolina | 37067 | 123 | 4 |
62300 | 62300 | 2020-04-16 | Forsyth | Georgia | 13117 | 169 | 5 |
63558 | 63558 | 2020-04-16 | Forsyth | North Carolina | 37067 | 122 | 5 |
65033 | 65033 | 2020-04-17 | Forsyth | Georgia | 13117 | 185 | 6 |
66301 | 66301 | 2020-04-17 | Forsyth | North Carolina | 37067 | 122 | 5 |
67781 | 67781 | 2020-04-18 | Forsyth | Georgia | 13117 | 197 | 7 |
69058 | 69058 | 2020-04-18 | Forsyth | North Carolina | 37067 | 124 | 5 |
70543 | 70543 | 2020-04-19 | Forsyth | Georgia | 13117 | 202 | 7 |
71824 | 71824 | 2020-04-19 | Forsyth | North Carolina | 37067 | 125 | 5 |
73312 | 73312 | 2020-04-20 | Forsyth | Georgia | 13117 | 211 | 7 |
74599 | 74599 | 2020-04-20 | Forsyth | North Carolina | 37067 | 126 | 5 |
76088 | 76088 | 2020-04-21 | Forsyth | Georgia | 13117 | 216 | 8 |
77380 | 77380 | 2020-04-21 | Forsyth | North Carolina | 37067 | 128 | 5 |
78872 | 78872 | 2020-04-22 | Forsyth | Georgia | 13117 | 227 | 8 |
80169 | 80169 | 2020-04-22 | Forsyth | North Carolina | 37067 | 133 | 5 |
81665 | 81665 | 2020-04-23 | Forsyth | Georgia | 13117 | 235 | 8 |
82968 | 82968 | 2020-04-23 | Forsyth | North Carolina | 37067 | 139 | 5 |
84465 | 84465 | 2020-04-24 | Forsyth | Georgia | 13117 | 241 | 8 |
85772 | 85772 | 2020-04-24 | Forsyth | North Carolina | 37067 | 142 | 5 |
87274 | 87274 | 2020-04-25 | Forsyth | Georgia | 13117 | 249 | 8 |
88584 | 88584 | 2020-04-25 | Forsyth | North Carolina | 37067 | 149 | 5 |
90090 | 90090 | 2020-04-26 | Forsyth | Georgia | 13117 | 252 | 8 |
91399 | 91399 | 2020-04-26 | Forsyth | North Carolina | 37067 | 150 | 5 |
92909 | 92909 | 2020-04-27 | Forsyth | Georgia | 13117 | 271 | 8 |
94225 | 94225 | 2020-04-27 | Forsyth | North Carolina | 37067 | 156 | 5 |
95741 | 95741 | 2020-04-28 | Forsyth | Georgia | 13117 | 284 | 9 |
97061 | 97061 | 2020-04-28 | Forsyth | North Carolina | 37067 | 179 | 5 |
98586 | 98586 | 2020-04-29 | Forsyth | Georgia | 13117 | 292 | 9 |
99908 | 99908 | 2020-04-29 | Forsyth | North Carolina | 37067 | 194 | 5 |
101436 | 101436 | 2020-04-30 | Forsyth | Georgia | 13117 | 299 | 9 |
102761 | 102761 | 2020-04-30 | Forsyth | North Carolina | 37067 | 219 | 5 |
104291 | 104291 | 2020-05-01 | Forsyth | Georgia | 13117 | 309 | 10 |
105623 | 105623 | 2020-05-01 | Forsyth | North Carolina | 37067 | 245 | 5 |
107156 | 107156 | 2020-05-02 | Forsyth | Georgia | 13117 | 331 | 10 |
108490 | 108490 | 2020-05-02 | Forsyth | North Carolina | 37067 | 266 | 5 |
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);