ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where county = "Williamson" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
314925 | 314925 | 2020-07-08 | Williamson | Tennessee | 47187 | 1515 | 15 |
311751 | 311751 | 2020-07-07 | Williamson | Tennessee | 47187 | 1420 | 15 |
308582 | 308582 | 2020-07-06 | Williamson | Tennessee | 47187 | 1340 | 15 |
305414 | 305414 | 2020-07-05 | Williamson | Tennessee | 47187 | 1313 | 15 |
302250 | 302250 | 2020-07-04 | Williamson | Tennessee | 47187 | 1268 | 15 |
299086 | 299086 | 2020-07-03 | Williamson | Tennessee | 47187 | 1226 | 14 |
295926 | 295926 | 2020-07-02 | Williamson | Tennessee | 47187 | 1148 | 14 |
292771 | 292771 | 2020-07-01 | Williamson | Tennessee | 47187 | 1090 | 14 |
289618 | 289618 | 2020-06-30 | Williamson | Tennessee | 47187 | 1013 | 14 |
286468 | 286468 | 2020-06-29 | Williamson | Tennessee | 47187 | 1001 | 14 |
283322 | 283322 | 2020-06-28 | Williamson | Tennessee | 47187 | 945 | 14 |
280176 | 280176 | 2020-06-27 | Williamson | Tennessee | 47187 | 945 | 14 |
277028 | 277028 | 2020-06-26 | Williamson | Tennessee | 47187 | 912 | 14 |
273881 | 273881 | 2020-06-25 | Williamson | Tennessee | 47187 | 874 | 14 |
270742 | 270742 | 2020-06-24 | Williamson | Tennessee | 47187 | 840 | 14 |
267608 | 267608 | 2020-06-23 | Williamson | Tennessee | 47187 | 813 | 14 |
264480 | 264480 | 2020-06-22 | Williamson | Tennessee | 47187 | 793 | 13 |
261352 | 261352 | 2020-06-21 | Williamson | Tennessee | 47187 | 782 | 13 |
258225 | 258225 | 2020-06-20 | Williamson | Tennessee | 47187 | 775 | 12 |
255099 | 255099 | 2020-06-19 | Williamson | Tennessee | 47187 | 767 | 12 |
251984 | 251984 | 2020-06-18 | Williamson | Tennessee | 47187 | 742 | 12 |
248869 | 248869 | 2020-06-17 | Williamson | Tennessee | 47187 | 730 | 12 |
245756 | 245756 | 2020-06-16 | Williamson | Tennessee | 47187 | 723 | 12 |
242644 | 242644 | 2020-06-15 | Williamson | Tennessee | 47187 | 703 | 12 |
239534 | 239534 | 2020-06-14 | Williamson | Tennessee | 47187 | 686 | 12 |
236426 | 236426 | 2020-06-13 | Williamson | Tennessee | 47187 | 675 | 12 |
233320 | 233320 | 2020-06-12 | Williamson | Tennessee | 47187 | 670 | 12 |
230216 | 230216 | 2020-06-11 | Williamson | Tennessee | 47187 | 662 | 11 |
227112 | 227112 | 2020-06-10 | Williamson | Tennessee | 47187 | 654 | 11 |
224012 | 224012 | 2020-06-09 | Williamson | Tennessee | 47187 | 648 | 11 |
220917 | 220917 | 2020-06-08 | Williamson | Tennessee | 47187 | 630 | 11 |
217825 | 217825 | 2020-06-07 | Williamson | Tennessee | 47187 | 621 | 11 |
214735 | 214735 | 2020-06-06 | Williamson | Tennessee | 47187 | 606 | 11 |
211648 | 211648 | 2020-06-05 | Williamson | Tennessee | 47187 | 595 | 11 |
208566 | 208566 | 2020-06-04 | Williamson | Tennessee | 47187 | 589 | 11 |
205484 | 205484 | 2020-06-03 | Williamson | Tennessee | 47187 | 577 | 11 |
202405 | 202405 | 2020-06-02 | Williamson | Tennessee | 47187 | 567 | 11 |
199330 | 199330 | 2020-06-01 | Williamson | Tennessee | 47187 | 552 | 10 |
196257 | 196257 | 2020-05-31 | Williamson | Tennessee | 47187 | 552 | 10 |
193187 | 193187 | 2020-05-30 | Williamson | Tennessee | 47187 | 552 | 10 |
190122 | 190122 | 2020-05-29 | Williamson | Tennessee | 47187 | 542 | 10 |
187058 | 187058 | 2020-05-28 | Williamson | Tennessee | 47187 | 533 | 10 |
184001 | 184001 | 2020-05-27 | Williamson | Tennessee | 47187 | 532 | 10 |
180951 | 180951 | 2020-05-26 | Williamson | Tennessee | 47187 | 527 | 10 |
177908 | 177908 | 2020-05-25 | Williamson | Tennessee | 47187 | 522 | 10 |
174864 | 174864 | 2020-05-24 | Williamson | Tennessee | 47187 | 512 | 10 |
171821 | 171821 | 2020-05-23 | Williamson | Tennessee | 47187 | 503 | 10 |
168782 | 168782 | 2020-05-22 | Williamson | Tennessee | 47187 | 500 | 10 |
165746 | 165746 | 2020-05-21 | Williamson | Tennessee | 47187 | 491 | 10 |
162717 | 162717 | 2020-05-20 | Williamson | Tennessee | 47187 | 492 | 10 |
159690 | 159690 | 2020-05-19 | Williamson | Tennessee | 47187 | 492 | 10 |
156668 | 156668 | 2020-05-18 | Williamson | Tennessee | 47187 | 480 | 10 |
153651 | 153651 | 2020-05-17 | Williamson | Tennessee | 47187 | 471 | 10 |
150640 | 150640 | 2020-05-16 | Williamson | Tennessee | 47187 | 471 | 10 |
147632 | 147632 | 2020-05-15 | Williamson | Tennessee | 47187 | 462 | 10 |
144631 | 144631 | 2020-05-14 | Williamson | Tennessee | 47187 | 456 | 10 |
141634 | 141634 | 2020-05-13 | Williamson | Tennessee | 47187 | 453 | 10 |
138638 | 138638 | 2020-05-12 | Williamson | Tennessee | 47187 | 447 | 10 |
135648 | 135648 | 2020-05-11 | Williamson | Tennessee | 47187 | 445 | 10 |
132657 | 132657 | 2020-05-10 | Williamson | Tennessee | 47187 | 443 | 10 |
129667 | 129667 | 2020-05-09 | Williamson | Tennessee | 47187 | 441 | 10 |
126678 | 126678 | 2020-05-08 | Williamson | Tennessee | 47187 | 441 | 10 |
123695 | 123695 | 2020-05-07 | Williamson | Tennessee | 47187 | 434 | 10 |
120716 | 120716 | 2020-05-06 | Williamson | Tennessee | 47187 | 436 | 10 |
117752 | 117752 | 2020-05-05 | Williamson | Tennessee | 47187 | 439 | 9 |
114796 | 114796 | 2020-05-04 | Williamson | Tennessee | 47187 | 431 | 9 |
111914 | 111914 | 2020-05-03 | Williamson | Tennessee | 47187 | 427 | 9 |
109040 | 109040 | 2020-05-02 | Williamson | Tennessee | 47187 | 419 | 9 |
106173 | 106173 | 2020-05-01 | Williamson | Tennessee | 47187 | 416 | 9 |
103310 | 103310 | 2020-04-30 | Williamson | Tennessee | 47187 | 411 | 9 |
100457 | 100457 | 2020-04-29 | Williamson | Tennessee | 47187 | 408 | 9 |
97607 | 97607 | 2020-04-28 | Williamson | Tennessee | 47187 | 399 | 8 |
94767 | 94767 | 2020-04-27 | Williamson | Tennessee | 47187 | 399 | 7 |
91939 | 91939 | 2020-04-26 | Williamson | Tennessee | 47187 | 397 | 7 |
89122 | 89122 | 2020-04-25 | Williamson | Tennessee | 47187 | 381 | 7 |
86307 | 86307 | 2020-04-24 | Williamson | Tennessee | 47187 | 377 | 7 |
83502 | 83502 | 2020-04-23 | Williamson | Tennessee | 47187 | 369 | 7 |
80703 | 80703 | 2020-04-22 | Williamson | Tennessee | 47187 | 365 | 6 |
77913 | 77913 | 2020-04-21 | Williamson | Tennessee | 47187 | 359 | 6 |
75131 | 75131 | 2020-04-20 | Williamson | Tennessee | 47187 | 358 | 6 |
72356 | 72356 | 2020-04-19 | Williamson | Tennessee | 47187 | 348 | 6 |
69589 | 69589 | 2020-04-18 | Williamson | Tennessee | 47187 | 342 | 6 |
66830 | 66830 | 2020-04-17 | Williamson | Tennessee | 47187 | 336 | 5 |
64083 | 64083 | 2020-04-16 | Williamson | Tennessee | 47187 | 324 | 5 |
61356 | 61356 | 2020-04-15 | Williamson | Tennessee | 47187 | 322 | 5 |
58640 | 58640 | 2020-04-14 | Williamson | Tennessee | 47187 | 322 | 5 |
55937 | 55937 | 2020-04-13 | Williamson | Tennessee | 47187 | 318 | 4 |
53249 | 53249 | 2020-04-12 | Williamson | Tennessee | 47187 | 312 | 4 |
50574 | 50574 | 2020-04-11 | Williamson | Tennessee | 47187 | 312 | 4 |
47917 | 47917 | 2020-04-10 | Williamson | Tennessee | 47187 | 299 | 4 |
45299 | 45299 | 2020-04-09 | Williamson | Tennessee | 47187 | 288 | 3 |
42711 | 42711 | 2020-04-08 | Williamson | Tennessee | 47187 | 287 | 3 |
40149 | 40149 | 2020-04-07 | Williamson | Tennessee | 47187 | 278 | 3 |
37627 | 37627 | 2020-04-06 | Williamson | Tennessee | 47187 | 260 | 2 |
35151 | 35151 | 2020-04-05 | Williamson | Tennessee | 47187 | 258 | 2 |
32714 | 32714 | 2020-04-04 | Williamson | Tennessee | 47187 | 239 | 2 |
30322 | 30322 | 2020-04-03 | Williamson | Tennessee | 47187 | 221 | 3 |
27987 | 27987 | 2020-04-02 | Williamson | Tennessee | 47187 | 199 | 3 |
25707 | 25707 | 2020-04-01 | Williamson | Tennessee | 47187 | 148 | 2 |
23504 | 23504 | 2020-03-31 | Williamson | Tennessee | 47187 | 111 | 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);