names

32 rows where place_id = 588885

✎ 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
3595904 1866353 1866353 defendant Cheket John husbandman 588885 588885 Cheket, John, of Ippesley, husbandman 1
3595905 1866353 1866353 defendant Cheket Thomas husbandman 588885 588885 Cheket, Thomas, of Ippesley, husbandman 2
3595908 1866354 1866354 defendant Cheket John husbandman 588885 588885 Cheket, John, of Ippesley, husbandman 1
3595909 1866354 1866354 defendant Cheket Thomas husbandman 588885 588885 Cheket, Thomas, of Ippesley, husbandman 2
3697469 1925428 1925428 defendant Steward Henry yeoman 588885 588885 Steward, Henry, of Ippesley, yeoman 0
3782650 1952315 1952315 defendant Davy William weaver 588885 588885 Davy, William, of Ippesley, weaver 0
3782651 1952315 1952315 defendant Davy Robert laborer 588885 588885 Davy, Robert, of Ippesley, laborer 1
3792426 1955494 1955494 defendant Hybbot John esq 588885 588885 Hybbot, John, of Ippesley, esq 0
3834287 1968668 1968668 defendant Homan John husbandman 588885 588885 Homan, John, of Ippesley, husbandman 1
4009310 2028094 2028094 plaintiff Nasshe Thomas   588885 588885 Nasshe, Thomas, of Ippesley 0
4035327 2037308 2037308 plaintiff Huband John   588885 588885 Huband, John, of Ippesley, knight 1
4052452 2043297 2043297 defendant Harryson Nicholas yeoman 588885 588885 Harryson, Nicholas, of Ippesley, yeoman 0
4718873 2271245 2271245 defendant Hedley John husbandman 588885 588885 Hedley, John, of Ippesley, husbandman 0
4816941 2301400 2301400 defendant Swyfte Richard husbandman 588885 588885 Swyfte, Richard, of Ippesley, husbandman 2
4876525 2319623 2319623 defendant Swyft Richard husbandman 588885 588885 Swyft, Richard, of Ippesley, husbandman 0
4920032 2332777 2332777 defendant Hore John yeoman 588885 588885 Hore, John, of Ippesley, yeoman 0
4920033 2332777 2332777 defendant Shipman Thomas husbandman 588885 588885 Shipman, Thomas, of Ippesley, husbandman 1
4966637 2346956 2346956 defendant Porter Robert yeoman 588885 588885 Porter, Robert, of Ippesley, yeoman 3
5234925 2425796 2425796 defendant Huband Thomas gent 588885 588885 Huband, Thomas, of Ippesley, gent 1
5251162 2430467 2430467 defendant Doweley Richard husbandman 588885 588885 Doweley, Richard, of Ippesley, husbandman 0
5286898 2441169 2441169 defendant Hubande William gent 588885 588885 Hubande, William, of Ippesley, gent 0
5314304 2449296 2449296 defendant Hubaude Edward gent 588885 588885 Hubaude, Edward, of Ippesley, gent 0
5390498 2472345 2472345 defendant Habande Richard gent 588885 588885 Habande, Richard, of Ippesley, gent 0
5430900 2484186 2484186 defendant Hubande Richard esq 588885 588885 Hubande, Richard, of Ippesley, esq 0
5447491 2489137 2489137 defendant Hubande Richard esq 588885 588885 Hubande, Richard, of Ippesley, esq 0
5459941 2492902 2492902 defendant Hubande Richard esq 588885 588885 Hubande, Richard, of Ippesley, esq 0
5554304 2521298 2521298 defendant Edmondes Thomas yeoman 588885 588885 Edmondes, Thomas, of Ippesley, yeoman 0
5554305 2521298 2521298 defendant Edmondes Robert yeoman 588885 588885 Edmondes, Robert, of Ippesley, yeoman 1
5566262 2524729 2524729 defendant Cheket Thomas husbandman 588885 588885 Cheket, Thomas, of Ippesley, husbandman 4
5566269 2524730 2524730 defendant Cheket Thomas husbandman 588885 588885 Cheket, Thomas, of Ippesley, husbandman 4
5573808 2526905 2526905 defendant Tayllour John tailor 588885 588885 Tayllour, John, of Ippesley, tailor 2
5573809 2526905 2526905 defendant Clerk John bagger 588885 588885 Clerk, John, of Ippesley, bagger 3

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