-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathpopulation_ratio_data.sql
More file actions
105 lines (90 loc) · 10.3 KB
/
population_ratio_data.sql
File metadata and controls
105 lines (90 loc) · 10.3 KB
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
--
-- PostgreSQL database dump
--
-- Dumped from database version 17.5
-- Dumped by pg_dump version 17.5
-- Started on 2025-07-29 16:04:44
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET transaction_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;
SET default_tablespace = '';
SET default_table_access_method = heap;
--
-- TOC entry 229 (class 1259 OID 16499)
-- Name: popudata; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.popudata (
country_name text,
indicator_name text,
y1961 double precision,
y1962 double precision,
y1963 double precision,
y1964 double precision,
y1965 double precision,
y1966 double precision,
y1967 double precision,
y1968 double precision,
y1969 double precision,
y1970 double precision,
y1971 double precision,
y1972 double precision,
y1973 double precision,
y1974 double precision,
y1975 double precision,
y1976 double precision,
y1977 double precision,
y1978 double precision,
y1979 double precision,
y1980 double precision,
y1981 double precision,
y1982 double precision,
y1983 double precision,
y1984 double precision,
y1985 double precision,
y1986 double precision,
y1987 double precision,
y1988 double precision
);
ALTER TABLE public.popudata OWNER TO postgres;
--
-- TOC entry 4878 (class 0 OID 16499)
-- Dependencies: 229
-- Data for Name: popudata; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.popudata (country_name, indicator_name, y1961, y1962, y1963, y1964, y1965, y1966, y1967, y1968, y1969, y1970, y1971, y1972, y1973, y1974, y1975, y1976, y1977, y1978, y1979, y1980, y1981, y1982, y1983, y1984, y1985, y1986, y1987, y1988) FROM stdin;
India Employers, female (% of female employment) (modeled ILO estimate) 0.742999971 0.763000011 0.776000023 0.79400003 0.703999996 0.621999979 0.546000004 0.485000014 0.430000007 0.377999991 0.409000009 0.441000015 0.481000006 0.521000028 0.565999985 0.555000007 0.545000017 0.524999976 0.518000007 0.50999999 0.488000005 0.463999987 0.476999998 0.490999997 0.505999982 0.518999994 0.532999992 0.547999978
India Employers, male (% of male employment) (modeled ILO estimate) 2.479000092 2.522000074 2.546000004 2.582999945 2.275000095 1.996999979 1.746999979 1.536999941 1.351999998 1.180999994 1.268000007 1.360999942 1.467000008 1.577000022 1.69599998 1.636999965 1.580000043 1.511000037 1.465999961 1.417000055 1.603999972 1.812999964 1.832000017 1.851999998 1.871999979 1.886999965 1.906000018 1.922999978
India Employers, total (% of total employment) (modeled ILO estimate) 2.042999983 2.078999996 2.09800005 2.128000021 1.875 1.646000028 1.440000057 1.268000007 1.116000056 0.975000024 1.046000004 1.121000051 1.208999991 1.299000025 1.398000002 1.358999968 1.32099998 1.271000028 1.241999984 1.208999991 1.35800004 1.527999997 1.542999983 1.559999943 1.577000022 1.590000033 1.605000019 1.623000026
India Employment in agriculture (% of total employment) (modeled ILO estimate) 63.04800034 62.77099991 62.48600006 62.1780014 61.75699997 61.43700027 61.07600021 60.6609993 59.92499924 59.64500046 59.04600143 58.43399811 57.66899872 56.68099976 55.8219986 54.89599991 53.86199951 53.09199905 52.12400055 51.05599976 48.96099854 47.00400162 46.59899902 46.0719986 45.55899811 45.12400055 44.52199936 43.86000061
India Employment in agriculture, female (% of female employment) (modeled ILO estimate) 76.27899933 76.01999664 75.76100159 75.45700073 75.23300171 75.08300018 74.96399689 74.79599762 74.41999817 74.3789978 73.90499878 73.42900085 72.82499695 72.11000061 71.43499756 70.39800262 69.23400116 68.21299744 66.98100281 65.60700226 62.79700089 59.9679985 59.57799911 59.08800125 58.59500122 58.1629982 57.625 57.06000137
India Employment in agriculture, male (% of male employment) (modeled ILO estimate) 58.61199951 58.31000137 57.99200058 57.64899826 57.15399933 56.76499939 56.30699921 55.79399872 54.92699814 54.54800034 53.85800171 53.1570015 52.30099869 51.18399811 50.22499847 49.5320015 48.73199844 48.2179985 47.51699829 46.72100067 45.04999924 43.52799988 43.0870018 42.51900101 41.97000122 41.49499893 40.83599854 40.17399979
India Employment in industry (% of total employment) (modeled ILO estimate) 15.30099964 15.35900021 15.35000038 15.42500019 15.56400013 15.72799969 15.875 16.02599907 16.22100067 16.31999969 16.66399956 17.04299927 17.55900002 18.38199997 18.97299957 19.64999962 20.44599915 20.96899986 21.6060009 22.37800026 23.52099991 24.35499954 24.35899925 24.37999916 24.3390007 24.28899956 24.47299957 24.68600082
India Employment in industry, female (% of female employment) (modeled ILO estimate) 11.62699986 11.64299965 11.63599968 11.65499973 11.63899994 11.63500023 11.64900017 11.65200043 11.65999985 11.65699959 12.07299995 12.52099991 13.00599957 13.60999966 14.12699986 14.6789999 15.34300041 15.99100018 16.71699905 17.56900024 18.25399971 18.7670002 18.74500084 18.72400093 18.66600037 18.61599922 18.68799973 18.74799919
India Employment in industry, male (% of male employment) (modeled ILO estimate) 16.53199959 16.61000061 16.6079998 16.71100044 16.90500069 17.12999916 17.32600021 17.53199959 17.79400063 17.93300056 18.2670002 18.63500023 19.17200089 20.08200073 20.70999908 21.37000084 22.14900017 22.57299995 23.12199974 23.81100082 25.00900078 25.85400009 25.87800026 25.92399979 25.90099907 25.86800003 26.10000038 26.34399986
India Employment in services (% of total employment) (modeled ILO estimate) 21.65099907 21.87100029 22.16300011 22.39699936 22.67900085 22.83499908 23.04800034 23.31299973 23.85400009 24.03499985 24.29000092 24.52300072 24.77199936 24.93700027 25.20499992 25.45400047 25.69199944 25.94000053 26.27000046 26.56599998 27.5189991 28.64100075 29.04199982 29.54800034 30.10199928 30.58699989 31.00499916 31.45400047
India Employment in services, female (% of female employment) (modeled ILO estimate) 12.09500027 12.33699989 12.60299969 12.88799953 13.12800026 13.28199959 13.38599968 13.55200005 13.92000008 13.96399975 14.02200031 14.05000019 14.17000008 14.27999973 14.43799973 14.92300034 15.42300034 15.79599953 16.30200005 16.8239994 18.9489994 21.26499939 21.67700005 22.18799973 22.73900032 23.22100067 23.68700027 24.19199944
India Employment in services, male (% of male employment) (modeled ILO estimate) 24.8560009 25.08099937 25.40099907 25.63999939 25.94199944 26.10499954 26.36700058 26.67499924 27.27899933 27.5189991 27.875 28.20899963 28.52799988 28.73399925 29.06500053 29.09799957 29.12000084 29.20899963 29.36100006 29.46899986 29.94099998 30.61800003 31.03499985 31.55699921 32.12900162 32.63700104 33.06299973 33.48199844
India Employment to population ratio, 15+, female (%) (modeled ILO estimate) 29.75600052 29.81599998 29.87999916 30.04700089 29.96899986 29.88699913 29.85499954 29.78800011 29.68199921 29.65299988 29.89999962 30.11400032 30.30800056 30.56999969 30.82600021 29.65699959 28.5170002 27.38999939 26.13899994 24.97200012 23.53899956 22.16500092 22.29199982 22.45299911 22.58600044 22.75600052 22.95000076 22.76499939
India Employment to population ratio, 15+, female (%) (national estimate) \N \N \N 30.26539993 \N \N \N \N \N 29.95669937 \N \N \N \N 31.28470039 \N \N \N \N 25.30209923 \N 22.48489952 \N \N \N \N \N \N
India Employment to population ratio, 15+, male (%) (modeled ILO estimate) 82.84700012 82.72499847 82.52600098 82.45400238 82.1989975 81.86100006 81.5719986 81.23300171 80.90899658 80.62999725 80.59400177 80.55999756 80.625 80.88600159 81.06800079 80.81700134 80.5490036 80.08300018 79.41100311 78.95400238 78.4509964 77.86399841 77.6210022 77.50700378 77.3010025 77.05599976 76.88500214 76.83599854
India Employment to population ratio, 15+, male (%) (national estimate) \N \N \N 82.24359894 \N \N \N \N \N 80.44989777 \N \N \N \N 80.84670258 \N \N \N \N 78.17140198 \N 77.17440033 \N \N \N \N \N \N
India Employment to population ratio, 15+, total (%) (modeled ILO estimate) 57.2140007 57.16999817 57.08499908 57.11700058 56.93600082 56.70999908 56.5359993 56.31900024 56.0909996 55.92300034 56.01800156 56.09600067 56.21500015 56.47000122 56.68500137 55.98799896 55.29999924 54.51800156 53.56800079 52.76900101 51.81600189 50.84600067 50.77999878 50.79899979 50.75600052 50.7120018 50.71699905 50.60100174
India Employment to population ratio, 15+, total (%) (national estimate) \N \N \N 56.83409882 \N \N \N \N \N 55.63800049 \N \N \N \N 56.39690018 \N \N \N \N 52.22460175 \N 50.2173996 \N \N \N \N \N \N
India Employment to population ratio, ages 15-24, female (%) (modeled ILO estimate) 24.72900009 24.55400085 24.34600067 24.32900047 23.95700073 23.59499931 23.31500053 22.99300003 22.59399986 22.31299973 22.23999977 22.09499931 21.9470005 21.86400032 21.77400017 20.54500008 19.37999916 18.22900009 16.94199944 15.74800014 14.32999992 13.01599979 12.77600002 12.53600025 12.18999958 11.77200031 11.37199974 11.13099957
India Employment to population ratio, ages 15-24, female (%) (national estimate) \N \N \N 24.45479965 \N \N \N \N \N 22.41790009 \N \N \N \N 21.81889915 \N \N \N \N 15.74590015 \N 12.94250011 \N \N \N \N \N \N
India Employment to population ratio, ages 15-24, male (%) (modeled ILO estimate) 62.77099991 62.46300125 61.95600128 61.74000168 61.25899887 60.68500137 60.16999817 59.61999893 59.07099915 58.57099915 58.43500137 58.25400162 58.27399826 58.54399872 58.67599869 57.18399811 55.64599991 53.6609993 51.29499817 49.27600098 47.51599884 45.65299988 44.94599915 44.43299866 43.68500137 42.77299881 41.9640007 41.69400024
India Employment to population ratio, ages 15-24, male (%) (national estimate) \N \N \N 60.8146019 \N \N \N \N \N 57.65050125 \N \N \N \N 57.70740128 \N \N \N \N 47.22480011 \N 43.96039963 \N \N \N \N \N \N
India Employment to population ratio, ages 15-24, total (%) (modeled ILO estimate) 44.50899887 44.26200104 43.89400101 43.76900101 43.33599854 42.86000061 42.45700073 42.01699829 41.54000092 41.14400101 41.04100037 40.87900162 40.82099915 40.9280014 40.96500015 39.61399841 38.27299881 36.70999908 34.88199997 33.27799988 31.70199966 30.12199974 29.65699959 29.29100037 28.75 28.08499908 27.4810009 27.23399925
\.
-- Completed on 2025-07-29 16:04:45
--
-- PostgreSQL database dump complete
--