ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where county = "Lynn", deaths = 1 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
330978 | 330978 | 2020-07-13 | Lynn | Texas | 48305 | 53 | 1 |
327792 | 327792 | 2020-07-12 | Lynn | Texas | 48305 | 53 | 1 |
324607 | 324607 | 2020-07-11 | Lynn | Texas | 48305 | 53 | 1 |
321426 | 321426 | 2020-07-10 | Lynn | Texas | 48305 | 49 | 1 |
318247 | 318247 | 2020-07-09 | Lynn | Texas | 48305 | 49 | 1 |
315074 | 315074 | 2020-07-08 | Lynn | Texas | 48305 | 45 | 1 |
311900 | 311900 | 2020-07-07 | Lynn | Texas | 48305 | 40 | 1 |
308731 | 308731 | 2020-07-06 | Lynn | Texas | 48305 | 39 | 1 |
305563 | 305563 | 2020-07-05 | Lynn | Texas | 48305 | 39 | 1 |
302399 | 302399 | 2020-07-04 | Lynn | Texas | 48305 | 39 | 1 |
299235 | 299235 | 2020-07-03 | Lynn | Texas | 48305 | 38 | 1 |
296074 | 296074 | 2020-07-02 | Lynn | Texas | 48305 | 38 | 1 |
292919 | 292919 | 2020-07-01 | Lynn | Texas | 48305 | 33 | 1 |
289766 | 289766 | 2020-06-30 | Lynn | Texas | 48305 | 33 | 1 |
286616 | 286616 | 2020-06-29 | Lynn | Texas | 48305 | 28 | 1 |
283470 | 283470 | 2020-06-28 | Lynn | Texas | 48305 | 28 | 1 |
280324 | 280324 | 2020-06-27 | Lynn | Texas | 48305 | 28 | 1 |
277176 | 277176 | 2020-06-26 | Lynn | Texas | 48305 | 28 | 1 |
274028 | 274028 | 2020-06-25 | Lynn | Texas | 48305 | 26 | 1 |
270888 | 270888 | 2020-06-24 | Lynn | Texas | 48305 | 23 | 1 |
267754 | 267754 | 2020-06-23 | Lynn | Texas | 48305 | 23 | 1 |
264626 | 264626 | 2020-06-22 | Lynn | Texas | 48305 | 21 | 1 |
261498 | 261498 | 2020-06-21 | Lynn | Texas | 48305 | 21 | 1 |
258371 | 258371 | 2020-06-20 | Lynn | Texas | 48305 | 21 | 1 |
255244 | 255244 | 2020-06-19 | Lynn | Texas | 48305 | 21 | 1 |
252129 | 252129 | 2020-06-18 | Lynn | Texas | 48305 | 21 | 1 |
249014 | 249014 | 2020-06-17 | Lynn | Texas | 48305 | 21 | 1 |
245901 | 245901 | 2020-06-16 | Lynn | Texas | 48305 | 21 | 1 |
242789 | 242789 | 2020-06-15 | Lynn | Texas | 48305 | 19 | 1 |
239679 | 239679 | 2020-06-14 | Lynn | Texas | 48305 | 19 | 1 |
236571 | 236571 | 2020-06-13 | Lynn | Texas | 48305 | 19 | 1 |
233465 | 233465 | 2020-06-12 | Lynn | Texas | 48305 | 14 | 1 |
230361 | 230361 | 2020-06-11 | Lynn | Texas | 48305 | 14 | 1 |
227257 | 227257 | 2020-06-10 | Lynn | Texas | 48305 | 10 | 1 |
224157 | 224157 | 2020-06-09 | Lynn | Texas | 48305 | 8 | 1 |
221062 | 221062 | 2020-06-08 | Lynn | Texas | 48305 | 8 | 1 |
217970 | 217970 | 2020-06-07 | Lynn | Texas | 48305 | 8 | 1 |
214880 | 214880 | 2020-06-06 | Lynn | Texas | 48305 | 8 | 1 |
211793 | 211793 | 2020-06-05 | Lynn | Texas | 48305 | 8 | 1 |
208709 | 208709 | 2020-06-04 | Lynn | Texas | 48305 | 8 | 1 |
205627 | 205627 | 2020-06-03 | Lynn | Texas | 48305 | 7 | 1 |
202548 | 202548 | 2020-06-02 | Lynn | Texas | 48305 | 7 | 1 |
199472 | 199472 | 2020-06-01 | Lynn | Texas | 48305 | 7 | 1 |
196399 | 196399 | 2020-05-31 | Lynn | Texas | 48305 | 7 | 1 |
193329 | 193329 | 2020-05-30 | Lynn | Texas | 48305 | 7 | 1 |
190263 | 190263 | 2020-05-29 | Lynn | Texas | 48305 | 7 | 1 |
187199 | 187199 | 2020-05-28 | Lynn | Texas | 48305 | 6 | 1 |
184142 | 184142 | 2020-05-27 | Lynn | Texas | 48305 | 6 | 1 |
181092 | 181092 | 2020-05-26 | Lynn | Texas | 48305 | 5 | 1 |
178048 | 178048 | 2020-05-25 | Lynn | Texas | 48305 | 5 | 1 |
175004 | 175004 | 2020-05-24 | Lynn | Texas | 48305 | 5 | 1 |
171961 | 171961 | 2020-05-23 | Lynn | Texas | 48305 | 5 | 1 |
168921 | 168921 | 2020-05-22 | Lynn | Texas | 48305 | 5 | 1 |
165885 | 165885 | 2020-05-21 | Lynn | Texas | 48305 | 5 | 1 |
162856 | 162856 | 2020-05-20 | Lynn | Texas | 48305 | 5 | 1 |
159828 | 159828 | 2020-05-19 | Lynn | Texas | 48305 | 5 | 1 |
156806 | 156806 | 2020-05-18 | Lynn | Texas | 48305 | 5 | 1 |
153789 | 153789 | 2020-05-17 | Lynn | Texas | 48305 | 5 | 1 |
150778 | 150778 | 2020-05-16 | Lynn | Texas | 48305 | 5 | 1 |
147770 | 147770 | 2020-05-15 | Lynn | Texas | 48305 | 5 | 1 |
144766 | 144766 | 2020-05-14 | Lynn | Texas | 48305 | 5 | 1 |
141769 | 141769 | 2020-05-13 | Lynn | Texas | 48305 | 5 | 1 |
138773 | 138773 | 2020-05-12 | Lynn | Texas | 48305 | 5 | 1 |
135783 | 135783 | 2020-05-11 | Lynn | Texas | 48305 | 5 | 1 |
132792 | 132792 | 2020-05-10 | Lynn | Texas | 48305 | 5 | 1 |
129802 | 129802 | 2020-05-09 | Lynn | Texas | 48305 | 5 | 1 |
126813 | 126813 | 2020-05-08 | Lynn | Texas | 48305 | 5 | 1 |
123829 | 123829 | 2020-05-07 | Lynn | Texas | 48305 | 5 | 1 |
120850 | 120850 | 2020-05-06 | Lynn | Texas | 48305 | 5 | 1 |
117886 | 117886 | 2020-05-05 | Lynn | Texas | 48305 | 5 | 1 |
114927 | 114927 | 2020-05-04 | Lynn | Texas | 48305 | 5 | 1 |
112045 | 112045 | 2020-05-03 | Lynn | Texas | 48305 | 5 | 1 |
109171 | 109171 | 2020-05-02 | Lynn | Texas | 48305 | 5 | 1 |
106302 | 106302 | 2020-05-01 | Lynn | Texas | 48305 | 5 | 1 |
103438 | 103438 | 2020-04-30 | Lynn | Texas | 48305 | 5 | 1 |
100583 | 100583 | 2020-04-29 | Lynn | Texas | 48305 | 5 | 1 |
97733 | 97733 | 2020-04-28 | Lynn | Texas | 48305 | 5 | 1 |
94892 | 94892 | 2020-04-27 | Lynn | Texas | 48305 | 5 | 1 |
92063 | 92063 | 2020-04-26 | Lynn | Texas | 48305 | 5 | 1 |
89246 | 89246 | 2020-04-25 | Lynn | Texas | 48305 | 5 | 1 |
86431 | 86431 | 2020-04-24 | Lynn | Texas | 48305 | 5 | 1 |
83626 | 83626 | 2020-04-23 | Lynn | Texas | 48305 | 5 | 1 |
80825 | 80825 | 2020-04-22 | Lynn | Texas | 48305 | 5 | 1 |
78034 | 78034 | 2020-04-21 | Lynn | Texas | 48305 | 5 | 1 |
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);