names

36 rows where place_id = 787375

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4702184 2266092 2266092 defendant Osteler John chapman 787375 787375 Osteler, John, of Stratford upon Avon, Warws, chapman 0
4730407 2274707 2274707 defendant Leek John chapman 787375 787375 Leek, John, of Stratford upon Avon, Warws, chapman 1
4745165 2279091 2279091 defendant Harewell Roger gent 787375 787375 Harewell, Roger, of Stratford upon Avon, Warws, gent 2
4751096 2280800 2280800 defendant Blamforn Margaret widow 787375 787375 Blamforn, Margaret, of Stratford upon Avon, Warws, widow 6
4751104 2280801 2280801 defendant Blamforn Margaret widow 787375 787375 Blamforn, Margaret, of Stratford upon Avon, Warws, widow 6
4811297 2299642 2299642 defendant Brasyer William   787375 787375 Brasyer, William, of Stratford upon Avon, Warws, semar 1
4825412 2303991 2303991 defendant Whetston John yeoman 787375 787375 Whetston, John, of Stratford upon Avon, Warws, yeoman 3
4836760 2307464 2307464 defendant Mounoweth Richard gent 787375 787375 Mounoweth, Richard, of Stratford upon Avon, Warws, gent 2
4836808 2307474 2307474 defendant Monmoweth Richard gent 787375 787375 Monmoweth, Richard, of Stratford upon Avon, Warws, gent 2
4837689 2307720 2307720 defendant Brasier William tanner 787375 787375 Brasier, William, of Stratford upon Avon, Warws, tanner 0
4852605 2312236 2312236 defendant Lucy William esq 787375 787375 Lucy, William, of Stratford upon Avon, Warws, esq 3
4933301 2336807 2336807 defendant Hore Thomas fisher 787375 787375 Hore, Thomas, of Stratford upon Avon, Warws, fisher 1
5127321 2394470 2394470 defendant Frost Roger chapman 787375 787375 Frost, Roger, of Stratford upon Avon, Warws, chapman 0
5194077 2414000 2414000 defendant Roger William husbandman 787375 787375 Roger, William, of Stratford upon Avon, Warws, husbandman 0
5195171 2414331 2414331 defendant Leke Thomas chapman 787375 787375 Leke, Thomas, of Stratford upon Avon, Warws, chapman 1
5200097 2415780 2415780 defendant Frost Roger chapman 787375 787375 Frost, Roger, of Stratford upon Avon, Warws, chapman 0
5208539 2418228 2418228 defendant Roger William husbandman 787375 787375 Roger, William, of Stratford upon Avon, Warws, husbandman 0
5209136 2418400 2418400 defendant Leke Thomas chapman 787375 787375 Leke, Thomas, of Stratford upon Avon, Warws, chapman 1
5305665 2446701 2446701 defendant Atkyns Thomas yeoman 787375 787375 Atkyns, Thomas, of Stratford upon Avon, Warws, yeoman 1
5309809 2447971 2447971 defendant Waynwryght Thomas yeoman 787375 787375 Waynwryght, Thomas, of Stratford upon Avon, Warws, yeoman 0
5397610 2474384 2474384 defendant Blakemon William   787375 787375 Blakemon, William, of Stratford upon Avon, Warws, shoe maker 0
5399737 2475016 2475016 defendant Couper Thomas yeoman 787375 787375 Couper, Thomas, of Stratford upon Avon, Warws, yeoman 2
5399741 2475017 2475017 defendant Couper Thomas yeoman 787375 787375 Couper, Thomas, of Stratford upon Avon, Warws, yeoman 2
5410188 2477998 2477998 defendant Hannys William chapman 787375 787375 Hannys, William, of Stratford upon Avon, Warws, chapman 4
5410726 2478153 2478153 defendant Blakemon William shoemaker 787375 787375 Blakemon, William, of Stratford upon Avon, Warws, shoemaker 0
5414309 2479214 2479214 defendant Walshman Hugh baker 787375 787375 Walshman, Hugh, of Stratford upon Avon, Warws, baker 1
5414317 2479217 2479217 defendant Walshman Hugh baker 787375 787375 Walshman, Hugh, of Stratford upon Avon, Warws, baker 1
5423866 2482092 2482092 defendant Hannys William chapman 787375 787375 Hannys, William, of Stratford upon Avon, Warws, chapman 4
5423870 2482093 2482093 defendant Hannys William chapman 787375 787375 Hannys, William, of Stratford upon Avon, Warws, chapman 2
5424410 2482267 2482267 defendant Hannys William fishmonger 787375 787375 Hannys, William, of Stratford upon Avon, Warws, fishmonger 0
5443230 2487891 2487891 defendant Hannys William fishmonger 787375 787375 Hannys, William, of Stratford upon Avon, Warws, fishmonger 0
5455951 2491689 2491689 defendant Hammys William fishmonger 787375 787375 Hammys, William, of Stratford upon Avon, Warws, fishmonger 0
5455953 2491690 2491690 defendant Haunys William fishmonger 787375 787375 Haunys, William, of Stratford upon Avon, Warws, fishmonger 0
5456214 2491772 2491772 defendant Blakemon William shoemaker 787375 787375 Blakemon, William, of Stratford upon Avon, Warws, shoemaker 0
5460875 2493200 2493200 defendant Fyle William shoemaker 787375 787375 Fyle, William, of Stratford upon Avon, Warws, shoemaker 3
5472456 2496727 2496727 defendant File William shoemaker 787375 787375 File, William, of Stratford upon Avon, Warws, shoemaker 3

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