# KölschCrew Tour Availability API

Canonical source for live availability: https://koelschcrew.de/availability
Feeds linked here: https://koelschcrew.de/api/events.json and https://koelschcrew.de/api/events.rss
German and English public tours are combined in the same feeds.
Each event instance includes explicit language labels (DE/EN).
Last updated: 2026-03-31T21:11:02.735Z (31/03/2026, 23:11:02, Europe/Berlin)
Data freshness policy: cached up to 10 minutes at the edge. For freshness checks, inspect generatedAt/dateModified.

## Live Data Feeds

- **Events JSON Feed**: https://koelschcrew.de/api/events.json
- **Events RSS Feed**: https://koelschcrew.de/api/events.rss

## Feed Features

### Date Filtering
```
https://koelschcrew.de/api/events.json?from=2026-02-19&to=2026-02-22&limit=120
```

### Larger Windows / More Results
```
https://koelschcrew.de/api/events.json?days=30&limit=600
https://koelschcrew.de/api/events.json?from=YYYY-MM-DD&to=YYYY-MM-DD&limit=1200
```

### Pretty JSON Format
Add `?pretty=1` query parameter or use header `Accept: application/json; indent=2`

### Discount Metadata
Feed includes discount information when applicable:
- `item.discount.name` - Campaign or discount name
- `item.discount.percent` - Discount percentage
- `item.discount.kinds` - Discount types applied
- `item.discount.originalAmount` - Original price
- `item.discount.discountedAmount` - Price after discount
- `item.discount.priceValidUntil` - Discount expiration timestamp

## Discovery Pages

- **Machine-oriented guide**: https://koelschcrew.de/availability

## Localization

**Canonical locales**: /de, /en, /fr, /es, /pt-br, /nl

**Example tour pages**:
- German: https://koelschcrew.de/de/tour/oeffentliche-touren
- English: https://koelschcrew.de/en/tour/public-tours

## Pricing Rules

### Last-Minute Discount
10% discount applies when:
- Tour start is within 12 hours
- At least one booking exists
- More than 7 spots are available

### Campaign Discount
Campaign discount inactive (configured end: n/a).


## SSR JSON Preview (Next 10 Upcoming Slots)

The JSON below is rendered server-side on each refresh window.
For more slots, use the Events JSON feed URLs above.

BEGIN_SSR_JSON
{
  "meta": {
    "generatedAt": "2026-03-31T21:11:02.735Z",
    "availableLocales": [
      "de",
      "en",
      "fr",
      "es",
      "pt-br",
      "nl"
    ],
    "defaultLocale": "de",
    "sourceVersion": "availability-preview-v1",
    "currencyDefault": "EUR"
  },
  "items": [
    {
      "name": "Kulinarische Brauhaustour Köln – Kölsch & Kölsche Küche (DE)",
      "productId": 351,
      "productTitle": "Kulinarische Brauhaustour Köln – Kölsch & Kölsche Küche",
      "inLanguage": "de",
      "language": "de",
      "startDate": "2026-04-01T16:00:00+02:00",
      "endDate": "2026-04-01T18:30:00+02:00",
      "url": "https://koelschcrew.de/de/tour/kulinarische-brauhaustour",
      "tourPageUrl": "https://koelschcrew.de/de/tour/kulinarische-brauhaustour",
      "bookingUrl": "https://koelschcrew.de/de/tour/kulinarische-brauhaustour#slot-20260401-1600-de-351",
      "availability": "available",
      "availableSpotsPublic": null,
      "availableSpotsDisclosure": "hidden",
      "maxPersonsPerBooking": 7,
      "durationMinutes": 180,
      "maxParticipants": 15,
      "price": {
        "amount": 95,
        "currency": "EUR"
      },
      "discount": {
        "name": "Launch Special",
        "percent": 10,
        "kinds": [
          "campaign"
        ],
        "originalAmount": 95,
        "discountedAmount": 85.5,
        "note": "Rabatt gilt bei Buchung innerhalb des Aktionszeitraums. Axtwerfen/Add-ons ausgeschlossen.",
        "priceValidUntil": "2026-03-31T23:59:00+02:00"
      },
      "location": "Vor dem Früh am Dom",
      "bookingCutoffAt": "2026-03-31T14:00:00.000Z",
      "bookingWindowRule": "without_booking_de_24h",
      "bookingsCount": 0,
      "isBookableNow": false,
      "cancellationNote": "Sorglos: kostenlose Stornierung bis 7 Tage vor Beginn; Umbuchung/Gutschein bis 24h vor Beginn kostenlos möglich; Sparfuchs: keine Erstattung möglich; Danach gelten folgende Stornogebühren:"
    },
    {
      "name": "Kulinarische Brauhaustour Köln – Kölsch & Kölsche Küche (EN)",
      "productId": 357,
      "productTitle": "Kulinarische Brauhaustour Köln – Kölsch & Kölsche Küche",
      "inLanguage": "en",
      "language": "en",
      "startDate": "2026-04-01T17:00:00+02:00",
      "endDate": "2026-04-01T19:30:00+02:00",
      "url": "https://koelschcrew.de/de/tour/kulinarische-brauhaustour",
      "tourPageUrl": "https://koelschcrew.de/de/tour/kulinarische-brauhaustour",
      "bookingUrl": "https://koelschcrew.de/de/tour/kulinarische-brauhaustour#slot-20260401-1700-en-357",
      "availability": "available",
      "availableSpotsPublic": null,
      "availableSpotsDisclosure": "hidden",
      "maxPersonsPerBooking": 7,
      "durationMinutes": 180,
      "maxParticipants": 15,
      "price": {
        "amount": 95,
        "currency": "EUR"
      },
      "discount": {
        "name": "Launch Special",
        "percent": 10,
        "kinds": [
          "campaign"
        ],
        "originalAmount": 95,
        "discountedAmount": 85.5,
        "note": "Rabatt gilt bei Buchung innerhalb des Aktionszeitraums. Axtwerfen/Add-ons ausgeschlossen.",
        "priceValidUntil": "2026-03-31T23:59:00+02:00"
      },
      "location": "Vor dem Früh am Dom",
      "bookingCutoffAt": "2026-03-28T15:00:00.000Z",
      "bookingWindowRule": "product_cutoff_no_bookings",
      "bookingsCount": 0,
      "isBookableNow": false,
      "cancellationNote": "Carefree: free cancellation up to 7 days before start; Rebooking/voucher free of charge up to 24h before start; Smart Saver: no refund possible; After that, the following cancellation fees apply:"
    },
    {
      "name": "Öffentliche Brauhaustour in der Altstadt (EN)",
      "productId": 23,
      "productTitle": "Öffentliche Brauhaustour in der Altstadt",
      "inLanguage": "en",
      "language": "en",
      "startDate": "2026-04-01T18:30:00+02:00",
      "endDate": "2026-04-01T21:00:00+02:00",
      "url": "https://koelschcrew.de/de/tour/oeffentliche-touren",
      "tourPageUrl": "https://koelschcrew.de/de/tour/oeffentliche-touren",
      "bookingUrl": "https://koelschcrew.de/de/tour/oeffentliche-touren#slot-20260401-1830-en-23",
      "availability": "available",
      "availableSpotsPublic": null,
      "availableSpotsDisclosure": "hidden",
      "maxPersonsPerBooking": 7,
      "durationMinutes": 150,
      "maxParticipants": 15,
      "price": {
        "amount": 20,
        "currency": "EUR"
      },
      "discount": null,
      "location": "Heumarkt 39, 50667 Köln",
      "bookingCutoffAt": "2026-04-01T14:30:00.000Z",
      "bookingWindowRule": "product_cutoff_no_bookings",
      "bookingsCount": 0,
      "isBookableNow": true,
      "cancellationNote": "Carefree: free cancellation up to 24 hours before start; Rebooking/voucher free of charge up to 24h before start; Smart Saver: no refund possible"
    },
    {
      "name": "Öffentliche Brauhaustour in der Altstadt (DE)",
      "productId": 3,
      "productTitle": "Öffentliche Brauhaustour in der Altstadt",
      "inLanguage": "de",
      "language": "de",
      "startDate": "2026-04-01T19:00:00+02:00",
      "endDate": "2026-04-01T21:30:00+02:00",
      "url": "https://koelschcrew.de/de/tour/oeffentliche-touren",
      "tourPageUrl": "https://koelschcrew.de/de/tour/oeffentliche-touren",
      "bookingUrl": "https://koelschcrew.de/de/tour/oeffentliche-touren#slot-20260401-1900-de-3",
      "availability": "available",
      "availableSpotsPublic": null,
      "availableSpotsDisclosure": "hidden",
      "maxPersonsPerBooking": 7,
      "durationMinutes": 150,
      "maxParticipants": 15,
      "price": {
        "amount": 20,
        "currency": "EUR"
      },
      "discount": null,
      "location": "Heumarkt 39, 50667 Köln",
      "bookingCutoffAt": "2026-04-01T16:00:00.000Z",
      "bookingWindowRule": "with_booking_1h",
      "bookingsCount": 2,
      "isBookableNow": true,
      "cancellationNote": "Sorglos: kostenlose Stornierung bis 24 Stunden vor Beginn; Umbuchung/Gutschein bis 24h vor Beginn kostenlos möglich; Sparfuchs: keine Erstattung möglich"
    },
    {
      "name": "Kulinarische Brauhaustour Köln – Kölsch & Kölsche Küche (DE)",
      "productId": 351,
      "productTitle": "Kulinarische Brauhaustour Köln – Kölsch & Kölsche Küche",
      "inLanguage": "de",
      "language": "de",
      "startDate": "2026-04-02T16:00:00+02:00",
      "endDate": "2026-04-02T18:30:00+02:00",
      "url": "https://koelschcrew.de/de/tour/kulinarische-brauhaustour",
      "tourPageUrl": "https://koelschcrew.de/de/tour/kulinarische-brauhaustour",
      "bookingUrl": "https://koelschcrew.de/de/tour/kulinarische-brauhaustour#slot-20260402-1600-de-351",
      "availability": "available",
      "availableSpotsPublic": null,
      "availableSpotsDisclosure": "hidden",
      "maxPersonsPerBooking": 7,
      "durationMinutes": 180,
      "maxParticipants": 15,
      "price": {
        "amount": 95,
        "currency": "EUR"
      },
      "discount": {
        "name": "Launch Special",
        "percent": 10,
        "kinds": [
          "campaign"
        ],
        "originalAmount": 95,
        "discountedAmount": 85.5,
        "note": "Rabatt gilt bei Buchung innerhalb des Aktionszeitraums. Axtwerfen/Add-ons ausgeschlossen.",
        "priceValidUntil": "2026-03-31T23:59:00+02:00"
      },
      "location": "Vor dem Früh am Dom",
      "bookingCutoffAt": "2026-04-01T14:00:00.000Z",
      "bookingWindowRule": "without_booking_de_24h",
      "bookingsCount": 0,
      "isBookableNow": true,
      "cancellationNote": "Sorglos: kostenlose Stornierung bis 7 Tage vor Beginn; Umbuchung/Gutschein bis 24h vor Beginn kostenlos möglich; Sparfuchs: keine Erstattung möglich; Danach gelten folgende Stornogebühren:"
    },
    {
      "name": "Kulinarische Brauhaustour Köln – Kölsch & Kölsche Küche (EN)",
      "productId": 357,
      "productTitle": "Kulinarische Brauhaustour Köln – Kölsch & Kölsche Küche",
      "inLanguage": "en",
      "language": "en",
      "startDate": "2026-04-02T17:00:00+02:00",
      "endDate": "2026-04-02T19:30:00+02:00",
      "url": "https://koelschcrew.de/de/tour/kulinarische-brauhaustour",
      "tourPageUrl": "https://koelschcrew.de/de/tour/kulinarische-brauhaustour",
      "bookingUrl": "https://koelschcrew.de/de/tour/kulinarische-brauhaustour#slot-20260402-1700-en-357",
      "availability": "available",
      "availableSpotsPublic": null,
      "availableSpotsDisclosure": "hidden",
      "maxPersonsPerBooking": 7,
      "durationMinutes": 180,
      "maxParticipants": 15,
      "price": {
        "amount": 95,
        "currency": "EUR"
      },
      "discount": {
        "name": "Launch Special",
        "percent": 10,
        "kinds": [
          "campaign"
        ],
        "originalAmount": 95,
        "discountedAmount": 85.5,
        "note": "Rabatt gilt bei Buchung innerhalb des Aktionszeitraums. Axtwerfen/Add-ons ausgeschlossen.",
        "priceValidUntil": "2026-03-31T23:59:00+02:00"
      },
      "location": "Vor dem Früh am Dom",
      "bookingCutoffAt": "2026-03-29T15:00:00.000Z",
      "bookingWindowRule": "product_cutoff_no_bookings",
      "bookingsCount": 0,
      "isBookableNow": false,
      "cancellationNote": "Carefree: free cancellation up to 7 days before start; Rebooking/voucher free of charge up to 24h before start; Smart Saver: no refund possible; After that, the following cancellation fees apply:"
    },
    {
      "name": "Öffentliche Brauhaustour in der Altstadt (EN)",
      "productId": 23,
      "productTitle": "Öffentliche Brauhaustour in der Altstadt",
      "inLanguage": "en",
      "language": "en",
      "startDate": "2026-04-02T18:30:00+02:00",
      "endDate": "2026-04-02T21:00:00+02:00",
      "url": "https://koelschcrew.de/de/tour/oeffentliche-touren",
      "tourPageUrl": "https://koelschcrew.de/de/tour/oeffentliche-touren",
      "bookingUrl": "https://koelschcrew.de/de/tour/oeffentliche-touren#slot-20260402-1830-en-23",
      "availability": "available",
      "availableSpotsPublic": null,
      "availableSpotsDisclosure": "hidden",
      "maxPersonsPerBooking": 7,
      "durationMinutes": 150,
      "maxParticipants": 15,
      "price": {
        "amount": 20,
        "currency": "EUR"
      },
      "discount": null,
      "location": "Heumarkt 39, 50667 Köln",
      "bookingCutoffAt": "2026-04-02T14:30:00.000Z",
      "bookingWindowRule": "product_cutoff_no_bookings",
      "bookingsCount": 0,
      "isBookableNow": true,
      "cancellationNote": "Carefree: free cancellation up to 24 hours before start; Rebooking/voucher free of charge up to 24h before start; Smart Saver: no refund possible"
    },
    {
      "name": "Öffentliche Brauhaustour in der Altstadt (DE)",
      "productId": 3,
      "productTitle": "Öffentliche Brauhaustour in der Altstadt",
      "inLanguage": "de",
      "language": "de",
      "startDate": "2026-04-02T19:00:00+02:00",
      "endDate": "2026-04-02T21:30:00+02:00",
      "url": "https://koelschcrew.de/de/tour/oeffentliche-touren",
      "tourPageUrl": "https://koelschcrew.de/de/tour/oeffentliche-touren",
      "bookingUrl": "https://koelschcrew.de/de/tour/oeffentliche-touren#slot-20260402-1900-de-3",
      "availability": "available",
      "availableSpotsPublic": null,
      "availableSpotsDisclosure": "hidden",
      "maxPersonsPerBooking": 7,
      "durationMinutes": 150,
      "maxParticipants": 15,
      "price": {
        "amount": 20,
        "currency": "EUR"
      },
      "discount": null,
      "location": "Heumarkt 39, 50667 Köln",
      "bookingCutoffAt": "2026-04-01T17:00:00.000Z",
      "bookingWindowRule": "without_booking_de_24h",
      "bookingsCount": 0,
      "isBookableNow": true,
      "cancellationNote": "Sorglos: kostenlose Stornierung bis 24 Stunden vor Beginn; Umbuchung/Gutschein bis 24h vor Beginn kostenlos möglich; Sparfuchs: keine Erstattung möglich"
    },
    {
      "name": "Öffentliche Brauhaustour in der Altstadt (EN)",
      "productId": 23,
      "productTitle": "Öffentliche Brauhaustour in der Altstadt",
      "inLanguage": "en",
      "language": "en",
      "startDate": "2026-04-03T15:30:00+02:00",
      "endDate": "2026-04-03T18:00:00+02:00",
      "url": "https://koelschcrew.de/de/tour/oeffentliche-touren",
      "tourPageUrl": "https://koelschcrew.de/de/tour/oeffentliche-touren",
      "bookingUrl": "https://koelschcrew.de/de/tour/oeffentliche-touren#slot-20260403-1530-en-23",
      "availability": "available",
      "availableSpotsPublic": null,
      "availableSpotsDisclosure": "hidden",
      "maxPersonsPerBooking": 7,
      "durationMinutes": 150,
      "maxParticipants": 15,
      "price": {
        "amount": 20,
        "currency": "EUR"
      },
      "discount": null,
      "location": "Heumarkt 39, 50667 Köln",
      "bookingCutoffAt": "2026-04-03T12:30:00.000Z",
      "bookingWindowRule": "product_cutoff_enough_bookings",
      "bookingsCount": 4,
      "isBookableNow": true,
      "cancellationNote": "Carefree: free cancellation up to 24 hours before start; Rebooking/voucher free of charge up to 24h before start; Smart Saver: no refund possible"
    },
    {
      "name": "Kulinarische Brauhaustour Köln – Kölsch & Kölsche Küche (DE)",
      "productId": 351,
      "productTitle": "Kulinarische Brauhaustour Köln – Kölsch & Kölsche Küche",
      "inLanguage": "de",
      "language": "de",
      "startDate": "2026-04-03T16:00:00+02:00",
      "endDate": "2026-04-03T18:30:00+02:00",
      "url": "https://koelschcrew.de/de/tour/kulinarische-brauhaustour",
      "tourPageUrl": "https://koelschcrew.de/de/tour/kulinarische-brauhaustour",
      "bookingUrl": "https://koelschcrew.de/de/tour/kulinarische-brauhaustour#slot-20260403-1600-de-351",
      "availability": "available",
      "availableSpotsPublic": null,
      "availableSpotsDisclosure": "hidden",
      "maxPersonsPerBooking": 7,
      "durationMinutes": 180,
      "maxParticipants": 15,
      "price": {
        "amount": 95,
        "currency": "EUR"
      },
      "discount": {
        "name": "Launch Special",
        "percent": 10,
        "kinds": [
          "campaign"
        ],
        "originalAmount": 95,
        "discountedAmount": 85.5,
        "note": "Rabatt gilt bei Buchung innerhalb des Aktionszeitraums. Axtwerfen/Add-ons ausgeschlossen.",
        "priceValidUntil": "2026-03-31T23:59:00+02:00"
      },
      "location": "Vor dem Früh am Dom",
      "bookingCutoffAt": "2026-04-02T14:00:00.000Z",
      "bookingWindowRule": "without_booking_de_24h",
      "bookingsCount": 0,
      "isBookableNow": true,
      "cancellationNote": "Sorglos: kostenlose Stornierung bis 7 Tage vor Beginn; Umbuchung/Gutschein bis 24h vor Beginn kostenlos möglich; Sparfuchs: keine Erstattung möglich; Danach gelten folgende Stornogebühren:"
    }
  ]
}
END_SSR_JSON