2010年5月24日

Dialogデータベース探訪 -TableBase-

今日から始まりました新企画「Dialogデータベース探訪」です。
日本で、普段はあまり日の目を見ない ちょっとかわいそうなデータベースを
思いっきり、がんばって紹介します!

記念する第1回は、「TableBase(ファイル93)」です。

TableBase を一言で言えば「各種統計データの表がある」ということにつきます。

結構マイナーな統計情報(マイナー過ぎる時もありますが...)もあるので、
一度は試してみる価値はあると思います!


タイトルの出力(形式6)は無料なので、検索したら、取り敢えず「形式6」で
出力してみてください。
きっと、そこには、きらりと光る何かが見つかるはず...です!

では、検索例をご覧ください。
-------------------------------------------------------------------------------------
? B 93 <---TableBaseに接続します

File 93:TableBase(R) Sep 1997-2010/Apr W4
(c) 2010 Gale/Cengage

Set Items Description
--- ----- -----------
? S (PHARMA? OR MEDIC?)/TI <---タイトルに限定して検索します
1912 PHARMA?/TI
1312 MEDIC?/TI
S1 3129 (PHARMA? OR MEDIC?)/TI

? S S1 AND PY=2009:2010 <---発行年で限定できます
3129 S1
4747 PY=2009 : PY=2010
S2 134 S1 AND PY=2009:2010

? T S2/6/1-20 <---タイトル一覧(形式6)は無料です

2/6/1
DIALOG(R)File 93: TableBase(R) Sep
(c) 2010 Gale/Cengage. All rights reserved.
01539383 SUPPLIER NUMBER: 226101487
United States pharmaceutical direct-to-consumer advertising expenditures by
advertising medium in dollars and percent change for 2009
SOURCE: The Nielsen Company
PUB. DATE: April 2010


2/6/2
DIALOG(R)File 93: TableBase(R) Sep
(c) 2010 Gale/Cengage. All rights reserved.
01539381 SUPPLIER NUMBER: 226101471
United States top 20 pharmaceutical companies by direct-to-consumer advertising
expenditures in dollars and percent change for 2009
SOURCE: The Nielsen Company
PUB. DATE: April 2010


2/6/3
DIALOG(R)File 93: TableBase(R) Sep
(c) 2010 Gale/Cengage. All rights reserved.
01539380 SUPPLIER NUMBER: 226101207
United States annual pharmaceuticals direct-to-consumer advertising expenditures
in dollars for 2005 to 2009
SOURCE: The Nielsen Company
PUB. DATE: April 2010


2/6/4
DIALOG(R)File 93: TableBase(R) Sep
(c) 2010 Gale/Cengage. All rights reserved.
01539222 SUPPLIER NUMBER: 224891133
United States pharmaceutical and medical trade shows by month in number of net
square feet, exhibiting firms, and professional attendance for 2009
SOURCE: Tradeshow Week
PUB. DATE: March 29, 2010


2/6/5
DIALOG(R)File 93: TableBase(R) Sep
(c) 2010 Gale/Cengage. All rights reserved.
01538918 SUPPLIER NUMBER: 223721805
United Kingdom gastrointestinal medicines markets in pounds sterling and percent
change for 2008 to 2009
SOURCE: IRI
PUB. DATE: April 03, 2010


2/6/6
DIALOG(R)File 93: TableBase(R) Sep
(c) 2010 Gale/Cengage. All rights reserved.
01538885 SUPPLIER NUMBER: 223397602
United States cold and cough medication retail sales by product category in
units, and percent change for 2009
SOURCE: Information Resources Inc.
PUB. DATE: March 2010


2/6/7
DIALOG(R)File 93: TableBase(R) Sep
(c) 2010 Gale/Cengage. All rights reserved.
01538884 SUPPLIER NUMBER: 223397560
United States cold and cough medication retail sales, sales share, and sales
change by category broken down for total sales and private-label sales in
dollars, and percentages for 2009
SOURCE: Information Resources Inc.
PUB. DATE: March 2010


2/6/8
DIALOG(R)File 93: TableBase(R) Sep
(c) 2010 Gale/Cengage. All rights reserved.
01538846 SUPPLIER NUMBER: 223201458
United States direct and indirect costs for top five most expensive medical
diagnostic categories forecast in dollars for 2010
SOURCE: National Heart, Lung and Blood Institute
PUB. DATE: February 19, 2010


2/6/9
DIALOG(R)File 93: TableBase(R) Sep
(c) 2010 Gale/Cengage. All rights reserved.
01538807 SUPPLIER NUMBER: 223202972
United States average yearly sales per pharmacy location in dollars for 2003 to
2007
SOURCE: National Community Pharmacists Association
PUB. DATE: March 15, 2010


2/6/10
DIALOG(R)File 93: TableBase(R) Sep
(c) 2010 Gale/Cengage. All rights reserved.
01538794 SUPPLIER NUMBER: 223212240
Global generic and nongeneric oral pharmaceutical sales in dollars for 2005 to
2009
SOURCE: IMS Health; MIDAS
PUB. DATE: February 15, 2010


2/6/11
DIALOG(R)File 93: TableBase(R) Sep
(c) 2010 Gale/Cengage. All rights reserved.
01538671 SUPPLIER NUMBER: 221865299
United States top 10 ear medications by drugstore sales in units and percent
change for 2009
SOURCE: Information Resources Inc.
PUB. DATE: March 01, 2010


2/6/12
DIALOG(R)File 93: TableBase(R) Sep
(c) 2010 Gale/Cengage. All rights reserved.
01538670 SUPPLIER NUMBER: 221865085
United States top 10 ear medications by drugstore sales, sales share, and sales
change in dollars and percentages for 2009
SOURCE: Information Resources Inc.
PUB. DATE: March 01, 2010


2/6/13
DIALOG(R)File 93: TableBase(R) Sep
(c) 2010 Gale/Cengage. All rights reserved.
01538663 SUPPLIER NUMBER: 221864065
United States cold and cough medication sales in drugstores by product category
in dollars, units, and percent change for the year ended January 24, 2010
SOURCE: Information Resources Inc.
PUB. DATE: March 01, 2010


2/6/14
DIALOG(R)File 93: TableBase(R) Sep
(c) 2010 Gale/Cengage. All rights reserved.
01538523 SUPPLIER NUMBER: 220785493
United States top 15 pharmaceutical companies by sales in dollars for 2008, and
data for 2007
SOURCE: IMS Health
PUB. DATE: March 01, 2010


2/6/15
DIALOG(R)File 93: TableBase(R) Sep
(c) 2010 Gale/Cengage. All rights reserved.
01538519 SUPPLIER NUMBER: 220785542
United States top 10 cold, allergy, and sinus medications in liquid or powder
form by retail sales in dollars, and percent change for the year ended January
24, 2010
SOURCE: Information Resources Inc.
PUB. DATE: March 01, 2010


2/6/16
DIALOG(R)File 93: TableBase(R) Sep
(c) 2010 Gale/Cengage. All rights reserved.
01538475 SUPPLIER NUMBER: 220160009
United States share of prescription medication purchases by continued-treatment
purchases, new-treatment purchases, changed-treatment purchases, and
additional-treatment purchases in percentages as reported July 2009
SOURCE: IMS Brand Excellence Study
PUB. DATE: July 2009


2/6/17
DIALOG(R)File 93: TableBase(R) Sep
(c) 2010 Gale/Cengage. All rights reserved.
01538468 SUPPLIER NUMBER: 220156878
United States top 10 pharmaceutical companies by prescription drugs volume
sales, sales share, and sales change in units and percentages for the year
ended June 2009
SOURCE: IMS Health
PUB. DATE: January 11, 2010


2/6/18
DIALOG(R)File 93: TableBase(R) Sep
(c) 2010 Gale/Cengage. All rights reserved.
01538467 SUPPLIER NUMBER: 220156877
United States top 10 pharmaceutical companies by sales, sales share, and sales
change in dollars and percentages for the year ended June 2009
SOURCE: IMS Health
PUB. DATE: January 11, 2010


2/6/19
DIALOG(R)File 93: TableBase(R) Sep
(c) 2010 Gale/Cengage. All rights reserved.
01538374 SUPPLIER NUMBER: 219687572
United States top 10 generic pharmaceutical companies by sales volume, volume
change, and volume share in units, and percentages for 2009
SOURCE: IMS Health
PUB. DATE: February 15, 2010


2/6/20
DIALOG(R)File 93: TableBase(R) Sep
(c) 2010 Gale/Cengage. All rights reserved.
01538373 SUPPLIER NUMBER: 219687393
United States top 10 generic pharmaceutical companies by sales, sales change,
and sales share in dollars, and percentages for 2009
SOURCE: IMS Health
PUB. DATE: February 15, 2010


★興味があるタイトルにめぐり合ったら、フルレコード(形式9)で出力してください
-------------------------------------------------------------------------------------
今回の例は、医薬品関係でやってみました。
医薬品メーカーの皆様、いかがでしたでしょうか? 何か面白そうなタイトル見つかりましたでしょうか?

「TableBase」は、統計情報の宝の山です。
そこから、お宝を見つけるのはあなた次第です!