Extracting and reformatting data

I have 77 txt files in Hebrew, they are poetry magazines. Each contains several dozens of poems.

I need this information to be organized into a database. I couldn't do it programmatically so it needs to be done manually.

The pattern is easily recognizable

The result needs to be a list of magazines, poems and poets in an sql format:

I think the structure should be like this but I'm open to suggestions

Each Poet needs id, name

Each Magazine needs id, date, name

Each Poem needs id, id of poet as secondary key, id of Magazine as secondary key

I need to be able later on to take the DB and analyze which Poet has poems in which Magazines. Also which Magazine has which poets.

Etc...

Skills: Data Entry, Excel, Data Processing, Copy Typing, Article Writing

About the Client:
( 0 reviews )
Netherlands
Project ID: #34625559

Offer to work on this job now! Bidding closes in 6 days
OPEN - 6 DAYS LEFT
Your bid for this job
 EUR
Your email address

Bid on this job
Set your budget and timeframe
Outline your proposal
Get paid for your work
It's free to sign up and bid on jobs
15 freelancers are bidding on average €471 for this job

revival786
€250 EUR in 7 days
(369 Reviews)
7.6

writingapp
(210 Reviews)
6.6

IdealExpert
€250 EUR in 1 day
(221 Reviews)
6.3

writingvector
€500 EUR in 1 day
(69 Reviews)
5.5

SolutionMart
€250 EUR in 1 day
(125 Reviews)
5.4

HelpingDoor
€250 EUR in 1 day
(113 Reviews)
5.5

WritingLabb
€250 EUR in 1 day
(133 Reviews)
5.7

sgarg161999
€500 EUR in 7 days
(16 Reviews)
4.2

ayesha0124
€750 EUR in 8 days
(1 Review)
1.6

IJay21
€380 EUR in 3 days
(0 Reviews)
0.0

umershahzad
€500 EUR in 7 days
(0 Reviews)
0.0

ahmedtanany14
€500 EUR in 7 days
(0 Reviews)
0.0

seemasingh40404
€1050 EUR in 7 days
(0 Reviews)
0.0

rohith00n
€500 EUR in 7 days
(0 Reviews)
0.0

Aishwarypradhan
€500 EUR in 7 days
(0 Reviews)
0.0
Offer to work on this job now! Bidding closes in 6 days
OPEN - 6 DAYS LEFT
Your bid for this job
 EUR
Your email address

Bid on this job
Set your budget and timeframe
Outline your proposal
Get paid for your work
It's free to sign up and bid on jobs
Post a project like this
< Previous Job
Next Job >
Similar jobs
Create MCQs alone side with Hint on explanation on physics for Jee mains entrance examination (€250-750 EUR)
Data Entry and Typing Expert required for a Computerized credentials Project. ($15-25 AUD / hour)
Virtual assistant and business admin (₹100-400 INR / hour)
Simple work for Indian students - 4 (₹100-400 INR / hour)
Create excel from jpeg files ($12-30 SGD)
Uniqdatasolutions.com looking for a freelancers (€250-750 EUR)
Project For Ankit (₹1500-12500 INR)
Data entry ($250-750 USD)
Data conversation based ($2000-6000 HKD)
I need a 60 question Quiz ($10-30 USD)
Aqeq Literary Foundation ($15-25 USD / hour)
Remote virtual assistant needed ($250-750 USD)
Shopify CSV Product Upload (£1500-3000 GBP)
Need 2 More Content Writers In The Team (6 months) -- 2 ($2-8 USD / hour)
Need assistance on my project (₹750-1250 INR / hour)
Need some astonishing Instragram user (₹750-1250 INR / hour)
PARIVAHAN dashboard data scraping script with Python (₹1500-12500 INR)
SEO Blog Writing for Solar Industry ($1500-3000 USD)
Project for Lovely Thakur Up Morya (₹750-1250 INR / hour)
Writers needed on a weekly basis -- 2 ($15-25 CAD / hour)
Need