names

18 rows where place_id = 617051

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3717567 1931787 1931787 defendant Alward Henry yeoman 617051 617051 Alward, Henry, of Christchurch, yeoman 0
4001730 2025395 2025395 plaintiff Harry Jevan yeoman 617051 617051 Harry, Jevan, of Christchurch, yeoman 0
4113019 2064924 2064924 defendant Kallaway Ambrose esq 617051 617051 Kallaway, Ambrose, of Christchurch, esq 0
4124858 2069182 2069182 defendant Rynald John yeoman 617051 617051 Rynald, John, of Christchurch, yeoman 0
4130424 2071195 2071195 defendant Harry Evan (legal representative) 617051 617051 Harry, Evan, of Christchurch, yeoman, executor of 0
4379180 2157636 2157636 defendant Edmond William yeoman 617051 617051 Edmond, William, of Christchurch, yeoman 1
4379181 2157636 2157636 defendant Thomas John yeoman 617051 617051 Thomas, John, of Christchurch, yeoman 2
4379182 2157636 2157636 defendant Morgan Ciprian yeoman 617051 617051 Morgan, Ciprian, of Christchurch, yeoman 3
4565370 2220737 2220737 plaintiff Smyth Amice   617051 617051 Smyth, Amice, of Christchurch 0
4565371 2220737 2220737 defendant Soutere John   617051 617051 Soutere, John, of Christchurch 0
4591527 2228709 2228709 defendant Honte Walter   617051 617051 Honte, Walter, of Christchurch 1
4591534 2228712 2228712 defendant Houte Walter   617051 617051 Houte, Walter, of Christchurch 1
5005343 2358465 2358465 defendant Arundell Thomas butcher 617051 617051 Arundell, Thomas, of Christchurch, butcher 0
5156093 2402941 2402941 defendant Franke John yeoman 617051 617051 Franke, John, of Christchurch, yeoman 1
5166469 2405918 2405918 defendant Horde Henry tailor 617051 617051 Horde, Henry, of Christchurch, tailor 0
5172410 2407657 2407657 defendant Franks John yeoman 617051 617051 Franks, John, of Christchurch, yeoman 1
5198465 2415306 2415306 defendant Fychet John husbandman 617051 617051 Fychet, John, of Christchurch, husbandman 0
5207497 2417934 2417934 defendant Frank John yeoman 617051 617051 Frank, John, of Christchurch, yeoman 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);