ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 37057 and state = "North Carolina" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5756 | 5756 | 2020-03-20 | Davidson | North Carolina | 37057 | 1 | 0 |
6753 | 6753 | 2020-03-21 | Davidson | North Carolina | 37057 | 1 | 0 |
7851 | 7851 | 2020-03-22 | Davidson | North Carolina | 37057 | 1 | 0 |
9052 | 9052 | 2020-03-23 | Davidson | North Carolina | 37057 | 2 | 0 |
10360 | 10360 | 2020-03-24 | Davidson | North Carolina | 37057 | 2 | 0 |
11800 | 11800 | 2020-03-25 | Davidson | North Carolina | 37057 | 2 | 0 |
13404 | 13404 | 2020-03-26 | Davidson | North Carolina | 37057 | 3 | 0 |
15138 | 15138 | 2020-03-27 | Davidson | North Carolina | 37057 | 4 | 0 |
16969 | 16969 | 2020-03-28 | Davidson | North Carolina | 37057 | 14 | 0 |
18899 | 18899 | 2020-03-29 | Davidson | North Carolina | 37057 | 16 | 0 |
20939 | 20939 | 2020-03-30 | Davidson | North Carolina | 37057 | 19 | 0 |
23065 | 23065 | 2020-03-31 | Davidson | North Carolina | 37057 | 23 | 0 |
25259 | 25259 | 2020-04-01 | Davidson | North Carolina | 37057 | 28 | 0 |
27521 | 27521 | 2020-04-02 | Davidson | North Carolina | 37057 | 35 | 0 |
29847 | 29847 | 2020-04-03 | Davidson | North Carolina | 37057 | 43 | 0 |
32234 | 32234 | 2020-04-04 | Davidson | North Carolina | 37057 | 53 | 0 |
34665 | 34665 | 2020-04-05 | Davidson | North Carolina | 37057 | 57 | 0 |
37134 | 37134 | 2020-04-06 | Davidson | North Carolina | 37057 | 63 | 0 |
39649 | 39649 | 2020-04-07 | Davidson | North Carolina | 37057 | 70 | 1 |
42206 | 42206 | 2020-04-08 | Davidson | North Carolina | 37057 | 73 | 1 |
44789 | 44789 | 2020-04-09 | Davidson | North Carolina | 37057 | 78 | 2 |
47402 | 47402 | 2020-04-10 | Davidson | North Carolina | 37057 | 81 | 2 |
50057 | 50057 | 2020-04-11 | Davidson | North Carolina | 37057 | 85 | 2 |
52730 | 52730 | 2020-04-12 | Davidson | North Carolina | 37057 | 85 | 2 |
55413 | 55413 | 2020-04-13 | Davidson | North Carolina | 37057 | 84 | 2 |
58113 | 58113 | 2020-04-14 | Davidson | North Carolina | 37057 | 86 | 2 |
60827 | 60827 | 2020-04-15 | Davidson | North Carolina | 37057 | 87 | 2 |
63553 | 63553 | 2020-04-16 | Davidson | North Carolina | 37057 | 91 | 2 |
66296 | 66296 | 2020-04-17 | Davidson | North Carolina | 37057 | 94 | 2 |
69053 | 69053 | 2020-04-18 | Davidson | North Carolina | 37057 | 94 | 2 |
71819 | 71819 | 2020-04-19 | Davidson | North Carolina | 37057 | 94 | 2 |
74594 | 74594 | 2020-04-20 | Davidson | North Carolina | 37057 | 94 | 2 |
77375 | 77375 | 2020-04-21 | Davidson | North Carolina | 37057 | 96 | 2 |
80164 | 80164 | 2020-04-22 | Davidson | North Carolina | 37057 | 103 | 2 |
82963 | 82963 | 2020-04-23 | Davidson | North Carolina | 37057 | 107 | 2 |
85767 | 85767 | 2020-04-24 | Davidson | North Carolina | 37057 | 113 | 2 |
88579 | 88579 | 2020-04-25 | Davidson | North Carolina | 37057 | 120 | 4 |
91394 | 91394 | 2020-04-26 | Davidson | North Carolina | 37057 | 156 | 4 |
94220 | 94220 | 2020-04-27 | Davidson | North Carolina | 37057 | 155 | 4 |
97056 | 97056 | 2020-04-28 | Davidson | North Carolina | 37057 | 166 | 5 |
99903 | 99903 | 2020-04-29 | Davidson | North Carolina | 37057 | 160 | 7 |
102756 | 102756 | 2020-04-30 | Davidson | North Carolina | 37057 | 163 | 7 |
105618 | 105618 | 2020-05-01 | Davidson | North Carolina | 37057 | 166 | 8 |
108485 | 108485 | 2020-05-02 | Davidson | North Carolina | 37057 | 180 | 8 |
111358 | 111358 | 2020-05-03 | Davidson | North Carolina | 37057 | 179 | 8 |
114239 | 114239 | 2020-05-04 | Davidson | North Carolina | 37057 | 179 | 10 |
117119 | 117119 | 2020-05-05 | Davidson | North Carolina | 37057 | 183 | 10 |
120080 | 120080 | 2020-05-06 | Davidson | North Carolina | 37057 | 186 | 10 |
123055 | 123055 | 2020-05-07 | Davidson | North Carolina | 37057 | 191 | 10 |
126038 | 126038 | 2020-05-08 | Davidson | North Carolina | 37057 | 199 | 10 |
129027 | 129027 | 2020-05-09 | Davidson | North Carolina | 37057 | 201 | 10 |
132016 | 132016 | 2020-05-10 | Davidson | North Carolina | 37057 | 202 | 10 |
135007 | 135007 | 2020-05-11 | Davidson | North Carolina | 37057 | 205 | 10 |
137997 | 137997 | 2020-05-12 | Davidson | North Carolina | 37057 | 227 | 10 |
140993 | 140993 | 2020-05-13 | Davidson | North Carolina | 37057 | 232 | 10 |
143988 | 143988 | 2020-05-14 | Davidson | North Carolina | 37057 | 243 | 10 |
146989 | 146989 | 2020-05-15 | Davidson | North Carolina | 37057 | 255 | 10 |
149996 | 149996 | 2020-05-16 | Davidson | North Carolina | 37057 | 274 | 10 |
153006 | 153006 | 2020-05-17 | Davidson | North Carolina | 37057 | 288 | 10 |
156023 | 156023 | 2020-05-18 | Davidson | North Carolina | 37057 | 293 | 10 |
159042 | 159042 | 2020-05-19 | Davidson | North Carolina | 37057 | 306 | 11 |
162069 | 162069 | 2020-05-20 | Davidson | North Carolina | 37057 | 314 | 11 |
165098 | 165098 | 2020-05-21 | Davidson | North Carolina | 37057 | 323 | 11 |
168133 | 168133 | 2020-05-22 | Davidson | North Carolina | 37057 | 332 | 11 |
171172 | 171172 | 2020-05-23 | Davidson | North Carolina | 37057 | 345 | 11 |
174214 | 174214 | 2020-05-24 | Davidson | North Carolina | 37057 | 352 | 11 |
177258 | 177258 | 2020-05-25 | Davidson | North Carolina | 37057 | 361 | 11 |
180301 | 180301 | 2020-05-26 | Davidson | North Carolina | 37057 | 361 | 11 |
183349 | 183349 | 2020-05-27 | Davidson | North Carolina | 37057 | 361 | 11 |
186406 | 186406 | 2020-05-28 | Davidson | North Carolina | 37057 | 368 | 12 |
189466 | 189466 | 2020-05-29 | Davidson | North Carolina | 37057 | 385 | 12 |
192530 | 192530 | 2020-05-30 | Davidson | North Carolina | 37057 | 398 | 13 |
195600 | 195600 | 2020-05-31 | Davidson | North Carolina | 37057 | 413 | 13 |
198673 | 198673 | 2020-06-01 | Davidson | North Carolina | 37057 | 430 | 13 |
201747 | 201747 | 2020-06-02 | Davidson | North Carolina | 37057 | 434 | 13 |
204824 | 204824 | 2020-06-03 | Davidson | North Carolina | 37057 | 446 | 13 |
207905 | 207905 | 2020-06-04 | Davidson | North Carolina | 37057 | 477 | 13 |
210987 | 210987 | 2020-06-05 | Davidson | North Carolina | 37057 | 500 | 13 |
214071 | 214071 | 2020-06-06 | Davidson | North Carolina | 37057 | 505 | 13 |
217161 | 217161 | 2020-06-07 | Davidson | North Carolina | 37057 | 511 | 13 |
220253 | 220253 | 2020-06-08 | Davidson | North Carolina | 37057 | 520 | 13 |
223347 | 223347 | 2020-06-09 | Davidson | North Carolina | 37057 | 529 | 12 |
226447 | 226447 | 2020-06-10 | Davidson | North Carolina | 37057 | 544 | 12 |
229551 | 229551 | 2020-06-11 | Davidson | North Carolina | 37057 | 556 | 12 |
232656 | 232656 | 2020-06-12 | Davidson | North Carolina | 37057 | 589 | 12 |
235761 | 235761 | 2020-06-13 | Davidson | North Carolina | 37057 | 620 | 13 |
238869 | 238869 | 2020-06-14 | Davidson | North Carolina | 37057 | 643 | 13 |
241978 | 241978 | 2020-06-15 | Davidson | North Carolina | 37057 | 655 | 14 |
245090 | 245090 | 2020-06-16 | Davidson | North Carolina | 37057 | 664 | 15 |
248203 | 248203 | 2020-06-17 | Davidson | North Carolina | 37057 | 678 | 15 |
251318 | 251318 | 2020-06-18 | Davidson | North Carolina | 37057 | 691 | 15 |
254433 | 254433 | 2020-06-19 | Davidson | North Carolina | 37057 | 725 | 15 |
257556 | 257556 | 2020-06-20 | Davidson | North Carolina | 37057 | 729 | 15 |
260683 | 260683 | 2020-06-21 | Davidson | North Carolina | 37057 | 735 | 15 |
263811 | 263811 | 2020-06-22 | Davidson | North Carolina | 37057 | 759 | 15 |
266939 | 266939 | 2020-06-23 | Davidson | North Carolina | 37057 | 772 | 15 |
270073 | 270073 | 2020-06-24 | Davidson | North Carolina | 37057 | 797 | 15 |
273212 | 273212 | 2020-06-25 | Davidson | North Carolina | 37057 | 831 | 15 |
276358 | 276358 | 2020-06-26 | Davidson | North Carolina | 37057 | 868 | 15 |
279506 | 279506 | 2020-06-27 | Davidson | North Carolina | 37057 | 908 | 15 |
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);