ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,507 rows where county = "Hidalgo" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
10659 | 10659 | 2020-03-24 | Hidalgo | Texas | 48215 | 2 | 0 |
12152 | 12152 | 2020-03-25 | Hidalgo | Texas | 48215 | 2 | 0 |
13781 | 13781 | 2020-03-26 | Hidalgo | Texas | 48215 | 7 | 0 |
15536 | 15536 | 2020-03-27 | Hidalgo | Texas | 48215 | 18 | 0 |
17405 | 17405 | 2020-03-28 | Hidalgo | Texas | 48215 | 18 | 0 |
19359 | 19359 | 2020-03-29 | Hidalgo | Texas | 48215 | 27 | 0 |
21418 | 21418 | 2020-03-30 | Hidalgo | Texas | 48215 | 28 | 0 |
23557 | 23557 | 2020-03-31 | Hidalgo | Texas | 48215 | 38 | 0 |
25767 | 25767 | 2020-04-01 | Hidalgo | Texas | 48215 | 46 | 0 |
28050 | 28050 | 2020-04-02 | Hidalgo | Texas | 48215 | 62 | 0 |
30385 | 30385 | 2020-04-03 | Hidalgo | Texas | 48215 | 79 | 0 |
32779 | 32779 | 2020-04-04 | Hidalgo | Texas | 48215 | 86 | 0 |
35217 | 35217 | 2020-04-05 | Hidalgo | Texas | 48215 | 86 | 0 |
37693 | 37693 | 2020-04-06 | Hidalgo | Texas | 48215 | 99 | 0 |
155918 | 155918 | 2020-05-18 | Hidalgo | New Mexico | 35023 | 1 | 0 |
158936 | 158936 | 2020-05-19 | Hidalgo | New Mexico | 35023 | 1 | 0 |
161962 | 161962 | 2020-05-20 | Hidalgo | New Mexico | 35023 | 1 | 0 |
164991 | 164991 | 2020-05-21 | Hidalgo | New Mexico | 35023 | 1 | 0 |
168027 | 168027 | 2020-05-22 | Hidalgo | New Mexico | 35023 | 1 | 0 |
171066 | 171066 | 2020-05-23 | Hidalgo | New Mexico | 35023 | 1 | 0 |
174108 | 174108 | 2020-05-24 | Hidalgo | New Mexico | 35023 | 1 | 0 |
177151 | 177151 | 2020-05-25 | Hidalgo | New Mexico | 35023 | 1 | 0 |
180195 | 180195 | 2020-05-26 | Hidalgo | New Mexico | 35023 | 1 | 0 |
183243 | 183243 | 2020-05-27 | Hidalgo | New Mexico | 35023 | 1 | 0 |
186300 | 186300 | 2020-05-28 | Hidalgo | New Mexico | 35023 | 1 | 0 |
189360 | 189360 | 2020-05-29 | Hidalgo | New Mexico | 35023 | 1 | 0 |
192424 | 192424 | 2020-05-30 | Hidalgo | New Mexico | 35023 | 1 | 0 |
195494 | 195494 | 2020-05-31 | Hidalgo | New Mexico | 35023 | 1 | 0 |
198567 | 198567 | 2020-06-01 | Hidalgo | New Mexico | 35023 | 1 | 0 |
201641 | 201641 | 2020-06-02 | Hidalgo | New Mexico | 35023 | 1 | 0 |
204718 | 204718 | 2020-06-03 | Hidalgo | New Mexico | 35023 | 1 | 0 |
207799 | 207799 | 2020-06-04 | Hidalgo | New Mexico | 35023 | 1 | 0 |
210881 | 210881 | 2020-06-05 | Hidalgo | New Mexico | 35023 | 1 | 0 |
213965 | 213965 | 2020-06-06 | Hidalgo | New Mexico | 35023 | 1 | 0 |
217054 | 217054 | 2020-06-07 | Hidalgo | New Mexico | 35023 | 1 | 0 |
220146 | 220146 | 2020-06-08 | Hidalgo | New Mexico | 35023 | 1 | 0 |
223241 | 223241 | 2020-06-09 | Hidalgo | New Mexico | 35023 | 1 | 0 |
226341 | 226341 | 2020-06-10 | Hidalgo | New Mexico | 35023 | 1 | 0 |
229445 | 229445 | 2020-06-11 | Hidalgo | New Mexico | 35023 | 1 | 0 |
232550 | 232550 | 2020-06-12 | Hidalgo | New Mexico | 35023 | 2 | 0 |
235655 | 235655 | 2020-06-13 | Hidalgo | New Mexico | 35023 | 3 | 0 |
238762 | 238762 | 2020-06-14 | Hidalgo | New Mexico | 35023 | 3 | 0 |
241872 | 241872 | 2020-06-15 | Hidalgo | New Mexico | 35023 | 20 | 0 |
244984 | 244984 | 2020-06-16 | Hidalgo | New Mexico | 35023 | 23 | 0 |
248097 | 248097 | 2020-06-17 | Hidalgo | New Mexico | 35023 | 23 | 0 |
251212 | 251212 | 2020-06-18 | Hidalgo | New Mexico | 35023 | 23 | 0 |
254327 | 254327 | 2020-06-19 | Hidalgo | New Mexico | 35023 | 26 | 0 |
257450 | 257450 | 2020-06-20 | Hidalgo | New Mexico | 35023 | 26 | 0 |
260576 | 260576 | 2020-06-21 | Hidalgo | New Mexico | 35023 | 28 | 0 |
263705 | 263705 | 2020-06-22 | Hidalgo | New Mexico | 35023 | 39 | 0 |
266832 | 266832 | 2020-06-23 | Hidalgo | New Mexico | 35023 | 39 | 0 |
269967 | 269967 | 2020-06-24 | Hidalgo | New Mexico | 35023 | 39 | 0 |
273106 | 273106 | 2020-06-25 | Hidalgo | New Mexico | 35023 | 40 | 0 |
276251 | 276251 | 2020-06-26 | Hidalgo | New Mexico | 35023 | 39 | 0 |
279399 | 279399 | 2020-06-27 | Hidalgo | New Mexico | 35023 | 46 | 0 |
282546 | 282546 | 2020-06-28 | Hidalgo | New Mexico | 35023 | 46 | 0 |
285691 | 285691 | 2020-06-29 | Hidalgo | New Mexico | 35023 | 49 | 0 |
288841 | 288841 | 2020-06-30 | Hidalgo | New Mexico | 35023 | 49 | 0 |
291993 | 291993 | 2020-07-01 | Hidalgo | New Mexico | 35023 | 49 | 0 |
295148 | 295148 | 2020-07-02 | Hidalgo | New Mexico | 35023 | 54 | 0 |
298308 | 298308 | 2020-07-03 | Hidalgo | New Mexico | 35023 | 54 | 0 |
301471 | 301471 | 2020-07-04 | Hidalgo | New Mexico | 35023 | 58 | 0 |
304634 | 304634 | 2020-07-05 | Hidalgo | New Mexico | 35023 | 59 | 0 |
307801 | 307801 | 2020-07-06 | Hidalgo | New Mexico | 35023 | 60 | 0 |
310969 | 310969 | 2020-07-07 | Hidalgo | New Mexico | 35023 | 61 | 0 |
314140 | 314140 | 2020-07-08 | Hidalgo | New Mexico | 35023 | 62 | 0 |
317314 | 317314 | 2020-07-09 | Hidalgo | New Mexico | 35023 | 64 | 0 |
320490 | 320490 | 2020-07-10 | Hidalgo | New Mexico | 35023 | 72 | 0 |
323670 | 323670 | 2020-07-11 | Hidalgo | New Mexico | 35023 | 72 | 0 |
326854 | 326854 | 2020-07-12 | Hidalgo | New Mexico | 35023 | 72 | 0 |
330041 | 330041 | 2020-07-13 | Hidalgo | New Mexico | 35023 | 74 | 0 |
333231 | 333231 | 2020-07-14 | Hidalgo | New Mexico | 35023 | 75 | 0 |
336425 | 336425 | 2020-07-15 | Hidalgo | New Mexico | 35023 | 75 | 0 |
339621 | 339621 | 2020-07-16 | Hidalgo | New Mexico | 35023 | 76 | 0 |
342819 | 342819 | 2020-07-17 | Hidalgo | New Mexico | 35023 | 77 | 0 |
346018 | 346018 | 2020-07-18 | Hidalgo | New Mexico | 35023 | 78 | 0 |
349219 | 349219 | 2020-07-19 | Hidalgo | New Mexico | 35023 | 78 | 0 |
352422 | 352422 | 2020-07-20 | Hidalgo | New Mexico | 35023 | 78 | 0 |
355625 | 355625 | 2020-07-21 | Hidalgo | New Mexico | 35023 | 80 | 0 |
358829 | 358829 | 2020-07-22 | Hidalgo | New Mexico | 35023 | 81 | 0 |
362035 | 362035 | 2020-07-23 | Hidalgo | New Mexico | 35023 | 84 | 0 |
365241 | 365241 | 2020-07-24 | Hidalgo | New Mexico | 35023 | 85 | 0 |
368450 | 368450 | 2020-07-25 | Hidalgo | New Mexico | 35023 | 85 | 0 |
371662 | 371662 | 2020-07-26 | Hidalgo | New Mexico | 35023 | 85 | 0 |
374874 | 374874 | 2020-07-27 | Hidalgo | New Mexico | 35023 | 85 | 0 |
378089 | 378089 | 2020-07-28 | Hidalgo | New Mexico | 35023 | 85 | 0 |
381307 | 381307 | 2020-07-29 | Hidalgo | New Mexico | 35023 | 85 | 0 |
384525 | 384525 | 2020-07-30 | Hidalgo | New Mexico | 35023 | 85 | 0 |
387742 | 387742 | 2020-07-31 | Hidalgo | New Mexico | 35023 | 85 | 0 |
390958 | 390958 | 2020-08-01 | Hidalgo | New Mexico | 35023 | 88 | 0 |
394175 | 394175 | 2020-08-02 | Hidalgo | New Mexico | 35023 | 88 | 0 |
397392 | 397392 | 2020-08-03 | Hidalgo | New Mexico | 35023 | 88 | 0 |
400607 | 400607 | 2020-08-04 | Hidalgo | New Mexico | 35023 | 88 | 0 |
403825 | 403825 | 2020-08-05 | Hidalgo | New Mexico | 35023 | 88 | 0 |
407044 | 407044 | 2020-08-06 | Hidalgo | New Mexico | 35023 | 89 | 0 |
410264 | 410264 | 2020-08-07 | Hidalgo | New Mexico | 35023 | 89 | 0 |
413484 | 413484 | 2020-08-08 | Hidalgo | New Mexico | 35023 | 90 | 0 |
416705 | 416705 | 2020-08-09 | Hidalgo | New Mexico | 35023 | 90 | 0 |
419925 | 419925 | 2020-08-10 | Hidalgo | New Mexico | 35023 | 90 | 0 |
423148 | 423148 | 2020-08-11 | Hidalgo | New Mexico | 35023 | 90 | 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);