QCEW Examples

desc.txt

#  java -jar qcew.jar desc ENU0603700562441_77Y
{:id "ENU0603700562441_77Y",
 :size "0: All establishment sizes",
 :owner "5: Private",
 :ind "62441: NAICS 62441 Child day care services",
 :agg "77: County, NAICS 5-digit -- by ownership sector",
 :area "06037: Los Angeles County, California",
 :span "Year"}

find.txt

# java -jar qcew.jar find ind 62441 agg 77
ENU2205700562441_77Y
ENU2203500562441_77M
ENU2118700362441_77M
ENU3005300562441_77Y
ENU2915100562441_77Y
ENU2916100562441_77Y
ENU2206900562441_77Y
ENU3106100362441_77M
ENU2916500362441_77M
ENU3107100562441_77Y

r-x12.r

install.packages("x12")
library(x12)
data(AirPassengers)
x12out <- x12(AirPassengers,x12path="/opt/qcew/x13as/x12a",transform="auto",
    arima=c(0,1,1),sarima=c(0,1,1),regvariables="lpyear",
    sigmalim=c(2.0,3.0),outlier="all",critical=list(LS=3.5,TC=3),
    seasonalma="s3x3")
summary(x12out)
x12out$d11

install.packages("rjson")
library(rjson)
toJSON(x12out)

random.txt

# java -jar qcew.jar random
Getting some random IDs.
:ids 0 0
ENU0603700562441_77Y
:kyoto (:read :dirty)
:kc-open data/series1.kch#dfunit=8#apow=7#msiz=2147483648#bnum=33554432
period  status  estab   emp     wages   taxable contrib weekly  annual
1990    _       713     9582    107950102       0       0       217     11267
1991    _       950     9769    120011550       0       0       236     12285
1992    _       1027    10124   132254986       0       0       251     13063
1993    _       1080    10540   143663635       0       0       262     13631
1994    _       1112    11211   157817283       0       0       271     14076
1995    _       1211    11435   168804316       0       0       284     14762
1996    _       1246    11864   178636029       0       0       290     15057
1997    _       1221    11963   189007424       0       0       304     15799
1998    _       1344    12914   210260396       0       0       313     16281
1999    _       1417    13511   231010006       0       0       329     17097
2000    _       1378    13939   250542149       0       0       346     17974
2001    _       1431    14761   279407845       99784353        2835969 364     18929
2002    _       1574    16539   327076918       116713946       3245299 380     19776
2003    _       1660    16551   340056569       114447296       3583504 395     20547
2004    _       1620    16633   354627305       115585616       5177826 410     21321
2005    _       1611    16531   365426329       116537429       5276004 425     22105
2006    _       1639    16855   386281638       125050687       5546623 441     22918
2007    _       1593    16157   379431031       113881786       4741464 452     23484
2008    _       1566    16059   389600059       113631915       4608533 467     24261
2009    _       1556    15642   386044990       109023113       4508537 475     24680
2010    _       1586    15775   390062636       107388697       5000268 476     24726
2011    _       1547    15747   399176650       108093174       5780633 487     25350
:kc-close