names

21 rows where place_id = 753382

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3971261 2014506 2014506 defendant Drue or Drewe John (legal representative) 753382 753382 Drue or Drewe, John, of Est Grenestede, yeoman, executrix of 0
3971262 2014506 2014506 defendant Drewe Joan widow 753382 753382 Drewe, Joan, of Est Grenestede, widow 1
4413117 2168972 2168972 defendant Burgeys Roger   753382 753382 Burgeys, Roger, of East Grenestede 0
4445460 2183535 2183535 defendant Storok Henry   753382 753382 Storok, Henry, of East Grenestede 0
4465130 2189752 2189752 defendant Cook Geoffrey   753382 753382 Cook, Geoffrey, of East Grenestede 0
4465132 2189753 2189753 defendant Cook Geoffrey   753382 753382 Cook, Geoffrey, of East Grenestede 0
4527178 2208779 2208779 defendant Couper Richard   753382 753382 Couper, Richard, of East Grenestede 0
4745685 2279250 2279250 defendant Pykstan John parker 753382 753382 Pykstan, John, of East Grenestede, parker 1
4781174 2290123 2290123 defendant Alfrey John gent 753382 753382 Alfrey, John, of Est Grenestede, gent 0
4828577 2304980 2304980 defendant Couper Richard yeoman 753382 753382 Couper, Richard, of East Grenestede, yeoman 0
4884159 2321953 2321953 defendant Woghere John yeoman 753382 753382 Woghere, John, of Est Grenestede, yeoman 0
4898187 2326093 2326093 defendant Woghere John yeoman 753382 753382 Woghere, John, of Est Grenestede, yeoman 0
4900258 2326712 2326712 defendant Drewe John husbandman 753382 753382 (Drewe, John, of Est Grenestede, husbandman 1
5124819 2393732 2393732 defendant Shorthlegge William husbandman 753382 753382 Shorthlegge, William, of East Grenestede, husbandman 0
5208883 2418322 2418322 defendant Bust Thomas yeoman 753382 753382 Bust, Thomas, of East Grenestede, yeoman 0
5255127 2431716 2431716 defendant Boteler John weaver 753382 753382 Boteler, John, of Est Grenestede, weaver 1
5296691 2444019 2444019 defendant Boteler John weaver 753382 753382 Boteler, John, of Est Grenestede, weaver 3
5379331 2469128 2469128 defendant Boteler John husbandman 753382 753382 Boteler, John, of East Grenestede, husbandman 0
5407881 2477334 2477334 defendant Boteler John husbandman 753382 753382 Boteler, John, of East Grenestede, husbandman 0
5610048 2546849 2546849 defendant Danyell Richard   753382 753382 Danyell, Richard, of East Grenestede 0
5623024 2551136 2551136 defendant Cook Geoffrey   753382 753382 Cook, Geoffrey, of East Grenestede 1

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