FRED Indeed Job Postings Index W Functional Groups

CREATE TABLE fred_indeedjobsbyfunctionalgroup_data_daily (
  "date" TIMESTAMP,
  "job_postings_on_indeed_in_the_united_states" DOUBLE,
  "job_postings_on_indeed_in_the_united_states_30day_pct" DOUBLE,
  "job_postings_on_indeed_in_the_united_states_365day_pct" DOUBLE,
  "new_job_postings_on_indeed_in_the_united_states" DOUBLE,
  "new_job_postings_on_indeed_in_the_united_states_30day_pct" DOUBLE,
  "new_job_postings_on_indeed_in_the_united_states_365day_pct" DOUBLE,
  "software_development_job_postings_on_indeed_in_the_uni_4a77f882" DOUBLE  -- Software Development Job Postings On Indeed In The United States,
  "software_development_job_postings_on_indeed_in_the_uni_80659dfc" DOUBLE  -- Software Development Job Postings On Indeed In The United States 30day Pct,
  "software_development_job_postings_on_indeed_in_the_uni_284bafdc" DOUBLE  -- Software Development Job Postings On Indeed In The United States 365day Pct,
  "banking_and_finance_job_postings_on_indeed_in_the_united_states" DOUBLE,
  "banking_and_finance_job_postings_on_indeed_in_the_unit_ed10acc0" DOUBLE  -- Banking And Finance Job Postings On Indeed In The United States 30day Pct,
  "banking_and_finance_job_postings_on_indeed_in_the_unit_9a069d84" DOUBLE  -- Banking And Finance Job Postings On Indeed In The United States 365day Pct,
  "it_operations_and_helpdesk_job_postings_on_indeed_in_t_04e479ce" DOUBLE  -- IT Operations And Helpdesk Job Postings On Indeed In The United States,
  "it_operations_and_helpdesk_job_postings_on_indeed_in_t_88baed23" DOUBLE  -- IT Operations And Helpdesk Job Postings On Indeed In The United States 30day Pct,
  "it_operations_and_helpdesk_job_postings_on_indeed_in_t_49d40294" DOUBLE  -- IT Operations And Helpdesk Job Postings On Indeed In The United States 365day Pct,
  "construction_job_postings_on_indeed_in_the_united_states" DOUBLE,
  "construction_job_postings_on_indeed_in_the_united_stat_99731c3b" DOUBLE  -- Construction Job Postings On Indeed In The United States 30day Pct,
  "construction_job_postings_on_indeed_in_the_united_stat_88ce4436" DOUBLE  -- Construction Job Postings On Indeed In The United States 365day Pct,
  "marketing_job_postings_on_indeed_in_the_united_states" DOUBLE,
  "marketing_job_postings_on_indeed_in_the_united_states_30day_pct" DOUBLE,
  "marketing_job_postings_on_indeed_in_the_united_states__fcfb91cb" DOUBLE  -- Marketing Job Postings On Indeed In The United States 365day Pct,
  "hospitality_and_tourism_job_postings_on_indeed_in_the__9d1e3b69" DOUBLE  -- Hospitality And Tourism Job Postings On Indeed In The United States,
  "hospitality_and_tourism_job_postings_on_indeed_in_the__8e43ede9" DOUBLE  -- Hospitality And Tourism Job Postings On Indeed In The United States 30day Pct,
  "hospitality_and_tourism_job_postings_on_indeed_in_the__cdff1d9e" DOUBLE  -- Hospitality And Tourism Job Postings On Indeed In The United States 365day Pct,
  "accounting_job_postings_on_indeed_in_the_united_states" DOUBLE,
  "accounting_job_postings_on_indeed_in_the_united_states_871b3ad1" DOUBLE  -- Accounting Job Postings On Indeed In The United States 30day Pct,
  "accounting_job_postings_on_indeed_in_the_united_states_710d0a68" DOUBLE  -- Accounting Job Postings On Indeed In The United States 365day Pct,
  "retail_job_postings_on_indeed_in_the_united_states" DOUBLE,
  "retail_job_postings_on_indeed_in_the_united_states_30day_pct" DOUBLE,
  "retail_job_postings_on_indeed_in_the_united_states_365day_pct" DOUBLE,
  "nursing_job_postings_on_indeed_in_the_united_states" DOUBLE,
  "nursing_job_postings_on_indeed_in_the_united_states_30day_pct" DOUBLE,
  "nursing_job_postings_on_indeed_in_the_united_states_365day_pct" DOUBLE,
  "electrical_engineering_job_postings_on_indeed_in_the_u_3c87343a" DOUBLE  -- Electrical Engineering Job Postings On Indeed In The United States,
  "electrical_engineering_job_postings_on_indeed_in_the_u_54bcb1d9" DOUBLE  -- Electrical Engineering Job Postings On Indeed In The United States 30day Pct,
  "electrical_engineering_job_postings_on_indeed_in_the_u_ff8a9c7a" DOUBLE  -- Electrical Engineering Job Postings On Indeed In The United States 365day Pct,
  "human_resources_job_postings_on_indeed_in_the_united_states" DOUBLE,
  "human_resources_job_postings_on_indeed_in_the_united_s_04d7c742" DOUBLE  -- Human Resources Job Postings On Indeed In The United States 30day Pct,
  "human_resources_job_postings_on_indeed_in_the_united_s_5de3fd1a" DOUBLE  -- Human Resources Job Postings On Indeed In The United States 365day Pct,
  "scientific_research_and_development_job_postings_on_in_e030250f" DOUBLE  -- Scientific Research And Development Job Postings On Indeed In The United States,
  "scientific_research_and_development_job_postings_on_in_c320c20c" DOUBLE  -- Scientific Research And Development Job Postings On Indeed In The United States 30day Pct,
  "scientific_research_and_development_job_postings_on_in_025aa9d9" DOUBLE  -- Scientific Research And Development Job Postings On Indeed In The United States 365day Pct,
  "production_and_manufacturing_job_postings_on_indeed_in_d8b082c1" DOUBLE  -- Production And Manufacturing Job Postings On Indeed In The United States,
  "production_and_manufacturing_job_postings_on_indeed_in_94bd0faa" DOUBLE  -- Production And Manufacturing Job Postings On Indeed In The United States 30day Pct,
  "production_and_manufacturing_job_postings_on_indeed_in_dedf2c1f" DOUBLE  -- Production And Manufacturing Job Postings On Indeed In The United States 365day Pct,
  "sales_job_postings_on_indeed_in_the_united_states" DOUBLE,
  "sales_job_postings_on_indeed_in_the_united_states_30day_pct" DOUBLE,
  "sales_job_postings_on_indeed_in_the_united_states_365day_pct" DOUBLE,
  "project_management_job_postings_on_indeed_in_the_united_states" DOUBLE,
  "project_management_job_postings_on_indeed_in_the_unite_9567e89a" DOUBLE  -- Project Management Job Postings On Indeed In The United States 30day Pct,
  "project_management_job_postings_on_indeed_in_the_unite_6f148fb3" DOUBLE  -- Project Management Job Postings On Indeed In The United States 365day Pct,
  "industrial_engineering_job_postings_on_indeed_in_the_u_8b0d3c8c" DOUBLE  -- Industrial Engineering Job Postings On Indeed In The United States,
  "industrial_engineering_job_postings_on_indeed_in_the_u_e3ede666" DOUBLE  -- Industrial Engineering Job Postings On Indeed In The United States 30day Pct,
  "industrial_engineering_job_postings_on_indeed_in_the_u_3e4db961" DOUBLE  -- Industrial Engineering Job Postings On Indeed In The United States 365day Pct,
  "civil_engineering_job_postings_on_indeed_in_the_united_states" DOUBLE,
  "civil_engineering_job_postings_on_indeed_in_the_united_ef9cbdf9" DOUBLE  -- Civil Engineering Job Postings On Indeed In The United States 30day Pct,
  "civil_engineering_job_postings_on_indeed_in_the_united_bf25748a" DOUBLE  -- Civil Engineering Job Postings On Indeed In The United States 365day Pct,
  "driving_job_postings_on_indeed_in_the_united_states" DOUBLE,
  "driving_job_postings_on_indeed_in_the_united_states_30day_pct" DOUBLE,
  "driving_job_postings_on_indeed_in_the_united_states_365day_pct" DOUBLE,
  "food_preparation_and_service_job_postings_on_indeed_in_a91e0ca3" DOUBLE  -- Food Preparation And Service Job Postings On Indeed In The United States,
  "food_preparation_and_service_job_postings_on_indeed_in_edeea70a" DOUBLE  -- Food Preparation And Service Job Postings On Indeed In The United States 30day Pct,
  "food_preparation_and_service_job_postings_on_indeed_in_94fb0f72" DOUBLE  -- Food Preparation And Service Job Postings On Indeed In The United States 365day Pct,
  "physicians_and_surgeons_job_postings_on_indeed_in_the__c72fda34" DOUBLE  -- Physicians And Surgeons Job Postings On Indeed In The United States,
  "physicians_and_surgeons_job_postings_on_indeed_in_the__f3457d62" DOUBLE  -- Physicians And Surgeons Job Postings On Indeed In The United States 30day Pct,
  "physicians_and_surgeons_job_postings_on_indeed_in_the__d49ad98f" DOUBLE  -- Physicians And Surgeons Job Postings On Indeed In The United States 365day Pct,
  "management_job_postings_on_indeed_in_the_united_states" DOUBLE,
  "management_job_postings_on_indeed_in_the_united_states_cdf6f32b" DOUBLE  -- Management Job Postings On Indeed In The United States 30day Pct,
  "management_job_postings_on_indeed_in_the_united_states_f8e4a05c" DOUBLE  -- Management Job Postings On Indeed In The United States 365day Pct,
  "information_design_and_documentation_job_postings_on_i_7d516c6a" DOUBLE  -- Information Design And Documentation Job Postings On Indeed In The United States,
  "information_design_and_documentation_job_postings_on_i_9e39a3c7" DOUBLE  -- Information Design And Documentation Job Postings On Indeed In The United States 30day Pct,
  "information_design_and_documentation_job_postings_on_i_8ea974d7" DOUBLE  -- Information Design And Documentation Job Postings On Indeed In The United States 365day Pct,
  "customer_service_job_postings_on_indeed_in_the_united_states" DOUBLE,
  "customer_service_job_postings_on_indeed_in_the_united__7aaf1a1d" DOUBLE  -- Customer Service Job Postings On Indeed In The United States 30day Pct,
  "customer_service_job_postings_on_indeed_in_the_united__4d5e1ca1" DOUBLE  -- Customer Service Job Postings On Indeed In The United States 365day Pct,
  "dental_job_postings_on_indeed_in_the_united_states" DOUBLE,
  "dental_job_postings_on_indeed_in_the_united_states_30day_pct" DOUBLE,
  "dental_job_postings_on_indeed_in_the_united_states_365day_pct" DOUBLE,
  "mathematics_job_postings_on_indeed_in_the_united_states" DOUBLE,
  "mathematics_job_postings_on_indeed_in_the_united_state_708fcbb9" DOUBLE  -- Mathematics Job Postings On Indeed In The United States 30day Pct,
  "mathematics_job_postings_on_indeed_in_the_united_state_adcadeea" DOUBLE  -- Mathematics Job Postings On Indeed In The United States 365day Pct,
  "childcare_job_postings_on_indeed_in_the_united_states" DOUBLE,
  "childcare_job_postings_on_indeed_in_the_united_states_30day_pct" DOUBLE,
  "childcare_job_postings_on_indeed_in_the_united_states__76f91076" DOUBLE  -- Childcare Job Postings On Indeed In The United States 365day Pct,
  "legal_job_postings_on_indeed_in_the_united_states" DOUBLE,
  "legal_job_postings_on_indeed_in_the_united_states_30day_pct" DOUBLE,
  "legal_job_postings_on_indeed_in_the_united_states_365day_pct" DOUBLE,
  "loading_and_stocking_job_postings_on_indeed_in_the_uni_0ff6071d" DOUBLE  -- Loading And Stocking Job Postings On Indeed In The United States,
  "loading_and_stocking_job_postings_on_indeed_in_the_uni_2005dc42" DOUBLE  -- Loading And Stocking Job Postings On Indeed In The United States 30day Pct,
  "loading_and_stocking_job_postings_on_indeed_in_the_uni_10231539" DOUBLE  -- Loading And Stocking Job Postings On Indeed In The United States 365day Pct,
  "cleaning_and_sanitation_job_postings_on_indeed_in_the__0ef0a0e3" DOUBLE  -- Cleaning And Sanitation Job Postings On Indeed In The United States,
  "cleaning_and_sanitation_job_postings_on_indeed_in_the__b7ee279a" DOUBLE  -- Cleaning And Sanitation Job Postings On Indeed In The United States 30day Pct,
  "cleaning_and_sanitation_job_postings_on_indeed_in_the__aa838dc5" DOUBLE  -- Cleaning And Sanitation Job Postings On Indeed In The United States 365day Pct,
  "logistic_support_job_postings_on_indeed_in_the_united_states" DOUBLE,
  "logistic_support_job_postings_on_indeed_in_the_united__42e16d98" DOUBLE  -- Logistic Support Job Postings On Indeed In The United States 30day Pct,
  "logistic_support_job_postings_on_indeed_in_the_united__e5b68245" DOUBLE  -- Logistic Support Job Postings On Indeed In The United States 365day Pct,
  "insurance_job_postings_on_indeed_in_the_united_states" DOUBLE,
  "insurance_job_postings_on_indeed_in_the_united_states_30day_pct" DOUBLE,
  "insurance_job_postings_on_indeed_in_the_united_states__b8026b66" DOUBLE  -- Insurance Job Postings On Indeed In The United States 365day Pct
);