bronx-lehman-cuny-edu/bronx-2006-2010-acs-5-year-estimated-poverty-kuxq-tteb
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 bronx_2006_2010_acs_5_year_estimated_poverty table in this repository, by referencing it like:

"bronx-lehman-cuny-edu/bronx-2006-2010-acs-5-year-estimated-poverty-kuxq-tteb:latest"."bronx_2006_2010_acs_5_year_estimated_poverty"

or in a full query, like:

SELECT
    ":id", -- Socrata column ID
    "hc02_vc99_estimate_margin_of_error_income_and_benefits_in_2010_",
    "hc03_vc99_percent_income_and_benefits_in_2010_inflationadjusted",
    "hc01_vc101_estimate_income_and_benefits_in_2010_inflationadjust",
    "hc03_vc102_percent_income_and_benefits_in_2010_inflationadjuste",
    "hc02_vc103_estimate_margin_of_error_income_and_benefits_in_2010",
    "hc02_vc104_estimate_margin_of_error_income_and_benefits_in_2010",
    "hc03_vc104_percent_income_and_benefits_in_2010_inflationadjuste",
    "hc04_vc104_percent_margin_of_error_income_and_benefits_in_2010_",
    "hc02_vc105_estimate_margin_of_error_income_and_benefits_in_2010",
    "hc04_vc105_percent_margin_of_error_income_and_benefits_in_2010_",
    "hc04_vc106_percent_margin_of_error_income_and_benefits_in_2010_",
    "hc02_vc107_estimate_margin_of_error_income_and_benefits_in_2010",
    "hc04_vc56_percent_margin_of_error_industry_information",
    "hc01_vc56_estimate_industry_information",
    "hc04_vc55_percent_margin_of_error_industry_transportation_and_w",
    "hc03_vc55_percent_industry_transportation_and_warehousing_and_u",
    "hc02_vc55_estimate_margin_of_error_industry_transportation_and_",
    "hc03_vc54_percent_industry_retail_trade",
    "hc02_vc54_estimate_margin_of_error_industry_retail_trade",
    "hc01_vc54_estimate_industry_retail_trade",
    "hc01_vc86_estimate_income_and_benefits_in_2010_inflationadjuste",
    "hc02_vc85_estimate_margin_of_error_income_and_benefits_in_2010_",
    "hc04_vc53_percent_margin_of_error_industry_wholesale_trade",
    "hc01_vc53_estimate_industry_wholesale_trade",
    "hc03_vc52_percent_industry_manufacturing",
    "hc02_vc52_estimate_margin_of_error_industry_manufacturing",
    "hc01_vc52_estimate_industry_manufacturing",
    "hc04_vc51_percent_margin_of_error_industry_construction",
    "hc03_vc51_percent_industry_construction",
    "hc04_vc50_percent_margin_of_error_industry_agriculture_forestry",
    "hc03_vc49_percent_industry_civilian_employed_population_16_year",
    "hc04_vc45_percent_margin_of_error_occupation_production_transpo",
    "hc03_vc45_percent_occupation_production_transportation_and_mate",
    "hc01_vc45_estimate_occupation_production_transportation_and_mat",
    "hc01_vc85_estimate_income_and_benefits_in_2010_inflationadjuste",
    "hc04_vc44_percent_margin_of_error_occupation_natural_resources_",
    "hc03_vc44_percent_occupation_natural_resources_construction_and",
    "hc02_vc44_estimate_margin_of_error_occupation_natural_resources",
    "hc04_vc43_percent_margin_of_error_occupation_sales_and_office_o",
    "hc02_vc42_estimate_margin_of_error_occupation_service_occupatio",
    "hc02_vc41_estimate_margin_of_error_occupation_management_busine",
    "hc01_vc41_estimate_occupation_management_business_science_and_a",
    "hc03_vc40_percent_occupation_civilian_employed_population_16_ye",
    "hc02_vc40_estimate_margin_of_error_occupation_civilian_employed",
    "hc01_vc40_estimate_occupation_civilian_employed_population_16_y",
    "hc04_vc33_percent_margin_of_error_commuting_to_work_other_means",
    "hc02_vc33_estimate_margin_of_error_commuting_to_work_other_mean",
    "hc04_vc32_percent_margin_of_error_commuting_to_work_walked",
    "hc01_vc32_estimate_commuting_to_work_walked",
    ":@computed_region_itb6_w327",
    ":@computed_region_23ia_pkqc",
    ":@computed_region_tx27_6f7w",
    "location_1_city",
    "hc02_vc24_estimate_margin_of_error_employment_status_all_parent",
    "hc03_vc43_percent_occupation_sales_and_office_occupations",
    "hc01_vc66_estimate_class_of_worker_civilian_employed_population",
    "hc02_vc31_estimate_margin_of_error_commuting_to_work_public_tra",
    "hc01_vc31_estimate_commuting_to_work_public_transportation_excl",
    "hc02_vc81_estimate_margin_of_error_income_and_benefits_in_2010_",
    "hc03_vc81_percent_income_and_benefits_in_2010_inflationadjusted",
    "hc04_vc81_percent_margin_of_error_income_and_benefits_in_2010_i",
    "hc01_vc82_estimate_income_and_benefits_in_2010_inflationadjuste",
    "hc03_vc82_percent_income_and_benefits_in_2010_inflationadjusted",
    "hc04_vc82_percent_margin_of_error_income_and_benefits_in_2010_i",
    "hc01_vc83_estimate_income_and_benefits_in_2010_inflationadjuste",
    "hc04_vc29_percent_margin_of_error_commuting_to_work_car_truck_o",
    "hc03_vc29_percent_commuting_to_work_car_truck_or_van_drove_alon",
    "hc02_vc29_estimate_margin_of_error_commuting_to_work_car_truck_",
    "hc03_vc108_percent_income_and_benefits_in_2010_inflationadjuste",
    "hc01_vc109_estimate_income_and_benefits_in_2010_inflationadjust",
    "hc03_vc109_percent_income_and_benefits_in_2010_inflationadjuste",
    "hc04_vc109_percent_margin_of_error_income_and_benefits_in_2010_",
    "hc01_vc110_estimate_income_and_benefits_in_2010_inflationadjust",
    "hc02_vc110_estimate_margin_of_error_income_and_benefits_in_2010",
    "hc03_vc110_percent_income_and_benefits_in_2010_inflationadjuste",
    "hc04_vc110_percent_margin_of_error_income_and_benefits_in_2010_",
    "hc01_vc111_estimate_income_and_benefits_in_2010_inflationadjust",
    "hc02_vc111_estimate_margin_of_error_income_and_benefits_in_2010",
    "hc03_vc111_percent_income_and_benefits_in_2010_inflationadjuste",
    "hc01_vc113_estimate_income_and_benefits_in_2010_inflationadjust",
    "hc02_vc113_estimate_margin_of_error_income_and_benefits_in_2010",
    "hc01_vc115_estimate_income_and_benefits_in_2010_inflationadjust",
    "hc02_vc115_estimate_margin_of_error_income_and_benefits_in_2010",
    "hc01_vc117_estimate_income_and_benefits_in_2010_inflationadjust",
    "hc02_vc117_estimate_margin_of_error_income_and_benefits_in_2010",
    "hc01_vc118_estimate_income_and_benefits_in_2010_inflationadjust",
    "hc02_vc28_estimate_margin_of_error_commuting_to_work_workers_16",
    "location_1_address",
    "hc03_vc66_percent_class_of_worker_civilian_employed_population_",
    "hc02_vc70_estimate_margin_of_error_class_of_worker_unpaid_famil",
    "hc02_vc20_estimate_margin_of_error_employment_status_own_childr",
    "hc01_vc09_estimate_employment_status_in_labor_force_armed_force",
    "puma",
    ":@computed_region_s8vt_86fu",
    "hc02_vc78_estimate_margin_of_error_income_and_benefits_in_2010_",
    "hc01_vc80_estimate_income_and_benefits_in_2010_inflationadjuste",
    "hc03_vc34_percent_commuting_to_work_worked_at_home",
    "hc04_vc41_percent_margin_of_error_occupation_management_busines",
    "hc01_vc49_estimate_industry_civilian_employed_population_16_yea",
    "hc02_vc53_estimate_margin_of_error_industry_wholesale_trade",
    "hc03_vc53_percent_industry_wholesale_trade",
    "hc03_vc56_percent_industry_information",
    "hc01_vc59_estimate_industry_educational_services_and_health_car",
    "hc03_vc59_percent_industry_educational_services_and_health_care",
    "hc03_vc88_percent_income_and_benefits_in_2010_inflationadjusted",
    "hc02_vc89_estimate_margin_of_error_income_and_benefits_in_2010_",
    "hc01_vc90_estimate_income_and_benefits_in_2010_inflationadjuste",
    "hc02_vc90_estimate_margin_of_error_income_and_benefits_in_2010_",
    "hc02_vc36_estimate_margin_of_error_commuting_to_work_mean_trave",
    "hc01_vc119_estimate_income_and_benefits_in_2010_inflationadjust",
    "hc01_vc121_estimate_income_and_benefits_in_2010_inflationadjust",
    "hc03_vc28_percent_commuting_to_work_workers_16_years_and_over",
    "hc01_vc28_estimate_commuting_to_work_workers_16_years_and_over",
    "hc04_vc24_percent_margin_of_error_employment_status_all_parents",
    "hc03_vc24_percent_employment_status_all_parents_in_family_in_la",
    "hc01_vc24_estimate_employment_status_all_parents_in_family_in_l",
    "hc02_vc23_estimate_margin_of_error_employment_status_own_childr",
    "hc04_vc21_percent_margin_of_error_employment_status_all_parents",
    "hc03_vc21_percent_employment_status_all_parents_in_family_in_la",
    "hc01_vc21_estimate_employment_status_all_parents_in_family_in_l",
    "hc03_vc20_percent_employment_status_own_children_under_6_years",
    "hc01_vc20_estimate_employment_status_own_children_under_6_years",
    "hc04_vc18_percent_margin_of_error_employment_status_in_labor_fo",
    "hc02_vc18_estimate_margin_of_error_employment_status_in_labor_f",
    "hc04_vc17_percent_margin_of_error_employment_status_in_labor_fo",
    "hc03_vc90_percent_income_and_benefits_in_2010_inflationadjusted",
    "hc01_vc105_estimate_income_and_benefits_in_2010_inflationadjust",
    "hc03_vc171_percent_percentage_of_families_and_people_whose_inco",
    "hc04_vc83_percent_margin_of_error_income_and_benefits_in_2010_i",
    "hc04_vc88_percent_margin_of_error_income_and_benefits_in_2010_i",
    "hc04_vc92_percent_margin_of_error_income_and_benefits_in_2010_i",
    "hc01_vc102_estimate_income_and_benefits_in_2010_inflationadjust",
    "hc04_vc107_percent_margin_of_error_income_and_benefits_in_2010_",
    "hc02_vc109_estimate_margin_of_error_income_and_benefits_in_2010",
    "location_1_zip",
    "hc03_vc17_percent_employment_status_in_labor_force_civilian_lab",
    "hc02_vc17_estimate_margin_of_error_employment_status_in_labor_f",
    "hc01_vc17_estimate_employment_status_in_labor_force_civilian_la",
    "hc01_vc16_estimate_employment_status_in_labor_force",
    "hc03_vc15_percent_employment_status_females_16_years_and_over",
    "hc01_vc15_estimate_employment_status_females_16_years_and_over",
    "hc04_vc13_percent_margin_of_error_employment_status_percent_une",
    "hc03_vc13_percent_employment_status_percent_unemployed",
    "hc03_vc12_percent_employment_status_civilian_labor_force",
    "hc02_vc12_estimate_margin_of_error_employment_status_civilian_l",
    "hc02_vc121_estimate_margin_of_error_income_and_benefits_in_2010",
    "hc01_vc122_estimate_income_and_benefits_in_2010_inflationadjust",
    "hc02_vc122_estimate_margin_of_error_income_and_benefits_in_2010",
    "hc01_vc123_estimate_income_and_benefits_in_2010_inflationadjust",
    "hc03_vc156_percent_percentage_of_families_and_people_whose_inco",
    "hc04_vc156_percent_margin_of_error_percentage_of_families_and_p",
    "census_tract",
    "hc01_vc04_estimate_employment_status_population_16_years_and_ov",
    "hc03_vc04_percent_employment_status_population_16_years_and_ove",
    "hc02_vc05_estimate_margin_of_error_employment_status_in_labor_f",
    "hc01_vc06_estimate_employment_status_in_labor_force_civilian_la",
    "hc02_vc06_estimate_margin_of_error_employment_status_in_labor_f",
    "hc04_vc06_percent_margin_of_error_employment_status_in_labor_fo",
    "hc01_vc07_estimate_employment_status_in_labor_force_civilian_la",
    "hc03_vc07_percent_employment_status_in_labor_force_civilian_lab",
    "hc04_vc09_percent_margin_of_error_employment_status_in_labor_fo",
    "hc01_vc10_estimate_employment_status_not_in_labor_force",
    "hc02_vc10_estimate_margin_of_error_employment_status_not_in_lab",
    "hc02_vc16_estimate_margin_of_error_employment_status_in_labor_f",
    "hc03_vc16_percent_employment_status_in_labor_force",
    "hc04_vc16_percent_margin_of_error_employment_status_in_labor_fo",
    "hc01_vc18_estimate_employment_status_in_labor_force_civilian_la",
    "hc03_vc18_percent_employment_status_in_labor_force_civilian_lab",
    "hc02_vc21_estimate_margin_of_error_employment_status_all_parent",
    "hc01_vc23_estimate_employment_status_own_children_6_to_17_years",
    "hc03_vc23_percent_employment_status_own_children_6_to_17_years",
    "hc01_vc29_estimate_commuting_to_work_car_truck_or_van_drove_alo",
    "hc01_vc30_estimate_commuting_to_work_car_truck_or_van_carpooled",
    "hc02_vc30_estimate_margin_of_error_commuting_to_work_car_truck_",
    "hc03_vc30_percent_commuting_to_work_car_truck_or_van_carpooled",
    "hc04_vc30_percent_margin_of_error_commuting_to_work_car_truck_o",
    "hc03_vc31_percent_commuting_to_work_public_transportation_exclu",
    "hc04_vc31_percent_margin_of_error_commuting_to_work_public_tran",
    "hc02_vc32_estimate_margin_of_error_commuting_to_work_walked",
    "hc03_vc32_percent_commuting_to_work_walked",
    "hc01_vc33_estimate_commuting_to_work_other_means",
    "hc03_vc33_percent_commuting_to_work_other_means",
    "hc01_vc34_estimate_commuting_to_work_worked_at_home",
    "hc02_vc34_estimate_margin_of_error_commuting_to_work_worked_at_",
    "hc04_vc34_percent_margin_of_error_commuting_to_work_worked_at_h",
    "hc01_vc36_estimate_commuting_to_work_mean_travel_time_to_work_m",
    "hc03_vc41_percent_occupation_management_business_science_and_ar",
    "hc01_vc42_estimate_occupation_service_occupations",
    "hc03_vc42_percent_occupation_service_occupations",
    "hc04_vc42_percent_margin_of_error_occupation_service_occupation",
    "hc01_vc43_estimate_occupation_sales_and_office_occupations",
    "hc02_vc43_estimate_margin_of_error_occupation_sales_and_office_",
    "hc01_vc44_estimate_occupation_natural_resources_construction_an",
    "hc02_vc45_estimate_margin_of_error_occupation_production_transp",
    "hc02_vc49_estimate_margin_of_error_industry_civilian_employed_p",
    "hc01_vc50_estimate_industry_agriculture_forestry_fishing_and_hu",
    "hc02_vc50_estimate_margin_of_error_industry_agriculture_forestr",
    "hc03_vc50_percent_industry_agriculture_forestry_fishing_and_hun",
    "hc01_vc51_estimate_industry_construction",
    "hc02_vc51_estimate_margin_of_error_industry_construction",
    "hc04_vc52_percent_margin_of_error_industry_manufacturing",
    "hc04_vc157_percent_margin_of_error_percentage_of_families_and_p",
    "hc03_vc158_percent_percentage_of_families_and_people_whose_inco",
    "hc04_vc158_percent_margin_of_error_percentage_of_families_and_p",
    "hc03_vc159_percent_percentage_of_families_and_people_whose_inco",
    "hc04_vc159_percent_margin_of_error_percentage_of_families_and_p",
    "hc03_vc160_percent_percentage_of_families_and_people_whose_inco",
    "hc02_vc123_estimate_margin_of_error_income_and_benefits_in_2010",
    "hc04_vc90_percent_margin_of_error_income_and_benefits_in_2010_i",
    "hc01_vc91_estimate_income_and_benefits_in_2010_inflationadjuste",
    "hc01_vc92_estimate_income_and_benefits_in_2010_inflationadjuste",
    "hc02_vc92_estimate_margin_of_error_income_and_benefits_in_2010_",
    "hc02_vc88_estimate_margin_of_error_income_and_benefits_in_2010_",
    "hc01_vc88_estimate_income_and_benefits_in_2010_inflationadjuste",
    "hc02_vc86_estimate_margin_of_error_income_and_benefits_in_2010_",
    "hc01_vc93_estimate_income_and_benefits_in_2010_inflationadjuste",
    "hc02_vc95_estimate_margin_of_error_income_and_benefits_in_2010_",
    "hc03_vc95_percent_income_and_benefits_in_2010_inflationadjusted",
    "hc04_vc95_percent_margin_of_error_income_and_benefits_in_2010_i",
    "hc02_vc96_estimate_margin_of_error_income_and_benefits_in_2010_",
    "hc01_vc97_estimate_income_and_benefits_in_2010_inflationadjuste",
    "hc02_vc97_estimate_margin_of_error_income_and_benefits_in_2010_",
    "hc01_vc98_estimate_income_and_benefits_in_2010_inflationadjuste",
    "hc02_vc98_estimate_margin_of_error_income_and_benefits_in_2010_",
    "hc01_vc99_estimate_income_and_benefits_in_2010_inflationadjuste",
    "hc02_vc69_estimate_margin_of_error_class_of_worker_selfemployed",
    "hc01_vc69_estimate_class_of_worker_selfemployed_in_own_not_inco",
    "hc04_vc68_percent_margin_of_error_class_of_worker_government_wo",
    "hc03_vc68_percent_class_of_worker_government_workers",
    "hc02_vc68_estimate_margin_of_error_class_of_worker_government_w",
    "hc01_vc68_estimate_class_of_worker_government_workers",
    "hc04_vc67_percent_margin_of_error_class_of_worker_private_wage_",
    "hc03_vc67_percent_class_of_worker_private_wage_and_salary_worke",
    "hc01_vc67_estimate_class_of_worker_private_wage_and_salary_work",
    "hc01_vc62_estimate_industry_public_administration",
    "hc04_vc61_percent_margin_of_error_industry_other_services_excep",
    "hc04_vc57_percent_margin_of_error_industry_finance_and_insuranc",
    "hc02_vc58_estimate_margin_of_error_industry_professional_scient",
    "hc03_vc58_percent_industry_professional_scientific_and_manageme",
    "hc04_vc58_percent_margin_of_error_industry_professional_scienti",
    "hc02_vc59_estimate_margin_of_error_industry_educational_service",
    "hc04_vc78_percent_margin_of_error_income_and_benefits_in_2010_i",
    "hc02_vc79_estimate_margin_of_error_income_and_benefits_in_2010_",
    "hc04_vc59_percent_margin_of_error_industry_educational_services",
    "hc01_vc60_estimate_industry_arts_entertainment_and_recreation_a",
    "hc02_vc60_estimate_margin_of_error_industry_arts_entertainment_",
    "hc01_vc61_estimate_industry_other_services_except_public_admini",
    "hc02_vc61_estimate_margin_of_error_industry_other_services_exce",
    "hc03_vc61_percent_industry_other_services_except_public_adminis",
    "hc04_vc84_percent_margin_of_error_income_and_benefits_in_2010_i",
    "hc03_vc84_percent_income_and_benefits_in_2010_inflationadjusted",
    "hc02_vc84_estimate_margin_of_error_income_and_benefits_in_2010_",
    "hc01_vc84_estimate_income_and_benefits_in_2010_inflationadjuste",
    "hc04_vc174_percent_margin_of_error_percentage_of_families_and_p",
    "hc03_vc174_percent_percentage_of_families_and_people_whose_inco",
    "hc04_vc173_percent_margin_of_error_percentage_of_families_and_p",
    "hc04_vc172_percent_margin_of_error_percentage_of_families_and_p",
    "hc03_vc170_percent_percentage_of_families_and_people_whose_inco",
    "hc03_vc79_percent_income_and_benefits_in_2010_inflationadjusted",
    "hc03_vc80_percent_income_and_benefits_in_2010_inflationadjusted",
    "hc04_vc80_percent_margin_of_error_income_and_benefits_in_2010_i",
    "hc01_vc81_estimate_income_and_benefits_in_2010_inflationadjuste",
    "hc02_vc82_estimate_margin_of_error_income_and_benefits_in_2010_",
    "hc02_vc83_estimate_margin_of_error_income_and_benefits_in_2010_",
    "hc03_vc83_percent_income_and_benefits_in_2010_inflationadjusted",
    "hc02_vc91_estimate_margin_of_error_income_and_benefits_in_2010_",
    "hc03_vc92_percent_income_and_benefits_in_2010_inflationadjusted",
    "hc02_vc93_estimate_margin_of_error_income_and_benefits_in_2010_",
    "hc02_vc102_estimate_margin_of_error_income_and_benefits_in_2010",
    "hc02_vc56_estimate_margin_of_error_industry_information",
    "hc02_vc15_estimate_margin_of_error_employment_status_females_16",
    "hc02_vc57_estimate_margin_of_error_industry_finance_and_insuran",
    "hc01_vc95_estimate_income_and_benefits_in_2010_inflationadjuste",
    "hc01_vc96_estimate_income_and_benefits_in_2010_inflationadjuste",
    "hc03_vc97_percent_income_and_benefits_in_2010_inflationadjusted",
    "hc04_vc97_percent_margin_of_error_income_and_benefits_in_2010_i",
    "hc04_vc99_percent_margin_of_error_income_and_benefits_in_2010_i",
    "hc02_vc101_estimate_margin_of_error_income_and_benefits_in_2010",
    "hc03_vc101_percent_income_and_benefits_in_2010_inflationadjuste",
    "hc04_vc102_percent_margin_of_error_income_and_benefits_in_2010_",
    "hc01_vc103_estimate_income_and_benefits_in_2010_inflationadjust",
    "hc03_vc103_percent_income_and_benefits_in_2010_inflationadjuste",
    "hc04_vc103_percent_margin_of_error_income_and_benefits_in_2010_",
    "hc01_vc104_estimate_income_and_benefits_in_2010_inflationadjust",
    "hc03_vc173_percent_percentage_of_families_and_people_whose_inco",
    "hc03_vc172_percent_percentage_of_families_and_people_whose_inco",
    "hc04_vc171_percent_margin_of_error_percentage_of_families_and_p",
    "hc04_vc170_percent_margin_of_error_percentage_of_families_and_p",
    "hc01_vc108_estimate_income_and_benefits_in_2010_inflationadjust",
    "hc02_vc108_estimate_margin_of_error_income_and_benefits_in_2010",
    "hc04_vc108_percent_margin_of_error_income_and_benefits_in_2010_",
    "hc04_vc111_percent_margin_of_error_income_and_benefits_in_2010_",
    "hc01_vc112_estimate_income_and_benefits_in_2010_inflationadjust",
    "hc02_vc112_estimate_margin_of_error_income_and_benefits_in_2010",
    "hc03_vc117_percent_income_and_benefits_in_2010_inflationadjuste",
    "hc02_vc118_estimate_margin_of_error_income_and_benefits_in_2010",
    "hc02_vc119_estimate_margin_of_error_income_and_benefits_in_2010",
    "hc03_vc107_percent_income_and_benefits_in_2010_inflationadjuste",
    "hc01_vc107_estimate_income_and_benefits_in_2010_inflationadjust",
    "hc03_vc106_percent_income_and_benefits_in_2010_inflationadjuste",
    "hc02_vc106_estimate_margin_of_error_income_and_benefits_in_2010",
    "hc01_vc106_estimate_income_and_benefits_in_2010_inflationadjust",
    "hc03_vc105_percent_income_and_benefits_in_2010_inflationadjuste",
    "hc03_vc166_percent_percentage_of_families_and_people_whose_inco",
    "hc04_vc162_percent_margin_of_error_percentage_of_families_and_p",
    "hc03_vc162_percent_percentage_of_families_and_people_whose_inco",
    "hc04_vc160_percent_margin_of_error_percentage_of_families_and_p",
    "hc03_vc157_percent_percentage_of_families_and_people_whose_inco",
    "hc01_vc89_estimate_income_and_benefits_in_2010_inflationadjuste",
    "hc03_vc161_percent_percentage_of_families_and_people_whose_inco",
    "hc04_vc161_percent_margin_of_error_percentage_of_families_and_p",
    "hc03_vc163_percent_percentage_of_families_and_people_whose_inco",
    "hc04_vc163_percent_margin_of_error_percentage_of_families_and_p",
    "hc03_vc164_percent_percentage_of_families_and_people_whose_inco",
    "hc04_vc164_percent_margin_of_error_percentage_of_families_and_p",
    "hc04_vc166_percent_margin_of_error_percentage_of_families_and_p",
    "hc03_vc167_percent_percentage_of_families_and_people_whose_inco",
    "hc04_vc167_percent_margin_of_error_percentage_of_families_and_p",
    "hc03_vc168_percent_percentage_of_families_and_people_whose_inco",
    "hc04_vc168_percent_margin_of_error_percentage_of_families_and_p",
    "hc03_vc169_percent_percentage_of_families_and_people_whose_inco",
    "hc04_vc169_percent_margin_of_error_percentage_of_families_and_p",
    "hc01_vc12_estimate_employment_status_civilian_labor_force",
    "hc04_vc10_percent_margin_of_error_employment_status_not_in_labo",
    "hc04_vc54_percent_margin_of_error_industry_retail_trade",
    "hc01_vc55_estimate_industry_transportation_and_warehousing_and_",
    "hc01_vc57_estimate_industry_finance_and_insurance_and_real_esta",
    "hc03_vc57_percent_industry_finance_and_insurance_and_real_estat",
    "hc01_vc58_estimate_industry_professional_scientific_and_managem",
    "hc03_vc60_percent_industry_arts_entertainment_and_recreation_an",
    "hc04_vc60_percent_margin_of_error_industry_arts_entertainment_a",
    "hc02_vc62_estimate_margin_of_error_industry_public_administrati",
    "hc03_vc62_percent_industry_public_administration",
    "hc04_vc62_percent_margin_of_error_industry_public_administratio",
    "hc02_vc66_estimate_margin_of_error_class_of_worker_civilian_emp",
    "hc02_vc67_estimate_margin_of_error_class_of_worker_private_wage",
    "hc04_vc69_percent_margin_of_error_class_of_worker_selfemployed_",
    "hc04_vc70_percent_margin_of_error_class_of_worker_unpaid_family",
    "hc01_vc74_estimate_income_and_benefits_in_2010_inflationadjuste",
    "hc02_vc75_estimate_margin_of_error_income_and_benefits_in_2010_",
    "hc03_vc75_percent_income_and_benefits_in_2010_inflationadjusted",
    "hc03_vc10_percent_employment_status_not_in_labor_force",
    "hc03_vc09_percent_employment_status_in_labor_force_armed_forces",
    "hc01_vc76_estimate_income_and_benefits_in_2010_inflationadjuste",
    "hc03_vc76_percent_income_and_benefits_in_2010_inflationadjusted",
    "hc01_vc77_estimate_income_and_benefits_in_2010_inflationadjuste",
    "hc03_vc77_percent_income_and_benefits_in_2010_inflationadjusted",
    "hc03_vc78_percent_income_and_benefits_in_2010_inflationadjusted",
    "hc02_vc09_estimate_margin_of_error_employment_status_in_labor_f",
    "hc04_vc08_percent_margin_of_error_employment_status_in_labor_fo",
    "hc03_vc08_percent_employment_status_in_labor_force_civilian_lab",
    "hc02_vc08_estimate_margin_of_error_employment_status_in_labor_f",
    "hc01_vc08_estimate_employment_status_in_labor_force_civilian_la",
    "hc04_vc07_percent_margin_of_error_employment_status_in_labor_fo",
    "hc02_vc07_estimate_margin_of_error_employment_status_in_labor_f",
    "hc03_vc06_percent_employment_status_in_labor_force_civilian_lab",
    "hc04_vc05_percent_margin_of_error_employment_status_in_labor_fo",
    "hc03_vc05_percent_employment_status_in_labor_force",
    "hc01_vc05_estimate_employment_status_in_labor_force",
    "hc02_vc04_estimate_margin_of_error_employment_status_population",
    "population_estimate",
    "ntacode",
    "neighborhood",
    "location_1_state",
    "location_1",
    "hc04_vc175_percent_margin_of_error_percentage_of_families_and_p",
    "hc03_vc175_percent_percentage_of_families_and_people_whose_inco",
    "hc02_vc80_estimate_margin_of_error_income_and_benefits_in_2010_",
    "hc04_vc79_percent_margin_of_error_income_and_benefits_in_2010_i",
    "hc01_vc79_estimate_income_and_benefits_in_2010_inflationadjuste",
    "hc01_vc78_estimate_income_and_benefits_in_2010_inflationadjuste",
    "hc04_vc77_percent_margin_of_error_income_and_benefits_in_2010_i",
    "hc02_vc77_estimate_margin_of_error_income_and_benefits_in_2010_",
    "hc04_vc76_percent_margin_of_error_income_and_benefits_in_2010_i",
    "hc02_vc76_estimate_margin_of_error_income_and_benefits_in_2010_",
    "hc04_vc75_percent_margin_of_error_income_and_benefits_in_2010_i",
    "hc01_vc75_estimate_income_and_benefits_in_2010_inflationadjuste",
    "hc03_vc74_percent_income_and_benefits_in_2010_inflationadjusted",
    "hc02_vc74_estimate_margin_of_error_income_and_benefits_in_2010_",
    "hc03_vc70_percent_class_of_worker_unpaid_family_workers",
    "hc01_vc70_estimate_class_of_worker_unpaid_family_workers",
    "hc03_vc69_percent_class_of_worker_selfemployed_in_own_not_incor"
FROM
    "bronx-lehman-cuny-edu/bronx-2006-2010-acs-5-year-estimated-poverty-kuxq-tteb:latest"."bronx_2006_2010_acs_5_year_estimated_poverty"
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/bronx-2006-2010-acs-5-year-estimated-poverty-kuxq-tteb 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/bronx-2006-2010-acs-5-year-estimated-poverty-kuxq-tteb: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)"
 

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/bronx-2006-2010-acs-5-year-estimated-poverty-kuxq-tteb" \
  --handler-options '{
    "domain": "bronx.lehman.cuny.edu",
    "tables": {
        "bronx_2006_2010_acs_5_year_estimated_poverty": "kuxq-tteb"
    }
}'

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/bronx-2006-2010-acs-5-year-estimated-poverty-kuxq-tteb is just another Postgres schema.

Related Documentation: