ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,536 rows where county = "Guadalupe" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
180193 | 180193 | 2020-05-26 | Guadalupe | New Mexico | 35019 | 20 | 0 |
181040 | 181040 | 2020-05-26 | Guadalupe | Texas | 48187 | 122 | 0 |
183241 | 183241 | 2020-05-27 | Guadalupe | New Mexico | 35019 | 20 | 0 |
184090 | 184090 | 2020-05-27 | Guadalupe | Texas | 48187 | 124 | 0 |
186298 | 186298 | 2020-05-28 | Guadalupe | New Mexico | 35019 | 20 | 0 |
187147 | 187147 | 2020-05-28 | Guadalupe | Texas | 48187 | 126 | 0 |
189358 | 189358 | 2020-05-29 | Guadalupe | New Mexico | 35019 | 20 | 0 |
190211 | 190211 | 2020-05-29 | Guadalupe | Texas | 48187 | 129 | 0 |
192422 | 192422 | 2020-05-30 | Guadalupe | New Mexico | 35019 | 20 | 0 |
193276 | 193276 | 2020-05-30 | Guadalupe | Texas | 48187 | 132 | 0 |
195492 | 195492 | 2020-05-31 | Guadalupe | New Mexico | 35019 | 20 | 0 |
196346 | 196346 | 2020-05-31 | Guadalupe | Texas | 48187 | 133 | 0 |
198565 | 198565 | 2020-06-01 | Guadalupe | New Mexico | 35019 | 20 | 0 |
199419 | 199419 | 2020-06-01 | Guadalupe | Texas | 48187 | 133 | 0 |
201639 | 201639 | 2020-06-02 | Guadalupe | New Mexico | 35019 | 20 | 0 |
202494 | 202494 | 2020-06-02 | Guadalupe | Texas | 48187 | 133 | 0 |
204716 | 204716 | 2020-06-03 | Guadalupe | New Mexico | 35019 | 20 | 0 |
205573 | 205573 | 2020-06-03 | Guadalupe | Texas | 48187 | 135 | 0 |
207797 | 207797 | 2020-06-04 | Guadalupe | New Mexico | 35019 | 20 | 0 |
208655 | 208655 | 2020-06-04 | Guadalupe | Texas | 48187 | 142 | 0 |
210879 | 210879 | 2020-06-05 | Guadalupe | New Mexico | 35019 | 20 | 0 |
211739 | 211739 | 2020-06-05 | Guadalupe | Texas | 48187 | 145 | 0 |
213963 | 213963 | 2020-06-06 | Guadalupe | New Mexico | 35019 | 20 | 0 |
214826 | 214826 | 2020-06-06 | Guadalupe | Texas | 48187 | 147 | 0 |
217052 | 217052 | 2020-06-07 | Guadalupe | New Mexico | 35019 | 20 | 0 |
217916 | 217916 | 2020-06-07 | Guadalupe | Texas | 48187 | 147 | 0 |
220144 | 220144 | 2020-06-08 | Guadalupe | New Mexico | 35019 | 20 | 0 |
221008 | 221008 | 2020-06-08 | Guadalupe | Texas | 48187 | 147 | 0 |
223239 | 223239 | 2020-06-09 | Guadalupe | New Mexico | 35019 | 20 | 0 |
224103 | 224103 | 2020-06-09 | Guadalupe | Texas | 48187 | 147 | 0 |
226339 | 226339 | 2020-06-10 | Guadalupe | New Mexico | 35019 | 20 | 0 |
227203 | 227203 | 2020-06-10 | Guadalupe | Texas | 48187 | 151 | 0 |
229443 | 229443 | 2020-06-11 | Guadalupe | New Mexico | 35019 | 20 | 0 |
230307 | 230307 | 2020-06-11 | Guadalupe | Texas | 48187 | 154 | 0 |
232548 | 232548 | 2020-06-12 | Guadalupe | New Mexico | 35019 | 20 | 0 |
233411 | 233411 | 2020-06-12 | Guadalupe | Texas | 48187 | 160 | 0 |
235653 | 235653 | 2020-06-13 | Guadalupe | New Mexico | 35019 | 20 | 0 |
236517 | 236517 | 2020-06-13 | Guadalupe | Texas | 48187 | 165 | 0 |
238760 | 238760 | 2020-06-14 | Guadalupe | New Mexico | 35019 | 20 | 0 |
239625 | 239625 | 2020-06-14 | Guadalupe | Texas | 48187 | 171 | 0 |
241870 | 241870 | 2020-06-15 | Guadalupe | New Mexico | 35019 | 20 | 0 |
242735 | 242735 | 2020-06-15 | Guadalupe | Texas | 48187 | 171 | 0 |
244982 | 244982 | 2020-06-16 | Guadalupe | New Mexico | 35019 | 20 | 0 |
245847 | 245847 | 2020-06-16 | Guadalupe | Texas | 48187 | 175 | 0 |
248095 | 248095 | 2020-06-17 | Guadalupe | New Mexico | 35019 | 20 | 0 |
248960 | 248960 | 2020-06-17 | Guadalupe | Texas | 48187 | 184 | 0 |
251210 | 251210 | 2020-06-18 | Guadalupe | New Mexico | 35019 | 20 | 0 |
252075 | 252075 | 2020-06-18 | Guadalupe | Texas | 48187 | 186 | 0 |
254325 | 254325 | 2020-06-19 | Guadalupe | New Mexico | 35019 | 20 | 0 |
255190 | 255190 | 2020-06-19 | Guadalupe | Texas | 48187 | 280 | 1 |
257448 | 257448 | 2020-06-20 | Guadalupe | New Mexico | 35019 | 20 | 0 |
258317 | 258317 | 2020-06-20 | Guadalupe | Texas | 48187 | 311 | 1 |
260574 | 260574 | 2020-06-21 | Guadalupe | New Mexico | 35019 | 20 | 0 |
261444 | 261444 | 2020-06-21 | Guadalupe | Texas | 48187 | 323 | 1 |
263703 | 263703 | 2020-06-22 | Guadalupe | New Mexico | 35019 | 20 | 0 |
264572 | 264572 | 2020-06-22 | Guadalupe | Texas | 48187 | 323 | 1 |
266830 | 266830 | 2020-06-23 | Guadalupe | New Mexico | 35019 | 20 | 0 |
267700 | 267700 | 2020-06-23 | Guadalupe | Texas | 48187 | 417 | 1 |
269965 | 269965 | 2020-06-24 | Guadalupe | New Mexico | 35019 | 20 | 0 |
270834 | 270834 | 2020-06-24 | Guadalupe | Texas | 48187 | 467 | 1 |
273104 | 273104 | 2020-06-25 | Guadalupe | New Mexico | 35019 | 20 | 0 |
273974 | 273974 | 2020-06-25 | Guadalupe | Texas | 48187 | 563 | 1 |
276249 | 276249 | 2020-06-26 | Guadalupe | New Mexico | 35019 | 20 | 0 |
277121 | 277121 | 2020-06-26 | Guadalupe | Texas | 48187 | 581 | 1 |
279397 | 279397 | 2020-06-27 | Guadalupe | New Mexico | 35019 | 20 | 0 |
280269 | 280269 | 2020-06-27 | Guadalupe | Texas | 48187 | 636 | 1 |
282544 | 282544 | 2020-06-28 | Guadalupe | New Mexico | 35019 | 20 | 0 |
283415 | 283415 | 2020-06-28 | Guadalupe | Texas | 48187 | 638 | 1 |
285689 | 285689 | 2020-06-29 | Guadalupe | New Mexico | 35019 | 20 | 0 |
286561 | 286561 | 2020-06-29 | Guadalupe | Texas | 48187 | 638 | 1 |
288839 | 288839 | 2020-06-30 | Guadalupe | New Mexico | 35019 | 20 | 0 |
289711 | 289711 | 2020-06-30 | Guadalupe | Texas | 48187 | 698 | 1 |
291991 | 291991 | 2020-07-01 | Guadalupe | New Mexico | 35019 | 20 | 0 |
292864 | 292864 | 2020-07-01 | Guadalupe | Texas | 48187 | 705 | 2 |
295146 | 295146 | 2020-07-02 | Guadalupe | New Mexico | 35019 | 20 | 0 |
296019 | 296019 | 2020-07-02 | Guadalupe | Texas | 48187 | 737 | 2 |
298306 | 298306 | 2020-07-03 | Guadalupe | New Mexico | 35019 | 20 | 0 |
299179 | 299179 | 2020-07-03 | Guadalupe | Texas | 48187 | 768 | 2 |
301469 | 301469 | 2020-07-04 | Guadalupe | New Mexico | 35019 | 20 | 0 |
302343 | 302343 | 2020-07-04 | Guadalupe | Texas | 48187 | 849 | 3 |
304632 | 304632 | 2020-07-05 | Guadalupe | New Mexico | 35019 | 20 | 0 |
305507 | 305507 | 2020-07-05 | Guadalupe | Texas | 48187 | 849 | 3 |
307799 | 307799 | 2020-07-06 | Guadalupe | New Mexico | 35019 | 20 | 0 |
308675 | 308675 | 2020-07-06 | Guadalupe | Texas | 48187 | 858 | 3 |
310967 | 310967 | 2020-07-07 | Guadalupe | New Mexico | 35019 | 20 | 0 |
311844 | 311844 | 2020-07-07 | Guadalupe | Texas | 48187 | 896 | 3 |
314138 | 314138 | 2020-07-08 | Guadalupe | New Mexico | 35019 | 20 | 0 |
315018 | 315018 | 2020-07-08 | Guadalupe | Texas | 48187 | 901 | 3 |
317312 | 317312 | 2020-07-09 | Guadalupe | New Mexico | 35019 | 20 | 0 |
318191 | 318191 | 2020-07-09 | Guadalupe | Texas | 48187 | 929 | 3 |
320488 | 320488 | 2020-07-10 | Guadalupe | New Mexico | 35019 | 20 | 0 |
321370 | 321370 | 2020-07-10 | Guadalupe | Texas | 48187 | 966 | 3 |
323668 | 323668 | 2020-07-11 | Guadalupe | New Mexico | 35019 | 20 | 0 |
324551 | 324551 | 2020-07-11 | Guadalupe | Texas | 48187 | 1014 | 3 |
326852 | 326852 | 2020-07-12 | Guadalupe | New Mexico | 35019 | 20 | 0 |
327736 | 327736 | 2020-07-12 | Guadalupe | Texas | 48187 | 1044 | 3 |
330039 | 330039 | 2020-07-13 | Guadalupe | New Mexico | 35019 | 20 | 0 |
330922 | 330922 | 2020-07-13 | Guadalupe | Texas | 48187 | 1044 | 3 |
333229 | 333229 | 2020-07-14 | Guadalupe | New Mexico | 35019 | 20 | 0 |
334113 | 334113 | 2020-07-14 | Guadalupe | Texas | 48187 | 1044 | 3 |
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);