names

20 rows where place_id = 624878

✎ 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
3760881 1945407 1945407 defendant Davey William husbandman 624878 624878 Davey, William, of Threxton, husbandman 1
3763862 1946340 1946340 defendant Bekke Thomas clerk 624878 624878 Bekke, Thomas, of Threxton, clerk 3
3787182 1953782 1953782 defendant Becke Thomas clerk 624878 624878 Becke, Thomas, of Threxton, clerk 0
3787183 1953782 1953782 defendant Davy Brian laborer 624878 624878 Davy, Brian, of Threxton, laborer 1
3846338 1972408 1972408 defendant Davy Brian husbandman 624878 624878 Davy, Brian, of Threxton, husbandman 0
3885766 1985492 1985492 defendant Hethe Thomas husbandman 624878 624878 Hethe, Thomas, of Threxton, husbandman 3
4220863 2102791 2102791 defendant Crowne Geoffrey yeoman 624878 624878 Crowne, Geoffrey, of Threxton, yeoman 0
4220864 2102791 2102791 defendant Crowne Thomas yeoman 624878 624878 Crowne, Thomas, of Threxton, yeoman 1
4220865 2102791 2102791 defendant Oldfyld William yeoman 624878 624878 Oldfyld, William, of Threxton, yeoman 2
4335670 2142208 2142208 defendant Crowne Geoffrey husbandman 624878 624878 Crowne, Geoffrey, of Threxton, husbandman 0
4679289 2259132 2259132 defendant Hook Richard husbandman 624878 624878 Hook, Richard, of Threxton, husbandman 0
5062442 2375332 2375332 defendant Horne William   624878 624878 Horne, William, of Threxton, shepherd 0
5062443 2375332 2375332 defendant Gylyot Robert husbandman 624878 624878 Gylyot, Robert, of Threxton, husbandman 1
5073409 2378531 2378531 defendant Hacche William   624878 624878 Hacche, William, of Threxton, shepherd 0
5073410 2378531 2378531 defendant Gylok Robert husbandman 624878 624878 Gylok, Robert, of Threxton, husbandman 1
5370563 2466381 2466381 defendant Gylok Robert, senior husbandman 624878 624878 Gylok, Robert, senior, of Threxton, husbandman 0
5370564 2466381 2466381 defendant Gylok Richard, junior husbandman 624878 624878 Gylok, Richard, junior, of Threxton, husbandman 1
5370565 2466381 2466381 defendant Mounteney John husbandman 624878 624878 Mounteney, John, of Threxton, husbandman 2
5507149 2507141 2507141 defendant Potter John miller 624878 624878 Potter, John, of Threxton, miller 1
5514002 2509227 2509227 plaintiff Porter John   624878 624878 Porter, John, of Threxton 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);