2010年5月25日

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

昨日の、紹介した「TableBase ですが、
「タイトル一覧だけじゃ、良さがわからん!」というご意見をいただきました。
全く、その通りでした... 反省してます。

ということで、今日は、フルレコードのサンプルをお見せいたしましょう!
ただ、レコードがボリュームがあるので、抜粋ということでご勘弁を...

昨日のタイトル一覧を見てみると... これなんかどうでしょう?
---------------------------------------------------------------------------------
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
---------------------------------------------------------------------------------

『米国の耳用薬トップ10の薬局での売上、シェア、売上変化』
「ちょっと、マイナーすぎるだろ」、という意見も聞こえてきそうですが、
これに決めさせていただきます!

検索例およびサンプルをご覧ください。
※いろいろな事情があり、統計数値データの一部は、伏字にしてあります...
---------------------------------------------------------------------------------
? B 93 <--TableBaseに接続

File 93:TableBase(R) Sep 1997-2010/May W1
(c) 2010 Gale/Cengage

Set Items Description
--- ----- -----------
? T 01538670/9 <--Dialogレコード番号を使って、直接出力(形式9)ができます

01538670/9
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

EAR DROPS/TREATMENTS
TOTAL DOLLAR SALES * $59.8 mil. (-12%)
DRUG STORES $44.6 mil. (-11.8%)
Dollar Dollar
Market sales sales
LEADING BRANDS ** share (000) % change
Debrox 21.3% $9,509 +24.4%
Similasan 12.7% 5,663 -6.2%
Murine X.X% X,XXX -XX.X%
Swim-Ear X.X% X,XXX -XX.X%
Murine Earigate X.X% X,XXX -XX.X%
Hyland's X.X% X,XXX +XX.X%
Ring Relief X.X% X,XXX +XX.X%
Auro-Dri X.X% X,XXX +XX.X%
EARinse X.X% X,XXX -XX.X%
Similasan Ear Wax Relief X.X% XXX -XX.X%
* Total of drug stores, supermarkets and discount stores
excluding Walmart.
** In drug stores only. private label products account for a
34.2% dollar share and a 40% unit share.
Source: Information Resources Inc.
For the 52 weeks ended December 27, 2009.


SOURCE: Information Resources Inc.

ORIGINATING ARTICLE:
There's more work to do in getting message across.
(HOMEPATHIC REMEDIES)

JOURNAL: Chain Drug Review, v 32, n 5, p 35
PUB. DATE: March 01, 2010
DOCUMENT TYPE: Journal; Ranking ISSN: 0164-9914 (United States)
LANGUAGE: English RECORD TYPE: Fulltext
WORD COUNT: 625
PUBLISHER: Racher Press Inc.

TEXT:
NEW YORK -- "Safety first" might best describe the rallying cry for
manufacturers of homeopathic medicines and for drug stores and other retailers
that sell such products.

Although suppliers of homeopathic items provide diverse offerings and employ
distinct marketing strategies, virtually all place a priority on stressing
product safety--particularly to the large number of consumers who have become
skittish over drug recalls by both prescription and over-the-counter drug
manufacturers and are seeking alternative remedies.

:
《途中省略》
:

"Because consumers and their doctors are looking for safer alternatives to O-T-C
oral pain medications as well as cold and flu products, homeopathic
medicines--recognized for their safety--are providing viable options for the
general population and especially for children," he says. "This can only be seen
as good news for drug store retailers."

EAR DROPS/TREATMENTS
TOTAL DOLLAR SALES * $59.8 mil. (-12%)
DRUG STORES $44.6 mil. (-11.8%)
Dollar Dollar
Market sales sales
LEADING BRANDS ** share (000) % change
Debrox 21.3% $9,509 +24.4%
Similasan 12.7% 5,663 -6.2%
Murine X.X% X,XXX -XX.X%
Swim-Ear X.X% X,XXX -XX.X%
Murine Earigate X.X% X,XXX -XX.X%
Hyland's X.X% X,XXX +XX.X%
Ring Relief X.X% X,XXX +XX.X%
Auro-Dri X.X% X,XXX +XX.X%
EARinse X.X% X,XXX -XX.X%
Similasan Ear Wax Relief X.X% XXX -XX.X%
TOTAL UNIT SALES * 8.5 mil. (-8.5%)
DRUG STORES 6.1 mil. (-8.2%)
Avg. price Unit sales Unit sales
LEADING BRANDS ** per unit (000) % change
Debrox $8.52 1,117 +18.3%
Similasan 10.02 565 -12.4%
Swim-Ear X.XX XXX -XX.X%
Murine X.XX XXX -XX.X%
Auro-Dri X.XX XXX -XX.X%
Hyland's X.XX XXX +XX.X%
EARinse X.XX XXX -XX.X%
Ring Relief XX.XX XXX XX.X%
Murine Earigate XX.XX XXX -XX.X%
Similasan Ear Wax Relief X.XX XX -XX.X%
* Total of drug stores, supermarkets and discount stores
excluding Walmart.
** In drug stores only. private label products account for a
34.2% dollar share and a 40% unit share.
Source: Information Resources Inc.
For the 52 weeks ended December 27, 2009.


COPYRIGHT: Copyright 2010 Racher Press Inc.
RELATED RECORDS: 6611200
INDUSTRY NAMES: Pharmaceutical
PRODUCT NAMES: Pharmaceutical preparations (283400); Pharmaceuticals NEC
(283490)
CONCEPT TERMS: Ranking; All market information; Market share; Sales
DATA TYPE: Business
BRAND NAMES: Auro-Dri (Medication); Debrox (Medication); EARinse
(Medication); Hyland's (Medication); Murine (Medication); Murine Earigate
(Medication); Ring Relief (Medication); Similasan (Medication); Similasan Ear
Wax Relief (Medication); Swim-Ear (Medication)
GEOGRAPHIC NAMES: North America (NOAX); United States (USA)
---------------------------------------------------------------------------------

いかがでしたでしょうか?
アメリカの耳用薬の売上データがバッチリわかりそうですね!

各種統計データをお探しの際には、「TableBase」を一度お試しください。