A survey by the Carnegie Endowment reveals that the community is dissatisfied with economic opportunities and President Trump's policies