ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,541 rows where county = "Armstrong" sorted by fips descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, deaths, date (date)
Link | rowid | date | county | state | fips ▲ | cases | deaths |
---|---|---|---|---|---|---|---|
58646 | 58646 | 2020-04-14 | Armstrong | Texas | 48011 | 1 | 0 |
61362 | 61362 | 2020-04-15 | Armstrong | Texas | 48011 | 1 | 0 |
64089 | 64089 | 2020-04-16 | Armstrong | Texas | 48011 | 1 | 0 |
66836 | 66836 | 2020-04-17 | Armstrong | Texas | 48011 | 1 | 0 |
69595 | 69595 | 2020-04-18 | Armstrong | Texas | 48011 | 1 | 0 |
72362 | 72362 | 2020-04-19 | Armstrong | Texas | 48011 | 1 | 0 |
75137 | 75137 | 2020-04-20 | Armstrong | Texas | 48011 | 1 | 0 |
77919 | 77919 | 2020-04-21 | Armstrong | Texas | 48011 | 1 | 0 |
80709 | 80709 | 2020-04-22 | Armstrong | Texas | 48011 | 1 | 0 |
83508 | 83508 | 2020-04-23 | Armstrong | Texas | 48011 | 1 | 0 |
86313 | 86313 | 2020-04-24 | Armstrong | Texas | 48011 | 1 | 0 |
89128 | 89128 | 2020-04-25 | Armstrong | Texas | 48011 | 2 | 0 |
91945 | 91945 | 2020-04-26 | Armstrong | Texas | 48011 | 2 | 0 |
94773 | 94773 | 2020-04-27 | Armstrong | Texas | 48011 | 2 | 0 |
97613 | 97613 | 2020-04-28 | Armstrong | Texas | 48011 | 2 | 0 |
100463 | 100463 | 2020-04-29 | Armstrong | Texas | 48011 | 2 | 0 |
103316 | 103316 | 2020-04-30 | Armstrong | Texas | 48011 | 2 | 0 |
106179 | 106179 | 2020-05-01 | Armstrong | Texas | 48011 | 2 | 0 |
109046 | 109046 | 2020-05-02 | Armstrong | Texas | 48011 | 2 | 0 |
111920 | 111920 | 2020-05-03 | Armstrong | Texas | 48011 | 2 | 0 |
114802 | 114802 | 2020-05-04 | Armstrong | Texas | 48011 | 2 | 0 |
117758 | 117758 | 2020-05-05 | Armstrong | Texas | 48011 | 2 | 0 |
120722 | 120722 | 2020-05-06 | Armstrong | Texas | 48011 | 2 | 0 |
123701 | 123701 | 2020-05-07 | Armstrong | Texas | 48011 | 2 | 0 |
126684 | 126684 | 2020-05-08 | Armstrong | Texas | 48011 | 2 | 0 |
129673 | 129673 | 2020-05-09 | Armstrong | Texas | 48011 | 2 | 0 |
132663 | 132663 | 2020-05-10 | Armstrong | Texas | 48011 | 2 | 0 |
135654 | 135654 | 2020-05-11 | Armstrong | Texas | 48011 | 2 | 0 |
138644 | 138644 | 2020-05-12 | Armstrong | Texas | 48011 | 2 | 0 |
141640 | 141640 | 2020-05-13 | Armstrong | Texas | 48011 | 2 | 0 |
144637 | 144637 | 2020-05-14 | Armstrong | Texas | 48011 | 2 | 0 |
147639 | 147639 | 2020-05-15 | Armstrong | Texas | 48011 | 2 | 0 |
150647 | 150647 | 2020-05-16 | Armstrong | Texas | 48011 | 2 | 0 |
153658 | 153658 | 2020-05-17 | Armstrong | Texas | 48011 | 2 | 0 |
156675 | 156675 | 2020-05-18 | Armstrong | Texas | 48011 | 2 | 0 |
159697 | 159697 | 2020-05-19 | Armstrong | Texas | 48011 | 2 | 0 |
162724 | 162724 | 2020-05-20 | Armstrong | Texas | 48011 | 2 | 0 |
165753 | 165753 | 2020-05-21 | Armstrong | Texas | 48011 | 2 | 0 |
168789 | 168789 | 2020-05-22 | Armstrong | Texas | 48011 | 2 | 0 |
171828 | 171828 | 2020-05-23 | Armstrong | Texas | 48011 | 2 | 0 |
174871 | 174871 | 2020-05-24 | Armstrong | Texas | 48011 | 2 | 0 |
177915 | 177915 | 2020-05-25 | Armstrong | Texas | 48011 | 2 | 0 |
180958 | 180958 | 2020-05-26 | Armstrong | Texas | 48011 | 2 | 0 |
184008 | 184008 | 2020-05-27 | Armstrong | Texas | 48011 | 2 | 0 |
187065 | 187065 | 2020-05-28 | Armstrong | Texas | 48011 | 2 | 0 |
190129 | 190129 | 2020-05-29 | Armstrong | Texas | 48011 | 3 | 0 |
193194 | 193194 | 2020-05-30 | Armstrong | Texas | 48011 | 3 | 0 |
196264 | 196264 | 2020-05-31 | Armstrong | Texas | 48011 | 3 | 0 |
199337 | 199337 | 2020-06-01 | Armstrong | Texas | 48011 | 3 | 0 |
202412 | 202412 | 2020-06-02 | Armstrong | Texas | 48011 | 3 | 0 |
205491 | 205491 | 2020-06-03 | Armstrong | Texas | 48011 | 3 | 0 |
208573 | 208573 | 2020-06-04 | Armstrong | Texas | 48011 | 3 | 0 |
211655 | 211655 | 2020-06-05 | Armstrong | Texas | 48011 | 3 | 0 |
214742 | 214742 | 2020-06-06 | Armstrong | Texas | 48011 | 3 | 0 |
217832 | 217832 | 2020-06-07 | Armstrong | Texas | 48011 | 3 | 0 |
220924 | 220924 | 2020-06-08 | Armstrong | Texas | 48011 | 3 | 0 |
224019 | 224019 | 2020-06-09 | Armstrong | Texas | 48011 | 3 | 0 |
227119 | 227119 | 2020-06-10 | Armstrong | Texas | 48011 | 3 | 0 |
230223 | 230223 | 2020-06-11 | Armstrong | Texas | 48011 | 3 | 0 |
233327 | 233327 | 2020-06-12 | Armstrong | Texas | 48011 | 2 | 0 |
236433 | 236433 | 2020-06-13 | Armstrong | Texas | 48011 | 2 | 0 |
239541 | 239541 | 2020-06-14 | Armstrong | Texas | 48011 | 2 | 0 |
242651 | 242651 | 2020-06-15 | Armstrong | Texas | 48011 | 2 | 0 |
245763 | 245763 | 2020-06-16 | Armstrong | Texas | 48011 | 2 | 0 |
248876 | 248876 | 2020-06-17 | Armstrong | Texas | 48011 | 3 | 0 |
251991 | 251991 | 2020-06-18 | Armstrong | Texas | 48011 | 3 | 0 |
255106 | 255106 | 2020-06-19 | Armstrong | Texas | 48011 | 3 | 0 |
258232 | 258232 | 2020-06-20 | Armstrong | Texas | 48011 | 3 | 0 |
261359 | 261359 | 2020-06-21 | Armstrong | Texas | 48011 | 3 | 0 |
264487 | 264487 | 2020-06-22 | Armstrong | Texas | 48011 | 3 | 0 |
267615 | 267615 | 2020-06-23 | Armstrong | Texas | 48011 | 3 | 0 |
270749 | 270749 | 2020-06-24 | Armstrong | Texas | 48011 | 3 | 0 |
273888 | 273888 | 2020-06-25 | Armstrong | Texas | 48011 | 3 | 0 |
277035 | 277035 | 2020-06-26 | Armstrong | Texas | 48011 | 3 | 0 |
280183 | 280183 | 2020-06-27 | Armstrong | Texas | 48011 | 3 | 0 |
283329 | 283329 | 2020-06-28 | Armstrong | Texas | 48011 | 3 | 0 |
286475 | 286475 | 2020-06-29 | Armstrong | Texas | 48011 | 3 | 0 |
289625 | 289625 | 2020-06-30 | Armstrong | Texas | 48011 | 3 | 0 |
292778 | 292778 | 2020-07-01 | Armstrong | Texas | 48011 | 3 | 0 |
295933 | 295933 | 2020-07-02 | Armstrong | Texas | 48011 | 3 | 0 |
299093 | 299093 | 2020-07-03 | Armstrong | Texas | 48011 | 3 | 0 |
302257 | 302257 | 2020-07-04 | Armstrong | Texas | 48011 | 3 | 0 |
305421 | 305421 | 2020-07-05 | Armstrong | Texas | 48011 | 3 | 0 |
308589 | 308589 | 2020-07-06 | Armstrong | Texas | 48011 | 3 | 0 |
311758 | 311758 | 2020-07-07 | Armstrong | Texas | 48011 | 3 | 0 |
314932 | 314932 | 2020-07-08 | Armstrong | Texas | 48011 | 3 | 0 |
318105 | 318105 | 2020-07-09 | Armstrong | Texas | 48011 | 3 | 0 |
321283 | 321283 | 2020-07-10 | Armstrong | Texas | 48011 | 3 | 0 |
324464 | 324464 | 2020-07-11 | Armstrong | Texas | 48011 | 3 | 0 |
327649 | 327649 | 2020-07-12 | Armstrong | Texas | 48011 | 3 | 0 |
330835 | 330835 | 2020-07-13 | Armstrong | Texas | 48011 | 3 | 0 |
334026 | 334026 | 2020-07-14 | Armstrong | Texas | 48011 | 3 | 0 |
337221 | 337221 | 2020-07-15 | Armstrong | Texas | 48011 | 3 | 0 |
340417 | 340417 | 2020-07-16 | Armstrong | Texas | 48011 | 3 | 0 |
343616 | 343616 | 2020-07-17 | Armstrong | Texas | 48011 | 3 | 0 |
346816 | 346816 | 2020-07-18 | Armstrong | Texas | 48011 | 3 | 0 |
350016 | 350016 | 2020-07-19 | Armstrong | Texas | 48011 | 3 | 0 |
353218 | 353218 | 2020-07-20 | Armstrong | Texas | 48011 | 3 | 0 |
356421 | 356421 | 2020-07-21 | Armstrong | Texas | 48011 | 3 | 0 |
359626 | 359626 | 2020-07-22 | Armstrong | Texas | 48011 | 3 | 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);