names

18 rows where place_id = 585877

✎ 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
3587404 1863705 1863705 defendant Sagge Thomas laborer 585877 585877 Sagge, Thomas, of Chart, laborer 2
3608424 1870294 1870294 defendant Park William, junior husbandman 585877 585877 Park, William, junior, of Chart, husbandman 2
3608428 1870295 1870295 defendant Park William husbandman 585877 585877 Park, William, of Chart, husbandman 2
3688692 1922625 1922625 defendant Morys Robert husbandman 585877 585877 Morys, Robert, of Chart, husbandman 1
3688693 1922625 1922625 defendant Baker Thomas glover 585877 585877 Baker, Thomas, of Chart, glover 2
3787956 1954026 1954026 defendant Clyfford Nicholas esq 585877 585877 Clyfford, Nicholas, of Chart, esq 0
3879023 1983235 1983235 defendant Jurden John glover 585877 585877 Jurden, John, of Chart, glover 0
4026826 2034243 2034243 plaintiff Carter George (legal representative) 585877 585877 Carter, George, of Chart, yeoman, executors of 0
4026896 2034270 2034270 plaintiff Cater George (legal representative) 585877 585877 Cater, George, of Chart, yeoman, executors of 0
4446916 2183951 2183951 defendant Melle John atte   585877 585877 Melle, John atte, of Chart 0
4641581 2243639 2243639 defendant Laurence John   585877 585877 Laurence, John, of Chart 1
4950626 2342160 2342160 defendant Hogges Stephen gent 585877 585877 Hogges, Stephen, of Chart, gent 1
5069773 2377451 2377451 defendant Clerk Simon laborer 585877 585877 Clerk, Simon, of Chart, laborer 1
5157037 2403196 2403196 defendant Munde William   585877 585877 Munde, William, of Chart 10
5352184 2460783 2460783 defendant Noreys Stephen butcher 585877 585877 Noreys, Stephen, of Chart, butcher 2
5396983 2474220 2474220 plaintiff Broker John   585877 585877 Broker, John, of Chart 0
5494503 2503242 2503242 defendant Mascall Stephen yeoman 585877 585877 Mascall, Stephen, of Chart, yeoman 2
5625163 2551809 2551809 plaintiff Lucas William   585877 585877 Lucas, William, of Chart 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);