photos_with_apple_metadata (view)

11 rows where albums contains "Museums" and favorite = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: albums, persons, ext, place_city, place_state_province, place_country, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZINTERACTIONSCORE, date (date), albums (array), persons (array)

rowid photo uuid date albums persons ext sha256 size latitude longitude favorite portrait screenshot slow_mo time_lapse hdr selfie panorama place_city place_state_province place_country ZUUID ZOVERALLAESTHETICSCORE ZCURATIONSCORE ZPROMOTIONSCORE ZHIGHLIGHTVISIBILITYSCORE ZBEHAVIORALSCORE ZFAILURESCORE ZHARMONIOUSCOLORSCORE ZIMMERSIVENESSSCORE ZINTERACTIONSCORE ZINTERESTINGSUBJECTSCORE ZINTRUSIVEOBJECTPRESENCESCORE ZLIVELYCOLORSCORE ZLOWLIGHT ZNOISESCORE ZPLEASANTCAMERATILTSCORE ZPLEASANTCOMPOSITIONSCORE ZPLEASANTLIGHTINGSCORE ZPLEASANTPATTERNSCORE ZPLEASANTPERSPECTIVESCORE ZPLEASANTPOSTPROCESSINGSCORE ZPLEASANTREFLECTIONSSCORE ZPLEASANTSYMMETRYSCORE ZSHARPLYFOCUSEDSUBJECTSCORE ZTASTEFULLYBLURREDSCORE ZWELLCHOSENSUBJECTSCORE ZWELLFRAMEDSUBJECTSCORE ZWELLTIMEDSHOTSCORE
212 46BAA089-F20D-40E3-8161-5C0FA28FAA90 2019-09-11T16:31:25+00:00 
[
    "Museums",
    "Public"
]
 
[
    "_UNKNOWN_"
]
 heic 6952898f95114d886494ec5e9df99510a745a0d1ef1fef61d7d924234284f687 1910261 29.934663333333333 -90.06162216666667 1 0 0 0 0 0 0 0 New Orleans LA United States 46BAA089-F20D-40E3-8161-5C0FA28FAA90 0.57666015625 0.75 0.0 0.0580211847110559 0.10000000149011612 -0.00044083595275878906 0.00860595703125 0.0017414093017578125 0.14000000059604645 0.34814453125 -0.051177978515625 0.31787109375 0.0015125274658203125 -0.01107025146484375 0.000823974609375 -0.06640625 -0.00482177734375 0.06878662109375 -0.014892578125 0.00110626220703125 -0.015899658203125 0.0032978057861328125 0.0634765625 0.028564453125 -0.33447265625 0.505859375 -0.003997802734375
43 A06B7B8E-4BF6-4906-A1E6-0CA4CF0E28E8 2019-08-07T06:22:37+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic 1698c710dab87f0f6aeee3f3ef95a0c7f1296abc949dc5d602cdff89c6ec63c5 2233828 -18.907088333333334 47.518475 1 0 0 0 0 0 0 0 Antananarivo Antananarivo Madagascar A06B7B8E-4BF6-4906-A1E6-0CA4CF0E28E8 0.32763671875 0.75 0.0 0.05801763419659083 0.7049635052680969 -0.0004305839538574219 0.07659912109375 0.002471923828125 0.019999999552965164 0.728515625 -0.0227203369140625 0.0977783203125 0.01422882080078125 -0.004398345947265625 0.0112457275390625 0.47314453125 0.401123046875 0.0261077880859375 0.326416015625 0.042083740234375 0.005859375 0.007038116455078125 0.63232421875 0.70458984375 0.4091796875 0.88330078125 0.5439453125
151 43A4A851-4821-4125-A673-C1E9FCF2F9AC 2019-06-03T21:20:05+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic 487c1ddfc65c37e0d20b4eb88864fd696fa68f5af025a4597115a7870d4a9e53 1917644 38.576375 -121.49330833333333 1 0 0 0 0 0 0 0 Sacramento CA United States 43A4A851-4821-4125-A673-C1E9FCF2F9AC 0.39794921875 0.75 0.0 0.05801526718694745 0.9074695706367493 -0.00034737586975097656 0.05255126953125 0.0016679763793945312 0.05999999865889549 0.7802734375 -0.03985595703125 0.09161376953125 0.01009368896484375 -0.002620697021484375 0.0107879638671875 0.4326171875 0.42333984375 0.0135345458984375 0.255615234375 0.0230560302734375 0.0037899017333984375 0.004329681396484375 0.73388671875 0.84716796875 0.241455078125 0.90087890625 0.541015625
5 A421A342-2706-4A6E-B993-38426E52421B 2018-12-24T20:06:03+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic 02e54839ec51f00bd8e4eaed08112c24b77cfedad2a2ea6563e421fcada75a44 1521065 45.20411333333333 -123.14530833333333 1 0 0 0 0 0 0 0 McMinnville OR United States A421A342-2706-4A6E-B993-38426E52421B 0.47509765625 0.75 0.0 0.058016162621610946 0.10000000149011612 -0.0010728836059570312 0.0234527587890625 0.001720428466796875 0.009999999776482582 -0.172119140625 -0.04046630859375 0.2279052734375 0.0035381317138671875 -0.01519012451171875 0.004852294921875 -0.03466796875 0.05120849609375 0.0616455078125 0.08056640625 0.0070037841796875 -0.0078887939453125 0.0027790069580078125 0.23388671875 0.19970703125 0.09521484375 0.51953125 0.004180908203125
233 8B27D87D-8FB6-4251-9E6A-68540AC7532B 2018-12-24T01:08:03+00:00 
[
    "Museums",
    "Public"
]
 
[
    "_UNKNOWN_",
    "_UNKNOWN_"
]
 heic 72dcc3993cdcaf43104031d23c42c5824186fbaa07b9bc5065422be1062b210d 2738037 45.646233333333335 -122.65947 1 0 0 0 0 0 0 0 Vancouver WA United States 8B27D87D-8FB6-4251-9E6A-68540AC7532B 0.47265625 0.75 0.0 0.05802243066425542 0.10000000149011612 -0.004573822021484375 0.025115966796875 0.0055999755859375 0.009999999776482582 -0.9287109375 -0.0258026123046875 0.014892578125 0.0028228759765625 -0.00453948974609375 -0.0038509368896484375 0.1556396484375 -0.06219482421875 0.01467132568359375 0.0863037109375 -0.021942138671875 -0.0030155181884765625 0.00547027587890625 0.09124755859375 0.0240478515625 0.2088623046875 0.483642578125 0.00794219970703125
316 1CCB0CD8-DDD9-40A5-AEBC-015C873A2A09 2018-09-04T15:40:35+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic 9ab8a8f8d0d8d62ecf5411bdb5ed26b1e5b7fa9df793f0ff21f7080e0163eb64 1813574 50.656758333333336 -4.251725 1 0 0 0 0 0 0 0 Lifton England United Kingdom 1CCB0CD8-DDD9-40A5-AEBC-015C873A2A09 0.390380859375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.07696533203125 -0.000335693359375 0.004608154296875 0.009999999776482582 -0.849609375 -0.08062744140625 -0.108642578125 0.049407958984375 -0.07196044921875 -0.044647216796875 -0.5185546875 -0.53076171875 0.0211639404296875 -0.06842041015625 -0.00606536865234375 -0.01552581787109375 0.001483917236328125 0.007122039794921875 -0.378173828125 -0.017852783203125 -0.19140625 -0.0211181640625
383 8A9FED20-BDE8-46E0-8583-C8FF1C7D3BFC 2018-09-04T14:39:55+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic bf353867bc1597a9f89dbc4de8af7d755095da20198147e47c69c35f6ebf0b36 1758797 50.656525 -4.251916666666666 1 0 0 0 0 0 0 0 Lifton England United Kingdom 8A9FED20-BDE8-46E0-8583-C8FF1C7D3BFC 0.403564453125 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.00555419921875 0.0181884765625 0.0021991729736328125 0.009999999776482582 -0.20703125 -0.05340576171875 -0.00537109375 0.05780029296875 -0.03240966796875 -0.006561279296875 -0.0440673828125 -0.14306640625 0.0265045166015625 0.084228515625 0.00756072998046875 -0.00572967529296875 0.00392913818359375 0.1265869140625 0.167724609375 0.06036376953125 0.489013671875 0.0262451171875
419 4730CC47-5D37-4A64-A6D2-D44CDF5F5B0C 2018-05-18T20:39:03+00:00 
[
    "Museums",
    "Public"
]
 
[
    "_UNKNOWN_"
]
 heic d4d2ad853a4bbb3b4ffd93c582b6567943b3edbc0daf7400754740b61b09a755 1884793 37.04161116666667 -122.07271666666666 1 0 0 0 0 0 0 0 Felton CA United States 4730CC47-5D37-4A64-A6D2-D44CDF5F5B0C 0.385009765625 0.75 0.0 0.05802466925091416 0.10000000149011612 -0.0021572113037109375 -0.0006103515625 0.0034160614013671875 0.009999999776482582 -0.064208984375 -0.09930419921875 0.287109375 0.004180908203125 -0.016845703125 -0.0426025390625 -0.50341796875 -0.06573486328125 0.1298828125 -0.06414794921875 -0.007534027099609375 -0.0122222900390625 0.0013456344604492188 0.01177978515625 0.0101470947265625 -0.53271484375 -0.367919921875 -0.1138916015625
414 FE1BAAE9-C33D-4933-88F0-9BCDA86F2D5B 2018-05-10T23:39:54+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic d0e381a36f050e4eaeb9530446058ff47fbbd42fe36d4c5bbfcea882000112e9 1255921 -32.893811666666664 -68.856545 1 0 0 0 0 0 0 0 Mendoza Mendoza Argentina FE1BAAE9-C33D-4933-88F0-9BCDA86F2D5B 0.3359375 0.75 0.0 0.05801526718694745 0.5042335987091064 -0.0003669261932373047 0.13916015625 0.005641937255859375 0.009999999776482582 0.247314453125 -0.006072998046875 0.31982421875 0.004150390625 -0.006313323974609375 0.007152557373046875 0.3681640625 0.2174072265625 0.05499267578125 0.243896484375 0.059234619140625 0.004730224609375 0.0103302001953125 0.26171875 0.056427001953125 0.67626953125 0.77685546875 0.06890869140625
351 47AC9BA3-C29C-46BA-855E-829C0EC59FF5 2017-12-03T22:40:16+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic a99406f355b55e1d8c5bf18f8d85761ef703d75b862e715f9e9751c5e0a8bacd 1734045 37.333511666666666 -121.92306333333333 1 0 0 0 0 0 0 0 San Jose CA United States 47AC9BA3-C29C-46BA-855E-829C0EC59FF5 0.477294921875 0.75 0.0 0.058022878381587165 0.10000000149011612 -0.0005526542663574219 0.027008056640625 0.0082855224609375 0.019999999552965164 -0.37451171875 -0.041778564453125 0.27587890625 0.004364013671875 -0.006565093994140625 -0.048553466796875 -0.1864013671875 -0.00262451171875 0.31640625 0.05841064453125 0.00191497802734375 -0.0159454345703125 0.0174407958984375 0.0215301513671875 0.001140594482421875 -0.11749267578125 0.0311279296875 -0.0047607421875
475 062B182C-CD24-4EC8-8E27-420EECB14688 2015-12-18T13:39:58+00:00 
[
    "Novelty Automation",
    "Museums",
    "Public"
]
 
[]
 jpeg f35f5580cec4289b90eb9ceebec27f017a5b5911a0b087d7e25efbf86a13b2d0 2073560 51.51998 -0.11689166666666666 1 0 0 0 0 0 0 0 London England United Kingdom 062B182C-CD24-4EC8-8E27-420EECB14688 0.33544921875 0.75 0.0 0.05801862506693556 0.50620436668396 -0.00033283233642578125 0.044891357421875 0.0087432861328125 0.009999999776482582 0.45703125 -0.047698974609375 0.134521484375 0.005344390869140625 -0.004100799560546875 0.001739501953125 0.175048828125 0.1627197265625 0.04742431640625 0.1656494140625 0.015380859375 0.02105712890625 0.0125274658203125 0.043701171875 0.010101318359375 -0.0157470703125 0.335693359375 0.1339111328125

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW photos_with_apple_metadata AS 
    select
        apple_photos.rowid,
        json_object(
            'img_src',
            'https://photos.simonwillison.net/i/' || uploads.sha256 || '.' || uploads.ext || '?w=600'
        ) as photo,
        apple_photos.uuid,
        apple_photos.date,
        apple_photos.albums,
        apple_photos.persons,
        uploads.ext,
        uploads.sha256,
        uploads.size,
        latitude,
        longitude,
        favorite,
        portrait,
        screenshot,
        slow_mo,
        time_lapse,
        hdr,
        selfie,
        panorama,
        place_city,
        place_state_province,
        place_country,
        apple_photos_scores.*
    from
        apple_photos
    join
        uploads on apple_photos.sha256 = uploads.sha256
    left join
        apple_photos_scores on apple_photos.uuid = apple_photos_scores.ZUUID
    order by
        apple_photos.date desc;
Powered by Datasette · Query took 572.49ms · About: dogsheep/dogsheep-photos