Skip to content

Instantly share code, notes, and snippets.

@rvaheldendaten

rvaheldendaten/gist:2be5fba604214f2d235b

Created March 1, 2016 17:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rvaheldendaten/2be5fba604214f2d235b to your computer and use it in GitHub Desktop.
Save rvaheldendaten/2be5fba604214f2d235b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';
SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';
SET FirstWeekDay=6;
SET BrokenWeeks=1;
SET ReferenceDay=0;
SET FirstMonthOfYear=1;
SET CollationLocale='en-US';
[US per capita personal income by state]:
SET ThousandSep=',';
SET DecimalSep='.';
LIB CONNECT TO 'DM (myuser)';
[US per capita personal income by state]:
LOAD "Country",
"State",
"Year",
"US dollars";
SQL SELECT * FROM "51w0";
store [US per capita personal income by state] into [c:\US per capita personal income by state.qvd];
drop table [US per capita personal income by state];
[US gross domestic product by state]:
SET ThousandSep=',';
SET DecimalSep='.';
//LIB CONNECT TO 'DM (myuser)';
[US gross domestic product by state]:
LOAD "Country",
"State",
"Year",
"Millions of chained 2009 US dollars",
"Millions of US dollars";
SQL SELECT * FROM "51vz"
WHERE "8sfh" = "1.2";
store [US gross domestic product by state] into [C:\US gross domestic product by state.qvd];
drop table [US gross domestic product by state];
[US consumer price index for urban consumers]:
SET ThousandSep=',';
SET DecimalSep='.';
//LIB CONNECT TO 'DM (myuser)';
[US consumer price index for urban consumers]:
LOAD "Year-and-month",
"CPI";
SQL SELECT * FROM "51w2";
store [US consumer price index for urban consumers] into [c:\US consumer price index for urban consumers.qvd];
drop table [US consumer price index for urban consumers];
[European national accounts - GDP and main components]:
SET ThousandSep=',';
SET DecimalSep='.';
//LIB CONNECT TO 'DM (myuser)';
[European national accounts - GDP and main components]:
SQL SELECT * FROM "50k9"
WHERE "8pce" = "h.10.f.11.s.j.3.12.u.m.y.w.c.i.l.x.d.5.6.v.g.z.r.7.9.p.t.q.2.1.e.13.o.b.k.4.a.n.8"
AND "8pcf" = "2.1";
store [European national accounts - GDP and main components] into [c:\European national accounts - GDP and main components.qvd];
drop table [European national accounts - GDP and main components];
[US employment, unemployment, and earnings]:
SET ThousandSep=',';
SET DecimalSep='.';
//LIB CONNECT TO 'DM (myuser)';
[US employment, unemployment, and earnings]:
LOAD "Country",
"State",
"Year-and-month",
"Average earnings for private employees (dollars per hour)",
"Number of non-farm employees",
"Unemployment rate";
SQL SELECT * FROM "51xg"
WHERE "8sll" = "3.2.1";
store [US employment, unemployment, and earnings] into [c:\US employment, unemployment, and earnings.qvd];
drop table [US employment, unemployment, and earnings];
[US federal interest rate]:
SET ThousandSep=',';
SET DecimalSep='.';
//LIB CONNECT TO 'DM (myuser)';
[US federal interest rate]:
LOAD "Date",
"Effective federal funds rate";
SQL SELECT * FROM "51w1";
store [US federal interest rate] into [c:\US federal interest rate.qvd];
drop table [US federal interest rate];
disconnect;
[21x21 currency exchange rates]:
SET ThousandSep=',';
SET DecimalSep='.';
LIB CONNECT TO 'DM (myuser)';
[21x21 currency exchange rates]:
LOAD "Base currency",
"Quote currency",
"DateTime",
"Exchange rate";
SQL SELECT * FROM "50e7";
store [21x21 currency exchange rates] into [c:\21x21 currency exchange rates.qvd];
drop table [21x21 currency exchange rates];
[Population of Canada by provinces or territories]:
SET ThousandSep=',';
SET DecimalSep='.';
//LIB CONNECT TO 'DM (myuser)';
[Population of Canada by provinces or territories]:
LOAD "Province or territory",
"Sex",
"Age",
"Year",
"Number of people";
SQL SELECT * FROM "535r";
store [Population of Canada by provinces or territories] into [c:\Population of Canada by provinces or territories.qvd];
drop table [Population of Canada by provinces or territories];
[Population of Europe by country and region]:
SET ThousandSep=',';
SET DecimalSep='.';
//LIB CONNECT TO 'DM (myuser)';
[Population of Europe by country and region]:
LOAD "Country",
"NUTS 1 region",
"NUTS 2 region",
"Age aggregate",
"Age",
"Sex aggregate",
"Sex",
"Year",
"Number of people";
SQL SELECT * FROM "51y6";
store [Population of Europe by country and region] into [c:\Population of Europe by country and region.qvd];
drop table [Population of Europe by country and region];
[US population by state, race, sex and age]:
SET ThousandSep=',';
SET DecimalSep='.';
//LIB CONNECT TO 'DM (myuser)';
[US population by state, race, sex and age]:
LOAD "State",
"Race aggregate",
"Race",
"Sex aggregate",
"Sex",
"Age aggregate",
"Age",
"Year",
"Persons";
SQL SELECT * FROM "51xd";
store [US population by state, race, sex and age] into [c:\US population by state race sex and age.qvd];
drop table [US population by state, race, sex and age];
disconnect;
[Business Dynamics Statistics: firms by sector, size and age]:
SET ThousandSep=',';
SET DecimalSep='.';
LIB CONNECT TO 'DM (myuser)';
[Business Dynamics Statistics: firms by sector, size and age]:
LOAD "Broad industry categories",
"Firm size",
"Firm age",
"Year",
"Davis-Haltiwanger-Schuh (DHS) denominator",
"Employment associated with firm deaths",
"Establishment exits",
"Establishments associated with firm deaths",
"Establishments born during the last 12 months",
"Firms that have exited in their entirety during the period",
"Jobs created",
"Jobs created by continuing establishments",
"Jobs created by establisment births",
"Jobs destroyed",
"Jobs destroyed at continuing establishments",
"Jobs destroyed by establishment exit",
"Net jobs created",
"Net rate of jobs created",
"Number of establishments",
"Number of firms",
"Rate of establishment exits",
"Rate of establishments born during the last 12 months",
"Rate of jobs created",
"Rate of jobs created by establisment births",
"Rate of jobs destroyed",
"Rate of jobs destroyed by establishment exit",
"Rate of jobs reallocations",
"Total sum of March 12 employment";
SQL SELECT * FROM "4ycp"
WHERE "8lj3" = "4.o.7.n.5.m.9.b.a.e.g.f.j.k.2.1.8.6.d.c.i.h.l.3";
store [Business Dynamics Statistics: firms by sector, size and age] into [c:\Business Dynamics Statistics firms by sector, size and age.qvd];
drop table [Business Dynamics Statistics: firms by sector, size and age];
[Business Dynamics Statistics: firms by state, size and age]:
SET ThousandSep=',';
SET DecimalSep='.';
//LIB CONNECT TO 'DM (myuser)';
[Business Dynamics Statistics: firms by state, size and age]:
LOAD "Firm size",
"Firm age",
"State",
"Year",
"Davis-Haltiwanger-Schuh (DHS) denominator",
"Employment associated with firm deaths",
"Establishment exits",
"Establishments associated with firm deaths",
"Establishments born during the last 12 months",
"Firms that have exited in their entirety during the period",
"Jobs created",
"Jobs created by continuing establishments",
"Jobs created by establishment births",
"Jobs destroyed",
"Jobs destroyed at continuing establishments",
"Jobs destroyed by establishment exit",
"Net jobs created",
"Net rate of jobs created",
"Number of establishments",
"Number of firms",
"Rate of establishment exits",
"Rate of establishments born during the last 12 months",
"Rate of jobs created",
"Rate of jobs created by establishment births",
"Rate of jobs destroyed",
"Rate of jobs destroyed by establishment exit",
"Rate of jobs reallocations",
"Total sum of March 12 employment";
SQL SELECT * FROM "4yc6"
WHERE "8lhh" = "4.o.7.n.5.m.9.b.a.e.g.f.j.k.2.1.8.6.d.c.i.h.l.3";
store [Business Dynamics Statistics: firms by state, size and age] into [c:\Business Dynamics Statistics firms by state, size and age.qvd];
drop table [Business Dynamics Statistics: firms by state, size and age];
disconnect;
[Europe: people at risk of poverty or social exclusion]:
SET ThousandSep=',';
SET DecimalSep='.';
LIB CONNECT TO 'DM (myuser)';
[Europe: people at risk of poverty or social exclusion]:
LOAD "Country",
"Age aggregate",
"Age",
"Sex aggregate",
"Sex",
"Year",
"Cumulative difference from 2008, in thousands",
"Percentage of total population",
"Thousand persons";
SQL SELECT * FROM "51sr"
WHERE "8rwt" = "3.2.1";
store [Europe: people at risk of poverty or social exclusion] into [c:\Europe_ people at risk of poverty or social exclusion.qvd];
drop table [Europe: people at risk of poverty or social exclusion];
[European minimum wages by country]:
SET ThousandSep=',';
SET DecimalSep='.';
//LIB CONNECT TO 'DM (myuser)';
[European minimum wages by country]:
LOAD "Country",
"Year",
"Euros per month";
SQL SELECT * FROM "51ss";
store [European minimum wages by country] into [c:\European minimum wages by country.qvd];
drop table [European minimum wages by country];
[European unemployment by country]:
SET ThousandSep=',';
SET DecimalSep='.';
//LIB CONNECT TO 'DM (myuser)';
[European unemployment by country]:
LOAD "Country",
"Age aggregate",
"Age",
"Sex aggregate",
"Sex",
"Year-and-month",
"Percentage of labour force";
SQL SELECT * FROM "51sq";
store [European unemployment by country] into [C:\European unemployment by country.qvd];
drop table [European unemployment by country];
[US economic characteristics (by state)]:
SET ThousandSep=',';
SET DecimalSep='.';
//LIB CONNECT TO 'DM (myuser)';
[US economic characteristics (by state)]:
LOAD "Country",
"State",
"Year",
"Civilian employed population 16 years and over - Government workers",
"Civilian employed population 16 years and over - Private wage and salary workers",
"Civilian employed population 16 years and over - Self-employed in own not incorporated business workers",
"Civilian employed population 16 years and over - Unpaid family workers",
"Civilian employed population 16 years and over (Class of worker)",
"Workers 16 years and over",
"Workers 16 years and over - Car, truck, or van -- carpooled",
"Workers 16 years and over - Car, truck, or van -- drove alone",
"Workers 16 years and over - Mean travel time to work (minutes)",
"Workers 16 years and over - Other means",
"Workers 16 years and over - Public transportation (excluding taxicab)",
"Workers 16 years and over - Walked",
"Workers 16 years and over - Worked at home",
"Civilian labor force",
"Females 16 years and over",
"Females 16 years and over - In labor force",
"Females 16 years and over - In labor force - Civilian labor force",
"Females 16 years and over - In labor force - Civilian labor force - Employed",
"Own children 6 to 17 years",
"Own children 6 to 17 years - All parents in family in labor force",
"Own children under 6 years",
"Own children under 6 years - All parents in family in labor force",
"Population 16 years and over",
"Population 16 years and over - In labor force",
"Population 16 years and over - In labor force - Armed Forces",
"Population 16 years and over - In labor force - Civilian labor force",
"Population 16 years and over - In labor force - Civilian labor force - Employed",
"Population 16 years and over - In labor force - Civilian labor force - Unemployed",
"Population 16 years and over - Not in labor force",
"Civilian noninstitutionalized population",
"Civilian noninstitutionalized population 18 to 64 years",
"Civilian noninstitutionalized population 18 to 64 years - In labor force:",
"Civilian noninstitutionalized population 18 to 64 years - In labor force: - Employed:",
"Civilian noninstitutionalized population 18 to 64 years - In labor force: - Employed: - No health insurance coverage",
"Civilian noninstitutionalized population 18 to 64 years - In labor force: - Employed: - With health insurance coverage",
"Civilian noninstitutionalized population 18 to 64 years - In labor force: - Employed: - With health insurance coverage - With private health insurance",
"Civilian noninstitutionalized population 18 to 64 years - In labor force: - Employed: - With health insurance coverage - With public coverage",
"Civilian noninstitutionalized population 18 to 64 years - In labor force: - Unemployed:",
"Civilian noninstitutionalized population 18 to 64 years - In labor force: - Unemployed: - No health insurance coverage",
"Civilian noninstitutionalized population 18 to 64 years - In labor force: - Unemployed: - With health insurance coverage",
"Civilian noninstitutionalized population 18 to 64 years - In labor force: - Unemployed: - With health insurance coverage - With private health insurance",
"Civilian noninstitutionalized population 18 to 64 years - In labor force: - Unemployed: - With health insurance coverage - With public coverage",
"Civilian noninstitutionalized population 18 to 64 years - Not in labor force:",
"Civilian noninstitutionalized population 18 to 64 years - Not in labor force: - No health insurance coverage",
"Civilian noninstitutionalized population 18 to 64 years - Not in labor force: - With health insurance coverage",
"Civilian noninstitutionalized population 18 to 64 years - Not in labor force: - With health insurance coverage - With private health insurance",
"Civilian noninstitutionalized population 18 to 64 years - Not in labor force: - With health insurance coverage - With public coverage",
"Civilian noninstitutionalized population - No health insurance coverage",
"Civilian noninstitutionalized population - With health insurance coverage",
"Civilian noninstitutionalized population - With health insurance coverage - With private health insurance",
"Civilian noninstitutionalized population - With health insurance coverage - With public coverage",
"Civilian noninstitutionalized population under 18 years",
"Civilian noninstitutionalized population under 18 years - No health insurance coverage",
"Families",
"Families - $10,000 to $14,999",
"Families - $15,000 to $24,999",
"Families - $25,000 to $34,999",
"Families - $35,000 to $49,999",
"Families - $50,000 to $74,999",
"Families - $75,000 to $99,999",
"Families - $100,000 to $149,999",
"Families - $150,000 to $199,999",
"Families - $200,000 or more",
"Families - Less than $10,000",
"Families - Mean family income (dollars)",
"Families - Median family income (dollars)",
"Families - Per capita income (dollars)",
"Median earnings for female full-time, year-round workers (dollars)",
"Median earnings for male full-time, year-round workers (dollars)",
"Median earnings for workers (dollars)",
"Nonfamily households",
"Nonfamily households - Mean nonfamily income (dollars)",
"Nonfamily households - Median nonfamily income (dollars)",
"Total households",
"Total households - $10,000 to $14,999",
"Total households - $15,000 to $24,999",
"Total households - $25,000 to $34,999",
"Total households - $35,000 to $49,999",
"Total households - $50,000 to $74,999",
"Total households - $75,000 to $99,999",
"Total households - $100,000 to $149,999",
"Total households - $150,000 to $199,999",
"Total households - $200,000 or more",
"Total households - Less than $10,000",
"Total households - Mean household income (dollars)",
"Total households - Median household income (dollars)",
"Total households - With cash public assistance income",
"Total households - With cash public assistance income - Mean cash public assistance income (dollars)",
"Total households - With earnings",
"Total households - With earnings - Mean earnings (dollars)",
"Total households - With Food Stamp/SNAP benefits in the past 12 months",
"Total households - With retirement income",
"Total households - With retirement income - Mean retirement income (dollars)",
"Total households - With Social Security",
"Total households - With Social Security - Mean Social Security income (dollars)",
"Total households - With Supplemental Security Income",
"Total households - With Supplemental Security Income - Mean Supplemental Security Income (dollars)",
"Civilian employed population 16 years and over - Agriculture, forestry, fishing and hunting, and mining",
"Civilian employed population 16 years and over - Arts, entertainment, and recreation, and accommodation and food services",
"Civilian employed population 16 years and over - Construction",
"Civilian employed population 16 years and over - Educational services, and health care and social assistance",
"Civilian employed population 16 years and over - Finance and insurance, and real estate and rental and leasing",
"Civilian employed population 16 years and over - Information",
"Civilian employed population 16 years and over - Manufacturing",
"Civilian employed population 16 years and over - Other services, except public administration",
"Civilian employed population 16 years and over - Professional, scientific, and management, and administrative and waste management services",
"Civilian employed population 16 years and over - Public administration",
"Civilian employed population 16 years and over - Retail trade",
"Civilian employed population 16 years and over - Transportation and warehousing, and utilities",
"Civilian employed population 16 years and over - Wholesale trade",
"Civilian employed population 16 years and over (Industry)",
"Civilian employed population 16 years and over - Management, business, science, and arts occupations",
"Civilian employed population 16 years and over - Natural resources, construction, and maintenance occupations",
"Civilian employed population 16 years and over - Production, transportation, and material moving occupations",
"Civilian employed population 16 years and over - Sales and office occupations",
"Civilian employed population 16 years and over - Service occupations",
"Civilian employed population 16 years and over (Occupation)";
SQL SELECT * FROM "51y3"
WHERE "8snz" = "2z.1l.y.23.3h.1x.1f.2e.s.3c.2q.29.2v.3b.2l.18.3f.2o.1p.h.v.2x.2u.2g.r.26.3a.1e.f.25.2y.3e.33.1o.1w.2d.11.t.2h.1d.2p.28.1v.1a.a.1g.10.1s.1m.8.1b.1h.x.20.1j.l.q.32.2t.2c.d.1k.13.12.c.p.2a.m.1z.35.3d.16.2j.2n.38.k.1n.1c.1t.22.2k.17.9.31.36.21.2s.37.2r.n.24.39.2m.j.1r.b.o.3g.34.2b.1y.2w.w.1i.15.u.2i.1q.i.19.3j.1u.27.z.2f.14.3i";
store [US economic characteristics (by state)] into [c:\US economic characteristics (by state).qvd];
drop table [US economic characteristics (by state)];
[US housing characteristics (by state)]:
SET ThousandSep=',';
SET DecimalSep='.';
//LIB CONNECT TO 'DM (myuser)';
[US housing characteristics (by state)]:
LOAD "Country",
"State",
"Year",
"No bedroom",
"Total housing units (Bedrooms)",
"1 bedroom",
"2 bedrooms",
"3 bedrooms",
"4 bedrooms",
"5 or more bedrooms",
"Occupied units paying rent",
"Occupied units paying rent - $1,000 to $1,499",
"Occupied units paying rent - $1,500 or more",
"Occupied units paying rent - $200 to $299",
"Occupied units paying rent - $300 to $499",
"Occupied units paying rent - $500 to $749",
"Occupied units paying rent - $750 to $999",
"Occupied units paying rent - Less than $200",
"Occupied units paying rent - Median (dollars)",
"Occupied units paying rent - No rent paid",
"Occupied units paying rent (excluding units where GRAPI cannot be computed)",
"Occupied units paying rent (excluding units where GRAPI cannot be computed) - 15.0 to 19.9 percent",
"Occupied units paying rent (excluding units where GRAPI cannot be computed) - 20.0 to 24.9 percent",
"Occupied units paying rent (excluding units where GRAPI cannot be computed) - 25.0 to 29.9 percent",
"Occupied units paying rent (excluding units where GRAPI cannot be computed) - 30.0 to 34.9 percent",
"Occupied units paying rent (excluding units where GRAPI cannot be computed) - 35.0 percent or more",
"Occupied units paying rent (excluding units where GRAPI cannot be computed) - Less than 15.0 percent",
"Occupied units paying rent (excluding units where GRAPI cannot be computed) - Not computed",
"Occupied housing units - Bottled, tank, or LP gas",
"Occupied housing units - Coal or coke",
"Occupied housing units - Electricity",
"Occupied housing units - Fuel oil, kerosene, etc.",
"Occupied housing units - No fuel used",
"Occupied housing units - Other fuel",
"Occupied housing units - Solar energy",
"Occupied housing units - Utility gas",
"Occupied housing units - Wood",
"Occupied housing units (House heating fuel)",
"Total housing units - Homeowner vacancy rate",
"Total housing units - Occupied housing units",
"Total housing units - Rental vacancy rate",
"Total housing units - Vacant housing units",
"Total housing units (Housing occupancy)",
"Occupied housing units - Average household size of owner-occupied unit",
"Occupied housing units - Average household size of renter-occupied unit",
"Occupied housing units - Owner-occupied",
"Occupied housing units - Renter-occupied",
"Occupied housing units (Housing tenure)",
"Owner-occupied units - Housing units with a mortgage",
"Owner-occupied units - Housing units without a mortgage",
"Owner-occupied units (Mortgage status)",
"Occupied housing units - 1.00 or less",
"Occupied housing units - 1.01 to 1.50",
"Occupied housing units - 1.51 or more",
"Occupied housing units (Occupants per room)",
"Median rooms",
"Total housing units (Rooms)",
"1 room",
"2 rooms",
"3 rooms",
"4 rooms",
"5 rooms",
"6 rooms",
"7 rooms",
"8 rooms",
"9 rooms or more",
"Occupied housing units - Lacking complete kitchen facilities",
"Occupied housing units - Lacking complete plumbing facilities",
"Occupied housing units - No telephone service available",
"Occupied housing units (Selected characteristics)",
"Housing units with a mortgage",
"Housing units with a mortgage - $1,000 to $1,499",
"Housing units with a mortgage - $1,500 to $1,999",
"Housing units with a mortgage - $2,000 or more",
"Housing units with a mortgage - $300 to $499",
"Housing units with a mortgage - $500 to $699",
"Housing units with a mortgage - $700 to $999",
"Housing units with a mortgage - Less than $300",
"Housing units with a mortgage - Median (dollars)",
"Housing units without a mortgage",
"Housing units without a mortgage - $100 to $199",
"Housing units without a mortgage - $200 to $299",
"Housing units without a mortgage - $300 to $399",
"Housing units without a mortgage - $400 or more",
"Housing units without a mortgage - Less than $100",
"Housing units without a mortgage - Median (dollars)",
"Housing unit without a mortgage (excluding units where SMOCAPI cannot be computed)",
"Housing unit without a mortgage (excluding units where SMOCAPI cannot be computed) - 10.0 to 14.9 percent",
"Housing unit without a mortgage (excluding units where SMOCAPI cannot be computed) - 15.0 to 19.9 percent",
"Housing unit without a mortgage (excluding units where SMOCAPI cannot be computed) - 20.0 to 24.9 percent",
"Housing unit without a mortgage (excluding units where SMOCAPI cannot be computed) - 25.0 to 29.9 percent",
"Housing unit without a mortgage (excluding units where SMOCAPI cannot be computed) - 30.0 to 34.9 percent",
"Housing unit without a mortgage (excluding units where SMOCAPI cannot be computed) - 35.0 percent or more",
"Housing unit without a mortgage (excluding units where SMOCAPI cannot be computed) - Less than 10.0 percent",
"Housing unit without a mortgage (excluding units where SMOCAPI cannot be computed) - Not computed",
"Housing units with a mortgage (excluding units where SMOCAPI cannot be computed)",
"Housing units with a mortgage (excluding units where SMOCAPI cannot be computed) - 20.0 to 24.9 percent",
"Housing units with a mortgage (excluding units where SMOCAPI cannot be computed) - 25.0 to 29.9 percent",
"Housing units with a mortgage (excluding units where SMOCAPI cannot be computed) - 30.0 to 34.9 percent",
"Housing units with a mortgage (excluding units where SMOCAPI cannot be computed) - 35.0 percent or more",
"Housing units with a mortgage (excluding units where SMOCAPI cannot be computed) - Less than 20.0 percent",
"Housing units with a mortgage (excluding units where SMOCAPI cannot be computed) - Not computed",
"Boat, RV, van, etc.",
"Mobile home",
"Total housing units (Units in structure)",
"1-unit, attached",
"1-unit, detached",
"2 units",
"3 or 4 units",
"5 to 9 units",
"10 to 19 units",
"20 or more units",
"Owner-occupied units - $1,000,000 or more",
"Owner-occupied units - $50,000 to $99,999",
"Owner-occupied units - $100,000 to $149,999",
"Owner-occupied units - $150,000 to $199,999",
"Owner-occupied units - $200,000 to $299,999",
"Owner-occupied units - $300,000 to $499,999",
"Owner-occupied units - $500,000 to $999,999",
"Owner-occupied units - Less than $50,000",
"Owner-occupied units - Median (dollars)",
"Owner-occupied units (Value)",
"Occupied housing units - 1 vehicle available",
"Occupied housing units - 2 vehicles available",
"Occupied housing units - 3 or more vehicles available",
"Occupied housing units - No vehicles available",
"Occupied housing units (Vehicles available)",
"Occupied housing units - Moved in 1969 or earlier",
"Occupied housing units - Moved in 1970 to 1979",
"Occupied housing units - Moved in 1980 to 1989",
"Occupied housing units - Moved in 1990 to 1999",
"Occupied housing units - Moved in 2000 to 2009",
"Occupied housing units - Moved in 2010 or later",
"Occupied housing units (Year householder moved into unit)",
"Built 1939 or earlier",
"Built 1940 to 1949",
"Built 1950 to 1959",
"Built 1960 to 1969",
"Built 1970 to 1979",
"Built 1980 to 1989",
"Built 1990 to 1999",
"Built 2000 to 2009",
"Built 2010 or later",
"Total housing units (Year structure built)";
SQL SELECT * FROM "51y4"
WHERE "8so1" = "23.4k.1h.2t.2y.2p.22.2b.w.1e.35.2n.2x.4c.1p.1z.v.14.45.2r.1u.2f.n.3m.2e.m.4d.3f.1g.1n.3n.15.21.2s.4r.10.1x.3j.j.4h.46.3c.16.3o.4f.3y.l.4o.2j.3z.1l.4g.39.4q.2m.x.3g.27.1t.17.13.47.3q.2a.r.3a.4n.20.3l.3r.1a.1v.3b.2v.1f.29.1m.p.3w.3p.2z.t.2h.1y.37.3d.44.40.3h.y.2q.s.24.3k.42.k.11.1i.1d.1k.26.4p.38.2l.1s.2k.2g.18.q.4b.2i.30.1j.25.1c.3u.3x.2w.4m.4e.3v.12.43.4j.36.1q.2c.i.z.3i.4i.1o.34.u.2d.3t.1b.3s.48.28.4l";
store [US housing characteristics (by state)] into [c:\US housing characteristics (by state).qvd];
drop table [US housing characteristics (by state)];
[US social characteristics (by state)]:
SET ThousandSep=',';
SET DecimalSep='.';
//LIB CONNECT TO 'DM (myuser)';
[US social characteristics (by state)]:
LOAD "Country",
"State",
"Year",
"Total population - American",
"Total population - Arab",
"Total population - Czech",
"Total population - Danish",
"Total population - Dutch",
"Total population - English",
"Total population - French (except Basque)",
"Total population - French Canadian",
"Total population - German",
"Total population - Greek",
"Total population - Hungarian",
"Total population - Irish",
"Total population - Italian",
"Total population - Lithuanian",
"Total population - Norwegian",
"Total population - Polish",
"Total population - Portuguese",
"Total population - Russian",
"Total population - Scotch-Irish",
"Total population - Scottish",
"Total population - Slovak",
"Total population - Subsaharan African",
"Total population - Swedish",
"Total population - Swiss",
"Total population - Ukrainian",
"Total population - Welsh",
"Total population - West Indian (excluding Hispanic origin groups)",
"Total population (Ancestry)",
"Total Civilian Noninstitutionalized Population",
"Total Civilian Noninstitutionalized Population - With a disability",
"Under 18 years",
"Under 18 years - With a disability",
"18 to 64 years",
"18 to 64 years - With a disability",
"65 years and over",
"65 years and over - With a disability",
"Population 25 years and over",
"Population 25 years and over - 9th to 12th grade, no diploma",
"Population 25 years and over - Associate's degree",
"Population 25 years and over - Bachelor's degree",
"Population 25 years and over - Graduate or professional degree",
"Population 25 years and over - High school graduate (includes equivalency)",
"Population 25 years and over - Less than 9th grade",
"Population 25 years and over - Some college, no degree",
"Number of women 15 to 50 years old who had a birth in the past 12 months",
"Number of women 15 to 50 years old who had a birth in the past 12 months - Per 1,000 women 15 to 19 years old",
"Number of women 15 to 50 years old who had a birth in the past 12 months - Per 1,000 women 15 to 50 years old",
"Number of women 15 to 50 years old who had a birth in the past 12 months - Per 1,000 women 20 to 34 years old",
"Number of women 15 to 50 years old who had a birth in the past 12 months - Per 1,000 women 35 to 50 years old",
"Number of women 15 to 50 years old who had a birth in the past 12 months - Unmarried women (widowed, divorced, and never married)",
"Number of women 15 to 50 years old who had a birth in the past 12 months - Unmarried women (widowed, divorced, and never married) - Per 1,000 unmarried women",
"Number of grandparents living with own grandchildren under 18 years",
"Number of grandparents living with own grandchildren under 18 years - Responsible for grandchildren",
"Number of grandparents living with own grandchildren under 18 years - Years responsible for grandchildren - 1 or 2 years",
"Number of grandparents living with own grandchildren under 18 years - Years responsible for grandchildren - 3 or 4 years",
"Number of grandparents living with own grandchildren under 18 years - Years responsible for grandchildren - 5 or more years",
"Number of grandparents living with own grandchildren under 18 years - Years responsible for grandchildren - Less than 1 year",
"Number of grandparents responsible for own grandchildren under 18 years",
"Number of grandparents responsible for own grandchildren under 18 years - Who are female",
"Number of grandparents responsible for own grandchildren under 18 years - Who are married",
"Total households",
"Total households - Average family size",
"Total households - Average household size",
"Total households - Family households (families)",
"Total households - Family households (families) - With own children under 18 years",
"Total households - Female householder, no husband present, family",
"Total households - Female householder, no husband present, family - With own children under 18 years",
"Total households - Households with one or more people 65 years and over",
"Total households - Households with one or more people under 18 years",
"Total households - Male householder, no wife present, family",
"Total households - Male householder, no wife present, family - With own children under 18 years",
"Total households - Married-couple family",
"Total households - Married-couple family - With own children under 18 years",
"Total households - Nonfamily households",
"Total households - Nonfamily households - Householder living alone",
"Total households - Nonfamily households - Householder living alone - 65 years and over",
"Population 5 years and over",
"Population 5 years and over - Asian and Pacific Islander languages",
"Population 5 years and over - Asian and Pacific Islander languages - Speak English less than very well",
"Population 5 years and over - English only",
"Population 5 years and over - Language other than English",
"Population 5 years and over - Language other than English - Speak English less than very well",
"Population 5 years and over - Other Indo-European languages",
"Population 5 years and over - Other Indo-European languages - Speak English less than very well",
"Population 5 years and over - Other languages",
"Population 5 years and over - Other languages - Speak English less than very well",
"Population 5 years and over - Spanish",
"Population 5 years and over - Spanish - Speak English less than very well",
"Females 15 years and over",
"Females 15 years and over - Divorced",
"Females 15 years and over - Never married",
"Females 15 years and over - Now married, except separated",
"Females 15 years and over - Separated",
"Females 15 years and over - Widowed",
"Males 15 years and over",
"Males 15 years and over - Divorced",
"Males 15 years and over - Never married",
"Males 15 years and over - Now married, except separated",
"Males 15 years and over - Separated",
"Males 15 years and over - Widowed",
"Total population - Foreign born",
"Total population - Native",
"Total population - Native - Born in Puerto Rico or the United States",
"Total population - Native - Born in Puerto Rico or the United States - In Puerto Rico",
"Total population - Native - Born in Puerto Rico or the United States - In the United States",
"Total population - Native - Born in Puerto Rico, U.S. Island areas, or born abroad to American parent(s)",
"Total population - Native - Born in U.S. Island Areas, or born abroad of American parents",
"Total population - Native - Born in United States",
"Total population - Native - Born in United States - Different state",
"Total population - Native - Born in United States - State of residence",
"Total population (Place of birth)",
"Population in households",
"Population in households - Child",
"Population in households - Householder",
"Population in households - Nonrelatives",
"Population in households - Nonrelatives - Unmarried partner",
"Population in households - Other relatives",
"Population in households - Spouse",
"Population 1 year and over",
"Population 1 year and over - Abroad",
"Population 1 year and over - Different house in Puerto Rico or the U.S.",
"Population 1 year and over - Different house in Puerto Rico or the U.S. - In Puerto Rico",
"Population 1 year and over - Different house in Puerto Rico or the U.S. - In Puerto Rico - Different municipio",
"Population 1 year and over - Different house in Puerto Rico or the U.S. - In Puerto Rico - Same municipio",
"Population 1 year and over - Different house in Puerto Rico or the U.S. - In the United States",
"Population 1 year and over - Different house in the U.S.",
"Population 1 year and over - Different house in the U.S. - Different county",
"Population 1 year and over - Different house in the U.S. - Different county - Different state",
"Population 1 year and over - Different house in the U.S. - Different county - Same state",
"Population 1 year and over - Different house in the U.S. - Same county",
"Population 1 year and over - Elsewhere",
"Population 1 year and over - Same house",
"Population 3 years and over enrolled in school",
"Population 3 years and over enrolled in school - College or graduate school",
"Population 3 years and over enrolled in school - Elementary school (grades 1-8)",
"Population 3 years and over enrolled in school - High school (grades 9-12)",
"Population 3 years and over enrolled in school - Kindergarten",
"Population 3 years and over enrolled in school - Nursery school, preschool",
"Foreign-born population",
"Foreign-born population - Naturalized U.S. citizen",
"Foreign-born population - Not a U.S. citizen",
"Civilian population 18 years and over",
"Civilian population 18 years and over - Civilian veterans",
"Foreign-born population, excluding population born at sea",
"Foreign-born population, excluding population born at sea - Africa",
"Foreign-born population, excluding population born at sea - Asia",
"Foreign-born population, excluding population born at sea - Europe",
"Foreign-born population, excluding population born at sea - Latin America",
"Foreign-born population, excluding population born at sea - Northern America",
"Foreign-born population, excluding population born at sea - Oceania",
"Population born outside Puerto Rico",
"Population born outside Puerto Rico - Foreign born",
"Population born outside Puerto Rico - Foreign born - Entered 2010 or later",
"Population born outside Puerto Rico - Foreign born - Entered before 2010",
"Population born outside Puerto Rico - Native",
"Population born outside Puerto Rico - Native - Entered 2010 or later",
"Population born outside Puerto Rico - Native - Entered before 2010",
"Population born outside the United States",
"Population born outside the United States - Foreign born",
"Population born outside the United States - Foreign born - Entered 2010 or later",
"Population born outside the United States - Foreign born - Entered before 2010",
"Population born outside the United States - Native",
"Population born outside the United States - Native - Entered 2010 or later",
"Population born outside the United States - Native - Entered before 2010";
SQL SELECT * FROM "51y2"
WHERE "8snx" = "2q.35.29.2p.47.m.30.25.24.n.2r.18.19.3v.l.4f.3n.1m.33.13.2o.4b.2n.27.3f.3m.k.51.i.2v.3g.4m.1d.3i.41.r.4r.4e.t.3z.2y.3j.2a.1e.1u.v.1i.1b.49.1q.3p.37.1t.46.39.40.4z.2z.3d.4x.1g.3k.1j.43.2g.22.4u.3l.23.s.1h.4c.2e.2x.j.2w.3q.4i.34.2h.x.45.2j.4h.3x.17.32.1l.1p.2f.1a.2s.4d.q.w.4v.15.48.3a.1w.21.20.1v.4y.4q.38.1o.1x.4l.50.52.1f.3h.3w.3r.2l.28.4k.2d.1c.4w.4a.11.3c.u.1z.12.2t.4j.1s.4p.14.1y.p.42.y.2c.3y.10.3b.1r.3e.26.z.31.2k.1n.o.2b.4g.h.4n.1k.3u.2i.3o.4o.36.2m.3s.4s.44.3t.4t";
store [US social characteristics (by state)] into [c:\US social characteristics (by state).qvd];
drop table [US social characteristics (by state)];
disconnect;
[Weather in 500 cities worldwide]:
SET ThousandSep=',';
SET DecimalSep='.';
LIB CONNECT TO 'DM (myuser)';
[Weather in 500 cities worldwide]:
LOAD "Country",
"City",
"Date",
"Average of the 24 hourly cloud cover observations as a percentage",
"Average of the 24 hourly dew point observations in degrees Celsius",
"Average of the 24 hourly dew point observations in degrees Fahrenheit",
"Average of the 24 hourly feels like temperature values in degrees Celsius",
"Average of the 24 hourly feels like temperature values in degrees Fahrenheit",
"Average of the 24 hourly relative humidity values as a percentage",
"Average of the 24 hourly station pressure observations in millibars",
"Average of the 24 hourly temperature observations in degrees Celsius",
"Average of the 24 hourly temperature observations in degrees Fahrenheit",
"Average of the 24 hourly wetbulb values in degrees Celsius",
"Average of the 24 hourly wetbulb values in degrees Fahrenheit",
"Average of the 24 hourly wind speed observations in km per hour",
"Average of the 24 hourly wind speed observations in miles per hour",
"Average of the daily minimum and maximum temperatures in Celsius",
"Average of the daily minimum and maximum temperatures in Fahrenheit",
"Cooling degree day value from daily average temperature in degrees Celsius",
"Cooling degree day value from daily average temperature in Fahrenheit",
"Daily total precipitation (rainfall and/or melted amount of snow) in cm",
"Daily total precipitation (rainfall and/or melted amount of snow) in inches",
"Daily total snowfall in cm",
"Daily total snowfall in inches",
"Heating degree day value from daily average temperature in degrees Celsius",
"Heating degree day value from daily average temperature in Fahrenheit",
"Maximum daily temperature in degrees Celsius",
"Maximum daily temperature in degrees Fahrenheit",
"Maximum of the 24 hourly cloud cover observations as a percentage",
"Maximum of the 24 hourly dew point observations in degrees Celsius",
"Maximum of the 24 hourly dew point observations in degrees Fahrenheit",
"Maximum of the 24 hourly feels like temperature values in degrees Celsius",
"Maximum of the 24 hourly feels like temperature values in degrees Fahrenheit",
"Maximum of the 24 hourly relative humidity values as a percentage",
"Maximum of the 24 hourly station pressure observations in millibars",
"Maximum of the 24 hourly wetbulb values in degrees Celsius",
"Maximum of the 24 hourly wetbulb values in degrees Fahrenheit",
"Maximum of the 24 hourly wind speed observations in km per hour",
"Maximum of the 24 hourly wind speed observations in miles per hour",
"Minimum daily temperature in degrees Celsius",
"Minimum daily temperature in degrees Fahrenheit",
"Minimum of the 24 hourly cloud cover observations as a percentage",
"Minimum of the 24 hourly dew point observations in degrees Celsius",
"Minimum of the 24 hourly dew point observations in degrees Fahrenheit",
"Minimum of the 24 hourly feels like temperature values in degrees Celsius",
"Minimum of the 24 hourly feels like temperature values in degrees Fahrenheit",
"Minimum of the 24 hourly relative humidity values as a percentage",
"Minimum of the 24 hourly station pressure observations in millibars",
"Minimum of the 24 hourly wetbulb values in degrees Celsius",
"Minimum of the 24 hourly wetbulb values in degrees Fahrenheit",
"Minimum of the 24 hourly wind speed observations in km per hour",
"Minimum of the 24 hourly wind speed observations in miles per hour";
SQL SELECT * FROM "52kp"
WHERE "8vpf" = "p.9.7.13.16.d.n.11.y.z.10.1b.l.12.14.18.17.g.t.b.5.s.8.i.k.q.m.o.6.a.f.c.j.h.w.1.1a.1c.3.r.u.15.1d.x.19.4.2.v.e";
store [Weather in 500 cities worldwide] into [C:\Weather in 500 cities worldwide.qvd];
drop table [Weather in 500 cities worldwide];
disconnect;
[Weather for more than 2500 cities worldwide]:
SET ThousandSep=',';
SET DecimalSep='.';
LIB CONNECT TO 'DM (myuser)';
[Weather for more than 2500 cities worldwide]:
LOAD "Country",
"Nearest city",
"Weather station",
"Date",
"Average of the 24 hourly cloud cover observations as a percentage",
"Average of the 24 hourly dew point observations in degrees Celsius",
"Average of the 24 hourly dew point observations in degrees Fahrenheit",
"Average of the 24 hourly feels like temperature values in degrees Celsius",
"Average of the 24 hourly feels like temperature values in degrees Fahrenheit",
"Average of the 24 hourly relative humidity values as a percentage",
"Average of the 24 hourly station pressure observations in millibars",
"Average of the 24 hourly temperature observations in degrees Celsius",
"Average of the 24 hourly temperature observations in degrees Fahrenheit",
"Average of the 24 hourly wetbulb values in degrees Celsius",
"Average of the 24 hourly wetbulb values in degrees Fahrenheit",
"Average of the 24 hourly wind speed observations in km per hour",
"Average of the 24 hourly wind speed observations in miles per hour",
"Average of the daily minimum and maximum temperatures in Celsius",
"Average of the daily minimum and maximum temperatures in Fahrenheit",
"Cooling degree day value from daily average temperature in degrees Celsius",
"Cooling degree day value from daily average temperature in Fahrenheit",
"Daily total precipitation (rainfall and/or melted amount of snow) in cm",
"Daily total precipitation (rainfall and/or melted amount of snow) in inches",
"Daily total snowfall in cm",
"Daily total snowfall in inches",
"Heating degree day value from daily average temperature in degrees Celsius",
"Heating degree day value from daily average temperature in Fahrenheit",
"Maximum daily temperature in degrees Celsius",
"Maximum daily temperature in degrees Fahrenheit",
"Maximum of the 24 hourly cloud cover observations as a percentage",
"Maximum of the 24 hourly dew point observations in degrees Celsius",
"Maximum of the 24 hourly dew point observations in degrees Fahrenheit",
"Maximum of the 24 hourly feels like temperature values in degrees Celsius",
"Maximum of the 24 hourly feels like temperature values in degrees Fahrenheit",
"Maximum of the 24 hourly relative humidity values as a percentage",
"Maximum of the 24 hourly station pressure observations in millibars",
"Maximum of the 24 hourly wetbulb values in degrees Celsius",
"Maximum of the 24 hourly wetbulb values in degrees Fahrenheit",
"Maximum of the 24 hourly wind speed observations in km per hour",
"Maximum of the 24 hourly wind speed observations in miles per hour",
"Minimum daily temperature in degrees Celsius",
"Minimum daily temperature in degrees Fahrenheit",
"Minimum of the 24 hourly cloud cover observations as a percentage",
"Minimum of the 24 hourly dew point observations in degrees Celsius",
"Minimum of the 24 hourly dew point observations in degrees Fahrenheit",
"Minimum of the 24 hourly feels like temperature values in degrees Celsius",
"Minimum of the 24 hourly feels like temperature values in degrees Fahrenheit",
"Minimum of the 24 hourly relative humidity values as a percentage",
"Minimum of the 24 hourly station pressure observations in millibars",
"Minimum of the 24 hourly wetbulb values in degrees Celsius",
"Minimum of the 24 hourly wetbulb values in degrees Fahrenheit",
"Minimum of the 24 hourly wind speed observations in km per hour",
"Minimum of the 24 hourly wind speed observations in miles per hour";
SQL SELECT * FROM "535q"
WHERE "8wnl" = "p.9.7.13.16.d.n.11.y.z.10.1b.l.12.14.18.17.g.t.b.5.s.8.i.k.q.m.o.6.a.f.c.j.h.w.1.1a.1c.3.r.u.15.1d.x.19.4.2.v.e";
store [Weather for more than 2500 cities worldwide] into [c:\Weather for more than 2500 cities worldwide.qvd];
drop table [Weather for more than 2500 cities worldwide];
disconnect;
[162x162 currency exchange rates]:
SET ThousandSep=',';
SET DecimalSep='.';
LIB CONNECT TO 'DM (myuser)';
[162x162 currency exchange rates]:
LOAD "Base currency",
"Quote currency",
"DateTime",
"Exchange rate";
SQL SELECT * FROM "52nr";
store [162x162 currency exchange rates] into [c:\162x162 currency exchange rates.qvd];
drop table [162x162 currency exchange rates];
disconnect;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment