names

20 rows where place_id = 588840

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595752 1866303 1866303 defendant Bernys Thomas yeoman 588840 588840 Bernys, Thomas, of Sondon, Beds, yeoman 0
3958089 2009896 2009896 defendant Lee John gent 588840 588840 Lee, John, of Sondon, Beds, gent 0
3987961 2020440 2020440 defendant Streame Thomas yeoman 588840 588840 Streame, Thomas, of Sondon, Beds, yeoman 0
4738713 2277196 2277196 defendant Drake John clerk 588840 588840 Drake, John, of Sondon, Beds, clerk 3
4875308 2319231 2319231 defendant Bern Edward husbandman 588840 588840 Bern, Edward, of Sondon, Beds, husbandman 0
4925438 2334390 2334390 defendant Omond Richard husbandman 588840 588840 Omond, Richard, of Sondon, Beds, husbandman 1
4934053 2337031 2337031 defendant Berne Edward yeoman 588840 588840 Berne, Edward, of Sondon, Beds, yeoman 0
4934055 2337032 2337032 defendant Berne Edward yeoman 588840 588840 Berne, Edward, of Sondon, Beds, yeoman 0
4934057 2337033 2337033 defendant Welles John parker 588840 588840 Welles, John, of Sondon, Beds, parker 0
4934059 2337034 2337034 defendant Welles John parker 588840 588840 Welles, John, of Sondon, Beds, parker 0
4985932 2352710 2352710 defendant Berne Edward yeoman 588840 588840 Berne, Edward, of Sondon, Beds, yeoman 0
4985934 2352711 2352711 defendant Welles John   588840 588840 Welles, John, of Sondon, Beds, park man 0
5007912 2359202 2359202 defendant Frebern John, sen husbandman 588840 588840 Frebern, John, sen, of Sondon, Beds, husbandman 0
5161534 2404472 2404472 defendant Kerver John husbandman 588840 588840 Kerver, John, of Sondon, Beds, husbandman 0
5175910 2408636 2408636 defendant Kerver John husbandman 588840 588840 Kerver, John, of Sondon, Beds, husbandman 0
5209305 2418455 2418455 defendant Buntyng John clerk 588840 588840 Buntyng, John, of Sondon, Beds, clerk 2
5261887 2433825 2433825 defendant Bernes John yeoman 588840 588840 Bernes, John, of Sondon, Beds, yeoman 4
5261893 2433826 2433826 defendant Bernes John yeoman 588840 588840 Bernes, John, of Sondon, Beds, or of Hensworth, Herts, yeoman 3
5302133 2445594 2445594 defendant Bern Edmund husbandman 588840 588840 Bern, Edmund, of Sondon, Beds, husbandman 1
5590410 2531972 2531972 defendant Carver John yeoman 588840 588840 Carver, John, of Sondon, Beds, 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);