Setting to select lowest (or lowest %) strength within a medication ingredient

[jrlegrand]

Proposal

If a developer wants to only show distributions for the lowest 50% of strengths for a population, maybe we could give them an option to specify that in the settings?

Could pull in the FDA product column called ACTIVE_NUMERATOR_STRENGTH, split it by a semicolon (;) and then work with the strengths in that column to get the lowest (or lowest %) strengths only - by medication ingredient.

This is just a thought in progress.

Rationale

I'm wondering if the feedback we will get from clinicians is that our starting dose for these patients is too high. This could be a way to mitigate that.

Example query:
select NONPROPRIETARYNAME, PROPRIETARYNAME, ACTIVE_NUMERATOR_STRENGTH from product p where NONPROPRIETARYNAME like('%fluticasone%');

NONPROPRIETARYNAME	PROPRIETARYNAME	ACTIVE_NUMERATOR_STRENGTH
Azelastine Hydrochloride and Fluticasone Propionate	DYMISTA	137; 50
fluticasone propionate and salmeterol	fluticasone propionate and salmeterol	50; 100
fluticasone propionate and salmeterol	fluticasone propionate and salmeterol	50; 250
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate and Salmeterol	Fluticasone Propionate and Salmeterol	55; 14
Fluticasone Propionate and Salmeterol	Fluticasone Propionate and Salmeterol	113; 14
Fluticasone Propionate and Salmeterol	Fluticasone Propionate and Salmeterol	232; 14
Fluticasone propionate	Good Sense 24 hour allergy nasal	50
Fluticasone Propionate	Good Sense 24 hour allergy nasal	50
Fluticasone propionate	basic care allergy relief nasal	50
fluticasone propionate	FLONASE	50
fluticasone propionate	CHILDRENS FLONASE	50
fluticasone furoate	FLONASE SENSIMIST	27.5
fluticasone furoate	FLONASE SENSIMIST	27.5
fluticasone propionate	FLUTICASONE PROPIONATE	0.5
fluticasone propionate	Fluticasone Propionate	0.05
fluticasone propionate	FLUTICASONE PROPIONATE	0.5
fluticasone propionate	FLOVENT	50
fluticasone propionate	FLOVENT	250
fluticasone propionate	FLOVENT	100
fluticasone propionate and salmeterol	ADVAIR	50; 100
fluticasone propionate and salmeterol	ADVAIR	50; 250
fluticasone propionate and salmeterol	ADVAIR	50; 500
fluticasone propionate and salmeterol xinafoate	ADVAIR HFA	45; 21
fluticasone propionate and salmeterol xinafoate	ADVAIR HFA	115; 21
fluticasone propionate and salmeterol xinafoate	ADVAIR HFA	230; 21
fluticasone propionate	FLOVENT	44
fluticasone propionate	FLOVENT	110
fluticasone propionate	FLOVENT	220
fluticasone furoate and vilanterol trifenatate	Breo Ellipta	100; 25
fluticasone furoate	Arnuity Ellipta	100
fluticasone furoate	Arnuity Ellipta	200
fluticasone furoate and vilanterol trifenatate	Breo Ellipta	200; 25
fluticasone furoate, umeclidinium bromide and vilanterol trifenatate	Trelegy Ellipta	100; 62.5; 25
fluticasone furoate	Arnuity Ellipta	50
fluticasone furoate, umeclidinium bromide and vilanterol trifenatate	Trelegy Ellipta	200; 62.5; 25
Fluticasone propionate	24 Hour Allergy Nasal	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Allergy Nasal	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50
Azelastine Hydrochloride and Fluticasone Propionate	Azelastine Hydrochloride and Fluticasone Propionate	137; 50
fluticasone propionate and salmeterol	Wixela Inhub	100; 50
fluticasone propionate and salmeterol	Wixela Inhub	250; 50
fluticasone propionate and salmeterol	Wixela Inhub	500; 50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone propionate	RUGBY FLUTICASONE PROPIONATE NASAL	50
Fluticasone Propionate	Fluticasone Propionate	0.5
Fluticasone Propionate	Fluticasone Propionate	0.05
Fluticasone Propionate	Fluticasone Propionate	0.5
fluticasone propionate	Cutivate	0.5
Fluticasone propionate	Up and Up Allergy Relief Nasal	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Up and Up allergy relief nasal	50
Fluticasone propionate	allergy nasal	50
Fluticasone Propionate	childrens allergy nasal	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone propionate	Signature Care Allergy Relief	50
Fluticasone Propionate	signature care childrens allergy relief	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone propionate	24 Hour Allergy Relief nasal	50
Fluticasone propionate	allergy relief nasal	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	TopCare Childrens Allergy Relief Nasal 24 Hour	50
Fluticasone propionate	topcare fluticasone propionate nasal	50
Fluticasone Propionate	Allergy Relief	50
Fluticasone propionate	Nasopro 24	50
fluticasone propionate	Childrens Nasopro	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone propionate	Equaline Fluticasone Propionate	50
Fluticasone Propionate	Equaline fluticasone propionate	50
Fluticasone propionate	Allergy Relief	50
Fluticasone propionate	24 hour allergy relief nasal	50
Fluticasone Propionate	careone childrens allergy relief	50
Fluticasone propionate	CareOne Allergy Relief	50
fluticasone propionate	Beser	0.5
Fluticasone propionate	Beser
azelastine hydrochloride, fluticasone propionate	AZELASTINE HYDROCHLORIDE AND FLUTICASONE PROPIONATE	137; 50
Fluticasone Propionate	Fluticasone Propionate	0.05
Fluticasone Propionate	Fluticasone Propionate	0.5
fluticasone propionate	fluticasone propionate	0.5
Fluticasone propionate	Good Neighbor Pharmacy Fluticasone Propionate	50
Fluticasone Propionate	Good Neighbor Pharmacy Childrens Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone propionate	equate allergy relief	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone propionate	SunMark allergy relief nasal 24 hr	50
fluticasone propionate and salmeterol	ADVAIR	.05; .25
fluticasone propionate	FLOVENT	110
fluticasone propionate	FLOVENT	44
fluticasone propionate	FLOVENT	220
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	0.5
fluticasone propionate	FLOVENT	50
fluticasone propionate	FLONASE	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate and Salmeterol	Fluticasone Propionate and Salmeterol	232; 14
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	0.5
fluticasone propionate and salmeterol	Fluticasone Propionate and Salmeterol	100; 50
fluticasone propionate and salmeterol	Fluticasone Propionate and Salmeterol	250; 50
fluticasone propionate and salmeterol	Fluticasone Propionate and Salmeterol	500; 50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone propionate	Fluticasone propionate	50
Fluticasone propionate	sound body allergy relief	50
Fluticasone Propionate	Fluticasone Propionate	0.05
fluticasone propionate	FLOVENT	44
fluticasone propionate	FLOVENT	110
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Allergy Relief	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone propionate	exchange select allergy relief	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone propionate	family wellness allergy relief nasal	50
fluticasone propionate	FLUTICASONE	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	DG Health childrens allergy relief nasal	50
Fluticasone propionate	DG Health Allergy Relief Nasal	50
Fluticasone propionate	allergy relief nasal	50
fluticasone propionate (glucocorticoid)	FlutiCare	50
Fluticasone Propionate and Salmeterol	AirDuo Digihaler	14; 55
Fluticasone Propionate	ArmonAir Digihaler	55
Fluticasone Propionate and Salmeterol	AirDuo Digihaler	113; 14
Fluticasone Propionate and Salmeterol	AirDuo Digihaler	232; 14
Fluticasone Propionate	ArmonAir Digihaler	113
Fluticasone Propionate	ArmonAir Digihaler	232
fluticasone propionate	ArmonAir Digihaler	55
Fluticasone Propionate and Salmeterol	AirDuo Digihaler	55; 14
fluticasone propionate	ArmonAir Digihaler	113
Fluticasone Propionate and Salmeterol	AirDuo Digihaler	113; 14
fluticasone propionate	ArmonAir Digihaler	232
Fluticasone Propionate and Salmeterol	AirDuo Digihaler	232; 14
Fluticasone Propionate and Salmeterol	AirDuo RespiClick	55; 14
Fluticasone Propionate and Salmeterol	AirDuo RespiClick	113; 14
Fluticasone Propionate and Salmeterol	AirDuo RespiClick	232; 14
Fluticasone Propionate	Fluticasone Propionate	50
fluticasone propionate	FLUTICASONE	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50
Azelastine hydrochloride and Fluticasone propionate	Azelastine hydrochloride and Fluticasone propionate	137; 50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50
FLUTICASONE	FLUTICASONE	50
FLUTICASONE	FLUTICASONE	50
FLUTICASONE	FLUTICASONE	50
FLUTICASONE PROPIONATE	FLUTICASONE PROPIONATE	0.5
Fluticasone propionate	health mart allergy relief nasal 24 hr	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50
fluticasone propionate	FLOVENT	100
fluticasone propionate	FLUTICASONE PROPIONATE	0.5
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone propionate	Core Values Allergy Relief	50
Fluticasone propionate	Kirkland Signature Aller Flo	50
Fluticasone propionate	Welby Fluticasone	50
Fluticasone propionate	welby allergy relief	50
Fluticasone Propionate	Allergy Relief	50
fluticasone propionate and salmeterol	Fluticasone Propionate and Salmeterol	100; 50
fluticasone propionate and salmeterol	Fluticasone Propionate and Salmeterol	250; 50
fluticasone propionate and salmeterol	Fluticasone Propionate and Salmeterol	500; 50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone propionate	Berkley and Jensen Allergy Relief	50
Fluticasone Propionate	Fluticasone Propionate	0.5
fluticasone propionate	FLOVENT	44
Fluticasone Propionate	Fluticasone Propionate	50
fluticasone propionate	FLUTICASONE	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone propionate	Harris Teeter Allergy Relief Nasal	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	FLUTICASONE PROPIONATE	50
Fluticasone Propionate	Fluticasone Propionate	50
Fluticasone Propionate	Fluticasone Propionate	50