names

26 rows where place_id = 614983

✎ 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
3706520 1928324 1928324 defendant Benett Thomas gent 614983 614983 Benett, Thomas, of Carleby, gent 0
3856873 1975779 1975779 defendant Jesop Robert husbandman 614983 614983 Jesop, Robert, of Carleby, husbandman 0
4428960 2173859 2173859 defendant Hardy Richard   614983 614983 Hardy, Richard, of Carleby 0
4459050 2187875 2187875 plaintiff Rome John   614983 614983 Rome, John, of Carleby 0
4499984 2200636 2200636 plaintiff Holand John   614983 614983 Holand, John, of Carleby, son of William Holand 0
4517422 2205850 2205850 defendant Malsal John   614983 614983 Malsal, John, of Carleby 0
4925011 2334254 2334254 defendant Thornef Richard yeoman 614983 614983 Thornef, Richard, of Carleby, yeoman 0
4970771 2348199 2348199 defendant Ovour Thomas yeoman 614983 614983 Ovour, Thomas, of Carleby, yeoman 1
4970774 2348200 2348200 defendant Ovour Thomas yeoman 614983 614983 Ovour, Thomas, of Carleby, yeoman 1
5009922 2359776 2359776 defendant Knappe Thomas husbandman 614983 614983 Knappe, Thomas, of Carleby, husbandman 3
5015002 2361267 2361267 defendant Ingoldesby William husbandman 614983 614983 Ingoldesby, William, of Carleby, husbandman 0
5119217 2392047 2392047 defendant White Hugh husbandman 614983 614983 White, Hugh, of Carleby, husbandman 0
5119218 2392047 2392047 defendant Whyte Robert husbandman 614983 614983 Whyte, Robert, of Carleby, husbandman 1
5191075 2413128 2413128 defendant Shepe John husbandman 614983 614983 Shepe, John, of Carleby, husbandman 5
5230562 2424553 2424553 defendant Shepe John husbandman 614983 614983 Shepe, John, of Carleby, husbandman 0
5374435 2467611 2467611 plaintiff Othelee Richard   614983 614983 Othelee, Richard, of Carleby 0
5392130 2472834 2472834 plaintiff Roo William   614983 614983 Roo, William, of Carleby 0
5405163 2476557 2476557 plaintiff Roo William   614983 614983 Roo, William, of Carleby 0
5418240 2480380 2480380 plaintiff Roo William   614983 614983 Roo, William, of Carleby 0
5418242 2480381 2480381 plaintiff Roo William   614983 614983 Roo, William, of Carleby 0
5476036 2497846 2497846 defendant Hughson William husbandman 614983 614983 Hughson, William, of Carleby, husbandman 4
5513391 2509040 2509040 plaintiff Othlee Richard   614983 614983 Othlee, Richard, of Carleby 0
5513398 2509041 2509041 plaintiff Othlee Richard   614983 614983 Othlee, Richard, of Carleby 0
5513405 2509042 2509042 plaintiff Othlee Richard   614983 614983 Othlee, Richard, of Carleby 0
5597563 2534137 2534137 defendant Reve Martin yeoman 614983 614983 Reve, Martin, of Carleby, yeoman 0
5597564 2534137 2534137 defendant Smyth Robert yeoman 614983 614983 Smyth, Robert, of Carleby, yeoman 1

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);