Convert json files to tsv text blob

jq -r 'keys | join("\t")' $(ls -f *.json | head -1) && jq -Sr 'to_entries | [ .[] | .value | tostring ] | join("\t")' *.json
Grabs the first JSON file in the directory, reads its keys, prints TSV, then prints all the json files' values as TSV. Nested objects appear as json. Unhappy times if your json has literal tabs in it.
Sample Output
_id	about	address	age	balance	company	email	eyeColor	favoriteFruit	friends	greeting	guid	index	isActive	latitude	longitude	name	phone	picture	range	registered	tags
57083c8b5ff65f57d375e255	0	73e73186-ba78-4e6d-9663-57eb5919bbc9	true	$2,005.56	http://placehold.it/32x32	30	blue	{"first":"Blackburn","last":"Miranda"}	PULZE	blackburn.miranda@pulze.us	+1 (836) 438-3256	389 Rockwell Place, Southmont, California, 6347	Anim ullamco velit enim ullamco sunt sunt ipsum tempor pariatur officia aute. Pariatur incididunt Lorem excepteur deserunt deserunt officia minim sint nisi cillum et magna fugiat. Do laboris dolore ipsum pariatur velit. Exercitation excepteur exercitation cillum eiusmod labore magna. Voluptate nulla veniam tempor minim anim est consectetur incididunt cupidatat ex. Eiusmod ex velit cupidatat Lorem minim do mollit ullamco sunt culpa excepteur.	Thursday, November 6, 2014 10:03 AM	60.671996	-94.85247	[7,"in"]	[0,1,2,3,4,5,6,7,8,9]	[3,{"id":1,"name":"Dunn Daniel"}]	Hello, Blackburn! You have 9 unread messages.	banana
57083c8b2f9273e388599eb8	1	b46e8e63-26c4-4fd6-b4d4-bae8f57b4f4c	false	$3,922.02	http://placehold.it/32x32	28	green	{"first":"Stark","last":"King"}	PRISMATIC	stark.king@prismatic.tv	+1 (966) 491-3883	622 Irving Avenue, Eastmont, Maine, 9966	Quis officia nisi et tempor anim sit velit. Eu aliqua eu ut eu amet enim aute cupidatat quis qui do aute. Sunt eiusmod veniam excepteur proident veniam pariatur exercitation. Dolore id nulla eu laborum laborum labore. Ad tempor Lorem in ipsum consequat eu ad nisi adipisicing irure. Amet non pariatur amet sint.	Saturday, July 25, 2015 6:51 AM	57.349475	85.773508	[7,"in"]	[0,1,2,3,4,5,6,7,8,9]	[3,{"id":1,"name":"Dunn Daniel"}]	Hello, Stark! You have 9 unread messages.	banana
57083c8b71acd0f59fedc36a	2	ae36f083-b123-402f-91d1-67cf2e450feb	true	$1,977.56	http://placehold.it/32x32	29	blue	{"first":"Stone","last":"Carroll"}	FROLIX	stone.carroll@frolix.me	+1 (874) 452-3838	938 Dahill Road, Sexton, Connecticut, 9259	Eiusmod tempor esse aute sit dolor aute aute occaecat aliquip occaecat esse officia. Sint amet cupidatat in magna voluptate. Aliqua consectetur et exercitation ullamco minim ut nostrud. Elit laboris Lorem commodo Lorem elit velit cupidatat velit dolor eiusmod eu in eu minim.	Saturday, August 22, 2015 9:30 PM	-70.378489	97.38272	[7,"in"]	[0,1,2,3,4,5,6,7,8,9]	[3,{"id":1,"name":"Dunn Daniel"}]	Hello, Stone! You have 8 unread messages.	apple
57083c8b20ae0667d75e7ef0	3	6d32ca46-07ba-42b9-85dc-07c3fe7f6c10	false	$2,170.25	http://placehold.it/32x32	33	green	{"first":"Latonya","last":"Ware"}	ANARCO	latonya.ware@anarco.biz	+1 (845) 569-2733	465 Myrtle Avenue, Lynn, Oklahoma, 3826	Aliqua amet officia deserunt enim minim eu labore consectetur sunt mollit sint officia fugiat dolor. Aliquip eu adipisicing id laborum quis culpa. Ut velit do deserunt voluptate tempor in anim magna aliquip ipsum in dolor. Minim culpa ea ut cupidatat consequat. Minim commodo veniam ut pariatur fugiat. Culpa tempor labore excepteur commodo sit adipisicing mollit in dolor qui incididunt et sit consectetur.	Sunday, March 22, 2015 12:39 AM	-67.522617	-105.250561	[7,"in"]	[0,1,2,3,4,5,6,7,8,9]	[3,{"id":1,"name":"Dunn Daniel"}]	Hello, Latonya! You have 10 unread messages.	strawberry
57083c8c3324cf5366112c8e	4	28f78639-595c-4e3b-8261-b7e109f58638	false	$3,587.78	http://placehold.it/32x32	27	green	{"first":"Juana","last":"Crane"}	ROCKYARD	juana.crane@rockyard.org	+1 (994) 457-3481	747 Ovington Avenue, Northridge, Oregon, 142	Aliqua quis nulla velit dolore consequat irure in laborum voluptate esse. Duis consectetur non aliqua eu labore. Exercitation officia adipisicing pariatur laboris commodo duis elit irure est ex est eiusmod. Qui aliquip qui eiusmod do aliqua fugiat minim aliquip elit.	Monday, November 16, 2015 6:21 PM	-67.487595	48.295541	[7,"in"]	[0,1,2,3,4,5,6,7,8,9]	[3,{"id":1,"name":"Dunn Daniel"}]	Hello, Juana! You have 5 unread messages.	banana

0
By: drjeats
2016-04-08 23:30:30

What Others Think

where to get shrooms dried mushrooms african pyramid mushroom african transkei mushroom albino penis envy b+ mushrooms blue meanies mushroom brazilian magic mushroom burmese mushroom golden teacher mushroom ko samui super strain malabar coast martinique mexican mushroom mushroom british columbia super thai mushroom nepalese chitwan mushroom penis envy texas penis envy 6 texas yellow caps vietnamese white jedi mind fuck tri coloured ecuadorian mushroom magic mushsroom edibles mexican cubensis psychedelic chocolate bar where to get shrooms dried mushrooms african pyramid mushroom african transkei mushroom albino penis envy b+ mushrooms blue meanies mushroom brazilian magic mushroom burmese mushroom golden teacher mushroom ko samui super strain malabar coast martinique mexican mushroom mushroom british columbia super thai mushroom nepalese chitwan mushroom penis envy texas penis envy 6 texas yellow caps vietnamese white jedi mind fuck tri coloured ecuadorian mushroom magic mushsroom edibles mexican cubensis psychedelic chocolate bar midnight mint psychedelic chocolate bar origin mango psilo gummies 0.25g-1g origin strawberry psilo gummies 0.25g-1g penis envy psychedelic chocolate bar psilocybin cube gummies vegan dark chocolate psychedelic chocolate bar microdoses brain capsules 50mg-200mg chill capsules 50mg-200mg clarity capsules 50mg-200mg health capsules 50mg-200mg love capsules 50mg-200mg mood capsules 50mg-200mg pure capsules 50mg-200mg social capsules 30 pack 350mg social capsules 5 pack 350mg buy weed online without medical card marijuana flowers types of concentrates cannabis cartridges buy edibles online legal marijuana shatter cannabis wax marijuana hash buy psychedelic online tinctures for anxiety cannabis seeds bank weed smoker accessories birthday cake kush acdc strain ace killer og strain ak 47 strain alaskan thunder fuck alien kush strain ambrosia kush strain atomik moon rocks cbd 40.57% atomik moon rocks diamond 58.77% banana og strain bc big bud strain birthday cake kush blue cheese strain blue dream og kush blue moonrock kush blue rhino strain blueberry kush strain bruce banner strain cannabis trim cherry pie strain cannatonic strain citrix strain dark star kush durban poison strain eleven roses strain g13 haze strain gelato strain girl scout cookies flavors girl scout cookies online granddad purple strain grape nana weed strains grape pie strain green crack strain guava kush strain hawaiian skunk jack herer strain mendo breath weed mighty mango mr nice guy weed blue mystic strain northern lights strain northern lights moon rock platinum og kush gas og strain pink og kush platinum hawaiian strain pootie tang strain purple mimosa strain purple white widow strain smart buds sour diesel weed strain sour moonrock strain space monkey tins strawberry banana weed sun rocks super citrus haze strain super silver haze wedding cake strain exotic white widows strain zombie kush strain all natural pistachio crunch apple fritter vape cartridge aura edibles gummy-candy banana og cartridge birthday cake dank vape pen cartridg biscotti vape cartridge blackberry kush cartridge bliss edibles 300mg thc blue dream cartridge 180mlg berry blue raspberry 500mg-chocolate chip- cookies atomic wheelchair activated thc distillate strike gold blue dream shatter bubba kush shatter cbd dried organic ginger blueberry kush vape cartridges chemdawg shatter 50mg choco chunk cookies cookies and cream vape delta 8 thc capsules do-si-dos cartridges durban poison vape cartridge eds and bills edible candy bags forbidden fruit cartridge fruity pebbles cartridge gelato cartridge 1000mg girl scout cookies shatter girl scout cookies wax gorilla glue #4 wax gorilla glue cartridge gorilla glue shatter grand daddy purple kush wax gsc cartridge hardcore og cartridge jack herer cartridge jack herer wax jet fuel cartridge juicy melon cartridge khalifa kush shatter kosher kush cartridge labanese camel hash lemon berry cartridge
johnson20007 · 51 weeks and 6 days ago
Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com - Commandlinefu.Com
seofox · 33 weeks and 1 day ago
Amazing! This blog looks just like my old one! It's on a completely different subject but it has pretty much the same layout and design. Wonderful choice of colors! Pug Puppies for Sale Near Me PUG PUPPY FOR SALE NEAR ME PUG PUPPIES FOR SALE pug puppies for sale in kentucky Pug Puppies for Sale Under $500 Near Me pug puppies for sale in texas pugs puppies for sale teacup pugs for sale pug puppies for sale by owner pug puppies ohio
rahimhh21 · 23 weeks and 3 days ago
Pug Puppies for Sale Near Me pugs puppies for sale teacup pugs for sale pug puppies for sale by owner pug puppies ohio PUG PUPPY FOR SALE NEAR ME PUG PUPPIES FOR SALE pug puppies for sale in kentucky Pug Puppies for Sale Under $500 Near Me pug puppies for sale in texas pug puppies for sale $200 pugs for sale near me under $500 pugs for sale under $400 near me pugs for sale near me puppies for sale near me under $500 pug puppies for sale under $1,000 near me pug for sale pug puppies for sale under $300 Brindle Pug Pitbull Pug Mix Pugs for sale cheap Cheap pug affordable pug puppies for sale near me black pugs for sale near me White Pugs for sale pug dog for sale free pug puppies pug puppies for sale in my area mn pug breeders pug puppies indiana pugs for sale michigan PUG PUPPY ADOPTION Pug puppies for sale Pug puppies for sale near me Pug puppies near me Pug Puppies for Sale Under $500 Near Me Cute Pug Puppies Black pug puppies Black pug puppies for sale pug puppies for adoption black pug puppies for sale near me chihuahua pug mix puppies how much is a pug puppy teacup pug puppies baby pug puppies pictures of pug puppies pug puppies for sale in Ohio pug puppies price pug mix puppies teacup pug puppies for sale best food for pug puppy newborn pug puppies pug puppies craigslist pug puppies for sale craigslist adorable pug puppies how much does a pug puppy cost Pitbull pug mix puppies pug pit mix puppy pug puppies for sale $200 pug puppies for sale in NJ Pug puppies for sale in Wisconsin pug puppy cost pug puppy food royal canin pug puppy royal canin pug puppy food fawn pug puppy pug puppies for sale florida pug puppies for sale in Indiana pug puppies for sale in KY/A> pug puppies for sale in NC pug dog puppy AKC Registered Pug Puppies For sale cheap pug puppies for sale near me cheap pug puppies for sale in California cheap pug puppies for sale in nj Black Pug Puppies for sale pugs puppies for sale
AnthonyLewis9201 · 17 weeks and 5 days ago
Pug Puppies for Sale Near Me pugs puppies for sale teacup pugs for sale pug puppies for sale by owner pug puppies ohio PUG PUPPY FOR SALE NEAR ME PUG PUPPIES FOR SALE pug puppies for sale in kentucky Pug Puppies for Sale Under $500 Near Me pug puppies for sale in texas pug puppies for sale $200 pugs for sale near me under $500 pugs for sale under $400 near me pugs for sale near me puppies for sale near me under $500 pug puppies for sale under $1,000 near me pug for sale pug puppies for sale under $300 Brindle Pug Pitbull Pug Mix Pugs for sale cheap Cheap pug affordable pug puppies for sale near me black pugs for sale near me White Pugs for sale pug dog for sale free pug puppies pug puppies for sale in my area mn pug breeders pug puppies indiana pugs for sale michigan PUG PUPPY ADOPTION Pug puppies for sale Pug puppies for sale near me Pug puppies near me Pug Puppies for Sale Under $500 Near Me Cute Pug Puppies Black pug puppies Black pug puppies for sale pug puppies for adoption black pug puppies for sale near me chihuahua pug mix puppies how much is a pug puppy teacup pug puppies baby pug puppies pictures of pug puppies pug puppies for sale in Ohio pug puppies price pug mix puppies teacup pug puppies for sale best food for pug puppy newborn pug puppies pug puppies craigslist pug puppies for sale craigslist adorable pug puppies how much does a pug puppy cost Pitbull pug mix puppies pug pit mix puppy pug puppies for sale $200 pug puppies for sale in NJ Pug puppies for sale in Wisconsin pug puppy cost pug puppy food royal canin pug puppy royal canin pug puppy food fawn pug puppy pug puppies for sale florida pug puppies for sale in Indiana pug puppies for sale in KY pug puppies for sale in NC pug dog puppy AKC Registered Pug Puppies For sale cheap pug puppies for sale near me cheap pug puppies for sale in California cheap pug puppies for sale in nj Black Pug Puppies for sale pugs puppies for sale
Perfecthomepugs · 13 weeks and 3 days ago
what is ketamine / how long does ketamine stay in your system / buy ketamine / buy ketamine online / Buy Ketamine Online USA / Where to buy ketamine Online in California USA / Buy Ketamine Online France / where to buy ketamine online / how to buy ketamine online / buy ketamine UK / buy ketamine EU / BUY KETAMINE CANADA / buy ketamine powder / buy ketamine hcl / buy ketamine / buy ketamine online / where to buy ketamine / where can i buy ketamine / how to buy ketamine / were to buy ketamine / can you buy ketamine / where can you buy ketamine / buy ketamine legally / can you buy ketamine online / how to buy ketamine online / can i buy ketamine / where to buy ketamine online / buy ketamine powder / buy ketamine powder online / buy ketamine nasal spray / how long does ketamine stay in the body / how long does ketamine last / how long does ketamine stay in the blood / buy ketamine usa / where do you buy ketamine / buy ketamine securely online buy ketamine online Italy / buy ketamine vials / buy ketamine online china / buy ketamine Germany / can you buy ketamine over the counter / where to buy ketamine / buy ketamine hcl crystal online / buy ketamine nasal spray online / can i buy ketamine online / buy ketamine vials online / buy ketamine hcl crystal powder online / buy ketamine hcl liquid online / where can i buy ketamine online / buy ketamine hcl / how can i buy ketamine / what is the use of ketamine / madical uses of ketamine / how is ketamine taken / ketamine for sale / buy ketamine with discreet shipping / ketamine for sale in usa / buy ketamine crystal online / can you buy ketamine hydrochloride / buy ketamine liquid online / buy ketamine from china / buy ketamine hcl crytal powder online / best store to by ketamine online / buy ketamine over night delivery / buy ketamine antidepressant / buy ketamine online / buy ketamine horse / i promise i'm not actually trying to buy ketamine it's for my thesis script / buy ketamine cream no rx / can i buy ketamine pharmacy mexico / buy ketamine "powered by ip.board" / buy ketamine drug in usa / best websites to buy ketamine / buy ketamine bahamas / can you buy ketamine in canada / can i buy ketamine hydrochloride / how to buy ketamine for animals / do you need a prescription to buy ketamine / buy ketamine for cat / legal to buy ketamine inline / where to buy ketamine in usa / where do teen buy ketamine / how to buy ketamine reddit / can you buy ketamine at the animal supply store / how to buy ketamine hcl / buy ketamine / sell these presents to buy ketamine i must / buy ketamine silkroad-pharmacy / buy ketamine poland / buy ketamine tijuana / can you buy ketamine in mexico / legal to buy ketamine e / how to buy ketamine without an rx / buy ketamine cream / can you legally buy ketamine / wher to buy ketamine in pakistan / buy ketamine Europe / where can buy ketamine france / buy ketamine for vetenary use / buy ketamine analov / where can i buy ketamine hydrochloride / can you legally buy ketamine without script in usa / buy ketamine legally online / buy ketamine in NY / buy ketamine online for ptsd / i promise i'm not actually trying to buy ketamine big brother it's for my thesis screenplay / l where to buy ketamine in spain / buy ketamine / where to buy ketamine los angeles / how do i buy ketamine / can i legally buy ketamine india / where to buy ketamine online / buy ketamine gas station kenya / buy ketamine pills online / how do you buy ketamine / buy ketamine india / buy ketamine UK / where to buy ketamine vials / buy ketamine without prescription / can you buy ketamine on internet / Buy ketamine online in Sweden / how to legally buy ketamine / Buy Ketamine Online NEAR ME / buy ketamine 1000mg vial / buy ketamine Australia / buy ketamine online no prescription / Buy ketamine discreetly online in Liechtenstein / Buy ketamine discreetly online in Slovenia / Buy ketamine discreetly online in Andorra / Buy ketamine discreetly online in Latvia / Buy ketamine discreetly online in Georgia / Buy ketamine discreetly online in Azerbaijan / Buy ketamine discreetly online in Armenia / Buy ketamine discreetly online in Luxembourg / Buy ketamine discreetly online in Austria / Buy ketamine discreetly online in Lithuania / Buy ketamine discreetly online in Switzerland / Buy ketamine discreetly online in Albania / Buy ketamine discreetly online in Netherlands / buy ketamine in mexico Where To Buy Ketamine Online In Canada | Buy ketamine Buy Ketamine Online Buy Ketamine Online USA Where to buy ketamine Online in California USA Ketamine For Sale Discreet Shipping UK Buy Ketamine Near Me Europe Buy Ketamine Online France Buy Ketamine Online NEAR ME where to buy ketamine in USA how to buy ketamine Online USA Discreet Shipping Ketamine HCL For Sale In Los angeles Buy Ketamine Powder Online Where To Buy Ketamine Online In Canada | order ketamine online WhatsApp text and call + 1 (408) 634 4006 Email:jugeketamine1@gmail.com weather you need bulk in kilos or retail in grams neither liquids in vials or liquid in litters we are specialize only in ketamine supply
Princesmith · 6 weeks and 6 days ago
SENSA838 selaku situs agen slot online terbaik no 1 di Indonesia akan selalu menyediakan layanan yang terbaik dan bisa memuaskan para member setia kami. Diantara nya seperti memberikan informasi mengenai daftar provider slot gacor dan terpopuler saat ini. SENSA838 Bukan hanya sekedar memberikan statement sebagai situs tergacor 2022 saat ini, kami membuktikan dengan memberikan jaminan garansi gacor 100% atau biasa di sebut garansi kekalahan 100%. Yang di mana apabila member baru deposit dan mengalami kekalahan pertamanya maka member berhak mengklaim garansi kekalahan 100% sesuai dengan syarat dan ketentuan yang berlaku. Menarik kan ? Main slot kalah dan bisa klaim kembali saldo nya. Promo ini hanya berlaku untuk member yang baru melakukan deposit untuk pertama kali nya. Cara klaim nya juga sangat mudah sekali. Member hanya perlu melapor ke CS Livechat SENSA838 yang bertugas 24 jam dimana fitur klaim garansi nya terdapat di bagian pojok kanan bawah di halaman situs kami.
missmawar222 · 5 weeks and 1 day ago

What do you think?

Any thoughts on this command? Does it work on your machine? Can you do the same thing with only 14 characters?

You must be signed in to comment.

What's this?

commandlinefu.com is the place to record those command-line gems that you return to again and again. That way others can gain from your CLI wisdom and you from theirs too. All commands can be commented on, discussed and voted up or down.

Share Your Commands



Stay in the loop…

Follow the Tweets.

Every new command is wrapped in a tweet and posted to Twitter. Following the stream is a great way of staying abreast of the latest commands. For the more discerning, there are Twitter accounts for commands that get a minimum of 3 and 10 votes - that way only the great commands get tweeted.

» http://twitter.com/commandlinefu
» http://twitter.com/commandlinefu3
» http://twitter.com/commandlinefu10

Subscribe to the feeds.

Use your favourite RSS aggregator to stay in touch with the latest commands. There are feeds mirroring the 3 Twitter streams as well as for virtually every other subset (users, tags, functions,…):

Subscribe to the feed for: