names

19 rows where place_id = 607541

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3669680 1916456 1916456 defendant Harsfeld alias Baker George yeoman 607541 607541 Harsfeld alias Baker, George, of Wotton Underegge, yeoman 0
3768349 1947742 1947742 defendant Samme Thomas   607541 607541 Samme, Thomas, of Wotton Underegge, wax chandler 0
3816572 1963083 1963083 defendant Colymore John yeoman 607541 607541 Colymore, John, of Wotton Underegge, yeoman 0
3818438 1963665 1963665 defendant Hyches John tailor 607541 607541 Hyches, John, of Wotton Underegge, tailor 0
3818439 1963665 1963665 defendant Ketylsby Richard butcher 607541 607541 Ketylsby, Richard, of Wotton Underegge, butcher 1
3848248 1973020 1973020 defendant Plummer alias Yeburne John clothier 607541 607541 Plummer alias Yeburne, John, of Wotton Underegge, clothier 0
4467212 2190418 2190418 plaintiff atte Hill Thomas   607541 607541 atte Hill, Thomas, of Wotton Underegge 0
4679858 2259306 2259306 defendant Chapman John chapman 607541 607541 Chapman, John, of Wotton Underegge, chapman 0
4720610 2271779 2271779 defendant Wynter John   607541 607541 Wynter, John, of Wotton Underegge, bailiff 2
4739749 2277507 2277507 defendant Dyllyng John husbandman 607541 607541 Dyllyng, John, of Wotton Underegge, husbandman 0
4875376 2319255 2319255 defendant Garsden John yeoman 607541 607541 Garsden, John, of Wotton Underegge, yeoman 0
4932573 2336580 2336580 defendant Boteler William baker 607541 607541 Boteler, William, of Wotton Underegge, baker 9
5095793 2385193 2385193 defendant Beweton William tucker 607541 607541 Beweton, William, of Wotton Underegge, tucker 0
5102388 2387102 2387102 defendant Stok John butcher 607541 607541 Stok, John, of Wotton Underegge, butcher 0
5121246 2392646 2392646 defendant Botell Lawrence yeoman 607541 607541 Botell, Lawrence, of Wotton Underegge, yeoman 0
5223861 2422665 2422665 defendant Stok John butcher 607541 607541 Stok, John, of Wotton Underegge, butcher 0
5223862 2422665 2422665 defendant Godewyn William carpenter 607541 607541 Godewyn, William, of Wotton Underegge, carpenter 1
5580267 2528916 2528916 defendant Cosyn Thomas weaver 607541 607541 Cosyn, Thomas, of Wotton Underegge, weaver 0
5585070 2530401 2530401 defendant Cosyn Thomas tucker 607541 607541 Cosyn, Thomas, of Wotton Underegge, tucker 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);