names

27 rows where place_id = 751784

✎ 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
4403213 2165645 2165645 defendant Stubbes John chapman 751784 751784 Stubbes, John, of New Windsor, chapman 2
4543850 2213974 2213974 defendant Petyt John   751784 751784 Petyt, John, of New Windsor 0
4691376 2262827 2262827 defendant Coterell Robert butcher 751784 751784 Coterell, Robert, of New Windsor, butcher 2
4707109 2267608 2267608 defendant Cotrell Robert butcher 751784 751784 Cotrell, Robert, of New Windsor, butcher 0
4707111 2267608 2267608 defendant Som_ Thomas husbandman 751784 751784 Som_, Thomas, of New Windsor, husbandman 2
4724610 2272996 2272996 defendant Neubury Richard butcher 751784 751784 Neubury, Richard, of New Windsor, butcher 0
4759217 2283226 2283226 defendant Norwode Robert yeoman 751784 751784 Norwode, Robert, of New Windsor, yeoman 0
4824579 2303739 2303739 defendant Coterell Robert butcher 751784 751784 Coterell, Robert, of New Windsor, butcher 0
4930232 2335858 2335858 defendant Sherman Roger sheerman 751784 751784 Sherman, Roger, of New Windsor, sheerman 0
4930233 2335858 2335858 defendant Piers Thomas victualer 751784 751784 Piers, Thomas, of New Windsor, victualer 1
4998674 2356487 2356487 defendant Towe William husbandman 751784 751784 Towe, William, of New Windsor, husbandman 0
5006507 2358802 2358802 defendant Playle Thomas barber 751784 751784 Playle, Thomas, of New Windsor, barber 0
5128305 2394755 2394755 defendant Bullok Ralph   751784 751784 Bullok, Ralph, of New Windsor 0
5128306 2394755 2394755 defendant Bolley William yeoman 751784 751784 Bolley, William, of New Windsor, yeoman 1
5130603 2395438 2395438 defendant Josep John baker 751784 751784 Josep, John, of New Windsor, baker 0
5147393 2400383 2400383 defendant Bullok Ralph miller 751784 751784 Bullok, Ralph, of New Windsor, miller 0
5147394 2400383 2400383 defendant Bollley William yeoman 751784 751784 Bollley, William, of New Windsor, yeoman 1
5163085 2404930 2404930 defendant Croucher John yeoman 751784 751784 Croucher, John, of New Windsor, yeoman 0
5172853 2407792 2407792 defendant Leneham John laborer 751784 751784 Leneham, John, of New Windsor, laborer 0
5176892 2408931 2408931 defendant Crowcher John yeoman 751784 751784 Crowcher, John, of New Windsor, yeoman 0
5192684 2413596 2413596 defendant Leneham John laborer 751784 751784 Leneham, John, of New Windsor, laborer 0
5199482 2415595 2415595 defendant Croucher John yeoman 751784 751784 Croucher, John, of New Windsor, yeoman 0
5397297 2474310 2474310 plaintiff Buknell John   751784 751784 Buknell, John, of New Windsor 0
5397300 2474311 2474311 plaintiff Buknell John brewer 751784 751784 Buknell, John, of New Windsor, brewer 0
5432371 2484654 2484654 defendant Pasche Thomas clerk 751784 751784 Pasche, Thomas, of New Windsor, clerk 4
5458061 2492314 2492314 defendant Blake William blacksmith 751784 751784 Blake, William, of New Windsor, blacksmith 0
5477079 2498150 2498150 defendant Hayward Richard innholder 751784 751784 Hayward, Richard, of New Windsor, innholder 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);