ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Lincoln" and fips = 47103 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
10607 | 10607 | 2020-03-24 | Lincoln | Tennessee | 47103 | 1 | 0 |
12086 | 12086 | 2020-03-25 | Lincoln | Tennessee | 47103 | 1 | 0 |
13710 | 13710 | 2020-03-26 | Lincoln | Tennessee | 47103 | 1 | 0 |
15462 | 15462 | 2020-03-27 | Lincoln | Tennessee | 47103 | 1 | 0 |
17325 | 17325 | 2020-03-28 | Lincoln | Tennessee | 47103 | 1 | 0 |
19273 | 19273 | 2020-03-29 | Lincoln | Tennessee | 47103 | 1 | 0 |
21329 | 21329 | 2020-03-30 | Lincoln | Tennessee | 47103 | 1 | 0 |
23468 | 23468 | 2020-03-31 | Lincoln | Tennessee | 47103 | 1 | 0 |
25670 | 25670 | 2020-04-01 | Lincoln | Tennessee | 47103 | 2 | 0 |
27949 | 27949 | 2020-04-02 | Lincoln | Tennessee | 47103 | 2 | 0 |
30284 | 30284 | 2020-04-03 | Lincoln | Tennessee | 47103 | 4 | 0 |
32675 | 32675 | 2020-04-04 | Lincoln | Tennessee | 47103 | 5 | 0 |
35112 | 35112 | 2020-04-05 | Lincoln | Tennessee | 47103 | 5 | 0 |
37588 | 37588 | 2020-04-06 | Lincoln | Tennessee | 47103 | 5 | 0 |
40111 | 40111 | 2020-04-07 | Lincoln | Tennessee | 47103 | 6 | 0 |
42673 | 42673 | 2020-04-08 | Lincoln | Tennessee | 47103 | 7 | 0 |
45260 | 45260 | 2020-04-09 | Lincoln | Tennessee | 47103 | 7 | 0 |
47878 | 47878 | 2020-04-10 | Lincoln | Tennessee | 47103 | 8 | 0 |
50536 | 50536 | 2020-04-11 | Lincoln | Tennessee | 47103 | 8 | 0 |
53211 | 53211 | 2020-04-12 | Lincoln | Tennessee | 47103 | 8 | 0 |
55898 | 55898 | 2020-04-13 | Lincoln | Tennessee | 47103 | 9 | 0 |
58601 | 58601 | 2020-04-14 | Lincoln | Tennessee | 47103 | 9 | 0 |
61316 | 61316 | 2020-04-15 | Lincoln | Tennessee | 47103 | 9 | 0 |
64043 | 64043 | 2020-04-16 | Lincoln | Tennessee | 47103 | 9 | 0 |
66789 | 66789 | 2020-04-17 | Lincoln | Tennessee | 47103 | 9 | 0 |
69548 | 69548 | 2020-04-18 | Lincoln | Tennessee | 47103 | 9 | 0 |
72315 | 72315 | 2020-04-19 | Lincoln | Tennessee | 47103 | 10 | 0 |
75090 | 75090 | 2020-04-20 | Lincoln | Tennessee | 47103 | 10 | 0 |
77872 | 77872 | 2020-04-21 | Lincoln | Tennessee | 47103 | 11 | 0 |
80662 | 80662 | 2020-04-22 | Lincoln | Tennessee | 47103 | 11 | 0 |
83461 | 83461 | 2020-04-23 | Lincoln | Tennessee | 47103 | 11 | 0 |
86266 | 86266 | 2020-04-24 | Lincoln | Tennessee | 47103 | 11 | 0 |
89081 | 89081 | 2020-04-25 | Lincoln | Tennessee | 47103 | 12 | 0 |
91898 | 91898 | 2020-04-26 | Lincoln | Tennessee | 47103 | 12 | 0 |
94726 | 94726 | 2020-04-27 | Lincoln | Tennessee | 47103 | 12 | 0 |
97566 | 97566 | 2020-04-28 | Lincoln | Tennessee | 47103 | 12 | 0 |
100416 | 100416 | 2020-04-29 | Lincoln | Tennessee | 47103 | 13 | 0 |
103269 | 103269 | 2020-04-30 | Lincoln | Tennessee | 47103 | 13 | 0 |
106132 | 106132 | 2020-05-01 | Lincoln | Tennessee | 47103 | 14 | 0 |
108999 | 108999 | 2020-05-02 | Lincoln | Tennessee | 47103 | 14 | 0 |
111873 | 111873 | 2020-05-03 | Lincoln | Tennessee | 47103 | 14 | 0 |
114755 | 114755 | 2020-05-04 | Lincoln | Tennessee | 47103 | 16 | 0 |
117711 | 117711 | 2020-05-05 | Lincoln | Tennessee | 47103 | 16 | 0 |
120675 | 120675 | 2020-05-06 | Lincoln | Tennessee | 47103 | 16 | 0 |
123653 | 123653 | 2020-05-07 | Lincoln | Tennessee | 47103 | 16 | 0 |
126636 | 126636 | 2020-05-08 | Lincoln | Tennessee | 47103 | 16 | 0 |
129625 | 129625 | 2020-05-09 | Lincoln | Tennessee | 47103 | 16 | 0 |
132614 | 132614 | 2020-05-10 | Lincoln | Tennessee | 47103 | 16 | 0 |
135605 | 135605 | 2020-05-11 | Lincoln | Tennessee | 47103 | 16 | 0 |
138595 | 138595 | 2020-05-12 | Lincoln | Tennessee | 47103 | 16 | 0 |
141591 | 141591 | 2020-05-13 | Lincoln | Tennessee | 47103 | 16 | 0 |
144588 | 144588 | 2020-05-14 | Lincoln | Tennessee | 47103 | 16 | 0 |
147589 | 147589 | 2020-05-15 | Lincoln | Tennessee | 47103 | 16 | 0 |
150597 | 150597 | 2020-05-16 | Lincoln | Tennessee | 47103 | 16 | 0 |
153608 | 153608 | 2020-05-17 | Lincoln | Tennessee | 47103 | 16 | 0 |
156625 | 156625 | 2020-05-18 | Lincoln | Tennessee | 47103 | 16 | 0 |
159647 | 159647 | 2020-05-19 | Lincoln | Tennessee | 47103 | 17 | 0 |
162674 | 162674 | 2020-05-20 | Lincoln | Tennessee | 47103 | 17 | 0 |
165703 | 165703 | 2020-05-21 | Lincoln | Tennessee | 47103 | 22 | 0 |
168739 | 168739 | 2020-05-22 | Lincoln | Tennessee | 47103 | 26 | 0 |
171778 | 171778 | 2020-05-23 | Lincoln | Tennessee | 47103 | 26 | 0 |
174821 | 174821 | 2020-05-24 | Lincoln | Tennessee | 47103 | 25 | 0 |
177865 | 177865 | 2020-05-25 | Lincoln | Tennessee | 47103 | 25 | 0 |
180908 | 180908 | 2020-05-26 | Lincoln | Tennessee | 47103 | 25 | 0 |
183958 | 183958 | 2020-05-27 | Lincoln | Tennessee | 47103 | 25 | 0 |
187015 | 187015 | 2020-05-28 | Lincoln | Tennessee | 47103 | 25 | 0 |
190079 | 190079 | 2020-05-29 | Lincoln | Tennessee | 47103 | 25 | 0 |
193144 | 193144 | 2020-05-30 | Lincoln | Tennessee | 47103 | 25 | 0 |
196214 | 196214 | 2020-05-31 | Lincoln | Tennessee | 47103 | 25 | 0 |
199287 | 199287 | 2020-06-01 | Lincoln | Tennessee | 47103 | 25 | 0 |
202362 | 202362 | 2020-06-02 | Lincoln | Tennessee | 47103 | 28 | 0 |
205441 | 205441 | 2020-06-03 | Lincoln | Tennessee | 47103 | 29 | 0 |
208523 | 208523 | 2020-06-04 | Lincoln | Tennessee | 47103 | 29 | 0 |
211605 | 211605 | 2020-06-05 | Lincoln | Tennessee | 47103 | 30 | 0 |
214692 | 214692 | 2020-06-06 | Lincoln | Tennessee | 47103 | 32 | 0 |
217782 | 217782 | 2020-06-07 | Lincoln | Tennessee | 47103 | 32 | 0 |
220874 | 220874 | 2020-06-08 | Lincoln | Tennessee | 47103 | 32 | 0 |
223969 | 223969 | 2020-06-09 | Lincoln | Tennessee | 47103 | 33 | 0 |
227069 | 227069 | 2020-06-10 | Lincoln | Tennessee | 47103 | 34 | 0 |
230173 | 230173 | 2020-06-11 | Lincoln | Tennessee | 47103 | 36 | 0 |
233278 | 233278 | 2020-06-12 | Lincoln | Tennessee | 47103 | 42 | 0 |
236384 | 236384 | 2020-06-13 | Lincoln | Tennessee | 47103 | 44 | 0 |
239492 | 239492 | 2020-06-14 | Lincoln | Tennessee | 47103 | 47 | 0 |
242602 | 242602 | 2020-06-15 | Lincoln | Tennessee | 47103 | 47 | 0 |
245714 | 245714 | 2020-06-16 | Lincoln | Tennessee | 47103 | 47 | 0 |
248827 | 248827 | 2020-06-17 | Lincoln | Tennessee | 47103 | 48 | 0 |
251942 | 251942 | 2020-06-18 | Lincoln | Tennessee | 47103 | 48 | 0 |
255057 | 255057 | 2020-06-19 | Lincoln | Tennessee | 47103 | 48 | 0 |
258183 | 258183 | 2020-06-20 | Lincoln | Tennessee | 47103 | 49 | 0 |
261310 | 261310 | 2020-06-21 | Lincoln | Tennessee | 47103 | 49 | 0 |
264438 | 264438 | 2020-06-22 | Lincoln | Tennessee | 47103 | 49 | 0 |
267566 | 267566 | 2020-06-23 | Lincoln | Tennessee | 47103 | 49 | 0 |
270700 | 270700 | 2020-06-24 | Lincoln | Tennessee | 47103 | 51 | 0 |
273839 | 273839 | 2020-06-25 | Lincoln | Tennessee | 47103 | 51 | 0 |
276986 | 276986 | 2020-06-26 | Lincoln | Tennessee | 47103 | 52 | 0 |
280134 | 280134 | 2020-06-27 | Lincoln | Tennessee | 47103 | 52 | 0 |
283280 | 283280 | 2020-06-28 | Lincoln | Tennessee | 47103 | 52 | 0 |
286425 | 286425 | 2020-06-29 | Lincoln | Tennessee | 47103 | 53 | 0 |
289576 | 289576 | 2020-06-30 | Lincoln | Tennessee | 47103 | 56 | 0 |
292728 | 292728 | 2020-07-01 | Lincoln | Tennessee | 47103 | 59 | 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);