ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where county = "Pecos" and state = "Texas" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
37743 | 37743 | 2020-04-06 | Pecos | Texas | 48371 | 1 | 0 |
40272 | 40272 | 2020-04-07 | Pecos | Texas | 48371 | 1 | 0 |
42840 | 42840 | 2020-04-08 | Pecos | Texas | 48371 | 1 | 0 |
45432 | 45432 | 2020-04-09 | Pecos | Texas | 48371 | 1 | 0 |
48053 | 48053 | 2020-04-10 | Pecos | Texas | 48371 | 1 | 0 |
50711 | 50711 | 2020-04-11 | Pecos | Texas | 48371 | 1 | 0 |
53386 | 53386 | 2020-04-12 | Pecos | Texas | 48371 | 1 | 0 |
56075 | 56075 | 2020-04-13 | Pecos | Texas | 48371 | 1 | 0 |
58780 | 58780 | 2020-04-14 | Pecos | Texas | 48371 | 1 | 0 |
61498 | 61498 | 2020-04-15 | Pecos | Texas | 48371 | 5 | 0 |
64227 | 64227 | 2020-04-16 | Pecos | Texas | 48371 | 5 | 0 |
66974 | 66974 | 2020-04-17 | Pecos | Texas | 48371 | 5 | 0 |
69734 | 69734 | 2020-04-18 | Pecos | Texas | 48371 | 5 | 0 |
72504 | 72504 | 2020-04-19 | Pecos | Texas | 48371 | 5 | 0 |
75280 | 75280 | 2020-04-20 | Pecos | Texas | 48371 | 5 | 0 |
78062 | 78062 | 2020-04-21 | Pecos | Texas | 48371 | 5 | 0 |
80853 | 80853 | 2020-04-22 | Pecos | Texas | 48371 | 5 | 0 |
83654 | 83654 | 2020-04-23 | Pecos | Texas | 48371 | 6 | 0 |
86461 | 86461 | 2020-04-24 | Pecos | Texas | 48371 | 6 | 0 |
92093 | 92093 | 2020-04-26 | Pecos | Texas | 48371 | 6 | 0 |
89276 | 89276 | 2020-04-25 | Pecos | Texas | 48371 | 8 | 0 |
94922 | 94922 | 2020-04-27 | Pecos | Texas | 48371 | 9 | 0 |
97763 | 97763 | 2020-04-28 | Pecos | Texas | 48371 | 9 | 0 |
100613 | 100613 | 2020-04-29 | Pecos | Texas | 48371 | 9 | 0 |
103468 | 103468 | 2020-04-30 | Pecos | Texas | 48371 | 9 | 0 |
109201 | 109201 | 2020-05-02 | Pecos | Texas | 48371 | 10 | 0 |
112075 | 112075 | 2020-05-03 | Pecos | Texas | 48371 | 10 | 0 |
114957 | 114957 | 2020-05-04 | Pecos | Texas | 48371 | 10 | 0 |
106332 | 106332 | 2020-05-01 | Pecos | Texas | 48371 | 11 | 0 |
117916 | 117916 | 2020-05-05 | Pecos | Texas | 48371 | 13 | 0 |
120880 | 120880 | 2020-05-06 | Pecos | Texas | 48371 | 14 | 0 |
123859 | 123859 | 2020-05-07 | Pecos | Texas | 48371 | 14 | 0 |
126843 | 126843 | 2020-05-08 | Pecos | Texas | 48371 | 14 | 0 |
129832 | 129832 | 2020-05-09 | Pecos | Texas | 48371 | 15 | 0 |
132822 | 132822 | 2020-05-10 | Pecos | Texas | 48371 | 15 | 0 |
135813 | 135813 | 2020-05-11 | Pecos | Texas | 48371 | 15 | 0 |
138803 | 138803 | 2020-05-12 | Pecos | Texas | 48371 | 19 | 0 |
141799 | 141799 | 2020-05-13 | Pecos | Texas | 48371 | 20 | 0 |
144796 | 144796 | 2020-05-14 | Pecos | Texas | 48371 | 20 | 0 |
147800 | 147800 | 2020-05-15 | Pecos | Texas | 48371 | 20 | 0 |
150808 | 150808 | 2020-05-16 | Pecos | Texas | 48371 | 20 | 0 |
153819 | 153819 | 2020-05-17 | Pecos | Texas | 48371 | 20 | 0 |
156836 | 156836 | 2020-05-18 | Pecos | Texas | 48371 | 20 | 0 |
159859 | 159859 | 2020-05-19 | Pecos | Texas | 48371 | 23 | 0 |
162887 | 162887 | 2020-05-20 | Pecos | Texas | 48371 | 24 | 0 |
165916 | 165916 | 2020-05-21 | Pecos | Texas | 48371 | 24 | 0 |
168952 | 168952 | 2020-05-22 | Pecos | Texas | 48371 | 24 | 0 |
171992 | 171992 | 2020-05-23 | Pecos | Texas | 48371 | 27 | 0 |
175035 | 175035 | 2020-05-24 | Pecos | Texas | 48371 | 27 | 0 |
178079 | 178079 | 2020-05-25 | Pecos | Texas | 48371 | 27 | 0 |
181123 | 181123 | 2020-05-26 | Pecos | Texas | 48371 | 27 | 0 |
184173 | 184173 | 2020-05-27 | Pecos | Texas | 48371 | 27 | 0 |
224188 | 224188 | 2020-06-09 | Pecos | Texas | 48371 | 27 | 0 |
187230 | 187230 | 2020-05-28 | Pecos | Texas | 48371 | 56 | 0 |
190294 | 190294 | 2020-05-29 | Pecos | Texas | 48371 | 66 | 0 |
193360 | 193360 | 2020-05-30 | Pecos | Texas | 48371 | 66 | 0 |
196430 | 196430 | 2020-05-31 | Pecos | Texas | 48371 | 93 | 0 |
199503 | 199503 | 2020-06-01 | Pecos | Texas | 48371 | 102 | 0 |
202579 | 202579 | 2020-06-02 | Pecos | Texas | 48371 | 102 | 0 |
205658 | 205658 | 2020-06-03 | Pecos | Texas | 48371 | 103 | 0 |
208740 | 208740 | 2020-06-04 | Pecos | Texas | 48371 | 103 | 0 |
211824 | 211824 | 2020-06-05 | Pecos | Texas | 48371 | 103 | 0 |
214911 | 214911 | 2020-06-06 | Pecos | Texas | 48371 | 104 | 0 |
218001 | 218001 | 2020-06-07 | Pecos | Texas | 48371 | 105 | 0 |
221093 | 221093 | 2020-06-08 | Pecos | Texas | 48371 | 105 | 0 |
227288 | 227288 | 2020-06-10 | Pecos | Texas | 48371 | 107 | 0 |
230392 | 230392 | 2020-06-11 | Pecos | Texas | 48371 | 107 | 0 |
233496 | 233496 | 2020-06-12 | Pecos | Texas | 48371 | 107 | 0 |
236602 | 236602 | 2020-06-13 | Pecos | Texas | 48371 | 107 | 0 |
239710 | 239710 | 2020-06-14 | Pecos | Texas | 48371 | 107 | 0 |
242820 | 242820 | 2020-06-15 | Pecos | Texas | 48371 | 107 | 0 |
249045 | 249045 | 2020-06-17 | Pecos | Texas | 48371 | 111 | 0 |
252160 | 252160 | 2020-06-18 | Pecos | Texas | 48371 | 111 | 0 |
245932 | 245932 | 2020-06-16 | Pecos | Texas | 48371 | 112 | 0 |
255275 | 255275 | 2020-06-19 | Pecos | Texas | 48371 | 112 | 0 |
258402 | 258402 | 2020-06-20 | Pecos | Texas | 48371 | 112 | 0 |
261529 | 261529 | 2020-06-21 | Pecos | Texas | 48371 | 112 | 0 |
264658 | 264658 | 2020-06-22 | Pecos | Texas | 48371 | 112 | 0 |
267786 | 267786 | 2020-06-23 | Pecos | Texas | 48371 | 112 | 0 |
270920 | 270920 | 2020-06-24 | Pecos | Texas | 48371 | 113 | 0 |
274060 | 274060 | 2020-06-25 | Pecos | Texas | 48371 | 116 | 0 |
277208 | 277208 | 2020-06-26 | Pecos | Texas | 48371 | 116 | 0 |
283502 | 283502 | 2020-06-28 | Pecos | Texas | 48371 | 117 | 0 |
280356 | 280356 | 2020-06-27 | Pecos | Texas | 48371 | 120 | 0 |
286648 | 286648 | 2020-06-29 | Pecos | Texas | 48371 | 120 | 0 |
289798 | 289798 | 2020-06-30 | Pecos | Texas | 48371 | 124 | 0 |
292951 | 292951 | 2020-07-01 | Pecos | Texas | 48371 | 127 | 0 |
296106 | 296106 | 2020-07-02 | Pecos | Texas | 48371 | 130 | 0 |
299267 | 299267 | 2020-07-03 | Pecos | Texas | 48371 | 131 | 0 |
305595 | 305595 | 2020-07-05 | Pecos | Texas | 48371 | 131 | 0 |
308763 | 308763 | 2020-07-06 | Pecos | Texas | 48371 | 131 | 0 |
302431 | 302431 | 2020-07-04 | Pecos | Texas | 48371 | 132 | 0 |
311932 | 311932 | 2020-07-07 | Pecos | Texas | 48371 | 135 | 1 |
315106 | 315106 | 2020-07-08 | Pecos | Texas | 48371 | 135 | 1 |
318279 | 318279 | 2020-07-09 | Pecos | Texas | 48371 | 138 | 1 |
321458 | 321458 | 2020-07-10 | Pecos | Texas | 48371 | 138 | 1 |
324639 | 324639 | 2020-07-11 | Pecos | Texas | 48371 | 139 | 1 |
327824 | 327824 | 2020-07-12 | Pecos | Texas | 48371 | 139 | 1 |
331010 | 331010 | 2020-07-13 | Pecos | Texas | 48371 | 139 | 1 |
334203 | 334203 | 2020-07-14 | Pecos | Texas | 48371 | 148 | 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);