-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathinit.sql
532 lines (516 loc) · 31.7 KB
/
init.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
/*
This database is intended to be an exercise to create a well-formed, easily
queried database of interesting details related to the reality show The Amazing
Race. Once complete the data should be complete through Season 36.
Data has been drawn from the show's Wiki (https://amazingrace.fandom.com/wiki/The_Amazing_Race_(US))
as well as its general Wikipedia page (https://en.wikipedia.org/wiki/The_Amazing_Race_(American_TV_series))
Author: Daniel Kolkena
*/
/* Create the database */
CREATE DATABASE IF NOT EXISTS tar;
/* Switch to the tar database */
USE tar;
/* Drop existing tables */
DROP TABLE IF EXISTS Challenges;
DROP TABLE IF EXISTS Contestants;
DROP TABLE IF EXISTS Episodes;
DROP TABLE IF EXISTS Seasons;
DROP TABLE IF EXISTS Countries;
/* Create the tables */
CREATE TABLE Seasons (
ID int AUTO_INCREMENT,
year_broadcast year,
details varchar(255),
PRIMARY KEY (ID)
);
CREATE TABLE Countries (
country varchar(255),
continent varchar(255),
-- language varchar(255),
PRIMARY KEY (country)
);
CREATE TABLE Contestants (
ID int AUTO_INCREMENT,
fullname varchar(255),
age int,
team_title varchar(255),
hometown varchar(255),
season int NOT NULL,
languages varchar(255),
details varchar(255),
PRIMARY KEY (ID),
FOREIGN KEY (season) REFERENCES Seasons(ID)
);
CREATE TABLE Episodes (
ID int NOT NULL,
season int,
season_episode int,
episode_name varchar(255),
elimination tinyint(1),
PRIMARY KEY (ID),
FOREIGN KEY (season) REFERENCES Seasons(ID)
);
CREATE TABLE Challenges (
ID int AUTO_INCREMENT,
country varchar(255),
episode_id int,
challenge_type enum ('Task', 'Roadblock', 'Detour', 'Express Pass', 'Yield', 'Fast Forward', 'U-Turn', 'Speed Bump'),
challenge_name varchar(255),
category varchar(255),
PRIMARY KEY (ID),
FOREIGN KEY (episode_id) REFERENCES Episodes(ID),
FOREIGN KEY (country) REFERENCES Countries(country)
);
/*
TODO:
Refining schema some more
Think about what data to include
Continue to add data
*/
/* Inserting data */
INSERT INTO Seasons (year_broadcast, details) VALUES
('2001',''),('2002',''),('2002',''),('2003',''),('2004',''),('2004',''),('2005',''),('2005','Family Edition'),('2006',''),('2006',''),('2007','All-Stars (2007)'),('2007',''),('2008',''),('2009',''),('2009',''),('2010',''),('2010',''),('2011','Unfinished Business'),('2011',''),('2012',''),('2012',''),('2013',''),('2013',''),('2014','All-Stars (2014)'),('2014',''),('2015',''),('2015',''),('2016',''),('2017',''),('2018',''),('2019',''),('2020',''),('2022',''),('2022',''),('2023',''),('2024','');
INSERT INTO Countries (country, continent) VALUES
('Botswana','Africa'),
('Burkina Faso','Africa'),
('Egypt','Africa'),
('Ethiopia','Africa'),
('Ghana','Africa'),
('Kenya','Africa'),
('Madagascar','Africa'),
('Malawi','Africa'),
('Mauritius','Africa'),
('Morocco','Africa'),
('Mozambique','Africa'),
('Namibia','Africa'),
('Senegal','Africa'),
('Seychelles','Africa'),
('South Africa','Africa'),
('Tanzania','Africa'),
('Tunisia','Africa'),
('Uganda','Africa'),
('Zambia','Africa'),
('Zimbabwe','Africa');
INSERT INTO Countries (country, continent) VALUES
('Armenia','Asia'),
('Azerbaijan','Asia'),
('Bahrain','Asia'),
('Bangladesh','Asia'),
('Cambodia','Asia'),
('China','Asia'),
('Georgia','Asia'),
('India','Asia'),
('Indonesia','Asia'),
('Japan','Asia'),
('Jordan','Asia'),
('Kazakhstan','Asia'),
('Kuwait','Asia'),
('Laos','Asia'),
('Malaysia','Asia'),
('Mongolia','Asia'),
('Oman','Asia'),
('Philippines','Asia'),
('Singapore','Asia'),
('South Korea','Asia'),
('Sri Lanka','Asia'),
('Taiwan','Asia'),
('Thailand','Asia'),
('Turkey','Asia'),
('United Arab Emirates','Asia'),
('Vietnam','Asia'),
('Hong Kong','Asia'),
('Macau','Asia');
INSERT INTO Countries (country, continent) VALUES
('Austria','Europe'),
('Belgium','Europe'),
('Croatia','Europe'),
('Czech Republic','Europe'),
('Denmark','Europe'),
('Estonia','Europe'),
('Finland','Europe'),
('France','Europe'),
('Germany','Europe'),
('Greece','Europe'),
('Hungary','Europe'),
('Iceland','Europe'),
('Ireland','Europe'),
('Italy','Europe'),
('Liechtenstein','Europe'),
('Lithuania','Europe'),
('Malta','Europe'),
('Monaco','Europe'),
('Netherlands','Europe'),
('Norway','Europe'),
('Poland','Europe'),
('Portugal','Europe'),
('Romania','Europe'),
('Russia','Europe'),
('Slovenia','Europe'),
('Spain','Europe'),
('Sweden','Europe'),
('Switzerland','Europe'),
('Ukraine','Europe'),
('United Kingdom','Europe');
INSERT INTO Countries (country, continent) VALUES
('Barbados','North America'),
('Costa Rica','North America'),
('Dominican Republic','North America'),
('Jamaica','North America'),
('Mexico','North America'),
('Panama','North America'),
('Trinidad and Tobago','North America'),
('United States','North America'),
('Puerto Rico','North America'),
('U.S. Virgin Islands','North America');
INSERT INTO Countries (country, continent) VALUES
('Australia','Oceania'),
('New Zealand','Oceania'),
('French Polynesia','Oceania'),
('Guam','Oceania');
INSERT INTO Countries (country, continent) VALUES
('Argentina','South America'),
('Brazil','South America'),
('Bolivia','South America'),
('Chile','South America'),
('Colombia','South America'),
('Ecuador','South America'),
('Paraguay','South America'),
('Peru','South America'),
('Uruguay','South America');
INSERT INTO Contestants (fullname, age, team_title, hometown, season, languages, details) VALUES
('Lisa Thomson', '28', 'Realtor Sisters', 'Miami, Florida', '25', '', ''),
('Michelle Thomson', '22', 'Realtor Sisters', 'Miami, Florida', '25', '', ''),
('Dennis Hour', '30', 'Newly Dating', 'Tustin, California', '25', '', ''),
('Isabelle Du', '28', 'Newly Dating', 'Tustin, California', '25', '', ''),
('Michael Ward', '40', 'Firefighters', 'Boston, Massachusetts', '25', '', ''),
('Scott Strazzullo', '39', 'Firefighters', 'Boston, Massachusetts', '25', '', ''),
('Keith Tollefson', '29', 'Engaged', 'Nashville, Tennessee', '25', '', ''),
('Whitney Duncan', '29', 'Engaged', 'Nashville, Tennessee', '25', '', ''),
('Shelley Porter', '42', 'Mother & Daughter', 'Detroit, Michigan', '25', '', ''),
('Nici Porter', '24', 'Mother & Daughter', 'Detroit, Michigan', '25', '', ''),
('Tim Tsao', '23', 'College Sweethearts', 'Pasadena, California', '25', '', ''),
('Te Jay McGrath', '24', 'College Sweethearts', 'Pasadena, California', '25', '', ''),
('Kym Perfetto', '30', 'Urban Bike Racers', 'Brooklyn, New York', '25', '', ''),
('Alli Forsythe', '26', 'Urban Bike Racers', 'Brooklyn, New York', '25', '', ''),
('Brooke Adams', '29', 'Dating Pro Wrestlers', 'Houston, Texas', '25', '', ''),
('Robbie Strauss', '30', 'Dating Pro Wrestlers', 'Woodbridge, New Jersey', '25', '', ''),
('Adam Dirks', '26', 'Married Surfers', 'Princeville, Hawaii', '25', '', ''),
('Bethany Hamilton', '24', 'Married Surfers', 'Princeville, Hawaii', '25', '', ''),
('Misti Raman', '36', 'Married Dentists', 'Columbia, South Carolina', '25', '', ''),
('Jim Raman', '37', 'Married Dentists', 'Columbia, South Carolina', '25', '', ''),
('Amy DeJong', '24', 'Food Scientists', 'Madison, Wisconsin', '25', '', ''),
('Maya Warren', '29', 'Food Scientists', 'Madison, Wisconsin', '25', '', ''),
('Jeff Magee', '57', 'Flight Crew', 'McCall, Idaho', '26', '', ''),
('Lyda Grawn', '49', 'Flight Crew', 'Scottsdale, Arizona', '26', '', ''),
('Libby Simpson', '25', 'Team Tuskegee', 'Tuskegee, Alabama', '26', '', ''),
('C.J. Harris', '26', 'Team Tuskegee', 'Tuskegee, Alabama', '26', '', ''),
('Harley Rodriguez', '41', 'Team New Kid', 'New York City, New York', '26', '', ''),
('Jonathan Knight', '46', 'Team New Kid', 'New York City, New York', '26', '', ''),
('Bergen Olsen', '23', 'The Blonde Date', 'Sunnyvale, California', '26', '', ''),
('Kurt Belcher', '24', 'The Blonde Date', 'Butler, New York', '26', '', ''),
('Jeff Weldon', '26', 'Team JJ', 'Tampa, Florida', '26', '', ''),
('Jackie Ibarra', '27', 'Team JJ', 'Las Vegas, Nevada', '26', '', ''),
('Aly Dudek', '24', 'Sochi Love', 'Milwaukee, Wisconsin', '26', '', ''),
('Steve Langton', '31', 'Sochi Love', 'Boston, Massachusetts', '26', '', ''),
('Matt Cucolo', '30', 'The Hairstylists', 'Scarsdale, New York', '26', '', ''),
('Ashley Gordon', '28', 'The Hairstylists', 'Scarsdale, New York', '26', '', ''),
('Mike Dombrowski', '26', 'Truck Stop Love', 'Traverse City, Michigan', '26', '', ''),
('Rochelle Nevedal', '29', 'Truck Stop Love', 'Kalkaska, Michigan', '26', '', ''),
('Hayley Keel', '28', 'Rx for Love', 'Saint Petersburg, Florida', '26', '', ''),
('Blair Townsend', '31', 'Rx for Love', 'Amelia Island, Florida', '26', '', ''),
('Jelani Roy', '32', 'The Legal Team', 'New York City, New York', '26', '', ''),
('Jenny Wu', '32', 'The Legal Team', 'Los Angeles, California', '26', '', ''),
('Laura Pierson', '29', 'Team SoCal', 'Los Angeles, California', '26', '', ''),
('Tyler Adams', '26', 'Team SoCal', 'Santa Monica, California', '26', '', ''),
('Kelly Berning', '37', 'Co-Workers', 'Los Angeles, California', '27', '', ''),
('Shevonne Sullivan', '31', 'Co-Workers', 'Los Angeles, California', '27', '', ''),
('Alex Manard', '22', 'Cousins', 'Champaign, Illinois', '27', '', ''),
('Adam Dingeman', '24', 'Cousins', 'Des Moines, Iowa', '27', '', ''),
('Ernest Phillips', '29', 'Brothers', 'Boston, Massachusetts', '27', '', ''),
('Jin Lao Greer', '26', 'Brothers', 'Boston, Massachusetts', '27', '', ''),
('Jazmine Lewis', '23', 'Best Friends & Athletes', 'Los Angeles, California', '27', '', ''),
('Danielle Littleton', '22', 'Best Friends & Athletes', 'Los Angeles, California', '27', '', ''),
('Cindy Chac', '36', 'Newlyweds', 'San Diego, California', '27', '', ''),
('Rick Chac', '38', 'Newlyweds', 'San Diego, California', '27', '', ''),
('Tanner Kloven', '26', 'Best Friends', 'Dallas, Texas', '27', '', ''),
('Josh Ahern', '28', 'Best Friends', 'Dallas, Texas', '27', '', ''),
('Denise Williams', '51', 'Mother & Son', 'Prattville, Alabama', '27', '', ''),
('James Earl Corley', '26', 'Mother & Son', 'Prattville, Alabama', '27', '', ''),
('Tiffany Torres', '28', 'Former NFL Cheerleaders', 'Hoboken, New Jersey', '27', '', ''),
('Krista DeBono', '28', 'Former NFL Cheerleaders', 'Staten Island, New York', '27', '', ''),
('Logan Fazio', '36', 'Dating Paparazzi', 'Miami Beach, Florida', '27', '', ''),
('Chris Gordon', '46', 'Dating Paparazzi', 'Miami Beach, Florida', '27', '', ''),
('Justin Scheman', '39', 'Engaged', 'Philadelphia, Pennsylvania', '27', '', ''),
('Diana Bishop', '30', 'Engaged', 'Philadelphia, Pennsylvania', '27', '', ''),
('Kelsey Gerckens', '25', 'Dating News Anchors', 'Santa Barbara, California', '27', '', ''),
('Joey Buttitta', '26', 'Dating News Anchors', 'Santa Barbara, California', '27', '', ''),
('Marty Cobb', '51', 'Mother & Daughter', 'McKinney, Texas', '28', '', ''),
('Hagan Parkman', '22', 'Mother & Daughter', 'McKinney, Texas', '28', '', ''),
('Darius Benson', '22', 'Brothers', 'Tuscaloosa, Alabama', '28', '', ''),
('Cameron Benson', '19', 'Brothers', 'Memphis, Tennessee', '28', '', ''),
('Brittany Oldehoff', '26', 'Instagram Models', 'Fort Lauderdale, Florida', '28', '', ''),
('Jessica Versteeg', '28', 'Instagram Models', 'San Francisco, California', '28', '', ''),
('Erin White Robinson', '31', 'Best Friends', 'Los Angeles, California', '28', '', ''),
('Joslyn Davis', '33', 'Best Friends', 'Los Angeles, California', '28', '', ''),
('Scott Fowler', '58', 'Father & Daughter', 'Kingsport, Tennessee', '28', '', ''),
('Blair Fowler', '22', 'Father & Daughter', 'San Diego, California', '28', '', ''),
('Zach King', '25', 'Newlyweds', 'Los Angeles, California', '28', '', ''),
('Rachel King', '25', 'Newlyweds', 'Los Angeles, California', '28', '', ''),
('Brodie Smith', '28', 'Pro Ultimate Players', 'Dallas, Texas', '28', '', ''),
('Kurt Gibson', '30', 'Pro Ultimate Players', 'Dallas, Texas', '28', '', ''),
('Burnie Burns', '42', 'Dating Gamers', 'Austin, Texas', '28', '', ''),
('Ashley Jenkins', '33', 'Dating Gamers', 'Austin, Texas', '28', '', ''),
('Tyler Oakley', '26', 'Best Friends', 'Jackson, Michigan', '28', '', ''),
('Korey Kuhl', '30', 'Best Friends', 'Jackson, Michigan', '28', '', ''),
('Sheri LaBrant', '45', 'Mother & Son', 'Enterprise, Alabama', '28', '', ''),
('Cole LaBrant', '19', 'Mother & Son', 'Enterprise, Alabama', '28', '', ''),
('Dana Borriello', '29', 'Engaged Choreographers', 'Los Angeles, California', '28', '', ''),
('Matt Steffanina', '30', 'Engaged Choreographers', 'Los Angeles, California', '28', '', ''),
('Kevin Ng', '31', 'Long Hair, Don''t Care', 'San Diego, California', '29', '', ''),
('Jenn Lee', '25', 'Long Hair, Don''t Care', 'Palos Verdes, California', '29', '', ''),
('Jessie Shields', '28', 'Swole Sisters', 'Howland, Ohio', '29', '', ''),
('Francesca Piccoli', '33', 'Swole Sisters', 'Banning, California', '29', '', ''),
('Seth Tyler', '37', 'Team America', 'Seattle, Washington', '29', '', ''),
('Olive Beauregard', '24', 'Team America', 'Providence, Rhode Island', '29', '', ''),
('Shamir Arzeno', '28', 'The S and S Express', 'Bronx, New York', '29', '', ''),
('Sara Fowler', '27', 'The S and S Express', 'Baltimore, Maryland', '29', '', ''),
('Vanck Zhu', '28', 'Team Vanck & Ashton', 'Saint Paul, Minnesota', '29', '', ''),
('Ashton Theiss', '25', 'Team Vanck & Ashton', 'Fort Worth, Texas', '29', '', ''),
('Liz Espey', '24', 'Team Liz & Mike', 'Maryville, Missouri', '29', '', ''),
('Michael Rado', '37', 'Team Liz & Mike', 'Pittsburgh, Pennsylvania', '29', '', ''),
('Becca Droz', '26', 'Team Fun', 'Pittsburgh, Pennsylvania', '29', '', ''),
('Floyd Pierce', '21', 'Team Fun', 'Highlands Ranch, Colorado', '29', '', ''),
('Matt Ladley', '25', 'The Boys', 'Steamboat Springs, Colorado', '29', '', ''),
('Redmond Ramos', '28', 'The Boys', 'Fremont, California', '29', '', ''),
('London Kaye', '27', 'Team LoLo', 'New York City, New York', '29', '', ''),
('Logan Bauer', '27', 'Team LoLo', 'Navarre, Florida', '29', '', ''),
('Tara Carr', '38', 'Team Mom and Dad', 'Alexandria, Virginia', '29', '', ''),
('Joey Covino', '46', 'Team Mom and Dad', 'Boston, Massachusetts', '29', '', ''),
('Brooke Camhi', '36', 'Team Brooke & Scott', 'Lynbrook, New York', '29', '', ''),
('Scott Flanary', '34', 'Team Brooke & Scott', 'Charlotte, North Carolina', '29', '', ''),
('Dessie Mitcheson', '27', 'Models', 'Apollo, Pennsylvania', '30', '', ''),
('Kayla Fitzgerald', '26', 'Models', 'Clermont, Florida', '30', '', ''),
('April Gould', '39', 'Goat Yoga Moms', 'Gilbert, Arizona', '30', '', ''),
('Sarah Williams', '39', 'Goat Yoga Moms', 'Mesa, Arizona', '30', '', ''),
('Cedric Ceballos', '48', 'Former NBA Players', 'Maui, Hawaii', '30', '', ''),
('Shawn Marion', '39', 'Former NBA Players', 'Chicago, Illinois', '30', '', ''),
('Joey Chestnut', '33', 'Competitive Eaters', 'San Jose, California', '30', '', ''),
('Tim Janus', '41', 'Competitive Eaters', 'New York City, New York', '30', '', ''),
('Trevor Wadleigh', '31', 'Dating Violinists', 'New York City, New York', '30', '', ''),
('Chris Marchant', '33', 'Dating Violinists', 'New York City, New York', '30', '', ''),
('Eric Guiffreda', '33', 'Twins', 'Ponchatoula, Louisiana', '30', '', ''),
('Daniel Guiffreda', '33', 'Twins', 'Ponchatoula, Louisiana', '30', '', ''),
('Lucas Bocanegra', '35', 'Dating→Engaged Lifeguards', 'Miami Springs, Florida', '30', '', ''),
('Brittany Austin', '31', 'Dating→Engaged Lifeguards', 'Miami Springs, Florida', '30', '', ''),
('Alex Rossi', '26', 'IndyCar Drivers', 'Nevada City, California', '30', '', ''),
('Conor Daly', '25', 'IndyCar Drivers', 'Noblesville, Indiana', '30', '', ''),
('Kristi Leskinen', '36', 'Professional Skiers', 'Scottsdale, Arizona', '30', '', ''),
('Jen Hudak', '30', 'Professional Skiers', 'Park City, Utah', '30', '', ''),
('Henry Zhang', '22', 'Dating Debaters', 'Los Angeles, California', '30', '', ''),
('Evan Lynyak', '22', 'Dating Debaters', 'Los Angeles, California', '30', '', ''),
('Cody Nickson', '33', 'Dating Reality Stars', 'Plano, Texas', '30', '', ''),
('Jessica Graf', '28', 'Dating Reality Stars', 'Los Angeles, California', '30', '', ''),
('Art Velez', '49', 'Best Friends', 'Temecula, California', '31', '', ''),
('J.J. Carrell', '49', 'Best Friends', 'San Marcos, California', '31', '', ''),
('Rupert Boneham', '54', 'Married', 'Indianapolis, Indiana', '31', '', ''),
('Laura Boneham', '49', 'Married', 'Indianapolis, Indiana', '31', '', ''),
('Corinne Kaplan', '39', 'Friends', 'Denver, Colorado', '31', '', ''),
('Eliza Orlins', '35', 'Friends', 'New York City, New York', '31', '', ''),
('Janelle Pierzina', '38', 'Friends', 'Lakeville, Minnesota', '31', '', ''),
('Britney Haynes', '30', 'Friends', 'Tulsa, Oklahoma', '31', '', ''),
('Rachel Reilly', '33', 'Sisters', 'Van Nuys, California', '31', '', ''),
('Elissa Slater', '32', 'Sisters', 'Las Vegas, Nevada', '31', '', ''),
('Chris Hammons', '40', 'Friends', 'Moore, Oklahoma', '31', '', ''),
('Bret LaBelle', '44', 'Friends', 'Dedham, Massachusetts', '31', '', ''),
('Becca Droz', '28', 'Friends', 'Boulder, Colorado', '31', '', ''),
('Floyd Pierce', '23', 'Friends', 'Highlands Ranch, Colorado', '31', '', ''),
('Nicole Franzel', '25', 'Dating', 'Ubly, Michigan', '31', '', ''),
('Victor Arroyo', '27', 'Dating', 'Slidell, Louisiana', '31', '', ''),
('Leo Temory', '31', 'Cousins', 'Pasadena, California', '31', '', ''),
('Jamal Zadran', '31', 'Cousins', 'Houston, Texas', '31', '', ''),
('Tyler Oakley', '29', 'Best Friends', 'Jackson, Michigan', '31', '', ''),
('Korey Kuhl', '33', 'Best Friends', 'Jackson, Michigan', '31', '', ''),
('Colin Guinn', '38', 'Life Partners', 'Austin, Texas', '31', '', ''),
('Christie Woods', '40', 'Life Partners', 'Austin, Texas', '31', '', ''),
('Nathan Worthington', '39', 'Best Friends', 'Dayton, Tennessee', '32', '', ''),
('Cody Buell', '33', 'Best Friends', 'Paint Lick, Kentucky', '32', '', ''),
('Kellie Wells-Brinkley', '37', 'Former Olympic Hurdlers', 'Richmond, Virginia', '32', '', ''),
('LaVonne Idlette', '34', 'Former Olympic Hurdlers', 'Hampton, Virginia', '32', '', ''),
('Jerry Eaves', '61', 'Father & Son', 'Louisville, Kentucky', '32', '', ''),
('Frank Eaves', '25', 'Father & Son', 'Louisville, Kentucky', '32', '', ''),
('Michelle Newland', '34', 'Sisters', 'Lafayette, Louisiana', '32', '', ''),
('Victoria Newland', '33', 'Sisters', 'Lafayette, Louisiana', '32', '', ''),
('Leo Brown', '31', 'Dating', 'Somerville, Massachusetts', '32', '', ''),
('Alana Folsom', '29', 'Dating', 'Somerville, Massachusetts', '32', '', ''),
('Kaylynn Williams', '30', 'Sisters', 'Bluffton, South Carolina', '32', '', ''),
('Haley Williams', '31', 'Sisters', 'Bluffton, South Carolina', '32', '', ''),
('Eswar Dhinakaran', '24', 'Siblings', 'Fremont, California ', '32', '', ''),
('Aparna Dhinakaran', '26', 'Siblings', 'Berkeley, California', '32', '', ''),
('DeAngelo Williams', '36', 'Former NFL Stars', 'Charlotte, North Carolina', '32', '', ''),
('Gary Barnidge', '34', 'Former NFL Stars', 'Middleburg, Florida', '32', '', ''),
('Riley McKibbin', '31', 'Pro Volleyball Brothers', 'Honolulu, Hawaii', '32', '', ''),
('Maddison McKibbin', '29', 'Pro Volleyball Brothers', 'Honolulu, Hawaii', '32', '', ''),
('Hung Nguyen', '39', 'Married Parents', 'Houston, Texas', '32', '', ''),
('Chee Lee', '38', 'Married Parents', 'Houston, Texas', '32', '', ''),
('Will Jardell', '30', 'Boyfriends', 'Nederland, Texas', '32', '', ''),
('James Wallington', '31', 'Boyfriends', 'Grand Rapids, Michigan', '32', '', ''),
('Taylor Green-Jones', '38', 'Married', 'Fort Worth, Texas', '33', '', ''),
('Isaiah Green-Jones', '31', 'Married', 'Portland, Oregon', '33', '', ''),
('Caro Viehweg', '23', 'Dating', 'Los Angeles, California', '33', '', ''),
('Ray Gantt', '25', 'Dating', 'Lakewood, New Jersey', '33', '', ''),
('Connie Greiner', '37', 'Married', 'Newport News, Virginia', '33', '', ''),
('Sam Greiner', '39', 'Married', 'Charlotte, North Carolina', '33', '', ''),
('Anthony Sadler', '29', 'Childhood Friends', 'Sacramento, California', '33', '', ''),
('Spencer Stone', '29', 'Childhood Friends', 'Sacramento, California', '33', '', ''),
('Michael Norwood', '36', 'Singing Police Officers', 'Buffalo, New York', '33', '', ''),
('Moe Badger', '42', 'Singing Police Officers', 'Buffalo, New York', '33', '', ''),
('Akbar Cook Sr.', '45', 'Married Educators', 'Newark, New Jersey', '33', '', ''),
('Sheri Cook', '44', 'Married Educators', 'Havana, Florida', '33', '', ''),
('Lulu Gonzalez', '37', 'Twins & Radio Hosts', 'North Bergen, New Jersey', '33', '', ''),
('Lala Gonzalez', '37', 'Twins & Radio Hosts', 'North Bergen, New Jersey', '33', '', ''),
('Arun Kumar', '56', 'Father & Daughter', 'Detroit, Michigan', '33', '', ''),
('Natalia Kumar', '28', 'Father & Daughter', 'Detroit, Michigan', '33', '', ''),
('Ryan Ferguson', '37', 'Best Friends', 'Manhattan, New York', '33', '', ''),
('Dusty Harris', '38', 'Best Friends', 'Columbia, Missouri', '33', '', ''),
('Raquel Moore', '31', 'Flight Attendants', 'Chicago, Illinois', '33', '', ''),
('Cayla Platt', '30', 'Flight Attendants', 'Gulf Breeze, Florida', '33', '', ''),
('Kim Holderness', '45', 'Married', 'Sarasota, Florida', '33', '', ''),
('Penn Holderness', '47', 'Married', 'Durham, North Carolina', '33', '', ''),
('Aastha Lal', '33', 'Engaged', 'Marina del Rey, California', '34', '', ''),
('Nina Duong', '34', 'Engaged', 'Marina del Rey, California', '34', '', ''),
('Tim Mann', '40', 'Golf Buddies', 'Brentwood, Tennessee', '34', '', ''),
('Rex Ryan', '59', 'Golf Buddies', 'Brentwood, Tennessee', '34', '', ''),
('Rich Kuo', '32', 'Motivational Speakers', 'Huntington Beach, California', '34', '', ''),
('Dom Jones', '35', 'Motivational Speakers', 'Huntington Beach, California', '34', '', ''),
('Linton Atkinson', '50', 'Father & Daughter', 'Brooklyn, New York', '34', '', ''),
('Sharik Atkinson', '23', 'Father & Daughter', 'Brooklyn, New York', '34', '', ''),
('Abby Garrett', '24', 'Childhood Sweethearts', 'Birmingham, Alabama', '34', '', ''),
('Will Freeman', '25', 'Childhood Sweethearts', 'Birmingham, Alabama', '34', '', ''),
('Glenda Roberts', '41', 'Newlyweds', 'Norcross, Georgia', '34', '', ''),
('Lumumba Roberts', '41', 'Newlyweds', 'Norcross, Georgia', '34', '', ''),
('Quinton Peron', '29', 'Former Rams Cheerleaders', 'Pasadena, California', '34', '', ''),
('Mattie Lynch', '27', 'Former Rams Cheerleaders', 'Vista, California', '34', '', ''),
('Marcus Craig', '38', 'Military Brothers', 'Richmond Hill, Georgia', '34', '', ''),
('Michael Craig', '30', 'Military Brothers', 'Alamogordo, New Mexico', '34', '', ''),
('Aubrey Ares', '29', 'Ballroom Dancers', 'Los Angeles, California', '34', '', ''),
('David Hernandez', '29', 'Ballroom Dancers', 'Los Angeles, California', '34', '', ''),
('Luis Colon', '34', 'Married', 'Miami, Florida', '34', '', ''),
('Michelle Burgos', '34', 'Married', 'Miami, Florida', '34', '', ''),
('Emily Bushnell', '36', 'Long-Lost Twins', 'Ardmore, Pennsylvania', '34', '', ''),
('Molly Sinert', '36', 'Long-Lost Twins', 'Palm Beach Gardens, Florida', '34', '', ''),
('Derek Xiao', '25', 'Reality Romance', 'Los Angeles, California', '34', '', ''),
('Claire Rehfuss', '26', 'Reality Romance', 'Los Angeles, California', '34', '', ''),
('Alexandra Lichtor', '34', 'Siblings & Roommates', 'Chicago, Illinois', '35', '', ''),
('Sheridan Lichtor', '29', 'Siblings & Roommates', 'Chicago, Illinois', '35', '', ''),
('Elizabeth Rivera', '52', 'Mother & Daughter', 'Tampa, Florida', '35', '', ''),
('Iliana Rivera', '27', 'Mother & Daughter', 'Tampa, Florida', '35', '', ''),
('Jocelyn Chao', '49', 'Married Entrepreneurs', 'Albuquerque, New Mexico', '35', '', ''),
('Victor Limary', '49', 'Married Entrepreneurs', 'Albuquerque, New Mexico', '35', '', ''),
('Joe Moskowitz', '35', 'Engaged', 'New York City, New York', '35', '', ''),
('Ian Todd', '40', 'Engaged', 'New York City, New York', '35', '', ''),
('Liam Hykel', '23', 'Brothers', 'Cheyenne, Wyoming', '35', '', ''),
('Yeremi Hykel', '24', 'Brothers', 'San Marcos, Texas', '35', '', ''),
('Andrea Simpson', '44', 'College Friends', 'Philadelphia, Pennsylvania ', '35', '', ''),
('Malaina Hatcher', '45', 'College Friends', 'Philadelphia, Pennsylvania', '35', '', ''),
('Morgan Franklin', '31', 'Sisters', 'Brooklyn, New York', '35', '', ''),
('Lena Franklin', '29', 'Sisters', 'Los Angeles, California', '35', '', ''),
('Robbin Tomich', '41', 'Childhood Friends', 'Kirkland, Washington', '35', '', ''),
('Chelsea Day', '41', 'Childhood Friends', 'Shoreline, Washington', '35', '', ''),
('Todd Martin', '38', 'Married High School Sweethearts', 'Chino, California', '35', '', ''),
('Ashlie Martin', '38', 'Married High School Sweethearts', 'Chino, California', '35', '', ''),
('Steve Cargile', '54', 'Father & Daughter', 'Petty, Texas', '35', '', ''),
('Anna Leigh Wilson', '28', 'Father & Daughter', 'Royse City, Texas', '35', '', ''),
('Rob McArthur', '48', 'Father & Son', 'Riverside, California', '35', '', ''),
('Corey McArthur', '25', 'Father & Son', 'New York City, New York', '35', '', ''),
('Joel Strasser', '42', 'Best Friends', 'Kuna, Idaho', '35', '', ''),
('Garrett Smith', '43', 'Best Friends', 'Meridian, Idaho', '35', '', ''),
('Greg Franklin', '25', 'Brothers & Computer Scientists', 'New York City, New York', '35', '', ''),
('John Franklin', '27', 'Brothers & Computer Scientists', 'Mountain View, California', '35', '', ''),
('Maya Mody', '20', 'Siblings', 'Monmouth Junction, New Jersey', '36', '', ''),
('Rohan Mody', '23', 'Siblings', 'Monmouth Junction, New Jersey', '36', '', ''),
('Chris Foster', '60', 'Father & Daughter', 'Waltham, Massachusetts', '36', '', ''),
('Mary Cardona-Foster', '27', 'Father & Daughter', 'Waltham, Massachusetts', '36', '', ''),
('Anthony Smith', '26', 'Twins', 'Clearwater, Florida', '36', '', ''),
('Bailey Smith', '26', 'Twins', 'Clearwater, Florida', '36', '', ''),
('Michelle Clark', '39', 'Married Aerobics Instructors', 'East Point, Georgia', '36', '', ''),
('Sean Clark', '46', 'Married Aerobics Instructors', 'East Point, Georgia', '36', '', ''),
('Kishori Turner', '26', 'Cousins', 'Gaithersburg, Maryland', '36', '', ''),
('Karishma Cordero', '22', 'Cousins', 'Austin, Texas', '36', '', ''),
('Derek Williams', '57', 'Grandparents', 'Alta Loma, California', '36', '', ''),
('Shelisa Williams', '55', 'Grandparents', 'Alta Loma, California', '36', '', ''),
('Sunny Pulver', '41', 'Firefighter Moms', 'Edgerton, Wisconsin', '36', '', ''),
('Bizzy Smith', '37', 'Firefighter Moms', 'New Berlin, Wisconsin', '36', '', ''),
('Angie Butler', '55', 'Mother & Son', 'Walla Walla, Washington', '36', '', ''),
('Danny Butler', '27', 'Mother & Son', 'San Diego, California', '36', '', ''),
('Yvonne Chavez', '40', 'Girlfriends', 'San Diego, California', '36', '', ''),
('Melissa Main', '38', 'Girlfriends', 'San Diego, California', '36', '', ''),
('Amber Craven', '30', 'Dating Nurses', 'Englewood, Colorado', '36', '', ''),
('Vinny Cagungun', '37', 'Dating Nurses', 'Englewood, Colorado', '36', '', ''),
('Rod Gardner', '46', 'Married', 'Lawrenceville, Georgia', '36', '', ''),
('Leticia Gardner', '38', 'Married', 'Lawrenceville, Georgia', '36', '', ''),
('Juan Villa', '29', 'Military Pilots', 'Spokane, Washington', '36', '', ''),
('Shane Bilek', '29', 'Military Pilots', 'Marine City, Michigan', '36', '', ''),
('Ricky Rotandi', '34', 'Boyfriends', 'New York City, New York', '36', '', ''),
('Cesar Aldrete', '34', 'Boyfriends', 'New York City, New York', '36', '', '')
;
INSERT INTO Episodes (ID, season, season_episode, episode_name, elimination) VALUES
('3201', '32', '1', 'One Million Miles', 1),
('3202', '32', '2', 'Red Lipstick Is Not My Color', 1),
('3203', '32', '3', 'We''re Makin'' Big Moves', 1),
('3204', '32', '4', 'Olé, Olé!', 0),
('3205', '32', '5', 'You Don''t Strike Me as a Renaissance Man', 1),
('3206', '32', '6', 'I''m Not Even Walking, I''m Falling', 0),
('3207', '32', '7', 'Give Me a Beard Bump', 1),
('3208', '32', '8', 'Are You a Rickshaw?', 0),
('3209', '32', '9', 'This Is Not Payback, This Is Karma', 1),
('3210', '32', '10', 'Getting Down to the Nitty Gritty', 1),
('3211', '32', '11', 'Run on Your Tippy Toes', 1),
('3212', '32', '12', 'Now It''s About Winning', 1),
('3301', '33', '1', 'We''re Back!', 1),
('3302', '33', '2', 'It Can''t Be That Easy', 0),
('3303', '33', '3', 'Who Has This One in the Bag?', 1),
('3304', '33', '4', 'Ready to Restart the Race', 1),
('3305', '33', '5', 'Stairway to Hell', 0),
('3306', '33', '6', 'Say Cheese', 1),
('3307', '33', '7', 'Gently Down the Stream', 0),
('3308', '33', '8', 'Souvlaki', 1),
('3309', '33', '9', 'Rock Bottom', 0),
('3310', '33', '10', 'No Room For Error', 1),
('3311', '33', '11', 'In the Hands of The Amazing Race Gods', 1),
('3401', '34', '1', 'Many Firsts But Don''t Be Last', 1),
('3402', '34', '2', 'Patience, is the New Me', 1),
('3403', '34', '3', 'It''s All in the Details', 0),
('3404', '34', '4', 'Everyone''s an Artist', 1),
('3405', '34', '5', 'The Amazing Race of Arabia', 1),
('3406', '34', '6', 'Step By Step', 1),
('3407', '34', '7', 'It''s Simply Medieval', 1),
('3408', '34', '8', 'La Ville Rose', 1),
('3409', '34', '9', 'Vamos a la Playa', 0),
('3410', '34', '10', 'Don''t Look Down', 1),
('3411', '34', '11', 'How Am I Going to Survive This?', 1),
('3412', '34', '12', 'The Only Leg That Matters', 1),
('3501', '35', '1', 'The Amazing Race Is Back!', 1),
('3502', '35', '2', 'You Don''t See That at Home', 1),
('3503', '35', '3', 'No Sleep and a Million Dollar Dream', 0),
('3504', '35', '4', 'The Day Keeps Rockin'' Here in Vietnam', 1),
('3505', '35', '5', 'Yessir, the Pink City', 1),
('3506', '35', '6', 'Driving Head On Into Scooters', 1),
('3507', '35', '7', 'Like Two Cats Fighting in a Car', 1),
('3508', '35', '8', 'A Planes, Trains and Automobiles Day', 1),
('3509', '35', '9', 'In the Belly of the Earth', 1),
('3510', '35', '10', 'Everyone Loves a Comeback Story', 1),
('3511', '35', '11', 'We''re Finding Our Pot of Gold', 1),
('3512', '35', '12', 'A Sunset, Seattle Scramble', 1)
;
INSERT INTO Challenges (country, episode_id, challenge_type, challenge_name, category) VALUES
('United States', '3501', 'Roadblock', 'Who wants to be above it all?', 'Heights'),
('Thailand', '3501', 'Express Pass', '', 'Eating Challenge'),
('Thailand', '3501', 'Detour', 'Sword Play', 'Dancing'),
('Thailand', '3501', 'Detour', 'Spa Day', 'Pain Endurance'),
('Thailand', '3502', 'Roadblock', 'Who has a green thumb?', 'Searching, Crafting'),
('Thailand', '3502', 'Detour', 'Stock Up', 'Shopping, Language'),
('Thailand', '3502', 'Detour', 'Scoop Up', 'Searching, Rowing'),
('Vietnam', '3503', 'Task', '', 'Boating, Searching, Cluefinding'),
('Vietnam', '3503', 'Detour', 'Paper', 'Crafting'),
('Vietnam', '3503', 'Detour', 'Plastic', 'Crafting')
;