names

31 rows where place_id = 601114

✎ 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
3643914 1908528 1908528 defendant Alger Richard husbandman 601114 601114 Alger, Richard, of Kyrton in Holand, husbandman 0
3661149 1913765 1913765 defendant Pooles Roger gent 601114 601114 Pooles, Roger, of Kyrton in Holand, gent 1
4040197 2038996 2038996 defendant Grene John husbandman 601114 601114 Grene, John, of Kyrton in Holand, husbandman 0
4889641 2323556 2323556 defendant Potoke John husbandman 601114 601114 Potoke, John, of Kyrton in Holand, husbandman 4
4889642 2323556 2323556 defendant Potoke Elizabeth singlewoman 601114 601114 Potoke, Elizabeth, of Kyrton in Holand, singlewoman 5
4889643 2323556 2323556 defendant Williamson John Jonson husbandman 601114 601114 Williamson, John Jonson, of Kyrton in Holand, husbandman 6
4889644 2323556 2323556 defendant Stevenet Agnes husbandman 601114 601114 Stevenet, Agnes, of Kyrton in Holand, husbandman 7
4889645 2323556 2323556 defendant Cokkewell Margaret widow 601114 601114 Cokkewell, Margaret, of Kyrton in Holand, widow 8
4889646 2323556 2323556 defendant Wylson Alice widow 601114 601114 Wylson, Alice, of Kyrton in Holand, widow 9
4889647 2323556 2323556 defendant John son of Peresson Richard husbandman 601114 601114 John son of Peresson, Richard, of Kyrton in Holand, husbandman 10
4889648 2323556 2323556 defendant Peke Mary widow 601114 601114 Peke, Mary, of Kyrton in Holand, widow 11
4889649 2323556 2323556 defendant Boson Lambert husbandman 601114 601114 Boson, Lambert, of Kyrton in Holand, husbandman 12
4889650 2323556 2323556 defendant Frankes Richard husbandman 601114 601114 Frankes, Richard, of Kyrton in Holand, husbandman 13
4908990 2329356 2329356 defendant Hughson Robert husbandman 601114 601114 Hughson, Robert, of Kyrton in Holand, husbandman 1
4938854 2338543 2338543 plaintiff Cobuldyke John   601114 601114 Cobuldyke, John, of Kyrton in Holand 0
5030643 2365832 2365832 defendant Lytelbury Robert esq 601114 601114 Lytelbury, Robert, of Kyrton in Holand, esq 4
5073254 2378488 2378488 defendant Warner William husbandman 601114 601114 Warner, William, of Kyrton in Holand, husbandman 2
5079350 2380322 2380322 defendant May John husbandman 601114 601114 May, John, of Kyrton in Holand, husbandman 0
5079351 2380322 2380322 defendant Miller Thomas husbandman 601114 601114 Miller, Thomas, of Kyrton in Holand, husbandman 1
5092217 2384103 2384103 defendant Meres Alan gent 601114 601114 Meres, Alan, of Kyrton in Holand, gent 0
5184088 2411081 2411081 defendant Cony John husbandman 601114 601114 Cony, John, of Kyrton in Holand, husbandman 4
5189816 2412767 2412767 defendant Malteby Thomas yeoman 601114 601114 Malteby, Thomas, of Kyrton in Holand, yeoman 2
5189821 2412768 2412768 defendant Malteby Thomas   601114 601114 Malteby, Thomas, of Kyrton in Holand 2
5204151 2416967 2416967 defendant Cony John husbandman 601114 601114 Cony, John, of Kyrton in Holand, husbandman 4
5206675 2417688 2417688 defendant Malteby Thomas yeoman 601114 601114 Malteby, Thomas, of Kyrton in Holand, yeoman 2
5215986 2420403 2420403 defendant Eland John husbandman 601114 601114 Eland, John, of Kyrton in Holand, husbandman 3
5215987 2420403 2420403 defendant Stalworth William husbandman 601114 601114 Stalworth, William, of Kyrton in Holand, husbandman 4
5374436 2467611 2467611 defendant Barneby Peter husbandman 601114 601114 Barneby, Peter, of Kyrton in Holand, husbandman 0
5374440 2467611 2467611 defendant Grene Elizabeth widow 601114 601114 Grene, Elizabeth, of Kyrton in Holand, widow 4
5393884 2473312 2473312 defendant G_ Thomas yeoman 601114 601114 G_, Thomas, of Kyrton in Holand, yeoman 3
5450373 2489999 2489999 defendant Gose Thomas husbandman 601114 601114 Gose, Thomas, of Kyrton in Holand, husbandman 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);