Below is a simple web crawler I wrote in Julia. The crawler searches for a word entered by a user on dotmed.com (a website that sells medical equipment). In this example the crawler searches for ‘wire’ and looks through 10 result pages. The crawler extracts listing URLs, visits the listing pages, and extracts listing details (such as price and condition). The listing details are inserted into an SQLite database.¶

In [1]:
# Get search query and number of pages from user
print("What do you want to search for?")
query = readline()
print("How many pages do you want to search through?")
pages_to_visit = readline()
pages_to_visit = parse(Int16, pages_to_visit);
pages_to_visit = pages_to_visit-1;

What do you want to search for?stdin> wire
How many pages do you want to search through?stdin> 10
In [2]:
# Import packages
using SQLite
using DataFrames
using HTTP
In [3]:
# Generate search page URL using inputs
url_prefix = "https://www.dotmed.com/listings/search/equipment.html?key="
url_suffix = "&offset="
url_to_examine = string(url_prefix, query, url_suffix);
In [4]:
# Connect to database
julia_dotmed = SQLite.DB("dotmed_julia.db");
In [5]:
page_size = 15
pages_viewed = 0

while pages_viewed <= pages_to_visit*page_size
    url_to_examine = split(url_to_examine, url_suffix)
    url_to_examine = first(url_to_examine)
    url_to_examine = url_to_examine*url_suffix*string(pages_viewed)
    
    # Visit URL and download HTML contents
    print("Visiting this page: " * url_to_examine * "\n")
    response = HTTP.request("GET", url_to_examine)
    status, headers, html_source = response.status, response.headers, String(response.body)

    # Get the listing URLs
    matches = eachmatch(r"(/listing/[^\"]+)", html_source)
    matches_as_list = [m.match for m in matches]
    matches_as_list = filter(x-> findfirst(r"/log_search_click",x) == nothing, matches_as_list)
    urls = ["https://www.dotmed.com"*s for s in matches_as_list]
    urls = unique(urls)

    # Visit URLs one by one
    urls_visited = 1
    while urls_visited < length(urls)

        listing_to_visit = urls[urls_visited]
        #print("Visiting this URL: " * listing_to_visit * "\n")

        response = HTTP.request("GET", listing_to_visit)
        status, headers, html_source = response.status, response.headers, String(response.body)

        # Extract Title
        regex_match = match(r"<meta property=.og:title. content=.([^<]+)", html_source)
        if regex_match !== nothing
            title = regex_match.match
            title = replace.(title, r"<meta property=\"og:title\" content=\"" => "")
            title = replace.(title, r" \- DOTmed Listing #.+" => "")
            title = replace(title, "\n" => "")
        end

        # Extract ID
        regex_match = match(r"<meta property=[^<]+DOTmed Listing #[0-9]+:", html_source)
        if regex_match !== nothing
            listing_id = regex_match.match
            listing_id = replace.(listing_id, r".+ \- DOTmed Listing #" => "")
            listing_id = replace.(listing_id, r":" => "")
        end

        # Extract Price
        regex_match = match(r"<span class=\"price\" content=\"[0-9\.]+", html_source)
        if regex_match !== nothing
            price = regex_match.match
            price = replace.(price, r"<span class=\"price\" content=\"" => "")
        else
            price = "NULL"
        end

        # Extract Location
        regex_match = match(r"<li><span>Location :</span>[^<]+", html_source)
        if regex_match !== nothing
            location = regex_match.match
            location = replace.(location, r"<li><span>Location :</span>" => "")
            location = replace(location, "  " => "")
        end

        # Extract Condition
        regex_match = match(r"<li><span>Condition :</span>[^\"]+<\/li>", html_source)
        if regex_match !== nothing
            condition = regex_match.match
            condition = replace.(condition, r".*<span>" => "")
            condition = split(condition, "<")
            condition = first(condition)
        end

        # Insert listing data into database
        query = "INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES (\"" * listing_to_visit * "\", \"" * title * "\", " * listing_id * ", " * price * ", \"" * location * "\", \"" * condition * "\")"
        println("Running this query: " * query)
        DataFrame(DBInterface.execute(julia_dotmed, query))

        urls_visited = urls_visited+1

    end

    pages_viewed = pages_viewed + 1*page_size;
    sleep(5)
    
end

Visiting this page: https://www.dotmed.com/listings/search/equipment.html?key=wire&offset=0
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/other/aesculap/ga176/wire-driver-cable-187cm-for-elan-surgical-system-6-months-warranty/4381615", "Used AESCULAP GA176 Wire Driver Cable 187cm for Elan surgical system + 6 months warranty  For Sale", 4381615, 499.99, "United Kingdom	", "Used - Good")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/liquid-chromatograph-hplc/agilent/3100-offgel-fractionator-and-g3101a-controller-protein-prefractionation/2293522", "Used AGILENT 3100 OFFGEL Fractionator and G3101A Controller PROTEIN PREFRACTIONATION Liquid Chromatograph/HPLC For Sale", 2293522, 1250.00, "United Kingdom	", "Used - Good")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/chromatograph/thermo/scientific-dionex-afc-3000-automated-fraction-collector/3427187", "Used THERMO Scientific Dionex AFC-3000 Automated Fraction Collector Chromatograph For Sale", 3427187, 1250.00, "United Kingdom	", "Used - Good")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/electrosurgical-unit/erbe/icc-200-apc-300-foot-switch/3474463", "Used ERBE ICC 200 + APC 300 + Foot-switch Electrosurgical Unit For Sale", 3474463, NULL, "United Kingdom	", "Used - Good")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/humidifier/fisher-paykel/fisher-and-paykal-mr810aek-respiratory-humidifier/4497801", "Used FISHER &amp; PAYKEL Fisher and paykal MR810AEK Respiratory Humidifier Humidifier For Sale", 4497801, 499.00, "United Kingdom	", "Used - Good")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/printer/mitsubishi/cp700e-video-color-printer-remote-controller-for-ultrasounds-and-endoscopes/4381439", "Used MITSUBISHI CP700E video color printer - remote controller for ultrasounds and endoscopes Printer For Sale", 4381439, 499.00, "United Kingdom	", "Used - Good")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/surgical-instruments/zimmer/durom-0100219826/hip-resurfacing-surgical-tool-set-acetabular-system-in-3-box/4381443", "Used ZIMMER Durom 01.00219.826 HIP resurfacing surgical tool set acetabular system in 3 box Surgical Instruments For Sale", 4381443, 3999.00, "United Kingdom	", "Used - Good")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/other/i2m/idrostar-/ontophoresis-for-hands-feet-axillae-dermatology-treatment-set/4381516", "Used I2M Idrostar + ontophoresis  for Hands Feet Axillae Dermatology treatment set  For Sale", 4381516, 499.00, "United Kingdom	", "Used - Good")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/ecg-simulator/ge/seer-1000/4381673", "New GE Seer 1000 ECG Simulator For Sale", 4381673, 1999.99, "United Kingdom	", "New")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/arthroscopy-pump/aesculap/elan-ga855/4381688", "Used AESCULAP Elan GA855 Arthroscopy Pump For Sale", 4381688, 1499.00, "United Kingdom	", "Used - Good")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/defibrillator/physio-control-medtronic/medtronic-lifepak-15-with-pacer-co2-ecg-masimo-spo2-nibp-bluetooth/4704550", "Used PHYSIO-CONTROL/ MEDTRONIC Medtronic lifepak 15 - with pacer, CO2, ECG, Masimo Spo2, NIBP, Bluetooth Defibrillator For Sale", 4704550, 7999.00, "United Kingdom	", "Used - Good")
Visiting this page: https://www.dotmed.com/listings/search/equipment.html?key=wire&offset=15
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/humidifier-heater/fisher-paykel/900mr806/4250173", "New FISHER &amp; PAYKEL 900mr806 Humidifier / Heater For Sale", 4250173, 85.00, "United Kingdom	", "New")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/titrator/metrohm/838-advanced-sample-processor/3405509", "Used METROHM 838 Advanced Sample Processor Titrator For Sale", 3405509, 1945.00, "United Kingdom	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/liquid-chromatograph-hplc/dionex/gp50-chromatography-hplc-gradient-pump/3523261", "Used DIONEX GP50 Chromatography HPLC Gradient Pump Liquid Chromatograph/HPLC For Sale", 3523261, 765.00, "United Kingdom	", "Used - Good")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/defibrillator/marquette/series-responder-1200/1627718", "Used MARQUETTE Series Responder 1200 Defibrillator For Sale", 1627718, 380.00, "United Kingdom	", "Used - Good")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/audiometer/otodynamics/otoport-docking-station-oae-a15-09-0-0/3040457", "Used OTODYNAMICS Otoport Docking Station OAE A15-09-0-0 Audiometer For Sale", 3040457, 139.00, "United Kingdom	", "Used - Good")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/monitor/iiyama/prolite-19-ips-touchscreen-t1931sr-w1/4535695", "New IIYAMA Prolite 19&quot; IPS Touchscreen T1931SR-W1 Monitor For Sale", 4535695, 350.00, "United Kingdom	", "New")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/orthopedic-general/stryker/electric-system-6-large-bone/stryker-electric-system-6-large-bone-power-tools-set/4552540", "Used STRYKER Electric System 6 Large Bone Stryker Electric System 6 Large Bone Power Tools Set Orthopedic - General For Sale", 4552540, 4400.00, "United Kingdom	", "Used - Good")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/titrator/metrohm/907-titrando-for-karl-fisher-titration-807-10ml-dosing-unit-807-20ml-dosing-unit-800-dosino-801-stirrer/4639674", "Used METROHM 907 Titrando for Karl Fisher Titration, 807 10ml Dosing Unit, 807 20ml Dosing Unit, 800 Dosino, 801 Stirrer, Titrator For Sale", 4639674, 9750.00, "United Kingdom	", "Used - Good")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/titrator/metrohm/901-titrando-for-karl-fischer-titration-900-touch-control-807-20ml-dosing-unit-800-dosino-803-ti-stand/4639931", "Used METROHM 901 Titrando for Karl Fischer Titration, 900 Touch Control, 807 20ml Dosing Unit, 800 Dosino, 803 Ti Stand Titrator For Sale", 4639931, 4750.00, "United Kingdom	", "Used - Good")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/liquid-chromatograph-hplc/dionex/ed-40-laboratory-hplc-electrochemical-detector/2850341", "Used DIONEX ED-40 Laboratory HPLC Electrochemical Detector Liquid Chromatograph/HPLC For Sale", 2850341, 665.00, "United Kingdom	", "Used - Good")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/gamma-counter/perkin-elmer/wizard-1470-gamma-counter/2850370", "Used PERKIN ELMER Wizard 1470 Gamma Counter Gamma Counter For Sale", 2850370, 1950.00, "United Kingdom	", "Used - Good")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/disposables-general/terumo/runthrough/ns-ptca-guide-wire-tw-as418xa/4422774", "New TERUMO Runthrough NS PTCA Guide Wire TW-AS418XA Disposables - General For Sale", 4422774, 46.44, "Poland	", "New")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/disposables-general/asahi-intecc/asahi-sion-black-guide-wire-apw14r010s/apw14r010s/4575942", "New ASAHI INTECC Asahi Sion Black Guide Wire APW14R010S APW14R010S Disposables - General For Sale", 4575942, 54.46, "Poland	", "New")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/disposables-general/asahi-intecc/asahi-sion-blue-guide-wire-ahw14r104s/asahi-sion-blue-guide-wire-ahw14r104s/4575944", "New ASAHI INTECC Asahi Sion Blue Guide Wire AHW14R104S Asahi Sion Blue Guide Wire AHW14R104S Disposables - General For Sale", 4575944, 54.58, "Poland	", "New")
Visiting this page: https://www.dotmed.com/listings/search/equipment.html?key=wire&offset=30
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/cardiac/volcano/verrata-guide-wire/2867013", "New VOLCANO Verrata Guide Wire Cardiac Ultrasound For Sale", 2867013, NULL, "Poland	", "New")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/stent/abbott/hi-torque-command-peripheral-guide-wire/2635234", "New ABBOTT HI-TORQUE COMMAND PERIPHERAL GUIDE WIRE Stent For Sale", 2635234, NULL, "Poland	", "New")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/stent/boston-scientific/pt-moderate-support-guide-wire/2814534", "New BOSTON SCIENTIFIC PT&sup2; Moderate Support Guide Wire Stent For Sale", 2814534, NULL, "Poland	", "New")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/other/microchoice/5020-028/wire-driver/4446704", "Used MICROCHOICE 5020-028 Wire Driver  For Sale", 4446704, 80.00, "Poland	", "Used - Good")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/other/hall/k111a/wire-driver/4446706", "Used HALL K111A Wire Driver  For Sale", 4446706, 85.00, "Poland	", "Used - Good")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/orthopedic-general/synthes/ref-511791/quick-coupling-for-kirschner-wires/3502631", "Used SYNTHES Ref 511.791 Quick Coupling for Kirschner Wires Orthopedic - General For Sale", 3502631, 150.00, "France	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/monitor/ge/dash-4000/3666837", "Used GE Dash 4000 Monitor For Sale", 3666837, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/humidifier/wilamed/aircon-gen2/4517985", "New WILAMED AIRcon Gen2 Humidifier For Sale", 4517985, NULL, "Netherlands	", "New")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/humidifier-heater/fisher-paykel/mr850/4644079", "Used FISHER &amp; PAYKEL MR850 Humidifier / Heater For Sale", 4644079, 300.00, "Netherlands	", "Used - Good")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/laser-radio-frequency-rf/ellman/round-loop-electrode-tbbb/2739573", "New ELLMAN Round Loop Electrode TBBB Laser - Radio Frequency (RF) For Sale", 2739573, NULL, "Poland	", "New")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/humidifier/fisher-paykel/mr730/3463037", "Used FISHER &amp; PAYKEL MR730 Humidifier For Sale", 3463037, 340.00, "Poland	", "Used - Good")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/monitor/ge/dash-4000/4235989", "Used GE Dash 4000 Monitor For Sale", 4235989, NULL, "Poland	", "Used - Good")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/video-endoscopy/olympus/cv-180/stack-system/4271170", "Used OLYMPUS CV 180 Stack System Video Endoscopy For Sale", 4271170, NULL, "Poland	", "Used - Good")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/humidifier-heater/fisher-paykel/mr850/4305255", "Used FISHER &amp; PAYKEL MR850 Humidifier / Heater For Sale", 4305255, NULL, "Poland	", "Used - Excellent")
Visiting this page: https://www.dotmed.com/listings/search/equipment.html?key=wire&offset=45
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/o-r-instruments-power/conmed-linvatec-hall/power-pro-pro6150/pneumatic-modular-drive/4449471", "Used CONMED LINVATEC HALL Power Pro PRO6150 Pneumatic Modular Drive O/R Instruments Power For Sale", 4449471, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/exam-chair/schmitz/medi-matic-115755-with-leisegang-colposcope/4494675", "Used SCHMITZ Medi-Matic 115.755 with Leisegang Colposcope Exam Chair For Sale", 4494675, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/o-r-table/brumaba/classic-l1-ophthalmic-surgical-treatment/4516264", "Used BRUMABA Classic L1  Ophthalmic Surgical Treatment O/R Table For Sale", 4516264, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/o-r-table/maquet/betastar-1131/4516285", "Used MAQUET Betastar 1131 O/R Table For Sale", 4516285, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/o-r-table/maquet/betastar-1223/4516294", "Used MAQUET Betastar 1223 O/R Table For Sale", 4516294, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/exam-chair/midmark/promotal-elansa-gynaecological/4516295", "Used MIDMARK Promotal Elansa Gynaecological Exam Chair For Sale", 4516295, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/arthroscopy-shaver-system/conmed-linvatec/d3000-orthopedic-drive-saw-shaver/4552452", "Used CONMED LINVATEC D3000 Orthopedic Drive Saw Shaver Arthroscopy Shaver System For Sale", 4552452, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/o-r-ob-table/trumpf/jupiter/4612306", "Used TRUMPF Jupiter O/R OB Table For Sale", 4612306, NULL, "Poland	", "Used - Good")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/patternless-edger/topcon/fr-50/4670472", "Used TOPCON FR-50 Patternless Edger For Sale", 4670472, 850.00, "Netherlands	", "Used - Unknown")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/injector-ct/nemoto/dual-shot/4669530", "Used NEMOTO Dual Shot Injector CT For Sale", 4669530, NULL, "Germany	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/monitor/datascope/duo-vital-signs-patient/3211353", "Used DATASCOPE DUO Vital signs patient Monitor For Sale", 3211353, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/ekg/nelcor-puritan-bennett/npb-4000-cardiomonitor/3211390", "Used NELCOR PURITAN BENNETT NPB-4000 Cardiomonitor EKG For Sale", 3211390, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/monitor/med-choice/mmed6000dp-m10-patient-monitor-cardiomonitor/4267431", "Used MED CHOICE MMED6000DP-M10 Patient Monitor / Cardiomonitor Monitor For Sale", 4267431, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/monitor/philips/intellivue-m8007a-patient-monitor-with-measuring-modules/4267689", "Used PHILIPS INTELLIVUE M8007A Patient Monitor with measuring modules Monitor For Sale", 4267689, NULL, "Poland	", "Used - Excellent")
Visiting this page: https://www.dotmed.com/listings/search/equipment.html?key=wire&offset=60
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/diathermy-unit/ellman/pelleve-s5-iec/4602949", "Refurbished ELLMAN PELLEVE S5-IEC Diathermy Unit For Sale", 4602949, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/arrhythmia/medtronic/flexcath-advance-steerable-sheath-4fc12/3682405", "New MEDTRONIC FlexCath Advance Steerable Sheath 4FC12 Arrhythmia For Sale", 3682405, NULL, "Poland	", "New")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/electrosurgical-unit/depuy-mitek/vapr-vue/3257851", "Used DEPUY MITEK VAPR VUE Electrosurgical Unit For Sale", 3257851, 750.00, "Netherlands	", "Used - Good")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/humidifier-heater/fisher-paykel/mr730/4375970", "Used FISHER &amp; PAYKEL MR730 Humidifier / Heater For Sale", 4375970, 250.00, "Netherlands	", "Used - Good")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/telemetry/ge/apex-pro-t4/4527023", "Used GE Apex Pro T4 Telemetry For Sale", 4527023, NULL, "France	", "Used - Good")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/dr/drtech/rosem-2430c/4699702", "New DRTECH RoseM 2430C DR For Sale", 4699702, NULL, "Latvia	", "New")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/dr/drtech/rosem-1824c/4699703", "New DRTECH RoseM 1824C DR For Sale", 4699703, NULL, "Latvia	", "New")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/o-r-table/famed-ywiec/su-04/4709467", "Used FAMED YWIEC SU-04 O/R Table For Sale", 4709467, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/o-r-instruments-power/wh/vinci-300-set-1/vinci-300-set-1/2828261", "Used W&amp;H Vinci 300 Set 1 Vinci 300 Set 1 O/R Instruments Power For Sale", 2828261, 1990.00, "Germany	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/anesthesia-accessories/draeger/infiniti-c700-for-it/workstation/2839748", "Used DRAEGER INFINITI C700 for IT Workstation  Anesthesia Accessories For Sale", 2839748, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/printer/mitsubishi/cp700e/3125562", "Used MITSUBISHI CP700E Printer For Sale", 3125562, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/monitor/welch-allyn/spot-vital-signs-patient/3179771", "Used WELCH ALLYN SPOT VITAL SIGNS Patient Monitor For Sale", 3179771, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/ekg/viatom/checkme-pro-patient-health-monitor-with-blood-pressure-monitor/3446013", "New VIATOM CHECKME PRO patient health monitor with blood pressure monitor EKG For Sale", 3446013, NULL, "Poland	", "New")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/endoscopy-general/olympus/sd-6l-ae/polypectomy-loop/3717497", "Used OLYMPUS SD - 6L AE Polypectomy Loop Endoscopy General For Sale", 3717497, NULL, "Poland	", "Used - Excellent")
Visiting this page: https://www.dotmed.com/listings/search/equipment.html?key=wire&offset=75
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/o-r-table/opt/30-version-b-operating-table/3741055", "Used OPT 30 Version (B) Operating table O/R Table For Sale", 3741055, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/ecg-unit/criticare-comfortcuff/506n3-patient-monitor/3743889", "Used CRITICARE COMFORTCUFF 506N3 Patient monitor ECG unit For Sale", 3743889, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/ekg/krans-buhler/doppler-logidop-2/3745495", "Used KRANS BUHLER Doppler LOGIDOP 2 EKG For Sale", 3745495, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/exam-chair/btl/1500-gynecological/4235960", "Used BTL 1500 Gynecological Exam Chair For Sale", 4235960, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/bedside-monitor/welch-allyn/patient-monitor-cardiac-monitor-propaq-encore-206-el/4253405", "Used WELCH ALLYN Patient monitor / cardiac monitor PROPAQ ENCORE 206 EL Bedside Monitor For Sale", 4253405, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/rad-room/general-x-ray/golem-skia-table/4263495", "Used GENERAL X-RAY GOLEM SKIA table Rad Room For Sale", 4263495, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/ultrasound-general/toshiba/ssa-790a-aplio-xg/ultrasound-system/4275757", "Used TOSHIBA SSA-790A APLIO XG Ultrasound System Ultrasound General For Sale", 4275757, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/monitor/ge/dash-3000/4275758", "Used GE Dash 3000 Monitor For Sale", 4275758, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/respirator/carefusion/ventilator-avea/4302603", "Used CAREFUSION Ventilator AVEA Respirator For Sale", 4302603, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/dental-x-ray/planmeca-intra/prox-intraoral/4335174", "Used PLANMECA INTRA PROX intraoral Dental X-Ray For Sale", 4335174, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/exam-chair/schmitz/gynaecological-arco-114595/4353962", "Used SCHMITZ Gynaecological ARCO 114.595 Exam Chair For Sale", 4353962, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/o-r-light/fedmedical-inc/treatment-lamp-fmi-301fb/4359328", "Used FEDMEDICAL INC Treatment Lamp FMI - 301FB O/R Light For Sale", 4359328, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/dental-x-ray/planmeca/panoramic-pro-one/4363765", "Used PLANMECA Panoramic PRO ONE Dental X-Ray For Sale", 4363765, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/hospital-bed/rehabed-taurus/silver-lux-electric-rehabilitation/4385878", "Used REHABED TAURUS SILVER LUX Electric Rehabilitation Hospital Bed For Sale", 4385878, NULL, "Poland	", "Used - Excellent")
Visiting this page: https://www.dotmed.com/listings/search/equipment.html?key=wire&offset=90
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/incubator/poleko/clw-53-laboratory/4393801", "Used POLEKO CLW 53 Laboratory Incubator For Sale", 4393801, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/dialysis-chair/nitrocare/ntcr-sd07/4417283", "New NITROCARE NTCR SD07 Dialysis Chair For Sale", 4417283, NULL, "Poland	", "New")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/hospital-bed/hill-rom/hr-900-hospital-beds-icu-large-quantity-in-stock/4417293", "Used HILL-ROM HR 900 Hospital beds (ICU) - Large quantity in stock! Hospital Bed For Sale", 4417293, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/o-r-table/blanco/bmt-500-1/4441724", "Refurbished BLANCO BMT-500/1 O/R Table For Sale", 4441724, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/o-r-table/maquet/alphaclassic-1118-gynecological-and-urological-operating-table/4463787", "Refurbished MAQUET ALPHACLASSIC 1118 gynecological and urological operating table O/R Table For Sale", 4463787, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/o-r-table/maquet/alphaclassic-1118-operating-table/4485942", "Refurbished MAQUET ALPHACLASSIC 1118 operating table O/R Table For Sale", 4485942, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/continuous-passive-motion-cpm/artromot/k-rehabilitation-splint/4504241", "Used ARTROMOT K Rehabilitation splint Continuous Passive Motion (CPM) For Sale", 4504241, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/smoke-evacuator/buffalo-filter/visiclear-vc220/4504253", "Used BUFFALO FILTER VISICLEAR VC220 Smoke Evacuator For Sale", 4504253, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/physical-therapy-unit/artromot/k4-rehabilitation-rail/4516320", "Refurbished ARTROMOT K4 Rehabilitation rail Physical Therapy Unit For Sale", 4516320, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/exam-chair/arjo-huntleigh/carendo-multifunctional-hygiene-chair/4529881", "Refurbished ARJO HUNTLEIGH CARENDO Multifunctional hygiene chair Exam Chair For Sale", 4529881, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/other/parker/indego-therapy-device/rehabilitation-and-gait-reduction-exoskeleton/4537037", "Used PARKER INDEGO THERAPY DEVICE Rehabilitation and gait reduction exoskeleton  For Sale", 4537037, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/defibrillator/medtronic/biphasic-lifepak-12/4581756", "Used MEDTRONIC Biphasic LIFEPAK 12 Defibrillator For Sale", 4581756, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/bedside-monitor/bionet/bm5/4581911", "Used BIONET BM5 Bedside Monitor For Sale", 4581911, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/defibrillator/medtronic/biphasic-lifepak-12/4582560", "Used MEDTRONIC Biphasic LIFEPAK 12 Defibrillator For Sale", 4582560, NULL, "Poland	", "Used - Excellent")
Visiting this page: https://www.dotmed.com/listings/search/equipment.html?key=wire&offset=105
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/hospital-bed/oostwoud/3800-with-bedside-cabinet/4587085", "Used OOSTWOUD 3800 with bedside cabinet Hospital Bed For Sale", 4587085, NULL, "Poland	", "Used - Excellent")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/monitor/philips/intellivue-mp5/4602910", "Refurbished PHILIPS Intellivue MP5 Monitor For Sale", 4602910, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/exam-table/alvo/sonata-4-03/4602932", "Refurbished ALVO Sonata 4-03 Exam Table For Sale", 4602932, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/cath-lab-monitoring/philips/intellivue-mp30/4603859", "Refurbished PHILIPS INTELLIVUE MP30 Cath Lab Monitoring  For Sale", 4603859, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/exam-table/alvo/sonata-4-03/4603863", "Refurbished ALVO Sonata 4-03 Exam Table For Sale", 4603863, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/refrigerator-freezer/thermo-scientific/forma-ffgl430v19/4605218", "Refurbished THERMO SCIENTIFIC FORMA FFGL430V19 Refrigerator Freezer For Sale", 4605218, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/ent-chair/rockmed/203601/4605254", "Refurbished ROCKMED 203601 ENT Chair For Sale", 4605254, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/exam-table/steris/surgigraphic-6000/4613234", "Refurbished STERIS SURGIGRAPHIC 6000 Exam Table For Sale", 4613234, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/spirometer/vitalograph/alpha/4613247", "Refurbished VITALOGRAPH ALPHA Spirometer For Sale", 4613247, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/icu-ccu/philips/intellivue-mp50/4613766", "Refurbished PHILIPS Intellivue MP50 ICU/CCU For Sale", 4613766, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/exam-table/maquet/alm-5090/4613775", "Refurbished MAQUET ALM 5090 Exam Table For Sale", 4613775, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/exam-table/trumpf/saturn-select-l/4613777", "Refurbished TRUMPF SATURN SELECT L Exam Table For Sale", 4613777, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/exam-chair/schmitz/arco-1146600/4614728", "Refurbished SCHMITZ ARCO 114.6600 Exam Chair For Sale", 4614728, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/water-bath/deltom/wpc-220-bmh-nursing-and-rehabilitation-tub/4614735", "Refurbished DELTOM WPC-220 BMH nursing and rehabilitation tub Water Bath For Sale", 4614735, NULL, "Poland	", "Refurbished")
Visiting this page: https://www.dotmed.com/listings/search/equipment.html?key=wire&offset=120
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/anesthesia-machine/drager/fabius-tiro/4618005", "Refurbished DRAGER FABIUS TIRO Anesthesia Machine For Sale", 4618005, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/cath-lab-monitoring/ge/datex-ohmeda-n-mri2-01/4667470", "Refurbished GE DATEX-OHMEDA N-MRI2-01 Cath Lab Monitoring  For Sale", 4667470, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/endoscopy-processor/olympus/evis-exera-ii-cv-180-video-processor-with-clv-180-light-source/4667472", "Refurbished OLYMPUS EVIS EXERA II CV-180 video-processor with CLV-180 light source Endoscopy Processor For Sale", 4667472, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/exam-chair/stille/sonesta-6300/4670513", "Refurbished STILLE SONESTA 6300 Exam Chair For Sale", 4670513, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/anesthesia-machine/datex-ohmeda/aespire-s5/4679824", "Refurbished DATEX-OHMEDA AESPIRE S5 Anesthesia Machine For Sale", 4679824, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/cath-lab-monitoring/ge/dash-5000/4679825", "Refurbished GE DASH 5000 Cath Lab Monitoring  For Sale", 4679825, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/defibrillator/medtronic/biphasic-lifepak-12/4679838", "Refurbished MEDTRONIC BIPHASIC LIFEPAK 12 Defibrillator For Sale", 4679838, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/defibrillator/medtronic/biphasic-lifepak-12/4679839", "Refurbished MEDTRONIC BIPHASIC LIFEPAK 12 Defibrillator For Sale", 4679839, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/defibrillator/medtronic/biphasic-lifepak-12/4679841", "Refurbished MEDTRONIC BIPHASIC LIFEPAK 12 Defibrillator For Sale", 4679841, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/defibrillator/medtronic/biphasic-lifepak-12/4681427", "Refurbished MEDTRONIC BIPHASIC LIFEPAK 12 Defibrillator For Sale", 4681427, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/audiometer/madsen/medimate-602/4682107", "Refurbished MADSEN MEDIMATE 602 Audiometer For Sale", 4682107, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/defibrillator/medtronic/biphasic-lifepak-12/4682802", "Refurbished MEDTRONIC BIPHASIC LIFEPAK 12 Defibrillator For Sale", 4682802, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/defibrillator/medtronic/biphasic-lifepak-12/4682803", "Refurbished MEDTRONIC BIPHASIC LIFEPAK 12 Defibrillator For Sale", 4682803, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/defibrillator/medtronic/biphasic-lifepak-12/4682806", "Refurbished MEDTRONIC BIPHASIC LIFEPAK 12 Defibrillator For Sale", 4682806, NULL, "Poland	", "Refurbished")
Visiting this page: https://www.dotmed.com/listings/search/equipment.html?key=wire&offset=135
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/audiometer/madsen/midimate-602-clinical-audiometer/4691406", "Refurbished MADSEN MIDIMATE 602 clinical audiometer Audiometer For Sale", 4691406, NULL, "Poland	", "Refurbished")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/cardiac-vascular-ultrasound/boston-scientific/maverick-balloon-catheter/2620276", "New BOSTON SCIENTIFIC Maverick Balloon Catheter Cardiac - Vascular Ultrasound For Sale", 2620276, NULL, "Poland	", "New")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/catheters/boston-scientific/apex-ptca-dilatation-catheter/2620280", "New BOSTON SCIENTIFIC APEX PTCA Dilatation Catheter Catheters For Sale", 2620280, NULL, "Poland	", "New")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/stent/boston-scientific/v-18-v-14-controlwire-guidewire/2620281", "New BOSTON SCIENTIFIC V-18 &amp; V-14 ControlWire Guidewire Stent For Sale", 2620281, NULL, "Poland	", "New")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/cardiac-vascular-ultrasound/boston-scientific/amplatz-super-stiff-guidewire/2620282", "New BOSTON SCIENTIFIC Amplatz Super Stiff Guidewire Cardiac - Vascular Ultrasound For Sale", 2620282, NULL, "Poland	", "New")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/cardiac-vascular-ultrasound/boston-scientific/imager-ii-catheters/2620283", "New BOSTON SCIENTIFIC Imager II Catheters Cardiac - Vascular Ultrasound For Sale", 2620283, NULL, "Poland	", "New")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/cardiac-vascular-ultrasound/medtronic/launcher-coronary-guide-catheter/2634817", "New MEDTRONIC LAUNCHER CORONARY GUIDE CATHETER Cardiac - Vascular Ultrasound For Sale", 2634817, NULL, "Poland	", "New")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/stent/abbott/perclose-proglide-suture-mediated-closure-system/2635233", "Used ABBOTT PERCLOSE PROGLIDE SUTURE-MEDIATED CLOSURE SYSTEM Stent For Sale", 2635233, NULL, "Poland	", "Used - Good")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/catheters/abbott-labs/armada-18-pta-catheter/2635238", "New ABBOTT LABS ARMADA 18 PTA CATHETER Catheters For Sale", 2635238, NULL, "Poland	", "New")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/stent/boston-scientific/promus-element-plus/2814533", "New BOSTON SCIENTIFIC Promus Element Plus Stent For Sale", 2814533, NULL, "Poland	", "New")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/catheters/cordis/vista-brite-tip-guiding-catheter/2867006", "New CORDIS Vista Brite Tip Guiding Catheter Catheters For Sale", 2867006, NULL, "Poland	", "New")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/catheters/abbott-labs/mini-trek/2868478", "New ABBOTT LABS Mini Trek Catheters For Sale", 2868478, NULL, "Poland	", "New")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/stent/medtronic/integrity-bare-metal-stent/2871588", "New MEDTRONIC Integrity Bare Metal Stent Stent For Sale", 2871588, NULL, "Poland	", "New")
Running this query: INSERT INTO listings (url, title, listing_id, price, location, condition) VALUES ("https://www.dotmed.com/listing/arrhythmia/medtronic/arctic-front-advance-pro-cardiac-cryoablation-catheter-afapro28/3682399", "New MEDTRONIC Arctic Front Advance Pro Cardiac Cryoablation Catheter AFAPRO28 Arrhythmia For Sale", 3682399, NULL, "Poland	", "New")
In [6]:
# Remove duplicates from database (if they exist)
DataFrame(DBInterface.execute(julia_dotmed, "DELETE FROM listings WHERE EXISTS (SELECT 1 FROM listings p2 WHERE listings.url = p2.url AND listings.rowid > p2.rowid);"));

# Close database connection
close(julia_dotmed)