ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Fayette" and state = "Tennessee" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- 2020-04-19 1
- …
state 1
- Tennessee · 784 ✖
fips 1
- 47047 784
county 1
- Fayette · 784 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
6926 | 6926 | 2020-03-21 | Fayette | Tennessee | 47047 | 1 | 0 |
8049 | 8049 | 2020-03-22 | Fayette | Tennessee | 47047 | 3 | 0 |
9267 | 9267 | 2020-03-23 | Fayette | Tennessee | 47047 | 3 | 0 |
10596 | 10596 | 2020-03-24 | Fayette | Tennessee | 47047 | 3 | 0 |
12073 | 12073 | 2020-03-25 | Fayette | Tennessee | 47047 | 3 | 0 |
13697 | 13697 | 2020-03-26 | Fayette | Tennessee | 47047 | 3 | 0 |
15449 | 15449 | 2020-03-27 | Fayette | Tennessee | 47047 | 3 | 0 |
17310 | 17310 | 2020-03-28 | Fayette | Tennessee | 47047 | 4 | 0 |
19256 | 19256 | 2020-03-29 | Fayette | Tennessee | 47047 | 10 | 0 |
21309 | 21309 | 2020-03-30 | Fayette | Tennessee | 47047 | 10 | 0 |
23447 | 23447 | 2020-03-31 | Fayette | Tennessee | 47047 | 12 | 0 |
25646 | 25646 | 2020-04-01 | Fayette | Tennessee | 47047 | 14 | 0 |
27924 | 27924 | 2020-04-02 | Fayette | Tennessee | 47047 | 14 | 0 |
30259 | 30259 | 2020-04-03 | Fayette | Tennessee | 47047 | 17 | 0 |
32650 | 32650 | 2020-04-04 | Fayette | Tennessee | 47047 | 18 | 0 |
35086 | 35086 | 2020-04-05 | Fayette | Tennessee | 47047 | 20 | 0 |
37562 | 37562 | 2020-04-06 | Fayette | Tennessee | 47047 | 21 | 0 |
40085 | 40085 | 2020-04-07 | Fayette | Tennessee | 47047 | 21 | 0 |
42647 | 42647 | 2020-04-08 | Fayette | Tennessee | 47047 | 22 | 0 |
45234 | 45234 | 2020-04-09 | Fayette | Tennessee | 47047 | 25 | 0 |
47852 | 47852 | 2020-04-10 | Fayette | Tennessee | 47047 | 28 | 0 |
50510 | 50510 | 2020-04-11 | Fayette | Tennessee | 47047 | 30 | 0 |
53185 | 53185 | 2020-04-12 | Fayette | Tennessee | 47047 | 30 | 0 |
55871 | 55871 | 2020-04-13 | Fayette | Tennessee | 47047 | 36 | 0 |
58574 | 58574 | 2020-04-14 | Fayette | Tennessee | 47047 | 37 | 0 |
61289 | 61289 | 2020-04-15 | Fayette | Tennessee | 47047 | 39 | 1 |
64016 | 64016 | 2020-04-16 | Fayette | Tennessee | 47047 | 42 | 1 |
66762 | 66762 | 2020-04-17 | Fayette | Tennessee | 47047 | 44 | 1 |
69521 | 69521 | 2020-04-18 | Fayette | Tennessee | 47047 | 45 | 1 |
72288 | 72288 | 2020-04-19 | Fayette | Tennessee | 47047 | 45 | 1 |
75063 | 75063 | 2020-04-20 | Fayette | Tennessee | 47047 | 46 | 1 |
77845 | 77845 | 2020-04-21 | Fayette | Tennessee | 47047 | 48 | 1 |
80635 | 80635 | 2020-04-22 | Fayette | Tennessee | 47047 | 48 | 1 |
83434 | 83434 | 2020-04-23 | Fayette | Tennessee | 47047 | 48 | 1 |
86239 | 86239 | 2020-04-24 | Fayette | Tennessee | 47047 | 48 | 1 |
89054 | 89054 | 2020-04-25 | Fayette | Tennessee | 47047 | 51 | 1 |
91871 | 91871 | 2020-04-26 | Fayette | Tennessee | 47047 | 52 | 1 |
94699 | 94699 | 2020-04-27 | Fayette | Tennessee | 47047 | 52 | 1 |
97539 | 97539 | 2020-04-28 | Fayette | Tennessee | 47047 | 53 | 1 |
100389 | 100389 | 2020-04-29 | Fayette | Tennessee | 47047 | 53 | 1 |
103242 | 103242 | 2020-04-30 | Fayette | Tennessee | 47047 | 56 | 1 |
106105 | 106105 | 2020-05-01 | Fayette | Tennessee | 47047 | 59 | 1 |
108972 | 108972 | 2020-05-02 | Fayette | Tennessee | 47047 | 59 | 1 |
111846 | 111846 | 2020-05-03 | Fayette | Tennessee | 47047 | 63 | 1 |
114728 | 114728 | 2020-05-04 | Fayette | Tennessee | 47047 | 68 | 1 |
117684 | 117684 | 2020-05-05 | Fayette | Tennessee | 47047 | 69 | 1 |
120648 | 120648 | 2020-05-06 | Fayette | Tennessee | 47047 | 73 | 1 |
123626 | 123626 | 2020-05-07 | Fayette | Tennessee | 47047 | 73 | 1 |
126609 | 126609 | 2020-05-08 | Fayette | Tennessee | 47047 | 75 | 1 |
129598 | 129598 | 2020-05-09 | Fayette | Tennessee | 47047 | 77 | 1 |
132587 | 132587 | 2020-05-10 | Fayette | Tennessee | 47047 | 79 | 1 |
135578 | 135578 | 2020-05-11 | Fayette | Tennessee | 47047 | 80 | 1 |
138568 | 138568 | 2020-05-12 | Fayette | Tennessee | 47047 | 82 | 1 |
141564 | 141564 | 2020-05-13 | Fayette | Tennessee | 47047 | 85 | 1 |
144561 | 144561 | 2020-05-14 | Fayette | Tennessee | 47047 | 86 | 2 |
147562 | 147562 | 2020-05-15 | Fayette | Tennessee | 47047 | 88 | 2 |
150570 | 150570 | 2020-05-16 | Fayette | Tennessee | 47047 | 88 | 2 |
153581 | 153581 | 2020-05-17 | Fayette | Tennessee | 47047 | 90 | 2 |
156598 | 156598 | 2020-05-18 | Fayette | Tennessee | 47047 | 94 | 2 |
159619 | 159619 | 2020-05-19 | Fayette | Tennessee | 47047 | 95 | 2 |
162646 | 162646 | 2020-05-20 | Fayette | Tennessee | 47047 | 95 | 2 |
165675 | 165675 | 2020-05-21 | Fayette | Tennessee | 47047 | 98 | 2 |
168711 | 168711 | 2020-05-22 | Fayette | Tennessee | 47047 | 100 | 2 |
171750 | 171750 | 2020-05-23 | Fayette | Tennessee | 47047 | 104 | 2 |
174793 | 174793 | 2020-05-24 | Fayette | Tennessee | 47047 | 107 | 2 |
177837 | 177837 | 2020-05-25 | Fayette | Tennessee | 47047 | 107 | 2 |
180880 | 180880 | 2020-05-26 | Fayette | Tennessee | 47047 | 108 | 2 |
183930 | 183930 | 2020-05-27 | Fayette | Tennessee | 47047 | 110 | 2 |
186987 | 186987 | 2020-05-28 | Fayette | Tennessee | 47047 | 110 | 2 |
190051 | 190051 | 2020-05-29 | Fayette | Tennessee | 47047 | 112 | 2 |
193116 | 193116 | 2020-05-30 | Fayette | Tennessee | 47047 | 115 | 2 |
196186 | 196186 | 2020-05-31 | Fayette | Tennessee | 47047 | 115 | 2 |
199259 | 199259 | 2020-06-01 | Fayette | Tennessee | 47047 | 115 | 2 |
202334 | 202334 | 2020-06-02 | Fayette | Tennessee | 47047 | 121 | 2 |
205413 | 205413 | 2020-06-03 | Fayette | Tennessee | 47047 | 125 | 2 |
208495 | 208495 | 2020-06-04 | Fayette | Tennessee | 47047 | 136 | 2 |
211577 | 211577 | 2020-06-05 | Fayette | Tennessee | 47047 | 144 | 2 |
214664 | 214664 | 2020-06-06 | Fayette | Tennessee | 47047 | 152 | 2 |
217754 | 217754 | 2020-06-07 | Fayette | Tennessee | 47047 | 151 | 2 |
220846 | 220846 | 2020-06-08 | Fayette | Tennessee | 47047 | 155 | 2 |
223941 | 223941 | 2020-06-09 | Fayette | Tennessee | 47047 | 159 | 2 |
227041 | 227041 | 2020-06-10 | Fayette | Tennessee | 47047 | 162 | 2 |
230145 | 230145 | 2020-06-11 | Fayette | Tennessee | 47047 | 163 | 2 |
233250 | 233250 | 2020-06-12 | Fayette | Tennessee | 47047 | 167 | 2 |
236356 | 236356 | 2020-06-13 | Fayette | Tennessee | 47047 | 169 | 2 |
239464 | 239464 | 2020-06-14 | Fayette | Tennessee | 47047 | 172 | 2 |
242574 | 242574 | 2020-06-15 | Fayette | Tennessee | 47047 | 177 | 2 |
245686 | 245686 | 2020-06-16 | Fayette | Tennessee | 47047 | 183 | 2 |
248799 | 248799 | 2020-06-17 | Fayette | Tennessee | 47047 | 186 | 2 |
251914 | 251914 | 2020-06-18 | Fayette | Tennessee | 47047 | 189 | 2 |
255029 | 255029 | 2020-06-19 | Fayette | Tennessee | 47047 | 193 | 2 |
258155 | 258155 | 2020-06-20 | Fayette | Tennessee | 47047 | 193 | 2 |
261282 | 261282 | 2020-06-21 | Fayette | Tennessee | 47047 | 195 | 2 |
264410 | 264410 | 2020-06-22 | Fayette | Tennessee | 47047 | 203 | 2 |
267538 | 267538 | 2020-06-23 | Fayette | Tennessee | 47047 | 213 | 2 |
270672 | 270672 | 2020-06-24 | Fayette | Tennessee | 47047 | 224 | 2 |
273811 | 273811 | 2020-06-25 | Fayette | Tennessee | 47047 | 229 | 2 |
276958 | 276958 | 2020-06-26 | Fayette | Tennessee | 47047 | 233 | 2 |
280106 | 280106 | 2020-06-27 | Fayette | Tennessee | 47047 | 244 | 2 |
283252 | 283252 | 2020-06-28 | Fayette | Tennessee | 47047 | 244 | 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);