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_4 table in this repository, by referencing it like:
"usaid-gov/guatemala-food-consumption-data-section-4-3hkt-uxc3:latest"."guatemala_food_consumption_data_section_4"or in a full query, like:
SELECT
":id", -- Socrata column ID
"h401_172", -- ITEM Payments for obtaining documents and procedures as car stickers fines licenses passports certificates
"h401_185", -- ITEM Sporting Goods
"h402_190", -- CONSUMPTION IN PAST 12 MONTHS Uniforms
"h403_192", -- MONEY SPENT ON AMOUNT CONSUMED 12 MONTHS Transportation to and from school
"h402_160", -- CONSUMPTION IN PAST 12 MONTHS Maintenance and repair of the dwelling painting and other minor repairs
"h402_193", -- CONSUMPTION IN PAST 12 MONTHS school fees or tuition
"h401_166", -- ITEM Ornaments as vases of all kinds ornamental plants and other decorations
"h402_162", -- CONSUMPTION IN PAST 12 MONTHS Repair and maintenance of personal and household goods appliances electronics etc
"h401_161", -- ITEM kitchen furniture dining room bedroom Include the repairs
"h403_160", -- MONEY SPENT ON AMOUNT CONSUMED 12 MONTHS Maintenance and repair of the dwelling painting and other minor repairs
"h401_160", -- ITEM Maintenance and repair of the dwelling painting and other minor repairs
"h601_205a", -- ITEM Other kitchen
"h604_204", -- REAL AGE grinding stone
"h602_215a", -- POSSESSION OF PROPERTY Other personal items and entertainment
"h301_151", -- ITEM Electricity
"h202_112", -- CONSUMPTION IN PAST 7 DAYS Other
"h301_131", -- ITEM recreation fun as public entertainment theater football buying cassettes CD s DVD s etc
"h601_204", -- ITEM grinding stone
"h402_186", -- CONSUMPTION IN PAST 12 MONTHS Toys
"h505b", -- H5 5b In what time frame
"h402_161", -- CONSUMPTION IN PAST 12 MONTHS kitchen furniture dining room bedroom Include the repairs
"h302_144", -- CONSUMPTION IN LAST 30 DAYS Internet
"h603_223", -- NUMBER OF GOODS solar panel
"h602_230", -- POSSESSION OF PROPERTY sewing machine
"h606_215a", -- GOODS PURCHASED IN PAST 12 MONTHS Other personal items and entertainment
"h301_132", -- ITEM Barbershop haircut and shave beauty salon hair curly manicure pedicure makeup
"h601_205", -- ITEM pressure cooker
"h302_147", -- CONSUMPTION IN LAST 30 DAYS kerosene gas stream
"h604_233", -- REAL AGE water heater
"h403_178", -- MONEY SPENT ON AMOUNT CONSUMED 12 MONTHS sent money and or goods food clothing footwear for absent household members students family friends
"h403_179", -- MONEY SPENT ON AMOUNT CONSUMED 12 MONTHS They made donations to individuals charities nonprofit
"h403_181", -- MONEY SPENT ON AMOUNT CONSUMED 12 MONTHS Services and burial contracts cemeteries burial boxes etc
"h403_185", -- MONEY SPENT ON AMOUNT CONSUMED 12 MONTHS Sporting Goods
"h402_187", -- CONSUMPTION IN PAST 12 MONTHS cell phone devices
"h403_187", -- MONEY SPENT ON AMOUNT CONSUMED 12 MONTHS cell phone devices
"h403_188", -- MONEY SPENT ON AMOUNT CONSUMED 12 MONTHS For registration or registration
"h403_189", -- MONEY SPENT ON AMOUNT CONSUMED 12 MONTHS Books and stationery notebooks and or school supplies
"h403_190", -- MONEY SPENT ON AMOUNT CONSUMED 12 MONTHS Uniforms
"h403_193", -- MONEY SPENT ON AMOUNT CONSUMED 12 MONTHS school fees or tuition
"h502", -- H5 2 If you sold this dwelling today how much you would get for it
"h605_195", -- MONETARY VALUE OF PROPERTY gas or electric stove
"h607_195", -- MONETARY VALUE PAID FOR PROPERTY IN PAST 12 MONTHS gas or electric stove
"h601_198", -- ITEM refrigerator
"h604_198", -- REAL AGE refrigerator
"h605_198", -- MONETARY VALUE OF PROPERTY refrigerator
"h604_202", -- REAL AGE Nixtamal manual mill
"h607_202", -- MONETARY VALUE PAID FOR PROPERTY IN PAST 12 MONTHS Nixtamal manual mill
"h605_205", -- MONETARY VALUE OF PROPERTY pressure cooker
"h607_205", -- MONETARY VALUE PAID FOR PROPERTY IN PAST 12 MONTHS pressure cooker
"h604_205a", -- REAL AGE Other kitchen
"h605_205a", -- MONETARY VALUE OF PROPERTY Other kitchen
"h607_205a", -- MONETARY VALUE PAID FOR PROPERTY IN PAST 12 MONTHS Other kitchen
"h604_207", -- REAL AGE computer
"h605_207", -- MONETARY VALUE OF PROPERTY computer
"h607_207", -- MONETARY VALUE PAID FOR PROPERTY IN PAST 12 MONTHS computer
"h602_209", -- POSSESSION OF PROPERTY printer
"h605_209", -- MONETARY VALUE OF PROPERTY printer
"h601_210", -- ITEM camera
"h402_172", -- CONSUMPTION IN PAST 12 MONTHS Payments for obtaining documents and procedures as car stickers fines licenses passports certificates
"h607_210", -- MONETARY VALUE PAID FOR PROPERTY IN PAST 12 MONTHS camera
"h603_235a", -- NUMBER OF GOODS Other household items
"h602_211", -- POSSESSION OF PROPERTY transistor radio
"h301_121", -- ITEM brooms brushes mops floor wax trash bags trash cans shovels to pick up trash etc
"h604_205", -- REAL AGE pressure cooker
"h403_172", -- MONEY SPENT ON AMOUNT CONSUMED 12 MONTHS Payments for obtaining documents and procedures as car stickers fines licenses passports certificates
"h402_174", -- CONSUMPTION IN PAST 12 MONTHS Repair and maintenance of vehicles Include spare parts lubricants labor tires etc
"h605_211", -- MONETARY VALUE OF PROPERTY transistor radio
"h607_211", -- MONETARY VALUE PAID FOR PROPERTY IN PAST 12 MONTHS transistor radio
"h603_215", -- NUMBER OF GOODS TV
"h604_215", -- REAL AGE TV
"h606_215", -- GOODS PURCHASED IN PAST 12 MONTHS TV
"h607_215", -- MONETARY VALUE PAID FOR PROPERTY IN PAST 12 MONTHS TV
"h302_143", -- CONSUMPTION IN LAST 30 DAYS Water
"h604_215a", -- REAL AGE Other personal items and entertainment
"h607_215a", -- MONETARY VALUE PAID FOR PROPERTY IN PAST 12 MONTHS Other personal items and entertainment
"h604_223", -- REAL AGE solar panel
"h605_223", -- MONETARY VALUE OF PROPERTY solar panel
"h606_223", -- GOODS PURCHASED IN PAST 12 MONTHS solar panel
"h607_223", -- MONETARY VALUE PAID FOR PROPERTY IN PAST 12 MONTHS solar panel
"h603_225", -- NUMBER OF GOODS iron
"h604_225", -- REAL AGE iron
"h403_174", -- MONEY SPENT ON AMOUNT CONSUMED 12 MONTHS Repair and maintenance of vehicles Include spare parts lubricants labor tires etc
"h403_175", -- MONEY SPENT ON AMOUNT CONSUMED 12 MONTHS Medicines medical fees exams x rays hospitalization etc
"h403_168", -- MONEY SPENT ON AMOUNT CONSUMED 12 MONTHS parties birthdays celebrations christenings and marriages organized by the household
"h303_147", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS kerosene gas stream
"h402_168", -- CONSUMPTION IN PAST 12 MONTHS Holidays birthdays celebrations christenings and marriages organized by the household
"h402_176", -- CONSUMPTION IN PAST 12 MONTHS Direct taxes Income tax single tax on real estate
"h401_177", -- ITEM Professional Services lawyers accountants and other professionals other than those related to healthy
"h403_177", -- MONEY SPENT ON AMOUNT CONSUMED 12 MONTHS Professional Services of lawyers accountants and other professionals other than those related to healthy
"h401_179", -- ITEM They made donations to individuals charities nonprofit
"h607_233", -- MONETARY VALUE PAID FOR PROPERTY IN PAST 12 MONTHS water heater
"h605_204", -- MONETARY VALUE OF PROPERTY grinding stone
"h606_225", -- GOODS PURCHASED IN PAST 12 MONTHS iron
"h401_188", -- ITEM For registration or registration
"h603_205a", -- NUMBER OF GOODS Other kitchen
"h401_175", -- ITEM Medicines medical fees exams x rays hospitalization etc
"h403_169", -- MONEY SPENT ON AMOUNT CONSUMED 12 MONTHS Gifts for all kinds of parties and celebrations not organized by the home
"h303_148", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS propane gas
"h606_202", -- GOODS PURCHASED IN PAST 12 MONTHS Nixtamal manual mill
"h603_228", -- NUMBER OF GOODS fan
"h301_146", -- ITEM candles and or candles
"h401_171", -- ITEM Hotels pensions and travel packages tours travel
"h602_205", -- POSSESSION OF PROPERTY pressure cooker
"h401_169", -- ITEM Gifts for all kinds of parties and celebrations not organized by the home
"h401_182", -- ITEM Payment vehicle insurance fire theft
"h301_152", -- ITEM firewood if only collected and or cut estimate its value at Q
"h302_134", -- CONSUMPTION IN LAST 30 DAYS maid service laundry ironing chauffer
"h605_225", -- MONETARY VALUE OF PROPERTY iron
"h605_226", -- MONETARY VALUE OF PROPERTY washing machine
"h606_226", -- GOODS PURCHASED IN PAST 12 MONTHS washing machine
"h607_226", -- MONETARY VALUE PAID FOR PROPERTY IN PAST 12 MONTHS washing machine
"h605_228", -- MONETARY VALUE OF PROPERTY fan
"h604_230", -- REAL AGE sewing machine
"h605_230", -- MONETARY VALUE OF PROPERTY sewing machine
"h607_230", -- MONETARY VALUE PAID FOR PROPERTY IN PAST 12 MONTHS sewing machine
"h605_233", -- MONETARY VALUE OF PROPERTY water heater
"h603_235", -- NUMBER OF GOODS metal silo to store grain
"h604_235", -- REAL AGE metal silo to store grain
"h605_235", -- MONETARY VALUE OF PROPERTY metal silo to store grain
"h402_192", -- CONSUMPTION IN PAST 12 MONTHS Transportation to and from school
"h302_118", -- CONSUMPTION IN LAST 30 DAYS razors shaver parts razor blades shaving cream etc
"h402_164", -- CONSUMPTION IN PAST 12 MONTHS Dishes pots trays pans cutlery and utensils for cooking and eating Include the repairs
"h606_235", -- GOODS PURCHASED IN PAST 12 MONTHS metal silo to store grain
"h607_235", -- MONETARY VALUE PAID FOR PROPERTY IN PAST 12 MONTHS metal silo to store grain
"h604_210", -- REAL AGE camera
"h301_125", -- ITEM sewing thread wool buttons elastic zippers and the like etc for home use
"h403_182", -- MONEY SPENT ON AMOUNT CONSUMED 12 MONTHS Payment vehicle insurance fire theft
"h603_211", -- NUMBER OF GOODS transistor radio
"h401_168", -- ITEM parties birthdays celebrations christenings and marriages organized by the household
"h303_153", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS Issues related to illness and injury including medications tests consultations and hospitalizations
"h503", -- H5 3 How many years ago that was built this house
"h504a", -- H5 4a If you rented this home today how much you would receive for the rent
"h601_195", -- ITEM gas or electric stove
"h603_198", -- NUMBER OF GOODS refrigerator
"h607_198", -- MONETARY VALUE PAID FOR PROPERTY IN PAST 12 MONTHS refrigerator
"h606_204", -- GOODS PURCHASED IN PAST 12 MONTHS grinding stone
"h606_205a", -- GOODS PURCHASED IN PAST 12 MONTHS Other kitchen
"h606_195", -- GOODS PURCHASED IN PAST 12 MONTHS gas or electric stove
"h601_209", -- ITEM printer
"h302_153", -- CONSUMPTION IN LAST 30 DAYS Issues related to illness and injury including medications tests consultations and hospitalizations
"h302_131", -- CONSUMPTION IN LAST 30 DAYS recreation fun as public entertainment theater football buying cassettes CD s DVD s etc
"h403_176", -- MONEY SPENT ON AMOUNT CONSUMED 12 MONTHS Direct taxes Income tax single tax on real estate
"h302_151", -- CONSUMPTION IN LAST 30 DAYS Electricity
"h303_149", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS carbon
"h602_215", -- POSSESSION OF PROPERTY TV
"h401_192", -- ITEM Transportation to and from school
"h401_165", -- ITEM curtains sheets towels blankets mattresses linens blankets and other
"h606_209", -- GOODS PURCHASED IN PAST 12 MONTHS printer
"h301_138", -- ITEM Expenses paid parking for vehicles home
"h501", -- H5 1 Are you the owner of this home or are buying the employer has provided for the free use or rented
"h301_148", -- ITEM propane gas
"h601_211", -- ITEM transistor radio
"h402_175", -- CONSUMPTION IN PAST 12 MONTHS Medicines medical fees exams x rays hospitalization etc
"h604_235a", -- REAL AGE Other household items
"h602_226", -- POSSESSION OF PROPERTY washing machine
"h604_228", -- REAL AGE fan
"h605_202", -- MONETARY VALUE OF PROPERTY Nixtamal manual mill
"h602_202", -- POSSESSION OF PROPERTY Nixtamal manual mill
"h303_121", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS brooms brushes mops floor wax trash bags trash cans shovels to pick up trash etc
"h604_195", -- REAL AGE gas or electric stove
"h303_139", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS extra urban passages expenses
"h603_205", -- NUMBER OF GOODS pressure cooker
"h604_226", -- REAL AGE washing machine
"h302_150", -- CONSUMPTION IN LAST 30 DAYS batteries batteries
"h303_125", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS sewing thread wool buttons elastic zippers and the like etc for home use
"h607_209", -- MONETARY VALUE PAID FOR PROPERTY IN PAST 12 MONTHS printer
"h602_210", -- POSSESSION OF PROPERTY camera
"h603_210", -- NUMBER OF GOODS camera
"h604_209", -- REAL AGE printer
"h401_189", -- ITEM Books and stationery notebooks and or school supplies
"h301_115", -- ITEM toothpaste toothbrush dental floss mouthwash etc
"h402_165", -- CONSUMPTION IN PAST 12 MONTHS curtains sheets towels blankets mattresses linens blankets and other
"h606_228", -- GOODS PURCHASED IN PAST 12 MONTHS fan
"h401_176", -- ITEM Direct taxes Income tax single tax on real estate
"h601_235a", -- ITEM Other household items
"h303_143", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS Water
"h601_228", -- ITEM fan
"h302_155", -- CONSUMPTION IN LAST 30 DAYS first aid medicines alcohol or non prescription medications such as Panadol Tabcin Ibuprofen Aspirin Alka Seltzer Sal Andrews etc
"h401_190", -- ITEM Uniforms
"h302_113c", -- CONSUMPTION IN LAST 30 DAYS flashlights or spotlights bulbs etc
"h402_182", -- CONSUMPTION IN PAST 12 MONTHS Payment vehicle insurance fire theft
"h302_113b", -- CONSUMPTION IN LAST 30 DAYS clothes brushes shoe brushes shoe liquid and tar
"h601_235", -- ITEM metal silo to store grain
"h401_158", -- ITEM Fabrics for clothing
"h301_153", -- ITEM Matters relating to illness and injuries including medications tests consultations and hospitalizations
"h504b", -- H5 4b In what time frame
"h602_235", -- POSSESSION OF PROPERTY metal silo to store grain
"h302_139", -- CONSUMPTION IN LAST 30 DAYS extra urban passages expenses
"h302_115", -- CONSUMPTION IN LAST 30 DAYS toothpaste toothbrush dental floss mouthwash etc
"h602_204", -- POSSESSION OF PROPERTY grinding stone
"h402_167", -- CONSUMPTION IN PAST 12 MONTHS Jewelry precious metals and fantasy Include the repairs
"h302_116", -- CONSUMPTION IN LAST 30 DAYS toilet paper and sanitary towels napkins paper towels etc
"h302_130", -- CONSUMPTION IN LAST 30 DAYS and repair laundered clothing outside the home
"h301_122", -- ITEM gloves for washing and cooking sponges ties coat hooks cleaners dish rack
"h403_157", -- MONEY SPENT ON AMOUNT CONSUMED 12 MONTHS Clothing made Do not include school uniforms
"h505a", -- H5 5a do you pay rent for this property
"h604_211", -- REAL AGE transistor radio
"h605_215", -- MONETARY VALUE OF PROPERTY TV
"h607_204", -- MONETARY VALUE PAID FOR PROPERTY IN PAST 12 MONTHS grinding stone
"h402_166", -- CONSUMPTION IN PAST 12 MONTHS Ornaments as vases of all kinds ornamental plants and other decorations
"h603_215a", -- NUMBER OF GOODS Other personal items and entertainment
"h605_215a", -- MONETARY VALUE OF PROPERTY Other personal items and entertainment
"h403_171", -- MONEY SPENT ON AMOUNT CONSUMED 12 MONTHS Hotels pensions and travel packages tours travel
"h607_225", -- MONETARY VALUE PAID FOR PROPERTY IN PAST 12 MONTHS iron
"h602_225", -- POSSESSION OF PROPERTY iron
"h601_226", -- ITEM washing machine
"h402_177", -- CONSUMPTION IN PAST 12 MONTHS Professional services of lawyers accountants and other professionals other than those related to healthy
"h402_159", -- CONSUMPTION IN PAST 12 MONTHS shoes tennis shoes boots and shoe repair Do not include school uniform footwear used
"h603_226", -- NUMBER OF GOODS washing machine
"h607_228", -- MONETARY VALUE PAID FOR PROPERTY IN PAST 12 MONTHS fan
"h606_230", -- GOODS PURCHASED IN PAST 12 MONTHS sewing machine
"h302_124", -- CONSUMPTION IN LAST 30 DAYS baby oil swabs suckers pepes pashas diapers and or cloth shirts bibs frazaditas
"h603_233", -- NUMBER OF GOODS water heater
"h301_124", -- ITEM baby oil swabs suckers pepes pashas diapers and or cloth shirts bibs frazaditas
"h302_114", -- CONSUMPTION IN LAST 30 DAYS bath soap shampoo conditioner etc
"h303_114", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS bath soap shampoo conditioner etc
"h606_233", -- GOODS PURCHASED IN PAST 12 MONTHS water heater
"h402_171", -- CONSUMPTION IN PAST 12 MONTHS Hotels pensions and travel packages tours travel
"id",
"h301_113a", -- ITEM dishwasher soap washing ball detergetes suavisante liquid bleach chlorine etc
"h303_150", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS batteries batteries
"h301_150", -- ITEM batteries batteries
"h606_211", -- GOODS PURCHASED IN PAST 12 MONTHS transistor radio
"h401_164", -- ITEM Dishes pots trays pans cutlery and utensils for cooking and eating Include the repairs
"h402_158", -- CONSUMPTION IN PAST 12 MONTHS Fabrics for clothing
"h301_114", -- ITEM bath soap shampoo conditioner etc
"h302_138", -- CONSUMPTION IN LAST 30 DAYS Expenses paid parking for vehicles home
"h605_235a", -- MONETARY VALUE OF PROPERTY Other household items
"h302_152", -- CONSUMPTION IN LAST 30 DAYS firewood if only collected and or cut estimate its value at Q
"h302_122", -- CONSUMPTION IN LAST 30 DAYS gloves for washing and cooking sponges ties coat hooks cleaners dish rack
"h606_198", -- GOODS PURCHASED IN PAST 12 MONTHS refrigerator
"h303_113b", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS clothes brushes shoe brushes shoe liquid and tar
"h303_151", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS Electricity
"h302_113a", -- CONSUMPTION IN LAST 30 DAYS dishwasher soap washing ball detergetes suavisante liquid bleach chlorine etc
"h302_137", -- CONSUMPTION IN LAST 30 DAYS Payments for alimony
"h301_147", -- ITEM kerosene gas stream
"h303_154", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS Health Care related to a disease preventive health care prenatal visits checkups etc
"h303_113a", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS dishwasher soap washing ball detergetes suavisante liquid bleach chlorine etc
"h601_230", -- ITEM sewing machine
"h301_149", -- ITEM carbon
"h303_113c", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS flashlights or spotlights bulbs etc
"h301_116", -- ITEM toilet paper and sanitary towels napkins paper towels etc
"h303_116", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS toilet paper and sanitary towels napkins paper towels etc
"h302_119", -- CONSUMPTION IN LAST 30 DAYS scissors nail files and nail clippers tweezers etc
"h302_121", -- CONSUMPTION IN LAST 30 DAYS brooms brushes mops floor wax trash bags trash cans shovels to pick up trash etc
"h402_185", -- CONSUMPTION IN PAST 12 MONTHS Sporting Goods
"h403_180", -- MONEY SPENT ON AMOUNT CONSUMED 12 MONTHS Contributions to local associations
"h302_125", -- CONSUMPTION IN LAST 30 DAYS sewing thread wool buttons elastic zippers and the like etc for home use
"h301_113c", -- ITEM flashlights or spotlights bulbs etc
"h603_195", -- NUMBER OF GOODS gas or electric stove
"h601_207", -- ITEM computer
"h301_130", -- ITEM laundered and repair of clothing outside the home
"h606_207", -- GOODS PURCHASED IN PAST 12 MONTHS computer
"h303_115", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS toothpaste toothbrush dental floss mouthwash etc
"h402_189", -- CONSUMPTION IN PAST 12 MONTHS Books and stationery notebooks and or school supplies
"h302_117", -- CONSUMPTION IN LAST 30 DAYS hairbrushes combs hair clips headbands tails tubing etc
"h303_117", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS hairbrushes combs hair clips headbands tails tubing etc
"h303_118", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS razors shaver parts razor blades shaving cream etc
"h401_193", -- ITEM school fees or tuition
"h401_180", -- ITEM Contributions to local associations
"h301_119", -- ITEM scissors nail files and nail clippers tweezers etc
"h303_119", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS scissors nail files and nail clippers tweezers etc
"h303_122", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS wash gloves and kitchen sponges ties coat hooks cleaners dish rack
"h203_112", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Other
"h303_142", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS Cell phone
"h606_235a", -- GOODS PURCHASED IN PAST 12 MONTHS Other household items
"h301_113b", -- ITEM clothes brushes shoe brushes shoe liquid and tar
"h606_205", -- GOODS PURCHASED IN PAST 12 MONTHS pressure cooker
"h402_179", -- CONSUMPTION IN PAST 12 MONTHS They made donations to individuals charities nonprofit
"h601_215a", -- ITEM Other personal items and entertainment
"h402_188", -- CONSUMPTION IN PAST 12 MONTHS For registration or registration
"h303_132", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS Barbershop haircut and shave beauty salon hair curly manicure pedicure makeup
"h401_178", -- ITEM sent money and or goods food clothing footwear for absent household members students family friends
"h601_202", -- ITEM Nixtamal manual mill
"h301_117", -- ITEM hairbrushes combs hair clips headbands tails tubing etc
"h602_205a", -- POSSESSION OF PROPERTY Other kitchen
"h402_180", -- CONSUMPTION IN PAST 12 MONTHS Contributions to local associations
"h602_235a", -- POSSESSION OF PROPERTY Other household items
"h302_146", -- CONSUMPTION IN LAST 30 DAYS candles and or candles
"h303_152", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS firewood if only collected and or cut estimate its value at Q
"h603_207", -- NUMBER OF GOODS computer
"h401_186", -- ITEM Toys
"h603_230", -- NUMBER OF GOODS sewing machine
"h302_149", -- CONSUMPTION IN LAST 30 DAYS carbon
"h401_181", -- ITEM Services and burial contracts cemeteries burial boxes etc
"h603_204", -- NUMBER OF GOODS grinding stone
"h301_144", -- ITEM Internet
"h603_202", -- NUMBER OF GOODS Nixtamal manual mill
"h602_207", -- POSSESSION OF PROPERTY computer
"h602_195", -- POSSESSION OF PROPERTY gas or electric stove
"h602_228", -- POSSESSION OF PROPERTY fan
"h401_174", -- ITEM Repair and maintenance of vehicles Include spare parts lubricants labor tires etc
"h601_233", -- ITEM water heater
"h402_178", -- CONSUMPTION IN PAST 12 MONTHS sent money and or goods food clothing footwear for absent household members students family friends
"h401_187", -- ITEM cell phone devices
"h301_154", -- ITEM Health Care related to a disease preventive health care prenatal visits checkups etc
"h302_148", -- CONSUMPTION IN LAST 30 DAYS propane gas
"h301_142", -- ITEM Cell phone
"h301_141", -- ITEM fixed at home
"h302_154", -- CONSUMPTION IN LAST 30 DAYS Health Care related to a disease preventive health care prenatal visits checkups etc
"h402_157", -- CONSUMPTION IN PAST 12 MONTHS Clothing made Do not include school uniforms
"h602_198", -- POSSESSION OF PROPERTY refrigerator
"h601_215", -- ITEM TV
"h302_132", -- CONSUMPTION IN LAST 30 DAYS Barbershop haircut and shave beauty salon hair curly manicure pedicure makeup
"h601_225", -- ITEM iron
"h401_162", -- ITEM Repair and maintenance of personal and household goods appliances electronics etc
"h606_210", -- GOODS PURCHASED IN PAST 12 MONTHS camera
"h602_233", -- POSSESSION OF PROPERTY water heater
"h301_126", -- ITEM books and magazines not including textbooks
"h303_126", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS books and magazines not including textbooks
"h303_138", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS Expenses paid parking for vehicles home
"h302_141", -- CONSUMPTION IN LAST 30 DAYS fixed at home
"h303_141", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS fixed at home
"h301_143", -- ITEM Water
"h303_124", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS baby oil swabs suckers pepes pashas diapers and or cloth shirts bibs frazaditas
"h302_126", -- CONSUMPTION IN LAST 30 DAYS books and magazines not including textbooks
"h301_127", -- ITEM colognes deodorants lotions powders perfumes hair gel Vaseline hair treatment etc
"h302_127", -- CONSUMPTION IN LAST 30 DAYS colognes deodorants lotions powders perfumes hair gel Vaseline hair treatment etc
"h303_127", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS colognes deodorants lotions powders perfumes hair gel Vaseline hair treatment etc
"h403_186", -- MONEY SPENT ON AMOUNT CONSUMED 12 MONTHS Toys
"h303_130", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS and repair laundered clothing outside the home
"h201_112", -- ITEM Other
"h602_223", -- POSSESSION OF PROPERTY solar panel
"h402_169", -- CONSUMPTION IN PAST 12 MONTHS Gifts for all kinds of parties and celebrations not organized by the home
"h601_223", -- ITEM solar panel
"h603_209", -- NUMBER OF GOODS printer
"h301_134", -- ITEM maid service laundry ironing chauffer
"h301_155", -- ITEM first aid medicines alcohol or non prescription medications such as Panadol Tabcin Ibuprofen Aspirin Alka Seltzer Sal Andrews etc
"h303_155", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS first aid medicines alcohol or non prescription medications such as Panadol Tabcin Ibuprofen Aspirin Alka Seltzer Sal Andrews etc
"h401_157", -- ITEM Clothing made Do not include school uniforms
"h403_158", -- MONEY SPENT ON AMOUNT CONSUMED 12 MONTHS Fabrics for clothing
"h401_159", -- ITEM shoes tennis shoes boots and shoe repair Do not include school uniform footwear used
"h303_131", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS recreation fun as public entertainment theater football buying cassettes CD s DVD s etc
"h303_146", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS candles and or candles
"h303_134", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS maid service laundry ironing chauffer
"h403_159", -- MONEY SPENT ON AMOUNT CONSUMED 12 MONTHS shoes tennis shoes boots and shoe repair Do not include school uniform footwear used
"h301_137", -- ITEM Payments for alimony
"h605_210", -- MONETARY VALUE OF PROPERTY camera
"h403_161", -- MONEY SPENT ON AMOUNT CONSUMED 12 MONTHS kitchen furniture dining room bedroom Include the repairs
"h403_162", -- MONEY SPENT ON AMOUNT CONSUMED 12 MONTHS Repair and maintenance of personal and household goods appliances electronics etc
"h402_181", -- CONSUMPTION IN PAST 12 MONTHS Services and burial contracts cemeteries burial boxes etc
"h403_164", -- MONEY SPENT ON AMOUNT CONSUMED 12 MONTHS Dishes pots trays pans cutlery and utensils for cooking and eating Include the repairs
"h403_165", -- MONEY SPENT ON AMOUNT CONSUMED 12 MONTHS curtains sheets towels blankets mattresses linens blankets and other
"h403_166", -- MONEY SPENT ON AMOUNT CONSUMED 12 MONTHS Ornaments as vases of all kinds ornamental plants and other decorations
"h401_167", -- ITEM Jewelry precious metals and fantasy Include the repairs
"h403_167", -- MONEY SPENT ON AMOUNT CONSUMED 12 MONTHS Jewelry precious metals and fantasy Include the repairs
"h303_137", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS Payments for alimony
"h302_142", -- CONSUMPTION IN LAST 30 DAYS Cell phone
"h303_144", -- MONEY SPENT ON AMOUNT CONSUMED 30 DAYS Internet
"h301_139", -- ITEM extra urban passages expenses
"h301_118" -- ITEM razors shaver parts razor blades shaving cream etc
FROM
"usaid-gov/guatemala-food-consumption-data-section-4-3hkt-uxc3:latest"."guatemala_food_consumption_data_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/guatemala-food-consumption-data-section-4-3hkt-uxc3 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-4-3hkt-uxc3: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-4-3hkt-uxc3" \
--handler-options '{
"domain": "data.usaid.gov",
"tables": {
"guatemala_food_consumption_data_section_4": "3hkt-uxc3"
}
}'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-4-3hkt-uxc3 is just another Postgres schema.