names

31 rows where place_id = 757124

✎ 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
4436834 2176261 2176261 plaintiff Sweredeston Nicholas de   757124 757124 Sweredeston, Nicholas de, of Swerdeston, vicar 0
4443522 2182941 2182941 defendant Monk John   757124 757124 Monk, John, of Swerdeston 0
4549026 2215628 2215628 plaintiff Colby John de   757124 757124 Colby, John de, of Swerdeston 0
4666270 2250920 2250920 defendant Ynstas Robert yeoman 757124 757124 Ynstas, Robert, of Swerdeston, yeoman 0
4766128 2285396 2285396 defendant Grenehill John   757124 757124 Grenehill, John, of Swerdeston, vicar 1
4910410 2329771 2329771 defendant Cresse John husbandman 757124 757124 Cresse, John, of Swerdeston, husbandman 0
4910411 2329771 2329771 defendant Chaloner Thomas husbandman 757124 757124 Chaloner, Thomas, of Swerdeston, husbandman 1
4942449 2339625 2339625 defendant Peye Nicholas husbandman 757124 757124 Peye, Nicholas, of Swerdeston, husbandman 0
4992432 2354620 2354620 defendant Barsham John de smith 757124 757124 Barsham, John de, of Swerdeston, smith 5
4994111 2355112 2355112 defendant Lely John husbandman 757124 757124 Lely, John, of Swerdeston, husbandman 2
5019168 2362495 2362495 defendant de Barsham John smith 757124 757124 de Barsham, John, of Swerdeston, smith 3
5053502 2372652 2372652 defendant Lely John smith 757124 757124 Lely, John, of Swerdeston, smith 0
5073742 2378633 2378633 defendant Lely John smith 757124 757124 Lely, John, of Swerdeston, smith 1
5105108 2387928 2387928 defendant Bennys William yeoman 757124 757124 Bennys, William, of Swerdeston, yeoman 1
5110544 2389483 2389483 plaintiff Haken or Hacon Thomas clerk 757124 757124 Haken or Hacon, Thomas, of Swerdeston, clerk 0
5110545 2389483 2389483 defendant Peye Nicholas husbandman 757124 757124 Peye, Nicholas, of Swerdeston, husbandman 0
5110546 2389483 2389483 defendant Kensy William yeoman 757124 757124 Kensy, William, of Swerdeston, yeoman 1
5144062 2399411 2399411 defendant Pey Nicholas husbandman 757124 757124 Pey, Nicholas, of Swerdeston, husbandman 0
5171659 2407431 2407431 defendant Pryce William gent 757124 757124 Pryce, William, of Swerdeston, gent 1
5190324 2412913 2412913 defendant Pryce William gent 757124 757124 Pryce, William, of Swerdeston, gent 1
5206873 2417745 2417745 defendant Pryce William gent 757124 757124 Pryce, William, of Swerdeston, gent 1
5285764 2440862 2440862 defendant Catour John husbandman 757124 757124 Catour, John, of Swerdeston, husbandman 0
5285765 2440862 2440862 defendant Peye Nicholas husbandman 757124 757124 Peye, Nicholas,of Swerdeston, husbandman 1
5530134 2513931 2513931 defendant Reygn John clerk 757124 757124 Reygn, John, of Swerdeston, clerk 2
5554816 2521408 2521408 defendant Rayn John clerk 757124 757124 Rayn, John, of of Swerdeston, clerk 2
5570770 2526012 2526012 defendant Chaundeler John husbandman 757124 757124 Chaundeler, John, of Swerdeston, husbandman 0
5570771 2526012 2526012 defendant Kensey Johnm husbandman 757124 757124 Kensey, Johnm, of Swerdeston, husbandman 1
5570772 2526012 2526012 defendant Chapman Henry husbandman 757124 757124 Chapman, Henry, of Swerdeston, husbandman 2
5588131 2531297 2531297 defendant Reyn John clerk 757124 757124 Reyn, John, of Swerdeston, clerk 1
5628104 2552761 2552761 defendant Stalon Robert yeoman 757124 757124 Stalon, Robert, of Swerdeston, yeoman 0
5634403 2554754 2554754 defendant Brewyn John yeoman 757124 757124 Brewyn, John, of Swerdeston, 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);