garden

Data source: Myles' Garden · About: Myles' Garden Dataset

Custom SQL query

Tables

book

_id, _path, text, html, isbn, title, authors, cover, series, seriesNumber, publishedDate, numOfPages

81 rows

book_series

_id, _path, text, html, title, type

7 rows

film

_id, _path, text, html, title, tmdbId, poster, imdbId, releaseDate

51 rows

location

_id, _path, text, html, type, streetAddress, locality, region, postalCode, countryName, latitude, longitude, name, url, extendedAddress

27 rows

nail_polish

slug, label, colour, url

6 rows

persona

_id, _path, text, html, name, givenName, familyName, role, pronouns, org, showOn, photo, email, url, birthday

7 rows

post

_id, _path, text, html, type, name, summary, emoji, publishedAt, updatedAt, author, tags, location, syndication, inReplyTo, bookmarkOf, rsvp, likeOf, repostOf, visibility, cover, media, book, film, tvShowSeason, vinylRecord, listenOnUrls, playlist, leftHand, rightHand, readStatus, currentPage, event, watchStatus

0 rows

post_type

_id, _path, text, html, type, name, emoji, summary, indieweb, showOn, weight

10 rows

project

_id, _path, text, html, type, name, summary, status, category, cover, postTag, useCases, stack, links, showOn, url

0 rows

resume_employer

_id, _path, text, html, name, url, logo

9 rows

resume_experience

_id, _path, text, html, position, startDate, endDate, employer, personas, location, skills, persona

7 rows

resume_skill

_id, _path, text, html, name, level, yearsExperience, category, tag, showOn

18 rows

resume_volunteering

_id, _path, text, html, position, startDate, endDate, employer, personas, location

4 rows

roadmap_entry

_id, _path, text, html, status, name, summary, quarter, completedAt, relatedPost, startedAt, linearUrl

11 rows

slash_page

_id, _path, text, html, emoji, name, summary, head, weight, showOn, isStub

20 rows

tag

_id, _path, text, html, type, name, summary, emojis, location, party

0 rows

tv_show

_id, _path, text, html, title, tmdbId, poster, imdbId

21 rows

tv_show_season

_id, _path, text, html, seasonNumber, tvSeries, episodes

86 rows

vinyl_record

_id, _path, text, html, title, artists, cover, releaseDate, trackList, listenOnUrls, discogsReleaseId

4 rows

vinyl_record_artist

_id, _path, text, html, name, discogsArtistId

4 rows

Download SQLite DB: garden.db 600.0 KB