डेटाबेस

स्कीमा संस्करण 2026-10-17 · 8959dbf अंतिम बदलाव 2026-10-17T07:37:29+02:00 /api/v1/schema/index.json

निजी भंडार

संग्रह कैसे जुड़े हैं

erDiagram
  NEWS }|--|| SOURCES : source
  NEWS }|--|| SOURCES : also_covered_by_.outlet
  NEWS ||--|| TITLE_I18N : id
  NEWS ||--|| BLURBS : id
  EVENTS }|--|| SPONSORS : sponsored
  EVENTS ||--o{ TALKS : id
  EVENTS ||--|| EVENT_DESCRIPTIONS : id
  EVENTS ||--|| EVENT_REDIRECTS : id
  SOURCES ||--o{ NEWS : id
  SPONSORS ||--o{ EVENTS : sponsored
  PROFILES }|--|| ORGCHART : entity_id_object_key
  ORGCHART }|--|| ORGCHART : relations_.from
  ORGCHART }|--|| ORGCHART : relations_.to
  ORGCHART }o--o{ TALKS : entities_.talk_ids
  ORGCHART ||--o{ PROFILES : id
  ORGCHART ||--o{ DEVELOPERS : id
  TALKS }|--|| EVENTS : event_id
  TALKS }o--o{ ORGCHART : speaker_ids
  DEVELOPERS }|--|| ORGCHART : org_id
  DEVELOPERS }|--|| ORGCHART : whoswho_id
  ILLUSTRATIONS }o--o{ NEWS : assign_.id
  IMAGES }|--|| ORGCHART : entity_id_object_key
  LOGOS ||--|| SOURCES : id_object_key
  ARTICLES }|--|| NEWS : articles_.id
  TITLE_I18N }|--|| NEWS : items_key
  BLURBS }|--|| NEWS : items_key
  EVENT_DESCRIPTIONS }|--|| EVENTS : items_key
  EVENT_REDIRECTS }|--|| EVENTS : removed_id_object_key
  EVENT_REDIRECTS }|--|| EVENTS : value

संग्रह

• News stories
• Events
• Sources
• Newsletters
• Sponsors
• Academia
• Books
• Markets
• Profiles
• Who's who
• Talks
• Developers
• Illustrations
• Portraits
• Outlet logos
• Changelog
• Rules map
• Visitor stats
• Crowdfunding
• Budget
• Article archive
• Headline translations
• Front-page blurbs
• Event descriptions
• Event redirects
• Regulation videos

News stories

Stories in data/news.json. status is the editorial state: pending, published, rejected or merged. The public API lists published stories that have a summary. Editor fields stay in the file and are left out of /api/v1/.

फ़ाइल data/news.json · JSON Schema

पृष्ठ

• /

API

• /api/v1/news.json — Published stories, newest first
• /api/v1/news/{id}.json — One story
• /api/v1/news/latest.json — The 25 newest stories, notifier fields only
• /api/v1/news/by-country/{country}.json — NO, SE, DK, FI, IS, NORDIC or EU
• /api/v1/news/by-topic/{topic}.json — One topic
• /api/v1/news/topics.json — Topic index

संबंध

• source → sources many-to-one — Outlet id in sources.json
• also_covered_by[].outlet → sources many-to-one — Other outlets on the same event
• id → title-i18n one-to-one — Our headlines, when we wrote them
• id → blurbs one-to-one — Front-page blurb, when one is written

फ़ाइल के फ़ील्ड

Story

Events

Calendar events. data/events.json is the working list, archive/events.json is what the public calendar keeps, and data/events_backfill.json is the previous-events backfill. sponsored is null, false, true, or the sponsor's name, and is never Kaupr. The calendar status upcoming, ongoing or past is computed from start and end and is not stored.

फ़ाइल data/events.json, archive/events.json, data/events_backfill.json · JSON Schema

पृष्ठ

• /calendar/
• /calendar/previous/

API

• /api/v1/events.json — Public events, soonest start first, including past events
• /api/v1/events/{id}.json — One event
• /api/v1/events/upcoming.json — Events that have not ended
• /api/v1/events/past.json — Finished public events
• /api/v1/events/previous.json — Finished calendar events plus the backfill
• /api/v1/events/by-country/{country}.json — One country

संबंध

• sponsored → sponsors many-to-one — Null, false, true, or the sponsor's name
• id → talks one-to-many — Talks recorded at this event
• id → event-descriptions one-to-one
• id → event-redirects one-to-one — A removed duplicate points at the kept id

फ़ाइल के फ़ील्ड

Event

Sources

News outlets and event sources in sources.json. type is how the fetcher reads the outlet. coverage is national, regional, local or justice. Kaupr is a news source and is never a sponsor.

फ़ाइल sources.json · JSON Schema

पृष्ठ

• /sources/

API

• /api/v1/sources.json — Outlets, search terms and event sources

संबंध

• id → news one-to-many — Stories that cite this outlet

फ़ाइल के फ़ील्ड

Outlet

Event source

Newsletters

Published issues in newsletter/published/issues.json. Drafts under newsletter/issues/ are not part of this schema. Subscriber addresses are a private store and are not in this file.

फ़ाइल newsletter/published/issues.json · JSON Schema

पृष्ठ

• /newsletter/

API

• /api/v1/newsletters.json — Published issues, without the HTML body
• /api/v1/newsletters/{id}.json — One issue, including text and HTML

फ़ाइल के फ़ील्ड

Issue

Sponsors

There is no sponsors file. A sponsor is the sponsored field on an event: null or false when there is no sponsor, true when it is sponsored without a named sponsor, or the sponsor's name. Kaupr is never a sponsor.

फ़ाइल — · JSON Schema

पृष्ठ

• /calendar/

API

• /api/v1/events.json — sponsored on each event

संबंध

• sponsored → events one-to-many — The event names its sponsor

Sponsor

Academia

Courses, student groups, publications and research groups in data/academia.json. The public page shows rows whose status is approved.

फ़ाइल data/academia.json · JSON Schema

पृष्ठ

• /academia/

API

• /api/v1/academia.json — All four sections
• /api/v1/academia/{section}.json — courses, groups, publications or research
• /api/v1/academia/{id}.json — One row

फ़ाइल के फ़ील्ड

Course

Student group

Publication

Research group

Books

Published books about bitcoin, crypto or blockchain by Nordic authors, or about the Nordic countries, in data/books.json. Titles stay in the original language. about is our one-line description in English.

फ़ाइल data/books.json · JSON Schema

पृष्ठ

• /books/

API

• /api/v1/books.json — Every book
• /api/v1/books/{id}.json — One book

फ़ाइल के फ़ील्ड

Book

Markets

Nordic exchange prices written at build time to /api/v1/markets.json. This is not a file in data/. Market data, not investment advice. quote is NOK, SEK, DKK or EUR. Nothing is converted between currencies.

फ़ाइल — · JSON Schema

पृष्ठ

• /markets/

API

• /api/v1/markets.json — All tickers and the aggregate
• /api/v1/markets/aggregated.json — One row per pair
• /api/v1/markets/{exchange}.json — firi, nbx or coinmotion
• /api/v1/markets/by-asset/{symbol}.json — One base asset, such as BTC
• /api/v1/markets/logos/{symbol}.svg — CC0 icon when the set includes the asset

फ़ाइल के फ़ील्ड

Ticker

Aggregate

Exchange

Profiles

Public profile links in data/profiles.json, keyed by who's who id. Each link needs a source_url that shows it belongs to that person or organisation. status published is what the site shows.

फ़ाइल data/profiles.json · JSON Schema

पृष्ठ

• /org-chart/

API

• /api/v1/profiles.json — Profiles taken from the published who's who
• /api/v1/profiles/{id}.json — One entity's links

संबंध

• entity id (object key) → orgchart many-to-one

फ़ाइल के फ़ील्ड

Link

Who's who

People and organisations in data/orgchart.json, the relations between them, and a short regulation note per country. status published is what the public page and the API show.

फ़ाइल data/orgchart.json · JSON Schema

पृष्ठ

• /org-chart/

API

• /api/v1/orgchart.json — Entities, relations and regulation
• /api/v1/orgchart/{id}.json — One entity
• /api/v1/relations.json — Relations only
• /api/v1/regulation.json — Regulation notes

संबंध

• relations[].from → orgchart many-to-one
• relations[].to → orgchart many-to-one
• entities[].talk_ids → talks many-to-many
• id → profiles one-to-many
• id → developers one-to-many — whoswho_id and org_id on a developer

फ़ाइल के फ़ील्ड

Entity

Relation

Regulation note

Talks

Public talks on bitcoin, cryptocurrencies and blockchain in the Nordic countries, in data/talks.json. description is ours. The other details come from the platform at source_url. A field the platform did not state is null.

फ़ाइल data/talks.json · JSON Schema

पृष्ठ

• /talks/

API

• /api/v1/talks.json — Every talk, newest first
• /api/v1/talks/{id}.json — One talk
• /api/v1/talks/by-country/{country}.json — NO, SE, DK, FI, IS, FO, GL or AX

संबंध

• event_id → events many-to-one — Null when the talk could not be dated or placed
• speaker_ids → orgchart many-to-many

फ़ाइल के फ़ील्ड

Talk

Developers

Open-source developers in data/developers.json. Only public professional information: no addresses and no private details. The public page shows status published.

फ़ाइल data/developers.json · JSON Schema

पृष्ठ

• /developers/

API

• /api/v1/developers.json — Published developers
• /api/v1/developers/{id}.json — One developer

संबंध

• org_id → orgchart many-to-one
• whoswho_id → orgchart many-to-one

फ़ाइल के फ़ील्ड

Developer

Illustrations

Licensed pictures that may be assigned to a story, in data/illustrations.json. kind is original, commons or official-press. A newspaper photograph is never stored here.

फ़ाइल data/illustrations.json · JSON Schema

पृष्ठ

• /media/

API

• /api/v1/illustrations.json — Picture records and the assignment rules

संबंध

• assign[].id → news many-to-many — Chosen from topics, then country

फ़ाइल के फ़ील्ड

Picture

Portraits

Portrait files for the who's who, keyed by entity id, in data/images.json. Each record names the file, the author and the licence.

फ़ाइल data/images.json · JSON Schema

पृष्ठ

• /org-chart/

API

• /api/v1/images.json — Portraits and logos published with the who's who

संबंध

• entity id (object key) → orgchart many-to-one

Portrait

Outlet logos

Outlet marks in assets/img/logos/logos.json, keyed by id. review ok is what the public API shows. A missing review counts as ok. pending is included only in a preview build. rejected is never shown. The marks are the publishers' trademarks, shown only to identify the source of a headline.

फ़ाइल assets/img/logos/logos.json · JSON Schema

API

• /api/v1/sources.json — logo and logo_url on each outlet
• /api/v1/news.json — source_logo and source_logo_url on each story

संबंध

• id (object key) → sources one-to-one

फ़ाइल के फ़ील्ड

Logo

Changelog

Site changes in changelog.json (new pages, sections and features, not the daily news). review pending keeps an entry off the public page until it has a date.

फ़ाइल changelog.json · JSON Schema

पृष्ठ

• /changelog/

API

• /api/v1/changelog.json — Public entries, newest first
• /api/v1/changelog/{id}.json — One entry

फ़ाइल के फ़ील्ड

Entry

Rules map

The regulation map behind /rules/, in rules.json. Every node points at a primary source. review approved is what the public page shows.

फ़ाइल rules.json · JSON Schema

पृष्ठ

• /rules/

API

• /api/v1/rules.json — The public rules document