ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Robertson" and state = "Tennessee" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4285 | 4285 | 2020-03-18 | Robertson | Tennessee | 47147 | 1 | 0 |
5033 | 5033 | 2020-03-19 | Robertson | Tennessee | 47147 | 2 | 0 |
5921 | 5921 | 2020-03-20 | Robertson | Tennessee | 47147 | 2 | 0 |
6937 | 6937 | 2020-03-21 | Robertson | Tennessee | 47147 | 2 | 0 |
8067 | 8067 | 2020-03-22 | Robertson | Tennessee | 47147 | 3 | 0 |
9285 | 9285 | 2020-03-23 | Robertson | Tennessee | 47147 | 3 | 0 |
10619 | 10619 | 2020-03-24 | Robertson | Tennessee | 47147 | 12 | 0 |
12098 | 12098 | 2020-03-25 | Robertson | Tennessee | 47147 | 15 | 0 |
13724 | 13724 | 2020-03-26 | Robertson | Tennessee | 47147 | 20 | 0 |
15476 | 15476 | 2020-03-27 | Robertson | Tennessee | 47147 | 22 | 0 |
17340 | 17340 | 2020-03-28 | Robertson | Tennessee | 47147 | 23 | 0 |
19290 | 19290 | 2020-03-29 | Robertson | Tennessee | 47147 | 25 | 0 |
21347 | 21347 | 2020-03-30 | Robertson | Tennessee | 47147 | 27 | 0 |
23486 | 23486 | 2020-03-31 | Robertson | Tennessee | 47147 | 27 | 0 |
25688 | 25688 | 2020-04-01 | Robertson | Tennessee | 47147 | 35 | 0 |
27968 | 27968 | 2020-04-02 | Robertson | Tennessee | 47147 | 41 | 0 |
30303 | 30303 | 2020-04-03 | Robertson | Tennessee | 47147 | 51 | 0 |
32694 | 32694 | 2020-04-04 | Robertson | Tennessee | 47147 | 51 | 0 |
35131 | 35131 | 2020-04-05 | Robertson | Tennessee | 47147 | 59 | 0 |
37607 | 37607 | 2020-04-06 | Robertson | Tennessee | 47147 | 60 | 0 |
40130 | 40130 | 2020-04-07 | Robertson | Tennessee | 47147 | 65 | 0 |
42692 | 42692 | 2020-04-08 | Robertson | Tennessee | 47147 | 67 | 0 |
45279 | 45279 | 2020-04-09 | Robertson | Tennessee | 47147 | 70 | 0 |
47897 | 47897 | 2020-04-10 | Robertson | Tennessee | 47147 | 73 | 0 |
50555 | 50555 | 2020-04-11 | Robertson | Tennessee | 47147 | 81 | 0 |
53230 | 53230 | 2020-04-12 | Robertson | Tennessee | 47147 | 81 | 0 |
55917 | 55917 | 2020-04-13 | Robertson | Tennessee | 47147 | 88 | 0 |
58620 | 58620 | 2020-04-14 | Robertson | Tennessee | 47147 | 92 | 0 |
61336 | 61336 | 2020-04-15 | Robertson | Tennessee | 47147 | 94 | 0 |
64063 | 64063 | 2020-04-16 | Robertson | Tennessee | 47147 | 95 | 0 |
66810 | 66810 | 2020-04-17 | Robertson | Tennessee | 47147 | 105 | 0 |
69569 | 69569 | 2020-04-18 | Robertson | Tennessee | 47147 | 105 | 0 |
72336 | 72336 | 2020-04-19 | Robertson | Tennessee | 47147 | 113 | 0 |
75111 | 75111 | 2020-04-20 | Robertson | Tennessee | 47147 | 116 | 0 |
77893 | 77893 | 2020-04-21 | Robertson | Tennessee | 47147 | 117 | 0 |
80683 | 80683 | 2020-04-22 | Robertson | Tennessee | 47147 | 123 | 0 |
83482 | 83482 | 2020-04-23 | Robertson | Tennessee | 47147 | 126 | 0 |
86287 | 86287 | 2020-04-24 | Robertson | Tennessee | 47147 | 125 | 0 |
89102 | 89102 | 2020-04-25 | Robertson | Tennessee | 47147 | 127 | 0 |
91919 | 91919 | 2020-04-26 | Robertson | Tennessee | 47147 | 136 | 0 |
94747 | 94747 | 2020-04-27 | Robertson | Tennessee | 47147 | 138 | 0 |
97587 | 97587 | 2020-04-28 | Robertson | Tennessee | 47147 | 139 | 0 |
100437 | 100437 | 2020-04-29 | Robertson | Tennessee | 47147 | 139 | 0 |
103290 | 103290 | 2020-04-30 | Robertson | Tennessee | 47147 | 148 | 0 |
106153 | 106153 | 2020-05-01 | Robertson | Tennessee | 47147 | 157 | 0 |
109020 | 109020 | 2020-05-02 | Robertson | Tennessee | 47147 | 168 | 0 |
111894 | 111894 | 2020-05-03 | Robertson | Tennessee | 47147 | 179 | 0 |
114776 | 114776 | 2020-05-04 | Robertson | Tennessee | 47147 | 184 | 0 |
117732 | 117732 | 2020-05-05 | Robertson | Tennessee | 47147 | 185 | 0 |
120696 | 120696 | 2020-05-06 | Robertson | Tennessee | 47147 | 186 | 0 |
123674 | 123674 | 2020-05-07 | Robertson | Tennessee | 47147 | 195 | 0 |
126657 | 126657 | 2020-05-08 | Robertson | Tennessee | 47147 | 207 | 0 |
129646 | 129646 | 2020-05-09 | Robertson | Tennessee | 47147 | 219 | 0 |
132636 | 132636 | 2020-05-10 | Robertson | Tennessee | 47147 | 218 | 0 |
135627 | 135627 | 2020-05-11 | Robertson | Tennessee | 47147 | 220 | 0 |
138617 | 138617 | 2020-05-12 | Robertson | Tennessee | 47147 | 244 | 0 |
141613 | 141613 | 2020-05-13 | Robertson | Tennessee | 47147 | 245 | 0 |
144610 | 144610 | 2020-05-14 | Robertson | Tennessee | 47147 | 250 | 0 |
147611 | 147611 | 2020-05-15 | Robertson | Tennessee | 47147 | 263 | 0 |
150619 | 150619 | 2020-05-16 | Robertson | Tennessee | 47147 | 274 | 0 |
153630 | 153630 | 2020-05-17 | Robertson | Tennessee | 47147 | 274 | 0 |
156647 | 156647 | 2020-05-18 | Robertson | Tennessee | 47147 | 294 | 0 |
159669 | 159669 | 2020-05-19 | Robertson | Tennessee | 47147 | 298 | 0 |
162696 | 162696 | 2020-05-20 | Robertson | Tennessee | 47147 | 298 | 0 |
165725 | 165725 | 2020-05-21 | Robertson | Tennessee | 47147 | 317 | 0 |
168761 | 168761 | 2020-05-22 | Robertson | Tennessee | 47147 | 335 | 0 |
171800 | 171800 | 2020-05-23 | Robertson | Tennessee | 47147 | 360 | 0 |
174843 | 174843 | 2020-05-24 | Robertson | Tennessee | 47147 | 371 | 1 |
177887 | 177887 | 2020-05-25 | Robertson | Tennessee | 47147 | 389 | 1 |
180930 | 180930 | 2020-05-26 | Robertson | Tennessee | 47147 | 414 | 1 |
183980 | 183980 | 2020-05-27 | Robertson | Tennessee | 47147 | 426 | 2 |
187037 | 187037 | 2020-05-28 | Robertson | Tennessee | 47147 | 441 | 2 |
190101 | 190101 | 2020-05-29 | Robertson | Tennessee | 47147 | 449 | 3 |
193166 | 193166 | 2020-05-30 | Robertson | Tennessee | 47147 | 465 | 3 |
196236 | 196236 | 2020-05-31 | Robertson | Tennessee | 47147 | 465 | 3 |
199309 | 199309 | 2020-06-01 | Robertson | Tennessee | 47147 | 465 | 3 |
202384 | 202384 | 2020-06-02 | Robertson | Tennessee | 47147 | 511 | 4 |
205463 | 205463 | 2020-06-03 | Robertson | Tennessee | 47147 | 516 | 5 |
208545 | 208545 | 2020-06-04 | Robertson | Tennessee | 47147 | 523 | 5 |
211627 | 211627 | 2020-06-05 | Robertson | Tennessee | 47147 | 542 | 5 |
214714 | 214714 | 2020-06-06 | Robertson | Tennessee | 47147 | 545 | 6 |
217804 | 217804 | 2020-06-07 | Robertson | Tennessee | 47147 | 553 | 6 |
220896 | 220896 | 2020-06-08 | Robertson | Tennessee | 47147 | 567 | 6 |
223991 | 223991 | 2020-06-09 | Robertson | Tennessee | 47147 | 580 | 7 |
227091 | 227091 | 2020-06-10 | Robertson | Tennessee | 47147 | 584 | 7 |
230195 | 230195 | 2020-06-11 | Robertson | Tennessee | 47147 | 594 | 7 |
233300 | 233300 | 2020-06-12 | Robertson | Tennessee | 47147 | 597 | 8 |
236406 | 236406 | 2020-06-13 | Robertson | Tennessee | 47147 | 609 | 8 |
239514 | 239514 | 2020-06-14 | Robertson | Tennessee | 47147 | 633 | 9 |
242624 | 242624 | 2020-06-15 | Robertson | Tennessee | 47147 | 649 | 9 |
245736 | 245736 | 2020-06-16 | Robertson | Tennessee | 47147 | 657 | 9 |
248849 | 248849 | 2020-06-17 | Robertson | Tennessee | 47147 | 658 | 9 |
251964 | 251964 | 2020-06-18 | Robertson | Tennessee | 47147 | 670 | 9 |
255079 | 255079 | 2020-06-19 | Robertson | Tennessee | 47147 | 703 | 9 |
258205 | 258205 | 2020-06-20 | Robertson | Tennessee | 47147 | 701 | 9 |
261332 | 261332 | 2020-06-21 | Robertson | Tennessee | 47147 | 705 | 9 |
264460 | 264460 | 2020-06-22 | Robertson | Tennessee | 47147 | 708 | 10 |
267588 | 267588 | 2020-06-23 | Robertson | Tennessee | 47147 | 715 | 10 |
270722 | 270722 | 2020-06-24 | Robertson | Tennessee | 47147 | 722 | 10 |
273861 | 273861 | 2020-06-25 | Robertson | Tennessee | 47147 | 729 | 10 |
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);