names

36 rows where place_id = 646012

✎ 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
3608729 1870393 1870393 defendant Everyngham John   646012 646012 Everyngham, John, of Byrkyn, knight 0
3717927 1931909 1931909 plaintiff Everyngham John   646012 646012 Everyngham, John, of Byrkyn, knight 0
3878329 1982999 1982999 defendant Everyngham Henry   646012 646012 Everyngham, Henry, of Byrkyn, knight 0
3888599 1986444 1986444 defendant Lethom Richard husbandman 646012 646012 Lethom, Richard, of Byrkyn, husbandman 0
3888600 1986444 1986444 defendant Medley John husbandman 646012 646012 Medley, John, of Byrkyn, husbandman 1
3888601 1986444 1986444 defendant Medley Thomas husbandman 646012 646012 Medley, Thomas, of Byrkyn, husbandman 2
3888602 1986444 1986444 defendant Emyngway Henry husbandman 646012 646012 Emyngway, Henry, of Byrkyn, husbandman 3
3888603 1986444 1986444 defendant Stones Christopher husbandman 646012 646012 Stones, Christopher, of Byrkyn, husbandman 4
3888605 1986445 1986445 defendant Lethom Richard husbandman 646012 646012 Lethom, Richard, of Byrkyn, husbandman 0
3888606 1986445 1986445 defendant Medley John husbandman 646012 646012 Medley, John, of Byrkyn, husbandman 1
3888607 1986445 1986445 defendant Medley Thomas husbandman 646012 646012 Medley, Thomas, of Byrkyn, husbandman 2
3888608 1986445 1986445 defendant Wellys John husbandman 646012 646012 Wellys, John, of Byrkyn, husbandman 3
3888609 1986445 1986445 defendant Leke William husbandman 646012 646012 Leke, William, of Byrkyn, husbandman 4
3888610 1986445 1986445 defendant Stonys Richard husbandman 646012 646012 Stonys, Richard, of Byrkyn, husbandman 5
3902642 1991115 1991115 defendant Lethom Richard husbandman 646012 646012 Lethom, Richard, of Byrkyn, husbandman 0
3902643 1991115 1991115 defendant Hemyngway Henry husbandman 646012 646012 Hemyngway, Henry, of Byrkyn, husbandman 1
3902644 1991115 1991115 defendant Wellys John husbandman 646012 646012 Wellys, John, of Byrkyn, husbandman 2
3902645 1991115 1991115 defendant Stones Beatrice widow 646012 646012 Stones, Beatrice, of Byrkyn, widow 3
4014189 2029801 2029801 defendant Cressey Gervase gent 646012 646012 Cressey, Gervase, of Byrkyn, gent 0
4170573 2085204 2085204 defendant Cressey Eleanor widow 646012 646012 Cressey, Eleanor, of Byrkyn, widow 0
4250655 2113202 2113202 defendant Calverley Nicholas gent 646012 646012 Calverley, Nicholas, of Byrkyn, gent 1
4320358 2137220 2137220 defendant Theckson Edward yeoman or gent 646012 646012 Theckson, Edward, of Byrkyn, yeoman or gent 3
4406350 2166689 2166689 defendant Gascoigne William esq 646012 646012 Gascoigne, William, of Byrkyn, esq 0
4406351 2166689 2166689 defendant Everingham Henry gent 646012 646012 Everingham, Henry, of Byrkyn, gent 1
4760388 2283603 2283603 defendant Botson Henry yeoman 646012 646012 Botson, Henry, of Byrkyn, yeoman 1
4813551 2300348 2300348 defendant Lilburn Philip   646012 646012 Lilburn, Philip, of Byrkyn, bailiff 0
4863237 2315476 2315476 defendant Box Agnes gentlewoman 646012 646012 Box, Agnes, of Byrkyn, gentlewoman 4
5224674 2422886 2422886 defendant Halele Robert yeoman 646012 646012 Halele, Robert, of Byrkyn, yeoman 0
5224677 2422886 2422886 defendant Everyngham William   646012 646012 together with Everyngham, William, of Byrkyn, knight 3
5289302 2441877 2441877 defendant Everyngham John esq 646012 646012 Everyngham, John, of Byrkyn, esq 0
5289304 2441877 2441877 defendant Everyngham Thomas gent 646012 646012 Everyngham, Thomas, of Byrkyn, gent 2
5289312 2441877 2441877 defendant Whipham Lawrence yeoman 646012 646012 Whipham, Lawrence, of Byrkyn, yeoman 10
5289314 2441877 2441877 defendant Holt William yeoman 646012 646012 Holt, William, of Byrkyn, yeoman 12
5341523 2457537 2457537 defendant Everyngham William (legal representative) 646012 646012 Everyngham, William, of Byrkyn, knight, administrator of 0
5589963 2531843 2531843 defendant Everyngham John   646012 646012 Everyngham, John, of Byrkyn, knight 0
5618874 2549742 2549742 defendant Everyngham William de   646012 646012 Everyngham, William de, of Byrkyn 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);