names

31 rows where place_id = 595710

✎ 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
3621589 1874292 1874292 defendant Assheley Richard husbandman 595710 595710 Assheley, Richard, of Dertyngton, husbandman 1
3621590 1874292 1874292 defendant Broun Richard husbandman 595710 595710 Broun, Richard, of Dertyngton, husbandman 2
3633356 1905245 1905245 defendant Wyllyam John butcher 595710 595710 Wyllyam, John, of Dertyngton, butcher 2
3633357 1905245 1905245 defendant William William husbandman 595710 595710 William, William, of Dertyngton, husbandman 3
3663741 1914595 1914595 defendant Gibbes Thomas gent 595710 595710 Gibbes, Thomas, of Dertyngton, gent 0
3669663 1916451 1916451 defendant Shylston John   595710 595710 Shylston, John, of Dertyngton, knight 0
3669822 1916506 1916506 defendant Blakaller William husbandman 595710 595710 Blakaller, William, of Dertyngton, husbandman 1
3669823 1916506 1916506 defendant Miller Robert husbandman 595710 595710 Miller, Robert, of Dertyngton, husbandman 2
3679681 1919711 1919711 defendant Gibbes Thomas gent 595710 595710 Gibbes, Thomas, of Dertyngton, gent 0
3689969 1923022 1923022 defendant Burryn John husbandman 595710 595710 Burryn, John, of Dertyngton, husbandman 2
3695296 1924751 1924751 defendant Gybbes Thomas gent 595710 595710 Gybbes, Thomas, of Dertyngton, gent 0
3709310 1929210 1929210 defendant Hawkyn John husbandman 595710 595710 Hawkyn, John, of Dertyngton, husbandman 1
3717406 1931726 1931726 defendant Shilston John   595710 595710 Shilston, John, of Dertyngton, knight 0
3768851 1947905 1947905 defendant Toker Thomas husbandman 595710 595710 (Toker, Thomas, of Dertyngton, husbandman 1
4030622 2035612 2035612 defendant Brooke Edward miller 595710 595710 Brooke, Edward, of Dertyngton, miller 0
4737665 2276888 2276888 defendant Hoxham John husbandman 595710 595710 Hoxham, John, of Dertyngton, husbandman 1
5130030 2395268 2395268 defendant Berkeley (illegible) husbandman 595710 595710 Berkeley, ----, of Dertyngton, husbandman 1
5226178 2423323 2423323 defendant Kellegh Henry gent 595710 595710 Kellegh, Henry, of Dertyngton, gent 0
5226179 2423323 2423323 defendant Holand William   595710 595710 together with Holand, William, of Dertyngton, knight 1
5226181 2423323 2423323 defendant Appelton John yeoman 595710 595710 Appelton, John, of Dertyngton, yeoman 3
5226182 2423323 2423323 defendant Penquyte John yeoman 595710 595710 Penquyte, John, of Dertyngton, yeoman 4
5247390 2429394 2429394 defendant Kellegh Henry gent 595710 595710 Kellegh, Henry, of Dertyngton, gent 1
5264879 2434775 2434775 defendant Kellegh Henry gent 595710 595710 Kellegh, Henry, of Dertyngton, gent 0
5264881 2434776 2434776 defendant Kellegh Henry gent 595710 595710 Kellegh, Henry, of Dertyngton, gent 0
5457123 2492029 2492029 defendant Miller John carpenter 595710 595710 Miller, John, of Dertyngton, carpenter 0
5480127 2499041 2499041 defendant Broughton Thomas   595710 595710 Broughton, Thomas, of Dertyngton, knight 1
5481572 2499417 2499417 defendant Miller John carpenter 595710 595710 Miller, John, of Dertyngton, carpenter 0
5484094 2500178 2500178 defendant Jakeman John husbandman 595710 595710 Jakeman, John, of Dertyngton, husbandman 0
5485201 2500493 2500493 defendant Oter Thomas yeoman 595710 595710 Oter, Thomas, of Dertyngton, yeoman 0
5486797 2500951 2500951 defendant Bykcombe William yeoman 595710 595710 Bykcombe, William, of Dertyngton, yeoman 0
5510587 2508148 2508148 defendant Bycham John husbandman 595710 595710 Bycham, John, of Dertyngton, husbandman 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);