names

24 rows where place_id = 782185

✎ 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
4676228 2258174 2258174 defendant Erl John yeoman 782185 782185 Erl, John, of Haghle, yeoman 2
4741258 2277940 2277940 defendant Wage John   782185 782185 Wage, John, of Haghle, wright 2
4763338 2284521 2284521 defendant Swan John husbandman 782185 782185 (Swan, John, of Haghle, husbandman 1
4763339 2284521 2284521 defendant Barnabe Thomas   782185 782185 Barnabe, Thomas, of Haghle, vicar 2
4796889 2295183 2295183 plaintiff Shiple John   782185 782185 Shiple, John, of Haghle 0
4802463 2296961 2296961 defendant Shiple John yeoman 782185 782185 Shiple, John, of Haghle, yeoman 0
4802465 2296962 2296962 defendant Shiple John yeoman 782185 782185 Shiple, John, of Haghle, yeoman 0
4805936 2298065 2298065 defendant Tomson John yeoman 782185 782185 Tomson, John, of Haghle, yeoman 3
4806129 2298125 2298125 defendant Perot Robert pardeoner 782185 782185 Perot, Robert, of Haghle, pardeoner 1
4873364 2318624 2318624 plaintiff Peper John   782185 782185 Peper, John, of Haghle 0
4910583 2329819 2329819 defendant Cok William carpenter 782185 782185 Cok, William, of Haghle, carpenter 0
4915251 2331275 2331275 defendant Cok William carpenter 782185 782185 Cok, William, of Haghle, carpenter 3
4942413 2339612 2339612 defendant Schaldeford John husbandman 782185 782185 Schaldeford, John, of Haghle, husbandman 0
4942416 2339612 2339612 defendant Berche Geoffrey husbandman 782185 782185 Berche, Geoffrey, of Haghle, husbandman 3
4944379 2340219 2340219 defendant Deyken Hugh drover 782185 782185 Deyken, Hugh, of Haghle, drover 0
4944380 2340219 2340219 defendant Wycop William yeoman 782185 782185 Wycop, William, of Haghle, yeoman 1
4944398 2340225 2340225 defendant Deykon Hugh drover 782185 782185 Deykon, Hugh, of Haghle, drover 0
4944399 2340225 2340225 defendant Wytop William yeoman 782185 782185 Wytop, William, of Haghle, yeoman 1
4945993 2340735 2340735 defendant Patle Margaret   782185 782185 Patle, Margaret, of Haghle, widow of Patle, John 0
4945995 2340736 2340736 defendant Whytop William singleman 782185 782185 Whytop, William, of Haghle, singleman 0
4972059 2348579 2348579 defendant Bleyne John husbandman 782185 782185 Bleyne, John, of Haghle, husbandman 0
5111182 2389659 2389659 defendant Thynge Simon husbandman 782185 782185 Thynge, Simon, of Haghle, husbandman 1
5111183 2389659 2389659 defendant Ronde John, senior husandman 782185 782185 Ronde, John, senior, of Haghle, husandman 2
5192324 2413493 2413493 plaintiff Sextayn Richard   782185 782185 Sextayn, Richard, of Haghle 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);