Skip to content

Instantly share code, notes, and snippets.

@aparrish
Created November 1, 2016 20:15
Show Gist options
  • Save aparrish/8a2359853cf60c02280000142694166d to your computer and use it in GitHub Desktop.
Save aparrish/8a2359853cf60c02280000142694166d to your computer and use it in GitHub Desktop.
Helpful JSONPath paths for getting lists of strings from Corpora Project data files with unusual structures. More info about JSONPath: http://goessner.net/articles/JsonPath/
{
"description": "Helpful JSONPath paths for getting lists of strings from Corpora Project data files with unusual structures",
"paths": [
{
"name": "animals.birds_antarctica.families",
"desc": "Families of Antarctic birds",
"src": "animals/birds_antarctica.json",
"query": "$.birds[*].family"
},
{
"name": "animals.birds_antarctica",
"desc": "Antarctic birds",
"src": "animals/birds_antarctica.json",
"query": "$.birds[*].members[*]"
},
{
"name": "animals.birds_north_america.families",
"desc": "North American bird families",
"src": "animals/birds_north_america.json",
"query": "$.birds[*].family"
},
{
"name": "animals.birds_north_america",
"desc": "North American birds",
"src": "animals/birds_north_america.json",
"query": "$.birds[*].members[*]"
},
{
"name": "archetypes.artifact.names",
"desc": "Archetypical artifacts",
"src": "archetypes/artifact.json",
"query": "$.artifacts[*].name"
},
{
"name": "archetypes.character.names",
"desc": "Archetypical characters",
"src": "archetypes/character.json",
"query": "$.characters[*].name"
},
{
"name": "archetypes.event.names",
"desc": "Archetypical events",
"src": "archetypes/event.json",
"query": "$.events[*].name"
},
{
"name": "archetypes.setting.names",
"desc": "Archetypical settings",
"src": "archetypes/setting.json",
"query": "$.settings[*].name"
},
{
"name": "colors.crayola",
"desc": "Names of Crayola crayons",
"src": "colors/crayola.json",
"query": "$.colors[*].color"
},
{
"name": "colors.paints",
"desc": "Names of paint colors from various brands",
"src": "colors/paints.json",
"query": "$.colors[*].color"
},
{
"name": "colors.web_colors",
"desc": "Names of HTML colors",
"src": "colors/web_colors.json",
"query": "$.colors[*].color"
},
{
"name": "corporations.djia.names",
"desc": "Names of Dow Jones Industrial Average corporations",
"src": "corporations/djia.json",
"query": "$.corporations[*].name"
},
{
"name": "corporations.djia.symbols",
"desc": "Symbols of Dow Jones Industrial Average corporations",
"src": "corporations/djia.json",
"query": "$.corporations[*].symbol"
},
{
"name": "corporations.fortune500",
"desc": "Names of 2014 Fortune 500 companies",
"src": "corporations/fortune500.json",
"query": "$.companies[*]"
},
{
"name": "corporations.nasdaq.names",
"desc": "Names of NASDAQ corporations",
"src": "corporations/nasdaq.json",
"query": "$.corporations[*].name"
},
{
"name": "corporations.nasdaq.symbols",
"desc": "Symbols of NASDAQ corporations",
"src": "corporations/nasdaq.json",
"query": "$.corporations[*].symbol"
},
{
"name": "foods.sandwiches",
"desc": "Names of sandwiches",
"src": "foods/sandwiches.json",
"query": "$.sandwiches[*].name"
},
{
"name": "games.cluedo.suspects",
"desc": "Clue/Cluedo suspects",
"src": "games/cluedo.json",
"query": "$.suspects..[*]"
},
{
"name": "games.cluedo.weapons",
"desc": "Clue/Cluedo weapons",
"src": "games/cluedo.json",
"query": "$.weapons..[*]"
},
{
"name": "games.cluedo.rooms",
"desc": "Clue/Cluedo rooms",
"src": "games/cluedo.json",
"query": "$.rooms[*]"
},
{
"name": "games.jeopardy_questions.questions",
"desc": "Jeopardy questions",
"src": "games/jeopardy_questions.json",
"query": "$.questions[*].question"
},
{
"name": "games.jeopardy_questions.answers",
"desc": "Jeopardy answers",
"src": "games/jeopardy_questions.json",
"query": "$.questions[*].answer"
},
{
"name": "games.jeopardy_questions.categories",
"desc": "Jeopardy categories",
"src": "games/jeopardy_questions.json",
"query": "$.questions[*].category"
},
{
"name": "games.pokemon",
"desc": "Pokemon names",
"src": "games/pokemon.json",
"query": "$.pokemon[*].name"
},
{
"name": "games.street_fighter_ii.characters",
"desc": "Street Fighter II characters",
"src": "games/street_fighter_ii.json",
"query": "$.characters[*].character"
},
{
"name": "games.street_fighter_ii.moves",
"desc": "Street Fighter II moves",
"src": "games/street_fighter_ii.json",
"query": "$.characters[*].moves[*]"
},
{
"name": "games.trivial_pursuit.categories",
"desc": "Trivial Pursuit category names",
"src": "games/trivial_pursuit.json",
"query": "$.pie[*].category"
},
{
"name": "geography.english_towns_cities",
"desc": "English towns and cities",
"src": "geography/english_towns_cities.json",
"query": "$.[towns,cities][*]"
},
{
"name": "geography.london_underground_stations",
"desc": "London Underground stations",
"src": "geography/london_underground_stations.json",
"query": "$.stations[*].name"
},
{
"name": "geography.rivers",
"desc": "Rivers",
"src": "geography/rivers.json",
"query": "$.rivers[*].name"
},
{
"name": "geography.us_cities",
"desc": "Names of top 1000 U.S. cities by 2013 population",
"src": "geography/us_cities.json",
"query": "$.cities[*].city"
},
{
"name": "humans.richpeople",
"desc": "Names of a bunch of rich people",
"src": "humans/richpeople.json",
"query": "$.richPeople[*].name"
},
{
"name": "humans.us_presidents",
"desc": "Names of US presidents",
"src": "humans/us_presidents.json",
"query": "$.objects[*].person.name"
},
{
"name": "instructions.laundry_care",
"desc": "Laundry care instructions",
"src": "instructions/laundry_care.json",
"query": "$.laundry_care_instructions[*].instruction"
},
{
"name": "music.mtv_day_one",
"desc": "Song names of music videos broadcast on MTV's first day",
"src": "music/mtv_day_one.json",
"query": "$.videos[*].song"
},
{
"name": "mythology.hebrew_gods",
"desc": "Hebrew names of God used in the Old Testament",
"src": "mythology/hebrew_god.json",
"query": "$.names[*].name"
},
{
"name": "mythology.lovecraft.deities",
"desc": "Deity names from Lovecraft",
"src": "mythology/lovecraft.json",
"query": "$.deities[*]"
},
{
"name": "mythology.lovecraft.supernatural_creatures",
"desc": "Supernatural creature names from Lovecraft",
"src": "mythology/lovecraft.json",
"query": "$.supernatural_creatures[*]"
},
{
"name": "science.elements.names",
"desc": "Names of the elements",
"src": "science/elements.json",
"query": "$.elements[*].name"
},
{
"name": "science.elements.symbols",
"desc": "Symbols of the elements",
"src": "science/elements.json",
"query": "$.elements[*].symbol"
},
{
"name": "science.planets.names",
"desc": "Names of planets",
"src": "science/planets.json",
"query": "$.planets[*].name"
},
{
"name": "science.planets.moons",
"desc": "Names of moons",
"src": "science/planets.json",
"query": "$.planets[*].moons[*]"
},
{
"name": "sports.nfl_teams.names",
"desc": "NFL team names",
"src": "sports/nfl_teams.json",
"query": "$.nfl_teams[*].name"
},
{
"name": "sports.nfl_teams.stadiums",
"desc": "NFL team stadiums",
"src": "sports/nfl_teams.json",
"query": "$.nfl_teams[*].stadium"
},
{
"name": "words.prefix_root_suffix.prefixes",
"desc": "English prefixes",
"src": "words/prefix_root_suffix.json",
"query": "$.prefixes[*].part"
},
{
"name": "words.prefix_root_suffix.roots",
"desc": "English roots",
"src": "words/prefix_root_suffix.json",
"query": "$.roots[*].part"
},
{
"name": "words.prefix_root_suffix.suffixes",
"desc": "English suffixes",
"src": "words/prefix_root_suffix.json",
"query": "$.suffixes[*].part"
},
{
"name": "words.proverbs",
"desc": "English proverbs",
"src": "words/proverbs.json",
"query": "$.proverbs[*].*[*]"
},
{
"name": "words.spells.incantations",
"desc": "Harry Potter spell incantations",
"src": "words/spells.json",
"query": "$.spells[*].incantation"
},
{
"name": "words.us_president_quotes",
"desc": "Quotes from US presidents",
"src": "words/us_president_quotes.json",
"query": "$.data[*].quotes[*]"
},
{
"name": "words.verbs.present",
"desc": "English present-tense verbs",
"src": "words/verbs.json",
"query": "$.verbs[*].present"
},
{
"name": "words.verbs.past",
"desc": "English past-tense verbs",
"src": "words/verbs.json",
"query": "$.verbs[*].past"
},
{
"name": "words.literature.mr_men_little_miss_characters",
"desc": "Mr Men and Little Miss characters, combined",
"src": "words/literature/mr_men_little_miss.json",
"query": "$..[*]"
},
{
"name": "words.literature.shakespeare_sonnets_lines",
"desc": "Lines from Shakespeare sonnets",
"src": "words/literature/shakespeare_sonnets.json",
"query": "$.sonnets[*].lines[*]"
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment