names

31 rows where place_id = 637713

✎ 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
3838088 1969827 1969827 defendant Johnson Richard husbandman 637713 637713 Johnson, Richard, of Manthorp, husbandman 0
3838089 1969827 1969827 defendant Twynse Richard husbandman 637713 637713 Twynse, Richard, of Manthorp, husbandman 1
3838090 1969827 1969827 defendant Page John husbandman 637713 637713 Page, John, of Manthorp, husbandman 2
3904729 1991840 1991840 defendant Quynoy Thomas husbandman 637713 637713 Quynoy, Thomas, of Manthorp, husbandman 0
4481654 2194959 2194959 plaintiff Lytster John   637713 637713 Lytster, John, of Manthorp 0
4544997 2214356 2214356 defendant Hull Robert   637713 637713 Hull, Robert, of Manthorp 0
4545000 2214356 2214356 defendant Walker William   637713 637713 Walker, William, of Manthorp 3
4652941 2246850 2246850 defendant Gonyld Henry laborer 637713 637713 Gonyld, Henry, of Manthorp, laborer 5
4656739 2248003 2248003 defendant Rounceby William   637713 637713 Rounceby, William, of Manthorp 0
4656740 2248003 2248003 defendant Warde William   637713 637713 Warde, William, of Manthorp 1
4656741 2248003 2248003 defendant Walker William   637713 637713 together with Walker, William, of Manthorp 2
4673320 2257293 2257293 defendant Gylbert Robert husbandman 637713 637713 Gylbert, Robert, of Manthorp, husbandman 0
4774395 2287974 2287974 defendant Milner John miller 637713 637713 Milner, John, of Manthorp, formerly of Baston, miller 1
4791838 2293549 2293549 defendant Shepherd John   637713 637713 Shepherd, John, of Manthorp, shepherd 0
4816386 2301218 2301218 plaintiff Lytster John   637713 637713 Lytster, John, of Manthorp 0
4870489 2317743 2317743 plaintiff Lytster John   637713 637713 Lytster, John, of Manthorp 0
4870491 2317743 2317743 defendant Gilberd Thomas husbandman 637713 637713 Gilberd, Thomas, of Manthorp, husbandman 1
5082853 2381376 2381376 defendant Bocher John husbandman 637713 637713 together wirh Bocher, John, of Manthorp, husbandman 1
5222043 2422151 2422151 defendant Goneld Richard husbandman 637713 637713 Goneld, Richard, of Manthorp, husbandman 0
5236255 2426191 2426191 defendant Lok John husbandman 637713 637713 Lok, John, of Manthorp, husbandman 1
5236256 2426191 2426191 defendant Laxton John husbandman 637713 637713 Laxton, John, of Manthorp, husbandman 2
5236257 2426191 2426191 defendant Gylbard Henry husbandman 637713 637713 Gylbard, Henry, of Manthorp, husbandman 3
5236258 2426191 2426191 defendant Gylbard Robert husbandman 637713 637713 Gylbard, Robert, of Manthorp, husbandman 4
5236380 2426232 2426232 defendant Lok John husbandman 637713 637713 Lok, John, of Manthorp, husbandman 1
5236382 2426232 2426232 defendant Gylbard Henry husbandman 637713 637713 Gylbard, Henry, of Manthorp, husbandman 3
5236383 2426232 2426232 defendant Gylbard Robert husbandman 637713 637713 Gylbard, Robert, of Manthorp, husbandman 4
5383811 2470455 2470455 defendant Freman William yeoman 637713 637713 Freman, William, of Manthorp, yeoman 1
5399617 2474973 2474973 defendant Tompson William miller 637713 637713 Tompson, William, of Manthorp, miller 2
5412626 2478722 2478722 defendant Thompson William miller 637713 637713 Thompson, William, of Manthorp, miller 2
5427500 2483176 2483176 defendant Thompson William miller 637713 637713 Thompson, William, of Manthorp, miller 2
5445231 2488465 2488465 defendant Thorplon William miller 637713 637713 Thorplon, William, of Manthorp, miller 2

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