EMERGENCY ROOM DATABASE [454]

HOME : Support : Dialog Search Aids : Bluesheets	Add RSS \| What is RSS?
View Bluesheets by \| Database Name \| File Number \| Subject \| OneSearch Categories \| Search Options \|

	454
Emergency Room (ER) Database

Last Loaded on Web: Thursday, October 02, 2008

Last Update To Bluesheet: January 31, 2006

Bluesheet Contents PDF version

File Description	Print Counterparts	Geographic Coverage	Terms and Conditions	Limit	Rates
Subject Coverage	Dialog File Data	Special Features	Sample Record	Sort
Sources	Database Content	DIALINDEX/OneSearch Categories	Basic Index	Rank
Tips	Document Types Indexed	Contact	Additional Indexes	Predefined Format Options

File Description [top]

The Emergency Room (ER) database provides disease-specific emergency department data for more than 2,600 diseases. Patient utilization information can be accessed by keyword or International Classification of Diseases (ICD) code.

Emergency Room database updates annually with the latest data available from the National Hospital Ambulatory Medical Care Survey (NHAMCS). Statistics are generally from two years prior to the current year.

Tips [top]

USE FILE 454

to find diagnosis and epidemiology information for market research, product development, and strategic planning.

SEARCH /TI

to search for keywords in the Title, e.g.,

SELECT RESPIRATORY(3N)DISEASE?/TI

SEARCH /DE

to search controlled-vocabulary terms, e.g.,

SELECT DIABETES(W)MELLITUS/DE

Subject Coverage [top]

Each ICD code includes discharge data (number of primary and all listed discharges for a given year), patient characteristics/payment source (gender/age/race breakouts, expected source of payment, and HMO participation), visit characteristics (mode of arrival, day of visit, urgency to see patient, actual waiting time to see physician, level of pain, place of injury), type of provider seen (percentage of patients seeing registered nurses, staff physicians, etc.), medications provided (drug usage by order and volume), diagnostic/screening services provided (frequency and type of tests performed), procedures provided (frequency and type of procedures performed), and disposition (where patient went after ER release).

Sources [top]

Data included in the Emergency Room database is derived from the National Hospital Ambulatory Medical Care Survey (NHAMCS), a national probability survey conducted by the National Center for Health Statistics (NCHS). The NCHS is a part of the Centers for Disease Control and Prevention, U.S. Department of Health and Human Services.

Print Counterparts [top]

None

Dialog File Data [top]

Dates Covered:	Current
File Size:	2,348 records as of October 2002
Update Frequency:	Annual

Database Content [top]

Numeric Data

Document Types Indexed [top]

Reports
Government Documents
Journal Articles
Statistics
Research Projects

Geographic Coverage [top]

US Only

Geographic Restrictions [top]

None

Special Features [top]

ERA Available
Graduate Education Program
KWIC and HILIGHT Available

DialIndex/OneSearch Categories [top]

ACRONYM	CATEGORY NAME
BUSSTAT	Industry/Product Statistics
PHARMIND	Pharmaceutical Industry News

Contact [top]

The Emergency Room Database is published by Timely Data Resources. Questions concerning ER should be directed to:

Timely Data Resources, Inc.
Customer Service
107 Washburn Avenue
Capitola, CA 95010

Telephone:	+1 831-462-2510
Fax:	+1 831-462-2580
E-Mail:	support@tdrdata.com

Terms and Conditions [top]

Database copyrighted by Timely Data Resources. For Dialog's Redistribution and Archive policy, enter HELP ERA online.

Dialog Standard Terms & Conditions apply.

SAMPLE RECORD [top]

	`DIALOG(R)File 454:Emergency Room`
	`(c) 2003 Timely Data Resources. All rts. reserv.`

	`00002093`
/TI	`Acute tonsillitis`

IC=	`ICD-9 CODE: 463.`
/ID,ID=	`DESCRIPTION: Acute tonsillitis`

	`SOURCE: National Hospital Ambulatory Medical Care Survey (NHAMCS) 2000.`
PY=	`PUBLICATION YEAR: 2000`

/TX	`STATISTICAL INFORMATION:`
	`Emergency Room Database(1)`
	`Primary Discharges(2): 367,785`
	`All Listed Discharges(3): 506,292`
	`Note: Annual discharges fewer than 80,000`
	`have a relative standard error of +/-30%.`

	`Patient Characteristics/Payment Source(4)`
	`----------------------------------------------------------------`
	`Gender Breakout`
	`Female: 61.6%`
	`Male: 38.4%`

	`Race/Ethnicity Breakout`
	`White: 73.5%`
	`Black/African American: 23.6%`
	`Asian or Native Hawaiian: 2.8%`
	`American Indian: 0.2%`
	`Other: 0.0%`

	`(...)`
	`Visit Characteristics(4)`
	`----------------------------------------------------------------`
	`Mode of Arrival`
	`Ambulance: 0.0%`
	`Public Service: 1.2%`
	`(...)`

	`Type of Provider Seen(4)`
	`----------------------------------------------------------------`
	`Yes No`
	`Registered Nurse 89.4% 10.6%`
	`Licensed Practical Nurse 3.4% 96.6%`
	`Emergency Medical Technician 1.6% 98.4%`
	`(...)`

	`Medications Provided(4)`
	`----------------------------------------------------------------`
	`Medications Ordered Or Provided`
	`Yes: 87.9%`
	`No: 12.1%`
	`(...)`





	`Top Four Medications Prescribed(4)`
	`(Among Patients Receiving From One to Six Medications)`
	`----------------------------------------------------------------`
	`One Medication`
	`AMOXICILLIN: 9.7%`
	`TYLENOL: 8.3%`
	`(...)`


	`Disposition(4)`
	`----------------------------------------------------------------`
	`Yes No`
	`Follow-up Planned 6.2% 93.8%`
	`Returned to Emergency Department 36.2% 63.8%`
	`as Needed/Appointment Scheduled`
	`Returned to Referring Physician 13.5% 86.5%`
	`(...)`

/DE	`DESCRIPTORS:`
	`Acute tonsillitis.`

/TX	`NOTE - RELATED TOPICS:`
	`1 Source: National Hospital Ambulatory Medical Care Survey (NHAMCS)`
	`2000. 2 Number of patients discharged with this as the primary diagnosis. 3`
	`All patients discharged with this diagnosis (whether it was the primary or`
	`an ancillary diagnosis). 4 Based on primary diagnosis.`

BASIC INDEX [top]

SEARCH SUFFIX	DISPLAY CODE	FIELD NAME	INDEXING	SELECT EXAMPLES
None	None	All Basic Index Fields	Word	S PRIMARY(W)DISCHARGES
/DE	DE	Descriptor	Word & Phrase	S ACUTE(W)TONSILLITIS/DE S ACUTE TONSILLITIS/DE
/ID	ID	ICD Description¹	Word & Phrase	S ACUTE(W)TONSILLITIS/ID S ACUTE TONSILLITIS/ID
/TI	TI	Title	Word	S ACUTE(W)TONSILLITIS/TI
/TX	TX	Text²	Word	S TOP(1W)MEDICATION?/TX

¹Searchable in the Basic Index and in the Additional Indexes.

²TX displays Statistical Information (SI) and Notes (NT).

ADDITIONAL INDEXES [top]

SEARCH PREFIX	DISPLAY CODE	FIELD NAME	INDEXING	SELECT EXAMPLES
None	AN	DIALOG Accession Number
IC=	IC	ICD Code³	Phrase	S IC=463.
ID=	ID	ICD Description¹	Word & Phrase	S ID=(ACUTE(W)TONSILLITIS) S ID=ACUTE TONSILLITIS
LA=	LA	Language	Phrase	S LA=ENGLISH
None	NT	Notes - Related Topics
PY=	PY	Publication Year	Phrase	S PY=2000
RT=	RT	Record Type	Phrase	S RT=FULLTEXT
None	SI	Statistical Information
None	SO	Source Information
UD=	None	Update	Phrase	S UD=9999

³If you get multiple hits for one ICD code, all the records in the resulting set will have the same statistical information.

LIMIT [top]

SUFFIX	FIELD NAME	EXAMPLES
Sets and terms can be restricted by Basic Index suffixes, i.e., /DE, /ID, /TI, and /TX (e.g., S S2/DE), as well as by the following features:
/ENG	English	S S2/ENG
/NONENG	Non-English	S S1/NONENG
/STAT	Statistical Information	S S3/STAT

SORT [top]

SORTABLE FIELDS	EXAMPLES
IC, ID, PY, TI	SORT S1/ALL/PY,D PRINT S5/5/1-24/TI

RANK [top]

RANK FIELDS	EXAMPLES
All phrase- and numeric-indexed fields in the Additional Indexes can be ranked. Other RANK codes include: DE, ID	RANK DE RANK ID S4

USER-DEFINED FORMAT OPTIONS [top]


Display codes listed in the Search Options tables can be used to customize output.	TYPE S3/ID,TI/1-5 PRINT S2/TI,TX/ALL

PREDEFINED FORMAT OPTIONS [top]

NO.	DIALOGWEB FORMAT	RECORD CONTENT
1	--	DIALOG Accession Number
2	--	Title, ICD Code & Description, Source, Publication Year, and Indexing
3	Medium	Title, ICD Code & Description, Source, and Publication Year
4	--	Full Record with Tagged Fields
5	--	Full Record except Statistics
6	Short	Title, ICD Code & Description
7	Long	Full Record except Indexing
8	Free	Title, Indexing, ICD Code and Description, and Publication Year
9	Full	Full Record
K	--	KWIC (Key Word In Context) displays a window of text; may be used alone or with other formats

DIRECT RECORD ACCESS [top]

FIELD NAME	EXAMPLES
If the accession number of a specific record is known, it can be used to display the record directly.	TYPE 00100005/5 DISPLAY 0074483/TI PRINT 50301964/9

Rates [top]

Rates For File: Emergency Room (ER) Database[454]
Cost per DialUnit:                $12.53
Cost per minute:                   $2.52
Rank Elements                      $0.00

Format    Types   Prints
     1    $0.00    $0.00
     2    $1.62    $1.62
     3    $1.62    $1.62
     4   $32.40   $32.40
     5    $3.24    $3.24
     6    $0.00    $0.00
     7   $32.40   $32.40
     8    $0.00    $0.00
     9   $32.40   $32.40
KWIC95    $1.62       NA
KWIC96    $1.62       NA

REDIST/COPY Multiplier Table:

      Range      Multiplier
        1-2       1.00
       3-25       1.50
     26-100       3.00
    101-200       4.00
    201-500       6.00
   501-1000       8.00
 1001 or more    10.00

ARCHIVE Multiplier Table:

      Range      Multiplier
       1-25       1.50
     26-200       3.00
    201-500       6.00
   501-1000       8.00
 1001 or more    10.00

[top]