names

52 rows where place_id = 602366

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3649793 1910298 1910298 defendant Calverley Walter esq 602366 602366 Calverley, Walter, of Calverley, esq 1
3708308 1928892 1928892 defendant Calverley Walter   602366 602366 Calverley, Walter, of Calverley, knight 0
3722846 1933411 1933411 defendant Calverley Walter   602366 602366 Calverley, Walter, of Calverley, knight 0
3750938 1942217 1942217 defendant Calverley Thomas gent 602366 602366 Calverley, Thomas, of Calverley, gent 0
3769652 1948165 1948165 defendant Calverley Robert gent 602366 602366 Calverley, Robert, of Calverley, gent 1
3784695 1953001 1953001 defendant Calverley Thomas gent 602366 602366 Calverley, Thomas, of Calverley, gent 0
3811191 1961396 1961396 defendant Calverley Walter   602366 602366 Calverley, Walter, of Calverley, knight 0
3811195 1961397 1961397 defendant Calverley Walter   602366 602366 Calverley, Walter, of Calverley, knight 0
3811197 1961398 1961398 defendant Pykkard William yeoman 602366 602366 Pykkard, William, of Calverley, yeoman 0
3811198 1961398 1961398 defendant Wyggesworth Christopher husbandman 602366 602366 Wyggesworth, Christopher, of Calverley, husbandman 1
3811199 1961398 1961398 defendant Thomson Edmund laborer 602366 602366 Thomson, Edmund, of Calverley, laborer 2
3811200 1961398 1961398 defendant Langfellowe Richard chaplain 602366 602366 Langfellowe, Richard, of Calverley, chaplain 3
3817494 1963382 1963382 defendant Wilson Thomas yeoman 602366 602366 Wilson, Thomas, of Calverley, yeoman 1
3817495 1963382 1963382 defendant Calverley John yeoman 602366 602366 Calverley, John, of Calverley, yeoman 2
3817496 1963382 1963382 defendant Chaloner John yeoman 602366 602366 Chaloner, John, of Calverley, yeoman 3
3817497 1963382 1963382 defendant Nussey Nicholas yeoman 602366 602366 Nussey, Nicholas, of Calverley, yeoman 4
3819007 1963836 1963836 defendant Rawdon Richard yeoman 602366 602366 Rawdon, Richard, of Calverley, yeoman 1
3849575 1973458 1973458 defendant Calverley Walter   602366 602366 Calverley, Walter, of Calverley, knight 0
3961236 2011024 2011024 defendant Byrkenshawe Wilfred laborer 602366 602366 Byrkenshawe, Wilfred, of Calverley, laborer 1
3979660 2017483 2017483 defendant Hogeson Richard clerk 602366 602366 Hogeson, Richard, of Calverley, clerk 0
4031205 2035830 2035830 defendant Calverley Ralph gent 602366 602366 Calverley, Ralph, of Calverley, gent 0
4031207 2035831 2035831 defendant Calverley Ralph gent 602366 602366 Calverley, Ralph, of Calverley, gent 0
4034150 2036876 2036876 defendant Wylkyns Walter husbandman 602366 602366 Wylkyns, Walter, of Calverley, husbandman 1
4050373 2042564 2042564 defendant Calverley Walter esq 602366 602366 Calverley, Walter, of Calverley, esq 0
4050375 2042564 2042564 defendant Taylor Thomas yeoman 602366 602366 Taylor, Thomas, of Calverley, yeoman 2
4054404 2043964 2043964 defendant Southwood William husbandman 602366 602366 Southwood, William, of Calverley, husbandman 0
4096505 2059077 2059077 defendant Wylson Stephen carpenter 602366 602366 Wylson, Stephen, of Calverley, carpenter 2
4107633 2063011 2063011 defendant Swyne George husbandman 602366 602366 Swyne, George, of Calverley, husbandman 0
4229910 2105944 2105944 defendant Webster James yeoman 602366 602366 Webster, James, of Calverley, yeoman 0
4253524 2114167 2114167 defendant Webster James yeoman 602366 602366 Webster, James, of Calverley, yeoman 0
4253525 2114167 2114167 defendant Webster William chapman 602366 602366 Webster, William, of Calverley, chapman 1
4295897 2128628 2128628 defendant Webster James yeoman 602366 602366 Webster, James, of Calverley, yeoman 0
4319416 2136897 2136897 defendant Webster James yeoman 602366 602366 Webster, James, of Calverley, yeoman 0
4322134 2137821 2137821 defendant Webster James yeoman 602366 602366 Webster, James, of Calverley, yeoman 0
4322135 2137821 2137821 defendant Webster William carrier 602366 602366 Webster, William, of Calverley, carrier 1
4349825 2147196 2147196 defendant Hare Andrew carrier 602366 602366 Hare, Andrew, of Calverley, carrier 1
4352858 2148228 2148228 defendant Webster James yeoman 602366 602366 Webster, James, of Calverley, yeoman 0
4352862 2148229 2148229 defendant Webster William yeoman 602366 602366 Webster, William, of Calverley, yeoman 0
4407185 2166966 2166966 defendant Exley Francis laborer 602366 602366 Exley, Francis, of Calverley, laborer 2
4410417 2168086 2168086 defendant Webster James carrier 602366 602366 Webster, James, of Calverley, carrier 0
4878623 2320255 2320255 defendant Bollyng Margaret widow 602366 602366 Bollyng, Margaret, of Calverley, widow 0
5013864 2360907 2360907 defendant Scoles Richard cordwainer 602366 602366 Scoles, Richard, of Calverley, cordwainer 0
5108029 2388788 2388788 defendant Calverley Walter esq 602366 602366 (Calverley, Walter, of Calverley, esq 1
5108030 2388788 2388788 defendant Calverley William esq 602366 602366 Calverley, William, of Calverley, esq 2
5108032 2388788 2388788 defendant Hollyngworth Lawrence yeoman 602366 602366 Hollyngworth, Lawrence, of Calverley, yeoman 4
5291466 2442510 2442510 defendant Calverley Robert gent 602366 602366 Calverley, Robert, of Calverley, gent 3
5291473 2442511 2442511 defendant Calverley Robert gent 602366 602366 Calverley, Robert, of Calverley, gent 3
5356124 2461993 2461993 defendant Wildsmyth John smith 602366 602366 Wildsmyth, John, of Calverley, smith 0
5556515 2521871 2521871 defendant Calverley William   602366 602366 Calverley, William, of Calverley, knight 8
5556539 2521872 2521872 defendant Calverley William   602366 602366 Calverley, William, of Calverley, knight 8
5565645 2524543 2524543 defendant Swyndon Christopher cordwainer 602366 602366 Swyndon, Christopher, of Calverley, cordwainer 4
5565646 2524543 2524543 defendant Flader William cordwainer 602366 602366 Flader, William, of Calverley, cordwainer 5

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