Metrics/Data Catalog - Revision history

Mike Linksvayer at 03:19, 27 June 2011

2011-06-27T03:19:56Z

← Older revision		Revision as of 03:19, 27 June 2011
Line 1:		Line 1:
	This page describes raw data available concerning [[Metrics/License statistics\|CC license use]].		This page describes raw data available concerning [[Metrics/License statistics\|CC license use]].

	See http://labs.creativecommons.org/2011/06/26/powerofopen-metrics/ for some tips on using this data.		See http://labs.creativecommons.org/2011/06/27/powerofopen-metrics/ for some tips on using this data.

	== per license link: search engine queries ==		== per license link: search engine queries ==

Mike Linksvayer at 01:13, 27 June 2011

2011-06-27T01:13:56Z

← Older revision		Revision as of 01:13, 27 June 2011
Line 1:		Line 1:
	This page describes raw data available concerning [[Metrics/License statistics\|CC license use]].		This page describes raw data available concerning [[Metrics/License statistics\|CC license use]].

			See http://labs.creativecommons.org/2011/06/26/powerofopen-metrics/ for some tips on using this data.

	== per license link: search engine queries ==		== per license link: search engine queries ==
Line 144:		Line 146:
	==License property search engine API queries==		==License property search engine API queries==
	Yahoo and Google allow filtering searches by CC license property (eg allows commercial use). This is coarser than per license link: queries, but unlike link: can be (indeed must be) combined with keyword and optionally country and language operators. This facilitates another take on the distribution of CC licenses not dependent on availability or use of jurisdiction ported licenses. Currently only Yahoo is regularly queried. Countries and languages are those supported for Yahoo queries.		Yahoo and Google allow filtering searches by CC license property (eg allows commercial use). This is coarser than per license link: queries, but unlike link: can be (indeed must be) combined with keyword and optionally country and language operators. This facilitates another take on the distribution of CC licenses not dependent on availability or use of jurisdiction ported licenses. Currently only Yahoo is regularly queried. Countries and languages are those supported for Yahoo queries.

			See http://labs.creativecommons.org/2010/12/09/available-for-analysis/ for ideas on using this data.

	<pre>		<pre>
	mysql> desc complex;		mysql> desc complex;

Mike Linksvayer at 04:42, 10 March 2010

2010-03-10T04:42:43Z

← Older revision		Revision as of 04:42, 10 March 2010
Line 1:		Line 1:
			This page describes raw data available concerning [[Metrics/License statistics\|CC license use]].

	== per license link: search engine queries ==		== per license link: search engine queries ==

Mike Linksvayer: /* per license link: search engine queries */

2010-03-10T03:10:45Z

per license link: search engine queries

@@ Line 111: / Line 111: @@
 | 3.0             |
 +-----------------+
 mysql> select distinct(license_uri) from simple where license_version is NULL;
@@ Line 121: / Line 120: @@
 | http://creativecommons.org/licenses/publicdomain |
 +--------------------------------------------------+
 These can be removed for many purposes:
 mysql> select distinct(license_uri) from simple where license_version is NULL or license_type = 'GPL' or license_type = 'LGPL';
 +--------------------------------------------------+
@@ Line 136: / Line 137: @@
 mysql> delete from simple where license_version is NULL or license_type = 'GPL' or license_type = 'LGPL';
 Query OK, 22822 rows affected (10.56 sec)
 </pre>
+==License property search engine API queries==
 <pre>
 mysql> desc complex;
@@ Line 173: / Line 173: @@
 INSERT INTO `complex` VALUES (32,'cc_any','Yahoo',3,'license','2006-07-11 16:24:42','Norway','portuguese');
 </pre>
 <pre>
 mysql> desc site_specific;
@@ Line 199: / Line 259: @@
 INSERT INTO `site_specific` VALUES (1,'http://creativecommons.org/licenses/by-nd/2.0/','http://www.flickr.com/',317345,'2006-03-17 12:00:00');
 </pre>

Mike Linksvayer at 02:36, 10 March 2010

2010-03-10T02:36:46Z

@@ Line 1: / Line 1: @@
 <pre>
 mysql> desc simple;
@@ Line 26: / Line 31: @@
    KEY `timestamp_index` (`timestamp`)
 );
 </pre>
 <pre>

Mike Linksvayer at 21:10, 9 March 2010

2010-03-09T21:10:44Z

← Older revision		Revision as of 21:10, 9 March 2010
Line 28:		Line 28:


	INSERT INTO `simple` VALUES (750584,'http://creativecommons.org/licenses/by-sa/2.0/jp','MSN',3955,'2006-07-11 16:04:56','jp','by-sa','2.0');		INSERT INTO `simple` VALUES (750584,'http://creativecommons.org/licenses/by-sa/2.0/jp/','MSN',3955,'2006-07-11 16:04:56','jp','by-sa','2.0');
	</pre>		</pre>

Mike Linksvayer at 21:04, 9 March 2010

2010-03-09T21:04:54Z

← Older revision		Revision as of 21:04, 9 March 2010
Line 26:		Line 26:
	KEY `timestamp_index` (`timestamp`)		KEY `timestamp_index` (`timestamp`)
	);		);


			INSERT INTO `simple` VALUES (750584,'http://creativecommons.org/licenses/by-sa/2.0/jp','MSN',3955,'2006-07-11 16:04:56','jp','by-sa','2.0');
	</pre>		</pre>

Line 55:		Line 58:
	KEY `complex_timestamp_index` (`timestamp`)		KEY `complex_timestamp_index` (`timestamp`)
	);		);

			INSERT INTO `complex` VALUES (32,'cc_any','Yahoo',3,'license','2006-07-11 16:24:42','Norway','portuguese');

	</pre>		</pre>



	<pre>		<pre>
Line 82:		Line 85:
	KEY `site_specific_timestamp_index` (`utc_time_stamp`)		KEY `site_specific_timestamp_index` (`utc_time_stamp`)
	);		);

			INSERT INTO `site_specific` VALUES (1,'http://creativecommons.org/licenses/by-nd/2.0/','http://www.flickr.com/',317345,'2006-03-17 12:00:00');
	</pre>		</pre>

Mike Linksvayer at 19:14, 9 March 2010

2010-03-09T19:14:47Z

@@ Line 13: / Line 13: @@
 | license_version | varchar(16)  | YES  |     | NULL                |                |
 +-----------------+--------------+------+-----+---------------------+----------------+
 </pre>
@@ Line 29: / Line 42: @@
 | language          | varchar(255) | YES  |     | NULL                |                |
 +-------------------+--------------+------+-----+---------------------+----------------+
 </pre>
@@ Line 44: / Line 71: @@
 | utc_time_stamp | datetime     | NO   | MUL | NULL    |                |
 +----------------+--------------+------+-----+---------+----------------+
 </pre>

Mike Linksvayer: Created page with '

 mysql> desc simple; +-----------------+--------------+------+-----+---------------------+----------------+ | Field           | Type         | Null | Key | Default          …'

2010-03-09T17:43:25Z

New page

<pre>
mysql> desc simple;
+-----------------+--------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| license_uri | varchar(255) | NO | | | |
| search_engine | varchar(255) | NO | | | |
| count | int(11) | NO | | 0 | |
| timestamp | datetime | NO | MUL | 0000-00-00 00:00:00 | |
| jurisdiction | varchar(255) | YES | | NULL | |
| license_type | varchar(16) | YES | | NULL | |
| license_version | varchar(16) | YES | | NULL | |
+-----------------+--------------+------+-----+---------------------+----------------+
</pre>

<pre>
mysql> desc complex;
+-------------------+--------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| license_specifier | varchar(255) | NO | | | |
| search_engine | varchar(255) | NO | | | |
| count | int(11) | NO | | 0 | |
| query | varchar(255) | YES | | NULL | |
| timestamp | datetime | NO | MUL | 0000-00-00 00:00:00 | |
| country | varchar(255) | YES | | NULL | |
| language | varchar(255) | YES | | NULL | |
+-------------------+--------------+------+-----+---------------------+----------------+
</pre>

<pre>
mysql> desc site_specific;
+----------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| license_uri | varchar(255) | NO | | NULL | |
| site | varchar(255) | NO | | NULL | |
| count | int(11) | NO | | NULL | |
| utc_time_stamp | datetime | NO | MUL | NULL | |
+----------------+--------------+------+-----+---------+----------------+
</pre>