Prescription Monitoring Program: Opioid, Benzodiazepine, Stimulant, Naloxone, And Gabapentin Prescription Count & Rate By Patient Residence

State of Connecticut

@usgov.state_of_connecticut_opioid_benzodiazepine_stimulant_n_ff589d14

Table List

1 table(121.74 KB)

Table 1

@usgov.state_of_connecticut_opioid_benzodiazepine_stimulant_n_ff589d14.table_1

121.74 KB
2028 rows
16 columns

date Date	patient_residence Patient Residence	geolocation Geolocation	state State	naloxone_prescription_count Naloxone Prescription Count	naloxone_rate_per_1_000_residents Naloxone Rate Per 1,000 Residents	opiate_agonist_prescription_count Opiate Agonist Prescription Count	opiate_agonist_rate_per_1_000_residents Opiate Agonist Rate Per 1,000 Residents	opiate_partial_agonist_prescription_count Opiate Partial Agonist Prescription Count	opiate_partial_agonist_rate_per_1_000_residents Opiate Partial Agonist Rate Per 1,000 Residents	benzodiazepine_prescription_count Benzodiazepine Prescription Count	benzodiazepine_rate_per_1_000_residents Benzodiazepine Rate Per 1,000 Residents	stimulant_prescription_count Stimulant Prescription Count	stimulant_rate_per_1_000_residents Stimulant Rate Per 1,000 Residents	gabapentin_prescription_count Gabapentin Prescription Count	gabapentin_rate_per_1_000_residents Gabapentin Rate Per 1,000 Residents
2022 Quarter 4	Suffield	POINT (-72.65914 41.98373)	CT	7	0.44	1224	77.17	172	10.84	1181	74.45	1154	72.75	1154	72.75
2023 Quarter 2	Ellington	POINT (-72.46909 41.90438)	CT	14	0.84	1311	78.83	197	11.85	1500	90.2	1162	69.87	781	46.96
2022 Quarter 1	Killingworth	POINT (-72.56592 41.35961)	CT	4	0.65	590	95.58	137	22.19	698	113.07	581	94.12	306	49.57
2023 Quarter 4	Thomaston	POINT (-73.07407 41.67348)	CT	7	0.94	894	119.71	190	25.44	828	110.87	636	85.16	403	53.96
2024 Quarter 2	Union	POINT (-72.15536 41.99378)	CT			59	74.4			26	32.79	39	49.18	41	51.7
2023 Quarter 3	Canton	POINT (-72.89936 41.82742)	CT	12	1.19	760	75.31	93	9.22	870	86.22	876	86.81	465	46.08
2024 Quarter 2	Harwinton	POINT (-73.06991 41.76965)	CT	4	0.72	584	105	95	17.08	483	86.84	491	88.28	353	63.47
2024 Quarter 1	Washington	POINT (-73.31101 41.63097)	CT	2	0.55	310	84.56	9	2.45	255	69.56	275	75.01	123	33.55
2023 Quarter 1	Stafford	POINT (-72.28626 41.98679)	CT	8	0.7	1480	129.69	312	27.34	1180	103.4	878	76.94	740	64.84
2024 Quarter 4	Canaan	POINT (-73.301162 41.965661)	CT	1	0.92	101	93.35	8	7.39	93	85.95	76	70.24	69	63.77


CREATE TABLE table_1 (
  "date" VARCHAR,
  "patient_residence" VARCHAR,
  "geolocation" VARCHAR,
  "state" VARCHAR,
  "naloxone_prescription_count" DOUBLE,
  "naloxone_rate_per_1_000_residents" DOUBLE,
  "opiate_agonist_prescription_count" BIGINT,
  "opiate_agonist_rate_per_1_000_residents" DOUBLE,
  "opiate_partial_agonist_prescription_count" BIGINT,
  "opiate_partial_agonist_rate_per_1_000_residents" DOUBLE,
  "benzodiazepine_prescription_count" BIGINT,
  "benzodiazepine_rate_per_1_000_residents" DOUBLE,
  "stimulant_prescription_count" BIGINT,
  "stimulant_rate_per_1_000_residents" DOUBLE,
  "gabapentin_prescription_count" BIGINT,
  "gabapentin_rate_per_1_000_residents" DOUBLE
);