names

28 rows where place_id = 586585

✎ 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
3589100 1864239 1864239 defendant Chelmede Henry yeoman 586585 586585 Chelmede, Henry, of Mestham, yeoman 1
3705123 1927890 1927890 defendant Stevyn John husbandman 586585 586585 Stevyn, John, of Mestham, husbandman 1
4176197 2087150 2087150 defendant Mathewe Edward butterman 586585 586585 Mathewe, Edward, of Mestham, or of Wevelesfeld, butterman 1
4456268 2186982 2186982 plaintiff Neyland Thomas   586585 586585 Neyland, Thomas, of Mestham, parson 0
4512725 2204413 2204413 defendant Dene John   586585 586585 Dene, John, of Mestham 0
4522733 2207446 2207446 defendant Lyngefeld John   586585 586585 Lyngefeld, John, of Mestham 0
4625584 2238960 2238960 defendant Rydere William   586585 586585 Rydere, William, of Mestham 0
4775138 2288218 2288218 defendant Alcok John grocer 586585 586585 Alcok, John, of Mestham, husbandman, formerly of London, grocer 0
4784431 2291134 2291134 defendant Playstowe Walter husbandman 586585 586585 Playstowe, Walter, of Mestham, husbandman 1
4800932 2296481 2296481 defendant Alcok John grocer 586585 586585 Alcok, John, of Mestham, husbandman, or of London, grocer 0
4860664 2314697 2314697 defendant Ryder Peter husbandman 586585 586585 Ryder, Peter, of Mestham, husbandman 0
4887437 2322910 2322910 defendant Wylkyn William collier 586585 586585 Wylkyn, William, of Mestham, collier 0
4887438 2322910 2322910 defendant Stokker William husbandman 586585 586585 Stokker, William, of Mestham, husbandman 1
4996343 2355764 2355764 defendant Rolf Henry carpenter 586585 586585 Rolf, Henry, of Mestham, carpenter 0
5050693 2371834 2371834 plaintiff Killik Richard   586585 586585 Killik, Richard, of Mestham 1
5062254 2375271 2375271 defendant Tanner John husbandman 586585 586585 Tanner, John, of Mestham, husbandman 0
5081479 2380959 2380959 defendant Twyner Thomas husbandman 586585 586585 Twyner, Thomas, of Mestham, husbandman 0
5112658 2390090 2390090 defendant Tanner John husbandman 586585 586585 Tanner, John, of Mestham, husbandman 0
5393661 2473248 2473248 defendant Sharp John, junior smith 586585 586585 Sharp, John, junior, of Mestham, smith 1
5402514 2475788 2475788 defendant Wilson William laborer 586585 586585 Wilson, William, of Mestham, laborer 0
5415288 2479510 2479510 defendant Wilson William laborer 586585 586585 Wilson, William, of Mestham, laborer 0
5416431 2479834 2479834 defendant Tye John husbandman 586585 586585 Tye, John, of Mestham, husbandman 0
5416432 2479834 2479834 defendant Thorne Thomas husbandman 586585 586585 Thorne, Thomas, of Mestham, husbandman 1
5433258 2484911 2484911 defendant Tye John husbandman 586585 586585 Tye, John, of Mestham, husbandman 0
5433259 2484911 2484911 defendant Thorne William husbandman 586585 586585 Thorne, William, of Mestham, husbandman 1
5502824 2505794 2505794 defendant Ropkyn William husbandman 586585 586585 Ropkyn, William, of Mestham, husbandman 0
5502827 2505795 2505795 defendant Ropkyn William husbandman 586585 586585 Ropkyn, William, of Mestham, husbandman 0
5562736 2523687 2523687 plaintiff Wylkyn Roger (legal representative) 586585 586585 Wylkyn, Roger, of Mestham, husbandman, executors of 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);