names

23 rows where place_id = 597270

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3627894 1903582 1903582 defendant Randall William husbandman 597270 597270 Randall, William, of Chalfount St Peter, husbandman 0
3657424 1912582 1912582 defendant White William yeoman 597270 597270 White, William, of Chalfount St Peter, yeoman 0
3669323 1916343 1916343 defendant Butterfeld Richard husbandman 597270 597270 Butterfeld, Richard, of Chalfount St Peter, husbandman 0
3751294 1942328 1942328 defendant Splene Adam husbandman 597270 597270 Splene, Adam, of Chalfount St Peter, husbandman 0
3764244 1946473 1946473 defendant Mowyer Giles husbandman 597270 597270 Mowyer, Giles, of Chalfount St Peter, husbandman 0
3776301 1950334 1950334 defendant Dorsett John tailor 597270 597270 Dorsett, John, of Chalfount St Peter, tailor 0
3776302 1950334 1950334 defendant Morwyn Stephen husbandman 597270 597270 Morwyn, Stephen, of Chalfount St Peter, husbandman 1
3777711 1950778 1950778 defendant Splene Adam husbandman 597270 597270 Splene, Adam, of Chalfount St Peter, husbandman 0
3778258 1950910 1950910 defendant Traughton Nicholas tailor 597270 597270 Traughton, Nicholas, of Chalfount St Peter, tailor 0
3810621 1961219 1961219 defendant Splene Adam husbandman 597270 597270 Splene, Adam, of Chalfount St Peter, husbandman 0
3810935 1961321 1961321 defendant Brudenell Edmund esq 597270 597270 Brudenell, Edmund, of Chalfount St Peter, esq 0
3810936 1961321 1961321 defendant Monke John laborer 597270 597270 Monke, John, of Chalfount St Peter, laborer 1
3817937 1963529 1963529 defendant Goderd Simon yeoman 597270 597270 Goderd, Simon, of Chalfount St Peter, yeoman 3
3817942 1963530 1963530 defendant Goderd Simon yeoman 597270 597270 Goderd, Simon, of Chalfount St Peter, yeoman 3
3867240 1979280 1979280 defendant Tayllour Richard tailor 597270 597270 Tayllour, Richard, of Chalfount St Peter, tailor 0
3881177 1983972 1983972 defendant Taylour Richard tailor 597270 597270 Taylour, Richard, of Chalfount St Peter, tailor 0
4135800 2073133 2073133 defendant Hull John, junior husbandman 597270 597270 Hull, John, junior, of Chalfount St Peter, husbandman 0
5155968 2402902 2402902 defendant Lychefeld John joiner 597270 597270 together with Lychefeld, John, of Chalfount St Peter, joiner 5
5155970 2402903 2402903 defendant Lychefeld John joiner 597270 597270 Lychefeld, John, of Chalfount St Peter, joiner 0
5191532 2413266 2413266 defendant Lychefeld John joiner 597270 597270 Lychefeld, John, of Chalfount St Peter, joiner 0
5367366 2465450 2465450 defendant Asshewell Robert butcher 597270 597270 Asshewell, Robert, of Chalfount St Peter, butcher 0
5509911 2507940 2507940 defendant Spornyng John laborer 597270 597270 Spornyng, John, of Chalfount, laborer 0
5593812 2533051 2533051 defendant Wyllys Stephen butcher 597270 597270 Wyllys, Stephen, of Chalfount St Peter, butcher 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);