jsk

Custom SQL query

count_history

type, user, datetime, count

1,691 rows

count_history_types

id, name

3 rows

following

followed_id, follower_id, first_seen

0 rows

list_members

list, user

953 rows

lists

id, name, uri, subscriber_count, member_count, mode, description, slug, full_name...

40 rows

places

id

0 rows

since_id_types

id, name

4 rows

since_ids

type, key, since_id

0 rows

sources

id, name, url

0 rows

tweets

id, user, created_at, full_text, retweeted_status, quoted_status, place, source

0 rows

users

id, screen_name, name, description, location, url, protected, followers_count, friends_count...

562 rows

tweets_fts (hidden)

full_text

0 rows

tweets_fts_config (hidden)

k, v

1 row

tweets_fts_data (hidden)

id, block

2 rows

tweets_fts_docsize (hidden)

id, sz

0 rows

tweets_fts_idx (hidden)

segid, term, pgno

0 rows

users_fts (hidden)

name, screen_name, description, location

562 rows

users_fts_config (hidden)

k, v

1 row

users_fts_data (hidden)

id, block

59 rows

users_fts_docsize (hidden)

id, sz

562 rows

users_fts_idx (hidden)

segid, term, pgno

57 rows

Views

Download SQLite DB: jsk.db 944.0 KB

Powered by Datasette · Query took 36.059ms · About: simonw/jsk-fellows-on-twitter