photos_with_apple_metadata (view)

26 rows where "date" is on date 2019-09-15

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ext, latitude, longitude, ZOVERALLAESTHETICSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZFAILURESCORE, ZHARMONIOUSCOLORSCORE, ZIMMERSIVENESSSCORE, ZINTERACTIONSCORE, ZNOISESCORE, date (date), 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
277 0C7F8BD3-7996-4FBD-A886-2D885AC7F618 2019-09-15T15:36:30+00:00 
[
    "Public"
]
 
[]
 heic 847b6ce3e30394f5485d356528eea16a644e0a2b54d1a7727c03011f8c54b554 1716536 30.24152 -89.67729166666666 1 0 0 0 0 0 0 0 Slidell LA United States 0C7F8BD3-7996-4FBD-A886-2D885AC7F618 0.5712890625 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0014781951904296875 0.016510009765625 0.008575439453125 0.03999999910593033 -0.235107421875 -0.05291748046875 0.2169189453125 0.00669097900390625 -0.01214599609375 -0.043487548828125 -0.1904296875 -0.03326416015625 0.430908203125 0.0216064453125 0.00054931640625 -0.0718994140625 0.0169830322265625 0.0224609375 0.0220794677734375 -0.1822509765625 -0.0218505859375 -0.0104827880859375
309 A34D9C15-11C6-488C-9E3C-910401A65132 2019-09-15T15:16:37+00:00 
[
    "Public"
]
 
[]
 heic 95e2658b31ac920ea73e962755503af66a5a04ceade3f3c91313f8808380f753 3537285 30.243796666666668 -89.68113 1 0 0 0 0 0 0 0 Slidell LA United States A34D9C15-11C6-488C-9E3C-910401A65132 0.47021484375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0036792755126953125 -0.00623321533203125 0.004573822021484375 0.009999999776482582 -0.17138671875 -0.05450439453125 0.2073974609375 0.0028896331787109375 -0.039794921875 -0.1051025390625 -0.3232421875 -0.1912841796875 0.39306640625 -0.091552734375 -0.002368927001953125 -0.1004638671875 0.0066680908203125 0.0038089752197265625 -0.022735595703125 -0.396484375 -0.28955078125 -0.07501220703125
442 1EC4C590-FBD5-4D44-9FF8-0FAC3F1600D5 2019-09-15T15:15:38+00:00 
[
    "Public"
]
 
[]
 heic e0418d31b3a2b842b3514b954ac271355a51ba93194dc39cfadb7ee9ecb1acac 3794075 30.243286666666666 -89.68092166666666 1 0 0 0 0 0 0 0 Slidell LA United States 1EC4C590-FBD5-4D44-9FF8-0FAC3F1600D5 0.6689453125 0.75 0.0 0.061091547248927694 0.10000000149011612 -0.0002913475036621094 0.0178985595703125 0.0090179443359375 0.009999999776482582 0.0235595703125 -0.039947509765625 0.11279296875 0.0070953369140625 -0.006641387939453125 -0.013092041015625 0.019287109375 0.0228271484375 0.275390625 0.11358642578125 0.0069427490234375 -0.0308074951171875 0.04949951171875 0.0284423828125 0.0028171539306640625 -0.1083984375 0.3466796875 0.00666046142578125
423 9B0C0741-55E0-4BB2-BC6B-BAB6804EE1A0 2019-09-15T14:38:47+00:00 
[
    "Public"
]
 
[]
 heic d6f260ebe038a495c75f0bbc1c00606f894676a9ce2098c3d5733530dc0e8ec2 2699124 30.234196666666666 -89.66815833333334 1 0 0 0 0 0 0 0 Slidell LA United States 9B0C0741-55E0-4BB2-BC6B-BAB6804EE1A0 0.6171875 0.75 0.0 0.06110566308480183 0.10000000149011612 -0.00473785400390625 -0.0020599365234375 0.002208709716796875 0.009999999776482582 -0.5263671875 -0.0616455078125 0.07708740234375 0.00482940673828125 -0.040679931640625 -0.0740966796875 -0.298095703125 -0.294677734375 0.0792236328125 -0.0595703125 -0.004840850830078125 -0.1695556640625 0.00464630126953125 0.00841522216796875 -0.0238189697265625 -0.1800537109375 0.0487060546875 -0.02069091796875
225 5896CD82-A625-4414-9D39-25EFE6E848C1 2019-09-15T14:37:30+00:00 
[
    "Public"
]
 
[]
 heic 7104ebd9287ca4e5d2556496eafd7d34ada9901997cbff1dbdd7c33281d65566 2529275 30.234196666666666 -89.66815833333334 1 0 0 0 0 0 0 0 Slidell LA United States 5896CD82-A625-4414-9D39-25EFE6E848C1 0.6513671875 0.75 0.0 0.8244531118232785 0.10000000149011612 -0.0008897781372070312 0.02996826171875 0.030792236328125 0.009999999776482582 0.0899658203125 -0.07708740234375 0.011474609375 0.00933837890625 -0.00847625732421875 -0.0897216796875 -0.1318359375 -0.0404052734375 0.316162109375 0.26220703125 0.013916015625 -0.0034942626953125 0.03228759765625 0.008880615234375 -0.00472259521484375 -0.01678466796875 -0.072998046875 0.016571044921875
131 D755ECF0-4954-461A-8523-2BCA917DA37C 2019-09-15T14:11:18+00:00 
[
    "Public"
]
 
[]
 jpeg 3bff710e021160610debf1cef0002dd77afc78694c1ad1373c2bc5a0c244658e 4403069     1 0 0 0 0 0 0 0       D755ECF0-4954-461A-8523-2BCA917DA37C 0.75732421875 0.75 0.0 0.0626162217773554 0.1004379540681839 -0.00033545494079589844 0.03814697265625 0.0197906494140625 0.019999999552965164 0.0579833984375 -0.0255126953125 0.1129150390625 0.0137939453125 -0.00600433349609375 0.0106964111328125 0.27734375 0.2056884765625 0.258544921875 0.2041015625 0.016815185546875 -0.001556396484375 0.0751953125 0.08770751953125 0.0274658203125 -0.0262451171875 0.48876953125 0.01727294921875
397 E8E3760C-6AA7-4E10-830A-1F54F6AA1DB1 2019-09-15T14:10:38+00:00 
[
    "Public"
]
 
[]
 jpeg c5ff4567d2b8823acc41ef686539055ca82fb17e9889de24621a623538ea0a7a 4943371     1 0 0 0 0 0 0 0       E8E3760C-6AA7-4E10-830A-1F54F6AA1DB1 0.7294921875 0.75 0.0 0.0626162217773554 0.10000000149011612 -0.001129150390625 0.04541015625 0.004718780517578125 0.009999999776482582 -0.1695556640625 -0.029541015625 0.1900634765625 0.0103302001953125 -0.0083160400390625 -0.002777099609375 0.113037109375 0.0458984375 0.0703125 0.11566162109375 0.01910400390625 -0.0452880859375 0.013275146484375 0.0880126953125 0.033050537109375 0.12371826171875 0.52001953125 0.01488494873046875
2 BDFD0BA5-1272-4F54-80CF-940CEBF0ACE8 2019-09-15T13:41:17+00:00 
[
    "Public"
]
 
[]
 jpeg 01aeec21c49bfddd0980785d24f6c5a269c2fae92bc49aa1dcb592d8442cf6fd 7719757     1 0 0 0 0 0 0 0       BDFD0BA5-1272-4F54-80CF-940CEBF0ACE8 0.478271484375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.003185272216796875 0.006916046142578125 0.0082550048828125 0.009999999776482582 -0.205078125 -0.091552734375 0.0966796875 0.00734710693359375 -0.025177001953125 -0.085205078125 -0.5166015625 -0.11151123046875 0.08416748046875 -0.055389404296875 0.0017242431640625 -0.0091552734375 0.0018968582153320312 0.004718780517578125 -0.01261138916015625 -0.13525390625 -0.422119140625 -0.012481689453125
466 B1CC5925-B5D2-459D-A9E9-C478226311D8 2019-09-15T13:36:33+00:00 
[
    "Public"
]
 
[]
 jpeg eb0cf641d40ba636af3dc3d20e719211c23d2479ffa5ae69814f570e4df46603 4886735     1 0 0 0 0 0 0 0       B1CC5925-B5D2-459D-A9E9-C478226311D8 0.79052734375 0.75 0.0 0.06262733508612363 0.10000000149011612 -0.0009660720825195312 0.016510009765625 0.004299163818359375 0.009999999776482582 -0.2744140625 -0.0231475830078125 0.381591796875 0.001483917236328125 -0.0121917724609375 -0.03131103515625 -0.085693359375 0.003692626953125 0.345947265625 -0.013671875 0.0076446533203125 -0.02392578125 0.006877899169921875 0.043701171875 0.0267333984375 -0.0008544921875 0.11480712890625 -0.01465606689453125
472 466CB5A7-6675-48D2-B7BF-9A2C0F83250E 2019-09-15T13:36:15+00:00 
[
    "Public"
]
 
[]
 jpeg f096c284469eab7364bc93f0e6b1a172fdf8f6221a7e27ef76b5bedc6720302a 6232116     1 0 0 0 0 0 0 0       466CB5A7-6675-48D2-B7BF-9A2C0F83250E 0.794921875 0.75 0.0 0.06417663634278392 0.5046228766441345 -0.0013885498046875 0.034088134765625 0.0020198822021484375 0.019999999552965164 0.54296875 -0.03759765625 0.03155517578125 0.062225341796875 -0.0127716064453125 0.008453369140625 0.302978515625 0.265625 0.018585205078125 0.195556640625 0.0266571044921875 0.003116607666015625 0.005428314208984375 0.5380859375 0.73583984375 0.2452392578125 0.85302734375 0.337890625
268 421867A7-CC19-4B0A-944C-26AE521DE430 2019-09-15T13:17:56+00:00 
[
    "Public"
]
 
[]
 jpeg 81afbe147b314b8d2080199a263d9d31e68d9bf8379123faf2c4a849b6d3b13e 6002543     1 0 0 0 0 0 0 0       421867A7-CC19-4B0A-944C-26AE521DE430 0.6416015625 0.75 0.0 0.061092475898393235 0.5047202110290527 -0.0017004013061523438 0.0198974609375 0.0017614364624023438 0.019999999552965164 0.5556640625 -0.060638427734375 -0.023101806640625 0.07574462890625 -0.0147857666015625 0.0053863525390625 0.2314453125 0.096923828125 0.009674072265625 0.1575927734375 0.010589599609375 0.00057220458984375 0.0058441162109375 0.36328125 0.4619140625 0.09844970703125 0.86572265625 0.349609375
448 74949E42-5A82-4CEE-93C6-3FF590F777CB 2019-09-15T13:14:14+00:00 
[
    "Public"
]
 
[]
 jpeg e32ee75d05e5052e8c6cb05455d521b92ba3d12e597c3063e6a7b59ec8c37603 7113473     1 0 0 0 0 0 0 0       74949E42-5A82-4CEE-93C6-3FF590F777CB 0.7529296875 0.75 0.0 0.06263980974677864 0.5051338076591492 -0.0006117820739746094 0.03955078125 0.006145477294921875 0.009999999776482582 0.39501953125 -0.06280517578125 0.167724609375 0.00557708740234375 -0.006488800048828125 0.007598876953125 0.0274658203125 0.143310546875 0.167236328125 0.165771484375 0.00952911376953125 -0.000843048095703125 0.0102081298828125 0.07489013671875 0.09228515625 -0.05126953125 0.416259765625 0.2978515625
126 A967087A-B06E-4B0E-A1E6-015C61FD460E 2019-09-15T13:14:09+00:00 
[
    "Public"
]
 
[]
 jpeg 3bb9961495d7ee420b248a932ddd3335ea67e7eed4bfae3b586f75e7883f80fc 5799222     1 0 0 0 0 0 0 0       A967087A-B06E-4B0E-A1E6-015C61FD460E 0.79052734375 0.75 0.0 0.0626213627917166 0.5045498609542847 -0.001461029052734375 0.03533935546875 0.0022869110107421875 0.07999999821186066 0.5009765625 -0.044769287109375 0.01611328125 0.06634521484375 -0.0104522705078125 0.007366180419921875 0.31103515625 0.2568359375 0.0154266357421875 0.212646484375 0.02606201171875 0.002635955810546875 0.00577545166015625 0.495849609375 0.69287109375 0.215087890625 0.83984375 0.302978515625
488 7DDBAB14-E762-46B3-942A-BAD5AB6668A3 2019-09-15T13:14:03+00:00 
[
    "Public"
]
 
[]
 jpeg fb3e9dc60565ab6a9e492642843dba702d5a63c945420c0ec573610bdde8e9b8 6274468     1 0 0 0 0 0 0 0       7DDBAB14-E762-46B3-942A-BAD5AB6668A3 0.77392578125 0.75 0.0 0.062639624107885 0.10000000149011612 -0.001674652099609375 0.0215606689453125 0.0020503997802734375 0.019999999552965164 0.34423828125 -0.043609619140625 0.0489501953125 0.014556884765625 -0.0276947021484375 -0.00164794921875 0.08935546875 -0.0223388671875 0.029205322265625 0.149169921875 0.006847381591796875 -0.001789093017578125 0.00469970703125 0.10687255859375 0.05255126953125 0.12890625 0.65283203125 0.26171875
160 536F85D8-60B3-4728-A836-04663A86DC6B 2019-09-15T13:08:42+00:00 
[
    "Public"
]
 
[]
 jpeg 4da99e1ec6bac9b6ab7f26b8aeda078259305b460e2fa33810b485c1760725ad 5423408     1 0 0 0 0 0 0 0       536F85D8-60B3-4728-A836-04663A86DC6B 0.80859375 0.75 0.0 0.06261790617731691 0.5048418641090393 -0.0010204315185546875 0.0242462158203125 0.001941680908203125 0.07999999821186066 0.55126953125 -0.057708740234375 -0.000274658203125 0.0999755859375 -0.01384735107421875 0.0078887939453125 0.22412109375 0.2369384765625 0.0125732421875 0.159912109375 0.0168914794921875 0.001590728759765625 0.005687713623046875 0.363525390625 0.435546875 0.07342529296875 0.83544921875 0.35693359375
399 4FB52292-60F3-429B-971F-4843A2BD51B4 2019-09-15T12:53:03+00:00 
[
    "Public"
]
 
[]
 jpeg c708f463941e998c2a9d12854bed87d6e85f2235270312999b216c006a6fdeb1 7760105     1 0 0 0 0 0 0 0       4FB52292-60F3-429B-971F-4843A2BD51B4 0.447021484375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0018177032470703125 0.027374267578125 0.02685546875 0.019999999552965164 -0.316650390625 -0.053497314453125 0.1463623046875 0.00428009033203125 -0.00894927978515625 -0.0819091796875 -0.28271484375 -0.04461669921875 0.1256103515625 0.0401611328125 0.00994873046875 -0.011474609375 0.00803375244140625 0.007373809814453125 -0.008026123046875 -0.03558349609375 -0.1982421875 -0.00734710693359375
246 1CE89584-DE92-4290-91D3-EDDFD28FEC5D 2019-09-15T12:51:42+00:00 
[
    "Public"
]
 
[]
 jpeg 78e814db89cff24f2189151f2b080c7aba9dcaa1b05e0d0444ca8b8111b46966 5301232     1 0 0 0 0 0 0 0       1CE89584-DE92-4290-91D3-EDDFD28FEC5D 0.703125 0.75 0.0 0.06262847985930116 0.5045985579490662 -0.0006413459777832031 0.021331787109375 0.0020351409912109375 0.05999999865889549 0.6328125 -0.061309814453125 0.012725830078125 0.037109375 -0.008544921875 0.0101776123046875 0.285888671875 0.2958984375 0.01242828369140625 0.1907958984375 0.0125732421875 0.001712799072265625 0.006122589111328125 0.441650390625 0.5263671875 0.0867919921875 0.86328125 0.423095703125
469 99A0B8E1-22E2-4640-AC9D-0BBDCB9B02EC 2019-09-15T12:44:27+00:00 
[
    "Public"
]
 
[]
 jpeg ec4dd816bb647c7991e8a77e285528de6853973fbbcd88b3923939938e33b9fb 5720642     1 0 0 0 0 0 0 0       99A0B8E1-22E2-4640-AC9D-0BBDCB9B02EC 0.734375 0.75 0.0 0.06261696478792729 0.7050121426582336 -0.0007700920104980469 0.06378173828125 0.0025615692138671875 0.009999999776482582 0.69482421875 -0.04443359375 0.036102294921875 0.05499267578125 -0.00555419921875 0.00826263427734375 0.400146484375 0.35693359375 0.01678466796875 0.270263671875 0.039459228515625 0.005062103271484375 0.006717681884765625 0.4736328125 0.61376953125 0.20947265625 0.83740234375 0.48095703125
184 36F88EBB-0DDF-423B-AEFB-A1A5FFE8202E 2019-09-15T12:44:16+00:00 
[
    "Public"
]
 
[]
 jpeg 5b2f88615086a37d0dcf66c5e60375212ed0f3927e8e720159524729f873bd41 5313920     1 0 0 0 0 0 0 0       36F88EBB-0DDF-423B-AEFB-A1A5FFE8202E 0.48486328125 0.75 0.0 0.05801526718694745 0.5043065547943115 -0.0008559226989746094 0.022125244140625 0.0018825531005859375 0.03999999910593033 0.58203125 -0.05633544921875 0.005279541015625 0.06903076171875 -0.01267242431640625 0.0079498291015625 0.2421875 0.242919921875 0.011505126953125 0.1534423828125 0.0126800537109375 0.001617431640625 0.005535125732421875 0.373291015625 0.41796875 0.06787109375 0.84716796875 0.3896484375
171 578C0EBB-DB86-40B7-9F4C-10156D8962CD 2019-09-15T12:43:46+00:00 
[
    "Public"
]
 
[]
 jpeg 57769019fe5b10d018767fca7528dffbfe2e3a1ba3d9acfdea5a284dfdf3b31e 5089150     1 0 0 0 0 0 0 0       578C0EBB-DB86-40B7-9F4C-10156D8962CD 0.67431640625 0.75 0.0 0.061102877136405186 0.5051581263542175 -0.0007643699645996094 0.03277587890625 0.001941680908203125 0.10000000149011612 0.61767578125 -0.061431884765625 0.02618408203125 0.039703369140625 -0.008544921875 0.009307861328125 0.25048828125 0.242431640625 0.01287078857421875 0.1942138671875 0.0166015625 0.002025604248046875 0.004848480224609375 0.366943359375 0.433837890625 0.091552734375 0.8076171875 0.38623046875
424 52F687D4-86F5-437D-9EC5-5FB7F7EAD2B5 2019-09-15T12:43:10+00:00 
[
    "Public"
]
 
[]
 jpeg d73471311a0372d75bcb1aed76b3fdfb459a27fb802c44abd9f1ba24f1390ff3 5278224     1 0 0 0 0 0 0 0       52F687D4-86F5-437D-9EC5-5FB7F7EAD2B5 0.428466796875 0.75 0.0 0.058020592930207726 0.504817545413971 -0.000690460205078125 0.040313720703125 0.002216339111328125 0.10000000149011612 0.53076171875 -0.03643798828125 0.0511474609375 0.0287628173828125 -0.00885009765625 0.00891876220703125 0.3388671875 0.28759765625 0.01422882080078125 0.2119140625 0.0172882080078125 0.0030670166015625 0.0055999755859375 0.43798828125 0.417724609375 0.203857421875 0.84521484375 0.369140625
452 27A4F78F-FC94-4E45-9512-0E89A13E33E5 2019-09-15T12:42:33+00:00 
[
    "Public"
]
 
[]
 jpeg e467e2655deced8d78b20667ebdf52cb3a325c2723ce0d8fed423f9fe8401ce7 4946963     1 0 0 0 0 0 0 0       27A4F78F-FC94-4E45-9512-0E89A13E33E5 0.6513671875 0.75 0.0 0.061090990332246735 0.5056204199790955 -0.00266265869140625 0.042999267578125 0.0033512115478515625 0.019999999552965164 0.52978515625 -0.063232421875 -0.0672607421875 0.2841796875 -0.025421142578125 0.0031890869140625 0.1854248046875 0.0341796875 0.0261993408203125 0.2314453125 0.040435791015625 0.00331878662109375 0.0094146728515625 0.143798828125 0.1871337890625 0.10595703125 0.6787109375 0.377197265625
483 AF2D570F-C629-4894-BFC2-FB019F1DAF80 2019-09-15T12:42:31+00:00 
[
    "Public"
]
 
[]
 jpeg f5b01d7ffd018e078bb6e197a4528ba5f030f7504124b9506fd91bbf3f6caa2c 5159422     1 0 0 0 0 0 0 0       AF2D570F-C629-4894-BFC2-FB019F1DAF80 0.65283203125 0.75 0.0 0.061102877136405186 0.7046471834182739 -0.0009326934814453125 0.051116943359375 0.0029239654541015625 0.009999999776482582 0.62353515625 -0.03436279296875 0.024139404296875 0.0709228515625 -0.0136871337890625 0.0076904296875 0.364013671875 0.289794921875 0.014617919921875 0.22509765625 0.0343017578125 0.00511932373046875 0.006389617919921875 0.319091796875 0.295166015625 0.265625 0.8193359375 0.495361328125
409 0E4C238E-A542-4C53-B676-B76D06C19901 2019-09-15T12:41:34+00:00 
[
    "Public"
]
 
[]
 jpeg cc2a28a48388addca3f543818e440b4d21939a2475cc2d58cb2aa27bc3af747f 5113277     1 0 0 0 0 0 0 0       0E4C238E-A542-4C53-B676-B76D06C19901 0.7958984375 0.75 0.0 0.06262434893892012 0.10000000149011612 -0.014007568359375 0.01042938232421875 0.003482818603515625 0.009999999776482582 0.185791015625 -0.094482421875 -0.1400146484375 0.1470947265625 -0.048583984375 -0.00669097900390625 -0.086669921875 -0.36962890625 0.01029205322265625 0.0726318359375 0.00626373291015625 -0.002170562744140625 0.00426483154296875 0.048492431640625 -0.132568359375 0.046142578125 0.54052734375 0.27783203125
159 BF9CEE04-8E45-4586-BC61-7E5921483763 2019-09-15T12:32:01+00:00 
[
    "Public"
]
 
[]
 jpeg 4d716099e85d3ba064b1cfbc236fc58381dc15b17ce4368141d10a39747b7998 4386363     1 0 0 0 0 0 0 0       BF9CEE04-8E45-4586-BC61-7E5921483763 0.712890625 0.75 0.0 0.06263033715823224 0.5045985579490662 -0.0006413459777832031 0.0499267578125 0.0026721954345703125 0.03999999910593033 0.54931640625 -0.041473388671875 0.035003662109375 0.0394287109375 -0.0082550048828125 0.00948333740234375 0.360107421875 0.301025390625 0.0127716064453125 0.260986328125 0.0268707275390625 0.00336456298828125 0.00653839111328125 0.37060546875 0.29248046875 0.223876953125 0.8359375 0.3427734375
258 F505A7F3-E583-46DE-8010-D8E6FE116376 2019-09-15T12:22:12+00:00 
[
    "Public"
]
 
[]
 jpeg 7de2e4e9f7166b348eeedac71aca8a8f54ef90c39cc1af6bd29b97356003a5c9 6065443     1 0 0 0 0 0 0 0       F505A7F3-E583-46DE-8010-D8E6FE116376 0.67724609375 0.75 0.0 0.061086160991028066 0.7049391865730286 -0.0007762908935546875 0.03778076171875 0.002208709716796875 0.009999999776482582 0.611328125 -0.03985595703125 0.0484619140625 0.0284881591796875 -0.006744384765625 0.00769805908203125 0.3466796875 0.34228515625 0.0125274658203125 0.1842041015625 0.021484375 0.003406524658203125 0.004398345947265625 0.54833984375 0.70458984375 0.219482421875 0.8525390625 0.417724609375

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