names

19 rows where place_id = 591424

✎ 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
3604368 1869034 1869034 defendant Deke John husbandman 591424 591424 Deke, John, of Twynsted, husbandman 0
3626316 1903088 1903088 defendant Russhey John husbandman 591424 591424 Russhey, John, of Twynsted, husbandman 0
3626317 1903088 1903088 defendant Vice Richard husbandman 591424 591424 Vice, Richard, of Twynsted, husbandman 1
3633383 1905253 1905253 defendant Heyward Robert husbandman 591424 591424 Heyward, Robert, of Twynsted, husbandman 0
3633386 1905254 1905254 defendant Stele Christopher clerk 591424 591424 Stele, Christopher, of Twynsted, clerk 0
3638876 1906982 1906982 defendant Russhey John husbandman 591424 591424 Russhey, John, of Twynsted, husbandman 0
3737870 1938063 1938063 defendant Russhey John husbandman 591424 591424 Russhey, John, of Twynsted, or of Bulmer, Essex, husbandman 0
3972925 2015104 2015104 defendant Wylson Anthony yeoman 591424 591424 Wylson, Anthony, of Twynsted, yeoman 3
3988083 2020481 2020481 defendant Barker Hugh yeoman 591424 591424 Barker, Hugh, of Twynsted, yeoman, son of John Barker, of Twynsted, yeoman 0
3992794 2022175 2022175 defendant Fitz John gent 591424 591424 Fitz, John, of Twynsted, gent 0
3992795 2022175 2022175 defendant Turner William yeoman 591424 591424 Turner, William, of Twynsted, yeoman 1
4007342 2027408 2027408 defendant Turner William yeoman 591424 591424 Turner, William, of Twynsted, yeoman 0
4020529 2032067 2032067 defendant Johnson Christopher clerk 591424 591424 Johnson, Christopher, of Twynsted, clerk 0
4026026 2033954 2033954 defendant Fytz John gent 591424 591424 Fytz, John, of Twynsted, gent 0
4026027 2033954 2033954 defendant Turner William yeoman 591424 591424 Turner, William, of Twynsted, yeoman 1
5028756 2365285 2365285 defendant Aleyn John husbandman 591424 591424 Aleyn, John, of Twynsted, husbandman 6
5104251 2387667 2387667 defendant Bokenham Roger husbandman 591424 591424 Bokenham, Roger, of Twynsted, husbandman 0
5121386 2392687 2392687 defendant Bokenham Roger husbandman 591424 591424 Bokenham, Roger, of Twynsted, husbandman 1
5523797 2512263 2512263 defendant Shert Edmund clerk 591424 591424 Shert, Edmund, of Twynsted, clerk 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);