ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 37067 and state = "North Carolina" sorted by deaths
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 |
3052 | 3052 | 2020-03-16 | Forsyth | North Carolina | 37067 | 2 | 0 |
3571 | 3571 | 2020-03-17 | Forsyth | North Carolina | 37067 | 2 | 0 |
4174 | 4174 | 2020-03-18 | Forsyth | North Carolina | 37067 | 2 | 0 |
4905 | 4905 | 2020-03-19 | Forsyth | North Carolina | 37067 | 2 | 0 |
5758 | 5758 | 2020-03-20 | Forsyth | North Carolina | 37067 | 7 | 0 |
6755 | 6755 | 2020-03-21 | Forsyth | North Carolina | 37067 | 8 | 0 |
7854 | 7854 | 2020-03-22 | Forsyth | North Carolina | 37067 | 12 | 0 |
9055 | 9055 | 2020-03-23 | Forsyth | North Carolina | 37067 | 12 | 0 |
10363 | 10363 | 2020-03-24 | Forsyth | North Carolina | 37067 | 12 | 0 |
11804 | 11804 | 2020-03-25 | Forsyth | North Carolina | 37067 | 17 | 0 |
13408 | 13408 | 2020-03-26 | Forsyth | North Carolina | 37067 | 17 | 0 |
15142 | 15142 | 2020-03-27 | Forsyth | North Carolina | 37067 | 17 | 0 |
16974 | 16974 | 2020-03-28 | Forsyth | North Carolina | 37067 | 24 | 0 |
18904 | 18904 | 2020-03-29 | Forsyth | North Carolina | 37067 | 35 | 0 |
20944 | 20944 | 2020-03-30 | Forsyth | North Carolina | 37067 | 39 | 0 |
23070 | 23070 | 2020-03-31 | Forsyth | North Carolina | 37067 | 42 | 1 |
25264 | 25264 | 2020-04-01 | Forsyth | North Carolina | 37067 | 42 | 1 |
27526 | 27526 | 2020-04-02 | Forsyth | North Carolina | 37067 | 56 | 1 |
29852 | 29852 | 2020-04-03 | Forsyth | North Carolina | 37067 | 63 | 1 |
32239 | 32239 | 2020-04-04 | Forsyth | North Carolina | 37067 | 82 | 1 |
34670 | 34670 | 2020-04-05 | Forsyth | North Carolina | 37067 | 86 | 2 |
37139 | 37139 | 2020-04-06 | Forsyth | North Carolina | 37067 | 94 | 2 |
39654 | 39654 | 2020-04-07 | Forsyth | North Carolina | 37067 | 105 | 2 |
42211 | 42211 | 2020-04-08 | Forsyth | North Carolina | 37067 | 104 | 2 |
44794 | 44794 | 2020-04-09 | Forsyth | North Carolina | 37067 | 105 | 2 |
47407 | 47407 | 2020-04-10 | Forsyth | North Carolina | 37067 | 111 | 3 |
50062 | 50062 | 2020-04-11 | Forsyth | North Carolina | 37067 | 112 | 4 |
52735 | 52735 | 2020-04-12 | Forsyth | North Carolina | 37067 | 114 | 4 |
55418 | 55418 | 2020-04-13 | Forsyth | North Carolina | 37067 | 117 | 4 |
58118 | 58118 | 2020-04-14 | Forsyth | North Carolina | 37067 | 121 | 4 |
60832 | 60832 | 2020-04-15 | Forsyth | North Carolina | 37067 | 123 | 4 |
63558 | 63558 | 2020-04-16 | Forsyth | North Carolina | 37067 | 122 | 5 |
66301 | 66301 | 2020-04-17 | Forsyth | North Carolina | 37067 | 122 | 5 |
69058 | 69058 | 2020-04-18 | Forsyth | North Carolina | 37067 | 124 | 5 |
71824 | 71824 | 2020-04-19 | Forsyth | North Carolina | 37067 | 125 | 5 |
74599 | 74599 | 2020-04-20 | Forsyth | North Carolina | 37067 | 126 | 5 |
77380 | 77380 | 2020-04-21 | Forsyth | North Carolina | 37067 | 128 | 5 |
80169 | 80169 | 2020-04-22 | Forsyth | North Carolina | 37067 | 133 | 5 |
82968 | 82968 | 2020-04-23 | Forsyth | North Carolina | 37067 | 139 | 5 |
85772 | 85772 | 2020-04-24 | Forsyth | North Carolina | 37067 | 142 | 5 |
88584 | 88584 | 2020-04-25 | Forsyth | North Carolina | 37067 | 149 | 5 |
91399 | 91399 | 2020-04-26 | Forsyth | North Carolina | 37067 | 150 | 5 |
94225 | 94225 | 2020-04-27 | Forsyth | North Carolina | 37067 | 156 | 5 |
97061 | 97061 | 2020-04-28 | Forsyth | North Carolina | 37067 | 179 | 5 |
99908 | 99908 | 2020-04-29 | Forsyth | North Carolina | 37067 | 194 | 5 |
102761 | 102761 | 2020-04-30 | Forsyth | North Carolina | 37067 | 219 | 5 |
105623 | 105623 | 2020-05-01 | Forsyth | North Carolina | 37067 | 245 | 5 |
108490 | 108490 | 2020-05-02 | Forsyth | North Carolina | 37067 | 266 | 5 |
111363 | 111363 | 2020-05-03 | Forsyth | North Carolina | 37067 | 267 | 5 |
114244 | 114244 | 2020-05-04 | Forsyth | North Carolina | 37067 | 271 | 5 |
117124 | 117124 | 2020-05-05 | Forsyth | North Carolina | 37067 | 287 | 5 |
120085 | 120085 | 2020-05-06 | Forsyth | North Carolina | 37067 | 308 | 5 |
123060 | 123060 | 2020-05-07 | Forsyth | North Carolina | 37067 | 332 | 5 |
126043 | 126043 | 2020-05-08 | Forsyth | North Carolina | 37067 | 353 | 5 |
129032 | 129032 | 2020-05-09 | Forsyth | North Carolina | 37067 | 369 | 5 |
132021 | 132021 | 2020-05-10 | Forsyth | North Carolina | 37067 | 373 | 5 |
135012 | 135012 | 2020-05-11 | Forsyth | North Carolina | 37067 | 379 | 5 |
138002 | 138002 | 2020-05-12 | Forsyth | North Carolina | 37067 | 397 | 5 |
140998 | 140998 | 2020-05-13 | Forsyth | North Carolina | 37067 | 449 | 5 |
143993 | 143993 | 2020-05-14 | Forsyth | North Carolina | 37067 | 508 | 5 |
146994 | 146994 | 2020-05-15 | Forsyth | North Carolina | 37067 | 568 | 5 |
150001 | 150001 | 2020-05-16 | Forsyth | North Carolina | 37067 | 627 | 7 |
153011 | 153011 | 2020-05-17 | Forsyth | North Carolina | 37067 | 651 | 7 |
156028 | 156028 | 2020-05-18 | Forsyth | North Carolina | 37067 | 687 | 7 |
159047 | 159047 | 2020-05-19 | Forsyth | North Carolina | 37067 | 736 | 7 |
162074 | 162074 | 2020-05-20 | Forsyth | North Carolina | 37067 | 749 | 7 |
165103 | 165103 | 2020-05-21 | Forsyth | North Carolina | 37067 | 801 | 7 |
168138 | 168138 | 2020-05-22 | Forsyth | North Carolina | 37067 | 849 | 7 |
171177 | 171177 | 2020-05-23 | Forsyth | North Carolina | 37067 | 889 | 7 |
174219 | 174219 | 2020-05-24 | Forsyth | North Carolina | 37067 | 920 | 9 |
177263 | 177263 | 2020-05-25 | Forsyth | North Carolina | 37067 | 969 | 9 |
180306 | 180306 | 2020-05-26 | Forsyth | North Carolina | 37067 | 977 | 9 |
183354 | 183354 | 2020-05-27 | Forsyth | North Carolina | 37067 | 1022 | 9 |
186411 | 186411 | 2020-05-28 | Forsyth | North Carolina | 37067 | 1081 | 9 |
189471 | 189471 | 2020-05-29 | Forsyth | North Carolina | 37067 | 1179 | 11 |
192535 | 192535 | 2020-05-30 | Forsyth | North Carolina | 37067 | 1253 | 11 |
195605 | 195605 | 2020-05-31 | Forsyth | North Carolina | 37067 | 1347 | 11 |
198678 | 198678 | 2020-06-01 | Forsyth | North Carolina | 37067 | 1383 | 11 |
201752 | 201752 | 2020-06-02 | Forsyth | North Carolina | 37067 | 1434 | 13 |
204829 | 204829 | 2020-06-03 | Forsyth | North Carolina | 37067 | 1486 | 14 |
207910 | 207910 | 2020-06-04 | Forsyth | North Carolina | 37067 | 1560 | 17 |
210992 | 210992 | 2020-06-05 | Forsyth | North Carolina | 37067 | 1660 | 17 |
214076 | 214076 | 2020-06-06 | Forsyth | North Carolina | 37067 | 1721 | 17 |
217166 | 217166 | 2020-06-07 | Forsyth | North Carolina | 37067 | 1774 | 17 |
220258 | 220258 | 2020-06-08 | Forsyth | North Carolina | 37067 | 1816 | 17 |
223352 | 223352 | 2020-06-09 | Forsyth | North Carolina | 37067 | 1874 | 18 |
226452 | 226452 | 2020-06-10 | Forsyth | North Carolina | 37067 | 1910 | 18 |
229556 | 229556 | 2020-06-11 | Forsyth | North Carolina | 37067 | 1967 | 25 |
232661 | 232661 | 2020-06-12 | Forsyth | North Carolina | 37067 | 2051 | 25 |
235766 | 235766 | 2020-06-13 | Forsyth | North Carolina | 37067 | 2128 | 25 |
238874 | 238874 | 2020-06-14 | Forsyth | North Carolina | 37067 | 2204 | 25 |
241983 | 241983 | 2020-06-15 | Forsyth | North Carolina | 37067 | 2250 | 25 |
245095 | 245095 | 2020-06-16 | Forsyth | North Carolina | 37067 | 2283 | 25 |
248208 | 248208 | 2020-06-17 | Forsyth | North Carolina | 37067 | 2333 | 26 |
251323 | 251323 | 2020-06-18 | Forsyth | North Carolina | 37067 | 2372 | 27 |
254438 | 254438 | 2020-06-19 | Forsyth | North Carolina | 37067 | 2463 | 27 |
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);