names

20 rows where place_id = 677455

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4027017 2034310 2034310 defendant Morres Thomas husbandman 677455 677455 Morres, Thomas, of Terryngton St John, husbandman 3
4027021 2034311 2034311 defendant Morrys Thomas husbandman 677455 677455 Morrys, Thomas, of Terryngton St John, husbandman 2
4033760 2036726 2036726 defendant Morrys Thomas husbandman 677455 677455 Morrys, Thomas, of Terryngton St John, husbandman 0
4047205 2041450 2041450 defendant Lynghoke George yeoman 677455 677455 Lynghoke, George, of Terryngton St John, yeoman 0
4047212 2041452 2041452 defendant Lynghooke george yeoman 677455 677455 Lynghooke, george, of Terryngton St John, yeoman 0
4056847 2044830 2044830 defendant Walbott alias Thacker Thomas husbandman or thatcher 677455 677455 Walbott alias Thacker, Thomas, of Terryngton St John, husbandman or thatcher 0
4066487 2048306 2048306 defendant Shrymplyn Edmund husbandman 677455 677455 Shrymplyn, Edmund, of Terryngton St John, husbandman 1
4066490 2048307 2048307 defendant Cannon William laborer 677455 677455 Cannon, William, of Terryngton St John, laborer 1
4069042 2049220 2049220 defendant Walbott Thomas yeoman 677455 677455 Walbott, Thomas, of Terryngton St John, yeoman 0
4079865 2053099 2053099 defendant Wynck John husbandman 677455 677455 Wynck, John, of Terryngton St John, husbandman 5
4101870 2060979 2060979 defendant Cowper Richard husbandman 677455 677455 Cowper, Richard, of Terryngton St John, husbandman 0
4101871 2060979 2060979 defendant Boston alias Tyler John husbandman 677455 677455 Boston alias Tyler, John, of Terryngton St John, husbandman 1
4163359 2082710 2082710 defendant Tyler alias Boston John husbandman 677455 677455 Tyler alias Boston, John, of Terryngton St John, husbandman 0
4163365 2082712 2082712 defendant Tyler alias Boston John husbandman 677455 677455 Tyler alias Boston, John, of Terryngton St John, husbandman 0
4208864 2098646 2098646 defendant Ferrar Robert chapman 677455 677455 Ferrar, Robert, of Terryngton St John, chapman 0
4212750 2100000 2100000 defendant Whyncke John yeoman 677455 677455 Whyncke, John, of Terryngton St John, yeoman 0
4213600 2100277 2100277 defendant Layne Thomas clerk 677455 677455 Layne, Thomas, of Terryngton St John, clerk 1
4281620 2123478 2123478 defendant May Henry husbandman 677455 677455 May, Henry, of Terryngton St John, husbandman 2
4333847 2141605 2141605 defendant Robynson John husbandman 677455 677455 Robynson, John, of Terryngton St John, husbandman 1
4333848 2141605 2141605 defendant Pelleom John husbandman 677455 677455 Pelleom, John, of Terryngton St John, husbandman 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);