The OpenCare Semantic Social Network Data
Exploring Interaction Patterns and Relationship Dynamics
@kaggle.thedevastator_semantic_opencare_network_analysis
Exploring Interaction Patterns and Relationship Dynamics
@kaggle.thedevastator_semantic_opencare_network_analysis
CREATE TABLE annotations (
"id" BIGINT,
"version" VARCHAR,
"text" VARCHAR,
"quote" VARCHAR,
"uri" VARCHAR,
"created_at" VARCHAR,
"updated_at" VARCHAR,
"post_id" BIGINT,
"creator_id" BIGINT,
"type" VARCHAR,
"shape" VARCHAR,
"units" VARCHAR,
"geometry" VARCHAR,
"src" VARCHAR,
"ext" VARCHAR,
"container" VARCHAR,
"start" VARCHAR,
"end" VARCHAR,
"topic_id" BIGINT,
"post_creator_id" BIGINT,
"code_id" BIGINT
);
CREATE TABLE codes (
"id" BIGINT,
"description" VARCHAR,
"creator_id" BIGINT,
"created_at" VARCHAR,
"updated_at" VARCHAR,
"ancestry" VARCHAR,
"annotations_count" BIGINT,
"name" VARCHAR,
"name_with_path" VARCHAR,
"names" VARCHAR
);
CREATE TABLE participants (
"par" VARCHAR,
"icipan" VARCHAR,
"unnamed_2" VARCHAR
);
CREATE TABLE posts (
"post_number" BIGINT,
"post_id" BIGINT,
"created_at" VARCHAR,
"topic_id" BIGINT,
"reply_count" BIGINT,
"reads" BIGINT,
"readers_count" BIGINT,
"incoming_link_count" BIGINT,
"quote_count" BIGINT,
"like_count" BIGINT,
"score" DOUBLE,
"reply_to_post_id" BIGINT,
"source_username" VARCHAR,
"target_username" VARCHAR,
"text" VARCHAR
);
Anyone who has the link will be able to view this.