names

19 rows where place_id = 627077

✎ 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
3774045 1949598 1949598 defendant Dun Bartholomew turner 627077 627077 Dun, Bartholomew, of Byllyngforth, turner 1
3774046 1949598 1949598 defendant Fuller John laborer 627077 627077 Fuller, John, of Byllyngforth, laborer 2
3774047 1949598 1949598 defendant Feltwell John pewterer 627077 627077 Feltwell, John, of Byllyngforth, pewterer 3
3800775 1958155 1958155 defendant Feltwell John pewterer 627077 627077 Feltwell, John, of Byllyngforth, pewterer 0
3860043 1976856 1976856 defendant Godfrey alias Perleston William glover 627077 627077 Godfrey alias Perleston, William, of Byllyngforth, glover 0
3864667 1978380 1978380 defendant Dyxe John butcher 627077 627077 Dyxe, John, of Byllyngforth, butcher 1
3893759 1988131 1988131 defendant Tolle John carpenter 627077 627077 Tolle, John, of Byllyngforth, carpenter 1
3969087 2013801 2013801 defendant Alleyn William husbandman 627077 627077 Alleyn, William, of Byllyngforth, husbandman 2
3982093 2018355 2018355 defendant Cleyborne John husbandman 627077 627077 Cleyborne, John, of Byllyngforth, husbandman 1
4001648 2025369 2025369 plaintiff Harper Christopher   627077 627077 Harper, Christopher, of Byllyngforth 0
4015022 2030073 2030073 defendant Selbey John husbandman 627077 627077 Selbey, John, of Byllyngforth, husbandman 14
4068438 2049009 2049009 defendant Davy Alexander miller 627077 627077 Davy, Alexander, of Byllyngforth, miller 2
4247550 2112169 2112169 defendant Francklyn William yeoman 627077 627077 Francklyn, William, of Byllyngforth, yeoman 0
4247554 2112170 2112170 defendant Francklyn William yeoman 627077 627077 Francklyn, William, of Byllyngforth, yeoman 0
4257864 2115605 2115605 defendant Francklyng Thomas yeoman 627077 627077 Francklyng, Thomas, of Byllyngforth, yeoman 1
5027276 2364850 2364850 defendant Chapman John smith 627077 627077 Chapman, John, of Byllyngforth, smith 0
5274903 2437746 2437746 defendant Curson Thomas gent 627077 627077 Curson, Thomas, of Byllyngforth, gent 0
5538791 2516617 2516617 defendant Haus or Hans John glover 627077 627077 Haus or Hans, John, of Byllyngforth, glover 0
5545769 2518753 2518753 defendant Kede William laborer 627077 627077 Kede, William, of Byllyngforth, laborer 4

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