names

37 rows where place_id = 625685

✎ 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
3765621 1946911 1946911 defendant Halle Edward yeoman 625685 625685 Halle, Edward, of Matteshall, yeoman 0
3844243 1971747 1971747 defendant Savage John husbandman 625685 625685 Savage, John, of Matteshall, husbandman 1
3844244 1971747 1971747 defendant Chapman William husbandman 625685 625685 Chapman, William, of Matteshall, husbandman 2
3948275 2006456 2006456 plaintiff Croswold Thomas   625685 625685 Croswold, Thomas, of Matteshall, wool chapman 0
3973809 2015409 2015409 plaintiff Hall Simon   625685 625685 Hall, Simon, of Matteshall 0
3973810 2015409 2015409 defendant Cockerell William blacksmith 625685 625685 Cockerell, William, of Matteshall, blacksmith 0
3973811 2015409 2015409 defendant Otberd Robert husbandman 625685 625685 Otberd, Robert, of Matteshall, husbandman 1
3973812 2015409 2015409 defendant Rounchmere John husbandman 625685 625685 Rounchmere, John, of Matteshall, husbandman 2
3974083 2015506 2015506 plaintiff Harlston Robert   625685 625685 Harlston, Robert, of Matteshall 0
3981255 2018061 2018061 plaintiff Pype Rose (legal representative) 625685 625685 Pype, Rose, of Matteshall, widow, executors of 0
3981257 2018061 2018061 defendant Watt Thomas, junior   625685 625685 Watt, Thomas, junior, of Matteshall, wool chapman 0
3981258 2018061 2018061 defendant Watt John   625685 625685 Watt, John, of Matteshall, wool chapman 1
3995732 2023218 2023218 defendant Allen Nicholas yeoman 625685 625685 Allen, Nicholas, of Matteshall, yeoman 0
3997272 2023796 2023796 plaintiff Dunham Thomas   625685 625685 Dunham, Thomas, of Matteshall 0
4002597 2025700 2025700 defendant Partrycke William yeoman 625685 625685 Partrycke, William, of Matteshall, yeoman 0
4018319 2031280 2031280 defendant Watt John, senior yeoman 625685 625685 Watt, John, senior, of Matteshall, yeoman 0
4019378 2031664 2031664 plaintiff Watt George singleman 625685 625685 Watt, George, of Matteshall, singleman 0
4019391 2031669 2031669 plaintiff Watt Thomas yeoman 625685 625685 Watt, Thomas, of Matteshall, yeoman 0
4023064 2032966 2032966 defendant Starke Richard husbandman 625685 625685 Starke, Richard, of Matteshall, husbandman 0
4048137 2041769 2041769 defendant Utbard Robert husbandman 625685 625685 Utbard, Robert, of Matteshall, husbandman 2
4064150 2047454 2047454 defendant Bennye John yeoman 625685 625685 Bennye, John, of Matteshall, yeoman 1
4075440 2051517 2051517 defendant Allen Nicholas yeoman 625685 625685 Allen, Nicholas, of Matteshall, yeoman 1
4075441 2051517 2051517 defendant Pyke Robert yeoman 625685 625685 Pyke, Robert, of Matteshall, yeoman 2
4075570 2051565 2051565 defendant Ryghtupp Thomas   625685 625685 Ryghtupp, Thomas, of Matteshall, husbandman, his brother 0
4107270 2062891 2062891 defendant Watt John yeoman 625685 625685 Watt, John, of Matteshall, yeoman 0
4143098 2075753 2075753 defendant Deane Richard singleman 625685 625685 Deane, Richard, of Matteshall, husbandman, singleman 0
4144025 2076074 2076074 defendant Potter alias Warner John husbandman 625685 625685 Potter alias Warner, John, of Matteshall, husbandman 0
4160119 2081604 2081604 defendant Raynold Joseph   625685 625685 Raynold, Joseph, of Matteshall, wool chapman 1
4185459 2090423 2090423 defendant Dabbes Thomas yeoman 625685 625685 Dabbes, Thomas, of Matteshall, or of Newton juxta Castellacre, yeoman 0
4186291 2090691 2090691 defendant Potter John husbandman 625685 625685 Potter, John, of Matteshall, husbandman 0
4193636 2093342 2093342 defendant Watt John husbandman 625685 625685 Watt, John, of Matteshall, husbandman 0
4204501 2097122 2097122 defendant Ryghteupp Thomas husbandman 625685 625685 Ryghteupp, Thomas, of Matteshall, husbandman 1
4204502 2097122 2097122 defendant Warner alias Potter John husbandman 625685 625685 Warner alias Potter, John, of Matteshall, husbandman 2
4211989 2099742 2099742 defendant Wattes Thomas   625685 625685 Wattes, Thomas, of Matteshall, wool chapman 0
4213055 2100091 2100091 defendant Potter John gent 625685 625685 Potter, John, of Matteshall, gent 2
4219090 2102173 2102173 defendant Long John tailor 625685 625685 Long, John, of Matteshall, tailor 2
4412638 2168815 2168815 defendant Baker Thomas gent 625685 625685 Baker, Thomas, of Matteshall, gent 2

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