30:T46c,31:[{"id":"b331f4eb0542553c95f6afc70a6efb00cc0ceff7e4bb693bc0af61917af7af23bcb0b3a4d52b06f85a438fa8310e2467a3a376bf84e9dda8d61b826259037199","href":"https://static.observableusercontent.com/files/b331f4eb0542553c95f6afc70a6efb00cc0ceff7e4bb693bc0af61917af7af23bcb0b3a4d52b06f85a438fa8310e2467a3a376bf84e9dda8d61b826259037199","name":"2023-ts-tz-asia-tokyo.csv","type":"text/csv","lastModified":1677059750227.035,"size":4403},{"id":"eb6653097bb28e2399b8146b1d1d66044b27ea392c2bd26badd14e74423c00b62d18054f201a042849d3920c98b745bbe0738444ec3fca40ab5bddc20a8ae3d2","href":"https://static.observableusercontent.com/files/eb6653097bb28e2399b8146b1d1d66044b27ea392c2bd26badd14e74423c00b62d18054f201a042849d3920c98b745bbe0738444ec3fca40ab5bddc20a8ae3d2","name":"2023-macau-holidays.csv","type":"text/csv","lastModified":1677059750261.698,"size":1705},{"id":"607811ce0bfe46a997cec17851756963ea290d9773052a447c0d3ce138fc6ae966b09e09e8ac556b1ffad64328a105762daadfa9a5cc687b5eddfd2078285c90","href":"https://static.observableusercontent.com/files/607811ce0bfe46a997cec17851756963ea290d9773052a447c0d3ce138fc6ae966b09e09e8ac556b1ffad64328a105762daadfa9a5cc687b5eddfd2078285c90","name":"2023-us-holidays.csv","type":"text/csv","lastModified":1677059750258.952,"size":817},{"id":"f188399db5d549c5e05e3c156c25e5a90e60d1878d32dc3596aafcc89963cd0e48a577406ed78216dca162dca269fb04d158923b4afadc612fb46fcb6d1117d0","href":"https://static.observableusercontent.com/files/f188399db5d549c5e05e3c156c25e5a90e60d1878d32dc3596aafcc89963cd0e48a577406ed78216dca162dca269fb04d158923b4afadc612fb46fcb6d1117d0","name":"2023-uk-holidays.csv","type":"text/csv","lastModified":1677059750264.018,"size":525},{"id":"f2d4599ca5df00c28744b993e0a603096a1ac7c4ec4da501e9610319d7848e5ae3d33503dfa0142be228c783a24e2235ebafb9b717c078ca6c48f37a78176e84","href":"https://static.observableusercontent.com/files/f2d4599ca5df00c28744b993e0a603096a1ac7c4ec4da501e9610319d7848e5ae3d33503dfa0142be228c783a24e2235ebafb9b717c078ca6c48f37a78176e84","name":"2023-japan-holidays.csv","type":"text/csv","lastModified":1677059750265.006,"size":1059},{"id":"746cbdd4b75430729fe2ab97231551602c6dd60f57fc46dbb442621f65bcdd6d218cdf5139a533f6993cdaa4198f3bfb7e3187cd90b789c016885666c40d977c","href":"https://static.observableusercontent.com/files/746cbdd4b75430729fe2ab97231551602c6dd60f57fc46dbb442621f65bcdd6d218cdf5139a533f6993cdaa4198f3bfb7e3187cd90b789c016885666c40d977c","name":"2023-china-holidays.csv","type":"text/csv","lastModified":1677059750266.919,"size":1906},{"id":"e114f4f8893964c0f14a24b9787e12ba2015a22dbec32f6eb03bcd3472b8c15471a6821bbe7c08e70af03623af2490009709dcab73e9947dd1b5b3f797008584","href":"https://static.observableusercontent.com/files/e114f4f8893964c0f14a24b9787e12ba2015a22dbec32f6eb03bcd3472b8c15471a6821bbe7c08e70af03623af2490009709dcab73e9947dd1b5b3f797008584","name":"2023-south-korea-holidays.csv","type":"text/csv","lastModified":1677059750277.545,"size":964},{"id":"3ec0bf0ff1326a3a2b86d6f0448525da0dba63e89213d89bab6e9ce1fc7ca03b092451d48e8bc37185e811a6dce42c2a597b0284423dda53c8496864ab1669fd","href":"https://static.observableusercontent.com/files/3ec0bf0ff1326a3a2b86d6f0448525da0dba63e89213d89bab6e9ce1fc7ca03b092451d48e8bc37185e811a6dce42c2a597b0284423dda53c8496864ab1669fd","name":"2023-taiwan-holidays.csv","type":"text/csv","lastModified":1677059750269.123,"size":2152},{"id":"c9517a2121a35e36484dce6c8e17d10502a8035b87656d8505db83b57e9afe45c73e339480d6d62e397b57e196ba946e49c6a53c2a1959d5a1070591192a4582","href":"https://static.observableusercontent.com/files/c9517a2121a35e36484dce6c8e17d10502a8035b87656d8505db83b57e9afe45c73e339480d6d62e397b57e196ba946e49c6a53c2a1959d5a1070591192a4582","name":"2023-hong-kong-holidays.csv","type":"text/csv","lastModified":1677059750316.592,"size":1411}] 2e:{"title":"Got A Date!?","cells":[{"id":0,"value":"# Got A Date!?\nUtilities for date related operations and data because date, time, and timezones are complicated in JavaScript\n- https://www.epochconverter.com/\n- https://timestamp.online/","pinned":false,"hidden":false,"mode":"md"},{"id":4,"value":"function generateDates(startDate, endDate, isLocal = true) {\n // Parse the start and end dates using D3's timeParse function\n const parseTime = d3.timeParse(\"%Y-%m-%d\");\n const start = parseTime(startDate);\n const end = parseTime(endDate);\n\n // Create an array to store the generated dates\n const dates = [];\n\n // Loop through each day between the start and end dates, adding 1 day each time\n for (let day = start; day <= end; day = d3.timeDay.offset(day, 1)) {\n // Format the date as a string using D3's timeFormat function\n const formattedDate = d3.timeFormat(\"%Y-%m-%d\")(day);\n const ts = isLocal\n ? Date.parse(`${formattedDate} 00:00:00`) / 1000\n : Date.parse(`${formattedDate} 00:00:00 UTC`) / 1000;\n\n // Add the formatted date to the dates array\n dates.push({ ts, date: formattedDate });\n }\n\n // Return the generated dates array\n return dates;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":210,"value":"sampleGenerateDates = generateDates(\"2023-01-01\", \"2023-01-05\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":328,"value":"typeof sampleGenerateDates[0].date","pinned":true,"hidden":false,"mode":"ojs"},{"id":216,"value":"epoch2human = (ts, short = false) =>\n short ? new Date(ts * 1000).toDateString() : new Date(ts * 1000).toString()","pinned":true,"hidden":false,"mode":"ojs"},{"id":214,"value":"epoch2human(1672498800)","pinned":true,"hidden":false,"mode":"ojs"},{"id":316,"value":"epoch2human(sampleGenerateDates[0].ts)","pinned":true,"hidden":false,"mode":"ojs"},{"id":219,"value":"human2epoch = (date) => Math.floor(Date.parse(date) / 1000)","pinned":true,"hidden":false,"mode":"ojs"},{"id":206,"value":"human2epoch(\"2023-01-01 00:00:00 GMT +9\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":258,"value":"epochOffset = (ts, days) => ts + days * 86400 // 1 day in seconds is 24 * 60 * 60","pinned":true,"hidden":false,"mode":"ojs"},{"id":260,"value":"epoch2human(epochOffset(1672498800, -1))","pinned":true,"hidden":false,"mode":"ojs"},{"id":238,"value":"function timeCounter(t, obj = true) {\n const days = parseInt(t / 86400);\n t = t - days * 86400;\n\n const hours = parseInt(t / 3600);\n t = t - hours * 3600;\n\n const minutes = parseInt(t / 60);\n t = t - minutes * 60;\n\n return obj\n ? { days, hours, minutes }\n : `${days} days, ${hours} hours, and ${minutes} minutes`;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":242,"value":"timeCounter(14 * 60 * 60)","pinned":true,"hidden":false,"mode":"ojs"},{"id":338,"value":"function timeSinceMidnight(timestampInSeconds) {\n // Convert the timestamp to milliseconds\n const timestampInMs = timestampInSeconds * 1000;\n\n // Create a new date object from the timestamp\n const date = new Date(timestampInMs);\n\n // Get the number of milliseconds elapsed since midnight\n const elapsedMs =\n date.getTime() -\n new Date(date.getFullYear(), date.getMonth(), date.getDate()).getTime();\n\n // Convert milliseconds to seconds and return the result\n return Math.floor(elapsedMs / 1000);\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":340,"value":"function timeResetToMidnight(timestampInSeconds) {\n // Convert the timestamp to milliseconds\n const timestampInMs = timestampInSeconds * 1000;\n\n // Create a new date object from the timestamp\n const date = new Date(timestampInMs);\n\n // Get the number of milliseconds elapsed since midnight\n const elapsedMs =\n date.getTime() -\n new Date(date.getFullYear(), date.getMonth(), date.getDate()).getTime();\n\n // Convert milliseconds to seconds and return the result\n return timestampInSeconds - Math.floor(elapsedMs / 1000);\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":342,"value":"function timeLeftTillMidnight(timestampInSeconds) {\n // Convert the timestamp to milliseconds\n const timestampInMs = timestampInSeconds * 1000;\n\n // Create a new date object from the timestamp\n const date = new Date(timestampInMs);\n\n // Get the timestamp for midnight of the same day\n const midnightTimestampInMs = new Date(\n date.getFullYear(),\n date.getMonth(),\n date.getDate() + 1\n ).getTime();\n\n // Calculate the number of seconds left until midnight\n const secondsLeft = Math.floor(\n (midnightTimestampInMs - timestampInMs) / 1000\n );\n\n // Return the result\n return secondsLeft;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":9,"value":"async function getPublicHolidays(countries, year) {\n const baseUrl = \"https://date.nager.at/api/v3\";\n\n // Create an array to store the public holidays for all countries\n const publicHolidays = [];\n\n // Loop through each country and get its public holidays for the specified year\n for (const country of countries) {\n const url = `${baseUrl}/publicholidays/${year}/${country}`;\n\n // Send a GET request to the API to get the public holidays for the country and year\n const response = await fetch(url);\n const holidays = await response.json();\n\n // Add the public holidays for the country to the publicHolidays array\n publicHolidays.push({\n country,\n holidays\n });\n }\n\n // Return the public holidays for all countries\n return publicHolidays;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":288,"value":"## Html Helpers","pinned":false,"hidden":false,"mode":"md"},{"id":286,"value":"note = {\n const scope = DOM.uid(\"note\").id;\n const style = document.head.appendChild(htl.html`","pinned":false,"hidden":false,"mode":"html"},{"id":62,"value":"# 2023 Public Holidays Cache\n```getPublicHolidays(['japan', 'china', ...], 2023)```","pinned":false,"hidden":false,"mode":"md"},{"id":41,"value":"## Japan","pinned":false,"hidden":false,"mode":"md"},{"id":303,"value":"Japan's timezone is JST which is 9 hours or ${9 * 60 * 60} seconds ahead of UTC.","pinned":false,"hidden":false,"mode":"md"},{"id":323,"value":"jp_holidays = await FileAttachment(\"2023-japan-holidays.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":46,"value":"## China","pinned":false,"hidden":false,"mode":"md"},{"id":166,"value":"cn_holidays = await FileAttachment(\"2023-china-holidays.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":50,"value":"## South Korea","pinned":false,"hidden":false,"mode":"md"},{"id":170,"value":"sk_holidays = await FileAttachment(\"2023-south-korea-holidays.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":57,"value":"## Hong Kong","pinned":false,"hidden":false,"mode":"md"},{"id":173,"value":"hk_holidays = await FileAttachment(\"2023-hong-kong-holidays.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":149,"value":"## Taiwan","pinned":false,"hidden":false,"mode":"md"},{"id":176,"value":"taiwan_holidays = await FileAttachment(\"2023-taiwan-holidays.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":151,"value":"## Macau","pinned":false,"hidden":false,"mode":"md"},{"id":179,"value":"mo_holidays = await FileAttachment(\"2023-macau-holidays.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":153,"value":"## United States of America","pinned":false,"hidden":false,"mode":"md"},{"id":182,"value":"us_holidays = await FileAttachment(\"2023-us-holidays.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":156,"value":"## United Kingdom","pinned":false,"hidden":false,"mode":"md"},{"id":186,"value":"uk_holidays = await FileAttachment(\"2023-uk-holidays.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}