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

77 rows

book_series

_id, _path, text, html, title, type

7 rows

event

_id, _path, text, html, emoji, name, startsAt, isAllDay, location

12 rows

film

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

42 rows

location

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

20 rows

nail_polish

slug, label, colour, url

5 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

100 rows

post_type

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

9 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, githubIssue

11 rows

slash_page

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

19 rows

tag

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

118 rows

tv_show

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

19 rows

tv_show_season

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

78 rows

vinyl_record

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

4 rows

vinyl_record_artist

_id, _path, text, html, name, discogsArtistId

4 rows

Download SQLite DB: garden.db 688.0 KB