usaid-gov/guatemala-food-consumption-data-section-2-7u62-dnwx

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 procotol. 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 guatemala_food_consumption_data_section_2 table in this repository, by referencing it like:

"usaid-gov/guatemala-food-consumption-data-section-2-7u62-dnwx:latest"."guatemala_food_consumption_data_section_2"

or in a full query, like:

SELECT 
    ":id", -- Socrata column ID
    "h105_071", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Pea Pounds
    "h103b_051", -- UNIT CONSUMED IN PAST 7 DAYS Edible oil Liters milliliters
    "h105_054", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Margarine Bars
    "h104b_083", -- UNIT FROM PURCHASES Lemons Units
    "h107a_059", -- AMOUNT OF GIFTS AND OTHER SOURCES Cabbage Units
    "h105_083", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Lemons Units
    "h106b_074", -- OWN PRODUCTION UNIT Green Beans Pounds
    "h103a_083", -- AMOUNT CONSUMED IN PAST 7 DAYS Lemons Units
    "h104a_057", -- AMOUNT FROM PURCHASES Onion Pounds
    "h104a_065", -- AMOUNT FROM PURCHASES Garlic Unit Head
    "h102_068", -- CONSUMPTION IN PAST 7 DAYS Celery Units
    "h106b_080", -- OWN PRODUCTION UNIT Apples Pounds Units
    "h106a_063", -- OWN PRODUCTION AMOUNT Cucumber Units
    "h102_064", -- CONSUMPTION IN PAST 7 DAYS Beet Units
    "h105_073", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Cauliflower Units
    "h103b_058", -- UNIT CONSUMED IN PAST 7 DAYS Chiles Pounds Units
    "h107a_081", -- AMOUNT OF GIFTS AND OTHER SOURCES Watermelons Units Portion
    "h104b_081", -- UNIT FROM PURCHASES Watermelons Units Portion
    "h106b_081", -- OWN PRODUCTION UNIT Watermelons Units Portion
    "h107a_074", -- AMOUNT OF GIFTS AND OTHER SOURCES Beans Pounds
    "h103b_070", -- UNIT CONSUMED IN PAST 7 DAYS Yuca Pounds
    "h107b_070", -- UNIT GIFTS AND OTHER SOURCES Yuca Pounds
    "h104b_054", -- UNIT FROM PURCHASES Margarine Bars
    "h106b_056", -- OWN PRODUCTION UNIT Tomato Pounds
    "h104b_077", -- UNIT FROM PURCHASES Bananas bananas Units
    "h102_058", -- CONSUMPTION IN PAST 7 DAYS Chiles Pounds Units
    "h103a_077", -- AMOUNT CONSUMED IN PAST 7 DAYS Bananas bananas Units
    "h103b_055", -- UNIT CONSUMED IN PAST 7 DAYS Mayonnaise and dressings Grams
    "h104b_064", -- UNIT FROM PURCHASES Beet Units
    "h105_048", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Yoghurt Grams
    "h106a_053", -- OWN PRODUCTION AMOUNT Lard Pounds
    "h104b_068", -- UNIT FROM PURCHASES Celery Units
    "h104a_051", -- AMOUNT FROM PURCHASES Edible oil Liters milliliters
    "h107b_054", -- UNIT GIFTS AND OTHER SOURCES Margarine Bars
    "h103b_079", -- UNIT CONSUMED IN PAST 7 DAYS Pineapple Units Portion
    "h102_069", -- CONSUMPTION IN PAST 7 DAYS Potatoes Pounds
    "h102_061", -- CONSUMPTION IN PAST 7 DAYS chayote Units
    "h106b_073", -- OWN PRODUCTION UNIT Cauliflower Units
    "h107a_060", -- AMOUNT OF GIFTS AND OTHER SOURCES Carrot Units
    "h104a_059", -- AMOUNT FROM PURCHASES Cabbage Units
    "h107a_083", -- AMOUNT OF GIFTS AND OTHER SOURCES Lemons Units
    "h107a_070", -- AMOUNT OF GIFTS AND OTHER SOURCES Yuca Pounds
    "h104a_055", -- AMOUNT FROM PURCHASES Mayonnaise and dressings Grams
    "id",
    "h104b_060", -- UNIT FROM PURCHASES Carrot Units
    "h106b_072", -- OWN PRODUCTION UNIT Broccoli Units
    "h106b_083", -- OWN PRODUCTION UNIT Lemons Units
    "h104b_066", -- UNIT FROM PURCHASES Herbs like watercress parsley macuy cilantro mint chipilin etc Bunch
    "h107a_047", -- AMOUNT OF GIFTS AND OTHER SOURCES Fresh drive Pounds
    "h107b_052", -- UNIT GIFTS AND OTHER SOURCES Shortening Pounds
    "h106b_048", -- OWN PRODUCTION UNIT Yoghurt Grams
    "h107b_069", -- UNIT GIFTS AND OTHER SOURCES Potatoes Pounds
    "h107a_075", -- AMOUNT OF GIFTS AND OTHER SOURCES g icoy Units
    "h103b_078", -- UNIT CONSUMED IN PAST 7 DAYS Oranges Units
    "h103b_083", -- UNIT CONSUMED IN PAST 7 DAYS Lemons Units
    "h107a_055", -- AMOUNT OF GIFTS AND OTHER SOURCES Mayonnaise and dressings Grams
    "h106b_070", -- OWN PRODUCTION UNIT Yuca Pounds
    "h106b_061", -- OWN PRODUCTION UNIT chayote Units
    "h103b_061", -- UNIT CONSUMED IN PAST 7 DAYS chayote Units
    "h106b_075", -- OWN PRODUCTION UNIT g icoy Units
    "h102_082", -- CONSUMPTION IN PAST 7 DAYS Mangos Units
    "h106a_065", -- OWN PRODUCTION AMOUNT Garlic Unit Head
    "h106a_047", -- OWN PRODUCTION AMOUNT Fresh drive Pounds
    "h104b_078", -- UNIT FROM PURCHASES Oranges Units
    "h107b_061", -- UNIT GIFTS AND OTHER SOURCES chayote Units
    "h104b_051", -- UNIT FROM PURCHASES Edible oil Liters milliliters
    "h107b_060", -- UNIT GIFTS AND OTHER SOURCES Carrot Units
    "h106b_052", -- OWN PRODUCTION UNIT Shortening Pounds
    "h102_060", -- CONSUMPTION IN PAST 7 DAYS Carrot Units
    "h104a_053", -- AMOUNT FROM PURCHASES Lard Pounds
    "h104b_069", -- UNIT FROM PURCHASES Potatoes Pounds
    "h107b_065", -- UNIT GIFTS AND OTHER SOURCES Garlic Unit Head
    "h104b_075", -- UNIT FROM PURCHASES g icoy Units
    "h107b_068", -- UNIT GIFTS AND OTHER SOURCES Celery Units
    "h107b_081", -- UNIT GIFTS AND OTHER SOURCES Watermelons Units Portion
    "h106b_062", -- OWN PRODUCTION UNIT Lettuce Units
    "h106a_056", -- OWN PRODUCTION AMOUNT Tomato Pounds
    "h106b_076", -- OWN PRODUCTION UNIT Bananas Units
    "h106b_058", -- OWN PRODUCTION UNIT Chiles Pounds Units
    "h106a_069", -- OWN PRODUCTION AMOUNT Potatoes Pounds
    "h105_066", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Herbs like watercress parsley macuy cilantro mint chipilin etc Bunch
    "h106a_083", -- OWN PRODUCTION AMOUNT Lemons Units
    "h106b_077", -- OWN PRODUCTION UNIT Bananas bananas Units
    "h103b_064", -- UNIT CONSUMED IN PAST 7 DAYS Beet Units
    "h103a_056", -- AMOUNT CONSUMED IN PAST 7 DAYS Tomato Pounds
    "h103b_065", -- UNIT CONSUMED IN PAST 7 DAYS Garlic Unit Head
    "h103b_068", -- UNIT CONSUMED IN PAST 7 DAYS Celery Units
    "h103a_058", -- AMOUNT CONSUMED IN PAST 7 DAYS Chiles Pounds Units
    "h103a_051", -- AMOUNT CONSUMED IN PAST 7 DAYS Edible oil Liters milliliters
    "h104b_074", -- UNIT FROM PURCHASES Beans Pounds
    "h106b_079", -- OWN PRODUCTION UNIT Pineapple Units Portion
    "h102_074", -- CONSUMPTION IN PAST 7 DAYS Beans Pounds
    "h104b_079", -- UNIT FROM PURCHASES Pineapple Units Portion
    "h103a_071", -- AMOUNT CONSUMED IN PAST 7 DAYS Pea Pounds
    "h105_055", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Mayonnaise and dressings Grams
    "h103b_053", -- UNIT CONSUMED IN PAST 7 DAYS Lard Pounds
    "h107b_064", -- UNIT GIFTS AND OTHER SOURCES Beet Units
    "h104b_053", -- UNIT FROM PURCHASES Lard Pounds
    "h104a_049", -- AMOUNT FROM PURCHASES Butter Pounds
    "h102_070", -- CONSUMPTION IN PAST 7 DAYS Yuca Pounds
    "h107a_068", -- AMOUNT OF GIFTS AND OTHER SOURCES Celery Units
    "h103b_063", -- UNIT CONSUMED IN PAST 7 DAYS Cucumber Units
    "h107a_056", -- AMOUNT OF GIFTS AND OTHER SOURCES Tomato Pounds
    "h106a_077", -- OWN PRODUCTION AMOUNT Bananas bananas Units
    "h107a_062", -- AMOUNT OF GIFTS AND OTHER SOURCES Lettuce Units
    "h103b_071", -- UNIT CONSUMED IN PAST 7 DAYS Pea Pounds
    "h105_082", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Mangos Units
    "h106a_066", -- OWN PRODUCTION AMOUNT Herbs like watercress parsley macuy cilantro mint chipilin etc Bunch
    "h105_069", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Potatoes Pounds
    "h105_056", -- MONETARY AMOUNT IN 7 DAYS CONSUMPTION Tomate Pounds
    "h104b_082", -- UNIT FROM PURCHASES Mangos Units
    "h103a_057", -- AMOUNT CONSUMED IN PAST 7 DAYS Onion Pounds
    "h104a_061", -- AMOUNT FROM PURCHASES chayote Units
    "h104b_059", -- UNIT FROM PURCHASES Cabbage Units
    "h107a_082", -- AMOUNT OF GIFTS AND OTHER SOURCES Mangos Units
    "h103a_078", -- AMOUNT CONSUMED IN PAST 7 DAYS Oranges Units
    "h104a_070", -- AMOUNT FROM PURCHASES Yuca Pounds
    "h105_070", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Yuca Pounds
    "h104b_055", -- UNIT FROM PURCHASES Mayonnaise and dressings Grams
    "h107b_049", -- UNIT GIFTS AND OTHER SOURCES Butter Pounds
    "h103b_062", -- UNIT CONSUMED IN PAST 7 DAYS Lettuce Units
    "h103a_064", -- AMOUNT CONSUMED IN PAST 7 DAYS Beet Units
    "h107b_051", -- UNIT GIFTS AND OTHER SOURCES Edible oil Liters milliliters
    "h103b_054", -- UNIT CONSUMED IN PAST 7 DAYS Margarine Bars
    "h103b_059", -- UNIT CONSUMED IN PAST 7 DAYS Cabbage Units
    "h107a_077", -- AMOUNT OF GIFTS AND OTHER SOURCES Bananas bananas Units
    "h103b_052", -- UNIT CONSUMED IN PAST 7 DAYS Shortening Pounds
    "h102_053", -- CONSUMPTION IN PAST 7 DAYS Lard Pounds
    "h103a_060", -- AMOUNT CONSUMED IN PAST 7 DAYS Carrot Units
    "h107a_058", -- AMOUNT OF GIFTS AND OTHER SOURCES Chiles Pounds Units
    "h107b_083", -- UNIT GIFTS AND OTHER SOURCES Lemons Units
    "h103a_072", -- AMOUNT CONSUMED IN PAST 7 DAYS Broccoli Units
    "h102_075", -- CONSUMPTION IN PAST 7 DAYS g icoy Units
    "h102_065", -- CONSUMPTION IN PAST 7 DAYS Garlic Unit Head
    "h107b_053", -- UNIT GIFTS AND OTHER SOURCES Lard Pounds
    "h104b_076", -- UNIT FROM PURCHASES Bananas Units
    "h104b_052", -- UNIT FROM PURCHASES Shortening Pounds
    "h102_052", -- CONSUMPTION IN PAST 7 DAYS Shortening Pounds
    "h107b_079", -- UNIT GIFTS AND OTHER SOURCES Pineapple Units Portion
    "h107b_075", -- UNIT GIFTS AND OTHER SOURCES g icoy Units
    "h103a_074", -- AMOUNT CONSUMED IN PAST 7 DAYS Beans Pounds
    "h104a_068", -- AMOUNT FROM PURCHASES Celery Units
    "h106b_059", -- OWN PRODUCTION UNIT Cabbage Units
    "h107b_077", -- UNIT GIFTS AND OTHER SOURCES Bananas bananas Units
    "h102_085", -- CONSUMPTION IN PAST 7 DAYS Avocado Units
    "h103a_075", -- AMOUNT CONSUMED IN PAST 7 DAYS g icoy Units
    "h103b_080", -- UNIT CONSUMED IN PAST 7 DAYS Apples Pounds Units
    "h106a_071", -- OWN PRODUCTION AMOUNT Pea Pounds
    "h105_074", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Beans Pounds
    "h103a_066", -- AMOUNT CONSUMED IN PAST 7 DAYS Herbs like watercress parsley macuy cilantro mint chipilin etc Bunch
    "h102_080", -- CONSUMPTION IN PAST 7 DAYS Apples Pounds Units
    "h103a_062", -- AMOUNT CONSUMED IN PAST 7 DAYS Lettuce Units
    "h103b_060", -- UNIT CONSUMED IN PAST 7 DAYS Carrot Units
    "h103a_054", -- AMOUNT CONSUMED IN PAST 7 DAYS Margarine Bars
    "h105_059", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Cabbage Units
    "h104b_049", -- UNIT FROM PURCHASES Butter Pounds
    "h103a_079", -- AMOUNT CONSUMED IN PAST 7 DAYS Pineapple Units Portion
    "h106a_048", -- OWN PRODUCTION AMOUNT Yoghurt Grams
    "h106a_062", -- OWN PRODUCTION AMOUNT Lettuce Units
    "h103b_073", -- UNIT CONSUMED IN PAST 7 DAYS Cauliflower Units
    "h105_053", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Lard Pounds
    "h104a_062", -- AMOUNT FROM PURCHASES Lettuce Units
    "h102_081", -- CONSUMPTION IN PAST 7 DAYS Watermelons Units Portion
    "h104b_080", -- UNIT FROM PURCHASES Apples Pounds Units
    "h104b_061", -- UNIT FROM PURCHASES chayote Units
    "h103b_049", -- UNIT CONSUMED IN PAST 7 DAYS Butter Pounds
    "h105_075", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES g icoy Units
    "h105_063", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Cucumber Units
    "h104a_075", -- AMOUNT FROM PURCHASES g icoy Units
    "h104a_078", -- AMOUNT FROM PURCHASES Oranges Units
    "h107a_061", -- AMOUNT OF GIFTS AND OTHER SOURCES chayote Units
    "h102_055", -- CONSUMPTION IN PAST 7 DAYS Mayonnaise and dressings Grams
    "h106a_070", -- OWN PRODUCTION AMOUNT Yuca Pounds
    "h103a_065", -- AMOUNT CONSUMED IN PAST 7 DAYS Garlic Unit Head
    "h103b_047", -- UNIT CONSUMED IN PAST 7 DAYS Fresh drive Pounds
    "h107b_059", -- UNIT GIFTS AND OTHER SOURCES Cabbage Units
    "h104b_065", -- UNIT FROM PURCHASES Garlic Unit Head
    "h104a_072", -- AMOUNT FROM PURCHASES Broccoli Units
    "h107b_082", -- UNIT GIFTS AND OTHER SOURCES Mangos Units
    "h106a_076", -- OWN PRODUCTION AMOUNT Bananas Units
    "h102_078", -- CONSUMPTION IN PAST 7 DAYS Oranges Units
    "h105_065", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Garlic Unit Head
    "h105_078", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Oranges Units
    "h102_077", -- CONSUMPTION IN PAST 7 DAYS Bananas bananas Units
    "h102_066", -- CONSUMPTION IN PAST 7 DAYS Herbs like watercress parsley macuy cilantro mint chipilin etc Bunch
    "h106a_079", -- OWN PRODUCTION AMOUNT Pineapple Units Portion
    "h105_079", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Pineapple Units Portion
    "h106b_049", -- OWN PRODUCTION UNIT Butter Pounds
    "h106a_081", -- OWN PRODUCTION AMOUNT Watermelons Units Portion
    "h106a_058", -- OWN PRODUCTION AMOUNT Chiles Pounds Units
    "h103b_048", -- UNIT CONSUMED IN PAST 7 DAYS Yoghurt Grams
    "h106a_075", -- OWN PRODUCTION AMOUNT g icoy Units
    "h104b_070", -- UNIT FROM PURCHASES Yuca Pounds
    "h106a_054", -- OWN PRODUCTION AMOUNT Margarine Bars
    "h105_080", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Apples Pounds Units
    "h105_068", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Celery Units
    "h107b_072", -- UNIT GIFTS AND OTHER SOURCES Broccoli Units
    "h106b_060", -- OWN PRODUCTION UNIT Carrot Units
    "h104a_064", -- AMOUNT FROM PURCHASES Beet Units
    "h106b_051", -- OWN PRODUCTION UNIT Edible oil Liters milliliters
    "h104b_073", -- UNIT FROM PURCHASES Cauliflower Units
    "h103a_049", -- AMOUNT CONSUMED IN PAST 7 DAYS Butter Pounds
    "h107b_074", -- UNIT GIFTS AND OTHER SOURCES Beans Pounds
    "h104a_048", -- AMOUNT FROM PURCHASES Yoghurt Grams
    "h107a_048", -- AMOUNT OF GIFTS AND OTHER SOURCES Yoghurt Grams
    "h106a_072", -- OWN PRODUCTION AMOUNT Broccoli Units
    "h103a_069", -- AMOUNT CONSUMED IN PAST 7 DAYS Potatoes Pounds
    "h103a_063", -- AMOUNT CONSUMED IN PAST 7 DAYS Cucumber Units
    "h105_058", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Chiles Pounds Units
    "h104a_060", -- AMOUNT FROM PURCHASES Carrot Units
    "h104a_056", -- AMOUNT FROM PURCHASES Tomato Pounds
    "h104a_083", -- AMOUNT FROM PURCHASES Lemons Units
    "h107a_052", -- AMOUNT OF GIFTS AND OTHER SOURCES Shortening Pounds
    "h104a_079", -- AMOUNT FROM PURCHASES Pineapple Units Portion
    "h103a_081", -- AMOUNT CONSUMED IN PAST 7 DAYS Watermelons Units Portion
    "h105_062", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Lettuce Units
    "h105_047", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Fresh drive Pounds
    "h106a_064", -- OWN PRODUCTION AMOUNT Beet Units
    "h107a_053", -- AMOUNT OF GIFTS AND OTHER SOURCES Lard Pounds
    "h103a_070", -- AMOUNT CONSUMED IN PAST 7 DAYS Yuca Pounds
    "h104a_058", -- AMOUNT FROM PURCHASES Chiles Pounds Units
    "h107a_064", -- AMOUNT OF GIFTS AND OTHER SOURCES Beet Units
    "h105_076", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Bananas Units
    "h106b_068", -- OWN PRODUCTION UNIT Celery Units
    "h102_072", -- CONSUMPTION IN PAST 7 DAYS Broccoli Units
    "h102_076", -- CONSUMPTION IN PAST 7 DAYS Bananas Units
    "h106b_064", -- OWN PRODUCTION UNIT Beet Units
    "h107a_079", -- AMOUNT OF GIFTS AND OTHER SOURCES Pineapple Units Portion
    "h106b_054", -- OWN PRODUCTION UNIT Margarine Bars
    "h106b_066", -- OWN PRODUCTION UNIT Herbs like watercress parsley macuy cilantro mint chipilin etc Bunch
    "h103b_075", -- UNIT CONSUMED IN PAST 7 DAYS g icoy Units
    "h107a_069", -- AMOUNT OF GIFTS AND OTHER SOURCES Potatoes Pounds
    "h106b_065", -- OWN PRODUCTION UNIT Garlic Unit Head
    "h103a_053", -- AMOUNT CONSUMED IN PAST 7 DAYS Lard Pounds
    "h104b_056", -- UNIT FROM PURCHASES Tomato Pounds
    "h104b_062", -- UNIT FROM PURCHASES Lettuce Units
    "h103a_073", -- AMOUNT CONSUMED IN PAST 7 DAYS Cauliflower Units
    "h104b_063", -- UNIT FROM PURCHASES Cucumber Units
    "h106a_080", -- OWN PRODUCTION AMOUNT Apples Pounds Units
    "h107a_078", -- AMOUNT OF GIFTS AND OTHER SOURCES Oranges Units
    "h107a_065", -- AMOUNT OF GIFTS AND OTHER SOURCES Garlic Unit Head
    "h105_081", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Watermelons Units Portion
    "h107a_080", -- AMOUNT OF GIFTS AND OTHER SOURCES Apples Pounds Units
    "h102_063", -- CONSUMPTION IN PAST 7 DAYS Cucumber Units
    "h105_060", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Carrot Units
    "h106b_053", -- OWN PRODUCTION UNIT Lard Pounds
    "h104a_073", -- AMOUNT FROM PURCHASES Cauliflower Units
    "h107b_047", -- UNIT GIFTS AND OTHER SOURCES Fresh drive Pounds
    "h106a_074", -- OWN PRODUCTION AMOUNT Beans Pounds
    "h107b_080", -- UNIT GIFTS AND OTHER SOURCES Apples Pounds Units
    "h104a_054", -- AMOUNT FROM PURCHASES Margarine Bars
    "h105_049", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Butter Pounds
    "h103a_082", -- AMOUNT CONSUMED IN PAST 7 DAYS Mangos Units
    "h104a_071", -- AMOUNT FROM PURCHASES Pea Pounds
    "h107a_063", -- AMOUNT OF GIFTS AND OTHER SOURCES Cucumber Units
    "h104a_063", -- AMOUNT FROM PURCHASES Cucumber Units
    "h107b_073", -- UNIT GIFTS AND OTHER SOURCES Cauliflower Units
    "h106b_071", -- OWN PRODUCTION UNIT Pea Pounds
    "h103a_048", -- AMOUNT CONSUMED IN PAST 7 DAYS Yoghurt Grams
    "h106b_057", -- OWN PRODUCTION UNIT Onion Pounds
    "h104a_047", -- AMOUNT FROM PURCHASES Fresh drive Pounds
    "h107b_066", -- UNIT GIFTS AND OTHER SOURCES Herbs like watercress parsley macuy cilantro mint chipilin etc Bunch
    "h102_051", -- CONSUMPTION IN PAST 7 DAYS Edible oil Liters milliliters
    "h107b_056", -- UNIT GIFTS AND OTHER SOURCES Tomato Pounds
    "h104a_080", -- AMOUNT FROM PURCHASES Apples Pounds Units
    "h106a_057", -- OWN PRODUCTION AMOUNT Onion Pounds
    "h104b_071", -- UNIT FROM PURCHASES Pea Pounds
    "h107a_051", -- AMOUNT OF GIFTS AND OTHER SOURCES Edible oil Liters milliliters
    "h106a_049", -- OWN PRODUCTION AMOUNT Butter Pounds
    "h103b_076", -- UNIT CONSUMED IN PAST 7 DAYS Bananas Units
    "h106a_061", -- OWN PRODUCTION AMOUNT chayote Units
    "h103b_081", -- UNIT CONSUMED IN PAST 7 DAYS Watermelons Units Portion
    "h107a_072", -- AMOUNT OF GIFTS AND OTHER SOURCES Broccoli Units
    "h102_079", -- CONSUMPTION IN PAST 7 DAYS Pineapple Units Portion
    "h102_054", -- CONSUMPTION IN PAST 7 DAYS Margarine Bars
    "h105_077", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Bananas bananas Units
    "h102_056", -- PAST 7 DAYS CONSUMPTION Tomate Pounds
    "h104a_074", -- AMOUNT FROM PURCHASES Beans Pounds
    "h106b_063", -- OWN PRODUCTION UNIT Cucumber Units
    "h106a_055", -- OWN PRODUCTION AMOUNT Mayonnaise and dressings Grams
    "h107a_073", -- AMOUNT OF GIFTS AND OTHER SOURCES Cauliflower Units
    "h102_059", -- CONSUMPTION IN PAST 7 DAYS Cabbage Units
    "h106a_052", -- OWN PRODUCTION AMOUNT Shortening Pounds
    "h105_052", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Shortening Pounds
    "h102_057", -- CONSUMPTION IN PAST 7 DAYS Onion Pounds
    "h107b_078", -- UNIT GIFTS AND OTHER SOURCES Oranges Units
    "h105_061", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES chayote Units
    "h103b_057", -- UNIT CONSUMED IN PAST 7 DAYS Onion Pounds
    "h104a_081", -- AMOUNT FROM PURCHASES Watermelons Units Portion
    "h106b_055", -- OWN PRODUCTION UNIT Mayonnaise and dressings Grams
    "h105_064", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Beet Units
    "h103b_077", -- UNIT CONSUMED IN PAST 7 DAYS Bananas bananas Units
    "h107a_071", -- AMOUNT OF GIFTS AND OTHER SOURCES Pea Pounds
    "h104a_066", -- AMOUNT FROM PURCHASES Herbs like watercress parsley macuy cilantro mint chipilin etc Bunch
    "h104b_057", -- UNIT FROM PURCHASES Onion Pounds
    "h103a_076", -- AMOUNT CONSUMED IN PAST 7 DAYS Bananas Units
    "h107a_076", -- AMOUNT OF GIFTS AND OTHER SOURCES Bananas Units
    "h104a_052", -- AMOUNT FROM PURCHASES Shortening Pounds
    "h102_062", -- CONSUMPTION IN PAST 7 DAYS Lettuce Units
    "h103a_061", -- AMOUNT CONSUMED IN PAST 7 DAYS chayote Units
    "h102_049", -- CONSUMPTION IN PAST 7 DAYS Butter Pounds
    "h103a_047", -- AMOUNT CONSUMED IN PAST 7 DAYS Fresh drive Pounds
    "h103b_074", -- UNIT CONSUMED IN PAST 7 DAYS Beans Pounds
    "h104b_072", -- UNIT FROM PURCHASES Broccoli Units
    "h102_048", -- CONSUMPTION IN PAST 7 DAYS Yoghurt Grams
    "h103b_082", -- UNIT CONSUMED IN PAST 7 DAYS Mangos Units
    "h106a_082", -- OWN PRODUCTION AMOUNT Mangos Units
    "h107a_054", -- AMOUNT OF GIFTS AND OTHER SOURCES Margarine Bars
    "h102_083", -- CONSUMPTION IN PAST 7 DAYS Lemons Units
    "h102_073", -- CONSUMPTION IN PAST 7 DAYS Cauliflower Units
    "h103b_066", -- UNIT CONSUMED IN PAST 7 DAYS Herbs like watercress parsley macuy cilantro mint chipilin etc Bunch
    "h107b_057", -- UNIT GIFTS AND OTHER SOURCES Onion Pounds
    "h106a_068", -- OWN PRODUCTION AMOUNT Celery Units
    "h105_057", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Onion Pounds
    "h103a_080", -- AMOUNT CONSUMED IN PAST 7 DAYS Apples Pounds Units
    "h104a_077", -- AMOUNT FROM PURCHASES Bananas bananas Units
    "h106b_078", -- OWN PRODUCTION UNIT Oranges Units
    "h106b_069", -- OWN PRODUCTION UNIT Potatoes Pounds
    "h103a_052", -- AMOUNT CONSUMED IN PAST 7 DAYS Shortening Pounds
    "h103a_059", -- AMOUNT CONSUMED IN PAST 7 DAYS Cabbage Units
    "h103b_072", -- UNIT CONSUMED IN PAST 7 DAYS Broccoli Units
    "h105_072", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Broccoli Units
    "h107b_055", -- UNIT GIFTS AND OTHER SOURCES Mayonnaise and dressings Grams
    "h107b_076", -- UNIT GIFTS AND OTHER SOURCES Bananas Units
    "h104a_069", -- AMOUNT FROM PURCHASES Potatoes Pounds
    "h106b_082", -- OWN PRODUCTION UNIT Mangos Units
    "h106a_078", -- OWN PRODUCTION AMOUNT Oranges Units
    "h103b_069", -- UNIT CONSUMED IN PAST 7 DAYS Potatoes Pounds
    "h105_051", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Edible oil Liters milliliters
    "h107b_063", -- UNIT GIFTS AND OTHER SOURCES Cucumber Units
    "h107b_058", -- UNIT GIFTS AND OTHER SOURCES Chiles Pounds Units
    "h104a_082", -- AMOUNT FROM PURCHASES Mangos Units
    "h104b_058", -- UNIT FROM PURCHASES Chiles Pounds Units
    "h103a_068", -- AMOUNT CONSUMED IN PAST 7 DAYS Celery Units
    "h106a_060", -- OWN PRODUCTION AMOUNT Carrot Units
    "h106b_047", -- OWN PRODUCTION UNIT Fresh drive Pounds
    "h106a_059", -- OWN PRODUCTION AMOUNT Cabbage Units
    "h104b_047", -- UNIT FROM PURCHASES Fresh drive Pounds
    "h107a_057", -- AMOUNT OF GIFTS AND OTHER SOURCES Onion Pounds
    "h107b_062", -- UNIT GIFTS AND OTHER SOURCES Lettuce Units
    "h106a_051", -- OWN PRODUCTION AMOUNT Edible oil Liters milliliters
    "h107a_066", -- AMOUNT OF GIFTS AND OTHER SOURCES Herbs like watercress parsley macuy cilantro mint chipilin etc Bunch
    "h104b_048", -- UNIT FROM PURCHASES Yoghurt Grams
    "h103b_056", -- UNIT CONSUMED IN PAST 7 DAYS Tomato Pounds
    "h107b_071", -- UNIT GIFTS AND OTHER SOURCES Pea Pounds
    "h102_071", -- CONSUMPTION IN PAST 7 DAYS Pea Pounds
    "h103a_055", -- AMOUNT CONSUMED IN PAST 7 DAYS Mayonnaise and dressings Grams
    "h107a_049", -- AMOUNT OF GIFTS AND OTHER SOURCES Butter Pounds
    "h107b_048", -- UNIT GIFTS AND OTHER SOURCES Yoghurt Grams
    "h106a_073", -- OWN PRODUCTION AMOUNT Cauliflower Units
    "h104a_076" -- AMOUNT FROM PURCHASES Bananas Units
FROM
    "usaid-gov/guatemala-food-consumption-data-section-2-7u62-dnwx:latest"."guatemala_food_consumption_data_section_2"
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/guatemala-food-consumption-data-section-2-7u62-dnwx with SQL in under 60 seconds.

This repository is an "external" repository. That means it's hosted elsewhere, in this case at data.usaid.gov. When you queryusaid-gov/guatemala-food-consumption-data-section-2-7u62-dnwx: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 data.usaid.gov, 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 \
  "usaid-gov/guatemala-food-consumption-data-section-2-7u62-dnwx" \
  --handler-options '{
    "domain": "data.usaid.gov",
    "tables": {
        "guatemala_food_consumption_data_section_2": "7u62-dnwx"
    }
}'

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, usaid-gov/guatemala-food-consumption-data-section-2-7u62-dnwx is just another Postgres schema.

Related Documentation: