names

45 rows where place_id = 600760

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3642395 1908065 1908065 defendant Carwardyn Roger husbandman 600760 600760 Carwardyn, Roger, of Madeley, husbandman 4
3645572 1909011 1909011 defendant Lyttylford John yeoman 600760 600760 Lyttylford, John, of Madeley, yeoman 1
3645573 1909011 1909011 defendant Escope Richard husbandman 600760 600760 Escope, Richard, of Madeley, husbandman 2
3645574 1909011 1909011 defendant Escope William husbandman 600760 600760 Escope, William, of Madeley, husbandman 3
3645578 1909012 1909012 defendant Lyttylford John yeoman 600760 600760 Lyttylford, John, of Madeley, yeoman 1
3645579 1909012 1909012 defendant Esthope Richard husbandman 600760 600760 Esthope, Richard, of Madeley, husbandman 2
3645580 1909012 1909012 defendant Esthope William husbandman 600760 600760 Esthope, William, of Madeley, husbandman 3
3653768 1911438 1911438 defendant Fote Edward husbandman 600760 600760 Fote, Edward, of Madeley, husbandman 0
3668258 1916017 1916017 defendant Gough John husbandman 600760 600760 Gough, John, of Madeley, husbandman 3
3673204 1917631 1917631 defendant Frankton Edward yeoman 600760 600760 Frankton, Edward, of Madeley, yeoman 3
3673697 1917798 1917798 defendant Nyxson Richard husbandman 600760 600760 Nyxson, Richard, of Madeley, husbandman 0
3707781 1928732 1928732 defendant Rogers Richard yeoman 600760 600760 Rogers, Richard, of Madeley, yeoman 0
3855721 1975423 1975423 defendant Bromwyche Henry gent 600760 600760 Bromwyche, Henry, of Madeley, gent 3
3896154 1988918 1988918 defendant Foote Walter husbandman 600760 600760 Foote, Walter, of Madeley, husbandman 0
3900710 1990466 1990466 defendant Roles Walter husbandman 600760 600760 Roles, Walter, of Madeley, husbandman 2
3901854 1990843 1990843 defendant Rowles Walter husbandman 600760 600760 Rowles, Walter, of Madeley, husbandman 1
3913886 1994990 1994990 defendant Kempson Edmund yeoman 600760 600760 Kempson, Edmund, of Madeley, yeoman 0
3945158 2005400 2005400 defendant Flynte Thomas shoemaker 600760 600760 Flynte, Thomas, of Madeley, shoemaker 1
3945756 2005588 2005588 defendant Smythman alias Michell Richard yeoman 600760 600760 Smythman alias Michell, Richard, of Madeley, yeoman 0
4019176 2031594 2031594 defendant Offley John gent 600760 600760 Offley, John, of Madeley, gent 3
4041879 2039579 2039579 defendant Rogers John gent 600760 600760 Rogers, John, of Madeley, gent 1
4070011 2049563 2049563 defendant Dyckyn Anthony laborer 600760 600760 Dyckyn, Anthony, of Madeley, laborer 2
4214393 2100540 2100540 defendant Verdon alias Baggeley Nicholas laborer 600760 600760 Verdon alias Baggeley, Nicholas, of Madeley, laborer 1
4217890 2101747 2101747 defendant Noden Nicholas husbandman 600760 600760 Noden, Nicholas, of Madeley, husbandman 0
4217891 2101747 2101747 defendant Rogerson John husbandman 600760 600760 Rogerson, John, of Madeley, husbandman 1
4328472 2139837 2139837 defendant Steele Reginald blacksmith 600760 600760 Steele, Reginald, of Madeley, blacksmith 1
4337425 2142826 2142826 defendant Holt John yeoman 600760 600760 Holt, John, of Madeley, yeoman 0
4360694 2150994 2150994 defendant Sydwaye Robert yeoman 600760 600760 Sydwaye, Robert, of madeley, yeoman;Walton, Ralph, of Muccleston, yeoman 0
4383815 2159293 2159293 defendant Wilson Thomas bloomer 600760 600760 Wilson, Thomas, of Madeley, bloomer 1
4395068 2162935 2162935 defendant Butterton Richard butcher 600760 600760 Butterton, Richard, of Madeley, butcher 1
4422079 2171777 2171777 defendant Cachefrensh John   600760 600760 Cachefrensh, John, of Madeley 5
4562746 2219907 2219907 defendant Aleyns John   600760 600760 Aleyns, John, of Madeley 0
4562747 2219907 2219907 defendant Buldewas William   600760 600760 Buldewas, William, of Madeley 1
4565454 2220766 2220766 plaintiff Smyth Richard   600760 600760 Smyth, Richard, of Madeley 0
4587013 2227342 2227342 defendant Cleo Richard fishmonger 600760 600760 Cleo, Richard, of Madeley, son of Roger, fishmonger 0
4693360 2263426 2263426 defendant Charboney John husbandman 600760 600760 Charboney, John, of Madeley, husbandman 2
4741323 2277958 2277958 plaintiff Shepherde Roger   600760 600760 Shepherde, Roger, of Madeley 1
4796849 2295171 2295171 plaintiff Shepherd Roger   600760 600760 Shepherd, Roger, of Madeley 0
4877348 2319873 2319873 defendant Pykkyn John yeoman 600760 600760 Pykkyn, John, of Madeley, yeoman 4
4886462 2322627 2322627 plaintiff Aleyns Roger   600760 600760 Aleyns, Roger, of Madeley 0
4909354 2329465 2329465 defendant Smyth Richard husbandman 600760 600760 Smyth, Richard, of Madeley, husbandman 0
5250355 2430223 2430223 defendant Stryngare Thomas husbandman 600760 600760 Stryngare, Thomas, of Madeley, husbandman 0
5423189 2481898 2481898 defendant Bradhede John yeoman 600760 600760 Bradhede, John, of Madeley, yeoman 0
5568415 2525308 2525308 defendant Heywode Margaret widow 600760 600760 Heywode, Margaret, of Madeley, widow 2
5592281 2532571 2532571 defendant Fleynte William husbandman 600760 600760 Fleynte, William, of Madeley, 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);