Displaying 2 results from an estimated 2 matches for "series_id".
2005 Sep 14
16
Showing database results in a grid view
...y to do what I want. Any advice on the best method would
be greatly appreciated.
Have the following database table:
CREATE TABLE datasets (
id int not null auto increment,
name varchar not null,
value varchar not null,
year varchar not null,
state varchar not null,
series_id int not null,
primary key (id)
);
In my view, I want to display the data from the datasets table as a grid
grouped by series_id. Each state should be on the x-axis (rows along
the left side) and each year should be on the y-axis (columns along the
top).
Any ideas?
Thanks.
2010 Mar 02
1
Reading data file with both fixed and tab-delimited fields
...lows.)
_*Details:*_
The U.S. Bureau of Labor Statistics provides local area unemployment
statistics at ftp://ftp.bls.gov/pub/time.series/la/, and the data are
documented in the file la.txt
<ftp://ftp.bls.gov/pub/time.series/la/la.txt>. Each data file has five
tab-delimited fields:
* series_id
* year
* period (codes for things like quarter or month of year)
* value
* footnote_codes
The series_id consists of five fixed-width subfields (length in
parentheses):
* survey abbreviation (2)
* seasonal code (1)
* area type code (2)
* area code (6)
* measure...