names

13 rows where place_id = 603004

✎ 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
3652641 1911160 1911160 defendant Button James yeoman 603004 603004 Button, James, of Amptell, Beds, yeoman 2
3669966 1916550 1916550 defendant Lewes Thomas gent 603004 603004 Lewes, Thomas, of Amptell, Beds, gent 2
3670677 1916793 1916793 defendant Lewes Thomas gent 603004 603004 Lewes, Thomas, of Amptell, Beds, gent 3
3762901 1946031 1946031 defendant Boughton Richard husbandman 603004 603004 Boughton, Richard, of Amptell, Beds, husbandman 3
4271506 2120050 2120050 defendant Merser John yeoman 603004 603004 Merser, John, of Amptell, Beds, yeoman 1
4271511 2120051 2120051 defendant Merser John yeoman 603004 603004 Merser, John, of Amptell, Beds, yeoman 1
4378329 2157321 2157321 defendant Foster Charles yeoman 603004 603004 Foster, Charles, of Amptell, Beds, yeoman 0
4378331 2157322 2157322 defendant Foster Giles warrener 603004 603004 Foster, Giles, of Amptell, Beds, yeoman, warrener 0
4890835 2323882 2323882 defendant Gillowe Antony Richard chapman 603004 603004 Gillowe Antony, Richard, of Amptell, Beds, chapman 0
5275103 2437797 2437797 defendant Grey William gent 603004 603004 Grey, William, of Amptell, Beds, gent 1
5295402 2443646 2443646 defendant de la Chambyr Peter yeoman 603004 603004 de la Chambyr, Peter, of Amptell, Beds, yeoman 0
5550907 2520298 2520298 defendant Keche John   603004 603004 Keche, John,of Amptell, Beds, cook 0
5555407 2521585 2521585 defendant Clyfford Henry clerk 603004 603004 Clyfford, Henry, of Amptell, Beds, clerk 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);