names

28 rows where place_id = 626001

✎ 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
3767415 1947454 1947454 defendant Wodward Thomas husbandman 626001 626001 Wodward, Thomas, of Slymbrygge, husbandman 1
3809213 1960763 1960763 defendant Knyght Thomas husbandman 626001 626001 Knyght, Thomas, of Slymbrygge, husbandman 0
3825458 1965811 1965811 defendant Wodwarde Thomas butcher 626001 626001 Wodwarde, Thomas, of Slymbrygge, butcher 0
3941372 2004123 2004123 defendant Hurd John butcher 626001 626001 Hurd, John, of Slymbrygge, butcher 0
4863300 2315488 2315488 defendant Tayllour John husbandman 626001 626001 Tayllour, John, of Slymbrygge, husbandman 2
4878368 2320182 2320182 defendant Byford John yeoman 626001 626001 Byford, John, of Slymbrygge, yeoman 0
4908258 2329134 2329134 defendant Knyght Richard husbandman 626001 626001 Knyght, Richard, of Slymbrygge, husbandman 0
4935168 2337402 2337402 defendant Byford John yeoman 626001 626001 Byford, John, of Slymbrygge, yeoman 0
4935169 2337402 2337402 defendant Bernard Richard husbandman 626001 626001 Bernard, Richard, of Slymbrygge, husbandman 1
4935170 2337402 2337402 defendant Batte Henry husbandman 626001 626001 Batte, Henry, of Slymbrygge, husbandman 2
4935171 2337402 2337402 defendant Tailloure John husbandman 626001 626001 Tailloure, John, of Slymbrygge, husbandman 3
4938802 2338526 2338526 defendant Bernam Richard husbandman 626001 626001 Bernam, Richard, of Slymbrygge, husbandman 2
4940156 2338952 2338952 defendant Barnard John, junior boatman 626001 626001 Barnard, John, junior, of Slymbrygge, boatman 0
5014179 2360997 2360997 defendant Bubwythe Thomas clerk 626001 626001 Bubwythe, Thomas, of Slymbrygge, clerk 0
5045885 2370406 2370406 defendant Man William husbandman 626001 626001 Man, William, of Slymbrygge, husbandman 0
5061398 2374995 2374995 defendant Audeley Thomas husbandman 626001 626001 Audeley, Thomas, of Slymbrygge, husbandman 0
5061411 2375000 2375000 defendant Byford John yeoman 626001 626001 Byford, John, of Slymbrygge, yeoman 0
5064623 2375960 2375960 defendant Sake John husbandman 626001 626001 Sake, John, of Slymbrygge, husbandman 0
5064624 2375960 2375960 defendant Batte Henry husbandman 626001 626001 Batte, Henry, of Slymbrygge, husbandman 1
5071532 2377981 2377981 defendant Milward William husbandman 626001 626001 Milward, William, of Slymbrygge, husbandman 1
5071535 2377982 2377982 defendant Milward William husbandman 626001 626001 Milward, William, of Slymbrygge, husbandman 1
5097282 2385636 2385636 defendant Batte Henry yeoman 626001 626001 Batte, Henry, of Slymbrygge, yeoman 1
5102367 2387100 2387100 defendant Milward William husbandman 626001 626001 Milward, William, of Slymbrygge, husbandman 10
5102383 2387100 2387100 defendant Byford John yeoman 626001 626001 Byford, John, of Slymbrygge, yeoman 26
5134376 2396551 2396551 defendant Batte Henry yeoman 626001 626001 Batte, Henry, of Slymbrygge, yeoman 2
5154271 2402406 2402406 defendant Batte Henry yeoman 626001 626001 Batte, Henry, of Slymbrygge, yeoman 2
5171393 2407358 2407358 defendant Batte Henry yeoman 626001 626001 Batte, Henry, of Slymbrygge, yeoman 1
5507748 2507323 2507323 plaintiff Dalamer John   626001 626001 Dalamer, John, of Slymbrygge 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);