ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
761 rows where county = "Jackson" and fips = 37099 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387870 | 387870 | 2020-07-31 | Jackson | North Carolina | 37099 | 389 | 3 |
384653 | 384653 | 2020-07-30 | Jackson | North Carolina | 37099 | 382 | 3 |
381435 | 381435 | 2020-07-29 | Jackson | North Carolina | 37099 | 374 | 3 |
378218 | 378218 | 2020-07-28 | Jackson | North Carolina | 37099 | 371 | 3 |
375002 | 375002 | 2020-07-27 | Jackson | North Carolina | 37099 | 365 | 3 |
371790 | 371790 | 2020-07-26 | Jackson | North Carolina | 37099 | 352 | 3 |
368578 | 368578 | 2020-07-25 | Jackson | North Carolina | 37099 | 348 | 3 |
365369 | 365369 | 2020-07-24 | Jackson | North Carolina | 37099 | 327 | 3 |
362163 | 362163 | 2020-07-23 | Jackson | North Carolina | 37099 | 317 | 3 |
358957 | 358957 | 2020-07-22 | Jackson | North Carolina | 37099 | 306 | 3 |
355753 | 355753 | 2020-07-21 | Jackson | North Carolina | 37099 | 293 | 3 |
352550 | 352550 | 2020-07-20 | Jackson | North Carolina | 37099 | 285 | 3 |
349347 | 349347 | 2020-07-19 | Jackson | North Carolina | 37099 | 279 | 3 |
346146 | 346146 | 2020-07-18 | Jackson | North Carolina | 37099 | 273 | 3 |
342947 | 342947 | 2020-07-17 | Jackson | North Carolina | 37099 | 252 | 3 |
339749 | 339749 | 2020-07-16 | Jackson | North Carolina | 37099 | 237 | 3 |
336553 | 336553 | 2020-07-15 | Jackson | North Carolina | 37099 | 221 | 3 |
333359 | 333359 | 2020-07-14 | Jackson | North Carolina | 37099 | 220 | 1 |
330169 | 330169 | 2020-07-13 | Jackson | North Carolina | 37099 | 206 | 1 |
326982 | 326982 | 2020-07-12 | Jackson | North Carolina | 37099 | 198 | 1 |
323798 | 323798 | 2020-07-11 | Jackson | North Carolina | 37099 | 189 | 1 |
320618 | 320618 | 2020-07-10 | Jackson | North Carolina | 37099 | 164 | 1 |
317441 | 317441 | 2020-07-09 | Jackson | North Carolina | 37099 | 157 | 1 |
314267 | 314267 | 2020-07-08 | Jackson | North Carolina | 37099 | 154 | 1 |
311096 | 311096 | 2020-07-07 | Jackson | North Carolina | 37099 | 147 | 1 |
307928 | 307928 | 2020-07-06 | Jackson | North Carolina | 37099 | 141 | 1 |
304761 | 304761 | 2020-07-05 | Jackson | North Carolina | 37099 | 138 | 1 |
301598 | 301598 | 2020-07-04 | Jackson | North Carolina | 37099 | 127 | 1 |
298435 | 298435 | 2020-07-03 | Jackson | North Carolina | 37099 | 126 | 1 |
295275 | 295275 | 2020-07-02 | Jackson | North Carolina | 37099 | 125 | 1 |
292120 | 292120 | 2020-07-01 | Jackson | North Carolina | 37099 | 117 | 1 |
288968 | 288968 | 2020-06-30 | Jackson | North Carolina | 37099 | 113 | 1 |
285818 | 285818 | 2020-06-29 | Jackson | North Carolina | 37099 | 105 | 1 |
282673 | 282673 | 2020-06-28 | Jackson | North Carolina | 37099 | 96 | 1 |
279527 | 279527 | 2020-06-27 | Jackson | North Carolina | 37099 | 91 | 1 |
276379 | 276379 | 2020-06-26 | Jackson | North Carolina | 37099 | 89 | 1 |
273233 | 273233 | 2020-06-25 | Jackson | North Carolina | 37099 | 83 | 1 |
270094 | 270094 | 2020-06-24 | Jackson | North Carolina | 37099 | 78 | 1 |
266960 | 266960 | 2020-06-23 | Jackson | North Carolina | 37099 | 77 | 1 |
263832 | 263832 | 2020-06-22 | Jackson | North Carolina | 37099 | 71 | 1 |
260704 | 260704 | 2020-06-21 | Jackson | North Carolina | 37099 | 71 | 1 |
257577 | 257577 | 2020-06-20 | Jackson | North Carolina | 37099 | 66 | 1 |
254454 | 254454 | 2020-06-19 | Jackson | North Carolina | 37099 | 65 | 1 |
251339 | 251339 | 2020-06-18 | Jackson | North Carolina | 37099 | 64 | 1 |
248224 | 248224 | 2020-06-17 | Jackson | North Carolina | 37099 | 61 | 1 |
245111 | 245111 | 2020-06-16 | Jackson | North Carolina | 37099 | 59 | 1 |
241999 | 241999 | 2020-06-15 | Jackson | North Carolina | 37099 | 58 | 1 |
238890 | 238890 | 2020-06-14 | Jackson | North Carolina | 37099 | 58 | 1 |
235782 | 235782 | 2020-06-13 | Jackson | North Carolina | 37099 | 57 | 1 |
232677 | 232677 | 2020-06-12 | Jackson | North Carolina | 37099 | 59 | 1 |
229572 | 229572 | 2020-06-11 | Jackson | North Carolina | 37099 | 55 | 1 |
226468 | 226468 | 2020-06-10 | Jackson | North Carolina | 37099 | 55 | 1 |
223368 | 223368 | 2020-06-09 | Jackson | North Carolina | 37099 | 55 | 1 |
220274 | 220274 | 2020-06-08 | Jackson | North Carolina | 37099 | 50 | 1 |
217182 | 217182 | 2020-06-07 | Jackson | North Carolina | 37099 | 47 | 1 |
214092 | 214092 | 2020-06-06 | Jackson | North Carolina | 37099 | 44 | 1 |
211008 | 211008 | 2020-06-05 | Jackson | North Carolina | 37099 | 38 | 1 |
207926 | 207926 | 2020-06-04 | Jackson | North Carolina | 37099 | 36 | 1 |
204845 | 204845 | 2020-06-03 | Jackson | North Carolina | 37099 | 36 | 1 |
201768 | 201768 | 2020-06-02 | Jackson | North Carolina | 37099 | 34 | 1 |
198694 | 198694 | 2020-06-01 | Jackson | North Carolina | 37099 | 34 | 1 |
195621 | 195621 | 2020-05-31 | Jackson | North Carolina | 37099 | 32 | 1 |
192551 | 192551 | 2020-05-30 | Jackson | North Carolina | 37099 | 32 | 1 |
189487 | 189487 | 2020-05-29 | Jackson | North Carolina | 37099 | 29 | 1 |
186427 | 186427 | 2020-05-28 | Jackson | North Carolina | 37099 | 26 | 1 |
183370 | 183370 | 2020-05-27 | Jackson | North Carolina | 37099 | 26 | 1 |
180322 | 180322 | 2020-05-26 | Jackson | North Carolina | 37099 | 25 | 1 |
177279 | 177279 | 2020-05-25 | Jackson | North Carolina | 37099 | 25 | 1 |
174235 | 174235 | 2020-05-24 | Jackson | North Carolina | 37099 | 25 | 1 |
171193 | 171193 | 2020-05-23 | Jackson | North Carolina | 37099 | 25 | 1 |
168154 | 168154 | 2020-05-22 | Jackson | North Carolina | 37099 | 24 | 1 |
165119 | 165119 | 2020-05-21 | Jackson | North Carolina | 37099 | 25 | 1 |
162090 | 162090 | 2020-05-20 | Jackson | North Carolina | 37099 | 24 | 1 |
159063 | 159063 | 2020-05-19 | Jackson | North Carolina | 37099 | 24 | 1 |
156044 | 156044 | 2020-05-18 | Jackson | North Carolina | 37099 | 24 | 1 |
153027 | 153027 | 2020-05-17 | Jackson | North Carolina | 37099 | 24 | 1 |
150017 | 150017 | 2020-05-16 | Jackson | North Carolina | 37099 | 24 | 1 |
147010 | 147010 | 2020-05-15 | Jackson | North Carolina | 37099 | 22 | 1 |
144009 | 144009 | 2020-05-14 | Jackson | North Carolina | 37099 | 22 | 1 |
141014 | 141014 | 2020-05-13 | Jackson | North Carolina | 37099 | 22 | 1 |
138018 | 138018 | 2020-05-12 | Jackson | North Carolina | 37099 | 21 | 1 |
135028 | 135028 | 2020-05-11 | Jackson | North Carolina | 37099 | 21 | 1 |
132037 | 132037 | 2020-05-10 | Jackson | North Carolina | 37099 | 21 | 1 |
129048 | 129048 | 2020-05-09 | Jackson | North Carolina | 37099 | 21 | 1 |
126059 | 126059 | 2020-05-08 | Jackson | North Carolina | 37099 | 21 | 1 |
123076 | 123076 | 2020-05-07 | Jackson | North Carolina | 37099 | 20 | 1 |
120101 | 120101 | 2020-05-06 | Jackson | North Carolina | 37099 | 20 | 1 |
117140 | 117140 | 2020-05-05 | Jackson | North Carolina | 37099 | 18 | 1 |
114260 | 114260 | 2020-05-04 | Jackson | North Carolina | 37099 | 16 | 0 |
111379 | 111379 | 2020-05-03 | Jackson | North Carolina | 37099 | 16 | 0 |
108506 | 108506 | 2020-05-02 | Jackson | North Carolina | 37099 | 16 | 0 |
105639 | 105639 | 2020-05-01 | Jackson | North Carolina | 37099 | 15 | 0 |
102777 | 102777 | 2020-04-30 | Jackson | North Carolina | 37099 | 13 | 0 |
99924 | 99924 | 2020-04-29 | Jackson | North Carolina | 37099 | 10 | 0 |
97076 | 97076 | 2020-04-28 | Jackson | North Carolina | 37099 | 10 | 0 |
94239 | 94239 | 2020-04-27 | Jackson | North Carolina | 37099 | 7 | 0 |
91413 | 91413 | 2020-04-26 | Jackson | North Carolina | 37099 | 5 | 0 |
88598 | 88598 | 2020-04-25 | Jackson | North Carolina | 37099 | 4 | 0 |
85786 | 85786 | 2020-04-24 | Jackson | North Carolina | 37099 | 3 | 0 |
82982 | 82982 | 2020-04-23 | Jackson | North Carolina | 37099 | 3 | 0 |
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);