names

28 rows where place_id = 589423

✎ 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
3597611 1866878 1866878 defendant Erle John tailor 589423 589423 Erle, John, of Sutton Courteney, tailor 3
3652427 1911093 1911093 defendant Lond John yeoman 589423 589423 Lond, John, of Sutton Courteney, yeoman 0
3687480 1922263 1922263 defendant Burges John clerk 589423 589423 Burges, John, of Sutton Courteney, clerk 0
3870667 1980431 1980431 defendant Aldeworthe John yeoman 589423 589423 Aldeworthe, John, of Sutton Courteney, yeoman 0
4514817 2205054 2205054 defendant Mayhowe William   589423 589423 Mayhowe, William, of Sutton Courteney 0
4847073 2310586 2310586 defendant Edward Thomas husbandman 589423 589423 Edward, Thomas, of Sutton Courteney, husbandman 4
4874782 2319055 2319055 defendant Edward Thomas husbandman 589423 589423 Edward, Thomas, of Sutton Courteney, husbandman 2
4888174 2323106 2323106 defendant Curteys John laborer 589423 589423 Curteys, John, of Sutton Courteney, laborer 0
4957254 2344132 2344132 defendant Eye or Bye Michael husbandman 589423 589423 Eye or Bye, Michael, of Sutton Courteney, husbandman 1
4959660 2344850 2344850 defendant Cary Thomas husbandman 589423 589423 Cary, Thomas, of Sutton Courteney, husbandman 0
4959661 2344850 2344850 defendant Notlyng Thomas laborer 589423 589423 Notlyng, Thomas, of Sutton Courteney, laborer 1
5013298 2360726 2360726 defendant Aldeworth Thomas husbandman 589423 589423 Aldeworth, Thomas, of Sutton Courteney, husbandman 0
5038903 2368281 2368281 defendant Pulker John, senior husbandman 589423 589423 Pulker, John, senior, of Sutton Courteney, husbandman 1
5047219 2370789 2370789 defendant Pulkar John, junior husbandman 589423 589423 Pulkar, John, junior, of Sutton Courteney, husbandman 0
5047861 2370977 2370977 defendant Whyte Richard husbandman 589423 589423 Whyte, Richard, of Sutton Courteney, husbandman 0
5047862 2370977 2370977 defendant Fyssher Henry husbandman 589423 589423 Fyssher, Henry, of Sutton Courteney, husbandman 1
5102456 2387120 2387120 defendant Brouns Richard gent 589423 589423 Brouns, Richard, of Sutton Courteney, gent 4
5194284 2414059 2414059 defendant Bolter Thomas laborer 589423 589423 Bolter, Thomas, of Sutton Courteney, laborer 1
5208691 2418265 2418265 defendant Bolter Thomas laborer 589423 589423 Bolter, Thomas, of Sutton Courteney, laborer 1
5336627 2456023 2456023 defendant Person John husbandman 589423 589423 Person, John, of Sutton Courteney, husbandman 2
5336631 2456024 2456024 defendant Person John husbandman 589423 589423 Person, John, of Sutton Courteney, husbandman 2
5351606 2460602 2460602 defendant Freman William yeoman 589423 589423 Freman, William, of Sutton Courteney, yeoman 1
5556235 2521820 2521820 defendant Whyte Andrew husbandman 589423 589423 Whyte, Andrew, of Sutton Courteney, husbandman 0
5556238 2521820 2521820 defendant Andrewe John husbandman 589423 589423 Andrewe, John, of Sutton Courteney, husbandman 3
5563425 2523903 2523903 defendant Bulkeley Robert gent 589423 589423 Bulkeley, Robert, of Sutton Courteney, gent 1
5586499 2530817 2530817 plaintiff Lond alias Sadeler John   589423 589423 Lond alias Sadeler, John, of Sutton Courteney 0
5599028 2534580 2534580 defendant Andrewes Roger husbandman 589423 589423 Andrewes, Roger, of Sutton Courteney, husbandman 0
5600575 2535071 2535071 defendant Watt Reginald butcher 589423 589423 Watt, Reginald, of Sutton Courteney, butcher 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);