Metrics/Data Catalog - Revision history

Mike Linksvayer at 03:19, 27 June 2011

2011-06-27T03:19:56Z

Mike Linksvayer at 01:13, 27 June 2011

2011-06-27T01:13:56Z

Mike Linksvayer at 04:42, 10 March 2010

2010-03-10T04:42:43Z

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

2010-03-10T03:10:45Z

‎per license link: search engine queries

Mike Linksvayer at 02:36, 10 March 2010

2010-03-10T02:36:46Z

Mike Linksvayer at 21:10, 9 March 2010

2010-03-09T21:10:44Z

Mike Linksvayer at 21:04, 9 March 2010

2010-03-09T21:04:54Z

Mike Linksvayer at 19:14, 9 March 2010

2010-03-09T19:14:47Z

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>

@@ Line 1: / Line 1: @@
 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 ==

@@ Line 1: / Line 1: @@
 This page describes raw data available concerning [[Metrics/License statistics|CC license use]].
 == per license link: search engine queries ==
@@ Line 144: / Line 146: @@
 ==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.
 <pre>
 mysql> desc complex;

← 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 ==

@@ 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>

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

← 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>

@@ Line 26: / Line 26: @@
    KEY `timestamp_index` (`timestamp`)
 );
 </pre>
@@ Line 55: / Line 58: @@
    KEY `complex_timestamp_index` (`timestamp`)
 );
 </pre>
 <pre>
@@ Line 82: / Line 85: @@
    KEY `site_specific_timestamp_index` (`utc_time_stamp`)
 );
 </pre>

@@ 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>