User:Timeshifter/Sandbox141

__TOC__

Rates

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.

class="wikitable"

|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

class="wikitable sortable nowrap mw-datatable" border=1 style="text-align:right;"

! State

!1999

!2005

!2014

!2015

!2016

! 2017

align=left|{{flaglist|Alabama}}

|3.9

|6.3

|15.2

|15.7

|16.2

| 18

align=left|{{flaglist|Alaska}}

|7.5

|11.4

|16.8

|16

|16.8

| 20.2

align=left|{{flaglist|Arizona}}

|10.6

|14.1

|12.6

|19

|20.3

| 22.2

Pivot table (from LibreOffice Calc) copied into Visual Editor

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

  • https://www.google.com/search?q=libreoffice+calc+pivot

One page it pulls up is this one:

  • https://elearn.ellak.gr/mod/page/view.php?id=3015

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.

class="wikitable"

|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

class="wikitable"

|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