names

33 rows where place_id = 586623

✎ 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
3589239 1864279 1864279 plaintiff Browne John   586623 586623 Browne, John, of Lyford 0
3612049 1871411 1871411 defendant Pynnell Roger husbandman 586623 586623 Pynnell, Roger, of Lyford, husbandman 0
4493110 2198546 2198546 defendant Curre John   586623 586623 Curre, John, of Lyford 0
4509604 2203479 2203479 defendant Wates John   586623 586623 Wates, John, of Lyford 0
4512297 2204285 2204285 defendant Choune John   586623 586623 Choune, John, of Lyford 0
4532569 2210452 2210452 defendant Janyns William   586623 586623 Janyns, William, of Lyford 0
4572307 2222881 2222881 defendant Cowedray Thomas   586623 586623 Cowedray, Thomas, of Lyford 0
4603739 2232355 2232355 defendant Kent Thomas   586623 586623 Kent, Thomas, of Lyford 0
4652450 2246715 2246715 defendant Wattys John husbandman 586623 586623 Wattys, John, of Lyford, husbandman 0
4658878 2248649 2248649 plaintiff Curre John   586623 586623 Curre, John, of Lyford 0
4722528 2272360 2272360 defendant Colles Robert husbandman 586623 586623 Colles, Robert, of Lyford, husbandman 2
4905483 2328311 2328311 plaintiff Tomelyns Thomas   586623 586623 Tomelyns, Thomas, of Lyford 0
5060067 2374577 2374577 defendant Tomlyns Thomas courser 586623 586623 Tomlyns, Thomas, of Lyford, courser 0
5060867 2374823 2374823 defendant Tomelyns Thomas courser 586623 586623 Tomelyns, Thomas, of Lyford, courser 0
5081187 2380879 2380879 defendant Chalers John   586623 586623 Chalers, John, of Lyford, knight 0
5084470 2381869 2381869 plaintiff Garston William   586623 586623 Garston, William, of Lyford 0
5102074 2387030 2387030 defendant Collys John   586623 586623 Collys, John, of Lyford, scofer or scoferer, servant 0
5127861 2394627 2394627 defendant Tomelyns Thomas shoemaker 586623 586623 Tomelyns, Thomas, of Lyford, shoemaker 0
5136316 2397142 2397142 defendant Lyford William yeoman 586623 586623 Lyford, William, of Lyford, yeoman 0
5166828 2406025 2406025 defendant Tomelyns Thomas   586623 586623 Tomelyns, Thomas, of Lyford, horse dealer 0
5192612 2413573 2413573 defendant Lyford William gent 586623 586623 Lyford, William, of Lyford, gent 0
5192614 2413574 2413574 defendant Lyford William yeoman 586623 586623 Lyford, William, of Lyford, yeoman 0
5220751 2421759 2421759 defendant Colles John courser 586623 586623 Colles, John, of Lyford, courser 0
5401821 2475583 2475583 defendant Lyford William yeoman 586623 586623 Lyford, William, of Lyford, yeoman 0
5454886 2491379 2491379 defendant Chalers Maud (legal representative) 586623 586623 Chalers, Maud, of Lyford, executors of 1
5454890 2491379 2491379 defendant Broun John yeoman 586623 586623 Broun, John, of Lyford, yeoman 5
5466715 2494992 2494992 defendant Bretin John yeoman 586623 586623 Bretin, John, of Lyford, yeoman 4
5531663 2514437 2514437 defendant Tubbe Richard husbandman 586623 586623 Tubbe, Richard, of Lyford, husbandman 0
5535831 2515712 2515712 plaintiff Broun John   586623 586623 Broun, John, of Lyford 0
5621380 2550578 2550578 defendant Mayde Henry   586623 586623 Mayde, Henry, of Lyford 0
5621381 2550578 2550578 defendant Herdeman Simon   586623 586623 Herdeman, Simon, of Lyford, son of John 1
5621382 2550578 2550578 defendant Kent John   586623 586623 Kent, John, of Lyford 2
5637025 2555527 2555527 defendant Coudray John gent 586623 586623 Coudray, John, of Lyford, gent 2

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