ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,537 rows where county = "Tyler" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
32849 | 32849 | 2020-04-04 | Tyler | Texas | 48457 | 1 | 0 |
35287 | 35287 | 2020-04-05 | Tyler | Texas | 48457 | 1 | 0 |
37764 | 37764 | 2020-04-06 | Tyler | Texas | 48457 | 2 | 0 |
40293 | 40293 | 2020-04-07 | Tyler | Texas | 48457 | 2 | 0 |
40542 | 40542 | 2020-04-07 | Tyler | West Virginia | 54095 | 1 | 0 |
42861 | 42861 | 2020-04-08 | Tyler | Texas | 48457 | 2 | 0 |
43114 | 43114 | 2020-04-08 | Tyler | West Virginia | 54095 | 1 | 0 |
45455 | 45455 | 2020-04-09 | Tyler | Texas | 48457 | 4 | 0 |
45710 | 45710 | 2020-04-09 | Tyler | West Virginia | 54095 | 2 | 0 |
48078 | 48078 | 2020-04-10 | Tyler | Texas | 48457 | 4 | 0 |
48338 | 48338 | 2020-04-10 | Tyler | West Virginia | 54095 | 2 | 0 |
50736 | 50736 | 2020-04-11 | Tyler | Texas | 48457 | 4 | 0 |
50998 | 50998 | 2020-04-11 | Tyler | West Virginia | 54095 | 3 | 0 |
53411 | 53411 | 2020-04-12 | Tyler | Texas | 48457 | 4 | 0 |
53675 | 53675 | 2020-04-12 | Tyler | West Virginia | 54095 | 3 | 0 |
56100 | 56100 | 2020-04-13 | Tyler | Texas | 48457 | 4 | 0 |
56365 | 56365 | 2020-04-13 | Tyler | West Virginia | 54095 | 3 | 0 |
58805 | 58805 | 2020-04-14 | Tyler | Texas | 48457 | 4 | 0 |
59072 | 59072 | 2020-04-14 | Tyler | West Virginia | 54095 | 3 | 0 |
61523 | 61523 | 2020-04-15 | Tyler | Texas | 48457 | 4 | 0 |
61791 | 61791 | 2020-04-15 | Tyler | West Virginia | 54095 | 3 | 0 |
64255 | 64255 | 2020-04-16 | Tyler | Texas | 48457 | 4 | 0 |
64524 | 64524 | 2020-04-16 | Tyler | West Virginia | 54095 | 3 | 0 |
67002 | 67002 | 2020-04-17 | Tyler | Texas | 48457 | 4 | 0 |
67272 | 67272 | 2020-04-17 | Tyler | West Virginia | 54095 | 3 | 0 |
69762 | 69762 | 2020-04-18 | Tyler | Texas | 48457 | 5 | 0 |
70034 | 70034 | 2020-04-18 | Tyler | West Virginia | 54095 | 3 | 0 |
72532 | 72532 | 2020-04-19 | Tyler | Texas | 48457 | 5 | 0 |
72803 | 72803 | 2020-04-19 | Tyler | West Virginia | 54095 | 3 | 0 |
75308 | 75308 | 2020-04-20 | Tyler | Texas | 48457 | 6 | 0 |
75579 | 75579 | 2020-04-20 | Tyler | West Virginia | 54095 | 3 | 0 |
78090 | 78090 | 2020-04-21 | Tyler | Texas | 48457 | 6 | 0 |
78362 | 78362 | 2020-04-21 | Tyler | West Virginia | 54095 | 3 | 0 |
80881 | 80881 | 2020-04-22 | Tyler | Texas | 48457 | 6 | 0 |
81155 | 81155 | 2020-04-22 | Tyler | West Virginia | 54095 | 3 | 0 |
83682 | 83682 | 2020-04-23 | Tyler | Texas | 48457 | 6 | 0 |
83956 | 83956 | 2020-04-23 | Tyler | West Virginia | 54095 | 3 | 0 |
86489 | 86489 | 2020-04-24 | Tyler | Texas | 48457 | 6 | 0 |
86763 | 86763 | 2020-04-24 | Tyler | West Virginia | 54095 | 3 | 0 |
89304 | 89304 | 2020-04-25 | Tyler | Texas | 48457 | 6 | 0 |
89579 | 89579 | 2020-04-25 | Tyler | West Virginia | 54095 | 3 | 0 |
92121 | 92121 | 2020-04-26 | Tyler | Texas | 48457 | 6 | 0 |
92397 | 92397 | 2020-04-26 | Tyler | West Virginia | 54095 | 3 | 0 |
94950 | 94950 | 2020-04-27 | Tyler | Texas | 48457 | 6 | 0 |
95227 | 95227 | 2020-04-27 | Tyler | West Virginia | 54095 | 3 | 0 |
97792 | 97792 | 2020-04-28 | Tyler | Texas | 48457 | 6 | 0 |
98072 | 98072 | 2020-04-28 | Tyler | West Virginia | 54095 | 3 | 0 |
100642 | 100642 | 2020-04-29 | Tyler | Texas | 48457 | 6 | 0 |
100922 | 100922 | 2020-04-29 | Tyler | West Virginia | 54095 | 3 | 0 |
103497 | 103497 | 2020-04-30 | Tyler | Texas | 48457 | 6 | 0 |
103777 | 103777 | 2020-04-30 | Tyler | West Virginia | 54095 | 3 | 0 |
106361 | 106361 | 2020-05-01 | Tyler | Texas | 48457 | 6 | 0 |
106641 | 106641 | 2020-05-01 | Tyler | West Virginia | 54095 | 3 | 0 |
109230 | 109230 | 2020-05-02 | Tyler | Texas | 48457 | 6 | 0 |
109510 | 109510 | 2020-05-02 | Tyler | West Virginia | 54095 | 3 | 0 |
112104 | 112104 | 2020-05-03 | Tyler | Texas | 48457 | 6 | 0 |
112385 | 112385 | 2020-05-03 | Tyler | West Virginia | 54095 | 3 | 0 |
114987 | 114987 | 2020-05-04 | Tyler | Texas | 48457 | 6 | 0 |
115268 | 115268 | 2020-05-04 | Tyler | West Virginia | 54095 | 3 | 0 |
117946 | 117946 | 2020-05-05 | Tyler | Texas | 48457 | 7 | 0 |
118227 | 118227 | 2020-05-05 | Tyler | West Virginia | 54095 | 3 | 0 |
120910 | 120910 | 2020-05-06 | Tyler | Texas | 48457 | 7 | 0 |
121192 | 121192 | 2020-05-06 | Tyler | West Virginia | 54095 | 3 | 0 |
123890 | 123890 | 2020-05-07 | Tyler | Texas | 48457 | 7 | 0 |
124172 | 124172 | 2020-05-07 | Tyler | West Virginia | 54095 | 3 | 0 |
126875 | 126875 | 2020-05-08 | Tyler | Texas | 48457 | 7 | 0 |
127157 | 127157 | 2020-05-08 | Tyler | West Virginia | 54095 | 3 | 0 |
129864 | 129864 | 2020-05-09 | Tyler | Texas | 48457 | 7 | 0 |
130147 | 130147 | 2020-05-09 | Tyler | West Virginia | 54095 | 3 | 0 |
132854 | 132854 | 2020-05-10 | Tyler | Texas | 48457 | 7 | 0 |
133137 | 133137 | 2020-05-10 | Tyler | West Virginia | 54095 | 3 | 0 |
135845 | 135845 | 2020-05-11 | Tyler | Texas | 48457 | 7 | 0 |
136127 | 136127 | 2020-05-11 | Tyler | West Virginia | 54095 | 3 | 0 |
138835 | 138835 | 2020-05-12 | Tyler | Texas | 48457 | 8 | 0 |
139118 | 139118 | 2020-05-12 | Tyler | West Virginia | 54095 | 3 | 0 |
141831 | 141831 | 2020-05-13 | Tyler | Texas | 48457 | 8 | 0 |
142114 | 142114 | 2020-05-13 | Tyler | West Virginia | 54095 | 3 | 0 |
144828 | 144828 | 2020-05-14 | Tyler | Texas | 48457 | 8 | 0 |
145111 | 145111 | 2020-05-14 | Tyler | West Virginia | 54095 | 3 | 0 |
147832 | 147832 | 2020-05-15 | Tyler | Texas | 48457 | 8 | 0 |
148114 | 148114 | 2020-05-15 | Tyler | West Virginia | 54095 | 3 | 0 |
150840 | 150840 | 2020-05-16 | Tyler | Texas | 48457 | 9 | 0 |
151123 | 151123 | 2020-05-16 | Tyler | West Virginia | 54095 | 3 | 0 |
153851 | 153851 | 2020-05-17 | Tyler | Texas | 48457 | 9 | 0 |
154134 | 154134 | 2020-05-17 | Tyler | West Virginia | 54095 | 3 | 0 |
156868 | 156868 | 2020-05-18 | Tyler | Texas | 48457 | 9 | 0 |
157151 | 157151 | 2020-05-18 | Tyler | West Virginia | 54095 | 3 | 0 |
159892 | 159892 | 2020-05-19 | Tyler | Texas | 48457 | 10 | 0 |
160175 | 160175 | 2020-05-19 | Tyler | West Virginia | 54095 | 3 | 0 |
162920 | 162920 | 2020-05-20 | Tyler | Texas | 48457 | 12 | 0 |
163203 | 163203 | 2020-05-20 | Tyler | West Virginia | 54095 | 3 | 0 |
165949 | 165949 | 2020-05-21 | Tyler | Texas | 48457 | 12 | 0 |
166232 | 166232 | 2020-05-21 | Tyler | West Virginia | 54095 | 3 | 0 |
168985 | 168985 | 2020-05-22 | Tyler | Texas | 48457 | 12 | 0 |
169268 | 169268 | 2020-05-22 | Tyler | West Virginia | 54095 | 3 | 0 |
172025 | 172025 | 2020-05-23 | Tyler | Texas | 48457 | 12 | 0 |
172309 | 172309 | 2020-05-23 | Tyler | West Virginia | 54095 | 3 | 0 |
175068 | 175068 | 2020-05-24 | Tyler | Texas | 48457 | 12 | 0 |
175352 | 175352 | 2020-05-24 | Tyler | West Virginia | 54095 | 3 | 0 |
178113 | 178113 | 2020-05-25 | Tyler | Texas | 48457 | 12 | 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);