photos_with_apple_metadata (view)

11 rows where ZCURATIONSCORE = "0.75" and albums contains "Museums" sorted by ZPLEASANTLIGHTINGSCORE

✎ View and edit SQL

This data as json, CSV (advanced)

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

place_state_province ✖

albums (array) ✖

ZCURATIONSCORE ✖

  • 0.75 · 11 ✖
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
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
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
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
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
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
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
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
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

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 664.1ms · About: dogsheep/dogsheep-photos