names

24 rows where place_id = 587590

✎ 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
3591854 1865073 1865073 defendant Broun Andrew husbandman 587590 587590 Broun, Andrew, of Est Reynham, husbandman 3
3797906 1957243 1957243 defendant Pratt William yeoman 587590 587590 Pratt, William, of Est Reynham, yeoman 0
3952464 2007930 2007930 defendant Jenyson Robert yeoman 587590 587590 Jenyson, Robert, of Est Reynham, yeoman 2
3958147 2009923 2009923 defendant Jenyson Robert yeoman 587590 587590 Jenyson, Robert, of Est Reynham, yeoman 0
4029110 2035056 2035056 defendant Jennyson Robert yeoman 587590 587590 Jennyson, Robert, of Est Reynham, yeoman 1
4097385 2059386 2059386 defendant Sturges Thomas gent 587590 587590 Sturges, Thomas, of Est Reynham, gent 0
4851895 2312027 2312027 defendant Bettham John   587590 587590 Bettham, John, of East Reynham 1
4879915 2320632 2320632 defendant Breccham John husbandman 587590 587590 Breccham, John, of Est Reynham, husbandman 1
4912814 2330505 2330505 plaintiff Champneys John clerk 587590 587590 Champneys, John, of East Reynham, clerk 0
4912815 2330505 2330505 plaintiff Marchall William   587590 587590 Marchall, William, of East Reynham 1
4983983 2352138 2352138 defendant Bekham William husbandman 587590 587590 Bekham, William, of Est Reynham, husbandman 0
4983985 2352139 2352139 defendant Bekham William husbandman 587590 587590 Bekham, William, of Est Reynham, husbandman 0
5057929 2373944 2373944 defendant Beccham John yeoman 587590 587590 Beccham, John, of Est Reynham, yeoman 0
5070858 2377778 2377778 defendant Becham John husbandman 587590 587590 Becham, John, of Est Reynham, husbandman 1
5142104 2398811 2398811 defendant Philypp John husbandman 587590 587590 Philypp, John, of East Reynham, husbandman 0
5142106 2398811 2398811 defendant Bole John husbandman 587590 587590 Bole, John, of east Reynham, husbandman 2
5189085 2412539 2412539 defendant atte Chirche John husbandman 587590 587590 atte Chirche, John, of East Reynham, husbandman 0
5266762 2435359 2435359 defendant Reve Robert   587590 587590 Reve, Robert, of Est Reynham, wool chapman 0
5499913 2504929 2504929 plaintiff Reve alias Wolvy Robert   587590 587590 Reve alias Wolvy, Robert, of Est Reynham 0
5499915 2504930 2504930 plaintiff Reve alias Wolvy Robert   587590 587590 Reve alias Wolvy, Robert, of Est Reynham 0
5504030 2506176 2506176 defendant Burgeys John yeoman 587590 587590 Burgeys, John, of Est Reynham, yeoman 0
5504031 2506176 2506176 defendant Anger or Auger Clement husbandman 587590 587590 Anger or Auger, Clement, of Est Reynham, husbandman 1
5504032 2506176 2506176 defendant Bonyour Robert husbandman 587590 587590 Bonyour, Robert, of Est Reynham, husbandman 2
5564664 2524251 2524251 plaintiff Boniour Robert   587590 587590 Boniour, Robert, of Est Reynham 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);