planningalerts-scrapers / nsw_office_of_liquor_gaming_and_racing

NSW Office of Liquor, Gaming and Racing - Liquor applications

README.md

NSW Office of Liquor, Gaming and Racing

This is a scraper that runs on Morph. To get started see the documentation

It scrapes liquor and gaming application notices posted in the last 28 days from the NSW Liquor & Gaming noticeboard.

Add any issues to https://github.com/planningalerts-scrapers/issues/issues

To run the scraper

bundle exec ruby scraper.rb

Expected output

Setting up search
Saving SR0001553543...
Saving SR0001553544...
...
Saving SR0001553601...
Finished - added 59 records

Execution time under a minute

To run style and coding checks

bundle exec rubocop

To run the tests

bundle exec rspec

To check for security updates

gem install bundler-audit
bundle-audit

Contributors henare CloCkWeRX jamezpolley mlandauer benrfairless

Last run completed successfully .

Console output of last run

Injecting configuration and compiling... Injecting scraper and running... Setting up search Saving 1-9972269052... Saving SR0001566157... Saving 1-9975510563... Saving SR0001566289... Saving 1-9975551084... Saving SR0001566173... Saving APP-0016800808... Saving 1-9975510653... Saving 1-9976161479... Saving SR0001565996... Saving SR0001566222... Saving SR0001566237... Saving APP-0016844983... Saving 1-9976161782... Saving SR0001566225... Saving SR0001566408... Saving SR0001566305... Saving SR0001566139... Saving 1-9975793045... Saving 1-9975793011... Saving APP-0016846714... Saving 1-9975587192... Saving SR0001566217... Saving APP-0016525289... Saving SR0001566360... Saving APP-0016844881... Saving APP-0016836644... Saving 1-9975602369... Saving 1-9975859803... Saving SR0001566044... Saving APP-0016842305... Saving SR0001530892... Saving SR0001566043... Saving APP-0016328750... Saving APP-0016802081... Saving APP-0016839333... Saving APP-0016834881... Saving APP-0016789179... Saving SR0001565651... Saving APP-0016836292... Saving SR0001565638... Saving APP-0016835510... Saving APP-0016836597... Saving SR0001565777... Saving APP-0016835312... Saving APP-0016819259... Saving SR0001563782... Saving APP-0016480637... Saving SR0001565689... Saving APP-0016769092... Saving SR0001565658... Saving SR0001565660... Saving SR0001565720... Saving 1-9973063782... Saving SR0001565520... Saving APP-0016834760... Saving SR0001565578... Saving APP-0016796064... Saving SR0001565747... Saving SR0001565728... Saving 1-9973338551... Saving 1-9971973687... Saving SR0001565202... Saving 1-9971577362... Saving 1-9971973602... Saving SR0001565367... Saving APP-0016828882... Saving SR0001565315... Saving SR0001565386... Saving APP-0015979930... Saving SR0001565235... Saving APP-0016730956... Saving APP-0016831757... Saving 1-9971630209... Saving 1-9972643519... Saving SR0001565419... Saving SR0001565307... Saving APP-0016778209... Saving APP-0016833060... Saving SR0001565176... Saving SR0001565275... Saving SR0001565147... Saving APP-0016833282... Saving SR0001565411... Saving APP-0016828220... Saving SR0001564071... Saving SR0001564072... Saving SR0001565319... Saving SR0001560464... Saving APP-0016825869... Saving APP-0016831765... Saving APP-0016830733... Saving SR0001564215... Saving SR0001564217... Saving SR0001565041... Saving 1-9936852251... Saving SR0001557264... Saving SR0001564590... Saving APP-0016689868... Saving SR0001564738... Saving APP-0016828762... Saving 1-9970489372... Saving APP-0016774975... Saving 1-9970188422... Saving APP-0016798246... Saving APP-0016827446... Saving SR0001564635... Saving SR0001563497... Saving SR0001564135... Saving SR0001564136... Saving 1-9970700802... Saving APP-0016758028... Saving APP-0016824237... Saving 1-9968828014... Saving APP-0016823424... Saving APP-0016823984... Saving 1-9945550742... Saving 1-9969506892... Saving SR0001564188... Saving SR0001564229... Saving SR0001564080... Saving SR0001560871... Saving SR0001560874... Saving APP-0016824338... Saving SR0001564263... Saving APP-0016823520... Saving APP-0016824530... Saving APP-0016824638... Saving APP-0016823575... Saving SR0001558766... Saving APP-0016820474... Saving 1-9968818421... Saving 1-9969273469... Saving APP-0016824156... Saving APP-0016823018... Saving SR0001564373... Saving APP-0016826206... Saving APP-0016776680... Saving SR0001564317... Saving APP-0016824408... Saving 1-9969242942... Saving 1-9969570891... Saving SR0001564058... Saving 1-9967649472... Saving 1-9967649721... Saving APP-0016818900... Saving SR0001564027... Saving 1-9967655766... Saving SR0001563826... Saving APP-0016822295... Saving 1-9967352762... Saving SR0001564091... Saving SR0001563912... Saving APP-0016707986... Saving APP-0016799749... Saving SR0001563027... Saving APP-0016820177... Saving SR0001563339... Saving APP-0016820105... Saving SR0001545927... Saving SR0001560061... Saving SR0001563938... Saving SR0001564014... Saving SR0001535757... Saving SR0001563198... Saving APP-0016778824... Saving APP-0016573436... Saving SR0001563619... Saving APP-0016813553... Saving 1-9966183589... Saving SR0001563610... Saving APP-0016814617... Saving APP-0016811565... Saving APP-0016813086... Saving APP-0016812509... Saving SR0001563386... Saving 1-9965405261... Saving APP-0016811509... Saving APP-0016811374... Saving APP-0016810777... Saving APP-0016811099... Saving APP-0016811348... Saving APP-0016810296... Saving APP-0016810814... Saving APP-0016810386... Saving SR0001563352... Saving APP-0016806822... Saving APP-0016805232... Saving APP-0016799138... Saving SR0001562702... Saving 1-9963706327... Saving 1-9964138422... Saving APP-0016796756... Saving SR0001557920... Saving SR0001557938... Saving APP-0016805997... Saving APP-0016807595... Saving 1-9963391500... Saving SR0001563017... Saving 1-9963391419... Saving 1-9964291492... Saving SR0001563151... Saving SR0001563126... Saving APP-0016807366... Saving APP-0016808817... Saving SR0001547073... Saving SR0001547074... Saving SR0001547075... Saving SR0001563197... Saving SR0001563219... Saving SR0001562466... Saving APP-0016797566... Saving 1-9962339130... Saving APP-0016805010... Saving APP-0016805381... Saving SR0001562719... Saving SR0001562742... Saving SR0001560127... Saving APP-0016804360... Saving SR0001562463... Saving 1-9951988481... Saving SR0001562557... Saving APP-0016804768... Saving APP-0016805146... Saving APP-0016730431... Saving APP-0016764311... Saving SR0001562551... Saving SR0001562175... Saving SR0001562748... Saving APP-0016804163... Saving APP-0016773300... Saving APP-0016804281... Saving SR0001562120... Saving APP-0016803551... Saving APP-0016803803... Saving SR0001562491... Saving APP-0016787376... Saving APP-0016801362... Saving SR0001561856... Saving SR0001561819... Saving SR0001556012... Saving SR0001559699... Saving SR0001558484... Saving SR0001562315... Saving APP-0016799060... Saving APP-0016799896... Saving APP-0016798382... Saving SR0001562248... Saving APP-0016798399... Saving APP-0016801670... Saving APP-0016799089... Saving SR0001562196... Saving SR0001548814... Saving SR0001562235... Saving SR0001562361... Saving SR0001562102... Saving SR0001558699... Saving APP-0016800282... Saving SR0001554034... Saving SR0001555720... Saving APP-0016797008... Saving APP-0016797826... Saving APP-0016754186... Saving APP-0016795558... Saving APP-0016797968... Saving APP-0016749725... Saving APP-0016749462... Saving APP-0016796990... Saving SR0001561766... Saving 1-9959551572... Saving APP-0016798226... Saving SR0001561810... Saving APP-0016798390... Saving 1-9959209972... Saving APP-0016795752... Saving APP-0016755212... Saving SR0001561893... Saving SR0001561862... Saving SR0001561830... Saving APP-0016785814... Saving SR0001561944... Saving SR0001559777... Saving SR0001561890... Saving APP-0016798015... Saving APP-0016795729... Saving 1-9959209822... Saving APP-0016796513... Saving SR0001561625... Saving SR0001561586... Saving APP-0016792880... Saving APP-0016793460... Saving APP-0016772787... Saving SR0001561508... Saving APP-0016755257... Saving APP-0016790085... Saving APP-0016790130... Saving APP-0016735539... Saving 1-9956857912... Saving APP-0016684192... Saving SR0001561293... Saving SR0001561346... Saving SR0001561230... Saving 1-9957153222... Saving APP-0016785491... Saving APP-0016786256... Saving SR0001561243... Saving 1-9956858053... Saving APP-0016781154... Saving APP-0016733565... Saving SR0001561261... Saving SR0001561194... Saving SR0001560859... Saving SR0001560767... Saving APP-0016785803... Saving SR0001555815... Saving APP-0016783572... Saving SR0001559903... Saving APP-0016783940... Saving APP-0016783400... Saving APP-0016692982... Saving SR0001560858... Saving SR0001560860... Saving APP-0016704074... Saving APP-0016784973... Saving APP-0016736369... Saving APP-0016487608... Saving SR0001560195... Saving SR0001560787... Saving APP-0016783989... Saving APP-0016784719... Saving SR0001560609... Saving SR0001560986... Saving APP-0016705680... Saving APP-0016785992... Saving 1-9955584973... Saving 1-9955589399... Saving SR0001560557... Saving SR0001560071... Saving SR0001560567... Saving SR0001560560... Saving SR0001560666... Saving APP-0016781722... Saving APP-0016774280... Saving SR0001560621... Saving APP-0016540867... Saving SR0001536419... Saving APP-0016778264... Saving APP-0016762704... Saving SR0001560353... Saving SR0001560525... Saving APP-0016782119... Saving 1-9954529643... Saving APP-0016780100... Saving 1-9954730611... Saving SR0001554405... Saving SR0001560442... Saving 1-9954297412... Saving APP-0016765251... Saving APP-0016750809... Saving APP-0016777206... Saving APP-0016778511... Saving 1-9952817385... Saving 1-9953035692... Saving APP-0016776804... Saving APP-0016776522... Saving SR0001560164... Saving 1-9951817290... Saving SR0001560004... Saving SR0001559971... Saving SR0001559626... Saving APP-0016766160... Saving APP-0016759629... Saving 1-9951935100... Saving SR0001559595... Saving SR0001557506... Saving 1-9952280819... Saving 1-9952193852... Saving SR0001558445... Saving APP-0016542636... Saving SR0001559778... Saving APP-0016729656... Saving 1-9951988695... Saving 1-9951934861... Saving SR0001559419... Saving APP-0016773514... Saving APP-0016740126... Saving 1-9949573491... Saving APP-0016771235... Saving SR0001559714... Saving APP-0016771876... Saving SR0001535774... Saving 1-9951480868... Saving APP-0016775089... Saving APP-0016770798... Saving APP-0016770446... Saving APP-0016768500... Saving APP-0016769317... Saving SR0001557331... Saving APP-0016763296... Saving SR0001558996... Saving 1-9949321112... Saving SR0001559039... Saving APP-0016764410... Saving APP-0016762505... Saving 1-9949350413... Saving 1-9949350705... Saving SR0001558987... Saving APP-0016619641... Saving SR0001558957... Saving APP-0016764060... Saving 1-9949337409... Saving SR0001559020... Saving SR0001557188... Saving 1-9949321146... Saving 1-9949351311... Saving SR0001556077... Saving SR0001558425... Saving SR0001558658... Saving SR0001556692... Saving APP-0016761692... Saving SR0001557900... Saving SR0001558627... Saving 1-9948340664... Saving APP-0016760409... Saving APP-0016758438... Saving APP-0016762853... Saving SR0001556731... Saving 1-9948388804... Saving 1-9948577861... Saving SR0001556143... Saving SR0001558787... Saving APP-0016759283... Saving 1-9947088405... Saving SR0001557797... Saving APP-0016757836... Saving 1-9946693113... Saving APP-0016749264... Saving SR0001558509... Saving SR0001558494... Saving 1-9947063512... Saving SR0001468087... Saving SR0001557528... Saving 1-9946692802... Saving 1-9947009442... Saving SR0001558416... Saving SR0001558486... Saving SR0001558407... Saving APP-0016757668... Saving APP-0016759280... Saving SR0001558378... Saving SR0001556075... Saving SR0001558129... Saving SR0001557214... Saving SR0001558335... Saving APP-0016733198... Saving APP-0016756365... Saving APP-0016664894... Saving 1-9946931944... Saving SR0001557984... Saving APP-0016753984... Saving APP-0016741127... Saving APP-0016752832... Saving APP-0016714091... Saving APP-0016752037... Saving 1-9945229022... Saving APP-0016737788... Saving 1-9945550562... Saving APP-0016673914... Saving SR0001555286... Saving SR0001557280... Saving SR0001557700... Saving APP-0016753507... Saving APP-0016753579... Saving SR0001557659... Saving SR0001557794... Saving SR0001557753... Saving 1-9945807312... Saving 1-9945247242... Saving APP-0016750378... Saving 1-9945212921... Saving SR0001557645... Saving SR0001557201... Saving 1-9945539151... Saving APP-0016755389... Saving APP-0016755397... Saving APP-0016753949... Saving APP-0016552295... Saving APP-0016594652... Saving APP-0016739697... Saving 1-9943821252... Saving 1-9944028550... Saving 1-9944028789... Saving APP-0016751946... Saving SR0001556935... Saving APP-0016733708... Saving APP-0016749554... Saving SR0001555205... Saving SR0001557291... Saving SR0001557296... Saving APP-0016751036... Saving SR0001557217... Finished - added 501 records.

Data

Downloaded 47160 times by slav123 dcalde openaustralia AthleticoPrawn mlandauer jesse-a-reilly LoveMyData tkrikke JamesNWeb equivalentideas TheZepto repose-lecture 538digital horecaOZ wee3434 sufiyanirfan3 planometric-vic Nigel78 Joel-Tan_valocity Jedwards157 DevAppProject nadavalon2

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (27.8 MB) Use the API

rows 10 / 71846

date_scraped description info_url date_received council_reference address on_notice_to comment_url latitude longitude
2011-05-24
Porters Liquor Woronora Heights - Packaged liquor licence
http://www.olgr.nsw.gov.au/liquor_applications/docs/1-640005893-Notice.pdf
2010-07-30
1-640005893
Shop 4/69 Warrangarree Drive, Woronora Heights 2233
2010-08-29
mailto:liquorapplications@olgr.nsw.gov.au?subject=Application%20Number:%201-640005893
2011-05-24
The Castle Hill Tavern - Liquor licence transfer
http://www.olgr.nsw.gov.au/liquor_applications/docs/1-716489405-Notice.pdf
2010-08-24
1-716489405
25 Victoria Avenue , Castle Hill 2154
2010-09-23
mailto:liquorapplications@olgr.nsw.gov.au?subject=Application%20Number:%201-716489405
2011-05-24
Aubergine Restaurant - On-premises licence
http://www.olgr.nsw.gov.au/liquor_applications/docs/1-820699167-Notice.pdf
2010-10-14
1-820699167
15 The Strand, Dee Why 2099
2010-11-13
mailto:liquorapplications@olgr.nsw.gov.au?subject=Application%20Number:%201-820699167
2011-05-24
BWS - Beer Wine Spirits - Liquor licence transfer
http://www.olgr.nsw.gov.au/liquor_applications/docs/1-876220035-Notice.pdf
2010-12-09
1-876220035
1 Beinda Street, Bomaderry 2541
2011-01-08
mailto:liquorapplications@olgr.nsw.gov.au?subject=Application%20Number:%201-876220035
2011-05-24
Bartarmon - On-premises licence
http://www.olgr.nsw.gov.au/liquor_applications/docs/1-910958001-Notice.pdf
2011-01-12
1-910958001
100 Hampden Road, Artarmon 2064
2011-02-11
mailto:liquorapplications@olgr.nsw.gov.au?subject=Application%20Number:%201-910958001
2011-05-24
Imperial Hotel - Minors area authorisation
http://www.olgr.nsw.gov.au/liquor_applications/docs/1-918876691-Notice.pdf
2011-01-24
1-918876691
183 John Street, Singleton 2330
2011-02-23
mailto:liquorapplications@olgr.nsw.gov.au?subject=Application%20Number:%201-918876691
2011-05-24
Hunter River Hotel - Minors area authorisation
http://www.olgr.nsw.gov.au/liquor_applications/docs/1-918876708-Notice.pdf
2011-01-24
1-918876708
110 Melbourne Street, East Maitland 2323
2011-02-23
mailto:liquorapplications@olgr.nsw.gov.au?subject=Application%20Number:%201-918876708
2011-05-24
Sarah French Boutique Catering and Events - On-premises licence
http://www.olgr.nsw.gov.au/liquor_applications/docs/1-918741180-Notice.pdf
2011-01-24
1-918741180
7 Gleeson Avenue, Sydenham 2044
2011-02-23
mailto:liquorapplications@olgr.nsw.gov.au?subject=Application%20Number:%201-918741180
2011-05-24
Vaby's Mediteranean Grill Erina - Liquor licence transfer
http://www.olgr.nsw.gov.au/liquor_applications/docs/1-918872277-Notice.pdf
2011-01-24
1-918872277
Shop R0809, Erina Shopping Centre Terrigal Drive, Erina 2250
2011-02-23
mailto:liquorapplications@olgr.nsw.gov.au?subject=Application%20Number:%201-918872277
2011-05-24
St John's College Student's Club - Liquor licence transfer
http://www.olgr.nsw.gov.au/liquor_applications/docs/1-918713601-Notice.pdf
2011-01-24
1-918713601
8a, Missenden Road, Camperdown 2050
2011-02-23
mailto:liquorapplications@olgr.nsw.gov.au?subject=Application%20Number:%201-918713601

Statistics

Average successful run time: 6 minutes

Total run time: 28 days

Total cpu time used: about 2 hours

Total disk space used: 32.6 MB

History

  • Auto ran revision 86296e05 and completed successfully .
    501 records added, 470 records removed in the database
  • Auto ran revision 86296e05 and completed successfully .
    474 records added, 472 records removed in the database
  • Auto ran revision 86296e05 and completed successfully .
    474 records added, 471 records removed in the database
  • Auto ran revision 86296e05 and completed successfully .
    494 records added, 440 records removed in the database
  • Auto ran revision 86296e05 and completed successfully .
    459 records added, 456 records removed in the database
  • ...
  • Created on morph.io

Show complete history