OKC Project

From edegan.com
Revision as of 14:56, 26 September 2011 by imported>Ed
Jump to navigation Jump to search
  • This page is protected so that only Ed, Toby and Misiek can read or edit it.

I will be posting reports and other materials on the OK Cupid project here.

Data Description from Misiek

Toby sent me a file with the following data description:

USERS

Total = 1,804,993
Female = 722,889 = 40%

US = 1,523,778
NonUS = 281,215 = 16%

US Male = 897,323 = 59%
US Female = 626,455 = 41%

US Male Singles = 827,702 = 92% of US Male
US Female Singles =  565,067 = 90% of US Female 

US Male LongTermInterest = 530,450 = 59% of Male
US Female LongTermInterest = 333,947 = 53% of US Female

US Male ShortTermInterest =  433,904 = 48% of Male
US Female ShortTermInterest = 225,715 = 36% of US Female

US Male CasualSex = 96,714 = 11% of Male
US Female CasualSex = 19,331 = 3% of US Female

US Male Gays = 77,902 = 9% of US Male
US Male Bi = 19,295 = 2% of US Male
US Male Straight = 800,126 = 89% of US Male

US Female Gays = 46,118 = 7% of US Female
US Female Bi = 59,585 = 10% of US Female
US Female Straight = 520,752 = 83% of US Female

US Male NoRace = 260,889 = 31% of US Male
US Male White = 517,636 = 57,172% of US Male
US Male Black = 38,787 = 4% of US Male
US Male Asian = 34,158= 4% of US Male
US Male Latino = 57,172 = 6% of US Male

US Female NoRace = 185,725 = 30% of US Female
US Female White = 358,119 = 57% of US Female
US Female Black =  32,195 = 5% of US Female
US Female Asian = 22,979 = 4% of US Female
US Female Latino = 37,274 = 5% of US Female

Data Description

This section provides summary stats on gender/orientation/race/location/age.

Gender

+--------+---------+------------+
| female | Count   | Percentage |
+--------+---------+------------+
|      0 | 1082104 |     0.5995 |
|      1 |  722889 |     0.4005 |
+--------+---------+------------+

Orientation

0=Straight, 1=Gay, 2=Bi
+-------------+---------+------------+
| orientation | Count   | Percentage |
+-------------+---------+------------+
|           0 | 1570050 |     0.8698 |
|           1 |  139697 |     0.0774 |
|           2 |   95246 |     0.0528 |
+-------------+---------+------------+

Ethnicity

+------------------+--------+------------+
| ethnicitylabels  | Count  | Percentage |
+------------------+--------+------------+
| mixed            | 105456 |     0.0584 |
| white            | 917178 |     0.5081 |
| black            |  53884 |     0.0299 |
| hispanic_latin   |  61034 |     0.0338 |
| asian            |  54645 |     0.0303 |
| indian           |  11658 |     0.0065 |
| middle_eastern   |   5916 |     0.0033 |
| native_american  |   4056 |     0.0022 |
| pacific_islander |   3238 |     0.0018 |
| other            |  24761 |     0.0137 |
| none             | 563167 |     0.3120 |
+------------------+--------+------------+

Location

+------+--------+------------+
| zip1 | Count  | Percentage |
+------+--------+------------+
| 0    | 178253 |     0.0988 |
| 1    | 229719 |     0.1273 |
| 2    | 136538 |     0.0756 |
| 3    | 148748 |     0.0824 |
| 4    | 126115 |     0.0699 |
| 5    |  66067 |     0.0366 |
| 6    | 105097 |     0.0582 |
| 7    | 126851 |     0.0703 |
| 8    |  84204 |     0.0467 |
| 9    | 322186 |     0.1785 |
| 99   | 281215 |     0.1558 |
+------+--------+------------+

Age

+-----------+--------+------------+
| age_range | Count  | Percentage |
+-----------+--------+------------+
| 15-19     |  97659 |     0.0541 |
| 20-24     | 485028 |     0.2687 |
| 25-29     | 475376 |     0.2634 |
| 30-34     | 274281 |     0.1520 |
| 35-39     | 155925 |     0.0864 |
| 40-44     | 109121 |     0.0605 |
| 45-49     |  78618 |     0.0436 |
| 50-59     |  95810 |     0.0531 |
| >60       |  33175 |     0.0184 |
+-----------+--------+------------+

Account Age

+---------------+--------+------------+
| acc_age_range | Count  | Percentage |
+---------------+--------+------------+
| 0             |   1385 |     0.0008 |
| 1             |   7914 |     0.0044 |
| 2             |   7967 |     0.0044 |
| 3             |   9051 |     0.0050 |
| 4             |   9134 |     0.0051 |
| 5             |  10032 |     0.0056 |
| 6-10          |  35862 |     0.0199 |
| 11-15         |  39986 |     0.0222 |
| 16-30         | 136983 |     0.0759 |
| 31-60         | 233560 |     0.1294 |
| 61-100        | 237369 |     0.1315 |
| 101-365       | 535715 |     0.2968 |
| 366-3650      | 540035 |     0.2992 |
+---------------+--------+------------+