ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,565 rows where county = "Blount" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5906 | 5906 | 2020-03-20 | Blount | Tennessee | 47009 | 1 | 0 |
6916 | 6916 | 2020-03-21 | Blount | Tennessee | 47009 | 1 | 0 |
8038 | 8038 | 2020-03-22 | Blount | Tennessee | 47009 | 1 | 0 |
9256 | 9256 | 2020-03-23 | Blount | Tennessee | 47009 | 1 | 0 |
10583 | 10583 | 2020-03-24 | Blount | Tennessee | 47009 | 3 | 0 |
10838 | 10838 | 2020-03-25 | Blount | Alabama | 1009 | 1 | 0 |
12060 | 12060 | 2020-03-25 | Blount | Tennessee | 47009 | 3 | 0 |
12370 | 12370 | 2020-03-26 | Blount | Alabama | 1009 | 3 | 0 |
13683 | 13683 | 2020-03-26 | Blount | Tennessee | 47009 | 4 | 0 |
14028 | 14028 | 2020-03-27 | Blount | Alabama | 1009 | 5 | 0 |
15435 | 15435 | 2020-03-27 | Blount | Tennessee | 47009 | 6 | 0 |
15806 | 15806 | 2020-03-28 | Blount | Alabama | 1009 | 5 | 0 |
17295 | 17295 | 2020-03-28 | Blount | Tennessee | 47009 | 9 | 0 |
17689 | 17689 | 2020-03-29 | Blount | Alabama | 1009 | 5 | 0 |
19240 | 19240 | 2020-03-29 | Blount | Tennessee | 47009 | 9 | 0 |
19659 | 19659 | 2020-03-30 | Blount | Alabama | 1009 | 5 | 0 |
21293 | 21293 | 2020-03-30 | Blount | Tennessee | 47009 | 10 | 0 |
21731 | 21731 | 2020-03-31 | Blount | Alabama | 1009 | 5 | 0 |
23431 | 23431 | 2020-03-31 | Blount | Tennessee | 47009 | 25 | 0 |
23884 | 23884 | 2020-04-01 | Blount | Alabama | 1009 | 5 | 0 |
25629 | 25629 | 2020-04-01 | Blount | Tennessee | 47009 | 28 | 0 |
26105 | 26105 | 2020-04-02 | Blount | Alabama | 1009 | 6 | 0 |
27907 | 27907 | 2020-04-02 | Blount | Tennessee | 47009 | 32 | 0 |
28401 | 28401 | 2020-04-03 | Blount | Alabama | 1009 | 9 | 0 |
30242 | 30242 | 2020-04-03 | Blount | Tennessee | 47009 | 33 | 0 |
30758 | 30758 | 2020-04-04 | Blount | Alabama | 1009 | 10 | 0 |
32633 | 32633 | 2020-04-04 | Blount | Tennessee | 47009 | 34 | 0 |
33162 | 33162 | 2020-04-05 | Blount | Alabama | 1009 | 10 | 0 |
35069 | 35069 | 2020-04-05 | Blount | Tennessee | 47009 | 36 | 1 |
35601 | 35601 | 2020-04-06 | Blount | Alabama | 1009 | 10 | 0 |
37545 | 37545 | 2020-04-06 | Blount | Tennessee | 47009 | 38 | 2 |
38089 | 38089 | 2020-04-07 | Blount | Alabama | 1009 | 10 | 0 |
40068 | 40068 | 2020-04-07 | Blount | Tennessee | 47009 | 41 | 2 |
40631 | 40631 | 2020-04-08 | Blount | Alabama | 1009 | 10 | 0 |
42629 | 42629 | 2020-04-08 | Blount | Tennessee | 47009 | 42 | 2 |
43204 | 43204 | 2020-04-09 | Blount | Alabama | 1009 | 11 | 0 |
45216 | 45216 | 2020-04-09 | Blount | Tennessee | 47009 | 44 | 2 |
45802 | 45802 | 2020-04-10 | Blount | Alabama | 1009 | 12 | 0 |
47834 | 47834 | 2020-04-10 | Blount | Tennessee | 47009 | 45 | 3 |
48431 | 48431 | 2020-04-11 | Blount | Alabama | 1009 | 12 | 0 |
50492 | 50492 | 2020-04-11 | Blount | Tennessee | 47009 | 46 | 3 |
51092 | 51092 | 2020-04-12 | Blount | Alabama | 1009 | 13 | 0 |
53167 | 53167 | 2020-04-12 | Blount | Tennessee | 47009 | 46 | 3 |
53770 | 53770 | 2020-04-13 | Blount | Alabama | 1009 | 15 | 0 |
55853 | 55853 | 2020-04-13 | Blount | Tennessee | 47009 | 46 | 3 |
56462 | 56462 | 2020-04-14 | Blount | Alabama | 1009 | 16 | 0 |
58556 | 58556 | 2020-04-14 | Blount | Tennessee | 47009 | 47 | 3 |
59170 | 59170 | 2020-04-15 | Blount | Alabama | 1009 | 17 | 0 |
61271 | 61271 | 2020-04-15 | Blount | Tennessee | 47009 | 47 | 3 |
61888 | 61888 | 2020-04-16 | Blount | Alabama | 1009 | 18 | 0 |
63998 | 63998 | 2020-04-16 | Blount | Tennessee | 47009 | 46 | 3 |
64621 | 64621 | 2020-04-17 | Blount | Alabama | 1009 | 20 | 0 |
66744 | 66744 | 2020-04-17 | Blount | Tennessee | 47009 | 46 | 3 |
67369 | 67369 | 2020-04-18 | Blount | Alabama | 1009 | 20 | 0 |
69502 | 69502 | 2020-04-18 | Blount | Tennessee | 47009 | 46 | 3 |
70131 | 70131 | 2020-04-19 | Blount | Alabama | 1009 | 21 | 0 |
72269 | 72269 | 2020-04-19 | Blount | Tennessee | 47009 | 46 | 3 |
72900 | 72900 | 2020-04-20 | Blount | Alabama | 1009 | 22 | 0 |
75044 | 75044 | 2020-04-20 | Blount | Tennessee | 47009 | 46 | 3 |
75676 | 75676 | 2020-04-21 | Blount | Alabama | 1009 | 26 | 0 |
77826 | 77826 | 2020-04-21 | Blount | Tennessee | 47009 | 46 | 3 |
78459 | 78459 | 2020-04-22 | Blount | Alabama | 1009 | 29 | 0 |
80616 | 80616 | 2020-04-22 | Blount | Tennessee | 47009 | 47 | 3 |
81252 | 81252 | 2020-04-23 | Blount | Alabama | 1009 | 31 | 0 |
83415 | 83415 | 2020-04-23 | Blount | Tennessee | 47009 | 48 | 3 |
84053 | 84053 | 2020-04-24 | Blount | Alabama | 1009 | 31 | 0 |
86220 | 86220 | 2020-04-24 | Blount | Tennessee | 47009 | 49 | 3 |
86861 | 86861 | 2020-04-25 | Blount | Alabama | 1009 | 31 | 0 |
89035 | 89035 | 2020-04-25 | Blount | Tennessee | 47009 | 53 | 3 |
89677 | 89677 | 2020-04-26 | Blount | Alabama | 1009 | 34 | 0 |
91852 | 91852 | 2020-04-26 | Blount | Tennessee | 47009 | 53 | 3 |
92495 | 92495 | 2020-04-27 | Blount | Alabama | 1009 | 34 | 0 |
94680 | 94680 | 2020-04-27 | Blount | Tennessee | 47009 | 54 | 3 |
95325 | 95325 | 2020-04-28 | Blount | Alabama | 1009 | 34 | 0 |
97520 | 97520 | 2020-04-28 | Blount | Tennessee | 47009 | 55 | 3 |
98170 | 98170 | 2020-04-29 | Blount | Alabama | 1009 | 36 | 0 |
100370 | 100370 | 2020-04-29 | Blount | Tennessee | 47009 | 55 | 3 |
101020 | 101020 | 2020-04-30 | Blount | Alabama | 1009 | 37 | 0 |
103223 | 103223 | 2020-04-30 | Blount | Tennessee | 47009 | 56 | 3 |
103875 | 103875 | 2020-05-01 | Blount | Alabama | 1009 | 39 | 0 |
106086 | 106086 | 2020-05-01 | Blount | Tennessee | 47009 | 58 | 3 |
106740 | 106740 | 2020-05-02 | Blount | Alabama | 1009 | 40 | 0 |
108953 | 108953 | 2020-05-02 | Blount | Tennessee | 47009 | 63 | 3 |
109609 | 109609 | 2020-05-03 | Blount | Alabama | 1009 | 40 | 0 |
111827 | 111827 | 2020-05-03 | Blount | Tennessee | 47009 | 63 | 3 |
112484 | 112484 | 2020-05-04 | Blount | Alabama | 1009 | 40 | 0 |
114709 | 114709 | 2020-05-04 | Blount | Tennessee | 47009 | 70 | 3 |
115367 | 115367 | 2020-05-05 | Blount | Alabama | 1009 | 40 | 0 |
117665 | 117665 | 2020-05-05 | Blount | Tennessee | 47009 | 73 | 3 |
118326 | 118326 | 2020-05-06 | Blount | Alabama | 1009 | 42 | 0 |
120629 | 120629 | 2020-05-06 | Blount | Tennessee | 47009 | 69 | 3 |
121292 | 121292 | 2020-05-07 | Blount | Alabama | 1009 | 44 | 0 |
123607 | 123607 | 2020-05-07 | Blount | Tennessee | 47009 | 69 | 3 |
124272 | 124272 | 2020-05-08 | Blount | Alabama | 1009 | 44 | 0 |
126590 | 126590 | 2020-05-08 | Blount | Tennessee | 47009 | 69 | 3 |
127257 | 127257 | 2020-05-09 | Blount | Alabama | 1009 | 44 | 0 |
129579 | 129579 | 2020-05-09 | Blount | Tennessee | 47009 | 71 | 3 |
130247 | 130247 | 2020-05-10 | Blount | Alabama | 1009 | 44 | 0 |
132568 | 132568 | 2020-05-10 | Blount | Tennessee | 47009 | 71 | 3 |
133237 | 133237 | 2020-05-11 | Blount | Alabama | 1009 | 45 | 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);