{"service":"leaguesync-api","version":"0.20260423.1","auth":{"type":"bearer","header":"Authorization: Bearer <token>","how_to_get_token":"Configured at deploy time; ask the operator."},"endpoints":{"/":{"auth":false,"description":"This document — schema, examples, auth instructions."},"/query":{"auth":true,"methods":["POST","GET"],"description":"Execute a read-only SQL SELECT query."},"/schedules/{service_id}":{"auth":false,"methods":["GET"],"description":"Weekday-grouped schedule for a Pike13 service."},"/services/{service_id}":{"auth":false,"methods":["GET"],"description":"Service metadata with upcoming events and occurrences."},"/meetups":{"auth":false,"methods":["GET"],"description":"Meetup events between from_date and to_date (required ISO-8601 query params), sorted by date_time ascending.","params":{"from_date":"ISO-8601 date (required)","to_date":"ISO-8601 date (required)"}},"/docs":{"auth":false,"description":"FastAPI OpenAPI / Swagger UI."}},"query":{"request":"POST JSON {\"sql\": \"...\", \"params\": [...]} or GET ?sql=...","accept_header":{"application/json (default)":"Array of row objects.","text/csv":"CSV with header row."},"content_encoding":"Automatic gzip when Accept-Encoding: gzip is sent.","restrictions":["Read-only — any write attempt returns 400/403.","Statement must begin with SELECT or WITH.","Single statement only — semicolons rejected."]},"schema":{"locations":[{"name":"id","type":"INTEGER","pk":true},{"name":"name","type":"VARCHAR","pk":false},{"name":"address","type":"VARCHAR","pk":false},{"name":"latitude","type":"FLOAT","pk":false},{"name":"longitude","type":"FLOAT","pk":false},{"name":"phone","type":"VARCHAR","pk":false},{"name":"description","type":"VARCHAR","pk":false},{"name":"show_in_client_mode","type":"BOOLEAN","pk":false},{"name":"slug","type":"VARCHAR","pk":false},{"name":"timezone_friendly","type":"VARCHAR","pk":false},{"name":"timezone","type":"VARCHAR","pk":false},{"name":"position","type":"INTEGER","pk":false},{"name":"formatted_address","type":"VARCHAR","pk":false},{"name":"street_address","type":"VARCHAR","pk":false},{"name":"street_address2","type":"VARCHAR","pk":false},{"name":"city","type":"VARCHAR","pk":false},{"name":"state_code","type":"VARCHAR","pk":false},{"name":"postal_code","type":"VARCHAR","pk":false},{"name":"country_code","type":"VARCHAR","pk":false},{"name":"hidden_at","type":"VARCHAR","pk":false},{"name":"deleted_at","type":"VARCHAR","pk":false},{"name":"code","type":"VARCHAR","pk":false},{"name":"is_stub","type":"BOOLEAN","pk":false},{"name":"data","type":"VARCHAR","pk":false}],"service_categories":[{"name":"id","type":"INTEGER","pk":true},{"name":"name","type":"VARCHAR","pk":false},{"name":"position","type":"INTEGER","pk":false},{"name":"description","type":"VARCHAR","pk":false},{"name":"description_short","type":"VARCHAR","pk":false},{"name":"deleted_at","type":"VARCHAR","pk":false},{"name":"is_stub","type":"BOOLEAN","pk":false},{"name":"data","type":"VARCHAR","pk":false}],"staff_members":[{"name":"id","type":"INTEGER","pk":true},{"name":"name","type":"VARCHAR","pk":false},{"name":"first_name","type":"VARCHAR","pk":false},{"name":"middle_name","type":"VARCHAR","pk":false},{"name":"last_name","type":"VARCHAR","pk":false},{"name":"phone","type":"VARCHAR","pk":false},{"name":"email","type":"VARCHAR","pk":false},{"name":"role","type":"VARCHAR","pk":false},{"name":"location_id","type":"INTEGER","pk":false},{"name":"bio","type":"VARCHAR","pk":false},{"name":"commissionable","type":"BOOLEAN","pk":false},{"name":"deleted_at","type":"VARCHAR","pk":false},{"name":"hidden_at","type":"VARCHAR","pk":false},{"name":"profile_photo","type":"VARCHAR","pk":false},{"name":"custom_fields","type":"VARCHAR","pk":false},{"name":"is_stub","type":"BOOLEAN","pk":false},{"name":"data","type":"VARCHAR","pk":false}],"business":[{"name":"id","type":"INTEGER","pk":true},{"name":"name","type":"VARCHAR","pk":false},{"name":"subdomain","type":"VARCHAR","pk":false},{"name":"default_locale","type":"VARCHAR","pk":false},{"name":"currency_code","type":"VARCHAR","pk":false},{"name":"website","type":"VARCHAR","pk":false},{"name":"phone","type":"VARCHAR","pk":false},{"name":"twitter","type":"VARCHAR","pk":false},{"name":"facebook","type":"VARCHAR","pk":false},{"name":"instagram","type":"VARCHAR","pk":false},{"name":"is_franchise","type":"BOOLEAN","pk":false},{"name":"age_of_majority","type":"INTEGER","pk":false},{"name":"is_active","type":"BOOLEAN","pk":false},{"name":"is_in_trial","type":"BOOLEAN","pk":false},{"name":"is_suspended","type":"BOOLEAN","pk":false},{"name":"client_app","type":"BOOLEAN","pk":false},{"name":"stripe_connect_account_id","type":"VARCHAR","pk":false},{"name":"email_address","type":"VARCHAR","pk":false},{"name":"timezone","type":"VARCHAR","pk":false},{"name":"created_at","type":"VARCHAR","pk":false},{"name":"updated_at","type":"VARCHAR","pk":false},{"name":"data","type":"VARCHAR","pk":false}],"custom_fields":[{"name":"id","type":"INTEGER","pk":true},{"name":"name","type":"VARCHAR","pk":false},{"name":"why","type":"VARCHAR","pk":false},{"name":"data_type","type":"VARCHAR","pk":false},{"name":"multi_select","type":"BOOLEAN","pk":false},{"name":"deleted_at","type":"VARCHAR","pk":false},{"name":"custom_field_settings","type":"VARCHAR","pk":false},{"name":"custom_field_options","type":"VARCHAR","pk":false},{"name":"data","type":"VARCHAR","pk":false}],"r_event_occurrences":[{"name":"event_occurrence_id","type":"INTEGER","pk":true},{"name":"attendance_completed","type":"BOOLEAN","pk":false},{"name":"business_id","type":"INTEGER","pk":false},{"name":"business_name","type":"VARCHAR","pk":false},{"name":"business_subdomain","type":"VARCHAR","pk":false},{"name":"capacity","type":"INTEGER","pk":false},{"name":"completed_enrollment_count","type":"INTEGER","pk":false},{"name":"completed_unpaid_count","type":"INTEGER","pk":false},{"name":"currency_code","type":"VARCHAR","pk":false},{"name":"duration_in_hours","type":"FLOAT","pk":false},{"name":"duration_in_minutes","type":"INTEGER","pk":false},{"name":"end_at","type":"VARCHAR","pk":false},{"name":"enrollment_count","type":"INTEGER","pk":false},{"name":"event_id","type":"INTEGER","pk":false},{"name":"event_name","type":"VARCHAR","pk":false},{"name":"expired_enrollment_count","type":"INTEGER","pk":false},{"name":"franchise_id","type":"INTEGER","pk":false},{"name":"instructor_names","type":"VARCHAR","pk":false},{"name":"is_waitlist_count","type":"INTEGER","pk":false},{"name":"key","type":"VARCHAR","pk":false},{"name":"late_canceled_enrollment_count","type":"INTEGER","pk":false},{"name":"noshowed_enrollment_count","type":"INTEGER","pk":false},{"name":"paid_count","type":"INTEGER","pk":false},{"name":"registered_enrollment_count","type":"INTEGER","pk":false},{"name":"removed_enrollment_count","type":"INTEGER","pk":false},{"name":"reserved_enrollment_count","type":"INTEGER","pk":false},{"name":"service_category","type":"VARCHAR","pk":false},{"name":"service_date","type":"VARCHAR","pk":false},{"name":"service_day","type":"VARCHAR","pk":false},{"name":"service_id","type":"INTEGER","pk":false},{"name":"service_location_id","type":"INTEGER","pk":false},{"name":"service_location_name","type":"VARCHAR","pk":false},{"name":"service_name","type":"VARCHAR","pk":false},{"name":"service_state","type":"VARCHAR","pk":false},{"name":"service_time","type":"VARCHAR","pk":false},{"name":"service_type","type":"VARCHAR","pk":false},{"name":"start_at","type":"VARCHAR","pk":false},{"name":"visit_count","type":"INTEGER","pk":false},{"name":"waiting_enrollment_count","type":"INTEGER","pk":false},{"name":"waitlist_to_visit_count","type":"INTEGER","pk":false}],"r_enrollments":[{"name":"visit_id","type":"INTEGER","pk":true},{"name":"registered_at","type":"VARCHAR","pk":false},{"name":"service_name","type":"VARCHAR","pk":false},{"name":"bulk_enrolled","type":"BOOLEAN","pk":false},{"name":"event_name","type":"VARCHAR","pk":false},{"name":"full_name","type":"VARCHAR","pk":false},{"name":"state","type":"VARCHAR","pk":false},{"name":"cancelled_at","type":"VARCHAR","pk":false},{"name":"client_booked","type":"BOOLEAN","pk":false},{"name":"email","type":"VARCHAR","pk":false},{"name":"first_visit","type":"BOOLEAN","pk":false},{"name":"service_id","type":"INTEGER","pk":false},{"name":"event_id","type":"INTEGER","pk":false},{"name":"event_occurrence_id","type":"INTEGER","pk":false},{"name":"person_id","type":"INTEGER","pk":false},{"name":"plan_id","type":"INTEGER","pk":false},{"name":"plan_product_id","type":"INTEGER","pk":false},{"name":"punch_id","type":"INTEGER","pk":false},{"name":"key","type":"VARCHAR","pk":false}],"r_person_plans":[{"name":"person_plan_id","type":"INTEGER","pk":true},{"name":"key","type":"VARCHAR","pk":false},{"name":"full_name","type":"VARCHAR","pk":false},{"name":"plan_name","type":"VARCHAR","pk":false},{"name":"plan_type","type":"VARCHAR","pk":false},{"name":"base_price","type":"FLOAT","pk":false},{"name":"is_available","type":"BOOLEAN","pk":false},{"name":"is_on_hold","type":"BOOLEAN","pk":false},{"name":"is_canceled","type":"BOOLEAN","pk":false},{"name":"start_date","type":"VARCHAR","pk":false},{"name":"end_date","type":"VARCHAR","pk":false},{"name":"first_visit_date","type":"VARCHAR","pk":false},{"name":"last_visit_date","type":"VARCHAR","pk":false},{"name":"canceled_at","type":"VARCHAR","pk":false},{"name":"completed_visit_count","type":"INTEGER","pk":false},{"name":"is_complimentary_pass","type":"BOOLEAN","pk":false},{"name":"plan_id","type":"INTEGER","pk":false},{"name":"next_plan_id","type":"INTEGER","pk":false},{"name":"next_plan_name","type":"VARCHAR","pk":false},{"name":"person_id","type":"INTEGER","pk":false},{"name":"plan_product_id","type":"INTEGER","pk":false},{"name":"product_name","type":"VARCHAR","pk":false},{"name":"product_id","type":"INTEGER","pk":false}],"r_staff":[{"name":"id","type":"INTEGER","pk":true},{"name":"full_name","type":"VARCHAR","pk":false},{"name":"first_name","type":"VARCHAR","pk":false},{"name":"last_name","type":"VARCHAR","pk":false},{"name":"email","type":"VARCHAR","pk":false},{"name":"person_state","type":"VARCHAR","pk":false},{"name":"role","type":"VARCHAR","pk":false},{"name":"tenure","type":"INTEGER","pk":false},{"name":"past_events","type":"INTEGER","pk":false}],"kv":[{"name":"key","type":"VARCHAR","pk":true},{"name":"value","type":"VARCHAR","pk":false},{"name":"updated_at","type":"VARCHAR","pk":false}],"sync_log":[{"name":"id","type":"INTEGER","pk":true},{"name":"object_type","type":"VARCHAR","pk":false},{"name":"started_at","type":"VARCHAR","pk":false},{"name":"finished_at","type":"VARCHAR","pk":false},{"name":"rows_upserted","type":"INTEGER","pk":false},{"name":"rows_deleted","type":"INTEGER","pk":false},{"name":"error","type":"VARCHAR","pk":false}],"services":[{"name":"id","type":"INTEGER","pk":true},{"name":"name","type":"VARCHAR","pk":false},{"name":"service_type","type":"VARCHAR","pk":false},{"name":"position","type":"INTEGER","pk":false},{"name":"category_id","type":"INTEGER","pk":false},{"name":"category_name","type":"VARCHAR","pk":false},{"name":"description","type":"VARCHAR","pk":false},{"name":"description_short","type":"VARCHAR","pk":false},{"name":"instructions","type":"VARCHAR","pk":false},{"name":"anonymous_staff","type":"BOOLEAN","pk":false},{"name":"duration_in_minutes","type":"INTEGER","pk":false},{"name":"snap_duration_in_minutes","type":"INTEGER","pk":false},{"name":"setup_duration_in_minutes","type":"INTEGER","pk":false},{"name":"cleanup_duration_in_minutes","type":"INTEGER","pk":false},{"name":"enrollment_window_start_minutes","type":"INTEGER","pk":false},{"name":"enrollment_window_end_minutes","type":"INTEGER","pk":false},{"name":"enrollment_window_blackout_minutes","type":"INTEGER","pk":false},{"name":"free_cancellation_window_in_hours","type":"INTEGER","pk":false},{"name":"visitors_can_view","type":"BOOLEAN","pk":false},{"name":"clients_can_view","type":"BOOLEAN","pk":false},{"name":"clients_can_book","type":"BOOLEAN","pk":false},{"name":"members_can_book","type":"BOOLEAN","pk":false},{"name":"members_can_view","type":"BOOLEAN","pk":false},{"name":"maximum_clients","type":"INTEGER","pk":false},{"name":"show_capacity_to_clients","type":"BOOLEAN","pk":false},{"name":"show_capacity_with_spaces_remain","type":"BOOLEAN","pk":false},{"name":"show_capacity_threshold","type":"INTEGER","pk":false},{"name":"show_rooms_to_clients","type":"BOOLEAN","pk":false},{"name":"calendar_color","type":"INTEGER","pk":false},{"name":"allow_tips","type":"BOOLEAN","pk":false},{"name":"require_cc","type":"BOOLEAN","pk":false},{"name":"require_plan","type":"BOOLEAN","pk":false},{"name":"no_merchandise_price","type":"BOOLEAN","pk":false},{"name":"supports_single_payer","type":"BOOLEAN","pk":false},{"name":"hidden_at","type":"VARCHAR","pk":false},{"name":"pricing","type":"VARCHAR","pk":false},{"name":"cancellation","type":"VARCHAR","pk":false},{"name":"make_up_policy","type":"VARCHAR","pk":false},{"name":"waitlist_settings","type":"VARCHAR","pk":false},{"name":"deleted_at","type":"VARCHAR","pk":false},{"name":"is_stub","type":"BOOLEAN","pk":false},{"name":"data","type":"VARCHAR","pk":false}],"staff_custom_fields":[{"name":"id","type":"INTEGER","pk":true},{"name":"staff_id","type":"INTEGER","pk":false},{"name":"custom_field_id","type":"INTEGER","pk":false},{"name":"name","type":"VARCHAR","pk":false},{"name":"value","type":"VARCHAR","pk":false}],"people":[{"name":"id","type":"INTEGER","pk":true},{"name":"name","type":"VARCHAR","pk":false},{"name":"first_name","type":"VARCHAR","pk":false},{"name":"last_name","type":"VARCHAR","pk":false},{"name":"middle_name","type":"VARCHAR","pk":false},{"name":"email","type":"VARCHAR","pk":false},{"name":"phone","type":"VARCHAR","pk":false},{"name":"address","type":"VARCHAR","pk":false},{"name":"street_address","type":"VARCHAR","pk":false},{"name":"street_address2","type":"VARCHAR","pk":false},{"name":"city","type":"VARCHAR","pk":false},{"name":"state_code","type":"VARCHAR","pk":false},{"name":"postal_code","type":"VARCHAR","pk":false},{"name":"country_code","type":"VARCHAR","pk":false},{"name":"is_member","type":"BOOLEAN","pk":false},{"name":"membership","type":"VARCHAR","pk":false},{"name":"joined_at","type":"VARCHAR","pk":false},{"name":"updated_at","type":"VARCHAR","pk":false},{"name":"deleted_at","type":"VARCHAR","pk":false},{"name":"hidden_at","type":"VARCHAR","pk":false},{"name":"birthdate","type":"VARCHAR","pk":false},{"name":"state","type":"VARCHAR","pk":false},{"name":"pronoun","type":"VARCHAR","pk":false},{"name":"guardian_name","type":"VARCHAR","pk":false},{"name":"guardian_email","type":"VARCHAR","pk":false},{"name":"secondary_info_field","type":"VARCHAR","pk":false},{"name":"waiver_signed","type":"BOOLEAN","pk":false},{"name":"business_id","type":"INTEGER","pk":false},{"name":"location_id","type":"INTEGER","pk":false},{"name":"timezone","type":"VARCHAR","pk":false},{"name":"custom_fields","type":"VARCHAR","pk":false},{"name":"dependents","type":"VARCHAR","pk":false},{"name":"providers","type":"VARCHAR","pk":false},{"name":"profile_photo","type":"VARCHAR","pk":false},{"name":"location","type":"VARCHAR","pk":false},{"name":"balances","type":"VARCHAR","pk":false},{"name":"is_stub","type":"BOOLEAN","pk":false},{"name":"data","type":"VARCHAR","pk":false}],"person_custom_fields":[{"name":"id","type":"INTEGER","pk":true},{"name":"person_id","type":"INTEGER","pk":false},{"name":"custom_field_id","type":"INTEGER","pk":false},{"name":"name","type":"VARCHAR","pk":false},{"name":"value","type":"VARCHAR","pk":false}],"person_dependency":[{"name":"parent_person_id","type":"INTEGER","pk":true},{"name":"dependent_person_id","type":"INTEGER","pk":true},{"name":"relation_type","type":"VARCHAR","pk":true}],"events":[{"name":"id","type":"INTEGER","pk":true},{"name":"name","type":"VARCHAR","pk":false},{"name":"service_id","type":"INTEGER","pk":false},{"name":"service_type","type":"VARCHAR","pk":false},{"name":"start_time","type":"VARCHAR","pk":false},{"name":"end_time","type":"VARCHAR","pk":false},{"name":"created_at","type":"VARCHAR","pk":false},{"name":"updated_at","type":"VARCHAR","pk":false},{"name":"instructions","type":"VARCHAR","pk":false},{"name":"recurs","type":"BOOLEAN","pk":false},{"name":"attendees","type":"VARCHAR","pk":false},{"name":"icals","type":"VARCHAR","pk":false},{"name":"is_stub","type":"BOOLEAN","pk":false},{"name":"data","type":"VARCHAR","pk":false}],"event_attendees":[{"name":"event_id","type":"INTEGER","pk":true},{"name":"person_id","type":"INTEGER","pk":true},{"name":"name","type":"VARCHAR","pk":false},{"name":"email","type":"VARCHAR","pk":false},{"name":"start_at","type":"VARCHAR","pk":false},{"name":"end_at","type":"VARCHAR","pk":false},{"name":"state","type":"VARCHAR","pk":false}],"event_icals":[{"name":"id","type":"INTEGER","pk":true},{"name":"event_id","type":"INTEGER","pk":false},{"name":"repeat_end","type":"INTEGER","pk":false},{"name":"day","type":"VARCHAR","pk":false},{"name":"interval","type":"INTEGER","pk":false},{"name":"rcount","type":"INTEGER","pk":false},{"name":"rule_type","type":"VARCHAR","pk":false},{"name":"all_day","type":"BOOLEAN","pk":false},{"name":"location_id","type":"INTEGER","pk":false},{"name":"start_at","type":"VARCHAR","pk":false},{"name":"end_at","type":"VARCHAR","pk":false},{"name":"organizers","type":"VARCHAR","pk":false},{"name":"rrule","type":"VARCHAR","pk":false},{"name":"until_at","type":"VARCHAR","pk":false}],"event_occurrences":[{"name":"id","type":"INTEGER","pk":true},{"name":"event_id","type":"INTEGER","pk":false},{"name":"service_id","type":"INTEGER","pk":false},{"name":"location_id","type":"INTEGER","pk":false},{"name":"name","type":"VARCHAR","pk":false},{"name":"description","type":"VARCHAR","pk":false},{"name":"start_at","type":"VARCHAR","pk":false},{"name":"end_at","type":"VARCHAR","pk":false},{"name":"timezone","type":"VARCHAR","pk":false},{"name":"attendance_complete","type":"BOOLEAN","pk":false},{"name":"state","type":"VARCHAR","pk":false},{"name":"full","type":"BOOLEAN","pk":false},{"name":"visits_count","type":"INTEGER","pk":false},{"name":"capacity_remaining","type":"INTEGER","pk":false},{"name":"course_dates","type":"VARCHAR","pk":false},{"name":"waitlist_entry_count","type":"INTEGER","pk":false},{"name":"staff_members","type":"VARCHAR","pk":false},{"name":"resources","type":"VARCHAR","pk":false},{"name":"people","type":"VARCHAR","pk":false},{"name":"notes","type":"VARCHAR","pk":false},{"name":"deleted_at","type":"VARCHAR","pk":false},{"name":"is_stub","type":"BOOLEAN","pk":false},{"name":"data","type":"VARCHAR","pk":false}],"event_occurrence_staff":[{"name":"event_occurrence_id","type":"INTEGER","pk":true},{"name":"staff_id","type":"INTEGER","pk":true},{"name":"name","type":"VARCHAR","pk":false}],"event_occurrence_resources":[{"name":"resource_id","type":"INTEGER","pk":true},{"name":"event_occurrence_id","type":"INTEGER","pk":false},{"name":"name","type":"VARCHAR","pk":false},{"name":"category_id","type":"INTEGER","pk":false},{"name":"location_id","type":"INTEGER","pk":false}],"event_occurrence_enrollments":[{"name":"id","type":"INTEGER","pk":true},{"name":"event_occurrence_id","type":"INTEGER","pk":false},{"name":"person_id","type":"INTEGER","pk":false},{"name":"name","type":"VARCHAR","pk":false},{"name":"email","type":"VARCHAR","pk":false},{"name":"visit_id","type":"INTEGER","pk":false},{"name":"visit_state","type":"VARCHAR","pk":false}],"visits":[{"name":"id","type":"INTEGER","pk":true},{"name":"person_id","type":"INTEGER","pk":false},{"name":"event_occurrence_id","type":"INTEGER","pk":false},{"name":"state","type":"VARCHAR","pk":false},{"name":"status","type":"VARCHAR","pk":false},{"name":"registered_at","type":"VARCHAR","pk":false},{"name":"completed_at","type":"VARCHAR","pk":false},{"name":"noshow_at","type":"VARCHAR","pk":false},{"name":"cancelled_at","type":"VARCHAR","pk":false},{"name":"created_at","type":"VARCHAR","pk":false},{"name":"updated_at","type":"VARCHAR","pk":false},{"name":"deleted_at","type":"VARCHAR","pk":false},{"name":"paid","type":"BOOLEAN","pk":false},{"name":"paid_for_by","type":"VARCHAR","pk":false},{"name":"punch_id","type":"INTEGER","pk":false},{"name":"only_staff_can_cancel","type":"BOOLEAN","pk":false},{"name":"client_can_cancel","type":"BOOLEAN","pk":false},{"name":"person","type":"VARCHAR","pk":false},{"name":"data","type":"VARCHAR","pk":false}],"sync_blocks":[{"name":"object_type","type":"VARCHAR","pk":true},{"name":"block_key","type":"VARCHAR","pk":true},{"name":"status","type":"VARCHAR","pk":false},{"name":"completed_at","type":"VARCHAR","pk":false},{"name":"row_count","type":"INTEGER","pk":false},{"name":"notes","type":"VARCHAR","pk":false}],"meetup_groups":[{"name":"id","type":"VARCHAR","pk":true},{"name":"name","type":"VARCHAR","pk":false},{"name":"urlname","type":"VARCHAR","pk":false},{"name":"city","type":"VARCHAR","pk":false},{"name":"state","type":"VARCHAR","pk":false},{"name":"country","type":"VARCHAR","pk":false},{"name":"timezone","type":"VARCHAR","pk":false},{"name":"deleted_at","type":"VARCHAR","pk":false},{"name":"data","type":"VARCHAR","pk":false}],"meetup_venues":[{"name":"id","type":"VARCHAR","pk":true},{"name":"group_id","type":"VARCHAR","pk":false},{"name":"name","type":"VARCHAR","pk":false},{"name":"address","type":"VARCHAR","pk":false},{"name":"city","type":"VARCHAR","pk":false},{"name":"state","type":"VARCHAR","pk":false},{"name":"country","type":"VARCHAR","pk":false},{"name":"lat","type":"FLOAT","pk":false},{"name":"lon","type":"FLOAT","pk":false},{"name":"deleted_at","type":"VARCHAR","pk":false},{"name":"data","type":"VARCHAR","pk":false}],"meetup_events":[{"name":"id","type":"VARCHAR","pk":true},{"name":"group_id","type":"VARCHAR","pk":false},{"name":"venue_id","type":"VARCHAR","pk":false},{"name":"title","type":"VARCHAR","pk":false},{"name":"description","type":"VARCHAR","pk":false},{"name":"date_time","type":"VARCHAR","pk":false},{"name":"event_url","type":"VARCHAR","pk":false},{"name":"status","type":"VARCHAR","pk":false},{"name":"featured_photo_url","type":"VARCHAR","pk":false},{"name":"subgroup","type":"VARCHAR","pk":false},{"name":"meetup_slug","type":"VARCHAR","pk":false},{"name":"is_stub","type":"BOOLEAN","pk":false},{"name":"deleted_at","type":"VARCHAR","pk":false},{"name":"data","type":"VARCHAR","pk":false}],"meetup_event_hosts":[{"name":"event_id","type":"VARCHAR","pk":true},{"name":"name","type":"VARCHAR","pk":true},{"name":"photo_url","type":"VARCHAR","pk":false},{"name":"data","type":"VARCHAR","pk":false}]},"examples":[{"name":"visits_per_month","sql":"SELECT strftime('%Y-%m', completed_at) AS month, COUNT(*) AS n FROM visits GROUP BY month ORDER BY month"},{"name":"active_members","sql":"SELECT COUNT(*) AS n FROM people WHERE is_member = 1 AND deleted_at IS NULL"},{"name":"upcoming_occurrences","sql":"SELECT id, start_at, end_at FROM event_occurrences WHERE start_at > date('now') ORDER BY start_at LIMIT 20"},{"name":"visits_by_person","sql":"SELECT p.full_name, COUNT(v.id) AS visit_count FROM visits v JOIN people p ON v.person_id = p.id GROUP BY p.id ORDER BY visit_count DESC LIMIT 10"},{"name":"events_list","sql":"SELECT id, name, event_type FROM events ORDER BY name"},{"name":"location_list","sql":"SELECT id, name FROM locations ORDER BY name"},{"name":"sync_blocks_summary","sql":"SELECT object_type, status, COUNT(*) AS n FROM sync_blocks GROUP BY object_type, status"},{"name":"visits_last_30_days","sql":"SELECT COUNT(*) AS n FROM visits WHERE completed_at >= date('now', '-30 days')"},{"name":"people_count_by_membership","sql":"SELECT is_member, COUNT(*) AS n FROM people WHERE deleted_at IS NULL GROUP BY is_member"}]}