names

24 rows where place_id = 627541

✎ 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
3776822 1950492 1950492 plaintiff Feld Thomas, senior   627541 627541 Feld, Thomas, senior, of Fossedyk 2
3776829 1950493 1950493 plaintiff Feld Thomas, senior   627541 627541 Feld, Thomas, senior, of Fossedyk 2
3776836 1950494 1950494 plaintiff Feld Thomas, senior   627541 627541 Feld, Thomas, senior, of Fossedyk 2
3776841 1950495 1950495 plaintiff Feld Thomas, senior   627541 627541 Feld, Thomas, senior, of Fossedyk 2
4473920 2192498 2192498 defendant Delby Thomas de   627541 627541 Delby, Thomas de, of Fossedyk 0
4485222 2196082 2196082 defendant Colynson Thomas   627541 627541 Colynson, Thomas, of Fossedyk 0
4485223 2196082 2196082 defendant Stachell John   627541 627541 Stachell, John, of Fossedyk 1
4499051 2200348 2200348 defendant (illegible)     627541 627541 --- , of Fossedyk 0
4555258 2217578 2217578 defendant Welby Thomas de   627541 627541 Welby, Thomas de, of Fossedyk 0
4573115 2223128 2223128 defendant Colynson Thomas carter 627541 627541 Colynson, Thomas, of Fossedyk, carter 0
4851513 2311909 2311909 defendant Slye Richard gent 627541 627541 Slye, Richard, of Fossedyk, gent 19
4869665 2317478 2317478 defendant Welby Thomas husbandman 627541 627541 Welby, Thomas, of Fossedyk, husbandman 0
4901053 2326955 2326955 plaintiff Abram Robert (legal representative) 627541 627541 Abram, Robert, of Fossedyk, executor of 0
5037548 2367856 2367856 defendant Athelard Thomas   627541 627541 Athelard, Thomas, of Fossedyk 0
5117766 2391631 2391631 plaintiff Pulvertoft Thomas   627541 627541 Pulvertoft, Thomas, of Fossedyk 0
5389104 2471933 2471933 defendant Welby Thomas gent 627541 627541 Welby, Thomas, of Fossedyk, gent 0
5401807 2475579 2475579 defendant Welby Thomas gent 627541 627541 Welby, Thomas, of Fossedyk, gent 0
5414760 2479351 2479351 defendant Welby Thomas gent 627541 627541 Welby, Thomas, of Fossedyk, gent 0
5603269 2535907 2535907 defendant Kyrton Richard yeoman 627541 627541 Kyrton, Richard, of Fossedyk, yeoman 0
5603270 2535907 2535907 defendant Honnyng William husbandman 627541 627541 Honnyng, William, of Fossedyk, husbandman 1
5603271 2535907 2535907 defendant Felde Thomas yeoman 627541 627541 Felde, Thomas, of Fossedyk, yeoman 2
5603273 2535907 2535907 defendant Welby Thomas husbandman 627541 627541 Welby, Thomas, of Fossedyk, husbandman 4
5612327 2547600 2547600 defendant Bolman William mower 627541 627541 Bolman, William, of Fossedyk, mower 11
5619755 2550039 2550039 defendant Mardynson Pitcok Laurence   627541 627541 Mardynson Pitcok, Laurence, of Fossedyk 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);