names

30 rows where place_id = 588883

✎ 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
3595895 1866351 1866351 defendant Coddyngton or Cotyngton Morgan gent 588883 588883 Coddyngton or Cotyngton, Morgan, of Ailberton, gent 0
3595899 1866352 1866352 defendant Codyngton Morgan gent 588883 588883 Codyngton, Morgan, of Ailberton, gent 0
4545097 2214384 2214384 defendant Chaumperneys John   588883 588883 Chaumperneys, John, of Ailberton 5
4570683 2222398 2222398 defendant Chaumpeneys John   588883 588883 Chaumpeneys, John, of Ailberton 1
4636910 2242356 2242356 defendant Crook John   588883 588883 Crook, John, of Ailberton 0
4721571 2272078 2272078 defendant Gayner Robert yeoman 588883 588883 Gayner, Robert, of Ailberton, yeoman 2
4745317 2279142 2279142 defendant Shipman John yeoman 588883 588883 Shipman, John, of Ailberton, yeoman 2
4754896 2281911 2281911 defendant Smyth Robert sawyer 588883 588883 Smyth, Robert, of Ailberton, sawyer 0
4754897 2281911 2281911 defendant Smyth John sawyer 588883 588883 Smyth, John, of Ailberton, sawyer 1
4763408 2284543 2284543 defendant Coke William carpenter 588883 588883 Coke, William, of Ailberton, carpenter 1
4763409 2284543 2284543 defendant Osseborn William husbandman 588883 588883 Osseborn, William, of Ailberton, husbandman 2
4763410 2284543 2284543 defendant Reve Nicholas husbandman 588883 588883 Reve, Nicholas, of Ailberton, husbandman 3
4776476 2288637 2288637 defendant Smyth Robert sawyer 588883 588883 Smyth, Robert, of Ailberton, sawyer 0
4776477 2288637 2288637 defendant Smyth John sawyer 588883 588883 Smyth, John, of Ailberton, sawyer 1
4782082 2290396 2290396 defendant Muleward William husbandman 588883 588883 Muleward, William, of Ailberton, husbandman 0
4782083 2290396 2290396 defendant Osebarne William husbandman 588883 588883 Osebarne, William, of Ailberton, husbandman 1
4782084 2290396 2290396 defendant Heynys Thomas husbandman 588883 588883 Heynys, Thomas, of Ailberton, husbandman 2
4782085 2290396 2290396 defendant Crook John husbandman 588883 588883 Crook John, of Ailberton, husbandman 3
4787520 2292169 2292169 defendant Tanner Thomas tanner 588883 588883 Tanner, Thomas, of Ailberton, tanner 0
4804093 2297467 2297467 defendant Dole Robert husbandman 588883 588883 Dole, Robert, of Ailberton, husbandman 0
4804094 2297467 2297467 defendant Dole John husbandman 588883 588883 Dole, John, of Ailberton, husbandman 1
4806864 2298353 2298353 defendant Gayner Robert husbandman 588883 588883 Gayner, Robert, of Ailberton, husbandman 0
4812389 2299986 2299986 defendant Aleyn Richard (legal representative) 588883 588883 Aleyn, Richard, of Ailberton, tanner, executrix of 3
4873466 2318659 2318659 defendant Bosse John chaplain 588883 588883 Bosse, John, of Ailberton, chaplain 0
4873468 2318660 2318660 defendant Bosse John chaplain 588883 588883 Bosse, John, of Ailberton, chaplain 0
4887083 2322802 2322802 defendant Huchyn Walter husbandman 588883 588883 Huchyn, Walter, of Ailberton, husbandman 2
5091747 2383976 2383976 defendant Smyth John laborer 588883 588883 Smyth, John, of Ailberton, laborer 4
5091756 2383977 2383977 defendant Smyth John laborer 588883 588883 Smyth, John, of Ailberton, laborer 7
5091765 2383978 2383978 defendant Smyth John laborer 588883 588883 Smyth, John, of Ailberton, laborer 7
5617195 2549194 2549194 defendant Swon Richard   588883 588883 Swon, Richard, of Ailberton 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);