168 rows of data grouped into 20 columns.
Here's some metadata about each column.
These results will expire in -501 days.

.

Temporal Scope

  • This column is full of text
  • The unique values in this column are:
    • Twentieth Century (168)
value frequency
Twentieth Century 168

Temporal Scope

  • This column is full of text
  • The unique values in this column are:
    • Twentieth Century (168)

Date

  • This column is full of dates
  • The smallest number is 25/07/1941
  • The biggest number is 02/05/1966
  • There are 86 rows of missing data
  • There are 74 unique values
value frequency
25/07/1941 - 15/01/1944 7
15/01/1944 - 08/07/1946 5
08/07/1946 - 29/12/1948 13
29/12/1948 - 21/06/1951 11
21/06/1951 - 12/12/1953 7
12/12/1953 - 04/06/1956 9
04/06/1956 - 25/11/1958 7
25/11/1958 - 18/05/1961 7
18/05/1961 - 09/11/1963 5
09/11/1963 - 02/05/1966 9

Date

  • This column is full of dates
  • The smallest number is 25/07/1941
  • The biggest number is 02/05/1966
  • There are 86 rows of missing data
  • There are 74 unique values

Decade

  • This column is full of text
  • The unique values in this column are:
    • 1940s (81)
    • 1950s (55)
    • 1960s (32)
value frequency
1940s 81
1950s 55
1960s 32

Decade

  • This column is full of text
  • The unique values in this column are:
    • 1940s (81)
    • 1950s (55)
    • 1960s (32)

Volume

  • This column is full of numbers
  • The smallest number is 4.0
  • The biggest number is 28.0
  • The total is 1291.0
  • The average is 15.94
  • The median is 15.0
  • The standard deviation is 6.95
  • There are 87 rows of missing data
  • There are 22 unique values
value frequency
4 - 6 7
6 - 9 4
9 - 11 14
11 - 14 6
14 - 16 12
16 - 18 8
18 - 21 7
21 - 23 7
23 - 26 5
26 - 28 10

Volume

  • This column is full of numbers
  • The smallest number is 4.0
  • The biggest number is 28.0
  • The total is 1291.0
  • The average is 15.94
  • The median is 15.0
  • The standard deviation is 6.95
  • There are 87 rows of missing data
  • There are 22 unique values

Number

  • This column is full of numbers
  • The smallest number is 1.0
  • The biggest number is 52.0
  • The total is 2500.0
  • The average is 30.86
  • The median is 31.0
  • The standard deviation is 14.29
  • There are 87 rows of missing data
  • There are 39 unique values
value frequency
1 - 6 7
6 - 11 4
11 - 16 3
16 - 21 9
21 - 26 6
26 - 32 12
32 - 37 4
37 - 42 10
42 - 47 14
47 - 52 10

Number

  • This column is full of numbers
  • The smallest number is 1.0
  • The biggest number is 52.0
  • The total is 2500.0
  • The average is 30.86
  • The median is 31.0
  • The standard deviation is 14.29
  • There are 87 rows of missing data
  • There are 39 unique values

Page Number

  • This column is full of dates
  • The smallest number is 02/01/9999
  • The biggest number is 08/12/9999
  • There are 87 rows of missing data
  • There are 15 unique values
value frequency
02/01/9999 - 05/02/9999 33
05/02/9999 - 11/03/9999 0
11/03/9999 - 14/04/9999 0
14/04/9999 - 18/05/9999 0
18/05/9999 - 21/06/9999 0
21/06/9999 - 25/07/9999 0
25/07/9999 - 28/08/9999 0
28/08/9999 - 01/10/9999 0
01/10/9999 - 04/11/9999 0
04/11/9999 - 08/12/9999 37

Page Number

  • This column is full of dates
  • The smallest number is 02/01/9999
  • The biggest number is 08/12/9999
  • There are 87 rows of missing data
  • There are 15 unique values

Article Name

  • This column is full of text
  • The longest string has 147 characters
  • There are 86 rows of missing data
  • There are 82 unique values
value frequency
love 16
boy 12
man 10
masquerading 8
men 8
bare 6
queer 6
girl 6
cult 6
male 6
boys 6
party 5
hill 5
cops 5
masquerade 5
gay 5
gal 5
sex 5
two 4
tells 4

Article Name

  • This column is full of text
  • The longest string has 147 characters
  • There are 86 rows of missing data
  • There are 82 unique values

Name(s) of Queer...

  • Full name: "Name(s) of Queer Individual(s) Mentioned in the Article"
  • This column is full of text
  • The most frequent values in this column are:
    • George Roland (4)
    • Odell (Odellett) Miller (3)
    • unknown minor (3)
    • Earl (Edith Thornton) Peterson (2)
    • James Holmes (2)
  • The longest string has 41 characters
  • There are 5 rows of missing data
  • There are 151 unique values
value frequency
George Roland 4
Odell (Odellett) Miller 3
unknown minor 3
Earl (Edith Thornton) Peterson 2
James Holmes 2
Other 149

Name(s) of Queer...

  • Full name: "Name(s) of Queer Individual(s) Mentioned in the Article"
  • This column is full of text
  • The most frequent values in this column are:
    • George Roland (4)
    • Odell (Odellett) Miller (3)
    • unknown minor (3)
    • Earl (Edith Thornton) Peterson (2)
    • James Holmes (2)
  • The longest string has 41 characters
  • There are 5 rows of missing data
  • There are 151 unique values

Age(s)

  • This column is full of numbers
  • The smallest number is 15.0
  • The biggest number is 65.0
  • The total is 3393.0
  • The average is 26.93
  • The median is 24.0
  • The standard deviation is 9.15
  • There are 42 rows of missing data
  • There are 32 unique values
value frequency
15 - 20 19
20 - 25 46
25 - 30 26
30 - 35 16
35 - 40 10
40 - 45 0
45 - 50 5
50 - 55 0
55 - 60 2
60 - 65 1

Age(s)

  • This column is full of numbers
  • The smallest number is 15.0
  • The biggest number is 65.0
  • The total is 3393.0
  • The average is 26.93
  • The median is 24.0
  • The standard deviation is 9.15
  • There are 42 rows of missing data
  • There are 32 unique values

Presumed Gender Identity

  • Full name: "Presumed Gender Identity"
  • This column is full of text
  • The unique values in this column are:
    • Male (98)
    • Transgender woman (49)
    • Female (12)
    • male (1)
  • There are 8 rows of missing data
value frequency
Male 98
Transgender woman 49
Female 12
male 1

Presumed Gender Identity

  • Full name: "Presumed Gender Identity"
  • This column is full of text
  • The unique values in this column are:
    • Male (98)
    • Transgender woman (49)
    • Female (12)
    • male (1)
  • There are 8 rows of missing data

Presumed Sexual...

  • Full name: "Presumed Sexual Orientation"
  • This column is full of text
  • The unique values in this column are:
    • Homosexual (94)
    • Queer (53)
    • Lesbian (6)
    • Heterosexual (4)
  • There are 11 rows of missing data
value frequency
Homosexual 94
Queer 53
Lesbian 6
Heterosexual 4

Presumed Sexual...

  • Full name: "Presumed Sexual Orientation"
  • This column is full of text
  • The unique values in this column are:
    • Homosexual (94)
    • Queer (53)
    • Lesbian (6)
    • Heterosexual (4)
  • There are 11 rows of missing data

Home Longitude

  • This column is full of numbers
  • The smallest number is -72.56856059
  • The biggest number is -70.21867699
  • The total is -9528.15
  • The average is -71.11
  • The median is -71.08
  • The standard deviation is 0.2
  • There are 34 rows of missing data
  • There are 115 unique values
value frequency
-72.57 - -72.33 1
-72.33 - -72.1 0
-72.1 - -71.86 0
-71.86 - -71.63 4
-71.63 - -71.39 1
-71.39 - -71.16 2
-71.16 - -70.92 124
-70.92 - -70.69 1
-70.69 - -70.45 0
-70.45 - -70.22 0

Home Longitude

  • This column is full of numbers
  • The smallest number is -72.56856059
  • The biggest number is -70.21867699
  • The total is -9528.15
  • The average is -71.11
  • The median is -71.08
  • The standard deviation is 0.2
  • There are 34 rows of missing data
  • There are 115 unique values

Home Latitude

  • This column is full of numbers
  • The smallest number is 42.09854501
  • The biggest number is 44.09132004
  • The total is 5676.72
  • The average is 42.36
  • The median is 42.34
  • The standard deviation is 0.17
  • There are 34 rows of missing data
  • There are 115 unique values
value frequency
42.1 - 42.3 9
42.3 - 42.5 120
42.5 - 42.7 2
42.7 - 42.9 1
42.9 - 439 1
439 - 43.29 0
43.29 - 43.49 0
43.49 - 43.69 0
43.69 - 43.89 0
43.89 - 449 0

Home Latitude

  • This column is full of numbers
  • The smallest number is 42.09854501
  • The biggest number is 44.09132004
  • The total is 5676.72
  • The average is 42.36
  • The median is 42.34
  • The standard deviation is 0.17
  • There are 34 rows of missing data
  • There are 115 unique values

Home Address

  • This column is full of text
  • The most frequent values in this column are:
    • 126 Commonwealth Avenue (5)
    • 100 Carver Street (2)
    • 116 Commonwealth Avenue (2)
    • 124 Dartmouth Street (2)
    • 291 Bryant Street (2)
  • The longest string has 68 characters
  • There are 25 rows of missing data
  • There are 127 unique values
value frequency
126 Commonwealth Avenue 5
100 Carver Street 2
116 Commonwealth Avenue 2
124 Dartmouth Street 2
291 Bryant Street 2
Other 130

Home Address

  • This column is full of text
  • The most frequent values in this column are:
    • 126 Commonwealth Avenue (5)
    • 100 Carver Street (2)
    • 116 Commonwealth Avenue (2)
    • 124 Dartmouth Street (2)
    • 291 Bryant Street (2)
  • The longest string has 68 characters
  • There are 25 rows of missing data
  • There are 127 unique values

Arrest Location

  • This column is full of text
  • The most frequent values in this column are:
    • Beaux Arte Ball at the Sherry Biltmore Hotel (4)
    • 69 Warwick Street (3)
    • Columbus Avenue (3)
    • Tremont Street (3)
    • D Street (2)
  • The longest string has 85 characters
  • There are 96 rows of missing data
  • There are 60 unique values
value frequency
Beaux Arte Ball at the Sherry Biltmore Hotel 4
69 Warwick Street 3
Columbus Avenue 3
Tremont Street 3
D Street 2
Other 57

Arrest Location

  • This column is full of text
  • The most frequent values in this column are:
    • Beaux Arte Ball at the Sherry Biltmore Hotel (4)
    • 69 Warwick Street (3)
    • Columbus Avenue (3)
    • Tremont Street (3)
    • D Street (2)
  • The longest string has 85 characters
  • There are 96 rows of missing data
  • There are 60 unique values

Arrest Longitude

  • This column is full of numbers
  • The smallest number is -71.09837679
  • The biggest number is -71.03548492
  • The total is -6041.3
  • The average is -71.07
  • The median is -71.08
  • The standard deviation is 0.01
  • There are 83 rows of missing data
  • There are 57 unique values
value frequency
-71.1 - -719 3
-719 - -719 5
-719 - -718 13
-718 - -717 32
-717 - -717 14
-717 - -716 10
-716 - -715 5
-715 - -715 0
-715 - -714 2
-714 - -714 0

Arrest Longitude

  • This column is full of numbers
  • The smallest number is -71.09837679
  • The biggest number is -71.03548492
  • The total is -6041.3
  • The average is -71.07
  • The median is -71.08
  • The standard deviation is 0.01
  • There are 83 rows of missing data
  • There are 57 unique values

Arrest Latitude

  • This column is full of numbers
  • The smallest number is 42.31576665
  • The biggest number is 42.37282119
  • The total is 3599.45
  • The average is 42.35
  • The median is 42.35
  • The standard deviation is 0.01
  • There are 83 rows of missing data
  • There are 57 unique values
value frequency
42.32 - 42.32 2
42.32 - 42.33 0
42.33 - 42.33 1
42.33 - 42.34 6
42.34 - 42.34 28
42.34 - 42.35 14
42.35 - 42.36 28
42.36 - 42.36 4
42.36 - 42.37 1
42.37 - 42.37 0

Arrest Latitude

  • This column is full of numbers
  • The smallest number is 42.31576665
  • The biggest number is 42.37282119
  • The total is 3599.45
  • The average is 42.35
  • The median is 42.35
  • The standard deviation is 0.01
  • There are 83 rows of missing data
  • There are 57 unique values

Activity At The...

  • Full name: "Activity At The Time Of Arrest"
  • This column is full of text
  • The most frequent values in this column are:
    • Soliciting sex from passing motorists (7)
    • Witnessing a lewd performance (7)
    • Having sexual relations in Varney's apt (3)
    • Cruising for and picking up sailors on the Summer Street bridge (2)
    • Home alone when arrested (2)
  • The longest string has 217 characters
  • There are 71 rows of missing data
  • There are 77 unique values
value frequency
Soliciting sex from passing motorists 7
Witnessing a lewd performance 7
Having sexual relations in Varney's apt 3
Cruising for and picking up sailors on the Summer Street bridge 2
Home alone when arrested 2
Other 76

Activity At The...

  • Full name: "Activity At The Time Of Arrest"
  • This column is full of text
  • The most frequent values in this column are:
    • Soliciting sex from passing motorists (7)
    • Witnessing a lewd performance (7)
    • Having sexual relations in Varney's apt (3)
    • Cruising for and picking up sailors on the Summer Street bridge (2)
    • Home alone when arrested (2)
  • The longest string has 217 characters
  • There are 71 rows of missing data
  • There are 77 unique values

Charges

  • This column is full of text
  • The most frequent values in this column are:
    • Being idle and disorderly (13)
    • Morals violations (11)
    • Witnessing a lewd performance (7)
    • 1000 dollar bail (3)
    • Being a lewd person in speech and behavior (3)
  • The longest string has 99 characters
  • There are 74 rows of missing data
  • There are 48 unique values
value frequency
Being idle and disorderly 13
Morals violations 11
Witnessing a lewd performance 7
1000 dollar bail 3
Being a lewd person in speech and behavior 3
Other 57

Charges

  • This column is full of text
  • The most frequent values in this column are:
    • Being idle and disorderly (13)
    • Morals violations (11)
    • Witnessing a lewd performance (7)
    • 1000 dollar bail (3)
    • Being a lewd person in speech and behavior (3)
  • The longest string has 99 characters
  • There are 74 rows of missing data
  • There are 48 unique values

Sentence(s)

  • This column is full of text
  • The most frequent values in this column are:
    • Guilty (6)
    • Guilty. Six month suspended sentence along with two year probation (4)
    • Six months term with two year probationary period (4)
    • 5000 dollar bail (3)
    • Guilty. 1000 dollar bail (3)
  • The longest string has 232 characters
  • There are 43 rows of missing data
  • There are 86 unique values
value frequency
Guilty 6
Guilty. Six month suspended sentence along with two year probation 4
Six months term with two year probationary period 4
5000 dollar bail 3
Guilty. 1000 dollar bail 3
Other 105

Sentence(s)

  • This column is full of text
  • The most frequent values in this column are:
    • Guilty (6)
    • Guilty. Six month suspended sentence along with two year probation (4)
    • Six months term with two year probationary period (4)
    • 5000 dollar bail (3)
    • Guilty. 1000 dollar bail (3)
  • The longest string has 232 characters
  • There are 43 rows of missing data
  • There are 86 unique values

What do I do next?

Understanding the data in your csv file is the first step in analyzing it for stories. Looking at individual columns can help you identify questions that might be fun to ask about your data. For instance, is it surprising that "Beaux Arte Ball at the Sherry Biltmore Hotel" is the most frequent value in the Arrest Location column? Does it make any sense to compare the Home Address column to the Decade column? Are there any other datasets you could find to ask interesting questions about the Arrest Location column?

Asking these types of questions is the first step in understanding the data you have, and what kind of stories you can find in it. Check out our activity guide for more help on asking questions of data sets.

Try these other tools to do more full-fledged analysis: