names

41 rows where place_id = 771458

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4578433 2224741 2224741 plaintiff Clerk Thomas   771458 771458 Clerk, Thomas, of Erdeley 0
4611279 2234592 2234592 plaintiff Clerk John   771458 771458 Clerk, John, of Erdeley 0
4632961 2241180 2241180 defendant Hogge John   771458 771458 Hogge, John, of Erdeley 0
4632962 2241180 2241180 defendant Leffyng Thomas   771458 771458 Leffyng, Thomas, of Erdeley 1
4665803 2250780 2250780 defendant Austyn John husbandman 771458 771458 Austyn, John, of Erdeley, husbandman 0
4665805 2250781 2250781 defendant Austyn John husbandman 771458 771458 Austyn, John, of Erdeley, husbandman 0
4678580 2258907 2258907 defendant Cotesmore William   771458 771458 Cotesmore, William, of Erdeley, vicar 0
4678581 2258907 2258907 defendant Austen John, senior husbandman 771458 771458 Austen, John, senior, of Erdeley, husbandman 1
4801865 2296766 2296766 defendant Bernard John   771458 771458 Bernard, John, of Erdeley, servant 0
4840251 2308499 2308499 defendant Shotbolt John husbandman 771458 771458 Shotbolt, John, of Erdeley, husbandman 0
4898427 2326163 2326163 defendant Prat John maltman 771458 771458 Prat, John, of Erdeley, maltman 0
4904294 2327959 2327959 defendant Prat John maltman 771458 771458 Prat, John, of Erdeley, maltman 0
4934273 2337107 2337107 defendant Shotbolte Roger husbandman 771458 771458 Shotbolte, Roger, of Erdeley, husbandman 1
4944781 2340354 2340354 plaintiff Hendry John   771458 771458 Hendry, John, of Erdeley 0
4959233 2344730 2344730 defendant Prat John maltman 771458 771458 Prat, John, of Erdeley, maltman 2
5006720 2358859 2358859 defendant Shotbolte Roger husbandman 771458 771458 Shotbolte, Roger, of Erdeley, husbandman 0
5006721 2358859 2358859 defendant Shotbolt Nicholas (legal representative) 771458 771458 Shotbolt, Nicholas, of Erdeley, executor of 1
5006722 2358859 2358859 defendant Shotbolte Roger yeoman 771458 771458 Shotbolte, Roger, of Erdeley, yeoman 2
5033398 2366649 2366649 defendant Smyth Stephen smith 771458 771458 Smyth, Stephen, of Erdeley, smith 0
5076097 2379350 2379350 defendant Halfhyde William barker 771458 771458 Halfhyde, William, of Erdeley, barker 0
5111783 2389838 2389838 defendant Pope John husbandman 771458 771458 Pope, John, of Erdeley, husbandman 0
5125232 2393858 2393858 plaintiff Austyn John (legal representative) 771458 771458 Austyn, John, of Erdeley, clerk, executor of 0
5137490 2397477 2397477 defendant Austyn Richard   771458 771458 Austyn, Richard, of Erdeley, malt man 1
5137491 2397477 2397477 defendant Dogge or Bogge William maltman 771458 771458 Dogge or Bogge, William, of Erdeley, maltman 2
5137815 2397570 2397570 plaintiff Coward John   771458 771458 Coward, John, of Erdeley 1
5138095 2397650 2397650 defendant Andrewe Thomas butcher 771458 771458 Andrewe, Thomas, of Erdeley, butcher 0
5138096 2397650 2397650 defendant Meyke Thomas clerk 771458 771458 Meyke, Thomas, of Erdeley, clerk 1
5158141 2403499 2403499 plaintiff Pope John   771458 771458 Pope, John, of Erdeley 0
5160156 2404070 2404070 defendant Botour Thomas tanner 771458 771458 Botour, Thomas, of Erdeley, tanner 0
5193936 2413956 2413956 plaintiff Pope John   771458 771458 Pope, John, of Erdeley 0
5195515 2414439 2414439 defendant Shepherd John husbandman 771458 771458 Shepherd, John, of Erdeley, husbandman 0
5195612 2414466 2414466 defendant Shepherd John husbandman 771458 771458 Shepherd, John, of Erdeley, husbandman 0
5195613 2414466 2414466 defendant Austyn John yeoman 771458 771458 Austyn, John, of Erdeley, yeoman 1
5197984 2415149 2415149 defendant Shepherd John husbandman 771458 771458 Shepherd, John, of Erdeley, husbandman 0
5197985 2415149 2415149 defendant Austyn John yeoman 771458 771458 Austyn, John, of Erdeley, yeoman 1
5208469 2418206 2418206 plaintiff Pope John   771458 771458 Pope, John, of Erdeley 0
5219016 2421291 2421291 defendant Clerk James yeoman 771458 771458 Clerk, James, of Erdeley, yeoman 2
5219017 2421291 2421291 defendant Bassyngbourn Richard yeoman 771458 771458 Bassyngbourn, Richard, of Erdeley, yeoman 3
5634830 2554889 2554889 defendant Hogge John maltman 771458 771458 Hogge, John, of Erdeley, maltman 0
5634831 2554889 2554889 defendant atte Hache Richard husbandman 771458 771458 atte Hache, Richard, of Erdeley, husbandman 1
5634832 2554889 2554889 defendant Shotbold Nicholas husbandman 771458 771458 Shotbold, Nicholas, of Erdeley, husbandman 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);