photos_with_apple_metadata (view)

26 rows where ZHIGHLIGHTVISIBILITYSCORE = "0.05801526718694745" and ext = "jpeg"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: albums, ZOVERALLAESTHETICSCORE, ZBEHAVIORALSCORE, ZFAILURESCORE, ZINTERACTIONSCORE, ZINTRUSIVEOBJECTPRESENCESCORE, ZPLEASANTLIGHTINGSCORE, 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
199 AC1D606E-185E-4B60-8213-782BE58B9DCE 2020-04-23T23:29:15+00:00 
[
    "Photography homework composition April 2020",
    "Public"
]
 
[]
 jpeg 6416af8c3fbce9295cc68411b2710c23ed8736a4ff4e23dd59627b960839241d 8772563     1 0 0 0 0 0 0 0       AC1D606E-185E-4B60-8213-782BE58B9DCE 0.4287109375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0013885498046875 0.024078369140625 0.0015668869018554688 0.009999999776482582 -0.280517578125 -0.0966796875 0.0313720703125 0.01837158203125 -0.006389617919921875 0.0133056640625 -0.011474609375 0.121826171875 0.034027099609375 0.306640625 0.01020050048828125 -0.005748748779296875 0.0057525634765625 0.456298828125 0.650390625 0.0997314453125 0.7548828125 0.040557861328125
13 8FB56C6C-6557-43E8-AC87-EF6E54F7F346 2020-04-23T23:28:23+00:00 
[
    "Photography homework composition April 2020",
    "Public"
]
 
[]
 jpeg 0762b5e844628b9e0b2a663a651df274d556c4f22705447e13546406cd779215 8341604     1 0 0 0 0 0 0 0       8FB56C6C-6557-43E8-AC87-EF6E54F7F346 0.378662109375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0014324188232421875 0.005527496337890625 0.0009217262268066406 0.009999999776482582 -0.455322265625 -0.1181640625 0.0677490234375 0.0192413330078125 -0.00981903076171875 -0.0017242431640625 -0.345703125 -0.0826416015625 0.0384521484375 0.024566650390625 -0.005931854248046875 -0.02398681640625 0.004024505615234375 0.2054443359375 0.29541015625 -0.298828125 0.59765625 -0.00146484375
467 DD2793EA-51C4-4196-AB34-12A665ACFF43 2020-04-23T23:25:49+00:00 
[
    "Photography homework composition April 2020",
    "Public"
]
 
[]
 jpeg eb9a25b29f51de5866383837f752a823eb39fcd7c6948af08970efbec9a117ee 9031772     1 0 0 0 0 0 0 0       DD2793EA-51C4-4196-AB34-12A665ACFF43 0.3916015625 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0023975372314453125 0.040679931640625 0.004055023193359375 0.009999999776482582 0.01025390625 -0.07598876953125 0.065185546875 0.011688232421875 -0.004924774169921875 0.00323486328125 0.0611572265625 0.137451171875 0.0294189453125 0.222900390625 0.011871337890625 -0.0007877349853515625 0.00392913818359375 0.2490234375 0.5400390625 0.0853271484375 0.525390625 0.1787109375
436 920D2FF3-BB4B-458A-B4B7-42D961777959 2020-04-23T23:23:27+00:00 
[
    "Photography homework composition April 2020",
    "Public"
]
 
[]
 jpeg dcdeb1800b9dff39a7b9b898cf72194e497608be08a212ea5eb0c707c2111dc8 7961248     1 0 0 0 0 0 0 0       920D2FF3-BB4B-458A-B4B7-42D961777959 0.5087890625 0.75 0.0 0.05801526718694745 0.5029926896095276 -0.0018033981323242188 0.038604736328125 0.0033512115478515625 0.009999999776482582 0.19921875 -0.0640869140625 0.0626220703125 0.01214599609375 -0.005218505859375 0.00536346435546875 0.1387939453125 0.170166015625 0.028594970703125 0.214599609375 0.01074981689453125 0.00038909912109375 0.004085540771484375 0.28076171875 0.568359375 0.0885009765625 0.5859375 0.28515625
375 91CFD354-BAD6-4367-9146-B5E214F7AED7 2020-04-23T23:21:22+00:00 
[
    "Photography homework composition April 2020",
    "Public"
]
 
[]
 jpeg b8a2541f7d0a3a7ba42e82810ff7409a0c4bb2e62d1ed0350f35ce2d47f6eaba 8662294     1 0 0 0 0 0 0 0       91CFD354-BAD6-4367-9146-B5E214F7AED7 0.2109375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.001674652099609375 0.0701904296875 0.00586700439453125 0.009999999776482582 -0.2425537109375 -0.05291748046875 0.0955810546875 0.009674072265625 -0.0018825531005859375 0.002086639404296875 0.17578125 0.209716796875 0.07366943359375 0.24951171875 0.01739501953125 0.0 0.006717681884765625 0.33154296875 0.740234375 0.060089111328125 0.349853515625 0.033599853515625
357 8E150DC5-5E6A-4286-9110-44501EC99304 2020-04-23T23:20:00+00:00 
[
    "Photography homework composition April 2020",
    "Public"
]
 
[]
 jpeg ada4f24e3ed43ef25da0ae2be782edc1bd9330d15661a67614cbafccb3277d63 7711907     1 0 0 0 0 0 0 0       8E150DC5-5E6A-4286-9110-44501EC99304 0.50390625 0.75 0.0 0.05801526718694745 0.7075425386428833 -0.0005192756652832031 0.07769775390625 0.006824493408203125 0.009999999776482582 0.3955078125 -0.041839599609375 0.260009765625 0.0034694671630859375 -0.004791259765625 0.0063018798828125 0.1600341796875 0.209716796875 0.025177001953125 0.13916015625 0.0210418701171875 0.00106048583984375 0.003376007080078125 0.11297607421875 0.06793212890625 0.1895751953125 0.517578125 0.210205078125
285 3BBBA8C5-62F9-4BFE-9DB6-CC38EAF11461 2020-04-23T23:18:02+00:00 
[
    "Photography homework composition April 2020",
    "Public"
]
 
[]
 jpeg 888f348b246e038ce7f950f3e5aca8169910d6bf144219c1e0dc80cd8117a2dd 8485248     1 0 0 0 0 0 0 0       3BBBA8C5-62F9-4BFE-9DB6-CC38EAF11461 0.47900390625 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.004718780517578125 0.0163421630859375 0.00473785400390625 0.009999999776482582 -0.95166015625 -0.0276336669921875 0.07867431640625 0.0016422271728515625 -0.00577545166015625 -0.00798797607421875 -0.0096435546875 -0.08978271484375 0.01934814453125 0.0404052734375 -0.0308837890625 -0.005924224853515625 0.0034027099609375 0.050994873046875 -0.00604248046875 0.1451416015625 0.304443359375 0.001800537109375
254 8B61EC59-ABEC-4C3A-BCB4-2F11D02CD3A0 2020-04-23T19:57:00+00:00 
[
    "Photography homework composition April 2020",
    "Public"
]
 
[]
 jpeg 7c22edd556267a6ee4b7016590064b1575aaaeb430dcfa674acfa5934eae85d9 8164899     1 0 0 0 0 0 0 0       8B61EC59-ABEC-4C3A-BCB4-2F11D02CD3A0 0.443115234375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0014781951904296875 0.018951416015625 0.0059814453125 0.019999999552965164 -0.01611328125 -0.056549072265625 0.10302734375 0.011199951171875 -0.01525115966796875 -0.0132904052734375 -0.09503173828125 -0.0242919921875 0.06646728515625 0.053741455078125 0.005584716796875 -0.01021575927734375 0.00646209716796875 0.037689208984375 0.017913818359375 -0.04901123046875 0.292236328125 0.03363037109375
444 0CEC9F87-56B8-4E82-885D-CE573A5A6733 2020-04-23T19:26:40+00:00 
[
    "Photography homework composition April 2020",
    "Public"
]
 
[]
 jpeg e19325bdaa3af04606d769494a62518ac08b5978677831eae415b73e4d05ae0a 8097615     1 0 0 0 0 0 0 0       0CEC9F87-56B8-4E82-885D-CE573A5A6733 0.2744140625 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.00217437744140625 0.031585693359375 0.001789093017578125 0.019999999552965164 0.165283203125 -0.072265625 0.1336669921875 0.00885009765625 -0.01142120361328125 0.0089263916015625 0.01983642578125 0.08697509765625 0.036346435546875 0.1024169921875 -0.00299072265625 -0.00263214111328125 0.001964569091796875 0.2469482421875 0.583984375 0.1607666015625 0.599609375 0.2371826171875
207 52E83D4D-36AA-465B-818C-307DE872BF95 2020-04-23T19:25:14+00:00 
[
    "Photography homework composition April 2020",
    "Public"
]
 
[]
 jpeg 679f4717f5d0fd9be0f0f39be3a1387b1ad828b30405f5a6f9acb3ffdc046911 8312828     1 0 0 0 0 0 0 0       52E83D4D-36AA-465B-818C-307DE872BF95 0.42724609375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.053192138671875 0.00365447998046875 0.0082855224609375 0.009999999776482582 -0.53271484375 -0.049407958984375 -0.058380126953125 0.0460205078125 -0.1201171875 -0.037750244140625 -0.2880859375 -0.47265625 0.017913818359375 -0.052459716796875 0.001800537109375 -0.016693115234375 0.0013885498046875 0.003780364990234375 -0.1241455078125 0.0040130615234375 -0.17236328125 -0.018096923828125
70 C0A58C86-B004-4413-855B-12A697F129D6 2020-04-23T19:19:34+00:00 
[
    "Photography homework composition April 2020",
    "Public"
]
 
[]
 jpeg 1fb3b73785ed9eb8ed706f9a7714d46c5508fcc0cf36c8212c9f88dd07d8640c 5960171     1 0 0 0 0 0 0 0       C0A58C86-B004-4413-855B-12A697F129D6 0.384521484375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.1927490234375 -0.00449371337890625 0.00555419921875 0.009999999776482582 -0.49853515625 -0.0809326171875 -0.1781005859375 0.060638427734375 -0.2347412109375 -0.032470703125 -0.41845703125 -0.6962890625 0.01267242431640625 -0.06781005859375 -0.0036258697509765625 -0.01239776611328125 0.0015974044799804688 0.00313568115234375 -0.78173828125 -0.075439453125 -0.02978515625 -0.1043701171875
314 0C9E4525-4A55-463C-ADC3-6A3A56113ABD 2020-04-23T19:17:34+00:00 
[
    "Photography homework composition April 2020",
    "Public"
]
 
[]
 jpeg 9971057ac89f7bdaf9c714d5391e7b2abab2c6cc92640f7806088a593c713f80 6475710     1 0 0 0 0 0 0 0       0C9E4525-4A55-463C-ADC3-6A3A56113ABD 0.448974609375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0018463134765625 0.01727294921875 0.0021152496337890625 0.009999999776482582 -0.411376953125 -0.053497314453125 0.1123046875 0.0083770751953125 -0.0191650390625 -0.01861572265625 -0.139404296875 -0.0224609375 0.0299835205078125 0.05865478515625 0.0028533935546875 -0.0088653564453125 0.00254058837890625 0.09808349609375 0.055267333984375 0.04888916015625 0.394287109375 0.007568359375
222 A05FA28C-4192-4430-A597-21FC5A10BEEE 2020-02-22T23:09:17+00:00 
[
    "Public"
]
 
[]
 jpeg 6f78d9316fea65c2ec229415af66627a2f106b91e79e3a59cb621ce0ef6a8996 6011023     1 0 0 0 0 0 0 0       A05FA28C-4192-4430-A597-21FC5A10BEEE 0.5107421875 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0018243789672851562 -0.00043487548828125 0.0027141571044921875 0.009999999776482582 -0.068359375 -0.07720947265625 0.170166015625 0.0079345703125 -0.029144287109375 -0.047027587890625 -0.339111328125 -0.1475830078125 0.125244140625 -0.048248291015625 -0.0052490234375 -0.03662109375 0.00464630126953125 0.0173797607421875 -0.0086822509765625 -0.49267578125 0.0789794921875 -0.03973388671875
78 92BCC6F0-0144-4501-A78D-778B3E48BF39 2020-01-25T20:09:19+00:00 
[
    "Public"
]
 
[]
 jpeg 22772bd05c0d6e769ea86ebaa1b58ed1645b4eabc9dcc9fea052196954438fdc 7751570     1 0 0 0 0 0 0 0       92BCC6F0-0144-4501-A78D-778B3E48BF39 0.46826171875 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0017681121826171875 -0.00048828125 0.0016937255859375 0.07999999821186066 0.163818359375 -0.08270263671875 0.21875 0.006412506103515625 -0.0310821533203125 -0.04290771484375 -0.2724609375 -0.14111328125 0.205078125 -0.07684326171875 -0.002254486083984375 -0.0218658447265625 0.0035648345947265625 0.021820068359375 0.0149688720703125 -0.49609375 0.0904541015625 -0.0667724609375
417 08E42F94-41A8-4205-995A-9877453FAF92 2020-01-25T19:56:23+00:00 
[
    "Public"
]
 
[]
 jpeg d3e53a733fe399fa38178513d64414c8d65639d4191cefb94ec2b7f4741dd67c 6550072     1 0 0 0 0 0 0 0       08E42F94-41A8-4205-995A-9877453FAF92 0.53515625 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0009889602661132812 0.0112152099609375 0.0030155181884765625 0.019999999552965164 -0.4736328125 -0.0181884765625 0.410888671875 0.0008263587951660156 -0.01422882080078125 -0.03338623046875 -0.06829833984375 -0.012237548828125 0.1614990234375 -0.030914306640625 -0.000240325927734375 -0.0221405029296875 0.004039764404296875 0.040313720703125 0.0086822509765625 0.0670166015625 0.204833984375 -0.01134490966796875
416 2E3925D6-FB1F-49E4-A256-7D25B38E5E77 2020-01-25T19:37:50+00:00 
[
    "Public"
]
 
[]
 jpeg d23b781c34e27fe18532881ee293166328d8e1836ab6b50b1f70ea312b5e0aab 5532065     1 0 0 0 0 0 0 0       2E3925D6-FB1F-49E4-A256-7D25B38E5E77 0.5263671875 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0017681121826171875 0.003124237060546875 0.003376007080078125 0.009999999776482582 -0.63232421875 -0.03753662109375 0.183837890625 0.001972198486328125 -0.0239105224609375 -0.08551025390625 -0.23046875 -0.079833984375 0.1666259765625 -0.06610107421875 -0.001552581787109375 -0.053802490234375 0.005344390869140625 0.02069091796875 0.00113677978515625 -0.03753662109375 0.025390625 -0.0134429931640625
310 F92B1415-1D5D-45A6-A736-54D988748BBF 2020-01-25T19:32:06+00:00 
[
    "Public"
]
 
[]
 jpeg 96bc3134c1bd2553c164f1eee6971a22ed15893dc5dabcc717fc1f72317e044a 5851617     1 0 0 0 0 0 0 0       F92B1415-1D5D-45A6-A736-54D988748BBF 0.5068359375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.030731201171875 0.00522613525390625 0.00208282470703125 0.009999999776482582 -0.45166015625 -0.199951171875 -0.006561279296875 0.033905029296875 -0.04132080078125 -0.09454345703125 -0.6005859375 -0.357666015625 0.0240936279296875 -0.1298828125 0.002777099609375 -0.021331787109375 0.0008692741394042969 0.020294189453125 -0.1363525390625 -0.057342529296875 -0.0946044921875 -0.033966064453125
335 9B1D1359-1267-42DE-BB2C-6DB3B885D3E0 2020-01-25T19:22:55+00:00 
[
    "Public"
]
 
[]
 jpeg a29c3a38ab84cb5a9158d2d1f5047f614c3065bc852042909e5ac09a59988275 5399639     1 0 0 0 0 0 0 0       9B1D1359-1267-42DE-BB2C-6DB3B885D3E0 0.46875 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0006771087646484375 0.032440185546875 0.00464630126953125 0.009999999776482582 -0.192138671875 -0.0174407958984375 0.354248046875 0.001056671142578125 -0.008544921875 -0.00421142578125 0.0537109375 0.05224609375 0.07861328125 0.060516357421875 0.00852203369140625 -0.0089111328125 0.00469970703125 0.08929443359375 0.027984619140625 0.271240234375 0.461181640625 0.0001983642578125
10 87585FA7-EF4D-4028-97D2-21631F66A32D 2020-01-25T19:17:10+00:00 
[
    "Public"
]
 
[]
 jpeg 04646192855eb795b440552ad953dd63ed7ef4adece0bb85d42b19586a6e2c59 5296462     1 0 0 0 0 0 0 0       87585FA7-EF4D-4028-97D2-21631F66A32D 0.5302734375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0020751953125 -0.00121307373046875 0.0015010833740234375 0.009999999776482582 0.32666015625 -0.06439208984375 0.1422119140625 0.012054443359375 -0.056121826171875 -0.03155517578125 -0.16259765625 -0.2366943359375 0.092041015625 -0.05120849609375 -0.0021514892578125 -0.017608642578125 0.0036640167236328125 0.0169830322265625 -0.0141448974609375 -0.45458984375 0.3212890625 -0.041168212890625
196 111A61B2-82D2-4D3D-8B38-7D6C4806C604 2020-01-25T19:07:18+00:00 
[
    "Public"
]
 
[]
 jpeg 639ea88d6253c88b10ff8b131e1845d276be62531c8c520b791f34fe905796bf 6193450     1 0 0 0 0 0 0 0       111A61B2-82D2-4D3D-8B38-7D6C4806C604 0.454345703125 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.00359344482421875 -0.002674102783203125 0.0018243789672851562 0.009999999776482582 0.2333984375 -0.062103271484375 0.07958984375 0.0154266357421875 -0.09039306640625 -0.044921875 -0.182861328125 -0.30029296875 0.105224609375 -0.06201171875 -0.0027313232421875 -0.018280029296875 0.00424957275390625 0.0118255615234375 -0.038177490234375 -0.403076171875 0.25341796875 -0.0418701171875
221 F367069B-2C5A-4C2E-BFCE-29AE79C72E73 2020-01-25T18:58:11+00:00 
[
    "Public"
]
 
[]
 jpeg 6f2595c2865301e8535ba3dee97fcb6ac321414e7989762856016992175c511f 6005431     1 0 0 0 0 0 0 0       F367069B-2C5A-4C2E-BFCE-29AE79C72E73 0.5732421875 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.002521514892578125 0.002841949462890625 0.0012941360473632812 0.009999999776482582 0.147705078125 -0.06756591796875 0.1873779296875 0.00473785400390625 -0.037384033203125 -0.025177001953125 -0.1666259765625 -0.1290283203125 0.04595947265625 -0.0789794921875 -0.00115203857421875 -0.01421356201171875 0.0018749237060546875 0.049041748046875 0.020660400390625 -0.311767578125 0.4150390625 -0.03570556640625
418 EA3A8FC2-1DB9-4906-B822-6FF0EABF625F 2020-01-25T18:52:28+00:00 
[
    "Public"
]
 
[]
 jpeg d3f48a9446d71b64f463675a11cfab4ef085b6896b185b7120daa151b946bb79 5676312     1 0 0 0 0 0 0 0       EA3A8FC2-1DB9-4906-B822-6FF0EABF625F 0.5693359375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.001926422119140625 0.0110931396484375 0.00881195068359375 0.009999999776482582 -0.0911865234375 -0.039642333984375 0.021240234375 0.01302337646484375 -0.0330810546875 -0.01708984375 -0.04541015625 -0.11285400390625 0.0360107421875 0.04541015625 0.003551483154296875 -0.00506591796875 0.006313323974609375 0.0164642333984375 -0.00704193115234375 0.0286865234375 0.219970703125 0.03277587890625
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
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
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
349 1F3A99DA-FBB6-4FDC-B84D-AE15DE0846BB 2017-03-31T00:53:36+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 jpeg a93401fea4842b551132a24a707ae8e30d646d4830c5c32c3ce7c1ddcdd61bbc 4502080 37.76918 -122.46453833333334 1 0 0 0 0 0 0 0 San Francisco CA United States 1F3A99DA-FBB6-4FDC-B84D-AE15DE0846BB 0.5263671875 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.006122589111328125 -0.00547027587890625 0.0029125213623046875 0.009999999776482582 -0.5576171875 -0.057373046875 0.273681640625 0.001956939697265625 -0.0379638671875 -0.159912109375 -0.435791015625 -0.146240234375 0.11676025390625 -0.2406005859375 -0.0036716461181640625 -0.045989990234375 0.0017681121826171875 0.00930023193359375 -0.03497314453125 -0.2568359375 -0.277587890625 -0.07403564453125

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