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 usaid_construction_assessment_subawards_section_4 table in this repository, by referencing it like:
"usaid-gov/usaid-construction-assessment-subawards-section-4-kwdq-phjc:latest"."usaid_construction_assessment_subawards_section_4"or in a full query, like:
SELECT
":id", -- Socrata column ID
"build_ss_plan_area_4_2", -- Rural:
"build_ss_plan_area_9_2", -- Rural:
"build_ss_est_area_9_1", -- Urban:
"build_ss_energy_eff_9", -- Type 9: BUILD_SS_TYPE-RC Energy efficiency standards required by the award (-1: Don t Know, 0: No, 1: Yes)
"build_ss_green_std_9_oe", -- BUILD_SS_GREEN_STD_9_OE
"build_ss_non_haz_mate_9", -- Type 9: BUILD_SS_TYPE-RC Specifications and or clauses requiring use of saf ()
"build_ss_disab_9", -- Type 9: BUILD_SS_TYPE-RC Did Does the sub-award(s) incorporated design eleme (-1: Don t Know, 0: No, 1: Yes; describe standards:)
"build_ss_plan_life_9_oe", -- BUILD_SS_PLAN_LIFE_9_OE
"build_ss_conflict_10", -- Type 10: BUILD_SS_TYPE-RC Was Is construction in a conflict area? (-1: Don t Know, 0: No, 1: Yes)
"build_ss_plan_sites_10", -- Type 10: BUILD_SS_TYPE-RC Planned of sites (by location)
"build_ss_plan_sites_10_2", -- Rural:
"build_ss_act_sites_10_1", -- Urban:
"build_ss_plan_area_10_96", -- Don t know
"build_ss_est_area_10_1", -- Urban:
"build_ss_est_area_10_2", -- Rural:
"build_ss_disab_10", -- Type 10: BUILD_SS_TYPE-RC Did Does the sub-award(s) incorporated design elem (-1: Don t Know, 0: No, 1: Yes; describe standards:)
"build_ss_gps_10_gpscoordinates", -- Type 10: BUILD_SS_TYPE-RC GPS coordinates for all related construction struc
"build_ss_const_location_11", -- Type 11: BUILD_SS_TYPE-RC Construction location (1: New site no previous construction of any kind, 2: New on site with previous construction of any type, 3: Upgrade Expansion of existing facility, 4: Rehab of existing facility approximately same footprint)
"build_ss_plan_sites_11_2", -- Rural:
"build_ss_est_area_11_1", -- Urban:
"build_ss_disab_4_oe", -- BUILD_SS_DISAB_4_OE
"build_ss_act_sites_4_2_oe", -- BUILD_SS_ACT_SITES_4_2_OE
"build_ss_plan_sites_4_96", -- Don t know
"build_ss_plan_sites_4_2", -- Rural:
"build_ss_prefab_4", -- Type 4: BUILD_SS_TYPE-RC Did this facility include any major pre-fabricated (-1: Don t Know, 0: No, 1: Yes)
"build_ss_gps_3_refusalmsg", -- Type 3: BUILD_SS_GPS : Refusal Message
"build_ss_disab_3_oe", -- BUILD_SS_DISAB_3_OE
"build_ss_non_haz_mate_3_oe", -- BUILD_SS_NON_HAZ_MATE_3_OE
"build_ss_non_haz_mate_3", -- Type 3: BUILD_SS_TYPE-RC Specifications and or clauses requiring use of saf ()
"region",
"build_ss_plan_life_11", -- Type 11: BUILD_SS_TYPE-RC Planned designed economic life of the constructed (-1: Don t know, 1: Years)
"build_ss_disab_11_oe", -- BUILD_SS_DISAB_11_OE
"build_ss_est_area_11_2", -- Rural:
"build_ss_est_area_11", -- Type 11: BUILD_SS_TYPE-RC Actual Estimated typical area per building (m2, by
"build_ss_plan_area_11_96", -- Don t know
"build_ss_plan_area_11_2_oe", -- BUILD_SS_PLAN_AREA_11_2_OE
"build_ss_act_sites_11_2", -- Rural:
"build_ss_rework_10_oe", -- BUILD_SS_REWORK_10_OE
"build_ss_plan_life_10_oe", -- BUILD_SS_PLAN_LIFE_10_OE
"build_ss_plan_life_10", -- Type 10: BUILD_SS_TYPE-RC Planned designed economic life of the constructed (-1: Don t know, 1: Years)
"build_ss_green_std_10_oe", -- BUILD_SS_GREEN_STD_10_OE
"build_ss_energy_eff_10", -- Type 10: BUILD_SS_TYPE-RC Energy efficiency standards required by the award (-1: Don t Know, 0: No, 1: Yes)
"build_ss_est_area_10_96", -- Don t know
"build_ss_est_area_10", -- Type 10: BUILD_SS_TYPE-RC Actual Estimated typical area per building (m2, by
"build_ss_act_sites_10_96", -- Don t know
"build_ss_plan_sites_10_96", -- Don t know
"build_ss_plan_sites_10_2_1", -- BUILD_SS_PLAN_SITES_10_2_OE
"build_ss_plan_sites_10_1_1", -- BUILD_SS_PLAN_SITES_10_1_OE
"build_ss_plan_sites_10_1", -- Urban:
"build_ss_prefab_10", -- Type 10: BUILD_SS_TYPE-RC Did this facility include any major pre-fabricated (-1: Don t Know, 0: No, 1: Yes)
"build_ss_gps_9_refusalmsg", -- Type 9: BUILD_SS_GPS : Refusal Message
"build_ss_est_life_9_oe", -- BUILD_SS_EST_LIFE_9_OE
"build_ss_est_area_9_2_oe", -- BUILD_SS_EST_AREA_9_2_OE
"build_ss_plan_area_9_96", -- Don t know
"build_ss_act_sites_9_96", -- Don t know
"build_ss_act_sites_9_1_oe", -- BUILD_SS_ACT_SITES_9_1_OE
"build_ss_plan_sites_9_96", -- Don t know
"build_ss_plan_sites_9", -- Type 9: BUILD_SS_TYPE-RC Planned of sites (by location)
"build_ss_gps_8_refusalmsg", -- Type 8: BUILD_SS_GPS : Refusal Message
"build_ss_gps_8_file", -- Type 8: BUILD_SS_GPS : File
"build_ss_non_haz_mate_8_oe", -- BUILD_SS_NON_HAZ_MATE_8_OE
"build_ss_non_haz_mate_8", -- Type 8: BUILD_SS_TYPE-RC Specifications and or clauses requiring use of saf ()
"build_ss_est_area_8_1", -- Urban:
"build_ss_plan_sites_8", -- Type 8: BUILD_SS_TYPE-RC Planned of sites (by location)
"build_ss_gps_7_file", -- Type 7: BUILD_SS_GPS : File
"build_ss_disab_7", -- Type 7: BUILD_SS_TYPE-RC Did Does the sub-award(s) incorporated design eleme (-1: Don t Know, 0: No, 1: Yes; describe standards:)
"build_ss_non_haz_mate_7", -- Type 7: BUILD_SS_TYPE-RC Specifications and or clauses requiring use of saf ()
"build_ss_green_std_7_oe", -- BUILD_SS_GREEN_STD_7_OE
"build_ss_est_area_7_1_oe", -- BUILD_SS_EST_AREA_7_1_OE
"build_ss_plan_area_7_1", -- Urban:
"build_ss_act_sites_7_1", -- Urban:
"build_ss_prefab_7", -- Type 7: BUILD_SS_TYPE-RC Did this facility include any major pre-fabricated (-1: Don t Know, 0: No, 1: Yes)
"build_ss_gps_6_file", -- Type 6: BUILD_SS_GPS : File
"build_ss_rework_6", -- Type 6: BUILD_SS_TYPE-RC Rework required and not completed prior to award en (1: Yes, minor defects, 2: Yes, major defects, 3: Yes, major requirements not met; estimate not usable:, 4: Yes, completely unusable, 5: No, 6: Don t know; explain:)
"build_ss_est_life_6", -- Type 6: BUILD_SS_TYPE-RC Estimated economic life of the constructed facility (-1: Don t know, 1: Years)
"build_ss_plan_life_6", -- Type 6: BUILD_SS_TYPE-RC Planned designed economic life of the constructed (-1: Don t know, 1: Years)
"build_ss_disab_6", -- Type 6: BUILD_SS_TYPE-RC Did Does the sub-award(s) incorporated design eleme (-1: Don t Know, 0: No, 1: Yes; describe standards:)
"build_ss_green_std_6_oe", -- BUILD_SS_GREEN_STD_6_OE
"build_ss_green_std_6", -- Type 6: BUILD_SS_TYPE-RC Green building standards required by the award (e.g (-1: Don t Know, 0: No, 1: Yes; describe standards:)
"build_ss_est_area_6_96", -- Don t know
"build_ss_est_area_6_2_oe", -- BUILD_SS_EST_AREA_6_2_OE
"build_ss_est_area_6_1_oe", -- BUILD_SS_EST_AREA_6_1_OE
"build_ss_est_area_6_1", -- Urban:
"build_ss_est_area_6", -- Type 6: BUILD_SS_TYPE-RC Actual Estimated typical area per building (m2, by
"build_ss_plan_area_6_96", -- Don t know
"build_ss_act_sites_6_2", -- Rural:
"build_ss_act_sites_6_1_oe", -- BUILD_SS_ACT_SITES_6_1_OE
"build_ss_act_sites_6_1", -- Urban:
"build_ss_plan_sites_6_1", -- Urban:
"build_ss_prefab_6", -- Type 6: BUILD_SS_TYPE-RC Did this facility include any major pre-fabricated (-1: Don t Know, 0: No, 1: Yes)
"build_ss_conflict_6", -- Type 6: BUILD_SS_TYPE-RC Was Is construction in a conflict area? (-1: Don t Know, 0: No, 1: Yes)
"build_ss_est_life_5_oe", -- BUILD_SS_EST_LIFE_5_OE
"build_ss_plan_life_5", -- Type 5: BUILD_SS_TYPE-RC Planned designed economic life of the constructed (-1: Don t know, 1: Years)
"build_ss_disab_5", -- Type 5: BUILD_SS_TYPE-RC Did Does the sub-award(s) incorporated design eleme (-1: Don t Know, 0: No, 1: Yes; describe standards:)
"build_ss_green_std_5_oe", -- BUILD_SS_GREEN_STD_5_OE
"build_ss_energy_eff_5", -- Type 5: BUILD_SS_TYPE-RC Energy efficiency standards required by the award (-1: Don t Know, 0: No, 1: Yes)
"build_ss_plan_area_5_2_oe", -- BUILD_SS_PLAN_AREA_5_2_OE
"build_ss_act_sites_5_96", -- Don t know
"build_ss_act_sites_5_2", -- Rural:
"build_ss_act_sites_5_1_oe", -- BUILD_SS_ACT_SITES_5_1_OE
"build_ss_act_sites_5_1", -- Urban:
"build_ss_act_sites_5", -- Type 5: BUILD_SS_TYPE-RC Actual Estimated of sites (by location)
"build_ss_plan_sites_5_96", -- Don t know
"build_ss_plan_sites_5_1_oe", -- BUILD_SS_PLAN_SITES_5_1_OE
"build_ss_const_location_5", -- Type 5: BUILD_SS_TYPE-RC Construction location (1: New site no previous construction of any kind, 2: New on site with previous construction of any type, 3: Upgrade Expansion of existing facility, 4: Rehab of existing facility approximately same footprint)
"build_ss_rework_4", -- Type 4: BUILD_SS_TYPE-RC Rework required and not completed prior to award en (1: Yes, minor defects, 2: Yes, major defects, 3: Yes, major requirements not met; estimate not usable:, 4: Yes, completely unusable, 5: No, 6: Don t know; explain:)
"build_ss_est_life_4", -- Type 4: BUILD_SS_TYPE-RC Estimated economic life of the constructed facility (-1: Don t know, 1: Years)
"build_ss_plan_life_4", -- Type 4: BUILD_SS_TYPE-RC Planned designed economic life of the constructed (-1: Don t know, 1: Years)
"build_ss_green_std_4_oe", -- BUILD_SS_GREEN_STD_4_OE
"build_ss_est_area_4_96", -- Don t know
"build_ss_est_area_4_1_oe", -- BUILD_SS_EST_AREA_4_1_OE
"build_ss_est_area_4", -- Type 4: BUILD_SS_TYPE-RC Actual Estimated typical area per building (m2, by
"build_ss_plan_area_4_1", -- Urban:
"build_ss_plan_sites_4_1", -- Urban:
"build_ss_conflict_4", -- Type 4: BUILD_SS_TYPE-RC Was Is construction in a conflict area? (-1: Don t Know, 0: No, 1: Yes)
"build_ss_gps_3_gpscoordinates", -- Type 3: BUILD_SS_TYPE-RC GPS coordinates for all related construction struct
"build_ss_est_life_3", -- Type 3: BUILD_SS_TYPE-RC Estimated economic life of the constructed facility (-1: Don t know, 1: Years)
"build_ss_green_std_3_oe", -- BUILD_SS_GREEN_STD_3_OE
"build_ss_non_haz_mate_11", -- Type 11: BUILD_SS_TYPE-RC Specifications and or clauses requiring use of sa ()
"build_ss_energy_eff_11", -- Type 11: BUILD_SS_TYPE-RC Energy efficiency standards required by the award (-1: Don t Know, 0: No, 1: Yes)
"build_ss_plan_area_11_1", -- Urban:
"build_ss_act_sites_11", -- Type 11: BUILD_SS_TYPE-RC Actual Estimated of sites (by location)
"build_ss_plan_sites_11_1_1", -- BUILD_SS_PLAN_SITES_11_1_OE
"build_ss_plan_sites_11_1", -- Urban:
"build_ss_prefab_11", -- Type 11: BUILD_SS_TYPE-RC Did this facility include any major pre-fabricated (-1: Don t Know, 0: No, 1: Yes)
"build_ss_gps_10_refusalmsg", -- Type 10: BUILD_SS_GPS : Refusal Message
"build_ss_rework_10", -- Type 10: BUILD_SS_TYPE-RC Rework required and not completed prior to award e (1: Yes, minor defects, 2: Yes, major defects, 3: Yes, major requirements not met; estimate not usable:, 4: Yes, completely unusable, 5: No, 6: Don t know; explain:)
"build_ss_est_life_10", -- Type 10: BUILD_SS_TYPE-RC Estimated economic life of the constructed facilit (-1: Don t know, 1: Years)
"build_ss_disab_10_oe", -- BUILD_SS_DISAB_10_OE
"build_ss_plan_area_10", -- Type 10: BUILD_SS_TYPE-RC Planned typical area per building (m2, by location
"build_ss_act_sites_10_2_oe", -- BUILD_SS_ACT_SITES_10_2_OE
"build_ss_non_haz_mate_9_oe", -- BUILD_SS_NON_HAZ_MATE_9_OE
"build_ss_est_area_9_96", -- Don t know
"build_ss_est_area_9", -- Type 9: BUILD_SS_TYPE-RC Actual Estimated typical area per building (m2, by
"build_ss_plan_sites_9_2", -- Rural:
"build_ss_plan_sites_9_1", -- Urban:
"build_ss_rework_8_oe", -- BUILD_SS_REWORK_8_OE
"build_ss_plan_life_8_oe", -- BUILD_SS_PLAN_LIFE_8_OE
"build_ss_disab_8_oe", -- BUILD_SS_DISAB_8_OE
"build_ss_green_std_8", -- Type 8: BUILD_SS_TYPE-RC Green building standards required by the award (e.g (-1: Don t Know, 0: No, 1: Yes; describe standards:)
"build_ss_energy_eff_8", -- Type 8: BUILD_SS_TYPE-RC Energy efficiency standards required by the award (-1: Don t Know, 0: No, 1: Yes)
"build_ss_est_area_8_1_oe", -- BUILD_SS_EST_AREA_8_1_OE
"build_ss_act_sites_8_1", -- Urban:
"build_ss_plan_sites_8_1_oe", -- BUILD_SS_PLAN_SITES_8_1_OE
"build_ss_prefab_8", -- Type 8: BUILD_SS_TYPE-RC Did this facility include any major pre-fabricated (-1: Don t Know, 0: No, 1: Yes)
"build_ss_gps_7_gpscoordinates", -- Type 7: BUILD_SS_TYPE-RC GPS coordinates for all related construction struct
"build_ss_rework_7_oe", -- BUILD_SS_REWORK_7_OE
"build_ss_est_life_7", -- Type 7: BUILD_SS_TYPE-RC Estimated economic life of the constructed facility (-1: Don t know, 1: Years)
"build_ss_plan_life_7_oe", -- BUILD_SS_PLAN_LIFE_7_OE
"build_ss_plan_life_7", -- Type 7: BUILD_SS_TYPE-RC Planned designed economic life of the constructed (-1: Don t know, 1: Years)
"build_ss_non_haz_mate_7_oe", -- BUILD_SS_NON_HAZ_MATE_7_OE
"build_ss_plan_area_7_2_oe", -- BUILD_SS_PLAN_AREA_7_2_OE
"build_ss_act_sites_7_2_oe", -- BUILD_SS_ACT_SITES_7_2_OE
"build_ss_const_location_7", -- Type 7: BUILD_SS_TYPE-RC Construction location (1: New site no previous construction of any kind, 2: New on site with previous construction of any type, 3: Upgrade Expansion of existing facility, 4: Rehab of existing facility approximately same footprint)
"build_ss_rework_6_oe", -- BUILD_SS_REWORK_6_OE
"build_ss_est_life_6_oe", -- BUILD_SS_EST_LIFE_6_OE
"build_ss_non_haz_mate_6_oe", -- BUILD_SS_NON_HAZ_MATE_6_OE
"build_ss_energy_eff_6", -- Type 6: BUILD_SS_TYPE-RC Energy efficiency standards required by the award (-1: Don t Know, 0: No, 1: Yes)
"build_ss_plan_area_6_2", -- Rural:
"build_ss_plan_area_6_1_oe", -- BUILD_SS_PLAN_AREA_6_1_OE
"build_ss_plan_area_6", -- Type 6: BUILD_SS_TYPE-RC Planned typical area per building (m2, by location)
"build_ss_const_location_6", -- Type 6: BUILD_SS_TYPE-RC Construction location (1: New site no previous construction of any kind, 2: New on site with previous construction of any type, 3: Upgrade Expansion of existing facility, 4: Rehab of existing facility approximately same footprint)
"build_ss_rework_5_oe", -- BUILD_SS_REWORK_5_OE
"build_ss_rework_5", -- Type 5: BUILD_SS_TYPE-RC Rework required and not completed prior to award en (1: Yes, minor defects, 2: Yes, major defects, 3: Yes, major requirements not met; estimate not usable:, 4: Yes, completely unusable, 5: No, 6: Don t know; explain:)
"build_ss_non_haz_mate_5", -- Type 5: BUILD_SS_TYPE-RC Specifications and or clauses requiring use of saf ()
"build_ss_est_area_5_1_oe", -- BUILD_SS_EST_AREA_5_1_OE
"build_ss_est_area_5", -- Type 5: BUILD_SS_TYPE-RC Actual Estimated typical area per building (m2, by
"build_ss_plan_area_5", -- Type 5: BUILD_SS_TYPE-RC Planned typical area per building (m2, by location)
"build_ss_gps_4_refusalmsg", -- Type 4: BUILD_SS_GPS : Refusal Message
"build_ss_plan_life_4_oe", -- BUILD_SS_PLAN_LIFE_4_OE
"build_ss_non_haz_mate_4_oe", -- BUILD_SS_NON_HAZ_MATE_4_OE
"build_ss_green_std_4", -- Type 4: BUILD_SS_TYPE-RC Green building standards required by the award (e.g (-1: Don t Know, 0: No, 1: Yes; describe standards:)
"build_ss_est_area_4_2_oe", -- BUILD_SS_EST_AREA_4_2_OE
"build_ss_plan_area_4_96", -- Don t know
"build_ss_plan_area_4_1_oe", -- BUILD_SS_PLAN_AREA_4_1_OE
"build_ss_plan_area_4", -- Type 4: BUILD_SS_TYPE-RC Planned typical area per building (m2, by location)
"build_ss_act_sites_4_96", -- Don t know
"build_ss_act_sites_4_2", -- Rural:
"build_ss_act_sites_4_1_oe", -- BUILD_SS_ACT_SITES_4_1_OE
"build_ss_plan_sites_4_2_oe", -- BUILD_SS_PLAN_SITES_4_2_OE
"build_ss_gps_3_file", -- Type 3: BUILD_SS_GPS : File
"build_ss_est_life_3_oe", -- BUILD_SS_EST_LIFE_3_OE
"build_ss_est_area_4_2", -- Rural:
"build_ss_est_life_5", -- Type 5: BUILD_SS_TYPE-RC Estimated economic life of the constructed facility (-1: Don t know, 1: Years)
"build_ss_act_sites_11_1", -- Urban:
"build_ss_est_area_7_96", -- Don t know
"build_ss_est_area_7_1", -- Urban:
"build_ss_gps_7_refusalmsg", -- Type 7: BUILD_SS_GPS : Refusal Message
"build_ss_plan_sites_7_1", -- Urban:
"build_ss_plan_area_9_1_oe", -- BUILD_SS_PLAN_AREA_9_1_OE
"build_ss_plan_sites_6", -- Type 6: BUILD_SS_TYPE-RC Planned of sites (by location)
"build_ss_act_sites_4", -- Type 4: BUILD_SS_TYPE-RC Actual Estimated of sites (by location)
"build_ss_gps_8_gpscoordinates", -- Type 8: BUILD_SS_TYPE-RC GPS coordinates for all related construction struct
"build_ss_plan_area_7_1_oe", -- BUILD_SS_PLAN_AREA_7_1_OE
"build_ss_disab_3", -- Type 3: BUILD_SS_TYPE-RC Did Does the sub-award(s) incorporated design eleme (-1: Don t Know, 0: No, 1: Yes; describe standards:)
"build_ss_plan_area_8_2_oe", -- BUILD_SS_PLAN_AREA_8_2_OE
"build_ss_act_sites_11_2_oe", -- BUILD_SS_ACT_SITES_11_2_OE
"build_ss_plan_area_5_1_oe", -- BUILD_SS_PLAN_AREA_5_1_OE
"build_ss_conflict_11", -- Type 11: BUILD_SS_TYPE-RC Was Is construction in a conflict area? (-1: Don t Know, 0: No, 1: Yes)
"build_ss_non_haz_mate_5_oe", -- BUILD_SS_NON_HAZ_MATE_5_OE
"build_ss_non_haz_mate_10_1", -- BUILD_SS_NON_HAZ_MATE_10_OE
"build_ss_plan_area_9_2_oe", -- BUILD_SS_PLAN_AREA_9_2_OE
"build_ss_disab_4", -- Type 4: BUILD_SS_TYPE-RC Did Does the sub-award(s) incorporated design eleme (-1: Don t Know, 0: No, 1: Yes; describe standards:)
"build_ss_plan_area_7_2", -- Rural:
"build_ss_act_sites_10_1_oe", -- BUILD_SS_ACT_SITES_10_1_OE
"build_ss_est_life_10_oe", -- BUILD_SS_EST_LIFE_10_OE
"build_ss_rework_3", -- Type 3: BUILD_SS_TYPE-RC Rework required and not completed prior to award en (1: Yes, minor defects, 2: Yes, major defects, 3: Yes, major requirements not met; estimate not usable:, 4: Yes, completely unusable, 5: No, 6: Don t know; explain:)
"build_ss_est_area_11_2_oe", -- BUILD_SS_EST_AREA_11_2_OE
"build_ss_const_location_4", -- Type 4: BUILD_SS_TYPE-RC Construction location (1: New site no previous construction of any kind, 2: New on site with previous construction of any type, 3: Upgrade Expansion of existing facility, 4: Rehab of existing facility approximately same footprint)
"build_ss_est_area_10_1_oe", -- BUILD_SS_EST_AREA_10_1_OE
"build_ss_plan_life_8", -- Type 8: BUILD_SS_TYPE-RC Planned designed economic life of the constructed (-1: Don t know, 1: Years)
"build_ss_plan_sites_11_2_1", -- BUILD_SS_PLAN_SITES_11_2_OE
"build_ss_disab_5_oe", -- BUILD_SS_DISAB_5_OE
"build_ss_plan_sites_6_2", -- Rural:
"build_ss_act_sites_8_1_oe", -- BUILD_SS_ACT_SITES_8_1_OE
"build_ss_est_area_5_2_oe", -- BUILD_SS_EST_AREA_5_2_OE
"build_ss_est_area_7_2", -- Rural:
"build_ss_gps_4_file", -- Type 4: BUILD_SS_GPS : File
"build_ss_disab_11", -- Type 11: BUILD_SS_TYPE-RC Did Does the sub-award(s) incorporated design elem (-1: Don t Know, 0: No, 1: Yes; describe standards:)
"build_ss_plan_area_11_1_oe", -- BUILD_SS_PLAN_AREA_11_1_OE
"build_ss_est_area_8", -- Type 8: BUILD_SS_TYPE-RC Actual Estimated typical area per building (m2, by
"build_ss_plan_area_10_1", -- Urban:
"build_ss_plan_sites_6_1_oe", -- BUILD_SS_PLAN_SITES_6_1_OE
"build_ss_plan_area_7_96", -- Don t know
"build_ss_plan_life_3_oe", -- BUILD_SS_PLAN_LIFE_3_OE
"build_ss_const_location_10", -- Type 10: BUILD_SS_TYPE-RC Construction location (1: New site no previous construction of any kind, 2: New on site with previous construction of any type, 3: Upgrade Expansion of existing facility, 4: Rehab of existing facility approximately same footprint)
"build_ss_est_area_4_1", -- Urban:
"build_ss_gps_9_file", -- Type 9: BUILD_SS_GPS : File
"build_ss_energy_eff_4", -- Type 4: BUILD_SS_TYPE-RC Energy efficiency standards required by the award (-1: Don t Know, 0: No, 1: Yes)
"build_ss_plan_life_3", -- Type 3: BUILD_SS_TYPE-RC Planned designed economic life of the constructed (-1: Don t know, 1: Years)
"build_ss_est_area_8_96", -- Don t know
"build_ss_plan_area_8_2", -- Rural:
"build_ss_plan_sites_11", -- Type 11: BUILD_SS_TYPE-RC Planned of sites (by location)
"build_ss_est_area_5_1", -- Urban:
"build_ss_plan_area_6_1", -- Urban:
"build_ss_prefab_5", -- Type 5: BUILD_SS_TYPE-RC Did this facility include any major pre-fabricated (-1: Don t Know, 0: No, 1: Yes)
"build_ss_est_area_11_96", -- Don t know
"build_ss_plan_sites_8_1", -- Urban:
"build_ss_rework_9", -- Type 9: BUILD_SS_TYPE-RC Rework required and not completed prior to award en (1: Yes, minor defects, 2: Yes, major defects, 3: Yes, major requirements not met; estimate not usable:, 4: Yes, completely unusable, 5: No, 6: Don t know; explain:)
"build_ss_gps_5_file", -- Type 5: BUILD_SS_GPS : File
"build_ss_rework_9_oe", -- BUILD_SS_REWORK_9_OE
"build_ss_gps_10_file", -- Type 10: BUILD_SS_GPS : File
"build_ss_green_std_11_oe", -- BUILD_SS_GREEN_STD_11_OE
"build_ss_plan_sites_6_96", -- Don t know
"build_ss_est_area_8_2", -- Rural:
"build_ss_plan_sites_6_2_oe", -- BUILD_SS_PLAN_SITES_6_2_OE
"build_ss_const_location_9", -- Type 9: BUILD_SS_TYPE-RC Construction location (1: New site no previous construction of any kind, 2: New on site with previous construction of any type, 3: Upgrade Expansion of existing facility, 4: Rehab of existing facility approximately same footprint)
"build_ss_act_sites_7", -- Type 7: BUILD_SS_TYPE-RC Actual Estimated of sites (by location)
"build_ss_green_std_10", -- Type 10: BUILD_SS_TYPE-RC Green building standards required by the award (e. (-1: Don t Know, 0: No, 1: Yes; describe standards:)
"build_ss_act_sites_9", -- Type 9: BUILD_SS_TYPE-RC Actual Estimated of sites (by location)
"build_ss_est_area_6_2", -- Rural:
"build_ss_est_area_5_2", -- Rural:
"build_ss_non_haz_mate_11_1", -- BUILD_SS_NON_HAZ_MATE_11_OE
"build_ss_plan_sites_5_2", -- Rural:
"build_ss_est_area_5_96", -- Don t know
"build_ss_disab_9_oe", -- BUILD_SS_DISAB_9_OE
"build_ss_plan_area_8_1_oe", -- BUILD_SS_PLAN_AREA_8_1_OE
"build_ss_conflict_7", -- Type 7: BUILD_SS_TYPE-RC Was Is construction in a conflict area? (-1: Don t Know, 0: No, 1: Yes)
"build_ss_plan_area_5_2", -- Rural:
"build_ss_act_sites_8", -- Type 8: BUILD_SS_TYPE-RC Actual Estimated of sites (by location)
"build_ss_act_sites_8_2", -- Rural:
"build_ss_conflict_8", -- Type 8: BUILD_SS_TYPE-RC Was Is construction in a conflict area? (-1: Don t Know, 0: No, 1: Yes)
"build_ss_green_std_8_oe", -- BUILD_SS_GREEN_STD_8_OE
"build_ss_act_sites_10", -- Type 10: BUILD_SS_TYPE-RC Actual Estimated of sites (by location)
"build_ss_plan_sites_5_1", -- Urban:
"build_ss_plan_area_9_1", -- Urban:
"build_ss_act_sites_5_2_oe", -- BUILD_SS_ACT_SITES_5_2_OE
"build_ss_plan_area_9", -- Type 9: BUILD_SS_TYPE-RC Planned typical area per building (m2, by location)
"build_ss_est_area_9_1_oe", -- BUILD_SS_EST_AREA_9_1_OE
"build_ss_plan_area_8_96", -- Don t know
"build_ss_green_std_9", -- Type 9: BUILD_SS_TYPE-RC Green building standards required by the award (e.g (-1: Don t Know, 0: No, 1: Yes; describe standards:)
"build_ss_act_sites_9_1", -- Urban:
"build_ss_est_area_9_2", -- Rural:
"build_ss_plan_area_10_2", -- Rural:
"build_ss_est_life_9", -- Type 9: BUILD_SS_TYPE-RC Estimated economic life of the constructed facility (-1: Don t know, 1: Years)
"build_ss_plan_sites_5_2_oe", -- BUILD_SS_PLAN_SITES_5_2_OE
"build_ss_conflict_9", -- Type 9: BUILD_SS_TYPE-RC Was Is construction in a conflict area? (-1: Don t Know, 0: No, 1: Yes)
"build_ss_plan_life_9", -- Type 9: BUILD_SS_TYPE-RC Planned designed economic life of the constructed (-1: Don t know, 1: Years)
"build_ss_act_sites_11_1_oe", -- BUILD_SS_ACT_SITES_11_1_OE
"build_ss_energy_eff_7", -- Type 7: BUILD_SS_TYPE-RC Energy efficiency standards required by the award (-1: Don t Know, 0: No, 1: Yes)
"build_ss_rework_3_oe", -- BUILD_SS_REWORK_3_OE
"build_ss_act_sites_4_1", -- Urban:
"build_ss_plan_area_10_2_oe", -- BUILD_SS_PLAN_AREA_10_2_OE
"build_ss_plan_sites_4", -- Type 4: BUILD_SS_TYPE-RC Planned of sites (by location)
"build_ss_act_sites_6_96", -- Don t know
"build_ss_plan_sites_7_2", -- Rural:
"build_ss_plan_area_5_1", -- Urban:
"build_ss_act_sites_7_96", -- Don t know
"build_ss_est_life_8_oe", -- BUILD_SS_EST_LIFE_8_OE
"build_ss_disab_7_oe", -- BUILD_SS_DISAB_7_OE
"build_ss_plan_area_4_2_oe", -- BUILD_SS_PLAN_AREA_4_2_OE
"build_ss_non_haz_mate_4", -- Type 4: BUILD_SS_TYPE-RC Specifications and or clauses requiring use of saf ()
"build_ss_plan_sites_7", -- Type 7: BUILD_SS_TYPE-RC Planned of sites (by location)
"build_ss_act_sites_11_96", -- Don t know
"build_ss_gps_9_gpscoordinates", -- Type 9: BUILD_SS_TYPE-RC GPS coordinates for all related construction struct
"build_ss_est_area_11_1_oe", -- BUILD_SS_EST_AREA_11_1_OE
"build_ss_non_haz_mate_10", -- Type 10: BUILD_SS_TYPE-RC Specifications and or clauses requiring use of sa ()
"build_ss_est_area_10_2_oe", -- BUILD_SS_EST_AREA_10_2_OE
"build_ss_plan_area_11_2", -- Rural:
"build_ss_plan_sites_7_1_oe", -- BUILD_SS_PLAN_SITES_7_1_OE
"build_ss_green_std_5", -- Type 5: BUILD_SS_TYPE-RC Green building standards required by the award (e.g (-1: Don t Know, 0: No, 1: Yes; describe standards:)
"build_ss_est_area_7", -- Type 7: BUILD_SS_TYPE-RC Actual Estimated typical area per building (m2, by
"build_ss_plan_area_10_1_oe", -- BUILD_SS_PLAN_AREA_10_1_OE
"build_ss_plan_sites_4_1_oe", -- BUILD_SS_PLAN_SITES_4_1_OE
"build_ss_act_sites_8_2_oe", -- BUILD_SS_ACT_SITES_8_2_OE
"build_ss_plan_area_11", -- Type 11: BUILD_SS_TYPE-RC Planned typical area per building (m2, by location
"build_ss_conflict_5", -- Type 5: BUILD_SS_TYPE-RC Was Is construction in a conflict area? (-1: Don t Know, 0: No, 1: Yes)
"build_ss_act_sites_10_2", -- Rural:
"build_ss_rework_8", -- Type 8: BUILD_SS_TYPE-RC Rework required and not completed prior to award en (1: Yes, minor defects, 2: Yes, major defects, 3: Yes, major requirements not met; estimate not usable:, 4: Yes, completely unusable, 5: No, 6: Don t know; explain:)
"build_ss_green_std_11", -- Type 11: BUILD_SS_TYPE-RC Green building standards required by the award (e. (-1: Don t Know, 0: No, 1: Yes; describe standards:)
"build_ss_plan_sites_11_96", -- Don t know
"build_ss_plan_area_8", -- Type 8: BUILD_SS_TYPE-RC Planned typical area per building (m2, by location)
"build_ss_act_sites_8_96", -- Don t know
"build_ss_plan_sites_8_96", -- Don t know
"build_ss_plan_sites_8_2_oe", -- BUILD_SS_PLAN_SITES_8_2_OE
"build_ss_plan_sites_8_2", -- Rural:
"build_ss_const_location_8", -- Type 8: BUILD_SS_TYPE-RC Construction location (1: New site no previous construction of any kind, 2: New on site with previous construction of any type, 3: Upgrade Expansion of existing facility, 4: Rehab of existing facility approximately same footprint)
"build_ss_rework_7", -- Type 7: BUILD_SS_TYPE-RC Rework required and not completed prior to award en (1: Yes, minor defects, 2: Yes, major defects, 3: Yes, major requirements not met; estimate not usable:, 4: Yes, completely unusable, 5: No, 6: Don t know; explain:)
"build_ss_est_life_7_oe", -- BUILD_SS_EST_LIFE_7_OE
"build_ss_green_std_7", -- Type 7: BUILD_SS_TYPE-RC Green building standards required by the award (e.g (-1: Don t Know, 0: No, 1: Yes; describe standards:)
"build_ss_est_area_7_2_oe", -- BUILD_SS_EST_AREA_7_2_OE
"build_ss_plan_area_7", -- Type 7: BUILD_SS_TYPE-RC Planned typical area per building (m2, by location)
"build_ss_act_sites_7_2", -- Rural:
"build_ss_act_sites_7_1_oe", -- BUILD_SS_ACT_SITES_7_1_OE
"build_ss_plan_sites_7_96", -- Don t know
"build_ss_plan_sites_7_2_oe", -- BUILD_SS_PLAN_SITES_7_2_OE
"build_ss_gps_6_refusalmsg", -- Type 6: BUILD_SS_GPS : Refusal Message
"build_ss_gps_6_gpscoordinates", -- Type 6: BUILD_SS_TYPE-RC GPS coordinates for all related construction struct
"build_ss_plan_life_6_oe", -- BUILD_SS_PLAN_LIFE_6_OE
"build_ss_disab_6_oe", -- BUILD_SS_DISAB_6_OE
"build_ss_non_haz_mate_6", -- Type 6: BUILD_SS_TYPE-RC Specifications and or clauses requiring use of saf ()
"build_ss_plan_area_6_2_oe", -- BUILD_SS_PLAN_AREA_6_2_OE
"build_ss_act_sites_6_2_oe", -- BUILD_SS_ACT_SITES_6_2_OE
"build_ss_act_sites_6", -- Type 6: BUILD_SS_TYPE-RC Actual Estimated of sites (by location)
"build_ss_gps_5_refusalmsg", -- Type 5: BUILD_SS_GPS : Refusal Message
"build_ss_gps_5_gpscoordinates", -- Type 5: BUILD_SS_TYPE-RC GPS coordinates for all related construction struct
"build_ss_plan_life_5_oe", -- BUILD_SS_PLAN_LIFE_5_OE
"build_ss_plan_area_5_96", -- Don t know
"build_ss_plan_sites_5", -- Type 5: BUILD_SS_TYPE-RC Planned of sites (by location)
"build_ss_gps_4_gpscoordinates", -- Type 4: BUILD_SS_TYPE-RC GPS coordinates for all related construction struct
"build_ss_rework_4_oe", -- BUILD_SS_REWORK_4_OE
"build_ss_est_life_4_oe", -- BUILD_SS_EST_LIFE_4_OE
"build_ss_plan_area_8_1", -- Urban:
"build_ss_est_area_8_2_oe", -- BUILD_SS_EST_AREA_8_2_OE
"build_ss_disab_8", -- Type 8: BUILD_SS_TYPE-RC Did Does the sub-award(s) incorporated design eleme (-1: Don t Know, 0: No, 1: Yes; describe standards:)
"build_ss_est_life_8", -- Type 8: BUILD_SS_TYPE-RC Estimated economic life of the constructed facility (-1: Don t know, 1: Years)
"build_ss_prefab_9", -- Type 9: BUILD_SS_TYPE-RC Did this facility include any major pre-fabricated (-1: Don t Know, 0: No, 1: Yes)
"build_ss_plan_sites_9_1_oe", -- BUILD_SS_PLAN_SITES_9_1_OE
"build_ss_plan_sites_9_2_oe", -- BUILD_SS_PLAN_SITES_9_2_OE
"build_ss_act_sites_9_2", -- Rural:
"build_ss_act_sites_9_2_oe" -- BUILD_SS_ACT_SITES_9_2_OE
FROM
"usaid-gov/usaid-construction-assessment-subawards-section-4-kwdq-phjc:latest"."usaid_construction_assessment_subawards_section_4"
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 usaid-gov/usaid-construction-assessment-subawards-section-4-kwdq-phjc with SQL in under 60 seconds.
Query Your Local Engine
Install Splitgraph Locally
bash -c "$(curl -sL https://github.com/splitgraph/splitgraph/releases/latest/download/install.sh)"Read the installation docs.
Splitgraph Cloud is built around Splitgraph Core (GitHub), which includes a local Splitgraph Engine packaged as a Docker image. Splitgraph Cloud is basically a scaled-up version of that local Engine. When you query the Data Delivery Network or the REST API, we mount the relevant datasets in an Engine on our servers and execute your query on it.
It's possible to run this engine locally. You'll need a Mac, Windows or Linux system to install sgr, and a Docker installation to run the engine. You don't need to know how to actually use Docker; sgrcan manage the image, container and volume for you.
There are a few ways to ingest data into the local engine.
For external repositories, the Splitgraph Engine can "mount" upstream data sources by using sgr mount. This feature is built around Postgres Foreign Data Wrappers (FDW). You can write custom "mount handlers" for any upstream data source. For an example, we blogged about making a custom mount handler for HackerNews stories.
For hosted datasets (like this repository), where the author has pushed Splitgraph Images to the repository, you can "clone" and/or "checkout" the data using sgr cloneand sgr checkout.
Cloning Data
Because usaid-gov/usaid-construction-assessment-subawards-section-4-kwdq-phjc:latest is a Splitgraph Image, you can clone the data from Spltgraph Cloud to your local engine, where you can query it like any other Postgres database, using any of your existing tools.
First, install Splitgraph if you haven't already.
Clone the metadata with sgr clone
This will be quick, and does not download the actual data.
sgr clone usaid-gov/usaid-construction-assessment-subawards-section-4-kwdq-phjcCheckout the data
Once you've cloned the data, you need to "checkout" the tag that you want. For example, to checkout the latest tag:
sgr checkout usaid-gov/usaid-construction-assessment-subawards-section-4-kwdq-phjc:latestThis will download all the objects for the latest tag of usaid-gov/usaid-construction-assessment-subawards-section-4-kwdq-phjc and load them into the Splitgraph Engine. Depending on your connection speed and the size of the data, you will need to wait for the checkout to complete. Once it's complete, you will be able to query the data like you would any other Postgres database.
Alternatively, use "layered checkout" to avoid downloading all the data
The data in usaid-gov/usaid-construction-assessment-subawards-section-4-kwdq-phjc:latest is 0 bytes. If this is too big to download all at once, or perhaps you only need to query a subset of it, you can use a layered checkout.:
sgr checkout --layered usaid-gov/usaid-construction-assessment-subawards-section-4-kwdq-phjc:latestThis will not download all the data, but it will create a schema comprised of foreign tables, that you can query as you would any other data. Splitgraph will lazily download the required objects as you query the data. In some cases, this might be faster or more efficient than a regular checkout.
Read the layered querying documentation to learn about when and why you might want to use layered queries.
Query the data with your existing tools
Once you've loaded the data into your local Splitgraph Engine, you can query it with any of your existing tools. As far as they're concerned, usaid-gov/usaid-construction-assessment-subawards-section-4-kwdq-phjc is just another Postgres schema.