ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Claiborne" and state = "Tennessee" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
10589 | 10589 | 2020-03-24 | Claiborne | Tennessee | 47025 | 1 | 0 |
12066 | 12066 | 2020-03-25 | Claiborne | Tennessee | 47025 | 1 | 0 |
13690 | 13690 | 2020-03-26 | Claiborne | Tennessee | 47025 | 2 | 0 |
15442 | 15442 | 2020-03-27 | Claiborne | Tennessee | 47025 | 2 | 0 |
17303 | 17303 | 2020-03-28 | Claiborne | Tennessee | 47025 | 2 | 0 |
19248 | 19248 | 2020-03-29 | Claiborne | Tennessee | 47025 | 2 | 0 |
21301 | 21301 | 2020-03-30 | Claiborne | Tennessee | 47025 | 2 | 0 |
23439 | 23439 | 2020-03-31 | Claiborne | Tennessee | 47025 | 2 | 0 |
25637 | 25637 | 2020-04-01 | Claiborne | Tennessee | 47025 | 2 | 0 |
27915 | 27915 | 2020-04-02 | Claiborne | Tennessee | 47025 | 2 | 0 |
30250 | 30250 | 2020-04-03 | Claiborne | Tennessee | 47025 | 2 | 0 |
32641 | 32641 | 2020-04-04 | Claiborne | Tennessee | 47025 | 2 | 0 |
35077 | 35077 | 2020-04-05 | Claiborne | Tennessee | 47025 | 2 | 0 |
37553 | 37553 | 2020-04-06 | Claiborne | Tennessee | 47025 | 2 | 0 |
40076 | 40076 | 2020-04-07 | Claiborne | Tennessee | 47025 | 2 | 0 |
42637 | 42637 | 2020-04-08 | Claiborne | Tennessee | 47025 | 2 | 0 |
45224 | 45224 | 2020-04-09 | Claiborne | Tennessee | 47025 | 2 | 0 |
47842 | 47842 | 2020-04-10 | Claiborne | Tennessee | 47025 | 3 | 0 |
50500 | 50500 | 2020-04-11 | Claiborne | Tennessee | 47025 | 3 | 0 |
53175 | 53175 | 2020-04-12 | Claiborne | Tennessee | 47025 | 3 | 0 |
55861 | 55861 | 2020-04-13 | Claiborne | Tennessee | 47025 | 4 | 0 |
58564 | 58564 | 2020-04-14 | Claiborne | Tennessee | 47025 | 5 | 0 |
61279 | 61279 | 2020-04-15 | Claiborne | Tennessee | 47025 | 5 | 0 |
64006 | 64006 | 2020-04-16 | Claiborne | Tennessee | 47025 | 5 | 0 |
66752 | 66752 | 2020-04-17 | Claiborne | Tennessee | 47025 | 5 | 0 |
69510 | 69510 | 2020-04-18 | Claiborne | Tennessee | 47025 | 5 | 0 |
72277 | 72277 | 2020-04-19 | Claiborne | Tennessee | 47025 | 5 | 0 |
75052 | 75052 | 2020-04-20 | Claiborne | Tennessee | 47025 | 5 | 0 |
77834 | 77834 | 2020-04-21 | Claiborne | Tennessee | 47025 | 5 | 0 |
80624 | 80624 | 2020-04-22 | Claiborne | Tennessee | 47025 | 5 | 0 |
83423 | 83423 | 2020-04-23 | Claiborne | Tennessee | 47025 | 5 | 0 |
86228 | 86228 | 2020-04-24 | Claiborne | Tennessee | 47025 | 5 | 0 |
89043 | 89043 | 2020-04-25 | Claiborne | Tennessee | 47025 | 5 | 0 |
91860 | 91860 | 2020-04-26 | Claiborne | Tennessee | 47025 | 5 | 0 |
94688 | 94688 | 2020-04-27 | Claiborne | Tennessee | 47025 | 5 | 0 |
97528 | 97528 | 2020-04-28 | Claiborne | Tennessee | 47025 | 5 | 0 |
100378 | 100378 | 2020-04-29 | Claiborne | Tennessee | 47025 | 5 | 0 |
103231 | 103231 | 2020-04-30 | Claiborne | Tennessee | 47025 | 5 | 0 |
106094 | 106094 | 2020-05-01 | Claiborne | Tennessee | 47025 | 5 | 0 |
108961 | 108961 | 2020-05-02 | Claiborne | Tennessee | 47025 | 5 | 0 |
111835 | 111835 | 2020-05-03 | Claiborne | Tennessee | 47025 | 5 | 0 |
114717 | 114717 | 2020-05-04 | Claiborne | Tennessee | 47025 | 5 | 0 |
117673 | 117673 | 2020-05-05 | Claiborne | Tennessee | 47025 | 6 | 0 |
120637 | 120637 | 2020-05-06 | Claiborne | Tennessee | 47025 | 6 | 0 |
123615 | 123615 | 2020-05-07 | Claiborne | Tennessee | 47025 | 7 | 0 |
126598 | 126598 | 2020-05-08 | Claiborne | Tennessee | 47025 | 7 | 0 |
129587 | 129587 | 2020-05-09 | Claiborne | Tennessee | 47025 | 7 | 0 |
132576 | 132576 | 2020-05-10 | Claiborne | Tennessee | 47025 | 7 | 0 |
135567 | 135567 | 2020-05-11 | Claiborne | Tennessee | 47025 | 7 | 0 |
138557 | 138557 | 2020-05-12 | Claiborne | Tennessee | 47025 | 7 | 0 |
141553 | 141553 | 2020-05-13 | Claiborne | Tennessee | 47025 | 7 | 0 |
144550 | 144550 | 2020-05-14 | Claiborne | Tennessee | 47025 | 7 | 0 |
147551 | 147551 | 2020-05-15 | Claiborne | Tennessee | 47025 | 7 | 0 |
150559 | 150559 | 2020-05-16 | Claiborne | Tennessee | 47025 | 7 | 0 |
153570 | 153570 | 2020-05-17 | Claiborne | Tennessee | 47025 | 7 | 0 |
156587 | 156587 | 2020-05-18 | Claiborne | Tennessee | 47025 | 8 | 0 |
159608 | 159608 | 2020-05-19 | Claiborne | Tennessee | 47025 | 8 | 0 |
162635 | 162635 | 2020-05-20 | Claiborne | Tennessee | 47025 | 8 | 0 |
165664 | 165664 | 2020-05-21 | Claiborne | Tennessee | 47025 | 8 | 0 |
168700 | 168700 | 2020-05-22 | Claiborne | Tennessee | 47025 | 8 | 0 |
171739 | 171739 | 2020-05-23 | Claiborne | Tennessee | 47025 | 8 | 0 |
174782 | 174782 | 2020-05-24 | Claiborne | Tennessee | 47025 | 8 | 0 |
177826 | 177826 | 2020-05-25 | Claiborne | Tennessee | 47025 | 8 | 0 |
180869 | 180869 | 2020-05-26 | Claiborne | Tennessee | 47025 | 8 | 0 |
183919 | 183919 | 2020-05-27 | Claiborne | Tennessee | 47025 | 8 | 0 |
186976 | 186976 | 2020-05-28 | Claiborne | Tennessee | 47025 | 9 | 0 |
190040 | 190040 | 2020-05-29 | Claiborne | Tennessee | 47025 | 9 | 0 |
193105 | 193105 | 2020-05-30 | Claiborne | Tennessee | 47025 | 9 | 0 |
196175 | 196175 | 2020-05-31 | Claiborne | Tennessee | 47025 | 9 | 0 |
199248 | 199248 | 2020-06-01 | Claiborne | Tennessee | 47025 | 9 | 0 |
202323 | 202323 | 2020-06-02 | Claiborne | Tennessee | 47025 | 12 | 0 |
205402 | 205402 | 2020-06-03 | Claiborne | Tennessee | 47025 | 12 | 0 |
208484 | 208484 | 2020-06-04 | Claiborne | Tennessee | 47025 | 12 | 0 |
211566 | 211566 | 2020-06-05 | Claiborne | Tennessee | 47025 | 12 | 0 |
214653 | 214653 | 2020-06-06 | Claiborne | Tennessee | 47025 | 12 | 0 |
217743 | 217743 | 2020-06-07 | Claiborne | Tennessee | 47025 | 14 | 0 |
220835 | 220835 | 2020-06-08 | Claiborne | Tennessee | 47025 | 14 | 0 |
223930 | 223930 | 2020-06-09 | Claiborne | Tennessee | 47025 | 14 | 0 |
227030 | 227030 | 2020-06-10 | Claiborne | Tennessee | 47025 | 15 | 0 |
230134 | 230134 | 2020-06-11 | Claiborne | Tennessee | 47025 | 15 | 0 |
233239 | 233239 | 2020-06-12 | Claiborne | Tennessee | 47025 | 15 | 0 |
236345 | 236345 | 2020-06-13 | Claiborne | Tennessee | 47025 | 15 | 0 |
239453 | 239453 | 2020-06-14 | Claiborne | Tennessee | 47025 | 15 | 0 |
242563 | 242563 | 2020-06-15 | Claiborne | Tennessee | 47025 | 15 | 0 |
245675 | 245675 | 2020-06-16 | Claiborne | Tennessee | 47025 | 15 | 0 |
248788 | 248788 | 2020-06-17 | Claiborne | Tennessee | 47025 | 15 | 0 |
251903 | 251903 | 2020-06-18 | Claiborne | Tennessee | 47025 | 16 | 0 |
255018 | 255018 | 2020-06-19 | Claiborne | Tennessee | 47025 | 16 | 0 |
258144 | 258144 | 2020-06-20 | Claiborne | Tennessee | 47025 | 16 | 0 |
261271 | 261271 | 2020-06-21 | Claiborne | Tennessee | 47025 | 16 | 0 |
264399 | 264399 | 2020-06-22 | Claiborne | Tennessee | 47025 | 16 | 0 |
267527 | 267527 | 2020-06-23 | Claiborne | Tennessee | 47025 | 18 | 0 |
270661 | 270661 | 2020-06-24 | Claiborne | Tennessee | 47025 | 18 | 0 |
273800 | 273800 | 2020-06-25 | Claiborne | Tennessee | 47025 | 19 | 0 |
276947 | 276947 | 2020-06-26 | Claiborne | Tennessee | 47025 | 19 | 0 |
280095 | 280095 | 2020-06-27 | Claiborne | Tennessee | 47025 | 21 | 0 |
283241 | 283241 | 2020-06-28 | Claiborne | Tennessee | 47025 | 21 | 0 |
286386 | 286386 | 2020-06-29 | Claiborne | Tennessee | 47025 | 24 | 0 |
289537 | 289537 | 2020-06-30 | Claiborne | Tennessee | 47025 | 25 | 0 |
292689 | 292689 | 2020-07-01 | Claiborne | Tennessee | 47025 | 28 | 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);