Jump to content

User:Timeshifter/Sandbox141

From Wikipedia, the free encyclopedia

Rates

[edit]

Return to top.

There is an easy way to convert the first table below to the format of the partial table below it. The lower table with the years in the top row is an older version that needed to be updated with later years, and with the corrected data for older years. See the updated version of the table here:

Rates are per 100,000 population.

YEAR STATE RATE
2019 AL 16.3
2019 AK 17.8
2019 AZ 26.8
2019 AR 13.5
2019 CA 15
2019 CO 18
2019 CT 34.7
2019 DE 48
2019 FL 25.5
2019 GA 13.1
2019 HI 15.9
2019 ID 15.1
2019 IL 21.9
2019 IN 26.6
2019 IA 11.5
2019 KS 14.3
2019 KY 32.5
2019 LA 28.3
2019 ME 29.9
2019 MD 38.2
2019 MA 32.1
2019 MI 24.4
2019 MN 14.2
2019 MS 13.6
2019 MO 26.9
2019 MT 14.1
2019 NE 8.7
2019 NV 20.1
2019 NH 32
2019 NJ 31.7
2019 NM 30.2
2019 NY 18.2
2019 NC 22.3
2019 ND 11.4
2019 OH 38.3
2019 OK 16.7
2019 OR 14
2019 PA 35.6
2019 RI 29.5
2019 SC 22.7
2019 SD 10.5
2019 TN 31.2
2019 TX 10.8
2019 UT 18.9
2019 VT 23.8
2019 VA 18.3
2019 WA 15.8
2019 WV 52.8
2019 WI 21.1
2019 WY 14.1
2018 AL 16.6
2018 AK 14.6
2018 AZ 23.8
2018 AR 15.7
2018 CA 12.8
2018 CO 16.8
2018 CT 30.7
2018 DE 43.8
2018 FL 22.8
2018 GA 13.2
2018 HI 14.3
2018 ID 14.6
2018 IL 21.3
2018 IN 25.6
2018 IA 9.6
2018 KS 12.4
2018 KY 30.9
2018 LA 25.4
2018 ME 27.9
2018 MD 37.2
2018 MA 32.8
2018 MI 26.6
2018 MN 11.5
2018 MS 10.8
2018 MO 27.5
2018 MT 12.2
2018 NE 7.4
2018 NV 21.2
2018 NH 35.8
2018 NJ 33.1
2018 NM 26.7
2018 NY 18.4
2018 NC 22.4
2018 ND 10.2
2018 OH 35.9
2018 OK 18.4
2018 OR 12.6
2018 PA 36.1
2018 RI 30.1
2018 SC 22.6
2018 SD 6.9
2018 TN 27.5
2018 TX 10.4
2018 UT 21.2
2018 VT 26.6
2018 VA 17.1
2018 WA 14.8
2018 WV 51.5
2018 WI 19.2
2018 WY 11.1
2017 AL 18
2017 AK 20.2
2017 AZ 22.2
2017 AR 15.5
2017 CA 11.7
2017 CO 17.6
2017 CT 30.9
2017 DE 37
2017 FL 25.1
2017 GA 14.7
2017 HI 13.8
2017 ID 14.4
2017 IL 21.6
2017 IN 29.4
2017 IA 11.5
2017 KS 11.8
2017 KY 37.2
2017 LA 24.5
2017 ME 34.4
2017 MD 36.3
2017 MA 31.8
2017 MI 27.8
2017 MN 13.3
2017 MS 12.2
2017 MO 23.4
2017 MT 11.7
2017 NE 8.1
2017 NV 21.6
2017 NH 37
2017 NJ 30
2017 NM 24.8
2017 NY 19.4
2017 NC 24.1
2017 ND 9.2
2017 OH 46.3
2017 OK 20.1
2017 OR 12.4
2017 PA 44.3
2017 RI 31
2017 SC 20.5
2017 SD 8.5
2017 TN 26.6
2017 TX 10.5
2017 UT 22.3
2017 VT 23.2
2017 VA 17.9
2017 WA 15.2
2017 WV 57.8
2017 WI 21.2
2017 WY 12.2
2016 AL 16.2
2016 AK 16.8
2016 AZ 20.3
2016 AR 14
2016 CA 11.2
2016 CO 16.6
2016 CT 27.4
2016 DE 30.8
2016 FL 23.7
2016 GA 13.3
2016 HI 12.8
2016 ID 15.2
2016 IL 18.9
2016 IN 24
2016 IA 10.6
2016 KS 11.1
2016 KY 33.5
2016 LA 21.8
2016 ME 28.7
2016 MD 33.2
2016 MA 33
2016 MI 24.4
2016 MN 12.5
2016 MS 12.1
2016 MO 23.6
2016 MT 11.7
2016 NE 6.4
2016 NV 21.7
2016 NH 39
2016 NJ 23.2
2016 NM 25.2
2016 NY 18
2016 NC 19.7
2016 ND 10.6
2016 OH 39.1
2016 OK 21.5
2016 OR 11.9
2016 PA 37.9
2016 RI 30.8
2016 SC 18.1
2016 SD 8.4
2016 TN 24.5
2016 TX 10.1
2016 UT 22.4
2016 VT 22.2
2016 VA 16.7
2016 WA 14.5
2016 WV 52
2016 WI 19.3
2016 WY 17.6
2015 AL 15.7
2015 AK 16
2015 AZ 19
2015 AR 13.8
2015 CA 11.3
2015 CO 15.4
2015 CT 22.1
2015 DE 22
2015 FL 16.2
2015 GA 12.7
2015 HI 11.3
2015 ID 14.2
2015 IL 14.1
2015 IN 19.5
2015 IA 10.3
2015 KS 11.8
2015 KY 29.9
2015 LA 19
2015 ME 21.2
2015 MD 20.9
2015 MA 25.7
2015 MI 20.4
2015 MN 10.6
2015 MS 12.3
2015 MO 17.9
2015 MT 13.8
2015 NE 6.9
2015 NV 20.4
2015 NH 34.3
2015 NJ 16.3
2015 NM 25.3
2015 NY 13.6
2015 NC 15.8
2015 ND 8.6
2015 OH 29.9
2015 OK 19
2015 OR 12
2015 PA 26.3
2015 RI 28.2
2015 SC 15.7
2015 SD 8.4
2015 TN 22.2
2015 TX 9.4
2015 UT 23.4
2015 VT 16.7
2015 VA 12.4
2015 WA 14.7
2015 WV 41.5
2015 WI 15.5
2015 WY 16.4
2014 AL 15.2
2014 AK 16.8
2014 AZ 12.6
2014 AR 18.2
2014 CA 11.1
2014 CO 16.3
2014 CT 17.6
2014 DE 20.9
2014 FL 13.2
2014 GA 11.9
2014 HI 10.9
2014 ID 13.7
2014 IL 13.1
2014 IN 18.2
2014 IA 8.8
2014 KS 11.7
2014 KY 24.7
2014 LA 16.9
2014 ME 16.8
2014 MD 17.4
2014 MA 19
2014 MI 18
2014 MN 9.6
2014 MS 11.6
2014 MO 18.2
2014 MT 12.4
2014 NE 7.2
2014 NV 18.4
2014 NH 26.2
2014 NJ 14
2014 NM 27.3
2014 NY 11.3
2014 NC 13.8
2014 ND 6.3
2014 OH 24.6
2014 OK 20.3
2014 OR 12.8
2014 PA 21.9
2014 RI 23.4
2014 SC 14.4
2014 SD 7.8
2014 TN 19.5
2014 TX 9.7
2014 UT 22.4
2014 VT 13.9
2014 VA 11.7
2014 WA 13.3
2014 WV 35.5
2014 WI 15.1
2014 WY 19.4
2005 AL 6.3
2005 AK 11.4
2005 AZ 14.1
2005 AR 10.1
2005 CA 9
2005 CO 12.7
2005 CT 8.5
2005 DE 7.5
2005 FL 13.5
2005 GA 8.2
2005 HI 9.4
2005 ID 8.1
2005 IL 8.4
2005 IN 9.8
2005 IA 4.8
2005 KS 9.1
2005 KY 15.3
2005 LA 14.7
2005 ME 12.4
2005 MD 11.4
2005 MA 12
2005 MI 9.8
2005 MN 5.4
2005 MS 8.8
2005 MO 10.7
2005 MT 10.1
2005 NE 5
2005 NV 18.7
2005 NH 10.7
2005 NJ 9.4
2005 NM 20.1
2005 NY 4.8
2005 NC 11.4
2005 ND 0
2005 OH 10.9
2005 OK 13.8
2005 OR 10.4
2005 PA 13.2
2005 RI 14.3
2005 SC 9.9
2005 SD 5.5
2005 TN 14.5
2005 TX 8.5
2005 UT 19.3
2005 VT 8.5
2005 VA 7.5
2005 WA 13
2005 WV 10.5
2005 WI 9.3
2005 WY 4.9
1999 AL 3.9
1999 AK 7.5
1999 AZ 10.6
1999 AR 4.4
1999 CA 8.1
1999 CO 8
1999 CT 9
1999 DE 6.4
1999 FL 6.4
1999 GA 3.5
1999 HI 6.5
1999 ID 5.3
1999 IL 6.7
1999 IN 3.2
1999 IA 1.9
1999 KS 3.4
1999 KY 4.9
1999 LA 4.3
1999 ME 5.3
1999 MD 11.4
1999 MA 7.5
1999 MI 4.6
1999 MN 2.8
1999 MS 3.2
1999 MO 5
1999 MT 4.6
1999 NE 2.3
1999 NV 11.5
1999 NH 4.3
1999 NJ 6.5
1999 NM 15
1999 NY 5
1999 NC 4.6
1999 ND 0
1999 OH 4.2
1999 OK 5.4
1999 OR 6.1
1999 PA 8.1
1999 RI 5.5
1999 SC 3.7
1999 SD 0
1999 TN 6.1
1999 TX 5.4
1999 UT 10.6
1999 VT 4.7
1999 VA 5
1999 WA 9.3
1999 WV 4.1
1999 WI 4
1999 WY 4.1


State 1999 2005 2014 2015 2016 2017
 Alabama 3.9 6.3 15.2 15.7 16.2 18
 Alaska 7.5 11.4 16.8 16 16.8 20.2
 Arizona 10.6 14.1 12.6 19 20.3 22.2

Pivot table (from LibreOffice Calc) copied into Visual Editor

[edit]

Conversion can be done quickly in freeware LibreOffice Calc. Use "Pivot Table" command in Calc. Here is a Google search:

One page it pulls up is this one:

Copy the above table to Calc. Or import the CSV file (or other file format) for the table. Select a data cell. Then click on the "Pivot Table" command from the Insert menu. Click OK in the popup box. In the next dialog box drag "Year" to the "Column Fields" box, and drag "State" to the "Row Fields" box. Drag "Rate" to the "Data Fields" box. Click OK. The table will convert to the new format with the years as column headers.

Copy the new table directly from the LibreOffice Calc page into visual editor. Then delete the summation column and row.

See: List of U.S. state and territory abbreviations. The 2-letter state abbreviations in the Calc table copied below are not in the same alphabetical order as the full state names. In the table that follows it below use Visual Editor to move rows where they need to be. Then copy the data columns from the table below into the table in the Wikipedia article.

STATE 1999 2005 2014 2015 2016 2017 2018 2019
AK 7.5 11.4 16.8 16 16.8 20.2 14.6 17.8
AL 3.9 6.3 15.2 15.7 16.2 18 16.6 16.3
AR 4.4 10.1 18.2 13.8 14 15.5 15.7 13.5
AZ 10.6 14.1 12.6 19 20.3 22.2 23.8 26.8
CA 8.1 9 11.1 11.3 11.2 11.7 12.8 15
CO 8 12.7 16.3 15.4 16.6 17.6 16.8 18
CT 9 8.5 17.6 22.1 27.4 30.9 30.7 34.7
DE 6.4 7.5 20.9 22 30.8 37 43.8 48
FL 6.4 13.5 13.2 16.2 23.7 25.1 22.8 25.5
GA 3.5 8.2 11.9 12.7 13.3 14.7 13.2 13.1
HI 6.5 9.4 10.9 11.3 12.8 13.8 14.3 15.9
IA 1.9 4.8 8.8 10.3 10.6 11.5 9.6 11.5
ID 5.3 8.1 13.7 14.2 15.2 14.4 14.6 15.1
IL 6.7 8.4 13.1 14.1 18.9 21.6 21.3 21.9
IN 3.2 9.8 18.2 19.5 24 29.4 25.6 26.6
KS 3.4 9.1 11.7 11.8 11.1 11.8 12.4 14.3
KY 4.9 15.3 24.7 29.9 33.5 37.2 30.9 32.5
LA 4.3 14.7 16.9 19 21.8 24.5 25.4 28.3
MA 7.5 12 19 25.7 33 31.8 32.8 32.1
MD 11.4 11.4 17.4 20.9 33.2 36.3 37.2 38.2
ME 5.3 12.4 16.8 21.2 28.7 34.4 27.9 29.9
MI 4.6 9.8 18 20.4 24.4 27.8 26.6 24.4
MN 2.8 5.4 9.6 10.6 12.5 13.3 11.5 14.2
MO 5 10.7 18.2 17.9 23.6 23.4 27.5 26.9
MS 3.2 8.8 11.6 12.3 12.1 12.2 10.8 13.6
MT 4.6 10.1 12.4 13.8 11.7 11.7 12.2 14.1
NC 4.6 11.4 13.8 15.8 19.7 24.1 22.4 22.3
ND 0 0 6.3 8.6 10.6 9.2 10.2 11.4
NE 2.3 5 7.2 6.9 6.4 8.1 7.4 8.7
NH 4.3 10.7 26.2 34.3 39 37 35.8 32
NJ 6.5 9.4 14 16.3 23.2 30 33.1 31.7
NM 15 20.1 27.3 25.3 25.2 24.8 26.7 30.2
NV 11.5 18.7 18.4 20.4 21.7 21.6 21.2 20.1
NY 5 4.8 11.3 13.6 18 19.4 18.4 18.2
OH 4.2 10.9 24.6 29.9 39.1 46.3 35.9 38.3
OK 5.4 13.8 20.3 19 21.5 20.1 18.4 16.7
OR 6.1 10.4 12.8 12 11.9 12.4 12.6 14
PA 8.1 13.2 21.9 26.3 37.9 44.3 36.1 35.6
RI 5.5 14.3 23.4 28.2 30.8 31 30.1 29.5
SC 3.7 9.9 14.4 15.7 18.1 20.5 22.6 22.7
SD 0 5.5 7.8 8.4 8.4 8.5 6.9 10.5
TN 6.1 14.5 19.5 22.2 24.5 26.6 27.5 31.2
TX 5.4 8.5 9.7 9.4 10.1 10.5 10.4 10.8
UT 10.6 19.3 22.4 23.4 22.4 22.3 21.2 18.9
VA 5 7.5 11.7 12.4 16.7 17.9 17.1 18.3
VT 4.7 8.5 13.9 16.7 22.2 23.2 26.6 23.8
WA 9.3 13 13.3 14.7 14.5 15.2 14.8 15.8
WI 4 9.3 15.1 15.5 19.3 21.2 19.2 21.1
WV 4.1 10.5 35.5 41.5 52 57.8 51.5 52.8
WY 4.1 4.9 19.4 16.4 17.6 12.2 11.1 14.1

Table in alphabetical order by full state name

[edit]
STATE 1999 2005 2014 2015 2016 2017 2018 2019
AL 3.9 6.3 15.2 15.7 16.2 18 16.6 16.3
AK 7.5 11.4 16.8 16 16.8 20.2 14.6 17.8
AZ 10.6 14.1 12.6 19 20.3 22.2 23.8 26.8
AR 4.4 10.1 18.2 13.8 14 15.5 15.7 13.5
CA 8.1 9 11.1 11.3 11.2 11.7 12.8 15
CO 8 12.7 16.3 15.4 16.6 17.6 16.8 18
CT 9 8.5 17.6 22.1 27.4 30.9 30.7 34.7
DE 6.4 7.5 20.9 22 30.8 37 43.8 48
FL 6.4 13.5 13.2 16.2 23.7 25.1 22.8 25.5
GA 3.5 8.2 11.9 12.7 13.3 14.7 13.2 13.1
HI 6.5 9.4 10.9 11.3 12.8 13.8 14.3 15.9
ID 5.3 8.1 13.7 14.2 15.2 14.4 14.6 15.1
IL 6.7 8.4 13.1 14.1 18.9 21.6 21.3 21.9
IN 3.2 9.8 18.2 19.5 24 29.4 25.6 26.6
IA 1.9 4.8 8.8 10.3 10.6 11.5 9.6 11.5
KS 3.4 9.1 11.7 11.8 11.1 11.8 12.4 14.3
KY 4.9 15.3 24.7 29.9 33.5 37.2 30.9 32.5
LA 4.3 14.7 16.9 19 21.8 24.5 25.4 28.3
ME 5.3 12.4 16.8 21.2 28.7 34.4 27.9 29.9
MD 11.4 11.4 17.4 20.9 33.2 36.3 37.2 38.2
MA 7.5 12 19 25.7 33 31.8 32.8 32.1
MI 4.6 9.8 18 20.4 24.4 27.8 26.6 24.4
MN 2.8 5.4 9.6 10.6 12.5 13.3 11.5 14.2
MS 3.2 8.8 11.6 12.3 12.1 12.2 10.8 13.6
MO 5 10.7 18.2 17.9 23.6 23.4 27.5 26.9
MT 4.6 10.1 12.4 13.8 11.7 11.7 12.2 14.1
NE 2.3 5 7.2 6.9 6.4 8.1 7.4 8.7
NV 11.5 18.7 18.4 20.4 21.7 21.6 21.2 20.1
NH 4.3 10.7 26.2 34.3 39 37 35.8 32
NJ 6.5 9.4 14 16.3 23.2 30 33.1 31.7
NM 15 20.1 27.3 25.3 25.2 24.8 26.7 30.2
NY 5 4.8 11.3 13.6 18 19.4 18.4 18.2
NC 4.6 11.4 13.8 15.8 19.7 24.1 22.4 22.3
ND 0 0 6.3 8.6 10.6 9.2 10.2 11.4
OH 4.2 10.9 24.6 29.9 39.1 46.3 35.9 38.3
OK 5.4 13.8 20.3 19 21.5 20.1 18.4 16.7
OR 6.1 10.4 12.8 12 11.9 12.4 12.6 14
PA 8.1 13.2 21.9 26.3 37.9 44.3 36.1 35.6
RI 5.5 14.3 23.4 28.2 30.8 31 30.1 29.5
SC 3.7 9.9 14.4 15.7 18.1 20.5 22.6 22.7
SD 0 5.5 7.8 8.4 8.4 8.5 6.9 10.5
TN 6.1 14.5 19.5 22.2 24.5 26.6 27.5 31.2
TX 5.4 8.5 9.7 9.4 10.1 10.5 10.4 10.8
UT 10.6 19.3 22.4 23.4 22.4 22.3 21.2 18.9
VT 4.7 8.5 13.9 16.7 22.2 23.2 26.6 23.8
VA 5 7.5 11.7 12.4 16.7 17.9 17.1 18.3
WA 9.3 13 13.3 14.7 14.5 15.2 14.8 15.8
WV 4.1 10.5 35.5 41.5 52 57.8 51.5 52.8
WI 4 9.3 15.1 15.5 19.3 21.2 19.2 21.1
WY 4.1 4.9 19.4 16.4 17.6 12.2 11.1 14.1
Retrieved from "https://en.wikipedia.org/w/index.php?title=User:Timeshifter/Sandbox141&oldid=1016700439"