names

24 rows where place_id = 758649

✎ 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
4455688 2186791 2186791 plaintiff Morland Peter de   758649 758649 Morland, Peter de, of Kirkeby Stephan, vicar 0
4455690 2186792 2186792 plaintiff Morland Peter de   758649 758649 Morland, Peter de, of Kirkeby Stephan, vicar 0
4455696 2186793 2186793 plaintiff Morland Peter de   758649 758649 Morland, Peter de, of Kirkeby Stephan, vicar 0
4455725 2186802 2186802 plaintiff Morolf John   758649 758649 Morolf, John, of Kirkeby Stephan 0
4506941 2202644 2202644 plaintiff Urry William   758649 758649 Urry, William, of Kirkeby Stephan 0
4525880 2208393 2208393 plaintiff Kelynghale John   758649 758649 Kelynghale, John, of Kirkeby Stephan, vicar 0
4566498 2221089 2221089 defendant Idesdale John   758649 758649 Idesdale, John, of Kirkeby Stephan 1
4655216 2247516 2247516 defendant Bredeman William husbandman 758649 758649 Bredeman, William, of Kirkeby Stephan, husbandman 0
4657305 2248175 2248175 defendant Moreland Thomas yeoman 758649 758649 Moreland, Thomas, of Kirkeby Stephan, yeoman 1
4657306 2248175 2248175 defendant Bredeman William yeoman 758649 758649 Bredeman, William, of Kirkeby Stephan, yeoman 2
4659237 2248759 2248759 defendant Alenbrig Thomas   758649 758649 Alenbrig, Thomas, of Kirkeby Stephan 3
4722137 2272251 2272251 defendant Tuke William yeoman 758649 758649 Tuke, William, of Kirkeby Stephan, yeoman 0
4822311 2303058 2303058 defendant Malson William yeoman 758649 758649 Malson, William, of Kirkeby Stephan, yeoman 1
4862385 2315243 2315243 defendant Tarran Thomas yeoman 758649 758649 Tarran, Thomas, of Kirkeby Stephan, yeoman 3
4872286 2318292 2318292 defendant Morland William yeoman 758649 758649 Morland, William, of Kirkeby Stephan, yeoman 0
4876577 2319640 2319640 plaintiff Smyth Thomas, junior   758649 758649 Smyth, Thomas, junior, of Kirkeby Stephan 0
4876578 2319640 2319640 defendant Farleton John chapman 758649 758649 Farleton, John, of Kirkeby Stephan, chapman 0
4876579 2319640 2319640 defendant Bysshop Thomas chaplain 758649 758649 Bysshop, Thomas, of Kirkeby Stephan, chaplain 1
4879924 2320635 2320635 defendant Booste John yeoman 758649 758649 Booste, John, of Kirkeby Stephan, yeoman 0
5066501 2376508 2376508 defendant Heynmare John cordwainer 758649 758649 Heynmare, John, of Kirkeby Stephan, cordwainer 0
5066502 2376508 2376508 defendant Johnson Robert cordwainer 758649 758649 Johnson, Robert, of Kirkeby Stephan, cordwainer 1
5089200 2383211 2383211 defendant Leek William yeoman 758649 758649 Leek, William, of Kirkeby Stephan, yeoman 0
5624103 2551487 2551487 defendant Taran William yeoman 758649 758649 Taran, William, of Kirkeby Stephan, yeoman 0
5624104 2551487 2551487 defendant Bradbelt John laborer 758649 758649 Bradbelt, John, of Kirkeby Stephan, laborer 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);