names

21 rows where place_id = 633753

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3814640 1962489 1962489 defendant Kyrby John butcher 633753 633753 Kyrby, John, of Lechelade, butcher 0
3840080 1970468 1970468 defendant Stevyns Richard   633753 633753 Stevyns, Richard, of Lechelade 0
3853921 1974863 1974863 defendant Stevyns Richard tailor 633753 633753 Stevyns, Richard, of Lechelade, tailor 0
3915501 1995552 1995552 defendant Kyrbye John butcher 633753 633753 Kyrbye, John, of Lechelade, butcher 0
3918701 1996584 1996584 defendant Colley Robert husbandman 633753 633753 Colley, Robert, of Lechelade, husbandman 0
4552297 2216673 2216673 defendant Curtays Walter   633753 633753 Curtays, Walter, of Lechelade 1
4558260 2218527 2218527 defendant Pykusame Hugh   633753 633753 Pykusame, Hugh, of Lechelade 0
4654893 2247411 2247411 defendant Lemull Robert   633753 633753 Lemull, Robert, of Lechelade, franklin 0
4919363 2332567 2332567 defendant Colat John butcher 633753 633753 Colat, John, of Lechelade, butcher 1
4968475 2347539 2347539 defendant Page Robert merchant 633753 633753 Page, Robert, of Lechelade, merchant 0
4988176 2353438 2353438 defendant Jamner Richard baker 633753 633753 Jamner, Richard, of Lechelade, baker 7
4988177 2353438 2353438 defendant Wheler John   633753 633753 Wheler, John, of Lechelade, wheel wright 8
4988178 2353438 2353438 defendant Joby Henry laborer 633753 633753 Joby, Henry, of Lechelade, laborer 9
4988179 2353438 2353438 defendant Chambrere William   633753 633753 Chambrere, William,of Lechelade, pedlar 10
5004354 2358169 2358169 defendant (not given) John prior of Wyhamms 633753 633753 Wyhamms, John, of Lechelade, prior of the House or Priory of St John 0
5308065 2447435 2447435 defendant Angesyn John husbandman 633753 633753 Angesyn, John, of Lechelade, husbandman 3
5308066 2447435 2447435 defendant Grene William husbandman 633753 633753 Grene, William, of Lechelade, husbandman 4
5393334 2473149 2473149 defendant Baywell Robert   633753 633753 Baywell, Robert, of Lechelade 0
5393335 2473149 2473149 defendant Caundeley James laborer 633753 633753 Caundeley, James, of Lechelade, laborer 1
5531657 2514435 2514435 defendant Shipward Robert chapman 633753 633753 Shipward, Robert, of Lechelade, chapman 3
5591086 2532191 2532191 plaintiff Stone Thomas gent 633753 633753 Stone, Thomas, of Lechelade, gent 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);