ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Warren" and fips = 47177 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
21360 | 21360 | 2020-03-30 | Warren | Tennessee | 47177 | 1 | 0 |
23499 | 23499 | 2020-03-31 | Warren | Tennessee | 47177 | 1 | 0 |
25702 | 25702 | 2020-04-01 | Warren | Tennessee | 47177 | 1 | 0 |
27982 | 27982 | 2020-04-02 | Warren | Tennessee | 47177 | 1 | 0 |
30317 | 30317 | 2020-04-03 | Warren | Tennessee | 47177 | 1 | 0 |
32709 | 32709 | 2020-04-04 | Warren | Tennessee | 47177 | 1 | 0 |
35146 | 35146 | 2020-04-05 | Warren | Tennessee | 47177 | 1 | 0 |
37622 | 37622 | 2020-04-06 | Warren | Tennessee | 47177 | 1 | 0 |
40144 | 40144 | 2020-04-07 | Warren | Tennessee | 47177 | 2 | 0 |
42706 | 42706 | 2020-04-08 | Warren | Tennessee | 47177 | 2 | 0 |
45294 | 45294 | 2020-04-09 | Warren | Tennessee | 47177 | 3 | 0 |
47912 | 47912 | 2020-04-10 | Warren | Tennessee | 47177 | 3 | 0 |
50569 | 50569 | 2020-04-11 | Warren | Tennessee | 47177 | 4 | 0 |
53244 | 53244 | 2020-04-12 | Warren | Tennessee | 47177 | 4 | 0 |
55932 | 55932 | 2020-04-13 | Warren | Tennessee | 47177 | 4 | 0 |
58635 | 58635 | 2020-04-14 | Warren | Tennessee | 47177 | 4 | 0 |
61351 | 61351 | 2020-04-15 | Warren | Tennessee | 47177 | 4 | 0 |
64078 | 64078 | 2020-04-16 | Warren | Tennessee | 47177 | 4 | 0 |
66825 | 66825 | 2020-04-17 | Warren | Tennessee | 47177 | 4 | 0 |
69584 | 69584 | 2020-04-18 | Warren | Tennessee | 47177 | 4 | 0 |
72351 | 72351 | 2020-04-19 | Warren | Tennessee | 47177 | 5 | 0 |
75126 | 75126 | 2020-04-20 | Warren | Tennessee | 47177 | 5 | 0 |
77908 | 77908 | 2020-04-21 | Warren | Tennessee | 47177 | 4 | 0 |
80698 | 80698 | 2020-04-22 | Warren | Tennessee | 47177 | 4 | 0 |
83497 | 83497 | 2020-04-23 | Warren | Tennessee | 47177 | 4 | 0 |
86302 | 86302 | 2020-04-24 | Warren | Tennessee | 47177 | 5 | 0 |
89117 | 89117 | 2020-04-25 | Warren | Tennessee | 47177 | 5 | 0 |
91934 | 91934 | 2020-04-26 | Warren | Tennessee | 47177 | 5 | 0 |
94762 | 94762 | 2020-04-27 | Warren | Tennessee | 47177 | 7 | 0 |
97602 | 97602 | 2020-04-28 | Warren | Tennessee | 47177 | 7 | 0 |
100452 | 100452 | 2020-04-29 | Warren | Tennessee | 47177 | 7 | 0 |
103305 | 103305 | 2020-04-30 | Warren | Tennessee | 47177 | 7 | 0 |
106168 | 106168 | 2020-05-01 | Warren | Tennessee | 47177 | 8 | 0 |
109035 | 109035 | 2020-05-02 | Warren | Tennessee | 47177 | 8 | 0 |
111909 | 111909 | 2020-05-03 | Warren | Tennessee | 47177 | 8 | 0 |
114791 | 114791 | 2020-05-04 | Warren | Tennessee | 47177 | 8 | 0 |
117747 | 117747 | 2020-05-05 | Warren | Tennessee | 47177 | 8 | 0 |
120711 | 120711 | 2020-05-06 | Warren | Tennessee | 47177 | 10 | 0 |
123690 | 123690 | 2020-05-07 | Warren | Tennessee | 47177 | 10 | 0 |
126673 | 126673 | 2020-05-08 | Warren | Tennessee | 47177 | 10 | 0 |
129662 | 129662 | 2020-05-09 | Warren | Tennessee | 47177 | 12 | 0 |
132652 | 132652 | 2020-05-10 | Warren | Tennessee | 47177 | 12 | 0 |
135643 | 135643 | 2020-05-11 | Warren | Tennessee | 47177 | 12 | 0 |
138633 | 138633 | 2020-05-12 | Warren | Tennessee | 47177 | 13 | 0 |
141629 | 141629 | 2020-05-13 | Warren | Tennessee | 47177 | 13 | 0 |
144626 | 144626 | 2020-05-14 | Warren | Tennessee | 47177 | 14 | 0 |
147627 | 147627 | 2020-05-15 | Warren | Tennessee | 47177 | 14 | 0 |
150635 | 150635 | 2020-05-16 | Warren | Tennessee | 47177 | 15 | 0 |
153646 | 153646 | 2020-05-17 | Warren | Tennessee | 47177 | 15 | 0 |
156663 | 156663 | 2020-05-18 | Warren | Tennessee | 47177 | 16 | 0 |
159685 | 159685 | 2020-05-19 | Warren | Tennessee | 47177 | 16 | 0 |
162712 | 162712 | 2020-05-20 | Warren | Tennessee | 47177 | 16 | 0 |
165741 | 165741 | 2020-05-21 | Warren | Tennessee | 47177 | 16 | 0 |
168777 | 168777 | 2020-05-22 | Warren | Tennessee | 47177 | 16 | 0 |
171816 | 171816 | 2020-05-23 | Warren | Tennessee | 47177 | 19 | 0 |
174859 | 174859 | 2020-05-24 | Warren | Tennessee | 47177 | 19 | 0 |
177903 | 177903 | 2020-05-25 | Warren | Tennessee | 47177 | 21 | 0 |
180946 | 180946 | 2020-05-26 | Warren | Tennessee | 47177 | 21 | 0 |
183996 | 183996 | 2020-05-27 | Warren | Tennessee | 47177 | 22 | 0 |
187053 | 187053 | 2020-05-28 | Warren | Tennessee | 47177 | 22 | 0 |
190117 | 190117 | 2020-05-29 | Warren | Tennessee | 47177 | 23 | 0 |
193182 | 193182 | 2020-05-30 | Warren | Tennessee | 47177 | 23 | 0 |
196252 | 196252 | 2020-05-31 | Warren | Tennessee | 47177 | 23 | 0 |
199325 | 199325 | 2020-06-01 | Warren | Tennessee | 47177 | 23 | 0 |
202400 | 202400 | 2020-06-02 | Warren | Tennessee | 47177 | 26 | 0 |
205479 | 205479 | 2020-06-03 | Warren | Tennessee | 47177 | 26 | 0 |
208561 | 208561 | 2020-06-04 | Warren | Tennessee | 47177 | 26 | 0 |
211643 | 211643 | 2020-06-05 | Warren | Tennessee | 47177 | 27 | 0 |
214730 | 214730 | 2020-06-06 | Warren | Tennessee | 47177 | 28 | 0 |
217820 | 217820 | 2020-06-07 | Warren | Tennessee | 47177 | 28 | 0 |
220912 | 220912 | 2020-06-08 | Warren | Tennessee | 47177 | 31 | 0 |
224007 | 224007 | 2020-06-09 | Warren | Tennessee | 47177 | 32 | 0 |
227107 | 227107 | 2020-06-10 | Warren | Tennessee | 47177 | 32 | 0 |
230211 | 230211 | 2020-06-11 | Warren | Tennessee | 47177 | 32 | 0 |
233315 | 233315 | 2020-06-12 | Warren | Tennessee | 47177 | 32 | 0 |
236421 | 236421 | 2020-06-13 | Warren | Tennessee | 47177 | 32 | 0 |
239529 | 239529 | 2020-06-14 | Warren | Tennessee | 47177 | 33 | 0 |
242639 | 242639 | 2020-06-15 | Warren | Tennessee | 47177 | 33 | 0 |
245751 | 245751 | 2020-06-16 | Warren | Tennessee | 47177 | 35 | 0 |
248864 | 248864 | 2020-06-17 | Warren | Tennessee | 47177 | 35 | 0 |
251979 | 251979 | 2020-06-18 | Warren | Tennessee | 47177 | 36 | 0 |
255094 | 255094 | 2020-06-19 | Warren | Tennessee | 47177 | 36 | 0 |
258220 | 258220 | 2020-06-20 | Warren | Tennessee | 47177 | 33 | 0 |
261347 | 261347 | 2020-06-21 | Warren | Tennessee | 47177 | 34 | 0 |
264475 | 264475 | 2020-06-22 | Warren | Tennessee | 47177 | 34 | 0 |
267603 | 267603 | 2020-06-23 | Warren | Tennessee | 47177 | 39 | 0 |
270737 | 270737 | 2020-06-24 | Warren | Tennessee | 47177 | 46 | 0 |
273876 | 273876 | 2020-06-25 | Warren | Tennessee | 47177 | 47 | 0 |
277023 | 277023 | 2020-06-26 | Warren | Tennessee | 47177 | 50 | 0 |
280171 | 280171 | 2020-06-27 | Warren | Tennessee | 47177 | 55 | 0 |
283317 | 283317 | 2020-06-28 | Warren | Tennessee | 47177 | 55 | 0 |
286463 | 286463 | 2020-06-29 | Warren | Tennessee | 47177 | 58 | 0 |
289613 | 289613 | 2020-06-30 | Warren | Tennessee | 47177 | 62 | 0 |
292766 | 292766 | 2020-07-01 | Warren | Tennessee | 47177 | 65 | 0 |
295921 | 295921 | 2020-07-02 | Warren | Tennessee | 47177 | 69 | 0 |
299081 | 299081 | 2020-07-03 | Warren | Tennessee | 47177 | 72 | 0 |
302245 | 302245 | 2020-07-04 | Warren | Tennessee | 47177 | 73 | 0 |
305409 | 305409 | 2020-07-05 | Warren | Tennessee | 47177 | 76 | 0 |
308577 | 308577 | 2020-07-06 | Warren | Tennessee | 47177 | 78 | 0 |
311746 | 311746 | 2020-07-07 | Warren | Tennessee | 47177 | 81 | 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);