names

33 rows where place_id = 618075

✎ 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
3722731 1933376 1933376 defendant Trapett Robert husbandman 618075 618075 Trapett, Robert, of Hepworth, husbandman 0
3829848 1967226 1967226 defendant Willis Edward laborer 618075 618075 Willis, Edward, of Hepworth, laborer 2
3829850 1967227 1967227 defendant Willis Edmund laborer 618075 618075 Willis, Edmund, of Hepworth, laborer 0
3961961 2011281 2011281 defendant Brundysshe William husbandman 618075 618075 Brundysshe, William, of Hepworth, husbandman 0
3961962 2011281 2011281 defendant Walker John laborer 618075 618075 Walker, John, of Hepworth, laborer 1
4147923 2077407 2077407 defendant Gilbert Robert yeoman 618075 618075 Gilbert, Robert, of Hepworth, yeoman 1
4196067 2094175 2094175 defendant Gilbert Robert yeoman 618075 618075 Gilbert, Robert, of Hepworth, yeoman 1
4209402 2098842 2098842 defendant Londe or Lande William husbandman 618075 618075 Londe or Lande, William, of Hepworth, husbandman 0
4297414 2129179 2129179 defendant Brundishe Edward yeoman 618075 618075 Brundishe, Edward, of Hepworth, yeoman 0
4577601 2224503 2224503 defendant Smyth Nicholas   618075 618075 Smyth, Nicholas, of Hepworth 3
4600100 2231257 2231257 plaintiff Bury John master & clerk 618075 618075 Bury, John, of Hepworth, master & clerk 1
4610518 2234359 2234359 defendant Tod Thomas   618075 618075 Tod, Thomas, of Hepworth 4
4705746 2267169 2267169 plaintiff Lawe William   618075 618075 Lawe, William, of Hepworth 0
4736617 2276582 2276582 defendant Smyth NIcholas husbandman 618075 618075 Smyth, NIcholas, of Hepworth, husbandman 0
4744892 2279022 2279022 plaintiff Flecche William   618075 618075 Flecche, William, of Hepworth 0
4762332 2284201 2284201 plaintiff Fleccher William   618075 618075 Fleccher, William, of Hepworth 0
4779068 2289430 2289430 defendant de Wyntre William yeoman 618075 618075 de Wyntre, William, of Hepworth, yeoman 2
4785867 2291612 2291612 plaintiff Fleccher William   618075 618075 Fleccher, William, of Hepworth 0
4808671 2298878 2298878 defendant Walter Robert yeoman 618075 618075 Walter, Robert, of Hepworth, yeoman 0
4848019 2310852 2310852 defendant Colewell John   618075 618075 Colewell, John, of Hepworth, 10
4848020 2310852 2310852 defendant Milleshawe William   618075 618075 Milleshawe, William, of Hepworth 11
4878345 2320174 2320174 defendant Schell John dyer 618075 618075 Schell, John, of Hepworth, dyer 1
4879269 2320452 2320452 defendant Dyconson Richard husbandman 618075 618075 Dyconson, Richard, of Hepworth, husbandman 1
5082637 2381313 2381313 defendant Lynne William husbandman 618075 618075 Lynne, William, of Hepworth, husbandman 0
5199087 2415485 2415485 plaintiff Walter John   618075 618075 Walter, John, of Hepworth 0
5199088 2415485 2415485 defendant Deye John husbandman 618075 618075 Deye, John, of Hepworth, husbandman 0
5230466 2424526 2424526 plaintiff Barker Robert   618075 618075 Barker, Robert, of Hepworth 0
5243632 2428330 2428330 defendant Broun John laborer 618075 618075 Broun, John, of Hepworth, laborer 0
5261372 2433666 2433666 defendant Grenegres Walter laborer 618075 618075 Grenegres, Walter, of Hepworth, laborer 0
5345055 2458615 2458615 plaintiff Walter John   618075 618075 Walter, John, of Hepworth 0
5548621 2519638 2519638 defendant Grymsyk Thomas carpenter 618075 618075 Grymsyk, Thomas, of Hepworth, carpenter 0
5579193 2528565 2528565 defendant Rust Roger (legal representative) 618075 618075 Rust, Roger, of Hepworth, executors of 0
5579200 2528566 2528566 defendant Barker Stephen husbandman 618075 618075 Barker, Stephen, of Hepworth, husbandman 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);