names

39 rows where place_id = 587802

✎ 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
3592478 1865263 1865263 defendant Borough John smith 587802 587802 Borough, John, of Thorp Langton, smith 0
3592480 1865264 1865264 defendant Palmer Robert esq 587802 587802 Palmer, Robert, of Thorp Langton, esq 0
3649013 1910079 1910079 defendant Matocke Robert husbandman 587802 587802 Matocke, Robert, of Thorp Langton, husbandman 0
3753294 1942968 1942968 defendant Colman John husbandman 587802 587802 Colman, John, of Thorp Langton, husbandman 0
3753295 1942968 1942968 defendant Clerke Robert   587802 587802 Clerke, Robert, of Thorp Langton, shepherd 1
3787946 1954024 1954024 defendant Jervys John yeoman 587802 587802 Jervys, John, of Thorp Langton, yeoman 0
3787948 1954024 1954024 defendant Payn John husbandman 587802 587802 Payn, John, of Thorp Langton, husbandman 2
3787949 1954024 1954024 defendant Payn Thomas husbandman 587802 587802 Payn, Thomas, of Thorp Langton, husbandman 3
3787950 1954024 1954024 defendant Payn William husbandman 587802 587802 Payn, William, of Thorp Langton, husbandman 4
3787951 1954024 1954024 defendant Mattocke Robert husbandman 587802 587802 Mattocke, Robert, of Thorp Langton, , husbandman 5
3787952 1954024 1954024 defendant Smith William husbandman 587802 587802 Smith, William, of Thorp Langton, husbandman 6
3806060 1959824 1959824 defendant Jerves John yeoman 587802 587802 Jerves, John, of Thorp Langton, yeoman 0
4522856 2207486 2207486 defendant Willesson Thomas   587802 587802 Willesson, Thomas, of Thorp Langton 2
4654105 2247165 2247165 defendant Grenehod John   587802 587802 Grenehod, John, of Thorp Langton, mason 3
4713271 2269474 2269474 defendant Gilberd William husbandman 587802 587802 Gilberd, William, of Thorp Langton, husbandman 0
4735161 2276143 2276143 defendant Wryght Peter husbandman 587802 587802 (Wryght, Peter, of Thorp Langton, husbandman 3
4746018 2279339 2279339 defendant Couper Margaret widow 587802 587802 Couper, Margaret, of Thorp Langton, widow 0
4746019 2279339 2279339 defendant Dare Thomas husbandman 587802 587802 Dare, Thomas, of Thorp Langton, husbandman 1
4746020 2279339 2279339 defendant Glene John yeoman 587802 587802 Glene, John, of Thorp Langton, yeoman 2
4768325 2286065 2286065 defendant Couper Margaret widow 587802 587802 Couper, Margaret, of Thorp Langton, widow 1
4918387 2332267 2332267 defendant Wylymote alias Haukyn William husbandman 587802 587802 Wylymote alias Haukyn, William, of Thorp Langton, husbandman 0
4944794 2340359 2340359 defendant Coke William husbandman 587802 587802 Coke, William, of Thorp Langton, husbandman 0
4949318 2341773 2341773 defendant Haryat alias Taillour Robert tailor 587802 587802 Haryat alias Taillour, Robert, of Thorp Langton, tailor 0
4950472 2342114 2342114 defendant Davy John husbandman 587802 587802 Davy, John, of Thorp Langton, husbandman 3
4962031 2345555 2345555 defendant Gerves Robert yeoman 587802 587802 Gerves, Robert, of Thorp Langton, yeoman 1
5028774 2365292 2365292 defendant Dare Lawrence husbandman 587802 587802 Dare, Lawrence, of Thorp Langton, husbandman 0
5028775 2365292 2365292 defendant Dare John husbandman 587802 587802 Dare, John, of Thorp Langton, husbandman 1
5028776 2365292 2365292 defendant Osbern John husbandman 587802 587802 Osbern, John, of Thorp Langton, husbandman 2
5050868 2371875 2371875 defendant Igler Willia laborer 587802 587802 Igler, Willia, of Thorp Langton, laborer 5
5085589 2382181 2382181 defendant Gerveys Thomas husbandman 587802 587802 Gerveys, Thomas, of Thorp Langton, husbandman 0
5124208 2393538 2393538 defendant Gerveys Robert husbandman 587802 587802 Gerveys, Robert, of Thorp Langton, husbandman 0
5124209 2393538 2393538 defendant Gerveys Thomas husbandman 587802 587802 Gerveys, Thomas, of Thorp Langton, husbandman 1
5124210 2393538 2393538 defendant Gerveys William husbandman 587802 587802 Gerveys, William, of Thorp Langton, husbandman 2
5187296 2412011 2412011 defendant Smyth John husbandman 587802 587802 Smyth, John, of Thorp Langton, husbandman 1
5257929 2432602 2432602 plaintiff Gerves William husbandman 587802 587802 Gerves, William, of Thorp Langton, husbandman 0
5257931 2432603 2432603 plaintiff Gerves William husbandman 587802 587802 Gerves, William, of Thorp Langton, husbandman 0
5290838 2442330 2442330 defendant Symkyn Thomas yeoman 587802 587802 Symkyn, Thomas, of Thorp Langton, yeoman 0
5290848 2442331 2442331 defendant Symkyn Thomas yeoman 587802 587802 Symkyn, Thomas, of Thorp Langton, yeoman 0
5392570 2472944 2472944 defendant Hoghekyne John husbandman 587802 587802 Hoghekyne, John, of Thorp Langton, husbandman 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);