names

21 rows where place_id = 634922

✎ 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
3822151 1964824 1964824 plaintiff Sotehyll Robert esq 634922 634922 Sotehyll, Robert, of North Dyghton, esq 0
3972975 2015121 2015121 defendant Stagge Richard yeoman 634922 634922 Stagge, Richard, of North Dyghton, yeoman 0
3972977 2015122 2015122 defendant Stagge Richard yeoman 634922 634922 Stagge, Richard, of North Dyghton, yeoman 0
3972978 2015122 2015122 defendant Bykerdyck Simon yeoman 634922 634922 Bykerdyck, Simon, of North Dyghton, yeoman 1
3972979 2015122 2015122 defendant Howseman George husbandman 634922 634922 Howseman, George, of North Dyghton, husbandman 2
3984302 2019148 2019148 defendant Stagge Richard yeoman 634922 634922 Stagge, Richard, of North Dyghton, yeoman 0
3986731 2019994 2019994 defendant Stagge Richard yeoman 634922 634922 Stagge, Richard, of North Dyghton, yeoman 0
3987186 2020162 2020162 defendant Stagge Richard yeoman 634922 634922 Stagge, Richard, of North Dyghton, yeoman 0
3987187 2020162 2020162 defendant Snawdon Stephen laborer 634922 634922 Snawdon, Stephen, of North Dyghton, laborer 1
3987188 2020162 2020162 defendant Gulyons Christopher husbandman 634922 634922 Gulyons, Christopher, of North Dyghton, husbandman 2
3987189 2020162 2020162 defendant Lowcock Henry carpenter 634922 634922 Lowcock, Henry, of North Dyghton, carpenter 3
4430522 2174314 2174314 defendant Botiller John   634922 634922 Botiller, John, of North Dyghton 0
4430525 2174314 2174314 defendant Horseford John de   634922 634922 Horseford, John de, of North Dyghton 3
4651406 2246445 2246445 defendant Thoresby Richard   634922 634922 Thoresby, Richard, of North Dyghton, wright 1
4651407 2246445 2246445 defendant Feliskirke John husbandman 634922 634922 Feliskirke, John, of North Dyghton, husbandman 2
4651409 2246445 2246445 defendant Perys John husbandman 634922 634922 Perys, John, of North Dyghton, husbandman 4
4726598 2273593 2273593 defendant Thuresby Richard husbandman 634922 634922 Thuresby, Richard, of North Dyghton, husbandman 5
4960129 2344997 2344997 defendant Bentham Robert husbandman 634922 634922 Bentham, Robert, of North Dyghton, husbandman 0
5148834 2400781 2400781 defendant Bonnay Richard yeoman 634922 634922 Bonnay, Richard, of North Dyghton, yeoman 1
5445450 2488536 2488536 defendant Wylson Robert   634922 634922 Wylson, Robert, of North Dyghton 0
5445459 2488540 2488540 defendant Wylson Robert   634922 634922 Wylson, Robert, of North Dyghton 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);