names

15 rows where place_id = 592235

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3607024 1869861 1869861 defendant Pays John yeoman 592235 592235 Pays, John, of Montagu, yeoman 0
4043140 2040013 2040013 defendant Gyll Thomas   592235 592235 Gyll, Thomas, of Montagu. Husbandman 0
4043142 2040014 2040014 defendant White Robert yeoman 592235 592235 White, Robert, of Montagu, yeoman 0
4677045 2258435 2258435 defendant Janet Walter carpneter 592235 592235 Janet, Walter, of Montagu, carpneter 0
4792632 2293784 2293784 defendant Monke John yeoman 592235 592235 Monke, John, of Montagu, yeoman 0
5024992 2364209 2364209 defendant Monke John, senior husbandman 592235 592235 Monke, John, senior, of Montagu, husbandman 0
5142712 2398994 2398994 defendant Haywode John   592235 592235 Haywode, John, of Montagu, shoe maker 1
5164106 2405236 2405236 defendant Barbour William barber 592235 592235 Barbour, William, of Montagu, barber 0
5164107 2405236 2405236 defendant Haywode John shoemaker 592235 592235 Haywode, John, of Montagu, shoemaker 1
5309664 2447929 2447929 defendant Knappe Nicholas barber 592235 592235 Knappe, Nicholas, of Montagu, barber 8
5309665 2447929 2447929 defendant Panter William yeoman 592235 592235 Panter, William, of Montagu, yeoman 9
5309666 2447929 2447929 defendant Chaunt John husbandman 592235 592235 Chaunt, John, of Montagu, husbandman 10
5309667 2447929 2447929 defendant Smert John husbandman 592235 592235 Smert, John, of Montagu, husbandman 11
5340252 2457160 2457160 defendant Chamberleyn John chaplain 592235 592235 Chamberleyn, John, of Montagu, chaplain 0
5393480 2473190 2473190 defendant Phelip Thomas gent 592235 592235 Phelip, Thomas, of Montagu, gent 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);