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 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 |
7448 | 7448 | 2020-03-22 | Tipton | Indiana | 18159 | 1 | 0 |
8074 | 8074 | 2020-03-22 | Tipton | Tennessee | 47167 | 5 | 0 |
8606 | 8606 | 2020-03-23 | Tipton | Indiana | 18159 | 2 | 0 |
9292 | 9292 | 2020-03-23 | Tipton | Tennessee | 47167 | 5 | 0 |
9881 | 9881 | 2020-03-24 | Tipton | Indiana | 18159 | 2 | 0 |
10626 | 10626 | 2020-03-24 | Tipton | Tennessee | 47167 | 6 | 0 |
11277 | 11277 | 2020-03-25 | Tipton | Indiana | 18159 | 2 | 0 |
12105 | 12105 | 2020-03-25 | Tipton | Tennessee | 47167 | 6 | 0 |
12837 | 12837 | 2020-03-26 | Tipton | Indiana | 18159 | 2 | 0 |
13731 | 13731 | 2020-03-26 | Tipton | Tennessee | 47167 | 8 | 0 |
14523 | 14523 | 2020-03-27 | Tipton | Indiana | 18159 | 2 | 0 |
15484 | 15484 | 2020-03-27 | Tipton | Tennessee | 47167 | 10 | 0 |
16323 | 16323 | 2020-03-28 | Tipton | Indiana | 18159 | 2 | 0 |
17348 | 17348 | 2020-03-28 | Tipton | Tennessee | 47167 | 11 | 0 |
18228 | 18228 | 2020-03-29 | Tipton | Indiana | 18159 | 4 | 0 |
19298 | 19298 | 2020-03-29 | Tipton | Tennessee | 47167 | 15 | 0 |
20234 | 20234 | 2020-03-30 | Tipton | Indiana | 18159 | 4 | 0 |
21355 | 21355 | 2020-03-30 | Tipton | Tennessee | 47167 | 16 | 0 |
22329 | 22329 | 2020-03-31 | Tipton | Indiana | 18159 | 4 | 0 |
23494 | 23494 | 2020-03-31 | Tipton | Tennessee | 47167 | 16 | 0 |
24500 | 24500 | 2020-04-01 | Tipton | Indiana | 18159 | 5 | 0 |
25697 | 25697 | 2020-04-01 | Tipton | Tennessee | 47167 | 22 | 0 |
26740 | 26740 | 2020-04-02 | Tipton | Indiana | 18159 | 5 | 0 |
27977 | 27977 | 2020-04-02 | Tipton | Tennessee | 47167 | 24 | 0 |
29051 | 29051 | 2020-04-03 | Tipton | Indiana | 18159 | 5 | 0 |
30312 | 30312 | 2020-04-03 | Tipton | Tennessee | 47167 | 28 | 0 |
31418 | 31418 | 2020-04-04 | Tipton | Indiana | 18159 | 6 | 0 |
32704 | 32704 | 2020-04-04 | Tipton | Tennessee | 47167 | 31 | 0 |
33829 | 33829 | 2020-04-05 | Tipton | Indiana | 18159 | 6 | 0 |
35141 | 35141 | 2020-04-05 | Tipton | Tennessee | 47167 | 33 | 0 |
36283 | 36283 | 2020-04-06 | Tipton | Indiana | 18159 | 6 | 0 |
37617 | 37617 | 2020-04-06 | Tipton | Tennessee | 47167 | 36 | 0 |
38781 | 38781 | 2020-04-07 | Tipton | Indiana | 18159 | 8 | 0 |
40140 | 40140 | 2020-04-07 | Tipton | Tennessee | 47167 | 38 | 0 |
41327 | 41327 | 2020-04-08 | Tipton | Indiana | 18159 | 9 | 0 |
42702 | 42702 | 2020-04-08 | Tipton | Tennessee | 47167 | 38 | 0 |
43903 | 43903 | 2020-04-09 | Tipton | Indiana | 18159 | 9 | 0 |
45289 | 45289 | 2020-04-09 | Tipton | Tennessee | 47167 | 39 | 0 |
46508 | 46508 | 2020-04-10 | Tipton | Indiana | 18159 | 9 | 0 |
47907 | 47907 | 2020-04-10 | Tipton | Tennessee | 47167 | 43 | 0 |
49142 | 49142 | 2020-04-11 | Tipton | Indiana | 18159 | 9 | 0 |
50565 | 50565 | 2020-04-11 | Tipton | Tennessee | 47167 | 44 | 0 |
51806 | 51806 | 2020-04-12 | Tipton | Indiana | 18159 | 9 | 0 |
53240 | 53240 | 2020-04-12 | Tipton | Tennessee | 47167 | 44 | 0 |
54487 | 54487 | 2020-04-13 | Tipton | Indiana | 18159 | 10 | 0 |
55927 | 55927 | 2020-04-13 | Tipton | Tennessee | 47167 | 50 | 0 |
57180 | 57180 | 2020-04-14 | Tipton | Indiana | 18159 | 10 | 0 |
58630 | 58630 | 2020-04-14 | Tipton | Tennessee | 47167 | 52 | 0 |
59888 | 59888 | 2020-04-15 | Tipton | Indiana | 18159 | 10 | 0 |
61346 | 61346 | 2020-04-15 | Tipton | Tennessee | 47167 | 53 | 0 |
62609 | 62609 | 2020-04-16 | Tipton | Indiana | 18159 | 10 | 1 |
64073 | 64073 | 2020-04-16 | Tipton | Tennessee | 47167 | 54 | 0 |
65343 | 65343 | 2020-04-17 | Tipton | Indiana | 18159 | 10 | 1 |
66820 | 66820 | 2020-04-17 | Tipton | Tennessee | 47167 | 55 | 0 |
68092 | 68092 | 2020-04-18 | Tipton | Indiana | 18159 | 10 | 1 |
69579 | 69579 | 2020-04-18 | Tipton | Tennessee | 47167 | 57 | 0 |
70854 | 70854 | 2020-04-19 | Tipton | Indiana | 18159 | 13 | 1 |
72346 | 72346 | 2020-04-19 | Tipton | Tennessee | 47167 | 56 | 0 |
73625 | 73625 | 2020-04-20 | Tipton | Indiana | 18159 | 13 | 1 |
75121 | 75121 | 2020-04-20 | Tipton | Tennessee | 47167 | 83 | 0 |
76402 | 76402 | 2020-04-21 | Tipton | Indiana | 18159 | 14 | 1 |
77903 | 77903 | 2020-04-21 | Tipton | Tennessee | 47167 | 83 | 0 |
79186 | 79186 | 2020-04-22 | Tipton | Indiana | 18159 | 14 | 1 |
80693 | 80693 | 2020-04-22 | Tipton | Tennessee | 47167 | 83 | 0 |
81979 | 81979 | 2020-04-23 | Tipton | Indiana | 18159 | 14 | 1 |
83492 | 83492 | 2020-04-23 | Tipton | Tennessee | 47167 | 87 | 0 |
84779 | 84779 | 2020-04-24 | Tipton | Indiana | 18159 | 17 | 1 |
86297 | 86297 | 2020-04-24 | Tipton | Tennessee | 47167 | 88 | 0 |
87589 | 87589 | 2020-04-25 | Tipton | Indiana | 18159 | 17 | 1 |
89112 | 89112 | 2020-04-25 | Tipton | Tennessee | 47167 | 91 | 0 |
90405 | 90405 | 2020-04-26 | Tipton | Indiana | 18159 | 17 | 1 |
91929 | 91929 | 2020-04-26 | Tipton | Tennessee | 47167 | 94 | 0 |
93224 | 93224 | 2020-04-27 | Tipton | Indiana | 18159 | 18 | 1 |
94757 | 94757 | 2020-04-27 | Tipton | Tennessee | 47167 | 95 | 0 |
96056 | 96056 | 2020-04-28 | Tipton | Indiana | 18159 | 18 | 1 |
97597 | 97597 | 2020-04-28 | Tipton | Tennessee | 47167 | 96 | 0 |
98900 | 98900 | 2020-04-29 | Tipton | Indiana | 18159 | 18 | 1 |
100447 | 100447 | 2020-04-29 | Tipton | Tennessee | 47167 | 98 | 0 |
101751 | 101751 | 2020-04-30 | Tipton | Indiana | 18159 | 18 | 1 |
103300 | 103300 | 2020-04-30 | Tipton | Tennessee | 47167 | 98 | 0 |
104607 | 104607 | 2020-05-01 | Tipton | Indiana | 18159 | 20 | 1 |
106163 | 106163 | 2020-05-01 | Tipton | Tennessee | 47167 | 98 | 0 |
107472 | 107472 | 2020-05-02 | Tipton | Indiana | 18159 | 20 | 1 |
109030 | 109030 | 2020-05-02 | Tipton | Tennessee | 47167 | 99 | 0 |
110342 | 110342 | 2020-05-03 | Tipton | Indiana | 18159 | 20 | 1 |
111904 | 111904 | 2020-05-03 | Tipton | Tennessee | 47167 | 146 | 0 |
113217 | 113217 | 2020-05-04 | Tipton | Indiana | 18159 | 20 | 1 |
114786 | 114786 | 2020-05-04 | Tipton | Tennessee | 47167 | 148 | 1 |
116100 | 116100 | 2020-05-05 | Tipton | Indiana | 18159 | 20 | 1 |
117742 | 117742 | 2020-05-05 | Tipton | Tennessee | 47167 | 149 | 1 |
119060 | 119060 | 2020-05-06 | Tipton | Indiana | 18159 | 20 | 1 |
120706 | 120706 | 2020-05-06 | Tipton | Tennessee | 47167 | 155 | 2 |
122030 | 122030 | 2020-05-07 | Tipton | Indiana | 18159 | 20 | 1 |
123684 | 123684 | 2020-05-07 | Tipton | Tennessee | 47167 | 158 | 2 |
125010 | 125010 | 2020-05-08 | Tipton | Indiana | 18159 | 20 | 1 |
126667 | 126667 | 2020-05-08 | Tipton | Tennessee | 47167 | 158 | 2 |
127997 | 127997 | 2020-05-09 | Tipton | Indiana | 18159 | 21 | 1 |
129656 | 129656 | 2020-05-09 | Tipton | Tennessee | 47167 | 158 | 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);