names

106 rows where place_id = 589607

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3598165 1867056 1867056 defendant Baret John yeoman 589607 589607 Baret, John, of Reygate, yeoman 1
3633479 1905284 1905284 defendant Shory John smith 589607 589607 Shory, John, of Reygate, smith 0
3642318 1908045 1908045 defendant Hall Ralph butcher 589607 589607 Hall, Ralph, of Reygate, butcher 2
3642319 1908045 1908045 defendant Bourer John laborer 589607 589607 Bourer, John, of Reygate, laborer 3
3642320 1908045 1908045 defendant Colby William tailor 589607 589607 Colby, William, of Reygate, tailor 4
3642608 1908130 1908130 defendant William Christopher carpenter 589607 589607 William, Christopher, of Reygate, carpenter 1
3664644 1914896 1914896 defendant Rowne John husbandman 589607 589607 Rowne, John, of Reygate, husbandman 1
3667268 1915699 1915699 defendant Belhouse William gent 589607 589607 (Belhouse, William, of Reygate, gent 1
3667663 1915830 1915830 defendant Belhouse William gent 589607 589607 Belhouse, William, of Reygate, gent 0
3699995 1926232 1926232 defendant Alyngam John, junior husbandman 589607 589607 Alyngam, John, junior, of Reygate, husbandman 0
3699996 1926232 1926232 defendant Wodeman Robert husbandman 589607 589607 Wodeman, Robert, of Reygate, husbandman 1
3699997 1926232 1926232 defendant Alyngham James husbandman 589607 589607 Alyngham, James, of Reygate, husbandman 2
3725169 1934160 1934160 defendant Brygham William laborer 589607 589607 Brygham, William, of Reygate, laborer 0
3725176 1934161 1934161 defendant Brygham William laborer 589607 589607 Brygham, William, of Reygate, laborer 0
3740646 1938935 1938935 defendant Ase Richard, senior husbandman 589607 589607 Ase, Richard, senior, of Reygate, husbandman 0
3740647 1938935 1938935 defendant Waterer Thomas, senior husbandman 589607 589607 Waterer, Thomas, senior, of Reygate, husbandman 1
3740649 1938935 1938935 defendant Charlewod Walter laborer 589607 589607 Charlewod, Walter, of Reygate, laborer 3
3741067 1939068 1939068 defendant Gander Robert carpenter 589607 589607 Gander, Robert, of Reygate, carpenter 0
3770021 1948285 1948285 defendant Sprenger James painter 589607 589607 Sprenger, James, of Reygate, painter 0
3775780 1950174 1950174 defendant Broun Richard smith 589607 589607 Broun, Richard, of Reygate, smith 0
3775873 1950207 1950207 defendant Skynner John gent 589607 589607 Skynner, John, of Reygate, gent 0
3812436 1961781 1961781 defendant Awodde William husbandman 589607 589607 Awodde, William, of Reygate, husbandman 0
3891255 1987341 1987341 defendant Bonwyke John yeoman 589607 589607 Bonwyke, John, of Reygate, yeoman 0
3897587 1989405 1989405 plaintiff Woodd William tanner 589607 589607 Woodd, William, of Reygate, tanner 0
3909712 1993557 1993557 defendant Halle Robert smith 589607 589607 Halle, Robert, of Reygate, smith 0
3913735 1994936 1994936 defendant Broke Thomas smith 589607 589607 Broke, Thomas, of Reygate, smith 0
3913943 1995009 1995009 defendant Elyatt Gregory husbandman 589607 589607 Elyatt, Gregory, of Reygate, husbandman 0
4069086 2049235 2049235 defendant Hocker Henry yeoman 589607 589607 Hocker, Henry, of Reygate, yeoman 0
4069087 2049235 2049235 defendant Hocker Alan yeoman 589607 589607 Hocker, Alan, of Reygate, yeoman 1
4086800 2055568 2055568 defendant Cuddington Richard husbandman 589607 589607 Cuddington, Richard, of Reygate, husbandman 0
4087299 2055748 2055748 defendant Cuddyngton Richard husbandman 589607 589607 Cuddyngton, Richard, of Reygate, husbandman 0
4122749 2068428 2068428 defendant Leedes Edward gent 589607 589607 Leedes, Edward, of Reygate, gent 1
4185208 2090334 2090334 defendant Cowper or Cooper Benjamin yeoman 589607 589607 Cowper or Cooper, Benjamin, of Reygate, yeoman 0
4213960 2100404 2100404 defendant Stacye Thomas husbandman 589607 589607 Stacye, Thomas, of Reygate, husbandman 0
4230829 2106280 2106280 defendant Savadge Richard yeoman 589607 589607 Savadge, Richard, of Reygate, yeoman 0
4230830 2106280 2106280 defendant Skelton Robert yeoman 589607 589607 Skelton, Robert, of Reygate, yeoman 1
4230833 2106281 2106281 defendant Savadge Richard yeoman 589607 589607 Savadge, Richard, of Reygate, yeoman 0
4230834 2106281 2106281 defendant Skelton Robert yeoman 589607 589607 Skelton, Robert, of Reygate, yeoman 1
4231632 2106566 2106566 defendant Allyngham Thomas husbandman 589607 589607 Allyngham, Thomas, of Reygate, husbandman 0
4231633 2106566 2106566 defendant Jelly Robert, junior husbandman 589607 589607 Jelly, Robert, junior, of Reygate, husbandman 1
4231634 2106566 2106566 defendant Allyngham Agnes single woman 589607 589607 together with Allyngham, Agnes, of Reygate, single woman 2
4231635 2106566 2106566 defendant Stacy Thomas husbandman 589607 589607 Stacy, Thomas, of Reygate, husbandman 3
4231636 2106566 2106566 defendant Killicke Thomas, junior husbandman 589607 589607 Killicke, Thomas, junior, of Reygate, husbandman 4
4234318 2107538 2107538 defendant Alyffe George blacksmith 589607 589607 Alyffe, George, of Reygate, blacksmith 1
4251313 2113417 2113417 defendant Arnold John laborer 589607 589607 Arnold, John, of Reygate, laborer 0
4276763 2121806 2121806 defendant Lymbden William, senior laborer 589607 589607 Lymbden , William, senior, of Reygate, laborer 0
4276765 2121806 2121806 defendant Sparke John tailor 589607 589607 Sparke, John, of Reygate, tailor 2
4467932 2190649 2190649 plaintiff Barbour Thomas   589607 589607 Barbour, Thomas, of Reygate 0
4509996 2203612 2203612 plaintiff Bakere William   589607 589607 Bakere, William, of Reygate 0
4545074 2214381 2214381 defendant Wrygge Walter   589607 589607 Wrygge, Walter, of Reygate 0
4558202 2218506 2218506 defendant Wrygge Walter   589607 589607 Wrygge, Walter, of Reygate 0
4565191 2220687 2220687 plaintiff Skynner Richard   589607 589607 Skynner, Richard, of Reygate 0
4572174 2222847 2222847 defendant Bakere John   589607 589607 Bakere, John, of Reygate 3
4599471 2231051 2231051 defendant atte Barre John   589607 589607 atte Barre, John, of Reygate 0
4599475 2231053 2231053 defendant Coumbe John (legal representative) 589607 589607 Coumbe, John, of Reygate, son of Thomas, executors of 0
4599477 2231053 2231053 defendant Chaunce Roger   589607 589607 Chaunce, Roger, of Reygate 2
4603441 2232267 2232267 defendant Cheyny John   589607 589607 Cheyny, John, of Reygate 0
4603663 2232332 2232332 plaintiff Wrygg Walter   589607 589607 Wrygg, Walter, of Reygate 0
4606639 2233186 2233186 defendant Northbrok Richard   589607 589607 Northbrok, Richard, of Reygate 0
4636591 2242272 2242272 defendant Northbrook Richard   589607 589607 Northbrook, Richard, of Reygate 0
4652772 2246799 2246799 defendant Skete Roger husbandman 589607 589607 Skete, Roger, of Reygate, husbandman 0
4686010 2261212 2261212 defendant Wyltsshire John   589607 589607 Wyltsshire, John, of Reygate, knight 0
4690776 2262653 2262653 defendant Bealde John husbandman 589607 589607 Bealde, John, of Reygate, husbandman 3
4690788 2262655 2262655 defendant Bealde John husbandman 589607 589607 Bealde, John, of Reygate, husbandman 1
4785790 2291592 2291592 defendant Gosehale Robert laborer 589607 589607 Gosehale, Robert, of Reygate, laborer 0
4785791 2291592 2291592 defendant Colbrond William laborer 589607 589607 Colbrond, William, of Reygate, laborer 1
4855682 2313148 2313148 defendant Swyft Richard laborer 589607 589607 Swyft, Richard, of Reygate, laborer 0
4861794 2315062 2315062 defendant Milne William baker 589607 589607 Milne, William, of Reygate, baker 0
4910839 2329898 2329898 defendant Grene Robert butcher 589607 589607 Grene, Robert, of Reygate, butcher 0
4941891 2339453 2339453 defendant Brytte Robert tanner 589607 589607 Brytte, Robert, of Reygate, tanner 0
4943366 2339893 2339893 defendant Jordan William   589607 589607 Jordan, William, of Reygate 0
4953451 2343001 2343001 defendant atte Nassh Simon husbandman 589607 589607 atte Nassh, Simon, of Reygate, husbandman 0
4991433 2354323 2354323 defendant Whyte William husbandman 589607 589607 Whyte, William, of Reygate, husbandman 0
5006086 2358668 2358668 defendant Chilmed Thomas   589607 589607 Chilmed, Thomas, of Reygate, servant 0
5009750 2359732 2359732 defendant Hervest John   589607 589607 Hervest, John, of Reygate priory, prior 0
5014718 2361176 2361176 defendant Britte Stephen yeoman 589607 589607 Britte, Stephen, of Reygate, yeoman 0
5015517 2361424 2361424 defendant atte Nasshe Simon carpenter 589607 589607 atte Nasshe, Simon, of Reygate, carpenter 1
5023161 2363675 2363675 defendant Tyler Walter, junior husbandman 589607 589607 Tyler, Walter, junior, of Reygate, husbandman 0
5023162 2363675 2363675 defendant Nasshe Simon yeoman 589607 589607 Nasshe, Simon, of Reygate, yeoman 1
5033186 2366588 2366588 defendant atte Nasshe Simon husbandman 589607 589607 atte Nasshe, Simon, of Reygate, husbandman 3
5050691 2371833 2371833 defendant Beld John yeoman 589607 589607 Beld, John, of Reygate, yeoman 0
5059274 2374339 2374339 defendant Skynner John gent 589607 589607 Skynner, John, of Reygate, gent 1
5081726 2381035 2381035 defendant Gander Robert husbandman 589607 589607 Gander, Robert, of Reygate, husbandman 0
5114479 2390633 2390633 defendant Marden John smith 589607 589607 Marden, John, of Reygate, smith 0
5114482 2390633 2390633 defendant Alen John smith 589607 589607 Alen, John, of Reygate, smith 3
5236580 2426286 2426286 defendant Skynner John gent 589607 589607 Skynner, John, of Reygate, gent 1
5265405 2434936 2434936 defendant Margery Henry butcher 589607 589607 Margery, Henry, of Reygate, butcher 1
5269685 2436245 2436245 defendant Skynner John gent 589607 589607 Skynner, John, of Reygate, gent 0
5269687 2436246 2436246 defendant Skynner John gent 589607 589607 Skynner, John, of Reygate, gent 0
5279526 2439089 2439089 defendant Skynner John (legal representative) 589607 589607 Skynner, John, of Reygate, gent, executors of 2
5279920 2439203 2439203 defendant Skynner John (legal representative) 589607 589607 Skynner, John, of Reygate, gent, executors of 2
5280830 2439464 2439464 defendant Pole Thomas   589607 589607 Pole, Thomas, of Reygate, surgeon or barber 0
5280832 2439465 2439465 defendant Pole Thomas   589607 589607 Pole, Thomas, of Reygate, surgeon or barber 0
5288263 2441585 2441585 defendant Meryweder John yeoman 589607 589607 Meryweder, John, of Reygate, yeoman 0
5299198 2444744 2444744 defendant Holmysden Simon chapman 589607 589607 Holmysden, Simon, of Reygate, chapman 1
5299442 2444812 2444812 defendant Hollnysden Simon chapman 589607 589607 Hollnysden, Simon, of Reygate, chapman 1
5350613 2460306 2460306 defendant Weller John laborer 589607 589607 together with Weller, John, of Reygate, laborer 1
5350614 2460306 2460306 defendant Agodsalfe John laborer 589607 589607 Agodsalfe, John, of Reygate, laborer 2
5350615 2460306 2460306 defendant Smyth Robert sawyer 589607 589607 Smyth, Robert, of Reygate, sawyer 3
5350649 2460315 2460315 defendant Wiche Richard clerk 589607 589607 Wiche, Richard, of Reygate, clerk 0

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);