Here is the raw mysql-data [35mb] for all tweeps and their internal relations. The format is a mysql-database, and the easiest is to import it to a local mysqldatabase and then export it a format of your choice (such as gefx, gml or similar). The file, of course, is quite big.  Have fun. If you use the data, please let me know!

-- phpMyAdmin SQL Dump
-- version 3.5.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 25, 2013 at 10:27 AM
-- Server version: 5.1.66
-- PHP Version: 5.3.3
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
--
-- Database: `twittercensus2013_fi`
--
-- --------------------------------------------------------
--
-- Table structure for table `rels_cleaned`
--
CREATE TABLE IF NOT EXISTS `rels_cleaned` (
 `tid1` int(11) NOT NULL,
 `tid2` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `tweeps`
--
CREATE TABLE IF NOT EXISTS `tweeps` (
 `tid` int(11) NOT NULL,
 `screen_name` char(250) NOT NULL,
 `real_name` char(250) NOT NULL,
 `description` text NOT NULL,
 `location` char(255) CHARACTER SET latin1 NOT NULL,
 `lang_pear` tinyint(4) NOT NULL,
 `friends_count` int(11) NOT NULL,
 `statuses_count` int(11) NOT NULL,
 `followers_count` int(11) NOT NULL,
 `lang` char(10) CHARACTER SET latin1 DEFAULT NULL,
 `changed` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `created_at` datetime NOT NULL,
 `url` varchar(255) CHARACTER SET latin1 NOT NULL,
 `geo_enabled` tinyint(1) NOT NULL,
 `profile_image_url` char(255) CHARACTER SET latin1 NOT NULL,
 `favourites_count` int(11) NOT NULL,
 `tc_activetaliban` tinyint(4) NOT NULL,
 `tc_active` tinyint(4) NOT NULL,
 `tc_gender` tinyint(2) NOT NULL,
 `is_doctor` tinyint(1) NOT NULL,
 `is_journalist` tinyint(1) NOT NULL,
 `modularity` tinyint(3) unsigned NOT NULL,
 `tc_category` tinyint(4) NOT NULL,
 `queue` tinyint(4) NOT NULL,
 PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

One thought on “Twittercensus, Finnish raw data

  1. Pingback: Suomi-Twitterin Top 100 seuratuimmat: Ilta-Sanomat ja Niinistö kärjessä

Leave a reply

required

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>