names

21 rows where place_id = 758417

✎ 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
4453632 2186149 2186149 plaintiff Letmogh John   758417 758417 Letmogh, John, of Wodeburgh 0
4733902 2275787 2275787 plaintiff Rotour John   758417 758417 Rotour, John, of Wodeburgh 0
4741693 2278063 2278063 defendant Woderove William husbandman 758417 758417 Woderove, William, of Wodeburgh, husbandman 3
4771002 2286910 2286910 plaintiff Rotur John   758417 758417 Rotur, John, of Wodeburgh 0
4772957 2287513 2287513 defendant Rutter John husbandman 758417 758417 Rutter, John, of Wodeburgh, husbandman 0
4795335 2294694 2294694 defendant Orchard William husbandman 758417 758417 Orchard, William, of Wodeburgh, husbandman 0
4795811 2294841 2294841 plaintiff Rotour John   758417 758417 Rotour, John, of Wodeburgh 0
5068516 2377076 2377076 defendant Strelley Richard (legal representative) 758417 758417 Strelley, Richard, of Wodeburgh, gent, executrix of 0
5109847 2389308 2389308 plaintiff Golhall Hugh   758417 758417 Golhall, Hugh, of Wodeburgh 0
5127472 2394511 2394511 defendant Alvys William husbandman 758417 758417 Alvys, William, of Wodeburgh, husbandman 0
5146337 2400060 2400060 defendant Alvye William husbandman 758417 758417 Alvye, William, of Wodeburgh, husbandman 0
5166529 2405929 2405929 defendant Alvye William husbandman 758417 758417 Alvye, William, of Wodeburgh, husbandman 0
5181360 2410292 2410292 defendant Alvye William husbandman 758417 758417 Alvye, William, of wodeburgh, husbandman 0
5228874 2424052 2424052 defendant Strelley John gent 758417 758417 Strelley, John, of Wodeburgh, gent 0
5229671 2424298 2424298 defendant Forster Richard husbandman 758417 758417 Forster, Richard, of Wodeburgh, husbandman 0
5229672 2424298 2424298 defendant Forster Joan widow 758417 758417 Forster, Joan, of Wodeburgh, widow 1
5246298 2429077 2429077 defendant Strelley John gent 758417 758417 Strelley, John, of Wodeburgh, gent 0
5274660 2437666 2437666 defendant Strelley John esq 758417 758417 Strelley, John, of Wodeburgh, esq 0
5392367 2472901 2472901 defendant Peret Richard yeoman 758417 758417 Peret, Richard, of Wodeburgh, yeoman 2
5511179 2508335 2508335 defendant Strelley John gent 758417 758417 Strelley, John, of Wodeburgh, gent 0
5511180 2508335 2508335 defendant Strilley Robert gent 758417 758417 Strilley, Robert, of Wodeburgh, gent 1

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