names

47 rows where place_id = 595966

✎ 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
3600237 1867721 1867721 defendant Barbour Thomas   595966 595966 Barbour, Thomas, of Mochelney, mason 0
3622555 1874590 1874590 defendant Wales Thomas husbandman 595966 595966 Wales, Thomas, of Mochelney, husbandman 0
3907289 1992731 1992731 defendant Woodes John butcher 595966 595966 Woodes, John, of Mochelney, butcher 0
3910915 1993973 1993973 defendant Vyncent John butcher 595966 595966 Vyncent, John, of Mochelney, butcher 0
3910916 1993973 1993973 defendant Whyte John butcher 595966 595966 Whyte, John, of Mochelney, butcher 1
3948012 2006368 2006368 defendant Vyncent John yeoman 595966 595966 Vyncent, John, of Mochelney, yeoman 0
4056472 2044699 2044699 defendant Prygge John husbandman 595966 595966 Prygge, John, of Mochelney, husbandman 0
4056473 2044699 2044699 defendant Nayshe Roger husbandman 595966 595966 Nayshe, Roger, of Mochelney, husbandman 1
4062188 2046764 2046764 defendant Seward Edward gent 595966 595966 Seward, Edward, of Mochelney, gent 3
4105460 2062230 2062230 defendant Smythe Robert gent 595966 595966 Smythe, Robert, of Mochelney, gent 0
4105461 2062230 2062230 defendant Smythe John gent 595966 595966 Smythe, John, of Mochelney, gent 1
4111955 2064525 2064525 defendant Wood John yeoman 595966 595966 Wood, John, of Mochelney, yeoman 1
4124093 2068914 2068914 defendant Nashe Roger butcher 595966 595966 Nashe, Roger, of Mochelney, butcher 0
4124096 2068914 2068914 defendant Vyncent Margery widow 595966 595966 Vyncent, Margery, of Mochelney, widow 3
4124098 2068914 2068914 defendant Wayott Gartwrita widow 595966 595966 Wayott, Gartwrita, of Mochelney, widow 5
4124100 2068915 2068915 defendant Prygge John yeoman 595966 595966 Prygge, John, of Mochelney, yeoman 0
4134741 2072753 2072753 defendant Kynge Mary spinster 595966 595966 Kynge, Mary, of Mochelney, spinster 1
4134742 2072753 2072753 defendant Prygge John yeoman 595966 595966 Prygge, John, of Mochelney, yeoman 2
4134959 2072823 2072823 defendant Smyth Robert yeoman 595966 595966 Smyth, Robert, of Mochelney, yeoman 0
4134993 2072836 2072836 defendant Smythe Robert yeoman 595966 595966 Smythe, Robert, of Mochelney, yeoman 0
4189302 2091753 2091753 defendant Cley Thomas butcher 595966 595966 Cley, Thomas, of Mochelney, butcher 1
4206436 2097794 2097794 defendant Smythe Robert yeoman 595966 595966 Smythe, Robert, of Mochelney, yeoman 0
4243375 2110775 2110775 defendant Cley Edith   595966 595966 Cley, Edith, of Mochelney, widow, their mother 2
4253721 2114236 2114236 defendant Cley Thomas, junior   595966 595966 Cley, Thomas, junior, of Mochelney, butcher, his brother 1
4260781 2116569 2116569 defendant Cley John butcher 595966 595966 Cley, John, of Mochelney, butcher 0
4280425 2123061 2123061 defendant Smyth Robert gent 595966 595966 Smyth, Robert, of Mochelney, gent 0
4284725 2124585 2124585 defendant Smyth Robert gent 595966 595966 Smyth, Robert, of Mochelney, gent 0
4286852 2125354 2125354 defendant Waters William laborer 595966 595966 Waters, William, of Mochelney, laborer 1
4322438 2137916 2137916 defendant Goolde John husbandman 595966 595966 Goolde, John, of Mochelney, husbandman 0
4365306 2152656 2152656 defendant Smythe Robert gent 595966 595966 Smythe, Robert, of Mochelney, gent 0
4365308 2152657 2152657 defendant Smythe Robert gent 595966 595966 Smythe, Robert, of Mochelney, gent 0
4379601 2157796 2157796 defendant Balye John husbandman 595966 595966 Balye, John, of Mochelney, husbandman 0
4403610 2165783 2165783 defendant Cley Thomas husbandman 595966 595966 Cley, Thomas, of Mochelney, husbandman 0
4403611 2165783 2165783 defendant Cheeke alias Chick John butcher 595966 595966 Cheeke alias Chick, John, of Mochelney, husbandman, or of Ileton, butcher 1
4595607 2229891 2229891 defendant White John   595966 595966 White, John, of Mochelney 0
4606443 2233126 2233126 defendant Lowe John   595966 595966 Lowe, John, of Mochelney 4
4629780 2240235 2240235 plaintiff Splyte Robert   595966 595966 Splyte, Robert, of Mochelney 0
4789060 2292633 2292633 defendant Crese John husbandman 595966 595966 Crese, John, of Mochelney, husbandman 1
4966884 2347021 2347021 defendant Cleve William husbandman 595966 595966 Cleve, William, of Mochelney, husbandman 0
5000269 2356956 2356956 defendant Stylard John carpenter 595966 595966 Stylard, John, of Mochelney, carpenter 0
5054866 2373022 2373022 defendant Cleve William husbandman 595966 595966 Cleve, William, of Mochelney, husbandman 0
5319334 2450877 2450877 defendant Bolour Thomas gent 595966 595966 Bolour, Thomas, of Mochelney, gent 0
5426651 2482918 2482918 defendant Hichecok Robert husbandman 595966 595966 Hichecok, Robert, of Mochelney, husbandman 0
5487316 2501107 2501107 defendant Huysshcock Robert   595966 595966 Huysshcock, Robert, of Mochelney, groom 0
5487317 2501107 2501107 defendant Dullock John   595966 595966 Dullock, John, of Mochelney, mason 1
5487318 2501107 2501107 defendant Hopkyns John husbandman 595966 595966 Hopkyns, John, of Mochelney, husbandman 2
5503667 2506060 2506060 defendant Mason John   595966 595966 Mason, John, of Mochelney, mason 3

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