names

31 rows where place_id = 594932

✎ 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
3618179 1873309 1873309 plaintiff Grene Richard   594932 594932 Grene, Richard, of Neuby 0
3618182 1873310 1873310 plaintiff Grene Richard esq 594932 594932 Grene, Richard, of Neuby, esq 0
3618185 1873311 1873311 plaintiff Grene Richard gent 594932 594932 Grene, Richard, of Neuby, gent 0
3618187 1873312 1873312 plaintiff Grene Richard gent 594932 594932 Grene, Richard, of Neuby, gent 0
4452700 2185855 2185855 defendant Brenhand Richard   594932 594932 Brenhand, Richard, of Neuby 0
4457927 2187500 2187500 plaintiff Pouchon John   594932 594932 Pouchon, John, of Neuby, on his own account 0
4506141 2202436 2202436 defendant Flecchere Henry   594932 594932 Flecchere, Henry, of Neuby 3
4541549 2213252 2213252 plaintiff Wryght Robert   594932 594932 Wryght, Robert, of Neuby 0
4646510 2245045 2245045 defendant Wandesford Richard   594932 594932 Wandesford, Richard, of Neuby 0
4646514 2245045 2245045 defendant Milner Thomas   594932 594932 Milner, Thomas, of Neuby 4
4657312 2248176 2248176 defendant Smale John yeoman 594932 594932 Smale, John, of Neuby, yeoman 4
4657313 2248176 2248176 defendant de Burgham Alexander yeoman 594932 594932 de Burgham, Alexander, of Neuby, yeoman 5
4669005 2256011 2256011 defendant Buktroute William gent 594932 594932 Buktroute, William, of Neuby, gent 0
4691565 2262888 2262888 defendant Grene Robert gent 594932 594932 Grene, Robert, of Neuby, gent 0
4717696 2270868 2270868 defendant Warde William   594932 594932 Warde, William, of Neuby, franklin 2
4726198 2273477 2273477 plaintiff Grene Robert   594932 594932 Grene, Robert, of Neuby 0
4776676 2288696 2288696 defendant Ward William yeoman 594932 594932 Ward, William, of Neuby, yeoman 0
4838760 2308049 2308049 plaintiff Grene John   594932 594932 Grene, John, of Neuby 0
4888326 2323153 2323153 defendant Colstan John yeoman 594932 594932 Colstan, John, of Neuby, yeoman 2
4901091 2326966 2326966 defendant Wilson John yeoman 594932 594932 Wilson, John, of Neuby, yeoman 2
4952920 2342834 2342834 defendant Warde William husbandman 594932 594932 Warde, William, of Neuby, husbandman 0
4952921 2342834 2342834 defendant Pynder William husbandman 594932 594932 Pynder, William, of Neuby, husbandman 1
4952922 2342834 2342834 defendant Pierson Robert husbandman 594932 594932 Pierson, Robert, of Neuby, husbandman 2
4952923 2342834 2342834 defendant Langlane William husbandman 594932 594932 Langlane, William, of Neuby, husbandman 3
4957176 2344105 2344105 defendant Nicolson Thomas yeoman 594932 594932 Nicolson, Thomas, of Neuby, yeoman 0
5318604 2450658 2450658 plaintiff Grene Richard gent 594932 594932 Grene, Richard, of Neuby, gent 0
5610690 2547062 2547062 defendant del Grene     594932 594932 del Grene, , of Neuby 2
5611450 2547313 2547313 defendant Marshall John   594932 594932 Marshall, John, of Neuby 0
5614671 2548386 2548386 defendant del Grene John   594932 594932 del Grene, John, of Neuby 1
5614889 2548457 2548457 defendant Robynson John   594932 594932 Robynson, John, of Neuby 2
5614904 2548458 2548458 defendant Webster John   594932 594932 Webster, John, of Neuby 13

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