Skip to content

Instantly share code, notes, and snippets.

@jeroenjanssens
Last active June 8, 2018 08:37
Show Gist options
  • Save jeroenjanssens/4210778f660026ec67bcb6aa1c9cb714 to your computer and use it in GitHub Desktop.
Save jeroenjanssens/4210778f660026ec67bcb6aa1c9cb714 to your computer and use it in GitHub Desktop.
Some jq examples translated from https://github.com/jsonlines/guide

Some jq examples translated from https://github.com/jsonlines/guide

jq can be downloaded from https://stedolan.github.io/jq/download/.

curl https://raw.githubusercontent.com/jsonlines/guide/master/datagov100.json > data.json
$ < data.json jq '.name' | head -n 6
"va-national-formulary"
"safer-company-snapshot-safer-company-snapshot"
"fatality-analysis-reporting-system-fars-ftp-raw-data"
"tiger-line-shapefile-2013-state-alabama-current-county-subdivision-state-based"
"tiger-line-shapefile-2013-state-virginia-current-county-subdivision-state-based"
"national-motor-vehicle-crash-causation-survey-nmvccs-nmvccs-xml-case-viewer"
$ < data.json jq '.organization.name' | head -n 6
"va-gov"
"dot-gov"
"dot-gov"
"census-gov"
"census-gov"
"dot-gov"
$ < data.json jq '.organization.name' | sort | uniq -c | head -n 8
  58 "census-gov"
  14 "dot-gov"
   2 "gsa-gov"
   1 "nsf-gov"
   8 "opm-gov"
   1 "ssa-gov"
  11 "usgs-gov"
   5 "va-gov"
$ < data.json jq -c '{name: .name, organization: .organization.name }' | head -n 3
{"name":"va-national-formulary","organization":"va-gov"}
{"name":"safer-company-snapshot-safer-company-snapshot","organization":"dot-gov"}
{"name":"fatality-analysis-reporting-system-fars-ftp-raw-data","organization":"dot-gov"}
$ < data.json jq -c '"Notes: " + .notes[0:60] + "..."' | head -n 3
"Notes: The VA National Formulary is a listing of products (drugs an..."
"Notes: The Company Snapshot is a concise electronic record of compa..."
"Notes: The program collects data for analysis of traffic safety cra..."
$ < data.json jq -c 'select(.maintainer) | . + { maintainer: (.maintainer | ascii_upcase) }' | head -n 3 | cut -c1-82
{"license_title":"Creative Commons CCZero","maintainer":"DON LEES","relationships_
{"license_title":"Other License Specified","maintainer":"JAMIE VASSER","relationsh
{"license_title":"U.S. Government Work","maintainer":"LIXIN ZHAO","relationships_a
$ < data.json jq -c 'if .license_id == "cc-zero" then "Open" else "Closed" end' | head -n 3
"Open"
"Closed"
"Closed"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment