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 housing_trends_per_zip_code_acs_11_5_yr_dp04 table in this repository, by referencing it like:
"bronx-lehman-cuny-edu/housing-trends-per-zip-code-acs-11-5-yr-dp04-btbs-6w65:latest"."housing_trends_per_zip_code_acs_11_5_yr_dp04"or in a full query, like:
SELECT
":id", -- Socrata column ID
"_107_percent_margin_of_error_rooms_total_housing_units",
"_213_margin_of_error_year_householder_moved_into_unit_moved_in_",
"_221_margin_of_error_year_householder_moved_into_unit_moved_in_",
"_514_percent_gross_rent_500_to_749",
"_228_estimate_vehicles_available_no_vehicles_available",
"_131_percent_margin_of_error_rooms_6_rooms",
"_243_percent_margin_of_error_vehicles_available_3_or_more_vehic",
"_237_margin_of_error_vehicles_available_2_vehicles_available",
"_254_percent_house_heating_fuel_bottled_tank_or_lp_gas",
"_244_estimate_house_heating_fuel_occupied_housing_units",
"_519_percent_margin_of_error_gross_rent_750_to_999",
"_529_margin_of_error_gross_rent_median_dollars",
"_119_percent_margin_of_error_rooms_3_rooms",
"_245_margin_of_error_house_heating_fuel_occupied_housing_units",
"_255_percent_margin_of_error_house_heating_fuel_bottled_tank_or",
"_530_percent_gross_rent_median_dollars",
"_250_percent_house_heating_fuel_utility_gas",
"_251_percent_margin_of_error_house_heating_fuel_utility_gas",
"_252_estimate_house_heating_fuel_bottled_tank_or_lp_gas",
"_531_percent_margin_of_error_gross_rent_median_dollars",
"_256_estimate_house_heating_fuel_electricity",
"_257_margin_of_error_house_heating_fuel_electricity",
"_260_estimate_house_heating_fuel_fuel_oil_kerosene_etc",
"_261_margin_of_error_house_heating_fuel_fuel_oil_kerosene_etc",
"_265_margin_of_error_house_heating_fuel_coal_or_coke",
"_272_estimate_house_heating_fuel_solar_energy",
"_273_margin_of_error_house_heating_fuel_solar_energy",
"_276_estimate_house_heating_fuel_other_fuel",
"_280_estimate_house_heating_fuel_no_fuel_used",
"_281_margin_of_error_house_heating_fuel_no_fuel_used",
"_286_percent_selected_characteristics_occupied_housing_units",
"_203_percent_margin_of_error_year_householder_moved_into_unit_m",
"_202_percent_year_householder_moved_into_unit_moved_in_2005_or_",
"_198_percent_year_householder_moved_into_unit_occupied_housing_",
"_266_percent_house_heating_fuel_coal_or_coke",
"_112_estimate_rooms_2_rooms",
"_267_percent_margin_of_error_house_heating_fuel_coal_or_coke",
"_188_estimate_housing_tenure_average_household_size_of_owner_oc",
"_269_margin_of_error_house_heating_fuel_wood",
"_79_percent_margin_of_error_year_structure_built_built_1990_to_",
"_72_estimate_year_structure_built_built_2000_to_2004",
"_187_percent_margin_of_error_housing_tenure_renter_occupied",
"_184_estimate_housing_tenure_renter_occupied",
"_534_percent_gross_rent_no_rent_paid",
"_277_margin_of_error_house_heating_fuel_other_fuel",
"_264_estimate_house_heating_fuel_coal_or_coke",
"_292_estimate_selected_characteristics_lacking_complete_kitchen",
"_306_percent_occupants_per_room_1_00_or_less",
"_308_estimate_occupants_per_room_1_01_to_1_50",
"_312_estimate_occupants_per_room_1_51_or_more",
"_313_margin_of_error_occupants_per_room_1_51_or_more",
"_314_percent_occupants_per_room_1_51_or_more",
"_249_margin_of_error_house_heating_fuel_utility_gas",
"_248_estimate_house_heating_fuel_utility_gas",
"_238_percent_vehicles_available_2_vehicles_available",
"_87_percent_margin_of_error_year_structure_built_built_1970_to_",
"_535_percent_margin_of_error_gross_rent_no_rent_paid",
"_82_percent_year_structure_built_built_1980_to_1989",
"_539_percent_margin_of_error_gross_rent_as_a_percentage_of_hous",
"_546_percent_gross_rent_as_a_percentage_of_household_income_gra",
"_64_estimate_year_structure_built_total_housing_units",
"_62_percent_units_in_structure_boat_rv_van_etc",
"_57_margin_of_error_units_in_structure_mobile_home",
"_47_percent_margin_of_error_units_in_structure_5_to_9_units",
"_44_estimate_units_in_structure_5_to_9_units",
"_33_margin_of_error_units_in_structure_1_unit_attached",
"point_x",
"_318_percent_value_owner_occupied_units",
"_287_percent_margin_of_error_selected_characteristics_occupied_",
"point_x_zip",
"_54_percent_units_in_structure_20_or_more_units",
"_270_percent_house_heating_fuel_wood",
":@computed_region_tx27_6f7w",
"_43_percent_margin_of_error_units_in_structure_3_or_4_units",
"_274_percent_house_heating_fuel_solar_energy",
":@computed_region_23ia_pkqc",
"_25_margin_of_error_units_in_structure_total_housing_units",
"_275_percent_margin_of_error_house_heating_fuel_solar_energy",
"_323_percent_margin_of_error_value_less_than_50_000",
"_326_percent_value_50_000_to_99_999",
"_328_estimate_value_100_000_to_149_999",
"_331_percent_margin_of_error_value_100_000_to_149_999",
"_335_percent_margin_of_error_value_150_000_to_199_999",
"_338_percent_value_200_000_to_299_999",
"_559_percent_margin_of_error_gross_rent_as_a_percentage_of_hous",
"_16_estimate_housing_occupancy_homeowner_vacancy_rate",
"point_x_state",
"point_x_address",
"_103_percent_margin_of_error_year_structure_built_built_1939_or",
"_565_margin_of_error_gross_rent_as_a_percentage_of_household_in",
"_561_margin_of_error_gross_rent_as_a_percentage_of_household_in",
"_557_margin_of_error_gross_rent_as_a_percentage_of_household_in",
"_556_estimate_gross_rent_as_a_percentage_of_household_income_gr",
"_116_estimate_rooms_3_rooms",
"_552_estimate_gross_rent_as_a_percentage_of_household_income_gr",
"_117_margin_of_error_rooms_3_rooms",
"_550_percent_gross_rent_as_a_percentage_of_household_income_gra",
"_549_margin_of_error_gross_rent_as_a_percentage_of_household_in",
"_123_percent_margin_of_error_rooms_4_rooms",
"_532_estimate_gross_rent_no_rent_paid",
"_547_percent_margin_of_error_gross_rent_as_a_percentage_of_hous",
":@computed_region_itb6_w327",
"_566_percent_gross_rent_as_a_percentage_of_household_income_gra",
"_463_percent_margin_of_error_selected_monthly_owner_costs_as_a_",
"_432_estimate_selected_monthly_owner_costs_as_a_percentage_of_h",
"_417_margin_of_error_selected_monthly_owner_costs_smoc_200_to_2",
"_398_percent_selected_monthly_owner_costs_smoc_2_000_or_more",
"_395_percent_margin_of_error_selected_monthly_owner_costs_smoc_",
"_372_estimate_selected_monthly_owner_costs_smoc_less_than_300",
"_352_estimate_value_median_dollars",
"_452_estimate_selected_monthly_owner_costs_as_a_percentage_of_h",
"_450_percent_selected_monthly_owner_costs_as_a_percentage_of_ho",
"_448_estimate_selected_monthly_owner_costs_as_a_percentage_of_h",
"_446_percent_selected_monthly_owner_costs_as_a_percentage_of_ho",
"_445_margin_of_error_selected_monthly_owner_costs_as_a_percenta",
"_441_margin_of_error_selected_monthly_owner_costs_as_a_percenta",
"_435_percent_margin_of_error_selected_monthly_owner_costs_as_a_",
"_434_percent_selected_monthly_owner_costs_as_a_percentage_of_ho",
"_428_estimate_selected_monthly_owner_costs_smoc_median_dollars",
"_422_percent_selected_monthly_owner_costs_smoc_300_to_399",
"_414_percent_selected_monthly_owner_costs_smoc_100_to_199",
"_548_estimate_gross_rent_as_a_percentage_of_household_income_gr",
"_176_estimate_housing_tenure_occupied_housing_units",
"_564_estimate_gross_rent_as_a_percentage_of_household_income_gr",
"_124_estimate_rooms_5_rooms",
"_544_estimate_gross_rent_as_a_percentage_of_household_income_gr",
"_174_percent_bedrooms_5_or_more_bedrooms",
"_563_percent_margin_of_error_gross_rent_as_a_percentage_of_hous",
"_562_percent_gross_rent_as_a_percentage_of_household_income_gra",
"_554_percent_gross_rent_as_a_percentage_of_household_income_gra",
"_558_percent_gross_rent_as_a_percentage_of_household_income_gra",
"_553_margin_of_error_gross_rent_as_a_percentage_of_household_in",
"_537_margin_of_error_gross_rent_as_a_percentage_of_household_in",
"_545_margin_of_error_gross_rent_as_a_percentage_of_household_in",
"_543_percent_margin_of_error_gross_rent_as_a_percentage_of_hous",
"_536_estimate_gross_rent_as_a_percentage_of_household_income_gr",
"_533_margin_of_error_gross_rent_no_rent_paid",
"_153_margin_of_error_bedrooms_no_bedroom",
"_528_estimate_gross_rent_median_dollars",
"_527_percent_margin_of_error_gross_rent_1_500_or_more",
"_525_margin_of_error_gross_rent_1_500_or_more",
"_151_percent_margin_of_error_bedrooms_total_housing_units",
"_538_percent_gross_rent_as_a_percentage_of_household_income_gra",
"_58_percent_units_in_structure_mobile_home",
"_60_estimate_units_in_structure_boat_rv_van_etc",
"_66_percent_year_structure_built_total_housing_units",
"_68_estimate_year_structure_built_built_2005_or_later",
"_158_percent_bedrooms_1_bedroom",
"_430_percent_selected_monthly_owner_costs_smoc_median_dollars",
"_522_percent_gross_rent_1_000_to_1_499",
"_69_margin_of_error_year_structure_built_built_2005_or_later",
"_70_percent_year_structure_built_built_2005_or_later",
"_71_percent_margin_of_error_year_structure_built_built_2005_or_",
"_73_margin_of_error_year_structure_built_built_2000_to_2004",
"_74_percent_year_structure_built_built_2000_to_2004",
"_171_percent_margin_of_error_bedrooms_4_bedrooms",
"_170_percent_bedrooms_4_bedrooms",
"_168_estimate_bedrooms_4_bedrooms",
"_19_percent_margin_of_error_housing_occupancy_homeowner_vacancy",
"_518_percent_gross_rent_750_to_999",
"_513_margin_of_error_gross_rent_500_to_749",
"_504_estimate_gross_rent_200_to_299",
"_493_margin_of_error_selected_monthly_owner_costs_as_a_percenta",
"_490_percent_selected_monthly_owner_costs_as_a_percentage_of_ho",
"_486_percent_selected_monthly_owner_costs_as_a_percentage_of_ho",
"_485_margin_of_error_selected_monthly_owner_costs_as_a_percenta",
"_154_percent_bedrooms_no_bedroom",
"_411_percent_margin_of_error_selected_monthly_owner_costs_smoc_",
"_410_percent_selected_monthly_owner_costs_smoc_less_than_100",
"_408_estimate_selected_monthly_owner_costs_smoc_less_than_100",
"_407_percent_margin_of_error_selected_monthly_owner_costs_smoc_",
"_406_percent_selected_monthly_owner_costs_smoc_housing_units_wi",
"_404_estimate_selected_monthly_owner_costs_smoc_housing_units_w",
"_403_percent_margin_of_error_selected_monthly_owner_costs_smoc_",
"_402_percent_selected_monthly_owner_costs_smoc_median_dollars",
"_400_estimate_selected_monthly_owner_costs_smoc_median_dollars",
"_397_margin_of_error_selected_monthly_owner_costs_smoc_2_000_or",
"_396_estimate_selected_monthly_owner_costs_smoc_2_000_or_more",
"_389_margin_of_error_selected_monthly_owner_costs_smoc_1_000_to",
"_374_percent_selected_monthly_owner_costs_smoc_less_than_300",
"_152_estimate_bedrooms_no_bedroom",
"_161_margin_of_error_bedrooms_2_bedrooms",
"_371_percent_margin_of_error_selected_monthly_owner_costs_smoc_",
"_75_percent_margin_of_error_year_structure_built_built_2000_to_",
"_163_percent_margin_of_error_bedrooms_2_bedrooms",
"_482_percent_selected_monthly_owner_costs_as_a_percentage_of_ho",
"_477_margin_of_error_selected_monthly_owner_costs_as_a_percenta",
"_475_percent_margin_of_error_selected_monthly_owner_costs_as_a_",
"_473_margin_of_error_selected_monthly_owner_costs_as_a_percenta",
"_339_percent_margin_of_error_value_200_000_to_299_999",
"_340_estimate_value_300_000_to_499_999",
"_472_estimate_selected_monthly_owner_costs_as_a_percentage_of_h",
"_344_estimate_value_500_000_to_999_999",
"_471_percent_margin_of_error_selected_monthly_owner_costs_as_a_",
"_345_margin_of_error_value_500_000_to_999_999",
"_143_percent_margin_of_error_rooms_9_rooms_or_more",
"_142_percent_rooms_9_rooms_or_more",
"_141_margin_of_error_rooms_9_rooms_or_more",
"_140_estimate_rooms_9_rooms_or_more",
"_139_percent_margin_of_error_rooms_8_rooms",
"_136_estimate_rooms_8_rooms",
"_132_estimate_rooms_7_rooms",
"_128_estimate_rooms_6_rooms",
"_122_percent_rooms_4_rooms",
"_169_margin_of_error_bedrooms_4_bedrooms",
"_121_margin_of_error_rooms_4_rooms",
"_118_percent_rooms_3_rooms",
"_114_percent_rooms_2_rooms",
"_113_margin_of_error_rooms_2_rooms",
"_370_percent_selected_monthly_owner_costs_smoc_housing_units_wi",
"_368_estimate_selected_monthly_owner_costs_smoc_housing_units_w",
"_177_margin_of_error_housing_tenure_occupied_housing_units",
"_362_percent_mortgage_status_housing_units_with_a_mortgage",
"_180_estimate_housing_tenure_owner_occupied",
"_359_percent_margin_of_error_mortgage_status_owner_occupied_uni",
"_355_percent_margin_of_error_value_median_dollars",
"_350_percent_value_1_000_000_or_more",
"_343_percent_margin_of_error_value_300_000_to_499_999",
"_342_percent_value_300_000_to_499_999",
"_108_estimate_rooms_1_room",
"_185_margin_of_error_housing_tenure_renter_occupied",
"_341_margin_of_error_value_300_000_to_499_999",
"_101_margin_of_error_year_structure_built_built_1939_or_earlier",
"_100_estimate_year_structure_built_built_1939_or_earlier",
"_98_percent_year_structure_built_built_1940_to_1949",
"_97_margin_of_error_year_structure_built_built_1940_to_1949",
"_94_percent_year_structure_built_built_1950_to_1959",
"_89_margin_of_error_year_structure_built_built_1960_to_1969",
"_214_percent_year_householder_moved_into_unit_moved_in_1980_to_",
"_88_estimate_year_structure_built_built_1960_to_1969",
"_85_margin_of_error_year_structure_built_built_1970_to_1979",
"_83_percent_margin_of_error_year_structure_built_built_1980_to_",
"_81_margin_of_error_year_structure_built_built_1980_to_1989",
"_80_estimate_year_structure_built_built_1980_to_1989",
"_468_estimate_selected_monthly_owner_costs_as_a_percentage_of_h",
"_346_percent_value_500_000_to_999_999",
"_465_margin_of_error_selected_monthly_owner_costs_as_a_percenta",
"_351_percent_margin_of_error_value_1_000_000_or_more",
"_358_percent_mortgage_status_owner_occupied_units",
"_361_margin_of_error_mortgage_status_housing_units_with_a_mortg",
"_334_percent_value_150_000_to_199_999",
"_464_estimate_selected_monthly_owner_costs_as_a_percentage_of_h",
"_555_percent_margin_of_error_gross_rent_as_a_percentage_of_hous",
"_542_percent_gross_rent_as_a_percentage_of_household_income_gra",
"_511_percent_margin_of_error_gross_rent_300_to_499",
"_510_percent_gross_rent_300_to_499",
"_509_margin_of_error_gross_rent_300_to_499",
"_502_percent_gross_rent_less_than_200",
"_499_percent_margin_of_error_gross_rent_occupied_units_paying_r",
"_380_estimate_selected_monthly_owner_costs_smoc_500_to_699",
"_316_estimate_value_owner_occupied_units",
"_315_percent_margin_of_error_occupants_per_room_1_51_or_more",
"_364_estimate_mortgage_status_housing_units_without_a_mortgage",
"_365_margin_of_error_mortgage_status_housing_units_without_a_mo",
"_366_percent_mortgage_status_housing_units_without_a_mortgage",
"_461_margin_of_error_selected_monthly_owner_costs_as_a_percenta",
"_375_percent_margin_of_error_selected_monthly_owner_costs_smoc_",
"_376_estimate_selected_monthly_owner_costs_smoc_300_to_499",
"_459_percent_margin_of_error_selected_monthly_owner_costs_as_a_",
"_454_percent_selected_monthly_owner_costs_as_a_percentage_of_ho",
"_390_percent_selected_monthly_owner_costs_smoc_1_000_to_1_499",
"_393_margin_of_error_selected_monthly_owner_costs_smoc_1_500_to",
"_453_margin_of_error_selected_monthly_owner_costs_as_a_percenta",
"_394_percent_selected_monthly_owner_costs_smoc_1_500_to_1_999",
"_399_percent_margin_of_error_selected_monthly_owner_costs_smoc_",
"_451_percent_margin_of_error_selected_monthly_owner_costs_as_a_",
"_401_margin_of_error_selected_monthly_owner_costs_smoc_median_d",
"_449_margin_of_error_selected_monthly_owner_costs_as_a_percenta",
"_447_percent_margin_of_error_selected_monthly_owner_costs_as_a_",
"_444_estimate_selected_monthly_owner_costs_as_a_percentage_of_h",
"_443_percent_margin_of_error_selected_monthly_owner_costs_as_a_",
"_437_margin_of_error_selected_monthly_owner_costs_as_a_percenta",
"_436_estimate_selected_monthly_owner_costs_as_a_percentage_of_h",
"_429_margin_of_error_selected_monthly_owner_costs_smoc_median_d",
"_425_margin_of_error_selected_monthly_owner_costs_smoc_400_or_m",
"_424_estimate_selected_monthly_owner_costs_smoc_400_or_more",
"_415_percent_margin_of_error_selected_monthly_owner_costs_smoc_",
"_392_estimate_selected_monthly_owner_costs_smoc_1_500_to_1_999",
"_391_percent_margin_of_error_selected_monthly_owner_costs_smoc_",
"_388_estimate_selected_monthly_owner_costs_smoc_1_000_to_1_499",
"_387_percent_margin_of_error_selected_monthly_owner_costs_smoc_",
"_386_percent_selected_monthly_owner_costs_smoc_700_to_999",
"_385_margin_of_error_selected_monthly_owner_costs_smoc_700_to_9",
"_384_estimate_selected_monthly_owner_costs_smoc_700_to_999",
"_383_percent_margin_of_error_selected_monthly_owner_costs_smoc_",
"_382_percent_selected_monthly_owner_costs_smoc_500_to_699",
"_379_percent_margin_of_error_selected_monthly_owner_costs_smoc_",
"_378_percent_selected_monthly_owner_costs_smoc_300_to_499",
"_27_percent_margin_of_error_units_in_structure_total_housing_un",
"_413_margin_of_error_selected_monthly_owner_costs_smoc_100_to_1",
"_377_margin_of_error_selected_monthly_owner_costs_smoc_300_to_4",
"_303_percent_margin_of_error_occupants_per_room_occupied_housin",
"_367_percent_margin_of_error_mortgage_status_housing_units_with",
"_363_percent_margin_of_error_mortgage_status_housing_units_with",
"_360_estimate_mortgage_status_housing_units_with_a_mortgage",
"_357_margin_of_error_mortgage_status_owner_occupied_units",
"_356_estimate_mortgage_status_owner_occupied_units",
"_354_percent_value_median_dollars",
"_353_margin_of_error_value_median_dollars",
"_349_margin_of_error_value_1_000_000_or_more",
"_348_estimate_value_1_000_000_or_more",
"_347_percent_margin_of_error_value_500_000_to_999_999",
"_337_margin_of_error_value_200_000_to_299_999",
"_336_estimate_value_200_000_to_299_999",
"_333_margin_of_error_value_150_000_to_199_999",
"_330_percent_value_100_000_to_149_999",
"_329_margin_of_error_value_100_000_to_149_999",
"_327_percent_margin_of_error_value_50_000_to_99_999",
"_324_estimate_value_50_000_to_99_999",
"_322_percent_value_less_than_50_000",
"_310_percent_occupants_per_room_1_01_to_1_50",
"_305_margin_of_error_occupants_per_room_1_00_or_less",
"_299_percent_margin_of_error_selected_characteristics_no_teleph",
"_298_percent_selected_characteristics_no_telephone_service_avai",
"_297_margin_of_error_selected_characteristics_no_telephone_serv",
"_317_margin_of_error_value_owner_occupied_units",
"_293_margin_of_error_selected_characteristics_lacking_complete_",
"_288_estimate_selected_characteristics_lacking_complete_plumbin",
"_247_percent_margin_of_error_house_heating_fuel_occupied_housin",
"_284_estimate_selected_characteristics_occupied_housing_units",
"_38_percent_units_in_structure_2_units",
"_282_percent_house_heating_fuel_no_fuel_used",
"_278_percent_house_heating_fuel_other_fuel",
"_263_percent_margin_of_error_house_heating_fuel_fuel_oil_kerose",
"_262_percent_house_heating_fuel_fuel_oil_kerosene_etc",
"_36_estimate_units_in_structure_2_units",
"_259_percent_margin_of_error_house_heating_fuel_electricity",
"_258_percent_house_heating_fuel_electricity",
"_253_margin_of_error_house_heating_fuel_bottled_tank_or_lp_gas",
"_246_percent_house_heating_fuel_occupied_housing_units",
"_35_percent_margin_of_error_units_in_structure_1_unit_attached",
"_242_percent_vehicles_available_3_or_more_vehicles_available",
"_240_estimate_vehicles_available_3_or_more_vehicles_available",
"_30_percent_units_in_structure_1_unit_detached",
"_236_estimate_vehicles_available_2_vehicles_available",
"_232_estimate_vehicles_available_1_vehicle_available",
"_230_percent_vehicles_available_no_vehicles_available",
"_229_margin_of_error_vehicles_available_no_vehicles_available",
"_226_percent_vehicles_available_occupied_housing_units",
"_225_margin_of_error_vehicles_available_occupied_housing_units",
"_224_estimate_vehicles_available_occupied_housing_units",
"_219_percent_margin_of_error_year_householder_moved_into_unit_m",
"_217_margin_of_error_year_householder_moved_into_unit_moved_in_",
"_216_estimate_year_householder_moved_into_unit_moved_in_1970_to",
"_215_percent_margin_of_error_year_householder_moved_into_unit_m",
"_212_estimate_year_householder_moved_into_unit_moved_in_1980_to",
"_210_percent_year_householder_moved_into_unit_moved_in_1990_to_",
"_405_margin_of_error_selected_monthly_owner_costs_smoc_housing_",
"_409_margin_of_error_selected_monthly_owner_costs_smoc_less_tha",
"_412_estimate_selected_monthly_owner_costs_smoc_100_to_199",
"_416_estimate_selected_monthly_owner_costs_smoc_200_to_299",
"_418_percent_selected_monthly_owner_costs_smoc_200_to_299",
"_419_percent_margin_of_error_selected_monthly_owner_costs_smoc_",
"_420_estimate_selected_monthly_owner_costs_smoc_300_to_399",
"_423_percent_margin_of_error_selected_monthly_owner_costs_smoc_",
"_426_percent_selected_monthly_owner_costs_smoc_400_or_more",
"_427_percent_margin_of_error_selected_monthly_owner_costs_smoc_",
"_438_percent_selected_monthly_owner_costs_as_a_percentage_of_ho",
"_439_percent_margin_of_error_selected_monthly_owner_costs_as_a_",
"_208_estimate_year_householder_moved_into_unit_moved_in_1990_to",
"_440_estimate_selected_monthly_owner_costs_as_a_percentage_of_h",
"_442_percent_selected_monthly_owner_costs_as_a_percentage_of_ho",
"_455_percent_margin_of_error_selected_monthly_owner_costs_as_a_",
"_460_estimate_selected_monthly_owner_costs_as_a_percentage_of_h",
"_466_percent_selected_monthly_owner_costs_as_a_percentage_of_ho",
"_469_margin_of_error_selected_monthly_owner_costs_as_a_percenta",
"_474_percent_selected_monthly_owner_costs_as_a_percentage_of_ho",
"_311_percent_margin_of_error_occupants_per_room_1_01_to_1_50",
"_302_percent_occupants_per_room_occupied_housing_units",
"_478_percent_selected_monthly_owner_costs_as_a_percentage_of_ho",
"_301_margin_of_error_occupants_per_room_occupied_housing_units",
"_479_percent_margin_of_error_selected_monthly_owner_costs_as_a_",
"_295_percent_margin_of_error_selected_characteristics_lacking_c",
"_480_estimate_selected_monthly_owner_costs_as_a_percentage_of_h",
"_290_percent_selected_characteristics_lacking_complete_plumbing",
"_289_margin_of_error_selected_characteristics_lacking_complete_",
"_207_percent_margin_of_error_year_householder_moved_into_unit_m",
"_175_percent_margin_of_error_bedrooms_5_or_more_bedrooms",
"_201_margin_of_error_year_householder_moved_into_unit_moved_in_",
"_173_margin_of_error_bedrooms_5_or_more_bedrooms",
"_235_percent_margin_of_error_vehicles_available_1_vehicle_avail",
"_172_estimate_bedrooms_5_or_more_bedrooms",
"_164_estimate_bedrooms_3_bedrooms",
"_200_estimate_year_householder_moved_into_unit_moved_in_2005_or",
"_197_margin_of_error_year_householder_moved_into_unit_occupied_",
"_162_percent_bedrooms_2_bedrooms",
"_196_estimate_year_householder_moved_into_unit_occupied_housing",
"_192_estimate_housing_tenure_average_household_size_of_renter_o",
"_190_percent_housing_tenure_average_household_size_of_owner_occ",
"_186_percent_housing_tenure_renter_occupied",
"_227_percent_margin_of_error_vehicles_available_occupied_housin",
"_182_percent_housing_tenure_owner_occupied",
"_199_percent_margin_of_error_year_householder_moved_into_unit_o",
"_181_margin_of_error_housing_tenure_owner_occupied",
"_178_percent_housing_tenure_occupied_housing_units",
"_431_percent_margin_of_error_selected_monthly_owner_costs_smoc_",
"_148_estimate_bedrooms_total_housing_units",
"_144_estimate_rooms_median_rooms",
"_133_margin_of_error_rooms_7_rooms",
"_130_percent_rooms_6_rooms",
"_7_percent_margin_of_error_housing_occupancy_total_housing_unit",
"_129_margin_of_error_rooms_6_rooms",
"_126_percent_rooms_5_rooms",
"_125_margin_of_error_rooms_5_rooms",
"_120_estimate_rooms_4_rooms",
"_234_percent_vehicles_available_1_vehicle_available",
"_111_percent_margin_of_error_rooms_1_room",
"_481_margin_of_error_selected_monthly_owner_costs_as_a_percenta",
"_271_percent_margin_of_error_house_heating_fuel_wood",
"_483_percent_margin_of_error_selected_monthly_owner_costs_as_a_",
"_268_estimate_house_heating_fuel_wood",
"point_x_city",
"_487_percent_margin_of_error_selected_monthly_owner_costs_as_a_",
"_488_estimate_selected_monthly_owner_costs_as_a_percentage_of_h",
"_489_margin_of_error_selected_monthly_owner_costs_as_a_percenta",
"_491_percent_margin_of_error_selected_monthly_owner_costs_as_a_",
"_109_margin_of_error_rooms_1_room",
":@computed_region_s8vt_86fu",
"_99_percent_margin_of_error_year_structure_built_built_1940_to_",
"_96_estimate_year_structure_built_built_1940_to_1949",
"_540_estimate_gross_rent_as_a_percentage_of_household_income_gr",
"_541_margin_of_error_gross_rent_as_a_percentage_of_household_in",
"_95_percent_margin_of_error_year_structure_built_built_1950_to_",
"_11_percent_margin_of_error_housing_occupancy_occupied_housing_",
"_93_margin_of_error_year_structure_built_built_1950_to_1959",
"_15_percent_margin_of_error_housing_occupancy_vacant_housing_un",
"_18_percent_housing_occupancy_homeowner_vacancy_rate",
"_91_percent_margin_of_error_year_structure_built_built_1960_to_",
"_86_percent_year_structure_built_built_1970_to_1979",
"_84_estimate_year_structure_built_built_1970_to_1979",
"_78_percent_year_structure_built_built_1990_to_1999",
"_77_margin_of_error_year_structure_built_built_1990_to_1999",
"_65_margin_of_error_year_structure_built_total_housing_units",
"_61_margin_of_error_units_in_structure_boat_rv_van_etc",
"_52_estimate_units_in_structure_20_or_more_units",
"_49_margin_of_error_units_in_structure_10_to_19_units",
"_45_margin_of_error_units_in_structure_5_to_9_units",
"_42_percent_units_in_structure_3_or_4_units",
"_40_estimate_units_in_structure_3_or_4_units",
"_159_percent_margin_of_error_bedrooms_1_bedroom",
"_157_margin_of_error_bedrooms_1_bedroom",
"_39_percent_margin_of_error_units_in_structure_2_units",
"_34_percent_units_in_structure_1_unit_attached",
"_156_estimate_bedrooms_1_bedroom",
"_32_estimate_units_in_structure_1_unit_attached",
"_150_percent_bedrooms_total_housing_units",
"_110_percent_rooms_1_room",
"_31_percent_margin_of_error_units_in_structure_1_unit_detached",
"_26_percent_units_in_structure_total_housing_units",
"_102_percent_year_structure_built_built_1939_or_earlier",
"_325_margin_of_error_value_50_000_to_99_999",
"_321_margin_of_error_value_less_than_50_000",
"_320_estimate_value_less_than_50_000",
"_14_percent_housing_occupancy_vacant_housing_units",
"_319_percent_margin_of_error_value_owner_occupied_units",
"_12_estimate_housing_occupancy_vacant_housing_units",
"_10_percent_housing_occupancy_occupied_housing_units",
"_9_margin_of_error_housing_occupancy_occupied_housing_units",
"_309_margin_of_error_occupants_per_room_1_01_to_1_50",
"_6_percent_housing_occupancy_total_housing_units",
"_304_estimate_occupants_per_room_1_00_or_less",
"_4_estimate_housing_occupancy_total_housing_units",
"_496_estimate_gross_rent_occupied_units_paying_rent",
"_296_estimate_selected_characteristics_no_telephone_service_ava",
"_291_percent_margin_of_error_selected_characteristics_lacking_c",
"_279_percent_margin_of_error_house_heating_fuel_other_fuel",
"_497_margin_of_error_gross_rent_occupied_units_paying_rent",
"_195_percent_margin_of_error_housing_tenure_average_household_s",
"_498_percent_gross_rent_occupied_units_paying_rent",
"_194_percent_housing_tenure_average_household_size_of_renter_oc",
"_500_estimate_gross_rent_less_than_200",
"_193_margin_of_error_housing_tenure_average_household_size_of_r",
"_191_percent_margin_of_error_housing_tenure_average_household_s",
"_501_margin_of_error_gross_rent_less_than_200",
"_505_margin_of_error_gross_rent_200_to_299",
"_189_margin_of_error_housing_tenure_average_household_size_of_o",
"_506_percent_gross_rent_200_to_299",
"_507_percent_margin_of_error_gross_rent_200_to_299",
"_183_percent_margin_of_error_housing_tenure_owner_occupied",
"_179_percent_margin_of_error_housing_tenure_occupied_housing_un",
"_167_percent_margin_of_error_bedrooms_3_bedrooms",
"_160_estimate_bedrooms_2_bedrooms",
"_155_percent_margin_of_error_bedrooms_no_bedroom",
"_147_percent_margin_of_error_rooms_median_rooms",
"_508_estimate_gross_rent_300_to_499",
"_146_percent_rooms_median_rooms",
"_512_estimate_gross_rent_500_to_749",
"_145_margin_of_error_rooms_median_rooms",
"_138_percent_rooms_8_rooms",
"_137_margin_of_error_rooms_8_rooms",
"_135_percent_margin_of_error_rooms_7_rooms",
"_127_percent_margin_of_error_rooms_5_rooms",
"_515_percent_margin_of_error_gross_rent_500_to_749",
"_516_estimate_gross_rent_750_to_999",
"_517_margin_of_error_gross_rent_750_to_999",
"_520_estimate_gross_rent_1_000_to_1_499",
"_521_margin_of_error_gross_rent_1_000_to_1_499",
"_523_percent_margin_of_error_gross_rent_1_000_to_1_499",
"_524_estimate_gross_rent_1_500_or_more",
"_526_percent_gross_rent_1_500_or_more",
"zip_code",
"_567_percent_margin_of_error_gross_rent_as_a_percentage_of_hous",
"_551_percent_margin_of_error_gross_rent_as_a_percentage_of_hous",
"_233_margin_of_error_vehicles_available_1_vehicle_available",
"_220_estimate_year_householder_moved_into_unit_moved_in_1969_or",
"_294_percent_selected_characteristics_lacking_complete_kitchen_",
"_218_percent_year_householder_moved_into_unit_moved_in_1970_to_",
"_166_percent_bedrooms_3_bedrooms",
"_46_percent_units_in_structure_5_to_9_units",
"_222_percent_year_householder_moved_into_unit_moved_in_1969_or_",
"_165_margin_of_error_bedrooms_3_bedrooms",
"_223_percent_margin_of_error_year_householder_moved_into_unit_m",
"_48_estimate_units_in_structure_10_to_19_units",
"_41_margin_of_error_units_in_structure_3_or_4_units",
"_231_percent_margin_of_error_vehicles_available_no_vehicles_ava",
"_456_estimate_selected_monthly_owner_costs_as_a_percentage_of_h",
"_50_percent_units_in_structure_10_to_19_units",
"_433_margin_of_error_selected_monthly_owner_costs_as_a_percenta",
"_37_margin_of_error_units_in_structure_2_units",
"_149_margin_of_error_bedrooms_total_housing_units",
"_239_percent_margin_of_error_vehicles_available_2_vehicles_avai",
"_29_margin_of_error_units_in_structure_1_unit_detached",
"_53_margin_of_error_units_in_structure_20_or_more_units",
"_503_percent_margin_of_error_gross_rent_less_than_200",
"_241_margin_of_error_vehicles_available_3_or_more_vehicles_avai",
"_134_percent_rooms_7_rooms",
"_421_margin_of_error_selected_monthly_owner_costs_smoc_300_to_3",
"_28_estimate_units_in_structure_1_unit_detached",
"_381_margin_of_error_selected_monthly_owner_costs_smoc_500_to_6",
"_373_margin_of_error_selected_monthly_owner_costs_smoc_less_tha",
"_24_estimate_units_in_structure_total_housing_units",
"_369_margin_of_error_selected_monthly_owner_costs_smoc_housing_",
"_59_percent_margin_of_error_units_in_structure_mobile_home",
"_17_margin_of_error_housing_occupancy_homeowner_vacancy_rate",
"_63_percent_margin_of_error_units_in_structure_boat_rv_van_etc",
"_13_margin_of_error_housing_occupancy_vacant_housing_units",
"_67_percent_margin_of_error_year_structure_built_total_housing_",
"_76_estimate_year_structure_built_built_1990_to_1999",
"_8_estimate_housing_occupancy_occupied_housing_units",
"_90_percent_year_structure_built_built_1960_to_1969",
"_457_margin_of_error_selected_monthly_owner_costs_as_a_percenta",
"_204_estimate_year_householder_moved_into_unit_moved_in_2000_to",
"_56_estimate_units_in_structure_mobile_home",
"_115_percent_margin_of_error_rooms_2_rooms",
"_458_percent_selected_monthly_owner_costs_as_a_percentage_of_ho",
"_55_percent_margin_of_error_units_in_structure_20_or_more_units",
"_106_percent_rooms_total_housing_units",
"_51_percent_margin_of_error_units_in_structure_10_to_19_units",
"_105_margin_of_error_rooms_total_housing_units",
"_104_estimate_rooms_total_housing_units",
"_92_estimate_year_structure_built_built_1950_to_1959",
"_462_percent_selected_monthly_owner_costs_as_a_percentage_of_ho",
"_332_estimate_value_150_000_to_199_999",
"_23_percent_margin_of_error_housing_occupancy_rental_vacancy_ra",
"_467_percent_margin_of_error_selected_monthly_owner_costs_as_a_",
"_300_estimate_occupants_per_room_occupied_housing_units",
"_5_margin_of_error_housing_occupancy_total_housing_units",
"point_y",
"_285_margin_of_error_selected_characteristics_occupied_housing_",
"_470_percent_selected_monthly_owner_costs_as_a_percentage_of_ho",
"_283_percent_margin_of_error_house_heating_fuel_no_fuel_used",
"_476_estimate_selected_monthly_owner_costs_as_a_percentage_of_h",
"_22_percent_housing_occupancy_rental_vacancy_rate",
"_484_estimate_selected_monthly_owner_costs_as_a_percentage_of_h",
"_21_margin_of_error_housing_occupancy_rental_vacancy_rate",
"_492_estimate_selected_monthly_owner_costs_as_a_percentage_of_h",
"_20_estimate_housing_occupancy_rental_vacancy_rate",
"_494_percent_selected_monthly_owner_costs_as_a_percentage_of_ho",
"_307_percent_margin_of_error_occupants_per_room_1_00_or_less",
"_495_percent_margin_of_error_selected_monthly_owner_costs_as_a_",
"_560_estimate_gross_rent_as_a_percentage_of_household_income_gr",
"_205_margin_of_error_year_householder_moved_into_unit_moved_in_",
"_206_percent_year_householder_moved_into_unit_moved_in_2000_to_",
"_209_margin_of_error_year_householder_moved_into_unit_moved_in_",
"_211_percent_margin_of_error_year_householder_moved_into_unit_m"
FROM
"bronx-lehman-cuny-edu/housing-trends-per-zip-code-acs-11-5-yr-dp04-btbs-6w65:latest"."housing_trends_per_zip_code_acs_11_5_yr_dp04"
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 bronx-lehman-cuny-edu/housing-trends-per-zip-code-acs-11-5-yr-dp04-btbs-6w65 with SQL in under 60 seconds.
This repository is an "external" repository. That means it's hosted elsewhere, in this case at bronx.lehman.cuny.edu. When you querybronx-lehman-cuny-edu/housing-trends-per-zip-code-acs-11-5-yr-dp04-btbs-6w65:latest on the DDN, we "mount" the repository using the socrata mount handler. The mount handler proxies your SQL query to the upstream data source, translating it from SQL to the relevant language (in this case SoQL).
We also cache query responses on the DDN, but we run the DDN on multiple nodes so a CACHE_HIT is only guaranteed for subsequent queries that land on the same node.
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 (like this repository), 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, where the author has pushed Splitgraph Images to the repository, you can "clone" and/or "checkout" the data using sgr cloneand sgr checkout.
Mounting Data
This repository is an external repository. It's not hosted by Splitgraph. It is hosted by bronx.lehman.cuny.edu, and Splitgraph indexes it. This means it is not an actual Splitgraph image, so you cannot use sgr clone to get the data. Instead, you can use the socrata adapter with the sgr mount command. Then, if you want, you can import the data and turn it into a Splitgraph image that others can clone.
First, install Splitgraph if you haven't already.
Mount the table with sgr mount
sgr mount socrata \
"bronx-lehman-cuny-edu/housing-trends-per-zip-code-acs-11-5-yr-dp04-btbs-6w65" \
--handler-options '{
"domain": "bronx.lehman.cuny.edu",
"tables": {
"housing_trends_per_zip_code_acs_11_5_yr_dp04": "btbs-6w65"
}
}'That's it! Now you can query the data in the mounted table like any other Postgres table.
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, bronx-lehman-cuny-edu/housing-trends-per-zip-code-acs-11-5-yr-dp04-btbs-6w65 is just another Postgres schema.