names

31 rows where place_id = 597626

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3629239 1904013 1904013 defendant Lynwod William carpenter 597626 597626 Lynwod, William, of Cheveley, carpenter 1
3631259 1904592 1904592 defendant Everard William   597626 597626 Everard, William, of Cheveley 25
3669675 1916454 1916454 defendant Herbert William husbandman 597626 597626 Herbert, William, of Cheveley, husbandman 0
3680287 1919910 1919910 plaintiff Reve William   597626 597626 Reve, William, of Cheveley 0
3680288 1919910 1919910 defendant Wyborough Thomas husbandman 597626 597626 Wyborough, Thomas, of Cheveley, husbandman 0
3681451 1920286 1920286 defendant Cage John husbandman 597626 597626 Cage, John, of Cheveley, husbandman 0
3720286 1932623 1932623 defendant Lylly John yeoman 597626 597626 Lylly, John, of Cheveley, yeoman 1
3731663 1936132 1936132 defendant Galte Roger husbandman 597626 597626 Galte, Roger, of Cheveley, husbandman 0
3731665 1936133 1936133 defendant Galte Roger husbandman 597626 597626 Galte, Roger, of Cheveley, husbandman 0
3760037 1945135 1945135 defendant Glover Andrew husbandman 597626 597626 Glover, Andrew, of Cheveley, husbandman 3
3762815 1946007 1946007 defendant Cotton Leonard clerk 597626 597626 Cotton, Leonard, of Cheveley, Cumber, clerk 4
3770504 1948457 1948457 defendant Sylby Henry husbandman 597626 597626 Sylby, Henry, of Cheveley, husbandman 2
3784754 1953023 1953023 defendant Annysworth George chaplain 597626 597626 Annysworth, George, of Cheveley, chaplain 1
3797628 1957156 1957156 defendant Cotton Leonard clerk 597626 597626 Cotton, Leonard, of Cheveley, clerk 0
3801269 1958321 1958321 defendant Annysworth George chaplain 597626 597626 Annysworth, George, of Cheveley, chaplain 0
3808747 1960613 1960613 defendant Narborough Thomas husbandman 597626 597626 Narborough, Thomas, of Cheveley, husbandman 1
3812619 1961834 1961834 defendant Teversham William shoemaker 597626 597626 Teversham, William, of Cheveley, shoemaker 3
3833047 1968259 1968259 defendant Pocok William husbandman 597626 597626 Pocok, William, of Cheveley, husbandman 0
3833048 1968259 1968259 defendant Smyth Richard husbandman 597626 597626 Smyth, Richard, of Cheveley, husbandman 1
3844582 1971843 1971843 defendant Glover Thomas, senior laborer 597626 597626 Glover, Thomas, senior, of Cheveley, laborer 2
3894890 1988498 1988498 defendant Cadge Thomas husbandman 597626 597626 Cadge, Thomas, of Cheveley, husbandman 0
3924941 1998660 1998660 defendant Knat Robert laborer 597626 597626 Knat, Robert, of Cheveley, laborer 1
3925133 1998718 1998718 defendant Wymer John husbandman 597626 597626 Wymer, John, of Cheveley, husbandman 2
4023924 2033261 2033261 defendant Butterall William   597626 597626 Butterall, William, of Cheveley, shepherd 0
4763242 2284492 2284492 defendant Saundre John thatcher 597626 597626 Saundre, John, of Cheveley, thatcher 0
5282768 2440019 2440019 defendant Broun John husbandman 597626 597626 Broun, John, of Cheveley, husbandman 0
5301816 2445499 2445499 defendant Broun John husbandman 597626 597626 Broun, John, of Cheveley, husbandman 0
5328572 2453623 2453623 defendant Norbury John yeoman 597626 597626 Norbury, John, of Cheveley, yeoman 0
5362835 2464019 2464019 defendant Norbery John, junior yeoman 597626 597626 Norbery, John, junior, of Cheveley, yeoman 1
5378575 2468883 2468883 defendant Northbery John, senior husbandman 597626 597626 Northbery, John, senior, of Cheveley, husbandman 0
5596986 2533971 2533971 plaintiff Maryott John   597626 597626 Maryott, John, of Cheveley 1

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