names

73 rows where place_id = 590276

✎ 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
3600458 1867789 1867789 defendant Hall James husbandman 590276 590276 Hall, James, of West Wynche, husbandman 0
3603105 1868636 1868636 defendant Cobbe Robert husbandman 590276 590276 Cobbe, Robert, of West Wynche, husbandman 2
3697784 1925530 1925530 defendant Rysyng John husbandman 590276 590276 Rysyng, John, of West Wynche, husbandman 2
3697785 1925530 1925530 defendant Marham John husbandman 590276 590276 Marham, John, of West Wynche, husbandman 3
3779909 1951444 1951444 defendant Clerk Christopher chaplain 590276 590276 Clerk, Christopher, of West Wynche, chaplain 3
3872307 1980962 1980962 defendant Smyth John husbandman 590276 590276 Smyth, John, of West Wynche, husbandman 0
3880556 1983756 1983756 defendant Baker Henry husbandman 590276 590276 Baker, Henry, of West Wynche, husbandman 0
3938568 2003242 2003242 defendant Browne Richard husbandman 590276 590276 Browne, Richard, of West Wynche, husbandman 0
3938579 2003246 2003246 defendant Browne Richard husbandman 590276 590276 Browne, Richard, of West Wynche, husbandman 0
3944511 2005180 2005180 plaintiff Bastard Francis gent 590276 590276 Bastard, Francis, of West Wynche, gent 0
3988518 2020637 2020637 defendant Reade Roger laborer 590276 590276 Reade, Roger, of West Wynche, laborer 1
3989660 2021047 2021047 defendant Matlys John yeoman 590276 590276 Matlys, John, of West Wynche, yeoman 0
3989661 2021047 2021047 defendant Curten Nicholas husbandman 590276 590276 Curten, Nicholas, of West Wynche, husbandman 1
3989742 2021074 2021074 defendant Lucke William yeoman 590276 590276 Lucke, William, of West Wynche, or of South Lynnes, yeoman 0
3991165 2021598 2021598 defendant Byrde John yeoman 590276 590276 Byrde, John, of West Wynche, yeoman 0
3995721 2023215 2023215 plaintiff Cropper Thomas gent 590276 590276 Cropper, Thomas, of West Wynche, gent 0
4003819 2026131 2026131 defendant Cropp or Cropper Thomas gent 590276 590276 Cropp or Cropper, Thomas, of West Wynche, gent 0
4012724 2029274 2029274 defendant Apprychard Thomas yeoman 590276 590276 Apprychard, Thomas, of West Wynche, yeoman 0
4014881 2030037 2030037 defendant Matlasse John, senior yeoman 590276 590276 Matlasse, John, senior, of West Wynche, yeoman 0
4053307 2043558 2043558 defendant Motley John husbandman 590276 590276 Motley, John, of West Wynche, husbandman 1
4055415 2044332 2044332 defendant Cropper Thomas gent 590276 590276 Cropper, Thomas, of West Wynche, gent 3
4069044 2049220 2049220 defendant Motley John yeoman 590276 590276 Motley, John, of West Wynche, yeoman 2
4083851 2054497 2054497 defendant Cropper Margaret widow 590276 590276 Cropper, Margaret, of West Wynche, widow 0
4083938 2054532 2054532 defendant Basterd Francis gent 590276 590276 Basterd, Francis, of West Wynche, gent 0
4084825 2054848 2054848 defendant Matlesse John yeoman 590276 590276 Matlesse, John, of West Wynche, yeoman 0
4084831 2054849 2054849 defendant Stonar Richard   590276 590276 Stonar, Richard, of West Wynche, rough mason 2
4094160 2058243 2058243 defendant Matlesse John yeoman 590276 590276 Matlesse, John, of West Wynche, yeoman 0
4113117 2064961 2064961 defendant Roberd alias Robyns Thomas husbandman 590276 590276 Roberd alias Robyns, Thomas, of West Wynche, husbandman 0
4113119 2064961 2064961 defendant Barker John husbandman 590276 590276 Barker, John, of West Wynche, husbandman 2
4132104 2071793 2071793 defendant Parkyn John husbandman 590276 590276 Parkyn, John, of West Wynche, husbandman 0
4134434 2072646 2072646 defendant Stonner Thomas   590276 590276 Stonner, Thomas, of West Wynche, mason 0
4143722 2075962 2075962 defendant Stonard Thomas bricklayer 590276 590276 Stonard, Thomas, of West Wynche, bricklayer 1
4146335 2076867 2076867 defendant Cleybrooke John husbandman 590276 590276 Cleybrooke, John, of West Wynche, husbandman 0
4155886 2080137 2080137 defendant Parkyn John husbandman 590276 590276 Parkyn, John, of West Wynche, husbandman 0
4156237 2080255 2080255 defendant Ellys Robert tailor 590276 590276 Ellys, Robert, of West Wynche, tailor 0
4195099 2093849 2093849 defendant Motley John husbandman 590276 590276 Motley, John, of West Wynche, husbandman 0
4197610 2094720 2094720 defendant Matlys John husbandman 590276 590276 Matlys, John, of West Wynche, husbandman 0
4197690 2094749 2094749 defendant Matlys John yeoman 590276 590276 Matlys, John, of West Wynche, yeoman 0
4205838 2097588 2097588 defendant Stonner Thomas   590276 590276 Stonner, Thomas, of West Wynche, mason 0
4381903 2158631 2158631 defendant Levett Edmund yeoman 590276 590276 Levett, Edmund, of West Wynche, yeoman 0
4381907 2158633 2158633 defendant Reymonde Francis yeoman 590276 590276 Reymonde, Francis, of West Wynche, or of Stowe Bardwell, yeoman 0
4398407 2164049 2164049 defendant Blesbye Thomas yeoman 590276 590276 Blesbye, Thomas, of West Wynche, yeoman 0
4740908 2277851 2277851 defendant Clerk Thomas laborer 590276 590276 Clerk, Thomas, of West Wynche, laborer 14
4782475 2290528 2290528 defendant Ryall Walter yeoman 590276 590276 Ryall, Walter, of West Wynche, yeoman 0
4798478 2295705 2295705 defendant Wyot Thomas yeoman 590276 590276 Wyot, Thomas, of West Wynche, yeoman 2
4811311 2299647 2299647 defendant Mannyng William husbandman 590276 590276 Mannyng, William, of West Wynche, husbandman 1
5047012 2370730 2370730 plaintiff Nicolasson John   590276 590276 Nicolasson, John, of West Wynche 0
5047017 2370730 2370730 defendant Taillour alias Wareyn John husbandman 590276 590276 Taillour alias Wareyn, John, of West Wynche, husbandman 4
5062417 2375326 2375326 defendant Nycholas John husbandman 590276 590276 Nycholas, John,of West Wynche, husbandman 0
5066957 2376642 2376642 defendant Ivys Richard husbandman 590276 590276 Ivys, Richard, of West Wynche, husbandman 2
5069222 2377287 2377287 defendant Necholas John yeoman 590276 590276 Necholas, John, of West Wynche, yeoman 0
5069232 2377288 2377288 defendant Necholas John yeoman 590276 590276 Necholas, John, of West Wynche, yeoman 0
5199753 2415676 2415676 defendant Nicollas John husbandman 590276 590276 Nicollas, John, of West Wynche, husbandman 0
5199754 2415676 2415676 defendant Elyse Thomas husbandman 590276 590276 Elyse, Thomas, of West Wynche, husbandman 1
5200033 2415761 2415761 defendant Nicollas John husbandman 590276 590276 Nicollas, John, of West Wynche, husbandman 0
5211216 2419009 2419009 defendant Ausyn Richard clerk 590276 590276 Ausyn, Richard, of West Wynche, clerk 0
5217175 2420759 2420759 defendant Aufyn or Anfyn Richard clerk 590276 590276 Aufyn or Anfyn, Richard, of West Wynche, clerk 0
5266642 2435320 2435320 defendant Lawys Thomas husbandman 590276 590276 Lawys, Thomas, of West Wynche, husbandman 2
5282831 2440040 2440040 defendant Greneacre John yeoman 590276 590276 Greneacre, John, of West Wynche, yeoman 0
5282832 2440040 2440040 defendant Baker John husbandman 590276 590276 Baker, John, of West Wynche, husbandman 1
5282833 2440040 2440040 defendant Dolman Richard husbandman 590276 590276 Dolman, Richard, of West Wynche, husbandman 2
5282835 2440040 2440040 defendant Stangame or Stangaine John laborer 590276 590276 Stangame or Stangaine, John, of West Wynche, laborer 4
5282839 2440041 2440041 defendant Greneacre John yeoman 590276 590276 together with Greneacre, John, of West Wynche, yeoman 1
5282840 2440041 2440041 defendant Baker John husbandman 590276 590276 Baker, John, of West Wynche, husbandman 2
5282841 2440041 2440041 defendant Dolman Richard husbandman 590276 590276 Dolman, Richard, of West Wynche, husbandman 3
5282843 2440041 2440041 defendant Stangame or Stangaine John laborer 590276 590276 Stangame or Stangaine, John, of West Wynche, laborer 5
5290791 2442311 2442311 defendant Whyte Robert   590276 590276 Whyte, Robert, of West Wynche, husbandma 3
5393017 2473074 2473074 defendant Wythe Robert husbandman 590276 590276 Wythe, Robert, of West Wynche, husbandman 0
5406149 2476837 2476837 defendant Whyte Thomas husbandman 590276 590276 Whyte, Thomas, of West Wynche, husbandman 1
5470199 2496003 2496003 defendant Shotesham John husbandman 590276 590276 Shotesham, John, of West Wynche, husbandman 3
5527693 2513242 2513242 defendant Walpole Thomas husbandman 590276 590276 Walpole, Thomas, of West Wynche, husbandman 3
5586348 2530772 2530772 defendant Complyn John husbandman 590276 590276 Complyn, John, of West Wynche, husbandman 0
5586350 2530773 2530773 defendant Complyn John husbandman 590276 590276 Complyn, John, of West Wynche, husbandman 0

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