usaid-gov/guatemala-food-consumption-data-section-5-k2ft-ssjh
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 guatemala_food_consumption_data_section_5 table in this repository, by referencing it like:

"usaid-gov/guatemala-food-consumption-data-section-5-k2ft-ssjh:latest"."guatemala_food_consumption_data_section_5"

or in a full query, like:

SELECT
    ":id", -- Socrata column ID
    "exceptional_15", -- Daily per capita consumption 2013 GTQ Reparacion y mantenimiento de vehiculos Incluya repuestos lubricantes mano de obra llantas etc
    "exceptional_31", -- Daily per capita consumption 2013 GTQ mensualidad escolar o colegiatura
    "exceptional_total", -- Total exceptional expenditures Daily per capita in 2013 GTQ
    "rent_paid", -- Daily rent paid assumed or actual
    "asset_3", -- Asset ownership molino manual de nixtamal
    "asset_6", -- Asset ownership computadora
    "asset_9", -- Asset ownership radio transistor
    "asset_11", -- Asset ownership panel solar
    "asset_16", -- Asset ownership calentador de agua
    "asset_17", -- Asset ownership silo met lico para guardar granos
    "asset_18", -- Asset ownership autom vil pick up camionetilla
    "asset_21", -- Asset ownership bicicleta
    "asset_14", -- Asset ownership ventilador
    "h101_064", -- ITEM Beet Units
    "asset_13", -- Asset ownership lavadora de ropa
    "h101_108", -- ITEM Cigarettes Units
    "h101_072", -- ITEM Broccoli Units
    "h101_099", -- ITEM Purified water Liters milliliters
    "asset_1", -- Asset ownership estufa a gas o el ctrica
    "h101_083", -- ITEM Lemons Units
    "h101_055", -- ITEM Mayonnaise and dressings Grams
    "h101_091", -- ITEM Pears Units
    "h101_117", -- ITEM Spending at restaurants food soda beer juice or other drinks or foods
    "h601_240", -- ITEM truck
    "h101_027", -- ITEM Beef Pounds
    "h101_038", -- ITEM Seafood shrimp crabs Pounds
    "h101_056", -- ITEM Tomato Pounds
    "h101_004", -- ITEM Pan small unit medium large
    "h603_236", -- NUMBER OF GOODS car pick up waiting van
    "h101_013", -- ITEM Sugar Pounds
    "h602_236", -- POSSESSION OF PROPERTY car pick up waiting van
    "h607_240", -- MONETARY VALUE PAID FOR PROPERTY IN PAST 12 MONTHS truck
    "h101_011", -- ITEM Atoles corn glass
    "h607_235a", -- MONETARY VALUE PAID FOR PROPERTY IN PAST 12 MONTHS Other household items
    "h601_239", -- ITEM moto scooter
    "h602_239", -- POSSESSION OF PROPERTY moto scooter
    "h604_239", -- REAL AGE moto scooter
    "h605_239", -- MONETARY VALUE OF PROPERTY moto scooter
    "h606_239", -- GOODS PURCHASED IN PAST 12 MONTHS moto scooter
    "h607_239", -- MONETARY VALUE PAID FOR PROPERTY IN PAST 12 MONTHS moto scooter
    "h603_241", -- NUMBER OF GOODS bike
    "h607_241", -- MONETARY VALUE PAID FOR PROPERTY IN PAST 12 MONTHS bike
    "h601_244", -- ITEM Other
    "h603_244", -- NUMBER OF GOODS Other
    "h604_244", -- REAL AGE Other
    "cluster", -- Cluster
    "pvo", -- PVO
    "total_members", -- Total household members
    "food_6", -- Daily per capita consumption 2013 GTQ Pasteles unidad peque a mediana grande
    "food_7", -- Daily per capita consumption 2013 GTQ Tortillas de ma z o harina Unidades Libras
    "food_21", -- Daily per capita consumption 2013 GTQ Carne de res Libras
    "food_41", -- Daily per capita consumption 2013 GTQ Mayonesa y aderezos Gramos
    "h101_001", -- ITEM Bean black white red etc Pounds
    "h101_006", -- ITEM Cakes unit small medium large
    "h101_007", -- ITEM corn or flour tortillas Units Pounds
    "h101_009", -- ITEM Incaparina Pounds
    "h101_014", -- ITEM Panela rapadura Pounds
    "h101_017", -- ITEM corn flour Maseca Pounds
    "h101_022", -- ITEM Noodles noodles macaroni pasta of all kinds Pounds
    "h101_023", -- ITEM Soup in envelopes Mahler Maggi etc Grams
    "h101_024", -- ITEM Sauces and canned tomato paste Grams
    "h101_034", -- ITEM Viscera giblets Pounds
    "h101_039", -- ITEM Ham Pounds Grams
    "h101_041", -- ITEM Milk Powder Pounds
    "h101_042", -- ITEM Fluid Milk Liters
    "h101_044", -- ITEM Eggs Units
    "h101_053", -- ITEM Lard Pounds
    "h101_058", -- ITEM Chiles Pounds Units
    "h101_062", -- ITEM Lettuce Units
    "h101_063", -- ITEM Cucumber Units
    "h101_065", -- ITEM Garlic Unit Head
    "h101_068", -- ITEM Celery Units
    "h101_069", -- ITEM Potatoes Pounds
    "h101_070", -- ITEM Yuca Pounds
    "h101_073", -- ITEM Cauliflower Units
    "h101_075", -- ITEM g icoy Units
    "h101_076", -- ITEM Bananas Units
    "h101_077", -- ITEM Bananas bananas Units
    "h101_080", -- ITEM Apples Pounds Units
    "h101_085", -- ITEM Avocado Units
    "h101_086", -- ITEM Potatoya Units Portion
    "h101_089", -- ITEM Strawberries Pounds
    "h101_093", -- ITEM Consomm s seasonings garlic salt onion and other salts Grams
    "h101_101", -- ITEM Coffee beans ground coffee instant Pounds Grams
    "h101_103", -- ITEM Beer Ounces liters milliliters
    "h101_104", -- ITEM Candy tortrix curls etc Grams
    "h101_106", -- ITEM Seeds toast as a hobby cashew etc Grams
    "h101_107", -- ITEM Liquor rums whiskeys wines cusha etc Liters
    "h101_113", -- ITEM Paches Units
    "h101_114", -- ITEM pork rillettes Libra
    "h101_116", -- ITEM Toast with guacamole beans salsa etc Units
    "usual_3", -- Daily per capita consumption 2013 GTQ Tel fono p blico telegramas cartas fax internet fuera del hogar
    "usual_4", -- Daily per capita consumption 2013 GTQ Combustible para veh culos de uso particular del hogar veh culos utilizados para el hogar
    "occasional_3", -- Daily per capita consumption 2013 GTQ Papel higi nico y toallas sanitarias servilletas toallas desechables etc
    "occasional_6", -- Daily per capita consumption 2013 GTQ Tijeras limas y corta u as pinzas etc
    "occasional_24", -- Daily per capita consumption 2013 GTQ Candelas y o veladoras
    "occasional_25", -- Daily per capita consumption 2013 GTQ Keroseno gas corriente
    "occasional_35", -- Daily per capita consumption 2013 GTQ Cepillos para ropa cepillos para calzado liquido y betun para calzado
    "occasional_total", -- Total occasional expenditures Daily per capita in 2013 GTQ
    "asset_2", -- Asset ownership refrigeradora
    "asset_4", -- Asset ownership piedra de moler
    "asset_5", -- Asset ownership olla a presi n
    "asset_19", -- Asset ownership moto motoneta
    "asset_20", -- Asset ownership cami n
    "id",
    "h604_236", -- REAL AGE car pick up waiting van
    "h605_236", -- MONETARY VALUE OF PROPERTY car pick up waiting van
    "h607_236", -- MONETARY VALUE PAID FOR PROPERTY IN PAST 12 MONTHS car pick up waiting van
    "h603_240", -- NUMBER OF GOODS truck
    "h605_240", -- MONETARY VALUE OF PROPERTY truck
    "h606_240", -- GOODS PURCHASED IN PAST 12 MONTHS truck
    "h604_241", -- REAL AGE bike
    "h605_241", -- MONETARY VALUE OF PROPERTY bike
    "h606_241", -- GOODS PURCHASED IN PAST 12 MONTHS bike
    "h605_244", -- MONETARY VALUE OF PROPERTY Other
    "h606_244", -- GOODS PURCHASED IN PAST 12 MONTHS Other
    "h607_244", -- MONETARY VALUE PAID FOR PROPERTY IN PAST 12 MONTHS Other
    "h608h", -- H6 08H ENDS Time Module H
    "h608m", -- H6 08M ENDS Minutes Module H
    "strata", -- Strata
    "hhwt", -- Sampling weight for households and household members
    "food_1", -- Daily per capita consumption 2013 GTQ Frijol negro blanco colorado etc Libras
    "food_2", -- Daily per capita consumption 2013 GTQ Arroz de 1ra o de 2da Libras
    "food_3", -- Daily per capita consumption 2013 GTQ Ma z blanco amarillo etc Libras
    "food_4", -- Daily per capita consumption 2013 GTQ Pan unidad peque a mediana grande
    "food_5", -- Daily per capita consumption 2013 GTQ Galletas unidad peque a mediana grande
    "food_8", -- Daily per capita consumption 2013 GTQ Cereales preparados Corn Flakes etc Gramos
    "food_9", -- Daily per capita consumption 2013 GTQ Incaparina Libras
    "food_10", -- Daily per capita consumption 2013 GTQ Avenas de toda clase mosh etc Libras
    "food_11", -- Daily per capita consumption 2013 GTQ Atoles de ma z vaso
    "food_13", -- Daily per capita consumption 2013 GTQ Azucar Libras
    "food_14", -- Daily per capita consumption 2013 GTQ Panela rapadura Libras
    "food_15", -- Daily per capita consumption 2013 GTQ Harina de ma z maseca Libras
    "food_16", -- Daily per capita consumption 2013 GTQ Harina de trigo Libras
    "food_17", -- Daily per capita consumption 2013 GTQ Fideos tallarines coditos pastas de toda clase Libras
    "food_18", -- Daily per capita consumption 2013 GTQ Sopa en sobres Malher Maggi etc Gramos
    "food_19", -- Daily per capita consumption 2013 GTQ Salsas y pasta de tomate envasadas Gramos
    "food_20", -- Daily per capita consumption 2013 GTQ Sopas instantaneas en vaso Gramos
    "food_22", -- Daily per capita consumption 2013 GTQ Carne de cerdo Libras
    "food_23", -- Daily per capita consumption 2013 GTQ Carne de pollo o gallina Libras
    "food_25", -- Daily per capita consumption 2013 GTQ Pescado fresco o seco Libras
    "food_26", -- Daily per capita consumption 2013 GTQ Sardinas at n etc enlatados Gramos
    "food_27", -- Daily per capita consumption 2013 GTQ Mariscos camarones cangrejos Libras
    "food_28", -- Daily per capita consumption 2013 GTQ Jam n Libras Gramos
    "food_29", -- Daily per capita consumption 2013 GTQ Leche en polvo para beb Libras
    "food_30", -- Daily per capita consumption 2013 GTQ Leche en polvo Libras
    "food_31", -- Daily per capita consumption 2013 GTQ Leche l quida Litros
    "food_32", -- Daily per capita consumption 2013 GTQ Huevos Unidades
    "food_33", -- Daily per capita consumption 2013 GTQ Crema fresca Litros Vaso
    "food_34", -- Daily per capita consumption 2013 GTQ Queso fresco duro Libras
    "food_35", -- Daily per capita consumption 2013 GTQ Yogures Gramos
    "food_36", -- Daily per capita consumption 2013 GTQ Mantequilla Libras
    "food_37", -- Daily per capita consumption 2013 GTQ Aceite comestible Litros Mililitros
    "food_38", -- Daily per capita consumption 2013 GTQ Manteca vegetal Libras
    "food_39", -- Daily per capita consumption 2013 GTQ Manteca de cerdo Libras
    "food_40", -- Daily per capita consumption 2013 GTQ Margarina Barras
    "food_42", -- Daily per capita consumption 2013 GTQ Tomate Libras
    "food_43", -- Daily per capita consumption 2013 GTQ Cebolla Libras
    "food_44", -- Daily per capita consumption 2013 GTQ Chiles Libras Unidades
    "food_45", -- Daily per capita consumption 2013 GTQ Repollo Unidades
    "food_46", -- Daily per capita consumption 2013 GTQ Zanahoria Unidades
    "food_47", -- Daily per capita consumption 2013 GTQ Guisquil Unidades
    "food_48", -- Daily per capita consumption 2013 GTQ Lechuga Unidades
    "food_49", -- Daily per capita consumption 2013 GTQ Pepino Unidades
    "food_50", -- Daily per capita consumption 2013 GTQ Remolacha Unidades
    "food_51", -- Daily per capita consumption 2013 GTQ Ajo Unidad Cabeza
    "food_52", -- Daily per capita consumption 2013 GTQ Hierbas como berro perejil macuy culantro yerbabuena chipilin etc Manojo
    "food_53", -- Daily per capita consumption 2013 GTQ Apio Unidades
    "food_54", -- Daily per capita consumption 2013 GTQ Papas Libras
    "food_55", -- Daily per capita consumption 2013 GTQ Yuca Libras
    "food_56", -- Daily per capita consumption 2013 GTQ Arveja Libras
    "food_57", -- Daily per capita consumption 2013 GTQ Brocoli Unidades
    "food_58", -- Daily per capita consumption 2013 GTQ Coliflor Unidades
    "food_59", -- Daily per capita consumption 2013 GTQ Ejotes Libras
    "food_60", -- Daily per capita consumption 2013 GTQ Guicoy Unidades
    "food_61", -- Daily per capita consumption 2013 GTQ Pl tanos Unidades
    "food_62", -- Daily per capita consumption 2013 GTQ Guineos bananos Unidades
    "food_63", -- Daily per capita consumption 2013 GTQ Naranjas Unidades
    "food_64", -- Daily per capita consumption 2013 GTQ Pi a Unidades Porci n
    "food_65", -- Daily per capita consumption 2013 GTQ Manzanas Libras Unidades
    "food_66", -- Daily per capita consumption 2013 GTQ Sand as Unidades Porci n
    "food_67", -- Daily per capita consumption 2013 GTQ Mangos Unidades
    "food_68", -- Daily per capita consumption 2013 GTQ Limones Unidades
    "food_69", -- Daily per capita consumption 2013 GTQ Aguacate Unidades
    "food_70", -- Daily per capita consumption 2013 GTQ Papaya Unidades Porci n
    "food_72", -- Daily per capita consumption 2013 GTQ Duraznos melocotones Unidades
    "food_73", -- Daily per capita consumption 2013 GTQ Fresas Libras
    "food_74", -- Daily per capita consumption 2013 GTQ Mandarinas Unidades
    "food_75", -- Daily per capita consumption 2013 GTQ Peras Unidades
    "food_76", -- Daily per capita consumption 2013 GTQ Uvas Libras
    "food_77", -- Daily per capita consumption 2013 GTQ Consom s sazonadores sal de ajo de cebolla y otras sales Gramos
    "food_78", -- Daily per capita consumption 2013 GTQ Tomillo laurel oregano y otras especias Manojo Onzas
    "food_79", -- Daily per capita consumption 2013 GTQ Sal Libras
    "food_80", -- Daily per capita consumption 2013 GTQ Aguas gaseosas Litros Mililitros
    "food_81", -- Daily per capita consumption 2013 GTQ Jugos empacados o enlatados Mililitros
    "food_82", -- Daily per capita consumption 2013 GTQ Frijoles enlatados Gramos
    "food_83", -- Daily per capita consumption 2013 GTQ Agua purificada Litros Mililitros
    "food_84", -- Daily per capita consumption 2013 GTQ Helados granizadas etc Unidades
    "food_85", -- Daily per capita consumption 2013 GTQ Caf en grano molido instant neo Libras Gramos
    "food_86", -- Daily per capita consumption 2013 GTQ Chocolate Libras
    "food_87", -- Daily per capita consumption 2013 GTQ Cerveza Onzas Litros Mililitros
    "food_88", -- Daily per capita consumption 2013 GTQ Golosinas tortrix ricitos etc Gramos
    "food_89", -- Daily per capita consumption 2013 GTQ Mermeladas jaleas Gramos
    "food_90", -- Daily per capita consumption 2013 GTQ Semillas tostadas como man a mara n etc Gramos
    "food_91", -- Daily per capita consumption 2013 GTQ Licores rones whiskys vinos cusha etc Litros
    "food_92", -- Daily per capita consumption 2013 GTQ Cigarrillos Unidades
    "food_93", -- Daily per capita consumption 2013 GTQ Compotas Gramos
    "food_94", -- Daily per capita consumption 2013 GTQ T en sobre cajita Gramos
    "food_95", -- Daily per capita consumption 2013 GTQ Tamales colorados negros de elote chuchitos etc Unidades
    "food_96", -- Daily per capita consumption 2013 GTQ Paches Unidades
    "food_97", -- Daily per capita consumption 2013 GTQ Chicharrones de cerdo Libra
    "food_98", -- Daily per capita consumption 2013 GTQ Tacos de toda clase Unidades
    "food_99", -- Daily per capita consumption 2013 GTQ Tostadas con guacamol frijol salsa etc Unidades
    "food_100", -- Daily per capita consumption 2013 GTQ Gasto en restaurantes Comida refrescos cerveza jugos u otras bebidas o comidas
    "food_101", -- Daily per capita consumption 2013 GTQ Otros embutidos como salchichas chorizos longanizas unidad peque a mediana
    "h101_002", -- ITEM Rice 1st or 2nd Pounds
    "h101_005", -- ITEM Cookies unit small medium large
    "h101_018", -- ITEM Wheat Pounds
    "h101_026", -- ITEM Instant Soups in glass Grams
    "h101_030", -- ITEM Pork Pounds
    "h101_035", -- ITEM Fish fresh or dry Pounds
    "h101_046", -- ITEM Fresh Cream Liters Glass
    "h101_051", -- ITEM Edible oil Liters milliliters
    "h101_052", -- ITEM Shortening Pounds
    "h101_057", -- ITEM Onion Pounds
    "h101_061", -- ITEM chayote Units
    "h101_092", -- ITEM Grapes Pounds
    "h101_094", -- ITEM thyme bay leaf oregano and other spices Bunch Ounces
    "h101_097", -- ITEM packaged or canned juices Milliliters
    "h101_110", -- ITEM Jams Grams
    "h101_112", -- ITEM Tamales colored black corn chuchitos etc Units
    "food_total", -- Daily per capita consumption 2013 UGX Food
    "usual_1", -- Daily per capita consumption 2013 GTQ Buses urbanos microbuses taxis o mototaxis no incluya gastos por transporte escolar
    "usual_2", -- Daily per capita consumption 2013 GTQ Peri dicos
    "usual_5", -- Daily per capita consumption 2013 GTQ Dinero que se da a los ni os para los gastos personales en el colegio
    "usual_6", -- Daily per capita consumption 2013 GTQ Molienda de ma z
    "usual_7", -- Daily per capita consumption 2013 GTQ F sforos
    "usual_8", -- Daily per capita consumption 2013 GTQ Encendedores
    "usual_9", -- Daily per capita consumption 2013 GTQ Lustre de calzado
    "usual_10", -- Daily per capita consumption 2013 GTQ Tarjetas de tiempo de aire para tel fonos celulares recargas pines
    "usual_11", -- Daily per capita consumption 2013 GTQ Otros
    "usual_total", -- Total usual expenditures Daily per capita in 2013 GTQ
    "occasional_2", -- Daily per capita consumption 2013 GTQ Pasta dental cepillo dental hilo dental enjuague bucal etc
    "occasional_4", -- Daily per capita consumption 2013 GTQ Cepillos para el cabello peines peinetas ganchos diademas colas tubos etc
    "occasional_5", -- Daily per capita consumption 2013 GTQ Rasuradoras repuestos para rasuradora hojas de afeitar cremas de afeitar etc
    "occasional_7", -- Daily per capita consumption 2013 GTQ Escobas cepillos trapeadores cera para pisos bolsas para basura basureros palas para recoger basura etc
    "occasional_8", -- Daily per capita consumption 2013 GTQ Guantes para lavar y de cocina esponjas lazos ganchos para colgar ropa limpiadores escurridor de platos
    "occasional_9", -- Daily per capita consumption 2013 GTQ Aceite de beb hisopos mamones pepes pachas pa ales desechables y o de tela camisetas baberos frazaditas
    "occasional_10", -- Daily per capita consumption 2013 GTQ Hilos para coser lanas botones el sticos zippers y similares etc para uso del hogar
    "occasional_11", -- Daily per capita consumption 2013 GTQ Libros y revistas no incluya los textos escolares
    "occasional_12", -- Daily per capita consumption 2013 GTQ Colonias desodorantes lociones talcos perfumes gel para el cabello vaselina tratamiento para el cabello etc
    "occasional_13", -- Daily per capita consumption 2013 GTQ Lavado planchado y reparaci n de prendas de vestir fuera del hogar
    "occasional_14", -- Daily per capita consumption 2013 GTQ Recreaci n diversi n como espect culos p blicos cine f tbol compra de casettes CD s DVD s etc
    "occasional_15", -- Daily per capita consumption 2013 GTQ Barber a corte de pelo y afeitada sal n de belleza peinado rizado manicure pedicure maquillaje
    "occasional_16", -- Daily per capita consumption 2013 GTQ Servicio de empleada dom stica lavandera planchadora chofer
    "occasional_18", -- Daily per capita consumption 2013 GTQ Gastos por pago de parqueo para veh culos del hogar
    "occasional_19", -- Daily per capita consumption 2013 GTQ Gastos por pasajes extraurbanos
    "occasional_20", -- Daily per capita consumption 2013 GTQ Tel fono fijo en el hogar
    "occasional_21", -- Daily per capita consumption 2013 GTQ Tel fono celular
    "occasional_22", -- Daily per capita consumption 2013 GTQ Agua
    "occasional_26", -- Daily per capita consumption 2013 GTQ Gas propano
    "occasional_28", -- Daily per capita consumption 2013 GTQ Baterias pilas
    "asset_8", -- Asset ownership c mara fotogr fica
    "h101_088", -- ITEM Peaches peaches Units
    "exceptional_14", -- Daily per capita consumption 2013 GTQ Pagos por obtenci n y tr mites de documentos como calcoman as de veh culos multas licencias pasaportes c dulas
    "h101_105", -- ITEM Jams jellies Grams
    "h101_010", -- ITEM Corn of all kinds mosh etc Pounds
    "food_24", -- Daily per capita consumption 2013 GTQ Visceras menudos Libras
    "occasional_27", -- Daily per capita consumption 2013 GTQ Carbon
    "occasional_1", -- Daily per capita consumption 2013 GTQ Jab n de ba o shamp acondicionador etc
    "h101_059", -- ITEM Cabbage Units
    "food_12", -- Daily per capita consumption 2013 GTQ Otros atoles arroz en leche atol de platana atolillo shuco etc vaso
    "occasional_32", -- Daily per capita consumption 2013 GTQ Atenci n m dica no relacionada con una enfermedad cuidado preventivo de la salud visitas prenatales chequeos etc
    "occasional_23", -- Daily per capita consumption 2013 GTQ Internet
    "food_71", -- Daily per capita consumption 2013 GTQ Melones Unidades Porci n
    "h101_090", -- ITEM Mandarins Units
    "occasional_29", -- Daily per capita consumption 2013 GTQ Electricidad
    "occasional_30", -- Daily per capita consumption 2013 GTQ Le a si solo la recogen y o cortan estime su valor en Q
    "occasional_31", -- Daily per capita consumption 2013 GTQ Asuntos relacionados con enfermedades y lesiones incluyendo medicamentos examenes consultas y hospitalizaciones
    "occasional_33", -- Daily per capita consumption 2013 GTQ Medicinas para primeros auxilios alcohol u otros medicamentos sin receta tales como Panadol Tabcin Ibuprofeno Aspirina Alka Seltzer Sal Andrews etc
    "occasional_34", -- Daily per capita consumption 2013 GTQ Jab n lava platos jab n en bola detergetes suavisante liquido blanqueadores cloro etc
    "occasional_36", -- Daily per capita consumption 2013 GTQ linternas o focos bombillas etc
    "exceptional_1", -- Daily per capita consumption 2013 GTQ Prendas de vestir confeccionadas No incluya los uniformes escolares
    "exceptional_2", -- Daily per capita consumption 2013 GTQ Telas para confeccionar ropa
    "exceptional_3", -- Daily per capita consumption 2013 GTQ Calzado zapatos tenis botas y reparaci n de calzado No incluya el calzado usado para uniforme escolar
    "exceptional_4", -- Daily per capita consumption 2013 GTQ Mantenimiento y reparaci n de la vivienda pintura y otras reparaciones menores
    "exceptional_5", -- Daily per capita consumption 2013 GTQ Muebles de cocina comedor sala dormitorio Incluya las reparaciones
    "exceptional_6", -- Daily per capita consumption 2013 GTQ Reparaci n y mantenimiento de bienes personales y del hogar Electrodom sticos aparatos electr nicos etc
    "exceptional_7", -- Daily per capita consumption 2013 GTQ Vajillas ollas bandejas sartenes cubiertos y otros utensilios para cocinar y comer Incluya las reparaciones
    "exceptional_8", -- Daily per capita consumption 2013 GTQ Cortinas s banas toallas mantas colchones manteles frazadas y otros
    "exceptional_9", -- Daily per capita consumption 2013 GTQ Adornos como floreros de toda clase plantas ornamentales y otros adornos
    "exceptional_10", -- Daily per capita consumption 2013 GTQ Art culos de joyer a de metales preciosos y fantas a Incluya las reparaciones
    "exceptional_11", -- Daily per capita consumption 2013 GTQ Fiestas cumplea os celebraciones bautizos y matrimonios organizados por el hogar
    "exceptional_12", -- Daily per capita consumption 2013 GTQ Regalos para todo tipo de fiestas o celebraciones no organizadas por el hogar
    "exceptional_13", -- Daily per capita consumption 2013 GTQ Hoteles pensiones y paquetes tur sticos tours de viajes
    "h101_040", -- ITEM baby milk powder Pounds
    "h101_087", -- ITEM Melons Units Portion
    "h603_239", -- NUMBER OF GOODS moto scooter
    "h101_066", -- ITEM Herbs like watercress parsley macuy cilantro mint chipilin etc Bunch
    "asset_7", -- Asset ownership impresora
    "h101_074", -- ITEM Beans Pounds
    "h101_078", -- ITEM Oranges Units
    "h101_060", -- ITEM Carrot Units
    "h101_079", -- ITEM Pineapple Units Portion
    "h101_037", -- ITEM Sardines tuna etc canned Grams
    "exceptional_16", -- Daily per capita consumption 2013 GTQ Medicinas honorarios m dicos ex menes radiograf as hospitalizaciones etc
    "h101_047", -- ITEM Fresh drive Pounds
    "asset_15", -- Asset ownership m quina de coser
    "h602_241", -- POSSESSION OF PROPERTY bike
    "h101_100", -- ITEM Ice hail etc Units
    "occasional_17", -- Daily per capita consumption 2013 GTQ Pagos por pensi n alimenticia
    "h101_054", -- ITEM Margarine Bars
    "h101_048", -- ITEM Yoghurt Grams
    "asset_22", -- Asset ownership Otro
    "h101_008", -- ITEM Cereal preparations Corn Flakes etc Grams
    "h606_236", -- GOODS PURCHASED IN PAST 12 MONTHS car pick up waiting van
    "h101_098", -- ITEM Canned beans Grams
    "asset_12", -- Asset ownership plancha
    "h602_244", -- POSSESSION OF PROPERTY Other
    "h604_240", -- REAL AGE truck
    "h101_071", -- ITEM Pea Pounds
    "h101_095", -- ITEM Sal Pounds
    "h602_240", -- POSSESSION OF PROPERTY truck
    "h101_115", -- ITEM Tacos of all kinds Units
    "h601_241", -- ITEM bike
    "h101_082", -- ITEM Mangos Units
    "h101_39a", -- ITEM Other meats like sausages sausages sausages small unit median
    "h101_102", -- ITEM Chocolate Pounds
    "asset_10", -- Asset ownership televisor
    "h101_033", -- ITEM Chicken meat or chicken Pounds
    "h101_081", -- ITEM Watermelons Units Portion
    "h101_012", -- ITEM Other gruel rice milk gruel platana Atolillo shuco etc vessel
    "h101_111", -- ITEM Tea on box Grams
    "h101_049", -- ITEM Butter Pounds
    "h101_003", -- ITEM Maize white yellow etc Pounds
    "h101_096", -- ITEM Aerated water Liters milliliters
    "h601_236", -- ITEM car pick up waiting van
    "exceptional_17", -- Daily per capita consumption 2013 GTQ Impuestos directos Impuesto sobre la renta impuesto nico sobre inmuebles
    "exceptional_18", -- Daily per capita consumption 2013 GTQ Servicios profesionales de abogados contadores y otros profesionales diferentes a los relacionados con la salu
    "exceptional_19", -- Daily per capita consumption 2013 GTQ Enviaron dinero y o bienes alimentos vestido calzado a miembros del hogar ausentes estudiantes familiares amigos
    "exceptional_20", -- Daily per capita consumption 2013 GTQ Hicieron donaciones a personas entidades de caridad sin fines de lucro
    "exceptional_21", -- Daily per capita consumption 2013 GTQ Aportes a asociaciones locales
    "exceptional_22", -- Daily per capita consumption 2013 GTQ Servicios y contratos funerarios panteones cajas mortuorias etc
    "exceptional_23", -- Daily per capita consumption 2013 GTQ Pago de seguro del veh culo incendio robo
    "exceptional_24", -- Daily per capita consumption 2013 GTQ Art culos deportivos
    "exceptional_25", -- Daily per capita consumption 2013 GTQ Juguetes
    "exceptional_26", -- Daily per capita consumption 2013 GTQ Aparato de tel fon a celular
    "exceptional_27", -- Daily per capita consumption 2013 GTQ Por la inscripci n o matr cula
    "exceptional_28", -- Daily per capita consumption 2013 GTQ Libros y papeler a cuadernos y o materiales escolares
    "exceptional_29", -- Daily per capita consumption 2013 GTQ Uniformes
    "exceptional_30" -- Daily per capita consumption 2013 GTQ Transporte de ida y vuelta a la escuela
FROM
    "usaid-gov/guatemala-food-consumption-data-section-5-k2ft-ssjh:latest"."guatemala_food_consumption_data_section_5"
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-5-k2ft-ssjh 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-5-k2ft-ssjh: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-5-k2ft-ssjh" \
  --handler-options '{
    "domain": "data.usaid.gov",
    "tables": {
        "guatemala_food_consumption_data_section_5": "k2ft-ssjh"
    }
}'

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-5-k2ft-ssjh is just another Postgres schema.