bronx-lehman-cuny-edu/housing-trends-per-zip-code-acs-11-5-yr-dp04-btbs-6w65
Icon for Socrata external plugin

Query the Data Delivery Network

Query the DDN

The 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
    "_346_percent_value_500_000_to_999_999",
    "_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",
    "_377_margin_of_error_selected_monthly_owner_costs_smoc_300_to_4",
    "_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",
    "_558_percent_gross_rent_as_a_percentage_of_household_income_gra",
    "_553_margin_of_error_gross_rent_as_a_percentage_of_household_in",
    "_545_margin_of_error_gross_rent_as_a_percentage_of_household_in",
    "_536_estimate_gross_rent_as_a_percentage_of_household_income_gr",
    "_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",
    "_293_margin_of_error_selected_characteristics_lacking_complete_",
    "_288_estimate_selected_characteristics_lacking_complete_plumbin",
    "_284_estimate_selected_characteristics_occupied_housing_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",
    "_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",
    "_242_percent_vehicles_available_3_or_more_vehicles_available",
    "_240_estimate_vehicles_available_3_or_more_vehicles_available",
    "_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_",
    "_208_estimate_year_householder_moved_into_unit_moved_in_1990_to",
    "_207_percent_margin_of_error_year_householder_moved_into_unit_m",
    "_201_margin_of_error_year_householder_moved_into_unit_moved_in_",
    "_200_estimate_year_householder_moved_into_unit_moved_in_2005_or",
    "_197_margin_of_error_year_householder_moved_into_unit_occupied_",
    "_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",
    "_182_percent_housing_tenure_owner_occupied",
    "_181_margin_of_error_housing_tenure_owner_occupied",
    "_178_percent_housing_tenure_occupied_housing_units",
    "_148_estimate_bedrooms_total_housing_units",
    "_144_estimate_rooms_median_rooms",
    "_133_margin_of_error_rooms_7_rooms",
    "_130_percent_rooms_6_rooms",
    "_129_margin_of_error_rooms_6_rooms",
    "_126_percent_rooms_5_rooms",
    "_125_margin_of_error_rooms_5_rooms",
    "_120_estimate_rooms_4_rooms",
    "_111_percent_margin_of_error_rooms_1_room",
    "_109_margin_of_error_rooms_1_room",
    "_99_percent_margin_of_error_year_structure_built_built_1940_to_",
    "_96_estimate_year_structure_built_built_1940_to_1949",
    "_95_percent_margin_of_error_year_structure_built_built_1950_to_",
    "_93_margin_of_error_year_structure_built_built_1950_to_1959",
    "_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",
    "_39_percent_margin_of_error_units_in_structure_2_units",
    "_34_percent_units_in_structure_1_unit_attached",
    "_32_estimate_units_in_structure_1_unit_attached",
    "_31_percent_margin_of_error_units_in_structure_1_unit_detached",
    "_26_percent_units_in_structure_total_housing_units",
    "_14_percent_housing_occupancy_vacant_housing_units",
    "_12_estimate_housing_occupancy_vacant_housing_units",
    "_10_percent_housing_occupancy_occupied_housing_units",
    "_9_margin_of_error_housing_occupancy_occupied_housing_units",
    "_6_percent_housing_occupancy_total_housing_units",
    "_4_estimate_housing_occupancy_total_housing_units",
    "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",
    "_456_estimate_selected_monthly_owner_costs_as_a_percentage_of_h",
    "_433_margin_of_error_selected_monthly_owner_costs_as_a_percenta",
    "_421_margin_of_error_selected_monthly_owner_costs_smoc_300_to_3",
    "_381_margin_of_error_selected_monthly_owner_costs_smoc_500_to_6",
    "_373_margin_of_error_selected_monthly_owner_costs_smoc_less_tha",
    "_369_margin_of_error_selected_monthly_owner_costs_smoc_housing_",
    "_307_percent_margin_of_error_occupants_per_room_1_00_or_less",
    "_294_percent_selected_characteristics_lacking_complete_kitchen_",
    "_233_margin_of_error_vehicles_available_1_vehicle_available",
    "_220_estimate_year_householder_moved_into_unit_moved_in_1969_or",
    "_166_percent_bedrooms_3_bedrooms",
    "_165_margin_of_error_bedrooms_3_bedrooms",
    "_149_margin_of_error_bedrooms_total_housing_units",
    "_134_percent_rooms_7_rooms",
    "_131_percent_margin_of_error_rooms_6_rooms",
    "_119_percent_margin_of_error_rooms_3_rooms",
    "_112_estimate_rooms_2_rooms",
    "_79_percent_margin_of_error_year_structure_built_built_1990_to_",
    "_72_estimate_year_structure_built_built_2000_to_2004",
    "_54_percent_units_in_structure_20_or_more_units",
    "_43_percent_margin_of_error_units_in_structure_3_or_4_units",
    "_25_margin_of_error_units_in_structure_total_housing_units",
    "_16_estimate_housing_occupancy_homeowner_vacancy_rate",
    "point_x_state",
    "point_x_address",
    "_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",
    "_552_estimate_gross_rent_as_a_percentage_of_household_income_gr",
    "_550_percent_gross_rent_as_a_percentage_of_household_income_gra",
    "_549_margin_of_error_gross_rent_as_a_percentage_of_household_in",
    "_547_percent_margin_of_error_gross_rent_as_a_percentage_of_hous",
    "_544_estimate_gross_rent_as_a_percentage_of_household_income_gr",
    "_543_percent_margin_of_error_gross_rent_as_a_percentage_of_hous",
    "_541_margin_of_error_gross_rent_as_a_percentage_of_household_in",
    "_540_estimate_gross_rent_as_a_percentage_of_household_income_gr",
    "_538_percent_gross_rent_as_a_percentage_of_household_income_gra",
    "_537_margin_of_error_gross_rent_as_a_percentage_of_household_in",
    "_532_estimate_gross_rent_no_rent_paid",
    "_526_percent_gross_rent_1_500_or_more",
    "_524_estimate_gross_rent_1_500_or_more",
    "_523_percent_margin_of_error_gross_rent_1_000_to_1_499",
    "_521_margin_of_error_gross_rent_1_000_to_1_499",
    "_520_estimate_gross_rent_1_000_to_1_499",
    "_517_margin_of_error_gross_rent_750_to_999",
    "_516_estimate_gross_rent_750_to_999",
    "_515_percent_margin_of_error_gross_rent_500_to_749",
    "_512_estimate_gross_rent_500_to_749",
    "_508_estimate_gross_rent_300_to_499",
    "_507_percent_margin_of_error_gross_rent_200_to_299",
    "_506_percent_gross_rent_200_to_299",
    "_505_margin_of_error_gross_rent_200_to_299",
    "_501_margin_of_error_gross_rent_less_than_200",
    "_500_estimate_gross_rent_less_than_200",
    "_498_percent_gross_rent_occupied_units_paying_rent",
    "_497_margin_of_error_gross_rent_occupied_units_paying_rent",
    "_496_estimate_gross_rent_occupied_units_paying_rent",
    "_491_percent_margin_of_error_selected_monthly_owner_costs_as_a_",
    "_489_margin_of_error_selected_monthly_owner_costs_as_a_percenta",
    "_488_estimate_selected_monthly_owner_costs_as_a_percentage_of_h",
    "_487_percent_margin_of_error_selected_monthly_owner_costs_as_a_",
    "_483_percent_margin_of_error_selected_monthly_owner_costs_as_a_",
    "_481_margin_of_error_selected_monthly_owner_costs_as_a_percenta",
    "_480_estimate_selected_monthly_owner_costs_as_a_percentage_of_h",
    "_479_percent_margin_of_error_selected_monthly_owner_costs_as_a_",
    "_478_percent_selected_monthly_owner_costs_as_a_percentage_of_ho",
    "_474_percent_selected_monthly_owner_costs_as_a_percentage_of_ho",
    "_469_margin_of_error_selected_monthly_owner_costs_as_a_percenta",
    "_466_percent_selected_monthly_owner_costs_as_a_percentage_of_ho",
    "_460_estimate_selected_monthly_owner_costs_as_a_percentage_of_h",
    "_455_percent_margin_of_error_selected_monthly_owner_costs_as_a_",
    "_442_percent_selected_monthly_owner_costs_as_a_percentage_of_ho",
    "_440_estimate_selected_monthly_owner_costs_as_a_percentage_of_h",
    "_439_percent_margin_of_error_selected_monthly_owner_costs_as_a_",
    "_438_percent_selected_monthly_owner_costs_as_a_percentage_of_ho",
    "_427_percent_margin_of_error_selected_monthly_owner_costs_smoc_",
    "_426_percent_selected_monthly_owner_costs_smoc_400_or_more",
    "_423_percent_margin_of_error_selected_monthly_owner_costs_smoc_",
    "_420_estimate_selected_monthly_owner_costs_smoc_300_to_399",
    "_419_percent_margin_of_error_selected_monthly_owner_costs_smoc_",
    "_418_percent_selected_monthly_owner_costs_smoc_200_to_299",
    "_416_estimate_selected_monthly_owner_costs_smoc_200_to_299",
    "_412_estimate_selected_monthly_owner_costs_smoc_100_to_199",
    "_409_margin_of_error_selected_monthly_owner_costs_smoc_less_tha",
    "_405_margin_of_error_selected_monthly_owner_costs_smoc_housing_",
    "_401_margin_of_error_selected_monthly_owner_costs_smoc_median_d",
    "_399_percent_margin_of_error_selected_monthly_owner_costs_smoc_",
    "_394_percent_selected_monthly_owner_costs_smoc_1_500_to_1_999",
    "_393_margin_of_error_selected_monthly_owner_costs_smoc_1_500_to",
    "_390_percent_selected_monthly_owner_costs_smoc_1_000_to_1_499",
    "_376_estimate_selected_monthly_owner_costs_smoc_300_to_499",
    "_375_percent_margin_of_error_selected_monthly_owner_costs_smoc_",
    "_366_percent_mortgage_status_housing_units_without_a_mortgage",
    "_365_margin_of_error_mortgage_status_housing_units_without_a_mo",
    "_364_estimate_mortgage_status_housing_units_without_a_mortgage",
    "_361_margin_of_error_mortgage_status_housing_units_with_a_mortg",
    "_358_percent_mortgage_status_owner_occupied_units",
    "_351_percent_margin_of_error_value_1_000_000_or_more",
    "_345_margin_of_error_value_500_000_to_999_999",
    "_344_estimate_value_500_000_to_999_999",
    "_340_estimate_value_300_000_to_499_999",
    "_339_percent_margin_of_error_value_200_000_to_299_999",
    "_338_percent_value_200_000_to_299_999",
    "_335_percent_margin_of_error_value_150_000_to_199_999",
    "_331_percent_margin_of_error_value_100_000_to_149_999",
    "_328_estimate_value_100_000_to_149_999",
    "_326_percent_value_50_000_to_99_999",
    "_323_percent_margin_of_error_value_less_than_50_000",
    "_318_percent_value_owner_occupied_units",
    "_314_percent_occupants_per_room_1_51_or_more",
    "_313_margin_of_error_occupants_per_room_1_51_or_more",
    "_312_estimate_occupants_per_room_1_51_or_more",
    "_308_estimate_occupants_per_room_1_01_to_1_50",
    "_306_percent_occupants_per_room_1_00_or_less",
    "_292_estimate_selected_characteristics_lacking_complete_kitchen",
    "_286_percent_selected_characteristics_occupied_housing_units",
    "_281_margin_of_error_house_heating_fuel_no_fuel_used",
    "_280_estimate_house_heating_fuel_no_fuel_used",
    "_276_estimate_house_heating_fuel_other_fuel",
    "_273_margin_of_error_house_heating_fuel_solar_energy",
    "_272_estimate_house_heating_fuel_solar_energy",
    "_265_margin_of_error_house_heating_fuel_coal_or_coke",
    "_261_margin_of_error_house_heating_fuel_fuel_oil_kerosene_etc",
    "_260_estimate_house_heating_fuel_fuel_oil_kerosene_etc",
    "_257_margin_of_error_house_heating_fuel_electricity",
    "_256_estimate_house_heating_fuel_electricity",
    "_252_estimate_house_heating_fuel_bottled_tank_or_lp_gas",
    "_251_percent_margin_of_error_house_heating_fuel_utility_gas",
    "_250_percent_house_heating_fuel_utility_gas",
    "_245_margin_of_error_house_heating_fuel_occupied_housing_units",
    "_244_estimate_house_heating_fuel_occupied_housing_units",
    "_237_margin_of_error_vehicles_available_2_vehicles_available",
    "_228_estimate_vehicles_available_no_vehicles_available",
    "_221_margin_of_error_year_householder_moved_into_unit_moved_in_",
    "_213_margin_of_error_year_householder_moved_into_unit_moved_in_",
    "_211_percent_margin_of_error_year_householder_moved_into_unit_m",
    "_209_margin_of_error_year_householder_moved_into_unit_moved_in_",
    "_206_percent_year_householder_moved_into_unit_moved_in_2000_to_",
    "_205_margin_of_error_year_householder_moved_into_unit_moved_in_",
    "_204_estimate_year_householder_moved_into_unit_moved_in_2000_to",
    "_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_",
    "_188_estimate_housing_tenure_average_household_size_of_owner_oc",
    "_187_percent_margin_of_error_housing_tenure_renter_occupied",
    "_184_estimate_housing_tenure_renter_occupied",
    "_176_estimate_housing_tenure_occupied_housing_units",
    "_174_percent_bedrooms_5_or_more_bedrooms",
    "_171_percent_margin_of_error_bedrooms_4_bedrooms",
    "_170_percent_bedrooms_4_bedrooms",
    "_168_estimate_bedrooms_4_bedrooms",
    "_154_percent_bedrooms_no_bedroom",
    "_152_estimate_bedrooms_no_bedroom",
    "_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",
    "_121_margin_of_error_rooms_4_rooms",
    "_118_percent_rooms_3_rooms",
    "_114_percent_rooms_2_rooms",
    "_113_margin_of_error_rooms_2_rooms",
    "_108_estimate_rooms_1_room",
    "_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",
    "_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",
    "_75_percent_margin_of_error_year_structure_built_built_2000_to_",
    "_74_percent_year_structure_built_built_2000_to_2004",
    "_73_margin_of_error_year_structure_built_built_2000_to_2004",
    "_71_percent_margin_of_error_year_structure_built_built_2005_or_",
    "_70_percent_year_structure_built_built_2005_or_later",
    "_69_margin_of_error_year_structure_built_built_2005_or_later",
    "_68_estimate_year_structure_built_built_2005_or_later",
    "_66_percent_year_structure_built_total_housing_units",
    "_60_estimate_units_in_structure_boat_rv_van_etc",
    "_58_percent_units_in_structure_mobile_home",
    "_53_margin_of_error_units_in_structure_20_or_more_units",
    "_50_percent_units_in_structure_10_to_19_units",
    "_48_estimate_units_in_structure_10_to_19_units",
    "_46_percent_units_in_structure_5_to_9_units",
    "_41_margin_of_error_units_in_structure_3_or_4_units",
    "_37_margin_of_error_units_in_structure_2_units",
    "_29_margin_of_error_units_in_structure_1_unit_detached",
    "_28_estimate_units_in_structure_1_unit_detached",
    "_24_estimate_units_in_structure_total_housing_units",
    "_17_margin_of_error_housing_occupancy_homeowner_vacancy_rate",
    "_13_margin_of_error_housing_occupancy_vacant_housing_units",
    "_8_estimate_housing_occupancy_occupied_housing_units",
    "_5_margin_of_error_housing_occupancy_total_housing_units",
    "point_y",
    "_560_estimate_gross_rent_as_a_percentage_of_household_income_gr",
    "_559_percent_margin_of_error_gross_rent_as_a_percentage_of_hous",
    "_503_percent_margin_of_error_gross_rent_less_than_200",
    "_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",
    "_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",
    "_533_margin_of_error_gross_rent_no_rent_paid",
    "_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",
    "_371_percent_margin_of_error_selected_monthly_owner_costs_smoc_",
    "_370_percent_selected_monthly_owner_costs_smoc_housing_units_wi",
    "_368_estimate_selected_monthly_owner_costs_smoc_housing_units_w",
    "_362_percent_mortgage_status_housing_units_with_a_mortgage",
    "_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",
    "_341_margin_of_error_value_300_000_to_499_999",
    "_334_percent_value_150_000_to_199_999",
    "_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",
    "_311_percent_margin_of_error_occupants_per_room_1_01_to_1_50",
    "_302_percent_occupants_per_room_occupied_housing_units",
    "_301_margin_of_error_occupants_per_room_occupied_housing_units",
    "_295_percent_margin_of_error_selected_characteristics_lacking_c",
    "_290_percent_selected_characteristics_lacking_complete_plumbing",
    "_289_margin_of_error_selected_characteristics_lacking_complete_",
    "_175_percent_margin_of_error_bedrooms_5_or_more_bedrooms",
    "_173_margin_of_error_bedrooms_5_or_more_bedrooms",
    "_172_estimate_bedrooms_5_or_more_bedrooms",
    "_164_estimate_bedrooms_3_bedrooms",
    "_162_percent_bedrooms_2_bedrooms",
    "_159_percent_margin_of_error_bedrooms_1_bedroom",
    "_157_margin_of_error_bedrooms_1_bedroom",
    "_156_estimate_bedrooms_1_bedroom",
    "_150_percent_bedrooms_total_housing_units",
    "_110_percent_rooms_1_room",
    "_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",
    "_319_percent_margin_of_error_value_owner_occupied_units",
    "_309_margin_of_error_occupants_per_room_1_01_to_1_50",
    "_304_estimate_occupants_per_room_1_00_or_less",
    "_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",
    "_195_percent_margin_of_error_housing_tenure_average_household_s",
    "_194_percent_housing_tenure_average_household_size_of_renter_oc",
    "_193_margin_of_error_housing_tenure_average_household_size_of_r",
    "_191_percent_margin_of_error_housing_tenure_average_household_s",
    "_189_margin_of_error_housing_tenure_average_household_size_of_o",
    "_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",
    "_146_percent_rooms_median_rooms",
    "_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",
    "_115_percent_margin_of_error_rooms_2_rooms",
    "_106_percent_rooms_total_housing_units",
    "_105_margin_of_error_rooms_total_housing_units",
    "_104_estimate_rooms_total_housing_units",
    "_92_estimate_year_structure_built_built_1950_to_1959",
    "_332_estimate_value_150_000_to_199_999",
    "_300_estimate_occupants_per_room_occupied_housing_units",
    "_285_margin_of_error_selected_characteristics_occupied_housing_",
    "_283_percent_margin_of_error_house_heating_fuel_no_fuel_used",
    "_277_margin_of_error_house_heating_fuel_other_fuel",
    "_264_estimate_house_heating_fuel_coal_or_coke",
    "_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_",
    "_82_percent_year_structure_built_built_1980_to_1989",
    "_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",
    "point_x_zip",
    ":@computed_region_tx27_6f7w",
    ":@computed_region_23ia_pkqc",
    ":@computed_region_itb6_w327",
    "_566_percent_gross_rent_as_a_percentage_of_household_income_gra",
    "_554_percent_gross_rent_as_a_percentage_of_household_income_gra",
    "_548_estimate_gross_rent_as_a_percentage_of_household_income_gr",
    "_546_percent_gross_rent_as_a_percentage_of_household_income_gra",
    "_539_percent_margin_of_error_gross_rent_as_a_percentage_of_hous",
    "_535_percent_margin_of_error_gross_rent_no_rent_paid",
    "_534_percent_gross_rent_no_rent_paid",
    "_531_percent_margin_of_error_gross_rent_median_dollars",
    "_530_percent_gross_rent_median_dollars",
    "_529_margin_of_error_gross_rent_median_dollars",
    "_519_percent_margin_of_error_gross_rent_750_to_999",
    "_514_percent_gross_rent_500_to_749",
    "_495_percent_margin_of_error_selected_monthly_owner_costs_as_a_",
    "_494_percent_selected_monthly_owner_costs_as_a_percentage_of_ho",
    "_492_estimate_selected_monthly_owner_costs_as_a_percentage_of_h",
    "_484_estimate_selected_monthly_owner_costs_as_a_percentage_of_h",
    "_476_estimate_selected_monthly_owner_costs_as_a_percentage_of_h",
    "_470_percent_selected_monthly_owner_costs_as_a_percentage_of_ho",
    "_467_percent_margin_of_error_selected_monthly_owner_costs_as_a_",
    "_462_percent_selected_monthly_owner_costs_as_a_percentage_of_ho",
    "_458_percent_selected_monthly_owner_costs_as_a_percentage_of_ho",
    "_457_margin_of_error_selected_monthly_owner_costs_as_a_percenta",
    "_90_percent_year_structure_built_built_1960_to_1969",
    "_76_estimate_year_structure_built_built_1990_to_1999",
    "_67_percent_margin_of_error_year_structure_built_total_housing_",
    "_63_percent_margin_of_error_units_in_structure_boat_rv_van_etc",
    "_59_percent_margin_of_error_units_in_structure_mobile_home",
    "_56_estimate_units_in_structure_mobile_home",
    "_55_percent_margin_of_error_units_in_structure_20_or_more_units",
    "_51_percent_margin_of_error_units_in_structure_10_to_19_units",
    "_23_percent_margin_of_error_housing_occupancy_rental_vacancy_ra",
    "_22_percent_housing_occupancy_rental_vacancy_rate",
    "_21_margin_of_error_housing_occupancy_rental_vacancy_rate",
    "_20_estimate_housing_occupancy_rental_vacancy_rate",
    "_18_percent_housing_occupancy_homeowner_vacancy_rate",
    "_15_percent_margin_of_error_housing_occupancy_vacant_housing_un",
    "_11_percent_margin_of_error_housing_occupancy_occupied_housing_",
    ":@computed_region_s8vt_86fu",
    "point_x_city",
    "_271_percent_margin_of_error_house_heating_fuel_wood",
    "_234_percent_vehicles_available_1_vehicle_available",
    "_214_percent_year_householder_moved_into_unit_moved_in_1980_to_",
    "_185_margin_of_error_housing_tenure_renter_occupied",
    "_180_estimate_housing_tenure_owner_occupied",
    "_177_margin_of_error_housing_tenure_occupied_housing_units",
    "_169_margin_of_error_bedrooms_4_bedrooms",
    "_163_percent_margin_of_error_bedrooms_2_bedrooms",
    "_161_margin_of_error_bedrooms_2_bedrooms",
    "_158_percent_bedrooms_1_bedroom",
    "_153_margin_of_error_bedrooms_no_bedroom",
    "_124_estimate_rooms_5_rooms",
    "_123_percent_margin_of_error_rooms_4_rooms",
    "_117_margin_of_error_rooms_3_rooms",
    "_116_estimate_rooms_3_rooms",
    "_103_percent_margin_of_error_year_structure_built_built_1939_or",
    "_275_percent_margin_of_error_house_heating_fuel_solar_energy",
    "_274_percent_house_heating_fuel_solar_energy",
    "_270_percent_house_heating_fuel_wood",
    "_269_margin_of_error_house_heating_fuel_wood",
    "_267_percent_margin_of_error_house_heating_fuel_coal_or_coke",
    "_266_percent_house_heating_fuel_coal_or_coke",
    "_255_percent_margin_of_error_house_heating_fuel_bottled_tank_or",
    "_254_percent_house_heating_fuel_bottled_tank_or_lp_gas",
    "_243_percent_margin_of_error_vehicles_available_3_or_more_vehic",
    "_241_margin_of_error_vehicles_available_3_or_more_vehicles_avai",
    "_239_percent_margin_of_error_vehicles_available_2_vehicles_avai",
    "_231_percent_margin_of_error_vehicles_available_no_vehicles_ava",
    "_223_percent_margin_of_error_year_householder_moved_into_unit_m",
    "_222_percent_year_householder_moved_into_unit_moved_in_1969_or_",
    "_218_percent_year_householder_moved_into_unit_moved_in_1970_to_",
    "_107_percent_margin_of_error_rooms_total_housing_units",
    "_287_percent_margin_of_error_selected_characteristics_occupied_",
    "_151_percent_margin_of_error_bedrooms_total_housing_units",
    "_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",
    "_522_percent_gross_rent_1_000_to_1_499",
    "_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",
    "_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",
    "_472_estimate_selected_monthly_owner_costs_as_a_percentage_of_h",
    "_471_percent_margin_of_error_selected_monthly_owner_costs_as_a_",
    "_468_estimate_selected_monthly_owner_costs_as_a_percentage_of_h",
    "_465_margin_of_error_selected_monthly_owner_costs_as_a_percenta",
    "_464_estimate_selected_monthly_owner_costs_as_a_percentage_of_h",
    "_461_margin_of_error_selected_monthly_owner_costs_as_a_percenta",
    "_459_percent_margin_of_error_selected_monthly_owner_costs_as_a_",
    "_454_percent_selected_monthly_owner_costs_as_a_percentage_of_ho",
    "_453_margin_of_error_selected_monthly_owner_costs_as_a_percenta",
    "_451_percent_margin_of_error_selected_monthly_owner_costs_as_a_",
    "_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",
    "_430_percent_selected_monthly_owner_costs_smoc_median_dollars",
    "_19_percent_margin_of_error_housing_occupancy_homeowner_vacancy",
    "_27_percent_margin_of_error_units_in_structure_total_housing_un",
    "_413_margin_of_error_selected_monthly_owner_costs_smoc_100_to_1",
    "_303_percent_margin_of_error_occupants_per_room_occupied_housin",
    "_317_margin_of_error_value_owner_occupied_units",
    "_247_percent_margin_of_error_house_heating_fuel_occupied_housin",
    "_38_percent_units_in_structure_2_units",
    "_36_estimate_units_in_structure_2_units",
    "_35_percent_margin_of_error_units_in_structure_1_unit_attached",
    "_30_percent_units_in_structure_1_unit_detached",
    "_235_percent_margin_of_error_vehicles_available_1_vehicle_avail",
    "_227_percent_margin_of_error_vehicles_available_occupied_housin",
    "_199_percent_margin_of_error_year_householder_moved_into_unit_o",
    "_431_percent_margin_of_error_selected_monthly_owner_costs_smoc_",
    "_7_percent_margin_of_error_housing_occupancy_total_housing_unit",
    "_268_estimate_house_heating_fuel_wood",
    "_562_percent_gross_rent_as_a_percentage_of_household_income_gra",
    "_563_percent_margin_of_error_gross_rent_as_a_percentage_of_hous",
    "_564_estimate_gross_rent_as_a_percentage_of_household_income_gr"
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.