ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Tyler" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
324680 | 324680 | 2020-07-11 | Tyler | Texas | 48457 | 36 | 0 |
321499 | 321499 | 2020-07-10 | Tyler | Texas | 48457 | 36 | 0 |
318320 | 318320 | 2020-07-09 | Tyler | Texas | 48457 | 30 | 0 |
315147 | 315147 | 2020-07-08 | Tyler | Texas | 48457 | 30 | 0 |
311973 | 311973 | 2020-07-07 | Tyler | Texas | 48457 | 30 | 0 |
308804 | 308804 | 2020-07-06 | Tyler | Texas | 48457 | 27 | 0 |
305636 | 305636 | 2020-07-05 | Tyler | Texas | 48457 | 27 | 0 |
302472 | 302472 | 2020-07-04 | Tyler | Texas | 48457 | 27 | 0 |
299308 | 299308 | 2020-07-03 | Tyler | Texas | 48457 | 27 | 0 |
296146 | 296146 | 2020-07-02 | Tyler | Texas | 48457 | 25 | 0 |
292991 | 292991 | 2020-07-01 | Tyler | Texas | 48457 | 25 | 0 |
289838 | 289838 | 2020-06-30 | Tyler | Texas | 48457 | 25 | 0 |
286688 | 286688 | 2020-06-29 | Tyler | Texas | 48457 | 25 | 0 |
283542 | 283542 | 2020-06-28 | Tyler | Texas | 48457 | 25 | 0 |
280396 | 280396 | 2020-06-27 | Tyler | Texas | 48457 | 21 | 0 |
277248 | 277248 | 2020-06-26 | Tyler | Texas | 48457 | 21 | 0 |
274100 | 274100 | 2020-06-25 | Tyler | Texas | 48457 | 21 | 0 |
270960 | 270960 | 2020-06-24 | Tyler | Texas | 48457 | 21 | 0 |
267826 | 267826 | 2020-06-23 | Tyler | Texas | 48457 | 20 | 0 |
264697 | 264697 | 2020-06-22 | Tyler | Texas | 48457 | 18 | 0 |
261568 | 261568 | 2020-06-21 | Tyler | Texas | 48457 | 18 | 0 |
258441 | 258441 | 2020-06-20 | Tyler | Texas | 48457 | 18 | 0 |
255314 | 255314 | 2020-06-19 | Tyler | Texas | 48457 | 14 | 0 |
252198 | 252198 | 2020-06-18 | Tyler | Texas | 48457 | 14 | 0 |
249083 | 249083 | 2020-06-17 | Tyler | Texas | 48457 | 14 | 0 |
245970 | 245970 | 2020-06-16 | Tyler | Texas | 48457 | 14 | 0 |
242858 | 242858 | 2020-06-15 | Tyler | Texas | 48457 | 16 | 0 |
239748 | 239748 | 2020-06-14 | Tyler | Texas | 48457 | 16 | 0 |
236640 | 236640 | 2020-06-13 | Tyler | Texas | 48457 | 16 | 0 |
233533 | 233533 | 2020-06-12 | Tyler | Texas | 48457 | 16 | 0 |
230429 | 230429 | 2020-06-11 | Tyler | Texas | 48457 | 16 | 0 |
227325 | 227325 | 2020-06-10 | Tyler | Texas | 48457 | 16 | 0 |
224225 | 224225 | 2020-06-09 | Tyler | Texas | 48457 | 16 | 0 |
221129 | 221129 | 2020-06-08 | Tyler | Texas | 48457 | 16 | 0 |
218037 | 218037 | 2020-06-07 | Tyler | Texas | 48457 | 16 | 0 |
214947 | 214947 | 2020-06-06 | Tyler | Texas | 48457 | 15 | 0 |
211860 | 211860 | 2020-06-05 | Tyler | Texas | 48457 | 14 | 0 |
208775 | 208775 | 2020-06-04 | Tyler | Texas | 48457 | 14 | 0 |
205693 | 205693 | 2020-06-03 | Tyler | Texas | 48457 | 12 | 0 |
202614 | 202614 | 2020-06-02 | Tyler | Texas | 48457 | 12 | 0 |
199538 | 199538 | 2020-06-01 | Tyler | Texas | 48457 | 12 | 0 |
196465 | 196465 | 2020-05-31 | Tyler | Texas | 48457 | 12 | 0 |
193395 | 193395 | 2020-05-30 | Tyler | Texas | 48457 | 12 | 0 |
190329 | 190329 | 2020-05-29 | Tyler | Texas | 48457 | 12 | 0 |
187265 | 187265 | 2020-05-28 | Tyler | Texas | 48457 | 12 | 0 |
184208 | 184208 | 2020-05-27 | Tyler | Texas | 48457 | 12 | 0 |
181157 | 181157 | 2020-05-26 | Tyler | Texas | 48457 | 12 | 0 |
178113 | 178113 | 2020-05-25 | Tyler | Texas | 48457 | 12 | 0 |
175068 | 175068 | 2020-05-24 | Tyler | Texas | 48457 | 12 | 0 |
172025 | 172025 | 2020-05-23 | Tyler | Texas | 48457 | 12 | 0 |
168985 | 168985 | 2020-05-22 | Tyler | Texas | 48457 | 12 | 0 |
165949 | 165949 | 2020-05-21 | Tyler | Texas | 48457 | 12 | 0 |
162920 | 162920 | 2020-05-20 | Tyler | Texas | 48457 | 12 | 0 |
159892 | 159892 | 2020-05-19 | Tyler | Texas | 48457 | 10 | 0 |
156868 | 156868 | 2020-05-18 | Tyler | Texas | 48457 | 9 | 0 |
153851 | 153851 | 2020-05-17 | Tyler | Texas | 48457 | 9 | 0 |
150840 | 150840 | 2020-05-16 | Tyler | Texas | 48457 | 9 | 0 |
147832 | 147832 | 2020-05-15 | Tyler | Texas | 48457 | 8 | 0 |
144828 | 144828 | 2020-05-14 | Tyler | Texas | 48457 | 8 | 0 |
141831 | 141831 | 2020-05-13 | Tyler | Texas | 48457 | 8 | 0 |
138835 | 138835 | 2020-05-12 | Tyler | Texas | 48457 | 8 | 0 |
135845 | 135845 | 2020-05-11 | Tyler | Texas | 48457 | 7 | 0 |
132854 | 132854 | 2020-05-10 | Tyler | Texas | 48457 | 7 | 0 |
129864 | 129864 | 2020-05-09 | Tyler | Texas | 48457 | 7 | 0 |
126875 | 126875 | 2020-05-08 | Tyler | Texas | 48457 | 7 | 0 |
123890 | 123890 | 2020-05-07 | Tyler | Texas | 48457 | 7 | 0 |
120910 | 120910 | 2020-05-06 | Tyler | Texas | 48457 | 7 | 0 |
117946 | 117946 | 2020-05-05 | Tyler | Texas | 48457 | 7 | 0 |
114987 | 114987 | 2020-05-04 | Tyler | Texas | 48457 | 6 | 0 |
112104 | 112104 | 2020-05-03 | Tyler | Texas | 48457 | 6 | 0 |
109230 | 109230 | 2020-05-02 | Tyler | Texas | 48457 | 6 | 0 |
106361 | 106361 | 2020-05-01 | Tyler | Texas | 48457 | 6 | 0 |
103497 | 103497 | 2020-04-30 | Tyler | Texas | 48457 | 6 | 0 |
100642 | 100642 | 2020-04-29 | Tyler | Texas | 48457 | 6 | 0 |
97792 | 97792 | 2020-04-28 | Tyler | Texas | 48457 | 6 | 0 |
94950 | 94950 | 2020-04-27 | Tyler | Texas | 48457 | 6 | 0 |
92121 | 92121 | 2020-04-26 | Tyler | Texas | 48457 | 6 | 0 |
89304 | 89304 | 2020-04-25 | Tyler | Texas | 48457 | 6 | 0 |
86489 | 86489 | 2020-04-24 | Tyler | Texas | 48457 | 6 | 0 |
83682 | 83682 | 2020-04-23 | Tyler | Texas | 48457 | 6 | 0 |
80881 | 80881 | 2020-04-22 | Tyler | Texas | 48457 | 6 | 0 |
78090 | 78090 | 2020-04-21 | Tyler | Texas | 48457 | 6 | 0 |
75308 | 75308 | 2020-04-20 | Tyler | Texas | 48457 | 6 | 0 |
72532 | 72532 | 2020-04-19 | Tyler | Texas | 48457 | 5 | 0 |
69762 | 69762 | 2020-04-18 | Tyler | Texas | 48457 | 5 | 0 |
67002 | 67002 | 2020-04-17 | Tyler | Texas | 48457 | 4 | 0 |
64255 | 64255 | 2020-04-16 | Tyler | Texas | 48457 | 4 | 0 |
61523 | 61523 | 2020-04-15 | Tyler | Texas | 48457 | 4 | 0 |
58805 | 58805 | 2020-04-14 | Tyler | Texas | 48457 | 4 | 0 |
56100 | 56100 | 2020-04-13 | Tyler | Texas | 48457 | 4 | 0 |
53411 | 53411 | 2020-04-12 | Tyler | Texas | 48457 | 4 | 0 |
50736 | 50736 | 2020-04-11 | Tyler | Texas | 48457 | 4 | 0 |
48078 | 48078 | 2020-04-10 | Tyler | Texas | 48457 | 4 | 0 |
45455 | 45455 | 2020-04-09 | Tyler | Texas | 48457 | 4 | 0 |
42861 | 42861 | 2020-04-08 | Tyler | Texas | 48457 | 2 | 0 |
40293 | 40293 | 2020-04-07 | Tyler | Texas | 48457 | 2 | 0 |
37764 | 37764 | 2020-04-06 | Tyler | Texas | 48457 | 2 | 0 |
35287 | 35287 | 2020-04-05 | Tyler | Texas | 48457 | 1 | 0 |
32849 | 32849 | 2020-04-04 | Tyler | Texas | 48457 | 1 | 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);