names

76 rows where place_id = 642363

✎ 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
3667457 1915762 1915762 plaintiff Wolmer Walter   642363 642363 Wolmer, Walter, of Solihull, rector & master 0
3667460 1915762 1915762 defendant Berbory Richard   642363 642363 Berbory, Richard, of Solihull, surgeon 2
3867509 1979369 1979369 plaintiff Seman Edward clerk 642363 642363 Seman, Edward, of Solihull, clerk 0
4121894 2068128 2068128 defendant Wythye John husbandman 642363 642363 Wythye, John, of Solihull, husbandman 1
4121895 2068128 2068128 defendant Cottrell Thomas miller 642363 642363 Cottrell, Thomas, of Solihull, miller 2
4140081 2074698 2074698 defendant Mortiboyes Maurice husbandman 642363 642363 Mortiboyes, Maurice, of Solihull, husbandman 0
4154002 2079493 2079493 defendant Brook Francis yeoman 642363 642363 Brook, Francis, of Solihull, yeoman 0
4172450 2085827 2085827 defendant Dawes Henry mercer 642363 642363 Dawes, Henry, of Solihull, mercer 0
4178266 2087869 2087869 defendant Smythe Henry clerk 642363 642363 Smythe, Henry, of Solihull, clerk 0
4182738 2089440 2089440 defendant Gibbes William husbandman 642363 642363 Gibbes, William, of Solihull, husbandman 0
4183308 2089644 2089644 defendant Smyth Robert husbandman 642363 642363 Smyth, Robert, of Solihull, husbandman 0
4183311 2089645 2089645 defendant Smythe Robert husbandman 642363 642363 Smythe, Robert, of Solihull, husbandman 0
4217965 2101777 2101777 defendant Gardener Richard yeoman 642363 642363 Gardener, Richard, of Solihull, yeoman 0
4217966 2101777 2101777 defendant Pynnynge Humphrey tailor 642363 642363 Pynnynge, Humphrey, of Solihull, tailor 1
4277057 2121909 2121909 defendant Westcote Richard yeoman 642363 642363 Westcote, Richard, of Solihull, or of Tanworthe, yeoman 0
4297283 2129136 2129136 defendant Wilson Thomas tailor 642363 642363 Wilson, Thomas, of Solihull, tailor 1
4369534 2154163 2154163 defendant Twist Thomas husbandman 642363 642363 Twist, Thomas, of Solihull, husbandman 2
4377688 2157091 2157091 defendant Cotterell John yeoman 642363 642363 Cotterell, John, of Solihull, yeoman 0
4381590 2158524 2158524 defendant Shawe Edmund gent 642363 642363 Shawe, Edmund, of Solihull, gent 2
4382380 2158807 2158807 defendant Worthen Richard husbandman 642363 642363 Worthen, Richard, of Solihull, husbandman 1
4413682 2169173 2169173 defendant Deystere Robert le   642363 642363 Deystere, Robert le, of Solihull 1
4416667 2170079 2170079 plaintiff Notte John le   642363 642363 Notte, John le, of Solihull 0
4420155 2171204 2171204 defendant Deystere Robert   642363 642363 Deystere, Robert, of Solihull 1
4422662 2171943 2171943 defendant atte Birches Richard, senior   642363 642363 atte Birches, Richard, senior, of Solihull 0
4426757 2173183 2173183 defendant Taillour Walter le   642363 642363 Taillour, Walter le, of Solihull 0
4438681 2181386 2181386 defendant Harpour John   642363 642363 Harpour, John, of Solihull 2
4442474 2182593 2182593 defendant atte Shawe Thomas   642363 642363 atte Shawe, Thomas, of Solihull 0
4447174 2184022 2184022 defendant atte Shawe Thomas   642363 642363 atte Shawe, Thomas, of Solihull 0
4482940 2195362 2195362 defendant Treweman William   642363 642363 Treweman, William, of Solihull 0
4575359 2223806 2223806 defendant Arnecok William   642363 642363 Arnecok, William, of Solihull 0
4606419 2233123 2233123 plaintiff Baker John (legal representative) 642363 642363 Baker, John, of Solihull, executors of 0
4606430 2233123 2233123 defendant Hawe Thomas   642363 642363 Hawe, Thomas, of Solihull 5
4616336 2236101 2236101 defendant Smyth William   642363 642363 Smyth, William, of Solihull 0
4651529 2246482 2246482 defendant Horspale John yeoman 642363 642363 Horspale, John, of Solihull, yeoman 0
4699637 2265338 2265338 defendant Warde John husbandman 642363 642363 Warde, John, of Solihull, husbandman 1
4703142 2266361 2266361 defendant atte Wode Richard butcher 642363 642363 atte Wode, Richard, of Solihull, butcher 1
4710005 2268487 2268487 defendant Hawe Robert husbandman 642363 642363 Hawe, Robert, of Solihull, husbandman 0
4720336 2271699 2271699 defendant Aleyn Thomas yeoman 642363 642363 Aleyn, Thomas, of Solihull, yeoman 3
4722560 2272370 2272370 defendant Hawe Robert   642363 642363 Hawe, Robert, of Solihull, franklin 0
4728690 2274211 2274211 defendant Byrches William husbandman 642363 642363 Byrches, William, of Solihull, husbandman 0
4728897 2274276 2274276 defendant Lowethorp John husbandman 642363 642363 Lowethorp, John, of Solihull, husbandman 0
4728899 2274276 2274276 defendant Grymesyarowe Beatrice widow 642363 642363 Grymesyarowe, Beatrice, of Solihull, widow 2
4744240 2278841 2278841 defendant Hulot John butcher 642363 642363 Hulot, John, of Solihull, butcher 1
4755468 2282089 2282089 defendant Bokemore John (legal representative) 642363 642363 Bokemore, John, of Solihull, executors of 0
4763433 2284551 2284551 defendant Strayn John husbandman 642363 642363 Strayn, John, of Solihull, husbandman 0
4763434 2284551 2284551 defendant atte Venne Robert husbandman 642363 642363 atte Venne, Robert, of Solihull, husbandman 1
4765692 2285264 2285264 defendant Cokesey John husbandman 642363 642363 Cokesey, John, of Solihull, husbandman 0
4771508 2287071 2287071 defendant Hawe William gent 642363 642363 Hawe, William, of Solihull, gent 0
4790118 2292988 2292988 defendant Cokesey John husbandman 642363 642363 Cokesey, John, of Solihull, husbandman 0
4794577 2294444 2294444 defendant Hawe Thomas gent 642363 642363 Hawe, Thomas, of Solihull, gent 0
4960249 2345040 2345040 defendant Avenant Thomas weaver 642363 642363 Avenant, Thomas, of Solihull, weaver 0
4996649 2355851 2355851 defendant Hynkeley Thomas yeoman 642363 642363 Hynkeley, Thomas, of Solihull, yeoman 1
5011195 2360129 2360129 defendant Broun Richard gent 642363 642363 Broun, Richard, of Solihull, gent 0
5015447 2361399 2361399 defendant Wareng John yeoman 642363 642363 Wareng, John, of Solihull, yeoman 1
5037108 2367725 2367725 defendant Broun Richard gent 642363 642363 Broun, Richard, of Solihull, gent 0
5052589 2372368 2372368 defendant Porter Baldwin esq 642363 642363 Porter, Baldwin, of Solihull, esq 1
5076115 2379358 2379358 defendant Fulford William husbandman 642363 642363 Fulford, William, of Solihull, husbandman 0
5076116 2379358 2379358 defendant Rastell John husbandman 642363 642363 Rastell, John, of Solihull, husbandman 1
5107616 2388660 2388660 defendant Huggeford William yeoman 642363 642363 Huggeford, William, of Solihull, yeoman 0
5114932 2390782 2390782 defendant Broun John tailor 642363 642363 Broun, John, of Solihull, tailor 0
5138409 2397741 2397741 defendant Corvesor William   642363 642363 Corvesor, William, of Solihull, Warr, corvisor 1
5152472 2401858 2401858 defendant Beverle Robert   642363 642363 Beverle, Robert, of Solihull, parson 0
5254986 2431673 2431673 defendant Greswold John, senior gent 642363 642363 Greswold, John, senior, of Solihull, gent 0
5267722 2435664 2435664 defendant Greswold John, senior esq 642363 642363 Greswold, John, senior, of Solihull, esq 0
5363579 2464263 2464263 defendant Smyth John smith 642363 642363 Smyth, John, of Solihull, smith 0
5363580 2464263 2464263 defendant Smyth John weaver 642363 642363 Smyth, John, of Solihull, weaver 1
5363581 2464263 2464263 defendant Corpeson William husbandman 642363 642363 Corpeson, William, of Solihull, husbandman 2
5415686 2479634 2479634 defendant Grene Brian butcher 642363 642363 Grene, Brian, of Solihull, butcher 4
5455545 2491568 2491568 defendant Grene Brian yeoman 642363 642363 Grene, Brian, of Solihull, yeoman 0
5460677 2493137 2493137 defendant Grene Brian butcher 642363 642363 Grene, Brian, of Solihull, butcher 3
5466675 2494979 2494979 defendant Grene Brian yeoman 642363 642363 Grene, Brian, of Solihull, yeoman 0
5502365 2505665 2505665 defendant Grene Brian yeoman 642363 642363 Grene, Brian, of Solihull, yeoman 0
5502366 2505665 2505665 defendant Barbour Richard   642363 642363 Barbour, Richard, of Solihull 1
5536340 2515853 2515853 defendant Boys William chapman 642363 642363 Boys, William, of Solihull, chapman 1
5624361 2551563 2551563 defendant Hulot John butcher 642363 642363 Hulot, John, of Solihull, butcher 1
5624362 2551563 2551563 defendant Ford William butcher 642363 642363 Ford, William, of Solihull, butcher 2

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);