starwars_average_height_of_speciesstarwars_average_species_heightstarwars_fastest_vehiclesstarwars_planet_climate_distributionstarwars_planet_population_distributionstarwars_species_average_lifespanstarwars_species_characters_overviewstarwars_species_classificationstarwars_species_classification_distributionstarwars_species_homeworld_details_overviewstarwars_species_inputstarwars_species_lifespan_distributionstarwars_species_most_common_skin_colorstarwars_species_overviewstarwars_starship_cost_distributionstarwars_starship_manufacturer_distributionstarwars_starship_passenger_distributionstarwars_top_10_largest_planetsstarwars_total_charactersstarwars_total_planetsstarwars_total_speciesstarwars_total_starshipsstarwars_vehicle_cargo_capacity_comparison
Query: starwars_species_characters_overview
Usage
powerpipe query starwars.query.starwars_species_characters_overview
SQL
select name as 'Character Name', height as 'Height in cm', mass as 'Mass in kg', hair_color as 'Hair Colors', eye_color as 'Eye Colors', birth_year as 'Birth Year', skin_color as 'Skin Colors', gender as 'Gender', homeworld as 'Homeworld'from characterswhere species = $1;
Dashboards
The query is used in the dashboards: