ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,568 rows where county = "Tipton" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
5927 | 5927 | 2020-03-20 | Tipton | Tennessee | 47167 | 1 | 0 |
7448 | 7448 | 2020-03-22 | Tipton | Indiana | 18159 | 1 | 0 |
6944 | 6944 | 2020-03-21 | Tipton | Tennessee | 47167 | 2 | 0 |
8606 | 8606 | 2020-03-23 | Tipton | Indiana | 18159 | 2 | 0 |
9881 | 9881 | 2020-03-24 | Tipton | Indiana | 18159 | 2 | 0 |
11277 | 11277 | 2020-03-25 | Tipton | Indiana | 18159 | 2 | 0 |
12837 | 12837 | 2020-03-26 | Tipton | Indiana | 18159 | 2 | 0 |
14523 | 14523 | 2020-03-27 | Tipton | Indiana | 18159 | 2 | 0 |
16323 | 16323 | 2020-03-28 | Tipton | Indiana | 18159 | 2 | 0 |
18228 | 18228 | 2020-03-29 | Tipton | Indiana | 18159 | 4 | 0 |
20234 | 20234 | 2020-03-30 | Tipton | Indiana | 18159 | 4 | 0 |
22329 | 22329 | 2020-03-31 | Tipton | Indiana | 18159 | 4 | 0 |
8074 | 8074 | 2020-03-22 | Tipton | Tennessee | 47167 | 5 | 0 |
9292 | 9292 | 2020-03-23 | Tipton | Tennessee | 47167 | 5 | 0 |
24500 | 24500 | 2020-04-01 | Tipton | Indiana | 18159 | 5 | 0 |
26740 | 26740 | 2020-04-02 | Tipton | Indiana | 18159 | 5 | 0 |
29051 | 29051 | 2020-04-03 | Tipton | Indiana | 18159 | 5 | 0 |
10626 | 10626 | 2020-03-24 | Tipton | Tennessee | 47167 | 6 | 0 |
12105 | 12105 | 2020-03-25 | Tipton | Tennessee | 47167 | 6 | 0 |
31418 | 31418 | 2020-04-04 | Tipton | Indiana | 18159 | 6 | 0 |
33829 | 33829 | 2020-04-05 | Tipton | Indiana | 18159 | 6 | 0 |
36283 | 36283 | 2020-04-06 | Tipton | Indiana | 18159 | 6 | 0 |
13731 | 13731 | 2020-03-26 | Tipton | Tennessee | 47167 | 8 | 0 |
38781 | 38781 | 2020-04-07 | Tipton | Indiana | 18159 | 8 | 0 |
41327 | 41327 | 2020-04-08 | Tipton | Indiana | 18159 | 9 | 0 |
43903 | 43903 | 2020-04-09 | Tipton | Indiana | 18159 | 9 | 0 |
46508 | 46508 | 2020-04-10 | Tipton | Indiana | 18159 | 9 | 0 |
49142 | 49142 | 2020-04-11 | Tipton | Indiana | 18159 | 9 | 0 |
51806 | 51806 | 2020-04-12 | Tipton | Indiana | 18159 | 9 | 0 |
15484 | 15484 | 2020-03-27 | Tipton | Tennessee | 47167 | 10 | 0 |
54487 | 54487 | 2020-04-13 | Tipton | Indiana | 18159 | 10 | 0 |
57180 | 57180 | 2020-04-14 | Tipton | Indiana | 18159 | 10 | 0 |
59888 | 59888 | 2020-04-15 | Tipton | Indiana | 18159 | 10 | 0 |
62609 | 62609 | 2020-04-16 | Tipton | Indiana | 18159 | 10 | 1 |
65343 | 65343 | 2020-04-17 | Tipton | Indiana | 18159 | 10 | 1 |
68092 | 68092 | 2020-04-18 | Tipton | Indiana | 18159 | 10 | 1 |
17348 | 17348 | 2020-03-28 | Tipton | Tennessee | 47167 | 11 | 0 |
70854 | 70854 | 2020-04-19 | Tipton | Indiana | 18159 | 13 | 1 |
73625 | 73625 | 2020-04-20 | Tipton | Indiana | 18159 | 13 | 1 |
76402 | 76402 | 2020-04-21 | Tipton | Indiana | 18159 | 14 | 1 |
79186 | 79186 | 2020-04-22 | Tipton | Indiana | 18159 | 14 | 1 |
81979 | 81979 | 2020-04-23 | Tipton | Indiana | 18159 | 14 | 1 |
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 |
84779 | 84779 | 2020-04-24 | Tipton | Indiana | 18159 | 17 | 1 |
87589 | 87589 | 2020-04-25 | Tipton | Indiana | 18159 | 17 | 1 |
90405 | 90405 | 2020-04-26 | Tipton | Indiana | 18159 | 17 | 1 |
93224 | 93224 | 2020-04-27 | Tipton | Indiana | 18159 | 18 | 1 |
96056 | 96056 | 2020-04-28 | Tipton | Indiana | 18159 | 18 | 1 |
98900 | 98900 | 2020-04-29 | Tipton | Indiana | 18159 | 18 | 1 |
101751 | 101751 | 2020-04-30 | Tipton | Indiana | 18159 | 18 | 1 |
104607 | 104607 | 2020-05-01 | Tipton | Indiana | 18159 | 20 | 1 |
107472 | 107472 | 2020-05-02 | Tipton | Indiana | 18159 | 20 | 1 |
110342 | 110342 | 2020-05-03 | Tipton | Indiana | 18159 | 20 | 1 |
113217 | 113217 | 2020-05-04 | Tipton | Indiana | 18159 | 20 | 1 |
116100 | 116100 | 2020-05-05 | Tipton | Indiana | 18159 | 20 | 1 |
119060 | 119060 | 2020-05-06 | Tipton | Indiana | 18159 | 20 | 1 |
122030 | 122030 | 2020-05-07 | Tipton | Indiana | 18159 | 20 | 1 |
125010 | 125010 | 2020-05-08 | Tipton | Indiana | 18159 | 20 | 1 |
127997 | 127997 | 2020-05-09 | Tipton | Indiana | 18159 | 21 | 1 |
130988 | 130988 | 2020-05-10 | Tipton | Indiana | 18159 | 21 | 1 |
133978 | 133978 | 2020-05-11 | Tipton | Indiana | 18159 | 21 | 1 |
136967 | 136967 | 2020-05-12 | Tipton | Indiana | 18159 | 21 | 1 |
139959 | 139959 | 2020-05-13 | Tipton | Indiana | 18159 | 21 | 1 |
142955 | 142955 | 2020-05-14 | Tipton | Indiana | 18159 | 21 | 1 |
145955 | 145955 | 2020-05-15 | Tipton | Indiana | 18159 | 21 | 1 |
148959 | 148959 | 2020-05-16 | Tipton | Indiana | 18159 | 21 | 1 |
151968 | 151968 | 2020-05-17 | Tipton | Indiana | 18159 | 21 | 1 |
154980 | 154980 | 2020-05-18 | Tipton | Indiana | 18159 | 21 | 1 |
157996 | 157996 | 2020-05-19 | Tipton | Indiana | 18159 | 21 | 1 |
161022 | 161022 | 2020-05-20 | Tipton | Indiana | 18159 | 21 | 1 |
164050 | 164050 | 2020-05-21 | Tipton | Indiana | 18159 | 21 | 1 |
167083 | 167083 | 2020-05-22 | Tipton | Indiana | 18159 | 21 | 1 |
25697 | 25697 | 2020-04-01 | Tipton | Tennessee | 47167 | 22 | 0 |
170120 | 170120 | 2020-05-23 | Tipton | Indiana | 18159 | 22 | 1 |
173161 | 173161 | 2020-05-24 | Tipton | Indiana | 18159 | 22 | 1 |
176205 | 176205 | 2020-05-25 | Tipton | Indiana | 18159 | 22 | 1 |
27977 | 27977 | 2020-04-02 | Tipton | Tennessee | 47167 | 24 | 0 |
179249 | 179249 | 2020-05-26 | Tipton | Indiana | 18159 | 25 | 1 |
182293 | 182293 | 2020-05-27 | Tipton | Indiana | 18159 | 25 | 2 |
185347 | 185347 | 2020-05-28 | Tipton | Indiana | 18159 | 25 | 2 |
188405 | 188405 | 2020-05-29 | Tipton | Indiana | 18159 | 26 | 2 |
191470 | 191470 | 2020-05-30 | Tipton | Indiana | 18159 | 26 | 2 |
194537 | 194537 | 2020-05-31 | Tipton | Indiana | 18159 | 26 | 2 |
197607 | 197607 | 2020-06-01 | Tipton | Indiana | 18159 | 26 | 2 |
200680 | 200680 | 2020-06-02 | Tipton | Indiana | 18159 | 26 | 2 |
203756 | 203756 | 2020-06-03 | Tipton | Indiana | 18159 | 27 | 2 |
206836 | 206836 | 2020-06-04 | Tipton | Indiana | 18159 | 27 | 2 |
209917 | 209917 | 2020-06-05 | Tipton | Indiana | 18159 | 27 | 2 |
213002 | 213002 | 2020-06-06 | Tipton | Indiana | 18159 | 27 | 2 |
216089 | 216089 | 2020-06-07 | Tipton | Indiana | 18159 | 27 | 2 |
219181 | 219181 | 2020-06-08 | Tipton | Indiana | 18159 | 27 | 2 |
30312 | 30312 | 2020-04-03 | Tipton | Tennessee | 47167 | 28 | 0 |
222276 | 222276 | 2020-06-09 | Tipton | Indiana | 18159 | 28 | 2 |
225371 | 225371 | 2020-06-10 | Tipton | Indiana | 18159 | 28 | 2 |
228473 | 228473 | 2020-06-11 | Tipton | Indiana | 18159 | 28 | 2 |
231576 | 231576 | 2020-06-12 | Tipton | Indiana | 18159 | 28 | 2 |
234682 | 234682 | 2020-06-13 | Tipton | Indiana | 18159 | 28 | 2 |
237789 | 237789 | 2020-06-14 | Tipton | Indiana | 18159 | 29 | 2 |
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);