names

29 rows where place_id = 590714

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3602067 1868309 1868309 defendant Faukener William, junior husbandman 590714 590714 Faukener, William, junior, of Magna Teynton, husbandman 0
3692079 1923692 1923692 defendant Slyde William husbandman 590714 590714 Slyde, William, of Magna Teynton, husbandman 0
3692080 1923692 1923692 defendant Slyde James husbandman 590714 590714 Slyde, James, of Magna Teynton, husbandman 1
3692081 1923692 1923692 defendant Slyde Richard husbandman 590714 590714 Slyde, Richard, of Magna Teynton, husbandman 2
3692086 1923693 1923693 defendant Wynd Simon husbandman 590714 590714 Wynd, Simon, of Magna Teynton, husbandman 0
3845142 1972041 1972041 defendant Crokker William husbandman 590714 590714 Crokker, William, of Magna Teynton, husbandman 2
3904891 1991900 1991900 defendant Wele William husbandman 590714 590714 Wele, William, of Magna Teynton, husbandman 3
3904892 1991900 1991900 defendant Ellye John husbandman 590714 590714 Ellye, John, of Magna Teynton, husbandman 4
3904893 1991900 1991900 defendant Horne Edward husbandman 590714 590714 Horne, Edward, of Magna Teynton, husbandman 5
3904894 1991900 1991900 defendant Fyssher Roger shoemaker 590714 590714 Fyssher, Roger, of Magna Teynton, shoemaker 6
3904896 1991900 1991900 defendant Hartland John husbandman 590714 590714 Hartland, John, of Magna Teynton, husbandman 8
3904898 1991900 1991900 defendant Fawkener John collier 590714 590714 Fawkener, John, of Magna Teynton, collier 10
3904899 1991900 1991900 defendant Dale Philip collier 590714 590714 Dale, Philip, of Magna Teynton, collier 11
3904902 1991900 1991900 defendant Cradock Hugh laborer 590714 590714 Cradock, Hugh,of Magna Teynton, laborer 14
3904905 1991901 1991901 defendant Dale Philip collier 590714 590714 Dale, Philip, of Magna Teynton, collier 1
3904906 1991901 1991901 defendant Fawkener John collier 590714 590714 Fawkener, John, of Magna Teynton, collier 2
3904907 1991901 1991901 defendant Overthrowe John collier 590714 590714 Overthrowe, John, of Magna Teynton, collier 3
4659172 2248741 2248741 defendant Kynget John husbandman 590714 590714 Kynget, John, of Magna Teynton, husbandman 0
4661424 2249401 2249401 defendant Aylwy Thomas husbandman 590714 590714 Aylwy, Thomas, of Magna Teynton, husbandman 0
5267286 2435531 2435531 defendant Garald John yeoman 590714 590714 Garald, John, of Magna Teynton, yeoman 0
5509473 2507812 2507812 defendant Alewey Thomas husbandman 590714 590714 Alewey, Thomas, of Magna Teynton, husbandman 0
5509474 2507812 2507812 defendant Slyte William husbandman 590714 590714 Slyte, William, of Magna Teynton, husbandman 1
5509477 2507813 2507813 defendant Alewey Thomas husbandman 590714 590714 Alewey, Thomas, of Magna Teynton, husbandman 0
5509478 2507813 2507813 defendant Slyte William husbandman 590714 590714 Slyte, William, of Magna Teynton, husbandman 1
5517874 2510432 2510432 defendant Slyte William husbandman 590714 590714 Slyte, William, of Magna Teynton, husbandman 0
5517887 2510438 2510438 defendant Slyte William husbandman 590714 590714 Slyte, William, of Magna Teynton, husbandman 0
5553139 2520957 2520957 defendant Slyde William yeoman 590714 590714 Slyde, William, of Magna Teynton, yeoman 0
5578603 2528379 2528379 defendant Aylewey Roger yeoman 590714 590714 Aylewey, Roger, of Magna Teynton, yeoman 0
5578605 2528380 2528380 defendant Aylewey Roger yeoman 590714 590714 Aylewey, Roger, of Magna Teynton, yeoman 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);