names

22 rows where place_id = 608692

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3674958 1918198 1918198 defendant Brickys Richard clerk 608692 608692 Brickys, Richard, of Long Compton, clerk 1
3746429 1940803 1940803 defendant Gyldon John husbandman 608692 608692 Gyldon, John, of Long Compton, husbandman 0
3746430 1940803 1940803 defendant Shepard John husbandman 608692 608692 Shepard, John, of Long Compton, husbandman 1
3759756 1945044 1945044 defendant Gyldon Henry husbandman 608692 608692 Gyldon, Henry, of Long Compton, husbandman 0
3759757 1945044 1945044 defendant Seppard John husbandman 608692 608692 Seppard, John, of Long Compton, husbandman 1
3759759 1945045 1945045 defendant Gyldon John husbandman 608692 608692 Gyldon, John, of Long Compton, husbandman 0
3759760 1945045 1945045 defendant Shepard John husbandman 608692 608692 Shepard, John, of Long Compton, husbandman 1
3956707 2009413 2009413 defendant Roche Charles yeoman 608692 608692 Roche, Charles, of Long Compton, yeoman 0
4005836 2026856 2026856 defendant Osbaston Thomas gent 608692 608692 Osbaston, Thomas, of Long Compton, gent 0
4011528 2028877 2028877 defendant Osbaston John gent 608692 608692 Osbaston, John, of Long Compton, gent 0
4225369 2104341 2104341 defendant Hewes Thomas husbandman 608692 608692 Hewes, Thomas, of Long Compton, husbandman 1
4233601 2107274 2107274 defendant Hewes Thomas husbandman 608692 608692 Hewes, Thomas, of Long Compton, husbandman 1
4307444 2132741 2132741 defendant Walker Edward husbandman 608692 608692 Walker, Edward, of Long Compton, or of Wilford Magna, Warks, husbandman 0
4307445 2132741 2132741 defendant Comedoe John husbandman 608692 608692 Comedoe, John, of Long Compton, husbandman 1
4366794 2153172 2153172 defendant Russell Richard yeoman 608692 608692 Russell, Richard, of Long Compton, yeoman 0
4578170 2224671 2224671 defendant Keyn John   608692 608692 Keyn, John, of Long Compton 1
4657009 2248082 2248082 defendant Kayn John husbandman 608692 608692 Kayn, John, of Long Compton, husbandman 1
4657064 2248103 2248103 defendant Kayn John husbandman 608692 608692 Kayn, John, of Long Compton, husbandman 1
5041547 2369073 2369073 plaintiff Cokkes Richard chaplain 608692 608692 Cokkes, Richard, of Long Compton, chaplain 0
5052260 2372283 2372283 defendant Bele William husbandman 608692 608692 Bele, William, of Long Compton, husbandman 3
5052261 2372283 2372283 defendant Bele John husbandman 608692 608692 Bele, John, of Long Compton, husbandman 4
5299191 2444742 2444742 defendant Redberd Richard husbandman 608692 608692 Redberd, Richard, of Long Compton, husbandman 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);