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 state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
426371 | 426371 | 2020-08-12 | Hidalgo | New Mexico | 35023 | 90 | 0 |
429595 | 429595 | 2020-08-13 | Hidalgo | New Mexico | 35023 | 90 | 0 |
432822 | 432822 | 2020-08-14 | Hidalgo | New Mexico | 35023 | 90 | 0 |
436048 | 436048 | 2020-08-15 | Hidalgo | New Mexico | 35023 | 90 | 0 |
439273 | 439273 | 2020-08-16 | Hidalgo | New Mexico | 35023 | 90 | 0 |
442500 | 442500 | 2020-08-17 | Hidalgo | New Mexico | 35023 | 93 | 0 |
445726 | 445726 | 2020-08-18 | Hidalgo | New Mexico | 35023 | 93 | 0 |
448953 | 448953 | 2020-08-19 | Hidalgo | New Mexico | 35023 | 93 | 0 |
452182 | 452182 | 2020-08-20 | Hidalgo | New Mexico | 35023 | 93 | 0 |
455410 | 455410 | 2020-08-21 | Hidalgo | New Mexico | 35023 | 93 | 0 |
458637 | 458637 | 2020-08-22 | Hidalgo | New Mexico | 35023 | 93 | 1 |
461865 | 461865 | 2020-08-23 | Hidalgo | New Mexico | 35023 | 93 | 1 |
465095 | 465095 | 2020-08-24 | Hidalgo | New Mexico | 35023 | 93 | 1 |
468323 | 468323 | 2020-08-25 | Hidalgo | New Mexico | 35023 | 93 | 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);