LCBO API Store

Minutes since midnight can be easily converted into 24 hour time. To get the clock hour, divide the minutes since midnight by 60. To get the minute value, mod the number by 60. Here is some example Javascript that demonstrates how to perform the calculation:

function msmTo24time(msm) {
  var hour = msm / 60;
  var mins = msm % 60;
  return [hour, mins];
}

You will probably want to convert the minutes since midnight to 12 hour time since that’s what most folks from Ontario will be familiar with, you can do that with a few extra steps:

function msmTo12time(msm) {
  var time = msmTo24time(msm),
      h24  = time[0],
      h12  = (0 == h24 ? 12 : (h24 > 12 ? (h24 - 10) - 2 : h24)),
      ampm = (h24 >= 12 ? 'PM' : 'AM');
  return [h12, time[1], ampm];
}

Formats

.json	JSON (default format if no extension is supplied)
.js	Javascript (for use with JSON-P, requires `callback` parameter)
.csv	Comma Separated Values
.tsv	Tab Separated Values

Fields

`address_line_1`	Street address
`address_line_2`	Secondary address information (Not all stores)
`city`	City the store is in
`fax`	Fax number (not all stores have one)
`has_beer_cold_room`	True if the store has a walk-in beer fridge
`has_bilingual_services`	True if the store has bilingual services
`has_parking`	True if the store has a parking lot
`has_product_consultant`	True if the store has a product consultant on staff
`has_special_occasion_permits`	True if the store can issue special occasion permits
`has_tasting_bar`	True if the store has a tasting bar
`has_transit_access`	True if the store is accessible by public transit
`has_vintages_corner`	True if the store has a Vintages area
`has_wheelchair_accessability`	True if the store can be entered via wheelchair
`id`	LCBO store number
`inventory_count`	Total inventory units at the store
`inventory_price_in_cents`	Total retail value of all products at the store
`inventory_volume_in_milliliters`	Total volume of all products at the store
`is_dead`	When a store is removed it is marked as "dead"
`latitude`	Reported latitude
`longitude`	Reported longitude
`name`	Official LCBO store name
`postal_code`	Postal code
`products_count`	Total unique products at the store
`store_no`	LCBO store number [Deprecated]
`[sunday..monday]_close`	Minutes since midnight that the store closes
`[sunday..monday]_open`	Minutes since midnight that the store opens
`tags`	A string of tags that reflect the store
`telephone`	Telephone number
`updated_at`	Time that the store information was updated

LCBO API

LCBO API Documentation

Store

Formats

Fields