API tools faq
paste
Guest User

Untitled

a guest
Dec 9th, 2017
143
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 180.38 KB | None | 0 0
raw download clone embed print report
  1. {
  2. "cells": [
  3. {
  4. "cell_type": "code",
  5. "execution_count": 1,
  6. "metadata": {
  7. "collapsed": true
  8. },
  9. "outputs": [],
  10. "source": [
  11. "import findspark\n",
  12. "findspark.init()\n",
  13. "import pyspark\n",
  14. "from pyspark.sql import SQLContext\n",
  15. "sc = pyspark.SparkContext(appName=\"jdbcquery\")\n",
  16. "spark = SQLContext(sc)"
  17. ]
  18. },
  19. {
  20. "cell_type": "code",
  21. "execution_count": 2,
  22. "metadata": {
  23. "collapsed": true
  24. },
  25. "outputs": [],
  26. "source": [
  27. "def show_query_response(query):\n",
  28. " url = \"jdbc:postgresql://localhost:5432/postgres\"\n",
  29. " properties = {\"user\": \"postgres\",\"password\": \"postgres\",\"driver\": \"org.postgresql.Driver\"}\n",
  30. " read_test_with_query2 = spark.read.jdbc(table=\"(%s) as t\"%query, properties=properties, url=url)\n",
  31. " return read_test_with_query2.toPandas()"
  32. ]
  33. },
  34. {
  35. "cell_type": "code",
  36. "execution_count": 3,
  37. "metadata": {},
  38. "outputs": [
  39. {
  40. "data": {
  41. "text/html": [
  42. "<div>\n",
  43. "<style>\n",
  44. " .dataframe thead tr:only-child th {\n",
  45. " text-align: right;\n",
  46. " }\n",
  47. "\n",
  48. " .dataframe thead th {\n",
  49. " text-align: left;\n",
  50. " }\n",
  51. "\n",
  52. " .dataframe tbody tr th {\n",
  53. " vertical-align: top;\n",
  54. " }\n",
  55. "</style>\n",
  56. "<table border=\"1\" class=\"dataframe\">\n",
  57. " <thead>\n",
  58. " <tr style=\"text-align: right;\">\n",
  59. " <th></th>\n",
  60. " <th>borough</th>\n",
  61. " <th>cuisine</th>\n",
  62. " <th>name</th>\n",
  63. " <th>restaurant_id</th>\n",
  64. " <th>address_json</th>\n",
  65. " <th>grades_json</th>\n",
  66. " </tr>\n",
  67. " </thead>\n",
  68. " <tbody>\n",
  69. " <tr>\n",
  70. " <th>0</th>\n",
  71. " <td>Bronx</td>\n",
  72. " <td>Bakery</td>\n",
  73. " <td>Morris Park Bake Shop</td>\n",
  74. " <td>30075445</td>\n",
  75. " <td>{\"building\":\"1007\",\"coord\":[-73.856077,40.8484...</td>\n",
  76. " <td>[{\"date\":{\"$date\":1393804800000},\"grade\":\"A\",\"...</td>\n",
  77. " </tr>\n",
  78. " <tr>\n",
  79. " <th>1</th>\n",
  80. " <td>Brooklyn</td>\n",
  81. " <td>Hamburgers</td>\n",
  82. " <td>Wendy'S</td>\n",
  83. " <td>30112340</td>\n",
  84. " <td>{\"building\":\"469\",\"coord\":[-73.961704,40.66294...</td>\n",
  85. " <td>[{\"date\":{\"$date\":1419897600000},\"grade\":\"A\",\"...</td>\n",
  86. " </tr>\n",
  87. " <tr>\n",
  88. " <th>2</th>\n",
  89. " <td>Manhattan</td>\n",
  90. " <td>Irish</td>\n",
  91. " <td>Dj Reynolds Pub And Restaurant</td>\n",
  92. " <td>30191841</td>\n",
  93. " <td>{\"building\":\"351\",\"coord\":[-73.98513559999999,...</td>\n",
  94. " <td>[{\"date\":{\"$date\":1409961600000},\"grade\":\"A\",\"...</td>\n",
  95. " </tr>\n",
  96. " <tr>\n",
  97. " <th>3</th>\n",
  98. " <td>Brooklyn</td>\n",
  99. " <td>American</td>\n",
  100. " <td>Riviera Caterer</td>\n",
  101. " <td>40356018</td>\n",
  102. " <td>{\"building\":\"2780\",\"coord\":[-73.98241999999999...</td>\n",
  103. " <td>[{\"date\":{\"$date\":1402358400000},\"grade\":\"A\",\"...</td>\n",
  104. " </tr>\n",
  105. " <tr>\n",
  106. " <th>4</th>\n",
  107. " <td>Queens</td>\n",
  108. " <td>Jewish/Kosher</td>\n",
  109. " <td>Tov Kosher Kitchen</td>\n",
  110. " <td>40356068</td>\n",
  111. " <td>{\"building\":\"97-22\",\"coord\":[-73.8601152,40.73...</td>\n",
  112. " <td>[{\"date\":{\"$date\":1416787200000},\"grade\":\"Z\",\"...</td>\n",
  113. " </tr>\n",
  114. " <tr>\n",
  115. " <th>5</th>\n",
  116. " <td>Queens</td>\n",
  117. " <td>American</td>\n",
  118. " <td>Brunos On The Boulevard</td>\n",
  119. " <td>40356151</td>\n",
  120. " <td>{\"building\":\"8825\",\"coord\":[-73.8803827,40.764...</td>\n",
  121. " <td>[{\"date\":{\"$date\":1416009600000},\"grade\":\"Z\",\"...</td>\n",
  122. " </tr>\n",
  123. " <tr>\n",
  124. " <th>6</th>\n",
  125. " <td>Staten Island</td>\n",
  126. " <td>Jewish/Kosher</td>\n",
  127. " <td>Kosher Island</td>\n",
  128. " <td>40356442</td>\n",
  129. " <td>{\"building\":\"2206\",\"coord\":[-74.1377286,40.611...</td>\n",
  130. " <td>[{\"date\":{\"$date\":1412553600000},\"grade\":\"A\",\"...</td>\n",
  131. " </tr>\n",
  132. " <tr>\n",
  133. " <th>7</th>\n",
  134. " <td>Brooklyn</td>\n",
  135. " <td>Delicatessen</td>\n",
  136. " <td>Wilken'S Fine Food</td>\n",
  137. " <td>40356483</td>\n",
  138. " <td>{\"building\":\"7114\",\"coord\":[-73.9068506,40.619...</td>\n",
  139. " <td>[{\"date\":{\"$date\":1401321600000},\"grade\":\"A\",\"...</td>\n",
  140. " </tr>\n",
  141. " <tr>\n",
  142. " <th>8</th>\n",
  143. " <td>Brooklyn</td>\n",
  144. " <td>American</td>\n",
  145. " <td>Regina Caterers</td>\n",
  146. " <td>40356649</td>\n",
  147. " <td>{\"building\":\"6409\",\"coord\":[-74.00528899999999...</td>\n",
  148. " <td>[{\"date\":{\"$date\":1405641600000},\"grade\":\"A\",\"...</td>\n",
  149. " </tr>\n",
  150. " <tr>\n",
  151. " <th>9</th>\n",
  152. " <td>Brooklyn</td>\n",
  153. " <td>Ice Cream, Gelato, Yogurt, Ices</td>\n",
  154. " <td>Taste The Tropics Ice Cream</td>\n",
  155. " <td>40356731</td>\n",
  156. " <td>{\"building\":\"1839\",\"coord\":[-73.9482609,40.640...</td>\n",
  157. " <td>[{\"date\":{\"$date\":1405296000000},\"grade\":\"A\",\"...</td>\n",
  158. " </tr>\n",
  159. " <tr>\n",
  160. " <th>10</th>\n",
  161. " <td>Bronx</td>\n",
  162. " <td>American</td>\n",
  163. " <td>Wild Asia</td>\n",
  164. " <td>40357217</td>\n",
  165. " <td>{\"building\":\"2300\",\"coord\":[-73.8786113,40.850...</td>\n",
  166. " <td>[{\"date\":{\"$date\":1401235200000},\"grade\":\"A\",\"...</td>\n",
  167. " </tr>\n",
  168. " <tr>\n",
  169. " <th>11</th>\n",
  170. " <td>Brooklyn</td>\n",
  171. " <td>American</td>\n",
  172. " <td>C & C Catering Service</td>\n",
  173. " <td>40357437</td>\n",
  174. " <td>{\"building\":\"7715\",\"coord\":[-73.9973325,40.611...</td>\n",
  175. " <td>[{\"date\":{\"$date\":1397606400000},\"grade\":\"A\",\"...</td>\n",
  176. " </tr>\n",
  177. " <tr>\n",
  178. " <th>12</th>\n",
  179. " <td>Brooklyn</td>\n",
  180. " <td>Chinese</td>\n",
  181. " <td>May May Kitchen</td>\n",
  182. " <td>40358429</td>\n",
  183. " <td>{\"building\":\"1269\",\"coord\":[-73.871194,40.6730...</td>\n",
  184. " <td>[{\"date\":{\"$date\":1410825600000},\"grade\":\"B\",\"...</td>\n",
  185. " </tr>\n",
  186. " <tr>\n",
  187. " <th>13</th>\n",
  188. " <td>Manhattan</td>\n",
  189. " <td>American</td>\n",
  190. " <td>1 East 66Th Street Kitchen</td>\n",
  191. " <td>40359480</td>\n",
  192. " <td>{\"building\":\"1\",\"coord\":[-73.96926909999999,40...</td>\n",
  193. " <td>[{\"date\":{\"$date\":1399420800000},\"grade\":\"A\",\"...</td>\n",
  194. " </tr>\n",
  195. " <tr>\n",
  196. " <th>14</th>\n",
  197. " <td>Brooklyn</td>\n",
  198. " <td>Jewish/Kosher</td>\n",
  199. " <td>Seuda Foods</td>\n",
  200. " <td>40360045</td>\n",
  201. " <td>{\"building\":\"705\",\"coord\":[-73.9653967,40.6064...</td>\n",
  202. " <td>[{\"date\":{\"$date\":1415577600000},\"grade\":\"A\",\"...</td>\n",
  203. " </tr>\n",
  204. " <tr>\n",
  205. " <th>15</th>\n",
  206. " <td>Brooklyn</td>\n",
  207. " <td>Ice Cream, Gelato, Yogurt, Ices</td>\n",
  208. " <td>Carvel Ice Cream</td>\n",
  209. " <td>40360076</td>\n",
  210. " <td>{\"building\":\"203\",\"coord\":[-73.97822040000001,...</td>\n",
  211. " <td>[{\"date\":{\"$date\":1391990400000},\"grade\":\"A\",\"...</td>\n",
  212. " </tr>\n",
  213. " <tr>\n",
  214. " <th>16</th>\n",
  215. " <td>Queens</td>\n",
  216. " <td>Ice Cream, Gelato, Yogurt, Ices</td>\n",
  217. " <td>Carvel Ice Cream</td>\n",
  218. " <td>40361322</td>\n",
  219. " <td>{\"building\":\"265-15\",\"coord\":[-73.7032601,40.7...</td>\n",
  220. " <td>[{\"date\":{\"$date\":1414454400000},\"grade\":\"A\",\"...</td>\n",
  221. " </tr>\n",
  222. " <tr>\n",
  223. " <th>17</th>\n",
  224. " <td>Brooklyn</td>\n",
  225. " <td>Delicatessen</td>\n",
  226. " <td>Nordic Delicacies</td>\n",
  227. " <td>40361390</td>\n",
  228. " <td>{\"building\":\"6909\",\"coord\":[-74.0259567,40.635...</td>\n",
  229. " <td>[{\"date\":{\"$date\":1408579200000},\"grade\":\"A\",\"...</td>\n",
  230. " </tr>\n",
  231. " <tr>\n",
  232. " <th>18</th>\n",
  233. " <td>Manhattan</td>\n",
  234. " <td>American</td>\n",
  235. " <td>Glorious Food</td>\n",
  236. " <td>40361521</td>\n",
  237. " <td>{\"building\":\"522\",\"coord\":[-73.95171,40.767461...</td>\n",
  238. " <td>[{\"date\":{\"$date\":1409616000000},\"grade\":\"A\",\"...</td>\n",
  239. " </tr>\n",
  240. " <tr>\n",
  241. " <th>19</th>\n",
  242. " <td>Brooklyn</td>\n",
  243. " <td>American</td>\n",
  244. " <td>The Movable Feast</td>\n",
  245. " <td>40361606</td>\n",
  246. " <td>{\"building\":\"284\",\"coord\":[-73.9829239,40.6580...</td>\n",
  247. " <td>[{\"date\":{\"$date\":1416355200000},\"grade\":\"A\",\"...</td>\n",
  248. " </tr>\n",
  249. " <tr>\n",
  250. " <th>20</th>\n",
  251. " <td>Queens</td>\n",
  252. " <td>Delicatessen</td>\n",
  253. " <td>Sal'S Deli</td>\n",
  254. " <td>40361618</td>\n",
  255. " <td>{\"building\":\"129-08\",\"coord\":[-73.839297,40.78...</td>\n",
  256. " <td>[{\"date\":{\"$date\":1408147200000},\"grade\":\"A\",\"...</td>\n",
  257. " </tr>\n",
  258. " <tr>\n",
  259. " <th>21</th>\n",
  260. " <td>Manhattan</td>\n",
  261. " <td>Delicatessen</td>\n",
  262. " <td>Bully'S Deli</td>\n",
  263. " <td>40361708</td>\n",
  264. " <td>{\"building\":\"759\",\"coord\":[-73.9925306,40.7309...</td>\n",
  265. " <td>[{\"date\":{\"$date\":1390262400000},\"grade\":\"A\",\"...</td>\n",
  266. " </tr>\n",
  267. " <tr>\n",
  268. " <th>22</th>\n",
  269. " <td>Queens</td>\n",
  270. " <td>Delicatessen</td>\n",
  271. " <td>Steve Chu'S Deli & Grocery</td>\n",
  272. " <td>40361998</td>\n",
  273. " <td>{\"building\":\"3406\",\"coord\":[-73.94024739999999...</td>\n",
  274. " <td>[{\"date\":{\"$date\":1395187200000},\"grade\":\"A\",\"...</td>\n",
  275. " </tr>\n",
  276. " <tr>\n",
  277. " <th>23</th>\n",
  278. " <td>Manhattan</td>\n",
  279. " <td>Chicken</td>\n",
  280. " <td>Harriet'S Kitchen</td>\n",
  281. " <td>40362098</td>\n",
  282. " <td>{\"building\":\"502\",\"coord\":[-73.976112,40.78671...</td>\n",
  283. " <td>[{\"date\":{\"$date\":1410739200000},\"grade\":\"A\",\"...</td>\n",
  284. " </tr>\n",
  285. " <tr>\n",
  286. " <th>24</th>\n",
  287. " <td>Manhattan</td>\n",
  288. " <td>American</td>\n",
  289. " <td>P & S Deli Grocery</td>\n",
  290. " <td>40362264</td>\n",
  291. " <td>{\"building\":\"730\",\"coord\":[-73.96805719999999,...</td>\n",
  292. " <td>[{\"date\":{\"$date\":1410480000000},\"grade\":\"B\",\"...</td>\n",
  293. " </tr>\n",
  294. " <tr>\n",
  295. " <th>25</th>\n",
  296. " <td>Manhattan</td>\n",
  297. " <td>American</td>\n",
  298. " <td>Angelika Film Center</td>\n",
  299. " <td>40362274</td>\n",
  300. " <td>{\"building\":\"18\",\"coord\":[-73.996984,40.72589]...</td>\n",
  301. " <td>[{\"date\":{\"$date\":1396483200000},\"grade\":\"A\",\"...</td>\n",
  302. " </tr>\n",
  303. " <tr>\n",
  304. " <th>26</th>\n",
  305. " <td>Brooklyn</td>\n",
  306. " <td>Hamburgers</td>\n",
  307. " <td>White Castle</td>\n",
  308. " <td>40362344</td>\n",
  309. " <td>{\"building\":\"531\",\"coord\":[-73.9634876,40.6940...</td>\n",
  310. " <td>[{\"date\":{\"$date\":1395100800000},\"grade\":\"A\",\"...</td>\n",
  311. " </tr>\n",
  312. " <tr>\n",
  313. " <th>27</th>\n",
  314. " <td>Queens</td>\n",
  315. " <td>Chinese</td>\n",
  316. " <td>Ho Mei Restaurant</td>\n",
  317. " <td>40362432</td>\n",
  318. " <td>{\"building\":\"103-05\",\"coord\":[-73.8642349,40.7...</td>\n",
  319. " <td>[{\"date\":{\"$date\":1398038400000},\"grade\":\"A\",\"...</td>\n",
  320. " </tr>\n",
  321. " <tr>\n",
  322. " <th>28</th>\n",
  323. " <td>Manhattan</td>\n",
  324. " <td>Turkish</td>\n",
  325. " <td>The Country Cafe</td>\n",
  326. " <td>40362715</td>\n",
  327. " <td>{\"building\":\"60\",\"coord\":[-74.0085357,40.70620...</td>\n",
  328. " <td>[{\"date\":{\"$date\":1411689600000},\"grade\":\"A\",\"...</td>\n",
  329. " </tr>\n",
  330. " <tr>\n",
  331. " <th>29</th>\n",
  332. " <td>Brooklyn</td>\n",
  333. " <td>Caribbean</td>\n",
  334. " <td>Shashemene Int'L Restaura</td>\n",
  335. " <td>40362869</td>\n",
  336. " <td>{\"building\":\"195\",\"coord\":[-73.9246028,40.6522...</td>\n",
  337. " <td>[{\"date\":{\"$date\":1399939200000},\"grade\":\"A\",\"...</td>\n",
  338. " </tr>\n",
  339. " <tr>\n",
  340. " <th>...</th>\n",
  341. " <td>...</td>\n",
  342. " <td>...</td>\n",
  343. " <td>...</td>\n",
  344. " <td>...</td>\n",
  345. " <td>...</td>\n",
  346. " <td>...</td>\n",
  347. " </tr>\n",
  348. " <tr>\n",
  349. " <th>25329</th>\n",
  350. " <td>Queens</td>\n",
  351. " <td>Mexican</td>\n",
  352. " <td>Bella'S Place</td>\n",
  353. " <td>41646934</td>\n",
  354. " <td>{\"building\":\"87-77\",\"coord\":[-73.8093635,40.70...</td>\n",
  355. " <td>[{\"date\":{\"$date\":1413417600000},\"grade\":\"Z\",\"...</td>\n",
  356. " </tr>\n",
  357. " <tr>\n",
  358. " <th>25330</th>\n",
  359. " <td>Brooklyn</td>\n",
  360. " <td>Caribbean</td>\n",
  361. " <td>Perfect Touch Cuisine Ii</td>\n",
  362. " <td>41646958</td>\n",
  363. " <td>{\"building\":\"1148\",\"coord\":[-73.9508029,40.659...</td>\n",
  364. " <td>[{\"date\":{\"$date\":1409270400000},\"grade\":\"B\",\"...</td>\n",
  365. " </tr>\n",
  366. " <tr>\n",
  367. " <th>25331</th>\n",
  368. " <td>Brooklyn</td>\n",
  369. " <td>American</td>\n",
  370. " <td>Del Rio Diner</td>\n",
  371. " <td>41646963</td>\n",
  372. " <td>{\"building\":\"166\",\"coord\":[-73.98527659999999,...</td>\n",
  373. " <td>[{\"date\":{\"$date\":1397001600000},\"grade\":\"A\",\"...</td>\n",
  374. " </tr>\n",
  375. " <tr>\n",
  376. " <th>25332</th>\n",
  377. " <td>Manhattan</td>\n",
  378. " <td>Chinese</td>\n",
  379. " <td>Fay Da Bakery</td>\n",
  380. " <td>41646967</td>\n",
  381. " <td>{\"building\":\"321\",\"coord\":[-74.0062401,40.7397...</td>\n",
  382. " <td>[{\"date\":{\"$date\":1399852800000},\"grade\":\"A\",\"...</td>\n",
  383. " </tr>\n",
  384. " <tr>\n",
  385. " <th>25333</th>\n",
  386. " <td>Manhattan</td>\n",
  387. " <td>Caribbean</td>\n",
  388. " <td>Jahlookova</td>\n",
  389. " <td>41646976</td>\n",
  390. " <td>{\"building\":\"1962\",\"coord\":[-73.9405519,40.806...</td>\n",
  391. " <td>[{\"date\":{\"$date\":1416960000000},\"grade\":\"A\",\"...</td>\n",
  392. " </tr>\n",
  393. " <tr>\n",
  394. " <th>25334</th>\n",
  395. " <td>Manhattan</td>\n",
  396. " <td>Delicatessen</td>\n",
  397. " <td>Merci Market</td>\n",
  398. " <td>41646979</td>\n",
  399. " <td>{\"building\":\"350\",\"coord\":[-73.9922178,40.7579...</td>\n",
  400. " <td>[{\"date\":{\"$date\":1420588800000},\"grade\":\"Z\",\"...</td>\n",
  401. " </tr>\n",
  402. " <tr>\n",
  403. " <th>25335</th>\n",
  404. " <td>Queens</td>\n",
  405. " <td>Caribbean</td>\n",
  406. " <td>Meat Veggies & Pasta Restaurant</td>\n",
  407. " <td>41647006</td>\n",
  408. " <td>{\"building\":\"118-16\",\"coord\":[-73.819531,40.67...</td>\n",
  409. " <td>[{\"date\":{\"$date\":1415577600000},\"grade\":\"A\",\"...</td>\n",
  410. " </tr>\n",
  411. " <tr>\n",
  412. " <th>25336</th>\n",
  413. " <td>Manhattan</td>\n",
  414. " <td>American</td>\n",
  415. " <td>Toshi'S Living Room</td>\n",
  416. " <td>41647012</td>\n",
  417. " <td>{\"building\":\"9\",\"coord\":[-73.98931019999999,40...</td>\n",
  418. " <td>[{\"date\":{\"$date\":1415750400000},\"grade\":\"A\",\"...</td>\n",
  419. " </tr>\n",
  420. " <tr>\n",
  421. " <th>25337</th>\n",
  422. " <td>Manhattan</td>\n",
  423. " <td>American</td>\n",
  424. " <td>Five Lamps Tavern</td>\n",
  425. " <td>41647017</td>\n",
  426. " <td>{\"building\":\"2756\",\"coord\":[-73.9675441,40.800...</td>\n",
  427. " <td>[{\"date\":{\"$date\":1407283200000},\"grade\":\"C\",\"...</td>\n",
  428. " </tr>\n",
  429. " <tr>\n",
  430. " <th>25338</th>\n",
  431. " <td>Queens</td>\n",
  432. " <td>German</td>\n",
  433. " <td>Max</td>\n",
  434. " <td>41647039</td>\n",
  435. " <td>{\"building\":\"47-02\",\"coord\":[-73.918047,40.765...</td>\n",
  436. " <td>[{\"date\":{\"$date\":1416355200000},\"grade\":\"A\",\"...</td>\n",
  437. " </tr>\n",
  438. " <tr>\n",
  439. " <th>25339</th>\n",
  440. " <td>Queens</td>\n",
  441. " <td>Chinese</td>\n",
  442. " <td>Liang'S Kitchen Flushing Restaurant</td>\n",
  443. " <td>41647062</td>\n",
  444. " <td>{\"building\":\"13351\",\"coord\":[-73.832828,40.759...</td>\n",
  445. " <td>[{\"date\":{\"$date\":1403308800000},\"grade\":\"B\",\"...</td>\n",
  446. " </tr>\n",
  447. " <tr>\n",
  448. " <th>25340</th>\n",
  449. " <td>Bronx</td>\n",
  450. " <td>Bangladeshi</td>\n",
  451. " <td>Mehman Sweets Restaurant</td>\n",
  452. " <td>41647098</td>\n",
  453. " <td>{\"building\":\"1445\",\"coord\":[-73.8549994,40.835...</td>\n",
  454. " <td>[{\"date\":{\"$date\":1406592000000},\"grade\":\"Z\",\"...</td>\n",
  455. " </tr>\n",
  456. " <tr>\n",
  457. " <th>25341</th>\n",
  458. " <td>Queens</td>\n",
  459. " <td>Mexican</td>\n",
  460. " <td>Stephanie'S Mexican Bakery</td>\n",
  461. " <td>41647129</td>\n",
  462. " <td>{\"building\":\"37-56\",\"coord\":[-73.860018,40.752...</td>\n",
  463. " <td>[{\"date\":{\"$date\":1408406400000},\"grade\":\"A\",\"...</td>\n",
  464. " </tr>\n",
  465. " <tr>\n",
  466. " <th>25342</th>\n",
  467. " <td>Bronx</td>\n",
  468. " <td>Bakery</td>\n",
  469. " <td>Bibbies Bakery</td>\n",
  470. " <td>41647169</td>\n",
  471. " <td>{\"building\":\"262\",\"coord\":[-73.9111954,40.8615...</td>\n",
  472. " <td>[{\"date\":{\"$date\":1399507200000},\"grade\":\"A\",\"...</td>\n",
  473. " </tr>\n",
  474. " <tr>\n",
  475. " <th>25343</th>\n",
  476. " <td>Manhattan</td>\n",
  477. " <td>Thai</td>\n",
  478. " <td>Jaiya Thai & Oriental Restaurant</td>\n",
  479. " <td>41647176</td>\n",
  480. " <td>{\"building\":\"1553\",\"coord\":[-73.954548,40.7745...</td>\n",
  481. " <td>[{\"date\":{\"$date\":1414540800000},\"grade\":\"A\",\"...</td>\n",
  482. " </tr>\n",
  483. " <tr>\n",
  484. " <th>25344</th>\n",
  485. " <td>Manhattan</td>\n",
  486. " <td>Chinese</td>\n",
  487. " <td>China Wok</td>\n",
  488. " <td>41647181</td>\n",
  489. " <td>{\"building\":\"199\",\"coord\":[-73.9831015,40.7228...</td>\n",
  490. " <td>[{\"date\":{\"$date\":1408060800000},\"grade\":\"B\",\"...</td>\n",
  491. " </tr>\n",
  492. " <tr>\n",
  493. " <th>25345</th>\n",
  494. " <td>Queens</td>\n",
  495. " <td>Chinese</td>\n",
  496. " <td>Xing Xing Chinese Restaurant</td>\n",
  497. " <td>41647183</td>\n",
  498. " <td>{\"building\":\"9712\",\"coord\":[-73.8194803,40.584...</td>\n",
  499. " <td>[{\"date\":{\"$date\":1398729600000},\"grade\":\"A\",\"...</td>\n",
  500. " </tr>\n",
  501. " <tr>\n",
  502. " <th>25346</th>\n",
  503. " <td>Queens</td>\n",
  504. " <td>American</td>\n",
  505. " <td>Packard Cafe</td>\n",
  506. " <td>41647192</td>\n",
  507. " <td>{\"building\":\"4134\",\"coord\":[-73.9400398,40.751...</td>\n",
  508. " <td>[{\"date\":{\"$date\":1421193600000},\"grade\":\"A\",\"...</td>\n",
  509. " </tr>\n",
  510. " <tr>\n",
  511. " <th>25347</th>\n",
  512. " <td>Queens</td>\n",
  513. " <td>Pizza</td>\n",
  514. " <td>Springfield & La Bari Pizzeria</td>\n",
  515. " <td>41647210</td>\n",
  516. " <td>{\"building\":\"136-13\",\"coord\":[-73.763352,40.67...</td>\n",
  517. " <td>[{\"date\":{\"$date\":1419984000000},\"grade\":\"A\",\"...</td>\n",
  518. " </tr>\n",
  519. " <tr>\n",
  520. " <th>25348</th>\n",
  521. " <td>Queens</td>\n",
  522. " <td>Caribbean</td>\n",
  523. " <td>Dee'S Catering Services</td>\n",
  524. " <td>41647221</td>\n",
  525. " <td>{\"building\":\"217-15\",\"coord\":[-73.737423999999...</td>\n",
  526. " <td>[{\"date\":{\"$date\":1401840000000},\"grade\":\"A\",\"...</td>\n",
  527. " </tr>\n",
  528. " <tr>\n",
  529. " <th>25349</th>\n",
  530. " <td>Manhattan</td>\n",
  531. " <td>Asian</td>\n",
  532. " <td>Jack'S Sliders And Sushi</td>\n",
  533. " <td>41647241</td>\n",
  534. " <td>{\"building\":\"171\",\"coord\":[-73.98581899999999,...</td>\n",
  535. " <td>[{\"date\":{\"$date\":1417564800000},\"grade\":\"B\",\"...</td>\n",
  536. " </tr>\n",
  537. " <tr>\n",
  538. " <th>25350</th>\n",
  539. " <td>Brooklyn</td>\n",
  540. " <td>Chinese</td>\n",
  541. " <td>New Ming Fat Chinese Restaurant</td>\n",
  542. " <td>41647292</td>\n",
  543. " <td>{\"building\":\"1155\",\"coord\":[-73.8753401,40.672...</td>\n",
  544. " <td>[{\"date\":{\"$date\":1394496000000},\"grade\":\"A\",\"...</td>\n",
  545. " </tr>\n",
  546. " <tr>\n",
  547. " <th>25351</th>\n",
  548. " <td>Queens</td>\n",
  549. " <td>Chinese</td>\n",
  550. " <td>Noodle House</td>\n",
  551. " <td>41647360</td>\n",
  552. " <td>{\"building\":\"56-09\",\"coord\":[-73.7315557,40.76...</td>\n",
  553. " <td>[{\"date\":{\"$date\":1404259200000},\"grade\":\"A\",\"...</td>\n",
  554. " </tr>\n",
  555. " <tr>\n",
  556. " <th>25352</th>\n",
  557. " <td>Brooklyn</td>\n",
  558. " <td>Middle Eastern</td>\n",
  559. " <td>Bahary Fish Market</td>\n",
  560. " <td>41647370</td>\n",
  561. " <td>{\"building\":\"484\",\"coord\":[-74.0212854,40.6334...</td>\n",
  562. " <td>[{\"date\":{\"$date\":1401840000000},\"grade\":\"A\",\"...</td>\n",
  563. " </tr>\n",
  564. " <tr>\n",
  565. " <th>25353</th>\n",
  566. " <td>Queens</td>\n",
  567. " <td>American</td>\n",
  568. " <td>The Tin House Tavern</td>\n",
  569. " <td>41647380</td>\n",
  570. " <td>{\"building\":\"195-02\",\"coord\":[-73.785758,40.75...</td>\n",
  571. " <td>[{\"date\":{\"$date\":1410134400000},\"grade\":\"A\",\"...</td>\n",
  572. " </tr>\n",
  573. " <tr>\n",
  574. " <th>25354</th>\n",
  575. " <td>Staten Island</td>\n",
  576. " <td>Pizza</td>\n",
  577. " <td>Ambrosino'S Ii</td>\n",
  578. " <td>41647384</td>\n",
  579. " <td>{\"building\":\"6410\",\"coord\":[-74.2150624,40.521...</td>\n",
  580. " <td>[{\"date\":{\"$date\":1409616000000},\"grade\":\"A\",\"...</td>\n",
  581. " </tr>\n",
  582. " <tr>\n",
  583. " <th>25355</th>\n",
  584. " <td>Bronx</td>\n",
  585. " <td>Soul Food</td>\n",
  586. " <td>Bruce'S Fish And Chips</td>\n",
  587. " <td>41647392</td>\n",
  588. " <td>{\"building\":\"500\",\"coord\":[-73.890768,40.85709...</td>\n",
  589. " <td>[{\"date\":{\"$date\":1403568000000},\"grade\":\"A\",\"...</td>\n",
  590. " </tr>\n",
  591. " <tr>\n",
  592. " <th>25356</th>\n",
  593. " <td>Manhattan</td>\n",
  594. " <td>Café/Coffee/Tea</td>\n",
  595. " <td>Coffee Bean Tea & Leaf</td>\n",
  596. " <td>41647399</td>\n",
  597. " <td>{\"building\":\"2169\",\"coord\":[-73.981231,40.7822...</td>\n",
  598. " <td>[{\"date\":{\"$date\":1406592000000},\"grade\":\"A\",\"...</td>\n",
  599. " </tr>\n",
  600. " <tr>\n",
  601. " <th>25357</th>\n",
  602. " <td>Manhattan</td>\n",
  603. " <td>Ice Cream, Gelato, Yogurt, Ices</td>\n",
  604. " <td>Gelato Ti Amo</td>\n",
  605. " <td>41647482</td>\n",
  606. " <td>{\"building\":\"68\",\"coord\":[-73.9892179,40.72594...</td>\n",
  607. " <td>[{\"date\":{\"$date\":1403913600000},\"grade\":\"A\",\"...</td>\n",
  608. " </tr>\n",
  609. " <tr>\n",
  610. " <th>25358</th>\n",
  611. " <td>Queens</td>\n",
  612. " <td>Caribbean</td>\n",
  613. " <td>Rockaway Roti Shop</td>\n",
  614. " <td>41647521</td>\n",
  615. " <td>{\"building\":\"12221\",\"coord\":[-73.8032425999999...</td>\n",
  616. " <td>[{\"date\":{\"$date\":1418428800000},\"grade\":\"A\",\"...</td>\n",
  617. " </tr>\n",
  618. " </tbody>\n",
  619. "</table>\n",
  620. "<p>25359 rows × 6 columns</p>\n",
  621. "</div>"
  622. ],
  623. "text/plain": [
  624. " borough cuisine \\\n",
  625. "0 Bronx Bakery \n",
  626. "1 Brooklyn Hamburgers \n",
  627. "2 Manhattan Irish \n",
  628. "3 Brooklyn American \n",
  629. "4 Queens Jewish/Kosher \n",
  630. "5 Queens American \n",
  631. "6 Staten Island Jewish/Kosher \n",
  632. "7 Brooklyn Delicatessen \n",
  633. "8 Brooklyn American \n",
  634. "9 Brooklyn Ice Cream, Gelato, Yogurt, Ices \n",
  635. "10 Bronx American \n",
  636. "11 Brooklyn American \n",
  637. "12 Brooklyn Chinese \n",
  638. "13 Manhattan American \n",
  639. "14 Brooklyn Jewish/Kosher \n",
  640. "15 Brooklyn Ice Cream, Gelato, Yogurt, Ices \n",
  641. "16 Queens Ice Cream, Gelato, Yogurt, Ices \n",
  642. "17 Brooklyn Delicatessen \n",
  643. "18 Manhattan American \n",
  644. "19 Brooklyn American \n",
  645. "20 Queens Delicatessen \n",
  646. "21 Manhattan Delicatessen \n",
  647. "22 Queens Delicatessen \n",
  648. "23 Manhattan Chicken \n",
  649. "24 Manhattan American \n",
  650. "25 Manhattan American \n",
  651. "26 Brooklyn Hamburgers \n",
  652. "27 Queens Chinese \n",
  653. "28 Manhattan Turkish \n",
  654. "29 Brooklyn Caribbean \n",
  655. "... ... ... \n",
  656. "25329 Queens Mexican \n",
  657. "25330 Brooklyn Caribbean \n",
  658. "25331 Brooklyn American \n",
  659. "25332 Manhattan Chinese \n",
  660. "25333 Manhattan Caribbean \n",
  661. "25334 Manhattan Delicatessen \n",
  662. "25335 Queens Caribbean \n",
  663. "25336 Manhattan American \n",
  664. "25337 Manhattan American \n",
  665. "25338 Queens German \n",
  666. "25339 Queens Chinese \n",
  667. "25340 Bronx Bangladeshi \n",
  668. "25341 Queens Mexican \n",
  669. "25342 Bronx Bakery \n",
  670. "25343 Manhattan Thai \n",
  671. "25344 Manhattan Chinese \n",
  672. "25345 Queens Chinese \n",
  673. "25346 Queens American \n",
  674. "25347 Queens Pizza \n",
  675. "25348 Queens Caribbean \n",
  676. "25349 Manhattan Asian \n",
  677. "25350 Brooklyn Chinese \n",
  678. "25351 Queens Chinese \n",
  679. "25352 Brooklyn Middle Eastern \n",
  680. "25353 Queens American \n",
  681. "25354 Staten Island Pizza \n",
  682. "25355 Bronx Soul Food \n",
  683. "25356 Manhattan Café/Coffee/Tea \n",
  684. "25357 Manhattan Ice Cream, Gelato, Yogurt, Ices \n",
  685. "25358 Queens Caribbean \n",
  686. "\n",
  687. " name restaurant_id \\\n",
  688. "0 Morris Park Bake Shop 30075445 \n",
  689. "1 Wendy'S 30112340 \n",
  690. "2 Dj Reynolds Pub And Restaurant 30191841 \n",
  691. "3 Riviera Caterer 40356018 \n",
  692. "4 Tov Kosher Kitchen 40356068 \n",
  693. "5 Brunos On The Boulevard 40356151 \n",
  694. "6 Kosher Island 40356442 \n",
  695. "7 Wilken'S Fine Food 40356483 \n",
  696. "8 Regina Caterers 40356649 \n",
  697. "9 Taste The Tropics Ice Cream 40356731 \n",
  698. "10 Wild Asia 40357217 \n",
  699. "11 C & C Catering Service 40357437 \n",
  700. "12 May May Kitchen 40358429 \n",
  701. "13 1 East 66Th Street Kitchen 40359480 \n",
  702. "14 Seuda Foods 40360045 \n",
  703. "15 Carvel Ice Cream 40360076 \n",
  704. "16 Carvel Ice Cream 40361322 \n",
  705. "17 Nordic Delicacies 40361390 \n",
  706. "18 Glorious Food 40361521 \n",
  707. "19 The Movable Feast 40361606 \n",
  708. "20 Sal'S Deli 40361618 \n",
  709. "21 Bully'S Deli 40361708 \n",
  710. "22 Steve Chu'S Deli & Grocery 40361998 \n",
  711. "23 Harriet'S Kitchen 40362098 \n",
  712. "24 P & S Deli Grocery 40362264 \n",
  713. "25 Angelika Film Center 40362274 \n",
  714. "26 White Castle 40362344 \n",
  715. "27 Ho Mei Restaurant 40362432 \n",
  716. "28 The Country Cafe 40362715 \n",
  717. "29 Shashemene Int'L Restaura 40362869 \n",
  718. "... ... ... \n",
  719. "25329 Bella'S Place 41646934 \n",
  720. "25330 Perfect Touch Cuisine Ii 41646958 \n",
  721. "25331 Del Rio Diner 41646963 \n",
  722. "25332 Fay Da Bakery 41646967 \n",
  723. "25333 Jahlookova 41646976 \n",
  724. "25334 Merci Market 41646979 \n",
  725. "25335 Meat Veggies & Pasta Restaurant 41647006 \n",
  726. "25336 Toshi'S Living Room 41647012 \n",
  727. "25337 Five Lamps Tavern 41647017 \n",
  728. "25338 Max 41647039 \n",
  729. "25339 Liang'S Kitchen Flushing Restaurant 41647062 \n",
  730. "25340 Mehman Sweets Restaurant 41647098 \n",
  731. "25341 Stephanie'S Mexican Bakery 41647129 \n",
  732. "25342 Bibbies Bakery 41647169 \n",
  733. "25343 Jaiya Thai & Oriental Restaurant 41647176 \n",
  734. "25344 China Wok 41647181 \n",
  735. "25345 Xing Xing Chinese Restaurant 41647183 \n",
  736. "25346 Packard Cafe 41647192 \n",
  737. "25347 Springfield & La Bari Pizzeria 41647210 \n",
  738. "25348 Dee'S Catering Services 41647221 \n",
  739. "25349 Jack'S Sliders And Sushi 41647241 \n",
  740. "25350 New Ming Fat Chinese Restaurant 41647292 \n",
  741. "25351 Noodle House 41647360 \n",
  742. "25352 Bahary Fish Market 41647370 \n",
  743. "25353 The Tin House Tavern 41647380 \n",
  744. "25354 Ambrosino'S Ii 41647384 \n",
  745. "25355 Bruce'S Fish And Chips 41647392 \n",
  746. "25356 Coffee Bean Tea & Leaf 41647399 \n",
  747. "25357 Gelato Ti Amo 41647482 \n",
  748. "25358 Rockaway Roti Shop 41647521 \n",
  749. "\n",
  750. " address_json \\\n",
  751. "0 {\"building\":\"1007\",\"coord\":[-73.856077,40.8484... \n",
  752. "1 {\"building\":\"469\",\"coord\":[-73.961704,40.66294... \n",
  753. "2 {\"building\":\"351\",\"coord\":[-73.98513559999999,... \n",
  754. "3 {\"building\":\"2780\",\"coord\":[-73.98241999999999... \n",
  755. "4 {\"building\":\"97-22\",\"coord\":[-73.8601152,40.73... \n",
  756. "5 {\"building\":\"8825\",\"coord\":[-73.8803827,40.764... \n",
  757. "6 {\"building\":\"2206\",\"coord\":[-74.1377286,40.611... \n",
  758. "7 {\"building\":\"7114\",\"coord\":[-73.9068506,40.619... \n",
  759. "8 {\"building\":\"6409\",\"coord\":[-74.00528899999999... \n",
  760. "9 {\"building\":\"1839\",\"coord\":[-73.9482609,40.640... \n",
  761. "10 {\"building\":\"2300\",\"coord\":[-73.8786113,40.850... \n",
  762. "11 {\"building\":\"7715\",\"coord\":[-73.9973325,40.611... \n",
  763. "12 {\"building\":\"1269\",\"coord\":[-73.871194,40.6730... \n",
  764. "13 {\"building\":\"1\",\"coord\":[-73.96926909999999,40... \n",
  765. "14 {\"building\":\"705\",\"coord\":[-73.9653967,40.6064... \n",
  766. "15 {\"building\":\"203\",\"coord\":[-73.97822040000001,... \n",
  767. "16 {\"building\":\"265-15\",\"coord\":[-73.7032601,40.7... \n",
  768. "17 {\"building\":\"6909\",\"coord\":[-74.0259567,40.635... \n",
  769. "18 {\"building\":\"522\",\"coord\":[-73.95171,40.767461... \n",
  770. "19 {\"building\":\"284\",\"coord\":[-73.9829239,40.6580... \n",
  771. "20 {\"building\":\"129-08\",\"coord\":[-73.839297,40.78... \n",
  772. "21 {\"building\":\"759\",\"coord\":[-73.9925306,40.7309... \n",
  773. "22 {\"building\":\"3406\",\"coord\":[-73.94024739999999... \n",
  774. "23 {\"building\":\"502\",\"coord\":[-73.976112,40.78671... \n",
  775. "24 {\"building\":\"730\",\"coord\":[-73.96805719999999,... \n",
  776. "25 {\"building\":\"18\",\"coord\":[-73.996984,40.72589]... \n",
  777. "26 {\"building\":\"531\",\"coord\":[-73.9634876,40.6940... \n",
  778. "27 {\"building\":\"103-05\",\"coord\":[-73.8642349,40.7... \n",
  779. "28 {\"building\":\"60\",\"coord\":[-74.0085357,40.70620... \n",
  780. "29 {\"building\":\"195\",\"coord\":[-73.9246028,40.6522... \n",
  781. "... ... \n",
  782. "25329 {\"building\":\"87-77\",\"coord\":[-73.8093635,40.70... \n",
  783. "25330 {\"building\":\"1148\",\"coord\":[-73.9508029,40.659... \n",
  784. "25331 {\"building\":\"166\",\"coord\":[-73.98527659999999,... \n",
  785. "25332 {\"building\":\"321\",\"coord\":[-74.0062401,40.7397... \n",
  786. "25333 {\"building\":\"1962\",\"coord\":[-73.9405519,40.806... \n",
  787. "25334 {\"building\":\"350\",\"coord\":[-73.9922178,40.7579... \n",
  788. "25335 {\"building\":\"118-16\",\"coord\":[-73.819531,40.67... \n",
  789. "25336 {\"building\":\"9\",\"coord\":[-73.98931019999999,40... \n",
  790. "25337 {\"building\":\"2756\",\"coord\":[-73.9675441,40.800... \n",
  791. "25338 {\"building\":\"47-02\",\"coord\":[-73.918047,40.765... \n",
  792. "25339 {\"building\":\"13351\",\"coord\":[-73.832828,40.759... \n",
  793. "25340 {\"building\":\"1445\",\"coord\":[-73.8549994,40.835... \n",
  794. "25341 {\"building\":\"37-56\",\"coord\":[-73.860018,40.752... \n",
  795. "25342 {\"building\":\"262\",\"coord\":[-73.9111954,40.8615... \n",
  796. "25343 {\"building\":\"1553\",\"coord\":[-73.954548,40.7745... \n",
  797. "25344 {\"building\":\"199\",\"coord\":[-73.9831015,40.7228... \n",
  798. "25345 {\"building\":\"9712\",\"coord\":[-73.8194803,40.584... \n",
  799. "25346 {\"building\":\"4134\",\"coord\":[-73.9400398,40.751... \n",
  800. "25347 {\"building\":\"136-13\",\"coord\":[-73.763352,40.67... \n",
  801. "25348 {\"building\":\"217-15\",\"coord\":[-73.737423999999... \n",
  802. "25349 {\"building\":\"171\",\"coord\":[-73.98581899999999,... \n",
  803. "25350 {\"building\":\"1155\",\"coord\":[-73.8753401,40.672... \n",
  804. "25351 {\"building\":\"56-09\",\"coord\":[-73.7315557,40.76... \n",
  805. "25352 {\"building\":\"484\",\"coord\":[-74.0212854,40.6334... \n",
  806. "25353 {\"building\":\"195-02\",\"coord\":[-73.785758,40.75... \n",
  807. "25354 {\"building\":\"6410\",\"coord\":[-74.2150624,40.521... \n",
  808. "25355 {\"building\":\"500\",\"coord\":[-73.890768,40.85709... \n",
  809. "25356 {\"building\":\"2169\",\"coord\":[-73.981231,40.7822... \n",
  810. "25357 {\"building\":\"68\",\"coord\":[-73.9892179,40.72594... \n",
  811. "25358 {\"building\":\"12221\",\"coord\":[-73.8032425999999... \n",
  812. "\n",
  813. " grades_json \n",
  814. "0 [{\"date\":{\"$date\":1393804800000},\"grade\":\"A\",\"... \n",
  815. "1 [{\"date\":{\"$date\":1419897600000},\"grade\":\"A\",\"... \n",
  816. "2 [{\"date\":{\"$date\":1409961600000},\"grade\":\"A\",\"... \n",
  817. "3 [{\"date\":{\"$date\":1402358400000},\"grade\":\"A\",\"... \n",
  818. "4 [{\"date\":{\"$date\":1416787200000},\"grade\":\"Z\",\"... \n",
  819. "5 [{\"date\":{\"$date\":1416009600000},\"grade\":\"Z\",\"... \n",
  820. "6 [{\"date\":{\"$date\":1412553600000},\"grade\":\"A\",\"... \n",
  821. "7 [{\"date\":{\"$date\":1401321600000},\"grade\":\"A\",\"... \n",
  822. "8 [{\"date\":{\"$date\":1405641600000},\"grade\":\"A\",\"... \n",
  823. "9 [{\"date\":{\"$date\":1405296000000},\"grade\":\"A\",\"... \n",
  824. "10 [{\"date\":{\"$date\":1401235200000},\"grade\":\"A\",\"... \n",
  825. "11 [{\"date\":{\"$date\":1397606400000},\"grade\":\"A\",\"... \n",
  826. "12 [{\"date\":{\"$date\":1410825600000},\"grade\":\"B\",\"... \n",
  827. "13 [{\"date\":{\"$date\":1399420800000},\"grade\":\"A\",\"... \n",
  828. "14 [{\"date\":{\"$date\":1415577600000},\"grade\":\"A\",\"... \n",
  829. "15 [{\"date\":{\"$date\":1391990400000},\"grade\":\"A\",\"... \n",
  830. "16 [{\"date\":{\"$date\":1414454400000},\"grade\":\"A\",\"... \n",
  831. "17 [{\"date\":{\"$date\":1408579200000},\"grade\":\"A\",\"... \n",
  832. "18 [{\"date\":{\"$date\":1409616000000},\"grade\":\"A\",\"... \n",
  833. "19 [{\"date\":{\"$date\":1416355200000},\"grade\":\"A\",\"... \n",
  834. "20 [{\"date\":{\"$date\":1408147200000},\"grade\":\"A\",\"... \n",
  835. "21 [{\"date\":{\"$date\":1390262400000},\"grade\":\"A\",\"... \n",
  836. "22 [{\"date\":{\"$date\":1395187200000},\"grade\":\"A\",\"... \n",
  837. "23 [{\"date\":{\"$date\":1410739200000},\"grade\":\"A\",\"... \n",
  838. "24 [{\"date\":{\"$date\":1410480000000},\"grade\":\"B\",\"... \n",
  839. "25 [{\"date\":{\"$date\":1396483200000},\"grade\":\"A\",\"... \n",
  840. "26 [{\"date\":{\"$date\":1395100800000},\"grade\":\"A\",\"... \n",
  841. "27 [{\"date\":{\"$date\":1398038400000},\"grade\":\"A\",\"... \n",
  842. "28 [{\"date\":{\"$date\":1411689600000},\"grade\":\"A\",\"... \n",
  843. "29 [{\"date\":{\"$date\":1399939200000},\"grade\":\"A\",\"... \n",
  844. "... ... \n",
  845. "25329 [{\"date\":{\"$date\":1413417600000},\"grade\":\"Z\",\"... \n",
  846. "25330 [{\"date\":{\"$date\":1409270400000},\"grade\":\"B\",\"... \n",
  847. "25331 [{\"date\":{\"$date\":1397001600000},\"grade\":\"A\",\"... \n",
  848. "25332 [{\"date\":{\"$date\":1399852800000},\"grade\":\"A\",\"... \n",
  849. "25333 [{\"date\":{\"$date\":1416960000000},\"grade\":\"A\",\"... \n",
  850. "25334 [{\"date\":{\"$date\":1420588800000},\"grade\":\"Z\",\"... \n",
  851. "25335 [{\"date\":{\"$date\":1415577600000},\"grade\":\"A\",\"... \n",
  852. "25336 [{\"date\":{\"$date\":1415750400000},\"grade\":\"A\",\"... \n",
  853. "25337 [{\"date\":{\"$date\":1407283200000},\"grade\":\"C\",\"... \n",
  854. "25338 [{\"date\":{\"$date\":1416355200000},\"grade\":\"A\",\"... \n",
  855. "25339 [{\"date\":{\"$date\":1403308800000},\"grade\":\"B\",\"... \n",
  856. "25340 [{\"date\":{\"$date\":1406592000000},\"grade\":\"Z\",\"... \n",
  857. "25341 [{\"date\":{\"$date\":1408406400000},\"grade\":\"A\",\"... \n",
  858. "25342 [{\"date\":{\"$date\":1399507200000},\"grade\":\"A\",\"... \n",
  859. "25343 [{\"date\":{\"$date\":1414540800000},\"grade\":\"A\",\"... \n",
  860. "25344 [{\"date\":{\"$date\":1408060800000},\"grade\":\"B\",\"... \n",
  861. "25345 [{\"date\":{\"$date\":1398729600000},\"grade\":\"A\",\"... \n",
  862. "25346 [{\"date\":{\"$date\":1421193600000},\"grade\":\"A\",\"... \n",
  863. "25347 [{\"date\":{\"$date\":1419984000000},\"grade\":\"A\",\"... \n",
  864. "25348 [{\"date\":{\"$date\":1401840000000},\"grade\":\"A\",\"... \n",
  865. "25349 [{\"date\":{\"$date\":1417564800000},\"grade\":\"B\",\"... \n",
  866. "25350 [{\"date\":{\"$date\":1394496000000},\"grade\":\"A\",\"... \n",
  867. "25351 [{\"date\":{\"$date\":1404259200000},\"grade\":\"A\",\"... \n",
  868. "25352 [{\"date\":{\"$date\":1401840000000},\"grade\":\"A\",\"... \n",
  869. "25353 [{\"date\":{\"$date\":1410134400000},\"grade\":\"A\",\"... \n",
  870. "25354 [{\"date\":{\"$date\":1409616000000},\"grade\":\"A\",\"... \n",
  871. "25355 [{\"date\":{\"$date\":1403568000000},\"grade\":\"A\",\"... \n",
  872. "25356 [{\"date\":{\"$date\":1406592000000},\"grade\":\"A\",\"... \n",
  873. "25357 [{\"date\":{\"$date\":1403913600000},\"grade\":\"A\",\"... \n",
  874. "25358 [{\"date\":{\"$date\":1418428800000},\"grade\":\"A\",\"... \n",
  875. "\n",
  876. "[25359 rows x 6 columns]"
  877. ]
  878. },
  879. "execution_count": 3,
  880. "metadata": {},
  881. "output_type": "execute_result"
  882. }
  883. ],
  884. "source": [
  885. "url = \"jdbc:postgresql://localhost:5432/postgres\"\n",
  886. "properties = {\"user\": \"postgres\",\"password\": \"postgres\",\"driver\": \"org.postgresql.Driver\"}\n",
  887. "read_test = spark.read.jdbc(table=\"restaurant_from_df\", properties=properties, url=\"jdbc:postgresql://localhost:5432/postgres\")\n",
  888. "read_test.toPandas()"
  889. ]
  890. },
  891. {
  892. "cell_type": "code",
  893. "execution_count": 4,
  894. "metadata": {
  895. "collapsed": true
  896. },
  897. "outputs": [],
  898. "source": [
  899. "url = \"jdbc:postgresql://localhost:5432/postgres\"\n",
  900. "properties = {\"user\": \"postgres\",\"password\": \"postgres\",\"driver\": \"org.postgresql.Driver\"}\n",
  901. "read_test_with_query = spark.read.jdbc(table=\"(select *, address_json::json->'building' as building from restaurant_from_df) as t\", properties=properties, url=url)"
  902. ]
  903. },
  904. {
  905. "cell_type": "code",
  906. "execution_count": 5,
  907. "metadata": {},
  908. "outputs": [
  909. {
  910. "data": {
  911. "text/html": [
  912. "<div>\n",
  913. "<style>\n",
  914. " .dataframe thead tr:only-child th {\n",
  915. " text-align: right;\n",
  916. " }\n",
  917. "\n",
  918. " .dataframe thead th {\n",
  919. " text-align: left;\n",
  920. " }\n",
  921. "\n",
  922. " .dataframe tbody tr th {\n",
  923. " vertical-align: top;\n",
  924. " }\n",
  925. "</style>\n",
  926. "<table border=\"1\" class=\"dataframe\">\n",
  927. " <thead>\n",
  928. " <tr style=\"text-align: right;\">\n",
  929. " <th></th>\n",
  930. " <th>borough</th>\n",
  931. " <th>cuisine</th>\n",
  932. " <th>name</th>\n",
  933. " <th>restaurant_id</th>\n",
  934. " <th>address_json</th>\n",
  935. " <th>grades_json</th>\n",
  936. " <th>building</th>\n",
  937. " </tr>\n",
  938. " </thead>\n",
  939. " <tbody>\n",
  940. " <tr>\n",
  941. " <th>0</th>\n",
  942. " <td>Bronx</td>\n",
  943. " <td>Bakery</td>\n",
  944. " <td>Morris Park Bake Shop</td>\n",
  945. " <td>30075445</td>\n",
  946. " <td>{\"building\":\"1007\",\"coord\":[-73.856077,40.8484...</td>\n",
  947. " <td>[{\"date\":{\"$date\":1393804800000},\"grade\":\"A\",\"...</td>\n",
  948. " <td>\"1007\"</td>\n",
  949. " </tr>\n",
  950. " <tr>\n",
  951. " <th>1</th>\n",
  952. " <td>Brooklyn</td>\n",
  953. " <td>Hamburgers</td>\n",
  954. " <td>Wendy'S</td>\n",
  955. " <td>30112340</td>\n",
  956. " <td>{\"building\":\"469\",\"coord\":[-73.961704,40.66294...</td>\n",
  957. " <td>[{\"date\":{\"$date\":1419897600000},\"grade\":\"A\",\"...</td>\n",
  958. " <td>\"469\"</td>\n",
  959. " </tr>\n",
  960. " <tr>\n",
  961. " <th>2</th>\n",
  962. " <td>Manhattan</td>\n",
  963. " <td>Irish</td>\n",
  964. " <td>Dj Reynolds Pub And Restaurant</td>\n",
  965. " <td>30191841</td>\n",
  966. " <td>{\"building\":\"351\",\"coord\":[-73.98513559999999,...</td>\n",
  967. " <td>[{\"date\":{\"$date\":1409961600000},\"grade\":\"A\",\"...</td>\n",
  968. " <td>\"351\"</td>\n",
  969. " </tr>\n",
  970. " <tr>\n",
  971. " <th>3</th>\n",
  972. " <td>Brooklyn</td>\n",
  973. " <td>American</td>\n",
  974. " <td>Riviera Caterer</td>\n",
  975. " <td>40356018</td>\n",
  976. " <td>{\"building\":\"2780\",\"coord\":[-73.98241999999999...</td>\n",
  977. " <td>[{\"date\":{\"$date\":1402358400000},\"grade\":\"A\",\"...</td>\n",
  978. " <td>\"2780\"</td>\n",
  979. " </tr>\n",
  980. " <tr>\n",
  981. " <th>4</th>\n",
  982. " <td>Queens</td>\n",
  983. " <td>Jewish/Kosher</td>\n",
  984. " <td>Tov Kosher Kitchen</td>\n",
  985. " <td>40356068</td>\n",
  986. " <td>{\"building\":\"97-22\",\"coord\":[-73.8601152,40.73...</td>\n",
  987. " <td>[{\"date\":{\"$date\":1416787200000},\"grade\":\"Z\",\"...</td>\n",
  988. " <td>\"97-22\"</td>\n",
  989. " </tr>\n",
  990. " <tr>\n",
  991. " <th>5</th>\n",
  992. " <td>Queens</td>\n",
  993. " <td>American</td>\n",
  994. " <td>Brunos On The Boulevard</td>\n",
  995. " <td>40356151</td>\n",
  996. " <td>{\"building\":\"8825\",\"coord\":[-73.8803827,40.764...</td>\n",
  997. " <td>[{\"date\":{\"$date\":1416009600000},\"grade\":\"Z\",\"...</td>\n",
  998. " <td>\"8825\"</td>\n",
  999. " </tr>\n",
  1000. " <tr>\n",
  1001. " <th>6</th>\n",
  1002. " <td>Staten Island</td>\n",
  1003. " <td>Jewish/Kosher</td>\n",
  1004. " <td>Kosher Island</td>\n",
  1005. " <td>40356442</td>\n",
  1006. " <td>{\"building\":\"2206\",\"coord\":[-74.1377286,40.611...</td>\n",
  1007. " <td>[{\"date\":{\"$date\":1412553600000},\"grade\":\"A\",\"...</td>\n",
  1008. " <td>\"2206\"</td>\n",
  1009. " </tr>\n",
  1010. " <tr>\n",
  1011. " <th>7</th>\n",
  1012. " <td>Brooklyn</td>\n",
  1013. " <td>Delicatessen</td>\n",
  1014. " <td>Wilken'S Fine Food</td>\n",
  1015. " <td>40356483</td>\n",
  1016. " <td>{\"building\":\"7114\",\"coord\":[-73.9068506,40.619...</td>\n",
  1017. " <td>[{\"date\":{\"$date\":1401321600000},\"grade\":\"A\",\"...</td>\n",
  1018. " <td>\"7114\"</td>\n",
  1019. " </tr>\n",
  1020. " <tr>\n",
  1021. " <th>8</th>\n",
  1022. " <td>Brooklyn</td>\n",
  1023. " <td>American</td>\n",
  1024. " <td>Regina Caterers</td>\n",
  1025. " <td>40356649</td>\n",
  1026. " <td>{\"building\":\"6409\",\"coord\":[-74.00528899999999...</td>\n",
  1027. " <td>[{\"date\":{\"$date\":1405641600000},\"grade\":\"A\",\"...</td>\n",
  1028. " <td>\"6409\"</td>\n",
  1029. " </tr>\n",
  1030. " <tr>\n",
  1031. " <th>9</th>\n",
  1032. " <td>Brooklyn</td>\n",
  1033. " <td>Ice Cream, Gelato, Yogurt, Ices</td>\n",
  1034. " <td>Taste The Tropics Ice Cream</td>\n",
  1035. " <td>40356731</td>\n",
  1036. " <td>{\"building\":\"1839\",\"coord\":[-73.9482609,40.640...</td>\n",
  1037. " <td>[{\"date\":{\"$date\":1405296000000},\"grade\":\"A\",\"...</td>\n",
  1038. " <td>\"1839\"</td>\n",
  1039. " </tr>\n",
  1040. " <tr>\n",
  1041. " <th>10</th>\n",
  1042. " <td>Bronx</td>\n",
  1043. " <td>American</td>\n",
  1044. " <td>Wild Asia</td>\n",
  1045. " <td>40357217</td>\n",
  1046. " <td>{\"building\":\"2300\",\"coord\":[-73.8786113,40.850...</td>\n",
  1047. " <td>[{\"date\":{\"$date\":1401235200000},\"grade\":\"A\",\"...</td>\n",
  1048. " <td>\"2300\"</td>\n",
  1049. " </tr>\n",
  1050. " <tr>\n",
  1051. " <th>11</th>\n",
  1052. " <td>Brooklyn</td>\n",
  1053. " <td>American</td>\n",
  1054. " <td>C & C Catering Service</td>\n",
  1055. " <td>40357437</td>\n",
  1056. " <td>{\"building\":\"7715\",\"coord\":[-73.9973325,40.611...</td>\n",
  1057. " <td>[{\"date\":{\"$date\":1397606400000},\"grade\":\"A\",\"...</td>\n",
  1058. " <td>\"7715\"</td>\n",
  1059. " </tr>\n",
  1060. " <tr>\n",
  1061. " <th>12</th>\n",
  1062. " <td>Brooklyn</td>\n",
  1063. " <td>Chinese</td>\n",
  1064. " <td>May May Kitchen</td>\n",
  1065. " <td>40358429</td>\n",
  1066. " <td>{\"building\":\"1269\",\"coord\":[-73.871194,40.6730...</td>\n",
  1067. " <td>[{\"date\":{\"$date\":1410825600000},\"grade\":\"B\",\"...</td>\n",
  1068. " <td>\"1269\"</td>\n",
  1069. " </tr>\n",
  1070. " <tr>\n",
  1071. " <th>13</th>\n",
  1072. " <td>Manhattan</td>\n",
  1073. " <td>American</td>\n",
  1074. " <td>1 East 66Th Street Kitchen</td>\n",
  1075. " <td>40359480</td>\n",
  1076. " <td>{\"building\":\"1\",\"coord\":[-73.96926909999999,40...</td>\n",
  1077. " <td>[{\"date\":{\"$date\":1399420800000},\"grade\":\"A\",\"...</td>\n",
  1078. " <td>\"1\"</td>\n",
  1079. " </tr>\n",
  1080. " <tr>\n",
  1081. " <th>14</th>\n",
  1082. " <td>Brooklyn</td>\n",
  1083. " <td>Jewish/Kosher</td>\n",
  1084. " <td>Seuda Foods</td>\n",
  1085. " <td>40360045</td>\n",
  1086. " <td>{\"building\":\"705\",\"coord\":[-73.9653967,40.6064...</td>\n",
  1087. " <td>[{\"date\":{\"$date\":1415577600000},\"grade\":\"A\",\"...</td>\n",
  1088. " <td>\"705\"</td>\n",
  1089. " </tr>\n",
  1090. " <tr>\n",
  1091. " <th>15</th>\n",
  1092. " <td>Brooklyn</td>\n",
  1093. " <td>Ice Cream, Gelato, Yogurt, Ices</td>\n",
  1094. " <td>Carvel Ice Cream</td>\n",
  1095. " <td>40360076</td>\n",
  1096. " <td>{\"building\":\"203\",\"coord\":[-73.97822040000001,...</td>\n",
  1097. " <td>[{\"date\":{\"$date\":1391990400000},\"grade\":\"A\",\"...</td>\n",
  1098. " <td>\"203\"</td>\n",
  1099. " </tr>\n",
  1100. " <tr>\n",
  1101. " <th>16</th>\n",
  1102. " <td>Queens</td>\n",
  1103. " <td>Ice Cream, Gelato, Yogurt, Ices</td>\n",
  1104. " <td>Carvel Ice Cream</td>\n",
  1105. " <td>40361322</td>\n",
  1106. " <td>{\"building\":\"265-15\",\"coord\":[-73.7032601,40.7...</td>\n",
  1107. " <td>[{\"date\":{\"$date\":1414454400000},\"grade\":\"A\",\"...</td>\n",
  1108. " <td>\"265-15\"</td>\n",
  1109. " </tr>\n",
  1110. " <tr>\n",
  1111. " <th>17</th>\n",
  1112. " <td>Brooklyn</td>\n",
  1113. " <td>Delicatessen</td>\n",
  1114. " <td>Nordic Delicacies</td>\n",
  1115. " <td>40361390</td>\n",
  1116. " <td>{\"building\":\"6909\",\"coord\":[-74.0259567,40.635...</td>\n",
  1117. " <td>[{\"date\":{\"$date\":1408579200000},\"grade\":\"A\",\"...</td>\n",
  1118. " <td>\"6909\"</td>\n",
  1119. " </tr>\n",
  1120. " <tr>\n",
  1121. " <th>18</th>\n",
  1122. " <td>Manhattan</td>\n",
  1123. " <td>American</td>\n",
  1124. " <td>Glorious Food</td>\n",
  1125. " <td>40361521</td>\n",
  1126. " <td>{\"building\":\"522\",\"coord\":[-73.95171,40.767461...</td>\n",
  1127. " <td>[{\"date\":{\"$date\":1409616000000},\"grade\":\"A\",\"...</td>\n",
  1128. " <td>\"522\"</td>\n",
  1129. " </tr>\n",
  1130. " <tr>\n",
  1131. " <th>19</th>\n",
  1132. " <td>Brooklyn</td>\n",
  1133. " <td>American</td>\n",
  1134. " <td>The Movable Feast</td>\n",
  1135. " <td>40361606</td>\n",
  1136. " <td>{\"building\":\"284\",\"coord\":[-73.9829239,40.6580...</td>\n",
  1137. " <td>[{\"date\":{\"$date\":1416355200000},\"grade\":\"A\",\"...</td>\n",
  1138. " <td>\"284\"</td>\n",
  1139. " </tr>\n",
  1140. " <tr>\n",
  1141. " <th>20</th>\n",
  1142. " <td>Queens</td>\n",
  1143. " <td>Delicatessen</td>\n",
  1144. " <td>Sal'S Deli</td>\n",
  1145. " <td>40361618</td>\n",
  1146. " <td>{\"building\":\"129-08\",\"coord\":[-73.839297,40.78...</td>\n",
  1147. " <td>[{\"date\":{\"$date\":1408147200000},\"grade\":\"A\",\"...</td>\n",
  1148. " <td>\"129-08\"</td>\n",
  1149. " </tr>\n",
  1150. " <tr>\n",
  1151. " <th>21</th>\n",
  1152. " <td>Manhattan</td>\n",
  1153. " <td>Delicatessen</td>\n",
  1154. " <td>Bully'S Deli</td>\n",
  1155. " <td>40361708</td>\n",
  1156. " <td>{\"building\":\"759\",\"coord\":[-73.9925306,40.7309...</td>\n",
  1157. " <td>[{\"date\":{\"$date\":1390262400000},\"grade\":\"A\",\"...</td>\n",
  1158. " <td>\"759\"</td>\n",
  1159. " </tr>\n",
  1160. " <tr>\n",
  1161. " <th>22</th>\n",
  1162. " <td>Queens</td>\n",
  1163. " <td>Delicatessen</td>\n",
  1164. " <td>Steve Chu'S Deli & Grocery</td>\n",
  1165. " <td>40361998</td>\n",
  1166. " <td>{\"building\":\"3406\",\"coord\":[-73.94024739999999...</td>\n",
  1167. " <td>[{\"date\":{\"$date\":1395187200000},\"grade\":\"A\",\"...</td>\n",
  1168. " <td>\"3406\"</td>\n",
  1169. " </tr>\n",
  1170. " <tr>\n",
  1171. " <th>23</th>\n",
  1172. " <td>Manhattan</td>\n",
  1173. " <td>Chicken</td>\n",
  1174. " <td>Harriet'S Kitchen</td>\n",
  1175. " <td>40362098</td>\n",
  1176. " <td>{\"building\":\"502\",\"coord\":[-73.976112,40.78671...</td>\n",
  1177. " <td>[{\"date\":{\"$date\":1410739200000},\"grade\":\"A\",\"...</td>\n",
  1178. " <td>\"502\"</td>\n",
  1179. " </tr>\n",
  1180. " <tr>\n",
  1181. " <th>24</th>\n",
  1182. " <td>Manhattan</td>\n",
  1183. " <td>American</td>\n",
  1184. " <td>P & S Deli Grocery</td>\n",
  1185. " <td>40362264</td>\n",
  1186. " <td>{\"building\":\"730\",\"coord\":[-73.96805719999999,...</td>\n",
  1187. " <td>[{\"date\":{\"$date\":1410480000000},\"grade\":\"B\",\"...</td>\n",
  1188. " <td>\"730\"</td>\n",
  1189. " </tr>\n",
  1190. " <tr>\n",
  1191. " <th>25</th>\n",
  1192. " <td>Manhattan</td>\n",
  1193. " <td>American</td>\n",
  1194. " <td>Angelika Film Center</td>\n",
  1195. " <td>40362274</td>\n",
  1196. " <td>{\"building\":\"18\",\"coord\":[-73.996984,40.72589]...</td>\n",
  1197. " <td>[{\"date\":{\"$date\":1396483200000},\"grade\":\"A\",\"...</td>\n",
  1198. " <td>\"18\"</td>\n",
  1199. " </tr>\n",
  1200. " <tr>\n",
  1201. " <th>26</th>\n",
  1202. " <td>Brooklyn</td>\n",
  1203. " <td>Hamburgers</td>\n",
  1204. " <td>White Castle</td>\n",
  1205. " <td>40362344</td>\n",
  1206. " <td>{\"building\":\"531\",\"coord\":[-73.9634876,40.6940...</td>\n",
  1207. " <td>[{\"date\":{\"$date\":1395100800000},\"grade\":\"A\",\"...</td>\n",
  1208. " <td>\"531\"</td>\n",
  1209. " </tr>\n",
  1210. " <tr>\n",
  1211. " <th>27</th>\n",
  1212. " <td>Queens</td>\n",
  1213. " <td>Chinese</td>\n",
  1214. " <td>Ho Mei Restaurant</td>\n",
  1215. " <td>40362432</td>\n",
  1216. " <td>{\"building\":\"103-05\",\"coord\":[-73.8642349,40.7...</td>\n",
  1217. " <td>[{\"date\":{\"$date\":1398038400000},\"grade\":\"A\",\"...</td>\n",
  1218. " <td>\"103-05\"</td>\n",
  1219. " </tr>\n",
  1220. " <tr>\n",
  1221. " <th>28</th>\n",
  1222. " <td>Manhattan</td>\n",
  1223. " <td>Turkish</td>\n",
  1224. " <td>The Country Cafe</td>\n",
  1225. " <td>40362715</td>\n",
  1226. " <td>{\"building\":\"60\",\"coord\":[-74.0085357,40.70620...</td>\n",
  1227. " <td>[{\"date\":{\"$date\":1411689600000},\"grade\":\"A\",\"...</td>\n",
  1228. " <td>\"60\"</td>\n",
  1229. " </tr>\n",
  1230. " <tr>\n",
  1231. " <th>29</th>\n",
  1232. " <td>Brooklyn</td>\n",
  1233. " <td>Caribbean</td>\n",
  1234. " <td>Shashemene Int'L Restaura</td>\n",
  1235. " <td>40362869</td>\n",
  1236. " <td>{\"building\":\"195\",\"coord\":[-73.9246028,40.6522...</td>\n",
  1237. " <td>[{\"date\":{\"$date\":1399939200000},\"grade\":\"A\",\"...</td>\n",
  1238. " <td>\"195\"</td>\n",
  1239. " </tr>\n",
  1240. " <tr>\n",
  1241. " <th>...</th>\n",
  1242. " <td>...</td>\n",
  1243. " <td>...</td>\n",
  1244. " <td>...</td>\n",
  1245. " <td>...</td>\n",
  1246. " <td>...</td>\n",
  1247. " <td>...</td>\n",
  1248. " <td>...</td>\n",
  1249. " </tr>\n",
  1250. " <tr>\n",
  1251. " <th>25329</th>\n",
  1252. " <td>Queens</td>\n",
  1253. " <td>Mexican</td>\n",
  1254. " <td>Bella'S Place</td>\n",
  1255. " <td>41646934</td>\n",
  1256. " <td>{\"building\":\"87-77\",\"coord\":[-73.8093635,40.70...</td>\n",
  1257. " <td>[{\"date\":{\"$date\":1413417600000},\"grade\":\"Z\",\"...</td>\n",
  1258. " <td>\"87-77\"</td>\n",
  1259. " </tr>\n",
  1260. " <tr>\n",
  1261. " <th>25330</th>\n",
  1262. " <td>Brooklyn</td>\n",
  1263. " <td>Caribbean</td>\n",
  1264. " <td>Perfect Touch Cuisine Ii</td>\n",
  1265. " <td>41646958</td>\n",
  1266. " <td>{\"building\":\"1148\",\"coord\":[-73.9508029,40.659...</td>\n",
  1267. " <td>[{\"date\":{\"$date\":1409270400000},\"grade\":\"B\",\"...</td>\n",
  1268. " <td>\"1148\"</td>\n",
  1269. " </tr>\n",
  1270. " <tr>\n",
  1271. " <th>25331</th>\n",
  1272. " <td>Brooklyn</td>\n",
  1273. " <td>American</td>\n",
  1274. " <td>Del Rio Diner</td>\n",
  1275. " <td>41646963</td>\n",
  1276. " <td>{\"building\":\"166\",\"coord\":[-73.98527659999999,...</td>\n",
  1277. " <td>[{\"date\":{\"$date\":1397001600000},\"grade\":\"A\",\"...</td>\n",
  1278. " <td>\"166\"</td>\n",
  1279. " </tr>\n",
  1280. " <tr>\n",
  1281. " <th>25332</th>\n",
  1282. " <td>Manhattan</td>\n",
  1283. " <td>Chinese</td>\n",
  1284. " <td>Fay Da Bakery</td>\n",
  1285. " <td>41646967</td>\n",
  1286. " <td>{\"building\":\"321\",\"coord\":[-74.0062401,40.7397...</td>\n",
  1287. " <td>[{\"date\":{\"$date\":1399852800000},\"grade\":\"A\",\"...</td>\n",
  1288. " <td>\"321\"</td>\n",
  1289. " </tr>\n",
  1290. " <tr>\n",
  1291. " <th>25333</th>\n",
  1292. " <td>Manhattan</td>\n",
  1293. " <td>Caribbean</td>\n",
  1294. " <td>Jahlookova</td>\n",
  1295. " <td>41646976</td>\n",
  1296. " <td>{\"building\":\"1962\",\"coord\":[-73.9405519,40.806...</td>\n",
  1297. " <td>[{\"date\":{\"$date\":1416960000000},\"grade\":\"A\",\"...</td>\n",
  1298. " <td>\"1962\"</td>\n",
  1299. " </tr>\n",
  1300. " <tr>\n",
  1301. " <th>25334</th>\n",
  1302. " <td>Manhattan</td>\n",
  1303. " <td>Delicatessen</td>\n",
  1304. " <td>Merci Market</td>\n",
  1305. " <td>41646979</td>\n",
  1306. " <td>{\"building\":\"350\",\"coord\":[-73.9922178,40.7579...</td>\n",
  1307. " <td>[{\"date\":{\"$date\":1420588800000},\"grade\":\"Z\",\"...</td>\n",
  1308. " <td>\"350\"</td>\n",
  1309. " </tr>\n",
  1310. " <tr>\n",
  1311. " <th>25335</th>\n",
  1312. " <td>Queens</td>\n",
  1313. " <td>Caribbean</td>\n",
  1314. " <td>Meat Veggies & Pasta Restaurant</td>\n",
  1315. " <td>41647006</td>\n",
  1316. " <td>{\"building\":\"118-16\",\"coord\":[-73.819531,40.67...</td>\n",
  1317. " <td>[{\"date\":{\"$date\":1415577600000},\"grade\":\"A\",\"...</td>\n",
  1318. " <td>\"118-16\"</td>\n",
  1319. " </tr>\n",
  1320. " <tr>\n",
  1321. " <th>25336</th>\n",
  1322. " <td>Manhattan</td>\n",
  1323. " <td>American</td>\n",
  1324. " <td>Toshi'S Living Room</td>\n",
  1325. " <td>41647012</td>\n",
  1326. " <td>{\"building\":\"9\",\"coord\":[-73.98931019999999,40...</td>\n",
  1327. " <td>[{\"date\":{\"$date\":1415750400000},\"grade\":\"A\",\"...</td>\n",
  1328. " <td>\"9\"</td>\n",
  1329. " </tr>\n",
  1330. " <tr>\n",
  1331. " <th>25337</th>\n",
  1332. " <td>Manhattan</td>\n",
  1333. " <td>American</td>\n",
  1334. " <td>Five Lamps Tavern</td>\n",
  1335. " <td>41647017</td>\n",
  1336. " <td>{\"building\":\"2756\",\"coord\":[-73.9675441,40.800...</td>\n",
  1337. " <td>[{\"date\":{\"$date\":1407283200000},\"grade\":\"C\",\"...</td>\n",
  1338. " <td>\"2756\"</td>\n",
  1339. " </tr>\n",
  1340. " <tr>\n",
  1341. " <th>25338</th>\n",
  1342. " <td>Queens</td>\n",
  1343. " <td>German</td>\n",
  1344. " <td>Max</td>\n",
  1345. " <td>41647039</td>\n",
  1346. " <td>{\"building\":\"47-02\",\"coord\":[-73.918047,40.765...</td>\n",
  1347. " <td>[{\"date\":{\"$date\":1416355200000},\"grade\":\"A\",\"...</td>\n",
  1348. " <td>\"47-02\"</td>\n",
  1349. " </tr>\n",
  1350. " <tr>\n",
  1351. " <th>25339</th>\n",
  1352. " <td>Queens</td>\n",
  1353. " <td>Chinese</td>\n",
  1354. " <td>Liang'S Kitchen Flushing Restaurant</td>\n",
  1355. " <td>41647062</td>\n",
  1356. " <td>{\"building\":\"13351\",\"coord\":[-73.832828,40.759...</td>\n",
  1357. " <td>[{\"date\":{\"$date\":1403308800000},\"grade\":\"B\",\"...</td>\n",
  1358. " <td>\"13351\"</td>\n",
  1359. " </tr>\n",
  1360. " <tr>\n",
  1361. " <th>25340</th>\n",
  1362. " <td>Bronx</td>\n",
  1363. " <td>Bangladeshi</td>\n",
  1364. " <td>Mehman Sweets Restaurant</td>\n",
  1365. " <td>41647098</td>\n",
  1366. " <td>{\"building\":\"1445\",\"coord\":[-73.8549994,40.835...</td>\n",
  1367. " <td>[{\"date\":{\"$date\":1406592000000},\"grade\":\"Z\",\"...</td>\n",
  1368. " <td>\"1445\"</td>\n",
  1369. " </tr>\n",
  1370. " <tr>\n",
  1371. " <th>25341</th>\n",
  1372. " <td>Queens</td>\n",
  1373. " <td>Mexican</td>\n",
  1374. " <td>Stephanie'S Mexican Bakery</td>\n",
  1375. " <td>41647129</td>\n",
  1376. " <td>{\"building\":\"37-56\",\"coord\":[-73.860018,40.752...</td>\n",
  1377. " <td>[{\"date\":{\"$date\":1408406400000},\"grade\":\"A\",\"...</td>\n",
  1378. " <td>\"37-56\"</td>\n",
  1379. " </tr>\n",
  1380. " <tr>\n",
  1381. " <th>25342</th>\n",
  1382. " <td>Bronx</td>\n",
  1383. " <td>Bakery</td>\n",
  1384. " <td>Bibbies Bakery</td>\n",
  1385. " <td>41647169</td>\n",
  1386. " <td>{\"building\":\"262\",\"coord\":[-73.9111954,40.8615...</td>\n",
  1387. " <td>[{\"date\":{\"$date\":1399507200000},\"grade\":\"A\",\"...</td>\n",
  1388. " <td>\"262\"</td>\n",
  1389. " </tr>\n",
  1390. " <tr>\n",
  1391. " <th>25343</th>\n",
  1392. " <td>Manhattan</td>\n",
  1393. " <td>Thai</td>\n",
  1394. " <td>Jaiya Thai & Oriental Restaurant</td>\n",
  1395. " <td>41647176</td>\n",
  1396. " <td>{\"building\":\"1553\",\"coord\":[-73.954548,40.7745...</td>\n",
  1397. " <td>[{\"date\":{\"$date\":1414540800000},\"grade\":\"A\",\"...</td>\n",
  1398. " <td>\"1553\"</td>\n",
  1399. " </tr>\n",
  1400. " <tr>\n",
  1401. " <th>25344</th>\n",
  1402. " <td>Manhattan</td>\n",
  1403. " <td>Chinese</td>\n",
  1404. " <td>China Wok</td>\n",
  1405. " <td>41647181</td>\n",
  1406. " <td>{\"building\":\"199\",\"coord\":[-73.9831015,40.7228...</td>\n",
  1407. " <td>[{\"date\":{\"$date\":1408060800000},\"grade\":\"B\",\"...</td>\n",
  1408. " <td>\"199\"</td>\n",
  1409. " </tr>\n",
  1410. " <tr>\n",
  1411. " <th>25345</th>\n",
  1412. " <td>Queens</td>\n",
  1413. " <td>Chinese</td>\n",
  1414. " <td>Xing Xing Chinese Restaurant</td>\n",
  1415. " <td>41647183</td>\n",
  1416. " <td>{\"building\":\"9712\",\"coord\":[-73.8194803,40.584...</td>\n",
  1417. " <td>[{\"date\":{\"$date\":1398729600000},\"grade\":\"A\",\"...</td>\n",
  1418. " <td>\"9712\"</td>\n",
  1419. " </tr>\n",
  1420. " <tr>\n",
  1421. " <th>25346</th>\n",
  1422. " <td>Queens</td>\n",
  1423. " <td>American</td>\n",
  1424. " <td>Packard Cafe</td>\n",
  1425. " <td>41647192</td>\n",
  1426. " <td>{\"building\":\"4134\",\"coord\":[-73.9400398,40.751...</td>\n",
  1427. " <td>[{\"date\":{\"$date\":1421193600000},\"grade\":\"A\",\"...</td>\n",
  1428. " <td>\"4134\"</td>\n",
  1429. " </tr>\n",
  1430. " <tr>\n",
  1431. " <th>25347</th>\n",
  1432. " <td>Queens</td>\n",
  1433. " <td>Pizza</td>\n",
  1434. " <td>Springfield & La Bari Pizzeria</td>\n",
  1435. " <td>41647210</td>\n",
  1436. " <td>{\"building\":\"136-13\",\"coord\":[-73.763352,40.67...</td>\n",
  1437. " <td>[{\"date\":{\"$date\":1419984000000},\"grade\":\"A\",\"...</td>\n",
  1438. " <td>\"136-13\"</td>\n",
  1439. " </tr>\n",
  1440. " <tr>\n",
  1441. " <th>25348</th>\n",
  1442. " <td>Queens</td>\n",
  1443. " <td>Caribbean</td>\n",
  1444. " <td>Dee'S Catering Services</td>\n",
  1445. " <td>41647221</td>\n",
  1446. " <td>{\"building\":\"217-15\",\"coord\":[-73.737423999999...</td>\n",
  1447. " <td>[{\"date\":{\"$date\":1401840000000},\"grade\":\"A\",\"...</td>\n",
  1448. " <td>\"217-15\"</td>\n",
  1449. " </tr>\n",
  1450. " <tr>\n",
  1451. " <th>25349</th>\n",
  1452. " <td>Manhattan</td>\n",
  1453. " <td>Asian</td>\n",
  1454. " <td>Jack'S Sliders And Sushi</td>\n",
  1455. " <td>41647241</td>\n",
  1456. " <td>{\"building\":\"171\",\"coord\":[-73.98581899999999,...</td>\n",
  1457. " <td>[{\"date\":{\"$date\":1417564800000},\"grade\":\"B\",\"...</td>\n",
  1458. " <td>\"171\"</td>\n",
  1459. " </tr>\n",
  1460. " <tr>\n",
  1461. " <th>25350</th>\n",
  1462. " <td>Brooklyn</td>\n",
  1463. " <td>Chinese</td>\n",
  1464. " <td>New Ming Fat Chinese Restaurant</td>\n",
  1465. " <td>41647292</td>\n",
  1466. " <td>{\"building\":\"1155\",\"coord\":[-73.8753401,40.672...</td>\n",
  1467. " <td>[{\"date\":{\"$date\":1394496000000},\"grade\":\"A\",\"...</td>\n",
  1468. " <td>\"1155\"</td>\n",
  1469. " </tr>\n",
  1470. " <tr>\n",
  1471. " <th>25351</th>\n",
  1472. " <td>Queens</td>\n",
  1473. " <td>Chinese</td>\n",
  1474. " <td>Noodle House</td>\n",
  1475. " <td>41647360</td>\n",
  1476. " <td>{\"building\":\"56-09\",\"coord\":[-73.7315557,40.76...</td>\n",
  1477. " <td>[{\"date\":{\"$date\":1404259200000},\"grade\":\"A\",\"...</td>\n",
  1478. " <td>\"56-09\"</td>\n",
  1479. " </tr>\n",
  1480. " <tr>\n",
  1481. " <th>25352</th>\n",
  1482. " <td>Brooklyn</td>\n",
  1483. " <td>Middle Eastern</td>\n",
  1484. " <td>Bahary Fish Market</td>\n",
  1485. " <td>41647370</td>\n",
  1486. " <td>{\"building\":\"484\",\"coord\":[-74.0212854,40.6334...</td>\n",
  1487. " <td>[{\"date\":{\"$date\":1401840000000},\"grade\":\"A\",\"...</td>\n",
  1488. " <td>\"484\"</td>\n",
  1489. " </tr>\n",
  1490. " <tr>\n",
  1491. " <th>25353</th>\n",
  1492. " <td>Queens</td>\n",
  1493. " <td>American</td>\n",
  1494. " <td>The Tin House Tavern</td>\n",
  1495. " <td>41647380</td>\n",
  1496. " <td>{\"building\":\"195-02\",\"coord\":[-73.785758,40.75...</td>\n",
  1497. " <td>[{\"date\":{\"$date\":1410134400000},\"grade\":\"A\",\"...</td>\n",
  1498. " <td>\"195-02\"</td>\n",
  1499. " </tr>\n",
  1500. " <tr>\n",
  1501. " <th>25354</th>\n",
  1502. " <td>Staten Island</td>\n",
  1503. " <td>Pizza</td>\n",
  1504. " <td>Ambrosino'S Ii</td>\n",
  1505. " <td>41647384</td>\n",
  1506. " <td>{\"building\":\"6410\",\"coord\":[-74.2150624,40.521...</td>\n",
  1507. " <td>[{\"date\":{\"$date\":1409616000000},\"grade\":\"A\",\"...</td>\n",
  1508. " <td>\"6410\"</td>\n",
  1509. " </tr>\n",
  1510. " <tr>\n",
  1511. " <th>25355</th>\n",
  1512. " <td>Bronx</td>\n",
  1513. " <td>Soul Food</td>\n",
  1514. " <td>Bruce'S Fish And Chips</td>\n",
  1515. " <td>41647392</td>\n",
  1516. " <td>{\"building\":\"500\",\"coord\":[-73.890768,40.85709...</td>\n",
  1517. " <td>[{\"date\":{\"$date\":1403568000000},\"grade\":\"A\",\"...</td>\n",
  1518. " <td>\"500\"</td>\n",
  1519. " </tr>\n",
  1520. " <tr>\n",
  1521. " <th>25356</th>\n",
  1522. " <td>Manhattan</td>\n",
  1523. " <td>Café/Coffee/Tea</td>\n",
  1524. " <td>Coffee Bean Tea & Leaf</td>\n",
  1525. " <td>41647399</td>\n",
  1526. " <td>{\"building\":\"2169\",\"coord\":[-73.981231,40.7822...</td>\n",
  1527. " <td>[{\"date\":{\"$date\":1406592000000},\"grade\":\"A\",\"...</td>\n",
  1528. " <td>\"2169\"</td>\n",
  1529. " </tr>\n",
  1530. " <tr>\n",
  1531. " <th>25357</th>\n",
  1532. " <td>Manhattan</td>\n",
  1533. " <td>Ice Cream, Gelato, Yogurt, Ices</td>\n",
  1534. " <td>Gelato Ti Amo</td>\n",
  1535. " <td>41647482</td>\n",
  1536. " <td>{\"building\":\"68\",\"coord\":[-73.9892179,40.72594...</td>\n",
  1537. " <td>[{\"date\":{\"$date\":1403913600000},\"grade\":\"A\",\"...</td>\n",
  1538. " <td>\"68\"</td>\n",
  1539. " </tr>\n",
  1540. " <tr>\n",
  1541. " <th>25358</th>\n",
  1542. " <td>Queens</td>\n",
  1543. " <td>Caribbean</td>\n",
  1544. " <td>Rockaway Roti Shop</td>\n",
  1545. " <td>41647521</td>\n",
  1546. " <td>{\"building\":\"12221\",\"coord\":[-73.8032425999999...</td>\n",
  1547. " <td>[{\"date\":{\"$date\":1418428800000},\"grade\":\"A\",\"...</td>\n",
  1548. " <td>\"12221\"</td>\n",
  1549. " </tr>\n",
  1550. " </tbody>\n",
  1551. "</table>\n",
  1552. "<p>25359 rows × 7 columns</p>\n",
  1553. "</div>"
  1554. ],
  1555. "text/plain": [
  1556. " borough cuisine \\\n",
  1557. "0 Bronx Bakery \n",
  1558. "1 Brooklyn Hamburgers \n",
  1559. "2 Manhattan Irish \n",
  1560. "3 Brooklyn American \n",
  1561. "4 Queens Jewish/Kosher \n",
  1562. "5 Queens American \n",
  1563. "6 Staten Island Jewish/Kosher \n",
  1564. "7 Brooklyn Delicatessen \n",
  1565. "8 Brooklyn American \n",
  1566. "9 Brooklyn Ice Cream, Gelato, Yogurt, Ices \n",
  1567. "10 Bronx American \n",
  1568. "11 Brooklyn American \n",
  1569. "12 Brooklyn Chinese \n",
  1570. "13 Manhattan American \n",
  1571. "14 Brooklyn Jewish/Kosher \n",
  1572. "15 Brooklyn Ice Cream, Gelato, Yogurt, Ices \n",
  1573. "16 Queens Ice Cream, Gelato, Yogurt, Ices \n",
  1574. "17 Brooklyn Delicatessen \n",
  1575. "18 Manhattan American \n",
  1576. "19 Brooklyn American \n",
  1577. "20 Queens Delicatessen \n",
  1578. "21 Manhattan Delicatessen \n",
  1579. "22 Queens Delicatessen \n",
  1580. "23 Manhattan Chicken \n",
  1581. "24 Manhattan American \n",
  1582. "25 Manhattan American \n",
  1583. "26 Brooklyn Hamburgers \n",
  1584. "27 Queens Chinese \n",
  1585. "28 Manhattan Turkish \n",
  1586. "29 Brooklyn Caribbean \n",
  1587. "... ... ... \n",
  1588. "25329 Queens Mexican \n",
  1589. "25330 Brooklyn Caribbean \n",
  1590. "25331 Brooklyn American \n",
  1591. "25332 Manhattan Chinese \n",
  1592. "25333 Manhattan Caribbean \n",
  1593. "25334 Manhattan Delicatessen \n",
  1594. "25335 Queens Caribbean \n",
  1595. "25336 Manhattan American \n",
  1596. "25337 Manhattan American \n",
  1597. "25338 Queens German \n",
  1598. "25339 Queens Chinese \n",
  1599. "25340 Bronx Bangladeshi \n",
  1600. "25341 Queens Mexican \n",
  1601. "25342 Bronx Bakery \n",
  1602. "25343 Manhattan Thai \n",
  1603. "25344 Manhattan Chinese \n",
  1604. "25345 Queens Chinese \n",
  1605. "25346 Queens American \n",
  1606. "25347 Queens Pizza \n",
  1607. "25348 Queens Caribbean \n",
  1608. "25349 Manhattan Asian \n",
  1609. "25350 Brooklyn Chinese \n",
  1610. "25351 Queens Chinese \n",
  1611. "25352 Brooklyn Middle Eastern \n",
  1612. "25353 Queens American \n",
  1613. "25354 Staten Island Pizza \n",
  1614. "25355 Bronx Soul Food \n",
  1615. "25356 Manhattan Café/Coffee/Tea \n",
  1616. "25357 Manhattan Ice Cream, Gelato, Yogurt, Ices \n",
  1617. "25358 Queens Caribbean \n",
  1618. "\n",
  1619. " name restaurant_id \\\n",
  1620. "0 Morris Park Bake Shop 30075445 \n",
  1621. "1 Wendy'S 30112340 \n",
  1622. "2 Dj Reynolds Pub And Restaurant 30191841 \n",
  1623. "3 Riviera Caterer 40356018 \n",
  1624. "4 Tov Kosher Kitchen 40356068 \n",
  1625. "5 Brunos On The Boulevard 40356151 \n",
  1626. "6 Kosher Island 40356442 \n",
  1627. "7 Wilken'S Fine Food 40356483 \n",
  1628. "8 Regina Caterers 40356649 \n",
  1629. "9 Taste The Tropics Ice Cream 40356731 \n",
  1630. "10 Wild Asia 40357217 \n",
  1631. "11 C & C Catering Service 40357437 \n",
  1632. "12 May May Kitchen 40358429 \n",
  1633. "13 1 East 66Th Street Kitchen 40359480 \n",
  1634. "14 Seuda Foods 40360045 \n",
  1635. "15 Carvel Ice Cream 40360076 \n",
  1636. "16 Carvel Ice Cream 40361322 \n",
  1637. "17 Nordic Delicacies 40361390 \n",
  1638. "18 Glorious Food 40361521 \n",
  1639. "19 The Movable Feast 40361606 \n",
  1640. "20 Sal'S Deli 40361618 \n",
  1641. "21 Bully'S Deli 40361708 \n",
  1642. "22 Steve Chu'S Deli & Grocery 40361998 \n",
  1643. "23 Harriet'S Kitchen 40362098 \n",
  1644. "24 P & S Deli Grocery 40362264 \n",
  1645. "25 Angelika Film Center 40362274 \n",
  1646. "26 White Castle 40362344 \n",
  1647. "27 Ho Mei Restaurant 40362432 \n",
  1648. "28 The Country Cafe 40362715 \n",
  1649. "29 Shashemene Int'L Restaura 40362869 \n",
  1650. "... ... ... \n",
  1651. "25329 Bella'S Place 41646934 \n",
  1652. "25330 Perfect Touch Cuisine Ii 41646958 \n",
  1653. "25331 Del Rio Diner 41646963 \n",
  1654. "25332 Fay Da Bakery 41646967 \n",
  1655. "25333 Jahlookova 41646976 \n",
  1656. "25334 Merci Market 41646979 \n",
  1657. "25335 Meat Veggies & Pasta Restaurant 41647006 \n",
  1658. "25336 Toshi'S Living Room 41647012 \n",
  1659. "25337 Five Lamps Tavern 41647017 \n",
  1660. "25338 Max 41647039 \n",
  1661. "25339 Liang'S Kitchen Flushing Restaurant 41647062 \n",
  1662. "25340 Mehman Sweets Restaurant 41647098 \n",
  1663. "25341 Stephanie'S Mexican Bakery 41647129 \n",
  1664. "25342 Bibbies Bakery 41647169 \n",
  1665. "25343 Jaiya Thai & Oriental Restaurant 41647176 \n",
  1666. "25344 China Wok 41647181 \n",
  1667. "25345 Xing Xing Chinese Restaurant 41647183 \n",
  1668. "25346 Packard Cafe 41647192 \n",
  1669. "25347 Springfield & La Bari Pizzeria 41647210 \n",
  1670. "25348 Dee'S Catering Services 41647221 \n",
  1671. "25349 Jack'S Sliders And Sushi 41647241 \n",
  1672. "25350 New Ming Fat Chinese Restaurant 41647292 \n",
  1673. "25351 Noodle House 41647360 \n",
  1674. "25352 Bahary Fish Market 41647370 \n",
  1675. "25353 The Tin House Tavern 41647380 \n",
  1676. "25354 Ambrosino'S Ii 41647384 \n",
  1677. "25355 Bruce'S Fish And Chips 41647392 \n",
  1678. "25356 Coffee Bean Tea & Leaf 41647399 \n",
  1679. "25357 Gelato Ti Amo 41647482 \n",
  1680. "25358 Rockaway Roti Shop 41647521 \n",
  1681. "\n",
  1682. " address_json \\\n",
  1683. "0 {\"building\":\"1007\",\"coord\":[-73.856077,40.8484... \n",
  1684. "1 {\"building\":\"469\",\"coord\":[-73.961704,40.66294... \n",
  1685. "2 {\"building\":\"351\",\"coord\":[-73.98513559999999,... \n",
  1686. "3 {\"building\":\"2780\",\"coord\":[-73.98241999999999... \n",
  1687. "4 {\"building\":\"97-22\",\"coord\":[-73.8601152,40.73... \n",
  1688. "5 {\"building\":\"8825\",\"coord\":[-73.8803827,40.764... \n",
  1689. "6 {\"building\":\"2206\",\"coord\":[-74.1377286,40.611... \n",
  1690. "7 {\"building\":\"7114\",\"coord\":[-73.9068506,40.619... \n",
  1691. "8 {\"building\":\"6409\",\"coord\":[-74.00528899999999... \n",
  1692. "9 {\"building\":\"1839\",\"coord\":[-73.9482609,40.640... \n",
  1693. "10 {\"building\":\"2300\",\"coord\":[-73.8786113,40.850... \n",
  1694. "11 {\"building\":\"7715\",\"coord\":[-73.9973325,40.611... \n",
  1695. "12 {\"building\":\"1269\",\"coord\":[-73.871194,40.6730... \n",
  1696. "13 {\"building\":\"1\",\"coord\":[-73.96926909999999,40... \n",
  1697. "14 {\"building\":\"705\",\"coord\":[-73.9653967,40.6064... \n",
  1698. "15 {\"building\":\"203\",\"coord\":[-73.97822040000001,... \n",
  1699. "16 {\"building\":\"265-15\",\"coord\":[-73.7032601,40.7... \n",
  1700. "17 {\"building\":\"6909\",\"coord\":[-74.0259567,40.635... \n",
  1701. "18 {\"building\":\"522\",\"coord\":[-73.95171,40.767461... \n",
  1702. "19 {\"building\":\"284\",\"coord\":[-73.9829239,40.6580... \n",
  1703. "20 {\"building\":\"129-08\",\"coord\":[-73.839297,40.78... \n",
  1704. "21 {\"building\":\"759\",\"coord\":[-73.9925306,40.7309... \n",
  1705. "22 {\"building\":\"3406\",\"coord\":[-73.94024739999999... \n",
  1706. "23 {\"building\":\"502\",\"coord\":[-73.976112,40.78671... \n",
  1707. "24 {\"building\":\"730\",\"coord\":[-73.96805719999999,... \n",
  1708. "25 {\"building\":\"18\",\"coord\":[-73.996984,40.72589]... \n",
  1709. "26 {\"building\":\"531\",\"coord\":[-73.9634876,40.6940... \n",
  1710. "27 {\"building\":\"103-05\",\"coord\":[-73.8642349,40.7... \n",
  1711. "28 {\"building\":\"60\",\"coord\":[-74.0085357,40.70620... \n",
  1712. "29 {\"building\":\"195\",\"coord\":[-73.9246028,40.6522... \n",
  1713. "... ... \n",
  1714. "25329 {\"building\":\"87-77\",\"coord\":[-73.8093635,40.70... \n",
  1715. "25330 {\"building\":\"1148\",\"coord\":[-73.9508029,40.659... \n",
  1716. "25331 {\"building\":\"166\",\"coord\":[-73.98527659999999,... \n",
  1717. "25332 {\"building\":\"321\",\"coord\":[-74.0062401,40.7397... \n",
  1718. "25333 {\"building\":\"1962\",\"coord\":[-73.9405519,40.806... \n",
  1719. "25334 {\"building\":\"350\",\"coord\":[-73.9922178,40.7579... \n",
  1720. "25335 {\"building\":\"118-16\",\"coord\":[-73.819531,40.67... \n",
  1721. "25336 {\"building\":\"9\",\"coord\":[-73.98931019999999,40... \n",
  1722. "25337 {\"building\":\"2756\",\"coord\":[-73.9675441,40.800... \n",
  1723. "25338 {\"building\":\"47-02\",\"coord\":[-73.918047,40.765... \n",
  1724. "25339 {\"building\":\"13351\",\"coord\":[-73.832828,40.759... \n",
  1725. "25340 {\"building\":\"1445\",\"coord\":[-73.8549994,40.835... \n",
  1726. "25341 {\"building\":\"37-56\",\"coord\":[-73.860018,40.752... \n",
  1727. "25342 {\"building\":\"262\",\"coord\":[-73.9111954,40.8615... \n",
  1728. "25343 {\"building\":\"1553\",\"coord\":[-73.954548,40.7745... \n",
  1729. "25344 {\"building\":\"199\",\"coord\":[-73.9831015,40.7228... \n",
  1730. "25345 {\"building\":\"9712\",\"coord\":[-73.8194803,40.584... \n",
  1731. "25346 {\"building\":\"4134\",\"coord\":[-73.9400398,40.751... \n",
  1732. "25347 {\"building\":\"136-13\",\"coord\":[-73.763352,40.67... \n",
  1733. "25348 {\"building\":\"217-15\",\"coord\":[-73.737423999999... \n",
  1734. "25349 {\"building\":\"171\",\"coord\":[-73.98581899999999,... \n",
  1735. "25350 {\"building\":\"1155\",\"coord\":[-73.8753401,40.672... \n",
  1736. "25351 {\"building\":\"56-09\",\"coord\":[-73.7315557,40.76... \n",
  1737. "25352 {\"building\":\"484\",\"coord\":[-74.0212854,40.6334... \n",
  1738. "25353 {\"building\":\"195-02\",\"coord\":[-73.785758,40.75... \n",
  1739. "25354 {\"building\":\"6410\",\"coord\":[-74.2150624,40.521... \n",
  1740. "25355 {\"building\":\"500\",\"coord\":[-73.890768,40.85709... \n",
  1741. "25356 {\"building\":\"2169\",\"coord\":[-73.981231,40.7822... \n",
  1742. "25357 {\"building\":\"68\",\"coord\":[-73.9892179,40.72594... \n",
  1743. "25358 {\"building\":\"12221\",\"coord\":[-73.8032425999999... \n",
  1744. "\n",
  1745. " grades_json building \n",
  1746. "0 [{\"date\":{\"$date\":1393804800000},\"grade\":\"A\",\"... \"1007\" \n",
  1747. "1 [{\"date\":{\"$date\":1419897600000},\"grade\":\"A\",\"... \"469\" \n",
  1748. "2 [{\"date\":{\"$date\":1409961600000},\"grade\":\"A\",\"... \"351\" \n",
  1749. "3 [{\"date\":{\"$date\":1402358400000},\"grade\":\"A\",\"... \"2780\" \n",
  1750. "4 [{\"date\":{\"$date\":1416787200000},\"grade\":\"Z\",\"... \"97-22\" \n",
  1751. "5 [{\"date\":{\"$date\":1416009600000},\"grade\":\"Z\",\"... \"8825\" \n",
  1752. "6 [{\"date\":{\"$date\":1412553600000},\"grade\":\"A\",\"... \"2206\" \n",
  1753. "7 [{\"date\":{\"$date\":1401321600000},\"grade\":\"A\",\"... \"7114\" \n",
  1754. "8 [{\"date\":{\"$date\":1405641600000},\"grade\":\"A\",\"... \"6409\" \n",
  1755. "9 [{\"date\":{\"$date\":1405296000000},\"grade\":\"A\",\"... \"1839\" \n",
  1756. "10 [{\"date\":{\"$date\":1401235200000},\"grade\":\"A\",\"... \"2300\" \n",
  1757. "11 [{\"date\":{\"$date\":1397606400000},\"grade\":\"A\",\"... \"7715\" \n",
  1758. "12 [{\"date\":{\"$date\":1410825600000},\"grade\":\"B\",\"... \"1269\" \n",
  1759. "13 [{\"date\":{\"$date\":1399420800000},\"grade\":\"A\",\"... \"1\" \n",
  1760. "14 [{\"date\":{\"$date\":1415577600000},\"grade\":\"A\",\"... \"705\" \n",
  1761. "15 [{\"date\":{\"$date\":1391990400000},\"grade\":\"A\",\"... \"203\" \n",
  1762. "16 [{\"date\":{\"$date\":1414454400000},\"grade\":\"A\",\"... \"265-15\" \n",
  1763. "17 [{\"date\":{\"$date\":1408579200000},\"grade\":\"A\",\"... \"6909\" \n",
  1764. "18 [{\"date\":{\"$date\":1409616000000},\"grade\":\"A\",\"... \"522\" \n",
  1765. "19 [{\"date\":{\"$date\":1416355200000},\"grade\":\"A\",\"... \"284\" \n",
  1766. "20 [{\"date\":{\"$date\":1408147200000},\"grade\":\"A\",\"... \"129-08\" \n",
  1767. "21 [{\"date\":{\"$date\":1390262400000},\"grade\":\"A\",\"... \"759\" \n",
  1768. "22 [{\"date\":{\"$date\":1395187200000},\"grade\":\"A\",\"... \"3406\" \n",
  1769. "23 [{\"date\":{\"$date\":1410739200000},\"grade\":\"A\",\"... \"502\" \n",
  1770. "24 [{\"date\":{\"$date\":1410480000000},\"grade\":\"B\",\"... \"730\" \n",
  1771. "25 [{\"date\":{\"$date\":1396483200000},\"grade\":\"A\",\"... \"18\" \n",
  1772. "26 [{\"date\":{\"$date\":1395100800000},\"grade\":\"A\",\"... \"531\" \n",
  1773. "27 [{\"date\":{\"$date\":1398038400000},\"grade\":\"A\",\"... \"103-05\" \n",
  1774. "28 [{\"date\":{\"$date\":1411689600000},\"grade\":\"A\",\"... \"60\" \n",
  1775. "29 [{\"date\":{\"$date\":1399939200000},\"grade\":\"A\",\"... \"195\" \n",
  1776. "... ... ... \n",
  1777. "25329 [{\"date\":{\"$date\":1413417600000},\"grade\":\"Z\",\"... \"87-77\" \n",
  1778. "25330 [{\"date\":{\"$date\":1409270400000},\"grade\":\"B\",\"... \"1148\" \n",
  1779. "25331 [{\"date\":{\"$date\":1397001600000},\"grade\":\"A\",\"... \"166\" \n",
  1780. "25332 [{\"date\":{\"$date\":1399852800000},\"grade\":\"A\",\"... \"321\" \n",
  1781. "25333 [{\"date\":{\"$date\":1416960000000},\"grade\":\"A\",\"... \"1962\" \n",
  1782. "25334 [{\"date\":{\"$date\":1420588800000},\"grade\":\"Z\",\"... \"350\" \n",
  1783. "25335 [{\"date\":{\"$date\":1415577600000},\"grade\":\"A\",\"... \"118-16\" \n",
  1784. "25336 [{\"date\":{\"$date\":1415750400000},\"grade\":\"A\",\"... \"9\" \n",
  1785. "25337 [{\"date\":{\"$date\":1407283200000},\"grade\":\"C\",\"... \"2756\" \n",
  1786. "25338 [{\"date\":{\"$date\":1416355200000},\"grade\":\"A\",\"... \"47-02\" \n",
  1787. "25339 [{\"date\":{\"$date\":1403308800000},\"grade\":\"B\",\"... \"13351\" \n",
  1788. "25340 [{\"date\":{\"$date\":1406592000000},\"grade\":\"Z\",\"... \"1445\" \n",
  1789. "25341 [{\"date\":{\"$date\":1408406400000},\"grade\":\"A\",\"... \"37-56\" \n",
  1790. "25342 [{\"date\":{\"$date\":1399507200000},\"grade\":\"A\",\"... \"262\" \n",
  1791. "25343 [{\"date\":{\"$date\":1414540800000},\"grade\":\"A\",\"... \"1553\" \n",
  1792. "25344 [{\"date\":{\"$date\":1408060800000},\"grade\":\"B\",\"... \"199\" \n",
  1793. "25345 [{\"date\":{\"$date\":1398729600000},\"grade\":\"A\",\"... \"9712\" \n",
  1794. "25346 [{\"date\":{\"$date\":1421193600000},\"grade\":\"A\",\"... \"4134\" \n",
  1795. "25347 [{\"date\":{\"$date\":1419984000000},\"grade\":\"A\",\"... \"136-13\" \n",
  1796. "25348 [{\"date\":{\"$date\":1401840000000},\"grade\":\"A\",\"... \"217-15\" \n",
  1797. "25349 [{\"date\":{\"$date\":1417564800000},\"grade\":\"B\",\"... \"171\" \n",
  1798. "25350 [{\"date\":{\"$date\":1394496000000},\"grade\":\"A\",\"... \"1155\" \n",
  1799. "25351 [{\"date\":{\"$date\":1404259200000},\"grade\":\"A\",\"... \"56-09\" \n",
  1800. "25352 [{\"date\":{\"$date\":1401840000000},\"grade\":\"A\",\"... \"484\" \n",
  1801. "25353 [{\"date\":{\"$date\":1410134400000},\"grade\":\"A\",\"... \"195-02\" \n",
  1802. "25354 [{\"date\":{\"$date\":1409616000000},\"grade\":\"A\",\"... \"6410\" \n",
  1803. "25355 [{\"date\":{\"$date\":1403568000000},\"grade\":\"A\",\"... \"500\" \n",
  1804. "25356 [{\"date\":{\"$date\":1406592000000},\"grade\":\"A\",\"... \"2169\" \n",
  1805. "25357 [{\"date\":{\"$date\":1403913600000},\"grade\":\"A\",\"... \"68\" \n",
  1806. "25358 [{\"date\":{\"$date\":1418428800000},\"grade\":\"A\",\"... \"12221\" \n",
  1807. "\n",
  1808. "[25359 rows x 7 columns]"
  1809. ]
  1810. },
  1811. "execution_count": 5,
  1812. "metadata": {},
  1813. "output_type": "execute_result"
  1814. }
  1815. ],
  1816. "source": [
  1817. "read_test_with_query.toPandas()"
  1818. ]
  1819. },
  1820. {
  1821. "cell_type": "code",
  1822. "execution_count": 21,
  1823. "metadata": {},
  1824. "outputs": [
  1825. {
  1826. "data": {
  1827. "text/html": [
  1828. "<div>\n",
  1829. "<style>\n",
  1830. " .dataframe thead tr:only-child th {\n",
  1831. " text-align: right;\n",
  1832. " }\n",
  1833. "\n",
  1834. " .dataframe thead th {\n",
  1835. " text-align: left;\n",
  1836. " }\n",
  1837. "\n",
  1838. " .dataframe tbody tr th {\n",
  1839. " vertical-align: top;\n",
  1840. " }\n",
  1841. "</style>\n",
  1842. "<table border=\"1\" class=\"dataframe\">\n",
  1843. " <thead>\n",
  1844. " <tr style=\"text-align: right;\">\n",
  1845. " <th></th>\n",
  1846. " <th>borough</th>\n",
  1847. " <th>cuisine</th>\n",
  1848. " <th>name</th>\n",
  1849. " <th>restaurant_id</th>\n",
  1850. " <th>address_json</th>\n",
  1851. " <th>grades_json</th>\n",
  1852. " <th>building</th>\n",
  1853. " </tr>\n",
  1854. " </thead>\n",
  1855. " <tbody>\n",
  1856. " <tr>\n",
  1857. " <th>0</th>\n",
  1858. " <td>Bronx</td>\n",
  1859. " <td>Bakery</td>\n",
  1860. " <td>Morris Park Bake Shop</td>\n",
  1861. " <td>30075445</td>\n",
  1862. " <td>{\"building\":\"1007\",\"coord\":[-73.856077,40.8484...</td>\n",
  1863. " <td>[{\"date\":{\"$date\":1393804800000},\"grade\":\"A\",\"...</td>\n",
  1864. " <td>\"1007\"</td>\n",
  1865. " </tr>\n",
  1866. " <tr>\n",
  1867. " <th>1</th>\n",
  1868. " <td>Brooklyn</td>\n",
  1869. " <td>Hamburgers</td>\n",
  1870. " <td>Wendy'S</td>\n",
  1871. " <td>30112340</td>\n",
  1872. " <td>{\"building\":\"469\",\"coord\":[-73.961704,40.66294...</td>\n",
  1873. " <td>[{\"date\":{\"$date\":1419897600000},\"grade\":\"A\",\"...</td>\n",
  1874. " <td>\"469\"</td>\n",
  1875. " </tr>\n",
  1876. " <tr>\n",
  1877. " <th>2</th>\n",
  1878. " <td>Manhattan</td>\n",
  1879. " <td>Irish</td>\n",
  1880. " <td>Dj Reynolds Pub And Restaurant</td>\n",
  1881. " <td>30191841</td>\n",
  1882. " <td>{\"building\":\"351\",\"coord\":[-73.98513559999999,...</td>\n",
  1883. " <td>[{\"date\":{\"$date\":1409961600000},\"grade\":\"A\",\"...</td>\n",
  1884. " <td>\"351\"</td>\n",
  1885. " </tr>\n",
  1886. " <tr>\n",
  1887. " <th>3</th>\n",
  1888. " <td>Brooklyn</td>\n",
  1889. " <td>American</td>\n",
  1890. " <td>Riviera Caterer</td>\n",
  1891. " <td>40356018</td>\n",
  1892. " <td>{\"building\":\"2780\",\"coord\":[-73.98241999999999...</td>\n",
  1893. " <td>[{\"date\":{\"$date\":1402358400000},\"grade\":\"A\",\"...</td>\n",
  1894. " <td>\"2780\"</td>\n",
  1895. " </tr>\n",
  1896. " <tr>\n",
  1897. " <th>4</th>\n",
  1898. " <td>Queens</td>\n",
  1899. " <td>Jewish/Kosher</td>\n",
  1900. " <td>Tov Kosher Kitchen</td>\n",
  1901. " <td>40356068</td>\n",
  1902. " <td>{\"building\":\"97-22\",\"coord\":[-73.8601152,40.73...</td>\n",
  1903. " <td>[{\"date\":{\"$date\":1416787200000},\"grade\":\"Z\",\"...</td>\n",
  1904. " <td>\"97-22\"</td>\n",
  1905. " </tr>\n",
  1906. " <tr>\n",
  1907. " <th>5</th>\n",
  1908. " <td>Queens</td>\n",
  1909. " <td>American</td>\n",
  1910. " <td>Brunos On The Boulevard</td>\n",
  1911. " <td>40356151</td>\n",
  1912. " <td>{\"building\":\"8825\",\"coord\":[-73.8803827,40.764...</td>\n",
  1913. " <td>[{\"date\":{\"$date\":1416009600000},\"grade\":\"Z\",\"...</td>\n",
  1914. " <td>\"8825\"</td>\n",
  1915. " </tr>\n",
  1916. " <tr>\n",
  1917. " <th>6</th>\n",
  1918. " <td>Staten Island</td>\n",
  1919. " <td>Jewish/Kosher</td>\n",
  1920. " <td>Kosher Island</td>\n",
  1921. " <td>40356442</td>\n",
  1922. " <td>{\"building\":\"2206\",\"coord\":[-74.1377286,40.611...</td>\n",
  1923. " <td>[{\"date\":{\"$date\":1412553600000},\"grade\":\"A\",\"...</td>\n",
  1924. " <td>\"2206\"</td>\n",
  1925. " </tr>\n",
  1926. " <tr>\n",
  1927. " <th>7</th>\n",
  1928. " <td>Brooklyn</td>\n",
  1929. " <td>Delicatessen</td>\n",
  1930. " <td>Wilken'S Fine Food</td>\n",
  1931. " <td>40356483</td>\n",
  1932. " <td>{\"building\":\"7114\",\"coord\":[-73.9068506,40.619...</td>\n",
  1933. " <td>[{\"date\":{\"$date\":1401321600000},\"grade\":\"A\",\"...</td>\n",
  1934. " <td>\"7114\"</td>\n",
  1935. " </tr>\n",
  1936. " <tr>\n",
  1937. " <th>8</th>\n",
  1938. " <td>Brooklyn</td>\n",
  1939. " <td>American</td>\n",
  1940. " <td>Regina Caterers</td>\n",
  1941. " <td>40356649</td>\n",
  1942. " <td>{\"building\":\"6409\",\"coord\":[-74.00528899999999...</td>\n",
  1943. " <td>[{\"date\":{\"$date\":1405641600000},\"grade\":\"A\",\"...</td>\n",
  1944. " <td>\"6409\"</td>\n",
  1945. " </tr>\n",
  1946. " <tr>\n",
  1947. " <th>9</th>\n",
  1948. " <td>Brooklyn</td>\n",
  1949. " <td>Ice Cream, Gelato, Yogurt, Ices</td>\n",
  1950. " <td>Taste The Tropics Ice Cream</td>\n",
  1951. " <td>40356731</td>\n",
  1952. " <td>{\"building\":\"1839\",\"coord\":[-73.9482609,40.640...</td>\n",
  1953. " <td>[{\"date\":{\"$date\":1405296000000},\"grade\":\"A\",\"...</td>\n",
  1954. " <td>\"1839\"</td>\n",
  1955. " </tr>\n",
  1956. " <tr>\n",
  1957. " <th>10</th>\n",
  1958. " <td>Bronx</td>\n",
  1959. " <td>American</td>\n",
  1960. " <td>Wild Asia</td>\n",
  1961. " <td>40357217</td>\n",
  1962. " <td>{\"building\":\"2300\",\"coord\":[-73.8786113,40.850...</td>\n",
  1963. " <td>[{\"date\":{\"$date\":1401235200000},\"grade\":\"A\",\"...</td>\n",
  1964. " <td>\"2300\"</td>\n",
  1965. " </tr>\n",
  1966. " <tr>\n",
  1967. " <th>11</th>\n",
  1968. " <td>Brooklyn</td>\n",
  1969. " <td>American</td>\n",
  1970. " <td>C & C Catering Service</td>\n",
  1971. " <td>40357437</td>\n",
  1972. " <td>{\"building\":\"7715\",\"coord\":[-73.9973325,40.611...</td>\n",
  1973. " <td>[{\"date\":{\"$date\":1397606400000},\"grade\":\"A\",\"...</td>\n",
  1974. " <td>\"7715\"</td>\n",
  1975. " </tr>\n",
  1976. " <tr>\n",
  1977. " <th>12</th>\n",
  1978. " <td>Brooklyn</td>\n",
  1979. " <td>Chinese</td>\n",
  1980. " <td>May May Kitchen</td>\n",
  1981. " <td>40358429</td>\n",
  1982. " <td>{\"building\":\"1269\",\"coord\":[-73.871194,40.6730...</td>\n",
  1983. " <td>[{\"date\":{\"$date\":1410825600000},\"grade\":\"B\",\"...</td>\n",
  1984. " <td>\"1269\"</td>\n",
  1985. " </tr>\n",
  1986. " <tr>\n",
  1987. " <th>13</th>\n",
  1988. " <td>Manhattan</td>\n",
  1989. " <td>American</td>\n",
  1990. " <td>1 East 66Th Street Kitchen</td>\n",
  1991. " <td>40359480</td>\n",
  1992. " <td>{\"building\":\"1\",\"coord\":[-73.96926909999999,40...</td>\n",
  1993. " <td>[{\"date\":{\"$date\":1399420800000},\"grade\":\"A\",\"...</td>\n",
  1994. " <td>\"1\"</td>\n",
  1995. " </tr>\n",
  1996. " <tr>\n",
  1997. " <th>14</th>\n",
  1998. " <td>Brooklyn</td>\n",
  1999. " <td>Jewish/Kosher</td>\n",
  2000. " <td>Seuda Foods</td>\n",
  2001. " <td>40360045</td>\n",
  2002. " <td>{\"building\":\"705\",\"coord\":[-73.9653967,40.6064...</td>\n",
  2003. " <td>[{\"date\":{\"$date\":1415577600000},\"grade\":\"A\",\"...</td>\n",
  2004. " <td>\"705\"</td>\n",
  2005. " </tr>\n",
  2006. " <tr>\n",
  2007. " <th>15</th>\n",
  2008. " <td>Brooklyn</td>\n",
  2009. " <td>Ice Cream, Gelato, Yogurt, Ices</td>\n",
  2010. " <td>Carvel Ice Cream</td>\n",
  2011. " <td>40360076</td>\n",
  2012. " <td>{\"building\":\"203\",\"coord\":[-73.97822040000001,...</td>\n",
  2013. " <td>[{\"date\":{\"$date\":1391990400000},\"grade\":\"A\",\"...</td>\n",
  2014. " <td>\"203\"</td>\n",
  2015. " </tr>\n",
  2016. " <tr>\n",
  2017. " <th>16</th>\n",
  2018. " <td>Queens</td>\n",
  2019. " <td>Ice Cream, Gelato, Yogurt, Ices</td>\n",
  2020. " <td>Carvel Ice Cream</td>\n",
  2021. " <td>40361322</td>\n",
  2022. " <td>{\"building\":\"265-15\",\"coord\":[-73.7032601,40.7...</td>\n",
  2023. " <td>[{\"date\":{\"$date\":1414454400000},\"grade\":\"A\",\"...</td>\n",
  2024. " <td>\"265-15\"</td>\n",
  2025. " </tr>\n",
  2026. " <tr>\n",
  2027. " <th>17</th>\n",
  2028. " <td>Brooklyn</td>\n",
  2029. " <td>Delicatessen</td>\n",
  2030. " <td>Nordic Delicacies</td>\n",
  2031. " <td>40361390</td>\n",
  2032. " <td>{\"building\":\"6909\",\"coord\":[-74.0259567,40.635...</td>\n",
  2033. " <td>[{\"date\":{\"$date\":1408579200000},\"grade\":\"A\",\"...</td>\n",
  2034. " <td>\"6909\"</td>\n",
  2035. " </tr>\n",
  2036. " <tr>\n",
  2037. " <th>18</th>\n",
  2038. " <td>Manhattan</td>\n",
  2039. " <td>American</td>\n",
  2040. " <td>Glorious Food</td>\n",
  2041. " <td>40361521</td>\n",
  2042. " <td>{\"building\":\"522\",\"coord\":[-73.95171,40.767461...</td>\n",
  2043. " <td>[{\"date\":{\"$date\":1409616000000},\"grade\":\"A\",\"...</td>\n",
  2044. " <td>\"522\"</td>\n",
  2045. " </tr>\n",
  2046. " <tr>\n",
  2047. " <th>19</th>\n",
  2048. " <td>Brooklyn</td>\n",
  2049. " <td>American</td>\n",
  2050. " <td>The Movable Feast</td>\n",
  2051. " <td>40361606</td>\n",
  2052. " <td>{\"building\":\"284\",\"coord\":[-73.9829239,40.6580...</td>\n",
  2053. " <td>[{\"date\":{\"$date\":1416355200000},\"grade\":\"A\",\"...</td>\n",
  2054. " <td>\"284\"</td>\n",
  2055. " </tr>\n",
  2056. " <tr>\n",
  2057. " <th>20</th>\n",
  2058. " <td>Queens</td>\n",
  2059. " <td>Delicatessen</td>\n",
  2060. " <td>Sal'S Deli</td>\n",
  2061. " <td>40361618</td>\n",
  2062. " <td>{\"building\":\"129-08\",\"coord\":[-73.839297,40.78...</td>\n",
  2063. " <td>[{\"date\":{\"$date\":1408147200000},\"grade\":\"A\",\"...</td>\n",
  2064. " <td>\"129-08\"</td>\n",
  2065. " </tr>\n",
  2066. " <tr>\n",
  2067. " <th>21</th>\n",
  2068. " <td>Manhattan</td>\n",
  2069. " <td>Delicatessen</td>\n",
  2070. " <td>Bully'S Deli</td>\n",
  2071. " <td>40361708</td>\n",
  2072. " <td>{\"building\":\"759\",\"coord\":[-73.9925306,40.7309...</td>\n",
  2073. " <td>[{\"date\":{\"$date\":1390262400000},\"grade\":\"A\",\"...</td>\n",
  2074. " <td>\"759\"</td>\n",
  2075. " </tr>\n",
  2076. " <tr>\n",
  2077. " <th>22</th>\n",
  2078. " <td>Queens</td>\n",
  2079. " <td>Delicatessen</td>\n",
  2080. " <td>Steve Chu'S Deli & Grocery</td>\n",
  2081. " <td>40361998</td>\n",
  2082. " <td>{\"building\":\"3406\",\"coord\":[-73.94024739999999...</td>\n",
  2083. " <td>[{\"date\":{\"$date\":1395187200000},\"grade\":\"A\",\"...</td>\n",
  2084. " <td>\"3406\"</td>\n",
  2085. " </tr>\n",
  2086. " <tr>\n",
  2087. " <th>23</th>\n",
  2088. " <td>Manhattan</td>\n",
  2089. " <td>Chicken</td>\n",
  2090. " <td>Harriet'S Kitchen</td>\n",
  2091. " <td>40362098</td>\n",
  2092. " <td>{\"building\":\"502\",\"coord\":[-73.976112,40.78671...</td>\n",
  2093. " <td>[{\"date\":{\"$date\":1410739200000},\"grade\":\"A\",\"...</td>\n",
  2094. " <td>\"502\"</td>\n",
  2095. " </tr>\n",
  2096. " <tr>\n",
  2097. " <th>24</th>\n",
  2098. " <td>Manhattan</td>\n",
  2099. " <td>American</td>\n",
  2100. " <td>P & S Deli Grocery</td>\n",
  2101. " <td>40362264</td>\n",
  2102. " <td>{\"building\":\"730\",\"coord\":[-73.96805719999999,...</td>\n",
  2103. " <td>[{\"date\":{\"$date\":1410480000000},\"grade\":\"B\",\"...</td>\n",
  2104. " <td>\"730\"</td>\n",
  2105. " </tr>\n",
  2106. " <tr>\n",
  2107. " <th>25</th>\n",
  2108. " <td>Manhattan</td>\n",
  2109. " <td>American</td>\n",
  2110. " <td>Angelika Film Center</td>\n",
  2111. " <td>40362274</td>\n",
  2112. " <td>{\"building\":\"18\",\"coord\":[-73.996984,40.72589]...</td>\n",
  2113. " <td>[{\"date\":{\"$date\":1396483200000},\"grade\":\"A\",\"...</td>\n",
  2114. " <td>\"18\"</td>\n",
  2115. " </tr>\n",
  2116. " <tr>\n",
  2117. " <th>26</th>\n",
  2118. " <td>Brooklyn</td>\n",
  2119. " <td>Hamburgers</td>\n",
  2120. " <td>White Castle</td>\n",
  2121. " <td>40362344</td>\n",
  2122. " <td>{\"building\":\"531\",\"coord\":[-73.9634876,40.6940...</td>\n",
  2123. " <td>[{\"date\":{\"$date\":1395100800000},\"grade\":\"A\",\"...</td>\n",
  2124. " <td>\"531\"</td>\n",
  2125. " </tr>\n",
  2126. " <tr>\n",
  2127. " <th>27</th>\n",
  2128. " <td>Queens</td>\n",
  2129. " <td>Chinese</td>\n",
  2130. " <td>Ho Mei Restaurant</td>\n",
  2131. " <td>40362432</td>\n",
  2132. " <td>{\"building\":\"103-05\",\"coord\":[-73.8642349,40.7...</td>\n",
  2133. " <td>[{\"date\":{\"$date\":1398038400000},\"grade\":\"A\",\"...</td>\n",
  2134. " <td>\"103-05\"</td>\n",
  2135. " </tr>\n",
  2136. " <tr>\n",
  2137. " <th>28</th>\n",
  2138. " <td>Manhattan</td>\n",
  2139. " <td>Turkish</td>\n",
  2140. " <td>The Country Cafe</td>\n",
  2141. " <td>40362715</td>\n",
  2142. " <td>{\"building\":\"60\",\"coord\":[-74.0085357,40.70620...</td>\n",
  2143. " <td>[{\"date\":{\"$date\":1411689600000},\"grade\":\"A\",\"...</td>\n",
  2144. " <td>\"60\"</td>\n",
  2145. " </tr>\n",
  2146. " <tr>\n",
  2147. " <th>29</th>\n",
  2148. " <td>Brooklyn</td>\n",
  2149. " <td>Caribbean</td>\n",
  2150. " <td>Shashemene Int'L Restaura</td>\n",
  2151. " <td>40362869</td>\n",
  2152. " <td>{\"building\":\"195\",\"coord\":[-73.9246028,40.6522...</td>\n",
  2153. " <td>[{\"date\":{\"$date\":1399939200000},\"grade\":\"A\",\"...</td>\n",
  2154. " <td>\"195\"</td>\n",
  2155. " </tr>\n",
  2156. " <tr>\n",
  2157. " <th>...</th>\n",
  2158. " <td>...</td>\n",
  2159. " <td>...</td>\n",
  2160. " <td>...</td>\n",
  2161. " <td>...</td>\n",
  2162. " <td>...</td>\n",
  2163. " <td>...</td>\n",
  2164. " <td>...</td>\n",
  2165. " </tr>\n",
  2166. " <tr>\n",
  2167. " <th>25329</th>\n",
  2168. " <td>Queens</td>\n",
  2169. " <td>Mexican</td>\n",
  2170. " <td>Bella'S Place</td>\n",
  2171. " <td>41646934</td>\n",
  2172. " <td>{\"building\":\"87-77\",\"coord\":[-73.8093635,40.70...</td>\n",
  2173. " <td>[{\"date\":{\"$date\":1413417600000},\"grade\":\"Z\",\"...</td>\n",
  2174. " <td>\"87-77\"</td>\n",
  2175. " </tr>\n",
  2176. " <tr>\n",
  2177. " <th>25330</th>\n",
  2178. " <td>Brooklyn</td>\n",
  2179. " <td>Caribbean</td>\n",
  2180. " <td>Perfect Touch Cuisine Ii</td>\n",
  2181. " <td>41646958</td>\n",
  2182. " <td>{\"building\":\"1148\",\"coord\":[-73.9508029,40.659...</td>\n",
  2183. " <td>[{\"date\":{\"$date\":1409270400000},\"grade\":\"B\",\"...</td>\n",
  2184. " <td>\"1148\"</td>\n",
  2185. " </tr>\n",
  2186. " <tr>\n",
  2187. " <th>25331</th>\n",
  2188. " <td>Brooklyn</td>\n",
  2189. " <td>American</td>\n",
  2190. " <td>Del Rio Diner</td>\n",
  2191. " <td>41646963</td>\n",
  2192. " <td>{\"building\":\"166\",\"coord\":[-73.98527659999999,...</td>\n",
  2193. " <td>[{\"date\":{\"$date\":1397001600000},\"grade\":\"A\",\"...</td>\n",
  2194. " <td>\"166\"</td>\n",
  2195. " </tr>\n",
  2196. " <tr>\n",
  2197. " <th>25332</th>\n",
  2198. " <td>Manhattan</td>\n",
  2199. " <td>Chinese</td>\n",
  2200. " <td>Fay Da Bakery</td>\n",
  2201. " <td>41646967</td>\n",
  2202. " <td>{\"building\":\"321\",\"coord\":[-74.0062401,40.7397...</td>\n",
  2203. " <td>[{\"date\":{\"$date\":1399852800000},\"grade\":\"A\",\"...</td>\n",
  2204. " <td>\"321\"</td>\n",
  2205. " </tr>\n",
  2206. " <tr>\n",
  2207. " <th>25333</th>\n",
  2208. " <td>Manhattan</td>\n",
  2209. " <td>Caribbean</td>\n",
  2210. " <td>Jahlookova</td>\n",
  2211. " <td>41646976</td>\n",
  2212. " <td>{\"building\":\"1962\",\"coord\":[-73.9405519,40.806...</td>\n",
  2213. " <td>[{\"date\":{\"$date\":1416960000000},\"grade\":\"A\",\"...</td>\n",
  2214. " <td>\"1962\"</td>\n",
  2215. " </tr>\n",
  2216. " <tr>\n",
  2217. " <th>25334</th>\n",
  2218. " <td>Manhattan</td>\n",
  2219. " <td>Delicatessen</td>\n",
  2220. " <td>Merci Market</td>\n",
  2221. " <td>41646979</td>\n",
  2222. " <td>{\"building\":\"350\",\"coord\":[-73.9922178,40.7579...</td>\n",
  2223. " <td>[{\"date\":{\"$date\":1420588800000},\"grade\":\"Z\",\"...</td>\n",
  2224. " <td>\"350\"</td>\n",
  2225. " </tr>\n",
  2226. " <tr>\n",
  2227. " <th>25335</th>\n",
  2228. " <td>Queens</td>\n",
  2229. " <td>Caribbean</td>\n",
  2230. " <td>Meat Veggies & Pasta Restaurant</td>\n",
  2231. " <td>41647006</td>\n",
  2232. " <td>{\"building\":\"118-16\",\"coord\":[-73.819531,40.67...</td>\n",
  2233. " <td>[{\"date\":{\"$date\":1415577600000},\"grade\":\"A\",\"...</td>\n",
  2234. " <td>\"118-16\"</td>\n",
  2235. " </tr>\n",
  2236. " <tr>\n",
  2237. " <th>25336</th>\n",
  2238. " <td>Manhattan</td>\n",
  2239. " <td>American</td>\n",
  2240. " <td>Toshi'S Living Room</td>\n",
  2241. " <td>41647012</td>\n",
  2242. " <td>{\"building\":\"9\",\"coord\":[-73.98931019999999,40...</td>\n",
  2243. " <td>[{\"date\":{\"$date\":1415750400000},\"grade\":\"A\",\"...</td>\n",
  2244. " <td>\"9\"</td>\n",
  2245. " </tr>\n",
  2246. " <tr>\n",
  2247. " <th>25337</th>\n",
  2248. " <td>Manhattan</td>\n",
  2249. " <td>American</td>\n",
  2250. " <td>Five Lamps Tavern</td>\n",
  2251. " <td>41647017</td>\n",
  2252. " <td>{\"building\":\"2756\",\"coord\":[-73.9675441,40.800...</td>\n",
  2253. " <td>[{\"date\":{\"$date\":1407283200000},\"grade\":\"C\",\"...</td>\n",
  2254. " <td>\"2756\"</td>\n",
  2255. " </tr>\n",
  2256. " <tr>\n",
  2257. " <th>25338</th>\n",
  2258. " <td>Queens</td>\n",
  2259. " <td>German</td>\n",
  2260. " <td>Max</td>\n",
  2261. " <td>41647039</td>\n",
  2262. " <td>{\"building\":\"47-02\",\"coord\":[-73.918047,40.765...</td>\n",
  2263. " <td>[{\"date\":{\"$date\":1416355200000},\"grade\":\"A\",\"...</td>\n",
  2264. " <td>\"47-02\"</td>\n",
  2265. " </tr>\n",
  2266. " <tr>\n",
  2267. " <th>25339</th>\n",
  2268. " <td>Queens</td>\n",
  2269. " <td>Chinese</td>\n",
  2270. " <td>Liang'S Kitchen Flushing Restaurant</td>\n",
  2271. " <td>41647062</td>\n",
  2272. " <td>{\"building\":\"13351\",\"coord\":[-73.832828,40.759...</td>\n",
  2273. " <td>[{\"date\":{\"$date\":1403308800000},\"grade\":\"B\",\"...</td>\n",
  2274. " <td>\"13351\"</td>\n",
  2275. " </tr>\n",
  2276. " <tr>\n",
  2277. " <th>25340</th>\n",
  2278. " <td>Bronx</td>\n",
  2279. " <td>Bangladeshi</td>\n",
  2280. " <td>Mehman Sweets Restaurant</td>\n",
  2281. " <td>41647098</td>\n",
  2282. " <td>{\"building\":\"1445\",\"coord\":[-73.8549994,40.835...</td>\n",
  2283. " <td>[{\"date\":{\"$date\":1406592000000},\"grade\":\"Z\",\"...</td>\n",
  2284. " <td>\"1445\"</td>\n",
  2285. " </tr>\n",
  2286. " <tr>\n",
  2287. " <th>25341</th>\n",
  2288. " <td>Queens</td>\n",
  2289. " <td>Mexican</td>\n",
  2290. " <td>Stephanie'S Mexican Bakery</td>\n",
  2291. " <td>41647129</td>\n",
  2292. " <td>{\"building\":\"37-56\",\"coord\":[-73.860018,40.752...</td>\n",
  2293. " <td>[{\"date\":{\"$date\":1408406400000},\"grade\":\"A\",\"...</td>\n",
  2294. " <td>\"37-56\"</td>\n",
  2295. " </tr>\n",
  2296. " <tr>\n",
  2297. " <th>25342</th>\n",
  2298. " <td>Bronx</td>\n",
  2299. " <td>Bakery</td>\n",
  2300. " <td>Bibbies Bakery</td>\n",
  2301. " <td>41647169</td>\n",
  2302. " <td>{\"building\":\"262\",\"coord\":[-73.9111954,40.8615...</td>\n",
  2303. " <td>[{\"date\":{\"$date\":1399507200000},\"grade\":\"A\",\"...</td>\n",
  2304. " <td>\"262\"</td>\n",
  2305. " </tr>\n",
  2306. " <tr>\n",
  2307. " <th>25343</th>\n",
  2308. " <td>Manhattan</td>\n",
  2309. " <td>Thai</td>\n",
  2310. " <td>Jaiya Thai & Oriental Restaurant</td>\n",
  2311. " <td>41647176</td>\n",
  2312. " <td>{\"building\":\"1553\",\"coord\":[-73.954548,40.7745...</td>\n",
  2313. " <td>[{\"date\":{\"$date\":1414540800000},\"grade\":\"A\",\"...</td>\n",
  2314. " <td>\"1553\"</td>\n",
  2315. " </tr>\n",
  2316. " <tr>\n",
  2317. " <th>25344</th>\n",
  2318. " <td>Manhattan</td>\n",
  2319. " <td>Chinese</td>\n",
  2320. " <td>China Wok</td>\n",
  2321. " <td>41647181</td>\n",
  2322. " <td>{\"building\":\"199\",\"coord\":[-73.9831015,40.7228...</td>\n",
  2323. " <td>[{\"date\":{\"$date\":1408060800000},\"grade\":\"B\",\"...</td>\n",
  2324. " <td>\"199\"</td>\n",
  2325. " </tr>\n",
  2326. " <tr>\n",
  2327. " <th>25345</th>\n",
  2328. " <td>Queens</td>\n",
  2329. " <td>Chinese</td>\n",
  2330. " <td>Xing Xing Chinese Restaurant</td>\n",
  2331. " <td>41647183</td>\n",
  2332. " <td>{\"building\":\"9712\",\"coord\":[-73.8194803,40.584...</td>\n",
  2333. " <td>[{\"date\":{\"$date\":1398729600000},\"grade\":\"A\",\"...</td>\n",
  2334. " <td>\"9712\"</td>\n",
  2335. " </tr>\n",
  2336. " <tr>\n",
  2337. " <th>25346</th>\n",
  2338. " <td>Queens</td>\n",
  2339. " <td>American</td>\n",
  2340. " <td>Packard Cafe</td>\n",
  2341. " <td>41647192</td>\n",
  2342. " <td>{\"building\":\"4134\",\"coord\":[-73.9400398,40.751...</td>\n",
  2343. " <td>[{\"date\":{\"$date\":1421193600000},\"grade\":\"A\",\"...</td>\n",
  2344. " <td>\"4134\"</td>\n",
  2345. " </tr>\n",
  2346. " <tr>\n",
  2347. " <th>25347</th>\n",
  2348. " <td>Queens</td>\n",
  2349. " <td>Pizza</td>\n",
  2350. " <td>Springfield & La Bari Pizzeria</td>\n",
  2351. " <td>41647210</td>\n",
  2352. " <td>{\"building\":\"136-13\",\"coord\":[-73.763352,40.67...</td>\n",
  2353. " <td>[{\"date\":{\"$date\":1419984000000},\"grade\":\"A\",\"...</td>\n",
  2354. " <td>\"136-13\"</td>\n",
  2355. " </tr>\n",
  2356. " <tr>\n",
  2357. " <th>25348</th>\n",
  2358. " <td>Queens</td>\n",
  2359. " <td>Caribbean</td>\n",
  2360. " <td>Dee'S Catering Services</td>\n",
  2361. " <td>41647221</td>\n",
  2362. " <td>{\"building\":\"217-15\",\"coord\":[-73.737423999999...</td>\n",
  2363. " <td>[{\"date\":{\"$date\":1401840000000},\"grade\":\"A\",\"...</td>\n",
  2364. " <td>\"217-15\"</td>\n",
  2365. " </tr>\n",
  2366. " <tr>\n",
  2367. " <th>25349</th>\n",
  2368. " <td>Manhattan</td>\n",
  2369. " <td>Asian</td>\n",
  2370. " <td>Jack'S Sliders And Sushi</td>\n",
  2371. " <td>41647241</td>\n",
  2372. " <td>{\"building\":\"171\",\"coord\":[-73.98581899999999,...</td>\n",
  2373. " <td>[{\"date\":{\"$date\":1417564800000},\"grade\":\"B\",\"...</td>\n",
  2374. " <td>\"171\"</td>\n",
  2375. " </tr>\n",
  2376. " <tr>\n",
  2377. " <th>25350</th>\n",
  2378. " <td>Brooklyn</td>\n",
  2379. " <td>Chinese</td>\n",
  2380. " <td>New Ming Fat Chinese Restaurant</td>\n",
  2381. " <td>41647292</td>\n",
  2382. " <td>{\"building\":\"1155\",\"coord\":[-73.8753401,40.672...</td>\n",
  2383. " <td>[{\"date\":{\"$date\":1394496000000},\"grade\":\"A\",\"...</td>\n",
  2384. " <td>\"1155\"</td>\n",
  2385. " </tr>\n",
  2386. " <tr>\n",
  2387. " <th>25351</th>\n",
  2388. " <td>Queens</td>\n",
  2389. " <td>Chinese</td>\n",
  2390. " <td>Noodle House</td>\n",
  2391. " <td>41647360</td>\n",
  2392. " <td>{\"building\":\"56-09\",\"coord\":[-73.7315557,40.76...</td>\n",
  2393. " <td>[{\"date\":{\"$date\":1404259200000},\"grade\":\"A\",\"...</td>\n",
  2394. " <td>\"56-09\"</td>\n",
  2395. " </tr>\n",
  2396. " <tr>\n",
  2397. " <th>25352</th>\n",
  2398. " <td>Brooklyn</td>\n",
  2399. " <td>Middle Eastern</td>\n",
  2400. " <td>Bahary Fish Market</td>\n",
  2401. " <td>41647370</td>\n",
  2402. " <td>{\"building\":\"484\",\"coord\":[-74.0212854,40.6334...</td>\n",
  2403. " <td>[{\"date\":{\"$date\":1401840000000},\"grade\":\"A\",\"...</td>\n",
  2404. " <td>\"484\"</td>\n",
  2405. " </tr>\n",
  2406. " <tr>\n",
  2407. " <th>25353</th>\n",
  2408. " <td>Queens</td>\n",
  2409. " <td>American</td>\n",
  2410. " <td>The Tin House Tavern</td>\n",
  2411. " <td>41647380</td>\n",
  2412. " <td>{\"building\":\"195-02\",\"coord\":[-73.785758,40.75...</td>\n",
  2413. " <td>[{\"date\":{\"$date\":1410134400000},\"grade\":\"A\",\"...</td>\n",
  2414. " <td>\"195-02\"</td>\n",
  2415. " </tr>\n",
  2416. " <tr>\n",
  2417. " <th>25354</th>\n",
  2418. " <td>Staten Island</td>\n",
  2419. " <td>Pizza</td>\n",
  2420. " <td>Ambrosino'S Ii</td>\n",
  2421. " <td>41647384</td>\n",
  2422. " <td>{\"building\":\"6410\",\"coord\":[-74.2150624,40.521...</td>\n",
  2423. " <td>[{\"date\":{\"$date\":1409616000000},\"grade\":\"A\",\"...</td>\n",
  2424. " <td>\"6410\"</td>\n",
  2425. " </tr>\n",
  2426. " <tr>\n",
  2427. " <th>25355</th>\n",
  2428. " <td>Bronx</td>\n",
  2429. " <td>Soul Food</td>\n",
  2430. " <td>Bruce'S Fish And Chips</td>\n",
  2431. " <td>41647392</td>\n",
  2432. " <td>{\"building\":\"500\",\"coord\":[-73.890768,40.85709...</td>\n",
  2433. " <td>[{\"date\":{\"$date\":1403568000000},\"grade\":\"A\",\"...</td>\n",
  2434. " <td>\"500\"</td>\n",
  2435. " </tr>\n",
  2436. " <tr>\n",
  2437. " <th>25356</th>\n",
  2438. " <td>Manhattan</td>\n",
  2439. " <td>Café/Coffee/Tea</td>\n",
  2440. " <td>Coffee Bean Tea & Leaf</td>\n",
  2441. " <td>41647399</td>\n",
  2442. " <td>{\"building\":\"2169\",\"coord\":[-73.981231,40.7822...</td>\n",
  2443. " <td>[{\"date\":{\"$date\":1406592000000},\"grade\":\"A\",\"...</td>\n",
  2444. " <td>\"2169\"</td>\n",
  2445. " </tr>\n",
  2446. " <tr>\n",
  2447. " <th>25357</th>\n",
  2448. " <td>Manhattan</td>\n",
  2449. " <td>Ice Cream, Gelato, Yogurt, Ices</td>\n",
  2450. " <td>Gelato Ti Amo</td>\n",
  2451. " <td>41647482</td>\n",
  2452. " <td>{\"building\":\"68\",\"coord\":[-73.9892179,40.72594...</td>\n",
  2453. " <td>[{\"date\":{\"$date\":1403913600000},\"grade\":\"A\",\"...</td>\n",
  2454. " <td>\"68\"</td>\n",
  2455. " </tr>\n",
  2456. " <tr>\n",
  2457. " <th>25358</th>\n",
  2458. " <td>Queens</td>\n",
  2459. " <td>Caribbean</td>\n",
  2460. " <td>Rockaway Roti Shop</td>\n",
  2461. " <td>41647521</td>\n",
  2462. " <td>{\"building\":\"12221\",\"coord\":[-73.8032425999999...</td>\n",
  2463. " <td>[{\"date\":{\"$date\":1418428800000},\"grade\":\"A\",\"...</td>\n",
  2464. " <td>\"12221\"</td>\n",
  2465. " </tr>\n",
  2466. " </tbody>\n",
  2467. "</table>\n",
  2468. "<p>25359 rows × 7 columns</p>\n",
  2469. "</div>"
  2470. ],
  2471. "text/plain": [
  2472. " borough cuisine \\\n",
  2473. "0 Bronx Bakery \n",
  2474. "1 Brooklyn Hamburgers \n",
  2475. "2 Manhattan Irish \n",
  2476. "3 Brooklyn American \n",
  2477. "4 Queens Jewish/Kosher \n",
  2478. "5 Queens American \n",
  2479. "6 Staten Island Jewish/Kosher \n",
  2480. "7 Brooklyn Delicatessen \n",
  2481. "8 Brooklyn American \n",
  2482. "9 Brooklyn Ice Cream, Gelato, Yogurt, Ices \n",
  2483. "10 Bronx American \n",
  2484. "11 Brooklyn American \n",
  2485. "12 Brooklyn Chinese \n",
  2486. "13 Manhattan American \n",
  2487. "14 Brooklyn Jewish/Kosher \n",
  2488. "15 Brooklyn Ice Cream, Gelato, Yogurt, Ices \n",
  2489. "16 Queens Ice Cream, Gelato, Yogurt, Ices \n",
  2490. "17 Brooklyn Delicatessen \n",
  2491. "18 Manhattan American \n",
  2492. "19 Brooklyn American \n",
  2493. "20 Queens Delicatessen \n",
  2494. "21 Manhattan Delicatessen \n",
  2495. "22 Queens Delicatessen \n",
  2496. "23 Manhattan Chicken \n",
  2497. "24 Manhattan American \n",
  2498. "25 Manhattan American \n",
  2499. "26 Brooklyn Hamburgers \n",
  2500. "27 Queens Chinese \n",
  2501. "28 Manhattan Turkish \n",
  2502. "29 Brooklyn Caribbean \n",
  2503. "... ... ... \n",
  2504. "25329 Queens Mexican \n",
  2505. "25330 Brooklyn Caribbean \n",
  2506. "25331 Brooklyn American \n",
  2507. "25332 Manhattan Chinese \n",
  2508. "25333 Manhattan Caribbean \n",
  2509. "25334 Manhattan Delicatessen \n",
  2510. "25335 Queens Caribbean \n",
  2511. "25336 Manhattan American \n",
  2512. "25337 Manhattan American \n",
  2513. "25338 Queens German \n",
  2514. "25339 Queens Chinese \n",
  2515. "25340 Bronx Bangladeshi \n",
  2516. "25341 Queens Mexican \n",
  2517. "25342 Bronx Bakery \n",
  2518. "25343 Manhattan Thai \n",
  2519. "25344 Manhattan Chinese \n",
  2520. "25345 Queens Chinese \n",
  2521. "25346 Queens American \n",
  2522. "25347 Queens Pizza \n",
  2523. "25348 Queens Caribbean \n",
  2524. "25349 Manhattan Asian \n",
  2525. "25350 Brooklyn Chinese \n",
  2526. "25351 Queens Chinese \n",
  2527. "25352 Brooklyn Middle Eastern \n",
  2528. "25353 Queens American \n",
  2529. "25354 Staten Island Pizza \n",
  2530. "25355 Bronx Soul Food \n",
  2531. "25356 Manhattan Café/Coffee/Tea \n",
  2532. "25357 Manhattan Ice Cream, Gelato, Yogurt, Ices \n",
  2533. "25358 Queens Caribbean \n",
  2534. "\n",
  2535. " name restaurant_id \\\n",
  2536. "0 Morris Park Bake Shop 30075445 \n",
  2537. "1 Wendy'S 30112340 \n",
  2538. "2 Dj Reynolds Pub And Restaurant 30191841 \n",
  2539. "3 Riviera Caterer 40356018 \n",
  2540. "4 Tov Kosher Kitchen 40356068 \n",
  2541. "5 Brunos On The Boulevard 40356151 \n",
  2542. "6 Kosher Island 40356442 \n",
  2543. "7 Wilken'S Fine Food 40356483 \n",
  2544. "8 Regina Caterers 40356649 \n",
  2545. "9 Taste The Tropics Ice Cream 40356731 \n",
  2546. "10 Wild Asia 40357217 \n",
  2547. "11 C & C Catering Service 40357437 \n",
  2548. "12 May May Kitchen 40358429 \n",
  2549. "13 1 East 66Th Street Kitchen 40359480 \n",
  2550. "14 Seuda Foods 40360045 \n",
  2551. "15 Carvel Ice Cream 40360076 \n",
  2552. "16 Carvel Ice Cream 40361322 \n",
  2553. "17 Nordic Delicacies 40361390 \n",
  2554. "18 Glorious Food 40361521 \n",
  2555. "19 The Movable Feast 40361606 \n",
  2556. "20 Sal'S Deli 40361618 \n",
  2557. "21 Bully'S Deli 40361708 \n",
  2558. "22 Steve Chu'S Deli & Grocery 40361998 \n",
  2559. "23 Harriet'S Kitchen 40362098 \n",
  2560. "24 P & S Deli Grocery 40362264 \n",
  2561. "25 Angelika Film Center 40362274 \n",
  2562. "26 White Castle 40362344 \n",
  2563. "27 Ho Mei Restaurant 40362432 \n",
  2564. "28 The Country Cafe 40362715 \n",
  2565. "29 Shashemene Int'L Restaura 40362869 \n",
  2566. "... ... ... \n",
  2567. "25329 Bella'S Place 41646934 \n",
  2568. "25330 Perfect Touch Cuisine Ii 41646958 \n",
  2569. "25331 Del Rio Diner 41646963 \n",
  2570. "25332 Fay Da Bakery 41646967 \n",
  2571. "25333 Jahlookova 41646976 \n",
  2572. "25334 Merci Market 41646979 \n",
  2573. "25335 Meat Veggies & Pasta Restaurant 41647006 \n",
  2574. "25336 Toshi'S Living Room 41647012 \n",
  2575. "25337 Five Lamps Tavern 41647017 \n",
  2576. "25338 Max 41647039 \n",
  2577. "25339 Liang'S Kitchen Flushing Restaurant 41647062 \n",
  2578. "25340 Mehman Sweets Restaurant 41647098 \n",
  2579. "25341 Stephanie'S Mexican Bakery 41647129 \n",
  2580. "25342 Bibbies Bakery 41647169 \n",
  2581. "25343 Jaiya Thai & Oriental Restaurant 41647176 \n",
  2582. "25344 China Wok 41647181 \n",
  2583. "25345 Xing Xing Chinese Restaurant 41647183 \n",
  2584. "25346 Packard Cafe 41647192 \n",
  2585. "25347 Springfield & La Bari Pizzeria 41647210 \n",
  2586. "25348 Dee'S Catering Services 41647221 \n",
  2587. "25349 Jack'S Sliders And Sushi 41647241 \n",
  2588. "25350 New Ming Fat Chinese Restaurant 41647292 \n",
  2589. "25351 Noodle House 41647360 \n",
  2590. "25352 Bahary Fish Market 41647370 \n",
  2591. "25353 The Tin House Tavern 41647380 \n",
  2592. "25354 Ambrosino'S Ii 41647384 \n",
  2593. "25355 Bruce'S Fish And Chips 41647392 \n",
  2594. "25356 Coffee Bean Tea & Leaf 41647399 \n",
  2595. "25357 Gelato Ti Amo 41647482 \n",
  2596. "25358 Rockaway Roti Shop 41647521 \n",
  2597. "\n",
  2598. " address_json \\\n",
  2599. "0 {\"building\":\"1007\",\"coord\":[-73.856077,40.8484... \n",
  2600. "1 {\"building\":\"469\",\"coord\":[-73.961704,40.66294... \n",
  2601. "2 {\"building\":\"351\",\"coord\":[-73.98513559999999,... \n",
  2602. "3 {\"building\":\"2780\",\"coord\":[-73.98241999999999... \n",
  2603. "4 {\"building\":\"97-22\",\"coord\":[-73.8601152,40.73... \n",
  2604. "5 {\"building\":\"8825\",\"coord\":[-73.8803827,40.764... \n",
  2605. "6 {\"building\":\"2206\",\"coord\":[-74.1377286,40.611... \n",
  2606. "7 {\"building\":\"7114\",\"coord\":[-73.9068506,40.619... \n",
  2607. "8 {\"building\":\"6409\",\"coord\":[-74.00528899999999... \n",
  2608. "9 {\"building\":\"1839\",\"coord\":[-73.9482609,40.640... \n",
  2609. "10 {\"building\":\"2300\",\"coord\":[-73.8786113,40.850... \n",
  2610. "11 {\"building\":\"7715\",\"coord\":[-73.9973325,40.611... \n",
  2611. "12 {\"building\":\"1269\",\"coord\":[-73.871194,40.6730... \n",
  2612. "13 {\"building\":\"1\",\"coord\":[-73.96926909999999,40... \n",
  2613. "14 {\"building\":\"705\",\"coord\":[-73.9653967,40.6064... \n",
  2614. "15 {\"building\":\"203\",\"coord\":[-73.97822040000001,... \n",
  2615. "16 {\"building\":\"265-15\",\"coord\":[-73.7032601,40.7... \n",
  2616. "17 {\"building\":\"6909\",\"coord\":[-74.0259567,40.635... \n",
  2617. "18 {\"building\":\"522\",\"coord\":[-73.95171,40.767461... \n",
  2618. "19 {\"building\":\"284\",\"coord\":[-73.9829239,40.6580... \n",
  2619. "20 {\"building\":\"129-08\",\"coord\":[-73.839297,40.78... \n",
  2620. "21 {\"building\":\"759\",\"coord\":[-73.9925306,40.7309... \n",
  2621. "22 {\"building\":\"3406\",\"coord\":[-73.94024739999999... \n",
  2622. "23 {\"building\":\"502\",\"coord\":[-73.976112,40.78671... \n",
  2623. "24 {\"building\":\"730\",\"coord\":[-73.96805719999999,... \n",
  2624. "25 {\"building\":\"18\",\"coord\":[-73.996984,40.72589]... \n",
  2625. "26 {\"building\":\"531\",\"coord\":[-73.9634876,40.6940... \n",
  2626. "27 {\"building\":\"103-05\",\"coord\":[-73.8642349,40.7... \n",
  2627. "28 {\"building\":\"60\",\"coord\":[-74.0085357,40.70620... \n",
  2628. "29 {\"building\":\"195\",\"coord\":[-73.9246028,40.6522... \n",
  2629. "... ... \n",
  2630. "25329 {\"building\":\"87-77\",\"coord\":[-73.8093635,40.70... \n",
  2631. "25330 {\"building\":\"1148\",\"coord\":[-73.9508029,40.659... \n",
  2632. "25331 {\"building\":\"166\",\"coord\":[-73.98527659999999,... \n",
  2633. "25332 {\"building\":\"321\",\"coord\":[-74.0062401,40.7397... \n",
  2634. "25333 {\"building\":\"1962\",\"coord\":[-73.9405519,40.806... \n",
  2635. "25334 {\"building\":\"350\",\"coord\":[-73.9922178,40.7579... \n",
  2636. "25335 {\"building\":\"118-16\",\"coord\":[-73.819531,40.67... \n",
  2637. "25336 {\"building\":\"9\",\"coord\":[-73.98931019999999,40... \n",
  2638. "25337 {\"building\":\"2756\",\"coord\":[-73.9675441,40.800... \n",
  2639. "25338 {\"building\":\"47-02\",\"coord\":[-73.918047,40.765... \n",
  2640. "25339 {\"building\":\"13351\",\"coord\":[-73.832828,40.759... \n",
  2641. "25340 {\"building\":\"1445\",\"coord\":[-73.8549994,40.835... \n",
  2642. "25341 {\"building\":\"37-56\",\"coord\":[-73.860018,40.752... \n",
  2643. "25342 {\"building\":\"262\",\"coord\":[-73.9111954,40.8615... \n",
  2644. "25343 {\"building\":\"1553\",\"coord\":[-73.954548,40.7745... \n",
  2645. "25344 {\"building\":\"199\",\"coord\":[-73.9831015,40.7228... \n",
  2646. "25345 {\"building\":\"9712\",\"coord\":[-73.8194803,40.584... \n",
  2647. "25346 {\"building\":\"4134\",\"coord\":[-73.9400398,40.751... \n",
  2648. "25347 {\"building\":\"136-13\",\"coord\":[-73.763352,40.67... \n",
  2649. "25348 {\"building\":\"217-15\",\"coord\":[-73.737423999999... \n",
  2650. "25349 {\"building\":\"171\",\"coord\":[-73.98581899999999,... \n",
  2651. "25350 {\"building\":\"1155\",\"coord\":[-73.8753401,40.672... \n",
  2652. "25351 {\"building\":\"56-09\",\"coord\":[-73.7315557,40.76... \n",
  2653. "25352 {\"building\":\"484\",\"coord\":[-74.0212854,40.6334... \n",
  2654. "25353 {\"building\":\"195-02\",\"coord\":[-73.785758,40.75... \n",
  2655. "25354 {\"building\":\"6410\",\"coord\":[-74.2150624,40.521... \n",
  2656. "25355 {\"building\":\"500\",\"coord\":[-73.890768,40.85709... \n",
  2657. "25356 {\"building\":\"2169\",\"coord\":[-73.981231,40.7822... \n",
  2658. "25357 {\"building\":\"68\",\"coord\":[-73.9892179,40.72594... \n",
  2659. "25358 {\"building\":\"12221\",\"coord\":[-73.8032425999999... \n",
  2660. "\n",
  2661. " grades_json building \n",
  2662. "0 [{\"date\":{\"$date\":1393804800000},\"grade\":\"A\",\"... \"1007\" \n",
  2663. "1 [{\"date\":{\"$date\":1419897600000},\"grade\":\"A\",\"... \"469\" \n",
  2664. "2 [{\"date\":{\"$date\":1409961600000},\"grade\":\"A\",\"... \"351\" \n",
  2665. "3 [{\"date\":{\"$date\":1402358400000},\"grade\":\"A\",\"... \"2780\" \n",
  2666. "4 [{\"date\":{\"$date\":1416787200000},\"grade\":\"Z\",\"... \"97-22\" \n",
  2667. "5 [{\"date\":{\"$date\":1416009600000},\"grade\":\"Z\",\"... \"8825\" \n",
  2668. "6 [{\"date\":{\"$date\":1412553600000},\"grade\":\"A\",\"... \"2206\" \n",
  2669. "7 [{\"date\":{\"$date\":1401321600000},\"grade\":\"A\",\"... \"7114\" \n",
  2670. "8 [{\"date\":{\"$date\":1405641600000},\"grade\":\"A\",\"... \"6409\" \n",
  2671. "9 [{\"date\":{\"$date\":1405296000000},\"grade\":\"A\",\"... \"1839\" \n",
  2672. "10 [{\"date\":{\"$date\":1401235200000},\"grade\":\"A\",\"... \"2300\" \n",
  2673. "11 [{\"date\":{\"$date\":1397606400000},\"grade\":\"A\",\"... \"7715\" \n",
  2674. "12 [{\"date\":{\"$date\":1410825600000},\"grade\":\"B\",\"... \"1269\" \n",
  2675. "13 [{\"date\":{\"$date\":1399420800000},\"grade\":\"A\",\"... \"1\" \n",
  2676. "14 [{\"date\":{\"$date\":1415577600000},\"grade\":\"A\",\"... \"705\" \n",
  2677. "15 [{\"date\":{\"$date\":1391990400000},\"grade\":\"A\",\"... \"203\" \n",
  2678. "16 [{\"date\":{\"$date\":1414454400000},\"grade\":\"A\",\"... \"265-15\" \n",
  2679. "17 [{\"date\":{\"$date\":1408579200000},\"grade\":\"A\",\"... \"6909\" \n",
  2680. "18 [{\"date\":{\"$date\":1409616000000},\"grade\":\"A\",\"... \"522\" \n",
  2681. "19 [{\"date\":{\"$date\":1416355200000},\"grade\":\"A\",\"... \"284\" \n",
  2682. "20 [{\"date\":{\"$date\":1408147200000},\"grade\":\"A\",\"... \"129-08\" \n",
  2683. "21 [{\"date\":{\"$date\":1390262400000},\"grade\":\"A\",\"... \"759\" \n",
  2684. "22 [{\"date\":{\"$date\":1395187200000},\"grade\":\"A\",\"... \"3406\" \n",
  2685. "23 [{\"date\":{\"$date\":1410739200000},\"grade\":\"A\",\"... \"502\" \n",
  2686. "24 [{\"date\":{\"$date\":1410480000000},\"grade\":\"B\",\"... \"730\" \n",
  2687. "25 [{\"date\":{\"$date\":1396483200000},\"grade\":\"A\",\"... \"18\" \n",
  2688. "26 [{\"date\":{\"$date\":1395100800000},\"grade\":\"A\",\"... \"531\" \n",
  2689. "27 [{\"date\":{\"$date\":1398038400000},\"grade\":\"A\",\"... \"103-05\" \n",
  2690. "28 [{\"date\":{\"$date\":1411689600000},\"grade\":\"A\",\"... \"60\" \n",
  2691. "29 [{\"date\":{\"$date\":1399939200000},\"grade\":\"A\",\"... \"195\" \n",
  2692. "... ... ... \n",
  2693. "25329 [{\"date\":{\"$date\":1413417600000},\"grade\":\"Z\",\"... \"87-77\" \n",
  2694. "25330 [{\"date\":{\"$date\":1409270400000},\"grade\":\"B\",\"... \"1148\" \n",
  2695. "25331 [{\"date\":{\"$date\":1397001600000},\"grade\":\"A\",\"... \"166\" \n",
  2696. "25332 [{\"date\":{\"$date\":1399852800000},\"grade\":\"A\",\"... \"321\" \n",
  2697. "25333 [{\"date\":{\"$date\":1416960000000},\"grade\":\"A\",\"... \"1962\" \n",
  2698. "25334 [{\"date\":{\"$date\":1420588800000},\"grade\":\"Z\",\"... \"350\" \n",
  2699. "25335 [{\"date\":{\"$date\":1415577600000},\"grade\":\"A\",\"... \"118-16\" \n",
  2700. "25336 [{\"date\":{\"$date\":1415750400000},\"grade\":\"A\",\"... \"9\" \n",
  2701. "25337 [{\"date\":{\"$date\":1407283200000},\"grade\":\"C\",\"... \"2756\" \n",
  2702. "25338 [{\"date\":{\"$date\":1416355200000},\"grade\":\"A\",\"... \"47-02\" \n",
  2703. "25339 [{\"date\":{\"$date\":1403308800000},\"grade\":\"B\",\"... \"13351\" \n",
  2704. "25340 [{\"date\":{\"$date\":1406592000000},\"grade\":\"Z\",\"... \"1445\" \n",
  2705. "25341 [{\"date\":{\"$date\":1408406400000},\"grade\":\"A\",\"... \"37-56\" \n",
  2706. "25342 [{\"date\":{\"$date\":1399507200000},\"grade\":\"A\",\"... \"262\" \n",
  2707. "25343 [{\"date\":{\"$date\":1414540800000},\"grade\":\"A\",\"... \"1553\" \n",
  2708. "25344 [{\"date\":{\"$date\":1408060800000},\"grade\":\"B\",\"... \"199\" \n",
  2709. "25345 [{\"date\":{\"$date\":1398729600000},\"grade\":\"A\",\"... \"9712\" \n",
  2710. "25346 [{\"date\":{\"$date\":1421193600000},\"grade\":\"A\",\"... \"4134\" \n",
  2711. "25347 [{\"date\":{\"$date\":1419984000000},\"grade\":\"A\",\"... \"136-13\" \n",
  2712. "25348 [{\"date\":{\"$date\":1401840000000},\"grade\":\"A\",\"... \"217-15\" \n",
  2713. "25349 [{\"date\":{\"$date\":1417564800000},\"grade\":\"B\",\"... \"171\" \n",
  2714. "25350 [{\"date\":{\"$date\":1394496000000},\"grade\":\"A\",\"... \"1155\" \n",
  2715. "25351 [{\"date\":{\"$date\":1404259200000},\"grade\":\"A\",\"... \"56-09\" \n",
  2716. "25352 [{\"date\":{\"$date\":1401840000000},\"grade\":\"A\",\"... \"484\" \n",
  2717. "25353 [{\"date\":{\"$date\":1410134400000},\"grade\":\"A\",\"... \"195-02\" \n",
  2718. "25354 [{\"date\":{\"$date\":1409616000000},\"grade\":\"A\",\"... \"6410\" \n",
  2719. "25355 [{\"date\":{\"$date\":1403568000000},\"grade\":\"A\",\"... \"500\" \n",
  2720. "25356 [{\"date\":{\"$date\":1406592000000},\"grade\":\"A\",\"... \"2169\" \n",
  2721. "25357 [{\"date\":{\"$date\":1403913600000},\"grade\":\"A\",\"... \"68\" \n",
  2722. "25358 [{\"date\":{\"$date\":1418428800000},\"grade\":\"A\",\"... \"12221\" \n",
  2723. "\n",
  2724. "[25359 rows x 7 columns]"
  2725. ]
  2726. },
  2727. "execution_count": 21,
  2728. "metadata": {},
  2729. "output_type": "execute_result"
  2730. }
  2731. ],
  2732. "source": [
  2733. "query = \"select *, address_json::json->'building' as building from restaurant_from_df\"\n",
  2734. "show_query_response(query)"
  2735. ]
  2736. },
  2737. {
  2738. "cell_type": "code",
  2739. "execution_count": 36,
  2740. "metadata": {},
  2741. "outputs": [
  2742. {
  2743. "data": {
  2744. "text/html": [
  2745. "<div>\n",
  2746. "<style>\n",
  2747. " .dataframe thead tr:only-child th {\n",
  2748. " text-align: right;\n",
  2749. " }\n",
  2750. "\n",
  2751. " .dataframe thead th {\n",
  2752. " text-align: left;\n",
  2753. " }\n",
  2754. "\n",
  2755. " .dataframe tbody tr th {\n",
  2756. " vertical-align: top;\n",
  2757. " }\n",
  2758. "</style>\n",
  2759. "<table border=\"1\" class=\"dataframe\">\n",
  2760. " <thead>\n",
  2761. " <tr style=\"text-align: right;\">\n",
  2762. " <th></th>\n",
  2763. " <th>building</th>\n",
  2764. " </tr>\n",
  2765. " </thead>\n",
  2766. " <tbody>\n",
  2767. " <tr>\n",
  2768. " <th>0</th>\n",
  2769. " <td>-73.856077</td>\n",
  2770. " </tr>\n",
  2771. " <tr>\n",
  2772. " <th>1</th>\n",
  2773. " <td>-73.961704</td>\n",
  2774. " </tr>\n",
  2775. " <tr>\n",
  2776. " <th>2</th>\n",
  2777. " <td>-73.98513559999999</td>\n",
  2778. " </tr>\n",
  2779. " <tr>\n",
  2780. " <th>3</th>\n",
  2781. " <td>-73.98241999999999</td>\n",
  2782. " </tr>\n",
  2783. " <tr>\n",
  2784. " <th>4</th>\n",
  2785. " <td>-73.8601152</td>\n",
  2786. " </tr>\n",
  2787. " <tr>\n",
  2788. " <th>5</th>\n",
  2789. " <td>-73.8803827</td>\n",
  2790. " </tr>\n",
  2791. " <tr>\n",
  2792. " <th>6</th>\n",
  2793. " <td>-74.1377286</td>\n",
  2794. " </tr>\n",
  2795. " <tr>\n",
  2796. " <th>7</th>\n",
  2797. " <td>-73.9068506</td>\n",
  2798. " </tr>\n",
  2799. " <tr>\n",
  2800. " <th>8</th>\n",
  2801. " <td>-74.00528899999999</td>\n",
  2802. " </tr>\n",
  2803. " <tr>\n",
  2804. " <th>9</th>\n",
  2805. " <td>-73.9482609</td>\n",
  2806. " </tr>\n",
  2807. " <tr>\n",
  2808. " <th>10</th>\n",
  2809. " <td>-73.8786113</td>\n",
  2810. " </tr>\n",
  2811. " <tr>\n",
  2812. " <th>11</th>\n",
  2813. " <td>-73.9973325</td>\n",
  2814. " </tr>\n",
  2815. " <tr>\n",
  2816. " <th>12</th>\n",
  2817. " <td>-73.871194</td>\n",
  2818. " </tr>\n",
  2819. " <tr>\n",
  2820. " <th>13</th>\n",
  2821. " <td>-73.96926909999999</td>\n",
  2822. " </tr>\n",
  2823. " <tr>\n",
  2824. " <th>14</th>\n",
  2825. " <td>-73.9653967</td>\n",
  2826. " </tr>\n",
  2827. " <tr>\n",
  2828. " <th>15</th>\n",
  2829. " <td>-73.97822040000001</td>\n",
  2830. " </tr>\n",
  2831. " <tr>\n",
  2832. " <th>16</th>\n",
  2833. " <td>-73.7032601</td>\n",
  2834. " </tr>\n",
  2835. " <tr>\n",
  2836. " <th>17</th>\n",
  2837. " <td>-74.0259567</td>\n",
  2838. " </tr>\n",
  2839. " <tr>\n",
  2840. " <th>18</th>\n",
  2841. " <td>-73.95171</td>\n",
  2842. " </tr>\n",
  2843. " <tr>\n",
  2844. " <th>19</th>\n",
  2845. " <td>-73.9829239</td>\n",
  2846. " </tr>\n",
  2847. " <tr>\n",
  2848. " <th>20</th>\n",
  2849. " <td>-73.839297</td>\n",
  2850. " </tr>\n",
  2851. " <tr>\n",
  2852. " <th>21</th>\n",
  2853. " <td>-73.9925306</td>\n",
  2854. " </tr>\n",
  2855. " <tr>\n",
  2856. " <th>22</th>\n",
  2857. " <td>-73.94024739999999</td>\n",
  2858. " </tr>\n",
  2859. " <tr>\n",
  2860. " <th>23</th>\n",
  2861. " <td>-73.976112</td>\n",
  2862. " </tr>\n",
  2863. " <tr>\n",
  2864. " <th>24</th>\n",
  2865. " <td>-73.96805719999999</td>\n",
  2866. " </tr>\n",
  2867. " <tr>\n",
  2868. " <th>25</th>\n",
  2869. " <td>-73.996984</td>\n",
  2870. " </tr>\n",
  2871. " <tr>\n",
  2872. " <th>26</th>\n",
  2873. " <td>-73.9634876</td>\n",
  2874. " </tr>\n",
  2875. " <tr>\n",
  2876. " <th>27</th>\n",
  2877. " <td>-73.8642349</td>\n",
  2878. " </tr>\n",
  2879. " <tr>\n",
  2880. " <th>28</th>\n",
  2881. " <td>-74.0085357</td>\n",
  2882. " </tr>\n",
  2883. " <tr>\n",
  2884. " <th>29</th>\n",
  2885. " <td>-73.9246028</td>\n",
  2886. " </tr>\n",
  2887. " <tr>\n",
  2888. " <th>...</th>\n",
  2889. " <td>...</td>\n",
  2890. " </tr>\n",
  2891. " <tr>\n",
  2892. " <th>25329</th>\n",
  2893. " <td>-73.8093635</td>\n",
  2894. " </tr>\n",
  2895. " <tr>\n",
  2896. " <th>25330</th>\n",
  2897. " <td>-73.9508029</td>\n",
  2898. " </tr>\n",
  2899. " <tr>\n",
  2900. " <th>25331</th>\n",
  2901. " <td>-73.98527659999999</td>\n",
  2902. " </tr>\n",
  2903. " <tr>\n",
  2904. " <th>25332</th>\n",
  2905. " <td>-74.0062401</td>\n",
  2906. " </tr>\n",
  2907. " <tr>\n",
  2908. " <th>25333</th>\n",
  2909. " <td>-73.9405519</td>\n",
  2910. " </tr>\n",
  2911. " <tr>\n",
  2912. " <th>25334</th>\n",
  2913. " <td>-73.9922178</td>\n",
  2914. " </tr>\n",
  2915. " <tr>\n",
  2916. " <th>25335</th>\n",
  2917. " <td>-73.819531</td>\n",
  2918. " </tr>\n",
  2919. " <tr>\n",
  2920. " <th>25336</th>\n",
  2921. " <td>-73.98931019999999</td>\n",
  2922. " </tr>\n",
  2923. " <tr>\n",
  2924. " <th>25337</th>\n",
  2925. " <td>-73.9675441</td>\n",
  2926. " </tr>\n",
  2927. " <tr>\n",
  2928. " <th>25338</th>\n",
  2929. " <td>-73.918047</td>\n",
  2930. " </tr>\n",
  2931. " <tr>\n",
  2932. " <th>25339</th>\n",
  2933. " <td>-73.832828</td>\n",
  2934. " </tr>\n",
  2935. " <tr>\n",
  2936. " <th>25340</th>\n",
  2937. " <td>-73.8549994</td>\n",
  2938. " </tr>\n",
  2939. " <tr>\n",
  2940. " <th>25341</th>\n",
  2941. " <td>-73.860018</td>\n",
  2942. " </tr>\n",
  2943. " <tr>\n",
  2944. " <th>25342</th>\n",
  2945. " <td>-73.9111954</td>\n",
  2946. " </tr>\n",
  2947. " <tr>\n",
  2948. " <th>25343</th>\n",
  2949. " <td>-73.954548</td>\n",
  2950. " </tr>\n",
  2951. " <tr>\n",
  2952. " <th>25344</th>\n",
  2953. " <td>-73.9831015</td>\n",
  2954. " </tr>\n",
  2955. " <tr>\n",
  2956. " <th>25345</th>\n",
  2957. " <td>-73.8194803</td>\n",
  2958. " </tr>\n",
  2959. " <tr>\n",
  2960. " <th>25346</th>\n",
  2961. " <td>-73.9400398</td>\n",
  2962. " </tr>\n",
  2963. " <tr>\n",
  2964. " <th>25347</th>\n",
  2965. " <td>-73.763352</td>\n",
  2966. " </tr>\n",
  2967. " <tr>\n",
  2968. " <th>25348</th>\n",
  2969. " <td>-73.73742399999999</td>\n",
  2970. " </tr>\n",
  2971. " <tr>\n",
  2972. " <th>25349</th>\n",
  2973. " <td>-73.98581899999999</td>\n",
  2974. " </tr>\n",
  2975. " <tr>\n",
  2976. " <th>25350</th>\n",
  2977. " <td>-73.8753401</td>\n",
  2978. " </tr>\n",
  2979. " <tr>\n",
  2980. " <th>25351</th>\n",
  2981. " <td>-73.7315557</td>\n",
  2982. " </tr>\n",
  2983. " <tr>\n",
  2984. " <th>25352</th>\n",
  2985. " <td>-74.0212854</td>\n",
  2986. " </tr>\n",
  2987. " <tr>\n",
  2988. " <th>25353</th>\n",
  2989. " <td>-73.785758</td>\n",
  2990. " </tr>\n",
  2991. " <tr>\n",
  2992. " <th>25354</th>\n",
  2993. " <td>-74.2150624</td>\n",
  2994. " </tr>\n",
  2995. " <tr>\n",
  2996. " <th>25355</th>\n",
  2997. " <td>-73.890768</td>\n",
  2998. " </tr>\n",
  2999. " <tr>\n",
  3000. " <th>25356</th>\n",
  3001. " <td>-73.981231</td>\n",
  3002. " </tr>\n",
  3003. " <tr>\n",
  3004. " <th>25357</th>\n",
  3005. " <td>-73.9892179</td>\n",
  3006. " </tr>\n",
  3007. " <tr>\n",
  3008. " <th>25358</th>\n",
  3009. " <td>-73.80324259999999</td>\n",
  3010. " </tr>\n",
  3011. " </tbody>\n",
  3012. "</table>\n",
  3013. "<p>25359 rows × 1 columns</p>\n",
  3014. "</div>"
  3015. ],
  3016. "text/plain": [
  3017. " building\n",
  3018. "0 -73.856077\n",
  3019. "1 -73.961704\n",
  3020. "2 -73.98513559999999\n",
  3021. "3 -73.98241999999999\n",
  3022. "4 -73.8601152\n",
  3023. "5 -73.8803827\n",
  3024. "6 -74.1377286\n",
  3025. "7 -73.9068506\n",
  3026. "8 -74.00528899999999\n",
  3027. "9 -73.9482609\n",
  3028. "10 -73.8786113\n",
  3029. "11 -73.9973325\n",
  3030. "12 -73.871194\n",
  3031. "13 -73.96926909999999\n",
  3032. "14 -73.9653967\n",
  3033. "15 -73.97822040000001\n",
  3034. "16 -73.7032601\n",
  3035. "17 -74.0259567\n",
  3036. "18 -73.95171\n",
  3037. "19 -73.9829239\n",
  3038. "20 -73.839297\n",
  3039. "21 -73.9925306\n",
  3040. "22 -73.94024739999999\n",
  3041. "23 -73.976112\n",
  3042. "24 -73.96805719999999\n",
  3043. "25 -73.996984\n",
  3044. "26 -73.9634876\n",
  3045. "27 -73.8642349\n",
  3046. "28 -74.0085357\n",
  3047. "29 -73.9246028\n",
  3048. "... ...\n",
  3049. "25329 -73.8093635\n",
  3050. "25330 -73.9508029\n",
  3051. "25331 -73.98527659999999\n",
  3052. "25332 -74.0062401\n",
  3053. "25333 -73.9405519\n",
  3054. "25334 -73.9922178\n",
  3055. "25335 -73.819531\n",
  3056. "25336 -73.98931019999999\n",
  3057. "25337 -73.9675441\n",
  3058. "25338 -73.918047\n",
  3059. "25339 -73.832828\n",
  3060. "25340 -73.8549994\n",
  3061. "25341 -73.860018\n",
  3062. "25342 -73.9111954\n",
  3063. "25343 -73.954548\n",
  3064. "25344 -73.9831015\n",
  3065. "25345 -73.8194803\n",
  3066. "25346 -73.9400398\n",
  3067. "25347 -73.763352\n",
  3068. "25348 -73.73742399999999\n",
  3069. "25349 -73.98581899999999\n",
  3070. "25350 -73.8753401\n",
  3071. "25351 -73.7315557\n",
  3072. "25352 -74.0212854\n",
  3073. "25353 -73.785758\n",
  3074. "25354 -74.2150624\n",
  3075. "25355 -73.890768\n",
  3076. "25356 -73.981231\n",
  3077. "25357 -73.9892179\n",
  3078. "25358 -73.80324259999999\n",
  3079. "\n",
  3080. "[25359 rows x 1 columns]"
  3081. ]
  3082. },
  3083. "execution_count": 36,
  3084. "metadata": {},
  3085. "output_type": "execute_result"
  3086. }
  3087. ],
  3088. "source": [
  3089. "query = \"select (address_json::json->'coord'->0) as building from restaurant_from_df\"\n",
  3090. "show_query_response(query)"
  3091. ]
  3092. },
  3093. {
  3094. "cell_type": "code",
  3095. "execution_count": 41,
  3096. "metadata": {},
  3097. "outputs": [
  3098. {
  3099. "data": {
  3100. "text/html": [
  3101. "<div>\n",
  3102. "<style>\n",
  3103. " .dataframe thead tr:only-child th {\n",
  3104. " text-align: right;\n",
  3105. " }\n",
  3106. "\n",
  3107. " .dataframe thead th {\n",
  3108. " text-align: left;\n",
  3109. " }\n",
  3110. "\n",
  3111. " .dataframe tbody tr th {\n",
  3112. " vertical-align: top;\n",
  3113. " }\n",
  3114. "</style>\n",
  3115. "<table border=\"1\" class=\"dataframe\">\n",
  3116. " <thead>\n",
  3117. " <tr style=\"text-align: right;\">\n",
  3118. " <th></th>\n",
  3119. " <th>restaurant_id</th>\n",
  3120. " <th>x</th>\n",
  3121. " </tr>\n",
  3122. " </thead>\n",
  3123. " <tbody>\n",
  3124. " <tr>\n",
  3125. " <th>0</th>\n",
  3126. " <td>30075445</td>\n",
  3127. " <td>-73.856077000000000000</td>\n",
  3128. " </tr>\n",
  3129. " <tr>\n",
  3130. " <th>1</th>\n",
  3131. " <td>30112340</td>\n",
  3132. " <td>-73.961704000000000000</td>\n",
  3133. " </tr>\n",
  3134. " <tr>\n",
  3135. " <th>2</th>\n",
  3136. " <td>30191841</td>\n",
  3137. " <td>-73.985135599999990000</td>\n",
  3138. " </tr>\n",
  3139. " <tr>\n",
  3140. " <th>3</th>\n",
  3141. " <td>40356018</td>\n",
  3142. " <td>-73.982419999999990000</td>\n",
  3143. " </tr>\n",
  3144. " <tr>\n",
  3145. " <th>4</th>\n",
  3146. " <td>40356068</td>\n",
  3147. " <td>-73.860115200000000000</td>\n",
  3148. " </tr>\n",
  3149. " <tr>\n",
  3150. " <th>5</th>\n",
  3151. " <td>40356151</td>\n",
  3152. " <td>-73.880382700000000000</td>\n",
  3153. " </tr>\n",
  3154. " <tr>\n",
  3155. " <th>6</th>\n",
  3156. " <td>40356442</td>\n",
  3157. " <td>-74.137728600000000000</td>\n",
  3158. " </tr>\n",
  3159. " <tr>\n",
  3160. " <th>7</th>\n",
  3161. " <td>40356483</td>\n",
  3162. " <td>-73.906850600000000000</td>\n",
  3163. " </tr>\n",
  3164. " <tr>\n",
  3165. " <th>8</th>\n",
  3166. " <td>40356649</td>\n",
  3167. " <td>-74.005288999999990000</td>\n",
  3168. " </tr>\n",
  3169. " <tr>\n",
  3170. " <th>9</th>\n",
  3171. " <td>40356731</td>\n",
  3172. " <td>-73.948260900000000000</td>\n",
  3173. " </tr>\n",
  3174. " <tr>\n",
  3175. " <th>10</th>\n",
  3176. " <td>40357217</td>\n",
  3177. " <td>-73.878611300000000000</td>\n",
  3178. " </tr>\n",
  3179. " <tr>\n",
  3180. " <th>11</th>\n",
  3181. " <td>40357437</td>\n",
  3182. " <td>-73.997332500000000000</td>\n",
  3183. " </tr>\n",
  3184. " <tr>\n",
  3185. " <th>12</th>\n",
  3186. " <td>40358429</td>\n",
  3187. " <td>-73.871194000000000000</td>\n",
  3188. " </tr>\n",
  3189. " <tr>\n",
  3190. " <th>13</th>\n",
  3191. " <td>40359480</td>\n",
  3192. " <td>-73.969269099999990000</td>\n",
  3193. " </tr>\n",
  3194. " <tr>\n",
  3195. " <th>14</th>\n",
  3196. " <td>40360045</td>\n",
  3197. " <td>-73.965396700000000000</td>\n",
  3198. " </tr>\n",
  3199. " <tr>\n",
  3200. " <th>15</th>\n",
  3201. " <td>40360076</td>\n",
  3202. " <td>-73.978220400000010000</td>\n",
  3203. " </tr>\n",
  3204. " <tr>\n",
  3205. " <th>16</th>\n",
  3206. " <td>40361322</td>\n",
  3207. " <td>-73.703260100000000000</td>\n",
  3208. " </tr>\n",
  3209. " <tr>\n",
  3210. " <th>17</th>\n",
  3211. " <td>40361390</td>\n",
  3212. " <td>-74.025956700000000000</td>\n",
  3213. " </tr>\n",
  3214. " <tr>\n",
  3215. " <th>18</th>\n",
  3216. " <td>40361521</td>\n",
  3217. " <td>-73.951710000000000000</td>\n",
  3218. " </tr>\n",
  3219. " <tr>\n",
  3220. " <th>19</th>\n",
  3221. " <td>40361606</td>\n",
  3222. " <td>-73.982923900000000000</td>\n",
  3223. " </tr>\n",
  3224. " <tr>\n",
  3225. " <th>20</th>\n",
  3226. " <td>40361618</td>\n",
  3227. " <td>-73.839297000000000000</td>\n",
  3228. " </tr>\n",
  3229. " <tr>\n",
  3230. " <th>21</th>\n",
  3231. " <td>40361708</td>\n",
  3232. " <td>-73.992530600000000000</td>\n",
  3233. " </tr>\n",
  3234. " <tr>\n",
  3235. " <th>22</th>\n",
  3236. " <td>40361998</td>\n",
  3237. " <td>-73.940247399999990000</td>\n",
  3238. " </tr>\n",
  3239. " <tr>\n",
  3240. " <th>23</th>\n",
  3241. " <td>40362098</td>\n",
  3242. " <td>-73.976112000000000000</td>\n",
  3243. " </tr>\n",
  3244. " <tr>\n",
  3245. " <th>24</th>\n",
  3246. " <td>40362264</td>\n",
  3247. " <td>-73.968057199999990000</td>\n",
  3248. " </tr>\n",
  3249. " <tr>\n",
  3250. " <th>25</th>\n",
  3251. " <td>40362274</td>\n",
  3252. " <td>-73.996984000000000000</td>\n",
  3253. " </tr>\n",
  3254. " <tr>\n",
  3255. " <th>26</th>\n",
  3256. " <td>40362344</td>\n",
  3257. " <td>-73.963487600000000000</td>\n",
  3258. " </tr>\n",
  3259. " <tr>\n",
  3260. " <th>27</th>\n",
  3261. " <td>40362432</td>\n",
  3262. " <td>-73.864234900000000000</td>\n",
  3263. " </tr>\n",
  3264. " <tr>\n",
  3265. " <th>28</th>\n",
  3266. " <td>40362715</td>\n",
  3267. " <td>-74.008535700000000000</td>\n",
  3268. " </tr>\n",
  3269. " <tr>\n",
  3270. " <th>29</th>\n",
  3271. " <td>40362869</td>\n",
  3272. " <td>-73.924602800000000000</td>\n",
  3273. " </tr>\n",
  3274. " <tr>\n",
  3275. " <th>...</th>\n",
  3276. " <td>...</td>\n",
  3277. " <td>...</td>\n",
  3278. " </tr>\n",
  3279. " <tr>\n",
  3280. " <th>25329</th>\n",
  3281. " <td>41646934</td>\n",
  3282. " <td>-73.809363500000000000</td>\n",
  3283. " </tr>\n",
  3284. " <tr>\n",
  3285. " <th>25330</th>\n",
  3286. " <td>41646958</td>\n",
  3287. " <td>-73.950802900000000000</td>\n",
  3288. " </tr>\n",
  3289. " <tr>\n",
  3290. " <th>25331</th>\n",
  3291. " <td>41646963</td>\n",
  3292. " <td>-73.985276599999990000</td>\n",
  3293. " </tr>\n",
  3294. " <tr>\n",
  3295. " <th>25332</th>\n",
  3296. " <td>41646967</td>\n",
  3297. " <td>-74.006240100000000000</td>\n",
  3298. " </tr>\n",
  3299. " <tr>\n",
  3300. " <th>25333</th>\n",
  3301. " <td>41646976</td>\n",
  3302. " <td>-73.940551900000000000</td>\n",
  3303. " </tr>\n",
  3304. " <tr>\n",
  3305. " <th>25334</th>\n",
  3306. " <td>41646979</td>\n",
  3307. " <td>-73.992217800000000000</td>\n",
  3308. " </tr>\n",
  3309. " <tr>\n",
  3310. " <th>25335</th>\n",
  3311. " <td>41647006</td>\n",
  3312. " <td>-73.819531000000000000</td>\n",
  3313. " </tr>\n",
  3314. " <tr>\n",
  3315. " <th>25336</th>\n",
  3316. " <td>41647012</td>\n",
  3317. " <td>-73.989310199999990000</td>\n",
  3318. " </tr>\n",
  3319. " <tr>\n",
  3320. " <th>25337</th>\n",
  3321. " <td>41647017</td>\n",
  3322. " <td>-73.967544100000000000</td>\n",
  3323. " </tr>\n",
  3324. " <tr>\n",
  3325. " <th>25338</th>\n",
  3326. " <td>41647039</td>\n",
  3327. " <td>-73.918047000000000000</td>\n",
  3328. " </tr>\n",
  3329. " <tr>\n",
  3330. " <th>25339</th>\n",
  3331. " <td>41647062</td>\n",
  3332. " <td>-73.832828000000000000</td>\n",
  3333. " </tr>\n",
  3334. " <tr>\n",
  3335. " <th>25340</th>\n",
  3336. " <td>41647098</td>\n",
  3337. " <td>-73.854999400000000000</td>\n",
  3338. " </tr>\n",
  3339. " <tr>\n",
  3340. " <th>25341</th>\n",
  3341. " <td>41647129</td>\n",
  3342. " <td>-73.860018000000000000</td>\n",
  3343. " </tr>\n",
  3344. " <tr>\n",
  3345. " <th>25342</th>\n",
  3346. " <td>41647169</td>\n",
  3347. " <td>-73.911195400000000000</td>\n",
  3348. " </tr>\n",
  3349. " <tr>\n",
  3350. " <th>25343</th>\n",
  3351. " <td>41647176</td>\n",
  3352. " <td>-73.954548000000000000</td>\n",
  3353. " </tr>\n",
  3354. " <tr>\n",
  3355. " <th>25344</th>\n",
  3356. " <td>41647181</td>\n",
  3357. " <td>-73.983101500000000000</td>\n",
  3358. " </tr>\n",
  3359. " <tr>\n",
  3360. " <th>25345</th>\n",
  3361. " <td>41647183</td>\n",
  3362. " <td>-73.819480300000000000</td>\n",
  3363. " </tr>\n",
  3364. " <tr>\n",
  3365. " <th>25346</th>\n",
  3366. " <td>41647192</td>\n",
  3367. " <td>-73.940039800000000000</td>\n",
  3368. " </tr>\n",
  3369. " <tr>\n",
  3370. " <th>25347</th>\n",
  3371. " <td>41647210</td>\n",
  3372. " <td>-73.763352000000000000</td>\n",
  3373. " </tr>\n",
  3374. " <tr>\n",
  3375. " <th>25348</th>\n",
  3376. " <td>41647221</td>\n",
  3377. " <td>-73.737423999999990000</td>\n",
  3378. " </tr>\n",
  3379. " <tr>\n",
  3380. " <th>25349</th>\n",
  3381. " <td>41647241</td>\n",
  3382. " <td>-73.985818999999990000</td>\n",
  3383. " </tr>\n",
  3384. " <tr>\n",
  3385. " <th>25350</th>\n",
  3386. " <td>41647292</td>\n",
  3387. " <td>-73.875340100000000000</td>\n",
  3388. " </tr>\n",
  3389. " <tr>\n",
  3390. " <th>25351</th>\n",
  3391. " <td>41647360</td>\n",
  3392. " <td>-73.731555700000000000</td>\n",
  3393. " </tr>\n",
  3394. " <tr>\n",
  3395. " <th>25352</th>\n",
  3396. " <td>41647370</td>\n",
  3397. " <td>-74.021285400000000000</td>\n",
  3398. " </tr>\n",
  3399. " <tr>\n",
  3400. " <th>25353</th>\n",
  3401. " <td>41647380</td>\n",
  3402. " <td>-73.785758000000000000</td>\n",
  3403. " </tr>\n",
  3404. " <tr>\n",
  3405. " <th>25354</th>\n",
  3406. " <td>41647384</td>\n",
  3407. " <td>-74.215062400000000000</td>\n",
  3408. " </tr>\n",
  3409. " <tr>\n",
  3410. " <th>25355</th>\n",
  3411. " <td>41647392</td>\n",
  3412. " <td>-73.890768000000000000</td>\n",
  3413. " </tr>\n",
  3414. " <tr>\n",
  3415. " <th>25356</th>\n",
  3416. " <td>41647399</td>\n",
  3417. " <td>-73.981231000000000000</td>\n",
  3418. " </tr>\n",
  3419. " <tr>\n",
  3420. " <th>25357</th>\n",
  3421. " <td>41647482</td>\n",
  3422. " <td>-73.989217900000000000</td>\n",
  3423. " </tr>\n",
  3424. " <tr>\n",
  3425. " <th>25358</th>\n",
  3426. " <td>41647521</td>\n",
  3427. " <td>-73.803242599999990000</td>\n",
  3428. " </tr>\n",
  3429. " </tbody>\n",
  3430. "</table>\n",
  3431. "<p>25359 rows × 2 columns</p>\n",
  3432. "</div>"
  3433. ],
  3434. "text/plain": [
  3435. " restaurant_id x\n",
  3436. "0 30075445 -73.856077000000000000\n",
  3437. "1 30112340 -73.961704000000000000\n",
  3438. "2 30191841 -73.985135599999990000\n",
  3439. "3 40356018 -73.982419999999990000\n",
  3440. "4 40356068 -73.860115200000000000\n",
  3441. "5 40356151 -73.880382700000000000\n",
  3442. "6 40356442 -74.137728600000000000\n",
  3443. "7 40356483 -73.906850600000000000\n",
  3444. "8 40356649 -74.005288999999990000\n",
  3445. "9 40356731 -73.948260900000000000\n",
  3446. "10 40357217 -73.878611300000000000\n",
  3447. "11 40357437 -73.997332500000000000\n",
  3448. "12 40358429 -73.871194000000000000\n",
  3449. "13 40359480 -73.969269099999990000\n",
  3450. "14 40360045 -73.965396700000000000\n",
  3451. "15 40360076 -73.978220400000010000\n",
  3452. "16 40361322 -73.703260100000000000\n",
  3453. "17 40361390 -74.025956700000000000\n",
  3454. "18 40361521 -73.951710000000000000\n",
  3455. "19 40361606 -73.982923900000000000\n",
  3456. "20 40361618 -73.839297000000000000\n",
  3457. "21 40361708 -73.992530600000000000\n",
  3458. "22 40361998 -73.940247399999990000\n",
  3459. "23 40362098 -73.976112000000000000\n",
  3460. "24 40362264 -73.968057199999990000\n",
  3461. "25 40362274 -73.996984000000000000\n",
  3462. "26 40362344 -73.963487600000000000\n",
  3463. "27 40362432 -73.864234900000000000\n",
  3464. "28 40362715 -74.008535700000000000\n",
  3465. "29 40362869 -73.924602800000000000\n",
  3466. "... ... ...\n",
  3467. "25329 41646934 -73.809363500000000000\n",
  3468. "25330 41646958 -73.950802900000000000\n",
  3469. "25331 41646963 -73.985276599999990000\n",
  3470. "25332 41646967 -74.006240100000000000\n",
  3471. "25333 41646976 -73.940551900000000000\n",
  3472. "25334 41646979 -73.992217800000000000\n",
  3473. "25335 41647006 -73.819531000000000000\n",
  3474. "25336 41647012 -73.989310199999990000\n",
  3475. "25337 41647017 -73.967544100000000000\n",
  3476. "25338 41647039 -73.918047000000000000\n",
  3477. "25339 41647062 -73.832828000000000000\n",
  3478. "25340 41647098 -73.854999400000000000\n",
  3479. "25341 41647129 -73.860018000000000000\n",
  3480. "25342 41647169 -73.911195400000000000\n",
  3481. "25343 41647176 -73.954548000000000000\n",
  3482. "25344 41647181 -73.983101500000000000\n",
  3483. "25345 41647183 -73.819480300000000000\n",
  3484. "25346 41647192 -73.940039800000000000\n",
  3485. "25347 41647210 -73.763352000000000000\n",
  3486. "25348 41647221 -73.737423999999990000\n",
  3487. "25349 41647241 -73.985818999999990000\n",
  3488. "25350 41647292 -73.875340100000000000\n",
  3489. "25351 41647360 -73.731555700000000000\n",
  3490. "25352 41647370 -74.021285400000000000\n",
  3491. "25353 41647380 -73.785758000000000000\n",
  3492. "25354 41647384 -74.215062400000000000\n",
  3493. "25355 41647392 -73.890768000000000000\n",
  3494. "25356 41647399 -73.981231000000000000\n",
  3495. "25357 41647482 -73.989217900000000000\n",
  3496. "25358 41647521 -73.803242599999990000\n",
  3497. "\n",
  3498. "[25359 rows x 2 columns]"
  3499. ]
  3500. },
  3501. "execution_count": 41,
  3502. "metadata": {},
  3503. "output_type": "execute_result"
  3504. }
  3505. ],
  3506. "source": [
  3507. "query = \"select restaurant_id, (address_json::json->'coord'->0)::TEXT::NUMERIC as x from restaurant_from_df\"\n",
  3508. "show_query_response(query)"
  3509. ]
  3510. },
  3511. {
  3512. "cell_type": "code",
  3513. "execution_count": 48,
  3514. "metadata": {},
  3515. "outputs": [
  3516. {
  3517. "data": {
  3518. "text/html": [
  3519. "<div>\n",
  3520. "<style>\n",
  3521. " .dataframe thead tr:only-child th {\n",
  3522. " text-align: right;\n",
  3523. " }\n",
  3524. "\n",
  3525. " .dataframe thead th {\n",
  3526. " text-align: left;\n",
  3527. " }\n",
  3528. "\n",
  3529. " .dataframe tbody tr th {\n",
  3530. " vertical-align: top;\n",
  3531. " }\n",
  3532. "</style>\n",
  3533. "<table border=\"1\" class=\"dataframe\">\n",
  3534. " <thead>\n",
  3535. " <tr style=\"text-align: right;\">\n",
  3536. " <th></th>\n",
  3537. " <th>restaurant_id</th>\n",
  3538. " <th>x</th>\n",
  3539. " <th>y</th>\n",
  3540. " </tr>\n",
  3541. " </thead>\n",
  3542. " <tbody>\n",
  3543. " <tr>\n",
  3544. " <th>0</th>\n",
  3545. " <td>30075445</td>\n",
  3546. " <td>-73.856077000000000000</td>\n",
  3547. " <td>40.848447000000000000</td>\n",
  3548. " </tr>\n",
  3549. " <tr>\n",
  3550. " <th>1</th>\n",
  3551. " <td>30112340</td>\n",
  3552. " <td>-73.961704000000000000</td>\n",
  3553. " <td>40.662942000000000000</td>\n",
  3554. " </tr>\n",
  3555. " <tr>\n",
  3556. " <th>2</th>\n",
  3557. " <td>30191841</td>\n",
  3558. " <td>-73.985135599999990000</td>\n",
  3559. " <td>40.767691900000000000</td>\n",
  3560. " </tr>\n",
  3561. " <tr>\n",
  3562. " <th>3</th>\n",
  3563. " <td>40356018</td>\n",
  3564. " <td>-73.982419999999990000</td>\n",
  3565. " <td>40.579505000000000000</td>\n",
  3566. " </tr>\n",
  3567. " <tr>\n",
  3568. " <th>4</th>\n",
  3569. " <td>40356068</td>\n",
  3570. " <td>-73.860115200000000000</td>\n",
  3571. " <td>40.731173900000000000</td>\n",
  3572. " </tr>\n",
  3573. " <tr>\n",
  3574. " <th>5</th>\n",
  3575. " <td>40356151</td>\n",
  3576. " <td>-73.880382700000000000</td>\n",
  3577. " <td>40.764312400000000000</td>\n",
  3578. " </tr>\n",
  3579. " <tr>\n",
  3580. " <th>6</th>\n",
  3581. " <td>40356442</td>\n",
  3582. " <td>-74.137728600000000000</td>\n",
  3583. " <td>40.611957200000000000</td>\n",
  3584. " </tr>\n",
  3585. " <tr>\n",
  3586. " <th>7</th>\n",
  3587. " <td>40356483</td>\n",
  3588. " <td>-73.906850600000000000</td>\n",
  3589. " <td>40.619903400000000000</td>\n",
  3590. " </tr>\n",
  3591. " <tr>\n",
  3592. " <th>8</th>\n",
  3593. " <td>40356649</td>\n",
  3594. " <td>-74.005288999999990000</td>\n",
  3595. " <td>40.628886000000000000</td>\n",
  3596. " </tr>\n",
  3597. " <tr>\n",
  3598. " <th>9</th>\n",
  3599. " <td>40356731</td>\n",
  3600. " <td>-73.948260900000000000</td>\n",
  3601. " <td>40.640827100000000000</td>\n",
  3602. " </tr>\n",
  3603. " <tr>\n",
  3604. " <th>10</th>\n",
  3605. " <td>40357217</td>\n",
  3606. " <td>-73.878611300000000000</td>\n",
  3607. " <td>40.850288300000000000</td>\n",
  3608. " </tr>\n",
  3609. " <tr>\n",
  3610. " <th>11</th>\n",
  3611. " <td>40357437</td>\n",
  3612. " <td>-73.997332500000000000</td>\n",
  3613. " <td>40.611748899999990000</td>\n",
  3614. " </tr>\n",
  3615. " <tr>\n",
  3616. " <th>12</th>\n",
  3617. " <td>40358429</td>\n",
  3618. " <td>-73.871194000000000000</td>\n",
  3619. " <td>40.673097500000000000</td>\n",
  3620. " </tr>\n",
  3621. " <tr>\n",
  3622. " <th>13</th>\n",
  3623. " <td>40359480</td>\n",
  3624. " <td>-73.969269099999990000</td>\n",
  3625. " <td>40.768523500000000000</td>\n",
  3626. " </tr>\n",
  3627. " <tr>\n",
  3628. " <th>14</th>\n",
  3629. " <td>40360045</td>\n",
  3630. " <td>-73.965396700000000000</td>\n",
  3631. " <td>40.606433900000000000</td>\n",
  3632. " </tr>\n",
  3633. " <tr>\n",
  3634. " <th>15</th>\n",
  3635. " <td>40360076</td>\n",
  3636. " <td>-73.978220400000010000</td>\n",
  3637. " <td>40.643525400000000000</td>\n",
  3638. " </tr>\n",
  3639. " <tr>\n",
  3640. " <th>16</th>\n",
  3641. " <td>40361322</td>\n",
  3642. " <td>-73.703260100000000000</td>\n",
  3643. " <td>40.738641700000000000</td>\n",
  3644. " </tr>\n",
  3645. " <tr>\n",
  3646. " <th>17</th>\n",
  3647. " <td>40361390</td>\n",
  3648. " <td>-74.025956700000000000</td>\n",
  3649. " <td>40.635367400000000000</td>\n",
  3650. " </tr>\n",
  3651. " <tr>\n",
  3652. " <th>18</th>\n",
  3653. " <td>40361521</td>\n",
  3654. " <td>-73.951710000000000000</td>\n",
  3655. " <td>40.767461000000000000</td>\n",
  3656. " </tr>\n",
  3657. " <tr>\n",
  3658. " <th>19</th>\n",
  3659. " <td>40361606</td>\n",
  3660. " <td>-73.982923900000000000</td>\n",
  3661. " <td>40.658075300000000000</td>\n",
  3662. " </tr>\n",
  3663. " <tr>\n",
  3664. " <th>20</th>\n",
  3665. " <td>40361618</td>\n",
  3666. " <td>-73.839297000000000000</td>\n",
  3667. " <td>40.781470000000000000</td>\n",
  3668. " </tr>\n",
  3669. " <tr>\n",
  3670. " <th>21</th>\n",
  3671. " <td>40361708</td>\n",
  3672. " <td>-73.992530600000000000</td>\n",
  3673. " <td>40.730934600000000000</td>\n",
  3674. " </tr>\n",
  3675. " <tr>\n",
  3676. " <th>22</th>\n",
  3677. " <td>40361998</td>\n",
  3678. " <td>-73.940247399999990000</td>\n",
  3679. " <td>40.762328800000000000</td>\n",
  3680. " </tr>\n",
  3681. " <tr>\n",
  3682. " <th>23</th>\n",
  3683. " <td>40362098</td>\n",
  3684. " <td>-73.976112000000000000</td>\n",
  3685. " <td>40.786714000000000000</td>\n",
  3686. " </tr>\n",
  3687. " <tr>\n",
  3688. " <th>24</th>\n",
  3689. " <td>40362264</td>\n",
  3690. " <td>-73.968057199999990000</td>\n",
  3691. " <td>40.792558700000000000</td>\n",
  3692. " </tr>\n",
  3693. " <tr>\n",
  3694. " <th>25</th>\n",
  3695. " <td>40362274</td>\n",
  3696. " <td>-73.996984000000000000</td>\n",
  3697. " <td>40.725890000000000000</td>\n",
  3698. " </tr>\n",
  3699. " <tr>\n",
  3700. " <th>26</th>\n",
  3701. " <td>40362344</td>\n",
  3702. " <td>-73.963487600000000000</td>\n",
  3703. " <td>40.694000100000000000</td>\n",
  3704. " </tr>\n",
  3705. " <tr>\n",
  3706. " <th>27</th>\n",
  3707. " <td>40362432</td>\n",
  3708. " <td>-73.864234900000000000</td>\n",
  3709. " <td>40.753560000000000000</td>\n",
  3710. " </tr>\n",
  3711. " <tr>\n",
  3712. " <th>28</th>\n",
  3713. " <td>40362715</td>\n",
  3714. " <td>-74.008535700000000000</td>\n",
  3715. " <td>40.706205399999990000</td>\n",
  3716. " </tr>\n",
  3717. " <tr>\n",
  3718. " <th>29</th>\n",
  3719. " <td>40362869</td>\n",
  3720. " <td>-73.924602800000000000</td>\n",
  3721. " <td>40.652239600000000000</td>\n",
  3722. " </tr>\n",
  3723. " <tr>\n",
  3724. " <th>...</th>\n",
  3725. " <td>...</td>\n",
  3726. " <td>...</td>\n",
  3727. " <td>...</td>\n",
  3728. " </tr>\n",
  3729. " <tr>\n",
  3730. " <th>25329</th>\n",
  3731. " <td>41646934</td>\n",
  3732. " <td>-73.809363500000000000</td>\n",
  3733. " <td>40.705091200000000000</td>\n",
  3734. " </tr>\n",
  3735. " <tr>\n",
  3736. " <th>25330</th>\n",
  3737. " <td>41646958</td>\n",
  3738. " <td>-73.950802900000000000</td>\n",
  3739. " <td>40.659537000000010000</td>\n",
  3740. " </tr>\n",
  3741. " <tr>\n",
  3742. " <th>25331</th>\n",
  3743. " <td>41646963</td>\n",
  3744. " <td>-73.985276599999990000</td>\n",
  3745. " <td>40.605480500000000000</td>\n",
  3746. " </tr>\n",
  3747. " <tr>\n",
  3748. " <th>25332</th>\n",
  3749. " <td>41646967</td>\n",
  3750. " <td>-74.006240100000000000</td>\n",
  3751. " <td>40.739754600000000000</td>\n",
  3752. " </tr>\n",
  3753. " <tr>\n",
  3754. " <th>25333</th>\n",
  3755. " <td>41646976</td>\n",
  3756. " <td>-73.940551900000000000</td>\n",
  3757. " <td>40.806262900000000000</td>\n",
  3758. " </tr>\n",
  3759. " <tr>\n",
  3760. " <th>25334</th>\n",
  3761. " <td>41646979</td>\n",
  3762. " <td>-73.992217800000000000</td>\n",
  3763. " <td>40.757992200000000000</td>\n",
  3764. " </tr>\n",
  3765. " <tr>\n",
  3766. " <th>25335</th>\n",
  3767. " <td>41647006</td>\n",
  3768. " <td>-73.819531000000000000</td>\n",
  3769. " <td>40.675913000000010000</td>\n",
  3770. " </tr>\n",
  3771. " <tr>\n",
  3772. " <th>25336</th>\n",
  3773. " <td>41647012</td>\n",
  3774. " <td>-73.989310199999990000</td>\n",
  3775. " <td>40.744059200000000000</td>\n",
  3776. " </tr>\n",
  3777. " <tr>\n",
  3778. " <th>25337</th>\n",
  3779. " <td>41647017</td>\n",
  3780. " <td>-73.967544100000000000</td>\n",
  3781. " <td>40.800936900000000000</td>\n",
  3782. " </tr>\n",
  3783. " <tr>\n",
  3784. " <th>25338</th>\n",
  3785. " <td>41647039</td>\n",
  3786. " <td>-73.918047000000000000</td>\n",
  3787. " <td>40.765320800000000000</td>\n",
  3788. " </tr>\n",
  3789. " <tr>\n",
  3790. " <th>25339</th>\n",
  3791. " <td>41647062</td>\n",
  3792. " <td>-73.832828000000000000</td>\n",
  3793. " <td>40.759771000000000000</td>\n",
  3794. " </tr>\n",
  3795. " <tr>\n",
  3796. " <th>25340</th>\n",
  3797. " <td>41647098</td>\n",
  3798. " <td>-73.854999400000000000</td>\n",
  3799. " <td>40.835251600000000000</td>\n",
  3800. " </tr>\n",
  3801. " <tr>\n",
  3802. " <th>25341</th>\n",
  3803. " <td>41647129</td>\n",
  3804. " <td>-73.860018000000000000</td>\n",
  3805. " <td>40.752453000000000000</td>\n",
  3806. " </tr>\n",
  3807. " <tr>\n",
  3808. " <th>25342</th>\n",
  3809. " <td>41647169</td>\n",
  3810. " <td>-73.911195400000000000</td>\n",
  3811. " <td>40.861512400000000000</td>\n",
  3812. " </tr>\n",
  3813. " <tr>\n",
  3814. " <th>25343</th>\n",
  3815. " <td>41647176</td>\n",
  3816. " <td>-73.954548000000000000</td>\n",
  3817. " <td>40.774537900000000000</td>\n",
  3818. " </tr>\n",
  3819. " <tr>\n",
  3820. " <th>25344</th>\n",
  3821. " <td>41647181</td>\n",
  3822. " <td>-73.983101500000000000</td>\n",
  3823. " <td>40.722830500000000000</td>\n",
  3824. " </tr>\n",
  3825. " <tr>\n",
  3826. " <th>25345</th>\n",
  3827. " <td>41647183</td>\n",
  3828. " <td>-73.819480300000000000</td>\n",
  3829. " <td>40.584887500000000000</td>\n",
  3830. " </tr>\n",
  3831. " <tr>\n",
  3832. " <th>25346</th>\n",
  3833. " <td>41647192</td>\n",
  3834. " <td>-73.940039800000000000</td>\n",
  3835. " <td>40.751488500000000000</td>\n",
  3836. " </tr>\n",
  3837. " <tr>\n",
  3838. " <th>25347</th>\n",
  3839. " <td>41647210</td>\n",
  3840. " <td>-73.763352000000000000</td>\n",
  3841. " <td>40.674456000000000000</td>\n",
  3842. " </tr>\n",
  3843. " <tr>\n",
  3844. " <th>25348</th>\n",
  3845. " <td>41647221</td>\n",
  3846. " <td>-73.737423999999990000</td>\n",
  3847. " <td>40.718094000000000000</td>\n",
  3848. " </tr>\n",
  3849. " <tr>\n",
  3850. " <th>25349</th>\n",
  3851. " <td>41647241</td>\n",
  3852. " <td>-73.985818999999990000</td>\n",
  3853. " <td>40.734705000000010000</td>\n",
  3854. " </tr>\n",
  3855. " <tr>\n",
  3856. " <th>25350</th>\n",
  3857. " <td>41647292</td>\n",
  3858. " <td>-73.875340100000000000</td>\n",
  3859. " <td>40.672474200000000000</td>\n",
  3860. " </tr>\n",
  3861. " <tr>\n",
  3862. " <th>25351</th>\n",
  3863. " <td>41647360</td>\n",
  3864. " <td>-73.731555700000000000</td>\n",
  3865. " <td>40.760093900000000000</td>\n",
  3866. " </tr>\n",
  3867. " <tr>\n",
  3868. " <th>25352</th>\n",
  3869. " <td>41647370</td>\n",
  3870. " <td>-74.021285400000000000</td>\n",
  3871. " <td>40.633488700000000000</td>\n",
  3872. " </tr>\n",
  3873. " <tr>\n",
  3874. " <th>25353</th>\n",
  3875. " <td>41647380</td>\n",
  3876. " <td>-73.785758000000000000</td>\n",
  3877. " <td>40.752324000000000000</td>\n",
  3878. " </tr>\n",
  3879. " <tr>\n",
  3880. " <th>25354</th>\n",
  3881. " <td>41647384</td>\n",
  3882. " <td>-74.215062400000000000</td>\n",
  3883. " <td>40.521769900000000000</td>\n",
  3884. " </tr>\n",
  3885. " <tr>\n",
  3886. " <th>25355</th>\n",
  3887. " <td>41647392</td>\n",
  3888. " <td>-73.890768000000000000</td>\n",
  3889. " <td>40.857094400000010000</td>\n",
  3890. " </tr>\n",
  3891. " <tr>\n",
  3892. " <th>25356</th>\n",
  3893. " <td>41647399</td>\n",
  3894. " <td>-73.981231000000000000</td>\n",
  3895. " <td>40.782200600000000000</td>\n",
  3896. " </tr>\n",
  3897. " <tr>\n",
  3898. " <th>25357</th>\n",
  3899. " <td>41647482</td>\n",
  3900. " <td>-73.989217900000000000</td>\n",
  3901. " <td>40.725940000000000000</td>\n",
  3902. " </tr>\n",
  3903. " <tr>\n",
  3904. " <th>25358</th>\n",
  3905. " <td>41647521</td>\n",
  3906. " <td>-73.803242599999990000</td>\n",
  3907. " <td>40.674534900000000000</td>\n",
  3908. " </tr>\n",
  3909. " </tbody>\n",
  3910. "</table>\n",
  3911. "<p>25359 rows × 3 columns</p>\n",
  3912. "</div>"
  3913. ],
  3914. "text/plain": [
  3915. " restaurant_id x y\n",
  3916. "0 30075445 -73.856077000000000000 40.848447000000000000\n",
  3917. "1 30112340 -73.961704000000000000 40.662942000000000000\n",
  3918. "2 30191841 -73.985135599999990000 40.767691900000000000\n",
  3919. "3 40356018 -73.982419999999990000 40.579505000000000000\n",
  3920. "4 40356068 -73.860115200000000000 40.731173900000000000\n",
  3921. "5 40356151 -73.880382700000000000 40.764312400000000000\n",
  3922. "6 40356442 -74.137728600000000000 40.611957200000000000\n",
  3923. "7 40356483 -73.906850600000000000 40.619903400000000000\n",
  3924. "8 40356649 -74.005288999999990000 40.628886000000000000\n",
  3925. "9 40356731 -73.948260900000000000 40.640827100000000000\n",
  3926. "10 40357217 -73.878611300000000000 40.850288300000000000\n",
  3927. "11 40357437 -73.997332500000000000 40.611748899999990000\n",
  3928. "12 40358429 -73.871194000000000000 40.673097500000000000\n",
  3929. "13 40359480 -73.969269099999990000 40.768523500000000000\n",
  3930. "14 40360045 -73.965396700000000000 40.606433900000000000\n",
  3931. "15 40360076 -73.978220400000010000 40.643525400000000000\n",
  3932. "16 40361322 -73.703260100000000000 40.738641700000000000\n",
  3933. "17 40361390 -74.025956700000000000 40.635367400000000000\n",
  3934. "18 40361521 -73.951710000000000000 40.767461000000000000\n",
  3935. "19 40361606 -73.982923900000000000 40.658075300000000000\n",
  3936. "20 40361618 -73.839297000000000000 40.781470000000000000\n",
  3937. "21 40361708 -73.992530600000000000 40.730934600000000000\n",
  3938. "22 40361998 -73.940247399999990000 40.762328800000000000\n",
  3939. "23 40362098 -73.976112000000000000 40.786714000000000000\n",
  3940. "24 40362264 -73.968057199999990000 40.792558700000000000\n",
  3941. "25 40362274 -73.996984000000000000 40.725890000000000000\n",
  3942. "26 40362344 -73.963487600000000000 40.694000100000000000\n",
  3943. "27 40362432 -73.864234900000000000 40.753560000000000000\n",
  3944. "28 40362715 -74.008535700000000000 40.706205399999990000\n",
  3945. "29 40362869 -73.924602800000000000 40.652239600000000000\n",
  3946. "... ... ... ...\n",
  3947. "25329 41646934 -73.809363500000000000 40.705091200000000000\n",
  3948. "25330 41646958 -73.950802900000000000 40.659537000000010000\n",
  3949. "25331 41646963 -73.985276599999990000 40.605480500000000000\n",
  3950. "25332 41646967 -74.006240100000000000 40.739754600000000000\n",
  3951. "25333 41646976 -73.940551900000000000 40.806262900000000000\n",
  3952. "25334 41646979 -73.992217800000000000 40.757992200000000000\n",
  3953. "25335 41647006 -73.819531000000000000 40.675913000000010000\n",
  3954. "25336 41647012 -73.989310199999990000 40.744059200000000000\n",
  3955. "25337 41647017 -73.967544100000000000 40.800936900000000000\n",
  3956. "25338 41647039 -73.918047000000000000 40.765320800000000000\n",
  3957. "25339 41647062 -73.832828000000000000 40.759771000000000000\n",
  3958. "25340 41647098 -73.854999400000000000 40.835251600000000000\n",
  3959. "25341 41647129 -73.860018000000000000 40.752453000000000000\n",
  3960. "25342 41647169 -73.911195400000000000 40.861512400000000000\n",
  3961. "25343 41647176 -73.954548000000000000 40.774537900000000000\n",
  3962. "25344 41647181 -73.983101500000000000 40.722830500000000000\n",
  3963. "25345 41647183 -73.819480300000000000 40.584887500000000000\n",
  3964. "25346 41647192 -73.940039800000000000 40.751488500000000000\n",
  3965. "25347 41647210 -73.763352000000000000 40.674456000000000000\n",
  3966. "25348 41647221 -73.737423999999990000 40.718094000000000000\n",
  3967. "25349 41647241 -73.985818999999990000 40.734705000000010000\n",
  3968. "25350 41647292 -73.875340100000000000 40.672474200000000000\n",
  3969. "25351 41647360 -73.731555700000000000 40.760093900000000000\n",
  3970. "25352 41647370 -74.021285400000000000 40.633488700000000000\n",
  3971. "25353 41647380 -73.785758000000000000 40.752324000000000000\n",
  3972. "25354 41647384 -74.215062400000000000 40.521769900000000000\n",
  3973. "25355 41647392 -73.890768000000000000 40.857094400000010000\n",
  3974. "25356 41647399 -73.981231000000000000 40.782200600000000000\n",
  3975. "25357 41647482 -73.989217900000000000 40.725940000000000000\n",
  3976. "25358 41647521 -73.803242599999990000 40.674534900000000000\n",
  3977. "\n",
  3978. "[25359 rows x 3 columns]"
  3979. ]
  3980. },
  3981. "execution_count": 48,
  3982. "metadata": {},
  3983. "output_type": "execute_result"
  3984. }
  3985. ],
  3986. "source": [
  3987. "query = '''\n",
  3988. "select restaurant_id, (coord->0)::TEXT::NUMERIC as x, (coord->1)::TEXT::NUMERIC as y \n",
  3989. "from (\n",
  3990. " select *, address_json::json->'coord' as coord\n",
  3991. " from restaurant_from_df\n",
  3992. ") as t\n",
  3993. "'''\n",
  3994. "show_query_response(query)"
  3995. ]
  3996. },
  3997. {
  3998. "cell_type": "code",
  3999. "execution_count": null,
  4000. "metadata": {
  4001. "collapsed": true
  4002. },
  4003. "outputs": [],
  4004. "source": []
  4005. }
  4006. ],
  4007. "metadata": {
  4008. "anaconda-cloud": {},
  4009. "kernelspec": {
  4010. "display_name": "Python [Root]",
  4011. "language": "python",
  4012. "name": "Python [Root]"
  4013. },
  4014. "language_info": {
  4015. "codemirror_mode": {
  4016. "name": "ipython",
  4017. "version": 3
  4018. },
  4019. "file_extension": ".py",
  4020. "mimetype": "text/x-python",
  4021. "name": "python",
  4022. "nbconvert_exporter": "python",
  4023. "pygments_lexer": "ipython3",
  4024. "version": "3.5.4"
  4025. }
  4026. },
  4027. "nbformat": 4,
  4028. "nbformat_minor": 1
  4029. }
Add Comment
Please, Sign In to add comment
Public Pastes
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!