City Holidays

City of San Francisco

@usgov.city_of_san_francisco_city_holidays

Table List

1 table(11.7 KB)

Table 1

@usgov.city_of_san_francisco_city_holidays.table_1

11.7 KB
193 rows
9 columns

holiday_name Holiday Name	holiday_year Holiday Year	holiday_day Holiday Day	holiday_date Holiday Date	holiday_weekday Holiday Weekday	observed_date Observed Date	observed_weekday Observed Weekday	data_as_of Data As Of	data_loaded_at Data Loaded At
New Year's Day	2010	January 1	Fri Jan 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Friday	Fri Jan 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Friday	2024/06/12 12:00:00 AM	2024/06/12 07:01:45 PM
Martin Luther King Jr. Day	2010	January 18	Mon Jan 18 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Monday	Mon Jan 18 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Monday	2024/06/12 12:00:00 AM	2024/06/12 07:01:45 PM
Presidents' Day	2010	February 15	Mon Feb 15 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Monday	Mon Feb 15 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Monday	2024/06/12 12:00:00 AM	2024/06/12 07:01:45 PM
Memorial Day	2010	May 31	Mon May 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Monday	Mon May 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Monday	2024/06/12 12:00:00 AM	2024/06/12 07:01:45 PM
Independence Day	2010	July 4	Sun Jul 04 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Sunday	Mon Jul 05 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Monday	2024/06/12 12:00:00 AM	2024/06/12 07:01:45 PM
Labor Day	2010	September 6	Mon Sep 06 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Monday	Mon Sep 06 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Monday	2024/06/12 12:00:00 AM	2024/06/12 07:01:45 PM
Columbus Day	2010	October 11	Mon Oct 11 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Monday	Mon Oct 11 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Monday	2024/06/12 12:00:00 AM	2024/06/12 07:01:45 PM
Veterans Day	2010	November 11	Thu Nov 11 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Thursday	Thu Nov 11 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Thursday	2024/06/12 12:00:00 AM	2024/06/12 07:01:45 PM
Thanksgiving Day	2010	November 25	Thu Nov 25 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Thursday	Thu Nov 25 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Thursday	2024/06/12 12:00:00 AM	2024/06/12 07:01:45 PM
Day After Thanksgiving	2010	November 26	Fri Nov 26 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Friday	Fri Nov 26 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Friday	2024/06/12 12:00:00 AM	2024/06/12 07:01:45 PM


CREATE TABLE table_1 (
  "holiday_name" VARCHAR,
  "holiday_year" BIGINT,
  "holiday_day" VARCHAR,
  "holiday_date" TIMESTAMP,
  "holiday_weekday" VARCHAR,
  "observed_date" TIMESTAMP,
  "observed_weekday" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);