names

32 rows where place_id = 592387

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3607556 1870021 1870021 defendant Bunnyng John, senior yeoman 592387 592387 Bunnyng, John, senior, of Denton, Norf, yeoman 0
3920744 1997285 1997285 defendant Kyppyng Richard husbandman 592387 592387 Kyppyng, Richard, of Denton, Norf, husbandman 2
3984187 2019110 2019110 defendant Bunnynge Thomas yeoman 592387 592387 Bunnynge, Thomas, of Denton, Norf, yeoman 0
3996976 2023686 2023686 defendant Bonnyng Thomas yeoman 592387 592387 Bonnyng, Thomas, of Denton, Norf, yeoman 1
3999017 2024407 2024407 defendant Warner Thomas husbandman 592387 592387 Warner, Thomas, of Denton, Norf, husbandman 0
3999026 2024411 2024411 plaintiff Foxe Nicholas yeoman 592387 592387 Foxe, Nicholas, of Denton, Norf, or of Mendham, Suff, yeoman 0
4008541 2027819 2027819 defendant Bonyng Thomas yeoman 592387 592387 Bonyng, Thomas, of Denton, Norf, yeoman 0
4016586 2030637 2030637 defendant Bunynge Richard yeoman 592387 592387 Bunynge, Richard, of Denton, Norf, yeoman 0
4016588 2030638 2030638 defendant Bunynge Thomas yeoman 592387 592387 Bunynge, Thomas, of Denton, Norf, yeoman 0
4016594 2030640 2030640 defendant Tyght Robert husbandman 592387 592387 Tyght, Robert, of Denton, Norf, husbandman 0
4017855 2031097 2031097 defendant Bonnyng Thomas yeoman 592387 592387 Bonnyng, Thomas, of Denton, Norf, yeoman 0
4017857 2031098 2031098 defendant Tyte Robert, senior yeoman 592387 592387 Tyte, Robert, senior, of Denton, Norf, yeoman 0
4106812 2062730 2062730 defendant Ingoll Christopher joiner 592387 592387 Ingoll, Christopher, of Denton, Norf, joiner 1
4139844 2074614 2074614 defendant Sparham Richard, senior yeoman 592387 592387 Sparham, Richard, senior, of Denton, Norf, yeoman 0
4169827 2084944 2084944 defendant Langerwoode Arthur yeoman 592387 592387 Langerwoode, Arthur, of Denton, Norf, yeoman 0
4256689 2115211 2115211 defendant Porter John clerk 592387 592387 Porter, John, of Denton, Norf, clerk 1
4268955 2119214 2119214 defendant Perter John clerk 592387 592387 Perter, John, of Denton, Norf, clerk 1
4341155 2144180 2144180 defendant Buninge Thomas yeoman 592387 592387 Buninge, Thomas, of Denton, Norf, yeoman 0
4341162 2144181 2144181 defendant Warner Arthur yeoman 592387 592387 Warner, Arthur, of Denton, Norf, yeoman 2
4674445 2257617 2257617 defendant Holm John clerk 592387 592387 (Holm, John, of Denton, Norf, clerk 2
4856200 2313314 2313314 defendant Gray Geoffrey gent 592387 592387 Gray, Geoffrey, of Denton, Norf, gent 0
4856204 2313315 2313315 defendant Gray Geoffrey gent 592387 592387 Gray, Geoffrey, of Denton, Norf, gent 0
4869361 2317386 2317386 defendant Grey Geoffrey gent 592387 592387 (Grey, Geoffrey, of Denton, Norf, gent 1
4972727 2348779 2348779 defendant Tyte Nicholas husbandman 592387 592387 Tyte, Nicholas, of Denton, Norf, husbandman 0
5007961 2359218 2359218 defendant Belward Walter yeoman 592387 592387 Belward, Walter, of Denton, Norf, yeoman 1
5055891 2373328 2373328 defendant Vergeous William gent 592387 592387 Vergeous, William, of Denton, Norf, gent 0
5055894 2373329 2373329 defendant Vergeous William gent 592387 592387 Vergeous, William, of Denton, Norf, gent 0
5055897 2373330 2373330 defendant Vergeous William gent 592387 592387 Vergeous, William, of Denton, Norf, gent 0
5059855 2374513 2374513 defendant Belward Walter yeoman 592387 592387 Belward, Walter, of Denton, Norf, yeoman 3
5073131 2378451 2378451 defendant Vergeous William gent 592387 592387 Vergeous, William, of Denton, Norf, gent 0
5128192 2394720 2394720 defendant Grey Geoffrey gent 592387 592387 Grey, Geoffrey, of Denton, Norf, gent 0
5474774 2497437 2497437 defendant Bunnyng John, sen yeoman 592387 592387 Bunnyng, John, sen, of Denton, Norf, 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);