names

26 rows where place_id = 589489

✎ 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
3597776 1866922 1866922 defendant Cok Thomas husbandman 589489 589489 Cok, Thomas, of Bregge, husbandman 1
3597788 1866925 1866925 defendant Turvey Thomas yeoman 589489 589489 Turvey, Thomas, of Bregge, yeoman 0
3611426 1871250 1871250 defendant Turney Thomas yeoman 589489 589489 Turney, Thomas, of Bregge, yeoman 0
3674151 1917953 1917953 defendant Laurence Thomas gent 589489 589489 Laurence, Thomas, of Bregge, gent 0
3757872 1944441 1944441 defendant Forstall Walter laborer 589489 589489 Forstall, Walter, of Bregge, laborer 2
3791347 1955128 1955128 defendant Fortune Thomas smith 589489 589489 Fortune, Thomas, of Bregge, smith 2
3858856 1976450 1976450 defendant Hale Thomas husbandman 589489 589489 Hale, Thomas, of Bregge, husbandman 2
3858859 1976450 1976450 defendant Doughty John husbandman 589489 589489 Doughty, John, of Bregge, husbandman 5
3878052 1982903 1982903 defendant Cryppyng Thomas husbandman 589489 589489 Cryppyng, Thomas, of Bregge, husbandman 1
4487087 2196684 2196684 defendant Taillour Thomas   589489 589489 Taillour, Thomas, of Bregge 2
4552194 2216640 2216640 defendant Mathew John   589489 589489 Mathew, John, of Bregge Water 0
4724097 2272831 2272831 defendant Gate Wililam smith 589489 589489 (Gate, Wililam, of Bregge, smith 4
4724098 2272831 2272831 defendant Morton John husbandman 589489 589489 Morton, John, of Bregge, husbandman 5
4866297 2316426 2316426 defendant Bysshoppesdane Richard yeoman 589489 589489 Bysshoppesdane, Richard, of Bregge, yeoman 2
5266309 2435214 2435214 defendant Fooll Henry husbandman 589489 589489 Fooll, Henry, of Bregge, husbandman 6
5279651 2439128 2439128 defendant Turne Thomas husbandman 589489 589489 Turne, Thomas, of Bregge, husbandman 0
5279652 2439128 2439128 defendant Suthfolk Thomas husbandman 589489 589489 Suthfolk, Thomas, of Bregge, husbandman 1
5279786 2439171 2439171 defendant Blande William yeoman 589489 589489 Blande, William, of Bregge, yeoman 1
5279797 2439172 2439172 defendant Blande William yeoman 589489 589489 Blande, William, of Bregge, yeoman 5
5293112 2442969 2442969 defendant Blande William yeoman 589489 589489 Blande, William, of Bregge, yeoman 0
5319430 2450903 2450903 defendant Dobull John husbandman 589489 589489 Dobull, John, of Bregge, husbandman 3
5335774 2455765 2455765 defendant Elgore Richard yeoman 589489 589489 Elgore, Richard, of Bregge, yeoman 0
5514616 2509418 2509418 defendant Turney Thomas yeoman 589489 589489 Turney, Thomas, of Bregge, yeoman 0
5525863 2512680 2512680 defendant Turney Thomas yeoman 589489 589489 Turney, Thomas, of Bregge, yeoman 2
5597249 2534050 2534050 defendant Morton Richard husbandman 589489 589489 Morton, Richard, of Bregge, husbandman 0
5597250 2534050 2534050 defendant Cubbyng John husbandman 589489 589489 Cubbyng, John, of Bregge, husbandman 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);