names

36 rows where place_id = 586966

✎ 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
3590107 1864545 1864545 defendant Appulby John laborer 586966 586966 Appulby, John, of Tunstede, laborer 0
3629058 1903967 1903967 plaintiff Cooke Edmund clerk 586966 586966 Cooke, Edmund, of Tunstede, clerk 0
3629061 1903967 1903967 defendant Brady John clerk 586966 586966 Brady, John, of Tunstede, clerk 2
4142767 2075642 2075642 defendant Wright Robert yeoman 586966 586966 Wright, Robert, of Tunstede, yeoman 0
4444156 2183150 2183150 defendant Blowere Walter   586966 586966 Blowere, Walter, of Tunstede 1
4489887 2197543 2197543 defendant Colle John   586966 586966 Colle, John, of Tunstede 1
4565091 2220651 2220651 defendant Nicholas formerly the warrener   586966 586966 Nicholas, formerly the warrener, of Tunstede 4
4568098 2221591 2221591 defendant Warner Nicholas   586966 586966 Warner, Nicholas, of Tunstede 1
4600026 2231233 2231233 plaintiff Tatirford Henry   586966 586966 Tatirford, Henry, of Tunstede, vicar 0
4630795 2240522 2240522 defendant Warner Nicholas   586966 586966 Warner, Nicholas, of Tunstede 0
4653622 2247060 2247060 defendant Sweyn John yeoman 586966 586966 Sweyn, John, of Tunstede, yeoman 1
4733175 2275553 2275553 defendant Bryd William   586966 586966 Bryd, William, of Tunstede, wool man 1
4761148 2283837 2283837 defendant Horne Nicholas smith 586966 586966 Horne, Nicholas, of Tunstede, smith 1
4777320 2288898 2288898 defendant Sweyn John yeoman 586966 586966 Sweyn, John, of Tunstede, yeoman 1
4831211 2305793 2305793 defendant Salekene Adam fuller 586966 586966 Salekene, Adam, of Tunstede, fuller 1
4937671 2338159 2338159 defendant Curteys John yeoman 586966 586966 Curteys, John, of Tunstede, yeoman 1
4937674 2338160 2338160 defendant Curteys John yeoman 586966 586966 Curteys, John, of Tunstede, yeoman 1
4965821 2346708 2346708 defendant Swayn Robert husbandman 586966 586966 Swayn, Robert, of Tunstede, husbandman 0
4998958 2356568 2356568 defendant Rygon Willim tinker 586966 586966 Rygon, Willim, of Tunstede, tinker 0
5063831 2375716 2375716 defendant Swayn John chandler 586966 586966 Swayn, John, of Tunstede, chandler 0
5063832 2375716 2375716 defendant Sweyn Henry husbandman 586966 586966 Sweyn, Henry, of Tunstede, husbandman 1
5079359 2380323 2380323 defendant Appulby Geoffrey husbandman 586966 586966 Appulby, Geoffrey, of Tunstede, husbandman 3
5222580 2422318 2422318 defendant Crowgate John husbandman 586966 586966 Crowgate, John, of Tunstede, husbandman 0
5222581 2422318 2422318 defendant York William husbandman 586966 586966 York, William, of Tunstede, husbandman 1
5284012 2440347 2440347 defendant Tunstede John gent 586966 586966 Tunstede, John, of Tunstede, gent 2
5294383 2443333 2443333 defendant Symmes Peter laborer 586966 586966 Symmes, Peter, of Tunstede, laborer 0
5338507 2456614 2456614 defendant Rorour Thomas laborer 586966 586966 Rorour, Thomas, of Tunstede, laborer 4
5338508 2456614 2456614 defendant Rotour James laborer 586966 586966 Rotour, James, of Tunstede, laborer 5
5425956 2482721 2482721 defendant Aylward Nicholas husbandman 586966 586966 Aylward, Nicholas, of Tunstede, husbandman 4
5442496 2487668 2487668 defendant Clerke Thomas yeoman 586966 586966 Clerke, Thomas, of Tunstede, yeoman 2
5455204 2491477 2491477 defendant Clerke Thomas yeoman 586966 586966 Clerke, Thomas, of Tunstede, yeoman 2
5455211 2491478 2491478 defendant Clerke Thomas yeoman 586966 586966 Clerke, Thomas, of Tunstede, yeoman 2
5467033 2495088 2495088 defendant Clerke Thomas yeoman 586966 586966 Clerke, Thomas, of Tunstede, yeoman 2
5478307 2498540 2498540 defendant Clerke Thomas yeoman 586966 586966 Clerke, Thomas, of Tunstede, yeoman 1
5558541 2522450 2522450 defendant Rose John, senior glover 586966 586966 Rose, John, senior, of Tunstede, glover 1
5632730 2554252 2554252 defendant Fysshere Nicholas yeoman 586966 586966 Fysshere, Nicholas, of Tunstede, yeoman 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);