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