ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Tipton" and state = "Tennessee" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5927 | 5927 | 2020-03-20 | Tipton | Tennessee | 47167 | 1 | 0 |
6944 | 6944 | 2020-03-21 | Tipton | Tennessee | 47167 | 2 | 0 |
8074 | 8074 | 2020-03-22 | Tipton | Tennessee | 47167 | 5 | 0 |
9292 | 9292 | 2020-03-23 | Tipton | Tennessee | 47167 | 5 | 0 |
10626 | 10626 | 2020-03-24 | Tipton | Tennessee | 47167 | 6 | 0 |
12105 | 12105 | 2020-03-25 | Tipton | Tennessee | 47167 | 6 | 0 |
13731 | 13731 | 2020-03-26 | Tipton | Tennessee | 47167 | 8 | 0 |
15484 | 15484 | 2020-03-27 | Tipton | Tennessee | 47167 | 10 | 0 |
17348 | 17348 | 2020-03-28 | Tipton | Tennessee | 47167 | 11 | 0 |
19298 | 19298 | 2020-03-29 | Tipton | Tennessee | 47167 | 15 | 0 |
21355 | 21355 | 2020-03-30 | Tipton | Tennessee | 47167 | 16 | 0 |
23494 | 23494 | 2020-03-31 | Tipton | Tennessee | 47167 | 16 | 0 |
25697 | 25697 | 2020-04-01 | Tipton | Tennessee | 47167 | 22 | 0 |
27977 | 27977 | 2020-04-02 | Tipton | Tennessee | 47167 | 24 | 0 |
30312 | 30312 | 2020-04-03 | Tipton | Tennessee | 47167 | 28 | 0 |
32704 | 32704 | 2020-04-04 | Tipton | Tennessee | 47167 | 31 | 0 |
35141 | 35141 | 2020-04-05 | Tipton | Tennessee | 47167 | 33 | 0 |
37617 | 37617 | 2020-04-06 | Tipton | Tennessee | 47167 | 36 | 0 |
40140 | 40140 | 2020-04-07 | Tipton | Tennessee | 47167 | 38 | 0 |
42702 | 42702 | 2020-04-08 | Tipton | Tennessee | 47167 | 38 | 0 |
45289 | 45289 | 2020-04-09 | Tipton | Tennessee | 47167 | 39 | 0 |
47907 | 47907 | 2020-04-10 | Tipton | Tennessee | 47167 | 43 | 0 |
50565 | 50565 | 2020-04-11 | Tipton | Tennessee | 47167 | 44 | 0 |
53240 | 53240 | 2020-04-12 | Tipton | Tennessee | 47167 | 44 | 0 |
55927 | 55927 | 2020-04-13 | Tipton | Tennessee | 47167 | 50 | 0 |
58630 | 58630 | 2020-04-14 | Tipton | Tennessee | 47167 | 52 | 0 |
61346 | 61346 | 2020-04-15 | Tipton | Tennessee | 47167 | 53 | 0 |
64073 | 64073 | 2020-04-16 | Tipton | Tennessee | 47167 | 54 | 0 |
66820 | 66820 | 2020-04-17 | Tipton | Tennessee | 47167 | 55 | 0 |
69579 | 69579 | 2020-04-18 | Tipton | Tennessee | 47167 | 57 | 0 |
72346 | 72346 | 2020-04-19 | Tipton | Tennessee | 47167 | 56 | 0 |
75121 | 75121 | 2020-04-20 | Tipton | Tennessee | 47167 | 83 | 0 |
77903 | 77903 | 2020-04-21 | Tipton | Tennessee | 47167 | 83 | 0 |
80693 | 80693 | 2020-04-22 | Tipton | Tennessee | 47167 | 83 | 0 |
83492 | 83492 | 2020-04-23 | Tipton | Tennessee | 47167 | 87 | 0 |
86297 | 86297 | 2020-04-24 | Tipton | Tennessee | 47167 | 88 | 0 |
89112 | 89112 | 2020-04-25 | Tipton | Tennessee | 47167 | 91 | 0 |
91929 | 91929 | 2020-04-26 | Tipton | Tennessee | 47167 | 94 | 0 |
94757 | 94757 | 2020-04-27 | Tipton | Tennessee | 47167 | 95 | 0 |
97597 | 97597 | 2020-04-28 | Tipton | Tennessee | 47167 | 96 | 0 |
100447 | 100447 | 2020-04-29 | Tipton | Tennessee | 47167 | 98 | 0 |
103300 | 103300 | 2020-04-30 | Tipton | Tennessee | 47167 | 98 | 0 |
106163 | 106163 | 2020-05-01 | Tipton | Tennessee | 47167 | 98 | 0 |
109030 | 109030 | 2020-05-02 | Tipton | Tennessee | 47167 | 99 | 0 |
111904 | 111904 | 2020-05-03 | Tipton | Tennessee | 47167 | 146 | 0 |
114786 | 114786 | 2020-05-04 | Tipton | Tennessee | 47167 | 148 | 1 |
117742 | 117742 | 2020-05-05 | Tipton | Tennessee | 47167 | 149 | 1 |
120706 | 120706 | 2020-05-06 | Tipton | Tennessee | 47167 | 155 | 2 |
123684 | 123684 | 2020-05-07 | Tipton | Tennessee | 47167 | 158 | 2 |
126667 | 126667 | 2020-05-08 | Tipton | Tennessee | 47167 | 158 | 2 |
129656 | 129656 | 2020-05-09 | Tipton | Tennessee | 47167 | 158 | 2 |
132646 | 132646 | 2020-05-10 | Tipton | Tennessee | 47167 | 159 | 2 |
135637 | 135637 | 2020-05-11 | Tipton | Tennessee | 47167 | 373 | 2 |
138627 | 138627 | 2020-05-12 | Tipton | Tennessee | 47167 | 395 | 2 |
141623 | 141623 | 2020-05-13 | Tipton | Tennessee | 47167 | 400 | 2 |
144620 | 144620 | 2020-05-14 | Tipton | Tennessee | 47167 | 402 | 2 |
147621 | 147621 | 2020-05-15 | Tipton | Tennessee | 47167 | 402 | 2 |
150629 | 150629 | 2020-05-16 | Tipton | Tennessee | 47167 | 403 | 2 |
153640 | 153640 | 2020-05-17 | Tipton | Tennessee | 47167 | 403 | 2 |
156657 | 156657 | 2020-05-18 | Tipton | Tennessee | 47167 | 405 | 2 |
159679 | 159679 | 2020-05-19 | Tipton | Tennessee | 47167 | 407 | 2 |
162706 | 162706 | 2020-05-20 | Tipton | Tennessee | 47167 | 407 | 2 |
165735 | 165735 | 2020-05-21 | Tipton | Tennessee | 47167 | 409 | 2 |
168771 | 168771 | 2020-05-22 | Tipton | Tennessee | 47167 | 423 | 2 |
171810 | 171810 | 2020-05-23 | Tipton | Tennessee | 47167 | 426 | 2 |
174853 | 174853 | 2020-05-24 | Tipton | Tennessee | 47167 | 421 | 3 |
177897 | 177897 | 2020-05-25 | Tipton | Tennessee | 47167 | 427 | 3 |
180940 | 180940 | 2020-05-26 | Tipton | Tennessee | 47167 | 427 | 3 |
183990 | 183990 | 2020-05-27 | Tipton | Tennessee | 47167 | 428 | 3 |
187047 | 187047 | 2020-05-28 | Tipton | Tennessee | 47167 | 430 | 3 |
190111 | 190111 | 2020-05-29 | Tipton | Tennessee | 47167 | 437 | 3 |
193176 | 193176 | 2020-05-30 | Tipton | Tennessee | 47167 | 442 | 3 |
196246 | 196246 | 2020-05-31 | Tipton | Tennessee | 47167 | 442 | 3 |
199319 | 199319 | 2020-06-01 | Tipton | Tennessee | 47167 | 442 | 3 |
202394 | 202394 | 2020-06-02 | Tipton | Tennessee | 47167 | 455 | 3 |
205473 | 205473 | 2020-06-03 | Tipton | Tennessee | 47167 | 459 | 3 |
208555 | 208555 | 2020-06-04 | Tipton | Tennessee | 47167 | 461 | 3 |
211637 | 211637 | 2020-06-05 | Tipton | Tennessee | 47167 | 467 | 3 |
214724 | 214724 | 2020-06-06 | Tipton | Tennessee | 47167 | 475 | 3 |
217814 | 217814 | 2020-06-07 | Tipton | Tennessee | 47167 | 479 | 3 |
220906 | 220906 | 2020-06-08 | Tipton | Tennessee | 47167 | 480 | 3 |
224001 | 224001 | 2020-06-09 | Tipton | Tennessee | 47167 | 487 | 3 |
227101 | 227101 | 2020-06-10 | Tipton | Tennessee | 47167 | 488 | 3 |
230205 | 230205 | 2020-06-11 | Tipton | Tennessee | 47167 | 491 | 3 |
233310 | 233310 | 2020-06-12 | Tipton | Tennessee | 47167 | 497 | 3 |
236416 | 236416 | 2020-06-13 | Tipton | Tennessee | 47167 | 501 | 3 |
239524 | 239524 | 2020-06-14 | Tipton | Tennessee | 47167 | 510 | 3 |
242634 | 242634 | 2020-06-15 | Tipton | Tennessee | 47167 | 520 | 3 |
245746 | 245746 | 2020-06-16 | Tipton | Tennessee | 47167 | 525 | 3 |
248859 | 248859 | 2020-06-17 | Tipton | Tennessee | 47167 | 534 | 4 |
251974 | 251974 | 2020-06-18 | Tipton | Tennessee | 47167 | 541 | 4 |
255089 | 255089 | 2020-06-19 | Tipton | Tennessee | 47167 | 551 | 4 |
258215 | 258215 | 2020-06-20 | Tipton | Tennessee | 47167 | 554 | 4 |
261342 | 261342 | 2020-06-21 | Tipton | Tennessee | 47167 | 562 | 4 |
264470 | 264470 | 2020-06-22 | Tipton | Tennessee | 47167 | 563 | 4 |
267598 | 267598 | 2020-06-23 | Tipton | Tennessee | 47167 | 565 | 4 |
270732 | 270732 | 2020-06-24 | Tipton | Tennessee | 47167 | 571 | 4 |
273871 | 273871 | 2020-06-25 | Tipton | Tennessee | 47167 | 580 | 4 |
277018 | 277018 | 2020-06-26 | Tipton | Tennessee | 47167 | 584 | 4 |
280166 | 280166 | 2020-06-27 | Tipton | Tennessee | 47167 | 593 | 4 |
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);