names

62 rows where place_id = 603165

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3653668 1911411 1911411 defendant Strelley Nicholas esq 603165 603165 Strelley, Nicholas, of Lyndeby, esq 0
3653678 1911413 1911413 defendant Strelley Nicholas esq 603165 603165 Strelley, Nicholas, of Lyndeby, esq 0
3668544 1916121 1916121 defendant Strelley Nicholas gent 603165 603165 Strelley, Nicholas, of Lyndeby, gent 0
3668583 1916127 1916127 defendant Foxe John husbandman 603165 603165 Foxe, John, of Lyndeby, husbandman 0
3668609 1916131 1916131 defendant Strelley Nicholas esq 603165 603165 Strelley, Nicholas, of Lyndeby, esq 0
3668615 1916132 1916132 defendant Strelley Nicholas esq 603165 603165 Strelley, Nicholas, of Lyndeby, esq 0
3668675 1916142 1916142 defendant Meykyn John husbandman 603165 603165 Meykyn, John, of Lyndeby, husbandman 0
3668687 1916144 1916144 defendant Strelley Nicholas esq 603165 603165 Strelley, Nicholas, of Lyndeby, esq 0
3682262 1920550 1920550 plaintiff Styrley Nicholas esq 603165 603165 Styrley, Nicholas, of Lyndeby, esq 0
3682264 1920551 1920551 plaintiff Styrley Nicholas esq 603165 603165 Styrley, Nicholas, of Lyndeby, esq 0
3699171 1925953 1925953 defendant Strelley Nicholas esq 603165 603165 Strelley, Nicholas, of Lyndeby, esq 0
3699172 1925953 1925953 defendant Foxe John husbandman 603165 603165 Foxe, John, of Lyndeby, husbandman 1
3707836 1928748 1928748 defendant Strelley Nicholas gent 603165 603165 Strelley, Nicholas, of Lyndeby, gent 2
3711186 1929804 1929804 plaintiff Strelley Nicholas esq 603165 603165 Strelley, Nicholas, of Lyndeby, esq 0
3716214 1931364 1931364 defendant Styrley Nicholas esq 603165 603165 Styrley, Nicholas, of Lyndeby, esq 1
3722357 1933252 1933252 defendant Strelly Nicholas esq 603165 603165 Strelly, Nicholas, of Lyndeby, esq 2
3837842 1969750 1969750 defendant Strelley Nicholas   603165 603165 Strelley, Nicholas, of Lyndeby, knight 0
3837930 1969776 1969776 plaintiff Styrley Nicholas   603165 603165 Styrley, Nicholas, of Lyndeby, knight 0
3837933 1969777 1969777 defendant Strelley Nicholas   603165 603165 Strelley, Nicholas, of Lyndeby, knight 0
3853955 1974877 1974877 plaintiff Strelley Nicholas   603165 603165 Strelley, Nicholas, of Lyndeby, knight 0
3875489 1982044 1982044 defendant Strelley Nicholas (legal representative) 603165 603165 Strelley, Nicholas, of Lyndeby, knight, administratrix of 0
3892740 1987822 1987822 defendant Crosseley Edward yeoman 603165 603165 Crosseley, Edward, of Lyndeby, yeoman 4
3892743 1987823 1987823 defendant Crosseley Edward yeoman 603165 603165 Crosseley, Edward, of Lyndeby, yeoman 1
4451955 2185595 2185595 defendant Burton William   603165 603165 Burton, William, of Lyndeby 0
4451957 2185595 2185595 defendant Blytheworth Walter   603165 603165 Blytheworth, Walter, of Lyndeby 2
4451958 2185595 2185595 defendant Cok Thomas   603165 603165 Cok, Thomas, of Lyndeby 3
4481541 2194923 2194923 defendant Hughson Geoffrey   603165 603165 Hughson, Geoffrey, of Lyndeby 0
4599995 2231221 2231221 defendant Lane John in the   603165 603165 Lane, John in the, of Lyndeby 6
4613853 2235350 2235350 plaintiff Hunt Thomas   603165 603165 (Hunt, Thomas, of Lyndeby 1
4613858 2235351 2235351 plaintiff Hunt Thomas   603165 603165 (Hunt, Thomas, of Lyndeby 1
4613868 2235352 2235352 plaintiff Hunt Thomas   603165 603165 (Hunt, Thomas, of Lyndeby 1
4688350 2261921 2261921 defendant Smyth John smith 603165 603165 Smyth, John, of Lyndeby, smith 2
4781395 2290190 2290190 defendant Hunt John husbandman 603165 603165 Hunt, John, of Lyndeby, husbandman 1
4781396 2290190 2290190 defendant Blythworth John husbandman 603165 603165 Blythworth, John, of Lyndeby, husbandman 2
4781397 2290190 2290190 defendant Kerre Roger husbandman 603165 603165 Kerre, Roger, of Lyndeby, husbandman 3
4781398 2290190 2290190 defendant Huknall John husbandman 603165 603165 Huknall, John, of Lyndeby, husbandman 4
4872260 2318282 2318282 defendant Mason John   603165 603165 Mason, John, of Lyndeby, mason 0
5226785 2423499 2423499 plaintiff Strelley John esq 603165 603165 Strelley, John, of Lyndeby, esq 0
5240419 2427409 2427409 defendant Hypron John husbandman 603165 603165 Hypron, John, of Lyndeby, husbandman 3
5247815 2429507 2429507 defendant Strelley John esq 603165 603165 Strelley, John, of Lyndeby, esq 0
5247816 2429507 2429507 defendant Broun Robert   603165 603165 Broun, Robert, of Lyndeby, cartwright 1
5247817 2429507 2429507 defendant Guld Henry husbandman 603165 603165 Guld, Henry, of Lyndeby, husbandman 2
5247818 2429507 2429507 defendant Padley William husbandman 603165 603165 Padley, William, of Lyndeby, husbandman 3
5248383 2429660 2429660 plaintiff Strelley John esq 603165 603165 Strelley, John, of Lyndeby, esq 0
5248386 2429661 2429661 plaintiff Strelley John esq 603165 603165 Strelley, John, of Lyndeby, esq 0
5309535 2447888 2447888 defendant Penyngton James yeoman 603165 603165 Penyngton, James, of Lyndeby, yeoman 1
5309536 2447888 2447888 defendant Broun Robert   603165 603165 Broun, Robert, of Lyndeby, cart wright 2
5326563 2453027 2453027 plaintiff Strelley John esq 603165 603165 Strelley, John, of Lyndeby, esq 0
5438097 2486332 2486332 plaintiff Strelley John esq 603165 603165 Strelley, John, of Lyndeby, esq 0
5438098 2486332 2486332 defendant Herryson William yeoman 603165 603165 Herryson, William, of Lyndeby, yeoman 0
5438099 2486332 2486332 defendant Brampton Henry walker 603165 603165 Brampton, Henry, of Lyndeby, walker 1
5438100 2486332 2486332 defendant Crampton Hugh tailor 603165 603165 Crampton, Hugh, of Lyndeby, tailor 2
5452237 2490546 2490546 defendant Herryson William yeoman 603165 603165 Herryson, William, of Lyndeby, yeoman 0
5464191 2494198 2494198 plaintiff Strelley John esq 603165 603165 Strelley, John, of Lyndeby, esq 0
5464195 2494199 2494199 plaintiff Strelley John esq 603165 603165 Strelley, John, of Lyndeby, esq 0
5475742 2497741 2497741 plaintiff Strelley John esq 603165 603165 Strelley, John, of Lyndeby, esq 0
5517054 2510167 2510167 defendant Savage James esq 603165 603165 Savage, James, of Lyndeby, esq 0
5574737 2527176 2527176 defendant Gee Richard husbandman 603165 603165 Gee, Richard, of Lyndeby, husbandman 0
5574738 2527176 2527176 defendant Mosse Henry husbandman 603165 603165 Mosse, Henry, of Lyndeby, husbandman 1
5574739 2527176 2527176 defendant Waren Robert husbandman 603165 603165 Waren, Robert, of Lyndeby, husbandman 2
5574740 2527176 2527176 defendant Atkynson Robert husbandman 603165 603165 Atkynson, Robert, of Lyndeby, husbandman 3
5574741 2527176 2527176 defendant Mason Lawrence husbandman 603165 603165 Mason, Lawrence, of Lyndeby, husbandman 4

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