-
Notifications
You must be signed in to change notification settings - Fork 7
/
census_metadata_load.sql
112 lines (75 loc) · 12.2 KB
/
census_metadata_load.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
COPY public.census_tabulation_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/unified_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2007_1yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2007_1yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2007_1yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2007_1yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2007_3yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2007_3yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2007_3yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2007_3yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2008_1yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2008_1yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2008_1yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2008_1yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2008_3yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2008_3yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2008_3yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2008_3yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2009_1yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2009_1yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2009_1yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2009_1yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2009_3yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2009_3yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2009_3yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2009_3yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2010_1yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2010_1yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2010_1yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2010_1yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2010_3yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2010_3yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2010_3yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2010_3yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2010_5yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2010_5yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2010_5yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2010_5yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2011_1yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2011_1yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2011_1yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2011_1yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2011_3yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2011_3yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2011_3yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2011_3yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2011_5yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2011_5yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2011_5yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2011_5yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2012_1yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2012_1yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2012_1yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2012_1yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2012_3yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2012_3yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2012_3yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2012_3yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2012_5yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2012_5yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2012_5yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2012_5yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2013_1yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2013_1yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2013_1yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2013_1yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2013_3yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2013_3yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2013_3yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2013_3yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2013_5yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2013_5yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2013_5yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2013_5yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2014_1yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2014_1yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2014_1yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2014_1yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2014_5yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2014_5yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2014_5yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2014_5yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2015_1yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2015_1yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2015_1yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2015_1yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2015_5yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2015_5yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2015_5yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2015_5yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2016_1yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2016_1yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2016_1yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2016_1yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2016_5yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2016_5yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2016_5yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2016_5yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2017_1yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2017_1yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2017_1yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2017_1yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2017_5yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2017_5yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2017_5yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2017_5yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2018_1yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2018_1yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2018_1yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2018_1yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2018_5yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2018_5yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2018_5yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2018_5yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2019_1yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2019_1yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2019_1yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2019_1yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2019_5yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2019_5yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2019_5yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2019_5yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2020_5yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2020_5yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2020_5yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2020_5yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2021_1yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2021_1yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2021_1yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2021_1yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2021_5yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2021_5yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2021_5yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2021_5yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2021_1yr_tables.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2021_1yr_tables/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2021_1yr_tables.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2021_1yr_tables/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2022_1yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2022_1yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2022_1yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2022_1yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2022_5yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2022_5yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2022_5yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2022_5yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2023_1yr.census_table_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2023_1yr/census_table_metadata.csv' WITH csv ENCODING 'utf8' HEADER;
COPY acs2023_1yr.census_column_metadata FROM '/home/ubuntu/census-table-metadata/precomputed/acs2023_1yr/census_column_metadata.csv' WITH csv ENCODING 'utf8' HEADER;