Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEADone in 4, depending on how you classify it you could have up to 17 entries.
For example, in the Faroe Islands you have that 2019-01-01 is for New Year's Day but 2019-12-31 is for New Year's Eve as a public holiday. Given that it is fixed date then 2018-12-31 would be celebrated too implying that Faroe Islands celebrates over 2 days.
Not sure I agree with the output, but this matches it:
I disagree with the output, as there are a bunch of countries which have both New Year's Eve and New Year's Day off, but aren't included in the output. Also Russia should probs be included too...
date | english_name | fixed_date | global_holiday | type | Country_Code | Country_Name |
01/01/2019 | New Year's Day | TRUE | TRUE | Public | AL | Albania |
02/01/2019 | New Year's Day | TRUE | TRUE | Public | AL | Albania |
01/01/2019 | New Year's Day | TRUE | TRUE | Public | DK | Denmark |
31/12/2019 | New Year's Eve | TRUE | TRUE | Bank, School, Optional | DK | Denmark |
01/01/2019 | New Year's Day | TRUE | TRUE | Public | FO | Faroe Islands |
31/12/2019 | New Year's Eve | TRUE | TRUE | Public | FO | Faroe Islands |
01/01/2019 | New Year's Day | FALSE | TRUE | Public | GB | United Kingdom |
02/01/2019 | New Year's Day | FALSE | FALSE | Public | GB | United Kingdom |
01/01/2019 | New Year's Day | TRUE | TRUE | Public | GL | Greenland |
31/12/2019 | New Year's Eve | TRUE | TRUE | Public | GL | Greenland |
01/01/2019 | New Year's Day | TRUE | TRUE | Public | GT | Guatemala |
31/12/2019 | New Year's Eve | TRUE | TRUE | Public | GT | Guatemala |
01/01/2019 | New Year's Day | TRUE | TRUE | Public | IS | Iceland |
31/12/2019 | New Year's Eve | TRUE | TRUE | Public | IS | Iceland |
01/01/2019 | New Year's Day | TRUE | TRUE | Public | LI | Liechtenstein |
31/12/2019 | New Year's Eve | TRUE | TRUE | Public | LI | Liechtenstein |
01/01/2019 | New Year's Day | TRUE | TRUE | Public | LV | Latvia |
31/12/2019 | New Year's Eve | TRUE | TRUE | Public | LV | Latvia |
01/01/2019 | New Year's Day | TRUE | TRUE | Public | NI | Nicaragua |
31/12/2019 | New Year's Eve | TRUE | TRUE | Public | NI | Nicaragua |
01/01/2019 | New Year's Day | FALSE | TRUE | Public | NZ | New Zealand |
02/01/2019 | Day after New Year's Day | FALSE | TRUE | Public | NZ | New Zealand |
01/01/2019 | New Year's Day | TRUE | TRUE | Public | RO | Romania |
02/01/2019 | Day after New Year's Day | TRUE | TRUE | Public | RO | Romania |
01/01/2019 | New Year's Day | TRUE | TRUE | Public | RS | Serbia |
02/01/2019 | New Year's Day | TRUE | TRUE | Public | RS | Serbia |
01/01/2019 | New Year's Day | TRUE | TRUE | Public | RU | Russia |
02/01/2019 | New Year holiday | TRUE | TRUE | Public | RU | Russia |
03/01/2019 | New Year holiday | TRUE | TRUE | Public | RU | Russia |
04/01/2019 | New Year holiday | TRUE | TRUE | Public | RU | Russia |
05/01/2019 | New Year holiday | TRUE | TRUE | Public | RU | Russia |
06/01/2019 | New Year holiday | TRUE | TRUE | Public | RU | Russia |
01/01/2019 | New Year's Day | TRUE | TRUE | Public | SE | Sweden |
31/12/2019 | New Year's Eve | TRUE | TRUE | Public | SE | Sweden |
01/01/2019 | New Year's Day | TRUE | TRUE | Public | SI | Slovenia |
02/01/2019 | New Year's Day | TRUE | TRUE | Public | SI | Slovenia |
01/01/2019 | New Year's Day | TRUE | TRUE | Public | SM | San Marino |
31/12/2019 | New Year's Eve | TRUE | TRUE | Public | SM | San Marino |
01/01/2019 | New Year's Day | TRUE | TRUE | Public | VE | Venezuela |
31/12/2019 | New Year's Eve | TRUE | TRUE | Public | VE | Venezuela |
Here is my solution.