This data as json, CSV (advanced)
Suggested facets: ext, ZBEHAVIORALSCORE, ZINTERACTIONSCORE, albums (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
74 | 3295CB6A-D459-45C2-8E45-9FBBDCF80266 | 2019-08-20T05:56:46+00:00 | [ "To Instagram", "Public" ] |
[] |
jpeg | 21f932155ee348af51628849af6626b7a6f5ffafd5eda45b6196ada242ae647b | 6094145 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3295CB6A-D459-45C2-8E45-9FBBDCF80266 | 0.751953125 | 0.75 | 0.0 | 0.06263145190158872 | 0.5050121545791626 | -0.0012111663818359375 | 0.043670654296875 | 0.00313568115234375 | 0.019999999552965164 | 0.640625 | -0.046539306640625 | 0.0594482421875 | 0.0136871337890625 | -0.0062408447265625 | 0.00662994384765625 | 0.28125 | 0.18310546875 | 0.03436279296875 | 0.207763671875 | 0.017669677734375 | 0.0028400421142578125 | 0.006145477294921875 | 0.2890625 | 0.537109375 | 0.179443359375 | 0.728515625 | 0.51416015625 | ||||||
369 | FCBB3E33-8FF9-4811-B242-729555B01F28 | 2019-08-12T08:14:34+00:00 | [ "To Instagram", "Public" ] |
[] |
jpeg | b59011c12dd96d5570d71fead8b84f1efa589beca989bdbad3f7ad36f6522c3a | 5240506 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | FCBB3E33-8FF9-4811-B242-729555B01F28 | 0.71533203125 | 0.75 | 0.0 | 0.06263535213834456 | 0.7032116651535034 | -0.000820159912109375 | 0.07196044921875 | 0.00243377685546875 | 0.009999999776482582 | 0.44921875 | -0.03424072265625 | 0.103515625 | 0.01433563232421875 | -0.003147125244140625 | 0.0105743408203125 | 0.374267578125 | 0.366455078125 | 0.026702880859375 | 0.30810546875 | 0.033294677734375 | 0.0036144256591796875 | 0.005100250244140625 | 0.6748046875 | 0.857421875 | 0.2802734375 | 0.82861328125 | 0.325439453125 | ||||||
301 | 6560AE2B-6571-400C-AE36-5249A5F7940D | 2019-08-02T09:58:38+00:00 | [ "To Instagram", "Public" ] |
[] |
heic | 9038a30de690deff661d96a60e74dc4e02c13bdcc932240c32e57c0d92c55a54 | 1141832 | -12.524263333333334 | 49.175421666666665 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Antsiranana | Madagascar | 6560AE2B-6571-400C-AE36-5249A5F7940D | 0.587890625 | 0.75 | 0.0 | 0.061096562229040016 | 0.5037956237792969 | -0.0004107952117919922 | 0.069580078125 | 0.006771087646484375 | 0.009999999776482582 | 0.086181640625 | -0.03436279296875 | 0.0643310546875 | 0.040374755859375 | -0.006145477294921875 | 0.0169525146484375 | 0.32177734375 | 0.341796875 | 0.10992431640625 | 0.414306640625 | 0.04290771484375 | 0.00167083740234375 | 0.026702880859375 | 0.253662109375 | 0.1519775390625 | 0.1221923828125 | 0.65380859375 | 0.057403564453125 | ||
180 | 0F308AB5-4F16-4C67-A84E-310F85B63E4E | 2019-08-02T09:31:50+00:00 | [ "To Instagram", "Public" ] |
[] |
heic | 59acef10149934e3af1e1078d07b77cb367d6227ca00cf93d93d7576b5bf2525 | 1082591 | -12.526836666666666 | 49.17201166666667 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Antsiranana | Madagascar | 0F308AB5-4F16-4C67-A84E-310F85B63E4E | 0.5078125 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.004100799560546875 | 0.06683349609375 | 0.01395416259765625 | 0.009999999776482582 | -0.1656494140625 | -0.035400390625 | 0.06732177734375 | 0.048309326171875 | -0.0202178955078125 | -0.016998291015625 | 0.005615234375 | 0.0098876953125 | 0.06610107421875 | 0.1409912109375 | 0.04559326171875 | 0.00055694580078125 | 0.00555419921875 | 0.030914306640625 | 0.030181884765625 | 0.06134033203125 | 0.038818359375 | 0.02703857421875 | ||
300 | 563D4862-8FC2-4BD9-BAD0-E9B2DC5DB473 | 2019-08-02T07:32:43+00:00 | [ "To Instagram", "Public" ] |
[] |
jpeg | 8fa3f67420480063a09ea4134c1dae4e8d67262f38433e3a41a2f6eb6aa47bf8 | 5402536 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 563D4862-8FC2-4BD9-BAD0-E9B2DC5DB473 | 0.68701171875 | 0.75 | 0.0 | 0.061090618599462146 | 0.10000000149011612 | -0.0045928955078125 | 0.059783935546875 | 0.024139404296875 | 0.009999999776482582 | -0.1326904296875 | -0.041778564453125 | 0.0091552734375 | 0.01763916015625 | -0.00948333740234375 | -0.0116119384765625 | 0.140625 | 0.001708984375 | 0.047698974609375 | 0.205810546875 | 0.0234832763671875 | 0.00275421142578125 | 0.007122039794921875 | 0.03289794921875 | 0.05401611328125 | 0.03717041015625 | 0.03765869140625 | 0.039886474609375 | ||||||
313 | 4353C1BC-259D-4814-B113-8E5DBA65470D | 2019-08-02T07:31:01+00:00 | [ "To Instagram", "Public" ] |
[] |
jpeg | 97c5b33f1ede95e3610b213858a47deb2d9b6e84edbc484348eb318234b1725e | 6764077 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4353C1BC-259D-4814-B113-8E5DBA65470D | 0.65869140625 | 0.75 | 0.0 | 0.061090990332246735 | 0.5033819675445557 | -0.0008330345153808594 | 0.05767822265625 | 0.001918792724609375 | 0.009999999776482582 | 0.077880859375 | -0.054107666015625 | 0.08892822265625 | 0.02947998046875 | -0.005535125732421875 | 0.0120697021484375 | 0.1839599609375 | 0.213623046875 | 0.035888671875 | 0.275146484375 | 0.02435302734375 | -0.001705169677734375 | 0.006824493408203125 | 0.44580078125 | 0.517578125 | 0.144287109375 | 0.7705078125 | 0.065185546875 | ||||||
243 | 18939B2A-0A75-461C-B1D0-7ABD87282C2D | 2019-08-02T07:06:42+00:00 | [ "To Instagram", "Public" ] |
[] |
jpeg | 77bff818519fbcb9928b5259e5865f7f16a90fca872e7372a6bb06be7ac89fd9 | 4601240 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18939B2A-0A75-461C-B1D0-7ABD87282C2D | 0.73486328125 | 0.75 | 0.0 | 0.06263108016880414 | 0.10000000149011612 | -0.00131988525390625 | 0.0268707275390625 | 0.0013151168823242188 | 0.009999999776482582 | -0.0050048828125 | -0.04803466796875 | 0.258544921875 | 0.005138397216796875 | -0.014617919921875 | 0.016845703125 | -0.0245361328125 | 0.05230712890625 | 0.06939697265625 | 0.068603515625 | 0.00927734375 | -0.009765625 | 0.002590179443359375 | 0.316650390625 | 0.431640625 | 0.0804443359375 | 0.6259765625 | 0.010986328125 | ||||||
266 | EB0F670F-3DE5-4917-840A-1C84BE9C570D | 2019-07-30T12:22:03+00:00 | [ "To Instagram", "Public" ] |
[] |
jpeg | 80c39df47ef66d49231ae15a6a0dcd036881b7310ebc344e9b8677da479ee070 | 5096405 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | EB0F670F-3DE5-4917-840A-1C84BE9C570D | 0.75927734375 | 0.75 | 0.0 | 0.06262309405639882 | 0.10000000149011612 | -0.0026721954345703125 | 0.040374755859375 | 0.0038242340087890625 | 0.009999999776482582 | -0.53515625 | -0.0248870849609375 | 0.30224609375 | 0.00426483154296875 | -0.0120086669921875 | -0.01177978515625 | -0.03497314453125 | 0.03985595703125 | 0.091064453125 | 0.054443359375 | 0.0120697021484375 | -0.018310546875 | 0.0028781890869140625 | 0.12890625 | 0.1641845703125 | 0.1927490234375 | 0.2381591796875 | -0.004730224609375 |
JSON shape: default, array, newline-delimited
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;