names

22 rows where place_id = 604310

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3657600 1912639 1912639 defendant Bocher John husbandman 604310 604310 Bocher, John, of Aylton, husbandman 0
3757398 1944294 1944294 defendant Wodcok John butcher 604310 604310 Wodcok, John, of Aylton, butcher 4
3782075 1952148 1952148 defendant Gwelym Thomas husbandman 604310 604310 Gwelym, Thomas, of Aylton, husbandman 0
3899572 1990075 1990075 defendant Bruer alias Chartor William yeoman 604310 604310 Bruer alias Chartor, William, of Aylton, yeoman 0
3901158 1990614 1990614 defendant Hodgeson Henry tailor 604310 604310 Hodgeson, Henry, of Aylton, tailor 0
3940919 2003970 2003970 plaintiff Symcotes alias Sapcotes Robert esq 604310 604310 Symcotes alias Sapcotes, Robert, of Aylton, esq 0
4215716 2100994 2100994 defendant Haukyns Williams yeoman 604310 604310 Haukyns, Williams, of Aylton, yeoman 0
4353679 2148506 2148506 defendant Broughton Nicholas husbandman 604310 604310 Broughton, Nicholas, of Aylton, husbandman 1
4558832 2218723 2218723 defendant Davyes John   604310 604310 Davyes, John, of Aylton 1
4830890 2305685 2305685 plaintiff Botiller Robert   604310 604310 Botiller, Robert, of Aylton 0
4853465 2312493 2312493 defendant Messyngere John husbandman 604310 604310 Messyngere, John, of Aylton, husbandman 1
4917365 2331945 2331945 plaintiff Gambon Richard   604310 604310 Gambon, Richard, of Aylton 0
5122461 2392996 2392996 defendant Hopkyns Richard husbandman 604310 604310 Hopkyns, Richard, of Aylton, husbandman 0
5353485 2461164 2461164 defendant Huwys William yeoman 604310 604310 Huwys, William, of Aylton, yeoman 0
5391483 2472636 2472636 defendant Smyth Philip   604310 604310 Smyth, Philip, of Aylton 1
5404735 2476433 2476433 defendant Robynson Thomas husbandman 604310 604310 Robynson, Thomas, of Aylton, husbandman 3
5404885 2476473 2476473 defendant Smyth Philip   604310 604310 Smyth, Philip, of Aylton 1
5417659 2480205 2480205 defendant Robynson Thomas husbandman 604310 604310 Robynson, Thomas, of Aylton, husbandman 1
5435420 2485534 2485534 defendant Robynson Thomas husbandman 604310 604310 Robynson, Thomas, of Aylton, husbandman 1
5435422 2485535 2485535 defendant Robynson John husbandman 604310 604310 Robynson, John, of Aylton, husbandman 0
5482650 2499755 2499755 defendant Robynson Thomas husbandman 604310 604310 Robynson, Thomas, of Aylton, husbandman 1
5548271 2519527 2519527 defendant Stylys John yeoman 604310 604310 Stylys, John, of Aylton, 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);