names

15 rows where place_id = 615326

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3708293 1928888 1928888 defendant Burnby William husbandman 615326 615326 Burnby, William, of Maunton, husbandman 1
3708294 1928888 1928888 defendant Laurens Thomas husbandman 615326 615326 Laurens, Thomas, of Maunton, husbandman 2
3708295 1928888 1928888 defendant Cheselden Richard husbandman 615326 615326 Cheselden, Richard, of Maunton, husbandman 3
4109469 2063649 2063649 defendant Pimperton John tailor 615326 615326 Pimperton, John, of Maunton, tailor 0
4139897 2074637 2074637 defendant Launder William yeoman 615326 615326 Launder, William, of Maunton, yeoman 2
4729536 2274449 2274449 defendant Hornsee Thomas chapman 615326 615326 Hornsee, Thomas, of Maunton, chapman 0
5010397 2359908 2359908 defendant Bowre John   615326 615326 Bowre, John, of Maunton, parson 0
5314143 2449245 2449245 defendant Tomson John husbandman 615326 615326 Tomson, John, of Maunton, husbandman 1
5320952 2451356 2451356 defendant Johnson Thomas husbandman 615326 615326 Johnson, Thomas, of Maunton, husbandman 1
5341702 2457596 2457596 defendant Knyght William husbandman 615326 615326 Knyght, William, of Maunton, husbandman 9
5341703 2457596 2457596 defendant Burnby Richard husbandman 615326 615326 Burnby, Richard, of Maunton, husbandman 10
5341704 2457596 2457596 defendant Goldesburgh John laborer 615326 615326 Goldesburgh, John, of Maunton, laborer 11
5506141 2506839 2506839 defendant Laurence Robert clerk 615326 615326 Laurence, Robert, of Maunton, clerk 0
5536210 2515820 2515820 defendant Belyngham Thomas gent 615326 615326 Belyngham, Thomas, of Maunton, gent 0
5636010 2555219 2555219 defendant Holme Thomas cooper 615326 615326 Holme, Thomas, of Maunton, cooper 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);