Ik scrap hotel datasets van bookingdotcom naar sql database

Ik heb al een python script dat alle datasets van booking.com haalt

hier is een lijst van enkele datasets die het in de database plaatst;

hotels tabel

1. hotel_type
2. hotel_name
3. no_of_stars
4. address
5. description
6. url
7. pool
8. airport_shuttle
9. spa_wellness_centre
10. fitness_centre
11. family_rooms
12. facilities_for_disabled_guests
13. parking
14. free_parking
15. pets_allowed
16. room_service
17. free_wifi
18. tea_coffee_maker_in_all_rooms
19. restaurant
20. bar
21. breakfast
22. breakfast_rating
23. breakfast_number_of_reviews
24. garden
25. wifi_all_areas
26. all_facilities

Hotel ratings tabel

1. overall
2. cleanliness
3. comfort
4. facilities
5. free_wifi
6. location
7. value_for_money
8. number_of_reviews

kamers tabel

1. room_name
2. room_size
3. air_conditioning
4. coffee_machine
5. free_wifi
6. minibar
7. soundproofing
8. tv
9. balcony
10. private_room
11. private_suite
12. dormitory
13. shared_dormitory
14. bath
15. private_bathroom
16. ensuite_bathroom
17. shared_bathroom
18. beds_single
19. beds_double
20. beds_large_double
21. beds_extra_large_double
22. beds_sofa
23. beds_bunk
24. additional_important
25. further_facilities

hotel aanbiedingen tabel

1. checkin
2. checkout
3. price
4. sleeps
5. breakfast_included
6. breakfast_optional
7. breakfast_text
8. meals
9. free_cancellation_until
10. free_cancellation_text
11. prepayment
12. prepayment_text

Laat me weten of je meer nodig hebt