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_uni_80659dfc" DOUBLE,
  "software_development_job_postings_on_indeed_in_the_uni_284bafdc" DOUBLE,
  "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_unit_9a069d84" DOUBLE,
  "it_operations_and_helpdesk_job_postings_on_indeed_in_t_04e479ce" DOUBLE,
  "it_operations_and_helpdesk_job_postings_on_indeed_in_t_88baed23" DOUBLE,
  "it_operations_and_helpdesk_job_postings_on_indeed_in_t_49d40294" DOUBLE,
  "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_stat_88ce4436" DOUBLE,
  "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,
  "hospitality_and_tourism_job_postings_on_indeed_in_the__9d1e3b69" DOUBLE,
  "hospitality_and_tourism_job_postings_on_indeed_in_the__8e43ede9" DOUBLE,
  "hospitality_and_tourism_job_postings_on_indeed_in_the__cdff1d9e" DOUBLE,
  "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_710d0a68" DOUBLE,
  "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_u_54bcb1d9" DOUBLE,
  "electrical_engineering_job_postings_on_indeed_in_the_u_ff8a9c7a" DOUBLE,
  "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_s_5de3fd1a" DOUBLE,
  "scientific_research_and_development_job_postings_on_in_e030250f" DOUBLE,
  "scientific_research_and_development_job_postings_on_in_c320c20c" DOUBLE,
  "scientific_research_and_development_job_postings_on_in_025aa9d9" DOUBLE,
  "production_and_manufacturing_job_postings_on_indeed_in_d8b082c1" DOUBLE,
  "production_and_manufacturing_job_postings_on_indeed_in_94bd0faa" DOUBLE,
  "production_and_manufacturing_job_postings_on_indeed_in_dedf2c1f" DOUBLE,
  "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_unite_6f148fb3" DOUBLE,
  "industrial_engineering_job_postings_on_indeed_in_the_u_8b0d3c8c" DOUBLE,
  "industrial_engineering_job_postings_on_indeed_in_the_u_e3ede666" DOUBLE,
  "industrial_engineering_job_postings_on_indeed_in_the_u_3e4db961" DOUBLE,
  "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_bf25748a" DOUBLE,
  "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_edeea70a" DOUBLE,
  "food_preparation_and_service_job_postings_on_indeed_in_94fb0f72" DOUBLE,
  "physicians_and_surgeons_job_postings_on_indeed_in_the__c72fda34" DOUBLE,
  "physicians_and_surgeons_job_postings_on_indeed_in_the__f3457d62" DOUBLE,
  "physicians_and_surgeons_job_postings_on_indeed_in_the__d49ad98f" DOUBLE,
  "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_f8e4a05c" DOUBLE,
  "information_design_and_documentation_job_postings_on_i_7d516c6a" DOUBLE,
  "information_design_and_documentation_job_postings_on_i_9e39a3c7" DOUBLE,
  "information_design_and_documentation_job_postings_on_i_8ea974d7" DOUBLE,
  "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__4d5e1ca1" DOUBLE,
  "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_state_adcadeea" DOUBLE,
  "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,
  "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_uni_2005dc42" DOUBLE,
  "loading_and_stocking_job_postings_on_indeed_in_the_uni_10231539" DOUBLE,
  "cleaning_and_sanitation_job_postings_on_indeed_in_the__0ef0a0e3" DOUBLE,
  "cleaning_and_sanitation_job_postings_on_indeed_in_the__b7ee279a" DOUBLE,
  "cleaning_and_sanitation_job_postings_on_indeed_in_the__aa838dc5" DOUBLE,
  "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__e5b68245" DOUBLE,
  "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
);