names

59 rows where place_id = 586214

✎ 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
3588183 1863958 1863958 defendant Taillour Hugh tailor 586214 586214 Taillour, Hugh, of Webley, Herefs, tailor 0
3591146 1864851 1864851 defendant Gough John yeoman 586214 586214 Gough, John, of Webley, Herefs, yeoman 2
3599677 1867540 1867540 defendant Vaughan Thomas   586214 586214 Vaughan, Thomas, of Webley, Herefs, knight 0
3599718 1867556 1867556 defendant Gyttyn John clerk 586214 586214 Gyttyn, John, of Webley, Herefs, clerk 0
3599721 1867557 1867557 defendant Gyttyng John clerk 586214 586214 Gyttyng, John, of Webley, Herefs, clerk 0
3727768 1934955 1934955 defendant Garewey Thomas grasier 586214 586214 Garewey, Thomas, of Webley, Herefs, grasier 2
3814559 1962466 1962466 defendant Mascall Thomas yeoman 586214 586214 Mascall, Thomas, of Webley, Herefs, yeoman 1
3854552 1975067 1975067 plaintiff Tomkyns James   586214 586214 Tomkyns, James, of Webley, Herefs 0
3889604 1986753 1986753 defendant Bygge Henry gent 586214 586214 Bygge, Henry, of Webley, Herefs, gent 2
3965119 2012407 2012407 defendant Howell Thomas husbandman 586214 586214 Howell, Thomas, of Webley, Herefs, husbandman 2
3965131 2012411 2012411 defendant Carpynter John yeoman 586214 586214 Carpynter, John, of Webley, Herefs, yeoman 0
3965141 2012415 2012415 defendant Wyett Humphrey tailor 586214 586214 Wyett, Humphrey, of Webley, Herefs, tailor 0
3986188 2019827 2019827 defendant Bayly Henry yeoman 586214 586214 Bayly, Henry, of Webley, Herefs, yeoman 4
4011047 2028724 2028724 defendant Monyngton George mercer 586214 586214 Monyngton, George, of Webley, Herefs, mercer 0
4048412 2041878 2041878 defendant Monyngton George chapman 586214 586214 Monyngton, George, of Webley, Herefs, chapman 1
4048415 2041879 2041879 defendant Monyngton George chapman 586214 586214 Monyngton, George, of Webley, Herefs, chapman 1
4049911 2042399 2042399 defendant Monyngton George gent 586214 586214 Monyngton, George, of Webley, Herefs, gent 1
4049915 2042400 2042400 defendant Monyngton George gent 586214 586214 Monyngton, George, of Webley, Herefs, gent 1
4102899 2061330 2061330 defendant Monyngton George gent 586214 586214 Monyngton, George, of Webley, Herefs, gent 0
4131013 2071406 2071406 defendant Monnyngton George chapman 586214 586214 Monnyngton, George, of Webley, Herefs, chapman 0
4141865 2075322 2075322 defendant Monyngton George chapman 586214 586214 Monyngton, George, of Webley, Herefs, chapman 0
4142874 2075682 2075682 defendant Monyngton George gent 586214 586214 Monyngton, George, of Webley, Herefs, gent 0
4149301 2077882 2077882 defendant Reade John husbandman 586214 586214 Reade, John, of Webley, Herefs, husbandman 0
4185789 2090526 2090526 defendant Monyngton George chapman 586214 586214 Monyngton, George, of Webley, Herefs, chapman 0
4194183 2093516 2093516 defendant Reade John yeoman 586214 586214 Reade, John, of Webley, Herefs, yeoman 0
4200642 2095784 2095784 defendant Monyngton George chapman 586214 586214 Monyngton, George, of Webley, Herefs, chapman 0
4201663 2096125 2096125 defendant Munnington George chapman 586214 586214 Munnington, George, of Webley, Herefs, chapman 0
4206937 2097969 2097969 defendant Monyngton George gent 586214 586214 Monyngton, George, of Webley, Herefs, gent 1
4321127 2137482 2137482 defendant Pembridge Thomas yeoman 586214 586214 Pembridge, Thomas, of Webley, Herefs, yeoman 0
4382382 2158808 2158808 plaintiff Yemond or Yemons George (legal representative) 586214 586214 Yemond or Yemons, George, of Webley, Herefs, sawyer, executrix of 0
4953599 2343047 2343047 defendant Baker John, junior hosier 586214 586214 Baker, John, junior, of Webley, Herefs, hosier 4
4953619 2343049 2343049 defendant Baker John, junior hosier 586214 586214 Baker, John, junior, of Webley, Herefs, hosier 4
4954983 2343448 2343448 defendant Mymmes Thomas gent 586214 586214 Mymmes, Thomas, of Webley, Herefs, gent 0
4982141 2351577 2351577 defendant Styward Robert yeoman 586214 586214 Styward, Robert, of Webley, Herefs, yeoman 0
5022348 2363431 2363431 plaintiff Glover John   586214 586214 Glover, John, of Webley, Herefs 0
5114281 2390571 2390571 defendant Devereux Walter esq 586214 586214 Devereux, Walter, of Webley, Herefs, esq 0
5114285 2390572 2390572 defendant Devereux Walter esq 586214 586214 Devereux, Walter, of Webley, Herefs, esq 0
5223964 2422691 2422691 defendant Oker John yeoman 586214 586214 Oker, John, of Webley, Herefs, yeoman 3
5265116 2434849 2434849 defendant ap Rychard John clerk 586214 586214 ap Rychard, John, of Webley, Herefs, clerk 0
5271238 2436680 2436680 defendant Baker John gent 586214 586214 Baker, John, of Webley, Herefs, gent 1
5271251 2436685 2436685 defendant Baker John gent 586214 586214 Baker, John, of Webley, Herefs, gent 2
5306903 2447062 2447062 defendant Devereux Walter   586214 586214 Devereux, Walter, of Webley, Herefs, knight, lord Ferres 0
5306907 2447064 2447064 defendant Devereux John   586214 586214 Devereux, John, of Webley, Herefs, knight 0
5311717 2448525 2448525 defendant Devereux Walter   586214 586214 Devereux, Walter, of Webley, Herefs, knight, Lord Ferrers 0
5316891 2450134 2450134 defendant Comrowe Thomas chapman 586214 586214 Comrowe, Thomas, of Webley, Herefs, chapman 0
5344139 2458345 2458345 defendant Prykerd John   586214 586214 Prykerd, John, of Webley, Herefs, cerk 2
5354678 2461541 2461541 defendant Monyngton Thomas esq 586214 586214 Monyngton, Thomas, of Webley, Herefs, esq 1
5354680 2461542 2461542 defendant Monyngton Thomas esq 586214 586214 Monyngton, Thomas, of Webley, Herefs, esq 0
5356103 2461986 2461986 defendant Glover John glover 586214 586214 Glover, John, of Webley, Herefs, glover 1
5356109 2461987 2461987 defendant Glover John glover 586214 586214 Glover, John, of Webley, Herefs, glover 1
5357556 2462432 2462432 defendant Devereux Walter   586214 586214 Devereux, Walter, of Webley, Herefs, knight, Lord Ferrers 0
5381312 2469709 2469709 defendant Bulkyn Hugh hosier 586214 586214 Bulkyn, Hugh, of Webley, Herefs, hosier 2
5383080 2470232 2470232 defendant Sendre John chapman 586214 586214 Sendre, John, of Webley, Herefs, chapman 2
5394557 2473504 2473504 defendant Semere John chapman 586214 586214 Semere, John, of Webley, Herefs, chapman 1
5471477 2496416 2496416 defendant Devereux John   586214 586214 Devereux, John, of Webley, Herefs, knight 0
5493003 2502815 2502815 defendant Glover Richard chapman 586214 586214 Glover, Richard, of Webley, Herefs, chapman 4
5530331 2513998 2513998 defendant Abadam Thomas yeoman 586214 586214 Abadam, Thomas, of Webley, Herefs, yeoman 0
5606681 2536970 2536970 defendant Brugges Hames esq 586214 586214 Brugges, Hames, of Webley, Herefs, esq 2
5608859 2537671 2537671 defendant Bulkyn Hugh hosier 586214 586214 Bulkyn, Hugh, of Webley, Herefs, hosier 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);