names

35 rows where place_id = 606712

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3666261 1915395 1915395 defendant Vile John yeoman 606712 606712 Vile, John, of Luxulyan, yeoman 6
3697964 1925587 1925587 defendant Bonam Stephen husbandman 606712 606712 Bonam, Stephen, of Luxulyan, husbandman 0
3697965 1925587 1925587 defendant Saunder Robert husbandman 606712 606712 Saunder, Robert, of Luxulyan, husbandman 1
3824738 1965612 1965612 defendant Robarde alias Hawkyn Mark tinner 606712 606712 Robarde alias Hawkyn, Mark, of Luxulyan, tinner 0
3924772 1998603 1998603 defendant Watte William Henry yeoman 606712 606712 Watte, William Henry, of Luxulyan, yeoman 0
3924773 1998603 1998603 defendant Watte William Henry clerk 606712 606712 Watte, William Henry, of Luxulyan, clerk 1
3924774 1998603 1998603 defendant Watte John Henry husbandman 606712 606712 Watte, John Henry, of Luxulyan, husbandman 2
3924775 1998603 1998603 defendant Reser John husbandman 606712 606712 Reser, John, of Luxulyan, husbandman 3
3925071 1998701 1998701 defendant Staddon Peter   606712 606712 Staddon, Peter, of Luxulyan, mason 1
3965746 2012637 2012637 defendant Falmouth John husbandman 606712 606712 Falmouth, John, of Luxulyan, husbandman 0
3965747 2012637 2012637 defendant Cook Richard husbandman 606712 606712 Cook, Richard, of Luxulyan, husbandman 1
3965748 2012637 2012637 defendant Falmouth Katherine spinster 606712 606712 Falmouth, Katherine, of Luxulyan, spinster 2
4006338 2027046 2027046 defendant Collyn John yeoman 606712 606712 Collyn, John, of Luxulyan, yeoman 1
4010166 2028405 2028405 defendant Hillary Edward yeoman 606712 606712 Hillary, Edward, of Luxulyan, yeoman 2
4012602 2029231 2029231 defendant Gomow William (legal representative) 606712 606712 Gomow, William, of Luxulyan, tinner, executors of 0
4012603 2029231 2029231 defendant Perronall William husbandman 606712 606712 (Perronall, William, of Luxulyan, husbandman 1
4016226 2030502 2030502 defendant Peyrs John husbandman 606712 606712 Peyrs, John, of Luxulyan, husbandman 0
4016227 2030502 2030502 defendant Cornyshe Henry husbandman 606712 606712 Cornyshe, Henry, of Luxulyan, husbandman 1
4040193 2038994 2038994 defendant Hyllarye Edward gent 606712 606712 Hyllarye, Edward, of Luxulyan, gent 0
4047461 2041542 2041542 defendant Cornishe Henry husbandman 606712 606712 Cornishe, Henry, of Luxulyan, husbandman 1
4197472 2094674 2094674 defendant Collyns John gent 606712 606712 Collyns, John, of Luxulyan, gent 0
4244762 2111235 2111235 defendant Collyer alias Robin Andrew husbandman 606712 606712 Collyer alias Robin, Andrew, of Luxulyan, husbandman 0
4244763 2111235 2111235 defendant Grosse Richard husbandman 606712 606712 Grosse, Richard, of Luxulyan, husbandman 1
4322104 2137810 2137810 defendant Hillarye Thomas gent 606712 606712 Hillarye, Thomas, of Luxulyan, gent 3
4659058 2248702 2248702 defendant Gayre Richard husbandman 606712 606712 Gayre, Richard, of Luxulyan, husbandman 0
5424987 2482440 2482440 defendant Dolfyn John husbandman 606712 606712 Dolfyn, John, of Luxulyan, husbandman 3
5424988 2482440 2482440 defendant Cowelyng John husbandman 606712 606712 Cowelyng, John, of Luxulyan, husbandman 4
5456333 2491814 2491814 defendant Dolfyn John husbandman 606712 606712 Dolfyn, John, of Luxulyan, husbandman 3
5456334 2491814 2491814 defendant Cowelyng John husbandman 606712 606712 Cowelyng, John, of Luxulyan, husbandman 4
5468145 2495417 2495417 defendant Dolfyn John husbandman 606712 606712 Dolfyn, John, of Luxulyan, husbandman 3
5468146 2495417 2495417 defendant Cowelyng John husbandman 606712 606712 Cowelyng, John, of Luxulyan, husbandman 4
5468224 2495435 2495435 defendant Cowelyng John   606712 606712 Cowelyng, John, of Luxulyan 4
5606559 2536936 2536936 defendant Carne or Carve John yeoman 606712 606712 Carne or Carve, John, of Luxulyan, yeoman 7
5606561 2536936 2536936 defendant July or Inly John yeoman 606712 606712 July or Inly, John, of Luxulyan, yeoman 9
5606563 2536936 2536936 defendant Crerowe Michael yeoman 606712 606712 Crerowe, Michael, of Luxulyan, yeoman 11

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