names

23 rows where place_id = 658986

✎ 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
3950601 2007281 2007281 defendant Myller alias Erton James yeoman 658986 658986 Myller alias Erton, James, of Snytterton, yeoman 0
3963990 2012015 2012015 defendant Cranehowse John husbandman 658986 658986 Cranehowse, John, of Snytterton, husbandman 0
3963991 2012015 2012015 defendant Lewyn John husbandman 658986 658986 Lewyn, John, of Snytterton, husbandman 1
4009372 2028118 2028118 defendant Locke Thomas husbandman 658986 658986 Locke, Thomas, of Snytterton, husbandman 3
4009376 2028120 2028120 plaintiff Nedham Richard gent 658986 658986 Nedham, Richard, of Snytterton, gent 0
4021299 2032344 2032344 plaintiff Wylkyns George yeoman 658986 658986 Wylkyns, George, of Snytterton, yeoman 0
4021300 2032344 2032344 defendant Forde Thomas husbandman 658986 658986 Forde, Thomas, of Snytterton, husbandman 0
4021301 2032345 2032345 plaintiff Wylkyns George yeoman 658986 658986 Wylkyns, George, of Snytterton, yeoman 0
4021302 2032345 2032345 defendant Forde Thomas husbandman 658986 658986 Forde, Thomas, of Snytterton, husbandman 0
4053892 2043769 2043769 defendant Dabney Robert husbandman 658986 658986 Dabney, Robert, of Snytterton, husbandman 1
4072095 2050318 2050318 defendant Daubeney Robert yeoman 658986 658986 Daubeney, Robert, of Snytterton, yeoman 0
4146712 2077002 2077002 defendant Beales John butcher 658986 658986 Beales, John, of Snytterton, butcher 3
4169168 2084717 2084717 defendant Davye Robert yeoman 658986 658986 Davye, Robert, of Snytterton, yeoman 0
4189508 2091830 2091830 defendant Neale John husbandman 658986 658986 Neale, John, of Snytterton, husbandman 0
4228337 2105393 2105393 defendant Gawdye Thomas (legal representative) 658986 658986 Gawdye, Thomas, of Snytterton, esq, executrix of 0
4228338 2105393 2105393 defendant Gawdye Honor widow 658986 658986 Gawdye, Honor, of Snytterton, widow 1
4289397 2126266 2126266 defendant Appleyard Geoffrey husbandman 658986 658986 Appleyard, Geoffrey, of Snytterton, or of Rowdham, husbandman 0
4339480 2143576 2143576 defendant Thurban William glover 658986 658986 Thurban, William, of Snytterton, glover 0
4391079 2161635 2161635 defendant Thurborne William yeoman 658986 658986 Thurborne, William, of Snytterton, yeoman 3
4395196 2162982 2162982 defendant Lane John husbandman 658986 658986 Lane, John, of Snytterton, husbandman 2
4405799 2166506 2166506 defendant Thurbon William glover 658986 658986 Thurbon, William, of Snytterton, glover 3
5491381 2502311 2502311 defendant Lokwode William yeoman 658986 658986 Lokwode, William, of Snytterton, yeoman 0
5491382 2502311 2502311 defendant Elys Ralph yeoman 658986 658986 Elys, Ralph, of Snytterton, yeoman 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);