{"id":"e1a6ad7f-3ce5-449c-a54f-20ef70f82c0b","type":"DATASET","name":"Berlin and Brandenburg Christmas Markets","slug":"berlin-and-brandenburg-christmas-markets","description":"Christmas markets in Berlin.","free_access_class":"FREE_NO_AUTH","auth_type":"NONE","homepage_url":null,"docs_url":null,"repo_url":"https://www.berlin.de/sen/web/service/maerkte-feste/weihnachtsmaerkte/index.php/index/all.xls?q=","status":"ACTIVE","verification_state":"VERIFIED","tags":["culture"],"logo_url":"https://www.google.com/s2/favicons?sz=64&domain=berlin.de","primary_source_url":"https://www.berlin.de/sen/web/service/maerkte-feste/weihnachtsmaerkte/index.php/index/all.xls?q=","extraction_confidence":"0.16","created_at":"2026-06-28T11:16:00.674Z","updated_at":"2026-08-16T00:18:36.537Z","last_verified_at":"2026-08-16T00:18:36.537Z","deprecated_at":null,"ranking_score":56,"last_ranked_at":"2026-08-10T16:44:06.984Z","last_seen_at":null,"last_validated_at":null,"last_uptime_at":"2026-08-04T07:18:33.502Z","search_vector":"'a':63B 'and':55A,70B,93B 'are':99B 'attribut':39B 'attributes':92B 'avail':51B 'available':104B 'basic':22B,75B 'berlin':1A,9B,16B,54A,62B,69B 'brandenburg':3A,18B,56A,71B 'christma':4A,6B,13B 'christmas':57A,59B,66B 'cultur':30B,53C 'cultural':83B 'dataset':11B,45B,64B,98B 'detail':48B 'detailed':101B 'for':82B 'frequenc':42B 'frequency':95B 'germani':19B 'germany':72B 'in':61B,68B,102B 'inform':23B 'information':76B 'it':73B 'like':27B 'likely':80B 'list':12B 'listing':65B 'locat':26B 'locations':79B 'market':5A,7B,14B,25B,78B 'markets':58A,60B,67B 'metadata':52B,105B 'not':100B 'of':96B 'on':77B 'or':84B 'provid':21B 'provides':74B 'purpos':35B 'purposes':88B 'relat':34B 'related':87B 'specif':38B 'specific':91B 'the':90B,97B,103B 'though':36B,89B 'tourism':33B,86B 'tourism-rel':32B 'tourism-related':85B 'updat':41B 'update':94B 'use':28B 'useful':81B","popularity_score":"0.0000","maintenance_score":"0.7000","institution_id":"9b80e8c7-91fe-4282-868f-ecbb510cb44f","institution_type":"MUNICIPALITY","country_code":"DE","official_confidence":null,"proof_summary":null,"source_seed_url":null,"is_public_sector":true,"published_at":"2026-06-29T08:44:46.843Z","geographic_scope":"NATIONAL","name_en":null,"description_en":"A dataset listing Christmas markets in Berlin and Brandenburg, Germany. It provides basic information on market locations, likely useful for cultural or tourism-related purposes, though the specific attributes and update frequency of the dataset are not detailed in the available metadata.","native_lang":"en","access_level":"direct","formats":["XLSX"],"capability_tier":"sample","trust_score":34.94230769230769,"access":{"level":"direct","primary":{"kind":"download","label":"Download XLSX","method":"GET","url":"https://www.berlin.de/sen/web/service/maerkte-feste/weihnachtsmaerkte/index.php/index/all.xls?q=","format":"XLSX","byte_size":"9249","source":"distribution","runnable":true},"actions":[{"kind":"download","label":"Download XLSX","method":"GET","url":"https://www.berlin.de/sen/web/service/maerkte-feste/weihnachtsmaerkte/index.php/index/all.xls?q=","format":"XLSX","byte_size":"9249","source":"distribution","runnable":true}],"formats":["XLSX"]},"maturity":{"entry_id":"e1a6ad7f-3ce5-449c-a54f-20ef70f82c0b","granularity":"entry","granularity_label":"One unit = one catalog entry. A PROXY for the SCOPE.md §4 ladder, which governs source families, not entries: a family with 400 entries moves this reading 400 times as much as a family with one. Never compare or combine with the source_family reading.","level":"profiled","level_index":3,"level_label":"Profiled","meaning":"Schema, dimensions and licence understood","counts_as_coverage":false,"blocked_by":null,"rungs":[{"level":"discovered","level_index":1,"label":"Discovered","meaning":"Source and metadata recorded","evidence":"membership of the named population the ladder is taken over","counts_as_coverage":false,"met":true,"reached":true,"criterion":"TRUE"},{"level":"verified","level_index":2,"label":"Verified","meaning":"Access tested successfully","evidence":"entries.verification_state = 'VERIFIED'","counts_as_coverage":false,"met":true,"reached":true,"criterion":"entries.verification_state = 'VERIFIED'"},{"level":"profiled","level_index":3,"label":"Profiled","meaning":"Schema, dimensions and licence understood","evidence":"a data profile with at least one field (entry_data_profiles.field_count > 0)","counts_as_coverage":false,"met":true,"reached":true,"criterion":"EXISTS (SELECT 1 FROM entry_data_profiles p WHERE p.entry_id = entries.id AND COALESCE(p.field_count, 0) > 0)"},{"level":"executable","level_index":4,"label":"Executable","meaning":"Queries run through Commodity","evidence":"entries.capability_tier = 'live' — today's proxy for \"queryable through us\"","counts_as_coverage":true,"met":false,"reached":false,"criterion":"entries.capability_tier = 'live'"},{"level":"joinable","level_index":5,"label":"Joinable","meaning":"Canonical identifiers and concepts mapped","evidence":"a field link to a canonical identifier whose sampled VALUES match its format","counts_as_coverage":true,"met":false,"reached":false,"criterion":"EXISTS (SELECT 1 FROM entry_field_links efl WHERE efl.entry_id = entries.id AND efl.identifier_id IS NOT NULL AND efl.value_status = 'match')"},{"level":"reproducible","level_index":6,"label":"Reproducible","meaning":"Snapshots and transformation evidence retained","evidence":"at least one retained evidence manifest (migration 078)","counts_as_coverage":true,"met":false,"reached":false,"criterion":"EXISTS (SELECT 1 FROM evidence_manifests em WHERE em.entry_id = entries.id)"},{"level":"guaranteed","level_index":7,"label":"Guaranteed","meaning":"Monitored against an operational reliability target","evidence":"an active reliability target with a named monitor (migration 096)","counts_as_coverage":true,"met":false,"reached":false,"criterion":"EXISTS (SELECT 1 FROM entry_reliability_targets rt WHERE rt.entry_id = entries.id AND rt.is_active = true)"}],"officialness":{"basis":"catalog_inherited","label":"Inherited from the upstream catalog: this item came from a trusted official government catalog, and that provenance — not per-item proof — is the warrant. Its own proof score is below 80 or it matched no registered institution (apps/worker/src/connectors/catalog/qualify-store.ts).","proof_confidence":null,"proven_threshold":80,"institution_id":"9b80e8c7-91fe-4282-868f-ecbb510cb44f","definition":"CASE WHEN COALESCE(entries.is_public_sector, false) IS NOT TRUE THEN 'not_official' WHEN COALESCE(entries.official_confidence, 0) >= 80 AND entries.institution_id IS NOT NULL THEN 'per_item_proven' ELSE 'catalog_inherited' END"},"source_family":{"key":"www.berlin.de","label":"One unit = one source family, approximated by the serving host of the entry's primary source URL (e.g. bdl.stat.gov.pl). A COMPUTED stand-in for the curated families of SCOPE.md §5, which no table holds yet. A family sits at the highest level any of its entries has reached, because a family is integrated to the depth of its deepest working integration. Never compare or combine with the entry reading."},"generated_at":"2026-08-16T13:55:58.646Z"},"api_details":null,"dataset_details":{"id":"d9d8ed89-3634-44f2-b8b4-bc8c1dc515a5","entry_id":"e1a6ad7f-3ce5-449c-a54f-20ef70f82c0b","upstream_issued":null,"upstream_modified":null,"themes":[],"update_frequency":null,"temporal_start":null,"temporal_end":null,"spatial_coverage":null,"landing_page":null,"license_id":null,"license_raw":null,"has_documentation":false,"has_data_dictionary":false,"has_versioning":false,"source_portal":null,"source_portal_url":null,"created_at":"2026-07-20T11:03:15.274Z","updated_at":"2026-07-20T11:03:15.274Z","publisher":null,"publisher_url":null,"distributions":[{"id":"d8881ecb-8f47-436f-bb94-b6e37d1947fa","dataset_details_id":"d9d8ed89-3634-44f2-b8b4-bc8c1dc515a5","title":"all.xls","description":null,"access_url":"https://www.berlin.de/sen/web/service/maerkte-feste/weihnachtsmaerkte/index.php/index/all.xls?q=","download_url":"https://www.berlin.de/sen/web/service/maerkte-feste/weihnachtsmaerkte/index.php/index/all.xls?q=","media_type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","format":"xlsx","byte_size":"9249","license_id":null,"license_raw":null,"last_checked_at":"2026-08-16T00:18:35.095Z","is_available":true,"last_http_status":200,"created_at":"2026-07-20T11:03:15.677Z","updated_at":"2026-08-16T00:18:35.095Z"}],"license":null},"license":null,"reuse":{"license_id":null,"license_name":null,"license_url":null,"commercial_use":{"status":"unknown","value":null},"redistribution":{"status":"unknown","value":null},"attribution_required":{"status":"unknown","value":null},"share_alike":{"status":"unknown","value":null},"personal_data_warning":{"status":"unknown","value":null},"cache_and_mirror":{"status":"unknown","value":null},"undetermined":["commercial_use","redistribution","attribution_required","share_alike","personal_data_warning","cache_and_mirror"],"basis":"unverified","confidence":0.1,"confidence_tier":"low","source_text":null,"source_url":null,"reviewed_at":null},"license_raw":null,"latest_check":{"id":"853b1498-d8f1-4797-96d8-6158a62b7a94","entry_id":"e1a6ad7f-3ce5-449c-a54f-20ef70f82c0b","status":"VERIFIED","last_checked_at":"2026-08-16T00:18:36.297Z","p50_latency_ms":2750,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-06-28T11:17:35.525Z","updated_at":"2026-08-16T00:18:36.297Z","consecutive_successes":2,"probe_url":"https://www.berlin.de/sen/web/service/maerkte-feste/weihnachtsmaerkte/index.php/index/all.xls?q=","probe_method":"GET","probe_http_status":200,"probe_content_type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","probe_succeeded_at":"2026-08-16T00:18:36.297Z"},"data_profile":{"id":"827920e8-4ce5-4eba-b179-4495c36b64b7","entry_id":"e1a6ad7f-3ce5-449c-a54f-20ef70f82c0b","profile_source":"excel","profile_kind":"dataset","dataset_id":null,"fields":[{"name":"Bezirk / Ort","type":"text","label":null,"filterable":false,"description":null,"description_en":"Berlin district or location of the Christmas market."},{"name":"Marktname","type":"text","label":null,"filterable":false,"description":null,"description_en":"Name of the Christmas market."},{"name":"Beginn","type":"text","label":null,"filterable":false,"description":null,"description_en":"Start date of the Christmas market."},{"name":"Ende","type":"text","label":null,"filterable":false,"description":null,"description_en":"End date of the Christmas market."},{"name":"Öffnungszeiten","type":"text","label":null,"filterable":false,"description":null,"description_en":"Opening dates or hours of the Christmas market."}],"field_count":5,"sample_records":[{"Ende":null,"Beginn":null,"Marktname":"Winter am THF","Bezirk / Ort":"Tempelhof-Schöneberg","Öffnungszeiten":"05.12.2025 bis 07.12.2025\n\n12.12.2025 bis 14.12.2025"},{"Ende":"31.12.2025","Beginn":"01.11.2025","Marktname":"Weihnachtsmarkt Verkauf von Trüffel Pasta, Dessert","Bezirk / Ort":"Lichtenberg, Mitte, Charlottenburg-Wilmersdorf","Öffnungszeiten":"11:00 bis 23:00 Uhr"},{"Ende":"23.12.2025","Beginn":"05.11.2025","Marktname":"LGBT*Winterdays und Christmas Avenue Nollendorfplatz","Bezirk / Ort":"Tempelhof-Schöneberg","Öffnungszeiten":"LGBTQIA* Winterdays:"},{"Ende":"07.12.2025 \n14.12.2025","Beginn":"05.12.2025 \n12.12.2025","Marktname":"30. Weihnachtsmarkt auf Lehmanns Bauernhof","Bezirk / Ort":"Tempelhof-Schöneberg","Öffnungszeiten":"Freitag: 14 - 20 Uhr \nSamstag: 12 - 20 Uhr \nSonntag: 12 - 20 Uhr"},{"Ende":null,"Beginn":"06.12.2025","Marktname":"Osram-Höfe Holiday Market","Bezirk / Ort":"Wedding","Öffnungszeiten":"12:00 - 18:00 Uhr"}],"record_count":null,"data_size_bytes":null,"dataset_count":null,"query_examples":null,"status":"partial","error_message":null,"profiled_at":"2026-07-27T11:20:43.135Z","run_id":"102b862c-2212-454a-92f2-8079831d255b","created_at":"2026-07-20T11:03:15.140Z","updated_at":"2026-08-05T06:17:07.354Z","license_raw":null,"license_id":null,"consecutive_failure_count":0,"last_error_at":null,"last_error_message":null,"previewable":true},"datasets":[],"limits":[]}