names

29 rows where place_id = 596435

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3624754 1875278 1875278 defendant Whychcote John gent 596435 596435 Whychcote, John, of Harpeswell, gent 0
3850979 1973896 1973896 defendant Kyrke Alexander husbandman 596435 596435 Kyrke, Alexander, of Harpeswell, husbandman 0
3883752 1984836 1984836 defendant Towne Richard husbandman 596435 596435 Towne, Richard, of Harpeswell, husbandman 3
3913890 1994992 1994992 defendant Stokys Thomas yeoman 596435 596435 Stokys, Thomas, of Harpeswell, yeoman 0
4088570 2056214 2056214 defendant Woodclyffe William husbandman 596435 596435 Woodclyffe, William, of Harpeswell, husbandman 0
4168744 2084559 2084559 defendant Wells Edward yeoman 596435 596435 Wells, Edward, of Harpeswell, yeoman 2
4495145 2199168 2199168 defendant Carleton John de   596435 596435 Carleton, John de, of Harpeswell, parson 1
4497472 2199854 2199854 defendant Rikard John   596435 596435 Rikard, John, of Harpeswell 0
4501979 2201217 2201217 plaintiff Marshall Walter   596435 596435 Marshall, Walter, of Harpeswell 0
4523443 2207653 2207653 defendant Elys John   596435 596435 Elys, John, of Harpeswell, parson 0
4552905 2216853 2216853 defendant Duffeld John   596435 596435 Duffeld, John, of Harpeswell 0
4552906 2216853 2216853 defendant Ricard John   596435 596435 Ricard, John, of Harpeswell 1
4581131 2225581 2225581 defendant at Oven William   596435 596435 at Oven, William, of Harpeswell 6
4682563 2260165 2260165 defendant Wyntere Thomas   596435 596435 Wyntere, Thomas, of Harpeswell, bailiff 0
4899020 2326336 2326336 defendant Argent John mercer 596435 596435 Argent, John, of Harpeswell, mercer 0
4959321 2344755 2344755 defendant Byrmand John husbandman 596435 596435 Byrmand, John, of Harpeswell, husbandman 0
4959322 2344755 2344755 defendant Robynson John husbandman 596435 596435 Robynson, John, of Harpeswell, husbandman 1
4959323 2344755 2344755 defendant Pese William husbandman 596435 596435 Pese, William, of Harpeswell, husbandman 2
5038619 2368195 2368195 plaintiff Argent John, senior merchant 596435 596435 Argent, John, senior, of Harpeswell, merchant 0
5111012 2389612 2389612 defendant Argent John merchant 596435 596435 Argent, John, of Harpeswell, merchant 0
5317646 2450364 2450364 defendant Richard Thomas merchant 596435 596435 Richard, Thomas, of Harpeswell, merchant 2
5393779 2473279 2473279 defendant Nevyll William yeoman 596435 596435 Nevyll, William, of Harpeswell, yeoman 1
5503887 2506130 2506130 defendant Whychecote John (legal representative) 596435 596435 Whychecote, John, of Harpeswell, esq, administrator of 0
5503888 2506130 2506130 defendant Whychecote John esq 596435 596435 Whychecote, John, of Harpeswell, esq 1
5518343 2510563 2510563 defendant Whichecote John (legal representative) 596435 596435 Whichecote, John, of Harpeswell, esq, administrator of 0
5518344 2510563 2510563 defendant Whichecote John esq 596435 596435 Whichecote, John, of Harpeswell, esq 1
5518354 2510567 2510567 defendant Whychecoye John (legal representative) 596435 596435 Whychecoye, John, of Harpeswell, esq, administrator of 0
5518355 2510567 2510567 defendant Whychecoye John esq 596435 596435 Whychecoye, John, of Harpeswell, esq 1
5634381 2554744 2554744 defendant Ricard John courser 596435 596435 Ricard, John, of Harpeswell, courser 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);