names

20 rows where place_id = 593698

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3612997 1871712 1871712 defendant Dikson Robert laborer 593698 593698 Dikson, Robert, of Flokton, laborer 2
3941073 2004018 2004018 defendant Sykes John yeoman 593698 593698 Sykes, John, of Flokton, yeoman 0
3941965 2004323 2004323 defendant Clayton Ralph yeoman 593698 593698 Clayton, Ralph, of Flokton, yeoman 0
3941967 2004323 2004323 defendant Otes John yeoman 593698 593698 Otes, John, of Flokton, yeoman 2
4518248 2206082 2206082 defendant Jakson Robert   593698 593698 Jakson, Robert, of Flokton 0
4523133 2207566 2207566 defendant Goweyn John   593698 593698 Goweyn, John, of Flokton 2
4582046 2225822 2225822 defendant Boner or Bover Thomas   593698 593698 Boner or Bover, Thomas, of Flokton 0
4869579 2317444 2317444 defendant Tomson John husbandman 593698 593698 Tomson, John, of Flokton, husbandman 7
4899472 2326476 2326476 defendant Pylbergh William husbandman 593698 593698 Pylbergh, William, of Flokton, husbandman 0
4930805 2336036 2336036 defendant Dyghton Richard yeoman 593698 593698 Dyghton, Richard, of Flokton, yeoman 2
5005013 2358364 2358364 defendant Sykes John   593698 593698 Sykes, John, of Flokton 2
5030014 2365649 2365649 defendant Goldore Thomas nailer 593698 593698 Goldore, Thomas, of Flokton, nailer 0
5034166 2366856 2366856 defendant Pylbergh John laborer 593698 593698 Pylbergh, John, of Flokton, laborer 0
5090878 2383724 2383724 defendant Hanley or Hauley William husbandman 593698 593698 Hanley or Hauley, William, of Flokton, husbandman 0
5096235 2385336 2385336 defendant Goldour Thomas nailer 593698 593698 Goldour, Thomas, of Flokton, nailer 3
5384152 2470558 2470558 defendant Walker William laborer 593698 593698 Walker, William, of Flokton, laborer 1
5384155 2470559 2470559 defendant Walker William laborer 593698 593698 Walker, William, of Flokton, laborer 1
5395973 2473934 2473934 defendant Walker William laborer 593698 593698 Walker, William, of Flokton, laborer 1
5422748 2481757 2481757 defendant Walker William laborer 593698 593698 Walker, William, of Flokton, laborer 1
5491908 2502489 2502489 defendant Goldore edward nailer 593698 593698 Goldore, edward, of Flokton, nailer 2

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);