names

19 rows where place_id = 634683

✎ 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
3820525 1964304 1964304 defendant Chelle John tailor 634683 634683 Chelle, John, of West Meston, tailor 1
3864251 1978236 1978236 defendant Pacon Richard yeoman 634683 634683 Pacon, Richard, of West Meston, yeoman 0
3893772 1988135 1988135 defendant Upgate John carver 634683 634683 Upgate, John, of West Meston, carver 0
4184389 2090041 2090041 defendant Earle Richard gent 634683 634683 Earle, Richard, of West Meston, gent 0
4330890 2140632 2140632 defendant Lullyngdon Drew yeoman 634683 634683 Lullyngdon, Drew, of West Meston, yeoman 0
4444653 2183306 2183306 plaintiff Colman John   634683 634683 Colman, John, of West Meston, formerly parson 0
4635887 2242058 2242058 defendant Tebald Richard   634683 634683 Tebald, Richard, of West Meston 21
4782871 2290663 2290663 defendant Reynold John, senior husbandman 634683 634683 Reynold, John, senior, of West Meston, husbandman 0
4782872 2290663 2290663 defendant Reynold John, junior laborer 634683 634683 Reynold, John, junior, of West Meston, laborer 1
4782873 2290663 2290663 defendant Page Thomas laborer 634683 634683 Page, Thomas, of West Meston, laborer 2
4782875 2290664 2290664 defendant Herdyng John laborer 634683 634683 Herdyng, John, of West Meston, laborer 0
4782876 2290664 2290664 defendant Fayrgo Simon laborer 634683 634683 Fayrgo, Simon, of West Meston, laborer 1
4788449 2292452 2292452 defendant Croftes John husbandman 634683 634683 Croftes, John, of West Meston, husbandman 0
4788452 2292453 2292453 defendant Croftes John husbandman 634683 634683 Croftes, John, of West Meston, husbandman 0
4793032 2293912 2293912 defendant Croftes John husbandman 634683 634683 Croftes, John, of West Meston, husbandman 0
5126593 2394254 2394254 plaintiff Bradmede William   634683 634683 Bradmede, William, of West Meston, parson 0
5130932 2395527 2395527 defendant Perys William miller 634683 634683 Perys, William, of West meston, miller 0
5145273 2399758 2399758 plaintiff Bradmede William   634683 634683 Bradmede, William, of West Meston 0
5161379 2404423 2404423 defendant Bradmed William chaplain 634683 634683 Bradmed, William, of West Meston, chaplain 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);