What JSON is
JSON is a text format for nested data: objects with named keys, arrays, strings, numbers, booleans and null. It has no date type and no comments.
Every web API, most configuration files and anything that talks to JavaScript.
What Markdown is
A Markdown table is rows of pipe-separated cells with a dashed rule under the header. Alignment is set by placing colons in that rule.
README files, GitHub issues, documentation sites, Obsidian and Notion.
What changes when you convert JSON to Markdown
Four shapes all read correctly: an array of objects, an array of arrays with a header row, an object of column arrays, and an object keyed by row id. A single wrapper key holding the array, which is how most APIs reply, is unwrapped automatically. Nested objects are flattened one level into dotted keys; anything deeper is kept as JSON text in the cell, because a table cannot hold a tree.
Cells are padded so the source lines up in a plain text editor, pipes inside values are escaped, and line breaks inside a cell become <br> because a Markdown table row cannot span lines.
Keys become the header row and each record becomes a table row. Records with different keys are unioned, so an optional field becomes a column that is blank where it was missing.
Pipes inside your values are escaped, because an unescaped pipe ends the cell. A value like a|b would otherwise silently become two columns and push every later column along by one.
Line breaks inside a value become <br>. A Markdown table row ends at the newline, so there is no other way to keep a multi-line value in a cell.
What carries over from JSON to Markdown
JSON records 4 things about a table that Markdown has no way to hold.
JSON distinguishes a number from the text of a number; Markdown does not, so every value arrives as text and has to be re-parsed by whatever reads it next.
An empty cell and a missing one are the same thing in Markdown, so a null and an empty string in the JSON both come out blank and can no longer be told apart.
JSON can hold a value that is itself a list or an object. Markdown has only flat cells, so nested values are flattened into one cell rather than being spread across columns.
A line break inside a cell ends the row in Markdown, so line breaks are replaced rather than carried through.
Markdown marks header cells differently from data cells, so the keys are lifted out and written once as a marked header row rather than repeated on every row.
The identifier 007 comes out of the Markdown as 007. Reading it as a number would have made it 7, and an id that changes value is worse than one that stays text.
The role "Analyst, data" survives with its comma, in one cell rather than split across two. That is the first thing to check in any converted table, and the usual place a Markdown file goes wrong.
The quotes around Jonah "Jo" Pryce are left as a plain quote character in the Markdown.