names

13 rows where place_id = 729608

✎ 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
4283467 2124123 2124123 defendant Cowper Thomas yeoman 729608 729608 Cowper, Thomas, of Skendelby, yeoman 3
4283478 2124126 2124126 defendant Bell Michael yeoman 729608 729608 Bell, Michael, of Skendelby, yeoman 1
4283480 2124126 2124126 defendant Cowper Thomas yeoman 729608 729608 Cowper, Thomas, of Skendelby, yeoman 3
4428999 2173873 2173873 defendant Thorp Joan de   729608 729608 Thorp, Joan de, of Skendelby, formerly wife of William, son of Mathew 0
4464824 2189663 2189663 defendant Botheby John   729608 729608 Botheby, John, of Skendelby 0
4539893 2212740 2212740 plaintiff Ward Robert   729608 729608 Ward, Robert, of Skendelby 0
4710548 2268657 2268657 defendant Thurstan John draper 729608 729608 Thurstan, John, of Skendelby, draper 0
4766440 2285496 2285496 defendant Michell Simon husbandman 729608 729608 Michell, Simon, of Skendelby, husbandman 0
4836610 2307422 2307422 defendant Michel Richard   729608 729608 Michel, Richard, of Skendelby, cartwright 0
4836611 2307422 2307422 defendant Michel Simon husbandman 729608 729608 Michel, Simon, of Skendelby, husbandman 1
4863917 2315690 2315690 defendant Michel Richard   729608 729608 Michel, Richard, of Skendelby, cartwright 0
4863918 2315690 2315690 defendant Michel Simon husbandman 729608 729608 Michel, Simon, of Skendelby, husbandman 1
5218891 2421250 2421250 defendant Tatte William husbandman 729608 729608 Tatte, William, of Skendelby, 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);