datafloe Get a key

A record, in full

grocery-prices

Schema, a real sample, a live query box, snippets, and the machine-readable license.

GET /v1/datafloe/grocery-prices

US grocery prices by area (USDA F-MAP)

source USDA ERS — Food-at-Home Monthly Area Prices  ·  license U.S. Government public domain  ·  retrieved 2018-12-01
redistribution unrestricted, commercial use permitted, no attribution required
rows113,400
columns18
version2018-12
sourcelicensed
License PD public domain CLEARED FOR REUSE · REC 2018-12

Schema

columntypenull %
id integer 0.0
year integer 0.0
month integer 0.0
efpg_code integer 0.0
efpg_name text 0.0
tier1_group text 0.0
tier2_group text 0.0
region_code integer 0.0
region_name text 0.0
purchase_dollars_wtd real 0.0
purchase_grams_wtd real 0.0
purchase_dollars_unwtd real 0.0
purchase_grams_unwtd real 0.0
number_stores real 0.0
unit_value_mean_wtd real 0.0
unit_value_se_wtd real 0.0
unit_value_mean_unwtd real 0.0
price_index_geks real 0.0

Sample · 5 rows

idyearmonthefpg_codeefpg_nametier1_grouptier2_groupregion_coderegion_namepurchase_dollars_wtdpurchase_grams_wtdpurchase_dollars_unwtdpurchase_grams_unwtdnumber_storesunit_value_mean_wtdunit_value_se_wtdunit_value_mean_unwtdprice_index_geks
12012110000Whole-grain breadsGrainsWhole-grain breads, cereal, rice, pasta, and flours0National249373446.5948751953624162985217.6332175581169417810.51151477640.0007686880.50654941330.9506893989
22012210000Whole-grain breadsGrainsWhole-grain breads, cereal, rice, pasta, and flours0National221806717.0343031809219151271985.929580905685417130.5154482720.00056872350.5113838890.9574933276
32012310000Whole-grain breadsGrainsWhole-grain breads, cereal, rice, pasta, and flours0National228860451.9344163705148159316789.0330972313780417170.51820935580.00058598610.51438452470.9595204018
42012410000Whole-grain breadsGrainsWhole-grain breads, cereal, rice, pasta, and flours0National222272932.443511461126154210561.4630313913114418660.51083766590.00055006950.50871215760.9462888149
52012510000Whole-grain breadsGrainsWhole-grain breads, cereal, rice, pasta, and flours0National229869146.6144876926984159388752.1331370959539417080.51222122830.00060901880.5080773890.9444149931

Query it — live

Use it

# every response carries x-license
curl "https://api.datafloe.dev/v1/datafloe/grocery-prices?year=2018" \
  -H "Authorization: Bearer datafloe_live_…"
const r = await fetch(
  "https://api.datafloe.dev/v1/datafloe/grocery-prices?year=2018",
  { headers: { Authorization: "Bearer datafloe_live_…" } }
);
const { data, meta } = await r.json();
import httpx
r = httpx.get(
  "https://api.datafloe.dev/v1/datafloe/grocery-prices",
  params={"year": "2018"},
  headers={"Authorization": "Bearer datafloe_live_…"},
)
data = r.json()["data"]

License · machine-readable

{
  "license_id": "us-public-domain@1",
  "spdx_analog": null,
  "rights": {
    "commercial_use": true,
    "redistribution": true,
    "raw_download": true,
    "ai_training": false
  },
  "attribution_required": false,
  "attribution_text": "U.S. Department of Agriculture, Economic Research Service. (2024). Food-at-Home Monthly Area Prices.",
  "provenance": {
    "uploader": "datafloe",
    "declared_origin": "licensed",
    "source_url": "https://www.ers.usda.gov/data-products/food-at-home-monthly-area-prices",
    "version": "2018-12",
    "content_hash": "sha256:27f9450b747e8f1f63821165ae31c3746a0c35afc11caaf66e7c2df15c485940",
    "published_at": "2018-12-01"
  },
  "price": {
    "model": "free",
    "monthly_usd": 0
  },
  "terms_url": "https://www.usa.gov/government-works"
}

ai_training is false on every dataset by design — you learn we're license-explicit before training rights are ever sold.