ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Polk" and fips = 47139 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
27965 | 27965 | 2020-04-02 | Polk | Tennessee | 47139 | 1 | 0 |
30300 | 30300 | 2020-04-03 | Polk | Tennessee | 47139 | 2 | 0 |
32691 | 32691 | 2020-04-04 | Polk | Tennessee | 47139 | 3 | 0 |
35128 | 35128 | 2020-04-05 | Polk | Tennessee | 47139 | 3 | 0 |
37604 | 37604 | 2020-04-06 | Polk | Tennessee | 47139 | 3 | 0 |
40127 | 40127 | 2020-04-07 | Polk | Tennessee | 47139 | 3 | 0 |
42689 | 42689 | 2020-04-08 | Polk | Tennessee | 47139 | 3 | 0 |
45276 | 45276 | 2020-04-09 | Polk | Tennessee | 47139 | 3 | 0 |
47894 | 47894 | 2020-04-10 | Polk | Tennessee | 47139 | 5 | 0 |
50552 | 50552 | 2020-04-11 | Polk | Tennessee | 47139 | 4 | 0 |
53227 | 53227 | 2020-04-12 | Polk | Tennessee | 47139 | 4 | 0 |
55914 | 55914 | 2020-04-13 | Polk | Tennessee | 47139 | 5 | 0 |
58617 | 58617 | 2020-04-14 | Polk | Tennessee | 47139 | 5 | 0 |
61333 | 61333 | 2020-04-15 | Polk | Tennessee | 47139 | 5 | 0 |
64060 | 64060 | 2020-04-16 | Polk | Tennessee | 47139 | 5 | 0 |
66806 | 66806 | 2020-04-17 | Polk | Tennessee | 47139 | 5 | 0 |
69565 | 69565 | 2020-04-18 | Polk | Tennessee | 47139 | 5 | 0 |
72332 | 72332 | 2020-04-19 | Polk | Tennessee | 47139 | 5 | 0 |
75107 | 75107 | 2020-04-20 | Polk | Tennessee | 47139 | 5 | 0 |
77889 | 77889 | 2020-04-21 | Polk | Tennessee | 47139 | 5 | 0 |
80679 | 80679 | 2020-04-22 | Polk | Tennessee | 47139 | 6 | 0 |
83478 | 83478 | 2020-04-23 | Polk | Tennessee | 47139 | 7 | 0 |
86283 | 86283 | 2020-04-24 | Polk | Tennessee | 47139 | 7 | 0 |
89098 | 89098 | 2020-04-25 | Polk | Tennessee | 47139 | 7 | 0 |
91915 | 91915 | 2020-04-26 | Polk | Tennessee | 47139 | 7 | 0 |
94743 | 94743 | 2020-04-27 | Polk | Tennessee | 47139 | 7 | 0 |
97583 | 97583 | 2020-04-28 | Polk | Tennessee | 47139 | 8 | 0 |
100433 | 100433 | 2020-04-29 | Polk | Tennessee | 47139 | 7 | 0 |
103286 | 103286 | 2020-04-30 | Polk | Tennessee | 47139 | 8 | 0 |
106149 | 106149 | 2020-05-01 | Polk | Tennessee | 47139 | 8 | 0 |
109016 | 109016 | 2020-05-02 | Polk | Tennessee | 47139 | 11 | 0 |
111890 | 111890 | 2020-05-03 | Polk | Tennessee | 47139 | 11 | 0 |
114772 | 114772 | 2020-05-04 | Polk | Tennessee | 47139 | 12 | 0 |
117728 | 117728 | 2020-05-05 | Polk | Tennessee | 47139 | 12 | 0 |
120692 | 120692 | 2020-05-06 | Polk | Tennessee | 47139 | 12 | 0 |
123670 | 123670 | 2020-05-07 | Polk | Tennessee | 47139 | 12 | 0 |
126653 | 126653 | 2020-05-08 | Polk | Tennessee | 47139 | 12 | 0 |
129642 | 129642 | 2020-05-09 | Polk | Tennessee | 47139 | 12 | 0 |
132632 | 132632 | 2020-05-10 | Polk | Tennessee | 47139 | 12 | 0 |
135623 | 135623 | 2020-05-11 | Polk | Tennessee | 47139 | 12 | 0 |
138613 | 138613 | 2020-05-12 | Polk | Tennessee | 47139 | 12 | 0 |
141609 | 141609 | 2020-05-13 | Polk | Tennessee | 47139 | 12 | 0 |
144606 | 144606 | 2020-05-14 | Polk | Tennessee | 47139 | 12 | 0 |
147607 | 147607 | 2020-05-15 | Polk | Tennessee | 47139 | 12 | 0 |
150615 | 150615 | 2020-05-16 | Polk | Tennessee | 47139 | 12 | 0 |
153626 | 153626 | 2020-05-17 | Polk | Tennessee | 47139 | 13 | 0 |
156643 | 156643 | 2020-05-18 | Polk | Tennessee | 47139 | 14 | 0 |
159665 | 159665 | 2020-05-19 | Polk | Tennessee | 47139 | 14 | 0 |
162692 | 162692 | 2020-05-20 | Polk | Tennessee | 47139 | 14 | 0 |
165721 | 165721 | 2020-05-21 | Polk | Tennessee | 47139 | 14 | 0 |
168757 | 168757 | 2020-05-22 | Polk | Tennessee | 47139 | 14 | 0 |
171796 | 171796 | 2020-05-23 | Polk | Tennessee | 47139 | 14 | 0 |
174839 | 174839 | 2020-05-24 | Polk | Tennessee | 47139 | 14 | 0 |
177883 | 177883 | 2020-05-25 | Polk | Tennessee | 47139 | 14 | 0 |
180926 | 180926 | 2020-05-26 | Polk | Tennessee | 47139 | 14 | 0 |
183976 | 183976 | 2020-05-27 | Polk | Tennessee | 47139 | 15 | 0 |
187033 | 187033 | 2020-05-28 | Polk | Tennessee | 47139 | 15 | 0 |
190097 | 190097 | 2020-05-29 | Polk | Tennessee | 47139 | 15 | 0 |
193162 | 193162 | 2020-05-30 | Polk | Tennessee | 47139 | 16 | 0 |
196232 | 196232 | 2020-05-31 | Polk | Tennessee | 47139 | 16 | 0 |
199305 | 199305 | 2020-06-01 | Polk | Tennessee | 47139 | 16 | 0 |
202380 | 202380 | 2020-06-02 | Polk | Tennessee | 47139 | 18 | 0 |
205459 | 205459 | 2020-06-03 | Polk | Tennessee | 47139 | 18 | 0 |
208541 | 208541 | 2020-06-04 | Polk | Tennessee | 47139 | 19 | 0 |
211623 | 211623 | 2020-06-05 | Polk | Tennessee | 47139 | 19 | 0 |
214710 | 214710 | 2020-06-06 | Polk | Tennessee | 47139 | 21 | 0 |
217800 | 217800 | 2020-06-07 | Polk | Tennessee | 47139 | 21 | 0 |
220892 | 220892 | 2020-06-08 | Polk | Tennessee | 47139 | 23 | 0 |
223987 | 223987 | 2020-06-09 | Polk | Tennessee | 47139 | 24 | 0 |
227087 | 227087 | 2020-06-10 | Polk | Tennessee | 47139 | 24 | 0 |
230191 | 230191 | 2020-06-11 | Polk | Tennessee | 47139 | 24 | 0 |
233296 | 233296 | 2020-06-12 | Polk | Tennessee | 47139 | 28 | 0 |
236402 | 236402 | 2020-06-13 | Polk | Tennessee | 47139 | 29 | 0 |
239510 | 239510 | 2020-06-14 | Polk | Tennessee | 47139 | 29 | 0 |
242620 | 242620 | 2020-06-15 | Polk | Tennessee | 47139 | 29 | 0 |
245732 | 245732 | 2020-06-16 | Polk | Tennessee | 47139 | 29 | 0 |
248845 | 248845 | 2020-06-17 | Polk | Tennessee | 47139 | 32 | 0 |
251960 | 251960 | 2020-06-18 | Polk | Tennessee | 47139 | 32 | 0 |
255075 | 255075 | 2020-06-19 | Polk | Tennessee | 47139 | 32 | 0 |
258201 | 258201 | 2020-06-20 | Polk | Tennessee | 47139 | 32 | 0 |
261328 | 261328 | 2020-06-21 | Polk | Tennessee | 47139 | 32 | 0 |
264456 | 264456 | 2020-06-22 | Polk | Tennessee | 47139 | 36 | 0 |
267584 | 267584 | 2020-06-23 | Polk | Tennessee | 47139 | 36 | 0 |
270718 | 270718 | 2020-06-24 | Polk | Tennessee | 47139 | 36 | 0 |
273857 | 273857 | 2020-06-25 | Polk | Tennessee | 47139 | 36 | 0 |
277004 | 277004 | 2020-06-26 | Polk | Tennessee | 47139 | 36 | 0 |
280152 | 280152 | 2020-06-27 | Polk | Tennessee | 47139 | 38 | 0 |
283298 | 283298 | 2020-06-28 | Polk | Tennessee | 47139 | 38 | 0 |
286443 | 286443 | 2020-06-29 | Polk | Tennessee | 47139 | 41 | 0 |
289594 | 289594 | 2020-06-30 | Polk | Tennessee | 47139 | 41 | 0 |
292746 | 292746 | 2020-07-01 | Polk | Tennessee | 47139 | 41 | 0 |
295902 | 295902 | 2020-07-02 | Polk | Tennessee | 47139 | 41 | 0 |
299062 | 299062 | 2020-07-03 | Polk | Tennessee | 47139 | 44 | 0 |
302226 | 302226 | 2020-07-04 | Polk | Tennessee | 47139 | 45 | 0 |
305389 | 305389 | 2020-07-05 | Polk | Tennessee | 47139 | 45 | 0 |
308557 | 308557 | 2020-07-06 | Polk | Tennessee | 47139 | 46 | 0 |
311726 | 311726 | 2020-07-07 | Polk | Tennessee | 47139 | 46 | 0 |
314900 | 314900 | 2020-07-08 | Polk | Tennessee | 47139 | 48 | 0 |
318073 | 318073 | 2020-07-09 | Polk | Tennessee | 47139 | 51 | 0 |
321251 | 321251 | 2020-07-10 | Polk | Tennessee | 47139 | 55 | 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);