Taddy API Podcast Dataset Sample

This sample contains 11,361 podcasts and 10,000 episodes from the Taddy Podcast API Dataset. The full dataset contains 4+ million podcasts and 200+ million episodes and is ~80GB in size.

If you want to purchase the full dataset, please contact danny@taddy.org.

Data Format

This project contains 4 files in Parquet format.

Table Definitions

Podcast Series Table - For documentation on the fields, see the PodcastSeries

CREATE TABLE podcastseries (
    id BIGSERIAL,
    uuid uuid PRIMARY KEY,
    created_at timestamp with time zone NOT NULL DEFAULT now(),
    updated_at timestamp with time zone,
    source character varying(255),
    hash character varying(255) UNIQUE,
    hash_timestamp bigint,
    genres_hash character varying(255),
    itunes_info_hash character varying(255),
    date_published timestamp with time zone,
    name character varying(255),
    description text,
    image_url text,
    itunes_id bigint UNIQUE,
    series_type character varying(255),
    copyright text,
    country_of_origin character varying(255),
    language character varying(255),
    website_url text,
    author_name character varying(255),
    content_type character varying(255),
    rss_url text UNIQUE,
    rss_owner_name character varying(255),
    rss_owner_public_email text,
    is_explicit_content boolean,
    is_completed boolean,
    is_blocked boolean,
    children_hash character varying(255),
    rss_persons_hash character varying(255),
    transcribe_status character varying(255)
);

Podcast Episode Table - For documentation on the fields, see the PodcastEpisode

CREATE TABLE podcastepisode (
    id BIGSERIAL,
    uuid uuid PRIMARY KEY,
    created_at timestamp with time zone NOT NULL DEFAULT now(),
    updated_at timestamp with time zone,
    hash character varying(255),
    hash_timestamp bigint,
    date_published timestamp with time zone,
    name character varying(255),
    description text,
    image_url text,
    series_uuid uuid NOT NULL,
    guid text NOT NULL,
    series_uuid_plus_guid text NOT NULL UNIQUE,
    subtitle text,
    audio_url text,
    video_url text,
    file_length integer,
    file_type character varying(255),
    duration integer,
    season_number integer,
    episode_number integer,
    episode_type character varying(255),
    website_url text,
    is_explicit_content boolean,
    is_removed boolean,
    series_hash character varying(255),
    is_blocked boolean,
    rss_transcripts jsonb, // Transcripts from the RSS feed
    rss_chapters jsonb, // Chapters from the RSS feed
    rss_persons_hash character varying(255), // Persons tag from the RSS feed
    transcribe_status character varying(255), // Status of the transcript (processing, completed, failed)
    taddy_transcript_url character varying(255), // Transcripts autogenerated by Taddy
    taddy_chunks_url character varying(255), // On-demand transcript (autogenerated by Taddy)
    taddy_chapter_url character varying(255) // Chapters autogenerated by Taddy (deprecated)
);

Genre Table - Lists the genres that a podcast belongs to. A podcast can have up to 5 genres. For possible genre values, see the Genre. You do not need to have your own genre table, but can add a column to the podcast series table to store the genres if you choose. We use this table internally for historical reasons.

CREATE TABLE genres (
    id BIGSERIAL PRIMARY KEY,
    created_at timestamp with time zone NOT NULL DEFAULT now(),
    updated_at timestamp with time zone,
    uuid uuid NOT NULL,
    genre character varying(255) NOT NULL,
    taddy_type character varying(255) NOT NULL,
    position integer
);

iTunes Info Table - For documentation on the fields, see the iTunesInfo

CREATE TABLE itunes_info (
    id BIGSERIAL,
    created_at timestamp with time zone NOT NULL DEFAULT now(),
    updated_at timestamp with time zone,
    uuid uuid PRIMARY KEY,
    hash character varying(255),
    hash_timestamp bigint,
    subtitle text,
    summary text,
    base_artwork_url text,
    country character varying(255),
    publisher_id bigint,
    publisher_name character varying(255)
);