names

23 rows where place_id = 744227

✎ 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
4359727 2150638 2150638 defendant Taylor William yeoman 744227 744227 Taylor, William, of Carleton in Moreland, yeoman 0
4510453 2203728 2203728 plaintiff Barham William   744227 744227 Barham, William, of Carleton in Moreland, vicar 0
4554809 2217431 2217431 defendant Weston Richard   744227 744227 Weston, Richard, of Carleton in Moreland 0
4652855 2246828 2246828 defendant Hoggesson John husbandman 744227 744227 Hoggesson, John, of Carleton in Moreland, husbandman 1
4801948 2296793 2296793 defendant Prygeon William husbandman 744227 744227 Prygeon, William, of Carleton in Moreland, husbandman 0
4801949 2296793 2296793 defendant Snayth John husbandman 744227 744227 Snayth, John, of Carleton in Moreland, husbandman 1
4807826 2298633 2298633 defendant Hoggeson John husbandman 744227 744227 Hoggeson, John, of Carleton in Moreland, husbandman 0
4807827 2298633 2298633 defendant Hoggeson William husbandman 744227 744227 Hoggeson, William, of Carleton in Moreland, husbandman 1
4839791 2308357 2308357 defendant Hogeson William husbandman 744227 744227 Hogeson, William, of Carleton in Moreland, husbandman 0
4850624 2311655 2311655 defendant Wistede Richard husbandman 744227 744227 Wistede, Richard, of Carleton in Moreland, husbandman 1
4850628 2311656 2311656 defendant Arnald Thomas husbandman 744227 744227 Arnald, Thomas, of Carleton in Moreland, husbandman 1
4854136 2312703 2312703 defendant Capper John husbandman 744227 744227 Capper, John, of Carleton in Moreland, husbandman 2
4878333 2320172 2320172 defendant Hoggeson John husbandman 744227 744227 Hoggeson, John, of Carleton in Moreland, husbandman 0
4878334 2320172 2320172 defendant Hoggeson William husbandman 744227 744227 Hoggeson, William, of Carleton in Moreland, husbandman 1
4900605 2326830 2326830 defendant Hogeson William husbandman 744227 744227 Hogeson, William, of Carleton in Moreland, husbandman 1
4900606 2326830 2326830 defendant Hogeson John husbandman 744227 744227 Hogeson, John, of Carleton in Moreland, husbandman 2
4961896 2345511 2345511 defendant Prygeon Robert husbandman 744227 744227 Prygeon, Robert, of Carleton in Moreland, husbandman 0
5012304 2360452 2360452 defendant Cappe John, sen husbandman 744227 744227 Cappe, John, sen, of Carleton in Moreland, husbandman 1
5015093 2361298 2361298 defendant Prigeon Robert husbandman 744227 744227 Prigeon, Robert, of Carleton in Moreland, husbandman 0
5048317 2371130 2371130 defendant Burnand Thomas husbandman 744227 744227 Burnand, Thomas, of Carleton in Moreland, husbandman 0
5377707 2468610 2468610 defendant Langton John husbandman 744227 744227 Langton, John, of Carleton in Moreland, husbandman 0
5393447 2473186 2473186 defendant Langton John   744227 744227 Langton, John, of Carleton in Moreland 0
5620599 2550306 2550306 defendant Scarld John de   744227 744227 Scarld, John de, of Carleton in Moreland 1

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