API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 22nd, 2019
103
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.04 KB | None | 0 0
raw download clone embed print report
  1. select jsonb_agg(jbo) from (
  2. select json_build_object(unnest(xpath('normalize-space(string(/*/th))', unnest)), unnest(xpath('normalize-space(string(/*/td))', unnest))) as jbo from (
  3. select unnest(xpath('/table/tbody/*', substring(html from '(<table class="infobox vcard".*<\/table>)')::xml))
  4.  
  5. from ( select $w$
  6. <table class="infobox vcard" style="" data-name="Учёный">
  7. <tbody>
  8. <tr>
  9. <th colspan="2" class="infobox-above fn"
  10. style="text-align:center; font-size: 120%; background:#eaecf0;">Натан Семёнович
  11. Лейтес</th>
  12. </tr>
  13. <tr>
  14. <td colspan="2" class="infobox-image" style="text-align:center;">
  15. <span class="no-wikidata" data-wikidata-property-id="P18"><a href="/wiki/%D0%A4%D0%B0%D0%B9%D0%BB:%D0%9B%D0%B5%D0%B9%D1%82%D0%B5%D1%81_%D0%9D%D0%B0%D1%82%D0%B0%D0%BD_%D0%A1%D0%B5%D0%BC%D1%91%D0%BD%D0%BE%D0%B2%D0%B8%D1%87.jpg" class="image"><img alt="Лейтес Натан Семёнович.jpg" src="//upload.wikimedia.org/wikipedia/ru/thumb/a/ae/%D0%9B%D0%B5%D0%B9%D1%82%D0%B5%D1%81_%D0%9D%D0%B0%D1%82%D0%B0%D0%BD_%D0%A1%D0%B5%D0%BC%D1%91%D0%BD%D0%BE%D0%B2%D0%B8%D1%87.jpg/250px-%D0%9B%D0%B5%D0%B9%D1%82%D0%B5%D1%81_%D0%9D%D0%B0%D1%82%D0%B0%D0%BD_%D0%A1%D0%B5%D0%BC%D1%91%D0%BD%D0%BE%D0%B2%D0%B8%D1%87.jpg" decoding="async" elementtiming="thumbnail-top" width="250" height="289" srcset="//upload.wikimedia.org/wikipedia/ru/thumb/a/ae/%D0%9B%D0%B5%D0%B9%D1%82%D0%B5%D1%81_%D0%9D%D0%B0%D1%82%D0%B0%D0%BD_%D0%A1%D0%B5%D0%BC%D1%91%D0%BD%D0%BE%D0%B2%D0%B8%D1%87.jpg/375px-%D0%9B%D0%B5%D0%B9%D1%82%D0%B5%D1%81_%D0%9D%D0%B0%D1%82%D0%B0%D0%BD_%D0%A1%D0%B5%D0%BC%D1%91%D0%BD%D0%BE%D0%B2%D0%B8%D1%87.jpg 1.5x, //upload.wikimedia.org/wikipedia/ru/a/ae/%D0%9B%D0%B5%D0%B9%D1%82%D0%B5%D1%81_%D0%9D%D0%B0%D1%82%D0%B0%D0%BD_%D0%A1%D0%B5%D0%BC%D1%91%D0%BD%D0%BE%D0%B2%D0%B8%D1%87.jpg 2x" data-file-width="400" data-file-height="463" /></a></span>
  16. </td>
  17. </tr>
  18. <tr>
  19. <th class="plainlist" style="min-width:8em;">Дата рождения</th>
  20. <td class="plainlist">
  21. <span class="no-wikidata" data-wikidata-property-id="P569"><a href="/wiki/26_%D0%B8%D1%8E%D0%BD%D1%8F" title="26 июня">26 июня</a> <a href="/wiki/1918_%D0%B3%D0%BE%D0%B4" title="1918 год">1918</a></span><span style="display:none">(<span class="bday">1918-06-26</span>)</span>
  22. </td>
  23. </tr>
  24. <tr>
  25. <th class="plainlist" style="min-width:8em;">Место рождения</th>
  26. <td class="plainlist">
  27. <span class="no-wikidata" data-wikidata-property-id="P19"><a href="/wiki/%D0%94%D0%BD%D0%B5%D0%BF%D1%80_(%D0%B3%D0%BE%D1%80%D0%BE%D0%B4)" title="Днепр (город)">Екатеринослав</a></span>
  28. </td>
  29. </tr>
  30. <tr>
  31. <th class="plainlist" style="min-width:8em;">Дата смерти</th>
  32. <td class="plainlist">
  33. <span class="no-wikidata" data-wikidata-property-id="P570"><a href="/wiki/6_%D0%BD%D0%BE%D1%8F%D0%B1%D1%80%D1%8F" title="6 ноября">6 ноября</a> <a href="/wiki/2013_%D0%B3%D0%BE%D0%B4" title="2013 год">2013</a></span><span style="display:none">(<span class="dday">2013-11-06</span>)</span>
  34. <span class="nowrap">(95 лет)</span></td>
  35. </tr>
  36. <tr>
  37. <th class="plainlist" style="min-width:8em;">Место смерти</th>
  38. <td class="plainlist">
  39. <span class="no-wikidata" data-wikidata-property-id="P20"><a href="/wiki/%D0%9C%D0%BE%D1%81%D0%BA%D0%B2%D0%B0" title="Москва">Москва</a></span>
  40. </td>
  41. </tr>
  42. <tr>
  43. <th class="plainlist" style="min-width:8em;">Страна</th>
  44. <td class="adr plainlist">
  45. <span class="no-wikidata" data-wikidata-property-id="P27"><span style="display: none; speak: none;" class="noprint">СССР</span><span class="nowrap"><span class="flagicon"><a href="/wiki/%D0%A1%D0%BE%D1%8E%D0%B7_%D0%A1%D0%BE%D0%B2%D0%B5%D1%82%D1%81%D0%BA%D0%B8%D1%85_%D0%A1%D0%BE%D1%86%D0%B8%D0%B0%D0%BB%D0%B8%D1%81%D1%82%D0%B8%D1%87%D0%B5%D1%81%D0%BA%D0%B8%D1%85_%D0%A0%D0%B5%D1%81%D0%BF%D1%83%D0%B1%D0%BB%D0%B8%D0%BA" title="Союз Советских Социалистических Республик"><img alt="" src="//upload.wikimedia.org/wikipedia/commons/thumb/a/a9/Flag_of_the_Soviet_Union.svg/22px-Flag_of_the_Soviet_Union.svg.png" decoding="async" elementtiming="thumbnail" width="22" height="11" class="thumbborder" srcset="//upload.wikimedia.org/wikipedia/commons/thumb/a/a9/Flag_of_the_Soviet_Union.svg/33px-Flag_of_the_Soviet_Union.svg.png 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/a/a9/Flag_of_the_Soviet_Union.svg/44px-Flag_of_the_Soviet_Union.svg.png 2x" data-file-width="1200" data-file-height="600" /></a></span>&#160;<a
  46. href="/wiki/%D0%A1%D0%BE%D1%8E%D0%B7_%D0%A1%D0%BE%D0%B2%D0%B5%D1%82%D1%81%D0%BA%D0%B8%D1%85_%D0%A1%D0%BE%D1%86%D0%B8%D0%B0%D0%BB%D0%B8%D1%81%D1%82%D0%B8%D1%87%D0%B5%D1%81%D0%BA%D0%B8%D1%85_%D0%A0%D0%B5%D1%81%D0%BF%D1%83%D0%B1%D0%BB%D0%B8%D0%BA"
  47. title="Союз Советских Социалистических Республик"><span class="wrap">СССР</span></a></span>&#160;→
  48. <span style="display: none; speak: none;" class="noprint">Россия</span><span class="nowrap"><span class="flagicon"><a href="/wiki/%D0%A0%D0%BE%D1%81%D1%81%D0%B8%D1%8F" title="Россия"><img alt="" src="//upload.wikimedia.org/wikipedia/commons/thumb/f/f3/Flag_of_Russia.svg/22px-Flag_of_Russia.svg.png" decoding="async" elementtiming="thumbnail" width="22" height="15" class="thumbborder" srcset="//upload.wikimedia.org/wikipedia/commons/thumb/f/f3/Flag_of_Russia.svg/33px-Flag_of_Russia.svg.png 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/f/f3/Flag_of_Russia.svg/44px-Flag_of_Russia.svg.png 2x" data-file-width="900" data-file-height="600" /></a></span>&#160;<a
  49. href="/wiki/%D0%A0%D0%BE%D1%81%D1%81%D0%B8%D1%8F"
  50. title="Россия"><span class="wrap">Россия</span></a></span></span></td>
  51. </tr>
  52. <tr>
  53. <th class="plainlist" style="min-width:8em;">Научная сфера</th>
  54. <td class="plainlist">
  55. <span class="no-wikidata" data-wikidata-property-id="P101"><a href="/wiki/%D0%9F%D1%81%D0%B8%D1%85%D0%BE%D1%84%D0%B8%D0%B7%D0%B8%D0%BE%D0%BB%D0%BE%D0%B3%D0%B8%D1%8F" title="Психофизиология">психофизиология</a>, <a href="/wiki/%D0%92%D0%BE%D0%B7%D1%80%D0%B0%D1%81%D1%82%D0%BD%D0%B0%D1%8F_%D0%BF%D1%81%D0%B8%D1%85%D0%BE%D0%BB%D0%BE%D0%B3%D0%B8%D1%8F" class="mw-redirect" title="Возрастная психология">возрастная психология</a>, <a href="/wiki/%D0%94%D0%B8%D1%84%D1%84%D0%B5%D1%80%D0%B5%D0%BD%D1%86%D0%B8%D0%B0%D0%BB%D1%8C%D0%BD%D0%B0%D1%8F_%D0%BF%D1%81%D0%B8%D1%85%D0%BE%D0%BB%D0%BE%D0%B3%D0%B8%D1%8F" title="Дифференциальная психология">дифференциальная психология</a>, <a href="/wiki/%D0%9F%D0%B5%D0%B4%D0%B0%D0%B3%D0%BE%D0%B3%D0%B8%D1%87%D0%B5%D1%81%D0%BA%D0%B0%D1%8F_%D0%BF%D1%81%D0%B8%D1%85%D0%BE%D0%BB%D0%BE%D0%B3%D0%B8%D1%8F" title="Педагогическая психология">педагогическая психология</a></span>
  56. </td>
  57. </tr>
  58. <tr>
  59. <th class="plainlist" style="min-width:8em;"><a
  60. href="/wiki/%D0%90%D0%BB%D1%8C%D0%BC%D0%B0-%D0%BC%D0%B0%D1%82%D0%B5%D1%80"
  61. title="Альма-матер">Альма-матер</a></th>
  62. <td class="plainlist">
  63. <span class="no-wikidata" data-wikidata-property-id="P69"><a href="/wiki/%D0%9C%D0%BE%D1%81%D0%BA%D0%BE%D0%B2%D1%81%D0%BA%D0%B8%D0%B9_%D0%B3%D0%BE%D1%81%D1%83%D0%B4%D0%B0%D1%80%D1%81%D1%82%D0%B2%D0%B5%D0%BD%D0%BD%D1%8B%D0%B9_%D1%83%D0%BD%D0%B8%D0%B2%D0%B5%D1%80%D1%81%D0%B8%D1%82%D0%B5%D1%82" title="Московский государственный университет">Московский государственный университет</a></span>
  64. </td>
  65. </tr>
  66. <tr>
  67. <th class="plainlist" style="min-width:8em;">Учёная степень</th>
  68. <td class="plainlist">
  69. <span class="no-wikidata" data-wikidata-property-id="P512"><a href="/wiki/%D0%94%D0%BE%D0%BA%D1%82%D0%BE%D1%80_%D0%BF%D1%81%D0%B8%D1%85%D0%BE%D0%BB%D0%BE%D0%B3%D0%B8%D1%87%D0%B5%D1%81%D0%BA%D0%B8%D1%85_%D0%BD%D0%B0%D1%83%D0%BA" class="mw-redirect" title="Доктор психологических наук">доктор психологических наук</a></span>
  70. </td>
  71. </tr>
  72. <tr>
  73. <th class="plainlist" style="min-width:8em;">Учёное звание</th>
  74. <td class="plainlist">
  75. <span class="no-wikidata" data-wikidata-property-id="P803"><a href="/wiki/%D0%9F%D1%80%D0%BE%D1%84%D0%B5%D1%81%D1%81%D0%BE%D1%80" title="Профессор">профессор</a></span>
  76. </td>
  77. </tr>
  78. <tr>
  79. <th class="plainlist" style="min-width:8em;">Научный руководитель</th>
  80. <td class="plainlist">
  81. <span class="no-wikidata" data-wikidata-property-id="P184"><a href="/wiki/%D0%A2%D0%B5%D0%BF%D0%BB%D0%BE%D0%B2,_%D0%91%D0%BE%D1%80%D0%B8%D1%81_%D0%9C%D0%B8%D1%85%D0%B0%D0%B9%D0%BB%D0%BE%D0%B2%D0%B8%D1%87" title="Теплов, Борис Михайлович">Б. М. Теплов</a></span>
  82. </td>
  83. </tr>
  84. <tr>
  85. <th class="plainlist" style="min-width:8em;">Известен как</th>
  86. <td class="note plainlist">
  87. исследователь <a
  88. href="/wiki/%D0%92%D1%83%D0%BD%D0%B4%D0%B5%D1%80%D0%BA%D0%B8%D0%BD%D0%B4%D1%8B"
  89. title="Вундеркинды">детской одарённости</a>, а также автор термина
  90. «<i>возрастная <a href="/wiki/%D0%9E%D0%B4%D0%B0%D1%80%D1%91%D0%BD%D0%BD%D0%BE%D1%81%D1%82%D1%8C" title="Одарённость">одарённость</a></i>».
  91. </td>
  92. </tr>
  93. <tr>
  94. <th class="plainlist" style="min-width:8em;">Награды и&#160;премии</th>
  95. <td class="plainlist">
  96. <span class="no-wikidata" data-wikidata-property-id="P166"><a href="/wiki/%D0%9F%D1%80%D0%B5%D0%BC%D0%B8%D1%8F_%D0%9F%D1%80%D0%B0%D0%B2%D0%B8%D1%82%D0%B5%D0%BB%D1%8C%D1%81%D1%82%D0%B2%D0%B0_%D0%A0%D0%BE%D1%81%D1%81%D0%B8%D0%B9%D1%81%D0%BA%D0%BE%D0%B9_%D0%A4%D0%B5%D0%B4%D0%B5%D1%80%D0%B0%D1%86%D0%B8%D0%B8_%E2%80%94_1998" title="Премия Правительства Российской Федерации — 1998"><img alt="Почётный знак лауреата премии Правительства Российской Федерации.png" src="//upload.wikimedia.org/wikipedia/commons/thumb/5/55/%D0%9F%D0%BE%D1%87%D1%91%D1%82%D0%BD%D1%8B%D0%B9_%D0%B7%D0%BD%D0%B0%D0%BA_%D0%BB%D0%B0%D1%83%D1%80%D0%B5%D0%B0%D1%82%D0%B0_%D0%BF%D1%80%D0%B5%D0%BC%D0%B8%D0%B8_%D0%9F%D1%80%D0%B0%D0%B2%D0%B8%D1%82%D0%B5%D0%BB%D1%8C%D1%81%D1%82%D0%B2%D0%B0_%D0%A0%D0%BE%D1%81%D1%81%D0%B8%D0%B9%D1%81%D0%BA%D0%BE%D0%B9_%D0%A4%D0%B5%D0%B4%D0%B5%D1%80%D0%B0%D1%86%D0%B8%D0%B8.png/20px-%D0%9F%D0%BE%D1%87%D1%91%D1%82%D0%BD%D1%8B%D0%B9_%D0%B7%D0%BD%D0%B0%D0%BA_%D0%BB%D0%B0%D1%83%D1%80%D0%B5%D0%B0%D1%82%D0%B0_%D0%BF%D1%80%D0%B5%D0%BC%D0%B8%D0%B8_%D0%9F%D1%80%D0%B0%D0%B2%D0%B8%D1%82%D0%B5%D0%BB%D1%8C%D1%81%D1%82%D0%B2%D0%B0_%D0%A0%D0%BE%D1%81%D1%81%D0%B8%D0%B9%D1%81%D0%BA%D0%BE%D0%B9_%D0%A4%D0%B5%D0%B4%D0%B5%D1%80%D0%B0%D1%86%D0%B8%D0%B8.png" decoding="async" elementtiming="thumbnail" width="20" height="36" srcset="//upload.wikimedia.org/wikipedia/commons/thumb/5/55/%D0%9F%D0%BE%D1%87%D1%91%D1%82%D0%BD%D1%8B%D0%B9_%D0%B7%D0%BD%D0%B0%D0%BA_%D0%BB%D0%B0%D1%83%D1%80%D0%B5%D0%B0%D1%82%D0%B0_%D0%BF%D1%80%D0%B5%D0%BC%D0%B8%D0%B8_%D0%9F%D1%80%D0%B0%D0%B2%D0%B8%D1%82%D0%B5%D0%BB%D1%8C%D1%81%D1%82%D0%B2%D0%B0_%D0%A0%D0%BE%D1%81%D1%81%D0%B8%D0%B9%D1%81%D0%BA%D0%BE%D0%B9_%D0%A4%D0%B5%D0%B4%D0%B5%D1%80%D0%B0%D1%86%D0%B8%D0%B8.png/30px-%D0%9F%D0%BE%D1%87%D1%91%D1%82%D0%BD%D1%8B%D0%B9_%D0%B7%D0%BD%D0%B0%D0%BA_%D0%BB%D0%B0%D1%83%D1%80%D0%B5%D0%B0%D1%82%D0%B0_%D0%BF%D1%80%D0%B5%D0%BC%D0%B8%D0%B8_%D0%9F%D1%80%D0%B0%D0%B2%D0%B8%D1%82%D0%B5%D0%BB%D1%8C%D1%81%D1%82%D0%B2%D0%B0_%D0%A0%D0%BE%D1%81%D1%81%D0%B8%D0%B9%D1%81%D0%BA%D0%BE%D0%B9_%D0%A4%D0%B5%D0%B4%D0%B5%D1%80%D0%B0%D1%86%D0%B8%D0%B8.png 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/5/55/%D0%9F%D0%BE%D1%87%D1%91%D1%82%D0%BD%D1%8B%D0%B9_%D0%B7%D0%BD%D0%B0%D0%BA_%D0%BB%D0%B0%D1%83%D1%80%D0%B5%D0%B0%D1%82%D0%B0_%D0%BF%D1%80%D0%B5%D0%BC%D0%B8%D0%B8_%D0%9F%D1%80%D0%B0%D0%B2%D0%B8%D1%82%D0%B5%D0%BB%D1%8C%D1%81%D1%82%D0%B2%D0%B0_%D0%A0%D0%BE%D1%81%D1%81%D0%B8%D0%B9%D1%81%D0%BA%D0%BE%D0%B9_%D0%A4%D0%B5%D0%B4%D0%B5%D1%80%D0%B0%D1%86%D0%B8%D0%B8.png/40px-%D0%9F%D0%BE%D1%87%D1%91%D1%82%D0%BD%D1%8B%D0%B9_%D0%B7%D0%BD%D0%B0%D0%BA_%D0%BB%D0%B0%D1%83%D1%80%D0%B5%D0%B0%D1%82%D0%B0_%D0%BF%D1%80%D0%B5%D0%BC%D0%B8%D0%B8_%D0%9F%D1%80%D0%B0%D0%B2%D0%B8%D1%82%D0%B5%D0%BB%D1%8C%D1%81%D1%82%D0%B2%D0%B0_%D0%A0%D0%BE%D1%81%D1%81%D0%B8%D0%B9%D1%81%D0%BA%D0%BE%D0%B9_%D0%A4%D0%B5%D0%B4%D0%B5%D1%80%D0%B0%D1%86%D0%B8%D0%B8.png 2x" data-file-width="87" data-file-height="156" /></a></span>
  97. </td>
  98. </tr>
  99. </tbody>
  100. </table>
  101. $w$ as html) t) t) t
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!