names

20 rows where place_id = 592748

✎ 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
3608739 1870396 1870396 defendant Manchester John husbandman 592748 592748 Manchester, John, of Bulcote, husbandman 1
3655121 1911863 1911863 defendant Berwyk Alfred gent & kinsman & heir of Margaret Berwyk 592748 592748 Berwyk, Alfred, of Bulcote, gent & son of Thomas Berwyke, gent & kinsman & heir of Margaret Berwyk 0
3844797 1971917 1971917 defendant Culbery Henry husbandman 592748 592748 Culbery, Henry, of Bulcote, husbandman 1
4580415 2225359 2225359 plaintiff Dawe John   592748 592748 Dawe, John, of Bulcote 0
4580416 2225359 2225359 plaintiff Spark John   592748 592748 Spark, John, of Bulcote 1
4735231 2276167 2276167 defendant Arnald Robert husbandman 592748 592748 Arnald, Robert, of Bulcote, husbandman 0
4735232 2276167 2276167 defendant Arnald John yeoman 592748 592748 Arnald, John, of Bulcote, yeoman 1
4801789 2296741 2296741 defendant Beyle John husbandman 592748 592748 Beyle, John, of Bulcote, husbandman 3
4828425 2304934 2304934 defendant Warde Thomas husbandman 592748 592748 Warde, Thomas, of Bulcote, husbandman 1
5068517 2377076 2377076 defendant Bewepe Katherine widow 592748 592748 Bewepe, Katherine, of Bulcote, widow 1
5076262 2379402 2379402 defendant Wychenell William husbandman 592748 592748 Wychenell, William, of Bulcote, husbandman 2
5211988 2419244 2419244 defendant Roweley Thomas gent 592748 592748 Roweley, Thomas, of Bulcote, gent 0
5211989 2419244 2419244 defendant Botman Thomas laborer 592748 592748 Botman, Thomas, of Bulcote, laborer 1
5218471 2421133 2421133 defendant Roweley Thomas gent 592748 592748 Roweley, Thomas, of Bulcote, gent 0
5218472 2421133 2421133 defendant Botman Thomas laborer 592748 592748 Botman, Thomas, of Bulcote, laborer 1
5233476 2425382 2425382 defendant Wythenyll William yeoman 592748 592748 Wythenyll, William, of Bulcote, yeoman 0
5263542 2434346 2434346 defendant Wythyvyll or Wythynyll William husbandman 592748 592748 Wythyvyll or Wythynyll, William, of Bulcote, husbandman 3
5376268 2468172 2468172 defendant Shoter Edmund tailor 592748 592748 Shoter, Edmund, of Bulcote, tailor 1
5392368 2472901 2472901 defendant Berwyk Alfred   592748 592748 Berwyk, Alfred, of Bulcote 3
5489646 2501785 2501785 defendant Barwyk Margaret widow 592748 592748 Barwyk, Margaret, of Bulcote, widow 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);