7,649
edits
Changes
Jump to navigation
Jump to search
Vermont Science and Technology Plan (view source)
Revision as of 14:25, 22 February 2023
, 14:25, 22 February 2023→Census Data
* The JobsEQ data has unknown providence and sampling criteria. It shows the number of technology firms at around the same level as the Census data in 2010 but then JobsEQ data shows dramatic growth while the Census data shows a material contraction. The most likely explanation is that the JobsEQ data is not correctly recording establishment exits.
* The Vermont Center for Emerging Technologies (VCET) was founded in 2005, before the major collapse of Vermont's technology sector between 2006 and 2010.
==== Relative Growth ====
[[File:RelativeTechnologyEmployment_Vermont.PNG|right|500px]] It is also interesting to look at Vermont's relative growth in technology establishments and employment:
* The data was retrieved in bulk from https://www.census.gov/data/datasets/time-series/econ/bds/bds-datasets.html and downloaded by sector and state from 1978 to 2020.
* State codes are available in https://www2.census.gov/programs-surveys/bds/technical-documentation/label_state.csv
* Files are E:\projects\census\BDS Bulk Analysis
* SQL script is BulkAnalysis.sql
[[File:RelativeTechnologyEstablishments_Vermont.PNG|right|500px]] I processed the data so that each state's establishments and employment are relative to their year 2000 levels. The establishments' data makes it clear that the Vermont Science and Technology Plan's numbers are patently absurd. They show Vermont with a growth rate of 59% from 2010 to 2020, which is more than 2.6 times the fastest growth rate achieved by the fastest-growing state (Delaware) over the same period.
=== Example 2: Quantifying the Vermont Manufacturing Sector ===
