names

17 rows where place_id = 813619

✎ 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
4748167 2279972 2279972 defendant Bakkele Thomas   813619 813619 Bakkele, Thomas, of Spellesbury, bailiff 4
4857596 2313765 2313765 defendant Takle Thomas yeoman 813619 813619 Takle, Thomas, of Spellesbury, yeoman 0
4859890 2314464 2314464 defendant Takley Thomas yeoman 813619 813619 Takley, Thomas, of Spellesbury, yeoman 0
4864197 2315778 2315778 defendant Takkele Thomas husbandman 813619 813619 Takkele, Thomas, of Spellesbury, husbandman 2
4880991 2320967 2320967 defendant Tackele Thomas yeoman 813619 813619 Tackele, Thomas, of Spellesbury, yeoman 0
4881645 2321159 2321159 defendant Tackele Thomas yeoman 813619 813619 Tackele, Thomas, of Spellesbury, yeoman 0
4894214 2324875 2324875 defendant Takeley Thomas yeoman 813619 813619 Takeley, Thomas, of Spellesbury, yeoman 0
4944216 2340162 2340162 defendant Takley Thomas husbandman 813619 813619 Takley, Thomas, of Spellesbury, husbandman 1
4987941 2353360 2353360 defendant Claryngton Thomas husbandman 813619 813619 Claryngton, Thomas, of Spellesbury, husbandman 0
4987943 2353361 2353361 defendant Claryngton Thomas husbandman 813619 813619 Claryngton, Thomas, of Spellesbury, husbandman 0
5000300 2356964 2356964 defendant Tackeley Thomas husbandman 813619 813619 Tackeley, Thomas, of Spellesbury, husbandman 0
5462004 2493530 2493530 defendant Damary Thomas husbandman 813619 813619 Damary, Thomas, of Spellesbury, husbandman 0
5473534 2497047 2497047 defendant Damary Thomas husbandman 813619 813619 Damary, Thomas, of Spellesbury, husbandman 0
5473536 2497048 2497048 defendant Damary Thomas husbandman 813619 813619 Damary, Thomas, of Spellesbury, husbandman 0
5484960 2500425 2500425 defendant Damary Thomas husbandman 813619 813619 Damary, Thomas, of Spellesbury, husbandman 0
5484962 2500426 2500426 defendant Damary Thomas husbandman 813619 813619 Damary, Thomas, of Spellesbury, husbandman 0
5582085 2529466 2529466 defendant Nurrey John husbandman 813619 813619 Nurrey, John, of Spellesbury, husbandman 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);