names

34 rows where place_id = 627862

✎ 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
3778927 1951125 1951125 defendant Harford John chapman 627862 627862 Harford, John, of Banwell, Soms, chapman 0
3959899 2010556 2010556 defendant Bannester Lewis yeoman 627862 627862 Bannester, Lewis, of Banwell, Soms, yeoman 0
3967645 2013319 2013319 defendant Banester Lewis yeoman 627862 627862 Banester, Lewis, of Banwell, Soms, yeoman 0
3968657 2013677 2013677 defendant Banester Lewis yeoman 627862 627862 Banester, Lewis, of Banwell, Soms, yeoman 0
3968659 2013678 2013678 defendant Banester Lewis yeoman or serving man 627862 627862 Banester, Lewis, of Banwell, Soms, yeoman or serving man 0
3979178 2017303 2017303 defendant Banester Lewis yeoman 627862 627862 Banester, Lewis, of Banwell, Soms, yeoman 2
4005166 2026627 2026627 defendant Jennyng Thomas yeoman 627862 627862 Jennyng, Thomas, of Banwell, Soms, yeoman 1
4005188 2026633 2026633 defendant Genyng Thomas husbandman 627862 627862 Genyng, Thomas, of Banwell, Soms, husbandman 0
4010751 2028621 2028621 defendant Bustell William, junior husbandman 627862 627862 Bustell, William, junior, of Banwell, Soms, husbandman 0
4029628 2035235 2035235 plaintiff Davys Ralph yeoman 627862 627862 Davys, Ralph, of Banwell, Soms, yeoman 0
4042681 2039859 2039859 defendant Warren Nicholas butcher 627862 627862 Warren, Nicholas, of Banwell, Soms, butcher 0
4042685 2039860 2039860 defendant Warren Nicholas butcher 627862 627862 Warren, Nicholas, of Banwell, Soms, butcher 0
4108767 2063387 2063387 defendant Powell James clerk 627862 627862 Powell, James, of Banwell, Soms, clerk 0
4109706 2063728 2063728 defendant Quarr Edward husbandman 627862 627862 Quarr, Edward, of Banwell, Soms, husbandman 0
4131469 2071575 2071575 defendant Stanley Thgomas husbandman 627862 627862 Stanley, Thgomas, of Banwell, Soms, husbandman 1
4202821 2096530 2096530 defendant Stanley Thomas husbandman 627862 627862 Stanley, Thomas, of Banwell, Soms, husbandman 1
4211824 2099686 2099686 defendant Wylye John husbandman 627862 627862 Wylye, John, of Banwell, Soms, husbandman 0
4211837 2099689 2099689 defendant Wylye John husbandman 627862 627862 Wylye, John, of Banwell, Soms, husbandman 0
4263364 2117410 2117410 defendant Quarre Edward yeoman 627862 627862 Quarre, Edward, of Banwell, Soms, yeoman 2
4306745 2132498 2132498 defendant Quarr Edward yeoman 627862 627862 Quarr, Edward, of Banwell, Soms, yeoman 0
4329903 2140300 2140300 defendant Neades Henry chapman 627862 627862 Neades, Henry, of Banwell, Soms, chapman 2
4332122 2141043 2141043 defendant Quarr Edward yeoman 627862 627862 Quarr, Edward, of Banwell, Soms, yeoman 0
4372688 2155309 2155309 defendant Adlam Thomas tucker 627862 627862 Adlam, Thomas, of Banwell, Soms, tucker 0
4380645 2158185 2158185 defendant Guthridge William husbandman 627862 627862 Guthridge, William, of Banwell, Soms, husbandman 3
4395323 2163016 2163016 defendant Quarr Edward gent 627862 627862 Quarr, Edward, of Banwell, Soms, gent 0
4412407 2168739 2168739 defendant Sanders John yeoman 627862 627862 Sanders, John, of Banwell, Soms, yeoman 1
5011626 2360256 2360256 defendant Hykyng John chapman 627862 627862 Hykyng, John, of Banwell, Soms, chapman 3
5011633 2360257 2360257 defendant Hykyng John chapman 627862 627862 Hykyng, John, of Banwell, Soms, chapman 3
5051652 2372111 2372111 defendant Hykelyng John chapman 627862 627862 Hykelyng, John, of Banwell, Soms, chapman 3
5051659 2372112 2372112 defendant Hykelyng John chapman 627862 627862 Hykelyng, John, of Banwell, Soms, chapman 3
5285490 2440776 2440776 defendant Melan William merchant 627862 627862 Melan, William, of Banwell, Soms, or of Evesham, merchant 0
5347883 2459481 2459481 defendant Kynge John tanner 627862 627862 Kynge, John, of Banwell, Soms, tanner 1
5398374 2474598 2474598 defendant Barber Robert girdler or belt maker 627862 627862 Barber, Robert, of Banwell, Soms, girdler or belt maker 0
5474956 2497491 2497491 defendant Barber John merchant 627862 627862 Barber, John, of Banwell, Soms, merchant 1

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);