public

Custom SQL query returning 24 rows (hide)

Query parameters

This data as json, CSV

rowidphotouuiddatealbumspersonsextsha256sizelatitudelongitudefavoriteportraitscreenshotslow_motime_lapsehdrselfiepanoramaplace_cityplace_state_provinceplace_countryZUUIDZOVERALLAESTHETICSCOREZCURATIONSCOREZPROMOTIONSCOREZHIGHLIGHTVISIBILITYSCOREZBEHAVIORALSCOREZFAILURESCOREZHARMONIOUSCOLORSCOREZIMMERSIVENESSSCOREZINTERACTIONSCOREZINTERESTINGSUBJECTSCOREZINTRUSIVEOBJECTPRESENCESCOREZLIVELYCOLORSCOREZLOWLIGHTZNOISESCOREZPLEASANTCAMERATILTSCOREZPLEASANTCOMPOSITIONSCOREZPLEASANTLIGHTINGSCOREZPLEASANTPATTERNSCOREZPLEASANTPERSPECTIVESCOREZPLEASANTPOSTPROCESSINGSCOREZPLEASANTREFLECTIONSSCOREZPLEASANTSYMMETRYSCOREZSHARPLYFOCUSEDSUBJECTSCOREZTASTEFULLYBLURREDSCOREZWELLCHOSENSUBJECTSCOREZWELLFRAMEDSUBJECTSCOREZWELLTIMEDSHOTSCORE
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
223 B29AB28B-D604-408A-923C-45D779BCB380 2020-01-25T19:57:50+00:00 
[
    "Public"
]
 
[]
 jpeg 6f92ecbbc9835eedeb6c95e828fe99398a85ead6c52dd116bd953cf4a26dafb6 5776484     1 0 0 0 0 0 0 0       B29AB28B-D604-408A-923C-45D779BCB380 0.599609375 0.75 0.0 0.06111792116674758 0.10000000149011612 -0.0009255409240722656 0.0242462158203125 0.0034694671630859375 0.019999999552965164 0.38623046875 -0.0982666015625 0.058197021484375 0.018096923828125 -0.0121002197265625 0.000335693359375 -0.111572265625 0.11328125 0.03155517578125 0.118896484375 0.00444793701171875 -0.00079345703125 0.0035648345947265625 0.06500244140625 0.06536865234375 -0.10003662109375 0.36474609375 0.423583984375
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
7 5BD1D973-19F4-48F1-AB13-A214B0B98452 2020-01-25T18:18:00+00:00 
[
    "Public"
]
 
[]
 heic 03bd641c31961be01b3f491a7414ccacb2c57dece64fd6fd8e4be6384643ef8e 2939606 37.11606667000001 -122.330475 1 0 0 0 0 0 0 0 Pescadero CA United States 5BD1D973-19F4-48F1-AB13-A214B0B98452 0.4609375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.00885009765625 0.0035858154296875 0.01512908935546875 0.019999999552965164 -0.51416015625 -0.0567626953125 0.0233154296875 0.029815673828125 -0.047515869140625 -0.06463623046875 -0.453369140625 -0.25146484375 0.134033203125 -0.031097412109375 0.00135040283203125 -0.0153350830078125 0.00577545166015625 0.004383087158203125 -0.039459228515625 -0.0838623046875 -0.360107421875 -0.022308349609375
252 0BE49C93-2ACC-4628-9C12-99566921EE00 2020-01-25T18:11:18+00:00 
[
    "Public"
]
 
[]
 heic 7ad35f068121f446574a8c950f35017b34cbc4e6dd25c72be8a71b9234bb1e7a 3541580 37.115291670000005 -122.32810333 1 0 0 0 0 0 0 0 Pescadero CA United States 0BE49C93-2ACC-4628-9C12-99566921EE00 0.499267578125 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.00359344482421875 0.0284423828125 0.0020751953125 0.019999999552965164 0.091552734375 -0.055206298828125 0.0228271484375 0.1646728515625 -0.0496826171875 -0.010345458984375 -0.0771484375 -0.1522216796875 0.047515869140625 0.07708740234375 0.0098876953125 -0.006160736083984375 0.006072998046875 0.0849609375 0.03167724609375 -0.0933837890625 0.5546875 0.07440185546875
93 45CD64EE-9C93-48EA-89F8-8F9C849543F6 2019-12-18T15:26:39+00:00 
[
    "Public"
]
 
[]
 heic 2914d77166bd3d96058e8c4994e7840b61fc4f42a2be6c67cf2f6dbba96861fb 1517951 51.51231333 -0.09033617000000002 1 0 0 0 0 0 0 0 London England United Kingdom 45CD64EE-9C93-48EA-89F8-8F9C849543F6 0.6953125 0.75 0.0 0.058028268450089085 0.7025303840637207 -0.0003597736358642578 0.112548828125 0.005344390869140625 0.019999999552965164 0.80517578125 -0.0253753662109375 0.1171875 0.0162811279296875 -0.004314422607421875 0.01824951171875 0.52001953125 0.43359375 0.043121337890625 0.350341796875 0.045166015625 0.056427001953125 0.01332855224609375 0.2529296875 0.1829833984375 0.2476806640625 0.771484375 0.8681640625
298 3C3089C2-BA72-45E8-90B9-2974D8D2DB36 2019-12-13T23:52:03+00:00 
[
    "Public"
]
 
[]
 heic 8e935af3c408ee0013c7d05f82ae8592f12aa341f455cc15534ae2db1ead05ef 2663392 34.11846667000001 -118.30060500000002 1 0 0 0 0 0 0 0 Los Angeles CA United States 3C3089C2-BA72-45E8-90B9-2974D8D2DB36 0.289794921875 0.75 0.0 0.05801763419659083 0.10000000149011612 -0.0009660720825195312 -0.00296783447265625 0.0020580291748046875 0.019999999552965164 0.148681640625 -0.0546875 0.416748046875 0.0016613006591796875 -0.0190887451171875 -0.022308349609375 -0.1881103515625 -0.056060791015625 0.286865234375 -0.05364990234375 -0.00543212890625 -0.0264129638671875 0.0034027099609375 0.0214080810546875 0.0212860107421875 -0.6259765625 0.081787109375 -0.1051025390625
107 8A1CFD4F-AF9F-4018-A451-4709416FAEA0 2019-11-02T20:39:44+00:00 
[
    "Public"
]
 
[]
 jpeg 3345e08925ea68ce3808102dce8f4b4e08f6c65a77d405c8b7a4741c322e0c68 4263841     1 0 0 0 0 0 0 0       8A1CFD4F-AF9F-4018-A451-4709416FAEA0 0.7177734375 0.75 0.0 0.06262569391090451 0.10000000149011612 -0.0007410049438476562 0.0189056396484375 0.0011157989501953125 0.019999999552965164 -0.064697265625 -0.046905517578125 0.2431640625 0.0034160614013671875 -0.01358795166015625 0.0128173828125 -0.04541015625 0.04571533203125 0.055206298828125 0.05841064453125 0.003330230712890625 -0.0134429931640625 0.0029582977294921875 0.242919921875 0.160888671875 -0.0233154296875 0.61572265625 0.01202392578125
230 D28ACD11-B3D5-43BE-96C5-9CE7D39E95E1 2019-11-02T20:31:30+00:00 
[
    "Public"
]
 
[]
 jpeg 71e43f92a0ac99ed5fa838e65f58a6976c1d3e80908eb4b0427e104da7f4d2e3 4531938     0 0 0 0 0 0 0 0       D28ACD11-B3D5-43BE-96C5-9CE7D39E95E1 0.84423828125 0.75 0.0 0.06261613123289501 0.10000000149011612 -0.0031719207763671875 -0.0098876953125 0.0023975372314453125 0.019999999552965164 -0.1708984375 -0.06890869140625 0.2208251953125 0.0024814605712890625 -0.05072021484375 -0.1019287109375 -0.407958984375 -0.1861572265625 0.199462890625 -0.140869140625 -0.0044708251953125 -0.032257080078125 0.002368927001953125 0.004848480224609375 -0.022552490234375 -0.53173828125 -0.293701171875 -0.13134765625
36 5C91B5A8-1A4C-4406-B5E6-11883EFC714E 2019-09-16T16:26:37+00:00 
[
    "Public"
]
 
[]
 heic 14101f33adc465139279ae9a80118d2b388f4350c9b1b5ed06596282646d000b 2027028 37.44983333333333 -122.1864 1 0 0 0 0 0 0 0 Menlo Park CA United States 5C91B5A8-1A4C-4406-B5E6-11883EFC714E 0.300048828125 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0008935928344726562 0.032806396484375 0.0007948875427246094 0.019999999552965164 -0.158447265625 -0.049957275390625 0.421630859375 0.0026721954345703125 -0.007904052734375 0.01885986328125 -0.05377197265625 0.057647705078125 0.08465576171875 0.02484130859375 0.0040283203125 -0.014495849609375 0.001934051513671875 0.43359375 0.56494140625 0.025390625 0.62744140625 -0.0088653564453125
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
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
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
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
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
136 C7714BF0-9654-4D2D-A5A4-032901EC2419 2019-08-21T16:10:02+00:00 
[
    "Public"
]
 
[]
 jpeg 3ed563ada4d69d6e5646209933fd179a95e4b1d13ac1aab3d671db4fab94dba9 6328113     1 0 0 0 0 0 0 0       C7714BF0-9654-4D2D-A5A4-032901EC2419 0.68212890625 0.75 0.0 0.061103434053086145 0.10000000149011612 -0.0013885498046875 0.02130126953125 0.0026836395263671875 0.019999999552965164 0.0869140625 -0.0867919921875 0.130126953125 0.00646209716796875 -0.0104522705078125 -0.006500244140625 -0.170654296875 0.044677734375 0.031982421875 0.054931640625 0.005218505859375 -0.004608154296875 0.0018463134765625 0.07611083984375 0.11651611328125 -0.04833984375 0.295166015625 0.1043701171875
485 379BF280-6D24-43EF-9DB2-0E497D08DD34 2019-08-21T16:08:21+00:00 
[
    "Public"
]
 
[]
 jpeg fa119150fd7f15dee753c4f9c609e7c0b84d349786b1ee52db4ba4b9b5508564 6961977     1 0 0 0 0 0 0 0       379BF280-6D24-43EF-9DB2-0E497D08DD34 0.6865234375 0.75 0.0 0.06110696301205468 0.7058150768280029 -0.0004494190216064453 0.06787109375 0.001964569091796875 0.019999999552965164 0.701171875 -0.028594970703125 0.143798828125 0.00653839111328125 -0.0026721954345703125 0.00968170166015625 0.40576171875 0.373291015625 0.0222015380859375 0.232177734375 0.02508544921875 0.004364013671875 0.004100799560546875 0.71484375 0.86328125 0.313232421875 0.8720703125 0.509765625
64 8D169BB8-BF13-4FE9-8196-10DA495ABA01 2019-08-21T16:05:31+00:00 
[
    "Public"
]
 
[]
 jpeg 1d8f6e62965eb678ed412a9eb03bf1bcfd25803814540e560b2f0b675b99f3f2 6446517     1 0 0 0 0 0 0 0       8D169BB8-BF13-4FE9-8196-10DA495ABA01 0.69873046875 0.75 0.0 0.061116806878388386 0.10000000149011612 -0.0006289482116699219 0.03472900390625 0.0033111572265625 0.019999999552965164 0.323486328125 -0.04803466796875 0.275390625 0.001979827880859375 -0.01024627685546875 0.006317138671875 0.017578125 0.07647705078125 0.058563232421875 0.0870361328125 0.016082763671875 -0.0051422119140625 0.003063201904296875 0.09185791015625 0.062103271484375 0.1712646484375 0.52392578125 0.09039306640625
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
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
95 A4CA92F3-A131-498E-8205-62E1BF5A4EF4 2018-02-09T17:12:24+00:00 
[
    "Public"
]
 
[]
 jpeg 2bb66fd402f278b2d94fe7858cc0433d75c10ae4b7dad602fea6f6d8c3cdb57f 6153631     1 0 0 0 0 0 0 0       A4CA92F3-A131-498E-8205-62E1BF5A4EF4 0.60595703125 0.75 0.0 0.06109619049625542 0.10000000149011612 -0.0016813278198242188 -0.0042266845703125 0.002834320068359375 0.019999999552965164 -0.5615234375 -0.033599853515625 0.300048828125 0.001220703125 -0.0206451416015625 -0.06109619140625 -0.2479248046875 -0.1029052734375 0.1707763671875 -0.0718994140625 -0.003936767578125 -0.048583984375 0.004070281982421875 0.0121917724609375 -0.003787994384765625 -0.199462890625 -0.051025390625 -0.02569580078125
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
Powered by Datasette · Query took 1.606ms · About: dogsheep/dogsheep-photos