names

24 rows where place_id = 772080

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4585122 2226767 2226767 defendant Smyth Robert   772080 772080 Smyth, Robert, of Illegh Combusta 0
4672835 2257145 2257145 defendant Wyseman John husbandman 772080 772080 Wyseman, John, of Illegh Combusta, husbandman 0
4918940 2332437 2332437 defendant Wyseman John husbandman 772080 772080 Wyseman, John, of Illegh Combusta, husbandman 0
4926113 2334593 2334593 defendant Coo John husbandman 772080 772080 Coo, John, of Illegh Combusta, husbandman 2
4997214 2356020 2356020 defendant Londe or Loude John tanner 772080 772080 Londe or Loude, John, of Illegh Combusta, tanner 3
5000559 2357033 2357033 defendant Webbe John yeoman 772080 772080 Webbe, John, of Illegh Combusta, yeoman 0
5129851 2395216 2395216 defendant Cogkesale John   772080 772080 Cogkesale, John, of Illegh Combusta, husbandman, administrators of 0
5168148 2406395 2406395 defendant Crogkesale John   772080 772080 Crogkesale, John, of Illegh Combusta, husbandman, administrators of 0
5197566 2415025 2415025 defendant Cokeyn Thomas husbandman 772080 772080 Cokeyn, Thomas, of Illegh Combusta, husbandman 2
5197567 2415025 2415025 defendant Cokeyn Richard husbandman 772080 772080 Cokeyn, Richard, of Illegh Combusta, husbandman 3
5197577 2415028 2415028 defendant Cokeyn Thomas husbandman 772080 772080 Cokeyn, Thomas, of Illegh Combusta, husbandman 2
5197578 2415028 2415028 defendant Cokeyn Richard husbandman 772080 772080 Cokeyn, Richard, of Illegh Combusta, husbandman 3
5197582 2415029 2415029 defendant Cokeyn Thomas husbandman 772080 772080 Cokeyn, Thomas, of Illegh Combusta, husbandman 2
5197583 2415029 2415029 defendant Cokeyn Richard husbandman 772080 772080 Cokeyn, Richard, of Illegh Combusta, husbandman 3
5210205 2418710 2418710 defendant Cokeyn Thomas husbandman 772080 772080 Cokeyn, Thomas, of Illegh Combusta, husbandman 2
5210206 2418710 2418710 defendant Cokeyn Richard husbandman 772080 772080 Cokeyn, Richard, of Illegh Combusta, husbandman 3
5296011 2443823 2443823 defendant Heyward John husbandman 772080 772080 Heyward, John, of Illegh Combusta, husbandman 0
5386525 2471214 2471214 defendant Perkyn George yeoman 772080 772080 Perkyn, George, of Illegh Combusta, yeoman 2
5386528 2471214 2471214 defendant Comegeyn William clothmaker 772080 772080 Comegeyn, William, of Illegh Combusta, clothmaker 5
5389999 2472200 2472200 defendant Neve John chapman 772080 772080 Neve, John, of Illegh Combusta, chapman 3
5398845 2474732 2474732 defendant Comegeyn William   772080 772080 Comegeyn, William, of Illegh Combusta, cloth maker 1
5411926 2478520 2478520 defendant Comegeyn William clothmaker 772080 772080 Comegeyn, William, of Illegh Combusta, clothmaker 1
5456920 2491973 2491973 defendant Comayn William   772080 772080 Comayn, William, of Illegh Combusta, cloth maker 3
5456921 2491973 2491973 defendant Kempe John husbandman 772080 772080 Kempe, John, of Illegh Combusta, husbandman 4

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