ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,566 rows where county = "Sumner" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4290 | 4290 | 2020-03-18 | Sumner | Tennessee | 47165 | 2 | 0 |
5038 | 5038 | 2020-03-19 | Sumner | Tennessee | 47165 | 3 | 0 |
5926 | 5926 | 2020-03-20 | Sumner | Tennessee | 47165 | 11 | 0 |
6943 | 6943 | 2020-03-21 | Sumner | Tennessee | 47165 | 11 | 0 |
8073 | 8073 | 2020-03-22 | Sumner | Tennessee | 47165 | 22 | 0 |
9291 | 9291 | 2020-03-23 | Sumner | Tennessee | 47165 | 22 | 0 |
10625 | 10625 | 2020-03-24 | Sumner | Tennessee | 47165 | 34 | 0 |
12104 | 12104 | 2020-03-25 | Sumner | Tennessee | 47165 | 36 | 0 |
12904 | 12904 | 2020-03-26 | Sumner | Kansas | 20191 | 1 | 0 |
13730 | 13730 | 2020-03-26 | Sumner | Tennessee | 47165 | 43 | 0 |
14607 | 14607 | 2020-03-27 | Sumner | Kansas | 20191 | 1 | 0 |
15483 | 15483 | 2020-03-27 | Sumner | Tennessee | 47165 | 58 | 0 |
16415 | 16415 | 2020-03-28 | Sumner | Kansas | 20191 | 1 | 0 |
17347 | 17347 | 2020-03-28 | Sumner | Tennessee | 47165 | 82 | 0 |
18324 | 18324 | 2020-03-29 | Sumner | Kansas | 20191 | 1 | 0 |
19297 | 19297 | 2020-03-29 | Sumner | Tennessee | 47165 | 93 | 0 |
20338 | 20338 | 2020-03-30 | Sumner | Kansas | 20191 | 1 | 0 |
21354 | 21354 | 2020-03-30 | Sumner | Tennessee | 47165 | 164 | 0 |
22437 | 22437 | 2020-03-31 | Sumner | Kansas | 20191 | 1 | 0 |
23493 | 23493 | 2020-03-31 | Sumner | Tennessee | 47165 | 164 | 0 |
24613 | 24613 | 2020-04-01 | Sumner | Kansas | 20191 | 1 | 0 |
25696 | 25696 | 2020-04-01 | Sumner | Tennessee | 47165 | 201 | 7 |
26857 | 26857 | 2020-04-02 | Sumner | Kansas | 20191 | 1 | 0 |
27976 | 27976 | 2020-04-02 | Sumner | Tennessee | 47165 | 268 | 7 |
29173 | 29173 | 2020-04-03 | Sumner | Kansas | 20191 | 2 | 0 |
30311 | 30311 | 2020-04-03 | Sumner | Tennessee | 47165 | 283 | 8 |
31547 | 31547 | 2020-04-04 | Sumner | Kansas | 20191 | 2 | 0 |
32703 | 32703 | 2020-04-04 | Sumner | Tennessee | 47165 | 301 | 10 |
33962 | 33962 | 2020-04-05 | Sumner | Kansas | 20191 | 2 | 0 |
35140 | 35140 | 2020-04-05 | Sumner | Tennessee | 47165 | 321 | 10 |
36420 | 36420 | 2020-04-06 | Sumner | Kansas | 20191 | 2 | 0 |
37616 | 37616 | 2020-04-06 | Sumner | Tennessee | 47165 | 335 | 15 |
38925 | 38925 | 2020-04-07 | Sumner | Kansas | 20191 | 2 | 0 |
40139 | 40139 | 2020-04-07 | Sumner | Tennessee | 47165 | 361 | 15 |
41472 | 41472 | 2020-04-08 | Sumner | Kansas | 20191 | 2 | 0 |
42701 | 42701 | 2020-04-08 | Sumner | Tennessee | 47165 | 376 | 18 |
44048 | 44048 | 2020-04-09 | Sumner | Kansas | 20191 | 2 | 1 |
45288 | 45288 | 2020-04-09 | Sumner | Tennessee | 47165 | 389 | 18 |
46655 | 46655 | 2020-04-10 | Sumner | Kansas | 20191 | 2 | 1 |
47906 | 47906 | 2020-04-10 | Sumner | Tennessee | 47165 | 413 | 21 |
49292 | 49292 | 2020-04-11 | Sumner | Kansas | 20191 | 2 | 1 |
50564 | 50564 | 2020-04-11 | Sumner | Tennessee | 47165 | 435 | 22 |
51958 | 51958 | 2020-04-12 | Sumner | Kansas | 20191 | 2 | 1 |
53239 | 53239 | 2020-04-12 | Sumner | Tennessee | 47165 | 435 | 22 |
54640 | 54640 | 2020-04-13 | Sumner | Kansas | 20191 | 2 | 1 |
55926 | 55926 | 2020-04-13 | Sumner | Tennessee | 47165 | 454 | 26 |
57334 | 57334 | 2020-04-14 | Sumner | Kansas | 20191 | 2 | 1 |
58629 | 58629 | 2020-04-14 | Sumner | Tennessee | 47165 | 466 | 27 |
60043 | 60043 | 2020-04-15 | Sumner | Kansas | 20191 | 2 | 1 |
61345 | 61345 | 2020-04-15 | Sumner | Tennessee | 47165 | 478 | 27 |
62764 | 62764 | 2020-04-16 | Sumner | Kansas | 20191 | 3 | 1 |
64072 | 64072 | 2020-04-16 | Sumner | Tennessee | 47165 | 491 | 28 |
65501 | 65501 | 2020-04-17 | Sumner | Kansas | 20191 | 3 | 1 |
66819 | 66819 | 2020-04-17 | Sumner | Tennessee | 47165 | 497 | 29 |
68250 | 68250 | 2020-04-18 | Sumner | Kansas | 20191 | 3 | 1 |
69578 | 69578 | 2020-04-18 | Sumner | Tennessee | 47165 | 503 | 30 |
71012 | 71012 | 2020-04-19 | Sumner | Kansas | 20191 | 3 | 1 |
72345 | 72345 | 2020-04-19 | Sumner | Tennessee | 47165 | 509 | 30 |
73784 | 73784 | 2020-04-20 | Sumner | Kansas | 20191 | 3 | 1 |
75120 | 75120 | 2020-04-20 | Sumner | Tennessee | 47165 | 518 | 31 |
76564 | 76564 | 2020-04-21 | Sumner | Kansas | 20191 | 3 | 1 |
77902 | 77902 | 2020-04-21 | Sumner | Tennessee | 47165 | 530 | 31 |
79349 | 79349 | 2020-04-22 | Sumner | Kansas | 20191 | 3 | 1 |
80692 | 80692 | 2020-04-22 | Sumner | Tennessee | 47165 | 550 | 32 |
82145 | 82145 | 2020-04-23 | Sumner | Kansas | 20191 | 3 | 1 |
83491 | 83491 | 2020-04-23 | Sumner | Tennessee | 47165 | 556 | 32 |
84948 | 84948 | 2020-04-24 | Sumner | Kansas | 20191 | 3 | 1 |
86296 | 86296 | 2020-04-24 | Sumner | Tennessee | 47165 | 573 | 32 |
87757 | 87757 | 2020-04-25 | Sumner | Kansas | 20191 | 3 | 1 |
89111 | 89111 | 2020-04-25 | Sumner | Tennessee | 47165 | 584 | 34 |
90573 | 90573 | 2020-04-26 | Sumner | Kansas | 20191 | 3 | 1 |
91928 | 91928 | 2020-04-26 | Sumner | Tennessee | 47165 | 593 | 34 |
93394 | 93394 | 2020-04-27 | Sumner | Kansas | 20191 | 3 | 1 |
94756 | 94756 | 2020-04-27 | Sumner | Tennessee | 47165 | 603 | 34 |
96227 | 96227 | 2020-04-28 | Sumner | Kansas | 20191 | 3 | 1 |
97596 | 97596 | 2020-04-28 | Sumner | Tennessee | 47165 | 608 | 35 |
99073 | 99073 | 2020-04-29 | Sumner | Kansas | 20191 | 3 | 1 |
100446 | 100446 | 2020-04-29 | Sumner | Tennessee | 47165 | 619 | 37 |
101925 | 101925 | 2020-04-30 | Sumner | Kansas | 20191 | 3 | 1 |
103299 | 103299 | 2020-04-30 | Sumner | Tennessee | 47165 | 623 | 37 |
104786 | 104786 | 2020-05-01 | Sumner | Kansas | 20191 | 3 | 1 |
106162 | 106162 | 2020-05-01 | Sumner | Tennessee | 47165 | 632 | 37 |
107651 | 107651 | 2020-05-02 | Sumner | Kansas | 20191 | 3 | 1 |
109029 | 109029 | 2020-05-02 | Sumner | Tennessee | 47165 | 640 | 38 |
110522 | 110522 | 2020-05-03 | Sumner | Kansas | 20191 | 4 | 1 |
111903 | 111903 | 2020-05-03 | Sumner | Tennessee | 47165 | 653 | 38 |
113399 | 113399 | 2020-05-04 | Sumner | Kansas | 20191 | 4 | 1 |
114785 | 114785 | 2020-05-04 | Sumner | Tennessee | 47165 | 663 | 38 |
116281 | 116281 | 2020-05-05 | Sumner | Kansas | 20191 | 4 | 1 |
117741 | 117741 | 2020-05-05 | Sumner | Tennessee | 47165 | 665 | 38 |
119242 | 119242 | 2020-05-06 | Sumner | Kansas | 20191 | 4 | 1 |
120705 | 120705 | 2020-05-06 | Sumner | Tennessee | 47165 | 671 | 38 |
122212 | 122212 | 2020-05-07 | Sumner | Kansas | 20191 | 4 | 1 |
123683 | 123683 | 2020-05-07 | Sumner | Tennessee | 47165 | 672 | 38 |
125194 | 125194 | 2020-05-08 | Sumner | Kansas | 20191 | 4 | 1 |
126666 | 126666 | 2020-05-08 | Sumner | Tennessee | 47165 | 683 | 38 |
128182 | 128182 | 2020-05-09 | Sumner | Kansas | 20191 | 4 | 1 |
129655 | 129655 | 2020-05-09 | Sumner | Tennessee | 47165 | 693 | 38 |
131172 | 131172 | 2020-05-10 | Sumner | Kansas | 20191 | 4 | 1 |
132645 | 132645 | 2020-05-10 | Sumner | Tennessee | 47165 | 698 | 38 |
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);