names

31 rows where place_id = 621763

✎ 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
3743397 1939808 1939808 defendant Wylne Thomas gent 621763 621763 Wylne, Thomas, of Melburne, gent 2
3743398 1939808 1939808 defendant Teples Richard yeoman 621763 621763 Teples, Richard, of Melburne, yeoman 3
3748861 1941581 1941581 defendant Colwell Richard husbandman 621763 621763 Colwell, Richard, of Melburne, husbandman 1
3866311 1978964 1978964 defendant Tobbe Francis laborer 621763 621763 Tobbe, Francis, of Melburne, laborer 0
3946926 2005992 2005992 defendant Shepard Thomas husbandman 621763 621763 Shepard, Thomas, of Melburne, husbandman 1
3946927 2005992 2005992 defendant Colloppe Anthony laborer 621763 621763 Colloppe, Anthony, of Melburne, laborer 2
3946928 2005992 2005992 defendant Humfrey John husbandman 621763 621763 Humfrey, John, of Melburne, husbandman 3
3946929 2005992 2005992 defendant Hytche John husbandman 621763 621763 Hytche, John, of Melburne, husbandman 4
3946930 2005992 2005992 defendant Collys Hugh husbandman 621763 621763 Collys, Hugh, of Melburne, husbandman 5
3946931 2005992 2005992 defendant Hytche Robert husbandman 621763 621763 Hytche, Robert, of Melburne, husbandman 6
3946932 2005992 2005992 defendant Fanne Thomas husbandman 621763 621763 Fanne, Thomas, of Melburne, husbandman 7
3946933 2005992 2005992 defendant Johnson John laborer 621763 621763 Johnson, John, of Melburne, laborer 8
3946940 2005993 2005993 defendant Colloppe Anthony laborer 621763 621763 Colloppe, Anthony, of Melburne, laborer 1
3946941 2005993 2005993 defendant Parkyn Richard carpenter 621763 621763 Parkyn, Richard, of Melburne, carpenter 2
3946942 2005993 2005993 defendant Ilger Thomas   621763 621763 Ilger, Thomas, of Melburne, wheelwright 3
4126513 2069766 2069766 defendant Dyneley John gent 621763 621763 Dyneley, John, of Melburne, gent 0
4429440 2174013 2174013 defendant Herynge Robert   621763 621763 Herynge, Robert, of Melburne 3
4486769 2196576 2196576 defendant Skynnere Richard   621763 621763 Skynnere, Richard, of Melburne 0
4528785 2209286 2209286 defendant Cullerdowe Robert   621763 621763 Cullerdowe, Robert, of Melburne, vicar 2
4737309 2276787 2276787 defendant Leylond Richard laborer 621763 621763 Leylond, Richard, of Melburne, laborer 0
4836186 2307299 2307299 defendant Barker Thomas, sen laborer 621763 621763 Barker, Thomas, sen, of Melburne, laborer 0
4836189 2307300 2307300 defendant Barker Thomas, sen laborer 621763 621763 Barker, Thomas, sen, of Melburne, laborer 0
4910761 2329874 2329874 defendant Parsage Bernard yeoman 621763 621763 Parsage, Bernard, of Melburne, yeoman 0
4931778 2336326 2336326 defendant Thornburgh Roland gent 621763 621763 Thornburgh, Roland, of Melburne, gent 2
4952409 2342677 2342677 defendant Hornolde John husbandman 621763 621763 Hornolde, John, of Melburne, husbandman 1
5125542 2393957 2393957 defendant Taillour William chaplain 621763 621763 Taillour, William, of Melburne, chaplain 0
5445098 2488422 2488422 defendant Huchson John yeoman 621763 621763 Huchson, John, of Melburne, yeoman 0
5549304 2519845 2519845 defendant Fox John yeoman 621763 621763 Fox, John, of Melburne, yeoman 1
5569727 2525718 2525718 defendant Mogulston Edmund husbandman 621763 621763 Mogulston, Edmund, of Melburne, husbandman 0
5569728 2525718 2525718 defendant Wylleyn John gent 621763 621763 Wylleyn, John, of Melburne, gent 1
5569729 2525718 2525718 defendant Wylleyn Thomas gent 621763 621763 Wylleyn, Thomas, of Melburne, gent 2

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