images_view (view)

1 row where path = "greater-seattle/IMG_2677.jpg"

✎ View and edit SQL

This data as json, CSV (advanced)

path stem url image_blob classification hash
greater-seattle/IMG_2677.jpg IMG_2677 https://gallery.teddysc.me/greater-seattle/IMG_2677.jpg 
[
    {
        "label": "PERSIAN CAT",
        "score": 0.6560133695602417
    },
    {
        "label": "LYNX",
        "score": 0.12845765054225922
    },
    {
        "label": "NORWICH TERRIER",
        "score": 0.022070471197366714
    },
    {
        "label": "ANGORA",
        "score": 0.017021477222442627
    },
    {
        "label": "TIGER CAT",
        "score": 0.010831443592905998
    }
]
 8db4b0d26e782f3f3891522da3f8e11b84bb5db902e8dae145103acf276fdb09

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW images_view AS 
SELECT
	i.*,
	r.classification,
	h.hash
FROM
	images i
	JOIN resnet50 r ON i.path = r.path
	JOIN hashes h ON i.path = h.path;