names

26 rows where place_id = 759948

✎ 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
4465789 2189971 2189971 plaintiff Wymundesham Robert de   759948 759948 Wymundesham, Robert de, of Great Boudon 0
4531515 2210135 2210135 defendant Person Richard   759948 759948 Person, Richard, of Great Boudon 0
4700252 2265494 2265494 defendant Veysy John husbandman 759948 759948 Veysy, John, of Great Boudon, husbandman 3
4707037 2267583 2267583 defendant atte More thomas husbandman 759948 759948 atte More, thomas, of Great Boudon, husbandman 0
4718130 2271010 2271010 defendant Bolton John   759948 759948 Bolton, John, of Great Boudon, wright 2
4742073 2278178 2278178 defendant Ingold Thomas husbandman 759948 759948 Ingold, Thomas, of Great Boudon, husbandman 2
4771340 2287019 2287019 defendant Basset John husbandman 759948 759948 Basset, John, of Great Boudon, husbandman 0
4771341 2287019 2287019 defendant Ingold Thomas husbandman 759948 759948 Ingold, Thomas, of Great Boudon, husbandman 1
4771342 2287019 2287019 defendant Person Thomas husbandman 759948 759948 Person, Thomas, of Great Boudon, husbandman 2
4771344 2287020 2287020 defendant Veysy John husbandman 759948 759948 Veysy, John, of Great Boudon, husbandman 0
4829810 2305369 2305369 defendant Harper William husbandman 759948 759948 Harper, William, of Great Boudon, husbandman 0
4829811 2305369 2305369 defendant Basset John husbandman 759948 759948 Basset, John, of Great Boudon, husbandman 1
4829812 2305369 2305369 defendant Ingold John, sen husbandman 759948 759948 Ingold, John, sen, of Great Boudon, husbandman 2
4829814 2305370 2305370 defendant Harper William husbandman 759948 759948 Harper, William, of Great Boudon, husbandman 0
4829815 2305370 2305370 defendant Basset John husbandman 759948 759948 Basset, John, of Great Boudon, husbandman 1
4829816 2305370 2305370 defendant Ingold John, sen husbandman 759948 759948 Ingold, John, sen, of Great Boudon, husbandman 2
4850097 2311489 2311489 defendant Clerk John husbandman 759948 759948 Clerk, John, of Great Boudon, husbandman 0
4850099 2311489 2311489 defendant Langton John   759948 759948 Langton, John, of Great Boudon, single man 2
4932801 2336645 2336645 defendant Mannyng William, senior husbandman 759948 759948 Mannyng, William, senior, of Great Boudon, husbandman 0
5039008 2368313 2368313 defendant Clerk Richard husbandman 759948 759948 Clerk, Richard, of Great Boudon, husbandman 0
5389475 2472040 2472040 defendant Harper Thomas husbandman 759948 759948 Harper, Thomas, of Great Boudon, husbandman 0
5393582 2473227 2473227 defendant Harper Thomas husbandman 759948 759948 Harper, Thomas, of Great Boudon, husbandman 0
5427607 2483212 2483212 defendant Harpar Robert husbandman 759948 759948 Harpar, Robert, of Great Boudon, husbandman 0
5427608 2483212 2483212 defendant Harpar William   759948 759948 Harpar, William, of Great Boudon, husbandman, son of Richard 1
5437297 2486099 2486099 defendant Saunderson John yeoman 759948 759948 Saunderson, John, of Great Boudon, yeoman 0
5440907 2487193 2487193 defendant Saunders John yeoman 759948 759948 Saunders, John, of Great Boudon, yeoman 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);