US Open 1921 Women's Singles (August 15 - August 20)

	Nation	R64	R32	R16	QF	SF	F	Champion
1.		Subscribe now

2.

3.

4.

5.

6.

7.		Deborah Seal		6-2 6-3
			Deborah Seal
8.		Alice Bayard	6-1 6-2
						Patricia Butlin
9.		Mildred Wildrey				8-6 6-2
			Mildred Wildrey
10.		N. Niles	6-3 6-8 8-6
				Mildred Willard
11.		Ermyntrude Harvey		9-11 8-6 rtd.
			Ermyntrude Harvey
12.		Katherine O'Rourke	6-0 6-0
					Adelaide Browning
13.		Subscribe now

14.

15.

16.
							Mary Kendall Browne
17.							6-3 6-0

18.

19.		E. V. Lynch		6-3 6-3
			E. V. Lynch
20.		Elizabeth Hugus	w/o
					Ann Sheafe Cole
21.		Leslie Bancroft			6-4 7-5
			Leslie Bancroft
22.		Marie Wagner	9-7 7-5
				Ann Sheafe Cole
23.		Ann Sheafe Cole		5-7 8-6 8-6
			Ann Sheafe Cole
24.		Clare Cassel	9-7 6-3
						Mary Kendall Browne
25.		Subscribe now				6-1 6-2

26.

27.

28.

29.

30.

31.		Edith Sigourney		6-2 6-1
			Edith Sigourney
32.		Mrs. Edward Duble	6-0 6-0
								Molla Bjurstedt
33.		Mrs. David Mills						4-6 6-4 6-2
			Mrs. David Mills
34.		Mabel Straffin	6-1 6-1
				Katherine Gardner
35.		Katherine Gardner		6-3 6-1
			Katherine Gardner
36.		Mrs. Joshua Brush	7-5 6-1
					Helene Pollak
37.		Subscribe now

38.

39.

40.
						Molla Bjurstedt
41.						6-2 6-1

42.

43.		Florence Sheldon		6-2 8-6
			Florence Sheldon
44.		Winifred Ellis	7-5 6-3
					Molla Bjurstedt
45.		Molla Bjurstedt			6-0 6-1
			Molla Bjurstedt
46.		Marion Zinderstein	7-5 6-0
				Molla Bjurstedt
47.		Suzanne Lenglen		6-2 0-0 rtd.
			Suzanne Lenglen
48.		Eleanor Goss	w/o
							Molla Bjurstedt
49.		Subscribe now					8-6 6-2

50.

51.

52.

53.

54.

55.		Margaret Leroy		6-2 6-2
			Margaret Leroy
56.		Mrs. Frank Godfrey	6-4 7-5
						May Sutton
57.		Phyllis Walsh				6-1 6-2
			Phyllis Walsh
58.		Mrs. Paul Martin	6-1 6-1
				Phyllis Walsh
59.		Margaret Grove		8-10 6-3 6-2
			Margaret Grove
60.		Mary Case	6-4 6-2
					Helen Gilleaudeau
61.		Subscribe now

62.

63.

64.

(default) 17 queries took 19 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Tournament`.`id`, `Tournament`.`name`, `Tournament`.`slug`, `Tournament`.`subtitle`, `Tournament`.`description`, `Tournament`.`surface`, `Tournament`.`venue`, `Tournament`.`eras`, `Tournament`.`history`, `Tournament`.`president`, `Tournament`.`PrizeMoney`, `Tournament`.`grandslam`, `Tournament`.`created`, `Tournament`.`modified` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`slug` = 'us-open' LIMIT 1	1	1	1
2	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`tournament_id`, `Category`.`gender`, `Category`.`type`, `Category`.`surface`, `Category`.`venue`, `Category`.`president`, `Category`.`name_of_the_tournament`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`tournament_id` = (4)	5	5	1
3	SELECT `Quote`.`id`, `Quote`.`tournament_id`, `Quote`.`quote`, `Quote`.`by`, `Quote`.`source`, `Quote`.`created`, `Quote`.`created_by`, `Quote`.`modified`, `Quote`.`modified_by` FROM `zavoihu1_db4tennis`.`quotes` AS `Quote` WHERE `Quote`.`tournament_id` = (4)	3	3	1
4	SELECT `Tournamenttotal`.`id`, `Tournamenttotal`.`tournament_id`, `Tournamenttotal`.`year`, `Tournamenttotal`.`price_money`, `Tournamenttotal`.`attendance`, `Tournamenttotal`.`created`, `Tournamenttotal`.`created_by`, `Tournamenttotal`.`modified`, `Tournamenttotal`.`modified_by` FROM `zavoihu1_db4tennis`.`tournamenttotals` AS `Tournamenttotal` WHERE `Tournamenttotal`.`tournament_id` = (4)	2	2	1
5	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`tournament_id`, `Category`.`gender`, `Category`.`type`, `Category`.`surface`, `Category`.`venue`, `Category`.`president`, `Category`.`name_of_the_tournament`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by`, `Tournament`.`id`, `Tournament`.`name`, `Tournament`.`slug`, `Tournament`.`subtitle`, `Tournament`.`description`, `Tournament`.`surface`, `Tournament`.`venue`, `Tournament`.`eras`, `Tournament`.`history`, `Tournament`.`president`, `Tournament`.`PrizeMoney`, `Tournament`.`grandslam`, `Tournament`.`created`, `Tournament`.`modified` FROM `zavoihu1_db4tennis`.`categories` AS `Category` LEFT JOIN `zavoihu1_db4tennis`.`tournaments` AS `Tournament` ON (`Category`.`tournament_id` = `Tournament`.`id`) WHERE `Tournament`.`slug` = 'us-open' AND `Category`.`slug` = 'women-singles' LIMIT 1	1	1	1
6	SELECT `Contest`.`id`, `Contest`.`category_id`, `Contest`.`year`, `Contest`.`slug`, `Contest`.`ch`, `Contest`.`date_from`, `Contest`.`date_to`, `Contest`.`book`, `Contest`.`name_of_the_tournament`, `Contest`.`location`, `Contest`.`venue`, `Contest`.`surface`, `Contest`.`participants`, `Contest`.`prize_money`, `Contest`.`attendance`, `Contest`.`misc`, `Contest`.`final_misc`, `Contest`.`created`, `Contest`.`created_by`, `Contest`.`modified`, `Contest`.`modified_by` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = (24) ORDER BY `Contest`.`year` ASC	138	138	2
7	SELECT `Contest`.`id`, `Contest`.`category_id`, `Contest`.`year`, `Contest`.`slug`, `Contest`.`ch`, `Contest`.`date_from`, `Contest`.`date_to`, `Contest`.`book`, `Contest`.`name_of_the_tournament`, `Contest`.`location`, `Contest`.`venue`, `Contest`.`surface`, `Contest`.`participants`, `Contest`.`prize_money`, `Contest`.`attendance`, `Contest`.`misc`, `Contest`.`final_misc`, `Contest`.`created`, `Contest`.`created_by`, `Contest`.`modified`, `Contest`.`modified_by`, `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`tournament_id`, `Category`.`gender`, `Category`.`type`, `Category`.`surface`, `Category`.`venue`, `Category`.`president`, `Category`.`name_of_the_tournament`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` LEFT JOIN `zavoihu1_db4tennis`.`categories` AS `Category` ON (`Contest`.`category_id` = `Category`.`id`) WHERE `Category`.`tournament_id` = 4 AND `Contest`.`category_id` = 24 AND `Contest`.`slug` = '1921' LIMIT 1	1	1	2
8	SELECT `Match`.`id`, `Match`.`contest_id`, `Match`.`player_a_id`, `Match`.`player_aa_id`, `Match`.`player_b_id`, `Match`.`player_bb_id`, `Match`.`results`, `Match`.`long`, `Match`.`attendance`, `Match`.`no`, `Match`.`round`, `Match`.`round_id`, `Match`.`note`, `Match`.`created`, `Match`.`created_by`, `Match`.`modified`, `Match`.`modified_by` FROM `zavoihu1_db4tennis`.`matches` AS `Match` WHERE `Match`.`contest_id` = (1338) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC	63	63	1
9	SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (12859, 12860, 12861, 12797, 12862, 12863, 12728, 12835, 12584, 12846, 10571, 12864, 12644, 12865, 12866, 12576, 11815, 11789, 12814, 12867, 10568, 11442, 12709, 11640, 10585, 12868, 12792, 12393, 11440, 12840, 11781, 12800, 12870, 12799, 11822, 12842, 12764, 12871, 12831, 12872, 12873, 12813, 12738, 12874, 10623, 10579, 10543, 11806, 10641, 12519, 12875, 12876, 12596, 12740, 12521, 12877, 12727, 12878, 12879, 12880, 12881, 12882, 12804, 12780, 12714) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	65	65	1
10	SELECT `Playercontest`.`id`, `Playercontest`.`player_id`, `Playercontest`.`contest_id`, `Playercontest`.`nat_id`, `Playercontest`.`draw` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE `Playercontest`.`contest_id` = 1338	65	65	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 196, 68)	3	3	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 196, 68)	3	3	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (12859, 12860, 12861, 12797, 12862, 12863, 12728, 12835, 12584, 12846, 10571, 12864, 12644, 12865, 12866, 12576, 11815, 11789, 12814, 12867, 10568, 11442, 12709, 11640, 10585, 12868, 12792, 12393, 11440, 12840, 11781, 12800, 12870, 12799, 11822, 12842, 12764, 12871, 12831, 12872, 12873, 12813, 12738, 12874, 10623, 10579, 10543, 11806, 10641, 12519, 12875, 12876, 12596, 12740, 12521, 12877, 12727, 12878, 12879, 12880, 12881, 12882, 12804, 12780, 12714)) AND (`Playercontest`.`contest_id` = 1338))	65	65	1
14	SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 24 ORDER BY `Contest`.`date_from` ASC	138	138	1
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 1921	14	14	1
16	SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (2, 1, 17, 22, 18, 23, 24, 25, 26, 12, 19, 20, 21, 14) AND `Category`.`gender` = 'Women' AND `Category`.`type` = 'Singles'	3	3	1
17	SELECT `Tournament`.`slug`, `Tournament`.`name` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`id` IN (2, 3, 4)	3	3	1

(default) 17 queries took 19 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Tournament`.`id`, `Tournament`.`name`, `Tournament`.`slug`, `Tournament`.`subtitle`, `Tournament`.`description`, `Tournament`.`surface`, `Tournament`.`venue`, `Tournament`.`eras`, `Tournament`.`history`, `Tournament`.`president`, `Tournament`.`PrizeMoney`, `Tournament`.`grandslam`, `Tournament`.`created`, `Tournament`.`modified` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`slug` = 'us-open' LIMIT 1

SELECT `Quote`.`id`, `Quote`.`tournament_id`, `Quote`.`quote`, `Quote`.`by`, `Quote`.`source`, `Quote`.`created`, `Quote`.`created_by`, `Quote`.`modified`, `Quote`.`modified_by` FROM `zavoihu1_db4tennis`.`quotes` AS `Quote` WHERE `Quote`.`tournament_id` = (4)

SELECT `Tournamenttotal`.`id`, `Tournamenttotal`.`tournament_id`, `Tournamenttotal`.`year`, `Tournamenttotal`.`price_money`, `Tournamenttotal`.`attendance`, `Tournamenttotal`.`created`, `Tournamenttotal`.`created_by`, `Tournamenttotal`.`modified`, `Tournamenttotal`.`modified_by` FROM `zavoihu1_db4tennis`.`tournamenttotals` AS `Tournamenttotal` WHERE `Tournamenttotal`.`tournament_id` = (4)

SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`tournament_id`, `Category`.`gender`, `Category`.`type`, `Category`.`surface`, `Category`.`venue`, `Category`.`president`, `Category`.`name_of_the_tournament`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by`, `Tournament`.`id`, `Tournament`.`name`, `Tournament`.`slug`, `Tournament`.`subtitle`, `Tournament`.`description`, `Tournament`.`surface`, `Tournament`.`venue`, `Tournament`.`eras`, `Tournament`.`history`, `Tournament`.`president`, `Tournament`.`PrizeMoney`, `Tournament`.`grandslam`, `Tournament`.`created`, `Tournament`.`modified` FROM `zavoihu1_db4tennis`.`categories` AS `Category` LEFT JOIN `zavoihu1_db4tennis`.`tournaments` AS `Tournament` ON (`Category`.`tournament_id` = `Tournament`.`id`) WHERE `Tournament`.`slug` = 'us-open' AND `Category`.`slug` = 'women-singles' LIMIT 1

138

SELECT `Contest`.`id`, `Contest`.`category_id`, `Contest`.`year`, `Contest`.`slug`, `Contest`.`ch`, `Contest`.`date_from`, `Contest`.`date_to`, `Contest`.`book`, `Contest`.`name_of_the_tournament`, `Contest`.`location`, `Contest`.`venue`, `Contest`.`surface`, `Contest`.`participants`, `Contest`.`prize_money`, `Contest`.`attendance`, `Contest`.`misc`, `Contest`.`final_misc`, `Contest`.`created`, `Contest`.`created_by`, `Contest`.`modified`, `Contest`.`modified_by`, `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`tournament_id`, `Category`.`gender`, `Category`.`type`, `Category`.`surface`, `Category`.`venue`, `Category`.`president`, `Category`.`name_of_the_tournament`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` LEFT JOIN `zavoihu1_db4tennis`.`categories` AS `Category` ON (`Contest`.`category_id` = `Category`.`id`) WHERE `Category`.`tournament_id` = 4 AND `Contest`.`category_id` = 24 AND `Contest`.`slug` = '1921' LIMIT 1

SELECT `Match`.`id`, `Match`.`contest_id`, `Match`.`player_a_id`, `Match`.`player_aa_id`, `Match`.`player_b_id`, `Match`.`player_bb_id`, `Match`.`results`, `Match`.`long`, `Match`.`attendance`, `Match`.`no`, `Match`.`round`, `Match`.`round_id`, `Match`.`note`, `Match`.`created`, `Match`.`created_by`, `Match`.`modified`, `Match`.`modified_by` FROM `zavoihu1_db4tennis`.`matches` AS `Match` WHERE `Match`.`contest_id` = (1338) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC

SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (12859, 12860, 12861, 12797, 12862, 12863, 12728, 12835, 12584, 12846, 10571, 12864, 12644, 12865, 12866, 12576, 11815, 11789, 12814, 12867, 10568, 11442, 12709, 11640, 10585, 12868, 12792, 12393, 11440, 12840, 11781, 12800, 12870, 12799, 11822, 12842, 12764, 12871, 12831, 12872, 12873, 12813, 12738, 12874, 10623, 10579, 10543, 11806, 10641, 12519, 12875, 12876, 12596, 12740, 12521, 12877, 12727, 12878, 12879, 12880, 12881, 12882, 12804, 12780, 12714) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC

SELECT `Playercontest`.`id`, `Playercontest`.`player_id`, `Playercontest`.`contest_id`, `Playercontest`.`nat_id`, `Playercontest`.`draw` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE `Playercontest`.`contest_id` = 1338

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 196, 68)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 196, 68)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (12859, 12860, 12861, 12797, 12862, 12863, 12728, 12835, 12584, 12846, 10571, 12864, 12644, 12865, 12866, 12576, 11815, 11789, 12814, 12867, 10568, 11442, 12709, 11640, 10585, 12868, 12792, 12393, 11440, 12840, 11781, 12800, 12870, 12799, 11822, 12842, 12764, 12871, 12831, 12872, 12873, 12813, 12738, 12874, 10623, 10579, 10543, 11806, 10641, 12519, 12875, 12876, 12596, 12740, 12521, 12877, 12727, 12878, 12879, 12880, 12881, 12882, 12804, 12780, 12714)) AND (`Playercontest`.`contest_id` = 1338))

SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 24 ORDER BY `Contest`.`date_from` ASC

138

SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 1921

SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (2, 1, 17, 22, 18, 23, 24, 25, 26, 12, 19, 20, 21, 14) AND `Category`.`gender` = 'Women' AND `Category`.`type` = 'Singles'

SELECT `Tournament`.`slug`, `Tournament`.`name` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`id` IN (2, 3, 4)