# 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-11T09:55:38.056Z (11/03/2026, 10:55:38, 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-11T09:55:38.056Z",
    "availableLocales": [
      "de",
      "en",
      "fr",
      "es",
      "pt-br",
      "nl"
    ],
    "defaultLocale": "de",
    "sourceVersion": "availability-preview-v1",
    "currencyDefault": "EUR"
  },
  "items": [
    {
      "name": "Öffentliche Brauhaustour in der Altstadt (EN)",
      "productId": 23,
      "productTitle": "Öffentliche Brauhaustour in der Altstadt",
      "inLanguage": "en",
      "language": "en",
      "startDate": "2026-03-11T18:30:00+01:00",
      "endDate": "2026-03-11T21:00:00+01: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-20260311-1830-en-23",
      "availability": "available",
      "availableSpotsPublic": null,
      "availableSpotsDisclosure": "hidden",
      "maxPersonsPerBooking": 7,
      "durationMinutes": 150,
      "maxParticipants": 15,
      "price": {
        "amount": 20,
        "currency": "EUR"
      },
      "discount": {
        "name": "Last-Minute",
        "percent": 10,
        "kinds": [
          "last_minute"
        ],
        "originalAmount": 20,
        "discountedAmount": 18,
        "note": "Rabatt gilt auf den Tourpreis. Axtwerfen/Add-ons ausgeschlossen."
      },
      "location": "Heumarkt 39, 50667 Köln",
      "bookingCutoffAt": "2026-03-11T15:30:00.000Z",
      "bookingWindowRule": "without_booking_en_2h",
      "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 (EN)",
      "productId": 23,
      "productTitle": "Öffentliche Brauhaustour in der Altstadt",
      "inLanguage": "en",
      "language": "en",
      "startDate": "2026-03-12T18:30:00+01:00",
      "endDate": "2026-03-12T21:00:00+01: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-20260312-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-03-12T15:30:00.000Z",
      "bookingWindowRule": "without_booking_en_2h",
      "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-03-12T19:00:00+01:00",
      "endDate": "2026-03-12T21:30:00+01: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-20260312-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-03-11T18: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-03-13T15:30:00+01:00",
      "endDate": "2026-03-13T18:00:00+01: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-20260313-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-03-13T12:30:00.000Z",
      "bookingWindowRule": "without_booking_en_2h",
      "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-03-13T16:00:00+01:00",
      "endDate": "2026-03-13T18:30:00+01: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-20260313-1600-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-03-12T15: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-03-13T18:30:00+01:00",
      "endDate": "2026-03-13T21:00:00+01: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-20260313-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-03-13T15:30:00.000Z",
      "bookingWindowRule": "without_booking_en_2h",
      "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-03-13T19:00:00+01:00",
      "endDate": "2026-03-13T21:30:00+01: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-20260313-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-03-12T18: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-03-14T12:30:00+01:00",
      "endDate": "2026-03-14T15:00:00+01: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-20260314-1230-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-03-14T09:30:00.000Z",
      "bookingWindowRule": "without_booking_en_2h",
      "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-03-14T13:00:00+01:00",
      "endDate": "2026-03-14T15:30:00+01: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-20260314-1300-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-03-14T11:00:00.000Z",
      "bookingWindowRule": "with_booking_1h",
      "bookingsCount": 5,
      "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-03-14T15:30:00+01:00",
      "endDate": "2026-03-14T18:00:00+01: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-20260314-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-03-14T13:30:00.000Z",
      "bookingWindowRule": "with_booking_1h",
      "bookingsCount": 2,
      "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"
    }
  ]
}
END_SSR_JSON