names

38 rows where place_id = 601711

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3646653 1909358 1909358 defendant Beryall Robert husbandman 601711 601711 Beryall, Robert, of Thorneton, husbandman 0
3646654 1909358 1909358 defendant Nele Thomas, senior husbandman 601711 601711 Nele, Thomas, senior, of Thorneton, husbandman 1
3646655 1909358 1909358 defendant Doughty Henry husbandman 601711 601711 Doughty, Henry, of Thorneton, husbandman 2
3646656 1909358 1909358 defendant Tolle Thomas husbandman 601711 601711 Tolle, Thomas, of Thorneton, husbandman 3
3742432 1939503 1939503 defendant Parys John husbandman 601711 601711 Parys, John, of Thorneton, husbandman 0
3801377 1958359 1958359 defendant Woodecrofte Thomas clerk 601711 601711 Woodecrofte, Thomas, of Thorneton, clerk 0
3938724 2003294 2003294 plaintiff Reader Thomas   601711 601711 Reader, Thomas, of Thorneton, rector 0
3944814 2005287 2005287 plaintiff Benet James (legal representative) 601711 601711 Benet, James, of Thorneton, yeoman, executors of 0
3948502 2006541 2006541 defendant Browne Henry husbandman 601711 601711 Browne, Henry, of Thorneton, husbandman 0
4013829 2029676 2029676 defendant Redman Richard gent 601711 601711 Redman, Richard, of Thorneton, gent 1
4013832 2029676 2029676 defendant Redman Marmaduke gent 601711 601711 Redman, Marmaduke, of Thorneton, gent 4
4021986 2032591 2032591 defendant Tyrrell Edward esq 601711 601711 Tyrrell, Edward, of Thorneton, esq, son of George Tyrrell, esq 0
4046456 2041180 2041180 defendant Tyrell Edward gent 601711 601711 Tyrell, Edward, of Thorneton, gent 1
4078948 2052770 2052770 plaintiff Tirrell Edward esq 601711 601711 Tirrell, Edward, of Thorneton, esq 0
4130769 2071314 2071314 defendant Gammell Simon blacksmith 601711 601711 Gammell, Simon, of Thorneton, blacksmith 0
4179561 2088327 2088327 defendant Watson Edward yeoman 601711 601711 Watson, Edward, of Thorneton, yeoman 1
4237333 2108645 2108645 defendant Harrison William yeoman 601711 601711 Harrison, William, of Thorneton, yeoman 0
4284370 2124459 2124459 defendant Tailor Thomas husbandman 601711 601711 Tailor, Thomas, of Thorneton, husbandman 0
4295731 2128562 2128562 defendant Readmayne Marmaduke esq 601711 601711 Readmayne, Marmaduke, of Thorneton, esq 0
4311293 2134095 2134095 defendant Porter Edward laborer 601711 601711 Porter, Edward, of Thorneton, laborer 2
4425809 2172884 2172884 plaintiff Molyneux Robert le   601711 601711 Molyneux, Robert le, of Thorneton 0
4446278 2183752 2183752 defendant Heron John   601711 601711 Heron, John, of Thorneton 0
4484329 2195802 2195802 defendant Heron John de   601711 601711 Heron, John de, of Thorneton 0
4541024 2213100 2213100 plaintiff Cartewright John   601711 601711 Cartewright, John, of Thorneton 2
4607491 2233454 2233454 defendant White John   601711 601711 White, John, of Thorneton 0
4690349 2262539 2262539 plaintiff Westhorp John de   601711 601711 Westhorp, John de, of Thorneton, on his own account 0
4939154 2338633 2338633 plaintiff Colyer John   601711 601711 Colyer, John, of Thorneton 0
5028380 2365183 2365183 defendant Langle Richard laborer 601711 601711 Langle, Richard, of Thorneton, laborer 0
5045526 2370290 2370290 plaintiff Colyer John   601711 601711 Colyer, John, of Thorneton 1
5059726 2374473 2374473 defendant Stephyn Walter husbandman 601711 601711 Stephyn, Walter, of Thorneton, husbandman 0
5059727 2374473 2374473 defendant Mershay Stephen husbandman 601711 601711 Mershay, Stephen, of Thorneton, husbandman 1
5059728 2374473 2374473 defendant Stephyn John husbandman 601711 601711 Stephyn, John, of Thorneton, husbandman 2
5059729 2374473 2374473 defendant Pawlyn John husbandman 601711 601711 Pawlyn, John, of Thorneton, husbandman 3
5368524 2465768 2465768 defendant Shawe William yeoman 601711 601711 Shawe, William, of Thorneton, yeoman 3
5368554 2465769 2465769 defendant Shawe William yeoman 601711 601711 Shawe, William, of Thorneton, yeoman 3
5594579 2533284 2533284 defendant Ratclyffe Thomas butcher 601711 601711 Ratclyffe, Thomas, of Thorneton, butcher 0
5599718 2534801 2534801 defendant Bayle Robert yeoman 601711 601711 Bayle, Robert, of Thorneton, yeoman 0
5624847 2551703 2551703 defendant Dunne John yeoman 601711 601711 Dunne, John, of Thorneton, yeoman 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);