Skip to content

Instantly share code, notes, and snippets.

@peteryates

peteryates/Public Holidays

Last active August 29, 2015 14:07
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save peteryates/6cfb40a199483d6026bf to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save peteryates/6cfb40a199483d6026bf to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Public Holidays
# select * from public_holidays limit 20;
id | name | date | notes | bunting | country_id | country_region_id | created_at | updated_at
----+---------------------------------------+------------+----------------+---------+------------+-------------------+----------------------------+----------------------------
30 | New Year’s Day | 2012-01-02 | Substitute day | t | 236 | 1 | 2014-08-20 09:08:59.079501 | 2014-08-20 09:08:59.079501
31 | Easter Monday | 2012-04-09 | | t | 236 | 1 | 2014-08-20 09:08:59.081972 | 2014-08-20 09:08:59.081972
32 | Spring bank holiday | 2012-06-04 | Substitute day | t | 236 | 1 | 2014-08-20 09:08:59.084068 | 2014-08-20 09:08:59.084068
33 | Summer bank holiday | 2012-08-27 | | t | 236 | 1 | 2014-08-20 09:08:59.086113 | 2014-08-20 09:08:59.086113
34 | Easter Monday | 2013-04-01 | | t | 236 | 1 | 2014-08-20 09:08:59.088169 | 2014-08-20 09:08:59.088169
35 | Summer bank holiday | 2013-08-26 | | t | 236 | 1 | 2014-08-20 09:08:59.090224 | 2014-08-20 09:08:59.090224
36 | Easter Monday | 2014-04-21 | | t | 236 | 1 | 2014-08-20 09:08:59.092287 | 2014-08-20 09:08:59.092287
37 | Summer bank holiday | 2014-08-25 | | t | 236 | 1 | 2014-08-20 09:08:59.094138 | 2014-08-20 09:08:59.094138
38 | Easter Monday | 2015-04-06 | | t | 236 | 1 | 2014-08-20 09:08:59.096256 | 2014-08-20 09:08:59.096256
39 | Summer bank holiday | 2015-08-31 | | t | 236 | 1 | 2014-08-20 09:08:59.098056 | 2014-08-20 09:08:59.098056
40 | Easter Monday | 2016-03-28 | | t | 236 | 1 | 2014-08-20 09:08:59.099912 | 2014-08-20 09:08:59.099912
41 | Summer bank holiday | 2016-08-29 | | t | 236 | 1 | 2014-08-20 09:08:59.10178 | 2014-08-20 09:08:59.10178
42 | New Year’s Day | 2012-01-02 | Substitute day | t | 236 | 2 | 2014-08-20 09:08:59.104597 | 2014-08-20 09:08:59.104597
43 | St Patrick’s Day | 2012-03-19 | Substitute day | t | 236 | 2 | 2014-08-20 09:08:59.106492 | 2014-08-20 09:08:59.106492
44 | Easter Monday | 2012-04-09 | | t | 236 | 2 | 2014-08-20 09:08:59.108292 | 2014-08-20 09:08:59.108292
45 | Spring bank holiday | 2012-06-04 | | t | 236 | 2 | 2014-08-20 09:08:59.110086 | 2014-08-20 09:08:59.110086
46 | Battle of the Boyne (Orangemen’s Day) | 2012-07-12 | | f | 236 | 2 | 2014-08-20 09:08:59.11186 | 2014-08-20 09:08:59.11186
47 | Summer bank holiday | 2012-08-27 | | t | 236 | 2 | 2014-08-20 09:08:59.113874 | 2014-08-20 09:08:59.113874
48 | St Patrick’s Day | 2013-03-18 | Substitute day | t | 236 | 2 | 2014-08-20 09:08:59.115684 | 2014-08-20 09:08:59.115684
49 | Easter Monday | 2013-04-01 | | t | 236 | 2 | 2014-08-20 09:08:59.11741 | 2014-08-20 09:08:59.11741
lbs_development=# select * from countries where id = 236;
-[ RECORD 1 ]--------------------------
id | 236
code | GB
name | United Kingdom
created_at | 2014-08-20 09:06:13.151335
updated_at | 2014-08-20 09:06:13.151335
lbs_development=# select name from country_regions where country_id = 236;
name
------------------
England
Northern Ireland
Scotland
Wales
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment