names

20 rows where place_id = 893567

✎ 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
5497987 2504344 2504344 defendant Brasebrigge Baldwin gent 893567 893567 Brasebrigge, Baldwin, of Magna Barre, Alriche, gent 0
5497988 2504344 2504344 defendant Blithe Richard husbandman 893567 893567 Blithe, Richard, of Magna Barre, Alriche, husbandman 1
5497989 2504344 2504344 defendant Walter John husbandman 893567 893567 Walter, John, of Magna Barre, Alriche, husbandman 2
5497990 2504344 2504344 defendant Walter Thomas husbandman 893567 893567 Walter, Thomas, of Magna Barre, Alriche, husbandman 3
5497991 2504344 2504344 defendant Madstart John husbandman 893567 893567 Madstart, John, of Magna Barre, Alriche, husbandman 4
5497992 2504344 2504344 defendant Bilston William husbandman 893567 893567 Bilston, William, of Magna Barre, Alriche, husbandman 5
5497994 2504344 2504344 defendant Persons John husbandman 893567 893567 Persons, John, of Magna Barre, Alriche, husbandman 7
5497995 2504344 2504344 defendant Whitehed Henry husbandman 893567 893567 Whitehed, Henry, of Magna Barre, Alriche, husbandman 8
5497996 2504344 2504344 defendant Golburn Richard husbandman 893567 893567 Golburn, Richard, of Magna Barre, Alriche, husbandman 9
5497997 2504344 2504344 defendant Neweman Richard husbandman 893567 893567 Neweman, Richard, of Magna Barre, Alriche, husbandman 10
5497999 2504345 2504345 defendant Brasebrigge Baldwin gent 893567 893567 Brasebrigge, Baldwin, of Magna Barre, Alriche, gent 0
5498000 2504345 2504345 defendant Blythe Richard husbandman 893567 893567 Blythe, Richard, of Magna Barre, Alriche, husbandman 1
5498001 2504345 2504345 defendant Walker John husbandman 893567 893567 Walker, John, of Magna Barre, Alriche, husbandman 2
5498002 2504345 2504345 defendant Walter Thomas husbandman 893567 893567 Walter, Thomas, of Magna Barre, Alriche, husbandman 3
5498003 2504345 2504345 defendant Madstart John husbandman 893567 893567 Madstart, John, of Magna Barre, Alriche, husbandman 4
5498004 2504345 2504345 defendant Bylston William husbandman 893567 893567 Bylston, William, of Magna Barre, Alriche, husbandman 5
5498006 2504345 2504345 defendant Parsons John husbandman 893567 893567 Parsons, John, of Magna Barre, Alriche, husbandman 7
5498007 2504345 2504345 defendant Whitehede Henry husbandman 893567 893567 Whitehede, Henry, of Magna Barre, Alriche, husbandman 8
5498008 2504345 2504345 defendant Golburn Richard husbandman 893567 893567 Golburn, Richard, of Magna Barre, Alriche, husbandman 9
5498009 2504345 2504345 defendant Neweman Richard, junior husbandman 893567 893567 Neweman, Richard, junior, of Magna Barre, Alriche, husbandman 10

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