database/watches-search.db
SQLite format 3 @ .r�
� N ��
�
A � 2 � F
�
& � N p ;'� indexidx_price_history_watchprice_history
CREATE INDEX idx_price_history_watch ON price_history(watch_id)d /� indexidx_watches_pricewatches CREATE INDEX idx_watches_price ON watches(min_price, max_price)d
9�indexidx_watches_collectionwatches
CREATE INDEX idx_watches_collection ON watches(collection)�7 ''�-tableprice_historyprice_history CREATE TABLE price_history (
id INTEGER PRIMARY KEY,
watch_id TEXT,
year INTEGER,
price REAL,
condition TEXT
)r11�tablewatches_fts_configwatches_fts_configCREATE TABLE 'watches_fts_config'(k PRIMARY KEY, v) WITHOUT ROWIDv33�tablewatches_fts_docsizewatches_fts_docsizeCREATE TABLE 'watches_fts_docsize'(id INTEGER PRIMARY KEY, sz BLOB)�33�1tablewatches_fts_contentwatches_fts_contentCREATE TABLE 'watches_fts_content'(id INTEGER PRIMARY KEY, c0, c1, c2, c3, c4, c5)�++�?tablewatches_fts_idxwatches_fts_idxCREATE TABLE 'watches_fts_idx'(segid, term, pgno, PRIMARY KEY(segid, term)) WITHOUT ROWIDp--�tablewatches_fts_datawatches_fts_dataCREATE TABLE 'watches_fts_data'(id INTEGER PRIMARY KEY, block BLOB)�a##� tablewatches_ftswatches_ftsCREATE VIRTUAL TABLE watches_fts USING fts5(
id UNINDEXED,
name,
collection,
reference,
description,
search_text,
tokenize = 'porter unicode61'
)�/�5tablewatcheswatchesCREATE TABLE watches (
id TEXT PRIMARY KEY,
name TEXT NOT NULL,
collection TEXT,
reference TEXT,
year_introduced INTEGER,
description TEXT,
min_price REAL,
max_price REAL,
avg_price REAL,
appreciation_rate REAL
)-A indexsqlite_autoindex_watches_1watches
V P�Q
�
4 � �
�
& � 7�V q %%%WflightmasterFlightmasterFlightmaster145.026�Pilot's chronograph with GMT function�:�@��� @��51���l /3#Ospeedmaster-mark2Speedmaster Mark IISpeedmaster145.014�Tonneau-shaped racing chronograph ��� s
33#!Gspeedmaster-reducedSpeedmaster ReducedSpeedmaster3510.50.00�Smaller automatic Speedmasterx�
�@k���m��x %9 3Kplanet-oceanSeamaster Planet OceanSeamaster215.30.44.21.01.001�Professional dive watch to 600m� ,@V^Pה5�y !5 3Iaqua-terraSeamaster Aqua TerraSeamaster220.10.41.21.03.001�Versatile sports-elegant watch
�d@��UUUUU@`��I$�Iw
37![railmaster-originalRailmaster (Original)Railmaster2914�Anti-magnetic watch for railway workers}m`@�*����W � +G 3Udeville-coaxialDe Ville Co-Axial ChronometerDe Ville431.33.41.21.03.001�First watch with Co-Axial escapement ��@�4�����@\ j )- 39deville-tresorDe Ville TrésorDe Ville432.53.40.21.02.002�Ultra-thin dress watch!44�*�@Miiiiij� ;;'3Yconstellation-manhattanConstellation ManhattanConstellation131.10.29.20.02.001�Modern Constellation with claws design�P@��I$�I%@t�UUUUV� 5;'Uconstellation-piepanConstellation 'Pie Pan'Constellation168.005�Iconic dress watch with pie pan dialE% @�UUUUU@�'bv'b� )O 3aseamaster-bondSeamaster Diver 300M (James Bond)Seamaster210.22.42.20.01.004�Made famous by Pierce Brosnan's James Bond8@�� q� r@n�8�8� /; 3Qseamaster-ploprofSeamaster PloProf 1200MSeamaster227.90.55.21.04.001�Extreme dive watch tested to 1200m�4��@�C�;�a '' Qseamaster-300Seamaster 300Seamaster165.024�Original professional diving watch �@t�*�� 1A#3ispeedmaster-alaskaSpeedmaster Alaska ProjectSpeedmaster311.32.42.30.04.001�Limited edition based on NASA's Alaska ProjectdY�@�K@ @o��;��- 7Q#3{speedmaster-moonwatchSpeedmaster Professional MoonwatchSpeedmaster311.30.42.30.01.005�The legendary chronograph worn on all six moon landings � L@���N��O@�����
� `|9M�!������� %flightmaster/speedmaster-mark23speedmaster-reduced
%planet-ocean !aqua-terra 3railmaster-original
+deville-coaxial )deville-tresor;constellation-manhattan5constellation-piepan)seamaster-bond/seamaster-ploprof'seamaster-3001speedmaster-alaska7 speedmaster-moonwatch
� � A��
�
) -
7 N[=qq_��� 9
x
� ����� �@ �0026 145 chronograph
flightmastunction gmt
pilot s with
p 8r
� ����� �@ �0014 145 chronograph ii mark race
shape peedmasttonneau
- 5l
� ����� � u000
3510
50
automat
reduc
smaller
peedmast
B 2f
�[����� �: �0001 1
21 5 30 44 600m dive
ocean planet rofession seamast to watch
E /`
�L����� � �0001 3
10 21 20 41 aqua eleg seamast port
terra versatil watch
,Z
������ �: �02914
anti
for
magnet
origin
railmast
wai
watch
orker
5 )T �p����� �d �0001 3
21 33
41 31 axial chronomet o de escap first vill watch ith
+ &N �H����� � �0002 2 21
40 32 53 deress thin resor ultra
villwatch
H +BU�S�A����� � �0001
2 10 31 20 9 claw onstel
design manhattan odern with
� B �(����� �T �0005 168 consteldial ress icon pan ie watch
ith
< ������ � �0004
1 20 10 2 300m 42
bond rosnan y diver famou jamemade pierc s eamast
6 �]����� �> �0001 4
1200m21 27 55 90 dive
extrem ploprof seamasttest o watch
� 0 �
����� � �0024 165 300 dive origin
profession seamastwatch
� * �m����� �^ �0001 4
30 11 2 42 alaskabase edit
limit nasa on project s peedmast
������ �, �0005 1
3011 42 all chronograph land
egendari
moon watch on
profession six peedmastthe worn
(3| $
� ���������������
y �
g � �
�
r��1t� y � %%%W�flightmasterFlightmasterFlightmaster145.026Pilot's chronograph with GMT functionFlightmaster Flightmaster 145.026 Pilot's chronograph with GMT function�) /3#O� speedmaster-mark2Speedmaster Mark IISpeedmaster145.014Tonneau-shaped racing chronographSpeedmaster Mark II Speedmaster 145.014 Tonneau-shaped racing chronograph�)
33#!G� speedmaster-reducedSpeedmaster ReducedSpeedmaster3510.50.00Smaller automatic SpeedmasterSpeedmaster Reduced Speedmaster 3510.50.00 Smaller automatic Speedmaster�: %9 3K�5planet-oceanSeamaster Planet OceanSeamaster215.30.44.21.01.001Professional dive watch to 600mSeamaster Planet Ocean Seamaster 215.30.44.21.01.001 Professional dive watch to 600m�2 !5 3I�/aqua-terraSeamaster Aqua TerraSeamaster220.10.41.21.03.001Versatile sports-elegant watchSeamaster Aqua Terra Seamaster 220.10.41.21.03.001 Versatile sports-elegant watch�3
37![�'railmaster-originalRailmaster (Original)Railmaster2914Anti-magnetic watch for railway workersRailmaster (Original) Railmaster 2914 Anti-magnetic watch for railway workers�S +G 3U�Kdeville-coaxialDe Ville Co-Axial ChronometerDe Ville431.33.41.21.03.001First watch with Co-Axial escapementDe Ville Co-Axial Chronometer De Ville 431.33.41.21.03.001 First watch with Co-Axial escapement� )- 39�deville-tresorDe Ville TrésorDe Ville432.53.40.21.02.002Ultra-thin dress watchDe Ville Trésor De Ville 432.53.40.21.02.002 Ultra-thin dress watch�] ;;'3Y�Mconstellation-manhattanConstellation ManhattanConstellation131.10.29.20.02.001Modern Constellation with claws designConstellation Manhattan Constellation 131.10.29.20.02.001 Modern Constellation with claws design�> 5;'U�1constellation-piepanConstellation 'Pie Pan'Constellation168.005Iconic dress watch with pie pan dialConstellation 'Pie Pan' Constellation 168.005 Iconic dress watch with pie pan dial�h )O 3a�aseamaster-bondSeamaster Diver 300M (James Bond)Seamaster210.22.42.20.01.004Made famous by Pierce Brosnan's James BondSeamaster Diver 300M (James Bond) Seamaster 210.22.42.20.01.004 Made famous by Pierce Brosnan's James Bond�G /; 3Q�=seamaster-ploprofSeamaster PloProf 1200MSeamaster227.90.55.21.04.001Extreme dive watch tested to 1200mSeamaster PloProf 1200M Seamaster 227.90.55.21.04.001 Extreme dive watch tested to 1200m� '' Q�seamaster-300Seamaster 300Seamaster165.024Original professional diving watchSeamaster 300 Seamaster 165.024 Original professional diving watch�j 1A#3i�_speedmaster-alaskaSpeedmaster Alaska ProjectSpeedmaster311.32.42.30.04.001Limited edition based on NASA's Alaska ProjectSpeedmaster Alaska Project Speedmaster 311.32.42.30.04.001 Limited edition based on NASA's Alaska Project� 7Q#3{�speedmaster-moonwatchSpeedmaster Professional MoonwatchSpeedmaster311.30.42.30.01.005The legendary chronograph worn on all six moon landingsSpeedmaster Professional Moonwatch Speedmaster 311.30.42.30.01.005 The legendary chronograph worn on all six moon landings
[ �����������|qf[
� � version � �pL(���tP,
�
�
�
�
f
E
$
� � � � l L , � � � � d D $
�
�
�
�
p
S
6
� � � � r K $����b<���~aD'
����vX: ����c=�����gN5�����jH%���yY5����rW8 � u %flightmaster��vintage t %flightmaster� �vintage s %flightmaster��vintager %flightmaster��newq %flightmaster��new p /speedmaster-mark2��new o /speedmaster-mark2�hnew n /speedmaster-mark2�
�new"m /speedmaster-mark2��vintage"l /speedmaster-mark2��vintage"k /speedmaster-mark2��vintage j /speedmaster-mark2��new i /speedmaster-mark2� �new!h 3speedmaster-reduced��used!g 3speedmaster-reduced��used!f 3speedmaster-reduced� �used!e 3speedmaster-reduced�
�used!d 3speedmaster-reduced� `used c 3speedmaster-reduced�4new b 3speedmaster-reduced�new a 3speedmaster-reduced�xnew` %planet-ocean� new_ %planet-ocean�8new^ %planet-ocean�new] %planet-ocean��new\ %planet-ocean��new[ !aqua-terra�dnewZ !aqua-terra�DnewY !aqua-terra��newX !aqua-terra�<newW !aqua-terra� �newV !aqua-terra�
�new$U 3railmaster-original�m`vintage$T 3railmaster-original�U�vintage$S 3railmaster-original�6�vintage$R 3railmaster-original�!4vintage$Q 3railmaster-original��vintage$P 3railmaster-original��vintage$O 3railmaster-original��vintage$N 3railmaster-original��vintage M 3railmaster-original�}new L +deville-coaxial��new K +deville-coaxial�pnew J +deville-coaxial�Pnew I +deville-coaxial��new H +deville-coaxial��new G +deville-coaxial� �newF )deville-tresor�4�newE )deville-tresor�0�newD )deville-tresor�+�newC )deville-tresor�)newB )deville-tresor�#�newA )deville-tresor�!4new$@ ;constellation-manhattan�Pnew$? ;constellation-manhattan��new$> ;constellation-manhattan��new$= ;constellation-manhattan� �new$< ;constellation-manhattan� `new$; ;constellation-manhattan�new$: ;constellation-manhattan��new%9 5constellation-piepan�% vintage%8 5constellation-piepan� Lvintage%7 5constellation-piepan�Pvintage%6 5constellation-piepan��vintage%5 5constellation-piepan� �vintage%4 5constellation-piepan�vintage%3 5constellation-piepan��vintage!2 5constellation-piepan��new!1 5constellation-piepan�Enew0 )seamaster-bond�8new/ )seamaster-bond� new. )seamaster-bond�Pnew- )seamaster-bond�\new, )seamaster-bond�hnew+ )seamaster-bond�
�new* )seamaster-bond�
�new) )seamaster-bond��new( )seamaster-bond�new ' /seamaster-ploprof�4�new & /seamaster-ploprof�.�new % /seamaster-ploprof�)new $ /seamaster-ploprof� �new"# /seamaster-ploprof�
�vintage"" /seamaster-ploprof�vintage ! /seamaster-ploprof��new /seamaster-ploprof��new 'seamaster-300�@tvintage 'seamaster-300�:�vintage 'seamaster-300�.�vintage 'seamaster-300�!4vintage 'seamaster-300�|vintage 'seamaster-300� �vintage 'seamaster-300��vintage 'seamaster-300� vintage 'seamaster-300�^new 'seamaster-300� �new 1speedmaster-alaska�Y�new 1speedmaster-alaska�Rnew 1speedmaster-alaska�@tnew 1speedmaster-alaska�6�new 1speedmaster-alaska�*�new 1speedmaster-alaska�!4new 1speedmaster-alaska� new 1speedmaster-alaska�dnew"
7speedmaster-moonwatch� Lnew" 7speedmaster-moonwatch� new" 7speedmaster-moonwatch��new"
7speedmaster-moonwatch��new" 7speedmaster-moonwatch�hnew" 7speedmaster-moonwatch� �new" 7speedmaster-moonwatch�
�new" 7speedmaster-moonwatch��new" 7speedmaster-moonwatch�new" 7speedmaster-moonwatch��new" 7speedmaster-moonwatch��new" 7speedmaster-moonwatch��new" 7speedmaster-moonwatch� u
���y j���\N��>. %Flightmaster#Speedmaster#Speedmaster
Seamaster
Seamaster !Railmaster
De Ville De Ville'Constellation'Constellation
Seamaster
Seamaster
Seamaster#Speedmaster# Speedmaster
� ���
�:� �� x�
�
�d x %flightmaster�:�vintage w %flightmaster�.�vintage v %flightmaster�!4vintage
l ���v�l��������� �:� �� x�
�
�d }m`
�� !44� �P E% 8 �4� �@t dY� � L
x� rcTE6'
�
�
�
�
{
_
C � � � � k R 9 � � � � m Y
0
� � �Q@/
������ A ) ������
�
�
�
�
�
�
y
g
U
C � m Z G 4 ! � �
-
� � � � ���jS<%
�������xb����eK1�������rZB* %flightmasterx%flightmasterw%flightmasterv%flightmasteru%flightmastert%flightmasters%flightmasterr%flightmasterq/speedmaster-mark2p/speedmaster-mark2o/speedmaster-mark2n/speedmaster-mark2m/speedmaster-mark2l/speedmaster-mark2k/speedmaster-mark2j/speedmaster-mark2i3speedmaster-reducedh3speedmaster-reducedg3speedmaster-reducedf3speedmaster-reducede3speedmaster-reducedd3speedmaster-reducedc3speedmaster-reducedb3speedmaster-reduceda%planet-ocean`%planet-ocean_%planet-ocean^%planet-ocean]%planet-ocean\!aqua-terra[!aqua-terraZ!aqua-terraY!aqua-terraX!aqua-terraW!aqua-terraV3railmaster-originalU3railmaster-originalT3railmaster-originalS3railmaster-originalR3railmaster-originalQ3railmaster-originalP3railmaster-originalO3railmaster-originalN3railmaster-originalM+deville-coaxialL+deville-coaxialK+deville-coaxialJ+deville-coaxialI+deville-coaxialH+deville-coaxialG)deville-tresorF)deville-tresorE)deville-tresorD)deville-tresorC)deville-tresorB)deville-tresorA;constellation-manhattan@;constellation-manhattan?;constellation-manhattan>;constellation-manhattan=;constellation-manhattan<;constellation-manhattan;;constellation-manhattan:5constellation-piepan95constellation-piepan85constellation-piepan75constellation-piepan65constellation-piepan55constellation-piepan45constellation-piepan35constellation-piepan25constellation-piepan1)seamaster-bond0)seamaster-bond/)seamaster-bond.)seamaster-bond-)seamaster-bond,)seamaster-bond+)seamaster-bond*)seamaster-bond))seamaster-bond(/seamaster-ploprof'/seamaster-ploprof&/seamaster-ploprof%/seamaster-ploprof$/seamaster-ploprof#/seamaster-ploprof"/seamaster-ploprof!/seamaster-ploprof 'seamaster-300 'seamaster-300 'seamaster-300 'seamaster-300 'seamaster-300'seamaster-300'seamaster-300'seamaster-300'seamaster-300'seamaster-3001speedmaster-alaska1speedmaster-alaska1speedmaster-alaska1speedmaster-alaska1speedmaster-alaska1speedmaster-alaska1speedmaster-alaska1speedmaster-alaska7speedmaster-moonwatch
7speedmaster-moonwatch 7speedmaster-moonwatch 7speedmaster-moonwatch
7speedmaster-moonwatch 7speedmaster-moonwatch7speedmaster-moonwatch7speedmaster-moonwatch7speedmaster-moonwatch7speedmaster-moonwatch7speedmaster-moonwatch7speedmaster-moonwatch7 speedmaster-moonwatch
u � ���pL(���tP,
�
�
�
�
f
E
$
� � � � l L , � � � � d D $
�
�
�
�
p
S
6
� � � � r K $����b<���~aD'
����vX: ����c=�����gN5�����jH%���yY5����rW8 � u %flightmaster��vintage t %flightmaster� �vintage s %flightmaster��vintager %flightmaster��newq %flightmaster��new p /speedmaster-mark2��new o /speedmaster-mark2�hnew n /speedmaster-mark2�
�new"m /speedmaster-mark2��vintage"l /speedmaster-mark2��vintage"k /speedmaster-mark2��vintage j /speedmaster-mark2��new i /speedmaster-mark2� �new!h 3speedmaster-reduced��used!g 3speedmaster-reduced��used!f 3speedmaster-reduced� �used!e 3speedmaster-reduced�
�used!d 3speedmaster-reduced� `used c 3speedmaster-reduced�4new b 3speedmaster-reduced�new a 3speedmaster-reduced�xnew` %planet-ocean� new_ %planet-ocean�8new^ %planet-ocean�new] %planet-ocean��new\ %planet-ocean��new[ !aqua-terra�dnewZ !aqua-terra�DnewY !aqua-terra��newX !aqua-terra�<newW !aqua-terra� �newV !aqua-terra�
�new$U 3railmaster-original�m`vintage$T 3railmaster-original�U�vintage$S 3railmaster-original�6�vintage$R 3railmaster-original�!4vintage$Q 3railmaster-original��vintage$P 3railmaster-original��vintage$O 3railmaster-original��vintage$N 3railmaster-original��vintage M 3railmaster-original�}new L +deville-coaxial��new K +deville-coaxial�pnew J +deville-coaxial�Pnew I +deville-coaxial��new H +deville-coaxial��new G +deville-coaxial� �newF )deville-tresor�4�newE )deville-tresor�0�newD )deville-tresor�+�newC )deville-tresor�)newB )deville-tresor�#�newA )deville-tresor�!4new$@ ;constellation-manhattan�Pnew$? ;constellation-manhattan��new$> ;constellation-manhattan��new$= ;constellation-manhattan� �new$< ;constellation-manhattan� `new$; ;constellation-manhattan�new$: ;constellation-manhattan��new%9 5constellation-piepan�% vintage%8 5constellation-piepan� Lvintage%7 5constellation-piepan�Pvintage%6 5constellation-piepan��vintage%5 5constellation-piepan� �vintage%4 5constellation-piepan�vintage%3 5constellation-piepan��vintage!2 5constellation-piepan��new!1 5constellation-piepan�Enew0 )seamaster-bond�8new/ )seamaster-bond� new. )seamaster-bond�Pnew- )seamaster-bond�\new, )seamaster-bond�hnew+ )seamaster-bond�
�new* )seamaster-bond�
�new) )seamaster-bond��new( )seamaster-bond�new ' /seamaster-ploprof�4�new & /seamaster-ploprof�.�new % /seamaster-ploprof�)new $ /seamaster-ploprof� �new"# /seamaster-ploprof�
�vintage"" /seamaster-ploprof�vintage ! /seamaster-ploprof��new /seamaster-ploprof��new 'seamaster-300�@tvintage 'seamaster-300�:�vintage 'seamaster-300�.�vintage 'seamaster-300�!4vintage 'seamaster-300�|vintage 'seamaster-300� �vintage 'seamaster-300��vintage 'seamaster-300� vintage 'seamaster-300�^new 'seamaster-300� �new 1speedmaster-alaska�Y�new 1speedmaster-alaska�Rnew 1speedmaster-alaska�@tnew 1speedmaster-alaska�6�new 1speedmaster-alaska�*�new 1speedmaster-alaska�!4new 1speedmaster-alaska� new 1speedmaster-alaska�dnew"
7speedmaster-moonwatch� Lnew" 7speedmaster-moonwatch� new" 7speedmaster-moonwatch��new"
7speedmaster-moonwatch��new" 7speedmaster-moonwatch�hnew" 7speedmaster-moonwatch� �new" 7speedmaster-moonwatch�
�new" 7speedmaster-moonwatch��new" 7speedmaster-moonwatch�new" 7speedmaster-moonwatch��new" 7speedmaster-moonwatch��new" 7speedmaster-moonwatch��new" 7speedmaster-moonwatch� �new