names

25 rows where place_id = 595482

✎ 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
3620635 1874033 1874033 defendant Wales John husbandman 595482 595482 Wales, John, of Hever, husbandman 0
3620638 1874034 1874034 defendant Walys John husbandman 595482 595482 Walys, John, of Hever, husbandman 0
3761462 1945598 1945598 defendant A Bowre John tailor 595482 595482 A Bowre, John, of Hever, tailor 0
3919623 1996896 1996896 defendant Wodgate George husbandman 595482 595482 Wodgate, George, of Hever, husbandman 0
3919624 1996896 1996896 defendant Snatte William husbandman 595482 595482 Snatte, William, of Hever, husbandman 1
3963653 2011898 2011898 defendant Hubberd John yeoman 595482 595482 Hubberd, John, of Hever, yeoman 0
4069255 2049292 2049292 defendant Cranwell Edward gent 595482 595482 Cranwell, Edward, of Hever, gent 0
4516034 2205430 2205430 plaintiff Cobeham John (legal representative) 595482 595482 Cobeham, John, of Hever, executors of 0
4760164 2283527 2283527 plaintiff Cook John   595482 595482 Cook, John, of Hever 0
4767972 2285954 2285954 defendant atte Crouch John weaver 595482 595482 atte Crouch, John, of Hever, weaver 0
4767974 2285954 2285954 defendant Rukke atte Broke John laborer 595482 595482 Rukke atte Broke, John, of Hever, laborer 2
4768875 2286246 2286246 defendant Broket John husbandman 595482 595482 Broket, John, of Hever, husbandman 0
4771501 2287068 2287068 defendant Ruk William husbandman 595482 595482 Ruk, William, of Hever, husbandman 0
4794971 2294569 2294569 defendant Polbroke Simon husbandman 595482 595482 (Polbroke, Simon, of Hever, husbandman 4
4809403 2299117 2299117 defendant Hupfeld Thomas husbandman 595482 595482 Hupfeld, Thomas, of Hever, husbandman 2
4828280 2304889 2304889 defendant atte Reye Thomas laborer 595482 595482 atte Reye, Thomas, of Hever, laborer 0
4847252 2310641 2310641 defendant Crudde John husbandman 595482 595482 Crudde, John, of Hever, husbandman 0
4923405 2333746 2333746 defendant Dowesbery John   595482 595482 Dowesbery, John, of Hever, parson 0
4932627 2336597 2336597 defendant Mathewe William gent 595482 595482 Mathewe, William, of Hever, gent 0
4932628 2336597 2336597 defendant Polbroke Simon husbandman 595482 595482 Polbroke, Simon, of Hever, husbandman 1
4972621 2348743 2348743 defendant Harry Alexander clothier 595482 595482 Harry, Alexander, of Hever, clothier 0
5139708 2398088 2398088 defendant Clerk John husbandman 595482 595482 Clerk, John, of Hever, husbandman 3
5160618 2404200 2404200 defendant Clerk John husbandman 595482 595482 Clerk, John, of Hever, husbandman 3
5175374 2408487 2408487 defendant Clerk John husbandman 595482 595482 Clerk, John, of Hever, husbandman 3
5196542 2414741 2414741 defendant Clerk John husbandman 595482 595482 Clerk, John, of Hever, husbandman 3

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