title: storing a dataset in a mysql database - 6000 entries
body: <p>i have a set of data that i have gatherd from a <a href="http://europa.eu/youth/volunteering/evs-organisation#open" rel="nofollow noreferrer">public page</a>. Note that are more than 6000 entries. 
  Some of the datasets are more complete than others. In other words, some have more lines of data. </p>
  
  <p>What is aimed: i want to store  the dataset in a mysql database...How to get the first steps to a a viable approach.</p>
  
  <pre><code>  'title' =&gt; 'ZWIAZEK MLODZIEZY MNIEJSZOSCI NIEMIECKIEJ',
              'hand' =&gt; [
                          'Receiving',
                          'Sending',
                          'Coordinating'
                        ],
              'external_url' =&gt; 'http://www.bjdm.eu',
              'topics' =&gt; [
                            'Youth (Participation, Youth Work, Youth Policy)',
                            'Creativity and culture',
                            'Romas and/or other minorities'
                          ],
              'pic_number' =&gt; '939424146',
              'internal_url' =&gt; 'https://europa.eu/youth/volunteering/organisation/939424146_en',
              'location' =&gt; 'Opole, Poland'
            },
            {
              'location' =&gt; 'Czestochowa, Poland',
              'internal_url' =&gt; 'https://europa.eu/youth/volunteering/organisation/947395412_en',
              'hand' =&gt; [
                          'Receiving',
                          'Sending',
                          'Coordinating'
                        ],
              'title' =&gt; 'Zwiazek Mlodziezy Wiejskiej Czestochowa',
              'topics' =&gt; [
                            'Access for disadvantaged',
                            'Creativity and culture',
                            'Early School Leaving / combating failure in education'
                          ],
              'pic_number' =&gt; '947395412',
              'external_url' =&gt; 'http://www.zmwczestochowa.pl'
            },
            {
              'title' =&gt; "ZWIAZEK POLSKICH KAWALER\x{d3}W MALTANSKICH SUWERENNEGO RYCERSKIEGO ZAKONU SZPITALNIK\x{d3}W SWIETEGO JANA JEROZOLIMSKIEGO ZWANEGO RODYJSKIM I MALTANSKIM",
              'hand' =&gt; [
                          'Receiving'
                        ],
              'external_url' =&gt; 'http://www.centrummaltanskie.eu',
              'topics' =&gt; [
                            'Inclusion - equity',
                            'Disabilities - special needs',
                            'Social dialogue'
                          ],
              'pic_number' =&gt; '941314385',
              'internal_url' =&gt; 'https://europa.eu/youth/volunteering/organisation/941314385_en',
              'location' =&gt; "Krak\x{f3}w, Poland"
            },
  </code></pre>
  
  <p>Well - note that are more than 6000 entries .....; 
  some of the datasets are more complete than others : in other words, some have more lines of data. What is aimed: i want to store  the dataset in a mysql database.</p>
  
  <p>How to get the first steps to a a viable approach.</p>
  
  <p>From the data shown at the page that can be seen here <a href="http://europa.eu/youth/volunteering/evs-organisation#open" rel="nofollow noreferrer">http://europa.eu/youth/volunteering/evs-organisation#open</a>
  we will require some db tables. (Inspection of the rest of the data may reveal more): </p>
  
  <p>the page that i have noted above shows a collection of open source projects in Europe: </p>
  
  <p>we can ... : </p>
  
  <ul>
  <li>find organisations which can involve volunteers who need some additional support:</li>
  <li>organisations with additional mentoring or other support suitable for volunteers with obstacles, educational difficulties, cultural differences or similar.</li>
  <li>organisations with a physical environment suitable for volunteers with physical, sensory or other disabilities (such as wheelchair access and similar).</li>
  <li>organisations looking for volunteers who face situations that make their participation in the activities more difficult. </li>
  </ul>
  
  <p>back to the database:  The main tables are Organisation,  hand_type and topic. 
  Because each organisation has multiple occerences of hand and topic, the intermediate tables are required.</p>
  
  <pre><code>+------------------+                                              +------------------+
  | organization     |                                              |  hand_type       |
  +------------------+                                              +------------------+
  | org_id (PK)      |---+-+       +-------------------+     +------| hand_type_id(PK) |
  | title            |   | |       |   org_hand        |     |      | description      |
  | location         |   | |       +-------------------+     |      +------------------+
  | pic_number       |   | |       | org_hand_id (PK)  |     |
  | internal_url     |   | +------&lt;| org_id      (FK)  |     |
  | external_url     |   |         | hand_type_id(FK)  |&gt;----+
  +------------------+   |         +-------------------+
                         |                                          +------------------+
                         |                                          |  topic           |
                         |         +-------------------+            +------------------+
                         |         |  org_topic        |     +------| topic_id (PK)    |
                         |         +-------------------+     |      | description      |
                         |         | org_topic_id (PK) |     |      +------------------+
                         +--------&lt;| org_id       (FK) |     |
                                   | topic_id     (FK) |&gt;----+ 
                                   +-------------------+
  </code></pre>
  
  <p>again see here <a href="http://europa.eu/youth/volunteering/evs-organisation#open" rel="nofollow noreferrer">http://europa.eu/youth/volunteering/evs-organisation#open</a></p>
  
  <p>i guess that we can narrow down the concept a bit... </p>