Query the Data Delivery Network
Query the DDNThe easiest way to query any data on Splitgraph is via the "Data Delivery Network" (DDN). The DDN is a single endpoint that speaks the PostgreSQL wire protocol. Any Splitgraph user can connect to it at data.splitgraph.com:5432 and query any version of over 40,000 datasets that are hosted or proxied by Splitgraph.
For example, you can query the rsbs_smo_part_2_of_2_new_york_state_residential table in this repository, by referencing it like:
"ny-gov/rsbs-smo-part-2-of-2-new-york-state-residential-87mp-9bnv:latest"."rsbs_smo_part_2_of_2_new_york_state_residential"or in a full query, like:
SELECT
":id", -- Socrata column ID
"elliptical", -- Elliptical in household if "Other Major Appliances" is "Yes, please specify" [Not mentioned; Mentioned; Programmed skip; Refused]
"well_pump", -- Well pump used in the household [Yes; No; Don't know; Refused]
"natural_gas_grill", -- Natural gas grill used in the household [Yes; No; Don't know; Refused]
"pool_heater", -- Pool heater present if "Personal Filtered Swimming Pool for Home" is "Yes" or "Personal Filtered Swimming Pool for Unit Only" is "Yes" [Yes; No; Not asked in mini-survey; Programmed skip]
"automatic_timer_pool_pump", -- Automatic timer present to control the time of day that pool pump operates if "Pool Pump" is "Yes" [Yes; No; Not asked in mini-survey; Programmed skip; Refused]
"waterbed_heater", -- Waterbed heater used in the household [Yes; No; Don't know; Refused]
"sump_pump", -- Sump pump used in the household [Yes; No; Don't know; Refused]
"natural_gas_fire_pit", -- Natural gas fire pit used in the household [Yes; No; Don't know; Refused]
"county", -- County in New York where the survey respondent's home is located.
"energy_star_vcr_dvd", -- ENERGY STAR® status of VCRs and DVD players if "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" and "Number of DVD/Blu-Rays" is "1-20" or "Number of VCRs" is "1-20" [Yes; No; Don't know; Interviewer mistake; Not asked in mini-survey; Programmed skip; Refused]
"energy_star_laptop", -- ENERGY STAR® status of laptop computers if "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" and "Number of Laptops" is "1-20" [Yes; No; Don't know; Interviewer mistake; Not asked in mini-survey; Programmed skip; Refused]
"number_of_tv_boxes", -- Number of cable, satellite, or set-top boxes in the home [0-20; Refused]
"number_of_combination_tv_boxes", -- Number of combination cable, satellite, or set-top boxes with DVR unit in the home [0-20; Refused]
"shut_down_computer_when_not_in_use", -- Typically shut down -this is different from letting it go into sleep mode or simply closing the cover - computer when it is not in use if "Number of Desktops" is "1-20" or "Number of Laptops" is "1-20" [Yes; No; Don't know; Interviewer mistake; Programmed skip; Refused]
"rinse_cycle_water_temperature", -- Water temperature typically used for wash cycle of the clothes washer if "Clothes Washer in the Home" is "Yes" or "Clothes Washer in the Unit Only" is "Yes" [Hot; Warm; Cold; Don't know; Not asked in mini-survey; Programmed skip; Refused]
"age_of_clothes_washer", -- Age of primary clothes washer if "Clothes Washer in the Home" is "Yes" or "Clothes Washer in the Unit Only" is "Yes" [Less than 2 years old; 2 to 4 years old; 5 to 9 years old; 10 to 14 years old; 15 to 19 years old; 20 years old or more; Don’t know; Not asked in mini-survey; Programmed skip; Refused]
"number_of_plasma_tvs", -- Number of flat screen plasma TVs in the home [0-20; Not asked in mini-survey; Refused]
"heat_pump_clothes_dryer", -- Heat pump clothes dryer if "Clothes Dryer in the Home" is "Yes" or "Clothes Dryer in the Unit Only" is "Yes." A heat pump clothes dryer is a fairly new technology that pulls energy from the air just like a heat pump heating and cooling system. The hot air is not vented but is reused to dry the clothes. They use 50% less energy, but take longer to dry clothes [Yes; No; Don't know; Not asked in mini-survey; Programmed skip; Refused]
"shared_water_heating_system", -- Receive hot water from a shared water heating system that is used by other families if the "Home Description" is "Apartment building or condominium with 2 to 4 units" or "Apartment building or condominium with 5 or more units" [Yes; No; Don't know; Not asked in mini-survey; Programmed skip; Refused]
"primary_water_heating_system", -- Primary water heating system if "Shared Water Heating System" is "No" [Heat pump water heater; Other, specify; Part of the heating system boiler; Stand-alone storage tank; Tankless or on demand water heater; Don't know; Not asked in mini-survey; Programmed skip; Refused]
"clothes_washer_loads_per_week", -- Number of loads washed in a clothes washer during a typical week in the household if "Clothes Washer in the Home" is "Yes" or "Clothes Washer in the Unit Only" is "Yes" [0-35; Don't know; Not asked in mini-survey; Programmed skip; Refused]
"energy_star_water_heating_system", -- ENERGY STAR® status of primary water heating system if "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" and "Age of Water Heating System" is "0-9" [Yes; No; Don't know; Interviewer mistake; Not asked in mini-survey; Programmed skip; Refused]
"type_of_other_water_heating_system", -- Other type of water heating system used in the house if "Other Water Heating System" is "Yes" [Heat pump water heater; Other, specify; Part of the heating system boiler; Stand-alone storage tank; Tankless or on demand water heater; Don't know; Not asked in mini-survey; Programmed skip; Refused]
"skylights", -- Use of skylights as natural lighting in the home during the day [Mentioned; Not mentioned; Not asked in mini-survey; Refused]
"tubular_skylights", -- Use of tubular skylights (also referred to as solar tubes or sun tunnels) as natural lighting in the home during the day [Mentioned; Not mentioned; Not asked in mini-survey; Refused]
"large_window_areas", -- Use of large uncovered window areas as natural lighting in the home during the day [Mentioned; Not mentioned; Not asked in mini-survey; Refused]
"dimmer_switch", -- Use of dimmer switches as lighting controls in- or outside of the home [Mentioned; Not mentioned; Not asked in mini-survey; Refused]
"_3_way_bulb", -- Use of 3-way bulbs as lighting controls in- or outside of the home [Mentioned; Not mentioned; Not asked in mini-survey; Refused]
"number_of_led_lcd_computer_monitors", -- Number of LED/LCD flat screen computer monitors in the home [0-20; Refused]
"number_of_tablets", -- Number of iPads or tablet computers in the home [0-20; Refused]
"spa_for_home", -- Existence of a hot tub, spa, or jetted tub/jacuzzi if "Home Description" is not "Apartment building or condominium with 2 to 4 units" or "Apartment building or condominium with 5 or more units" [Yes; No; Not asked in mini-survey; Programmed skip; Refused]
"spa_heater_fuel_type", -- Type of fuel used by hot tub, spa, or jetted tub/jacuzzi heater if "Spa for Home" is "Yes" or "Spa for Unit Only" is "Yes" [Electricity; Natural gas from underground pipes; Other fuel, specify;Propane (bottled gas); Solar; Don't know; Not asked in mini-survey; Programmed skip; Refused]
"number_of_dvd_blu_rays", -- Number of DVD/Blu-Ray players or recorders in the home [0-20; Refused]
"number_of_flat_screen_tvs_of_unknown_type_used", -- Number of flat screen TVs of unknown type used at least two hours each day in the home if "Number of Flat Screen TVs of Unknown Type" is "1-20" [0-20; Programmed skip; Programming change; Refused]
"cfl_led_bulbs_used_daily_inside_home", -- Number of CFL/LED bulbs used within the home more than two hours each day [0-99; Don't know; Not asked in mini-survey; Refused]
"other_water_heating_system", -- Use of more than one water heating system in the home if "Primary Water Heating System" is not "Part of the heating system boiler" [Yes; No; Don't know; Not asked in mini-survey; Programmed skip; Refused]
"automatic_dishwasher", -- Existence of an automatic dishwasher in the house [Yes; No; Not asked in mini-survey; Refused]
"age_of_water_heating_system", -- Age of water heating system if "Shared Water Heating System" is "No" [Less than 2 years old; 2 to 4 years old; 5 to 9 years old; 10 to 14 years old; 15 to 19 years old; 20 years old or more; Don’t know; Not asked in mini-survey; Programmed skip; Refused]
"energy_star_automatic_dishwasher", -- ENERGY STAR® status of automatic dishwasher if "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" and "Age of Automatic Dishwasher" is "0-9" [Yes; No; Don't know; Not asked in mini-survey; Programmed skip; Refused]
"clothes_washer_in_home", -- Existence of a clothes washer in the home if "Home Description" is not "Apartment building or condominium with 2 to 4 units" or "Apartment building or condominium with 5 or more units" [Yes; No; Not asked in min-survey; Programmed skip; Refused]
"pool_pump", -- Personal filtered swimming pool equipped with a pool pump if "Personal Filtered Swimming Pool for Home" is "Yes" or "Personal Filtered Swimming Pool for Unit Only" is "Yes" [Yes; No; Not asked in mini-survey; Programmed skip; Refused]
"number_of_individual_copier", -- Number of individual copiers in the home [0-20; Refused]
"clothes_dryer_in_home", -- [Yes; No; Not asked in mini-survey; Programmed skip; Refused]
"energy_star_clothes_washer", -- [Yes; No; Don't know; Not asked in mini-survey; Programmed skip; Refused]
"number_of_individual_printers", -- Number of individual printers in the home [0-20; Refused]
"number_of_individual_fax_machines", -- Number of individual fax machines in the home [0-20; Refused]
"number_of_all_in_one_printers", -- Number combination printer, copier, scanner, or fax in the home [0-20; Refused]
"personal_filtered_swimming_pool", -- Existence of a personal filtered swimming pool if "Home Description" is not "Apartment building or condominium with 2 to 4 units" or "Apartment building or condominium with 5 or more units" [Yes; No; Not asked in mini-survey; Programmed skip; Refused]
"number_of_laptops", -- Number of laptop computers in the home [0-20; Refused]
"number_of_crt_computer_monitors", -- Number of CRT computer monitors in the home [0-20; Refused]
"stair_climber", -- Stair climber in household if "Other Major Appliances" is "Yes, please specify" [Not mentioned; Mentioned; Programmed skip; Refused]
"sewing_machine", -- Sewing machine in household if "Other Major Appliances" is "Yes, please specify" [Not mentioned; Mentioned; Programmed skip; Refused]
"energy_management_system", -- Use of an energy management system in the household. An energy management system provides real-time information on your energy usage and allows you to control temperature settings, turn off lights, and appliances remotely [Yes; No; Not asked in mini-survey; Refused]
"other_office_equipment", -- Existence of any other type of computer or home office equipment in the home [Yes; No]
"desktop_daily_hours_of_use", -- Total hours desktop computer(s) are typically used by all residents of the house if "Number of Desktops" is "1-20" [0-24; Interviewer mistake; Programmed skip; Refused]
"work_from_home", -- One or more household members that work from home [Yes; No; Refused]
"number_of_lcd_led_tvs_used", -- Number of flat screen LCD/LED TVs used at least two hours each day in the home if "Number of LCD/LED TVs" is "1-20" [0-20; Programmed skip; Refused]
"other_business_equipment_used", -- Other energy-using home business equipment used aside from computers, printers, and copiers [No other energy using equipment; Specify what types of equipment; Programmed skip; Refused]
"number_of_plasma_tvs_used", -- Number of flat screen plasma TVs used at least two hours each day in the home if "Number of Plasma TVs" is "1-20" [0-20; Programmed skip; Refused]
"number_of_dvrs", -- Number of DVRs (for example, TiVo) in the home [0-20; Refused]
"number_of_vcrs", -- Number of VCRs in the home [0-20; Refused]
"number_of_digital_converter_boxes", -- Number of digital converter boxes in the home [0-20; interviewer mistake; Refused]
"number_of_home_theater_systems", -- Number of home theater systems in the home [0-20; Refused]
"number_of_cordless_phones", -- Number of cordless telephones in the home [0-20; Refused]
"hair_dryer", -- Hair dryer in household if "Other Major Appliances" is "Yes, please specify" [Not mentioned; Mentioned; Not asked in mini-survey; Programmed skip]
"energy_star_led_lcd_computer_monitor", -- ENERGY STAR® status of LED/LCD computer monitors if "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" and "Number of LED/LCD Computer Monitors" is "1-20" [Yes; No; Don't know; Interviewer mistake; Not asked in mini-survey; Programmed skip; Refused]
"number_of_stereo_systems", -- Number of stereo systems in the home [0-20; Refused]
"number_of_people_that_work_from_home", -- Number of people that work from home including the respondent if "Work from Home" is "Yes" [1-20; Programmed skip]
"number_of_mp3_players", -- Number of MP3 players (for example iPod) in the home [0-20; Refused]
"number_of_cell_smart_phones", -- Number of cell phones or smart phones in the home [0-20; Refused]
"number_of_ereaders", -- Number of eReaders such as Kindle or Nook in the home [0-20; Refused]
"number_of_rear_projection_tvs", -- Number of rear projection TVs in the home [0-20; Not asked in mini-survey; Refused]
"number_of_flat_screen_tvs_of_unknown_type", -- Number of flat screen TVs of unknown type in the home [0-20; Not asked in mini-survey; Programmed skip; Refused]
"dwelling_type", -- Flag of dwelling type [Single family, Tenant]
"number_of_rear_projection_tvs_used", -- Number of rear projection TVs used at least two hours each day in the home if "Number of Rear Projection TVs" is "1-20" [0-20; Programmed skip; Refused]
"clothes_washer_in_unit", -- Existence of a clothes washer in the unit only and not common to the building itself if "Home Description" is "Apartment building or condominium with 2 to 4 units" or "Apartment building or condominium with 5 or more units" [Yes; No; Not asked in mini-survey; Programmed skip; Refused]
"number_of_modems_routers", -- Number of modems or routers in the home [0-20; Programming change]
"number_of_individual_scanners", -- Number of individual scanners in the home [0-20; Refused]
"radiant_floor_heating", -- Radiant floor heating separate from heating system used in the household [Yes; No; Don't know; Refused]
"other_major_appliances", -- Presence of any other major appliances or equipment in the home that use a lot of energy such as exercise equipment, welding equipment or heavy tools, or equipment used for a home business [Yes; No; Not asked in mini-survey; Refused]
"clothes_dryer_in_unit_only", -- [Yes; No; Not asked in mini-survey; Programmed skip; Refused]
"case_disposition", -- Final disposition of case [Phone complete, Mini-survey complete]
"number_of_standard_tube_tvs", -- Number of standard tube TVs in the home [0-20; Not asked in mini-survey; Refused]
"pool_heater_fuel_type", -- Type of fuel used by pool heater if "Pool Heater" is "Yes" [Electricity; Natural gas from underground pipes; Other fuel, specify;Propane (bottled gas); Solar; Don't know; Not asked in mini-survey; Programmed skip]
"personal_filtered_swimming_pool_for_unit_only", -- Existence of a personal filtered swimming pool for the unit and not the building itself if "Home Description" is "Apartment building or condominium with 2 to 4 units" or "Apartment building or condominium with 5 or more units" [Yes; No; Not asked in mini-survey; Programmed skip; Refused]
"cfl_led_bulbs_used_daily_outside_home", -- Number of outdoor lights used two hours or more each day that are CFL or LED lights if "Bulbs Used Daily Outside Home" is "1-95" [0-95; Don't know; Not asked in mini-survey; Programmed skip; Refused]
"other_bulbs_used_daily_inside_home", -- Number of other bulbs used within the home more than two hours each day [0-99; Don't know; Not asked in mini-survey; Refused]
"incandescent_bulbs_used_daily_inside_home", -- Number of incandescent bulbs used within the home more than two hours each day [0-99; Don't know; Not asked in mini-survey; Refused]
"previously_familiar_with_leds", -- Previously familiar with LED light bulbs, which give off directional light, so the light goes where you aim it. They are also very energy efficient and can work with dimmable switches. [Yes; No; Not asked in mini-survey; Refused]
"smart_strip_to_power_off", -- Smart strip used to turn off computers, printers, and other equipment when not in use. Smart strips are different from regular power strips. They incorporate additional technologies to automatically disconnect power to equipment when not in use. [Yes; No; Don't know; Not asked in mini-survey; Refused]
"laptop_daily_hours_of_use", -- Total hours laptop computer(s) are typically used by all residents of the house if "Number of Laptops" is "1-20" [0-24; Interviewer mistake; Programmed skip; Refused]
"number_of_lcd_led_tvs", -- Number of flat screen LCD/LED TVs in the home [0-20; Not asked in mini-survey; Refused]
"spa_for_unit_only", -- Existence of a hot tub, spa, or jetted tub/jacuzzi for the unit and not the building itself if "Home Description" is "Apartment building or condominium with 2 to 4 units" or "Apartment building or condominium with 5 or more units" [Yes; No; Not asked in mini-survey; Programmed skip]
"water_heating_fuel_type", -- Primary type of fuel used for water heating in the home if "Shared Water Heating System" is not "Yes" or "Don't know" [Electricity; Fuel Oil; Kerosene; Natural gas from underground pipes; Other, specify; Propane (bottled gas); Solar; Not asked in mini-survey; Programmed skip; Refused]
"no_natural_lighting_method_above", -- No use of natural lighting in the home during the day [Mentioned; Not mentioned; Not asked in mini-survey; Refused]
"wash_cycle_water_temperature", -- Water temperature typically used for rinse cycle of the clothes washer if "Clothes Washer in the Home" is "Yes" or "Clothes Washer in the Unit Only" is "Yes" [Hot; Warm; Cold; Don't know; Not asked in mini-survey; Programmed skip; Refused]
"construction_type", -- Flag of construction type [Existing construction - built prior to 2012; New construction - built 2012 or later]
"age_of_clothes_dryer", -- Age of primary clothes dryer if "Clothes Dryer in the Home" is "Yes" or "Clothes Dryer in the Unit Only" is "Yes" [Less than 2 years old; 2 to 4 years old; 5 to 9 years old; 10 to 14 years old; 15 to 19 years old; 20 years old or more; Don’t know; Not asked in mini-survey; Programmed skip; Refused]
"clothes_dryer_fuel_type", -- Type of fuel used by primary clothes dryer if "Clothes Dryer in Home" is "Yes" or "Clothes Dryer in Unit Only" is "Yes" [Electricity; Natural gas from underground pipes; Other, specify; Propane (bottled gas); Don't know; Not asked in mini-survey; Programmed skip; Refused]
"unique_case_id", -- Unique case identifier for each survey respondent [ST#####]. The first two letters of the ID represent a New York State Regional Economic Development Council: CD=Capital District, CN= Central New York, FL=Finger Lakers, LI=Long Island, MH=Mid-Hudson, MV=Mohawk Valley, NC=North Country, NY=New York City, ST=Southern Tier, WN=Western New York
"therm_category", -- Therm cat [300 or less therms annually; 300 to 600 therms annually; 600 to 900 therms annually; 900 to 1,200 therms annually; 1,200 to 1,500 therms annually; 1,500 to 1,800 therms annually; 1,800 to 2,100 therms annually; 2,100 or more therms annually; Not asked in mini-survey]
"age_of_automatic_dishwasher", -- Age of primary automatic dishwasher if "Automatic Dishwasher" is "Yes" [Less than 2 years old; 2 to 4 years old; 5 to 9 years old; 10 to 14 years old; 15 to 19 years old; 20 years old or more; Don’t know; Not asked in mini-survey; Programmed skip; Refused]
"automatic_dishwasher_loads_per_week", -- Loads of dishes washed in automatic dishwasher in typical week in the household [0-35; Not asked in mini-survey; Programmed skip; Refused]
"occupancy_motion_sensor", -- Use of occupancy/motion sensors as lighting controls in- or outside of the home [Mentioned; Not mentioned; Not asked in mini-survey; Refused]
"bulbs_used_daily_outside_home", -- Number of light bulbs outside the home typically used two or more hours each day (include only lights controlled from home if "Home Description" is "Single family attached house such as a duplex, townhouse, or rowhouse," "Apartment building or condominium with 2 to 4 units," or "Apartment building or condominium with 5 or more units") [0-95; Not asked in mini-survey; Refused]
"high_efficiency_pool_pump", -- Pool pump present is a high efficiency pool pump if "Pool Pump" is "Yes" [Yes; No; Don't know; Not asked in mini-survey; Programmed skip]
"number_of_standard_tube_tvs_used", -- Number of standard tube TVs used at least two hours each day in the home if "Number of Standard Tube TVs" is "1-20" [0-20; Programmed skip; Refused]
"home_internet_access", -- Internet access at home [Yes; No; Not asked in mini-survey; Refused]
"number_of_desktop_computers", -- Number of desktop computers in the home (not including monitors) [0-20; Refused]
"previously_familiar_with_cfls", -- Previously familiar with compact fluorescent light bulbs, also known as CFLs, which usually do not look like regular incandescent bulbs. The most common type of CFL is made with a glass tube bent into a spiral shape and fits in a regular light bulb socket. [Yes; No; Not asked in mini-survey; Refused]
"no_lighting_control_method_above", -- No use of lighting controls in- or outside of the home [Mentioned; Not mentioned; Not asked in mini-survey; Refused]
"tiered_smart_strip", -- Tier of smart strip used if "Smart Strip to Power Off" is "Yes." Tier 1 smart strips are controlled by a master outlet and Tier 2 smart strips are controlled by motion sensing or a timer. [Tier 1 smart strip...; Tier 2 smart strip; Both Tier 1 and Tier 2 smart strip; Don't know; Not asked in mini-survey; Programmed skip; Refused]
"number_of_gaming_systems", -- Number of video gaming systems (for example PS3, Playstation, Nintendo, Xbox, Wii) in the home [0-20; Refused]
"fish_tank", -- Fish tank in household if "Other Major Appliances" is "Yes, please specify" [Not mentioned; Mentioned; Not asked in mini-survey; Programmed skip]
"power_tools", -- Power tools in household if "Other Major Appliances" is "Yes, please specify" [Not mentioned; Mentioned; Programmed skip; Refused]
"number_of_digital_photo_albums", -- Number of digital photo albums in the home [0-20j; Refused]
"other_entertainment_telecomm_equipment", -- Other type of entertainment or telecommunications equipment used in the household [Yes; No; Not asked in mini-survey]
"energy_star_plasma_tv", -- ENERGY STAR® status of Plasma TVs if "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" and "Number of Plasma TVs" is "1-20" [Yes; No; Don't know; Interviewer mistake; Not asked in mini-survey; Programmed skip; Refused]
"energy_star_lcd_led_tv", -- ENERGY STAR® status of LCD/LED TVs if "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" and "Number of LCD/LED TVs" is "1-20" [Yes; No; Don't know; Not asked in mini-survey; Programmed skip; Refused]
"energy_star_stereo_equipment", -- ENERGY STAR® status of stereo equipment if "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" and "Number of Stereo Systems" is "1-20" [Yes; No; Don't know; Interviewer mistake; Not asked in mini-survey; Programmed skip; Refused]
"energy_star_desktop", -- ENERGY STAR® status of desktop computers if "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" and "Number of Desktops" is "1-20" [Yes; No; Don't know; Interviewer mistake; Not asked in mini-survey; Programmed skip; Refused]
"energy_star_fax_printer_scanner_all_in_one", -- ENERGY STAR® status of office copy, fax, print, and scan equipment if "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" and "Number of All-In-One Printers" is "1-20" or "Number of Individual Printers" is "1-20" or "Number of Individual Copiers" is "1-20" or "Number of Individual Fax Machines" is "1-20" or "Number of Individual Scanners" is "1-20" [Yes; No; Don't know; Interviewer mistake; Not asked in mini-survey; Programmed skip; Refused]
"energy_star_tv_boxes", -- ENERGY STAR® status of set-top/cable boxes if "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" and "Number of Combination TV Boxes" is "1-20" or "Number of TV Boxes" is "1-20" [Yes; No; Don't know; Interviewer mistake; Not asked in mini-survey; Programmed skip; Refused]
"electric_automobile", -- Presence of electric automobile that is charged on the household electric meter [Yes; No; Refused]
"home_security_system", -- Presence of home security system, which may include a security camera [Yes; No; Refused]
"generator_used", -- Presence of a generator including natural gas, solar, or wind to supply household electric needs [Yes; No; Refused]
"air_compressor", -- Air compressor in household if "Other Major Appliances" is "Yes, please specify" [Not mentioned; Mentioned; Programmed skip; Refused]
"exercise_bike", -- Exercise bike in household if "Other Major Appliances" is "Yes, please specify" [Not mentioned; Mentioned; Programmed skip; Refused]
"timer", -- Use of timers as lighting controls in- or outside of the home [Mentioned; Not mentioned; Not asked in mini-survey; Refused]
"survey_method", -- The medium by which the respondent completed the survey [Phone Complete; Web Complete; Mini-Survey Complete]
"data_origin", -- Origin of initial case data [Utility data, Tax record data]
"kwh_category", -- kWh category [500 kWh or less; 501 to 2,500 kWh; 2,501 to 6,000 kWh; 6,001 to 12,000 kWh; 12,001 to 20,000 kWh; 20,000 kWh or more; Not asked in mini-survey]
"climate_zone", -- Climate zone [Climate zone 4-6]
"region", -- Region in New York: Capital District, Central New York, Finger Lakes, Long Island, Mid-Hudson, Mohawk Valley, New York City, North Country, Southern Tier, Western New York.
"exercise_equipment", -- Exercise equipment in household if "Other Major Appliances" is "Yes, please specify" [Not mentioned; Mentioned; Programmed skip; Refused]
"water_pump", -- Water pump in household if "Other Major Appliances" is "Yes, please specify" [Not mentioned; Mentioned; Programmed skip; Refused]
"treadmill", -- Treadmill in household if "Other Major Appliances" is "Yes, please specify" [Not mentioned; Mentioned; Programmed skip; Refused]
"sauna", -- Sauna in household if "Other Major Appliances" is "Yes, please specify" [Not mentioned; Mentioned; Programmed skip; Refused]
"musical_equipment", -- Musical equipment in household if "Other Major Appliances" is "Yes, please specify" [Not mentioned; Mentioned; Not asked in mini-survey; Programmed skip]
"heating_pad_blanket", -- Heating pad/blanket in household if "Other Major Appliances" is "Yes, please specify" [Not mentioned; Mentioned; Not asked in mini-survey; Programmed skip]
"electric_utility", -- [Central Hudson, ConEd, LIPA, National Grid, NYSEG, O&R,RG&E]
"miscellaneous_appliance", -- Miscellaneous other appliances or equipment that use a lot of energy in household if "Other Major Appliances" is "Yes, please specify" [Not mentioned; Mentioned; Programmed skip; Refused]
"welder" -- Welder in household if "Other Major Appliances" is "Yes, please specify" [Not mentioned; Mentioned; Programmed skip; Refused]
FROM
"ny-gov/rsbs-smo-part-2-of-2-new-york-state-residential-87mp-9bnv:latest"."rsbs_smo_part_2_of_2_new_york_state_residential"
LIMIT 100;Connecting to the DDN is easy. All you need is an existing SQL client that can connect to Postgres. As long as you have a SQL client ready, you'll be able to query ny-gov/rsbs-smo-part-2-of-2-new-york-state-residential-87mp-9bnv with SQL in under 60 seconds.
Query Your Local Engine
Install Splitgraph Locally
bash -c "$(curl -sL https://github.com/splitgraph/splitgraph/releases/latest/download/install.sh)"Read the installation docs.
Splitgraph Cloud is built around Splitgraph Core (GitHub), which includes a local Splitgraph Engine packaged as a Docker image. Splitgraph Cloud is basically a scaled-up version of that local Engine. When you query the Data Delivery Network or the REST API, we mount the relevant datasets in an Engine on our servers and execute your query on it.
It's possible to run this engine locally. You'll need a Mac, Windows or Linux system to install sgr, and a Docker installation to run the engine. You don't need to know how to actually use Docker; sgrcan manage the image, container and volume for you.
There are a few ways to ingest data into the local engine.
For external repositories, the Splitgraph Engine can "mount" upstream data sources by using sgr mount. This feature is built around Postgres Foreign Data Wrappers (FDW). You can write custom "mount handlers" for any upstream data source. For an example, we blogged about making a custom mount handler for HackerNews stories.
For hosted datasets (like this repository), where the author has pushed Splitgraph Images to the repository, you can "clone" and/or "checkout" the data using sgr cloneand sgr checkout.
Cloning Data
Because ny-gov/rsbs-smo-part-2-of-2-new-york-state-residential-87mp-9bnv:latest is a Splitgraph Image, you can clone the data from Spltgraph Cloud to your local engine, where you can query it like any other Postgres database, using any of your existing tools.
First, install Splitgraph if you haven't already.
Clone the metadata with sgr clone
This will be quick, and does not download the actual data.
sgr clone ny-gov/rsbs-smo-part-2-of-2-new-york-state-residential-87mp-9bnvCheckout the data
Once you've cloned the data, you need to "checkout" the tag that you want. For example, to checkout the latest tag:
sgr checkout ny-gov/rsbs-smo-part-2-of-2-new-york-state-residential-87mp-9bnv:latestThis will download all the objects for the latest tag of ny-gov/rsbs-smo-part-2-of-2-new-york-state-residential-87mp-9bnv and load them into the Splitgraph Engine. Depending on your connection speed and the size of the data, you will need to wait for the checkout to complete. Once it's complete, you will be able to query the data like you would any other Postgres database.
Alternatively, use "layered checkout" to avoid downloading all the data
The data in ny-gov/rsbs-smo-part-2-of-2-new-york-state-residential-87mp-9bnv:latest is 0 bytes. If this is too big to download all at once, or perhaps you only need to query a subset of it, you can use a layered checkout.:
sgr checkout --layered ny-gov/rsbs-smo-part-2-of-2-new-york-state-residential-87mp-9bnv:latestThis will not download all the data, but it will create a schema comprised of foreign tables, that you can query as you would any other data. Splitgraph will lazily download the required objects as you query the data. In some cases, this might be faster or more efficient than a regular checkout.
Read the layered querying documentation to learn about when and why you might want to use layered queries.
Query the data with your existing tools
Once you've loaded the data into your local Splitgraph Engine, you can query it with any of your existing tools. As far as they're concerned, ny-gov/rsbs-smo-part-2-of-2-new-york-state-residential-87mp-9bnv is just another Postgres schema.