names

23 rows where place_id = 599307

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3636185 1906105 1906105 defendant Barker William husbandman 599307 599307 Barker, William, of Torlaton, husbandman 1
4732674 2275399 2275399 defendant Martell Hugh   599307 599307 Martell, Hugh, of Torlaton, parson 0
4872729 2318422 2318422 defendant Barry Edmund gent 599307 599307 Barry, Edmund, of Torlaton, gent 0
4972230 2348639 2348639 defendant Barre Edmund gent 599307 599307 Barre, Edmund, of Torlaton, gent 0
4998575 2356458 2356458 defendant Barre Edmund gent 599307 599307 Barre, Edmund, of Torlaton, gent 0
5038120 2368035 2368035 defendant Barry Edmund gent 599307 599307 Barry, Edmund, of Torlaton, gent 0
5067737 2376849 2376849 defendant Hervy Thomas husbandman 599307 599307 Hervy, Thomas, of Torlaton, husbandman 0
5099621 2386325 2386325 defendant Barry Edmund gent 599307 599307 Barry, Edmund, of Torlaton, gent 0
5113850 2390439 2390439 defendant Barry Edmund gent 599307 599307 Barry, Edmund, of Torlaton, gent 0
5117411 2391524 2391524 defendant Barre Edmund gent 599307 599307 Barre, Edmund, of Torlaton, gent 4
5157618 2403356 2403356 defendant Barry Edmund esq 599307 599307 Barry, Edmund, of Torlaton, esq 0
5193476 2413820 2413820 defendant Barry Edmund esq 599307 599307 Barry, Edmund, of Torlaton, esq 0
5244129 2428474 2428474 defendant Barry Edmund gent 599307 599307 Barry, Edmund, of Torlaton, gent 0
5312642 2448818 2448818 defendant Hawes Thomas husbandman 599307 599307 Hawes, Thomas, of Torlaton, husbandman 0
5381336 2469714 2469714 defendant Pyght Henry husbandman 599307 599307 Pyght, Henry, of Torlaton, husbandman 0
5381338 2469715 2469715 defendant Sharp John husbandman 599307 599307 Sharp, John, of Torlaton, husbandman 0
5384080 2470535 2470535 defendant Lovet Robert husbandman 599307 599307 Lovet, Robert, of Torlaton, husbandman 0
5388353 2471715 2471715 defendant Pyght Henry husbandman 599307 599307 Pyght, Henry, of Torlaton, husbandman 0
5388355 2471716 2471716 defendant Pyght Henry husbandman 599307 599307 Pyght, Henry, of Torlaton, husbandman 0
5388359 2471718 2471718 defendant Sharp John husbandman 599307 599307 Sharp, John, of Torlaton, husbandman 0
5543943 2518216 2518216 defendant Barry Hugh gent 599307 599307 Barry, Hugh, of Torlaton, gent 0
5608870 2537674 2537674 defendant (illegible) Henry husbandman 599307 599307 ---, Henry, of Torlaton, husbandman 0
5608872 2537675 2537675 defendant Sharp John husbandman 599307 599307 Sharp, John, of Torlaton, 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);