Skip to content

Instantly share code, notes, and snippets.

@rashadsternes

rashadsternes/BizRecords

Created August 31, 2019 06:58
Show Gist options
  • Save rashadsternes/940cef0d1341e38b088315daeffa63c6 to your computer and use it in GitHub Desktop.
Save rashadsternes/940cef0d1341e38b088315daeffa63c6 to your computer and use it in GitHub Desktop.
Download ZIP
Biz Records
Raw
BizRecords
bizschema=# SELECT * FROM biz WHERE bid =1000;
bid | bizname | reviewcount | rating | price | category | location | phone | url | photos
------+--------------------------+-------------+--------+-------+---------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+----------------------+---------
1000 | Fried Los Pollos Cottage | 6905 | 3.5 | $ | ["Filipino","Soup"] | {"address1":"35606 Harvey Burgs","address2":"Apt. 212","city":"Jasttown","state":"VT","zipcode":"47923","neighborhood":"Braeswood Place","latitude":-57.253,"longitude":60.998} | (270) 682-4168 | http://margarete.net | {1,2,3}
(1 row)
bizschema=# SELECT * FROM biz WHERE bid =10000000;
bid | bizname | reviewcount | rating | price | category | location | phone | url | photos
----------+------------+-------------+--------+-------+--------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+-------------------+---------
10000000 | Famous Way | 4915 | 4 | $$ | ["Mexican","Bubble Tea"] | {"address1":"6079 Parisian Harbor","address2":"Apt. 303","city":"Lockmanville","state":"GA","zipcode":"88227","neighborhood":"Fourth Ward","latitude":87.9485,"longitude":22.7766} | (453) 015-6519 | https://erica.com | {1,2,3}
(1 row)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment