Closed crisjf closed 4 years ago
Just added the industry-occupation matrix data to the repo. I also committed the script used to download the single table. @doorleyr I'll leave it up to you to decide where you want to keep scripts like that that are more for documentation than for anything else.
I still need to look into the level of knowledge-intensity/innovation-intensity of each occupation. I'm gonna look into O*Net for this: https://www.onetcenter.org/database.html#all-files
Will add data on R&D expenditure by industry. This will be important to think about innovation, as not only occupations matter but also the industries in which people perform those occupations. Don't think about it as just expenditure, think about it as how important is innovation for companies in each industry.
https://www.nsf.gov/statistics/industry/ https://www.nsf.gov/statistics/srvybrds/
Here is the relevant file: https://ncses.nsf.gov/pubs/nsf20311/assets/data-tables/tables/nsf20311-tab002.xlsx
Previous version: https://www.nsf.gov/statistics/srvyindustry/
I'm going to close this issue for now as we need the CityScope categories to keep developing it.
Next steps: Function to link CItyScope categories to occupations using the industry-occupation matrix. Function to link CityScope categories to innovation intensity based on the funding.
Ready: Link occupation composition to innovation potential.
Need to download the Industry-Occupation matrix by industry available at: https://www.bls.gov/emp/tables/industry-occupation-matrix-industry.htm
Not sure if BLS has an API for this.
Data should answer: How many people in each occupation work in each industry?
Occupations should also be classified on their level of knowledge-intensity/innovation-intensity to build the innovation indicator.