ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 47043 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5912 | 5912 | 2020-03-20 | Dickson | Tennessee | 47043 | 2 | 0 |
6924 | 6924 | 2020-03-21 | Dickson | Tennessee | 47043 | 3 | 0 |
8047 | 8047 | 2020-03-22 | Dickson | Tennessee | 47043 | 4 | 0 |
9265 | 9265 | 2020-03-23 | Dickson | Tennessee | 47043 | 4 | 0 |
10594 | 10594 | 2020-03-24 | Dickson | Tennessee | 47043 | 5 | 0 |
12071 | 12071 | 2020-03-25 | Dickson | Tennessee | 47043 | 5 | 0 |
13695 | 13695 | 2020-03-26 | Dickson | Tennessee | 47043 | 7 | 0 |
15447 | 15447 | 2020-03-27 | Dickson | Tennessee | 47043 | 9 | 0 |
17308 | 17308 | 2020-03-28 | Dickson | Tennessee | 47043 | 11 | 0 |
19254 | 19254 | 2020-03-29 | Dickson | Tennessee | 47043 | 11 | 0 |
21307 | 21307 | 2020-03-30 | Dickson | Tennessee | 47043 | 12 | 0 |
23445 | 23445 | 2020-03-31 | Dickson | Tennessee | 47043 | 17 | 0 |
25644 | 25644 | 2020-04-01 | Dickson | Tennessee | 47043 | 18 | 0 |
27922 | 27922 | 2020-04-02 | Dickson | Tennessee | 47043 | 20 | 0 |
30257 | 30257 | 2020-04-03 | Dickson | Tennessee | 47043 | 21 | 0 |
32648 | 32648 | 2020-04-04 | Dickson | Tennessee | 47043 | 22 | 0 |
35084 | 35084 | 2020-04-05 | Dickson | Tennessee | 47043 | 23 | 0 |
37560 | 37560 | 2020-04-06 | Dickson | Tennessee | 47043 | 24 | 0 |
40083 | 40083 | 2020-04-07 | Dickson | Tennessee | 47043 | 27 | 0 |
42645 | 42645 | 2020-04-08 | Dickson | Tennessee | 47043 | 27 | 0 |
45232 | 45232 | 2020-04-09 | Dickson | Tennessee | 47043 | 28 | 0 |
47850 | 47850 | 2020-04-10 | Dickson | Tennessee | 47043 | 29 | 0 |
50508 | 50508 | 2020-04-11 | Dickson | Tennessee | 47043 | 30 | 0 |
53183 | 53183 | 2020-04-12 | Dickson | Tennessee | 47043 | 30 | 0 |
55869 | 55869 | 2020-04-13 | Dickson | Tennessee | 47043 | 30 | 0 |
58572 | 58572 | 2020-04-14 | Dickson | Tennessee | 47043 | 33 | 0 |
61287 | 61287 | 2020-04-15 | Dickson | Tennessee | 47043 | 37 | 0 |
64014 | 64014 | 2020-04-16 | Dickson | Tennessee | 47043 | 39 | 0 |
66760 | 66760 | 2020-04-17 | Dickson | Tennessee | 47043 | 42 | 0 |
69519 | 69519 | 2020-04-18 | Dickson | Tennessee | 47043 | 43 | 0 |
72286 | 72286 | 2020-04-19 | Dickson | Tennessee | 47043 | 45 | 0 |
75061 | 75061 | 2020-04-20 | Dickson | Tennessee | 47043 | 46 | 0 |
77843 | 77843 | 2020-04-21 | Dickson | Tennessee | 47043 | 46 | 0 |
80633 | 80633 | 2020-04-22 | Dickson | Tennessee | 47043 | 50 | 0 |
83432 | 83432 | 2020-04-23 | Dickson | Tennessee | 47043 | 56 | 0 |
86237 | 86237 | 2020-04-24 | Dickson | Tennessee | 47043 | 63 | 0 |
89052 | 89052 | 2020-04-25 | Dickson | Tennessee | 47043 | 64 | 0 |
91869 | 91869 | 2020-04-26 | Dickson | Tennessee | 47043 | 66 | 0 |
94697 | 94697 | 2020-04-27 | Dickson | Tennessee | 47043 | 70 | 0 |
97537 | 97537 | 2020-04-28 | Dickson | Tennessee | 47043 | 71 | 0 |
100387 | 100387 | 2020-04-29 | Dickson | Tennessee | 47043 | 72 | 0 |
103240 | 103240 | 2020-04-30 | Dickson | Tennessee | 47043 | 72 | 0 |
106103 | 106103 | 2020-05-01 | Dickson | Tennessee | 47043 | 74 | 0 |
108970 | 108970 | 2020-05-02 | Dickson | Tennessee | 47043 | 77 | 0 |
111844 | 111844 | 2020-05-03 | Dickson | Tennessee | 47043 | 80 | 0 |
114726 | 114726 | 2020-05-04 | Dickson | Tennessee | 47043 | 82 | 0 |
117682 | 117682 | 2020-05-05 | Dickson | Tennessee | 47043 | 84 | 0 |
120646 | 120646 | 2020-05-06 | Dickson | Tennessee | 47043 | 84 | 0 |
123624 | 123624 | 2020-05-07 | Dickson | Tennessee | 47043 | 85 | 0 |
126607 | 126607 | 2020-05-08 | Dickson | Tennessee | 47043 | 85 | 0 |
129596 | 129596 | 2020-05-09 | Dickson | Tennessee | 47043 | 85 | 0 |
132585 | 132585 | 2020-05-10 | Dickson | Tennessee | 47043 | 86 | 0 |
135576 | 135576 | 2020-05-11 | Dickson | Tennessee | 47043 | 86 | 0 |
138566 | 138566 | 2020-05-12 | Dickson | Tennessee | 47043 | 88 | 0 |
141562 | 141562 | 2020-05-13 | Dickson | Tennessee | 47043 | 88 | 0 |
144559 | 144559 | 2020-05-14 | Dickson | Tennessee | 47043 | 88 | 0 |
147560 | 147560 | 2020-05-15 | Dickson | Tennessee | 47043 | 90 | 0 |
150568 | 150568 | 2020-05-16 | Dickson | Tennessee | 47043 | 91 | 0 |
153579 | 153579 | 2020-05-17 | Dickson | Tennessee | 47043 | 92 | 0 |
156596 | 156596 | 2020-05-18 | Dickson | Tennessee | 47043 | 93 | 0 |
159617 | 159617 | 2020-05-19 | Dickson | Tennessee | 47043 | 93 | 0 |
162644 | 162644 | 2020-05-20 | Dickson | Tennessee | 47043 | 93 | 0 |
165673 | 165673 | 2020-05-21 | Dickson | Tennessee | 47043 | 97 | 0 |
168709 | 168709 | 2020-05-22 | Dickson | Tennessee | 47043 | 101 | 0 |
171748 | 171748 | 2020-05-23 | Dickson | Tennessee | 47043 | 101 | 0 |
174791 | 174791 | 2020-05-24 | Dickson | Tennessee | 47043 | 101 | 0 |
177835 | 177835 | 2020-05-25 | Dickson | Tennessee | 47043 | 104 | 0 |
180878 | 180878 | 2020-05-26 | Dickson | Tennessee | 47043 | 106 | 0 |
183928 | 183928 | 2020-05-27 | Dickson | Tennessee | 47043 | 107 | 0 |
186985 | 186985 | 2020-05-28 | Dickson | Tennessee | 47043 | 110 | 0 |
190049 | 190049 | 2020-05-29 | Dickson | Tennessee | 47043 | 109 | 0 |
193114 | 193114 | 2020-05-30 | Dickson | Tennessee | 47043 | 109 | 0 |
196184 | 196184 | 2020-05-31 | Dickson | Tennessee | 47043 | 109 | 0 |
199257 | 199257 | 2020-06-01 | Dickson | Tennessee | 47043 | 109 | 0 |
202332 | 202332 | 2020-06-02 | Dickson | Tennessee | 47043 | 116 | 0 |
205411 | 205411 | 2020-06-03 | Dickson | Tennessee | 47043 | 118 | 0 |
208493 | 208493 | 2020-06-04 | Dickson | Tennessee | 47043 | 120 | 0 |
211575 | 211575 | 2020-06-05 | Dickson | Tennessee | 47043 | 121 | 0 |
214662 | 214662 | 2020-06-06 | Dickson | Tennessee | 47043 | 124 | 0 |
217752 | 217752 | 2020-06-07 | Dickson | Tennessee | 47043 | 125 | 0 |
220844 | 220844 | 2020-06-08 | Dickson | Tennessee | 47043 | 125 | 0 |
223939 | 223939 | 2020-06-09 | Dickson | Tennessee | 47043 | 127 | 0 |
227039 | 227039 | 2020-06-10 | Dickson | Tennessee | 47043 | 128 | 0 |
230143 | 230143 | 2020-06-11 | Dickson | Tennessee | 47043 | 129 | 0 |
233248 | 233248 | 2020-06-12 | Dickson | Tennessee | 47043 | 131 | 0 |
236354 | 236354 | 2020-06-13 | Dickson | Tennessee | 47043 | 133 | 0 |
239462 | 239462 | 2020-06-14 | Dickson | Tennessee | 47043 | 135 | 0 |
242572 | 242572 | 2020-06-15 | Dickson | Tennessee | 47043 | 138 | 0 |
245684 | 245684 | 2020-06-16 | Dickson | Tennessee | 47043 | 138 | 0 |
248797 | 248797 | 2020-06-17 | Dickson | Tennessee | 47043 | 140 | 0 |
251912 | 251912 | 2020-06-18 | Dickson | Tennessee | 47043 | 140 | 0 |
255027 | 255027 | 2020-06-19 | Dickson | Tennessee | 47043 | 145 | 0 |
258153 | 258153 | 2020-06-20 | Dickson | Tennessee | 47043 | 145 | 0 |
261280 | 261280 | 2020-06-21 | Dickson | Tennessee | 47043 | 147 | 0 |
264408 | 264408 | 2020-06-22 | Dickson | Tennessee | 47043 | 146 | 0 |
267536 | 267536 | 2020-06-23 | Dickson | Tennessee | 47043 | 150 | 0 |
270670 | 270670 | 2020-06-24 | Dickson | Tennessee | 47043 | 150 | 0 |
273809 | 273809 | 2020-06-25 | Dickson | Tennessee | 47043 | 151 | 0 |
276956 | 276956 | 2020-06-26 | Dickson | Tennessee | 47043 | 156 | 0 |
280104 | 280104 | 2020-06-27 | Dickson | Tennessee | 47043 | 159 | 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);