cleaned metadata from mid town journal.csv
168 rows of data grouped into 20 columns.
Here's some metadata about each column.
These results will expire in -501 days.
.
- 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 |
- 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 |
- 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 |
- 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 |
- 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 |
- 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 |
- 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
- 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 |
- 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 |
- 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 |
- 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 |
- 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
- 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 |
- 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
- 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 |
- 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 |
- 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 |
- 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
- 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 |
- 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
- 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 |
- 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: