names

31 rows where place_id = 586715

✎ 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
3589450 1864339 1864339 plaintiff Burgeys John clerk 586715 586715 Burgeys, John, of Knapton, Norf, clerk 0
3664485 1914841 1914841 defendant Baker Thomas butcher 586715 586715 Baker, Thomas, of Knapton, Norf, butcher 0
3914423 1995168 1995168 defendant Fenne John butcher 586715 586715 Fenne, John, of Knapton, Norf, butcher 0
3954494 2008641 2008641 defendant Huse Alban gent 586715 586715 Huse, Alban, of Knapton, Norf, gent 0
3969655 2013991 2013991 defendant Grene Thomas gent 586715 586715 Grene, Thomas, of Knapton, Norf, gent 0
4000567 2024972 2024972 defendant Reyners George yeoman 586715 586715 Reyners, George, of Knapton, Norf, yeoman 8
4005401 2026713 2026713 defendant Grene Thomas gent 586715 586715 Grene, Thomas, of Knapton, Norf, gent 0
4010104 2028380 2028380 defendant Huse Alban gent 586715 586715 Huse, Alban, of Knapton, Norf, gent 0
4014453 2029893 2029893 defendant Grene Thomas gent 586715 586715 Grene, Thomas, of Knapton, Norf, gent 0
4023851 2033234 2033234 defendant Bretton Thomas gent 586715 586715 Bretton, Thomas, of Knapton, norf, gent 1
4024587 2033471 2033471 defendant Bretton Thomas gent 586715 586715 Bretton, Thomas, of Knapton, Norf, gent 1
4034300 2036935 2036935 defendant Bretton Thomas gent 586715 586715 Bretton, Thomas, of Knapton, Norf, gent 0
4034308 2036938 2036938 defendant Bretton Thomas gent 586715 586715 Bretton, Thomas, of Knapton, Norf, gent 0
4065349 2047893 2047893 defendant Robbes Nicholas singleman 586715 586715 Robbes, Nicholas, of Knapton, Norf, gent, singleman 0
4097981 2059607 2059607 defendant Bretten Thomas gent 586715 586715 Bretten, Thomas, of Knapton, Norf, gent 0
4106955 2062782 2062782 defendant Grene Thomas gent 586715 586715 Grene, Thomas, of Knapton, Norf, gent 0
4110849 2064135 2064135 defendant Grene Thomas gent 586715 586715 Grene, Thomas, of Knapton, Norf, gent 0
4115038 2065666 2065666 defendant Robbes Nicholas yeoman 586715 586715 Robbes, Nicholas, of Knapton, Norf, yeoman 1
4117940 2066704 2066704 defendant Hewes Alban gent 586715 586715 Hewes, Alban, of Knapton, Norf, gent 0
4117969 2066712 2066712 defendant Hewes Alan gent 586715 586715 Hewes, Alan, of Knapton, norf, gent 2
4117988 2066719 2066719 defendant Huse Alban gent 586715 586715 Huse, Alban, of Knapton, Norf, gent 0
4164141 2082984 2082984 defendant Wrighte Nicholas yeoman 586715 586715 Wrighte, Nicholas, of Knapton, Norf, yeoman 0
4202833 2096535 2096535 defendant Bretton Humphrey gent 586715 586715 Bretton, Humphrey, of Knapton, Norf, gent 0
4337840 2142983 2142983 defendant Gryme Thomas gent 586715 586715 Gryme, Thomas, of Knapton, Norf, gent 1
4337851 2142985 2142985 defendant Gryme Thomas gent 586715 586715 Gryme, Thomas, of Knapton, Norf, gent 2
4339242 2143488 2143488 defendant Wright William yeoman 586715 586715 Wright, William, of Knapton, Norf, yeoman, son of Nicholas Wright, of Knapton, yeoman 1
5092526 2384194 2384194 defendant Kebyll Henry husbandman 586715 586715 (Kebyll, Henry, of Knapton, Norf, husbandman 1
5314313 2449300 2449300 defendant Smyth John clerk 586715 586715 Smyth, John, of Knapton, Norf, clerk 0
5331452 2454485 2454485 defendant Funke Robert husbandman 586715 586715 Funke, Robert, of Knapton, Norf, husbandman 0
5491289 2502283 2502283 defendant Chapman Thomas pantryman 586715 586715 Chapman, Thomas, of Knapton, Norf, pantryman 0
5520582 2511263 2511263 plaintiff Burgeys John (legal representative) 586715 586715 Burgeys, John, of Knapton, Norf, clerk, executor of 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);