names

16 rows where place_id = 628321

✎ 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
3781710 1952023 1952023 defendant Moleyns William esq 628321 628321 Moleyns, William, of Makney, Berks, esq 0
3781712 1952024 1952024 defendant Moleyns William esq 628321 628321 Moleyns, William, of Makney, Berks, esq 0
5151778 2401681 2401681 defendant Makney Henry gent 628321 628321 Makney, Henry, of Makney, Berks, gent 0
5169842 2406922 2406922 defendant Makney Henry gent 628321 628321 Makney, Henry, of Makney, Berks, gent 0
5186225 2411720 2411720 defendant Makney Henry gent 628321 628321 Makney, Henry, of Makney, Berks, gent 2
5205126 2417257 2417257 defendant Makney Henry gent 628321 628321 Makney, Henry, of Makney, Berks, gent 2
5205130 2417258 2417258 defendant Makney Henry gent 628321 628321 Makney, Henry, of Makney, Berks, gent 2
5390785 2472429 2472429 defendant Makney Henry gent 628321 628321 Makney, Henry, of Makney, Berks, gent 1
5403737 2476141 2476141 defendant Makney Henry gent 628321 628321 Makney, Henry, of Makney, Berks, gent 1
5403740 2476142 2476142 defendant Makney Henry gent 628321 628321 Makney, Henry, of Makney, Berks, gent 1
5416830 2479952 2479952 defendant Makney Henry gent 628321 628321 Makney, Henry, of Makney, Berks, gent 0
5416832 2479953 2479953 defendant Makney Henry gent 628321 628321 Makney, Henry, of Makney, Berks, gent 0
5457481 2492136 2492136 defendant Makney Henry gent 628321 628321 Makney, Henry, of Makney, Berks, gent 4
5469302 2495747 2495747 defendant Makney Henry gent 628321 628321 Makney, Henry, of Makney, Berks, gent 4
5469310 2495748 2495748 defendant Makney Henry gent 628321 628321 Makney, Henry, of Makney, Berks, gent 4
5513042 2508932 2508932 defendant Makney Henry gent 628321 628321 Makney, Henry, of Makney, Berks, gent 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);